[Trinity] [3.3.5] {Ultimate} Transmog Mall.

[mindsear]

Just updated Phil's Transmog Mall script for the latest TrinityCore rev. TDB 335.61 (Aug-27-2016)

[3.3.5] Transmog Mall: http://pastebin.com/MA2LViJ8

[3.3.5] Transmog NPC's SPAWN: http://pastebin.com/pEwcq8Qz

 

[chase vis]

Just updated Phil's Transmog Mall script for the latest TrinityCore rev. TDB 335.61 (Aug-27-2016)

[3.3.5] Transmog Mall: http://pastebin.com/MA2LViJ8

[3.3.5] Transmog NPC's SPAWN: http://pastebin.com/pEwcq8Qz

+rep

thank you for your work

 

[Brunolopes]

Just updated Phil's Transmog Mall script for the latest TrinityCore rev. TDB 335.61 (Aug-27-2016)

[3.3.5] Transmog Mall: http://pastebin.com/MA2LViJ8

[3.3.5] Transmog NPC's SPAWN: http://pastebin.com/pEwcq8Qz

many thanks I actually needed this so hard! +rep!

 

[philippovitch]

thank you a lot for updating my work. i had a lot of work this days got so busy !

 

[celinemessi]

Hello guys and thx for this shop, but the sql have a problem for me... :
Error SQL (1054) : Unknow column 'InhabitType' in 'field list'
so please help me what can i do? add a new colum in creature template? or custom the sql script?

 

[mindsear]

Hello guys and thx for this shop, but the sql have a problem for me... :
Error SQL (1054) : Unknow column 'InhabitType' in 'field list'
so please help me what can i do? add a new colum in creature template? or custom the sql script?

I've just updated Phil's Transmog mall for TrinityCore rev. TDB 335.64 (Jul-25-2018)

[3.3.5] Transmog Mall: https://gist.github.com/mindsear/b224a6d5a0e1b73a03bbc144cd0d63f7

Enjoy!

 

[celinemessi]

Oh my god thanks you very much

I have a little question, i downloaded the transmogvendor but i want to transmog with item in my bag not with the item vendor how can i do?

- - - Updated - - -

And please another question, is that hard to up to date an sql file? like u did before for this script?

 

[philippovitch]

I've just updated Phil's Transmog mall for TrinityCore rev. TDB 335.64 (Jul-25-2018)

[3.3.5] Transmog Mall: https://gist.github.com/mindsear/b224a6d5a0e1b73a03bbc144cd0d63f7

Enjoy!

Wow been long time i didin't returned to this thread thanks for updating it mindsear.

Oh my god thanks you very much

I have a little question, i downloaded the transmogvendor but i want to transmog with item in my bag not with the item vendor how can i do?

- - - Updated - - -

And please another question, is that hard to up to date an sql file? like u did before for this script?

I Didin't get it, you got TransmogVendor from Rochet2 ? and you want to Transmog items from your bag? then just add his blizzlike Transmog Vendor " http://rochet2.github.io/Transmogrification "

It's not hard mainly if you know what have changed, with notepad++ and "some regex (not really needed)" also it's not really complicated in this case you can also re-create the "npc vendor" part which is copy-paste mainly. it's just very long..

 

[celinemessi]

Thank you very much that just what i needed to know. But i can add 2 different transmog vendor type?

In the new sql from mindsear there are just wow tlk transmogs and not tbc and vanilla just want to signal it!

 

[pennybox]

not working with current revision.

- - - Updated - - -

anyone updating?

 

[GlebJM]

3 3 5 Ultimate Transmog Mall

Summon Existing Fleet has an issue where the ships that jump to you wont carry out new orders. Removing them from your squad and adding them in again seemed to fix it.

 

[dickyiko]

My bad sorry xD

 

[Brunolopes]

anyone got this updated?

 

[philippovitch]

anyone got this updated?

I do not maintain my scripts anymore. but by reading my original code only the entry, name, and subname of the creature_template are being set. the rest of the code should be able to run on any db revision that has an item_template.

I made for you a simple javascript program that generates for you all the vendors entries, so you do not have to request an update every time.

https://gist.github.com/callmephil/969998828b699eefd26f#file-updater-js

you must change line 16, with your own creature template / db structure.

You can run the code with nodejs if you have that on your pc. Or use any browser console by right-clicking + inspect.

I'm pretty sure there's a modern way of doing it tho, so if anyone has an alternative feel free to comment and I'll update the original post with your name on it.

 

[Brunolopes]

I will be home in 1 hour i will have a look! thanks!

 

[Brunolopes]

swaped the line 16 with
const creature_template = (entry, name, subname) => {
return `(${entry},'0','0','0','0','0','27822','0','0','0',${name},${subname}, NULL, 0, 80, 80, 0, 35, 4225, 1, 1.14286, 0.25, 3, 0, 0, 0, 1, 1, 1, 0, 2048, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 1, 1, 1, 1, 1, 0, 0, 1, 0, 0, 0, '0', 12340);,`;
};

installing that softwere to run the code right now

it still doesnt work i know its me who´s doing something wrong but still cant figure it out xD

 

[philippovitch]

swaped the line 16 with
const creature_template = (entry, name, subname) => {
return `(${entry},'0','0','0','0','0','27822','0','0','0',${name},${subname}, NULL, 0, 80, 80, 0, 35, 4225, 1, 1.14286, 0.25, 3, 0, 0, 0, 1, 1, 1, 0, 2048, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 1, 1, 1, 1, 1, 0, 0, 1, 0, 0, 0, '0', 12340);,`;
};

installing that softwere to run the code right now

it still doesnt work i know its me who´s doing something wrong but still cant figure it out xD

It's probably due to the closing of your query

);,`;

should either be ), for mulitline insert or ); for single line insert `; this closes the javascript string declaration.