Codezwiz >> Forums >> General PHP Nuke Help >> admin/module.php not showing new modules installed

I am trying to add a couple new modules but the module in the admin section that defines whether a module is active or not, isn't showing or not looking for new modules that I have added to the root/admin/module folder. I read the post on the fix at Nukecops.com but it doesn't seem to apply. Telli, the admin/module.php came from when you updated my site to 7.3 from 6.5. Can you verify whether or not the fix was applied?

What do you mean arnt showing up? Do you mean when you add a new module into the modules/ folder that it doesnt show up in the admin> modules managment?

Telli

exactly

I am wondering if it's a permissions issue.. I can't remmeber where that list of permissions is that tells you what each folder should be!

doesn't seem to be a permissions issue... I got all the directories set correctly!

That happends to me when i upgraded v6.5 to v7.3, what i did was, i went to the MySQL data base and added one module manualy, then it become ok.
I think its your MySQL that is stuck, and just need a little push.
It worked for me.

hope that works for you friend,

The admin/modules/modules.php has a bad query in it. Attach that and the table structure for your nuke_modules and I will show you what I mean.

My files are listed. I'm having the same problem.

admin/modules/modules.php

<?php
/************************************************************************/
/* Tweaked by Telli */
/* Tweak Copyright (c) 2003-2004 by Telli                */
/* Web Site: http://codzwiz.com */
/************************************************************************/

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) {

/*********************************************************/
/* REVIEWS Block Functions */
/*********************************************************/

function modules() {
global $prefix, $dbi, $multilingual, $bgcolor2;
include ("header.php");
GraphicAdmin();
OpenTable();
echo "<center><font class=\"title\"><b>"._MODULESADMIN."</b></font></center>";
CloseTable();
$handle=opendir('modules');
while ($file = readdir($handle)) {
if ( (!ereg("[.]",$file)) ) {
   $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."_modules where title='$modlist[$i]'", $dbi);
   list ($mid) = sql_fetch_row($result, $dbi);
   if ($mid == "") {
   sql_query("insert into ".$prefix."_modules values (NULL, '$modlist[$i]', '$modlist[$i]', '0', '0', '1','1')", $dbi);
   }
}
}
$result = sql_query("select title from ".$prefix."_modules", $dbi);
while (list($title) = sql_Fetch_row($result, $dbi)) {
$a = 0;
$handle=opendir('modules');
while ($file = readdir($handle)) {
   if ($file == $title) {
   $a = 1;
   }
}
closedir($handle);
if ($a == 0) {
   sql_query("delete from ".$prefix."_modules where title='$title'", $dbi);
}
}
echo "<br>";
OpenTable();
echo "<br><center><font class=\"option\">"._MODULESADDONS."</font><br><br>"
."<font class=\"content\">"._MODULESACTIVATION."</font><br><br>"
.""._MODULEHOMENOTE."<br><br>"._NOTINMENU."<br><br>"
."<form action=\"admin.php\" method=\"post\">"
."<table border=\"1\" align=\"center\" width=\"90%\"><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>"._VIEW."</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>"._FUNCTIONS."</b></td></tr>";
$main_m = sql_query("select main_module from ".$prefix."_main", $dbi);
list($main_module) = sql_fetch_row($main_m, $dbi);
$result = sql_query("select mid, title, custom_title, active, view, inmenu, mcid from ".$prefix."_modules order by title ASC", $dbi);
while(list($mid, $title, $custom_title, $active, $view, $inmenu, $mcid) = sql_fetch_row($result, $dbi)) {
if ($custom_title == "") {
   $custom_title = ereg_replace("_"," ",$title);
   sql_query("update ".$prefix."_modules 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 ($custom_title == "") {
   $custom_title = ereg_replace("_", " ", $title);
}
if ($view == 0) {
   $who_view = _MVALL;
} elseif ($view == 1) {
   $who_view = _MVUSERS;
} elseif ($view == 2) {
   $who_view = _MVADMIN;
}
if ($title != $main_module AND $inmenu == 0) {
   $title = "[ <big><strong>�;</strong></big> ] $title";
}
if ($title == $main_module) {
   $title = "<b>$title</b>";
   $custom_title = "<b>$custom_title</b>";
   $active = "<b>$active ("._INHOME.")</b>";
   $who_view = "<b>$who_view</b>";
   $puthome = "<i>"._PUTINHOME."</i>";
   $change_status = "<i>$change</i>";
   $background = "bgcolor=\"$bgcolor2\"";
} else {
   $puthome = "<a href=\"admin.php?op=home_module&mid=$mid\">"._PUTINHOME."</a>";
   $change_status = "<a href=\"admin.php?op=module_status&mid=$mid&active=$act\">$change</a>";
   $background = "";
}
echo "<tr><td $background> ;;$title</td><td align=\"center\" $background>$custom_title</td><td align=\"center\" $background>$active</td><td align=\"center\" $background>$who_view</td><td align=\"center\" $background>[ <a href=\"admin.php?op=module_edit&mid=$mid\">"._EDIT."</a> | $change_status | $puthome ]</td></tr>";
}
echo "</table>";
CloseTable();
echo "<br>";

/* Add A New Modules Category */
OpenTable();
echo "<form method=\"post\" action=\"admin.php\">"
."<font class=\"content\"><b>"._ADDMAINCATEGORY."</b><br><br>"
.""._NAME.": <input type=\"text\" name=\"mcname\" size=\"30\" maxlength=\"100\"><br>"
."<input type=\"hidden\" name=\"op\" value=\"modules_add_category\">"
."<input type=\"submit\" value=\""._ADD."\"><br>"
."</form>";
CloseTable();
echo "<br>";

// Modify Category

$result = sql_query("select * from ".$prefix."_modules_categories", $dbi);
$numrows = sql_num_rows($result, $dbi);
if ($numrows>0) {
OpenTable();
echo "<form method=\"post\" action=\"admin.php\">"
   ."<font class=\"content\"><b>"._MODCATEGORY."</b></font><br><br>";
$result2=sql_query("select mcid, mcname from ".$prefix."_modules_categories order by mcname", $dbi);
echo ""._CATEGORY.": <select name=\"cat\">";
while(list($mcid2, $mcname2) = sql_fetch_row($result2, $dbi)) {
   echo "<option value=\"$mcid2\">$mcname2</option>";
}
echo "</select>"
   ."<input type=\"hidden\" name=\"op\" value=\"modules_edit_category\">"
   ."<input type=\"submit\" value=\""._MODIFY."\">"
   ."</form>";
CloseTable();
} else {
}
CZModulecopy();
include ("footer.php");
}

function home_module($mid, $ok=0) {
global $prefix, $dbi;
if ($ok == 0) {
include ("header.php");
GraphicAdmin();
title(""._HOMECONFIG."");
OpenTable();
$result = sql_query("select title from ".$prefix."_modules where mid='$mid'", $dbi);
list($new_m) = sql_fetch_row($result, $dbi);
$result = sql_query("select main_module from ".$prefix."_main", $dbi);
list($old_m) = sql_fetch_row($result, $dbi);
echo "<center><b>"._DEFHOMEMODULE."</b><br><br>"
   .""._SURETOCHANGEMOD." <b>$old_m</b> "._TO." <b>$new_m</b>?<br><br>"
   ."[ <a href=\"admin.php?op=modules\">"._NO."</a> | <a href=\"admin.php?op=home_module&mid=$mid&ok=1\">"._YES."</a> ]</center>";
CloseTable();
CZModulecopy();
include("footer.php");
} else {
$result = sql_query("select title from ".$prefix."_modules where mid='$mid'", $dbi);
list($title) = sql_fetch_row($result, $dbi);
$active = 1;
$view = 0;
$result = sql_query("update ".$prefix."_main set main_module='$title'", $dbi);
$result = sql_query("update ".$prefix."_modules set active='$active', view='$view' where mid='$mid'", $dbi);
Header("Location: admin.php?op=modules");
}
}

function module_status($mid, $active) {
global $prefix, $dbi;
sql_query("update ".$prefix."_modules set active='$active' where mid='$mid'", $dbi);
Header("Location: admin.php?op=modules");
}

function module_edit($mid) {
global $prefix, $dbi;
$main_m = sql_query("select main_module from ".$prefix."_main", $dbi);
list($main_module) = sql_fetch_row($main_m, $dbi);
$result = sql_query("select title, custom_title, view, inmenu, mcid from ".$prefix."_modules where mid='$mid'", $dbi);
list($title, $custom_title, $view, $inmenu, $mcid) = sql_fetch_row($result, $dbi);
include ("header.php");
GraphicAdmin();
title(""._MODULEEDIT."");
OpenTable();
if ($view == 0) {
$sel1 = "selected";
$sel2 = "";
$sel3 = "";
} elseif ($view == 1) {
$sel1 = "";
$sel2 = "selected";
$sel3 = "";
} elseif ($view == 2) {
$sel1 = "";
$sel2 = "";
$sel3 = "selected";
}
if ($title == $main_module) {
$a = " - "._INHOME."";
} else {
$a = "";
}
if ($inmenu == 1) {
$insel1 = "checked";
$insel2 = "";
} elseif ($inmenu == 0) {
$insel1 = "";
$insel2 = "checked";
}
echo "<center><b>"._CHANGEMODNAME."</b><br>($title$a)</center><br><br>"
."<form action=\"admin.php\" method=\"post\">"
."<table border=\"0\"><tr><td>"
.""._CUSTOMMODNAME."</td><td>"
."<input type=\"text\" name=\"custom_title\" value=\"$custom_title\" size=\"50\"></td></tr>";
if ($title == $main_module) {
echo "<input type=\"hidden\" name=\"view\" value=\"0\">"
   ."<input type=\"hidden\" name=\"inmenu\" value=\"$inmenu\">"
   ."</table><br><br>";
} else {
echo "<tr><td>"._VIEWPRIV."</td><td><select name=\"view\">"
   ."<option value=\"0\" $sel1>"._MVALL."</option>"
   ."<option value=\"1\" $sel2>"._MVUSERS."</option>"
   ."<option value=\"2\" $sel3>"._MVADMIN."</option>"
   ."</select></tr></td>"
   ."<tr><td>"._SHOWINMENU."</td><td>"
   ."<input type=\"radio\" name=\"inmenu\" value=\"1\" $insel1> "._YES." ;; ;; <input type=\"radio\" name=\"inmenu\" value=\"0\" $insel2> "._NO.""
   ."</td></tr>";
   $result=sql_query("select mcid, mcname from ".$prefix."_modules_categories order by mcid ASC", $dbi);
   list($mcid, $mcname) = sql_fetch_row($result, $dbi);
   echo "<tr><td>"._CATEGORY.": <select name=\"mcat\">";
   $result2=sql_query("select mcid, mcname from ".$prefix."_modules_categories order by mcid ASC", $dbi);
   while(list($mcid2, $mcname2) = sql_fetch_row($result2, $dbi)) {
      if ($mcid2==$mcid) {
               $sel = "selected";
            } else {
               $sel = "";
   }
      echo "<option value=\"$mcid2\" $sel>$mcname2</option>";
   }
   echo "</select></td></tr></table><br><br>";
}
if ($title != $main_module) {

}
echo "<input type=\"hidden\" name=\"mid\" value=\"$mid\">"
."<input type=\"hidden\" name=\"op\" value=\"module_edit_save\">"
."<input type=\"submit\" value=\""._SAVECHANGES."\">"
."</form>"
."<br><br><center>"._GOBACK."</center>";
CloseTable();
CZModulecopy();
include("footer.php");
}

function module_edit_save($mid, $custom_title, $view, $inmenu, $mcat) {
global $prefix, $dbi;
$mcat = explode("-", $mcat);
   if ($mcat[1]=="") {
   $mcat[1] = 0;
}
$result = sql_query("update ".$prefix."_modules set custom_title='$custom_title', view='$view', inmenu='$inmenu', mcid='$mcat[0]' where mid='$mid'", $dbi);
Header("Location: admin.php?op=modules");
}

function modules_add_category($mcname){
global $prefix, $dbi;
$result=sql_query("SELECT * FROM ".$prefix."_modules_categories WHERE mcname='$mcname'", $dbi);
$numrows = sql_num_rows($result, $dbi);
if($numrows > 0){
   include("header.php");
   GraphicAdmin();
   OpenTable();
      echo "<br><center><font class=\"content\">"
         ."<b>"._ERRORTHECATEGORY." $title "._ALREADYEXIST."</b><br><br>"
         .""._GOBACK."<br><br>";
   CloseTable();
   CZModulecopy();
   include("footer.php");
} else {
   sql_query("INSERT INTO ".$prefix."_modules_categories (mcid, mcname) VALUES (NULL, '$mcname')", $dbi);
   header("Location: admin.php?op=modules");
}
}
function CZModulecopy(){
echo "<br>";
OpenTable();
echo "<div align=\"right\">CZModules for PHPNuke 6.5-6.9 by <a href=\"http://codezwiz.com/\">Telli</a></div>";
echo "<div align=\"right\">Copyright © 2003-2004 by Codezwiz</div>";
CloseTable();
}

function modules_edit_category($cat) {
global $prefix, $dbi;
include ("header.php");
GraphicAdmin();
OpenTable();
echo "<center><font class=\"title\"><b>"._MODULESADMIN."</b></font></center>";
CloseTable();
echo "<br>";
$cat = explode("-", $cat);
if ($cat[1]=="") {
$cat[1] = 0;
}
OpenTable();
echo "<center><font class=\"content\"><b>"._MODCATEGORY."</b></font></center><br><br>";
$result=sql_query("select mcname, visible from ".$prefix."_modules_categories where mcid='$cat[0]'", $dbi);
list($mcname,$visible) = sql_fetch_row($result, $dbi);
if ($visible == 1) {
   $insel1 = "checked";
   $insel2 = "";
   } elseif ($visible == 0) {
   $insel1 = "";
   $insel2 = "checked";
   }

echo "<form action=\"admin.php\" method=\"get\">"
   .""._NAME.": <input type=\"text\" name=\"mcname\" value=\"$mcname\" size=\"51\" maxlength=\"50\"><br>"
   ."Visible? <input type=\"radio\" name=\"visible\" value=\"1\" $insel1> "._YES." ;; ;; <input type=\"radio\" name=\"visible\" value=\"0\" $insel2> "._NO.""
   ."<input type=\"hidden\" name=\"mcid\" value=\"$cat[0]\">"
   ."<input type=\"hidden\" name=\"op\" value=\"modules_edit_category_save\">"
   ."<table border=\"0\"><tr><td>"
   ."<input type=\"submit\" value=\""._SAVECHANGES."\"></form></td><td>"
   ."<form action=\"admin.php\" method=\"get\">"
   ."<input type=\"hidden\" name=\"mcid\" value=\"$cat[0]\">"
   ."<input type=\"hidden\" name=\"op\" value=\"modules_delete_category\">"
   ."<input type=\"submit\" value=\""._DELETE."\"></form></td></tr></table>";
CloseTable();
CZModulecopy();
include("footer.php");
}

function modules_edit_category_save($mcid, $mcname, $visible) {
global $prefix, $dbi;

sql_query("UPDATE ".$prefix."_modules_categories SET mcname='$mcname', visible='$visible' WHERE mcid='$mcid'", $dbi);
Header("Location: admin.php?op=modules");
}

function modules_delete_category($mcid, $ok) {
global $prefix, $dbi;
if($ok==1) {
   sql_query("delete from ".$prefix."_modules_categories where mcid='$mcid'", $dbi);

Header("Location: admin.php?op=modules");
} else {
include("header.php");
GraphicAdmin();
OpenTable();
echo "<br><center><font class=\"option\">";
echo "<b>Are You Sure?</b><br><br>";
}
echo "[ <a href=\"admin.php?op=modules_delete_category&mcid=$mcid&ok=1\">"._YES."</a> | <a href=\"admin.php?op=modules\">"._NO."</a> ]<br><br>";

CloseTable();
CZModulecopy();
include("footer.php");
}

switch ($op){

case "modules":
modules();
break;

case "module_status":
module_status($mid, $active);
break;

case "module_edit":
module_edit($mid);
break;

case "module_edit_save":
module_edit_save($mid, $custom_title, $view, $inmenu, $mcat);
break;

case "home_module":
home_module($mid, $ok);
break;

case "modules_add_category":
modules_add_category($mcname);
break;

case "modules_edit_category":
modules_edit_category($cat);
break;

case "modules_edit_category_save":
modules_edit_category_save($mcid, $mcname, $visible);
break;

case "modules_delete_category":
modules_delete_category($mcid, $ok);
break;
}
} else {
echo "Access Denied";
}

?>

Ok you have 8 fields in the nuke_modules table. Your admin/modules/modules.php is only inserting 7 which is causing the error. Find and change this line in admin/modules/modules.php:

sql_query("insert into ".$prefix."_modules values (NULL, '$modlist[$i]', '$modlist[$i]', '0', '0', '1','1')", $dbi);

did the trick for me too!