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

[ImportBot]

Originally Posted by XpKiller*:

 

This plugin will not work in anyway without a MySql database.

Without heavy modifications to the plugin your request is not possible.

The main use of the database is to store the results received from bfbcs to reduce the requests to them.

[ImportBot]

Originally Posted by kinleyb*:

 

Hey guys i am new to this tool and have no problems with it expect for this plugin! I have tried everything! But i Continue to get this error message when enabling the plugin:

[18:04:06 44] Error in OpenConnection:

[18:04:06 48] Index #0

[18:04:06 48] Message: [MySQL][ODBC 5.1 Driver]Unknown database 'local mysql'

[18:04:06 48] Native: 1049

[18:04:06 49] Source:

[18:04:06 49] SQL: HY000

[18:04:06 49] Index #1

[18:04:06 49] Message: [MySQL][ODBC 5.1 Driver]Unknown database 'local mysql'

[18:04:06 50] Native: 1049

[18:04:06 50] Source:

[18:04:06 50] SQL: HY000

[18:04:06 52] Error in GetRank: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

at PRoConEvents.CChatGUIDStatsLogger.GetRank(String SoldierName)

[18:04:06 56] Error in OpenConnection:

[18:04:06 56] Index #0

[18:04:06 57] Message: [MySQL][ODBC 5.1 Driver]Unknown database 'local mysql'

[18:04:06 57] Native: 1049

[18:04:06 57] Source:

[18:04:06 57] SQL: HY000

[18:04:06 58] Index #1

[18:04:06 58] Message: [MySQL][ODBC 5.1 Driver]Unknown database 'local mysql'

[18:04:06 58] Native: 1049

[18:04:06 58] Source:

[18:04:06 59] SQL: HY000

 

I have the drivers and a SQL server installed and i dont know what to do! Can anyone help me!

[ImportBot]

Originally Posted by XpKiller*:

 

Your database name doesn't exists and be aware of spaces in the database name. Use a ? instead of a space.

So make sure that the target db is there.

[ImportBot]

Originally Posted by leibhold*:

 

www.phogue.net/forumvb...Configuration.*Read that yet - might help

[ImportBot]

Originally Posted by Zaeed*:

 

I've found that if the plugin can't connect to the db server, after a while it will crash procon.. Perhaps after 5 failed connections disable the plugin.

[ImportBot]

Originally Posted by maester*:

 

I created the tables originally separate tables vietnam & then bc2

 

Is there someway to merge the stats?

 

So I have

 

tbl_bfbcs

tbl_chatlog

tbl_dogtags

tbl_dogtags_bfv

tbl_general

tbl_mapstats

tbl_mapstats_bfv

tbl_playerdata

tbl_playerstats

tbl_playerstats

tbl_stars

tbl_weaponstats

tbl_weaponstats_bfv

[ImportBot]

Originally Posted by Trizik*:

 

I've found that if the plugin can't connect to the db server, after a while it will crash procon.. Perhaps after 5 failed connections disable the plugin.

ah, that must be why my layer crashes so randomly. i haven't been able to pinpoint anything but i was suspicious about this.

[ImportBot]

Originally Posted by noobsrus*:

 

great plugin mate we got 4 bc2 servers the plugins working great its just we getting the error that they cant connect to bfbc2 stats website

Any ideas ?

[ImportBot]

Originally Posted by Trizik*:

 

if you're talking about the global bfbc2 stats from bfbcs.com it's just because their servers are often overloaded. nothing you can do about that unless you disable global stats support.

[ImportBot]

Originally Posted by Lokalen*:

 

Great plug-in! Worth a huge donation.

 

One question. I want to have stats for last yesterday, last week-end, this week, this month etc. Is this possible with this plug-in without making it too slow or writing db-scripts that aggregate stuff certain intervals?

 

Do you get my question?

[ImportBot]

Originally Posted by RedOne1*:

 

Server gone to another hosting

 

This is my error

 

[21:56:43 66] Start tablebuilder

[21:56:43 67] Error in OpenConnection:

[21:56:43 67] Index #0

[21:56:43 67] Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

[21:56:43 67] Native: 0

[21:56:43 67] Source:

[21:56:43 67] SQL: IM002

 

Please help :S

 

GrTz Red

[ImportBot]

Originally Posted by MorpheusX(AUT)*:

 

You have not installed the ODBC-connector correctly.

Please check this (www.phogue.net/forumvb/showth...-Configuration*.) thread.

[ImportBot]

Originally Posted by XpKiller*:

 

Atm I don't have much time to work on plugin because of private things until 11 may . Then I have time again to improve the plugin.

[ImportBot]

Originally Posted by RedOne1*:

 

No problem, you did already a lot. It worked fine by me till we moved our server to another datacentre. :smile:So have to check everything.

 

GrTz Red

 

