[BF4] Stats webpage for XpKiller's Stats Logger Plugin

[ImportBot]

Originally Posted by Grovax*:

 

You have to add the weapons to the constants.php weapon name array as well. Just adding the weapon image won't cause it to automatically work.

https://github.com/tyger07/BF4-Serve.constants.php

thanks

[ImportBot]

Originally Posted by Grovax*:

 

here is my updated constants.php with new maps and weapons (+ new pictures)

 

bf4-stats-new-weapons-and-maps.zip

[ImportBot]

Originally Posted by SmackDown*:

 

I have been using this program for over a year now and been very happy with it.

 

However for some time now, the images for graphs, banners, and maps are not showing up. The stats for these images are loading on the pages, but the graphs, banners, and maps all have little X's in the upper left hand corner.

 

I have used different browsers and all show the same issue. If try to click on empty box where the graph or map photo would be, nothing happens.

 

Any ideas or suggestions. I have searched this forum, and found similar issues but not sure if they were able to solve it or not.

 

Thanks for you help.

[ImportBot]

Originally Posted by ty_ger07*:

 

A link to your stats page would help me understand the problem and find errors.

 

Often the issue is a security setting in your web server's php configuration which does not allow the php script to obtain read or write access to other files in the file system. Or, sometimes it is a web server security setting which does not allow htaccess changes. If either one of these are the cause, it is not always something you have the ability to change/correct depending on your web server host's policies.

[ImportBot]

Originally Posted by Level*:

 

Sorry wrong thread

 

myrcon.net/...chat-guid-stats-and-mapstats-logger#entry46278

[ImportBot]

Originally Posted by Porthos1973*:

 

I recently did a fresh install of this for a new server. The leaderboard is not updating correctly but if you click on a player you get accurate info then. For example is shows me with no score, kills, etc but once you click my name it does show my stats. Only a few rounds have been played on the server so not much data there yet. http://www.mowgaming.com/serverstats...p_p=home&sid=1

 

To make sure PRoCon Chat, GUID, Stats and Map Logger was working correctly I also installed millhouses stats page. http://www.mowgaming.com/serverstats2/

 

When you go to players on his, it does show correctly so Know the logger is working correctly. I prefer the layout of your stats page but need to get it working correctly. Any ideas?

[ImportBot]

Originally Posted by ty_ger07*:

 

That is normal. The leaderboard and many other things are on a 12 hour cache update cycle. You will notice the inconsistency between the cache and real-time less and less as the server stats mature. This has been asked many times previously. If you want to know why it is cached or how to change the cache length, please look through the previous pages. I don't think you would need to go back more than 10 pages.

 

Edit:

Here is probably the most useful recent explaination from me of how to change the cache length:

myrcon.net/...stats-webpage-for-xpkillers-stats-logger-plugin#entry48278

[ImportBot]

Originally Posted by mambochambo*:

 

hello Tyger-

is there any chance to ammend the Settings to get instead of the weekly top 20, also the monthly top 20, because i need that info,

we are giving top 20 monthly players vip slots, is there any method how i can see that?

Best Regards

[ImportBot]

Originally Posted by ty_ger07*:

 

hello Tyger-

is there any chance to ammend the Settings to get instead of the weekly top 20, also the monthly top 20, because i need that info,

we are giving top 20 monthly players vip slots, is there any method how i can see that?

Best Regards

In common/leaders/sessions-tab.php, you could change the period of time to a month instead of a week.

 

That would be the easiest way without needing to create and add a new tab.

 

Code:

