Send Items Via mail from System

[Drewww]

Remember those times when you needed a GM to replace a lost item, or you crit errored entering a mini game and a GM mailed you mini game reset ticket, or you wanted something like a Mount moved from one toon to another.

Well here is a little SQL code to send mail
--------------------------
USE [ROM_ImportDB]
GO
INSERT [dbo].[ImportMail]

([WorldID], [ToName], [OrgObjID], [Count], [Durable], [ImageObjectID], [Title], [Content], [Money], [Money_Account], [Money_Bonus], [GmName]) VALUES

(1, N'Drewww', 0, 0, 0, 0, N'Welcome to RoM', N'Here, have some Gold', 100000000, 0, 0, N'System'),
(1, N'Drewww', 0, 0, 0, 0, N'Welcome to RoM', N'Here, have some Diamonds', 0, 100000, 0, N'System'),
(1, N'Drewww', 0, 0, 0, 0, N'Welcome to RoM', N'Here, have some Rubys', 0, 0, 1000, N'System'),
(1, N'Drewww', 206946, 1, 0, 206946, N'Welcome to RoM', N'Have a Rune Disk', 0, 0, 0, N'System'),
(1, N'Drewww', 202670, 1, 0, 202670, N'Welcome to RoM', N'Mount Speed Potion', 0, 0, 0, N'System'),
(1, N'Drewww', 202847, 1, 0, 202847, N'Welcome to RoM', N'Enjoy a T8', 0, 0, 0, N'System'),
(1, N'Drewww', 202847, 1, 0, 202847, N'Welcome to RoM', N'Enjoy a T8', 0, 0, 0, N'System'),
(1, N'Drewww', 202847, 1, 0, 202847, N'Welcome to RoM', N'Enjoy a T8', 0, 0, 0, N'System');

GO
-----------------------
Still working on mailing stats or stat lists or items with stats. Since I don't have access to the logview stuff I have to make do with home brew scripts. The Ability field for mail is a Varbinary(32) field I am still trying to figure out its design.

so in the above example, replace Drewww with the name of the player you want to send mail to.

 

[Turmalin]

Well done)
Also, to be clear, you can do almost same thing with usual mails, but would need to fill 2 tables instead of one for items in mails.