SQL Developer

thank a lot budy also i want to tell because of frozen rev this doesnt work,for people who you like to add this on there servers use this
### Eclipse Workspace Patch 1.0 #P L2jFrozen_GameServer Index: head-src/com/l2jfrozen/gameserver/network/clientpackets/EnterWorld.java =================================================================== --- head-src/com/l2jfrozen/gameserver/network/clientpackets/EnterWorld.java (revision 1097) +++ head-src/com/l2jfrozen/gameserver/network/clientpackets/EnterWorld.java (working copy) @@ -49,10 +49,12 @@ import com.l2jfrozen.gameserver.model.L2Character; import com.l2jfrozen.gameserver.model.L2Clan; import com.l2jfrozen.gameserver.model.L2Effect; +import com.l2jfrozen.gameserver.model.L2Object; import com.l2jfrozen.gameserver.model.L2Skill; import com.l2jfrozen.gameserver.model.L2World; import com.l2jfrozen.gameserver.model.actor.instance.L2ClassMasterInstance; import com.l2jfrozen.gameserver.model.actor.instance.L2ItemInstance; +import com.l2jfrozen.gameserver.model.actor.instance.L2NpcInstance; import com.l2jfrozen.gameserver.model.actor.instance.L2PcInstance; import com.l2jfrozen.gameserver.model.base.ClassLevel; import com.l2jfrozen.gameserver.model.base.PlayerClass; @@ -92,6 +94,7 @@ import com.l2jfrozen.gameserver.network.serverpackets.QuestList; import com.l2jfrozen.gameserver.network.serverpackets.ShortCutInit; import com.l2jfrozen.gameserver.network.serverpackets.SignsSky; +import com.l2jfrozen.gameserver.network.serverpackets.SpecialCamera; import com.l2jfrozen.gameserver.network.serverpackets.SystemMessage; import com.l2jfrozen.gameserver.network.serverpackets.UserInfo; import com.l2jfrozen.gameserver.powerpak.PowerPakConfig; @@ -508,6 +511,144 @@ private void onEnterNewbie(L2PcInstance activeChar) { + /* ****************************** Camera MOD ****************************** */ + // 1 actived, 0 deactived + int activemod = 1; + + // 1th value: ID + // 2nd value: Distance between char and camera + // 3th value: Left-Right angle of camera starting position + // 4th value: Up-Down angle of camera starting position + // 5th value: time in which "turn" and "rise" will take effect + // 6th value: total time of the camera effect + + activeChar.sendPacket(new ExShowScreenMessage("Welcome to Lineage II Cyber Reborn!", 6000)); + + try + { + Thread.sleep(2000); + } + catch (InterruptedException e) + { + e.printStackTrace(); + } + + int NPC1 = 0; + int NPC2 = 0; + int NPC3 = 0; + int NPC4 = 0; + + // Configurable + // Here you can change npc name and the message + String NPCname1 = "GM Shop"; + String MessageNPC1 = "Here you can buy equipment for free!!"; + + String NPCname2 = "Special Shop"; + String MessageNPC2 = "Here you can buy special equipments to become stronger!"; + + String NPCname3 = "Gatekeeper"; + String MessageNPC3 = "With Gatekeeper you can go anywhere you want!!"; + + String NPCname4 = "Pepper"; + String MessageNPC4 = "Here you can add your Dyes!"; + // End Config + + for (final L2Object npc : activeChar.getKnownList().getKnownObjects().values()) + { + if (!(npc instanceof L2NpcInstance)) + continue; + + if (npc.getName().equals(NPCname1) && NPC1 != 1) + { + activeChar.setTarget(npc); + final int gottarget = activeChar.getTarget().getObjectId(); + + activeChar.sendPacket(new SpecialCamera(gottarget, 50, 120, 15, 1000, 6000)); + activeChar.sendPacket(new ExShowScreenMessage(MessageNPC1, 3000)); + + try + { + Thread.sleep(5000); + } + catch (InterruptedException e) + { + e.printStackTrace(); + } + + NPC1 = 1; + continue; + } + + if (npc.getName().equals(NPCname2) && NPC2 != 1) + { + activeChar.setTarget(npc); + final int gottarget = activeChar.getTarget().getObjectId(); + + activeChar.sendPacket(new SpecialCamera(gottarget, 50, 120, 15, 2000, 6000)); + activeChar.sendPacket(new ExShowScreenMessage(MessageNPC2, 3000)); + + try + { + Thread.sleep(5000); + } + catch (InterruptedException e) + { + e.printStackTrace(); + } + + NPC2 = 1; + continue; + } + + if (npc.getName().equals(NPCname3) && NPC3 != 1) + { + activeChar.setTarget(npc); + final int gottarget = activeChar.getTarget().getObjectId(); + + activeChar.sendPacket(new SpecialCamera(gottarget, 50, 145, 15, 3000, 6000)); + activeChar.sendPacket(new ExShowScreenMessage(MessageNPC3, 3000)); + + try + { + Thread.sleep(5000); + } + catch (InterruptedException e) + { + e.printStackTrace(); + } + + NPC3 = 1; + continue; + } + + if (npc.getName().equals(NPCname4) && NPC4 != 1) + { + activeChar.setTarget(npc); + final int gottarget = activeChar.getTarget().getObjectId(); + + activeChar.sendPacket(new SpecialCamera(gottarget, 50, 50, 15, 4000, 6000)); + activeChar.sendPacket(new ExShowScreenMessage(MessageNPC4, 3000)); + + try + { + Thread.sleep(5000); + } + catch (InterruptedException e) + { + e.printStackTrace(); + } + + NPC4 = 1; + continue; + } + } + + activeChar.setTarget(null); + + /* ****************************** Camera MOD ****************************** */ + if(Config.NEW_PLAYER_EFFECT)

Gia ta grand boss opos valakas,aq,baium ktlp pas sto navicat -> grandboss_data -> x,y,z (to xyz to vriskeis mesa sto game pas p.x ekei pou 9es na kaneis spawn to raid boss kai grafeis to command /loc) kai to allazeis sto navicat
 
Gia ta upoloipa mobs/normal rb pas sto navicat->spawnlist kai allazeis to xyz me ton idio tropo
 
Gia na allakseis ta drop se kapoio rb pas navicat -> droplist -> kai vriskeis to id tou rb pou 9es na epeksergasteis kai apla ta allazeis ..