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

[ImportBot]

Originally Posted by sp37zn4z*:

 

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.

I fix this by reinstalling a new database.

[ImportBot]

Originally Posted by TimSad*:

 

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.

Melee is the Takedown/animation which happens around about 90% of all knife kills. Knife is what happens when you just slash them from the front or somewhere that doesn't initiate the Takedown and is around about 10% of all knife kills.

 

That is not the problem, however. My problem is that it can't even get into any of those fields because it doesn't think the tbl_weapons_melee exists. Same thing happens when I try the AEK...

 

[18:07:39 60] Error: SQLQuery:

[18:07:39 60] Index #0

[18:07:39 60] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.0.91-log]Table 'b2kstats.tbl_weapons_AssaultRifle' doesn't exist

[18:07:39 60] Native: 1146

[18:07:39 60] Source: myodbc5.dll

[18:07:39 60] SQL: 42S02

@XpKiller

 

Yeah, I am using a MYSQL database hosted by GoDaddy. I'm pretty darn sure it is on Linux.

[ImportBot]

Originally Posted by ty_ger07*:

 

Yeah, I am using a MYSQL database hosted by GoDaddy. I'm pretty darn sure it is on Linux.

Me too. Mine is definitely on Linux.

[ImportBot]

Originally Posted by max1982*:

 

XpKiller Thanks for the plugin i have made a stats from your Plugin.

 

http://www.friendlygamersclan.com/mu...age.php_ab_s=1

 

Hop updates will coming soon:smile:

 

I question is there going to be Medal stat in the plugin and Kit?

[ImportBot]

Originally Posted by XpKiller*:

 

Something like awards is planned but with low priority

Kit stats are not possible atm due the gameserver don't report which kit a player has used.

And Update with bugfixes and new features is planned this weekend.

[ImportBot]

Originally Posted by Jenne*:

 

Hello,

 

We also have our 3 BF 3 server with the plugin BF3 Stats for Procon run, there is a possibility to bring this to my webpage? in html / php etc. ...

 

thank you

[ImportBot]

Originally Posted by seim*:

 

We also have our 3 BF 3 server with the plugin BF3 Stats for Procon run, there is a possibility to bring this to my webpage? in html / php etc. ...

You could write a php Skript :>

[ImportBot]

Originally Posted by Jenne*:

 

ach ne

[ImportBot]

Originally Posted by Porthos*:

 

Any one have any ideas or way to get around this?

 

 

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

 

Any one have any ideas or way to get around this?

This issue is now answered countless times...

 

The ODBC Driver on the Server which host the Proconlayer is missing or not configured.

Ask you hosting partner for install or if it is you own server install the odbc driver by you own.

[ImportBot]

Originally Posted by CptChaos*:

 

I would like a query which gives the count (or sum) of each unique contrycode. But doing it with each available countrycode would make alot of queries to fix that, which is not sufficient I believe. I can only think of this query, which is insufficient, but I lack the knowledge of MySQL to accomplish this correctly.

Code:

SELECT COUNT (CountryCode) from tbl_playerdata WHERE countrycode = $someCountryCode

.

This is not sufficient, I think it can be done for all countrycodes in just one query, but I do not know how, looping between them or even using subqueries would only make it longer to take. I hope I am not to unclear.

 

Many thanks in advance!

 

EDIT: I've found thatCode:

SELECT DISTINCT CountryCode
FROM tbl_playerdata

selects all the countrycodes, but I need the total numbers from each countrycode as well.

[ImportBot]

Originally Posted by ty_ger07*:

I would like a query which gives the count (or sum) of each unique contrycode. But doing it with each available countrycode would make alot of queries to fix that, which is not sufficient I believe. I can only think of this query, which is insufficient, but I lack the knowledge of MySQL to accomplish this correctly.Code:

SELECT COUNT (CountryCode) from tbl_playerdata WHERE countrycode = $someCountryCode

.This is not sufficient, I think it can be done for all countrycodes in just one query, but I do not know how, looping between them or even using subqueries would only make it longer to take. I hope I am not to unclear.Many thanks in advance!

Is this in PHP for a website, or what is the application? For PHP, here's a start:Code:

<html>
<head>
<title>BF3 Country Stats</title>
</head>
<body>
<_php

//DATABASE INFORMATION

$db['host']		=''; // enter your database login information here
$db['uname']	='';
$db['pass']		='';
$db['name']		='';

//DATABASE ACCESS

mysql_connect($db['host'], $db['uname'], $db['pass']);
mysql_select_db("$db[name]") or die ("<b><center>Unable to access database. Please notify administrator.</center></b>");

//PAGE CONTENT
echo "Number of players from each country:";

// make an empty array
$country_code_array = array();

// get all the country codes
$get_countries = mysql_query("SELECT CountryCode FROM tbl_playerdata WHERE 1 ORDER BY CountryCode ASC");

