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

[ImportBot]

Originally Posted by XpKiller*:

 

@INilo

Try this as Drivername: MySQL ODBC 5.1 Driver

 

Also please take a look at this:

www.phogue.net/forumvb/showth...-Configuration*.

[ImportBot]

Originally Posted by RCONHostingServices*:

 

No problems here, it's working great!

[ImportBot]

Originally Posted by iNilo*:

 

Thx

 

Its working now,

 

Btw, how can I setup this plugin so the top 10 players are from all our servers ? (5 servers),

basically recording all the players & having cross server stats ?

so if I'm playing on server 2 and type !top10 I will see the top ten across all our servers (1,2,3,4,5) ?

 

 

 

Thx

[ImportBot]

Originally Posted by RCONHostingServices*:

 

Just use 1 database and put the 1 database settings into each plugin config for each server.

[ImportBot]

Originally Posted by sourtimer*:

 

I have a question.

 

If I change the name of my server, will the database be no good anymore ? Or can I just edit the server name in the database to match my new server name ?

[ImportBot]

Originally Posted by XpKiller*:

 

Just use 1 database and put the 1 database settings into each plugin config for each server.

Nope this is not working anymore due the new database design.

 

There is no need to split server up.

 

If you want to have your serverstats combined i need to add code for this.

 

New toDo:

add global ranking option

[ImportBot]

Originally Posted by XpKiller*:

 

I have a question.

 

If I change the name of my server, will the database be no good anymore ? Or can I just edit the server name in the database to match my new server name ?

Changing the name of the Server has no effect on the database. The data is still valid. It depends on the Server IP address + port.

[ImportBot]

Originally Posted by DeadWalking*:

 

Anyone here using this any good with coding for PHP/WebSpace and grabbing the info's in the MySQL DB's?

 

Would love to see a web stats page added. I would try but it would probably take my nubsauce *** 6 months to write.

 

I hate to copy or mimic, but something similar to what xlrstats is trying to do for B3 would be excellent.

[ImportBot]

Originally Posted by EBassie*:

 

Found a bug in the @top10 command:

It shows the top10 of serverID 1 when I am on serverID 2

 

 

Also there is a difference between my @rank and the @top10 when I'm on serverID 1:

@top10 gives me the the 7th position, while rank says I'm the number 16th

Both are showing the correct points though

[ImportBot]

Originally Posted by feeblemedic*:

 

am i reading correctly that I can only have 1 server per database/connection via procon....I can't have all my server stats in one database?

[ImportBot]

Originally Posted by XpKiller*:

 

Found a bug in the @top10 command:

It shows the top10 of serverID 1 when I am on serverID 2

 

 

Also there is a difference between my @rank and the @top10 when I'm on serverID 1:

@top10 gives me the the 7th position, while rank says I'm the number 16th

Both are showing the correct points though

Damn, looks like i missed something in the query again thanks for report.

Will look at this again today. :-)

 

@feeblemedic

No you can put all servers in to one db.

Actually the max server per DB is 65535 different servers.

I dont think you hit this, aren't you? :-)

[ImportBot]

Originally Posted by Pegasus829*:

 

Does anyone have a preset PHP page for showing the stats? Can't find any info on it anywhere and am not a coder by any means! All I need is the basic calling to get the xml data through, the web page itself I can do with ease. Cheers.

[ImportBot]

Originally Posted by FARSTAN*:

 

great plugin, it works great, we look now welcome the stats, we look forward to.

I cried a tutorial to configure the plugin, but it's in French!

http://team-gsp.net/tuto_mysql_stats...r_v0.0.0.2.pdf

BRAVO XpKiller

[ImportBot]

Originally Posted by FARSTAN*:

 

when do you get the welcome stats, when a player back on the server?

must wait dice

[ImportBot]

Originally Posted by FARSTAN*:

 

Hello, I return to the forum for two things, I see the welcome message, according to (Nice to see you again on our Server, FARSTAN) and after my server stats displayed:smile:

 

2 nd point, the number of kills (%playerKills%) on the server it is not moving a block 51 for 2 days, then yesterday I had to make 200

 

I board do not crush the sql to each new version of the plugin, I have to do?

[ImportBot]

Originally Posted by XpKiller*:

 

Will take a look tomorrow . Today I won't have time. But looks for me like a bug in the gameserver or the way procon or my pluging react on the onplayerkilled event. The insert and update queries are fine you would get error if they were broken.

You don't need to drop your tables unless I explicit say to do t

his the tables are compatible to previous versions

[ImportBot]

Originally Posted by Sebokan*:

 

Requirements:

Access to a MySQL database that accepts remote connections is required so you need to create a user and database if not exists.

It requires the use of a MySQL database with INNODB engine that allows remote connections.(MYSQL Version 5.1.x is required!!!)

Also the ODBC 5.1 Driver (the latest is 5.1.9) is needed and can be found here http://dev.mysql.com/downloads/connector/odbc/5.1.html .

 

READ THE CHANGELOG

 

Installation:

Extract CChatGUIDStatsLogger.cs into plugin directory.

Set DB Server Settings and the Plugin Settings

 

Add the machine running the plugin to the remote mysql access host list.

Will throw a permissions error if not done

 

Enable outgoing ODBC Connections, located in Tools -> Options -> Plugins

Will throw a permissions error if not done

I'm currently using a webhotel for hosting my php websites. The solution I currently have is a MySQL 5.1 DB running on Linux server. According to the host, only Windows servers have the ODBC DNS connection (ASP), not Linux server like I have access to.

So my question is, do I need to install MySQL server on my homecomputer with ODBC and somehow syncronize the 2 databases?

 

Sorry if this sound strange, but my knowledge is limited when it comes to databases and MySQL.

[ImportBot]

Originally Posted by XpKiller*:

 

Maybe there is a misunderstanding , only the procon host server need the mysql ODBC driver. It's no problem to have the DB on a Linux based host. You don't need to install a ODBC Driver on your DB host.

If you got further questions feel free to ask.

[ImportBot]

Originally Posted by FARSTAN*:

 

I'm currently using a webhotel for hosting my php websites. The solution I currently have is a MySQL 5.1 DB running on Linux server. According to the host, only Windows servers have the ODBC DNS connection (ASP), not Linux server like I have access to.

So my question is, do I need to install MySQL server on my homecomputer with ODBC and somehow syncronize the 2 databases?

 

Sorry if this sound strange, but my knowledge is limited when it comes to databases and MySQL.

look this tuto whit linux

http://team-gsp.net/tuto_mysql_stats...r_v0.0.0 0.2. pdf

[ImportBot]

Originally Posted by FARSTAN*:

 

XpKiller since the update 0.0.0.4, I get this error, I have to stop the plugin, and then back, and it works.

but the message back every 10/15 minutes

 

 

Error: SQLQuery:System.InvalidOperationException: Erreur interne du fournisseur de données .Net Framework 12.

à System.Data.ProviderBase.DbConnectionInternal.Crea teReferenceCollection()

à System.Data.ProviderBase.DbConnectionInternal.AddW eakReference(Object value, Int32 tag)

à System.Data.Odbc.OdbcCommand.GetStatementHandle()

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

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

à System.Data.Odbc.OdbcCommand.ExecuteReader(Command Behavior behavior)

à System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(C ommandBehavior behavior)

à System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior behavior)

à System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

à System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)

à System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

à PRoConEvents.CChatGUIDStatsLoggerBF3.SQLquery(Odbc Command selectQuery)

[ImportBot]

Originally Posted by iNilo*:

 

What does this means ?

Code:

Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [HY001] [MySQL][ODBC 5.1 Driver][mysqld-5.5.16]Memory allocation error
   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)

[ImportBot]

Originally Posted by Sebokan*:

 

Got it working now. What formular is used to calculate server rank?

[ImportBot]

Originally Posted by XpKiller*:

 

@FARSTAN and iNilo

 

On the way to solve this problems i properly release a new Version.

 

@Sebokan

You can choose if want a ranking by score or by kills.

to turn on ranking Score set the option "Ranking by Score" to Yes.

 

Ranking by score is recommend because the queries are easer for the db.

[ImportBot]

Originally Posted by flashback830*:

 

For me, the K / D is not logged. Is also nothing in the DB

 

http://zfg-com.de/pics/dbx1.png

