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!

Custom Stat List+Runes to Hex String

Junior Spellweaver
Joined
Apr 27, 2015
Messages
176
Reaction score
107
For those who have used my SQL Mailing script to send gear to your toons, some have asked me how to make a stat list of their own to mail. Well here is a SQL script that will do that.

The output is a Hex string ready to copy and paste into one of the mailing scripts, just copy the output and paste it over the string in the mail script for the item you want to have your custom list.

You should be able to see where to put in your Stat ID numbers when you look over the script.
Just load edit and execute in msSQL Management Studio

(This is part of a project I am trying to work on so you can copy the equipment from the server you play on and use it on your own server).

And Yes - You can make and use a rune list with 4 Raid X runes, or 4 Curse X runes, it is only the game that restricts this, so you can have 4x of the same rune and 6x of the same stat if you want.

Code:
declare @StatBase    int;
declare @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID   int;
declare @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half   int;
declare @LeftHalf    int;
declare @Stat1       int;
declare @Stat2       int;
declare @Stat3       int;
declare @Stat4       int;
declare @Stat5       int;
declare @Stat6       int;
declare @Rune1       int;
declare @Rune2       int;
declare @Rune3       int;
declare @Rune4       int;
declare @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexRight char(2);
declare @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexLeft  char(2);
declare @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID0  char(4);
declare @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID1  char(4);
declare @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID2  char(4);
declare @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID3  char(4);
declare @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID4  char(4);
declare @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID5  char(4);
declare @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID6  char(4);
declare @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID7  char(4);
declare @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID8  char(4);
declare @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID9  char(4);
declare @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]String   char(100);
declare @[I][B][URL="https://forum.ragezone.com/members/849235.html"]Other[/URL][/B][/I]       char(30);
set     @[I][B][URL="https://forum.ragezone.com/members/849235.html"]Other[/URL][/B][/I]       = '000000000000000000000000';
set     @StatBase    = 500000


set     @Stat1       = 514119; -- <<  Put your Stat ID here
set     @Stat2       = 510810; -- <<  Put your Stat ID here
set     @Stat3       = 514105; -- <<  Put your Stat ID here
set     @Stat4       = 514217; -- <<  Put your Stat ID here
set     @Stat5       = 514343; -- <<  Put your Stat ID here
set     @Stat6       = 510757; -- <<  Put your Stat ID here
set     @rune1       = 521380; -- <<  Put Rune ID here
set     @rune2       = 521440; -- <<  Put Rune ID here
set     @rune3       = 521480; -- <<  Put Rune ID here
set     @rune4       = 521400; -- <<  Put Rune ID here


set @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID   = @Stat1 - @StatBase;
set @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half   = @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID / 256;
set @LeftHalf    = @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID - ( @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half * 256 );
set @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexRight = CONVERT ( VARCHAR ( 8 ) , CONVERT ( VARBINARY ( 1 ) , @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half ) , 2 ); --DEC2HEX
set @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexLeft  = CONVERT ( VARCHAR ( 8 ) , CONVERT ( VARBINARY ( 1 ) , @LeftHalf ) , 2); --DEC2HEX
set @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID0  = @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexLeft + @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexRight;


set @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID   = @Stat2 - @StatBase;
set @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half   = @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID / 256;
set @LeftHalf    = @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID - ( @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half * 256 );
set @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexRight = CONVERT ( VARCHAR ( 8 ) , CONVERT ( VARBINARY ( 1 ) , @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half ) , 2 ); --DEC2HEX
set @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexLeft  = CONVERT ( VARCHAR ( 8 ) , CONVERT ( VARBINARY ( 1 ) , @LeftHalf ) , 2); --DEC2HEX
set @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID1  = @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexLeft + @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexRight;


set @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID   = @Stat3 - @StatBase;
set @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half   = @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID / 256;
set @LeftHalf    = @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID - ( @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half * 256 );
set @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexRight = CONVERT ( VARCHAR ( 8 ) , CONVERT ( VARBINARY ( 1 ) , @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half ) , 2 ); --DEC2HEX
set @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexLeft  = CONVERT ( VARCHAR ( 8 ) , CONVERT ( VARBINARY ( 1 ) , @LeftHalf ) , 2); --DEC2HEX
set @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID2  = @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexLeft + @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexRight;


set @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID   = @Stat4 - @StatBase;
set @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half   = @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID / 256;
set @LeftHalf    = @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID - ( @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half * 256 );
set @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexRight = CONVERT ( VARCHAR ( 8 ) , CONVERT ( VARBINARY ( 1 ) , @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half ) , 2 ); --DEC2HEX
set @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexLeft  = CONVERT ( VARCHAR ( 8 ) , CONVERT ( VARBINARY ( 1 ) , @LeftHalf ) , 2); --DEC2HEX
set @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID3  = @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexLeft + @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexRight;


