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

[ImportBot]

Originally Posted by IRussao*:

 

very nice site, is there a way to disable chat log on the web page or just display all/team chat? if it's possible to do both, can u tell me how?

thx.

[ImportBot]

Originally Posted by ty_ger07*:

 

As it is built, the only way to disable the chat log is to turn chat logging off in the Stats Logger plugin.

Your other option is the modify the stats webpage code to fit your needs.

[ImportBot]

Originally Posted by B7ackhawk*:

 

i tired to fix Live Scoreboard but cant dunno what i do to fix it

 

 

 

https://panda-zlo.lima-city.de/index.php_p=home&sid=2

[ImportBot]

Originally Posted by ty_ger07*:

 

I don't know either. What version of PHP are you using?

[ImportBot]

Originally Posted by nguyendu*:

 

thanks you for share!

[ImportBot]

Originally Posted by B7ackhawk*:

 

i use this version post by Ty_ger07

[ImportBot]

Originally Posted by ty_ger07*:

 

Your Apache web server, it has a PHP environment set up. Which version of PHP? Which version of Apache?

[ImportBot]

Originally Posted by B7ackhawk*:

 

Your Apache web server, it has a PHP environment set up. Which version of PHP? Which version of Apache?

Dear ty_ger07 can you tell me from where i run Live Scoreboard i serch on data bass cant find it

 

 

http://pandaa.pro/

[ImportBot]

Originally Posted by ty_ger07*:

 

The current players for the scoreboard are stored in the tbl_currentplayers table.

[ImportBot]

Originally Posted by B7ackhawk*:

 

The current players for the scoreboard are stored in the tbl_currentplayers table.

and what i do ?

Capture.PNG

[ImportBot]

Originally Posted by ColColonCleaner*:

 

and what i do ?

Attachment 4619

Go to your stat logger plugin and enable the 'live scoreboard in database' setting.

[ImportBot]

Originally Posted by B7ackhawk*:

 

Go to your stat logger plugin and enable the 'live scoreboard in database' setting.

its on Capture.PNG

[ImportBot]

Originally Posted by Sp0rAdiC*:

 

He's running hacked servers, right? Do hacked servers retrieve info from BL?

[ImportBot]

Originally Posted by B7ackhawk*:

 

He's running hacked servers, right? Do hacked servers retrieve info from BL?

Who asked for your opinion_..Do not interfere with what does not concern you

[ImportBot]

Originally Posted by Sp0rAdiC*:

 

showthread....llegal-servers*

[ImportBot]

Originally Posted by B7ackhawk*:

 

again Who asked for your opinion?

[ImportBot]

Originally Posted by ty_ger07*:

 

You never did tell me your version of Apache and PHP. You responded to my question with a question.

 

I have a hunch that my ORDER BY is too ambiguous.

 

In phpmyadmin, run this query.

 

Code:

SELECT cp.`Soldiername`, cp.`Score`, cp.`Kills`, cp.`Deaths`, cp.`TeamID`, cp.`SquadID`, cp.`CountryCode`, sub.`PlayerID`
FROM `tbl_currentplayers` cp
LEFT JOIN
(
	SELECT tpd.`PlayerID`, tpd.`SoldierName`
	FROM `tbl_playerdata` tpd
	INNER JOIN `tbl_server_player` tsp ON tsp.`PlayerID` = tpd.`PlayerID`
	INNER JOIN `tbl_playerstats` tps ON tps.`StatsID` = tsp.`StatsID`
	WHERE tpd.`GameID` = 1
	AND tsp.`ServerID` = 1
) sub ON sub.`SoldierName` = cp.`SoldierName`
WHERE cp.`ServerID` = 1
AND cp.`TeamID` = 1
GROUP BY cp.`SoldierName`
ORDER BY Score DESC;

What is the result?

 

And then try:

 

Code:

SELECT cp.`Soldiername`, cp.`Score`, cp.`Kills`, cp.`Deaths`, cp.`TeamID`, cp.`SquadID`, cp.`CountryCode`, sub.`PlayerID`
FROM `tbl_currentplayers` cp
LEFT JOIN
(
	SELECT tpd.`PlayerID`, tpd.`SoldierName`
	FROM `tbl_playerdata` tpd
	INNER JOIN `tbl_server_player` tsp ON tsp.`PlayerID` = tpd.`PlayerID`
	INNER JOIN `tbl_playerstats` tps ON tps.`StatsID` = tsp.`StatsID`
	WHERE tpd.`GameID` = 1
	AND tsp.`ServerID` = 1
) sub ON sub.`SoldierName` = cp.`SoldierName`
WHERE cp.`ServerID` = 1
AND cp.`TeamID` = 1
GROUP BY cp.`SoldierName`
ORDER BY cp.`Score` DESC;

