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

ImportBot · June 6, 2013

Originally Posted by Tomgun*:

in the other post it says

This is due to Connector/NET 6.6 dropping support for "old style" password authentication. Make sure your database password authentication is changed to not use old style authentication.

I asked the guy who deals with our website and he said the old style is not on and never was so it should be fine

ImportBot · June 6, 2013

Originally Posted by ty_ger07*:

in the other post it says

I asked the guy who deals with our website and he said the old style is not on and never was so it should be fine

Rather than saying it isn't or thinking it isn't, can you just have him run this query to make sure?

Code:

SELECT @@session.old_passwords, @@global.old_passwords;

Just run it in phpMyAdmin while logged into that database. It's the best way to know for sure.

ImportBot · June 6, 2013

Originally Posted by Tomgun*:

Rather than saying it isn't or thinking it isn't, can you just have him run this query to make sure?

Code:
SELECT @@session.old_passwords, @@global.old_passwords;
Just run it in phpMyAdmin while logged into that database. It's the best way to know for sure.

ok will do cheers

ImportBot · June 6, 2013

Originally Posted by ty_ger07*:

ok will do cheers

Once you confirm that, I would make sure he tries to rehash the password. Even if the database is currently using new style password authentication, that doesn't mean that the password wasn't hashed using old style password authentication.

Code:

SET PASSWORD FOR 'user-name-here'@'hostname-name-here' = PASSWORD('new-password-here');

Since you have already confirmed that the database is set up to use new style authentication by this point, setting the password again will rehash it and make sure that the password is hashed in the new authentication method.

And if that doesn't help, then you should look at verifying the correct username and password and verifying that the database is set up to allow external connections from IPs other than itself.

ImportBot · June 10, 2013

Originally Posted by ty_ger07*:

Any luck?

ImportBot · June 11, 2013

Originally Posted by Tomgun*:

still trying to sort, ill post when got new info

ImportBot · June 24, 2013

Originally Posted by Snowy*:

Is there any way to export the top 10 players to an HTML page?

I'd like to put that on our clan website but have no idea how to do it...

ImportBot · June 24, 2013

Originally Posted by ty_ger07*:

Is there any way to export the top 10 players to an HTML page?

I'd like to put that on our clan website but have no idea how to do it...

Not with HTML. HTML is static. You need something dynamic. Look at the link in my signature.

ImportBot · June 24, 2013

Here's my stats Page http://kackboon.org/top2.php

<_php
    include 'inc/dbconnect.php';

//Sort by
$stats = "Score";

$server= "1";
$limit = "250";

$count = 1;
$query = "select tbl_playerdata.SoldierName, tbl_playerstats.Score, tbl_playerstats.Kills, tbl_playerstats.Headshots, tbl_playerstats.Deaths, tbl_playerstats.Suicide, tbl_playerstats.TKs, tbl_playerstats.Rounds, tbl_playerstats.Killstreak, tbl_playerstats.Deathstreak, tbl_playerstats.Wins, tbl_playerstats.Losses, tbl_playerstats.HighScore, tbl_playerdata.CountryCode, tbl_server.ServerName
from tbl_playerstats, tbl_server_player, tbl_playerdata, tbl_server
where tbl_playerstats.StatsID = tbl_server_player.StatsID and tbl_playerdata.PlayerID = tbl_server_player.PlayerID and tbl_server_player.ServerID = tbl_server.ServerID and tbl_server.ServerID like '".$server."'
order by tbl_playerstats.".$stats." desc
limit ".$limit;

$result = mysql_query($query) or die(mysql_error())
_>
<!-- Query:
<_php echo $query; _>
-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Top <_php echo $limit_> Spieler</title>
<style>
    .headlines {
        text-decoration:underline;
    }
.tr {
        border-style:solid;
        border-width:1px;
        border-color:black;
    }
    .country {text-align:center;}
</style>
</head>

<body>
<h2 style="text-align:center; ">Top <_php echo $limit_> (ordered by <_php echo $stats; _>)</h2>

<table style="width:100%; ">
    <tr class="headlines"><td style="text-align:center;">#</td><td style='width:18px; text-align:center; '><img src="../img/globe.png" /></img></td><td>Name</td><td>Score</td><td>Kills</td><td>HeadShots</td><td>Deaths</td><td>Suicide</td><td>TeamKills</td><td>Rounds</td><td>Killstreak</td><td>Deathstreak</td><td>Wins</td><td>Losses</td></tr><tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<_php    while($row = mysql_fetch_assoc($result)) {

