Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UpdateTopKillsTextdraws()
- {
- new score_str[256], query[128],kills, str[256];
- new finalname[256], finalkill[256];
- mysql_format(g_MySQLHandle, query, 128, "SELECT name, SUM(cyclekills) AS totalammount FROM `visits` GROUP BY name HAVING COUNT(name)>1 ORDER BY totalammount DESC LIMIT 5");
- mysql_query(g_MySQLHandle, query, true);
- if(!cache_get_row_count())
- {
- finalname = "Name~n~-~n~-~n~-~n~-~n~-";
- finalkill = "Kills~n~-~n~-~n~-~n~-~n~-~n~";
- }
- else if(!!cache_get_row_count())
- {
- new j = cache_get_row_count();
- for(new x = 0; x < j; x++)
- {
- cache_get_field_content(x, "name", query);
- kills = cache_get_field_content_int(x, "totalammount");
- format(str, sizeof str, "%s%s~n~", str, query);
- format(score_str, sizeof score_str, "%s%d~n~", score_str, kills);
- }
- format(finalname, 256, "Name~n~%s", str);
- format(finalkill, 256, "Kills~n~%s", score_str);
- }
- for(new i, max_playerid = GetPlayerPoolSize(); i <= max_playerid; i ++)
- {
- if( IsPlayerConnected(i))
- {
- PlayerTextDrawSetString(i, g_TopKillsTextdraw[i][TOPKILLS_TD_POS], "Pos~n~01~n~02~n~03~n~04~n~05");
- PlayerTextDrawSetString(i, g_TopKillsTextdraw[i][TOPKILLS_TD_NAME], finalname);
- PlayerTextDrawSetString(i, g_TopKillsTextdraw[i][TOPKILLS_TD_KILLS], finalkill);
- ShowTopKillsTextdraws(i);
- }
- }
- return 1;
- }
Add Comment
Please, Sign In to add comment