Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

SQL Script to mail full EQ sets

D

Drewww

Junior Spellweaver
Joined
Apr 27, 2015
Messages
176
Reaction score
107
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.

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.
 
The Best DDoS Protected Servers
D

Drewww

Junior Spellweaver
Joined
Apr 27, 2015
Messages
176
Reaction score
107
Ok, so a week+ has past, and I finally worked out the part with mailing items with a user defined Dura Value from 0-255, Hammer Dura level 0-255, Tier level, Plus Level, Rune Slots and Power Level Ranks. Took a few days. Once I get time to jaz up some sql code that will make user input easy without someone needing to learn binary, decimal, signed and unsigned binary and the rest, i will put it up.
But for now you can drop then [Durable] column and replace it with [ExValue], then in it's column you can put the number 30840 you will then be mailing out gear with 120/120 dura.
Have fun with it.
 
D

Drewww

Junior Spellweaver
Joined
Apr 27, 2015
Messages
176
Reaction score
107
Back again with Revision 2 of an SQL Script to mail to a player EQ based on Str/PA.
This revision will allow you to modify figures for :
Dura
Tier
Plus
Rune Slots
Power
As you will see the size of the script has grown rather large, mostly cause I am not using functions, just a flowing script.
Maybe someone with PHP+SQL+HTML skills can make this in to Webpage similar to RAtools/LogViewer. I am currently
working on this myself but learning at a slow pace.

Well have fun with this, and ppl please post back to the forums with stuff yo learn, even if it small or seems meaningless,
the more info we have the better it can be for us all.

Code: 
code removed due to bad copy/paste issues.
Look further down for working code.
 
Last edited:
S

SuperFrogster

Newbie Spellweaver
Joined
Apr 17, 2013
Messages
46
Reaction score
13
Thank you for scripts and great ideas.

Can you write explanation how you form ExValue number?
 
D

Drewww

Junior Spellweaver
Joined
Apr 27, 2015
Messages
176
Reaction score
107
32 bit signed binary made up of 6 fields which cover all but the item id and stats.
 
D

Drewww

Junior Spellweaver
Joined
Apr 27, 2015
Messages
176
Reaction score
107
Thanks to SuperFrogster I see a problem with the last code I put in, this forum is removing some codes from the SQL example i posted. Some codes pasted in these forums needs spaces before and after ( ) and some @ codes
So I have done that and tested this latest code and it will execute without problems.

The Stat list on the gear is based on version 6.4 FDBs
Bones, Spirits, Crypt, Eons.

Code: 
/*
Use this Webpage: http://www.binaryconvert.com/result_signed_int.html?hexadecimal=14137878 To convert the Binary String to Signed INT
Use this Webpage: http://www.binaryhexconverter.com/decimal-to-binary-converter to convert Decimal to Binary
*/
---------------------------------------------------------------------------------
------------------------------ Strength Based Gear ------------------------------
------------------------ Warden and Champ and Warrior EQ ------------------------
------------------------ Warden/Warrior or Rogue or Scout -----------------------
------------------------ Champ/Rogue --------------------------------------------
------------------------ Warrior/Warden or Rogue --------------------------------
---------------------------------------------------------------------------------


/*
   Please give back to this community, submit something to the forum that you
   learn or make or design which others can benifit from. Don't just Take Take.
   The community needs Programmers to make tools or scripts to make it
   easier to manage our Test Servers
   People my be willing to share new Files if you put some effort back in to
   showing that you deserve it.
   This code you have now has taken months of work and many sleepless nights to
   learn and design, it is not purfect but works as intended, I submit it as free
   to return thanks to the community for making the current server files avilable
   If you have new Bin's/Lua's/Database files please share with me.
*/
   
USE [ROM_ImportDB]
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 >


