Server Stats page for XpKiller's 'BF3 Chat, GUID, Stats and Mapstats Logger'

[ImportBot]

Originally Posted by EBassie*:

 

The fact that I don't use PBbans because they never approved my account for whatever reason makes it difficult for me to test and incorporate their API.

 

EDIT: I will not incorporate GGC-Stream back into the server page for a while. It seems GGC-Stream is still not fully operational and I can't trust that things will not change at a moments notice.

Hi ty_ger07,

 

personally I would choose PBBans over GGC every day. I used to DUO stream to both. But after this mess I decided to remove GGC.

 

GGC just fucked up too many times the last 12 months.

First the fake bans in January 2012, then the MD5-Tool BANNING for a disabled Filetweaker. Now this mess with claiming the ownership of GGC. I don't trust them any more.

 

And I will not go back to them.

 

Also the PBBans community & staff are much more active, like MaydaX here in the forum.

Hell, you can find MaydaX all over the internet

 

You know PBBans now has a light-streaming subscription?

http://www.pbbans.com/forums/pbbans-...e-t161764.html

 

 

PS: I don't know why you were denied by PBBans in the past, but I see your website does not have a clanroster with members. That could be fixed easily?

 

Streaming Requirements:

http://www.pbbans.com/forums/streami...ts-t82423.html

[ImportBot]

Originally Posted by utopiate*:

 

Agreed, GGC have had a bad year. I will wait until they are more settled before I use them again. As EBastard said PBBans offer the better service by a fair margin. The requirements are not too rigorous so maybe worth your time?

[ImportBot]

Originally Posted by ty_ger07*:

 

Hi ty_ger07,

 

personally I would choose PBBans over GGC every day. I used to DUO stream to both. But after this mess I decided to remove GGC.

 

GGC just fucked up too many times the last 12 months.

First the fake bans in January 2012, then the MD5-Tool BANNING for a disabled Filetweaker. Now this mess with claiming the ownership of GGC. I don't trust them any more.

 

And I will not go back to them.

 

Also the PBBans community & staff are much more active, like MaydaX here in the forum.

Hell, you can find MaydaX all over the internet

 

You know PBBans now has a light-streaming subscription?

http://www.pbbans.com/forums/pbbans-...e-t161764.html

 

 

PS: I don't know why you were denied by PBBans in the past, but I see your website does not have a clanroster with members. That could be fixed easily?

 

Streaming Requirements:

http://www.pbbans.com/forums/streami...ts-t82423.html

We do have a clan member roster, but it is not available to guests. At the bottom of the page, the legend which says "Legend :: Clan Members, Management, Registered users" are links to each group of people where everyone in that group is listed. But guests do not have access to that information and that is why a guest doesn't see it as a link.

 

For instance, this is a list of all our clan members:

http://thetacteam.info/memberlist.php_mode=group&g=7

 

But a user needs to be logged in to view that information.

 

You need to login to view group details.

That is why they are not links as a guest because viewing those pages are useless to them.

[ImportBot]

Originally Posted by ty_ger07*:

 

Hi,

 

The webpage is not connecting to the database. Please see below a link.

 

http://www.bf3-fairplay.com/

 

Don't we need a port to connect to database?

 

Thanks.

No, you should not need a port to connect to the database using php's mysql_connect() function.

 

Where is your database? Is your database hosted on the same webserver as http://www.bf3-fairplay.com/ , or hosted somewhere else?

 

Open phpmyadmin for that MySQL database. The majority of the correct connection details should be listed there.

 

For example:

 

In this example, you can see that the user name is 'tactournuser'. You can also see that the database is located at 'tactournuser.db.8362636.hostedresource.com'. The only other thing to know from that point is the database name and password.

[ImportBot]

Originally Posted by EBassie*:

 

That is why they are not links as a guest because viewing those pages are useless to them.

I think the roster needs to be public to be able to stream to PBBans.

[ImportBot]

Originally Posted by BF3-FairPlay*:

 

No, you should not need a port to connect to the database using php's mysql_connect() function.

 

Where is your database? Is your database hosted on the same webserver as http://www.bf3-fairplay.com/ , or hosted somewhere else?

 

