+- Las Venturas Playground (https://forum.sa-mp.nl)
+-- Forum: Main Talk (https://forum.sa-mp.nl/forum-3.html)
+--- Forum: Development (https://forum.sa-mp.nl/forum-16.html)
+--- Thread: MySQL: What we need (/thread-25819.html)
MySQL: What we need - Jay - 11-29-2010
This is the current plugin we use for MySQL. It has a few problems and is fairly limited.
- Automatic detection and reconnection upon performing MySQL queries. Sure it'd be possible in PAWN using mysql_ping(), but in the current version of our plugin this function has some crashes often if queries conflict. I have reported it in the topic and personally but the writer hasn't done anything about it.
- A mysql_query native with an option to call a custom callback for when the query is complete to make threading nice and easy
Code:
mysql_thread_query(const query[], const callback[], const format[], {Float,_}:...)
Example:
mysql_query_callback("UPDATE Players SET registered = 1 WHERE name = 'Jay'", OnPlayerRegister, "d", playerid);- The possibility to have more than one result stored.
Have fun
