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

[ImportBot]

Originally Posted by MorpheusX(AUT)*:

 

Well, the best guess is:

Code:

Access denied for user 'wayne_hawes'@'109.70.148.109' (using password: YES)

Seems like the user doesn't have appropriate privileges.

 

@ronald32: well, then there's your problem. The connection/distance are probably too slow to allow quick loading of the webpage. Is there any real reason for keeping them at a homeserver and not moving the database to a dedicated provider?

[ImportBot]

Originally Posted by ronin*:

 

Hi ive attached 2 pics one of all the priv and the mysql ver ect so im not sure whats going on .

 

mver.jpgpriv.jpg

 

Thanks Wayne

 

EDIT

 

Ah think i just found out why . Is it becuase my hosting is with hostgator and there still using the old auth ver ? if so if the old odbc ver of the plugin is used it should work yes ? .

[ImportBot]

Originally Posted by Hutchew*:

 

Branzone offers a tinyhost server for $4.00 a month, unlimited DB's and remote connections accepted.

 

It's what we use and is blazing fast on our webadmin and stats pages.

 

FYI

 

 

Hutchew

[ImportBot]

Originally Posted by cc*:

 

Does anyone know of a webpage addon for this plugin that would show all these collected stats in a SINGLE leaderboard? Our server has changed IP so many times, that the stats are a mess now, they are listed as 4 servers instead of 1, so our web based leaderboard shows 4 servers too, all though the in game stats are correct, that correctly combines the stats, but it would be nice if I could show the combined stats at our website too.

[ImportBot]

Originally Posted by ty_ger07*:

 

