Newbie Spellweaver
- Joined
- Dec 24, 2010
- Messages
- 5
- Reaction score
- 0
Yeah this is not working at all this = fail
thank you that helped me
Most visitors online was 12720 , on 2 May 2024
-
Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.
[Website] AltairCMS! | Updated with steps to add new page
- Thread starter AuroX
- Start date
- Status
- Joined
- Jan 19, 2009
- Messages
- 613
- Reaction score
- 96
Added to library..
Newbie Spellweaver
- Joined
- Dec 24, 2010
- Messages
- 6
- Reaction score
- 0
- Joined
- Nov 27, 2009
- Messages
- 442
- Reaction score
- 230
No one cares. There's a reason why it's locked up, but I guess Hubba-people are too stupid to realize it.
Newbie Spellweaver
- Joined
- Dec 20, 2009
- Messages
- 20
- Reaction score
- 0
sorry for the bump, though is suppose im not the only one. Anyway, I was wondering if someone could teach me how to edit the vote.php :/ I would like to set it so that it edits votepoints in character, not accounts. The column has been added and the methods are set up, but I just dont know how to edit the php script. can anyone help? oh, and here is my php script if you want it.
and here is my maplecharacter.java
Thank you,
Pepsinotcoke.
PHP:
<div id="main">
<div class="sidebartop">Vote</div>
<div class="sidebarbox">
<!-- VOTE -->
<?php
function getVoteErr($err) {
if($err == "1") {
echo '<p class="error">Please fill in the correct account credentials.</p>';
} elseif($err == "2") {
echo '<p class="error">You must be logged out to vote for rewards.</p>';
} elseif($err == "3") {
echo '<p class="error">You\'ve already voted with this account in the past 12 hours!<br />Last time you voted was on: '.$_SESSION['vote_date'].'!</p>';
}
}
if(isset($_POST['doVote'])) {
$earnednx = false;
$account = $_POST['name'];
$account = mysql_real_escape_string($account);
mysql_select_db($host['database']);
$query=mysql_query("SELECT * FROM accounts WHERE name='" . mysql_real_escape_string($_POST["name"]) . "'");
$info=mysql_fetch_assoc($query);
if($_POST["name"] == "") {
$_SESSION['vote_err'] = "1";
echo '<meta http-equiv="refresh" content="0;url=?page=vote">';
} elseif($_POST["password"] == "") {
$_SESSION['vote_err'] = "1";
echo '<meta http-equiv="refresh" content="0;url=?page=vote">';
} elseif(mysql_num_rows($query) < 1) {
$_SESSION['vote_err'] = "1";
echo '<meta http-equiv="refresh" content="0;url=?page=vote">';
} elseif(($info["password"] != hash('sha512',$_POST["password"].$info["salt"]) && sha1($_POST["password"])) && $info["password"] != sha1($_POST["password"])) {
$_SESSION['vote_err'] = "1";
echo '<meta http-equiv="refresh" content="0;url=?page=vote">';
} elseif($info["loggedin"] > 0) {
$_SESSION['vote_err'] = "2";
echo '<meta http-equiv="refresh" content="0;url=?page=vote">';
} else {
$ip = $_SERVER['REMOTE_ADDR'];
$time = time();
$get = "SELECT *, SUM(`times`) as amount FROM voterecords GROUP BY account='$account'";
$query1 = mysql_query($get);
$lasttime = mysql_fetch_array($query1);
$amount = $lasttime['amount'];
$insertnew = false;
if ($amount == "") {
$insertnew = true;
}
$timecalc = $time - $lasttime['date'];
if (!$insertnew) {
if ($timecalc < 43200) { // 43200 ms is 12 hours
date_default_timezone_set(''.$timezone.'');
$_SESSION['vote_err'] = "3";
$_SESSION['vote_date'] = date('M d\, h:i:s A', $lasttime['date']);
echo '<meta http-equiv="refresh" content="0;url=?page=vote">';
} else {
$update = mysql_query("SELECT * from voterecords WHERE ip='$ip' AND account = '$account'");
if ($update) {
mysql_query("UPDATE voterecords SET account='$account', date='$time', times=times+1 WHERE account='$account'");
mysql_query("UPDATE voterecords SET account='$account', date='$time', times=times+1 WHERE ip='$ip'");
$earnednx = true;
} elseif (!$update) {
$ipinsert = mysql_query("INSERT INTO voterecords (`account`, `ip`, `date`, `times`) VALUES ('$account', '$ip', '$time', 1)");
if (!$ipinsert) {
$message = 'Invalid query: ' . mysql_error() . "\n";
$message .= 'Whole query: ' . $ipinsert;
die($message);
} else {
$earnednx = true;
}
} else {
$message = 'Invalid query: ' . mysql_error() . "\n";
$message .= 'Whole query: ' . $update;
die($message);
}
}
} else {
$success = mysql_query("INSERT INTO voterecords (`account`, `ip`, `date`, `times`) VALUES ('$account', '$ip', '$time', 1)");
if (!$success) {
$message = 'Invalid query: ' . mysql_error() . "\n";
$message .= 'Whole query: ' . $success;
die($message);
} else {
$earnednx = true;
}
}
// Insert the NX into the db now
if ($earnednx) {
mysql_query("UPDATE accounts SET votepoints = votepoints + '1' WHERE name='" . mysql_real_escape_string($_POST["name"]) . "'");
mysql_query("UPDATE accounts SET cardNX = nxCredit + '2000' WHERE name='" .mysql_real_escape_string($_POST["name"]) . "'");
mysql_query("UPDATE accounts SET lastvote='" .time(). "' WHERE name='" . mysql_real_escape_string($_POST["name"]) . "'");
mysql_close();
echo '<html>';
echo '<head>';
unset($_SESSION['vote_err']);
echo '<meta HTTP-EQUIV="REFRESH" content="0; url='.$votelink.'">';
echo '</head>';
echo '</html>';
}
}
}
?><!-- END VOTE PHP SCRIPT -->
<!-- BEGIN VOTE -->
<div align="center">
<div id="message-yellow">Not interested in any rewards, but still wanna vote? <a href="<?php echo $votelink; ?>" target="_blank">Click Here</a></div>
<br />
<div id="vote">
<fieldset class="normal">
<legend>Vote</legend>
<b>Welcome to the Vote Page!</b><br />
You can vote for us every 12 hours, and get rewards for voting.<br /><br />
<b>Attention: Once transferred to vote page, please type the word you read in the captcha image and click "Submit".</b><br /><br />
Also, once you click submit, your Account and IP Address will be logged.<br />Please don't try to fool us with fake votes, bypasses, ect.<br>You may get suspended/banned.<br /><br />
<b>Below, please fill in your login credentials.</b><br />Click submit once filled out to get confirmed.<br />
5k NX and 1 Vote Point will be added to your account
<form action="?page=vote" method="POST"><br>
<div style="width:70px; float:left;">Username:</div><input type="text" name="name" maxlength="15" class="input" ><br />
<div style="width:70px; float:left;">Password:</div><input type="password" name="password" maxlength="15" class="input" ><br />
<input type="hidden" name="submit_check" value="1">
<input type="submit" name="doVote" value="Submit" class="doVote"><br />
<?php getVoteErr($_SESSION['vote_err']); ?>
</form>
</div>
</div>
</div>
</div>and here is my maplecharacter.java
PHP:
/*
This file is part of the OdinMS Maple Story Server
Copyright (C) 2008 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 as
published by the Free Software Foundation 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;
import constants.ExpTable;
import constants.ServerConstants;
import constants.skills.Bishop;
import constants.skills.BlazeWizard;
import constants.skills.Corsair;
import constants.skills.Crusader;
import constants.skills.DarkKnight;
import constants.skills.DawnWarrior;
import java.io.File;
import constants.skills.FPArchMage;
import constants.skills.GM;
import constants.skills.Hermit;
import constants.skills.ILArchMage;
import constants.skills.Magician;
import constants.skills.Marauder;
import constants.skills.Priest;
import constants.skills.Ranger;
import constants.skills.Sniper;
import constants.skills.Spearman;
import constants.skills.SuperGM;
import provider.*;
import constants.skills.Swordsman;
import constants.skills.ThunderBreaker;
import java.awt.Point;
import java.lang.ref.WeakReference;
import java.rmi.RemoteException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Timestamp;
import java.text.DecimalFormat;
import java.text.NumberFormat;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Calendar;
import java.util.Collection;
import java.util.Collections;
import java.util.Iterator;
import java.util.LinkedHashMap;
import java.util.LinkedHashSet;
import java.util.LinkedList;
import java.util.List;
import java.util.Map;
import java.util.Map.Entry;
import java.util.Set;
import java.util.TimeZone;
import java.util.concurrent.ScheduledFuture;
import java.util.concurrent.atomic.AtomicInteger;
import java.util.regex.Pattern;
import net.MaplePacket;
import net.channel.ChannelServer;
import net.world.MapleMessenger;
import net.world.MapleMessengerCharacter;
import net.world.MapleParty;
import net.world.MaplePartyCharacter;
import net.world.PartyOperation;
import net.world.PlayerBuffValueHolder;
import net.world.PlayerCoolDownValueHolder;
import net.world.guild.MapleGuild;
import net.world.guild.MapleGuildCharacter;
import net.world.remote.WorldChannelInterface;
import scripting.event.EventInstanceManager;
import client.autoban.AutobanManager;
import constants.ItemConstants;
import server.CashShop;
import server.MapleInventoryManipulator;
import server.MapleItemInformationProvider;
import server.MapleMiniGame;
import server.MaplePlayerShop;
import server.MaplePortal;
import server.MapleShop;
import server.MapleStatEffect;
import server.MapleStorage;
import server.MapleTrade;
import server.TimerManager;
import server.events.MapleFitness;
import server.events.MapleOla;
import server.events.MonsterCarnival;
import server.events.MonsterCarnivalParty;
import server.life.MapleMonster;
import server.life.MobSkill;
import server.maps.AbstractAnimatedMapleMapObject;
import server.maps.HiredMerchant;
import server.maps.MapleDoor;
import server.maps.MapleMap;
import server.maps.MapleMapEffect;
import server.maps.MapleMapFactory;
import server.maps.MapleMapObject;
import server.maps.MapleMapObjectType;
import server.maps.MapleSummon;
import server.maps.PlayerNPCs;
import server.maps.SavedLocation;
import server.maps.SavedLocationType;
import server.quest.MapleQuest;
import tools.DatabaseConnection;
import tools.MaplePacketCreator;
import tools.Pair;
import tools.Randomizer;
import scripting.npc.NPCScriptManager;
public class MapleCharacter extends AbstractAnimatedMapleMapObject {
private int world;
private int accountid;
private int rank;
private int rankMove;
private int jobRank;
private int jobRankMove;
private int id;
private int level;
private int reborns;
private int str;
private int dex;
private int luk;
private int int_;
private int hp;
private int maxhp;
private int mp;
private int maxmp;
private int hpMpApUsed;
private int hair;
private int face;
private int remainingAp;
private int remainingSp;
private int fame;
private int initialSpawnPoint;
private int mapid;
private int gender;
private int currentPage;
private int currentType = 0;
private int currentTab = 1;
private int chair;
private int itemEffect;
private int guildid;
private int guildrank;
private int allianceRank;
private int messengerposition = 4;
private int slots = 0;
private int energybar;
private int gmLevel;
private int ci = 0;
private int familyId;
private int bookCover;
private int markedMonster = 0;
private int battleshipHp = 0;
private int mesosTraded = 0;
private int possibleReports = 10;
private int dojoPoints;
private int vanquisherStage;
private int dojoStage;
private int dojoEnergy;
private int vanquisherKills;
private int warpToId;
private int expRate = ServerConstants.EXP_RATE;
private int mesoRate = ServerConstants.MESO_RATE;
private int dropRate = ServerConstants.DROP_RATE;
private int omokwins;
private int omokties;
private int omoklosses;
private int matchcardwins;
private int matchcardties;
private int matchcardlosses;
private int married;
private long dojoFinish;
private long lastfametime;
private long lastUsedCashItem;
private long lastHealed;
private transient int localmaxhp;
private transient int localmaxmp;
private transient int localstr;
private transient int localdex;
private transient int localluk;
private transient int localint_;
private transient int magic;
private transient int watk;
private boolean hidden;
private boolean canDoor = true;
private boolean whitechat = true;
private boolean Berserk;
private boolean hasMerchant;
private int linkedLevel = 0;
private String linkedName = null;
private boolean finishedDojoTutorial;
private boolean dojoParty;
private String name;
private String chalktext;
private String search = null;
private AtomicInteger exp = new AtomicInteger();
private AtomicInteger gachaexp = new AtomicInteger();
private AtomicInteger meso = new AtomicInteger();
private int merchantmeso;
private BuddyList buddylist;
private EventInstanceManager eventInstance = null;
private HiredMerchant hiredMerchant = null;
private MapleClient client;
private MapleGuildCharacter mgc = null;
private MapleInventory[] inventory;
private MapleJob job = MapleJob.BEGINNER;
private MapleMap map;
private MapleMap dojoMap;
private MapleMessenger messenger = null;
private MapleMiniGame miniGame;
private MapleMount maplemount;
private MapleParty party;
private MaplePet[] pets = new MaplePet[3];
private MaplePlayerShop playerShop = null;
private MapleShop shop = null;
private MapleSkinColor skinColor = MapleSkinColor.NORMAL;
private MapleStorage storage = null;
private MapleTrade trade = null;
private SavedLocation savedLocations[];
private SkillMacro[] skillMacros = new SkillMacro[5];
private List<Integer> lastmonthfameids;
private Map<MapleQuest, MapleQuestStatus> quests;
private Set<MapleMonster> controlled = new LinkedHashSet<MapleMonster>();
private Map<Integer, String> entered = new LinkedHashMap<Integer, String>();
private Set<MapleMapObject> visibleMapObjects = new LinkedHashSet<MapleMapObject>();
private Map<ISkill, SkillEntry> skills = new LinkedHashMap<ISkill, SkillEntry>();
private Map<MapleBuffStat, MapleBuffStatValueHolder> effects = Collections.synchronizedMap(new LinkedHashMap<MapleBuffStat, MapleBuffStatValueHolder>());
private Map<Integer, MapleKeyBinding> keymap = new LinkedHashMap<Integer, MapleKeyBinding>();
private Map<Integer, MapleSummon> summons = new LinkedHashMap<Integer, MapleSummon>();
private Map<Integer, MapleCoolDownValueHolder> coolDowns = new LinkedHashMap<Integer, MapleCoolDownValueHolder>();
private List<MapleDisease> diseases = new ArrayList<MapleDisease>();
private List<MapleDoor> doors = new ArrayList<MapleDoor>();
private ScheduledFuture<?> dragonBloodSchedule;
private ScheduledFuture<?> mapTimeLimitTask = null;
private ScheduledFuture<?> fullnessSchedule;
private ScheduledFuture<?> fullnessSchedule_1;
private ScheduledFuture<?> fullnessSchedule_2;
private ScheduledFuture<?> hpDecreaseTask;
private ScheduledFuture<?> beholderHealingSchedule;
private ScheduledFuture<?> beholderBuffSchedule;
private ScheduledFuture<?> BerserkSchedule;
private ScheduledFuture<?> expiretask;
private NumberFormat nf = new DecimalFormat("#,###,###,###");
private ArrayList<String> commands = new ArrayList<String>();
private ArrayList<Integer> excluded = new ArrayList<Integer>();
private MonsterBook monsterbook;
private List<MapleRing> crushRings = new ArrayList<MapleRing>();
private List<MapleRing> friendshipRings = new ArrayList<MapleRing>();
private MapleRing marriageRing;
private static String[] ariantroomleader = new String[3];
private static int[] ariantroomslot = new int[3];
private CashShop cashshop;
private long portaldelay = 0, lastattack = 0;
private int combocounter = 0, lastmobcount = 0;
private List<String> blockedPortals = new ArrayList<String>();
public ArrayList<String> area_data = new ArrayList<String>();
private AutobanManager autoban;
private boolean isbanned = false;
private ScheduledFuture<?> pendantOfSpirit = null; //1122017
private int pendantExp = 0; //Actually should just be equipExp
private boolean updated;
private ChannelServer cserv;
private static final org.slf4j.Logger log = org.slf4j.LoggerFactory.getLogger(MapleClient.class);
private int votepoints;
public MapleCharacter() {
setStance(0);
inventory = new MapleInventory[MapleInventoryType.values().length];
savedLocations = new SavedLocation[SavedLocationType.values().length];
for (MapleInventoryType type : MapleInventoryType.values()) {
byte b = 24;
if (type == MapleInventoryType.CASH) b = 96;
inventory[type.ordinal()] = new MapleInventory(type, (byte) b);
}
for (int i = 0; i < SavedLocationType.values().length; i++) {
savedLocations[i] = null;
}
quests = new LinkedHashMap<MapleQuest, MapleQuestStatus>();
setPosition(new Point(0, 0));
}
public String getName() {
return name;
}
public static MapleCharacter getDefault(MapleClient c) {
MapleCharacter ret = new MapleCharacter();
ret.client = c;
ret.gmLevel = c.gmLevel();
ret.hp = 50;
ret.maxhp = 50;
ret.mp = 5;
ret.maxmp = 5;
ret.str = 12;
ret.dex = 5;
ret.int_ = 4;
ret.luk = 4;
ret.map = null;
ret.job = MapleJob.BEGINNER;
ret.level = 1;
ret.accountid = c.getAccID();
ret.buddylist = new BuddyList(20);
ret.maplemount = null;
ret.getInventory(MapleInventoryType.EQUIP).setSlotLimit(24);
ret.getInventory(MapleInventoryType.USE).setSlotLimit(24);
ret.getInventory(MapleInventoryType.SETUP).setSlotLimit(24);
ret.getInventory(MapleInventoryType.ETC).setSlotLimit(24);
int[] key = {18, 65, 2, 23, 3, 4, 5, 6, 16, 17, 19, 25, 26, 27, 31, 34, 35, 37, 38, 40, 43, 44, 45, 46, 50, 56, 59, 60, 61, 62, 63, 64, 57, 48, 29, 7, 24, 33, 41};
int[] type = {4, 6, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 5, 5, 4, 4, 5, 6, 6, 6, 6, 6, 6, 5, 4, 5, 4, 4, 4, 4};
int[] action = {0, 106, 10, 1, 12, 13, 18, 24, 8, 5, 4, 19, 14, 15, 2, 17, 11, 3, 20, 16, 9, 50, 51, 6, 7, 53, 100, 101, 102, 103, 104, 105, 54, 22, 52, 21, 25, 26, 23};
for (int i = 0; i < key.length; i++) {
ret.keymap.put(key[i], new MapleKeyBinding(type[i], action[i]));
}
return ret;
}
public void addCooldown(int skillId, long startTime, long length, ScheduledFuture<?> timer) {
if (this.coolDowns.containsKey(Integer.valueOf(skillId))) {
this.coolDowns.remove(skillId);
}
this.coolDowns.put(Integer.valueOf(skillId), new MapleCoolDownValueHolder(skillId, startTime, length, timer));
}
public void addCommandToList(String command) {
commands.add(command);
}
public void addCrushRing(MapleRing r) {
crushRings.add(r);
}
public int addDojoPointsByMap() {
int pts = 0;
if (dojoPoints < 17000) {
pts = 1 + ((getMap().getId() - 1) / 100 % 100) / 6;
if (!dojoParty) {
pts++;
}
this.dojoPoints += pts;
}
return pts;
}
public void update() {
this.updated = !updated;
}
public void addDoor(MapleDoor door) {
doors.add(door);
}
public void setGMLevel(int level) {
if (level >= 5) {
this.gmLevel = 5;
} else if (level < 0) {
this.gmLevel = 0;
} else {
this.gmLevel = level;
}
}
public void addExcluded(int x) {
excluded.add(x);
}
public void addFame(int famechange) {
this.fame += famechange;
}
public void addFriendshipRing(MapleRing r) {
friendshipRings.add(r);
}
public void addHP(int delta) {
setHp(hp + delta);
updateSingleStat(MapleStat.HP, hp);
}
public void addMesosTraded(int gain) {
this.mesosTraded += gain;
}
public void addMP(int delta) {
setMp(mp + delta);
updateSingleStat(MapleStat.MP, mp);
}
public void addMPHP(int hpDiff, int mpDiff) {
setHp(hp + hpDiff);
setMp(mp + mpDiff);
updateSingleStat(MapleStat.HP, getHp());
updateSingleStat(MapleStat.MP, getMp());
}
public void addPet(MaplePet pet) {
for (int i = 0; i < 3; i++) {
if (pets[i] == null) {
pets[i] = pet;
return;
}
}
}
public void addStat(int type, int up) {
if (type == 1) {
this.str += up;
updateSingleStat(MapleStat.STR, str);
} else if (type == 2) {
this.dex += up;
updateSingleStat(MapleStat.DEX, dex);
} else if (type == 3) {
this.int_ += up;
updateSingleStat(MapleStat.INT, int_);
} else if (type == 4) {
this.luk += up;
updateSingleStat(MapleStat.LUK, luk);
}
}
public int addHP(MapleClient c) {
MapleCharacter player = c.getPlayer();
MapleJob jobtype = player.getJob();
int MaxHP = player.getMaxHp();
if (player.getHpMpApUsed() > 9999 || MaxHP >= 30000) {
return MaxHP;
}
if (jobtype.isA(MapleJob.BEGINNER)) {
MaxHP += 8;
} else if (jobtype.isA(MapleJob.WARRIOR) || jobtype.isA(MapleJob.DAWNWARRIOR1)) {
if (player.getSkillLevel(player.isCygnus() ? SkillFactory.getSkill(10000000) : SkillFactory.getSkill(1000001)) > 0) {
MaxHP += 20;
} else {
MaxHP += 8;
}
} else if (jobtype.isA(MapleJob.MAGICIAN) || jobtype.isA(MapleJob.BLAZEWIZARD1)) {
MaxHP += 6;
} else if (jobtype.isA(MapleJob.BOWMAN) || jobtype.isA(MapleJob.WINDARCHER1)) {
MaxHP += 8;
} else if (jobtype.isA(MapleJob.THIEF) || jobtype.isA(MapleJob.NIGHTWALKER1)) {
MaxHP += 8;
} else if (jobtype.isA(MapleJob.PIRATE) || jobtype.isA(MapleJob.THUNDERBREAKER1)) {
if (player.getSkillLevel(player.isCygnus() ? SkillFactory.getSkill(15100000) : SkillFactory.getSkill(5100000)) > 0) {
MaxHP += 18;
} else {
MaxHP += 8;
}
}
return MaxHP;
}
public int addMP(MapleClient c) {
MapleCharacter player = c.getPlayer();
int MaxMP = player.getMaxMp();
if (player.getHpMpApUsed() > 9999 || player.getMaxMp() >= 30000) {
return MaxMP;
}
if (player.getJob().isA(MapleJob.BEGINNER) || player.isCygnus()) {
MaxMP += 6;
} else if (player.getJob().isA(MapleJob.WARRIOR) || player.getJob().isA(MapleJob.DAWNWARRIOR1)) {
MaxMP += 2;
} else if (player.getJob().isA(MapleJob.MAGICIAN) || player.getJob().isA(MapleJob.BLAZEWIZARD1)) {
if (player.getSkillLevel(player.isCygnus() ? SkillFactory.getSkill(12000000) : SkillFactory.getSkill(2000001)) > 0) {
MaxMP += 18;
} else {
MaxMP += 14;
}
} else if (player.getJob().isA(MapleJob.BOWMAN) || player.getJob().isA(MapleJob.THIEF)) {
MaxMP += 10;
} else if (player.getJob().isA(MapleJob.PIRATE)) {
MaxMP += 14;
}
return MaxMP;
}
public void addSummon(int id, MapleSummon summon) {
summons.put(id, summon);
}
public void addVisibleMapObject(MapleMapObject mo) {
visibleMapObjects.add(mo);
}
public void ban(String reason, boolean dc) {
try {
Connection con = DatabaseConnection.getConnection();
PreparedStatement ps = con.prepareStatement("UPDATE accounts SET banned = 1, banreason = ? WHERE id = ?");
ps.setString(1, reason);
ps.setInt(2, accountid);
ps.executeUpdate();
ps.close();
this.isbanned = true;
} catch (Exception e) {
}
}
public static boolean ban(String id, String reason, boolean accountId) {
PreparedStatement ps = null;
try {
Connection con = DatabaseConnection.getConnection();
if (id.matches("/[0-9]{1,3}\\..*")) {
ps = con.prepareStatement("INSERT INTO ipbans VALUES (DEFAULT, ?)");
ps.setString(1, id);
ps.executeUpdate();
ps.close();
return true;
}
if (accountId) {
ps = con.prepareStatement("SELECT id FROM accounts WHERE name = ?");
} else {
ps = con.prepareStatement("SELECT accountid FROM characters WHERE name = ?");
}
boolean ret = false;
ps.setString(1, id);
ResultSet rs = ps.executeQuery();
if (rs.next()) {
PreparedStatement psb = DatabaseConnection.getConnection().prepareStatement("UPDATE accounts SET banned = 1, banreason = ? WHERE id = ?");
psb.setString(1, reason);
psb.setInt(2, rs.getInt(1));
psb.executeUpdate();
psb.close();
ret = true;
}
rs.close();
ps.close();
return ret;
} catch (SQLException ex) {
} finally {
try {
if (ps != null && !ps.isClosed()) {
ps.close();
}
} catch (SQLException e) {
}
}
return false;
}
public int calculateMaxBaseDamage(int watk) {
int maxbasedamage;
if (watk == 0) {
maxbasedamage = 1;
} else {
IItem weapon_item = getInventory(MapleInventoryType.EQUIPPED).getItem((byte) -11);
if (weapon_item != null) {
MapleWeaponType weapon = MapleItemInformationProvider.getInstance().getWeaponType(weapon_item.getItemId());
int mainstat;
int secondarystat;
if (weapon == MapleWeaponType.BOW || weapon == MapleWeaponType.CROSSBOW) {
mainstat = localdex;
secondarystat = localstr;
} else if ((getJob().isA(MapleJob.THIEF) || getJob().isA(MapleJob.NIGHTWALKER1)) && (weapon == MapleWeaponType.CLAW || weapon == MapleWeaponType.DAGGER)) {
mainstat = localluk;
secondarystat = localdex + localstr;
} else {
mainstat = localstr;
secondarystat = localdex;
}
maxbasedamage = (int) (((weapon.getMaxDamageMultiplier() * mainstat + secondarystat) / 100.0) * watk) + 10;
} else {
maxbasedamage = 0;
}
}
return maxbasedamage;
}
public final void dropOverheadMessage (String msg){
dropOverheadMessage (msg, 500);
}
public final void dropOverheadMessage(String msg, int length) {
getClient().announce(MaplePacketCreator.sendHint(msg, length, 10));
getClient().announce(MaplePacketCreator.enableActions());
}
public void cancelAllBuffs() {
for (MapleBuffStatValueHolder mbsvh : new ArrayList<MapleBuffStatValueHolder>(effects.values())) {
cancelEffect(mbsvh.effect, false, mbsvh.startTime);
}
}
public void cancelBuffStats(MapleBuffStat stat) {
List<MapleBuffStat> buffStatList = Arrays.asList(stat);
deregisterBuffStats(buffStatList);
cancelPlayerBuffs(buffStatList);
}
public void setCombo(int count) {
if (combocounter > 30000) {
combocounter = 30000;
return;
}
combocounter = count;
}
public void setLastAttack(long time) {
lastattack = time;
}
public int getCombo() {
return combocounter;
}
public long getLastAttack() {
return lastattack;
}
public int getLastMobCount() { //Used for skills that have mobCount at 1. (a/b)
return lastmobcount;
}
public void setLastMobCount(int count) {
lastmobcount = count;
}
public static class CancelCooldownAction implements Runnable {
private int skillId;
private WeakReference<MapleCharacter> target;
public CancelCooldownAction(MapleCharacter target, int skillId) {
this.target = new WeakReference<MapleCharacter>(target);
this.skillId = skillId;
}
@Override
public void run() {
MapleCharacter realTarget = target.get();
if (realTarget != null) {
realTarget.removeCooldown(skillId);
realTarget.client.announce(MaplePacketCreator.skillCooldown(skillId, 0));
}
}
}
public void cancelEffect(MapleStatEffect effect, boolean overwrite, long startTime) {
List<MapleBuffStat> buffstats;
if (!overwrite) {
buffstats = getBuffStats(effect, startTime);
} else {
List<Pair<MapleBuffStat, Integer>> statups = effect.getStatups();
buffstats = new ArrayList<MapleBuffStat>(statups.size());
for (Pair<MapleBuffStat, Integer> statup : statups) {
buffstats.add(statup.getLeft());
}
}
deregisterBuffStats(buffstats);
if (effect.isMagicDoor()) {
if (!getDoors().isEmpty()) {
MapleDoor door = getDoors().iterator().next();
for (MapleCharacter chr : door.getTarget().getCharacters()) {
door.sendDestroyData(chr.client);
}
for (MapleCharacter chr : door.getTown().getCharacters()) {
door.sendDestroyData(chr.client);
}
for (MapleDoor destroyDoor : getDoors()) {
door.getTarget().removeMapObject(destroyDoor);
door.getTown().removeMapObject(destroyDoor);
}
clearDoors();
silentPartyUpdate();
}
}
if (effect.getSourceId() == Spearman.HYPER_BODY || effect.getSourceId() == GM.HYPER_BODY || effect.getSourceId() == SuperGM.HYPER_BODY) {
List<Pair<MapleStat, Integer>> statup = new ArrayList<Pair<MapleStat, Integer>>(4);
statup.add(new Pair<MapleStat, Integer>(MapleStat.HP, Math.min(hp, maxhp)));
statup.add(new Pair<MapleStat, Integer>(MapleStat.MP, Math.min(mp, maxhp)));
statup.add(new Pair<MapleStat, Integer>(MapleStat.MAXHP, maxhp));
statup.add(new Pair<MapleStat, Integer>(MapleStat.MAXMP, maxmp));
client.announce(MaplePacketCreator.updatePlayerStats(statup));
}
if (effect.isMonsterRiding()) {
if (effect.getSourceId() != Corsair.BATTLE_SHIP) {
this.getMount().cancelSchedule();
this.getMount().setActive(false);
}
}
if (!overwrite) {
cancelPlayerBuffs(buffstats);
if (effect.isHide() && (MapleCharacter) getMap().getMapObject(getObjectId()) != null) {
this.hidden = false;
announce(MaplePacketCreator.getGMEffect(0x10, (byte) 0));
getMap().broadcastNONGMMessage(this, MaplePacketCreator.spawnPlayerMapobject(this), false);
}
}
}
public void cancelEffectFromBuffStat(MapleBuffStat stat) {
cancelEffect(effects.get(stat).effect, false, -1);
}
private void cancelFullnessSchedule(int petSlot) {
switch (petSlot) {
case 0:
if (fullnessSchedule != null) {
fullnessSchedule.cancel(false);
}
break;
case 1:
if (fullnessSchedule_1 != null) {
fullnessSchedule_1.cancel(false);
}
break;
case 2:
if (fullnessSchedule_2 != null) {
fullnessSchedule_2.cancel(false);
}
break;
}
}
public void cancelMagicDoor() {
for (MapleBuffStatValueHolder mbsvh : new ArrayList<MapleBuffStatValueHolder>(effects.values())) {
if (mbsvh.effect.isMagicDoor()) {
cancelEffect(mbsvh.effect, false, mbsvh.startTime);
}
}
}
public void cancelMapTimeLimitTask() {
if (mapTimeLimitTask != null) {
mapTimeLimitTask.cancel(false);
}
}
public void maxAllSkills() {
MapleDataProvider dataProvider = MapleDataProviderFactory.getDataProvider(new File(System.getProperty("wzpath") + "/" + "String.wz"));
MapleData skilldData = dataProvider.getData("Skill.img");
for (MapleData skill_ : skilldData.getChildren())
try {
ISkill skill = SkillFactory.getSkill(Integer.parseInt(skill_.getName()));
if (skill.getId() < 9000000 || skill.getId() > 9120000 || gmLevel > 0)
changeSkillLevel(skill, skill.getMaxLevel(), skill.getMaxLevel());
} catch (NumberFormatException nfe) {
break;
} catch (NullPointerException npe) {
continue;
}
}
public void unMaxAllSkills() {
MapleDataProvider dataProvider = MapleDataProviderFactory.getDataProvider(new File(System.getProperty("wzpath") + "/" + "String.wz"));
MapleData skilldData = dataProvider.getData("Skill.img");
for (MapleData skill_ : skilldData.getChildren())
try {
ISkill skill = SkillFactory.getSkill(Integer.parseInt(skill_.getName()));
if (skill.getId() < 9000000 || skill.getId() > 9120000 || gmLevel > 0)
changeSkillLevel(skill,0, skill.getMaxLevel());
} catch (NumberFormatException nfe) {
break;
} catch (NullPointerException npe) {
continue;
}
}
public void maxSkillLevel(int skillid) {
int maxlevel = SkillFactory.getSkill(skillid).getMaxLevel();
changeSkillLevel(SkillFactory.getSkill(skillid), maxlevel, maxlevel);
}
public void unMaxSkillLevel(int skillid) {
int maxlevel = SkillFactory.getSkill(skillid).getMaxLevel();
changeSkillLevel(SkillFactory.getSkill(skillid), 0, maxlevel);
}
public void changeSkillLevel(ISkill skill, int newLevel, int newMasterlevel) {
skills.put(skill, new SkillEntry(newLevel, newMasterlevel));
this.getClient().getSession().write(MaplePacketCreator.updateSkill2(skill.getId(), newLevel, newMasterlevel));
}
private void cancelPlayerBuffs(List<MapleBuffStat> buffstats) {
if (client.getChannelServer().getPlayerStorage().getCharacterById(getId()) != null) {
recalcLocalStats();
enforceMaxHpMp();
client.announce(MaplePacketCreator.cancelBuff(buffstats));
if (buffstats.size() > 0)
getMap().broadcastMessage(this, MaplePacketCreator.cancelForeignBuff(getId(), buffstats), false);
}
}
public static boolean canCreateChar(String name) {
if (name.length() < 4 || name.length() > 12)
return false;
if (isInUse(name))
return false;
return getIdByName(name) < 0 && !name.toLowerCase().contains("gm") && Pattern.compile("[a-zA-Z0-9_-]{3,12}").matcher(name).matches();
}
public boolean canDoor() {
return canDoor;
}
public FameStatus canGiveFame(MapleCharacter from) {
if (gmLevel > 0) {
return FameStatus.OK;
} else if (lastfametime >= System.currentTimeMillis() - 3600000 * 24) {
return FameStatus.NOT_TODAY;
} else if (lastmonthfameids.contains(Integer.valueOf(from.getId()))) {
return FameStatus.NOT_THIS_MONTH;
} else {
return FameStatus.OK;
}
}
public void changeCI(int type) {
this.ci = type;
}
public void changeJob(MapleJob newJob) {
this.job = newJob;
this.remainingSp++;
if (newJob.getId() % 10 == 2) {
this.remainingSp += 2;
}
if (newJob.getId() % 10 > 1) {
this.remainingAp += 5;
}
int job_ = job.getId() % 1000; // lame temp "fix"
if (job_ == 100) {
maxhp += Randomizer.rand(200, 250);
} else if (job_ == 200) {
maxmp += Randomizer.rand(100, 150);
} else if (job_ % 100 == 0) {
maxhp += Randomizer.rand(100, 150);
maxhp += Randomizer.rand(25, 50);
} else if (job_ > 0 && job_ < 200) {
maxhp += Randomizer.rand(300, 350);
} else if (job_ < 300) {
maxmp += Randomizer.rand(450, 500);
} //handle KoC here (undone)
else if (job_ > 0 && job_ != 1000) {
maxhp += Randomizer.rand(300, 350);
maxmp += Randomizer.rand(150, 200);
}
if (maxhp >= 30000) {
maxhp = 30000;
}
if (maxmp >= 30000) {
maxmp = 30000;
}
if (!isGM()) {
for (byte i = 1; i < 5; i++) {
gainSlots(i, 4, true);
}
}
List<Pair<MapleStat, Integer>> statup = new ArrayList<Pair<MapleStat, Integer>>(5);
statup.add(new Pair<MapleStat, Integer>(MapleStat.MAXHP, Integer.valueOf(maxhp)));
statup.add(new Pair<MapleStat, Integer>(MapleStat.MAXMP, Integer.valueOf(maxmp)));
statup.add(new Pair<MapleStat, Integer>(MapleStat.AVAILABLEAP, remainingAp));
statup.add(new Pair<MapleStat, Integer>(MapleStat.AVAILABLESP, remainingSp));
statup.add(new Pair<MapleStat, Integer>(MapleStat.JOB, Integer.valueOf(job.getId())));
recalcLocalStats();
client.announce(MaplePacketCreator.updatePlayerStats(statup));
silentPartyUpdate();
if (this.guildid > 0) {
getGuild().broadcast(MaplePacketCreator.jobMessage(0, job.getId(), name), this.getId());
}
guildUpdate();
getMap().broadcastMessage(this, MaplePacketCreator.showForeignEffect(getId(), 8), false);
}
public void changeKeybinding(int key, MapleKeyBinding keybinding) {
if (keybinding.getType() != 0) {
keymap.put(Integer.valueOf(key), keybinding);
} else {
keymap.remove(Integer.valueOf(key));
}
}
public void changeMap(int map) {
changeMap(map, 0);
}
public void changeMap(int map, int portal) {
MapleMap warpMap = client.getChannelServer().getMapFactory().getMap(map);
changeMap(warpMap, warpMap.getPortal(portal));
}
public void changeMap(int map, String portal) {
MapleMap warpMap = client.getChannelServer().getMapFactory().getMap(map);
changeMap(warpMap, warpMap.getPortal(portal));
}
public void changeMap(int map, MaplePortal portal) {
MapleMap warpMap = client.getChannelServer().getMapFactory().getMap(map);
changeMap(warpMap, portal);
}
public void changeMap(MapleMap to) {
changeMap(to, to.getPortal(0));
}
public void changeMap(final MapleMap to, final MaplePortal pto) {
if (to.getId() == 100000200 || to.getId() == 211000100 || to.getId() == 220000300) {
changeMapInternal(to, pto.getPosition(), MaplePacketCreator.getWarpToMap(to, pto.getId() - 2, this));
} else {
changeMapInternal(to, pto.getPosition(), MaplePacketCreator.getWarpToMap(to, pto.getId(), this));
}
}
public void changeMap(final MapleMap to, final Point pos) {
changeMapInternal(to, pos, MaplePacketCreator.getWarpToMap(to, 0x80, this));
}
public void changeMapBanish(int mapid, String portal, String msg) {
dropMessage(5, msg);
MapleMap map_ = ChannelServer.getInstance(client.getChannel()).getMapFactory().getMap(mapid);
changeMap(map_, map_.getPortal(portal));
}
private void changeMapInternal(final MapleMap to, final Point pos, MaplePacket warpPacket) {
warpPacket.setOnSend(new Runnable() {
@Override
public void run() {
map.removePlayer(MapleCharacter.this);
if (client.getChannelServer().getPlayerStorage().getCharacterById(getId()) != null) {
map = to;
setPosition(pos);
map.addPlayer(MapleCharacter.this);
if (party != null) {
silentPartyUpdate();
client.announce(MaplePacketCreator.updateParty(client.getChannel(), party, PartyOperation.SILENT_UPDATE, null));
updatePartyMemberHP();
}
if (getMap().getHPDec() > 0) {
hpDecreaseTask = TimerManager.getInstance().schedule(new Runnable() {
@Override
public void run() {
doHurtHp();
}
}, 10000);
}
}
}
});
client.announce(warpPacket);
}
public void changePage(int page) {
this.currentPage = page;
}
public void changeSkillLevel(ISkill skill, int newLevel, int newMasterlevel, long expiration) {
if (newLevel > -1) {
skills.put(skill, new SkillEntry(newLevel, newMasterlevel, expiration));
this.client.announce(MaplePacketCreator.updateSkill(skill.getId(), newLevel, newMasterlevel, expiration));
} else {
skills.remove(skill);
this.client.announce(MaplePacketCreator.updateSkill(skill.getId(), newLevel, newMasterlevel, -1)); //Shouldn't use expiration anymore :)
try {
Connection con = DatabaseConnection.getConnection();
PreparedStatement ps = con.prepareStatement("DELETE FROM skills WHERE skillid = ? AND characterid = ?");
ps.setInt(1, skill.getId());
ps.setInt(2, id);
ps.execute();
ps.close();
} catch (SQLException ex) {
System.out.print("Error deleting skill: " + ex);
}
}
}
public void changeTab(int tab) {
this.currentTab = tab;
}
public void changeType(int type) {
this.currentType = type;
}
public void checkBerserk() {
if (BerserkSchedule != null) {
BerserkSchedule.cancel(false);
}
final MapleCharacter chr = this;
if (job.equals(MapleJob.DARKKNIGHT)) {
ISkill BerserkX = SkillFactory.getSkill(DarkKnight.BERSERK);
final int skilllevel = getSkillLevel(BerserkX);
if (skilllevel > 0) {
Berserk = chr.getHp() * 100 / chr.getMaxHp() < BerserkX.getEffect(skilllevel).getX();
BerserkSchedule = TimerManager.getInstance().register(new Runnable() {
@Override
public void run() {
client.announce(MaplePacketCreator.showOwnBerserk(skilllevel, Berserk));
getMap().broadcastMessage(MapleCharacter.this, MaplePacketCreator.showBerserk(getId(), skilllevel, Berserk), false);
}
}, 5000, 3000);
}
}
}
public void checkMessenger() {
if (messenger != null && messengerposition < 4 && messengerposition > -1) {
try {
WorldChannelInterface wci = ChannelServer.getInstance(client.getChannel()).getWorldInterface();
wci.silentJoinMessenger(messenger.getId(), new MapleMessengerCharacter(this, messengerposition), messengerposition);
wci.updateMessenger(getMessenger().getId(), name, client.getChannel());
} catch (Exception e) {
client.getChannelServer().reconnectWorld();
}
}
}
public void checkMonsterAggro(MapleMonster monster) {
if (!monster.isControllerHasAggro()) {
if (monster.getController() == this) {
monster.setControllerHasAggro(true);
} else {
monster.switchController(this, true);
}
}
}
public void clearDoors() {
doors.clear();
}
public void clearSavedLocation(SavedLocationType type) {
savedLocations[type.ordinal()] = null;
}
public void controlMonster(MapleMonster monster, boolean aggro) {
monster.setController(this);
controlled.add(monster);
client.announce(MaplePacketCreator.controlMonster(monster, false, aggro));
}
public int countItem(int itemid) {
return inventory[MapleItemInformationProvider.getInstance().getInventoryType(itemid).ordinal()].countById(itemid);
}
public void decreaseBattleshipHp(int decrease) {
this.battleshipHp -= decrease;
if (battleshipHp <= 0) {
this.battleshipHp = 0;
ISkill battleship = SkillFactory.getSkill(Corsair.BATTLE_SHIP);
int cooldown = battleship.getEffect(getSkillLevel(battleship)).getCooldown();
getClient().announce(MaplePacketCreator.skillCooldown(Corsair.BATTLE_SHIP, cooldown));
addCooldown(Corsair.BATTLE_SHIP, System.currentTimeMillis(), cooldown * 1000, TimerManager.getInstance().schedule(new CancelCooldownAction(this, Corsair.BATTLE_SHIP), cooldown * 1000));
cancelEffectFromBuffStat(MapleBuffStat.MONSTER_RIDING);
resetBattleshipHp();
}
}
public void decreaseReports() {
this.possibleReports--;
}
public void deleteGuild(int guildId) {
try {
Connection con = DatabaseConnection.getConnection();
PreparedStatement ps = con.prepareStatement("UPDATE characters SET guildid = 0, guildrank = 5 WHERE guildid = ?");
ps.setInt(1, guildId);
ps.execute();
ps.close();
ps = con.prepareStatement("DELETE FROM guilds WHERE guildid = ?");
ps.setInt(1, id);
ps.execute();
ps.close();
} catch (SQLException ex) {
System.out.print("Error deleting guild: " + ex);
}
}
private void deleteWhereCharacterId(Connection con, String sql) throws SQLException {
PreparedStatement ps = con.prepareStatement(sql);
ps.setInt(1, id);
ps.executeUpdate();
ps.close();
}
private void deregisterBuffStats(List<MapleBuffStat> stats) {
synchronized (stats) {
List<MapleBuffStatValueHolder> effectsToCancel = new ArrayList<MapleBuffStatValueHolder>(stats.size());
for (MapleBuffStat stat : stats) {
MapleBuffStatValueHolder mbsvh = effects.get(stat);
if (mbsvh != null) {
effects.remove(stat);
boolean addMbsvh = true;
for (MapleBuffStatValueHolder contained : effectsToCancel) {
if (mbsvh.startTime == contained.startTime && contained.effect == mbsvh.effect) {
addMbsvh = false;
}
}
if (addMbsvh) {
effectsToCancel.add(mbsvh);
}
if (stat == MapleBuffStat.SUMMON || stat == MapleBuffStat.PUPPET) {
int summonId = mbsvh.effect.getSourceId();
MapleSummon summon = summons.get(summonId);
if (summon != null) {
getMap().broadcastMessage(MaplePacketCreator.removeSpecialMapObject(summon, true), summon.getPosition());
getMap().removeMapObject(summon);
removeVisibleMapObject(summon);
summons.remove(summonId);
}
if (summon.getSkill() == DarkKnight.BEHOLDER) {
if (beholderHealingSchedule != null) {
beholderHealingSchedule.cancel(false);
beholderHealingSchedule = null;
}
if (beholderBuffSchedule != null) {
beholderBuffSchedule.cancel(false);
beholderBuffSchedule = null;
}
}
} else if (stat == MapleBuffStat.DRAGONBLOOD) {
dragonBloodSchedule.cancel(false);
dragonBloodSchedule = null;
}
}
}
for (MapleBuffStatValueHolder cancelEffectCancelTasks : effectsToCancel) {
if (getBuffStats(cancelEffectCancelTasks.effect, cancelEffectCancelTasks.startTime).isEmpty()) {
cancelEffectCancelTasks.schedule.cancel(false);
}
}
}
}
public void disableDoor() {
canDoor = false;
TimerManager.getInstance().schedule(new Runnable() {
@Override
public void run() {
canDoor = true;
}
}, 5000);
}
public void disbandGuild() {
if (guildid < 1 || guildrank != 1) {
return;
}
try {
client.getChannelServer().getWorldInterface().disbandGuild(guildid);
} catch (Exception e) {
}
}
public void dispel() {
for (MapleBuffStatValueHolder mbsvh : new ArrayList<MapleBuffStatValueHolder>(effects.values())) {
if (mbsvh.effect.isSkill()) {
cancelEffect(mbsvh.effect, false, mbsvh.startTime);
}
}
}
public void dispelDebuffs() {
List<MapleDisease> disease_ = new ArrayList<MapleDisease>();
for (MapleDisease disease : diseases) {
if (disease == MapleDisease.WEAKEN || disease != MapleDisease.DARKNESS || disease != MapleDisease.SEAL || disease != MapleDisease.POISON) {
disease_.add(disease);
client.announce(MaplePacketCreator.cancelDebuff(disease_));
getMap().broadcastMessage(this, MaplePacketCreator.cancelForeignDebuff(this.id, disease_), false);
disease_.clear();
} else {
return;
}
}
this.diseases.clear();
}
public void dispelSeduce() {
List<MapleDisease> disease_ = new ArrayList<MapleDisease>();
for (MapleDisease disease : diseases) {
if (disease == MapleDisease.SEDUCE) {
disease_.add(disease);
client.announce(MaplePacketCreator.cancelDebuff(disease_));
getMap().broadcastMessage(this, MaplePacketCreator.cancelForeignDebuff(this.id, disease_), false);
disease_.clear();
}
}
this.diseases.clear();
}
public void dispelSkill(int skillid) {
LinkedList<MapleBuffStatValueHolder> allBuffs = new LinkedList<MapleBuffStatValueHolder>(effects.values());
for (MapleBuffStatValueHolder mbsvh : allBuffs) {
if (skillid == 0) {
if (mbsvh.effect.isSkill() && (mbsvh.effect.getSourceId() % 10000000 == 1004 || dispelSkills(mbsvh.effect.getSourceId()))) {
cancelEffect(mbsvh.effect, false, mbsvh.startTime);
}
} else if (mbsvh.effect.isSkill() && mbsvh.effect.getSourceId() == skillid) {
cancelEffect(mbsvh.effect, false, mbsvh.startTime);
}
}
}
private boolean dispelSkills(int skillid) {
switch (skillid) {
case DarkKnight.BEHOLDER:
case FPArchMage.ELQUINES:
case ILArchMage.IFRIT:
case Priest.SUMMON_DRAGON:
case Bishop.BAHAMUT:
case Ranger.PUPPET:
case Ranger.SILVER_HAWK:
case Sniper.PUPPET:
case Sniper.GOLDEN_EAGLE:
case Hermit.SHADOW_PARTNER:
return true;
default:
return false;
}
}
public void dispelSeal() {
List<MapleDisease> disease_ = new ArrayList<MapleDisease>();
for (MapleDisease disease : diseases) {
if (disease == MapleDisease.SEAL) {
disease_.add(disease);
client.announce(MaplePacketCreator.cancelDebuff(disease_));
getMap().broadcastMessage(this, MaplePacketCreator.cancelForeignDebuff(this.id, disease_), false);
disease_.clear();
}
}
this.diseases.clear();
}
public void doHurtHp() {
if (this.getInventory(MapleInventoryType.EQUIPPED).findById(getMap().getHPDecProtect()) != null) {
return;
}
addHP(-getMap().getHPDec());
hpDecreaseTask = TimerManager.getInstance().schedule(new Runnable() {
@Override
public void run() {
doHurtHp();
}
}, 10000);
}
public void dropMessage(String message) {
dropMessage(6, message);
}
public void dropMessage(int type, String message) {
client.announce(MaplePacketCreator.serverNotice(type, message));
}
public String emblemCost() {
return nf.format(MapleGuild.CHANGE_EMBLEM_COST);
}
private void enforceMaxHpMp() {
List<Pair<MapleStat, Integer>> stats = new ArrayList<Pair<MapleStat, Integer>>(2);
if (getMp() > getCurrentMaxMp()) {
setMp(getMp());
stats.add(new Pair<MapleStat, Integer>(MapleStat.MP, Integer.valueOf(getMp())));
}
if (getHp() > getCurrentMaxHp()) {
setHp(getHp());
stats.add(new Pair<MapleStat, Integer>(MapleStat.HP, Integer.valueOf(getHp())));
}
if (stats.size() > 0) {
client.announce(MaplePacketCreator.updatePlayerStats(stats));
}
}
public void enteredScript(String script, int mapid) {
if (!entered.containsKey(mapid)) {
entered.put(mapid, script);
}
}
public void equipChanged() {
getMap().broadcastMessage(this, MaplePacketCreator.updateCharLook(this), false);
recalcLocalStats();
enforceMaxHpMp();
//saveToDB(true);
if (getMessenger() != null) {
WorldChannelInterface wci = client.getChannelServer().getWorldInterface();
try {
wci.updateMessenger(getMessenger().getId(), getName(), client.getChannel());
} catch (Exception e) {
client.getChannelServer().reconnectWorld();
}
}
}
public void setName(String name, boolean changeName) {
if (!changeName) {
this.name = name;
} else {
Connection con = DatabaseConnection.getConnection();
try {
con.setTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITTED);
con.setAutoCommit(false);
PreparedStatement sn = con.prepareStatement("UPDATE characters SET name = ? WHERE id = ?");
sn.setString(1, name);
sn.setInt(2, id);
sn.execute();
con.commit();
sn.close();
this.name = name;
} catch (SQLException e) {
}
}
}
public ScheduledFuture<?> getExpirationTask() {
return expiretask;
}
public void expirationTask() {
expiretask = TimerManager.getInstance().register(new Runnable() {
@Override
public void run() {
long expiration, currenttime = System.currentTimeMillis();
Set<ISkill> keys = getSkills().keySet();
for (Iterator<ISkill> i = keys.iterator(); i.hasNext();) {
ISkill key = i.next();
SkillEntry skill = getSkills().get(key);
if (skill.expiration != -1 && skill.expiration < currenttime) {
changeSkillLevel(key, -1, 0, -1);
}
}
List<IItem> toberemove = new ArrayList<IItem>();
for (MapleInventory inv : inventory) {
for (IItem item : inv.list()) {
expiration = item.getExpiration();
if (expiration != -1 && (expiration < currenttime) && ((item.getFlag() & ItemConstants.LOCK) == ItemConstants.LOCK)) {
byte aids = item.getFlag();
aids &= ~(ItemConstants.LOCK);
item.setFlag(aids); //Probably need a check, else people can make expiring items into permanent items...
item.setExpiration(-1);
forceUpdateItem(inv.getType(), item); //TEST :3
} else if (expiration != -1 && expiration < currenttime) {
client.announce(MaplePacketCreator.itemExpired(item.getItemId()));
toberemove.add(item);
}
}
for (IItem item : toberemove) {
MapleInventoryManipulator.removeFromSlot(client, inv.getType(), item.getPosition(), item.getQuantity(), true);
}
toberemove.clear();
}
//saveToDB(true);
}
}, 60000);
}
public enum FameStatus {
OK, NOT_TODAY, NOT_THIS_MONTH
}
public void forceUpdateItem(MapleInventoryType type, IItem item) {
client.announce(MaplePacketCreator.clearInventoryItem(type, item.getPosition(), false));
client.announce(MaplePacketCreator.addInventorySlot(type, item, false));
}
public void gainGachaExp() {
int expgain = 0;
int currentgexp = gachaexp.get();
if ((currentgexp + exp.get()) >= ExpTable.getExpNeededForLevel(level)) {
expgain += ExpTable.getExpNeededForLevel(level) - exp.get();
int nextneed = ExpTable.getExpNeededForLevel(level + 1);
if ((currentgexp - expgain) >= nextneed) {
expgain += nextneed;
}
this.gachaexp.set(currentgexp - expgain);
} else {
expgain = this.gachaexp.getAndSet(0);
}
gainExp(expgain, false, false);
updateSingleStat(MapleStat.GACHAEXP, this.gachaexp.get());
}
public void gainGachaExp(int gain) {
updateSingleStat(MapleStat.GACHAEXP, gachaexp.addAndGet(gain));
}
public void gainExp(int gain, boolean show, boolean inChat) {
gainExp(gain, show, inChat, true);
}
public void gainExp(int gain, boolean show, boolean inChat, boolean white) {
int equip = (gain / 10) * pendantExp;
int total = gain + equip;
if (level < getMaxLevel()) {
if ((long) this.exp.get() + (long) total > (long) Integer.MAX_VALUE) {
int gainFirst = ExpTable.getExpNeededForLevel(level) - this.exp.get();
total -= gainFirst + 1;
this.gainExp(gainFirst + 1, false, inChat, white);
}
updateSingleStat(MapleStat.EXP, this.exp.addAndGet(total));
if (show && gain != 0) {
client.announce(MaplePacketCreator.getShowExpGain(gain, equip, inChat, white));
}
if (!ServerConstants.GMS_LIKE) {
while (level < getMaxLevel() && exp.get() >= ExpTable.getExpNeededForLevel(level)) {
levelUp(true);
}
} else if (exp.get() >= ExpTable.getExpNeededForLevel(level)) {
levelUp(true);
int need = ExpTable.getExpNeededForLevel(level);
if (exp.get() >= need) {
setExp(need - 1);
updateSingleStat(MapleStat.EXP, need);
}
}
}
}
public void gainFame(int delta) {
this.addFame(delta);
this.updateSingleStat(MapleStat.FAME, this.fame);
}
public void gainMeso(int gain, boolean show) {
gainMeso(gain, show, false, false);
}
public void gainMeso(int gain, boolean show, boolean enableActions, boolean inChat) {
if (meso.get() + gain < 0) {
client.announce(MaplePacketCreator.enableActions());
return;
}
updateSingleStat(MapleStat.MESO, meso.addAndGet(gain), enableActions);
if (show) {
client.announce(MaplePacketCreator.getShowMesoGain(gain, inChat));
}
}
public void genericGuildMessage(int code) {
this.client.announce(MaplePacketCreator.genericGuildMessage((byte) code));
}
public int getAccountID() {
return accountid;
}
public List<PlayerBuffValueHolder> getAllBuffs() {
List<PlayerBuffValueHolder> ret = new ArrayList<PlayerBuffValueHolder>();
for (MapleBuffStatValueHolder mbsvh : effects.values()) {
ret.add(new PlayerBuffValueHolder(mbsvh.startTime, mbsvh.effect));
}
return ret;
}
public List<PlayerCoolDownValueHolder> getAllCooldowns() {
List<PlayerCoolDownValueHolder> ret = new ArrayList<PlayerCoolDownValueHolder>();
for (MapleCoolDownValueHolder mcdvh : coolDowns.values()) {
ret.add(new PlayerCoolDownValueHolder(mcdvh.skillId, mcdvh.startTime, mcdvh.length));
}
return ret;
}
public int getAllianceRank() {
return this.allianceRank;
}
public int getAllowWarpToId() {
return warpToId;
}
public static String getAriantRoomLeaderName(int room) {
return ariantroomleader[room];
}
public static int getAriantSlotsRoom(int room) {
return ariantroomslot[room];
}
public int getBattleshipHp() {
return battleshipHp;
}
public BuddyList getBuddylist() {
return buddylist;
}
public static Map<String, String> getCharacterFromDatabase(String name) {
Map<String, String> character = new LinkedHashMap<String, String>();
try {
PreparedStatement ps = DatabaseConnection.getConnection().prepareStatement("SELECT `id`, `accountid`, `name` FROM `characters` WHERE `name` = ?");
ps.setString(1, name);
ResultSet rs = ps.executeQuery();
if (!rs.next()) {
rs.close();
ps.close();
return null;
}
for (int i = 1; i <= rs.getMetaData().getColumnCount(); i++) {
character.put(rs.getMetaData().getColumnLabel(i), rs.getString(i));
}
rs.close();
ps.close();
} catch (SQLException sqle) {
sqle.printStackTrace();
}
return character;
}
public static boolean isInUse(String name) {
return getCharacterFromDatabase(name) != null;
}
public Long getBuffedStarttime(MapleBuffStat effect) {
MapleBuffStatValueHolder mbsvh = effects.get(effect);
if (mbsvh == null) {
return null;
}
return Long.valueOf(mbsvh.startTime);
}
public Integer getBuffedValue(MapleBuffStat effect) {
MapleBuffStatValueHolder mbsvh = effects.get(effect);
if (mbsvh == null) {
return null;
}
return Integer.valueOf(mbsvh.value);
}
public int getBuffSource(MapleBuffStat stat) {
MapleBuffStatValueHolder mbsvh = effects.get(stat);
if (mbsvh == null) {
return -1;
}
return mbsvh.effect.getSourceId();
}
private List<MapleBuffStat> getBuffStats(MapleStatEffect effect, long startTime) {
List<MapleBuffStat> stats = new ArrayList<MapleBuffStat>();
for (Entry<MapleBuffStat, MapleBuffStatValueHolder> stateffect : effects.entrySet()) {
if (stateffect.getValue().effect.sameSource(effect) && (startTime == -1 || startTime == stateffect.getValue().startTime)) {
stats.add(stateffect.getKey());
}
}
return stats;
}
public int getChair() {
return chair;
}
public String getChalkboard() {
return this.chalktext;
}
public MapleClient getClient() {
return client;
}
public final List<MapleQuestStatus> getCompletedQuests() {
List<MapleQuestStatus> ret = new LinkedList<MapleQuestStatus>();
for (MapleQuestStatus q : quests.values()) {
if (q.getStatus().equals(MapleQuestStatus.Status.COMPLETED)) {
ret.add(q);
}
}
return Collections.unmodifiableList(ret);
}
public Collection<MapleMonster> getControlledMonsters() {
return Collections.unmodifiableCollection(controlled);
}
public List<MapleRing> getCrushRings() {
Collections.sort(crushRings);
return crushRings;
}
public int getCurrentCI() {
return ci;
}
public int getCurrentPage() {
return currentPage;
}
public int getCurrentMaxHp() {
return localmaxhp;
}
public int getCurrentMaxMp() {
return localmaxmp;
}
public int getCurrentTab() {
return currentTab;
}
public int getCurrentType() {
return currentType;
}
public int getDex() {
return dex;
}
public List<MapleDisease> getDiseases() {
synchronized (diseases) {
return Collections.unmodifiableList(diseases);
}
}
public int getDojoEnergy() {
return dojoEnergy;
}
public boolean getDojoParty() {
return dojoParty;
}
public int getDojoPoints() {
return dojoPoints;
}
public int getDojoStage() {
return dojoStage;
}
public List<MapleDoor> getDoors() {
return new ArrayList<MapleDoor>(doors);
}
public int getDropRate() {
return dropRate;
}
public int getEnergyBar() {
return energybar;
}
public EventInstanceManager getEventInstance() {
return eventInstance;
}
public ArrayList<Integer> getExcluded() {
return excluded;
}
public int getExp() {
return exp.get();
}
public int getGachaExp() {
return gachaexp.get();
}
public int getExpRate() {
return expRate;
}
public int getFace() {
return face;
}
public int getFame() {
return fame;
}
public MapleFamilyEntry getFamily() {
return MapleFamily.getMapleFamily(this);
}
public int getFamilyId() {
return familyId;
}
public boolean getFinishedDojoTutorial() {
return finishedDojoTutorial;
}
public List<MapleRing> getFriendshipRings() {
Collections.sort(friendshipRings);
return friendshipRings;
}
public int getGender() {
return gender;
}
public boolean isMale() {
return getGender() == 0;
}
public boolean getGMChat() {
return whitechat;
}
public MapleGuild getGuild() {
try {
return client.getChannelServer().getWorldInterface().getGuild(getGuildId(), null);
} catch (Exception ex) {
return null;
}
}
public int getGuildId() {
return guildid;
}
public int getGuildRank() {
return guildrank;
}
public int getHair() {
return hair;
}
public HiredMerchant getHiredMerchant() {
return hiredMerchant;
}
public int getHp() {
return hp;
}
public int getHpMpApUsed() {
return hpMpApUsed;
}
public int getId() {
return id;
}
public static int getIdByName(String name) {
try {
PreparedStatement ps = DatabaseConnection.getConnection().prepareStatement("SELECT id FROM characters WHERE name = ?");
ps.setString(1, name);
ResultSet rs = ps.executeQuery();
if (!rs.next()) {
rs.close();
ps.close();
return -1;
}
int id = rs.getInt("id");
rs.close();
ps.close();
return id;
} catch (Exception e) {
}
return -1;
}
public static String getNameById(int id) {
try {
PreparedStatement ps = DatabaseConnection.getConnection().prepareStatement("SELECT name FROM characters WHERE id = ?");
ps.setInt(1, id);
ResultSet rs = ps.executeQuery();
if (!rs.next()) {
rs.close();
ps.close();
return null;
}
String name = rs.getString("name");
rs.close();
ps.close();
return name;
} catch (Exception e) {
}
return null;
}
public static int getIdByName(String name, int world) {
Connection con = DatabaseConnection.getConnection();
PreparedStatement ps;
try {
ps = con.prepareStatement("SELECT id FROM characters WHERE name = ? AND world = ?");
ps.setString(1, name);
ps.setInt(2, world);
ResultSet rs = ps.executeQuery();
if (!rs.next()) {
rs.close();
ps.close();
return -1;
}
int id = rs.getInt("id");
rs.close();
ps.close();
return id;
} catch (SQLException e) {
System.out.print("ERROR" + e);
}
return -1;
}
public int getInitialSpawnpoint() {
return initialSpawnPoint;
}
public int getInt() {
return int_;
}
public MapleInventory getInventory(MapleInventoryType type) {
return inventory[type.ordinal()];
}
public int getItemEffect() {
return itemEffect;
}
public int getItemQuantity(int itemid, boolean checkEquipped) {
int possesed = inventory[MapleItemInformationProvider.getInstance().getInventoryType(itemid).ordinal()].countById(itemid);
if (checkEquipped) {
possesed += inventory[MapleInventoryType.EQUIPPED.ordinal()].countById(itemid);
}
return possesed;
}
public MapleJob getJob() {
return job;
}
public int getJobRank() {
return jobRank;
}
public int getJobRankMove() {
return jobRankMove;
}
public int getJobType() {
return job.getId() / 1000;
}
public Map<Integer, MapleKeyBinding> getKeymap() {
return keymap;
}
public long getLastHealed() {
return lastHealed;
}
public long getLastUsedCashItem() {
return lastUsedCashItem;
}
public int getLevel() {
return level;
}
public int getLuk() {
return luk;
}
public int getFh() {
if (getMap().getFootholds().findBelow(this.getPosition()) == null) {
return 0;
} else {
return getMap().getFootholds().findBelow(this.getPosition()).getId();
}
}
public MapleMap getMap() {
return map;
}
public int getMapId() {
if (map != null) {
return map.getId();
}
return mapid;
}
public int getMarkedMonster() {
return markedMonster;
}
public MapleRing getMarriageRing() {
return marriageRing;
}
public int getMarried() {
return married;
}
public int getMasterLevel(ISkill skill) {
if (skills.get(skill) == null) {
return 0;
}
return skills.get(skill).masterlevel;
}
public int getMaxHp() {
return maxhp;
}
public int getMaxLevel() {
return isCygnus() ? 120 : 200;
}
public int getvotepoints(){
return votepoints;
}
public void setvotepoints(int points){
this.votepoints = votepoints;
}
public int getMaxMp() {
return maxmp;
}
public int getMeso() {
return meso.get();
}
public int getMerchantMeso() {
return merchantmeso;
}
public int getMesoRate() {
return mesoRate;
}
public int getMesosTraded() {
return mesosTraded;
}
public int getMessengerPosition() {
return messengerposition;
}
public MapleGuildCharacter getMGC() {
return mgc;
}
public MapleMiniGame getMiniGame() {
return miniGame;
}
public int getMiniGamePoints(String type, boolean omok) {
if (omok) {
if (type.equals("wins")) {
return omokwins;
} else if (type.equals("losses")) {
return omoklosses;
} else {
return omokties;
}
} else {
if (type.equals("wins")) {
return matchcardwins;
} else if (type.equals("losses")) {
return matchcardlosses;
} else {
return matchcardties;
}
}
}
public MonsterBook getMonsterBook() {
return monsterbook;
}
public int getMonsterBookCover() {
return bookCover;
}
public MapleMount getMount() {
return maplemount;
}
public int getMp() {
return mp;
}
public MapleMessenger getMessenger() {
return messenger;
}
public int getNextEmptyPetIndex() {
for (int i = 0; i < 3; i++) {
if (pets[i] == null) {
return i;
}
}
return 3;
}
public int getNoPets() {
int ret = 0;
for (int i = 0; i < 3; i++) {
if (pets[i] != null) {
ret++;
}
}
return ret;
}
public int getNumControlledMonsters() {
return controlled.size();
}
public MapleParty getParty() {
return party;
}
public int getPartyId() {
return (party != null ? party.getId() : -1);
}
public MaplePlayerShop getPlayerShop() {
return playerShop;
}
public MaplePet[] getPets() {
return pets;
}
public MaplePet getPet(int index) {
return pets[index];
}
public int getPetIndex(int petId) {
for (int i = 0; i < 3; i++) {
if (pets[i] != null) {
if (pets[i].getUniqueId() == petId) {
return i;
}
}
}
return -1;
}
public int getPetIndex(MaplePet pet) {
for (int i = 0; i < 3; i++) {
if (pets[i] != null) {
if (pets[i].getUniqueId() == pet.getUniqueId()) {
return i;
}
}
}
return -1;
}
public int getPossibleReports() {
return possibleReports;
}
public final byte getQuestStatus(final int quest) {
for (final MapleQuestStatus q : quests.values()) {
if (q.getQuest().getId() == quest) {
return (byte) q.getStatus().getId();
}
}
return 0;
}
public MapleQuestStatus getQuest(MapleQuest quest) {
if (!quests.containsKey(quest)) {
return new MapleQuestStatus(quest, MapleQuestStatus.Status.NOT_STARTED);
}
return quests.get(quest);
}
public boolean needQuestItem(int questid, int itemid) {
if (questid <= 0) return true; //For non quest items :3
MapleQuest quest = MapleQuest.getInstance(questid);
return quest.getItemAmountNeeded(itemid) > getInventory(ItemConstants.getInventoryType(itemid)).countById(itemid);
}
public int getRank() {
return rank;
}
public int getRankMove() {
return rankMove;
}
public int getRemainingAp() {
return remainingAp;
}
public int getRemainingSp() {
return remainingSp;
}
public int getSavedLocation(String type) {
int m = savedLocations[SavedLocationType.fromString(type).ordinal()].getMapId();
if (!SavedLocationType.fromString(type).equals(SavedLocationType.WORLDTOUR)) {
clearSavedLocation(SavedLocationType.fromString(type));
}
return m;
}
public String getSearch() {
return search;
}
public MapleShop getShop() {
return shop;
}
public Map<ISkill, SkillEntry> getSkills() {
return Collections.unmodifiableMap(skills);
}
public int getSkillLevel(int skill) {
SkillEntry ret = skills.get(SkillFactory.getSkill(skill));
if (ret == null) {
return 0;
}
return ret.skillevel;
}
public int getSkillLevel(ISkill skill) {
if (skills.get(skill) == null) {
return 0;
}
return skills.get(skill).skillevel;
}
public long getSkillExpiration(int skill) {
SkillEntry ret = skills.get(SkillFactory.getSkill(skill));
if (ret == null) {
return -1;
}
return ret.expiration;
}
public long getSkillExpiration(ISkill skill) {
if (skills.get(skill) == null) {
return -1;
}
return skills.get(skill).expiration;
}
public MapleSkinColor getSkinColor() {
return skinColor;
}
public int getSlot() {
return slots;
}
public final List<MapleQuestStatus> getStartedQuests() {
List<MapleQuestStatus> ret = new LinkedList<MapleQuestStatus>();
for (MapleQuestStatus q : quests.values()) {
if (q.getStatus().equals(MapleQuestStatus.Status.STARTED)) {
ret.add(q);
}
}
return Collections.unmodifiableList(ret);
}
public MapleStatEffect getStatForBuff(MapleBuffStat effect) {
MapleBuffStatValueHolder mbsvh = effects.get(effect);
if (mbsvh == null) {
return null;
}
return mbsvh.effect;
}
public MapleStorage getStorage() {
return storage;
}
public int getStr() {
return str;
}
public Map<Integer, MapleSummon> getSummons() {
return summons;
}
public int getTotalLuk() {
return localluk;
}
public int getTotalMagic() {
return magic;
}
public int getTotalWatk() {
return watk;
}
public MapleTrade getTrade() {
return trade;
}
public int getVanquisherKills() {
return vanquisherKills;
}
public int getVanquisherStage() {
return vanquisherStage;
}
public Collection<MapleMapObject> getVisibleMapObjects() {
return Collections.unmodifiableCollection(visibleMapObjects);
}
public int getWorld() {
return world;
}
public void giveCoolDowns(final int skillid, long starttime, long length) {
int time = (int) ((length + starttime) - System.currentTimeMillis());
addCooldown(skillid, System.currentTimeMillis(), time, TimerManager.getInstance().schedule(new CancelCooldownAction(this, skillid), time));
}
public void giveDebuff(MapleDisease disease, MobSkill skill) {
if (this.isAlive() && diseases.size() < 2) {
List<Pair<MapleDisease, Integer>> disease_ = new ArrayList<Pair<MapleDisease, Integer>>();
disease_.add(new Pair<MapleDisease, Integer>(disease, Integer.valueOf(skill.getX())));
this.diseases.add(disease);
client.announce(MaplePacketCreator.giveDebuff(disease_, skill));
getMap().broadcastMessage(this, MaplePacketCreator.giveForeignDebuff(this.id, disease_, skill), false);
}
}
public int gmLevel() {
return gmLevel;
}
public String guildCost() {
return nf.format(MapleGuild.CREATE_GUILD_COST);
}
private void guildUpdate() {
if (this.guildid < 1) {
return;
}
mgc.setLevel(level);
mgc.setJobId(job.getId());
try {
this.client.getChannelServer().getWorldInterface().memberLevelJobUpdate(this.mgc);
int allianceId = getGuild().getAllianceId();
if (allianceId > 0) {
client.getChannelServer().getWorldInterface().allianceMessage(allianceId, MaplePacketCreator.updateAllianceJobLevel(this), getId(), -1);
}
} catch (RemoteException e) {
e.printStackTrace();
}
}
public void handleEnergyChargeGain() { // to get here energychargelevel has to be > 0
ISkill energycharge = isCygnus() ? SkillFactory.getSkill(ThunderBreaker.ENERGY_CHARGE) : SkillFactory.getSkill(Marauder.ENERGY_CHARGE);
MapleStatEffect ceffect = null;
ceffect = energycharge.getEffect(getSkillLevel(energycharge));
TimerManager tMan = TimerManager.getInstance();
if (energybar < 10000) {
energybar += 102;
if (energybar > 10000) {
energybar = 10000;
}
client.announce(MaplePacketCreator.giveEnergyCharge(energybar));
client.announce(MaplePacketCreator.showOwnBuffEffect(energycharge.getId(), 2));
getMap().broadcastMessage(this, MaplePacketCreator.showBuffeffect(id, energycharge.getId(), 2));
if (energybar == 10000) {
getMap().broadcastMessage(this, MaplePacketCreator.giveForeignEnergyCharge(id, energybar));
}
}
if (energybar >= 10000 && energybar < 11000) {
energybar = 15000;
final MapleCharacter chr = this;
tMan.schedule(new Runnable() {
@Override
public void run() {
client.announce(MaplePacketCreator.giveEnergyCharge(0));
getMap().broadcastMessage(chr, MaplePacketCreator.giveForeignEnergyCharge(id, energybar));
energybar = 0;
}
}, ceffect.getDuration());
}
}
public void handleOrbconsume() {
int skillid = isCygnus() ? DawnWarrior.COMBO : Crusader.COMBO;
ISkill combo = SkillFactory.getSkill(skillid);
List<Pair<MapleBuffStat, Integer>> stat = Collections.singletonList(new Pair<MapleBuffStat, Integer>(MapleBuffStat.COMBO, 1));
setBuffedValue(MapleBuffStat.COMBO, 1);
client.announce(MaplePacketCreator.giveBuff(skillid, combo.getEffect(getSkillLevel(combo)).getDuration() + (int) ((getBuffedStarttime(MapleBuffStat.COMBO) - System.currentTimeMillis())), stat, false, false, getMount()));
getMap().broadcastMessage(this, MaplePacketCreator.giveForeignBuff(getId(), stat, false), false);
}
public boolean hasEntered(String script) {
for (int mapId : entered.keySet()) {
if (entered.get(mapId).equals(script)) {
return true;
}
}
return false;
}
public boolean hasEntered(String script, int mapId) {
if (entered.containsKey(mapId)) {
if (entered.get(mapId).equals(script)) {
return true;
}
}
return false;
}
public void hasGivenFame(MapleCharacter to) {
lastfametime = System.currentTimeMillis();
lastmonthfameids.add(Integer.valueOf(to.getId()));
try {
PreparedStatement ps = DatabaseConnection.getConnection().prepareStatement("INSERT INTO famelog (characterid, characterid_to) VALUES (?, ?)");
ps.setInt(1, getId());
ps.setInt(2, to.getId());
ps.executeUpdate();
ps.close();
} catch (SQLException e) {
}
}
public boolean hasMerchant() {
return hasMerchant;
}
public boolean haveItem(int itemid) {
return getItemQuantity(itemid, false) > 0;
}
public boolean haveMeso(int mesos) {
return meso.get() > mesos;
}
public void increaseGuildCapacity() { //hopefully nothing is null
if (getMeso() < getGuild().getIncreaseGuildCost(getGuild().getCapacity())) {
dropMessage(1, "You don't have enough mesos.");
return;
}
try {
client.getChannelServer().getWorldInterface().increaseGuildCapacity(guildid);
} catch (RemoteException e) {
client.getChannelServer().reconnectWorld();
return;
}
gainMeso(-getGuild().getIncreaseGuildCost(getGuild().getCapacity()), true, false, false);
}
public boolean isActiveBuffedValue(int skillid) {
LinkedList<MapleBuffStatValueHolder> allBuffs = new LinkedList<MapleBuffStatValueHolder>(effects.values());
for (MapleBuffStatValueHolder mbsvh : allBuffs) {
if (mbsvh.effect.isSkill() && mbsvh.effect.getSourceId() == skillid) {
return true;
}
}
return false;
}
public boolean isAlive() {
return hp > 0;
}
public boolean isBuffFrom(MapleBuffStat stat, ISkill skill) {
MapleBuffStatValueHolder mbsvh = effects.get(stat);
if (mbsvh == null) {
return false;
}
return mbsvh.effect.isSkill() && mbsvh.effect.getSourceId() == skill.getId();
}
public boolean isCygnus() {
return getJobType() == 1;
}
public boolean isAran() {
return getJob().getId() >= 2000 && getJob().getId() <= 2112;
}
public boolean isBeginnerJob() {
return (getJob().getId() == 0 || getJob().getId() == 1000 || getJob().getId() == 2000) && getLevel() < 11;
}
public boolean isGM() {
return gmLevel > 0;
}
public boolean isHidden() {
return hidden;
}
public boolean isMapObjectVisible(MapleMapObject mo) {
return visibleMapObjects.contains(mo);
}
public boolean isPartyLeader() {
return party.getLeader() == party.getMemberById(getId());
}
public void leaveMap() {
controlled.clear();
visibleMapObjects.clear();
if (chair != 0) {
chair = 0;
}
if (hpDecreaseTask != null) {
hpDecreaseTask.cancel(false);
}
}
public void levelUp(boolean takeexp) {
ISkill improvingMaxHP = null;
ISkill improvingMaxMP = null;
int improvingMaxHPLevel = 0;
int improvingMaxMPLevel = 0;
if (isBeginnerJob()) {
remainingAp = 0;
if (getLevel() < 6) {
str += 5;
} else {
str += 4;
dex += 1;
}
} else {
remainingAp += 5;
if (isCygnus() && level < 70) {
remainingAp++;
}
}
if (job == MapleJob.BEGINNER || job == MapleJob.NOBLESSE || job == MapleJob.LEGEND) {
maxhp += Randomizer.rand(12, 16);
maxmp += Randomizer.rand(10, 12);
} else if (job.isA(MapleJob.WARRIOR) || job.isA(MapleJob.DAWNWARRIOR1)) {
improvingMaxHP = isCygnus() ? SkillFactory.getSkill(DawnWarrior.MAX_HP_INCREASE) : SkillFactory.getSkill(Swordsman.IMPROVED_MAX_HP_INCREASE);
if (job.isA(MapleJob.CRUSADER)) {
improvingMaxMP = SkillFactory.getSkill(1210000);
} else if (job.isA(MapleJob.DAWNWARRIOR2)) {
improvingMaxMP = SkillFactory.getSkill(11110000);
}
improvingMaxHPLevel = getSkillLevel(improvingMaxHP);
maxhp += Randomizer.rand(24, 28);
maxmp += Randomizer.rand(4, 6);
} else if (job.isA(MapleJob.MAGICIAN) || job.isA(MapleJob.BLAZEWIZARD1)) {
improvingMaxMP = isCygnus() ? SkillFactory.getSkill(BlazeWizard.INCREASING_MAX_MP) : SkillFactory.getSkill(Magician.IMPROVED_MAX_MP_INCREASE);
improvingMaxMPLevel = getSkillLevel(improvingMaxMP);
maxhp += Randomizer.rand(10, 14);
maxmp += Randomizer.rand(22, 24);
} else if (job.isA(MapleJob.BOWMAN) || job.isA(MapleJob.THIEF) || (job.getId() > 1299 && job.getId() < 1500)) {
maxhp += Randomizer.rand(20, 24);
maxmp += Randomizer.rand(14, 16);
} else if (job.isA(MapleJob.GM)) {
maxhp = 30000;
maxmp = 30000;
} else if (job.isA(MapleJob.PIRATE) || job.isA(MapleJob.THUNDERBREAKER1)) {
improvingMaxHP = isCygnus() ? SkillFactory.getSkill(ThunderBreaker.IMPROVE_MAX_HP) : SkillFactory.getSkill(5100000);
improvingMaxHPLevel = getSkillLevel(improvingMaxHP);
maxhp += Randomizer.rand(22, 28);
maxmp += Randomizer.rand(18, 23);
} else if (job.isA(MapleJob.ARAN1)) {
maxhp += Randomizer.rand(44, 48);
int aids = Randomizer.rand(4, 8);
maxmp += aids + Math.floor(aids * 0.1);
}
if (improvingMaxHPLevel > 0 && (job.isA(MapleJob.WARRIOR) || job.isA(MapleJob.PIRATE) || job.isA(MapleJob.DAWNWARRIOR1))) {
maxhp += improvingMaxHP.getEffect(improvingMaxHPLevel).getX();
}
if (improvingMaxMPLevel > 0 && (job.isA(MapleJob.MAGICIAN) || job.isA(MapleJob.CRUSADER) || job.isA(MapleJob.BLAZEWIZARD1))) {
maxmp += improvingMaxMP.getEffect(improvingMaxMPLevel).getX();
}
maxmp += localint_ / 10;
if (takeexp) {
exp.addAndGet(-ExpTable.getExpNeededForLevel(level));
if (exp.get() < 0) {
exp.set(0);
}
}
level++;
if (level >= getMaxLevel()) {
exp.set(0);
}
maxhp = Math.min(30000, maxhp);
maxmp = Math.min(30000, maxmp);
if (level == 200) {
exp.set(0);
}
hp = maxhp;
mp = maxmp;
recalcLocalStats();
List<Pair<MapleStat, Integer>> statup = new ArrayList<Pair<MapleStat, Integer>>(10);
statup.add(new Pair<MapleStat, Integer>(MapleStat.AVAILABLEAP, remainingAp));
statup.add(new Pair<MapleStat, Integer>(MapleStat.HP, localmaxhp));
statup.add(new Pair<MapleStat, Integer>(MapleStat.MP, localmaxmp));
statup.add(new Pair<MapleStat, Integer>(MapleStat.EXP, exp.get()));
statup.add(new Pair<MapleStat, Integer>(MapleStat.LEVEL, level));
statup.add(new Pair<MapleStat, Integer>(MapleStat.MAXHP, maxhp));
statup.add(new Pair<MapleStat, Integer>(MapleStat.MAXMP, maxmp));
statup.add(new Pair<MapleStat, Integer>(MapleStat.STR, str));
statup.add(new Pair<MapleStat, Integer>(MapleStat.DEX, dex));
if (job.getId() % 1000 > 0) {
remainingSp += 3;
statup.add(new Pair<MapleStat, Integer>(MapleStat.AVAILABLESP, remainingSp));
}
client.announce(MaplePacketCreator.updatePlayerStats(statup));
getMap().broadcastMessage(this, MaplePacketCreator.showForeignEffect(getId(), 0), false);
recalcLocalStats();
silentPartyUpdate();
if (this.guildid > 0) {
getGuild().broadcast(MaplePacketCreator.levelUpMessage(2, level, name), this.getId());
}
guildUpdate();
if (ServerConstants.GMS_LIKE) saveToDB(true);
if (level>=120 && is3rdJob())
{
client.getPlayer().changeJob(MapleJob.getById(job.getId() + 1));
}
else if (level >= 70 && is2ndJob())
{
client.getPlayer().changeJob(MapleJob.getById(job.getId() + 1));
}
else if (level == 30)
{
NPCScriptManager.getInstance().start(getClient(), 9200000, null, null);
}
else if (level==10)
{
NPCScriptManager.getInstance().start(getClient(), 9200000, null, null);
}
}
public boolean is2ndJob() {
return getJob().getId()%10 == 0 && getJob().getId()%100 != 0;
}
public boolean is3rdJob() {
return getJob().getId()%10 == 1;
}
public static MapleCharacter loadCharFromDB(int charid, MapleClient client, boolean channelserver) throws SQLException {
try {
MapleCharacter ret = new MapleCharacter();
ret.client = client;
ret.id = charid;
Connection con = DatabaseConnection.getConnection();
PreparedStatement ps = con.prepareStatement("SELECT * FROM characters WHERE id = ?");
ps.setInt(1, charid);
ResultSet rs = ps.executeQuery();
if (!rs.next()) {
rs.close();
ps.close();
throw new RuntimeException("Loading char failed (not found)");
}
ret.name = rs.getString("name");
ret.level = rs.getInt("level");
ret.fame = rs.getInt("fame");
ret.str = rs.getInt("str");
ret.dex = rs.getInt("dex");
ret.int_ = rs.getInt("int");
ret.luk = rs.getInt("luk");
ret.exp.set(rs.getInt("exp"));
ret.gachaexp.set(rs.getInt("gachaexp"));
ret.hp = rs.getInt("hp");
ret.maxhp = rs.getInt("maxhp");
ret.mp = rs.getInt("mp");
ret.maxmp = rs.getInt("maxmp");
ret.hpMpApUsed = rs.getInt("hpMpUsed");
ret.hasMerchant = rs.getInt("HasMerchant") == 1;
ret.remainingSp = rs.getInt("sp");
ret.remainingAp = rs.getInt("ap");
ret.meso.set(rs.getInt("meso"));
ret.merchantmeso = rs.getInt("MerchantMesos");
ret.gmLevel = rs.getInt("gm");
ret.skinColor = MapleSkinColor.getById(rs.getInt("skincolor"));
ret.gender = rs.getInt("gender");
ret.job = MapleJob.getById(rs.getInt("job"));
ret.finishedDojoTutorial = rs.getInt("finishedDojoTutorial") == 1;
ret.vanquisherKills = rs.getInt("vanquisherKills");
ret.omokwins = rs.getInt("omokwins");
ret.omoklosses = rs.getInt("omoklosses");
ret.omokties = rs.getInt("omokties");
ret.matchcardwins = rs.getInt("matchcardwins");
ret.matchcardlosses = rs.getInt("matchcardlosses");
ret.matchcardties = rs.getInt("matchcardties");
ret.hair = rs.getInt("hair");
ret.face = rs.getInt("face");
ret.accountid = rs.getInt("accountid");
ret.mapid = rs.getInt("map");
ret.initialSpawnPoint = rs.getInt("spawnpoint");
ret.world = rs.getInt("world");
ret.rank = rs.getInt("rank");
ret.rankMove = rs.getInt("rankMove");
ret.jobRank = rs.getInt("jobRank");
ret.jobRankMove = rs.getInt("jobRankMove");
int mountexp = rs.getInt("mountexp");
int mountlevel = rs.getInt("mountlevel");
int mounttiredness = rs.getInt("mounttiredness");
ret.guildid = rs.getInt("guildid");
ret.guildrank = rs.getInt("guildrank");
ret.allianceRank = rs.getInt("allianceRank");
ret.familyId = rs.getInt("familyId");
ret.bookCover = rs.getInt("monsterbookcover");
ret.monsterbook = new MonsterBook();
ret.monsterbook.loadCards(charid);
ret.vanquisherStage = rs.getInt("vanquisherStage");
ret.dojoPoints = rs.getInt("dojoPoints");
ret.dojoStage = rs.getInt("lastDojoStage");
ret.votepoints = rs.getInt("votepoints");
ret.whitechat = ret.gmLevel > 0;
ret.reborns = rs.getInt("reborns");
if (ret.guildid > 0) {
ret.mgc = new MapleGuildCharacter(ret);
}
int buddyCapacity = rs.getInt("buddyCapacity");
ret.buddylist = new BuddyList(buddyCapacity);
ret.getInventory(MapleInventoryType.EQUIP).setSlotLimit(rs.getByte("equipslots"));
ret.getInventory(MapleInventoryType.USE).setSlotLimit(rs.getByte("useslots"));
ret.getInventory(MapleInventoryType.SETUP).setSlotLimit(rs.getByte("setupslots"));
ret.getInventory(MapleInventoryType.ETC).setSlotLimit(rs.getByte("etcslots"));
for (Pair<IItem, MapleInventoryType> item : ItemFactory.INVENTORY.loadItems(ret.id, !channelserver)) {
ret.getInventory(item.getRight()).addFromDB(item.getLeft());
IItem itemz = item.getLeft();
if (itemz.getPetId() > -1) {
MaplePet pet = MaplePet.loadFromDb(itemz.getItemId(), itemz.getPosition(), itemz.getPetId());
if (pet.isSummoned())
ret.addPet(pet);
}
}
if (channelserver) {
MapleMapFactory mapFactory = client.getChannelServer().getMapFactory();
ret.map = mapFactory.getMap(ret.mapid);
if (ret.map == null) {
ret.map = mapFactory.getMap(100000000);
}
MaplePortal portal = ret.map.getPortal(ret.initialSpawnPoint);
if (portal == null) {
portal = ret.map.getPortal(0);
ret.initialSpawnPoint = 0;
}
ret.setPosition(portal.getPosition());
int partyid = rs.getInt("party");
try {
MapleParty party = client.getChannelServer().getWorldInterface().getParty(partyid);
if (party != null) {
ret.party = party;
}
} catch (RemoteException ex) {
client.getChannelServer().reconnectWorld();
}
int messengerid = rs.getInt("messengerid");
int position = rs.getInt("messengerposition");
if (messengerid > 0 && position < 4 && position > -1) {
try {
WorldChannelInterface wci = client.getChannelServer().getWorldInterface();
MapleMessenger messenger = wci.getMessenger(messengerid);
if (messenger != null) {
ret.messenger = messenger;
ret.messengerposition = position;
}
} catch (RemoteException ez) {
client.getChannelServer().reconnectWorld();
}
}
}
rs.close();
ps.close();
ps = con.prepareStatement("SELECT name FROM accounts WHERE id = ?");
ps.setInt(1, ret.accountid);
rs = ps.executeQuery();
if (rs.next()) {
ret.getClient().setAccountName(rs.getString("name"));
}
rs.close();
ps.close();
ret.cashshop = new CashShop(ret.accountid, ret.id, ret.getJobType());
ret.autoban = new AutobanManager(ret);
if (ret.id == 30027)
ret.marriageRing = null; //for now
ps = con.prepareStatement("SELECT name, level FROM characters WHERE accountid = ? AND id != ? ORDER BY level DESC limit 1");
ps.setInt(1, ret.accountid);
ps.setInt(2, charid);
rs = ps.executeQuery();
if (rs.next()) {
ret.linkedName = rs.getString("name");
ret.linkedLevel = rs.getInt("level");
}
rs.close();
ps.close();
if (channelserver) {
ps = con.prepareStatement("SELECT * FROM queststatus WHERE characterid = ?");
ps.setInt(1, charid);
rs = ps.executeQuery();
PreparedStatement pse = con.prepareStatement("SELECT * FROM queststatusmobs WHERE queststatusid = ?");
while (rs.next()) {
MapleQuest q = MapleQuest.getInstance(rs.getInt("quest"));
MapleQuestStatus status = new MapleQuestStatus(q, MapleQuestStatus.Status.getById(rs.getInt("status")));
long cTime = rs.getLong("time");
if (cTime > -1) {
status.setCompletionTime(cTime * 1000);
}
status.setForfeited(rs.getInt("forfeited"));
ret.quests.put(q, status);
pse.setInt(1, rs.getInt("queststatusid"));
ResultSet rsMobs = pse.executeQuery();
while (rsMobs.next()) {
status.setMobKills(rsMobs.getInt("mob"), rsMobs.getInt("count"));
}
rsMobs.close();
}
rs.close();
ps.close();
pse.close();
ps = con.prepareStatement("SELECT skillid,skilllevel,masterlevel,expiration FROM skills WHERE characterid = ?");
ps.setInt(1, charid);
rs = ps.executeQuery();
while (rs.next()) {
ret.skills.put(SkillFactory.getSkill(rs.getInt("skillid")), new SkillEntry(rs.getInt("skilllevel"), rs.getInt("masterlevel"), rs.getLong("expiration")));
}
rs.close();
ps.close();
ps = con.prepareStatement("SELECT * FROM skillmacros WHERE characterid = ?");
ps.setInt(1, charid);
rs = ps.executeQuery();
while (rs.next()) {
int position = rs.getInt("position");
SkillMacro macro = new SkillMacro(rs.getInt("skill1"), rs.getInt("skill2"), rs.getInt("skill3"), rs.getString("name"), rs.getInt("shout"), position);
ret.skillMacros[position] = macro;
}
rs.close();
ps.close();
ps = con.prepareStatement("SELECT `key`,`type`,`action` FROM keymap WHERE characterid = ?");
ps.setInt(1, charid);
rs = ps.executeQuery();
while (rs.next()) {
int key = rs.getInt("key");
int type = rs.getInt("type");
int action = rs.getInt("action");
ret.keymap.put(Integer.valueOf(key), new MapleKeyBinding(type, action));
}
rs.close();
ps.close();
ps = con.prepareStatement("SELECT `locationtype`,`map`,`portal` FROM savedlocations WHERE characterid = ?");
ps.setInt(1, charid);
rs = ps.executeQuery();
while (rs.next()) {
ret.savedLocations[SavedLocationType.valueOf(rs.getString("locationtype")).ordinal()] = new SavedLocation(rs.getInt("map"), rs.getInt("portal"));
}
rs.close();
ps.close();
ps = con.prepareStatement("SELECT `characterid_to`,`when` FROM famelog WHERE characterid = ? AND DATEDIFF(NOW(),`when`) < 30");
ps.setInt(1, charid);
rs = ps.executeQuery();
ret.lastfametime = 0;
ret.lastmonthfameids = new ArrayList<Integer>(31);
while (rs.next()) {
ret.lastfametime = Math.max(ret.lastfametime, rs.getTimestamp("when").getTime());
ret.lastmonthfameids.add(Integer.valueOf(rs.getInt("characterid_to")));
}
rs.close();
ps.close();
ret.buddylist.loadFromDb(charid);
ret.storage = MapleStorage.loadOrCreateFromDB(ret.accountid);
ret.recalcLocalStats();
ret.resetBattleshipHp();
ret.silentEnforceMaxHpMp();
}
int mountid = ret.getJobType() * 10000000 + 1004;
if (ret.getInventory(MapleInventoryType.EQUIPPED).getItem((byte) -18) != null) {
ret.maplemount = new MapleMount(ret, ret.getInventory(MapleInventoryType.EQUIPPED).getItem((byte) -18).getItemId(), mountid);
} else {
ret.maplemount = new MapleMount(ret, 0, mountid);
}
ret.maplemount.setExp(mountexp);
ret.maplemount.setLevel(mountlevel);
ret.maplemount.setTiredness(mounttiredness);
ret.maplemount.setActive(false);
return ret;
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
public static String makeMapleReadable(String in) {
String i = in.replace('I', 'i');
i = i.replace('l', 'L');
i = i.replace("rn", "Rn");
i = i.replace("vv", "Vv");
i = i.replace("VV", "Vv");
return i;
}
private static class MapleBuffStatValueHolder {
public MapleStatEffect effect;
public long startTime;
public int value;
public ScheduledFuture<?> schedule;
public MapleBuffStatValueHolder(MapleStatEffect effect, long startTime, ScheduledFuture<?> schedule, int value) {
super();
this.effect = effect;
this.startTime = startTime;
this.schedule = schedule;
this.value = value;
}
}
public static class MapleCoolDownValueHolder {
public int skillId;
public long startTime, length;
public ScheduledFuture<?> timer;
public MapleCoolDownValueHolder(int skillId, long startTime, long length, ScheduledFuture<?> timer) {
super();
this.skillId = skillId;
this.startTime = startTime;
this.length = length;
this.timer = timer;
}
}
public void message(String m) {
dropMessage(5, m);
}
public void yellowMessage(String m) {
announce(MaplePacketCreator.sendYellowTip(m));
}
public void mobKilled(int id) {
for (MapleQuestStatus q : quests.values()) {
if (q.getStatus() == MapleQuestStatus.Status.COMPLETED || q.getQuest().canComplete(this, null)) continue;
if (q.getMobKills(id) > q.getQuest().getMobAmountNeeded(id)) continue;
if (q.mobKilled(id)) {
client.announce(MaplePacketCreator.updateQuestMobKills(q));
if (q.getQuest().canComplete(this, null)) {
client.announce(MaplePacketCreator.getShowQuestCompletion(q.getQuest().getId()));
}
}
}
}
public void mount(int id, int skillid) {
maplemount = new MapleMount(this, id, skillid);
}
public void playerNPC(MapleCharacter v, int scriptId) {
int npcId;
try {
Connection con = DatabaseConnection.getConnection();
PreparedStatement ps = con.prepareStatement("SELECT id FROM playernpcs WHERE ScriptId = ?");
ps.setInt(1, scriptId);
ResultSet rs = ps.executeQuery();
if (!rs.next()) {
rs.close();
ps = con.prepareStatement("INSERT INTO playernpcs (name, hair, face, skin, x, cy, map, ScriptId, Foothold, rx0, rx1) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", Statement.RETURN_GENERATED_KEYS);
ps.setString(1, v.getName());
ps.setInt(2, v.getHair());
ps.setInt(3, v.getFace());
ps.setInt(4, v.getSkinColor().getId());
ps.setInt(5, getPosition().x);
ps.setInt(6, getPosition().y);
ps.setInt(7, getMapId());
ps.setInt(8, scriptId);
ps.setInt(9, getMap().getFootholds().findBelow(getPosition()).getId());
ps.setInt(10, getPosition().x + 50);
ps.setInt(11, getPosition().x - 50);
ps.executeUpdate();
rs = ps.getGeneratedKeys();
rs.next();
npcId = rs.getInt(1);
ps.close();
ps = con.prepareStatement("INSERT INTO playernpcs_equip (NpcId, equipid, equippos) VALUES (?, ?, ?)");
ps.setInt(1, npcId);
for (IItem equip : getInventory(MapleInventoryType.EQUIPPED)) {
int position = Math.abs(equip.getPosition());
if ((position < 12 && position > 0) || (position > 100 && position < 112)) {
ps.setInt(2, equip.getItemId());
ps.setInt(3, equip.getPosition());
ps.addBatch();
}
}
ps.executeBatch();
ps.close();
rs.close();
ps = con.prepareStatement("SELECT * FROM playernpcs WHERE ScriptId = ?");
ps.setInt(1, scriptId);
rs = ps.executeQuery();
rs.next();
PlayerNPCs pn = new PlayerNPCs(rs);
for (ChannelServer channel : ChannelServer.getAllInstances()) {
MapleMap m = channel.getMapFactory().getMap(getMapId());
m.broadcastMessage(MaplePacketCreator.spawnPlayerNPC(pn));
m.broadcastMessage(MaplePacketCreator.getPlayerNPC(pn));
m.addMapObject(pn);
}
}
ps.close();
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
private void playerDead() {
cancelAllBuffs();
dispelDebuffs();
if (getEventInstance() != null) {
getEventInstance().playerKilled(this);
}
int[] charmID = {5130000, 4031283, 4140903};
int possesed = 0;
int i;
for (i = 0; i < charmID.length; i++) {
int quantity = getItemQuantity(charmID[i], false);
if (possesed == 0 && quantity > 0) {
possesed = quantity;
break;
}
}
if (possesed > 0) {
message("You have used a safety charm, so your EXP points have not been decreased.");
MapleInventoryManipulator.removeById(client, MapleItemInformationProvider.getInstance().getInventoryType(charmID[i]), charmID[i], 1, true, false);
} else if (mapid > 925020000 && mapid < 925030000) {
this.dojoStage = 0;
} else if (mapid > 980000100 && mapid < 980000700) {
getMap().broadcastMessage(this, MaplePacketCreator.CPQDied(this));
} else if (getJob() != MapleJob.BEGINNER) { //Hmm...
int XPdummy = ExpTable.getExpNeededForLevel(getLevel());
if (getMap().isTown()) {
XPdummy /= 100;
}
if (XPdummy == ExpTable.getExpNeededForLevel(getLevel())) {
if (getLuk() <= 100 && getLuk() > 8) {
XPdummy *= (200 - getLuk()) / 2000;
} else if (getLuk() < 8) {
XPdummy /= 10;
} else {
XPdummy /= 20;
}
}
if (getExp() > XPdummy) {
gainExp(-XPdummy, false, false);
} else {
gainExp(-getExp(), false, false);
}
}
if (getBuffedValue(MapleBuffStat.MORPH) != null) {
cancelEffectFromBuffStat(MapleBuffStat.MORPH);
}
if (getBuffedValue(MapleBuffStat.MONSTER_RIDING) != null) {
cancelEffectFromBuffStat(MapleBuffStat.MONSTER_RIDING);
}
if (getChair() == -1) {
setChair(0);
client.announce(MaplePacketCreator.cancelChair(-1));
getMap().broadcastMessage(this, MaplePacketCreator.showChair(getId(), 0), false);
}
client.announce(MaplePacketCreator.enableActions());
}
private void prepareDragonBlood(final MapleStatEffect bloodEffect) {
if (dragonBloodSchedule != null) {
dragonBloodSchedule.cancel(false);
}
dragonBloodSchedule = TimerManager.getInstance().register(new Runnable() {
@Override
public void run() {
addHP(-bloodEffect.getX());
client.announce(MaplePacketCreator.showOwnBuffEffect(bloodEffect.getSourceId(), 5));
getMap().broadcastMessage(MapleCharacter.this, MaplePacketCreator.showBuffeffect(getId(), bloodEffect.getSourceId(), 5), false);
checkBerserk();
}
}, 4000, 4000);
}
private void recalcLocalStats() {
int oldmaxhp = localmaxhp;
localmaxhp = getMaxHp();
localmaxmp = getMaxMp();
localdex = getDex();
localint_ = getInt();
localstr = getStr();
localluk = getLuk();
int speed = 100, jump = 100;
magic = localint_;
watk = 0;
for (IItem item : getInventory(MapleInventoryType.EQUIPPED)) {
IEquip equip = (IEquip) item;
localmaxhp += equip.getHp();
localmaxmp += equip.getMp();
localdex += equip.getDex();
localint_ += equip.getInt();
localstr += equip.getStr();
localluk += equip.getLuk();
magic += equip.getMatk() + equip.getInt();
watk += equip.getWatk();
speed += equip.getSpeed();
jump += equip.getJump();
}
magic = Math.min(magic, 2000);
Integer hbhp = getBuffedValue(MapleBuffStat.HYPERBODYHP);
if (hbhp != null) {
localmaxhp += (hbhp.doubleValue() / 100) * localmaxhp;
}
Integer hbmp = getBuffedValue(MapleBuffStat.HYPERBODYMP);
if (hbmp != null) {
localmaxmp += (hbmp.doubleValue() / 100) * localmaxmp;
}
localmaxhp = Math.min(30000, localmaxhp);
localmaxmp = Math.min(30000, localmaxmp);
Integer watkbuff = getBuffedValue(MapleBuffStat.WATK);
if (watkbuff != null) {
watk += watkbuff.intValue();
}
if (job.isA(MapleJob.BOWMAN)) {
ISkill expert = null;
if (job.isA(MapleJob.MARKSMAN)) {
expert = SkillFactory.getSkill(3220004);
} else if (job.isA(MapleJob.BOWMASTER)) {
expert = SkillFactory.getSkill(3120005);
}
if (expert != null) {
int boostLevel = getSkillLevel(expert);
if (boostLevel > 0) {
watk += expert.getEffect(boostLevel).getX();
}
}
}
Integer matkbuff = getBuffedValue(MapleBuffStat.MATK);
if (matkbuff != null) {
magic += matkbuff.intValue();
}
Integer speedbuff = getBuffedValue(MapleBuffStat.SPEED);
if (speedbuff != null) {
speed += speedbuff.intValue();
}
Integer jumpbuff = getBuffedValue(MapleBuffStat.JUMP);
if (jumpbuff != null) {
jump += jumpbuff.intValue();
}
if (speed > 140) {
speed = 140;
}
if (jump > 123) {
jump = 123;
}
if (oldmaxhp != 0 && oldmaxhp != localmaxhp) {
updatePartyMemberHP();
}
}
public void receivePartyMemberHP() {
if (party != null) {
int channel = client.getChannel();
for (MaplePartyCharacter partychar : party.getMembers()) {
if (partychar.getMapid() == getMapId() && partychar.getChannel() == channel) {
MapleCharacter other = ChannelServer.getInstance(channel).getPlayerStorage().getCharacterByName(partychar.getName());
if (other != null) {
client.announce(MaplePacketCreator.updatePartyMemberHP(other.getId(), other.getHp(), other.getCurrentMaxHp()));
}
}
}
}
}
public void registerEffect(MapleStatEffect effect, long starttime, ScheduledFuture<?> schedule) {
if (effect.isHide() && gmLevel > 0) {
this.hidden = true;
announce(MaplePacketCreator.getGMEffect(0x10, (byte) 1));
getMap().broadcastNONGMMessage(this, MaplePacketCreator.removePlayerFromMap(getId()), false);
} else if (effect.isDragonBlood()) {
prepareDragonBlood(effect);
} else if (effect.isBerserk()) {
checkBerserk();
} else if (effect.isBeholder()) {
final int beholder = DarkKnight.BEHOLDER;
if (beholderHealingSchedule != null) {
beholderHealingSchedule.cancel(false);
}
if (beholderBuffSchedule != null) {
beholderBuffSchedule.cancel(false);
}
ISkill bHealing = SkillFactory.getSkill(DarkKnight.AURA_OF_BEHOLDER);
int bHealingLvl = getSkillLevel(bHealing);
if (bHealingLvl > 0) {
final MapleStatEffect healEffect = bHealing.getEffect(bHealingLvl);
int healInterval = healEffect.getX() * 1000;
beholderHealingSchedule = TimerManager.getInstance().register(new Runnable() {
@Override
public void run() {
addHP(healEffect.getHp());
client.announce(MaplePacketCreator.showOwnBuffEffect(beholder, 2));
getMap().broadcastMessage(MapleCharacter.this, MaplePacketCreator.summonSkill(getId(), beholder, 5), true);
getMap().broadcastMessage(MapleCharacter.this, MaplePacketCreator.showOwnBuffEffect(beholder, 2), false);
}
}, healInterval, healInterval);
}
ISkill bBuff = SkillFactory.getSkill(DarkKnight.HEX_OF_BEHOLDER);
if (getSkillLevel(bBuff) > 0) {
final MapleStatEffect buffEffect = bBuff.getEffect(getSkillLevel(bBuff));
int buffInterval = buffEffect.getX() * 1000;
beholderBuffSchedule = TimerManager.getInstance().register(new Runnable() {
@Override
public void run() {
buffEffect.applyTo(MapleCharacter.this);
client.announce(MaplePacketCreator.showOwnBuffEffect(beholder, 2));
getMap().broadcastMessage(MapleCharacter.this, MaplePacketCreator.summonSkill(getId(), beholder, (int) (Math.random() * 3) + 6), true);
getMap().broadcastMessage(MapleCharacter.this, MaplePacketCreator.showBuffeffect(getId(), beholder, 2), false);
}
}, buffInterval, buffInterval);
}
}
for (Pair<MapleBuffStat, Integer> statup : effect.getStatups()) {
effects.put(statup.getLeft(), new MapleBuffStatValueHolder(effect, starttime, schedule, statup.getRight().intValue()));
}
recalcLocalStats();
}
public void ban(String reason) {
try {
getClient().banMacs();
Connection con = DatabaseConnection.getConnection();
PreparedStatement ps = con.prepareStatement("UPDATE accounts SET banned = ?, banreason = ? WHERE id = ?");
ps.setInt(1, 1);
ps.setString(2, reason);
ps.setInt(3, accountid);
ps.executeUpdate();
ps.close();
ps = con.prepareStatement("INSERT INTO ipbans VALUES (DEFAULT, ?)");
String[] ipSplit = client.getSession().getRemoteAddress().toString().split(":");
ps.setString(1, ipSplit[0]);
ps.executeUpdate();
ps.close();
} catch (SQLException ex) {
log.error("Error while banning", ex);
}
client.getSession().write(MaplePacketCreator.sendGMPolice());
TimerManager.getInstance().schedule(new Runnable() {
public void run() {
client.getSession().close();
}
}, 10000);
}
public void removeAllCooldownsExcept(int id) {
for (MapleCoolDownValueHolder mcvh : coolDowns.values()) {
if (mcvh.skillId != id) {
coolDowns.remove(mcvh.skillId);
}
}
}
public static void removeAriantRoom(int room) {
ariantroomleader[room] = "";
ariantroomslot[room] = 0;
}
public void removeBuffStat(MapleBuffStat effect) {
effects.remove(effect);
}
public void removeCooldown(int skillId) {
if (this.coolDowns.containsKey(skillId)) {
this.coolDowns.remove(skillId);
}
}
public void removeDisease(MapleDisease disease) {
synchronized (diseases) {
if (diseases.contains(disease)) {
diseases.remove(disease);
}
}
}
public void removeDiseases() {
diseases.clear();
}
public void removePet(MaplePet pet, boolean shift_left) {
int slot = -1;
for (int i = 0; i < 3; i++) {
if (pets[i] != null) {
if (pets[i].getUniqueId() == pet.getUniqueId()) {
pets[i] = null;
slot = i;
break;
}
}
}
if (shift_left) {
if (slot > -1) {
for (int i = slot; i < 3; i++) {
if (i != 2) {
pets[i] = pets[i + 1];
} else {
pets[i] = null;
}
}
}
}
}
public void removeVisibleMapObject(MapleMapObject mo) {
visibleMapObjects.remove(mo);
}
public void resetStats() {
List<Pair<MapleStat, Integer>> statup = new ArrayList<Pair<MapleStat, Integer>>(5);
int tap = 0, tsp = 1;
int tstr = 4, tdex = 4, tint = 4, tluk = 4;
int levelap = (isCygnus() ? 6 : 5);
switch (job.getId()) {
case 100:
case 1100:
case 2100://?
tstr = 35;
tap = ((getLevel() - 10) * levelap) + 14;
tsp += ((getLevel() - 10) * 3);
break;
case 200:
case 1200:
tint = 20;
tap = ((getLevel() - 10) * levelap) + 29;
tsp += ((getLevel() - 10) * 3);
break;
case 300:
case 1300:
case 400:
case 1400:
tdex = 25;
tap = ((getLevel() - 10) * levelap) + 24;
tsp += ((getLevel() - 10) * 3);
break;
case 500:
case 1500:
tdex = 20;
tap = ((getLevel() - 10) * levelap) + 29;
tsp += ((getLevel() - 10) * 3);
break;
}
this.remainingAp = tap;
this.remainingSp = tsp;
this.dex = tdex;
this.int_ = tint;
this.str = tstr;
this.luk = tluk;
statup.add(new Pair<MapleStat, Integer>(MapleStat.AVAILABLEAP, tap));
statup.add(new Pair<MapleStat, Integer>(MapleStat.AVAILABLESP, tsp));
statup.add(new Pair<MapleStat, Integer>(MapleStat.STR, tstr));
statup.add(new Pair<MapleStat, Integer>(MapleStat.DEX, tdex));
statup.add(new Pair<MapleStat, Integer>(MapleStat.INT, tint));
statup.add(new Pair<MapleStat, Integer>(MapleStat.LUK, tluk));
announce(MaplePacketCreator.updatePlayerStats(statup));
}
public void resetBattleshipHp() {
this.battleshipHp = 4000 * getSkillLevel(SkillFactory.getSkill(Corsair.BATTLE_SHIP)) + ((getLevel() - 120) * 2000);
}
public void resetEnteredScript() {
if (entered.containsKey(map.getId())) {
entered.remove(map.getId());
}
}
public void resetEnteredScript(int mapId) {
if (entered.containsKey(mapId)) {
entered.remove(mapId);
}
}
public void resetEnteredScript(String script) {
for (int mapId : entered.keySet()) {
if (entered.get(mapId).equals(script)) {
entered.remove(mapId);
}
}
}
public void resetMGC() {
this.mgc = null;
}
public void saveCooldowns() {
if (getAllCooldowns().size() > 0) {
try {
PreparedStatement ps = DatabaseConnection.getConnection().prepareStatement("INSERT INTO cooldowns (charid, SkillID, StartTime, length) VALUES (?, ?, ?, ?)");
ps.setInt(1, getId());
for (PlayerCoolDownValueHolder cooling : getAllCooldowns()) {
ps.setInt(2, cooling.skillId);
ps.setLong(3, cooling.startTime);
ps.setLong(4, cooling.length);
ps.addBatch();
}
ps.executeBatch();
ps.close();
} catch (SQLException se) {
}
}
}
public void saveGuildStatus() {
try {
PreparedStatement ps = DatabaseConnection.getConnection().prepareStatement("UPDATE characters SET guildid = ?, guildrank = ?, allianceRank = ? WHERE id = ?");
ps.setInt(1, guildid);
ps.setInt(2, guildrank);
ps.setInt(3, allianceRank);
ps.setInt(4, id);
ps.execute();
ps.close();
} catch (SQLException se) {
}
}
public void saveLocation(String type) {
MaplePortal closest = map.findClosestPortal(getPosition());
savedLocations[SavedLocationType.fromString(type).ordinal()] = new SavedLocation(getMapId(), closest != null ? closest.getId() : 0);
}
public void saveToDB(boolean update) {
Connection con = DatabaseConnection.getConnection();
try {
con.setTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITTED);
con.setAutoCommit(false);
PreparedStatement ps;
if (update) {
ps = con.prepareStatement("UPDATE characters SET level = ?, fame = ?, str = ?, dex = ?, luk = ?, `int` = ?, exp = ?, gachaexp = ?, hp = ?, mp = ?, maxhp = ?, maxmp = ?, sp = ?, ap = ?, gm = ?, skincolor = ?, gender = ?, job = ?, hair = ?, face = ?, map = ?, meso = ?, hpMpUsed = ?, spawnpoint = ?, party = ?, buddyCapacity = ?, messengerid = ?, messengerposition = ?, mountlevel = ?, mountexp = ?, mounttiredness= ?, equipslots = ?, useslots = ?, setupslots = ?, etcslots = ?, monsterbookcover = ?, vanquisherStage = ?, dojoPoints = ?, lastDojoStage = ?, finishedDojoTutorial = ?, vanquisherKills = ?, matchcardwins = ?, matchcardlosses = ?, matchcardties = ?, omokwins = ?, omoklosses = ?, omokties = ?, reborns = ?, votepoints = ? WHERE id = ?", Statement.RETURN_GENERATED_KEYS);
} else {
ps = con.prepareStatement("INSERT INTO characters (level, fame, str, dex, luk, `int`, exp, gachaexp, hp, mp, maxhp, maxmp, sp, ap, gm, skincolor, gender, job, hair, face, map, meso, hpMpUsed, spawnpoint, party, buddyCapacity, messengerid, messengerposition, mountlevel, mounttiredness, mountexp, equipslots, useslots, setupslots, etcslots, monsterbookcover, vanquisherStage, dojopoints, lastDojoStage, finishedDojoTutorial, vanquisherKills, matchcardwins, matchcardlosses, matchcardties, omokwins, omoklosses, omokties, reborns, votepoints, accountid, name, world) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", Statement.RETURN_GENERATED_KEYS);
}
if (gmLevel < 1 && level > 199) {
ps.setInt(1, isCygnus() ? 120 : 200);
} else {
ps.setInt(1, level);
}
ps.setInt(2, fame);
ps.setInt(3, str);
ps.setInt(4, dex);
ps.setInt(5, luk);
ps.setInt(6, int_);
ps.setInt(7, Math.abs(exp.get()));
ps.setInt(8, Math.abs(gachaexp.get()));
ps.setInt(9, hp);
ps.setInt(10, mp);
ps.setInt(11, maxhp);
ps.setInt(12, maxmp);
ps.setInt(13, remainingSp);
ps.setInt(14, remainingAp);
ps.setInt(15, gmLevel);
ps.setInt(16, skinColor.getId());
ps.setInt(17, gender);
ps.setInt(18, job.getId());
ps.setInt(19, hair);
ps.setInt(20, face);
if (map == null && getJob() == MapleJob.BEGINNER) {
ps.setInt(21, 0);
} else if (map == null && getJob() == MapleJob.NOBLESSE) {
ps.setInt(21, 130030000);
} else if (map == null && getJob() == MapleJob.LEGEND) {
ps.setInt(21, 914000000);
} else {
if (map.getForcedReturnId() != 999999999) {
ps.setInt(21, map.getForcedReturnId());
} else {
ps.setInt(21, map.getId());
}
}
ps.setInt(22, meso.get());
ps.setInt(23, hpMpApUsed);
if (map == null || map.getId() == 610020000 || map.getId() == 610020001) {
ps.setInt(24, 0);
} else {
MaplePortal closest = map.findClosestSpawnpoint(getPosition());
if (closest != null) {
ps.setInt(24, closest.getId());
} else {
ps.setInt(24, 0);
}
}
if (party != null) {
ps.setInt(25, party.getId());
} else {
ps.setInt(25, -1);
}
ps.setInt(26, buddylist.getCapacity());
if (messenger != null) {
ps.setInt(27, messenger.getId());
ps.setInt(28, messengerposition);
} else {
ps.setInt(27, 0);
ps.setInt(28, 4);
}
if (maplemount != null) {
ps.setInt(29, maplemount.getLevel());
ps.setInt(30, maplemount.getExp());
ps.setInt(31, maplemount.getTiredness());
} else {
ps.setInt(29, 1);
ps.setInt(30, 0);
ps.setInt(31, 0);
}
for (int i = 1; i < 5; i++)
ps.setInt(i + 31, getSlots(i));
if (update) {
monsterbook.saveCards(getId());
}
ps.setInt(36, bookCover);
ps.setInt(37, vanquisherStage);
ps.setInt(38, dojoPoints);
ps.setInt(39, dojoStage);
ps.setInt(40, finishedDojoTutorial ? 1 : 0);
ps.setInt(41, vanquisherKills);
ps.setInt(42, matchcardwins);
ps.setInt(43, matchcardlosses);
ps.setInt(44, matchcardties);
ps.setInt(45, omokwins);
ps.setInt(46, omoklosses);
ps.setInt(47, omokties);
ps.setInt(48, reborns);
ps.setInt(49, votepoints);
if (update) {
ps.setInt(50, id);
} else {
ps.setInt(50, accountid);
ps.setString(51, name);
ps.setInt(52, world);
}
int updateRows = ps.executeUpdate();
if (!update) {
ResultSet rs = ps.getGeneratedKeys();
if (rs.next()) {
this.id = rs.getInt(1);
} else {
throw new RuntimeException("Inserting char failed.");
}
} else if (updateRows < 1) {
throw new RuntimeException("Character not in database (" + id + ")");
}
for (int i = 0; i < 3; i++) {
if (pets[i] != null) {
pets[i].saveToDb();
}
}
deleteWhereCharacterId(con, "DELETE FROM keymap WHERE characterid = ?");
ps = con.prepareStatement("INSERT INTO keymap (characterid, `key`, `type`, `action`) VALUES (?, ?, ?, ?)");
ps.setInt(1, id);
for (Entry<Integer, MapleKeyBinding> keybinding : keymap.entrySet()) {
ps.setInt(2, keybinding.getKey().intValue());
ps.setInt(3, keybinding.getValue().getType());
ps.setInt(4, keybinding.getValue().getAction());
ps.addBatch();
}
ps.executeBatch();
deleteWhereCharacterId(con, "DELETE FROM skillmacros WHERE characterid = ?");
ps = con.prepareStatement("INSERT INTO skillmacros (characterid, skill1, skill2, skill3, name, shout, position) VALUES (?, ?, ?, ?, ?, ?, ?)");
ps.setInt(1, getId());
for (int i = 0; i < 5; i++) {
SkillMacro macro = skillMacros[i];
if (macro != null) {
ps.setInt(2, macro.getSkill1());
ps.setInt(3, macro.getSkill2());
ps.setInt(4, macro.getSkill3());
ps.setString(5, macro.getName());
ps.setInt(6, macro.getShout());
ps.setInt(7, i);
ps.addBatch();
}
}
ps.executeBatch();
List<Pair<IItem, MapleInventoryType>> itemsWithType = new ArrayList<Pair<IItem, MapleInventoryType>>();
for (MapleInventory iv : inventory) {
for (IItem item : iv.list()) {
itemsWithType.add(new Pair<IItem, MapleInventoryType>(item, iv.getType()));
}
}
ItemFactory.INVENTORY.saveItems(itemsWithType, id);
deleteWhereCharacterId(con, "DELETE FROM skills WHERE characterid = ?");
ps = con.prepareStatement("INSERT INTO skills (characterid, skillid, skilllevel, masterlevel, expiration) VALUES (?, ?, ?, ?, ?)");
ps.setInt(1, id);
for (Entry<ISkill, SkillEntry> skill : skills.entrySet()) {
ps.setInt(2, skill.getKey().getId());
ps.setInt(3, skill.getValue().skillevel);
ps.setInt(4, skill.getValue().masterlevel);
ps.setLong(5, skill.getValue().expiration);
ps.addBatch();
}
ps.executeBatch();
deleteWhereCharacterId(con, "DELETE FROM savedlocations WHERE characterid = ?");
ps = con.prepareStatement("INSERT INTO savedlocations (characterid, `locationtype`, `map`, `portal`) VALUES (?, ?, ?, ?)");
ps.setInt(1, id);
for (SavedLocationType savedLocationType : SavedLocationType.values()) {
if (savedLocations[savedLocationType.ordinal()] != null) {
ps.setString(2, savedLocationType.name());
ps.setInt(3, savedLocations[savedLocationType.ordinal()].getMapId());
ps.setInt(4, savedLocations[savedLocationType.ordinal()].getPortal());
ps.addBatch();
}
}
ps.executeBatch();
deleteWhereCharacterId(con, "DELETE FROM buddies WHERE characterid = ? AND pending = 0");
ps = con.prepareStatement("INSERT INTO buddies (characterid, `buddyid`, `pending`, `group`) VALUES (?, ?, 0, ?)");
ps.setInt(1, id);
for (BuddylistEntry entry : buddylist.getBuddies()) {
if (entry.isVisible()) {
ps.setInt(2, entry.getCharacterId());
ps.setString(3, entry.getGroup());
ps.addBatch();
}
}
ps.executeBatch();
deleteWhereCharacterId(con, "DELETE FROM queststatus WHERE characterid = ?");
ps = con.prepareStatement("INSERT INTO queststatus (`queststatusid`, `characterid`, `quest`, `status`, `time`, `forfeited`) VALUES (DEFAULT, ?, ?, ?, ?, ?)", Statement.RETURN_GENERATED_KEYS);
PreparedStatement pse = con.prepareStatement("INSERT INTO queststatusmobs VALUES (DEFAULT, ?, ?, ?)");
ps.setInt(1, id);
for (MapleQuestStatus q : quests.values()) {
ps.setInt(2, q.getQuest().getId());
ps.setInt(3, q.getStatus().getId());
ps.setInt(4, (int) (q.getCompletionTime() / 1000));
ps.setInt(5, q.getForfeited());
ps.executeUpdate();
ResultSet rs = ps.getGeneratedKeys();
rs.next();
for (int mob : q.getMobKills().keySet()) {
pse.setInt(1, rs.getInt(1));
pse.setInt(2, mob);
pse.setInt(3, q.getMobKills(mob));
pse.addBatch();
}
pse.executeBatch();
rs.close();
}
pse.close();
ps = con.prepareStatement("UPDATE accounts SET gm = ? WHERE id = ?");
ps.setInt(1, gmLevel);
ps.setInt(2, client.getAccID());
ps.executeUpdate();
if (cashshop != null) {
cashshop.save();
}
if (storage != null) {
storage.saveToDB();
}
if (gmLevel > 0) {
ps = con.prepareStatement("INSERT INTO gmlog (`cid`, `command`) VALUES (?, ?)");
ps.setInt(1, id);
for (String com : commands) {
ps.setString(2, com);
ps.addBatch();
}
ps.executeBatch();
}
ps.close();
con.commit();
} catch (Exception e) {
e.printStackTrace();
try {
con.rollback();
} catch (SQLException se) {
}
} finally {
try {
con.setAutoCommit(true);
con.setTransactionIsolation(Connection.TRANSACTION_REPEATABLE_READ);
} catch (Exception e) {
}
}
}
public void sendPolice(int greason, String reason, int duration) {
announce(MaplePacketCreator.sendPolice(greason, reason, duration));
this.isbanned = true;
TimerManager.getInstance().schedule(new Runnable() {
@Override
public void run() {
client.disconnect(); //FAGGOTS
}
}, duration);
}
public void sendPolice(String text) {
announce(MaplePacketCreator.sendPolice(text));
this.isbanned = true;
TimerManager.getInstance().schedule(new Runnable() {
@Override
public void run() {
client.disconnect(); //FAGGOTS
}
}, 6000);
}
public void sendKeymap() {
client.announce(MaplePacketCreator.getKeymap(keymap));
}
public void sendMacros() {
boolean macros = false;
for (int i = 0; i < 5; i++) {
if (skillMacros[i] != null) {
macros = true;
}
}
if (macros) {
client.announce(MaplePacketCreator.getMacros(skillMacros));
}
}
public void sendNote(String to, String msg) throws SQLException {
PreparedStatement ps = DatabaseConnection.getConnection().prepareStatement("INSERT INTO notes (`to`, `from`, `message`, `timestamp`) VALUES (?, ?, ?, ?)");
ps.setString(1, to);
ps.setString(2, this.getName());
ps.setString(3, msg);
ps.setLong(4, System.currentTimeMillis());
ps.executeUpdate();
ps.close();
}
public void setAllianceRank(int rank) {
allianceRank = rank;
if (mgc != null) {
mgc.setAllianceRank(rank);
}
}
public void setAllowWarpToId(int id) {
this.warpToId = id;
}
public static void setAriantRoomLeader(int room, String charname) {
ariantroomleader[room] = charname;
}
public static void setAriantSlotRoom(int room, int slot) {
ariantroomslot[room] = slot;
}
public void setBattleshipHp(int battleshipHp) {
this.battleshipHp = battleshipHp;
}
public void setBuddyCapacity(int capacity) {
buddylist.setCapacity(capacity);
client.announce(MaplePacketCreator.updateBuddyCapacity(capacity));
}
public void setBuffedValue(MapleBuffStat effect, int value) {
MapleBuffStatValueHolder mbsvh = effects.get(effect);
if (mbsvh == null) {
return;
}
mbsvh.value = value;
}
public void setChair(int chair) {
this.chair = chair;
}
public void setChalkboard(String text) {
this.chalktext = text;
}
public void setDex(int dex) {
this.dex = dex;
recalcLocalStats();
}
public void setDojoEnergy(int x) {
this.dojoEnergy = x;
}
public void setDojoParty(boolean b) {
this.dojoParty = b;
}
public void setDojoPoints(int x) {
this.dojoPoints = x;
}
public void setDojoStage(int x) {
this.dojoStage = x;
}
public void setDojoStart() {
this.dojoMap = map;
int stage = (map.getId() / 100) % 100;
this.dojoFinish = System.currentTimeMillis() + (stage > 36 ? 15 : stage / 6 + 5) * 60000;
}
public void setRates() {
Calendar cal = Calendar.getInstance();
cal.setTimeZone(TimeZone.getTimeZone("GMT+8"));
int time= new java.util.Date().getHours();
if (((time>=8)&&(time<9)) || ((time>=12)&&(time<13)) || ((time>=19)&&(time<20))){
this.expRate=client.getChannelServer().getExpRate() *2;
this.mesoRate=client.getChannelServer().getMesoRate() *2;
this.dropRate=client.getChannelServer().getDropRate() *2;
} else {
this.expRate=client.getChannelServer().getExpRate();
this.mesoRate=client.getChannelServer().getMesoRate();
this.dropRate=client.getChannelServer().getDropRate();
}
}
public void setEnergyBar(int set) {
energybar = set;
}
public void setEventInstance(EventInstanceManager eventInstance) {
this.eventInstance = eventInstance;
}
public void setExp(int amount) {
this.exp.set(amount);
}
public void setGachaExp(int amount) {
this.gachaexp.set(amount);
}
public void setFace(int face) {
this.face = face;
}
public void setFame(int fame) {
this.fame = fame;
}
public void setFamilyId(int familyId) {
this.familyId = familyId;
}
public void setFinishedDojoTutorial() {
this.finishedDojoTutorial = true;
}
public void setGender(int gender) {
this.gender = gender;
}
public void setGM(int level) {
this.gmLevel = level;
}
public void setGuildId(int _id) {
guildid = _id;
if (guildid > 0) {
if (mgc == null) {
mgc = new MapleGuildCharacter(this);
} else {
mgc.setGuildId(guildid);
}
} else {
mgc = null;
}
}
public void setGuildRank(int _rank) {
guildrank = _rank;
if (mgc != null) {
mgc.setGuildRank(_rank);
}
}
public void setHair(int hair) {
this.hair = hair;
}
public void setHasMerchant(boolean set) {
try {
PreparedStatement ps = DatabaseConnection.getConnection().prepareStatement("UPDATE characters SET HasMerchant = ? WHERE id = ?");
ps.setInt(1, set ? 1 : 0);
ps.setInt(2, id);
ps.executeUpdate();
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
hasMerchant = set;
}
public void setMerchantMeso(int set) {
try {
PreparedStatement ps = DatabaseConnection.getConnection().prepareStatement("UPDATE characters SET MerchantMesos = ? WHERE id = ?");
ps.setInt(1, set);
ps.setInt(2, id);
ps.executeUpdate();
ps.close();
} catch (SQLException e) {
return;
}
merchantmeso = set;
}
public void setHiredMerchant(HiredMerchant merchant) {
this.hiredMerchant = merchant;
}
public void setHp(int newhp) {
setHp(newhp, false);
}
public void setHp(int newhp, boolean silent) {
int oldHp = hp;
int thp = newhp;
if (thp < 0) {
thp = 0;
}
if (thp > localmaxhp) {
thp = localmaxhp;
}
this.hp = thp;
if (!silent) {
updatePartyMemberHP();
}
if (oldHp > hp && !isAlive()) {
playerDead();
}
}
public void setHpMpApUsed(int mpApUsed) {
this.hpMpApUsed = mpApUsed;
}
public void setHpMp(int x) {
setHp(x);
setMp(x);
updateSingleStat(MapleStat.HP, hp);
updateSingleStat(MapleStat.MP, mp);
}
public void setInt(int int_) {
this.int_ = int_;
recalcLocalStats();
}
public void setInventory(MapleInventoryType type, MapleInventory inv) {
inventory[type.ordinal()] = inv;
}
public void setItemEffect(int itemEffect) {
this.itemEffect = itemEffect;
}
public void setJob(MapleJob job) {
this.job = job;
}
public void setLastHealed(long time) {
this.lastHealed = time;
}
public void setLastUsedCashItem(long time) {
this.lastUsedCashItem = time;
}
public void setLevel(int level) {
this.level = level;
}
public void setLuk(int luk) {
this.luk = luk;
recalcLocalStats();
}
public void setMap(int PmapId) {
this.mapid = PmapId;
}
public void setMap(MapleMap newmap) {
this.map = newmap;
}
public String getMapName(int mapId) {
return client.getChannelServer().getMapFactory().getMap(mapId).getMapName();
}
public void setMarkedMonster(int markedMonster) {
this.markedMonster = markedMonster;
}
public void setMaxHp(int hp) {
this.maxhp = hp;
recalcLocalStats();
}
public void setMaxHp(int hp, boolean ap) {
hp = Math.min(30000, hp);
if (ap) {
setHpMpApUsed(getHpMpApUsed() + 1);
}
this.maxhp = hp;
recalcLocalStats();
}
public void setMaxMp(int mp) {
this.maxmp = mp;
recalcLocalStats();
}
public void setMaxMp(int mp, boolean ap) {
mp = Math.min(30000, mp);
if (ap) {
setHpMpApUsed(getHpMpApUsed() + 1);
}
this.maxmp = mp;
recalcLocalStats();
}
public void setMessenger(MapleMessenger messenger) {
this.messenger = messenger;
}
public void setMessengerPosition(int position) {
this.messengerposition = position;
}
public void setMiniGame(MapleMiniGame miniGame) {
this.miniGame = miniGame;
}
public void setMiniGamePoints(MapleCharacter visitor, int winnerslot, boolean omok) {
if (omok) {
if (winnerslot == 1) {
this.omokwins++;
visitor.omoklosses++;
} else if (winnerslot == 2) {
visitor.omokwins++;
this.omoklosses++;
} else {
this.omokties++;
visitor.omokties++;
}
} else {
if (winnerslot == 1) {
this.matchcardwins++;
visitor.matchcardlosses++;
} else if (winnerslot == 2) {
visitor.matchcardwins++;
this.matchcardlosses++;
} else {
this.matchcardties++;
visitor.matchcardties++;
}
}
}
public void setMonsterBookCover(int bookCover) {
this.bookCover = bookCover;
}
public void setMp(int newmp) {
int tmp = newmp;
if (tmp < 0) {
tmp = 0;
}
if (tmp > localmaxmp) {
tmp = localmaxmp;
}
this.mp = tmp;
}
public void setName(String name) {
this.name = name;
}
public void setParty(MapleParty party) {
this.party = party;
}
public void setPlayerShop(MaplePlayerShop playerShop) {
this.playerShop = playerShop;
}
public void setRemainingAp(int remainingAp) {
this.remainingAp = remainingAp;
}
public void setRemainingSp(int remainingSp) {
this.remainingSp = remainingSp;
}
public void setSearch(String find) {
search = find;
}
public void setSkinColor(MapleSkinColor skinColor) {
this.skinColor = skinColor;
}
public byte getSlots(int type) {
return type == MapleInventoryType.CASH.getType() ? 96 : inventory[type].getSlotLimit();
}
public boolean gainSlots(int type, int slots) {
return gainSlots(type, slots, true);
}
public boolean gainSlots(int type, int slots, boolean update) {
slots += inventory[type].getSlotLimit();
if (slots <= 96) {
inventory[type].setSlotLimit(slots);
saveToDB(true);
if (update) {
client.announce(MaplePacketCreator.updateInventorySlotLimit(type, slots));
}
return true;
}
return false;
}
public void setShop(MapleShop shop) {
this.shop = shop;
}
public void setSlot(int slotid) {
slots = slotid;
}
public void setStr(int str) {
this.str = str;
recalcLocalStats();
}
public void setTrade(MapleTrade trade) {
this.trade = trade;
}
public void setVanquisherKills(int x) {
this.vanquisherKills = x;
}
public void setVanquisherStage(int x) {
this.vanquisherStage = x;
}
public void setWorld(int world) {
this.world = world;
}
public void shiftPetsRight() {
if (pets[2] == null) {
pets[2] = pets[1];
pets[1] = pets[0];
pets[0] = null;
}
}
public void showDojoClock() {
int stage = (map.getId() / 100) % 100;
long time;
if (stage % 6 == 1) {
time = (stage > 36 ? 15 : stage / 6 + 5) * 60;
} else {
time = (dojoFinish - System.currentTimeMillis()) / 1000;
}
if (stage % 6 > 0) {
client.announce(MaplePacketCreator.getClock((int) time));
}
boolean rightmap = true;
int clockid = (dojoMap.getId() / 100) % 100;
if (map.getId() > clockid / 6 * 6 + 6 || map.getId() < clockid / 6 * 6) {
rightmap = false;
}
final boolean rightMap = rightmap; // lol
TimerManager.getInstance().schedule(new Runnable() {
@Override
public void run() {
if (rightMap) {
client.getPlayer().changeMap(client.getChannelServer().getMapFactory().getMap(925020000));
}
}
}, time * 1000 + 3000); // let the TIMES UP display for 3 seconds, then warp
}
public void showNote() {
try {
PreparedStatement ps = DatabaseConnection.getConnection().prepareStatement("SELECT * FROM notes WHERE `to`=?", ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
ps.setString(1, this.getName());
ResultSet rs = ps.executeQuery();
rs.last();
rs.first();
client.announce(MaplePacketCreator.showNotes(rs, rs.getRow()));
rs.close();
ps.close();
} catch (SQLException e) {
}
}
private void silentEnforceMaxHpMp() {
setMp(getMp());
setHp(getHp(), true);
}
public void silentGiveBuffs(List<PlayerBuffValueHolder> buffs) {
for (PlayerBuffValueHolder mbsvh : buffs) {
mbsvh.effect.silentApplyBuff(this, mbsvh.startTime);
}
}
public void silentPartyUpdate() {
if (party != null) {
try {
client.getChannelServer().getWorldInterface().updateParty(party.getId(), PartyOperation.SILENT_UPDATE, new MaplePartyCharacter(this));
} catch (RemoteException e) {
e.printStackTrace();
client.getChannelServer().reconnectWorld();
}
}
}
public static class SkillEntry {
public int skillevel, masterlevel;
public long expiration;
public SkillEntry(int skillevel, int masterlevel, long expiration) {
this.skillevel = skillevel;
this.masterlevel = masterlevel;
this.expiration = expiration;
}
public SkillEntry(int skillevel, int masterlevel) {
this.skillevel = skillevel;
this.masterlevel = masterlevel;
}
@Override
public String toString() {
return skillevel + ":" + masterlevel;
}
}
public boolean skillisCooling(int skillId) {
return coolDowns.containsKey(Integer.valueOf(skillId));
}
public void startFullnessSchedule(final int decrease, final MaplePet pet, int petSlot) {
ScheduledFuture<?> schedule = TimerManager.getInstance().register(new Runnable() {
@Override
public void run() {
int newFullness = pet.getFullness() - decrease;
if (newFullness <= 5) {
pet.setFullness(15);
pet.saveToDb();
unequipPet(pet, true);
} else {
pet.setFullness(newFullness);
client.announce(MaplePacketCreator.updatePet(pet));
}
}
}, 180000, 18000);
switch (petSlot) {
case 0:
fullnessSchedule = schedule;
break;
case 1:
fullnessSchedule_1 = schedule;
break;
case 2:
fullnessSchedule_2 = schedule;
break;
}
}
public void startMapEffect(String msg, int itemId) {
startMapEffect(msg, itemId, 30000);
}
public void startMapEffect(String msg, int itemId, int duration) {
final MapleMapEffect mapEffect = new MapleMapEffect(msg, itemId);
getClient().announce(mapEffect.makeStartData());
TimerManager.getInstance().schedule(new Runnable() {
@Override
public void run() {
getClient().announce(mapEffect.makeDestroyData());
}
}, duration);
}
public void startMapTimeLimitTask(final MapleMap from, final MapleMap to) {
if (to.getTimeLimit() > 0 && from != null) {
final MapleCharacter chr = this;
mapTimeLimitTask = TimerManager.getInstance().register(new Runnable() {
@Override
public void run() {
MaplePortal pfrom = null;
int id = from.getId();
if (id == 100020000 || id == 105040304 || id == 105050100 || id == 221023400) {
pfrom = from.getPortal("MD00");
} else {
pfrom = from.getPortal(0);
}
if (pfrom != null) {
chr.changeMap(from, pfrom);
}
}
}, from.getTimeLimit() * 1000, from.getTimeLimit() * 1000);
}
}
public void stopControllingMonster(MapleMonster monster) {
controlled.remove(monster);
}
public void toggleGMChat() {
whitechat = !whitechat;
}
public void broadcast(MaplePacket packet) {
client.announce(packet);
}
public void unequipAllPets() {
for (int i = 0; i < 3; i++) {
if (pets[i] != null) {
unequipPet(pets[i], true);
}
}
}
public void unequipPet(MaplePet pet, boolean shift_left) {
unequipPet(pet, shift_left, false);
}
public void unequipPet(MaplePet pet, boolean shift_left, boolean hunger) {
if (this.getPet(this.getPetIndex(pet)) != null) {
this.getPet(this.getPetIndex(pet)).setSummoned(false);
this.getPet(this.getPetIndex(pet)).saveToDb();
}
cancelFullnessSchedule(getPetIndex(pet));
getMap().broadcastMessage(this, MaplePacketCreator.showPet(this, pet, true, hunger), true);
List<Pair<MapleStat, Integer>> stats = new ArrayList<Pair<MapleStat, Integer>>();
stats.add(new Pair<MapleStat, Integer>(MapleStat.PET, Integer.valueOf(0)));
client.getSession().write(MaplePacketCreator.petStatUpdate(this));
client.getSession().write(MaplePacketCreator.enableActions());
removePet(pet, shift_left);
}
public void updateMacros(int position, SkillMacro updateMacro) {
skillMacros[position] = updateMacro;
}
public void updatePartyMemberHP() {
if (party != null) {
int channel = client.getChannel();
for (MaplePartyCharacter partychar : party.getMembers()) {
if (partychar.getMapid() == getMapId() && partychar.getChannel() == channel) {
MapleCharacter other = ChannelServer.getInstance(channel).getPlayerStorage().getCharacterByName(partychar.getName());
if (other != null) {
other.client.announce(MaplePacketCreator.updatePartyMemberHP(getId(), this.hp, localmaxhp));
}
}
}
}
}
public void updateQuest(MapleQuestStatus quest) {
quests.put(quest.getQuest(), quest);
if (quest.getStatus().equals(MapleQuestStatus.Status.STARTED)) {
announce(MaplePacketCreator.startQuest(this, (short) quest.getQuest().getId()));
announce(MaplePacketCreator.updateQuestInfo(this, (short) quest.getQuest().getId(), quest.getNpc(), (byte) 8));
} else if (quest.getStatus().equals(MapleQuestStatus.Status.COMPLETED)) {
announce(MaplePacketCreator.completeQuest(this, (short) quest.getQuest().getId()));
} else if (quest.getStatus().equals(MapleQuestStatus.Status.NOT_STARTED)) {
announce(MaplePacketCreator.forfeitQuest(this, (short) quest.getQuest().getId()));
}
}
public void updateSingleStat(MapleStat stat, int newval) {
updateSingleStat(stat, newval, false);
}
private void updateSingleStat(MapleStat stat, int newval, boolean itemReaction) {
announce(MaplePacketCreator.updatePlayerStats(Collections.singletonList(new Pair<MapleStat, Integer>(stat, Integer.valueOf(newval))), itemReaction));
}
public void announce(MaplePacket packet) {
client.announce(packet);
}
@Override
public int getObjectId() {
return getId();
}
public MapleMapObjectType getType() {
return MapleMapObjectType.PLAYER;
}
public void sendDestroyData(MapleClient client) {
client.announce(MaplePacketCreator.removePlayerFromMap(this.getObjectId()));
}
@Override
public void sendSpawnData(MapleClient client) {
if (!this.isHidden() || client.getPlayer().gmLevel() > 0) {
client.announce(MaplePacketCreator.spawnPlayerMapobject(this));
}
}
@Override
public void setObjectId(int id) {
return;
}
@Override
public String toString() {
return name;
}
private int givenRiceCakes;
private boolean gottenRiceHat;
public int getGivenRiceCakes() {
return givenRiceCakes;
}
public void increaseGivenRiceCakes(int amount) {
this.givenRiceCakes += amount;
}
public boolean getGottenRiceHat() {
return gottenRiceHat;
}
public void setGottenRiceHat(boolean b) {
this.gottenRiceHat = b;
}
public int getLinkedLevel() {
return linkedLevel;
}
public String getLinkedName() {
return linkedName;
}
public CashShop getCashShop() {
return cashshop;
}
public void portalDelay(long delay) {
this.portaldelay = System.currentTimeMillis() + delay;
}
public long portalDelay() {
return portaldelay;
}
public void blockPortal(String scriptName) {
if (!blockedPortals.contains(scriptName) && scriptName != null) {
blockedPortals.add(scriptName);
client.announce(MaplePacketCreator.enableActions());
}
}
public void unblockPortal(String scriptName) {
if (blockedPortals.contains(scriptName) && scriptName != null) {
blockedPortals.remove(scriptName);
}
}
public List<String> getBlockedPortals() {
return blockedPortals;
}
public boolean getAranIntroState(String mode) {
if (area_data.contains(mode)) {
return true;
}
return false;
}
public void addAreaData(int quest, String data) {
if (!this.area_data.contains(data)) {
this.area_data.add(data);
try {
Connection con = DatabaseConnection.getConnection();
PreparedStatement ps = con.prepareStatement("INSERT INTO char_area_info VALUES (DEFAULT, ?, ?, ?)");
ps.setInt(1, getId());
ps.setInt(2, quest);
ps.setString(3, data);
ps.executeUpdate();
ps.close();
} catch (SQLException ex) {
System.out.println("[AREA DATA] An error has occured.");
ex.printStackTrace();
}
}
}
public void removeAreaData() {
this.area_data.clear();
try {
Connection con = DatabaseConnection.getConnection();
PreparedStatement ps = con.prepareStatement("DELETE FROM char_area_info WHERE charid = ?");
ps.setInt(1, getId());
ps.executeUpdate();
ps.close();
} catch (SQLException ex) {
System.out.println("[AREA DATA] An error has occured.");
ex.printStackTrace();
}
}
public void autoban(String reason, int greason) {
Calendar cal = Calendar.getInstance();
cal.set(cal.get(Calendar.YEAR), cal.get(Calendar.MONTH) + 1, cal.get(Calendar.DATE), cal.get(Calendar.HOUR_OF_DAY), cal.get(Calendar.MINUTE));
Timestamp TS = new Timestamp(cal.getTimeInMillis());
try {
Connection con = DatabaseConnection.getConnection();
PreparedStatement ps = con.prepareStatement("UPDATE accounts SET banreason = ?, tempban = ?, greason = ? WHERE id = ?");
ps.setString(1, reason);
ps.setTimestamp(2, TS);
ps.setInt(3, greason);
ps.setInt(4, accountid);
ps.executeUpdate();
ps.close();
} catch (SQLException e) {
}
}
public boolean isBanned() {
return isbanned;
}
//EVENTS
private byte team = 0;
private MapleFitness fitness;
private MapleOla ola;
private long snowballattack;
public byte getTeam() {
return team;
}
public void setTeam(int team) {
this.team = (byte) team;
}
public MapleOla getOla() {
return ola;
}
public void setOla(MapleOla ola) {
this.ola = ola;
}
public MapleFitness getFitness() {
return fitness;
}
public void setFitness(MapleFitness fit) {
this.fitness = fit;
}
public long getLastSnowballAttack() {
return snowballattack;
}
public void setLastSnowballAttack(long time) {
this.snowballattack = time;
}
//Monster Carnival
private int cp = 0;
private int obtainedcp = 0;
private MonsterCarnivalParty carnivalparty;
private MonsterCarnival carnival;
public MonsterCarnivalParty getCarnivalParty() {
return carnivalparty;
}
public void setCarnivalParty(MonsterCarnivalParty party) {
this.carnivalparty = party;
}
public MonsterCarnival getCarnival() {
return carnival;
}
public void setCarnival(MonsterCarnival car) {
this.carnival = car;
}
public int getCP() {
return cp;
}
public int getObtainedCP() {
return obtainedcp;
}
public void addCP(int cp) {
this.cp += cp;
this.obtainedcp += cp;
}
public void useCP(int cp) {
this.cp -= cp;
}
public void setObtainedCP(int cp) {
this.obtainedcp = cp;
}
public int getAndRemoveCP() {
int rCP = 10;
if (cp < 9) {
rCP = cp;
cp = 0;
} else
cp -= 10;
return rCP;
}
public AutobanManager getAutobanManager() {
return autoban;
}
public void equipPendantOfSpirit() {
if (pendantOfSpirit == null) {
pendantOfSpirit = TimerManager.getInstance().register(new Runnable() {
@Override
public void run() {
if (pendantExp < 3) {
pendantExp++;
message("Pendant of the Spirit has been equipped for " + pendantExp + " hour(s), you will now receive " + pendantExp + "0% bonus exp.");
}
}
}, 3600000); //1 hour
}
}
public void unequipPendantOfSpirit() {
if (pendantOfSpirit != null) {
pendantOfSpirit.cancel(false);
pendantOfSpirit = null;
}
pendantExp = 0;
}
public void setReborns(int r) {
this.reborns = r;
}
public int getReborns() {
return reborns;
}
public void gainvotepoints(int gainedpoints) {
this.votepoints += gainedpoints;
}
public void doReborn() {
setReborns(getReborns() + 1);
List<Pair<MapleStat, Integer>> reborn = new ArrayList<Pair<MapleStat, Integer>>(4);
setLevel(1);
setExp(0);
setJob(MapleJob.BEGINNER);
updateSingleStat(MapleStat.LEVEL, 1);
updateSingleStat(MapleStat.JOB, 0);
updateSingleStat(MapleStat.EXP, 0);
}
public void changeChannel() {
expiretask.cancel(false);
cancelMagicDoor();
saveCooldowns();
if (getBuffedValue(MapleBuffStat.MONSTER_RIDING) != null) {
cancelEffectFromBuffStat(MapleBuffStat.MONSTER_RIDING);
}
if (getBuffedValue(MapleBuffStat.PUPPET) != null) {
cancelEffectFromBuffStat(MapleBuffStat.PUPPET);
}
if (getBuffedValue(MapleBuffStat.COMBO) != null) {
cancelEffectFromBuffStat(MapleBuffStat.COMBO);
}
getInventory(MapleInventoryType.EQUIPPED).checked(false); //test
saveToDB(true);
getMap().removePlayer(this);
getClient().getChannelServer().removePlayer(this);
getClient().updateLoginState(MapleClient.LOGIN_SERVER_TRANSITION);
}
}Thank you,
Pepsinotcoke.
Newbie Spellweaver
- Joined
- Jan 17, 2011
- Messages
- 16
- Reaction score
- 0
Genius
Yenpooh, this also worked for me, you should put this fix at the start of the thread
Yenpooh, this also worked for me, you should put this fix at the start of the thread
AltairCMS version4 notes: (29/1/2011)
Updates
How to setup voting page?
Download Link
Regards,
-AuroX
Updates
- Added New Registration Page with Captcha (Credits to CypeCMS for the generating of image)
- Fixed the part of the registration where you will get a "not aligned page" if you registered wrongly.
- New Voting Page: You won't get any errors to do with voting anymore. Just execute the new SQL. (6 hours per vote, Per IP)
- Cleaned up some codes.
How to setup voting page?
- First of all, open up vote.html and edit this word
Code:"Edit Me in vote.html" - Also, edit your voting site in Vote.html and Vote_do.php
- You will also have to edit your database settings in vote_do.php.
- Right now, it is integrated with 5kNX per vote. You can simply modify it for your own likings.
Download Link
You must be registered to see links
Regards,
-AuroX
Newbie Spellweaver
- Joined
- Nov 2, 2009
- Messages
- 13
- Reaction score
- 0
Thanks.
Newbie Spellweaver
- Joined
- Sep 14, 2008
- Messages
- 8
- Reaction score
- 0
Hey yenpooh. I need a little help. I setup the website successfully (MySQL databases, etc), but I cannot register successfully. When I hit the register button, the page refreshes with no content on the page except for the sidebar, header and footer stuff. Its just blank.
Please reply! Thanks!
--
Edit:
I found why the account creation wasn't going through. The name values that wanted to store on the mysql database tables.
! Quick fix.
Please reply! Thanks!
--
Edit:
I found why the account creation wasn't going through. The name values that wanted to store on the mysql database tables.
! Quick fix.
Last edited:
Junior Spellweaver
- Joined
- Nov 23, 2010
- Messages
- 173
- Reaction score
- 9
AuroX can you make this ranking with http://forum.ragezone.com/f427/release-darkmagics-ranking-system-v-438086/
cause that ranking have a avatar character
cause that ranking have a avatar character
Newbie Spellweaver
- Joined
- Dec 1, 2010
- Messages
- 28
- Reaction score
- 8
Awesome bud
Apart from the few errors it gave me (Which are logical to fix)
Im using it ATM
Apart from the few errors it gave me (Which are logical to fix)
Im using it ATM
- Joined
- Sep 19, 2010
- Messages
- 3
- Reaction score
- 0
Whenever a player logins to the CMS they can't go to the control panel it just takes them back to the login box.
Help please? Thank you.
Help please? Thank you.
Newbie Spellweaver
- Joined
- Mar 20, 2011
- Messages
- 42
- Reaction score
- 14
I need some help... I just got done putting this in my folder, renaming it but I have one problem. When I go to the website, it loads without a template and I get this error:
Fatal error: Cannot redeclare sql_sanitize() (previously declared in C:\wamp\www\config\afuncs.php:386) in C:\wamp\www\styles\cype\sources\login\function.php on line 14
Help?
Fatal error: Cannot redeclare sql_sanitize() (previously declared in C:\wamp\www\config\afuncs.php:386) in C:\wamp\www\styles\cype\sources\login\function.php on line 14
Help?
Initiate Mage
- Joined
- Sep 15, 2009
- Messages
- 3
- Reaction score
- 0
noob question
how do you get into the admin control panel to add news and events?
i did the webadmin in the sql and set it to 1
but it wont pop up still
how do you get into the admin control panel to add news and events?
i did the webadmin in the sql and set it to 1
but it wont pop up still
- Joined
- Mar 1, 2010
- Messages
- 20
- Reaction score
- 1
Hi, I like this CMS the only problem i am haveing is this when i try to create a account, Can you help since its your Creation
I have Inserted the 2 SQL Scripts "altair.sql" & "vote.sql"
And i have set up the Config correctly im sure of it.
:?:
I have Inserted the 2 SQL Scripts "altair.sql" & "vote.sql"
And i have set up the Config correctly im sure of it.
Code:
Fatal error: Failed to execute MySQL Query - Unknown column 'ip' in 'field list'
Query: INSERT INTO accounts (`name`, `password`, `ip`, `email`, `birthday`) VALUES ('danny', '7c4a8d09ca3762af61e59520943dc26494f8941b', '/', 'dacloudster@hotmail.co.uk', '2010-01-01') in C:\wamp\www\config\core_class.php on line 37
Call Stack
# Time Memory Function Location
1 0.0009 387784 {main}( ) ..\index.php:0
2 0.0420 484064 include_once( 'C:\wamp\www\pages\register.php' ) ..\index.php:69
3 0.0536 520312 Database->query( ) ..\register.php:84
4 0.0539 520576 trigger_error ( ) ..\core_class.php:37
- Joined
- May 19, 2007
- Messages
- 440
- Reaction score
- 78
Nice job and thank you. My server needs this.
I had problem with Captcha, but i marked it as un-needed (in our server) well i share 'pages/register.php' of mine for all of you guys (who have) problem with register.php
Have a nice day
I had problem with Captcha, but i marked it as un-needed (in our server) well i share 'pages/register.php' of mine for all of you guys (who have) problem with register.php
Have a nice day
PHP:
<?php include('config/config.php'); ?>
<div id="main">
<div class="sidebartop">Downloads</div>
<div class="sidebarbox">
<center>
<table width="600" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center" bgcolor="#FFFFFF"><form id="form1" name="form1" method="post" action="">
<table width="400" border="0" cellpadding="1" cellspacing="1">
<tr>
<td width="200" align="right">Username: </td>
<td width="200" align="left"><label for="username2"></label>
<input type="text" name="username" id="username2" /></td>
</tr>
<tr>
<td align="right">Password: </td>
<td align="left"><label for="password"></label>
<input type="password" name="password" id="password" /></td>
</tr>
<tr>
<td align="right">Re-type Password: </td>
<td align="left"><input type="password" name="password2" id="password2" /></td>
</tr>
<tr>
<td align="right">Birthday:</td>
<td align="left"><label for="birthday"></label>
<input name="birthday" type="text" id="birthday" value="YYYY-MM-DD" /></td>
</tr>
<tr>
<td align="right"> </td>
<td align="left"><input type="submit" value="Register" /></td>
</tr>
</table>
<p>
<?php
mysql_connect($host['hostname'], $host['user'], $host['password']);
mysql_select_db($host['database']);
$Check = mysql_query("SELECT * FROM accounts WHERE name='$_POST[username]'");
if($_POST['username'] == "") {
echo 'Every field is required.';
}
else if ($_POST['password'] == "") {
echo 'Every field is required.';
}
else if ($_POST['password2'] == "") {
echo 'Every field is required.';
}
else if ($_POST['birthday'] == "") {
echo 'Every field is required.';
}
else if (mysql_affected_rows() == 1) {
echo 'Username is already exist!';
} else {
if($_POST['password'] !== $_POST['password2']) {
echo 'Passwords does not match.';
}
else
{
$ShaPass = sha1($_POST['password']);
mysql_query("INSERT INTO accounts (name, password, birthday) VALUES ('$_POST[username]', '$ShaPass', '$_POST[birthday]')");
echo 'Account created!';
}
}
?>
</p>
</form></td>
</tr>
</table>
</div>
</div>http://forum.ragezone.com/f566/altaircms-issue-743901/
can someone help me? :/
can someone help me? :/
Newbie Spellweaver
- Joined
- Feb 11, 2011
- Messages
- 74
- Reaction score
- 16
I continue to just get errors. and errors AND ERRORS LOL.
I Fixed everything BUT voting -_- any Help Guys.
I think its.... WELL IDK WHAT IT IS. Advice? LOL
Heres My Config. Vote. and Vote_do
Vote_do.php
Vote.php
Config.php
I Fixed everything BUT voting -_- any Help Guys.
I think its.... WELL IDK WHAT IT IS. Advice? LOL
Heres My Config. Vote. and Vote_do
Vote_do.php
PHP:
<?php
$database = 'MoopleDev;
$table = 'accounts';
$mysql = mysql_connect('localhost', 'root', 'john123');
$usr = mysql_real_escape_string($_GET['a']);
$pwd = hash('sha1', $_GET['b']);
$ipaddr = $_SERVER['REMOTE_ADDR'];
if ($_GET['k'] == 'true') { } // Check if "click here" was clicked
$nan = $_GET['c'];
$non = $_GET['d'];
if ($non != 'false') { die('Error: Please Try Again.'); }
if ($nan != 'Vote!') { die('Error: Please Try Again.'); }
$get_account_id = mysql_query("SELECT `id` FROM `$database`.`$table` WHERE `name` = '$usr' AND `password` = '$pwd' AND `loggedin` = '0';") or die(mysql_error());
$id_result = mysql_fetch_array($get_account_id, MYSQL_ASSOC);
$accid = $id_result['id'];
if ($accid == '') { die('Logged in or Invalid information.'); }
$voted_check = "";
$get_last_vote = mysql_query("SELECT `lastvote` FROM `$database`.`ipvotes` WHERE `accid` = '$accid';") or die(mysql_error());
while ($row = mysql_fetch_array($get_last_vote, MYSQL_ASSOC)) {
if (time() - $row['lastvote'] <= 21600) {
die('You have already voted. Please wait <span id="tu">'.floor((21600 - (time() - $row['lastvote'])) / 60).'</span> minutes to vote.');
}
}
$get_last_ip_vote = mysql_query("SELECT `lastvote` FROM `$database`.`ipvotes` WHERE `ip` = '$ipaddr';") or die(mysql_error());
while ($row2 = mysql_fetch_array($get_last_ip_vote, MYSQL_ASSOC)) {
if (time() - $row2['lastvote'] <= 21600) {
die('You have already voted. Please wait <span id="tu">'.floor((21600 - (time() - $row2['lastvote'])) / 60).'</span> minutes to vote.');
}
}
if ($voted_check == '') {
mysql_query("UPDATE `$database`.`$table` SET `cardNX` = `cardNX`+15000 WHERE `id` = $accid") or die(mysql_error());
$set_last_vote = mysql_query("INSERT INTO `$database`.`ipvotes` (`ip`,`accid`,`lastvote`) VALUES ('$ipaddr','$accid','".time()."')") or die(mysql_error());
die('Please <a href="http:http://www.gtop100.com/in.php?site=56659">click here</a> to vote!');
}
?>Vote.php
PHP:
br />
<div id="main">
<center>
<div class="sidebartop">Vote for NX!</div>
<div class="sidebarbox">
<table cellspacing="1" cellpadding="5">
<iframe src="vote.html" style="height: 420px; width: 580px;" scrolling="no" allowtransparency="true" frameborder="0"></iframe>
</table>
</div>
</center>
</div>
<br />Config.php
PHP:
<?php
$host['hostname'] = 'LocalHost'; // Host name [DEFAULT:Localhost]
$host['user'] = 'root'; // DB Username
$host['password'] = 'john123'; // DB Password
$host['database'] = 'MoopleDev'; // DB Name
$webtitle = 'EverythingMs'; // Website Title
$rate['exp'] = '300x'; // Exp Rate
$rate['meso'] = '250x'; // Meso Rate
$rate['drop'] = '5x'; // Drop Rate
$servername = 'EverythingMs'; // Server Name
$version = '83'; // Version
$serverip = "199.71.213.198"; // Replace with your WAN IP if public
$loginport = "8484"; // LoginPort [DEFAULT: 8484]
//Features (You can put pictures here too)
$features = "
<li>Multi-World Support!</li>
<li>Full Cash Shop</li>
<li>Hired Merchants!</li>
<li>OX Quiz</li>
<li>PVP</li>";
//banner/logo/images
$logo = "images/logo.png"; // (800x150)
$vote = "0"; // vote pop-up. 1 = yes/0 = no
//Links
$forum = "http://forum.ragezone.com/f427"; // Your Forum link
$client = "http://www.mediafire.com/?8564l2othq92xfo"; // Client download link
$gms = "http://download3.nexon.net/maplestory/fullversion/MSSetupv83.exe"; // Full Maplestory setup download link
$votelink = "http://www.gtop100.com/in.php?site=56659&cookie_test=true";
//Scrolling text
$scrollingtext = "Welcome To EverythingMs!";
$sidebartitle = "Amber Likes Her players ";
$sidebar = "May Everything be with you ";
$offline = "<img src=images/offline.png>"; // online message
$online = "<img src=images/online.png>"; // offline message
// Opens connection to mysql server [DO NOT TOUCH THIS]
mysql_connect($host['hostname'],$host['user'],$host['password']) OR die("Can't connect to server");
mysql_select_db($host['database']) OR die("Cannot select DB");
if(basename($_SERVER["PHP_SELF"]) == "config.php"){
die("Error!");
}
?>- Status
RaGEZONE Sponsor
