[BF4] Stats webpage for XpKiller's Stats Logger Plugin

[ImportBot]

Originally Posted by swats73*:

 

Error!

 

WebPage

 

 

 

PROCON

had this message before with my DB hosted on fragnet I just submitted a ticket asking them to flush the DB and has been fine since.

[ImportBot]

Originally Posted by HitchItch*:

 

Ok, Thanks so much for this topic

I am trying to get a stats page up, reading through the op, most of the instructions are pretty straight foward expect for the first step

 

"Download the following file:

https://github.com/tyger07/BF4-Serve...zipball/master

 

Extract the files."

 

Where am I downloading this to?

 

I created a openweb account but cannot upload anything to it

[ImportBot]

Originally Posted by ty_ger07*:

 

Where am I downloading this to?

You download it and put it on your website. If you don't have a website, you will need to buy website hosting from some web server provider who offers a modern php environment and database support.

[ImportBot]

Originally Posted by HitchItch*:

 

Thanks, i just figured that out. We do have a website host with SQL

my only problem now is inputting the proper info for the following

 

DEFINE('HOST', '100.200.300.400'); // database host address IS THIS OUR WEBSITE IP?

 

In Procon plugin:

Host- IS THIS OUR WEBSITE IP?

Database name- IS THIS THE NAME OF THE DATABASE I CREATED?

UserName- MY USERNAME FOR MY SQL?

[ImportBot]

Originally Posted by HitchItch*:

 

Getting the following error when i load our webpage

 

Error: Access denied for user 'otckilli_user'@'%' to database 'otckilli_server_stats'

 

the database name is correct as well as the user and password. I created a user and a password just for this.

[ImportBot]

Originally Posted by ty_ger07*:

 

DEFINE('HOST', '100.200.300.400'); // database host address

IS THIS OUR WEBSITE IP?

The database host address. It is the IP address of the database. If the database is at the same location as the website, the host may be localhost instead of an IP address.

Host- IS THIS OUR WEBSITE IP?

The database host address.

Database name- IS THIS THE NAME OF THE DATABASE I CREATED?

Yes, the database name.

UserName- MY USERNAME FOR MY SQL?

Yes, the database user name.

 

Everything is about the database for both the plugin and the stats webpage.

[ImportBot]

Originally Posted by HitchItch*:

 

Works Great, You guys are the best, Only real stumble was getting a user name and password that worked. was getting User Access Denied.

 

Now to change up the images

[ImportBot]

Originally Posted by khalane*:

 

Hello, I have a problem with the overview webpage, i have this error message:

 

I installed the file, on the area of my team website (hosted ovh), as you can see here: tyger07… directory

 

In tyger07…, I opened the "config" directory:

 

In this config directory, I modified the file "config.php"

 

Here is how I configured:

 

The SQL database : db4free.net base (hosted by db4free.net) the following plugins work fine with this SQL database :

-Stats And MapStats Logger [1.0.0.2]

-AdKats [6.5.0.0]

Why I have this error message?

 

Thank you in advance ...

[ImportBot]

Originally Posted by ty_ger07*:

 

For one thing, your stylesheet is all messed up. I have to wonder why. The background color, missing background image, and text color in the error message is not normal.

 

Instead of using 'db4free.net', try using db4free.net's IP address so that you can avoid DNS issues.

 

Other than that, I have no idea why your website is not able to connect to db4free.net. You might want to ask db4free.net why. Perhaps there were too many unsuccessful attempts or too many attempts within a short period of time and db4free.net blocked your website address.

[ImportBot]

Originally Posted by khalane*:

 

Thank you very much for the quick response and for your Webpage overview ! And thank you to the community and all plugin developers (they work well) !

For the style sheet, I did not touch anything, I just put the login info in the config.php file.

Thank you for your reply ; I'll look in those directions, I'll let you know...

[ImportBot]

Originally Posted by khalane*:

 

When i put : 'host', 'db4free.net:3306' i have this :

 

It is the right style sheet ?

[ImportBot]

Originally Posted by HitchItch*:

 

Got the stats working, its keeping the players stats but

Some of the players are being listed twice, myself included

I am listed #20 and #25 yet my score/stats are identical, we have other players with double listings Any idea?

20 Hitch_Itch 86469 214 1.15 5.61 %

25 Hitch_Itch 86469 214 1.15 5.61 %

 

take a look if you wish to - http://otckillingtime.com/index.php_p=leaders&sid=1

[ImportBot]

Originally Posted by ty_ger07*:

 

Got the stats working, its keeping the players stats but

Some of the players are being listed twice, myself included

I am listed #20 and #25 yet my score/stats are identical, we have other players with double listings Any idea?

20 Hitch_Itch 86469 214 1.15 5.61 %

25 Hitch_Itch 86469 214 1.15 5.61 %

 

take a look if you wish to - http://otckillingtime.com/index.php_p=leaders&sid=1

I don't see the issue. I think you probably saw the issue due to caching. It looks like the problem cleared up on its own.

[ImportBot]

Originally Posted by HitchItch*:

 

Thanks I will keep an eye on it

[ImportBot]

Originally Posted by )RAG()N*:

 

I got this working 2days ago but the map stats graphs not working anyone had that problem ?

Or will it show up once there is more stats ?

[ImportBot]

Originally Posted by ty_ger07*:

 

I got this working 2days ago but the map stats graphs not working anyone had that problem ?

Or will it show up once there is more stats ?

I need more information. Are map stats enabled? Are there map stats being displayed? Is it only the image which isn't working? Has anyone played in your server since you got the stats working?

[ImportBot]

Originally Posted by GvnrRickPerry*:

 

Hello sir,

 

We (AK907) are in the process of upgrading the webstats page. We've been using a fairly modified version of the webstats to suit our needs, and it has been working great! You are an awesome coder, and I really love the style of the webstats.

 

My problem is we recently started using a 70 slot Hardline server. I've been working on getting everything setup, but for some reason the webstats only shows 2 servers. Both of which are our older BF4 servers. I would love it to show our BF Hardline server. Is there something that needs to happen for the webstats to show the Hardline servers versus the BF4 servers?

 

I've been trying to research this, but am not coming across too much. I'd love to have some other input!

 

The half-working page is available at:

http://battlefield.ak907.net/

 

We've still got some modifying to do in order to get things working properly - right now, I just want the Hardline server to show up in the server list drop down, or any server list!

 

Thanks!

-Gvnr

 

EDIT:

I am able to query the database (SELECT * FROM tbl_server) and the new Hardline server shows up there, just not the web stats. I am starting to think it's something our web programmer did and nothing to do with the database or your version of webstats... Going to try to get him in here ASAP.

[ImportBot]

Originally Posted by ty_ger07*:

 

My problem is we recently started using a 70 slot Hardline server. I've been working on getting everything setup, but for some reason the webstats only shows 2 servers. Both of which are our older BF4 servers. I would love it to show our BF Hardline server. Is there something that needs to happen for the webstats to show the Hardline servers versus the BF4 servers?

My web stats code only selects BF4 servers because of what is in ./common/connect.php.

 

https://github.com/tyger07/BF4-Serve...on/connect.php

 

It says:

...

// first we need to find the GameID of BF4

// note: WHERE `Name` = 'BF4'

// change 'BF4' to other game name if you want to try to modify this code to work with another game

$Server_q = @mysqli_query($BF4stats,"

SELECT `GameID`

FROM `tbl_games`

WHERE `Name` = 'BF4'

");

You would have to do something like WHERE `Name` = 'BF4' OR `Name` = 'BH' (or whatever abbreviation Battlefield Hardline shows up in the database as).

 

I would advise that it is easier to make two separate versions of the stats page in different directories. Otherwise, it might be difficult to properly match the rank images, weapon images, backgrounds, text, and so forth to display properly depending on the game being viewed.

[ImportBot]

Originally Posted by )RAG()N*:

 

I need more information. Are map stats enabled? Are there map stats being displayed? Is it only the image which isn't working? Has anyone played in your server since you got the stats working?

Yes map stats are enabled.

 

its showing the maps that has been played,

 

the only image that isn't working is the Map stats pie graph at the top.

 

I have just had a look at the error log file

 

PHP Fatal error: Call to undefined function imagettfbbox() in /common/pchart/class/pImage.class.php on line 211

 

this is whats on line 211

 

Code:

$coords = imagettfbbox($FontSize, 0, $FontName, $Text);

[ImportBot]

Originally Posted by GvnrRickPerry*:

 

My web stats code only selects BF4 servers because of what is in ./common/connect.php.

 

https://github.com/tyger07/BF4-Serve...on/connect.php

 

It says:

 

 

You would have to do something like WHERE `Name` = 'BF4' OR `Name` = 'BH' (or whatever abbreviation Battlefield Hardline shows up in the database as).

 

I would advise that it is easier to make two separate versions of the stats page in different directories. Otherwise, it might be difficult to properly match the rank images, weapon images, backgrounds, text, and so forth to display properly depending on the game being viewed.

