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

[ImportBot]

Originally Posted by ty_ger07*:

 

Thats just the database name, used a spare one I had for DayZ.

And it worked XpKiller, restarting the layer.

 

Now here comes the fun part again, some of the stats wont show up - like kills, total deaths, K/D, headshots etc. Its all at 0.

 

http://bf4stats.battlefield.no/

Since you just created the database, a lot of stuff will be zero at first.

 

It also looks like you have some stuff disabled in you stats logger plugin.

[ImportBot]

Originally Posted by bFe*:

 

Seems to be working properly now, enabled some other stuff also(mapdata, session etc).

You can just disregard the PM I sent you :-)

[ImportBot]

Originally Posted by Porthos1973*:

 

Ok quick question. I currently have two separate databases for two servers which means two different stats pages. We are probably going to be moving our servers over to a dedicated box so servers will move. If I point the new servers all to the same database, does server id automatically get assigned or do I have to do it manually?

[ImportBot]

Originally Posted by ty_ger07*:

 

Ok quick question. I currently have two separate databases for two servers which means two different stats pages. We are probably going to be moving our servers over to a dedicated box so servers will move. If I point the new servers all to the same database, does server id automatically get assigned or do I have to do it manually?

You should put your servers all in the same database. Xpkiller's plugin automatically assigns them different server ids.

[ImportBot]

Originally Posted by Porthos1973*:

 

You should put your servers all in the same database. Xpkiller's plugin automatically assigns them different server ids.

Thanks that is what I wanted to know.

[ImportBot]

Originally Posted by TMiland*:

 

When you release this will it work on evo extreme?

No, this is for e107.

[ImportBot]

Originally Posted by bFe*:

 

To have the new maps show up on the stats page, change your $map_array(found in index.php | around line 130) to this:

 

$map_array = array('Zavod 311'=>'MP_Abandoned','Lancang Dam'=>'MP_Damage','Flood Zone'=>'MP_Flooded','Golmud Railway'=>'MP_Journey','Paracel Storm'=>'MP_Naval','Operation Locker'=>'MP_Prison','Hainan Resort'=>'MP_Resort','Siege of Shanghai'=>'MP_Siege','Rogue Transmission'=>'MP_TheDish','Dawnbreaker'=>'MP_Tre mors','Silk Road'=>'XP1_001','Altai Range'=>'XP1_002','Guilin Peaks'=>'XP1_003','Dragon Pass'=>'XP1_004');

 

 

And another thing, how can I make the leaderboards global and not show individual stats from each server?

I have seven servers all having the same server group and all having overall ranking turned on, but the leaderboards are different.

[ImportBot]

Originally Posted by ty_ger07*:

 

To have the new maps show up on the stats page, change your $map_array(found in index.php | around line 130) to this:

 

$map_array = array('Zavod 311'=>'MP_Abandoned','Lancang Dam'=>'MP_Damage','Flood Zone'=>'MP_Flooded','Golmud Railway'=>'MP_Journey','Paracel Storm'=>'MP_Naval','Operation Locker'=>'MP_Prison','Hainan Resort'=>'MP_Resort','Siege of Shanghai'=>'MP_Siege','Rogue Transmission'=>'MP_TheDish','Dawnbreaker'=>'MP_Tre mors','Silk Road'=>'XP1_001','Altai Range'=>'XP1_002','Guilin Peaks'=>'XP1_003','Dragon Pass'=>'XP1_004');

 

 

And another thing, how can I make the leaderboards global and not show individual stats from each server?

I have seven servers all having the same server group and all having overall ranking turned on, but the leaderboards are different.

I am busy with work so I can't update this code for the expansion pack right now.

An expansion pack came out already and I haven't even had a chance to play much.

 

For global stats, the server ID needs to be removed from the SQL queries. The stats pages at present are designed to show stats for each server individually. You would have to remove WHERE serverID = '{$server_ID}' or whatever (off the top of my head) from the queries and replace it with WHERE 1 in the code to not filter the stats for each server individually.

 

For example, to show top players in all servers on 'home' page, change this:

 