---------------------------------------------------------------------------------
--------- Here you define the Value Attributes for the EQ being mailed ----------
------------ Exceeding the range will produce non game spec results -------------
---------------------------------------------------------------------------------
DECLARE @EQMainDura     int; SET @EQMainDura  = 200; -- Range 0-200 (Can go to 255, but odd results can happen)
DECLARE @EQPlus         int; SET @EQPlus      = 20;  -- Range 0-20 (Above 20 can add strange ghost figures)
DECLARE @EQRareity      int; SET @EQRareity   = 0;   -- Range 0-7 (keep as 0 unless you want non standard Power Rankings, IE: Purple,Brown,Blue,Red)
DECLARE @EQTier         int; SET @EQTier      = 9;   -- Range 1-20
DECLARE @EQWepTier      int; SET @EQWepTier   = 13;  -- Range 1-20
DECLARE @EQRuneSlots    int; SET @EQRuneSlots = 0;   -- Range 0-4 (WARNING: Use 0 if EQ has runes embeded: Use 0-4 if it has no runes)
DECLARE @EQBaseTier     int; SET @EQBaseTier  = 5;   -- Check the base Tier of your item in game, if it is T4 then change make @EQBaseTier = 4
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------


DECLARE @EQDurable      int; SET @EQDurable   = @EQMainDura * 100;
DECLARE @EQBinaryString VARCHAR(32); SET @EQBinaryString = '';
DECLARE @EQWepBinString VARCHAR(32); SET @EQWepBinString = '';


----- This Adds the EQ's Base Tier to your Desired Tier -----
set @EQTier    = @EQTier    + @EQBaseTier;
set @EQWepTier = @EQWepTier + @EQBaseTier;
-------------------------------------------------------------


------------------- EQMainDura String -----------------------
declare @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]value int;
set     @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]value = @EQMainDura;


declare @vsresult1 varchar(8);
declare @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]i      int;
select  @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]i      = 8, @vsresult1 = '';


while   @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]i > 0
        begin
                select @vsresult1= convert ( char ( 1 ), @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]value % 2 )+@vsresult1;
                select @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]value = convert ( int, ( @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]value / 2 ) ), @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]i  =  @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]i -1;
        end
-------------------------------------------------------------


--------------------- EQPlus String -------------------------
set     @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]value  = @EQPlus;
declare @vsresult3 varchar(5);


select  @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]i      = 5, @vsresult3 = '';


while   @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]i > 0
        begin
                select @vsresult3= convert ( char ( 1 ), @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]value % 2 )+@vsresult3
                select @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]value = convert ( int, ( @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]value / 2 ) ), @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]i  =  @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]i - 1
        end
-------------------------------------------------------------


-------------------- EQRareity String -----------------------
set     @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]value  = @EQRareity;
declare @vsresult4 varchar(3);


select  @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]i      = 3, @vsresult4 = '';


while   @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]i > 0
        begin
                select @vsresult4= convert ( char ( 1 ), @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]value % 2 )+@vsresult4;
                select @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]value = convert ( int, ( @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]value / 2 ) ), @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]i  =  @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]i - 1;
        end
-------------------------------------------------------------


--------------------- EQTier String -------------------------
set     @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]value  = @EQTier;
declare @vsresult5 varchar(5);


select  @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]i      = 5, @vsresult5 = '';


while   @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]i > 0
        begin
                select @vsresult5= convert ( char ( 1 ), @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]value % 2 )+@vsresult5;
                select @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]value = convert ( int, ( @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]value / 2 ) ), @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]i  =  @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]i - 1;
        end
-------------------------------------------------------------


------------------- EQWepTier String ------------------------
set     @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]value  = @EQWepTier;
declare @vsresult7 varchar(5);


select  @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]i      = 5, @vsresult7 = '';


while   @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]i > 0
        begin
                select @vsresult7= convert ( char ( 1 ), @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]value % 2 )+@vsresult7;
                select @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]value = convert ( int, ( @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]value / 2 ) ), @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]i  =  @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]i - 1;
        end
-------------------------------------------------------------


------------------- EQRuneSlots String ----------------------
set     @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]value  = @EQRuneSlots;
declare @vsresult6 varchar(3);


select  @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]i      = 3, @vsresult6 = '';


while   @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]i > 0
        begin
                select @vsresult6= convert ( char ( 1 ), @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]value % 2 )+@vsresult6;
                select @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]value = convert ( int, ( @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]value / 2 ) ), @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]i  =  @[I][B][URL="https://forum.ragezone.com/members/874269.html"]Int[/URL][/B][/I]i - 1;
        end
-------------------------------------------------------------
set @EQBinaryString = @EQBinaryString + @vsresult6 + @vsresult3 + @vsresult4 + @vsresult5 + @vsresult1 + @vsresult1;
set @EQWepBinString = @EQWepBinString + @vsresult6 + @vsresult3 + @vsresult4 + @vsresult7 + @vsresult1 + @vsresult1;
------------ Convert EQBinary String to Decimal -------------
DECLARE @EQBinary    VARCHAR(100);
DECLARE @EQWepBinary VARCHAR(100);
SET     @EQBinary    = @EQBinaryString;
SET     @EQWepBinary = @EQWepBinString;
DECLARE @[I][B][URL="https://forum.ragezone.com/members/1333352388.html"]Character[/URL][/B][/I]s CHAR(36),
        @eqresult BIGINT,
        @wepresult BIGINT,
        @[I][B][URL="https://forum.ragezone.com/members/1333459381.html"]Index[/URL][/B][/I] SMALLINT,
        @[I][B][URL="https://forum.ragezone.com/members/643985.html"]BaSe[/URL][/B][/I] BIGINT;
SET     @[I][B][URL="https://forum.ragezone.com/members/1333352388.html"]Character[/URL][/B][/I]s = '0123456789abcdefghijklmnopqrstuvwxyz';
SET     @eqresult = 0;
SET     @[I][B][URL="https://forum.ragezone.com/members/1333459381.html"]Index[/URL][/B][/I] = 0;
SET     @[I][B][URL="https://forum.ragezone.com/members/643985.html"]BaSe[/URL][/B][/I] = 2;
WHILE   @[I][B][URL="https://forum.ragezone.com/members/1333459381.html"]Index[/URL][/B][/I] < LEN(@EQBinary)
        BEGIN
                SELECT @eqresult = @eqresult + POWER ( @[I][B][URL="https://forum.ragezone.com/members/643985.html"]BaSe[/URL][/B][/I], @[I][B][URL="https://forum.ragezone.com/members/1333459381.html"]Index[/URL][/B][/I] ) * ( CHARINDEX ( SUBSTRING ( @EQBinary, LEN ( @EQBinary ) - @[I][B][URL="https://forum.ragezone.com/members/1333459381.html"]Index[/URL][/B][/I], 1 ), @[I][B][URL="https://forum.ragezone.com/members/1333352388.html"]Character[/URL][/B][/I]s ) - 1);
                SET @[I][B][URL="https://forum.ragezone.com/members/1333459381.html"]Index[/URL][/B][/I] = @[I][B][URL="https://forum.ragezone.com/members/1333459381.html"]Index[/URL][/B][/I] + 1;
        END
SET     @[I][B][URL="https://forum.ragezone.com/members/1333352388.html"]Character[/URL][/B][/I]s = '0123456789abcdefghijklmnopqrstuvwxyz';
SET     @wepresult = 0;
SET     @[I][B][URL="https://forum.ragezone.com/members/1333459381.html"]Index[/URL][/B][/I] = 0;
SET     @[I][B][URL="https://forum.ragezone.com/members/643985.html"]BaSe[/URL][/B][/I] = 2;
WHILE   @[I][B][URL="https://forum.ragezone.com/members/1333459381.html"]Index[/URL][/B][/I] < LEN(@EQWepBinary)
        BEGIN
                SELECT @wepresult = @wepresult + POWER ( @[I][B][URL="https://forum.ragezone.com/members/643985.html"]BaSe[/URL][/B][/I], @[I][B][URL="https://forum.ragezone.com/members/1333459381.html"]Index[/URL][/B][/I] ) * ( CHARINDEX ( SUBSTRING ( @EQWepBinary, LEN ( @EQWepBinary ) - @[I][B][URL="https://forum.ragezone.com/members/1333459381.html"]Index[/URL][/B][/I], 1 ), @[I][B][URL="https://forum.ragezone.com/members/1333352388.html"]Character[/URL][/B][/I]s ) - 1);
                SET @[I][B][URL="https://forum.ragezone.com/members/1333459381.html"]Index[/URL][/B][/I] = @[I][B][URL="https://forum.ragezone.com/members/1333459381.html"]Index[/URL][/B][/I] + 1;
        END
