Giter Club home page Giter Club logo

keira2's Introduction

News from Keira's authors

  • Keira2 is no longer mantained and it has been replaced by Keira3

Keira2 the TrinityCore Database Web-Editor

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.

Keira2

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/";

Contribute

or you can donate to support us

Donate

License

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

Screenshots

Keira2 Keira2 Keira2 Keira2 Keira2 Keira2 Keira2

keira2's People

Contributors

francescoborzi avatar helias avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

keira2's Issues

Suggestion?

Hi, Would there any option for connection to own database as if u pick some creature and change something as will it import automatically rather import it manually ?

Some suggestions

1, multi language support, provide Lang options, easy to localize.
2, e.g:item: class subclass, spellid column should have the pop option, easy to search skills, class,subclass ……you can refer to Truice
3, to provide add new items, new creature options (now only to maintain)
Expect to become a web version of the Truice!

Execute SQL Script

First, great work!
Its planned to integrate a "Execute SQL" Button?

Greets

Missing smart actions and smart targets

Keira2 has missing or out of date actions and targets compared to current commit of TrinityCore.

See this gist for all current actions and targets formatted for Keira2

I haven't done the labels for the specific fields, unfortunately, haven't had the time.

Conditions

In behalf of Malcrom, I'm feature requesting a page to do conditions in an easier way without having to know what each number means by heart (similar to SAI).

Misleading visual values in the `event_flags` pop-up list

When comparing the "Flags" values in Keira2 (online test version, 3.3.5) with TC wiki, values in the pop-up list from "Flags" seem incorrect. Copy-paste from Keira2 pop-up from 'Flags' :

0 NOT_REPEATABLE
1 DIFFICULTY_0
2 DIFFICULTY_1
3 DIFFICULTY_2
4 DIFFICULTY_3
5 RESERVED_5 (not used)
6 RESERVED_6 (not used)
7 DEBUG_ONLY

Values in event_flags table from TC wiki:
https://trinitycore.atlassian.net/wiki/display/tc/smart_scripts#smart_scripts-event_flags

Name Flag Hex Comment
SMART_EVENT_FLAG_NOT_REPEATABLE 1 0x01 Event can not repeat
SMART_EVENT_FLAG_DIFFICULTY_0 2 0x02 Event only occurs in normal dungeon
SMART_EVENT_FLAG_DIFFICULTY_1 4 0x04 Event only occurs in heroic dungeon
SMART_EVENT_FLAG_DIFFICULTY_2 8 0x08 Event only occurs in normal raid
SMART_EVENT_FLAG_DIFFICULTY_3 16 0x10 Event only occurs in heroic raid
SMART_EVENT_FLAG_DEBUG_ONLY 128 0x80 Event only occurs in debug build
SMART_EVENT_FLAG_DONT_RESET 256 0x100 Event will not reset in SmartScript::OnReset()

I don't know how Keira2 applies the flags or if the wiki page is outdated or incorrect, but I find the Keira2 example table somewhat confusing when it comes to using event_flags = 0, which should mean "Flag not set, empty value" to the user. The visual value selection in the table will make a user like me think that 0 means 'Not repeatable', which actually is 1 in the script and in the wiki page.

If I may suggest what the visual pop-up could look like, here is an example list:

  0 FLAG_NOT_SET (placeholder/empty value)
  1 NOT_REPEATABLE (Event can not repeat)
  2 DIFFICULTY_0 (Normal dungeon)
  4 DIFFICULTY_1 (Heroic dungeon)
  8 DIFFICULTY_2 (Normal raid)
 16 DIFFICULTY_3 (Heroic raid)
 32 RESERVED_5 (not used)
 64 RESERVED_6 (not used)
128 DEBUG_ONLY (only used in debug build)
256 DONT_RESET (Event will not reset)

I hope this explains my issue well enough. Feel free to ask if you need more information. :)

trainer_class

For 3.3.5
The right is as follows:
/* creature classes constants */
app.modalConstants.classes = [];
app.modalConstants.classes[1] = "WARRIOR";
app.modalConstants.classes[2] = "PALADIN";
app.modalConstants.classes[3] = "HUNTER";
app.modalConstants.classes[4] = "ROGUE";
app.modalConstants.classes[5] = "PRIEST";
app.modalConstants.classes[6] = "DEATH_KNIGHT ";
app.modalConstants.classes[7] = "SHAMAN";
app.modalConstants.classes[8] = "MAGE";
app.modalConstants.classes[9] = "WARLOCK";
app.modalConstants.classes[10] = "UNK";
app.modalConstants.classes[11] = "DRUID";

But yours is like this:
/* creature classes constants */
app.modalConstants.classes = [];
app.modalConstants.classes[0] = "WARRIOR";
app.modalConstants.classes[1] = "PALADIN";
app.modalConstants.classes[2] = "HUNTER";
app.modalConstants.classes[3] = "ROGUE";
app.modalConstants.classes[4] = "PRIEST";
app.modalConstants.classes[5] = "DEATH_KNIGHT ";
app.modalConstants.classes[6] = "SHAMAN";
app.modalConstants.classes[7] = "MAGE";
app.modalConstants.classes[8] = "WARLOCK";
app.modalConstants.classes[9] = "UNK";
app.modalConstants.classes[10] = "DRUID";

The file name is: constants.js
Thanks!

Looking up items in 6.x

It is currently not possible to lookup items, if you're on 6.x.
Is there some specific reason for this? Is it being handled differently than in 3.5.5?

Add/Edit button like a Quice/Truice?

Hello,
i really like your project, but i really missing button like EXECUTE script to database. It is possible in short time to create it? It will be really awesome.
PS: Sorry for my english and have a nice rest of the day :)

quest_offer_reward is not defined

When I set some text in OfferRewardText filed, update button does not detect change and full sql does not detect the ID in quest_offer_reward.

screenshot from 2016-12-04 19 23 40

Comment generation

If in SAI editor phase set to 1-9, then comment generation isn`t work

Directly query the DB

It would be nice to directly query the DB using a button.
For now you have to copy paste the code.
In the Update Script tab and Full Script modal we should implement a button that makes an Ajax call to query the DB.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.