SA-MP Forums Archive
Server Crashing - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Server Crashing (/showthread.php?tid=654841)


Server Crashing - Uvais - 07.06.2018

This command is crashing the server, I don't understand what's wrong:

PHP код:
ACMD:offlineban[4](playerid, params[])
{
    new playername, query[350], reason[200];
    if(sscanf(params, "s[25]s[200]", playername, reason))
        return Usage(playerid, "offlineban [playername] [reason]");
    if(pData[playerid][Level] < pData[playername][Level]) //Level Check
        return COMMAND_NO_AUTH;
    mysql_format(connectionHandle, query, sizeof(query), "SELECT * FROM `account` WHERE `username` = '%e' LIMIT 1;", playername);
    new Cache:test = mysql_query(connectionHandle, query);
    if(cache_get_row_count() > 0)
     {
         mysql_format(connectionHandle, query, 350, "INSERT INTO bans VALUES (NULL, %s, %d, '%e')", playername, pData[playerid][RealID], reason);
        mysql_query(connectionHandle, query, false);
        MessageAll(-1, "[IG] {A9C4E4}%p has been offline-banned from the server by %s. {00FF00}[REASON: %s]", playername, playerid, reason);
        MessageAdmin(COLOR_BLUE, "%o has offline-banned %o. {00FF00}[REASON: %s]", playerid, playername, reason);
        SendAdminText(playerid, "%o has offline-banned %o");
        WriteLog("admin.html", "%p has offline-banned %p", playerid, playername);
    }
    else
    {
        Message(playerid, -1, "{FF0000}[ADMIN]: {FFFFFF}The account you are trying to ban doesn't exist in the database.");
        cache_delete(test);
    }
    return 1;
} 


Re: Server Crashing - jasperschellekens - 07.06.2018

Crashdetect?

Re: Server Crashing - Uvais - 07.06.2018

No log. Something is wrong with this command.. Can someone check what's wrong? I've tried my best.

Re: Server Crashing - Florin48 - 07.06.2018

what command processor you use?

Re: Server Crashing - Uvais - 07.06.2018

ACMD
for Admin commands

Re: Server Crashing - kovac - 07.06.2018

PHP код:
stock GetName(playerid)
{
    new name[MAX_PLAYER_NAME];
    GetPlayerName(playerid, name, sizeof(name));
    return name;
}
ACMD:offlineban(playerid, params[])
{
    new playername[MAX_PLAYER_NAME], reason[50];
    if(sscanf(params, "s[24]s[50]", playername, reason)) return SendClientMessage(playerid, -1, "USAGE: /offlineban [playername] [reason]");
    new query[350];
      mysql_format(connectionHandle, query, sizeof(query), "SELECT * FROM `account` WHERE `username` = '%e' LIMIT 1;", playername);
     new Cache:result = mysql_query(connectionHandle, query);
     if(!cache_num_rows()) return SendClientMessage(playerid, -1, "ERROR: No users found. Make sure that you have entered full and correct username.");
    mysql_format(connectionHandle, query, sizeof(query), "INSERT INTO `bans` VALUES (NULL, '%s', '%d', '%e')", playername, pData[playerid][RealID], reason);
    mysql_query(connectionHandle, query);
    
    SendClientMessageToAll(-1, "[IG] {A9C4E4}%s has been offline-banned from the server by %s. {00FF00}[REASON: %s]", playername, GetName(playerid), reason);
    MessageAdmin(COLOR_BLUE, "%s has offline-banned %s. {00FF00}[REASON: %s]", GetName(playerid), playername, reason);
    SendAdminText(playerid, "%s has offline-banned %s", GetName(playerid), playername);
    WriteLog("admin.html", "%s has offline-banned %s", GetName(playerid), playername);
    cache_delete(result);
    return 1;
} 


Re: Server Crashing - Uvais - 07.06.2018

Quote:
Originally Posted by kovac
Посмотреть сообщение
PHP код:
stock GetName(playerid)
{
    new name[MAX_PLAYER_NAME];
    GetPlayerName(playerid, name, sizeof(name));
    return name;
}
ACMD:offlineban(playerid, params[])
{
    new playername[MAX_PLAYER_NAME], reason[50];
    if(sscanf(params, "s[24]s[50]", playername, reason)) return SendClientMessage(playerid, -1, "USAGE: /offlineban [playername] [reason]");
    new query[350];
      mysql_format(connectionHandle, query, sizeof(query), "SELECT * FROM `account` WHERE `username` = '%e' LIMIT 1;", playername);
     new Cache:result = mysql_query(connectionHandle, query);
     if(!cache_num_rows()) return SendClientMessage(playerid, -1, "ERROR: No users found. Make sure that you have entered full and correct username.");
    mysql_format(connectionHandle, query, sizeof(query), "INSERT INTO `bans` VALUES (NULL, '%s', '%d', '%e')", playername, pData[playerid][RealID], reason);
    mysql_query(connectionHandle, query);
    
    SendClientMessageToAll(-1, "[IG] {A9C4E4}%s has been offline-banned from the server by %s. {00FF00}[REASON: %s]", playername, GetName(playerid), reason);
    MessageAdmin(COLOR_BLUE, "%s has offline-banned %s. {00FF00}[REASON: %s]", GetName(playerid), playername, reason);
    SendAdminText(playerid, "%s has offline-banned %s", GetName(playerid), playername);
    WriteLog("admin.html", "%s has offline-banned %s", GetName(playerid), playername);
    cache_delete(result);
    return 1;
} 
Invalid Command.

Re: Server Crashing - kovac - 07.06.2018

I have no idea what ACMD is. Try ZCMD and change "ACMD" to "CMD"

Re: Server Crashing - Dayrion - 07.06.2018

What MySQL Logs says? Plus, you should use threaded queries instead of that.

Re: Server Crashing - Uvais - 07.06.2018

Quote:
Originally Posted by kovac
Посмотреть сообщение
I have no idea what ACMD is. Try ZCMD and change "ACMD" to "CMD"
Still crashes the server. ACMD is another command processor similar to ZCMD.