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

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

[CthulhuFtagn]

Ain't that the truth... lol

[GrandpaJohn]

@TRM:

hey bro the update worked just great and the repack is awsome as always everything working great thanks mate, you're awsome, love your work please keep it up

also in regards to the v-map extractor zip, just wondering is the split config file not necessary cause its not in it.