dex360 Posted August 17, 2009 Share Posted August 17, 2009 cool :O n1 Link to comment Share on other sites More sharing options...
badriniki Posted September 19, 2009 Share Posted September 19, 2009 Nice share, thanks ! Link to comment Share on other sites More sharing options...
Nik Posted September 19, 2009 Share Posted September 19, 2009 kinda suck cuz it will fak up everything... players will have hard time with these titles that have replaced the NPCs default Link to comment Share on other sites More sharing options...
p1p1 Posted September 20, 2009 Share Posted September 20, 2009 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 ;) Link to comment Share on other sites More sharing options...
D0urm0uk1 Posted September 20, 2009 Share Posted September 20, 2009 nice man ty for giude Link to comment Share on other sites More sharing options...
npro Posted September 21, 2009 Share Posted September 21, 2009 Good information, thank you. Link to comment Share on other sites More sharing options...
Drasius Posted September 27, 2009 Author Share Posted September 27, 2009 Np :P i'm happy for helping someone. Link to comment Share on other sites More sharing options...
Nefer Posted September 27, 2009 Share Posted September 27, 2009 Nothing to special, but good share for newbie ;) Link to comment Share on other sites More sharing options...
SirDarkAngel Posted September 27, 2009 Share Posted September 27, 2009 Thanks man nice share. Link to comment Share on other sites More sharing options...
tasha Posted September 29, 2009 Share Posted September 29, 2009 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'; Link to comment Share on other sites More sharing options...
d0ds™ Posted September 29, 2009 Share Posted September 29, 2009 thanks! but I downloaded the file, It won't run. Link to comment Share on other sites More sharing options...
DarkHacker Posted January 6, 2010 Share Posted January 6, 2010 ty i do untill with navicat one one all the titles xaxa Link to comment Share on other sites More sharing options...
azizilaika Posted January 6, 2010 Share Posted January 6, 2010 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'; Link to comment Share on other sites More sharing options...
Mitjuh Posted January 6, 2010 Share Posted January 6, 2010 well easy but usefull =D gj ;) Link to comment Share on other sites More sharing options...
Xd3sT1nYX Posted January 8, 2010 Share Posted January 8, 2010 :O ty man i was tyred of editing the npcs Title!! Link to comment Share on other sites More sharing options...
Recommended Posts