Mini-Patch: Fix Web Based Ingame Mail Sending.
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:
Code:
IF @iGu = 'A1'
BEGIN
INSERT MAIL_TBL
Scroll down to where you see:
Code:
VALUES
(
@nMail,
@serverindex,
@idReceiver,
@idSender,
@nGold,
@tmCreate,
Change @tmCreate, so it looks like the following:
Code:
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 :)