print "<tr class='tr' ";
if(($count%2) == "0") {print "style='background-color:white;'";} else {print "style='background-color:LightGray;'";};
print ">";

print "<td style='text-align:center;'>";
print $count;
print "</td>";

print "<td class='country' style='width:18px; text-align:center; '>";
print "<img src='img/flag/".$row[CountryCode].".gif'></img>";
print "</td>";

print "<td>";
print "$row[SoldierName]";
print "</td>";    

print "<td>";
print "$row[Score]";
print "</td>";

print "<td>";
print "$row[Kills]";
print "</td>";

print "<td>";
print "$row[Headshots]";
print "</td>";

print "<td>";
print "$row[Deaths]";
print "</td>";

print "<td>";
print "$row[Suicide]";
print "</td>";

print "<td>";
print "$row[TKs]";
print "</td>";

print "<td>";
print "$row[Rounds]";
print "</td>";

print "<td>";
print "$row[Killstreak]";
print "</td>";

print "<td>";
print "$row[Deathstreak]";
print "</td>";

print "<td>";
print "$row[Wins]";
print "</td>";

print "<td>";
print "$row[Losses]";
print "</td>";

//print "<td>";
//print "$row[ServerName]";
//print "</td>";

$count++;
}
_>
</table>
</body>
</html>

Fell free to copy / modify it

Edited August 7, 2019 by maxdralle

ImportBot · June 26, 2013

@marc1307

Thanks!!! Now for the tweaking!

Edited August 7, 2019 by maxdralle

ImportBot · June 26, 2013

Originally Posted by Snowy*:

Not with HTML. HTML is static. You need something dynamic. Look at the link in my signature.

Thanks to you too!

I'll have to check it out!

ImportBot · June 28, 2013

Originally Posted by Salzstange*:

Hey guys, how can i realize that a message appears in the chat at the beginning of every new round:

Type !rank for your rank

Type !top10 for the top ten of the server

for example. Is there any option? Sorry but my English isnt very good

ImportBot · July 4, 2013

Originally Posted by rasvib*:

Hello

I have this error , can you help me ?

Code:

Error: SQLQuery:
[23:02:42 91] Message: Unable to connect to any of the specified MySQL hosts.
[23:02:42 91] Native: -2147467259
[23:02:42 91] Source: MySql.Data
[23:02:42 91] StackTrace:    Ã  MySql.Data.MySqlClient.NativeDriver.Open()
   Ã  MySql.Data.MySqlClient.Driver.Open()
   Ã  MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   Ã  MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
   Ã  MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   Ã  MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
   Ã  MySql.Data.MySqlClient.MySqlPool.GetConnection()
   Ã  MySql.Data.MySqlClient.MySqlConnection.Open()
   Ã  System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
   Ã  System.Data.Common.DbDataAdapter.FillInternal(DataSet 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(MySqlCommand selectQuery)
[23:02:42 91] InnerException: System.Net.Sockets.SocketException: Une tentative de connexion a échoué car le parti connecté n'a pas répondu convenablement au-delà d'une certaine durée ou une connexion établie a échoué car l'hôte de connexion n'a pas répondu 54.215.148.52:3306
   Ã  System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult)
   Ã  MySql.Data.Common.StreamCreator.CreateSocketStream(IPAddress ip, Boolean unix)
   Ã  MySql.Data.Common.StreamCreator.GetStreamFromHost(String pipeName, String hostName, UInt32 timeout)
   Ã  MySql.Data.Common.StreamCreator.GetStream(UInt32 timeout)
   Ã  MySql.Data.MySqlClient.NativeDriver.Open()

ImportBot · July 4, 2013

Originally Posted by Xia0_Xia0*:

So I was trying to install this addon today and it went smooth.. sort of

23 tables were made in my database but not all of the got updated.

the only 2 tables that got some sort of records are chatlog and playerdata

then I got an error in procon saying this:

[01:04:14 36] Error: Error in Startstreaming:

[01:04:14 36] Message: Cannot add or update a child row: a foreign key constraint fails (`sid91256_1`.`tbl_server_player`, CONSTRAINT `fk_tbl_server_player_tbl_server` FOREIGN KEY (`ServerID`) REFERENCES `tbl_server` (`ServerID`) ON DELETE CASCADE ON UPDATE NO ACTION)

[01:04:14 36] Native: -2147467259

