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

[ImportBot]

Originally Posted by Dragon2203*:

 

I get this error:

[18:17:23 76] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [08S01] [MySQL][ODBC 5.1 Driver]Lost connection to MySQL server at 'waiting for initial communication packet', system error: 2

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

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

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

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

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

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

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

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

bei PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

[ImportBot]

Originally Posted by GitSum*:

 

That looks like the same error I was getting - look at post #554 >>>>myrcon.net/...chat-guid-stats-and-mapstats-logger#entry7095

 

I believe XpKiller fixed it with his latest patch and "High Performance Mode" because I am not seeing this error any longer

[ImportBot]

Originally Posted by Dragon2203*:

 

I am running the newest version 1.0.0.1 and I have enabled "close connection after each request" and also " High performance mode"

[ImportBot]

Originally Posted by XpKiller*:

 

I am running the newest version 1.0.0.1 and I have enabled "close connection after each request" and also " High performance mode"

Your error is not caused by plugin itself. So changes in plugin wont solve this problem.

To fix this: If you got this error instant check your firewall setting properly something is wrong. It seems that the answer of the mysql server dont reach the plugin.

If the firewall is fine try to raise the timeout in the odbc driver.

[ImportBot]

Originally Posted by Frakkas*:

 

@RMG-Dr4k3

This was a bug in previous version now the plugin should store data in Taurus_44_kills only.

 

@Gitsum and CptChaos

im aware of the problem in not sure yet what causes this because it is not every time.

Maybe a serverbug.

 

Edit:

If a round never started due less player this clomun stays empty too.

