/** * Diese statische Methode bestimmt, in welchem Newsletter der uebergebene * Newsletter-Entry ist. * @param int $entry_id die ID des Newsletter-Eintrags * @return int die ID des Newsletters oder <i>null</i> */ public static function get_newsletter_id_for_entry($entry_id) { $rueckgabe = null; $db = new DbPdo(); $sql = "SELECT newsletterContId FROM " . PREFIX . "newsletterEntries WHERE id=:entry_id;"; $erg = $db->prepare_and_execute($sql, array("entry_id" => $entry_id)); if (is_array($erg) && count($erg) == 1) { $rueckgabe = $erg[0]['newsletterContId']; } return $rueckgabe; }
public static function getDefaultUserGroupForNewUsers() { $db = new DbPdo(); $sql = "SELECT * FROM " . PREFIX . "newsletterGroups WHERE specialGroup=?;"; $result = $db->prepare_and_execute($sql, array(self::NEWSLETTER_GROUP_TYPE_NEW_USERS)); if (isset($result[0]['id'])) { return $result[0]['id']; } return false; }
/** * Hilfsfunktion zum Auslesen aller noch "unerledigten" Updates * @param string $update_dir absoluter Pfad zum Updates-Verzeichnis * @param DbPdo $db eine offene Datenbankverbindung * @return array list of filenames */ function get_updates_to_do($update_dir, $db) { $filenames = array(); // get all available updates from updates directory $update_dir_handle = opendir($update_dir); if ($update_dir_handle) { $filenames['update_files'] = array(); while ($update_file = readdir($update_dir_handle)) { if ($update_file != "update.css" && !is_dir($update_file) && $update_file[0] != ".") { $filenames['update_files'][] = $update_file; } } } unset($update_file); closedir($update_dir_handle); // set defaults for backwards compatibility $filenames['migrations_done'] = array(); $filenames['updates_to_do'] = $filenames['update_files']; if ($db->table_exists("migrations")) { $sql = "SELECT * FROM " . PREFIX . "migrations"; $result = $db->prepare_and_execute($sql); $filenames['migrations_done'] = array(); foreach ($result as $migration_done) { $filenames['migrations_done'][] = $migration_done['filename']; } $filenames['updates_to_do'] = array_diff($filenames['update_files'], $filenames['migrations_done']); } sort($filenames['updates_to_do']); sort($filenames['update_files']); sort($filenames['migrations_done']); return $filenames; }