[SHARE] Change all server npc Tittle's in 1 second!

[linkinpark21]

i was looking for that ty :P

[vipergtrs]

thank you all coders good work

[CriticalError]

well simple work but really good mate ty

[rodox]

UPDATE `npc` SET `title`='Your Title', `serverSideTitle`='1' where 'type' not like 'L2Monster';

Tx azizilaika for your optimised code.

[Ghouls]

Link its broken.

[Coyote™]

Link its broken.

Indeed, Locked.

If the author is willing to update it, PM me to unlock it.

 

EDIT: Topic Unlocked, the author is willing to update the link.

[Drasius]

Link updated:

 

http://www.4shared.com/account/file/256797709/20727799/sql.html

[wazadrian]

it's old topic  ;) but thx for refresh i need this

[labman]

ha! It's very funny... simple share

[d0ds™]

lol...that SQL code is totally wrong if you say its npc's its funny because mobs/raidbosses...etc..etc will get a title too

 

This should do the right thing :D

 

UPDATE `npc` SET `title`='Your Title', `serverSideTitle`='1' where 'type'='L2Npc';

UPDATE `npc` SET `title`='Your Title', `serverSideTitle`='1' where 'type'='L2Guard';

UPDATE `npc` SET `title`='Your Title', `serverSideTitle`='1' where 'type'='L2Merchant';

UPDATE `npc` SET `title`='Your Title', `serverSideTitle`='1' where 'type'='L2Teleporter';

UPDATE `npc` SET `title`='Your Title', `serverSideTitle`='1' where 'type'='L2Warehouse';

UPDATE `npc` SET `title`='Your Title', `serverSideTitle`='1' where 'type'='L2Trainer';

UPDATE `npc` SET `title`='Your Title', `serverSideTitle`='1' where 'type'='L2VillageMaster';

UPDATE `npc` SET `title`='Your Title', `serverSideTitle`='1' where 'type'='L2PetManager';

UPDATE `npc` SET `title`='Your Title', `serverSideTitle`='1' where 'type'='L2Auctioneer';

UPDATE `npc` SET `title`='Your Title', `serverSideTitle`='1' where 'type'='L2SymbolMaker';

UPDATE `npc` SET `title`='Your Title', `serverSideTitle`='1' where 'type'='L2FestivalGuide';

UPDATE `npc` SET `title`='Your Title', `serverSideTitle`='1' where 'type'='L2ClassMaster';

UPDATE `npc` SET `title`='Your Title', `serverSideTitle`='1' where 'type'='L2PetManager';

UPDATE `npc` SET `title`='Your Title', `serverSideTitle`='1' where 'type'='L2SymbolMaker';

UPDATE `npc` SET `title`='Your Title', `serverSideTitle`='1' where 'type'='L2FestivalGuide';

UPDATE `npc` SET `title`='Your Title', `serverSideTitle`='1' where 'type'='L2NpcWalker';

UPDATE `npc` SET `title`='Your Title', `serverSideTitle`='1' where 'type'='L2OlympiadManager';

UPDATE `npc` SET `title`='Your Title', `serverSideTitle`='1' where 'type'='L2FisherMan';

UPDATE `npc` SET `title`='Your Title', `serverSideTitle`='1' where 'type'='L2Adventurer';

 

 

this is better..

Some NPC Title Must not be change for some reasons.

 

-~ Edit ~-

My topic related or the same as this, was locked because it was in a wrong section according to Matim?

:)

hmmmp..

so why this thread still open?

[Andrey™]

Link is DeaD:(