}
}
if ($appsToDelete) {
$stmt = $query->prepare();
if ($stmt->execute()) {
echo "Done.<br />\n";
} else {
echo "Couldn't delete apps.<br />\n";
}
} else {
echo "No apps to delete.<br />\n";
}
ob_flush();
flush();
if ($versToCorrect) {
$vquery->whereCloseGroup();
echo "Got versions and dates.<br />\n";
// Get all the first crackers for each version with another strawbery query
$vquery->field('v.app_id');
$vquery->field('l1.cracker');
$vquery->from('versions', 'v');
$vquery->join('links', 'l1', 'LEFT');
$vquery->on('v.id = l1.version_id');
$vquery->join('links', 'l2', 'LEFT');
$vquery->on('l1.version_id = l2.version_id');
$vquery->on('l1.date_added > l2.date_added');
$vquery->where('l2.date_added IS NULL');
$stmt = $vquery->prepare();
if (!$stmt->execute()) {
die("You broke shit.");
}
public function getResultCount($cat = 0, $filter = false, $app_ids = false, $itunes_ids = false)
{
$query = new Query('SELECT');
$query->field('COUNT(*)', 'count');
$query->from('applications');
if ($cat > 0) {
$query->where('category_id = ?', $cat);
}
if ($filter) {
$inclids = $this->getMatchedIDs($filter);
$newfilter = $this->processFilter($filter);
$query->whereOpenGroup('AND');
$query->where('MATCH(name, description) AGAINST(? IN BOOLEAN MODE)', $newfilter);
foreach ($inclids as $inclid) {
$query->where('id = ?', $inclid, 'OR');
}
$query->whereCloseGroup();
}
if ($app_ids) {
if (is_array($app_ids)) {
$query->whereOpenGroup('AND');
foreach ($app_ids as $app_id) {
$query->where('id = ?', $app_id, 'OR');
}
$query->whereCloseGroup();
} else {
$query->where('id = ?', $app_id);
}
}
if ($itunes_ids) {
if (is_array($itunes_ids)) {
$query->whereOpenGroup('AND');
foreach ($itunes_ids as $itunes_id) {
$query->where('itunes_id = ?', $itunes_id, 'OR');
}
$query->whereCloseGroup();
} else {
$query->where('tunes_id = ?', $itunes_id);
}
}
$stmt = $query->prepare();
$stmt->execute();
$obj = $stmt->fetchObj();
return $obj->count;
}
