diff options
| author | Adam <Adam@anope.org> | 2016-11-04 22:07:00 -0400 |
|---|---|---|
| committer | Adam <Adam@anope.org> | 2016-11-04 22:07:00 -0400 |
| commit | 76ea11198028b6a1ab4f739d239bf890ce6d937e (patch) | |
| tree | bead8e71542dfddd2462ad79ade4316374d102d1 | |
| parent | 9f9183afc4898fc176677623ece5051d95540923 (diff) | |
irc2sql: fix a couple SQL errors
| -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 a00181304..99fb46da3 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`)," |