I put in a piece of code (hope you don't mind) that, if you have mapstats enabled and started a round, will continually update the round end time on an OnServerInfo event. This seems to have fixed my default RoundEndTime issue. This event seems to happen every 15 seconds or so, which is close enough for me. If you manually kick to next map, or do other such things, you can still get default start/end times, but I just cull those out periodically.

[ImportBot]

Originally Posted by XpKiller*:

 

@Frakkas

im aware of this bug. But lost much time in find those bug which causing odbc errors.

[ImportBot]

Originally Posted by Frakkas*:

 

@Frakkas

im aware of this bug. But lost much time in find those bug which causing odbc errors.

Oh, no worries. My little time problem is secondary to what you've been doing.

 

Does my solution sound reasonable? I always feel dirty hacking around a problem this way, without fully understanding why the MapEnd() wasn't being called from OnRoundOverPlayers, or why we might not get that event in the first place, but this stuff is painful to debug - especially when running on a layer server - so hack in a workaround it is! ;-)

 

This is all I did:

 

Code:

public override void OnServerInfo(CServerInfo csiServerInfo)
        {

            ...

            //Mapstats
            if (csiServerInfo.PlayerCount >= intRoundStartCount && this.Mapstats.TimeMapStarted == DateTime.MinValue)
            {
                this.Mapstats.MapStarted();
                //Frakkas
                this.continuousEndTime = true;
                //Frakkas
            }

            //Frakkas
            if (this.continuousEndTime == true)
            {
                this.Mapstats.MapEnd();
            }
            //Frakkas

            ...

        }

I also set the flag wherever else you call MapStarted() - which I should have just put in MapStarted(), but oh well....

[ImportBot]

Originally Posted by gabipaci*:

 

How to can i duplicate this plugin?

I would like to use two separated database.

First permanent, and second montly reseted.

 

Have u find the bug in playtime data?

 

Regards

[ImportBot]

Originally Posted by sp37zn4z*:

 

found a bug where when you type !TOP10 AFASLDKFJLASDFJLASKDJ (or any keyword that doesn't exist in the database) causes the procon client to crash to desktop. I use procon client not procon layer. Tried to rollback previous version and the bug disappears at version 0.1.2bet downwards. 0.1.3beta to latest version have this bug. Please check.

is it just me getting this bug?

[ImportBot]

Originally Posted by ty_ger07*:

 

is it just me getting this bug?

I haven't tested it. Most players in the server know nothing more than !stats or !rank so they are blissfully ignorant.

[ImportBot]

Originally Posted by Dragon2203*:

 

When I change the MySQL-database and enter a new one. How long does it last until the plugin creates new tables ?

Do I have to make some kills or anything else to build the tables ?

 

Edit: I just read that the plugins updates the stats at the end of a round ... so I think it will place the tables too at that moment or am I wrong?

 

Is it possible to copy existing tables from my old MySQL to the new one in order not to lose the existing ranks ?

[ImportBot]

Originally Posted by XpKiller*:

 

The plugin builds the tables before it try to get or write data. Also it tries to build the tables when you enable the plugin.

[ImportBot]

Originally Posted by Dragon2203*:

 

I just changed the MySQL-Database and enabled the plugin. Then I started a new map and joined the server. When I typed "!rank" it showed me the existing rank I had with the old database.

So if I am right I don't need to copy the tables ? So I can change the MySQL-database as often as I want but the ranking is also saved otherwhere ?

 

Now I diasbled the plugin to change some settings and the name of my database. I enabled again, changed the map but when somebody writes "rank" nothing happens.

 

Edit: and I get several warnings:

[18:50:17 83] Warning: Weapon: RoadKill is missing in the bf3.def file!!!

[18:57:41 92] Warning: Weapon: SoldierCollision is missing in the bf3.def file!!!

[18:58:31 62] Warning: Weapon: DamageArea is missing in the bf3.def file!!!

[19:01:35 14] Warning: Weapon: RoadKill is missing in the bf3.def file!!!

[ImportBot]

Originally Posted by XpKiller*:

 

i dont understand what you want to do?

If the new database is empty the plugin cant display a ranking. Because the ranking is saved in the Database.

 

Those warnings can be ignored.

[ImportBot]

Originally Posted by Dragon2203*:

 

When I change the Database and don't want to lose the ranking is there a possibility to copy the old Database and implement it in the new one ?

[ImportBot]

Originally Posted by XpKiller*:

 

make a Dump of the old Database and import the db on the new server.

Search mysql import export @ google

[ImportBot]

Originally Posted by gabipaci*:

 

i dont understand what you want to do?

If the new database is empty the plugin cant display a ranking. Because the ranking is saved in the Database.

 

Those warnings can be ignored.

I wolud like to use the logger for the webtat.

We will manage 12 months championship, and we need reset the stat every months.

And, i would like to other logger, will working with other webstat, and that will never resteted.

The question is, i need just rename and upload the second logger (eg: CChatGUIDStatsLoggerBF3for_permanent_webstat.cs) or have more things, what i need do?

[ImportBot]

Originally Posted by XpKiller*:

 

Rename the CChatGUIDStatsLoggerBF3.cs to CChatGUIDStatsLoggerBF3for_permanent_webstat.cs

 

And find this line:

public class CChatGUIDStatsLoggerBF3 : PRoConPluginAPI, IPRoConPluginInterface

And change it to

public class CChatGUIDStatsLoggerBF3for_permanent_webstat : PRoConPluginAPI, IPRoConPluginInterface

[ImportBot]

Originally Posted by gabipaci*:

 

Thanks!

[ImportBot]

Originally Posted by CptChaos*:

 

Otherwise you could make a second Procon install in a different folder on your disk.

[ImportBot]

Originally Posted by gabipaci*:

 

Otherwise you could make a second Procon install in a different folder on your disk.

No way, i have procon by our game server provider, i have ftp access, and i join with procon layer.

[ImportBot]

Originally Posted by sp37zn4z*:

 

hi guys,

 

is there any tutorial on how to incorporate the stats gathered by this plugin into a webstat? I see there is this thing called bf3conn webstat, but i haven't find any tutorial on how to setup this along with this plugin.

 

thanks

[ImportBot]

Originally Posted by lupri*:

 

hi, finally i installed mysql on my pc, which is running procon too. the plugin activates without crashing procon, so i think is well configured with everything.

 

sql server is set with the default configuration. where can i find now the logs?

 

sorry for the question, it's the first time i use mysql

 

thanks!!

[ImportBot]

Originally Posted by Dragon2203*:

 

@sp37zn4z:

Ther is no real tutorial for that. You have to check the forum for BC2Conn and manage the system used in scripts with the BF3Conn, because some functions changed or aren't logged in BF3 in procon (ex: Clantags not supported)

 

For the rest you have to know php and write a script by yourself. In what way the Tables of this plugin are used I don't know. Perhaps XPkiller can tell you if there is a tutorial just for that communication or which points are captured in which table.

 

 

@lupri:

 

There is no real Log. The MySQL-server saves the stats in Tables which can be read by the plugin.

This tables are "installed" automatically by the plugin when it starts running.

You can check if the tables are managed correctly by logging in to your MySQL-account and open the Database-url. There you will find a database whith the name you gave to it and in that, there are the tables.

[ImportBot]

Originally Posted by lupri*:

 

@ Dragon2203

 

thanks dragon. what you mean when you say "logging in to your MySQL-account and open the Database-url"? my server is on this machine with procon too. i think the database should be in any folder...

 

when i've found this database folder, how can i use these tables?

[ImportBot]

Originally Posted by Dragon2203*:

 

Oh ok you used as host "localhost"... for Localhost I don't know... i think you have to launch the phpMyAdmin or another tool which you used to create the database.

But you have to use the Username and password used in the plugin to log in your MySQL-Server.

 

Why do you want to "use" the tables? The tables stay on the same place and the plugin gets acces to them for the stats. You can write "!rank" on your gameserver to see the stats. Another use of the tables would be to use a Statspage or Gameserverviewer which gets the data of the tables and the plugin...

[ImportBot]

Originally Posted by XpKiller*:

 

@lurpi

A (mysql) database is not an excel sheet. So you cannot open it like a file. You need a tool like the MySQL workbench or phpmyadmin to view your data.

[ImportBot]

Originally Posted by GitSum*:

 

=BB=Insomnia is developing his Private Server Stats - which will be able to display the stats on a web page (worked great in BC2)

www.phogue.net/forumvb/showth...ease-BF3/page4*

 

Until then you will have to wing it or develop something on you own

[ImportBot]

Originally Posted by gabipaci*:

 

=BB=Insomnia is developing his Private Server Stats - which will be able to display the stats on a web page (worked great in BC2)

www.phogue.net/forumvb/showth...ease-BF3/page4*

 

Until then you will have to wing it or develop something on you own

Our webstat are 99% finished, U see here:

http://multistat.netgamezone.de/index.php

 

XpKiller: Can u check the played time please?

That is a last things, what we need to 100%

[ImportBot]

Originally Posted by XpKiller*:

 

@gabipaci

i have time to check this tomorrow

Also i'm working on a much faster ranking system.

Some query will run 3x faster. This is good for Webstats usage. and also reduce the stress on the db.

 

btw:

Your webstats look sweet nice work.

I like it!