Help Error Code

xTakegawa · November 26, 2014

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 ?

/*
 * 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 November 26, 2014 by MeVsYou

Devlin · November 28, 2014

http://pastebin.com/MTACLPtD

και για grandboss μαζί

Boorinio · November 26, 2014

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)

xTakegawa · November 26, 2014

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

nikosdevil20 · November 27, 2014

On 11/26/2014 at 11:08 PM, xTakegawa said:
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

xTakegawa · November 27, 2014

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 ?

nikosdevil20 · November 27, 2014

On 11/27/2014 at 12:16 PM, xTakegawa said:

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");

xTakegawa · November 27, 2014

pali null mou vgazei :/

xTakegawa · November 27, 2014

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

nikosdevil20 · November 27, 2014

On 11/27/2014 at 9:30 PM, xTakegawa said:

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?

Dante44® · November 27, 2014

On 11/27/2014 at 9:30 PM, xTakegawa said:

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 November 27, 2014 by Dante44®

xTakegawa · November 27, 2014

On 11/27/2014 at 10:52 PM, nikosdevil20 said:
exei xexwrista html ayto to npc?

nai exei ksexwrista

xTakegawa · November 27, 2014

On 11/27/2014 at 10:59 PM, Dante44® said:

SPAWNTABLE(spawnlist)

COLUMN 'npc_templateid'

OUT OF RANGE VALUE

Mipos evales kanena trelo noumero ekei?? :P

oxi dn to peiraksa kan :/

nikosdevil20 · November 27, 2014

On 11/27/2014 at 11:41 PM, xTakegawa said:
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

Dante44® · November 27, 2014

On 11/27/2014 at 11:42 PM, xTakegawa said:
oxi dn to peiraksa kan :/

Pote sto petaei to error auto? otan klineis ton server??

xTakegawa · November 27, 2014

On 11/27/2014 at 11:45 PM, Dante44® said:
Pote sto petaei to error auto? otan klineis ton server??

otan ton anoigw

Help Error Code

Question

xTakegawa

31 answers to this question

Recommended Posts

Devlin

Boorinio

xTakegawa

nikosdevil20

xTakegawa

nikosdevil20

xTakegawa

xTakegawa

nikosdevil20

Dante44®

xTakegawa

xTakegawa

nikosdevil20

Dante44®

xTakegawa

Posts

Topics

Browse

Activity

Store