public static string GetBulletinGuid(string bulletin_name) { string _sql = @"select top 1 guid from RM_ResourceSoftware_Bulletin where Name = '{0}'"; string sql = String.Format(_sql, bulletin_name); try { return(DatabaseAPI.ExecuteScalar(sql).ToString()); } catch { return(""); } }
public bool procedure_installed() { string test_sql = @"select count(*) from sysobjects where type = 'P' and name = 'ZeroDayPatch_GetVulnerableMachines-" + Constant.ZERODAY_SCHEMA_VERSION + "'"; if ((int)DatabaseAPI.ExecuteScalar(test_sql) == 1) { return(true); } DatabaseAPI.ExecuteNonQuery(Constant.ZERODAY_GET_VULNERABLE); foreach (string legacy_sp in legacy_spnames) { string clean_legacy = "if exists (select 1 from sysobjects where type = 'P' and name = '" + legacy_sp + "') " + "begin " + "drop proc [" + legacy_sp + "] " + "end"; Console.WriteLine("Making sure legacy stored procedure {0} is not present.", legacy_sp); DatabaseAPI.ExecuteNonQuery(clean_legacy); } return(true); }