Changeset 10378 for trunk/admin/memb_levels.php

Timestamp:

05/01/09 01:18:36 (3 years ago)

Author:

Andrey Prikaznov

Message:

 

File:

• trunk/admin/memb_levels.php (modified) (12 diffs)

trunk/admin/memb_levels.php

@@ -135 +135 @@
     if($membershipID <= 0) return '';
 
-    $resMemLevel = mysql_query("SELECT `Icon`, `Removable` FROM `sys_acl_levels` WHERE ID = $membershipID");
+    $resMemLevel = db_res("SELECT `Icon`, `Removable` FROM `sys_acl_levels` WHERE ID = $membershipID");
 
     if(mysql_num_rows($resMemLevel) < 1) {
@@ -150 +150 @@
     //check if there are still members using this membership
 
-    $resMaxDateExpires = @mysql_query("
+    $resMaxDateExpires = db_res("
         SELECT UNIX_TIMESTAMP(MAX(DateExpires)) as MaxDateExpires
         FROM `sys_acl_levels_members` WHERE IDLevel = $membershipID");
@@ -169 +169 @@
 
     @unlink(BX_DIRECTORY_PATH_ROOT . 'media/images/membership/' . $aRemovable['Icon']);
-    @mysql_query("DELETE FROM `sys_acl_level_prices` WHERE IDLevel = $membershipID");
-    @mysql_query("DELETE FROM `sys_acl_matrix` WHERE IDLevel = $membershipID");
-    @mysql_query("DELETE FROM `sys_acl_levels` WHERE ID = $membershipID");
-
-    if(mysql_affected_rows() > 0) {
+    db_res("DELETE FROM `sys_acl_level_prices` WHERE IDLevel = $membershipID");
+    db_res("DELETE FROM `sys_acl_matrix` WHERE IDLevel = $membershipID");
+    db_res("DELETE FROM `sys_acl_levels` WHERE ID = $membershipID");
+
+    if(db_affected_rows() > 0) {
         return "\n<div class=\"actionSuccess\">Membership has been deleted</div>";
     }
@@ -187 +187 @@
     if($membershipID <= 0) return '';
 
-    $resMemLevel = mysql_query("SELECT Purchasable FROM `sys_acl_levels` WHERE ID = $membershipID");
+    $resMemLevel = db_res("SELECT Purchasable FROM `sys_acl_levels` WHERE ID = $membershipID");
 
     if(mysql_num_rows($resMemLevel) < 1) {
@@ -202 +202 @@
     }
 
-    @mysql_query("UPDATE `sys_acl_levels` SET Active = '$active' WHERE ID = $membershipID");
-
-    if(mysql_affected_rows() <= 0){
+    db_res("UPDATE `sys_acl_levels` SET Active = '$active' WHERE ID = $membershipID");
+
+    if(db_affected_rows() <= 0){
         $de = $active ? '' : 'de';
         return "\n<div class=\"actionFailure\">Error: membership has not been {$de}activated</div>";
@@ -441 +441 @@
     if($days < 0 || $price <= 0) return "\n<div class=\"actionFailure\">Error: payment option has not been added</div>";
 
-    @mysql_query("INSERT INTO `sys_acl_level_prices` (IDLevel, Days, Price) VALUES ($membershipID, $days, $price)");
-
-    if(mysql_affected_rows() > 0)
+    db_res("INSERT INTO `sys_acl_level_prices` (IDLevel, Days, Price) VALUES ($membershipID, $days, $price)");
+
+    if(db_affected_rows() > 0)
     {
         if ( $days > 0 )
@@ -465 +465 @@
     if($membershipID <= 0 || $days < 0) return '';
 
-    @mysql_query("DELETE FROM `sys_acl_level_prices` WHERE IDLevel = $membershipID AND Days = $days");
-
-    if(mysql_affected_rows() > 0)
+    db_res("DELETE FROM `sys_acl_level_prices` WHERE IDLevel = $membershipID AND Days = $days");
+
+    if(db_affected_rows() > 0)
     {
         if ( $days > 0 )
@@ -489 +489 @@
     //check if membership can be purchased
 
-    $resMemLevel = mysql_query("SELECT Purchasable FROM `sys_acl_levels` WHERE ID = $membershipID");
+    $resMemLevel = db_res("SELECT Purchasable FROM `sys_acl_levels` WHERE ID = $membershipID");
 
     if(mysql_num_rows($resMemLevel) < 1) {
@@ -594 +594 @@
     if($membershipID <= 0 || $actionID <= 0) return '';
 
-    @mysql_query("INSERT INTO `sys_acl_matrix`
+    db_res("INSERT INTO `sys_acl_matrix`
                   (IDLevel, IDAction, AllowedCount, AllowedPeriodLen, AllowedPeriodStart, AllowedPeriodEnd)
                   VALUES ($membershipID, $actionID, NULL, NULL, NULL, NULL)");
 
-    if(mysql_affected_rows() > 0)
+    if(db_affected_rows() > 0)
         return $msgAdded;
     else
@@ -614 +614 @@
     if($membershipID <= 0 || $actionID <= 0) return '';
 
-    @mysql_query("DELETE FROM `sys_acl_matrix` WHERE IDLevel = $membershipID AND IDAction = $actionID");
-
-    if(mysql_affected_rows() > 0)
+    db_res("DELETE FROM `sys_acl_matrix` WHERE IDLevel = $membershipID AND IDAction = $actionID");
+
+    if(db_affected_rows() > 0)
         return $msgDeleted;
     else
@@ -660 +660 @@
     $periodEnd = "FROM_UNIXTIME($periodEnd)";
 
-    @mysql_query("
+    db_res("
         UPDATE  `sys_acl_matrix`
         SET     AllowedCount = $cnt,
@@ -669 +669 @@
         WHERE IDLevel = $membershipID AND IDAction = $actionID");
 
-    if(mysql_affected_rows() > 0) {
+    if(db_affected_rows() > 0) {
         return $msgUpdated;
     }else {