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

[dex360]

cool :O n1

[badriniki]

Nice share, thanks !

[Nik]

kinda suck cuz it will fak up everything... players will have hard time with these titles that have replaced the NPCs default

[p1p1]

I created simple code with which you can change your server all npc tittles in few seconds..

 

I think its very usefull for all newbies.  ;)

 

Its a sql code:

 

plzz man link no found, refresh link plz

 

update npc SET title = 'www.MaxCheaters.Com' where id between 1 and 99999;

update npc SET serverSideTitle = '1' where id between 1 and 99999;

update npc SET serverSideName = '1' where id between 1 and 99999;

 

If you dont know how to add this.. Just download full sql file

 

http://www.4shared.com/file/91472236/aab0e6ff/change_npc_Tittle_by_Drasius.html

 

Hope it helps for someone.. Works for all versions!

 

Just execute with navicat .sql file  ;)

[D0urm0uk1]

nice man ty for giude

[npro]

Good information, thank you.

[Drasius]

Np :P i'm happy for helping someone.

[Nefer]

Nothing to special, but good share for newbie  ;)

[SirDarkAngel]

Thanks man nice share.

[tasha]

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';

 

 

 

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

 

[d0ds™]

thanks! but I downloaded the file, It won't run.

[DarkHacker]

ty i do untill with navicat one one all the titles xaxa

[azizilaika]

 

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

 

This won't work.

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

[Mitjuh]

well easy but usefull =D gj ;)

[Xd3sT1nYX]

:O ty man i was tyred of editing the npcs Title!!