added owner history to cmd_info

diff --git a/src/bot_NeonServ.c b/src/bot_NeonServ.c
index 28ecb7160f597fdc9737ca582d2a0a991d13fb7b..06d7826fb73d48e4ca2abeb0caecdae63a1fc548 100644 (file)
--- 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 f5aa8d06f34df664a8b61c296992ff7aaec0143b..ce9544c013aad014f37c2efbe62e664e591ed4dc 100644 (file)
--- 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);
+        }
+    }
 }