[Comando] Clan Notice System

[Swarlog]

Código [Seleccionar] Expandir

### Eclipse Workspace Patch 1.0
#P Chr.6DTP
Index: sql/characters.sql
===================================================================
--- sql/characters.sql    (revision 8778)
+++ sql/characters.sql    (working copy)
@@ -79,6 +79,7 @@
   clan_join_expiry_time DECIMAL(20,0) NOT NULL DEFAULT 0,
   clan_create_expiry_time DECIMAL(20,0) NOT NULL DEFAULT 0,
   death_penalty_level int(2) NOT NULL DEFAULT 0,
+  announce varchar(100) NOT NULL default ''
   PRIMARY KEY  (obj_Id),
   KEY `clanid` (`clanid`)
 ) ;

### Eclipse Workspace Patch 1.0
#P Chr.6GMS
Index: java/net/sf/l2j/gameserver/clientpackets/EnterWorld.java
===================================================================
--- java/net/sf/l2j/gameserver/clientpackets/EnterWorld.java    (revision 5263)
+++ java/net/sf/l2j/gameserver/clientpackets/EnterWorld.java    (working copy)
@@ -55,8 +55,10 @@
 import net.sf.l2j.gameserver.model.entity.TvTEvent;
 import net.sf.l2j.gameserver.model.quest.Quest;
 import net.sf.l2j.gameserver.network.SystemMessageId;
+import net.sf.l2j.gameserver.serverpackets.CreatureSay;
 import net.sf.l2j.gameserver.serverpackets.Die;
 import net.sf.l2j.gameserver.serverpackets.EtcStatusUpdate;
+import net.sf.l2j.gameserver.serverpackets.ExShowScreenMessage;
 import net.sf.l2j.gameserver.serverpackets.ExStorageMaxCount;
 import net.sf.l2j.gameserver.serverpackets.FriendList;
 import net.sf.l2j.gameserver.serverpackets.HennaInfo;
@@ -71,6 +73,7 @@
 import net.sf.l2j.gameserver.serverpackets.SignsSky;
 import net.sf.l2j.gameserver.serverpackets.SystemMessage;
 import net.sf.l2j.gameserver.serverpackets.UserInfo;
+import net.sf.l2j.gameserver.serverpackets.ExShowScreenMessage.SMPOS;
 import net.sf.l2j.gameserver.util.FloodProtector;
 
 /**
@@ -251,6 +254,8 @@
 
         SevenSigns.getInstance().sendCurrentPeriodMsg(activeChar);
         Announcements.getInstance().showAnnouncements(activeChar);
+       
+        loadAnnounceClan(activeChar);
 
         Quest.playerEnter(activeChar);
         activeChar.sendPacket(new QuestList());
@@ -350,6 +355,18 @@
         TvTEvent.onLogin(activeChar);
     }
 
+    private void loadAnnounceClan(L2PcInstance pc){
+        if(pc.hasNewAnnounce()){
+            CreatureSay msg1 = new CreatureSay(1,Say2.CLAN,"Clan Announcement",pc.getAnnounce());
+           
+            ExShowScreenMessage msg2 = new ExShowScreenMessage(pc.getAnnounce(), 15000, SMPOS.TOP_CENTER, true);
+       
+             pc.sendPacket(msg1);
+             pc.sendPacket(msg2);
+            
+        }
+    }
+   
     /**
      * @param activeChar
      */
Index: java/net/sf/l2j/gameserver/model/actor/instance/L2PcInstance.java
===================================================================
--- java/net/sf/l2j/gameserver/model/actor/instance/L2PcInstance.java    (revision 5263)
+++ java/net/sf/l2j/gameserver/model/actor/instance/L2PcInstance.java    (working copy)
@@ -214,8 +214,8 @@
     private static final String RESTORE_SKILL_SAVE = "SELECT skill_id,skill_level,effect_count,effect_cur_time, reuse_delay FROM character_skills_save WHERE char_obj_id=? AND class_index=? AND restore_type=? ORDER BY buff_index ASC";
     private static final String DELETE_SKILL_SAVE = "DELETE FROM character_skills_save WHERE char_obj_id=? AND class_index=?";
 
