Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private static final int Integer = 0;
- public static MySQL MySQL = new MySQL("snip", "snip", "snip", "snip", "snip");
- public static Connection c = null;
- public static void enable() {
- try {
- c = MySQL.openConnection();
- Main.getInstance().getLogger().info("MySQL Fired!");
- } catch (ClassNotFoundException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
- public static int sqlLoginQuery(Player p) throws SQLException {
- Statement statement = c.createStatement();
- Main.getInstance().getLogger().info("Second Query fired!");
- ResultSet res = statement.executeQuery("SELECT * FROM player_data WHERE Name = '" + p.getName() + "';");
- res.next();
- int Integer = res.getInt("Logins");
- Main.getInstance().getLogger().info("" + Integer);
- if(res.getString("Name") == null) {
- Main.getInstance().getLogger().info("Null");
- statement.executeUpdate("INSERT INTO player_data (Name, Logins) VALUES ('" + p.getName() + "', 1);");
- } else {
- int Integer2 = Integer + 1;
- Main.getInstance().getLogger().info("" + Integer2);
- statement.executeUpdate("UPDATE player_data SET Logins = '" + Integer2 + "' WHERE Name = '" + p.getName() + "'");
- }
- return Integer;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement