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

[ImportBot]

Originally Posted by ToM666*:

 

Okay, I've created a mysql database onlinem how do I do this:

 

"Add the machine running the plugin to the remote mysql access host list"

 

Sorry guys on a bit of a steep learning curve here never down anything mysql before.

[ImportBot]

Originally Posted by ToM666*:

 

also what is the plugin asking for when it says "web address" is that just the domain name of the website where the database is?

[ImportBot]

Originally Posted by XpKiller*:

 

You mean Webrequest?

This is only needed if you have a web script running on you webserver needs to be run every 30 Minutes. ( The old P&S Stats needed it for calculateding the stars).

If you dont need this keep it off.

[ImportBot]

Originally Posted by Porthos*:

 

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/

I contancted branzone and was told they do not allow the ODBC driver. gameservers doesn't allow it and neither does my website host. Guess I am out of luck when it come to running this plug in

[ImportBot]

Originally Posted by bionicchicken*:

 

Thanks - very nice plugin and working perfectly

[ImportBot]

Originally Posted by GitSum*:

 

I contancted branzone and was told they do not allow the ODBC driver. gameservers doesn't allow it and neither does my website host. Guess I am out of luck when it come to running this plug in

I switched to Branzone in December and have been running this plugin without any problems (unless they changed their policy)

 

Here is their reply to my email when I first inquired about their service:

 

Hello,

FTP access is available with our Procon Layer Hosting and you can install any plugins you want. Yes the ODBC mysql drivers are installed and we have numerous customers connecting to external databases.

 

If you have any other questions please let us know.

 

--

Brandon M

[ImportBot]

Originally Posted by ToM666*:

 

Hi guys, I am still trying to install this and I am stuck with this bit:

 

"Add the machine running the plugin to the remote mysql access host list"

 

This is what I am faced with and having been through all the tabs and tried to google the solution, I cannot see a "mysql access host list".

 

Also, how do I add the machine? Do I add the IP address or something?

 

Any help would be appreciated

[ImportBot]

Originally Posted by Porthos*:

 

I switched to Branzone in December and have been running this plugin without any problems (unless they changed their policy)

 

Here is their reply to my email when I first inquired about their service:

Went ahead and switched my procon hosting to branzone and now have the plugin active.

See that the EoT guys have a server stats page that uses this. Going to give it a try. I use their server viewer and leaderboards on my site. They do great work.

[ImportBot]

Originally Posted by GitSum*:

 

Hi guys, I am still trying to install this and I am stuck with this bit:

 

"Add the machine running the plugin to the remote mysql access host list"

 

This is what I am faced with and having been through all the tabs and tried to google the solution, I cannot see a "mysql access host list".

 

Also, how do I add the machine? Do I add the IP address or something?

 

Any help would be appreciated

Where is your database hosted?

 

If it is one of the "big" web site hosting companies, they usually have something in the control panel regarding remote access. The game server provider we use has a simple checkbox to allow external connections

[ImportBot]

Originally Posted by ToM666*:

 

Where is your database hosted?

 

If it is one of the "big" web site hosting companies, they usually have something in the control panel regarding remote access. The game server provider we use has a simple checkbox to allow external connections

I'm with clanwebs, I don't see anything like you have described. I may have to ask the provider but he comes across as not being particularly knowledgable on this sort of thing.

 

http://www.clanwebs.co.uk/

[ImportBot]

Originally Posted by GitSum*:

 

That may be the easiest way - just say you need to have external access/connections to one of your databases - (you may need to provide them with the ip address of your procon layer so they can "whitelist it")

[ImportBot]

Originally Posted by NoID96*:

 

where can i get a free remoteable mysql database?

[ImportBot]

Originally Posted by ToM666*:

 

That may be the easiest way - just say you need to have external access/connections to one of your databases - (you may need to provide them with the ip address of your procon layer so they can "whitelist it")

Hi mate, I have just had this reply from my website provider:

 

************************************************** *********************

Hi ToM,

 

Just enter your database info into your script config, it should not matter what computer/laptop you are using.

 

If however you are trying to access the database from a script not hosted on the same server, then instead of 'localhost', use the server 'IP Address'.

 

Kind regards

Paul

************************************************** **********************

 

Still confused.

 

Looking at it logically the plugin needs to know where the database is so it can read and write to it.

 

I am guessing that is what these variables are for on the plugin settings?

 

Host: I'm guessing the website URL as in when you FTP or the path

Port: Dont have this?

Database name: I have this

username: I have this

 

password: I have this

 

