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