function icon($name, $text)
{
$db = new CodeKBDatabase();
$db->dosql("SELECT symbol " . "FROM symbols " . "WHERE name = '{$db->string($name)}'");
$symbol = $db->column("symbol");
if (is_null($symbol)) {
return "";
}
global $conf;
return img("/icons/" . $symbol, $text ? $text : $name, "vertical-align: middle;");
}
public function change($name, $author, $symbol, $description, $documentation)
{
if (!$this->_user->entrycan("changeentry", $this)) {
return false;
}
if (!$author && $this->_user->name()) {
$author = $this->_user->name();
}
$db = new CodeKBDatabase();
$db->dosql("UPDATE entries " . "SET name = '{$db->string($name)}', " . "author = '{$db->string($author)}', " . "symbol = '{$db->string($symbol)}', " . "description = '{$db->string($description)}', " . "documentation = '{$db->string($documentation)}', " . "modified = now()" . "WHERE id = {$db->number($this->_id)}");
if ($db->success()) {
$this->_name = $name;
$this->_author = $author;
$this->_symbol = $symbol;
$this->_description = $description;
return true;
}
throw new CodeKBException(__METHOD__, "entry", "failedchange", $name);
}
function showinput()
{
global $lang;
global $conf;
global $user;
global $site;
global $catid;
global $file;
$site->title($lang['file']['modify']);
$site->addfooter("help.php?on=file#change", "help", $lang['menu']['help'], $lang['menu']['helpalt']);
if (!$user->entrycan("changeentry", $file->entry())) {
$site->addcontent(notice($lang['entry']['nochangeallowed']));
return false;
}
if ($_POST['cancel']) {
redirect("entry.php?id=" . $file->entry()->id());
}
$form = new CodeKBForm("file.php", "modify");
$form->addhidden("id", $file->id());
$form->addhidden("cat", $catid);
$form->addtext("name", $file->name());
$form->addlabel("name", $lang['file']['name']);
$form->setrequired("name");
$form->addfile("upload");
$form->addlabel("upload", $lang['file']['upload']);
$form->addcombo("highlight", $conf['highlight']['binary'], null, $conf['highlight']['binary'] == $file->highlight());
foreach ($conf['highlight']['languages'] as $language) {
$form->addcombo("highlight", $language, null, $language == $file->highlight());
}
$form->addlabel("highlight", $lang['file']['language']);
$db = new CodeKBDatabase();
$db->dosql("SELECT name, symbol " . "FROM symbols " . "WHERE symbol LIKE 'type_%'");
while ($val = $db->row()) {
$form->addradio("symbol", $val['name'], icon($val['name'], $val['name']), $val['name'] == $file->symbol(), false);
}
$form->addbutton("submit");
$form->addbutton("cancel");
if ($_POST['submit']) {
if (!$form->fill()) {
$site->addcontent(notice($lang['general']['missing']));
} else {
global $HTTP_POST_FILES;
if (is_uploaded_file($HTTP_POST_FILES['upload']['tmp_name'])) {
$upload = "upload";
} else {
$upload = false;
}
try {
$file->change($form->value("name"), $form->value("highlight"), $form->value("symbol"), $upload);
if ($form->value("highlight") == $conf['highlight']['binary']) {
redirect("entry.php?id=" . $file->entry()->id() . "&cat=" . $catid);
} else {
redirect("file.php?id=" . $file->id() . "&cat=" . $catid);
}
} catch (Exception $e) {
$site->addcontent(notice($lang['entry']['failedfilechange']));
}
}
}
$dialog = new CodeKBTemplate("dialog");
$dialog->push("legend", $lang['file']['modify']);
$dialogitem = new CodeKBTemplate("dialogitem");
$content = $form->head();
$content .= $form->get("name");
$dialogitem->push("top", $content);
$dialogitem->push("head", "(" . $lang['file']['newuploadexplain'] . ")<br />\n");
$dialogitem->push("content1", $form->get());
$dialogitem->push("tail", $form->tail());
$dialog->push("content", $dialogitem);
$site->addcontent($dialog);
return true;
}
public function output()
{
global $conf;
global $lang;
$header = new CodeKBTemplate("header");
$header->push("stylesheet", $conf['general']['stylesheet']);
$header->push("favicon", $conf['general']['imagepath'] . "/codekb.ico");
$header->push("title", $this->_title);
$header->push("headline", $conf['general']['title']);
array_unshift($this->_menu, array("home.php", $lang['menu']['home'], $lang['menu']['homealt']), array("category.php", $lang['menu']['browse'], $lang['menu']['browsealt']));
if ($this->_user->isadmin()) {
array_push($this->_menu, array("admin.php", $lang['menu']['admin'], $lang['menu']['adminalt']));
}
if ($this->_user->valid()) {
array_push($this->_menu, array("login.php?action=logout", $lang['menu']['logout'] . " [<em>" . htmlentities($this->_user->name()) . "</em>]", $lang['menu']['logoutalt']));
} else {
array_push($this->_menu, array("login.php", $lang['menu']['login'], $lang['menu']['loginalt']));
}
$menuitems = "";
while ($menuentry = array_shift($this->_menu)) {
$menuitems .= "\t\t" . url($menuentry[0], $menuentry[1], $menuentry[2]);
if (count($this->_menu) != 0) {
$menuitems .= " | \n";
}
}
$search = new CodeKBForm("search.php", "search");
$search->addtext("query");
$menuitems .= $search->head();
$searchstring = url("help.php", $lang['menu']['help'], $lang['menu']['helpalt']) . " | \n";
$searchstring .= url("search.php", $lang['menu']['search'], $lang['menu']['searchalt']) . " \n";
$searchstring .= $search->get("query");
$tail = $search->tail();
$menu = new CodeKBTemplate("menu");
$menu->push("menu", $menuitems);
$menu->push("search", $searchstring);
$menu->push("tail", $tail);
echo $header;
echo $menu;
if ($this->_navigation) {
echo $this->_navigation;
}
echo $this->_content;
$footeritems = "";
while ($menuentry = array_shift($this->_footer)) {
$footeritems .= "\t\t" . url($menuentry[0], icon($menuentry[1], $menuentry[2]), $menuentry[3]) . " \n";
$footeritems .= "\t\t" . url($menuentry[0], $menuentry[2], $menuentry[3]) . " \n";
}
if ($conf['layout']['jumptonavigation']) {
$footerform = new CodeKBForm("category.php", "list");
$tmpcat = new CodeKBCategory(0, $this->_user);
$footerform->addcombo("id", "0", $lang['category']['root'], $this->_catid == 0, "jump");
$array = $tmpcat->listcategories("name", 1);
foreach ($array as $val) {
if ($this->_user->can("see", $val['id'])) {
$footerform->addcombo("id", $val['id'], str_repeat("-", $val['reclevel'] * 2) . " " . $val['name'], $this->_catid == $val['id'], "jump");
}
}
unset($tmpcat);
$footerform->addbutton("jump", $lang['general']['go']);
$navi = $footerform->head();
$navi .= $footerform->get("id");
$navi .= $footerform->tail();
}
$query_num = CodeKBDatabase::querycount();
$endtime = microtime(true);
$debug = "";
if ($conf['err']['debug']) {
CodeKBException::backtrace();
$debug = "<span style=\"font-size: xx-small;\">(Execution time: " . round($endtime - $this->_starttime, 4) . " / " . $query_num . " Queries)</span>";
}
$footer = new CodeKBTemplate("footer");
$footer->push("footer", $footeritems);
$footer->push("runtime", $debug);
$footer->push("navigation", $navi);
echo $footer;
}
function buildsearchquery($type)
{
global $lang;
$query = "SELECT DISTINCT entries.id, " . "entries.name, " . "entries.author, " . "entries.description, " . "entries.symbol, " . "entries.created, " . "entries.modified " . "FROM ";
$keywords = preg_split("/\\s+/", trim($_POST['query']));
$count = count($keywords);
if ($type == "pgsql") {
for ($i = 0; $i < $count; $i++) {
$query .= "entries_fti i" . $i . ", ";
}
}
if (is_array($_POST['cats'])) {
$query .= " entry_cat, ";
}
$query .= "entries WHERE ";
if ($type == "pgsql") {
$query .= "entries.oid = i0.id AND ";
}
if ($_POST['author']) {
$query .= "lower(entries.author) = lower('" . CodeKBDatabase::string($_POST['author']) . "') AND ";
}
$a = 1;
$b = count($_POST['cats']);
while (is_array($_POST['cats']) && !is_null($val = array_shift($_POST['cats']))) {
if ($a == 1) {
$query .= "entries.id = entry_cat.entry AND ( ";
}
$query .= "entry_cat.cat = " . CodeKBDatabase::number($val) . " ";
if ($a != $b) {
$query .= "OR ";
} else {
$query .= ") AND ";
}
$a++;
}
if ($_POST['age'] != $lang['search']['all'] && $_POST['whichage']) {
if ($_POST['whichage'] == $lang['sort']['sortbymodifydate']) {
$wage = "modified";
} else {
$wage = "created";
}
switch ($_POST['age']) {
case $lang['search']['1day']:
$age = 86400;
break;
case $lang['search']['7days']:
$age = 604800;
break;
case $lang['search']['1month']:
$age = 2592000;
break;
case $lang['search']['3months']:
$age = 7776000;
break;
case $lang['search']['6months']:
$age = 15552000;
break;
case $lang['search']['1year']:
$age = 31536000;
break;
default:
$age = time();
}
$query .= "entries." . CodeKBDatabase::string($wage) . " > '" . CodeKBDatabase::string(date("Y-m-d H:i:s", time() - $age)) . "' AND ";
}
$i = 0;
if ($type == "mysql") {
$query .= "(";
}
while (is_array($keywords) && !is_null($val = array_shift($keywords))) {
if ($val == "*" || $val == "?") {
$val = "";
}
if ($type == "pgsql") {
$query .= ($i == 0 ? "" : "AND ") . "i" . $i . ".string ~ lower('^" . CodeKBDatabase::string($val) . "') ";
if ($i > 0) {
$query .= "AND i" . ($i - 1) . ".id = i" . $i . ".id ";
}
$i++;
}
if ($type == "mysql") {
$query .= ($i == 0 ? "" : "OR ") . " entries.description LIKE '%" . CodeKBDatabase::string($val) . "%' OR entries.documentation LIKE '%" . CodeKBDatabase::string($val) . "%' ";
}
$i++;
}
if ($type == "mysql") {
$query .= ") ";
}
$sortorder = false;
switch ($_POST['sort']) {
case $lang['sort']['sortbycreatedate']:
$sort = "entries.created";
break;
case $lang['sort']['sortbymodifydate']:
$sort = "entries.modified";
break;
case $lang['sort']['sortbyname']:
default:
$sort = "entries.name";
}
switch ($_POST['order']) {
case $lang['sort']['descending']:
$order = "DESC";
break;
case $lang['sort']['ascending']:
default:
$order = "ASC";
}
$query .= "ORDER BY " . $sort . " " . $order;
echo $query;
return $query;
}
function showlisting()
{
global $lang;
global $user;
global $site;
global $conf;
global $category;
$site->title($category->name());
if ($user->can("addcat", $category)) {
$site->addmenu("category.php?id=" . $category->id() . "&action=new", $lang['menu']['addcat'], $lang['menu']['addcatalt']);
$site->addfooter("category.php?id=" . $category->id() . "&action=new", "newcat", $lang['menu']['addcat'], $lang['menu']['addcatalt']);
}
if ($user->can("addentry", $category)) {
$site->addmenu("entry.php?cat=" . $category->id() . "&action=new", $lang['menu']['addentry'], $lang['menu']['addentryalt']);
$site->addfooter("entry.php?cat=" . $category->id() . "&action=new", "newentry", $lang['menu']['addentry'], $lang['menu']['addentryalt']);
}
if ($category->id() != 0 && $user->can("changecat", $category)) {
$site->addfooter("category.php?id=" . $category->id() . "&action=change", "configure", $lang['menu']['changecat'], $lang['menu']['changecatalt']);
}
if ($category->id() != 0 && $user->can("delcat", $category)) {
$site->addfooter("category.php?id=" . $category->id() . "&action=delete", "delete", $lang['menu']['delcat'], $lang['menu']['delcatalt']);
}
$site->addfooter("help.php?on=category", "help", $lang['menu']['help'], $lang['menu']['helpalt']);
// Sorting stuff
$sort = $_SESSION['sort'] ? $_SESSION['sort'] : urldecode($_COOKIE['codekb_sort']);
$order = $_SESSION['order'] != "" ? $_SESSION['order'] : urldecode($_COOKIE['codekb_order']);
$age = $_SESSION['age'] != "" ? $_SESSION['age'] : urldecode($_COOKIE['codekb_age']);
$whichage = $_SESSION['wage'] != "" ? $_SESSION['wage'] : urldecode($_COOKIE['codekb_wage']);
$entriesperpage = $_SESSION['epp'] != "" ? $_SESSION['epp'] : urldecode($_COOKIE['codekb_epp']);
if (!$entriesperpage) {
$entriesperpage = $conf['layout']['entriesperpage'];
}
switch ($sort) {
case $lang['sort']['sortbycreatedate']:
$sort = "created";
break;
case $lang['sort']['sortbymodifydate']:
$sort = "modified";
break;
case $lang['sort']['sortbyname']:
default:
$sort = "name";
}
switch ($order) {
case $lang['sort']['descending']:
$order = "DESC";
break;
case $lang['sort']['ascending']:
default:
$order = "ASC";
}
$sortorder = $sort . " " . $order;
if ($age != $lang['search']['all'] && $whichage) {
if ($whichage == $lang['sort']['sortbymodifydate']) {
$wage = "modified";
} else {
$wage = "created";
}
switch ($age) {
case $lang['search']['1day']:
$age = 86400;
break;
case $lang['search']['7days']:
$age = 604800;
break;
case $lang['search']['1month']:
$age = 2592000;
break;
case $lang['search']['3months']:
$age = 7776000;
break;
case $lang['search']['6months']:
$age = 15552000;
break;
case $lang['search']['1year']:
$age = 31536000;
break;
default:
$age = time();
}
$filter = "AND entries." . CodeKBDatabase::string($wage) . " > '" . CodeKBDatabase::string(date("Y-m-d H:i:s", time() - $age)) . "' ";
}
if ($_GET['offset']) {
$offset = $_GET['offset'];
} else {
$offset = 0;
}
$list = new CodeKBTemplate("listing");
// Categories
$categories = $category->listcategories();
$i = 0;
$count = 4;
$listcode = "";
foreach ($categories as $cat) {
$listitem = new CodeKBTemplate("listitem");
if ($i % $count == 0) {
$listitem->push("first", true);
}
$listitem->push("icon", url("category.php?id=" . $cat['id'], icon("category", $cat['name']), $cat['name']) . "\n");
$listitem->push("name", url("category.php?id=" . $cat['id'], htmlentities($cat['name']), $cat['name']));
// Do we want to show subcategory and entry counts?
if ($conf['layout']['showcounts']) {
$listitem->push("catdescr", $lang['category']['subcats']);
$listitem->push("entdescr", $lang['category']['entries']);
$catcount = $category->listcategories(null, $conf['layout']['showcountsrecursive'] ? "1" : "0", $cat['id']);
$listitem->push("count", true);
$listitem->push("catcount", count($catcount));
$entrycount = count($category->listentries(null, null, $cat['id']));
if ($conf['layout']['showcountsrecursive']) {
foreach ($catcount as $val) {
$entrycount += count($category->listentries(null, null, $val['id']));
}
}
$listitem->push("entrycount", $entrycount);
}
$listitem->push("description", htmlentities($cat['description']));
$i++;
if ($i % $count == 0) {
$listitem->push("last", true);
}
$listcode .= $listitem->__toString();
unset($listitem);
}
$list->push("categories", $listcode);
// Entries
$entries = $category->listentries($sortorder, $filter);
$list->push("changeview", url("category.php?id=" . $category->id() . "&action=sort", $lang['sort']['changeview'], $lang['sort']['changeviewalt']));
$entriescount = count($entries);
if ($entriesperpage == $lang['search']['all']) {
$entriesperpage = $entriescount;
}
if ($offset >= $entriescount) {
$offset = $entriescount - 1;
}
if (!is_numeric($offset) || $offset <= 0) {
$offset = 0;
}
if ($entriescount > 0) {
$pages = ceil($entriescount / $entriesperpage);
$currentpage = ceil($offset / $entriesperpage) + 1;
$pagesting = "";
if ($pages > 1) {
// Go to the given offset
for ($i = 0; $i < $offset * $entriesperpage - 1; $i++) {
if (is_array($entries)) {
array_shift($entries);
}
}
$pagestring .= url("category.php?id=" . $category->id() . "&offset=" . ($offset <= 0 ? "0" : $offset - 1), $lang['search']['last'], $lang['search']['lastalt']) . " ";
for ($i = 1; $i <= $pages; $i++) {
if ($i == $currentpage) {
$pagestring .= $i . " ";
} else {
$pagestring .= url("category.php?id=" . $category->id() . "&offset=" . ($i - 1), $i, phrasereplace($lang['search']['page'], "%1%", $i)) . " ";
}
}
$pagestring .= url("category.php?id=" . $category->id() . "&offset=" . ($offset >= $entriescount - 1 ? $entriescount - 1 : $offset + 1), $lang['search']['next'], $lang['search']['nextalt']);
}
$list->push("pages", $pagestring);
}
$i = 0;
$count = 3;
$listcode = "";
foreach ($entries as $entry) {
$listitem = new CodeKBTemplate("listitem");
if ($i % $count == 0) {
$listitem->push("first", true);
}
$listitem->push("icon", url("entry.php?id=" . $entry['id'] . "&cat=" . $category->id(), icon($entry['symbol'], $entry['name']), $entry['name']) . "\n");
$listitem->push("name", url("entry.php?id=" . $entry['id'] . "&cat=" . $category->id(), htmlentities($entry['name']), $entry['name']));
$listitem->push("description", htmlentities($entry['description']));
$i++;
if ($entriesperpage != $lang['search']['all'] && $i == $entriesperpage) {
$listitem->push("last", true);
break;
}
if ($i % $count == 0 || $i == $entriescount) {
$listitem->push("last", true);
}
$listcode .= $listitem->__toString();
unset($listitem);
}
$list->push("entries", $listcode);
$site->addcontent($list);
return true;
}
function change($name, $highlight, $symbol, $newupload = null)
{
// return values
// 1 upload failed
if (!$this->_user->entrycan("changeentry", $this->_entry)) {
return false;
}
// Do we want to exchange our file with a new one?
if ($newupload) {
// First upload new one and then delete the old
global $HTTP_POST_FILES;
$fs_name = null;
if (is_uploaded_file($HTTP_POST_FILES[$newupload]['tmp_name'])) {
$fs_name = $this->upload($newupload);
}
if (!$fs_name) {
throw new CodeKBException(__METHOD__, "file", "failedchange", $name, 1);
} else {
$size = $HTTP_POST_FILES[$newupload]['size'];
}
} else {
$fs_name = $this->_fsname;
$size = $this->_size;
}
$db = new CodeKBDatabase();
$db->dosql("UPDATE files " . "SET name = '{$db->string($name)}', " . "fs_name = '{$db->string($fs_name)}', " . "size = {$db->number($size)}, " . "highlight = '{$db->string($highlight)}', " . "symbol = '{$db->string($symbol)}', " . "modified = now() " . "WHERE id = {$db->number($this->_id)}");
if (!$db->success()) {
throw new CodeKBException(__METHOD__, "file", "failedchange", $name);
}
// Remove old file
if ($newupload) {
$this->delink();
}
$this->_name = $name;
$this->_fs_name = $fs_name;
$this->_size = $size;
$this->_highlight = $highlight;
$this->_symbol = $symbol;
return true;
}
function entrycan($what, &$entry, $cache = true)
{
// Do something for a bit more performance:
// Cache the last request because we often query
// just one entry per page
static $lastentry;
static $lastcat;
if (is_null($entry)) {
return false;
}
if (is_object($entry)) {
$id = $entry->id();
} else {
$id = $entry;
}
if ($cache && $id == $lastentry) {
$array = $lastcat;
} else {
$db = new CodeKBDatabase();
$db->dosql("SELECT cat " . "FROM entry_cat " . "WHERE entry = {$db->number($id)}");
$lastentry = $id;
$array = $db->all();
$lastcat = $array;
}
$succ = false;
while (is_array($array) && ($val = array_pop($array))) {
if ($this->can($what, $val['cat'], $cache)) {
$succ = true;
break;
}
}
if ($succ) {
return true;
}
return false;
}
function showfiles()
{
global $lang;
global $conf;
global $user;
global $site;
global $category;
global $entry;
$site->title($lang['entry']['files']);
$site->addfooter("help.php?on=file", "help", $lang['menu']['help'], $lang['menu']['helpalt']);
if ($category) {
$cat = $category->id();
}
if (!$user->entrycan("changeentry", $entry)) {
$site->addcontent(notice($lang['entry']['nochangeallowed']));
return false;
}
if ($_POST['cancel']) {
redirect("entry.php?id=" . $entry->id() . "&cat=" . $cat);
}
$form1 = new CodeKBForm("entry.php", "files");
$form1->addhidden("id", $entry->id());
$form1->addhidden("cat", $cat);
$form1->addfile("upload");
$form1->addlabel("upload", $lang['file']['upload']);
$form1->addcombo("highlight", $conf['highlight']['binary']);
while ($language = next($conf['highlight']['languages'])) {
$form1->addcombo("highlight", $language, null, $language == "text");
}
$form1->addlabel("highlight", $lang['file']['language']);
$db = new CodeKBDatabase();
$db->dosql("SELECT name, symbol " . "FROM symbols " . "WHERE symbol LIKE 'type_%'");
while ($val = $db->row()) {
$form1->addradio("symbol", $val['name'], icon($val['name'], $val['name']), $val['name'] == "Unkown", false);
}
$form1->addsubmit("addfile");
$form1->addcancel();
$form2 = new CodeKBForm("entry.php", "files");
$form2->addhidden("id", $entry->id());
$form2->addhidden("cat", $cat);
$filesofentry = $entry->listfiles();
foreach ($filesofentry as $val) {
$form2->addcheckbox("file_" . $val['id'], icon($val['symbol'], $val['name']) . " " . $val['name'] . " (" . url("file.php?id=" . $val['id'] . "&cat=" . $cat . "&action=modify", $lang['general']['modify']) . ")");
}
$form2->addsubmit("removefile", $lang['general']['delete']);
$form2->addcancel();
if ($_POST['addfile'] && $form1->fill()) {
try {
$ret = $entry->addfile("upload", $form1->value("highlight"), $form1->value("symbol"));
$newfile = new CodeKBFile($ret, $user);
$site->addcontent(notice($lang['file']['addsucc']));
$form2->addcheckbox("file_" . $newfile->id(), icon($newfile->symbol(), $newfile->name()) . " " . $newfile->name() . " (" . url("file.php?id=" . $newfile->id() . "&cat=" . $cat . "&action=modify", $lang['general']['modify']) . ")");
unset($newfile);
} catch (Exception $e) {
if ($e->getCode() == 1) {
$site->addcontent(notice($lang['file']['uploadfailed']));
} else {
$site->addcontent(notice($lang['file']['failedadd']));
}
}
}
if ($_POST['removefile'] && $form2->fill()) {
foreach ($filesofentry as $val) {
try {
if ($form2->value("file_" . $val['id']) == "1") {
$tmpfile = new CodeKBFile($val['id'], $user);
$tmpfile->delete();
unset($tmpfile);
$notice = $lang['file']['delsucc'];
$form2->remove("file_" . $val['id']);
}
} catch (Exception1 $e) {
$notice = $lang['file']['failedremove'];
break;
}
}
$site->addcontent(notice($notice));
}
$dialog = new CodeKBTemplate("dialog");
$dialog->push("legend", $lang['entry']['files']);
$dialogcode = "";
$dialogitem1 = new CodeKBTemplate("dialogitem");
$content = $form1->head();
$content .= $lang['file']['addexplain'] . "<br /><br />\n";
$dialogitem1->push("head", $content);
$dialogitem1->push("content1", $form1->get());
$dialogitem1->push("tail", $form1->tail());
$dialogcode .= $dialogitem1->__toString();
$content = $form2->head();
$content .= $lang['file']['removeexplain'] . "<br /><br />\n";
$dialogitem2 = new CodeKBTemplate("dialogitem");
$dialogitem2->push("head", $content);
$content = "<div class = \"forms\">\n";
$content .= $form2->get();
$content .= "</div>";
$dialogitem2->push("content1", $content);
$dialogitem2->push("tail", $form2->tail());
$dialogcode .= $dialogitem2->__toString();
$dialog->push("content", $dialogcode);
$site->addcontent($dialog);
return true;
}
public function partgroup($user, $group)
{
$db = new CodeKBDatabase();
$db->dosql("DELETE FROM group_user " . "WHERE userid = {$db->number($user)} AND " . "groupid = {$db->number($group)}");
if ($db->success()) {
return true;
}
throw new CodeKBException(__METHOD__, "admin", "failedpart");
}
public function delete(&$dbobj = null, $level = 0)
{
// return values
// 1 aborted recursion
// Are we at the first recursion level?
if (is_null($dbobj)) {
$first = true;
$db = new CodeKBDatabase();
$db->start();
$dbobj =& $db;
} else {
$first = false;
$db =& $dbobj;
}
if ($this->_id == 0 || !$this->_user->can("delcat", $this)) {
$db->abort();
return false;
}
$entries = $this->listentries();
foreach ($entries as $val) {
$tmpentry = new CodeKBEntry($val['id'], $this->_user);
$tmpentry->delink($this->_id);
unset($tmpentry);
}
$db->dosql("SELECT id " . "FROM categories " . "WHERE parent = {$db->number($this->_id)}", $level);
while ($val = $db->row($level)) {
$subcat = new CodeKBCategory($val['id'], $this->_user);
if (!$subcat->delete($db, $level + 1)) {
$db->abort();
throw new CodeKBException(__METHOD__, "category", "faileddel", null, 1);
}
unset($subcat);
}
$db->dosql("DELETE FROM rights " . "WHERE category = {$db->number($this->_id)}", $level);
$db->dosql("DELETE FROM categories " . "WHERE id = {$db->number($this->_id)}", $level);
if ($first) {
$db->commit();
} else {
return $db->success();
}
if ($db->success()) {
return true;
}
$db->abort();
throw new CodeKBException(__METHOD__, "category", "faileddel");
}