while($get_countries_row = mysql_fetch_assoc($get_countries))
{
	$country_code = $get_countries_row['CountryCode'];

	// add this country code to the array
	$country_code_array[] = $country_code;
}

// now all the country codes are in the array

// find all the unique country codes
$unique_country_code_array = array_unique($country_code_array);

// now we will count how often each unique country code was found in the array of all country codes

foreach($unique_country_code_array AS $current_country)
{
	$number_unique_country = count(array_keys($country_code_array, "$current_country"));
	
	// display it to on screen
	echo "   $current_country: $number_unique_country";
}

_>
</body>
</html>

Example:http://thetacteam.info/countrystats.php Of course that is a very crude output, but that will provide you with all the data to sort and display as you see fit.

[ImportBot]

Originally Posted by XpKiller*:

 

Its much easier and can be solved in one SQL Query:

 

Code:

SELECT CountryCode, COUNT(CountryCode) AS PlayerCount from tbl_playerdata GROUP BY CountryCode ORDER BY PlayerCount DESC;

This does the sames as ty_ger07 code but much faster because the MySql Server do the sorting and not the php.

[ImportBot]

Originally Posted by Porthos*:

 

Can some one recommend a reliabe Procon Host that does allow the driver to be installed so I can use this plugin?

[ImportBot]

Originally Posted by CptChaos*:

 

Can some one recommend a reliabe Procon Host that does allow the driver to be installed so I can use this plugin?

You can host your own Procon!

 

Its much easier and can be solved in one SQL Query:

 

Code:

SELECT CountryCode, COUNT(CountryCode) AS PlayerCount from tbl_playerdata GROUP BY CountryCode ORDER BY PlayerCount DESC;

Few pages ago I've read something about a bundle with a lot of queries, has this bundle been released yet?

 

 

This does the sames as ty_ger07 code but much faster because the MySql Server do the sorting and not the php.

Great, awesome! I accidently forgot to mention one thing, I hope you don't mind. I would also like to know the percentage of the total players are for example Dutch, German, Belgian, Russion, French and the like, is that also possible? I can't seem to get that working.

 

EDIT:

Few pages ago I've read something about a package with different queries, is that package still coming? I sure hope so!

 

EDIT 2:

I am updating my stats pages for B2K, I now also have a table tbl_weapons_none, what are those kills? And what are death_kills en death_deaths? Is that a friendly kill or a kill with no weapon?

 

Could it be vehicle kills?

[ImportBot]

Originally Posted by GitSum*:

 

Can some one recommend a reliabe Procon Host that does allow the driver to be installed so I can use this plugin?

Take a look at Branzone. They are on the "licensed" list, allow full FTP access a web interface so others can stop/restart the layer server if need be and you should not have any problems connecting this plugin to a database hosted elsewhere

 

http://www.branzone.com/

[ImportBot]

Originally Posted by XpKiller*:

 

New Version 0.0.1.0

 

Maybe this is the last beta ;-)

 

Please post your errors and suggestions for improvment

 

Changelog:

[0.0.1.0beta]

fixed ingame weaponstats

added option to turn off ingame commands

added options to customize the top10 messages

 

The sql query examples will come soon.

 

 

@CptChaos

 

the weapon death are kills with vehicle.

The Gameserver dont report vehicle kills to procon correctly atm.

[ImportBot]

Originally Posted by CptChaos*:

 

New Version 0.0.1.0

 

Maybe this is the last beta ;-)

 

Please post your errors and suggestions for improvment

 

Changelog:

[0.0.1.0beta]

fixed ingame weaponstats

added option to turn off ingame commands

added options to customize the top10 messages

 

The sql query examples will come soon.

 

 

@CptChaos

 

the weapon death are kills with vehicle.

The Gameserver dont report vehicle kills to procon correctly atm.

NIce, I just updated to the new version as well, thanks for that! Yes, I went outside in the cold to think, when I came in a lightbulb started to glow and came with the vehicle idea, but thanks for the confirmation!

 

Could you help me with the query question as well? I have to admit that your (My)SQL knowledge is better than mine, lol!

Great, awesome! I accidently forgot to mention one thing, I hope you don't mind. I would also like to know the percentage of the total players are for example Dutch, German, Belgian, Russion, French and the like, is that also possible? I can't seem to get that working

[ImportBot]

Originally Posted by XpKiller*:

 

@CptChaos

 

This Query will do it:

 

Code:

SELECT CountryCode,COUNT(CountryCode) AS PlayerCount, ((COUNT(CountryCode)/(SELECT COUNT(*) FROM  tbl_playerdata))*100) AS PlayerCountryProcent from tbl_playerdata GROUP BY CountryCode ORDER BY PlayerCountryProcent DESC

[ImportBot]

Originally Posted by ty_ger07*:

 

New Version 0.0.1.0

 

