| Age | Commit message (Collapse) | Author |
|---|
|
of the Blue Dragonflight>.
Signed-off-by: Manuel <manue.l@live.com.ar>
|
|
functionality. Thanks to Xanandu and click.
Signed-off-by: Manuel <manue.l@live.com.ar>
|
|
Signed-off-by: Manuel <manue.l@live.com.ar>
|
|
Readd lost changes from char db type cleanup
|
|
- It is _strongly_ recommended to extensively test the recent changes before applying them to live data
- To fully resync the character db layout with TC releases it is recommended to dump the characters table with
mysqldump --no-data characters > characters_database_livedata.sql
and use a diff tool to compare it against sql/base/characters_database.sql
|
|
|
|
|
|
|
|
There is a chance that you will be getting importing errors / data truncation warnings because of ancient invalid pet names.
SELECT * FROM character_pet WHERE CHAR_LENGTH(`name`) > 21;
|
|
|
|
- MySQL numeric types can NOT be altered in value range or or storage size at all, so things like INT(32) are entirely pointless. As TC currently doesn't use the display width of numeric types, use the default width to avoid confusion. (see MySQL numeric types docs)
- Timestamps can be stored as INT(10) UNSIGNED. As the max value of this type is 4294967295 which translates into year 2106 using it as timestamp we are NOT affected by the year 2038 bug. If the timestamp needs to be negative in some cases, i.e. for displaying infinity using -1, use BIGINT(20) instead.
- Do NOT set ROW_FORMAT for InnoDB tables unless you specifically want COMPRESSED tables (which we don't for performance reasons). MySQL will chose the appropriate ROW_FORMAT by itself depending on the innodb_file_format setting of the server. (FIXED is only available for MyISAM)
- Even though VARCHAR does require less storage space than CHAR for values with variable length, the length still needs to be chosen wisely as this doesn't apply to memory consumption.
|
|
mysqldump version in preparation for char db storage type cleanup
|
|
packet manipulation.
|
|
after finish a dungeon they did not queue for. Note: lfg_dungeon_encounters MUST contain the correct dungeonId, no the random ones.
|
|
Closes #138
|
|
|
|
changes.
|
|
Flame for The Orb Whisperer achievement, thanks Shocker for noticing
|
|
Scripts/Icecrown Citadel: Fixed Professor Putricide adds chasing different targets than selected.
Scripts/Icecrown Citadel: Fixed Coldflame ticking twice because of too close spawning.
Scripts/Icecrown Citadel: Fixed Coldflame affecting spiked targets.
|
|
with with *characters*.sql file mask)
|
|
last of them caused by this area of the core.
|
|
display errors on nano. Thanks to Aokromes for pointing out.
|
|
credit from NPC_TAMARA
|
|
|
|
destructor.
Core/Transports: Properly delink units from transports on transport desutruction. - Thanks to Shauren for help.
Core/ObjectAccessor: Unload corpse 'storage' in added UnloadAll method called in WorldRunnable postservice hook.
Core/Master: Change some postservice queries to syncrhonous (direct) execution to ensure execution on shutdown
Core/Master: Remove redundant calls to ACE::init and ACE::fini
These changes were made to fix crash/freeze issues on shutdown.
|
|
Signed-off-by: Manuel <manue.l@live.com.ar>
|
|
possible desyncrhonisation issue when DatabaseWorkerPool calls wait() on the workers.
|
|
(0x00000100). Spells with this attribute flag (Avenger's Shield, Hammer of Righteousness, Shield of Righteousness, Felguard Cleave, Fel Iron Bomb) will ignore secondary targets that are under the effect of crowd control aura's.
Thanks to Shauren for advices.
|
|
summon list, not before
|
|
Signed-off-by: Shauren <shauren.trinity@gmail.com>
|
|
from sniff
Closes #176 and #177
Signed-off-by: Shauren <shauren.trinity@gmail.com>
|
|
Signed-off-by: Anubisss <anubisss210@gmail.com>
|
|
Closes #234
Signed-off-by: Shauren <shauren.trinity@gmail.com>
|
|
Signed-off-by: Shauren <shauren.trinity@gmail.com>
|
|
It will enable add friends which have moderators (or more) status in other realms and cease undue AH activity logging from those same accounts.
Signed-off-by: click <per.wilhelmsen@gmail.com>
|
|
Signed-off-by: Shauren <shauren.trinity@gmail.com>
|
|
|
|
and removed hacks for it
Signed-off-by: Shauren <shauren.trinity@gmail.com>
|
|
Breaking Through (11898). Thanks to Svannon for original code and joint brainstorming session.
Closes issue #194
|
|
state by implementing QUEST_STATUS_REWARDED. The latter is not used in the database explicitly, only in the core. This is to prevent overhead by iterating over the rewarded quests storage multiple times.
All relevant upper level code has been updated accordingly to the best of my ability.
|
|
Dump found here: http://pastebin.com/2GZ3t5v4
|
|
authserver and worldserver. Prevent multiple calls and make it more elegant.
|
|
Databaseworkerpool queue.
|
|
- Implement DatabaseWorkerPool::DirectCommitTransaction for synchronous transaction execution (as opposed to asynchronous/enqueued).
- Add MySQL errno 1213 "Deadlock found when trying to get lock; try restarting transaction" handler. If 1213 is called the core will retry to directly execute the transaction a maximum of 5 times.
|
|
* Call EnterEvadeMode before teleporting players to entrance - prevents players being stuck in combat
* Fixed Gaseous Blight stacking damage
* Properly initialize phase for Professor Putricide when entering combat
* Fixed Blood Nova and Boiling Blood abilities of Deathbringer Saurfang
|
|
client for bank eventlog and regular eventlog respectively. Higher values will result in client crashes.
|
|
Professor Putricide entered combat during Festergut or Rotface fight (encounter mechanic)
|
|
This crash happens when effect is SPELL_EFFECT_TALENT_SPEC_SELECT and the caster is not a player.
You should always check object's type (or sure that object is 101% a player) before you use ToPlayer() casting function.
Signed-off-by: Anubisss <anubisss210@gmail.com>
|
|
make the warning text a little bit more "Hello Cpt.Obvious" obvious for
users that can't read. (It now includes the word WARNING in the warnings)
|
|
|