[01:04:14 36] Source: MySql.Data

[01:04:14 36] 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.ExecuteNonQuer y()

bei PRoConEvents.CChatGUIDStatsLoggerBF3.StartStreamin g()

[01:04:14 37] Error: Error in UpdateRanking: System.InvalidOperationException: Nested transactions are not supported.

bei MySql.Data.MySqlClient.ExceptionInterceptor.Throw( Exception exception)

bei MySql.Data.MySqlClient.MySqlConnection.BeginTransa ction(IsolationLevel iso)

bei PRoConEvents.CChatGUIDStatsLoggerBF3.UpdateRanking ()

[01:04:15 29] Error: Error in Startstreaming OuterException: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLoggerBF3.DisplayMySqlE rrorCollection(MySqlException myException)

bei PRoConEvents.CChatGUIDStatsLoggerBF3.StartStreamin g()

stats logging is on and chat logging is on

am I missing anything?

ImportBot · July 4, 2013

Originally Posted by Prophet731*:

Hello

I have this error , can you help me ?

Code:

Error: SQLQuery:
[23:02:42 91] Message: Unable to connect to any of the specified MySQL hosts.
[23:02:42 91] Native: -2147467259
[23:02:42 91] Source: MySql.Data
[23:02:42 91] StackTrace:    Ã  MySql.Data.MySqlClient.NativeDriver.Open()
   Ã  MySql.Data.MySqlClient.Driver.Open()
   Ã  MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   Ã  MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
   Ã  MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   Ã  MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
   Ã  MySql.Data.MySqlClient.MySqlPool.GetConnection()
   Ã  MySql.Data.MySqlClient.MySqlConnection.Open()
   Ã  System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
   Ã  System.Data.Common.DbDataAdapter.FillInternal(DataSet 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(MySqlCommand selectQuery)
[23:02:42 91] InnerException: System.Net.Sockets.SocketException: Une tentative de connexion a échoué car le parti connecté n'a pas répondu convenablement au-delà d'une certaine durée ou une connexion établie a échoué car l'hôte de connexion n'a pas répondu 54.215.148.52:3306
   Ã  System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult)
   Ã  MySql.Data.Common.StreamCreator.CreateSocketStream(IPAddress ip, Boolean unix)
   Ã  MySql.Data.Common.StreamCreator.GetStreamFromHost(String pipeName, String hostName, UInt32 timeout)
   Ã  MySql.Data.Common.StreamCreator.GetStream(UInt32 timeout)
   Ã  MySql.Data.MySqlClient.NativeDriver.Open()

That error is saying it couldn't connect to your database. Check your database settings to make sure they are correct.

ImportBot · July 4, 2013

Originally Posted by Prophet731*:

So I was trying to install this addon today and it went smooth.. sort of

23 tables were made in my database but not all of the got updated.

the only 2 tables that got some sort of records are chatlog and playerdata

then I got an error in procon saying this:

stats logging is on and chat logging is on

am I missing anything?

It looks like when the plugin created the tables some of them weren't fully setup. If you don't have any data or very little I suggest you delete all those tables and run the plugin again to create the tables again. That should possibly fix your problem.

ImportBot · July 4, 2013

Originally Posted by Xia0_Xia0*:

just dropped all the tables and re-ran the addon... restarted the server and procon layer... we will see what i get when the server gets full

ImportBot · July 4, 2013

Originally Posted by Prophet731*:

You shouldn't have to restart the game server or procon for the tables to be created. Just saying.

ImportBot · July 4, 2013

Originally Posted by rasvib*:

That error is saying it couldn't connect to your database. Check your database settings to make sure they are correct.

Hello,

I checked and stats are uploaded to db, but since last night i get this message from time to time.

Sent from my iPhone using Tapatalk

ImportBot · July 5, 2013

Originally Posted by Prophet731*:

Hello,

I checked and stats are uploaded to db, but since last night i get this message from time to time.

Sent from my iPhone using Tapatalk

Then the plugin must be losing connection with the mysql server. Thats what the error is telling you. If its happening on occasion.

ImportBot · July 5, 2013

Originally Posted by rasvib*:

ok not a big matter then, thank you

Sent from my iPhone using Tapatalk

ImportBot · July 5, 2013

Originally Posted by rasvib*:

Hello,

I made a request here showthread....ed-to-mysql-db*

Hope i'm in the good thread for asking this.