[ImportBot]

Originally Posted by g34rfr34k*:

 

It works flawlessly. Thank you for creating this plugin!

 

For those who'd like to know my hosting company:

 

I use HostGator.com (business plan).

 

I had some issues with setting up the server remotely but they replied back with really dead-on info on how to solve it.

 

The really impressive part of their support is the fact that the time is 4AM lol.

 

Also, the new R10 update is released which fixes the vars idletime.

 

Not a bad night afterall

 

Happy Thanksgiving everyone!!!

[ImportBot]

Originally Posted by Grovax*:

 

Hi, i get this error message ... is the ODBC Connector disabled on this Layer-Server?

 

 

[16:51:03 55] Error: System.Security.SecurityException: Fehler bei der Anforderung des Berechtigungstyps "System.Data.Odbc.OdbcPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=*************".

bei System.Security.CodeAccessSecurityEngine.Check(Obj ect demand, StackCrawlMark& stackMark, Boolean isPermSet)

bei System.Security.PermissionSet.Demand()

bei System.Data.Common.DbConnectionOptions.DemandPermi ssion()

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

bei System.Data.Odbc.OdbcConnectionFactory.PermissionD emand(DbConnection outerConnection)

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

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

bei PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

Die Aktion, bei der ein Fehler aufgetreten ist:

Demand

Der Typ der ersten Berechtigung, bei der ein Fehler aufgetreten ist:

System.Data.Odbc.OdbcPermission

Die Zone der Assembly, bei der ein Fehler aufgetreten ist:

MyComputer

[ImportBot]

Originally Posted by FARSTAN*:

 

Hello, I wonder if I could create another table (SQL SoldierNames) in tbl_playerstats?

 

I create, SoldierNames, in your indantique located in tbl_playerdata with the same index, everything has indantique.

 

After that I think we have a "relationship" between the SoldierNames playerdata and playerstats, but I get this error

because

 

Erreur

Requête SQL:

 

ALTER TABLE `tbl_playerstats` ADD FOREIGN KEY ( `SoldierNames` ) REFERENCES `gspmegah_serv32hc`.`tbl_playerdata` (

 

`SoldierName`

) ON DELETE RESTRICT ON UPDATE RESTRICT ;

 

MySQL a répondu:

 

#1452 - Cannot add or update a child row: a foreign key constraint fails (`gspmegah_serv32hc`., CONSTRAINT `#sql-624_196c9_ibfk_1` FOREIGN KEY (`SoldierNames`) REFERENCES `tbl_playerdata` (`SoldierName`))

 

I am in a project, import the stats of the DB in a php script, for visitors to our website

 

why I would like to display the username in the page or is the kills

 

Attached Files:

• Tbl Playerstats.png

[ImportBot]

Originally Posted by XpKiller*:

 

@flashback

I know this issue atm i dont know what cause the problem has

It would help if you could give me the version and os of your mysql server

 

@FARSTAN

 

There is not direct relation between tbl_playerdata and tbl_playerstats.

The most parts of the DB are normalized tables.

So you dont need a new table.

 

Use this query to get your result:

Code:

SELECT tpd.*, tps.*, tsp.*,ts.*
FROM tbl_server_player tsp
INNER JOIN tbl_server ts ON tsp.ServerID = ts.ServerID
INNER JOIN tbl_playerdata tpd ON tsp.PlayerID = tpd.PlayerID
INNER JOIN tbl_playerstats tps ON tsp.StatsID = tps.StatsID
WHERE tpd.SoldierName = 'FARSTAN';

This is only a short example. this query gives you results for the player Farstan per Server.

Dont be afraid to use joins. InnoDB performs joins very fast so it doesn't matter.

If yoi have more questions regarding queries feel free to as.

A golden rules is only query fields you really need. The query is post is "bad" because it gets all fields of the tables which were joined.

 

Also you should use on DB for all your servers.

The Stats dont get mixed in the DB so dont worry.

[ImportBot]

Originally Posted by FARSTAN*:

 

I do not understand, because I use a generator for php

 

I can give you my id in my sql

[ImportBot]

Originally Posted by FARSTAN*:

 

I sent my information in connection with my cpanel, by PM

 

DB _srerv32hc