MiBlueCredits (core) - MiBlue SQL Credits System

MiBlueCredits_.classpath

<?xml version="1.0" encoding="UTF-8"?>
<classpath>
	<classpathentry kind="src" path="src"/>
	<classpathentry kind="con" path="org.eclipse.jdt.launching.JRE_CONTAINER/org.eclipse.jdt.internal.debug.ui.launcher.StandardVMType/JavaSE-1.6"/>
	<classpathentry kind="lib" path="/Users/MilesMcc/Downloads/bukkit-1.6.2-R0.1-20130715.060132-5.jar"/>
	<classpathentry kind="lib" path="/Users/MilesMcc/Downloads/Vault (10).jar"/>
	<classpathentry kind="output" path="bin"/>
</classpath>

MiBlueCredits_.project

<?xml version="1.0" encoding="UTF-8"?>
<projectDescription>
	<name>MiBlueCredits</name>
	<comment></comment>
	<projects>
	</projects>
	<buildSpec>
		<buildCommand>
			<name>org.eclipse.jdt.core.javabuilder</name>
			<arguments>
			</arguments>
		</buildCommand>
	</buildSpec>
	<natures>
		<nature>org.eclipse.jdt.core.javanature</nature>
	</natures>
</projectDescription>

MiBlueCredits_.settings_org.eclipse.core.resources.prefs

eclipse.preferences.version=1
encoding//src/net/miblue/credits/MiBlueCredits.java=UTF-8

MiBlueCredits_.settings_org.eclipse.jdt.core.prefs

eclipse.preferences.version=1
org.eclipse.jdt.core.compiler.codegen.inlineJsrBytecode=enabled
org.eclipse.jdt.core.compiler.codegen.targetPlatform=1.6
org.eclipse.jdt.core.compiler.codegen.unusedLocal=preserve
org.eclipse.jdt.core.compiler.compliance=1.6
org.eclipse.jdt.core.compiler.debug.lineNumber=generate
org.eclipse.jdt.core.compiler.debug.localVariable=generate
org.eclipse.jdt.core.compiler.debug.sourceFile=generate
org.eclipse.jdt.core.compiler.problem.assertIdentifier=error
org.eclipse.jdt.core.compiler.problem.enumIdentifier=error
org.eclipse.jdt.core.compiler.source=1.6

MiBlueCredits_bin_net_miblue_credits_MiBlueCredits.class

  // IntelliJ API Decompiler stub source generated from a class file
  // Implementation of methods is not available

package net.miblue.credits;

public final class MiBlueCredits extends org.bukkit.plugin.java.JavaPlugin implements org.bukkit.event.Listener {
    public static java.util.HashMap<org.bukkit.entity.Player,java.lang.Integer> kills;
    private static net.milkbowl.vault.economy.Economy economy;
    public static java.sql.Connection conn;

    public MiBlueCredits() { /* compiled code */ }

    public void onEnable() { /* compiled code */ }

    private boolean setupEconomy() { /* compiled code */ }

    public void onDisable() { /* compiled code */ }

    public boolean onCommand(org.bukkit.command.CommandSender sender, org.bukkit.command.Command cmd, java.lang.String label, java.lang.String[] args) { /* compiled code */ }

    public int getCredits(java.lang.String player) { /* compiled code */ }

    public void setCredits(java.lang.String player, int amount) { /* compiled code */ }
}

MiBlueCredits_config.yml

hungergames:
  per-win: 5
  enabled: false
killstreak:
  multiple: 10
  worth: 1
  enabled: false
redeem:
  worth: 100
  # How much money a credit is worth.
  enabled: false
database:
  user: root
  pass: password
  url: jdbc:mysql://localhost:3306/credits

  

MiBlueCredits_MiBlueCredits.eml

<?xml version="1.0" encoding="UTF-8"?>
<component inheritJdk="true">
	<exclude-output/>
	<contentEntry url="file://$MODULE_DIR$"/>
</component>

MiBlueCredits_MiBlueCredits.iml

<?xml version="1.0" encoding="UTF-8"?>
<module classpath="eclipse" classpath-dir="$MODULE_DIR$" type="JAVA_MODULE" version="4" />

MiBlueCredits_plugin.yml

name: MiBlueCredits
main: net.miblue.credits.MiBlueCredits
version: 1.0
depend: [Vault]
commands:
   credits:
      description: Root MiBlueCredits Command
      usage: /credits [set <amount> <player> | add <amount> <player> | remove <amount> <player> | help | redeem <amount> <for>]

