Changeset 9977 for trunk/profile_customize.php

Timestamp:

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

Author:

Andrey Prikaznov

Message:

 

File:

• trunk/profile_customize.php (modified) (9 diffs)

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 );