最新公告
★ 欢迎来到天堂私服123 | 天天更新最新私服信息
天堂私服123|每日開服情報
首页 › 文章看板 › 🖥️ 私服架设 › 天堂私服排行榜的编写方式~
🖥️ 私服架设

天堂私服排行榜的编写方式~

🧙
匿名

本排名系统最初由99nets.spofpak首发

经过我的整理,然后经过missu0524的改良(还有一个missu0524的版本,目前还没有办法适当地套用在我自己的版本上)

再经由9001183ex的共同努力,目前达成如下效果,在收集排名的同时避免太多人点击而造成服务器LAG.

理论上而言,可以套用到从三年前到现在的任何版本......

本段代码由missu0524所提供

[Copy to clipboard]

CODE:
private String[] getPlayersExp() throws SQLException { //等级排名
String[] name = new String[10];
PreparedStatement pstm1 = null;
ResultSet rs = null;
Connection con = null;
con = L1DatabaseFactory.getInstance().getConnection();
int cc = 0;
while (cc < 10) {
pstm1 = con.prepareStatement("select char_name from characters where accesslevel=0 order by exp DESC limit "+cc+",1;");
rs = pstm1.executeQuery();
while (rs.next()) {
name[cc] = rs.getString("char_name");
}
SQLUtil.close(rs);
cc++;
}
return name;
}

通过读取DB内所保存的数据而非玩家的当前数据,所以每次读取的应该是在线玩家上线时的数据,每次有玩家下线,DB数据库更新此排名也随之更新.

[Copy to clipboard]

CODE:
if (((L1NpcInstance)obj).getNpcTemplate().get_npcId()==123456) { //排行榜NPC的编号
L1NpcInstance npc = (L1NpcInstance) obj;
int time = npc.getSkillEffectTimeSec(123456);
if (s.equalsIgnoreCase("playersexp")) { //显示等级前10
if (!npc.hasSkillEffect(123456) || pc.isGm()) {
htmldata = getPlayersExp();
htmlid = "getexp";
npc.setSkillEffect(123456, 1800*1000);
} else {
npc.broadcastPacket(new S_NpcChatPacket(npc, "最新排名的信息还需要"+ time +"秒的时间,请稍后再来!", 0));
Thread.sleep(10000);
}
}
}

每半小时可以查找一人次......这便是此写法的不是很人性化的一个地方了,为了避免LAG,暂时也只好这样了.


----------------------------------------------------------------------------


softpak曾经写过的排行榜,只是拿过来稍稍改了一下.因为softpak以前是发在99的,所以请勿随意转载.

希望套用等级排名而又不希望太过于占用资源导致服务器LAG的朋友请将此贴所有跟贴看完

看完后相信可以有一个比较适当的解决方法给你!


对话档命令添加:
if (s.equalsIgnoreCase("playersexp")) { //显示等级前10
htmldata = getPlayersExp();
htmlid = "playersexp";
}

写一个<var src="#xx">的对话档,命令为 playersexp 备用

随意找个能添加的java
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

