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

[ImportBot]

Originally Posted by XpKiller*:

 

Setup the odbc datasource as system dsn or run the service under an other user with user den entry. The windows service works without any problem with this plugin.

[ImportBot]

Originally Posted by Mandizzy*:

 

XpKiller, any solution to problem listed 3 posts above?

[ImportBot]

Originally Posted by XpKiller*:

 

Atm not.

 

Especially the duplicate key issue is strange be it managed by the database I guess the chatlog table is corrupted.

 

Do you host everything by yourself?

[ImportBot]

Originally Posted by Mandizzy*:

 

Yes, it's hosted on my PC and interesting enough, ever since I turned off chat logging because of this problem - the other problem of procon hanging every few hours has also went away! I was actually checking the code and was confused why you decided to use a separate DB connection for chat logging? It's the same DB!

[ImportBot]

Originally Posted by XpKiller*:

 

I need to use multiply connection to use the threads.

ODBC dont support parallel queries over on connection.

 

the 2. reason is that myisam dont support transactions.

 

That it is the same DB is irrelevant. To maintain a high performance i must to use multiply connections simultaneous, because innodb (the most tables of the plugin are innodb tables) is transactionbased and you only can start one transaction per connection.

 

 

i think you chatlog table is damaged. MyISAM table can get damaged easily.

 

you should execute the repair statement on it.

[ImportBot]

Originally Posted by Mandizzy*:

 

Repair table fixed it for me - thanks.

 

One question for you - in table tbl_playerstats, how is playtime stored in here? As in milliseconds or seconds? For example, my own playtime is 4284528 - what does it translate into? ~1190 hrs?

[ImportBot]

Originally Posted by TimSad*:

 

It's strange! You know how the with 5.1.11 ODBC drivers dates aren't being recorded with the method used by this plugin? Well, for me, around 2-4 logged chat lines a day actually somehow get a timestamp... http://socbf3.site.nfoservers.com/bf...s/messages.php

[ImportBot]

Originally Posted by Cire*:

 

i have set up the msql and the currency plugin seems to be working but when i turn on the bf3 stats this is the error i get , i need help please. ive tested the setup with the procon dbase and test connection is good. no errors on currency just this. please help. ive save the info in the options for plugin too(outgoing info)

 

[21:55:14 46] Error in Tablebuilder:

[21:55:14 46] Index #0

[21:55:14 46] Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

[21:55:14 46] Native: 0

[21:55:14 48] Source:

[21:55:14 48] SQL: IM002

[21:55:14 48] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[21:55:15 49] BF3 Chat, GUID and Stats Logger Disabled

[21:55:16 48] Error in Tablebuilder:

[21:55:16 48] Index #0

[21:55:16 48] Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

[21:55:16 48] Native: 0

[21:55:16 48] Source:

[21:55:16 48] SQL: IM002

[21:55:16 48] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[21:55:16 48] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [iM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

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)

[21:55:18 48] Error in Tablebuilder:

[21:55:18 48] Index #0

[21:55:18 48] Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

[21:55:18 48] Native: 0

[21:55:18 48] Source:

[21:55:18 48] SQL: IM002

[21:55:18 48] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[21:55:18 48] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [iM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

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 TimSad*:

 

Hey, XpKiller, I have been getting this error for as long as I can remember when I have Chat Logging set to instant...

 

Error: LogChat: System.InvalidOperationException: The connection has been disabled. ---> System.Data.Odbc.OdbcException: ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.0.92-log]MySQL server has gone away

--- End of inner exception stack trace ---

at System.Data.Odbc.OdbcConnection.ConnectionIsAlive( Exception innerException)

at System.Data.Odbc.OdbcConnection.HandleErrorNoThrow (OdbcHandle hrHandle, RetCode retcode)

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

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader)

at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()

at PRoConEvents.CChatGUIDStatsLoggerBF3.LogChat(Strin g strSpeaker, String strMessage, String strType)

I have always thought that this error is expected when Chat Logging is set to instant. Am I correct? There's not much that I can really do, right? I believe it has something to do with chat messages occurring pretty much at the same second, right? The reason I ask now is because I wanna make sure there is nothing I can do short of turning instant Chat Logging off to resolve this and have those errors stop popping up on me and flooding my plugin console.

[ImportBot]

Originally Posted by johnny5*:

 

Error: Error in Startstreaming:

[14:32:57 74] Index #0

[14:32:57 74] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.25]Out of range value for column 'Playtime' at row 22

[14:32:57 74] Native: 1264

[14:32:57 74] Source: myodbc5.dll

[14:32:57 74] SQL: HY000

 

 

This is the only error i get, it is very intermittant. Well not intermittant, it always happens after a certain amount of time. I think it is not fatal also, things go one fine afterwards.

 

I have no idea, i like this plugin, this plugin sort of amazed me actually.

 

I did a quick google:

The error 1264 Out of range value adjusted for column mostly occurs when INSERT query makes try to insert an empty value into a NOT NULL field. So 'id' is a NOT NULL field in your table against which you are inserting empty ('') value. Means, you must pass some value instead of empty value against NOT NULL type field. Further, because your id field is also AUTO_INCREMENT so you can change your query by passing NULL value against the id field. Change your query from:

 

I wonder if it has something to do with conversion, somewhere in the code. Just a speculation.

`Playtime` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',

 

It is INT(10) in the stats table, and smallint(5) in the sessions table. I am not sure if the 2 tables are even related, just throwing up some ideas.

 

Thanks for the plugin, it is awesome.

[ImportBot]

Originally Posted by XpKiller*:

 

Have set a timeoffset ?

[ImportBot]

Originally Posted by johnny5*:

 

no.

 

I put the trace on, to see if that will show anything. It can take days to happen.

 

My database has around 120 000 in the session table, and around 40 000 players. It doesn't happen that often.

[ImportBot]

Originally Posted by XpKiller*:

 

I'm at work atm I will give you a few SQL statements which could helpe to find the bug.

[ImportBot]

Originally Posted by johnny5*:

 

Cool, no stress.

 

I'll try to help if i can.

[ImportBot]

Originally Posted by XpKiller*:

 

@Cire

It seems that you odbc driver is not configured correctly.

 

@TimSad

This error means that plugin loses the connection to the server whil execute the query. This can have several reasons.

In general it helps to enable conection pooling in the odbc driver.

 

@Johnny5

could you give me the results of those queries:

 

Code:

SELECT * from tbl_server_stats;

Code:

SELECT MAX(Playtime) AS MAX_Playtime, MIN(Playtime) AS MIN_Playtime from tbl_playerstats;

Code:

SELECT MAX(Playtime) AS MAX_Playtime, MIN(Playtime) AS MIN_Playtime from tbl_sessions;

[ImportBot]

Originally Posted by johnny5*:

 

query 1:

'1', '39739', '595733857', '14991.2', '1981758', '49.8693', '382789', '9.63258', '2033367', '51.168', '14634', '0.368253', '2901', '0.0730013', '523338870', '13169.4', '301403', '7.58456'

 

query2:

'1571555', '0'

 

quey3:

'64603', '0'

 

int(5) is only 16bit i think, cutting it close. 2 power of 16 is only 65536. The data types are not big enough.

 

2 power 32 = 4294967296 / 3600 = 1193046.4711111111111111111111111. The 32 bit number should be ok.

 

If int(5) is 16-bit, that is about 18hrs. It is possible with my server, it has gone 7 days straight before, literally 7 days without going empty.

 

i got this from this site:

http://dev.mysql.com/doc/refman/5.0/...uirements.html

 

Data Type

 

Storage Required

 

 

 

 

TINYINT

 

1 byte

 

 

 

SMALLINT

 

2 bytes

 

 

 

MEDIUMINT

 

3 bytes

 

 

 

INT, INTEGER

 

4 bytes

 

 

 

BIGINT

 

8 bytes

 

 

 

FLOAT(p)

 

4 bytes if 0

 

 

 

FLOAT

 

4 bytes

 

 

 

DOUBLE [PRECISION], REAL

 

8 bytes

 

 

 

DECIMAL(M,D), NUMERIC(M,D)

 

Varies; see following discussion

 

 

 

BIT(M)

 

approximately (M+7)/8 bytes

[ImportBot]

Originally Posted by maester*:

 

Xpkiller I know your busy just have a quick question. I have used this plugin since BC2 and it works great. Only difference I see is when a Player joins it would say player name you are ranked # out of ranked # am I missing something or did I configure it wrong for BF3? I see it under player messages and says its enabled but It isnt working in server. Please advise.

[ImportBot]

Originally Posted by XpKiller*:

 

That is what I expected regardless the maxium size of the datatype, I knew that and I choose them to save space, it must an error in the code as well.

I.guess the error is not directly in the plugin but probably some events are not fired by the gameserver sometimes.

I need to buildin some additional detection.for that.

[ImportBot]

Originally Posted by johnny5*:

 

I have the idle timeout off on my server. That is how i started the population, by parking my man on the server.

 

I think people do 30 hr stretches to be honest.

 

I noticed early on, when i started the server some people basically living on it.

 

It is amazing, but i think some people do amazingly long sessions.

 

You can basically start a server population by just parking 1 man on a server, the quick match stuff from DICE, tends to keep the server going, if someone is parked on it.

[ImportBot]

Originally Posted by XpKiller*:

 

Ok I don't know that.

 

Just change the data type of column playtime in tbl_sessions to int.