I imagine provided the website provider doesn't block it, which it sounds like he isn't going to, I should be good to go?

 

So I suppose the questions now are:

 

1)Am I right? and if so;

2) What am I supposed to put in the Host and port sections?

 

Thanks again to those that are attempting to help me with this.

 

ToM

[ImportBot]

Originally Posted by XpKiller*:

 

@Tom666

Try the default port: 3306

 

Host could be the Host then leave out http:// and paths --> cpanel.clanwebs.co.uk

 

But i dont think this is the right address because no server listen on port 3306 on this address. you can check this with telnet

[ImportBot]

Originally Posted by gabipaci*:

 

Hi!

 

We working on webstat, and use this plugin for that.

I have problem only with the playertime.

If i see 1500 in the playertime field, how to can i convert to seconds?

I tried this with my solider, and i think, i need divide with 3,4

 

Real time chat are working, real time status for player numbers, map name, mode are working.

Can u make real time status for player name?

 

Thank U for Your great job!

Best Regards, Gabor

(sorry for my basic english)

[ImportBot]

Originally Posted by XpKiller*:

 

@gabipaci

Realtime statstracking is not implemented yet because the mayor of people will get performance problems.

 

 

the Field Playertime is in seconds.

 

I will release an Update today with fixes and a new feature serverstats.

It will introduce a new table which hold data like Playercount Avg.Score usw.

 

Anyway if you got good ideas for feature feel free to post them!

[ImportBot]

Originally Posted by gabipaci*:

 

@XpKiller

No, i dont want the RealTime stattracking, just player name tracking, if it possible. Like the playernumber and map name tracking. When i change the map on our server, the plugin is send the new map nema within 2 secons abt.

 

I will try again the playertime asap, just i cooking atm

 

And, how to can i logging the chat inclouding join/leaving and kill/deaths to sql database?

 

Update:

player time is not in second.

i read the database before and after playing, have 3600 pionts difference between score and 790 (seconds___) difference between the player time. I just rush over on the map, arm and destroy 3x2 m-com (3600points) and play 4min 40 seconds on the map. (approx 5 min 20sec with loading and stat count) this is just about 300sec, so far from 790.

[ImportBot]

Originally Posted by XpKiller*:

 

@XpKiller

No, i dont want the RealTime stattracking, just player name tracking, if it possible. Like the playernumber and map name tracking. When i change the map on our server, the plugin is send the new map nema within 2 secons abt.

 

And, how to can i logging the chat inclouding join/leaving and kill/deaths to sql database?

 

Update:

player time is not in second.

i read the database before and after playing, have 3600 pionts difference between score and 790 (seconds___) difference between the player time. I just rush over on the map, arm and destroy 3x2 m-com (3600points) and play 4min 40 seconds on the map. (approx 5 min 20sec with loading and stat count) this is just about 300sec, so far from 790.

I will review playertime it should be in second maybe i got a bug in it so it started count to late.

 

Join/Leave History is planned soon.

[ImportBot]

Originally Posted by XpKiller*:

 

New version 0.0.1.1

 

Added new Ingamecommand serverstats

Added a new table which holds serverstatistics data (good for website /faster queries /access to precalculated values)

Fixed dogtags stats

Several small fixes to reported bugs.

 

Changelog:

 

[0.0.1.1beta]

fixed ingame dogtags

added new Ingame Command serverstats

The Usage of this command is the same like stats

added a new table tbl_server_stats which contains server stats (very useful for websites)

some minor changes and fixes

 

 

New todos:

Join/leave History for Players

investigate Playertime (it should be correct hmm lets see if i find something)

realtime tracking of playerdata( no stats just name, guid, ip)

[ImportBot]

Originally Posted by ToM666*:

 

@Tom666

Try the default port: 3306

 

Host could be the Host then leave out http:// and paths --> cpanel.clanwebs.co.uk

 

But i dont think this is the right address because no server listen on port 3306 on this address. you can check this with telnet

Thanks xpkiller you were right about the port.

 

I have had confirmation of the all the information now I need for the plugin except the host.

 

The website provider had this to say:

 

The Host depends on where the script that is using the database is located, same server is local host, different server you use the server IP address 79.170.40.236

 

I have tried the following:

 

1) localhost

2) local host

3) 79.170.40.236

4) my public IP address

5) my router IP address

 

I get an error which is something like this:

 

SQL: HY000

error in tablebuilder

index #0

Message: [Mysql][odbc 5.1 driver] access denied for user 'web105-1-t_stats@cpc2-nfds13-2-0- etc etc

