[TF2 Stats] With Web Ranking and Item Logger [v9.1.0] - Page 8

**DarthNinja** · 12-04-2009 , 05:57 Re: TF2 Stats With Web Ranking and Item Logger

I assume thats an error you get when importing?

You'd get that if that entry already exists in the database and you're trying to import a new copy.

Just delete the preexisting entry and import.

-Edit
That is to say, delete it on the mysql server.

eraserhead · 12-04-2009 , 08:22 Re: TF2 Stats With Web Ranking and Item Logger

Yes, its an importing error. Its my own steam ID because i entered the server to test and now my own score is the only one in the MySQL database. How can i remove that record from the datbase so i can import it afterwards? Im a total phpMyAdmin noob.

When looking at the structure i see three fields: name, datatxt, dataint?

Should i do a query to find that one record? How do i do this?

eraserhead · 12-04-2009 , 08:49 Re: TF2 Stats With Web Ranking and Item Logger

oh i noticed that thos three fields were part of the 'Data' table. I now selected the Player table and pressed the Empty button and it was truncated. Now i when i look at my webstats it looks to have been succesfull although i got this error:

SQL-query:
INSERT INTO Player VALUES('STEAM_0:1:11360953','/-Taso-\',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0); INSERT INTO Player VALUES('STEAM_0:1:6310374','DankMastaFlex _ P4770N',6,5,1254633703,0,1,0,0,0,0,0,0,0,0,0, 0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); INSERT INTO Player VALUES('STEAM_0:0

944291','Black Jesus',-4,2,1254633523,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); INSERT INTO Player VALUES('STEAM_0:1:19768839','bP`',0,3,1254635 263,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0 ,0,0,0,0,0,0,0,0,0,0); INSERT INTO Player VALUES('STEAM_0:1:26176787','Dani xD',0,0,0,0,0,0,0,0,0,0,0,0,0,0[...]
MySQL retourneerde:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STEAM_0:1:6310374','DankMastaFlex _ P4770N',6,5,1254633703,0,1,0,0,0,0,0,0,0,0,0' at line 1

eraserhead · 12-04-2009 , 08:53 Re: TF2 Stats With Web Ranking and Item Logger

Well everything seems to be in order if i look at the webststats :-)

http://www.pulpfortress.com/tf2stats/ranking/player

eraserhead · 12-04-2009 , 10:38 Re: TF2 Stats With Web Ranking and Item Logger

I have a feature request: it would be nice to make an extra column in the player rankings list that shows the KD ratio.

eraserhead · 12-04-2009 , 16:10 Re: TF2 Stats With Web Ranking and Item Logger

And i think i have found a bug: When you look at the player details it allways shows 0 headshot kills. Or am i the only one with that problem?

quinbd · 12-04-2009 , 16:31 Re: TF2 Stats With Web Ranking and Item Logger

I have the plugin setup and working fine, but i can't get the web working. I installed it on my server, which is my own running wamp, and i get a slew of errors. I set up the settings.php with the same working information i used for the plugin. i used localhost, root, and a password, and yet the error looks like it is using default values or something for some reason. This is the site

http://damerell.is-a-geek.com/TF2/rank/

any help would be awesome

thanks

**DarthNinja** · 12-04-2009 , 16:43 Re: TF2 Stats With Web Ranking and Item Logger

So you want the k/d for each player to show on the rankings page too?
I can do that.

Quote:

Originally Posted by eraserhead

And i think i have found a bug: When you look at the player details it allways shows 0 headshot kills. Or am i the only one with that problem?

Yea there are several bugs with the plugin, I think the headshot one is easy to fix though...
Give me a minute and I'll see if I can fix it.

eraserhead · 12-04-2009 , 18:25 Re: TF2 Stats With Web Ranking and Item Logger

Well i installed it but can't say anything about it because now i have a bigger problem! It seems the plugin is not working anymore. There are 16 people on the server right now but looking on our page it says 'No online players at the moment'. This is strange because it used to work before. Only thing i did was empty all tables and import the sqlite database. Could something have been damaged? The first time i imported records i went on the server and i saw my score added to the points i had after importing. Only thing that happened after that is that i had to empty the tables again and import again because i got errors about some strange steam names some users had.

http://www.pulpfortress.com/tf2stats/index.php

eraserhead · 12-04-2009 , 19:06 Re: TF2 Stats With Web Ranking and Item Logger

It seems i accidentally uploaded the wrong databases.cfg file sometime this day. Changed it back but can't check out to see if it's working again because there are people playing now. I reloaded with the plugin manager but it keeps going back to the sqlite database instead of MySQL....have to reboot the server on a later time to find out if that fixes it.