Chat, GUID, Stats and Mapstats Logger[1.1.0.1][BF3]

[ImportBot]

Originally Posted by XpKiller*:

 

Got exactly the same problem. Configured everything. But once i enable it: Boom procon layer crashes... Anything that i might have done wrong?

Post you logs.

 

In 99% of all cases the error will be in it.

[ImportBot]

Originally Posted by ty_ger07*:

 

New Version is coming this weekend.

Yay!

[ImportBot]

Originally Posted by RMG-Dr4k3*:

 

We are release our Battlefield 3 server stat installer.

 

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

 

Download link: Installer.zip

 

Demo link: Webstat

 

This is the first release. Based on XpKiller procon plugin.

Please move to the enhancements section.

[ImportBot]

Originally Posted by XpKiller*:

 

@RMG-Dr4k3

Some querys are not correct.

You link the PlayerID with the StatsID this works with one server only!

The correct way would be:

tbl_playerdata tbl_server_Player tbl_playerstats, tbl_weapon_...

 

You could make your life easy and the script faster if you would use joins.

 

Server which uses a table suffix wont work either with this script.

 

On linux server you will get problems too due linux is case sensitive (BF3Conn.php --> bf3conn.php)

 

Also this script is highly vulnerable against sql injections

[ImportBot]

Originally Posted by Klaauw*:

 

That happens to me if I don't have the connection to the database setup properly. Where is the database and where is procon being hosted - is the ODBC driver installed?

Procon is hosted at gameservers.com. When you asked me this question I searched the topic and it seems that that is the problem . Is it possible to locate procon layer hoster at another hoster provider without having troubles to connect to a server of gameservers.com?

 

BTW sql host is hosted at my place with a Synology NAS. All settings should be allright on that one.

[ImportBot]

Originally Posted by GitSum*:

 

No, Procon does not have to be with game server provider. Branzone and rcon hosting appear to be pretty popular and should work

[ImportBot]

Originally Posted by Vetula*:

 

We are release our Battlefield 3 server stat installer.

 

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

 

Download link: Installer.zip

 

Demo link: Webstat

 

This is the first release. Based on XpKiller procon plugin.

Please move to the enhancements section.

Nice

 

we have to on the Homepage Server-Stats :

 

You can look here : http://www.bf3fl.org/index.php/server-stats.html

[ImportBot]

Originally Posted by kolsyra*:

 

Hi,

 

I've installed the plugin correctly to my procon software. I have MYSQL on my pc, same pc im running procon. I also installed ODBC.

My server is hosted at gameservers. Ist it possible for it to work this way?

 

The db only recognize "tbl_server". No errors, nothing. I really want this plugin to work.

[ImportBot]

Originally Posted by XpKiller*:

 

@kolsyra

Yes this will work.

The Stats are writte to the db after each round.

Only the tbl_server gets updated every 30 seconds.

[ImportBot]

Originally Posted by GitSum*:

 

When I am setting up a new connection or database - I go into the server and type a chat message (date and time when database was started) - it should show up in tbl_chatlog immediately (using phpmyadmin to view it). I then advance the server to the next map (if it is empty) and it should then show at least one player in tbl_playerdata

[ImportBot]

Originally Posted by beantje*:

 

it dont work no more ?

 

[22:42:24 76] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '46.249.40.158' (10061)

ERROR [HY000] [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '46.249.40.158' (10061)

at System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle, RetCode retcode)

at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcCo nnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)

at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConn ection outerConnection, OdbcConnectionString connectionOptions)

at System.Data.Odbc.OdbcConnectionFactory.CreateConne ction(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)

at System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

at System.Data.Odbc.OdbcConnection.Open()

at PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

[22:42:27 72] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '46.249.40.158' (10061)

ERROR [HY000] [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '46.249.40.158' (10061)

at System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle, RetCode retcode)

at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcCo nnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)

at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConn ection outerConnection, OdbcConnectionString connectionOptions)

at System.Data.Odbc.OdbcConnectionFactory.CreateConne ction(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)

at System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

at System.Data.Odbc.OdbcConnection.Open()

at PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

[ImportBot]

