Xaraya / Postnuke CVS Notices - Message

Note: this list is kept only as a demonstration for CVSNotice. For the latest CVS notices, see the Xaraya and Postnuke sites

Directory filter : [ all ] / postnuke_modules / modinfo [ view in CVS ]

Date	Directory [filter]	File(s) [view]	Author [filter]
09 Aug 2002 00:01:17	postnuke_modules/modinfo	pninit.php,1.2,1.3	Gary Mitchell
	Add Drop Table Statements

Update of /home/cvsroot/postnuke_modules/modinfo
In directory ns7.hostnuke.net:/tmp/cvs-serv15832

Modified Files:
	pninit.php 
Log Message:
Add Drop Table Statements


Index: pninit.php
===================================================================
RCS file: /home/cvsroot/postnuke_modules/modinfo/pninit.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** pninit.php	28 Jul 2002 01:06:05 -0000	1.2
--- pninit.php	9 Aug 2002 00:01:15 -0000	1.3
***************
*** 153,156 ****
--- 153,182 ----
  {
      
+     // Open the database connection
+     list($dbconn) = pnDBGetConn();
+     $pntable = pnDBGetTables();
+ 
+     // adodb does not provide the functionality to abstract table creates
+     // across multiple databases.  Postnuke offers the pnDropeTable function
+     // contained in the following file to provide this functionality.
+     include ('pnadodb/pnTableDDL.php');
+ 
+     // Generate the SQL to drop the table using the API
+     $sql = pnDBDropTable($pntable['registrations']);
+     if ($dbconn->ErrorNo() != 0) {
+         // Report failed deletion attempt
+         return false;
+     }
+ 
+     // Drop the table
+     $dbconn->Execute($sql);
+ 
+     // Check for an error with the database code, and if so set an
+     // appropriate error message and return
+     if ($dbconn->ErrorNo() != 0) {
+         // Report failed deletion attempt
+         return false;
+     }
+ 
      // This module requires the categories API be installed
      if(!pnModAPILoad('categories', 'admin')) {

View Statistics - Next Notice - Previous Notice