[Release] TRM's Cthulhu Ftagn Dual-Database MaNGOS Repack (3.3.5.12340) - 32 & 64-bit

[marko94]

DO NOT CONTINUE UNTIL YOU HAVE THE SERVER FOLDER DIRECTLY UNDER THE C:\ DRIVE!!!

Well there are a lot of people complaining how their MySQL won't start, well guys you heard the man !

TRM tell 'em !!! xD

[agamoose]

Nice work again TRM as always Also loving the new Panoramic Views.

[marko94]

For some reason I can't download this ... :/

[xpainfullx]

TRM excellent work as always. Your a friggen genius man

[ZomgEary]

Good to see you're doing well TRM Glad to see you've released a new repack.

[marko94]

Mangosd won't load if vmaps are enabled, any ideas why is this happening ?

[CthulhuFtagn]

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 file

vmap_extract_assembler_bin.zip (267.84 KB)

Then make sure the lines in your mangosd.conf file look like this:

vmap.enableLOS = 1
vmap.enableHeight = 1
...
DetectPosCollision = 1

Tested and works great...

characters version, required_10051_01
realmd version, required_10008_01

Your realmd database is good, execute this code into your characters db:

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`);

[marko94]

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

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.

Anyways thx for reply.

EDIT: I just extracted vMaps with this new extractor and everything works perfectly, thanks m8!

[CthulhuFtagn]

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

[ZomgEary]

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..