28.07.2016, 15:39
(
Последний раз редактировалось Shinja; 28.07.2016 в 16:16.
)
The command:
This loop isn't getting info from database right way
Why? and how to fix it?
PHP код:
CMD:sban(playerid, params[])
{
new n[24], admin[24], IP[16], reason[56], Day[2], Year[4], Month[2], Hour[2], Minute[2], Second[2];
if(pAdmin[playerid] < 2) return SendClientMessage(playerid, 0xCD0000FF, "Invalid command. Please use {FFF8CF}/cmds {CD0000}to list all available commands.");
if(sscanf(params, "s[24]", n)) return SendClientMessage(playerid, -1, "{0008F7}USAGE: {FFFFFF}/SBAN NAME");
new query[200];
format(query, sizeof(query),"SELECT Admin,Player,Reason,IP,Day,Month,Year,Hour,Minute,Second FROM `Bans` WHERE `Player`='%s'", n);
mysql_query(query);
mysql_store_result();
new rows = mysql_num_rows();
if(rows == 1)
{
while(mysql_fetch_row(query))
{
mysql_fetch_field_row(admin, "Admin");
mysql_fetch_field_row(IP, "IP");
mysql_fetch_field_row(reason, "Reason");
mysql_fetch_field_row(Day, "Day");
mysql_fetch_field_row(Month, "Month");
mysql_fetch_field_row(Year, "Year");
mysql_fetch_field_row(Hour, "Hour");
mysql_fetch_field_row(Minute, "Minute");
mysql_fetch_field_row(Second, "Second");
}
new string[224], name[24];
GetPlayerName(playerid, name, sizeof(name));
format(string,sizeof(string),"{0008F7}[Administration]: {FF0095}%s {C90076}have used {FF0095}SBAN", name);
SendToAdmins(-1, string);
format(string, sizeof(string), "{9384CF}Account: %s Banned by %s on %d:%d:%d the %d/%d/%d for %s", n, admin, Hour, Minute, Second, Day,Month, Year, reason);
SendClientMessage(playerid, -1, string);
}
if(!rows)
{
SendClientMessage(playerid, 0xCD0000FF, "Account no banned or not exists");
}
return 1;
}
PHP код:
while(mysql_fetch_row(query))
{
mysql_fetch_field_row(admin, "Admin");
mysql_fetch_field_row(IP, "IP");
mysql_fetch_field_row(reason, "Reason");
mysql_fetch_field_row(Day, "Day");
mysql_fetch_field_row(Month, "Month");
mysql_fetch_field_row(Year, "Year");
mysql_fetch_field_row(Hour, "Hour");
mysql_fetch_field_row(Minute, "Minute");
mysql_fetch_field_row(Second, "Second");
}