Beispiel #1
1
        private void Build(StringBuilder sb, List<object> args, Sql lhs)
        {
            if (!String.IsNullOrEmpty(_sql))
            {
                // Add SQL to the string
                if (sb.Length > 0)
                {
                    sb.Append("\n");
                }

                var sql = ProcessParams(_sql, _args, args);

                if (Is(lhs, "WHERE ") && Is(this, "WHERE "))
                    sql = "AND " + sql.Substring(6);
                if (Is(lhs, "ORDER BY ") && Is(this, "ORDER BY "))
                    sql = ", " + sql.Substring(9);

                sb.Append(sql);
            }

            // Now do rhs
            _rhs?.Build(sb, args, this);
        }
        object GetName(string userid)
        {
            if (useSQLITE)
            {
                string query = string.Format("SELECT name FROM {0} WHERE steamid = {1} LIMIT 1", "playerdatabase", userid);
                sqlite.Append(query);
                IEnumerable <Dictionary <string, object> > res = Interface.Oxide.GetLibrary <Ext.SQLite.Libraries.SQLite>("SQLite").Query(sqlite, sqconnection);
                foreach (Dictionary <string, object> obj in res)
                {
                    foreach (object value in obj.Values)
                    {
                        if (value != null || value != "")
                        {
                            return(value.ToString());
                        }
                    }
                }
            }
            else if (useMysql)
            {
                string query = string.Format("SELECT name FROM `{0}` WHERE `steamid` = '{1}' LIMIT 1", mysqlTable, userid);
                sql = Interface.Oxide.GetLibrary <Ext.MySql.Libraries.MySql>("MySql").NewSql();
                sql.Append(query);
                IEnumerable <Dictionary <string, object> > res = Interface.Oxide.GetLibrary <Ext.MySql.Libraries.MySql>("MySql").Query(sql, connection);
                foreach (Dictionary <string, object> obj in res)
                {
                    foreach (object value in obj.Values)
                    {
                        if (value != null || value != "")
                        {
                            return(value.ToString());
                        }
                    }
                }
            }
            else
            {
                if (Data[userid] != null && ((Dictionary <string, object>)Data[userid])["name"] != null)
                {
                    return(((Dictionary <string, object>)Data[userid])["name"]);
                }
            }
            if (steamapikey.Length < 5)
            {
                return(null);
            }
            var url = string.Format("https://api.steampowered.com/ISteamUser/GetPlayerSummaries/v0002/?key={0}&steamids={1}", steamapikey, userid);

            Interface.GetMod().GetLibrary <WebRequests>("WebRequests").EnqueueGet(url, (code, response) =>
            {
                var tempnewname = CheckResponse(code, response);
                if (tempnewname != null)
                {
                    SetPlayerData(userid, "name", tempnewname.ToString());
                }
            }
                                                                                  , this);
            return(null);
        }
Beispiel #3
0
        public Sql Append(Sql sql)
        {
            if (_rhs != null)
                _rhs.Append(sql);
            else
                _rhs = sql;

            return this;
        }
        string[] FindAllPlayers(string name)
        {
            var returnlist = new List <string>();

            if (useSQLITE)
            {
                string query = string.Format("SELECT steamid FROM `{0}` WHERE `name` LIKE '%{1}%'", "playerdatabase", name);
                sqlite.Append(query);
                IEnumerable <Dictionary <string, object> > res = Interface.Oxide.GetLibrary <Ext.SQLite.Libraries.SQLite>("SQLite").Query(sqlite, sqconnection);
                foreach (Dictionary <string, object> obj in res)
                {
                    foreach (object value in obj.Values)
                    {
                        returnlist.Add(value.ToString());
                    }
                }
            }
            else if (useMysql)
            {
                string query = string.Format("SELECT steamid FROM `{0}` WHERE `name` LIKE '%{1}%'", mysqlTable, name);
                sql = Interface.Oxide.GetLibrary <Ext.MySql.Libraries.MySql>("MySql").NewSql();
                sql.Append(query);
                IEnumerable <Dictionary <string, object> > res = Interface.Oxide.GetLibrary <Ext.MySql.Libraries.MySql>("MySql").Query(sql, connection);
                foreach (Dictionary <string, object> obj in res)
                {
                    foreach (object value in obj.Values)
                    {
                        returnlist.Add(value.ToString());
                    }
                }
            }
            else
            {
                name = name.ToLower();
                Dictionary <string, object> currenttable;
                foreach (KeyValuePair <string, object> pair in Data)
                {
                    currenttable = pair.Value as Dictionary <string, object>;
                    if (currenttable.ContainsKey("name"))
                    {
                        if (currenttable["name"].ToString().ToLower().Contains(name))
                        {
                            returnlist.Add(pair.Key);
                        }
                    }
                }
            }
            return(returnlist.ToArray());
        }
 object GetPlayerData(string userid, string key)
 {
     if (key == "name")
     {
         return(GetName(userid));
     }
     if (useSQLITE)
     {
         string query = string.Format("SELECT {2} FROM {0} WHERE steamid = {1} LIMIT 1", "playerdatabase", userid, key);
         sqlite.Append(query);
         IEnumerable <Dictionary <string, object> > res = Interface.Oxide.GetLibrary <Ext.SQLite.Libraries.SQLite>("SQLite").Query(sqlite, sqconnection);
         foreach (Dictionary <string, object> obj in res)
         {
             foreach (object value in obj.Values)
             {
                 return(value.ToString());
             }
         }
     }
     else if (useMysql)
     {
         string query = string.Format("SELECT {2} FROM `{0}` WHERE `steamid` = '{1}' LIMIT 1", mysqlTable, userid, key);
         sql = Interface.Oxide.GetLibrary <Ext.MySql.Libraries.MySql>("MySql").NewSql();
         sql.Append(query);
         IEnumerable <Dictionary <string, object> > res = Interface.Oxide.GetLibrary <Ext.MySql.Libraries.MySql>("MySql").Query(sql, connection);
         foreach (Dictionary <string, object> obj in res)
         {
             foreach (object value in obj.Values)
             {
                 return(value.ToString());
             }
         }
     }
     else
     {
         if (Data[userid] == null)
         {
             return(null);
         }
         if (!((Dictionary <string, object>)Data[userid]).ContainsKey(key))
         {
             return(null);
         }
         return(((Dictionary <string, object>)Data[userid])[key]);
     }
     return(null);
 }
        void Loaded()
        {
            if (!permission.PermissionExists("admin"))
            {
                permission.RegisterPermission("admin", this);
            }
            LoadData();
            if (useSQLITE)
            {
                sqconnection = Interface.Oxide.GetLibrary <Ext.SQLite.Libraries.SQLite>("SQLite").OpenDb("PlayerDatabaseSQL");
                sqlite       = Interface.Oxide.GetLibrary <Ext.SQLite.Libraries.SQLite>("SQLite").NewSql();
                sqlite.Append("create table if not exists playerdatabase (name text, steamid text)");
                Interface.Oxide.GetLibrary <Ext.SQLite.Libraries.SQLite>("SQLite").Query(sqlite, sqconnection);
                sqlite.Append("PRAGMA encoding = 'UTF - 8'");
                Interface.Oxide.GetLibrary <Ext.SQLite.Libraries.SQLite>("SQLite").Query(sqlite, sqconnection);
                sqlite.Append("SELECT steamid FROM playerdatabase");

                IEnumerable <Dictionary <string, object> > res = Interface.Oxide.GetLibrary <Ext.SQLite.Libraries.SQLite>("SQLite").Query(sqlite, sqconnection);

                foreach (Dictionary <string, object> obj in res)
                {
                    foreach (object key in obj.Values)
                    {
                        AvaibleUserID.Add(key.ToString());
                    }
                }
                sqlite.Append("SELECT * FROM playerdatabase");
                res = Interface.Oxide.GetLibrary <Ext.SQLite.Libraries.SQLite>("SQLite").Query(sqlite, sqconnection);

                foreach (Dictionary <string, object> obj in res)
                {
                    Debug.Log(obj.ToString());
                    foreach (string key in obj.Keys)
                    {
                        AvaibleKeys.Add(key.ToString());
                    }
                    break;
                }
                if (AvaibleKeys.Count == 0)
                {
                    AvaibleKeys.Add("name");
                    AvaibleKeys.Add("steamid");
                }
            }
            else if (useMysql)
            {
                connection = Interface.Oxide.GetLibrary <Ext.MySql.Libraries.MySql>("MySql").OpenDb(mysqlHost, mysqlPort, mysqlDatabase, mysqlUsername, mysqlPass);
                sql        = Interface.Oxide.GetLibrary <Ext.MySql.Libraries.MySql>("MySql").NewSql();
                sql.Append("SELECT steamid FROM `" + mysqlTable + "`");
                IEnumerable <Dictionary <string, object> > res = Interface.Oxide.GetLibrary <Ext.MySql.Libraries.MySql>("MySql").Query(sql, connection);
                foreach (Dictionary <string, object> obj in res)
                {
                    foreach (object key in obj.Values)
                    {
                        AvaibleUserID.Add(key.ToString());
                    }
                }
                sql = Interface.Oxide.GetLibrary <Ext.MySql.Libraries.MySql>("MySql").NewSql();
                sql.Append("SELECT * FROM `" + mysqlTable + "`");
                res = Interface.Oxide.GetLibrary <Ext.MySql.Libraries.MySql>("MySql").Query(sql, connection);
                foreach (Dictionary <string, object> obj in res)
                {
                    foreach (string key in obj.Keys)
                    {
                        AvaibleKeys.Add(key.ToString());
                    }
                    break;
                }
                if (AvaibleKeys.Count == 0)
                {
                    AvaibleKeys.Add("name");
                    AvaibleKeys.Add("steamid");
                }
            }
        }
        void SetPlayerData(string userid, string key, object value)
        {
            if (useSQLITE)
            {
                string query = string.Empty;
                if (!AvaibleKeys.Contains(key))
                {
                    query = string.Format("ALTER TABLE {0} ADD {1} VARCHAR(255);", "playerdatabase", key);
                    sqlite.Append(query);
                    Interface.Oxide.GetLibrary <Ext.SQLite.Libraries.SQLite>("SQLite").Query(sqlite, sqconnection);
                    AvaibleKeys.Add(key);
                }

                if (!AvaibleUserID.Contains(userid))
                {
                    query = string.Format("INSERT INTO {0} (steamid) VALUES ('{1}');", "playerdatabase", userid);
                    sqlite.Append(query);
                    var test2 = Interface.Oxide.GetLibrary <Ext.SQLite.Libraries.SQLite>("SQLite").Update(sqlite, sqconnection);
                    Debug.Log(test2.ToString());
                    AvaibleUserID.Add(userid);
                }

                query = string.Format("UPDATE {0} SET {2} = '{3}' WHERE steamid = '{1}';", "playerdatabase", userid, key, value.ToString());
                sqlite.Append(query);
                var test = Interface.Oxide.GetLibrary <Ext.SQLite.Libraries.SQLite>("SQLite").Update(sqlite, sqconnection);
                Debug.Log(test.ToString());
            }
            else if (useMysql)
            {
                string query = string.Empty;
                if (!AvaibleKeys.Contains(key))
                {
                    query = string.Format("ALTER TABLE `{0}` ADD `{1}` VARCHAR(255) NOT NULL;", mysqlTable, key);
                    sql   = Interface.Oxide.GetLibrary <Ext.MySql.Libraries.MySql>("MySql").NewSql();
                    sql.Append(query);
                    Interface.Oxide.GetLibrary <Ext.MySql.Libraries.MySql>("MySql").Query(sql, connection);
                    AvaibleKeys.Add(key);
                }

                if (!AvaibleUserID.Contains(userid))
                {
                    query = string.Format("INSERT INTO `{0}` (`steamid`) VALUES('{1}');", mysqlTable, userid);
                    sql   = Interface.Oxide.GetLibrary <Ext.MySql.Libraries.MySql>("MySql").NewSql();
                    sql.Append(query);
                    Interface.Oxide.GetLibrary <Ext.MySql.Libraries.MySql>("MySql").Query(sql, connection);
                    AvaibleUserID.Add(userid);
                }

                query = string.Format("UPDATE `{0}` SET `{2}` = '{3}' WHERE `{0}`.`steamid` = {1};", mysqlTable, userid, key, value.ToString());
                sql   = Interface.Oxide.GetLibrary <Ext.MySql.Libraries.MySql>("MySql").NewSql();
                sql.Append(query);

                Interface.Oxide.GetLibrary <Ext.MySql.Libraries.MySql>("MySql").Query(sql, connection);
            }
            else
            {
                if (Data[userid] == null)
                {
                    Data[userid] = new Dictionary <string, object>();
                }
                if (!((Dictionary <string, object>)Data[userid]).ContainsKey(key))
                {
                    ((Dictionary <string, object>)Data[userid]).Add(key, value);
                }
                else
                {
                    ((Dictionary <string, object>)Data[userid])[key] = value;
                }
            }
        }
Beispiel #8
0
 private static bool Is(Sql sql, string sqltype)
 {
     return sql?._sql != null && sql._sql.StartsWith(sqltype, StringComparison.InvariantCultureIgnoreCase);
 }
Beispiel #9
0
 public SqlJoinClause(Sql sql)
 {
     _sql = sql;
 }