Chat, GUID, Stats and Mapstats Logger [1.0.0.3]

[ImportBot]

Originally Posted by ty_ger07*:

 

Hey tyger,

 

How would i make a query that results in top 10 players with most melee kils? Or any other weapon?

 

Kind regards.

Melee:

 

Code:

SELECT tpd.`Soldiername`, tws.`Friendlyname`, wa.`Kills`, wa.`Deaths`, wa.`Headshots`, (wa.`Headshots`/wa.`Kills`) AS HSR
FROM `tbl_weapons_stats` wa
INNER JOIN `tbl_server_player` tsp ON tsp.`StatsID` = wa.`StatsID`
INNER JOIN `tbl_playerdata` tpd ON tsp.`PlayerID` = tpd.`PlayerID`
INNER JOIN `tbl_weapons` tws ON tws.`WeaponID` = wa.`WeaponID`
WHERE tsp.`ServerID` = 1
AND tpd.`GameID` = 1
AND tws.`Damagetype` = 'melee'
ORDER BY Kills DESC, Deaths DESC
LIMIT 10

Result for example:

Capture1.PNG

 

 

Substitute 'melee' for some other valid damage type in the portion "AND tws.`Damagetype` = 'melee'" to display other damage types.

[ImportBot]

Originally Posted by Gijzijtdood*:

 

Melee:

 

Code:

SELECT tpd.`Soldiername`, tws.`Friendlyname`, wa.`Kills`, wa.`Deaths`, wa.`Headshots`, (wa.`Headshots`/wa.`Kills`) AS HSR
FROM `tbl_weapons_stats` wa
INNER JOIN `tbl_server_player` tsp ON tsp.`StatsID` = wa.`StatsID`
INNER JOIN `tbl_playerdata` tpd ON tsp.`PlayerID` = tpd.`PlayerID`
INNER JOIN `tbl_weapons` tws ON tws.`WeaponID` = wa.`WeaponID`
WHERE tsp.`ServerID` = 1
AND tpd.`GameID` = 1
AND tws.`Damagetype` = 'melee'
ORDER BY Kills DESC, Deaths DESC
LIMIT 10

Result example:

 

(I left out HS and HSR columns because they were all 0s in this example.)

 

Substitute 'melee' for some other valid damage type in the portion "AND tws.`Damagetype` = 'melee'" to display other damage types.

Is it also possible to query for top 10 players for a specific weapon like for exaple the Knife?

[ImportBot]

Originally Posted by ty_ger07*:

 

Is it also possible to query for top 10 players for a specific weapon like for exaple the Knife?

Yes. Just use tws.`Friendlyname` instead of tws.`Damagetype`.

 

For example:

Code:

SELECT tpd.`Soldiername`, tws.`Friendlyname`, wa.`Kills`, wa.`Deaths`, wa.`Headshots`, (wa.`Headshots`/wa.`Kills`) AS HSR
FROM `tbl_weapons_stats` wa
INNER JOIN `tbl_server_player` tsp ON tsp.`StatsID` = wa.`StatsID`
INNER JOIN `tbl_playerdata` tpd ON tsp.`PlayerID` = tpd.`PlayerID`
INNER JOIN `tbl_weapons` tws ON tws.`WeaponID` = wa.`WeaponID`
WHERE tsp.`ServerID` = 1
AND tpd.`GameID` = 1
AND tws.`Friendlyname` = 'USAS-12'
ORDER BY Kills DESC, Deaths DESC
LIMIT 10

Example results:

Capture2.PNG

 

Friendlyname for Damagetype melee is Friendlyname melee by the way. There are also other different kinds of knives with other Friendlynames though.

 

I will post (edit or reply) with more information about the knife situation.

[ImportBot]

Originally Posted by ty_ger07*:

 

Friendlyname for Damagetype melee is Friendlyname melee by the way. There are also other different kinds of knives with other Friendlynames though.

 

I will post (edit or reply) with more information about the knife situation.

Your database is newer than mine and therefore may have additional newer weapons which I don't have. These are all the different Friendlyname's which share the melee Damagetype in my database:

Repairtool

Melee

Defib

 

I am pretty sure that there are other knives you may need to consider for premium players and maybe some which have been available with DLC.

 

 

If you wanted to use Friendlynames in all your queries but also wanted to include more than one specific weapon, use a query similar to this:

Code:

