Executing SQL files..

[Dkocir]

Ok so this is really weird.. I was trying to make some custom items on wow-v.com, but whenever i tried to

add it to database, it told me this error : SQL ERROR(1054) : Unknown Column 'dmg_min1' in 'field list'... I dont undestand it cause i was adding bracers and it

has nothing to do with damage .. I also tried to add other items, but it was the same.. Iam downloading the right file (mangos file)... Also i was trying

to delete the "dmg_min1" from the sql file with the value but then it told me error with "dmg_min2" and so on.. Please can u tell me what to do to make it

work? I had Arcemu server before and i havent got any problems wih it...

[Meltie]

Ok so this is really weird.. I was trying to make some custom items on wow-v.com, but whenever i tried to

add it to database, it told me this error : SQL ERROR(1054) : Unknown Column 'dmg_min1' in 'field list'... I dont undestand it cause i was adding bracers and it

has nothing to do with damage .. I also tried to add other items, but it was the same.. Iam downloading the right file (mangos file)... Also i was trying

to delete the "dmg_min1" from the sql file with the value but then it told me error with "dmg_min2" and so on.. Please can u tell me what to do to make it

work? I had Arcemu server before and i havent got any problems wih it...

Most project database structures are different, and wow-v doesn't have updated structures for the custom items part.

Double check the structure lineup within the database to make sure all the fields are counted for. Another thing you can do, is compare the structures and see what's different between them.

[krill]

Most project database structures are different, and wow-v doesn't have updated structures for the custom items part.

Double check the structure lineup within the database to make sure all the fields are counted for. Another thing you can do, is compare the structures and see what's different between them.

Alternatively he could look in the DB it's self and manually apply what he wants and use the wiki as a reference. I'd find that at least 3x easier instead of manually comparing and screwing around with Query tables.

[Dkocir]

Krill.. I looked for it and.. I compared values and everything.. The problem is that i cant find value "armor".. I found the "dmg" and changed it to "DamageType".

Problem is , that i tried to find the real name of the "armor" value but, i searched for items in database and i tried to find the number of armor in item but i didnt

find the number of armor .. WTF ? Really weird.. (i was searching it in table "item_template" .. ) And also i looked for the wiki here : http://wiki.wowresource.eu/index.php/Mangos_world_item_template

.. And .. Its old .. Its not for the new MaNGOS 3