Hello, i was using arcemu and decided change to Trinitycore now i have problem whit all me custom items, i am trying to convert it to trinity whit this sql: http://pastebin.com/bP8Tz1Ty but it says me : Column count doesn’t match value count at row 1, i have copied all of the rows correctly if some1 can take a look on it if something is wrong, thanks.
Btw sorry if posting in wrong section.
The fields of INSERT have to match the fields of the SELECT query.
F.ex you have these fields in INSERT ScriptName, DisenchantID, FoodType, minMoneyLoot, maxMoneyLoot but no equivalent in SELECT.
mmmmmmmmmm its normal cause arcemu have different tables than trinitycore =EEi want to convert all me custom items from arc to tc D;
Both arc and TC use the same fields for item_template (we have to, as does arc), however, we name our fields differently. You need to know what field names that arc uses, and match them up to their equivalents in TC. item_template is one of the few tables that ALL emulators have to use the same fields, but they may name them differently.
If you post the fields that arc uses, I can tell you what they match up to in TC.
– Brian
Thanks for reply, here you have all arc fields : http://pastebin.com/yr4nvgX1
i gonna be so happy if u make dat sql for me =D.
You have to learn mySQL syntax and read my answer again. /emoticons/default_smile.png
And this:
LoL, i understand perfectly what you mean, i just don’t know what rows to match, as Brian said, and don’t let me google cause i always google and regoogle me problems and if i don’t find the answer then i post on forums…
But I told you already /emoticons/default_wink.png
F.ex you have these fields in INSERT ScriptName, DisenchantID, FoodType, minMoneyLoot, maxMoneyLoot but no equivalent in SELECT.
In fact you try to insert these fields but you don’t have equivalent field in the SELECT query. Because these fields exist in TC only, not in ArcEmu.
May there are some other fields with problems, I didn’t checked all of them /emoticons/default_biggrin.png
Okay thx for reply i go try to match them all but i need to know the equivalent in TC
You must read my answers more exactly: Because these fields exists in TC only, not in ArcEmu.
This means there are no equivalents. Remove these fields in the INSERT part of your SQL query. The fields will be filled with default values.
Good Luck.
Ohh shi**et its true, i know what you mean now, thanks for reply.
I made an application to convert arcemu items to trinitycore:
http://www.mediafire.com/download/tl0uqjx0t3nfg0w/CAIT_v1.zip
Thank’s but when i convert item it don’t change nothing and still can’t upload to db
For example export an item from arcemu db as .sql then convert it
mmm okey ill try that way