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

Threaded Mode
Unknown Command
DarkLored
High-roller
*****
Posts: 1,045
Threads: 150
Joined: Oct 2013
Reputation: 0
#1

18.07.2015, 04:30
Hello, I have made a command which will show all factions, their names, and the leaders name, whenever I try to use it in the server it says "Unknown Command".

pawn Код:
CMD:families(playerid, params[])
{
    new Query[500],family1[500], family2[500], family3[500], family4[500], family5[500], family6[500], family7[500], family8[500], family9[500], family10[500];
    new family11[500], family12[500], family13[500], family14[500], family15[500], family16[500], family17[500], family18[500], family19[500], family20[500];
    new DBResult:Result;
    Result = db_query(FDatabase, Query);
    format(family1, sizeof(family1), "Family One: %s. Leader: %s", db_get_field_assoc(Result, "fname", fInfo[1][FNAME], 50), db_get_field_assoc(Result, "fid", fInfo[1][FACTIONLEADER], 21));
    SendClientMessage(playerid, -1, family1);
    format(family2, sizeof(family2), "Family Two: %s. Leader: %s", db_get_field_assoc(Result, "fname", fInfo[2][FNAME], 50), db_get_field_assoc(Result, "fid", fInfo[2][FACTIONLEADER], 21));
    SendClientMessage(playerid, -1, family2);
    format(family3, sizeof(family3), "Family Three: %s. Leader: %s", db_get_field_assoc(Result, "fname", fInfo[3][FNAME], 50), db_get_field_assoc(Result, "fid", fInfo[3][FACTIONLEADER], 21));
    SendClientMessage(playerid, -1, family3);
    format(family4, sizeof(family4), "Family Four: %s. Leader: %s", db_get_field_assoc(Result, "fname", fInfo[4][FNAME], 50), db_get_field_assoc(Result, "fid", fInfo[4][FACTIONLEADER], 21));
    SendClientMessage(playerid, -1, family4);
    format(family5, sizeof(family5), "Family Five: %s. Leader: %s", db_get_field_assoc(Result, "fname", fInfo[5][FNAME], 50), db_get_field_assoc(Result, "fid", fInfo[5][FACTIONLEADER], 21));
    SendClientMessage(playerid, -1, family5);
    format(family6, sizeof(family6), "Family Six: %s. Leader: %s", db_get_field_assoc(Result, "fname", fInfo[6][FNAME], 50), db_get_field_assoc(Result, "fid", fInfo[6][FACTIONLEADER], 21));
    SendClientMessage(playerid, -1, family6);
    format(family7, sizeof(family7), "Family Seven: %s. Leader: %s", db_get_field_assoc(Result, "fname", fInfo[7][FNAME], 50), db_get_field_assoc(Result, "fid", fInfo[7][FACTIONLEADER], 21));
    SendClientMessage(playerid, -1, family7);
    format(family8, sizeof(family8), "Family Eight: %s. Leader: %s", db_get_field_assoc(Result, "fname", fInfo[8][FNAME], 50), db_get_field_assoc(Result, "fid", fInfo[8][FACTIONLEADER], 21));
    SendClientMessage(playerid, -1, family8);
    format(family9, sizeof(family9), "Family Nine: %s. Leader: %s", db_get_field_assoc(Result, "fname", fInfo[9][FNAME], 50), db_get_field_assoc(Result, "fid", fInfo[9][FACTIONLEADER], 21));
    SendClientMessage(playerid, -1, family9);
    format(family10, sizeof(family10), "Family Ten: %s. Leader: %s", db_get_field_assoc(Result, "fname", fInfo[10][FNAME], 50), db_get_field_assoc(Result, "fid", fInfo[10][FACTIONLEADER], 21));
    SendClientMessage(playerid, -1, family10);
    format(family11, sizeof(family11), "Family Eleven: %s. Leader: %s", db_get_field_assoc(Result, "fname", fInfo[11][FNAME], 50), db_get_field_assoc(Result, "fid", fInfo[11][FACTIONLEADER], 21));
    SendClientMessage(playerid, -1, family11);
    format(family12, sizeof(family12), "Family Twelve: %s. Leader: %s", db_get_field_assoc(Result, "fname", fInfo[12][FNAME], 50), db_get_field_assoc(Result, "fid", fInfo[12][FACTIONLEADER], 21));
    SendClientMessage(playerid, -1, family12);
    format(family13, sizeof(family13), "Family Thirteen: %s. Leader: %s", db_get_field_assoc(Result, "fname", fInfo[13][FNAME], 50), db_get_field_assoc(Result, "fid", fInfo[13][FACTIONLEADER], 21));
    SendClientMessage(playerid, -1, family13);
    format(family14, sizeof(family14), "Family Fourteen: %s. Leader: %s", db_get_field_assoc(Result, "fname", fInfo[14][FNAME], 50), db_get_field_assoc(Result, "fid", fInfo[14][FACTIONLEADER], 21));
    SendClientMessage(playerid, -1, family14);
    format(family15, sizeof(family15), "Family Fifthteen: %s. Leader: %s", db_get_field_assoc(Result, "fname", fInfo[15][FNAME], 50), db_get_field_assoc(Result, "fid", fInfo[15][FACTIONLEADER], 21));
    SendClientMessage(playerid, -1, family15);
    format(family16, sizeof(family16), "Family Sixteen: %s. Leader: %s", db_get_field_assoc(Result, "fname", fInfo[16][FNAME], 50), db_get_field_assoc(Result, "fid", fInfo[16][FACTIONLEADER], 21));
    SendClientMessage(playerid, -1, family16);
    format(family17, sizeof(family17), "Family Seventeen: %s. Leader: %s", db_get_field_assoc(Result, "fname", fInfo[17][FNAME], 50), db_get_field_assoc(Result, "fid", fInfo[17][FACTIONLEADER], 21));
    SendClientMessage(playerid, -1, family17);
    format(family18, sizeof(family18), "Family Eighteen: %s. Leader: %s", db_get_field_assoc(Result, "fname", fInfo[18][FNAME], 50), db_get_field_assoc(Result, "fid", fInfo[18][FACTIONLEADER], 21));
    SendClientMessage(playerid, -1, family18);
    format(family19, sizeof(family19), "Family Nineteen: %s. Leader: %s", db_get_field_assoc(Result, "fname", fInfo[19][FNAME], 50), db_get_field_assoc(Result, "fid", fInfo[19][FACTIONLEADER], 21));
    SendClientMessage(playerid, -1, family19);
    format(family20, sizeof(family20), "Family Twenty: %s. Leader: %s", db_get_field_assoc(Result, "fname", fInfo[20][FNAME], 50), db_get_field_assoc(Result, "fid", fInfo[20][FACTIONLEADER], 21));
    SendClientMessage(playerid, -1, family20);
    db_free_result(Result);
    return 1;
}
Find
Reply
SickAttack
High-roller
*****
Posts: 4,759
Threads: 33
Joined: Dec 2013
Reputation: 0
#2

