X-Git-Url: https://code.wpia.club/?p=gigi.git;a=blobdiff_plain;f=src%2Forg%2Fcacert%2Fgigi%2FUser.java;h=b049bc3ffde11edb06d49e4263dfad0001f604f7;hp=50e13ac044e14b9e187117b44ac72a4ea533939f;hb=b0ab4664edfc6ee90b658bfa662a54dec42879b3;hpb=bd001f36f9ae184eae6ffb59305289df8e5aed71

diff --git a/src/org/cacert/gigi/User.java b/src/org/cacert/gigi/User.java
index 50e13ac0..b049bc3f 100644
--- a/src/org/cacert/gigi/User.java
+++ b/src/org/cacert/gigi/User.java
@@ -6,6 +6,7 @@ import java.sql.SQLException;
 import java.util.Date;
 
 import org.cacert.gigi.database.DatabaseConnection;
+import org.cacert.gigi.util.PasswordHash;
 
 public class User {
 
@@ -77,5 +78,26 @@ public class User {
 	public void setLname(String lname) {
 		this.lname = lname;
 	}
+	public void insert(String password) throws SQLException {
+		if (id != 0) {
+			throw new Error("refusing to insert");
+		}
+		PreparedStatement query = DatabaseConnection.getInstance().prepare(
+				"insert into `users` set `email`=?, `password`=?, "
+						+ "`fname`=?, `mname`=?, `lname`=?, "
+						+ "`suffix`=?, `dob`=?, `created`=NOW(),"
+						+ " `orgadmin`=0, `adadmin`=0, `locked`=0,"
+						+ " `uniqueID`=0, `otphash`='', `otppin`=0");
+		query.setString(1, email);
+		query.setString(2, PasswordHash.hash(password));
+		query.setString(3, fname);
+		query.setString(4, mname);
+		query.setString(5, lname);
+		query.setString(6, suffix);
+		query.setDate(7, new java.sql.Date(dob.getTime()));
+		query.execute();
+		id = DatabaseConnection.lastInsertId(query);
+		System.out.println("Inserted: " + id);
+	}
 
 }