Jump to content

[sql Patch] Playercreateinfo_items


Guest Walla
 Share

Recommended Posts

Hey, i converted CharStartOutfit.dbc(contains playercreateinfo items values) into sql, as of patch 2.4.3.

Here is the patch;

/* Full one */
TRUNCATE `playercreateinfo_item`;
INSERT INTO `playercreateinfo_item` (`race`, `class`, `itemid`, `amount`) VALUES
(1,1,38,1),
(1,2,45,1),
(1,4,49,1),
(1,5,6098,1),
(1,8,56,1),
(1,9,57,1),
(2,1,6125,1),
(2,3,127,1),
(2,4,2105,1),
(2,7,154,1),
(2,9,6129,1),
(3,1,38,1),
(3,2,6117,1),
(3,3,148,1),
(3,4,2092,1),
(3,5,6098,1),
(4,1,25,1),
(4,3,2092,1),
(4,4,2092,1),
(4,5,36,1),
(4,11,3661,1),
(5,1,6125,1),
(5,4,2092,1),
(5,5,6144,1),
(5,8,6140,1),
(5,9,6129,1),
(6,1,6125,1),
(6,3,127,1),
(6,7,154,1),
(6,11,35,1),
(7,1,38,1),
(7,4,49,1),
(7,8,56,1),
(7,9,57,1),
(8,1,37,1),
(8,3,37,1),
(8,4,2092,1),
(8,5,36,1),
(8,7,36,1),
(8,8,6140,1),
(10,2,24143,1),
(10,3,20901,1),
(10,4,20982,1),
(10,5,20891,1),
(10,8,20893,1),
(10,9,20892,1),
(11,1,23473,1),
(11,2,23476,1),
(11,3,23345,1),
(11,5,1396,1),
(11,7,23345,1),
(11,8,23478,1),
(1,1,39,1),
(1,2,43,1),
(1,4,47,1),
(1,5,52,1),
(1,8,1395,1),
(1,9,6097,1),
(2,1,139,1),
(2,3,6126,1),
(2,4,120,1),
(2,7,153,1),
(2,9,1396,1),
(3,1,39,1),
(3,2,6118,1),
(3,3,147,1),
(3,4,49,1),
(3,5,53,1),
(4,1,6120,1),
(4,3,148,1),
(4,4,49,1),
(4,5,6119,1),
(4,11,6123,1),
(5,1,139,1),
(5,4,2105,1),
(5,5,53,1),
(5,8,1395,1),
(5,9,1396,1),
(6,1,139,1),
(6,3,6126,1),
(6,7,153,1),
(6,11,6139,1),
(7,1,39,1),
(7,4,48,1),
(7,8,1395,1),
(7,9,6097,1),
(8,1,117,4),
(8,3,4604,4),
(8,4,117,4),
(8,5,4540,4),
(8,7,117,4),
(8,8,1395,1),
(10,2,24145,1),
(10,3,20899,1),
(10,4,20897,1),
(10,5,53,1),
(10,8,20894,1),
(10,9,1396,1),
(11,1,23474,1),
(11,2,23477,1),
(11,3,23344,1),
(11,5,6097,1),
(11,7,23344,1),
(11,8,23479,1),
(1,1,40,1),
(1,2,44,1),
(1,4,48,1),
(1,5,53,1),
(1,8,55,1),
(1,9,1396,1),
(2,1,140,1),
(2,3,6127,1),
(2,4,121,1),
(2,7,6948,1),
(2,9,59,1),
(3,1,40,1),
(3,2,43,1),
(3,3,129,1),
(3,4,48,1),
(3,5,52,1),
(4,1,6121,1),
(4,3,147,1),
(4,4,48,1),
(4,5,52,1),
(4,11,6124,1),
(5,1,140,1),
(5,4,120,1),
(5,5,52,1),
(5,8,6096,1),
(5,9,59,1),
(6,3,6948,1),
(6,7,6948,1),
(6,11,6124,1),
(7,1,40,1),
(7,4,47,1),
(7,8,6096,1),
(7,9,1396,1),
(8,1,6125,1),
(8,3,2101,1),
(8,4,6136,1),
(8,5,159,2),
(8,7,159,2),
(8,8,6096,1),
(10,2,24146,1),
(10,3,20900,1),
(10,4,20896,1),
(10,5,52,1),
(10,8,6096,1),
(10,9,59,1),
(11,1,23475,1),
(11,2,2361,1),
(11,3,25,1),
(11,5,36,1),
(11,7,23348,1),
(11,8,35,1),
(1,2,6948,1),
(1,4,28979,100),
(1,5,51,1),
(1,8,35,1),
(1,9,2092,1),
(2,1,6948,1),
(2,3,159,2),
(2,4,25861,200),
(2,9,2092,1),
(3,4,47,1),
(3,5,51,1),
(4,1,6122,1),
(4,3,129,1),
(4,4,47,1),
(4,5,51,1),
(4,11,159,2),
(5,1,25,1),
(5,4,121,1),
(5,5,36,1),
(5,8,35,1),
(5,9,2092,1),
(6,1,2361,1),
(6,3,37,1),
(6,7,36,1),
(6,11,159,2),
(7,8,55,1),
(7,9,59,1),
(8,1,139,1),
(8,3,2512,200),
(8,4,6137,1),
(8,5,6144,1),
(8,7,6134,1),
(8,8,55,1),
(10,2,23346,1),
(10,3,159,2),
(10,4,20898,1),
(10,5,20981,1),
(10,8,35,1),
(10,9,20983,1),
(11,1,23346,1),
(11,3,23348,1),
(11,5,23322,1),
(11,7,6948,1),
(11,8,23473,1),
(1,1,25,1),
(1,2,2361,1),
(1,4,2092,1),
(1,5,36,1),
(1,8,6096,1),
(1,9,59,1),
(2,1,12282,1),
(2,3,37,1),
(2,4,2092,1),
(2,7,36,1),
(2,9,6948,1),
(3,1,12282,1),
(3,2,2361,1),
(3,3,37,1),
(3,5,36,1),
(4,1,2362,1),
(4,3,159,2),
(4,4,4540,4),
(4,5,53,1),
(4,11,4536,4),
(5,1,2362,1),
(5,4,4604,4),
(5,5,4604,4),
(5,8,55,1),
(6,1,6948,1),
(6,3,159,2),
(6,7,4604,4),
(7,1,25,1),
(7,4,2092,1),
(7,9,2092,1),
(8,1,2362,1),
(8,3,2504,1),
(8,4,6138,1),
(8,5,53,1),
(8,7,6135,1),
(8,8,35,1),
(10,3,20982,1),
(10,4,20857,4),
(10,5,20857,4),
(10,8,20895,1),
(10,9,6097,1),
(11,1,6948,1),
(11,2,6948,1),
(11,3,6948,1),
(11,5,6948,1),
(11,7,36,1),
(11,8,6948,1),
(1,1,2362,1),
(1,2,159,2),
(1,4,2070,4),
(1,5,159,2),
(1,8,2070,4),
(2,3,6948,1),
(2,4,117,4),
(2,7,117,4),
(2,9,117,4),
(3,1,6948,1),
(3,2,4540,4),
(3,3,159,2),
(3,4,4540,4),
(3,5,159,2),
(4,1,117,4),
(4,3,2504,1),
(4,5,2070,4),
(5,1,4604,4),
(5,5,159,2),
(5,8,4604,4),
(5,9,4604,4),
(6,1,4540,4),
(6,3,2508,1),
(6,7,159,2),
(6,11,4536,4),
(7,1,2362,1),
(7,4,28979,100),
(7,8,35,1),
(7,9,159,2),
(8,3,6126,1),
(8,5,52,1),
(8,8,117,4),
(10,2,20857,4),
(10,3,6948,1),
(10,5,159,2),
(10,8,20857,4),
(10,9,20857,4),
(11,1,4540,4),
(11,2,4540,4),
(11,3,4540,4),
(11,5,4540,4),
(11,7,4540,4),
(11,8,4540,4),
(1,1,117,4),
(1,2,2070,4),
(1,5,2070,4),
(1,8,159,2),
(1,9,4604,4),
(2,1,117,4),
(2,3,2101,1),
(2,7,159,2),
(2,9,159,2),
(3,1,117,4),
(3,2,159,2),
(3,3,2102,1),
(3,4,25861,200),
(3,5,4540,4),
(4,3,2101,1),
(4,4,28979,100),
(4,5,159,2),
(4,11,6948,1),
(5,4,25861,200),
(5,5,51,1),
(5,8,159,2),
(5,9,159,2),
(6,3,2102,1),
(6,11,6948,1),
(7,1,117,4),
(7,4,117,4),
(7,8,4536,4),
(7,9,4604,4),
(8,1,25861,200),
(8,3,127,1),
(8,4,25861,200),
(8,7,6948,1),
(8,8,159,2),
(10,2,159,2),
(10,3,2101,1),
(10,4,25861,200),
(10,5,51,1),
(10,8,159,2),
(10,9,159,2),
(11,2,159,2),
(11,3,159,2),
(11,5,159,2),
(11,7,159,2),
(11,8,159,2),
(1,1,6948,1),
(1,4,6948,1),
(1,9,159,2),
(2,3,2504,1),
(2,4,6948,1),
(3,2,6948,1),
(3,3,2508,1),
(3,4,6948,1),
(4,1,6948,1),
(4,3,2512,200),
(4,4,6948,1),
(5,1,6948,1),
(5,4,6948,1),
(5,9,6948,1),
(6,3,2516,200),
(7,1,6948,1),
(7,4,6948,1),
(7,8,159,2),
(8,1,6948,1),
(8,3,159,2),
(8,4,6948,1),
(8,5,6948,1),
(10,2,6948,1),
(10,3,20980,1),
(10,4,6948,1),
(10,9,6948,1),
(11,3,23347,100),
(1,5,6948,1),
(1,8,6948,1),
(1,9,6948,1),
(2,3,117,4),
(3,3,2516,200),
(3,5,6948,1),
(4,3,117,4),
(4,5,6948,1),
(5,5,6948,1),
(5,8,6948,1),
(6,3,117,4),
(7,8,6948,1),
(7,9,6948,1),
(8,8,6948,1),
(10,3,20857,4),
(10,5,6948,1),
(10,8,6948,1),
(11,3,2101,1),
(2,3,2512,200),
(3,3,117,4),
(8,3,6948,1),
(10,3,2512,200),
(11,3,2512,200),
(3,3,6948,1),
(4,3,6948,1);

Note: There's 1 thing which doens't exists there which are Gift Vouchers, those are "giftf" that players with collection pack get. See.

Hope you like it,

Walla.

Link to comment
Share on other sites

  • 4 months later...
 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use