RaGEZONE sponsored advertisment:
| | Would you like your advertisement banner here? Perfect exposure for your world of warcraft server! click the banner to email me today! | |
07-10-2007
|
#351 (permalink)
| | Average Member
Rank: Hobbit
Join Date: Aug 2006
Posts: 50
Thanked 0 Times in 0 Posts
| Re: [MaNGOS] Latest binaries and SDB (With no support questions! Only files)
Does anyone have the 2.1.2 dbc files?
|
| |
07-10-2007
|
#352 (permalink)
| | Average Member
Rank: Hobbit
Join Date: Feb 2007
Posts: 72
Thanked 0 Times in 0 Posts
| Re: [MaNGOS] Latest binaries and SDB (With no support questions! Only files) Here is a new release for mangos 4063 2.1.2 for rev 10 of silvermoon with scriptdev2 69 + other patches
Warning : haven t tested yet, i still use 4045, there might be some issues between 2.1.2 and mangos core if you want to be brave and be the first to adop here it is ;) (this is now an official change btw not a patch). Removed pet patch, lets see how this works now
This is now version 0.8 of mangos : black temple alpha branch Main changes : Vmaps included in mangos now and wow is now at version 2.1.2. You will have to build new maps and vmaps.
changelog for 4063: Important : VMaPS are now built into mangos by default, please rebuild if upgrading from 4045!!! http://www.mangosproject.org/ChangeLog.xml
This contains my rogue patch (fixed for new invisibility system )+ my new vmap additions for stealthing near enemies behind walls, fixing most issue with rogue including vanish, sap, gouge blind, stealth issues etc
and it includes the latest scriptdev 69 (add life, magic and ai to bosses)
This includes my frostbolt patch (add slowdown for spell frostbolt as official).
This includes the pounce and garrot patch, the auction house 4.4 and moregroup info patch allowing to see team members outside normal reach. And finally adding the autoshoot patch for hunter + my readiness talent patch. (these patches where most of them made by other excellent programmers, their work is really appreciated!!!)
Note: Make sure u use the simple vmap bat file in the wow dir to create the new vmaps that need to be put in mangos dir.
Do no forgot to use the mangosd.conf included as it has some added info needed for the vmaps. Added also the ad.exe to create maps from client. Download
Core download 4063 Filebeam - Free Fast File Hosting Silvermoon db rev 10 Filebeam - Free Fast File Hosting new realmd + update (as of 3939) not required if upgrading from 3969) Filebeam - Free Fast File Hosting
Mangos bible for 2.0.12 all info related to mangos, not all was made by me most of it was taken from numerous sites, but is essential. Filebeam - Free Fast File Hosting
Don t forget to update the latest sql files. Please use silvermoons rev 10 db as the pet patch is almost all included except update 5 included!!
ps: use regular dbc and maps as other releases for 2.0.12. For database use silvermoons db rev 10 or older or other already posted db on these pages. How to use auction bot :
From Chris K :
Step 1.) Create a character that you are going to use as the auction house bot character. This character will be the auction's owner for all the items created by the bot.
Step 2.) Go into the realm database and note the account number for the character.
Step 3.) Go into the mangos database and note the character's GUID.
Step 4:) Modify the mangos ini with this information.
Step 5.) Log in at least once with this character.
|
| |
07-10-2007
|
#353 (permalink)
| | The Omega
Rank: Member
Join Date: May 2006 Location: InComputer
Posts: 123
Thanked 0 Times in 0 Posts
| Re: [MaNGOS] Latest binaries and SDB (With no support questions! Only files)
downloaded and on the test :=)
{ ---- plus ---- }
excuse me, vmaps and maps still building and not be tryed. i don't see dbc folder and files, this version, we don't need this ?
__________________ Life for NOTHING .... 
Last edited by efsanekan71; 07-10-2007 at 06:34 PM.
Reason: plus!
|
| |
07-10-2007
|
#354 (permalink)
| | The Omega
Rank: Member
Join Date: Apr 2006 Location: Mexico
Posts: 103
Thanked 0 Times in 0 Posts
| Re: [MaNGOS] Latest binaries and SDB (With no support questions! Only files)
Yes you need em, but you gotta extract em for your own.
|
| |
07-10-2007
|
#355 (permalink)
| | Average Member
Rank: Hobbit
Join Date: Aug 2006
Posts: 50
Thanked 0 Times in 0 Posts
| Re: [MaNGOS] Latest binaries and SDB (With no support questions! Only files)
|
Originally Posted by Krayhan | |
Does anyone have the 2.1.2 dbc files?
| No need anymore i extracted them myself.
|
| |
07-11-2007
|
#356 (permalink)
| | Monster Member
Rank: Member
Join Date: Sep 2005 Location: Armenia - Yerevan
Posts: 197
Thanked 0 Times in 0 Posts
| Re: [MaNGOS] Latest binaries and SDB (With no support questions! Only files)
|
Originally Posted by student1 | | Here is a new release for mangos 4063 2.1.2 for rev 10 of silvermoon with scriptdev2 69 + other patches
Warning : haven t tested yet, i still use 4045, there might be some issues between 2.1.2 and mangos core if you want to be brave and be the first to adop here it is ;) (this is now an official change btw not a patch). Removed pet patch, lets see how this works now
This is now version 0.8 of mangos : black temple alpha branch Main changes : Vmaps included in mangos now and wow is now at version 2.1.2. You will have to build new maps and vmaps.
changelog for 4063: Important : VMaPS are now built into mangos by default, please rebuild if upgrading from 4045!!! http://www.mangosproject.org/ChangeLog.xml
This contains my rogue patch (fixed for new invisibility system )+ my new vmap additions for stealthing near enemies behind walls, fixing most issue with rogue including vanish, sap, gouge blind, stealth issues etc
and it includes the latest scriptdev 69 (add life, magic and ai to bosses)
This includes my frostbolt patch (add slowdown for spell frostbolt as official).
This includes the pounce and garrot patch, the auction house 4.4 and moregroup info patch allowing to see team members outside normal reach. And finally adding the autoshoot patch for hunter + my readiness talent patch. (these patches where most of them made by other excellent programmers, their work is really appreciated!!!)
Note: Make sure u use the simple vmap bat file in the wow dir to create the new vmaps that need to be put in mangos dir.
Do no forgot to use the mangosd.conf included as it has some added info needed for the vmaps. Added also the ad.exe to create maps from client. Download
Core download 4063 Filebeam - Free Fast File Hosting Silvermoon db rev 10 Filebeam - Free Fast File Hosting new realmd + update (as of 3939) not required if upgrading from 3969) Filebeam - Free Fast File Hosting
Mangos bible for 2.0.12 all info related to mangos, not all was made by me most of it was taken from numerous sites, but is essential. Filebeam - Free Fast File Hosting
Don t forget to update the latest sql files. Please use silvermoons rev 10 db as the pet patch is almost all included except update 5 included!!
ps: use regular dbc and maps as other releases for 2.0.12. For database use silvermoons db rev 10 or older or other already posted db on these pages. How to use auction bot :
From Chris K :
Step 1.) Create a character that you are going to use as the auction house bot character. This character will be the auction's owner for all the items created by the bot.
Step 2.) Go into the realm database and note the account number for the character.
Step 3.) Go into the mangos database and note the character's GUID.
Step 4:) Modify the mangos ini with this information.
Step 5.) Log in at least once with this character.
| Hi Student Thank you for share mangos Revs . i really wish you more luck
and please if you can attach DBC folder for 2.1.2
(i download Core download 4063 and when i extrat rar File: <<libeay32.dll>> was missed File is Corrupted ! Please if you can Creat archive again and share it ) Thenks a lot !
|
| |
07-11-2007
|
#357 (permalink)
| | Newbie
Rank: Hobbit
Join Date: Feb 2007
Posts: 17
Thanked 0 Times in 0 Posts
| Re: [MaNGOS] Latest binaries and SDB (With no support questions! Only files) |
| |
07-11-2007
|
#358 (permalink)
| | Member
Rank: Hobbit
Join Date: May 2007
Posts: 33
Thanked 1 Time in 1 Post
| Re: [MaNGOS] Latest binaries and SDB (With no support questions! Only files)
How to Entraxt them?
i mean how to make the DBC files?
|
| |
07-11-2007
|
#359 (permalink)
| | Average Member
Rank: Hobbit
Join Date: Aug 2006
Posts: 50
Thanked 0 Times in 0 Posts
| Re: [MaNGOS] Latest binaries and SDB (With no support questions! Only files)
DBC Extract: Filebeam - Free Fast File Hosting
i uploaded the file to extract, mine is enUS if you want enGB just change it in the batch file. The newest ad.exe you can find here https://svn.mangosproject.org/trac/M.../map_extractor
Post updated the dll file is inclued now
Last edited by Krayhan; 07-18-2007 at 01:31 AM.
|
| |
07-12-2007
|
#360 (permalink)
| | The Omega
Rank: Member
Join Date: May 2006 Location: InComputer
Posts: 123
Thanked 0 Times in 0 Posts
| Re: [MaNGOS] Latest binaries and SDB (With no support questions! Only files) Rew Release For ManGos Core 4079 + Rev 10 of Silvermoon DB with ScriptDev2 69 + VMap Support + DBC 2.1.3 + Other Patches Game Client Support To 2.1.3
{ Build by e[R]dem.dogan } ------> Mangos 4079 Core Download Link; Filebeam - Free Fast File Hosting ------> Silvermoon Rev 10 DB Download Link; Filebeam - Free Fast File Hosting
Mangos 4079 Changelog --->
Corrected unlimited gain of combopoints. Fixed spelling in mangosd.conf
[/SIZE][/SIZE]
{ --- plus! ---}
Note : Mem Usage some high!
__________________ Life for NOTHING .... 
Last edited by efsanekan71; 07-12-2007 at 01:31 PM.
Reason: plus!
|
| |
07-12-2007
|
#361 (permalink)
| | Newbie
Rank: Hobbit
Join Date: Jun 2006 Location: Where you live
Posts: 1
Thanked 0 Times in 0 Posts
| Re: [MaNGOS] Latest binaries and SDB (With no support questions! Only files)
thanks
|
| |
07-12-2007
|
#362 (permalink)
| | Newbie
Rank: Hobbit
Join Date: Jan 2007
Posts: 3
Thanked 0 Times in 0 Posts
| Re: [MaNGOS] Latest binaries and SDB (With no support questions! Only files)
@student1: can you please update your client to 4079 with auctionhouse bot and rougepatch e.t.c, since efsanekan71's Version doesn't contain these patches.
Or can I use your latest rev for 2.1.3 as well?
|
| |
07-12-2007
|
#363 (permalink)
| | The Omega
Rank: Member
Join Date: May 2006 Location: InComputer
Posts: 123
Thanked 0 Times in 0 Posts
| Re: [MaNGOS] Latest binaries and SDB (With no support questions! Only files)
ah bot already running :=)
[quote] :
How to use auction bot :
From Chris K :
Step 1.) Create a character that you are going to use as the auction house bot character. This character will be the auction's owner for all the items created by the bot.
Step 2.) Go into the realm database and note the account number for the character.
Step 3.) Go into the mangos database and note the character's GUID.
Step 4:) Modify the mangos ini with this information.
Step 5.) Log in at least once with this character.
,
try this and u can see that's working :=)
and rog patch already on server core side :=)
__________________ Life for NOTHING ....  |
| |
07-12-2007
|
#364 (permalink)
| | Newbie
Rank: Hobbit
Join Date: Jan 2007
Posts: 3
Thanked 0 Times in 0 Posts
| Re: [MaNGOS] Latest binaries and SDB (With no support questions! Only files)
Yeah right, in student1's Version it is implemented!
In yours, too?!
Cause your mangosd.conf is missing the following passage, then:
# Auction House Bot
AuctionHouseBot.Account = 0
AuctionHouseBot.GUID = 0
AuctionHouseBot.AllianceItems = 0
AuctionHouseBot.HordeItems = 0
AuctionHouseBot.NeutralItems = 0
AuctionHouseBot.MinTime = 8
AuctionHouseBot.MaxTime = 24
AuctionHouseBot.PercentWhiteTradeGoods = 30
AuctionHouseBot.PercentGreenTradeGoods = 13
AuctionHouseBot.PercentBlueTradeGoods = 9
AuctionHouseBot.PercentPurpleTradeGoods = 1
AuctionHouseBot.PercentWhiteItems = 6
AuctionHouseBot.PercentGreenItems = 30
AuctionHouseBot.PercentBlueItems = 9
AuctionHouseBot.PercentPurpleItems = 2
AuctionHouseBot.MinPriceWhite = 150
AuctionHouseBot.MaxPriceWhite = 250
AuctionHouseBot.BidPriceWhite = 100
AuctionHouseBot.MinPriceGreen = 200
AuctionHouseBot.MaxPriceGreen = 300
AuctionHouseBot.BidPriceGreen = 100
AuctionHouseBot.MinPriceBlue = 250
AuctionHouseBot.MaxPriceBlue = 350
AuctionHouseBot.BidPriceBlue = 100
AuctionHouseBot.MinPricePurple = 300
AuctionHouseBot.MaxPricePurple = 450
AuctionHouseBot.BidPricePurple = 100
So is it implemented in your build or not. :biggrin:
This was my question and the reason for my post.
GreetZ
|
| |
07-12-2007
|
#365 (permalink)
| | Newbie
Rank: Hobbit
Join Date: Jul 2007
Posts: 8
Thanked 0 Times in 0 Posts
| Re: [MaNGOS] Latest binaries and SDB (With no support questions! Only files)
When i extract using mpqe.exe (i had to find sfmpq.dll somewhere else too) I get an error patch-enus-2.mpq the syntax of the command is not correct.
When i run mangosd i get errors like:
2007-07-12 12:17:37 Initialize data stores...
2007-07-12 12:17:37 ERROR:
Some required *.dbc files (19 from 35) not found or not compatible:
./dbc/AreaTable.dbc (exist, but have 35 fields instead 27) Wrong client version DBC file?
./dbc/BattlemasterList.dbc (exist, but have 32 fields instead 24) Wrong client version DBC file?
./dbc/ChatChannels.dbc (exist, but have 37 fields instead 21) Wrong client version DBC file?
./dbc/ChrClasses.dbc (exist, but have 24 fields instead 18) Wrong client version DBC file?
./dbc/ChrRaces.dbc (exist, but have 35 fields instead 27) Wrong client version DBC file?
./dbc/CreatureFamily.dbc (exist, but have 26 fields instead 18) Wrong client version DBC file?
./dbc/Faction.dbc (exist, but have 53 fields instead 37) Wrong client version DBC file?
./dbc/ItemRandomProperties.dbc (exist, but have 24 fields instead 16) Wrong client version DBC file?
./dbc/ItemRandomSuffix.dbc (exist, but have 25 fields instead 17) Wrong client version DBC file?
./dbc/ItemSet.dbc (exist, but have 53 fields instead 45) Wrong client version DBC file?
./dbc/Map.dbc (exist, but have 123 fields instead 75) Wrong client version DBC file?
./dbc/SkillLine.dbc (exist, but have 38 fields instead 22) Wrong client version DBC file?
./dbc/Spell.dbc (exist, but have 211 fields instead 179) Wrong client version DBC file?
./dbc/SpellItemEnchantment.dbc (exist, but have 34 fields instead 26) Wrong client version DBC file?
./dbc/SpellRange.dbc (exist, but have 38 fields instead 22) Wrong client version DBC file?
./dbc/TalentTab.dbc (exist, but have 23 fields instead 15) Wrong client version DBC file?
./dbc/TaxiNodes.dbc (exist, but have 24 fields instead 16) Wrong client version DBC file?
./dbc/TaxiPathNode.dbc (exist, but have 11 fields instead 9) Wrong client version DBC file?
./dbc/WorldSafeLocs.dbc (exist, but have 22 fields instead 14) Wrong client version DBC file?
Does any one have the 2.1.2 DBC? I've been trying to extract it and maybe someone already has it uploaded somewhere? Thanks!
|
| |
07-13-2007
|
#366 (permalink)
| | Newbie
Rank: Hobbit
Join Date: Sep 2005
Posts: 2
Thanked 0 Times in 0 Posts
| Re: [MaNGOS] Latest binaries and SDB (With no support questions! Only files)
Working DBC files for 2.1.3 TBC here |
| |
07-13-2007
|
#367 (permalink)
| | RaGEZONER
Rank: Hobbit
Join Date: May 2005 Location: In the darkness...
Posts: 85
Thanked 0 Times in 0 Posts
| Re: [MaNGOS] Latest binaries and SDB (With no support questions! Only files)
|
Originally Posted by LMuri | |
Working DBC files for 2.1.3 TBC here | thanks a lot dude
|
| |
07-13-2007
|
#368 (permalink)
| | Newbie
Rank: Hobbit
Join Date: Jul 2007
Posts: 8
Thanked 0 Times in 0 Posts
| Re: [MaNGOS] Latest binaries and SDB (With no support questions! Only files)
thanks, let me give these dbc a try.
|
| |
07-13-2007
|
#369 (permalink)
| | Newbie
Rank: Hobbit
Join Date: Jul 2007
Posts: 8
Thanked 0 Times in 0 Posts
| Re: [MaNGOS] Latest binaries and SDB (With no support questions! Only files)
One more question, I got it work , but I can not select the new tbc characters like blood elves. It's like TBC is gone or something. I can't teleport to silvermoon, it says that I don't have TBC installed (and of course i do). Anyone else having this problem? Any suggestions?
|
| |
07-13-2007
|
#370 (permalink)
| | Newbie
Rank: Hobbit
Join Date: Oct 2005
Posts: 3
Thanked 0 Times in 0 Posts
| Re: [MaNGOS] Latest binaries and SDB (With no support questions! Only files)
You have to go into the database realmd and select your account and under the tbc column put 1.
|
| |
07-13-2007
|
#371 (permalink)
| | Newbie
Rank: Hobbit
Join Date: Jul 2007
Posts: 8
Thanked 0 Times in 0 Posts
| Re: [MaNGOS] Latest binaries and SDB (With no support questions! Only files)
Great thanks again.
|
| |
07-13-2007
|
#372 (permalink)
| | Newbie
Rank: Hobbit
Join Date: Feb 2007
Posts: 9
Thanked 0 Times in 0 Posts
| Re: [MaNGOS] Latest binaries and SDB (With no support questions! Only files)
|
Originally Posted by peewee1 | |
One more question, I got it work , but I can not select the new tbc characters like blood elves. It's like TBC is gone or something. I can't teleport to silvermoon, it says that I don't have TBC installed (and of course i do). Anyone else having this problem? Any suggestions?
| Easier solve than GenDeathRaiser's:
Mangosd.exe,command line: setbc <accountname> 1
Whoila:punk:
|
| |
07-13-2007
|
#373 (permalink)
| | Newbie
Rank: Hobbit
Join Date: Jul 2007
Posts: 1
Thanked 0 Times in 0 Posts
| Re: [MaNGOS] Latest binaries and SDB (With no support questions! Only files)
Hi . Need help.
I`ve tried the 4063 and 4079 core , both with sdb rev 10. when i open mangosd.exe, I get this error:
| | Quote: |
2007-07-13 12:37:58 Using configuration file mangosd.conf.
2007-07-13 12:37:58 MaNGOS daemon /0.8-SVN (Win32)
2007-07-13 12:37:58 <Ctrl-C> to stop.
MM MM MM MM MMMMM MMMM MMMMM
MM MM MM MM MMM MMM MM MM MMM MMM
MMM MMM MMM MM MMM MMM MM MM MMM
MM M MM MMMM MM MMM MM MM MMM
MM M MM MMMMM MM MMMM MMM MM MM MMM
MM M MM M MMM MM MMM MMMMMMM MM MM MMM
MM MM MMM MM MM MM MMM MM MM MMM
MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
MM MM MM MMM MM MM MMMMMM MMMM MMMMM
MM MMM MaNGOS community forums (Powered by Invision Power Board)
MMMMMM
2007-07-13 12:37:58 World Database: 127.0.0.1;3306;root;pass;mangos
2007-07-13 12:37:58 Login Database: 127.0.0.1;3306;root;pass;mangos
2007-07-13 12:37:58 Realm running as realm ID 1
2007-07-13 12:37:58 ERROR:SQL: UPDATE `account`,`realmcharacters` SET `account`.`online` = 0 WHERE `account`.`online` > 0 AND `account`.`id` = `realmcharacters`.`acctid` AND `realmcharacters`.`realmid` = '1'
2007-07-13 12:37:58 ERROR:SQL ERROR: Table 'mangos.account' doesn't exist
2007-07-13 12:37:59 Using DataDir ./
2007-07-13 12:37:59 WORLD: VMap support included. LineOfSight:0, getHeight:0
2007-07-13 12:37:59 WORLD: VMap data directory is: ./vmaps
2007-07-13 12:37:59 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2007-07-13 12:37:59 ERROR:SQL: UPDATE `realmlist` SET `icon` = 4 WHERE `id` = '1'
2007-07-13 12:37:59 ERROR:SQL ERROR: Table 'mangos.realmlist' doesn't exist
2007-07-13 12:37:59 Initialize data stores...
2007-07-13 12:38:01
2007-07-13 12:38:01 >> Loaded 35 data stores
2007-07-13 12:38:01
2007-07-13 12:38:01 Using DBC Locale From Config (0).
2007-07-13 12:38:01 Cleaning up instances...
2007-07-13 12:38:02
2007-07-13 12:38:02 >> Initialized 0 instances, deleted 0 old instances
2007-07-13 12:38:02 Packing instances...
2007-07-13 12:38:02
2007-07-13 12:38:02 >> Instance numbers remapped, next instance id is 1
2007-07-13 12:38:02 Loading Game Object Templates...
2007-07-13 12:38:03 >> Loaded 12157 game object templates
2007-07-13 12:38:03
2007-07-13 12:38:03 Loading Spell Chain Data...
2007-07-13 12:38:03
2007-07-13 12:38:03 >> Loaded 1914 spell chain records
2007-07-13 12:38:03 Loading Spell Learn Skills...
2007-07-13 12:38:03 ERROR:Spell 3386 listed in `spell_learn_skill` not exist
2007-07-13 12:38:03
2007-07-13 12:38:03 >> Loaded 44 spell learn skills + found in DBC 74
2007-07-13 12:38:03 Loading Spell Learn Spells...
2007-07-13 12:38:03
2007-07-13 12:38:03 >> Loaded 40 spell learn spells + found in DBC 5930
2007-07-13 12:38:03 Loading Spell Proc Event conditions...
2007-07-13 12:38:03 ERROR:SQL: SELECT `entry`,`SchoolMask`,`Category`,`SkillID`,`SpellFa milyName`,`SpellFamilyMask`,`procFlags`,`ppmRate` FROM `spell_proc_event`
2007-07-13 12:38:03 ERROR:query ERROR: Unknown column 'SpellFamilyName' in 'field list'
2007-07-13 12:38:03
2007-07-13 12:38:03 >> Loaded 0 spell proc event conditions
2007-07-13 12:38:03 Loading Aggro Spells Definitions...
2007-07-13 12:38:03 >> Loaded 101 aggro generating spells
2007-07-13 12:38:03
2007-07-13 12:38:03 Loading NPC Texts...
2007-07-13 12:38:04
2007-07-13 12:38:04 >> Loaded 3687 npc texts
2007-07-13 12:38:04 Loading Items...
2007-07-13 12:38:12 ERROR:Error in `item_template` table, probably sql file format was updated (there should be 132 fields in sql).
| I tried to get a sql dump for item_template table from other revs, even googlesearch it. all had round 119-120 fields. what should I do?
|
| |
07-13-2007
|
#374 (permalink)
| | It's Me
Rank: Member + Join Date: Dec 2003 Location: Netherlands
Posts: 975
Thanked 0 Times in 0 Posts
| Re: [MaNGOS] Latest binaries and SDB (With no support questions! Only files)
fucking NOOBS read the FUCKING RULES OF THIS TOPIC NO SUPORT IN THIS TOPIC MAKE AN FUCKING NEW TOPIC FOR SUPORT .
Sorry for the ruthness but you fucking noobs cant read aperently .
Delete this post as well when cleaning topic please .
|
| |
07-13-2007
|
#375 (permalink)
| | Newbie
Rank: Hobbit
Join Date: Sep 2005
Posts: 2
Thanked 0 Times in 0 Posts
| Re: [MaNGOS] Latest binaries and SDB (With no support questions! Only files)
Problem with item_template: U must update your Database with Mangos core update, the files its called 4058.sql or use this Code: ALTER TABLE `item_template` ADD COLUMN `ArmorDamageModifier` float NOT NULL default '0' AFTER `RequiredDisenchantSkill`;
ALTER TABLE `item_template` DROP COLUMN `name2`, DROP COLUMN `name3`, DROP COLUMN `name4`;
and this Code: DELETE FROM `spell_affect` WHERE `entry` in(11370,12288,12288,12707,12707,14067,15019,16183,16823,16823,16825,16825,17325,18310,18311,18312,18313,29860,29861,29862,30440,30640,30649,33216,33217,34301);
DELETE FROM `spell_proc_event` WHERE `entry` in(****637,646,648,1028,1034,1048,1707,2095,2852,4051,4161,4512,5575,5580,6134,6135,6592,6593,7601,7614,7615,7616,7618,9205,9793,97***9801,9808,10095,10400,10727,10868,11830,11838,11961,12002,12038,12094,12546,12552,13078,13260,13320,13767,13987,14095,14150,14152,14154,15364,15365,15567,15568,15569,15644,15650,16140,16241,16242,16311,16312,16313,16423,16563,16925,16926,16955,16956,16957,16962,16963,16964,17000,17001,17079,17082,19195,19234,19235,19389,19390,193***19640,20163,20169,20183,20204,20411,20412,20413,20414,20419,20421,20422,20423,20563,20809,208***21387,21789,22283,22285,22286,22287,22288,226***22716,23255,23301,23303,23305,23306,25592,25715,25727,25728,25729,25730,25731,257***25733,25734,25745,25751,25752,25757,25926,25942,25945,26341,28130,28881,29526);
|
| | |