Illidan's Mall ( Heaven )

[Illidan1]

KK, let me see, i think i didn't eve add the Npc's In it only the spawn
Just wait

[Immortals]

The vendors aren't there for me, and the portals in the main cities arent there, and when I use .go spawn 229922 it says it doesnt exist O_o

[Slippers]

I downloaded Navicat, when I execute batch file it gives me this:

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `creature_names` VALUES ('50000', 'Armor', 'Dungeon I', '0', '4', '0', '3', '0', '0', '18106', '0', '0', '1', '1', '1', '0', '0');
[Msg] Finished - Unsuccessfully

[kayleta]

Wow, this looks great dude

[Illidan1]

Humm, Wired so the Errors are

Executed batch but no Npc / vendors
Executed batch but no Portal..

And Slippers, you get that because you already have the Vendors
in your Database

[Slippers]

I'm sorry, I'm new at this. So the vendors should be there right? or at least in my db. So what is their ID to summon them?

[Illidan1]

50000 - 50080

[Slippers]

Invalid entry ID. Your mall looks beutiful btw.. if only it worked for me =(!

[kristian92]

i get invalid entry 2!

[Ukrajinc]

Can you please tell me how to change the item prices that the vendors are selling.Oh and this mall is great but the only thing that is missing is the rings vendor, while there are 2 off-hand vendors.

[Illidan1]

Ukrajinc try
.npc spawn 20 - 24
one of those is the Ring vendor

[Ukrajinc]

Hey thanks Illidan the vendor' spwn id was 50021.hey can you help me with changing the prices cause i dont want to make things too easy for people.i just need to know how to edit the prices

[Immortals]

The vendors aren't there for me, and the portals in the main cities arent there, and when I use .go spawn 229922 it says it doesnt exist O_o

Yet to get an answer on this...

[Illidan1]

Immortals and Ukrajinc
Go into your Database, and Find the Table called " Items"
In there find the item's that are in the Vendor and Change the Sell PRice
And Buy price to something you wont

1 = 1 Copper, 1000 = 1 Gold, Etc

[Succy]

Haha... I forgot to rep you... But have +Rep :ed you now :P