[Release] TCG Tabard Vendor SQL

[Bartons]

Filebeam - Free Fast File Hosting


Adds the following items to your database :

Tabard of Brilliance

Tabard of Flame

Tabard of Frost

Tabard of Fury

Tabard of Nature

Tabard of the Arcane

Tabard of the Defender

Tabard of the Void

Competitor's Tabard

To spawn the NPC that sells these items, the ID for him is 450000.

( Common GM Command : .npc spawn 450000 )


Edit :

Added Screenshot :]

[Shao111]

Nice release, +Rep

[colincancer]

nice job man

[GPUseless]

Sweet, defiantely gonna use this, +Rep EDIT:When I can

[Jrgamespot]

+rep - very nice share
i cant execute in DB though - get this error:

Query:
REPLACE INTO `creature_spawns`(`id`,`entry`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`movetype`,`displayid`,`faction`,`flags`,`bytes`,`bytes2`,`emote_state`,`npc_respawn_link`,`channel_spell`,`channel_target_sqlid`,`channel_target_sqlid_creature`,`standstate`) VALUES ( NULL,'23569','1','-2607,16','-4251,64','-2,17365','3,99454','0','21624','72','0','0','0','0','0','0','0','0','0')

Error occured at:2008-08-20 20:52:59
Line no.:320
Error Code: 1265 - Data truncated for column 'position_x' at row 1

Query:
INSERT INTO `pickpocketingloot` VALUES ('14000', '25073', '29569', '8', '0', '1', '1', '0')

Error occured at:2008-08-20 20:53:19
Line no.:205
Error Code: 1062 - Duplicate entry '14000' for key 1

Query:
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`,`ReqDisenchantSkill`,`unk2`) 
values (38310, 4, 0, -1, "Tabard of the Arcane", '0', '0', '0', 50861, 4, 0, 0, 0, 19, -1, -1, 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', '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, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, '0', '0', 0, '0', '0', '0', '0', '0', 0, '0', '0', '0', 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, -1, 0)
values (38309, 4, 0, -1, "Tabard of Nature", '0', '0', '0', 50860, 4, 0, 0, 0, 19, -1, -1, 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', '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, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, '0', '0', 0, '0', '0', '0', '0', '0', 0, '0', '0', '0', 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, -1, 0)
values (38309, 4, 0, -1, "Tabard of Nature", '0', '0', '0', 50860, 4, 0, 0, 0, 19, -1, -1, 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', '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, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, '0', '0', 0, '0', '0', '0', '0', '0', 0, '0', '0', '0', 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, -1, 0)
values (38312, 4, 0, -1, "Tabard of Brilliance", '0', '0', '0', 50686, 4, 0, 0, 0, 19, -1, -1, 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', '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, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, '0', '0', 0, '0', '0', '0', '0', '0', 0, '0', '0', '0', 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, -1, 0)
values (38313, 4, 0, -1, "Tabard of Fury", '0', '0', '0', 50859, 4, 0, 0, 0, 19, -1, -1, 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, 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, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, '0', '0', 0, '0', '0', '0', '0', '0', 0, '0', '0', '0', 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, -1, 0)
values (38314, 4, 0, -1, "Tabard of the Defender", '0', '0', '0', 50862, 4, 0, 0, 0, 19, -1, -1, 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', '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, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, '0', '0', 0, '0', '0', '0', '0', '0', 0, '0', '0', '0', 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, -1, 0)
values (38311, 4, 0, -1, "Tabard of the Void", '0', '0', '0', 50863, 4, 0, 0, 0, 19, -1, -1, 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', '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, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, '0', '0', 0, '0', '0', '0', '0', '0', 0, '0', '0', '0', 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, -1, 0)
values (36941, 4, 0, -1, "Competitor's Tabard", '0', '0', '0', 49625, 3, 0, 0, 0, 19, 262143, -1, 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, 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, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, '0', '0', 0, '0', '0', '0', '0', '0', 0, '0', '0', '0', 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, -1, 0)
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, invisibility_type, death_state)
VALUES (450000, 70, 70, 814,  5000,  5000,  5000,  1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0, 0, 0)

Error occured at:2008-08-24 14:47:24
Line no.:22
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'values (38309, 4, 0, -1, "Tabard of Nature", '0', '0', '0', 50860, 4, 0, 0, 0, 1' at line 3

Query:
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`,`ReqDisenchantSkill`,`unk2`) 
values (38310, 4, 0, -1, "Tabard of the Arcane", '0', '0', '0', 50861, 4, 0, 0, 0, 19, -1, -1, 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', '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, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, '0', '0', 0, '0', '0', '0', '0', '0', 0, '0', '0', '0', 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, -1, 0)
values (38309, 4, 0, -1, "Tabard of Nature", '0', '0', '0', 50860, 4, 0, 0, 0, 19, -1, -1, 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', '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, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, '0', '0', 0, '0', '0', '0', '0', '0', 0, '0', '0', '0', 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, -1, 0)
values (38309, 4, 0, -1, "Tabard of Nature", '0', '0', '0', 50860, 4, 0, 0, 0, 19, -1, -1, 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', '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, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, '0', '0', 0, '0', '0', '0', '0', '0', 0, '0', '0', '0', 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, -1, 0)
values (38312, 4, 0, -1, "Tabard of Brilliance", '0', '0', '0', 50686, 4, 0, 0, 0, 19, -1, -1, 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', '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, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, '0', '0', 0, '0', '0', '0', '0', '0', 0, '0', '0', '0', 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, -1, 0)
values (38313, 4, 0, -1, "Tabard of Fury", '0', '0', '0', 50859, 4, 0, 0, 0, 19, -1, -1, 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, 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, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, '0', '0', 0, '0', '0', '0', '0', '0', 0, '0', '0', '0', 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, -1, 0)
values (38314, 4, 0, -1, "Tabard of the Defender", '0', '0', '0', 50862, 4, 0, 0, 0, 19, -1, -1, 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', '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, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, '0', '0', 0, '0', '0', '0', '0', '0', 0, '0', '0', '0', 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, -1, 0)
values (38311, 4, 0, -1, "Tabard of the Void", '0', '0', '0', 50863, 4, 0, 0, 0, 19, -1, -1, 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', '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, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, '0', '0', 0, '0', '0', '0', '0', '0', 0, '0', '0', '0', 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, -1, 0)
values (36941, 4, 0, -1, "Competitor's Tabard", '0', '0', '0', 49625, 3, 0, 0, 0, 19, 262143, -1, 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, 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, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, '0', '0', 0, '0', '0', '0', '0', '0', 0, '0', '0', '0', 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, -1, 0)
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, invisibility_type, death_state)
VALUES (450000, 70, 70, 814,  5000,  5000,  5000,  1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0, 0, 0)

