Firecracker

when i add this system i cant see normal arrows and skill's arrows. could you help?

uppp

up....

this is my first login to game. and the skill number is the first skill of the ninja. when i try to login with warrior, it will be 1.

up

Hi devs, When i wanted to login to game, after loading screen game crashes. Syserr: 0912 20:36:42563 :: SYSERR: game.py(line:160) Open game.py(line:508) StartGame game.py(line:645) RefreshCharacter interfaceModule.py(line:624) RefreshCharacter uiCharacter.py(line:1046) RefreshCharacter uiCharacter.py(line:1102) __SelectSkillGroup uiCharacter.py(line:1088) __SetSkillSlotData uiCharacter.py(line:831) RefreshSkill uiCharacter.py(line:772) __RefreshSkillPage uiCharacter.py(line:1139) __GetRealSkillSlot GameWindow.Open - <type 'exceptions.RuntimeError'>:skill.CanUseSkill - Failed to find skill by 61 0912 20:36:42564 :: SYSERR: ============================================================================================================ 0912 20:36:42564 :: SYSERR: Abort!!!! Skilldesc.txt and skilltable.txt are OK. What is the problem? Can you help me?

thank you, solved.

hi devs I wanted to build my game with gcc8 and i upgraded crytopp, boots to last version. But i get linking error. I compiled cryptopp with gcc8 again and again. I also tried with pkg and used default cryptopp lib but always errors are there. This is my makefike: This are errors.

no

Push

push...

I fixed it. Mysql usage is %3-10 now. Crash problem is still exist. I said that i fixed mysql problem many times.

Scirred offline shop related with high mysql usage because every warp and in every 5 minutes there is a mysql search for every players. So i solved with adding indexes to player_gift table and mysql usage is OK now. My problem is not mysql usage my problem is core crash which tells me that bad memory alloc. Although i have enough ram my cores crash randomly in a few days. I just wanted to learn that if someone faced a problem like this. It can be because of adding a system like transmutaion, new pets or just because of freebsd 10.3. I already disabled log tables from source.

Up

Up

Help pls. What can cause this crash?

Mysql usage is OK. But core crashes randomly because of the same problem.

i dont know why the code which is above causes %4 mysql usage for every player. How this query cause? The website also has sorting query but it doesn't increase mysql usage for example. Do you have any idea? Edit: I think i solved problem. Thanks all for your help. I just added indexes my player_gift table with following code. Now mysql usage is OK. ALTER TABLE player_gift ADD INDEX episode_active(owner_id, status);

