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