Voldemmort

Rev. 9261. YTDB SD2 When I use glyph, the summon just last like 10 or 15 seconds and it cant cast any of the spells it has to cast (With Glyph just Waterbolt)

Hello Rage, thanks for the patch, I'll test it now. P.D: You post the same link of the previous patch. Is it correct?

Confirmed in rev 9259 still

Thanks bosc0 for the patch. Which file i have to change? ObjectMgr.cpp if I'm corect?

I guess display IDS are being taked from core side with stored dbc, not from client side. 2010-01-18 19:27:41 ERROR:Item (Entry: 1313) not correct 48166 display id, must be 6458 (using it). But I have no idea of how to change it in source code.

Bump for this. Crash very often and a really anoying thing. Help please =)

I'm having the following crash every 2 ~ 6 hours on my server. Any idea why? Thanks in advance. Revision: * * 9182 ac7ef53cde5b960f3bc31ad87f6db38bba8c998d Date 15:1:2010. Time 9:8 //===================================================== *** Hardware *** Processor: Intel(R) Xeon(R) CPU X3220 @ 2.40GHz Number Of Processors: 4 Physical Memory: 8386128 KB (Available: 5609140 KB) Commit Charge Limit: 16824544 KB *** Operation System *** Windows Vista or Windows Server 2008 Server 4.0 Service Pack 2 (Version 6.0, Build 6002) //===================================================== Exception code: C0000005 ACCESS_VIOLATION Fault address: 00000001400D34FE 01:00000000000D24FE D:\\Servidores WoW\\MaNGOS 3.3.0a\\mangosd.exe Registers: RAX:0000000000000008 RBX:0000000009745370 RCX:95A39505732B0000 RDX:0000000000000000 RSI:000007FFECF75300 RDI:00000001402C7A20 R8: 000000000002F8B3 R9: 0000000000000000 R10:000007FFEAD04018 R11:0000000000000000 R12:0000000000000000 R13:0000000000000000 R14:0000000000000000 R15:000000000D1C6F30 CS:RIP:0033:00000001400D34FE SS:RSP:002B:000000000D1C74D0 RBP:00000000 DS:002B ES:002B FS:0053 GS:002B Flags:00010246 Call stack: Address Frame Function SourceFile 00000001400D34FE 000000000D1C9540 MapInstanced::RemoveGridMapReference+12E c:\\servidores\\wow\\trabajo actual\\mangos\\src\\game\\mapinstanced.h line 57 00000001400D3303 000000000D1CF6A0 Map::UnloadGrid+333 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\game\\map.cpp line 1114 00000001400D36FE 000000000D1CF750 Map::UnloadAll+16E c:\\servidores\\wow\\trabajo actual\\mangos\\src\\game\\map.cpp line 1129 00000001400CCDB7 000000000D1CF950 Map::~Map+57 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\game\\map.cpp line 66 00000001400D89C1 000000000D1CF9A0 InstanceMap::~InstanceMap+91 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\game\\map.cpp line 2347 00000001400EB245 000000000D1CF9D0 InstanceMap::`vector deleting destructor'+65 0000000140590EB3 000000000D1CFAE0 MapInstanced::DestroyInstance+133 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\game\\mapinstanced.cpp line 252 000000014058F955 000000000D1CFB60 MapInstanced::Update+145 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\game\\mapinstanced.cpp line 60 000000014032603F 000000000D1CFC50 MapManager::Update+19F c:\\servidores\\wow\\trabajo actual\\mangos\\src\\game\\mapmanager.cpp line 266 00000001402A1455 000000000D1CFE00 World::Update+725 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\game\\world.cpp line 1675 000000014003E715 000000000D1CFE40 WorldRunnable::run+A5 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\mangosd\\worldrunnable.cpp line 61 00000001402C7A43 000000000D1CFEB0 ACE_Based::Thread::ThreadTask+23 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\shared\\threading.cpp line 186 000007FEF667170B 000000000D1CFEF0 ?invoke@ACE_OS_Thread_Adapter@@UEAAKXZ+5B 0000000074E52FDF 000000000D1CFF20 _endthreadex+47 0000000074E53080 000000000D1CFF50 _endthreadex+E8 00000000778FBE3D 000000000D1CFF80 BaseThreadInitThunk+D 0000000077A36A51 000000000D1CFFD0 RtlUserThreadStart+21 Call stack: Address Frame Function SourceFile 0000000077A56D5A 000000000082FA70 NtWaitForSingleObject+A 000000007790C0B0 000000000082FB30 WaitForSingleObjectEx+A0 000007FEF661B64A 000000000082FB60 ?__ace_assert@@YAXPEBDH0@Z+38A 000007FEF669E8E3 000000000082FBE0 ?wait_task@ACE_Thread_Manager@@QEAAHPEAVACE_Task_Base@@@Z+243 00000001402C9523 000000000082FC20 WorldSocketMgr::Wait+63 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\game\\worldsocketmgr.cpp line 313 0000000140038F76 000000000082FEE0 Master::Run+776 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\mangosd\\master.cpp line 322 00000001400387CD 000000000082FF20 main+42D c:\\servidores\\wow\\trabajo actual\\mangos\\src\\mangosd\\main.cpp line 180 000000014003F0EA 000000000082FF50 __tmainCRTStartup+11A f:\\dd\\vctools\\crt_bld\\self_64_amd64\\crt\\src\\crtexe.c line 582 00000000778FBE3D 000000000082FF80 BaseThreadInitThunk+D 0000000077A36A51 000000000082FFD0 RtlUserThreadStart+21 Call stack: Address Frame Function SourceFile 0000000077A5705A 000000000445FCB0 ZwDelayExecution+A 000000007790C1B8 000000000445FD30 SleepEx+88 00000001402C7CA9 000000000445FD80 ACE_Based::Thread::Sleep+39 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\shared\\threading.cpp line 232 000000014058A975 000000000445FE40 SqlDelayThread::run+35 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\shared\\database\\sqldelaythread.cpp line 39 00000001402C7A43 000000000445FEB0 ACE_Based::Thread::ThreadTask+23 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\shared\\threading.cpp line 186 000007FEF667170B 000000000445FEF0 ?invoke@ACE_OS_Thread_Adapter@@UEAAKXZ+5B 0000000074E52FDF 000000000445FF20 _endthreadex+47 0000000074E53080 000000000445FF50 _endthreadex+E8 00000000778FBE3D 000000000445FF80 BaseThreadInitThunk+D 0000000077A36A51 000000000445FFD0 RtlUserThreadStart+21 Call stack: Address Frame Function SourceFile 0000000077A5705A 0000000004C5FCB0 ZwDelayExecution+A 000000007790C1B8 0000000004C5FD30 SleepEx+88 00000001402C7CA9 0000000004C5FD80 ACE_Based::Thread::Sleep+39 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\shared\\threading.cpp line 232 000000014058A975 0000000004C5FE40 SqlDelayThread::run+35 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\shared\\database\\sqldelaythread.cpp line 39 00000001402C7A43 0000000004C5FEB0 ACE_Based::Thread::ThreadTask+23 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\shared\\threading.cpp line 186 000007FEF667170B 0000000004C5FEF0 ?invoke@ACE_OS_Thread_Adapter@@UEAAKXZ+5B 0000000074E52FDF 0000000004C5FF20 _endthreadex+47 0000000074E53080 0000000004C5FF50 _endthreadex+E8 00000000778FBE3D 0000000004C5FF80 BaseThreadInitThunk+D 0000000077A36A51 0000000004C5FFD0 RtlUserThreadStart+21 Call stack: Address Frame Function SourceFile 0000000077A5705A 000000000545FCB0 ZwDelayExecution+A 000000007790C1B8 000000000545FD30 SleepEx+88 00000001402C7CA9 000000000545FD80 ACE_Based::Thread::Sleep+39 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\shared\\threading.cpp line 232 000000014058A975 000000000545FE40 SqlDelayThread::run+35 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\shared\\database\\sqldelaythread.cpp line 39 00000001402C7A43 000000000545FEB0 ACE_Based::Thread::ThreadTask+23 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\shared\\threading.cpp line 186 000007FEF667170B 000000000545FEF0 ?invoke@ACE_OS_Thread_Adapter@@UEAAKXZ+5B 0000000074E52FDF 000000000545FF20 _endthreadex+47 0000000074E53080 000000000545FF50 _endthreadex+E8 00000000778FBE3D 000000000545FF80 BaseThreadInitThunk+D 0000000077A36A51 000000000545FFD0 RtlUserThreadStart+21 Call stack: Address Frame Function SourceFile 0000000077A579BA 000000000D1C4E40 NtGetContextThread+A 00000000778E2E3A 000000000D1C4E70 GetThreadContext+A 000000014003CFB9 000000000D1C53B0 WheatyExceptionReport::PrintTracesForAllThreads+C9 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\shared\\wheatyexceptionreport.cpp line 370 000000014003D386 000000000D1C6420 WheatyExceptionReport::GenerateExceptionReport+396 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\shared\\wheatyexceptionreport.cpp line 468 000000014003C61A 000000000D1C66D0 WheatyExceptionReport::WheatyUnhandledExceptionFilter+18A c:\\servidores\\wow\\trabajo actual\\mangos\\src\\shared\\wheatyexceptionreport.cpp line 109 000000007799C9CF 000000000D1C67B0 UnhandledExceptionFilter+15F 0000000077A88120 000000000D1C67E0 RtlCharToInteger+E0 0000000077A495A4 000000000D1C6850 __C_specific_handler+8C 0000000077A45B4D 000000000D1C6880 RtlIntegerToChar+53D 0000000077A49947 000000000D1C6F20 __C_specific_handler+42F 0000000077A56C78 000000000D1C74C0 KiUserExceptionDispatcher+2E 00000001400D34FE 000000000D1C9540 MapInstanced::RemoveGridMapReference+12E c:\\servidores\\wow\\trabajo actual\\mangos\\src\\game\\mapinstanced.h line 57 00000001400D3303 000000000D1CF6A0 Map::UnloadGrid+333 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\game\\map.cpp line 1114 00000001400D36FE 000000000D1CF750 Map::UnloadAll+16E c:\\servidores\\wow\\trabajo actual\\mangos\\src\\game\\map.cpp line 1129 00000001400CCDB7 000000000D1CF950 Map::~Map+57 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\game\\map.cpp line 66 00000001400D89C1 000000000D1CF9A0 InstanceMap::~InstanceMap+91 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\game\\map.cpp line 2347 00000001400EB245 000000000D1CF9D0 InstanceMap::`vector deleting destructor'+65 0000000140590EB3 000000000D1CFAE0 MapInstanced::DestroyInstance+133 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\game\\mapinstanced.cpp line 252 000000014058F955 000000000D1CFB60 MapInstanced::Update+145 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\game\\mapinstanced.cpp line 60 000000014032603F 000000000D1CFC50 MapManager::Update+19F c:\\servidores\\wow\\trabajo actual\\mangos\\src\\game\\mapmanager.cpp line 266 00000001402A1455 000000000D1CFE00 World::Update+725 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\game\\world.cpp line 1675 000000014003E715 000000000D1CFE40 WorldRunnable::run+A5 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\mangosd\\worldrunnable.cpp line 61 00000001402C7A43 000000000D1CFEB0 ACE_Based::Thread::ThreadTask+23 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\shared\\threading.cpp line 186 000007FEF667170B 000000000D1CFEF0 ?invoke@ACE_OS_Thread_Adapter@@UEAAKXZ+5B 0000000074E52FDF 000000000D1CFF20 _endthreadex+47 0000000074E53080 000000000D1CFF50 _endthreadex+E8 00000000778FBE3D 000000000D1CFF80 BaseThreadInitThunk+D 0000000077A36A51 000000000D1CFFD0 RtlUserThreadStart+21 Call stack: Address Frame Function SourceFile 0000000077A56F3A 000000000D9CF790 ZwRequestWaitReplyPort+A 0000000077A5A4E9 000000000D9CF7C0 CsrClientCallServer+89 000000007794236C 000000000D9CF920 CloseConsoleHandle+2AC 0000000077966A64 000000000D9CF9F0 ReadConsoleA+64 0000000077919C74 000000000D9CFA80 GetProcAddress+C3D4 0000000074EA07AE 000000000D9CFB20 _wsopen_s+266 0000000074EA0E15 000000000D9CFB80 _read+10D 0000000074E5EB03 000000000D9CFBC0 _filbuf+8F 0000000074E5DF8C 000000000D9CFC30 fgets+198 0000000140013BDA 000000000D9CFE40 CliRunnable::run+BA c:\\servidores\\wow\\trabajo actual\\mangos\\src\\mangosd\\clirunnable.cpp line 321 00000001402C7A43 000000000D9CFEB0 ACE_Based::Thread::ThreadTask+23 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\shared\\threading.cpp line 186 000007FEF667170B 000000000D9CFEF0 ?invoke@ACE_OS_Thread_Adapter@@UEAAKXZ+5B 0000000074E52FDF 000000000D9CFF20 _endthreadex+47 0000000074E53080 000000000D9CFF50 _endthreadex+E8 00000000778FBE3D 000000000D9CFF80 BaseThreadInitThunk+D 0000000077A36A51 000000000D9CFFD0 RtlUserThreadStart+21 Call stack: Address Frame Function SourceFile 0000000077A5705A 000000000E1B7990 ZwDelayExecution+A 000000007790C1B8 000000000E1B7A10 SleepEx+88 00000001402C7CA9 000000000E1B7A60 ACE_Based::Thread::Sleep+39 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\shared\\threading.cpp line 232 000000014003982E 000000000E1CFE40 RARunnable::run+25E c:\\servidores\\wow\\trabajo actual\\mangos\\src\\mangosd\\master.cpp line 185 00000001402C7A43 000000000E1CFEB0 ACE_Based::Thread::ThreadTask+23 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\shared\\threading.cpp line 186 000007FEF667170B 000000000E1CFEF0 ?invoke@ACE_OS_Thread_Adapter@@UEAAKXZ+5B 0000000074E52FDF 000000000E1CFF20 _endthreadex+47 0000000074E53080 000000000E1CFF50 _endthreadex+E8 00000000778FBE3D 000000000E1CFF80 BaseThreadInitThunk+D 0000000077A36A51 000000000E1CFFD0 RtlUserThreadStart+21 Call stack: Address Frame Function SourceFile 0000000077A5705A 000000000E9CFD30 ZwDelayExecution+A 000000007790C1B8 000000000E9CFDB0 SleepEx+88 00000001402C7CA9 000000000E9CFE00 ACE_Based::Thread::Sleep+39 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\shared\\threading.cpp line 232 00000001400393B1 000000000E9CFE40 FreezeDetectorRunnable::run+91 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\mangosd\\master.cpp line 83 00000001402C7A43 000000000E9CFEB0 ACE_Based::Thread::ThreadTask+23 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\shared\\threading.cpp line 186 000007FEF667170B 000000000E9CFEF0 ?invoke@ACE_OS_Thread_Adapter@@UEAAKXZ+5B 0000000074E52FDF 000000000E9CFF20 _endthreadex+47 0000000074E53080 000000000E9CFF50 _endthreadex+E8 00000000778FBE3D 000000000E9CFF80 BaseThreadInitThunk+D 0000000077A36A51 000000000E9CFFD0 RtlUserThreadStart+21 Call stack: Address Frame Function SourceFile 0000000077A56D5A 000000000F1CF880 NtWaitForSingleObject+A 000007FEFD543756 000000000F1CF900 0001:0000000000002756 C:\\Windows\\system32\\MSWSOCK.dll 000007FEFD54F375 000000000F1CFAA0 WSPStartup+6AE5 000007FEFF24668C 000000000F1CFAE0 select+15C 000007FEFF24660D 000000000F1CFBE0 select+DD 000007FEF6628252 000000000F1CFC60 ?wait_for_multiple_events@?$ACE_Select_Reactor_T@V?$ACE_Reactor_Token_T@VACE_Token@@@@@@MEAAHAEAVACE_Select_Reactor_Handle_Set@@PEAVACE_Time_Value@@@Z+132 000007FEF66A0DC0 000000000F1CFCD0 ?handle_events@ACE_TP_Reactor@@UEAAHPEAVACE_Time_Value@@@Z+A0 000007FEF667E55D 000000000F1CFD00 ?run_reactor_event_loop@ACE_Reactor@@QEAAHAEAVACE_Time_Value@@P6AHPEAV1@@Z@Z+4D 00000001402C8E07 000000000F1CFE40 ReactorRunnable::svc+77 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\game\\worldsocketmgr.cpp line 167 000007FEF669A171 000000000F1CFE70 ?svc_run@ACE_Task_Base@@SAKPEAX@Z+41 000007FEF669A72B 000000000F1CFEB0 ?invoke_i@ACE_Thread_Adapter@@EEAAKXZ+4B 000007FEF669A851 000000000F1CFEF0 ?invoke@ACE_Thread_Adapter@@UEAAKXZ+71 0000000074E52FDF 000000000F1CFF20 _endthreadex+47 0000000074E53080 000000000F1CFF50 _endthreadex+E8 00000000778FBE3D 000000000F1CFF80 BaseThreadInitThunk+D 0000000077A36A51 000000000F1CFFD0 RtlUserThreadStart+21 Call stack: Address Frame Function SourceFile 0000000077A56D5A 000000000F9CF880 NtWaitForSingleObject+A 000007FEFD543756 000000000F9CF900 0001:0000000000002756 C:\\Windows\\system32\\MSWSOCK.dll 000007FEFD54F375 000000000F9CFAA0 WSPStartup+6AE5 000007FEFF24668C 000000000F9CFAE0 select+15C 000007FEFF24660D 000000000F9CFBE0 select+DD 000007FEF6628252 000000000F9CFC60 ?wait_for_multiple_events@?$ACE_Select_Reactor_T@V?$ACE_Reactor_Token_T@VACE_Token@@@@@@MEAAHAEAVACE_Select_Reactor_Handle_Set@@PEAVACE_Time_Value@@@Z+132 000007FEF66A0DC0 000000000F9CFCD0 ?handle_events@ACE_TP_Reactor@@UEAAHPEAVACE_Time_Value@@@Z+A0 000007FEF667E55D 000000000F9CFD00 ?run_reactor_event_loop@ACE_Reactor@@QEAAHAEAVACE_Time_Value@@P6AHPEAV1@@Z@Z+4D 00000001402C8E07 000000000F9CFE40 ReactorRunnable::svc+77 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\game\\worldsocketmgr.cpp line 167 000007FEF669A171 000000000F9CFE70 ?svc_run@ACE_Task_Base@@SAKPEAX@Z+41 000007FEF669A72B 000000000F9CFEB0 ?invoke_i@ACE_Thread_Adapter@@EEAAKXZ+4B 000007FEF669A851 000000000F9CFEF0 ?invoke@ACE_Thread_Adapter@@UEAAKXZ+71 0000000074E52FDF 000000000F9CFF20 _endthreadex+47 0000000074E53080 000000000F9CFF50 _endthreadex+E8 00000000778FBE3D 000000000F9CFF80 BaseThreadInitThunk+D 0000000077A36A51 000000000F9CFFD0 RtlUserThreadStart+21 ======================== Local Variables And Parameters Call stack: Address Frame Function SourceFile 00000001400D34FE 000000000D1C9540 MapInstanced::RemoveGridMapReference+12E c:\\servidores\\wow\\trabajo actual\\mangos\\src\\game\\mapinstanced.h line 57 Local <user defined> 'this' = D1CB5DC Parameter <user defined> 'p' = 1404815DD 00000001400D3303 000000000D1CF6A0 Map::UnloadGrid+333 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\game\\map.cpp line 1114 punting on symbol this punting on symbol x punting on symbol y punting on symbol pForce Local int 'gx' = 0 Local int 'gy' = D1CF701 Local <user defined> 'grid' = D1CF6E8 00000001400D36FE 000000000D1CF750 Map::UnloadAll+16E c:\\servidores\\wow\\trabajo actual\\mangos\\src\\game\\map.cpp line 1129 punting on symbol i Local <user defined> 'this' = 0 Parameter bool 'pForce' = C0 00000001400CCDB7 000000000D1CF950 Map::~Map+57 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\game\\map.cpp line 66 Local <user defined> 'this' = 100000000 00000001400D89C1 000000000D1CF9A0 InstanceMap::~InstanceMap+91 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\game\\map.cpp line 2347 Local <user defined> 'this' = 7FFEE3249A0 00000001400EB245 000000000D1CF9D0 InstanceMap::`vector deleting destructor'+65 Local <user defined> 'this' = 7FFFF084000 0000000140590EB3 000000000D1CFAE0 MapInstanced::DestroyInstance+133 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\game\\mapinstanced.cpp line 252 Local <user defined> 'this' = 7FFECF73BF0 Parameter <user defined> 'itr' = 140326205 000000014058F955 000000000D1CFB60 MapInstanced::Update+145 c:\\servidores\\wow\\trabajo actual\\mangos\\src\\game\\mapinstanced.cpp line 60 Local <user defined> 'this' = 8C Parameter unsigned int 't' = 7FF00000000

