Changeset 9985 for trunk/inc/classes/BxDolPFM.php

Timestamp:

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

Author:

Andrey Prikaznov

Message:

 

File:

• trunk/inc/classes/BxDolPFM.php (modified) (22 diffs)

trunk/inc/classes/BxDolPFM.php

@@ -98 +98 @@
                 `ID`,
                 `Name`
-            FROM `ProfileFields`
+            FROM `sys_profile_fields`
             WHERE
                 `{$this -> areaOrderCol}` IS NOT NULL AND
@@ -118 +118 @@
                     `ID`,
                     `Name`
-                FROM `ProfileFields`
+                FROM `sys_profile_fields`
                 WHERE
                     `Type` != 'block' AND
@@ -147 +147 @@
                 `ID`,
                 `Name`
-            FROM `ProfileFields`
+            FROM `sys_profile_fields`
             WHERE
                 `{$this -> areaOrderCol}` IS NULL AND
@@ -167 +167 @@
                 `ID`,
                 `Name`
-            FROM `ProfileFields`
+            FROM `sys_profile_fields`
             WHERE
                 `Type` != 'block' AND (
@@ -189 +189 @@
     
     function savePositions( $aInArrays ) {
-        db_res( "UPDATE `ProfileFields` SET `{$this -> areaOrderCol}` = NULL" );
-        db_res( "UPDATE `ProfileFields` SET `{$this -> areaBlockCol}` = 0" );
+        db_res( "UPDATE `sys_profile_fields` SET `{$this -> areaOrderCol}` = NULL" );
+        db_res( "UPDATE `sys_profile_fields` SET `{$this -> areaBlockCol}` = 0" );
         
         if( is_array( $aInArrays['blocks'] ) ) {
@@ -198 +198 @@
                 $iBlockOrd = (int)db_value( "
                     SELECT MAX( `{$this -> areaOrderCol}` )
-                    FROM `ProfileFields`
+                    FROM `sys_profile_fields`
                     WHERE `Type` = 'block'
                 " ) + 1;
                 
                 db_res( "
-                    UPDATE `ProfileFields`
+                    UPDATE `sys_profile_fields`
                     SET `{$this -> areaOrderCol}` = $iBlockOrd
                     WHERE `ID` = $iBlockID
@@ -217 +217 @@
                         $iItemOrd = db_value( "
                             SELECT MAX( `{$this -> areaOrderCol}` )
-                            FROM `ProfileFields`
+                            FROM `sys_profile_fields`
                             WHERE `Type` != 'block' AND `{$this -> areaBlockCol}` = $iItemBlockID
                         " ) + 1;
                         
                         db_res( "
-                            UPDATE `ProfileFields`
+                            UPDATE `sys_profile_fields`
                             SET
                                 `{$this -> areaOrderCol}` = $iItemOrd,
@@ -260 +260 @@
                 ) . "
                 
-            FROM `ProfileFields` WHERE `ID` = $iItemID";
+            FROM `sys_profile_fields` WHERE `ID` = $iItemID";
         
         $aField = db_assoc_arr( $sQuery );
@@ -451 +451 @@
         
         
-        $sQuery = "SELECT `Name` FROM `ProfileFields` WHERE $sWhere";
+        $sQuery = "SELECT `Name` FROM `sys_profile_fields` WHERE $sWhere";
         $rFields = db_res( $sQuery );
         
@@ -465 +465 @@
     
     function getJoinPagesSelector( $iCurrent ) {
-        $sQuery = "SELECT MAX( `JoinPage` ) FROM `ProfileFields`";
+        $sQuery = "SELECT MAX( `JoinPage` ) FROM `sys_profile_fields`";
         $iMaxPage = (int)db_value( $sQuery );
         
@@ -518 +518 @@
         }
         
-        $sQuery = "SELECT `ID`, `Name` FROM `ProfileFields` WHERE FIND_IN_SET( `Type`, '" . implode( ',', $aSelectFields ) . "' )";
+        $sQuery = "SELECT `ID`, `Name` FROM `sys_profile_fields` WHERE FIND_IN_SET( `Type`, '" . implode( ',', $aSelectFields ) . "' )";
         $rMyFields = db_res( $sQuery );
         
@@ -799 +799 @@
         $iItemID = (int)$aData['id'];
         
-        $aItem = db_assoc_arr( "SELECT * FROM `ProfileFields` WHERE `ID` = $iItemID" );
+        $aItem = db_assoc_arr( "SELECT * FROM `sys_profile_fields` WHERE `ID` = $iItemID" );
         
         if( !$aItem ) {
@@ -824 +824 @@
                 $this -> genSaveItemError( 'The name must begin with a latin letter and contain only latin letters, numbers or underscores.', 'Name' );
                 $bHaveErrors = true;
-            } elseif( db_value( "SELECT COUNT(*) FROM `ProfileFields` WHERE `Name` = '$sName' and `ID` != $iItemID" ) ) {
+            } elseif( db_value( "SELECT COUNT(*) FROM `sys_profile_fields` WHERE `Name` = '$sName' and `ID` != $iItemID" ) ) {
                 $this -> genSaveItemError( 'A field with such name already exists. Please select another.', 'Name' );
                 $bHaveErrors = true;
@@ -1150 +1150 @@
         
         $sQuery = "
-            UPDATE `ProfileFields` SET 
+            UPDATE `sys_profile_fields` SET 
                 " . implode( ", 
                 ", $aUpdateStrs ) . "
@@ -1211 +1211 @@
         
         //try to insert new item
-        if( db_res( "INSERT INTO `ProfileFields` (`Name`, `Type` ) VALUES ('NEW_ITEM', 'text')", 0 ) and $iNewID = mysql_insert_id() ) {
+        if( db_res( "INSERT INTO `sys_profile_fields` (`Name`, `Type` ) VALUES ('NEW_ITEM', 'text')", 0 ) and $iNewID = mysql_insert_id() ) {
             //if success - try to alter table
             if( !db_res( "ALTER TABLE `Profiles` ADD `NEW_ITEM` varchar(255) NOT NULL default ''", 0 ) ) {
                 //if couldn't alter - delete inserted field
-                db_res( "DELETE FROM `ProfileFields` WHERE `ID` = $iNewID" );
+                db_res( "DELETE FROM `sys_profile_fields` WHERE `ID` = $iNewID" );
                 $iNewID = 0;
             }
@@ -1224 +1224 @@
     
     function createNewBlock() {
-        db_res( "INSERT INTO `ProfileFields` (`Name`, `Type` ) VALUES ('NEW BLOCK', 'block')", 0 );
+        db_res( "INSERT INTO `sys_profile_fields` (`Name`, `Type` ) VALUES ('NEW BLOCK', 'block')", 0 );
         $iNewID = mysql_insert_id();
         
@@ -1303 +1303 @@
         $this -> genSaveItemHeader();
         
-        $aItem = db_assoc_arr( "SELECT * FROM `ProfileFields` WHERE `ID` = $iItemID" );
+        $aItem = db_assoc_arr( "SELECT * FROM `sys_profile_fields` WHERE `ID` = $iItemID" );
         
         if( !$aItem )
@@ -1310 +1310 @@
             $this -> genSaveItemError( 'The field cannot be deleted.' );
         else{
-            $sQuery = "DELETE FROM `ProfileFields` WHERE `ID` = $iItemID";
+            $sQuery = "DELETE FROM `sys_profile_fields` WHERE `ID` = $iItemID";
             db_res( $sQuery );
             
@@ -1458 +1458 @@
         );
         
-        $this -> sCacheFile = BX_DIRECTORY_PATH_DBCACHE . 'ProfileFields.inc';
+        $this -> sCacheFile = BX_DIRECTORY_PATH_DBCACHE . 'sys_profile_fields.inc';
         
     }
@@ -1671 +1671 @@
             SELECT
                 DISTINCT `JoinPage`
-            FROM `ProfileFields`
+            FROM `sys_profile_fields`
             WHERE
                 `Type` = 'block' AND
@@ -1694 +1694 @@
                 `ID`,
                 `Name`
-            FROM `ProfileFields`
+            FROM `sys_profile_fields`
             WHERE
                 `Type` = 'block' AND
@@ -1733 +1733 @@
                 $sAddSelect
             FROM
-                `ProfileFields`
+                `sys_profile_fields`
             WHERE
                 `Type` != 'block' AND