SELECT tpd.`Soldiername`, tws.`Friendlyname`, wa.`Kills`, wa.`Deaths`, wa.`Headshots`, (wa.`Headshots`/wa.`Kills`) AS HSR
FROM `tbl_weapons_stats` wa
INNER JOIN `tbl_server_player` tsp ON tsp.`StatsID` = wa.`StatsID`
INNER JOIN `tbl_playerdata` tpd ON tsp.`PlayerID` = tpd.`PlayerID`
INNER JOIN `tbl_weapons` tws ON tws.`WeaponID` = wa.`WeaponID`
WHERE tsp.`ServerID` = 1
AND tpd.`GameID` = 1
AND (tws.`Friendlyname` = 'Repairtool' OR tws.`Friendlyname` = 'Melee' OR tws.`Friendlyname` = 'Defib')
ORDER BY Kills DESC, Deaths DESC
LIMIT 10

Example result:

Capture3.PNG

 

 

Here is an example for including AEK971_M26_Buck, AEK971_M26_Flechette, AEK971_M26_Frag, AEK971_M26_Slug, AEK971_M320_FLASH, AEK971_M320_HE, AEK971_M320_LVG, AEK971_M320_SHG, and AEK971_M320_SMK along with AEK971 when querying for AEK971 by using the term LIKE. When using LIKE, the string you are comparing against should have a wildcard in it. The wildcard is %. If there is one % at the end, it means that the string starts with the specified string and ends with whatever. If there is a wild card at the beginning and a wildcard at the end, it means that the string starts with whatever, has the specified string in the middle, and ends with whatever.

Code:

SELECT tpd.`Soldiername`, tws.`Friendlyname`, wa.`Kills`, wa.`Deaths`, wa.`Headshots`, (wa.`Headshots`/wa.`Kills`) AS HSR
FROM `tbl_weapons_stats` wa
INNER JOIN `tbl_server_player` tsp ON tsp.`StatsID` = wa.`StatsID`
INNER JOIN `tbl_playerdata` tpd ON tsp.`PlayerID` = tpd.`PlayerID`
INNER JOIN `tbl_weapons` tws ON tws.`WeaponID` = wa.`WeaponID`
WHERE tsp.`ServerID` = 1
AND tpd.`GameID` = 1
AND tws.`Friendlyname` LIKE 'AEK971%'
ORDER BY Kills DESC, Deaths DESC
LIMIT 10

Capture4.PNG

 

 

Lastly, if you have multiple servers and want to include results from multiple servers, use the term IN in the ServerID constraint followed by an array of values separated by commas.

 

For example:

Code:

SELECT tpd.`Soldiername`, tws.`Friendlyname`, wa.`Kills`, wa.`Deaths`, wa.`Headshots`, (wa.`Headshots`/wa.`Kills`) AS HSR
FROM `tbl_weapons_stats` wa
INNER JOIN `tbl_server_player` tsp ON tsp.`StatsID` = wa.`StatsID`
INNER JOIN `tbl_playerdata` tpd ON tsp.`PlayerID` = tpd.`PlayerID`
INNER JOIN `tbl_weapons` tws ON tws.`WeaponID` = wa.`WeaponID`
WHERE tsp.`ServerID` IN (1,2,3,5)
AND tpd.`GameID` = 1
AND tws.`Friendlyname` = 'M416'
ORDER BY Kills DESC, Deaths DESC
LIMIT 10

Capture5.PNG

[ImportBot]

Originally Posted by Gijzijtdood*:

 

Your database is newer than mine and therefore may have additional newer weapons which I don't have. These are all the different Friendlyname's which share the melee Damagetype in my database:

Repairtool

Melee

Defib

 

I am pretty sure that there are other knives you may need to consider for premium players and maybe some which have been available with DLC.

 

 

If you wanted to use Friendlynames in all your queries but also wanted to include more than one specific weapon, use a query similar to this:

Code:

