[alanhutch]

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

[SanAndreasMP]

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.

[[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]);

[alanhutch]

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

.

[alanhutch]

Resolved!

pawn Код:

PlayerInfo[playerid][pNomePersonaggio3] = stringnome3[123];