tweety

hm ... nice mate:)

daffynash if you are still looking for a dev pm me at " gheorghedelabacau@yahoo.com ". i also have a group of 60-70 players willing to join a server where i whould be dev so if you whould like to colaborate with me i'll be glad. also I whould like to know what project are you developing . I whould like to work on a medium rate server cause i have many players looking for a server like that ...

intreprid ...u understood me wrong :) u don't need to modify Rizel's share...only to make the .php file that we need into our sites + the sql file:)

intrepid :\ most of us we are a lil be lowbies :( ...what u've just wrote here it's for advanced devs ... can't u make it simple ? for example if you want please share with us the .sql file +php ...and thank you also for that share mby will somone will try to complete it

Hello ...I whould to present you the newest medium rate , crafting server. l2equilibrium.tk - Discover the real passion of Lineage2 Server Rates XP & SP : 25x Drop & Spoil : 25x Raid Drop rate : 10x Adena : 25x Quests rate : 10x Manor rate : 10x Party xp rate : 1.2x Enchant Rates: Max. enchant : +10 Enchant rate : 50% normal scrolls , 60% blessed Safe enchant : +4 Server's Features: - Server conceived for a long term game play - Professional DEV staff - Hospitable community - Daily updates & backups to prevent unwanted problems that might appear - One restart / day to mentain the server clear of lag - Geodata enabled - Lux. GK - Npc buffer : buffs & chants , dances & songs + 3rd buffs - GM shop up to B grade, crystals & shots up to B grade, clan lvl 4 & 5 q items - Wedding priest - Subclass without quest - Auto learn skills - Champion mobs system enabled - Manor system - Noblesse & Olly system - 7Signs system 100% working - Duel system - TvT & CTF events with unique rewards - C5 Clan system 100% working inclusive clan lvl 10 & all clan related skills & quests working http://l2EQUILIBRIUM.TK - Discover the real passion of Lineage2

still no1 :|

still now one :( damn...

ok so for request 1 i found the solution ...only need to change the imports :) so now ...the second requst if any1 could help us ?:|

Sorry for the double post but i couldn't edited the last one ...please any moderators delete the previous post! thanks and sorry once again:| Hello ...recently i was searching MXC's 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 "Rizel" and they are made for l2jfree... Now I whould have 2 requests and i think lots of other users whould apreciate if anyone whould help us to finish it :| 1. the scripts are made for "L2jFREE" and as we can all know lots of users are using "l2jserver" also so if anyone whould like to make the script functionally for a "L2jServer" whould be awesome. 2. the script below has only the java files that we need to implement into the server side ...now it whould be really nice if someone whould share with us a script to implement into our websites so players could receive the rewards... ok so ...most of the devs will say that i'm a newbie. and I'm a newbie but i'm trying to learn php / sql / html & java ...it's hard but with time i will learn them :| so ...before anyone make us newbies please can anyone help the MXC's community with that script? All the credits for that script goes to "RIZEL" ...please read the below script and if anyone could find a solution please share it with us :( whould be really usefull . thanks in advance . Have a nice day! Hello. This is my first share on this forum:) 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; @@ -2101,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; } } Once again ...all credits goes to Rizel !

ok so could please share the PHP script , the one we need to add it into our webpages so it can register the votes ? please , whould be really great :| i know a lil bit of php but i don't know how to do it :( please ...we really need it :| rizel , whould you please post your php script ? ...i whould thank you for life :( this utile it's really great for the new servers and not only... please rizel :| we really need it:)

Heya ...first of all if i've made the topic in the wrong section a moderator please move it ... so let's start :) which server pack you think it's better ? till now i've worked on l2jfree , l2jserver & l2emu ...in a while emu seems to be more stable but after that l2jfree seems and so on so i whould like to know your opinion :)

very usefull guide :) thanks a lot scream :)

grats skorpion :> my opinion it's a good server & developed by good ppl :P

it's a medium rate srv and has a pretty good community :)

lol i will try it for sure :))