07.05.2014, 11:13
Hello, I have the problem with stock... "OfflineBan"
In CMD every thing is alright, but when sendig info to stock, then ban reason[P6hjus] change to NULL
Here's cmd and stock.
Some translation... Estonian to English
Nimi = Name
P6hjus = Reason
Mдngja = User/Accont
Waiting for help.
Sorry for bad English.
In CMD every thing is alright, but when sendig info to stock, then ban reason[P6hjus] change to NULL
Here's cmd and stock.
PHP код:
//-------------------------- CMD: [/OfflineBan]-----------------------//
CMD:offlineban(playerid, params[])
{
new playerb[MAX_PLAYER_NAME], str[128], strmysql[256];
if(KasutajaInfo[playerid][pAdminTase]<3) return SendClientMessage(playerid, COLOR_RED, "Teil pole antud хigust kasutada!");
if(sscanf(params, "s[24]s[128]", playerb, str)) return SendClientMessage(playerid, COLOR_ORANGE, "|NДPUNДIDE|: {FFFFFF}/OfflineBan {FF9900}[{FFFFFF}Nimi{FF9900}] [{FFFFFF}Pхhjus{FF9900}]");
format(strmysql, sizeof(strmysql), "SELECT * FROM kasutajad WHERE Nimi = '%s' LIMIT 0,1", playerb);
mysql_function_query(SQL, strmysql, true, "OfflineBan", "is[24]s[128]", playerid, playerb, str);
return 1;
}
//---------------------------OfflineBan-----------------------//
forward OfflineBan(playerid, Nimi[], P6hjus[]);
public OfflineBan(playerid, Nimi[], P6hjus[])
{
new rows, fields, Query[256], number[11], string[256], Bannitud;
cache_get_data(rows, fields);
if(!rows) return SendClientMessage(playerid, COLOR_RED, "Sellise nimega isikut ei eksisteeri andmebaasis.");
else
{
cache_get_row(0, 26, number), Bannitud = strval(number);
if(Bannitud == 1) return SendClientMessage(playerid, COLOR_RED, "Valitud mдngja on siit serverist juba banned.");
else
{
format(Query, sizeof(Query), "UPDATE kasutajad SET Ban =1, BanP6hjus = '%s' WHERE Nimi = '%s'", P6hjus, Nimi);
mysql_function_query(SQL, Query, false, "", "");
format(string, sizeof(string), "[%s] %s lisas OfflineBanni mдngjale %s. | Pхhjus: %s", AdminLevel(playerid), PlayerName(playerid), Nimi, P6hjus);
SendAdminMessage(COLOR_GREEN, 1, string);
}
}
return 1;
}
Nimi = Name
P6hjus = Reason
Mдngja = User/Accont
Waiting for help.
Sorry for bad English.