Native 1045

source:

 

I'm a bit stumped now.

[ImportBot]

Originally Posted by XpKiller*:

 

@Tom666

your user or Password is incorrect

 

Small hotfix 0.0.1.2

 

Changelog:

hotfix for a sql query which causes a error on sql server with sql strict mode on

[ImportBot]

Originally Posted by gabipaci*:

 

New version 0.0.1.1

New todos:

Join/leave History for Players

investigate Playertime (it should be correct hmm lets see if i find something)

realtime tracking of playerdata( no stats just name, guid, ip)

Respect! BIG Respect!

[ImportBot]

Originally Posted by Narf!*:

 

Well, I've got some problems with this plugin

 

Couldn't get a MySQL database running on my v-server, so I go one from db4free.net. Installed the plugin on my layer server, set procon settings, set plugin and sql settings, works. But my problem is... With this plugin my Procon layer server gets laggy. Really laggy. Chat is laggy, events (frm other plugins) are laggy, rank request is laggy, ticket count is laggy, event log is laggy... Don't know what to do. Is it a bug? Is it procon? is it the free database? Need some help what I could do. Anyone? Pleaaaase, would be nice

 

Greetz

[ImportBot]

Originally Posted by micovery*:

 

Well, I've got some problems with this plugin

 

Couldn't get a MySQL database running on my v-server, so I go one from db4free.net. Installed the plugin on my layer server, set procon settings, set plugin and sql settings, works. But my problem is... With this plugin my Procon layer server gets laggy. Really laggy. Chat is laggy, events (frm other plugins) are laggy, rank request is laggy, ticket count is laggy, event log is laggy... Don't know what to do. Is it a bug? Is it procon? is it the free database? Need some help what I could do. Anyone? Pleaaaase, would be nice

 

Greetz

I have had similar issue ... if the MySQL connections take a long time to respond (mostly the ones that end up timing-out) ... the plugin lags all of PRoCon. It comes to a screeching halt. I think this is because some of the queries are done directly from the event handlers.

 

These are some places I could find ...

 

Code:

OnServerInfo -> getUpdateServerID
OnPlayerJoin -> CreateSession-> GetRank
OnPlayerJoin -> WelcomeStats
OnCommandSession -> GetSession -> GetRank
OnListPlayers -> CreateSession -> GetRank
OnCommandDogtags -> GetDogtags

Because of this, PRoCon probably has to wait until the plugin is done doing its business before it moves to the next plugin and fire the same event. (hence the lag)

 

It would be nice if the plugin dealt with DB Queries in parallel, so that PRoCon does not halt while plugin waits for the query results.

[ImportBot]

Originally Posted by XpKiller*:

 

@Narf

I never monitored such a behavior of the plugin.

Maybe other plugin effect each other in some way.

 

This plugin is very passive it doesn't trigger any additional requests to the gameserver.

The only thing are chat messages which where sent to the server.

Try to disable welcomestats if enabled and disabled ingame commands. This will prevent the plugin to send any additional request.

 

Also turn of instant chat logging

 

Note:

If possible you should not use a free db due the performance and reliability is not so good. Try to setup the db on your root. If you need help you could writte me a pm.

But in general a slow db should not create laggs.

 

@micovery

 

good point i allways though such event are fired into an own thread.

so it seems in need to implement more threads here.

 

Edit:

Oh great threading in c# 2.0 just sucks...

cool stuff like this dont work..

Code:

Thread t = new Thread( () => this.CreateSession (strSoldierName, 0) );
            t.Start();

In need to wrap it into an object or class to pass multiply parameters

 

Edit2:

properly working

Code:

ThreadStart starter = delegate { this.CreateSession(strSoldierName, 0); };
Thread t = new Thread(starter);
t.Start();

[ImportBot]

Originally Posted by XpKiller*:

 

I will release a threaded version soon to fix those hangs with slow db.

[ImportBot]

Originally Posted by ToM666*:

 

@Tom666

your user or Password is incorrect

LOL just got these messages from my website provider after I asked if I was correct to use the database password or was there another one I should use

 

"Dear ToM

 

If that's the password, then that's what you use. Your original question stated you wanted to read/write to a database from your laptop..

 

What are you trying to do exactly? Is the script running on the web server along with the database, or are you trying to run a php script on your laptop, and connect to a database on your webserver?

 

The latter is not going to work, you will be better off using WAMP server (Windows) or MAMP (Mac) to create a virtual server on your laptop where you can run Apache, MySql and php locally.

