protected override ModInfo LoadDefaultConfig(ModController controller)
        {
            Dictionary<string, string> settings = new Dictionary<string, string>
                                                  {
                                                      {
                                                          "EventAdminRoles",
                                                          "Administrator,Moderator"
                                                      },
                                                      {
                                                          "EventShowHolidays","1"
                                                      }
                                                  };
            ModInfo modinfo = new ModInfo
            {
                Id = -1,
                Name = "Events",
                Description = "Events Calendar",
                Version = new Version(1, 0),
                Enabled = true,
                AdminControl = "EventsAdmin.ascx",
                Settings = new Hashtable(settings)
            };

            controller.ModInfo = modinfo;
            controller.InstallMod();
            return modinfo;
        }
Example #2
0
        public int Add(ModInfo modinfo)
        {
            string insertSql = "INSERT INTO " + Config.FilterTablePrefix +
                "MODS_CONFIG (MOD_NAME,MOD_DESCRIPTION,MOD_VERSION,MOD_ENABLED,MOD_ROLES) VALUES (@Name,@Description,@Version,@Enabled,@Roles ); SELECT SCOPE_IDENTITY();";
            List<SqlParameter> parms = new List<SqlParameter>
                {
                    new SqlParameter("@Name", SqlDbType.NVarChar) {Value = modinfo.Name},
                    new SqlParameter("@Description", SqlDbType.NVarChar) {Value = modinfo.Description},
                    new SqlParameter("@Version", SqlDbType.NVarChar) {Value = modinfo.Version.ToString()},
                    new SqlParameter("@Enabled", SqlDbType.Bit) {Value = modinfo.Enabled},
                    new SqlParameter("@Roles", SqlDbType.NVarChar) {Value = (object)modinfo.Roles??DBNull.Value}
                };
            int modid = Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.ConnString, CommandType.Text, insertSql, parms.ToArray()));

            foreach (DictionaryEntry setting in modinfo.Settings)
            {
                string insSetting = "INSERT INTO " + Config.FilterTablePrefix + "MODS_SETTING (MOD_ID,MOD_SETTING,MOD_VALUE) VALUES (@Id,@Setting,@Value);";
                List<SqlParameter> sparms = new List<SqlParameter>
                {
                    new SqlParameter("@Id", SqlDbType.Int) {Value = modid},
                    new SqlParameter("@Setting", SqlDbType.NVarChar) {Value = setting.Key},
                    new SqlParameter("@Value", SqlDbType.NVarChar) {Value = setting.Value}
                };
                SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, insSetting, sparms.ToArray());
            }

            return modid;
        }
        protected override ModInfo LoadDefaultConfig(ModController controller)
        {
            Dictionary<string, string> settings = new Dictionary<string, string>
                                                  {
                                                      {
                                                          "Url",
                                                          "http://forum.snitz.com/forum/rssfeed2.asp"
                                                      }
                                                  };

            ModInfo modinfo = new ModInfo
            {
                Id = -1,
                Name = "RSSFeed",
                Description = "Displays an RSS feed",
                Version = new Version(1, 1),
                Enabled = true,
                AdminControl = "RSSFeed.ascx",
                Settings = new Hashtable(settings)
            };

            controller.ModInfo = modinfo;
            controller.InstallMod();
            return modinfo;
        }
Example #4
0
        public void Delete(ModInfo modinfo)
        {
            int modid = modinfo.Id;

            string delSql = "DELETE FROM " + Config.FilterTablePrefix + "MODS_SETTING WHERE MOD_ID=@ModId; " +
                            "DELETE FROM " + Config.FilterTablePrefix + "MODS_CONFIG WHERE MOD_ID=@ModId; ";
            SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, delSql, new SqlParameter("@Id", SqlDbType.Int) { Value = modid });
        }
Example #5
0
 protected ModConfigBase(string name)
 {
     this._name = name;
     var controller = new ModController(name);
     this._modinfo = controller.ModInfo ?? LoadDefaultConfig(controller);
     if (_modinfo != null)
     {
         Id = _modinfo.Id;
         Description = _modinfo.Description;
         Version = _modinfo.Version;
         Enabled = _modinfo.Enabled;
     }
     else
     {
         throw new Exception(String.Format("{0} configuration data not defined", name));
     }
 }
Example #6
0
        public ModInfo GetById(int id)
        {
            string strSql = "SELECT MOD_ID,MOD_NAME,MOD_DESCRIPTION,MOD_VERSION,MOD_ENABLED,MOD_ROLES FROM " + Config.ForumTablePrefix + "MODS_CONFIG WHERE MOD_ID = @ModId";
            ModInfo modInfo = null;
            //Execute a query to read the products
            using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnString, CommandType.Text, strSql, new SqlParameter("@ModId", SqlDbType.Int) { Value = id }))
            {
                while (rdr.Read())
                {
                    modInfo = new ModInfo
                    {
                        Id = rdr.GetInt32(0),
                        Name = rdr.SafeGetString(1),
                        Description = rdr.SafeGetString(2),
                        Version = new Version(rdr.SafeGetString(3)),
                        Enabled = rdr.GetBoolean(4),
                        Roles = rdr.SafeGetString(5),
                        Settings = GetModSettings(id)
                    };

                }
            }
            return modInfo;
        }
        protected override ModInfo LoadDefaultConfig(ModController controller)
        {
            //todo: load mod config data from xml file etc

            ModInfo modinfo = new ModInfo
                              {
                                  Id = -1,
                                  Name = "BlogMenu",
                                  Description = "Blog Menu Config",
                                  Version = new Version(1, 0),
                                  Enabled = true,
                                  Settings = null
                              };

            controller.ModInfo = modinfo;
            controller.InstallMod();
            return modinfo;
        }
        protected override ModInfo LoadDefaultConfig(ModController controller)
        {
            Dictionary<string,string> settings = new Dictionary<string, string>
                                                 {
                                                     {"AllowFileUpload", "1"},
                                                     {"AllowImageUpload", "1"},
                                                     {"AllowAttachments", "1"},
                                                     {"ShowFileAttach", "1"},
                                                     {"FileUploadLocation", "/sharedFiles"},
                                                     {"AllowedAttachmentTypes","zip,pdf,txt,doc"},
                                                     {"AllowedImageTypes","jpg,jpeg,gif,png"},
                                                     {"TotalUploadLimitFileSize","100"},
                                                     {"TotalUploadLimitFileNumber", "50"},
                                                     {"FileSizeLimit", "10"}
                                                 };

            ModInfo modinfo = new ModInfo
            {
                Id = -1,
                Name = "FileUpload",
                Description = "File Upload Configuration",
                Version = new Version(1, 0),
                Enabled = true,
                Settings = new Hashtable(settings)
            };

            controller.ModInfo = modinfo;
            controller.InstallMod();
            return modinfo;
        }
