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

[ImportBot]

Originally Posted by Joshman2934*:

 

I found a online sql host that works

http://www.freesqldatabase.com

 

works without any problems right now

[ImportBot]

Originally Posted by Basert*:

 

I get this:

 

Code:

Error in DownloadBFBCS: System.Security.SecurityException: Request for the permission of type 'System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
   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)
The action that failed was:
Demand
The type of the first permission that failed was:
System.Net.WebPermission
The Zone of the assembly that failed was:
MyComputer

if BFBCs is enabled.

 

 

€dit: Have found the error, haven't added api.bfbcs to the whitelist

[ImportBot]

Originally Posted by Fussballgott*:

 

Hi,

 

Welcomestats are working, Session command too.

But rank, stats (with or without weapon/map name) and top10 commands just give me the following message back: "Specifc Weapon not found!!"

(btw Specific)

 

And the configuration for the cheater protection is not showing in procon.

 

I initially installed V3.0.1.4 and upgrade to V3.0.2.1

[ImportBot]

Originally Posted by haclevan*:

 

i didnt had such problems but i will take a look at i try to reproduce and fix it.

I have the same problem. Procon crash since I use the current version one time per day.

Can I support you to find the bug (logs, debugfiles etc)?

[ImportBot]

Originally Posted by XpKiller*:

 

Hi,

 

Welcomestats are working, Session command too.

But rank, stats (with or without weapon/map name) and top10 commands just give me the following message back: "Specifc Weapon not found!!"

(btw Specific)

 

And the configuration for the cheater protection is not showing in procon.

 

I initially installed V3.0.1.4 and upgrade to V3.0.2.1

You need to wait one Round to see your stats. The plugin writes the data back to db when the Round ends.

 

To see the point Cheater Protection you must turn on Fetch Stats from BFBCS.

 

@haclevan

To help finding this bug enable Logging in Procon you find it under Options in the Tab Basics.

And sent the the log files to me.

[ImportBot]

Originally Posted by Fussballgott*:

 

You need to wait one Round to see your stats. The plugin writes the data back to db when the Round ends.

 

To see the point Cheater Protection you must turn on Fetch Stats from BFBCS.

Cheaterprotection found, thx.

And there is already a lot playerdata in the db, so I suppose commands like top10 should work - welcome stats are working after all.

[ImportBot]

Originally Posted by XpKiller*:

 

the top10 command is working for me.

if you use top10 weaponname make sure the the weaponname is know by the plugin you can see the list of weapons looks: Keywordlist BC2 or Vietnam.

You can add own weaponname by write them in these {}.

Example: AK47V{AK47,AK-74}

[ImportBot]

Originally Posted by haclevan*:

 

@haclevan

To help finding this bug enable Logging in Procon you find it under Options in the Tab Basics.

And sent the the log files to me.

Done

[ImportBot]

Originally Posted by tonyboy77*:

 

its possible to add a language.php for translate this plugin? :_: :_:

 

sorry bad tread

[ImportBot]

Originally Posted by XpKiller*:

 

its possible to add a language.php for translate this plugin? :_: :_:

Do you talk about webstats? Because my plugin is written in C# not PHP

 

ATM: Experimenting with the HTTPServer function of Procon so you guy could get a playerlist with ranks

[ImportBot]

Originally Posted by feeblemedic*:

 

I need some assistance. I recently activated this plugin on two of my servers...one bc2 server and one vietnam server.

 

Server #1 is BC2 and Server #2 is vietnam....the only difference in configuration of the plugin is that i have the default game mod set to "BC2" on server #1 and "Vietnam" on server #2.

 

I get no errors on server #2; however I get the following error messages on server #1 plugin tab:

 

Error in Startstreaming:

Index#0

Message: ODBC 5.1 driver mysqld 5.0.91.(shortened since i cant copy and paste)unknown column 'StatsID' in field list'

Native: 1054

Source: myodbc5.dll

SQL: 42S22

 

Can anyone help me with this issue?

[ImportBot]

Originally Posted by Fussballgott*:

 

the top10 command is working for me.

if you use top10 weaponname make sure the the weaponname is know by the plugin you can see the list of weapons looks: Keywordlist BC2 or Vietnam.

You can add own weaponname by write them in these {}.

Example: AK47V{AK47,AK-74}

[07:58:16 06] Your Weapontable is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

 

rank, stats, top10 is not working - Specfic weapon not found.

And this message comes up when I do not enter a weapon name, just /@rank, /@stats, /@top10.

[ImportBot]

Originally Posted by XpKiller*:

 

