appcast.php

<?PHP
    // This is your basic, run of the mill appcast feed

	require 'includes/master.inc.php';
	require_once 'includes/class.config.php';
	use UnitedPrototype\GoogleAnalytics;

	if (!empty($_GET['id'])) $app = new Application($_GET['id']);
	else {
		$app = new Application();
		$app->select($_GET['abbr'], 'abbreviation');
	}
	if(!$app->ok()) die('Application not found');
	
	$status = VERSION_STATUS_PRODUCTION;
	
	if (!empty($_GET['status'])) {
		$status = $_GET['status'] == 'beta' ? VERSION_STATUS_BETA : 
			($_GET['status'] == 'test' ? VERSION_STATUS_TEST : VERSION_STATUS_PRODUCTION);
		unset($_GET['status']);
	}
	
	$db = Database::getDatabase();

	// This table format is crap, but it future proofs us against Sparkle format changes
	$ip = $_SERVER['REMOTE_ADDR'];
	$dt = date("Y-m-d H:i:s");
	$db->query("INSERT INTO shine_sparkle_reports (ip, dt, app_id) VALUES (:ip, :dt, :app_id)", array('ip' => $ip, 'dt' => $dt, 'app_id' => $app->id));
	$id = $db->insertId();
	foreach($_GET as $k => $v)
		$db->query("INSERT INTO shine_sparkle_data (sparkle_id, `key`, data) VALUES (:id, :k, :v)", array('id' => $id, 'k' => $k, 'v' => $v));

	$versions = DBObject::glob('Version', "SELECT * FROM shine_versions WHERE app_id = '{$app->id}' AND status = ".$status." ORDER BY dt DESC LIMIT 10");

	$db->query("UPDATE shine_versions SET updates = updates + 1 WHERE app_id = '{$app->id}' AND status = ".$status." ORDER BY dt DESC LIMIT 1");
	
	# Google Analytics
	if ($app->use_ga == 1) {
		$uuid_ga = abs(crc32($dt)); # unsigned crc32
		// Initilize GA Tracker
		$tracker = new GoogleAnalytics\Tracker($app->ga_key, $app->ga_domain);
		
		// Assemble Visitor information
		// (could also get unserialized from database)
		$visitor = new GoogleAnalytics\Visitor();
		$visitor->setUniqueId($uuid_ga);
		$visitor->setIpAddress($_SERVER['REMOTE_ADDR']);
		$visitor->setUserAgent($_SERVER['HTTP_USER_AGENT']);
		$visitor->setScreenResolution('1024x768');
		
		$ga_country = null;
		if ($app->ga_country == 1 && function_exists('geoip_country_code_by_name')) {
			$ga_country = geoip_country_code_by_name($ip);
			if ($ga_country == '') $ga_country = 'XX';
		}
		
		// Assemble Session information
		// (could also get unserialized from PHP session)
		$session = new GoogleAnalytics\Session();
		// Assemble Event information
		$event = new GoogleAnalytics\Event($app->name, 'Update', $ga_country, null, true);
		// Track event
		$tracker->trackEvent($event, $session, $visitor);
	}
	
	$pirate = false;
	if(isset($_GET['serialNumber'])) {
		$sn = $db->quote(trim($_GET['serialNumber']));
		$count = $db->getValue("SELECT COUNT(*) FROM shine_orders WHERE license = $sn");
		if($count == 0) {
			$pirate = true;
		}
	}

	header("Content-type: application/xml");
?>
<?PHP echo '<'; ?>?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:sparkle="http://www.andymatuschak.org/xml-namespaces/sparkle"  xmlns:dc="http://purl.org/dc/elements/1.1/">
	<channel>
		<title><?PHP echo $app->name; ?> Changelog</title>
		<link><?PHP echo $app->link; ?></link>
		<description>Most recent changes with links to updates.</description>
		<language>en</language>
		<?PHP
			foreach($versions as $v) : 
				switch ($app->storage)
				{
					case 0:
					case 1:
						$enclosureLink = (1 == $app->is_ssl ? "https" : "http") . "://" . $app->s3domain . "/" . $app->s3path . $v->url;
					break;
					case 2:
						$enclosureLink = HTTP_SITE_NAME.'/dl/'.$v->url;
					break;
				}
		?>
		<item>
			<title><?PHP echo $app->name; ?> <?PHP echo $v->human_version; ?></title>
			<description><![CDATA[ <?PHP echo $v->release_notes; ?> ]]></description>
			<pubDate><?PHP echo dater('D, d M Y H:i:s O', $v->dt); ?></pubDate>
			<enclosure url="<?PHP echo $enclosureLink; ?>" sparkle:shortVersionString="<?PHP echo $v->human_version; ?>" sparkle:version="<?PHP echo $v->version_number; ?>" length="<?PHP echo $v->filesize; ?>" type="application/octet-stream" sparkle:dsaSignature="<?PHP echo $v->signature; ?>" />
		</item>
		<?PHP endforeach; ?>
		<?PHP if($pirate === true) : ?>
		<item>
			<title>sparkle</title>
			<description></description>
			<pubDate></pubDate>
			<enclosure url="http://clickontyler.com" sparkle:shortVersionString="1.0" sparkle:version="1.0" length="3000000" type="application/octet-stream" sparkle:dsaSignature="abc123" />
		</item>
		<?PHP endif; ?>
	</channel>
</rss>