SELECT tpd.`Soldiername`, tws.`Friendlyname`, wa.`Kills`, wa.`Deaths`, wa.`Headshots`, (wa.`Headshots`/wa.`Kills`) AS HSR
FROM `tbl_weapons_stats` wa
INNER JOIN `tbl_server_player` tsp ON tsp.`StatsID` = wa.`StatsID`
INNER JOIN `tbl_playerdata` tpd ON tsp.`PlayerID` = tpd.`PlayerID`
INNER JOIN `tbl_weapons` tws ON tws.`WeaponID` = wa.`WeaponID`
WHERE tsp.`ServerID` = 1
AND tpd.`GameID` = 1
AND (tws.`Friendlyname` = 'Repairtool' OR tws.`Friendlyname` = 'Melee' OR tws.`Friendlyname` = 'Defib')
ORDER BY Kills DESC, Deaths DESC
LIMIT 10

Example result:

Capture3.PNG

 

 

Here is an example for including AEK971_M26_Buck, AEK971_M26_Flechette, AEK971_M26_Frag, AEK971_M26_Slug, AEK971_M320_FLASH, AEK971_M320_HE, AEK971_M320_LVG, AEK971_M320_SHG, and AEK971_M320_SMK along with AEK971 when querying for AEK971 by using the term LIKE. When using LIKE, the string you are comparing against should have a wildcard in it. The wildcard is %. If there is one % at the end, it means that the string starts with the specified string and ends with whatever. If there is a wild card at the beginning and a wildcard at the end, it means that the string starts with whatever, has the specified string in the middle, and ends with whatever.

Code:

SELECT tpd.`Soldiername`, tws.`Friendlyname`, wa.`Kills`, wa.`Deaths`, wa.`Headshots`, (wa.`Headshots`/wa.`Kills`) AS HSR
FROM `tbl_weapons_stats` wa
INNER JOIN `tbl_server_player` tsp ON tsp.`StatsID` = wa.`StatsID`
INNER JOIN `tbl_playerdata` tpd ON tsp.`PlayerID` = tpd.`PlayerID`
INNER JOIN `tbl_weapons` tws ON tws.`WeaponID` = wa.`WeaponID`
WHERE tsp.`ServerID` = 1
AND tpd.`GameID` = 1
AND tws.`Friendlyname` LIKE 'AEK971%'
ORDER BY Kills DESC, Deaths DESC
LIMIT 10

Capture4.PNG

 

 

Lastly, if you have multiple servers and want to include results from multiple servers, use the term IN in the ServerID constraint followed by an array of values separated by commas.

 

For example:

Code:

SELECT tpd.`Soldiername`, tws.`Friendlyname`, wa.`Kills`, wa.`Deaths`, wa.`Headshots`, (wa.`Headshots`/wa.`Kills`) AS HSR
FROM `tbl_weapons_stats` wa
INNER JOIN `tbl_server_player` tsp ON tsp.`StatsID` = wa.`StatsID`
INNER JOIN `tbl_playerdata` tpd ON tsp.`PlayerID` = tpd.`PlayerID`
INNER JOIN `tbl_weapons` tws ON tws.`WeaponID` = wa.`WeaponID`
WHERE tsp.`ServerID` IN (1,2,3,5)
AND tpd.`GameID` = 1
AND tws.`Friendlyname` = 'M416'
ORDER BY Kills DESC, Deaths DESC
LIMIT 10

Capture5.PNG

Thanks a million Tyger.

You are the best

 

Regards

[ImportBot]

Originally Posted by spatieman*:

 

is there a way to reset reputation stats?

i was testing some tempban setings, now i have a -28 reputation score.

[ImportBot]

Originally Posted by Goran*:

 

Hi

I am new in this,just installed my bf4 server and all nessery plugins.

Most of them are working but one thing it doesnt work , its player server stat . Can anyone help me? and since I am kind a new at this ,just tell me what prt screen do you need or info and I wll provide you info.

Thx

[ImportBot]

Originally Posted by ty_ger07*:

 

is there a way to reset reputation stats?

i was testing some tempban setings, now i have a -28 reputation score.

I have no idea what reputation is, but it has nothing to do with this plugin. You better find out which plugin is creating a reputation score and then ask there.

[ImportBot]

Originally Posted by ty_ger07*:

 

Hi

I am new in this,just installed my bf4 server and all nessery plugins.

Most of them are working but one thing it doesnt work , its player server stat . Can anyone help me? and since I am kind a new at this ,just tell me what prt screen do you need or info and I wll provide you info.

Thx

Do you have a SQL database hosted by a web server? That is step 1.

[ImportBot]

Originally Posted by Goran*:

 

Do you have a SQL database hosted by a web server? That is step 1.

