Command is crashing the server

Command is crashing the server - 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: Command is crashing the server (/showthread.php?tid=481001)

Command is crashing the server - Brandon_More - 13.12.2013

I have made this command:

pawn Код:

COMMAND:leaders(playerid, params[])
{
    if(PlayerInfo[playerid][power] < 9)
        return SendClientError(playerid, CANT_USE_CMD);

    new savingstring[20], tier, team[24], rank[42], username[24], query[200], laston[35];
    format(query, sizeof(query),"SELECT user, PTeamName, lastonline, rankname, ranklvl FROM PlayerInfo WHERE ranklvl < 1");
    mysql_query(query);
    mysql_store_result();
    SendClientMSG(playerid, COLOR_HELPEROOC, "{4985d7}[Server Staff] {a7c2e6}- All Faction Leaders:");
    while(mysql_fetch_row_format(query,"|"))
    {
        mysql_fetch_field_row(savingstring, "user");
        myStrcpy(username, savingstring);
        mysql_fetch_field_row(savingstring, "ranklvl");
        tier = strval(savingstring);
        mysql_fetch_field_row(savingstring, "lastonline");
        myStrcpy(laston, savingstring);
        mysql_fetch_field_row(savingstring, "rankname");
        myStrcpy(rank, savingstring);
        mysql_fetch_field_row(savingstring, "PTeamName");
        myStrcpy(team, savingstring);
        new Online = GetPlayerId(username);
        if(!IsPlayerConnected(Online))
        {
            format(iStr, sizeof(iStr),"%s | %s [Tier:%d] [Rank:%s] [Last Online:%s",team, username, tier, rank, laston);
            SendClientMessage(playerid,COLOR_GREY,iStr);
        }
    }
    mysql_free_result();
    return 1;
}

And every time I use it the server seems to crash, can someone tell me what I am doing wrong?

Re: Command is crashing the server - BizzyD - 13.12.2013

Any errors in the server.log/mysql.log ?

And is it called pTeamName in the database to?

Код:

mysql_fetch_field_row(savingstring, "PTeamName");

Re: Command is crashing the server - Brandon_More - 13.12.2013

No I over checked the variables. All that is fine.

MySQL_Debug:

Код:

[17:48:51] CMySQLHandler::Query(SELECT user, PTeamName, lastonline, rankname, ranklvl FROM PlayerInfo WHERE ranklvl < 1) - Successfully executed.
[17:48:51] >> mysql_store_result( Connection handle: 1 )
[17:48:51] CMySQLHandler::StoreResult() - Result was stored.
[17:48:51] >> mysql_fetch_row_format( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchRow() - Return: Levi_Corleone|Corleone|[13/12/2013 - 17:42:29]|Enforcer|0
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("user") - Levi_Corleone
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("ranklvl") - 0
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("lastonline") - [13/12/2013 - 17:42:29]
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("rankname") - Enforcer
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("PTeamName") - Corleone
[17:48:51] >> mysql_fetch_row_format( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchRow() - Return: Alexander_Collins|FBI|[12/12/2013 - 16:53:34]|[F.B.I] Chief|0
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("user") - Alexander_Collins
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("ranklvl") - 0
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("lastonline") - [12/12/2013 - 16:53:34]
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("rankname") - [F.B.I] Chief
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("PTeamName") - FBI
[17:48:51] >> mysql_fetch_row_format( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchRow() - Return: Giuseppe_Barzini|Barzini|[13/12/2013 - 17:42:29]|Right Hand|0
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("user") - Giuseppe_Barzini
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("ranklvl") - 0
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("lastonline") - [13/12/2013 - 17:42:29]
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("rankname") - Right Hand
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("PTeamName") - Barzini
[17:48:51] >> mysql_fetch_row_format( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchRow() - Return: Salvatore_Barzini|Barzini|[13/12/2013 - 14:11:39]|Padrino|0
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("user") - Salvatore_Barzini
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("ranklvl") - 0
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("lastonline") - [13/12/2013 - 14:11:39]
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("rankname") - Padrino
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("PTeamName") - Barzini
[17:48:51] >> mysql_fetch_row_format( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchRow() - Return: William_Smith|Paterno|[12/12/2013 - 15:7:16]|UnderGod|0
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("user") - William_Smith
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("ranklvl") - 0
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("lastonline") - [12/12/2013 - 15:7:16]
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("rankname") - UnderGod
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("PTeamName") - Paterno
[17:48:51] >> mysql_fetch_row_format( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchRow() - Return: Emir_Toroslu|Triads|[13/12/2013 - 14:52:57]|Mafya Babasi|0
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("user") - Emir_Toroslu
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("ranklvl") - 0
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("lastonline") - [13/12/2013 - 14:52:57]
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("rankname") - Mafya Babasi
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("PTeamName") - Triads
[17:48:51] >> mysql_fetch_row_format( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchRow() - Return: Daniel_Cabrea|Government|[12/12/2013 - 16:7:14]|Mayor|0
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("user") - Daniel_Cabrea
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("ranklvl") - 0
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("lastonline") - [12/12/2013 - 16:7:14]
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("rankname") - Mayor
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("PTeamName") - Government
[17:48:51] >> mysql_fetch_row_format( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchRow() - Return: Charles_Razzo|FBI|[13/12/2013 - 17:15:32]|Special Agent 02|0
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("user") - Charles_Razzo
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("ranklvl") - 0
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("lastonline") - [13/12/2013 - 17:15:32]
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("rankname") - Special Agent 02
[17:48:51] >> mysql_fetch_field_row( Connection handle: 1 )
[17:48:51] CMySQLHandler::FetchField("PTeamName") - FBI
[17:48:51] >> mysql_fetch_row_format( Connection handle: 1 )
[17:48:51] >> mysql_free_result( Connection handle: 1 )
[17:48:51] CMySQLHandler::FreeResult() - Result was successfully free'd.

Re: Command is crashing the server - Brandon_More - 14.12.2013

Bump, anyone?