Help me Mysql - Printable Version

Help me Mysql - 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: Help me Mysql (/showthread.php?tid=667851)

Help me Mysql - Libbyphay - 10.07.2019

PHP Code:



forward Characters_Menu(playerid);

public Characters_Menu(playerid)

{

    new str[64], dialog[512], C_ID, C_LVL, C_Name[32];


    format(str, sizeof(str), "C_ID\tCharacter Name\tLevel\n");

    strcat(dialog, str, sizeof(dialog));


    for( new id = 0; id < cache_num_rows(); id++)

    {

        cache_get_value(id, "ID", C_ID);

        cache_get_value(id, "Name", C_Name, 32);

        cache_get_value(id, "Level", C_LVL);


        format(str, sizeof(str), "[%d] \t%s\t%d\n", C_ID, C_Name, C_LVL);

        strcat(dialog, str, sizeof(dialog));

    }


    if(cache_num_rows() < 3) 

    {

        format(str, sizeof(str), " \tCreate Character\t\n");

        strcat(dialog, str, sizeof(dialog));

    }


    format(str, sizeof(str), "%s's Characters", Account[playerid][Name]);

    Dialog_Show(playerid, Character_Select, DIALOG_STYLE_TABLIST_HEADERS, str, dialog, "Select","Leave");


    return 1;

}

PHP Code:



C:\Users\Administrator\Desktop\SAMP\gamemodes\SCRP-R39.pwn(1094) : error 035: argument type mismatch (argument 3)

C:\Users\Administrator\Desktop\SAMP\gamemodes\SCRP-R39.pwn(1096) : error 035: argument type mismatch (argument 3)

HTML Code:

cache_get_value(id, "ID", C_ID);
cache_get_value(id, "Level", C_LVL);

I updated Mysql R39 to R41-4, but I can't fix it

Re: Help me Mysql - Libbyphay - 10.07.2019

Someone help me

Re: Help me Mysql - Libbyphay - 10.07.2019

The Gamemode Small Country RolePlay can't use mysql R41-4?

Re: Help me Mysql - Symon - 10.07.2019

cache_get_value_int

Re: Help me Mysql - Libbyphay - 10.07.2019

Quote:

C:\Users\Administrator\Desktop\SAMP\gamemodes\SCRP-R39.pwn(1094) : error 017: undefined symbol "cache_get_value_int_ovrld"
C:\Users\Administrator\Desktop\SAMP\gamemodes\SCRP-R39.pwn(1096) : error 017: undefined symbol "cache_get_value_int_ovrld"

Quote:

C_ID = cache_get_value_int(id, "ID");
cache_get_value(id, "Name", C_Name, 24);
C_LVL = cache_get_value_int(id, "Level");

No working.

Re: Help me Mysql - Libbyphay - 10.07.2019

Quote:

Originally Posted by KeyOfKey

cache_get_value_int

PHP Code:



forward Characters_Fetch(playerid);

public Characters_Fetch(playerid)

{

    new query[128];

    mysql_format(SQL_CONNECTION, query, sizeof(query), "SELECT ID, Name, Level FROM Characters WHERE A_ID = '%d' LIMIT 3", Account[playerid][SQLID]);

    mysql_tquery(SQL_CONNECTION, query, "Characters_Menu", "i", playerid);

    return 1;

}


forward Characters_Menu(playerid);

public Characters_Menu(playerid)

{

    new str[64], dialog[512], C_ID, C_Name[24], C_LVL;


    format(str, sizeof(str), "C_ID\tCharacter Name\tLevel\n");

    strcat(dialog, str, sizeof(dialog));


    for( new id = 0; id < cache_num_rows(); id++)

    {

        C_ID = cache_get_value_int(id, "ID", Character[playerid][ID]);

        cache_get_value(id, "Name", C_Name, 24);

        C_LVL = cache_get_value_int(id, "Level", Character[playerid][Level]);


        format(str, sizeof(str), "[%d] \t%s\t%d\n", C_ID, C_Name, C_LVL);

        strcat(dialog, str, sizeof(dialog));

    }


    if(cache_num_rows() < 3) 

    {

        format(str, sizeof(str), " \tCreate Character\t\n");

        strcat(dialog, str, sizeof(dialog));

    }


    format(str, sizeof(str), "%s's Characters", Account[playerid][Name]);

    Dialog_Show(playerid, Character_Select, DIALOG_STYLE_TABLIST_HEADERS, str, dialog, "Select","Leave");


    return 1;

}

I think Characters_Fetch(playerid) no working, how to fix it?

Re: Help me Mysql - Libbyphay - 10.07.2019

I Fixed, tks bro so much.