Stats page for XPKillers Stats Logger Plugin

[ImportBot]

Originally Posted by RMG-Dr4k3*:

 

We are release our Battlefield 3 server stat installer.

 

Webstat is using javascript. You must allow it in the browser, or the stat page not working good.

 

Support three languages: English, Deutsch, Hungarian

 

v1.0 - 2012-02-03 20:28

 

About the server stat:

Home page:

-Live server statistic

-Top server statistic

-Clan website

-Server Battlelog site

Players Page:

-All players statistics

-Order by all data

-Search player by name

Playerstat page:

-All type of ranks

-Kills, Deaths, K/D etc...

-Weapons statistics

-Battlelog profil

Maps page:

-List avarage datas of maps

-Show map image

Weapons

-List all of weapons by type

-Kills and Headshots

Messages

-List all messages

-Search chat player or message

 

Demo link: Webstat

 

 

v1.1- 2012-02-04 09:51

 

-Add escape to the querys.

-Renamed the BF3Conn.php to bf3conn.php

-Added suffix to the installer.

 

v1.2- 2012-02-04 16:20

 

-Add more escape

-Change player Battlelog Button

-Automated Server Join button

-Reworked sql query. Multiple query - to Join query

-Support multiple of servers

-Cleaned installer

 

v1.3- 2012-02-09 20:05

 

-Fix the installer problem.

-All players linked to the battlelog profile on the index page.

 

v1.4- 2012-02-14 21:12

 

-Fixed player search

-Reworked statistic querys. Thanks to XpKiller

-Fixed map image bug

-Limited player and message display

-Fixed chat list on index with multiple servers

 

v1.5 2012-02-17 18:32

 

-Fix blank page if map logging disabled

-Fix playerstat weapons. Add no data found if player not use any weapon

-Added changelog.txt

-Added 2 sec server checking. If game server is not responding, the stat page is using offline mode.

-Added version information the bottom of the page.

-Increased messages and players list 1000 to 1500

-Added error message if database file not created

-Cleaned up installer file

-Change squad colors. Added two color with 80% opacity.

 

If you use the updater, need to run the update.php.

Installer 1.5

 

Updater

 

Browsers pictures

 

-Safari 5

-IE9

-FireFox8

-Chrome16

 

sf5.jpgie9.jpgff8.jpgcr16.jpg

 

btn_donate_SM.gif

[ImportBot]

Originally Posted by XpKiller*:

 

@RMG-Dr4k3

i like you stats page

 

If you need help with those queries feel free to ask.

 

I must correct myself, even with one server linking PlayerID against the StatsID dont work all the time.

The Result is that some player seems not to update anymore. But they do because their statsid id different from PlayerID

 

i found some other bugs:

the Button to the battlelog always link to the same player.

in players.php somethings are not escaped yet.

The player country flags dont show up on a linux webserver due case sensitive. in they are lowercase but the images are spelled in uppercase.

[ImportBot]

Originally Posted by RMG-Dr4k3*:

 

@XpKiller

 

I'm thank's your work and help.

Make some changes in the stat page.

 

v1.2

 

-Add more escape

-Change player Battlelog Button

-Server Join button auto created from database

-Reworked sql query. Multiple query to Join query

-Support multiple of servers

-Cleaned installer

-Added uppercase function to national flags

 

The new installer: Install.zip

[ImportBot]

Originally Posted by RMG-Dr4k3*:

 

Version 1.2

 

v1.2

 

-Add more escape

-Change player Battlelog Button

-Automated Server Join button

-Reworked sql query. Multiple query - to Join query

-Support multiple of server

-Cleaned up installer

-Other color all the squads

-Disabled error if the procon layer is not updated to B2K

 

Download link

[ImportBot]

Originally Posted by RMG-Dr4k3*:

 

v1.2

 

-Add more escape

-Change player Battlelog Button

-Automated Server Join button

-Reworked sql query. Multiple query - to Join query

-Support multiple of servers

-Cleaned installer

 

Webstat v1.2

[ImportBot]

Originally Posted by beantje*:

 

hi,

 

nice work !

 

but when i instal this i get a white screen

 

http://gaming4fun.nl/Battlefield/index.php

 

any help ?

[ImportBot]

Originally Posted by quzo*:

 

both version dont work

v 1.1

Parse error: syntax error, unexpected T_STRING in database.php on line 9

v 1.2

Parse error: syntax error, unexpected T_STRING in database.php on line 16

[ImportBot]

Originally Posted by RMG-Dr4k3*:

 

rry.

 

I must go out to my home.

I am arrived and fix the installer problem.

v 1.3 works fine

 

Download

[ImportBot]

Originally Posted by ty_ger07*:

 

I was looking at your demo site. It looks good and promising, but it still has some issues to be fixed.

 

glitch.jpg

[ImportBot]

Originally Posted by beantje*:

 

thx for a quick update,

 

stil have a little problems like the map list wont work ?

http://gaming4fun.nl/Battlefield/index.php

 

And the messages i olso dont see

 

thx! nice work

[ImportBot]

Originally Posted by ty_ger07*:

 

thx for a quick update,

 

stil have a little problems like the map list wont work ?

