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();
