<?php
require_once dirname(__FILE__).'/../config.inc';
require_once "$path_prefix/db/Dal/Dal.php";

// Re-include constants.php to make sure we have the most up to date
// constants.  If we are in the middle of an update and this script is
// being included by web/update/run_scripts.php, we might not have all
// the constants.
include "$path_prefix/web/includes/constants.php";

  // Connect to MySQL
  $db = Dal::get_connection();
  $settings_new =array(PAGE_USER_PRIVATE=> array('page_id'=>PAGE_USER_PRIVATE,
                        'page_name'=>'user_private',
                        'data'=> array(
                                      'left'=>array(
                                                   'EnableModule', 'RelationsModule', 'ImagesModule', 'MyGroupsModule', 'MyLinksModule',
                                                   'MyNetworksModule'
                                                   ),
                                       'middle'=>array(
                                                      'ShowContentModule'
                                                      ),
                                       'right'=>array(
                                                      'UserPhotoModule', 'AboutUserModule',  'InRelationModule', 'UserMessagesModule', 'RecentCommentsModule', 'FlickrModule', 'LinkModule'
                                                      
                                                      )
                                       ),
                         ),
                        PAGE_USER_PUBLIC=>array('page_id'=>PAGE_USER_PUBLIC,
                        'page_name'=>'user_public',
                        'data'=> array(
                                      'left'=>array(
                                                   'RelationsModule', 'ImagesModule',
                                                   'MyLinksModule'
                                                   ),
                                       'middle'=>array(
                                                      'ShowContentModule'
                                                      ),
                                       'right'=>array(
                                                      'UserPhotoModule', 'AboutUserModule', 
                                                      'FlickrModule', 'LinkModule'
                                                      )
                                       ),
                         ),

                        PAGE_GROUPS_HOME=>array('page_id'=>PAGE_GROUPS_HOME,
                        'page_name'=>'groups_home',
                        'data'=> array(
                                      'left'=>array(
                                                   'NewestGroupsModule','MyGroupsModule', 'LogoModule'
                                                   ),
                                       'middle'=>array(
                                                      'SearchGroupsModule',
                                                      'GroupsDirectoryModule'
                                                      ),
                                       'right'=>array(
                                                      'LargestGroupsModule', 'GroupsCategoryModule','AdsByGoogleModule'
                                                      )
                                       ),
                         ),
                        PAGE_GROUPS_CATEGORY=>array('page_id'=>PAGE_GROUPS_CATEGORY,
                        'page_name'=>'groups_category',
                        'data'=> array(
                                      'left'=>array(
                                                   'NewestGroupsModule', 'LogoModule'
                                                   ),
                                       'middle'=>array(
                                                      'GroupsInCategoryModule'
                                                      ),
                                       'right'=>array(
                                                      'LargestGroupsModule', 'AdsByGoogleModule'
                                                      )
                                       ),
                      ),
                      PAGE_HOMEPAGE=>array('page_id'=>PAGE_HOMEPAGE,
                        'page_name'=>'homepage',
                        'data'=> array(
                                      'left'=>array(
                                                   'MembersFacewallModule', 'ImagesModule', 'PopularTagsModule', 'LogoModule'
                                                   ),
                                       'middle'=>array(
                                                      'ShowContentModule'
                                                      ),
                                       'right'=>array(
                                                      'NewestGroupsModule', 'RecentPostModule', 'TakerATourModule', 'AdsByGoogleModule'
                                                      )
                                       ),

                      ),

                      PAGE_PEOPLES=>array('page_id'=>PAGE_PEOPLES,
                        'page_name'=>'peoples',
                        'data'=> array(
                                      'left'=>array(
                                                   'MembersFacewallModule','RecentTagsModule', 'LogoModule'
                                                   ),
                                       'middle'=>array(
                                                      'SearchUserModule', 'PeopleModule'
                                                      ),
                                       'right'=>array(
                                                      'NewestGroupsModule', 'AdsByGoogleModule'
                                                      )
                                       ),

                      ),
                      PAGE_ADDGROUP=>array('page_id'=>PAGE_ADDGROUP,
                        'page_name'=>'addgroup',
                        'data'=> array(
                                      'left'=>array(
                                                   'NewestGroupsModule', 'LogoModule'
                                                   ),
                                       'middle'=>array(
                                                      'AddGroupModule'
                                                      ),
                                       'right'=>array(
                                                      'LargestGroupsModule', 'AdsByGoogleModule'
                                                      )
                                       ),

                      ),
                      PAGE_GROUP=>array('page_id'=>PAGE_GROUP,
                        'page_name'=>'group',
                        'data'=> array(
                                      'left'=>array(
                                                   'GroupAccessModule', 'MembersFacewallModule','LogoModule'
                                                   ),
                                       'middle'=>array(
                                                      'GroupOverviewModule', 'ShowContentModule', 'GroupForumModule', 'GroupImageMediaModule', 'GroupAudioMediaModule', 'GroupVideoMediaModule'
                                                      ),
                                       'right'=>array(
                                                      'GroupStatsModule', 'RecentPostModule', 'AdsByGoogleModule'
                                                      )
                                       ),
                      ),
                      PAGE_CHOOSECONTENT=>array('page_id'=>PAGE_CHOOSECONTENT,
                        'page_name'=>'chooseContent',
                        'data'=> array(
                                      'left'=>array(
                                                   'LogoModule'
                                                   ),
                                       'middle'=>array(
                                                      'ChooseContentModule'
                                                      ),
                                       'right'=>array(
                                                      'AdsByGoogleModule'
                                                      )
                                       ),
                      ),
                      PAGE_CREATECONTENT=>array('page_id'=>PAGE_CREATECONTENT,
                        'page_name'=>'createContent',
                        'data'=> array(
                                      'left'=>array(
                                                   'LogoModule'
                                                   ),
                                       'middle'=>array(
                                                      'CreateContentModule'
                                                      ),
                                       'right'=>array(
                                                      'AdsByGoogleModule'
                                                      )
                                       ),
                      ),
                      PAGE_PERMALINK=>array('page_id'=>PAGE_PERMALINK,
                        'page_name'=>'permalink',
                        'data'=> array(
                                      'left'=>array(
                                                   'RecentCommentsModule',
                                                   'LogoModule'
                                                   ),
                                       'middle'=>array(
                                                   'PermalinkModule'
                                                      ),
                                       'right'=>array(
                                                    'RecentPostModule',
                                                    'AdsByGoogleModule'
                                                      )
                                       ),

                      ),
                       PAGE_MANAGECONTENT=>array('page_id'=>PAGE_MANAGECONTENT,
                        'page_name'=>'managecontent',
                        'data'=> array(
                                      'left'=>array(
                                                   'LogoModule'
                                                   ),
                                       'middle'=>array(
                                                      'ManageContentModule'
                                                      ),
                                       'right'=>array(
                                                      'AdsByGoogleModule'
                                                      )


                                       )

                      ),
                      PAGE_MEDIA_MANAGEMENT=>array('page_id'=>PAGE_MEDIA_MANAGEMENT,
                        'page_name'=>'media_management',
                        'data'=> array(
                                      'left'=>array(
                                                   'RecentCommentsModule',
                                                   'LogoModule'
                                                   ),
                                       'middle'=>array(
                                                   'MediaManagementModule'
                                                      ),
                                       'right'=>array(
                                                    'RecentPostModule',
                                                    'AdsByGoogleModule'
                                                      )
                                       ),


                      ),
                      PAGE_MEDIA_GALLERY=>array('page_id'=>PAGE_MEDIA_GALLERY,
                        'page_name'=>'media_gallery',
                        'data'=> array(
                                      'left'=>array(
                                                   'RelationsModule', 'LogoModule'
                                                   ),
                                       'middle'=>array(
                                                   'ImageMediaGalleryModule', 'AudioMediaGalleryModule', 'VideoMediaGalleryModule'
                                                      ),
                                       'right'=>array(
                                                      'UserPhotoModule', 'AdsByGoogleModule'
                                                      )
                                       ),
                      ),
                      PAGE_MESSAGE=>array('page_id'=>PAGE_MESSAGE,
                        'page_name'=>'message',
                        'data'=> array(
                                      'left'=>array(

                                                   'LogoModule'
                                                   ),
                                       'middle'=>array(
                                                   'MessageModule'
                                                      ),
                                       'right'=>array(

                                                    'AdsByGoogleModule'
                                                      )
                                       ),

                      ),
                      PAGE_ADDMESSAGE=>array('page_id'=>PAGE_ADDMESSAGE,
                        'page_name'=>'addmessage',
                        'data'=> array(
                                      'left'=>array(

                                                   'LogoModule'
                                                   ),
                                       'middle'=>array(
                                                   'AddMessageModule'
                                                      )
                                       ),

                      ),
                      PAGE_SEARCH=>array('page_id'=>PAGE_SEARCH,
                        'page_name'=>'searchContent',
                        'data'=> array(
                                      'left'=>array(
                                                   'LogoModule','RecentTagsModule'
                                                   ),
                                       'middle'=>array(
                                                      'SearchContentModule','ShowContentModule'
                                                      ),
                                      'right'=>array(
                                                      'AdsByGoogleModule'
                                                      )
                                       ),

                      ),
                      PAGE_SHOWCONTENT=>array('page_id'=>PAGE_SHOWCONTENT,
                        'page_name'=>'showContent',
                        'data'=> array(
                                      'left'=>array(
                                                   'LogoModule'
                                                   ),
                                       'middle'=>array(
                                                      'ShowContentModule'
                                                      ),
                                      'right'=>array(
                                                      'AdsByGoogleModule'
                                                      )
                                       ),
                      ),
                       PAGE_FORUM_MESSAGES=>array('page_id'=>PAGE_FORUM_MESSAGES,
                        'page_name'=>'forumMessages',
                        'data'=> array(
                                      'left'=>array(
                                                   'LogoModule'
                                                   ),
                                       'middle'=>array(
                                                      'GroupForumModule'
                                                      ),
                                      'right'=>array(
                                                      'AdsByGoogleModule'
                                                      )
                                       ),

                      ),
                      PAGE_REGISTER=>array('page_id'=>PAGE_REGISTER,
                        'page_name'=>'register',
                        'data'=> array(
                                      'left'=>array(
                                                   'RecentCommentsModule',
                                                   'LogoModule'
                                                   ),
                                       'middle'=>array(
                                                   'RegisterModule'
                                                      ),
                                       'right'=>array(
                                                    'RecentPostModule',
                                                    'AdsByGoogleModule'
                                                      )
                                       ),


                      ),
                      PAGE_INVITATION=>array('page_id'=>PAGE_INVITATION,
                        'page_name'=>'invitation',
                        'data'=> array(
                                      'left'=>array(
                                                   'RecentCommentsModule',
                                                   'LogoModule'
                                                   ),
                                       'middle'=>array(
                                                   'InvitationModule', 'InvitationStatusModule'
                                                      ),
                                       'right'=>array(
                                                    'RecentPostModule',
                                                    'AdsByGoogleModule'
                                                      )
                                       ),


                      ),
                      PAGE_EDIT_MEDIA=>array('page_id'=>PAGE_EDIT_MEDIA,
                        'page_name'=>'edit_media',
                        'data'=> array(
                                      'left'=>array(
                                                   'RelationsModule',
                                                   'LogoModule'
                                                   ),
                                       'middle'=>array(
                                                   'EditMediaModule'
                                                      ),
                                       'right'=>array(
                                                    'UserPhotoModule',
                                                    'AdsByGoogleModule'
                                                      )
                                       ),


                      ),
                     /* PAGE_EDIT_PROFILE=>array('page_id'=>PAGE_EDIT_PROFILE,
                        'page_name'=>'edit_profile',
                        'data'=> array(
                                      'left'=>array(
                                                   'EnableModule', 'RelationsModule', 'ImagesModule', 'MyGroupsModule', 'MyLinksModule', 'MyNetworksModule'
                                                   ),
                                       'middle'=>array(
                                                   'EditProfileModule'
                                                      )
                      
                                       ),
                      ),*/
                      PAGE_EDIT_PROFILE=>array('page_id'=>PAGE_EDIT_PROFILE,
                        'page_name'=>'edit_profile',
                        'data'=> array(
                                      'left'=>array(
                                                   'EnableModule'
                                                   ),
                                       'middle'=>array(
                                                   'EditProfileModule'
                                                      ),
                                       'right'=>array(
                                                      ),               
                                       
                                       ),
                      ),
                      PAGE_GROUP_MEMBERS=>array('page_id'=>PAGE_GROUP_MEMBERS,
                        'page_name'=>'searchContent',
                        'data'=> array(
                                      'left'=>array(
                                                   'LogoModule'
                                                   ),
                                       'middle'=>array(
                                                       'GroupModerationModule'
                                                      ),
                                      'right'=>array(
                                                      'AdsByGoogleModule'
                                                      )
                                       ),

                      ),
                      PAGE_VIEW_ALL_MEMBERS=>array('page_id'=>PAGE_VIEW_ALL_MEMBERS,
                        'page_name'=>'viewAllMembers',
                        'data'=> array(
                                      'left'=>array(
                                                   'RecentCommentsModule',
                                                   'LogoModule'
                                                   ),
                                       'middle'=>array(
                                                    'ViewAllMembersModule'

                                                      ),
                                       'right'=>array(
                                                    'RecentPostModule',
                                                    'AdsByGoogleModule'
                                                      )
                                       )

                      ),
                      PAGE_EDIT_RELATION=>array('page_id'=>PAGE_EDIT_RELATION,
                        'page_name'=>'edit_relation',
                        'data'=> array(
                                      'left'=>array(
                                                   'RelationsModule', 'LogoModule'
                                                   ),
                                       'middle'=>array(
                                                   'EditRelationModule'
                                                      ),
                                       'right'=>array(
                                                      'UserPhotoModule', 'AdsByGoogleModule'
                                                      )
                                       )
                        ),
                        PAGE_FORGOT_PASSWORD=>array('page_id'=>PAGE_FORGOT_PASSWORD,
                        'page_name'=>'homepage',
                        'data'=> array(
                                      'left'=>array(
                                                   'MembersFacewallModule', 'PopularTagsModule', 'LogoModule'
                                                   ),
                                       'middle'=>array(
                                                      'ForgotPasswordModule'
                                                      ),
                                       'right'=>array(
                                                      'NewestGroupsModule', 'RecentPostModule', 'AdsByGoogleModule'
                                                      )
                                       ),

                      ),
                      PAGE_LOGIN=>array('page_id'=>PAGE_LOGIN,
                        'page_name'=>'homepage',
                        'data'=> array(
                                      'left'=>array(
                                                   'MembersFacewallModule', 'PopularTagsModule', 'LogoModule'
                                                   ),
                                       'middle'=>array(
                                                      'LoginModule'
                                                      ),
                                       'right'=>array(
                                                      'NewestGroupsModule', 'RecentPostModule', 'AdsByGoogleModule'
                                                      )
                                       ),


                      ),
                      PAGE_POSTCONTENT=>array('page_id'=>PAGE_POSTCONTENT,
                        'page_name'=>'postContent',
                        'data'=> array(
                                      'left'=>array(
                                                   ''
                                                   ),
                                       'middle'=>array(
                                                      'PostContentModule'
                                                      ),
                                       'right'=>array(
                                                      ''
                                                      )
                                       ),
                      ),
                      PAGE_GROUP_INVITE=>array('page_id'=>PAGE_GROUP_INVITE,
                        'page_name'=>'group_invitaion',

                        'data'=> array(
                                      'left'=>array(
                                                   'LargestGroupsModule', 'LogoModule'
                                                   ),
                                       'middle'=>array(
                                                      'GroupInvitationModule','InvitationStatusModule'
                                                      ),
                                       'right'=>array(
                                                      'NewestGroupsModule', 'AdsByGoogleModule',
                                                      )
                                       ),

                      ),
                       PAGE_MEDIA_FULL_VIEW=>array('page_id'=>PAGE_MEDIA_FULL_VIEW,
                        'page_name'=>'media_full_view',
                        'data'=> array(
                                      'left'=>array(
                                                   ),
                                       'middle'=>array(
                                                      'MediaFullViewModule'
                                                      ),
                                       'right'=>array(
                                                      )
                                       ),

                      ),
                      PAGE_CREATE_NETWORK=>array('page_id'=>PAGE_CREATE_NETWORK,
                        'page_name'=>'create_network',
                        'data'=> array(
                                      'left'=>array(
                                                      'LogoModule'
                                                   ),
                                       'middle'=>array(
                                                      'NetworkModule'
                                                      ),
                                       'right'=>array(
                                                      'RecentNetworksModule','AdsByGoogleModule'
                                                      )
                                       ),

                         ),
                           PAGE_NETWORKS_HOME=>array('page_id'=>PAGE_NETWORKS_HOME,
                           'page_name'=>'networks_directory',
                           'data'=> array(
                                        'left'=>array('LogoModule'),
                                        'middle'=>array('SearchNetworksModule',                              'NetworksDirectoryModule'
                                                      ),
                                       'right'=>array('NetworksCategoryModule')
                                       )
                          ),
                         PAGE_NETWORKS_CATEGORY=>array('page_id'=>PAGE_NETWORKS_CATEGORY,
                        'page_name'=>'networs_category',
                        'data'=> array(
                                      'left'=>array(
                                                      'LogoModule'
                                                   ),
                                       'middle'=>array(
                                                      'NetworksInCategoryModule'
                                                      ),
                                       'right'=>array(
                                                      'AdsByGoogleModule'
                                                      )
                                       ),

                         ),
                      PAGE_LINKS_MANAGEMENT=>array('page_id'=>PAGE_LINKS_MANAGEMENT,
                        'page_name'=>'create_network',
                        'data'=> array(
                                      'left'=>array(
                                                      'LogoModule'
                                                   ),
                                       'middle'=>array(
                                                      'LinksModule'
                                                      ),
                                       'right'=>array(
                                                      'AdsByGoogleModule'
                                                      )
                                       ),

                         ),
                           PAGE_NETWORK=>array('page_id'=>PAGE_NETWORK,
                        'page_name'=>'network',
                        'data'=> array(
                                      'left'=>array(
                                                      'LogoModule'
                                                   ),
                                       'middle'=>array(

                                                      ),
                                       'right'=>array(
                                                      'AdsByGoogleModule'
                                                      )
                                       ),

                         ),
                         PAGE_GROUP_MEDIA_GALLERY=>array('page_id'=>PAGE_GROUP_MEDIA_GALLERY,
                        'page_name'=>'group_media_gallery',
                        'data'=> array(
                                      'left'=>array(
                                                   'RelationsModule', 'LogoModule'
                                                   ),
                                       'middle'=>array(
                                                   'GroupImageMediaModule', 'GroupAudioMediaModule', 'GroupVideoMediaModule'
                                                      ),
                                       'right'=>array(
                                                      'UserPhotoModule', 'AdsByGoogleModule'
                                                      )
                                       ),
							 ),
		       PAGE_BADGE_CREATE => array(
			   'page_name' => 'badge_create',
			   'data' => array(
			       'left' => array(
				   ),
			       'middle' => array(
				   ),
			       'right' => array(
				   ),
			       ),
			   ),
		       PAGE_COMMENT_MANAGEMENT => array(
			   'page_name' => 'comment_management',
			   'data' => array(
			       'left' => array(
				   ),
			       'middle' => array(
				   ),
			       'right' => array(
				   ),
			       ),
			   ),

                  );


   // check whether user is already deleted

   // truncate existing data
   $sql = 'TRUNCATE TABLE page_default_settings';
   $res = Dal::query($sql);

   foreach($settings_new as $page_id => $v1) {
        $page_name = $v1['page_name'];
        $data = $v1['data'];
        $settings_data = serialize($data);
      $sql = 'INSERT into page_default_settings (page_id, page_name, default_settings) values (?, ?, ?)';
      $data = array($page_id, $page_name, $settings_data);
      $res = Dal::query($sql, $data);
    }

   echo "page_default_settings table created and populated.\n";

?>
<!--  -->