Jump to content

Trinitycore2 to Mangos


Guest Bogdan_012794

Recommended Posts

i need help to convert item_instance (trinity 9530) to mangos 10431. this table originaly was changed in 9090, just, not know, how to match few collumns data to one...

http://pastebin.com/akdhwRfi tc 9530+

i renamed tc table to ..._old and inserted mangos table, this is almost working, just, not know, how to add space between guid and creatorguid in concat function

replace into item_instance (`guid`,`owner_guid`,`text`,`data`)

select guid,owner_guid,`text`,concat(guid,`creatorGuid`,`giftCreatorGuid`,`count`,`duration`,`charges`,`flags`,`enchantments`,`randomPropertyId`,`durability`,`playedTime`,`text`) from item_instance_old;

Link to comment
Share on other sites

  • 5 weeks later...

Yo can try this:

replace into item_instance (`guid`,`owner_guid`,`text`,`data`)
select guid,owner_guid,`text`,concat(guid,' ',`creatorGuid`,' ',` giftCreatorGuid`,' ',`count`,' ',`duration`,' ',`charges`,' ',`flags`,' ',`enchantments`,' ',`randomPropertyId`,' ',`durability` ,' ',`playedTime`,' ',`text`) from item_instance_old;

But i don't know if it works.

Link to comment
Share on other sites

  • 1 month later...
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use