*Resursă folosită:marty
*ServerFiles utilizat:marty
*Detalii suplimentare:
Am urmatoarea problema:
-Cand iau un item de UP mil baga in item ca find in BELT_INVENTORY
-Daca iau o carte o baga in GROUND adica dupa un reboot dispare si din inventar
-Daca iau o piatra o baga in UPGRADE_INVENTORY
Normal ar trebui sa le bage in UPGRADE_INVENTORY, BOOK_INVENTORY, STONE_INVENTORY
ClientManagerPlayer al meu arata asa unde trebuia sa editez:
Cod: Selectaţi tot
snprintf(szQuery, sizeof(szQuery),
"SELECT id,window+0,pos,count,vnum,socket0,socket1,socket2,attrtype0,attrvalue0,attrtype1,attrvalue1,attrtype2,attrvalue2,attrtype3,attrvalue3,attrtype4,attrvalue4,attrtype5,attrvalue5,attrtype6,attrvalue6 "
"FROM item%s WHERE owner_id=%d AND (window in ('INVENTORY','EQUIPMENT','DRAGON_SOUL_INVENTORY','BELT_INVENTORY','UPGRADE_INVENTORY','BOOK_INVENTORY','STONE_INVENTORY'))",
GetTablePostfix(), pTab->id);Cod: Selectaţi tot
snprintf(queryStr, sizeof(queryStr),
"SELECT id,window+0,pos,count,vnum,socket0,socket1,socket2,attrtype0,attrvalue0,attrtype1,attrvalue1,attrtype2,attrvalue2,attrtype3,attrvalue3,attrtype4,attrvalue4,attrtype5,attrvalue5,attrtype6,attrvalue6 "
"FROM item%s WHERE owner_id=%d AND (window in ('INVENTORY','EQUIPMENT','DRAGON_SOUL_INVENTORY','BELT_INVENTORY','UPGRADE_INVENTORY','BOOK_INVENTORY','STONE_INVENTORY'))",
GetTablePostfix(), packet->player_id);
CDBManager::instance().ReturnQuery(queryStr, QID_ITEM, peer->GetHandle(), new ClientHandleInfo(dwHandle, packet->player_id));Cod: Selectaţi tot
snprintf(queryStr, sizeof(queryStr), "DELETE FROM item%s WHERE owner_id=%d AND (window in ('INVENTORY','EQUIPMENT','DRAGON_SOUL_INVENTORY','BELT_INVENTORY','UPGRADE_INVENTORY','BOOK_INVENTORY','STONE_INVENTORY'))", GetTablePostfix(), pi->player_id);
delete CDBManager::instance().DirectQuery(queryStr);Folosesc acesta: Special
T.C
de 
de