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

[ImportBot]

Originally Posted by loki87*:

 

hwo to update ? just replace the logindata in new files ?

[ImportBot]

Originally Posted by ty_ger07*:

 

Why would that be a 'hack'? It's just a workaround for hosts who don't want images have a .php file extension (for security reasons mostly).

Hack as in "an inelegant but effective solution to a computing problem".

[ImportBot]

Originally Posted by ty_ger07*:

 

hwo to update ? just replace the logindata in new files ?

The best way is to delete the files and replace them with the new files.

[ImportBot]

Originally Posted by Borzywit*:

 

Hi there!

 

I suggest two changes. First is a bug fix, and second an upgrade.

 

file: root/index.php

 

Find:

<_php>

// server stats page by Ty_ger07 at http://open-web-community.com/

 

// DON'T EDIT ANYTHING BELOW UNLESS YOU KNOW WHAT YOU ARE DOING

Add after:

//timezone fix

date_default_timezone_set('Europe/Warsaw');

Please refer to PHP valid timezones and use it at your discrettion. Not going after that fix may cause PHP errors on several pages.

 

file: root/common/player.php

 

FIND:

Battlelog Stats: www.Battlelog.Battlefield.com

BF4 Stats: www.BF4stats.com

Metabans: www.Metabans.com

REPLACE WITH:

Battlelog Stats: www.Battlelog.Battlefield.com

BF4 Stats: www.BF4stats.com

Metabans: www.Metabans.com ';

$Find_guid = @mysqli_query($BF4stats,"

SELECT `PBGUID`

FROM `tbl_playerdata`

WHERE `PlayerID` = {$PlayerID}

AND `GameID` = {$GameID}

");

if (@mysqli_num_rows($Find_guid) == 1)

{

$PlayerPB = @mysqli_fetch_assoc($Find_guid);

$PbGuid = $PlayerPB['PBGUID'];

echo '

Gametracker PB: www.GameTracker.com ';

}

else

{

echo '

Gametracker PB: www.GameTracker.com ';

}

echo '

FIND:

}

_>

ADD BEFORE:

// free up PB guid query memory

@mysqli_free_result($Find_guid);

This will add a gamtracker PB screens search link on right side of MetaBans link at player detailed stats page. This also overrides PBguid search link with player name search link, if player is not recorded on database.

 

Updraded player.php file is downloadable form: http://cnpc.org.pl/stats/player.rar

 

Thanks for that great stats page!

 

http://cnpc.org.pl/stats/

[ImportBot]

Originally Posted by Borzywit*:

 

Ok,

 

