[Release] Wintchman's Ascent Repack

[Wintchman11]

Ahh the illidan bug... just npc delete illidan and respawn him.. most of the 2.2 repacks have that bug.

[slyfox101]

Brewfest included in this?

(All of the items, GOs, and npcs?)

[slyfox101]

Kaitsusora, try waiting for it.

It may take more than 3 minutes. :P

[Wintchman11]

ahh no there isnt brewfest in this DB... wasnt made when the patch came out

[frobiez]

well nice repack. first to make version 2.2.0 that i know off and that i cud find. so u dont have the jail system or w.e? bummer.

[slyfox101]

Alright thanks, I apologize for the double-post, I thought I was in a different thread. :P

[Reatork]

I have this and can log in and even get in game but i cant get my TBC to work.. so i cant try out the new toons.. and i have a Blood Elf Pali on Retail. i wanted to get an idea what i would be looking forward to by checking it out on a priv..


Is there something wrong or a setting i was missing?

[Locklear]

Please explain how to set this up

[wowstorm]

Hey i have no problem setting it up Its great!. I Do although have a few problems. I Tryed Adding My custom item like i did on antrix seeing as they are basically the same. (this is it)

 
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 (95000,2,15,-1,"Life Ripper","Life Ripper","Life Ripper","Life Ripper",42286,5,0,0000,0000,13,-1,-1,250,70,0,0,0,0,0,0,0,2,1,0,3,125,7,75,4,25,31,10,0,0,0,0,0,0,0,0,0,0,0,0,167,253,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,14056,1,0,0,0,0,7598,1,0,0,0,0,14056,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"Awarded for Donating to the Server",0,0,0,0,0,1,3,0,0,0,0,150,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0);

And i sadly ended up with it error.

 
Error occured at:2007-10-05 17:31:10
Line no.:271
Error Code: 1062 - Duplicate entry '31978' 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 (91111,2,15,-1,"Life Ripper","Life Ripper","Life Ripper","Life Ripper",42286,5,0,0000,0000,13,-1,-1,250,70,0,0,0,0,0,0,0,2,1,0,3,125,7,75,4,25,31,10,0,0,0,0,0,0,0,0,0,0,0,0,167,253,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,14056,1,0,0,0,0,7598,1,0,0,0,0,14056,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"Awarded for Donating to the Server",0,0,0,0,0,1,3,0,0,0,0,150,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0)
Error occured at:2007-10-07 14:05:40
Line no.:2
Error Code: 1054 - Unknown column 'name' in 'field list'
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 (91111,2,15,-1,"Life Ripper","Life Ripper","Life Ripper","Life Ripper",42286,5,0,0000,0000,13,-1,-1,250,70,0,0,0,0,0,0,0,2,1,0,3,125,7,75,4,25,31,10,0,0,0,0,0,0,0,0,0,0,0,0,167,253,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,14056,1,0,0,0,0,7598,1,0,0,0,0,14056,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"Awarded for Donating to the Server",0,0,0,0,0,1,3,0,0,0,0,150,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0)
Error occured at:2007-10-07 14:06:13
Line no.:2
Error Code: 1054 - Unknown column 'name' in 'field list'
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 (95000,2,15,-1,"Life Ripper","Life Ripper","Life Ripper","Life Ripper",42286,5,0,0000,0000,13,-1,-1,250,70,0,0,0,0,0,0,0,2,1,0,3,125,7,75,4,25,31,10,0,0,0,0,0,0,0,0,0,0,0,0,167,253,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,14056,1,0,0,0,0,7598,1,0,0,0,0,14056,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"Awarded for Donating to the Server",0,0,0,0,0,1,3,0,0,0,0,150,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0)
Error occured at:2007-10-07 14:07:09
Line no.:2
Error Code: 1054 - Unknown column 'name' in 'field list'
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 (95000,2,15,-1,"Life Ripper","Life Ripper","Life Ripper","Life Ripper",42286,5,0,0000,0000,13,-1,-1,250,70,0,0,0,0,0,0,0,2,1,0,3,125,7,75,4,25,31,10,0,0,0,0,0,0,0,0,0,0,0,0,167,253,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,14056,1,0,0,0,0,7598,1,0,0,0,0,14056,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"Awarded for Donating to the Server",0,0,0,0,0,1,3,0,0,0,0,150,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0)
Error occured at:2007-10-07 14:07:14
Line no.:2
Error Code: 1146 - Table 'character.items' doesn't exist
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 (95000,2,15,-1,"Life Ripper","Life Ripper","Life Ripper","Life Ripper",42286,5,0,0000,0000,13,-1,-1,250,70,0,0,0,0,0,0,0,2,1,0,3,125,7,75,4,25,31,10,0,0,0,0,0,0,0,0,0,0,0,0,167,253,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,14056,1,0,0,0,0,7598,1,0,0,0,0,14056,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"Awarded for Donating to the Server",0,0,0,0,0,1,3,0,0,0,0,150,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0)
Error occured at:2007-10-07 20:57:09
Line no.:2
Error Code: 1054 - Unknown column 'name' in 'field list'

I Also need some help with some other things. i would really appreciate it I added your msn so will you reply to me on there.

[godofwar]

im not using this repack but im sure, the reason your getting these errors is one, that item number is already taken, and two if you go into the table view in heidi sql, look at the tables in items. you see name1 name2 name3 (if it says just name instead of name1, alter it and make it say name1, if it just says name1 then change it to just name.) that should fix your problem

[wowstorm]

HeidiSQL? I use SQLyog or Navicat Sorry i just transfered from antrix and i didn't think it mattered seeing as they and ascent are basically the same. So does this mean the WoW-V doesn't work for Ascent?. And Does Anyone know how to make Shop Price's 0 for all items not just vendors, got to get rid of the attunement need and how to get rid of Rep /Signets and other items [Example: Need Exhalted Or need 20 WSG Tickets to buy it] Thank You.

[Dartillus]

Can anyone tell me what version client you need for this, which patches you need, and where I can download them?

[Wintchman11]

Well its set for any of the newest patches atm, even the one that just came out today.

[Dartillus]

I've got another problem. At my own place, I set up the server, and I was able to log in. But now I'm at my sisters place, and I've copied the WoW client I used to log in to her pc. I've installed Hamachi, and joined the appropriate network thats running at my place. But when I start WoW up here, I can log in, and choose a realm, but then it throws me back into the Choose A Realm screen the whole time. When I click cancel, I cannot create a character.

Any ideas?

[Wintchman11]

hmm... either your server is timing out or your sisters connection is timing out. That or your impatient and not waiting long enough