This is a read only copy without any forum functionality of the old Modcraft forum.
If there is anything that you would like to have removed, message me on Discord via Kaev#5208.
Big thanks to Alastor for making this copy!

Menu

Author Topic: SQL Question  (Read 806 times)

WhiteDarkrai

  • Registred Member
  • LUA Script Tinker
  • *****
  • Posts: 45
    • View Profile
SQL Question
« on: November 08, 2013, 02:54:55 pm »
I want to take all of the wotlk items and put them in a tbc database. How do I go about doing this?

Also, in 2.4.3, attack power and spell power are spells unlike in 3.3.5+ they are stats. Is there a way in the 2.4.3 DB/core to make items use spell power and attack power as a stat instead of a spell?
« Last Edit: January 01, 1970, 01:00:00 am by Admin »

Insanity

  • Registred Member
  • LUA Script Tinker
  • *****
  • Posts: 40
    • View Profile
Re: SQL Question
« Reply #1 on: November 08, 2013, 03:59:05 pm »
I would take that question to the forum of your database (trinity, udb, etc).  Most of the forums have a tbc version and they could better help you with that.
Basically you need to go through the item tables and fix which field differ between tbc and wotlk, don’t forgot to check the displayids and see if the models are present in the tbc dbc.  I’m sure there are other things in the dbc to take care of but that’s another topic…also best asked at the db forum sites

As for your second question the core's forum could help you more (that would be trinity, mangos, etc).  I assume you  would have to convert the numbers back to the tbc format unless you are comfortable with updating the portions of the core that handle items and their effects.
« Last Edit: January 01, 1970, 01:00:00 am by Admin »