Yes ,everything is correctly entered ,host ,name, db ,usr,pass..it somehow rememberd only 7 players ,when u run for example !top10 it shows 0 kd etc,and that is where it end . Doesnt remember new players ,new kills ,deaths..

[ImportBot]

Originally Posted by TheUltimateForce*:

 

Since a server crash at gamed.de the player stats are not beïng updated anymore. Plugins are all updated and reïnstalled.

What can be the problem here?

[ImportBot]

Originally Posted by Esccape*:

 

The Statslogger is missing a Weapon:

fe.jpg

Same with Groza-4.

 

Procon Client and Layer are up to date with BF4.def

[ImportBot]

Originally Posted by Mr_Shishacolic*:

 

Hi Guys

 

i need your help with setting up this plugin to show the Roundstats automatically on Roundend like:

most kills, most deaths, most dogtags etc.

 

i hope there is one hero, who will help me.

[ImportBot]

Originally Posted by ty_ger07*:

 

Hi Guys

 

i need your help with setting up this plugin to show the Roundstats automatically on Roundend like:

most kills, most deaths, most dogtags etc.

 

i hope there is one hero, who will help me.

This plugin doesn't keep track of round stats. Sorry.

[ImportBot]

Originally Posted by Mr_Shishacolic*:

 

;( but thank you for the fast reply^^.

[ImportBot]

Originally Posted by Dete96*:

 

Hi!

 

Every time !top10 "weapon code" ist typed ingame this error message appears in ProCon. Does anyone know what the message means and in best case how to solve the problem?

 

Every other ingame command works perfectly, It´s just !top10 "weapon code" that causes problems and doesn´t work.

 

Thank you in advance.

Dete96

 

[15:56:55 81] [statslogger]Error: SQLQuery:

[15:56:55 81] Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '` DESC, SUM(`Headshots`) DESC

LIMIT 10' at line 8

[15:56:55 81] Native: -2147467259

[15:56:55 81] Source: MySql.Data

[15:56:55 81] StackTrace: bei MySql.Data.MySqlClient.MySqlStream.ReadPacket()

bei MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& affectedRow, Int64& insertedId)

bei MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

bei MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

bei MySql.Data.MySqlClient.MySqlDataReader.NextResult( )

bei MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)

bei MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataR eader(CommandBehavior behavior)

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

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

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

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

bei PRoConEvents.CChatGUIDStatsLogger.SQLquery(MySqlCo mmand selectQuery)

[15:56:55 81] [statslogger]Error: SQLQuery OuterException:System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

bei PRoConEvents.CChatGUIDStatsLogger.SQLquery(MySqlCo mmand selectQuery)

[ImportBot]

Originally Posted by ty_ger07*:

 

Hi!

 

Every time !top10 "weapon code" ist typed ingame this error message appears in ProCon. Does anyone know what the message means and in best case how to solve the problem?

 

Every other ingame command works perfectly, It´s just !top10 "weapon code" that causes problems and doesn´t work.

 

Thank you in advance.

Dete96

 

[15:56:55 81] [statslogger]Error: SQLQuery:

[15:56:55 81] Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '` DESC, SUM(`Headshots`) DESC

LIMIT 10' at line 8

[15:56:55 81] Native: -2147467259

[15:56:55 81] Source: MySql.Data

[15:56:55 81] StackTrace: bei MySql.Data.MySqlClient.MySqlStream.ReadPacket()

bei MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& affectedRow, Int64& insertedId)

bei MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

bei MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

bei MySql.Data.MySqlClient.MySqlDataReader.NextResult( )

bei MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)

bei MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataR eader(CommandBehavior behavior)

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

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

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

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

bei PRoConEvents.CChatGUIDStatsLogger.SQLquery(MySqlCo mmand selectQuery)

[15:56:55 81] [statslogger]Error: SQLQuery OuterException:System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

bei PRoConEvents.CChatGUIDStatsLogger.SQLquery(MySqlCo mmand selectQuery)

Yes, I see the mistake in XpKiller's plugin code.

 

