public static function get($pkgIsInstalled = 1)
{
$pkgList = CacheLocal::getEntry('pkgList', $pkgIsInstalled);
if ($pkgList != false) {
return $pkgList;
}
$db = Loader::db();
$r = $db->query("select pkgID, pkgName, pkgIsInstalled, pkgDescription, pkgVersion, pkgHandle, pkgDateInstalled from Packages where pkgIsInstalled = ? order by pkgID asc", array($pkgIsInstalled));
$list = new static();
while ($row = $r->fetchRow()) {
$pkg = new Package();
$pkg->setPropertiesFromArray($row);
$list->add($pkg);
}
CacheLocal::set('pkgList', $pkgIsInstalled, $list);
return $list;
}
public static function getInstalledList()
{
$db = Loader::db();
$r = $db->query("select * from Packages where pkgIsInstalled = 1 order by pkgDateInstalled asc");
$pkgArray = array();
while ($row = $r->fetchRow()) {
$pkg = new Package();
$pkg->setPropertiesFromArray($row);
$pkgArray[] = $pkg;
}
return $pkgArray;
}
/**
* Returns an array of all installed packages
* @return Package[]
*/
public static function getInstalledList()
{
$db = Database::getActiveConnection();
$r = $db->query("SELECT * FROM Packages WHERE pkgIsInstalled = 1 ORDER BY pkgDateInstalled ASC");
$pkgArray = array();
while ($row = $r->fetchRow()) {
$pkg = new Package();
$pkg->setPropertiesFromArray($row);
$pkgArray[] = $pkg;
}
return $pkgArray;
}
public function setPropertiesFromArray($arr)
{
return parent::setPropertiesFromArray($arr);
}
