From: tabris <redacted>
Date: Mon, 17 Jun 2013 14:32:42 +0000 (+0000)
Subject: use REPLACE INTO for tmpban
X-Git-Url: https://jfr.im/git/irc/SurrealServices/srsv.git/commitdiff_plain/f36ab9e5367cadc62b209e4441fecd391802051a

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 270ea85b..e05642f5 100644
--- 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=?"],