Splash

Apply this patch and recompile:

http://pastebin.org/420751

This should solve the problem

With this modification you have the possibility to add a description to the chars showed in ".gm ingame". Its possible to extend this modification so that this additional information is showed in other commands like ".player info", I will do this if there is a demand for this mod.

Note: Don't forget the SQL Update.

Download:

http://rapidshare.com/files/387695477/accountbuisness.txt

SQL Code for adding new column at account table:

ALTER TABLE account ADD business varchar(255) NOT NULL;

Best regards

Splash

Because it should be active_realm_id instead of realm. The following should fix it.

diff --git a/src/mangosd/CliRunnable.cpp b/src/mangosd/CliRunnable.cpp
index 1f11037..549d578 100644
--- a/src/mangosd/CliRunnable.cpp
+++ b/src/mangosd/CliRunnable.cpp
@@ -483,7 +483,7 @@ bool ChatHandler::HandleAccountOnlineListCommand(const char* args)

    ///- Get the list of accounts ID logged to the realm
    //                                                 0   1         2        3        4
-    QueryResult *result = loginDatabase.PQuery("SELECT id, username, last_ip, gmlevel, expansion FROM account WHERE realm = %u", realmID);
+    QueryResult *result = loginDatabase.PQuery("SELECT id, username, last_ip, gmlevel, expansion FROM account WHERE active_realm_id = %u", realmID);

    return ShowAccountListHelper(result,&limit);
}

Apply this to make compile work. It might be not the best way to fix the problem but it works.

diff --git a/src/game/SpellMgr.h b/src/game/SpellMgr.h
index 29b74ec..be1241b 100644
--- a/src/game/SpellMgr.h
+++ b/src/game/SpellMgr.h
@@ -26,6 +26,7 @@
#include "SpellAuraDefines.h"
#include "DBCStructure.h"
#include "DBCStores.h"
+#include "Unit.h"
#include "Database/SQLStorage.h"

#include "Utilities/UnorderedMap.h"

Crash is related to changes in rev 9186/9187. Appears on Debian Etch ,too.

Using host libthread_db library "/lib/libthread_db.so.1".

