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

[ImportBot]

Originally Posted by VAM*:

 

warum baut ihr nicht was wo jeder mit um kann?

wie meinst du das?

da muss man einen mysql server und 'ne datenbank erstellen ... ja wo? lokal? oder auf meinem gehosteten account oder wo?

viel zu umständlich! und auch noch in englisch...

 

p.s. ich habe dafür keine andere lösung - will nur meckern. 8-)

[ImportBot]

Originally Posted by Repoman1*:

 

Not sure if you are aware of this bug also. On our server stats page I am #1, but in game it says I am ranked 2 out of 24.

[ImportBot]

Originally Posted by 28thCDM*:

 

ok so i have all setting correct and everything as it should be but i still cant seem to get this to work.

so i am thinking may be i am missing something

 

I rent a procon server and this is the place where the plugin is hosted the ip is 64.79.102.218

now the game server ip is 217.163.10.125

now the ip where my database is 216.139.203.70

so with this in mind

when i set up the plugin via procon parent layer control

the host is

216.139.203.70

and the port to the data base is 3306

then my username and database password ?

 

then i restart my server and the plugin will insatll the tables to my database and then start recording players stats ? :_:

[ImportBot]

Originally Posted by Repoman1*:

 

you need to setup a remote mysql database for 217.163.10.125

[ImportBot]

Originally Posted by XpKiller*:

 

Not sure if you are aware of this bug also. On our server stats page I am #1, but in game it says I am ranked 2 out of 24.

Hi

This not really a bug because the ingame ranking is based on kills not on score because atm the scores are very inaccurate but in the next release here will be a switch for this.

I didn't wrote the php script

[ImportBot]

Originally Posted by XpKiller*:

 

ok so i have all setting correct and everything as it should be but i still cant seem to get this to work.

so i am thinking may be i am missing something

 

I rent a procon server and this is the place where the plugin is hosted the ip is 64.79.102.218

now the game server ip is 217.163.10.125

now the ip where my database is 216.139.203.70

so with this in mind

when i set up the plugin via procon parent layer control

the host is

216.139.203.70

and the port to the data base is 3306

then my username and database password ?

 

then i restart my server and the plugin will insatll the tables to my database and then start recording players stats ? :_:

Hi

Make sure that outgoing odbc connecting are allowed in procon and that you have create the database and your datebaseuser on your databaseserver and give the user the needed rights for the database

Maybe you databaseport is not 3306

 

The plugin create the table not instant it create them after a round with players on if the table not exists.

[ImportBot]

Originally Posted by MonkeyFiend*:

 

I made a smal real basic script to show the stuff from the Logger on your website.

It is realy basic and dosent look good, maybe someone can use it to make a good looking one.

I ´m not a master in programing so use it @ your own risk and find a lot of bugs :roll: .

hi,

 

I've reattached a version - found a single bug in the code - you've made some comments using // in the config.inc.php but since it's parsed as php they needed to be commented using instead (as the comments were being displayed)

 

I've reuploaded this and also changed it to display the headings in english.

 

thx

 

Monkey

[ImportBot]

Originally Posted by 28thCDM*:

 

ok so i have all setting correct and everything as it should be but i still cant seem to get this to work.

so i am thinking may be i am missing something

 

I rent a procon server and this is the place where the plugin is hosted the ip is 64.79.102.218

now the game server ip is 217.163.10.125

now the ip where my database is 216.139.203.70

so with this in mind

when i set up the plugin via procon parent layer control

the host is

216.139.203.70

and the port to the data base is 3306

then my username and database password ?

 

then i restart my server and the plugin will insatll the tables to my database and then start recording players stats ? :_:

Hi

Make sure that outgoing odbc connecting are allowed in procon and that you have create the database and your datebaseuser on your databaseserver and give the user the needed rights for the database

Maybe you databaseport is not 3306

 

The plugin create the table not instant it create them after a round with players on if the table not exists.

Thx i check with my provider and the port is 3306 so that is right and i also entered in the tools for procon ticked sandbox mode then i ticked the allow outgoing odbc

[ImportBot]

Originally Posted by XpKiller*:

 

The Plugin probably might not work atm I'm on work now

The fix will come today.

[ImportBot]

Originally Posted by Repoman1*:

 

What the scoop on updating for the plugin?

[ImportBot]

Originally Posted by XpKiller*:

 

the update will come todays

 

it was delayed because of the patch related serverproblems

[ImportBot]

Originally Posted by XpKiller*:

 

*Bump*

 

New Version 1.3

[ImportBot]

Originally Posted by Repoman1*:

 

Is there going to be an update viewer section also?

[ImportBot]

Originally Posted by Repoman1*:

 

I get this msg when i run the plugin and join the server.

 

Error in SQLQuery: System.Security.SecurityException: Request for the permission of type 'System.Data.Odbc.OdbcPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

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

at System.Security.PermissionSet.Demand()

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

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

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

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

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

at PRoConEvents.CChatGUIDStatsLogger.SQLquery(String str_selectSQL, Int32 sort)

The action that failed was:

Demand

The type of the first permission that failed was:

System.Data.Odbc.OdbcPermission

The Zone of the assembly that failed was:

MyComputer

[ImportBot]

Originally Posted by HelloKitty*:

 

At 1st I want to confirm that this plugin is working good for me:

 

installing the odcb thingy (mentioned in 1st post);

setting up sql base and user;

setting up the plugin.

 

Stats can be viewed by php-script.

 

some hints for users:

 

sql and maybe C can have problems with capital letters and special signs. So I would advise to use only small letters in the database, databaseuser and password. F.e. "ProConStats" , "Proconstats" , "procon-stats" or "procon stats" can couse problems. This depends on your windows-language and charset. You should have no problems when you name your db, user and password like "proconstats" or "statsonserver1" or "mystats".

Another tricky hint: The sql database-user can be set up to allow only connections from the localhost, restricted ip's or all hosts. So in case that your sql database is not located on the same physical machine as your procon: make sure that the sql-username is allowed to login from everywhere or from a specific IP. in this case also make sure that the sql port is forwarded propperly.

 

At least: The player- and chatdata is written to the sql db on every roundend / new mapload. So you will have to play on the map, get some points and wait until it loads the next map. Then you can check if your db got new entries.

 

The php-script for displaying stats on a website is attached some posts before and looks like: http://cabanossi.de.vu/proconstats/simple_view_eng

 

My improvement suggestions:

 

Can you involve to count the Rounds played per player?

Is there a way to display the top10 periodicaly in chat or as yell, without giving the command each time?

[ImportBot]

Originally Posted by Repoman1*:

 

i had this working for his older verion, so i am not sure why it won't now.

 

PRoCon is running on IP 69.147.242.19

Game server IP is 74.220.215.90 and I have the set on hostmonster for Remote Mysql

Also have 69.147.242.19 for Remote Mysql

[ImportBot]

Originally Posted by XpKiller*:

 

I get this msg when i run the plugin and join the server.

 

Error in SQLQuery: System.Security.SecurityException: Request for the permission of type 'System.Data.Odbc.OdbcPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

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

at System.Security.PermissionSet.Demand()

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

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

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

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

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

at PRoConEvents.CChatGUIDStatsLogger.SQLquery(String str_selectSQL, Int32 sort)

The action that failed was:

Demand

The type of the first permission that failed was:

System.Data.Odbc.OdbcPermission

The Zone of the assembly that failed was:

MyComputer

Hi,

For me this looks like a permission problem please check your password and username and check that the mysql user has the required permissions on your database.

I will take a closer look at this when I come home from work.

I didn't change much in this part of the program.

[ImportBot]

Originally Posted by HelloKitty*:

 

@ Repoman:

 

In the picture that you attached, you inserted the ip of the gameserver in the "host" field in "Server details" in "plugin settings". Thats definatly wrong! in this field you put the ip of the sqldatabase.

 

PRoCon is running on IP 69.147.242.19

Game server IP is 74.220.215.90 and I have the set on hostmonster for Remote Mysql

Also have 69.147.242.19 for Remote Mysql

...means that your sql database is on the same machine as the procon !?

If I am right, you only have to enter "localhost" or "127.0.0.1" to the "host" field in "Server details" in "plugin settings", where you have now "74.220.215.90".

[ImportBot]

Originally Posted by Repoman1*:

 

Only type of DB connection even with error is with ths set up. Thanks Phogue, I fixed it and uploaded the pic again.

[ImportBot]

Originally Posted by FoxTech*:

 

Procon just updated a few minutes ago and got this error message under the Plugins tab....

 

Error: System.InvalidOperationException: Collection was modified; enumeration operation may not execute.

at System.ThrowHelper.ThrowInvalidOperationException( ExceptionResource resource)

at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()

[ImportBot]

Originally Posted by LAB-HeliMagnet*:

 

I just want to say ....

Damn, that is a lot of plugins going on at once!

[ImportBot]

Originally Posted by Repoman1*:

 

Anyone get this working, I am still getting an error trying to conect to my DB.

[ImportBot]

Originally Posted by Zaeed*:

 

Anyone get this working, I am still getting an error trying to conect to my DB.

Easiest way to check if your db details are correct is to go to Control Panel -> Administrative Tools -> Data Sources (ODBC)

 

Click Add -> Select the MySQL ODBC 5.1 Driver -> Click Finish

 

Enter the details you have, and click Test.. If it says Connection Successful then your details are correct..

If the driver isn't there you need to download it (linky)

The other possible error would be that you need to assign the IP Address you will be accessing you database from to the Remote MySQL Access list.

The final reason it might not work is that the host of your database does not allow remote access.

[ImportBot]

Originally Posted by XpKiller*:

 

You problem is not plugin related you got a permission problem probably your db user is not set up correctly or some settings in ProCon are wrong

 

If your connection settings are correct than your db user doesnt have all privileges he needed.

[ImportBot]

Originally Posted by Repoman1*:

 

It was working fine for the older plugin.

[ImportBot]

Originally Posted by XpKiller*:

 

But I didn't changed anything on the way it connects to database

[ImportBot]

Originally Posted by lann*:

 

Anyone get this working, I am still getting an error trying to conect to my DB.

for testing purposes it was pretty easy. make sure to install MySQL ODBC 5.1 Driver on the same box you have procon. I went to http://www.freesqldatabase.com/ and created a free database. Put in the database details in the plugin and log into the game server. change map and it creates data. Done

[ImportBot]

Originally Posted by lann*:

 

BTW is there any way to not log the server spam as chat. Or could we get that option on a release?

[ImportBot]

Originally Posted by XpKiller*:

 

i will be in next version

[ImportBot]

Originally Posted by XpKiller*:

 

*Bump*

 

New Version out [1.4]

 

new features added

Some reported bug should be fixed.

 

Know issues Score is not 100% accurate due the event OnOverRoundPlayer does not work correctly

 

If you find a bug pls report.