function photoplog_child_list(&$list_children, &$list_parents, $catid = -1, $levels = -1)
{
global $vbulletin;
$categories = $vbulletin->db->query_read("SELECT catid, parentid\r\n\t\tFROM " . PHOTOPLOG_PREFIX . "photoplog_categories\r\n\t");
$catids = array();
$parids = array();
while ($category = $vbulletin->db->fetch_array($categories)) {
$catids[] = $category['catid'];
$parids[] = $category['parentid'];
}
$vbulletin->db->free_result($categories);
if (!in_array(0, $catids)) {
$catids[] = 0;
$parids[] = -1;
}
photoplog_child_worker($list_children, $list_parents, $catid, $catids, $parids, $levels);
}
function photoplog_child_list_v2(&$list_imm, &$list_all, &$list_cats)
{
global $vbulletin;
// ORDER BY parentid,displayorder,catid
// now done by ALTER TABLE after change
$categories = $vbulletin->db->query_read("SELECT catid, parentid, title\r\n\t\tFROM " . PHOTOPLOG_PREFIX . "photoplog_categories\r\n\t");
$catids = array();
$titles = array();
$parentids = array();
while ($category = $vbulletin->db->fetch_array($categories)) {
$catid = intval($category['catid']);
$parid = intval($category['parentid']);
$list_imm[$parid][] = $catid;
if (!isset($list_imm[$catid])) {
$list_imm[$catid] = array();
}
$catids[] = $catid;
$titles[] = strval($category['title']);
$parentids[] = $parid;
}
$vbulletin->db->free_result($categories);
photoplog_child_worker($list_imm, $list_all);
photoplog_list_worker($list_cats, -1, '', $catids, $titles, $parentids);
}