-    private static final String UPDATE_CHARACTER = "UPDATE characters SET level=?,maxHp=?,curHp=?,maxCp=?,curCp=?,maxMp=?,curMp=?,str=?,con=?,dex=?,_int=?,men=?,wit=?,face=?,hairStyle=?,hairColor=?,heading=?,x=?,y=?,z=?,exp=?,expBeforeDeath=?,sp=?,karma=?,pvpkills=?,pkkills=?,rec_have=?,rec_left=?,clanid=?,maxload=?,race=?,classid=?,deletetime=?,title=?,accesslevel=?,online=?,isin7sdungeon=?,clan_privs=?,wantspeace=?,base_class=?,onlinetime=?,in_jail=?,jail_timer=?,newbie=?,nobless=?,power_grade=?,subpledge=?,last_recom_date=?,lvl_joined_academy=?,apprentice=?,sponsor=?,varka_ketra_ally=?,clan_join_expiry_time=?,clan_create_expiry_time=?,char_name=?,death_penalty_level=? WHERE obj_id=?";
-    private static final String RESTORE_CHARACTER = "SELECT account_name, obj_Id, char_name, level, maxHp, curHp, maxCp, curCp, maxMp, curMp, acc, crit, evasion, mAtk, mDef, mSpd, pAtk, pDef, pSpd, runSpd, walkSpd, str, con, dex, _int, men, wit, face, hairStyle, hairColor, sex, heading, x, y, z, movement_multiplier, attack_speed_multiplier, colRad, colHeight, exp, expBeforeDeath, sp, karma, pvpkills, pkkills, clanid, maxload, 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, newbie, nobless, power_grade, subpledge, last_recom_date, lvl_joined_academy, apprentice, sponsor, varka_ketra_ally,clan_join_expiry_time,clan_create_expiry_time,death_penalty_level FROM characters WHERE obj_id=?";
+    private static final String UPDATE_CHARACTER = "UPDATE characters SET level=?,maxHp=?,curHp=?,maxCp=?,curCp=?,maxMp=?,curMp=?,str=?,con=?,dex=?,_int=?,men=?,wit=?,face=?,hairStyle=?,hairColor=?,heading=?,x=?,y=?,z=?,exp=?,expBeforeDeath=?,sp=?,karma=?,pvpkills=?,pkkills=?,rec_have=?,rec_left=?,clanid=?,maxload=?,race=?,classid=?,deletetime=?,title=?,accesslevel=?,online=?,isin7sdungeon=?,clan_privs=?,wantspeace=?,base_class=?,onlinetime=?,in_jail=?,jail_timer=?,newbie=?,nobless=?,power_grade=?,subpledge=?,last_recom_date=?,lvl_joined_academy=?,apprentice=?,sponsor=?,varka_ketra_ally=?,clan_join_expiry_time=?,clan_create_expiry_time=?,char_name=?,death_penalty_level=?,announce=? WHERE obj_id=?";
+    private static final String RESTORE_CHARACTER = "SELECT account_name, obj_Id, char_name, level, maxHp, curHp, maxCp, curCp, maxMp, curMp, acc, crit, evasion, mAtk, mDef, mSpd, pAtk, pDef, pSpd, runSpd, walkSpd, str, con, dex, _int, men, wit, face, hairStyle, hairColor, sex, heading, x, y, z, movement_multiplier, attack_speed_multiplier, colRad, colHeight, exp, expBeforeDeath, sp, karma, pvpkills, pkkills, clanid, maxload, 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, newbie, nobless, power_grade, subpledge, last_recom_date, lvl_joined_academy, apprentice, sponsor, varka_ketra_ally,clan_join_expiry_time,clan_create_expiry_time,death_penalty_level,announce FROM characters WHERE obj_id=?";
     private static final String RESTORE_CHAR_SUBCLASSES = "SELECT class_id,exp,sp,level,class_index FROM character_subclasses WHERE char_obj_id=? ORDER BY class_index ASC";
     private static final String ADD_CHAR_SUBCLASS = "INSERT INTO character_subclasses (char_obj_id,class_id,exp,sp,level,class_index) VALUES (?,?,?,?,?,?)";
     private static final String UPDATE_CHAR_SUBCLASS = "UPDATE character_subclasses SET exp=?,sp=?,level=?,class_id=? WHERE char_obj_id=? AND class_index =?";
