Jump to content
TrinityCore

[Help] PHP Market ( Send mail )


BRABUS
 Share

Recommended Posts

Hi all, im trying now to make an php custom market for buying an items in website, and i would ask for help. Which is the proper way to add/send items to player with in-game mail?

I need to add new entry in mail, mail_item, and item_instance ???

Something like that? 

$mail->insert(
 'mail',
 array(
  'messageType' => 0,
  'stationery' => 61,
  'mailTemplateId' => 0,
  'sender' => 1,
  'receiver' => 2,
  'subject' => 'Market item',
  'body' => 'You have successfully buyed an item from market!',
  'has_items' => 1,
  'checked' => 0
 ),
 array(
  '%d',
  '%d',
  '%d',
  '%d',
  '%d',
  '%s',
  '%s',
  '%d',
  '%d'
 )
);

$mail->insert(
 'mail_items',
 array(
  'mail_id' => 44,
  'item_guid' => 61, // ????
  'receiver' => 0
 ),
 array(
  '%d',
  '%d',
  '%d'
 )
);

 

Thanks.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By Lenny4
      I'm currently developping a web site to allow user to create an account and play in the game. For that I'm using soap connection, this way I can execute gm command from my website. (like bnetaccount create ...)
      I was wondering, if one day I have a lot of players and I need to limit the amount of players who can be connect in the game at the same time.
      But I want to choose (I will not choose my self I will create a php script for that) wich one can connect or not.
      So my questions are:
      - is there a way to know when a user try to connect in game, I mean a request is send to my website (or another way)? how?
                       - if yes can I avoid the connection to the game? how?
      - is there a way to disconnect a user in the game using soap command (or another way)? how? Because here https://trinitycore.atlassian.net/wiki/spaces/tc/pages/2130065/GM+Commands I can't find a command to disconnect a player
      Thank you for your help.
    • By lalalastab
      I've been trying to implement my own simple cms solution without php, but can't figure out the formatting of the SOAP requests. I was wondering if anyone was able to explain where I can find the wsdl schema? Googling only really gives results for php...
      edit2 solved after 2 days. feel free to close. code was updated with correct structure. make sure to set basic authentication headers in your request.
      <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsi="http://www.w3.org/1999/XMLSchema-instance" xmlns:xsd="http://www.w3.org/1999/XMLSchema" xmlns:ns1="urn:TC">
          <SOAP-ENV:Header>
          </SOAP-ENV:Header>
          <SOAP-ENV:Body>
               <ns1:executeCommand>
                   <command>server info</command>
               </ns1:executeCommand>
          </SOAP-ENV:Body>
      </SOAP-ENV:Envelope>
      The code is enough to get to the authorization stage but I'm not sure how to log in.
      Thanks!
    • By darki73
      So i guess it is pretty obvious about what am i going to ask =)
      Problem is, previousle we could just sha1 username and password separated by colon and here is the sha_pass_hash.
      The problem i am facing right now, is that according to https://github.com/TrinityCore/TrinityCore/blob/86b98686a95e23247ecb774fb23ecd5b8d94b97b/src/server/game/Accounts/BattlenetAccountMgr.cpp#L177 Trinity now uses SHA256, so the hashes do not match anymore. The thing is, password length in database is 40 symbols (exactly as many as in sha1 hash), but sha256 hash length is 64 characters long. I am confused...
      I've tried to recreate whole "Cryptography" thing on PHP but, guess what, failed.
      Can somebody explain me how the password is generated nowadays?
      Thank you for your attention. 
    • By damian054
      ####### English Version ########
      Hello Everyone!.
      I am requesting a script to change username in php, someone would be so kind as to contribute?.
      Thanks in advance
       
      ###### Version Español ######
      Hola a todos.
      Estoy necesitando un codigo php para cambiar el nombre de usuario, alguno podria aportarlo?
      se los agradeceria mucho. saludos!
       
      Version: TrinityCore 3.3.5a.
×
×
  • Create New...