X-Git-Url: https://code.wpia.club/?a=blobdiff_plain;ds=sidebyside;f=src%2Forg%2Fcacert%2Fgigi%2Futil%2FNotary.java;h=767230b0a82dfd470af7b356500a07dff3b8a056;hb=46dd85120b48c942c00f61775c4c840e956d02df;hp=bd6f762586d6c79f07c8d4523948491ba8b96e8e;hpb=90771b77a6e7cd00bce47feeb35786f0371b89bd;p=gigi.git diff --git a/src/org/cacert/gigi/util/Notary.java b/src/org/cacert/gigi/util/Notary.java index bd6f7625..767230b0 100644 --- a/src/org/cacert/gigi/util/Notary.java +++ b/src/org/cacert/gigi/util/Notary.java @@ -29,7 +29,7 @@ public class Notary { if (assurer.getId() == target.getId()) { throw new GigiApiException("You cannot assure yourself."); } - GigiPreparedStatement ps = DatabaseConnection.getInstance().prepare("SELECT 1 FROM `notary` where `to`=? and `from`=? AND `deleted`=0"); + GigiPreparedStatement ps = DatabaseConnection.getInstance().prepare("SELECT 1 FROM `notary` where `to`=? and `from`=? AND `deleted` IS NULL"); ps.setInt(1, target.getId()); ps.setInt(2, assurer.getId()); GigiResultSet rs = ps.executeQuery(); @@ -105,7 +105,7 @@ public class Notary { gae.mergeInto(e); } - if ( !assuree.getName().equals(assureeName) || !assuree.getDob().equals(dob)) { + if ( !assuree.getName().equals(assureeName) || !assuree.getDoB().equals(dob)) { gae.mergeInto(new GigiApiException("The person you are assuring changed his personal details.")); } if (awarded > assurer.getMaxAssurePoints() || awarded < 0) {