public static void adduser( int checkid, String player, String email, String password, String ipAddress) throws SQLException { if (checkid == 1) { long timestamp = System.currentTimeMillis() / 1000; // PreparedStatement ps; // String salt = Encryption.hash(12, "none", 33, 126); String hash = hash("create", player, password, salt); ps = MySQL.mysql.prepareStatement( "INSERT INTO `" + Config.script_tableprefix + "users" + "` (`group_id`, `username`, `password`, `salt`, `email`, `registered`, `registration_ip`, `last_visit`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)", 1); ps.setInt(1, 3); // group_id ps.setString(2, player); // username ps.setString(3, hash); // password ps.setString(4, salt); // salt ps.setString(5, email); // email ps.setLong(6, timestamp); // registered ps.setString(7, ipAddress); // registration_ip ps.setLong(8, timestamp); // last_visit // Util.logging.mySQL(ps.toString()); ps.executeUpdate(); ps.close(); /* ps = MySQL.mysql.prepareStatement("UPDATE `" + Config.script_tableprefix + "config" + "` SET `config_value` = '" + userid + "' WHERE `config_name` = 'newest_user_id'"); ps.executeUpdate(); ps = MySQL.mysql.prepareStatement("UPDATE `" + Config.script_tableprefix + "config" + "` SET `config_value` = '" + player + "' WHERE `config_name` = 'newest_username'"); ps.executeUpdate(); ps = MySQL.mysql.prepareStatement("UPDATE `" + Config.script_tableprefix + "config" + "` SET `config_value` = config_value + 1 WHERE `config_name` = 'num_users'"); ps.executeUpdate(); */ } }
public static String passwordHash(String password, String salt) throws NoSuchAlgorithmException, UnsupportedEncodingException { return Encryption.SHA1(salt + Encryption.SHA1(password)); }