*QUESTION* Vendor ID Display

[thegame240]

Hey! Whatz Up! i have one question can u tell me some cool id for make mall with it thanks!

[TheSpidey]

For creatures? You can just go around sampling existing npcs with .npc info,
Or make a macro to set your display ID to the current one +1 and find a good one

[thegame240]

yeah i found one great :P but i have other problem how can i change my vendors id display when i change it with that it doesnt work

UPDATE creature_spawns SET displayid = '8379' WHERE entry between '80000' and '80066';
UPDATE creature_names SET type = '7' WHERE entry between '80000' and '80066';

[TheSpidey]

DisplayID is in creature_proto or creature_names.

[thegame240]

ok thanks !

nahh it doesnt work

[TheSpidey]

You have to be more specific. What SQL statement did you run?

[thegame240]

ABD or somthin like that and i use Navicat

[TheSpidey]

No, when you updated the creature. Post the statement.

[thegame240]

so i put that

UPDATE creature_names SET displayid = '8379' WHERE entry between '80000' and '80066';

and it says

[Err] 1054 - Unknown column 'displayid' in 'field list'
[Err] UPDATE creature_names SET displayid = '8379' WHERE entry between '80000' and '80066';
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[TheSpidey]

1054 - Unknown column 'displayid' in 'field list'
Kinda says it all. There's no field called "displayid".
Take a look at this for more info: http://wiki.ascentemu.com/index.php?..._documentation

[thegame240]

i think u put wrong link

Edit: Nope its closed !

[TheSpidey]

Bah.
Well, time to open your creature_names table and check the names for yourself

[Tornad0z]

If you got AC Web, there is some vendors with id 60000 and up to 68000 i think