[DrWagstaff]

http://stats.wagstaffsarena.com/index.php

You have to manually navigate to the index >_>. Something is wrong with the setup. Any ideas?

[Sobuno]

Originally Posted by DrWagstaff http://stats.wagstaffsarena.com/index.php You have to manually navigate to the index >_>. Something is wrong with the setup. Any ideas?

My initial impression leaves me thinking that you can't use mod_rewrite/the RewriteEngine or that it is broken for some reason. Another poster had a similar problem, see my previous post on the subject (I have no idea if the file I attached works anymore as I no longer am part of running a server): http://forums.alliedmods.net/showthr...921#post939921

[DrWagstaff]

I'm getting the following error in the logs:

L 05/15/2010 - 019:00: [TF2_Stats.smx] SQL Error: Table 'wagtf2stats.founditems' doesn't exist

Also, the items and map features don't work on the web ranking. See for yourself if you're curious as to what I mean. http://stats.wagstaffsarena.com

EDIT: Also getting a table Map doesn't exist. I think since I imported my data from SQLite to mysql i'm missing some tables or something. Can anyone devise me a query that would fix these errors?

L 05/15/2010 - 019:00: [TF2_Stats.smx] SQL Error: Table 'wagtf2stats.founditems' doesn't exist
L 05/15/2010 - 019:15: [TF2_Stats.smx] SQL Error: Table 'wagtf2stats.Map' doesn't exist

I'd be really appreciative. =)

[DarthNinja]

Try checking your versions.

[DrWagstaff]

I updated to the latest version of the plugin. I really don't think that's it. It's looking for a section in my mysql db that isn't there, but I don't know mysql so I cant cook up a query to add a spot for map ranking and item found info

[DarthNinja]

Originally Posted by DrWagstaff I updated to the latest version of the plugin. I really don't think that's it. It's looking for a section in my mysql db that isn't there, but I don't know mysql so I cant cook up a query to add a spot for map ranking and item found info

http://stats.wagstaffsarena.com/version.php





Also, how did you go about importing data?
Did you let the plugin create the database structure first?

[Sobuno]

I took the time to make a version of the web ranking system in which you can enable or disable the use of mod_rewrite/the RewriteEngine.

It has not been tested thoroughly, but I think it should work.

To disable the use of mod_rewrite/RewriteEngine, go to your settings.php file and change the variable named $userewrite from 1 to 0, upload the file and you are done.

DarthNinja, feel free to use the code if you want to, all the URLS are stored at the bottom of the settings.php file.

Oh, and here it is in effect: http://orangex.sobuno.dk/tf2stats3/index.php, no data though as I have no server anymore, but you can see that the links are working (and that they aren't "pretty")

[DrWagstaff]

Originally Posted by DarthNinja http://stats.wagstaffsarena.com/version.php Also, how did you go about importing data? Did you let the plugin create the database structure first?

I was using a version someone else made because my mod rewrite is broken. The normal one didn't work for me at all. I imported my data after the plugin made the structure, yes. I did import it from SQlite though, so who knows if it did something.

[DrWagstaff]

Originally Posted by Sobuno I took the time to make a version of the web ranking system in which you can enable or disable the use of mod_rewrite/the RewriteEngine. It has not been tested thoroughly, but I think it should work. To disable the use of mod_rewrite/RewriteEngine, go to your settings.php file and change the variable named $userewrite from 1 to 0, upload the file and you are done. DarthNinja, feel free to use the code if you want to, all the URLS are stored at the bottom of the settings.php file. Oh, and here it is in effect: http://orangex.sobuno.dk/tf2stats3/index.php, no data though as I have no server anymore, but you can see that the links are working (and that they aren't "pretty")

You're a gentlemanne and a scholar. Many thanks. For anyone reading, I could still use that mysql query to add those tables I"m missing

[Sobuno]

Originally Posted by DrWagstaff You're a gentlemanne and a scholar. Many thanks. For anyone reading, I could still use that mysql query to add those tables I"m missing

The following piece of SQL, when executed, will add any of the 4 required tables missing (It will not alter any table you already have). Taken from the plugin code so it should contain exactly what is needed.

You need to use phpMyAdmin or similar to run it.

