/**
  * Gets the historical journal for an object from the log database.
  * Objects will have VirtualAttributes available to lookup login, date, and action information from the journal object.
  * @param integer intSettingId
  * @return AdminSetting[]
  */
 public static function GetJournalForId($intSettingId)
 {
     $objDatabase = AdminSetting::GetDatabase()->JournalingDatabase;
     $objResult = $objDatabase->Query('SELECT * FROM admin_setting WHERE setting_id = ' . $objDatabase->SqlVariable($intSettingId) . ' ORDER BY __sys_date');
     return AdminSetting::InstantiateDbResult($objResult);
 }
Esempio n. 2
0
    /**
     * Truncate admin_setting table
     * @return void
     */
    public static function Truncate()
    {
        // Get the Database Object for this Class
        $objDatabase = AdminSetting::GetDatabase();
        // Perform the Query
        $objDatabase->NonQuery('
				TRUNCATE `admin_setting`');
    }