Changeset 9977

Timestamp:

04/06/09 05:42:46 (3 years ago)

Author:

Andrey Prikaznov

Message:

 

Location:

trunk

Files:

• admin/post_mod_profiles.php (modified) (5 diffs)
• admin/profiles.php (modified) (1 diff)
• communicator.php (modified) (1 diff)
• inc/admin.inc.php (modified) (2 diffs)
• inc/classes/BxDolInstaller.php (modified) (1 diff)
• inc/classes/BxDolSearch.php (modified) (1 diff)
• inc/classes/BxDolVotingQuery.php (modified) (1 diff)
• inc/match.inc.php (modified) (3 diffs)
• inc/profiles.inc.php (modified) (2 diffs)
• inc/shared_sites.inc.php (modified) (1 diff)
• install/sql/v70.sql (modified) (14 diffs)
• modules/boonex/blogs/install/sql/install.sql (modified) (1 diff)
• modules/boonex/blogs/install/sql/uninstall.sql (modified) (1 diff)
• modules/boonex/events/install/sql/install.sql (modified) (1 diff)
• modules/boonex/events/install/sql/uninstall.sql (modified) (1 diff)
• modules/boonex/feedback/install/sql/install.sql (modified) (1 diff)
• modules/boonex/feedback/install/sql/uninstall.sql (modified) (1 diff)
• modules/boonex/news/install/sql/install.sql (modified) (1 diff)
• modules/boonex/news/install/sql/uninstall.sql (modified) (1 diff)
• modules/boonex/shared_files/install/sql/install.sql (modified) (1 diff)
• modules/boonex/shared_files/install/sql/uninstall.sql (modified) (1 diff)
• modules/boonex/shared_music/install/sql/install.sql (modified) (1 diff)
• modules/boonex/shared_music/install/sql/uninstall.sql (modified) (1 diff)
• modules/boonex/shared_photo/install/sql/install.sql (modified) (1 diff)
• modules/boonex/shared_photo/install/sql/uninstall.sql (modified) (1 diff)
• modules/boonex/shared_video/install/sql/install.sql (modified) (1 diff)
• modules/boonex/shared_video/install/sql/uninstall.sql (modified) (1 diff)
• modules/boonex/store/install/sql/install.sql (modified) (1 diff)
• modules/boonex/store/install/sql/uninstall.sql (modified) (1 diff)
• periodic/cmd.php (modified) (1 diff)
• profile.php (modified) (1 diff)
• profile_customize.php (modified) (9 diffs)
• templates/base/scripts/BxBaseBrowse.php (modified) (2 diffs)
• templates/base/scripts/BxBaseCommunicator.php (modified) (1 diff)
• templates/base/scripts/BxBaseProfileView.php (modified) (1 diff)

trunk/admin/post_mod_profiles.php

@@ -42 +42 @@
     }
 
-    $query = "UPDATE ProfilesSettings SET `Status` = 'Active' WHERE " . $query . " '1'='0' ";
+    $query = "UPDATE `sys_profiles_settings` SET `Status` = 'Active' WHERE " . $query . " '1'='0' ";
 
     db_res( $query );
@@ -58 +58 @@
     }
 
-    $query1 = "SELECT `BackgroundFilename` FROM ProfilesSettings WHERE " . $query . " '1'='0' ";
+    $query1 = "SELECT `BackgroundFilename` FROM `sys_profiles_settings` WHERE " . $query . " '1'='0' ";
     $res = db_res( $query1 );
     while( $arr = mysql_fetch_array( $res ) )
@@ -66 +66 @@
     }
 
-    $query2 = "UPDATE ProfilesSettings SET `BackgroundFilename` = '' WHERE " . $query . " '1'='0' ";
+    $query2 = "UPDATE `sys_profiles_settings` SET `BackgroundFilename` = '' WHERE " . $query . " '1'='0' ";
 
     db_res( $query2 );
@@ -114 +114 @@
 
 
-$sql = "SELECT COUNT(*) FROM ProfilesSettings WHERE `BackgroundFilename` != '' && `BackgroundFilename` IS NOT NULL
+$sql = "SELECT COUNT(*) FROM `sys_profiles_settings` WHERE `BackgroundFilename` != '' && `BackgroundFilename` IS NOT NULL
         && $sqlMain $sqlUser";
 $p_num = db_arr( $sql );
@@ -123 +123 @@
 $page_first_p = $real_first_p + 1;
 