Open phpmyadmin for that MySQL database. The majority of the correct connection details should be listed there.

 

For example:

 

In this example, you can see that the user name is 'tactournuser'. You can also see that the database is located at 'tactournuser.db.8362636.hostedresource.com'. The only other thing to know from that point is the database name and password.

Hi, thank you for your response.

 

Yes, my database is hosted on the same webserver and I'm currently using it for several plugins which are working fine. I used exactly the same database host name, name, username, password, etc apart of port for your webpage as for plugins that are working fine. This is why I thought it might be something else that is not letting your webpage to connect to the database.

 

However, thank you for trying to help - I really appreciate it.

[ImportBot]

Originally Posted by BF3-FairPlay*:

 

I think the roster needs to be public to be able to stream to PBBans.

You have 2 types of streaming which are lite and full and you don't need to have a clan, website, etc for lite option (that what I have at the moment since I dont have a ready website, clan, etc yet). With lite streaming option PBBans also will be kicking known cheaters out of your server and it takes less then a day to review and accept your application (normally)....

[ImportBot]

Originally Posted by EBassie*:

 

You have 2 types of streaming which are lite and full and you don't need to have a clan, website, etc for lite option (that what I have at the moment since I dont have a ready website, clan, etc yet). With lite streaming option PBBans also will be kicking known cheaters out of your server and it takes less then a day to review and accept your application (normally)....

I know, I already said that earlier.

Now I was talking about why ty_ger07 was denied streaming in the past, before the Light version was there.

 

And when he makes the clanroster publicly available he probably can have the FULL version.

 

LIGHT is not as good as the FULL version.

[ImportBot]

Originally Posted by BF3-FairPlay*:

 

No, you should not need a port to connect to the database using php's mysql_connect() function.

 

Where is your database? Is your database hosted on the same webserver as http://www.bf3-fairplay.com/ , or hosted somewhere else?

 

Open phpmyadmin for that MySQL database. The majority of the correct connection details should be listed there.

 

For example:

 

In this example, you can see that the user name is 'tactournuser'. You can also see that the database is located at 'tactournuser.db.8362636.hostedresource.com'. The only other thing to know from that point is the database name and password.

Ok, I sorted this out. I had to type localhost instead of database host name that I use for remote connections. Also, I had to use a local login name (user name that I use to access cPanel) which doesn't make any sense to me...

[ImportBot]

Originally Posted by BF3-FairPlay*:

 

I know, I already said that earlier.

Now I was talking about why ty_ger07 was denied streaming in the past, before the Light version was there.

 

And when he makes the clanroster publicly available he probably can have the FULL version.

 

LIGHT is not as good as the FULL version.

All right, I got it.

 

It's a pity that the full streaming option is not available to me and I don't think it would be since I'm not planing on creating or joining any clans...

[ImportBot]

Originally Posted by ronald32*:

 

Hey thanks for the great work you did and i am having a issue i am able to connect to the database ans use the stats but when i use the playerstats.php that guy has created its doesn't show the battle stats but when i enter in my server everything works fine with the plugin and here is the link to website:

http://mysql.clanservers.com/player_stats.php

 

Pliz can you help me out what is going wrong i have used localhost,127.0.01,my server ip that is running mysql and none of them have solved the problem and i port forwarded 3306 and i can use another computer and connect to my mysql server with no problem i have also telnet my ip and port works perfect !! I got no idea why its not going!! Any help would be great thank you and btw i am new to this !!

[ImportBot]

Originally Posted by ty_ger07*:

 

Hey thanks for the great work you did and i am having a issue i am able to connect to the database ans use the stats but when i use the playerstats.php that guy has created its doesn't show the battle stats but when i enter in my server everything works fine with the plugin and here is the link to website:

http://mysql.clanservers.com/player_stats.php

 

Pliz can you help me out what is going wrong i have used localhost,127.0.01,my server ip that is running mysql and none of them have solved the problem and i port forwarded 3306 and i can use another computer and connect to my mysql server with no problem i have also telnet my ip and port works perfect !! I got no idea why its not going!! Any help would be great thank you and btw i am new to this !!

