Chat, GUID, Stats and Mapstats Logger [1.0.0.3]

[ImportBot]

Originally Posted by Prophet731*:

 

Can I drop all tables but keep the adkats intact or should I start over ?

AdKats references the tbl_playerdata table and the tbl_servers table. Once you drop or empty those tables then records, bans, etc.. that use that information will be deleted.

[ImportBot]

Originally Posted by Prophet731*:

 

Maybe but the server kills is wrong so it seems that there must besom conflict between adkats and this plugin

The stats logger isn't fully compatible for hardline. It doesn't parse the stats correctly so hardline stats won't be accurate. However it will still add players and a few other things just fine.

[ImportBot]

Originally Posted by Talzac*:

 

The stats logger isn't fully compatible for hardline. It doesn't parse the stats correctly so hardline stats won't be accurate. However it will still add players and a few other things just fine.

ok thanks, then there are no reason to reinstall, just have to wait for an upgrade.

[ImportBot]

Originally Posted by Kendis*:

 

Hi!

 

I got the plugin working but I do get some errors/trace:

[14:51:00 75] [statslogger]Trace: Weapon: U_SG533LB is missing in the BFHL.def file!!!

[14:51:04 49] [statslogger]Trace: Weapon: U_P90 is missing in the BFHL.def file!!!

And many more like that one, but it's only for the weapons.

 

How can I possibly fix this? My BFHL.def file is packed with the information about the weapons and I also added the keyword list from a few pages back in this topic.

 

Best Regards

Hi!

 

I don't want to hound anyone, but has anyone figured anything out above the problem I have? (I quoted my last post).

The BFHL.def file is packed with weapons and also as stated the keyword list is edited.

[ImportBot]

Originally Posted by TimSad*:

 

Hi!

 

I don't want to hound anyone, but has anyone figured anything out above the problem I have? (I quoted my last post).

The BFHL.def file is packed with weapons and also as stated the keyword list is edited.

The keyword list is just for player friendliness when they go to type in something like "!stats jury". They player has no idea that the weapon is actually stored and retrieved as U_Jury410 so that keyword list acts as the middleman.

 

As far as weapons not being tracked, are you sure all the weapons are in your BFHL.def file? Double check with the ones you are seeing that aren't having their kills being recorded and such.

[ImportBot]

Originally Posted by Kendis*:

 

The keyword list is just for player friendliness when they go to type in something like "!stats jury". They player has no idea that the weapon is actually stored and retrieved as U_Jury410 so that keyword list acts as the middleman.

 

As far as weapons not being tracked, are you sure all the weapons are in your BFHL.def file? Double check with the ones you are seeing that aren't having their kills being recorded and such.

Hi thanks for the answer!

Ok then I understand how the keywords work :3

 

And for example P90 in the BFHL.def file is :tongue:rocon.protected.weapons.add Demolition "U_P90" Primary SMG

 

I hope these are the correct lines in the file

But the Addon still says it's missing..

 

Best Regards!

[ImportBot]

Originally Posted by ShinkonNakami*:

 

Hi Just installed the plugin

 

when i enable the plug in get this

 

[22:57:24 93] [statslogger]Info: Start tablebuilder

[22:57:24 94] [statslogger]Warning: PrepareKeywordDic: Mainkey RPG-7 not found!

