These following examples will work if your Server and Client are running at least v6.3.1.2745 FDBs and WDBs, it could work for earlier but I am using 2745.
This uses the mail system to generate EQ with stats and runes. All dura is a flat 100, I can't seem to get it to change that yet. When you run the script in Management Studio it will send the gear to the mail queue, short time after the system will mail to the name you specify in the script.
Also the 'Tier Level' and 'Plus' is default for the EQ mailed. So you will need to Plus and Tier them yourself. Sorry for the miss aligned tabs, but when you copy and paste in to SQL Studio it should look tidy.
The following examples are for Mage, Rogue, Priest and Warden.
Rogue
Priest
Warden
Please click Like to get me a swollen head. Na.lol.. Gives me an idea of the people I help.
Looks like you guys will have to clean up the tabs and spaces yourselves. Next time I will use just spaces since the text stays aligned better here.
This uses the mail system to generate EQ with stats and runes. All dura is a flat 100, I can't seem to get it to change that yet. When you run the script in Management Studio it will send the gear to the mail queue, short time after the system will mail to the name you specify in the script.
Also the 'Tier Level' and 'Plus' is default for the EQ mailed. So you will need to Plus and Tier them yourself. Sorry for the miss aligned tabs, but when you copy and paste in to SQL Studio it should look tidy.
The following examples are for Mage, Rogue, Priest and Warden.
Code:
USE [ROM_ImportDB]
GO
DECLARE @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I] NVARCHAR(50);
SET @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I] = N'Drewww' -- < This is where you edit the name of the player to mail to >
DECLARE @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep1H BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep2H BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/822931.html"]Range[/URL][/B][/I]Wep BINARY(20);
DECLARE @Tally BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/779652.html"]Ring[/URL][/B][/I]A BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/779652.html"]Ring[/URL][/B][/I]B BINARY(20);
DECLARE @Earring1 BINARY(20);
DECLARE @Earring2 BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/354677.html"]nec[/URL][/B][/I]klace BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/1333430533.html"]Belt[/URL][/B][/I] BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/474274.html"]Pants[/URL][/B][/I] BINARY(20);
DECLARE @Gloves BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/1333419955.html"]Sho[/URL][/B][/I]ulder BINARY(20);
DECLARE @Cape BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/2000190331.html"]body[/URL][/B][/I] BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/264011.html"]boo[/URL][/B][/I]ts BINARY(20);
DECLARE @Helm BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/1333349811.html"]Wings[/URL][/B][/I] BINARY(20);
SET @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep1H = 0x000000000000000000000000345336515E51E650000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep2H = 0x000000000000000000000000345336515E51E650000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/822931.html"]Range[/URL][/B][/I]Wep = 0xD8371F378F371238FF370A2A3651D4535E51E650000000000000000000000000
SET @Tally = 0xD8371F378F371238FF370A2A3651D4535E51E650000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/779652.html"]Ring[/URL][/B][/I]A = 0xD8371F378F371238FF370A2AAC53D4536E50E452000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/779652.html"]Ring[/URL][/B][/I]B = 0xD8371F378F371238FF370A2AAC53D4536E50E452000000000000000000000000
SET @Earring1 = 0xD8371F378F371238FF370A2AAC53D4536E50E452000000000000000000000000
SET @Earring2 = 0xD8371F378F371238FF370A2AAC53D4536E50E452000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/354677.html"]nec[/URL][/B][/I]klace = 0xD8371F378F371238FF370A2AAC53D4536E50E452000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/1333430533.html"]Belt[/URL][/B][/I] = 0xD8371F378F371238FF370A2AAC53D4536E50E452000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/474274.html"]Pants[/URL][/B][/I] = 0xD8371F378F371238FF370A2AAC53D4536E50E452000000000000000000000000
SET @Gloves = 0xD8371F378F371238FF370A2AAC53D4536E50E452000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/1333419955.html"]Sho[/URL][/B][/I]ulder = 0xD8371F378F371238FF370A2AAC53D4536E50E452000000000000000000000000
SET @Cape = 0xD8371F378F371238FF370A2AAC53D4536E50E452000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/2000190331.html"]body[/URL][/B][/I] = 0xD8371F378F371238FF370A2AAC53D4536E50E452000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/264011.html"]boo[/URL][/B][/I]ts = 0xD8371F378F371238FF370A2AAC53D4536E50E452000000000000000000000000
SET @Helm = 0xD8371F378F371238FF370A2AAC53D4536E50E452000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/1333349811.html"]Wings[/URL][/B][/I] = 0xD8371F378F371238FF370A2AAC53D4536E50E452000000000000000000000000
INSERT [dbo].[ImportMail]
([WorldID], [ToName], [OrgObjID], [Count], [Durable], [ImageObjectID], [Ability], [Title], [Content], [Money], [Money_Account], [Money_Bonus], [GmName]) VALUES
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 214640, 1, 12000, 214640, @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep1H, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 214639, 1, 12000, 214639, @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep2H, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 212931, 1, 12000, 212931, @[I][B][URL="https://forum.ragezone.com/members/822931.html"]Range[/URL][/B][/I]Wep, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234068, 1, 12000, 234068, @Tally, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234053, 1, 12000, 234053, @[I][B][URL="https://forum.ragezone.com/members/779652.html"]Ring[/URL][/B][/I]A, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 232403, 1, 12000, 232403, @[I][B][URL="https://forum.ragezone.com/members/779652.html"]Ring[/URL][/B][/I]B, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234054, 1, 12000, 234054, @Earring1, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234054, 1, 12000, 234054, @Earring2, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234052, 1, 12000, 234052, @[I][B][URL="https://forum.ragezone.com/members/354677.html"]nec[/URL][/B][/I]klace, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 232401, 1, 12000, 232401, @[I][B][URL="https://forum.ragezone.com/members/1333430533.html"]Belt[/URL][/B][/I], N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 232402, 1, 12000, 232402, @[I][B][URL="https://forum.ragezone.com/members/474274.html"]Pants[/URL][/B][/I], N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 232400, 1, 12000, 232400, @Gloves, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234046, 1, 12000, 234046, @[I][B][URL="https://forum.ragezone.com/members/1333419955.html"]Sho[/URL][/B][/I]ulder, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234051, 1, 12000, 234051, @Cape, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234045, 1, 12000, 234045, @[I][B][URL="https://forum.ragezone.com/members/2000190331.html"]body[/URL][/B][/I], N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234047, 1, 12000, 234047, @[I][B][URL="https://forum.ragezone.com/members/264011.html"]boo[/URL][/B][/I]ts, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234044, 1, 12000, 234044, @Helm, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 230763, 1, 12000, 230763, @[I][B][URL="https://forum.ragezone.com/members/1333349811.html"]Wings[/URL][/B][/I], N'Welcome', N'Hi', 0, 0, 0, N'System');
GO
Rogue
Code:
USE [ROM_ImportDB]
GO
DECLARE @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I] NVARCHAR(50);
SET @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I] = N'Drewww' -- < This is where you edit the name of the player to mail to >
DECLARE @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep1H BINARY(20);
DECLARE @OffWep BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/822931.html"]Range[/URL][/B][/I]Wep BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/779652.html"]Ring[/URL][/B][/I]A BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/779652.html"]Ring[/URL][/B][/I]B BINARY(20);
DECLARE @Earring1 BINARY(20);
DECLARE @Earring2 BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/354677.html"]nec[/URL][/B][/I]klace BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/1333430533.html"]Belt[/URL][/B][/I] BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/474274.html"]Pants[/URL][/B][/I] BINARY(20);
DECLARE @Gloves BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/1333419955.html"]Sho[/URL][/B][/I]ulder BINARY(20);
DECLARE @Cape BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/2000190331.html"]body[/URL][/B][/I] BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/264011.html"]boo[/URL][/B][/I]ts BINARY(20);
DECLARE @Helm BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/1333349811.html"]Wings[/URL][/B][/I] BINARY(20);
SET @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep1H = 0x000000000000000000000000345322514A51E650000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/822931.html"]Range[/URL][/B][/I]Wep = 0x1A379C378A370C38FA37062A22514A51E853E650000000000000000000000000
SET @Offwep = 0x1A379C378A370C38FA37062A345322514A51E650000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/779652.html"]Ring[/URL][/B][/I]A = 0x1A379C378A370C38FA37062A8453C0539853E853000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/779652.html"]Ring[/URL][/B][/I]B = 0x1A379C378A370C38FA37062A8453C0539853E853000000000000000000000000
SET @Earring1 = 0x1A379C378A370C38FA37062A8453C0539853E853000000000000000000000000
SET @Earring2 = 0x1A379C378A370C38FA37062A8453C0539853E853000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/354677.html"]nec[/URL][/B][/I]klace = 0x1A379C378A370C38FA37062A8453C0539853E853000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/1333430533.html"]Belt[/URL][/B][/I] = 0x1A379C378A370C38FA37062A8453C0539853E853000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/474274.html"]Pants[/URL][/B][/I] = 0x1A379C378A370C38FA37062A8453C0539853E853000000000000000000000000
SET @Gloves = 0x1A379C378A370C38FA37062A8453C0539853E853000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/1333419955.html"]Sho[/URL][/B][/I]ulder = 0x1A379C378A370C38FA37062A8453C0539853E853000000000000000000000000
SET @Cape = 0x1A379C378A370C38FA37062A8453C0539853E853000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/2000190331.html"]body[/URL][/B][/I] = 0x1A379C378A370C38FA37062A8453C0539853E853000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/264011.html"]boo[/URL][/B][/I]ts = 0x1A379C378A370C38FA37062A8453C0539853E853000000000000000000000000
SET @Helm = 0x1A379C378A370C38FA37062A8453C0539853E853000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/1333349811.html"]Wings[/URL][/B][/I] = 0x1A379C378A370C38FA37062A8453C0539853E853000000000000000000000000
INSERT [dbo].[ImportMail]
([WorldID], [ToName], [OrgObjID], [Count], [Durable], [ImageObjectID], [Ability], [Title], [Content], [Money], [Money_Account], [Money_Bonus], [GmName]) VALUES
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 214638, 1, 12000, 214638, @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep1H, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 214637, 1, 12000, 214637, @[I][B][URL="https://forum.ragezone.com/members/822931.html"]Range[/URL][/B][/I]Wep, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 214638, 1, 12000, 214638, @Offwep, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234043, 1, 12000, 234043, @[I][B][URL="https://forum.ragezone.com/members/779652.html"]Ring[/URL][/B][/I]A, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234043, 1, 12000, 234043, @[I][B][URL="https://forum.ragezone.com/members/779652.html"]Ring[/URL][/B][/I]B, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234042, 1, 12000, 234042, @Earring1, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234042, 1, 12000, 234042, @Earring2, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234041, 1, 12000, 234041, @[I][B][URL="https://forum.ragezone.com/members/354677.html"]nec[/URL][/B][/I]klace, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234038, 1, 12000, 234038, @[I][B][URL="https://forum.ragezone.com/members/1333430533.html"]Belt[/URL][/B][/I], N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234039, 1, 12000, 234039, @[I][B][URL="https://forum.ragezone.com/members/474274.html"]Pants[/URL][/B][/I], N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234037, 1, 12000, 234037, @Gloves, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234035, 1, 12000, 234035, @[I][B][URL="https://forum.ragezone.com/members/1333419955.html"]Sho[/URL][/B][/I]ulder, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234040, 1, 12000, 234040, @Cape, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234034, 1, 12000, 234034, @[I][B][URL="https://forum.ragezone.com/members/2000190331.html"]body[/URL][/B][/I], N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234036, 1, 12000, 234036, @[I][B][URL="https://forum.ragezone.com/members/264011.html"]boo[/URL][/B][/I]ts, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234033, 1, 12000, 234033, @Helm, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 230764, 1, 12000, 230764, @[I][B][URL="https://forum.ragezone.com/members/1333349811.html"]Wings[/URL][/B][/I], N'Welcome', N'Hi', 0, 0, 0, N'System');
GO
Priest
Code:
USE [ROM_ImportDB]
GO
DECLARE @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I] NVARCHAR(50);
SET @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I] = N'Drewww' -- < This is where you edit the name of the player to mail to >
DECLARE @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep1H BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep2H BINARY(20);
DECLARE @OffWep BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/822931.html"]Range[/URL][/B][/I]Wep BINARY(20);
DECLARE @Tally BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/173438.html"]Shield[/URL][/B][/I] BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/779652.html"]Ring[/URL][/B][/I]A BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/779652.html"]Ring[/URL][/B][/I]B BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/1333430533.html"]Belt[/URL][/B][/I] BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/474274.html"]Pants[/URL][/B][/I] BINARY(20);
DECLARE @Gloves BINARY(20);
DECLARE @Earring1 BINARY(20);
DECLARE @Earring2 BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/779652.html"]Ring[/URL][/B][/I] BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/354677.html"]nec[/URL][/B][/I]klace BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/1333349811.html"]Wings[/URL][/B][/I] BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/1333419955.html"]Sho[/URL][/B][/I]ulder BINARY(20);
DECLARE @Cape BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/2000190331.html"]body[/URL][/B][/I] BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/264011.html"]boo[/URL][/B][/I]ts BINARY(20);
DECLARE @Helm BINARY(20);
SET @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep1H = 0x5837C8378D37FD370E2A0D2A485336515E51E650000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep2H = 0x5837C8378D37FD370E2A0D2A485336515E51E650000000000000000000000000
SET @OffWep = 0x5837C8378D37FD370E2A0D2A485336515E51E650000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/822931.html"]Range[/URL][/B][/I]Wep = 0x5837C8378D37FD370E2A0D2A36515E51E6507053000000000000000000000000
SET @Tally = 0x5837C8378D37FD370E2A0D2A485336515E51E650000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/173438.html"]Shield[/URL][/B][/I] = 0x5837C8378D37FD370E2A0D2A8453BE500C537053000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/779652.html"]Ring[/URL][/B][/I]A = 0x5837C8378D37FD370E2A0D2A0A50BE500C537053000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/779652.html"]Ring[/URL][/B][/I]B = 0x5837C8378D37FD370E2A0D2A0A50BE500C537053000000000000000000000000
SET @Earring1 = 0x5837C8378D37FD370E2A0D2A0A50BE500C537053000000000000000000000000
SET @Earring2 = 0x5837C8378D37FD370E2A0D2A0A50BE500C537053000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/354677.html"]nec[/URL][/B][/I]klace = 0x5837C8378D37FD370E2A0D2A0A50BE500C537053000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/1333430533.html"]Belt[/URL][/B][/I] = 0x5837C8378D37FD370E2A0D2A8453BE500C537053000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/474274.html"]Pants[/URL][/B][/I] = 0x5837C8378D37FD370E2A0D2A8453BE500C537053000000000000000000000000
SET @Gloves = 0x5837C8378D37FD370E2A0D2A8453BE500C537053000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/1333419955.html"]Sho[/URL][/B][/I]ulder = 0x5837C8378D37FD370E2A0D2A8453BE500C537053000000000000000000000000
SET @Cape = 0x5837C8378D37FD370E2A0D2A8453BE500C537053000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/2000190331.html"]body[/URL][/B][/I] = 0x5837C8378D37FD370E2A0D2A8453BE500C537053000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/264011.html"]boo[/URL][/B][/I]ts = 0x5837C8378D37FD370E2A0D2A8453BE500C537053000000000000000000000000
SET @Helm = 0x5837C8378D37FD370E2A0D2A8453BE500C537053000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/1333349811.html"]Wings[/URL][/B][/I] = 0x5837C8378D37FD370E2A0D2A8453BE500C537053000000000000000000000000
INSERT [dbo].[ImportMail]
([WorldID], [ToName], [OrgObjID], [Count], [Durable], [ImageObjectID], [Ability], [Title], [Content], [Money], [Money_Account], [Money_Bonus], [GmName]) VALUES
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 214642, 1, 120000, 214642, @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep1H, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 214641, 1, 120000, 214641, @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep2H, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 214340, 1, 120000, 214340, @[I][B][URL="https://forum.ragezone.com/members/822931.html"]Range[/URL][/B][/I]Wep, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234069, 1, 120000, 234069, @Tally, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234067, 1, 120000, 234067, @[I][B][URL="https://forum.ragezone.com/members/173438.html"]Shield[/URL][/B][/I], N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 214460, 1, 120000, 214460, @Offwep, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234064, 1, 120000, 234064, @[I][B][URL="https://forum.ragezone.com/members/779652.html"]Ring[/URL][/B][/I]A, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234064, 1, 120000, 234064, @[I][B][URL="https://forum.ragezone.com/members/779652.html"]Ring[/URL][/B][/I]B, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234065, 1, 120000, 234065, @Earring1, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234065, 1, 120000, 234065, @Earring2, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234063, 1, 120000, 234063, @[I][B][URL="https://forum.ragezone.com/members/354677.html"]nec[/URL][/B][/I]klace, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234060, 1, 120000, 234060, @[I][B][URL="https://forum.ragezone.com/members/1333430533.html"]Belt[/URL][/B][/I], N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234061, 1, 120000, 234061, @[I][B][URL="https://forum.ragezone.com/members/474274.html"]Pants[/URL][/B][/I], N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234059, 1, 120000, 234059, @Gloves, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234057, 1, 120000, 234057, @[I][B][URL="https://forum.ragezone.com/members/1333419955.html"]Sho[/URL][/B][/I]ulder, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234062, 1, 120000, 234062, @Cape, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234056, 1, 120000, 234056, @[I][B][URL="https://forum.ragezone.com/members/2000190331.html"]body[/URL][/B][/I], N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234058, 1, 120000, 234058, @[I][B][URL="https://forum.ragezone.com/members/264011.html"]boo[/URL][/B][/I]ts, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234055, 1, 120000, 234055, @Helm, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 230763, 1, 120000, 230763, @[I][B][URL="https://forum.ragezone.com/members/1333349811.html"]Wings[/URL][/B][/I], N'Welcome', N'Hi', 0, 0, 0, N'System');
GO
Warden
Code:
USE [ROM_ImportDB]
GO
DECLARE @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I] NVARCHAR(50);
SET @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I] = N'Drewww' -- < This is where you edit the name of the player to mail to >
DECLARE @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/822931.html"]Range[/URL][/B][/I]Wep BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/779652.html"]Ring[/URL][/B][/I]A BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/779652.html"]Ring[/URL][/B][/I]B BINARY(20);
DECLARE @Earring1 BINARY(20);
DECLARE @Earring2 BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/354677.html"]nec[/URL][/B][/I]klace BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/1333430533.html"]Belt[/URL][/B][/I] BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/474274.html"]Pants[/URL][/B][/I] BINARY(20);
DECLARE @Gloves BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/1333419955.html"]Sho[/URL][/B][/I]ulder BINARY(20);
DECLARE @Cape BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/2000190331.html"]body[/URL][/B][/I] BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/264011.html"]boo[/URL][/B][/I]ts BINARY(20);
DECLARE @Helm BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/1333349811.html"]Wings[/URL][/B][/I] BINARY(20);
SET @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep = 0x000000000000000000000000345322514A51D250000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/822931.html"]Range[/URL][/B][/I]Wep = 0x00000000000000000000000022514A51E853E650000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/779652.html"]Ring[/URL][/B][/I]A = 0x9737193789370738F937052A8453C0539853E853000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/779652.html"]Ring[/URL][/B][/I]B = 0x9737193789370738F937052A8453C0539853E853000000000000000000000000
SET @Earring1 = 0x9737193789370738F937052A8453C0539853E853000000000000000000000000
SET @Earring2 = 0x9737193789370738F937052A8453C0539853E853000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/354677.html"]nec[/URL][/B][/I]klace = 0x9737193789370738F937052A8453C0539853E853000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/1333430533.html"]Belt[/URL][/B][/I] = 0x9737193789370738F937052A8453C0539853E853000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/474274.html"]Pants[/URL][/B][/I] = 0x9737193789370738F937052A8453C0539853E853000000000000000000000000
SET @Gloves = 0x9737193789370738F937052A8453C0539853E853000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/1333349811.html"]Wings[/URL][/B][/I] = 0x9737193789370738F937052A8453C0539853E853000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/1333419955.html"]Sho[/URL][/B][/I]ulder = 0x9737193789370738F937052A8453C0539853E853000000000000000000000000
SET @Cape = 0x9737193789370738F937052A8453C0539853E853000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/2000190331.html"]body[/URL][/B][/I] = 0x9737193789370738F937052A8453C0539853E853000000000000000000000000
SET @[I][B][URL="https://forum.ragezone.com/members/264011.html"]boo[/URL][/B][/I]ts = 0x9737193789370738F937052A8453C0539853E853000000000000000000000000
SET @Helm = 0x9737193789370738F937052A8453C0539853E853000000000000000000000000
INSERT [dbo].[ImportMail]
([WorldID], [ToName], [OrgObjID], [Count], [Durable], [ImageObjectID], [Ability], [Title], [Content], [Money], [Money_Account], [Money_Bonus], [GmName]) VALUES
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 214632, 1, 12000, 214632, @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 214637, 1, 12000, 214637, @[I][B][URL="https://forum.ragezone.com/members/822931.html"]Range[/URL][/B][/I]Wep, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 232391, 1, 12000, 232391, @[I][B][URL="https://forum.ragezone.com/members/779652.html"]Ring[/URL][/B][/I]A, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234031, 1, 12000, 234031, @[I][B][URL="https://forum.ragezone.com/members/779652.html"]Ring[/URL][/B][/I]B, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234032, 1, 12000, 234032, @Earring1, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234032, 1, 12000, 234032, @Earring2, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234030, 1, 12000, 234030, @[I][B][URL="https://forum.ragezone.com/members/354677.html"]nec[/URL][/B][/I]klace, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 232389, 1, 12000, 232389, @[I][B][URL="https://forum.ragezone.com/members/1333430533.html"]Belt[/URL][/B][/I], N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 232390, 1, 12000, 232390, @[I][B][URL="https://forum.ragezone.com/members/474274.html"]Pants[/URL][/B][/I], N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 232388, 1, 12000, 232388, @Gloves, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234024, 1, 12000, 234024, @[I][B][URL="https://forum.ragezone.com/members/1333419955.html"]Sho[/URL][/B][/I]ulder, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234029, 1, 12000, 234029, @Cape, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234023, 1, 12000, 234023, @[I][B][URL="https://forum.ragezone.com/members/2000190331.html"]body[/URL][/B][/I], N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234025, 1, 12000, 234025, @[I][B][URL="https://forum.ragezone.com/members/264011.html"]boo[/URL][/B][/I]ts, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 234022, 1, 12000, 234022, @Helm, N'Welcome', N'Hi', 0, 0, 0, N'System'),
(1, @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 224985, 1, 12000, 224985, @[I][B][URL="https://forum.ragezone.com/members/1333349811.html"]Wings[/URL][/B][/I], N'Welcome', N'Hi', 0, 0, 0, N'System');
GO
Please click Like to get me a swollen head. Na.lol.. Gives me an idea of the people I help.
Looks like you guys will have to clean up the tabs and spaces yourselves. Next time I will use just spaces since the text stays aligned better here.