nanounico

Rev [8650] latest ScriptDev2 YTDB

Rev [8650] latest ScriptDev2 YTDB

Rev [8650] latest ScriptDev2 YTDB

Rev [8650] latest ScriptDev2 YTDB

Rev [8650] latest ScriptDev2 YTDB

who and why delete my previous post?? this patch is give me a lot of crasheeeeeeeeeeees!!!

More than 10 crashes in 10 minuts

More more and more..

So this dont work with mtmaps? PD: A lot of crashes. without mtmaps

well i use RHEL maybe is for that? i delete all crashlog and desactivate this patch so i cant put the crash log but all relate to "pexecute sql" , a least for now, without patch no crashes

i have some crashes related to this patch

wow men.. really thank you.. >>!! jaja nice I use intel allocator,and OpenMP

please, somebody can tell me where is the new mtmaps?

where is the new mtmaps?

thank you very much, but dont work :'(

Ambal, my good friend, you know i'm so bad with github.. i cant find the patch.. :'( can you post in a simple .patch please please please

hey vladimir, Oracle is not a good option?

Hey ambal, help us with the lagg, 2000+ lagg :'(

Yes patman, i have some user in the esmeral dream. but i never have problems with esmeral dream, i have some npc spawn and before allways work fine.

crash_log_2009-08-25_15-28-08.log [?1034h[New Thread 2545] [New Thread 2571] [New Thread 2572] [New Thread 2573] [New Thread 2541] [New Thread 2542] [New Thread 2570] [New Thread 2539] [New Thread 2574] [New Thread 2575] Core was generated by `./bin/mangos-worldd -c etc/mangosd.conf'. Program terminated with signal 6, Aborted. #0 0x0000003ec82332f5 in raise () from /lib64/libc.so.6 #0 0x0000003ec82332f5 in raise () from /lib64/libc.so.6 No symbol table info available. #1 0x0000003ec8234b20 in abort () from /lib64/libc.so.6 No symbol table info available. #2 0x0000003ec822c2fa in __assert_fail () from /lib64/libc.so.6 No symbol table info available. #3 0x00000000007f1b8e in MapInstanced::CreateInstance (this=0x7fd4c1373280, mapId=<value optimized out>, player=0x7fd4c136e170) at /root/Desktop/Mangos/Sources/src/game/MapInstanced.cpp:124 map = <value optimized out> NewInstanceId = <value optimized out> __FUNCTION__ = "CreateInstance" __PRETTY_FUNCTION__ = "Map* MapInstanced::CreateInstance(uint32, Player*)" #4 0x00000000006a655d in Player::LoadFromDB (this=0x7fd4c136e170, guid=<value optimized out>, holder=0x7fd4d5e7c880) at /root/Desktop/Mangos/Sources/src/game/Player.cpp:14311 dbAccountId = <value optimized out> arena_currency = <value optimized out> bytes0 = <value optimized out> transGUID = 0 time_diff = <value optimized out> extraflags = 32725 savedPower = {1251232074, 0, 684845, 0, 3241608840, 32724, 3241599344} __PRETTY_FUNCTION__ = "bool Player::LoadFromDB(uint32, SqlQueryHolder*)" result = 0x7fd560014bd0 fields = 0x7fd560014c08 now = 140548509794640 taxi_nodes = {static npos = 18446744073709551615, _M_dataplus = {<std::allocator<char>> = {<__gnu_cxx::new_allocator<char>> = {<No data fields>}, <No data fields>}, _M_p = 0x7fd4c1311460 "\\20\\62\\217"}} savedHealth = <value optimized out> #5 0x00000000008171df in WorldSession::HandlePlayerLogin ( this=<value optimized out>, holder=<value optimized out>) at /root/Desktop/Mangos/Sources/src/game/CharacterHandler.cpp:562 data = {<ByteBuffer> = {static DEFAULT_SIZE = 4096, _rpos = 140553678747744, _wpos = 47, _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 = 0x4a94494a <Address 0x4a94494a out of bounds>, _M_finish = 0x7fd53417f860 "", _M_end_of_storage = 0x533e4b7d <Address 0x533e4b7d out of bounds>}}, <No data fields>}}, m_opcode = 32700} 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 = 0x489bd <Address 0x489bd out of bounds>}} #6 0x000000000082f82f in SqlResultQueue::Update (this=0x7fd55c002a00) at /root/Desktop/Mangos/Sources/src/shared/Database/SqlOperations.cpp:77 callback = 0x7fd4c1311460 #7 0x0000000000783834 in World::UpdateResultQueue (this=<value optimized out>) at /root/Desktop/Mangos/Sources/src/game/World.cpp:2051 No locals. #8 World::Update (this=<value optimized out>) at /root/Desktop/Mangos/Sources/src/game/World.cpp:1602 No locals. #9 0x00000000004c975c in WorldRunnable::run (this=<value optimized out>) at /root/Desktop/Mangos/Sources/src/mangosd/WorldRunnable.cpp:65 diff = 121 realCurrTime = 1396591485 realPrevTime = <value optimized out> prevSleepTime = 53 #10 0x000000000083840c in ACE_Based::Thread::ThreadTask (param=0x9eb) at /root/Desktop/Mangos/Sources/src/shared/Threading.cpp:182 _task = 0xc868310 #11 0x0000003ec8a0686a in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #12 0x0000003ec82de39d in clone () from /lib64/libc.so.6 No symbol table info available. #13 0x0000000000000000 in ?? () No symbol table info available.

Rev [8415] Latest ScriptDev2 YTDB 505 Patches: Map::PlayerRelocation performance, new announce crash_log_2009-08-25_10-59-18.log [?1034h[New Thread 9510] [New Thread 9511] [New Thread 9513] [New Thread 9495] [New Thread 9514] [New Thread 9512] [New Thread 9498] [New Thread 9497] [New Thread 9499] [New Thread 9515] Core was generated by `./bin/mangos-worldd -c etc/mangosd.conf'. Program terminated with signal 6, Aborted. #0 0x0000003ec82332f5 in raise () from /lib64/libc.so.6 #0 0x0000003ec82332f5 in raise () from /lib64/libc.so.6 No symbol table info available. #1 0x0000003ec8234b20 in abort () from /lib64/libc.so.6 No symbol table info available. #2 0x0000003ec822c2fa in __assert_fail () from /lib64/libc.so.6 No symbol table info available. #3 0x00000000007e347b in MapInstanced::CreateInstance ( this=<value optimized out>, mapId=<value optimized out>, player=0x7f8f892896d0) at /root/Desktop/Mangos/Sources/src/game/MapInstanced.cpp:124 st = {static SYMBUFSIZ = 4096, buf_ = "./bin/mangos-worldd(_ZN6Player10LoadFromDBEjP14SqlQueryHolder+0x6cd) [0x6aa50d]\\n./bin/mangos-worldd(_ZN12WorldSession17HandlePlayerLoginEP16LoginQueryHolder+0x7f) [0x80179f]\\n./bin/mangos-worldd(_ZN14SqlResultQueue6UpdateEv+0x2b) [0x81bd4b]\\n./bin/mangos-worldd(_ZN5World6UpdateEj+0x2b4) [0x778664]\\n./bin/mangos-worldd(_ZN13WorldRunnable3runEv+0x7c) [0x4c81bc]\\n./bin/mangos-worldd(_ZN9ACE_Based6Thread10ThreadTaskEPv+0x1c) [0x8245fc]\\n/lib64/libpthread.so.0 [0x3ec8a0686a]\\n/lib64/libc.so.6(clone+0x6d) [0x3ec82de39d]\\n\\203"..., buflen_ = 514, static UNSUPPORTED = 0x7f9036fa6c60 "<stack traces unsupported platform>", static UNABLE_TO_GET_TRACE = 0x7f9036fa6c90 "<unable to get trace>"} map = <value optimized out> NewInstanceId = <value optimized out> __FUNCTION__ = "CreateInstance" __PRETTY_FUNCTION__ = "Map* MapInstanced::CreateInstance(uint32, Player*)" #4 0x00000000005db1ec in MapManager::CreateMap (this=<value optimized out>, id=529, obj=0x7f8f892896d0) at /root/Desktop/Mangos/Sources/src/game/MapManager.cpp:131 __FUNCTION__ = "CreateMap" __PRETTY_FUNCTION__ = "Map* MapManager::CreateMap(uint32, const WorldObject*)" m = 0x0 #5 0x00000000006aa50d in Player::LoadFromDB (this=0x7f8f892896d0, guid=<value optimized out>, holder=0x7f8fc5334250) at /root/Desktop/Mangos/Sources/src/game/Player.cpp:14313 dbAccountId = <value optimized out> arena_currency = <value optimized out> bytes0 = <value optimized out> transGUID = 0 time_diff = <value optimized out> extraflags = 32656 savedPower = {1251215945, 0, 120096, 0, 2301148136, 32655, 2301138640} __PRETTY_FUNCTION__ = "bool Player::LoadFromDB(uint32, SqlQueryHolder*)" result = 0x7f9028003b80 fields = 0x7f9028025ff8 now = 140252157051216 taxi_nodes = {static npos = 18446744073709551615, _M_dataplus = {<std::allocator<char>> = {<__gnu_cxx::new_allocator<char>> = {<No data fields>}, <No data fields>}, _M_p = 0x7f9010002a08 ""}} savedHealth = <value optimized out> #6 0x000000000080179f in WorldSession::HandlePlayerLogin ( this=<value optimized out>, holder=<value optimized out>) at /root/Desktop/Mangos/Sources/src/game/CharacterHandler.cpp:562 data = {<ByteBuffer> = {static DEFAULT_SIZE = 4096, _rpos = 140257123121136, _wpos = 140257123121192, _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 = 0x7f90280037f0 "", _M_finish = 0x7f9018831ea0 "", _M_end_of_storage = 0x7f9018831efa ""}}, <No data fields>}}, m_opcode = 14376} 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 = 0xd93cb0b ""}} #7 0x000000000081bd4b in SqlResultQueue::Update (this=0x7f9010002a00) at /root/Desktop/Mangos/Sources/src/shared/Database/SqlOperations.cpp:77 callback = 0x7f8f99c54770 #8 0x0000000000778664 in World::UpdateResultQueue (this=<value optimized out>) at /root/Desktop/Mangos/Sources/src/game/World.cpp:2051 No locals. #9 World::Update (this=<value optimized out>) at /root/Desktop/Mangos/Sources/src/game/World.cpp:1602 No locals. #10 0x00000000004c81bc in WorldRunnable::run (this=<value optimized out>) at /root/Desktop/Mangos/Sources/src/mangosd/WorldRunnable.cpp:65 diff = 165 realCurrTime = 1380461912 realPrevTime = <value optimized out> prevSleepTime = 95 #11 0x00000000008245fc in ACE_Based::Thread::ThreadTask (param=0x2517) at /root/Desktop/Mangos/Sources/src/shared/Threading.cpp:182 _task = 0xd88bea0 #12 0x0000003ec8a0686a in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #13 0x0000003ec82de39d in clone () from /lib64/libc.so.6 No symbol table info available. #14 0x0000000000000000 in ?? () No symbol table info available. (Testing now without - Map::PlayerRelocation performance - ) but yesterday with this patch, work absolutly fine. Without patch, again crash every 5-10 Minuts. crash_log_2009-08-25_13-43-11.log [?1034h[New Thread 29922] [New Thread 29920] [New Thread 29924] [New Thread 29921] [New Thread 29886] [New Thread 29889] [New Thread 29888] [New Thread 29890] [New Thread 29925] [New Thread 29923] Core was generated by `./bin/mangos-worldd -c etc/mangosd.conf'. Program terminated with signal 6, Aborted. #0 0x0000003ec82332f5 in raise () from /lib64/libc.so.6 #0 0x0000003ec82332f5 in raise () from /lib64/libc.so.6 No symbol table info available. #1 0x0000003ec8234b20 in abort () from /lib64/libc.so.6 No symbol table info available. #2 0x0000003ec822c2fa in __assert_fail () from /lib64/libc.so.6 No symbol table info available. #3 0x00000000007e348b in MapInstanced::CreateInstance ( this=<value optimized out>, mapId=<value optimized out>, player=0x7f6fa869e380) at /root/Desktop/Mangos/Sources/src/game/MapInstanced.cpp:124 st = {static SYMBUFSIZ = 4096, buf_ = "./bin/mangos-worldd(_ZN6Player10LoadFromDBEjP14SqlQueryHolder+0x6cd) [0x6aa38d]\\n./bin/mangos-worldd(_ZN12WorldSession17HandlePlayerLoginEP16LoginQueryHolder+0x7f) [0x8017af]\\n./bin/mangos-worldd(_ZN14SqlResultQueue6UpdateEv+0x2b) [0x81bd5b]\\n./bin/mangos-worldd(_ZN5World6UpdateEj+0x2b4) [0x778674]\\n./bin/mangos-worldd(_ZN13WorldRunnable3runEv+0x7c) [0x4c81bc]\\n./bin/mangos-worldd(_ZN9ACE_Based6Thread10ThreadTaskEPv+0x1c) [0x82460c]\\n/lib64/libpthread.so.0 [0x3ec8a0686a]\\n/lib64/libc.so.6(clone+0x6d) [0x3ec82de39d]\\n\\310"..., buflen_ = 514, static UNSUPPORTED = 0x7f70b2ab8c60 "<stack traces unsupported platform>", static UNABLE_TO_GET_TRACE = 0x7f70b2ab8c90 "<unable to get trace>"} map = <value optimized out> NewInstanceId = <value optimized out> __FUNCTION__ = "CreateInstance" __PRETTY_FUNCTION__ = "Map* MapInstanced::CreateInstance(uint32, Player*)" #4 0x00000000005db16c in MapManager::CreateMap (this=<value optimized out>, id=529, obj=0x7f6fa869e380) at /root/Desktop/Mangos/Sources/src/game/MapManager.cpp:131 __FUNCTION__ = "CreateMap" __PRETTY_FUNCTION__ = "Map* MapManager::CreateMap(uint32, const WorldObject*)" m = 0x0 #5 0x00000000006aa38d in Player::LoadFromDB (this=0x7f6fa869e380, guid=<value optimized out>, holder=0x7f6fa1577850) at /root/Desktop/Mangos/Sources/src/game/Player.cpp:14296 dbAccountId = <value optimized out> arena_currency = <value optimized out> bytes0 = <value optimized out> transGUID = 0 time_diff = <value optimized out> extraflags = 32624 savedPower = {1251225772, 0, 888543, 0, 2825521304, 32623, 2825511808} __PRETTY_FUNCTION__ = "bool Player::LoadFromDB(uint32, SqlQueryHolder*)" result = 0x7f70a4221e60 fields = 0x7f70a4221e98 now = 140114718097744 taxi_nodes = {static npos = 18446744073709551615, _M_dataplus = {<std::allocator<char>> = {<__gnu_cxx::new_allocator<char>> = {<No data fields>}, <No data fields>}, _M_p = 0x7f708c002a08 ""}} savedHealth = <value optimized out> #6 0x00000000008017af in WorldSession::HandlePlayerLogin ( this=<value optimized out>, holder=<value optimized out>) at /root/Desktop/Mangos/Sources/src/game/CharacterHandler.cpp:562 data = {<ByteBuffer> = {static DEFAULT_SIZE = 4096, _rpos = 2713218272, _wpos = 140117431315854, _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 = 0x1a1b86d8e <Address 0x1a1b86d8e out of bounds>, _M_finish = 0x1400000000 <Address 0x1400000000 out of bounds>, _M_end_of_storage = 0x0}}, <No data fields>}}, m_opcode = 35904} 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 = 0xd742648 ""}} #7 0x000000000081bd5b in SqlResultQueue::Update (this=0x7f708c002a00) at /root/Desktop/Mangos/Sources/src/shared/Database/SqlOperations.cpp:77 callback = 0x7f6fe3d6de20 #8 0x0000000000778674 in World::UpdateResultQueue (this=<value optimized out>) at /root/Desktop/Mangos/Sources/src/game/World.cpp:2051 No locals. #9 World::Update (this=<value optimized out>) at /root/Desktop/Mangos/Sources/src/game/World.cpp:1602 No locals. #10 0x00000000004c81bc in WorldRunnable::run (this=<value optimized out>) at /root/Desktop/Mangos/Sources/src/mangosd/WorldRunnable.cpp:65 diff = 226 realCurrTime = 1390289619 realPrevTime = <value optimized out> prevSleepTime = 0 #11 0x000000000082460c in ACE_Based::Thread::ThreadTask (param=0x74be) at /root/Desktop/Mangos/Sources/src/shared/Threading.cpp:182 _task = 0xd68f020 #12 0x0000003ec8a0686a in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #13 0x0000003ec82de39d in clone () from /lib64/libc.so.6 No symbol table info available. #14 0x0000000000000000 in ?? () No symbol table info available. crash_log_2009-08-25_13-49-58.log [?1034h[New Thread 8014] [New Thread 8016] [New Thread 8017] [New Thread 7997] [New Thread 8018] [New Thread 8000] [New Thread 8015] [New Thread 8019] [New Thread 7999] [New Thread 8001] Core was generated by `./bin/mangos-worldd -c etc/mangosd.conf'. Program terminated with signal 6, Aborted. #0 0x0000003ec82332f5 in raise () from /lib64/libc.so.6 #0 0x0000003ec82332f5 in raise () from /lib64/libc.so.6 No symbol table info available. #1 0x0000003ec8234b20 in abort () from /lib64/libc.so.6 No symbol table info available. #2 0x0000003ec822c2fa in __assert_fail () from /lib64/libc.so.6 No symbol table info available. #3 0x00000000007e348b in MapInstanced::CreateInstance ( this=<value optimized out>, mapId=<value optimized out>, player=0x7f882321e880) at /root/Desktop/Mangos/Sources/src/game/MapInstanced.cpp:124 st = {static SYMBUFSIZ = 4096, buf_ = "./bin/mangos-worldd(_ZN6Player10LoadFromDBEjP14SqlQueryHolder+0x6cd) [0x6aa38d]\\n./bin/mangos-worldd(_ZN12WorldSession17HandlePlayerLoginEP16LoginQueryHolder+0x7f) [0x8017af]\\n./bin/mangos-worldd(_ZN14SqlResultQueue6UpdateEv+0x2b) [0x81bd5b]\\n./bin/mangos-worldd(_ZN5World6UpdateEj+0x2b4) [0x778674]\\n./bin/mangos-worldd(_ZN13WorldRunnable3runEv+0x7c) [0x4c81bc]\\n./bin/mangos-worldd(_ZN9ACE_Based6Thread10ThreadTaskEPv+0x1c) [0x82460c]\\n/lib64/libpthread.so.0 [0x3ec8a0686a]\\n/lib64/libc.so.6(clone+0x6d) [0x3ec82de39d]\\n\\345"..., buflen_ = 514, static UNSUPPORTED = 0x7f88d4461c60 "<stack traces unsupported platform>", static UNABLE_TO_GET_TRACE = 0x7f88d4461c90 "<unable to get trace>"} map = <value optimized out> NewInstanceId = <value optimized out> __FUNCTION__ = "CreateInstance" __PRETTY_FUNCTION__ = "Map* MapInstanced::CreateInstance(uint32, Player*)" #4 0x00000000005db16c in MapManager::CreateMap (this=<value optimized out>, id=529, obj=0x7f882321e880) at /root/Desktop/Mangos/Sources/src/game/MapManager.cpp:131 __FUNCTION__ = "CreateMap" __PRETTY_FUNCTION__ = "Map* MapManager::CreateMap(uint32, const WorldObject*)" m = 0x0 #5 0x00000000006aa38d in Player::LoadFromDB (this=0x7f882321e880, guid=<value optimized out>, holder=0x7f88290bf0e0) at /root/Desktop/Mangos/Sources/src/game/Player.cpp:14296 dbAccountId = <value optimized out> arena_currency = <value optimized out> bytes0 = <value optimized out> transGUID = 0 time_diff = <value optimized out> extraflags = 32648 savedPower = {1251226183, 0, 865556, 0, 589434264, 32648, 589424768} __PRETTY_FUNCTION__ = "bool Player::LoadFromDB(uint32, SqlQueryHolder*)" result = 0x7f88c4007330 fields = 0x7f88c4007368 now = 140222092280144 taxi_nodes = {static npos = 18446744073709551615, _M_dataplus = {<std::allocator<char>> = {<__gnu_cxx::new_allocator<char>> = {<No data fields>}, <No data fields>}, _M_p = 0x7f88b0002a08 ""}} savedHealth = <value optimized out> #6 0x00000000008017af in WorldSession::HandlePlayerLogin ( this=<value optimized out>, holder=<value optimized out>) at /root/Desktop/Mangos/Sources/src/game/CharacterHandler.cpp:562 data = {<ByteBuffer> = {static DEFAULT_SIZE = 4096, _rpos = 140225380642720, _wpos = 140225380642776, _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 = 0x7f88c4006fa0 "0+", _M_finish = 0x7f88c2e51ea0 "", _M_end_of_storage = 0x7f88c2e51efa ""}}, <No data fields>}}, m_opcode = 28632} 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 = 0xd8b3304 ""}} #7 0x000000000081bd5b in SqlResultQueue::Update (this=0x7f88b0002a00) at /root/Desktop/Mangos/Sources/src/shared/Database/SqlOperations.cpp:77 callback = 0x7f881c7cf3f0 #8 0x0000000000778674 in World::UpdateResultQueue (this=<value optimized out>) at /root/Desktop/Mangos/Sources/src/game/World.cpp:2051 No locals. #9 World::Update (this=<value optimized out>) at /root/Desktop/Mangos/Sources/src/game/World.cpp:1602 No locals. #10 0x00000000004c81bc in WorldRunnable::run (this=<value optimized out>) at /root/Desktop/Mangos/Sources/src/mangosd/WorldRunnable.cpp:65 diff = 263 realCurrTime = 1390700585 realPrevTime = <value optimized out> prevSleepTime = 0 #11 0x000000000082460c in ACE_Based::Thread::ThreadTask (param=0x1f3d) at /root/Desktop/Mangos/Sources/src/shared/Threading.cpp:182 _task = 0xd7ff470 #12 0x0000003ec8a0686a in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #13 0x0000003ec82de39d in clone () from /lib64/libc.so.6 No symbol table info available. #14 0x0000000000000000 in ?? () No symbol table info available.

somebody can update this thread for compile with the latest rev please!

sorry is "From" a website.. the RA socket work, i dont say that the RA socket dont work, only, not work for me, becouse, when much tester try at the same time send items, gold, or a simple mail, (I have more than 1000+ testers) the RA socket dont work, and is possible two options, one, the server crash, two, the RA close and dont work more. is for that, this patch is very usefull

come on, i know that, but if i want create some aplications for the testers, like "Send items from a website" the RA socket dont work for me man!

no fist the patch need to patch manually,the sql no have problems, about the patch i dont know the argument that mangos for send mail to player, i dont know if the argument of this patch work with mangos, but maybe this patch can start a new patch for mangos.