MySQL syntax error
#1

Hi all.

I get these codes with my new MySQL script.
Код:
C:\Users\Nicolas\Downloads\samp03z_svr_R1_win32\gamemodes\PLRPbene.pwn(28951) : error 076: syntax error in the expression, or invalid function call
C:\Users\Nicolas\Downloads\samp03z_svr_R1_win32\gamemodes\PLRPbene.pwn(28953) : error 047: array sizes do not match, or destination array is too small
C:\Users\Nicolas\Downloads\samp03z_svr_R1_win32\gamemodes\PLRPbene.pwn(28955) : error 076: syntax error in the expression, or invalid function call
C:\Users\Nicolas\Downloads\samp03z_svr_R1_win32\gamemodes\PLRPbene.pwn(28957) : error 047: array sizes do not match, or destination array is too small
C:\Users\Nicolas\Downloads\samp03z_svr_R1_win32\gamemodes\PLRPbene.pwn(28959) : error 076: syntax error in the expression, or invalid function call
C:\Users\Nicolas\Downloads\samp03z_svr_R1_win32\gamemodes\PLRPbene.pwn(28961) : error 047: array sizes do not match, or destination array is too small
Here's the lines of the errors.

pawn Код:
new stringnome1[256];
    format(stringnome1,sizeof(stringnome1),"SELECT `nomepersonaggio1` FROM `users` WHERE `username` = `%e`",PlayerName);
    mysql_query(stringnome1);
    PlayerInfo[playerid][pNomePersonaggio1] = stringnome1;
    new stringnome2[256];
    format(stringnome2,sizeof(stringnome2),"SELECT `nomepersonaggio2` FROM `users` WHERE `username` = `%e`",PlayerName);
    mysql_query(stringnome2);
    PlayerInfo[playerid][pNomePersonaggio2] = stringnome2;
    new stringnome3[256];
    format(stringnome3,sizeof(stringnome3),"SELECT `nomepersonaggio3` FROM `users` WHERE `username` = `%e`",PlayerName);
    mysql_query(stringnome3);
    PlayerInfo[playerid][pNomePersonaggio3] = stringnome3;
Can you help me? Thanks
Reply
#2

If your plugin is outdated, Upgrade your plugin to Mysql R7.


and replace mysql_query with mysql_function_query

Usage of mysql_function_query :
Код:
 mysql_function_query( connectionHandle,query[],bool:cache,callback[], format[],{Float,_}:... )
And use mysql_format instead of format(....);

Usage of Mysql_format

Код:
 mysql_format(connectionHandle, output[], format[],{Float,_}:...)
Hope i helped.
Reply
#3

Not sure but i think this will work:
pawn Код:
format(PlayerInfo[playerid][pNomePersonaggio1],sizeof(PlayerInfo[playerid][pNomePersonaggio1]),"SELECT `nomepersonaggio1` FROM `users` WHERE `username` = `%e`",PlayerName);
    mysql_query(PlayerInfo[playerid][pNomePersonaggio1]);
    format(PlayerInfo[playerid][pNomePersonaggio2],sizeof(PlayerInfo[playerid][pNomePersonaggio2]),"SELECT `nomepersonaggio2` FROM `users` WHERE `username` = `%e`",PlayerName);
    mysql_query(PlayerInfo[playerid][pNomePersonaggio2]);
    format(PlayerInfo[playerid][pNomePersonaggio3],sizeof(PlayerInfo[playerid][pNomePersonaggio3]),"SELECT `nomepersonaggio3` FROM `users` WHERE `username` = `%e`",PlayerName);
    mysql_query(PlayerInfo[playerid][pNomePersonaggio3]);
Reply
#4

Quote:
Originally Posted by [D]ry[D]esert
Посмотреть сообщение
Not sure but i think this will work:
pawn Код:
format(PlayerInfo[playerid][pNomePersonaggio1],sizeof(PlayerInfo[playerid][pNomePersonaggio1]),"SELECT `nomepersonaggio1` FROM `users` WHERE `username` = `%e`",PlayerName);
    mysql_query(PlayerInfo[playerid][pNomePersonaggio1]);
    format(PlayerInfo[playerid][pNomePersonaggio2],sizeof(PlayerInfo[playerid][pNomePersonaggio2]),"SELECT `nomepersonaggio2` FROM `users` WHERE `username` = `%e`",PlayerName);
    mysql_query(PlayerInfo[playerid][pNomePersonaggio2]);
    format(PlayerInfo[playerid][pNomePersonaggio3],sizeof(PlayerInfo[playerid][pNomePersonaggio3]),"SELECT `nomepersonaggio3` FROM `users` WHERE `username` = `%e`",PlayerName);
    mysql_query(PlayerInfo[playerid][pNomePersonaggio3]);
That gives me:
Код:
C:\Users\Nicolas\Downloads\samp03z_svr_R1_win32\gamemodes\PLRPbene.pwn(28964) : error 001: expected token: "]", but found "-identifier-"
C:\Users\Nicolas\Downloads\samp03z_svr_R1_win32\gamemodes\PLRPbene.pwn(28964) : warning 215: expression has no effect
C:\Users\Nicolas\Downloads\samp03z_svr_R1_win32\gamemodes\PLRPbene.pwn(28964) : error 001: expected token: ";", but found "]"
C:\Users\Nicolas\Downloads\samp03z_svr_R1_win32\gamemodes\PLRPbene.pwn(28964) : error 029: invalid expression, assumed zero
C:\Users\Nicolas\Downloads\samp03z_svr_R1_win32\gamemodes\PLRPbene.pwn(28964) : fatal error 107: too many error messages on one line
.
Reply
#5

Resolved!

pawn Код:
PlayerInfo[playerid][pNomePersonaggio3] = stringnome3[123];
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)