X-Git-Url: https://code.wpia.club/?a=blobdiff_plain;f=src%2Forg%2Fcacert%2Fgigi%2FUser.java;h=055ac8384fe376e65771e5aaff1a8d52459beec4;hb=109ee347f66820b5a860c1ae579866c7da01c5cd;hp=b049bc3ffde11edb06d49e4263dfad0001f604f7;hpb=b0ab4664edfc6ee90b658bfa662a54dec42879b3;p=gigi.git diff --git a/src/org/cacert/gigi/User.java b/src/org/cacert/gigi/User.java index b049bc3f..055ac838 100644 --- a/src/org/cacert/gigi/User.java +++ b/src/org/cacert/gigi/User.java @@ -22,12 +22,13 @@ public class User { this.id = id; try { PreparedStatement ps = DatabaseConnection.getInstance().prepare( - "SELECT `fname`, `lname` FROM `users` WHERE id=?"); + "SELECT `fname`, `lname`, `dob` FROM `users` WHERE id=?"); ps.setInt(1, id); ResultSet rs = ps.executeQuery(); if (rs.next()) { fname = rs.getString(1); lname = rs.getString(2); + dob = rs.getDate(3); } rs.close(); } catch (SQLException e) { @@ -85,9 +86,7 @@ public class User { 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"); + + "`suffix`=?, `dob`=?, `created`=NOW(), locked=0"); query.setString(1, email); query.setString(2, PasswordHash.hash(password)); query.setString(3, fname);