Thank you, ty_ger07. I guess we will have to wait until the dev gets this one, because we are using an older version of webstats and it doesn't have the connect.php file.

 

I am going to try to copy over the update again and see if it will work, but I don't know if it will.

 

Thank you!

-Gvnr

 

I got her to work using the abbreviation 'BFHL' but it only does whichever one is first. It seems the rest of the statement just doesn't execute or work if I use the "OR" command.

 

For example, I changed the line to this:

Code:

WHERE `Name` = 'BFHL' OR 'BF4'

and Hardline shows up when I refresh the page. If I change the line to this:

Code:

WHERE `Name` = 'BF4' OR 'BFHL'

then only BF4 shows up. It doesn't want to do both of them for some reason. Got any ideas good sir?

Thanks,

-Gvnr

 

Second note:

 

Looks like none of the images work for HL either. I didn't expect weapons to, but none of the normal stuff works either like signatures, server banners, and a few others. Oddly enough, some of the vehicles "coins" show up and some of the weapons do too - like the grenades for example.

[ImportBot]

Originally Posted by ty_ger07*:

 

For example, I changed the line to this:

Code:

WHERE `Name` = 'BFHL' OR 'BF4'

Code:

WHERE `Name` = 'BF4' OR 'BFHL'

Ummm, as I said...

 

WHERE `Name` = 'BF4' OR `Name` = 'BFHL'

 

 

But, as I said, you would be best off making them two separate pages in different directories of your server. It would be messy otherwise.

 

Looks like none of the images work for HL either. I didn't expect weapons to, but none of the normal stuff works either like signatures, server banners, and a few others. Oddly enough, some of the vehicles "coins" show up and some of the weapons do too - like the grenades for example.

Yup, that is to be expected.

[ImportBot]

Originally Posted by GvnrRickPerry*:

 

But, as I said, you would be best off making them two separate pages in different directories of your server. It would be messy otherwise.

 

Yup, that is to be expected.

I will give that a shot to see what happens - thank you!

 

I didn't know if you had been testing with Hardline or anything, so just trying to give a little report. If you need, or would like, any help with getting webstats to work with Hardline, let me know. I don't know a whole lot, but I have a dev in the clan that took what you had and grew on it. We were trying to setup an advanced query, but I don't think it will ever work like we had wanted because of things not being logged to the database. I'd be more than happy to do what I can to help, and try to get my dev involved too if you are interested!

 

Thank you, again,

-Gvnr (http://www.linkedin.com/in/duanemizell/en)

[ImportBot]

Originally Posted by knownchild*:

 

I have a general question, in order to get both of my servers to show up in the server drop down do i just point both of the servers xpKillers stats logger plugin's to the same sql database?

[ImportBot]

Originally Posted by ty_ger07*:

 

Yes

[ImportBot]

Originally Posted by swats73*:

 

am a total noob with code but have set up a page for the hardline servers but what part of it do I need to chanfe to get the Join button to stop looking at BF4 and link to the Hardline website?

 

http://uwg.webfrag.net/hardline/index.php

[ImportBot]

Originally Posted by ty_ger07*:

 

You are using some ancient code there. I don't even remember any more how that code was structured or where that link is. I do know that this is the source of your problem though: "...battlefield.com/bf4/servers/pc/...".

Why not update your code to the current version?

[ImportBot]

Originally Posted by swats73*:

 

the old stats page I found is easier to keep updated.... us old gits have trouble remembering stuff =D

 

will give the new one a try though

[ImportBot]

Originally Posted by )RAG()N*:

 

Yes map stats are enabled.

 

its showing the maps that has been played,

 

the only image that isn't working is the Map stats pie graph at the top.

 

I have just had a look at the error log file

 

PHP Fatal error: Call to undefined function imagettfbbox() in /common/pchart/class/pImage.class.php on line 211

 

this is whats on line 211

 

Code:

$coords = imagettfbbox($FontSize, 0, $FontName, $Text);

anyone got any ideas how to fix this?

[ImportBot]

Originally Posted by ty_ger07*:

 

PHP Fatal error: Call to undefined function imagettfbbox() in /common/pchart/class/pImage.class.php on line 211

anyone got any ideas how to fix this?

You are probably using an old version of PHP which doesn't include GD or else simply don't have GD installed on your server for one reason or another.

 

http://php.net/manual/en/book.image.php

[ImportBot]

Originally Posted by )RAG()N*:

 

You are probably using an old version of PHP which doesn't include GD or else simply don't have GD installed on your server for one reason or another.

 

http://php.net/manual/en/book.image.php

oh ok I don't know anything about that,, So if I contacted my server host I should ask to get it updated ?