public static void showInventory(Player player, String group, int page) {
// Show inventory
final GroupPageInfo info = new GroupPageInfo(group, page);
Inventory inventory = null;
if (inventories.containsKey(info)) {
if (RootConfig.getBoolean(ConfigNode.DEBUG_INVENTORY)) {
plugin.getLogger().info("inventory already open");
}
// Grab already open inventory
inventory = inventories.get(info).getInventory();
} else {
if (RootConfig.getBoolean(ConfigNode.DEBUG_INVENTORY)) {
plugin.getLogger().info("inventory first open");
}
final KSInventoryHolder holder = new KSInventoryHolder(info);
inventory = plugin.getServer().createInventory(holder, chestSize, group + " : " + page);
populateInventory(inventory, page, group);
holder.setInventory(inventory);
inventories.put(info, holder);
}
// Set task
final int id =
plugin
.getServer()
.getScheduler()
.scheduleSyncDelayedTask(plugin, new ShowKSInventoryTask(plugin, player, inventory), 3);
if (id == -1) {
if (RootConfig.getBoolean(ConfigNode.DEBUG_INVENTORY)) {
plugin.getLogger().warning("Could not schedule open inventory for " + player.getName());
}
player.sendMessage(ChatColor.RED + KarmicShare.TAG + " Could not schedule open inventory!");
}
}
public static int getGroupId(String group) {
int id = -1;
try {
final Query query =
plugin
.getDatabaseHandler()
.select(
"SELECT * FROM " + Table.GROUPS.getName() + " WHERE groupname='" + group + "';");
if (query.getResult().next()) {
id = query.getResult().getInt("id");
if (query.getResult().wasNull()) {
id = -1;
}
}
query.closeQuery();
} catch (SQLException e) {
if (RootConfig.getBoolean(ConfigNode.DEBUG_KARMA)) {
plugin.getLogger().warning("SQLException on getGroupId(" + group + ")");
}
plugin.getLogger().warning("SQL Exception on getting group '" + group + "' id");
e.printStackTrace();
}
if (RootConfig.getBoolean(ConfigNode.DEBUG_KARMA)) {
plugin.getLogger().info("getGroupId(" + group + ") == " + id);
}
return id;
}
public static String getGroupName(int id) {
String group = "NONE";
try {
final Query query =
plugin
.getDatabaseHandler()
.select("SELECT * FROM " + Table.GROUPS.getName() + " WHERE id='" + id + "';");
if (query.getResult().next()) {
group = query.getResult().getString("groupname");
if (query.getResult().wasNull()) {
group = "NONE";
}
}
query.closeQuery();
} catch (SQLException e) {
if (RootConfig.getBoolean(ConfigNode.DEBUG_KARMA)) {
plugin.getLogger().warning("SQL Exception on getting group name for id '" + id + "'");
}
e.printStackTrace();
}
if (RootConfig.getBoolean(ConfigNode.DEBUG_KARMA)) {
plugin.getLogger().info("getGroupName(" + id + ") == " + group);
}
return group;
}
/**
* Retrieves karma value of a player from the database. Forces player to be added to database if
* they don't exist
*
* @param Player name
* @return karma value associated with name
*/
public static int getPlayerKarma(String name) throws SQLException {
int karma = RootConfig.getInt(ConfigNode.KARMA_PLAYER_DEFAULT);
if (RootConfig.getBoolean(ConfigNode.KARMA_ECONOMY)) {
double balance = plugin.getEconomy().getBalance(name);
karma = (int) balance;
} else {
boolean has = false;
String query =
"SELECT * FROM " + Table.PLAYERS.getName() + " WHERE playername='" + name + "';";
final Query rs = plugin.getDatabaseHandler().select(query);
// Retrieve karma from database
try {
if (rs.getResult().next()) {
do {
// Grab player karma value
karma = rs.getResult().getInt("karma");
has = true;
} while (rs.getResult().next());
}
rs.closeQuery();
if (!has) {
if (RootConfig.getBoolean(ConfigNode.DEBUG_KARMA)) {
plugin.getLogger().info("getPlayerKarma(" + name + ") not in database, adding");
}
// Player not in database, therefore add them
query =
"INSERT INTO "
+ Table.PLAYERS.getName()
+ " (playername,karma) VALUES ('"
+ name
+ "','"
+ karma
+ "');";
plugin.getDatabaseHandler().standardQuery(query);
}
} catch (SQLException e) {
if (RootConfig.getBoolean(ConfigNode.DEBUG_KARMA)) {
plugin.getLogger().warning("SQLException on getPlayerKarma(" + name + ")");
}
throw e;
}
}
return karma;
}
public static void cycleGroup(Player player, String current, Direction direction) {
String nextGroup = current;
final List<String> list = Karma.getPlayerGroups(player, player.getName());
int index = list.indexOf(current);
switch (direction) {
case FORWARD:
{
if (index + 1 >= list.size()) {
nextGroup = list.get(0);
} else {
nextGroup = list.get(index + 1);
}
break;
}
case BACKWARD:
{
if (index - 1 < 0) {
nextGroup = list.get(list.size() - 1);
} else {
nextGroup = list.get(index - 1);
}
break;
}
default:
{
// Ignore
break;
}
}
Karma.selectedGroup.put(player.getName(), nextGroup);
player.sendMessage(
ChatColor.GREEN
+ KarmicShare.TAG
+ " Changed group to '"
+ ChatColor.GOLD
+ nextGroup
+ ChatColor.GREEN
+ "'");
if (RootConfig.getBoolean(ConfigNode.DEBUG_INVENTORY)) {
plugin
.getLogger()
.info(
"cycleGroup("
+ player.getName()
+ ","
+ current
+ ","
+ direction.toString()
+ ") : "
+ nextGroup);
}
}
public static boolean validGroup(CommandSender sender, String group) {
if (group.equals("global")) {
if (RootConfig.getBoolean(ConfigNode.DEBUG_KARMA)) {
plugin.getLogger().info("global group valid for " + sender.getName());
}
return true;
} else if (group.equals("self_" + sender.getName().toLowerCase())) {
if (RootConfig.getBoolean(ConfigNode.DEBUG_KARMA)) {
plugin.getLogger().info("self group valid for " + sender.getName());
}
return true;
}
boolean valid = false;
try {
final Query rs =
plugin
.getDatabaseHandler()
.select(
"SELECT * FROM " + Table.GROUPS.getName() + " WHERE groupname='" + group + "';");
if (rs.getResult().next()) {
if (RootConfig.getBoolean(ConfigNode.DEBUG_KARMA)) {
plugin.getLogger().info(group + " group valid for " + sender.getName());
}
valid = true;
}
rs.closeQuery();
} catch (SQLException e) {
if (RootConfig.getBoolean(ConfigNode.DEBUG_KARMA)) {
plugin
.getLogger()
.warning("SQLException on validGroup(" + sender.getName() + "," + group + ")");
}
sender.sendMessage(ChatColor.RED + KarmicShare.TAG + " SQL Exception");
e.printStackTrace();
}
return valid;
}
/**
* Updates the player's karma
*
* @param Name of player
* @param Amount of karma to add
* @param Boolean if to add to current karma, or to set it as given value
* @throws SQLException
*/
public static void updatePlayerKarma(String name, int k) throws SQLException {
if (RootConfig.getBoolean(ConfigNode.KARMA_ECONOMY)) {
EconomyResponse response = null;
if (k < 0) {
// negative, take away
response = plugin.getEconomy().withdrawPlayer(name, (k * -1));
} else {
// give
response = plugin.getEconomy().depositPlayer(name, k);
}
if (response == null) {
return;
}
switch (response.type) {
case FAILURE:
{
try {
plugin
.getServer()
.getPlayer(name)
.sendMessage(ChatColor.RED + KarmicShare.TAG + " Failed economy transaction!");
} catch (NullPointerException npe) {
// IGNORE
}
if (RootConfig.getBoolean(ConfigNode.DEBUG_ECONOMY)) {
plugin
.getLogger()
.warning(
"Failed economy transaction on updatePlayerKarma("
+ name
+ ", "
+ k
+ ") : "
+ response.errorMessage);
}
break;
}
case NOT_IMPLEMENTED:
{
try {
plugin
.getServer()
.getPlayer(name)
.sendMessage(ChatColor.RED + KarmicShare.TAG + " Failed economy transaction!");
} catch (NullPointerException npe) {
// IGNORE
}
if (RootConfig.getBoolean(ConfigNode.DEBUG_ECONOMY)) {
plugin
.getLogger()
.warning(
"Unimplemented economy transaction on updatePlayerKarma("
+ name
+ ", "
+ k
+ ") for eco "
+ plugin.getEconomy().getName()
+ " : "
+ response.errorMessage);
}
break;
}
case SUCCESS:
{
if (RootConfig.getBoolean(ConfigNode.DEBUG_ECONOMY)) {
plugin
.getLogger()
.info(
"Successful economy transaction on updatePlayerKarma("
+ name
+ ", "
+ k
+ ")");
}
break;
}
default:
{
if (RootConfig.getBoolean(ConfigNode.DEBUG_ECONOMY)) {
plugin.getLogger().warning("Unknown response type:" + response.type.toString());
}
break;
}
}
} else {
try {
// Retrieve karma from database
int karma = getPlayerKarma(name);
// Add to existing value
karma += k;
String query;
// Check updated karma value to limits in config
if (karma <= RootConfig.getInt(ConfigNode.KARMA_LOWER_LIMIT)) {
// Updated karma value is beyond lower limit, so set to min
query =
"UPDATE "
+ Table.PLAYERS.getName()
+ " SET karma='"
+ RootConfig.getInt(ConfigNode.KARMA_LOWER_LIMIT)
+ "' WHERE playername='"
+ name
+ "';";
} else if (karma >= RootConfig.getInt(ConfigNode.KARMA_UPPER_LIMIT)) {
// Updated karma value is beyond upper limit, so set to max
query =
"UPDATE "
+ Table.PLAYERS.getName()
+ " SET karma='"
+ RootConfig.getInt(ConfigNode.KARMA_UPPER_LIMIT)
+ "' WHERE playername='"
+ name
+ "';";
} else {
// Updated karma value is within acceptable range
query =
"UPDATE "
+ Table.PLAYERS.getName()
+ " SET karma='"
+ karma
+ "' WHERE playername='"
+ name
+ "';";
}
plugin.getDatabaseHandler().standardQuery(query);
} catch (SQLException e) {
if (RootConfig.getBoolean(ConfigNode.DEBUG_KARMA)) {
plugin.getLogger().warning("SQLException on updatePlayerKarma(" + name + "," + k + ")");
}
throw e;
}
}
}
private static void populateInventory(Inventory inventory, int page, String group) {
try {
int count = 0;
int start = (page - 1) * chestSize;
int groupId = Karma.getGroupId(group);
if (groupId == -1) {
if (RootConfig.getBoolean(ConfigNode.DEBUG_INVENTORY)) {
plugin.getLogger().warning("Tried to populateInventory for invalid group: " + group);
}
return;
}
Query itemList =
plugin
.getDatabaseHandler()
.select(
"SELECT * FROM " + Table.ITEMS.getName() + " WHERE groups='" + groupId + "';");
if (itemList.getResult().next()) {
boolean done = false;
do {
// Generate item
int id = itemList.getResult().getInt("itemid");
int amount = itemList.getResult().getInt("amount");
byte data = itemList.getResult().getByte("data");
short dur = itemList.getResult().getShort("durability");
ItemStack item = null;
if (Item.isTool(id)) {
item = new ItemStack(id, amount, dur);
} else {
item = new ItemStack(id, amount, dur, data);
}
// Generate psudo item to calculate slots taken up
int maxStack = item.getType().getMaxStackSize();
if (maxStack <= 0) {
maxStack = 1;
}
int stacks = amount / maxStack;
final double rem = (double) amount % (double) maxStack;
if (rem != 0) {
stacks++;
}
for (int x = 0; x < stacks; x++) {
ItemStack add = item.clone();
if (amount < maxStack) {
add.setAmount(amount);
} else {
add.setAmount(maxStack);
amount -= maxStack;
}
if (count >= start) {
Item meta = new Item(id, data, dur);
try {
// If tool
if (meta.isTool()) {
// Check for enchantments
String enchantments = itemList.getResult().getString("enchantments");
if (!itemList.getResult().wasNull()) {
if (!enchantments.equals("")) {
String[] cut = enchantments.split("i");
for (int s = 0; s < cut.length; s++) {
String[] cutter = cut[s].split("v");
EnchantmentWrapper e = new EnchantmentWrapper(Integer.parseInt(cutter[0]));
add.addUnsafeEnchantment(e.getEnchantment(), Integer.parseInt(cutter[1]));
}
}
}
final HashMap<Integer, ItemStack> residual = inventory.addItem(add);
if (!residual.isEmpty()) {
done = true;
}
} else if (meta.isPotion()) {
// Remove data for full potion compatibility
item = new ItemStack(id, amount, dur);
final HashMap<Integer, ItemStack> residual = inventory.addItem(add);
if (!residual.isEmpty()) {
done = true;
}
} else {
final HashMap<Integer, ItemStack> residual = inventory.addItem(add);
if (!residual.isEmpty()) {
done = true;
}
}
} catch (NumberFormatException e) {
// Ignore faulty item
}
}
count++;
}
} while (itemList.getResult().next() && !done);
} else {
// No items to add.
inventory.clear();
}
// Close select
itemList.closeQuery();
} catch (SQLException e) {
if (RootConfig.getBoolean(ConfigNode.DEBUG_INVENTORY)) {
plugin
.getLogger()
.warning(
"SQLException on populateInventory("
+ inventory.getName()
+ ","
+ page
+ ","
+ group
+ ")");
}
e.printStackTrace();
}
}
public static boolean addPlayerToGroup(CommandSender sender, String name, String group) {
try {
// Ensure that the player's default groups get added in
getPlayerGroups(sender, name);
int groupId = Karma.getGroupId(group);
if (groupId == -1) {
if (RootConfig.getBoolean(ConfigNode.DEBUG_KARMA)) {
plugin.getLogger().info("Invalid group " + group + " for addPlayerToGroup");
}
sender.sendMessage(
ChatColor.RED
+ KarmicShare.TAG
+ " Invalid group '"
+ ChatColor.GRAY
+ group
+ ChatColor.RED
+ "'");
return false;
}
final int selfGroup = Karma.getGroupId("self_" + name);
final int global = Karma.getGroupId("global");
// plugin.getLogger().info("self: " + selfGroup);
// plugin.getLogger().info("global: " + global);
// Insures that the player is added to the database
getPlayerKarma(name);
String groups = "";
Query rs =
plugin
.getDatabaseHandler()
.select(
"SELECT * FROM " + Table.PLAYERS.getName() + " WHERE playername='" + name + "';");
if (rs.getResult().next()) {
groups = rs.getResult().getString("groups");
if (!rs.getResult().wasNull()) {
groups += "&" + groupId;
} else {
// Clear
groups = "";
// plugin.getLogger().info("null groups");
if (global != -1) {
// plugin.getLogger().info("added global");
groups += global + "&";
}
if (selfGroup != -1) {
// plugin.getLogger().info("added self");
groups += selfGroup + "&";
}
groups += "" + groupId;
}
}
rs.closeQuery();
// Update their groups
// plugin.getLogger().info("groups: " + groups);
plugin
.getDatabaseHandler()
.standardQuery(
"UPDATE "
+ Table.PLAYERS.getName()
+ " SET groups='"
+ groups
+ "' WHERE playername='"
+ name
+ "';");
} catch (SQLException e) {
if (RootConfig.getBoolean(ConfigNode.DEBUG_KARMA)) {
plugin
.getLogger()
.warning(
"SQLException on addPlayerToGroup("
+ sender.getName()
+ ","
+ name
+ ","
+ group
+ ")");
}
sender.sendMessage(ChatColor.RED + KarmicShare.TAG + " SQL Exception");
e.printStackTrace();
return false;
}
if (RootConfig.getBoolean(ConfigNode.DEBUG_KARMA)) {
plugin
.getLogger()
.info("addPlayerToGroup(" + sender.getName() + "," + name + "," + group + ")");
}
return true;
}
public static boolean removePlayerFromGroup(CommandSender sender, String name, String group) {
try {
int groupId = Karma.getGroupId(group);
if (groupId == -1) {
sender.sendMessage(
ChatColor.RED
+ KarmicShare.TAG
+ " Invalid group '"
+ ChatColor.GRAY
+ group
+ ChatColor.RED
+ "'");
return false;
}
String groups = "";
Query rs =
plugin
.getDatabaseHandler()
.select(
"SELECT * FROM " + Table.PLAYERS.getName() + " WHERE playername='" + name + "';");
if (rs.getResult().next()) {
groups = rs.getResult().getString("groups");
if (!rs.getResult().wasNull()) {
if (groups.contains("&")) {
// Multigroup
final StringBuilder sb = new StringBuilder();
for (String s : groups.split("&")) {
try {
int id = Integer.parseInt(s);
// plugin.getLogger().info(s);
// Add back all groups excluding specified group
if (id != groupId) {
sb.append(s + "&");
}
} catch (NumberFormatException n) {
}
}
// Remove trailing ampersand
sb.deleteCharAt(sb.length() - 1);
groups = sb.toString();
} else {
groups = "";
}
}
}
rs.closeQuery();
// Update their groups
plugin
.getDatabaseHandler()
.standardQuery(
"UPDATE "
+ Table.PLAYERS.getName()
+ " SET groups='"
+ groups
+ "' WHERE playername='"
+ name
+ "';");
} catch (SQLException e) {
if (RootConfig.getBoolean(ConfigNode.DEBUG_KARMA)) {
plugin
.getLogger()
.warning(
"SQLException on removePlayerFromGroup("
+ sender.getName()
+ ","
+ name
+ ","
+ group
+ ")");
}
sender.sendMessage(ChatColor.RED + KarmicShare.TAG + " SQL Exception");
e.printStackTrace();
return false;
}
if (RootConfig.getBoolean(ConfigNode.DEBUG_KARMA)) {
plugin
.getLogger()
.info("removePlayerFromGroup(" + sender.getName() + "," + name + "," + group + ")");
}
return true;
}
public static List<String> getPlayerGroups(CommandSender sender, String name) {
List<String> list = new ArrayList<String>();
boolean wasNull = false, initial = false;
try {
String groups = "";
Query rs =
plugin
.getDatabaseHandler()
.select(
"SELECT * FROM " + Table.PLAYERS.getName() + " WHERE playername='" + name + "';");
if (rs.getResult().next()) {
groups = rs.getResult().getString("groups");
wasNull = rs.getResult().wasNull();
}
rs.closeQuery();
if (wasNull) {
initial = true;
} else if (groups.equals("")) {
initial = true;
}
if (initial) {
if (RootConfig.getBoolean(ConfigNode.DEBUG_KARMA)) {
plugin.getLogger().info("Initial groups for " + name);
}
// No groups, add in the global and self
plugin
.getDatabaseHandler()
.standardQuery(
"INSERT INTO "
+ Table.GROUPS.getName()
+ " (groupname) VALUES ('self_"
+ name.toLowerCase()
+ "');");
groups = getGroupId("global") + "&" + getGroupId("self_" + name.toLowerCase());
// Set groups for future reference
plugin
.getDatabaseHandler()
.standardQuery(
"UPDATE "
+ Table.PLAYERS.getName()
+ " SET groups='"
+ groups
+ "' WHERE playername='"
+ name
+ "';");
}
String[] split = groups.split("&");
for (String s : split) {
try {
if (s != null && !s.equals("")) {
list.add(getGroupName(Integer.parseInt(s)));
}
} catch (NumberFormatException n) {
if (RootConfig.getBoolean(ConfigNode.DEBUG_KARMA)) {
plugin.getLogger().warning("Bad group id '" + s + "'");
}
n.printStackTrace();
}
}
} catch (SQLException e) {
if (RootConfig.getBoolean(ConfigNode.DEBUG_KARMA)) {
plugin
.getLogger()
.warning("SQLException on getPlayerGroups(" + sender.getName() + "," + name + ")");
}
sender.sendMessage(ChatColor.RED + KarmicShare.TAG + " SQL Exception");
e.printStackTrace();
}
return list;
}
public static boolean playerHasGroup(CommandSender sender, String name, String group) {
if (group.equals("global")) {
if (RootConfig.getBoolean(ConfigNode.DEBUG_KARMA)) {
plugin.getLogger().info(name + " has group " + group);
}
return true;
} else if (group.equals("self_" + name.toLowerCase())) {
return true;
}
boolean has = false;
try {
// Insures that the player is added to the database
getPlayerKarma(name);
String groups = "";
final Query rs =
plugin
.getDatabaseHandler()
.select(
"SELECT * FROM " + Table.PLAYERS.getName() + " WHERE playername='" + name + "';");
if (rs.getResult().next()) {
groups = rs.getResult().getString("groups");
if (!rs.getResult().wasNull()) {
if (groups.contains("&")) {
// they have multiple groups
for (String s : groups.split("&")) {
try {
// grab id of given group and compare against
// ids
final String groupName = getGroupName(Integer.parseInt(s));
if (groupName.equalsIgnoreCase(group)) {
has = true;
}
} catch (NumberFormatException n) {
// bad group id
if (RootConfig.getBoolean(ConfigNode.DEBUG_KARMA)) {
plugin
.getLogger()
.warning(
"NumberFormatException for playerHasGroup("
+ sender.getName()
+ ","
+ name
+ ","
+ group
+ ")");
}
}
}
} else {
try {
final String groupName = getGroupName(Integer.parseInt(groups));
// they only have one group
if (groupName.equalsIgnoreCase(group)) {
has = true;
}
} catch (NumberFormatException n) {
// bad group id
if (RootConfig.getBoolean(ConfigNode.DEBUG_KARMA)) {
plugin
.getLogger()
.warning(
"NumberFormatException for playerHasGroup("
+ sender.getName()
+ ","
+ name
+ ","
+ group
+ ")");
}
}
}
}
}
rs.closeQuery();
} catch (SQLException e) {
sender.sendMessage(ChatColor.RED + KarmicShare.TAG + " SQL Exception");
e.printStackTrace();
}
if (RootConfig.getBoolean(ConfigNode.DEBUG_KARMA)) {
plugin.getLogger().info("Player " + name + " has group " + group + " : " + has);
}
return has;
}
public static void setPlayerKarma(String name, int karma) {
if (RootConfig.getBoolean(ConfigNode.KARMA_ECONOMY)) {
EconomyResponse response = null;
try {
int balance = getPlayerKarma(name);
if (balance > karma) {
// Give difference
response = plugin.getEconomy().depositPlayer(name, (balance - karma));
} else {
// Take difference
response = plugin.getEconomy().withdrawPlayer(name, (karma - balance));
}
} catch (SQLException e) {
// Won't happen since we're using economy
}
if (response == null) {
return;
}
switch (response.type) {
case FAILURE:
{
try {
plugin
.getServer()
.getPlayer(name)
.sendMessage(ChatColor.RED + KarmicShare.TAG + " Failed economy transaction!");
} catch (NullPointerException npe) {
// IGNORE
}
if (RootConfig.getBoolean(ConfigNode.DEBUG_ECONOMY)) {
plugin
.getLogger()
.warning(
"Failed economy transaction on setPlayerKarma("
+ name
+ ", "
+ karma
+ ") : "
+ response.errorMessage);
}
break;
}
case NOT_IMPLEMENTED:
{
try {
plugin
.getServer()
.getPlayer(name)
.sendMessage(ChatColor.RED + KarmicShare.TAG + " Failed economy transaction!");
} catch (NullPointerException npe) {
// IGNORE
}
if (RootConfig.getBoolean(ConfigNode.DEBUG_ECONOMY)) {
plugin
.getLogger()
.warning(
"Unimplemented economy transaction on setPlayerKarma("
+ name
+ ", "
+ karma
+ ") for eco "
+ plugin.getEconomy().getName()
+ " : "
+ response.errorMessage);
}
break;
}
case SUCCESS:
{
if (RootConfig.getBoolean(ConfigNode.DEBUG_ECONOMY)) {
plugin
.getLogger()
.info(
"Successful economy transaction on setPlayerKarma("
+ name
+ ", "
+ karma
+ ")");
}
break;
}
default:
{
if (RootConfig.getBoolean(ConfigNode.DEBUG_ECONOMY)) {
plugin.getLogger().warning("Unknown response type:" + response.type.toString());
}
break;
}
}
} else {
String query;
// Check updated karma value to limits in config
if (karma <= RootConfig.getInt(ConfigNode.KARMA_LOWER_LIMIT)) {
// Updated karma value is beyond lower limit, so set to min
query =
"UPDATE "
+ Table.PLAYERS.getName()
+ " SET karma='"
+ RootConfig.getInt(ConfigNode.KARMA_LOWER_LIMIT)
+ "' WHERE playername='"
+ name
+ "';";
} else if (karma >= RootConfig.getInt(ConfigNode.KARMA_UPPER_LIMIT)) {
// Updated karma value is beyond upper limit, so set to max
query =
"UPDATE "
+ Table.PLAYERS.getName()
+ " SET karma='"
+ RootConfig.getInt(ConfigNode.KARMA_UPPER_LIMIT)
+ "' WHERE playername='"
+ name
+ "';";
} else {
// Updated karma value is within acceptable range
query =
"UPDATE "
+ Table.PLAYERS.getName()
+ " SET karma='"
+ karma
+ "' WHERE playername='"
+ name
+ "';";
}
plugin.getDatabaseHandler().standardQuery(query);
}
}
public static int grabPage(int current, String group, Direction direction) {
// Calculate number of slots
int slots = 0;
int groupId = Karma.getGroupId(group);
if (groupId == -1) {
if (RootConfig.getBoolean(ConfigNode.DEBUG_INVENTORY)) {
plugin.getLogger().warning("Tried to grabPage for invalid group: " + group);
}
return 1;
}
final Query all =
plugin
.getDatabaseHandler()
.select("SELECT * FROM " + Table.ITEMS.getName() + " WHERE groups='" + groupId + "';");
try {
if (all.getResult().next()) {
do {
final int amount = all.getResult().getInt("amount");
if (!all.getResult().wasNull()) {
final ItemStack item = new ItemStack(all.getResult().getInt("itemid"), amount);
if (item != null) {
int maxStack = item.getType().getMaxStackSize();
if (maxStack <= 0) {
maxStack = 1;
}
int stacks = amount / maxStack;
final double rem = (double) amount % (double) maxStack;
if (rem != 0) {
stacks++;
}
slots += stacks;
}
}
} while (all.getResult().next());
}
all.closeQuery();
} catch (SQLException e) {
if (RootConfig.getBoolean(ConfigNode.DEBUG_INVENTORY)) {
plugin
.getLogger()
.warning(
"SQLException on grabPage("
+ current
+ ","
+ group
+ ","
+ direction.toString()
+ ")");
}
e.printStackTrace();
}
// if no slots, return 1
if (slots <= 0) {
return 1;
}
// Calculate pages
int pageTotal = slots / chestSize;
final double rem = (double) slots % (double) chestSize;
if (rem != 0) {
pageTotal++;
}
// Check against maximum
if (current >= Integer.MAX_VALUE) {
// Cycle back as we're at the max value for an integer
return 1;
}
int page = current;
switch (direction) {
case FORWARD:
{
page++;
break;
}
case BACKWARD:
{
page--;
break;
}
default:
{
break;
}
}
if (page <= 0) {
// Was negative or zero, loop back to max page
page = (pageTotal + 1);
}
// Allow for empty page
else if (page > (pageTotal + 1)) {
// Going to page beyond the total items, cycle back to
// first
page = 1;
}
if (RootConfig.getBoolean(ConfigNode.DEBUG_INVENTORY)) {
plugin
.getLogger()
.info("grabPage(" + current + "," + group + "," + direction.toString() + ") : " + page);
}
return page;
}