Rev [9171] Still with this bug, after you login to server, you start to run with your char and the pet walk after you. A way to made the pet run, is activate your walk speed and go back to run speed and the pet will start to run after you.

Well, finally I could came to the correct query. Just replace the and <NEWENTRY> marks in the following query. UPDATE `item_instance` SET `data`=CONCAT(CAST(SUBSTRING_INDEX(`data`, ' ', 3) AS CHAR), ' ', <NEW ENTRY>, ' ', CAST(SUBSTRING_INDEX(`data`, ' ', -61) AS CHAR)) WHERE CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 4), ' ', -1) AS UNSIGNED) = [list=1]; UPDATE character_inventory SET item_template = <NEWENTRY> WHERE item_template = [list=1]; Here an example UPDATE `item_instance` SET `data`=CONCAT(CAST(SUBSTRING_INDEX(`data`, ' ', 3) AS CHAR), ' ', 1313, ' ', CAST(SUBSTRING_INDEX(`data`, ' ', -61) AS CHAR)) WHERE CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 4), ' ', -1) AS UNSIGNED) = 75000; UPDATE character_inventory SET item_template = 1313 WHERE item_template = 75000;

I have tried with different methods but I'm still unable to update properly item_instance. Anyone could help with the proper query for this? Thanks in advance.

