} else { echo "not found\n"; } echo "get(888):"; if ($row = $rpm->get(888)) { print_r($row); } else { echo "not found\n"; } echo "Last update : " . date("r", $rpm->getMaxStamp()) . "\n"; $up = new TableUpstream($db); $up->delete(array('name' => 'foo', 'type' => 'test')); $rec = $up->record('test', 'bar', 'foo', '1.0', true); echo "record(foo-1.0) : {$rec}\n"; echo "find(foo,test):"; if ($row = $up->find(array('name' => 'foo', 'type' => 'test'))) { print_r($row); } else { echo "not found\n"; } $up->record('test', 'bar', 'foo', '1.2', false, 'beta'); echo "record(foo-1.2) : {$rec}\n"; echo "find(foo,test):"; if ($row = $up->find(array('name' => 'foo', 'type' => 'test'))) { print_r($row); } else { echo "not found\n"; } echo "request(test) : "; foreach ($up->request(array('type' => 'test', 'ORDER' => 'name')) as $upstr) { print_r($upstr);
$ret = implode($ret_tmp, ', '); } return $ret; } $smarty->registerPlugin('function', 'getBranchPeople', 'getBranchPeople'); if (!isset($name) || !$name) { $smarty->assign('error', 'missing_name'); } else { try { $db = new PDO("mysql:dbname=" . MYBASE . ";host=" . MYHOST, MYUSER, MYPASS); $uptable = new TableUpstream($db); // Consider each part of ver/rel as integer except second part of rel (generally distro name) $sql = "SELECT rpm.*, repo.active, repo.url as repourl, packagist.pkgname,\n CONCAT(repo.url ,rpm.name,'-',rpm.ver,'-',rpm.rel,'.src.rpm') as rpmurl\n FROM rpm\n LEFT JOIN packagist ON (packagist.rpmname=rpm.name)\n INNER JOIN repo ON (repo.main=rpm.repo_main AND repo.sub=rpm.repo_sub)\n WHERE rpm.name=" . $uptable->escape($name) . "\n ORDER BY repo.id DESC,\n CAST(SUBSTRING_INDEX(rpm.ver,'.',1) AS SIGNED) DESC,\n CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(rpm.ver,'.',2),'.',-1) AS SIGNED) DESC,\n CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(rpm.ver,'.',3),'.',-1) AS SIGNED) DESC,\n CAST(SUBSTRING_INDEX(rpm.rel,'.',1) AS SIGNED) DESC,\n SUBSTRING_INDEX(SUBSTRING_INDEX(rpm.rel,'.',2),'.',-1) DESC,\n CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(rpm.rel,'.',3),'.',-1) AS SIGNED) DESC"; $resrpm = $db->query($sql); $rpm = $resrpm ? $resrpm->fetchObject() : false; $up = $uptable->find(array('name' => $name)); $sql = "SELECT * FROM acls WHERE name = " . $uptable->escape($name); $resown = $db->query($sql); $owner = $resown ? $resown->fetchObject() : false; if (isset($owner->name)) { // Use exact name (with case) from acl (else pkgdb could fail) $name = $owner->name; $smarty->assign('name', $name); $smarty->assign('page_title', 'Package: ' . $name); } $summary = array(); $packages = array(); $fedpkg = false; if (!$rpm) { echo "<h1>{$name} not found</h1>\n"; } else {