next »

[Huhwut]

I recently installed B3 and it is working perfectly fine.

Now I want my registered users be able to view their stats/awards online.

How do i get my website having access to the db??

Xlrstats is working fine too, I only need to know how to link it to my domain.

So if there is a guide for it, please link me.

For now I am following this guide: http://www.xlrstats.com/site/?q=node/1

I downloaded all needed packages, but just do not know how to link it to my website.

Thanks in advance


Kind regards

[Garreth]

Where do you have your database installed (local computer/somewhere in the internet)?
Where do you have webserver where you want to install xlrstats webfront (local computer/somewhere in the internet?)

In general, if you are following the guide on the website, in Step 1 of the installation you are providing the login/db name/db password/db address to the webfront. You need to provide correct information here (this data should point to the BBB database), as this is the moment, where you are linking the stats generated by BBB with your website.

[Huhwut]

Everything is somewhere in the internet.

I uploaded it to my website and if i open the xlrstats folder the install-shield from xlrstats appears. So I assume everything gone well so far.

But if i enter my database-info, it spits out the message:
"Cant connect to the database"

I actually do not get that point (from readme.txt):
4. Copy/rename the file ./config/statsconfig-distro.php to
./config/statsconfig.php and edit it to fit your server settings

I edited this file, therefore I noticed there is no status.xml in it, so where do I have to place it?

description from statsconfig.php:
// This is the path where B3 stores the status.xml file. May be an absolute path or an URL. (Use forward slashes / only!)
// ie.: /var/www/status/status.xml or http://www.yourwebsite.com/status/urt1.xml

Do I need to create a new folder called status and place the status.xml in it?

To now I only have the folders which were included in the package I downloaded by following the instruction of the guide (containing 3 folders: "b3-plugins", "sql" and "xlrstats").

And also, do I have to use GeoIP or can I just use the value "0", to disable it?

Sorry for my stupidity and thanks for your patience and help.

[Garreth]

If your website and your database are on separate servers, you have to make sure that the database accepts incoming connections from the website. To check it easily, download Navicat (free version is more then enough), and try to connect to the BBB database from your computer using this tool, and the login data that you use while configuring xlrstats webfront.


Status.xml file is generated automatically by BBB plugin called status, which comes in package with the BBB. In it's config file (plugin_status.xml) you need to specify where to upload the status.xml file.
The best way, is to upload this file somewhere to the ftp of the webserver. The path is really not important, you can make it in the root folder of your webserver, but I'd suggest creating it just in the folder of the xlrstats.


You don't have to use geoIP and 0 disables it. However it's quite simple to install it, so reconsider:) With geoIP, you have country flags near people on the webfront, it looks nice, especially if you have many users on public server. In case of any troubles with it, I'll help you.

And you don't have to be sorry, this time I'm trying to help you, and in some time you will be helping others probably:) I'm just glad, that you describe your problem in details, so it's easier to answer.

[Huhwut]

Many thanks Garreth, I wish there were a like-button.

There might be some problems regarding the webspace I use, I'll have a new one on monday, so please don't lock this.

I'll get back to you on monday.