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

[stoneharry]

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?

Can you try deleting your SpellEditor.db and reimporting the DBC files?

[Ulec]

Same error unfortunately

[stoneharry]

Same error unfortunately

Strange, I'm not actually sure what could be causing this for you. :/

[naluni1277]

Hey buddy, been using your tool for a bit now, but im getting an error saying "System.Format.Exception: Die Eingabezeichenfolge hat das falsche format bei System.Number.ParseDouble(string value).." and keeps going a good side, any ideas?

Mainly happends with any kind of "Deadly throw" 3.3.5A

[stoneharry]

Hey buddy, been using your tool for a bit now, but im getting an error saying "System.Format.Exception: Die Eingabezeichenfolge hat das falsche format bei System.Number.ParseDouble(string value).." and keeps going a good side, any ideas?

Mainly happends with any kind of "Deadly throw" 3.3.5A

Reproduced the same bug:


Please report it on the GitHub issue tracker and I'll get round to fixing it at some point.

[Jyria]

Hey I'm pretty new to the server based stuff so got a couple of questions. How would i findout what spell visual ID's are of some animations? I can't get the spellvisual map working atm. Is there a way to find the spell visual ID somewhere else? Was thinking WoW modelviewer 3.3.5 but dont think that shows the spell visual ID itself

[Ironsven]

Very new to Servers, is there a way to convert spells from the .dbc file to spell_templates within sql? Thank you in advance!

[stoneharry]

Very new to Servers, is there a way to convert spells from the .dbc file to spell_templates within sql? Thank you in advance!

When you import the DBC into the spell editor, it saves the data to a SQL table. You can map this SQL table to your emulator one. There's an example in this issue: Create 1.12.1 cmangos/vmangos converter . Issue #91 . stoneharry/WoW-Spell-Editor . GitHub

[Corelith]

Found this wunderful program right now, and it seems to be verry useful.... for that many thanks^^...

but for one reason i dont know, i'm not able to connect to my database - server.
The data i insert is right, i'm verry sure on that!

My SQL-Version is "5.7.26-0ubuntu0.18.04.1" and my sys-version "1.5.1" ...

Any solution for that? What about the Port, is it 3306 or 33060? I'm not sure about this, but tested both - noone worked...

[stoneharry]

Found this wunderful program right now, and it seems to be verry useful.... for that many thanks^^...

but for one reason i dont know, i'm not able to connect to my database - server.
The data i insert is right, i'm verry sure on that!

My SQL-Version is "5.7.26-0ubuntu0.18.04.1" and my sys-version "1.5.1" ...

Any solution for that? What about the Port, is it 3306 or 33060? I'm not sure about this, but tested both - noone worked...

3306 is default. Depends what you configured.

What's not working? Error message / screenshots?

[Corelith]

3306 is default. Depends what you configured.

What's not working? Error message / screenshots?

Didn't change anything, so i think it's about the default port 3306 (thisone is also in the worldserver.conf - so i think it's open )

So the prog tries to read out the files:
1.jpg


and after a while it tells this fail:
2.jpg

i'll try to translate: it's something like 'The other side does not react. It's not possible to etablish a connection' ...

[stoneharry]

Didn't change anything, so i think it's about the default port 3306 (thisone is also in the worldserver.conf - so i think it's open )

So the prog tries to read out the files:
1.jpg


and after a while it tells this fail:
2.jpg

i'll try to translate: it's something like 'The other side does not react. It's not possible to etablish a connection' ...

It's unable to connect to your database for some reason. Are you able to connect using any MySQL IDE (any GUI editor)? (Navicat, SQLyog, HediSQL, etc)

If your MySQL server is hosted on another machine then you need to make sure port 3306 is open. That port does not need to be open in order to connect to a private server, only for database access.

[Corelith]

It's unable to connect to your database for some reason. Are you able to connect using any MySQL IDE (any GUI editor)? (Navicat, SQLyog, HediSQL, etc)

If your MySQL server is hosted on another machine then you need to make sure port 3306 is open. That port does not need to be open in order to connect to a private server, only for database access.

I'm working with phpMyAdmin... sure, it's on localhost... but if i look in putty for mysql open port with

 mysql> SHOW VARIABLES LIKE 'port';

it tells me

+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port          | 3306  |
+---------------+-------+

so i think it's about port 3306, no?

[6thsense]

It's 2023 and this is still the most valuable tool in 3.3.5a emulation, can't thank you enough for putting this together and releasing it to the public stoneharry - you are the man and a pillar of the emulation community, appreciate your contributions to the scene. I was learning off your guides as a kid 10 years ago and now I'm building the content I've always imagined using tools like this. Works flawlessly and saves so much time I wish I could do more than just profess my thanks.

[stoneharry]

It's 2023 and this is still the most valuable tool in 3.3.5a emulation, can't thank you enough for putting this together and releasing it to the public stoneharry - you are the man and a pillar of the emulation community, appreciate your contributions to the scene. I was learning off your guides as a kid 10 years ago and now I'm building the content I've always imagined using tools like this. Works flawlessly and saves so much time I wish I could do more than just profess my thanks.

Thanks for the kind words.