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

[ImportBot]

Originally Posted by ty_ger07*:

 

Code linked in first post updated.

 

Changes:

- Includes Crossbow stats.

- Better handling of errors so less error data is displayed if an error occurs.

- Change from one background image to two and slight visual changes so that page will display properly for high resolution monitor users.

- Adjustment of rank logic to support multiple server IDs.

[ImportBot]

Originally Posted by ty_ger07*:

 

In another thread, this was asked:

 

Hi i have installed your web statistics and work fine.

Hi have a problem, i would like to exclude from the ranking my clan.

We haven't the battlefield clantag becouse it's too short but we are registred on origin with our_clan_name-our_nick.

Mysql side like:

Code:

SELECT 'SoldierName' FROM mydb.tbl_playerdata WHERE SoldierName NOT LIKE '%our_clan_name';

How do I change your code?

I'm not an expert in php code

Thank you.

Well, I honestly don't know why you would want your clan members to not know how well they are performing compared to the rest of the players in your server. But, if you wanted to do such a thing, it would be pretty simple to modify the queries to execute such a change.

 

I can give you examples but I don't know where all you would want this to be implemented. Would you want this change to be implemented only certain places? Or do you want to keep them from even searching for their names and seeing their stats?

 

 

 

 

For instance, if you just wanted to hide them from your Top 25 players page, you could make these changes:

 

Line 1809:

$sql = @mysql_query("SELECT COUNT(tpd.SoldierName), tps.Score 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.SoldierName NOT LIKE 'our_clan_name%' ORDER BY Score DESC");

 

Line 1842:

$sql = @mysql_query("SELECT tpd.SoldierName, 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.SoldierName NOT LIKE 'our_clan_name%' ORDER BY Score DESC LIMIT $offset, $rowsperpage");

 

The term "our_clan_name" would be the characters you want to filter out which is "our_clan_name" in your example. The "%" is important and you need to leave it because it means that only the names which start with "our_clan_name" are being filtered.

 

Line 1809 is where it is counting the total number of players and ranking them by score. Line 1842 is where it is actually getting each player's information and to display that information for each 25 player page. You need to modify both of them in this example.

 

 

 

 

If you wish to do the same thing in the Country Stats page, you would need to do a similar modification.

 

Line 1617:

$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}' AND tpd.SoldierName NOT LIKE 'our_clan_name%' ORDER BY Score DESC LIMIT 10";

 

 

 

Pretty simple. Rinse and repeat.

[ImportBot]

Originally Posted by diabolik1973*:

 

In another thread, this was asked:

 

 

 

Well, I honestly don't know why you would want your clan members to not know how well they are performing compared to the rest of the players in your server. But, if you wanted to do such a thing, it would be pretty simple to modify the queries to execute such a change.

 

I can give you examples but I don't know where all you would want this to be implemented. Would you want this change to be implemented only certain places? Or do you want to keep them from even searching for their names and seeing their stats?

 

 

 

 

For instance, if you just wanted to hide them from your Top 25 players page, you could make these changes:

 

Line 1809:

$sql = @mysql_query("SELECT COUNT(tpd.SoldierName), tps.Score 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.SoldierName NOT LIKE 'our_clan_name%' ORDER BY Score DESC");

 

Line 1842:

$sql = @mysql_query("SELECT tpd.SoldierName, 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.SoldierName NOT LIKE 'our_clan_name%' ORDER BY Score DESC LIMIT $offset, $rowsperpage");

 

The term "our_clan_name" would be the characters you want to filter out which is "our_clan_name" in your example. The "%" is important and you need to leave it because it means that only the names which start with "our_clan_name" are being filtered.

 

Line 1809 is where it is counting the total number of players and ranking them by score. Line 1842 is where it is actually getting each player's information and to display that information for each 25 player page. You need to modify both of them in this example.

 

 

 

 

If you wish to do the same thing in the Country Stats page, you would need to do a similar modification.

 

Line 1617:

$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}' AND tpd.SoldierName NOT LIKE 'our_clan_name%' ORDER BY Score DESC LIMIT 10";

 

 

 

Pretty simple. Rinse and repeat.

It work very well

I was close to the solution but i had forgotten the 'AND' operator

Thank you so much for your fast reply ,you are very kind