@@ -451,6 +451,8 @@
 
     private boolean _noble = false;
     private boolean _hero = false;
+   
+    private String announce = null;
 
     /** The L2FolkInstance corresponding to the last Folk wich one the player talked. */
     private L2FolkInstance _lastFolkNpc = null;
@@ -4671,6 +4673,13 @@
     {
         return _partyMatchingMemo;
     }
+   
+    public boolean hasNewAnnounce(){
+        if(getAnnounce() != "" && getAnnounce() != null)
+            return true;
+       
+        return false;
+    }
 
     public boolean isPartyMatchingShowClass()
     {
@@ -5595,6 +5604,7 @@
                 player.setOnlineTime(rset.getLong("onlinetime"));
                 player.setNewbie(rset.getInt("newbie")==1);
                 player.setNoble(rset.getInt("nobless")==1);
+                player.setAnnounce(rset.getString("announce"));
 
                 player.setClanJoinExpiryTime(rset.getLong("clan_join_expiry_time"));
                 if (player.getClanJoinExpiryTime() < System.currentTimeMillis())
@@ -6059,7 +6069,8 @@
             statement.setLong(54, getClanCreateExpiryTime());
             statement.setString(55, getName());
             statement.setLong(56, getDeathPenaltyBuffLevel());
-            statement.setInt(57, getObjectId());
+            statement.setString(57, getAnnounce());
+            statement.setInt(58, getObjectId());
 
             statement.execute();
             statement.close();
@@ -8215,6 +8226,15 @@
         return true;
     }
 
