public function getInstance() { if (self::$instance == null) { self::$instance = new SDB(); } return self::$instance; }
public static function getActiveApp($user) { $aid = isset($_REQUEST['aid']) ? $_REQUEST['aid'] : null; if ($aid === null) { $domain = App::$SDBDomain; $aaa = array(); foreach (App::$SDBFields as $field => $meta) { $aaa[] = $field; } $uid = $user->id; $where = "where `uid` = '{$uid}' limit 1"; $sdb = SDB::getInstance(); if (!$sdb->select($domain, $aaa, $where, false)) { return null; } $app = new App(); foreach (App::$SDBFields as $field => $meta) { $app->{$field} = $aaa[0][$field]; } $app->id = $aaa[0]['id']; } else { $app = new App($aid); } return $app; }
private function __construct() { try { self::$instance = new PDO('mysql:dbname=' . self::DBNAME . ';host=' . self::HOSTNAME, self::USERNAME, self::PASSWORD, array(PDO::ATTR_AUTOCOMMIT => false)); } catch (PDOException $e) { self::$instance = null; throw new Exception('PDOException', 4); } }
function delete() { $id = $this->id; // fb("sdbo - delete $this->id"); $domain = $this->getSDBDomain(); $this->sdb = SDB::getInstance(); $fields = array('deleted' => date('Y-m-d')); // Soft delete $this->sdb->put($domain, $id, $fields, true); // $this->sdb->delete($domain, $id); }
public function __construct() { try { $this->db =& SDB::get_instance(); $this->set_properties(); if ($this->relationships) { $this->set_relation_properties($this->relationships); } } catch (Exception $e) { throw $e; } }
function multiSite2_showSite() { global $TEMPSDB; global $_GET; $site = multiSite2_getSite(); $path = SDB::getValue(SDB::read($TEMPSDB), $site); $plugin = $_GET["plugin"]; if (file_exists("plugins/" . $plugin . "/" . $path)) { return "plugins/" . $plugin . "/" . $path; } else { echo "Unknown site"; return FALSE; } }
function moreColumns_deleteValue($tableName, $id) { if (!file_exists("sdbs/{$tableName}/")) { return false; } $columns = scandir("sdbs/{$tableName}/"); foreach ($columns as $entry) { if ($entry != "." && $entry != ".." && $entry != ".DS_Store" && $entry != ".htaccess" && $entry != ".htdocs") { $file = "{$tableName}/{$entry}"; SDB::deleteValue($file, $id); } } return true; }
protected function add_column($table, $column, $data_type, $options = array()) { $cmd = new SDBCommand('ALTER TABLE @table ADD @column '); $cmd->set('table', $table, SDB::TableName); $cmd->set('column', $column, SDB::FieldName); if (array_key_exists(strtolower($data_type), $this->_type_mappings)) { $data_type = $this->_type_mappings[strtolower($data_type)]; if (is_array($data_type)) { $options = $options + $data_type[1]; $data_type = $data_type[0]; } } if (array_key_exists(strtolower($data_type), $this->_type_defaults)) { $options = $options + $this->_type_defaults[strtolower($data_type)]; } $cmd->command .= strtoupper($data_type); if (strtolower($data_type) == 'enum') { $values = array(); if (array_key_exists('values', $options)) { $values = $options['values']; } elseif (array_key_exists('options', $options)) { $values = $options['options']; } if (!is_array($values) || !count($values)) { throw new Exception('Invalid enum values'); } foreach ($values as &$val) { $val = SDB::quote($val); } $cmd->command .= '(' . join(',', $values) . ')'; } elseif (array_key_exists('size', $options) && $options['size'] > 0) { $cmd->command .= '(' . $options['size'] . ')'; } if (array_key_exists('unsigned', $options) && $options['unsigned']) { $cmd->command .= ' UNSIGNED'; } $cmd->command .= array_key_exists('null', $options) && $options['null'] ? ' NULL' : ' NOT NULL'; $cmd->execute(); }
static function check_init() { if (!count(SDB::get_tables_list())) { $sql = file_get_contents(BASE . 'conf/simple.' . conf('db.type') . '.sql'); if (conf('db.type') == 'mysql') { $spl = explode(';', $sql); foreach ($spl as $part) { $cmd = new SDBCommand($part); $cmd->execute(); } } else { $cmd = new SDBCommand($sql); $cmd->execute(); } SDB::reset_cached_data(); $fl = new FileItem(); $fl->parent_id = 0; $fl->name = 's'; $fl->type = FileItem::Folder; $fl->save(); Initiator::fill_db(S_BASE, $fl->id); } }
public function createSubmit() { $name = isset($_POST['name']) ? $_POST['name'] : ''; $description = isset($_POST['description']) ? $_POST['description'] : ''; $type = isset($_POST['type']) ? $_POST['type'] : HouseAd::HOUSEAD_TYPE_ICON; $link = isset($_POST['link']) ? $_POST['link'] : ''; $linkType = isset($_POST['linkType']) ? $_POST['linkType'] : HouseAd::HOUSEAD_LINKTYPE_WEBSITE; $imageLink = isset($_POST['imageLink']) ? $_POST['imageLink'] : ''; $houseAd = new HouseAd(); $houseAd->id = SDB::uuid(); $houseAd->uid = $_SESSION['uid']; $houseAd->name = $name; $houseAd->description = $description; $houseAd->type = $type; $houseAd->link = HouseAdUtil::getFixedLink($link, $linkType); $houseAd->linkType = $linkType; $houseAd->launchType = HouseAdUtil::getLaunchType($linkType); $houseAd->imageLink = $imageLink; $result = $houseAd->put(); $aids_of_apps_to_add = isset($_POST['apps']) ? $_POST['apps'] : null; AppHouseAdUtil::addRemoveAppHouseAds($houseAd->id, $aids_of_apps_to_add, array()); fb($houseAd); $this->redirect($_REQUEST['returnPage'] . '?&n_cid=' . $houseAd->id . '&n_name=' . $houseAd->name . '&n_type=' . $houseAd->type . '&n_linkType=' . $houseAd->linkType); }
public static function getNetworksByAidIndexNid($aid) { $sdb = SDB::getInstance(); $domain = Network::$SDBDomain; $aaa = array(); foreach (Network::$SDBFields as $field => $meta) { $aaa[] = $field; } $where = "where `aid` = '{$aid}'"; if (!$sdb->select($domain, $aaa, $where)) { return null; } $appNetworks = array(); foreach ($aaa as $aa) { $appNetwork = new Network(); foreach (Network::$SDBFields as $field => $meta) { $appNetwork->{$field} = $aa[$field]; } $appNetwork->id = $aa['id']; $appNetwork->postGet(); $appNetworks[$appNetwork->id] = $appNetwork; } return $appNetworks; }
<?php if (!count(SDB::get_tables_list())) { $sql = file_get_contents(BASE . '../common/examples.' . conf('db.type') . '.sql'); if (conf('db.type') == 'mysql') { $spl = explode(';', $sql); foreach ($spl as $part) { $cmd = new SDBCommand($part); $cmd->execute(); } } else { $cmd = new SDBCommand($sql); $cmd->execute(); } SDB::reset_cached_data(); }
protected function update_positions($position = 0) { $parent_childs = $this->parent_node == null ? self::get_root_nodes() : $this->parent_node->childs; $replace_data = array(); $pos = 1; foreach ($parent_childs as $nd) { if ($nd->id != $this->id) { if ($pos == $position) { $pos++; } if ($nd->position != $pos) { $replace_data[] = sprintf("(%s,%s,%s,%s,%s,%s,%s)", SDB::quote($nd->id), SDB::quote($nd->path), SDB::quote($nd->name), SDB::quote($nd->title), SDB::quote($nd->type), SDB::quote($nd->flags), SDB::quote($pos)); } $pos++; } } if (count($replace_data)) { $cmd = new SDBCommand("REPLACE INTO `nodes` (`id`,`path`,`name`,`title`,`type`,`flags`,`position`) VALUES " . join(',', $replace_data)); $cmd->execute(); } return $pos; }
public static function getAppsByCid($cid) { $sdb = SDB::getInstance(); $domain = self::$SDBDomain_JOIN_AID; $aaa = array(); foreach (self::$SDBFields_JOIN_AID as $field => $meta) { $aaa[] = $field; } $where = "where `cid` = '{$cid}'"; if (!$sdb->select($domain, $aaa, $where)) { return null; } $apps = array(); foreach ($aaa as $aa) { $aid = $aa['aid']; $weight = $aa['weight']; $app = new App($aid); if ($app != null) { $apps[] = $app; } } return $apps; }
<?php if (!isset($permittedCall)) { echo "Please don't open this page directly!"; exit; } SDB::requireSDB("examplePlugin.sdb", "http://bennetthollstein.de/files/synchro/plugins/examplePlugin/examplePlugin.sdb"); // Include the scriptfile (site.script.php) include scriptfile(); // Include the packages include package("ownLog"); include package("multiSite2"); include package("tiles"); multiSite2_addPage("main", "pages/main.php"); multiSite2_addPage("test", "pages/test.php"); multiSite2_addPage("packageTester", "pages/packageTester.php"); include multiSite2_showSite();
public function adjustHouseAdNetwork($add_ahid, $del_ahid) { $retVal = "doNothing"; fb("adjusthouseAdNet", "start"); $networks = $this->getNetworks(); if ($networks != null) { foreach ($networks as $type => $network) { if ($type == Network::NETWORK_TYPE_HOUSE) { $houseAdNet = $network; } } } $appHouseAds = AppHouseAdUtil::getAppHouseAdsByAid($this->id); $count = count($appHouseAds); if ($count == 0 && $add_ahid != null) { $count++; } else { if ($count == 1 && $appHouseAds['0']->id == $del_ahid) { $count--; } } fb("appHouseAds", $appHouseAds); fb($count, 'count'); fb(isset($houseAdNet), 'hasHouseAdNet'); if ($count > 0 && !isset($houseAdNet)) { // add houseAdNet fb("Should Add"); $network = new Network(); $network->id = SDB::uuid(); $network->aid = $this->id; $network->type = Network::NETWORK_TYPE_HOUSE; $network->adsOn = 0; $network->weight = 0; $network->priority = 99; $network->keys = array("_CUSTOMS_"); $network->put(); $retVal = "add"; } else { if ($count == 0 && isset($houseAdNet)) { // should remove or turn off $hasHouseAds = count(HouseAdUtil::getHouseAdsByUid($_SESSION['uid'])) > 0; if ($hasHouseAds) { fb("should turn off"); $houseAdNet->adsOn = 0; $houseAdNet->put(); $retVal = "turnOff"; } else { fb("Should Remove", $houseAdNet); $houseAdNet->delete(); unset($networks['9']); $retVal = "delete"; } App::setWeights($networks); App::setPriorities($networks); } } fb("adjustHouseAdNet", "end"); return $retVal; }
public static function confirmUser($uid) { $sdb = SDB::getInstance(); $aaa = array('email', 'firstName', 'lastName', 'password', 'allowEmail'); $sdb->select(self::$DOMAIN_USERS_UNVERIFIED, $aaa, "where itemName() = '{$uid}' limit 1", false); if (empty($aaa[0])) { return false; } $user = new User(); $user->id = $uid; $user->email = $aaa[0]['email']; $user->password = $aaa[0]['password']; $user->allowEmail = $aaa[0]['allowEmail']; $user->firstName = $aaa[0]['firstName']; $user->lastName = $aaa[0]['lastName']; $user->put(); return true; }
public function __construct($command = '', $db = null) { $this->command = $command; $this->db = $db !== null ? $db : SDB::get_current(); }
protected function _init_fields() { if (count($this->_db_fields)) { return; } $this->_init_table(); $cols = SDB::get_table_columns($this->_db_table); foreach (get_object_vars($this) as $prop => $val) { if ($prop[0] == '_' || $prop == $this->_db_key || is_array($val) || is_object($val) || $val === null) { continue; } if (!array_key_exists($prop, $cols)) { throw new Exception("Table '{$this->_db_table}' doesn't have field '{$prop}'"); } $this->map_field($prop, $prop, $cols[$prop]['t'], $cols[$prop]['s']); } // map _db_key here, because get_object_vars not returns virtual properties $this->map_field($this->_db_key, $this->_db_key, $cols[$this->_db_key]['t'], $cols[$this->_db_key]['s']); }
public static function invalidateCustom($nid) { $sdb = SDB::getInstance(); $aa = array('dateTime' => gmdate('Y-m-d, H:i:s')); $sdb->put(HouseAd::$SDBDomainInvalid, $nid, $aa, true); }
function require_SDB($name, $dlurl) { return SDB::requireSDB($name, $dlurl); }
public static function delete($entry) { return SDB::deleteValue(REGISTRY, $entry, ";;"); }
protected function getDBConnect() { if ($this->_connect) { return $this->_connect; } $db = new SDB(); $this->_connect = $db->getInstance(); return $this->_connect; }
public function createSubmit() { if (isset($_REQUEST['n_aid']) || !isset($_REQUEST['name'])) { $this->redirect('/apps/apps'); } $this->printHeader = false; $this->printFooter = false; $name = $_POST['name']; $storeUrl = $_POST['storeUrl']; $platform = $_POST['platform']; $fgColor = $_POST['fgColor']; $bgColor = $_POST['bgColor']; $cycleTime = $_POST['cycleTime']; $transition = $_POST['transition']; $locationOn = $_POST['locationOn']; $app = new App(); $app->id = SDB::uuid(); $app->uid = $this->user->id; $app->name = $name; $app->storeUrl = $storeUrl; $app->platform = $platform; $app->fgColor = $fgColor; $app->bgColor = $bgColor; $app->cycleTime = $cycleTime; $app->transition = $transition; $app->locationOn = $locationOn; $app->adsOn = 1; $app->put(); $_POST['aid'] = $app->id; // before finishing, check to see if the new app has been added to th SDB $sdb = SDB::getInstance(); // sleeps for half a second until we see an entry for this id $fields = "name"; while (!$sdb->get($app->getSDBDomain(), $app->id, $fields)) { $fields = "name"; // necessary since get overwrites $fields usleep(500); } }
public static function getAppHouseAdsByCid($cid) { $sdb = SDB::getInstance(); $domain = self::$SDBDomain; $aaa = array(); foreach (self::$SDBFields as $field => $meta) { $aaa[] = $field; } $where = "where `cid` = '{$cid}'"; if (!$sdb->select($domain, $aaa, $where)) { return null; } $appHouseAds = array(); foreach ($aaa as $aa) { $id = $aa['id']; $appHouseAd = new AppHouseAd($id); if ($appHouseAd != null) { $appHouseAds[] = $appHouseAd; } } return $appHouseAds; }
public static function getNetworkReportsByUid($uid, $startDate, $endDate) { $sdb = SDB::getInstance(); $apps = AppUtil::getAppsByUid($uid); $reports = array(); foreach ($apps as $app) { $aid = $app->id; $aaa = array($groupBy, 'clicks', 'impressions', 'dateTime'); $sdb->select(Report::$SDBDomain, $aaa, "where `aid` = '{$aid}' and `dateTime` >= '{$startDate}' and `dateTime` <= '{$endDate}'"); if (empty($aaa)) { continue; } foreach ($aaa as $aa) { $dateTime = $aa['dateTime']; $type = $aa[$groupBy]; $clicks = $aa['clicks']; $impressions = $aa['impressions']; $reports['types'][$type] = 1; if (isset($reports[$dateTime][$type])) { $reports[$dateTime][$type]['clicks'] += $clicks; $reports[$dateTime][$type]['impressions'] += $impressions; } else { $reports[$dateTime][$type]['clicks'] = $clicks; $reports[$dateTime][$type]['impressions'] = $impressions; } if (isset($reports[$dateTime][0])) { $reports[$dateTime][0]['clicks'] += $clicks; $reports[$dateTime][0]['impressions'] += $impressions; } else { $reports[$dateTime][0] = array(); $reports[$dateTime][0]['clicks'] = $clicks; $reports[$dateTime][0]['impressions'] = $impressions; } } return $reports; } }