bool MySQL::GetRankingList(LobbyPlayerList* List)
{
MYSQL_RES* pResult;
MYSQL_ROW Row;
char query[1024];
//snprintf(query, 1024, "SELECT username, win, lose FROM `tb_user` WHERE `useremail` IS NOT NULL AND (`win` > 0 OR `lose` > 0) ORDER BY `win` DESC, `lose` ASC LIMIT 10;");
snprintf(query, 1024, "SELECT user, win, lose FROM `users` WHERE `mail` IS NOT NULL AND (`win` > 0 OR `lose` > 0) ORDER BY `win` DESC, `lose` ASC LIMIT 10;");
if(!DoQuery(query))
return false;
pResult = mysql_store_result(m_pMySQL);
unsigned int count = (unsigned int)mysql_num_rows(pResult);
if(count == 0)
{
mysql_free_result(pResult);
return true;
}
for(unsigned int i = 0; i < count; i++)
{
Row = mysql_fetch_row(pResult);
int punkte = atoi(Row[1]) * 100 - atoi(Row[2]) * 70;
if(punkte < 0)
punkte = 0;
LobbyPlayerInfo player;
player.setId(i + 1);
player.setName(Row[0]);
player.setGewonnen(atoi(Row[1]));
player.setVerloren(atoi(Row[2]));
player.setPunkte(punkte);
List->push_back(player);
}
mysql_free_result(pResult);
return true;
}
/**
*
*
*
* @author FloSoft
*/
bool MySQL::GetRankingInfo(LobbyPlayerInfo& player)
{
MYSQL_RES* pResult;
MYSQL_ROW Row;
char query[1024];
char name[256];
mysql_real_escape_string(m_pMySQL, name, player.getName().c_str(), (unsigned long)player.getName().length());
//snprintf(query, 1024, "SELECT username, win, lose FROM `tb_user` WHERE `username` = '%s' LIMIT 1;", name);
snprintf(query, 1024, "SELECT user, win, lose FROM `users` WHERE `user` = '%s' LIMIT 1;", name);
if(!DoQuery(query))
return false;
pResult = mysql_store_result(m_pMySQL);
if(mysql_num_rows(pResult) == 0)
{
mysql_free_result(pResult);
return true;
}
Row = mysql_fetch_row(pResult);
int punkte = atoi(Row[1]) * 100 - atoi(Row[2]) * 70;
if(punkte < 0)
punkte = 0;
//player.setId(0);
player.setName(Row[0]);
player.setGewonnen(atoi(Row[1]));
player.setVerloren(atoi(Row[2]));
player.setPunkte(punkte);
mysql_free_result(pResult);
return true;
}