dev-chiefworks
42 lines
1.4 KiB
PHP
42 lines
1.4 KiB
PHP
<?php
|
|
|
|
class Version {
|
|
|
|
|
|
public function getAppVersion($db, $platform_name, $rev_count, $short_hash) {
|
|
syslog(LOG_WARNING,"Version::getAppVersion(\$db, $platform_name, $rev_count, $short_hash)");
|
|
$platform = Push::getPlatformByName($db, $platform_name);
|
|
$platform_id = $platform==NULL?0:$platform['id'];
|
|
$db_rev_count = (int)$rev_count;
|
|
$db_short_hash = pg_escape_string($short_hash);
|
|
|
|
$q = "SELECT * FROM myfloat_version WHERE platform_id=${platform_id} AND rev_count=${db_rev_count} AND short_hash='${db_short_hash}'";
|
|
syslog(LOG_WARNING,$q);
|
|
$r = pg_query($db, $q);
|
|
if ($r && pg_num_rows($r) && $f=pg_fetch_assoc($r)) {
|
|
return $f;
|
|
}
|
|
return NULL;
|
|
}
|
|
|
|
public function getNewAppVersion($db, $platform_name, $rev_count, $short_hash) {
|
|
syslog(LOG_WARNING,"Version::getNewAppVersion(\$db, $platform_name, $rev_count, $short_hash)");
|
|
$platform = Push::getPlatformByName($db, $platform_name);
|
|
$platform_id = $platform==NULL?0:$platform['id'];
|
|
$db_rev_count = (int)$rev_count;
|
|
$db_short_hash = pg_escape_string($short_hash);
|
|
|
|
$q = "SELECT * FROM myfloat_version WHERE platform_id=${platform_id} AND rev_count>${db_rev_count} AND short_hash<>'${db_short_hash}'";
|
|
$q.= " ORDER BY rev_count DESC LIMIT 1";
|
|
syslog(LOG_WARNING,$q);
|
|
$r = pg_query($db, $q);
|
|
if ($r && pg_num_rows($r) && $f=pg_fetch_assoc($r)) {
|
|
return $f;
|
|
}
|
|
return NULL;
|
|
}
|
|
}
|
|
|
|
// vi:ts=2
|
|
|