MySQL errors - Printable Version

MySQL errors - 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: MySQL errors (/showthread.php?tid=526871)

MySQL errors - [CG]Milito - 19.07.2014

Hey guys,

after a very long break from samp, I lost some of my knowledge.
Last night I was converting my script to mysql r33 version following this tutorial

https://sampforum.blast.hk/showthread.php?tid=485633

And I got some errors,

Код:

C:\Users\Emilio\Desktop\samp 0.3z\gamemodes\MySQLCops.pwn(1556) : error 028: invalid subscript (not an array or too many subscripts): "pInfo"
C:\Users\Emilio\Desktop\samp 0.3z\gamemodes\MySQLCops.pwn(1556) : warning 215: expression has no effect
C:\Users\Emilio\Desktop\samp 0.3z\gamemodes\MySQLCops.pwn(1556) : error 001: expected token: ";", but found "]"
C:\Users\Emilio\Desktop\samp 0.3z\gamemodes\MySQLCops.pwn(1556) : error 029: invalid expression, assumed zero
C:\Users\Emilio\Desktop\samp 0.3z\gamemodes\MySQLCops.pwn(1556) : fatal error 107: too many error messages on one line

This is the line 1556

pawn Код:

mysql_format(mysql, query, sizeof(query), "UPDATE `users` SET `AdminLvl`=%d, `VIPLvl`=%d, `Money`=%d, WHERE `ID`=%d",pInfo[playerid][pAdmin], pInfo[playerid][pVIP], pInfo[playerid][pMoney], pInfo[playerid][pID]);

This is the part of the code where the line is located

pawn Код:

new query[128];//query[128] is for formatting our query
    mysql_format(mysql, query, sizeof(query), "UPDATE `users` SET `AdminLvl`=%d, `VIPLvl`=%d, `Money`=%d, WHERE `ID`=%d",pInfo[playerid][pAdmin], pInfo[playerid][pVIP], pInfo[playerid][pMoney], pInfo[playerid][pID]);
    mysql_tquery(mysql, query, "", "");

Kind Regards

Re : MySQL errors - ManuelNeuer - 19.07.2014

Change this

pawn Код:

enum PInfo
{

to this

pawn Код:

enum PlayerData
{

pawn Код:

new PInfo[MAX_PLAYERS][PlayerData];

Re: Re : MySQL errors - [CG]Milito - 19.07.2014

Quote:

Originally Posted by ManuelNeuer

Change this

pawn Код:

enum PInfo
{

to this

pawn Код:

enum PlayerData
{

pawn Код:

new PInfo[MAX_PLAYERS][PlayerData];

Nothing changes

EDIT: Fixed