public function __construct() { adminGateKeeper(); $name = pageArray(2); if ($name != "user") { $query = "DELETE FROM `entities` WHERE `type` = '{$name}'"; Dbase::query($query); $query = "DROP TABLE `{$name}`"; Dbase::query($query); Systemvariable::set("setup_complete", "false"); clearCache(); Cache::clear(); Cache::clear(); Cache::clear(); new SystemMessage("Your table has been deleted."); } forward(); }
public function __construct() { adminGateKeeper(); $admin_guids = getAdminGuidArray(); $admin_guids = implode(",", $admin_guids); $name = pageArray(2); $query = "DELETE FROM `entities` WHERE `type` = '{$name}' AND `guid` NOT IN ({$admin_guids})"; Dbase::query($query); if ($name != "User") { $query = "DELETE FROM `{$name}`"; } else { $query = "DELETE FROM `{$name}` WHERE `guid` NOT IN ({$admin_guids})"; } Dbase::query($query); clearCache(); Cache::clear(); Cache::clear(); Cache::clear(); Systemvariable::set("setup_complete", "false"); new SystemMessage("Your table has been purged."); forward(); }
static function addColumn($column, $type) { $type = strtolower($type); $columns = Cache::get("table_columns", "site"); if (!$columns) { $columns = array(); } if (!isset($columns[$type][$column])) { $columns[$type][] = $column; $query = "ALTER TABLE `{$type}` ADD `{$column}` VARCHAR(50);"; Dbase::query($query); } return true; }
private static function TriggerAlerts($module, $action) { global $currentuser, $currentorg; if (!$currentuser || !$currentorg) { return; } $user_id = $currentuser->user_id; $org_id = $currentorg->org_id; $db = new Dbase('stores'); $sql = "SELECT nc.*, o.name as org_name FROM notification_configs nc\n\t\t\t\tJOIN actions a ON a.id = nc.action_id\n\t\t\t\tJOIN modules m ON m.id = a.module_id\n\t\t\t\tJOIN user_management.organizations o ON o.id = {$org_id}\n\t\t\t\tWHERE m.code = '{$module}' AND a.code = '{$action}' AND nc.org_id = {$org_id}"; $result = $db->query_firstrow($sql); if ($result) { $report_to = json_decode($result['report_to'], true); $send_sms = $result['send_sms'] == 'YES' ? true : false; $send_email = $result['send_email'] == 'YES' ? true : false; $action_id = $result['action_id']; $apache_thread_id = $_SERVER['UNIQUE_ID']; $org_name = $result['org_name']; $user_name = $currentuser->username; $time = date('Y-m-d G:i:s'); $sql = "INSERT INTO access_logs\n\t\t\t\t\t(action_id, params, user_id, org_id, time, apache_thread_id)\n\t\t\t\t\tVALUES\n\t\t\t\t\t({$action_id}, '', {$user_id}, {$org_id}, NOW(), '{$apache_thread_id}')"; $ret = $db->insert($sql); $subject = "{$module} / {$action} accessed by {$user_name}"; $msg = "The user {$user_name} from {$org_name} has accessed {$module} / {$action} at {$time}"; $sql = "SELECT mobile, email FROM user_management.users WHERE id IN (" . Util::joinForSql($report_to) . ")"; $result = $db->query($sql); foreach ($result as $row) { if ($send_email) { Util::sendEmail($row['email'], $subject, $msg, $org_id); } if ($send_sms) { Util::sendSms($row['mobile'], $msg, $org_id); } } } }
function runDbaseQuery($query) { return Dbase::query($query); }
public function delete() { Cache::delete("entity_" . $this->guid); $guid = $this->guid; $query = "DELETE FROM `" . strtolower($this->type) . "` WHERE `guid`='{$this->guid}'"; Dbase::query($query); $query = "DELETE FROM `entities` WHERE `id`='{$this->guid}'"; Dbase::query($query); $tables = Dbase::getAllTables(); foreach ($tables as $table) { $query = "DELETE FROM {$table} WHERE `owner_guid` = '{$this->guid}'"; Dbase::query($query); $query = "DELETE FROM {$table} WHERE `container_guid` = '{$this->guid}'"; Dbase::query($query); } return true; }