private String[] getPlayersExp() throws SQLException { //等级排名 by softpak .jhony修正
String msg1 = null; String msg2 = null; String msg3 = null; String msg4 = null; 
String msg5 = null; String msg6 = null; String msg7 = null; String msg8 = null; 
String msg9 = null; String msg10 = null;
PreparedStatement pstm1 = null; PreparedStatement pstm2 = null;
PreparedStatement pstm3 = null; PreparedStatement pstm4 = null;
PreparedStatement pstm5 = null; PreparedStatement pstm6 = null;
PreparedStatement pstm7 = null; PreparedStatement pstm8 = null;
PreparedStatement pstm9 = null; PreparedStatement pstm10 = null;
ResultSet rs1 = null; ResultSet rs2 = null;
ResultSet rs3 = null; ResultSet rs4 = null;
ResultSet rs5 = null; ResultSet rs6 = null;
ResultSet rs7 = null; ResultSet rs8 = null;
ResultSet rs9 = null; ResultSet rs10 = null;
Connection con = null;
String[] expresult = null;
con = L1DatabaseFactory.getInstance().getConnection();
pstm1 = con.prepareStatement("select char_name from characters where accesslevel=0 order by exp DESC limit 0,1;");
pstm2 = con.prepareStatement("select char_name from characters where accesslevel=0 order by exp DESC limit 1,1;");
pstm3 = con.prepareStatement("select char_name from characters where accesslevel=0 order by exp DESC limit 2,1;");
pstm4 = con.prepareStatement("select char_name from characters where accesslevel=0 order by exp DESC limit 3,1;");
pstm5 = con.prepareStatement("select char_name from characters where accesslevel=0 order by exp DESC limit 4,1;");
pstm6 = con.prepareStatement("select char_name from characters where accesslevel=0 order by exp DESC limit 5,1;");
pstm7 = con.prepareStatement("select char_name from characters where accesslevel=0 order by exp DESC limit 6,1;");
pstm8 = con.prepareStatement("select char_name from characters where accesslevel=0 order by exp DESC limit 7,1;");
pstm9 = con.prepareStatement("select char_name from characters where accesslevel=0 order by exp DESC limit 8,1;");
pstm10 = con.prepareStatement("select char_name from characters where accesslevel=0 order by exp DESC limit 9,1;");
rs1 = pstm1.executeQuery();
while (rs1.next()) {
msg1 = rs1.getString("char_name");
}
rs2 = pstm2.executeQuery();
while (rs2.next()) {
msg2 = rs2.getString("char_name");
}
rs3 = pstm3.executeQuery();
while (rs3.next()) {
msg3 = rs3.getString("char_name");
}
rs4 = pstm4.executeQuery();
while (rs4.next()) {
msg4 = rs4.getString("char_name");
}
rs5 = pstm5.executeQuery();
while (rs5.next()) {
msg5 = rs5.getString("char_name");
}
rs6 = pstm6.executeQuery();
while (rs6.next()) {
msg6 = rs6.getString("char_name");
}
rs7 = pstm7.executeQuery();
while (rs7.next()) {
msg7 = rs7.getString("char_name");
}
rs8 = pstm8.executeQuery();
while (rs8.next()) {
msg8 = rs8.getString("char_name");
}
rs9 = pstm9.executeQuery();
while (rs9.next()) {
msg9 = rs9.getString("char_name");
}
rs10 = pstm10.executeQuery();
while (rs10.next()) {
msg10 = rs10.getString("char_name");
}
expresult = new String[] {String.valueOf(msg1),String.valueOf(msg2),String.valueOf(msg3),String.valueOf(msg4),String.valueOf(msg5),String.valueOf(msg6),String.valueOf(msg7),String.valueOf(msg8),String.valueOf(msg9),String.valueOf(msg10)};
SQLUtil.close(rs1);
SQLUtil.close(rs2);
SQLUtil.close(rs3);
SQLUtil.close(rs4);
SQLUtil.close(rs5);
SQLUtil.close(rs6);
SQLUtil.close(rs7);
SQLUtil.close(rs8);
SQLUtil.close(rs9);
SQLUtil.close(rs10);
SQLUtil.close(pstm1);
SQLUtil.close(pstm2);
SQLUtil.close(pstm3);
SQLUtil.close(pstm4);
SQLUtil.close(pstm5);
SQLUtil.close(pstm6);
SQLUtil.close(pstm7);
SQLUtil.close(pstm8);
SQLUtil.close(pstm9);
SQLUtil.close(pstm10);
SQLUtil.close(con);
return expresult;
}

❤️ 0 💬 0 🔄 0 🔖 0
分享 f L 𝕏 已拷贝

💬 留言

还没有留言,来抢头香吧!

LINE 咨询
比较:
开始比较
PlaySF

ui.pwa_install

ui.install_prompt