Home›Help›Trac

Changeset 9972


Ignore:
Timestamp:
04/06/09 04:21:27 (3 years ago)
Author:
Andrey Prikaznov
Message:
 
Location:
trunk
Files:
52 edited

Legend:

Unmodified
Added
Removed

  • trunk/admin/global_settings.php

    r9968 r9972  
    368368            SELECT 
    369369                `Name`, `VALUE`, `desc`, `Type`, `AvailableValues` 
    370             FROM `GlParams` 
     370            FROM `sys_options` 
    371371            WHERE `kateg` = '{$cat}' AND `Name` NOT LIKE '%_subject' 
    372372            ORDER BY `order_in_kateg` ASC 
    … …  
    418418                    // Get email subject. 
    419419                    $subject_name = $param_name.'_subject'; 
    420                     $q_str = "SELECT `VALUE` FROM `GlParams` WHERE `Name` = '$subject_name'"; 
     420                    $q_str = "SELECT `VALUE` FROM `sys_options` WHERE `Name` = '$subject_name'"; 
    421421                    $res = db_res($q_str); 
    422422                    if ($row = mysql_fetch_array($res)) 
    … …  
    551551        { 
    552552            // Get error message. 
    553             $q_str = "SELECT `desc`, `err_text` FROM `GlParams` WHERE `Name`='$key'"; 
     553            $q_str = "SELECT `desc`, `err_text` FROM `sys_options` WHERE `Name`='$key'"; 
    554554            $row = db_arr($q_str); 
    555555            // 
    … …  
    614614    global $errors; 
    615615    // Get checking conditions and error messages for every item in the category. 
    616     $q_str = "SELECT `Name`, `check` FROM `GlParams` WHERE `kateg` = $cat"; 
     616    $q_str = "SELECT `Name`, `check` FROM `sys_options` WHERE `kateg` = $cat"; 
    617617    $res = db_res($q_str); 
    618618    // Iterate thru items and check if values entered are valid. 
    … …  
    685685        if ( move_uploaded_file($_FILES['file_watermark']['tmp_name'], $uploadfile) ) 
    686686        { 
    687             $query = "UPDATE `GlParams` SET  `VALUE` ='". addslashes($_FILES['file_watermark']['name']) ."' WHERE `Name` = 'Water_Mark'"; 
     687            $query = "UPDATE `sys_options` SET  `VALUE` ='". addslashes($_FILES['file_watermark']['name']) ."' WHERE `Name` = 'Water_Mark'"; 
    688688            db_res($query); 
    689689            imageResize( $uploadfile, $targetfile, $gl_pic['pic']['width'], $gl_pic['pic']['height'] ); 
    … …  
    693693    } 
    694694 
    695     $query = "UPDATE `GlParams` SET `VALUE` ='". (int)$_POST['transp1'] ."' WHERE `Name` = 'transparent1'"; 
     695    $query = "UPDATE `sys_options` SET `VALUE` ='". (int)$_POST['transp1'] ."' WHERE `Name` = 'transparent1'"; 
    696696    db_res($query); 
    697     $query = "UPDATE `GlParams` SET `VALUE` ='". process_db_input($_POST['enable_wm']) ."' WHERE `Name` = 'enable_watermark'"; 
     697    $query = "UPDATE `sys_options` SET `VALUE` ='". process_db_input($_POST['enable_wm']) ."' WHERE `Name` = 'enable_watermark'"; 
    698698    db_res($query); 
    699699    ?> 

  • trunk/admin/memb_levels.php

    r9970 r9972  
    5050     
    5151    $sQuery = "SELECT 
    52                     `GlParams`.`Name`, 
     52                    `sys_options`.`Name`, 
    5353                    `VALUE` as `Value`, 
    5454                    `desc`, 
    … …  
    5757                    `order_in_kateg` as `Order` 
    5858            FROM 
    59                     `GlParams` 
    60             LEFT JOIN `sys_options_cats` ON `sys_options_cats`.`ID` = `GlParams`.`kateg` 
     59                    `sys_options` 
     60            LEFT JOIN `sys_options_cats` ON `sys_options_cats`.`ID` = `sys_options`.`kateg` 
    6161            WHERE 
    62                     ".$sCat." AND `GlParams`.`Name` NOT LIKE '%_subject' OR `GlParams`.`Name` = 'free_mode' ORDER BY `kateg`,`order_in_kateg` ASC"; 
     62                    ".$sCat." AND `sys_options`.`Name` NOT LIKE '%_subject' OR `sys_options`.`Name` = 'free_mode' ORDER BY `kateg`,`order_in_kateg` ASC"; 
    6363     
    6464    $sCode = '<form method="post" action="'. $_SERVER['PHP_SELF'].'"> 

  • trunk/admin/notifies.php

    r9969 r9972  
    3939 
    4040    // Select count of emails in queue per one message 
    41     $query = "SELECT `sys_mass_messages`.ID, `sys_mass_messages`.Subj, COUNT(`sys_mail_queue`.Email) AS `count_per_msg` FROM `sys_mass_messages` INNER JOIN `sys_mail_queue` ON (`sys_mail_queue`.Msg = `sys_mass_messages`.ID) GROUP BY `sys_mass_messages`.ID"; 
     41    $query = "SELECT `sys_mail_mass_messages`.ID, `sys_mail_mass_messages`.Subj, COUNT(`sys_mail_queue`.Email) AS `count_per_msg` FROM `sys_mail_mass_messages` INNER JOIN `sys_mail_queue` ON (`sys_mail_queue`.Msg = `sys_mail_mass_messages`.ID) GROUP BY `sys_mail_mass_messages`.ID"; 
    4242    $res = db_res($query); 
    4343    if ( !mysql_num_rows($res) ) 
    … …  
    116116    $ret = ""; 
    117117 
    118     $query = "SELECT `ID` FROM `sys_mass_messages` WHERE `ID` = $msg_id"; 
     118    $query = "SELECT `ID` FROM `sys_mail_mass_messages` WHERE `ID` = $msg_id"; 
    119119    $arr_arr = db_arr( $query ); 
    120120    if ( !$arr_arr ) 
    … …  
    247247function AddMessage() 
    248248{ 
    249     $query = "INSERT INTO `sys_mass_messages` SET `Subj` = '". process_db_input($_POST['subj']) ."', `Text` = '". process_db_input(html2txt($_POST['body_html'])) ."',`HTML` = '". process_db_input($_POST['body_html']) ."'"; 
     249    $query = "INSERT INTO `sys_mail_mass_messages` SET `Subj` = '". process_db_input($_POST['subj']) ."', `Text` = '". process_db_input(html2txt($_POST['body_html'])) ."',`HTML` = '". process_db_input($_POST['body_html']) ."'"; 
    250250 
    251251    $res = db_res( $query ); 
    … …  
    258258function UpdateMessage() 
    259259{ 
    260     $query = "UPDATE `sys_mass_messages` SET `Subj` = '". process_db_input($_POST['subj']) ."', `Text` = '". process_db_input(html2txt($_POST['body_html'])) ."', `HTML` = '". process_db_input($_POST['body_html']) ."' WHERE ID = '". (int)$_POST['msgs_id'] ."'"; 
     260    $query = "UPDATE `sys_mail_mass_messages` SET `Subj` = '". process_db_input($_POST['subj']) ."', `Text` = '". process_db_input(html2txt($_POST['body_html'])) ."', `HTML` = '". process_db_input($_POST['body_html']) ."' WHERE ID = '". (int)$_POST['msgs_id'] ."'"; 
    261261 
    262262    $res = db_res( $query ); 
    … …  
    293293function DeleteMessage() 
    294294{ 
    295     $query = "DELETE FROM `sys_mass_messages` WHERE `ID` = ". (int)$_POST['msgs_id']; 
     295    $query = "DELETE FROM `sys_mail_mass_messages` WHERE `ID` = ". (int)$_POST['msgs_id']; 
    296296    if ( !($res = db_res( $query )) ) 
    297297        return $res; 
    … …  
    384384<? 
    385385 
    386 $res_msgs = db_res("SELECT `ID`, `Subj`, `Text`, `HTML`, (`ID` = ". (int)$_POST['msgs_id'] ." OR `Subj` = '". process_db_input($_POST['subj']) ."' ) AS `Selected` FROM `sys_mass_messages`"); 
     386$res_msgs = db_res("SELECT `ID`, `Subj`, `Text`, `HTML`, (`ID` = ". (int)$_POST['msgs_id'] ." OR `Subj` = '". process_db_input($_POST['subj']) ."' ) AS `Selected` FROM `sys_mail_mass_messages`"); 
    387387while ( $arr_msgs = mysql_fetch_array($res_msgs) ) 
    388388{ 
    … …  
    413413elseif ( $_POST['msgs_id'] ) 
    414414{ 
    415     $arr = db_arr( "SELECT * FROM `sys_mass_messages` WHERE `ID` = ". (int)$_POST['msgs_id'] ); 
     415    $arr = db_arr( "SELECT * FROM `sys_mail_mass_messages` WHERE `ID` = ". (int)$_POST['msgs_id'] ); 
    416416    $body_html = $arr['HTML']; 
    417417    $body_text = $arr['Text']; 

  • trunk/flash/modules/desktop/inc/customFunctions.inc.php

    r8561 r9972  
    4747    $sNow = "NOW()"; 
    4848    if(!$bOnline) 
    49         $sNow = "(" . $sNow . "-" . getValue("SELECT `VALUE` FROM `GlParams` WHERE `Name`='member_online_time' LIMIT 1") * 120 . ")"; 
     49        $sNow = "(" . $sNow . "-" . getValue("SELECT `VALUE` FROM `sys_options` WHERE `Name`='member_online_time' LIMIT 1") * 120 . ")"; 
    5050    getResult("UPDATE `Profiles` SET `DateLastNav`=" . $sNow . " WHERE `ID`='" . $sId . "' LIMIT 1"); 
    5151} 

  • trunk/flash/modules/global/inc/customFunctions.inc.php

    r9967 r9972  
    9090        $sDesc = isset($aUser['DescriptionMe']) ? $aUser['DescriptionMe'] : ""; 
    9191         
    92         $sModRewrite = getValue("SELECT `VALUE` FROM `GlParams` WHERE `Name`='enable_modrewrite' LIMIT 1"); 
     92        $sModRewrite = getValue("SELECT `VALUE` FROM `sys_options` WHERE `Name`='enable_modrewrite' LIMIT 1"); 
    9393        $sProfile = $sModRewrite == "on" ? $sRootURL . $sNick : $sProfileUrl . "?ID=" . $sId; 
    9494 

  • trunk/inc/classes/BxDolParams.php

    r9304 r9972  
    5151           return $this->_aParams[$sKey]; 
    5252        else  
    53            return $this->_oDb->getOne("SELECT `VALUE` FROM `GlParams` WHERE `Name`='" . $sKey . "' LIMIT 1"); 
     53           return $this->_oDb->getOne("SELECT `VALUE` FROM `sys_options` WHERE `Name`='" . $sKey . "' LIMIT 1"); 
    5454    } 
    5555    function set($sKey, $mixedValue) { 
    … …  
    6060         
    6161        //--- Update Database ---// 
    62         $this->_oDb->query("UPDATE `GlParams` SET `VALUE`='" . $mixedValue . "' WHERE `Name`='" . $sKey . "' LIMIT 1"); 
     62        $this->_oDb->query("UPDATE `sys_options` SET `VALUE`='" . $mixedValue . "' WHERE `Name`='" . $sKey . "' LIMIT 1"); 
    6363    } 
    6464     
    6565    function cache() { 
    66         $aParams = $this->_oDb->getAll("SELECT `Name`, `VALUE` FROM `GlParams`", 'Name'); 
     66        $aParams = $this->_oDb->getAll("SELECT `Name`, `VALUE` FROM `sys_options`", 'Name'); 
    6767        if(empty($aParams))  
    6868            return false; 

  • trunk/inc/db.inc.php

    r9024 r9972  
    9898function getParamDesc( $param_name ) 
    9999{ 
    100     return $GLOBALS['MySQL']->getOne ("SELECT `desc` FROM `GlParams` WHERE `Name` = '$param_name'"); 
     100    return $GLOBALS['MySQL']->getOne ("SELECT `desc` FROM `sys_options` WHERE `Name` = '$param_name'"); 
    101101} 
    102102 

  • trunk/inc/match.inc.php

    r9969 r9972  
    7272    // update last execution time 
    7373    $sUpdateCronValSQL = " 
    74         UPDATE `GlParams` 
     74        UPDATE `sys_options` 
    7575        SET `VALUE` = NOW() 
    7676        WHERE `Name`='cupid_last_cron' 

  • trunk/install/index.php

    r9939 r9972  
    14351435 
    14361436    $enable_gd_value = extension_loaded('gd') ? 'on' : ''; 
    1437     if (! (mysql_query ("UPDATE `GlParams` SET `VALUE`='{$enable_gd_value}' WHERE `Name`='enable_gd'", $vLink ))) 
     1437    if (! (mysql_query ("UPDATE `sys_options` SET `VALUE`='{$enable_gd_value}' WHERE `Name`='enable_gd'", $vLink ))) 
    14381438        $ret .= "<font color=red><i><b>Error</b>:</i> ".mysql_error()."</font><hr>"; 
    14391439 
    … …  
    14421442    $sSiteEmailNotify = $_POST['notify_email']; 
    14431443    if ($sSiteEmail != '' && $sSiteTitle != '' && $sSiteEmailNotify != '') { 
    1444         if (! (mysql_query("UPDATE `GlParams` SET `VALUE`='{$sSiteEmail}' WHERE `Name`='site_email'", $vLink))) 
     1444        if (! (mysql_query("UPDATE `sys_options` SET `VALUE`='{$sSiteEmail}' WHERE `Name`='site_email'", $vLink))) 
    14451445            $ret .= "<font color=red><i><b>Error</b>:</i> ".mysql_error()."</font><hr>"; 
    1446         if (! (mysql_query("UPDATE `GlParams` SET `VALUE`='{$sSiteTitle}' WHERE `Name`='site_title'", $vLink))) 
     1446        if (! (mysql_query("UPDATE `sys_options` SET `VALUE`='{$sSiteTitle}' WHERE `Name`='site_title'", $vLink))) 
    14471447            $ret .= "<font color=red><i><b>Error</b>:</i> ".mysql_error()."</font><hr>"; 
    1448         if (! (mysql_query("UPDATE `GlParams` SET `VALUE`='{$sSiteEmailNotify}' WHERE `Name`='site_email_notify'", $vLink))) 
     1448        if (! (mysql_query("UPDATE `sys_options` SET `VALUE`='{$sSiteEmailNotify}' WHERE `Name`='site_email_notify'", $vLink))) 
    14491449            $ret .= "<font color=red><i><b>Error</b>:</i> ".mysql_error()."</font><hr>"; 
    14501450    } else { 

  • trunk/install/sql/v70.sql

    r9970 r9972  
    66 
    77SET NAMES 'utf8'; 
    8 DROP TABLE IF EXISTS `sys_account_custom_stat_elements`, `sys_admin_ban_list`, `sys_admin_links`, `sys_admin_menu`, `sys_admin_menu_categ`, `Admins`, `aff`, `sys_aff_banners`, `sys_aff_members`, `alerts`, `sys_albums`, `sys_albums_objects`,`sys_banners`, `sys_banners_clicks`, `sys_banners_shows`, `sys_block_list`, `sys_objects_browse`, `Categories`, `sys_objects_categories`, `sys_objects_cmts`, `sys_cmts_profile`, `sys_cmts_track`, `sys_color_base`, `sys_countries`, `sys_email_templates`, `sys_menu_member`, `sys_friend_list`, `GlParams`, `sys_options_cats`, `Groups`, `GroupsCateg`, `GroupsGallery`, `GroupsMembers`, `groups_rating`, `groups_voting_track`, `grp_forum`, `grp_forum_cat`, `grp_forum_flag`, `grp_forum_post`, `grp_forum_report`, `grp_forum_topic`, `grp_forum_user`, `grp_forum_user_activity`, `grp_forum_user_stat`, `grp_forum_vote`, `sys_fave_list`, `IPList`, `IPMembersVisits`, `Links`, `LocalizationCategories`, `LocalizationKeys`, `LocalizationLanguages`, `LocalizationStringParams`, `LocalizationStrings`, `sys_acl_actions`, `sys_acl_actions_track`, `members_as_aff`, `sys_acl_matrix`, `sys_acl_level_prices`, `sys_acl_levels`, `Messages`, `moderators`, `Modules`, `News`, `sys_subscriptions`, `sys_mass_messages`, `sys_mail_queue`, `PageCompose`, `PageComposePages`, `PaymentParameters`, `PaymentProviders`, `PaymentSubscriptions`, `sys_stat_member`, `PreValues`, `ProfileFields`, `sys_acl_levels_members`, `Profiles`, `profile_views_track`, `ProfilesMatch`, `ProfilesSettings`, `ProfilesTrack`, `profile_rating`, `profile_voting_track`, `RayBoardCurrentUsers`, `RayBoardBoards`, `RayBoardUsers`, `RayChatCurrentUsers`, `RayChatMessages`, `RayChatProfiles`, `RayChatRooms`, `RayChatRoomsUsers`, `RayGlobalTrackUsers`, `RayImContacts`, `RayImMessages`, `RayImPendings`, `RayImProfiles`, `RayMp3Files`, `RayShoutboxMessages`, `RayVideoFiles`, `RayVideo_commentsFiles`, `SearchObjects`, `sharedSites`, `sys_stat_site`, `smiles`, `sys_alerts`, `sys_alerts_handlers`, `sys_injections`, `sys_injections_admin`, `sys_modules`, `sys_modules_file_tracks`, `sys_permalinks`, `Stories`, `Tags`, `TagObjects`, `TopMenu`, `Transactions`, `sys_objects_actions`, `Greetings`, `Votes`, `ZIPCodes`, `VoteObjects`, `sys_objects_views`, `sys_box_download`; 
     8DROP TABLE IF EXISTS `sys_account_custom_stat_elements`, `sys_admin_ban_list`, `sys_admin_links`, `sys_admin_menu`, `sys_admin_menu_categ`, `Admins`, `aff`, `sys_aff_banners`, `sys_aff_members`, `alerts`, `sys_albums`, `sys_albums_objects`,`sys_banners`, `sys_banners_clicks`, `sys_banners_shows`, `sys_block_list`, `sys_objects_browse`, `Categories`, `sys_objects_categories`, `sys_objects_cmts`, `sys_cmts_profile`, `sys_cmts_track`, `sys_color_base`, `sys_countries`, `sys_email_templates`, `sys_menu_member`, `sys_friend_list`, `sys_options`, `sys_options_cats`, `Groups`, `GroupsCateg`, `GroupsGallery`, `GroupsMembers`, `groups_rating`, `groups_voting_track`, `grp_forum`, `grp_forum_cat`, `grp_forum_flag`, `grp_forum_post`, `grp_forum_report`, `grp_forum_topic`, `grp_forum_user`, `grp_forum_user_activity`, `grp_forum_user_stat`, `grp_forum_vote`, `sys_fave_list`, `IPList`, `IPMembersVisits`, `Links`, `LocalizationCategories`, `LocalizationKeys`, `LocalizationLanguages`, `LocalizationStringParams`, `LocalizationStrings`, `sys_acl_actions`, `sys_acl_actions_track`, `members_as_aff`, `sys_acl_matrix`, `sys_acl_level_prices`, `sys_acl_levels`, `Messages`, `moderators`, `News`, `sys_subscriptions`, `sys_mail_mass_messages`, `sys_mail_queue`, `PageCompose`, `PageComposePages`, `PaymentParameters`, `PaymentProviders`, `PaymentSubscriptions`, `sys_stat_member`, `PreValues`, `ProfileFields`, `sys_acl_levels_members`, `Profiles`, `profile_views_track`, `ProfilesMatch`, `ProfilesSettings`, `ProfilesTrack`, `profile_rating`, `profile_voting_track`, `RayBoardCurrentUsers`, `RayBoardBoards`, `RayBoardUsers`, `RayChatCurrentUsers`, `RayChatMessages`, `RayChatProfiles`, `RayChatRooms`, `RayChatRoomsUsers`, `RayGlobalTrackUsers`, `RayImContacts`, `RayImMessages`, `RayImPendings`, `RayImProfiles`, `RayMp3Files`, `RayShoutboxMessages`, `RayVideoFiles`, `RayVideo_commentsFiles`, `SearchObjects`, `sharedSites`, `sys_stat_site`, `smiles`, `sys_alerts`, `sys_alerts_handlers`, `sys_injections`, `sys_injections_admin`, `sys_modules`, `sys_modules_file_tracks`, `sys_permalinks`, `Stories`, `Tags`, `TagObjects`, `TopMenu`, `Transactions`, `sys_objects_actions`, `Greetings`, `Votes`, `ZIPCodes`, `VoteObjects`, `sys_objects_views`, `sys_box_download`; 
    99ALTER DATABASE DEFAULT CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci'; 
    1010 
    … …  
    10991099 
    11001100-- 
    1101 -- Table structure for table `GlParams` 
    1102 -- 
    1103  
    1104 CREATE TABLE `GlParams` ( 
     1101-- Table structure for table `sys_options` 
     1102-- 
     1103 
     1104CREATE TABLE `sys_options` ( 
    11051105  `Name` varchar(64) NOT NULL default '', 
    11061106  `VALUE` mediumtext NOT NULL, 
    … …  
    11171117 
    11181118-- 
    1119 -- Dumping data for table `GlParams` 
    1120 -- 
    1121  
    1122 INSERT INTO `GlParams` VALUES('anon_mode', '', 1, 'Anonymous mode (no contact information)', 'checkbox', '', '', 12, ''); 
    1123 INSERT INTO `GlParams` VALUES('autoApproval_ifJoin', 'on', 6, 'Automatic profile activation after joining', 'checkbox', '', '', NULL, ''); 
    1124 INSERT INTO `GlParams` VALUES('autoApproval_ifProfile', 'on', 6, 'Do not change profile status after editing profile information', 'checkbox', '', '', NULL, ''); 
    1125 INSERT INTO `GlParams` VALUES('cmdDay', '10', 0, '', 'digit', '', '', NULL, ''); 
    1126 INSERT INTO `GlParams` VALUES('currency_code', 'USD', 0, 'Currency code (for checkout system)', 'combobox', 'return strlen($arg0) > 0;', 'cannot be empty.', NULL, 'USD,EURO'); 
    1127 INSERT INTO `GlParams` VALUES('currency_sign', '$', 15, 'Currency sign (for display purposes only)', 'digit', 'return strlen($arg0) > 0;', 'cannot be empty.', 9, ''); 
    1128 INSERT INTO `GlParams` VALUES('date_format', '%m-%d-%y %H:%i', 15, 'Long Date Format <a href="#" onclick="javascript: window.open(''/admin/help.html'', ''DateFormat'', ''width=500,height=400,scrollbars=yes,menubar=no,resizable=no''); return false;">?</a>', 'digit', '', '', 15, ''); 
    1129 INSERT INTO `GlParams` VALUES('db_clean_msg', '180', 11, 'Clean old messages ( days )', 'digit', '', '', NULL, ''); 
    1130 INSERT INTO `GlParams` VALUES('db_clean_profiles', '180', 11, 'Clean old profiles by last log in ( days )', 'digit', '', '', NULL, ''); 
    1131 INSERT INTO `GlParams` VALUES('db_clean_views', '180', 11, 'Clean old profile views ( days )', 'digit', '', '', NULL, ''); 
    1132 INSERT INTO `GlParams` VALUES('db_clean_vkiss', '90', 11, 'Clean old greetings ( days )', 'digit', '', '', NULL, ''); 
    1133 INSERT INTO `GlParams` VALUES('default_country', 'US', 51, 'Default Country on Index Page', 'text', '', '', NULL, ''); 
    1134 INSERT INTO `GlParams` VALUES('enable_aff', '', 15, 'Enable affiliate support', 'checkbox', '', '', 1, ''); 
    1135 INSERT INTO `GlParams` VALUES('enable_contact_form', 'on', 15, 'Show contact form on contact us page', 'checkbox', '', '', 2, ''); 
    1136 INSERT INTO `GlParams` VALUES('enable_cupid', 'on', 12, 'Enable cupid mails', 'checkbox', '', '', NULL, ''); 
    1137 INSERT INTO `GlParams` VALUES('enable_customization', 'on', 1, 'Enable profile customization', 'checkbox', '', '', 10, ''); 
    1138 INSERT INTO `GlParams` VALUES('enable_gd', 'on', 15, 'Use GD library for image processing', 'checkbox', '', '', 5, ''); 
    1139 INSERT INTO `GlParams` VALUES('enable_inbox_notify', '', 17, 'Enable new message notifications', 'checkbox', '', '', NULL, ''); 
    1140 INSERT INTO `GlParams` VALUES('enable_match', 'on', 12, 'Enable matchmaking', 'checkbox', '', '', NULL, ''); 
    1141 INSERT INTO `GlParams` VALUES('enable_msg_dest_choice', 'on', 17, 'Enable message destination user choice', 'checkbox', '', '', NULL, ''); 
    1142 INSERT INTO `GlParams` VALUES('enable_promotion_membership', 'on', 7, 'Enable promotional membership', 'checkbox', '', '', 1, ''); 
    1143 INSERT INTO `GlParams` VALUES('enable_recurring', 'on', 0, 'Enable recurring billings', 'checkbox', '', '', NULL, ''); 
    1144 INSERT INTO `GlParams` VALUES('enable_template', '', 15, 'Enable Users to Change Templates', 'checkbox', '', '', NULL, ''); 
    1145 INSERT INTO `GlParams` VALUES('enable_watermark', '', 16, 'Enable Watermark', 'checkbox', '', '', 1, ''); 
    1146 INSERT INTO `GlParams` VALUES('enable_zip_loc', 'on', 15, 'Enable search by ZIP codes', 'checkbox', '', '', 0, ''); 
    1147 INSERT INTO `GlParams` VALUES('expire_notification_days', '1', 5, 'Number of days before membership expiration to notify members ( -1 = after expiration )', 'digit', '', '', NULL, ''); 
    1148 INSERT INTO `GlParams` VALUES('expire_notify_once', 'on', 5, 'Notify members about membership expiration only once (every day otherwise)', 'checkbox', '', '', NULL, ''); 
    1149 INSERT INTO `GlParams` VALUES('featured_num', '16', 51, 'Number of featured members displayed on front page', 'digit', 'return $arg0 >= 0;', 'must be equal to or greater than zero.', NULL, ''); 
    1150 INSERT INTO `GlParams` VALUES('free_mode', 'on', 0, 'Site is running in free mode', 'checkbox', '', '', NULL, ''); 
    1151 INSERT INTO `GlParams` VALUES('lang_default', 'en', 0, 'Default site language', 'text', '', '', NULL, ''); 
    1152 INSERT INTO `GlParams` VALUES('match_percent', '70', 12, 'Send a cupid mail if the recently joined profile matches more than this percentage', 'digit', '', '', NULL, ''); 
    1153 -- INSERT INTO `GlParams` VALUES('max_inbox_messages', '5', 3, 'Maximum number of messages stored in inbox', 'digit', '', '', 3, ''); 
    1154 INSERT INTO `GlParams` VALUES('max_inbox_message_size', '1500', 3, 'Maximum message size in symbols', 'digit', '', '', 4, ''); 
    1155 INSERT INTO `GlParams` VALUES('member_online_time', '5', 3, 'Time period in minutes within which a member is considered to be online', 'digit', '', '', 5, ''); 
    1156 INSERT INTO `GlParams` VALUES('MetaDescription', '', 19, 'Insert Meta description on site  pages', 'text', '', '', NULL, ''); 
    1157 INSERT INTO `GlParams` VALUES('MetaKeyWords', '', 19, 'Insert Meta keywords on site pages (comma-separated list)', 'text', '', '', NULL, ''); 
    1158 INSERT INTO `GlParams` VALUES('msgs_per_start', '20', 8, 'Send emails from queue, it happens every cron execution (5m-1h)', 'digit', '', '', NULL, ''); 
    1159 INSERT INTO `GlParams` VALUES('news_enable', '1', 0, 'show boonex news in admin panel', 'digit', '', '', NULL, ''); 
    1160 INSERT INTO `GlParams` VALUES('newusernotify', 'on', 1, 'New User Notify', 'checkbox', '', '', 2, ''); 
    1161 INSERT INTO `GlParams` VALUES('promotion_membership_days', '7', 7, 'Number of days for promotional membership', 'digit', '', '', 2, ''); 
    1162 INSERT INTO `GlParams` VALUES('search_end_age', '75', 1, 'Highest age possible for site members', 'digit', '', '', 21, ''); 
    1163 INSERT INTO `GlParams` VALUES('search_start_age', '18', 1, 'Lowest age possible for site members', 'digit', '', '', 20, ''); 
    1164 INSERT INTO `GlParams` VALUES('short_date_format', '%m-%d-%y', 15, 'Short Date Format <a href="#" onclick="javascript: window.open(''/admin/help.html'', ''DateFormat'', ''width=500,height=400,scrollbars=yes,menubar=no,resizable=no''); return false;">?</a>', 'digit', '', '', 14, ''); 
    1165 INSERT INTO `GlParams` VALUES('template', 'uni', 15, 'Template', 'combobox', 'global $dir; return (strlen($arg0) > 0 && file_exists($dir["root"]."templates/tmpl_".$arg0) ) ? true : false;', 'cannot be empty and template must be valid.', 17, ''); 
    1166 INSERT INTO `GlParams` VALUES('sys_calendar_starts_sunday', '', 15, 'Is calendar starts from Sunday?', 'checkbox', '', '', '18', ''); 
    1167 INSERT INTO `GlParams` VALUES('top_members_max_num', '16', 51, 'How many results show on index page in top members area', 'digit', '', '', NULL, ''); 
    1168 INSERT INTO `GlParams` VALUES('track_profile_view', 'on', 1, 'Track all profile views. Later a member can manage these "views".', 'checkbox', '', '', 1, ''); 
    1169 INSERT INTO `GlParams` VALUES('transparent1', '0', 16, 'Transparency for first image', 'digit', '', '', 2, ''); 
    1170 INSERT INTO `GlParams` VALUES('transparent2', '15', 16, 'Transparency for second image', 'digit', '', '', NULL, ''); 
    1171 INSERT INTO `GlParams` VALUES('votes', 'on', 1, 'Enable profile votes', 'checkbox', '', '', 5, ''); 
    1172 INSERT INTO `GlParams` VALUES('Water_Mark', '', 16, 'Water Mark', 'text', '', '', 3, ''); 
    1173 INSERT INTO `GlParams` VALUES('zodiac', '', 1, 'Show zodiac signs', 'checkbox', '', '', 9, ''); 
    1174 INSERT INTO `GlParams` VALUES('php_date_format', 'F j, Y', 15, 'PHP date format', 'digit', '', '', 16, ''); 
    1175 INSERT INTO `GlParams` VALUES('group_img_width', '600', 24, 'Gallery max image width', 'digit', '', '', 1, ''); 
    1176 INSERT INTO `GlParams` VALUES('group_img_height', '600', 24, 'Gallery max image height', 'digit', '', '', 2, ''); 
    1177 INSERT INTO `GlParams` VALUES('group_img_tmb_width', '100', 24, 'Gallery max image thumb width', 'digit', '', '', 3, ''); 
    1178 INSERT INTO `GlParams` VALUES('group_img_tmb_height', '100', 24, 'Gallery max image thumb height', 'digit', '', '', 4, ''); 
    1179 INSERT INTO `GlParams` VALUES('group_invitation_text', '<b>{sender}</b> has invited you to join <b>{group}</b>.<br />\r\nGroups allow users to communicate on the forums on interesting topics, share pictures, etc.<br />\r\nYou may accept or reject this invitation below:<br />\r\n<b>{accept} &nbsp; &nbsp; &nbsp; {reject}</b>', 24, 'Group invitation text', 'text', '', '', 5, ''); 
    1180 INSERT INTO `GlParams` VALUES('group_approve_notify', 'The creator of the {group} allows you to join the group.<br />\r\nNow you''re an active member of this group and you can share your opinion, post images and communicate on message boards.\r\n', 24, 'Group member approve notification', 'text', '', '', 6, ''); 
    1181 INSERT INTO `GlParams` VALUES('group_creator_request', 'Hello, {creator}.<br />\r\nMember {member} would like to join your group {group}.<br />\r\nYou may approve or reject this join request below:<br />\r\n{approve} &nbsp; &nbsp; &nbsp; {reject}', 24, 'Request message to group creator', 'text', '', '', 8, ''); 
    1182 INSERT INTO `GlParams` VALUES('group_reject_notify', 'Dear {member},<br />\r\nSorry but the creator of the group {group} doesn''t allow you to join the group. If you wish try again later.\r\n', 24, 'Group member reject notification', 'text', '', '', 7, ''); 
    1183 INSERT INTO `GlParams` VALUES('tags_non_parsable', 'hi, hey, hello, all, i, i''m, i''d, am, for, in, to, a, the, on, it''s, is, my, of, are, from, i''m, me, you, and, we, not, will, at, where, there', 25, 'Non-parsable tags (type all tags in lower case, delimit them by comma)', 'text', '', '', 0, ''); 
    1184 INSERT INTO `GlParams` VALUES('tags_last_parse_time', '0', 0, 'Temporary value when tags cron-job was runed last time', 'digit', '', '', NULL, ''); 
    1185 INSERT INTO `GlParams` VALUES('tags_min_rating', '2', 25, 'Minimum rating of tag to show it', 'digit', '', '', 2, ''); 
    1186 INSERT INTO `GlParams` VALUES('autoApproval_ifNoConfEmail', 'on', 6, 'Automatic profile confirmation without Confirmation Email', 'checkbox', '', '', NULL, ''); 
    1187 INSERT INTO `GlParams` VALUES('enable_flash_promo', 'on', 0, '', 'checkbox', '', '', NULL, ''); 
    1188 INSERT INTO `GlParams` VALUES('custom_promo_code', '', 0, '', 'text', '', '', NULL, ''); 
    1189 INSERT INTO `GlParams` VALUES('license_code', '', 1, 'Dolphin License Code', 'digit', '', '', 0, ''); 
    1190 INSERT INTO `GlParams` VALUES('enable_dolphin_footer', 'on', 0, 'enable boonex footers', 'checkbox', '', '', NULL, ''); 
    1191 INSERT INTO `GlParams` VALUES('enable_ray_footer', 'on', 0, 'enable boonex footers', 'checkbox', '', '', NULL, ''); 
    1192 -- INSERT INTO `GlParams` VALUES('topmenu_items_perline', '0', 15, 'Number of items per line in top menu. 0 - no breaking.', 'digit', '', '', 20, ''); 
    1193 INSERT INTO `GlParams` VALUES('enable_modrewrite', 'on', 26, 'Enable friendly profile permalinks', 'checkbox', '', '', 1, ''); 
    1194 INSERT INTO `GlParams` VALUES('permalinks_groups', 'on', 26, 'Enable friendly groups permalinks', 'checkbox', '', '', 10, ''); 
    1195 INSERT INTO `GlParams` VALUES('cupid_last_cron', '0', 0, 'Temporary value when cupid mails checked was runed last time', 'text', '', '', NULL, ''); 
    1196 INSERT INTO `GlParams` VALUES('reg_by_inv_only', '', 3, 'Registration by invitation only (need before Enable affiliate support)', 'checkbox', '', '', 13, ''); 
    1197 INSERT INTO `GlParams` VALUES('main_div_width', '960px', 0, 'Width of the main container of the site', 'digit', '', '', 0, ''); 
    1198 INSERT INTO `GlParams` VALUES('promoWidth', '960', 0, 'Default Width of the Promo Images for resizing', 'digit', '', '', 0, ''); 
    1199 INSERT INTO `GlParams` VALUES('profile_gallery_feature', '', 3, 'New Gallery Feature for Shared Photos', 'checkbox', '', '', NULL, ''); 
    1200 INSERT INTO `GlParams` VALUES('boonexAffID', '', 1, 'My BoonEx Affiliate ID', 'digit', '', '', 0.5, ''); 
    1201 INSERT INTO `GlParams` VALUES('ipBlacklistMode', '1', 3, 'IP Blacklist system mode (1 - total block, 2 - login block)', 'digit', '', '', NULL, ''); 
    1202 INSERT INTO `GlParams` VALUES('ipListGlobalType', '3', 3, 'IP List Type (1 - all allowed except listed, 2 - all blocked except listed, 0 - disabled)', 'digit', '', '', NULL, ''); 
    1203 INSERT INTO `GlParams` VALUES('enable_member_store_ip', 'on', 3, 'When a member login into dolphin 6 that the IP address from that person will be saved into the database', 'checkbox', '', '', NULL, ''); 
    1204 INSERT INTO `GlParams` VALUES('site_email', 'xxx@gmail.com', 50, 'Site Email', 'digit', '', '', NULL, ''); 
    1205 INSERT INTO `GlParams` VALUES('site_title', 'Unite Community', 50, 'Site Title', 'digit', '', '', NULL, ''); 
    1206 INSERT INTO `GlParams` VALUES('site_email_notify', 'xxx2@gmail.com', 50, 'Site Email Notify', 'digit', '', '', NULL, ''); 
    1207 INSERT INTO `GlParams` VALUES('enable_html_in_comments', 'on', 3, 'Enable HTML in comments', 'checkbox', '', '', NULL, ''); 
    1208 INSERT INTO `GlParams` VALUES('enable_tiny_in_comments', '', 3, 'Enable TinyMCS in comments', 'checkbox', '', '', NULL, ''); 
    1209 INSERT INTO `GlParams` VALUES('enable_global_couple', 'on', 3, 'Global Enabling of Couples', 'checkbox', '', '', NULL, ''); 
    1210 INSERT INTO `GlParams` VALUES('enable_new_dhtml_popups', 'on', 3, 'Enable new DHTML notifications rather than popup', 'checkbox', '', '', NULL, ''); 
    1211 INSERT INTO `GlParams` VALUES('dbCleanAlert', '2', 3, 'Clean old user alerts', 'digit', '', '', 5, ''); 
    1212 INSERT INTO `GlParams` VALUES('galleryFiles_user', '2', 23, 'Number of gallery files relate to user', 'digit', '', '', 21, ''); 
    1213 INSERT INTO `GlParams` VALUES('galleryFiles_keyword', '2', 23, 'Number of related gallery files', 'digit', '', '', 22, ''); 
    1214 INSERT INTO `GlParams` VALUES('enable_cache_system', 'on', 3, 'Enable caching system to store profiles information', 'checkbox', '', '', NULL, ''); 
    1215 INSERT INTO `GlParams` VALUES('nav_menu_elements_on_line', '12', 3, 'The number of elements in the navigation menu which will be desplayed before the More link (line)', 'digit', '', '', 15, ''); 
    1216 INSERT INTO `GlParams` VALUES('ext_nav_menu_on_line_bottom', '11', 3, 'The number of elements in the additional members menu which will be desplayed (in bottom position )', 'digit', '', '', 17, ''); 
    1217 INSERT INTO `GlParams` VALUES('enable_guest_comments', '', 3, 'enable possibility to post comments by guests', 'checkbox', '', '', NULL, ''); 
    1218 INSERT INTO `GlParams` VALUES('permalinks_browse', 'on', 26, 'Enable friendly browse permalinks', 'checkbox', '', '', 12, ''); 
    1219 INSERT INTO `GlParams` VALUES('sys_ntns_ajax_mode', 'on', 1, 'Enable Ajax mode for Notifications', 'checkbox', '', '', 23, ''); 
    1220 INSERT INTO `GlParams` VALUES('sys_ntns_update_interval', '10', 1, 'Notification''s update interval in seconds(for Ajax mode only)', 'digit', '', '', 24, ''); 
    1221 INSERT INTO `GlParams` VALUES('sys_ntns_expiration_time', '30', 1, 'Notification''s expiration time in minutes', 'digit', '', '', 25, ''); 
    1222 INSERT INTO `GlParams` VALUES('sys_ntns_display_number', '3', 1, 'Notification''s display number', 'digit', '', '', 26, ''); 
    1223 INSERT INTO `GlParams` VALUES('promo_relocation_link_visitor', 'join.php', 3, 'Default relocation link to Promo for non-members', 'text', '', '', NULL, ''); 
    1224 INSERT INTO `GlParams` VALUES('promo_relocation_link_member', 'member.php', 3, 'Default relocation link to Promo for members', 'text', '', '', NULL, ''); 
    1225 INSERT INTO `GlParams` VALUES('leaders_male_types', 'year,month,week,day', 3, 'Period types of leaders for male', 'select', '', '', NULL, 'year,month,week,day'); 
    1226 INSERT INTO `GlParams` VALUES('leaders_female_types', 'year,month,week,day', 3, 'Period types of leaders for female', 'select', '', '', NULL, 'year,month,week,day'); 
    1227 INSERT INTO `GlParams` VALUES('useLikeOperator', '', 15, 'Use operator LIKE for search (recommended for small content)', 'checkbox', '', '', 21, ''); 
    1228 INSERT INTO `GlParams` VALUES('ext_nav_menu_top_position', 'bottom', 15, 'Member menu position', 'combobox', 'return strlen($arg0) > 0;', 'cannot be empty.', 16, 'top,bottom,static'); 
    1229 INSERT INTO `GlParams` VALUES('sys_ps_enabled_group_2', 'on', 9, 'Enable \'All\' group', 'checkbox', '', '', 1, ''); 
    1230 INSERT INTO `GlParams` VALUES('sys_ps_enabled_group_3', 'on', 9, 'Enable \'Friends\' group', 'checkbox', '', '', 2, ''); 
    1231 INSERT INTO `GlParams` VALUES('sys_ps_enabled_group_4', 'on', 9, 'Enable \'Faves\' group', 'checkbox', '', '', 3, ''); 
    1232 INSERT INTO `GlParams` VALUES('sys_ps_enabled_group_5', 'on', 9, 'Enable \'Contacts\' group', 'checkbox', '', '', 4, ''); 
    1233 INSERT INTO `GlParams` VALUES('sys_make_album_cover_last', 'on', 1, 'Set last object as cover of album', 'checkbox', '', '', 20, ''); 
    1234 INSERT INTO `GlParams` VALUES('sys_album_auto_app', 'on', 1, 'Autoapproval for albums', 'checkbox', '', '', 21, ''); 
    1235 INSERT INTO `GlParams` VALUES('sys_album_default_name', 'Unsorted', 0, 'Default album name', 'text', '', '', 22, ''); 
     1119-- Dumping data for table `sys_options` 
     1120-- 
     1121 
     1122INSERT INTO `sys_options` VALUES('anon_mode', '', 1, 'Anonymous mode (no contact information)', 'checkbox', '', '', 12, ''); 
     1123INSERT INTO `sys_options` VALUES('autoApproval_ifJoin', 'on', 6, 'Automatic profile activation after joining', 'checkbox', '', '', NULL, ''); 
     1124INSERT INTO `sys_options` VALUES('autoApproval_ifProfile', 'on', 6, 'Do not change profile status after editing profile information', 'checkbox', '', '', NULL, ''); 
     1125INSERT INTO `sys_options` VALUES('cmdDay', '10', 0, '', 'digit', '', '', NULL, ''); 
     1126INSERT INTO `sys_options` VALUES('currency_code', 'USD', 0, 'Currency code (for checkout system)', 'combobox', 'return strlen($arg0) > 0;', 'cannot be empty.', NULL, 'USD,EURO'); 
     1127INSERT INTO `sys_options` VALUES('currency_sign', '$', 15, 'Currency sign (for display purposes only)', 'digit', 'return strlen($arg0) > 0;', 'cannot be empty.', 9, ''); 
     1128INSERT INTO `sys_options` VALUES('date_format', '%m-%d-%y %H:%i', 15, 'Long Date Format <a href="#" onclick="javascript: window.open(''/admin/help.html'', ''DateFormat'', ''width=500,height=400,scrollbars=yes,menubar=no,resizable=no''); return false;">?</a>', 'digit', '', '', 15, ''); 
     1129INSERT INTO `sys_options` VALUES('db_clean_msg', '180', 11, 'Clean old messages ( days )', 'digit', '', '', NULL, ''); 
     1130INSERT INTO `sys_options` VALUES('db_clean_profiles', '180', 11, 'Clean old profiles by last log in ( days )', 'digit', '', '', NULL, ''); 
     1131INSERT INTO `sys_options` VALUES('db_clean_views', '180', 11, 'Clean old profile views ( days )', 'digit', '', '', NULL, ''); 
     1132INSERT INTO `sys_options` VALUES('db_clean_vkiss', '90', 11, 'Clean old greetings ( days )', 'digit', '', '', NULL, ''); 
     1133INSERT INTO `sys_options` VALUES('default_country', 'US', 51, 'Default Country on Index Page', 'text', '', '', NULL, ''); 
     1134INSERT INTO `sys_options` VALUES('enable_aff', '', 15, 'Enable affiliate support', 'checkbox', '', '', 1, ''); 
     1135INSERT INTO `sys_options` VALUES('enable_contact_form', 'on', 15, 'Show contact form on contact us page', 'checkbox', '', '', 2, ''); 
     1136INSERT INTO `sys_options` VALUES('enable_cupid', 'on', 12, 'Enable cupid mails', 'checkbox', '', '', NULL, ''); 
     1137INSERT INTO `sys_options` VALUES('enable_customization', 'on', 1, 'Enable profile customization', 'checkbox', '', '', 10, ''); 
     1138INSERT INTO `sys_options` VALUES('enable_gd', 'on', 15, 'Use GD library for image processing', 'checkbox', '', '', 5, ''); 
     1139INSERT INTO `sys_options` VALUES('enable_inbox_notify', '', 17, 'Enable new message notifications', 'checkbox', '', '', NULL, ''); 
     1140INSERT INTO `sys_options` VALUES('enable_match', 'on', 12, 'Enable matchmaking', 'checkbox', '', '', NULL, ''); 
     1141INSERT INTO `sys_options` VALUES('enable_msg_dest_choice', 'on', 17, 'Enable message destination user choice', 'checkbox', '', '', NULL, ''); 
     1142INSERT INTO `sys_options` VALUES('enable_promotion_membership', 'on', 7, 'Enable promotional membership', 'checkbox', '', '', 1, ''); 
     1143INSERT INTO `sys_options` VALUES('enable_recurring', 'on', 0, 'Enable recurring billings', 'checkbox', '', '', NULL, ''); 
     1144INSERT INTO `sys_options` VALUES('enable_template', '', 15, 'Enable Users to Change Templates', 'checkbox', '', '', NULL, ''); 
     1145INSERT INTO `sys_options` VALUES('enable_watermark', '', 16, 'Enable Watermark', 'checkbox', '', '', 1, ''); 
     1146INSERT INTO `sys_options` VALUES('enable_zip_loc', 'on', 15, 'Enable search by ZIP codes', 'checkbox', '', '', 0, ''); 
     1147INSERT INTO `sys_options` VALUES('expire_notification_days', '1', 5, 'Number of days before membership expiration to notify members ( -1 = after expiration )', 'digit', '', '', NULL, ''); 
     1148INSERT INTO `sys_options` VALUES('expire_notify_once', 'on', 5, 'Notify members about membership expiration only once (every day otherwise)', 'checkbox', '', '', NULL, ''); 
     1149INSERT INTO `sys_options` VALUES('featured_num', '16', 51, 'Number of featured members displayed on front page', 'digit', 'return $arg0 >= 0;', 'must be equal to or greater than zero.', NULL, ''); 
     1150INSERT INTO `sys_options` VALUES('free_mode', 'on', 0, 'Site is running in free mode', 'checkbox', '', '', NULL, ''); 
     1151INSERT INTO `sys_options` VALUES('lang_default', 'en', 0, 'Default site language', 'text', '', '', NULL, ''); 
     1152INSERT INTO `sys_options` VALUES('match_percent', '70', 12, 'Send a cupid mail if the recently joined profile matches more than this percentage', 'digit', '', '', NULL, ''); 
     1153-- INSERT INTO `sys_options` VALUES('max_inbox_messages', '5', 3, 'Maximum number of messages stored in inbox', 'digit', '', '', 3, ''); 
     1154INSERT INTO `sys_options` VALUES('max_inbox_message_size', '1500', 3, 'Maximum message size in symbols', 'digit', '', '', 4, ''); 
     1155INSERT INTO `sys_options` VALUES('member_online_time', '5', 3, 'Time period in minutes within which a member is considered to be online', 'digit', '', '', 5, ''); 
     1156INSERT INTO `sys_options` VALUES('MetaDescription', '', 19, 'Insert Meta description on site  pages', 'text', '', '', NULL, ''); 
     1157INSERT INTO `sys_options` VALUES('MetaKeyWords', '', 19, 'Insert Meta keywords on site pages (comma-separated list)', 'text', '', '', NULL, ''); 
     1158INSERT INTO `sys_options` VALUES('msgs_per_start', '20', 8, 'Send emails from queue, it happens every cron execution (5m-1h)', 'digit', '', '', NULL, ''); 
     1159INSERT INTO `sys_options` VALUES('news_enable', '1', 0, 'show boonex news in admin panel', 'digit', '', '', NULL, ''); 
     1160INSERT INTO `sys_options` VALUES('newusernotify', 'on', 1, 'New User Notify', 'checkbox', '', '', 2, ''); 
     1161INSERT INTO `sys_options` VALUES('promotion_membership_days', '7', 7, 'Number of days for promotional membership', 'digit', '', '', 2, ''); 
     1162INSERT INTO `sys_options` VALUES('search_end_age', '75', 1, 'Highest age possible for site members', 'digit', '', '', 21, ''); 
     1163INSERT INTO `sys_options` VALUES('search_start_age', '18', 1, 'Lowest age possible for site members', 'digit', '', '', 20, ''); 
     1164INSERT INTO `sys_options` VALUES('short_date_format', '%m-%d-%y', 15, 'Short Date Format <a href="#" onclick="javascript: window.open(''/admin/help.html'', ''DateFormat'', ''width=500,height=400,scrollbars=yes,menubar=no,resizable=no''); return false;">?</a>', 'digit', '', '', 14, ''); 
     1165INSERT INTO `sys_options` VALUES('template', 'uni', 15, 'Template', 'combobox', 'global $dir; return (strlen($arg0) > 0 && file_exists($dir["root"]."templates/tmpl_".$arg0) ) ? true : false;', 'cannot be empty and template must be valid.', 17, ''); 
     1166INSERT INTO `sys_options` VALUES('sys_calendar_starts_sunday', '', 15, 'Is calendar starts from Sunday?', 'checkbox', '', '', '18', ''); 
     1167INSERT INTO `sys_options` VALUES('top_members_max_num', '16', 51, 'How many results show on index page in top members area', 'digit', '', '', NULL, ''); 
     1168INSERT INTO `sys_options` VALUES('track_profile_view', 'on', 1, 'Track all profile views. Later a member can manage these "views".', 'checkbox', '', '', 1, ''); 
     1169INSERT INTO `sys_options` VALUES('transparent1', '0', 16, 'Transparency for first image', 'digit', '', '', 2, ''); 
     1170INSERT INTO `sys_options` VALUES('transparent2', '15', 16, 'Transparency for second image', 'digit', '', '', NULL, ''); 
     1171INSERT INTO `sys_options` VALUES('votes', 'on', 1, 'Enable profile votes', 'checkbox', '', '', 5, ''); 
     1172INSERT INTO `sys_options` VALUES('Water_Mark', '', 16, 'Water Mark', 'text', '', '', 3, ''); 
     1173INSERT INTO `sys_options` VALUES('zodiac', '', 1, 'Show zodiac signs', 'checkbox', '', '', 9, ''); 
     1174INSERT INTO `sys_options` VALUES('php_date_format', 'F j, Y', 15, 'PHP date format', 'digit', '', '', 16, ''); 
     1175INSERT INTO `sys_options` VALUES('group_img_width', '600', 24, 'Gallery max image width', 'digit', '', '', 1, ''); 
     1176INSERT INTO `sys_options` VALUES('group_img_height', '600', 24, 'Gallery max image height', 'digit', '', '', 2, ''); 
     1177INSERT INTO `sys_options` VALUES('group_img_tmb_width', '100', 24, 'Gallery max image thumb width', 'digit', '', '', 3, ''); 
     1178INSERT INTO `sys_options` VALUES('group_img_tmb_height', '100', 24, 'Gallery max image thumb height', 'digit', '', '', 4, ''); 
     1179INSERT INTO `sys_options` VALUES('group_invitation_text', '<b>{sender}</b> has invited you to join <b>{group}</b>.<br />\r\nGroups allow users to communicate on the forums on interesting topics, share pictures, etc.<br />\r\nYou may accept or reject this invitation below:<br />\r\n<b>{accept} &nbsp; &nbsp; &nbsp; {reject}</b>', 24, 'Group invitation text', 'text', '', '', 5, ''); 
     1180INSERT INTO `sys_options` VALUES('group_approve_notify', 'The creator of the {group} allows you to join the group.<br />\r\nNow you''re an active member of this group and you can share your opinion, post images and communicate on message boards.\r\n', 24, 'Group member approve notification', 'text', '', '', 6, ''); 
     1181INSERT INTO `sys_options` VALUES('group_creator_request', 'Hello, {creator}.<br />\r\nMember {member} would like to join your group {group}.<br />\r\nYou may approve or reject this join request below:<br />\r\n{approve} &nbsp; &nbsp; &nbsp; {reject}', 24, 'Request message to group creator', 'text', '', '', 8, ''); 
     1182INSERT INTO `sys_options` VALUES('group_reject_notify', 'Dear {member},<br />\r\nSorry but the creator of the group {group} doesn''t allow you to join the group. If you wish try again later.\r\n', 24, 'Group member reject notification', 'text', '', '', 7, ''); 
     1183INSERT INTO `sys_options` VALUES('tags_non_parsable', 'hi, hey, hello, all, i, i''m, i''d, am, for, in, to, a, the, on, it''s, is, my, of, are, from, i''m, me, you, and, we, not, will, at, where, there', 25, 'Non-parsable tags (type all tags in lower case, delimit them by comma)', 'text', '', '', 0, ''); 
     1184INSERT INTO `sys_options` VALUES('tags_last_parse_time', '0', 0, 'Temporary value when tags cron-job was runed last time', 'digit', '', '', NULL, ''); 
     1185INSERT INTO `sys_options` VALUES('tags_min_rating', '2', 25, 'Minimum rating of tag to show it', 'digit', '', '', 2, ''); 
     1186INSERT INTO `sys_options` VALUES('autoApproval_ifNoConfEmail', 'on', 6, 'Automatic profile confirmation without Confirmation Email', 'checkbox', '', '', NULL, ''); 
     1187INSERT INTO `sys_options` VALUES('enable_flash_promo', 'on', 0, '', 'checkbox', '', '', NULL, ''); 
     1188INSERT INTO `sys_options` VALUES('custom_promo_code', '', 0, '', 'text', '', '', NULL, ''); 
     1189INSERT INTO `sys_options` VALUES('license_code', '', 1, 'Dolphin License Code', 'digit', '', '', 0, ''); 
     1190INSERT INTO `sys_options` VALUES('enable_dolphin_footer', 'on', 0, 'enable boonex footers', 'checkbox', '', '', NULL, ''); 
     1191INSERT INTO `sys_options` VALUES('enable_ray_footer', 'on', 0, 'enable boonex footers', 'checkbox', '', '', NULL, ''); 
     1192-- INSERT INTO `sys_options` VALUES('topmenu_items_perline', '0', 15, 'Number of items per line in top menu. 0 - no breaking.', 'digit', '', '', 20, ''); 
     1193INSERT INTO `sys_options` VALUES('enable_modrewrite', 'on', 26, 'Enable friendly profile permalinks', 'checkbox', '', '', 1, ''); 
     1194INSERT INTO `sys_options` VALUES('permalinks_groups', 'on', 26, 'Enable friendly groups permalinks', 'checkbox', '', '', 10, ''); 
     1195INSERT INTO `sys_options` VALUES('cupid_last_cron', '0', 0, 'Temporary value when cupid mails checked was runed last time', 'text', '', '', NULL, ''); 
     1196INSERT INTO `sys_options` VALUES('reg_by_inv_only', '', 3, 'Registration by invitation only (need before Enable affiliate support)', 'checkbox', '', '', 13, ''); 
     1197INSERT INTO `sys_options` VALUES('main_div_width', '960px', 0, 'Width of the main container of the site', 'digit', '', '', 0, ''); 
     1198INSERT INTO `sys_options` VALUES('promoWidth', '960', 0, 'Default Width of the Promo Images for resizing', 'digit', '', '', 0, ''); 
     1199INSERT INTO `sys_options` VALUES('profile_gallery_feature', '', 3, 'New Gallery Feature for Shared Photos', 'checkbox', '', '', NULL, ''); 
     1200INSERT INTO `sys_options` VALUES('boonexAffID', '', 1, 'My BoonEx Affiliate ID', 'digit', '', '', 0.5, ''); 
     1201INSERT INTO `sys_options` VALUES('ipBlacklistMode', '1', 3, 'IP Blacklist system mode (1 - total block, 2 - login block)', 'digit', '', '', NULL, ''); 
     1202INSERT INTO `sys_options` VALUES('ipListGlobalType', '3', 3, 'IP List Type (1 - all allowed except listed, 2 - all blocked except listed, 0 - disabled)', 'digit', '', '', NULL, ''); 
     1203INSERT INTO `sys_options` VALUES('enable_member_store_ip', 'on', 3, 'When a member login into dolphin 6 that the IP address from that person will be saved into the database', 'checkbox', '', '', NULL, ''); 
     1204INSERT INTO `sys_options` VALUES('site_email', 'xxx@gmail.com', 50, 'Site Email', 'digit', '', '', NULL, ''); 
     1205INSERT INTO `sys_options` VALUES('site_title', 'Unite Community', 50, 'Site Title', 'digit', '', '', NULL, ''); 
     1206INSERT INTO `sys_options` VALUES('site_email_notify', 'xxx2@gmail.com', 50, 'Site Email Notify', 'digit', '', '', NULL, ''); 
     1207INSERT INTO `sys_options` VALUES('enable_html_in_comments', 'on', 3, 'Enable HTML in comments', 'checkbox', '', '', NULL, ''); 
     1208INSERT INTO `sys_options` VALUES('enable_tiny_in_comments', '', 3, 'Enable TinyMCS in comments', 'checkbox', '', '', NULL, ''); 
     1209INSERT INTO `sys_options` VALUES('enable_global_couple', 'on', 3, 'Global Enabling of Couples', 'checkbox', '', '', NULL, ''); 
     1210INSERT INTO `sys_options` VALUES('enable_new_dhtml_popups', 'on', 3, 'Enable new DHTML notifications rather than popup', 'checkbox', '', '', NULL, ''); 
     1211INSERT INTO `sys_options` VALUES('dbCleanAlert', '2', 3, 'Clean old user alerts', 'digit', '', '', 5, ''); 
     1212INSERT INTO `sys_options` VALUES('galleryFiles_user', '2', 23, 'Number of gallery files relate to user', 'digit', '', '', 21, ''); 
     1213INSERT INTO `sys_options` VALUES('galleryFiles_keyword', '2', 23, 'Number of related gallery files', 'digit', '', '', 22, ''); 
     1214INSERT INTO `sys_options` VALUES('enable_cache_system', 'on', 3, 'Enable caching system to store profiles information', 'checkbox', '', '', NULL, ''); 
     1215INSERT INTO `sys_options` VALUES('nav_menu_elements_on_line', '12', 3, 'The number of elements in the navigation menu which will be desplayed before the More link (line)', 'digit', '', '', 15, ''); 
     1216INSERT INTO `sys_options` VALUES('ext_nav_menu_on_line_bottom', '11', 3, 'The number of elements in the additional members menu which will be desplayed (in bottom position )', 'digit', '', '', 17, ''); 
     1217INSERT INTO `sys_options` VALUES('enable_guest_comments', '', 3, 'enable possibility to post comments by guests', 'checkbox', '', '', NULL, ''); 
     1218INSERT INTO `sys_options` VALUES('permalinks_browse', 'on', 26, 'Enable friendly browse permalinks', 'checkbox', '', '', 12, ''); 
     1219INSERT INTO `sys_options` VALUES('sys_ntns_ajax_mode', 'on', 1, 'Enable Ajax mode for Notifications', 'checkbox', '', '', 23, ''); 
     1220INSERT INTO `sys_options` VALUES('sys_ntns_update_interval', '10', 1, 'Notification''s update interval in seconds(for Ajax mode only)', 'digit', '', '', 24, ''); 
     1221INSERT INTO `sys_options` VALUES('sys_ntns_expiration_time', '30', 1, 'Notification''s expiration time in minutes', 'digit', '', '', 25, ''); 
     1222INSERT INTO `sys_options` VALUES('sys_ntns_display_number', '3', 1, 'Notification''s display number', 'digit', '', '', 26, ''); 
     1223INSERT INTO `sys_options` VALUES('promo_relocation_link_visitor', 'join.php', 3, 'Default relocation link to Promo for non-members', 'text', '', '', NULL, ''); 
     1224INSERT INTO `sys_options` VALUES('promo_relocation_link_member', 'member.php', 3, 'Default relocation link to Promo for members', 'text', '', '', NULL, ''); 
     1225INSERT INTO `sys_options` VALUES('leaders_male_types', 'year,month,week,day', 3, 'Period types of leaders for male', 'select', '', '', NULL, 'year,month,week,day'); 
     1226INSERT INTO `sys_options` VALUES('leaders_female_types', 'year,month,week,day', 3, 'Period types of leaders for female', 'select', '', '', NULL, 'year,month,week,day'); 
     1227INSERT INTO `sys_options` VALUES('useLikeOperator', '', 15, 'Use operator LIKE for search (recommended for small content)', 'checkbox', '', '', 21, ''); 
     1228INSERT INTO `sys_options` VALUES('ext_nav_menu_top_position', 'bottom', 15, 'Member menu position', 'combobox', 'return strlen($arg0) > 0;', 'cannot be empty.', 16, 'top,bottom,static'); 
     1229INSERT INTO `sys_options` VALUES('sys_ps_enabled_group_2', 'on', 9, 'Enable \'All\' group', 'checkbox', '', '', 1, ''); 
     1230INSERT INTO `sys_options` VALUES('sys_ps_enabled_group_3', 'on', 9, 'Enable \'Friends\' group', 'checkbox', '', '', 2, ''); 
     1231INSERT INTO `sys_options` VALUES('sys_ps_enabled_group_4', 'on', 9, 'Enable \'Faves\' group', 'checkbox', '', '', 3, ''); 
     1232INSERT INTO `sys_options` VALUES('sys_ps_enabled_group_5', 'on', 9, 'Enable \'Contacts\' group', 'checkbox', '', '', 4, ''); 
     1233INSERT INTO `sys_options` VALUES('sys_make_album_cover_last', 'on', 1, 'Set last object as cover of album', 'checkbox', '', '', 20, ''); 
     1234INSERT INTO `sys_options` VALUES('sys_album_auto_app', 'on', 1, 'Autoapproval for albums', 'checkbox', '', '', 21, ''); 
     1235INSERT INTO `sys_options` VALUES('sys_album_default_name', 'Unsorted', 0, 'Default album name', 'text', '', '', 22, ''); 
    12361236 
    12371237-- -------------------------------------------------------- 
    … …  
    20502050-- 
    20512051 
    2052  
    2053 -- -------------------------------------------------------- 
    2054  
    2055 -- 
    2056 -- Table structure for table `Modules` 
    2057 -- 
    2058  
    2059 CREATE TABLE `Modules` ( 
    2060   `ID` tinyint(4) unsigned NOT NULL auto_increment, 
    2061   `Name` varchar(32) NOT NULL default '', 
    2062   `Conf` mediumtext NOT NULL, 
    2063   `FuncAdd` mediumtext NOT NULL, 
    2064   `FuncDel` mediumtext NOT NULL, 
    2065   `FuncUpdate` mediumtext NOT NULL, 
    2066   `FuncBlock` mediumtext NOT NULL, 
    2067   `FuncUnblock` mediumtext NOT NULL, 
    2068   `Help` mediumtext NOT NULL, 
    2069   `LogIn` mediumtext NOT NULL, 
    2070   `Type` enum('chat','forum') NOT NULL default 'chat', 
    2071   `ReadableName` varchar(15) NOT NULL default '', 
    2072   PRIMARY KEY  (`ID`), 
    2073   UNIQUE KEY `Name` (`Name`) 
    2074 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    2075  
    2076 -- 
    2077 -- Dumping data for table `Modules` 
    2078 -- 
    2079  
    2080  
    20812052-- -------------------------------------------------------- 
    20822053 
    … …  
    21242095 
    21252096-- 
    2126 -- Table structure for table `sys_mass_messages` 
    2127 -- 
    2128  
    2129 CREATE TABLE `sys_mass_messages` ( 
     2097-- Table structure for table `sys_mail_mass_messages` 
     2098-- 
     2099 
     2100CREATE TABLE `sys_mail_mass_messages` ( 
    21302101  `ID` int(10) unsigned NOT NULL auto_increment, 
    21312102  `Subj` varchar(128) NOT NULL default '', 
    … …  
    21362107 
    21372108-- 
    2138 -- Dumping data for table `sys_mass_messages` 
     2109-- Dumping data for table `sys_mail_mass_messages` 
    21392110-- 
    21402111 

  • trunk/modules/boonex/ads/install/sql/install.sql

    r9970 r9972  
    219219INSERT INTO `sys_objects_cmts` (`ID`, `ObjectName`, `TableCmts`, `TableTrack`, `AllowTags`, `Nl2br`, `SecToEdit`, `PerView`, `IsRatable`, `ViewingThreshold`, `AnimationEffect`, `AnimationSpeed`, `IsOn`, `IsMood`, `RootStylePrefix`, `TriggerTable`, `TriggerFieldId`, `TriggerFieldComments`, `ClassName`, `ClassFile`) VALUES(NULL, 'classifieds', 'CmtsClassifieds', 'sys_cmts_track', 0, 1, 90, 5, 1, -3, 'slide', 2000, 1, 1, 'cmt', 'ClassifiedsAdvertisements', 'ID', 'CommentsCount', '', ''); 
    220220 
    221 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('a_max_live_days_classifieds', '30', 3, 'How long can Classifieds live (days)', 'digit', '', '', NULL); 
    222 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('enable_paid_system', 'on', 3, 'Enable Ability to work with Buy Now button in Classifieds', 'checkbox', '', '', NULL); 
    223 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('autoApproval_Classifieds', 'on', 3, 'Automatic advertisements activation after adding', 'checkbox', '', '', NULL); 
    224 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('permalinks_ads', '', 26, 'Enable friendly classifieds permalinks', 'checkbox', '', '', NULL); 
     221INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('a_max_live_days_classifieds', '30', 3, 'How long can Classifieds live (days)', 'digit', '', '', NULL); 
     222INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('enable_paid_system', 'on', 3, 'Enable Ability to work with Buy Now button in Classifieds', 'checkbox', '', '', NULL); 
     223INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('autoApproval_Classifieds', 'on', 3, 'Automatic advertisements activation after adding', 'checkbox', '', '', NULL); 
     224INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('permalinks_ads', '', 26, 'Enable friendly classifieds permalinks', 'checkbox', '', '', NULL); 
    225225 
    226226SELECT @iPCPOrder:=MAX(`Order`) FROM `PageComposePages`; 
    … …  
    264264INSERT INTO `VoteObjects` (`ID`, `ObjectName`, `TableRating`, `TableTrack`, `RowPrefix`, `MaxVotes`, `PostName`, `IsDuplicate`, `IsOn`, `className`, `classFile`, `TriggerTable`, `TriggerFieldRate`, `TriggerFieldRateCount`, `TriggerFieldId`, `OverrideClassName`, `OverrideClassFile`) VALUES(NULL, 'ads', 'classifieds_rating', 'classifieds_voting_track', 'ads_', 5, 'vote_send_result', 'BX_PERIOD_PER_VOTE', 1, '', '', 'ClassifiedsAdvertisements', 'Rate', 'RateCount', 'ID', '', ''); 
    265265 
    266 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('permalinks_module_ads', 'on', 26, 'Enable friendly ads permalink', 'checkbox', '', '', 0); 
     266INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('permalinks_module_ads', 'on', 26, 'Enable friendly ads permalink', 'checkbox', '', '', 0); 
    267267-- INSERT INTO `sys_permalinks`(`standard`, `permalink`, `check`) VALUES('modules/?r=ads/', 'm/ads/', 'permalinks_module_ads'); 
    268268 

  • trunk/modules/boonex/ads/install/sql/uninstall.sql

    r9970 r9972  
    1313DELETE FROM `sys_objects_cmts` WHERE `TableCmts`='CmtsClassifieds'; 
    1414 
    15 DELETE FROM `GlParams` WHERE `Name` = 'a_max_live_days_classifieds'; 
    16 DELETE FROM `GlParams` WHERE `Name` = 'enable_paid_system'; 
    17 DELETE FROM `GlParams` WHERE `Name` = 'autoApproval_Classifieds'; 
    18 DELETE FROM `GlParams` WHERE `Name` = 'permalinks_ads'; 
     15DELETE FROM `sys_options` WHERE `Name` = 'a_max_live_days_classifieds'; 
     16DELETE FROM `sys_options` WHERE `Name` = 'enable_paid_system'; 
     17DELETE FROM `sys_options` WHERE `Name` = 'autoApproval_Classifieds'; 
     18DELETE FROM `sys_options` WHERE `Name` = 'permalinks_ads'; 
    1919 
    2020DELETE FROM `PageComposePages` WHERE `Name`='ads' AND `Title`='Ads'; 
    … …  
    5454DELETE FROM `VoteObjects` WHERE `ObjectName`='ads' AND `TableRating`='classifieds_rating'; 
    5555 
    56 DELETE FROM `GlParams` WHERE `Name` = 'permalinks_module_ads'; 
     56DELETE FROM `sys_options` WHERE `Name` = 'permalinks_module_ads'; 
    5757 
    5858-- DELETE FROM `sys_permalinks` WHERE `check` = 'permalinks_module_ads'; 

  • trunk/modules/boonex/avatar/install/sql/install.sql

    r9969 r9972  
    2323INSERT INTO `sys_options_cats` (`name`, `menu_order`) VALUES ('Avatar', @iMaxOrder); 
    2424SET @iCategId = (SELECT LAST_INSERT_ID()); 
    25 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`) VALUES 
     25INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`) VALUES 
    2626('bx_avatar_permalinks', 'on', @iCategId, 'Enable friendly permalinks in avatars', 'checkbox', '', '', '0', ''), 
    2727('bx_avatar_quality', '85', @iCategId, 'JPEG quality of avatars (1-100)', 'digit', '', '', '0', ''), 

  • trunk/modules/boonex/avatar/install/sql/uninstall.sql

    r9969 r9972  
    1515-- settings 
    1616SET @iCategId = (SELECT `ID` FROM `sys_options_cats` WHERE `name` = 'Avatar'); 
    17 DELETE FROM `GlParams` WHERE `kateg` = @iCategId; 
     17DELETE FROM `sys_options` WHERE `kateg` = @iCategId; 
    1818DELETE FROM `sys_options_cats` WHERE `ID` = @iCategId; 
    1919 

  • trunk/modules/boonex/blogs/install/sql/install.sql

    r9970 r9972  
    145145INSERT INTO `sys_options_cats` VALUES(NULL, 'Blogs', 9); 
    146146SET @iGlCategID = LAST_INSERT_ID(); 
    147 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('blogCategoryCaptionMaxLenght', '150', @iGlCategID, 'Maximum length of Blog Category caption', 'digit', '', '', 3); 
    148 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('blogCommentMaxLenght', '250', @iGlCategID, 'Maximum length of Blog comment', 'digit', '', '', 2); 
    149 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('blogAutoApproval', 'on', @iGlCategID, 'Enable AutoApproval of Blogs', 'checkbox', '', '', 7); 
    150 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('blog_step', '10', @iGlCategID, 'How many blogs showing on page', 'digit', '', '', 15); 
    151 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('max_blogs_on_home', '3', @iGlCategID, 'Maximum number of Blogs to show on homepage', 'digit', '', '', 2); 
    152 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('max_blog_preview', '256', @iGlCategID, 'Maximum length of Blog preview', 'digit', '', '', 3); 
    153 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('permalinks_blogs', '', 26, 'Enable friendly blogs permalinks', 'checkbox', '', '', 4); 
    154 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('bx_blogs_enabled', 'on', @iGlCategID, 'Enable Boonex Blogs module', 'checkbox', '', '', 4); 
    155 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('blogCaptionMaxLenght', '150', @iGlCategID, 'Maximum length of Blog Caption', 'digit', '', '', 5); 
    156 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('category_auto_app_blogs', 'on', @iGlCategID, 'Autoapprove categories of blog posts', 'checkbox', '', '', 6); 
     147INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('blogCategoryCaptionMaxLenght', '150', @iGlCategID, 'Maximum length of Blog Category caption', 'digit', '', '', 3); 
     148INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('blogCommentMaxLenght', '250', @iGlCategID, 'Maximum length of Blog comment', 'digit', '', '', 2); 
     149INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('blogAutoApproval', 'on', @iGlCategID, 'Enable AutoApproval of Blogs', 'checkbox', '', '', 7); 
     150INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('blog_step', '10', @iGlCategID, 'How many blogs showing on page', 'digit', '', '', 15); 
     151INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('max_blogs_on_home', '3', @iGlCategID, 'Maximum number of Blogs to show on homepage', 'digit', '', '', 2); 
     152INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('max_blog_preview', '256', @iGlCategID, 'Maximum length of Blog preview', 'digit', '', '', 3); 
     153INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('permalinks_blogs', '', 26, 'Enable friendly blogs permalinks', 'checkbox', '', '', 4); 
     154INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('bx_blogs_enabled', 'on', @iGlCategID, 'Enable Boonex Blogs module', 'checkbox', '', '', 4); 
     155INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('blogCaptionMaxLenght', '150', @iGlCategID, 'Maximum length of Blog Caption', 'digit', '', '', 5); 
     156INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('category_auto_app_blogs', 'on', @iGlCategID, 'Autoapprove categories of blog posts', 'checkbox', '', '', 6); 
    157157 
    158158INSERT INTO `PageCompose` (`ID`, `Page`, `PageWidth`, `Desc`, `Caption`, `Column`, `Order`, `Func`, `Content`, `DesignBox`, `ColWidth`, `Visible`, `MinWidth`) VALUES(NULL, 'index', '960px', 'Recently posted blogs', '_Blogs', 1, 4, 'PHP', 'return BxDolService::call(''blogs'', ''blogs_index_page'');', 1, 70, 'non,memb', 0); 
    … …  
    198198ALTER TABLE `[db_prefix]_posts` ADD FULLTEXT (`PostCaption`, `PostText`, `Tags`); 
    199199 
    200 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('permalinks_module_blogs', 'on', 26, 'Enable friendly blogs permalink', 'checkbox', '', '', 0); 
     200INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('permalinks_module_blogs', 'on', 26, 'Enable friendly blogs permalink', 'checkbox', '', '', 0); 
    201201 
    202202INSERT INTO `sys_permalinks`(`standard`, `permalink`, `check`) VALUES('modules/boonex/blogs/blogs.php', 'blogs/', 'permalinks_module_blogs'); 

  • trunk/modules/boonex/blogs/install/sql/uninstall.sql

    r9970 r9972  
    1818DELETE FROM `sys_objects_cmts` WHERE `TableCmts`='[db_prefix]_cmts'; 
    1919 
    20 DELETE FROM `GlParams` WHERE `Name` = 'blogCaptionMaxLenght'; 
    21 DELETE FROM `GlParams` WHERE `Name` = 'blogCategoryCaptionMaxLenght'; 
    22 DELETE FROM `GlParams` WHERE `Name` = 'blogCommentMaxLenght'; 
    23 DELETE FROM `GlParams` WHERE `Name` = 'blogAutoApproval'; 
    24 DELETE FROM `GlParams` WHERE `Name` = 'blog_step'; 
    25 DELETE FROM `GlParams` WHERE `Name` = 'max_blogs_on_home'; 
    26 DELETE FROM `GlParams` WHERE `Name` = 'max_blog_preview'; 
    27 DELETE FROM `GlParams` WHERE `Name` = 'permalinks_blogs'; 
    28 DELETE FROM `GlParams` WHERE `Name` = 'bx_blogs_enabled'; 
    29 DELETE FROM `GlParams` WHERE `Name` = 'category_auto_app_blogs'; 
     20DELETE FROM `sys_options` WHERE `Name` = 'blogCaptionMaxLenght'; 
     21DELETE FROM `sys_options` WHERE `Name` = 'blogCategoryCaptionMaxLenght'; 
     22DELETE FROM `sys_options` WHERE `Name` = 'blogCommentMaxLenght'; 
     23DELETE FROM `sys_options` WHERE `Name` = 'blogAutoApproval'; 
     24DELETE FROM `sys_options` WHERE `Name` = 'blog_step'; 
     25DELETE FROM `sys_options` WHERE `Name` = 'max_blogs_on_home'; 
     26DELETE FROM `sys_options` WHERE `Name` = 'max_blog_preview'; 
     27DELETE FROM `sys_options` WHERE `Name` = 'permalinks_blogs'; 
     28DELETE FROM `sys_options` WHERE `Name` = 'bx_blogs_enabled'; 
     29DELETE FROM `sys_options` WHERE `Name` = 'category_auto_app_blogs'; 
    3030 
    3131DELETE FROM `sys_options_cats` WHERE `name` = 'Blogs'; 
    … …  
    5959DELETE FROM `VoteObjects` WHERE `ObjectName`='blogposts' AND `TableRating`='[db_prefix]_rating'; 
    6060 
    61 DELETE FROM `GlParams` WHERE `Name` = 'permalinks_module_blogs'; 
     61DELETE FROM `sys_options` WHERE `Name` = 'permalinks_module_blogs'; 
    6262DELETE FROM `sys_permalinks` WHERE `permalink` = 'blogs/'; 
    6363DELETE FROM `sys_permalinks` WHERE `permalink` = 'blogs/top/'; 

  • trunk/modules/boonex/board/install/sql/install.sql

    r9970 r9972  
    1313INSERT INTO `sys_permalinks`(`standard`, `permalink`, `check`) VALUES('modules/?r=board/', 'm/board/', 'permalinks_module_board'); 
    1414 
    15 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('permalinks_module_board', 'on', 26, 'Enable friendly board permalink', 'checkbox', '', '', 0); 
     15INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('permalinks_module_board', 'on', 26, 'Enable friendly board permalink', 'checkbox', '', '', 0); 
    1616 
    1717INSERT INTO `Categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Board', 0, 'shared_photo', 0, 'active'); 

  • trunk/modules/boonex/board/install/sql/uninstall.sql

    r9970 r9972  
    66DELETE FROM `sys_permalinks` WHERE `check`='permalinks_module_board'; 
    77 
    8 DELETE FROM `GlParams` WHERE `Name`='permalinks_module_board'; 
     8DELETE FROM `sys_options` WHERE `Name`='permalinks_module_board'; 
    99 
    1010DELETE FROM `Categories` WHERE `Category`='Board' AND `Type`='shared_photo' AND `Owner`=0; 

  • trunk/modules/boonex/chat/install/sql/install.sql

    r9969 r9972  
    1313INSERT INTO `sys_permalinks`(`standard`, `permalink`, `check`) VALUES('modules/?r=chat/', 'm/chat/', 'permalinks_module_chat'); 
    1414 
    15 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('permalinks_module_chat', 'on', 26, 'Enable friendly chat permalink', 'checkbox', '', '', 0); 
     15INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('permalinks_module_chat', 'on', 26, 'Enable friendly chat permalink', 'checkbox', '', '', 0); 

  • trunk/modules/boonex/chat/install/sql/uninstall.sql

    r9969 r9972  
    66DELETE FROM `sys_permalinks` WHERE `check`='permalinks_module_chat'; 
    77 
    8 DELETE FROM `GlParams` WHERE `Name`='permalinks_module_chat'; 
     8DELETE FROM `sys_options` WHERE `Name`='permalinks_module_chat'; 

  • trunk/modules/boonex/custom_rss/install/sql/install.sql

    r9968 r9972  
    3232INSERT INTO `sys_options_cats` VALUES(NULL, 'Custom RSS', @iGPKOrder+1); 
    3333SET @iGlCategID = LAST_INSERT_ID(); 
    34 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('enable_crss_module', 'on', @iGlCategID, 'Enable Custom RSS Module', 'checkbox', '', '', NULL); 
    35 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('crss_AutoApprove_RSS', 'on', @iGlCategID, 'Autoapprove Custom RSS of Custom RSS Module', 'checkbox', '', '', NULL); 
     34INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('enable_crss_module', 'on', @iGlCategID, 'Enable Custom RSS Module', 'checkbox', '', '', NULL); 
     35INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('crss_AutoApprove_RSS', 'on', @iGlCategID, 'Autoapprove Custom RSS of Custom RSS Module', 'checkbox', '', '', NULL); 
    3636 
    3737SELECT @PageKey1 := MAX(`Order`) FROM `PageCompose` WHERE `Page` = 'profile' AND `Column`=2; 

  • trunk/modules/boonex/custom_rss/install/sql/uninstall.sql

    r9968 r9972  
    1111DELETE FROM `sys_options_cats` WHERE `name` = 'Custom RSS'; 
    1212 
    13 DELETE FROM `GlParams` WHERE `Name` = 'enable_crss_module'; 
    14 DELETE FROM `GlParams` WHERE `Name` = 'crss_AutoApprove_RSS'; 
     13DELETE FROM `sys_options` WHERE `Name` = 'enable_crss_module'; 
     14DELETE FROM `sys_options` WHERE `Name` = 'crss_AutoApprove_RSS'; 
    1515 
    1616DELETE FROM `PageCompose` WHERE `Caption`='_crss_Custom_Feeds' AND `Func`='PHP'; 

  • trunk/modules/boonex/events/install/sql/install.sql

    r9970 r9972  
    124124INSERT INTO `sys_options_cats` (`name`, `menu_order`) VALUES ('Events', @iMaxOrder); 
    125125SET @iCategId = (SELECT LAST_INSERT_ID()); 
    126 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`) VALUES 
     126INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`) VALUES 
    127127('bx_events_permalinks', 'on', @iCategId, 'Enable friendly permalinks in events', 'checkbox', '', '', '0', ''), 
    128128('bx_events_autoapproval', 'on', @iCategId, 'Activate all events after creation automatically', 'checkbox', '', '', '0', ''), 

  • trunk/modules/boonex/events/install/sql/uninstall.sql

    r9970 r9972  
    4848-- settings 
    4949SET @iCategId = (SELECT `ID` FROM `sys_options_cats` WHERE `name` = 'Events'); 
    50 DELETE FROM `GlParams` WHERE `kateg` = @iCategId; 
     50DELETE FROM `sys_options` WHERE `kateg` = @iCategId; 
    5151DELETE FROM `sys_options_cats` WHERE `ID` = @iCategId; 
    5252 

  • trunk/modules/boonex/feedback/install/sql/install.sql

    r9968 r9972  
    9090 
    9191 
    92 SET @iCategoryId = (SELECT MAX(`kateg`) FROM `GlParams`) + 1; 
     92SET @iCategoryId = (SELECT MAX(`kateg`) FROM `sys_options`) + 1; 
    9393SET @iCategoryOrder = (SELECT MAX(`menu_order`) FROM `sys_options_cats`) + 1; 
    9494INSERT INTO `sys_options_cats` (`ID`, `name` , `menu_order` ) VALUES (@iCategoryId, 'Feedback', @iCategoryOrder); 
    9595 
    96 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES 
     96INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES 
    9797('permalinks_module_feedback', 'on', 26, 'Enable friendly feedback permalink', 'checkbox', '', '', 0), 
    9898('feedback_autoapprove', 'on', @iCategoryId, 'Enable autoapprove for members feedback', 'checkbox', '', '', 0), 

  • trunk/modules/boonex/feedback/install/sql/uninstall.sql

    r9968 r9972  
    1313SET @iCategoryId = (SELECT `ID` FROM `sys_options_cats` WHERE `name`='Feedback' LIMIT 1); 
    1414DELETE FROM `sys_options_cats` WHERE `name`='Feedback' LIMIT 1; 
    15 DELETE FROM `GlParams` WHERE `kateg`=@iCategoryId OR `Name`='permalinks_module_feedback'; 
     15DELETE FROM `sys_options` WHERE `kateg`=@iCategoryId OR `Name`='permalinks_module_feedback'; 
    1616 
    1717 

  • trunk/modules/boonex/google_search/install/sql/install.sql

    r9968 r9972  
    1717INSERT INTO `sys_options_cats` (`name`, `menu_order`) VALUES ('Google Search', @iMaxOrder); 
    1818SET @iCategId = (SELECT LAST_INSERT_ID()); 
    19 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`) VALUES 
     19INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`) VALUES 
    2020('bx_gsearch_permalinks', 'on', @iCategId, 'Enable friendly permalinks', 'checkbox', '', '', '0', ''), 
    2121('bx_gsearch_block_tabbed', 'on', @iCategId, 'Tabbed search results in block', 'checkbox', '', '', '0', ''), 

  • trunk/modules/boonex/google_search/install/sql/uninstall.sql

    r9968 r9972  
    77 
    88SET @iCategId = (SELECT `ID` FROM `sys_options_cats` WHERE `name` = 'Google Search' LIMIT 1); 
    9 DELETE FROM `GlParams` WHERE `kateg` = @iCategId; 
     9DELETE FROM `sys_options` WHERE `kateg` = @iCategId; 
    1010DELETE FROM `sys_options_cats` WHERE `ID` = @iCategId; 
    1111 

  • trunk/modules/boonex/map_profiles/install/sql/install.sql

    r9969 r9972  
    114114INSERT INTO `sys_options_cats` (`name`, `menu_order`) VALUES ('Profiles Map General', @iMaxOrder); 
    115115SET @iCategId = (SELECT LAST_INSERT_ID()); 
    116 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`) VALUES 
     116INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`) VALUES 
    117117('bx_map_key', '', @iCategId, 'Google Maps API key', 'digit', '', '', '0', ''), 
    118118('bx_map_permalinks', 'on', @iCategId, 'Enable friendly permalinks', 'checkbox', '', '', '0', ''); 
    … …  
    120120INSERT INTO `sys_options_cats` (`name`, `menu_order`) VALUES ('Profiles Map Homepage', @iMaxOrder); 
    121121SET @iCategId = (SELECT LAST_INSERT_ID()); 
    122 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`) VALUES 
     122INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`) VALUES 
    123123('bx_map_homepage_control_type', 'small', @iCategId, 'Map control type', 'combobox', '', '', '0', 'none,small,large'), 
    124124('bx_map_homepage_is_type_control', 'on', @iCategId, 'Display map type controls', 'checkbox', '', '', '0', ''), 
    … …  
    129129INSERT INTO `sys_options_cats` (`name`, `menu_order`) VALUES ('Profiles Map Separate', @iMaxOrder); 
    130130SET @iCategId = (SELECT LAST_INSERT_ID()); 
    131 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`) VALUES 
     131INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`) VALUES 
    132132('bx_map_separate_control_type', 'large', @iCategId, 'Map control type', 'combobox', '', '', '0', 'none,small,large'), 
    133133('bx_map_separate_is_type_control', 'on', @iCategId, 'Display map type controls', 'checkbox', '', '', '0', ''), 
    … …  
    138138INSERT INTO `sys_options_cats` (`name`, `menu_order`) VALUES ('Profiles Map Profile', @iMaxOrder); 
    139139SET @iCategId = (SELECT LAST_INSERT_ID()); 
    140 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`) VALUES 
     140INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`) VALUES 
    141141('bx_map_profile_control_type', 'small', @iCategId, 'Map control type', 'combobox', '', '', '0', 'none,small,large'), 
    142142('bx_map_profile_is_type_control', 'on', @iCategId, 'Display map type controls', 'checkbox', '', '', '0', ''), 
    … …  
    149149INSERT INTO `sys_options_cats` (`name`, `menu_order`) VALUES ('Profiles Map Hidden', @iMaxOrder); 
    150150SET @iCategId = (SELECT LAST_INSERT_ID()); 
    151 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`) VALUES 
     151INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`) VALUES 
    152152 
    153153('bx_map_homepage_lat', '20', @iCategId, 'Homepage map latitude', 'digit', '', '', '0', ''), 

  • trunk/modules/boonex/map_profiles/install/sql/uninstall.sql

    r9969 r9972  
    1616 
    1717SET @iCategId = (SELECT `ID` FROM `sys_options_cats` WHERE `name` = 'Profiles Map General' LIMIT 1); 
    18 DELETE FROM `GlParams` WHERE `kateg` = @iCategId; 
     18DELETE FROM `sys_options` WHERE `kateg` = @iCategId; 
    1919DELETE FROM `sys_options_cats` WHERE `ID` = @iCategId; 
    2020SET @iCategId = (SELECT `ID` FROM `sys_options_cats` WHERE `name` = 'Profiles Map Homepage' LIMIT 1); 
    21 DELETE FROM `GlParams` WHERE `kateg` = @iCategId; 
     21DELETE FROM `sys_options` WHERE `kateg` = @iCategId; 
    2222DELETE FROM `sys_options_cats` WHERE `ID` = @iCategId; 
    2323SET @iCategId = (SELECT `ID` FROM `sys_options_cats` WHERE `name` = 'Profiles Map Separate' LIMIT 1); 
    24 DELETE FROM `GlParams` WHERE `kateg` = @iCategId; 
     24DELETE FROM `sys_options` WHERE `kateg` = @iCategId; 
    2525DELETE FROM `sys_options_cats` WHERE `ID` = @iCategId; 
    2626SET @iCategId = (SELECT `ID` FROM `sys_options_cats` WHERE `name` = 'Profiles Map Profile' LIMIT 1); 
    27 DELETE FROM `GlParams` WHERE `kateg` = @iCategId; 
     27DELETE FROM `sys_options` WHERE `kateg` = @iCategId; 
    2828DELETE FROM `sys_options_cats` WHERE `ID` = @iCategId; 
    2929SET @iCategId = (SELECT `ID` FROM `sys_options_cats` WHERE `name` = 'Profiles Map Hidden' LIMIT 1); 
    30 DELETE FROM `GlParams` WHERE `kateg` = @iCategId; 
     30DELETE FROM `sys_options` WHERE `kateg` = @iCategId; 
    3131DELETE FROM `sys_options_cats` WHERE `ID` = @iCategId; 
    3232 

  • trunk/modules/boonex/news/install/sql/install.sql

    r9968 r9972  
    117117 
    118118 
    119 SET @iCategoryId = (SELECT MAX(`kateg`) FROM `GlParams`) + 1; 
     119SET @iCategoryId = (SELECT MAX(`kateg`) FROM `sys_options`) + 1; 
    120120SET @iCategoryOrder = (SELECT MAX(`menu_order`) FROM `sys_options_cats`) + 1; 
    121121INSERT INTO `sys_options_cats` (`ID`, `name` , `menu_order` ) VALUES (@iCategoryId, 'News', @iCategoryOrder); 
    122122 
    123 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES 
     123INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES 
    124124('permalinks_module_news', 'on', 26, 'Enable friendly news permalink', 'checkbox', '', '', 0), 
    125125('news_comments', 'on', @iCategoryId, 'Allow comments for news', 'checkbox', '', '', 0), 

  • trunk/modules/boonex/news/install/sql/uninstall.sql

    r9968 r9972  
    1515SET @iCategoryId = (SELECT `ID` FROM `sys_options_cats` WHERE `name`='News' LIMIT 1); 
    1616DELETE FROM `sys_options_cats` WHERE `name`='News' LIMIT 1; 
    17 DELETE FROM `GlParams` WHERE `kateg`=@iCategoryId OR `Name`='permalinks_module_news'; 
     17DELETE FROM `sys_options` WHERE `kateg`=@iCategoryId OR `Name`='permalinks_module_news'; 
    1818 
    1919DELETE FROM `sys_objects_cmts` WHERE `ObjectName`='bx_news' LIMIT 1; 

  • trunk/modules/boonex/poll/install/sql/install.sql

    r9970 r9972  
    3737 
    3838-- 
    39 -- GlParams ; 
    40 -- 
    41  
    42 INSERT INTO  
    43     `GlParams`  
     39-- sys_options ; 
     40-- 
     41 
     42INSERT INTO  
     43    `sys_options`  
    4444SET  
    4545    `Name` = 'enable_poll',  
    … …  
    5050 
    5151INSERT INTO  
    52     `GlParams`  
     52    `sys_options`  
    5353SET  
    5454    `Name` = 'profile_poll_num',  
    … …  
    5959 
    6060INSERT INTO  
    61     `GlParams`  
     61    `sys_options`  
    6262SET  
    6363    `Name` = 'profile_page_polls',  
    … …  
    6868 
    6969INSERT INTO  
    70     `GlParams`  
     70    `sys_options`  
    7171SET  
    7272    `Name` = 'index_page_polls',  
    … …  
    7777 
    7878INSERT INTO  
    79     `GlParams`  
     79    `sys_options`  
    8080SET  
    8181    `Name` = 'profile_poll_act',  

  • trunk/modules/boonex/poll/install/sql/uninstall.sql

    r9970 r9972  
    66 
    77-- 
    8 -- sys_options_cats and GlParams ; 
     8-- sys_options_cats and sys_options ; 
    99-- 
    1010 
    1111SELECT @iKatId := `ID` FROM `sys_options_cats` WHERE `name` = 'Polls'; 
    1212DELETE FROM `sys_options_cats` WHERE `name` = 'Polls'; 
    13 DELETE FROM `GlParams` WHERE `kateg` = @iKatId; 
     13DELETE FROM `sys_options` WHERE `kateg` = @iKatId; 
    1414 
    1515-- 

  • trunk/modules/boonex/quotes/install/sql/install.sql

    r9968 r9972  
    3030-- INSERT INTO `sys_options_cats` VALUES(NULL, 'Quotes', 9); 
    3131-- SET @iGlCategID = LAST_INSERT_ID(); 
    32 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES ('enable_daily_quotes', 'on', 3, 'Enable Daily Quotes as pages', 'checkbox', '', '', NULL); 
     32INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES ('enable_daily_quotes', 'on', 3, 'Enable Daily Quotes as pages', 'checkbox', '', '', NULL); 
    3333 
    3434INSERT INTO `sys_injections` (`id`, `name`, `page_index`, `key`, `type`, `data`, `replace`, `active`) VALUES(NULL, 'quotes_injection', 0, 'injection_top', 'php', 'return BxDolService::call("quotes", "get_quote_unit");', 0, 1); 

  • trunk/modules/boonex/quotes/install/sql/uninstall.sql

    r9888 r9972  
    77DROP TABLE IF EXISTS `[db_prefix]units`; 
    88 
    9 DELETE FROM `GlParams` WHERE `Name` = 'enable_daily_quotes'; 
     9DELETE FROM `sys_options` WHERE `Name` = 'enable_daily_quotes'; 
    1010 
    1111DELETE FROM `sys_injections` WHERE `sys_injections`.`name` = 'quotes_injection'; 

  • trunk/modules/boonex/shared_files/install/sql/install.sql

    r9968 r9972  
    7878('text/plain', 'default.png'); 
    7979 
    80 -- GlParams  settings 
     80-- sys_options  settings 
    8181INSERT INTO `sys_options_cats` VALUES(NULL, 'Shared Files', ''); 
    8282SET @iKatID = LAST_INSERT_ID(); 
    8383 
    84 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`)  VALUES 
     84INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`)  VALUES 
    8585('bx_shared_files_all_count', '10', @iKatID, 'How many shared files show on browse page', 'digit', '', '', 1, ''), 
    8686('bx_shared_files_featured_count', '4', @iKatID, 'How many shared files show on featured section', 'digit', '', '', 2, ''), 
    … …  
    135135INSERT INTO `sys_permalinks`(`standard`, `permalink`, `check`) VALUES('modules/?r=shared_files/', 'm/shared_files/', 'permalinks_module_shared_files'); 
    136136 
    137 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('permalinks_module_shared_files', 'on', 26, 'Enable friendly shared files permalink', 'checkbox', '', '', 0); 
     137INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('permalinks_module_shared_files', 'on', 26, 'Enable friendly shared files permalink', 'checkbox', '', '', 0); 
    138138 
    139139INSERT INTO `SearchObjects` (`ObjectName`, `Title`, `ClassName`, `ClassPath`) VALUES 

  • trunk/modules/boonex/shared_files/install/sql/uninstall.sql

    r9968 r9972  
    88SET @iKatID = (SELECT `ID` FROM `sys_options_cats` WHERE `name` = 'Shared Files' LIMIT 1); 
    99 
    10 DELETE FROM `GlParams` WHERE `kateg` = @iKatID; 
     10DELETE FROM `sys_options` WHERE `kateg` = @iKatID; 
    1111 
    1212DELETE FROM `sys_options_cats` WHERE `ID` = @iKatID; 

  • trunk/modules/boonex/shared_music/install/sql/install.sql

    r9970 r9972  
    5454('Christmas songs', 0, 'shared_music', 0, 'active'); 
    5555 
    56 -- GlParams settings 
     56-- sys_options settings 
    5757INSERT INTO `sys_options_cats` VALUES('', 'Shared Music', ''); 
    5858SET @iKatID = LAST_INSERT_ID(); 
    5959 
    60 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES 
     60INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES 
    6161('topMusicMaxNum', '10', @iKatID, 'How many gallery files show on index page in music area', 'digit', '', '', 1), 
    6262('topMusicMode', 'rand', @iKatID, 'Show members on index page<br /> (if enabled in the template)', 'combobox', 'return $arg0 == ''rand'' || $arg0 == ''last'' || $arg0 == ''top'' ? true : false;', 'posible values: rand, last, top', 2), 
    … …  
    7575('maxSharedMusicThumbHeight', '80', @iKatID, 'Max height of gallery music thumb (in pixels)', 'digit', '', '', 17); 
    7676 
    77 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES 
     77INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES 
    7878('permalinks_gallery_music', 'on', 26, 'Enable friendly gallery music permalinks', 'checkbox', '', '', 8); 
    7979 

  • trunk/modules/boonex/shared_music/install/sql/uninstall.sql

    r9970 r9972  
    1111SET @iKatID = (SELECT  `ID` FROM `sys_options_cats` WHERE `name` = 'Shared Music' LIMIT 1); 
    1212 
    13 DELETE FROM `GlParams` WHERE `kateg` = @iKatID; 
     13DELETE FROM `sys_options` WHERE `kateg` = @iKatID; 
    1414 
    15 DELETE FROM `GlParams` WHERE `Name` = 'permalinks_gallery_music' OR `Name` = 'autoApproval_Music'; 
     15DELETE FROM `sys_options` WHERE `Name` = 'permalinks_gallery_music' OR `Name` = 'autoApproval_Music'; 
    1616 
    1717DELETE FROM `sys_options_cats` WHERE `name` = 'Shared Music'; 

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

    r9970 r9972  
    8080('Our cars', 0, 'shared_photo', 0, 'active'); 
    8181 
    82 -- GlParams settings 
     82-- sys_options settings 
    8383INSERT INTO `sys_options_cats` VALUES(NULL, 'Shared Photos', ''); 
    8484SET @iKatID = LAST_INSERT_ID(); 
    8585 
    86 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`)  VALUES 
     86INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`)  VALUES 
    8787('topPhotosMaxNum', '10', @iKatID, 'How many gallery files show on index page in photos area', 'digit', '', '', 1, ''), 
    8888('topPhotosMode', 'rand', @iKatID, 'Show members on index page<br /> (if enabled in the template)', 'combobox', 'return $arg0 == ''rand'' || $arg0 == ''last'' || $arg0 == ''top'' ? true : false;', 'posible values: rand, last, top', 2, ''), 
    … …  
    106106('maxThumbHeight', '64', @iKatID, 'Max width of profile thumbnail (in pixels)', 'digit', '', '', 19, ''); 
    107107 
    108 INSERT INTO `GlParams` VALUES('permalinks_gallery_photos', 'on', 26, 'Enable friendly gallery photos permalinks', 'checkbox', '', '', 0, ''); 
     108INSERT INTO `sys_options` VALUES('permalinks_gallery_photos', 'on', 26, 'Enable friendly gallery photos permalinks', 'checkbox', '', '', 0, ''); 
    109109 
    110110-- PageComposePages for admin builder 

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

    r9970 r9972  
    1111SET @iKatID = (SELECT  `ID` FROM `sys_options_cats` WHERE `name` = 'Shared Photos' LIMIT 1); 
    1212 
    13 DELETE FROM `GlParams` WHERE `kateg` = @iKatID; 
     13DELETE FROM `sys_options` WHERE `kateg` = @iKatID; 
    1414 
    15 DELETE FROM `GlParams` WHERE `Name` = 'permalinks_gallery_photos' OR `Name` = 'autoApproval_Photo'; 
     15DELETE FROM `sys_options` WHERE `Name` = 'permalinks_gallery_photos' OR `Name` = 'autoApproval_Photo'; 
    1616 
    1717DELETE FROM `sys_options_cats` WHERE `name` = 'Shared Photos'; 

  • trunk/modules/boonex/shared_video/install/sql/install.sql

    r9970 r9972  
    5454('About vacations', 0, 'shared_video', 0, 'active'); 
    5555 
    56 -- GlParams settings 
     56-- sys_options settings 
    5757INSERT INTO `sys_options_cats` VALUES('', 'Shared Videos', ''); 
    5858SET @iKatID = LAST_INSERT_ID(); 
    5959 
    60 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES 
     60INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES 
    6161('topVideoMaxNum', '10', @iKatID, 'How many gallery files show on index page in videos area', 'digit', '', '', 1), 
    6262('topVideoMode', 'rand', @iKatID, 'Show members on index page<br /> (if enabled in the template)', 'combobox', 'return $arg0 == ''rand'' || $arg0 == ''last'' || $arg0 == ''top'' ? true : false;', 'posible values: rand, last, top', 2), 
    … …  
    7575('maxSharedVideoThumbHeight', '80', @iKatID, 'Max width of gallery video thumb (in pixels)', 'digit', '', '', 20); 
    7676 
    77 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES 
     77INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES 
    7878('permalinks_gallery_videos', 'on', 26, 'Enable friendly gallery videos permalinks', 'checkbox', '', '', 9); 
    7979 

  • trunk/modules/boonex/shared_video/install/sql/uninstall.sql

    r9970 r9972  
    1111SET @iKatID = (SELECT `ID` FROM `sys_options_cats` WHERE `name` = 'Shared Videos' LIMIT 1); 
    1212 
    13 DELETE FROM `GlParams` WHERE `kateg` = @iKatID; 
     13DELETE FROM `sys_options` WHERE `kateg` = @iKatID; 
    1414 
    15 DELETE FROM `GlParams` WHERE `Name` = 'permalinks_gallery_videos' OR `Name` = 'autoApproval_Videos'; 
    16 DELETE FROM `GlParams` WHERE `Name` = 'category_auto_app_shared_video'; 
     15DELETE FROM `sys_options` WHERE `Name` = 'permalinks_gallery_videos' OR `Name` = 'autoApproval_Videos'; 
     16DELETE FROM `sys_options` WHERE `Name` = 'category_auto_app_shared_video'; 
    1717 
    1818DELETE FROM `sys_options_cats` WHERE `name` = 'Shared Videos'; 

  • trunk/modules/boonex/sites/install/sql/install.sql

    r9970 r9972  
    105105INSERT INTO `sys_permalinks`(`standard`, `permalink`, `check`) VALUES('modules/?r=sites/', 'm/sites/', 'permalinks_module_sites'); 
    106106 
    107 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('permalinks_module_sites', 'on', 26, 'Enable friendly sites permalink', 'checkbox', '', '', 0); 
     107INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('permalinks_module_sites', 'on', 26, 'Enable friendly sites permalink', 'checkbox', '', '', 0); 
    108108 
    109109-- page compose 

  • trunk/modules/boonex/sites/install/sql/uninstall.sql

    r9970 r9972  
    1313DELETE FROM `sys_permalinks` WHERE `check`='permalinks_module_sites'; 
    1414 
    15 DELETE FROM `GlParams` WHERE `Name`='permalinks_module_sites'; 
     15DELETE FROM `sys_options` WHERE `Name`='permalinks_module_sites'; 
    1616 
    1717DELETE FROM `PageComposePages` WHERE `Name` = 'bx_sites_main' OR `Name` = 'bx_sites_profile' OR `Name` = 'bx_sites_view'; 

  • trunk/modules/boonex/store/install/sql/install.sql

    r9970 r9972  
    102102INSERT INTO `sys_options_cats` (`name`, `menu_order`) VALUES ('Store', @iMaxOrder); 
    103103SET @iCategId = (SELECT LAST_INSERT_ID()); 
    104 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`) VALUES 
     104INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`) VALUES 
    105105('bx_store_permalinks', 'on', @iCategId, 'Enable friendly permalinks in store', 'checkbox', '', '', '0', ''), 
    106106('bx_store_autoapproval', 'on', @iCategId, 'Activate all products after creation automatically', 'checkbox', '', '', '0', ''), 

  • trunk/modules/boonex/store/install/sql/uninstall.sql

    r9970 r9972  
    4444-- settings 
    4545SET @iCategId = (SELECT `ID` FROM `sys_options_cats` WHERE `name` = 'Store'); 
    46 DELETE FROM `GlParams` WHERE `kateg` = @iCategId; 
     46DELETE FROM `sys_options` WHERE `kateg` = @iCategId; 
    4747DELETE FROM `sys_options_cats` WHERE `ID` = @iCategId; 
    4848 

  • trunk/modules/boonex/wall/install/sql/install.sql

    r9969 r9972  
    8383 
    8484 
    85 SET @iCategoryId = (SELECT `kateg` FROM `GlParams` ORDER BY `kateg` DESC LIMIT 1) + 1; 
     85SET @iCategoryId = (SELECT `kateg` FROM `sys_options` ORDER BY `kateg` DESC LIMIT 1) + 1; 
    8686SET @iCategoryOrder = (SELECT `menu_order` FROM `sys_options_cats` ORDER BY `menu_order` DESC LIMIT 1); 
    8787INSERT INTO `sys_options_cats` (`ID`, `name` , `menu_order` ) VALUES (@iCategoryId, 'Wall', @iCategoryOrder); 
    8888 
    89 INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES 
     89INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES 
    9090('permalinks_module_wall', 'on', 26, 'Enable friendly wall permalink', 'checkbox', '', '', 0), 
    9191('wall_enable_guest_comments', '', @iCategoryId, 'Allow non-members to post in wall', 'checkbox', '', '', 0), 

  • trunk/modules/boonex/wall/install/sql/uninstall.sql

    r9969 r9972  
    1313SET @iCategoryId = (SELECT `ID` FROM `sys_options_cats` WHERE `name`='Wall' LIMIT 1); 
    1414DELETE FROM `sys_options_cats` WHERE `name`='Wall' LIMIT 1; 
    15 DELETE FROM `GlParams` WHERE `kateg`=@iCategoryId OR `Name`='permalinks_module_wall'; 
     15DELETE FROM `sys_options` WHERE `kateg`=@iCategoryId OR `Name`='permalinks_module_wall'; 
    1616 
    1717DELETE FROM `sys_acl_actions` WHERE `Name` IN ('Wall Post', 'Wall Post Comment'); 

  • trunk/periodic/notifies.php

    r9969 r9972  
    6969                `sys_subscriptions`.Name as Name, 
    7070                `sys_subscriptions`.Email, 
    71                 `sys_mass_messages`.Subj, 
    72                 `sys_mass_messages`.HTML as Body 
     71                `sys_mail_mass_messages`.Subj, 
     72                `sys_mail_mass_messages`.HTML as Body 
    7373            FROM `sys_mail_queue` 
    74             INNER JOIN `sys_mass_messages` ON 
    75                 (`sys_mass_messages`.ID =  `sys_mail_queue`.Msg) 
     74            INNER JOIN `sys_mail_mass_messages` ON 
     75                (`sys_mail_mass_messages`.ID =  `sys_mail_queue`.Msg) 
    7676            INNER JOIN `sys_subscriptions` ON 
    7777                (`sys_subscriptions`.ID = `sys_mail_queue`.Email) 
    … …  
    106106                Profiles.NickName as Name, 
    107107                Profiles.Email, 
    108                 `sys_mass_messages`.Subj, 
    109                 `sys_mass_messages`.HTML as Body 
     108                `sys_mail_mass_messages`.Subj, 
     109                `sys_mail_mass_messages`.HTML as Body 
    110110            FROM `sys_mail_queue`            
    111             INNER JOIN `sys_mass_messages` ON 
    112                 (`sys_mass_messages`.ID =  `sys_mail_queue`.Msg) 
     111            INNER JOIN `sys_mail_mass_messages` ON 
     112                (`sys_mail_mass_messages`.ID =  `sys_mail_queue`.Msg) 
    113113            INNER JOIN Profiles ON 
    114114                (Profiles.ID = `sys_mail_queue`.Email) 

  • trunk/templates/base/scripts/BxBaseProfileView.php

    r9967 r9972  
    7777        $this->oTemplConfig = new BxTemplConfig( $site ); 
    7878        //$this->sColumnsOrder = getParam( 'profile_view_cols' ); 
    79         //INSERT INTO `GlParams` VALUES('profile_view_cols', 'thin,thick', 0, 'Profile view columns order', 'digit', '', '', NULL, ''); 
     79        //INSERT INTO `sys_options` VALUES('profile_view_cols', 'thin,thick', 0, 'Profile view columns order', 'digit', '', '', NULL, ''); 
    8080         
    8181        if( $this->_iProfileID ) { 
Note: See TracChangeset for help on using the changeset viewer.
 
 

Site Search

Market

Notes

Websites

About BoonEx• Contacts• © BoonEx (ACN 127966581)