[22:57:24 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/SCAR-H/SCAR-H not found!

[22:57:24 94] [statslogger]Warning: PrepareKeywordDic: Mainkey USAS-12 not found!

[22:57:24 94] [statslogger]Warning: PrepareKeywordDic: Mainkey M27IAR not found!

[22:57:24 94] [statslogger]Warning: PrepareKeywordDic: Mainkey M16A4 not found!

[22:57:24 94] [statslogger]Warning: PrepareKeywordDic: Mainkey AEK-971 not found!

[22:57:24 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/A91/A91 not found!

[22:57:24 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/AK74M/AK74 not found!

[22:57:24 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/G36C/G36C not found!

[22:57:24 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/G3A3/G3A3 not found!

[22:57:24 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/Gadgets/C4/C4 not found!

[22:57:24 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/Gadgets/Claymore/Claymore not found!

[22:57:24 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/KH2002/KH2002 not found!

[22:57:24 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/Knife/Knife not found!

[22:57:24 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/M416/M416 not found!

[22:57:24 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/MagpulPDR/MagpulPDR not found!

[22:57:24 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/MP412Rex/MP412REX not found!

[22:57:24 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/MP443/MP443 not found!

[22:57:24 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Taurus .44 not found!

[22:57:24 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/P90/P90 not found!

[22:57:24 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/Sa18IGLA/Sa18IGLA not found!

[22:57:24 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/UMP45/UMP45 not found!

[22:57:24 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/XP1_L85A2/L85A2 not found!

[22:57:24 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Glock18 not found!

[22:57:37 37] [statslogger]Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Reading from the stream has failed. ---> System.IO.EndOfStreamException: Attempted to read past the end of the stream.

at MySql.Data.MySqlClient.MySqlStream.ReadFully(Strea m stream, Byte[] buffer, Int32 offset, Int32 count)

at MySql.Data.MySqlClient.MySqlStream.LoadPacket()

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

at MySql.Data.MySqlClient.MySqlStream.LoadPacket()

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

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)

[22:57:40 38] Error in Tablebuilder:

[22:57:40 38] Message: Reading from the stream has failed.

[22:57:40 38] Native: -2147467259

[22:57:40 38] Source: MySql.Data

[22:57:40 38] StackTrace: at MySql.Data.MySqlClient.MySqlStream.LoadPacket()

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

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

[22:57:40 38] InnerException: System.IO.EndOfStreamException: Attempted to read past the end of the stream.

at MySql.Data.MySqlClient.MySqlStream.ReadFully(Strea m stream, Byte[] buffer, Int32 offset, Int32 count)

at MySql.Data.MySqlClient.MySqlStream.LoadPacket()

[22:57:40 38] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[22:57:55 82] [statslogger]Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Reading from the stream has failed. ---> System.IO.EndOfStreamException: Attempted to read past the end of the stream.

at MySql.Data.MySqlClient.MySqlStream.ReadFully(Strea m stream, Byte[] buffer, Int32 offset, Int32 count)

at MySql.Data.MySqlClient.MySqlStream.LoadPacket()

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

at MySql.Data.MySqlClient.MySqlStream.LoadPacket()

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

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 Kendis*:

 

The keyword list is just for player friendliness when they go to type in something like "!stats jury". They player has no idea that the weapon is actually stored and retrieved as U_Jury410 so that keyword list acts as the middleman.

 

As far as weapons not being tracked, are you sure all the weapons are in your BFHL.def file? Double check with the ones you are seeing that aren't having their kills being recorded and such.

Hi thanks for the answer!

Ok then I understand how the keywords work :3

 

And for example P90 in the BFHL.def file is :tongue:rocon.protected.weapons.add Demolition "U_P90" Primary SMG

 

I hope these are the correct lines in the file

But the Addon still says it's missing..

 

Best Regards!

I was just wondering if there might be an update to this problem? Do you think this will fix itself with time or must something be done? From what I can guess, the plugin is not reading the BFHL.def file correctly; or am I way off now?

 

I don't understand the coding at all and I'm very pleased with what you've developed but if you have any thoughts in regards to the problem then I would greatly appreciate it!

[ImportBot]

Originally Posted by Phractal*:

 

Hello all,

 

I think my Database might have been corrupted but I'm not sure. Playerdata is completely weird. Check here

If I have to completely purge my DB (I'm running AdKats too) how would I do that, so that AdKats with all Triggers and procedures is gone and I can start fresh?

 

Thanks in advance!

[ImportBot]

Originally Posted by ty_ger07*:

 

Hello all,

Playerdata is completely weird. Check here

It's no problem.

 

Either wait a few hours for it to fix itself, or empty the `tyger_stats_top_twenty_cache` table in your database.

 

Cache Used:

Top Twenty

The thing you are seeing is just the cached players on the first page. Apparently, when you first viewed that page, there were only 2 players in the database. Now, you have to wait for the next cache update to find the other 18 players on the first page, or empty the `tyger_stats_top_twenty_cache` table.

 

Page 2 and on works fine.

http://stats.kamelfarm.net/index.php...e&o=DESC&sid=1

[ImportBot]

Originally Posted by Phractal*:

 

Thanks a lot for taking a Look! Greatly appreciated!

[ImportBot]

Originally Posted by Kendis*:

 

So in regards to my previous posts, in ProCon it says this:

 

[12:23:29 45] [statslogger]Trace: WeaponMapping: ID: 1 Weapon:biggrin:amageArea

[12:23:29 45] [statslogger]Trace: WeaponMapping: ID: 5 Weapon:biggrin:eath

[12:23:29 45] [statslogger]Trace: WeaponMapping: ID: 7 Weapon:Melee

[12:23:29 45] [statslogger]Trace: WeaponMapping: ID: 6 Weapon:RoadKill

[12:23:29 45] [statslogger]Trace: WeaponMapping: ID: 2 Weapon:SoldierCollision

[12:23:29 45] [statslogger]Trace: WeaponMapping: ID: 3 Weapon:Suicide

[12:23:29 45] [statslogger]Trace: WeaponMapping: ID: 4 Weapon:VehicleUpsideDown

 

And I can tell from the database that these entries exist. So how come it imports the above "weapons" and not the others, mainly the ones starting with "U_xxxxx"?

 

Any thoughts?

 

Best Regards

[ImportBot]

Originally Posted by ShadzeB*:

 

Guys can you tell me what I need to do with this:

 

My hoster has added my Procon Layer IP through the firewall and I have the remote access to the SQL Datavases but

it just wont work it's throwing these messages at me:

 

[12:16:14 56] Error in Tablebuilder:

[12:16:14 56] Message: Unable to connect to any of the specified MySQL hosts.

[12:16:14 56] Native: -2147467259

[12:16:14 58] Source: MySql.Data

[12:16:14 58] StackTrace: 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.tablebuilder()

[12:16:14 58] InnerException: System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 74.118.68.239:3306

at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult)

at MySql.Data.Common.StreamCreator.CreateSocketStream (IPAddress ip, Boolean unix)

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

[12:16:14 58] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[12:16:23 33] PRoCon Chat, GUID and Stats Logger Disabled

[12:16:38 76] Error in Tablebuilder:

[12:16:38 76] Message: Unable to connect to any of the specified MySQL hosts.

[12:16:38 76] Native: -2147467259

[12:16:38 76] Source: MySql.Data

[12:16:38 76] StackTrace: 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.tablebuilder()

[12:16:38 76] InnerException: System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 74.118.68.239:3306

at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult)

at MySql.Data.Common.StreamCreator.CreateSocketStream (IPAddress ip, Boolean unix)

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

[12:16:38 76] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[ImportBot]

Originally Posted by ty_ger07*:

 

You have plugin sandbox disabled on the procon layer side? You have the database address added as a trusted host on the procon layer side?

 

Not only does the database have to trust procon, procon needs to be configured to trust the database. And, procon's plugin sandbox needs to be disabled.

[ImportBot]

Originally Posted by Cablekiller*:

 

Hey guys, so im the First Admin of a good known BFBC2 (old game, I know) Clan. We have had 1 Server over the years which was always full (day and night) and it ran really well with the Plugins, but since a half year we have some Lag issue with the hoster and we hostet a 2nd Server, we got a database for free with it and with the help of Hand of Shadow we made this Plugin run there. But we use the 3... version because if i upload the 1...version it just doesnt appear in the Plugin list...why is that like that? Can someone help me?

 

And my second question is, both servers are always good visitet so we want to change the lag server to that provider too, so we would have 2 Servers with ranking systems, but we want to have all players the same score on both servers, i saw there is a "suffix table" but i dont know what i can do with is or what to write in if we have the 2nd server.

 

 

I´ve posted this in the older Thread of the Forum: myrcon.net/.../chat-guid-stats-and-mapstats-logger

but noone replys there so i try my luck out here, because i see nice helping guys like ty_ger07 are more active here =)

 

Thanks everyone for the answeres, i dont want to get on HandoFShadows nerves even longer =)

[ImportBot]

Originally Posted by ShadzeB*:

 

You have plugin sandbox disabled on the procon layer side? You have the database address added as a trusted host on the procon layer side?

 

Not only does the database have to trust procon, procon needs to be configured to trust the database. And, procon's plugin sandbox needs to be disabled.

I have the Procon address added onto my web-server to allow connection do I need to send me web-servers address to gameservers.com to get them to allow Procon to trust this address. Sandbox is disabled mate yes so plugins have full control.

[ImportBot]

Originally Posted by ty_ger07*:

 

I have the Procon address added onto my web-server to allow connection do I need to send me web-servers address to gameservers.com to get them to allow Procon to trust this address. Sandbox is disabled mate yes so plugins have full control.

No, I mean in Procon, you need to add your database's address as a trusted connection. Procon won't connect to the database until you tell procon that you trust the database's address.

 

Procon -> Tools -> Options... -> Plugins (tab)

1) Plugin Security: Run plugins with no restrictions (you already did this_)

2) Outgoing Connections: Add trusted Host/Domain and Port (add the address of your database/webserver)

 

 

If you are using a Procon Layer server, this needs to be done on your procon layer server (not the local Procon application on your computer). If you are using a Procon layer server, doing the above changes on your local procon application will make no difference. If you need help doing this on your procon layer server, ask your layer server provider.

[ImportBot]

Originally Posted by ShadzeB*:

 

No, I mean in Procon, you need to add your database's address as a trusted connection. Procon won't connect to the database until you tell procon that you trust the database's address.

 

Procon -> Tools -> Options... -> Plugins (tab)

1) Plugin Security: Run plugins with no restrictions (you already did this_)

2) Outgoing Connections: Add trusted Host/Domain and Port (add the address of your database/webserver)

 

 

If you are using a Procon Layer server, this needs to be done on your procon layer server (not the local Procon application on your computer). If you are using a Procon layer server, doing the above changes on your local procon application will make no difference. If you need help doing this on your procon layer server, ask your layer server provider.

Thanks for the help mate I have sent the gameserver provider a message and asked them to add this in for me.

at the minute I am getting the error:

 

[20:17:27 99] Error in Tablebuilder:

[20:17:27 99] Message: Authentication method 'mysql_old_password' not supported by any of the available plugins.

[20:17:27 99] Native: -2147467259

[20:17:27 99] Source: MySql.Data

[20:17:27 99] StackTrace: at MySql.Data.MySqlClient.Authentication.Authenticati onPluginManager.GetPlugin(String method)

at MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.GetPlugin(String method, NativeDriver driver, Byte[] authData)

at MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.HandleAuthChange(MySqlPacket packet)

at MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.Authenticate(Boolean reset)

at MySql.Data.MySqlClient.NativeDriver.Authenticate(S tring authMethod, Boolean reset)

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

 

Is this because of the IP not being trusted Procon layer side?

[ImportBot]

Originally Posted by ty_ger07*:

 

Error message says:

Message: Authentication method 'mysql_old_password' not supported

You need to tell your database host that you need your database password re-encrypted using the "new -style" password encryption method.

Old style password encryption has been disabled due to security concerns.

 

I have sent the gameserver provider a message and asked them to add this in for me.

It's not a game server issue. It's a layer server issue. Your procon layer server needs that setting changed. Even if your game server provider is the same company who provides your layer server, you need to remember that the layer server is running on a different computer than your game server and you need to contact the right people for help.

[ImportBot]

Originally Posted by ShadzeB*:

 

Error message says:

 

 

You need to tell your database host that you need your database password re-encrypted using the "new -style" password encryption method.

Old style password encryption has been disabled due to security concerns.

 

 

 

It's not a game server issue. It's a layer server issue. Your procon layer server needs that setting changed. Even if your game server provider is the same company who provides your layer server, you need to remember that the layer server is running on a different computer than your game server and you need to contact the right people for help.

I will send my web-server company an ticket to sort that out now.

 

With regards to my Procon layer it's hosted by the same people that host my BF4 server Gameservers.com

[ImportBot]

Originally Posted by ty_ger07*:

 

I will send my web-server company an ticket to sort that out now.

 

With regards to my Procon layer it's hosted by the same people that host my BF4 server Gameservers.com

I understand that it is the same company. But please don't confuse the names. The game server is on a different computer than the layer server. You need to make sure that you contact the people who control the layer servers. If you just tell them that you need help with your "game server", they will have no idea what you are talking about and won't be able to help you.

[ImportBot]

Originally Posted by ShadzeB*:

 

I understand that it is the same company. But please don't confuse the names. The game server is on a different computer than the layer server. You need to make sure that you contact the people who control the layer servers. If you just tell them that you need help with your "game server", they will have no idea what you are talking about and won't be able to help you.

All sorted now and working like a dream thanks for the help mate.

[ImportBot]

Originally Posted by fanboyzgames*:

 

hi, im admin from fanboyzgames.com server and we are making a championship and i want to know if its possible to extract de statistics by an peridod.. we want to use this plugin in the championship but we have installed this plugin a long time ago so i need to extract the statiscts only for the championship time window.

thanks!

[ImportBot]

Originally Posted by ty_ger07*:

 

The only stats you can get within a date/time range are session stats which are basically kills, deaths, and score. No weapon stats or dog tag stats. Also, session stats are usually buggy and way wrong (score is easily double the actual score).

 

The easiest method to save stats from a specific range is to rent a new layer server and have a second version of the plugin running on the second layer server which is saving to a different database.

[ImportBot]

Originally Posted by ShadzeB*:

 

Can you tell me what this feature on the plugin does please.

 

"Enable Chatlog filter (regex)"

 

If you could let me know I would appreciate it.

[ImportBot]

Originally Posted by ty_ger07*:

 

Can you tell me what this feature on the plugin does please.

 

"Enable Chatlog filter (regex)"

 

If you could let me know I would appreciate it.

See post #3

myrcon.net/...chat-guid-stats-and-mapstats-logger#entry44800

 

It makes chat messages which match the filter not get stored in the database.

[ImportBot]

Originally Posted by ShadzeB*:

 

See post #3

myrcon.net/...chat-guid-stats-and-mapstats-logger#entry44800

 

It makes chat messages which match the filter not get stored in the database.

Awesome, so basically for my server messages all I do is add them to the list and put ID_CHAT_.* before them

and they will not show in the chat log. Good stuff man thanks.

[ImportBot]

Originally Posted by Cablekiller*:

 

Any tipps for my Problems too? =(

[ImportBot]

Originally Posted by madem*:

 

Website development :Old Thread(the most queries still should work):

myrcon.net/.../advanced-in-game-admin-and-ban-enforcer-adkats

 

Show all Weapons known by the plugin:

Code:

SELECT `tbl_games`.`Name`, tbl_weapons.* FROM tbl_weapons
INNER JOIN tbl_games using (`GameID`);

Show Weaponstats for a single Player for one Server:

Code:

SELECT 
`tbl_playerdata`.`SoldierName`,
`tbl_weapons`.`Fullname`,
`tbl_weapons`.`Damagetype`,
`tbl_weapons_stats`.`Kills`,
`tbl_weapons_stats`.`Headshots`,
`tbl_weapons_stats`.`Deaths`
FROM `tbl_playerdata`
INNER JOIN `tbl_server_player` ON `tbl_playerdata`.`PlayerID` = `tbl_server_player`.`PlayerID`
INNER JOIN `tbl_weapons_stats` ON `tbl_server_player`.`StatsID` = `tbl_weapons_stats`.`StatsID`
INNER JOIN `tbl_weapons` ON `tbl_weapons_stats`.`WeaponID` = `tbl_weapons`.`WeaponID`
WHERE 
`tbl_playerdata`.`SoldierName` ="XpKiller" AND `tbl_server_player`.`ServerID` = 1

Where can I download Database? also

I'm going where the database information??

[ImportBot]

Originally Posted by ShadzeB*:

 

This chatfilter dont work at all.

 

I have put ID_CHAT_.* in the box on its own and it then still shows my server messages in the server which is

what I want but then it still puts them on the chat logging on the site.

 

If I put the ID_CHAT_.* in front of the messages and put those in the filter list it doesn't show on the server.

 

So can you tell me what I need to do so that the messages show in the server but NOT in the chat log please.