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; }
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."); } $acracker = array(); while ($row = $stmt->fetchAssoc()) { $acracker[$row['app_id']] = $row['cracker']; } echo "Got crackers.<br />\n"; ob_flush(); flush();