PHP MediaContent::load Examples

Example #1

File: list.php Project: nbuy/xoops-modules-medialinks

    $keyid = intval($_GET['keyid']);
    $xoopsTpl->assign('keypath', $keypath);
    $res = $xoopsDB->query("SELECT midref FROM " . RELAY . " WHERE keyref=" . $keyid);
    $mids = array();
    while (list($mid) = $xoopsDB->fetchRow($res)) {
        $mids[] = $mid;
    }
    $cond .= " AND mid IN (" . join(',', $mids) . ")";
}
if (!$isadmin) {
    $uid = is_object($xoopsUser) ? $xoopsUser->getVar('uid') : 0;
    $acl = "LEFT JOIN " . ACLS . " ON amid=mid AND auid=" . $uid;
    $cond .= " AND (nacl=0 OR auid>0)";
}
$res = $xoopsDB->query("SELECT count(mid) FROM " . MAIN . " {$acl} WHERE {$cond}");
list($n) = $xoopsDB->fetchRow($res);
$start = isset($_GET['start']) ? intval($_GET['start']) : 0;
$max = $xoopsModuleConfig['max_list'];
$res = $xoopsDB->query("SELECT * FROM " . MAIN . " {$acl} WHERE {$cond} ORDER BY {$order}", $max, $start);
$nav = new XoopsPageNav($n, $max, $start, "start");
if ($n > $max) {
    $xoopsTpl->assign('pagenav', $nav->renderNav());
}
$list = array();
while ($content->load(0, $res)) {
    $fields = $content->dispVars();
    $fields['detail'] = "detail.php?mid=" . $content->getVar('mid');
    $list[] = $fields;
}
$xoopsTpl->assign('list', $list);
include XOOPS_ROOT_PATH . "/footer.php";