18.07.2015, 04:44
You didn't create the query.

Also, use https://sampwiki.blast.hk/wiki/Db_next_row, instead of obtaining the same result over and over.

What to do, otherwise:
  • Put these lines "db_get_field_assoc(...)" solely and use the variable instead.
  • Decrease the amount of cells each variable has.
  • If the problem persists, put "#pragma dynamic (memory allocation here)" in your script - 1000000 or so. This goes on top of your script.
Find
Reply
DarkLored
High-roller
*****
Posts: 1,045
Threads: 150
Joined: Oct 2013
Reputation: 0
#3

18.07.2015, 22:03
With the help of Konstantinos I have worked on most of my code, but when I perform it, it doesn't do anything at all.

here is my updated code
pawn Код:
CMD:families(playerid, params[])
{
    new Query[500], DBResult:Result;
    new rows;
    format(Query, sizeof(Query), "SELECT* FROM factioninfo WHERE fid = '%d'", fInfo[rows][FID]);
    Result = db_query(FDatabase, Query);

    if((rows = db_num_rows(Result)))
    {
        for(new i; i != rows; ++i)
        {
            if(i >= sizeof fInfo) break;

            db_get_field_assoc(Result, "fname", fInfo[1][FNAME], 50);
            db_get_field_assoc(Result, "fleader", fInfo[1][FACTIONLEADER], 24);

            format(Query, sizeof(Query), "Family One: %s. Leader: %s", fInfo[1][FNAME], fInfo[1][FACTIONLEADER]);
            SendClientMessage(playerid, -1, Query);

            db_next_row(Result);

            db_get_field_assoc(Result, "fname", fInfo[2][FNAME], 50);
            db_get_field_assoc(Result, "fleader", fInfo[2][FACTIONLEADER], 24);

            format(Query, sizeof(Query), "Family Two: %s. Leader: %s", fInfo[2][FNAME], fInfo[2][FACTIONLEADER]);
            SendClientMessage(playerid, -1, Query);

            db_next_row(Result);

            db_get_field_assoc(Result, "fname", fInfo[3][FNAME], 50);
            db_get_field_assoc(Result, "fleader", fInfo[3][FACTIONLEADER], 24);

            format(Query, sizeof(Query), "Family Three: %s. Leader: %s", fInfo[3][FNAME], fInfo[3][FACTIONLEADER]);
            SendClientMessage(playerid, -1, Query);

            db_next_row(Result);

            db_get_field_assoc(Result, "fname", fInfo[4][FNAME], 50);
            db_get_field_assoc(Result, "fleader", fInfo[4][FACTIONLEADER], 24);

            format(Query, sizeof(Query), "Family Four: %s. Leader: %s", fInfo[4][FNAME], fInfo[4][FACTIONLEADER]);
            SendClientMessage(playerid, -1, Query);

            db_next_row(Result);

            db_get_field_assoc(Result, "fname", fInfo[5][FNAME], 50);
            db_get_field_assoc(Result, "fleader", fInfo[5][FACTIONLEADER], 24);

            format(Query, sizeof(Query), "Family Five: %s. Leader: %s", fInfo[5][FNAME], fInfo[5][FACTIONLEADER]);
            SendClientMessage(playerid, -1, Query);

            db_next_row(Result);

            db_get_field_assoc(Result, "fname", fInfo[6][FNAME], 50);
            db_get_field_assoc(Result, "fleader", fInfo[6][FACTIONLEADER], 24);

            format(Query, sizeof(Query), "Family Six: %s. Leader: %s", fInfo[6][FNAME], fInfo[6][FACTIONLEADER]);
            SendClientMessage(playerid, -1, Query);

            db_next_row(Result);

            db_get_field_assoc(Result, "fname", fInfo[7][FNAME], 50);
            db_get_field_assoc(Result, "fleader", fInfo[7][FACTIONLEADER], 24);

            format(Query, sizeof(Query), "Family Seven: %s. Leader: %s", fInfo[7][FNAME], fInfo[7][FACTIONLEADER]);
            SendClientMessage(playerid, -1, Query);

            db_next_row(Result);

            db_get_field_assoc(Result, "fname", fInfo[8][FNAME], 50);
            db_get_field_assoc(Result, "fleader", fInfo[8][FACTIONLEADER], 24);

            format(Query, sizeof(Query), "Family Eight: %s. Leader: %s", fInfo[8][FNAME], fInfo[8][FACTIONLEADER]);
            SendClientMessage(playerid, -1, Query);

            db_next_row(Result);

            db_get_field_assoc(Result, "fname", fInfo[9][FNAME], 50);
            db_get_field_assoc(Result, "fleader", fInfo[9][FACTIONLEADER], 24);

            format(Query, sizeof(Query), "Family Nine: %s. Leader: %s", fInfo[9][FNAME], fInfo[9][FACTIONLEADER]);
            SendClientMessage(playerid, -1, Query);

            db_next_row(Result);

            db_get_field_assoc(Result, "fname", fInfo[10][FNAME], 50);
            db_get_field_assoc(Result, "fleader", fInfo[10][FACTIONLEADER], 24);

            format(Query, sizeof(Query), "Family Ten: %s. Leader: %s", fInfo[10][FNAME], fInfo[10][FACTIONLEADER]);
            SendClientMessage(playerid, -1, Query);

            db_next_row(Result);

            db_get_field_assoc(Result, "fname", fInfo[11][FNAME], 50);
            db_get_field_assoc(Result, "fleader", fInfo[11][FACTIONLEADER], 24);

            format(Query, sizeof(Query), "Family Eleven: %s. Leader: %s", fInfo[11][FNAME], fInfo[11][FACTIONLEADER]);
            SendClientMessage(playerid, -1, Query);

            db_next_row(Result);

            db_get_field_assoc(Result, "fname", fInfo[12][FNAME], 50);
            db_get_field_assoc(Result, "fleader", fInfo[12][FACTIONLEADER], 24);

            format(Query, sizeof(Query), "Family Twelve: %s. Leader: %s", fInfo[12][FNAME], fInfo[12][FACTIONLEADER]);
            SendClientMessage(playerid, -1, Query);

            db_next_row(Result);

            db_get_field_assoc(Result, "fname", fInfo[13][FNAME], 50);
            db_get_field_assoc(Result, "fleader", fInfo[13][FACTIONLEADER], 24);

            format(Query, sizeof(Query), "Family Thirteen: %s. Leader: %s", fInfo[13][FNAME], fInfo[13][FACTIONLEADER]);
            SendClientMessage(playerid, -1, Query);

            db_next_row(Result);

            db_get_field_assoc(Result, "fname", fInfo[14][FNAME], 50);
            db_get_field_assoc(Result, "fleader", fInfo[14][FACTIONLEADER], 24);

            format(Query, sizeof(Query), "Family Fourteen: %s. Leader: %s", fInfo[14][FNAME], fInfo[14][FACTIONLEADER]);
            SendClientMessage(playerid, -1, Query);

            db_next_row(Result);

            db_get_field_assoc(Result, "fname", fInfo[15][FNAME], 50);
            db_get_field_assoc(Result, "fleader", fInfo[15][FACTIONLEADER], 24);

            format(Query, sizeof(Query), "Family Fifthteen: %s. Leader: %s", fInfo[15][FNAME], fInfo[15][FACTIONLEADER]);
            SendClientMessage(playerid, -1, Query);

            db_next_row(Result);

            db_get_field_assoc(Result, "fname", fInfo[16][FNAME], 50);
            db_get_field_assoc(Result, "fleader", fInfo[16][FACTIONLEADER], 24);

            format(Query, sizeof(Query), "Family Sixteen: %s. Leader: %s", fInfo[16][FNAME], fInfo[16][FACTIONLEADER]);
            SendClientMessage(playerid, -1, Query);

            db_next_row(Result);

            db_get_field_assoc(Result, "fname", fInfo[17][FNAME], 50);
            db_get_field_assoc(Result, "fleader", fInfo[17][FACTIONLEADER], 24);

            format(Query, sizeof(Query), "Family Seventeen: %s. Leader: %s", fInfo[17][FNAME], fInfo[17][FACTIONLEADER]);
            SendClientMessage(playerid, -1, Query);

            db_next_row(Result);

            db_get_field_assoc(Result, "fname", fInfo[18][FNAME], 50);
            db_get_field_assoc(Result, "fleader", fInfo[18][FACTIONLEADER], 24);

            format(Query, sizeof(Query), "Family Eighteen: %s. Leader: %s", fInfo[18][FNAME], fInfo[18][FACTIONLEADER]);
            SendClientMessage(playerid, -1, Query);

            db_next_row(Result);

            db_get_field_assoc(Result, "fname", fInfo[19][FNAME], 50);
            db_get_field_assoc(Result, "fleader", fInfo[19][FACTIONLEADER], 24);

            format(Query, sizeof(Query), "Family Nineteen: %s. Leader: %s", fInfo[19][FNAME], fInfo[19][FACTIONLEADER]);
            SendClientMessage(playerid, -1, Query);

            db_next_row(Result);

            db_get_field_assoc(Result, "fname", fInfo[20][FNAME], 50);
            db_get_field_assoc(Result, "fleader", fInfo[20][FACTIONLEADER], 24);

            format(Query, sizeof(Query), "Family Twenty: %s. Leader: %s", fInfo[20][FNAME], fInfo[20][FACTIONLEADER]);
            SendClientMessage(playerid, -1, Query);
        }
    }
    db_free_result(Result);
    return 1;
}
Find
Reply
Krokett
Big Clucker
***
Posts: 51
Threads: 0
Joined: Jul 2015
Reputation: 0
#4

18.07.2015, 22:07
Код:
format(Query, sizeof(Query), "SELECT * FROM factioninfo WHERE fid = '%d'", fInfo[rows][FID]);
You forgot a space between SELECT and *.
Find
Reply
DarkLored
High-roller
*****
Posts: 1,045
Threads: 150
Joined: Oct 2013
Reputation: 0
#5

18.07.2015, 22:21
Quote:
Originally Posted by Krokett
Посмотреть сообщение
Код:
format(Query, sizeof(Query), "SELECT * FROM factioninfo WHERE fid = '%d'", fInfo[rows][FID]);
You forgot a space between SELECT and *.
That is not the issue there is no difference between not putting the space and putting one, I've tried that already.
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