Originally Posted by XpKiller*:

 

@beantje

 

The mysql server is not reachable anymore.

 

getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '46.249.40.158' (10061)

[ImportBot]

Originally Posted by beantje*:

 

but on the site http://gaming4fun.nl/Battlefield/player_stats.php

 

changes the stats ?

[ImportBot]

Originally Posted by ty_ger07*:

 

No. Coincidence.

[ImportBot]

Originally Posted by XpKiller*:

 

I would say the plugin is locked out from the mysql server

Maybe because of a firewall

[ImportBot]

Originally Posted by ty_ger07*:

 

but on the site http://gaming4fun.nl/Battlefield/player_stats.php

 

changes the stats ?

Sorry for my hasty reply earlier which offered little help.

 

The stats page makes absolutely no changes to the database. It is not possible for it to cause you problems. All it does is read what is already there.

 

But, while you are at it, I recommend that you update your stats webpage code. The code you are using is quite old and has some display errors and is lacking some features.

 

www.phogue.net/forumvb/showth...apstats-Logger*

[ImportBot]

Originally Posted by humanbait*:

 

Cant start procon anymore after i install this plugin, it keeps crashing.

what am i doing wrong ?

[ImportBot]

Originally Posted by ctgbalu*:

 

wir haben das gleiche Problem seit gestern.Das plugin crasht den Layer Server sowie auch meine lokale Installation von Procon,hat bis jetzt immer funktioniert.

Info:

Spiel BF3 Server Version R19

Plugin Version:CChatGUIDStatsLoggerBF3[1.0.0.1]

Unsere Stats Seite:http://45034.vs.webtropia.com/bf3/player_stats.php

DB Server ist unser eigener

[ImportBot]

Originally Posted by ctgbalu*:

 

wir haben das gleiche Problem seit gestern.Das plugin crasht den Layer Server sowie auch meine lokale Installation von Procon,hat bis jetzt immer funktioniert.

Info:

Spiel BF3 Server Version R19

Plugin Version:CChatGUIDStatsLoggerBF3[1.0.0.1]

Unsere Stats Seite:http://45034.vs.webtropia.com/bf3/player_stats.php

DB Server ist unser eigener

[ImportBot]

Originally Posted by GitSum*:

 

Cant start procon anymore after i install this plugin, it keeps crashing.

what am i doing wrong ?

I would say that it is a connection problem to the database that is causing it to crash. Where is Procon being hosted and where is the database located?

 

to start Procon - if can you access the .cfg file for the layer (it is inside the Configs folder). Open up that file with notepad, look for

 

procon.protected.plugins.enable "CChatGUIDStatsLoggerBF3" True

 

change the True to False and try to start it

[ImportBot]

Originally Posted by Polak*:

 

Hi there! Guys I need this plugin so much, but I just noticed that Procon hosted with GameServers can't run this. Is there any free procon hosting? If not, can you tell me what should I do?

[ImportBot]

Originally Posted by GitSum*:

 

Take a look at Branzone or rconhosting

 

Branzone charges $3 a month for one layer and it should work fine with this plugin - but you still need a database somewhere

[ImportBot]

Originally Posted by Polak*:

 

No problem with that I have web site with all that stuff, my problem is the Procon.

 

For example. If I steup procon in other PC like laptop only with this plugin and the GameServers Procon for all the others plugins... Will it work or no?

[ImportBot]

Originally Posted by GitSum*:

 

It should work -

 

What you want to do is use your account at GameServers for your layer server and all of your plugins except this one.

 

Then you want to setup a procon on your home laptop and just use this plugin to stream the data to you database at your website

 

I have actually been playing around with a similar setup using a free "micro instance" at Amazon. It has only been running for about a week, but so far so good

[ImportBot]

Originally Posted by XpKiller*:

 

No new Version today

found so bugs which need to fixed first

Maybe i release tomorrow.

[ImportBot]

Originally Posted by Klaauw*:

 

K everything seems to work allright for me now. Only have one thing that I don't know and don't know how to fix is that some messages don't show up on the server. While they are in my message log. Is this a communication error?

[ImportBot]

Originally Posted by LR_dev*:

 

