private function delete()
{
if (!$this->_user->entrycan("delentry", $this)) {
return false;
}
$db = new CodeKBDatabase();
$db->dosql("SELECT id " . "FROM files " . "WHERE entry = {$db->number($this->_id)}");
while ($val = $db->row()) {
$file = new CodeKBFile($val['id'], $this->_user);
if (!$file->delete(true)) {
return false;
}
unset($file);
}
$db->start();
$db->dosql("DELETE FROM entry_cat " . "WHERE entry = {$db->number($this->_id)}");
$db->dosql("DELETE FROM entries " . "WHERE id = {$db->number($this->_id)}");
$db->commit();
if ($db->success()) {
return true;
}
throw new CodeKBException(__METHOD__, "entry", "faileddel");
}
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;
}
function showsearch()
{
global $lang;
global $conf;
global $site;
global $user;
$site->title($lang['search']['results']);
$site->addfooter("search.php", "search", $lang['search']['extended']);
if ($_POST['cancel']) {
redirect("category.php");
}
if (!$_POST['query'] && !$_POST['author'] && !$_POST['cats']) {
$site->addcontent(notice($lang['search']['noquery']));
return false;
}
$start_search = microtime(true);
$db = new CodeKBDatabase();
$searchquery = buildsearchquery($db->type());
try {
$db->dosql($searchquery);
} catch (Exception $e) {
$site->addcontent(notice($lang['search']['wrongquery']));
}
$end_search = microtime(true);
$search = new CodeKBTemplate("search");
$search->push("extended", url("search.php", $lang['search']['extended']));
$text = phrasereplace($lang['search']['xresultsiny'], "%1%", $db->countrows());
$text = phrasereplace($text, "%2%", round($end_search - $start_search, 2));
$search->push("info", $text);
$resultcode = "";
while ($val = $db->row()) {
try {
$tmpentry = new CodeKBEntry($val['id'], $user);
unset($tmpentry);
} catch (Exception $e) {
continue;
}
$resultitem = new CodeKBTemplate("result");
$content = url("entry.php?id=" . $val['id'], icon($val['symbol'], $val['name'])) . " \n";
$content .= url("entry.php?id=" . $val['id'], htmlentities($val['name']), $val['name']);
$resultitem->push("title", $content);
$content = $db->datetime($val['created']) . " (" . htmlentities($val['author']) . ")";
$resultitem->push("subtitle", $content);
$resultitem->push("description", htmlentities($val['description']));
$resultcode .= $resultitem->__toString();
unset($resultitem);
}
$search->push("results", $resultcode);
$site->addcontent($search);
return true;
}
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 addgroup($name, $clone = 0)
{
// return values
// 1 duplicate group
global $lang;
if ($name == $lang['admin']['nobody']) {
throw new CodeKBException(__METHOD__, "admin", "duplicategroup", $name, 1);
}
$db = new CodeKBDatabase();
$db->start();
$db->dosql("SELECT id " . "FROM groups " . "WHERE name = '{$db->string($name)}'");
if ($db->countrows() > 0) {
$db->abort();
throw new CodeKBException(__METHOD__, "admin", "duplicategroup", $name, 1);
}
// We need a random id
$succ = false;
while ($succ == false) {
$id = mt_rand();
$db->dosql("SELECT id " . "FROM groups " . "WHERE id = {$db->number($id)}");
if ($db->countrows() == 0) {
break;
}
}
$db->dosql("INSERT INTO groups (id, name) " . "VALUES ({$db->number($id)}, " . "'{$db->string($name)}')");
// Now clone rights to new group
$db->dosql("SELECT groupid, " . "category, " . "rights " . "FROM rights " . "WHERE groupid = {$db->number($clone)}");
while ($val = $db->row()) {
$db->dosql("INSERT INTO rights " . "(groupid, category, rights) " . "VALUES ({$db->number($id)}, " . "{$db->number($val['category'])}, " . "{$db->number($val['rights'])})", 1);
}
$db->commit();
if ($db->success()) {
return $id;
}
throw new CodeKBException(__METHOD__, "admin", "failedaddgroup", $name);
}
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");
}
