use REPLACE INTO for tmpban

git-svn-id: http://svn.tabris.net/repos/srsv@3614 70d4eda1-72e9-0310-a436-91e5bd24443c

diff --git a/branches/0.4.3/modules/serviceslibs/chanserv.pm b/branches/0.4.3/modules/serviceslibs/chanserv.pm
index 270ea85be8c432ead5a63f70b05affe601638da0..e05642f5b9dd9c1b7bd5493cee699524643483d1 100644 (file)
--- a/branches/0.4.3/modules/serviceslibs/chanserv.pm
+++ b/branches/0.4.3/modules/serviceslibs/chanserv.pm
@@ -532,7 +532,7 @@ use SrSv::MySQL::Stub {
                JOIN nickid ON (chanuser.nickid=nickid.id AND chanacc.nrid=nickid.nrid)
                WHERE chanperm.name='Join'
                AND nickid.id=?"],
-       add_tempban => ['INSERT', "INSERT INTO tmpban values (?,?,UNIX_TIMESTAMP()+?,UNIX_TIMESTAMP())"],
+       add_tempban => ['INSERT', "REPLACE INTO tmpban values (?,?,UNIX_TIMESTAMP()+?,UNIX_TIMESTAMP())"],
        del_tempban  => ['NULL', "DELETE FROM tmpban WHERE channel=? AND banmask = ?"],
        __get_bantime => ['SCALAR', "SELECT bantime FROM chanreg WHERE chan=?"],
        set_bantime => ['NULL', "UPDATE chanreg SET bantime=? WHERE chan=?"],