private static String getLowest(Plugin plugin, Material shopType, short durability) {
ItemStack itemStack = ItemUtil.getLowest();
ItemMeta itemMeta = itemStack.getItemMeta();
Trade trade =
SqlUtil.getFirst(
plugin
.getDatabase()
.find(Trade.class)
.where()
.ieq("material", shopType.name())
.ieq("durability", durability + "")
.ieq("sell", "1")
.orderBy()
.asc("price")
.findList());
if (trade != null) {
itemMeta.setDisplayName(
String.format(
"Lowest sell price: %d:%d by %s",
trade.getItemPrice(), trade.getMoneyPrice(), trade.getPlayer()));
} else {
itemMeta.setDisplayName("Nobody selling");
}
itemStack.setItemMeta(itemMeta);
return itemMeta.getDisplayName();
}
private void checkDDL() {
try {
plugin.getDatabase().find(IntUserValue.class).findRowCount();
} catch (PersistenceException e) {
try {
Method method = JavaPlugin.class.getDeclaredMethod("installDDL");
method.setAccessible(true);
method.invoke(plugin);
} catch (ReflectiveOperationException e1) {
e1.printStackTrace();
}
}
}
@Override
public void run() {
while (!stop) {
DatabaseTask task;
while ((task = threadTasks.poll()) != null) {
try {
task.run(plugin.getDatabase());
} catch (Exception e) {
System.out.println("Exception while doing DatabaseTask");
e.printStackTrace();
}
}
try {
Thread.sleep(5);
} catch (InterruptedException e) {
e.printStackTrace();
return;
}
}
}