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

[ImportBot]

Originally Posted by gabipaci*:

 

good news

 

btw:

Big Thanks for Your useful plugin!

And I'm happy with our great web developer, Thanks Dr4k3!

[ImportBot]

Originally Posted by lupri*:

 

good news

 

btw:

Big Thanks for Your useful plugin!

And I'm happy with our great web developer, Thanks Dr4k3!

this webstats is fantastic!!

[ImportBot]

Originally Posted by TimSad*:

 

Our webstat are 99% finished, U see here:

http://multistat.netgamezone.de/index.php

 

XpKiller: Can u check the played time please?

That is a last things, what we need to 100%

Nice Webstats there! Will Dr4k3 release this to the public? I'm sure he's still working on more details for it, right? I also suggest a chat message search function if he does not already have that in mind.

[ImportBot]

Originally Posted by gabipaci*:

 

Yes, the webstat will be public between the next few days.

I also suggest a chat message search function if he does not already have that in mind.

Useful idea, will do.

[ImportBot]

Originally Posted by Polak*:

 

O MY GOD! that's just awesome. I hope Drake realse this to the public, that will be the best.

 

Any way, excellent job, seriously, I'm like this " d(Ô_Ô)b " right now.

[ImportBot]

Originally Posted by Ryan57*:

 

i keep getting this error. Made a database on my website with Mysql. Any idea how to fix this?

 

[10:06:19 73] Error in Tablebuilder:

[10:06:19 74] Index #0

[10:06:19 74] Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

[10:06:19 74] Native: 0

[10:06:19 74] Source:

[10:06:19 74] SQL: IM002

Never mind, mysql version on my website is 5.0.45 Anywayto set up a database for free elsewhere?

[ImportBot]

Originally Posted by XpKiller*:

 

@Ryan57

Your error is not caused by the plugin.

The odbc driver is not installed or not configured on you procon server or layer.

[ImportBot]

Originally Posted by Ryan57*:

 

Ah alright, gonna need to set that up then. Thanks

 

wow i suck at this lol. Now i get this error

 

[12:56:38 79] Error in Tablebuilder:

[12:56:38 83] Index #0

[12:56:38 84] Message: [MySQL][ODBC 5.1 Driver]Unknown MySQL server host '******************' (2)

[12:56:38 84] Native: 2005

[12:56:38 84] Source:

[12:56:38 88] SQL: HY000

[12:56:38 88] Index #1

[12:56:38 88] Message: [MySQL][ODBC 5.1 Driver]Unknown MySQL server host '*******************' (2)

[12:56:38 88] Native: 2005

[12:56:38 89] Source:

[12:56:38 89] SQL: HY000

[ImportBot]

Originally Posted by GhostSheets*:

 

@Ryan57

Your error is not caused by the plugin.

The odbc driver is not installed or not configured on you procon server or layer.

So I have to install the ODBC driver on my Procon Layer? Is this something I can do myself?

 

When I submitted a ticket to GameServers, they told me it wasn't supported. I have FTP access to my Procon layer.

 

Help is appreciated. I have all the other pieces in play. Thanks,

[ImportBot]

Originally Posted by XpKiller*:

 

@Ryan57

You are one step close now

You mysql Server address is wrong.

http://webyog.com/faq/content/23/17/...rver-host.html

 

@GhostSheets

 

you cant install this drive over ftp you need to ask you hoster. But so far i know gameserver.com will not install this driver.

[ImportBot]

Originally Posted by GhostSheets*:

 

@Ryan57

You are one step close now

You mysql Server address is wrong.

http://webyog.com/faq/content/23/17/...rver-host.html

 

@GhostSheets

 

you cant install this drive over ftp you need to ask you hoster. But so far i know gameserver.com will not install this driver.

So in short, If your servers are hosted on GameServers.com you can't use this plugin. Right?

[ImportBot]

Originally Posted by Frakkas*:

 

So in short, If your servers are hosted on GameServers.com you can't use this plugin. Right?

That is correct. I moved my procon from gameservers to branzone and it's working fine.

[ImportBot]

Originally Posted by GhostSheets*:

 

That is correct. I moved my procon from gameservers to branzone and it's working fine.

Cool, I didn't know you could have Procon hosted on a separate host. Thanks!

[ImportBot]

Originally Posted by XpKiller*:

 

XpKiller: Can u check the played time please?

