1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
Command is crashing the server
Brandon_More
Huge Clucker
****
Posts: 251
Threads: 73
Joined: Jul 2012
Reputation: 0
#1

13.12.2013, 20:47
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?
Find
Reply
BizzyD
Gangsta
*****
Posts: 879
Threads: 90
Joined: Jan 2011
Reputation: 0
#2

13.12.2013, 20:50
Any errors in the server.log/mysql.log ?

And is it called pTeamName in the database to?

Код:
mysql_fetch_field_row(savingstring, "PTeamName");
Find
Reply
Brandon_More
Huge Clucker
****
Posts: 251
Threads: 73
Joined: Jul 2012
Reputation: 0
#3

13.12.2013, 20:52
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.
Find
Reply
Brandon_More
Huge Clucker
****
Posts: 251
Threads: 73
Joined: Jul 2012
Reputation: 0
#4

14.12.2013, 13:09
Bump, anyone?
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help