I have this section of code here that is supposed to list all of the files in a directory and save their names to a mySQL database. I have tried over and over again to try to fix the problem but nothing I do works. And the best part is, I just sent a news article to PHPNuke.org about this great new module I have made and they are going to publish it on their homepage. Any help would really be appreciated.
<?PHP
if (!eregi("admin.php", $PHP_SELF))
{
die ("Access Denied");
}
$result = sql_query("select radminsuper from ".$prefix."_authors where aid='$aid'", $dbi);
list($radminsuper) = sql_fetch_row($result, $dbi);
if ($radminsuper==1)
{
function nwcmusic()
{
global $prefix, $dbi, $multilingual, $bgcolor2;
include ("header.php");
GraphicAdmin();
OpenTable();
echo "<center><font class=\"title\"><b>NWC Music Admin</b></font></center>";
CloseTable();
$handle=opendir('mmm');
while ($file = readdir($handle))
{
$modlist .= "$file ";
}
closedir($handle);
$modlist = explode(" ", $modlist);
sort($modlist);
for ($i=0; $i < sizeof($modlist); $i++)
{
if($modlist[$i] != "")
{
$result = sql_query("select mid from ".$prefix."_nwcmusic where title='$modlist[$i]'", $dbi);
list ($mid) = sql_fetch_row($result, $dbi);
if ($mid == "")
{
sql_query("insert into ".$prefix."_nwcmusic values (NULL, '$modlist[$i]', '$modlist[$i]', '0', '0', '1')", $dbi);
}
}
}
$result = sql_query("select title from ".$prefix."_nwcmusic", $dbi);
while (list($title) = sql_Fetch_row($result, $dbi))
{
$a = 0;
$handle=opendir('mmm');
while ($file = readdir($handle))
{
if ($file == $title)
{
$a = 1;
}
elseif ($file =='.')
{
$b = 1;
}
elseif ($file =='..')
{
$c = 1;
}
}
closedir($handle);
if ($a == 0)
{
sql_query("delete from ".$prefix."_nwcmusic where title='$title'", $dbi);
}
elseif ($b == 1)
{
sql_query("delete from ".$prefix."_nwcmusic where title='.'", $dbi);
}
elseif ($b == 1)
{
sql_query("delete from ".$prefix."_nwcmusic where title='.'", $dbi);
}
elseif ($c == 1)
{
sql_query("delete from ".$prefix."_nwcmusic where custom_title='..'", $dbi);
}
elseif ($c == 1)
{
sql_query("delete from ".$prefix."_nwcmusic where custom_title='..'", $dbi);
}
}
echo "<br>";
OpenTable();
echo "<br><center><font class=\"option\">"
."<table border=\"1\" align=\"center\"><tr><td align=\"center\" bgcolor=\"$bgcolor2\">"
."<b>"._TITLE."</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>"._CUSTOMTITLE."</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>"._STATUS."</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>Menu Status</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>"._FUNCTIONS."</b></td></tr>";
$result = sql_query("select mid, title, custom_title, active, inmenu from ".$prefix."_nwcmusic order by title ASC", $dbi);
while(list($mid, $title, $custom_title, $active, $inmenu) = sql_fetch_row($result, $dbi)) {
if ($custom_title == "")
{
$custom_title = ereg_replace("_"," ",$title);
sql_query("update ".$prefix."_nwcmusic set custom_title='$custom_title' where mid='$mid'", $dbi);
}
if ($active == 1)
{
$active = "Active";
$change = "Deactivate";
$act = 0;
}
else
{
$active = "<i>Inactive</i>";
$change = "Activate";
$act = 1;
}
if ($inmenu == 1)
{
$menu = "Active";
$menuchange = "Delete From Menu";
$acte = 0;
}
else
{
$menu = "Inactive";
$menuchange = "Put In Menu";
$acte = 1;
}
$change_status = "<a href=\"admin.php?op=nwcmusic_status&mid=$mid&active=$act\">$change</a>";
$menulink = "<a href=\"admin.php?op=nwcmusic_menu&mid=$mid&menu=$acte\">$menuchange</a>";
echo "<tr><td $background align=\"center\"> $title</td><td align=\"center\" $background>$custom_title</td><td align=\"center\" $background>$active</td><td align=\"center\" $background>$menu</td><td align=\"center\" $background>[ <a href=\"admin.php?op=nwcmusic_edit&mid=$mid\">"._EDIT."</a> | $change_status |<br> $menulink]</td></tr>";
}
echo "</table>";
CloseTable();
include ("footer.php");
}
function nwcmusic_status($mid, $active)
{
global $prefix, $dbi;
sql_query("update ".$prefix."_nwcmusic set active='$active' where mid='$mid'", $dbi);
Header("Location: admin.php?op=nwcmusic");
}
function nwcmusic_menu($mid, $menu)
{
global $prefix, $dbi;
sql_query("update ".$prefix."_nwcmusic set inmenu='$menu' where mid='$mid'", $dbi);
Header("Location: admin.php?op=nwcmusic");
}
function nwcmusic_edit($mid)
{
global $prefix, $dbi;
$result = sql_query("select title, custom_title from ".$prefix."_nwcmusic where mid='$mid'", $dbi);
list($title, $custom_title) = sql_fetch_row($result, $dbi);
include ("header.php");
GraphicAdmin();
title("Nwc Music Edit");
OpenTable();
echo "<center><b>Editing: </b>($title$a)</center><br><br>"
."<form action=admin.php method=\"post\">"
."<table border=\"0\"><tr><td>"
."Custom Music Name</td><td>"
."<input type=\"text\" name=\"custom_title\" value=\"$custom_title\" size=\"50\"></td></tr>"
."</td></tr><tr><td colspan=2><input type=\"hidden\" name=\"mid\" value=\"$mid\">"
."<input type=\"hidden\" name=\"op\" value=\"nwcmusic_edit_save\">"
."<center><input type=\"submit\" value=\""._SAVECHANGES."\"></tr></td></table>"
."</form>"
."<br><br><center>"._GOBACK."</center>";
CloseTable();
include ("footer.php");
}
function nwcmusic_edit_save($mid, $custom_title)
{
global $prefix, $dbi;
$result = sql_query("update ".$prefix."_nwcmusic set custom_title='$custom_title' where mid='$mid'", $dbi);
Header("Location: admin.php?op=nwcmusic");
}
switch ($op)
{
case "nwcmusic":
nwcmusic();
break;
case "nwcmusic_status":
nwcmusic_status($mid, $active);
break;
case "nwcmusic_menu":
nwcmusic_menu($mid, $menu);
break;
case "nwcmusic_edit":
nwcmusic_edit($mid);
break;
case "nwcmusic_edit_save":
nwcmusic_edit_save($mid, $custom_title);
break;
}
}
else {
echo "Access Denied";
}
?>
(The script later calls for the information and it is not showing it.)
