Chat, GUID, Stats and Mapstats Logger[1.1.0.1][BF3]

[ImportBot]

Originally Posted by sp37zn4z*:

 

XPkiller,

 

I tried !top10 KNIFE command all i'm getting as a reply is "Top 10 Killers in KNIFE" with no listings of players. Same as with !stats KNIFE i'm getting a reply of "nostats available on this weapon". Tried renaming the Keyword KNIFE into MELEE same results.

 

Upon checking the database values for knife and melee the stats are there 100% and it updates every round ends. Am i missing something? Or are this features even working on this current version?

 

So far, !stats welcomestats !top10 are working for me 2 days since i installed the plugin. Just this weapon stats isn't working right.

[ImportBot]

Originally Posted by eumel*:

 

Hi, i want to setup the Plugin for my Server. My Proconlayer runs at gamed.de. Db is configured and setup in the Plugin, but i get the error:

 

[11:34:58 58] Error in Tablebuilder:

[11:34:58 58] Index #0

[11:34:58 58] Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben

[11:34:58 58] Native: 0

[11:34:58 58] Source:

[11:34:58 58] SQL: IM002

 

I don't know where is the Problem. Could u help me?

 

eUmel

[ImportBot]

Originally Posted by C-4-N*:

 

Hi i think he need more information

Did your sql run on same server ?

Did ODBC Driver Manager is installed ?

innoDB or other ?

[ImportBot]

Originally Posted by Porthos*:

 

Am I missing something? I downloaded and unzipped and have the .cs file and two .txt files. Shouldn't there be an sql file that initially creates the tables?

[ImportBot]

Originally Posted by eumel*:

 

Hi C-4_N, DB is running at freesql.org. I don't no if the Driver Manager is installed on the Server, because the Layer is renzed from my Gameserverhoster. Is this necessary? So i have to ask my hoster.

[ImportBot]

Originally Posted by XpKiller*:

 

@Waterboyeee

Sry i missed to anwers your post. Im honest i didnt tested this but make a backup and run TRUNCATE TABLE tbl_server_player

This should delete all entry related to the statsid in all the other tables and dont touch tbl_playerdata and tbl_server.

 

@C-4-N & sp37zn4z

I will investigate this weaponstats issue. My personal tests dont revealed such an issue maybe my test were accurate enough.

 

@Frakkas

Rerun the streamprocess wont help you in my opinion, because your mysql server seems to have a max query limit set. The second try would fail like the first one. Procon react badly on ODBC errors. So need to avoid ODBC error or procon is prone to crash.

Otherwise somemore info about you db host would also help me.

2. Point is that would need to implement new methode to determinate how far the streamingprocess was gone.

So the chance to fix it is far lower than the chance to break this working system now. Anyway i will see if i can improve anything.

 

@eumel

Need to install the ODBC Connector and configure it:

www.phogue.net/forumvb/showth...-Configuration*.

The ODBC Driver is need otherwise the plugin wont work.

 

@Porthos

You need to create the DB and the user only.

The plugin creates the needed tables by its own.

 

Hopefully didnt forget anybody. Otherwise protest please^^

[ImportBot]

Originally Posted by Porthos*:

 

Thanks for the reply. Will install next time the server is dead.

[ImportBot]

Originally Posted by NoID96*:

 

Hello,

i need a Free mySQL hosting with REMOTE ACCESS.

Where can I get one?

[ImportBot]

Originally Posted by ty_ger07*:

 

Hello,

i need a Free mySQL hosting with REMOTE ACCESS.

Where can I get one?

Free MySQL is usually quite awful. (connection rejections, service unavailable, time-outs, etc.) I pay for mine and it is still hardly good enough for this plugin.

[ImportBot]

Originally Posted by Clay52*:

 

Hey what if anything am I doing wrong with any settings, when a player would type @stats FAMAS or @stats dogtags or @stats USAS-12 and gets no specific weapon found error?

[ImportBot]

Originally Posted by sp37zn4z*:

 

Hey what if anything am I doing wrong with any settings, when a player would type @stats FAMAS or @stats dogtags or @stats USAS-12 and gets no specific weapon found error?

I think we have the same problem. for the FAMAS to work you need to add it in the keywords FAMAS{FAMAS}. But i doubt it'll work.

@stats weapon @top10 weapon and @dogtags is broken for me. It seems it can't fetch the data required in the database everytime a user query.