-$result = db_res( "SELECT `IDMember`, `BackgroundFilename` FROM ProfilesSettings WHERE `BackgroundFilename` != '' && `BackgroundFilename` IS NOT NULL
+$result = db_res( "SELECT `IDMember`, `BackgroundFilename` FROM `sys_profiles_settings` WHERE `BackgroundFilename` != '' && `BackgroundFilename` IS NOT NULL
         && $sqlMain $sqlUser LIMIT $real_first_p, $p_per_page" );
 

trunk/admin/profiles.php

@@ -595 +595 @@
             
         case 'bg':
-            $sqlAct  = "SELECT COUNT(*) as `Num` FROM `ProfilesSettings` WHERE `IDmember`='$ID' AND `Status`='Active' AND `BackgroundFilename`<>''";
-            $sqlPas  = "SELECT COUNT(*) as `Num` FROM `ProfilesSettings` WHERE `IDmember`='$ID' AND (`Status` IS NULL OR `Status`<>'Active') AND `BackgroundFilename`<>''";
+            $sqlAct  = "SELECT COUNT(*) as `Num` FROM `sys_profiles_settings` WHERE `IDmember`='$ID' AND `Status`='Active' AND `BackgroundFilename`<>''";
+            $sqlPas  = "SELECT COUNT(*) as `Num` FROM `sys_profiles_settings` WHERE `IDmember`='$ID' AND (`Status` IS NULL OR `Status`<>'Active') AND `BackgroundFilename`<>''";
             $sHrefA  = 'post_mod_profiles.php?iUser='.$ID.'&status=active';
             $sHrefP  = 'post_mod_profiles.php?iUser='.$ID;

trunk/communicator.php

@@ -136 +136 @@
         break;
 
-        // function will delete the received members from  `ProfilesTrack` ;
+        // function will delete the received members from  `sys_profiles_track` ;
         case 'delete_views' :
             if ( $aCommunicatorSettings['person_switcher'] == 'from' )
             {
-                $oCommunicator -> execFunction( '_deleteRequest', 'ProfilesTrack', $aMembersList, array(1) );
+                $oCommunicator -> execFunction( '_deleteRequest', 'sys_profiles_track', $aMembersList, array(1) );
             }
             else
             {
-                $oCommunicator -> execFunction('_deleteRequest', 'ProfilesTrack', $aMembersList);
+                $oCommunicator -> execFunction('_deleteRequest', 'sys_profiles_track', $aMembersList);
             }
         break;

trunk/inc/admin.inc.php

@@ -977 +977 @@
     
     db_res( "DELETE FROM `sys_block_list` WHERE `ID` = '{$ID}' OR `Profile` = '{$ID}'" );
-    db_res( "DELETE FROM `ProfilesTrack` WHERE `ID` = '{$ID}' OR `Profile` = '{$ID}'" );
+    db_res( "DELETE FROM `sys_profiles_track` WHERE `ID` = '{$ID}' OR `Profile` = '{$ID}'" );
     db_res( "DELETE FROM `Messages` WHERE Recipient = {$ID} " );
     db_res( "DELETE FROM `sys_aff_members` WHERE idProfile = {$ID}" );
@@ -999 +999 @@
 
     // Clean customizations
-    $customArr = db_arr( "SELECT `BackgroundFilename` FROM `ProfilesSettings` WHERE `IDMember` = {$ID}" );
+    $customArr = db_arr( "SELECT `BackgroundFilename` FROM `sys_profiles_settings` WHERE `IDMember` = {$ID}" );
     if ( strlen($customArr['BackgroundFilename']) && file_exists($dir['profileImage'] . $customArr['BackgroundFilename']) && is_file($dir['profileImage'] . $customArr['BackgroundFilename']) )
         unlink( $dir['profileImage'] . $customArr['BackgroundFilename'] );
-    db_res( "DELETE FROM `ProfilesSettings` WHERE `IDMember` = {$ID}" );
+    db_res( "DELETE FROM `sys_profiles_settings` WHERE `IDMember` = {$ID}" );
 
     db_res( "DELETE FROM `Profiles` WHERE `ID` = '{$ID}'" );

trunk/inc/classes/BxDolInstaller.php

@@ -419 +419 @@
     function actionRecompileSearch($bInstall = true) {
         ob_start();
-        $bResult = clearCacheFile(BX_DIRECTORY_PATH_DBCACHE . 'SearchObjects.inc');
+        $bResult = clearCacheFile(BX_DIRECTORY_PATH_DBCACHE . 'sys_objects_search.inc');
         ob_get_clean();
         

trunk/inc/classes/BxDolSearch.php

@@ -47 +47 @@
             // cache is empty | load data from DB
 
-            $sQuery  = "SELECT * FROM `SearchObjects`";
+            $sQuery  = "SELECT * FROM `sys_objects_search`";
             $rResult = db_res($sQuery);
 

trunk/inc/classes/BxDolVotingQuery.php

@@ -46 +46 @@
 
         //'A' prevent voting for own profile
-        if ($sTable == 'profile_rating' && (int)$_COOKIE['memberID']==$iId) {
+        if ($sTable == 'sys_profile_rating' && (int)$_COOKIE['memberID']==$iId) {
             return;
         }

trunk/inc/match.inc.php

@@ -15 +15 @@
 
     // try to find in cache
-    $sQuery = "SELECT `Percent` FROM `ProfilesMatch` WHERE `PID1` = $iPID1 AND `PID2` = $iPID2";
+    $sQuery = "SELECT `Percent` FROM `sys_profiles_match` WHERE `PID1` = $iPID1 AND `PID2` = $iPID2";
 
     $aPercent = db_assoc_arr( $sQuery );
@@ -33 +33 @@
 
     //write to cache
-    $sQuery = "INSERT INTO `ProfilesMatch` ( `PID1`, `PID2`, `Percent` ) VALUES ( $iPID1, $iPID2, $iMatch )";
+    $sQuery = "INSERT INTO `sys_profiles_match` ( `PID1`, `PID2`, `Percent` ) VALUES ( $iPID1, $iPID2, $iMatch )";
     db_res( $sQuery );
     
@@ -44 +44 @@
         return false;
     
-    $sQuery = "DELETE FROM `ProfilesMatch` WHERE `PID1` = $iProfileID OR `PID2` = $iProfileID";
+    $sQuery = "DELETE FROM `sys_profiles_match` WHERE `PID1` = $iProfileID OR `PID2` = $iProfileID";
     db_res( $sQuery );
 }

trunk/inc/profiles.inc.php

@@ -394 +394 @@
         break;  
         case 'rate' :   
-            // `profile_rating`.`pr_rating_sum
-            $sOrderBy = 'ORDER BY `profile_rating`.`pr_rating_sum`';
-            $sJoin = 'LEFT JOIN `profile_rating` ON p.`ID` = `profile_rating`.`pr_id`';
+            // `sys_profile_rating`.`pr_rating_sum
+            $sOrderBy = 'ORDER BY `sys_profile_rating`.`pr_rating_sum`';
+            $sJoin = 'LEFT JOIN `sys_profile_rating` ON p.`ID` = `sys_profile_rating`.`pr_id`';
         break;  
         default :
@@ -442 +442 @@
             break;  
             case 'rate' :   
-                // `profile_rating`.`pr_rating_sum
+                // `sys_profile_rating`.`pr_rating_sum
                 array_multisort($aFriends[3], SORT_DESC, SORT_NUMERIC);
             break;  

trunk/inc/shared_sites.inc.php

@@ -21 +21 @@
 require_once(BX_DIRECTORY_PATH_INC . 'db.inc.php');
 
-define('SHARED_SITES_TABLE', 'sharedSites');
-define('SHARED_SITES_CACHE', 'SharedSites.inc');
+define('SHARED_SITES_TABLE', 'sys_shared_sites');
+define('SHARED_SITES_CACHE', 'sys_shared_sites.inc');
 
 function getSitesArray ($sLink) {

trunk/install/sql/v70.sql

@@ -6 +6 @@
 
 SET NAMES 'utf8';
-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`, `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`, `sys_ip_list`, `sys_ip_members_visits`, `Links`, `sys_localization_categories`, `sys_localization_keys`, `sys_localization_languages`, `sys_localization_string_params`, `sys_localization_strings`, `sys_acl_actions`, `sys_acl_actions_track`, `sys_members_as_aff`, `sys_acl_matrix`, `sys_acl_level_prices`, `sys_acl_levels`, `Messages`, `sys_moderators`, `News`, `sys_subscriptions`, `sys_mail_mass_messages`, `sys_mail_queue`, `sys_page_compose`, `sys_page_compose_pages`, `sys_payment_parameters`, `sys_payment_providers`, `sys_payment_subscriptions`, `sys_stat_member`, `sys_pre_values`, `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`;
+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`, `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`, `sys_ip_list`, `sys_ip_members_visits`, `Links`, `sys_localization_categories`, `sys_localization_keys`, `sys_localization_languages`, `sys_localization_string_params`, `sys_localization_strings`, `sys_acl_actions`, `sys_acl_actions_track`, `sys_members_as_aff`, `sys_acl_matrix`, `sys_acl_level_prices`, `sys_acl_levels`, `Messages`, `sys_moderators`, `News`, `sys_subscriptions`, `sys_mail_mass_messages`, `sys_mail_queue`, `sys_page_compose`, `sys_page_compose_pages`, `sys_payment_parameters`, `sys_payment_providers`, `sys_payment_subscriptions`, `sys_stat_member`, `sys_pre_values`, `ProfileFields`, `sys_acl_levels_members`, `Profiles`, `sys_profile_views_track`, `sys_profiles_match`, `sys_profiles_settings`, `sys_profiles_track`, `sys_profile_rating`, `sys_profile_voting_track`, `RayBoardCurrentUsers`, `RayBoardBoards`, `RayBoardUsers`, `RayChatCurrentUsers`, `RayChatMessages`, `RayChatProfiles`, `RayChatRooms`, `RayChatRoomsUsers`, `RayGlobalTrackUsers`, `RayImContacts`, `RayImMessages`, `RayImPendings`, `RayImProfiles`, `RayMp3Files`, `RayShoutboxMessages`, `RayVideoFiles`, `RayVideo_commentsFiles`, `sys_objects_search`, `sys_shared_sites`, `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`;
 ALTER DATABASE DEFAULT CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci';
 
@@ -2352 +2352 @@
 INSERT INTO `sys_stat_member` VALUES('mgc', 'SELECT COUNT(*) FROM `Greetings` WHERE `ID` = ''__member_id__'' AND New = ''1''');
 INSERT INTO `sys_stat_member` VALUES('mbc', 'SELECT COUNT(*) FROM `sys_block_list` WHERE `ID` = ''__member_id__''');
-INSERT INTO `sys_stat_member` VALUES('mvc', 'SELECT COUNT(*) FROM `ProfilesTrack` WHERE `ID` = ''__member_id__''');
+INSERT INTO `sys_stat_member` VALUES('mvc', 'SELECT COUNT(*) FROM `sys_profiles_track` WHERE `ID` = ''__member_id__''');
 INSERT INTO `sys_stat_member` VALUES('mg', 'SELECT COUNT(*) FROM `Groups` WHERE `creatorID` = ''__member_id__'' AND `status`=''Active''');
 INSERT INTO `sys_stat_member` VALUES('mgj', 'SELECT COUNT(*) FROM `GroupsMembers` WHERE `memberID` = ''__member_id__'' AND `status`=''Active''');
 INSERT INTO `sys_stat_member` VALUES('mgmc', 'SELECT COUNT(*) FROM `Greetings` WHERE `Profile` = ''__member_id__'' AND New = ''1''');
 INSERT INTO `sys_stat_member` VALUES('mrc', 'SELECT COUNT(*) FROM `sys_block_list` WHERE `ID` = ''__member_id__''');
-INSERT INTO `sys_stat_member` VALUES('mvmc', 'SELECT COUNT(*) FROM `ProfilesTrack` WHERE `Profile` = ''__member_id__''');
+INSERT INTO `sys_stat_member` VALUES('mvmc', 'SELECT COUNT(*) FROM `sys_profiles_track` WHERE `Profile` = ''__member_id__''');
 
 
@@ -2931 +2931 @@
 
 --
--- Table structure for table `profile_views_track`
---
-
-CREATE TABLE IF NOT EXISTS `profile_views_track` (
+-- Table structure for table `sys_profile_views_track`
+--
+
+CREATE TABLE IF NOT EXISTS `sys_profile_views_track` (
   `id` int(10) unsigned NOT NULL,
   `viewer` int(10) unsigned NOT NULL,
@@ -2943 +2943 @@
 
 --
--- Dumping data for table `profile_views_track`
---
-
--- --------------------------------------------------------
-
---
--- Table structure for table `ProfilesMatch`
---
-
-CREATE TABLE `ProfilesMatch` (
+-- Dumping data for table `sys_profile_views_track`
+--
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sys_profiles_match`
+--
+
+CREATE TABLE `sys_profiles_match` (
   `PID1` int(10) unsigned NOT NULL default '0' COMMENT 'Profile ID',
   `PID2` int(10) unsigned NOT NULL default '0',
@@ -2960 +2960 @@
 
 --
--- Dumping data for table `ProfilesMatch`
---
-
-
--- --------------------------------------------------------
-
---
--- Table structure for table `ProfilesSettings`
---
-
-CREATE TABLE `ProfilesSettings` (
+-- Dumping data for table `sys_profiles_match`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sys_profiles_settings`
+--
+
+CREATE TABLE `sys_profiles_settings` (
   `IDMember` int(10) NOT NULL default '0',
   `BackgroundFilename` varchar(40) default NULL,
@@ -2982 +2982 @@
 
 --
--- Dumping data for table `ProfilesSettings`
---
-
-
--- --------------------------------------------------------
-
---
--- Table structure for table `ProfilesTrack`
---
-
-CREATE TABLE `ProfilesTrack` (
+-- Dumping data for table `sys_profiles_settings`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sys_profiles_track`
+--
+
+CREATE TABLE `sys_profiles_track` (
   `ID` int(10) unsigned NOT NULL default '0',
   `Profile` int(10) unsigned NOT NULL default '0',
@@ -3004 +3004 @@
 
 --
--- Dumping data for table `ProfilesTrack`
---
-
-
--- --------------------------------------------------------
-
---
--- Table structure for table `profile_rating`
---
-
-CREATE TABLE `profile_rating` (
+-- Dumping data for table `sys_profiles_track`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sys_profile_rating`
+--
+
+CREATE TABLE `sys_profile_rating` (
   `pr_id` int(10) unsigned NOT NULL default '0',
   `pr_rating_count` int(11) NOT NULL default '0',
@@ -3022 +3022 @@
 
 --
--- Dumping data for table `profile_rating`
---
-
-
--- --------------------------------------------------------
-
---
--- Table structure for table `profile_voting_track`
---
-
-CREATE TABLE `profile_voting_track` (
+-- Dumping data for table `sys_profile_rating`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sys_profile_voting_track`
+--
+
+CREATE TABLE `sys_profile_voting_track` (
   `pr_id` int(10) unsigned NOT NULL default '0',
   `pr_ip` varchar(20) default NULL,
@@ -3040 +3040 @@
 
 --
--- Dumping data for table `profile_voting_track`
+-- Dumping data for table `sys_profile_voting_track`
 --
 
@@ -3492 +3492 @@
 
 --
--- Table structure for table `Stories`
---
-
-CREATE TABLE `Stories` (
-  `ID` smallint(6) unsigned NOT NULL auto_increment,
-  `Date` date NOT NULL default '0000-00-00',
-  `Sender` bigint(8) unsigned NOT NULL default '0',
-  `Header` varchar(50) NOT NULL default '',
-  `Text` longtext NOT NULL,
-  `active` varchar(4) NOT NULL default '',
-  PRIMARY KEY  (`ID`),
-  KEY `Sender` (`Sender`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
---
--- Dumping data for table `Stories`
---
-
--- --------------------------------------------------------
-
---
--- Table structure for table 'SearchObjects'
---
-
-CREATE TABLE `SearchObjects` (
+-- Table structure for table 'sys_objects_search'
+--
+
+CREATE TABLE `sys_objects_search` (
   `ID` int(10) unsigned NOT NULL auto_increment,
   `ObjectName` varchar(50) NOT NULL  default '',
@@ -3526 +3505 @@
 
 --
--- Dumping data for table 'SearchObjects'
---
-
-INSERT INTO `SearchObjects` VALUES(2, 'group', '_Groups', 'BxTemplSearchGroup', 'templates/tmpl_{tmpl}/scripts/BxTemplSearchGroup.php');
-INSERT INTO `SearchObjects` VALUES(3, 'profile', '_Profiles', 'BxTemplSearchProfile', 'templates/tmpl_{tmpl}/scripts/BxTemplSearchProfile.php');
-
--- --------------------------------------------------------
-
---
--- Table structure for table 'sharedSites'
---
-
-CREATE TABLE `sharedSites` (
+-- Dumping data for table 'sys_objects_search'
+--
+
+INSERT INTO `sys_objects_search` VALUES(2, 'group', '_Groups', 'BxTemplSearchGroup', 'templates/tmpl_{tmpl}/scripts/BxTemplSearchGroup.php');
+INSERT INTO `sys_objects_search` VALUES(3, 'profile', '_Profiles', 'BxTemplSearchProfile', 'templates/tmpl_{tmpl}/scripts/BxTemplSearchProfile.php');
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table 'sys_shared_sites'
+--
+
+CREATE TABLE `sys_shared_sites` (
   `ID` tinyint(4) unsigned NOT NULL auto_increment,
   `Name` varchar(255) default NULL,
@@ -3546 +3525 @@
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
-INSERT INTO `sharedSites` VALUES('', 'digg', 'http://digg.com/submit?phase=2&url=', 'digg.png');
-INSERT INTO `sharedSites` VALUES('', 'delicious', 'http://del.icio.us/post?url=', 'delicious.png');
-INSERT INTO `sharedSites` VALUES('', 'blinklist', 'http://www.blinklist.com/index.php?Action=Blink/addblink.php&Url=', 'blinklist.png');
-INSERT INTO `sharedSites` VALUES('', 'furl', 'http://www.furl.net/storeIt.jsp?u=', 'furl.png');
-INSERT INTO `sharedSites` VALUES('', 'netscape', 'http://www.netscape.com/submit/?U=', 'netscape.gif');
-INSERT INTO `sharedSites` VALUES('', 'newsvine', 'http://www.newsvine.com/_tools/seed&save?u=', 'newsvine.png');
-INSERT INTO `sharedSites` VALUES('', 'reddit', 'http://reddit.com/submit?url=', 'reddit.png');
-INSERT INTO `sharedSites` VALUES('', 'shadows', 'http://www.shadows.com/features/tcr.htm?url=', 'shadows.png');
-INSERT INTO `sharedSites` VALUES('', 'slashdot', 'http://slashdot.org/bookmark.pl?url=', 'slashdot.png');
-INSERT INTO `sharedSites` VALUES('', 'sphere', 'http://www.sphere.com/search?q=sphereit:', 'sphere.png');
-INSERT INTO `sharedSites` VALUES('', 'stumbleupon', 'http://www.stumbleupon.com/url/http', 'stumbleupon.png');
-INSERT INTO `sharedSites` VALUES('', 'technorati', 'http://technorati.com/faves?add=', 'technorati.png');
-
---
--- Dumping data for table 'sharedSites'
+INSERT INTO `sys_shared_sites` VALUES('', 'digg', 'http://digg.com/submit?phase=2&url=', 'digg.png');
+INSERT INTO `sys_shared_sites` VALUES('', 'delicious', 'http://del.icio.us/post?url=', 'delicious.png');
+INSERT INTO `sys_shared_sites` VALUES('', 'blinklist', 'http://www.blinklist.com/index.php?Action=Blink/addblink.php&Url=', 'blinklist.png');
+INSERT INTO `sys_shared_sites` VALUES('', 'furl', 'http://www.furl.net/storeIt.jsp?u=', 'furl.png');
+INSERT INTO `sys_shared_sites` VALUES('', 'netscape', 'http://www.netscape.com/submit/?U=', 'netscape.gif');
+INSERT INTO `sys_shared_sites` VALUES('', 'newsvine', 'http://www.newsvine.com/_tools/seed&save?u=', 'newsvine.png');
+INSERT INTO `sys_shared_sites` VALUES('', 'reddit', 'http://reddit.com/submit?url=', 'reddit.png');
+INSERT INTO `sys_shared_sites` VALUES('', 'shadows', 'http://www.shadows.com/features/tcr.htm?url=', 'shadows.png');
+INSERT INTO `sys_shared_sites` VALUES('', 'slashdot', 'http://slashdot.org/bookmark.pl?url=', 'slashdot.png');
+INSERT INTO `sys_shared_sites` VALUES('', 'sphere', 'http://www.sphere.com/search?q=sphereit:', 'sphere.png');
+INSERT INTO `sys_shared_sites` VALUES('', 'stumbleupon', 'http://www.stumbleupon.com/url/http', 'stumbleupon.png');
+INSERT INTO `sys_shared_sites` VALUES('', 'technorati', 'http://technorati.com/faves?add=', 'technorati.png');
+
+--
+-- Dumping data for table 'sys_shared_sites'
 --
 
@@ -3858 +3837 @@
 --
 
-INSERT INTO `VoteObjects` VALUES(1, 'profile', 'profile_rating', 'profile_voting_track', 'pr_', '5', 'vote_send_result', 'BX_PERIOD_PER_VOTE', '1', '', '', 'Profiles', 'Rate', 'RateCount', 'ID', '', '');
+INSERT INTO `VoteObjects` VALUES(1, 'profile', 'sys_profile_rating', 'sys_profile_voting_track', 'pr_', '5', 'vote_send_result', 'BX_PERIOD_PER_VOTE', '1', '', '', 'Profiles', 'Rate', 'RateCount', 'ID', '', '');
 
 --
@@ -4056 +4035 @@
 --
 
-INSERT INTO `sys_objects_views` VALUES(NULL, 'profiles', 'profile_views_track', 86400, 'Profiles', 'ID', 'Views', 1);
+INSERT INTO `sys_objects_views` VALUES(NULL, 'profiles', 'sys_profile_views_track', 86400, 'Profiles', 'ID', 'Views', 1);
 
 --

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

@@ -164 +164 @@
 INSERT INTO `sys_stat_site` (`ID`, `Name`, `Title`, `UserLink`, `UserQuery`, `AdminLink`, `AdminQuery`, `IconName`, `StatOrder`) VALUES(NULL, 'blg', 'bx_blog_blog_posts', 'modules/boonex/blogs/blogs.php?action=all_posts', 'SELECT COUNT(*) FROM `[db_prefix]_posts` WHERE `PostStatus`=''approval''', '', '', 'modules/boonex/blogs/|user_comment.png', 0);
 
-INSERT INTO `SearchObjects` (`ID`, `ObjectName`, `Title`, `ClassName`, `ClassPath`) VALUES(NULL, 'blog', '_Blogs', 'BxBlogsSearchUnit', 'modules/boonex/blogs/classes/BxBlogsSearchUnit.php');
+INSERT INTO `sys_objects_search` (`ID`, `ObjectName`, `Title`, `ClassName`, `ClassPath`) VALUES(NULL, 'blog', '_Blogs', 'BxBlogsSearchUnit', 'modules/boonex/blogs/classes/BxBlogsSearchUnit.php');
 
 INSERT INTO `TagObjects` (`ID`, `ObjectName`, `Query`, `PermalinkParam`, `EnabledPermalink`, `DisabledPermalink`, `LangKey`) VALUES(NULL, 'blog', 'SELECT `Tags` FROM `[db_prefix]_posts` WHERE `PostID` = {iID} AND `PostStatus` = ''approval''', 'permalinks_module_blogs', 'blogs/tag/{tag}', 'modules/boonex/blogs/blogs.php?action=search_by_tag&tagKey={tag}', '_Blogs');

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

@@ -39 +39 @@
 DELETE FROM `sys_stat_site` WHERE `Name`='blg';
 
-DELETE FROM `SearchObjects` WHERE `ClassName`='BxBlogsSearchUnit';
+DELETE FROM `sys_objects_search` WHERE `ClassName`='BxBlogsSearchUnit';
 
 DELETE FROM `TagObjects` WHERE `ObjectName`='blog' AND `LangKey`='_Blogs';

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

@@ -137 +137 @@
 
 -- search objects
-INSERT INTO `SearchObjects` VALUES(NULL, 'bx_events', '_bx_events', 'BxEventsSearchResult', 'modules/boonex/events/classes/BxEventsSearchResult.php');
+INSERT INTO `sys_objects_search` VALUES(NULL, 'bx_events', '_bx_events', 'BxEventsSearchResult', 'modules/boonex/events/classes/BxEventsSearchResult.php');
 
 -- vote objects

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

@@ -23 +23 @@
 DELETE FROM `Categories` WHERE `Type` = 'shared_photo' AND `Category` = 'Events';
 DELETE FROM `TagObjects` WHERE `ObjectName` = 'bx_events';
-DELETE FROM `SearchObjects` WHERE `ObjectName` = 'bx_events';
+DELETE FROM `sys_objects_search` WHERE `ObjectName` = 'bx_events';
 DELETE FROM `Tags` WHERE `Type` = 'bx_events';
 DELETE FROM `sys_objects_actions` WHERE `Type` = 'bx_events';

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

@@ -113 +113 @@
 ('bx_feedback', 'SELECT `tags` FROM `[db_prefix]entries` WHERE `id`={iID} AND `status`=0', 'permalinks_module_feedback', 'm/feedback/tags/{tag}', 'modules/?r=feedback/tags/{tag}', '_feedback_lcaption_tags_object');
 
-INSERT INTO `SearchObjects` (`ObjectName`, `Title`, `ClassName`, `ClassPath`) VALUES
+INSERT INTO `sys_objects_search` (`ObjectName`, `Title`, `ClassName`, `ClassPath`) VALUES
 ('bx_feedback', '_feedback_lcaption_search_object', 'BxFdbSearchResult', 'modules/boonex/feedback/classes/BxFdbSearchResult.php');
 

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

@@ -19 +19 @@
 DELETE FROM `VoteObjects` WHERE `ObjectName`='bx_feedback' LIMIT 1;
 DELETE FROM `TagObjects` WHERE `ObjectName`='bx_feedback' LIMIT 1;
-DELETE FROM `SearchObjects` WHERE `ObjectName`='bx_feedback' LIMIT 1;
+DELETE FROM `sys_objects_search` WHERE `ObjectName`='bx_feedback' LIMIT 1;
 
 

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

@@ -139 +139 @@
 ('bx_news', 'SELECT `tags` FROM `[db_prefix]entries` WHERE `id`={iID} AND `status`=0', 'permalinks_module_news', 'm/news/tags/{tag}', 'modules/?r=news/tags/{tag}', '_news_lcaption_tags');
 
-INSERT INTO `SearchObjects` (`ObjectName`, `Title`, `ClassName`, `ClassPath`) VALUES
+INSERT INTO `sys_objects_search` (`ObjectName`, `Title`, `ClassName`, `ClassPath`) VALUES
 ('bx_news', '_news_lcaption_search_object', 'BxNewsSearchResult', 'modules/boonex/news/classes/BxNewsSearchResult.php');
 

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

@@ -20 +20 @@
 DELETE FROM `VoteObjects` WHERE `ObjectName`='bx_news' LIMIT 1;
 DELETE FROM `TagObjects` WHERE `ObjectName`='bx_news' LIMIT 1;
-DELETE FROM `SearchObjects` WHERE `ObjectName`='bx_news' LIMIT 1;
+DELETE FROM `sys_objects_search` WHERE `ObjectName`='bx_news' LIMIT 1;
 DELETE FROM `sys_objects_views` WHERE `name`='bx_news' LIMIT 1;
 

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

@@ -137 +137 @@
 INSERT 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);
 
-INSERT INTO `SearchObjects` (`ObjectName`, `Title`, `ClassName`, `ClassPath`) VALUES
+INSERT INTO `sys_objects_search` (`ObjectName`, `Title`, `ClassName`, `ClassPath`) VALUES
 ('bx_shared_files', '_bx_shared_files', 'BxShFilesSearch', 'modules/boonex/shared_files/classes/BxShFilesSearch.php');

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

@@ -21 +21 @@
 DELETE FROM `TopMenu` WHERE `Name`='Files' OR `Parent`=@iTMParentId;
 
-DELETE FROM `SearchObjects` WHERE `ObjectName` = 'bx_shared_files' LIMIT 1;
+DELETE FROM `sys_objects_search` WHERE `ObjectName` = 'bx_shared_files' LIMIT 1;

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

@@ -168 +168 @@
 VALUES('shared_music', '[db_prefix]cmts', 'sys_cmts_track', 0, 1, 90, 5, 1, -3, 'slide', 2000, 1, 1, 'cmt', 'RayMp3Files', 'ID', 'CommentsCount');
 
--- SearchObjects
-INSERT INTO `SearchObjects` VALUES(NULL, 'shared_music', '_Music', 'BxShMusicSearch', 'modules/boonex/shared_music/classes/BxShMusicSearch.php');
+-- sys_objects_search
+INSERT INTO `sys_objects_search` VALUES(NULL, 'shared_music', '_Music', 'BxShMusicSearch', 'modules/boonex/shared_music/classes/BxShMusicSearch.php');
 
 -- sys_stat_site

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

@@ -30 +30 @@
 DELETE FROM `sys_objects_cmts` WHERE `ObjectName` = 'shared_music';
 
-DELETE FROM `SearchObjects` WHERE `ObjectName` = 'shared_music';
+DELETE FROM `sys_objects_search` WHERE `ObjectName` = 'shared_music';
 
 DELETE FROM `sys_stat_site` WHERE `Name` = 'pmu';

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

@@ -212 +212 @@
 INSERT INTO `TagObjects` VALUES(NULL, 'shared_photo', 'SELECT `medTags`  FROM `[db_prefix]files` WHERE `medID`  = {iID} AND `Status` = ''approved''', 'permalinks_gallery_photos', 'modules/boonex/shared_photo/browsePhoto.php?tag={tag}', 'modules/boonex/shared_photo/browsePhoto.php?type=shared_photo&tag={tag}', '_Photos');
 
--- SearchObjects
-INSERT INTO `SearchObjects` VALUES(NULL, 'shared_photo', '_Photos', 'BxShPhotoSearch', 'modules/boonex/shared_photo/classes/BxShPhotoSearch.php');
+-- sys_objects_search
+INSERT INTO `sys_objects_search` VALUES(NULL, 'shared_photo', '_Photos', 'BxShPhotoSearch', 'modules/boonex/shared_photo/classes/BxShPhotoSearch.php');
 
 -- UserActions

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

@@ -30 +30 @@
 DELETE FROM `sys_objects_cmts` WHERE `ObjectName` = 'shared_photo';
 
-DELETE FROM `SearchObjects` WHERE `ObjectName` = 'shared_photo';
+DELETE FROM `sys_objects_search` WHERE `ObjectName` = 'shared_photo';
 
 DELETE FROM `sys_stat_site` WHERE `Name` = 'pph';

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

@@ -173 +173 @@
 INSERT INTO `TagObjects` VALUES(NULL, 'shared_video', 'SELECT `Tags` FROM `RayVideoFiles` WHERE `ID` = {iID} AND `Status` = ''approved''', 'permalinks_gallery_videos', 'modules/boonex/shared_video/browseVideo.php?tag={tag}', 'modules/boonex/shared_video/browseVideo.php?tag={tag}', '_Videos');
 
--- SearchObjects
-INSERT INTO `SearchObjects` VALUES(NULL, 'shared_video', '_Videos', 'BxShVideoSearch', 'modules/boonex/shared_video/classes/BxShVideoSearch.php');
+-- sys_objects_search
+INSERT INTO `sys_objects_search` VALUES(NULL, 'shared_video', '_Videos', 'BxShVideoSearch', 'modules/boonex/shared_video/classes/BxShVideoSearch.php');
 
 -- UserActions

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

@@ -31 +31 @@
 DELETE FROM `sys_objects_cmts` WHERE `ObjectName` = 'shared_video';
 
-DELETE FROM `SearchObjects` WHERE `ObjectName` = 'shared_video';
+DELETE FROM `sys_objects_search` WHERE `ObjectName` = 'shared_video';
 
 DELETE FROM `sys_stat_site` WHERE `Name` = 'pvi';

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

@@ -110 +110 @@
 
 -- search objects
-INSERT INTO `SearchObjects` VALUES(NULL, 'bx_store', '_bx_store', 'BxStoreSearchResult', 'modules/boonex/store/classes/BxStoreSearchResult.php');
+INSERT INTO `sys_objects_search` VALUES(NULL, 'bx_store', '_bx_store', 'BxStoreSearchResult', 'modules/boonex/store/classes/BxStoreSearchResult.php');
 
 -- vote objects

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

@@ -21 +21 @@
 DELETE FROM `TagObjects` WHERE `ObjectName` = 'bx_store';
 DELETE FROM `Tags` WHERE `Type` = 'bx_store';
-DELETE FROM `SearchObjects` WHERE `ObjectName` = 'bx_store';
+DELETE FROM `sys_objects_search` WHERE `ObjectName` = 'bx_store';
 DELETE FROM `sys_objects_actions` WHERE `Type` = 'bx_store';
 DELETE FROM `sys_stat_site` WHERE `Name` = 'bx_store';

trunk/periodic/cmd.php

@@ -86 +86 @@
     if ( $db_clean_views > 0 )
     {
-        $res = db_res("DELETE FROM `ProfilesTrack` WHERE (TO_DAYS(NOW())-TO_DAYS(`When`)) > $db_clean_views");
+        $res = db_res("DELETE FROM `sys_profiles_track` WHERE (TO_DAYS(NOW())-TO_DAYS(`When`)) > $db_clean_views");
         if ( $res )
             $db_clean_views_num = mysql_affected_rows();

trunk/profile.php

@@ -95 +95 @@
 if ( $track_profile_view && $memberID && !$oProfile -> owner )
 {
-    db_res( "DELETE FROM `ProfilesTrack` WHERE `ID` = {$memberID} AND `Profile` = $profileID", 0);
-    db_res( "INSERT INTO `ProfilesTrack` SET `When` = NOW(), `ID` = {$memberID}, `Profile` = $profileID", 0);
+    db_res( "DELETE FROM `sys_profiles_track` WHERE `ID` = {$memberID} AND `Profile` = $profileID", 0);
+    db_res( "INSERT INTO `sys_profiles_track` SET `When` = NOW(), `ID` = {$memberID}, `Profile` = $profileID", 0);
 }
 

trunk/profile_customize.php

@@ -48 +48 @@
     {
 
-            $query = "SELECT `BackgroundFilename` FROM `ProfilesSettings` WHERE `IDMember` = '$ID';";
+            $query = "SELECT `BackgroundFilename` FROM `sys_profiles_settings` WHERE `IDMember` = '$ID';";
             $custom_arr = db_arr( $query );
             if ( strlen($custom_arr['BackgroundFilename']) && file_exists($dir['profileBackground'] . $custom_arr['BackgroundFilename']) && is_file($dir['profileBackground'] . $custom_arr['BackgroundFilename']) )
                 @unlink($dir['profileBackground'] . $custom_arr['BackgroundFilename']);
 
-            $query = "DELETE FROM `ProfilesSettings` WHERE `IDMember`='$ID' LIMIT 1";
+            $query = "DELETE FROM `sys_profiles_settings` WHERE `IDMember`='$ID' LIMIT 1";
             db_res( $query );
 
@@ -60 +60 @@
     {
 
-    $query = "SELECT * FROM `ProfilesSettings` WHERE `IDMember` = '$ID';";
+    $query = "SELECT * FROM `sys_profiles_settings` WHERE `IDMember` = '$ID';";
     $custom_arr = db_arr( $query );
     $record_created = $custom_arr['IDMember'] ? 'ok' : '';
@@ -78 +78 @@
                 if ( !$record_created )
                 {
-                    $query = "INSERT INTO ProfilesSettings (`IDMember`, `BackgroundFilename` ) VALUES ( '$ID', '$pic_name$ext' )";
+                    $query = "INSERT INTO `sys_profiles_settings` (`IDMember`, `BackgroundFilename` ) VALUES ( '$ID', '$pic_name$ext' )";
                     $record_created = 'ok';
                 }
                 else
                 {
-                    $query = "UPDATE ProfilesSettings SET `BackgroundFilename` = '$pic_name$ext', `Status` = 'Approval' WHERE `IDMember` = '$ID'";
+                    $query = "UPDATE `sys_profiles_settings` SET `BackgroundFilename` = '$pic_name$ext', `Status` = 'Approval' WHERE `IDMember` = '$ID'";
                 }
                 $res = db_res( $query );
@@ -97 +97 @@
             if (file_exists($dir['profileBackground'] . $custom_arr['BackgroundFilename'])) unlink($dir['profileBackground'] . $custom_arr['BackgroundFilename']);
 
-                $query = "UPDATE ProfilesSettings SET `BackgroundFilename` = '' WHERE `IDMember` = '$ID'";
+                $query = "UPDATE `sys_profiles_settings` SET `BackgroundFilename` = '' WHERE `IDMember` = '$ID'";
                 $res = db_res( $query );
             }
@@ -109 +109 @@
     if ( !$record_created )
     {
-        $query = "INSERT INTO ProfilesSettings (`IDMember`, `BackgroundColor` ) VALUES ( '$ID', '{$_POST['bgcolor']}' )";
+        $query = "INSERT INTO `sys_profiles_settings` (`IDMember`, `BackgroundColor` ) VALUES ( '$ID', '{$_POST['bgcolor']}' )";
         $record_created = 'ok';
     }
     else
-        $query = "UPDATE ProfilesSettings SET `BackgroundColor` = '{$_POST['bgcolor']}' WHERE `IDMember` = '$ID'";
+        $query = "UPDATE `sys_profiles_settings` SET `BackgroundColor` = '{$_POST['bgcolor']}' WHERE `IDMember` = '$ID'";
 
     $res = db_res( $query );
@@ -123 +123 @@
     if ( !$record_created )
     {
-        $query = "INSERT INTO ProfilesSettings (`IDMember`, `FontColor` ) VALUES ( '$ID', '{$_POST['fontcolor']}' )";
+        $query = "INSERT INTO `sys_profiles_settings` (`IDMember`, `FontColor` ) VALUES ( '$ID', '{$_POST['fontcolor']}' )";
         $record_created = 'ok';
     }
     else
-        $query = "UPDATE ProfilesSettings SET `FontColor` = '{$_POST['fontcolor']}' WHERE `IDMember` = '$ID'";
+        $query = "UPDATE `sys_profiles_settings` SET `FontColor` = '{$_POST['fontcolor']}' WHERE `IDMember` = '$ID'";
 
     $res = db_res( $query );
@@ -137 +137 @@
     if ( !$record_created )
     {
-        $query = "INSERT INTO ProfilesSettings (`IDMember`, `FontSize` ) VALUES ( '$ID', '{$_POST['fontsize']}' )";
+        $query = "INSERT INTO `sys_profiles_settings` (`IDMember`, `FontSize` ) VALUES ( '$ID', '{$_POST['fontsize']}' )";
         $record_created = 'ok';
     }
     else
-        $query = "UPDATE ProfilesSettings SET `FontSize` = '{$_POST['fontsize']}' WHERE `IDMember` = '$ID'";
+        $query = "UPDATE `sys_profiles_settings` SET `FontSize` = '{$_POST['fontsize']}' WHERE `IDMember` = '$ID'";
 
     $res = db_res( $query );
@@ -151 +151 @@
     if ( !$record_created )
     {
-        $query = "INSERT INTO ProfilesSettings (`IDMember`, `FontFamily` ) VALUES ( '$ID', '{$_POST['fontfamily']}' )";
+        $query = "INSERT INTO `sys_profiles_settings` (`IDMember`, `FontFamily` ) VALUES ( '$ID', '{$_POST['fontfamily']}' )";
         $record_created = 'ok';
     }
     else
-        $query = "UPDATE ProfilesSettings SET `FontFamily` = '{$_POST['fontfamily']}' WHERE `IDMember` = '$ID'";
+        $query = "UPDATE `sys_profiles_settings` SET `FontFamily` = '{$_POST['fontfamily']}' WHERE `IDMember` = '$ID'";
 
     $res = db_res( $query );
@@ -188 +188 @@
     global $site;
 
-    $query = "SELECT * FROM `ProfilesSettings` WHERE `IDMember` = '$ID'";
+    $query = "SELECT * FROM `sys_profiles_settings` WHERE `IDMember` = '$ID'";
     $custom_arr = db_arr( $query );
 

trunk/templates/base/scripts/BxBaseBrowse.php

@@ -770 +770 @@
                     break;    
                     case 'rate' :    
-                        $sSortParam = ' `profile_rating`.`pr_rating_sum` DESC';
+                        $sSortParam = ' `sys_profile_rating`.`pr_rating_sum` DESC';
                     break;    
                     default :
@@ -788 +788 @@
                     `Profiles` 
                 LEFT JOIN
-                    `profile_rating`
+                    `sys_profile_rating`
                 ON
-                    `Profiles`.`ID` = `profile_rating`.`pr_id`
+                    `Profiles`.`ID` = `sys_profile_rating`.`pr_id`
                 WHERE 
                     `Status` = 'Active'

trunk/templates/base/scripts/BxBaseCommunicator.php

@@ -210 +210 @@
                         'to'            => _t( '_MEMBERS_YOU_VIEWED_BY' ),
                     );
-                    $aRows = $this -> getRequests( 'ProfilesTrack', $aTypes );
+                    $aRows = $this -> getRequests( 'sys_profiles_track', $aTypes );
                 break;
 

trunk/templates/base/scripts/BxBaseProfileView.php

@@ -124 +124 @@
         $ret = '';
 
-        $query = "SELECT * FROM `ProfilesSettings` WHERE `IDMember` = '$ID'";
+        $query = "SELECT * FROM `sys_profiles_settings` WHERE `IDMember` = '$ID'";
         $arr = db_arr( $query );
         if ( $arr['IDMember'] )