[ImportBot]

Originally Posted by johnny5*:

 

Thanks for your hard work.

 

Youre plugin is excellent.

 

Just trying to contribute.

 

Cheers.

[ImportBot]

Originally Posted by CBG*:

 

Hi,

 

I am running, this but would like to have different set of tables, for different servers.

I have 3 servers

 

I would like

 

tbl1_*

tbl2_*

tbl3_*

 

* means the table names.

 

Now, it is just the case of editting CChatGUIDStatsLoggerBF3.cs and changing tbl_* to tblX_* for each, server procon plugin?

 

Or would I use the suffix part?

[ImportBot]

Originally Posted by XpKiller*:

 

There is no need for that.

Don't use suffixes or prefix it deprecated feature which can cause problems.

 

The stats don't get mixed when using more that one server.

[ImportBot]

Originally Posted by CBG*:

 

Ok thanks.

 

Have another question, I want to add serverID to dogtags, bit.

Is it just the case of adding serverID to the insert string and add the extra bit in the database?

 

Reason, being I am using the stats page, and dogtags, is the same for each server, but it should be just for the server it was got on.

[ImportBot]

Originally Posted by XpKiller*:

 

No needed as well

 

The dogtags based on the StatsID. The Statsid is a unique Product out for ServerID and PlayerID.

 

If you Stats pages is wrong, it probably uses the wrong query.

 

 

Set all dogtags for a player of a specific Player order by Count

Code:

SELECT tpd.SoldierName AS Killer, dt.Count , tpd2.SoldierName AS Victim
FROM tbl_dogtags dt
INNER JOIN tbl_server_player tsp ON tsp.StatsID = dt.KillerID 
INNER JOIN tbl_server_player tsp2 ON tsp2.StatsID = dt.VictimID
INNER JOIN tbl_playerdata tpd ON tsp.PlayerID = tpd.PlayerID
INNER JOIN tbl_playerdata tpd2 ON tsp2.PlayerID = tpd2.PlayerID
WHERE tpd.SoldierName = '_I_XpKiller_I_' AND tsp.ServerID = 1 
ORDER BY Count DESC

Get all Dogtags of a specfic player overall server

Code:

SELECT tpd.SoldierName AS Killer ,tpd2.SoldierName AS Victim, SUM(dt.Count) AS Count
FROM tbl_dogtags dt
INNER JOIN tbl_server_player tsp ON tsp.StatsID = dt.VictimID 
INNER JOIN tbl_server_player tsp2 ON tsp2.StatsID = dt.KillerID 
INNER JOIN tbl_playerdata tpd ON tsp.PlayerID = tpd.PlayerID
INNER JOIN tbl_playerdata tpd2 ON tsp2.PlayerID = tpd2.PlayerID
WHERE tpd.SoldierName = '_I_XpKiller_I_' AND tsp.ServerID = 1 
GROUP BY dt.KillerID
ORDER BY Count DESC

Out of my Query guide:

www.phogue.net/forumvb/showth...atsDB-examples*

[ImportBot]

Originally Posted by ty_ger07*:

 

Ok thanks.

 

Have another question, I want to add serverID to dogtags, bit.

Is it just the case of adding serverID to the insert string and add the extra bit in the database?

 

Reason, being I am using the stats page, and dogtags, is the same for each server, but it should be just for the server it was got on.

( not my code )

[ImportBot]

Originally Posted by CBG*:

 

( not my code )

I did test yours and got errors, to do with mysql, so gave up on that one.

[ImportBot]

Originally Posted by CBG*:

 

I am running RMG-Dr4k3 stats script.

 

I am not after the player stats, I am after an overall dogtags for that server.

 

I have 3 servers, when you click on the different servers, you get an overall server stats, it shows the same dogtags for all servers.

 

This is the SQL he is using

$dogtags=mysqli_fetch_array(mysqli_query($dbconn, "SELECT SUM(`Count`) FROM `".$sqlprefix."dogtags".$suffix."`"));

 

Which is why I am seeing the same amount of dogtags on each server overall stats

 

This was the reason, I was looking at adding the serverID, so I could do a where, in the SQL.

To show the right dogtags for the server overall stats

[ImportBot]

Originally Posted by XpKiller*:

 

You know how SQL works ?

 

Again the serverid is not needed there. If you would add the column the column would stay empty because the plugin do not enter a value there.

[ImportBot]

Originally Posted by ty_ger07*:

 

I did test yours and got errors, to do with mysql, so gave up on that one.

Nope.

 

The most likely cause is that you used the incorrect configuration or had wordwrap enabled while editing the file. I suggest you request help in my thread regarding your issue with my code.

 

I just wanted to clarify that my code does not have any issues with mixing stats from different servers unlike the code you are using which was developed by someone else.