Jump to content
  • 0

Question

Posted (edited)

paidia vazw ena npc pou deixnei ta rb an einai alive i dead kai mou vgazei kati null mesa sto npc enw to code dn exei tpt 

mporeite na help ?

 

Shot00000.png

 

/*
 * 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 2, 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, write to the Free Software
 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA
 * 02111-1307, USA.
 *
 * http://www.gnu.org/copyleft/gpl.html
 */
package net.sf.l2j.gameserver.model.actor.instance;


import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;


import net.sf.l2j.L2DatabaseFactory;
import net.sf.l2j.gameserver.ai.CtrlIntention;
import net.sf.l2j.gameserver.model.actor.L2Npc;
import net.sf.l2j.gameserver.network.serverpackets.ActionFailed;
import net.sf.l2j.gameserver.network.serverpackets.MyTargetSelected;
import net.sf.l2j.gameserver.network.serverpackets.NpcHtmlMessage;
import net.sf.l2j.gameserver.network.serverpackets.ValidateLocation;
import net.sf.l2j.gameserver.templates.chars.L2NpcTemplate;


public class L2RBStatsInstance extends L2Npc {


public L2RBStatsInstance(int objectId, L2NpcTemplate template) {
super(objectId, template);
// TODO Auto-generated constructor stub
}


public void onAction(L2PcInstance player) {
if (this != player.getTarget())
        {
            player.setTarget(this);
            player.sendPacket(new MyTargetSelected(getObjectId(), 0));
            player.sendPacket(new ValidateLocation(this));
        }
        else
        {
            player.sendPacket(new MyTargetSelected(getObjectId(), 0));
            player.getAI().setIntention(CtrlIntention.INTERACT, this);
            
            if (!isInsideRadius(player, 150, false, false))
                player.sendPacket(ActionFailed.STATIC_PACKET);
            else
             showHtmlWindow(player);
        }
    }


private void showHtmlWindow(L2PcInstance activeChar)
{
showChatWindow(activeChar);


activeChar.sendPacket(ActionFailed.STATIC_PACKET);
}




@Override 
public void showChatWindow(L2PcInstance player) {
NpcHtmlMessage msg = new NpcHtmlMessage(this.getObjectId());
StringBuilder tb = new StringBuilder();
PreparedStatement statement = null;
ResultSet rset = null;
HashMap<Integer,String> raidboss = new  HashMap<Integer,String>();


raidboss.put(29001,"Queen Ant");
raidboss.put(29006,"Core");
raidboss.put(29014,"Orfen");
raidboss.put(29019,"Antharas");
raidboss.put(29020,"Baium");
raidboss.put(29022,"Zaken");
raidboss.put(29028,"Valakas");
raidboss.put(25035,"Shilen's Messenger Cabrio");
raidboss.put(25126,"Longhorn Golkonda");
raidboss.put(25054,"Kernon");
raidboss.put(25220,"Death Lord Hallate");
raidboss.put(25229,"Storm Winged Naga");
raidboss.put(25099,"Bloody Tree Vermilion");
raidboss.put(25276,"Death Lord Ipos");
raidboss.put(25255,"Gargoyle Lord Tiphon");
raidboss.put(25252,"Palibati Queen Themis");
raidboss.put(25266,"Bloody Empress Decarbia");
raidboss.put(25315,"Varka's Chief Horus");
raidboss.put(25312,"Varka's Commander Mos");
raidboss.put(25309,"Varka's Hero Shadith");
raidboss.put(25235,"Vanor Chief Kandra");
raidboss.put(25269,"Beast Lord Behemoth");
raidboss.put(25143,"Fire of Wrath Shuriel");
raidboss.put(25109,"Antharas Priest Cloe");
raidboss.put(25245,"Last Lesser Giant Glaki");
raidboss.put(25293,"Hestia Guardian Deity of the Hot Springs");
raidboss.put(25299,"Ketra's Hero Hekaton");
raidboss.put(25302,"Ketra's Commander Tayr");
raidboss.put(25305,"Ketra's Chief Brakki");
raidboss.put(25322,"Demon's Agent Falston");
raidboss.put(25328,"Eilhalder von Hellmann");
raidboss.put(25450,"Cherub Galaxia");
raidboss.put(25244,"Last Lesser Giant Olkuth");








tb.append("<html><title>Raid Boss Status</title><body><center><br>");


try (Connection con = L2DatabaseFactory.getInstance().getConnection())
{
statement = con.prepareStatement("SELECT boss_id, respawn_time FROM grandboss_data UNION SELECT boss_id, respawn_time FROM raidboss_spawnlist");


rset = statement.executeQuery();
tb.append("<table width=\"280\">");
tb.append("<tr><td>Name</td>");
tb.append("<td>Status</td></tr>");


while (rset.next())
{


tb.append("<tr><td>" + raidboss.get(rset.getInt("boss_id")) + "</td>");
if (rset.getLong("respawn_time") > 0)
tb.append("<td>" + "Dead" + "</td></tr>");
else
tb.append("<td>" + "Alive" + "</td></tr>");


}
tb.append("</table>");


rset.close();
statement.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
  
  tb.append("</center></body></html>");
  
  msg.setHtml(tb.toString());
  msg.replace("%objectId%", String.valueOf(this.getObjectId()));
  player.sendPacket(msg);
}
}
Edited by MeVsYou

Recommended Posts

