Details Changelog 1 Review 7 Comments Смердокрыл 191 Posted July 2, 2016 It's for WotLK, right? Link to comment Share on other sites Bronzegear 2 Posted September 21, 2016 Does it contain newer models, like from WoD? Link to comment Share on other sites Amaroth 549 Posted November 25, 2016 My apologies for not responding earlier. This is for WotLK. It contains only displayIDs for all models in WotLK client, it doesn't contain any retro ported models or similiar kind of stuff. I'm going to release a tool used for creating this release to give you possibility to make something like this on your own and to use this even on retro-ported models. Link to comment Share on other sites Amaroth 549 Posted November 27, 2016 For generating your own one, you can use this: Link to comment Share on other sites Смердокрыл 191 Posted March 27, 2017 Hey! I tried to run that SQL file (the light version) on my server, but it only produces this error for every single object: Spoiler [Err] 1054 - Unknown column 'faction' in 'field list' [Err] REPLACE INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `AIName`, `ScriptName`, `VerifiedBuild`) VALUES (421401, 5, 21401, 'AbolishMagic_Base.m2 [AmPatch]', '', '', '', 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 12340); Link to comment Share on other sites Amaroth 549 Posted April 9, 2017 This is an older version of my patch which might not work on some databases. It seems that TrinityCore dev have yet again for absolutely no good reasons renamed some field 'cause fuck backwards compatibility. As you can see, query is trying to insert value to field 'faction', which, according to your MySQL server, doesn't exist (so its most likely renamed to something else). I'd suggest you to try creating this patch by yourself by running my gob generating tool (its linked in this patch's description). It will generate similiar SQL, but one which should be far more compatible with other version of database. If even using my tool to generate your own patch that doesn't work... You need to open SqlBackup.sql in my tool's folder and change field name(s) to match your database (by some mass-text editing software, most applications for programming have this, and nearly any decent document editing software should also have an option to replace all instances of one word with another one). Link to comment Share on other sites ayahne 33 Posted March 15, 2019 hello there i spawned everysingle objects from your relase but there are a list of missing object gameobject_template_trinity.sql could you add them to dbc file? most of the wotlk objects. Link to comment Share on other sites
Bronzegear 2 Posted September 21, 2016 Does it contain newer models, like from WoD? Link to comment Share on other sites
Amaroth 549 Posted November 25, 2016 My apologies for not responding earlier. This is for WotLK. It contains only displayIDs for all models in WotLK client, it doesn't contain any retro ported models or similiar kind of stuff. I'm going to release a tool used for creating this release to give you possibility to make something like this on your own and to use this even on retro-ported models. Link to comment Share on other sites
Amaroth 549 Posted November 27, 2016 For generating your own one, you can use this: Link to comment Share on other sites
Смердокрыл 191 Posted March 27, 2017 Hey! I tried to run that SQL file (the light version) on my server, but it only produces this error for every single object: Spoiler [Err] 1054 - Unknown column 'faction' in 'field list' [Err] REPLACE INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `AIName`, `ScriptName`, `VerifiedBuild`) VALUES (421401, 5, 21401, 'AbolishMagic_Base.m2 [AmPatch]', '', '', '', 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 12340); Link to comment Share on other sites
Amaroth 549 Posted April 9, 2017 This is an older version of my patch which might not work on some databases. It seems that TrinityCore dev have yet again for absolutely no good reasons renamed some field 'cause fuck backwards compatibility. As you can see, query is trying to insert value to field 'faction', which, according to your MySQL server, doesn't exist (so its most likely renamed to something else). I'd suggest you to try creating this patch by yourself by running my gob generating tool (its linked in this patch's description). It will generate similiar SQL, but one which should be far more compatible with other version of database. If even using my tool to generate your own patch that doesn't work... You need to open SqlBackup.sql in my tool's folder and change field name(s) to match your database (by some mass-text editing software, most applications for programming have this, and nearly any decent document editing software should also have an option to replace all instances of one word with another one). Link to comment Share on other sites
ayahne 33 Posted March 15, 2019 hello there i spawned everysingle objects from your relase but there are a list of missing object gameobject_template_trinity.sql could you add them to dbc file? most of the wotlk objects. Link to comment Share on other sites