First of all: Thanks for this awesome plugin!

 

Second: I h ave an issue

 

Im getting errors on one of the two servers i use this on.

 

I have a PC that functions as a home server on which i run ProCon, this plugin and the MySQL database (with the ODBC connector).

 

We have a wake server that gives no errors.

The other server (karkand one) does give errors, the following:

 

Code:

[18:55:01 92] Error: Error in Startstreaming: 
[18:55:01 95] Index #0
[18:55:01 97] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.20]Cannot add or update a child row: a foreign key constraint fails (`procon`.`tbl_server_playerkarky`, CONSTRAINT `fk_tbl_server_player_tbl_serverkarky` FOREIGN KEY (`ServerID`) REFERENCES `tbl_serverkarky` (`ServerID`) ON DELETE CASCADE ON UPDATE NO ACTION)
[18:55:01 98] Native: 1452
[18:55:01 98] Source: myodbc5.dll
[18:55:01 99] SQL: HY000

As you can see i put "karky" in the plugin;s settings as a suffix to make the difference (or is my mistake in that_) I didnt give the wake server a suffix.

 

Please advice!

[ImportBot]

Originally Posted by ty_ger07*:

 

First of all: Thanks for this awesome plugin!

 

Second: I h ave an issue

 

Im getting errors on one of the two servers i use this on.

 

I have a PC that functions as a home server on which i run ProCon, this plugin and the MySQL database (with the ODBC connector).

 

We have a wake server that gives no errors.

The other server (karkand one) does give errors, the following:

 

Code:

[18:55:01 92] Error: Error in Startstreaming: 
[18:55:01 95] Index #0
[18:55:01 97] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.20]Cannot add or update a child row: a foreign key constraint fails (`procon`.`tbl_server_playerkarky`, CONSTRAINT `fk_tbl_server_player_tbl_serverkarky` FOREIGN KEY (`ServerID`) REFERENCES `tbl_serverkarky` (`ServerID`) ON DELETE CASCADE ON UPDATE NO ACTION)
[18:55:01 98] Native: 1452
[18:55:01 98] Source: myodbc5.dll
[18:55:01 99] SQL: HY000

As you can see i put "karky" in the plugin;s settings as a suffix to make the difference (or is my mistake in that_) I didnt give the wake server a suffix.

 

Please advice!

XpKiller recommends that you do not use suffixes. He says that the second server will automatically get a server ID of 2 instead of 1 and will have no conflicts with being in the same tables as server 1. He says not using suffixes is also faster and more efficient.

[ImportBot]

Originally Posted by XpKiller*:

 

First of all: Thanks for this awesome plugin!

 

Second: I h ave an issue

 

Im getting errors on one of the two servers i use this on.

 

I have a PC that functions as a home server on which i run ProCon, this plugin and the MySQL database (with the ODBC connector).

 

We have a wake server that gives no errors.

The other server (karkand one) does give errors, the following:

 

Code:

[18:55:01 92] Error: Error in Startstreaming: 
[18:55:01 95] Index #0
[18:55:01 97] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.20]Cannot add or update a child row: a foreign key constraint fails (`procon`.`tbl_server_playerkarky`, CONSTRAINT `fk_tbl_server_player_tbl_serverkarky` FOREIGN KEY (`ServerID`) REFERENCES `tbl_serverkarky` (`ServerID`) ON DELETE CASCADE ON UPDATE NO ACTION)
[18:55:01 98] Native: 1452
[18:55:01 98] Source: myodbc5.dll
[18:55:01 99] SQL: HY000

As you can see i put "karky" in the plugin;s settings as a suffix to make the difference (or is my mistake in that_) I didnt give the wake server a suffix.

 

Please advice!

im sry this suffix stuff is not well tested and not needed anymore

It is a relic of the previous plugin for BFBC2.

i can try to fixed that but this easiest would be to use no suffix.

The plugin supports up to 65k different server in one DB.

 

Please check if all the tables with the suffix exists.

[ImportBot]

Originally Posted by LR_dev*:

 

thanks, seems to solve my issue. No onwards to the finding and customizing of a nice stats-page, yours perhaps