Example #9
0
 public IEnumerable<ModInfo> GetByName(string name)
 {
     string strSql = "SELECT MOD_ID,MOD_NAME,MOD_DESCRIPTION,MOD_VERSION,MOD_ENABLED,MOD_ROLES FROM " + Config.ForumTablePrefix + "MODS_CONFIG WHERE MOD_Name = @ModName";
     ModInfo modInfo = null;
     //Execute a query to read the products
     using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnString, CommandType.Text, strSql, new SqlParameter("@ModName", SqlDbType.VarChar) { Value = name }))
     {
         while (rdr.Read())
         {
             int modid = rdr.GetInt32(0);
             modInfo = new ModInfo
             {
                 Id = modid,
                 Name = rdr.SafeGetString(1),
                 Description = rdr.SafeGetString(2),
                 Version = new Version(rdr.SafeGetString(3)),
                 Enabled = rdr.SafeGetInt16(4) == 1,
                 Roles = rdr.SafeGetString(5),
                 Settings = GetModSettings(modid)
             };
         }
     }
     return new[] {modInfo};
 }
Example #10
0
        public void Update(ModInfo modinfo)
        {
            StringBuilder updSql = new StringBuilder("UPDATE ");
            updSql.AppendFormat("{0}MODS_CONFIG SET",Config.FilterTablePrefix).AppendLine();
            updSql.AppendLine("MOD_NAME=@Name,");
            updSql.AppendLine("MOD_DESCRIPTION=@Description,");
            updSql.AppendLine("MOD_VERSION=@Version,");
            updSql.AppendLine("MOD_ENABLED=@Enabled,");
            updSql.AppendLine("MOD_ROLES=@Roles");
            updSql.AppendLine("WHERE MOD_ID=@ModId;");
            List<SqlParameter> parms = new List<SqlParameter>
                {
                    new SqlParameter("@ModId", SqlDbType.Int) {Value = modinfo.Id},
                    new SqlParameter("@Name", SqlDbType.NVarChar) {Value = modinfo.Name},
                    new SqlParameter("@Description", SqlDbType.NVarChar) {Value = modinfo.Description},
                    new SqlParameter("@Version", SqlDbType.NVarChar) {Value = modinfo.Version.ToString()},
                    new SqlParameter("@Enabled", SqlDbType.Bit) {Value = modinfo.Enabled},
                    new SqlParameter("@Roles", SqlDbType.NVarChar) {Value = (object)modinfo.Roles??DBNull.Value}
                };
            SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, updSql.ToString(), parms.ToArray());

            foreach (DictionaryEntry setting in modinfo.Settings)
            {
                updSql.Length = 0;
                updSql.AppendFormat("UPDATE {0}MODS_SETTING SET", Config.FilterTablePrefix).AppendLine();
                updSql.AppendLine("MOD_Value=@Value");
                updSql.AppendLine("WHERE MOD_ID=@ModId AND MOD_SETTING=@Setting;");
                List<SqlParameter> sparms = new List<SqlParameter>
                {
                    new SqlParameter("@ModId", SqlDbType.Int) {Value = modinfo.Id},
                    new SqlParameter("@Value", SqlDbType.NVarChar) {Value = setting.Value},
                    new SqlParameter("@Setting", SqlDbType.NVarChar) {Value = setting.Key}
                };
                SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, updSql.ToString(), sparms.ToArray());
            }
        }
Example #11
0
        protected override ModInfo LoadDefaultConfig(ModController controller)
        {
            Dictionary<string, string> settings = new Dictionary<string, string>
                                                  {
                                                      {"Member Likes","1"},
                                                      {"Topic Likes","1"},
                                                      {"Reply Likes","1"}
                                                  };

            ModInfo modinfo = new ModInfo
            {
                Id = -1,
                Name = "Thanks",
                Description = "Thanks mod",
                Version = new Version(1, 0),
                Enabled = false,
                AdminControl = "ThanksMod.ascx",
                Settings = new Hashtable(settings)
            };

            controller.ModInfo = modinfo;
            controller.InstallMod();
            return modinfo;
        }
        protected override ModInfo LoadDefaultConfig(ModController controller)
        {
            Dictionary<string, string> settings = new Dictionary<string, string>
                                                  {
                                                      {
                                                          "MediaItems",
                                                          "messenger,googlebuzz"
                                                      }
                                                  };

            ModInfo modinfo = new ModInfo
            {
                Id = -1,
                Name = "ShareIt",
                Description = "Share topic on Social Media sites",
                Version = new Version(1, 0),
                Enabled = true,
                Settings = new Hashtable(settings)
            };

            controller.ModInfo = modinfo;
            controller.InstallMod();
            return modinfo;
        }