Changeset 9969 for trunk/admin/memb_levels.php

Timestamp:

04/06/09 03:52:46 (3 years ago)

Author:

Andrey Prikaznov

Message:

 

File:

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

trunk/admin/memb_levels.php

@@ -135 +135 @@
     if(!get_magic_quotes_gpc()) $membershipName = addslashes($membershipName);
 
-    @mysql_query("INSERT INTO MemLevels (Name) VALUES ('$membershipName')");
+    @mysql_query("INSERT INTO `sys_acl_levels` (Name) VALUES ('$membershipName')");
 
     if(mysql_affected_rows() > 0) {
@@ -151 +151 @@
     if($membershipID <= 0) return '';
 
-    $resMemLevel = mysql_query("SELECT Removable FROM MemLevels WHERE ID = $membershipID");
+    $resMemLevel = mysql_query("SELECT Removable FROM `sys_acl_levels` WHERE ID = $membershipID");
 
     if(mysql_num_rows($resMemLevel) < 1) {
@@ -186 +186 @@
     }
 
-    @mysql_query("DELETE FROM MemLevelPrices WHERE IDLevel = $membershipID");
-    @mysql_query("DELETE FROM MemLevelActions WHERE IDLevel = $membershipID");
-    @mysql_query("DELETE FROM MemLevels WHERE ID = $membershipID");
+    @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) {
@@ -204 +204 @@
     if($membershipID <= 0) return '';
 
-    $resMemLevel = mysql_query("SELECT Purchasable FROM MemLevels WHERE ID = $membershipID");
+    $resMemLevel = mysql_query("SELECT Purchasable FROM `sys_acl_levels` WHERE ID = $membershipID");
 
     if(mysql_num_rows($resMemLevel) < 1) {
@@ -219 +219 @@
     }
 
-    @mysql_query("UPDATE MemLevels SET Active = '$active' WHERE ID = $membershipID");
+    @mysql_query("UPDATE `sys_acl_levels` SET Active = '$active' WHERE ID = $membershipID");
 
     if(mysql_affected_rows() <= 0){
@@ -262 +262 @@
         </tr>
 <?
-    $resMemLevels = db_res ( "SELECT ID, Name, Active, Purchasable, Removable FROM MemLevels ORDER BY ID" );
+    $resMemLevels = db_res ( "SELECT ID, Name, Active, Purchasable, Removable FROM `sys_acl_levels` ORDER BY ID" );
 
     if (mysql_num_rows($resMemLevels) <= 0) {
@@ -357 +357 @@
     if($days < 0 || $price <= 0) return "\n<div class=\"actionFailure\">Error: payment option has not been added</div>";
 
-    @mysql_query("INSERT INTO MemLevelPrices (IDLevel, Days, Price) VALUES ($membershipID, $days, $price)");
+    @mysql_query("INSERT INTO `sys_acl_level_prices` (IDLevel, Days, Price) VALUES ($membershipID, $days, $price)");
 
     if(mysql_affected_rows() > 0)
@@ -381 +381 @@
     if($membershipID <= 0 || $days < 0) return '';
 
-    @mysql_query("DELETE FROM MemLevelPrices WHERE IDLevel = $membershipID AND Days = $days");
+    @mysql_query("DELETE FROM `sys_acl_level_prices` WHERE IDLevel = $membershipID AND Days = $days");
 
     if(mysql_affected_rows() > 0)
@@ -405 +405 @@
     //check if membership can be purchased
 
-    $resMemLevel = mysql_query("SELECT Purchasable FROM MemLevels WHERE ID = $membershipID");
+    $resMemLevel = mysql_query("SELECT Purchasable FROM `sys_acl_levels` WHERE ID = $membershipID");
 
     if(mysql_num_rows($resMemLevel) < 1) {
@@ -430 +430 @@
     if($_POST['delete_payment_option']) echo deletePaymentOption($membershipID, $_POST['delete_payment_days']);
 
-    $resLevelPrices = db_res("SELECT Days, Price FROM MemLevelPrices WHERE IDLevel = $membershipID ORDER BY Days");
+    $resLevelPrices = db_res("SELECT Days, Price FROM `sys_acl_level_prices` WHERE IDLevel = $membershipID ORDER BY Days");
 ?>
     <div align="right">
@@ -510 +510 @@
     if($membershipID <= 0 || $actionID <= 0) return '';
 
-    @mysql_query("INSERT INTO MemLevelActions
+    @mysql_query("INSERT INTO `sys_acl_matrix`
                   (IDLevel, IDAction, AllowedCount, AllowedPeriodLen, AllowedPeriodStart, AllowedPeriodEnd)
                   VALUES ($membershipID, $actionID, NULL, NULL, NULL, NULL)");
@@ -530 +530 @@
     if($membershipID <= 0 || $actionID <= 0) return '';
 
-    @mysql_query("DELETE FROM MemLevelActions WHERE IDLevel = $membershipID AND IDAction = $actionID");
+    @mysql_query("DELETE FROM `sys_acl_matrix` WHERE IDLevel = $membershipID AND IDAction = $actionID");
 
     if(mysql_affected_rows() > 0)
@@ -577 +577 @@
 
     @mysql_query("
-        UPDATE  MemLevelActions
+        UPDATE  `sys_acl_matrix`
         SET     AllowedCount = $cnt,
                 AllowedPeriodLen = $periodLen,
@@ -608 +608 @@
 <div class="sectionBody"><div style="padding: 10px"> -->
 <?
-    $resActions = db_res("SELECT ID, Name FROM MemActions ORDER BY Name");
+    $resActions = db_res("SELECT ID, Name FROM `sys_acl_actions` ORDER BY Name");
 
     $arrActions = array();
@@ -639 +639 @@
                 AdditionalParamName,
                 AdditionalParamValue
-        FROM    MemLevelActions
-                INNER JOIN MemActions
-                ON MemLevelActions.IDAction = MemActions.ID
-        WHERE MemLevelActions.IDLevel = $membershipID
-        ORDER BY MemActions.Name");
+        FROM    `sys_acl_matrix`
+                INNER JOIN `sys_acl_actions`
+                ON `sys_acl_matrix`.IDAction = `sys_acl_actions`.ID
+        WHERE `sys_acl_matrix`.IDLevel = $membershipID
+        ORDER BY `sys_acl_actions`.Name");
 
     $arrLevelActions = array();