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

crazyboylou · 12-20-2011 , 20:06 Re: [TF2 Stats] With Web Ranking and Item Logger [v8.9.0]

DarthNinja,
I figured out what was wrong... I entered in the database name wrong. I feel really stupid for it. Thanks for all of your hard work on fixing this mod up! It is really great! I love this stat system because it is more fair then any other! Keep other the great work! and I just have one more question...

In the pdf you state to "Just make an export of that file in .txt format. Open
the txt file and remove the lines in the beginning and in the ending of the file so that only the
lines with the player data remain (the lines that start with ‘INSERT INTO..etc’)."
I exported the player file not the data file. Where is the Insert Into in this text?

**DarthNinja** · 12-20-2011 , 20:10 Re: [TF2 Stats] With Web Ranking and Item Logger [v8.9.0]

I assume you're trying to export your sqlite database and import it into your sql database?
From that paste (use pastebin next time please) it looks like you exported the database structure, not the actual records.

crazyboylou · 12-20-2011 , 20:13 Re: [TF2 Stats] With Web Ranking and Item Logger [v8.9.0]

Where would i find the actual records? I did extract the tf2stats.sq3 file.

**DarthNinja** · 12-20-2011 , 20:17 Re: [TF2 Stats] With Web Ranking and Item Logger [v8.9.0]

http://sqlitebrowser.sourceforge.net/
Documentation is available.

crazyboylou · *Last edited by crazyboylou; 12-20-2011 at 22:54.*

#1136 - Column count doesn't match value count at row 1

^^^^ This is what is showing up now whenever I enter the data. Any suggestions?

Quote:

INSERT INTO Player VALUES('STEAM_0:1:20991231','Dr. Monocle- TheMonocleShow.com',4564,1681,1324268122,684, 454,67,7,8,4,65,69,46,4,0,4,25,0,68,159,0,0,0 ,30,32,13,0,0,0,0,0,0,0,1,11,0,0,0,0,5,32,1,0 ,42,0,0,16,0,0,0,1,0,0,1,0,18,17,0,0,0,20,0,1 ,0,0,0,41,0,0,0,0,6,1,0,0,11,0,0,0,2,0,0,0,0, 0,0,2,7,3,2,11,0,0,0,0,0,7,0,16,11,1,0,3,0,0, 0,0,4,0,11,0,20,0,0,16,33,0,0,157,68,109,34,8 1,10,9,44,66,33,62,183,44,115,23,31,49,121,68 ,0,2,10250,0,2,0,0,2,0,0,0,0,0,0,0,0,0,1,0,0, 5,0,0,0,67,0,0,0,0,0,2,0,8,0,0,0,0,27,3,0,1,0 ,0,25,0,0,0,0,11,0,0,0,0,2,0,0,0,0,0,13,0,19, 0,0,0,4,0,0,0,0,0,0,0,0,0);

**DarthNinja** · 12-20-2011 , 23:25 Re: [TF2 Stats] With Web Ranking and Item Logger [v8.9.0]

Due to structure differences in the SQLite and MySQL database versions, you will have to do an INSERT INTO VALUES statement. You may be able to generate the required SQL by first importing in to intermediary database, exporting, and re-importing.

crazyass · 12-21-2011 , 18:39 Re: [TF2 Stats] With Web Ranking and Item Logger [v8.9.0]

Hi, Would like to say, I love you plugin and would like to know if there is a Cvar for changing the admin flag from root to a custom one? if not, is there anyway of doing this?

**DarthNinja** · 12-21-2011 , 19:38 Re: [TF2 Stats] With Web Ranking and Item Logger [v8.9.0]

Quote:

Originally Posted by crazyass

Hi, Would like to say, I love you plugin and would like to know if there is a Cvar for changing the admin flag from root to a custom one? if not, is there anyway of doing this?

http://wiki.alliedmods.net/Overridin...28SourceMod%29

resin · *Last edited by resin; 12-22-2011 at 21:50.*

thanks for the ongoing updates, been using with for a while (sqllite) and its wonderful. I may have stated it before, but an option to rank by time played on the server as well would make it perfect (possibly an average between points and time played). But it's not a complaint, just an idea

thanks again!

**DarthNinja** · 12-22-2011 , 22:36 Re: [TF2 Stats] With Web Ranking and Item Logger [v8.9.0]

The website has the data to do such a ranking so I assume you mean ingame (also since you said you use sqlite).

I could write something like !mytime to output something like "<Name> has spent more time on this server then XX other players (xdays, xminutes, and xseconds). XX Players have spent more time on this server".

Is that what you're thinking?