[RujinXERO]

ok i realised that it got that stuff from the sql.cfg file.. so i looked in my amx database and the only other table besides the admins one was called %s not what the table cvar indicated.. and no inserts..

[ripcurl2]

i think i know what's going wrong.

mysql_query(g_dbc,
"CREATE TABLE IF NOT EXISTS `%s`
 (`authid` VARCHAR( 32 ) NOT NULL , 
 `name` VARCHAR( 32 ) NOT NULL , 
`date` TIMESTAMP( 10 ) NOT NULL , 
`rank` INT NOT NULL ,
`kills` INT NOT NULL , 
`teamkills` INT NOT NULL, 
`deaths` INT NOT NULL , 
`hits` INT NOT NULL , 
`shots` INT NOT NULL , 
`headshots` INT NOT NULL , 
`playtime` BIGINT NOT NULL , 
PRIMARY KEY ( `authid` ) )",
 g_sqlstats_table)

you see the %s?
the old 0.16 amx doesn't support this way of referring to a variable
%s = g_sqlstats_table

i'll see what i can do

[BigBaller]

good work man, this might prove useful for something I had in mind.

It would be cool if this was improved enough to even make part of the cstrike package lol.

[ripcurl2]

tell me your ideas ...

[4ever!]

The database is working but can you tell me how to link it to the site, to wich file i have to link? sorry but don't know that much about php en stuff..
Or does somebody haven a nice stats layout i can use??

thnx anyhow..

[MC-Olivenoel]

hi

how do u display the stat ingame ??

use u the breafing menu ??

[ripcurl2]

as the data is gathered into a database, it's up to you to make your custom ranking page. you can put the ranking in the motd.txt of the server if you wish (learn some html/php/xml/javascript coding to make it even better)

[ripcurl2]

to get the data from the database you have to query the database
example phpcode for mysql databases (this is just a part)

php

<?php
.... (connect to db) .... 

$statstable="sqlstatstable";
$sortoder="kills";//column name 

$result = mysql_query("SELECT * FROM ".$statstable." ORDER BY ".$sortorder);
while ($record=mysql_fetch_array($result)){
	$playtime=$record['playtime'];
	echo $record['name']."has ".$record['kills']." and has played ".$playtime." seconds";
}
?>

[BigBaller]

O my idea was just to give psychostats a run for its money

[ripcurl2]

i've made an attachment to the first post in this topic for sqlstats-0.16, you guessed it right its a new version for amxmodx 0.16.
It's still untested, i fixed the problem with the last version for 0.16, which complained about some things during compile. And i think this was the reason it didn't work right.

I'll see when i have time to setup a server with amxmod 0.16 to test it, meanwhile you guys can try it out. Feedback on sqlstats-0.16 is appreciated