set @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID   = @Stat5 - @StatBase;
set @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half   = @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID / 256;
set @LeftHalf    = @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID - ( @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half * 256 );
set @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexRight = CONVERT ( VARCHAR ( 8 ) , CONVERT ( VARBINARY ( 1 ) , @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half ) , 2 ); --DEC2HEX
set @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexLeft  = CONVERT ( VARCHAR ( 8 ) , CONVERT ( VARBINARY ( 1 ) , @LeftHalf ) , 2); --DEC2HEX
set @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID4  = @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexLeft + @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexRight;


set @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID   = @Stat6 - @StatBase;
set @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half   = @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID / 256;
set @LeftHalf    = @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID - ( @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half * 256 );
set @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexRight = CONVERT ( VARCHAR ( 8 ) , CONVERT ( VARBINARY ( 1 ) , @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half ) , 2 ); --DEC2HEX
set @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexLeft  = CONVERT ( VARCHAR ( 8 ) , CONVERT ( VARBINARY ( 1 ) , @LeftHalf ) , 2); --DEC2HEX
set @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID5  = @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexLeft + @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexRight;


set @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID   = @Rune1 - @StatBase;
set @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half   = @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID / 256;
set @LeftHalf    = @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID - ( @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half * 256 );
set @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexRight = CONVERT ( VARCHAR ( 8 ) , CONVERT ( VARBINARY ( 1 ) , @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half ) , 2 ); --DEC2HEX
set @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexLeft  = CONVERT ( VARCHAR ( 8 ) , CONVERT ( VARBINARY ( 1 ) , @LeftHalf ) , 2); --DEC2HEX
set @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID6  = @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexLeft + @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexRight;


set @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID   = @Rune2 - @StatBase;
set @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half   = @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID / 256;
set @LeftHalf    = @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID - ( @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half * 256 );
set @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexRight = CONVERT ( VARCHAR ( 8 ) , CONVERT ( VARBINARY ( 1 ) , @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half ) , 2 ); --DEC2HEX
set @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexLeft  = CONVERT ( VARCHAR ( 8 ) , CONVERT ( VARBINARY ( 1 ) , @LeftHalf ) , 2); --DEC2HEX
set @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID7  = @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexLeft + @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexRight;


set @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID   = @Rune3 - @StatBase;
set @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half   = @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID / 256;
set @LeftHalf    = @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID - ( @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half * 256 );
set @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexRight = CONVERT ( VARCHAR ( 8 ) , CONVERT ( VARBINARY ( 1 ) , @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half ) , 2 ); --DEC2HEX
set @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexLeft  = CONVERT ( VARCHAR ( 8 ) , CONVERT ( VARBINARY ( 1 ) , @LeftHalf ) , 2); --DEC2HEX
set @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID8  = @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexLeft + @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexRight;


set @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID   = @Rune4 - @StatBase;
set @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half   = @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID / 256;
set @LeftHalf    = @[I][B][URL="https://forum.ragezone.com/members/2000173161.html"]news[/URL][/B][/I]tatID - ( @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half * 256 );
set @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexRight = CONVERT ( VARCHAR ( 8 ) , CONVERT ( VARBINARY ( 1 ) , @[I][B][URL="https://forum.ragezone.com/members/1333385732.html"]Right[/URL][/B][/I]Half ) , 2 ); --DEC2HEX
set @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexLeft  = CONVERT ( VARCHAR ( 8 ) , CONVERT ( VARBINARY ( 1 ) , @LeftHalf ) , 2); --DEC2HEX
set @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID9  = @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexLeft + @[I][B][URL="https://forum.ragezone.com/members/841155.html"]New[/URL][/B][/I]HexRight;


set @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]String   =
    @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID0+
    @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID1+
    @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID2+
    @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID3+
    @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID4+
    @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID5+
    @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID6+
    @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID7+
    @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID8+
    @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]StatID9+
    @[I][B][URL="https://forum.ragezone.com/members/849235.html"]Other[/URL][/B][/I];


print @[I][B][URL="https://forum.ragezone.com/members/276351.html"]hex[/URL][/B][/I]String;


EDIT: As usual I am having problems pasting code without the forum doing some editing/trimming. But I tested a copy/paste of the above and it seems to have posted correctly.
 
Last edited:
Back
Top