Mini-Patch: Fix Web Based Ingame Mail Sending.

[Jcdacez]

I noticed, when using the Billing API for my cash shop that if an item was sent by mail
It would delete itself after 1 Minute, and the user would lose the Item.


For those who have the same problem, here is a simple fix:

In Your SQL Database, find the Stored procedure MAIL_STR Right Click it and Click "Modify".

In there, Find:

IF @iGu	= 'A1'
	BEGIN
		INSERT MAIL_TBL

Scroll down to where you see:

			VALUES 
			(
				@nMail,
				@serverindex,
				@idReceiver,
				@idSender,
				@nGold,
				@tmCreate,

Change @tmCreate, so it looks like the following:

			VALUES 
			(
				@nMail,
				@serverindex,
				@idReceiver,
				@idSender,
				@nGold,
				DATEDIFF(s, {d '1970-01-01'}, GETDATE()),

And then Exectute Your modification.

Kind of a hacky fix, but it works :)

[MentaL]