Do you think its possible to add a feature that reserve slots for a TopX player depending on a sql request, and add the option of time/day when the plugin should update the reserved slots.

And a list for admin.

ImportBot · July 6, 2013

Originally Posted by 24Flat*:

Hi xp I have been running your plugin for quite a while with no issues, I implemented [bF3] Server Stats page for XpKiller's 'BF3 Chat, GUID, Stats and Mapstats Logger' Everything works great but the page does not show when people are in the server.

ty_ger07 replied

Do you have XpKiller's PRoCon stats plugin set to update current players data? It's an option in his plugin, which if disabled, won't save current players to the database.

I don't see this setting in your Stats.. Logger. I'm running 1.0.1.0 any help would be greatly appreciated

ImportBot · July 29, 2013

Originally Posted by Hutchew*:

It doesn't work. Been there, tried that. It's got to be a bug with the way the plugin checks for the CountryCode and submits it to MySQL. I don't have the resources to go through all 8500 lines of code and decipher someone else's coding. Maybe the devs can step in and shed some light on a fix.

I've even tried increasing the VARCHAR character limit to 5 on the table structure to allow for the "N/A" to be inserted but it still throws an error and crashes.

Edit:

Ok, so the fix is to set both the table playerdata and currentplayers CountryCode VARCHAR limit to 7+. What happens when a player is not in the GeoIP.dat file, is the plugin logs the CountryCode as unknown. Obviously originally setting the field to allow only 5 chars didn't work because the word unknown has 7 letters therefore causing the plugin to throw the error. See here:

http://i.imgur.com/J4uuC7G.jpg

Hope this helps.

Just bringing this back to the top of the pile. Had this issue again when torture testing ADKATS on a fresh DB, causing our layers to crash. ADKATS was not the cause of our problems; since applying this fix, layers are now stable.

Hutchew

ImportBot · July 30, 2013

Originally Posted by ColColonCleaner*:

Just bringing this back to the top of the pile. Had this issue again when torture testing ADKATS on a fresh DB, causing our layers to crash. ADKATS was not the cause of our problems; since applying this fix, layers are now stable.

Hutchew

If the underlying issue wasn't AdKats could you please reply in that thread saying such? Thanks

ImportBot · July 30, 2013

Originally Posted by ColColonCleaner*:

Hey killer, suggesting a 4 line addition to your plugin. Simply to add a registered name with procon so other plugins can know if stat logger is installed and running on the current layer. I am currently using the connected database to get this information, but having another layer of confirmation would be nice.

private MatchCommand LoggerAvailableIndicator;

this.LoggerAvailableIndicator= new MatchCommand("BF3ChatGUIDStatsandMapstatsLogger", "NoCallableMethod", new List(), "BF3ChatGUIDStatsandMapstatsLogger_NoCallableMetho d", new List(), new ExecutionRequirements(ExecutionScope.None), "Useable by other plugins to determine whether this logger is installed and enabled.");

//Register a command to indicate availibility to other plugins on enable

this.RegisterCommand(this.LoggerAvailableIndicator );

//Unregister command on disable

this.UnregisterCommand(this.LoggerAvailableIndicat or);

ImportBot · July 31, 2013

Originally Posted by ty_ger07*:

Hi xp I have been running your plugin for quite a while with no issues, I implemented [bF3] Server Stats page for XpKiller's 'BF3 Chat, GUID, Stats and Mapstats Logger' Everything works great but the page does not show when people are in the server.

ty_ger07 replied

I don't see this setting in your Stats.. Logger. I'm running 1.0.1.0 any help would be greatly appreciated

BTW, he found out that the problem was that he was using an old plugin version.

ImportBot · August 5, 2013

Originally Posted by Shakal-hh*:

can someone help?

[18:36:04 27] BF3 Chat, GUID and Stats Logger Enabled

[18:36:04 27] BF3 Chat, GUID and Stats Logger: Floodprotection set to 10 Request per Round for each Player

[18:36:07 19] Error: System.TypeInitializationException: Der Typeninitialisierer für "MySql.Data.MySqlClient.MySqlPoolManager" hat eine Ausnahme verursacht. ---> System.Security.SecurityException: Fehler bei der Anforderung des Berechtigungstyps "System.Security.Permissions.SecurityPermissio n, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089".

bei MySql.Data.MySqlClient.MySqlPoolManager..cctor()

Die Aktion, bei der ein Fehler aufgetreten ist:

LinkDemand

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

