mysql multiple connections - 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: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql multiple connections (/showthread.php?tid=555160)

---

mysql multiple connections - TakeiT - 06.01.2015

I'm trying to build a filterscript, where its database is the same user as the main gamemode, but a different databasse. Using mysql_connect again seems to be causing issues (with threaded queries).

Does anyone know how to properly allow connection to 2 or more databases at a time?

---

Re: mysql multiple connections - Dignity - 06.01.2015

Have you tried using two separate variables to store your connection in?

---

Re: mysql multiple connections - TakeiT - 06.01.2015

Yeah.

---

Re: mysql multiple connections - Dignity - 06.01.2015

https://sampwiki.blast.hk/wiki/MySQL/R33#mysql_option

---

Re: mysql multiple connections - TakeiT - 06.01.2015

Thanks, that removed the warning, But I guess that wasn't the problem. In the filterscript, if I have the following line
Queries work, but the callback on mysql_tquery does not call. Commenting that line out fixes it.

EDIT: it still seems to log it with it disabled in all scripts, I guess thats good enough

---

Re: mysql multiple connections - Dignity - 06.01.2015

---

Re: mysql multiple connections - PowerPC603 - 07.01.2015

Do you use MySQL R39-2, combined with the latest streamer version?

I had the same problem and it was investigated and there seems to be a conflict between both plugins, causing callbacks failing to work in filterscripts.

I fixed it by going back to MySQL plugin R34 on my server.

---