[Plugin] [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - 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] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 (/showthread.php?tid=122983)

---

Re: [REL] SA:MP MySQL Plugin 2.1 - Released (11/24/2010) - StrickenKid - 27.01.2011

Btw, can a mod please change the topic name to: "[REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011)"

Thanks.

---

Re: [REL] SA:MP MySQL Plugin 2.1 - Released (11/24/2010) - PeteShag - 27.01.2011

Oh yeah....

Thanks for the update.

---

Re: [REL] SA:MP MySQL Plugin 2.1 - Released (11/24/2010) - Deji - 28.01.2011

Could support for packed strings be added?

---

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - Raimis_R - 01.02.2011

Why i have this error [MySQL] Error (0): Function: mysql_connect failed, mysql was not initialized on this handle.

---

AW: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - selEcT - 04.02.2011

Is there a possibility to make an inner join statement (p.e. SELECT * FROM blabla INNER JOIN blabla2 ON balabla.ID = blabla2.ID) and read out the fields of the two tables (a whole load function)? Is this more confortable and optimized?

---

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - Dj_maryo1993 - 09.02.2011

A problem here too .
[17:14:26] [MySQL] Error (0): Function: mysql_connect failed, mysql was not initialized on this handle.

---

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - Fro1sha - 10.02.2011

mysql_close don't close handle.

And server crash...

---

AW: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - n8 - 11.02.2011

^^ to many noobs with too many problems :-p
StrickenKid your work rocks its fucking awsomme!!!
and it makes controlling so easy thx for this plugin

Live from fucking switzerland
Grezz Nate

---

AW: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - n8 - 12.02.2011

i read a little bit of your problems

heer is a little tutorial it works first time:

ON TOP OF SCRIPT
#include <mysql>

#define SQL_HOST "127.0.0.1"
#define SQL_DB "*******"
#define SQL_USER "root"
#define SQL_PASS "*******"

new MySQL:connection;

AND ON GAME / FILTER SCRIPT INIT

connection = mysql_init(LOG_ONLY_ERRORS, 1);
mysql_connect(SQL_HOST, SQL_USER, SQL_PASS, SQL_DB, connection, 1);

if this not work you have not a sql server running. Download XAMPP for Fuck Windows to test.

Grezz Nate

---

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - StrickenKid - 12.02.2011

Build 157 - Fixed.

---

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - Burridge - 12.02.2011

Your Linux Static link doesn't work.

---

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - StrickenKid - 12.02.2011

Whoops, had the file named linux_satic_2.1.1.tar.gz by mistake

Fixed now :P

---

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - Redirect Left - 12.02.2011

I keep getting this error when trying to do something regarding MySQL:

Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.

Any tips?

---

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - xxmitsu - 12.02.2011

That could be caused because you're not freeing the result before storing it again.

You should use mysql_free_result afer each mysql_store_result.

---

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - Burridge - 13.02.2011

Thanks.

---

AW: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - JulianM - 13.02.2011

That's funny ...
Sometimes the links works and somtimes you'll be redirected to the parked domain, strange.

I've got now all files, but StrickenKid should check this problem with the host^^

---

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - kLx - 17.02.2011

Waddup!

So, I have this problem here.
When I use mysql_real_escape_string on strings, where first letter is unicode (ą č ę ė į š ų ū ž), the whole script gets messed up, check this out.
I think it's somehow related to charsets, are there any fixes, or it's inside the plugin?

---

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - RingoRus - 28.02.2011

After several restarts the server I get an error:
[MySQL] Error: Max connections (4) reached, could not connect.

How to do that did not open more than one connection after restarts?
(mysql_connect() and mysql_close() called in OnGameModeInit and OnGameModeExit respectively)

P.S. Sorry if there are errors in the post, the English do not know much

---

AW: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - Akmet - 28.02.2011

there are some solutions
exit the server and restart it then(no gmx)

or u change the source and set it up to an maximal 10 connections or something else


but i think, the best solution would be that the amount of maximal connections is just the count of actual connections.
for example:
i have two connections in my gm, a fs with one connection.
now i want to reload my filterscript 2 or 3 times. after the first reloading the server exits, because it reached 4 connections, but i only have actual 3 connections
is that probalby Incognito?

---

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - Sheeba - 28.02.2011

Thanks everyone.I need it.I'm coding a role play panel and I use MySQL and PHP.My game mode is connected to MySQL server.I research mysql plugins for Linux and I found it.

---