@feeblemedic

Are both server in the same database ?

Could you post a screen shot of your tables?

And of your plugin configuration but leave password out or blur it.

 

@fussballgott

Could you check if your all tables containing data.

Do you get welcomestats displayed ?

[ImportBot]

Originally Posted by feeblemedic*:

 

Yes both servers use same database.

 

I'm attaching the screenshots...when i compared them I noticed that server #2 was "loggging server spam" and "updating eaguid's" while server #1 (the one with the errors) did not have those two actions activated.

 

Since taking the photos i've made server #1 "update eaguid's" and i've stopped server #2 from logging server spam.

[ImportBot]

Originally Posted by XpKiller*:

 

Oh i think you got an old version of the table tbl_playerstats from 2.x, thats Reason why it doesnt work.

You run just this two servers right? Then

Stop Procon

And drop the table tbl_playerstats (tbl_playerGUID you can drop too)

And start Procon again

the plugin automatically recreate the missing table and in the right format.

Then it should work again.

 

@Fussballgott

I rechecked those commands they all working flawless in my own server, so maybe the plugin is wrong configured or there is something wrong in the database(wrong tables)

[ImportBot]

Originally Posted by Fussballgott*:

 

@fussballgott

Could you check if your all tables containing data.

Do you get welcomestats displayed ?

All tables contain data, and - like I wrote before - welcome stats are working.

[ImportBot]

Originally Posted by terwax*:

 

Code:

Error in LogChat: System.InvalidOperationException: The connection has been disabled. ---> System.Data.Odbc.OdbcException: ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.1.52]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(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)
   at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()
   at PRoConEvents.CChatGUIDStatsLogger.LogChat(String strSpeaker, String strMessage, String strType)

But software working fine O.o

[ImportBot]

Originally Posted by feeblemedic*:

 

I made the modifications you suggested and dropped those two tables. Now I get the following error on Server #1 the bc vanilla server. Settings are the same.

[ImportBot]

Originally Posted by XpKiller*:

 

This is no error of the plugin it is an error of the bfbcs server ignore it.

 

 

Terwax your sql server forced closed the connection.

[ImportBot]

Originally Posted by terwax*:

 

why woudl it do that? O.o

 

its connected to mysql off my website at hostgator

[ImportBot]

Originally Posted by Fussballgott*:

 

@fussballgott

Could you check if your all tables containing data.

Do you get welcomestats displayed ?

All tables contain data, and - like I wrote before - welcome stats are working.

And Default GameMod is set to Shared, maybe this is not that much tested?

[ImportBot]

Originally Posted by XpKiller*:

 

No this is no problem.

Have you may changed the messages for stats?

[ImportBot]

Originally Posted by Code187*:

 

Sorry to bother, is there a fix for this error_. I have enabled trusted host's.

Error in DownloadBFBCS: System.Security.SecurityException: Request for the permission of type 'System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

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(Ob ject ListObject)

The action that failed was:

Demand

The type of the first permission that failed was:

System.Net.WebPermission

The Zone of the assembly that failed was:

MyComputer

[ImportBot]

Originally Posted by HelloKitty*:

 

"enable all outgoing connections" ! let the trusted domain and port in there. Restart procon!

[ImportBot]

Originally Posted by Fussballgott*:

 

Have you may changed the messages for stats?

Nope, messages are unchanged.

[ImportBot]

Originally Posted by feeblemedic*:

 

Can running this plugin cause lag in the game server?

[ImportBot]

Originally Posted by XpKiller*:

 

Not really only if to many people requests stats like @top10 in my experience it depends also on the server itself i got server from 4netplayer which suffered laggs but at the same time the server of gameservers is not effected of this.

In general you should try not to have too many chat messages spamming on your server.

The statstracking itself does not effect the server because it runs in procon and only uses data of procon or bfbcs.

[ImportBot]

Originally Posted by TONY-TOC*:

 

I am having the error code187 wrote up. I have all outgoing connections allowed as well as in sandbox mode. All other stats are working fine but cant get the bfbcs stats to work.

 

Error in DownloadBFBCS: System.Security.SecurityException: Request for the permission of type 'System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

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(Ob ject ListObject)

The action that failed was:

Demand

The type of the first permission that failed was:

System.Net.WebPermission

The Zone of the assembly that failed was:

MyComputer

[ImportBot]

Originally Posted by XpKiller*:

 

add the "http://api.bfbcs.com" and port 80 to the trusted hosts

[ImportBot]

Originally Posted by TONY-TOC*:

 

Thank you sir!