Well there are a lot of people complaining how their MySQL won't start, well guys you heard the man !Quote:
DO NOT CONTINUE UNTIL YOU HAVE THE SERVER FOLDER DIRECTLY UNDER THE C:\ DRIVE!!!
TRM tell 'em !!! xD
+rep
Printable View
Well there are a lot of people complaining how their MySQL won't start, well guys you heard the man !Quote:
DO NOT CONTINUE UNTIL YOU HAVE THE SERVER FOLDER DIRECTLY UNDER THE C:\ DRIVE!!!
TRM tell 'em !!! xD
+rep
Nice work again TRM as always +rep Also loving the new Panoramic Views.
For some reason I can't download this ... :/
TRM excellent work as always. Your a friggen genius man :)
Good to see you're doing well TRM :) Glad to see you've released a new repack.
Mangosd won't load if vmaps are enabled, any ideas why is this happening ?
Did you extract the vmaps? Here's the newest extractor for them, place the extracted files from it in your World of Warcraft/Data/enUS folder then double-click the makevmaps_SIMPLE.bat fileQuote:
Originally Posted by marko94
vmap_extract_assembler_bin.zip (267.84 KB)
Then make sure the lines in your mangosd.conf file look like this:
Tested and works great...Code:vmap.enableLOS = 1
vmap.enableHeight = 1
...
DetectPosCollision = 1
http://img24.imageshack.us/img24/1296/vmaps.jpg
Your realmd database is good, execute this code into your characters db:Quote:
Originally Posted by GrandpaJohn
Code:ALTER TABLE character_db_version CHANGE COLUMN required_10051_01_characters_character_aura required_10156_01_characters_character_aura bit;
DELETE FROM `character_aura`;
ALTER TABLE `character_aura`
DROP COLUMN `effect_index`, DROP COLUMN `amount`, DROP COLUMN `maxduration`, DROP COLUMN `remaintime`;
ALTER TABLE `character_aura`
ADD COLUMN `basepoints0` INT(11) NOT NULL DEFAULT '0',
ADD COLUMN `basepoints1` INT(11) NOT NULL DEFAULT '0',
ADD COLUMN `basepoints2` INT(11) NOT NULL DEFAULT '0',
ADD COLUMN `maxduration0` INT(11) NOT NULL DEFAULT '0',
ADD COLUMN `maxduration1` INT(11) NOT NULL DEFAULT '0',
ADD COLUMN `maxduration2` INT(11) NOT NULL DEFAULT '0',
ADD COLUMN `remaintime0` INT(11) NOT NULL DEFAULT '0',
ADD COLUMN `remaintime1` INT(11) NOT NULL DEFAULT '0',
ADD COLUMN `remaintime2` INT(11) NOT NULL DEFAULT '0',
ADD COLUMN `effIndexMask` INT(11) NOT NULL DEFAULT '0';
ALTER TABLE character_db_version CHANGE COLUMN required_10156_01_characters_character_aura required_10156_02_characters_pet_aura bit;
DELETE FROM `pet_aura`;
ALTER TABLE `pet_aura`
DROP COLUMN `effect_index`, DROP COLUMN `amount`, DROP COLUMN `maxduration`, DROP COLUMN `remaintime`;
ALTER TABLE `pet_aura`
ADD COLUMN `basepoints0` INT(11) NOT NULL DEFAULT '0',
ADD COLUMN `basepoints1` INT(11) NOT NULL DEFAULT '0',
ADD COLUMN `basepoints2` INT(11) NOT NULL DEFAULT '0',
ADD COLUMN `maxduration0` INT(11) NOT NULL DEFAULT '0',
ADD COLUMN `maxduration1` INT(11) NOT NULL DEFAULT '0',
ADD COLUMN `maxduration2` INT(11) NOT NULL DEFAULT '0',
ADD COLUMN `remaintime0` INT(11) NOT NULL DEFAULT '0',
ADD COLUMN `remaintime1` INT(11) NOT NULL DEFAULT '0',
ADD COLUMN `remaintime2` INT(11) NOT NULL DEFAULT '0',
ADD COLUMN `effIndexMask` INT(11) NOT NULL DEFAULT '0';
ALTER TABLE character_db_version CHANGE COLUMN required_10156_02_characters_pet_aura required_10160_01_characters_character_aura bit;
alter table `character_aura` drop primary key;
alter table `character_aura` add primary key (`guid`,`spell`);
ALTER TABLE character_db_version CHANGE COLUMN required_10160_01_characters_character_aura required_10160_02_characters_pet_aura bit;
alter table `pet_aura` drop primary key;
alter table `pet_aura` add primary key (`guid`,`spell`);
ALTER TABLE character_db_version CHANGE COLUMN required_10160_02_characters_pet_aura required_10254_01_characters_auctionhouse bit;
ALTER TABLE auctionhouse
ADD COLUMN houseid int(11) unsigned NOT NULL default '0' AFTER id;
UPDATE auctionhouse, mangos.creature AS c, mangos.creature_template AS ct
SET houseid =
CASE ct.faction_A
WHEN 12 THEN 1 /* human */
WHEN 29 THEN 6 /* orc, and generic for horde */
WHEN 55 THEN 2 /* dwarf/gnome, and generic for alliance */
WHEN 68 THEN 4 /* undead */
WHEN 80 THEN 3 /* n-elf */
WHEN 104 THEN 5 /* trolls */
WHEN 120 THEN 7 /* booty bay, neutral */
WHEN 474 THEN 7 /* gadgetzan, neutral */
WHEN 534 THEN 2 /* Alliance Generic */
WHEN 855 THEN 7 /* everlook, neutral */
WHEN 1604 THEN 6 /* b-elfs, */
WHEN 1638 THEN 2 /* exodar, alliance */
ELSE 0 /* auction will canceled at loading */
END
WHERE auctionhouse.auctioneerguid = c.guid AND c.id = ct.entry;
ALTER TABLE auctionhouse
DROP COLUMN auctioneerguid;
DROP TABLE IF EXISTS auction;
RENAME TABLE auctionhouse TO auction;
ALTER TABLE character_db_version CHANGE COLUMN required_10254_01_characters_auctionhouse required_10312_01_characters_character_aura bit;
ALTER TABLE `character_aura` DROP PRIMARY KEY;
ALTER TABLE `character_aura` ADD PRIMARY KEY (`guid`,`caster_guid`,`spell`);
ALTER TABLE character_db_version CHANGE COLUMN required_10312_01_characters_character_aura required_10312_02_characters_pet_aura bit;
ALTER TABLE `pet_aura` DROP PRIMARY KEY;
ALTER TABLE `pet_aura` ADD PRIMARY KEY (`guid`,`caster_guid`,`spell`);
ALTER TABLE character_db_version CHANGE COLUMN required_10312_02_characters_pet_aura required_10332_01_characters_character_aura bit;
ALTER TABLE `character_aura`
ADD COLUMN `item_guid` int(11) unsigned NOT NULL default '0' AFTER `caster_guid`,
DROP PRIMARY KEY,
ADD PRIMARY KEY (`guid`,`caster_guid`,`item_guid`,`spell`);
ALTER TABLE character_db_version CHANGE COLUMN required_10332_01_characters_character_aura required_10332_02_characters_pet_aura bit;
ALTER TABLE `pet_aura`
ADD COLUMN `item_guid` int(11) unsigned NOT NULL default '0' AFTER `caster_guid`,
DROP PRIMARY KEY,
ADD PRIMARY KEY (`guid`,`caster_guid`,`item_guid`,`spell`);
Yeah I deleted the old ones and used vmap extractor from this repack to create a new ones and again it didn't worked, so I'm gonna try this latest extractor you suggested and I hope to see progress.Quote:
Did you extract the vmaps? Here's the newest extractor for them, place the extracted files from it in your World of Warcraft/Data/enUS folder then double-click the makevmaps_SIMPLE.bat file
Anyways thx for reply.
EDIT: I just extracted vMaps with this new extractor and everything works perfectly, thanks m8!
Oh, good... I added the new extractor link to the first post, I think the one I included WITH the repack was from 3.3.3a
Yeah I had run into the same error that marko encountered, glad to see it was fixed before all the spam about it...even though there will be spam anyways..