[jugule]

Hi, I also have a problem with the 'SQL_ReadResult' function, this function is to see if the player in the database has VIP.

The column in the database is called: vip.


Error:

PHP Code:

08/22/2020 - 00:26:00: [MySQL] Invalid column: -1
08/22/2020 - 00:26:00: [AMXX] Displaying debug trace (plugin "test.amxx")
08/22/2020 - 00:26:00: [AMXX] Run time error 10: native error (native "SQL_ReadResult")
08/22/2020 - 00:26:00: [AMXX] [0] test.sma::register_client (line 7771) 


[Shadows Adi]

The error may be in the results from the sql, the columns are wrong.

[jugule]

Originally Posted by Shadows Adi The error may be in the results from the sql, the columns are wrong.

in sql :
table: players : colum is vip (value 1 = vip / value 0 = no vip)
whats are wrong?

[Shadows Adi]

Then try to change this:

 g_vip[id] = SQL_ReadResult(Query, vip3);

in

 g_vip[id] = SQL_ReadResult(Query, /*Column Number*/);

I mean, avoid this:

PHP Code:

new vip3 = SQL_FieldNameToNum(Query, "vip"); 


[jugule]

Originally Posted by Shadows Adi Then try to change this: g_vip[id] = SQL_ReadResult(Query, vip3); in g_vip[id] = SQL_ReadResult(Query, /*Column Number*/); I mean, avoid this: PHP Code: new vip3 = SQL_FieldNameToNum(Query, "vip");

same problem.

[Shadows Adi]

Provide more code.

[jugule]

solved.

[ZaX]

And how did you solve it? Post the solution because other people might have the same issue