Databases with AMXx 0.2
 

I am announcing an important change in AMX Mod X structure which pertains to scripters for 0.2.

I have implemented a trivial Database API so a plugin that uses SQL will work anywhere. As long as the user has a database interface module loaded, and the plugin author uses ANSI-SQL, it will work. If you would like something other than MySQL or PgSQL supported, please list it here.

Change for scripters:

Should be changed to:

Any function that references a native like this:
mysql_query, mysql_connect
Is now:
dbi_query, dbi_connect, et cetera.
configs/mysql.cfg is now configs/sql.cfg
amx_mysql_cvars are now amx_sql_cvars

Remember, this is for 0.2 only. (changes are in CVS).

Please be ready to change to this new format when the next release comes out.

(btw - I fixed those infamous crashing bugs in mysql module)

Re: Databases with AMXx 0.2
 

THANK GOD!!! Can you give us any input as to why it was happening?

there was actually, believe it or not, no error checking in the module at all.
if you find something that crashes it, please tell me and I will fix it

will thy mysql.cfg file also be renamed?

yes, to sql.cfg

Hurray!
 

hurray much simnpler, good job!

k, will the cvars change too?
"amx_mysql_db,amx_mysql_host,......."

sorry for all the questions, but I'm updating my code at the moment.

Yes, sorry, I should mention that
mysql => sql in cvar name

someone asked me if sql is a thing used to hack people....

I love you BAIL, I've HATED the mysql module for so long because you couldn't execute multiple commands w/o a crash.

one question though.

Lets say when someone types /rank I query a server and display some info. And the ping b/t my server and the mysql server is around like 200 (not very good). Will the server freeze up? This is what happened with the old one, was wondering if this would still be an issue.