Xp stats

Senne · Post by **Senne** » Tue Sep 11, 2007 11:38 am

hi,
could it be that xp statistics 2 , latest version, does not yet work with RC8.0 ?

Post by **YamiKaitou** » Tue Sep 11, 2007 12:34 pm

1.2 should work fine with 3.0. What is the error message that you are getting?

Senne · Post by **Senne** » Tue Sep 11, 2007 2:38 pm

Well , ill reinstall it and show it to you.

- it didnt display the individual player stats correctly : 1 mysql error + icons wrong
- it displayed not the correct stats, when i was still using war3users , my top users had about 200k xp on one race; this stats only display a user with max 70k ; it is connected to the right database (config.php is correct) but seems to display users from a diffrent server (yea i know it sounds strange)

my old stats : http://t3hreloaded.com/xpstats/
the new stats : http://t3hreloaded.com/xpstats2/

config file is using in both stats the same parameters (since i still have the old war3users on the mysql server as backup)

Code: Select all

// 4HM Forums database
$config->dbuser 		= "senne_senne";
$config->dbpassword 	= "xxxxleftoutxxxx";
$config->dbname 		= "senne_amxxft";
$config->dbhost 		= "75.126.64.xxleftoutxx";

Post by **YamiKaitou** » Tue Sep 11, 2007 3:16 pm

Do the wc3_web_* tables exist? If yes, try deleting them and changing the map or restart the server.

Senne · Post by **Senne** » Tue Sep 11, 2007 5:10 pm

ok i will do that tomorrow morning after a decent backup, did you compair on sight the diffrences in xp amounts and players?
xpstats2 does not display my server player's xp !

Post by **YamiKaitou** » Tue Sep 11, 2007 9:22 pm

I didn't have that much of a chance to look at it. I am going to look at the source code some tomorrow after school and see if I can construct something. I do not have 3.0 saving to MySQL, so I really can't test it

Senne · Post by **Senne** » Wed Sep 12, 2007 3:17 am

ok, let me know if you need something from my side.

Senne · Post by **Senne** » Thu Sep 20, 2007 1:40 pm

any clue why it displays stats from a diffrent server?

Senne · Post by **Senne** » Tue Oct 16, 2007 9:58 am

Any update maybe,
or fixes?

Or just tell me to stop annoying you guys

Senne · Post by **Senne** » Sat Nov 03, 2007 6:50 am

