Skip to content

Django app created for Tibia players to provide as many statistics and tools as possible.

Notifications You must be signed in to change notification settings

jakubg89/tibia_stats

Repository files navigation

About

The Tibia game tracking application allows users to monitor their progress in the game, including their character level, acquired experience and charm points. Users can also track boss information such as respawn time on all game worlds. All this information is stored in a MySQL database and presented in a clear and easy to interpret manner using Charts.js data visualization library. The application is built with a Python Django backend and a Bootstrap, HTML5, CSS3 and JavaScript frontend, making it easy to use the tools and analyze their Tibia game results.

Features

  1. Worlds information.
    • Basic information.
    • Online time counter.
  2. Character information.
    • Basic information.
    • World transfers.
    • Name changes.
  3. Experience change list.
    • Mainland.
    • Rookgaard.
  4. Charm change list.
    • Mainland.
    • Rookgaard.
  5. Character bazaar statistics.
    • Monitoring active auctions.
    • History of finished auctions.
    • Price statistics.
  6. Boss information.
    • Boss list.
    • Boss statistics.
  7. Calculators.
    • Training calculator.
    • Loot calculator.
    • Stamina calculator.

Stack

Back-end: Django, Python

Database: MySQL

Front-end: HTML5, CSS3, Bootstrap, JavaScript

Installation

The installation manual includes all the necessary steps, including configuring the MySQL database, downloading all required libraries and modules and starting the application server. After installation is complete and the server is up and running, the application will be available for use via a web browser on your own computer.

Check your python version by typing python --version To run application you need python 3.10

Download repository and extract files.

.env

  • Create .env file in directory tibia_stats
  • Paste following code with needed information:
DSN= your sentry information
SECRET_KEY= your secret key
DEBUG=False
ALLOWED_HOSTS=localhost 127.0.0.1
DB_NAME=tibia_stats
DB_USER= your db user name
DB_PASSWORD= password to your database
DB_HOST=127.0.0.1
DB_PORT=3306

Prepare environment

  • Update pip python -m pip install -U pip
  • Install virtual environment pip install virtualenv
  • Create your virtual environment python -m venv your_virtual_environment_name
  • Activate virtual environment source /path_to/your_virtual_environment/bin/activate
  • Install requirements from file pip install -r setup-requirements.txt

MySQL

  • Create database tibia_stats

Django

Create demo project to obtain SECRET_KEY for your app

  • Create project django-admin startproject demo
  • Navigate to settings.py of your demo project and copy your SECRET_KEY to .env file.
  • Navigate to directory with manage.py
  • Make migrations python manage.py makemigrations
  • Migrate python manage.py migrate
  • Run server python manage.py runserver

You can now access app by opening http://127.0.0.1:8000/ in your browser.