[Uvais]

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;
} 


[jasperschellekens]

Crashdetect?

[Uvais]

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

[Florin48]

what command processor you use?

[Uvais]

ACMD
for Admin commands

[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;
} 


[Uvais]

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.

[kovac]

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

[Dayrion]

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

[Uvais]

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.