Spell Editor for WoW versions [3.3.5] [2.4.3] [1.12.1]

[stoneharry]

I have been having a lot of fun with the editor now that I have it working, however, spells with special effects such as Seal of Righteousness escape my control! For instance, SoR uses weapon normalization, the slower the weapon the more damage it does, nowhere in the basic spell data in the spell.dbc is any of this visible. I think it may have something to do with spell family masks but I have not been able to crack it. I would really like to remove the weapon normalization and turn it into a flat damage proc.

Edit. Resolved this-sort of. There are "old" versions of the SoR spells that behave how I want while still getting a talent tree bonus. I will change the active SoR to match the old and bada bing it works. I still have absolutely no clue where the original spell was getting its damage info tho XD.

Looking at spell ID 21084:







Looking at: WoW-Spell-Editor/Vels Tag Documentation.txt at master . stoneharry/WoW-Spell-Editor . GitHub

$MWS - some of meele spells
$AP - Current attack power(not confirmed) uses only for formulas, involved in the formation of damage or healing.
$SPH - Spell power? undocumented in this list at the time of writing this

There's a lot of funky stuff going on here with the spell family masks. Some of those values will be how the talent is applied.

[redlegdaddy]

Thank you again Harry, this app is an absolute lifesaver and basically makes spell editing possible.

[Hiddenboy]

Hi thx for release, i'm getting error : Authentication with old password no longer supported, use 4.1 style passwords. when i try to connect MYSQL

[stoneharry]

Hi thx for release, i'm getting error : Authentication with old password no longer supported, use 4.1 style passwords. when i try to connect MYSQL

This looks like the MySQL version used in this application is not compatible with your current MySQL user password.

I had a quick google and it looks like this can be resolved by running a couple of MySQL queries: c# - Authentication with old password no longer supported, use 4.1 style passwords - Stack Overflow

SET old_passwords=0;
SET PASSWORD FOR my_user=PASSWORD('my_password');

Or, you can run the following two commands instead which require less privileges because it updates the currently logged in user:

SET old_passwords=0;
SET PASSWORD = PASSWORD('my_password');

[Hiddenboy]

This looks like the MySQL version used in this application is not compatible with your current MySQL user password.

I had a quick google and it looks like this can be resolved by running a couple of MySQL queries: c# - Authentication with old password no longer supported, use 4.1 style passwords - Stack Overflow

SET old_passwords=0;
SET PASSWORD FOR my_user=PASSWORD('my_password');

Or, you can run the following two commands instead which require less privileges because it updates the currently logged in user:

SET old_passwords=0;
SET PASSWORD = PASSWORD('my_password');

Thx for answer and it solved,

now the problem is that says no spells loaded. and when i type spell id nothing happen

[stoneharry]

Thx for answer and it solved,

now the problem is that says no spells loaded. and when i type spell id nothing happen

You have to import the spell.dbc before any spells will be loaded.

edit:

Finished the spell visual editor:

[veng455]

Appreciate the update to support older versions. Any idea which dbc 1.12 uses for stance requirements for spells? I have never been able to figure this out. E.g with your program The flags--->misc-->stances are greyed out. I'm assuming 1.12 uses a different dbc for stance requirements.

[stoneharry]

Appreciate the update to support older versions. Any idea which dbc 1.12 uses for stance requirements for spells? I have never been able to figure this out. E.g with your program The flags--->misc-->stances are greyed out. I'm assuming 1.12 uses a different dbc for stance requirements.

I am not sure, maybe SpellShapeshiftForm.dbc? DB/SpellShapeshiftForm - wowdev

All of my information basically comes from WoWDev: DB/Spell - wowdev

[Evever]

Hey Stone, awesome editor, use it for 3.3.5 and it works great, when I try to use it for my 1.12, I get

Capture.JPG

[stoneharry]

Hey Stone, awesome editor, use it for 3.3.5 and it works great, when I try to use it for my 1.12, I get

Capture.JPG

Double check your config, make sure you are using a unique database name and NOT the emulator world database.

[Ulec]

Hi Harry,

Great tool and thank you for making it!

I had used an earlier version of this in the past and it had worked perfectly fine. Needed it for something now and went ahead to download the latest release, yet I get the error below when trying to use it for 3.3.5.

Appreciate any guidance; cheers!

Attachment 73205

FYI: I get this immediately after I select SQLite at the first prompt.

[stoneharry]

Hi Harry,

Great tool and thank you for making it!

I had used an earlier version of this in the past and it had worked perfectly fine. Needed it for something now and went ahead to download the latest release, yet I get the error below when trying to use it for 3.3.5.

Appreciate any guidance; cheers!

Attachment 73205

FYI: I get this immediately after I select SQLite at the first prompt.

I just wanted to confirm you are using running a clean installation? Don't try to upgrade from an older version, export SQL data to DBC and import DBC to SQL using the new version. v1.9.6 has a pretty fundamental bug so try using v1.9.5 until a newer version is available.

[Ulec]

Yes, it is a clean installation. What I had used back then is completely gone; was on a different PC

P.S: Installed the new v1.9.7 after having completely deleted the previous one; still the same error. Tried the same with v1.9.5 as you've suggested, to no avail

[stoneharry]

Yes, it is a clean installation. What I had used back then is completely gone; was on a different PC

P.S: Installed the new v1.9.7 after having completely deleted the previous one; still the same error. Tried the same with v1.9.5 as you've suggested, to no avail

Can you post a screenshot of your config please? (with username/password removed)

Are you using the DBC and Binding files provided with the program? It looks like it might be failing on AreaTable.dbc.

If you can, upload your DBC files for me to test with.

[Ulec]

I am only using the DBC and bindings that came with the editor; nothing else.

<?xml version="1.0" encoding="utf-8"?>
<SpellEditor>
  <SQLite>
    <DatabaseFileName>SpellEditor</DatabaseFileName>
  </SQLite>
  <Language>enUS</Language>
  <BindingsDirectory>C:\Users\MYUSERNAME\Desktop\Spelleditor\WoW Spell Editor\Bindings_335_wotlk</BindingsDirectory>
  <DbcDirectory>C:\Users\MYUSERNAME\Desktop\Spelleditor\WoW Spell Editor\DBC_335_wotlk</DbcDirectory>
  <WoWVersion>3.3.5a 12340</WoWVersion>
</SpellEditor>

You mean this config.xml?