When selecting an Item, show more info about linked entities such as

• creature that drops that item (if any)
• gameobject that drops that item (if any)

etc...

also give the possibility of clicking the linked entity to edit it

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Suggestion by @Stoabrogga

does keira3 check linked events? it should somehow show an error if a link is not pointing to an event id with event type 61. this is a common error in the sai scripts.

Keira should automatically check if the DB version is correct and display a warning otherwise.

Reproduction steps:

1. Create a new SmartAI Areatrigger
2. Add a new row
3. Trigger the comment generation

main.456420854ed7a23b742f.js:1 ERROR Error: Uncaught (in promise): TypeError: Cannot read property 'toPromise' of undefined
TypeError: Cannot read property 'toPromise' of undefined

When selecting a new entity, inserting special characters like single quote ' will break the query.

The results appear to be duplicate:

SQL grouping is needed to avoid this issue.

It might be cool to have but don't know exactly how it would be done.

Perhaps either:

1. SAI for example: Have an option to save the SAI as "Anachronos - SAI - DATE.sql" or something
2. Have an option to store all changes you make across everything into a file that you then can name whatever you want. For example if you do an update of several things that link together. For example Updating some creature template stuff, some SAI stuff, some Condition stuff etc.

Yea I am a lazy fucker xD Copy pasta takes time :PPP

Amazing work so far btw <3

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

New random test failure detected:

