Changeset 9985 for trunk/modules/boonex/shared_photo/install/sql/install.sql

Timestamp:

04/06/09 23:30:15 (3 years ago)

Author:

Andrey Prikaznov

Message:

 

File:

• trunk/modules/boonex/shared_photo/install/sql/install.sql (modified) (2 diffs)

trunk/modules/boonex/shared_photo/install/sql/install.sql

@@ -72 +72 @@
 INSERT INTO `sys_objects_browse` VALUES(NULL, 'shared_photo', '_All Photos', 'BxShPhotoMain', 'modules/boonex/shared_photo/classes/BxShPhotoMain.php', 'BxShPhotoSearch', 'modules/boonex/shared_photo/classes/BxShPhotoSearch.php');
 
--- Categories for photo
-INSERT INTO `Categories` VALUES
+-- sys_categories for photo
+INSERT INTO `sys_categories` VALUES
 ('Profile photos', 0, 'shared_photo', 0, 'active'),
 ('Family', 0, 'shared_photo', 0, 'active'),
@@ -120 +120 @@
 INSERT INTO `sys_page_compose` VALUES
 (NULL, 'index', '960px', 'Photos Shared By Members', '_Photo Gallery', 1, 7, 'PHP', 'require_once(BX_DIRECTORY_PATH_MODULES . ''/boonex/shared_photo/classes/BxShPhotoSearch.php'');\r\n$oMedia = new BxShPhotoSearch();\r\n$oMedia->aCurrent[''paginate''][''perPage''] = getParam($oMedia->aGlParamsSettings[''maxTopFilesNum'']);\r\n$sCode = $oMedia->displayResultBlock();\r\n     if (strlen($sCode) > 0) {\r\n$aMenu = $oMedia->displayMenu();\r\n\r\n$iWidth = (int)getParam($oMedia->aGlParamsSettings[''maxSharedFileThumbWidth'']) + 16;\r\n$ret = $this->GenFormWrap($sCode, ''index'', ''_Photo Gallery'', $iWidth, $oMedia->aCurrent[''paginate''][''totalNum'']);\r\n\r\nreturn array($ret, $aMenu[0], $aMenu[1]);\r\n}\r\nelse\r\nreturn;', 1, 70, 'non,memb', 0),
-(NULL, 'index', '960px', 'Profile Photos By Members', '_Profile Photos', 1, 2, 'PHP',  'require_once(BX_DIRECTORY_PATH_MODULES . ''/boonex/shared_photo/classes/BxShPhotoSearch.php'');\r\n$oMedia = new BxShPhotoSearch();\r\n$oMedia->aCurrent[''paginate''][''perPage''] = getParam($oMedia->aGlParamsSettings[''maxTopFilesNum'']);\r\n$oMedia->aCurrent[''join''][''category''] = array(''type'' => ''left'',''table'' => ''Categories'',''mainField'' => $oMedia->aPseud[''id''],''onField'' => ''ID'',''joinFields'' => '''');\r\n$oMedia->aCurrent[''restriction''][''category''] = array(''value'' => PROFILE_PHOTO_CATEGORY,''field'' => ''Category'',''operator'' => ''='',''table'' => ''Categories'');\r\n
+(NULL, 'index', '960px', 'Profile Photos By Members', '_Profile Photos', 1, 2, 'PHP',  'require_once(BX_DIRECTORY_PATH_MODULES . ''/boonex/shared_photo/classes/BxShPhotoSearch.php'');\r\n$oMedia = new BxShPhotoSearch();\r\n$oMedia->aCurrent[''paginate''][''perPage''] = getParam($oMedia->aGlParamsSettings[''maxTopFilesNum'']);\r\n$oMedia->aCurrent[''join''][''category''] = array(''type'' => ''left'',''table'' => ''sys_categories'',''mainField'' => $oMedia->aPseud[''id''],''onField'' => ''ID'',''joinFields'' => '''');\r\n$oMedia->aCurrent[''restriction''][''category''] = array(''value'' => PROFILE_PHOTO_CATEGORY,''field'' => ''Category'',''operator'' => ''='',''table'' => ''sys_categories'');\r\n
 $sCode = $oMedia->displayResultBlock(); if (strlen($sCode) > 0) { $aMenu = $oMedia->displayMenu();\r\n$iWidth = (int)getParam($oMedia->aGlParamsSettings[''maxSharedFileThumbWidth'']) + 16;\r\n$ret = $this->GenFormWrap($sCode, ''index'', ''_Photo Gallery'', $iWidth, $oMedia->aCurrent[''paginate''][''totalNum'']); return array($ret, $aMenu[0], $aMenu[1]);\r\n} else return;', 1, 70, 'non,memb', 0),
 (NULL, 'member', '960px', '', '_My Photo Gallery', 2, 6, 'PHP', 'require_once(BX_DIRECTORY_PATH_MODULES . ''boonex/shared_photo/classes/BxShPhotoSearch.php'');\r\n$oMedia = new BxShPhotoSearch();\r\n$oMedia->aCurrent[''paginate''][''perPage''] = getParam($oMedia->aGlParamsSettings[''maxTopFilesNum'']);\r\n $oMedia->aCurrent[''restriction''][''owner''][''value''] = $this->iMember;\r\n      $sCode = $oMedia->displayResultBlock();\r\nif (strlen($sCode) > 0) {\r\n$aMenu = $oMedia->displayMenu();\r\n\r\n$iWidth = (int)getParam($oMedia->aGlParamsSettings[''maxSharedFileThumbWidth'']) + 16;\r\n$ret = $this->GenFormWrap($sCode, ''member'', ''_My Photo Gallery'', $iWidth, $oMedia->aCurrent[''paginate''][''totalNum'']);\r\n \r\nreturn array($ret, $aMenu[0], $aMenu[1]);\r\n}\r\nelse\r\nreturn;', 1, 70, 'non,memb', 0),