• Like 4

1 Screenshot

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

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

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




User Feedback