stoneharry / wow-spell-editor Goto Github PK

I noticed this with effect 136, HEAL_PCT. On the Effects 1 tab, it's listed as such. On Effects 2, it's "unknown_16." On further inspection, it looks like most of the effects listed as unknown in Effects 2 are listed with an actual name in Effects 1. I'm assuming the two parts need to be updated separately?

please localise the SpellMechanic.dbc

example : spell 20597,

ingame : requires sword, 2h sword

on myspelleditor : nothing about that

Would be possible to create 1.12.1 Editor :)?

when attempting to edit spell 325 (lightning shield) and some others, it gives this error using sqlite AND mysql on the latest release.

If you save any spell that row ^ gets set to 0. Also the row itself isnot editable from the spelleditor

so it is possible it is most likely left out.

Its easy to reproduce, set that row to any number then save the spell via the db editor after loading it ofc, and itll be set to 0 again in the DB.

everytime you save a spell, the AttributesEX3 gets set to 0. This really messes up your spells! :P

The spell editor allows you to click "Import Spell.dbc to MySQL" even though the table in the database is not empty.

It will show a message, stating that the table appears empty, asking the user whether they wish to fill it or not. Clicking continue will result in a mySQL error, leaving the user clueless that they have to truncate the table first.

It doesn't create the editing table but creates the database and all other tables, so its not an issue with the MySQL connection. Wouldnt be that big of an issue if I had the SQL Code for the table.

For some reason loading spell:

holy shield - ID: 48952

It just wont, it is stuck at this forever: http://puu.sh/jRoUX/f9f7d39bc0.png

I recently updated today, my last version was months old, where it would load it but it would show no stats and no information at all, like it was loading wrong. Not sure what is causing it.

I am sorry for posting here, but I have searched the whole internet for this, but I couldn't find any information about it. I am wondering about "SPELL_EFFECT_DUMMY = 3" what this is for ? what is it doing exactly ?

I update the 1.4.5 version to the new 1.4.6 version. Now i modify a spell and click on "Save spell change" button. If i reload the modify spell then my changes are lost. Version 1.4.5 working.

Hi,

I am using your software with the TrinityCore 3.3.5a and I am having some problems with the spell icons. I was able to successfully load the spell.dbc database into the SQL Lite, however whenever I select a spell and click on the "Icon" button of the interface, I get an unhandled exception saying this: "File could not be found: Icons\Interface\Icons\Spell_Frost_IceStorm.blp"

The call stack is below:

SpellEditor.exe!SpellEditor.MainWindow.HandleErrorMessage(string msg) Line 133	C#
SpellEditor.exe!SpellEditor.Sources.DBC.SpellIconDBC.UpdateMainWindowIcons(double margin) Line 148	C#
SpellEditor.exe!SpellEditor.Sources.DBC.SpellIconDBC.LoadImages.AnonymousMethod__0() Line 91	C#

I've checked the folder from which I am running the program and it doesn't have an Icons\Inteface folder. I am not sure how to get it or generate it. Could you help me?

The program load time is really slow due to listing all icons and spells at the same time creating a huge list. Add a on scroll event to load spells from the last loaded item and create a new config item to set how many items are loaded / session.

SELECT * FROM $DATABASE.$TABLE ORDER BY ID ASC LIMIT $LAST_ITEM, $ITEMS_TO_LOAD;

this should improve the loading time a little

Would be nice to have a success/error message after saving a spell something similar to the one you receive once a new spell is created. Sometimes I have to manually check in DB or refresh the program to make sure that changes were saved.

Selected Spell id 100 -> tab 1 -> Goes back to select spell tab, view is the same as it was when i first selected the spell -> Selects spell 100 -> tab 1 -> Goes back to select spell tab, Now the view is from spell id 1-33 -> select spell 15970 -> Crash

When you set the PowerType of a spell to "Health" and save it, you're unable to load and thus edit it anymore. It also the case for Blizzard's spells using Health as Powertype.

To reproduce the error, simply open the SpellID 1454 in the editor.

I am using the lastest version of the Editor (1.8.2) in 64bits and have the French locale.

If you delete spell id 5 the UI fails to populate the spell list on the main tab. Localisation also fails when spell id 5 does not exist.

