X-Git-Url: https://code.wpia.club/?a=blobdiff_plain;ds=sidebyside;f=src%2Forg%2Fcacert%2Fgigi%2Futil%2FNotary.java;h=3dfc4faab5700647bb8ba0ecee6113fab6ebde2d;hb=4434b6f12f8813b1a32f6c3cbf925cd5b83f1843;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..3dfc4faa 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();