diff options
| author | Adam <Adam@anope.org> | 2017-04-07 14:27:20 -0400 |
|---|---|---|
| committer | Adam <Adam@anope.org> | 2017-04-07 14:27:20 -0400 |
| commit | a8f2a9b491d9f583f86a5fae68a67b392a6ef8e2 (patch) | |
| tree | 475d14ae9dfc0495db06a3da7df31955e5df2ef8 | |
| parent | 2b58a75c85e1dbdee730e057cbf6c3d6fa759a29 (diff) | |
| parent | 76ea11198028b6a1ab4f739d239bf890ce6d937e (diff) | |
Merge commit '76ea11198028b6a1ab4f739d239bf890ce6d937e'
| -rw-r--r-- | modules/extra/stats/irc2sql/irc2sql.cpp | 5 | ||||
| -rw-r--r-- | modules/extra/stats/irc2sql/tables.cpp | 4 |
2 files changed, 6 insertions, 3 deletions
diff --git a/modules/extra/stats/irc2sql/irc2sql.cpp b/modules/extra/stats/irc2sql/irc2sql.cpp index e0c03edbd..3ad901f74 100644 --- a/modules/extra/stats/irc2sql/irc2sql.cpp +++ b/modules/extra/stats/irc2sql/irc2sql.cpp @@ -195,7 +195,10 @@ void IRC2SQL::OnChannelCreate(Channel *c) query.SetValue("channel", c->name); query.SetValue("topic", c->topic); query.SetValue("topicauthor", c->topic_setter); - query.SetValue("topictime", c->topic_ts); + if (c->topic_ts > 0) + query.SetValue("topictime", c->topic_ts); + else + query.SetValue("topictime", "NULL", false); query.SetValue("modes", c->GetModes(true,true)); this->RunQuery(query); } diff --git a/modules/extra/stats/irc2sql/tables.cpp b/modules/extra/stats/irc2sql/tables.cpp index f8102e041..bb7a8edd7 100644 --- a/modules/extra/stats/irc2sql/tables.cpp +++ b/modules/extra/stats/irc2sql/tables.cpp @@ -73,8 +73,8 @@ void IRC2SQL::CheckTables() "`comment` varchar(255) NOT NULL," "`link_time` datetime DEFAULT NULL," "`split_time` datetime DEFAULT NULL," - "`version` varchar(127) NOT NULL," - "`currentusers` int(15) NOT NULL," + "`version` varchar(127) DEFAULT NULL," + "`currentusers` int(15) DEFAULT 0," "`online` enum('Y','N') NOT NULL DEFAULT 'Y'," "`ulined` enum('Y','N') NOT NULL DEFAULT 'N'," "PRIMARY KEY (`id`)," |