PDA

Просмотр полной версии : [Вопрос] Перевод на MySql R41



Vasya_Pupkin
07.03.2018, 21:23
Всем привет.
Помогите перевести на MySql R41


forward warninfo(playerid);
public warninfo(playerid)
{
new rows, fields, string[295], data[11], time[9], anick[24], reason[34], query[34];
cache_get_data(rows, fields);
format(string, sizeof(string), "{ffcf00}Дата и время\t\t Кем выдан\tПричина{FFFFFF}\n\n");
for(new i = 0; i < rows; i++)
{
cache_get_value_name_int(i, "date", query); strmid(data, query, 0, strlen(query), 11);
cache_get_value_name_int(i, "time", query); strmid(time, query, 0, strlen(query), 9);
cache_get_value_name_int(i, "anick", query); strmid(anick, query, 0, strlen(query), MAX_PLAYER_NAME);
cache_get_value_name_int(i, "reason", query); strmid(reason, query, 0, strlen(query), 34);
format(string, sizeof(string), "%s%s %s\t%s\t%s\n", string, data, time, anick, reason);
}
SPD(playerid, 0, DIALOG_STYLE_MSGBOX, "{ff5500}Действующие предупреждения", string, "Закрыть", "");
return 1;
}

Elrmrnt-Kritik
07.03.2018, 22:19
forward warninfo(playerid);
public warninfo(playerid)
{
if(!cache_num_rows())
return 0;


new string[295], data[11], time[9], anick[24], reason[34];
strcat(string, "{ffcf00}Дата и время\t\t Кем выдан\tПричина{FFFFFF}\n\n");
for(new i = 0; i < cache_num_rows(); i++)
{
cache_get_value_name(i, "date", data, sizeof(data));
cache_get_value_name(i, "time", time, sizeof(time));
cache_get_value_name(i, "anick", anick, sizeof(anick));
cache_get_value_name(i, "reason", reason, sizeof(reason));
format(string, sizeof(string), "%s%s %s\t%s\t%s\n", string, data, time, anick, reason);
}
SPD(playerid, 0, DIALOG_STYLE_MSGBOX, "{ff5500}Действующие предупреждения", string, "Закрыть", "");
return 1;
}