Chat, GUID, Stats and Mapstats Logger [1.0.0.3]

[ImportBot]

Originally Posted by ty_ger07*:

 

ah, do you have more than 1 game in your database ?

 

i was looking at my BF3(only) database, that's probably the reason for my low weaponid count.

 

just looked in my bf4(only) database,it has 307 weaponids.

245 = MK11

206 = ASVAL

The number of weapons and their weapon ID in the database will be different for everyone depending on which DLC the server runs, which weapons the players in the server use, and the order in which players use weapons. There is no reason to argue about which is the proper weapon ID or how many total weapons there are. Kinsman wants to know why the weapon stats for the AS Val are missing in his case.

[ImportBot]

Originally Posted by OddJob001*:

 

Having a small issue.

Everything is set up, but it appears it won't announce the "say" on player join (welcomestat). Debug shows this:

 

JuX3M8t.png

 

Edit: The problem seems to be it waits for them to spawn before sending the message to chat. Trying to edit code to do it OnJoin + 1min wait. Anyone have an idea?

[ImportBot]

Originally Posted by subzero*:

 

Hi can anyone help me i keep on getting this error i've tried working with hypernia tech support but we still come up with the error can anyone help ?

 

16:55:21 38] [statslogger]Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts. ---> System.Exception: Call to GetHostEntry failed after 00:00:00 while querying for hostname '198.23.167.34

[ImportBot]

Originally Posted by HARDCOREBF*:

 

How to disable ADMIN SAY to all server when player reported..

 

So when player used !report name reason . server anouncing to all that {player} was reported . We would like to hide that

[ImportBot]

Originally Posted by ty_ger07*:

 

How to disable ADMIN SAY to all server when player reported..

 

So when player used !report name reason . server anouncing to all that {player} was reported . We would like to hide that

I think you might have posted in the wrong thread.

[ImportBot]

Originally Posted by xr650rhonda*:

 

My tbl_mapstats table is empty and I think I have everything enabled, is that normal? I am looking for a way to collect information on the vote maps results and don't know how to go about it.

 

map.PNG

[ImportBot]

Originally Posted by ty_ger07*:

 

My tbl_mapstats table is empty and I think I have everything enabled, is that normal? I am looking for a way to collect information on the vote maps results and don't know how to go about it.

 

map.PNG

If you said which game, that would help a lot.

[ImportBot]

Originally Posted by xr650rhonda*:

 

If you said which game, that would help a lot.

Lol, bf4

[ImportBot]

Originally Posted by ty_ger07*:

 

Lol, bf4

Is that funny? BF:BC2 has some support issues so the answer to your question would have been much different.

 

Newest version of Procon? Newest version of this plugin? Which maps? DLC? This Procon plugin running on your computer or on hosted layer? Plugin settings are what?

[ImportBot]

Originally Posted by xr650rhonda*:

 

Is that funny? BF:BC2 has some support issues so the answer to your question would have been much different.

 

Newest version of Procon? Newest version of this plugin? Which maps? DLC? This Procon plugin running on your computer or on hosted layer? Plugin settings are what?

My apologies, bad reaction to my embarrassment of lack of details;it's not funny at all. I will look into it a little deeper before posting back.

[ImportBot]

Originally Posted by tolgad*:

 

Hello,

I enable top 10 in game but don't showing in game.

If i work plugin on local,top 10 is working.

Can you help me ?

[ImportBot]

Originally Posted by ty_ger07*:

 

Hello,

I enable top 10 in game but don't showing in game.

If i work plugin on local,top 10 is working.

Can you help me ?

Where is the database? I would assume that when you are running the plugin on the layer, the database is either too slow or too far from the layer and the top10 query is timing out. Can you increase the error/debug level of the plugin and monitor for error messages on the layer when top10 is tried?

[ImportBot]

Originally Posted by B3g1nz*:

 

Can somebody help me? xD How can I import my old server database to a new server database via phpmyadmin?

[ImportBot]

Originally Posted by ty_ger07*:

 

Can somebody help me? xD How can I import my old server database to a new server database via phpmyadmin?

The old database has data in it obviously. But does the new database also have data in it? If so, right from the get-go, you might as well just give up the idea of merging the two databases together.

 

Use whichever database is more important to you. If the old database is what you want to use:

1) Log into phpMyAdmin in old database.

2) Click 'Export' on main page.

3) Top left of export page, select the database name. Select SQL radio button. Select 'Save as File' and hit 'Go' at bottom right.

4) Log into new database.

5) Drop all tables from new database so that it is completely empty.

6) Import on main page of new database.

7) Select the backup file you exported in step 3. Go.

 

 

Or do a search online. https://www.youtube.com/watch_v=NnOE0KWHGkY