That is a last things, what we need to 100%

I have rechecked this time issue it.

The playtime is calculated correctly.

In version 1.0.0.x Anyway i didnt make any changes to way playtime is calculated.

 

Testdata:

Playered from 13:46:10 - 13:55:04 --> 534 seconds

My Playtime in DB: 491111 seconds

New Playtime now is 491645 seconds

 

So everything is fine here.

 

Keep in mind that the Score per minute is allways lower than in battlelog due because those bonus points for medals and ribbons are not transmitted via rcon.

[ImportBot]

Originally Posted by IceCold*:

 

hi xpkiller,

 

i have started to put some stats on my clans webpage using your BF3 Chat, GUID, Stats and Mapstats Logger.

i'm using a crude PHP script to calc player rank, but its very very slow.

is there a fastest way to calc player rank using PHP .

 

 

thanks

[ImportBot]

Originally Posted by XpKiller*:

 

@IceCold

to help you i need to know your scenario

Do you want to calcualte the rank for one player or du you want to have something like to Top10 players.

 

The next version will add a new column which contains the rank, so no calculation are needed anymore in future.

[ImportBot]

Originally Posted by IceCold*:

 

ok,

 

i just needed it for 1 player.

but i have worked it out. i think this is the best way :-

 

function P_rank ($n) {

$RN = 0;

$playerstats_query = "SELECT * FROM tbl_playerstats ORDER BY Score DESC";

$playerstats_result = mysql_query($playerstats_query);

 

while($playerstats_row = mysql_fetch_array($playerstats_result))

{

$Stats2ID = $playerstats_row['StatsID'];

$RN= $RN +1;

if ($n == $Stats2ID) { break; }

 

 

}

 

return $RN;

}

[ImportBot]

Originally Posted by XpKiller*:

 

@IceCold

 

Select * is always bad

 

Also your code will return wrong results

 

try this query:

Code:

SELECT pd.SoldierName,y.Score, y.Kills, y.Deaths, y.Suicide, y.TKs, y.rank, (SELECT CountPlayers FROM tbl_server_stats WHERE ServerID = 2) allrank ,y.Playtime, y.Headshots, y.Rounds, y.Killstreak, y.Deathstreak 
								FROM (SELECT(@num := @num+1) rank, sp.PlayerID, ps.Score, ps.Kills, ps.Deaths, ps.Suicide, ps.TKs, ps.Playtime, ps.Headshots, ps.Rounds, ps.Killstreak, ps.Deathstreak  
                      FROM tbl_playerstats ps 
                      STRAIGHT_JOIN tbl_server_player sp ON sp.StatsID = ps.StatsID ,(SELECT @num := 0) x           
                      WHERE sp.ServerID = 2
                      ORDER BY Score DESC) y 
INNER JOIN tbl_playerdata pd ON y.PlayerID = pd.PlayerID
WHERE pd.SoldierName = "_I_XpKiller_I_"

Note: remove all unneed columns to speed up the query.

 

 

 

Anyway in the next version this will be much simpler

I willl add a new column to tbl_playerstats or a new table which holds the rank.

 

then the query looks different but it runs much faster

Maybe like this:

Code:

SELECT tpd.SoldierName, tr.Rank 
FROM tbl_ranking tr
INNER JOIN tbl_server_player tsp ON tsp.StatsID = tr.StatsID
INNER JOIN tbl_playerdata tpd ON tsp.PlayerID = tpd.PlayerID
WHERE tsp.ServerID = 2 AND tpd.Soldiername = 'Bonebreak3r'

[ImportBot]

Originally Posted by IceCold*:

 

oh, ok.

 

thanks anyway.

 

also thanks for a such a cool plugin

[ImportBot]

Originally Posted by ty_ger07*:

 

For Friegide:

 

EDIT: Moved

 

www.phogue.net/forumvb/showth...apstats-Logger*

[ImportBot]

Originally Posted by ty_ger07*:

 

EDIT: Moved

 

www.phogue.net/forumvb/showth...apstats-Logger*

[ImportBot]

Originally Posted by XpKiller*:

 

Coming Changes in next Version:

 

The Rank of Player will be include into the table tbl_playerstats

A top10 would look like this query:

Code:

