[Podunk]

/*
rememberthefrags SQL
Remembers your Frags/Deaths even after reconnecting.
CVAR            Default Value    Description

rtf_id             "not set"    //Unique Identifier for this network
rtf_sql_type       "sqlite"     //mysql or sqlite
rtf_sql_host       "127.0.0.1"  //sql host
rtf_sql_user       "root"       //sql username
rtf_sql_pass       ""           //sql password
rtf_sql_db         "rtf"        //database name
rtf_sql_table      "rtf"        //table name
rtf_tickrate       5.0          //rate at which plugin runs ( LOWER = MORE CPU )
rtf_reset_newround 0            //discard data on new round ( 0 or 1 )
rtf_min_frags      0            //minimum frags before account is started
rtf_min_deaths     0            //minimum deaths before account is started

*/
new PLUGINNAME[] = "rtf_sql"
new VERSION[] = "0.2.6 beta"
new AUTHOR[] = "FoolyCooly/JGHG"
#include <amxmisc>
#include <cstrike>
#include <fun>
#include <sqlx>

[Deviance]

You should use SQLx instead of DBI, AFAIK it doesn't work to use anymore.
Here's a good tut on SQLx: http://forums.alliedmods.net/showthread.php?t=46779

[Podunk]

"AFAIK it doesn't work to use anymore."

not true, I'm using the latest release of amxmodx, and it compiles and runs just fine

you are right about sqlx being the successor, I was using that at first, but this is my first time writing sql stuff in plugins so I opted for the much easier to implement dbi class

[Deviance]

Originally Posted by Podunk "AFAIK it doesn't work to use anymore." not true, I'm using the latest release of amxmodx, and it compiles and runs just fine

Right, whatever then.

Originally Posted by Podunk you are right about sqlx being the successor, I was using that at first, but this is my first time writing sql stuff in plugins so I opted for the much easier to implement dbi class

You'll see the reasons why SQLx is better then DBI in the tut anyway.

[Zenith77]

CREATE TABLE `frags` (
`id` varchar(64) NOT NULL,
`frags` int(10) NOT NULL default '0',
`deaths` int(10) NOT NULL default '0',
`name` varchar(64) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Just add this in your code, along with an IF NOT EXISTS statement to make sure you don't over write it. And yes, use SQLx. The only reason why your plugins is because SQLx provides backwards compatibility. Do not use older standards to create newer plugins.

[hasta]

rememberthefrags by nick, possibly?

[bmann_420]

Oops, but it would be nice if you could use this with sqlite also, for those of us without a database. (I have used jghg's forever now and love it)

[vvg125]

Any chance for nVault support on this?

Nice job btw.

[Podunk]

I believe the origonal "rememberthefrags" plugin was designed for the vault db

Deviant, Zenith77, Thanks for the advice.

does SqlX work with sqlite?

[Deviance]

Originally Posted by Podunk Deviant

Deviance

Originally Posted by Podunk does SqlX work with sqlite?

According to the tutorial it does.