/* * Copyright (C) 2004-2015 L2J DataPack * * This file is part of L2J DataPack. * * L2J DataPack 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. * * L2J DataPack 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 . */ package handlers.admincommandhandlers; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.logging.Logger; import com.l2jserver.commons.database.pool.impl.ConnectionFactory; import com.l2jserver.gameserver.handler.IAdminCommandHandler; import com.l2jserver.gameserver.instancemanager.QuestManager; import com.l2jserver.gameserver.model.L2Object; import com.l2jserver.gameserver.model.L2World; import com.l2jserver.gameserver.model.actor.instance.L2PcInstance; import com.l2jserver.gameserver.model.quest.Quest; import com.l2jserver.gameserver.model.quest.QuestState; import com.l2jserver.gameserver.model.quest.State; import com.l2jserver.gameserver.network.SystemMessageId; import com.l2jserver.gameserver.network.serverpackets.ExShowQuestMark; import com.l2jserver.gameserver.network.serverpackets.NpcHtmlMessage; import com.l2jserver.gameserver.network.serverpackets.QuestList; /** * TODO: Rework and cleanup. * @author Korvin, Zoey76 */ public class AdminShowQuests implements IAdminCommandHandler { private static final Logger _log = Logger.getLogger(AdminShowQuests.class.getName()); private static final String[] ADMIN_COMMANDS = { "admin_charquestmenu", "admin_setcharquest" }; private static final String[] _states = { "CREATED", "STARTED", "COMPLETED" }; @Override public boolean useAdminCommand(String command, L2PcInstance activeChar) { String[] cmdParams = command.split(" "); L2PcInstance target = null; L2Object targetObject = null; String[] val = new String[4]; val[0] = null; if (cmdParams.length > 1) { target = L2World.getInstance().getPlayer(cmdParams[1]); if (cmdParams.length > 2) { if (cmdParams[2].equals("0")) { val[0] = "var"; val[1] = "Start"; } if (cmdParams[2].equals("1")) { val[0] = "var"; val[1] = "Started"; } if (cmdParams[2].equals("2")) { val[0] = "var"; val[1] = "Completed"; } if (cmdParams[2].equals("3")) { val[0] = "full"; } if (cmdParams[2].indexOf("_") != -1) { val[0] = "name"; val[1] = cmdParams[2]; } if (cmdParams.length > 3) { if (cmdParams[3].equals("custom")) { val[0] = "custom"; val[1] = cmdParams[2]; } } } } else { targetObject = activeChar.getTarget(); if ((targetObject != null) && targetObject.isPlayer()) { target = targetObject.getActingPlayer(); } } if (target == null) { activeChar.sendPacket(SystemMessageId.INCORRECT_TARGET); return false; } if (command.startsWith("admin_charquestmenu")) { if (val[0] != null) { showQuestMenu(target, activeChar, val); } else { showFirstQuestMenu(target, activeChar); } } else if (command.startsWith("admin_setcharquest")) { if (cmdParams.length >= 5) { val[0] = cmdParams[2]; val[1] = cmdParams[3]; val[2] = cmdParams[4]; if (cmdParams.length == 6) { val[3] = cmdParams[5]; } setQuestVar(target, activeChar, val); } else { return false; } } return true; } private static void showFirstQuestMenu(L2PcInstance target, L2PcInstance actor) { StringBuilder replyMSG = new StringBuilder("
Player: " + target.getName() + "
"); final NpcHtmlMessage adminReply = new NpcHtmlMessage(); int ID = target.getObjectId(); replyMSG.append("Quest Menu for " + target.getName() + " (ID:" + ID + ")
"); replyMSG.append(""); replyMSG.append(""); replyMSG.append(""); replyMSG.append(""); replyMSG.append(""); replyMSG.append(""); replyMSG.append("



Manual Edit by Quest number:

"); adminReply.setHtml(replyMSG.toString()); actor.sendPacket(adminReply); } private static void showQuestMenu(L2PcInstance target, L2PcInstance actor, String[] val) { // TODO(Zoey76): Refactor this into smaller methods and separate database access logic from HTML creation. try (Connection con = ConnectionFactory.getInstance().getConnection()) { ResultSet rs; PreparedStatement req; int ID = target.getObjectId(); StringBuilder replyMSG = new StringBuilder(""); final NpcHtmlMessage adminReply = new NpcHtmlMessage(); switch (val[0]) { case "full": { replyMSG.append(""); req = con.prepareStatement("SELECT DISTINCT name FROM character_quests WHERE charId='" + ID + "' AND var='' ORDER by name"); req.execute(); rs = req.getResultSet(); while (rs.next()) { replyMSG.append(""); } replyMSG.append("
Full Quest List for " + target.getName() + " (ID:" + ID + ")
" + rs.getString(1) + "
"); break; } case "name": { QuestState qs = target.getQuestState(val[1]); String state = (qs != null) ? _states[qs.getState()] : "CREATED"; replyMSG.append("Character: " + target.getName() + "
Quest: " + val[1] + "
State: " + state + "

"); replyMSG.append("
"); req = con.prepareStatement("SELECT var,value FROM character_quests WHERE charId='" + ID + "' and name='" + val[1] + "'"); req.execute(); rs = req.getResultSet(); while (rs.next()) { String var_name = rs.getString(1); if (var_name.equals("")) { continue; } replyMSG.append(""); } replyMSG.append("
VarValueNew Value 
" + var_name + "" + rs.getString(2) + "


"); replyMSG.append(""); replyMSG.append(""); replyMSG.append("
Repeatable quest:Unrepeatable quest:


Delete Quest from DB:
"); break; } case "var": { replyMSG.append("Character: " + target.getName() + "
Quests with state: " + val[1] + "
"); replyMSG.append(""); req = con.prepareStatement("SELECT DISTINCT name FROM character_quests WHERE charId='" + ID + "' and var='' and value='" + val[1] + "'"); req.execute(); rs = req.getResultSet(); while (rs.next()) { replyMSG.append(""); } replyMSG.append("
" + rs.getString(1) + "
"); break; } case "custom": { boolean exqdb = true; boolean exqch = true; int qnumber = Integer.parseInt(val[1]); String state = null; String qname = null; QuestState qs = null; Quest quest = QuestManager.getInstance().getQuest(qnumber); if (quest != null) { qname = quest.getName(); qs = target.getQuestState(qname); } else { exqdb = false; } if (qs != null) { state = _states[qs.getState()]; } else { exqch = false; state = "N/A"; } if (exqdb) { if (exqch) { replyMSG.append("Character: " + target.getName() + "
Quest: " + qname + "
State: " + state + "

"); replyMSG.append("
"); req = con.prepareStatement("SELECT var,value FROM character_quests WHERE charId='" + ID + "' and name='" + qname + "'"); req.execute(); rs = req.getResultSet(); while (rs.next()) { String var_name = rs.getString(1); if (var_name.equals("")) { continue; } replyMSG.append(""); } replyMSG.append("
VarValueNew Value 
" + var_name + "" + rs.getString(2) + "


"); replyMSG.append(""); replyMSG.append(""); replyMSG.append("
Repeatable quest:Unrepeatable quest:


Delete Quest from DB:
"); } else { replyMSG.append("Character: " + target.getName() + "
Quest: " + qname + "
State: " + state + "

"); replyMSG.append("
Start this Quest for player:
"); replyMSG.append("
"); } } else { replyMSG.append("
Quest with number " + qnumber + " doesn't exist!
"); } break; } } adminReply.setHtml(replyMSG.toString()); actor.sendPacket(adminReply); } catch (Exception e) { actor.sendMessage("There was an error."); _log.warning(AdminShowQuests.class.getSimpleName() + ": " + e.getMessage()); } } private static void setQuestVar(L2PcInstance target, L2PcInstance actor, String[] val) { QuestState qs = target.getQuestState(val[0]); String[] outval = new String[3]; if (val[1].equals("state")) { switch (val[2]) { case "COMPLETED": { qs.exitQuest((val[3].equals("1")) ? true : false); break; } case "DELETE": { Quest.deleteQuestInDb(qs, true); qs.exitQuest(true); target.sendPacket(new QuestList()); target.sendPacket(new ExShowQuestMark(qs.getQuest().getId())); break; } case "CREATE": { qs = QuestManager.getInstance().getQuest(Integer.parseInt(val[0])).newQuestState(target); qs.setState(State.STARTED); qs.set("cond", "1"); target.sendPacket(new QuestList()); target.sendPacket(new ExShowQuestMark(qs.getQuest().getId())); val[0] = qs.getQuest().getName(); break; } case "CC": { qs = QuestManager.getInstance().getQuest(Integer.parseInt(val[0])).newQuestState(target); qs.exitQuest(false); target.sendPacket(new QuestList()); target.sendPacket(new ExShowQuestMark(qs.getQuest().getId())); val[0] = qs.getQuest().getName(); break; } } } else { if (val[2].equals("delete")) { qs.unset(val[1]); } else { qs.set(val[1], val[2]); } target.sendPacket(new QuestList()); target.sendPacket(new ExShowQuestMark(qs.getQuest().getId())); } actor.sendMessage(""); outval[0] = "name"; outval[1] = val[0]; showQuestMenu(target, actor, outval); } @Override public String[] getAdminCommandList() { return ADMIN_COMMANDS; } }