Error occured at:2008-08-24 14:48:30
Line no.:22
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'values (38309, 4, 0, -1, "Tabard of Nature", '0', '0', '0', 50860, 4, 0, 0, 0, 1' at line 3

help plz?

[Hellgawd]

These tabards look nice, and I didn't have them on my server. +3REP.
Thanks for this, at least the displayids!

[Bartons]

+rep - very nice share
i cant execute in DB though - get this error:

help plz?

Sorry about that, updated and fixxed. :]

[mrloewen16]

im getting an error when ever i try and execute

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'values (38309, 4, 0, -1, "Tabard of Nature", '0', '0', '0', 50860, 4, 0, 0, 0, 1' at line 5
[Err] 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`,`ReqDisenchantSkill`,`unk2`) 

values (38310, 4, 0, -1, "Tabard of the Arcane", '0', '0', '0', 50861, 4, 0, 0, 0, 19, -1, -1, 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', '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, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, '0', '0', 0, '0', '0', '0', '0', '0', 0, '0', '0', '0', 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, -1, 0)

values (38309, 4, 0, -1, "Tabard of Nature", '0', '0', '0', 50860, 4, 0, 0, 0, 19, -1, -1, 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', '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, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, '0', '0', 0, '0', '0', '0', '0', '0', 0, '0', '0', '0', 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, -1, 0)

values (38309, 4, 0, -1, "Tabard of Nature", '0', '0', '0', 50860, 4, 0, 0, 0, 19, -1, -1, 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', '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, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, '0', '0', 0, '0', '0', '0', '0', '0', 0, '0', '0', '0', 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, -1, 0)

values (38312, 4, 0, -1, "Tabard of Brilliance", '0', '0', '0', 50686, 4, 0, 0, 0, 19, -1, -1, 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', '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, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, '0', '0', 0, '0', '0', '0', '0', '0', 0, '0', '0', '0', 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, -1, 0)

values (38313, 4, 0, -1, "Tabard of Fury", '0', '0', '0', 50859, 4, 0, 0, 0, 19, -1, -1, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', '0', 0, '0', '0', 0, 0, 0, 0,
[Msg] Finished - Unsuccessfully

any sugestions?

[Bartons]

im getting an error when ever i try and execute

any sugestions?

Terribly sorry about that. It seems the main post did not update last night when I edited it. It's fixed now, sorry for the inconvenience.