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

100 pages of epicness... right on.

Originally Posted by matt71tx

Looks like the Mangos devs have changed up the DB structure again...

Quice has been updated for these new changes.

Quice - MaNGOS DataBase Editor

Thanks for the heads up matt.

Originally Posted by MrBytes

Many thanks for your work, in my view, now is the best mangos repack there today.

Greetings

I appreciate it, thank you.

Originally Posted by picaro

VERY GOOD THANKS... UPDATE AGREGATE.....

Glad you like it.

Originally Posted by junebuggy64

Can someone please test this.. Ever since update 81 I believe i've had a bunch of issues with pets and mobs in certain areas. When I revert back to 79, it works fine. The mobs outside ZG in stranglethorn vale. Attack one and then backup. They won't follow you but instead stop.. Same with mobs in duskwood. Then hunter pets don't move and get stuck in Booty bay and possible other places. Again since 81 or so. if I redownload and use only my character/realm db back to 79 it works fine. but as soon as I update things get messed up. I've been running this repack since update 20 so pretty sure I know what I am doing.

I'll test this and see what the problem is.

Originally Posted by nrmwow

Great Repack, works fine!

Thanks!

I don't normally double-post, most of you now this... but I thought this was important enough to warrant it.

I went through my database with a fine tooth comb today and found a LOT (over 1200 errors), I have fixed them and completely redid both the scriptdev2 and mangos dbs and I believe I have fixed most, if not all, of the problems that have plagued a lot of you... This will require a completely different type of update, so I will be writing a little guide in a few moments that will show you how to update the two dbs without disrupting your accounts or characters.

Great job updating this repack. I'm re-downloading (i have the old one) to give it a spin. Let me know when you have posted your fix for the 1200+ issues you mentioned above.

To install this update, please follow the instructions below:

1. Close the MySQL.bat file. If you have installed MySQL as a service using the C:\Server\mysql\mysql_installservice.bat please double-click the mysql_uninstallservice.bat.



2. Go to the C:\Server\mysql\data folder and delete the mangos and scriptdev2 folders.

3. Copy the extracted mangos and scriptdev2 folders from the database_updates.zip to the C:\Server\mysql\data folder.

4. Restart the MySQL.bat file or reinstall the MySQL service.

The core update is installed just like all previous core updates.

This WILL not affect your characters or accounts but will impact any custom malls, etc which you have made.

This update contains all of my fixes, patches, etc and will bring the Repack up to:

MaNGOS 10763 (required_10762_01_mangos_spell_proc_event)
ScriptDev2 1885
YTDB 351 (573_FIX_10726)
Acid 39 (3.0.7) "We Came, We Raided and We Conquered"

I have also included the new Quice database editor update in the CU_0084.zip files' tools folder.

Updates Available:
Database: database_updates.zip (27.29 MB)
Core: COMPILING...


This is the most in-depth, complete update that I've done on my repack, I have literally spent a few days tracking down errors and non-blizzlike problems... I believe it is the best repack I've made.

Code:

Over 1200 errors corrected.
MaNGOS 10763 (required_10762_01_mangos_spell_proc_event)
Move comments at 61 line, no functional changes. 
Implement SPELL_AURA_IGNORE_UNIT_STATE (252).
Basic support for target-name in MonsterSay/etc 
Remove unneeded non-player Say et al. 
Correctly reset mob orientation upon reaching spawn point. Should also improve visualisation of mob orientation on clients.
Fixed typo in CONTROLED_* 
Implement zone limited pets unsummon at leave allowed zones.
Implement armor penetration limitations.
Use class specific combat rating factors from gtOCTClassCombatRatingScalarStore.dbc
Use UNIT_FIELD_CRITTER for store minipet guid. 
Lost mangos.sql changes in one from recent commits. 
Convert to objetguids map scripts and finally drop IS_PLAYER_GUID. 
Use objectguids in item code. 
Convert Gameobject owner to objectguid use. 
Convert MonsterSay/Say and similar functions to ObjectGuid use. 
ScriptDev 1885
Correct ScriptDev2_1835_to_MaNGOS_0.12.patch thanks Schmoo for fixing.