thanks for reply. i dont need mysql log anymore because i found what causes high usage of mysql. i used this query when i warp and when i close shop. select * from INFORMATION_SCHEMA.PROCESSLIST where db = 'player' i found that when i warp and when i close my shop there is a control on mysql and it causes high mysql usage. now i have to modify this code. thanks all for your help up to here. any idea how i modify this code? this code is: void CHARACTER::RefreshGift() { char szSockets[1024] = { '\0' }; char *tempSockets = szSockets; for (int i = 0; i < ITEM_SOCKET_MAX_NUM; i++) { tempSockets += sprintf(tempSockets, "socket%d", i); if (i<ITEM_SOCKET_MAX_NUM - 1) tempSockets += sprintf(tempSockets, ","); } char szAttrs[1024] = { '\0' }; char *tempAttrs = szAttrs; for (int i = 0; i < ITEM_ATTRIBUTE_MAX_NUM; i++) { if (i < 7) tempAttrs += sprintf(tempAttrs, "attrtype%d,attrvalue%d", i, i); else tempAttrs += sprintf(tempAttrs, "applytype%d,applyvalue%d", i - 7, i - 7); if (i<ITEM_ATTRIBUTE_MAX_NUM - 1) tempAttrs += sprintf(tempAttrs, ","); } #ifdef __CHANGE_LOOK_SYSTEM__ SQLMsg * pkMsg(DBManager::instance().DirectQuery("SELECT id,vnum,count,unix_timestamp(date_add),replace(reason,' ','_'),replace(`from`,' ','_'),%s,%s,dwLookVnum from player_gift where owner_id = %d and status = 'WAIT' ORDER BY date_add ", szSockets, szAttrs, GetPlayerID())); #else SQLMsg * pkMsg(DBManager::instance().DirectQuery("SELECT id,vnum,count,unix_timestamp(date_add),replace(reason,' ','_'),replace(`from`,' ','_'),%s,%s from player_gift where owner_id = %d and status = 'WAIT' ORDER BY date_add ", szSockets, szAttrs, GetPlayerID())); #endif SQLResult * pRes = pkMsg->Get(); m_mapGiftGrid.clear(); grid = M2_NEW CGrid(15, 8); grid->Clear(); int page = 1; if (pRes->uiNumRows>0) { AddGiftGrid(page); MYSQL_ROW row; while ((row = mysql_fetch_row(pRes->pSQLResult)) != NULL) { int col = 0; TGiftItem item; memset(&item, 0, sizeof(item)); str_to_number(item.id, row[col++]); str_to_number(item.vnum, row[col++]); str_to_number(item.count, row[col++]); str_to_number(item.dwDateAdd, row[col++]); strlcpy(item.szReason, row[col++], sizeof(item.szReason) - 1); strlcpy(item.szFrom, row[col++], sizeof(item.szFrom) - 1); for (int i = 0; i < ITEM_SOCKET_MAX_NUM; i++) str_to_number(item.alSockets[i], row[col++]); for (int i = 0; i < ITEM_ATTRIBUTE_MAX_NUM; i++) { str_to_number(item.aAttr[i].bType, row[col++]); str_to_number(item.aAttr[i].sValue, row[col++]); } #ifdef __CHANGE_LOOK_SYSTEM__ str_to_number(item.dwLookVnum, row[col++]); #endif const TItemTable * item_table = ITEM_MANAGER::instance().GetTable(item.vnum); if (!item_table) continue; int iPos = AddGiftGridItem( page, item_table->bSize); if (iPos < 0) { page++; grid->Clear(); iPos = AddGiftGridItem(page, item_table->bSize); if (iPos < 0) { sys_err("iPos <0"); break; } } item.pos = iPos; m_mapGiftGrid[page].push_back(item); } M2_DELETE(grid); } if(GetGiftPages()>0) ChatPacket(CHAT_TYPE_COMMAND, "gift_info %d", GetGiftPages()); } #endif

i activated general_log and slow_query_log but there is nothing. when i check on my test server i realized that i warp any map and mysql usage goes up to %4 usage. And after 10 seconds it goes down to 0. edit: when i activated mysql logs, there is not general_log table. i created manually.

I know. But i dont know what uses mysql. My server files contains scirred offline shop and official pet system and they rape mysql i think. All log tables disabled already.

but how? future of my system is very good i think. [Hidden Content]

it is already undefined. thanks for reply.

in char_manager.cpp 84 LPCHARACTER ch = M2_NEW CHARACTER; in char_manager.cpp 419 LPCHARACTER ch = CHARACTER_MANAGER::instance().CreateCharacter(pkMob->m_table.szLocaleName); in char_manager.cpp 470 LPCHARACTER ch = SpawnMob(dwVnum, lMapIndex, x, y, 0, bSpawnMotion); in char_manager.cpp 600 LPCHARACTER tch = SpawnMobRange(c_rdwMembers, lMapIndex, sx, sy, ex, ey, true, bSpawnedByStone); in char_state.cpp 449 CHARACTER_MANAGER::instance().SpawnGroup(dwVnum, GetMapIndex(), GetX() - 1000, GetY() - 1000, GetX() + 1000, GetY() + 1000); in char.cpp 4455 Update(); in char_manager.cpp 699 for_each(v.begin(), v.end(), bind2nd(mem_fun(&CHARACTER::UpdateStateMachine), iPulse)); Pls help me. It is random crash. I dont know what causes this.

help pls one more time core crashed. 0 0x288f68d7 in thr_kill () from /usr/lib32/libc.so.7 #1 0x288f68ca in raise () from /usr/lib32/libc.so.7 #2 0x288f6816 in abort () from /usr/lib32/libc.so.7 #3 0x2874f595 in __gnu_cxx::__verbose_terminate_handler () at ../../.././../gcc-4.8-20131212/libstdc++-v3/libsupc++/vterminate.cc:95 #4 0x2874c295 in __cxxabiv1::__terminate (handler=0x2874f400 <__gnu_cxx::__verbose_terminate_handler()>) at ../../.././../gcc-4.8-20131212/libstdc++-v3/libsupc++/eh_terminate.cc:38 #5 0x2874c2ef in std::terminate () at ../../.././../gcc-4.8-20131212/libstdc++-v3/libsupc++/eh_terminate.cc:48 #6 0x2874c54e in __cxxabiv1::__cxa_throw (obj=0x4f466540, tinfo=0x86b7460 <typeinfo for std::bad_alloc@@GLIBCXX_3.4>, dest=0x804ddf0 <std::bad_alloc::~bad_alloc()@plt>) at ../../.././../gcc-4.8-20131212/libstdc++-v3/libsupc++/eh_throw.cc:84 #7 0x2874dafe in operator new (sz=sz@entry=12120) at ../../.././../gcc-4.8-20131212/libstdc++-v3/libsupc++/new_op.cc:56 #8 0x080af313 in CHARACTER_MANAGER::CreateCharacter (this=0xffffbe48, name=name@entry=0x2a35099d "Yeti", dwPID=dwPID@entry=0) at char_manager.cpp:84 #9 0x080afda9 in CHARACTER_MANAGER::SpawnMob (this=this@entry=0xffffbe48, dwVnum=dwVnum@entry=1106, lMapIndex=lMapIndex@entry=660141, x=x@entry=268418, y=731821, z=z@entry=0, bSpawnMotion=bSpawnMotion@entry=true, iRot=iRot@entry=-1, bShow=bShow@entry=true) at char_manager.cpp:419 #10 0x080b01ca in CHARACTER_MANAGER::SpawnMobRange (this=this@entry=0xffffbe48, dwVnum=1106, lMapIndex=lMapIndex@entry=660141, sx=sx@entry=267865, sy=sy@entry=731794, ex=ex@entry=268613, ey=ey@entry=732668, bIsException=bIsException@entry=true, bSpawnMotion=<optimized out>, bSpawnMotion@entry=true, bAggressive=bAggressive@entry=false) at char_manager.cpp:470 #11 0x080b067d in CHARACTER_MANAGER::SpawnGroup (this=0xffffbe48, dwVnum=dwVnum@entry=1113, lMapIndex=660141, sx=267865, sy=731794, ex=268613, ey=732668, pkRegen=pkRegen@entry=0x0, bAggressive_=bAggressive_@entry=false, pDungeon=pDungeon@entry=0x0) at char_manager.cpp:600 #12 0x080c4f54 in CHARACTER::__StateIdle_Stone (this=0x28322000) at char_state.cpp:449 #13 0x0806e2f8 in CHARACTER::UpdateStateMachine (this=0x28322000, dwPulse=6170391) at char.cpp:4455 #14 0x080b0e9e in std::mem_fun1_t<void, CHARACTER, unsigned int>::operator() (x=6170391, p=<optimized out>, this=0xffffa2bc) at /usr/local/lib/gcc48/include/c++/bits/stl_function.h:623 #15 std::binder2nd<std::mem_fun1_t<void, CHARACTER, unsigned int> >::operator() (__x=<optimized out>, this=0xffffa2bc) at /usr/local/lib/gcc48/include/c++/backward/binders.h:160 #16 std::for_each<__gnu_cxx::__normal_iterator<CHARACTER*, std::vector<CHARACTER, std::allocator<CHARACTER*> > >, std::binder2nd<std::mem_fun1_t<void, CHARACTER, unsigned int> > > (__first=..., last=..., f=...) at /usr/local/lib/gcc48/include/c++/bits/stl_algo.h:4440 #17 0x080aecbf in CHARACTER_MANAGER::Update (this=0xffffbe48, iPulse=6170391) at char_manager.cpp:699 #18 0x082120d4 in idle () at main.cpp:979 #19 0x08054b9d in main (argc=1, argv=0xffffdc24) at main.cpp:640