it seems like I will have to move all DB from one hosting to another. The problem is, on another hosting I already have 4 active servers ( http://cnpc.org.pl/stats/ ). Can you please advise q query to change all SERVERID entries in DB? For example from ID 1 to ID 5.

 

THNX.

[ImportBot]

Originally Posted by ty_ger07*:

 

Ok,

 

it seems like I will have to move all DB from one hosting to another. The problem is, on another hosting I already have 4 active servers ( http://cnpc.org.pl/stats/ ). Can you please advise q query to change all SERVERID entries in DB? For example from ID 1 to ID 5.

 

THNX.

No, I don't have a good answer. I could guess, but don't want to guess and cause all your data to corrupt. The tricky part is changing player ids and stats ids. I think it will get all messed up.

 

I would ask xpkiller.

[ImportBot]

Originally Posted by Borzywit*:

 

This is another thing that was thinking of ... It's a tricky task.

 

BTW. What would you say about changes I proposed via PM?

[ImportBot]

Originally Posted by ty_ger07*:

 

This is another thing that was thinking of ... It's a tricky task.

 

BTW. What would you say about changes I proposed via PM?

The timezone proposal I assume is mainly for showing the correct local time in the chat log, correct?

 

The gametracker screenshot proposal I am on the fence about because gametracker screenshots only work if your server is rented from gameservers.com, right?

[ImportBot]

Originally Posted by Borzywit*:

 

Without timezone override I have had such notivication:

 

on chat log page:

Strict Standards: strtotime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Berlin' for 'CET/1.0/no DST' instead in /homepages/45/d484598997/htdocs/cnpc/stats/common/chat.php on line 180

On detailed user page:

Strict Standards: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Berlin' for 'CET/1.0/no DST' instead in /homepages/45/d484598997/htdocs/cnpc/stats/common/player.php on line 461

 

Strict Standards: strtotime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Berlin' for 'CET/1.0/no DST' instead in /homepages/45/d484598997/htdocs/cnpc/stats/common/player.php on line 462

Regarding PB screens on gamtracker, it will show ALL stored on gametracker servers screens (if screen was uploaded to gametracker at all). However URL used to generate request is taken from my servers page on gametracker. I did not figure out, how to bypass it.

[ImportBot]

Originally Posted by ty_ger07*:

 

Without timezone override I have had such notivication:

That is weird. You shouldn't see any strict notifications with PHP debugging disabled. Usually it is not good to leave PHP debugging enabled because any error message could give a hacker more information on how they might want to try hacking your site.

 

Anyways, that is odd. Which version of PHP is running on your server? The server is not able to figure out its own timezone any more? Every PHP update has something new and weird.

[ImportBot]

Originally Posted by Borzywit*:

 

It's 5.4

[ImportBot]

Originally Posted by ty_ger07*:

 

It's 5.4

I believe that you are supposed to set your timezone in your php.ini file for your server's PHP installation and then all other pages will know which timezone to use.

 

http://www.php.net/manual/en/datetime.configuration.php

 

 

Individual pages shouldn't have to set their own time zone over and over each time a page is loaded.

[ImportBot]

Originally Posted by Borzywit*:

 

Unfotunatelly I do net have an opportunity to change anything. This was a fix for me ... maybe others will need it. Anyway, it may be appplied an commented out, so it's line with no impact at all.

[ImportBot]

Originally Posted by Borzywit*:

 

Can you please take a look at those two pages?

 

http://grajdolek.net/index.php_ServerID=1&potw=1 -> I am Borzywit-CNP-, currently no.5, according to presented stats

 

http://grajdolek.net/index.php_Serve...=1643&search=1 -> detailed stats page. According to thios, I am no.6.

 

There is also different KDR, headshoots amount, total score.

 

PS

http://grajdolek.net/index.php_ServerID=1 -> this presents same info as first link.

[ImportBot]

Originally Posted by ty_ger07*:

 

Unfotunatelly I do net have an opportunity to change anything. This was a fix for me ... maybe others will need it. Anyway, it may be appplied an commented out, so it's line with no impact at all.

This is really something your server host should take care of. There is no reason why your server shouldn't know which timezone it is in. Have you asked your server host to fix this for you?

 

I updated from PHP 5.3 to PHP version 5.4 and don't see any problem at my host.

[ImportBot]

Originally Posted by cdd3068*:

 

The gametracker screenshot proposal I am on the fence about because gametracker screenshots only work if your server is rented from gameservers.com, right?

No. As long as the person has the ability to change the server name temporarily and has an account on game tracker, they would be able to "claim" the server on game tracker and become the manager. See the game tracker link in my signature.

[ImportBot]

Originally Posted by cdd3068*:

 

The signature images use the GD library and those are working fine for you. The signature images just use standard low quality fonts. The graphs use high quality true type fonts and for some reason your GD installation does not support it.

Thank you VERY MUCH for your help! I contacted Fragnet again through my support ticket and they have updated the necessary files for me. I wish I could have learned how to do it myself, however this is the best that it will get. Every chart is now populated as required. Thank you so much again.

 

Click here: stats.nosnipersbf4.com

 

Now the question is, what kind of custom stats can I provide?

[ImportBot]

Originally Posted by ty_ger07*:

 

Can you please take a look at those two pages?

 

http://grajdolek.net/index.php_ServerID=1&potw=1 -> I am Borzywit-CNP-, currently no.5, according to presented stats

 

http://grajdolek.net/index.php_Serve...=1643&search=1 -> detailed stats page. According to thios, I am no.6.

 

There is also different KDR, headshoots amount, total score.

 

PS

http://grajdolek.net/index.php_ServerID=1 -> this presents same info as first link.

That is normal.

 

POTW (Players of the Week) shows only the stats you have achieved over the last week. If you have played in the server more than a week, your total server stats will be different than your weekly stats because the weekly stats only count what you have achieved over the last week.

 

To explain the difference: over this last week, you were the #5 player ranked by score, but over the lifetime of your server stats, you were the #6 player ranked by score.

[ImportBot]

Originally Posted by ty_ger07*:

 

No. As long as the person has the ability to change the server name temporarily and has an account on game tracker, they would be able to "claim" the server on game tracker and become the manager. See the game tracker link in my signature.

I know how GameTracker works as far as adding servers to GameTracker and claiming servers. But that is not the case for GameTracker PB Screenshots. GameTrackers says that ONLY game servers rented from GameServers.com currently support the GameTracker PB Screenshots feature.

[ImportBot]

Originally Posted by ty_ger07*:

 

Is there anyone out there with the latest version of XpKillers plugin running on a BC2 or BF3 server who is interested in sharing a copy of their database with me so I can see what is necessary to support multiple games?

[ImportBot]

Originally Posted by Chilace*:

 

I can install logger for bf3 later when the server is empty

[ImportBot]

Originally Posted by Kinsman*:

 

Is there anyone out there with the latest version of XpKillers plugin running on a BC2 or BF3 server who is interested in sharing a copy of their database with me so I can see what is necessary to support multiple games?

I could export this if it helps, but it is about 3-4 months old.

 

http://jw.servegame.org/stats/

[ImportBot]

Originally Posted by CptChaos*:

 

EDIT 2: Pchart Image class file already has the headers set back in time, but it doesn't seem to be foolproof.

 

By the way, while "WHERE 1" isn't necessary, it is a coding convention to include a WHERE clause in such a query and that is why the always true '1' is provided to populate the WHERE clause.

I thought you would say that, but even a where clause isn't neccesary in a query. There are other ways to limit the results, with the limit-clause for example.

!empty checks that its value is not 0. You could put _globalhome=0 in the URL and you wouldn't want globalhome=0 to be treated the same as _globalhome=1. So we use !empty to consider that _globalhome doesn't even exist if its value is 0.

 

Is_numeric wouldn't work well for a string like soldiername.

0 != null.

[ImportBot]

Originally Posted by ty_ger07*:

 

I thought you would say that, but even a where clause isn't neccesary in a query. There are other ways to limit the results, with the limit-clause for example.0 != null.

I could remove 'WHERE 1', but I am a stick in the mud.

 

I know that 0 does not equal null. But empty() considers 0 empty. So, when I check !empty() I am checking that the variable contains a value and that the value is not 0. Two birds with one stone.

 

http://us1.php.net/manual/en/function.empty.php

 

The following things are considered to be empty:

"" (an empty string)

0 (0 as an integer)

0.0 (0 as a float)

"0" (0 as a string)

NULL

FALSE

array() (an empty array)

$var; (a variable declared, but without a value)

Empty checks that a variable is not null, is not zero, and is not empty. The documentation is not clear about whether it checks if a variable is set. It says an empty set variable is empty, but does not say whether a non set variable is empty, so paranoia causes me to add isset also. With multiple versions of php in use and the strange things which happen in some versions, you can't be too careful.

 

By the way, you will see a consequence if you search for soldiername of 0, but i figured that was an unlikely name.

 

Edit:

No warning is generated if the variable does not exist. That means empty() is essentially the concise equivalent to !isset($var) || $var == false.

Crap. Well whatever. I know what can be removed in the next update. Lol.

[ImportBot]

Originally Posted by ty_ger07*:

 

I could export this if it helps, but it is about 3-4 months old.

 

http://jw.servegame.org/stats/

But is that stats database created with xpkiller's newest universal plugin version? The old bf3 stats database with the old plugin is not the same as the new bf3 stats database with the new plugin. XpKiller changed the weapon stats and game handling procedure.

 

I need to make sure the bc2 and bf3 databases use the latest database since the old structure isn't supported anymore.

[ImportBot]

Originally Posted by Kinsman*:

 

Good point so I can't help sorry, we only have BF4 currently.

[ImportBot]

Originally Posted by Chilace*:

 

Ok, just installed newest logger. What now ? Wait until the players will play one round?

[ImportBot]

Originally Posted by Chilace*:

 

Is there anyone out there with the latest version of XpKillers plugin running on a BC2 or BF3 server who is interested in sharing a copy of their database with me so I can see what is necessary to support multiple games?

Still you need that db for bf3 created by the newest logger ?

[ImportBot]

Originally Posted by ty_ger07*:

 

Still you need that db for bf3 created by the newest logger ?

Yes, it would be helpful, but I don't have time for the next week or two to do too much with it.

[ImportBot]

Originally Posted by Chilace*:

 

Yes, it would be helpful, but I don't have time for the next week or two to do too much with it.

Ok, just waiting for you.