Raised This Month: $12 Target: $400
 3% 

Databases with AMXx 0.2


Post New Thread Closed Thread   
 
Thread Tools Display Modes
Author Message
BAILOPAN
Join Date: Jan 2004
Old 04-02-2004 , 19:31   Databases with AMXx 0.2
#1

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:
Code:
#include <mysql>

Should be changed to:
Code:
#include <dbi>

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)
__________________
egg
BAILOPAN is offline
Geesu
Veteran Member
Join Date: Mar 2004
Location: Cincinnati, OH
Old 04-02-2004 , 19:47   Re: Databases with AMXx 0.2
#2

Quote:
Originally Posted by BAILOPAN
(btw - I fixed those infamous crashing bugs in mysql module)

THANK GOD!!! Can you give us any input as to why it was happening?
__________________
Need war3ft help? DO NOT PM ME... Check the forums
Geesu is offline
Send a message via AIM to Geesu Send a message via MSN to Geesu
BAILOPAN
Join Date: Jan 2004
Old 04-02-2004 , 19:58  
#3

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
__________________
egg
BAILOPAN is offline
DopeFish
Senior Member
Join Date: Feb 2004
Old 04-02-2004 , 20:31  
#4

will thy mysql.cfg file also be renamed?
DopeFish is offline
Send a message via ICQ to DopeFish
BAILOPAN
Join Date: Jan 2004
Old 04-02-2004 , 20:32  
#5

yes, to sql.cfg
__________________
egg
BAILOPAN is offline
knekter
Senior Member
Join Date: Mar 2004
Location: PA
Old 04-02-2004 , 20:40   Hurray!
#6

hurray much simnpler, good job!
__________________
More updates for Matrix Mod!
knekter is offline
Send a message via AIM to knekter Send a message via MSN to knekter
DopeFish
Senior Member
Join Date: Feb 2004
Old 04-02-2004 , 20:44  
#7

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.
DopeFish is offline
Send a message via ICQ to DopeFish
BAILOPAN
Join Date: Jan 2004
Old 04-02-2004 , 21:14  
#8

Yes, sorry, I should mention that
mysql => sql in cvar name
__________________
egg
BAILOPAN is offline
QwertyAccess
Veteran Member
Join Date: Feb 2004
Location: Enjiru Layer
Old 04-02-2004 , 22:29  
#9

someone asked me if sql is a thing used to hack people....
__________________
QwertyAccess is offline
Geesu
Veteran Member
Join Date: Mar 2004
Location: Cincinnati, OH
Old 04-02-2004 , 22:51  
#10

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.
__________________
Need war3ft help? DO NOT PM ME... Check the forums
Geesu is offline
Send a message via AIM to Geesu Send a message via MSN to Geesu
Closed Thread


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 02:22.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode