linkinpark21 Posted January 9, 2010 Share Posted January 9, 2010 i was looking for that ty :P Link to comment Share on other sites More sharing options...
vipergtrs Posted January 13, 2010 Share Posted January 13, 2010 thank you all coders good work Link to comment Share on other sites More sharing options...
CriticalError Posted January 14, 2010 Share Posted January 14, 2010 well simple work but really good mate ty Link to comment Share on other sites More sharing options...
rodox Posted January 24, 2010 Share Posted January 24, 2010 UPDATE `npc` SET `title`='Your Title', `serverSideTitle`='1' where 'type' not like 'L2Monster'; Tx azizilaika for your optimised code. Link to comment Share on other sites More sharing options...
Ghouls Posted April 1, 2010 Share Posted April 1, 2010 Link its broken. Link to comment Share on other sites More sharing options...
Coyote™ Posted April 1, 2010 Share Posted April 1, 2010 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. Link to comment Share on other sites More sharing options...
Drasius Posted April 4, 2010 Author Share Posted April 4, 2010 Link updated: http://www.4shared.com/account/file/256797709/20727799/sql.html Link to comment Share on other sites More sharing options...
wazadrian Posted August 20, 2010 Share Posted August 20, 2010 it's old topic ;) but thx for refresh i need this Link to comment Share on other sites More sharing options...
labman Posted October 28, 2010 Share Posted October 28, 2010 ha! It's very funny... simple share Link to comment Share on other sites More sharing options...
d0ds™ Posted October 28, 2010 Share Posted October 28, 2010 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? Link to comment Share on other sites More sharing options...
Andrey™ Posted October 31, 2010 Share Posted October 31, 2010 Link is DeaD:( Link to comment Share on other sites More sharing options...
Recommended Posts