The easiest way is to install it on your webserver, and access through the web based admin panel (If this is an option), then just parse your log files manually, or by setting up a cronjob/scheduled task. This is the way 99% of game server stats tools run.

 

The other way is to install it on the game server.

 

The developers will tell you which is the recommended way to do this.

 

I have never come across one which you install on your laptop, whats the point_"

 

So basically what he is saying is it wont work and I particularly like the way he said the comment below bearing in mind I had already explained I am a bit of a novice on this sort of thing

"just parse your log files manually, or by setting up a cronjob/scheduled task"

 

Like I am going to know what any of that means it may as well be in russian LOL

 

So next thing to do is use WAMP server to create a virtual server so I can parse my log files manually by setting up a cronjob/scheduled task. Simples

 

Very helpful. Cheers you condascending dick head.

 

I'm going to spend a bit of time on google learning about these things and I'll report back if it works. I might be some time.

[ImportBot]

Originally Posted by ty_ger07*:

 

0.0.1.2 :

 

%playerDeaths% in top10 stats is not substituting correctly. It shows a random number between two percent signs (%1234% for instance) instead of the correct number.

 

 

Table error:

[19:50:11 20] Error: Error in Startstreaming:

[19:50:11 20] Index #0

[19:50:11 20] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.0.92-log]Table 'bf3serverstats.tbl_playerstats' doesn't exist

[19:50:11 20] Native: 1146

[19:50:11 20] Source: myodbc5.dll

[19:50:11 20] SQL: 42S02

In this case, with the table suffix of that server, should be 'bf3serverstats.tbl_playerstats_16' not 'bf3serverstats.tbl_playerstats'.

 

 

All of the substitutions in the serverstats messages are not working -- the original commands (%sumScore% for instance) are displayed in the server chat instead of the value.

 

The only backup I have is version 0.0.0.9.

 

I also noticed that 'tbl_server_stats_16' and 'tbl_server_stats_32' are in the database, but the tables are all empty.

 

Going back to 0.0.0.9 for now since that is the only good backup I have.

 

 

 

 

EDIT:

 

The fix for the table issue:

Code:

string serverstats = @"REPLACE INTO " + this.tbl_server_stats + @" SELECT tsp.ServerID, Count(*) AS CountPlayers, SUM(tps.Score) AS SumScore, AVG(tps.Score) AS AvgScore, SUM(tps.Kills) AS SumKills,  AVG(tps.Kills) AS AvgKills, SUM(tps.Headshots) AS SumHeadshots,
                                                        AVG(tps.Headshots) AS AvgHeadshots, SUM(tps.Deaths) AS SumDeaths, AVG(tps.Deaths) AS AvgDeaths, SUM(tps.Suicide) AS SumSuicide, AVG(tps.Suicide) AS AvgSuicide, SUM(tps.TKs) AS SumTKs, AVG(tps.TKs) AS AvgTKs,
                                                        SUM(tps.Playtime) AS SumPlaytime, AVG(tps.Playtime) AS AvgPlaytime, SUM(tps.Rounds) AS SumRounds, AVG(tps.Rounds) AS AvgRounds FROM " + this.tbl_playerstats + @" tps
                                                        INNER JOIN " + this.tbl_server_player + @" tsp ON tps.StatsID = tsp.StatsID
                                                        WHERE tsp.ServerID = _ GROUP BY tsp.ServerID";

Needed the general reference to the table name (" + this.tbl_server_player + @" for instance) instead of the rigid table name since I am using table suffixes.

 

The serverstats %variables% are working now that I fixed that query.

 

For the %playerDeaths% issue:

Code:

Top10Row.Replace("%playerDeaths%", row[3].ToString()).Replace("%playerHeadshots%", row["Headshots"].ToString());

The ' % ' in %playerDeaths% were missing.

[ImportBot]

Originally Posted by asra1l*:

 

it looks like your plugin is only for local procon installations,

 

 

well is it possible to have a version for hosted procon layers?

 

i only need a text-log-kinda thing, no fancy database.

preferably with custom reset/overwrite rules.

 

i would donate via paypal for it!

pretty pleees

[ImportBot]

Originally Posted by XpKiller*:

 

Changelog:

[0.0.1.3beta]

The plugin now uses threads for db request this should avoid the procon laggs

Fixed SQL querys and serverstats Thx ty_ger07 for report

 

@asra1l

This is a plugin for Mysql DB.

Many Hoster offer a MySQL DB. So i dont will make such an option for this plugin.

You Request would be a complete new plugin.

If you need such an plugin post a request in the plugin forum.