Advertisement
tatianka

Untitled

Jun 3rd, 2024
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Pawn 2.02 KB | Gaming | 0 0
  1. COMMAND:history(playerid, params[])
  2. {
  3.     if(sscanf(params, "s[24]", params[0])) return SendClientMessage(playerid, COLOR_LIGHTGREY, !"Èñïîëüçóéòå /history [èìÿ èãðîêà]");
  4.     new query[73];
  5.     format(query, sizeof(query), "SELECT * FROM `accounts` WHERE `pName` = '%s'", params[0]);
  6.     mysql_tquery(mysqlconnect, query, !"OnPlayerCheckHistoryName", !"ds", playerid, params[0]);
  7.     return true;
  8. }
  9.  
  10. forward OnPlayerCheckHistoryName(playerid, player_name[]);
  11. public OnPlayerCheckHistoryName(playerid, player_name[])
  12. {
  13.     new rows;
  14.     cache_get_row_count(rows);
  15.     if(!rows)
  16.     {
  17.         SendClientMessage(playerid, COLOR_DARKGREY, !"Игрок с таким именем не найден");
  18.     }
  19.     else
  20.     {
  21.         new player_id, query[74 + 11];
  22.         cache_get_value_name_int(0, "pID", player_id);
  23.  
  24.         format(query, sizeof(query), "SELECT * FROM `history` WHERE `pID` = '%d' ORDER BY `number` DESC LIMIT 25", player_id);
  25.         mysql_tquery(mysqlconnect, query, !"OnPlayerHistoryName", !"ds", playerid, player_name);
  26.     }
  27.     return true;
  28. }
  29.  
  30. forward OnPlayerHistoryName(playerid, player_name[]);
  31. public OnPlayerHistoryName(playerid, player_name[])
  32. {
  33.     new rows;
  34.     cache_get_row_count(rows);
  35.     new string_title[22 + MAX_PLAYER_NAME];
  36.     format(string_title, sizeof(string_title), "{FFCD00}Прошлые имена %s\t\t\t", player_name);
  37.     if(!rows)
  38.     {
  39.         ShowPlayerDialog(playerid, DIALOG_INFORMATION, DIALOG_STYLE_MSGBOX, string_title, !"{FFFFFF}История изменения имён персонажа пуста", !"Закрыть", "");
  40.     }
  41.     else
  42.     {
  43.         new playername[MAX_PLAYER_NAME], date[16], string[(10 + MAX_PLAYER_NAME)*25];
  44.         for(new i; i < rows; i++)
  45.         {
  46.             cache_get_value_name(i, "pName", playername, MAX_PLAYER_NAME);
  47.             cache_get_value_name(i, "pDate", date, 16);
  48.  
  49.             format(string, sizeof(string), "%s{FFFFFF}До %s\t%s\n", string, date, playername);
  50.         }
  51.         ShowPlayerDialog(playerid, DIALOG_INFORMATION, DIALOG_STYLE_MSGBOX, string_title, string, !"Закрыть", "");
  52.     }
  53.     return true;
  54. }
  55.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement