SQL Developer

Well my target for now is to fix the droplist (the target of the post is to find people that would like to help to do that in order to help java go one step forward,at least on droplist part)

Hello everyone,my name is George and i am from Greece. -My real life job is ERP manager My idea was very simple and easy,there is many source developers on lineage section but i never saw a database developer so L2Java DB is unstable and no-real drop rates and chances. And here we come .. My idea is to fix the whole l2java database part and i will start by fixing the droplist of all mobs, I am gonna use one original l2off database (website like pmfun,or even pmfun) to find the real l2off drops and use them to our l2j db For start lets take a look at the "plan": Now lets look one by one the steps: *Here we gonna find out the real mob droplist on pmfun *Here we gonna find out the npc name id in order to continue to the next step(for this step we can write sql in our database or use l2 db websites to find the npc id) *Now we have to use the mob id that we found to find out the droplist of it *Now there is only items id and no item names,in order to find out what is this id names we must use sql for one more time: And now we must use online percentage calculator in order to correct the drop chances (as you can see on pmfun sometimes there is 1/300) so lets use this calculator.. http://www.calculatorsoup.com/calculators/games/odds.php And now we must just correct the drop rates. *p.s: you can see 4-6 digits,this mean for example: 70% is 70 and "0000" so 70% is 70.0000 , 1% is 1.0000, and 0,5% is 5000 .. This is not just a guide,this project need a lot of work to complete but we can create lineage emulator with the exact values of official lineage, already many project managers work on the l2j emulation source like l2jacis and they try hard to complete this part of the source, If anyone want to work with me,send a pm because the job request a basic knowledge of sql please i want to work with people that know basics of sql . When this project will complete we gonna work on other unstable things ..

Hello i will rework all l2jfrozen npc drops and i want one original database website like pmfun that have 100% l2off drop chances,anyone know a trustful website ?

thanks a lot buddy

Hello i am looking for c5 source (because the sources are old all the links is dead and not available) so if anyone got any source please contact with me or paste a link down below ..thanks a lot

Hello,i am a player on l2dawn now and Xel was the developer of this server and server was great but admin did some bad actions and server now is dead (30% is about summer period,but still).. So our clan looking for a nice low rate new server to join (L2OFF only) Thanks!

Well the point is what you want to play .. for example if there is a server with high population that mean player competition will be bigger ... player competition bigger=botters .. where is botters and high population servers there are russian ... but on the other point of view to avoid that you must play a low population server .. but low population server(low rate at least) sux ... so the only think to do it go play a game like l2 dex with russians and bots .. dont care about them .. if you are a solo player make your fun .. make a spoiler and go get them .. there are no a dream server with no bots or russian nowdays .. (low rate about russian at least)

personal i love it its realy better from my other 2 monitos and also in my eyes is more "peacfull" :D .. i couldnt stay 5+ hours because of my eyes but with this one i am ok now :D i love this shiny screen :D

i agree

well yesterday i made a market research and i ended on DELL S2715H - (210-ADOX) .. is 27" well this screen is amazing .. not only the resolution but the way of crafting .. amazing materials all metal very nice design on back for the cables .. and the class .. this glass guys is like from onother dimension .. its works like a mirror too recomend it 100% .. check img below: p.s: i am using the monitors like that because its more usefull for my work there .. cost of monitos on greece 310(cheapest from out country .. and this is bad) and the highest price is 350 ... i bought it 320(350 original price) from Media Markt in greece .. its so shiny and mirroring .. my picture resolution suck but even there you can see the glass ... Also i change graphic card from this -> (gtx 750) http://cdn.wccftech.com/wp-content/uploads/2014/02/Maxwell-GTX-750-.jpg to this -> (gtx 960) http://www.palit.biz/product/vga/picture/p02442/p02442_bigimage_166454b736eb9dfbe.jpg

Hello i would like to know your opinions about that .. i am using my computer for programming,education,some times games (1/10). I wont talk about my pc features .. Well to the main object i got 2 monitors atm 2 lg 23" LG Monitor 23'' 23MP67VQ and i am thinking to put a 3rd main monitor propably much much better from others (maybe a curved one) with 27" .. Just make an imagine about that .. [23" - 27" - 23"] ... should be good? and also if someone can give me opinion about a specific monitor 25"-27" 200-400 euro ..

Hello anyone can give me a hand about that? i need when player press client side "create" and while he choose name,race,class etc appear one html in this viewpoint .. i am searching to put it in createcharacter.java but i think is not there the correct place .. thanks

1) Database etcitem - item_type (recipe) 2) in data search on the what you gona search? 1) write recipe 2) write a specific recipe id to take it as example for example recipe id (8369) there are 2 or 3 files but because i had never touched the recipes i dont have idea about there specific locations so if someone can give more details its ok :D also on client side you need to change the itemname and etcitemgrp with fileeditor or whatever

dont open a server there are so many mid rates who is L2OFF with standard community ammount and everyone is happy .. work until them on your pack search what make the servers unique create plan and ideas and work and while the correct time will come and this server will be in the edges boom make your server !

At least pay someone to create a website for you if your workers doesnt know how to :D Very nice script dude gz and also is very cheap !!! i recomend this guy!

wow this is amazing elfo with objective languages classes is way easier i will read the source code for sure thank you !!

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)

The whole think is just an idea i am getting ideas from the community but my main idea is to create somethink fast and easy imagine a dialog Give me multisell name Want to give product id? Give me product id Give me product ammoun Would you like to add ingedance id? Give me id Give me ammount Want continue? There is no point to make your life easier from the time which manualy you can make xml with notepad to avoid all this questions .. Elfo thanks a lot for advice today i learned about how create app with c# in visual studio in seminar

no lies .. i dont have idea about .NET .. yet i guess .. i am not a ready programmer and my knowledge is limited but i study hard but i dont have much free time to dedicated in my studies .. because i pay for that .. and to get the pay i have to work hard for that .. Greece ftw ..

the interface is the easiest part also the chronicle choise is easy from the time i will finish all the id list you know how hard is to add 5000 ids +15.000 item description +25.000 fast word keys .. just imagine .. and to tell you the truth i never image a chronicle choise .. thanks for the support !! i will add visual environment..

Hello i can see the 9 of 10 coming servers in there promo video they put random youtube Pvp sieges etc videos in there intro.. You crazy guys your server is not open yet stop lie the community :D

So much practical skills but 0 feeling of design i suggest you hire a Designer .. You are the weapon you need and a desgn mind :D Also +1 for your awsome skills !

Hello i am wondering how exacly is the best way to work the specialcamera and how to modify it private void onEnterNewbie(L2PcInstance activeChar) { sendPacket(new SpecialCamera(this supposed to be the target npc->29052, 10, 0, 5, 0, 3000)); Well this didnt work at all .. any suggestion? My thought is to set a target and just change the id to target? or whatever... on specialcamera.java tell me _id and this supposed to work but doesnt .. if anyone know how to modify it .. thanks

Hello mates i decide to create an XML creator in order to create new and easy multisell lists for your server.. download Beta (Beta include only 1 item id) (129) How exacly this will work Over 5.000 items id will be include in order to help you For every single item ID will be include 5 fast words like: 129 item ID - you can just write 'sword of revolution' 'Sword Of Revolution' 'Sword Of revolution' 'Sword of revolution' 'SWORD OF REVOLUTION' if the system cant find your item name will alert you , 'please give a specific ID' Also while you will add a item ID automaticaly in the xml file list will appear a description like <!-- Sword of Revolution --> It is the best arround because: Create the xml file Create XML list Create item description automaticaly when you type item Id example: <!-- Sword of Revolution --> Create <item id="Number"> <--automatical count--> <Ingredient id="Your number" count="Your Number"/> <Production id="Your number" count="Your Number"/> Close the </item> Close XML list </list> Actually the best part is it will be available for all the lineage ids and everythink will be automatical ... and the best part of all is the description! Price for this will be 5 Euro or free it depend on how much work i will give to it .. when i will finish it propably i will add visual environment..

Hello i have a question .. I want to create a website about an oil company which in the main index will have the price of oil but this price must change daily so there is any "easy" way for the customer to change it and avoid go and change the source code in the html or the php file?