When I want to load spell.dbc(zhcn-3.3.5) ,it can't read……
sad……
but this project is so cool and thank you!

Hi,

I had this issue several times now since I use the version 1.8.0 of your editor (French locale, 64bits version) :

When I just do what the editor is made for, aka creating spells, after switching between tabs, spells and saving a certain amount of times (heavy usage for like 40minutes) it suddenly freezes and dissapear and I have to kill it's task manually.

The error log only say "Not enough memory" but I had only 67% of my total memory used while the Editor was launched and crashed and the last 10 lines of the debug_output only talk about an unexpected token in the description field.

Unexpected tokens [$m1, REFERENCE] PLUS [$AP, REFERENCE]
Unexpected tokens [$AP, REFERENCE] MULTIPLY [0, NUMBER]
> Token '$m1' derived value '$m1'
> Token '+' derived value ''
> Token '$AP' derived value '$AP'
> Token '*' derived value ''
> Token '0' derived value '0'
${$m1+$AP*0.1}	----	Processing
Token: [$m1, REFERENCE, $m1]
Token: [+, PLUS, ]
Token: [$AP, R

I can't really tell you how to reproduce this issue tbh, it happen randomly after many reload/saves, therefore I'm not really waiting for a "fix" but I just assumed you would like to know anyway this issue eventually existed.

If i try open my custom icons it load like 90% and crash!

I compiled ur latest version

what is the problem ?

I'm using 64bit version of Window 10. The program (Latest Release) shuts down, after choosing to connect to a MySQL server (I have already set up the connection). The table has already been set up by the program, as I can see in my db, however the program just crashes quickly afterwards.

The occurance can be seen in this gif: https://gyazo.com/7e2eec286d5589f7b8c752ab832ed5ba

Although we can clone it and modify it then compile to native language ,if provide a Interface maybe cool and well!~we can more convenient merge code.
for example you add a folder:/loc/ ,we put zhcn.js,zhtw.js(or zhcn.ini) .
in UI we can easy to change language.

This may actually be related to the issue someone opened 3 days ago.

If I change the duration index to ID 21, save, close the editor, and then come back to it later, the "Value was too large or too small for an Int32" error tends to appear. I'm not FULLY certain what triggers it in this case, but it might actually be the tooltip tag trying to call the value, because I just tested it on spell 696-Demon Skin (Rank 2). I had to actually edit the duration index in the dbc itself for the editor to allow me to edit the spell, and all I did was remove the duration part of the tooltip and set the duration index to ID 21 again. Saved, closed, reopened, and it allowed me to select the spell. So I'm not certain if it's just the tag, or some kind of variable I'm not aware of, but it's DEFINITELY related to the duration.

Hi, this is a minor issue,

When you add a dividing tag ($/10;s1) for a certain effect, let's say effect1, the other effets won't be able to show the value in the "real time description" of the editor.

The dividing tag is used to show the final value of time or rage for exemple, since the input value is always bigger than the real final value the player have.

You can see it with the spell ID 17061, the $s2 is not anymore able to show the value in real time, it does the same if you change the 2 by a 3, but if you remove the dividing tag, everything works again.

does not support Chinese.

So i use your newest program version, but the save function does not work on some spells.

For example: 9472

Error message: Concurrency violation: the UpdateCommand affected 0 of the expected 1 records

I think that this is something on my end, can anyone please confirm or tell me if there's an easy fix?

Hi, i see this when i logged on my mysql Trinity Core server.. but i dont know how to fix it..

The attributes editor is currently not implemented which is a large portion of the spell DBC.

When i open the Editor and click in some spell, it stuck in a infinity loading screen, sometimes "Updating text control's" and sometimes "Updating category & dispel & mechanic"

thank you :)

When the dialog open up i'll put the name of the dbc in my case spell.dbc when i'll put this it says that can't open the file

IF I use CN spell.dbc
can success import to mysql
but IF I enter any ID
it will be always please wait
If I use US spell.dbc or your 1.4.3 release build it can run well

Hello,

When I launch for the first time the editor and Import (a clean) spell.dbc (SQL or SQLite) I can choose the Ranges and DispelTypes in the menus, but once I stop and restart it the two dropdown menu are empty.

I don't see any reason that could lead to this issue, since the DBC is fresh, also i'm using the 64bits version, the spell I used in this exemple is the spell ID 11, but any other spell do exactly the same.

