CyberDragon

What bug does the patch fix? What features does the patch add?

The writepdump console command also accepts character names not just GUIDs.

For which SubVersion revision was the patch created?

6048

Is there a thread in the bug report section? If yes, please add a link to the thread.

Didn't find any.

Who has been writing this patch? Please include either forum user names or email addresses.

CyberDragon

Index: src/mangosd/CliRunnable.cpp
===================================================================
--- src/mangosd/CliRunnable.cpp        (revision 6048)
+++ src/mangosd/CliRunnable.cpp        (working copy)
@@ -110,7 +110,7 @@
        char * p2 = strtok(NULL, " ");
        if(!file || !p2)
        {
-                zprintf("Syntax is: writepdump $filename $playerGUID\\r\\n");
+                zprintf("Syntax is: writepdump $filename $playerNameOrGUID\\r\\n");
                return;
        }

@@ -120,7 +120,7 @@

        if(!guid)
        {
-                zprintf("Syntax is: writepdump $filename $playerGUID\\r\\n");
+                zprintf("Syntax is: writepdump $filename $playerNameOrGUID\\r\\n");
                return;
        }

http://www.wowwiki.com/Formulas:Aggro

http://www.wowwiki.com/Threat

And what the config file setting modifies is:

http://www.wowwiki.com/Aggro_radius

You must edit the source files.

Firest you should read the pinned guides in the Installation, Configuration and Updates subforum.

You should update to atleast rev5762 and check mangosd.conf

Bump for this small fix

What bug does the patch fix? What features does the patch add?

Fixing typo in `spell_chain` table. Replacing "Melt Ore" (5159) spell with the correct "Entangling Roots (Rank 3)" (5195) spell.

For which SubVersion revision was the patch created?

5747

Is there a thread in the bug report section? If yes, please add a link to the thread.

no

Who has been writing this patch? Please include either forum user names or email addresses.

CyberDragon

UPDATE `spell_chain` SET `spell_id`='5195' WHERE `spell_id`='5159';
UPDATE `spell_chain` SET `prev_spell`='5195' WHERE `prev_spell`='5159';

Index: sql/mangos.sql
===================================================================
--- sql/mangos.sql        (revision 5747)
+++ sql/mangos.sql        (working copy)
@@ -11635,7 +11635,7 @@
(5143,0,5143,1),
(5144,5143,5143,2),
(5145,5144,5143,3),
-(5159,1062,339,3),
+(5195,1062,339,3),
(5171,0,5171,1),
(5176,0,5176,1),
(5177,5176,5176,2),
@@ -11647,7 +11647,7 @@
(5187,5186,5185,3),
(5188,5187,5185,4),
(5189,5188,5185,5),
-(5196,5159,339,4),
+(5196,5195,339,4),
(5201,3029,1082,3),
(5211,0,5211,1),
(5215,0,5215,1),

This should fix the characters who already learned that bad spell:

DELETE FROM `character_spell` WHERE `spell`='5159';

Make sure that the timezone field in the realmd.realmlist table is NOT 0!