Changeset 9977 for trunk/admin/profiles.php

Timestamp:

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

Author:

Andrey Prikaznov

Message:

 

File:

• trunk/admin/profiles.php (modified) (1 diff)

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;