if(!empty($ServerID))
{
	// get the info from the db 
	$Players_q  = @mysqli_query($BF4stats,"
		SELECT tpd.`PlayerID`, tpd.`SoldierName`, SUM(tss.`Score`) AS Score, SUM(tss.`Kills`) AS Kills, (SUM(tss.`Kills`)/SUM(tss.`Deaths`)) AS KDR, (SUM(tss.`Headshots`)/SUM(tss.`Kills`)) AS HSR
		FROM `tbl_sessions` tss
		INNER JOIN `tbl_server_player` tsp ON tss.`StatsID` = tsp.`StatsID`
		INNER JOIN `tbl_playerdata` tpd ON tsp.`PlayerID` = tpd.`PlayerID`
		WHERE tsp.`ServerID` = {$ServerID}
		AND tss.`Starttime` BETWEEN CURDATE() - INTERVAL 7 DAY AND CURDATE()
		AND tpd.`GameID` = {$GameID}
		GROUP BY tpd.`PlayerID`
		ORDER BY Score DESC, tpd.`SoldierName` ASC
		LIMIT 0, 20
	");
}
// or else this is a global stats page
else
{
	// get the info from the db 
	$Players_q  = @mysqli_query($BF4stats,"
		SELECT tpd.`PlayerID`, tpd.`SoldierName`, SUM(tss.`Score`) AS Score, SUM(tss.`Kills`) AS Kills, (SUM(tss.`Kills`)/SUM(tss.`Deaths`)) AS KDR, (SUM(tss.`Headshots`)/SUM(tss.`Kills`)) AS HSR
		FROM `tbl_sessions` tss
		INNER JOIN `tbl_server_player` tsp ON tss.`StatsID` = tsp.`StatsID`
		INNER JOIN `tbl_playerdata` tpd ON tsp.`PlayerID` = tpd.`PlayerID`
		WHERE tss.`Starttime` BETWEEN CURDATE() - INTERVAL 7 DAY AND CURDATE()
		AND tpd.`GameID` = {$GameID}
		AND tsp.`ServerID` IN ({$valid_ids})
		GROUP BY tpd.`PlayerID`
		ORDER BY Score DESC, tpd.`SoldierName` ASC
		LIMIT 0, 20
	");
}

In two places, change:

 

WHERE tss.`Starttime` BETWEEN CURDATE() - INTERVAL 7 DAY AND CURDATE()

 

to:

 

WHERE tss.`Starttime` BETWEEN CURDATE() - INTERVAL 30 DAY AND CURDATE()

 

https://github.com/tyger07/BF4-Serve...ssions-tab.php

 

In leaders.php, you would also want to change the text from "week" to "month".

 

Code:

<li><a href="./common/leaders/sessions-tab.php_sid=' . $ServerID . '&gid=' . $GameID . '">Top 20 Players This Month</a></li>

[ImportBot]

Originally Posted by Grovax*:

 

@ty_ger07: send u 2 commits at github

[ImportBot]

Originally Posted by mambochambo*:

 

Thank you very much! I really appreciate that you take your time to help me out in this case-

i also ammend the settings for the top 40 players- bec. alot of our Clanmembers are in the top 20, and i want to give the top 20 nonclanmembers vip for one month... It worked! again, Thx!!

Best Regards

[ImportBot]

Originally Posted by ty_ger07*:

 

@ty_ger07: send u 2 commits at github

I created a pull request to pull your changes into my master.

[ImportBot]

Originally Posted by bdevroey*:

 

Some on knows i need to connect the plugins from several server to 1 database? or put them all in separated databases?

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Some on knows i need to connect the plugins from several server to 1 database? or put them all in separated databases?

All on the same database.

[ImportBot]

Originally Posted by bdevroey*:

 

i reconnected, al servers to one new data base, only one server is listing on de stats webpage...

Someone knows if i am doing something wrong?

 

Servers procon frostbite:

https://gyazo.com/f690e3a6754bc7f9fccefe63357cfc2c

 

phpmyadmin servers:

https://gyazo.com/8235f6b4020f9cf70e4451c12659fdf7

 

 

 

Thanks in advance.

 

Kind regards

[ImportBot]

Originally Posted by bdevroey*:

 

i reconnected, al servers to one new data base, only one server is listing on de stats webpage...

Someone knows if i am doing something wrong?

 

Servers procon frostbite:

https://gyazo.com/f690e3a6754bc7f9fccefe63357cfc2c

 

phpmyadmin servers:

https://gyazo.com/8235f6b4020f9cf70e4451c12659fdf7

 

 

 

Thanks in advance.

 

Kind regards

its working now... thanks

[ImportBot]

Originally Posted by bdevroey*:

 

How to Remove the Google block?

[ImportBot]

Originally Posted by ty_ger07*:

 

I have no idea what you are talking about. What is a Google block? You mean the bot blocker?

 

If so, in Index.php, change:

 

Code:

// detect (and block) common bots
if(stripos($useragent, 'search') === false && stripos($useragent, 'seek') === false && stripos($useragent, 'fetch') === false && stripos($useragent, 'archiv') === false && stripos($useragent, 'spide') === false && stripos($useragent, 'validat') === false && stripos($useragent, 'analyze') === false && stripos($useragent, 'crawl') === false && stripos($useragent, 'robot') === false && stripos($useragent, 'track') === false && stripos($useragent, 'generat') === false && stripos($useragent, 'google') === false && stripos($useragent, 'bing') === false && stripos($useragent, 'msnbot') === false && stripos($useragent, 'yahoo') === false && stripos($useragent, 'facebook') === false && stripos($useragent, 'yandex') === false && stripos($useragent, 'alexa') === false)
{

to:

 

Code:

// detect (and block) common bots
if(stripos($useragent, 'search') === false && stripos($useragent, 'seek') === false && stripos($useragent, 'fetch') === false && stripos($useragent, 'archiv') === false && stripos($useragent, 'spide') === false && stripos($useragent, 'validat') === false && stripos($useragent, 'analyze') === false && stripos($useragent, 'crawl') === false && stripos($useragent, 'robot') === false && stripos($useragent, 'track') === false && stripos($useragent, 'generat') === false && stripos($useragent, 'bing') === false && stripos($useragent, 'msnbot') === false && stripos($useragent, 'yahoo') === false && stripos($useragent, 'facebook') === false && stripos($useragent, 'yandex') === false && stripos($useragent, 'alexa') === false)
{

[ImportBot]

Originally Posted by bdevroey*:

 

I have no idea what you are talking about. What is a Google block? You mean the bot blocker?

 

If so, in Index.php, change:

 

Code:

// detect (and block) common bots
if(stripos($useragent, 'search') === false && stripos($useragent, 'seek') === false && stripos($useragent, 'fetch') === false && stripos($useragent, 'archiv') === false && stripos($useragent, 'spide') === false && stripos($useragent, 'validat') === false && stripos($useragent, 'analyze') === false && stripos($useragent, 'crawl') === false && stripos($useragent, 'robot') === false && stripos($useragent, 'track') === false && stripos($useragent, 'generat') === false && stripos($useragent, 'google') === false && stripos($useragent, 'bing') === false && stripos($useragent, 'msnbot') === false && stripos($useragent, 'yahoo') === false && stripos($useragent, 'facebook') === false && stripos($useragent, 'yandex') === false && stripos($useragent, 'alexa') === false)
{

to:

 

Code:

// detect (and block) common bots
if(stripos($useragent, 'search') === false && stripos($useragent, 'seek') === false && stripos($useragent, 'fetch') === false && stripos($useragent, 'archiv') === false && stripos($useragent, 'spide') === false && stripos($useragent, 'validat') === false && stripos($useragent, 'analyze') === false && stripos($useragent, 'crawl') === false && stripos($useragent, 'robot') === false && stripos($useragent, 'track') === false && stripos($useragent, 'generat') === false && stripos($useragent, 'bing') === false && stripos($useragent, 'msnbot') === false && stripos($useragent, 'yahoo') === false && stripos($useragent, 'facebook') === false && stripos($useragent, 'yandex') === false && stripos($useragent, 'alexa') === false)
{

Thank you for the reply

 

Is it this code to allow all?

// detect (and block) common bots

if(stripos($useragent, 'search') === false)

{

[ImportBot]

Originally Posted by ty_ger07*:

 

Thank you for the reply

 

Is it this code to allow all?

// detect (and block) common bots

if(stripos($useragent, 'search') === false)

{

Replacement with :

Code:

if(1)
{

would be the easiest way to disable the bot blocker.

[ImportBot]

Originally Posted by leandro-motta*:

 

Hello tyger 07 would be possible to add or put a donation link on the page if you know could pass me the way to add.

Grateful for the attention;

 

Attached Files:

• print.jpg

[ImportBot]

Originally Posted by ty_ger07*:

 

Hello tyger 07 would be possible to add or put a donation link on the page if you know could pass me the way to add.

Grateful for the attention;

The HTML for that menu is in common/menu/navigation-menu.php.

 

https://github.com/tyger07/BF4-Serve...ation-menu.php

[ImportBot]

Originally Posted by leandro-motta*:

 

The HTML for that menu is in common/menu/navigation-menu.php.

 

https://github.com/tyger07/BF4-Serve...ation-menu.php

Thank you ty_ger07;

[ImportBot]

Originally Posted by thunderje*:

 

hi guys

im getting an error trying to load webpage,could anyone look at my config php here and see what im doing wrong, a screenshot is included of what im getting on my page

 

screenshot==>> http://prntscr.com/afec5e

[ImportBot]

Originally Posted by Chilace*:

 

hi guys

im getting an error trying to load webpage,could anyone look at my config php here and see what im doing wrong, a screenshot is included of what im getting on my page

 

screenshot==>> http://prntscr.com/afec5e

You messed up config.php:

 

// DATABASE INFORMATION

DEFINE('HOST', 'localhost'); // database host address

DEFINE('PORT', '3306'); // database port - default is 3306

DEFINE('NAME', 'xxx'); // database name

DEFINE('USER', 'xxx'); // database user name - sometimes the same as the database name

DEFINE('PASS', 'xxx'); // database password

 

Only that reds editable.

[ImportBot]

Originally Posted by Dete96*:

 

Hi! I just tried to install it on my webpage. But I always get this error:

 

Error: Connection timed out

 

I'm quite sure that I put in the right information in the config.php. Does anyone have an idea how to fix this problem?

 

Thank you in advance

Dete96

 

Edit: Found the problem. My Webhoster denies external Database access via port 3306. Found another one, now it works great!!!

[ImportBot]

Originally Posted by ty_ger07*:

 

I am glad you figured it out. I read your post on the 15th and was completely stumped from my end.

[ImportBot]

Originally Posted by Gijzijtdood*:

 

Hey Tyger,

 

What's your query for finding the kills with the M2 SLAM mine?

 

ScreenShot088.jpg

 

If i query for the U_SLAM or friendlyname SLAM i get a different result than on your statspage.

And yours is the correct one

 

cheers

[ImportBot]

Originally Posted by ty_ger07*:

 

I don't believe that I have any SLAM kills in my stats database. Therefore, I cannot test this query. I think it works though. For one player when PlayerID is known and only for SLAM:

Code:

SELECT tws.`Friendlyname`, wa.`Kills`, wa.`Deaths`, wa.`Headshots`, (wa.`Headshots`/wa.`Kills`) AS HSR
FROM `tbl_weapons_stats` wa
INNER JOIN `tbl_server_player` tsp ON tsp.`StatsID` = wa.`StatsID`
INNER JOIN `tbl_playerdata` tpd ON tsp.`PlayerID` = tpd.`PlayerID`
INNER JOIN `tbl_weapons` tws ON tws.`WeaponID` = wa.`WeaponID`
WHERE tsp.`ServerID` = {$ServerID}
AND tpd.`PlayerID` = {$PlayerID}
AND tpd.`GameID` = {$GameID}
AND tws.`Friendlyname` = 'SLAM'
AND (wa.`Kills` > 0 OR wa.`Deaths` > 0)
ORDER BY Kills DESC, Deaths DESC

[ImportBot]

Originally Posted by EntraVenuS*:

 

i just dont know

 

why would someones stats ingame when typing !rank show different stats on the webpage ? their stats havent chaged ingame for ages but the website ones update with no problem (this isnt the case for all players) but when typing !top10 the person who i am talking about shows correctly too

 

Any help would be gratefully recieved

 

thanks in advance