[Sollution] Mouse Icons at Newest Revisions

[~ViVo~]

I already did this...

[Da Tank]

Ur the EMU expert to help me most this month

[pepsi1x1]

im sure you could just run a sql query like

obviously changing the 3,15 for the combination of npcflags that can be used on a vendor :P
UPDATE `creature_names` SET `info_str` = 'vendor' WHERE `entry` in (SELECT `entry` from creature_proto where npcflags = 3,15 ) ;

[warxhead]

Dang, you beat me to it.
But here's an example anyway.

Normal Vendor:
UPDATE `creature_names` SET `info_str` = 'buy' WHERE `entry` in (SELECT `entry` from creature_proto where npcflags = 128 ) ;
Repair:
UPDATE `creature_names` SET `info_str` = 'repair' WHERE `entry` in (SELECT `entry` from creature_proto where npcflags = 4224 ) ;
Trainer:
UPDATE `creature_names` SET `info_str` = 'trainer' WHERE `entry` in (SELECT `entry` from creature_proto where npcflags = 16 ) ;
Guard:
UPDATE `creature_names` SET `info_str` = 'directions' WHERE `entry` in (SELECT `entry` from creature_proto where npcflags = 1 ) ;

[pepsi1x1]

haha sorry mate, your queries look prettier than mine on that codebox tho

+Rep for great minds think alike

[Anarchy [RD]]

Hehe, It's hell a lot of work to change all lol :P

not realy, depending on how fast u work, it can take 5 minutes tops

and +Rep for Knaur!

[~ViVo~]

People.. wow.. Look in the guide section, I posted one 12 hours before he did..

*Sigh*
________
I'm out.

[Da Tank]

No u didn't I posted about it first and u talked about deleting the section Knaur actually tells you what to put into info_str so stub being a noob.. god

[knaur]

vivoxity: first thing... this sollution you gave ARE GODDAMN OLD and its like 100 posts before, with the "delete 0 or NULL" sollution.

If you read MY post, you maybe would see that YOUR SOLLUTION DONT WORK FOR EVERYONE goddamnit... do ppl need all in with a spoon these days?

Ok, read this:

Your sollution works for many ppl,
BUT of a strange reason it does NOT work for everyone.
Like on our realms at epicwow, when we have info_str
all empty, its still NO ICONS! (yeah, ofcourse i deleted cache folder.....)

BUT my sollution WORKS for ALL databases with info_str field,
because my sollution is actually the one that normally
shall be used for icons (what burlex made the field for)

NCDB has started now with filling in this info in theyr tables at svn.

if you write like this word in the field: Directions
the directions icon will come

if you write this word: repair
the repair icon will show.

So in other word: MY SOLLUTION IS A WHOLE DIFFERENT THAN YOUR
SOLLUTION THAT ALREADY EVERYONE KNOW FROM BEFORE

so shut the **** up before you get banned from mmowned

[Da Tank]

I guess so cuz he made a post like if anyone cared.. saying he is leaving the EMU section for ppl stealing his GREAT CONTRIBUTIONS.. lol w/e dude needs to grow up.... Btw Knaur this worked for sum custom guards but i cant seem to find my custom mall =P Any help??

[knaur]

use .npc info on the npc,s in game, then you get spawn id.
when you have the spawn id,s its easyer to find them in database

[Da Tank]

thanxs alot man.. i think i can rep u now that 24 hour cooldown is gone

[Anarchy [RD]]

Wooo Knaur is from Epic WoW, which means he must be EPIC!!!

yes that was lame, but he is still EPIC lol

Edit: better?

[Da Tank]

naa Knaur is Epix

[knaur]

hehe =) hmm, missing the pink color for epic lol