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

View Statistics - Next Notice - Previous Notice

Directory filter : [ all ] / postnuke_official / html / modules / blocks [ view in CVS ]

Date Directory [filter] File(s) [view] Author [filter]
06 Aug 2002 15:47:36postnuke_official/html/modules/blockspninit.php,1.1,1.2Paul Rosania
 decentralized table creation, split into relevant modules (somewhat)

Update of /home/cvsroot/postnuke_official/html/modules/blocks
In directory ns7.hostnuke.net:/tmp/cvs-serv15336/blocks

Modified Files:
	pninit.php 
Log Message:
decentralized table creation, split into relevant modules (somewhat)


Index: pninit.php
===================================================================
RCS file: /home/cvsroot/postnuke_official/html/modules/blocks/pninit.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** pninit.php	3 Aug 2002 03:00:13 -0000	1.1
--- pninit.php	6 Aug 2002 15:47:33 -0000	1.2
***************
*** 39,159 ****
      // Create tables
  
!     // *_block_group_instances
!     pnDBCreateTable($prefix . '_block_group_instances',
!                     array('pn_id'          => array('type'        => 'integer',
!                                                     'unsigned'    => true,
!                                                     'null'        => false,
!                                                     'default'     => 0,
!                                                     'increment'   => true,
!                                                     'primary_key' => true)
!                           'pn_group_id'    => array('type'     => 'integer',
!                                                     'unsigned' => true,
!                                                     'null'     => false,
!                                                     'default'  => 0)
!                           'pn_instance_id' => array('type'     => 'integer',
!                                                     'unsigned' => true,
!                                                     'null'     => false,
!                                                     'default'  => 0)
!                           'pn_position'    => array('type'     => 'integer',
!                                                     'unsigned' => true,
!                                                     'null'     => false,
!                                                     'default'  => 0)));
! /*
! #
! # Dumping data for table `nuke_block_group_instances`
! #
! 
! INSERT INTO nuke_block_group_instances (pn_id, pn_group_id, pn_instance_id, pn_position) VALUES (1, 1, 6, 0);
! INSERT INTO nuke_block_group_instances (pn_id, pn_group_id, pn_instance_id, pn_position) VALUES (2, 1, 1, 1);
! INSERT INTO nuke_block_group_instances (pn_id, pn_group_id, pn_instance_id, pn_position) VALUES (3, 1, 7, 2);
! INSERT INTO nuke_block_group_instances (pn_id, pn_group_id, pn_instance_id, pn_position) VALUES (4, 1, 2, 3);
! INSERT INTO nuke_block_group_instances (pn_id, pn_group_id, pn_instance_id, pn_position) VALUES (5, 1, 3, 4);
! INSERT INTO nuke_block_group_instances (pn_id, pn_group_id, pn_instance_id, pn_position) VALUES (6, 1, 4, 5);
! INSERT INTO nuke_block_group_instances (pn_id, pn_group_id, pn_instance_id, pn_position) VALUES (7, 2, 5, 0);
! # --------------------------------------------------------
! 
! #
! # Table structure for table `nuke_block_groups`
! #
! 
! DROP TABLE IF EXISTS nuke_block_groups;
! CREATE TABLE nuke_block_groups (
!   pn_id int(11) unsigned NOT NULL auto_increment,
!   pn_name varchar(255) NOT NULL default '',
!   pn_template varchar(255) default NULL,
!   PRIMARY KEY  (pn_id),
!   UNIQUE KEY pn_name (pn_name)
! ) TYPE=MyISAM;
! 
! #
! # Dumping data for table `nuke_block_groups`
! #
! 
! INSERT INTO nuke_block_groups (pn_id, pn_name, pn_template) VALUES (1, 'left', 'default');
! INSERT INTO nuke_block_groups (pn_id, pn_name, pn_template) VALUES (2, 'right', 'right');
! # --------------------------------------------------------
! 
! #
! # Table structure for table `nuke_block_instances`
! #
! 
! DROP TABLE IF EXISTS nuke_block_instances;
! CREATE TABLE nuke_block_instances (
!   pn_id int(11) unsigned NOT NULL auto_increment,
!   pn_type_id int(11) unsigned NOT NULL default '0',
!   pn_title varchar(255) default NULL,
!   pn_content text,
!   pn_template varchar(255) default NULL,
!   pn_state tinyint(1) NOT NULL default '1',
!   pn_refresh int(11) NOT NULL default '0',
!   pn_last_update int(11) NOT NULL default '0',
!   PRIMARY KEY  (pn_id)
! ) TYPE=MyISAM;
! 
! #
! # Dumping data for table `nuke_block_instances`
! #
! 
! INSERT INTO nuke_block_instances (pn_id, pn_type_id, pn_title, pn_content, pn_template, pn_state, pn_refresh, pn_last_update) VALUES (1, 5, 'Main Menu', 'a:4:{s:5:"style";s:1:"1";s:14:"displaywaiting";i:0;s:14:"displaymodules";s:1:"1";s:7:"content";s:292:"index.php|Home|Back to the home page.LINESPLITindex.php?module=users|My Account|Administer your personal account.LINESPLITindex.php?module=adminpanels&type=admin&func=main|Administration|Administer your PostNuked site.LINESPLITindex.php?module=users&func=logout|Logout|Logout of your account.";}', NULL, 1, 0, 0);
! INSERT INTO nuke_block_instances (pn_id, pn_type_id, pn_title, pn_content, pn_template, pn_state, pn_refresh, pn_last_update) VALUES (2, 5, 'Incoming', 'a:4:{s:5:"style";s:1:"1";s:14:"displaywaiting";s:1:"1";s:14:"displaymodules";i:0;s:7:"content";s:0:"";}', NULL, 0, 0, 0);
! INSERT INTO nuke_block_instances (pn_id, pn_type_id, pn_title, pn_content, pn_template, pn_state, pn_refresh, pn_last_update) VALUES (3, 9, 'Who\'s Online', '', NULL, 1, 0, 0);
! INSERT INTO nuke_block_instances (pn_id, pn_type_id, pn_title, pn_content, pn_template, pn_state, pn_refresh, pn_last_update) VALUES (4, 8, 'Users Block', 'Put anything you want here', NULL, 1, 0, 0);
! INSERT INTO nuke_block_instances (pn_id, pn_type_id, pn_title, pn_content, pn_template, pn_state, pn_refresh, pn_last_update) VALUES (5, 7, 'User\'s Login', '', NULL, 1, 0, 0);
! INSERT INTO nuke_block_instances (pn_id, pn_type_id, pn_title, pn_content, pn_template, pn_state, pn_refresh, pn_last_update) VALUES (6, 2, 'Reminder', 'Please remember to remove the following files from your PostNuke directory<p>&middot;<b>install.php</b> file<p>&middot;<b>install</b> directory<p>If you do not remove these files then users can obtain the password to your database!', NULL, 1, 0, 0);
! INSERT INTO nuke_block_instances (pn_id, pn_type_id, pn_title, pn_content, pn_template, pn_state, pn_refresh, pn_last_update) VALUES (7, 10, 'Admin', '', NULL, 1, 0, 0);
! # --------------------------------------------------------
! 
! #
! # Table structure for table `nuke_block_types`
! #
! 
! DROP TABLE IF EXISTS nuke_block_types;
! CREATE TABLE nuke_block_types (
!   pn_id int(11) unsigned NOT NULL auto_increment,
!   pn_type varchar(255) NOT NULL default '',
!   pn_module varchar(255) NOT NULL default '',
!   PRIMARY KEY  (pn_id),
!   KEY pn_type (pn_type),
!   KEY pn_typemodule_index (pn_type(100),pn_module(100))
! ) TYPE=MyISAM;
! 
! #
! # Dumping data for table `nuke_block_types`
! #
  
! INSERT INTO nuke_block_types (pn_id, pn_type, pn_module) VALUES (1, 'text', 'base');
! INSERT INTO nuke_block_types (pn_id, pn_type, pn_module) VALUES (2, 'html', 'base');
! INSERT INTO nuke_block_types (pn_id, pn_type, pn_module) VALUES (3, 'php', 'base');
! INSERT INTO nuke_block_types (pn_id, pn_type, pn_module) VALUES (4, 'finclude', 'base');
! INSERT INTO nuke_block_types (pn_id, pn_type, pn_module) VALUES (5, 'menu', 'base');
! INSERT INTO nuke_block_types (pn_id, pn_type, pn_module) VALUES (6, 'thelang', 'base');
! INSERT INTO nuke_block_types (pn_id, pn_type, pn_module) VALUES (7, 'login', 'users');
! INSERT INTO nuke_block_types (pn_id, pn_type, pn_module) VALUES (8, 'user', 'users');
! INSERT INTO nuke_block_types (pn_id, pn_type, pn_module) VALUES (9, 'online', 'users');
! INSERT INTO nuke_block_types (pn_id, pn_type, pn_module) VALUES (10, 'adminmenu', 'adminpanels');
! INSERT INTO nuke_block_types (pn_id, pn_type, pn_module) VALUES (11, 'admintop', 'adminpanels');
! # --------------------------------------------------------
  
- */
      // Register BL tags
      pnTplRegisterTag('blocks', 'blocks-stateicon',
--- 39,202 ----
      // Create tables
  
!     // *_block_groups
!     $query = pnDBCreateTable($prefix . '_block_groups',
!                              array('pn_id'         => array('type'        => 'integer',
!                                                              'null'        => false,
!                                                              'default'     => '',
!                                                              'increment'   => true,
!                                                              'primary_key' => true),
!                                    'pn_name'        => array('type'        => 'varchar',
!                                                              'size'        => 255,
!                                                              'null'        => false,
!                                                              'default'     => ''),
!                                    'pn_template'    => array('type'        => 'varchar',
!                                                              'size'        => 255,
!                                                              'null'        => false,
!                                                              'default'     => '')));
!     $dbconn->Execute($query);
!         
!     // Check for db errors
!     if ($dbconn->ErrorNo() != 0) {
!         $msg = pnMLByKey('DATABASE_ERROR', $dbconn->ErrorMsg(), $query);
!         pnExceptionSet(PN_SYSTEM_EXCEPTION, 'DATABASE_ERROR',
!                        new SystemException(__FILE__.'('.__LINE__.'): '.$msg));
!         return NULL;
!     }
!     
!     $query = pnDBCreateIndex($prefix . '_block_groups',
!                              array('name'   => 'pn_name_index',
!                                    'fields' => array('pn_name'),
!                                    'unique' => 'true'));
!     $dbconn->Execute($query);
!     
!     // Check for db errors
!     if ($dbconn->ErrorNo() != 0) {
!         $msg = pnMLByKey('DATABASE_ERROR', $dbconn->ErrorMsg(), $query);
!         pnExceptionSet(PN_SYSTEM_EXCEPTION, 'DATABASE_ERROR',
!                        new SystemException(__FILE__.'('.__LINE__.'): '.$msg));
!         return NULL;
!     }
!     
!     // *_block_instances
!     $query = pnDBCreateTable($prefix . '_block_instances',
!                              array('pn_id'          => array('type'        => 'integer',
!                                                              'null'        => false,
!                                                              'default'     => '0',
!                                                              'increment'   => true,
!                                                              'primary_key' => true),
!                                    'pn_type_id'     => array('type'        => 'integer',
!                                                              'null'        => false,
!                                                              'default'     => '0'),
!                                    'pn_title'       => array('type'        => 'varchar',
!                                                              'size'        => 255,
!                                                              'null'        => true,
!                                                              'default'     => NULL),
!                                    'pn_content'     => array('type'        => 'text'),
!                                    'pn_template'    => array('type'        => 'varchar',
!                                                              'size'        => 255,
!                                                              'null'        => true,
!                                                              'default'     => NULL),
!                                    'pn_state'       => array('type'        => 'integer',
!                                                              'size'        => 'tiny',
!                                                              'null'        => false,
!                                                              'default'     => '2'),
!                                    'pn_refresh'     => array('type'        => 'integer',
!                                                              'null'        => false,
!                                                              'default'     => '0'),
!                                    'pn_last_update' => array('type'        => 'integer',
!                                                              'null'        => false,
!                                                              'default'     => '0')));
!     
!      $dbconn->Execute($query);
!         
!     // Check for db errors
!     if ($dbconn->ErrorNo() != 0) {
!         $msg = pnMLByKey('DATABASE_ERROR', $dbconn->ErrorMsg(), $query);
!         pnExceptionSet(PN_SYSTEM_EXCEPTION, 'DATABASE_ERROR',
!                        new SystemException(__FILE__.'('.__LINE__.'): '.$msg));
!         return NULL;
!     }
!                                                                                
!     // *_block_types
!     $query = pnDBCreateTable($prefix . '_block_types',
!                              array('pn_id'          => array('type'        => 'integer',
!                                                              'null'        => false,
!                                                              'default'     => '0',
!                                                              'increment'   => true,
!                                                              'primary_key' => true),
!                                    'pn_type'        => array('type'        => 'varchar',
!                                                              'size'        => 255,
!                                                              'null'        => false,
!                                                              'default'     => ''),
!                                    'pn_module'    => array('type'        => 'varchar',
!                                                              'size'        => 255,
!                                                              'null'        => false,
!                                                              'default'     => '')));
!     
!      $dbconn->Execute($query);
!         
!     // Check for db errors
!     if ($dbconn->ErrorNo() != 0) {
!         $msg = pnMLByKey('DATABASE_ERROR', $dbconn->ErrorMsg(), $query);
!         pnExceptionSet(PN_SYSTEM_EXCEPTION, 'DATABASE_ERROR',
!                        new SystemException(__FILE__.'('.__LINE__.'): '.$msg));
!         return NULL;
!     }
!     
!     $query = pnDBCreateIndex($prefix . '_block_types',
!                              array('name'   => 'pn_type_index',
!                                    'fields' => array('pn_type'),
!                                    'unique' => false));
!     $dbconn->Execute($query);
!     
!     // Check for db errors
!     if ($dbconn->ErrorNo() != 0) {
!         $msg = pnMLByKey('DATABASE_ERROR', $dbconn->ErrorMsg(), $query);
!         pnExceptionSet(PN_SYSTEM_EXCEPTION, 'DATABASE_ERROR',
!                        new SystemException(__FILE__.'('.__LINE__.'): '.$msg));
!         return NULL;
!     }
  
!     $query = pnDBCreateIndex($prefix . '_block_types',
!                              array('name'   => 'pn_typemodule_index',
!                                    'fields' => array('pn_type(50)', 'pn_module(50)'),
!                                    'unique' => true));
!     $dbconn->Execute($query);
!     
!     // Check for db errors
!     if ($dbconn->ErrorNo() != 0) {
!         $msg = pnMLByKey('DATABASE_ERROR', $dbconn->ErrorMsg(), $query);
!         pnExceptionSet(PN_SYSTEM_EXCEPTION, 'DATABASE_ERROR',
!                        new SystemException(__FILE__.'('.__LINE__.'): '.$msg));
!         return NULL;
!     }
!     
!     // *_block_group_instances
!     $query = pnDBCreateTable($prefix . '_block_group_instances',
!                              array('pn_id'          => array('type'        => 'integer',
!                                                              'null'        => false,
!                                                              'default'     => '0',
!                                                              'increment'   => true,
!                                                              'primary_key' => true),
!                                    'pn_group_id'    => array('type'        => 'integer',
!                                                              'null'        => false,
!                                                              'default'     => '0'),
!                                    'pn_instance_id' => array('type'        => 'integer',
!                                                              'null'        => false,
!                                                              'default'     => '0'),
!                                    'pn_position'    => array('type'        => 'integer',
!                                                              'null'        => false,
!                                                              'default'     => '0')));
!     
!      $dbconn->Execute($query);
!         
!     // Check for db errors
!     if ($dbconn->ErrorNo() != 0) {
!         $msg = pnMLByKey('DATABASE_ERROR', $dbconn->ErrorMsg(), $query);
!         pnExceptionSet(PN_SYSTEM_EXCEPTION, 'DATABASE_ERROR',
!                        new SystemException(__FILE__.'('.__LINE__.'): '.$msg));
!         return NULL;
!     }
  
      // Register BL tags
      pnTplRegisterTag('blocks', 'blocks-stateicon',


Directory filter : [ all ] / postnuke_official / html / modules / blocks [ view in CVS ]

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