http://gaming4fun.nl/Battlefield/index.php

 

And the messages i olso dont see

 

thx! nice work

Do you have map stats and chat logging enabled in XpKiller's plugin?

[ImportBot]

Originally Posted by micovery*:

 

Like the looks, and layout, but it's annoying that the whole page keeps getting reloaded. I think you should be able to do AJAX request in the background, and just load the data you need to update the HTML for the real-time info.

[ImportBot]

Originally Posted by Anvil-bw*:

 

very nice work

 

www.bf-3.net

www.nato-clan.com

[ImportBot]

Originally Posted by gabipaci*:

 

RMG-Dr4k3 can't reply to here.

Why?

Any Moderator can help?

 

Regards, Gabor

[ImportBot]

Originally Posted by leibhold*:

 

RMG-Dr4k3 can't reply to here.

Why?

Any Moderator can help?

 

Regards, Gabor

Next time PM someone - we dont read ALL posts 8-) - sent to Zaeed - god of the pages....

[ImportBot]

Originally Posted by Zaeed*:

 

Fixed

[ImportBot]

Originally Posted by gabipaci*:

 

Next time PM someone - we dont read ALL posts 8-) - sent to Zaeed - god of the pages....

Dr4k3 sent 3 PM for 3 different moderator, and no answer.

Zaeed, thanks for fixing.

[ImportBot]

Originally Posted by lupri*:

 

we have problem in the page setting:

 

clan website: ok

language: ok

mysql server, user and password: ok

 

server database?

table prefix?

table sufix?

 

we don't know how to set this 2 parameters...

 

our procon is working on a server, with the mysql server too. The site is on another server. the sql database is copied every 3 hours on the website server. how do i've to set this page?

[ImportBot]

Originally Posted by XpKiller*:

 

server database?

table prefix?

table sufix?

?

server database try the same as you entered in the procon plugin

table prefix: tbl?

table suffix the same as in procon plugin

[ImportBot]

Originally Posted by lupri*:

 

it works thanks

[ImportBot]

Originally Posted by XpKiller*:

 

There are still queries wrong in the statspage.

Like the Player search.

[ImportBot]

Originally Posted by RMG-Dr4k3*:

 

What's wrong in the player search?

 

edit: Found the problem. Im using Player-ID not the stats-id.

Make a change today.

[ImportBot]

Originally Posted by XpKiller*:

 

You search a Player and click on the name and get the entry of an other Player.

 

Example:

http://www.dpiens.webs.g-portal.de/players.php

 

Search for player: hauwechwienix

But you get the stats of Player: Hear_the_Voices

 

Also you should rework you queries for the rank calculation they are getting very slow on big DBs.

 

Use this Query to calculate the Playerrank for Kills, Score, Rounds, etc.

 

Code:

SELECT sub.PlayerID, sub.StatsID AS StatsID, sub.rank AS Rank
FROM (SELECT(@num := @num+1) AS rank, tsp.StatsID, tsp.PlayerID
        FROM tbl_playerstats tps 
        STRAIGHT_JOIN tbl_server_player tsp ON tsp.StatsID = tps.StatsID 
        INNER JOIN (SELECT @num := 0) x           
        WHERE tsp.ServerID = 1
        ORDER BY Score DESC) sub 
WHERE  sub.PlayerID = 115

This will be MUCH faster.

[ImportBot]

Originally Posted by ZUBAT2011*:

 

Hello I need some help with this its all installed but the maps page does not show any maps like on this site http://www.dpiens.webs.g-portal.de/maps.php that XPKiller posted can some 1 help me get the maps to show.ty for any help.

[ImportBot]

Originally Posted by RMG-Dr4k3*:

 

The only map is not showed, the operation fire storm.

Quick fix. Go to the maps folder on the ftp. And rename np_012.jpg to mp_012.jpg.

[ImportBot]

Originally Posted by ZUBAT2011*:

 

No on mine none of the maps show or info it just blank here is a photo =Death-Angels-Clan=BF3=Noobs=Welcome=24-7=20p=1p Start= Server stats.png please help me get this to show up.

The only map is not showed, the operation fire storm.

Quick fix. Go to the maps folder on the ftp. And rename np_012.jpg to mp_012.jpg.

[ImportBot]

Originally Posted by ty_ger07*:

 

No on mine none of the maps show or info it just blank here is a photo =Death-Angels-Clan=BF3=Noobs=Welcome=24-7=20p=1p Start= Server stats.png please help me get this to show up.

Do you have mapstats enabled in XpKiller's PRoCon plugin?

[ImportBot]

Originally Posted by ZUBAT2011*:

 

Ok I got it to work I dont have any ppl onthe server yet so i guess thats what it was the maps not lodding or something like that lol any ways i reinstalled it but the same thing so them i wet to the server admincp and started each map 1 at a time. that seems to got them on there for now and thank for the help guys..

[ImportBot]

Originally Posted by RMG-Dr4k3*:

 

New release is available in the first post.

Reworked some querys. Much faster. Thanks XpKiller.

Fixed map image. Limited player and message list.

[ImportBot]

Originally Posted by Narf!*:

 

I love your damn stats page. Just wanted to say that