Problem solved! Thx to the link from Morpheus, thank you:smile:

 

@Xpkiller. About problem on page 69. I quess its solved. The error not showed anymore thanks

 

@Honk Also page 69 When i ready with making 1 databes out of 5 i will use the latest version of P&s Thanks to you too

[ImportBot]

Originally Posted by RedOne1*:

 

Maybe its in a post earlier but 71 pages of posts searching isnt a small thing:smile:. But a member of our clan isnt found on the stats. I searched for another name of the user by (ea)guides and ip adress in the database because maybe there are problems with copy guides/ipadresses but cant find any duplicates.

 

Is there a kwown bug?

 

Players types ingame !rank and gets something like "There are no stats avaible yet, play a round first"

 

GrTz Red

[ImportBot]

Originally Posted by MorpheusX(AUT)*:

 

I get that problem often in the last days/weeks, many players seem not to be logged correctly. Have already reported that to XpKiller, and I think he is currently looking at it.

[ImportBot]

Originally Posted by Flyswamper*:

 

Perhaps it would make a little sense for this plugin to have its own subforum? Something for the forum admins to ponder if you haven't already.... Would allow separation of problem reports, suggestions, etc.... related to this topic. I dunno, maybe the time for this has come and gone, but I'll throw the thought out there and see if anybody catches it.

[ImportBot]

Originally Posted by leibhold*:

 

Suggestion re this - Think maybe this applies to all the plugins.

 

I think it needs to have a

 

Released plugins forum -

where the plugin authors can edit write up - no other users can post.

 

Released plugin discussion/bug report -

where users can bug the plugin writer...

 

A lot seems to be just plugin questions re setup RTM and RTFM etc

Just a thought....

[ImportBot]

Originally Posted by MorpheusX(AUT)*:

 

Well, but thats also more threads to handle for each person...

I dont really care, I could live with both "systems".

 

[ImportBot]

Originally Posted by chaoslion*:

 

Hey Guys

why am i gettings this error with freesql.org:

[18:54:45 91] Error in Startstreaming:

[18:54:45 91] Index #0

[18:54:45 91] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.0.16-standard-log]Got error -1 from storage engine

[18:54:45 91] Native: 1030

[18:54:45 91] Source: myodbc5.dll

[18:54:45 91] SQL: HY000

but he does upload the chat and mapstats but not the playerstats..

[ImportBot]

Originally Posted by XpKiller*:

 

Hi chaoslion

 

The error you got is related to the old sql version freesqldb is using. I could in detail what this mean. But short this means that your table is damaged. Innodb plugin in this version of mysql is not stable.

I recommend at least version 5.1 or better 5.5 of mysql.

 

The reason that chat and mapstats still working is that those table aren't innodb tables.

[ImportBot]

Originally Posted by Lokalen*:

 

Can I reliably concider points - kills x som_factor = "team effort points" suchs as caping a point, reviving, ammo dumping etc? What I am looking for is stats more directed towards team-work and non-camping play.

[ImportBot]

Originally Posted by XpKiller*:

 

@Lokalen

Points - kills x 50 such be a value which reflects the the teamwork of a player(you will still have kill, and kill assist bonus inside the points so they are not 100% reliable) unfortunately it is not possible to track such teamwork points because the server dont report them to procon.

[ImportBot]

Originally Posted by noobsrus*:

 

Does the cheatprotection work set it to the mAX kdr to 15 but a player went over that didint kick him ?

[ImportBot]

Originally Posted by Lokalen*:

 

Thanks XP killer, I will count "team effort" as points - (kills * 50). Better than nothing and really crap they only report kills/deaths and headshots etc. No focus on team-play is weird - to say the least.

[ImportBot]

Originally Posted by MorpheusX(AUT)*:

 

Does the cheatprotection work set it to the mAX kdr to 15 but a player went over that didint kick him ?

Not quite sure, but I think the cheatprotection referrs to the "global" KDR (from bfbcs.com)

[ImportBot]

Originally Posted by XpKiller*:

 

Not quite sure, but I think the cheatprotection referrs to the "global" KDR (from bfbcs.com)

Exactly! It's the global kdr

[ImportBot]

Originally Posted by noobsrus*:

 

This is my error

 

[21:56:43 66] Start tablebuilder

[21:56:43 67] Error in OpenConnection:

[21:56:43 67] Index #0

[21:56:43 67] Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

[21:56:43 67] Native: 0

[21:56:43 67] Source:

[21:56:43 67] SQL: IM002

 

very strange the plugin has been working fine then tonight this error then it crashes procon console

 

database screwed ?

[ImportBot]

Originally Posted by MorpheusX(AUT)*:

 

Your ODBC-connector seems not to work anymore.

Double-check that you have set that up correctly.

[ImportBot]

Originally Posted by noobsrus*:

 

how can i check to fix this ?