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 :)