Major Changes

[Tommy]

For those of you that have been using our SQL generator we're grateful and hope you continue to use this tool. Over the next few days we're going to be changing up the look of our generator as presentation is important. Not only the look will be changed but our systems as well, and there will be new stuff. Anything that appears broken can be reported.

✔ = Completed

Our planned features:

• Create a slide animation when clicking on different bars. ✔
• Remove login requirement and allow guests to generate again. ✔
• Database Version on all generator pages so you know which version your query is being generated for. This takes less time if you wasted your time generating an outdated or updated sql query which the table structure could be inconsistent. More on this here. ✔
• We're not too happy about our current look of the generator. We need to present the overall look better. ✔
• Present the field bar better. ✔
• Remove all the images (Create NPC, TrinityCore, MaNGOS, etc.) and probably come up with a better way in navigating to the generators. ✔
• Allow users to create their own special custom items(or spells) so others can have fun and rate them on EmuDevs. Top 5 rated items(or spells) will be displayed on the front page of the generator and maybe the forum too.
• Implement our custom tooltip system so users can hover over items and such to see the outcome.
• Create a stylish tooltip. ✔
• Add (?) so people can hover over the question mark and it will be a tooltip explaining what this field is for ✔
• Add (?) to every required page
• Probably rework some fields with icons. e.g. money fields add gold, silver and copper icons next to the fields
• A better advanced search ✔
• More search choices (faction, etc) ✔
• Make building your query much more simple or present the fields better in a way that building anything will be faster. ✔
• Apply dynamically changing input fields based on DB version on all generators. ✔
• Implement multiple selection to stack bitmask values. ✔

Updates/Fixes that were done: ✔

• Multiple selection for stacking bitmask values.
• Inconsistent structure for creature_template generator.
• Fixed tab dropdown not working for Chrome, IE and other browsers (FF not included).
• Selected Tab expands and collapses when clicking on them until another tab is expanded.
• quest_template_addon now exists in TDB59+ queries.
• TrinityCore Quest page now has TDB58 version option.

Thanks to [MENTION=2825]Chessa103[/MENTION] for reporting some issues in this thread.
Thanks to [MENTION=426]Vitrex[/MENTION] for pointing out you couldn't select multiple options so you could stack bitmask values.

 

[Vitrex]

Sounds cool !

 

[Tommy]

Thanks.

Added a ✔ for features/other that are already completed.

 

[Tommy]

Okay, I'm starting to make selecting versions much easier now. Instead of going to another page you'll be able to select your version at the bottom of the generator above submit via the combobox. Once you've selected your version the input fields will dynamically change to the structure of the version you selected. This cleans up a lot of pointless directory spam.

Current example(s): TrinityCore Npc Generator and TrinityCore Npc Quest

Updated DB Versions thread too.

Q: How do I know which input fields change?
A: Fields with

next to them is an indicator that the input field will change during version selection.

 

[Vitrex]

Nice changes, but how about NPC Flags stacking? i mean if people wanna make Mirror image with disarmed off hand. since now they can select only one flag / immunity type.

 

[Tommy]

Nice changes, but how about NPC Flags stacking? i mean if people wanna make Mirror image with disarmed off hand. since now they can select only one flag / immunity type.

That's always been like that. The Immunity type does have an option for ALL, but I see your initial point on all flags. I might come with with something later. Thanks for pointing this out.

 

[Tommy]

Implemented "multiple select" for comboboxes. Flags and other columns that support bitmask, you'll be able to select multiple options and the values for those options will increment. Columns that cannot have stacked values will remain single selection only. Thanks [MENTION=426]Vitrex[/MENTION] for pointing this out.

Currently most important comboboxes has this edit. I'll work out getting this changed everywhere so they all match. "Select Version" boxes will not be changed.

 

[Tommy]

Tabs with large amounts of boxes and options will be simplified soon.

For example, Item Spells tab (simplified) ~ IT is in order too, just view the tooltip: