Problem with XP statistics :/

[Luke]

amxx 1.8.1-3711
metamod 1.19.32
wc3 2.3.2
XP statistics 1.1

warcraft3FT.cfg

Code: Select all

// Warcraft 3 Frozen Throne Configuration File

mp_savexp		1		// Enables saving of experience (uses a vault, default is 0)
sv_sql			1		// Save using a SQL module (a module needs to be turned on, note: to use this mp_savexp must also be 1, default is 0)
FT_saveby		0		// What should I save this as?  steam id = 0, IP = 1, name = 2 (default is 0)
FT_admin_flag		"m"		// Admin flag required to give/take XP (default is m)

// SQL configuration
FT_sql_host		"89.161.240.214"	// Host Name
FT_sql_user		"onyxadv2"		// User Name
FT_sql_pass		"top secret :P"		// Password
FT_sql_db		"onyxadv2"		// Database Name
FT_auto_pruning		0		// Automatically prunes the database of old users at a mapchange (default is 0)
sv_daysbeforedelete	666		// However many days before deleting XP or pruning from the database (default is 31)
sv_sqltablename		"war3users"	// Table Name, no need to change (default is war3users)
sv_save_end_round	1		// Save xp at the end of each round (may cause lag, default is 1)

config.php

Code: Select all

<?
/*************************************************
*	This is the configuration file, please
*	enter the mysql information below
*
*	Details at http://war3ft.com
*
*	Credits: Design set up by b4p
*************************************************/

$host =		"89.161.240.214";
$username =     "onyxadv2";
$pass =		"top secret :P";
$dbname =	"onyxadv2";
$tbname =	"war3users";

// Set this to true to show the user's steam ID
$show_steam_id = false;

// The amount to display per page
$limit = 100;

/*** DO NOT EDIT BELOW THIS LINE ***/
require("functions.inc.php");

// Open the mysql connection
$mysql = mysql_connect($host, $username, $pass) or die("Could not connect : " . mysql_error());

// Select the database
mysql_select_db($dbname) or die("Could not select " . $dbname . " database");
?>

My XP statistics WebSite:

http://onyxadv.home.pl/war3stats/index.php

Code: Select all

Query failed : Table 'onyxadv2.war3users' doesn't exist

Help me pls!

[Geesu]

I think you're using version 1.2 and not 1.1 - you 100% sure you're using 1.1?

[Luke]

yes, i'm sure!

xp_statistics_v1.1

[Luke]

What now? Any idea?

[aligind4h0us3]

Be patient as a first idea.

[Luke]

Be patient as a first idea.

lol

Guys, i need xp statistics, i love it

[Geesu]

Can you post a .sql dump of your database?

[Luke]

from server ?

my sqlite from server....

http://onyxadv.home.pl/sqlite3.zip

[YamiKaitou]

No, we mean the SQL dump that the statistics page is using. If you are saving your XP to SQLite, that is why you can't get the page to work right

[Luke]

ok, i exported database...

look this

http://www.cs-czero.nazwa.pl/luke/warcraft.sql

and check this...

warcraft3FT.cfg from server

Code: Select all

Code:
// Warcraft 3 Frozen Throne Configuration File

mp_savexp      1      // Enables saving of experience (uses a vault, default is 0)
sv_sql         1      // Save using a SQL module (a module needs to be turned on, note: to use this mp_savexp must also be 1, default is 0)
FT_saveby      0      // What should I save this as?  steam id = 0, IP = 1, name = 2 (default is 0)
FT_admin_flag      "m"      // Admin flag required to give/take XP (default is m)

// SQL configuration
FT_sql_host      "89.161.240.214"   // Host Name
FT_sql_user      "onyxadv2"      // User Name
FT_sql_pass      "top secret :P"      // Password
FT_sql_db      "onyxadv2"      // Database Name
FT_auto_pruning      0      // Automatically prunes the database of old users at a mapchange (default is 0)
sv_daysbeforedelete   666      // However many days before deleting XP or pruning from the database (default is 31)
sv_sqltablename      "war3users"   // Table Name, no need to change (default is war3users)
sv_save_end_round   1      // Save xp at the end of each round (may cause lag, default is 1)

config.php from WebSite

Code: Select all

Code:
<?
/*************************************************
*   This is the configuration file, please
*   enter the mysql information below
*
*   Details at http://war3ft.com
*
*   Credits: Design set up by b4p
*************************************************/

$host =      "89.161.240.214";
$username =     "onyxadv2";
$pass =      "top secret :P";
$dbname =   "onyxadv2";
$tbname =   "war3users";

// Set this to true to show the user's steam ID
$show_steam_id = false;

// The amount to display per page
$limit = 100;

/*** DO NOT EDIT BELOW THIS LINE ***/
require("functions.inc.php");

// Open the mysql connection
$mysql = mysql_connect($host, $username, $pass) or die("Could not connect : " . mysql_error());

// Select the database
mysql_select_db($dbname) or die("Could not select " . $dbname . " database");
?>

0:/czero/addons/amxmodx/data/



Help...

[YamiKaitou]

You gave us the wrong database.


Since there is a chance that you might be saving via sqlite, please also provide the output of the following command

rcon meta list

[Luke]

Code: Select all

          [ 1] AMX Mod X        RUN   -    amxmodx_mm_i386.  v1.8.1.3  ini   Start ANY  
          [ 2] MySQL            RUN   -    mysql_amxx_i386.  v1.8.1.3  pl1   ANY   ANY  
          [ 3] SQLite           RUN   -    sqlite_amxx_i386  v1.8.1.3  pl1   ANY   ANY  
          [ 4] Fun              RUN   -    fun_amxx_i386.so  v1.8.1.3  pl1   ANY   ANY  
          [ 5] Engine           RUN   -    engine_amxx_i386  v1.8.1.3  pl1   ANY   ANY  
          [ 6] FakeMeta         RUN   -    fakemeta_amxx_i3  v1.8.1.3  pl1   ANY   ANY  
          [ 7] CStrike          RUN   -    cstrike_amxx_i38  v1.8.1.3  pl1   ANY   ANY  
          [ 8] CSX              RUN   -    csx_amxx_i386.so  v1.8.1.3  pl1   ANY   ANY  
         8 plugins, 8 running

[YamiKaitou]

Please provide a dump of the "onyxadv2" database.