BfBC2 Chat GUID and Stats Logger Webstats v1.21 [BC2]

[ImportBot]

Originally Posted by BB-Insomnia*:

 

Lastupdate: 24. January 2011

 

Hi folks,

 

here is a script for your homepage to view the Stats.

 

Features:

- Sorting by Name, Points, Kills, Deaths, Headshots, Dogtags, Rounds, Time, K/D, Headshots/Kill,Points/Round and Killstreak

- Mapstats provides infos about played rounds, player joined/left and average players per map

- Weaponstats for weapon and player

- embedded Teamspeakviewer

- embedded Gametrackerviewer

- embedded Serverinfo

- Playersearch by partial name

- Playersignatures

- Global Playerstats from bfbcs.com

- Top Killstreak Holder listed

- Live serverinfo with players & teams on click on serverinfo on mainpage

- Check if player already played on your server with different name

- Link to check if player is banned by evenbalanced.com via ggc-stream.com (external)

- Jump directly to page XX

- Show player who played in certain period (not the stats they earned on that date but total)

- VIETNAM SUPPORT! (hope so :-))

 

 

Installation / Update:

Upload all files to your Webspace and run install.php!

After updating, delete installer.php

Done!

 

Changelog:

v1.21

- Weaponstats bugfix

- Installer bugfix

- Serversummery bugfix

 

v1.20

- added Dogtags

- sigs should work now also for Vietnam servers

- a lot of changes in code

 

v1.11

- Fixed error in singleweaponstats (you only need to change index.php and single_weaponstats.php)

 

v1.10

- Added Headshots/Kill in Maintable

- Added Weaponstats for weapon and player

- Searching now also searches for Clantag

- Added several tooltips

- restyled info.php

- signatures fixed again!

- added wonderfull hovereffects

- rewritten pageselection

- added statssummary on top

- added uncountable bugs

- pretty buttons for mapstats and weaponstats

- customizable Stats summery

- CURL NOT NEEDED ANY MORE!

- Vietnam (more) compatible (please give feedback)

- sharedmode should also work now (please give feedback)

- updated fancybox

(pretty sure I forgot about 100 things)

 

v1.01

- changed $top to $top_killstreaks (should fix Top10-View of Killstreaks not even viewing the title)

 

v1.0

- Mapstats provides infos about played rounds, player joined/left and average players per map

- Added switch to change between tight layout for embedding in your cms and wide layout

- fully customizable with css

- lot of sourcecode cleaned

- Tooltips + Hovering

- Jump directly to page XX

- Show player who played in certain period (not the stats they earned on that date but total)

- VIETNAM SUPPORT!

 

v0.55

- Added check if player is banned via GGC-Stream.com

- Fixed GUID display

- Fixed no sig-banner if player has 0 deaths

 

v0.54

- Added check if player already played with other name on your server (Playerinfo)

 

v0.53

- Added EAGUID + GUID to playerinfo

- Changed playerinfo (easier copy&paste of IMG and GUID's)

- View should be centered on all browsers now

 

v0.52

- Added Vietnam Maps (waiting on confirmation if it work (have no Nam server)!)

- Centered Serverinfo view + border

 

v0.51

- Several Things

- added Playmode into the Serverinfo

- added Killstreak row

- added support for all maps

- added Playerlist and some Serverinfo on click on shown serverinfo on mainpage!

 

Requires:

phogue.net/forum/viewtopic.php_f=18&t=694* on Procon

outgoing connections allowed and Curl on your Webspace for fetching stats from bfbcs.com (ranks="1") NOT NEEDED ANY MORE!

outgoing connections allowed for $bc2conn_enable="1"

 

Livedemo: http://bc2.blood-boys.de

 

Downloads:

 

[ImportBot]

Originally Posted by Phogue*:

 

Cool 8-)

[ImportBot]

Originally Posted by Repoman1*:

 

I get this error Table 'ragining_bcstats.tbl_playerguid' doesn't exist . All my information to connect to my DB is correct.

[ImportBot]

Originally Posted by 101st-chicago*:

 

it depends if u are using a linux or windows MYSQL server.

 

linux is case sensitive..

 

I run both and notice that the linux DB has

 

tbl_ChatLog

tbl_PlayerGUID

 

then windows DB has

 

tbl_chatLog

tbl_playerguid

[ImportBot]

Originally Posted by Repoman1*:

 

linux base, I will look through his code to see if i can fix it.

[ImportBot]

Originally Posted by BB-Insomnia*:

 

Fixed it, new download link in first post

[ImportBot]

Originally Posted by Repoman1*:

 

I am now just getting a loading in the tab window. If my host doesn't allow 48888 port will make it hang on loading?

[ImportBot]

Originally Posted by Sp00k*:

 

I get the following error on map change and the plugin stops updating stats

 

 

Code:

Error in SQLQuery: System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 5.1 Driver]User phs_pcSp00k already has more than 'max_user_connections' active connections
ERROR [HY000] [MySQL][ODBC 5.1 Driver]User phs_pcSp00k already has more than 'max_user_connections' active connections
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)
at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions)
at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.Odbc.OdbcConnection.Open()
at PRoConEvents.CChatGUIDStatsLogger.SQLquery(String str_selectSQL, Int32 sort)

