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

Snowie · 08-26-2015 , 13:21 Re: [TF2 Stats] With Web Ranking and Item Logger [v9.1.0]

Quote:

Originally Posted by Cloman

just open:
/home/tftermin/public_html/tf2stats/inc/dbconnect.php
or
/home/tftermin/public_html/tf2stats/inc/config.php
Where you defined your database and database account and set your HOST variable to localhost or 127.0.0.1 as i assume your database is on the same system as your webserver.

errrm this is what I see inside the dbconnect.php

PHP Code:


			
<?php

include('settings.php');

$version = "7.6.1";

mysql_connect($mysql_server, $mysql_user, $mysql_password);

mysql_query("SET NAMES 'UTF8'");

mysql_select_db($mysql_database);  

date_default_timezone_set('UTC');

?>

Cloman · 08-26-2015 , 13:36 Re: [TF2 Stats] With Web Ranking and Item Logger [v9.1.0]

Quote:

Originally Posted by Snowie

errrm this is what I see inside the dbconnect.php

PHP Code:


			
<?php
include('settings.php');
$version = "7.6.1";
mysql_connect($mysql_server, $mysql_user, $mysql_password);
mysql_query("SET NAMES 'UTF8'");
mysql_select_db($mysql_database);  
date_default_timezone_set('UTC');
?>

yes.. then you need to go and find the settings.php and make sure it contains the correct setting for the database. its probably in the same directory as dbconnect.php.

Snowie · *Last edited by Snowie; 08-31-2015 at 01:22.*

Quote:

Originally Posted by Cloman

yes.. then you need to go and find the settings.php and make sure it contains the correct setting for the database. its probably in the same directory as dbconnect.php.

thanks for your help dude. I have removed most of the errors. However 1 error line is still here

PHP Code:


			
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/tftermin/public_html/tf2stats/index.php on line 20

I also get similar issues when loading other pages such as top10

PHP Code:


			
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/tftermin/public_html/tf2stats/top10.php on line 83

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/tftermin/public_html/tf2stats/top10.php on line 196

I looked further into this and it seems the line causing the error on some (haven't looked at all) .php files are the same.

PHP Code:


			
while ($adr = mysql_fetch_array($ergebnis))

Cloman · 08-31-2015 , 03:23 Re: [TF2 Stats] With Web Ranking and Item Logger [v9.1.0]

Quote:

Originally Posted by Snowie

thanks for your help dude. I have removed most of the errors. However 1 error line is still here

PHP Code:


			
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/tftermin/public_html/tf2stats/index.php on line 20

I also get similar issues when loading other pages such as top10

PHP Code:


			
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/tftermin/public_html/tf2stats/top10.php on line 83

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/tftermin/public_html/tf2stats/top10.php on line 196

I looked further into this and it seems the line causing the error on some (haven't looked at all) .php files are the same.

PHP Code:


			
while ($adr = mysql_fetch_array($ergebnis))

Seems there is a error in the select query.
and its returning a false boolean back to your result.
Add something like this in the website above this function mysql_fetch_array($ergebnis) to get a better error overview:
if (false === $ergebnis) { echo mysql_error(); }

Cloman · 09-19-2015 , 07:51 Re: [TF2 Stats] With Web Ranking and Item Logger [v9.1.0]

Hi,
I have updated the plugin again.

Added:
- Die point message that pendrive148 has added cvar: rank_chatdiepoints (see also the cfg)
- Changeable Charset for the database cvar: rank_DBCharSet (see also cfg. Leave default its still WIP. for the people who have mysql and already changed theyr database stuff to UTF8MB4 need to change it first or if you have mysql and start with a new database use UTF8MB4.)
- Preparation for dynamic database change for mysql.
- Added some cvars to cfg for weapons that have not been added yet.

BugFix:
- Disabled point harvesting if the map respawns for example dispenser (some trade maps have them example mariokart maps)
- removed BOT receives still points for extinguish players.
- Separated sqllite with other type database table creation.

Other:
- made some changes to the code but not noticible.

rtil · *Last edited by rtil; 09-20-2015 at 05:01.*

Quote:

Originally Posted by Cloman

Hi,
I have updated the plugin again.

Added:
- Die point message that pendrive148 has added cvar: rank_chatdiepoints (see also the cfg)
- Changeable Charset for the database cvar: rank_DBCharSet (see also cfg. Leave default its still WIP. for the people who have mysql and already changed theyr database stuff to UTF8MB4 need to change it first or if you have mysql and start with a new database use UTF8MB4.)
- Preparation for dynamic database change for mysql.
- Added some cvars to cfg for weapons that have not been added yet.

BugFix:
- Disabled point harvesting if the map respawns for example dispenser (some trade maps have them example mariokart maps)
- removed BOT receives still points for extinguish players.
- Separated sqllite with other type database table creation.

Other:
- made some changes to the code but not noticible.

thanks for the updates! are the added items compatible with the webserver side?

also this is probably a longshot but one feature i'd love to see added is ELO ranking.

Cloman · 09-20-2015 , 05:20 Re: [TF2 Stats] With Web Ranking and Item Logger [v9.1.0]

Quote:

Originally Posted by rtil

thanks for the updates! are the added items compatible with the webserver side?

also this is probably a longshot but one feature i'd love to see added is ELO ranking.

Yes they are compatible with the website no need for any changes there.

ELO ranking looks abit like the command in chat "session" and "kd" of the tf2 stats.

Pala4 · 09-21-2015 , 03:27 Re: [TF2 Stats] With Web Ranking and Item Logger [v9.1.0]

Quote:

Originally Posted by Cloman

Hi,
I have updated the plugin again.

Added:
- Die point message that pendrive148 has added cvar: rank_chatdiepoints (see also the cfg)
- Changeable Charset for the database cvar: rank_DBCharSet (see also cfg. Leave default its still WIP. for the people who have mysql and already changed theyr database stuff to UTF8MB4 need to change it first or if you have mysql and start with a new database use UTF8MB4.)
- Preparation for dynamic database change for mysql.
- Added some cvars to cfg for weapons that have not been added yet.

BugFix:
- Disabled point harvesting if the map respawns for example dispenser (some trade maps have them example mariokart maps)
- removed BOT receives still points for extinguish players.
- Separated sqllite with other type database table creation.

Other:
- made some changes to the code but not noticible.

The server crashes without error.

Cloman · 09-21-2015 , 05:25 Re: [TF2 Stats] With Web Ranking and Item Logger [v9.1.0]

Quote:

Originally Posted by Pala4

The server crashes without error.

When you remove the tf2stats plugin all is working ?
If the server still crashes i think you need to go to other forum part.

There is always a error. Some suggestions to find the error.
- log console output to file.
- check "tf\addons\sourcemod\logs\".

Pala4 · 09-21-2015 , 06:51 Re: [TF2 Stats] With Web Ranking and Item Logger [v9.1.0]

Quote:

Originally Posted by Cloman

When you remove the tf2stats plugin all is working ?
If the server still crashes i think you need to go to other forum part.

There is always a error. Some suggestions to find the error.
- log console output to file.
- check "tf\addons\sourcemod\logs\".

When I remove the plugin then statistics server is running normally. There are no errors.