I have no experience with setting up a web server. Since you have chosen to host the database from your own computer, you need to figure out how to make it accessible from the web. Using 'localhost' or '127.0.0.1' from the website at http://mysql.clanservers.com will obviously not work since that is the local address of 'http://mysql.clanservers.com' and not your computer's internet address. Also make sure that your MySQL server is set up to allow remote access to the database because by default a MySQL database will only be allowed to be accessed by the local network.

 

On the other hand, if you are going to host the database from your computer, why not also host the website from your computer which is displaying the stats? There is no sense in using http://mysql.clanservers.com if you could just host it directly from your computer.

 

Or just do what 99% of the world does and host your database and website from rented web server space.

[ImportBot]

Originally Posted by russel5*:

 

Hi, I heed help.

Tell me why here http://otmopo3ku.pusku.com/_top25_countries=View

displayed Players with only UNKNOWN Country Code

Thanks

[ImportBot]

Originally Posted by ty_ger07*:

 

Hi, I heed help.

Tell me why here http://otmopo3ku.pusku.com/_top25_countries=View

displayed Players with only UNKNOWN Country Code

Thanks

Huh? Can you explain your question?

[ImportBot]

Originally Posted by russel5*:

 

Huh? Can you explain your question?

When you visit this page where you can see the players are sorted by country. But the players are only displayed with an unknown country, ie choose the Americas (counter shows 3) to open the list and it's empty.

But the problem I decided to rewrite some code. Thank you for your help.

[ImportBot]

Originally Posted by ty_ger07*:

 

So, did you get it working?

 

Is there a prpblem with the code? Or was the problem caused by you changing the code?

[ImportBot]

Originally Posted by russel5*:

 

when i changed the code, it working.

[ImportBot]

Originally Posted by ty_ger07*:

 

when i changed the code, it working.

So, what did you need to change to get it working?

[ImportBot]

Originally Posted by russel5*:
 
in my database ContryCode have this string -> ru, us, az
in code here

$CountryCode = strtoupper($country_row['CountryCode']);
$PlayerCount = $country_row['PlayerCount'];
$country_name = array_search($CountryCode,$country_array);
$count = ($count + 1);
?>
<div style='margin-left: auto;margin-right: auto;border-style: solid;border-width: 2px;border-color:#363636;width: 99%;background-color: #262626;border-radius: 10px;'>
<table width='100%' align='center' border='0'><tr>
<td style='text-align: left;' valign='top' width='2%'>  <font size='3'><a title="show/hide" id="<?php	echo "$CountryCode";	?>_link" href="javascript:void(0);" onclick="toggle(this, '<?php	echo "$CountryCode";	?>');">−</a></font></td>
<td style='text-align: left;' valign='top' width='4%'><font size='2'><?php	echo "$count:";	?></font></td>
<td style='text-align: left;' width='94%'>
<div style="border: 0px; padding: 0px;">
<table border="0" cellspacing="0" cellpadding="2" width="100%">
<tr>
<td width='25%' style='text-align: left;'><font color='#999999'><?php	echo "$country_name";	?></font></td>
<td width='25%' style='text-align: left;'><font color='#999999'>Country Code: </font><?php	echo "$CountryCode";	?></td>
<td width='50%' style='text-align: left;'><font color='#999999'>Player Count: </font><?php	echo "$PlayerCount";	?></td>
</tr>
</table>
<div id="<?php	echo "$CountryCode";	?>" style="padding:3px;">
<br/>
<div style='margin-left: auto;margin-right: auto;border-style: solid;border-width: 2px;border-color:#363636;width: 99%;background-color: #151515;border-radius: 10px;'><br/>
<?php
$country_count = '0';
$playerrank_query  = "SELECT tpd.SoldierName, tpd.CountryCode, tps.Score, tps.Kills, tps.Deaths, tps.Rounds FROM tbl_playerstats{$table_suffix} tps INNER JOIN tbl_server_player{$table_suffix} tsp ON tsp.StatsID = tps.StatsID INNER JOIN tbl_playerdata{$table_suffix} tpd ON tsp.PlayerID = tpd.PlayerID WHERE tsp.ServerID = '{$server_ID}' AND tpd.CountryCode = '{$CountryCode}' ORDER BY Score DESC LIMIT 10";