DECLARE @EQExValue  INT;
DECLARE @WEPExValue INT;
IF      @eqresult > 2147483647
        BEGIN
                SET @eqresult = @eqresult - (2147483648 * 2);
        END
IF      @wepresult > 2147483647
        BEGIN
                SET @wepresult = @wepresult - (2147483648 * 2);
        END
SET     @EQExValue  = @eqresult;
SET     @WEPExValue = @wepresult;
-------------------------------------------------------------


DECLARE @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep1 BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep2 BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep3 BINARY(20);
DECLARE @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep4 BINARY(20);
DECLARE @OffWep1  BINARY(20);
DECLARE @OffWep2  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);


-- Stats are here     [    6 Embeded Stats   ]
-- Runes are here                             [  4 Runes     ]
-- Reserved/Unused                                            [                      ]
SET     @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep1 = 0x000000000000000000000000345322514A51D250000000000000000000000000
SET     @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep2 = 0x000000000000000000000000345322514A51D250000000000000000000000000
SET     @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep3 = 0x000000000000000000000000345322514A51D250000000000000000000000000
SET     @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep4 = 0x000000000000000000000000345322514A51D250000000000000000000000000
SET     @[I][B][URL="https://forum.ragezone.com/members/822931.html"]Range[/URL][/B][/I]Wep = 0x00000000000000000000000022514A51E853E650000000000000000000000000
SET     @OffWep1  = 0x8937FA270738F937052A2A288453C0539853E853000000000000000000000000
SET     @OffWep2  = 0x8937FA270738F937052A2A288453C0539853E853000000000000000000000000


SET     @[I][B][URL="https://forum.ragezone.com/members/779652.html"]Ring[/URL][/B][/I]A    = 0x8937FA270738F937052A2A288453C0539853E853000000000000000000000000
SET     @[I][B][URL="https://forum.ragezone.com/members/779652.html"]Ring[/URL][/B][/I]B    = 0x8937FA270738F937052A2A288453C0539853E853000000000000000000000000
SET     @Earring1 = 0x8937FA270738F937052A2A288453C0539853E853000000000000000000000000
SET     @Earring2 = 0x8937FA270738F937052A2A288453C0539853E853000000000000000000000000
SET     @[I][B][URL="https://forum.ragezone.com/members/354677.html"]nec[/URL][/B][/I]klace = 0x8937FA270738F937052A2A288453C0539853E853000000000000000000000000


SET     @[I][B][URL="https://forum.ragezone.com/members/1333430533.html"]Belt[/URL][/B][/I]     = 0x8937FA270738F937052A2A288453C0539853E853000000000000000000000000
SET     @[I][B][URL="https://forum.ragezone.com/members/474274.html"]Pants[/URL][/B][/I]    = 0x8937FA270738F937052A2A288453C0539853E853000000000000000000000000
SET     @Gloves   = 0x8937FA270738F937052A2A288453C0539853E853000000000000000000000000
SET     @[I][B][URL="https://forum.ragezone.com/members/1333349811.html"]Wings[/URL][/B][/I]    = 0x8937FA270738F937052A2A288453C0539853E853000000000000000000000000
SET     @[I][B][URL="https://forum.ragezone.com/members/1333419955.html"]Sho[/URL][/B][/I]ulder = 0x8937FA270738F937052A2A288453C0539853E853000000000000000000000000
SET     @Cape     = 0x8937FA270738F937052A2A288453C0539853E853000000000000000000000000
SET     @[I][B][URL="https://forum.ragezone.com/members/2000190331.html"]body[/URL][/B][/I]     = 0x8937FA270738F937052A2A288453C0539853E853000000000000000000000000
SET     @[I][B][URL="https://forum.ragezone.com/members/264011.html"]boo[/URL][/B][/I]ts    = 0x8937FA270738F937052A2A288453C0539853E853000000000000000000000000
SET     @Helm     = 0x8937FA270738F937052A2A288453C0539853E853000000000000000000000000


