/**
* @return array
*/
public function getMyPiles()
{
$db = Loader::db();
$u = new User();
if ($u->isRegistered()) {
$v = array($u->getUserID());
$q = "select pID from Piles where uID = ? order by name asc";
}
$piles = array();
$r = $db->query($q, $v);
if ($r) {
while ($row = $r->fetchRow()) {
$piles[] = Pile::get($row['pID']);
}
}
return $piles;
}
function get($pcID)
{
$db = Loader::db();
$v = array($pcID);
$q = "select pID, pcID, itemID, itemType, displayOrder, quantity, timestamp from PileContents where pcID = ?";
$r = $db->query($q, $v);
$row = $r->fetchRow();
$pc = new PileContent();
if (is_array($row)) {
foreach ($row as $k => $v) {
$pc->{$k} = $v;
}
}
$p = Pile::get($pc->pID);
$pc->p = $p;
// pc-p . get it ?
return $pc;
}