Php set CountryCode upper string, but database not have this string (upper)
So when php make list of players sorted by CountryCode, it's empty.
And i just add this in code

CountryCode10 = $country_row['CountryCode'];
$playerrank_query  = "SELECT tpd.SoldierName, tpd.CountryCode, tps.Score, tps.Kills, tps.Deaths, tps.Rounds FROM tbl_playerstats{$table_suffix} tps INNER JOIN tbl_server_player{$table_suffix} tsp ON tsp.StatsID = tps.StatsID INNER JOIN tbl_playerdata{$table_suffix} tpd ON tsp.PlayerID = tpd.PlayerID WHERE tsp.ServerID = '{$server_ID}' AND tpd.CountryCode = '{$CountryCode10}' ORDER BY Score DESC LIMIT 10";

Maybe this problem have defferent solution, but this help me solved my problem.

[ImportBot]

Originally Posted by ty_ger07*:

 

The php code has strtoupper() which converts the lowercase string in database to uppercase. There should have been no problem.

[ImportBot]

Originally Posted by russel5*:

 

I don't know why, but in my case this not work.

[ImportBot]

Originally Posted by ronald32*:

 

Hey mate thanks for the info can you help me out in how to setup a web server from home any info would be great I have made my sql to connect remotely and its works fine but only the web page doesn't work !!

[ImportBot]

Originally Posted by ty_ger07*:

 

Hey mate thanks for the info can you help me out in how to setup a web server from home any info would be great I have made my sql to connect remotely and its works fine but only the web page doesn't work !!

Like I said, I have no idea how to set up a web server accessible by the world wide web.

[ImportBot]

Originally Posted by ty_ger07*:

 

I am working on adding the GGC-Stream API back into the stats page for those who wish to use it.

 

I am just waiting on confirmation that the API is still supported and what needs to be done to get it working properly again.

 

$url = "http://api.ggc-stream.net/public/server/banlistmgr/{$serverId}/key/{$key}/format/json/do/{$type}/status/{$status}"; _?

 

EDIT: All the old code seems to still work by just changing from api.ggc-stream.com to api.ggc-stream.net.

[ImportBot]

Originally Posted by ty_ger07*:

 

removed

[ImportBot]

Originally Posted by ty_ger07*:

 

Code linked in first post updated.

 

Changes:

- Added GGC-Stream.net ban API back into the stats page.

-

- GGC-Stream requests now using curl() instead of file_get_contents() for security reasons.

- Added external link to metabans ban information.

- Added external link to cheat-o-meter information.

- Minor layout changes.

- Minor search engine optimization.

- Added 30 minute session tracking to count number of users viewing stats page.

For example:

44 users viewing these stats

data computed in 0.009 seconds

[ImportBot]

Originally Posted by ty_ger07*:

 

Working on adding scoreboard using XpKiller's stats plugin version 1.1.0.0.

 

score_board.jpg

 

Work in progress...

[ImportBot]

Originally Posted by ty_ger07*:

 

Code linked in first post updated.

 

Changes:

- Now REQUIRES PRoCon version 1.4.0.5 or higher and XpKiller's Stats plugin version 1.1.0.0 or higher.

- Added server stats.

- Added server scoreboard.

[ImportBot]

Originally Posted by ty_ger07*:

 

Code linked in first post updated.

 

Changes:

- Scoreboard now reports squad name instead of just squad number.

- Scoreboard now reports player's country name.

- Scoreboard now reports players loading in.

[ImportBot]

Originally Posted by russel5*:

 

Hi, ty_ger07. Use your new code, but i have a little bug

Code:

Strict Standards: gmmktime(): You should be using the time() function instead in /home/u371193945/public_html/stats/index.php on line 2336

Strict Standards: gmmktime(): You should be using the time() function instead in /home/u371193945/public_html/stats/index.php on line 2346

My server php version 5.4

http://otmopo3ku.pusku.com/stats