MySQL: What we need

[Jay]

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