ORDER BY SUM(`Kills`)` DESC, SUM(`Headshots`) DESC

I don't know the line number (on my phone). Just search the CChatGUIDStatsLogger.inc file for that. You will find it.

 

The extra accent mark (in red) needs to be removed, the file saved, and procon and/or procon layer restarted.

[ImportBot]

Originally Posted by Dete96*:

 

Thank you mate! It worked! You made one special person very happy!

[ImportBot]

Originally Posted by mutsnuts*:

 

System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

 

i keep getting this what have i done wrong

[ImportBot]

Originally Posted by CaptCourage*:

 

Any update on this plugin? I cannot get this plugin to work on the latest ver of mysql. I see that it is posted that I should revert my sql version to an older one. The problem is that I am using a shared mysql environment where my database is being hosted and it cannot be changed.

I need this plugin to be working for adkats to run so I am hoping for a solution. I would like the plugins to run on 2 servers.

Has there been a workaround yet ?

Regards

[ImportBot]

Originally Posted by ty_ger07*:

 

Any update on this plugin? I cannot get this plugin to work on the latest ver of mysql. I see that it is posted that I should revert my sql version to an older one. The problem is that I am using a shared mysql environment where my database is being hosted and it cannot be changed.

I need this plugin to be working for adkats to run so I am hoping for a solution. I would like the plugins to run on 2 servers.

Has there been a workaround yet ?

Regards

Unfortunately, XpKiller -- this plugin's author -- has not showed himself around here for quite some time. You will need to edit the C# source code of this plugin if you wish for it to work with the latest sql version. Do you need help modifying the sql table builder queries in the source code of this plugin?

[ImportBot]

Originally Posted by mutsnuts*:

 

[19:04:18 83] Error: System.TimeoutException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond ---> System.IO.IOException: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)

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

at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)

at MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)

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

at MySql.Data.Common.MyNetworkStream.HandleOrRethrowE xception(Exception e)

at MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)

at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)

at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)

at MySql.Data.MySqlClient.MySqlStream.ReadFully(Strea m stream, Byte[] buffer, Int32 offset, Int32 count)

at MySql.Data.MySqlClient.MySqlStream.LoadPacket()

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.Open()

at MySql.Data.MySqlClient.Driver.Open()

at MySql.Data.MySqlClient.Driver.Create(MySqlConnecti onStringBuilder settings)

at MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on()

at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()

at MySql.Data.MySqlClient.MySqlPool.GetConnection()

at MySql.Data.MySqlClient.MySqlConnection.Open()

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[19:04:18 83] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

 

 

 

 

 

please help me with this iv been trying to get it to work no im lost

[ImportBot]

Originally Posted by mutsnuts*:

 

[19:04:18 83] Error: System.TimeoutException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond ---> System.IO.IOException: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)

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

at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)

at MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)

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

at MySql.Data.Common.MyNetworkStream.HandleOrRethrowE xception(Exception e)

at MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)

at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)

at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)

at MySql.Data.MySqlClient.MySqlStream.ReadFully(Strea m stream, Byte[] buffer, Int32 offset, Int32 count)

at MySql.Data.MySqlClient.MySqlStream.LoadPacket()

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.Open()

at MySql.Data.MySqlClient.Driver.Open()

at MySql.Data.MySqlClient.Driver.Create(MySqlConnecti onStringBuilder settings)

at MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on()

at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()

at MySql.Data.MySqlClient.MySqlPool.GetConnection()

at MySql.Data.MySqlClient.MySqlConnection.Open()

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[19:04:18 83] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

 

please help me im try to get this to work now im lost if u need anythink off me im happy to get it for u

[ImportBot]

Originally Posted by )RAG()N*:

 

Don't know if anyone posted an update for the missing map images yet, but here is the one I made for my site

 

Just make a backup of your constants.php before you upload the new one,

 

Attached Files:

• New-Maps-images update.zip

[ImportBot]

Originally Posted by ty_ger07*:

 

Don't know if anyone posted an update for the missing map images yet, but here is the one I made for my site

 

Just make a backup of your constants.php before you upload the new one,

This does not really belong in this thread. XpKiller's plugin does not use php. Your post belongs in the appropriate thread in the plugin enhancements section of the forum.

[ImportBot]

Originally Posted by spatieman*:

 

ok, so i messed up my sql setup masivly.

tried to rebuild with clean stuff, but didnt manage to create user account for adkats/statlogger.

 

installed xampp ,made a user account first and created the adkats database.

both xampp and procon are running on the same machine.

 

but i get this message when starting the stats logger.

 

Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Authentication to host '127.0.0.1' for user 'xxxxx' using method 'mysql_native_password' failed with message: Access denied for user 'xxxx'@'localhost' (using password: YES) ---> MySql.Data.MySqlClient.MySqlException: Access denied for user 'xxxx'@'localhost' (using password: YES)

bij MySql.Data.MySqlClient.MySqlStream.ReadPacket()

bij MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.ReadPacket()

--- Einde van intern uitzonderingsstackpad ---

bij MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.AuthenticationFailed(Exception ex)

bij MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.ReadPacket()

bij MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.Authenticate(Boolean reset)

bij MySql.Data.MySqlClient.NativeDriver.Open()

bij MySql.Data.MySqlClient.Driver.Open()

bij MySql.Data.MySqlClient.Driver.Create(MySqlConnecti onStringBuilder settings)

bij MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on()

bij MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()

bij MySql.Data.MySqlClient.MySqlPool.GetConnection()

bij MySql.Data.MySqlClient.MySqlConnection.Open()

bij PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo)

 

 

i managed the stuff with phpmyadmin, so, where did i misfired.

 

think i found it, makeing a user not at localhost wont work i guess.. lets wait.....

[ImportBot]

Originally Posted by CaptCourage*:

 

Unfortunately, XpKiller -- this plugin's author -- has not showed himself around here for quite some time. You will need to edit the C# source code of this plugin if you wish for it to work with the latest sql version. Do you need help modifying the sql table builder queries in the source code of this plugin?

Ty_ger...Thanks for your reply. As I do not code myself, your proposition sounds excellent. I would really like to have adkats operational. Any assistance with this would be gladly appreciated.

Pop into my ts anytime mate 43.245.160.15:10028.

[ImportBot]

Originally Posted by irdx*:

 

ok, so i messed up my sql setup masivly.

tried to rebuild with clean stuff, but didnt manage to create user account for adkats/statlogger.

 

installed xampp ,made a user account first and created the adkats database.

both xampp and procon are running on the same machine.

 

but i get this message when starting the stats logger.

 

Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Authentication to host '127.0.0.1' for user 'xxxxx' using method 'mysql_native_password' failed with message: Access denied for user 'xxxx'@'localhost' (using password: YES) ---> MySql.Data.MySqlClient.MySqlException: Access denied for user 'xxxx'@'localhost' (using password: YES)

bij MySql.Data.MySqlClient.MySqlStream.ReadPacket()

bij MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.ReadPacket()

--- Einde van intern uitzonderingsstackpad ---

bij MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.AuthenticationFailed(Exception ex)

bij MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.ReadPacket()

bij MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.Authenticate(Boolean reset)

bij MySql.Data.MySqlClient.NativeDriver.Open()

bij MySql.Data.MySqlClient.Driver.Open()

bij MySql.Data.MySqlClient.Driver.Create(MySqlConnecti onStringBuilder settings)

bij MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on()

bij MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()

bij MySql.Data.MySqlClient.MySqlPool.GetConnection()

bij MySql.Data.MySqlClient.MySqlConnection.Open()

bij PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo)

 

 

i managed the stuff with phpmyadmin, so, where did i misfired.

 

think i found it, makeing a user not at localhost wont work i guess.. lets wait.....

You need to grant access to your database user:

 

GRANT ALL PRIVILEGES TO 'user'@'127.0.0.1' ON yourdb.* IDENTIFIED BY 'youruserpassword';

[ImportBot]

Originally Posted by spatieman*:

 

You need to grant access to your database user:

yea, found that out, my console sql is poor, i was always used to phpmyadmin.

so i installed xampp for it, geting that working wass horror to, bcouse some ports where already used.

but it is working again,, and making complete backups is a bit easy'r now.

[ImportBot]

Originally Posted by ty_ger07*:

 

Ty_ger...Thanks for your reply. As I do not code myself, your proposition sounds excellent. I would really like to have adkats operational. Any assistance with this would be gladly appreciated.

Pop into my ts anytime mate 43.245.160.15:10028.

Stop the plugin on the layer server (if it is running for some reason).

 

Open the file 'CChatGUIDStatsLogger.inc'. On line 5429, change `TeamID` smallint(5) DEFAULT NULL, to `TeamID` smallint(5) unsigned NOT NULL,.

 

Save the file. Upload it to your layer server. Start the plugin on the layer server. It should work now.

 

I have no way to test since I don't have that new of a database to test on and I don't have a game server or layer server to start the process either. Let me know if it does or does not work.