<% include( "./anmelden.html"); $thisadmin = mysql_fetch_array($result); %> Neue Seite 1 <% ######################################################## # Knowledgebase 1000 (c) Thomas.Tausend@2000-onLine.de # ######################################################## require("/scripts/dbdetails.php"); $dbcode = mysql_connect($host,$user,$pw); if(!$dbcode): echo "Kein Kontakt zur Datenbank"; else: if($send=="neuer Topic"): $query="INSERT INTO topics (ID, title, admin, subof) VALUES ('', '$title', '$admin', '$subof')"; $redraw="ja"; elseif($send=="aktualisieren"): $query="REPLACE INTO topics (ID, title, admin, subof) VALUES ('$ID', '$title', '$admin', '$subof')"; $redraw="ja"; elseif($delete=="ja"): $query="DELETE FROM topics WHERE ID='$edit'"; $redraw="ja"; endif; $result = mysql_db_query($db,$query,$dbcode); ############# echo "send ist: $send
\n"; ############# echo "query is: $query
\n"; if ($thisadmin["master"]==1): $query = "select topics.ID, topics.title, topics.admin, topics.subof, topicsSUB.title as subtitle, admins.aID, admins.name from (topics LEFT JOIN topics AS topicsSUB ON topics.subof = topicsSUB.ID) LEFT JOIN admins ON topics.admin=aID ORDER BY topics.ID"; else: $query = "select topics.ID, topics.title, topics.admin, topics.subof, topicsSUB.title as subtitle, admins.aID, admins.name from (topics LEFT JOIN topics AS topicsSUB ON topics.subof = topicsSUB.ID) LEFT JOIN admins ON topics.admin=aID WHERE aID=" . $thisadmin["aID"] . " ORDER BY topics.ID"; endif; $result = mysql_db_query($db,$query,$dbcode); if(!$result): echo "Konnte Abfrage nicht ausführen!"; else: $num = mysql_num_rows($result); endif; endif; if($redraw=="ja"):%> <% endif; %> <% include("./header.html"); %>

<% echo $num; %> Kategorien befinden sich derzeit im System:

<% while($row = mysql_fetch_array($result)): %> <% endwhile; %>
Aktion
ID
Bezeichnung
Unterkategorie von
Administrator
<% if($thisadmin["name"]==$row["name"] OR $thisadmin["master"]==1):%> "> / "> <% endif; %> <% echo $row["ID"]; %> <% echo $row["title"]; %> <% echo $row["subtitle"]; %> <% echo $row["name"]; %>
value="neuer Topic" <% else: %> value="aktualisieren" <% endif; %> name="send"> <% if(!$edit): %> ? <% else: echo $edit; $query = "SELECT * FROM topics WHERE ID=$edit"; $result = mysql_db_query($db,$query,$dbcode); $row = mysql_fetch_array($result); endif; %> "> <% if($thisadmin["master"]!=0): %> <% else: echo $thisadmin["name"] ; %> " name="admin"> <% endif; %>