Modcraft - The community dedicated to quality WoW modding!
Wrath of the Lich King Modding => Resources and Tools => Topic started by: stoneharry on June 01, 2014, 05:24:15 pm
-
Edit the 3.3.5a spell DBC with ease with this tool.
You can download from here: https://github.com/stoneharry/Spell-Editor-GUI-V2/releases (https://github.com/stoneharry/Spell-Editor-GUI-V2/releases)
Source code: https://github.com/stoneharry/Spell-Editor-GUI-V2 (https://github.com/stoneharry/Spell-Editor-GUI-V2)
(https://i.imgur.com/Mfy2xKC.png)
Old video: https://youtu.be/eRmLi54PDko
-
really ty dose it have a spell visual editor it would be great to change the model of the spell its really hard to do it buy hand
-
really ty dose it have a spell visual editor it would be great to change the model of the spell its really hard to do it buy hand
No. I was going to, but it would be incredibly hard.
My understanding is the ID points to a record that points to 4 records, and each of those 4 records point to another 8 records. Those records are spread across many DBC files and have a ton of data.
Furthermore to render the visual I would need some sort of rendering engine, which I have no idea how to go about doing.
-
This looks way too OP... will try it today.
EDIT1: So, first feedback incoming. I would prefer some config file, while I use one directory where I have all edited DBCs and don't want to 24/7 copy everything there and back. Also connection to MPQs would be fine, while I have my own custom Icons and again, now I have just to copy everything there and keep 2 directories up to date, not just one. Still pretty cool tool, I also love modern design and so on :P. Thumbs up.
EDIT2: Would also use filtering Icons by part of name (f.i. I might be looking for "sword" and so on).
-
This looks way too OP... will try it today.
EDIT1: So, first feedback incoming. I would prefer some config file, while I use one directory where I have all edited DBCs and don't want to 24/7 copy everything there and back. Also connection to MPQs would be fine, while I have my own custom Icons and again, now I have just to copy everything there and keep 2 directories up to date, not just one. Still pretty cool tool, I also love modern design and so on :P. Thumbs up.
EDIT2: Would also use filtering Icons by part of name (f.i. I might be looking for "sword" and so on).
I won't be adding MPQ support because it would be quite a lot of code to do so and not that easy (I've never worked with compression before). Cheers for the other feedback.
-
This app almost made me jizz my phants, thought I'd have to manually enter all the values into the dbc. Saved me from tons of work. Thank you very much!
-
I have pushed a new version, includes:
- Fixed localisation.
- Improved code greatly.
- Control's are now thread-safe so can be updated asynchronously. Stops the 'freezing' when you click spells.
- Documented more known values.
-
German .dbc files can not edit it.
Spells can not be selected to.
an error when saving=
the input string has the wrong format.
is the still not resolved?
-
German .dbc files can not edit it.
Spells can not be selected to.
an error when saving=
the input string has the wrong format.
is the still not resolved?
Can you upload your German spell.dbc so that I can test it?
Just saying "is this still not resolved?" when I haven't actually had any bug report is not helpful. I did not know this was an issue - the Chinese spell DBC I tested worked fine.
Bug reports are better posted on the GitHub page as well because then I get notified.
-
https://dl.dropboxusercontent.com/u/34528743/Spell.dbc (https://dl.dropboxusercontent.com/u/34528743/Spell.dbc" onclick="window.open(this.href);return false;)
I didn't test it, but here is a German spell.dbc
-
https://dl.dropboxusercontent.com/u/34528743/Spell.dbc
I didn't test it, but here is a German spell.dbc
This spell.dbc seems to be working fine for me:
(http://i.imgur.com/gBZt2pN.png)
If it does not work for somebody they need to upload their specific files for me to test. Also make sure you are using the latest version of the editor.
-
There is a bug when editing Target A and Target B. It works fine to number 9 which is TARGET_DEST_HOME. After that it starts adding 4 or 5 to a number you choose.. For example if you choose 22 which is TARGET_UNIT_MASTER (used for all AoE spell paired with 15 for target B which is TARGET_UNIT_CASTER_AREA_PARTY) it adds 5 to it when you save, so it's now 27 - TARGET_DEST_CASTER_SUMMON and 15 is 20 - TARGET_UNIT_TARGET_ANY.
So you have to go and fix it manually in DBC (rows 86-88 Target A and 89-91 Target B zero based ).
-
I have a Feature request.
Would LOVE a .txt / .csv Import/Export feature.
Would really help with group projects with people working different classes, or much easier copy and paste for things like Talents with up to 5 ranks.
Should also enable returns in the Description Textbox in the XAML.
Would be nice if the Spell Effects were numbered would be easier to find certain effects. e.g : SCHOOL DAMAGE = 2: SCHOOL DAMAGE
Otherwise, really enjoying the update. So much smoother loading.
-
There is a bug when editing Target A and Target B. It works fine to number 9 which is TARGET_DEST_HOME. After that it starts adding 4 or 5 to a number you choose.. For example if you choose 22 which is TARGET_UNIT_MASTER (used for all AoE spell paired with 15 for target B which is TARGET_UNIT_CASTER_AREA_PARTY) it adds 5 to it when you save, so it's now 27 - TARGET_DEST_CASTER_SUMMON and 15 is 20 - TARGET_UNIT_TARGET_ANY.
So you have to go and fix it manually in DBC (rows 86-88 Target A and 89-91 Target B zero based ).
This should now be fixed in the latest version.
I have a Feature request.
Would LOVE a .txt / .csv Import/Export feature.
Would really help with group projects with people working different classes, or much easier copy and paste for things like Talents with up to 5 ranks.
Should also enable returns in the Description Textbox in the XAML.
Would be nice if the Spell Effects were numbered would be easier to find certain effects. e.g : SCHOOL DAMAGE = 2: SCHOOL DAMAGE
Otherwise, really enjoying the update. So much smoother loading.
I have enabled returns in the spell strings and I have numerically labelled targets and such as suggested.
I do not know how a CSV exporter/importer would work. You mean like how DBCUtil works? I guess I could try and write it at some point.
-
Minor thing, but could you expand the attributes tables a little bit? Some of the text that tells you what each attribute does is cut off. For example in the attributes table Spell damage depends on caster location is cut off at Caster L, attributes EX2 cuts off Ambush, Backstab, Cheap Shot, De (cant tell the rest of the spells)
Just minor things like that.
-
I do not know how a CSV exporter/importer would work. You mean like how DBCUtil works? I guess I could try and write it at some point.
I was thinking more like SQL.
Being able to import a .csv or .txt
When you import a .csv it'll:
Add new rows to the spell dbc if new IDs are not present.
Or overwrite spells with already present IDs.
When you export a spell to .csv It'll
Export that spell like you would find in spell.dbc when you convert it with DBCUtil, that could be reimported or tooled around.
The majority of this idea stems from working with a bunch of people who'll be working at the same time. So instead of having to reinvent the wheel every time you update your Master spell.dbc, you can just have each member export a .csv with all their spells, then patch it into your master .dbc
This would also work for mass producing talents which have multiple ranks, as to speed up their creation process.
I only recommended .csv due to being able to open it with tools like CSVed or Excel an still retain column count for easier editing.
-
I do not know how a CSV exporter/importer would work. You mean like how DBCUtil works? I guess I could try and write it at some point.
I was thinking more like SQL.
Being able to import a .csv or .txt
When you import a .csv it'll:
Add new rows to the spell dbc if new IDs are not present.
Or overwrite spells with already present IDs.
When you export a spell to .csv It'll
Export that spell like you would find in spell.dbc when you convert it with DBCUtil, that could be reimported or tooled around.
The majority of this idea stems from working with a bunch of people who'll be working at the same time. So instead of having to reinvent the wheel every time you update your Master spell.dbc, you can just have each member export a .csv with all their spells, then patch it into your master .dbc
This would also work for mass producing talents which have multiple ranks, as to speed up their creation process.
I only recommended .csv due to being able to open it with tools like CSVed or Excel an still retain column count for easier editing.
Makes sense, but this is quite a large feature so not something I will implement any time soon.
Minor thing, but could you expand the attributes tables a little bit? Some of the text that tells you what each attribute does is cut off. For example in the attributes table Spell damage depends on caster location is cut off at Caster L, attributes EX2 cuts off Ambush, Backstab, Cheap Shot, De (cant tell the rest of the spells)
Just minor things like that.
Made them wider in the latest version.
-
Deployed a new build: https://github.com/stoneharry/Spell-Edi ... s/tag/v1.4 (https://github.com/stoneharry/Spell-Editor-GUI-V2/releases/tag/v1.4" onclick="window.open(this.href);return false;)
Flat file DBC editing is no longer supported - all edits are done from MySQL. A spell DBC can be imported into a MySQL database and the MySQL database can be exported to a new Spell.DBC.
This allows for multiple people to edit the same database at the same time.
This version also brings along many improvements and bug fixes over the older versions.
Please report any bugs you find on the GitHub page.
-
Created a tool to automatically generate all spell visuals as creatures to easily find spell visuals for the spell editor.
Screenshot can be seen here:
(http://i.imgur.com/pCLQ3zK.jpg)
-
Nice :D
-
Any plans to make it work for 4.3.4? Pleeeeeease?
-
Any plans to make it work for 4.3.4? Pleeeeeease?
No. The structure of the spell DBC changed completely with cataclysm and I made this primarily for my own work and shared it so others can do better custom spells too.
-
Any plans to make it work for 4.3.4? Pleeeeeease?
No. The structure of the spell DBC changed completely with cataclysm and I made this primarily for my own work and shared it so others can do better custom spells too.
Is there something (a certain config file maybe) in the program that I can modify myself to adjust it for cata?
-
Any plans to make it work for 4.3.4? Pleeeeeease?
No. The structure of the spell DBC changed completely with cataclysm and I made this primarily for my own work and shared it so others can do better custom spells too.
Is there something (a certain config file maybe) in the program that I can modify myself to adjust it for cata?
Not really. You could adjust it for earlier patches easily but there are so many changes with cataclysm.
-
:(
-
stoneyharry
can u upload a compiled vision of this tool? :D i become code error if i want compile it
-
stoneyharry
can u upload a compiled vision of this tool? :D i become code error if i want compile it
https://github.com/stoneharry/Spell-Edi ... 2/releases (https://github.com/stoneharry/Spell-Editor-GUI-V2/releases" onclick="window.open(this.href);return false;)
-
stoneyharry
can u upload a compiled vision of this tool? :D i become code error if i want compile it
https://github.com/stoneharry/Spell-Edi ... 2/releases (https://github.com/stoneharry/Spell-Editor-GUI-V2/releases" onclick="window.open(this.href);return false;)
I mean your Spell - creature tool to spawn the spells as creatures
-
stoneyharry
can u upload a compiled vision of this tool? :D i become code error if i want compile it
https://github.com/stoneharry/Spell-Edi ... 2/releases (https://github.com/stoneharry/Spell-Editor-GUI-V2/releases" onclick="window.open(this.href);return false;)
I mean your Spell - creature tool to spawn the spells as creatures
Oh - can do tomorrow. Bit busy today.
-
sounds good :)
-
New release build:
https://github.com/stoneharry/Spell-Edi ... tag/v1.4.3 (https://github.com/stoneharry/Spell-Editor-GUI-V2/releases/tag/v1.4.3" onclick="window.open(this.href);return false;)
Fixes MySQL error and includes the spell visual map builder tool.
-
Nice & thanks :)
-
I become a SQL Error:
If i import the create_template then comes this error
Column count doesn't match value count at row 1
-
I become a SQL Error:
If i import the create_template then comes this error
Column count doesn't match value count at row 1
Your TrinityCore version is different to mine. You will need to update the query generated to match the correct structure.
-
Love the design man looks really nice. I am using Mango's and was curious to know if it will support that database structure as I am getting an error that reads
Unknown column 'spellname0 in fieldlist'
I would greatly like some help on this as I really want to create my own spells.
-
Love the design man looks really nice. I am using Mango's and was curious to know if it will support that database structure as I am getting an error that reads
Unknown column 'spellname0 in fieldlist'
I would greatly like some help on this as I really want to create my own spells.
The spell editor works with all emulators on 3.3.5a 12340, it is completely independent.
The currently known issue people are getting is here: https://github.com/stoneharry/Spell-Edi ... -131586459 (https://github.com/stoneharry/Spell-Editor-GUI-V2/issues/14#issuecomment-131586459" onclick="window.open(this.href);return false;)
Make sure you are using the latest version.
-
I just grabbed your most current repo and compiled myself and ran it. I am still getting the issue Unknown column 'Spellname0' in 'Fieldlist'
Can you shed some light on this for me?
also when it asks for what table to use I'm assuming I'm using spell_template correct?
-
I just grabbed your most current repo and compiled myself and ran it. I am still getting the issue Unknown column 'Spellname0' in 'Fieldlist'
Can you shed some light on this for me?
also when it asks for what table to use I'm assuming I'm using spell_template correct?
The table name can be anything as long as it doesn't already exist.
-
I'm assuming that the error on spell 8939 hasn't been fixed yet or was there a work around that I'm not seeing?
-
I'm assuming that the error on spell 8939 hasn't been fixed yet or was there a work around that I'm not seeing?
I reported the bug but it's not fixed by the moment
-
I reported the bug but it's not fixed by the moment
from the looks of it the developer seems to be super active so I'm assuming he will probably fix it pretty quick :D
-
Can someone please explain to me what the EffectDieSides does before I go screwing stuff up?
-
Curious to know if we can expect an update on this software anytime or if I should look for a different method of adding custom spells to my server?
-
Curious to know if we can expect an update on this software anytime or if I should look for a different method of adding custom spells to my server?
I do not know when it will be fixed. I don't know what is causing the issue and since I cannot reproduce it, it becomes incredibly hard to debug. I do not have a lot of free time currently.
You can always use an older version that is not the MySQL update. Some stuff is broken but it works for the most part.
Can someone please explain to me what the EffectDieSides does before I go screwing stuff up?
The whole point of this tool is that it is easy to test what things do, and if you don't want to break an existing spell copy it to a new ID to test.
-
This is really outstanding contribution, thank you very much for your wisdom! :geek: :ugeek:
-
I edited a spell with this tool, but ingame the spell's effect doesn't working.
Somebody can help me ?
I put the spell dbc to my server and to my client.
-
Provide more information please. How did you create that spell? Did you just copy blizzlike spell and changed a few values? Which values? Sending your spell.dbc in RAR/7Z/MPQ (to compress it) would be also useful.
-
Provide more information please. How did you create that spell? Did you just copy blizzlike spell and changed a few values? Which values? Sending your spell.dbc in RAR/7Z/MPQ (to compress it) would be also useful.
Yes, I copied a blizzlike spell and I wanted to disable an effect in this, so I just changed the number to 0 at the column 71 in spell.dbc, but ingame the effect still in work.
-
Video of the spell editor: https://youtu.be/eRmLi54PDko (https://youtu.be/eRmLi54PDko" onclick="window.open(this.href);return false;)
-
Why cant this work to 1.12.1? :/
-
because 1.x.x has differnder spell.dbc structure
-
The new version fixes all the lag on the GUI!
https://github.com/stoneharry/Spell-Edi ... tag/v1.4.6 (https://github.com/stoneharry/Spell-Editor-GUI-V2/releases/tag/v1.4.6" onclick="window.open(this.href);return false;)
-
Thank you very much for making and updating this tool.
I have a few suggested features:
-SpellFamilyFlags fields (not to be confused with masks)
-option to filter spell names
-configurable dropdown lists (for example, if I add a new Mechanic Type or Aura Name, I'd like to be able to add those without opening Spell.DBC in a DBC editor). I guess it should be editable in a config file or something.
-annotated SpellFamilyNames (for example, if a spell has SpellFamilyName 3, it would be nice if the program noted that this is, by default, the mage family)
-
Thank you very much for making and updating this tool.
I have a few suggested features:
-SpellFamilyFlags fields (not to be confused with masks)
-option to filter spell names
-configurable dropdown lists (for example, if I add a new Mechanic Type or Aura Name, I'd like to be able to add those without opening Spell.DBC in a DBC editor). I guess it should be editable in a config file or something.
-annotated SpellFamilyNames (for example, if a spell has SpellFamilyName 3, it would be nice if the program noted that this is, by default, the mage family)
Fair suggestions. I am not actively developing the tool currently though, only bug fixing. There are a lot of things I would like to do but don't have the time nor motivation to do. :P
-
This is such a beast, well done. This has taken so much of the pain away from dbc editing. =D
-
The structure of the CreatureTemplate.sql in SpellVisualMapBuilder/Export doesn't work with the TrinityCore Database 2016 - 10 - 17
When I run SpellVisualMapBuilder.exe there is no new file generated...
Issue : https://github.com/stoneharry/Spell-Edi ... /issues/29 (https://github.com/stoneharry/Spell-Editor-GUI-V2/issues/29" onclick="window.open(this.href);return false;)
-
(https://i.gyazo.com/8c793121da1a5d4458e388f7c0b805e5.gif)
I compiled ur latest version
what is the problem ?
//Solved
-
Added SQLite support, improved icon editor, many other fixes/improvements/additions:
https://github.com/stoneharry/Spell-Editor-GUI-V2/ (https://github.com/stoneharry/Spell-Editor-GUI-V2/" onclick="window.open(this.href);return false;)