Wow Band :d :d

[Chrispee]

so guys i decided to make the wow band as an sql since they arent in most db here u go :


Link : Filebeam - Free Fast File Hosting
Band ids :112233
112244
112255
112266
112277

Stage id :888884

[Rizzano]

Can't see the url for the image.

EDIT: Never mind, for some reason the image wasn't showing up here but now it is.

[crwilborn]

woot..awesome +rep

[Rizzano]

oo, yeah, forgot to add rep, +rep from me too. Nice work!

[vanyali]

not workin for me i get the
There was an error while executing a query.
The query and the error message has been logged at:
C:\Program Files\SQLyog Community\sqlyog.err.
Please click on "Open Error File..." to open the error file.

thingie, tell me please i rilly wanna do this

[Banksey]

It'd help if you posted the error file

[friendofdar]

Kewl even thoungh it comes in ur database

[vanyali]

oh yeah sorry >.<

Query:
CREATE TABLE `ai_threattospellid` (
 `spellId` int(5) NOT NULL default '0',
 `mod` int(5) NOT NULL default '0',
 PRIMARY KEY  (`spellId`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2007-07-26 03:00:08
Line no.:18
Error Code: 1050 - Table 'ai_threattospellid' already exists

Query:
CREATE TABLE `ai_threattospellid` (
 `spellId` int(5) NOT NULL default '0',
 `mod` int(5) NOT NULL default '0',
 PRIMARY KEY  (`spellId`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2007-07-26 03:00:16
Line no.:18
Error Code: 1050 - Table 'ai_threattospellid' already exists

Query:
CREATE TABLE `accounts` (
 `acct` bigint(20) NOT NULL auto_increment,
 `login` varchar(255) NOT NULL default '',
 `password` varchar(28) NOT NULL default '',
 `gm` varchar(27) NOT NULL default '',
 `banned` int(30) NOT NULL default '0',
 `lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
 `lastip` varchar(15) NOT NULL default '',
 `email` varchar(50) NOT NULL default '',
 `flags` int(11) NOT NULL default '0',
 PRIMARY KEY  (`acct`,`login`),
 UNIQUE KEY `acct` (`acct`)
 ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1

Error occured at:2007-09-22 05:33:04
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

Query:
CREATE TABLE `accounts` (
 `acct` bigint(20) NOT NULL auto_increment,
 `login` varchar(255) NOT NULL default '',
 `password` varchar(28) NOT NULL default '',
 `gm` varchar(27) NOT NULL default '',
 `banned` int(30) NOT NULL default '0',
 `lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
 `lastip` varchar(15) NOT NULL default '',
 `email` varchar(50) NOT NULL default '',
 `flags` int(11) NOT NULL default '0',
 PRIMARY KEY  (`acct`,`login`),
 UNIQUE KEY `acct` (`acct`)
 ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1

Error occured at:2007-09-22 05:33:33
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

Query:
CREATE TABLE `accounts` (
 `acct` bigint(20) NOT NULL auto_increment,
 `login` varchar(255) NOT NULL default '',
 `password` varchar(28) NOT NULL default '',
 `gm` varchar(27) NOT NULL default '',
 `banned` int(30) NOT NULL default '0',
 `lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
 `lastip` varchar(15) NOT NULL default '',
 `email` varchar(50) NOT NULL default '',
 `flags` int(11) NOT NULL default '0',
 PRIMARY KEY  (`acct`,`login`),
 UNIQUE KEY `acct` (`acct`)
 ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1

Error occured at:2007-09-22 10:39:12
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

Query:
INSERT INTO items (entry, class, subclass, field4, name, 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 (9000052,2,10,-1,"Flaming eye of the drake","Flaming eye of the drake","Flaming eye of the drake","Flaming eye of the drake",41560,4,0,2000000,1000000,17,128,-1,100,70,0,0,0,0,0,0,0,1,1,0,21,24,5,56,7,39,6,45,0,0,0,0,0,0,0,0,0,0,0,0,200,300,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,50,100,0,0,3000,0,0,21230,1,0,0,0,0,21230,1,0,0,0,0,21230,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,"empowered by the eye of raaklaks",0,0,0,0,0,1,2,0,0,0,0,200,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

Error occured at:2007-09-26 22:46:31
Line no.:2
Error Code: 1062 - Duplicate entry '9000052' for key 1

Query:
INSERT INTO items (entry, class, subclass, field4, name, 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 (9000085,4,1,-1,"arcana gloves","arcana gloves","arcana gloves","arcana gloves",31028,4,0,2000000,1000000,10,128,-1,145,75,0,0,0,0,0,0,0,1,1,0,5,46,7,45,6,31,21,21,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,235,0,0,0,0,0,50,0,0,0,42184,1,0,0,0,0,36430,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"streaming with the power of the arcana",0,0,0,0,0,7,0,0,0,0,0,85,0,0,0,0,0,0,0,0,2,0,2865,0,0,0,0)

Error occured at:2007-09-26 22:47:00
Line no.:26
Error Code: 1062 - Duplicate entry '9000085' for key 1

Query:
INSERT INTO items (entry, class, subclass, field4, name, 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 (9000056,2,4,-1,"Sun reflector","Sun reflector","Sun reflector","Sun reflector",35250,4,0,2000000,1000000,13,16,-1,100,70,0,0,0,0,0,0,0,1,1,0,5,60,6,45,7,29,24,30,0,0,0,0,0,0,0,0,0,0,0,0,100,200,5,0,0,0,0,0,0,0,0,0,0,0,0,0,100,0,0,0,50,0,2500,0,0,37379,1,0,0,0,0,18017,1,0,0,0,0,15317,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,"reflects the sun",0,0,0,0,0,1,3,0,0,0,0,100,0,0,0,0,8,0,0,0,0,0,2865,0,0,0,0)

Error occured at:2007-09-26 22:47:36
Line no.:2
Error Code: 1062 - Duplicate entry '9000056' for key 1

Query:
CREATE TABLE `account_data` (
 `account_id` int(30) NOT NULL,
 `uiconfig0` longtext,
 `uiconfig1` longtext,
 `uiconfig2` longtext,
 `uiconfig3` longtext,
 `uiconfig4` longtext,
 `uiconfig5` longtext,
 `uiconfig6` longtext,
 `uiconfig7` longtext,
 `uiconfig8` longtext,
 PRIMARY KEY  (`account_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1

Error occured at:2007-09-27 17:15:52
Line no.:26
Error Code: 1050 - Table 'account_data' already exists

Query:
INSERT INTO gameobject_names VALUES('600002','22','1327','The Mall\'s Arena','12520','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0')

Error occured at:2007-09-27 19:52:21
Line no.:34
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO gameobject_names VALUES('600002','22','1327','The Mall\'s Arena','12520','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0')

Error occured at:2007-09-27 19:54:40
Line no.:34
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO creature_proto VALUES (11000000,  255, 814,  9999999,  9999999,  1, 16388, 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)

Error occured at:2007-09-27 19:57:59
Line no.:7
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO creature_proto VALUES (50083, 100, 1741, 1000000, 1000000, 0.55, 4, 1000, 1000, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0)

Error occured at:2007-09-27 19:59:45
Line no.:3
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO creature_proto (entry, level, faction, health, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)
 VALUES (90010,  80, 1741,  500000000000000000,  500000000000000000000000000,  1, 16388, 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)

Error occured at:2007-09-27 20:18:50
Line no.:29
Error Code: 1054 - Unknown column 'money' in 'field list'

Query:
INSERT INTO creature_proto VALUES (50005, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0)

Error occured at:2007-09-27 20:27:52
Line no.:68
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO creature_proto
 (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money, invisibility_type, death_state)
 VALUES
 (112233, 73, 73, 474, 9999999, 9999999, 999999, 1, 16388, 500, 1500, 3000, 2000, 2000, 2500, 0, 45479, 45479, 45479, 45481, 45481, 45481, 45481, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 2, "0", 1, 0, 0, 0)

Error occured at:2007-09-27 20:42:50
Line no.:10
Error Code: 1054 - Unknown column 'minlevel' in 'field list'

Query:
INSERT `creature_names` VALUES ('112233', 'Chief Thunder','L70ETC', '0', '2', '0', '2', '0', null, ' 21665', '1', '1', '0', null)

Error occured at:2007-09-27 20:43:20
Line no.:1
Error Code: 1062 - Duplicate entry '112233' for key 1

Query:
INSERT `creature_names` VALUES ('112233', 'Chief Thunder','L70ETC', '0', '2', '0', '2', '0', null, ' 21665', '1', '1', '0', null)

Error occured at:2007-09-27 21:25:27
Line no.:1
Error Code: 1062 - Duplicate entry '112233' for key 1

BTW didnt know which part to copy so

EDIT: EEK sorry, didnt see i had it

[Chrispee]

guys this works 100% with my db so...

[Clixer]

Thay had these on the server Burning Wow Realm Netherstorm for a special event.
they are kool

[hainzey]

nice one thnx

[Quick$ilver]

Make them play powered to the horde.

.playall 11803

[killerkid3029]

yea i get an error every time i try this

[KeyMaster45]

can sombody plz post how to import this into the database, trying to input it manually but i dont have some of the fields listed in the file or the fields aren't in the correct order.

[yoyo10105]

YAY!!! IT WORKS!!! +rep