[spd_sahil]

i have an SQL databse , which is created in my gamemode..

but i want to access the values from inside it in another filterscript.. how do i achieve this ?

[Roel]

You mean you want to connect to the database within a filterscript?

[spd_sahil]

yes exactly

[Roel]

Well just copy the part in your gamemode that connects to the database, mostly this will be in OnGameModeinit.
And you have to include the mysql.inc in your filterscript, also you can copy this from your gamemode.

[aRoach]

Use:

pawn Код:

db_open( name[ ] ); // At OnFilterScriptInit
db_close( DB:Database ); // At OnFilterScriptExit

And do your job )

-----------

Quote:

Originally Posted by Roel Well just copy the part in your gamemode that connects to the database, mostly this will be in OnGameModeinit. And you have to include the mysql.inc in your filterscript, also you can copy this from your gamemode.

Lol man, it's not MYSQL, it's SQLite lol...

[Roel]

congratz

[spd_sahil]

Quote:

Originally Posted by aRoach Use: pawn Код: db_open( name[ ] ); // At OnFilterScriptInit db_close( DB:Database ); // At OnFilterScriptExit And do your job )

are u sure that works ? my server crashes when i reach the function where the FS is extracting from the database

also is this a legit query ??

pawn Код:

format(Query, sizeof(Query), "SELECT * FROM `USERS` WHERE `NAME` = '%s' ", DB_Escape(name));

[spd_sahil]

bump