Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- COMMAND:history(playerid, params[])
- {
- if(sscanf(params, "s[24]", params[0])) return SendClientMessage(playerid, COLOR_LIGHTGREY, !"Èñïîëüçóéòå /history [èìÿ èãðîêà]");
- new query[73];
- format(query, sizeof(query), "SELECT * FROM `accounts` WHERE `pName` = '%s'", params[0]);
- mysql_tquery(mysqlconnect, query, !"OnPlayerCheckHistoryName", !"ds", playerid, params[0]);
- return true;
- }
- forward OnPlayerCheckHistoryName(playerid, player_name[]);
- public OnPlayerCheckHistoryName(playerid, player_name[])
- {
- new rows;
- cache_get_row_count(rows);
- if(!rows)
- {
- SendClientMessage(playerid, COLOR_DARKGREY, !"Игрок с таким именем не найден");
- }
- else
- {
- new player_id, query[74 + 11];
- cache_get_value_name_int(0, "pID", player_id);
- format(query, sizeof(query), "SELECT * FROM `history` WHERE `pID` = '%d' ORDER BY `number` DESC LIMIT 25", player_id);
- mysql_tquery(mysqlconnect, query, !"OnPlayerHistoryName", !"ds", playerid, player_name);
- }
- return true;
- }
- forward OnPlayerHistoryName(playerid, player_name[]);
- public OnPlayerHistoryName(playerid, player_name[])
- {
- new rows;
- cache_get_row_count(rows);
- new string_title[22 + MAX_PLAYER_NAME];
- format(string_title, sizeof(string_title), "{FFCD00}Прошлые имена %s\t\t\t", player_name);
- if(!rows)
- {
- ShowPlayerDialog(playerid, DIALOG_INFORMATION, DIALOG_STYLE_MSGBOX, string_title, !"{FFFFFF}История изменения имён персонажа пуста", !"Закрыть", "");
- }
- else
- {
- new playername[MAX_PLAYER_NAME], date[16], string[(10 + MAX_PLAYER_NAME)*25];
- for(new i; i < rows; i++)
- {
- cache_get_value_name(i, "pName", playername, MAX_PLAYER_NAME);
- cache_get_value_name(i, "pDate", date, 16);
- format(string, sizeof(string), "%s{FFFFFF}До %s\t%s\n", string, date, playername);
- }
- ShowPlayerDialog(playerid, DIALOG_INFORMATION, DIALOG_STYLE_MSGBOX, string_title, string, !"Закрыть", "");
- }
- return true;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement