Keira2: the TrinityCore Database Web Editor (cross-platform)

TrinityCore Development TrinityCore Code Discussion
1

This software is a Database Editor web application for the TrinityCore MMORPG framework built with AngularJS and using the TrinityCore JSON RESTful API to retrieve database data.

Keira2 allows the user to edit the database via GUI and generates automatically the SQL code for him/her. It is inspired by the old Quice/Truice database editor, originally developed by indomit, and by the Discover-'s SAI Editor.

Using Keira2, you can edit SmartAI, Quests, Creatures, Spawns, Loots, GameObjects, Items, Characters, etc…

Also you can change the GUI style choosing a different graphic theme using the theme-switcher button. There are several themes, light and dark ones.

[SIZE=18px]https://github.com/Helias/Keira2[/SIZE]

http://shinworld.altervista.org/images/keira2/Keira2.png

Live demo

A live demo is available here. You can use it for production but be aware that its database may not be updated to the latest version.

Also you can help us by testing the development version without installing it, simply using our development live demo. Remember to clear your browser cache before testing it and report any bug or suggestion.

Installation

Keira2 fetches data from an istance of the TrinityCore JSON API, it can be installed either on the same machine or on an external one.

You can install an istance of the TrinityCore JSON API using this guide.

Once you have installed the API, download the latest release of Keira2 and extract the Keira2 folder and place is inside your web server directory (e.g. /var/www/).

Then open the Keira2 folder and copy the file config.js.dist to config.js, open it and set it properly with the path of the API:

app.api = “…/TC-JSON-API/public/index.php/”;

replace "../TC-JSON-API/public/index.php/" with the path of your API istance.

If you have the TrinityCore JSON API on an external machine, you should set it like:

app.api = “http://www.your.external.server.org/path/to/TC-JSON-API/public/index.php/”;

[B]Contribute[/B]

[ul][li]You can help us even without installing your own Keira2 instance by testing our development live demo.[/li]
[li]Report any bug or suggestions by opening a new issue.[/li]
[li]Check our documentation to understand how the source is structured.[/li]
[/ul]
License

Keira2 is open-sourced software licensed under the GNU AGPL license.

Future plans:

  • Authentication end query execution

  • … post your ideas!

More Screenshots:

Spoiler

http://shinworld.altervista.org/images/keira2/Keira2-2.png

http://shinworld.altervista.org/images/keira2/Keira2-3.png

http://shinworld.altervista.org/images/keira2/Keira2-4.png

http://shinworld.altervista.org/images/keira2/Keira2-5.png

http://shinworld.altervista.org/images/keira2/Keira2-themes.png

http://shinworld.altervista.org/images/keira2/Keira2-themes2.png

http://shinworld.altervista.org/images/keira2/Keira2-themes3.png

2

UPDATE: Released Keira 2.1.0

Changelog:

[ul]
[li]Implemented SmartAI Editor (inspired and partially based on Discover-'s SAI Editor)[/li][li]Improved & rewritten most Modals[/li]
[li]Improved Query Builder[/li]
[li]Improved SQL output display[/li]
[li]Fixed all numeric conversion issues of values[/li][li]Minor View improvements[/li][li]Several global improvements[/li][/ul]
Notes:

[ul]
[li]Requires TrinityCore JSON API v0.4 or newer[/li][li]This is a major release, any additional minor changes will be released on next 2.1.x versions[/li][li]A lot of features already work for 6.x game version, we plan to full support it on 2.2.x release[/li][/ul]

I want to thank Discover- for having assisted me in converting his SAI Editor to the web, by answering all my questions, and all guys of the TrinityCore community who helped me by testing Keira2 and reporting bugs/suggestions.
Download: http://community.trinitycore.org/files/file/20-keira2-database-editor/

Alternative Download: https://github.com/Helias/Keira2/releases

Live demo: http://shinworld.altervista.org/Keira2/

[SIZE=14px]Please report ANY bug or suggestion here.[/SIZE]

http://shinworld.altervista.org/images/keira2/Keira2.png

3

UPDATE: Released Keira 2.1.1

Changelog:

[ul][li] Fixed several minor bugs[/li][li] Implemented new modals[/li][li] Implemented automated check for newer version[/li][/ul]
Notes:

[ul][li]Requires TrinityCore JSON API v0.4 or newer[/li][li]This is a minor release[/li][/ul]
Download: http://community.trinitycore.org/files/file/20-keira2-database-editor/

Alternative Download: https://github.com/Helias/Keira2/releases

Live demo: http://shinworld.altervista.org/Keira2/

[SIZE=14px]Please report ANY bug or suggestion here.[/SIZE]

4

Due to some recent changes to the TrinityCore world database structure, the latest Keira2 release (2.1.1) doesn’t fit with latest 3.3.5 TrinityCore.

However, I already updated Keira2 source code to fit with it, so you if you get latest sources version (by cloning both Keira2 and the API from github), you can use Keira2 with latest TrinityCore revision.

Once we ensure that there is nothing broken, we will publish the next release 2.1.2, which will include those changes.

This update pushes Keira2 a step forward the 6.x support, because it makes 3.3.5a database structure a bit more similar to the 6.x one. However, it does not mean the next release will fully support the 6.x game version yet.

5

​thanks

6

Freeze.

Next release will be published soon. Meanwhile you can help us by testing it here and tell us if there is something bugged.

7

UPDATE: Released Keira 2.1.2

[SIZE=14px]Changelog:[/SIZE]

[ul][li][SIZE=14px]Implemented Quest Items tabs for Creature and Gameobject editors[/SIZE][/li]
[li][SIZE=14px]Implemented quest_template_addon table editing[/SIZE][/li]
[li][SIZE=14px]Improved several modals[/SIZE][/li]
[li][SIZE=14px]Improved Gameobject Editor[/SIZE][/li]
[li][SIZE=14px]All table rows are now selectable by click[/SIZE][/li]
[li][SIZE=14px]Improved SAI Editor view for ultra-wide screens[/SIZE][/li]
[li][SIZE=14px]Several minor improvements[/SIZE][/li]
[li][SIZE=14px]Fit with latest TrinityCore DB structure changes[/SIZE][/li]
[/ul]
[SIZE=14px]Notes:[/SIZE]

[ul][li][SIZE=14px]Requires TrinityCore JSON API v0.5 or newer[/SIZE][/li]
[li][SIZE=14px]Latest TDB structure changes made 3.3.5 database similar to 6.x one[/SIZE][/li]
[/ul]

Download: http://community.trinitycore.org/files/file/20-keira2-database-editor/

Alternative Download: https://github.com/Helias/Keira2/releases

Live demo: http://shinworld.altervista.org/Keira2/

Please report ANY bug or suggestion here.

8

Testing and so far so good on IIS 8. Really appreciate your work.

9

Live demo database updated to TDB 335.59

[SIZE=18px]LIVE DEMO[/SIZE]

10

F.Y.I.

Although Keira2 does not fully support 6.x yet, several things already work for 6.x and some people are already using Keira2 for 6.x.

This could be useful for those who are already using Keira2 to work with 6.x/4.3.4 stuff:

If you are working with the Keira2 SmartAI Editor and you need to work with some spells introduced in 4.3.4, just temporarily edit this line of code in your TC-JSON-API instance:

https://github.com/ShinDarth/TC-JSON-API/blob/3.3.5/app/Http/routes.php#L123

and replace:

$results = DB::connection(‘sqlite’)->select(“SELECT * FROM spells_wotlk WHERE ID = ?”, [$id]);with:

$results = DB::connection(‘sqlite’)->select(“SELECT * FROM spells_cata WHERE ID = ?”, [$id]);in /app/Http/routes.php file.

11

Hey guys,

I wanted to test Keira2 and installed/configured the TC-JSON-API.

But when I go to TC-JSON-API/public/index.php I get a white page and no log file is created.

Keira2 says it cannot find the API :confused:

.env is correct

ist’s a windows server, I tried these to for the Keira config.js:

app.api = “…\TC-JSON-API\public\index.php/”;

app.api = “…/TC-JSON-API/public/index.php/”;

any suggestions?

greetings Yaga

12

@YaGa

[COLOR= rgb(82, 82, 82)]But when I go to TC-JSON-API/public/index.php I get a white page and no log file is created.

[COLOR= rgb(82, 82, 82)]If you get white page there, your API is not working so you can’t use Keira2 before fixing it.

[COLOR= rgb(82, 82, 82)]If you are sure that there is no log in …/TC-JSON-API/storage/logs then probably you have to grant the permissions to the directory TC-JSON-API and all its files and subdirectories.

Just try setting 777 to all files and subfolders of the TC-JSON-API, if it works then you will probably want to set all permissions in a proper way.

13

tried to set it to 777 no log is created :confused:

edit: forgot to set the rights recursively… my fault, got it to work properly, thanks!

14

​You’re welcome, I’m glad you wanted to test it. Any kind of feedback is always welcome =)

15

Hello.

First, thanks you for this amazing work!

Is there any solution to add an authentification to API, http auth for example? Because I think it’s not very safe to let free access to api, because anyone can have access to all your datas.

Regards,

et65.

16

Is there any solution to add an authentification to API, http auth for example?

We will work on the authentification for the API in future, now we are working on a new version to support 6.x

17

how to use it on 6.X ?

18

You can test the 6.x versionof Keira here: http://keira2.altervista.org/Keira2-dev/
You can use the follow button to switch the version of Keira
data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAGwAAAAtCAIAAADEABlTAAAAA3NCSVQICAjb4U/gAAAJNklEQVRoQ+2ae1AURx7HZ2Znd3aXXZaXAsEHiA8QYkQIJmqMRi3lLidqjOIlpeYsEzUPY4wHUSQm/qHGi9EY60698/TuIlXGy10oQa2Lii90BdSoHATwBQLLIrvL7rLMzqP7egZFdhlleaRSOaZri9rt/vWvuz/97d90N4NDCDE59YwA0bPqcm2BgAyxF3QgQ5Qh9gKBXnAhK7EXIJIdfThLSkrSVzvuVQMedCyVc6b+UEIQHuLzhth0/nzRO28FhIUPSkxWatUyMi8CFfn5LMtSFNU+3wMi2jPeWPd7/9Aw/379gN3mtvIyxI4EeN4biwdEAIDLaguOCeMdjo6V5ZzHEfBWIgQAY1nhr5x8JuANEVUEHOdzddlQIOD9YEFZ8mm6q9KQgIgodtVLH7eXgCgrsauakCF2lZiEfTchskxzBY0P1Gv1eJtTSNPNt1gySqfWPMqUaPIJWRAwt51sgM4vqKfHUdjsps0M1wIxtZKKUKuo7nbpCb1tK5LqLNrfdPLBtbP3p53YTKnbWyqwpf9K++6DQFWn1R9rQPSbNfXU3yND8c468FgPYkXezVBM2oZJ/8xPO3P8pYyUJpxDW+Ce+XxYXQqqBEQUEztLHGs86qCSwkeo+YemgAj1fzGMKTjhpjur/fhy4Lpl//Y/XHOb18ebPqEEEPT87RMXhbsPrK/ckA2fyxi/NKZnHh81JsWwu1sc2HDRUvHeUzOG3yu+2rpS2JCxQyJs1q03xe7yFtpt4XgOwzWkKlStEhY4ZO84WYNW6aLdNKmNonCWdde5uRYAcUIRqFb3JwnMfsW43WjwE5YzBFwD7bbxgMcIPxUVTpFKNALI3XEyeo3SzTB2DuAKZaiGCiA81iqg4iPTIqyfvV57xophxfTnAyJnxPmRZTT7iADHttyksTCdxoCjhpi7zaxaqw1TdHPNd0+JEHJmx7FyMvlXGAXEacL5xGn+TQW2my0CQcXQ4A0HZp4uWnD22KSPUu0KnkUmhmkTT/7Ff8SvRx/8PmXZUJwnmqZnvJhzboGx6NVvvxqU5O8EEAt+edLpgwPCCETQrE8e+MXh2eeL0o4fGrsk0cxxwvToJr1wcn9wQuro3TnzjJfm/C1TG6rgHglF7MrAcSGairqiutsOR6ndUXFq07Wswy1MeyNcPWXrK99vo3Q8B4E9eNYL+UcSE3WebqR/SSpRAqKwT+z8w3HGPKfmufChakQRwwzUtGjm4nHaBQEe0e/LP8UHGOsy3izfkA0SPpzy8SQOQz4xTBUdkzlXe25ffb4JG/LGuIyJfM6mipVraov6x3yaHqpDQhPEhloHVFz03s+Hq8/UrFleuatAO3/75GUjGEQZtUWNiF09Hvt6bdmbWY2KlKTV45GYPDocPIRy2+ipWVNyzqWdzp28dqZTgWC1t+HZsztryp5JWJ5k4fXqVcv0Z/5guuLwYdTSO+huPp2FsZovNFaufGrGkJprJWTAqMjhLtu+ciQWMHTusAjjhdlf3mtCTRYpaoJe3jtXH3CG4SFGarhvMu/k1KECRXK0xl169ZtccxOhL612XgwDSK4qsZdIBPGvRRoKb6/4s70RneJLaXJk3Ir51IGNqAQj8JaD2+qNZojdqs8u6b9wEElAFDgeJoLQqgld0pjUYzU70+uJ2JB30ievtV78tMCvvYo4k2XH3qA9H8U0lIfGFFYvucSiGepukoLo4+0DqHfklSsXp2DKG0xsShBtvFnmgIBQRI3U6GIn5BY8OPgQFKGsDfLH6xohZE2W6w3CgxLDuJLs+zVfTMjLs+WfrDl7ovxEgR5XGTSiFIGCHDqIqMlxWNFqQxmAKSl0qSfrDITDiZyYbRVW0Qm6dBLiBJo40aw1oVCDflRVZW25fwdFwctOV3T8Z4uCggvoBo9bFVj97/K/piSuSKz7ZJ7VwnUzHIptSkH09djHMRdyHe/9rn/UnoYZT4Oi9c1ohBhUEDisz778bjYpqgPwrInhAxhG6YcKGR6tSdE/a7lYtHDGgGcnBo97fvDbu+NW5he+kSWueUGIChRmAHADSIr64DgEBidxARiqyruF8ChaCqUiR+GLmCC03ecYZ4OJaXXGVpe6YJyfnmgxe9wDollwBgVgmNovQtfENxqkAlub0yd/kaoqoPDpA80FjeX+EXN+MzABNh0tQSPDIA+qbnFBI7kWk7nebDeZakPmJWTO0ROiQ3GM4odQT1g67LdRdYW5t3dkXnp1SSU/cVhigDhsZMNwldVwQDKgWDvHu1jWMixZx1SxVvaBwaMgKFh79RZWFbqwSG0ItLCci2UaIuK1oAFYUVgGLrfbzPBCEIfAFr04OdVauy2XWpgZGIYhSfs0aimchNUzicP0OXH19rxy9fS3IsjLjSWO1mr8fw/dr38meUe6YXS0c8y80VsWBZquMu4HYnnoGu1bhke/vTF2dpIz6mnlnAURQVamtlnkLAyGu5rd6Hw+eeNSKmYIPXn52PRE9mi2Eym91aKtgw+V277HoOG0+YI+dktm8LMx9PjFietfgnl7bY08xA3qBe9HpkYhQdP44PCsBcShTXXf7ao6P2BU+nQ7ChA+jFuKIUYGBga2FaD/HrRClDSVyhRWdDMWq7mS22wXn9Io0WX3VrwL0t9P2P6Kkjc5jnzy4x9/4ISwTVAYrsWhVbCDbMHWyv3rBi/bOVhHAPP1xq2rqq+7sBBchRHIxu4svrssg09fMXbPUoXzrv3wh6X7rqEnU5sTi9gYThA4TigR9NamW7vIWyybP1CtWhm/+QDF19jz1pXtLhY6QOrDU18faLtRfKTG8NrGOG3Oj1+X8zy07frK9Y9VyVMuVZ64396N1Hil84Qw01aCIJ4aM8rg7y9tK+diWJPdPsFYrNVq28OQeLAIZ0w5dYWABMT22uyKq75rK0PshbmXIf40EB9s6HrBeV9xISuxF2ZahvjTQEQvg+E9OY73Qq9+YS48lIjjuEqr5d3u1mP/L2woP193PS4gEMToNekcz7PoIOnLSdKHw+b/mYnkTHkoEb27GDpzliYquvLjTKfwkqf3O2SSLuRMj7MzwoEUiC7vUEJv4clHl476UCgUJEl6veTpDRFVQ+zaFnNHL308B0U8tF69XjeWgNjHMXVj+FI3291w07eryBB7Yf7/B2rmkE044iNiAAAAAElFTkSuQmCC
…but you should remind that the database remains 6.02, so if you switch to 3.3.5 probably, you will find problems of incompatibility

19

Also majority of things should be already working for 6.x using the latest stable release (3.3.5 branch). The development live version that Helias has linked is the one we are using to testing 6.x version of Keira2 in order to fix all bugs.

20

F.Y.I.

Due to latest changes to the 3.3.5 database structure, the Keira2 Quest Editor of latest release is now broken. However, we have already fixed it so if you need to use the Quest Editor please use latest source of Keira2 from the github repo, but please be aware that new features will be incomplete/unstable until the next Keira2 release then don’t rely on them.

Meanwhile, we are working to release a 6.x-and-3.3.5a compatible database editor:

http://s16.postimg.org/ayvlnx2mt/Schermata_2015_09_04_alle_11_33_23.png