SA-MP Forums Archive
Problems with mysql.. Maybe someone could help me out.. - 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: Problems with mysql.. Maybe someone could help me out.. (/showthread.php?tid=470418)



Problems with mysql.. Maybe someone could help me out.. - Scrillex - 17.10.2013

Hello samp forum members.. Again I need help with my code..I use r7 plugin and it requires r8 mysql.. (as r15 is out dated I wanted to update it);

Maybe some one could help me.. out..
ENUM:

pawn Код:
enum e_pInfo
{
    pSQLid,
    pPass[129],
    pSalt[30],
    Float:pHealth,
    Float:pPos[4],
    pInterior,
    pVirtualWorld,
    pSkin
}
Error Code:

pawn Код:
warning 202: number of arguments does not match definition
(474) : error 017: undefined symbol "cache_get_row_int"
(475) : warning 202: number of arguments does not match definition
(476) : warning 202: number of arguments does not match definition
(494) : error 017: undefined symbol "cache_get_row_float"
Error lines:

pawn Код:
mysql_real_escape_string(string, esc_string, g_Handle, sizeof(esc_string)); //369

g_PlayerInfo[playerid][pSQLid] = cache_get_row_int(0, 0, g_Handle); //474

cache_get_row(0, 1, g_PlayerInfo[playerid][pPass], g_Handle, 130); //475

cache_get_row(0, 2, g_PlayerInfo[playerid][pSalt], g_Handle, SALT_LENGTH+1);//476

g_PlayerInfo[playerid][pHealth] = cache_get_row_float(0, 4, g_Handle),//494



Re: Problems with mysql.. Maybe someone could help me out.. - iJumbo - 18.10.2013

Please look at the changelog for the mysql Plugin


Re: Problems with mysql.. Maybe someone could help me out.. - Scrillex - 18.10.2013

I don't have any changelog...


Re: Problems with mysql.. Maybe someone could help me out.. - Konstantinos - 18.10.2013

cache_get_row_int and cache_get_row_float functions were added in r14.

I'd recommend you to use R34 (or R33 which is static too) which is always better! However, if you want to use r7 or r8, you'll need to store the result to a string and then use strval and floatstr to convert them.


Re: Problems with mysql.. Maybe someone could help me out.. - iJumbo - 18.10.2013

This changelog: https://code.******.com/p/sa-mp-mysq...in/source/list


Re: Problems with mysql.. Maybe someone could help me out.. - Scrillex - 18.10.2013

Yeah I already took r34.. the errors are thats why.. but idk... how to fix them.. at ****** it showed one page without a solution..

And thank you guys for your time.. Just new with this mysql thing .. I hope soon all the function I will know how to use them..


Re: Problems with mysql.. Maybe someone could help me out.. - Konstantinos - 18.10.2013

Update a_mysql.inc too.


Re: Problems with mysql.. Maybe someone could help me out.. - Scrillex - 18.10.2013

lol I'm totally stupid.. I used to update with plugin-R7-win32_vs9 not r34... okay mate big thanks to all you guys.

With best regards Scrillex.