+    public String getAnnounce()
+    {
+        return announce;
+    }
+   
+    public void setAnnounce(String newAnnounce){
+        announce = newAnnounce;
+    }
+   
     public boolean isNoble()
     {
         return _noble;
Index: java/net/sf/l2j/gameserver/serverpackets/ExShowScreenMessage.java
===================================================================
--- java/net/sf/l2j/gameserver/serverpackets/ExShowScreenMessage.java    (revision 0)
+++ java/net/sf/l2j/gameserver/serverpackets/ExShowScreenMessage.java    (revision 0)
@@ -0,0 +1,125 @@
+/*
+ * This program is free software: you can redistribute it and/or modify it under
+ * the terms of the GNU General Public License as published by the Free Software
+ * Foundation, either version 3 of the License, or (at your option) any later
+ * version.
+ *
+ * This program is distributed in the hope that it will be useful, but WITHOUT
+ * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
+ * FOR A PARTICULAR PURPOSE. See the GNU General Public License for more
+ * details.
+ *
+ * You should have received a copy of the GNU General Public License along with
+ * this program. If not, see <http://www.gnu.org/licenses/>.
+ */
+package net.sf.l2j.gameserver.serverpackets;
+
+public class ExShowScreenMessage extends L2GameServerPacket
+{
+    public static enum SMPOS
+    {
+        DUMMY, TOP_LEFT, TOP_CENTER, TOP_RIGHT, MIDDLE_LEFT, MIDDLE_CENTER, MIDDLE_RIGHT, BOTTOM_CENTER, BOTTOM_RIGHT,
+    }
+   
+    private final int _type;
+    private final int _sysMessageId;
+    private final int _hide;
+    private final int _unk2;
+    private final int _unk3;
+    private final int _unk4;
+    private final int _size;
+    private final int _position;
+    private final boolean _effect;
+    private final String _text;
+    private final int _time;
+   
+    public ExShowScreenMessage(String text, int time)
+    {
+        _type = 1;
+        _sysMessageId = -1;
+        _hide = 0;
+        _unk2 = 0;
+        _unk3 = 0;
+        _unk4 = 0;
+        _position = 0x02;
+        _text = text;
+        _time = time;
+        _size = 0;
+        _effect = false;
+    }
+   
+    public ExShowScreenMessage(String text, int time, SMPOS pos, boolean effect)
+    {
+        this(text, time, pos.ordinal(), effect);
+    }
+   
+    public ExShowScreenMessage(String text, int time, int pos, boolean effect)
+    {
+        _type = 1;
+        _sysMessageId = -1;
+        _hide = 0;
+        _unk2 = 0;
+        _unk3 = 0;
+        _unk4 = 0;
+        _position = pos;
+        _text = text;
+        _time = time;
+        _size = 0;
+        _effect = effect;
+    }
+   
+    public ExShowScreenMessage(int type, int messageId, int position, int unk1, int size, int unk2, int unk3, boolean showEffect, int time, int unk4, String text)
+    {
+        _type = type;
+        _sysMessageId = messageId;
+        _hide = unk1;
+        _unk2 = unk2;
+        _unk3 = unk3;
+        _unk4 = unk4;
+        _position = position;
+        _text = text;
+        _time = time;
+        _size = size;
+        _effect = showEffect;
+    }
+   
+    // Close packet
+    public ExShowScreenMessage()
+    {
+        _type = 1;
+        _sysMessageId = -1;
+        _hide = 1; // hide it
+        _unk2 = 0;
+        _unk3 = 0;
+        _unk4 = 0;
+        _position = 0x02;
+        _text = "";
+        _time = 0;
+        _size = 0;
+        _effect = false;
+    }
+   
+    @Override
+    public String getType()
+    {
+        return "[S]FE:39 ExShowScreenMessage";
+    }
+   
+    @Override
+    protected void writeImpl()
+    {
+        writeC(0xfe);
+        writeH(0x38);
+        writeD(_type); // 0 - system messages, 1 - your defined text
+        writeD(_sysMessageId); // system message id (_type must be 0 otherwise no effect)
+        writeD(_position); // message position
+        writeD(_hide); // hide
+        writeD(_size); // font size 0 - normal, 1 - small
+        writeD(_unk2); // ?
+        writeD(_unk3); // ?
+        writeD(_effect == true ? 1 : 0); // upper effect (0 - disabled, 1 enabled) - _position must be 2 (center) otherwise no effect
+        writeD(_time); // time
+        writeD(_unk4); // ?
+        writeS(_text); // your text (_type must be 1, otherwise no effect)
+    }
+}
Index: java/net/sf/l2j/gameserver/clientpackets/RequestBypassToServer.java
===================================================================
--- java/net/sf/l2j/gameserver/clientpackets/RequestBypassToServer.java    (revision 5263)
+++ java/net/sf/l2j/gameserver/clientpackets/RequestBypassToServer.java    (working copy)
@@ -18,22 +18,29 @@
  */
 package net.sf.l2j.gameserver.clientpackets;
 
+import java.sql.Connection;
+import java.sql.PreparedStatement;
 import java.util.logging.Level;
 import java.util.logging.Logger;
 
 import net.sf.l2j.Config;
+import net.sf.l2j.L2DatabaseFactory;
 import net.sf.l2j.gameserver.ai.CtrlIntention;
 import net.sf.l2j.gameserver.communitybbs.CommunityBoard;
 import net.sf.l2j.gameserver.handler.AdminCommandHandler;
 import net.sf.l2j.gameserver.handler.IAdminCommandHandler;
 import net.sf.l2j.gameserver.model.L2CharPosition;
+import net.sf.l2j.gameserver.model.L2ClanMember;
 import net.sf.l2j.gameserver.model.L2Object;
 import net.sf.l2j.gameserver.model.L2World;
 import net.sf.l2j.gameserver.model.actor.instance.L2NpcInstance;
 import net.sf.l2j.gameserver.model.actor.instance.L2PcInstance;
 import net.sf.l2j.gameserver.model.entity.L2Event;
 import net.sf.l2j.gameserver.serverpackets.ActionFailed;
+import net.sf.l2j.gameserver.serverpackets.CreatureSay;
+import net.sf.l2j.gameserver.serverpackets.ExShowScreenMessage;
 import net.sf.l2j.gameserver.serverpackets.NpcHtmlMessage;
+import net.sf.l2j.gameserver.serverpackets.ExShowScreenMessage.SMPOS;
 
 /**
  * This class ...
@@ -85,6 +92,60 @@
             {
                 comeHere(activeChar);
             }
+            else if (_command.startsWith("clan_ann")){
+                String announce = _command.substring(9);
+               
+                if(announce == null || announce == ""){
+                    activeChar.sendMessage("nothing happened");
+                    return;
+                }
+               
+                else if(announce.length() >= 100){
+                    activeChar.sendMessage("Max Length: 100");
+                    return;
+                }
+               
+                else if(activeChar.hasNewAnnounce()){
+                    activeChar.sendMessage("There is already a clan announcement, delete it first.");
+                    return;
+                }
+               
+                else {
+                    CreatureSay msg1 = new CreatureSay(1,Say2.CLAN,"Clan Announcement",announce);
+                    ExShowScreenMessage msg2 = new ExShowScreenMessage(announce, 15000, SMPOS.TOP_CENTER, true);
+                    for(L2ClanMember member : activeChar.getClan().getMembers()){
+                        L2PcInstance real = member.getPlayerInstance();
+                        if(real == null)
+                            continue;
+                        if(real.isOnline() == 1){
+                        real.setAnnounce(announce);
+                        real.sendPacket(msg1);
+                        real.sendPacket(msg2);
+                        }
+                    }
+                   
+                    Connection con = null;
+                    PreparedStatement state = null;
+                   
+                    try{
+                        con = L2DatabaseFactory.getInstance().getConnection();
+                        state = con.prepareStatement("UPDATE characters SET announce=? WHERE clanid=?");
+                        state.setString(1, announce);
+                        state.setInt(2, activeChar.getClan().getClanId());
+                        state.execute();
+                       
+                        state.close();
+                    }
+                   
+                    catch(Exception ie){
+                        ie.printStackTrace();
+                    }
+                    finally{
+                        con.close();
+                    }
+                   
+                }
+            }
             else if (_command.startsWith("player_help "))
             {
                 playerHelp(activeChar, _command.substring(12));
Index: java/net/sf/l2j/gameserver/handler/VoicedCommandHandler.java
===================================================================
--- java/net/sf/l2j/gameserver/handler/VoicedCommandHandler.java    (revision 0)
+++ java/net/sf/l2j/gameserver/handler/VoicedCommandHandler.java    (working copy)
@@ -0,0 +1,98 @@
 
import net.sf.l2j.gameserver.handler.voicedcommandhandlers.Online;
+import net.sf.l2j.gameserver.handler.voicedcommandhandlers.clanannounce;
 
        registerHandler(new Online());
+        registerHandler(new clanannounce());

Index: java/net/sf/l2j/gameserver/handler/voicedcommandhandlers/clanannounce.java
===================================================================
--- java/net/sf/l2j/gameserver/handler/voicedcommandhandlers/clanannounce.java    (revision 0)
+++ java/net/sf/l2j/gameserver/handler/voicedcommandhandlers/clanannounce.java    (revision 0)
@@ -0,0 +1,108 @@
+
+package net.sf.l2j.gameserver.handler.voicedcommandhandlers;
+
+import java.sql.Connection;
+import java.sql.PreparedStatement;
+import java.sql.SQLException;
+
+import javolution.text.TextBuilder;
+import net.sf.l2j.L2DatabaseFactory;
+import net.sf.l2j.gameserver.handler.IVoicedCommandHandler;
+import net.sf.l2j.gameserver.model.L2ClanMember;
+import net.sf.l2j.gameserver.model.actor.instance.L2PcInstance;
+import net.sf.l2j.gameserver.serverpackets.ExShowScreenMessage;
+import net.sf.l2j.gameserver.serverpackets.NpcHtmlMessage;
+
+/**
+ *
+ * @author  irat
+ */
+public class clanannounce implements IVoicedCommandHandler
+{
+
+    ExShowScreenMessage screenMessage = new ExShowScreenMessage("Using clan notice system services.",2);
+    private final String[] commands = {"clanannounce_add","clanannounce_remove"};
+   
+    public boolean useVoicedCommand(String command, L2PcInstance activeChar, String target)
+    {
+        if(activeChar == null)
+            return false;
+       
+        if(!activeChar.isClanLeader())
+          return false;
+         
+        else if(activeChar.getClan() == null )
+              return false;
+       
+        else if(activeChar.getClan().getMembersCount() == 0){
+            activeChar.sendMessage("You don't have any members");
+            return false;
+        }
+       
+        if(command.equals("clanannounce_add")){
+            activeChar.sendPacket(screenMessage);
+            showChat(activeChar);   
+        }
+        else if(command.equals("clanannounce_remove")){
+            for(L2ClanMember member : activeChar.getClan().getMembers()){
+                L2PcInstance real = member.getPlayerInstance();
+               
+               
+                if(real == null)
+                    continue;
+               
+                if(real.isOnline() == 1){
+                    real.setAnnounce("");
+                }
+            }
+            Connection con = null;
+            PreparedStatement state = null;
+           
+            try{
+                con = L2DatabaseFactory.getInstance().getConnection();
+                state = con.prepareStatement("UPDATE characters SET announce=? WHERE clanid=?");
+                state.setString(1,"");
+                state.setInt(2,activeChar.getClan().getClanId());
+               
+                state.execute();
+                state.close();
+            }
+            catch(Exception ie){
+                ie.printStackTrace();
+            }
+            finally{
+                try
+                {
+                    con.close();
+                }
+                catch (SQLException e2)
+                {
+                    //
+                }
+            }
+        }
+        return true;
+    }
+   
+    private void showChat(L2PcInstance playable){
+        NpcHtmlMessage html = new NpcHtmlMessage(1);
+        TextBuilder tb = new TextBuilder();
+       
+        tb.append("<html><head>");
+        tb.append("<title>Clan Notice</title></head><body>");
+        tb.append("<center><font color=\"FFFF00\">Hey! Welcome </font>"+"<font color=\"FF11FF\">"+playable.getName()+"</font></center>");
+        tb.append("<font color=\"FFAA23\">Here you can handle the clan notice system.<br>Create a new announce to broadcast in all your clan members.<br>Offline members will be informed when they log in.</font>");
+        tb.append("<br><br><center><font color=\"55FF55\">Creating New Announce:</font><br>");
+        tb.append("<multiedit var=\"clan_announce\" width=240 height=30>");
+        tb.append("<br><button value=\"Broadcast Announce\" action=\"bypass -h clan_ann $clan_announce\" width=60 height=15 length=\"3000\" back=\"sek.cbui94\" fore=\"sek.cbui92\"><br>");
+        tb.append("</center></body></html>");
+        html.setHtml(tb.toString());
+        playable.sendPacket(html);
+    }
+
+    public String[] getVoicedCommandList()
+    {
+        return commands;
+    }
+   
+}