Jump to content

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

ImportBot

By ImportBot
in Plugins

Recommended Posts

ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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.

* Restored post. It could be that the author is no longer active.
Link to comment
  • Replies 1.9k
  • Created
  • Last Reply

Top Posters In This Topic

  • ImportBot

    1934

Popular Days

Top Posters In This Topic

Popular Days

ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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.

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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 :sad:. 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.

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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 :smile:

 

we have to on the Homepage Server-Stats :

 

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

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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.

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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)

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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)

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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*

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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?

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by Polak*:

 

No problem with that :smile: 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?

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

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?

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by LR_dev*:

 

First of all: Thanks for this awesome plugin!

 

Second: I h ave an issue :ohmy:

 

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!

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by ty_ger07*:

 

First of all: Thanks for this awesome plugin!

 

Second: I h ave an issue :ohmy:

 

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.
* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by XpKiller*:

 

First of all: Thanks for this awesome plugin!

 

Second: I h ave an issue :ohmy:

 

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.

* Restored post. It could be that the author is no longer active.
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
Go to topic listing


×
×
  • Create New...

Important Information

Please review our Terms of Use and Privacy Policy. We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.