Good job my friend.

[ImportBot]

Originally Posted by ty_ger07*:

 

I am glad it's working well for you.

[ImportBot]

Originally Posted by th3hood*:

 

Merry Xmas ty_ger07, yes i changed db host, still had issues so i redid the tables separatly then added the data and now all good, free db host had altered the tables slightly :/ See you left me an Xmas pressie in the form an update, now let me see, what was it i changed :0 :0 :0

I see its snowing over at your place too

have a good holiday.

[ImportBot]

Originally Posted by ty_ger07*:

 

Merry Xmas ty_ger07, yes i changed db host, still had issues so i redid the tables separatly then added the data and now all good, free db host had altered the tables slightly :/ See you left me an Xmas pressie in the form an update, now let me see, what was it i changed :0 :0 :0

I see its snowing over at your place too

have a good holiday.

Thank you for the donation!

[ImportBot]

Originally Posted by ty_ger07*:

 

GGC-Stream has closed its doors.

 

Hello friends , acquaintances and communities,

 

sadly we have to inform you, that GGC-Stream will close its doors at 12/31/2012.

 

The Reason for this is that the personal background of some staff members has changed.

 

Another important reason is the missing cooperation Which has always been the spirit and purpose of GGC-Stream.

 

Hereby we do not think of the anticheat communities but the publishers and even balance as they do not provide real support for projects like GGC.

 

Furthermore PunkBuster has gotten vulnerable to miscellaneous modifications. We from GGC can not take responsibility for this way.

 

Sure, PunkBuster still does a good job, but it drops out more and more evidences that are needed for the work of GGC.

 

We are very grateful for your loyalty and for long lasting standing 100% behind us.

 

Even when there were some disagreements or when GGC which dragged in the mud on other boards.

 

Therefore a really big THANKYOU to everyone of you.

 

Sorry folks this is a hard step for GGC but the basic idea got lost.

 

This basic idea was "Together against cheaters".

 

Sadly this is a lost project without the support from the publishers or PunkBuster ( Even Balance ).

 

Thanks to all who supported us.

 

We wish all friends, acquaintances and the community all the best for the future.

 

So a happy new year.

 

Yours GGC Staff

As a consequence, the GGC-Stream functions of this stats page will no longer be supported. Cached bans in your database will still be displayed, but obviously no new players will be able to be added to your GGC-Stream ban list and those players listed as banned will no longer be restricted from entering your servers as GGC-Stream will no longer be actually operational.

[ImportBot]

Originally Posted by Rucki*:

 

Phu;

HYJ gamers!

No more words today.........

[ImportBot]

Originally Posted by ty_ger07*:

 

Code linked in first post updated.

 

Changes:

- GGC-Stream ban information removed due to GGC-Stream shutting down.

[ImportBot]

Originally Posted by EBassie*:

 

Code linked in first post updated.

 

Changes:

- GGC-Stream ban information removed due to GGC-Stream shutting down.

GGC is NOT shutting down:

https://twitter.com/kommissar_007/st...19997455376384

https://twitter.com/kommissar_007/st...23812489457664

 

Sounds like a staff / former staff member had a falling out. That or they hacked or someone gained access to a staff account.

[ImportBot]

Originally Posted by ty_ger07*:

 

GGC is NOT shutting down:

https://twitter.com/kommissar_007/st...19997455376384

https://twitter.com/kommissar_007/st...23812489457664

 

Sounds like a staff / former staff member had a falling out. That or they hacked or someone gained access to a staff account.

So what is up then?

 

They are not currently streaming. If you go to GGC-Stream.com it says they shut down. If you go to GGC-Stream.net they say they are moving. But your twitter information says that GGC-Stream.net is not official. So, that means GGC-Stream.com is still official which officially says that they shut down.

[ImportBot]

Originally Posted by EBassie*:

 

So what is up then?

 

They are not currently streaming. If you go to GGC-Stream.com it says they shut down. If you go to GGC-Stream.net they say they are moving. But your twitter information says that GGC-Stream.net is not official. So, that means GGC-Stream.com is still official which officially says that they shut down.

I think they got hacked or something like that.

 

The Twitter from Kommissar tells the truth I think. Let's see what happens in a few hours.

I really don't believe they are shutting down.

