na gut....... ich gebe mal den (noch nicht) fertigen code hier her.... intersannt dürfte für euch der if($do == "add") und if($do == "addforum") bereich sein. hab mit codemonkey und mungo auch schon versucht das mit den $HTTP Variablen zu machen, Variablennamen Änderung uvm. geht alles nicht.
Code: Alles auswählen
<?php
/*
### Newsmod by Frederic Schneider ###
### Copyright 2003 by Frederic Schneider (sge minus adler at web dot de | sge-adler@web.de) ###
*/
define('IN_PHPBB', 1);
$phpbb_root_path = "./../";
require($phpbb_root_path . 'extension.inc');
require('./pagestart.' . $phpEx);
// Forum hinzufügen
if($do == "add")
{
echo "<h1>\n<b>Forum hinzufügen</b>\n</h1>\n";
echo "<p>\n";
echo "Hier kannst du für dein Newssystem, neue Foren hinzufügen.\n<br />\n";
echo "</p>\n";
$sql = "SELECT forum_id,forum_name FROM ".$table_prefix."forums";
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, "Couldn't obtain news data", "", __LINE__, __FILE__, $sql);
}
else
{
echo "<div align=\"center\">";
echo "<form action=\"news.php?do=addforum\" method=\"post\">\n";
echo "<select name=\"forenid\">\n";
while($row=$db->sql_fetchrow($result))
{
echo "<option value=\"$row[forum_id]\">$row[forum_name]</option>\n";
}
echo "</select>\n<br />\n";
echo "<input type=\"submit\" name=\"submit\" value=\"Forum hinzufügen\" />\n";
echo "</form>\n";
echo "</div>\n";
}
}
// Forum editieren
if($do == "edit")
{
echo "<h1>\n<b>Forum editieren</b>\n</h1>\n";
echo "<p>\n";
echo "Hier kannst du für dein Newssystem, Foren bearbeiten.\n<br />\n";
echo "</p>\n";
$sql = "SELECT forenid FROM ".$table_prefix."news";
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, "Couldn't obtain news data", "", __LINE__, __FILE__, $sql);
}
else
{
echo "<table cellspacing=\"1\" cellpadding=\"4\" border=\"0\" align=\"center\" class=\"forumline\">\n";
echo "<tr>\n";
echo "<th class=\"thCornerL\">Forumname</th>\n";
echo "<th class=\"thTop\">Aktion</th>\n";
echo "</tr>\n";
while($row=$db->sql_fetchrow($result))
{
$forenid = $row[forenid];
$sql2 = "SELECT forum_name FROM ".$table_prefix."forums WHERE forum_id=\"$forenid\"";
if(!$result2 = $db->sql_query($sql2))
{
message_die(GENERAL_ERROR, "Couldn't obtain news data", "", __LINE__, __FILE__, $sql);
}
else
{
while($row2=$db->sql_fetchrow($result2))
{
echo "<tr>\n";
echo "<td class=\"row1\" align=\"center\">$row2[forum_name]</td>\n";
echo "<td class=\"row1\" align=\"center\"><a href=\"news.php?do=delete&forenid=$row[forenid]\">Löschen</a></td>\n";
echo "</tr>\n";
}
}
}
echo "</table>\n";
}
}
// Forum hinzufügen (SELECT Vorgang)
if($do == "addforum")
{
echo "$forenid\n<br/>\n";
echo "<h1>\n<b>Forum hinzufügen</b>\n</h1>\n";
$sql = "SELECT forenid FROM ".$table_prefix."news WHERE forenid=\"$forenid\"";
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, "Couldn't obtain news data", "", __LINE__, __FILE__, $sql);
}
else
{
if($db->sql_numrows($result) != "0")
{
echo "<p>\n";
echo "Dieser Eintrag existiert schon in der Datenbank!";
echo "</p>\n";
}
else
{
echo "<p>\n";
echo "funzt!";
echo "</p>\n";
}
}
}
// Forum löschen
if($do == "delete")
{
echo "<h1>\n<b>Forum löschen</b>\n</h1>\n";
$sql = "DELETE FROM ".$table_prefix."news WHERE forenid=\"$forenid\"";
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, "Couldn't obtain news data", "", __LINE__, __FILE__, $sql);
}
else
{
echo "<p>\n";
echo "Das Forum wurde erfolgreich gelöscht!\n";
echo "</p>\n";
}
}
echo "<br />\n<br />\n";
echo "<div align=\"center\"><span class=\"copyright\">News-Mod by <a href=\"mailto:sge-adler@web.de\">Frederic Schneider</a></span></div>";
?>