[ImportBot]

Originally Posted by B3g1nz*:

 

The old database has data in it obviously. But does the new database also have data in it? If so, right from the get-go, you might as well just give up the idea of merging the two databases together.

 

Use whichever database is more important to you. If the old database is what you want to use:

1) Log into phpMyAdmin in old database.

2) Click 'Export' on main page.

3) Top left of export page, select the database name. Select SQL radio button. Select 'Save as File' and hit 'Go' at bottom right.

4) Log into new database.

5) Drop all tables from new database so that it is completely empty.

6) Import on main page of new database.

7) Select the backup file you exported in step 3. Go.

 

 

Or do a search online. https://www.youtube.com/watch_v=NnOE0KWHGkY

followed everything here. And encountered 2 errors.#1 is I dont have super privileges to do the task so I deleted the create definer line in the table

 

Attached Files:

• error1.png

[ImportBot]

Originally Posted by B3g1nz*:

 

Got the error #2 here

 

 

What should I do now_

 

Attached Files:

• error2.png

[ImportBot]

Originally Posted by Ruger*:

 

followed everything here. And encountered 2 errors.#1 is I dont have super privileges to do the task so I deleted the create definer line in the table

Find all instances of CREATE DEFINER='c1021641' and replace with CREATE DEFINER='c1021641_c3bubf4'. (That is if your database username is c1021641_c3bubf4.) Save then try importing again.

[ImportBot]

Originally Posted by B3g1nz*:

 

Find all instances of CREATE DEFINER='c1021641' and replace with CREATE DEFINER='c1021641_c3bubf4'. (That is if your database username is c1021641_c3bubf4.) Save then try importing again.

Ok I will try this an d let u know:biggrin:

[ImportBot]

Originally Posted by B3g1nz*:

 

Find all instances of CREATE DEFINER='c1021641' and replace with CREATE DEFINER='c1021641_c3bubf4'. (That is if your database username is c1021641_c3bubf4.) Save then try importing again.

It worked! Now its came to life again. Thank you for your help

[ImportBot]

Originally Posted by Ruger*:

 

Not a problem. I had the same issue a week ago til I noticed that.

 

 

Sent from my iPhone using Tapatalk

[ImportBot]

Originally Posted by ToM666*:

 

Hi guys

 

I am quite keem to use this and associated plugins.

 

I am getting stumped however by the MYSQL database aspect of it.

 

Our website has MYSQL databases available to me but the don't appear to allow remote connections.

 

My website host "Clanwebs" (

 

What I want to know is this:

 

1) If I rent a MYSQL database that does allow remote connections but will be on a different server to my website would it still work correctly?

 

2) Can I install the MYSQL database locally on my computer and it will still work?

 

My Procon is running on a layer.

 

Many Thanks

 

ToM

[ImportBot]

Originally Posted by LCARSx64*:

 

Hi guys

 

I am quite keem to use this and associated plugins.

 

I am getting stumped however by the MYSQL database aspect of it.

 

Our website has MYSQL databases available to me but the don't appear to allow remote connections.

 

My website host "Clanwebs" (

 

What I want to know is this:

 

1) If I rent a MYSQL database that does allow remote connections but will be on a different server to my website would it still work correctly?

 

2) Can I install the MYSQL database locally on my computer and it will still work?

 

My Procon is running on a layer.

 

Many Thanks

 

ToM

If you can set the MySQL Database host (which usually defaults to localhost) and port to the IP and port for your Database host then you should be fine.

[ImportBot]

Originally Posted by FLirtY-3D*:

 

correct me if i am wrong but is this the plugin for @rank and @stars ingame commands ?

if not can you show me the right way... thankyou in advance

[ImportBot]

Originally Posted by ty_ger07*:

 

Yes

[ImportBot]

Originally Posted by JB_Sniper*:

 

Hi, sorry for the incovenient, but i'm trying to set up the rank plugin but it's showing an error in procon client. The plugin is installed, the database is working fine, but the error persists. Can you help me with that? Seeing if i did something wrong.. My list is like this:

 

Host: Game Servers

 

Port: 3306

 

Database Name: (Database name)

 

Username: (My username)

 

Password: (My password)

 

Connection Pooling: On

 

Min Connection Pool Size: 0

 

Max Connection Pool Size: 10

 

Failed Transaction failed attemps: 3

 

Minimum time(sec) between ServerInfo Updates: 60

 

What is wrong with my configuration? Thanks

[ImportBot]

Originally Posted by Obl1ter*:

 

Constantly confronting with following problem: i've set up plugin to stat logging etc., turned off chat logging , set up server time zone. After a while chat logging somehow became turned on, and time zone is set to another. Reinstall plugin with old config removed didn't do any good. Did anybody met with such a problem ?

