function photoplog_list_categories(&$list_cats, $parentid = -1, $root_title = '', $include_not_available = 0, $spacer = '', $spacer_append = '--')
{
global $vbulletin, $vbphrase;
// ORDER BY parentid,displayorder,catid
// now done by ALTER TABLE after change
$categories = $vbulletin->db->query_read("SELECT catid, title, parentid\r\n\t\tFROM " . PHOTOPLOG_PREFIX . "photoplog_categories\r\n\t");
$catids = array();
$titles = array();
$parentids = array();
while ($category = $vbulletin->db->fetch_array($categories)) {
if ($include_not_available || $category['catid'] > 0) {
$catids[] = $category['catid'];
$titles[] = $category['title'];
$parentids[] = $category['parentid'];
}
}
$vbulletin->db->free_result($categories);
if ($include_not_available && !in_array(0, $catids)) {
$catids[] = 0;
$titles[] = $vbphrase['photoplog_not_available'];
$parentids[] = -1;
}
photoplog_list_worker($list_cats, $parentid, $root_title, $spacer, $spacer_append, $catids, $titles, $parentids);
}
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);
}