What is the result?

 

And then try:

 

Code:

SELECT cp.`Soldiername`, cp.`Score`, cp.`Kills`, cp.`Deaths`, cp.`TeamID`, cp.`SquadID`, cp.`CountryCode`, sub.`PlayerID`, sub.`ban_status`
FROM `tbl_currentplayers` cp
LEFT JOIN
(
	SELECT tpd.`PlayerID`, tpd.`SoldierName`, adk.`ban_status`
	FROM `tbl_playerdata` tpd
	INNER JOIN `tbl_server_player` tsp ON tsp.`PlayerID` = tpd.`PlayerID`
	INNER JOIN `tbl_playerstats` tps ON tps.`StatsID` = tsp.`StatsID`
	LEFT JOIN `adkats_bans` adk ON adk.`player_id` = tpd.`PlayerID`
	WHERE tpd.`GameID` = 1
	AND tsp.`ServerID` = 1
) sub ON sub.`SoldierName` = cp.`SoldierName`
WHERE cp.`ServerID` = 1
AND cp.`TeamID` = 1
GROUP BY cp.`SoldierName`
ORDER BY Score DESC;

What is the result?

[ImportBot]

Originally Posted by leibhold*:

 

Who asked for your opinion_..Do not interfere with what does not concern you

Are you running an illegal server?

 

If you are then we will have to ban you.

[ImportBot]

Originally Posted by ty_ger07*:

 

I don't know how to help you if you can't understand my English and aren't providing me useful information. Maybe you can find a translator.

 

Here is my suggestion:

 

In the file ./common/home/scoreboard-live.php, make the following changes:

 

line 395 and line 415 (in two places total),

change:

Code:

ORDER BY {$rank} {$order};

to:

Code:

ORDER BY cp.{$rank} {$order};

My assumption is that your sql server is providing an error message because "ORDER BY whatever" is ambiguous because those particular queries contain subqueries, and your sql server may prefer "ORDER BY cp.whatever" to remove ambiguity. Most databases probably make the assumption just fine without providing an error message, but your server configuration or version numbers may be different, extra strict, or otherwise lack ability to make such assumptions.

 

If you can't understand that suggestion, I don't know how I can help you.

 

 

If that works for everyone, I can make that change official in the stats webpage code.

[ImportBot]

Originally Posted by B7ackhawk*:

 

I don't know how to help you if you can't understand my English and aren't providing me useful information. Maybe you can find a translator.

 

Here is my suggestion:

 

In the file ./common/home/scoreboard-live.php, make the following changes:

 

line 395 and line 415 (in two places total),

change:

Code:

ORDER BY {$rank} {$order};

to:

Code:

ORDER BY cp.{$rank} {$order};

My assumption is that your sql server is providing an error message because "ORDER BY whatever" is ambiguous because those particular queries contain subqueries, and your sql server may prefer "ORDER BY cp.whatever" to remove ambiguity. Most databases probably make the assumption just fine without providing an error message, but your server configuration or version numbers may be different, extra strict, or otherwise lack ability to make such assumptions.

 

If you can't understand that suggestion, I don't know how I can help you.

 

 

If that works for everyone, I can make that change official in the stats webpage code.

thank for you help. i change it but not work

[ImportBot]

Originally Posted by ty_ger07*:

 

Well, I see other things on your stats page which also aren't working. Country stats aren't working and round stats aren't working properly. I cannot help you. Your hacked server with missing information is not something I can support.

[ImportBot]

Originally Posted by B7ackhawk*:

 

Well, I see other things on your stats page which also aren't working. Country stats aren't working and round stats aren't working properly. I cannot help you. Your hacked server with missing information is not something I can support.

ok i will try edit .. thank you

[ImportBot]

Originally Posted by IRussao*:

 

hi, if i move to another host provider, how do i keep the current stats? im guessing the server id will be different, but i want to keep the same stats as the last server, without adding a "new server", so like moving all the stats to a "new server", like it was never changed.

 

I also made some modifications in the player and home page

Player: https://www.modoom.ml/index.php_p=pl...player=IRussao

 

home: https://www.modoom.ml/

 

I also saw many erros about "constructor something", i forget what is, but i fixed it editing the class/fuction.

The log was full of erros for this 2 pages: pchart\class\pData.class.php and pchart\class\pImage.class.php

 

it seems that on php 7.0 u cant have the same class name as function

 

pData.class.php

i had to change line 70: function pData()

to: function __construct()

 

and

pImage.class.php

