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

No, what I mean is: I've labeled my updates by number, mangos_0001.sql, mangos_0002.sql etc. If you've already injected 0002, then when a new update comes along do not inject 0002 again, only inject the sql files you haven't injected yet.

If you look at your mangos database under the db_version table, you'll see which update you have installed up-to.

(Click to enlarge)

Originally Posted by Narcoleptic

ohhh i´m so sorry friend now i get it...i´m so sorry...ohh and what about the files in the win32 and x64 do i have to install them all new in each update or no...?
Thanks

Yes, with each new Update, just copy the Win32 and x64 folders from the update pack and paste them (overwrite) into the C:\Server\MaNGOS\ directory.

Originally Posted by Stefan30

hey dude it's me again... let me ask you something... i'm newbie with that things too... but let me ask does it my version correctly? :

Code:

Characters version -> characters_0018.sql
Empty version -> empty_0021.sql
Mangos version -> mangos_0021.sql
scriptdev2 version -> scriptdev2_0019.sql
core version -> win32 0021

Does it correctly injected ? Only the latest versions, right ?
sry if I'm certainly become tedious to you

Make sure you have installed ALL the previous .sql files before injecting the new ones.

For those who want to know what changes have been made from release to update 0021:

Major Changes

MaNGOS 10351 - 10429

Code:

Stability enhancement 8MB reserved stack size.
Aspeed, Speed, Flyspeed, Swimspeed updated from 10-255.
For item 50351 and 50706 fixed work in case no offhand weapon. 
Implement support explcitly started timed achievements.
Avoid access to DB at view GM tickets by chat commands.
Use time constants instead of hard coded values for STOP_TIME_FOR_PLAYER 
Correctly clearUnitState at Interrupt of WaypointMovementGenerator for creature.
Drop unneeded groupFlag and rename it properly.
PacketLog.* not used in core some time already so drop it.
A small spoon of changes and cleanup for WaypointMovementGenerator.
Restore triggered auras cleanup at main aura expire after auraholders adding.
Send proper error message at password check fail.
Remove trailing space.
Implement creature_movement_template.
More wide use ObjectGuid in way remove MAKE_NEW_GUID uses.
Restore build with gcc and cleanup includes a bit. 
Implement ACTION_T_MOUNT_TO_ENTRY_OR_MODEL (43) for creature eventAI.
Add portable way for hash specialization adding.
Making sure CreaturesAddon are re-loaded after creature evade.
Use AI function DoCastSpellIfCan for eventAI ACTION_T_CAST
Implement UNORDERED_SET support.
Rename UnorderedMap.h -> UnorderedMapSet.h 
More wide use ObjectGuid in group code.
Implement EFLAG_RANDOM_ACTION
Drop unused team-argument in ChooseDisplayId -function.
Fixes for EFLAG_RANDOM_ACTION
Updated MySQL client libs to 5.1.49
Fixed build at VS90 with TR1
Simplify use Guild::BroadcastEvent 
Avoid double lookup member slot in guild operations.
More wide use ObjectGuid in arena team code.
Finaly drop MAKE_NEW_GUID. 
Implement generic system for racial model selection.
Add missing holiday id<->battleground id definitions for AB
Store guid instaed pointer for first user of GAMEOBJECT_TYPE_SUMMONING_RITUAL
Fixed reset time calculation for some cases.
Traditional post-commit typo fix.
Remove Unit::GetUnit and update it callers.
Correct creature entry selection for raid difficulties.
Fixed quote parsing after optional arg in chat commands. 
Make spawntime arg really optional as before for .gobject add
Typo fixes.
Add several new script calls for InstanceData.
Restore build at Unix after Unit::GetUnit drop. 
Small correction in SetReputation to avoid confusion.
Add script call for InstanceData, OnPlayerDeath
Remove redundant use of this-> in recent implemented script calls.
No debug log output when a certain ability is active.
Send GMTicket to SendGMTicketGetTicket instead text. 
Fixed wrong difficulty selection and possible crash.
Fix mixed up FactionEntry to lookup in SetReputation 
Fixed typo in doc/EventAI.txt
Fixed crash in .aura command for spell without auras. 
Some code style cleanups. 
Use ObjectGuid in packets and fix some uint32 guids cases.
Stricted name check at chat command data loading from 'command' table. 
Additional checks for call assist. 
Restore remove spell affect 58427 after stealth fade. 
Fixed work .learn and other spell commands with unlearned talent shift-link. 
Add -o <outfile> option to genrevision. 
Fix mistake in recent debug log output change (ref 10395) 
Restore work of 47230 and ranks.
Fix wrong sql.
Fix broken sqls for spell_proc_event.
Add a BindIP warning to worldd/realmd config files 
Add some missing class/struct forward declarations and includes.
Constantify some functions in InstanceSave.
Sort triggered spell chains 44203 and 42231 in proper place `spell_chain` data.
Fix 71611 proc and remove check for family name if no spell_proc_event is defined.
Fix Battle/Guardian elixirs stacking.
Merge not-skill linked spell lists in `spell_chain`.
Check redundant single rank spell data in `spell_chain`.
Avoid send stop packet in PointMovementGenerator when unit is not moving.
Correct typo in function name.
Fix 71642 proc conditions.
Load most spell chains data from SkillLineAbility.dbc
Fix 50334 additional targets part.
Add comment in Aura::CanProcFrom
Remove not needed checks from IsNoStackAuraDueToAura
Drop redundant data from `spell_proc_event` after recent spell chain changes. 
Fix line ends.
Some format string fixes.
Improve detection removed ranks for spell in `spell_chain`

