added cmd_unregister and cmd_recover

[NeonServV5.git] / cmd_neonserv_register.c

diff --git a/cmd_neonserv_register.c b/cmd_neonserv_register.c
index 0a287f1dbf88c3736f1b634a0c2b407707e71296..24063899c4ea9deb86dfed55156eaccca17ee364 100644 (file)
--- a/cmd_neonserv_register.c
+++ b/cmd_neonserv_register.c
@@ -111,7 +111,13 @@ static void neonserv_cmd_register_async1(struct ClientSocket *client, struct Cli
     //we've got a valid auth now...
     MYSQL_RES *res;
     MYSQL_ROW row, row2;
-    int userid;
+    int userid, adminid;
+    printf_mysql_query("SELECT `user_id` FROM `users` WHERE `user_user` = '%s'", escape_string(user->auth));
+    res = mysql_use();
+    if ((row = mysql_fetch_row(res)) != NULL)
+        adminid = atoi(row[0]);
+    else
+        adminid = 0;
     printf_mysql_query("SELECT `user_id` FROM `users` WHERE `user_user` = '%s'", escape_string(auth));
     res = mysql_use();
     if ((row = mysql_fetch_row(res)) != NULL) {
@@ -143,8 +149,9 @@ static void neonserv_cmd_register_async1(struct ClientSocket *client, struct Cli
     res = mysql_use();
     if ((row = mysql_fetch_row(res)) != NULL) {
         chanid = atoi(row[0]);
+        printf_mysql_query("UPDATE `channels` SET `channel_registered` = UNIX_TIMESTAMP(), `channel_registrator` = '%d' WHERE `channel_id` = '%d'", adminid, chanid);
     } else {
-        printf_mysql_query("INSERT INTO `channels` (`channel_name`) VALUES ('%s')", escape_string(channel));
+        printf_mysql_query("INSERT INTO `channels` (`channel_name`, `channel_registered`, `channel_registrator`) VALUES ('%s', UNIX_TIMESTAMP(), '%d')", escape_string(channel), adminid);
         chanid = (int) mysql_insert_id(mysql_conn);
     }
     struct ClientSocket *bot;