i had to change line 85: function pImage($XSize,$YSize,$DataSet=NULL,$TransparentBac kground=FALSE)

to function __construct($XSize,$YSize,$DataSet=NULL,$Transpare ntBackground=FALSE)

[ImportBot]

Originally Posted by ColColonCleaner*:

 

hi, if i move to another host provider, how do i keep the current stats? im guessing the server id will be different, but i want to keep the same stats as the last server, without adding a "new server", so like moving all the stats to a "new server", like it was never changed.

 

I also made some modifications in the player and home page

Player: https://www.modoom.ml/index.php_p=pl...player=IRussao

 

home: https://www.modoom.ml/

 

I also saw many erros about "constructor something", i forget what is, but i fixed it editing the class/fuction.

The log was full of erros for this 2 pages: pchart\class\pData.class.php and pchart\class\pImage.class.php

 

it seems that on php 7.0 u cant have the same class name as function

 

pData.class.php

i had to change line 70: function pData()

to: function __construct()

 

and

pImage.class.php

i had to change line 85: function pImage($XSize,$YSize,$DataSet=NULL,$TransparentBac kground=FALSE)

to function __construct($XSize,$YSize,$DataSet=NULL,$Transpare ntBackground=FALSE)

To keep your stats when you change your server IP you need to modify the tbl_server entry for that server to the new IP address BEFORE you connect to your new server. If you do it afterward you will see a second server entry when there shouldn't be.

 

You'll have to talk with tyger about the webpage changes.

[ImportBot]

Originally Posted by ty_ger07*:

 

hi, if i move to another host provider, how do i keep the current stats? im guessing the server id will be different, but i want to keep the same stats as the last server, without adding a "new server", so like moving all the stats to a "new server", like it was never changed.

Instructions with pictures:

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

I also saw many erros about "constructor something", i forget what is, but i fixed it editing the class/fuction.

The log was full of erros for this 2 pages: pchart\class\pData.class.php and pchart\class\pImage.class.php

 

it seems that on php 7.0 u cant have the same class name as function

 

pData.class.php

i had to change line 70: function pData()

to: function __construct()

 

and

pImage.class.php

i had to change line 85: function pImage($XSize,$YSize,$DataSet=NULL,$TransparentBac kground=FALSE)

to function __construct($XSize,$YSize,$DataSet=NULL,$Transpare ntBackground=FALSE)

I will look into it, if I get the chance.

[ImportBot]

Originally Posted by IRussao*:

 

Instructions with pictures:

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

 

I will look into it, if I get the chance.

thanks man.

[ImportBot]

Originally Posted by samoz83*:

 

Seems the player graphs on the server info page and players sigs don't get generated for me, is it due to me using nginx?

[ImportBot]

Originally Posted by ty_ger07*:

 

i tired to fix Live Scoreboard but cant dunno what i do to fix it

 

 

 

https://panda-zlo.lima-city.de/index.php_p=home&sid=2

I think this issue has now been found and fixed.

https://github.com/tyger07/BF4-Serve...es/tag/6-21-18

 

I also saw many erros about "constructor something", i forget what is, but i fixed it editing the class/fuction.

The log was full of erros for this 2 pages: pchart\class\pData.class.php and pchart\class\pImage.class.php

 

it seems that on php 7.0 u cant have the same class name as function

 

pData.class.php

i had to change line 70: function pData()

to: function __construct()

 

and

pImage.class.php

i had to change line 85: function pImage($XSize,$YSize,$DataSet=NULL,$TransparentBac kground=FALSE)

to function __construct($XSize,$YSize,$DataSet=NULL,$Transpare ntBackground=FALSE)

This should now also be fixed. What I really SHOULD have done is contact the maker of the pChart library and let them know instead of taking matters into my own hand.

[ImportBot]

Originally Posted by IRussao*:

 

I'm have some strange problem the mysql table "tbl_server" the column "GameID" keep reseting to 0 messing up the site with "No 'BF4' servers were found in this database! "

 

Since changing it to 1, it would reset back again to 0, so instead i changed "tbl_game" >> gameId to 0, so it work, but then I noticed it make "new stats", I changed it back to 1, I saw the top 10, but then, once I load the web page, the GameId get reseted back to 0.

 

 

How do I fix that? It was working like yesterday and It was not working today, but I remember when it happened, the site was getting "too many connections", I couldnt see any stats, then it stopped showing "too many connections" and it started to display that error, I saw a msg here in fórum about the "fix" to change the gameid, but it keep reseting back to 0.

[ImportBot]

Originally Posted by ty_ger07*:

 

I have no idea why it would change in the first place. This stats page code doesn't alter that value.

Have you stopped the plugin in Procon before changing the value?