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;
}
