Auto in-game mail for new characters..

[nofeara]

Hello guys,

I just want to know if it is possible to make an automatic in game mail message for every new character created. Like when you write a letter to a friend and that friend receives a letter. I would like every new player created at level 1 to receive in game mails containing welcome messages such as greetings, information about the server and message redirecting to jump starts forum links and so on...

and of course how to do if it is possible...

Using MuemuS8ep3 btw.

Thanks in advance :)

[MentaL]

[KarLi]

Hey,
nice idea !

well i checked the DB tables etc and found this

T_FriendMail = emails each character gets

and at stored procedures

WZ_WriteMail

INSERT INTO T_FriendMail (MemoIndex, GUID, FriendName, wDate, Subject,bRead,  Dir,  Act) VALUES(@memocount @userguid, @SendName, getdate(), @subject, 0,  @Dir, @Act)

	if( @@error <> 0 )
	BEGIN
		SET @return = 4
		GOTO EndProcTran
	END

i dont know much SQL but if u can understand and figure out where u can update a welcome messages for each new character then ur ready to go.