System.Security.Permissions.SecurityPermission

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

MyComputer

--- Ende der internen Ausnahmestapelüberwachung ---

bei MySql.Data.MySqlClient.MySqlPoolManager.GetPool(My SqlConnectionStringBuilder settings)

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

bei PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[18:36:07 19] Error: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[18:36:10 94] Error: System.TypeInitializationException: Der Typeninitialisierer für "MySql.Data.MySqlClient.MySqlPoolManager" hat eine Ausnahme verursacht. ---> System.Security.SecurityException: Fehler bei der Anforderung des Berechtigungstyps "System.Security.Permissions.SecurityPermissio n, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089".

bei MySql.Data.MySqlClient.MySqlPoolManager..cctor()

Die Aktion, bei der ein Fehler aufgetreten ist:

LinkDemand

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

System.Security.Permissions.SecurityPermission

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

MyComputer

--- Ende der internen Ausnahmestapelüberwachung ---

bei MySql.Data.MySqlClient.MySqlPoolManager.GetPool(My SqlConnectionStringBuilder settings)

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

bei PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[18:36:10 94] Error: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[18:36:10 95] Error: getUpdateServerID1: System.TypeInitializationException: Der Typeninitialisierer für "MySql.Data.MySqlClient.MySqlPoolManager" hat eine Ausnahme verursacht. ---> System.Security.SecurityException: Fehler bei der Anforderung des Berechtigungstyps "System.Security.Permissions.SecurityPermissio n, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089".

bei MySql.Data.MySqlClient.MySqlPoolManager..cctor()

Die Aktion, bei der ein Fehler aufgetreten ist:

LinkDemand

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

System.Security.Permissions.SecurityPermission

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

MyComputer

--- Ende der internen Ausnahmestapelüberwachung ---

bei MySql.Data.MySqlClient.MySqlPoolManager.GetPool(My SqlConnectionStringBuilder settings)

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

bei PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

[18:36:20 94] Error: System.TypeInitializationException: Der Typeninitialisierer für "MySql.Data.MySqlClient.MySqlPoolManager" hat eine Ausnahme verursacht. ---> System.Security.SecurityException: Fehler bei der Anforderung des Berechtigungstyps "System.Security.Permissions.SecurityPermissio n, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089".

bei MySql.Data.MySqlClient.MySqlPoolManager..cctor()

Die Aktion, bei der ein Fehler aufgetreten ist:

LinkDemand

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

System.Security.Permissions.SecurityPermission

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

MyComputer

--- Ende der internen Ausnahmestapelüberwachung ---

bei MySql.Data.MySqlClient.MySqlPoolManager.GetPool(My SqlConnectionStringBuilder settings)

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

bei PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[18:36:20 94] Error: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[18:36:20 95] Error: getUpdateServerID1: System.TypeInitializationException: Der Typeninitialisierer für "MySql.Data.MySqlClient.MySqlPoolManager" hat eine Ausnahme verursacht. ---> System.Security.SecurityException: Fehler bei der Anforderung des Berechtigungstyps "System.Security.Permissions.SecurityPermissio n, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089".

bei MySql.Data.MySqlClient.MySqlPoolManager..cctor()

Die Aktion, bei der ein Fehler aufgetreten ist:

LinkDemand

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

System.Security.Permissions.SecurityPermission

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

MyComputer

--- Ende der internen Ausnahmestapelüberwachung ---

bei MySql.Data.MySqlClient.MySqlPoolManager.GetPool(My SqlConnectionStringBuilder settings)

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

bei PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

EDIT:

done. have tested the "beta" version and it works

ImportBot · August 11, 2013

Originally Posted by _lecro_*:

Anyone know how i can work out maximum number of queries to our SQL server the plugin requires at any one time ?

is it dependant on the number of players or is it just one for the whole plugin and just reading/writing when it needs to.

The reason i ask is every few days we are getting errors

after flushing hosts all is good for a few days then they come back again.

For E.G

16:29:30 66] Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Host '81.**.***.**' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

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.CreateNewPooledCo nnection()

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

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

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

ImportBot · August 12, 2013

Originally Posted by Porthos1973*:

Does anyone know of a host that offers this set up with the hosting? I use to use www.rconhostingservices.net but it looks like the site is being maintained anymore and now response letting them the order page isn't working. They offered the layer and set this plugin up as well as the stats page so made it real easy.

Sign In

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

Recommended Posts

Link to comment

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Join the conversation

Important Information