Post Reply
Thread Rating:
  • 1 Votes - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Guide How to setup DotA OpenStats with Garena HostBot v6.0
14-Feb-2012, 08:52 PM (This post was last modified: 04-Mar-2012 10:32 PM by GarenaHack-er.)
Post: #1

Thread: How to setup DotA OpenStats with Garena HostBot v6.0

[Image: 65780879k.jpg]

DotA OpenStats is MySql based web statistic site for DotA games. MySQL. Data is updated automatically after every game ends. Everything is sortable. Top player statistics. Templates.

Live Demo here: http://openstats.iz.rs/

Features :
Spoiler:
  • Content Managment System
  • Template system
  • Top player statistics.
  • Country Flags
  • Adjustable scoring system.
  • Optimized queries.
  • Ajax.
  • List banned players.
  • List admins.
  • Players can create signatures
  • Everything is sortable.
  • User Achievements
  • Updated automatically
  • ACP: site configuration, manage bans, items, heroes, add news, manage games, delete "broken" and short games

To install it and make it work with Garena HostBot v6.0 you need to:

1) Install and configure a web server and MySQL or set up your hosted website.

Download and install WAMP - http://www.wampserver.com - a http and mysql server for Windows

(Optional) Set up DynDNS
Spoiler:
DynDNS is a free service that gives your IP address it's own domain name.
They have a tray program that can automatically update their site with your IP address.
If you don't do this, in order for outsiders to view your website, they will have to know
your IP address.
Avaliable at: http://www.dyndns.com/

2) Copy DotA OpenStats into your web folder.

Download DotA OpenStats v1.3.9 from here: http://www.mediafire.com/?171l2vxehy0djyh (or from the home page, but this is already updated for dota 6.73), and extract the files into the "www" folder of you Wamp directory, default is : C:\wamp\www.

3) Import the appropriate database schema file into your MySQL database

Navigate to PHPMyAdmin (by default at http://localhost/phpmyadmin, or click in the tray for phpmyadmin)
  • Create a GHost database if you haven't already
  • Select your GHost database on the left
  • Select the import tab
  • Click choose file and select the included SQL setup file:
    mysql_create_tables_v2.3one.sql - from the Garena HostBot v6.0 install folder
    MySQLSetup_V2.sql and optimizeMySQL.sql - they are both found in the DOC folder of Dota OpenStats
  • Click Import


4) Edit config.php for your settings - found in the DotA OpenStats home directory

Setup your db configuration:
  • $server - Your server, default "localhost" (If using remote computer than IP of the remote computer)
  • $username - Your DB username
  • $password - Your DB password
  • $database Your DB table

5) Setup admin username and password:

In ../DEV/config.cfg edit your admin username and password. Default is: test - 123456
Spoiler:
Navigatate to http://YOUR_DOTA_OS/DEV and enter your admin username and password to login.
There are 3 user access levels.
ADMINISTRATORS have all privilegies.
MODERATORS can manage bans and add news.
PUBLISHER can only add news.
Read instructions in /DEV/config.cfg folder how to setup different user access level

6) Configure Garena HostBot v6.0 to use the MySql database.

Setup your db configuration (HostBot options -> Page 4):
  • Select the database type as MySql
  • $server - Your server, default "localhost" (If using remote computer than IP of the remote computer)
  • $username - Your DB username
  • $password - Your DB password
  • $database Your DB table

[Image: ghbn.png]


After this all the statistics from Garena HostBot v6.0 will be updated in this database and you can access it on Localhost (http://localhost/). This MySql database is compatible with !sd and dota_elo matchmaking system.

If you want to convert your old sqlite3 database to MySql please read this post: http://www.garenaworld.com/Thread-How-to...1#pid23201


Attached File(s) Thumbnail(s)
               
[Image: hotlink.jpg]
Visit this user's website Find all posts by this user
Add Thank You Quote this message in a reply
[-] The following 4 users say Thank You to GarenaHack-er for this post:
DarkSupremo (03-11-2012), greenaz (02-06-2013), Pocket.Diamond (25-04-2014), ¶§Ç (16-09-2013)
14-Feb-2012, 10:59 PM
Post: #2
RE: How to setup DotA OpenStats with Garena HostBot v5.0
Thanks for the tutorial, but i think i will still using the old SQLite database because it's easier. Smile
[Image: davilex.jpg][Image: davilex.png]
Find all posts by this user
Add Thank You Quote this message in a reply
16-Feb-2012, 10:14 PM
Post: #3
RE: How to setup DotA OpenStats with Garena HostBot v5.0
don't understand

Quote:3) Import the appropriate database schema file into your MySQL database

Navigate to PHPMyAdmin (by default at http://localhost/phpmyadmin, or click in the tray for phpmyadmin)
Create a GHost database if you haven't already
Select your GHost database on the left
Select the import tab
Click choose file and select the included SQL setup file:
mysql_create_tables_v2.3one.sql - from the Garena HostBot v5.0 install folder
MySQLSetup_V2.sql and optimizeMySQL.sql - they are both found in the DOC folder of Dota OpenStats
Click Import

plz give detailed instruction, thx ...
Find all posts by this user
Add Thank You Quote this message in a reply
17-Feb-2012, 05:55 AM
Post: #4
RE: How to setup DotA OpenStats with Garena HostBot v5.0
Is there any way how to convert "old" stats to openstats? Ive got it all running but i dont want start over with 0 games...
Find all posts by this user
Add Thank You Quote this message in a reply
17-Feb-2012, 07:40 AM
Post: #5
RE: How to setup DotA OpenStats with Garena HostBot v5.0
what host can setup dota open stat?
Find all posts by this user
Add Thank You Quote this message in a reply
17-Feb-2012, 09:42 AM (This post was last modified: 17-Feb-2012 09:45 AM by GarenaHack-er.)
Post: #6
RE: How to setup DotA OpenStats with Garena HostBot v5.0
(16-Feb-2012 10:14 PM)DzhiM Wrote:  don't understand

plz give detailed instruction, thx ...

You have 3 sql files (that contain commands) and you need to import them to your database. Click import and select these files.

(17-Feb-2012 05:55 AM)salda Wrote:  Is there any way how to convert "old" stats to openstats? Ive got it all running but i dont want start over with 0 games...

You can export your old database to a sql file(s) (make sure before you applied the server="Garena" patch as shown in the main ghb post, or apply it after) then import them to your new database.

(17-Feb-2012 07:40 AM)longhaitac Wrote:  what host can setup dota open stat?

You can host it on your home computer (or a windows vps) but you need first Wamp installed.
[Image: hotlink.jpg]
Visit this user's website Find all posts by this user
Add Thank You Quote this message in a reply
[-] The following 1 user says Thank You to GarenaHack-er for this post:
c0m3 (18-02-2012)
17-Feb-2012, 03:36 PM (This post was last modified: 17-Feb-2012 04:31 PM by salda.)
Post: #7
RE: How to setup DotA OpenStats with Garena HostBot v5.0
Sorry probably my question was not clear. I want to convert my old sqlite3 database to mysql. Is there any noobproof way? Smile

When I use the code mentioned in main thread(Update admins SET server="Garena" etc...) - it is ok first. But when I close db and open again there is no server colmumn or row...
Find all posts by this user
Add Thank You Quote this message in a reply
[-] The following 1 user says Thank You to salda for this post:
c0m3 (18-02-2012)
17-Feb-2012, 04:39 PM
Post: #8
RE: How to setup DotA OpenStats with Garena HostBot v5.0
(17-Feb-2012 03:36 PM)salda Wrote:  Sorry probably my question was not clear. I want to convert my old sqlite3 database to mysql. Is there any noobproof way? Smile

When I use the code mentioned in main thread(Update admins SET server="Garena" etc...) - it is ok first. But when I close db and open again there is no server colmumn or row...

Run those queries because there is a server column, just that after you close and re-open it's hidden Smile You can see it in phpmyadmin or with a sqlite browser like: "SQLite Database Browser".
[Image: hotlink.jpg]
Visit this user's website Find all posts by this user
Add Thank You Quote this message in a reply
[-] The following 1 user says Thank You to GarenaHack-er for this post:
c0m3 (18-02-2012)
17-Feb-2012, 04:47 PM (This post was last modified: 17-Feb-2012 05:01 PM by GarenaHack-er.)
Post: #9
RE: How to setup DotA OpenStats with Garena HostBot v5.0
To convert old Sqlite3 database to MySql you need to do the following:

1. Select Sqlite3 as database for GHB then go to the "Database" tab and click "Open Database"
2. Select the bans table (or what table you want to export) then click the "Import or export bans to XML" button
3. Click in the new window the "Export bans from ghost to XML" and in the GHB folder installation a file called ghost.xml will be created with your bans

4. Now close the database and select in options MySql as your database type
5. Go to the "Database" tab, select the "Bans" table and click "Import or export bans to XML" button
6. Where it says "WC3 Banlist Database File" click and select the previous ghost.xml file created from your GHB install folder.
7. Click "Import bans from XML" button then to add them to your database click "Add imported bans to ghost". Now exit and close and re-open your database and the bans will be there.

Don't forget to apply the server patch (in sqlite3 or mysql) if your bans are in an older version then 5.0 of GHB
Code:
Update admins SET server="Garena";
Update bans SET server="Garena";
Update games SET server="Garena";
Update safelist SET server="Garena";
Update scores SET server="Garena";
[Image: hotlink.jpg]
Visit this user's website Find all posts by this user
Add Thank You Quote this message in a reply
[-] The following 1 user says Thank You to GarenaHack-er for this post:
c0m3 (18-02-2012)
17-Feb-2012, 07:10 PM
Post: #10
RE: How to setup DotA OpenStats with Garena HostBot v5.0
bro, i need your help, yes my english very bad, but you must undarstand me.

i can't set the wamp program, plz give some detailed instructions... i don't undestand, where i must copy
mysql_create_tables_v2.3one.sql MySQLSetup_V2.sql and optimizeMySQL.sql ??
Find all posts by this user
Add Thank You Quote this message in a reply
[-] The following 1 user says Thank You to DzhiM for this post:
c0m3 (18-02-2012)
Post Reply



Related Threads

Thread: Author Replies: Views: Last Post
[Tool] 
Garena HostBot v6.0 - for Garena Plus - with League Mode
GarenaHack-er 203 157,743 04-Aug-2014 04:15 PM
Last Post: bingtaiilaizawn
[TUTORIAL]How to use Garena Hostbot
hellnano 154 210,525 30-Mar-2014 12:10 PM
Last Post: NeutraL
Garena Hostbot, how to load autosave game?
wingly113 6 3,173 09-Mar-2014 04:09 PM
Last Post: dreed
[Guide] 
How to remove credits from ghb (This game is hosted with Garena Hostbot 6.0 ...)
GarenaHack-er 13 1,461 13-Jan-2014 05:42 PM
Last Post: dragonlord06
[Question] 
Other people cant join me when i use Garena HostBot v6.0
Aditya Jambhalikar 1 681 02-Dec-2013 02:34 PM
Last Post: GarenaHack-er



User(s) browsing this thread: 1 Guest(s)
Contact Us Terms of Use - Rules Privacy Policy DMCA disclaimer Mobile Version RSS Syndication Return to Content Return to Top