hello. @stoneharry.
Because of the use of the editor to open an MySQL service, there is a little inconvenient.
so I am trying to modify the MySQL sqlite. to make the program does not need to rely on the MySQL can work normally. The current editor has been able to read the spelldbc data to the database.
Can generate tables.
Editor can also browse spell information.
However,when the output of spell.dbc there are some mistakes I couldn't resolve.
And SpellDescriptionGen will go wrong (I temporary note the SpellDescriptionGen)
And some unexpected mistakes.
I want to know if you think SQLite is a feasible change? If possible, I hope to get your help. Thank you.
I have to change my push to my github. if you have the time I hope you can help look now.

I hope you can understand what I said above.I will try my best to improve my English. - -!

v1.8.1 You can't select what dbc you want to export
https://i.imgur.com/qBpGWug.jpg

If you close the selection window, program just freeze and crash

When you set a coma in the values of RealPointsPerLevel and/or EffectBonusMultiplier and/or DamageMultiplier the editor is unable to copy the spell if you want to use it as a base for a new spell, you get a truncated data error.

To reproduce this issue, simply create a new spell using the SpellID 205 as a base for it and you will get the error for RealPointsPerLevel. (You can test and change the value of DamageMultiplier and EffectBonusMultiplier for this spell and try to copy and you will be able to reproduce the two others errors)

I am using the lastest version of the Editor (1.8.2) in 64bits and have the French locale.

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...

I use your all of the dbcs run well but If I use cn spells after import spell to mysql,click one spell then you can see always

so I put cn spell dbcs to you maybe you can solve it

I suspect that the structure of Chinese dbc file, you may need to check the file structure

my cn spell link
https://mega.nz/#!M9ZRDa4a!nrY6Trj9r1X5wSFTNQiHD97JJswzOeBb7_PvswZuj7A

Release Build 1.4.8:

Polymorph (Corrupts Target [Creature Types] in MISC & marks as giants) must re-enter flags then save
Health Funnel (Stuck on opening spell wont load & stuck in loop) must force close [x]
Life Tap (Stuck on opening spell wont load & stuck in loop) must force close [x]
Bloodrage (Stuck on opening spell wont load & stuck in loop) must force close [x]
Probably more with same issue, these spells load in some older versions.

Saving stacks up & becomes slower after each save.

i'll put the dbc in the release folder i put the name of the file "Spell" and "Spell.dbc"
And doesn't open anything ._.

Great editor but some more tuning is required.

Practically everything in the stances tab starting after "Ambient" will not stay checked.

Spell Editor ---> Flags ---> Misc ---> Stances ---> Ghoul (down to) Spirit of Redemption (do not work as intended)

Once saved they uncheck & randomly select other options (typically on ambient or above it)

I just noticed you fixed it a day ago

Re-opened

Stances are still not fixed

so i tried using the latest version, seems when you are in game it will use the valus on the tooltips that you use in the editor.

Lets say i want the paladin talent Hammer of justice, instead of saying it will decrease the cooldown with 10 seconds it will say 10000 seconds. While it decreases the cooldown by 10 seconds.

Lets say we have the Talent Improved Righteous Fury (Paladin talent, which is the one above too)
it will say

"While Righteous Fury is active, all damage taken is reduced by 2/%"
while it should say
"While Righteous Fury is active, all damage taken is reduced by 2%"

And it does this to all talents, seals etc.

Everything that uses a value or % in stat increase or damage.

Like for Seal of Righteousness it will say

"Fills the paladin with holy spirit for 30 min, granting each meele attack $ additional Holy damage. Only one Seal can be active on the paladin at once.

Unleashing this Seal's Energy will cause 2652 Holy damage to an enemy.
"
Now the problem with that is that it should give you a number instead of a symbol "$"

and so on, you get it.

When I attempt to import a clean dbc

i get this error:

Any ideas what is wrong?

If it's possible to update it, how can i do it?

IS this tool can be use for 1.12.1？

(this can be bypassed by copying the spell in SQL)
This error occured for me when i tried to make a new spell and copy 635 (Holy Light)
the new spell will not be added either.
This is what it says for me when i try to copy it:
Data truncated for column "EffectRealPointsPerLeve1" at row 1