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