or you can use this
make .sql files with this command
and just change id
insert into droplist (mobId, itemid, chance, min, max,category) select id, 4037, 1000000, 1, 1, 52 from npc where type='L2Monster';
Delete from Server All Data of Character that is not active more then 1 month.
Code:
DELETE FROM characters WHERE lastAccess < 155520000;
DELETE FROM character_quests WHERE char_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM items WHERE owner_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_shortcuts WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_skills WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_skills_save WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_subclasses WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
Here you are my friend!
hahahah lol....You are most scammer here in forum...Also all your packs are from other players taht you scammed!!And JvE pack was from l2eclipse.org that you scammed the admin!!Anywhey if someone wants to get scammed and lost his money, just pm to Gekas..He is professional for that!!
Because its crazy to sell l2jpack for 2 euros...So the guy that buy it he should open a server and spend money for deticated,domain,advertisment and other shit and he buy the pack 2 euros???Its full of bugs and i am sure that you dont know to fix them!