added cmd_clvl and moved all the database request functions to DBHelper.c

[NeonServV5.git] / DBHelper.c

diff --git a/DBHelper.c b/DBHelper.c
new file mode 100644 (file)
index 0000000..eb89536
--- /dev/null
+++ b/DBHelper.c
@@ -0,0 +1,98 @@
+
+#include "DBHelper.h"
+#include "UserNode.h"
+#include "ChanNode.h"
+#include "ChanUser.h"
+#include "mysqlConn.h"
+#include "lang.h"
+
+
+void _loadUserSettings(struct UserNode *user) {
+    check_mysql();
+    MYSQL_RES *res;
+    MYSQL_ROW row;
+    printf_mysql_query("SELECT `user_lang`, `user_reply_privmsg`, `user_god` FROM `users` WHERE `user_user` = '%s'", escape_string(user->auth));
+    res = mysql_use();
+    if ((row = mysql_fetch_row(res)) != NULL) {
+        user->language = get_language_by_tag(row[0]);
+        if(user->language == NULL) user->language = get_default_language();
+        if(strcmp(row[1], "0"))
+            user->flags |= USERFLAG_REPLY_PRIVMSG;
+        if(strcmp(row[2], "0"))
+            user->flags |= USERFLAG_GOD_MODE;
+    } else
+        user->language = get_default_language();
+    user->flags |= USERFLAG_LOADED_SETTINGS;
+}
+
+int isGodMode(struct UserNode *user) {
+    loadUserSettings(user);
+    return (user->flags & USERFLAG_GOD_MODE);
+}
+
+int getChannelAccess(struct UserNode *user, struct ChanNode *chan, int override) {
+    if(!(user->flags & USERFLAG_ISAUTHED)) return 0;
+    loadChannelSettings(chan);
+    if(!(chan->flags & CHANFLAG_CHAN_REGISTERED)) return 0;
+    MYSQL_RES *res;
+    MYSQL_ROW row;
+    check_mysql();
+    int caccess = 0;
+    printf_mysql_query("SELECT `user_id`, `user_access`, `user_god` FROM `users` WHERE `user_user` = '%s'", escape_string(user->auth));
+    res = mysql_use();
+    if ((row = mysql_fetch_row(res)) != NULL) {
+        if(strcmp(row[2], "0") && override) 
+            caccess = atoi(row[1]);
+        printf_mysql_query("SELECT `chanuser_access`, `chanuser_flags` FROM `chanusers` WHERE `chanuser_uid` = '%s' AND `chanuser_cid` = '%d'", row[0], chan->channel_id);
+        //
+        res = mysql_use();
+        if ((row = mysql_fetch_row(res)) != NULL) {
+            if(!(atoi(row[1]) & DB_CHANUSER_SUSPENDED) && atoi(row[0]) > caccess)
+                caccess = atoi(row[0]);
+        }
+        return caccess;
+    }
+    return 0;
+}
+
+int checkChannelAccess(struct UserNode *user, struct ChanNode *chan, char *channel_setting, int allow_override, int allow_501) {
+    loadChannelSettings(chan);
+    if(!(chan->flags & CHANFLAG_CHAN_REGISTERED)) return 0;
+    MYSQL_RES *res;
+    MYSQL_ROW row;
+    printf_mysql_query("SELECT `%s` FROM `channels` WHERE `channel_id` = '%d'", channel_setting, chan->channel_id);
+    res = mysql_use();
+    if ((row = mysql_fetch_row(res)) == NULL) return 0;
+    int require_access = atoi(row[0]);
+    if(require_access == 0) return 1;
+    if(!(user->flags & USERFLAG_ISAUTHED)) return 0;
+    int caccess = 0;
+    printf_mysql_query("SELECT `user_id`, `user_access`, `user_god` FROM `users` WHERE `user_user` = '%s'", escape_string(user->auth));
+    res = mysql_use();
+    if ((row = mysql_fetch_row(res)) != NULL) {
+        printf_mysql_query("SELECT `chanuser_access`, `chanuser_flags` FROM `chanusers` WHERE `chanuser_uid` = '%s' AND `chanuser_cid` = '%d'", row[0], chan->channel_id);
+        res = mysql_use();
+        if ((row = mysql_fetch_row(res)) != NULL) {
+            if(!(atoi(row[1]) & DB_CHANUSER_SUSPENDED))
+                caccess = atoi(row[0]);
+        }
+    }
+    if(caccess >= require_access) return 1;
+    if(caccess == 500 && require_access == 501 && allow_501) return 1;
+    return 0;
+}
+
+void _loadChannelSettings(struct ChanNode *chan) {
+    check_mysql();
+    MYSQL_RES *res;
+    MYSQL_ROW row;
+    printf_mysql_query("SELECT `channel_id` FROM `channels` WHERE `channel_name` = '%s'", escape_string(chan->name));
+    res = mysql_use();
+    if ((row = mysql_fetch_row(res)) != NULL) {
+        chan->flags |= CHANFLAG_CHAN_REGISTERED;
+        chan->channel_id = atoi(row[0]);
+    }
+    chan->flags |= CHANFLAG_REQUESTED_CHANINFO;
+}
+
+