Chrome 78.0.3904 (Linux 0.0.0) SingleRowComplexKeyEditorService check methods of class onCreatingNewEntity() FAILED
	TypeError: Cannot read property '0' of undefined
	    at <Jasmine>
	    at MockSingleRowComplexKeyEditorService.SingleRowComplexKeyEditorService.onReloadSuccessful (http://localhost:9876/_karma_webpack_/src/app/services/editors/single-row-complex-key-editor.service.ts:94:41)
	    at SafeSubscriber.onReloadSuccessful [as _next] (http://localhost:9876/_karma_webpack_/src/app/services/editors/single-row-complex-key-editor.service.ts:54:19)
	    at SafeSubscriber.push../node_modules/rxjs/_esm5/internal/Subscriber.js.SafeSubscriber.__tryOrUnsub (http://localhost:9876/_karma_webpack_/node_modules/rxjs/_esm5/internal/Subscriber.js:192:1)
	    at SafeSubscriber.push../node_modules/rxjs/_esm5/internal/Subscriber.js.SafeSubscriber.next (http://localhost:9876/_karma_webpack_/node_modules/rxjs/_esm5/internal/Subscriber.js:130:1)
	    at Subscriber.push../node_modules/rxjs/_esm5/internal/Subscriber.js.Subscriber._next (http://localhost:9876/_karma_webpack_/node_modules/rxjs/_esm5/internal/Subscriber.js:76:1)
	    at Subscriber.push../node_modules/rxjs/_esm5/internal/Subscriber.js.Subscriber.next (http://localhost:9876/_karma_webpack_/node_modules/rxjs/_esm5/internal/Subscriber.js:53:1)
	    at Observable._subscribe (http://localhost:9876/_karma_webpack_/node_modules/rxjs/_esm5/internal/util/subscribeToArray.js:5:1)
	    at Observable.push../node_modules/rxjs/_esm5/internal/Observable.js.Observable._trySubscribe (http://localhost:9876/_karma_webpack_/node_modules/rxjs/_esm5/internal/Observable.js:43:1)
	    at Observable.push../node_modules/rxjs/_esm5/internal/Observable.js.Observable.subscribe (http://localhost:9876/_karma_webpack_/node_modules/rxjs/_esm5/internal/Observable.js:29:1)
	    at MockSingleRowComplexKeyEditorService.subscribe [as reloadEntity] (http://localhost:9876/_karma_webpack_/src/app/services/editors/single-row-complex-key-editor.service.ts:52:28)

https://www.youtube.com/watch?v=R9oQs5KlEBo&feature=emb_logo
It would be good if we could:

• visualize the items in 3D;
• have better ergonomics with maybe icons that at a glance show us the option;
• visualize, as in the video, the item we are creating;
• also visualize the quest we are creating;
• can be created an algorithm that automatically calculates the level of the item based on the statistics.

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Keira3 should allow the user to run custom queries and see their result

Improve requiredhonorrank selector using ITEM_CONSTANTS['pvpRank'].

Hello there.
Keira is good, but with some reasons with working on remote machine - app is disconnected affter sometime (this is normal, i think), but force-reload and reload options do same thing - just kick you on connection settings window.
I think improvments with timed-out connection can reduce madness with it.
For example HeidiSQL don't have this issue.
When Keira is lost connection - the status changed to red.

Screenshot Here

I attempted to download Keira3 from the Release tab. This here to be exact. and every-time I try to unzip it to my desktop, it brings up the "File contains a virus or potentially unwanted software." error then removes both Keira3 & the zip folder.

It says the file is detected as a Trojan..

[FEATURE REQUEST] - Clone of existing entity

-- Currently only available for: Creatures (NPC`s) in future potentially add on all entities like: Quests etc...

Workflow:

You can either search normally for NPC in Keira3 or select entity by ID.
There should be a button or icon to clone existing entity with all relations to it in basically new form where you can edit it fully and execute new entity to DB.

In real example:

If i select creature ID: 2479, which is vendor by default and I press clone. I would like to have also his: Vendor table cloned too (Which is associated to him by his ID). Which would give me ability to edit only items in vendor list.
And so on.

Thank you.

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

This is the list of features that needs to be implemented in order to complete the 3.0.0 milestone.

Until 3.0.0, we will publish intermediate releases, so you can already use Keira3 and give us feedback.

The features below are marked as DONE once we have them in master branch (they are not immediately released, so this list might differ from what is currently available in the latest release available).

Feature editors

• Creature
• Quest
• Gameobject
• Item
• Gossip
• Conditions
• SmartAI

OS Support

• GNU/Linux
• macOS
• Windows

Enhancements

• Item editor preview
• Item icons in all editors

Internal technical/development features

• Base classes re-used for all editors/selectors/etc...
• Automated unit test full coverage
• Automated integration tests covering all editors
• Dependencies always updated to latest stable version via automated dependency-updater
• Debug mode toggle feature (show queries in console for easy debug)
• Querying MySQL
• Querying sqlite

Support us

I and @Helias are working for free during our free time, you can support us with a donation.

once this PR is on master: azerothcore/azerothcore-wotlk#2304

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

As mentioned in Discord:

If you pick a creature for SAI editing, it would be nice to see all aviable actionlists for that creature.
In addition, jumping back and forth with a simple click to take them into editing would be nice too.

Example - Trinitycores Version of AoWoW shows all aviable actionlists for creatures :
https://tcubuntu.northeurope.cloudapp.azure.com/aowow/?npc=15402#sai-main

How it looks by default (without the user to resize it manually):

how it should be instead:

it's not a serious bug as the user can resize the window or manually drag the column size, but it's a bit annoying

Also, when toggling the sidebar, all datatable break:

Chrome 76.0.3809 (Linux 0.0.0) QuestRequestItems integration tests Editing existing should correctly initialise FAILED
	Uncaught Error: ViewDestroyedError: Attempt to use a destroyed view: detectChanges thrown

https://travis-ci.com/azerothcore/Keira3/builds/126514599

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

We need to align with: https://github.com/azerothcore/wiki/pull/175/files

If using timed action lists (source_type 9 "SMART_SCRIPT_TYPE_TIMED_ACTIONLIST") the event type should be set to 0 and disabled. The action lists only use event param1 and param2 to specify a minimum / maximum wait time, they (obviously) don't use events, as those are just sequentially executed actions.

All the new AzerothCore actions:

SMART_ACTION_MOVE_TO_POS_TARGET                 = 201,    // pointId
SMART_ACTION_SET_GO_STATE                       = 202,    // state
SMART_ACTION_EXIT_VEHICLE                       = 203,    // none
SMART_ACTION_SET_UNIT_MOVEMENT_FLAGS            = 204,    // flags
SMART_ACTION_SET_COMBAT_DISTANCE                = 205,    // combatDistance
SMART_ACTION_SET_CASTER_COMBAT_DIST             = 206,    // followDistance, resetToMax
SMART_ACTION_SET_HOVER                          = 207,    // 0/1
SMART_ACTION_ADD_IMMUNITY                       = 208,    // type, id, value
SMART_ACTION_REMOVE_IMMUNITY                    = 209,    // type, id, value
SMART_ACTION_FALL                               = 210,    //
SMART_ACTION_SET_EVENT_FLAG_RESET               = 211,    // 0/1
SMART_ACTION_STOP_MOTION                        = 212,    // stopMoving, movementExpired
SMART_ACTION_NO_ENVIRONMENT_UPDATE              = 213,
SMART_ACTION_ZONE_UNDER_ATTACK                  = 214,
SMART_ACTION_LOAD_GRID                          = 215,
SMART_ACTION_MUSIC                              = 216,    // SoundId, onlySelf, type
SMART_ACTION_RANDOM_MUSIC                       = 217,    // SoundId1, SoundId2, SoundId3, SoundId4, onlySelf, type

https://github.com/azerothcore/azerothcore-wotlk/blob/master/src/server/game/AI/SmartScripts/SmartScriptMgr.h#L571

don't have a comment in SAI_ACTION_COMMENTS in sai-comments.ts

I Suggest that when either exiting the program by clicking (X) or the close button
an option that appears when clicking it saying (Do you wish to exit your work might not be saved)

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

I have a suggestion, When pressing the execute button
I would like a message saying something similar to this "Your query has been successful!"
so people dont have to check in their database wether it was added or not :)

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Some ideas in bulk :
copy a character from one AC server to another, as with Blizzard, you can sometimes migrate a character to a test server for example.
More information about the :

• time since it started
• how many people logged on
• and so on.

I know Keira's primary goal is to manage the database. Maybe a future evolution of Keira 4:D, adding a more advanced server administration function. Like managing and replying to tickets, phase change, and everything a GM needs to respond to the players but also everything a server administrator needs for the rest.

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Need to add it condition once this PR is merged:

azerothcore/azerothcore-wotlk#2342

12046

Hi,

it would be nice if the software could allow a mysql connection over ssh.

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

it does this on any folder.

Also i have no idea how to install npm. its unclear. please upload a video explained or just a video..

C:\WINDOWS\system32>npm run ng:serve:web
npm ERR! path C:\WINDOWS\system32\package.json
npm ERR! code ENOENT
npm ERR! errno -4058
npm ERR! syscall open
npm ERR! enoent ENOENT: no such file or directory, open 'C:\WINDOWS\system32\package.json'
npm ERR! enoent This is related to npm not being able to find a file.
npm ERR! enoent

npm ERR! A complete log of this run can be found in:
npm ERR! C:\Users\Sheldon Gelinas\AppData\Roaming\npm-cache_logs\2019-08-15T02_10_37_902Z-debug.log

Affecting:

• npcflags
• dynamic_flags
• mechanic_immune_mask

Hi. Thanks for your work.
Do you have plans to add locales editing for entities ?

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

I would suggest a feature to save the latest connection data for easy reconnection