@ bosc0 I get the Data from the DBC, and the id 1313 is the id for a dagger stored in the DBC but not in DB (u cant find it even in wowhead) but as I say it is in DBC like a Dagger (Use MyWarcraftStudio to read DBC, get fields comparing them with current DB, update dbclayout_3.2.2 to add fields not added in Item.dbc extract and insert dbc_item to DB and start comparing class and subclass fields to get entrys not in DB, already got IDS for custom weapons I got) @Mordaunt: YES, thats is exactly what I want to do, change the entry of all 75000 items to 1313 (thats just an example, but I can get the example and change values for the IDS I got)

I already found some IDS not used in DB with proper CLASS and SUBCLASS fields, to update the entry in the DB I know I should run something like: UPDATE item_template SET entry = '1313' WHERE entry = '75000'; Now the question is, what should I run in order to update characters inventory? I dont feel like manually changing all the custom items ingame. I know I have to run a query to update characters.character_inventory and item_instance, I know it have to be something like UPDATE character_inventory SET item_template = '1313' WHERE item_template = '75000'; The problem is that I dont know what should I run in order to update item_instance, hope someone could help us with any idea =) Thanks in advance for your help.

I already found some IDS not used in DB with proper CLASS and SUBCLASS fields, to update the entry in the DB I know I should run something like: UPDATE item_template SET entry = '1313' WHERE entry = '75000'; Now the question is, what should I run in order to update characters inventory? I dont feel like manually changing all the custom items ingame. I know I have to run a query to update characters.character_inventory and item_instance, I know it have to be something like UPDATE character_inventory SET item_template = '1313' WHERE item_template = '75000'; The problem is that I dont know what should I run in order to update item_instance, hope someone could help us with any idea =) Thanks in advance for your help.