CREATE TABLE IF NOT EXISTS `Player` (
`STEAMID` varchar(25) NOT NULL,
`NAME` varchar(30) NOT NULL,
`POINTS` int(25) NOT NULL default '0',
`PLAYTIME` int(25) NOT NULL default '0',
`LASTONTIME` int(25) NOT NULL default '0',
`KILLS` int(11) NOT NULL default '0',
`Death` int(11) NOT NULL default '0',
`KillAssist` int(11) NOT NULL default '0',
`KillAssistMedic` int(11) NOT NULL default '0',
`BuildSentrygun` int(11) NOT NULL default '0',
`BuildDispenser` int(11) NOT NULL default '0',
`HeadshotKill` int(11) NOT NULL default '0',
`KOSentrygun` int(11) NOT NULL default '0',
`Domination` int(11) NOT NULL default '0',
`Overcharge` int(11) NOT NULL default '0',
`KOSapper` int(11) NOT NULL default '0',
`BOTeleporterentrace` int(11) NOT NULL default '0',
`KODispenser` int(11) NOT NULL default '0',
`BOTeleporterExit` int(11) NOT NULL default '0',
`CPBlocked` int(11) NOT NULL default '0',
`CPCaptured` int(11) NOT NULL default '0',
`FileCaptured` int(11) NOT NULL default '0',
`ADCaptured` int(11) NOT NULL default '0',
`KOTeleporterExit` int(11) NOT NULL default '0',
`KOTeleporterEntrace` int(11) NOT NULL default '0',
`BOSapper` int(11) NOT NULL default '0',
`Revenge` int(11) NOT NULL default '0',
`KW_Axe` int(11) NOT NULL default '0',
`KW_Bnsw` int(11) NOT NULL default '0',
`KW_Bt` int(11) NOT NULL default '0',
`KW_Bttl` int(11) NOT NULL default '0',
`KW_Cg` int(11) NOT NULL default '0',
`KW_Fsts` int(11) NOT NULL default '0',
`KW_Ft` int(11) NOT NULL default '0',
`KW_Gl` int(11) NOT NULL default '0',
`KW_Kn` int(11) NOT NULL default '0',
`KW_Mctte` int(11) NOT NULL default '0',
`KW_Mgn` int(11) NOT NULL default '0',
`KW_Ndl` int(11) NOT NULL default '0',
`KW_Pistl` int(11) NOT NULL default '0',
`KW_Rkt` int(11) NOT NULL default '0',
`KW_Sg` int(11) NOT NULL default '0',
`KW_Sky` int(11) NOT NULL default '0',
`KW_Smg` int(11) NOT NULL default '0',
`KW_Spr` int(11) NOT NULL default '0',
`KW_Stgn` int(11) NOT NULL default '0',
`KW_Wrnc` int(11) NOT NULL default '0',
`KW_Sntry` int(11) NOT NULL default '0',
`KW_Shvl` int(11) NOT NULL default '0',
`KW_Ubersaw` int(11) NOT NULL default '0',
`KW_Flaregun` int(11) NOT NULL default '0',
`KW_Axtinguisher` int(11) NOT NULL default '0',
`KW_taunt_pyro` int(11) NOT NULL default '0',
`KW_taunt_heavy` int(11) NOT NULL default '0',
`KW_gloves` int(11) NOT NULL default '0',
`KW_backburner` int(11) NOT NULL default '0',
`KW_natascha` int(11) NOT NULL default '0',
`KW_blutsauger` int(11) NOT NULL default '0',
`KW_deflect_rocket` int(11) NOT NULL default '0',
`KW_deflect_promode` int(11) NOT NULL default '0',
`KW_deflect_sticky` int(11) NOT NULL default '0',
`KW_world` int(11) NOT NULL default '0',
`KW_bat_wood` int(11) NOT NULL default '0',
`player_stunned` int(11) NOT NULL default '0',
`drunk_bonk` int(11) NOT NULL default '0',
`player_stealsandvich` int(11) NOT NULL default '0',
`chat_status` int(11) NOT NULL default '0',
`KW_tf_projectile_arrow` int(11) NOT NULL default '0',
`KW_ambassador` int(11) NOT NULL default '0',
`KW_taunt_sniper` int(11) NOT NULL default '0',
`KW_taunt_spy` int(11) NOT NULL default '0',
`player_extinguished` int(11) NOT NULL default '0',
`player_teleported` int(11) NOT NULL default '0',
`player_feigndeath` int(11) NOT NULL default '0',
`KW_force_a_nature` int(11) NOT NULL default '0',
`KW_sandman` int(11) NOT NULL default '0',
`K_backstab` int(11) NOT NULL default '0',
`KW_compound_bow` int(11) NOT NULL default '0',
`KW_taunt_scout` int(11) NOT NULL default '0',
`KW_deflect_arrow` int(11) NOT NULL default '0',
`KW_rocketlauncher_directhit` int(11) NOT NULL default '0',
`KW_telefrag` int(11) NOT NULL default '0',
`KW_deflect_flare` int(11) NOT NULL default '0',
`KW_taunt_soldier` int(11) NOT NULL default '0',
`KW_pickaxe` int(11) NOT NULL default '0',
`KW_demoshield` int(11) NOT NULL default '0',
`KW_sword` int(11) NOT NULL default '0',
`KW_taunt_demoman` int(11) NOT NULL default '0',
`KW_sticky_resistance` int(11) NOT NULL default '0',
`KW_jar` int(11) NOT NULL default '0',
PRIMARY KEY  (`STEAMID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `killlog` (    
`attacker` VARCHAR( 20 ) NOT NULL ,
`victim` VARCHAR( 20 ) NOT NULL ,
`assister` VARCHAR( 20 ) NOT NULL ,
`weapon` VARCHAR( 25 ) NOT NULL ,
`killtime` INT( 11 ) NOT NULL ,
`dominated` BOOL NOT NULL ,
`assister_dominated` BOOL NOT NULL ,
`revenge` BOOL NOT NULL ,
`assister_revenge` BOOL NOT NULL
) ENGINE = MYISAM ;


CREATE TABLE IF NOT EXISTS `Map`
 (`NAME` varchar(30) NOT NULL,
  `POINTS` int(25) NOT NULL,`PLAYTIME` int(25) NOT NULL, `LASTONTIME` int(25) NOT NULL ,
 `KILLS` int(11) NOT NULL , `Death` int(11) NOT NULL , `KillAssist` int(11) NOT NULL ,
 `KillAssistMedic` int(11) NOT NULL , `BuildSentrygun` int(11) NOT NULL ,
 `BuildDispenser` int(11) NOT NULL , `HeadshotKill` int(11) NOT NULL ,
 `KOSentrygun` int(11) NOT NULL , `Domination` int(11) NOT NULL , `Overcharge` int(11) NOT NULL ,
 `KOSapper` int(11) NOT NULL , `BOTeleporterentrace` int(11) NOT NULL ,
 `KODispenser` int(11) NOT NULL , `BOTeleporterExit` int(11) NOT NULL ,
 `CPBlocked` int(11) NOT NULL , `Captured` int(11) NOT NULL , `KOTeleporterExit` int(11) NOT NULL ,
 `KOTeleporterEntrace` int(11) NOT NULL , `BOSapper` int(11) NOT NULL , `Revenge` int(11) NOT NULL ,
 `KW_Axe` int(11) NOT NULL , `KW_Bnsw` int(11) NOT NULL , `KW_Bt` int(11) NOT NULL , `KW_Bttl` int(11) NOT NULL ,
 `KW_Cg` int(11) NOT NULL , `KW_Fsts` int(11) NOT NULL , `KW_Ft` int(11) NOT NULL , `KW_Gl` int(11) NOT NULL ,
 `KW_Kn` int(11) NOT NULL , `KW_Mctte` int(11) NOT NULL , `KW_Mgn` int(11) NOT NULL , `KW_Ndl` int(11) NOT NULL ,
 `KW_Pistl` int(11) NOT NULL , `KW_Rkt` int(11) NOT NULL , `KW_Sg` int(11) NOT NULL , `KW_Sky` int(11) NOT NULL ,
 `KW_Smg` int(11) NOT NULL , `KW_Spr` int(11) NOT NULL , `KW_Stgn` int(11) NOT NULL , `KW_Wrnc` int(11) NOT NULL ,
 `KW_Sntry` int(11) NOT NULL , `KW_Shvl` int(11) NOT NULL , PRIMARY KEY (`NAME`));

CREATE TABLE IF NOT EXISTS `founditems`
 (`ID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`STEAMID` VARCHAR( 25 ) NOT NULL DEFAULT '0',
`ACTUALTIME` INT NOT NULL DEFAULT '0',
`ITEM` VARCHAR( 50 ) NOT NULL DEFAULT '0'
) ENGINE = MYISAM ;