[ImportBot]

Originally Posted by ty_ger07*:

 

Hey what if anything am I doing wrong with any settings, when a player would type @stats FAMAS or @stats dogtags or @stats USAS-12 and gets no specific weapon found error?

None of the dog tag stats, weapon stats, or weapon top 10 work for me either. Dog tag stats gives no stats and weapon stats and weapon top 10 give no weapon found.

[ImportBot]

Originally Posted by Clay52*:

 

None of the dog tag stats, weapon stats, or weapon top 10 work for me either. Dog tag stats gives no stats and weapon stats and weapon top 10 give no weapon found.

Ok guys thanks for posting. Hopefully Xp will chime in on this and enlighten us.

[ImportBot]

Originally Posted by feeblemedic*:

 

same issue. be nice if it worked like bc2.

[ImportBot]

Originally Posted by sp37zn4z*:

 

phew.... i though i'm just the one having the problems with weaponstats. so officially weaponstats is broken? i'm about to reinstall my database but thanks to the replies it seems im not just the only one having the problem. i'm gonna stick to my current setup as of now.

[ImportBot]

Originally Posted by sp37zn4z*:

 

finally my weaponstats is working. i think the culprit was using freemysql hosting sites causes the problem. Currently my new database is hosted on a spare blade server here in my workplace. !stats weapon !top10 weapon !dogtags are all working now. cheers!

[ImportBot]

Originally Posted by Clay52*:

 

finally my weaponstats is working. i think the culprit was using freemysql hosting sites causes the problem. Currently my new database is hosted on a spare blade server here in my workplace. !stats weapon !top10 weapon !dogtags are all working now. cheers!

Well that's interesting but I happen to be with one of the leading GSPs out there, NFO where my web stuff is so that simply can't be it, glad it's working for you though.

[ImportBot]

Originally Posted by apocalypsedan*:

 

Hi I have the MYSQL Databases with all requirements installed all you need to do is add your server details

I am in the process of installing the INNODB engine that allows remote connections.(MYSQL Version 5.1.x is required!!!)

Also the ODBC 5.1 Driver

 

If you would like to rent one of my databases they are all hosted at

 

Pinellas Hosting https://www.pinellashosting.com/

on a Corei5 16GB RAM 2 X 1TB HD 3TB Transfer Dedicated box

the cost of this is a $2 per calendar month paid in advance set up is nearly instant

 

like i said they will be available by the 10th jan 2012 anyone intrested in a database for there stats please pm me

[ImportBot]

Originally Posted by Terran*:

 

I also have a few questions on the plugins functions:

 

What's the function of these options? What does it do?

 

MapStats

Overall ranking(merged Serverranking)

Send Stats to all Player

tableSuffix

TimeOffset

Servertime Offset

Webrequest

 

I'm asking coz i didn't read any info's regarding these options from the plugin details. No info given by the users nor the developer itself. And btw, i browsed all 38 pages in this thread before posting this.

 

Thanks

I've digged a bit in the code about the "Webrequest" option. The GUI interprets the "&" sign instead of displaying it, so the full option name is

Periodical Webrequest On_(P&S Stats)

 

Now I've searched for "P&S Stats" and came across this site: http://eot-clan.net/p-s-stats-script/

 

hope this helps

[ImportBot]

Originally Posted by Pickerd*:

 

Any way to get a more detailed readme about the settings to save first time installers some, well, time. It's trial and error and alot of guesswork trying to figure out what all the settings are for. What does Mapstats do and is it something that needs to be enabled? What about Session? All those settings are open to the users interpretation if it lacks documentation and explanation, and language barriers play a role in that perception.

[ImportBot]

Originally Posted by TimSad*:

 

Weaponstats do not work on my server. Is it because your BF3.def files is needed for this to work?

[ImportBot]

Originally Posted by EBassie*:

 

Hey XPkiller,

 

I had to put back a backup of my stats database, because our MySQL server had a sudden shutdown.

So some tables were not updated when that happened.

 

So I put a backup back from a couple of days ago.

 

But now I'm facing this problem:

 

Code:

