-
Posts
3,654 -
Credits
0 -
Joined
-
Last visited
-
Days Won
2 -
Feedback
0%
Content Type
Articles
Profiles
Forums
Store
Everything posted by ExCaLiBuR®
-
perna ta arxeia sto eclipse kai trava ekei photo ta errors. i
-
tin perases kai sou vgazei kapoio error ?
-
Help Html File (Page1,page2,page3)
ExCaLiBuR® replied to rlfem123's question in Request Server Development Help [L2J]
i take the photo from crome :)- 14 replies
-
Help Html File (Page1,page2,page3)
ExCaLiBuR® replied to rlfem123's question in Request Server Development Help [L2J]
you want in a row pages on NPC- 14 replies
-
Help Html File (Page1,page2,page3)
ExCaLiBuR® replied to rlfem123's question in Request Server Development Help [L2J]
seriously now ? why you dont test it ? do you want to create a full HTML file for you ?- 14 replies
-
ti akrivos kanoun oi "hakers" ? bot kai etsi ?
-
Help Html File (Page1,page2,page3)
ExCaLiBuR® replied to rlfem123's question in Request Server Development Help [L2J]
<td width="38"> <a action="bypass -h npc_%objectId%_Chat 1"> Page1 </a> </td> <td> <a action="bypass -h npc_%objectId%_Chat 2"> Page2 </a> </td>- 14 replies
-
my settings -> signature
-
Help Vote Reward Help
ExCaLiBuR® replied to davidBm's question in Request Server Development Help [L2J]
l2reunion -
deleted from the onwer
-
Help Olympiad Shows No Ranking (Acis)
ExCaLiBuR® replied to teamviewer's question in Request Server Development Help [L2J]
sorry about my patch. on olympiad.java find this private static final String GET_ALL_CLASSIFIED_NOBLESS private static final String GET_EACH_CLASS_LEADER and replace olympiad_nobles_eom to olympiad_nobles -
Discussion Testers For C4 X45
ExCaLiBuR® replied to AccessDenied's topic in Server Development Discussion [Greek]
perimene tha vreis pollous... den to lew eirwnika oute me kamia. apla sto lew gia na stamatiseis na elpizeis oti tha vreis testers -
Help Olympiad Shows No Ranking (Acis)
ExCaLiBuR® replied to teamviewer's question in Request Server Development Help [L2J]
(no custom ofc because it counters the logic of your projects policy). yes ofc no custom codes. acis have only one custom java code the buffer -
Help Olympiad Shows No Ranking (Acis)
ExCaLiBuR® replied to teamviewer's question in Request Server Development Help [L2J]
stop fight and help this guy to solve the problem -
Help Olympiad Shows No Ranking (Acis)
ExCaLiBuR® replied to teamviewer's question in Request Server Development Help [L2J]
iam not sure. try this ### Eclipse Workspace Patch 1.0 #P aCis_gameserver Index: java/net/sf/l2j/gameserver/model/olympiad/Olympiad.java =================================================================== --- java/net/sf/l2j/gameserver/model/olympiad/Olympiad.java (revision 14) +++ java/net/sf/l2j/gameserver/model/olympiad/Olympiad.java (working copy) @@ -64,8 +64,8 @@ private static final String OLYMPIAD_SAVE_NOBLES = "INSERT INTO olympiad_nobles (`char_id`,`class_id`,`olympiad_points`,`competitions_done`,`competitions_won`,`competitions_lost`, `competitions_drawn`) VALUES (?,?,?,?,?,?,?)"; private static final String OLYMPIAD_UPDATE_NOBLES = "UPDATE olympiad_nobles SET olympiad_points = ?, competitions_done = ?, competitions_won = ?, competitions_lost = ?, competitions_drawn = ? WHERE char_id = ?"; private static final String OLYMPIAD_GET_HEROS = "SELECT olympiad_nobles.char_id, characters.char_name FROM olympiad_nobles, characters WHERE characters.obj_Id = olympiad_nobles.char_id AND olympiad_nobles.class_id = ? AND olympiad_nobles.competitions_done >= " + Config.ALT_OLY_MIN_MATCHES + " AND olympiad_nobles.competitions_won > 0 ORDER BY olympiad_nobles.olympiad_points DESC, olympiad_nobles.competitions_done DESC, olympiad_nobles.competitions_won DESC"; - private static final String GET_ALL_CLASSIFIED_NOBLESS = "SELECT char_id from olympiad_nobles_eom WHERE competitions_done >= " + Config.ALT_OLY_MIN_MATCHES + " ORDER BY olympiad_points DESC, competitions_done DESC, competitions_won DESC"; - private static final String GET_EACH_CLASS_LEADER = "SELECT characters.char_name from olympiad_nobles_eom, characters WHERE characters.obj_Id = olympiad_nobles_eom.char_id AND olympiad_nobles_eom.class_id = ? AND olympiad_nobles_eom.competitions_done >= " + Config.ALT_OLY_MIN_MATCHES + " ORDER BY olympiad_nobles_eom.olympiad_points DESC, olympiad_nobles_eom.competitions_done DESC, olympiad_nobles_eom.competitions_won DESC LIMIT 10"; + private static final String GET_ALL_CLASSIFIED_NOBLESS = "SELECT char_id from olympiad_nobles WHERE competitions_done >= " + Config.ALT_OLY_MIN_MATCHES + " ORDER BY olympiad_points DESC, competitions_done DESC, competitions_won DESC"; + private static final String GET_EACH_CLASS_LEADER = "SELECT characters.char_name from olympiad_nobles, characters WHERE characters.obj_Id = olympiad_nobles_eom.char_id AND olympiad_nobles_eom.class_id = ? AND olympiad_nobles_eom.competitions_done >= " + Config.ALT_OLY_MIN_MATCHES + " ORDER BY olympiad_nobles_eom.olympiad_points DESC, olympiad_nobles_eom.competitions_done DESC, olympiad_nobles_eom.competitions_won DESC LIMIT 10"; private static final String OLYMPIAD_DELETE_ALL = "TRUNCATE olympiad_nobles"; private static final String OLYMPIAD_MONTH_CLEAR = "TRUNCATE olympiad_nobles_eom"; -
Help [Event]How Split Event Member In 1Vs1
ExCaLiBuR® replied to SQL Developer's question in Request Server Development Help [L2J]
you can take the event 1vs1 from the forum. its shared but i dont remember the "name" and you can change the member from 2 -> 12 (6vs6) -
Help Hopzone Topzone Problem!
ExCaLiBuR® replied to Tachi's question in Request Server Development Help [L2J]
TopzoneFirstPageLink = http://l2topzone.com/lineage2/list TopzoneServerLink = http://l2topzone.com/lineage/server-info/2923/l2-saga.html try this and tell me. -
Help Hopzone Topzone Problem!
ExCaLiBuR® replied to Tachi's question in Request Server Development Help [L2J]
HopzoneServerLink = http://l2.topzone.net/lineage2/details/74078/L2World-Servers/ lol ? -
Help Hopzone Topzone Problem!
ExCaLiBuR® replied to Tachi's question in Request Server Development Help [L2J]
you can send me our configs? i want to see the topzone / hopzone URL -
LF Im Looking For Augment Shop
ExCaLiBuR® replied to rlfem123's question in Request Server Development Help [L2J]
remove the @Override and press ctrl + shift + o for organize the imports. and change the L2ItemInstance to ItemInstance -
Help External Url In Npc Html?
ExCaLiBuR® replied to djterixx's question in Request Server Development Help [L2J]
http://www.maxcheaters.com/topic/197078-l2j-velvet-engine/ -
package ... import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.logging.Level; import java.util.logging.Logger; import net.sf.l2j.Config; import net.sf.l2j.L2DatabaseFactory; public class TopPlayers { protected static final Logger _log = Logger.getLogger(TopPlayers.class.getName()); private static final String SELECT_CHARS = "SELECT SUM(chr.points), SUM(it.count), ch.char_name, ch.pkkills, ch.pvpkills, ch.onlinetime, ch.base_class, ch.online FROM characters ch LEFT JOIN character_raid_points chr ON ch.obj_Id=ch.obj_Id LEFT OUTER JOIN items it ON ch.obj_Id=it.owner_id WHERE item_id=57 GROUP BY ch.obj_Id ORDER BY "; private int pos; private final StringBuilder _topList = new StringBuilder(); String sort = ""; public TopPlayers(String file) { loadDB(file); } private void loadDB(String file) { switch (file) { case "toppvp": sort = "pvpkills"; break; case "toppk": sort = "pkkills"; break; case "topadena": sort = "SUM(it.count)"; break; case "toprbrank": sort = "SUM(chr.points)"; break; case "toponline": sort = "onlinetime"; break; default: break; } try (Connection con = L2DatabaseFactory.getInstance().getConnection()) { pos = 0; PreparedStatement statement = con.prepareStatement(SELECT_CHARS + sort + " DESC LIMIT " + Config.TOP_PLAYER_RESULTS); ResultSet result = statement.executeQuery(); while (result.next()) { boolean status = false; pos++; if (result.getInt("online") == 1) { status = true; } String timeon = getPlayerRunTime(result.getInt("ch.onlinetime")); String adenas = getAdenas(result.getLong("SUM(it.count)")); addChar(pos, result.getString("ch.char_name"), result.getInt("base_class"), result.getInt("ch.pvpkills"), result.getInt("ch.pkkills"), result.getInt("SUM(chr.points)"), adenas, timeon, status); } result.close(); statement.close(); } catch (Exception e) { _log.log(Level.WARNING, getClass().getName() + ": Could not Select Top Players " + e); } } public String loadTopList() { return _topList.toString(); } private void addChar(int position, String name, int classid, int pvp, int pk, int raid, String adenas, String online, boolean isOnline) { _topList.append("<table border=0 cellspacing=0 cellpadding=2 bgcolor=050505 height=" + Config.TOP_PLAYER_ROW_HEIGHT + "><tr><td FIXWIDTH=5></td>"); _topList.append("<td FIXWIDTH=27>" + position + ".</td>"); _topList.append("<td FIXWIDTH=160>" + name + "</td>"); _topList.append("<td FIXWIDTH=145>" + className(classid) + "</td>"); _topList.append("<td FIXWIDTH=60>" + pvp + "</td>"); _topList.append("<td FIXWIDTH=60>" + pk + "</td>"); _topList.append("<td FIXWIDTH=60>" + raid + "</td>"); _topList.append("<td FIXWIDTH=150>" + adenas + "</td>"); _topList.append("<td FIXWIDTH=150>" + online + "</td>"); _topList.append("<td FIXWIDTH=65>" + ((isOnline) ? "<font color=99FF00>Online</font>" : "<font color=CC0000>Offline</font>") + "</td>"); _topList.append("</tr></table><img src=\"L2UI.Squaregray\" width=\"610\" height=\"1\">"); } public final static String className(int classId) { return String.valueOf(ClassList.className(classId)); } public String getPlayerRunTime(int secs) { String timeResult = ""; timeResult = ((secs >= 86400 ? Integer.toString(secs / 86400) + " Days " + Integer.toString((secs % 86400) / 3600) + " hours." : Integer.toString(secs / 3600) + " Hours " + Integer.toString((secs % 3600) / 60) + " mins.")); return timeResult; } public String getAdenas(Long adena) { String adenas = ""; adenas = (adena >= 1000000000 ? Long.toString(adena / 1000000000) + " Billion " + Long.toString((adena % 1000000000) / 1000000) + " million" : Long.toString(adena / 1000000) + " Million " + Long.toString((adena % 1000000) / 1000) + " k"); return adenas; } } public class TopPvpPlayers { private int _counter = 1; private final TextBuilder _topPvp = new TextBuilder(); public TopPvpPlayers(String file) { loadDB(file); } private void loadDB(String file) { for (PlayersTopData playerData : CustomTable.getInstance().getTopPvp()) { if (getCounter() <= SmartCommunityConfigs.TOP_PLAYER_RESULTS) { String name = playerData.getCharName(); String cName = playerData.getClanName(); int pvp = playerData.getPvp(); addChar(name, cName, pvp); setCounter(getCounter() + 1); } } } public String loadTopList() { return _topPvp.toString(); } private void addChar(String name, String cname, int pvp) { _topPvp.append("<table border=0 cellspacing=0 cellpadding=2 bgcolor=111111 width=750>"); _topPvp.append("<tr>"); _topPvp.append("<td FIXWIDTH=40>" + getCounter() + "</td"); _topPvp.append("<td fixwidth=160>" + name + "</td"); _topPvp.append("<td fixwidth=160>" + cname + "</td>"); _topPvp.append("<td fixwidth=80>" + pvp + "</td>"); _topPvp.append("</tr></table><img src=\"L2UI.Squaregray\" width=\"735\" height=\"1\">"); } public int getCounter() { return _counter; } public void setCounter(int counter) { _counter = counter; } }
-
LF Im Looking For Augment Shop
ExCaLiBuR® replied to rlfem123's question in Request Server Development Help [L2J]
i think is shared on the forum. start the searching