INSERT [dbo].[ImportMail]
([WorldID], [ToName],  [OrgObjID], [Count], [Durable],  [ExValue],   [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,       @EQDurable, @WEPExValue, 214632,          @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep1, N'Welcome', N'Hi',     0,       0,               0,             N'System'),
(1,         @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 214634,     1,       @EQDurable, @WEPExValue, 214634,          @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep2, N'Welcome', N'Hi',     0,       0,               0,             N'System'),
(1,         @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 214635,     1,       @EQDurable, @WEPExValue, 214635,          @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep3, N'Welcome', N'Hi',     0,       0,               0,             N'System'),
(1,         @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 214633,     1,       @EQDurable, @WEPExValue, 214633,          @[I][B][URL="https://forum.ragezone.com/members/275405.html"]Main[/URL][/B][/I]Wep4, 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,       @EQDurable, @EQExValue,  214637,          @Offwep2,  N'Welcome', N'Hi',     0,       0,               0,             N'System'),
(1,         @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 212779,     1,       @EQDurable, @EQExValue,  212779,          @Offwep1,  N'Welcome', N'Hi',     0,       0,               0,             N'System'),
(1,         @[I][B][URL="https://forum.ragezone.com/members/2000159491.html"]TOplayer[/URL][/B][/I], 214633,     1,       @EQDurable, @EQExValue,  214633,          @Offwep2,  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,       @EQDurable, @EQExValue,  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,       @EQDurable, @EQExValue,  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,       @EQDurable, @EQExValue,  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,       @EQDurable, @EQExValue,  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,       @EQDurable, @EQExValue,  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,       @EQDurable, @EQExValue,  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,       @EQDurable, @EQExValue,  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,       @EQDurable, @EQExValue,  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,       @EQDurable, @EQExValue,  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,       @EQDurable, @EQExValue,  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], 227728,     1,       @EQDurable, @EQExValue,  227728,          @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,       @EQDurable, @EQExValue,  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,       @EQDurable, @EQExValue,  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,       @EQDurable, @EQExValue,  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], 230764,     1,       @EQDurable, @EQExValue,  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
-- [OrgObjID] = Item ID in game and [ImageObjectID] = Skin/Agg for the item
-- [Count] - Must remain as 1 for items that can not be stacked
-- [WorldID] = If you run more then one server then change the WorldID so the mail is sent to the correct server
 
Last edited:
S

SuperFrogster

Newbie Spellweaver
Joined
Apr 17, 2013
Messages
46
Reaction score
13
Hmm, last night I found this little gem, I am sure we can add it to script (it has to be ExValue or Ability that gets edited, that removes level restriction from gear. With this little item, you can use above created gear on level 1 toon.

You must be registered to see links


Remove Level Restriction
Item Shop Item
Not dropped on PK death
Tools
Cannot be sold
Can be used to remove level restriction from a weapon or armor piece. Will be consumed after use.
 
D

Drewww

Junior Spellweaver
Joined
Apr 27, 2015
Messages
176
Reaction score
107
There is a bunch of stuff to play with that isnt in game, lot of it is buggy too. That item if I remember correctly its desction used to read Remove Class Restriction. Maybe its been changed now. But you can also use the tool Munksy made for editing the FDB files, you can also remove or modify restrictions there too. Sick-as tool, can do so much with it.



Oh and the Serial Number and CreateTime that all items should have, ive finaly got around to finishing that too. I'd like to get the hang of functions in SQL, might help make the code a little smaller. But for something that can execute in 1 second I don't think it matters.
 
S

SuperFrogster

Newbie Spellweaver
Joined
Apr 17, 2013
Messages
46
Reaction score
13
Hi Drewww,

I tried this script today, again, and it just does not work right for me.

I am trying to process set for L50 (Issac's Blessing) from Order of Dark Glory Gift pack (Chain) - 240387 item #.

Tier is 3, trying for Dura 120, Tier 9 for gear, Tier 10 for weapons, as well everything to +12.

Once I run it, it creates dura 88 item Tier 5?!

Can you try to run it for that set?
 
You must log in or register to reply here.

About Us

RaGEZONE® is a website dedicated to the development of massively multiplayer online role-playing games (MMORPGs).

Online statistics

Members online
241
Guests online
6,657
Total visitors
6,898
Totals may include hidden visitors.

Forum statistics

Threads
429,022
Messages
4,589,863
Members
280,281
Latest member
huzz
Most visitors online was 8830 , on 6 Feb 2024

RaGEZONE Sponsor

    HyperFilter
Back
Top