08.03.2019, 22:42
After entering calls - Player not found.
But the player is in the database.
if(cont == 0) return SCM(playerid, COLOR_LIGHTGREEN3, "Player not found.");
mysql_real_escape_string(reason, reasone);
But the player is in the database.
if(cont == 0) return SCM(playerid, COLOR_LIGHTGREEN3, "Player not found.");
mysql_real_escape_string(reason, reasone);
PHP код:
function MySQLCheckAccount( playername[ ] ) {
new playerID; gString[ 0 ] = (EOS);
format( gString, sizeof gString, "SELECT * FROM `users` WHERE `name` = '%e'", playername );
new Cache: usercache = mysql_query( SQL, gString );
if( !cache_get_row_count( ) ) {
cache_delete( usercache );
return false;
}
playerID = cache_get_field_content_int( 0, "id" );
cache_delete( usercache );
return playerID; }
PHP код:
YCMD:banoff(playerid, params[], help) {
if(gPlayerLogged[playerid] == 0) return SendClientMessage(playerid, COLOR_LIGHTRED, "Nie jesteś zalogowany!");
if(IsPlayerConnected(playerid))
{
if(PlayerInfo[playerid][pAdmin] >= 1)
{
new id[30],reason[128],reasone[128],string[200],sendername[30],days,str[1400],year,month,day,hour,minute,second,time,cont,qstr[500],playeridd,escape[30],admlevel;
if(sscanf(params, "s[30]ds[128]", id,days,reason)) return SCM(playerid, COLOR_WHITE, "{AB0000}Użyj: {FFFFFF}/banoff [exactly name] [day/0= perm] [reason]");
if(days < 0) return SCM(playerid, COLOR_WHITE, "{AB0000}Użyj: {FFFFFF}/banoff [exactly name] [day/0= perm] [reason]");
cont = MySQLCheckAccount(id);
if(cont == 0) return SCM(playerid, COLOR_LIGHTGREEN3, "Player not found.");
mysql_real_escape_string(reason, reasone);
getdate(year, month, day);
gettime(hour, minute, second);
GetPlayerName(playerid, sendername, sizeof(sendername));
mysql_real_escape_string(id, escape);
format(qstr,sizeof(qstr),"SELECT * FROM bans WHERE `PlayerName`='%s' AND `Active`='1'", escape);
new Cache: banuri = mysql_query(SQL,qstr);
if(cache_get_row_count() > 0)
{
SendClientMessage(playerid, COLOR_LIGHTRED, "This player is already banned.");
}
else
{
format(qstr, sizeof(qstr), "SELECT `id` FROM users WHERE `name` = '%s'", escape);
new Cache: abs = mysql_query(SQL,qstr);
if(cache_get_row_count() > 0) {
playeridd = cache_get_field_content_int(0, "id");
admlevel = cache_get_field_content_int(0, "Admin");
}
cache_delete(abs);
if( admlevel >= PlayerInfo[ playerid ][ pAdmin ] )
return SendClientMessage( playerid, COLOR_GREY, "You can not ban a higher admin (equal)" );
if(days == 0) {
format(string,sizeof(string),"AdmBan: %s was permanently banned by %s, reason: %s.", id, sendername, reasone);
if(strfind(reason, "silent", true) != -1)
{
ABroadCast(COLOR_LIGHTRED, string, 1);
}
else
{
SCMTA(COLOR_LIGHTRED, string);
}
mysql_format(SQL,str,sizeof(str),"INSERT INTO bans (PlayerName, AdminName, Reason, IP, Days, IPBan, Permanent, Active, Time) VALUES('%s', '%s', '%s', '0', 0, 0, 1, 1, 0)",
escape,PlayerInfo[playerid][pNormalName],reasone);
mysql_tquery(SQL,str,"","");
new var100[256];
mysql_format(SQL, var100, sizeof(var100), "INSERT INTO punishlogs (`playerid`,`giverid`,`actionid`,`actiontime`,`reason`,`playername`,`givername`) VALUES ('%d','%d','1','0','%s','%s','%s')", playeridd,PlayerInfo[playerid][pSQLID],reasone,escape,sendername);
mysql_tquery(SQL,var100,"","");
}
if(days > 0) {
time = gettime() + (days*86400);
format(string,sizeof(string),"AdmBan: %s was banned by %s for %d day, reason: %s.",id,sendername,days,reasone);
if(strfind(reason, "silent", true) != -1)
{
ABroadCast(COLOR_LIGHTRED, string, 1);
}
else
{
SCMTA(COLOR_LIGHTRED, string);
}
mysql_format(SQL,str,sizeof(str),"INSERT INTO bans (PlayerName, AdminName, Reason, IP, Days, IPBan, Permanent, Active, Time) VALUES('%s', '%s', '%s', '0', %d, 0, 0, 1, %d)",
id,PlayerInfo[playerid][pNormalName],reasone,days,time);
mysql_tquery(SQL,str,"","");
new var100[256];
mysql_format(SQL, var100, sizeof(var100), "INSERT INTO punishlogs (`playerid`,`giverid`,`actionid`,`actiontime`,`reason`,`playername`,`givername`) VALUES ('%d','%d','2','%d','%s','%s','%s')", playeridd,PlayerInfo[playerid][pSQLID],days,reasone,escape,sendername);
mysql_tquery(SQL,var100,"","");
}
}
cache_delete(banuri);
}
else return SendClientMessage(playerid, COLOR_LIGHTGREEN3, AdminOnly);
}
return 1;
}