Maybe this is the last beta ;-)

 

Please post your errors and suggestions for improvment

 

Changelog:

[0.0.1.0beta]

fixed ingame weaponstats

added option to turn off ingame commands

added options to customize the top10 messages

Weapon stats are working for me now. Thanks!

 

I think the only thing left that doesn't work is the dog tag stats. I assume that the next release will be the official release with that final issue fixed.

[ImportBot]

Originally Posted by TimSad*:

 

Weapon stats are working for me now. Thanks!

Yep! Weaponstats are now working! Thanks mucho!

[ImportBot]

Originally Posted by Panther*:

 

My Keywordlist has 23 Weapons. Some Weapons are missing. Do i have to add them manually or is there a predifened Keywordlist with more weapons in it?

 

Weaponstats working here too.

[ImportBot]

Originally Posted by CptChaos*:

 

@CptChaos

 

This Query will do it:

 

Code:

SELECT CountryCode,COUNT(CountryCode) AS PlayerCount, ((COUNT(CountryCode)/(SELECT COUNT(*) FROM  tbl_playerdata))*100) AS PlayerCountryProcent from tbl_playerdata GROUP BY CountryCode ORDER BY PlayerCountryProcent DESC

You sir, have once again made yourself Godlike. About the query: I was thinking the only way was with a subquery, and so did you... Think I'm starting to learn it!

 

I also have a feature request:

Is it possible for the plugin to determine on which port and host (IP for example) it is running? Would be nice if that could be added to it, making it easier to check whether or not the Procon layer is running. I've added it manually in the database, but automated would be cool!

[ImportBot]

Originally Posted by lupri*:

 

hi, i'm new to procon. i've istalled many plugins, they are all great. But i've a problem with this one. I just need the chat logger, but i can't configure the plugin.

 

i got the error message:

Message: [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on 'localhost' (10061)

 

 

i think is because i didn't set any server. how should i set a server?

 

sorry but i'm a newbie

 

thanks!

[ImportBot]

Originally Posted by XpKiller*:

 

My Keywordlist has 23 Weapons. Some Weapons are missing. Do i have to add them manually or is there a predifened Keywordlist with more weapons in it?

 

Weaponstats working here too.

The Keywordlist only contains remapping to friendly names for some weapons.

The real name of e.g. Scar-H is Weapons\Scar-H\Scar-H.

You wont like to type in Weapons\Scar-H\Scar-H to get weaponstats ingame. So it is remapped to just scar or scar-h.

 

You could also give M320 an alternative name like noobtube.

 

So plugin knows all weapons which are in you bf3.def file of procon. Some of them have a friendly name already and dont need to be remapped.

[ImportBot]

Originally Posted by beantje*:

 

i have rent a server, and have somewebspace, with directadmin login,

can i make this plugin work ?

 

thx

[ImportBot]

Originally Posted by Frakkas*:

 

weapons stats are working for me now (have a linux based mysql provider) but I'm still getting these:

 

[22:11:54 07] Warning: Weapon: FAMAS is missing in the bf3.def file!!!

 

I recall seeing in a post that you were including an updated version of the bf3.def file, but I didn't see it in the zip. I *think* I have the latest one from procon (I redownloaded and compared the def file from that with the one on the server). None of the Assignment weapons are in it, though.

 

Also, I am getting a lot of uninitialized RoundStart and RoundEnd times in my tbl_mapstats, and my session time always starts out negative. I am using a server offset of -2, and it's always close to -116 minutes or something like that, so perhaps one time is initialized with the offset and the other is not.

[ImportBot]

Originally Posted by XpKiller*:

 

@lupri

you need a mysql database to run this plugin.

 

@beantje

if you webspace contains a mysqldb (in most cases it will) you can run this plugin if the mysql server allows external connections.

 

@Frakkas

The FAMAS is in the lastest bf3.def, which comes with procon (version 1.1.3.1)

You procon layer properly has an old version of the bf3.def file.

[ImportBot]

Originally Posted by Frakkas*:

 

@Frakkas

The FAMAS is in the lastest bf3.def, which comes with procon (version 1.1.3.1)

You procon layer properly has an old version of the bf3.def file.

I see what's up now. My desktop client is 1.1.3.1 - the official download from phogue.net is still 1.1.3.0, so when I looked at the latest download, it's stale, but equivalent to the one on the layer server.

 

Usually, the client shows a message when it's out of step with the layer server...

 

Is there an easy way to update the layer server? Or do I need to ask the layer provider to do it?

[ImportBot]

Originally Posted by CptChaos*:

 

Any idea when suicide is comming in the bf3.def file? Sometimes I get an error that 'weapon' suicide is missing in bf3.def file.

 

@Frakkas: If you have a hosted Procon layer than yes, otherwise you can update the layer yourself (which is exactly the same as updating your own Procon).