Illidan's 2.3.0 Mall ( Scarlet's Hand )

[fresh]

as always nice mate

marry christmas to all i just added this mall area but i have a small problem the pack i am useing already had a .tele port mall in so i need the coords to this mall to check it out please and thank you

[Illidan1]

.recall port tyr

[fresh]

.recall port tyr didnt work neather

[Illidan1]

.worldport 0 1683.56 -5329.52 74.6664

MapID = 0
x = 1683.56
y = -5329.52
z = 74.6664

[fresh]

thanks so much bro hope you have a marry christmas the mall looks nice+Rep2

[fresh]

allmost all the vendor give free items how we fix this ?

[Illidan1]

you will need to need to change the Price in Items tables all to what you wont
And that is over 22'000 items

[Wheeze201]

Great work !

I might use this someday

[Moederkoek]

GG - I tried it again, now all NPC's are gone, and the 'fixed' SQL's' vendor's still make my wow crash, damnit :<

[Illidan1]

Humm, Meh, kinda old Mall now anyway , you should see what im doing know

[Moederkoek]

Lol, what you call old ... I like it mate, but I want it to work... I backed up the server so it's no big deal but it doesn't works :<

Btw - Can you make one in SHatt? ;o

[Illidan1]

lol na i don't like Shattrath

when my new one comes out every one will Die of how kool it is

[Jimzor]

Very helpfull ! ^^ GJ!

[Wheeze201]

It always says "Duplicate entry 40000" or "Duplicate entry 199199" .. i've deleted both the 40000 and 199199 entries from Creature_names but it still comes up !

WTF ?

These .sql files are glitchy as hell

[Wheeze201]

I saw that i already had "Mr free free" and that kill for skill creature..so i removed all sql codes that inserted into creature_names or creature_proto and there was only insert into creature_spawn and gameobject spawns.

And they still don't work.
I was able to execute the recall location sql script though.