Chat, GUID, Stats and Mapstats Logger[3.0.2.2] 01.02.

[ImportBot]

Originally Posted by TimSad*:

 

Okay, WTF_! I go to update my Rush server's CChatGUIDStatsLogger plugin manually by FTPing the CChatGUIDStatsLogger.cs file to Plugins/BFBC2/ after deleting the older one and it's DLL file first. I then restart the Procon server then go to the plugin list and don't see it there.

 

I then delete CChatGUIDStatsLogger.cs and the DLL again and try installing from the package. Doing that successfully installed the updated version to my other two Procon servers but came back as "Layer already has package installed" for my Rush server. After that, I went into my local directory of Packages and deleted the CChatGUIDStatsLogger.xml to try the install again after deleting the files once again. Still, I get the same thing, "Layer already has package installed."

 

Anyone here able to help me out or do you think I'll have to contact my Procon service provider, Primary Target, for this one_...

 

Here's the screenshot! Click for larger view...

[ImportBot]

Originally Posted by TimSad*:

 

Grrr! Still not showing up in the plugin list after trying different versions. I don't even see it creating a DLL.

[ImportBot]

Originally Posted by Stryker412*:

 

I have a small issue. My own stats on our server don't seem to be updating. My rank still shows as a 12 even though I'm a 25. I was able to get my stats updated on BFBC2 Stats, and it correctly shows me as a 25 but the stats on our website still shows me as a 12. Any idea how I can get that to update?

[ImportBot]

Originally Posted by XpKiller*:

 

I have a small issue. My own stats on our server don't seem to be updating. My rank still shows as a 12 even though I'm a 25. I was able to get my stats updated on BFBC2 Stats, and it correctly shows me as a 25 but the stats on our website still shows me as a 12. Any idea how I can get that to update?

The plugin update by default if you join the server and the entry in the tbl_bfbcs is older than 72 hours.

You can lower this value if you want. I can update the whole database this would be insane if the database contains more than 10k players.

[ImportBot]

Originally Posted by nbtc971*:

 

Here are all the queries coming across from the plugin (attachment). At the bottom, at the end of a round, you'll see that no INSERT queries are made EXCEPT those that are going to Myisam tables. There appears to be some logic problem, at least when it comes to Vietnam SQDM servers.

 

By the way this test and log was possible due to micovery offering his linux server and mysql DB. He took care of setting it up and setting up the logging. I greatly appreciate his help.

 

XPkiller, he has offered to help you debug this problem by offering his linux system and access to his mysql db.

 

Thanks guys!

 

plugin_test.zip[/attachment:2etx53in]

[ImportBot]

Originally Posted by XpKiller*:

 

Problem is solved from my point of view something is wrong with the gameserver so that Punkbuster didnt work correctly this causes the malfunktion of the plugin.

[ImportBot]

Originally Posted by thetoast*:

 

Code:

Error in DownloadBFBCS: System.Net.WebException: The remote server returned an error: (500) Internal Server Error.
   at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)
   at System.Net.WebClient.DownloadString(Uri address)
   at System.Net.WebClient.DownloadString(String address)
   at PRoConEvents.CChatGUIDStatsLogger.DownloadBFBCS(Object ListObject)

What is this error?

[ImportBot]

Originally Posted by XpKiller*:

 

And another time this error is sent by the bfbcs server. Error 500 stands for unexpected error in case of bfbcs it mostly means that the server is overloaded . Don't worry about this.

[ImportBot]

Originally Posted by thetoast*:

 

thanks

[ImportBot]

Originally Posted by nbtc971*:

 

The problem is solved. The game server host has a problem with Punkbuster on one of their servers and I was on that server. After almost a week of trying to get moved off the server I finally managed to do that early this morning. Just had people on the new server and it is recording stats accurately.

 

Thanks to XPKiller and especially micovery who setup his Linux and mysql server so we could do testing. That was going above and beyond to help someone you don't know. Thank you again!

[ImportBot]

Originally Posted by Trizik*:

 

correct me if i'm wrong but basically this plugin can't be used in conjunction with any webhost that uses cpanel because the latest version of MySQL supported by cpanel is 5.0.91-community and this plugin requires version 5.1.x

 

kind of a bummer as most webhosts including mine use cpanel...

 

is there any possible way to get this plugin to work with MySQL 5.0.91-community? if not would you guys please recommend an affordable/free MySQL 5.1.x host?

 

thanks.

[ImportBot]

Originally Posted by Trizik*:

 

I found a online sql host that works

http://www.freesqldatabase.com

 

works without any problems right now

does this host still work for you?

 

