public function getByAppID__3600_screenshots($app_id) { $query = new Query('SELECT'); $query->where('app_id = ?', $app_id); $query->orderby('id', 'ASC'); return ScreenshotBean::select($query); }
public function getValue($key) { $q = new Query("SELECT"); $q->where("key = ?", $key); $q->limit(1); $q->orderby("id", "DESC"); $cvbs = ConfigValueBean::select($q); $cvb = $cvbs[0]; $data = unserialize($cvb->data); return $data; }
public function getByAppID__300_applinks($app_id, $activeonly = true) { $query = new Query('SELECT'); $query->where('lnk.app_id = ?', $app_id); if ($activeonly) { $query->where('lnk.active = ?', 1); } $query->orderby('lnk_ver.intversion', 'DESC'); $query->orderBy('lnk.date_added', 'DESC'); return AppLinkBean::select($query, array('version' => false, 'submitter' => false)); }
public function retrieve($key, $moduleNamespace) { $moduleNamespace = str_replace("\\", "*", $moduleNamespace); $q = new Query("SELECT"); $q->where("module = ?", $moduleNamespace); $q->where("title = ?", $key); $q->limit(1); $q->orderby("id", "DESC"); $mdbs = ModuleDataBean::select($q); $mdb = $mdbs[0]; $data = unserialize($mdb->data); return $data; }
public function getByITunesID__600_appdetails($itunes_id, $version = false) { $query = new Query('SELECT'); $fields = AppVersionBean::getFields(); foreach ($fields as $field) { $query->field('v.' . $field); } $query->from('applications', 'a'); $query->join('versions', 'v', 'LEFT'); $query->on('a.id = v.app_id'); $query->where('a.itunes_id = ?', $itunes_id); if ($version) { $query->where('v.version = ?', $version); } $query->orderby('v.intversion', 'ASC'); $stmt = $query->prepare(); $stmt->execute(); $vers = array(); while ($ver = $stmt->fetchAssoc()) { $vers[] = new AppVersionBean(false, $ver); } return $vers; }
public function getAll__3600() { $query = new Query('SELECT'); $query->orderby('category_name', 'ASC'); return AppCategoryBean::select($query); }
$stmt = $query->prepare(); $stmt->execute(); $obj = $stmt->fetchObj(); $count = $obj->count; echo "Starting indexing for {$count} apps...<br />\n"; // Loop it! $i = 0; $sindex = array(); $cm = RECacheManager::getInstance(); $am = ApplicationModel::getInstance(); while ($i < $count) { $query = new Query('SELECT'); $query->field('id'); $query->field('name'); $query->from('applications'); $query->orderby('name', 'ASC'); $query->limit(500, $i); $stmt = $query->prepare(); $stmt->execute(); while ($row = $stmt->fetchAssoc()) { echo "{$row['name']} ({$row['id']}): "; $i++; $name = $row['name']; $app_id = $row['id']; // Pull out the words we'll need to index $iwords = $am->getIndexable($name); // Add 'em if (count($iwords) > 0) { echo "Indexing: " . implode(', ', $iwords) . "<br />\n"; foreach ($iwords as $iword) { $sindex[$iword][] = $app_id;
/** * Gets the number of messages specified in $count * that are immediately before the given timestamp * * @param integer $timestamp unix epoch timestamp * @param integer $count number of messages to get * @return array array of ChannelActionBean objects latest * first */ public function getMessagesBeforeTimestamp($timestamp, $count) { $query = new Query("SELECT"); $query->where("channel_name = ?", Config::getVal("general", "channel")); $query->where("time < ?", $timestamp); $query->orderby("time", "DESC"); $query->limit($count); $messages = ChannelActionBean::select($query); return $messages; }
public function getAppList($perpage, $page, $sort = 'relevance', $cat = 0, $filter = false, $app_ids = false, $itunes_ids = false, $overrideStartWith = false, $fullinfo = false) { $query = new Query('SELECT'); if (($filter = trim($filter)) == '') { $filter = false; } switch ($sort) { case 'appname': $query->orderby('app.name', 'ASC'); break; case 'newapps': $query->orderby('app.date_added', 'DESC'); break; case 'relevance': if ($filter) { $query->orderby('namematch', 'DESC'); $query->orderby('score', 'DESC'); break; } case 'newvers': default: $sort = 'newvers'; $query->orderby('latest_version_added', 'DESC'); } $query->limit($perpage, $overrideStartWith ?: $perpage * ($page - 1)); $inclids = array(); if ($filter) { $inclids = $this->getMatchedIDs($filter); $newfilter = $this->processFilter($filter); if ($sort == 'relevance') { $query->field('CASE when name like ? then 1 else 0 END', 'namematch', '%' . $filter . '%'); $query->field('MATCH(app.name, app.description) AGAINST(? IN BOOLEAN MODE)', 'score', $newfilter); } $query->whereOpenGroup('AND'); $query->where('MATCH(app.name, app.description) AGAINST(? IN BOOLEAN MODE)', $newfilter); foreach ($inclids as $inclid) { $query->where('app.id = ?', $inclid, 'OR'); } $query->whereCloseGroup(); } if ($cat > 0) { $query->where('app.category_id = ?', $cat); } if ($app_ids) { if (is_array($app_ids)) { $query->whereOpenGroup('AND'); foreach ($app_ids as $app_id) { $query->where('app.id = ?', $app_id, 'OR'); } $query->whereCloseGroup(); } else { $query->where('app.id = ?', $app_id); } } if ($itunes_ids) { if (is_array($itunes_ids)) { $query->whereOpenGroup('AND'); foreach ($itunes_ids as $itunes_id) { $query->where('app.itunes_id = ?', $itunes_id, 'OR'); } $query->whereCloseGroup(); } else { $query->where('app.itunes_id = ?', $itunes_id); } } if ($fullinfo) { $result = ApplicationBean::select($query, true); } else { $result = ShortAppBean::select($query, true); } if (!$result) { return false; } return $result; }