Core was generated by `./mangos-worldd'.

Program terminated with signal 11, Segmentation fault.

#0 Unit::GetTotem (this=<value optimized out>, slot=<value optimized out>)

at ../../../src/game/Unit.cpp:8456

8456 return totem->isTotem() ? (Totem*)totem : NULL;

#0 Unit::GetTotem (this=<value optimized out>, slot=<value optimized out>)

at ../../../src/game/Unit.cpp:8456

totem = (class Creature *) 0x0

#1 0x000000000073d26a in Unit::CallForAllControlledUnits<AuraHandleAddModifierHelper> (this=0x2aaac4ae6e30, func=@0x41ffc910, withTotems=true,

withGuardians=<value optimized out>, withCharms=false)

at ../../../src/game/Unit.h:1693

No locals.

#2 0x000000000072f729 in Aura::HandleAddModifier (this=0x2aaac4af15b0,

apply=true, Real=<value optimized out>)

at ../../../src/game/SpellAuras.cpp:1433

No locals.

#3 0x00000000007227f9 in Aura::ApplyModifier (this=0x2aaac4af15b0,

apply=false, Real=false) at ../../../src/game/SpellAuras.cpp:943

aura = SPELL_AURA_NONE

#4 0x000000000079950c in Unit::AddAura (this=0x2aaac4ae6e30,

Aur=0x2aaac4af15b0) at ../../../src/game/Unit.cpp:3722

caster = <value optimized out>

scAuras = (

std::list<Aura*,std::allocator<Aura*> > &) @0x2aaac4af15b0: {<std::_List_base<Aura*,std::allocator<Aura*> >> = {

_M_impl = {<std::allocator<std::_List_node<Aura*> >> = {<__gnu_cxx::new_allocator<std::_List_node<Aura*> >> = {<No data fields>}, <No data fields>},

_M_node = {_M_next = 0x920c30,

_M_prev = 0x17700000006b}}}, <No data fields>}

aurSpellInfo = (const SpellEntry *) 0x2aaab05baa70

aurName = SPELL_AURA_ADD_FLAT_MODIFIER

spair = {first = 49562, second = 0 '\\0'}

#5 0x000000000075cfba in Spell::EffectApplyAura (this=0x2aaac4af1320, i=0)

at ../../../src/game/SpellEffects.cpp:2553

caster = (class Unit *) 0x2aaac4ae6e30

Aur = (class Aura *) 0x2aaac4af15b0

duration = 0

limitduration = <value optimized out>

#6 0x000000000074438b in Spell::DoSpellHitOnUnit (this=0x2aaac4af1320,

unit=0x2aaac4ae6e30, effectMask=1) at ../../../src/game/Spell.cpp:1173

multiplier = 0

effectNumber = 0

realCaster = (class Unit *) 0x2aaac4ae6e30

#7 0x000000000074c333 in Spell::DoAllEffectOnTarget (this=0x2aaac4af1320,

target=0x2aaac4af1590) at ../../../src/game/Spell.cpp:974

p = <value optimized out>

mask = 0

unit = (class Unit *) 0x2aaac4ae6e30

caster = (class Unit *) 0x2aaac4ae6e30

missInfo = <value optimized out>

procAttacker = 16384

procVictim = 32768

procEx = <value optimized out>

#8 0x000000000074f2ff in Spell::handle_immediate (this=0x2aaac4af1320)

at ../../../src/game/Spell.cpp:2742

No locals.

#9 0x0000000000757218 in Spell::cast (this=0x2aaac4af1320, skipCheck=true)

at ../../../src/game/Spell.cpp:2716

castResult = <value optimized out>

#10 0x00000000007a1aa6 in Unit::CastSpell (this=0x2aaac4ae6e30,

Victim=0x2aaac4ae6e30, spellInfo=0x2aaab05baa70, triggered=true,

castItem=0x0, triggeredByAura=0x0, originalCaster=0)

at ../../../src/game/Unit.cpp:952

spell = (Spell *) 0x2aaac4af1320

targets = {m_srcX = 0, m_srcY = 0, m_srcZ = 0, m_destX = 5872.75,

m_destY = 2108.18994, m_destZ = 636.023987, m_strTarget = {

static npos = 18446744073709551615,

_M_dataplus = {<std::allocator<char>> = {<__gnu_cxx::new_allocator<char>> = {<No data fields>}, <No data fields>}, _M_p = 0xb01a68 ""}}, m_targetMask = 2,

m_unitTarget = 0x2aaac4ae6e30, m_GOTarget = 0x0, m_itemTarget = 0x0,

m_unitTargetGUID = 216724, m_GOTargetGUID = 0, m_CorpseTargetGUID = 0,

m_itemTargetGUID = 0, m_itemTargetEntry = 0}

#11 0x00000000007a21af in Unit::CastSpell (this=0x2aaac4ae6e30, Victim=0x0,

spellId=49562, triggered=false, castItem=0x0, triggeredByAura=0x0,

originalCaster=0) at ../../../src/game/Unit.cpp:930

spellInfo = (const SpellEntry *) 0x0

#12 0x00000000006f56d0 in Player::addSpell (this=0x2aaac4ae6e30,

spell_id=49562, active=true, learning=false, dependent=false,

disabled=false) at ../../../src/game/Player.cpp:3154

talentPos = <value optimized out>

newspell = (PlayerSpell *) 0x2aaac4af12e0

spellInfo = (const SpellEntry *) 0x2aaab05baa70

state = PLAYERSPELL_UNCHANGED

dependent_set = <value optimized out>

superceded_old = false

talentCost = 2

spellLearnSkill = <value optimized out>

#13 0x00000000006f646e in Player::_LoadSpells (this=0x2aaac4ae6e30,

result=0x2aaac4a79010) at ../../../src/game/Player.cpp:15902

fields = (Field *) 0x2aaac4a79048

#14 0x00000000006fe49e in Player::LoadFromDB (this=0x2aaac4ae6e30,

guid=216724, holder=0x2aaac2bf48a0) at ../../../src/game/Player.cpp:15111

bubble = <value optimized out>

result = (QueryResult *) 0x2aaac4a79af0

fields = (Field *) 0x2aaac4a777a8

dbAccountId = <value optimized out>

transGUID = 0

difficulty = <value optimized out>

arena_currency = <value optimized out>

now = <value optimized out>

soberFactor = <value optimized out>

extraflags = 35

taxi_nodes = {static npos = 18446744073709551615,

_M_dataplus = {<std::allocator<char>> = {<__gnu_cxx::new_allocator<char>> = {<No data fields>}, <No data fields>}, _M_p = 0xb01a68 ""}}

savedHealth = 10417

savedPower = {0, 0, 0, 100, 0, 0, 0}

__PRETTY_FUNCTION__ = "bool Player::LoadFromDB(uint32, SqlQueryHolder*)"

#15 0x00000000008593d6 in WorldSession::HandlePlayerLogin (

this=0x2aaac4a79c80, holder=0x2aaac2bf48a0)

at ../../../src/game/CharacterHandler.cpp:572

playerGuid = 216724

pCurrChar = (class Player *) 0x2aaac4ae6e30

data = {<ByteBuffer> = {static DEFAULT_SIZE = 4096,

_rpos = 46912900122784, _wpos = 11816144,

_storage = {<std::_Vector_base<unsigned char,std::allocator<unsigned char> >> = {

_M_impl = {<std::allocator<unsigned char>> = {<__gnu_cxx::new_allocator<unsigned char>> = {<No data fields>}, <No data fields>}, _M_start = 0x0,

_M_finish = 0x85ea69 "\\017���\\0021�H\\213\\\\$\\030H\\213l$ L\\213d$(L\\213l$0L\\213t$8L\\213|$@H\\203�H�", '\\220' <repeats 13 times>, "H�\\aPd\\223",

_M_end_of_storage = 0x0}}, <No data fields>}}, m_opcode = 1}

resultGuild = <value optimized out>

IP_str = {static npos = 18446744073709551615,

_M_dataplus = {<std::allocator<char>> = {<__gnu_cxx::new_allocator<char>> = {<No data fields>}, <No data fields>}, _M_p = 0x2aaac498d3f0 "�b\\224"}}

#16 0x00000000008858ca in SqlResultQueue::Update (this=<value optimized out>)

at ../../../../src/shared/Database/SqlOperations.cpp:77

callback = (class MaNGOS::IQueryCallback *) 0x2aaac4a78aa0

#17 0x00000000007d08f9 in World::Update (this=0xb6bb00, diff=52)

at ../../../src/game/World.cpp:1675

next = {_M_cur = 0x0, _M_ht = 0x0}

autobroadcaston = 0

#18 0x0000000000501e84 in WorldRunnable::run (this=<value optimized out>)

at ../../../src/mangosd/WorldRunnable.cpp:60

diff = 52

realCurrTime = 922692948

realPrevTime = <value optimized out>

prevSleepTime = 49

#19 0x000000000088d135 in ACE_Based::Thread::ThreadTask (

param=<value optimized out>) at ../../../src/shared/Threading.cpp:183

_task = (class ACE_Based::Runnable *) 0x2aaac4a589d0

#20 0x00002abef4a67f1a in start_thread () from /lib/libpthread.so.0

No symbol table info available.

#21 0x00002abef50ce5d2 in clone () from /lib/libc.so.6

No symbol table info available.

#22 0x0000000000000000 in ?? ()

No symbol table info available.

So it looks like that greater Changes in Mount System are required to make the rider on his mammoth to a vehicle for other players.