Thibaud-DT / trinitycore-models by thibauddt

Eloquent Models for TrinityCore database

154

Package Data
Maintainer Username:	thibauddt
Maintainer Contact:	thibaud@d-t.fr (Thibaud DELOBELLE TOUSSAINT)
Package Create Date:	2016-12-21
Package Last Update:	2019-06-29
Language:	PHP
License:	GPL-3.0
Last Refreshed:	2024-05-03 03:06:44

Package Statistics
Total Downloads:	154
Monthly Downloads:	0
Daily Downloads:	0
Total Stars:	0
Total Watchers:	1
Total Forks:	3
Total Open Issues:	1

TrinityCore Eloquent Models

Eloquent Models of TrinityCore 3.3.5 Database.

TrinityCore Database has any relationship between tables. Morever it's split on 3 differents databases : auth, characters and world

Requirements

PHP >= 5.5.9 || 7.0

Installation

composer require thibaud-dt/trinitycore-models

Add database connection in you config/database.php

'connections' => [

        [...]

        'characters' => [
            'driver'    => 'mysql',
            'host'      => env('DB_HOST_CHARACTERS', 'localhost'),
            'database'  => env('DB_DATABASE_CHARACTERS', 'forge'),
            'username'  => env('DB_USERNAME_CHARACTERS', 'forge'),
            'password'  => env('DB_PASSWORD_CHARACTERS', ''),
            'charset'   => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'prefix'    => '',
            'strict'    => false,
        ],

        'world' => [
            'driver'    => 'mysql',
            'host'      => env('DB_HOST_WORLD', 'localhost'),
            'database'  => env('DB_DATABASE_WORLD', 'forge'),
            'username'  => env('DB_USERNAME_WORLD', 'forge'),
            'password'  => env('DB_PASSWORD_WORLD', ''),
            'charset'   => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'prefix'    => '',
            'strict'    => false,
        ],

        'auth' => [
            'driver'    => 'mysql',
            'host'      => env('DB_HOST_AUTH', 'localhost'),
            'database'  => env('DB_DATABASE_AUTH', 'forge'),
            'username'  => env('DB_USERNAME_AUTH', 'forge'),
            'password'  => env('DB_PASSWORD_AUTH', ''),
            'charset'   => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'prefix'    => '',
            'strict'    => false,
        ]

        [...]

    ],

Add variable in your .env and configure it

DB_HOST_WORLD=localhost
DB_DATABASE_WORLD=world
DB_USERNAME_WORLD=root
DB_PASSWORD_WORLD=root

DB_HOST_CHARACTERS=localhost
DB_DATABASE_CHARACTERS=characters
DB_USERNAME_CHARACTERS=root
DB_PASSWORD_CHARACTERS=root

DB_HOST_AUTH=localhost
DB_DATABASE_AUTH=auth
DB_USERNAME_AUTH=root
DB_PASSWORD_AUTH=root

It's done ! You can now use the package

Usage

All models can be use like a Eloquent Model.

TODO

Write relationships of all tables.. A lot of work to do ! You can help me with pull request ;)

Credits

The community of TrinityCore for the awesome work !