Walla

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.