[Morpheine]

Hi i use this variabile: new SQL; to define SQL connection with database but i get errors on SQL SELECT commands:
[ERROR] "mysql_query" - invalid connection handle (ID = 1)
[18:02:02] [ERROR] "mysql_format" - invalid connection handle (ID = 1)
[18:02:02] [ERROR] "mysql_tquery" - invalid connection handle (ID = 1)

[Jeroen52]

Quote:

Originally Posted by Morpheine Hi i use this variabile: new SQL; to define SQL connection with database but i get errors on SQL SELECT commands: [ERROR] "mysql_query" - invalid connection handle (ID = 1) [18:02:02] [ERROR] "mysql_format" - invalid connection handle (ID = 1) [18:02:02] [ERROR] "mysql_tquery" - invalid connection handle (ID = 1)

Which plugin version are you using?

[Unrea1]

v39-4 compiled in debian 7 please?

[Jeroen52]

Quote:

Originally Posted by LatinZ v39-4 compiled in debian 7 please?

Here you go: mysql.so . .

Please reply if it works or if it doesn't work. I haven't had the time to test it correctly.

[Morpheine]

Quote:

Originally Posted by Jeroen52 Which plugin version are you using?

R33.

[Ducati]

Useful!

[Unrea1]

Quote:

Originally Posted by Jeroen52 Here you go: mysql.so . . Please reply if it works or if it doesn't work. I haven't had the time to test it correctly.

Is mysql.so or mysql_static.so ?

[Jeroen52]

Quote:

Originally Posted by LatinZ Is mysql.so or mysql_static.so ?

It should be a working static shared object, it has only been renamed from mysql_static.so to mysql.so.

[Misiur]

Hello, did anybody encounter this bug - https://github.com/pBlueG/SA-MP-MySQL/issues/90 ?

[Max_Andolini]

Hello, can you look at this - https://github.com/pBlueG/SA-MP-MySQL/issues/89

[Misiur]

Can somebody build me windows plugin of this branch - https://github.com/pBlueG/SA-MP-MySQL/tree/issue-54 ?

[maddinat0r]

Quote:

Originally Posted by Misiur Can somebody build me windows plugin of this branch - https://github.com/pBlueG/SA-MP-MySQL/tree/issue-54 ?

No need for that

R39-5 has been released.
All changes and downloads can be found here: https://github.com/pBlueG/SA-MP-MySQ...ases/tag/R39-5

Special thanks to Kar for testing.

[Max_Andolini]

Quote:

Originally Posted by maddinat0r No need for that R39-5 has been released. All changes and downloads can be found here: https://github.com/pBlueG/SA-MP-MySQ...ases/tag/R39-5 Special thanks to Kar for testing.

Hello, can you look at this - https://github.com/pBlueG/SA-MP-MySQL/issues/89

[Jeroen52]

Quote:

Originally Posted by maddinat0r No need for that R39-5 has been released. All changes and downloads can be found here: https://github.com/pBlueG/SA-MP-MySQ...ases/tag/R39-5 Special thanks to Kar for testing.

Currently building the plugin statically for CentOS 6.

[Jeroen52]

Here is the plugin statically compiled for CentOS 6: https://mirror.jeroendeneef.com/samp...tatic/mysql.so . .

[Belengher]

How is it fair use?

Код HTML:

					format(var, sizeof(var), "UPDATE `players` SET `Registered` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pReg], PlayerInfo[playerid][pSQLID]);
					mysql_query(var);

Код HTML:

					format(var, sizeof(var), "UPDATE `players` SET `Registered` = '%d' WHERE id= %d", PlayerInfo[playerid][pReg], PlayerInfo[playerid][pSQLID]);
					mysql_query(var);

Код HTML:

					format(var, sizeof(var), "UPDATE `players` SET `Registered` = '%d' WHERE `id`= %d", PlayerInfo[playerid][pReg], PlayerInfo[playerid][pSQLID]);
					mysql_query(var);

Please help me!
Which of the above are good?

Sorry for myy bad english

[vannesenn]

[code]UPDATE players SET Registered = %d WHERE id = %d"[code]

Avoid `, MySQL will work without `. Also ' use when you want put string into query(so MySQL will Know what is string you want to put, and what is query)

Код:

UPDATE players SET Name = 'Carl Johnson' WHERE ID = 1

[Jeroen52]

Quote:

Originally Posted by LatinZ debian 7, please?

Static or dynamically linked?

[Unrea1]

static

[Belengher]

Quote:

Originally Posted by vannesenn [code]UPDATE players SET Registered = %d WHERE id = %d"[code] Avoid `, MySQL will work without `. Also ' use when you want put string into query(so MySQL will Know what is string you want to put, and what is query) Код: UPDATE players SET Name = 'Carl Johnson' WHERE ID = 1

Get this version is correct??