[ImportBot]

Originally Posted by ty_ger07*:

 

Hi, sorry for the incovenient, but i'm trying to set up the rank plugin but it's showing an error in procon client. The plugin is installed, the database is working fine, but the error persists. Can you help me with that? Seeing if i did something wrong.. My list is like this:

 

Host: Game Servers

 

Port: 3306

 

Database Name: (Database name)

 

Username: (My username)

 

Password: (My password)

 

Connection Pooling: On

 

Min Connection Pool Size: 0

 

Max Connection Pool Size: 10

 

Failed Transaction failed attemps: 3

 

Minimum time(sec) between ServerInfo Updates: 60

 

What is wrong with my configuration? Thanks

What is the error message?

[ImportBot]

Originally Posted by JB_Sniper*:

 

What is the error message?

this is the error message:

 

"Connection()

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

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[11:58:30 97] InnerException: System.Exception: Call to GetHostEntry failed after 00:00:00 while querying for hostname 'Game Servers': SocketErrorCode=NoData, ErrorCode=11004, NativeErrorCode=11004. ---> System.Net.Sockets.SocketException: The requested name is valid, but no data of the requested type was found

at System.Net.Dns.GetAddrInfo(String name)

at System.Net.Dns.InternalGetHostByName(String hostName, Boolean includeIPv6)

at System.Net.Dns.GetHostEntry(String hostNameOrAddress)

at MySql.Data.Common.StreamCreator.GetDnsHostEntry(St ring hostname)

--- End of inner exception stack trace ---

at MySql.Data.Common.StreamCreator.GetDnsHostEntry(St ring hostname)

at MySql.Data.Common.StreamCreator.GetHostEntry(Strin g hostname)

at MySql.Data.Common.StreamCreator.GetStreamFromHost( String pipeName, String hostName, UInt32 timeout)

at MySql.Data.Common.StreamCreator.GetStream(UInt32 timeout)

at MySql.Data.MySqlClient.NativeDriver.Open()

[11:58:30 97] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[11:58:33 22] [statslogger]Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts. ---> System.Exception: Call to GetHostEntry failed after 00:00:00 while querying for hostname 'Game Servers': SocketErrorCode=NoData, ErrorCode=11004, NativeErrorCode=11004. ---> System.Net.Sockets.SocketException: The requested name is valid, but no data of the requested type was found

at System.Net.Dns.GetAddrInfo(String name)

at System.Net.Dns.InternalGetHostByName(String hostName, Boolean includeIPv6)

at System.Net.Dns.GetHostEntry(String hostNameOrAddress)

at MySql.Data.Common.StreamCreator.GetDnsHostEntry(St ring hostname)

--- End of inner exception stack trace ---

at MySql.Data.Common.StreamCreator.GetDnsHostEntry(St ring hostname)

at MySql.Data.Common.StreamCreator.GetHostEntry(Strin g hostname)

at MySql.Data.Common.StreamCreator.GetStreamFromHost( String pipeName, String hostName, UInt32 timeout)

at MySql.Data.Common.StreamCreator.GetStream(UInt32 timeout)

at MySql.Data.MySqlClient.NativeDriver.Open()

--- End of inner exception stack trace ---

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

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

at PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo)"

[ImportBot]

Originally Posted by ty_ger07*:

 

'Game Servers' is not a valid host name. You have to enter the valid database location such as db.gamerservers.com/123456/ (whatevere the database address is).

[ImportBot]

Originally Posted by JB_Sniper*:

 

'Game Servers' is not a valid host name. You have to enter the valid database location such as db.gamerservers.com/123456/ (whatevere the database address is).

thanks for the answer friend! I changed it, it's right now and i guess it's conneted, show this message:

 

[12:34:38 04] [MULTIbalancer]:0 Enabled! Version = 1.0.9.0

[12:34:38 10] [MULTIbalancer]:1 WARNING: BattlelogCache is not supported for BF4 yet!

[12:34:38 15] [MULTIbalancer]:0 Thread(updater): !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!

[12:34:38 15] [MULTIbalancer]:0 Thread(updater):

[12:34:38 15] [MULTIbalancer]:0 Thread(updater): A NEW VERSION OF THIS PLUGIN IS AVAILABLE!

[12:34:38 15] [MULTIbalancer]:0 Thread(updater):

[12:34:38 15] [MULTIbalancer]:0 Thread(updater): PLEASE UPDATE TO VERSION: 1.1.2.0

[12:34:38 15] [MULTIbalancer]:0 Thread(updater):

[12:34:38 15] [MULTIbalancer]:0 Thread(updater): !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!

 

 

is it enable? Because it still not working in-game. Do i have to wait? thanks for the help man