MuMail Sending Script (PHP)

[sandbird]

-= MuMail Sending Script (PHP) =-

I was saving this for a WAP application i was writing but it seems it will never finish so here it is. With the script you can send MuMail messages to any character you want ingame, from your website.

You just fill up the form (pic1) with any "From:" you want....It can be your characters' name or your real name, it doesnt matter, it works as a regular email.

At the "To:" field fill up the Character name who will receive the message. If no user exists with this name the message will not be sent.

At the "Msg:" field you type your message (max 1000 characters)

The only difference with the real thing is that its not "live". The user must either switch subservers ingame (Lorencia -> Crywolf) for the message to appear or he must log ingame.

Setup
Open answer.php with notepad and add your server details. (user/pass/db)
Then upload scripts to your website and run mumail.php from your browser.

I've left the script simple so you can copy/paste it wherever you want in your website.

Important Note:
Works only with English characters.

[MentaL]

[Dios]

Approved. Please use [Release] tag next time.

[Shagoon]

Nice release ;)
Keep up the good work.

[sandbird]

lhdvg i know what you mean, the problem is that in order to send something to the Joinserver (like a chat) you have to send an authentication user/pass as well....it is hard to emulate that with PHP. It took me some time to get that "Already Connected" script to work. I am reading some C++ functions that were used for lotheis' programs but since then alot of things changed.

[sandbird]

hehe i am not talking about that :P In order to send something to the Joinserver or the chatserver it has to be send through "packets". You need to authenticate with the .exe through sockets and all that with PHP...Creating the C3 or C4 algorithm and send the proper packets, etc etc...i mean, its not easy stuff.
I am not talking about $session user/pass that you get from the database or simple MD5 encryption ;)
What you are talking about is joining PHP and the subservers...I wish it was that easy but its never been done before.I can barely find my way around.

[I Rule MU]

Awsome dude. Awsome job =D

[hymen]

Great work really, wonderful... Got 2 questions tho:

- Is it possible to make it send all users? And if it is, will it create any problems, such as lag, crashes or anything simillar?

- Can you change the Sender's image? For example, instead of a dark horse making it a monster or a character.

[Saint]

Nice release, im about to test it.

[Ragnaros]

nice one thx!

[sandbird]

hymen yeah its possible to send to all users, put like you said i am not sure about the load when doing that. Plus if you have a big server and some accounts are inactive, by sending a global email you'll end up filling your DB with extra bytes for no reason.
The dark horse image was a a random choice. There is value in the database that holds the "Photo" of the user sending the mail. I've played with it a bit and made "photos" of SM wearing Elf divine pants, satan, BK armor and DL boots..... I just couldnt find how that value was working. The DL horse was the only "Non united colors of Benetton" image i could make.

[sodazt]

1quesion

in GS 1.00.16 Can't sent mail

can use this to sent ? and GS Crash?

[pyrrhic]

Great Job! tnx.

[sandbird]

Sodazt, i think it will be ok to use this instead because its not using the GS to send the mail...It just inserts the entry to the DB. The GS shouldnt crash reading it....

[Damian_1993]

This scripts not work for me....I think the problem is in my apache and php.Give me link to apache and php pls.

[sandbird]

Damian_1993 did you change your error_report message in php.ini ?

Remove that easyphp. Install this : Install PHP 5 Apache MySQL on Windows : WampServer
its easy to setup and to use.
(DL: http://mirror.optus.net/sourceforge/...Server2.0b.exe)

[shark15]

For me all work Perfect! Great Job! Keep it up!

[Hacke]

if i use it it shows me ingame that i got a letter but it doesnt show me the letter oO also i get a sql error when i send the letter:

Warning: mssql_query() [function.mssql-query]: message: Der Wert NULL kann in die wDate-Spalte, MuOnline.dbo.T_FriendMail-Tabelle, nicht eingef

[Postal]

Nice work again.

[sodazt]

Thx. It work :)

how to Works with other characters.

[sandbird]

text above translated to English :

The value NULL (zero) cant be added to the wDate-column MuOnline.dbbo T_FriendMail- Table. The column doesnt accept the value Null(Zero). Error at INSERT. (severity 16) in C:\xampp\htdocs\answer.php on line 54

you know how to fix it ?

Maybe your table is not compatible to my version ?

can you show me the structure of the table T_FriendMail ?
For some reason its not accepting the date...but i need to see the way the tables look like in order to help you

Thx. It work :)

how to Works with other characters.

Other characters ? What do you mean ?

[sodazt]

other language not only for english characters.

how i can do that?

sry for my bad eng.

[sandbird]

my guess is to convert the msg string to utf8. Anyone know if i am correct or what?

[xute]

mirror: RapidShare: 1-Click Webhosting

[Hacke]

Maybe your table is not compatible to my version ?

can you show me the structure of the table T_FriendMail ?
For some reason its not accepting the date...but i need to see the way the tables look like in order to help you

The table looks like this

[sandbird]

hmmm nope its all the same i guess...
For some reason its not setting the date properly...
open answer.php with a notepad and paste

date_default_timezone_set('America/Los_Angeles');

after <?
so it should look like this:

<?
date_default_timezone_set('America/Los_Angeles');

and tell me if it works.
For sure its something wrong with your php/apache server. I would suggest to leave Xamp and move to Wamp...its 10 times better