i tried it and was able to connect to and write to the database from PRoCon (running on a home PC) but when i try to access the database using either of the stat scripts here (P&S and =BB=Insomnia's webstats) on various webhosts (i have multiple, all running MySQL 5.0.91 and latest PHP) my browser just sits at "waiting for reply" for a long time and eventually displays a blank page or an "Internal Server Error" message.

 

if i export the database from freesqldatabase.com then import it to any of my webhosts, the webstats scripts display the data from my webhosts' databases without hiccup.

 

PRoCon can't connect to the databases on my webhosts because it requires MySQL 5.1.x and my webhosts all use MySQL 5.0.91

 

what's my solution?

[ImportBot]

Originally Posted by Phil_K*:

 

Hi.

 

PRoCon can't connect to the databases on my webhosts because it requires MySQL 5.1.x and my webhosts all use MySQL 5.0.91

Have you tried it?

I use the plugin with MySQL 5.0.45 and the ODBC 5.1 connector without problems.

 

Greets

Phil.

[ImportBot]

Originally Posted by XpKiller*:

 

I just recommend MySQL 5.1.x or greater due the greater stability of the innodb plugin. In 5.5 Innodb is the default Databaseengine.

[ImportBot]

Originally Posted by Trizik*:

 

Hi.

 

 

 

Have you tried it?

I use the plugin with MySQL 5.0.45 and the ODBC 5.1 connector without problems.

 

Greets

Phil.

yes of course, on different hosts running 5.0.91 -- PRoCon won't connect to their MySQL databases. when i configure PRoCon to use a host that's running 5.1.x (such as freesqldatabase.com) PRoCon connects without hiccup.

 

the machine running PRoCon has the ODBC 5.1 driver installed (does it need to be configured at all_) and it's on the hosts' remote MySQL access lists.

 

MySQL host must accept remote connections and use INNODB. what else is required?

[ImportBot]

Originally Posted by Trizik*:

 

I just recommend MySQL 5.1.x or greater due the greater stability of the innodb plugin. In 5.5 Innodb is the default Databaseengine.

so MySQL 5.0.91-community will work, right?

[ImportBot]

Originally Posted by XpKiller*:

 

i didnt test on anything below 5.1.x so i cant say for sure that it will work.

[ImportBot]

Originally Posted by Trizik*:

 

it's finally working now that my host made some adjustments on their end.

 

i'm confirming that MySQL 5.0.91-community works with the current version (3.0.2.2) of this plugin.

[ImportBot]

Originally Posted by NilsBov*:

 

I get "specific weapon not found!!" when i type !stats, !rank, !top10 when there is more then one on the server. but if im alone it works perfect.

The stats is updating in the database but i cant view them ingame unless i am alone.

 

I attached my settings

 

Attached Files:

• Untitled.jpg

[ImportBot]

Originally Posted by XpKiller*:

 

@NilsBov

 

i cant read anything on this pic its too small.

[ImportBot]

Originally Posted by NilsBov*:

 

Here you go

 

[ImportBot]

Originally Posted by MorpheusX(AUT)*:

 

Getting

[13:45:19 35] Error in LogChat:

[13:45:19 35] Index #0

[13:45:19 35] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.1.51-community]Duplicate entry '25607' for key 'PRIMARY'

[13:45:19 35] Native: 1062

[13:45:19 35] Source: myodbc5.dll

[13:45:19 35] SQL: 23000

Since yesterday afternoon. Could this have to be with me reinstalling the network-card drivers on my root?

[ImportBot]

Originally Posted by XpKiller*:

 

This error is related to the tbl_chatlog it seems that mysql has a wrong autoincrement value . The plugin doesn't modifies this entry .

You can fix it by setting the default autoincrement value higher than your greatest is value.

[ImportBot]

Originally Posted by XpKiller*:

 

@NilsBov

I can't see any mistakes in you settings.

But you should increase the bfbcs update interval to 12 or higher because bfbcs allows one update every 12 hours per player .

A lower value doesn't make sense because you will get the same stats like one hour ago.

[ImportBot]

Originally Posted by gabipaci*:

 

Hi!

 

How to can i set the kill streak in a row counter in webstat?

Webstat here

Procon settings here:

[ImportBot]

Originally Posted by RedOne1*:

 

I searched for my problem on the forum and i fine something but when i click on the link I will be forwarded to page 1 of this topic. So i have to make a new reply because I think search function of the forum is a bit confused.

 

Running Weapon/chat stats logger 3.0.2.2 i get this error:

 

[20:42:34 88] Error in Startstreaming:

[20:42:34 88] Index #0

[20:42:34 88] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.1.46-community]Field 'tUpdate' doesn't have a default value

[20:42:34 88] Native: 1364

[20:42:34 88] Source: myodbc5.dll

[20:42:34 89] SQL: HY000

 

Whats wrong?

 

GrTz Red

[ImportBot]

Originally Posted by XpKiller*:

 

Hi RedOne1,

This error is not caused by my plugin because the field tUpdate normally doesnt exists. This field is created by p&s Stats. ( Good example what can happen if you alter a table)

P & S seems not to set a default values for this field. So if you Mysql Server runs in Strict Mode you will get an error like yours.

You can fix that by define a default value of "0" to this field. Also you should report that the the author of P&S Stats.

If you need help feel free to ask.

[ImportBot]

Originally Posted by EoT-Honk*:

 

We fixed this..

New install with default value..

No more problems in the Strict mode

[ImportBot]

Originally Posted by RedOne1*:

 

XPKiller and Honk both thanks for the replies,

 

I will look at it after dinner

 

GrTz Red

[ImportBot]

Originally Posted by IIIAVIII*:

 

I want to use your cheaterprotection module only without any database stuff.

Is it possible? Will it work without mysql?