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

[Drasius]

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:

 

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/account/file/256797709/20727799/sql.html

 

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

 

Just execute with navicat .sql file  ;)

[LouLou]

Very nice its was boring to mak the npcs one one

[jossoo]

oO nice share...this is nice sql code..tnx :)

[Intrepid]

or you can make it as a voiced command:)

[Vago]

update npc SET title = 'title' where id > 1;

update npc SET serverSideTitle = '1' where id > 1;

 

better...

[DragonHunter]

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

 

[marius200597]

nice share :)

 

[hoangnhan]

Great guide,

Thank all.

[loverplus_kr]

Great guide,

Thank all.

[neptun444]

nice guide ty for the share ;)

[Neo1993k]

Amazing share,usefull program, Ty for it!

[Inesko0]

great thx  :) :)

[vamav3che]

thanx , testing.

[Orgyilkos]

All npc title editing (1sec) [ EASY ]

UPDATE npc SET title = "Your Tittle";

UPDATE npc SET serverSideTitle = "1";

 

All npc name editing (1sec) [ EASY ]

UPDATE npc SET name = "Your Tittle";

UPDATE npc SET serverSideName = "1";

[zeenith]

really nice share thnks