db error

[Yonick19]

HERAKLES Otomatik Avlı kalıcı sunucu. 19 Haziran'da açılıyor. Atius & Wizard güvencesiyle hemen kayıt ol, ön kayıt ödülleri aktif. HEMEN TIKLA!

I have an error CombatZoneResetRanking: The giving ranking medals not was possible because not was exist 3 players on ranking weekly


Mi ClientManager.cpp



#if defined(WJ_COMBAT_ZONE)
void CClientManager::CombatZoneResetRanking(const TPacketGDCombatZoneResetRanking* p)
{
CDBManager::instance().DirectQuery("UPDATE player.player SET combat_zone_rank = 0 WHERE combat_zone_rank > 0");

std::auto_ptr<SQLMsg> pMsg(CDBManager::instance().DirectQuery("SELECT * FROM player.combat_zone_ranking_weekly ORDER BY memberPoints DESC LIMIT 3"));
if (pMsg->Get()->uiNumRows == 3)
{
MYSQL_ROW row;
int memberRank = 1;
char szQuery[512 + 1];
while ((row = mysql_fetch_row(pMsg->Get()->pSQLResult)))
{
sprintf(szQuery, "UPDATE player.player SET combat_zone_rank = '%d' WHERE name = '%s'", memberRank, row[0]);
CDBManager::instance().DirectQuery(szQuery);
memberRank++;
}
}
else {
sys_err("The giving ranking medals not was possible because not was exist 3 players on ranking weekly.");
}

CDBManager::instance().DirectQuery("TRUNCATE TABLE player.combat_zone_ranking_weekly");
}

void CClientManager::UpdateSkillsCache(const TPacketGDCombatZoneSkillsCache* p)
{
char szQuery[2048 + 1];
sprintf(szQuery,
"INSERT INTO player.combat_zone_skills_cache (pid, skillLevel1, skillLevel2, skillLevel3, skillLevel4, skillLevel5, skillLevel6) "
"VALUES('%d', '%d', '%d', '%d', '%d', '%d', '%d') "
"ON DUPLICATE KEY UPDATE skillLevel1 = '%d', skillLevel2 = '%d', skillLevel3 = '%d', skillLevel4 = '%d', skillLevel5 = '%d', skillLevel6 = '%d'",
p->dwPID, p->dwSkillLevel1, p->dwSkillLevel2, p->dwSkillLevel3, p->dwSkillLevel4, p->dwSkillLevel5, p->dwSkillLevel6, p->dwSkillLevel1, p->dwSkillLevel2, p->dwSkillLevel3, p->dwSkillLevel4, p->dwSkillLevel5, p->dwSkillLevel6);
CDBManager::instance().DirectQuery(szQuery);
}
#endif


Help?