SELECT tps.rankScore AS Rank, tpd.SoldierName, tps.Score, tps.Kills,tps.Deaths , tps.Headshots
FROM tbl_playerstats  tps
INNER JOIN tbl_server_player tsp ON tsp.StatsID = tps.StatsID AND tsp.ServerID = 2
INNER JOIN tbl_playerdata tpd ON tsp.PlayerID = tpd.PlayerID
WHERE tps.rankScore BETWEEN 1 AND 10
ORDER BY tps.rankScore;

Result:

Code:

Rank, SoldierName, Score, Kills, Deaths, Headshots
1, Pillefuss, 1008362, 3207, 1882, 706
2, _I_XpKiller_I_, 750709, 3026, 1479, 986
3, Bonebreak3r, 677168, 2460, 1250, 585
4, _I-FLY-I_, 533121, 2205, 922, 519
5, GranDan, 514748, 1550, 1171, 277
6, Metoo2k, 504270, 2114, 1095, 497
7, HardstyI3, 450532, 935, 884, 245
8, SeviG101, 425530, 1668, 1218, 344
9, freakmaster8891, 407297, 1316, 1178, 293
10, Fubu338, 400385, 1442, 763, 310

And very fast! The DB dont need to tablesscan anymore

[ImportBot]

Originally Posted by ty_ger07*:

 

Coming Changes in next Version:

 

The Rank of Player will be include into the table tbl_playerstats

A top10 would look like this query:

Code:

SELECT tps.rankScore AS Rank, tpd.SoldierName, tps.Score, tps.Kills,tps.Deaths , tps.Headshots
FROM tbl_playerstats  tps
INNER JOIN tbl_server_player tsp ON tsp.StatsID = tps.StatsID AND tsp.ServerID = 2
INNER JOIN tbl_playerdata tpd ON tsp.PlayerID = tpd.PlayerID
WHERE tps.rankScore BETWEEN 1 AND 10
ORDER BY tps.rankScore;

Result:

Code:

Rank, SoldierName, Score, Kills, Deaths, Headshots
1, Pillefuss, 1008362, 3207, 1882, 706
2, _I_XpKiller_I_, 750709, 3026, 1479, 986
3, Bonebreak3r, 677168, 2460, 1250, 585
4, _I-FLY-I_, 533121, 2205, 922, 519
5, GranDan, 514748, 1550, 1171, 277
6, Metoo2k, 504270, 2114, 1095, 497
7, HardstyI3, 450532, 935, 884, 245
8, SeviG101, 425530, 1668, 1218, 344
9, freakmaster8891, 407297, 1316, 1178, 293
10, Fubu338, 400385, 1442, 763, 310

And very fast! The DB dont need to tablesscan anymore

Hooray! That will be very helpful to many.

[ImportBot]

Originally Posted by Sage-BRIG*:

 

I had this working but accidentally deleted the SQL, I reinstalled it but its still crashing procon when I enable it. Any ideas?

 

Update, error I see before crash says cant connect mysql to (our address)

 

Update: We determined the ip had changed and needed to be updated server side. If anyone has the above issue, maybe this post will help.

[ImportBot]

Originally Posted by halli42*:

 

Hey,

 

how to update the plugin? Simply replace CChatGUIDStatsLoggerBF3.cs in my /bf3/ directory?

 

thanks in advance!

[ImportBot]

Originally Posted by leibhold*:

 

Hey,

 

how to update the plugin? Simply replace CChatGUIDStatsLoggerBF3.cs in my /bf3/ directory?

 

thanks in advance!

And restart procon...

[ImportBot]

Originally Posted by XpKiller*:

 

@halli42

you got it, just replace it.

 

New Version is coming this weekend.

[ImportBot]

Originally Posted by halli42*:

 

Just replaced the file on my ProCon-Layer and in my local /bf3/ directory. But it still says "0.0.1.2beta"....

[ImportBot]

Originally Posted by Klaauw*:

 

hi, i tried the plugin and it will crash the procon layer as soon as i set it to enabled.

any idea what might cause a crash like that? i can't find any information in my local logfiles, and i have no access to the layer logfiles...

Got exactly the same problem. Configured everything. But once i enable it: Boom procon layer crashes... Anything that i might have done wrong?

[ImportBot]

Originally Posted by GitSum*:

 

Got exactly the same problem. Configured everything. But once i enable it: Boom procon layer crashes... Anything that i might have done wrong?

That happens to me if I don't have the connection to the database setup properly. Where is the database and where is procon being hosted - is the ODBC driver installed?