public static function get($id)
{
if (!$id || !is_numeric($id)) {
return false;
}
$db = SqlHandler::getInstance();
$q = 'SELECT * FROM ' . self::$tbl_name . ' WHERE id = ?';
$row = $db->pSelectRow($q, 'i', $id);
$obj = SqlObject::loadObject($row, __CLASS__);
if (!$obj) {
throw new \Exception('bad id ' . $id);
}
$obj->episodes = TvEpisode::getAllByOwner($id);
return $obj;
}
public static function getByReference($type, $reference)
{
$q = 'SELECT * FROM ' . self::$tbl_name . ' WHERE type = ? AND reference = ?';
$row = Sql::pSelectRow($q, 'ii', $type, $reference);
return SqlObject::loadObject($row, __CLASS__);
}
public static function getLatestByOwner($type, $owner)
{
$q = 'SELECT * FROM ' . self::$tbl_name . ' WHERE type = ? AND owner = ?' . ' ORDER BY time_saved DESC' . ' LIMIT 1';
$row = Sql::pSelectRow($q, 'ii', $type, $owner);
return SqlObject::loadObject($row, __CLASS__);
}
public static function get($id)
{
$q = 'SELECT * FROM ' . self::$tbl_name . ' WHERE id = ?' . ' AND time_deleted IS NULL';
$row = Sql::pSelectRow($q, 'i', $id);
return SqlObject::loadObject($row, __CLASS__);
}
static function get($id)
{
$q = 'SELECT * FROM tblPolls WHERE id = ? AND deleted_by = ?';
$row = Sql::pSelectRow($q, 'ii', $id, 0);
return SqlObject::loadObject($row, __CLASS__);
}
public static function getByOwner($id)
{
$q = 'SELECT * FROM ' . self::$tbl_name . ' WHERE owner = ?' . ' ORDER BY time_saved DESC' . ' LIMIT 1';
$res = Sql::pSelectRow($q, 'i', $id);
return SqlObject::loadObject($res, __CLASS__);
}
