From bf75ae4f4184dcbf6e41d7ca869c5452da53abff Mon Sep 17 00:00:00 2001
From: pk910 <philipp@zoelle1.de>
Date: Tue, 4 Oct 2011 20:24:34 +0200
Subject: [PATCH] added owner history to cmd_info

---
 src/bot_NeonServ.c      |  2 +-
 src/cmd_neonserv_info.c | 15 ++++++++++++++-
 2 files changed, 15 insertions(+), 2 deletions(-)

diff --git a/src/bot_NeonServ.c b/src/bot_NeonServ.c
index 28ecb71..06d7826 100644
--- a/src/bot_NeonServ.c
+++ b/src/bot_NeonServ.c
@@ -306,7 +306,7 @@ static const struct default_language_entry msgtab[] = {
     {"NS_INFO_REGISTERED", "Registered:"},
     {"NS_INFO_REGISTRAR", "Registered by:"},
     {"NS_INFO_OWNERLOG", "Ownership transfer history for $b%s$b:"},
-    {"NS_INFO_OWNERCHANGE", " from %s to %s on %s (%s)"},
+    {"NS_INFO_OWNERCHANGE", " from %s to %s on %s"},
     {NULL, NULL}
 };
 
diff --git a/src/cmd_neonserv_info.c b/src/cmd_neonserv_info.c
index f5aa8d0..ce9544c 100644
--- a/src/cmd_neonserv_info.c
+++ b/src/cmd_neonserv_info.c
@@ -82,5 +82,18 @@ CMD_BIND(neonserv_cmd_info) {
         reply(getTextBot(), user, table_lines[i]);
     }
     table_free(table);
-    
+    printf_mysql_query("SELECT `owner_history_time`, a.`user_user`, b.`user_user` FROM `owner_history` LEFT JOIN `users` a ON `owner_history_from_uid` = a.`user_id` LEFT JOIN `users` b ON `owner_history_to_uid` = b.`user_id` WHERE `owner_history_cid` = '%d'", chan->channel_id);
+    res = mysql_use();
+    if(mysql_num_rows(res)) {
+        reply(getTextBot(), user, "NS_INFO_OWNERLOG", chan->name);
+        time_t rawtime;
+        struct tm *timeinfo;
+        char timeBuf[80];
+        while((row = mysql_fetch_row(res))) {
+            rawtime = (time_t) atol(row[0]);
+            timeinfo = localtime(&rawtime);
+            strftime(timeBuf, 80, "%c", timeinfo);
+            reply(getTextBot(), user, "NS_INFO_OWNERCHANGE", row[1], row[2], timeBuf);
+        }
+    }
 }
-- 
2.20.1