ScriptDev2 1778 - 1815

Code:

Minor code cleanup for ebon_hold.cpp
Correct two typos in boss_cthun. Patch by zergtmn.
Restore compile after changes in KilledMonsterCredit function. Requires Mangos 10363.
Add the missing .sql update for rev 1780
Update sources with changed ChooseDisplayId -function. Req Mangos 10373
Added support for boss Galdarah in Gundrak. Based on Gelu's work.
Added reworked version of Stratholme instance script. Blame Schmoozerd for any errors inside.
Added long time missing texts for arena event in BRD. Thanks to DaemonCantor.
Code cleanup in old_hillsbrad scripts and also move related gossip texts to database.
Re-design instance_old_hillsbrad
Added basic abilities of boss Drakkari Colossus in Gundrak.
Mortal Strikes proc rate might need adjusting.
Add a few missing texts in old_hillsbrad scripts. Correct a few existing and also added part of end-event.
Added a slightly more reliable way to prevent thrall from proceeding with waypoints before he should. Requires Mangos 10390
Fix r1786 sql, thanks Pandore.
Add more missing texts for old_hillsbrad and implement end event for the escort.
Reset old_hillsbrad escort at respawn.
Add lost call to escortAI JustRespawned, so escort variables are reset properly.
Removed obsolate code for boss Rockmar the Crackler in Slave Pens. Already implemented in ACID.
Reworked instance Gundrak.
Added cleaned up version of DasBlub's cleanup patch. Note: might need additional cleanup.
Added support for quests 5097 and 5098. Patch by virusav.
Might need additional core support.
Added support for quest 12916. Patch by virusav.
Corrected typo in dalaran.cpp. Patch by klark20.
Added support for quest 7603. Patch by Schmoozerd.
Fixed compile after r1798.
Fixed sql files from r1791.
Not check distance to group/player when escort is paused.
Fix crash after login, for the second time!! (ref revision 1267)
Add SetCurrentWaypoint for escortAi.
Can be used for escorts where points may be skipped (or continue from earlier reached) under special circumstances.
Implement relocation of thrall in case escort fail for any reason. Different locations are used, depending on overall progression.
Add missing semicolon in sql.
Some code cleanup, SD2 code style and enclose nested if's in () for readability.
Move some gossip texts to database.
Correct VC100 project file.
Use HandleEmote() also in DoScriptText function.
Move some crusader's gossip to database. Patch by patman.
In addition correct some bad style naming's and add missing for scriptloader.
Let boss_volkhan shatter only once. Patch by rise2.
Make sure cast is ok before yell and emote anything for volkhan shatter.
Add teleports related to quest 12548. Patch by crackm.
Remove some unwanted tabs and whitespace.
Manually reset button at unworthy initiate respawn.

YTDB 338 - 340

Code:

UPDATE 562_(10408)
+ all fixes from forum
+ fix spawn
+ quest scripts
+ mob's gossip menus
+ new templates from WDB
+ update table "*_template" by WDB
+ data from sniffs (templates, spawn)
+ processed 130 caches (3.3.5a)

UPDATE 561_(10372)
+ all fixes from forum
+ fix spawn
+ quest scripts
+ mob's gossip menus
+ new templates from WDB
+ update table "*_template" by WDB
+ data from sniffs (templates, spawn)
+ processed 117 caches (3.3.5a)

UPDATE 560_(10344) "Balthalionus"
+ all fixes from forum
+ fix spawn
+ quest scripts
+ mob's gossip menus
+ new templates from WDB
+ update table "*_template" by WDB
+ data from sniffs (templates, spawn)
+ processed 107 caches (3.3.5a)