function show($id, $text = "")
{
if (!session::get("tooltips")) {
// display text from database
if ($id) {
$helpArray = fetch_to_array(database::query("SELECT * FROM system WHERE name='{$id}'"), "");
if ($helpArray) {
$entry = current($helpArray);
}
$right = right::get_field($id);
$user = right::get("rights");
$temp = $entry[text];
// admin informations
if (right::superuser()) {
$temp .= "<hr><table>";
$temp .= "<tr><td>fieldname</td><td>{$id}</td></tr>";
// fieldname
$temp .= "<tr><td>edit</td><td>" . right::int2string($right[edit]) . "</td></tr>";
// edit rights
$temp .= "<tr><td>view</td><td>" . right::int2string($right[view]) . "</td></tr>";
// view rights
$temp .= "</table>";
$clickEvent = " onmousedown = edit("{$id}")";
}
if ($text) {
$temp .= "<hr>{$text}";
}
return "onmouseover='return overlib("" . $temp . "");' onmouseout='return nd()' {$clickEvent}";
}
// display special text
}
}
function get($name, $exact = "")
{
if ($name != "") {
// use global parameters
if (!$exact) {
if (session::get("searchexact")) {
$nameString = "name='{$name}'";
} elseif (session::get("searchstart")) {
$nameString = "name LIKE '{$name}%'";
} else {
$nameString = "name LIKE '%{$name}%'";
}
} else {
switch ($exact) {
case exact:
$nameString = "name='{$name}'";
break;
case start:
$nameString = "name LIKE '{$name}%'";
break;
case like:
$nameString = "name LIKE '%{$name}%'";
break;
}
}
if (session::get("searchcom")) {
$comString = " or comment LIKE '%{$name}%'";
} else {
$comString = "";
}
if (session::get("searchorder")) {
$visibleString = " and visible='0'";
} else {
$visibleString = "";
}
if (session::get("searchowner")) {
$ownerString = " and owner='" . session::get("searchowner") . "'";
} else {
$ownerString = "";
}
if (session::get("searchentrytype")) {
$entrytypeString = " and entrytype='" . session::get("searchentrytype") . "'";
} else {
$entrytypeString = "";
}
if (session::get("searchstatus")) {
$statusString = " and status='" . session::get("searchstatus") . "'";
} else {
$statusString = "";
}
$search_res = mysql_query("SELECT ID FROM entry WHERE ({$nameString} {$comString}) {$desString} {$visibleString} {$ownerString} {$entrytypeString} {$statusString} ORDER BY name");
return fetch_to_array($search_res, "");
} else {
return FALSE;
}
// no search string
}
function get_field($name)
{
if ($name) {
$tempArray = fetch_to_array(database::query("SELECT * FROM system WHERE name='{$name}'"), "");
if (is_array($tempArray)) {
return current($tempArray);
}
} else {
return false;
}
}
<html>
<head><TITLE></TITLE></head>
<body>
<h1>Transfer Parents to new table</h1>
<?php
include "liboutput.php";
include "libdatabase.php";
// connect database
$daba = new database();
$daba->connect("localhost", "iggmp", "1s87J37r0");
$daba->select("thesaurus");
$res = mysql_query("SELECT * FROM entry where descriptor='0'");
$tempArray = fetch_to_array($res, "");
echo "Anzahl: " . count($tempArray) . "<hr>";
foreach ($tempArray as $entry) {
echoall($entry);
database::query("UPDATE entry SET status='1' WHERE ID='" . $entry[ID] . "'");
echo "<hr>";
}
?>
</body></html>
function print_search($searchString)
{
echo "<h1>Liste der Deskriptoren aus der Suche nach <i>'" . session::get("search") . "'</i></h1>";
echo "<p><b>Suchparameter:</b><br>";
echo "<i>Stand vom " . date("d. M Y, H:i:s") . "</i></p>";
echo "<ul>";
if (session::get("searchexact")) {
echo "<li>Exakte Suche</li>";
} elseif (!session::get("searchstart")) {
echo "<li>Freie Suche</li>";
} else {
echo "<li>Suche am Wortanfang</li>";
}
if (session::get("searchcom")) {
echo "<li>Suche auch in Erläuterungen</li>";
}
if (session::get("searchentrytype")) {
$tempArray = thesaurus::get_entrytype_name(session::get("searchentrytype"));
}
echo "<li>Suche nach Begriffstyp '" . $tempArray[type] . "'</li>";
if (session::get("searchstatus")) {
echo "<li>Suche nach Status '" . thesaurus::get_status_name(session::get("searchstatus")) . "'</li>";
}
if (session::get("searchstatus")) {
echo "<li>Suche nach Benutzer '" . user::name(session::get("searchowner")) . "'</li>";
}
echo "</ul>";
echo "<br>";
$entryArray = explode(",", $searchString);
foreach ($entryArray as $element) {
$descriptorArray = fetch_to_array(database::query("SELECT * FROM entry WHERE ID='{$element}'"), "");
foreach ($descriptorArray as $entry) {
export::descriptor($entry[ID], $searchString);
echo "<hr>";
}
}
}
$user = $_GET[user];
$md5Password = md5($_GET[password]);
database::query("INSERT INTO user SET user='******',password='******',`group`='4'");
} else {
echo "<div id='alert'><b>User schon vergeben</div>";
}
}
break;
case deleteuser:
if (user::exists($id)) {
echoalert("Benutzer " . user::name($id) . " gelöscht");
database::query("DELETE FROM user WHERE ID='{$id}'");
}
break;
}
$userArray = fetch_to_array(database::query("SELECT user.ID,user.user,user.password,user.group,user.status,`group`.name FROM user,`group` WHERE user.group=group.ID ORDER BY user"), "");
// list users
echo "<div id='infobig'>";
echo "<fieldset><legend>User</legend>";
echo "<table border='1'>";
echo "<th>User</th>";
echo "<th>Group</th>";
echo "<th></th>";
echo "<th></th>";
echo "<th>Last Login</th>";
echo "<th>Kandidaten</th>";
// edit users and groups
$bgColor = "lightblue";
foreach ($userArray as $entry) {
echo "<tr style='background-color:{$bgColor}'>";
// toggle backgroud color
function login($user, $password)
{
$tempArray = fetch_to_array(database::query("SELECT * FROM user WHERE user='******' and password='******'"), "");
if (is_array($tempArray)) {
$tempArray = current($tempArray);
session::set("user", $tempArray[ID]);
save_status($_SESSION);
} else {
echojavascript("Login oder Passwort falsch");
}
}
function newstatus()
{
$ref = database::query("SELECT * FROM statustype WHERE new=1");
$temp = fetch_to_array($ref, "ID");
return $temp[0];
}
function get_list()
{
return fetch_to_array(database::query("SELECT ID AS value,name AS text,rights FROM `group` ORDER BY name"), "");
}
function get_linkstatus($typeID)
{
$tempArray = fetch_to_array(database::query("SELECT * FROM linktype WHERE ID='{$typeID}'"), "");
if (is_array($tempArray)) {
$tempArray = current($tempArray);
}
return $tempArray[hyrarchic];
}