$sql = @mysql_query("SELECT tpd.SoldierName, tps.Score, tps.Kills, tps.Deaths, tps.Rounds, tps.Headshots FROM tbl_playerstats tps INNER JOIN tbl_server_player tsp ON tsp.StatsID = tps.StatsID INNER JOIN tbl_playerdata tpd ON tsp.PlayerID = tpd.PlayerID WHERE tsp.ServerID = '$server_ID' ORDER BY $rankin $order, SoldierName $nextorder LIMIT $offset, $rowsperpage");

 

To this:

 

$sql = @mysql_query("SELECT tpd.SoldierName, tps.Score, tps.Kills, tps.Deaths, tps.Rounds, tps.Headshots FROM tbl_playerstats tps INNER JOIN tbl_server_player tsp ON tsp.StatsID = tps.StatsID INNER JOIN tbl_playerdata tpd ON tsp.PlayerID = tpd.PlayerID WHERE 1 ORDER BY $rankin $order, SoldierName $nextorder LIMIT $offset, $rowsperpage");

[ImportBot]

Originally Posted by ty_ger07*:

 

I should clarify that I have not tested that query.

 

I don't think it will do exactly what you want because I think it will show the same player on the list in multiple places (one for their ranking on each server). To add up each player's stats on all servers, I think you would need to sum the stats and group by soldier name.

 

But that query I gave should at least show the top players on all your servers grouped by their best stats in any one server.

[ImportBot]

Originally Posted by XpKiller*:

 

I am busy with work so I can't update this code for the expansion pack right now.

An expansion pack came out already and I haven't even had a chance to play much.

 

For global stats, the server ID needs to be removed from the SQL queries. The stats pages at present are designed to show stats for each server individually. You would have to remove WHERE serverID = '{$server_ID}' or whatever (off the top of my head) from the queries and replace it with WHERE 1 in the code to not filter the stats for each server individually.

 

For example, to show top players in all servers on 'home' page, change this:

 

$sql = @mysql_query("SELECT tpd.SoldierName, tps.Score, tps.Kills, tps.Deaths, tps.Rounds, tps.Headshots FROM tbl_playerstats tps INNER JOIN tbl_server_player tsp ON tsp.StatsID = tps.StatsID INNER JOIN tbl_playerdata tpd ON tsp.PlayerID = tpd.PlayerID WHERE tsp.ServerID = '$server_ID' ORDER BY $rankin $order, SoldierName $nextorder LIMIT $offset, $rowsperpage");

 

To this:

 

$sql = @mysql_query("SELECT tpd.SoldierName, tps.Score, tps.Kills, tps.Deaths, tps.Rounds, tps.Headshots FROM tbl_playerstats tps INNER JOIN tbl_server_player tsp ON tsp.StatsID = tps.StatsID INNER JOIN tbl_playerdata tpd ON tsp.PlayerID = tpd.PlayerID WHERE 1 ORDER BY $rankin $order, SoldierName $nextorder LIMIT $offset, $rowsperpage");

Use this one:

$sql = @mysql_query("SELECT tpd.SoldierName,SUM( tps.Score), SUM(tps.Kills), SUM(tps.Deaths), SUM(tps.Rounds), SUM(tps.Headshots) FROM tbl_playerstats tps INNER JOIN tbl_server_player tsp ON tsp.StatsID = tps.StatsID INNER JOIN tbl_playerdata tpd ON tsp.PlayerID = tpd.PlayerID WHERE tsp.ServerGroup = $ServerGroup GROUP BY tpd.PlayerID ORDER BY SUM($rankin) $order, SoldierName $nextorder LIMIT $offset, $rowsperpage");

 

not tested may soe variables are wrong.

 

edit:

forgot a group by :-(

[ImportBot]

Originally Posted by ty_ger07*:

 

Thanks for the support xpkiller.

[ImportBot]

Originally Posted by bFe*:

 

Nice, ill test it out and let ya know how it works

[ImportBot]

Originally Posted by XpKiller*:

 

please recheck my last post:

 

i forgot:

GROUP BY tpd.PlayerID

[ImportBot]

Originally Posted by Kinsman*:

 

I think this line above to get the playername stops it working? I guess it now needs to get playernames from all servers?

 

$sql = @mysql_query("SELECT COUNT(tpd.SoldierName) FROM tbl_playerstats tps INNER JOIN tbl_server_player tsp ON tsp.StatsID = tps.StatsID INNER JOIN tbl_playerdata tpd ON tsp.PlayerID = tpd.PlayerID WHERE tsp.ServerID = '$server_ID' ORDER BY Score DESC, SoldierName ASC");

 

Also how do I add all 5 server groups to your query XPKiller? (yes we have 1 server per group, dumb i guess!)

 

$sql = @mysql_query("SELECT tpd.SoldierName,SUM( tps.Score), SUM(tps.Kills), SUM(tps.Deaths), SUM(tps.Rounds), SUM(tps.Headshots) FROM tbl_playerstats tps INNER JOIN tbl_server_player tsp ON tsp.StatsID = tps.StatsID INNER JOIN tbl_playerdata tpd ON tsp.PlayerID = tpd.PlayerID WHERE tsp.ServerGroup = $ServerGroup GROUP BY tpd.PlayerID ORDER BY SUM($rankin) $order, SoldierName $nextorder LIMIT $offset, $rowsperpage");

[ImportBot]

Originally Posted by ty_ger07*:

 

What are you attempting to do in the first query?

 

Oh... yeah. The first query is there to find the total number of players and figure out how many pages of pagination to provide. With the wrong number of players detected, it would just not show the very last pages of worst ranking players.

[ImportBot]

Originally Posted by t0p8uzz*:

 

Anyone got map images for the 4 new ones yet?

[ImportBot]

Originally Posted by TMiland*:

 

Anyone got map images for the 4 new ones yet?

I resized the battlelog map images, to fit the others found here.

 

Download: china_rising_maps.zip

[ImportBot]

Originally Posted by Kinsman*:

 

Well the total query just says no stats found until I figure out how to add the servergroups.

[ImportBot]

Originally Posted by t0p8uzz*:

 

I resized the battlelog map images, to fit the others found here.

 

Download: china_rising_maps.zip

Appreciate that, thanks!

[ImportBot]

Originally Posted by Repoman*:

 

I tried to get the plugin connected to my remote DB, however I keep getting this error.

 

Attached Files:

• stats.jpg

[ImportBot]

Originally Posted by ty_ger07*:

 

I tried to get the plugin connected to my remote DB, however I keep getting this error.

Please ask in xpkiller's plugin thread. This is not the place to ask questions about his plugin.

[ImportBot]

Originally Posted by Hand-of-Shadow*:

 

this Stats page is for BF 4 only ?

[ImportBot]

Originally Posted by ty_ger07*:

 

this Stats page is for BF 4 only ?

It is for xpkiller's latest version of his plugin. If xpkiller's latest plugin version works for bf3, then this code will work for BF3 also.

[ImportBot]

Originally Posted by XpKiller*:

 

The stats plugin works with all games supported by procon.

[ImportBot]

Originally Posted by ty_ger07*:

 

Thank you xpkiller. Since I don't rent servers any more, it is hard for me to answer those types of questions.

[ImportBot]

Originally Posted by Cedbru57*:

 

Hi,

 

Is it possible to add the gamemode in mapstats ?

[ImportBot]

Originally Posted by ty_ger07*:

 

Hi,

 

Is it possible to add the gamemode in mapstats ?

Yes, it would be possible, but how would you like it organized? Each map listed for each game mode played?

[ImportBot]

Originally Posted by Kinsman*:

 

Done.

 

add gamemode to the query here.

 

Code:

// query for maps
    $map_result = @mysql_query("SELECT ServerID, MapName, Gamemode, SUM(NumberofRounds) AS NumberofRounds, AVG(AvgPlayers) AS AveragePlayers, AvgPlayers, AVG(PlayersLeftServer) AS AveragePlayersLeftServer, PlayersLeftServer FROM tbl_mapstats WHERE ServerID = '$server_ID' GROUP BY MapName ORDER BY $rankin $order");
    if(@mysql_num_rows($map_result)==0)
    {

then arrange how you like.

 

Code:

<th width="20%" style="text-align:left">Map Name</th>
        ';
        if($rank != 'MapName')
        {
            echo'<th width="20%" style="text-align:left;"><a href="' . $_SERVER['PHP_SELF'] . '_mapstats=View&rank=MapName&order=ASC"><span class="orderheader">Map Code</span></a></th>';
        }
        else
        {
            echo'<th width="20%" style="text-align:left;"><a href="' . $_SERVER['PHP_SELF'] . '_mapstats=View&rank=MapName&order=' . $nextorder . '"><span class="orderheader">Map Code</span></a></th>';
        }
        if($rank != 'Gamemode')
        {
            echo'<th width="20%" style="text-align:left;"><a href="' . $_SERVER['PHP_SELF'] . '_mapstats=View&rank=Gamemode&order=ASC"><span class="orderheader">Game Mode</span></a></th>';
        }
        else
        {
            echo'<th width="20%" style="text-align:left;"><a href="' . $_SERVER['PHP_SELF'] . '_mapstats=View&rank=Gamemode&order=' . $nextorder . '"><span class="orderheader">Game Mode</span></a></th>';
        }
        
        if($rank != 'NumberofRounds')
        {
            echo'<th width="20%" style="text-align:left;"><a href="' . $_SERVER['PHP_SELF'] . '_mapstats=View&rank=NumberofRounds&order=DESC"><span class="orderheader">Rounds Played</span></a></th>';
        }
        else
        {
            echo'<th width="20%" style="text-align:left;"><a href="' . $_SERVER['PHP_SELF'] . '_mapstats=View&rank=NumberofRounds&order=' . $nextorder . '"><span class="orderheader">Rounds Played</span></a></th>';
        }
        if($rank != 'AVGPop')
        {
            echo'<th width="20%" style="text-align:left;"><a href="' . $_SERVER['PHP_SELF'] . '_mapstats=View&rank=AVGPop&order=DESC"><span class="orderheader">Average Popularity</span></a></th>';
        }
        else
        {
            echo'<th width="20%" style="text-align:left;"><a href="' . $_SERVER['PHP_SELF'] . '_mapstats=View&rank=AVGPop&order=' . $nextorder . '"><span class="orderheader">Average Popularity</span></a></th>';
        }
        echo '</tr>';
        // initialize value
        $count = 0;
        while($map_row = @mysql_fetch_assoc($map_result))
        {
            $MapName = $map_row['MapName'];
            $NumberofRounds = $map_row['NumberofRounds'];
            $map_stats = array_search($MapName,$map_array);
            // convert mode to friendly name
          $mode = $map_row['Gamemode'];
          $mode_name = array_search($mode,$mode_array);
        
            $AveragePlayers = $map_row['AveragePlayers'];
            $AveragePlayersLeftServer = $map_row['AveragePlayersLeftServer'];
            // avoid dividing by zero
            if(($AveragePlayers >= 1) AND ($AveragePlayersLeftServer >= 1))
            {
                $AveragePopularity = round(($AveragePlayers/$AveragePlayersLeftServer),2);
            }
            else
            {
                $AveragePopularity = 'Not enough data';
            }
            // only display the map in the list if it has been played
            if($MapName!=null)
            {
                $count++;
                echo '
                <tr>
                <td width="5%" class="tablecontents" style="text-align: left;"><font size="2">' . $count . ':</font></td>
                <td width="20%" class="tablecontents" style="text-align: left;">' . $map_stats . '</td>
                <td width="20%" class="tablecontents" style="text-align: left;">' . $MapName . '</td>
                <td width="20%" class="tablecontents" style="text-align: left;">' . $mode_name . '</td>
                <td width="20%" class="tablecontents" style="text-align: left;">' . $NumberofRounds . '</td>
                <td width="20%" class="tablecontents" style="text-align: left;">' . $AveragePopularity . '</td>

[ImportBot]

Originally Posted by ty_ger07*:

 

Done.

 

add gamemode to the query here.

 

Code:

// query for maps
    $map_result = @mysql_query("SELECT ServerID, MapName, Gamemode, SUM(NumberofRounds) AS NumberofRounds, AVG(AvgPlayers) AS AveragePlayers, AvgPlayers, AVG(PlayersLeftServer) AS AveragePlayersLeftServer, PlayersLeftServer FROM tbl_mapstats WHERE ServerID = '$server_ID' GROUP BY MapName ORDER BY $rankin $order");
    if(@mysql_num_rows($map_result)==0)
    {

then arrange how you like.

 

Code:

<th width="20%" style="text-align:left">Map Name</th>
        ';
        if($rank != 'MapName')
        {
            echo'<th width="20%" style="text-align:left;"><a href="' . $_SERVER['PHP_SELF'] . '_mapstats=View&rank=MapName&order=ASC"><span class="orderheader">Map Code</span></a></th>';
        }
        else
        {
            echo'<th width="20%" style="text-align:left;"><a href="' . $_SERVER['PHP_SELF'] . '_mapstats=View&rank=MapName&order=' . $nextorder . '"><span class="orderheader">Map Code</span></a></th>';
        }
        if($rank != 'Gamemode')
        {
            echo'<th width="20%" style="text-align:left;"><a href="' . $_SERVER['PHP_SELF'] . '_mapstats=View&rank=Gamemode&order=ASC"><span class="orderheader">Game Mode</span></a></th>';
        }
        else
        {
            echo'<th width="20%" style="text-align:left;"><a href="' . $_SERVER['PHP_SELF'] . '_mapstats=View&rank=Gamemode&order=' . $nextorder . '"><span class="orderheader">Game Mode</span></a></th>';
        }
        
        if($rank != 'NumberofRounds')
        {
            echo'<th width="20%" style="text-align:left;"><a href="' . $_SERVER['PHP_SELF'] . '_mapstats=View&rank=NumberofRounds&order=DESC"><span class="orderheader">Rounds Played</span></a></th>';
        }
        else
        {
            echo'<th width="20%" style="text-align:left;"><a href="' . $_SERVER['PHP_SELF'] . '_mapstats=View&rank=NumberofRounds&order=' . $nextorder . '"><span class="orderheader">Rounds Played</span></a></th>';
        }
        if($rank != 'AVGPop')
        {
            echo'<th width="20%" style="text-align:left;"><a href="' . $_SERVER['PHP_SELF'] . '_mapstats=View&rank=AVGPop&order=DESC"><span class="orderheader">Average Popularity</span></a></th>';
        }
        else
        {
            echo'<th width="20%" style="text-align:left;"><a href="' . $_SERVER['PHP_SELF'] . '_mapstats=View&rank=AVGPop&order=' . $nextorder . '"><span class="orderheader">Average Popularity</span></a></th>';
        }
        echo '</tr>';
        // initialize value
        $count = 0;
        while($map_row = @mysql_fetch_assoc($map_result))
        {
            $MapName = $map_row['MapName'];
            $NumberofRounds = $map_row['NumberofRounds'];
            $map_stats = array_search($MapName,$map_array);
            // convert mode to friendly name
          $mode = $map_row['Gamemode'];
          $mode_name = array_search($mode,$mode_array);
        
            $AveragePlayers = $map_row['AveragePlayers'];
            $AveragePlayersLeftServer = $map_row['AveragePlayersLeftServer'];
            // avoid dividing by zero
            if(($AveragePlayers >= 1) AND ($AveragePlayersLeftServer >= 1))
            {
                $AveragePopularity = round(($AveragePlayers/$AveragePlayersLeftServer),2);
            }
            else
            {
                $AveragePopularity = 'Not enough data';
            }
            // only display the map in the list if it has been played
            if($MapName!=null)
            {
                $count++;
                echo '
                <tr>
                <td width="5%" class="tablecontents" style="text-align: left;"><font size="2">' . $count . ':</font></td>
                <td width="20%" class="tablecontents" style="text-align: left;">' . $map_stats . '</td>
                <td width="20%" class="tablecontents" style="text-align: left;">' . $MapName . '</td>
                <td width="20%" class="tablecontents" style="text-align: left;">' . $mode_name . '</td>
                <td width="20%" class="tablecontents" style="text-align: left;">' . $NumberofRounds . '</td>
                <td width="20%" class="tablecontents" style="text-align: left;">' . $AveragePopularity . '</td>

That won't really work. That will just show the last gamemode played by that map but won't display how many times that map has been played in other game modes.

 

Unless that is the goal in mind. I am not really sure what the goal is since the request was vague.

[ImportBot]

Originally Posted by Cedbru57*:

 

Yes, it would be possible, but how would you like it organized? Each map listed for each game mode played?

Yes, each map for each game mode.

1: Siege of Shanghai MP_Siege Domination 34 1.42

2: Siege of Shanghai MP_Siege SmallConquest 20 1.10

 

Other question, why the first seen and last seen are no longer appear in player statistics ?

 

Thank for your reply