[ImportBot]

Originally Posted by ty_ger07*:

 

Well, I hope they aren't shutting down.

[ImportBot]

Originally Posted by HexaCanon*:

 

i always thought that game producers should have their own image streaming program to monitor players. evenbalance or ggcstream or pbbans can not handle all games.

 

on-topic i might give this plugin a try now that i have my database.

[ImportBot]

Originally Posted by LumpyNutZ*:

 

Here ya go, not hacked http://ggc.tpc-clan.de/

[ImportBot]

Originally Posted by ty_ger07*:

 

Here ya go, not hacked http://ggc.tpc-clan.de/

I know. I already quoted that whole page on page 25 of this thread.

( myrcon.net/...server-stats-page-for-xpkillers-bf3-chat-guid-stats-and-mapstats-logger#entry23261 )

 

EBastard is holding out hope that the website was hacked, an unofficial redirect was created, and that notification is fake.

[ImportBot]

Originally Posted by EBassie*:

 

GGC-Stream will NOT close it's doors. Our old project leader try everything to close it. A detailled information follows in some hours.

https://twitter.com/ggcstream/status/286036077159006208

 

There you go

 

Seems they have some big internal issues at GGC...

 

im Gegensatz zu dem, was derzeit beim Aufrufen unserer alten Adresse zu sehen ist, haben wir unsere Tore noch NICHT geschlossen, denn diese Nachricht spiegelt nur den Willen und die persönliche Meinung des jetzt ehemaligen Projektmanagers wieder. Wir sind ab sofort unter der Adresse www.ggc-stream.net erreichbar.

http://battlelog.battlefield.com/bf3...4348381817116/

 

In contrast to the message displayed on our old website we will NOT shut down as this message is only the will and personal opinion of our former project manager.

 

From now on we will only be available at this domain: www.ggc-stream.net.

http://battlelog.battlefield.com/bf3...90109514680/2/

[ImportBot]

Originally Posted by MorpheusX(AUT)*:

 

The GGC-page and the "redirect"-page are registered to the same person (the project leader of GGC). A hacker would probably need to compromise both pages and their hosting accout to place the redirect...

[ImportBot]

Originally Posted by MaydaX*:

 

Sounds like a staff / former staff member had a falling out. That or they hacked or someone gained access to a staff account.

I think they got hacked or something like that.

 

The Twitter from Kommissar tells the truth I think. Let's see what happens in a few hours.

I really don't believe they are shutting down.

Seems they have some big internal issues at GGC...

Looks like their Project leader Draco was the person who pulled the plug. http://ggc.tpc-clan.de is a sub domain belonging to a clan Draco is an admin of.

 

http://www.tpc-clan.de/modules.php_name=Forums

 

[ImportBot]

Originally Posted by EBassie*:

 

Well, whatever happens with GGC, I've stopped streaming to them. This is just too messy.

 

I really dislike the fact they are / were still issueing color / file tweaker bans after it was already rendered useless by latest patch....

 

 

 

Sent from my GT-I9100 using Tapatalk 2

[ImportBot]

Originally Posted by MaydaX*:

 

I really dislike the fact they are / were still issueing color / file tweaker bans after it was already rendered useless by latest patch....

They were? That would truly be a case of banning innocent players. PBBans removed all our MD5Tool checks that kicked for it after the patch was released and we seen the file protection DICE added couldn't be bypassed.

 

Then again DICE should have patched it long before the Dec DLC patch and avoided the need to ban for it in the first place.

[ImportBot]

Originally Posted by Kinsman*:

 

MaydaX, ever the master of diplomacy!

[ImportBot]

Originally Posted by EBassie*:

 

They were? That would truly be a case of banning innocent players. PBBans removed all our MD5Tool checks that kicked for it after the patch was released and we seen the file protection DICE added couldn't be bypassed.

 

Then again DICE should have patched it long before the Dec DLC patch and avoided the need to ban for it in the first place.

Yes Maydax, they still were banning for it after the patch. They justified their bans by saying those cas-files could still be used for tweaking / cheating.

 

There was a topic on their board about the ban of TheRussianBadger:

board.ggc-stream.com/showthre...eaker-bannable*

 

Too bad it's not properly cached by Google.

[ImportBot]

Originally Posted by MorpheusX(AUT)*:

 

I've just had a chat with one of the GGC-Staffmembers. Here's what I've been told:

 

Most important: GGC-Stream will continue their service. After internal disputes, GGC will now be "relaunched" under the new domain ggc-stream.net. Although they had to change their hoster, the ban information was still preserved and there should hopefully be no problem getting the streaming online as soon as possible.

[ImportBot]

Originally Posted by MaydaX*:

 

Yes Maydax, they still were banning for it after the patch. They justified their bans by saying those cas-files could still be used for tweaking / cheating.

Well that is dumb. The game kicks you for modified content if the cat.cas file is changed. Without it being modded the rest don't work. Wonder if they even tried it. I did and got the boot every time and it didn't change anything when using just the cas files the tweaker made.

 

Oh well maybe they will see the light someday. I've been doing this for 7 years, PBBans is nearly 10 year old and we always put the player first when it comes to the possibility of banning innocent players. Better to let a cheater go free than ban an innocent player.

 

/end rant

 

Bit off topic but banning innocent players always makes me shake my head.

[ImportBot]

Originally Posted by EBassie*:

 

Well that is dumb. The game kicks you for modified content if the cat.cas file is changed. Without it being modded the rest don't work. Wonder if they even tried it. I did and got the boot every time and it didn't change anything when using just the cas files the tweaker made.

 

Oh well maybe they will see the light someday. I've been doing this for 7 years, PBBans is nearly 10 year old and we always put the player first when it comes to the possibility of banning innocent players. Better to let a cheater go free than ban an innocent player.

 

/end rant

 

Bit off topic but banning innocent players always makes me shake my head.

MaydaX, you're right as always

[ImportBot]

Originally Posted by HexaCanon*:

 

Well that is dumb. The game kicks you for modified content if the cat.cas file is changed. Without it being modded the rest don't work. Wonder if they even tried it. I did and got the boot every time and it didn't change anything when using just the cas files the tweaker made.

 

Oh well maybe they will see the light someday. I've been doing this for 7 years, PBBans is nearly 10 year old and we always put the player first when it comes to the possibility of banning innocent players. Better to let a cheater go free than ban an innocent player.

 

/end rant

 

Bit off topic but banning innocent players always makes me shake my head.

i tried to do that but i got accused of being paid by hackers lol.

[ImportBot]

Originally Posted by MorpheusX(AUT)*:

 

Please keep the OT discussion to a minimum since the "main OT topic" has been resolved now. If needed, create a seperate thread in the OT section. Thanks!

[ImportBot]

Originally Posted by ty_ger07*:

 

I am sure that all GGC-Stream admins have already received this email... But just in case, I will post it here anyways to wrap up this discussion.

 

Dear GGC-server admin,

 

during the last days there were several rumors about the future of GGC. Please accept our apologies, but it wasn't possible to give you any detailed explanations or direct messages earlier, as we had to ensure that the data was secured, restored and working again. GGC-Stream will continue! We are aware about the rumors, but rest assured, these are just rumors.

There are some changes though:

• We have a new web address (GGC-Stream.NET). Please update your bookmarks.

• Because of a new forum software, it is necessary for you, to set up a new password. Use the "Lost password" function found in the forum. http://board.ggc-stream.net/index.php_form=LostPassword

• By moving to another data center, the IP's of the master servers have changed. Most of the streaming servers, have already received the new IP's automatically. If you encounter any problems, with the setup, please contact us via forum the ticket system (when it's available).

The new IP's are: "85.114.136.131" and "85.114.136.132"

• During the move, we were not be able to work on any tickets or etc, therefore you may have to wait longer for your answer. All tickets, servers and bans have been migrated successfully to our new system and they will be available again shortly.

We apologize for any inconvenience you may have encountered. All your tickets, servers and bans have survived the move and are available after a few changes. (If any)

 

sincerely your

GGC-admin staff

I guess I will have to add the GGC-Stream stuff back into this web stats page. If anyone wants to know why this stats page only supports GGC-Stream and not PBbans, the answer is that I happen to have been using GGC-Stream. I briefly looked into adding PBbans functionality into the stats page but became confused and overwhelmed by their API. 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.

[ImportBot]

Originally Posted by BF3-FairPlay*:

 

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.