The option to combine the stats (so server id isn't taken into consideration) is a feature which could be added.

[ImportBot]

Originally Posted by cc*:

 

That would be a great addition.

[ImportBot]

Originally Posted by ty_ger07*:

 

Does anyone know of a webpage addon for this plugin that would show all these collected stats in a SINGLE leaderboard? Our server has changed IP so many times, that the stats are a mess now, they are listed as 4 servers instead of 1, so our web based leaderboard shows 4 servers too, all though the in game stats are correct, that correctly combines the stats, but it would be nice if I could show the combined stats at our website too.

Since I have no way of testing this (my database doesn't have multiple server IDs for the same server due to moving the server around), I will have to ask XpKiller how this should be properly handled.

 

I believe that it is a simple task of modifying the query if necessary to not take into account server IDs.

[ImportBot]

Originally Posted by cc*:

 

Since I have no way of testing this (my database doesn't have multiple server IDs for the same server due to moving the server around), I will have to ask XpKiller how this should be properly handled.

 

I believe that it is a simple task of modifying the query if necessary to not take into account server IDs.

I can give you access to our database if you need.

[ImportBot]

Originally Posted by ty_ger07*:

 

I have asked XpKiller. I am awaiting his response. All I need to do is verify how his plugin combines the server stats in the game and then do the same for the web stats page. It should be an easy task; I just want his verification so that I do it correctly.

[ImportBot]

Originally Posted by ty_ger07*:

 

I am still waiting for XpKiller's reply.

 

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

[ImportBot]

Originally Posted by cc*:

 

I am still waiting for XpKiller's reply.

 

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

I believe you posted in an out of date thread, unless I'm mistaken, this seems to be the current thread for the stats logger: showthread....-0-BF3/page163*

[ImportBot]

Originally Posted by XpKiller*:

 

It seems that i overseen it:

 

Code:

SELECT tpr.rankScore, tpd.PlayerID , tpd.Soldiername,  SUM(tps.Score) AS Totalscore,  SUM(tps.Kills) AS Totalkills, SUM(tps.Headshots) AS Totalheadshots, SUM(tps.Deaths) AS Totaldeaths
FROM tbl_server ts  
INNER JOIN tbl_server_player tsp ON tsp.ServerID = ts.ServerID
INNER JOIN tbl_playerstats tps  ON  tsp.StatsID = tps.StatsID
INNER JOIN tbl_playerdata tpd ON tsp.PlayerID = tpd.PlayerID
INNER JOIN tbl_Playerrank tpr ON tpd.PlayerID = tpr.PlayerID 
WHERE ts.ServerGroup = 0 AND tpr.ServerGroup =  ts.ServerGroup AND tpr.rankScore BETWEEN 1 AND 20
GROUP BY tsp.PlayerID 
ORDER BY tpr.rankScore ASC;

Basically Select the ServerGroup and Group BY PlayerID

 

myrcon.net/.../advanced-in-game-admin-and-ban-enforcer-adkats

[ImportBot]

Originally Posted by ty_ger07*:

 

Yes, sorry, I posted the request in an old abandoned thread.

 

Speaking of abandoned...

 

I am abandoning a lot of stuff and moving on. On the chopping block is support of this code.

 

If someone is interested, they should feel free to use my base work and adapt it as necessary.

 

[ImportBot]

Originally Posted by ty_ger07*:

 

Code linked to in first post updated!

 

Changes:

- Added new End Game maps

- Added new End Game modes

 

As stated though, support is being abandoned so don't expect many more updates to this code from me.

[ImportBot]

Originally Posted by cc*:

 

No chance for the merged leaderboard option then?

[ImportBot]

Originally Posted by ty_ger07*:

 

No chance for the merged leaderboard option then?

People are free to take my code and edit it. It should be pretty easy to incorporate.

 

I have been supporting this for over a year and it is time to move on.

[ImportBot]

Originally Posted by ty_ger07*:

 

No chance for the merged leaderboard option then?

I am simply taking a break from this sort of thing and focusing more on other things in my life. There are a lot of things I am distancing myself from.

 

My code is well structured and well commented. It should not be hard for anyone with a PHP background to continue developing this code from where I left off.

[ImportBot]

Originally Posted by ozplanet*:

 

I modified the base code so it can be used as a WordPress Plugin. If I find there is enough interest I might package it up for download.

 

Let me know if your interested...The site is not currently live I am still developing our new clan site.

 

Here are some screenshots.

 

Server List

List.jpg

 

Country Stats

Country.png

 

Map Stats also broken down by Day of Week

MapStats.jpg

 

The WordPress theme we are using is inFocus.

[ImportBot]

Originally Posted by alexrayden*:

 

I modified the base code so it can be used as a WordPress Plugin. If I find there is enough interest I might package it up for download.

 

Let me know if your interested...The site is not currently live I am still developing our new clan site.

 

Here are some screenshots.

 

Server List

List.jpg

 

Country Stats

Country.png

 

Map Stats also broken down by Day of Week

MapStats.jpg

 

The WordPress theme we are using is inFocus.

I might be interested but for joomla

[ImportBot]

Originally Posted by lesmoky*:

 

hello,

 

Thanks for this very nice script and your hard work!!!!

It works fine and looks good.

 

i have edit the "player_stats.css" and change 2 pictures for a "dark-yellow-theme".

You can see our statspage and download the "theme-files" in my signatur or >>>here

 

 

greet LE-Sm0ky

[ImportBot]

Originally Posted by ty_ger07*:

 

I sold the website and hosting space. I no longer have any control over the code provided.

[ImportBot]

Originally Posted by diabolik73*:

 

Hello I have a problem with "Suspicios" and "Banned" pages.

What's the problem?

Thank you

 

Attached Files:

• Cattura2.PNG
• Cattura.PNG

[ImportBot]

Originally Posted by ty_ger07*:

 

Hello I have a problem with "Suspicios" and "Banned" pages.

What's the problem?

Thank you

The CURL extension ext/curl is not installed or enabled in your PHP installation. Check the WAMP manual for information on how to install or enable CURL on your system.

[ImportBot]

Originally Posted by diabolik73*:

 

The CURL extension ext/curl is not installed or enabled in your PHP installation. Check the WAMP manual for information on how to install or enable CURL on your system.

Great you are the best. I fix the problem, wamp have a bug in php_curl

Fix in this thread http://forum.wampserver.com/read.php_2,85716

Thank you very much and good job

[ImportBot]

Originally Posted by diabolik73*:

 

Hello,

which plugin I should install to clean my server?

http://thetacteam.info/player_stats2...d_players=View

thank you

[ImportBot]

Originally Posted by ty_ger07*:

 

What is the question? That is a GGC-Stream admin ban list.

 

Looks like they banned me LOL.

[ImportBot]

Originally Posted by diabolik73*:

 

What is the question? That is a GGC-Stream admin ban list.

 

Looks like they banned me LOL.

ok thank you very much

[ImportBot]

Originally Posted by p19blo*:

 

hello i have the page installed fine. but it isnt actually showing any stats from either of my servers.

 

the db options in player_stats_main.php what should they be ? my web host db or my server db s they are both hosted by seperate partys.

 

http://www.battlefieldsquad.com/bftw...stats_main.php

[ImportBot]

Originally Posted by Flaxe*:

 

I'm using the latest version of the webpage, all the data is being stored correctly in the MySQL database, but when I look at one of my server statpages and try to see the stats for a specific player, it don't show any stats.

 

I have tried to download the webpage files again and do it all from beginning, and also deleted the database and created a new one, but it still don't work.

It's only the first server that it don't work on. Second server work good and they are in the same database.

http://mullers-mk.se/bf3/server1.php

[ImportBot]

Originally Posted by p19blo*:

 

the banned players tab doesnt even show up for me on any of my servers

 

Edit noob remark from myself. i dont use ggc