- search function doesnt work
- stats do not display all players (for instance i myself aint listed, while i have the most xp

- my steamid : STEAM_0:0:3637317 (you can try a search : http://t3hreloaded.com/xpstats2/index.php)

DesasterUK · Post by **DesasterUK** » Sat Nov 10, 2007 5:26 am

I noticed something similiar when i updated to 3.0 Beta ???
It converted the players to the new DB-Structure but on the stats it only displays players that starts playing after updating.

Maybe u have the same problem and never realised it.

Senne · Post by **Senne** » Sun Nov 25, 2007 5:38 pm

DesasterUK wrote:I noticed something similiar when i updated to 3.0 Beta ???
It converted the players to the new DB-Structure but on the stats it only displays players that starts playing after updating.

Maybe u have the same problem and never realised it.

yea that could be the thing!

Post by **Geesu** » Tue Nov 27, 2007 3:33 pm

Is it working now? Unfortunately the structure changed around RC6ish I think - so if you ran a previous DB version, you would have to delete all data for the 1.2 web statistics to work.

Josh

Senne · Post by **Senne** » Tue Dec 04, 2007 2:54 pm

im still running v3.0 RC8.0 tho;
just installed the new xp stats (v1.2.1)

error :

probably this is wrong :

Code: Select all

require("");
asdfsadf rquire config file!!

i removed it and it loads now.

altho all old players do not get displayed , but then again this will have to do with not having RC9.0 installed? (ill do this in a month orso, im kinda busy + i would need to install amxmodx 1.80 and have to recompile all my plugins etc)

http://t3hreloaded.com/xpstats/

Post by **Geesu** » Wed Dec 05, 2007 8:24 am

I'm confused is it not working now? And no you don't need RC9... RC8 should work fine

Senne · Post by **Senne** » Wed Dec 05, 2007 3:42 pm

Geesu wrote:I'm confused is it not working now? And no you don't need RC9... RC8 should work fine

its just the same as previous stats.

Post by **Geesu** » Fri Dec 07, 2007 8:36 am

But it's working normal now right?

Senne · Post by **Senne** » Fri Dec 07, 2007 10:31 am

Geesu wrote:But it's working normal now right?

not really,

its just the same as before :
not all players get displayed

for instance im not getting dislayed on my own stats : http://t3hreloaded.com/xpstats/
player : senne
even when i search myself by steamid.

same for other older players.

Post by **Geesu** » Fri Dec 07, 2007 1:44 pm

are you sure it's pointing to the correct database??

When you search in the database itself can you find yourself?

Provide me with a DB dump and I can debug this more.

Senne · Post by **Senne** » Sat Dec 08, 2007 7:11 am

Geesu wrote:are you sure it's pointing to the correct database??

When you search in the database itself can you find yourself?

Provide me with a DB dump and I can debug this more.

yeah because the old stats page is at http://t3hreloaded.com/xpstats2

ill recheck the config.php to be 100% sure, ill even reinstal it to be sure

downloaded : viewtopic.php?t=3080 version for 3.0

deleted the folder on ftp
reuploaded the folder
configurated config.php with the right details. (same details as on my wc3ft server)

i'm listed in the database and my xp is there when im in the gameserver (you can recheck this in the xp dump attached), playername senne, xp on orc 250000 , not listed in xpstats

sidenote :

Code: Select all

require("");
asdfsadf rquire config file!!

has to be removed from the config.php in order to work!

Liquidz · Post by **Liquidz** » Fri Dec 14, 2007 3:03 pm

I keep getting this error.

Parse error: syntax error, unexpected T_STRING in /home/adam/public_html/xpstats/config.php on line 14

Senne · Post by **Senne** » Sat Dec 15, 2007 6:55 am

Liquidz wrote:I keep getting this error.

Parse error: syntax error, unexpected T_STRING in /home/adam/public_html/xpstats/config.php on line 14

if you would have read the replies above , you would have solved this issue in 1 second...

remove this lines from the config :

require("");
asdfsadf rquire config file!!

Post by **Geesu** » Tue Dec 18, 2007 1:50 pm

It's been fixed - re download

slmclarengt · Post by **slmclarengt** » Wed Dec 19, 2007 1:48 am

Funniest part about this is that when I installed the web stats for myself today, I was shocked to see it actually worked (after I realized that my dbname/dbuser were asked for in opposite order than I'm used to - Geesu, were you TRYING to spin heads or did you play Spin the Damn Bottle with what cvars should be asked for first?).

Works beautifully: www.bndclan.com/wc3stats

Slmclarengt

Senne · Post by **Senne** » Thu Dec 20, 2007 2:16 pm

yea he had me a couple of times with it also

t3hreloaded.com/xpstats installed it.

Looks ok, but it still doesnt display all players...only the once that joined like 2 months ago and not the players that have been playing for a year in the server...

ex its still not displaying myself while i am listed in the mysql. (see attachement in a previous post)

Gunny · Post by **Gunny** » Wed Jan 09, 2008 11:33 am

I am also having the same problem of the stats not displaying all of the players.

me for example. I can't find myself in the stats but I am listed in the database.

Yes I am connecting to the correct database.

I have compared other players who are listed in the stats with what is listed in the database and it is listed correctly.

Post by **Geesu** » Tue Jan 15, 2008 12:14 pm

Unfortunately it won't display all players... I could have it but the names of teh people are lost in the conversion...

I'll put it on the to-do list to see if I can have them stored in the conversion, but the VERY first time you convert war3users to 3.0 would take a long time (could be like a 3 min conversion)

Perhaps I should make a web conversion tool... hmmmm....