"); rawoutput(""); rawoutput(""); rawoutput(""); rawoutput(""); rawoutput(""); rawoutput(""); rawoutput("

Code (ohne `, 1 Zeichen)
HEX-Farbe (ohne #) Farbauswähler
HTML-Tag
Style
dürfen User benutzen

"); } elseif ($_GET[op] == "add2") { $show = true; $sql = "SELECT * FROM appoencode WHERE code='".$_POST[code]."'"; $result = db_query($sql); if (db_num_rows($result) > 0) { output("`$ Code (`$_POST[code]) bereits vorhanden.`0`n`n",true); } else { if ($_POST[code] == "") { output("`$ Bitte korrigiere deine Eingabe!`0`n`n"); } else { if ($_POST[color] == "" && $_POST[tag] == "") { output("`$ Es muss entweder eine Farbe oder ein Tag angegeben werden.`0`n`n"); } else { $sql = "INSERT INTO appoencode SET code='".$_POST[code]."',color="; if ($_POST[color] == "") $sql .= "NULL"; else $sql .= "'".$_POST[color]."'"; $sql .= ",tag="; if ($_POST[tag] == "") $sql .= "NULL"; else $sql .= "'".$_POST[tag]."'"; $sql .= ",style="; if ($_POST[style] == "") $sql .= "NULL"; else $sql .= "'".$_POST[style]."'"; $sql .= ",allowed='"; if ($_POST[allowed] == "on") $sql .= "1'"; else $sql .= "0'"; db_query($sql); output("Farbcode erstellt.`n`n"); } } } } elseif ($_GET[op] == "del") { $sql = "DELETE FROM appoencode WHERE id=$_GET[id]"; db_query($sql); output("Farbcode erfolgreich gelöscht!`n`n"); $show = true; } elseif ($_GET[op] == "edit") { $show = false; addnav("Zurück","colors.php"); addnav("","colors.php?op=edit2&id=$_GET[id]"); addnav("","colorpicker.php"); $sql = "SELECT code,color,tag,style,allowed FROM appoencode WHERE id=$_GET[id]"; $result = db_query($sql); $row = db_fetch_assoc($result); rawoutput(""); } elseif ($_GET[op] == "edit2") { $show = true; $sql = "SELECT * FROM appoencode WHERE code='".$_POST[code]."'"; $result = db_query($sql); if (db_num_rows($result) > 1) { output("`$ Code (`$_POST[code]) bereits vorhanden.`0`n`n",true); } else { if ($_POST[code] == "") { output("`$ Bitte korrigiere deine Eingabe!`0`n`n"); } else { if ($_POST[color] == "" && $_POST[tag] == "") { output("`$ Es muss entweder eine Farbe oder ein Tag angegeben werden.`0`n`n"); } else { $sql = "UPDATE appoencode SET code='".$_POST[code]."',color="; if ($_POST[color] == "") $sql .= "NULL"; else $sql .= "'".$_POST[color]."'"; $sql .= ",tag="; if ($_POST[tag] == "") $sql .= "NULL"; else $sql .= "'".$_POST[tag]."'"; $sql .= ",style="; if ($_POST[style] == "") $sql .= "NULL"; else $sql .= "'".$_POST[style]."'"; $sql .= ",allowed='"; if ($_POST[allowed] == "on") $sql .= "1'"; else $sql .= "0'"; $sql .= "WHERE id='".$_POST[id]."'"; db_query($sql); output("Änderungen erfolgreich übernommen.`n`n"); } } } } elseif ($_GET[op] == "reset") { $show = true; $sql = array(); $sql[] = "TRUNCATE TABLE appoencode"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (1, '1', '0000B0', NULL, NULL, '1');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (2, '2', '00B000', NULL, NULL, '1');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (3, '3', '00B0B0', NULL, NULL, '1');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (4, '4', 'B00000', NULL, NULL, '1');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (5, '5', 'B000CC', NULL, NULL, '1');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (6, '6', 'B0B000', NULL, NULL, '1');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (7, '7', 'B0B0B0', NULL, NULL, '1');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (8, '8', 'DDFFBB', NULL, NULL, '1');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (9, '9', '0070FF', NULL, NULL, '1');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (10, '!', '0000FF', NULL, NULL, '1');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (11, '@', '00FF00', NULL, NULL, '1');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (12, '#', '00FFFF', NULL, NULL, '1');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (13, '$', 'FF0000', NULL, NULL, '1');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (14, '%', 'FF00FF', NULL, NULL, '1');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (15, '^', 'FFFF00', NULL, NULL, '1');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (16, '&', 'FFFFFF', NULL, NULL, '1');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (17, ')', '999999', NULL, NULL, '1');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (18, '~', '222222', NULL, NULL, '1');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (19, 'Q', 'FF6600', NULL, NULL, '1');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (20, 'q', 'FF9900', NULL, NULL, '1');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (21, 'r', 'EEBBEE', NULL, NULL, '1');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (22, 'R', 'EEBBEE', NULL, NULL, '1');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (23, 'V', '9A5BEE', NULL, NULL, '1');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (24, 'v', 'AABBEE', NULL, NULL, '1');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (25, 'g', 'aaff99', NULL, NULL, '1');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (26, 'G', 'aaff99', NULL, NULL, '1');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (27, 'T', '6b563f', NULL, NULL, '1');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (28, 't', 'F8DB83', NULL, NULL, '1');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (29, 'c', NULL, 'center', NULL, '0');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (30, 'H', NULL, 'span', 'class=''navhi''', '0');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (31, 'b', NULL, 'strong', NULL, '0');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (32, '¬', NULL, 'pre', NULL, '0');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (33, 'i', NULL, 'i', NULL, '0');"; $sql[] = "INSERT INTO appoencode (id, code, color, tag, style, allowed) VALUES (34, 'n', NULL, 'br /', NULL, '0');"; for ($i = 0;$i < count($sql);$i++) { db_query($sql[$i]); } output("Standartfarben erfolgreich wiederhergestellt.`n`n"); } else { $show = true; } if ($show == true) { addnav("Zurück zur Grotte","superuser.php"); addnav("Zurück zum Weltlichen","village.php"); addnav("Farben"); addnav("Standartfarben wiederherstellen","colors.php?op=reset"); addnav("Hinzufügen","colors.php?op=add"); addnav("Aktualisieren","colors.php"); $sql = "SELECT id,code,color,tag,style,allowed FROM appoencode ORDER BY id"; $result = db_query($sql); output("Vorhandene Farben:"); output("",true); $i = 0; while ($row = db_fetch_assoc($result)) { $i++; $code = "`$row[code]"; $color = "`$row[code]".strtoupper($row[color]); $tag = $row[tag]; $style = $row[style]; $id = $row[id]; $bgcolor = ($i % 2 == 1 ? "trlight" : "trdark"); output("",true); addnav("","colors.php?op=del&id=$id"); addnav("","colors.php?op=edit&id=$id"); } output("

Code	HEX-Farbe	identisch mit HTML-Tag	Style	dürfen User benutzen	Ops.
$code	$color	$tag	$style	",true); if ($row[allowed] == 0) output("nein"); else output("ja"); output("	[löschen\|ändern]