[SloppyJoe]

Originally Posted by Cloman Good to hear you found it and have it to work. strange that that was the problem. I have changed it in the plugin as you mentioned. Can you share what mysql version you have etc ? As i have mysql version 5.7 and player database is in lower case and this problem is not occuring with me. Seems some option in mysql maybe makes things case sensitive.

Here is the version the host uses:
MySQL Version 5.5.48-37.8
PHP Version 5.4.45

Thanks again for your help. Love the plugin.

[Cloman]

While searching google i found some interesting stuff.
Seems case handling with mysql in unix and windows and OSX are completely different
in unix mysql its default case sensitive and in windows its totally not and for OSX its totally weird and wouldn't surprise me if its also different in every mysql version .
For reference if you are curious about this to see
ref: http://dev.mysql.com/doc/refman/5.7/...nsitivity.html
and check option "lower_case_table_names"
ref: http://dev.mysql.com/doc/refman/5.7/...se_table_names

[vcab100]

Sorry if this has been re-hashed a million times. I have the plugin working and logging data to MySql. I am trying to install the web interface on IIS 7 and just get a blank white page. I have made sure "short tags are turned on" as I was able to use phpmyadmin after turning it on. So I know PHP is working ok.

Has anyone been able to get it working on IIS?

Thanks for any help.


My servers: http://vcab.hopto.org/

Tf2stats: http://vcab.hopto.org/tf2stats

--------------------------------------------------------

EDIT: I installed the web interface on my hosting service (Apache) and it works fine. I had to open port 3306 on my game server which I prefer not to do.

http://s264566891.onlinehome.us/Gibb...tats/index.php

How big of a security risk is it opening port 3306?

--------------------------------------------------------

Also where can I change the color of the text? I have a hard time seeing the orange font.

Thanks for any help.

--------------------------------------------------------

--------------------------------------------------------

I am running this version:


Updated TF2Stats to 9.3.3

- Fix Player database for case sensitive database engines/ configuration.
Attached Files Get Plugin or Get Source (TF2_Stats.sp - 6 views - 389.8 KB) TF2_Ranking_and_Item_Logger_v9.3.3.zip (831.5 KB, 3 views) tf2-stats.cfg (19.7 KB, 3 views)

[Cloman]

Originally Posted by vcab100 Sorry if this has been re-hashed a million times. I have the plugin working and logging data to MySql. I am trying to install the web interface on IIS 7 and just get a blank white page. I have made sure "short tags are turned on" as I was able to use phpmyadmin after turning it on. So I know PHP is working ok. Has anyone been able to get it working on IIS? Thanks for any help. My servers: http://vcab.hopto.org/ Tf2stats: http://vcab.hopto.org/tf2stats -------------------------------------------------------- EDIT: I installed the web interface on my hosting service (Apache) and it works fine. I had to open port 3306 on my game server which I prefer not to do. http://s264566891.onlinehome.us/Gibb...tats/index.php How big of a security risk is it opening port 3306? -------------------------------------------------------- Also where can I change the color of the text? I have a hard time seeing the orange font. Thanks for any help. --------------------------------------------------------

3306 is used by your mysql database.
Is your game server and database and webserver on the same box ?
if so you should not need to open 3306 then you just need to make the correct configuration to your database.

[vcab100]

Originally Posted by Cloman 3306 is used by your mysql database. Is your game server and database and webserver on the same box ? if so you should not need to open 3306 then you just need to make the correct configuration to your database.

It is ontwo different boxes. I would prefer to run it all on one box (windows) but I cant get the web interface to run on IIS7.

[Cloman]

Originally Posted by vcab100 It is ontwo different boxes. I would prefer to run it all on one box (windows) but I cant get the web interface to run on IIS7.

where do you open the 3306 in the firewall ?
on the router or software firewall or do you have a hardware firewall ?
are they on the same network or both on external ?

[vcab100]

Originally Posted by Cloman where do you open the 3306 in the firewall ? on the router or software firewall or do you have a hardware firewall ? are they on the same network or both on external ?

I have windows server at this location running my game server.

I also have web hosting via 1and1 and that is where i have access to apache to run the tf2stats web interface.

I had to forward 3306 on my router here and allow it on the windows firewall.

If I could run the tf2stats web interface on this windows server IIS the port would not be an issue.

I may just remove IIS and install apache anyway since most thing i run use mysql and php.

[Cloman]

Originally Posted by vcab100 I have windows server at this location running my game server. I also have web hosting via 1and1 and that is where i have access to apache to run the tf2stats web interface. I had to forward 3306 on my router here and allow it on the windows firewall. If I could run the tf2stats web interface on this windows server IIS the port would not be an issue. I may just remove IIS and install apache anyway since most thing i run use mysql and php.

i am not very experienced with IIS also regarding running it with php as its a huge hassle for me.
One of the easyst way is just to disable IIS from running and install WAMP or XAMPP its a all in one package(apache, PHP, MYSQL). as i have installed mysql seperately i just diasabled mysql in WAMP to startup. till now never had a problem.
Here you have the link if you like to have a snoop: http://www.wampserver.com/en/

[SyN3rgY]

During the game, there are times bugs often look through the console on the server.

[TF2 Stats Debug] Weapon sandman

[DEBUG]   INSERT INTO `killlog` (`attacker` ,`victim` ,`assister` ,`weapon` ,`killtime` ,`dominated` ,`assister_dominated` ,`revenge` ,`assister_revenge`) VALUES ('STEAM_0:0:XXXXXXX', 'STEAM_0:1:XXXXXXXXX', '', 'sandman', '1469967775', '1', '0', '0', '0');
No caption found for 'spy.painsevere05'
F

[Cloman]

Originally Posted by SyN3rgY During the game, there are times bugs often look through the console on the server. [TF2 Stats Debug] Weapon sandman [DEBUG] INSERT INTO `killlog` (`attacker` ,`victim` ,`assister` ,`weapon` ,`killtime` ,`dominated` ,`assister_dominated` ,`revenge` ,`assister_revenge`) VALUES ('STEAM_0:0:XXXXXXX', 'STEAM_0:1:XXXXXXXXX', '', 'sandman', '1469967775', '1', '0', '0', '0'); No caption found for 'spy.painsevere05' F

Hi,
Wat version do you use of tf2stats ?
What database do you use (Please also mention version if possible)?