Anyone know how to make 2 realms, the first one (main) with 3.2.2a, and the second one (test server) with 3.3.0a? I tried, but if i login with 3.3.0a the client close and I cant get into main or test server, and if i get with a 3.2.2a client it login without problems to main server, but cant get into test server.

Thanks kaxias. I tried to clone that repo, but got this. Question, that repo just have the mangos source + anticheat, right? thanks for your help

Can someone please provide an updated patch of this anticheat for latest rev [8538] ??

Revision: * * 8432 * Date 28:8:2009. Time 20:56 //===================================================== *** Hardware *** Processor: Quad-Core AMD Opteron(tm) Processor 1356 Number Of Processors: 4 Physical Memory: 4194303 KB (Available: 4194303 KB) Commit Charge Limit: 4194303 KB *** Operation System *** Windows Vista or Windows Server 2008 Server 4.0 Service Pack 2 (Version 6.0, Build 6002) //===================================================== Exception code: C00000FD STACK_OVERFLOW Fault address: 0042F897 01:0002E897 D:\\Mangos Server 3.1.3\\mangosd.exe Registers: EAX:110D2000 EBX:10C99BC0 ECX:110CBC04 EDX:0000008A ESI:99E00000 EDI:00098012 CS:EIP:0023:0042F897 SS:ESP:002B:110EF364 EBP:110EF36C DS:002B ES:002B FS:0053 GS:002B Flags:00010206 Call stack: Address Frame Function SourceFile 0042F897 00000000 ?getSource@?$Reference@V?$GridRefManager@VCorpse@@@@VCorpse@@@@QBEPAVCorpse@@XZ+181C7 006978CE 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+8C9E 00455585 00000000 ?CastSpell@Unit@@QAEXPAV1@PBUSpellEntry@@_NPAVItem@@PAVAura@@_K@Z+1B5 004553C8 00000000 ?CastSpell@Unit@@QAEXPAV1@I_NPAVItem@@PAVAura@@_K@Z+118 00625006 00000000 ?HandleAddModifier@Aura@@QAEX_N0@Z+566 006236E6 00000000 ?ApplyModifier@Aura@@QAEX_N0@Z+66 0045D86E 00000000 ?AddAura@Unit@@QAE_NPAVAura@@@Z+87E 007FE6EE 00000000 ?HandleRepairItemOpcode@WorldSession@@QAEXAAVWorldPacket@@@Z+9CBE 0069CD13 00000000 ?SendCastResult@Spell@@SAXPAVPlayer@@PBUSpellEntry@@EW4SpellCastResult@@@Z+3283 00693AD0 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+4EA0 00692ED5 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+42A5 00698706 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+9AD6 00698538 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+9908 006979D2 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+8DA2 00455585 00000000 ?CastSpell@Unit@@QAEXPAV1@PBUSpellEntry@@_NPAVItem@@PAVAura@@_K@Z+1B5 004553C8 00000000 ?CastSpell@Unit@@QAEXPAV1@I_NPAVItem@@PAVAura@@_K@Z+118 00625006 00000000 ?HandleAddModifier@Aura@@QAEX_N0@Z+566 006236E6 00000000 ?ApplyModifier@Aura@@QAEX_N0@Z+66 0045D86E 00000000 ?AddAura@Unit@@QAE_NPAVAura@@@Z+87E 007FE6EE 00000000 ?HandleRepairItemOpcode@WorldSession@@QAEXAAVWorldPacket@@@Z+9CBE 0069CD13 00000000 ?SendCastResult@Spell@@SAXPAVPlayer@@PBUSpellEntry@@EW4SpellCastResult@@@Z+3283 00693AD0 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+4EA0 00692ED5 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+42A5 00698706 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+9AD6 00698538 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+9908 006979D2 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+8DA2 00455585 00000000 ?CastSpell@Unit@@QAEXPAV1@PBUSpellEntry@@_NPAVItem@@PAVAura@@_K@Z+1B5 004553C8 00000000 ?CastSpell@Unit@@QAEXPAV1@I_NPAVItem@@PAVAura@@_K@Z+118 00625006 00000000 ?HandleAddModifier@Aura@@QAEX_N0@Z+566 006236E6 00000000 ?ApplyModifier@Aura@@QAEX_N0@Z+66 0045D86E 00000000 ?AddAura@Unit@@QAE_NPAVAura@@@Z+87E 007FE6EE 00000000 ?HandleRepairItemOpcode@WorldSession@@QAEXAAVWorldPacket@@@Z+9CBE 0069CD13 00000000 ?SendCastResult@Spell@@SAXPAVPlayer@@PBUSpellEntry@@EW4SpellCastResult@@@Z+3283 00693AD0 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+4EA0 00692ED5 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+42A5 00698706 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+9AD6 00698538 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+9908 006979D2 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+8DA2 00455585 00000000 ?CastSpell@Unit@@QAEXPAV1@PBUSpellEntry@@_NPAVItem@@PAVAura@@_K@Z+1B5 004553C8 00000000 ?CastSpell@Unit@@QAEXPAV1@I_NPAVItem@@PAVAura@@_K@Z+118 00625006 00000000 ?HandleAddModifier@Aura@@QAEX_N0@Z+566 006236E6 00000000 ?ApplyModifier@Aura@@QAEX_N0@Z+66 0045D86E 00000000 ?AddAura@Unit@@QAE_NPAVAura@@@Z+87E 007FE6EE 00000000 ?HandleRepairItemOpcode@WorldSession@@QAEXAAVWorldPacket@@@Z+9CBE 0069CD13 00000000 ?SendCastResult@Spell@@SAXPAVPlayer@@PBUSpellEntry@@EW4SpellCastResult@@@Z+3283 00693AD0 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+4EA0 00692ED5 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+42A5 00698706 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+9AD6 00698538 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+9908 006979D2 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+8DA2 00455585 00000000 ?CastSpell@Unit@@QAEXPAV1@PBUSpellEntry@@_NPAVItem@@PAVAura@@_K@Z+1B5 004553C8 00000000 ?CastSpell@Unit@@QAEXPAV1@I_NPAVItem@@PAVAura@@_K@Z+118 00625006 00000000 ?HandleAddModifier@Aura@@QAEX_N0@Z+566 006236E6 00000000 ?ApplyModifier@Aura@@QAEX_N0@Z+66 0045D86E 00000000 ?AddAura@Unit@@QAE_NPAVAura@@@Z+87E 007FE6EE 00000000 ?HandleRepairItemOpcode@WorldSession@@QAEXAAVWorldPacket@@@Z+9CBE 0069CD13 00000000 ?SendCastResult@Spell@@SAXPAVPlayer@@PBUSpellEntry@@EW4SpellCastResult@@@Z+3283 00693AD0 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+4EA0 00692ED5 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+42A5 00698706 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+9AD6 00698538 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+9908 006979D2 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+8DA2 00455585 00000000 ?CastSpell@Unit@@QAEXPAV1@PBUSpellEntry@@_NPAVItem@@PAVAura@@_K@Z+1B5 004553C8 00000000 ?CastSpell@Unit@@QAEXPAV1@I_NPAVItem@@PAVAura@@_K@Z+118 00625006 00000000 ?HandleAddModifier@Aura@@QAEX_N0@Z+566 006236E6 00000000 ?ApplyModifier@Aura@@QAEX_N0@Z+66 0045D86E 00000000 ?AddAura@Unit@@QAE_NPAVAura@@@Z+87E 007FE6EE 00000000 ?HandleRepairItemOpcode@WorldSession@@QAEXAAVWorldPacket@@@Z+9CBE 0069CD13 00000000 ?SendCastResult@Spell@@SAXPAVPlayer@@PBUSpellEntry@@EW4SpellCastResult@@@Z+3283 00693AD0 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+4EA0 00692ED5 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+42A5 00698706 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+9AD6 00698538 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+9908 006979D2 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+8DA2 00455585 00000000 ?CastSpell@Unit@@QAEXPAV1@PBUSpellEntry@@_NPAVItem@@PAVAura@@_K@Z+1B5 004553C8 00000000 ?CastSpell@Unit@@QAEXPAV1@I_NPAVItem@@PAVAura@@_K@Z+118 00625006 00000000 ?HandleAddModifier@Aura@@QAEX_N0@Z+566 006236E6 00000000 ?ApplyModifier@Aura@@QAEX_N0@Z+66 0045D86E 00000000 ?AddAura@Unit@@QAE_NPAVAura@@@Z+87E 007FE6EE 00000000 ?HandleRepairItemOpcode@WorldSession@@QAEXAAVWorldPacket@@@Z+9CBE 0069CD13 00000000 ?SendCastResult@Spell@@SAXPAVPlayer@@PBUSpellEntry@@EW4SpellCastResult@@@Z+3283 00693AD0 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+4EA0 00692ED5 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+42A5 00698706 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+9AD6 00698538 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+9908 006979D2 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+8DA2 00455585 00000000 ?CastSpell@Unit@@QAEXPAV1@PBUSpellEntry@@_NPAVItem@@PAVAura@@_K@Z+1B5 004553C8 00000000 ?CastSpell@Unit@@QAEXPAV1@I_NPAVItem@@PAVAura@@_K@Z+118 00625006 00000000 ?HandleAddModifier@Aura@@QAEX_N0@Z+566 006236E6 00000000 ?ApplyModifier@Aura@@QAEX_N0@Z+66 0045D86E 00000000 ?AddAura@Unit@@QAE_NPAVAura@@@Z+87E 007FE6EE 00000000 ?HandleRepairItemOpcode@WorldSession@@QAEXAAVWorldPacket@@@Z+9CBE 0069CD13 00000000 ?SendCastResult@Spell@@SAXPAVPlayer@@PBUSpellEntry@@EW4SpellCastResult@@@Z+3283 00693AD0 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+4EA0 00692ED5 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+42A5 00698706 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+9AD6 00698538 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+9908 006979D2 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+8DA2 00455585 00000000 ?CastSpell@Unit@@QAEXPAV1@PBUSpellEntry@@_NPAVItem@@PAVAura@@_K@Z+1B5 004553C8 00000000 ?CastSpell@Unit@@QAEXPAV1@I_NPAVItem@@PAVAura@@_K@Z+118 00625006 00000000 ?HandleAddModifier@Aura@@QAEX_N0@Z+566 006236E6 00000000 ?ApplyModifier@Aura@@QAEX_N0@Z+66 0045D86E 00000000 ?AddAura@Unit@@QAE_NPAVAura@@@Z+87E 007FE6EE 00000000 ?HandleRepairItemOpcode@WorldSession@@QAEXAAVWorldPacket@@@Z+9CBE 0069CD13 00000000 ?SendCastResult@Spell@@SAXPAVPlayer@@PBUSpellEntry@@EW4SpellCastResult@@@Z+3283 00693AD0 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+4EA0 00692ED5 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+42A5 00698706 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+9AD6 00698538 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+9908 006979D2 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+8DA2 00455585 00000000 ?CastSpell@Unit@@QAEXPAV1@PBUSpellEntry@@_NPAVItem@@PAVAura@@_K@Z+1B5 004553C8 00000000 ?CastSpell@Unit@@QAEXPAV1@I_NPAVItem@@PAVAura@@_K@Z+118 00625006 00000000 ?HandleAddModifier@Aura@@QAEX_N0@Z+566 006236E6 00000000 ?ApplyModifier@Aura@@QAEX_N0@Z+66 0045D86E 00000000 ?AddAura@Unit@@QAE_NPAVAura@@@Z+87E 007FE6EE 00000000 ?HandleRepairItemOpcode@WorldSession@@QAEXAAVWorldPacket@@@Z+9CBE 0069CD13 00000000 ?SendCastResult@Spell@@SAXPAVPlayer@@PBUSpellEntry@@EW4SpellCastResult@@@Z+3283 00693AD0 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+4EA0 00692ED5 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+42A5 00698706 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+9AD6 00698538 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+9908 006979D2 00000000 ?Update@?$ConfusedMovementGenerator@VPlayer@@@@QAE_NAAVPlayer@@ABI@Z+8DA2 00455585 00000000 ?CastSpell@Unit@@QAEXPAV1@PBUSpellEntry@@_NPAVItem@@PAVAura@@_K@Z+1B5 004553C8 00000000 ?CastSpell@Unit@@QAEXPAV1@I_NPAVItem@@PAVAura@@_K@Z+118 004C1A41 00000000 ?addSpell@Player@@QAE_NI_N000@Z+10F1 004F00C3 00000000 ?_LoadSpells@Player@@IAEXPAVQueryResult@@@Z+C3 004EC996 00000000 ?LoadFromDB@Player@@QAE_NIPAVSqlQueryHolder@@@Z+2A36 00837858 00000000 ?HandlePlayerLogin@WorldSession@@QAEXPAVLoginQueryHolder@@@Z+178 008376D0 00000000 ?HandlePlayerLoginOpcode@WorldSession@@QAEXAAVWorldPacket@@@Z+290 0083BCBD 00000000 ?HandleEquipmentSetUse@WorldSession@@QAEXAAVWorldPacket@@@Z+70D 00850FAF 00000000 ?GetFloatDefault@Config@@QAEMPBDM@Z+339F 005E8BD5 00000000 ??0CreatureEventAI@@QAE@ABV0@@Z+7F65 005E7576 00000000 ??0CreatureEventAI@@QAE@ABV0@@Z+6906 0042F6EE 00000000 ?getSource@?$Reference@V?$GridRefManager@VCorpse@@@@VCorpse@@@@QBEPAVCorpse@@XZ+1801E 0084E9A9 00000000 ?GetFloatDefault@Config@@QAEMPBDM@Z+D99 71CC1B84 00000000 ?invoke@ACE_OS_Thread_Adapter@@UAEKXZ+74 723E3433 00000000 _endthreadex+44 723E34C7 00000000 _endthreadex+D8 7577ECCB 00000000 BaseThreadInitThunk+E 7773D24D 00000000 RtlCreateUserProcess+8C 7773D45F 00000000 RtlCreateProcessParameters+4E ======================== Local Variables And Parameters

I made myself the same question

It isnt working for latest revs megosh could you provide us the source of your patch? so we could keep it updated, if you want can send it to me via PM, i tried to send you want but u set to not allow PM. Thanks in advance.

I manually fix the patch and already apply it. I got a custom telenpc, the antihack is gonna have problems with it?? Havent tested myself ^^ Thanks P.D: Ok, tested and working just perfect , btw megosh, where can we find that antihack you talking about? just to keep it updated =)

megosh, if you can post the patch here, it would be awsome. Thanks

I tryed to apply this but the Git tell me "patch with only garbage at line 5"

BUMP again for devs?? this should be a good patch to review, and apply

A question, I'm using MangChat for the global channel thing, the auto invite (to avoid speaking at the LFG as general, and also that some people have problems with it cause they have their client in another language. I'm not currently using the IRC client. Is there any way that when someone auto join the Global channel (Called Assassin in my server) it doesnt spawn the "[6. Assassin] [%S] Joined channel" and "[6. Assassin] [%S] Left channel"

Could please someone help me with this?