SA-MP Forums Archive
[Plugin] [REL] MySQL Plugin (Now on github!) - 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: Plugin Development (https://sampforum.blast.hk/forumdisplay.php?fid=18)
+--- Thread: [Plugin] [REL] MySQL Plugin (Now on github!) (/showthread.php?tid=56564)



Re: [REL] MySQL Plugin (Now on github!) - Morpheine - 26.02.2016

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)


Re: [REL] MySQL Plugin (Now on github!) - Jeroen52 - 26.02.2016

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?


Re: [REL] MySQL Plugin (Now on github!) - Unrea1 - 11.03.2016

v39-4 compiled in debian 7 please?


Re: [REL] MySQL Plugin (Now on github!) - Jeroen52 - 12.03.2016

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.


Re: [REL] MySQL Plugin (Now on github!) - Morpheine - 12.03.2016

Quote:
Originally Posted by Jeroen52
Посмотреть сообщение
Which plugin version are you using?
R33.


Re: [REL] MySQL Plugin (Now on github!) - Ducati - 12.03.2016

Useful!


Re: [REL] MySQL Plugin (Now on github!) - Unrea1 - 12.03.2016

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 ?


Re: [REL] MySQL Plugin (Now on github!) - Jeroen52 - 12.03.2016

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.


Re: [REL] MySQL Plugin (Now on github!) - Misiur - 26.03.2016

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


Re: [REL] MySQL Plugin (Now on github!) - Max_Andolini - 26.03.2016

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


Re: [REL] MySQL Plugin (Now on github!) - Misiur - 27.03.2016

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


Re: [REL] MySQL Plugin (Now on github!) - maddinat0r - 27.03.2016

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.


Re: [REL] MySQL Plugin (Now on github!) - Max_Andolini - 27.03.2016

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


Re: [REL] MySQL Plugin (Now on github!) - Jeroen52 - 27.03.2016

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.


Re: [REL] MySQL Plugin (Now on github!) - Jeroen52 - 27.03.2016

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


Re: [REL] MySQL Plugin (Now on github!) - Belengher - 27.03.2016

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


Re: [REL] MySQL Plugin (Now on github!) - vannesenn - 27.03.2016

[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



Re: [REL] MySQL Plugin (Now on github!) - Jeroen52 - 28.03.2016

Quote:
Originally Posted by LatinZ
View Post
debian 7, please?
Static or dynamically linked?


Re: [REL] MySQL Plugin (Now on github!) - Unrea1 - 28.03.2016

static


Re: [REL] MySQL Plugin (Now on github!) - Belengher - 28.03.2016

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??