[ PHPXref.com ] [ Generated: Sun Jul 20 19:04:52 2008 ] [ OneCMS 2.3 ]
[ Index ]     [ Variables ]     [ Functions ]     [ Classes ]     [ Constants ]     [ Statistics ]

title

Body

[close]

/ -> a_systems.php (source)

   1  <?php
   2  include  ("config.php");
   3  if ($ipbancheck3 == "0") {if ($numv == "0"){
   4      if ($warn == $naum) {
   5      echo "You are banned from the Admin CP...now go away!";
   6  } else {
   7  
   8  if(!isset($_GET['page'])){
   9      $page = 1;
  10  } else {
  11      $page = $_GET['page'];
  12  }
  13  
  14  $from = (($page * $max_results) - $max_results);echo '<SCRIPT LANGUAGE="JavaScript">var checkflag = "false";function check(field) {if (checkflag == "false") {for (i = 0; i < field.length; i++) {field[i].checked = true;}checkflag = "true";return "Uncheck All"; }else {for (i = 0; i < field.length; i++) {field[i].checked = false; }checkflag = "false";return "Check All"; }}</script>';
  15  
  16  if ((($userlevel == "3") or ($userlevel == "4") or ($userlevel == "5"))) {
  17      echo "Sorry $username, but you do not have permission to manage systems. You are only a $level.";
  18  } else {
  19  
  20  echo "<center><a href='a_systems.php?view=add'>Add Systems</a> | <a href='a_systems.php'>Manage Systems</a> | <a href='a_systems.php?view=search'>Search</a></center><br><br>";
  21  
  22  if ($_GET['view'] == "search") {
  23  
  24      echo "<title>OneCMS - www.insanevisions.com/onecms > Systems > Search</title>";
  25  
  26      echo "<form action='a_systems.php?view=search'  method='post'><table cellspacing=\"0\" cellpadding=\"3\" border=\"0\" align=\"center\"><tr><td>Search for system</td><td><input type='text' name='search'></td><td><input type='submit' name='Submit' value='Search'></td></tr></table></form>";
  27  
  28      echo "<form action='a_systems.php?view=manage' name='form1' method='post'><table cellspacing=\"0\" cellpadding=\"3\" border=\"0\" align=\"center\"><tr><td><b>System Name</b></td><td><b>Abbreviation</b></td><td><b>Status</b></td><td><b><b>Edit</b></td><td><b>Delete</b></td></tr><center><div align=\"center\">";
  29  
  30      $query="SELECT * FROM onecms_systems WHERE name LIKE '%" . $_POST['search'] . "%' ORDER BY `id` DESC LIMIT $from, $max_results";
  31      $result=mysql_query($query);
  32      while($row = mysql_fetch_array($result)) {
  33          $id = "$row[id]";
  34          $name2 = "$row[name]";
  35          $name = stripslashes($name2);
  36          echo "<tr><td><a href='index.php?id=systems&sid=".$row[abr]."' target='popup'>$name</a></td><td>$row[abr]</td><td>";
  37          if ($row[status]) {
  38          echo "Offline";
  39          } else {
  40          echo "Online";
  41          }
  42          echo "</td><td><input type=\"checkbox\" name=\"id[]\" value=\"$id\"></td><td><input type=\"checkbox\" name=\"delete[]\" value=\"$id\"></td></tr>";
  43      }
  44  
  45  echo "<tr><td><div align='right'><input type='submit' name='submit' value='Submit'></td><td><input type=button value='Check All' onClick='this.value=check(this.form)'></td><td><a href=\"a_systems.php?view=add\">Add system</a></td></tr></form></table><br><br>";
  46  
  47  $total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM onecms_systems WHERE name LIKE '%" . $_POST['search'] . "%'"),0);
  48  
  49  $total_pages = ceil($total_results / $max_results);
  50  
  51  echo "<center>Select a Page<br />";
  52  
  53  // Build Previous Link

  54  if($page > 1){
  55      $prev = ($page - 1);
  56      echo "<a href=\"".$HTTP_SERVER_VARS['REQUEST_URI']."?page=$prev\"><<Previous</a>&nbsp;";
  57  }
  58  
  59  for($i = 1; $i <= $total_pages; $i++){
  60      if(($page) == $i){
  61          echo "$i&nbsp;";
  62          } else {
  63              echo "<a href=\"".$HTTP_SERVER_VARS['REQUEST_URI']."?page=$i\">$i</a>&nbsp;";if (($i/25) == (int)($i/25)) {echo "<br>";}
  64      }
  65  }
  66  
  67  // Build Next Link

  68  if($page < $total_pages){
  69      $next = ($page + 1);
  70      echo "<a href=\"".$HTTP_SERVER_VARS['REQUEST_URI']."?page=$next\">Next>></a>";
  71  }
  72  echo "</center>
  73  
  74      </span>
  75    </div></div></center>";
  76  
  77  }
  78  
  79  if ($_GET['view'] == "") {
  80  
  81                  echo "<title>OneCMS - www.insanevisions.com/onecms > Manage Systems</title>";
  82  
  83      echo "<form action='a_systems.php?view=search'  method='post'><table cellspacing=\"0\" cellpadding=\"3\" border=\"0\" align=\"center\"><tr><td>Search for system</td><td><input type='text' name='search'></td><td><input type='submit' name='Submit' value='Search'></td></tr></table></form>";
  84  
  85      echo "<form action='a_systems.php?view=manage' name='form1' method='post'><table cellspacing=\"0\" cellpadding=\"3\" border=\"0\" align=\"center\"><tr><td><b>System Name</b></td><td><b>Abbreviation</b></td><td><b>Status</b></td><td><b><b>Edit</b></td><td><b>Delete</b></td></tr>";
  86  
  87  $query="SELECT * FROM onecms_systems ORDER BY `id` DESC LIMIT $from, $max_results";
  88      $result=mysql_query($query);
  89      while($row = mysql_fetch_array($result)) {
  90          $id = "$row[id]";
  91          $name2 = "$row[name]";
  92          $name = stripslashes($name2);
  93          echo "<tr><td><a href='index.php?id=systems&sid=".$row[abr]."' target='popup'>$name</a></td><td>$row[abr]</td><td>";
  94          if ($row[status]) {
  95          echo "Offline";
  96          } else {
  97          echo "Online";
  98          }
  99          echo "</td><td><input type=\"checkbox\" name=\"id[]\" value=\"$id\"></td><td><input type=\"checkbox\" name=\"delete[]\" value=\"$id\"></td></tr>";
 100      }
 101  
 102  echo "<tr><td><div align='right'><input type='submit' name='submit' value='Submit'></td><td><input type=button value='Check All' onClick='this.value=check(this.form)'></td><td><a href=\"a_systems.php?view=add\">Add system</a></td></tr></form></table><br><br>";
 103  $total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM onecms_systems"),0);
 104  
 105  $total_pages = ceil($total_results / $max_results);
 106  
 107  echo "<center>Select a Page<br />";
 108  
 109  // Build Previous Link

 110  if($page > 1){
 111      $prev = ($page - 1);
 112      echo "<a href=\"".$HTTP_SERVER_VARS['REQUEST_URI']."?page=$prev\"><<Previous</a>&nbsp;";
 113  }
 114  
 115  for($i = 1; $i <= $total_pages; $i++){
 116      if(($page) == $i){
 117          echo "$i&nbsp;";
 118          } else {
 119              echo "<a href=\"".$HTTP_SERVER_VARS['REQUEST_URI']."?page=$i\">$i</a>&nbsp;";if (($i/25) == (int)($i/25)) {echo "<br>";}
 120      }
 121  }
 122  
 123  // Build Next Link

 124  if($page < $total_pages){
 125      $next = ($page + 1);
 126      echo "<a href=\"".$HTTP_SERVER_VARS['REQUEST_URI']."?page=$next\">Next>></a>";
 127  }
 128  echo "</center>
 129      </span>
 130    </div></div></center>";
 131  
 132  }
 133  
 134  if (($_GET['view'] == "manage") && ($_POST['delete'])) {
 135  
 136  echo '<SCRIPT LANGUAGE="JavaScript">
 137  var agree=confirm("Confirm Deletion?");
 138  if (agree)
 139  document.write("");
 140  else
 141  history.go(-1);
 142  </SCRIPT>';
 143  
 144  while (list(, $val) = each ($_POST['delete'])) {
 145  
 146      $delete2 = mysql_query("DELETE FROM onecms_content WHERE systems = '$val'") or die("<font color='red'><b>A fatal MySQL error occured</b></font>.<br><br><b>Query:</b> ".$delete2."<br><b>Error:</b> (".mysql_errno().")".mysql_error());
 147  
 148      $delete = mysql_query("DELETE FROM onecms_systems WHERE id = '$val'") or die("<font color='red'><b>A fatal MySQL error occured</b></font>.<br><br><b>Query:</b> ".$delete."<br><b>Error:</b> (".mysql_errno().")".mysql_error());
 149  }
 150  if (($delete == TRUE) && ($delete2 == TRUE)) {
 151  echo re_direct("1500", "a_systems.php");
 152  echo "The system(s) have been deleted. <a href=\"a_systems.php\">Manage Systems</a>";
 153  }
 154  }
 155  
 156  if (($_GET['view'] == "manage") && ($_POST['delete'] == "") && ($_GET['edit'] == "")) {
 157  
 158      echo "<form action='a_systems.php?view=manage&edit=2' name='form1' method='post'><table cellspacing=\"0\" cellpadding=\"3\" border=\"0\" align=\"left\">";
 159  
 160      while (list(, $val) = each ($_POST['id'])) {
 161      $query="SELECT * FROM onecms_systems WHERE id = '$val'";
 162      $result=mysql_query($query);
 163      while($row2 = mysql_fetch_array($result)) {
 164          $namea = "$row2[name]";
 165          $abr = "$row2[abr]";
 166          $icon = "$row2[icon]";
 167  
 168      echo "<input type=\"hidden\" name=\"id[]\" value=\"$val\"><tr><td><b><center>Item #".$val."</b></center></td></tr><tr><td><b>Name</b></td><td><input type='text' name=\"name_$val\" value=\"$namea\"></td></tr><tr><td><b>Abbreviation</b></td><td><input type='text' name=\"abr_$val\" value=\"$abr\"></td></tr><tr><td><b>System Icon</b></td><td><input type='text' name='img_".$val."' value='".$icon."'></td></tr><tr><td><b>System Content Offline?</b></td><td><input type='checkbox' name='status_".$val."' value='off'";
 169      
 170      if ($row2[status]) {
 171      echo " checked";
 172      }
 173      echo "></td></tr><tr><td><b>Skin</b></td><td><select name='skin_".$val."'><option value=''>-------</option>";
 174  
 175      $sql = mysql_query("SELECT * FROM onecms_skins ORDER BY `id` DESC");
 176      while($r = mysql_fetch_array($sql)) {
 177          if ($r[id] == $row2[skin]) {
 178          echo "<option value='".$r[id]."' selected>-- ".$r[name]." --</option>";
 179          } else {
 180          echo "<option value='".$r[id]."'>".$r[name]."</option>";
 181          }
 182      }
 183      echo "</select></td></tr>";
 184      }
 185      }
 186              echo "<tr><td><input type=\"submit\" name=\"Add\" value=\"Submit Changes\"></td></tr></form></table>";
 187  }
 188  
 189  if (($_GET['view'] == "manage") && ($_GET['edit'] == "2")) {
 190  
 191     while (list(, $val) = each ($_POST['id'])) {
 192     $r = mysql_query("UPDATE onecms_systems SET name = '".$_POST["name_$val"]."', abr = '".$_POST["abr_$val"]."', icon = '".$_POST["img_$val"]."', status = '".$_POST["status_$val"]."', skin = '".$_POST["skin_$val"]."' WHERE id = '$val'") or die("<font color='red'><b>A fatal MySQL error occured</b></font>.<br><br><b>Query:</b> ".$r."<br><b>Error:</b> (".mysql_errno().")".mysql_error());
 193     }
 194  if ($r == TRUE) {
 195  echo re_direct("1500", "a_systems.php");
 196  echo "The systems has been updated. <a href=\"a_systems.php\">Manage Systems</a>";
 197  }
 198  }    
 199  
 200  if ($_GET['view'] == "add") {
 201          echo "<form action=\"a_systems.php?view=add&cat=".$_GET['cat']."\" name='form1' method='post'><table cellspacing=\"0\" cellpadding=\"3\" border=\"0\" align=\"center\"><tr><td>How many systems to add?</td><td><input type='text' name='search'></td><td><input type='submit' name='addd' value='Submit'></td></tr></table></form>";
 202  
 203          echo "<form action='a_systems.php?view=add2' name='form1' method='post'><table cellspacing=\"0\" cellpadding=\"3\" border=\"0\" align=\"left\">";
 204  
 205      if ($_POST['search']) {
 206  
 207  echo "<input type=\"hidden\" name=\"s\" value='".$_POST['search']."'>";
 208  
 209      for($i = 0; $i < $_POST['search']; $i = $i+1) {
 210      echo "<tr><td><b><center>System #".$i."</b></center></td></tr><tr><td>Name</td><td><input type=\"text\" name='name_".$i."'></td></tr><tr><td>Abbreviation</td><td><input type=\"text\" name='abr_".$i."'></td></tr><tr><td>System Icon</td><td><input type='text' name='img_".$i."'></td></tr><tr><td>System Content Offline?</td><td><input type='checkbox' name='status_".$i."' value='off'></td></tr><tr><td><b>Skin</b></td><td><select name='skin_".$i."'><option value=''>-------</option>";
 211  
 212      $sql = mysql_query("SELECT * FROM onecms_skins ORDER BY `id` DESC");
 213      while($r = mysql_fetch_array($sql)) {
 214          echo "<option value='".$r[id]."'>".$r[name]."</option>";
 215      }
 216      echo "</select></td></tr>";
 217      }
 218              echo "<tr><td><input type=\"submit\" name=\"Add\" value=\"Add\"></td></tr></form>";
 219      }
 220      echo "</table>";
 221  }
 222  
 223      if ($_GET['view'] == "add2") {
 224  
 225     $time = date("Ymd");
 226     for($i = 0; $i < $_POST['s']; $i = $i+1) {
 227     $r = mysql_query("INSERT INTO onecms_systems VALUES ('null', '".$_POST["name_$i"]."', '".$_POST["abr_$i"]."', '".$_POST["img_$i"]."', '".$_POST["status_$i"]."', '".$_POST["skin_$i"]."')") or die("<font color='red'><b>A fatal MySQL error occured</b></font>.<br><br><b>Query:</b> ".$r."<br><b>Error:</b> (".mysql_errno().")".mysql_error());
 228     }
 229  if ($r == TRUE) {
 230  echo re_direct("1500", "a_systems.php");
 231  echo "The system(s) have been created. <a href=\"a_systems.php\">Manage Systems</a>";
 232  }
 233  }
 234  }
 235  }
 236  }
 237  }include  ("a_footer.inc");
 238  ?>


[ Powered by PHPXref - Served by Debian GNU/Linux ]