/*
This file is part of the OdinMS Maple Story Server
Copyright (C) 2008 ~ 2010 Patrick Huy <patrick.huy@frz.cc>
Matthias Butz <matze@odinms.de>
Jan Christian Meyer <vimes@odinms.de>
This program is free software: you can redistribute it and/or modify
it under the terms of the GNU Affero General Public License version 3
as published by the Free Software Foundation. You may not use, modify
or distribute this program under any other version of the
GNU Affero General Public License.
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 Affero General Public License for more details.
You should have received a copy of the GNU Affero General Public License
along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
package client.inventory;
import java.awt.Point;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.io.Serializable;
import java.util.List;
import java.util.logging.Level;
import java.util.logging.Logger;
import database.DatabaseConnection;
import java.util.ArrayList;
import server.MapleItemInformationProvider;
import server.movement.LifeMovement;
import server.movement.LifeMovementFragment;
import server.movement.StaticLifeMovement;
public class MaplePet implements Serializable {
public static enum PetFlag {
ITEM_PICKUP(0x01, 5190000, 5191000), // 撿道具技能
EXPAND_PICKUP(0x02, 5190002, 5191002), // 擴大移動範圍技能
AUTO_PICKUP(0x04, 5190003, 5191003), // 範圍自動撿起功能
UNPICKABLE(0x08, 5190005, -1), // 勿撿特定道具技能
LEFTOVER_PICKUP(0x10, 5190004, 5191004), // 撿起無所有權道具&楓幣技能
HP_CHARGE(0x20, 5190001, 5191001), // 自動服用HP藥水技能
MP_CHARGE(0x40, 5190006, -1), // 自動服用MP藥水技能
PET_BUFF(0x80, 5190007, -1), // 寵物召喚
PET_DRAW(0x100, 5190008, -1), // 自言自語
PET_DIALOGUE(0x200, 5190010, -1), // 寵物自動加持技能
寵物萬能療傷藥(0x400, 5190009, -1), // 寵物萬能療傷藥自動使用技能
PET_SMART(0x800, 5190011, -1), // 寵物訓練技能
寵物巨大化(0x1000, 5190012, -1); // 寵物巨大技能
private final int i, item, remove;
private PetFlag(int i, int item, int remove) {
this.i = i;
this.item = item;
this.remove = remove;
}
public final int getValue() {
return i;
}
public final boolean check(int flag) {
return (flag & i) == i;
}
public static final PetFlag getByAddId(final int itemId) {
for (PetFlag flag : PetFlag.values()) {
if (flag.item == itemId) {
return flag;
}
}
return null;
}
public static final PetFlag getByDelId(final int itemId) {
for (PetFlag flag : PetFlag.values()) {
if (flag.remove == itemId) {
return flag;
}
}
return null;
}
}
private static final long serialVersionUID = 9179541993413738569L;
private String name;
private int Fh = 0, stance = 0, uniqueid, petitemid, secondsLeft = 0, skillid;
private Point pos;
private byte fullness = 100, level = 1, summoned = 0;
private short inventorypos = 0, closeness = 0, flags = 0;
private boolean changed = false;
private boolean canPickup = true;
private int[] excluded = new int[10];
private MaplePet(final int petitemid, final int uniqueid) {
this.petitemid = petitemid;
this.uniqueid = uniqueid;
for (int i = 0; i < this.excluded.length; i++) {
this.excluded[i] = 0;
}
}
private MaplePet(final int petitemid, final int uniqueid, final short inventorypos) {
this.petitemid = petitemid;
this.uniqueid = uniqueid;
this.inventorypos = inventorypos;
for (int i = 0; i < this.excluded.length; i++) {
this.excluded[i] = 0;
}
}
public static final MaplePet loadFromDb(final int itemid, final int petid, final short inventorypos) {
try {
final MaplePet ret = new MaplePet(itemid, petid, inventorypos);
Connection con = DatabaseConnection.getConnection(); // Get a connection to the database
try (PreparedStatement ps = con.prepareStatement("SELECT * FROM pets WHERE petid = ?")) {
ps.setInt(1, petid);
try (ResultSet rs = ps.executeQuery()) {
if (!rs.next()) {
rs.close();
ps.close();
return null;
}
ret.setName(rs.getString("name"));
ret.setCloseness(rs.getShort("closeness"));
ret.setLevel(rs.getByte("level"));
ret.setFullness(rs.getByte("fullness"));
ret.setSecondsLeft(rs.getInt("seconds"));
ret.setFlags(rs.getShort("flags"));
ret.setBuffSkill(rs.getInt("skillid"));
String[] list = rs.getString("excluded").split(",");
for (int i = 0; i < ret.excluded.length; i++) {
ret.excluded[i] = Integer.parseInt(list[i]);
}
ret.changed = false;
}
}
return ret;
} catch (SQLException ex) {
Logger.getLogger(MaplePet.class.getName()).log(Level.SEVERE, null, ex);
return null;
}
}
public final void saveToDb() {
if (!changed) {
return;
}
try {
try (PreparedStatement ps = DatabaseConnection.getConnection().prepareStatement("UPDATE pets SET name = ?, level = ?, closeness = ?, fullness = ?, seconds = ?, flags = ?, skillid = ?, excluded = ? WHERE petid = ?")) {
ps.setString(1, name); // Set name
ps.setByte(2, level); // Set Level
ps.setShort(3, closeness); // Set Closeness
ps.setByte(4, fullness); // Set Fullness
ps.setInt(5, secondsLeft);
ps.setShort(6, flags);
ps.setInt(7, this.skillid);
StringBuilder list = new StringBuilder();
for (int i = 0; i < this.excluded.length; i++) {
list.append(this.excluded[i]);
list.append(",");
}
String newlist = list.toString();
ps.setString(8, newlist.substring(0, newlist.length() - 1));
ps.setInt(9, uniqueid); // Set ID
ps.executeUpdate();
}
changed = false;
} catch (final SQLException ex) {
}
}
public static final MaplePet createPet(final int itemid) {
return createPet(itemid, -1);
}
public static final MaplePet createPet(final int itemid, final int uniqueid) {
MapleItemInformationProvider ii = MapleItemInformationProvider.getInstance();
return createPet(itemid, ii.getName(itemid), 1, 0, 100, uniqueid, itemid == 5000054 ? 18000 : 0, ii.getPetFlagInfo(itemid), 0);
}
public static final MaplePet createPet(int itemid, String name, int level, int closeness, int fullness, int uniqueid, int secondsLeft, short flag, int skillId) {
if (uniqueid <= -1) { //wah
uniqueid = MapleInventoryIdentifier.getInstance();
}
try {
try (PreparedStatement pse = DatabaseConnection.getConnection().prepareStatement("INSERT INTO pets (petid, name, level, closeness, fullness, seconds, flags, skillid) VALUES (?, ?, ?, ?, ?, ?, ?, ?)")) {
pse.setInt(1, uniqueid);
pse.setString(2, name);
pse.setByte(3, (byte) level);
pse.setShort(4, (short) closeness);
pse.setByte(5, (byte) fullness);
pse.setInt(6, secondsLeft);
pse.setShort(7, flag);
pse.setInt(8, skillId);
pse.executeUpdate();
}
} catch (final SQLException ex) {
System.out.println("創建寵物錯誤: " + ex);
return null;
}
final MaplePet pet = new MaplePet(itemid, uniqueid);
pet.setName(name);
pet.setLevel(level);
pet.setFullness(fullness);
pet.setCloseness(closeness);
pet.setFlags(flag);
pet.setSecondsLeft(secondsLeft);
pet.setBuffSkill(skillId);
return pet;
}
public final String getName() {
return name;
}
public final void setName(final String name) {
this.name = name;
this.changed = true;
}
public final boolean getSummoned() {
return summoned > 0;
}
public final byte getSummonedValue() {
return summoned;
}
public final void setSummoned(final int summoned) {
this.summoned = (byte) summoned;
}
public final short getInventoryPosition() {
return inventorypos;
}
public final void setInventoryPosition(final short inventorypos) {
this.inventorypos = inventorypos;
}
public int getUniqueId() {
return uniqueid;
}
public final short getCloseness() {
return closeness;
}
public final void setCloseness(final int closeness) {
this.closeness = (short) closeness;
this.changed = true;
}
public final byte getLevel() {
return level;
}
public final void setLevel(final int level) {
this.level = (byte) level;
this.changed = true;
}
public final byte getFullness() {
return fullness;
}
public final void setFullness(final int fullness) {
this.fullness = (byte) fullness;
this.changed = true;
}
public final short getFlags() {
return flags;
}
public final void setFlags(final int fffh) {
this.flags = (short) fffh;
this.changed = true;
}
public final int getFh() {
return Fh;
}
public final void setFh(final int Fh) {
this.Fh = Fh;
}
public final Point getPos() {
return pos;
}
public final void setPos(final Point pos) {
this.pos = pos;
}
public final int getStance() {
return stance;
}
public final void setStance(final int stance) {
this.stance = stance;
}
public final int getPetItemId() {
return petitemid;
}
public final boolean canConsume(final int itemId) {
final MapleItemInformationProvider mii = MapleItemInformationProvider.getInstance();
for (final int petId : mii.getItemEffect(itemId).getPetsCanConsume()) {
if (petId == petitemid) {
return true;
}
}
return false;
}
public final void updatePosition(final List<LifeMovementFragment> movement) {
for (final LifeMovementFragment move : movement) {
if (move instanceof LifeMovement) {
if (move instanceof StaticLifeMovement) {
setPos(((LifeMovement) move).getPosition());
}
setStance(((LifeMovement) move).getNewstate());
}
}
}
public final int getSecondsLeft() {
return secondsLeft;
}
public final void setSecondsLeft(int sl) {
this.secondsLeft = sl;
this.changed = true;
}
public boolean isCanPickup() {
return this.canPickup;
}
public void setCanPickup(boolean can) {
this.canPickup = can;
}
public int getBuffSkill() {
return this.skillid;
}
public void setBuffSkill(int id) {
this.skillid = id;
}
public static void clearPet() {
try {
Connection con = DatabaseConnection.getConnection();
PreparedStatement ps = con.prepareStatement("SELECT * FROM pets");
ResultSet rs = ps.executeQuery();
ArrayList<Integer> uids = new ArrayList();
while (rs.next()) {
int uid = rs.getInt("petid");
if (!ItemLoader.isExistsByUniqueid(uid)) {
System.err.println("寵物：" + rs.getString("name") + " petid: " + uid + " 不存在, 清理。");
uids.add(uid);
}
}
ps.close();
rs.close();
for (int id : uids) {
ps = con.prepareStatement("DELETE FROM pets WHERE petid = ?");
ps.setInt(1, id);
ps.executeUpdate();
}
} catch (SQLException se) {
System.err.println("[MaplePet] 從數據庫中加載寵物訊息出錯");
}
}
}