1<?php 2 3//includes 4 require_once "root.php"; 5 require_once "resources/require.php"; 6 7//check permissions 8 require_once "resources/check_auth.php"; 9 if (permission_exists('access_control_view')) { 10 //access granted 11 } 12 else { 13 echo "access denied"; 14 exit; 15 } 16 17//add multi-lingual support 18 $language = new text; 19 $text = $language->get(); 20 21//get variables used to control the order 22 $order_by = $_GET["order_by"]; 23 $order = $_GET["order"]; 24 25//additional includes 26 require_once "resources/header.php"; 27 require_once "resources/paging.php"; 28 29//prepare to page the results 30 $sql = "select count(*) as num_rows from v_access_controls "; 31 if (strlen($order_by)> 0) { $sql .= "order by $order_by $order "; } 32 $prep_statement = $db->prepare($sql); 33 if ($prep_statement) { 34 $prep_statement->execute(); 35 $row = $prep_statement->fetch(PDO::FETCH_ASSOC); 36 if ($row['num_rows'] > 0) { 37 $num_rows = $row['num_rows']; 38 } 39 else { 40 $num_rows = '0'; 41 } 42 } 43 44//prepare to page the results 45 $rows_per_page = ($_SESSION['domain']['paging']['numeric'] != '') ? $_SESSION['domain']['paging']['numeric'] : 50; 46 $param = ""; 47 $page = $_GET['page']; 48 if (strlen($page) == 0) { $page = 0; $_GET['page'] = 0; } 49 list($paging_controls, $rows_per_page, $var3) = paging($num_rows, $param, $rows_per_page); 50 $offset = $rows_per_page * $page; 51 52//get the list 53 $sql = "select * from v_access_controls "; 54 if (strlen($order_by)> 0) { $sql .= "order by $order_by $order "; } 55 $sql .= "limit $rows_per_page offset $offset "; 56 $prep_statement = $db->prepare(check_sql($sql)); 57 $prep_statement->execute(); 58 $result = $prep_statement->fetchAll(PDO::FETCH_NAMED); 59 unset ($prep_statement, $sql); 60 61//alternate the row style 62 $c = 0; 63 $row_style["0"] = "row_style0"; 64 $row_style["1"] = "row_style1"; 65 66//show the content 67 echo "<table width='100%' border='0'>\n"; 68 echo " <tr>\n"; 69 echo " <td width='50%' align='left' nowrap='nowrap'><b>".$text['title-access_controls']."</b></td>\n"; 70 echo " <td width='50%' align='right'> </td>\n"; 71 echo " </tr>\n"; 72 echo " <tr>\n"; 73 echo " <td align='left' colspan='2'>\n"; 74 echo " ".$text['description-access_control']."<br /><br />\n"; 75 echo " </td>\n"; 76 echo " </tr>\n"; 77 echo "</table>\n"; 78 79 echo "<table class='tr_hover' width='100%' border='0' cellpadding='0' cellspacing='0'>\n"; 80 echo "<tr>\n"; 81 echo th_order_by('access_control_name', $text['label-access_control_name'], $order_by, $order); 82 echo th_order_by('access_control_default', $text['label-access_control_default'], $order_by, $order); 83 echo th_order_by('access_control_description', $text['label-access_control_description'], $order_by, $order); 84 echo "<td class='list_control_icons'>"; 85 if (permission_exists('access_control_add')) { 86 echo "<a href='access_control_edit.php' alt='".$text['button-add']."'>$v_link_label_add</a>"; 87 } 88 else { 89 echo " \n"; 90 } 91 echo "</td>\n"; 92 echo "<tr>\n"; 93 94 if (is_array($result)) { 95 foreach($result as $row) { 96 if (permission_exists('access_control_edit')) { 97 $tr_link = "href='access_control_edit.php?id=".$row['access_control_uuid']."'"; 98 } 99 echo "<tr ".$tr_link.">\n"; 100 echo " <td valign='top' class='".$row_style[$c]."'>".$row['access_control_name']." </td>\n"; 101 echo " <td valign='top' class='".$row_style[$c]."'>".$row['access_control_default']." </td>\n"; 102 echo " <td valign='top' class='".$row_style[$c]."'>".$row['access_control_description']." </td>\n"; 103 echo " <td class='list_control_icons'>"; 104 if (permission_exists('access_control_edit')) { 105 echo "<a href='access_control_edit.php?id=".$row['access_control_uuid']."' alt='".$text['button-edit']."'>$v_link_label_edit</a>"; 106 } 107 if (permission_exists('access_control_delete')) { 108 echo "<a href='access_control_delete.php?id=".$row['access_control_uuid']."' alt='".$text['button-delete']."' onclick=\"return confirm('".$text['confirm-delete']."')\">$v_link_label_delete</a>"; 109 } 110 echo " </td>\n"; 111 echo "</tr>\n"; 112 if ($c==0) { $c=1; } else { $c=0; } 113 } //end foreach 114 unset($sql, $result, $row_count); 115 } //end if results 116 117 echo "<tr>\n"; 118 echo "<td colspan='4' align='left'>\n"; 119 echo " <table width='100%' cellpadding='0' cellspacing='0'>\n"; 120 echo " <tr>\n"; 121 echo " <td width='33.3%' nowrap='nowrap'> </td>\n"; 122 echo " <td width='33.3%' align='center' nowrap='nowrap'>$paging_controls</td>\n"; 123 echo " <td class='list_control_icons'>"; 124 if (permission_exists('access_control_add')) { 125 echo "<a href='access_control_edit.php' alt='".$text['button-add']."'>$v_link_label_add</a>"; 126 } 127 else { 128 echo " "; 129 } 130 echo " </td>\n"; 131 echo " </tr>\n"; 132 echo " </table>\n"; 133 echo "</td>\n"; 134 echo "</tr>\n"; 135 echo "</table>"; 136 echo "<br /><br />"; 137 138//include the footer 139 require_once "resources/footer.php"; 140 141?>