From: pk910 <philipp@zoelle1.de>
Date: Thu, 8 Sep 2011 03:14:05 +0000 (+0200)
Subject: using mysql UNIX_TIMESTAMP function to store timestamps
X-Git-Tag: v5.3~459
X-Git-Url: http://git.pk910.de/?p=NeonServV5.git;a=commitdiff_plain;h=0af1752f101a625999d62624ee948c61f2059c16

using mysql UNIX_TIMESTAMP function to store timestamps
---

diff --git a/cmd_neonserv_addban.c b/cmd_neonserv_addban.c
index 91202d9..245190b 100644
--- a/cmd_neonserv_addban.c
+++ b/cmd_neonserv_addban.c
@@ -76,6 +76,6 @@ static void neonserv_cmd_addban_async1(struct ClientSocket *client, struct Clien
     else
         return;
     //add the ban
-    printf_mysql_query("INSERT INTO `bans` (`ban_channel`, `ban_mask`, `ban_triggered`, `ban_owner`, `ban_reason`) VALUES ('%d', '%s', '%u', '%d', '%s')", chan->channel_id, escape_string(mask), (unsigned int) time(0), userid, escape_string(reason));
+    printf_mysql_query("INSERT INTO `bans` (`ban_channel`, `ban_mask`, `ban_triggered`, `ban_owner`, `ban_reason`) VALUES ('%d', '%s', UNIX_TIMESTAMP(), '%d', '%s')", chan->channel_id, escape_string(mask), userid, escape_string(reason));
     reply(getTextBot(), user, "NS_ADDBAN_DONE", mask, chan->name, match_count);
 }