Jump to content

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


ImportBot

Recommended Posts

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-)

* Restored post. It could be that the author is no longer active.
Link to comment
  • Replies 837
  • Created
  • Last Reply

Top Posters In This Topic

  • ImportBot

    838

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 ? :_:

* Restored post. It could be that the author is no longer active.
Link to comment

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

* Restored post. It could be that the author is no longer active.
Link to comment

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.

* Restored post. It could be that the author is no longer active.
Link to comment

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. :lol:

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

* Restored post. It could be that the author is no longer active.
Link to comment

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
* Restored post. It could be that the author is no longer active.
Link to comment

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

* Restored post. It could be that the author is no longer active.
Link to comment

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?

* Restored post. It could be that the author is no longer active.
Link to comment

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

* Restored post. It could be that the author is no longer active.
Link to comment

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.

* Restored post. It could be that the author is no longer active.
Link to comment

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".

* Restored post. It could be that the author is no longer active.
Link to comment

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()

* Restored post. It could be that the author is no longer active.
Link to comment

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.

* Restored post. It could be that the author is no longer active.
Link to comment

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.

* Restored post. It could be that the author is no longer active.
Link to comment

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
* Restored post. It could be that the author is no longer active.
Link to comment

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 :sad:

 

If you find a bug pls report.

* Restored post. It could be that the author is no longer active.
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.




×
×
  • Create New...

Important Information

Please review our Terms of Use and Privacy Policy. We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.