Jump to content

bubulinas

Members
  • Posts

    1,291
  • Joined

  • Last visited

  • Feedback

    0%

Everything posted by bubulinas

  1. I made a little Gatekeeper for my own server and wanted to share it It works on Gracia & Hellbound You can change the 2 farmingzone's in your own ps: The Owner is Madgizmo but i make manny changes in this share so good luck! hope you like it Downloand http://www.4shared.com/file/125959114/5ed092d4/Gracia_Gatekeeper_by_skanners.html
  2. Hello...recently i was searching on some forums and i found a very interesting tool for lineage2 servers. This is a Vote point system that whould impulse the players to vote for a reward... Java scrips are made by "bubulina" . the script below has only the java files that we need to implement into the server side .. also if anyone whould share the script needed to implement into the websites whould be great. All the credits for that script goes to "bubulina" ...Have a nice day! This share is a 'simple' core mod to inspirate your players to vote to the server. I added a field to the characters table in the servers SQL. With Navicat (design table/ add field) the properties are: Name: 'vote' Type: 'int' Lenght: 10 Decimals: 0 Allow null:[ ] Default: 0 Unsigned: [x] After that apply the patch that i attached. This contains the diff file and 2 java files wich you have to copy to handler/voicedcommandhandlers/. After that compile the server core and you're done. You have to make a PHP script for your servers homepage for increase the character's vote field if he voted. In the game use the .vote voice command to see how many vote points you have and .change to change theese points to Glittering Medal. You can change the reward item-s id in VoteChange.java so you can give anything you want for the vote points. I use the Glittering Medal with a simple multisell NPC. Diff file: Index: D:/Eclipse/Core Version 1.2.6/src/main/java/com/l2jfree/gameserver/model/actor/instance/L2PcInstance.java =================================================================== --- D:/Eclipse/Core Version 1.2.6/src/main/java/com/l2jfree/gameserver/model/actor/instance/L2PcInstance.java (revision 4875) +++ D:/Eclipse/Core Version 1.2.6/src/main/java/com/l2jfree/gameserver/model/actor/instance/L2PcInstance.java (working copy) @@ -267,8 +267,8 @@ private static final String DELETE_SKILL_SAVE = "DELETE FROM character_skills_save WHERE charId=? AND class_index=?"; // Character Character SQL String Definitions: - private static final String UPDATE_CHARACTER = "UPDATE characters SET level=?,maxHp=?,curHp=?,maxCp=?,curCp=?,maxMp=?,curMp=?,face=?,hairStyle=?,hairColor=?,heading=?,x=?,y=?,z=?,exp=?,expBeforeDeath=?,sp=?,karma=?,pvpkills=?,pkkills=?,rec_have=?,rec_left=?,clanid=?,race=?,classid=?,deletetime=?,title=?,accesslevel=?,online=?,isin7sdungeon=?,clan_privs=?,wantspeace=?,base_class=?,onlinetime=?,in_jail=?,jail_timer=?,newbie=?,nobless=?,pledge_rank=?,subpledge=?,last_recom_date=?,lvl_joined_academy=?,apprentice=?,sponsor=?,varka_ketra_ally=?,clan_join_expiry_time=?,clan_create_expiry_time=?,banchat_timer=?,char_name=?,death_penalty_level=?,trust_level=? WHERE charId=?"; - private static final String RESTORE_CHARACTER = "SELECT account_name, charId, char_name, level, maxHp, curHp, maxCp, curCp, maxMp, curMp, face, hairStyle, hairColor, sex, heading, x, y, z, exp, expBeforeDeath, sp, karma, pvpkills, pkkills, clanid, race, classid, deletetime, cancraft, title, rec_have, rec_left, accesslevel, online, char_slot, lastAccess, clan_privs, wantspeace, base_class, onlinetime, isin7sdungeon, in_jail, jail_timer, banchat_timer, newbie, nobless, pledge_rank, subpledge, last_recom_date, lvl_joined_academy, apprentice, sponsor, varka_ketra_ally, clan_join_expiry_time,clan_create_expiry_time,charViP,death_penalty_level,trust_level FROM characters WHERE charId=?"; + private static final String UPDATE_CHARACTER = "UPDATE characters SET level=?,maxHp=?,curHp=?,maxCp=?,curCp=?,maxMp=?,curMp=?,face=?,hairStyle=?,hairColor=?,heading=?,x=?,y=?,z=?,exp=?,expBeforeDeath=?,sp=?,karma=?,pvpkills=?,pkkills=?,rec_have=?,rec_left=?,clanid=?,race=?,classid=?,deletetime=?,title=?,accesslevel=?,online=?,isin7sdungeon=?,clan_privs=?,wantspeace=?,base_class=?,onlinetime=?,in_jail=?,jail_timer=?,newbie=?,nobless=?,pledge_rank=?,subpledge=?,last_recom_date=?,lvl_joined_academy=?,apprentice=?,sponsor=?,varka_ketra_ally=?,clan_join_expiry_time=?,clan_create_expiry_time=?,banchat_timer=?,char_name=?,death_penalty_level=?,trust_level=?,vote=? WHERE charId=?"; + private static final String RESTORE_CHARACTER = "SELECT account_name, charId, char_name, level, maxHp, curHp, maxCp, curCp, maxMp, curMp, face, hairStyle, hairColor, sex, heading, x, y, z, exp, expBeforeDeath, sp, karma, pvpkills, pkkills, clanid, race, classid, deletetime, cancraft, title, rec_have, rec_left, accesslevel, online, char_slot, lastAccess, clan_privs, wantspeace, base_class, onlinetime, isin7sdungeon, in_jail, jail_timer, banchat_timer, newbie, nobless, pledge_rank, subpledge, last_recom_date, lvl_joined_academy, apprentice, sponsor, varka_ketra_ally, clan_join_expiry_time,clan_create_expiry_time,charViP,death_penalty_level,trust_level,vote FROM characters WHERE charId=?"; // Character Subclass SQL String Definitions: private static final String RESTORE_CHAR_SUBCLASSES = "SELECT class_id,exp,sp,level,class_index FROM character_subclasses WHERE charId=? ORDER BY class_index ASC"; @@ -289,7 +289,9 @@ private static final String RESTORE_CHAR_RECOMS = "SELECT charId,target_id FROM character_recommends WHERE charId=?"; private static final String ADD_CHAR_RECOM = "INSERT INTO character_recommends (charId,target_id) VALUES (?,?)"; private static final String DELETE_CHAR_RECOMS = "DELETE FROM character_recommends WHERE charId=?"; - + private static final String RESTORE_CHAR_VOTE = "SELECT vote FROM characters WHERE charId=?"; + private static final String UPDATE_CHAR_VOTE = "UPDATE characters SET vote=? WHERE charId=?"; + // Character Transformation SQL String Definitions: private static final String SELECT_CHAR_TRANSFORM = "SELECT transform_id FROM characters WHERE charId=?"; private static final String UPDATE_CHAR_TRANSFORM = "UPDATE characters SET transform_id=? WHERE charId=?"; @@ -408,6 +410,10 @@ /** The number of player killed during a PvP (the player killed was PvP Flagged) */ private int _pvpKills; + + /** The number of the player's votes */ + + private int _voteCount; /** The PK counter of the L2PcInstance (= Number of non PvP Flagged player killed) */ private int _pkKills; @@ -2****6 +2107,19 @@ return _pvpKills; } + + public int getVoteCount() + { + restoreVote(); + return _voteCount; + } + + public void setVoteCount(int vote) + { + _voteCount = vote; + updateVote(); + } + /** * Set the the PvP Kills of the L2PcInstance (Number of player killed during a PvP).<BR><BR> */ @@ -6794,7 +6813,8 @@ player.setAllianceWithVarkaKetra(rset.getInt("varka_ketra_ally")); player.setDeathPenaltyBuffLevel(rset.getInt("death_penalty_level")); player.setTrustLevel(rset.getInt("trust_level")); - + player.setVoteCount(rset.getInt("vote")); + // Add the L2PcInstance object in _allObjects // L2World.getInstance().storeObject(player); @@ -7030,6 +7050,57 @@ finally { try { if (con != null) con.close(); } catch (SQLException e) { e.printStackTrace(); } } } + + private void restoreVote() + { + Connection con = null; + + try + { + con = L2DatabaseFactory.getInstance().getConnection(con); + PreparedStatement statement = con.prepareStatement(RESTORE_CHAR_VOTE); + statement.setInt(1, getObjectId()); + ResultSet rset = statement.executeQuery(); + while (rset.next()) + { + _voteCount=(rset.getInt("vote")); + } + + rset.close(); + statement.close(); + } + catch (Exception e) + { + _log.error("could not restore vote: ", e); + } + finally { try { if (con != null) con.close(); } catch (SQLException e) { e.printStackTrace(); } } + } + + + private void updateVote() + { + + + + Connection con = null; + try + { + con = L2DatabaseFactory.getInstance().getConnection(con); + PreparedStatement statement = con.prepareStatement(UPDATE_CHAR_VOTE); + statement.setInt(1, _voteCount); + statement.setInt(2, getObjectId()); + + statement.execute(); + statement.close(); + } + catch (Exception e) + { + _log.fatal("Vote insert info: " + e); + } + finally { try { if (con != null) con.close(); } catch (SQLException e) { e.printStackTrace(); } } + } + + /** * Store recipe book data for this L2PcInstance, if not on an active sub-class. */ @@ -7203,7 +7274,8 @@ statement.setString(49, getName()); statement.setLong(50, getDeathPenaltyBuffLevel()); statement.setLong(51, getTrustLevel()); - statement.setInt(52, getObjectId()); + statement.setInt(52, getVoteCount()); + statement.setInt(53, getObjectId()); statement.execute(); statement.close(); } Index: D:/Eclipse/Core Version 1.2.6/src/main/java/com/l2jfree/gameserver/handler/VoicedCommandHandler.java =================================================================== --- D:/Eclipse/Core Version 1.2.6/src/main/java/com/l2jfree/gameserver/handler/VoicedCommandHandler.java (revision 4875) +++ D:/Eclipse/Core Version 1.2.6/src/main/java/com/l2jfree/gameserver/handler/VoicedCommandHandler.java (working copy) @@ -48,6 +48,8 @@ registerVoicedCommandHandler(new CastleDoors()); registerVoicedCommandHandler(new Hellbound()); registerVoicedCommandHandler(new VersionInfo()); + registerVoicedCommandHandler(new VoteCount()); + registerVoicedCommandHandler(new VoteChange()); if (Config.ALLOW_WEDDING) { registerVoicedCommandHandler(new Wedding()); handler/voicedcommandhandlers/VoteChange.java package com.l2jfree.gameserver.handler.voicedcommandhandlers; import com.l2jfree.gameserver.handler.IVoicedCommandHandler; import com.l2jfree.gameserver.model.actor.instance.L2PcInstance; /** * @author Rizel * */ public class VoteChange implements IVoicedCommandHandler { private static final String[] VOICED_COMMANDS = { "change" }; public boolean useVoicedCommand(String command, L2PcInstance activeChar, String target) { if (command.startsWith("change")) { if (activeChar.getVoteCount() == 0) { activeChar.sendMessage("You don't have any vote points."); return true; } else { activeChar.addItem("Loot", 6393, activeChar.getVoteCount(), activeChar, true); activeChar.sendMessage("You changed " + activeChar.getVoteCount() + " vote points to Medal!"); activeChar.setVoteCount(0); return true; } } return false; } public String[] getVoicedCommandList() { return VOICED_COMMANDS; } } handler/voicedcommandhandlers/VoteCount.java package com.l2jfree.gameserver.handler.voicedcommandhandlers; import com.l2jfree.gameserver.handler.IVoicedCommandHandler; import com.l2jfree.gameserver.model.actor.instance.L2PcInstance; /** * @author Rizel * */ public class VoteCount implements IVoicedCommandHandler { private static final String[] VOICED_COMMANDS = { "vote" }; public boolean useVoicedCommand(String command, L2PcInstance activeChar, String target) { if (command.startsWith("vote")) { activeChar.sendMessage("Your vote points: " + activeChar.getVoteCount()); return true; } return false; } public String[] getVoicedCommandList() { return VOICED_COMMANDS; } } btw bubulina = skanners
  3. <skill id="2001" levels="1" name="Super Powers"> <!-- Done by xEviLx & skanners Description(s): Temporarily increases all your stats. You will have super powers for 1H. --> <set name="power" val="0.0"/> <set name="target" val="TARGET_SELF"/> <set name="skillType" val="BUFF"/> <set name="operateType" val="OP_ACTIVE"/> <set name="isPotion" val="true"/> <set name="castRange" val="-1"/> <set name="effectRange" val="-1"/> <for> <effect count="1" name="Buff" time="3600" val="0"> <mul order="0x30" stat="pAtk" val="1.50"/> <mul order="0x30" stat="pAtkSpd" val="1.50"/> <mul order="0x30" stat="mAtk" val="1.50"/> <mul order="0x30" stat="mAtkSpd" val="1.50"/> <mul order="0x30" stat="maxMp" val="1.50"/> <mul order="0x30" stat="maxHp" val="1.50"/> <add order="0x40" stat="reflectDam" val="30.0"/> <mul order="0x30" stat="pDef" val="1.50"/> <mul order="0x30" stat="mDef" val="1.50"/> <basemul order="0x30" stat="rCrit" val="2"/> <add order="0x40" stat="runSpd" val="33"/> <add order="0x40" stat="regMp" val="10.1"/> <add order="0x40" stat="regHp" val="10.1"/> <add order="0x40" stat="accCombat" val="10"/> <add order="0x40" stat="rEvas" val="10"/> <mul order="0x30" stat="cAtk" val="2"/> <mul order="0x30" stat="mCritRate" val="6"/> </effect> </for> </skill> i edit : ) i think the rest works fine, except the npc merchant ... just add that multisell to another shop or make a npc for it your selfs
  4. www.riseofevil.net
  5. It's a simple event, all mobs drop an item with 25% chance (Bitter Cold Vodka). When you get 500 Vodka, you can go to the Super Powers Trader and he will give you a potion that will increase your stats significantly, the potion lasts for 1 hour. This is the actual event from the server RiseOfEviL made by xEviLx I hope you like it: Here it is: Downloand click me
  6. skanners, Xavez, Phoenix4, GrisoM, ˚°▫•Cobra●▫°˚, FiX, Raigon and 0 Guests are viewing this topic.
  7. you see to manny carton :))
  8. you ar just a kid with Mom Money..!!! good luck for you g MOd =)))))))))))))))XD
  9. is useful cuz in romania all off kid's and all pll use yahoo messenger not msn and if you have some 1friend and you wanna se if him is online and he stay in inv mode you see it !! with this program!
  10. thx to equal team i make yor pack from a faction in1 nice pvp server with manny player's on it..!! keep sharing dude and thx!!!
  11. PALADIN/OVERLORD Sagitarius / GostHunter Soultaker :D
  12. search before posting http://www.maxcheaters.com/forum/index.php?topic=75420.msg568053#msg568053 and your vid dont work
  13. look nice may be i will join today.. when wass opened?? and i see is not in hopzone....
  14. omfg if my wife see what reaply i will put here she 100% will kill me :)) i prefer HOT girl's xD like angelina :D
  15. i test it and work nice share and keep it up!! :)
  16. my hight score and i wanna make 30k :D
  17. I have explored the site and it’s pretty amazing. But as an experienced lineage 2 player I found the corresponding forum very poor (don’t get me wrong at this). It's not to blame someone because it is extremely difficult to hack these days on lineage 2 and even dedicated lineage 2 forums don't have workable hacks. So, I am going to post all the hacks that are available for lineage 2 at the moment in my pc along with a link to download and a short description. If I forgot any hack tool just post it and I will be adding it to the first post. So here I go: hLaPEx The most famous hack program on lineage 2 which was created by h1nt. It sends and receives packets from the server and vise versa. http://rapidshare.com/files/9820981/lahelp_new.rar L2 Monster 1.7 A program that makes its user immune to all attacking skills. Lots of other features http://rapidshare.com/files/11131577/Monster_1.7.rar L2 Brut 1.4 A program to steal the password of other users. http://rapidshare.com/files/10550134/L2Brut_1.4.rar L2PacketHack 3.1.4 A hlapex like program but this is better and works on C6 servers. http://rapidshare.com/files/37047708/L2PacketHack_3.1.4.rar.html Server Addons In this section addons for your own server will be added. But this addons to your server and you will make him unique. Dusk Items With this addon, you can add to your server the "holy" Dusk Items http://rapidshare.com/files/36304942/Dusk_Items.rar.html Weapons Glow With this addon you can add you own custom glows to your server. What changes is that as the enchant grows bigger the color changes instead of being red. http://rapidshare.com/files/36350744/Weapons_Glow.rar.html Hero Skills C5 With this addon you can add some very cool skills for heros. For C5 servers. http://http//rapidshare.com/files/36351686/Hero_Skills_C5.rar.html About botting, there is a bot which works on every full c6 server. http://rapidshare.com/files/36681697/L2Walker_IG_C6.rar.html If you see any dead links, post and I will replace it. Also if you have any question don’t be afraid to ask.
  18. i like this one... special server.:)) i will test it.. good luck with your server!
  19. is onlly for admins who have server?? or i can add in my personal cs mode with Bots?:))
  20. but try it now cuz idont have msn and... cuz yahoo and msn is almost the same..!
  21. if u play 1 game or you work somnting with mozila or 1 program you can hide it and you can make anothor thigs!
  22. i dont know for sure but i can make 1 for msn also
  23. i know also anothor metodd.. if you ar in jail make anothor char in dual boxx and go buy somntin from npc 2bill++to restart adena and you will get jail 5min for ilegal (somnting) and put stall with you second char somnting and buy with frist.. and after rr the game with frist char.. and if u haveed jail 1h or 2 or 3 day, after rr you will have onlly 15min jail max :) work in almost all servers.. i tryed in c6 sry for my eng,,,!
×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..