SA-MP Forums Archive
Why this won't work? - 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: Why this won't work? (/showthread.php?tid=620554)


Why this won't work? - StrikerZ - 31.10.2016

Hi i'm using SQLite. Why this command not working? The purpose of it was to select all the strings in the 'Name' column and show on player's screen.
PHP код:
CMD:factions(playerid, params[])
{
    new Query[256];
    new DBResult:Result;
    format(Query, sizeof(Query), "SELECT 'Name' FROM `Faction`");
    Result = db_query(Database, Query);
     if(db_num_rows(Result))
      {
           new Field[30];
           db_get_field_assoc(Result, #Name, Field, 30);
           printf("%s",Field);
    }
    return 1;
} 
EDIT:I used printf just in case to check if it appears on console or not

Re: Why this won't work? - Konstantinos - 31.10.2016

This will literally return "Name" and store it in Field variable and not the data that are stored in that column. Use either grave accent `Name` or nothing Name.

Format is pointless in that case, just execute the query directly in db_query.

You will also need db_next_row otherwise it will only retrieve from the first row.

Re: Why this won't work? - StrikerZ - 31.10.2016

Like this?
PHP код:
CMD:factions(playerid, params[])
{
    new DBResult:Result;
    Result = db_query(Database, "SELECT 'Name' FROM `Faction'");
     if(db_num_rows(Result))
      {
          do
          {
           new Field[30];
           db_get_field_assoc(Result, 'Name', Field, 30);
           new string[120];
           format(string,sizeof(string),"%s",Field);
           SCM(playerid,COLOR_YELLOW,string);
        }
        while(db_next_row(db_result));
    }
    db_free_result(Result);
    return 1;
} 


Re: Why this won't work? - Logic_ - 31.10.2016

Fixed some errors.
PHP код:
CMD:factions(playerid)
{
    new DBResult:Result;
    Result = db_query(Database, "SELECT 'Name' FROM `Faction`");
    if(db_num_rows(Result))
    {
        new Field[30], string[100];
        db_get_field_assoc(Result, 'Name', Field, 30);
        format(string,sizeof(string),"%s",Field);
        SCM(playerid,COLOR_YELLOW,string);
        while(db_next_row(db_result));
    }
    db_free_result(Result);
    return 1;
} 


Re: Why this won't work? - StrikerZ - 31.10.2016

Thanks! Will try it and reply if it worked.EDIT: errors and i don't know these ones because i just started learning sqlite today
PHP код:
D:\Softwares\Cops And Robbers\gamemodes\Sandhu.pwn(9159) : error 027: invalid character constant
D:\Softwares\Cops And Robbers\gamemodes\Sandhu.pwn(9159) : error 017: undefined symbol "ame"
D:\Softwares\Cops And Robbers\gamemodes\Sandhu.pwn(9159) : warning 215: expression has no effect
D:\Softwares\Cops And Robbers\gamemodes\Sandhu.pwn(9159) : error 001: expected token: ";", but found "-identifier-"
D:\Softwares\Cops And Robbers\gamemodes\Sandhu.pwn(9159) : fatal error 107: too many error messages on one line
Compilation aborted.Pawn compiler 3.2.3664              Copyright (c) 1997-2006, ITB CompuPhase
4 Errors. 
PHP код:
db_get_field_assoc(Result, 'Name', Field, 30); 


Re: Why this won't work? - Logic_ - 31.10.2016

"'Name'"

Re: Why this won't work? - Konstantinos - 31.10.2016

No, it still has issues:

- You still left it as 'Name' and explained what will return if trying to retrieve the text.
- db_result is unknown.
- do .. while loop, you forgot "do".
- The second parameter in db_get_field_assoc is a string so you'd use "Name" and not 'Name'.
- Formatting another string is again pointless.

Код:
CMD:factions(playerid, params[])
{
    new DBResult: Result = db_query(Database, "SELECT `Name` FROM `Faction");

    if (db_num_rows(Result))
    {
        new Field[30];

        do 
        {
            db_get_field_assoc(Result, "Name", Field, 30);
            // or
            // db_get_field(Result, 0, Field, 30);

            SCM(playerid, COLOR_YELLOW, Field);
        }
        while (db_next_row(Result));
    }

    db_free_result(Result);
    return 1;
}


Re: Why this won't work? - StrikerZ - 31.10.2016

Thx! A rep to you both! So this sqlite thingy works on frag host too [Frag is linux]?

Re: Why this won't work? - SyS - 31.10.2016

Quote:
Originally Posted by Sunehildeep
Посмотреть сообщение
Thx! A rep to you both! So this sqlite thingy works on frag host too [Frag is linux]?
Yes it will.

Re: Why this won't work? - StrikerZ - 31.10.2016

And yeah one more thing can i show that Field result in a dialog style list instead of SCM?