SYSER:
SYSERR: Mar 19 13:38:57 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'window = 'PRIVATE_SHOP' and owner_id=12' at line 1
query: SELECT id FROM item WHERE window = 'PRIVATE_SHOP' and owner_id=12ClientManager.cpp:
Linkleri görebilmek için
giriş yap veya kayıt ol.
Syserin geçtiği satır ise 500. satırda başlıyor.
C++:
pi->pSafebox = pSafebox;
char szQuery[1024];
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"
#ifdef ENABLE_PREMIUM_PRIVATE_SHOP
", price, shop_id "
#endif
"FROM item%s WHERE `owner_id`=%d AND `window`='PRIVATE_SHOP'", GetTablePostfix(), pi->player_id);
pi->account_index = 1;
CDBManager::instance().ReturnQuery(szQuery, QID_SAFEBOX_LOAD, pkPeer->GetHandle(), pi);