MiBlueCredits_src_net_miblue_credits_MiBlueCredits.java

package net.miblue.credits;

import java.io.File;
import java.sql.Array;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.HashMap;
import java.util.logging.Logger;

import org.bukkit.ChatColor;
import org.bukkit.Server;
import org.bukkit.command.Command;
import org.bukkit.command.CommandSender;
import org.bukkit.entity.Player;
import org.bukkit.event.EventHandler;
import org.bukkit.event.Listener;
import org.bukkit.event.entity.EntityDeathEvent;
import org.bukkit.event.player.PlayerJoinEvent;
import org.bukkit.event.player.PlayerQuitEvent;
import org.bukkit.plugin.RegisteredServiceProvider;
import org.bukkit.plugin.java.JavaPlugin;

import net.milkbowl.vault.economy.*;

public final class MiBlueCredits extends JavaPlugin implements Listener {
	public static HashMap<Player, Integer> kills = new HashMap<Player, Integer>();
	private static Economy economy;
	public static Connection conn = null;
	@Override
	public void onEnable(){
		getLogger().info("MiBlueCredits by milesmcc is being enabled...");
		Server server = getServer();
		getServer().getPluginManager().registerEvents(this, this);
		if(new File(getDataFolder().toString()).exists()){
			// Config exists, why generate a new one?
		}else{
			getLogger().info("Generating MiBlueCredits config!");
			getConfig().options().copyDefaults(true);
			saveDefaultConfig();
			getLogger().info("Generation complete!");
		}
		setupEconomy();
		getLogger().info("Attempting to connect to MySQL...");
		String user = getConfig().getString("database.user");
		String pass = getConfig().getString("database.pass");
		String url = getConfig().getString("database.url");
		conn = null;
		try {
			conn = DriverManager.getConnection(url, user, pass);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		try {
			if(conn.isClosed()){
				getLogger().severe("Unable to connect to MySQL. Disabling...");
				this.setEnabled(false);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		getLogger().warning("MiBlueCredits expects the table 'credits' to already created and have the columns 'name' and 'credits' existing!");
		getLogger().info("Enabling complete!");
		}
	
	private boolean setupEconomy() {
        @SuppressWarnings("unchecked")
		final RegisteredServiceProvider<Economy> economyProvider = (RegisteredServiceProvider<Economy>)this.getServer().getServicesManager().getRegistration((Class)Economy.class);
        if (economyProvider != null) {
            MiBlueCredits.economy = (Economy)economyProvider.getProvider();
        }
        return MiBlueCredits.economy != null;
    }
	@Override
	public void onDisable(){
		getLogger().info("Disconnecting from MySQL...");
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		getLogger().info("MiBlueCredits has been disabled.");
	}
	public boolean onCommand(CommandSender sender, Command cmd, String label, String[] args){
		if(args.length == 0){
			if(getConfig().getBoolean("redeem.enabled")){
				sender.sendMessage(ChatColor.GRAY +""+ ChatColor.ITALIC + "Redeem your credits for money with " + ChatColor.GOLD + ChatColor.ITALIC + "/credits redeem <amount of credits> money" + ChatColor.GRAY + ChatColor.ITALIC + ". Exchange rate: 1 credit is worth " + ChatColor.GOLD + getConfig().getInt("redeem.worth") + ChatColor.BLUE + " in-game currency.");
			}
			if(getConfig().getBoolean("killstreak.enabled")){
				sender.sendMessage(ChatColor.GRAY +""+ ChatColor.ITALIC + "Every " + getConfig().getInt("killstreak.multiple") + " kills, you can earn " + ChatColor.GOLD + ChatColor.ITALIC + getConfig().getInt("killstreak.worth") + ChatColor.GRAY + ChatColor.ITALIC + " credits.");
			}
			if(getConfig().getBoolean("hungergames.enabled")){
				sender.sendMessage(ChatColor.GRAY +""+ ChatColor.ITALIC + "If you win the Hunger Games, you will get " + ChatColor.GOLD + ChatColor.ITALIC + getConfig().getInt("hungergames.per-win") + ChatColor.GRAY + ChatColor.ITALIC + " credits.");
			}
			sender.sendMessage(ChatColor.BLUE + "Ⓜ" + ChatColor.STRIKETHROUGH + "-----------------------------------------");
			sender.sendMessage(ChatColor.BLUE + "Ⓜ"+ ChatColor.ITALIC + "Your credits: " + ChatColor.GOLD + ChatColor.ITALIC + getCredits(sender.getName()));
			sender.sendMessage(ChatColor.BLUE + "Ⓜ" + ChatColor.STRIKETHROUGH + "-----------------------------------------");
		}else if(args.length == 3){
			if(args[0].equalsIgnoreCase("redeem")){
				if(getConfig().getBoolean("redeem.enabled")){
					if(args[2].equalsIgnoreCase("money")){
						int toget = 0;
						try {
						    toget = Integer.parseInt(args[1]) * getConfig().getInt("redeem.worth");
						    if(getCredits(sender.getName()) >= Integer.parseInt(args[1])){
									economy.depositPlayer(sender.getName(), toget);
									setCredits(sender.getName(), getCredits(sender.getName()) - Integer.parseInt(args[1]));
									sender.sendMessage(ChatColor.GREEN + "Successfully traded in " + Integer.parseInt(args[1]) + " credits in order to get " + toget + " in-game currency.");
							}else{
								sender.sendMessage(ChatColor.RED + "Not enough credits!");
							}
						} catch (NumberFormatException e) {
						      sender.sendMessage(ChatColor.RED + "Amount of credits not a number!");
						}
					}
				}
			}else if(args[0].equalsIgnoreCase("set")){
				if(sender.hasPermission("mibluecredits.admin") || sender.isOp()){
					int amount = 0;
					String to = args[1];
					try {
					    amount = Integer.parseInt(args[2]);
					    if(amount > -1){
					    	setCredits(to, amount);
						    sender.sendMessage(ChatColor.GREEN + "Success.");
					    }else{
					    	sender.sendMessage(ChatColor.RED + "You can't have negative credits!");
					    }
					    
					} catch (NumberFormatException e) {
					      sender.sendMessage(ChatColor.RED + "Amount of credits not a number!");
					}
				}else{
					sender.sendMessage(ChatColor.RED + "No permission.");
				}
			}else if(args[0].equalsIgnoreCase("add")){
				if(sender.hasPermission("mibluecredits.admin") || sender.isOp()){
					int amount = 0;
					try {
					    amount = Integer.parseInt(args[2]);
					    setCredits(args[1], amount + getCredits(args[1]));
					    sender.sendMessage(ChatColor.GREEN + "Success.");
					} catch (NumberFormatException e) {
					      sender.sendMessage(ChatColor.RED + "Amount of credits not a number!");
					}
				}else{
					sender.sendMessage(ChatColor.RED + "No permission.");
				}
			}else if(args[0].equalsIgnoreCase("remove")){
				if(sender.hasPermission("mibluecredits.admin") || sender.isOp()){
					int amount = 0;
					try {
					    amount = Integer.parseInt(args[2]);
					    if(getCredits(sender.getName()) - amount < 0){
					    	sender.sendMessage(ChatColor.RED + "You can't have a negative amount of credits!");
					    }else{
					    	setCredits(args[1], getCredits(args[1]) - amount);
						    sender.sendMessage(ChatColor.GREEN + "Success.");
					    }
					} catch (NumberFormatException e) {
					      sender.sendMessage(ChatColor.RED + "Amount of credits not a number!");
					}
				}else{
					sender.sendMessage(ChatColor.RED + "No permission.");
				}
			}else{
				sender.sendMessage(ChatColor.RED + "Unknown command.");
			}
		}else{
			sender.sendMessage(ChatColor.RED + "Too many/too few arguments.");
		}
		return true;
	}
	public int getCredits(String player){
		int credits = 0;
		try {
			ResultSet data = conn.createStatement().executeQuery("SELECT `credits` FROM `credits` WHERE `name`='" + player + "'");
			while(data.next() == true){
				credits = data.getInt("credits");
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return credits;
	}
	public void setCredits(String player, int amount){
		boolean exists = false;
		try {
			ResultSet data = conn.createStatement().executeQuery("SELECT `credits` FROM `credits` WHERE `name`='" + player + "'");
			while(data.next() == true){
				exists = true;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		if(exists){
			try {
				conn.createStatement().execute("UPDATE `credits` SET `credits` = '" + amount + "' WHERE `name` = '" + player + "'");
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}else{
			try {
				conn.createStatement().execute("REPLACE INTO `credits` SET `credits` = '" + amount + "', `name` = '" + player + "'");
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}	
		}
	}
}