Note: this list is kept only as a demonstration for CVSNotice. For the latest CVS notices, see the Xaraya and Postnuke sites
View Statistics - Next Notice - Previous NoticeDirectory filter : [ all ] / postnuke_modules / New_pnadmin / html / modules / admin [ view in CVS ]
| Date | Directory [filter] | File(s) [view] | Author [filter] |
| 10 Aug 2002 00:31:54 | postnuke_modules/New_pnadmin/html/modules/admin | pnfunctions.php,1.2,1.3 pninit.php,1.2,1.3 | Richard Cave |
| ADODB conversion. | |||
Update of /home/cvsroot/postnuke_modules/New_pnadmin/html/modules/admin
In directory ns7.hostnuke.net:/tmp/cvs-serv26607/New_pnadmin/html/modules/admin
Modified Files:
pnfunctions.php pninit.php
Log Message:
ADODB conversion.
Index: pnfunctions.php
===================================================================
RCS file: /home/cvsroot/postnuke_modules/New_pnadmin/html/modules/admin/pnfunctions.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** pnfunctions.php 5 Aug 2002 11:10:36 -0000 1.2
--- pnfunctions.php 10 Aug 2002 00:31:51 -0000 1.3
***************
*** 25,59 ****
// for use in admin.
// ----------------------------------------------------------------------
- // Functions in "old" admin:
- // ----------------------------------------------------------------------
! function getAllSkins(){
! $ModName = basename(dirname(__FILE__));
! $skinDir = "modules/".$ModName."/skins";
! $handle = opendir($skinDir);
! $i = 0;
[...2836 lines suppressed...]
! elseif (file_exists($file.'jpg'))
! $imgfile = $file.'jpg';
! elseif (file_exists($file.'png'))
! $imgfile = $file.'png';
! else $imgfile = 'modules/'.$ModName.'/images/default.gif';
menu_add_option("admin.php?module=$mod[directory]&op=main", $mod['displayname'], $imgfile);
***************
*** 1331,1335 ****
{
OpenTable();
! echo "<center><font class=\"pn-title\"><b>".$title."</b></font></center>";
CloseTable();
}
--- 1585,1589 ----
{
OpenTable();
! echo "<center><font class=\"pn-title\"><b>".$title."</b></font></center>";
CloseTable();
}
Index: pninit.php
===================================================================
RCS file: /home/cvsroot/postnuke_modules/New_pnadmin/html/modules/admin/pninit.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** pninit.php 5 Aug 2002 11:10:36 -0000 1.2
--- pninit.php 10 Aug 2002 00:31:51 -0000 1.3
***************
*** 24,28 ****
// ----------------------------------------------------------------------
-
// --------------------------------------------
// This is not a standardfunction in pninit.php
--- 24,27 ----
***************
*** 30,163 ****
function isInAGroup($mID)
{
! list($dbconn) = pnDBGetConn();
!
if(function_exists(admin_pntables)){
! $pntable = admin_pntables();
}
! else{
! $pntable = pnDBGetTables();
}
! $table = $pntable['member_table'];
! $column = &$pntable['members'];
! $query = "SELECT * FROM ".$table." WHERE ".$column['mid']."='".$mID."'";
! $result = mysql_query($query);
! return mysql_numrows($result);
}
! function restoreToDefault(){
! $ModName = basename(dirname(__FILE__));
! list($dbconn) = pnDBGetConn();
! if(function_exists(admin_pntables)){
! $pntable = admin_pntables();
! }else{
! $pntable = pnDBGetTables();
! }
! $modTable = pnConfigGetVar('prefix')."_modules";
!
!
! // Delete all records of any tab and modules
! $table = $pntable['member_table'];
! mysql_query("DELETE FROM ".$table);
! if (mysql_error()){
! pnSessionSetVar('errormsg', _CREATETABLEFAILED);
! echo "<p>".nl2br($query). " <br> ".mysql_error()."</p>";
return false;
}
! $table = $pntable['group_table'];
! mysql_query("DELETE FROM ".$table);
! if (mysql_error()){
! pnSessionSetVar('errormsg', _CREATETABLEFAILED);
! echo "<p>".nl2br($query). " <br> ".mysql_error()."</p>";
return false;
! } // Create a list of default tabs
!
! // ----------------------------------------------------------------------------------------
! // All tabnames
! $tabNames = array("Configuration","Users","Content","Quick Links");
! // ----------------------------------------------------------------------------------------
! // All sorting of tabs
! $sort['Quick Links'] = 1;
! $sort['Content'] = 2;
! $sort['Users'] = 3;
! $sort['Configuration'] = 4;
! // ----------------------------------------------------------------------------------------
! // All sorting of tabs
! $lockID['Quick Links'] = 0;
! $lockID['Content'] = 0;
! $lockID['Users'] = 0;
! $lockID['Configuration'] = 1;
! // ----------------------------------------------------------------------------------------
! // All sorting of tabs
! $defaultID['Quick Links'] = 1;
! $defaultID['Content'] = 0;
! $defaultID['Users'] = 0;
! $defaultID['Configuration'] = 0;
! // ----------------------------------------------------------------------------------------
! // All default modules in tabs, each number is the ID in the table "modules"
! $modsIDs['Quick Links'] = array("6","60","84","86","77","19","52","25");
! $modsIDs['Content'] = array("8","9","10","13","3","20","27","90","33");
! $modsIDs['Users'] = array("14","16","18","53","32");
! $modsIDs['Configuration'] = array("7","96","11","12","15","17","41","93","21","22","29","31");
! // ----------------------------------------------------------------------------------------
! // Let's loop and create tabs and it's content.
! for($x = 0;$x < count($tabNames);$x++){
! $newTabName = $tabNames[$x];
! $sortOrder = $sort[$newTabName];
! $listODModIDs = $modsIDs[$newTabName];
! $UseLock = $lockID[$newTabName];
! $default = $defaultID[$newTabName];
! $infotype_cols = &$pntable['group'];
! $query = "INSERT INTO ".$pntable['group_table']." (". $infotype_cols['id'].",". $infotype_cols['lock'].",".$infotype_cols['order'].",". $infotype_cols['name'].",". $infotype_cols['default'].") VALUES ('','".$UseLock."','".$sortOrder."','".$newTabName."','".$default."')";
! mysql_query($query);
! if (mysql_error()){
! pnSessionSetVar('errormsg', _CREATETABLEFAILED);
! echo "<p>".nl2br($query). " <br> ".mysql_error()."</p>";
! return false;
! }else{
! $infotype_cols = &$pntable['members'];
! $groupID = mysql_insert_id();
! for($i = 0;$i < count($listODModIDs);$i++){
! $modID = $listODModIDs[$i];
! $query = "INSERT INTO ".$pntable['member_table']." (". $infotype_cols['gid'].",". $infotype_cols['mid'].") VALUES ('".$groupID."','".$modID."')";
! mysql_query($query);
! }
! }
}
! // ----------------------------------------------------------------------------------------
! // Create a Misc tab where all other modules should be stored.
! //
$infotype_cols = &$pntable['group'];
! $newTabName = "Misc";
! $sortOrder = "";
! $default = 0;
! $query = "INSERT INTO ".$pntable['group_table']." (". $infotype_cols['id'].",". $infotype_cols['lock'].",".$infotype_cols['order'].",". $infotype_cols['name'].",". $infotype_cols['default'].") VALUES ('','0','".(count($tabNames)+1)."','".$newTabName."','".$default."')";
! mysql_query($query);
! if (mysql_error()){
! pnSessionSetVar('errormsg', _CREATETABLEFAILED);
! echo "<p>".nl2br($query). " <br> ".mysql_error()."</p>";
return false;
}else{
! $miscID = mysql_insert_id();
! }
!
! // ----------------------------------------------------------------------------------------
! // Modules in group
! $infotype_cols = &$pntable['members'];
! $result = mysql_query("SELECT * FROM ".pnConfigGetVar('prefix')."_modules WHERE pn_admin_capable='1'");
! $num = mysql_numrows($result);
! for ($i = 0 ;$i < $num; $i++){
! $modID = mysql_result($result, $i, "pn_id");
! if(isInAGroup($modID) < 1){
! $query = "INSERT INTO ".$pntable['member_table']." (". $infotype_cols['gid'].",". $infotype_cols['mid'].") VALUES ('".$miscID."','".$modID."')";
! mysql_query($query);
! if(mysql_error()){
! pnSessionSetVar('errormsg', _CREATETABLEFAILED);
! echo "<p>".nl2br($sql). " <br> ".mysql_error()."</p>";
! return false;
! }
! }
! }
return true;
}
--- 29,206 ----
function isInAGroup($mID)
{
! list($dbconn) = pnDBGetConn();
if(function_exists(admin_pntables)){
! $pntable = admin_pntables();
! }else{
! $pntable = pnDBGetTables();
}
! $table = $pntable['member_table'];
! $column = &$pntable['members'];
!
! $query = "SELECT COUNT(*) FROM ".$table." WHERE ".$column['mid']."='".$mID."'";
! $result = $dbconn->Execute( $query );
! if ($result == false) {
! pnSessionSetVar('errormsg', "SELECT of ".$table." table failed.");
! $recordCount = 0;
! } else {
! $recordCount = $result->fields[0];
}
!
! return $recordCount;
}
! function restoreToDefault()
! {
! $ModName = basename(dirname(__FILE__));
! list($dbconn) = pnDBGetConn();
!
! if(function_exists(admin_pntables)){
! $pntable = admin_pntables();
! }else{
! $pntable = pnDBGetTables();
! }
! $modTable = pnConfigGetVar('prefix')."_modules";
!
!
! // Delete all records of any tab and modules
! $table = $pntable['member_table'];
! $query = "DELETE FROM ".$table;
! $result = $dbconn->Execute( $query );
! if ($result == false) {
! pnSessionSetVar('errormsg', "DELETE of ".$table." table failed.");
return false;
}
!
! $table = $pntable['group_table'];
! $query = "DELETE FROM ".$table;
! $result = $dbconn->Execute( $query );
! if ($result == false) {
! pnSessionSetVar('errormsg', "DELETE of ".$table." table failed.");
return false;
! }
!
! // Create a list of default tabs
!
! // ----------------------------------------------------------------------------------------
! // All tabnames
! $tabNames = array("Configuration","Users","Content","Quick Links");
! // ----------------------------------------------------------------------------------------
! // All sorting of tabs
! $sort['Quick Links'] = 1;
! $sort['Content'] = 2;
! $sort['Users'] = 3;
! $sort['Configuration'] = 4;
! // ----------------------------------------------------------------------------------------
! // All sorting of tabs
! $lockID['Quick Links'] = 0;
! $lockID['Content'] = 0;
! $lockID['Users'] = 0;
! $lockID['Configuration'] = 1;
! // ----------------------------------------------------------------------------------------
! // All sorting of tabs
! $defaultID['Quick Links'] = 1;
! $defaultID['Content'] = 0;
! $defaultID['Users'] = 0;
! $defaultID['Configuration'] = 0;
! // ----------------------------------------------------------------------------------------
! // All default modules in tabs, each number is the ID in the table "modules"
! $modsIDs['Quick Links'] = array("6","60","84","86","77","19","52","25");
! $modsIDs['Content'] = array("8","9","10","13","3","20","27","90","33");
! $modsIDs['Users'] = array("14","16","18","53","32");
! $modsIDs['Configuration'] = array("7","96","11","12","15","17","41","93","21","22","29","31");
! // ----------------------------------------------------------------------------------------
! // Let's loop and create tabs and it's content.
! for($x = 0;$x < count($tabNames);$x++){
! $newTabName = $tabNames[$x];
! $sortOrder = $sort[$newTabName];
! $listODModIDs = $modsIDs[$newTabName];
! $UseLock = $lockID[$newTabName];
! $default = $defaultID[$newTabName];
! $infotype_cols = &$pntable['group'];
!
! // Generate id
! $groupID = $dbconn->GenId($infotype_cols['id']);
!
! $query = "INSERT INTO ".$pntable['group_table'].
! " (". $infotype_cols['id'].",". $infotype_cols['lock'].",".$infotype_cols['order'].",". $infotype_cols['name'].",". $infotype_cols['default']." )".
! " VALUES ('".$groupID."','".$UseLock."','".$sortOrder."','".$newTabName."','".$default."')";
!
! $resultIns = $dbconn->Execute( $query );
! if ($resultIns == false) {
! pnSessionSetVar('errormsg', "INSERT into ".$pntable['group_table']." table failed.");
! return false;
! }else{
! // Get the newly generated id
! $groupID = $dbconn->PO_Insert_ID( $pntable, $infotype_cols['id'] );
!
! // New table - not to be confused with above id from group table
! $infotype_cols = &$pntable['members'];
!
! for($i = 0;$i < count($listODModIDs);$i++){
! $modID = $listODModIDs[$i];
!
! $query = "INSERT INTO ".$pntable['member_table'].
! " (". $infotype_cols['gid'].")".",". $infotype_cols['mid'].
! " VALUES ('".$groupID."','".$modID."')";
!
! $resultInsSub = $dbconn->Execute( $query );
! if ($resultInsSub == false) {
! pnSessionSetVar('errormsg', "INSERT into ".$pntable['member_table']." table failed.");
! return false;
! }
! }
! }
}
! // ----------------------------------------------------------------------------------------
! // Create a Misc tab where all other modules should be stored.
! //
$infotype_cols = &$pntable['group'];
! $newTabName = "Misc";
! $sortOrder = "";
! $default = 0;
!
! // Generate id
! $miscID = $dbconn->GenId($infotype_cols['id']);
!
! $query = "INSERT INTO ".$pntable['group_table'].
! " (". $infotype_cols['id'].",". $infotype_cols['lock'].",".$infotype_cols['order'].",". $infotype_cols['name'].",". $infotype_cols['default'].")".
! " VALUES ('".$miscID."','".$default."','".(count($tabNames)+1)."','".$newTabName."','".$default."')";
!
! $resultIns = $dbconn->Execute( $query );
! if ($resultIns == false) {
! pnSessionSetVar('errormsg', "INSERT into ".$pntable['group_table']." table failed.");
return false;
}else{
! // Get the newly generated id
! $miscID = $dbconn->PO_Insert_ID( $pntable, $infotype_cols['id'] );
! // ----------------------------------------------------------------------------------------
! // Modules in group
! $infotype_cols = &$pntable['members'];
! $query = "SELECT ".$column['pn_id']." FROM ".pnConfigGetVar('prefix')."_modules WHERE pn_admin_capable='1'";
!
! $resultSel = $dbconn->Execute( $query );
! if ( $resultSel == false ) {
! pnSessionSetVar('errormsg', "SELECT of ".pnConfigGetVar('prefix')."_modules table failed.");
! return false;
! }
! for (; !$resultSel->EOF; $resultSel->MoveNext() ) {
! $modID = $resultSel->fields[0];
!
! if(isInAGroup($modID) < 1){
! $query = "INSERT INTO ".$pntable['member_table'].
! " (". $infotype_cols['gid'].",". $infotype_cols['mid'].")".
! " VALUES ('".$miscID."','".$modID."')";
!
! $resultInsSub = $dbconn->Execute( $query );
! if ($resultInsSub == false) {
! pnSessionSetVar('errormsg', "INSERT into ".$pntable['member_table']." table failed.");
! return false;
! }
! }
! }
! }
!
return true;
}
***************
*** 167,182 ****
function admin_init()
{
! list($dbconn) = pnDBGetConn();
! $pntable = pnDBGetTables();
if(!is_array($pntable)){
! echo "<p><b>No tables found to create!</b></p>";
}
! // :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
! // ============================== NEXT TABLE ===============================
! // group_table
! // :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
$templatetable = $pntable['group_table'];
$templatecolumn = &$pntable['group'];
! $sql = "CREATE TABLE ".$templatetable." (
".$templatecolumn['id']." INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
".$templatecolumn['name']." VARCHAR(200) NOT NULL DEFAULT '',
--- 210,225 ----
function admin_init()
{
! list($dbconn) = pnDBGetConn();
! $pntable = pnDBGetTables();
if(!is_array($pntable)){
! echo "<p><b>No tables found to create!</b></p>";
}
! // :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
! // ============================== NEXT TABLE ===============================
! // group_table
! // :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
$templatetable = $pntable['group_table'];
$templatecolumn = &$pntable['group'];
! $query = "CREATE TABLE ".$templatetable." (
".$templatecolumn['id']." INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
".$templatecolumn['name']." VARCHAR(200) NOT NULL DEFAULT '',
***************
*** 186,222 ****
".$templatecolumn['default']." TINYINT(1) DEFAULT '0' NOT NULL
)";
! mysql_query($sql);
! // Check for an error with the database code, and if so set an
! // appropriate error message and return
! if (mysql_error()) {
! pnSessionSetVar('errormsg', _CREATETABLEFAILED);
! return false;
}
! // :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
! // ============================== NEXT TABLE ===============================
! // member_table
! // :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
$templatetable = $pntable['member_table'];
$templatecolumn = &$pntable['members'];
! $sql = "CREATE TABLE ".$templatetable." (
".$templatecolumn['gid']." INT(11),
".$templatecolumn['order']." INT(11),
".$templatecolumn['mid']." INT(11)
)";
! mysql_query($sql);
! // Check for an error with the database code, and if so set an
! // appropriate error message and return
! if (mysql_error()) {
! pnSessionSetVar('errormsg', _CREATETABLEFAILED);
! return false;
}
! $query = "INSERT INTO ".pnConfigGetVar('prefix')."_module_vars (pn_modname,pn_name,pn_value) VALUES ('/PNConfig','use_new_admin','1')";
! mysql_query($query);
! if(restoreToDefault()){
! return true;
! }else{
! return false;
}
}
--- 229,263 ----
".$templatecolumn['default']." TINYINT(1) DEFAULT '0' NOT NULL
)";
! $dbconn->Execute( $query );
! if ($dbconn->ErrorNo() != 0) {
! pnSessionSetVar('errormsg', "CREATE table ".$pntable['group_table']." table failed.");
! return false;
}
! // :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
! // ============================== NEXT TABLE ===============================
! // member_table
! // :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
$templatetable = $pntable['member_table'];
$templatecolumn = &$pntable['members'];
! $query = "CREATE TABLE ".$templatetable." (
".$templatecolumn['gid']." INT(11),
".$templatecolumn['order']." INT(11),
".$templatecolumn['mid']." INT(11)
)";
! $dbconn->Execute( $query );
! if ($dbconn->ErrorNo() != 0) {
! pnSessionSetVar('errormsg', "CREATE table ".$pntable['member_table']." table failed.");
! return false;
}
! $query = "INSERT INTO ".pnConfigGetVar('prefix')."_module_vars (pn_modname,pn_name,pn_value) ".
! " VALUES ('/PNConfig','use_new_admin','1')";
! $dbconn->Execute( $query );
! if ($dbconn->ErrorNo() != 0) {
! pnSessionSetVar('errormsg', "INSERT into ".pnConfigGetVar('prefix')."_module_vars table failed.");
! return false;
}
+
+ return true;
}
***************
*** 229,338 ****
function admin_upgrade($oldversion)
{
! list($dbconn) = pnDBGetConn();
! $pntable = pnDBGetTables();
- if(!is_array($pntable)){
- echo "<p><b>No tables to create were found!</b></p>";
- die;
- return false;
- }
- switch($oldversion) {
- case "0.0.6":
- // No table update needed.
- return true;
- break;
case "0.0.5":
! // No table update needed.
! admin_upgrade("0.0.6");
! break;
case "0.0.4":
! $query = "INSERT INTO ".pnConfigGetVar('prefix')."_module_vars (pn_modname,pn_name,pn_value) VALUES ('/PNConfig','use_new_admin','1')";
! mysql_query($sql);
! if (mysql_error()) {
! pnSessionSetVar('errormsg', _UPDATETABLEFAILED);
! echo "<p>".nl2br($sql). " <br> ".mysql_error()."</p>";
! return false;
! }
! admin_upgrade("0.0.5");
! break;
case "0.0.3":
! $templatetable = $pntable['group_table'];
! $templatecolumn = &$pntable['group'];
! $sql = "ALTER TABLE ".$templatetable." ADD ".$templatecolumn['all']." INT(11) NOT NULL default '0'";
! mysql_query($sql);
! if (mysql_error()) {
! pnSessionSetVar('errormsg', _UPDATETABLEFAILED);
! echo "<p>".nl2br($sql). " <br> ".mysql_error()."</p>";
! return false;
! }
! admin_upgrade("0.0.4");
! break;
case "0.0.2":
! $templatetable = $pntable['group_table'];
! $templatecolumn = &$pntable['group'];
! $sql = "ALTER TABLE ".$templatetable." ADD ".$templatecolumn['lock']." INT(11) NOT NULL default '0'";
! mysql_query($sql);
! if (mysql_error()) {
! pnSessionSetVar('errormsg', _UPDATETABLEFAILED);
! echo "<p>".nl2br($sql). " <br> ".mysql_error()."</p>";
! return false;
! }
! admin_upgrade("0.0.3");
! break;
! case "0.0.1":
! $templatetable = $pntable['member_table'];
! $templatecolumn = &$pntable['members'];
! $sql = "ALTER TABLE ".$templatetable." ADD ".$templatecolumn['order']." INT(11) NOT NULL default '1'";
! mysql_query($sql);
! if (mysql_error()) {
! pnSessionSetVar('errormsg', _UPDATETABLEFAILED);
! echo "<p>".nl2br($sql). " <br> ".mysql_error()."</p>";
! return false;
! }
!
! $templatetable = $pntable['group_table'];
! $templatecolumn = &$pntable['group'];
! $sql = "ALTER TABLE ".$templatetable." ADD ".$templatecolumn['order']." INT(11) NOT NULL default '1'";
! mysql_query($sql);
! if (mysql_error()){
! pnSessionSetVar('errormsg', _UPDATETABLEFAILED);
! echo "<p>".nl2br($sql). " <br> ".mysql_error()."</p>";
! return false;
! }
! admin_upgrade("0.0.2");
! break;
! // ------------------------------------------------------------------------
! }
}
function admin_delete()
{
list($dbconn) = pnDBGetConn();
! $pntable = pnDBGetTables();
$query = "DROP TABLE IF EXISTS ".$pntable['group_table'];
! $dbconn->Execute($query);
!
if ($dbconn->ErrorNo() != 0) {
! pnSessionSetVar('errormsg', 'Deletion of admin lite group table failed');
return false;
}
!
$query = "DROP TABLE IF EXISTS ".$pntable['member_table'];
! $dbconn->Execute($query);
!
if ($dbconn->ErrorNo() != 0) {
! pnSessionSetVar('errormsg', 'Deletion of admin lite group members table failed');
return false;
}
//FIXME <johnny> - use pnModDelVar()
! pnModDelVar('admin','
! $sql = "DELETE FROM ".pnConfigGetVar('prefix')."_module_vars WHERE pn_modname='/PNConfig' AND pn_name='use_new_admin'";
! mysql_query($sql);
! if (mysql_error()) {
! return false;
! }
return true;
}
?>
--- 270,393 ----
function admin_upgrade($oldversion)
{
! list($dbconn) = pnDBGetConn();
! $pntable = pnDBGetTables();
!
! if(!is_array($pntable)){
! echo "<p><b>No tables to create were found!</b></p>";
! die;
! return false;
! }
!
! switch($oldversion) {
!
! case "0.0.7":
! // No table update needed.
! //admin_upgrade("0.0.8");
! break;
!
! case "0.0.6":
! // No table update needed.
! admin_upgrade("0.0.7");
! break;
case "0.0.5":
! // No table update needed.
! admin_upgrade("0.0.6");
! break;
!
case "0.0.4":
! $query = "INSERT INTO ".pnConfigGetVar('prefix')."_module_vars (pn_modname,pn_name,pn_value) ".
! " VALUES ('/PNConfig','use_new_admin','1')";
! $dbconn->Execute( $query );
! if ($dbconn->ErrorNo() != 0) {
! pnSessionSetVar('errormsg', "INSERT into ".pnConfigGetVar('prefix')."_module_vars table failed.");
! return false;
! }
! admin_upgrade("0.0.5");
! break;
!
case "0.0.3":
! $templatetable = $pntable['group_table'];
! $templatecolumn = &$pntable['group'];
! $query = "ALTER TABLE ".$templatetable." ADD ".$templatecolumn['all']." INT(11) NOT NULL default '0'";
! $dbconn->Execute( $query );
! if ($dbconn->ErrorNo() != 0) {
! pnSessionSetVar('errormsg', "ALTER table ".$templatetable." table failed.");
! return false;
! }
! admin_upgrade("0.0.4");
! break;
!
case "0.0.2":
! $templatetable = $pntable['group_table'];
! $templatecolumn = &$pntable['group'];
! $query = "ALTER TABLE ".$templatetable." ADD ".$templatecolumn['lock']." INT(11) NOT NULL default '0'";
! $dbconn->Execute( $query );
! if ($dbconn->ErrorNo() != 0) {
! pnSessionSetVar('errormsg', "ALTER table ".$templatetable." table failed.");
! return false;
! }
! admin_upgrade("0.0.3");
! break;
!
! case "0.0.1":
! $templatetable = $pntable['member_table'];
! $templatecolumn = &$pntable['members'];
! $query = "ALTER TABLE ".$templatetable." ADD ".$templatecolumn['order']." INT(11) NOT NULL default '1'";
! $dbconn->Execute( $query );
! if ($dbconn->ErrorNo() != 0) {
! pnSessionSetVar('errormsg', "ALTER table ".$templatetable." table failed.");
! return false;
! }
!
! $templatetable = $pntable['group_table'];
! $templatecolumn = &$pntable['group'];
! $query = "ALTER TABLE ".$templatetable." ADD ".$templatecolumn['order']." INT(11) NOT NULL default '1'";
! $dbconn->Execute( $query );
! if ($dbconn->ErrorNo() != 0) {
! pnSessionSetVar('errormsg', "ALTER table ".$templatetable." table failed.");
! return false;
! }
! admin_upgrade("0.0.2");
! break;
!
! default:
! break;
! }
!
! // Update successful
! return true;
}
+
function admin_delete()
{
list($dbconn) = pnDBGetConn();
! $pntable = pnDBGetTables();
$query = "DROP TABLE IF EXISTS ".$pntable['group_table'];
! $dbconn->Execute( $query );
if ($dbconn->ErrorNo() != 0) {
! pnSessionSetVar('errormsg', "DROP of table ".$pntable['group_table']." table failed.");
return false;
}
!
$query = "DROP TABLE IF EXISTS ".$pntable['member_table'];
! $dbconn->Execute( $query );
if ($dbconn->ErrorNo() != 0) {
! pnSessionSetVar('errormsg', "DROP of table ".$pntable['member_table']." table failed.");
return false;
}
+
//FIXME <johnny> - use pnModDelVar()
! $query = "DELETE FROM ".pnConfigGetVar('prefix')."_module_vars WHERE pn_modname='/PNConfig' AND pn_name='use_new_admin'";
! $dbconn->Execute( $query );
! if ($dbconn->ErrorNo() != 0) {
! pnSessionSetVar('errormsg', "DELETE from table ".pnConfigGetVar('prefix')."_module_vars table failed.");
! return false;
! }
return true;
}
+
?>
View Statistics - Next Notice - Previous Notice
| Visit Developer Site - Browse CVS Repository |
Syndicate via backend.rss (max. once per hour please) | Powered by CVSNotice 0.1.3 |