Changeset 9977 for trunk/admin/post_mod_profiles.php

Timestamp:

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

Author:

Andrey Prikaznov

Message:

 

File:

• trunk/admin/post_mod_profiles.php (modified) (5 diffs)

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