really need help

[love236]

hi guys when i try to well execute a sql that gives me armor and weps or anything it says Column count doesn't match value count at row 1 can somsone tell me how to fix it?

[Viter]

its not for your db.

[love236]

then what is it for?

[nickelo]

then what is it for?

CAn you post the SQL file and ill fix it for you and re-post..i know how = \..(and when i say post the sql file i mean copy and paste it into a code.)

[latruwski]

post your SQL file of the weapon and post what DB rev you are using... (or post a DB structure you use by dumping the table to a sql file)

[love236]

tier 7 weapons is the name of the sql






INSERT INTO `items` VALUES ('60000', '2', '0', '-1', 'Axe of the Ogre', 'Axe of the Ogre', 'Axe of the Ogre', 'Axe of the Ogre', '43655', '5', '0', '4440000', '4440000', '13', '1', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '4', '213', '7', '122', '31', '97', '36', '89', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '782', '1072', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2600', '0', '0', '0', '0', '0', '0', '0', '0', '28093', '2', '0', '0', '0', '0', '27216', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2', 'A Mighty Ogre Had possession of these Weapon', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '552', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `items` VALUES ('60001', '2', '0', '-1', 'Axe of Ren\'jin', 'Axe of Ren\'jin', 'Axe of Ren\'jin', 'Axe of Ren\'jin', '41772', '5', '0', '4440000', '4440000', '13', '1', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '4', '143', '7', '97', '31', '78', '36', '65', '32', '73', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '585', '896', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1965', '0', '0', '0', '0', '0', '0', '0', '0', '28494', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2', 'Ren\'jin\'s Axe of the Trollsbane', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '475', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `items` VALUES ('60002', '2', '8', '-1', 'Death\'s Skulll Toped Rever', 'Death\'s Skulll Toped Rever', 'Death\'s Skulll Toped Rever', 'Death\'s Skulll Toped Rever', '35255', '5', '0', '4444444', '4444444', '17', '1', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '4', '342', '7', '253', '16', '164', '36', '133', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1324', '1643', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2614', '0', '0', '28506', '0', '0', '120044', '1141', '0', '28494', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'The Repering of Skulls', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '657', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '300', '0');
INSERT INTO `items` VALUES ('60003', '2', '7', '-1', 'Sword of the Defender', 'Sword of the Defender', 'Sword of the Defender', 'Sword of the Defender', '39039', '5', '0', '4440000', '4440000', '21', '1', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '7', '312', '3', '115', '12', '97', '31', '64', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '714', '912', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2265', '0', '0', '7599', '1', '0', '0', '0', '0', '34696', '2', '0', '0', '0', '0', '28735', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Defender this sword with your life...', '0', '0', '0', '0', '0', '1', '3', '0', '0', '0', '0', '563', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `items` VALUES ('60004', '4', '6', '-1', 'Protector of Death', 'Protector of Death', 'Protector of Death', 'Protector of Death', '35654', '5', '0', '44444', '44444', '14', '1', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '7', '623', '4', '523', '15', '132', '36', '243', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5723', '0', '0', '0', '0', '0', '0', '0', '0', '0', '7599', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Protector of Death', '0', '0', '0', '0', '0', '6', '4', '0', '0', '112', '0', '1172', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '300', '0');

INSERT INTO `items` VALUES ('60006', '2', '7', '-1', 'Sword of the Unbroken', 'Sword of the Unbroken', 'Sword of the Unbroken', 'Sword of the Unbroken', '43401', '5', '0', '4440000', '4440000', '22', '8', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '3', '186', '4', '143', '31', '121', '36', '98', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '463', '784', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1846', '0', '0', '17013', '2', '0', '0', '0', '0', '33014', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'The Broken one Akama Possess this Weapon', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '518', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `items` VALUES ('60005', '2', '7', '-1', 'Sword of the Unbroken', 'Sword of the Unbroken', 'Sword of the Unbroken', 'Sword of the Unbroken', '43401', '5', '0', '4440000', '4440000', '21', '8', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '3', '213', '4', '186', '31', '143', '36', '121', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '513', '867', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2356', '0', '0', '17013', '2', '0', '0', '0', '0', '33014', '2', '0', '0', '0', '0', '41597', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'The Broken one Akama Possess this Weapon', '0', '0', '0', '0', '0', '1', '3', '0', '0', '0', '0', '513', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `items` VALUES ('60007', '2', '2', '-1', 'Bow of the Trolls', 'Bow of the Trolls', 'Bow of the Trolls', 'Bow of the Trolls', '32571', '5', '0', '4440000', '4440000', '15', '4', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '3', '143', '7', '213', '29', '142', '20', '97', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '492', '761', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2314', '2', '100', '16885', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Trolls Crafted this with Wood', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '735', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `items` VALUES ('60008', '2', '6', '-1', 'Arm of Deverstation', 'Arm of Deverstation', 'Arm of Deverstation', 'Arm of Deverstation', '42073', '5', '0', '4440000', '4440000', '17', '4', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '3', '324', '7', '213', '20', '153', '29', '75', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1120', '1321', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2984', '0', '0', '15820', '1', '0', '0', '0', '0', '7599', '1', '0', '0', '0', '0', '26693', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Deverstation apon this world', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '1022', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `items` VALUES ('60009', '2', '0', '-1', 'Axe of Venom Spit', 'Axe of Venom Spit', 'Axe of Venom Spit', 'Axe of Venom Spit', '38797', '5', '0', '4440000', '4440000', '13', '4', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '3', '65', '7', '97', '28', '123', '29', '97', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '354', '743', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2079', '0', '0', '9405', '1', '0', '0', '0', '0', '29155', '2', '0', '0', '0', '0', '28735', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Powerfull Posion', '0', '0', '0', '0', '0', '1', '3', '0', '0', '0', '0', '431', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `items` VALUES ('60010', '2', '10', '-1', 'Skulled Beation Staff', 'Skulled Beation Staff', 'Skulled Beation Staff', 'Skulled Beation Staff', '24771', '5', '0', '4440000', '4440000', '17', '128', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '5', '341', '7', '231', '18', '210', '30', '93', '24', '88', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '264', '583', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3153', '0', '0', '35894', '1', '0', '0', '0', '0', '35898', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Beation down', '0', '0', '0', '0', '0', '1', '2', '0', '0', '0', '0', '646', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `items` VALUES ('60011', '2', '15', '-1', 'Dagger of the Forge', 'Dagger of the Forge', 'Dagger of the Forge', 'Dagger of the Forge', '43645', '5', '0', '4440000', '4440000', '13', '128', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '5', '152', '7', '175', '18', '98', '1', '76', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '241', '562', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1615', '0', '0', '28141', '1', '0', '0', '0', '0', '35900', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Forged with pure Power', '0', '0', '0', '0', '0', '1', '3', '0', '0', '0', '0', '415', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `items` VALUES ('60012', '2', '5', '-1', 'Maul of Damand', 'Maul of Damand', 'Maul of Damand', 'Maul of Damand', '36518', '5', '0', '4440000', '4440000', '17', '2', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '4', '215', '5', '184', '7', '132', '19', '97', '30', '45', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '734', '972', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3036', '0', '0', '35893', '1', '0', '0', '0', '0', '29155', '2', '0', '0', '0', '0', '7600', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Damand Respect', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '824', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `items` VALUES ('60013', '2', '4', '-1', 'Blood Rocker', 'Blood Rocker', 'Blood Rocker', 'Blood Rocker', '42212', '5', '0', '4440000', '4440000', '21', '2', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '5', '134', '4', '79', '12', '52', '21', '59', '28', '87', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '462', '678', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1809', '0', '0', '7599', '1', '0', '0', '0', '0', '35894', '1', '0', '0', '0', '0', '26693', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Rocked Some ones World!', '0', '0', '0', '0', '0', '1', '3', '0', '0', '0', '0', '478', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `items` VALUES ('60014', '4', '6', '-1', 'Crest of Rockness', 'Crest of Rockness', 'Crest of Rockness', 'Crest of Rockness', '23825', '5', '0', '44440000', '4440000', '14', '2', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '7', '312', '4', '187', '30', '42', '18', '62', '16', '75', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '11653', '0', '0', '0', '0', '0', '0', '0', '0', '0', '7600', '1', '0', '0', '0', '0', '36409', '1', '0', '0', '0', '0', '35887', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Rock this world!', '0', '0', '0', '0', '0', '6', '4', '0', '0', '362', '0', '724', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `items` VALUES ('60015', '2', '10', '-1', 'Stave of Demonic Legion', 'Stave of Demonic Legion', 'Stave of Demonic Legion', 'Stave of Demonic Legion', '32332', '5', '0', '4440000', '4440000', '17', '256', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '5', '413', '7', '314', '18', '164', '30', '112', '21', '85', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '541', '726', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2946', '0', '0', '35896', '1', '0', '0', '0', '0', '36430', '1', '0', '0', '0', '0', '35887', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'The Demonic Legion Will Corrupted you', '0', '0', '0', '0', '0', '1', '2', '0', '0', '0', '0', '581', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `items` VALUES ('60016', '2', '7', '-1', 'Fire bender of the Legion', 'Fire bender of the Legion', 'Fire bender of the Legion', 'Fire bender of the Legion', '20030', '5', '0', '4440000', '4440000', '13', '256', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '7', '152', '5', '97', '6', '45', '30', '78', '18', '46', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '241', '521', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1805', '0', '0', '28141', '1', '0', '0', '0', '0', '35893', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2', 'the Fire within the Legion', '0', '0', '0', '0', '0', '1', '3', '0', '0', '0', '0', '472', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `items` VALUES ('60017', '2', '1', '-1', 'Axe of Eternal Doom', 'Axe of Eternal Doom', 'Axe of Eternal Doom', 'Axe of Eternal Doom', '41776', '5', '0', '4440000', '4440000', '17', '64', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '4', '231', '5', '196', '7', '143', '28', '69', '21', '46', '18', '87', '0', '0', '0', '0', '0', '0', '0', '0', '813', '1235', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2891', '0', '0', '29155', '2', '0', '0', '0', '0', '28735', '1', '0', '0', '0', '0', '35894', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Doom Beyond you all', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '724', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `items` VALUES ('60018', '2', '4', '-1', 'Mace of Spikes', 'Mace of Spikes', 'Mace of Spikes', 'Mace of Spikes', '35250', '5', '0', '4440000', '4440000', '21', '64', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '4', '183', '5', '98', '7', '112', '18', '67', '28', '84', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '476', '925', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2314', '0', '0', '7600', '1', '0', '0', '0', '0', '29155', '2', '0', '0', '0', '0', '36409', '1', '0', '0', '0', '0', '36430', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Spikes Whitin in you', '0', '0', '0', '0', '0', '1', '3', '0', '0', '0', '0', '412', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `items` VALUES ('60019', '2', '0', '-1', 'Corrupted Man Slayer', 'Corrupted Man Slayer', 'Corrupted Man Slayer', 'Corrupted Man Slayer', '34718', '5', '0', '4440000', '4440000', '13', '64', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '4', '78', '5', '98', '7', '58', '28', '84', '18', '57', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '512', '782', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1792', '0', '0', '7599', '1', '0', '0', '0', '0', '26693', '2', '0', '0', '0', '0', '35893', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Slayed alot of men!', '0', '0', '0', '0', '0', '1', '3', '0', '0', '0', '0', '412', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `items` VALUES ('60020', '2', '4', '-1', 'Mace to the Face', 'Mace to the Face', 'Mace to the Face', 'Mace to the Face', '33830', '5', '0', '4440000', '4440000', '21', '64', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '4', '86', '5', '114', '18', '213', '30', '178', '21', '165', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '465', '721', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2164', '0', '0', '35898', '1', '0', '0', '0', '0', '29155', '2', '0', '0', '0', '0', '7599', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Face the mace', '0', '0', '0', '0', '0', '1', '3', '0', '0', '0', '0', '612', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `items` VALUES ('60021', '4', '6', '-1', 'Shield of the Bloodtrolls', 'Shield of the Bloodtrolls', 'Shield of the Bloodtrolls', 'Shield of the Bloodtrolls', '23750', '5', '0', '4440000', '4440000', '14', '64', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '4', '98', '5', '114', '7', '164', '18', '153', '30', '87', '21', '78', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5912', '0', '0', '0', '0', '0', '0', '0', '0', '0', '7600', '1', '0', '0', '0', '0', '35827', '1', '0', '0', '0', '0', '35893', '1', '0', '0', '0', '0', '36409', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Bloodtrolls, Crazy Things!', '0', '0', '0', '0', '0', '6', '4', '0', '0', '623', '0', '817', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `items` VALUES ('60022', '2', '10', '-1', 'Dragon Skulled Staff', 'Dragon Skulled Staff', 'Dragon Skulled Staff', 'Dragon Skulled Staff', '31960', '5', '0', '4440000', '4440000', '17', '16', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '5', '341', '6', '311', '7', '262', '18', '175', '30', '145', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '262', '634', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2996', '0', '0', '36430', '1', '0', '0', '0', '0', '35900', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Killed a Dragon once, Forgot were i put the body', '0', '0', '0', '0', '0', '1', '2', '0', '0', '0', '0', '624', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `items` VALUES ('60023', '2', '15', '-1', 'Dagger of Dismembered Gods', 'Dagger of Dismembered Gods', 'Dagger of Dismembered Gods', 'Dagger of Dismembered Gods', '43645', '5', '0', '4440000', '4440000', '13', '16', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '5', '186', '6', '143', '7', '127', '18', '86', '30', '56', '21', '45', '0', '0', '0', '0', '0', '0', '0', '0', '184', '534', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1793', '0', '0', '36430', '1', '0', '0', '0', '0', '36067', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Dismemebered gods are Watching', '0', '0', '0', '0', '0', '1', '3', '0', '0', '0', '0', '452', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `items` VALUES ('60024', '2', '10', '-1', 'Quill of Druidsom', 'Quill of Druidsom', 'Quill of Druidsom', 'Quill of Druidsom', '24015', '5', '0', '4440000', '4440000', '17', '1024', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '3', '361', '4', '272', '7', '164', '5', '165', '31', '141', '30', '113', '0', '0', '0', '0', '0', '0', '0', '0', '452', '782', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3123', '0', '0', '7599', '1', '0', '0', '0', '0', '29155', '2', '0', '0', '0', '0', '36409', '1', '0', '0', '0', '0', '35900', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Druidsom Other the others', '0', '0', '0', '0', '0', '1', '2', '0', '0', '0', '0', '724', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `items` VALUES ('60025', '2', '4', '-1', 'Maced rod of the Druid', 'Maced rod of the Druid', 'Maced rod of the Druid', 'Maced rod of the Druid', '37049', '5', '0', '4440000', '4440000', '13', '1024', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '3', '145', '4', '134', '5', '120', '6', '89', '7', '69', '18', '57', '16', '86', '0', '0', '0', '0', '0', '0', '754', '824', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2142', '0', '0', '7600', '1', '0', '0', '0', '0', '29155', '2', '0', '0', '0', '0', '15831', '1', '0', '0', '0', '0', '35893', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'This rod was made for the one....', '0', '0', '0', '0', '0', '1', '3', '0', '0', '0', '0', '624', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `creature_names` VALUES ('880088', 'Thays', 'Tier 7 Weapons', '0', '7', '0', '0', '0', null, '15320', '0', '0', '0', '0', '0', '1');
INSERT INTO `creature_proto` VALUES ('880088', '90', '90', '475', '9999', '9999', '0', '1', '16388', '10', '999', '9999', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '15000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '1', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `vendors` VALUES ('880088', '60001', '2');
INSERT INTO `vendors` VALUES ('880088', '60002', '2');
INSERT INTO `vendors` VALUES ('880088', '60003', '2');
INSERT INTO `vendors` VALUES ('880088', '60004', '2');
INSERT INTO `vendors` VALUES ('880088', '60005', '2');
INSERT INTO `vendors` VALUES ('880088', '60006', '2');
INSERT INTO `vendors` VALUES ('880088', '60007', '2');
INSERT INTO `vendors` VALUES ('880088', '60008', '2');
INSERT INTO `vendors` VALUES ('880088', '60009', '2');
INSERT INTO `vendors` VALUES ('880088', '60010', '2');
INSERT INTO `vendors` VALUES ('880088', '60011', '2');
INSERT INTO `vendors` VALUES ('880088', '60012', '2');
INSERT INTO `vendors` VALUES ('880088', '60013', '2');
INSERT INTO `vendors` VALUES ('880088', '60014', '2');
INSERT INTO `vendors` VALUES ('880088', '60015', '2');
INSERT INTO `vendors` VALUES ('880088', '60016', '2');
INSERT INTO `vendors` VALUES ('880088', '60017', '2');
INSERT INTO `vendors` VALUES ('880088', '60018', '2');
INSERT INTO `vendors` VALUES ('880088', '60019', '2');
INSERT INTO `vendors` VALUES ('880088', '60020', '2');
INSERT INTO `vendors` VALUES ('880088', '60021', '2');
INSERT INTO `vendors` VALUES ('880088', '60022', '2');
INSERT INTO `vendors` VALUES ('880088', '60023', '2');
INSERT INTO `vendors` VALUES ('880088', '60024', '2');
INSERT INTO `vendors` VALUES ('880088', '60025', '2');
INSERT INTO `vendors` VALUES ('880088', '60000', '2');





i dont know what rev is but i am using ac web ultimate repack 7.3 and i use mafiaboys database

[nickelo]

okay this is waht u do in the beginning of every one delete this INSERT INTO ITEMS' and just keep values and put this on top INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2)

[nickelo]

here to clear things up

 
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES ('60000', '2', '0', '-1', 'Axe of the Ogre', 'Axe of the Ogre', 'Axe of the Ogre', 'Axe of the Ogre', '43655', '5', '0', '4440000', '4440000', '13', '1', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '4', '213', '7', '122', '31', '97', '36', '89', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '782', '1072', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2600', '0', '0', '0', '0', '0', '0', '0', '0', '28093', '2', '0', '0', '0', '0', '27216', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2', 'A Mighty Ogre Had possession of these Weapon', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '552', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES('60001', '2', '0', '-1', 'Axe of Ren\'jin', 'Axe of Ren\'jin', 'Axe of Ren\'jin', 'Axe of Ren\'jin', '41772', '5', '0', '4440000', '4440000', '13', '1', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '4', '143', '7', '97', '31', '78', '36', '65', '32', '73', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '585', '896', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1965', '0', '0', '0', '0', '0', '0', '0', '0', '28494', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2', 'Ren\'jin\'s Axe of the Trollsbane', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '475', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES ('60002', '2', '8', '-1', 'Death\'s Skulll Toped Rever', 'Death\'s Skulll Toped Rever', 'Death\'s Skulll Toped Rever', 'Death\'s Skulll Toped Rever', '35255', '5', '0', '4444444', '4444444', '17', '1', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '4', '342', '7', '253', '16', '164', '36', '133', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1324', '1643', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2614', '0', '0', '28506', '0', '0', '120044', '1141', '0', '28494', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'The Repering of Skulls', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '657', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '300', '0');
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES ('60003', '2', '7', '-1', 'Sword of the Defender', 'Sword of the Defender', 'Sword of the Defender', 'Sword of the Defender', '39039', '5', '0', '4440000', '4440000', '21', '1', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '7', '312', '3', '115', '12', '97', '31', '64', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '714', '912', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2265', '0', '0', '7599', '1', '0', '0', '0', '0', '34696', '2', '0', '0', '0', '0', '28735', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Defender this sword with your life...', '0', '0', '0', '0', '0', '1', '3', '0', '0', '0', '0', '563', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES ('60004', '4', '6', '-1', 'Protector of Death', 'Protector of Death', 'Protector of Death', 'Protector of Death', '35654', '5', '0', '44444', '44444', '14', '1', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '7', '623', '4', '523', '15', '132', '36', '243', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5723', '0', '0', '0', '0', '0', '0', '0', '0', '0', '7599', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Protector of Death', '0', '0', '0', '0', '0', '6', '4', '0', '0', '112', '0', '1172', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '300', '0');
 
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES ('60006', '2', '7', '-1', 'Sword of the Unbroken', 'Sword of the Unbroken', 'Sword of the Unbroken', 'Sword of the Unbroken', '43401', '5', '0', '4440000', '4440000', '22', '8', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '3', '186', '4', '143', '31', '121', '36', '98', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '463', '784', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1846', '0', '0', '17013', '2', '0', '0', '0', '0', '33014', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'The Broken one Akama Possess this Weapon', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '518', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES ('60005', '2', '7', '-1', 'Sword of the Unbroken', 'Sword of the Unbroken', 'Sword of the Unbroken', 'Sword of the Unbroken', '43401', '5', '0', '4440000', '4440000', '21', '8', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '3', '213', '4', '186', '31', '143', '36', '121', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '513', '867', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2356', '0', '0', '17013', '2', '0', '0', '0', '0', '33014', '2', '0', '0', '0', '0', '41597', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'The Broken one Akama Possess this Weapon', '0', '0', '0', '0', '0', '1', '3', '0', '0', '0', '0', '513', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES ('60007', '2', '2', '-1', 'Bow of the Trolls', 'Bow of the Trolls', 'Bow of the Trolls', 'Bow of the Trolls', '32571', '5', '0', '4440000', '4440000', '15', '4', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '3', '143', '7', '213', '29', '142', '20', '97', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '492', '761', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2314', '2', '100', '16885', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Trolls Crafted this with Wood', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '735', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES ('60008', '2', '6', '-1', 'Arm of Deverstation', 'Arm of Deverstation', 'Arm of Deverstation', 'Arm of Deverstation', '42073', '5', '0', '4440000', '4440000', '17', '4', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '3', '324', '7', '213', '20', '153', '29', '75', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1120', '1321', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2984', '0', '0', '15820', '1', '0', '0', '0', '0', '7599', '1', '0', '0', '0', '0', '26693', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Deverstation apon this world', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '1022', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES ('60009', '2', '0', '-1', 'Axe of Venom Spit', 'Axe of Venom Spit', 'Axe of Venom Spit', 'Axe of Venom Spit', '38797', '5', '0', '4440000', '4440000', '13', '4', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '3', '65', '7', '97', '28', '123', '29', '97', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '354', '743', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2079', '0', '0', '9405', '1', '0', '0', '0', '0', '29155', '2', '0', '0', '0', '0', '28735', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Powerfull Posion', '0', '0', '0', '0', '0', '1', '3', '0', '0', '0', '0', '431', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
 
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES ('60010', '2', '10', '-1', 'Skulled Beation Staff', 'Skulled Beation Staff', 'Skulled Beation Staff', 'Skulled Beation Staff', '24771', '5', '0', '4440000', '4440000', '17', '128', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '5', '341', '7', '231', '18', '210', '30', '93', '24', '88', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '264', '583', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3153', '0', '0', '35894', '1', '0', '0', '0', '0', '35898', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Beation down', '0', '0', '0', '0', '0', '1', '2', '0', '0', '0', '0', '646', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES ('60011', '2', '15', '-1', 'Dagger of the Forge', 'Dagger of the Forge', 'Dagger of the Forge', 'Dagger of the Forge', '43645', '5', '0', '4440000', '4440000', '13', '128', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '5', '152', '7', '175', '18', '98', '1', '76', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '241', '562', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1615', '0', '0', '28141', '1', '0', '0', '0', '0', '35900', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Forged with pure Power', '0', '0', '0', '0', '0', '1', '3', '0', '0', '0', '0', '415', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES ('60012', '2', '5', '-1', 'Maul of Damand', 'Maul of Damand', 'Maul of Damand', 'Maul of Damand', '36518', '5', '0', '4440000', '4440000', '17', '2', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '4', '215', '5', '184', '7', '132', '19', '97', '30', '45', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '734', '972', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3036', '0', '0', '35893', '1', '0', '0', '0', '0', '29155', '2', '0', '0', '0', '0', '7600', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Damand Respect', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '824', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES ('60013', '2', '4', '-1', 'Blood Rocker', 'Blood Rocker', 'Blood Rocker', 'Blood Rocker', '42212', '5', '0', '4440000', '4440000', '21', '2', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '5', '134', '4', '79', '12', '52', '21', '59', '28', '87', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '462', '678', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1809', '0', '0', '7599', '1', '0', '0', '0', '0', '35894', '1', '0', '0', '0', '0', '26693', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Rocked Some ones World!', '0', '0', '0', '0', '0', '1', '3', '0', '0', '0', '0', '478', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES ('60014', '4', '6', '-1', 'Crest of Rockness', 'Crest of Rockness', 'Crest of Rockness', 'Crest of Rockness', '23825', '5', '0', '44440000', '4440000', '14', '2', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '7', '312', '4', '187', '30', '42', '18', '62', '16', '75', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '11653', '0', '0', '0', '0', '0', '0', '0', '0', '0', '7600', '1', '0', '0', '0', '0', '36409', '1', '0', '0', '0', '0', '35887', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Rock this world!', '0', '0', '0', '0', '0', '6', '4', '0', '0', '362', '0', '724', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
 
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES ('60015', '2', '10', '-1', 'Stave of Demonic Legion', 'Stave of Demonic Legion', 'Stave of Demonic Legion', 'Stave of Demonic Legion', '32332', '5', '0', '4440000', '4440000', '17', '256', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '5', '413', '7', '314', '18', '164', '30', '112', '21', '85', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '541', '726', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2946', '0', '0', '35896', '1', '0', '0', '0', '0', '36430', '1', '0', '0', '0', '0', '35887', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'The Demonic Legion Will Corrupted you', '0', '0', '0', '0', '0', '1', '2', '0', '0', '0', '0', '581', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES ('60016', '2', '7', '-1', 'Fire bender of the Legion', 'Fire bender of the Legion', 'Fire bender of the Legion', 'Fire bender of the Legion', '20030', '5', '0', '4440000', '4440000', '13', '256', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '7', '152', '5', '97', '6', '45', '30', '78', '18', '46', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '241', '521', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1805', '0', '0', '28141', '1', '0', '0', '0', '0', '35893', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2', 'the Fire within the Legion', '0', '0', '0', '0', '0', '1', '3', '0', '0', '0', '0', '472', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES ('60017', '2', '1', '-1', 'Axe of Eternal Doom', 'Axe of Eternal Doom', 'Axe of Eternal Doom', 'Axe of Eternal Doom', '41776', '5', '0', '4440000', '4440000', '17', '64', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '4', '231', '5', '196', '7', '143', '28', '69', '21', '46', '18', '87', '0', '0', '0', '0', '0', '0', '0', '0', '813', '1235', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2891', '0', '0', '29155', '2', '0', '0', '0', '0', '28735', '1', '0', '0', '0', '0', '35894', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Doom Beyond you all', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '724', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES ('60018', '2', '4', '-1', 'Mace of Spikes', 'Mace of Spikes', 'Mace of Spikes', 'Mace of Spikes', '35250', '5', '0', '4440000', '4440000', '21', '64', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '4', '183', '5', '98', '7', '112', '18', '67', '28', '84', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '476', '925', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2314', '0', '0', '7600', '1', '0', '0', '0', '0', '29155', '2', '0', '0', '0', '0', '36409', '1', '0', '0', '0', '0', '36430', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Spikes Whitin in you', '0', '0', '0', '0', '0', '1', '3', '0', '0', '0', '0', '412', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

[love236]

i didnt really understand that i am a really noob could u show me on an easier way ?

[nickelo]

and heres the other part

INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES ('60020', '2', '4', '-1', 'Mace to the Face', 'Mace to the Face', 'Mace to the Face', 'Mace to the Face', '33830', '5', '0', '4440000', '4440000', '21', '64', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '4', '86', '5', '114', '18', '213', '30', '178', '21', '165', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '465', '721', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2164', '0', '0', '35898', '1', '0', '0', '0', '0', '29155', '2', '0', '0', '0', '0', '7599', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Face the mace', '0', '0', '0', '0', '0', '1', '3', '0', '0', '0', '0', '612', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES ('60021', '4', '6', '-1', 'Shield of the Bloodtrolls', 'Shield of the Bloodtrolls', 'Shield of the Bloodtrolls', 'Shield of the Bloodtrolls', '23750', '5', '0', '4440000', '4440000', '14', '64', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '4', '98', '5', '114', '7', '164', '18', '153', '30', '87', '21', '78', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5912', '0', '0', '0', '0', '0', '0', '0', '0', '0', '7600', '1', '0', '0', '0', '0', '35827', '1', '0', '0', '0', '0', '35893', '1', '0', '0', '0', '0', '36409', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Bloodtrolls, Crazy Things!', '0', '0', '0', '0', '0', '6', '4', '0', '0', '623', '0', '817', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES ('60022', '2', '10', '-1', 'Dragon Skulled Staff', 'Dragon Skulled Staff', 'Dragon Skulled Staff', 'Dragon Skulled Staff', '31960', '5', '0', '4440000', '4440000', '17', '16', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '5', '341', '6', '311', '7', '262', '18', '175', '30', '145', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '262', '634', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2996', '0', '0', '36430', '1', '0', '0', '0', '0', '35900', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Killed a Dragon once, Forgot were i put the body', '0', '0', '0', '0', '0', '1', '2', '0', '0', '0', '0', '624', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES ('60023', '2', '15', '-1', 'Dagger of Dismembered Gods', 'Dagger of Dismembered Gods', 'Dagger of Dismembered Gods', 'Dagger of Dismembered Gods', '43645', '5', '0', '4440000', '4440000', '13', '16', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '5', '186', '6', '143', '7', '127', '18', '86', '30', '56', '21', '45', '0', '0', '0', '0', '0', '0', '0', '0', '184', '534', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1793', '0', '0', '36430', '1', '0', '0', '0', '0', '36067', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Dismemebered gods are Watching', '0', '0', '0', '0', '0', '1', '3', '0', '0', '0', '0', '452', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `items` VALUES ('60024', '2', '10', '-1', 'Quill of Druidsom', 'Quill of Druidsom', 'Quill of Druidsom', 'Quill of Druidsom', '24015', '5', '0', '4440000', '4440000', '17', '1024', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '3', '361', '4', '272', '7', '164', '5', '165', '31', '141', '30', '113', '0', '0', '0', '0', '0', '0', '0', '0', '452', '782', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3123', '0', '0', '7599', '1', '0', '0', '0', '0', '29155', '2', '0', '0', '0', '0', '36409', '1', '0', '0', '0', '0', '35900', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Druidsom Other the others', '0', '0', '0', '0', '0', '1', '2', '0', '0', '0', '0', '724', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES ('60025', '2', '4', '-1', 'Maced rod of the Druid', 'Maced rod of the Druid', 'Maced rod of the Druid', 'Maced rod of the Druid', '37049', '5', '0', '4440000', '4440000', '13', '1024', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '3', '145', '4', '134', '5', '120', '6', '89', '7', '69', '18', '57', '16', '86', '0', '0', '0', '0', '0', '0', '754', '824', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2142', '0', '0', '7600', '1', '0', '0', '0', '0', '29155', '2', '0', '0', '0', '0', '15831', '1', '0', '0', '0', '0', '35893', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'This rod was made for the one....', '0', '0', '0', '0', '0', '1', '3', '0', '0', '0', '0', '624', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES ('60018', '2', '4', '-1', 'Mace of Spikes', 'Mace of Spikes', 'Mace of Spikes', 'Mace of Spikes', '35250', '5', '0', '4440000', '4440000', '21', '64', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '4', '183', '5', '98', '7', '112', '18', '67', '28', '84', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '476', '925', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2314', '0', '0', '7600', '1', '0', '0', '0', '0', '29155', '2', '0', '0', '0', '0', '36409', '1', '0', '0', '0', '0', '36430', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Spikes Whitin in you', '0', '0', '0', '0', '0', '1', '3', '0', '0', '0', '0', '412', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2)

[nickelo]

and then heres the creatures


[code]

INSERT INTO creature_names (entry, `name`, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, male_displayid, unknown_float1, unknown_float2, Civilian, Leader)
VALUES ('880088', 'Thays', 'Tier 7 Weapons', '0', '7', '0', '0', '0', null, '15320', '0', '0', '0', '0', '0', '1');
INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)
VALUES ('880088', '90', '90', '475', '9999', '9999', '0', '1', '16388', '10', '999', '9999', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '15000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '1', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `vendors` VALUES ('880088', '60001', '2');
INSERT INTO `vendors` VALUES ('880088', '60002', '2');
INSERT INTO `vendors` VALUES ('880088', '60003', '2');
INSERT INTO `vendors` VALUES ('880088', '60004', '2');
INSERT INTO `vendors` VALUES ('880088', '60005', '2');
INSERT INTO `vendors` VALUES ('880088', '60006', '2');
INSERT INTO `vendors` VALUES ('880088', '60007', '2');
INSERT INTO `vendors` VALUES ('880088', '60008', '2');
INSERT INTO `vendors` VALUES ('880088', '60009', '2');
INSERT INTO `vendors` VALUES ('880088', '60010', '2');
INSERT INTO `vendors` VALUES ('880088', '60011', '2');
INSERT INTO `vendors` VALUES ('880088', '60012', '2');
INSERT INTO `vendors` VALUES ('880088', '60013', '2');
INSERT INTO `vendors` VALUES ('880088', '60014', '2');
INSERT INTO `vendors` VALUES ('880088', '60015', '2');
INSERT INTO `vendors` VALUES ('880088', '60016', '2');
INSERT INTO `vendors` VALUES ('880088', '60017', '2');
INSERT INTO `vendors` VALUES ('880088', '60018', '2');
INSERT INTO `vendors` VALUES ('880088', '60019', '2');
INSERT INTO `vendors` VALUES ('880088', '60020', '2');
INSERT INTO `vendors` VALUES ('880088', '60021', '2');
INSERT INTO `vendors` VALUES ('880088', '60022', '2');
INSERT INTO `vendors` VALUES ('880088', '60023', '2');
INSERT INTO `vendors` VALUES ('880088', '60024', '2');
INSERT INTO `vendors` VALUES ('880088', '60025', '2');
INSERT INTO `vendors` VALUES ('880088', '60000', '2');

[love236]

it still says Column count doesn't match value count at row 1 when i execute them

[nickelo]

hmm..what rev are u using..?

[love236]

what do u mean by rev? i am using ac web ultimate repack 7.3 but i am using mafiaboys database

[latruwski]

okay this is waht u do in the beginning of every one delete this INSERT INTO ITEMS' and just keep values and put this on top INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2)

that is not needed...

post the exact error message you get here... will make things easier...

post what core revision you are using.. (you can see in the top of the ascent-world.config)
post what database you are using...

edit: i just checked the updates... this is the first thing i saw for items:

alter table items add column ArenaRankRequirement int(30) not null default 0 after ItemExtendedCost;

run that query on your DB and if you still get error do the thing i posted above the edit

grtz