[20:33:38 70] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.1.35]Cannot add or update a child row: a foreign key constraint fails (`11-clan_stats`.`tbl_playerstats`, CONSTRAINT `fk_tbl_playerstats_tbl_server_player1` FOREIGN KEY (`StatsID`) REFERENCES `tbl_server_player` (`StatsID`) ON DELETE CASCADE ON UPDATE NO ACTION)
[20:33:38 70] Native: 1452
[20:33:38 70] Source: myodbc5.dll
[20:33:38 70] SQL: HY000

The table "tbl_server_player" gets updated, but "tbl_playerstats" is not.

Any idea on how to fix this?

[ImportBot]

Originally Posted by XpKiller*:

 

@TimSad

The the bf3.def file which comes with the latest procon version fine.

Please make sure the the keywordlist is not empty.

Atm im a little bit short with time im hopefully have some at the weekend to take a look at the weaponstats issue.

 

@EBastard

Have you restored the whole db or only single tables?

 

Also you could try to drop the constrain and re add it.

 

If you could more information would be fine to because you error is very general.

 

Have you stopped the proconlayer? The pluging has a cache maybe the are some entrys still in there.

[ImportBot]

Originally Posted by EBassie*:

 

I had an complete export made by phpAdmin. So no single tables.

 

Do you have any info how to 'drop the constrain'? I'm not an innoDB guy

 

Good point in stopping the layer... Checking it out first.

 

 

 

EDIT:

After 3 Layer restarts and 3 new imports the problem seems fixed.

I hope... Need to wait some more round updates to be sure.

[ImportBot]

Originally Posted by XpKiller*:

 

These contrains should prevent that your db get corrupt.

Your error properly means that the plugin tries to add a value into tbl_playerstats which not exists in tbl_server_player

[ImportBot]

Originally Posted by TimSad*:

 

@TimSad

The the bf3.def file which comes with the latest procon version fine.

Please make sure the the keywordlist is not empty.

Atm im a little bit short with time im hopefully have some at the weekend to take a look at the weaponstats issue.

I am running Procon 1.1.3.1 and version 0.0.0.9beta of this plugin. When I type !stats knife in chat this is the debug output that results...

 

[14:19:33 55] Error: SQLQuery:

[14:19:33 55] Index #0

[14:19:33 55] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.0.91-log]Table 'bf3tdm.tbl_weapons_Melee' doesn't exist

[14:19:33 55] Native: 1146

[14:19:33 55] Source: myodbc5.dll

[14:19:33 55] SQL: 42S02

This is in the Keyword List... Weapons/Knife/Knife{KNIFE}

 

This is what my table is... tbl_weapons_melee

 

I just realized, this stuff is case sensitive, right? That must be the problem, right?

[ImportBot]

Originally Posted by XpKiller*:

 

@TimSad

 

Good Find!!! this could be an issue.

 

i tested on a windows mysql Server with is not case sensitive. Btw. the Linux mysql server is case sensitive.

I will fix that a soon as possible.

[ImportBot]

Originally Posted by Porthos*:

 

What does it meand exaclty when you get

 

Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

 

Hosting company for my site which is where I created the database, says as far as they can tell everything should be good to go but when I turn on the plugin I get that error and no tables are created.

[ImportBot]

Originally Posted by sp37zn4z*:

 

I am running Procon 1.1.3.1 and version 0.0.0.9beta of this plugin. When I type !stats knife in chat this is the debug output that results...

 

 

 

This is in the Keyword List... Weapons/Knife/Knife{KNIFE}

 

This is what my table is... tbl_weapons_melee

 

I just realized, this stuff is case sensitive, right? That must be the problem, right?

The default Weapons/Knife/Knife{KNIFE} doesn't work because for some reason procon/bf3 recognizes KNIFE as MELEE, and as you can see on the tbl_weapons_melee the MELEE row is being populated more than the KNIFE row does in values. So what i did for this to work is to change the keyword from Weapons/Knife/Knife to Melee{Knife,Melee}.

 

@Xpkiller

 

weaponstats are now working while the !dogstats returns blank results.

[ImportBot]

Originally Posted by ty_ger07*:

 

@TimSad

 

Good Find!!! this could be an issue.

 

i tested on a windows mysql Server with is not case sensitive. Btw. the Linux mysql server is case sensitive.

I will fix that a soon as possible.

My MySql database is running on a Linux server. Might that be the problem? My problem isn't limited to just Knife stats, it appears to include all Weapon stats. I have tried !stats names in upper case and lower case and neither worked.