Send mail in game whith mysql, its possible ?

[lecails]

Hi ,anyone know if its possible to send mail in game whith mysql query ?

add:Oki,maybe i found but I m bloked , what is item guid,its not item template id ?

[Darky88]

See the tables mail,mail_items and rows id and mail_id

[DasBlub]

you can't.

the table is only being loaded at startup, so you have to stop mangos, insert mails into the db and then start mangos again.

or you can search through the forum, i think there once was a patch which added another table and then from time to time loaded all mails from that table.

-- DasBlub

[Alex]

Again, this is better done via CLI. Telnet to the server CLI from PHP and do some mail commands

[arrai]

While the telnet interface is clearly a better approach than the database as IPC antipattern, it has some limitations. Currently only one user is allowed to login, which can become a problem for crowded websites. Some form of queuing is needed serverside. Another issue is the missing specification; you can hardly say if an output of a command ended or if other lines will follow, which makes automated use of the telnet interface difficult.

In order to eliminate these restrictions, I started to implement a SOAP interface. After authenticating, you will send your commands encapsulate in a SOAP request. You will either receive a success message or a SOAP fault message. Handling things with this will be far more easy, expect a fiveliner in php

It's in an early state of development, but if you're interested you might want to have a look at it:

http://github.com/arrai/mangos/commits/mangossoap