0 HouLiGaN Posted July 21, 2010 Author Posted July 21, 2010 ye but you may need again in a future. That's why i suggest to delete in game. Well i dont know if im saying it rounge :)...soory for my english but i will try to explain again I want to delete them from spawning were they spawn. I dont want them to be deleted from database :P Get it? so when i put //spawn xxx i want it to spawn only then ... Please someone edit the sql so it will work. its giving me error in navicat
0 EdenEternal Posted July 21, 2010 Posted July 21, 2010 Well i dont know if im saying it rounge :)...soory for my english but i will try to explain again I want to delete them from spawning were they spawn. I dont want them to be deleted from database :P Get it? so when i put //spawn xxx i want it to spawn only then ... Please someone edit the sql so it will work. its giving me error in navicat please tell for example which mob you want delete? p.s tell your pack also
0 HouLiGaN Posted July 21, 2010 Author Posted July 21, 2010 Im noob i ask forgivness! L2j Epilogue pack is that it? In my server I dont want PLAYERS TO BE ABLE TO GO SOMEWERE ND FIND THE MOBS THEY WANT I WANT TO USE custom area with custom mobs and kill them only. To reduce LAG! When i mean custom mobs i dont mean i made my own mobs i mean i got a mob from spawn list and customized drop and stats! Now if theres a sql file that works for me please say if theres not then just tell gm to lock!
0 EdenEternal Posted July 21, 2010 Posted July 21, 2010 i don't know i'm stupid or no but i can't understand... i understand only one you want to delete all Retail Mobs? if yes Open navicat->host Right Click on L2jdb and click Console write where DELETE FROM spawnlist WHERE `npc_templateid` IN (SELECT id FROM npc WHERE type = 'L2Monster') Press Enter and OK
0 HouLiGaN Posted July 21, 2010 Author Posted July 21, 2010 i don't know i'm stupid or no but i can't understand... i understand only one you want to delete all Retail Mobs? if yes Open navicat->host Right Click on L2jdb and click Console write where DELETE FROM spawnlist WHERE `npc_templateid` IN (SELECT id FROM npc WHERE type = 'L2Monster') Press Enter and OK YEY MAN I LOVE YOU IT WORKED!!!! THIS IS WHAT I WANTED NOW LAG DROPED ALOT IN SERVER!!!!!! the othere sql they give me never worked this Works 100% Please somone like gm give him somthing as thnk you!!!!
0 EdenEternal Posted July 21, 2010 Posted July 21, 2010 next if you have sql question post here Question - Answer
Question
HouLiGaN
How do i delete them :P ????
22 answers to this question
Recommended Posts