[ImportBot]

Originally Posted by 101st-chicago*:

 

already has more than 'max_user_connections' active connections

 

that is the issue

 

what is server max_user_connections at ?

 

maybe increase it a few

[ImportBot]

Originally Posted by BB-Insomnia*:

 

I am now just getting a loading in the tab window. If my host doesn't allow 48888 port will make it hang on loading?

Don't know what you mean with tab windows

 

I get the following error on map change and the plugin stops updating stats

 

 

Code:

Error in SQLQuery: System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 5.1 Driver]User phs_pcSp00k already has more than 'max_user_connections' active connections
..........

Do you get this error when you open the script in your browser or is it in procon?

[ImportBot]

Originally Posted by Sp00k*:

 

i get it in the procon layer console

[ImportBot]

Originally Posted by BB-Insomnia*:

 

i get it in the procon layer console

Please post your error here: viewtopic.php_f=18&t=694*

[ImportBot]

Originally Posted by Sp00k*:

 

lol i thought someone (you_) posted on that thread to post the errors in this one.. oh well

[ImportBot]

Originally Posted by Repoman1*:

 

Go here and see http://21stssclan.com/bc2stats1/

[ImportBot]

Originally Posted by BB-Insomnia*:

 

lol i thought someone (you_) posted on that thread to post the errors in this one.. oh well

This thread is only for the Webinterface for the BfBC2 Chat GUID and Stats Logger!

 

If you have any issues with procon (errors in procon/layer or the stats not logging) post here: viewtopic.php_f=18&t=694*

[ImportBot]

Originally Posted by Repoman1*:

 

=BB=Insomnia did you have a look at http://21stssclan.com/bc2stats1/ would this issue be because my web host has those ports blocked?

[ImportBot]

Originally Posted by BB-Insomnia*:

 

the page doesn't stop loading for me...

Seems like they block outgoing connections :-(

[ImportBot]

Originally Posted by Repoman1*:

 

Do you know a free service that I could use to link it from them?

[ImportBot]

Originally Posted by 28thCDM*:

 

Love it looks great and really simple to config kudos

I have one small problem I am getting this error when i click on a players name to get there personal stats

 

Code:

Fatal error: Call to undefined function curl_init() in /home/cdmcom/public_html/stats/info.php on line 76

any ideas on how to fix this my cms is Nuke Evolution Extreme 2.0.7

 

Many thanks for your hard work and ongoing support

 

stats page can be found here

http://www.stats.28cdm.com

[ImportBot]

Originally Posted by BB-Insomnia*:

 

Do you know a free service that I could use to link it from them?

There are several semifree hosters, search here in the forums!

 

Love it looks great and really simple to config kudos

I have one small problem I am getting this error when i click on a players name to get there personal stats

 

Code:

Fatal error: Call to undefined function curl_init() in /home/cdmcom/public_html/stats/info.php on line 76

You need Curl to be enabled on your webspace!

Ask your provider to enable it!

[ImportBot]

Originally Posted by BB-Insomnia*:

 

update according to latest changes in the logger plugin!

[ImportBot]

Originally Posted by Phogue*:

 

I've also mirrored the downloads on procons file host at www.phogue.net/procon/developers/insomnia/*

[ImportBot]

Originally Posted by BB-Insomnia*:

 

ah, ok, thanks!

how is the Changemap thingie going on?

you are back to school and i am on holiday for 2 weeks now... holidays until oct the 1st whooohooo

[ImportBot]

Originally Posted by poolacko*:

 

may not work on wamp? activate the curl ... check all settings several times but only get to see the blank page. : (

 

Yes... Dont work with WAMP!

 

http://www.chacalesofkrakus.com/bc2stats/

[ImportBot]

Originally Posted by BB-Insomnia*:

 

WAMP? something like xampp?

if so, it's just a collection of application for hosting.

on my xampp server it works fine.

 

set showerrors=1 and check the error.

set ranks=0 and bc2conn=0 and check if it works, if so, your host does not allow outgoining connections!

[ImportBot]

Originally Posted by BB-Insomnia*:

 

*smallupdate*

if you have problems with curl or outgoing connections, set ranks=0 and bc2conn_enable=0

and the stats should work on your webspace!

 

give me feedback please!

[ImportBot]

Originally Posted by HelloKitty*:

 

confired: running good on xampp 1.6 WinServ2k3 with "set ranks=1 and bc2conn_enable=0"

 

thx for that thingy.

[ImportBot]

Originally Posted by BB-Insomnia*:

 

noone else who tested it, and having problems before?

[ImportBot]

Originally Posted by JLNNN*:

 

Off-Topic: You should use the latest version of BC2Conn, not the very old one which included a "message" in the HTML sourcecodes. Get it here: http://bc2conn.sourceforge.net/

 

Have a nice day,

JLNNN

[ImportBot]

Originally Posted by GrossKopf*:

 

Is this the same code used for the Wolfcon stats? I noticed it's the same package, but wondered if some stuff was different in PRoCon.