  • 0
Posted

ayto bgainei giati stin sql iparxoun kapia rb pou den mpikan sto hashmap

 

edw diladi


HashMap<Integer,String> raidboss = new  HashMap<Integer,String>();

raidboss.put(29001,"Queen Ant");

[/code

 

pane des pia loipoun 

kai bale aytes tis grames

 

raidboss.put(<to id tou boss p lipei>,"<to onoma tou boss p lipei>");

 

(an kai tha eprepe na ginei allios to code ayto einai ena hotfix)

  • 0
Posted

ma den 8elw na upoarxoun sto npc mou auta pou leipoun

wraia pare kai svise tis grammes pou den thes 

 

raidboss.put(25220,"Death Lord Hallate");

 

ayto px leei oti einai to death lord hallate pare kai svise olo to lane ap ta npc pou den thes. prosexe omws min sviseis kanena ;  katalathos kai sou vgazei error

  • 0
Posted

tpt pali ta idia 

egw to ekana anti gia retsi raidboss.put(25220,"Death Lord Hallate");

etsi   raidboss.put(25220,"");

i mipos ennoeis kati allo ?

svise oli ti grammi..kanto etsi diladi:

 

raidboss.put(29001,"Queen Ant");

raidboss.put(29006,"Core");

raidboss.put(29014,"Orfen");

raidboss.put(29019,"Antharas");

raidboss.put(29020,"Baium");

raidboss.put(29022,"Zaken");

raidboss.put(29028,"Valakas");

raidboss.put(25035,"Shilen's Messenger Cabrio");

raidboss.put(25126,"Longhorn Golkonda");

raidboss.put(25054,"Kernon");

raidboss.put(25229,"Storm Winged Naga");

raidboss.put(25099,"Bloody Tree Vermilion");

raidboss.put(25276,"Death Lord Ipos");

raidboss.put(25255,"Gargoyle Lord Tiphon");

raidboss.put(25252,"Palibati Queen Themis");

raidboss.put(25266,"Bloody Empress Decarbia");

raidboss.put(25315,"Varka's Chief Horus");

raidboss.put(25312,"Varka's Commander Mos");

raidboss.put(25309,"Varka's Hero Shadith");

raidboss.put(25235,"Vanor Chief Kandra");

raidboss.put(25269,"Beast Lord Behemoth");

raidboss.put(25143,"Fire of Wrath Shuriel");

raidboss.put(25109,"Antharas Priest Cloe");

raidboss.put(25245,"Last Lesser Giant Glaki");

raidboss.put(25293,"Hestia Guardian Deity of the Hot Springs");

raidboss.put(25299,"Ketra's Hero Hekaton");

raidboss.put(25302,"Ketra's Commander Tayr");

raidboss.put(25305,"Ketra's Chief Brakki");

raidboss.put(25322,"Demon's Agent Falston");

raidboss.put(25328,"Eilhalder von Hellmann");

raidboss.put(25450,"Cherub Galaxia");

raidboss.put(25244,"Last Lesser Giant Olkuth");

  • 0
Posted

mou vgazei episis sto console auto edw:

 

SpawnTable: Could not store spawn in the DB:com.mysql.jdbc.MysqlDataTruncation:
Data truncation: Out of range value for column 'npc_templateid' at row 1
  • 0
Posted

 

mou vgazei episis sto console auto edw:

 

SpawnTable: Could not store spawn in the DB:com.mysql.jdbc.MysqlDataTruncation:
Data truncation: Out of range value for column 'npc_templateid' at row 1

 

exei xexwrista html ayto to npc?

  • 0
Posted (edited)

 

mou vgazei episis sto console auto edw:

 

SpawnTable: Could not store spawn in the DB:com.mysql.jdbc.MysqlDataTruncation:
Data truncation: Out of range value for column 'npc_templateid' at row 1

 

SPAWNTABLE(spawnlist) 

COLUMN  'npc_templateid' 

OUT OF RANGE VALUE

Mipos evales kanena trelo noumero ekei?? :P

Edited by Dante44®
  • 0
Posted

nai exei ksexwrista 

afou exei xexwrista tote apo kei tha ta sviseis nomiza to html einai grammeno sto script. tha vreis to html pou leei to raidboss pou thes na sviseis kai tha sviseis ti grammi pou thes. an den xereis pws kanto post edw na se voithisoume

Guest
This topic is now closed to further replies.



  • Posts

    • New implementations   Autofarm complete system with time limit fully configurable   Tournament 1vs1 ( not instanced ) With queue fully configurable ( possibility to run all day or 2 different hours for example Latin/Europe   Fortress vs Fortress event automated with top killer reward , protections and fully configurable with seperated .ini   And more
    • Anybody has these monsters ripped from the latest chronicle lineagemonsters14.volcanic_archer_m00 lineagemonsters14.volcanic_ice_m00 lineagemonsters14.volcanic_magic_m00 lineagemonsters14.volcanic_warrior_m00 lineagemonsters14.volcanic_boss_m00  
    • this is literally like such bad advice? i dont thikn you understand the question..   node_begin name=[Ability] type=5 sub_node_begin paramType=100 unk=0 nodeName=[Type] int_params={1;1;1;1;1;1;1;1;1;1;1;1;1;1;1;1;1;1;1;1;1;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;3;3;3;3;3;3;3;3;3;3;3;3;3;3;3;3;3} sub_node_end sub_node_begin paramType=100 unk=0 nodeName=[SkillID] int_params={19233;19234;19235;19236;19237;19238;19239;19240;19241;19242;19243;19244;19245;19246;19247;19248;19249;19250;19251;19252;19253;19254;19255;19256;19257;19258;19259;19260;19261;19262;19263;19264;19265;19266;19267;19268;19269;19270;19271;19272;19273;19274;19275;19276;19277;19278;19279;19280;19281;19282;19283;19284;19285;19286;19287;19288;19289} sub_node_end sub_node_begin paramType=100 unk=0 nodeName=[SkillLev] int_params={3;3;3;3;2;2;2;2;4;1;4;1;2;2;2;2;2;1;1;2;1;2;4;4;3;2;3;1;3;2;3;1;2;2;1;2;2;2;2;1;2;3;3;3;3;1;3;2;1;2;2;2;2;2;2;2;1} sub_node_end sub_node_begin paramType=100 unk=0 nodeName=[Depth] int_params={1;1;1;1;2;2;2;2;3;3;3;3;4;4;4;4;5;5;5;5;6;1;1;1;2;2;2;2;3;3;3;3;4;4;4;4;5;5;5;6;1;1;1;2;2;2;3;3;3;4;4;4;4;5;5;5;6} sub_node_end sub_node_begin paramType=100 unk=0 nodeName=[Column] int_params={1;2;3;4;1;2;3;4;1;2;3;4;1;2;3;4;1;2;3;4;2;1;2;4;1;2;3;4;1;2;3;4;1;2;3;4;1;2;4;2;1;2;4;1;3;4;1;2;4;1;2;3;4;1;2;4;2} sub_node_end sub_node_begin paramType=100 unk=0 nodeName=[RequireLev] int_params={85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85;85} sub_node_end sub_node_begin paramType=100 unk=0 nodeName=[RequireSkillID] int_params={0;0;0;0;0;0;0;19236;19237;0;19239;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;19257;0;19259;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;19276;0;0;0;0;0;0;0;0;0;0} sub_node_end sub_node_begin paramType=100 unk=0 nodeName=[RequireSkillLev] int_params={0;0;0;0;0;0;0;3;2;0;2;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;3;0;3;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;3;0;0;0;0;0;0;0;0;0;0} sub_node_end sub_node_begin paramType=100 unk=0 nodeName=[RequireCount] int_params={0;0;0;0;5;5;5;5;10;10;10;10;15;15;15;15;20;20;20;20;25;0;0;0;5;5;5;5;10;10;10;10;15;15;15;15;20;20;20;25;0;0;0;5;5;5;10;10;10;15;15;15;15;20;20;20;25} sub_node_end sub_node_begin paramType=115 unk=0 nodeName=[Name] string_params={[Guardian's Shield];[Guardian's Magic Barrier];[Guardian's Body];[Guardian's Elemental Cover];[Guardian's Armor Defense];[Guardian's Leather Defense];[Guardian's Tunic Defense];[Guardian's Resistance];[Guardian's Life];[Guardian's Block];[Guardian's Armor];[Guardian's Guidance];[Guardian's Death Shield];[Guardian's Focus Shield];[Guardian's Mind Control];[Guardian's Blessing];[Guardian's Binding Cover];[Guardian's Spirit];[Guardian's Potential];[Guardian's Expert Potion];[Guardian's Defense Master];[Berserker's Haste];[Berserker's Might];[Berserker's Elemental Attack];[Berserker's Craft Focus];[Berserker's Backfire];[Berserker's Focus];[Berserker's Cost];[Berserker's Craft Death];[Berserker's Mortal];[Berserker's Death Whisper];[Berserker's Eagle];[Berserker's Battle];[Berserker's Fire];[Berserker's Skill Reduction];[Berserker's Blessing];[Berserker's Binding Attack];[Berserker's Divine Attack];[Berserker's Expert Potion];[Berserker's Combat Master];[Magician's Acumen];[Magician's Empower];[Magician's Elemental Shot];[Magician's Wild Magic];[Magician's Condition];[Magician's Eva];[Magician's Mystic];[Magician's Prominence];[Magician's Sight];[Magician's Protection];[Magician's Water];[Magician's Magic Reduction];[Magician's Blessing];[Magician's Binding Shot];[Magician's Divine Shot];[Magician's Expert Potion];[Magician's Spell Master]} sub_node_end sub_node_begin paramType=115 unk=0 nodeName=[Icon] string_params={[icon.skill19120];[icon.skill19121];[icon.skill1045];[icon.skill1352];[icon.skill0231];[icon.skill0233];[icon.skill0234];[icon.skill1354];[icon.skill1229];[icon.skill1304];[icon.skill19165];[icon.skill19127];[icon.skill1542];[icon.skill0986];[icon.skill19132];[icon.skill_exp_sp_up];[icon.skill0335];[icon.skill10044];[icon.skill1532];[icon.skill_potion_up];[icon.skill0528];[icon.skill1086];[icon.skill19139];[icon.skill19130];[icon.skill0193];[icon.skill0030];[icon.skill1077];[icon.skill19140];[icon.skill10655];[icon.skill0330];[icon.skill4278];[icon.skill19127];[icon.skill1388];[icon.skill1356];[icon.skill0758];[icon.skill_exp_sp_up];[icon.skill0983];[icon.skill11011];[icon.skill_potion_up];[icon.skill1499];[icon.skill1085];[icon.skill1059];[icon.skill19130];[icon.skill1303];[icon.skill1501];[icon.skill0214];[icon.skill19160];[icon.skill0330];[icon.skill19127];[icon.skill0046];[icon.skill1355];[icon.skill0945];[icon.skill_exp_sp_up];[icon.skill0983];[icon.skill11011];[icon.skill_potion_up];[icon.skill1500]} sub_node_end sub_node_begin paramType=115 unk=0 nodeName=[IconPanel] string_params={[icon.pannel_blessed];[icon.pannel_blessed];[icon.pannel_blessed];[icon.pannel_blessed];[icon.pannel_blessed];[icon.pannel_blessed];[icon.pannel_blessed];[icon.pannel_blessed];[icon.pannel_blessed];[icon.pannel_blessed];[icon.pannel_blessed];[icon.pannel_blessed];[icon.pannel_blessed];[icon.pannel_blessed];[icon.pannel_blessed];[icon.pannel_blessed];[icon.pannel_blessed];[icon.pannel_blessed];[icon.pannel_blessed];[icon.pannel_blessed];[icon.pannel_blessed];[icon.pannel_pupple];[icon.pannel_pupple];[icon.pannel_pupple];[icon.pannel_pupple];[icon.pannel_pupple];[icon.pannel_pupple];[icon.pannel_pupple];[icon.pannel_pupple];[icon.pannel_pupple];[icon.pannel_pupple];[icon.pannel_pupple];[icon.pannel_pupple];[icon.pannel_pupple];[icon.pannel_pupple];[icon.pannel_pupple];[icon.pannel_pupple];[icon.pannel_pupple];[icon.pannel_pupple];[icon.pannel_pupple];[icon.panel_2];[icon.panel_2];[icon.panel_2];[icon.panel_2];[icon.panel_2];[icon.panel_2];[icon.panel_2];[icon.panel_2];[icon.panel_2];[icon.panel_2];[icon.panel_2];[icon.panel_2];[icon.panel_2];[icon.panel_2];[icon.panel_2];[icon.panel_2];[icon.panel_2]} sub_node_end sub_node_begin paramType=109 unk=0 nodeName=[LevelDesc] array_params={{[P. Def. + 2%];[P. Def. + 4%];[P. Def. + 7%]};{[M. Def. + 2%];[M. Def. + 4%];[M. Def. + 7%]};{[Max HP + 3%];[Max HP + 6%];[Max HP + 9%]};{[All Attribute Defense + 15];[All Attribute Defense + 25];[All Attribute Defense + 40]};{[When equipping Heavy Armor <br>P./M. Def. + 3%];[When equipping Heavy Armor <br>P./M. Def. + 6%]};{[When equipping Light Armor <br>P./M. Def. + 3%];[When equipping Light Armor <br>P./M. Def. + 6%]};{[When equipping Robe <br>P./M. Def. + 3%];[When equipping Robe <br>P./M. Def. + 6%]};{[Debuff Resistance + 5%];[Debuff Resistance + 10%]};{[Max HP + 3%];[Max HP + 6%];[Max HP + 10%];[Max HP + 15%]};{[Shield Defense + 100%]};{[P. Def. + 2%];[P. Def. + 4%];[P. Def. + 8%];[P. Def. + 12%]};{[P. Accuracy, M. Accuracy,<br>servitor's P. Accuracy + 12.<br>Enchants Revelation skill]};{[Received P. Critical Damage - 10%];[Received P. Critical Damage - 20%]};{[Chance of receiving P. Critical Damage - 15%];[Chance of receiving P. Critical Damage - 30%]};{[Skill Cooldown - 3%];[Skill Cooldown - 5%]};{[EXP, SP + 5%];[EXP, SP + 10%]};{[Received damage when immobilized - 7%];[Received damage when immobilized - 15%]};{[All Attribute Defense + 50]};{[Skill Critical Rate + 10%]};{[Recovery Potion, Elixir Effect + 500];[Recovery Potion, Elixir Effect + 1000]};{[Received Damage - 10%]};{[Atk. Spd. + 1%];[Atk. Spd. + 3%]};{[P. Atk. + 1%];[P. Atk. + 2%];[P. Atk. + 3%];[P. Atk. + 4%]};{[Attack Attribute + 10];[Attack Attribute + 20];[Attack Attribute + 30];[Attack Attribute + 40]};{[P. Skill Critical Rate + 3%];[P. Skill Critical Rate + 6%];[P. Skill Critical Rate + 10%]};{[Rear Damage + 2%];[Rear Damage + 5%]};{[P. Critical Rate + 10];[P. Critical Rate + 20];[P. Critical Rate + 40]};{[Skill MP Consumption - 5%]};{[P. Skill Critical Damage + 2%];[P. Skill Critical Damage + 4%];[P. Skill Critical Damage + 7%]};{[Skill Mastery Rate + 30%];[Skill Mastery Rate + 60%]};{[P. Critical Damage + 2%];[P. Critical Damage + 4%];[P. Critical Damage + 7%]};{[P. Accuracy, M. Accuracy,<br>servitor's P. Accuracy + 12.<br>Enchants Revelation skill]};{[P. Atk. + 3%];[P. Atk. + 6%]};{[P. Skill Power + 2%];[P. Skill Power + 5%]};{[Skill Cooldown - 3%]};{[EXP, SP + 5%];[EXP, SP + 10%]};{[Damage to immobilized<br>targets + 5%];[Damage to immobilized<br>targets + 10%]};{[Attack Attribute + 25];[Attack Attribute + 50]};{[Recovery Potion, Elixir Effect + 500];[Recovery Potion, Elixir Effect + 1000]};{[Damage + 10%]};{[Casting Spd. + 2%];[Casting Spd. + 4%]};{[M. Atk. + 2%];[M. Atk. + 5%];[M. Atk. + 8%]};{[Attack Attribute + 10];[Attack Attribute + 20];[Attack Attribute + 40]};{[M. Critical Rate + 10];[M. Critical Rate + 20];[M. Critical Rate + 40]};{[Max HP, MP + 3%];[Max HP, MP + 6%];[Max HP, MP + 9%]};{[Skill MP Consumption - 5%]};{[M. Critical Damage + 3%];[M. Critical Damage + 6%];[M. Critical Damage + 10%]};{[Skill Mastery Rate + 30%];[Skill Mastery Rate + 60%]};{[P. Accuracy, M. Accuracy,<br>servitor's P. Accuracy + 12.<br>Enchants Revelation skill]};{[Mental, Stun, Aerial Yoke<br>Success Rate + 5%];[Mental, Stun, Aerial Yoke<br>Success Rate + 10%]};{[M. Skill Power + 2%];[M. Skill Power + 5%]};{[Skill Cooldown - 3%];[Skill Cooldown - 5%]};{[EXP, SP + 5%];[EXP, SP + 10%]};{[Damage to Immobile<br>Opponents + 5%];[Damage to Immobile<br>Opponents + 10%]};{[Attack Attribute + 25];[Attack Attribute + 50]};{[Recovery Potion, Elixir Effect + 500];[Recovery Potion, Elixir Effect + 1000]};{[Damage + 10%]}} sub_node_end node_end @babyjason in regards to your post ><
  • Topics

×
×
  • 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..