Call to undefined function sql_query() (custom blocks)

webservant · Posted: Wed Nov 26, 2008 7:39 am

I had this issue with VersionNum.php. Here is the fixed code for /admin/modules/VersionNum.php

Code:

<?php

/************************************************************************/
/* PHP-NUKE: Web Portal System */
/* =========================== */
/* */
/* Copyright (c) 2002 by Francisco Burzi */
/* http://phpnuke.org */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License. */
/************************************************************************/

if (!eregi("admin.php", $_SERVER['PHP_SELF'])) { die ("Access Denied"); }
$result = $db->sql_query("select radminsuper from ".$prefix."_authors where aid='$aid'");
list($radminsuper) = $db->sql_fetchrow($result);
if ($radminsuper==1) {
function MiscAdmin($action) {
   global $admin, $bgcolor2, $prefix, $db;
   include ("header.php");
   GraphicAdmin();
   OpenTable();
   echo "<center><font class=\"title\"><b>"."Miscellaneous Admin Stuff"."</b></font></center>";
   CloseTable();
   echo "<br>";
   OpenTable();
   if ($action=="VersionNumber") {
      echo ""
      ."<table border=\"1\" width=\"100%\" align=\"center\"><tr>"
      ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>"."Version Number"."</b></td></tr><tr>";
      $result = $db->sql_query("select Version_Num from ".$prefix."_config");
      while(list($Version_Num) = $db->sql_fetchrow($result)) {
         echo "<td align=\"center\">$Version_Num</td></tr></table>";
      }
   }
   CloseTable();
   include("footer.php");
}

switch($op) {
   case "VersionNum":
   MiscAdmin("VersionNumber");
   break;
}

}
else {
echo "Access Denied";
}

?>

Raven · Posted: Wed Nov 26, 2008 11:26 am

Thanks!