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

title

Body

[close]

/ -> a_pages.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 pages. You are only a $level.";
  18  } else {
  19  
  20      echo "<center><a href=\"a_pages.php?view=add1\">Add pages</a> | <a href=\"a_pages.php?view=add2\">Add pages (to content)</a> | <a href='a_pages.php'>Manage Pages</a></center><br><br>";
  21  
  22      if ($_GET['view'] == "") {
  23  
  24      echo "<title>OneCMS - www.insanevisions.com/onecms > Page Manager</title>";
  25  
  26      echo "<form action='a_pages.php?view=search'  method='post'><table cellspacing=\"0\" cellpadding=\"3\" border=\"0\" align=\"center\"><tr><td>Search for page</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_pages.php?view=manage' name='form1' method='post'><table cellspacing=\"0\" cellpadding=\"3\" border=\"0\" align=\"center\"><tr><td><b>Name</b></td><td><b><b>Edit</b></td><td><b>Delete</b></td></tr>";
  29  
  30  $query="SELECT * FROM onecms_pages 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          $url = "$row[url]";
  36          $name = stripslashes($name2);
  37          if ($row[type] == "backend") {
  38          echo "<tr><td><a href='".$pagepart1."".$url."".$pagepart2."' target='popup'>$name</a></td><td><input type=\"checkbox\" name=\"id[]\" value=\"$id\"></td><td><input type=\"checkbox\" name=\"delete[]\" value=\"$id\"></td></tr>";
  39          } else {
  40          echo "<tr><td><a href='pages.php?id=".$id."' target='popup'>$name</a></td><td><input type=\"checkbox\" name=\"id[]\" value=\"$id\"></td><td><input type=\"checkbox\" name=\"delete[]\" value=\"$id\"></td></tr>";
  41          }
  42      }
  43  
  44  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></tr></form></table><br><br>";
  45  $total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM onecms_pages WHERE type = 'backend'"),0);
  46  
  47  $total_pages = ceil($total_results / $max_results);
  48  
  49  echo "<center>Select a Page<br>";
  50  
  51  // Build Previous Link

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

  66  if($page < $total_pages){
  67      $next = ($page + 1);
  68      echo "<a href=\"a_pages.php?page=$next\">Next>></a>";
  69  }
  70  echo "</center>";
  71  
  72  }
  73  
  74  if (($_GET['view'] == "add1") && ($_GET['add'] == "")) {
  75  echo "<form action=\"a_pages.php?view=add1\" method='post'><table cellspacing=\"0\" cellpadding=\"3\" border=\"0\" align=\"center\"><tr><td>How many pages to add?</td><td><input type='text' name='search'></td><td><input type='submit' name='addd' value='Submit'></td></tr></table></form>";
  76  
  77      if ($_POST['search']) {
  78  
  79  echo "<form action='a_pages.php?view=add1&add=yes' name='form1' method='post'><table cellspacing=\"0\" cellpadding=\"3\" border=\"0\" align=\"left\"><input type=\"hidden\" name=\"s\" value='".$_POST['search']."'>";
  80  
  81      for($i = 0; $i < $_POST['search']; $i = $i+1) {
  82      echo "<tr><td><b><center>Page #".$i."</b></center></td></tr><tr><td>Page Name</td><td><input type=\"text\" name='name_".$i."'></td></tr><tr><td>Coding</td><td><textarea name='content_".$i."' cols='30' rows='12'></textarea></td></tr>";
  83      echo "<tr><td>Page Online?</td><td><select name='online_".$i."' multiple><option value='Yes'>Yes</option><option value='No'>No</option></select></td></tr><tr><td>URL (ex. contact)</td><td><input type='text' name='url_".$i."'></td></tr>";
  84  }
  85  echo "<tr><td><input type=\"submit\" name=\"Add\" value=\"Add\"></td></tr></form></table>";
  86  }
  87  }
  88  
  89  if (($_GET['view'] == "add2") && ($_GET['add'] == "")) {
  90  echo "<form action=\"a_pages.php?view=add2\" method='post'><table cellspacing=\"0\" cellpadding=\"3\" border=\"0\" align=\"center\"><tr><td>How many pages to add?</td><td><input type='text' name='search'></td><td><input type='submit' name='addd' value='Submit'></td></tr></table></form>";
  91  
  92      if ($_POST['search']) {
  93  
  94  echo "<form action='a_pages.php?view=add2&add=yes' name='form1' method='post'><table cellspacing=\"0\" cellpadding=\"3\" border=\"0\" align=\"left\"><input type=\"hidden\" name=\"s\" value='".$_POST['search']."'>";
  95  
  96      for($i = 0; $i < $_POST['search']; $i = $i+1) {
  97      echo "<tr><td><b><center>Page #".$i."</b></center></td></tr>";
  98      echo "<tr><td>Content</td><td><textarea name='content_".$i."' cols='30' rows='12'></textarea></td></tr>";
  99      echo "<tr><td>Page Online?</td><td><select name='online_".$i."' multiple><option value='Yes'>Yes</option><option value='No'>No</option></select></td></tr><tr><td>Content for this page to be linked to</td><td><select name='url_".$i."'>";
 100      
 101      $sql = mysql_query("SELECT * FROM onecms_content ORDER BY `id` DESC");
 102      while($row = mysql_fetch_array($sql)) {
 103  
 104      $check1 = mysql_query("SELECT * FROM onecms_cat WHERE name = '".$row[cat]."'");
 105      $check2 = mysql_num_rows($check1);
 106  
 107      if ($check2 == "1") {
 108  
 109      $perm = mysql_query("SELECT * FROM onecms_permissions WHERE username = '".$_COOKIE[username]."' AND ".$row[cat]." = 'yes'") or die(mysql_error());
 110      $numper = mysql_num_rows($perm);
 111  
 112      if ($numper > "0") {
 113          echo "<option value=\"".$row[id]."\">".$row[name]."</option>";
 114      }
 115      }
 116      }
 117  
 118      echo "</td></tr>";
 119  }
 120  echo "<tr><td><input type=\"submit\" name=\"Add\" value=\"Add\"></td></tr></form></table>";
 121  }
 122  }
 123  
 124  if (($_GET['view'] == "add1") && ($_GET['add'] == "yes")) {
 125  
 126     for($i = 0; $i < $_POST['s']; $i = $i+1) {
 127  
 128     $r = mysql_query("INSERT INTO onecms_pages VALUES ('null', '".$_POST["name_$i"]."', '".$_POST["url_$i"]."', '".addslashes($_POST["content_$i"])."', '".$_POST["online_$i"]."', 'backend')") 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());
 129     }
 130  if ($r == TRUE) {
 131  echo re_direct("1500", "a_pages.php");
 132  echo "The page(s) have been created. <a href=\"a_pages.php\">Return to Page Manager Home</a>";
 133  }
 134  }
 135  
 136  if (($_GET['view'] == "add2") && ($_GET['add'] == "yes")) {
 137  
 138     for($i = 0; $i < $_POST['s']; $i = $i+1) {
 139  
 140     $findea = mysql_query("SELECT * FROM onecms_pages WHERE url = '".$_POST["url_$i"]."' AND type = 'frontend'");
 141     $page = mysql_num_rows($findea);
 142     
 143     $pagename = $page + 2;
 144  
 145  
 146     $r = mysql_query("INSERT INTO onecms_pages VALUES ('null', '".$pagename."', '".$_POST["url_$i"]."', '".addslashes($_POST["content_$i"])."', '".$_POST["online_$i"]."', 'frontend')") 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());
 147     }
 148  if ($r == TRUE) {
 149  echo re_direct("1500", "a_pages.php");
 150  echo "The page(s) have been created. <a href=\"a_pages.php\">Return to Page Manager Home</a>";
 151  }
 152  }
 153  if (($_GET['view'] == "manage") && ($_POST['id'] == "")) {
 154  echo '<SCRIPT LANGUAGE="JavaScript">
 155  var agree=confirm("Confirm Deletion?");
 156  if (agree)
 157  document.write("");
 158  else
 159  history.go(-1);
 160  </SCRIPT>';
 161  
 162  while (list(, $val) = each ($_POST['delete'])) {
 163      $delete = mysql_query("DELETE FROM onecms_pages 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());
 164  }
 165  if ($delete == TRUE) {
 166  echo re_direct("1500", "a_pages.php");
 167  echo "The page(s) have been deleted. <a href=\"a_pages.php\">Return to Page Manager Home</a>";
 168  }
 169  }
 170  if ((($_GET['view'] == "manage") && ($_POST['delete'] == "") && ($_GET['edit'] == ""))) {
 171  
 172      echo "<form action='a_pages.php?view=manage&edit=2' name='form1' method='post'><table cellspacing=\"0\" cellpadding=\"3\" border=\"0\" align=\"left\">";
 173  
 174      while (list(, $i) = each ($_POST['id'])) {
 175      $query="SELECT * FROM onecms_pages WHERE id = '$i'";
 176      $result=mysql_query($query);
 177      while($row2 = mysql_fetch_array($result)) {
 178  
 179      $row1 = mysql_fetch_row(mysql_query("SELECT name FROM onecms_content WHERE id = '".$row2[url]."'"));
 180  
 181   echo "<input type='hidden' name='id[]' value='".$row2[id]."'><tr><td><b><center>Page #".$i."</b></center></td></tr>";
 182   echo "<tr><td>Page Name</td><td><input type=\"text\" name='name_".$i."' value='".$row2[name]."'></td></tr><tr><td>Content</td><td><textarea name='content_".$i."' cols='30' rows='12'>".stripslashes($row2[content])."</textarea></td></tr><tr><td>Page Online?</td><td><select name='online_".$i."' multiple><option value='".$row2[online]."' selected>-- ".$row2[online]." --</option><option value='Yes'>Yes</option><option value='No'>No</option></select></td></tr>";
 183    if ($row2['type'] == "frontend") {
 184   echo "<tr><td>Content for this page to be linked to</td><td><select name='url_".$i."'><option value='".$row2[url]."' selected>-- ".$row1[0]." --</option>";
 185      
 186      $query="SELECT * FROM onecms_content";
 187      $result=mysql_query($query);
 188      while($row = mysql_fetch_array($result)) {
 189      $cat = "$row[cat]";
 190      $name = "$row[name]";
 191      $id = "$row[id]";
 192  
 193      $queryy = mysql_query("SELECT * FROM onecms_permissions WHERE username = '$username' AND ".$cat." = 'yes'") or die(mysql_error());
 194      $numb = mysql_num_rows($queryy);
 195  
 196      if ($numb == "0") {
 197          echo "";
 198      } else {
 199          echo "<option value=\"$id\">$name</option>";
 200      }
 201      }
 202  
 203      echo "</td></tr>";
 204      } else {
 205      echo "</tr><tr><td>URL (ex. contact)</td><td><input type='text' name='url_".$i."' value='".$row2[url]."'></td></tr>";
 206      }
 207  }
 208  }
 209  echo "<tr><td><input type=\"submit\" name=\"Modify\" value=\"Modify\"></td></tr></form></table>";
 210  
 211  }
 212  if ($_GET['view'] == "search") {
 213  
 214      echo "<title>OneCMS - www.insanevisions.com/onecms > Page Manager > Search</title>";
 215  
 216      echo "<form action='a_pages.php?view=search'  method='post'><table cellspacing=\"0\" cellpadding=\"3\" border=\"0\" align=\"center\"><tr><td>Search for page</td><td><input type='text' name='search'></td><td><input type='submit' name='Submit' value='Search'></td></tr></table></form>";
 217  
 218      echo "<form action='a_pages.php?view=manage' name='form1' method='post'><table cellspacing=\"0\" cellpadding=\"3\" border=\"0\" align=\"center\"><tr><td><b>Name</b></td><td><b><b>Edit</b></td><td><b>Delete</b></td></tr><center><div align=\"center\">";
 219  
 220      $query="SELECT * FROM onecms_pages WHERE name LIKE '%" . $_POST['search'] . "%' OR url LIKE '%" . $_POST['search'] . "%' ORDER BY `id` DESC LIMIT $from, $max_results";
 221      $result=mysql_query($query);
 222      while($row = mysql_fetch_array($result)) {
 223          $id = "$row[id]";
 224          $name2 = "$row[name]";
 225          $url = "$row[url]";
 226          $name = stripslashes($name2);
 227          if ($row[type] == "backend") {
 228          echo "<tr><td><a href='".$pagepart1."".$url."".$pagepart2."' target='popup'>$name</a></td><td><input type=\"checkbox\" name=\"id[]\" value=\"$id\"></td><td><input type=\"checkbox\" name=\"delete[]\" value=\"$id\"></td></tr>";
 229          } else {
 230          echo "<tr><td><a href='pages.php?id=".$id."' target='popup'>$name</a></td><td><input type=\"checkbox\" name=\"id[]\" value=\"$id\"></td><td><input type=\"checkbox\" name=\"delete[]\" value=\"$id\"></td></tr>";
 231          }
 232      }
 233  
 234  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_pages.php?view=add\">Add Company</a></td></tr></form></table><br><br>";
 235  
 236  $total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM onecms_pages WHERE name LIKE '%" . $_POST['search'] . "%' OR url LIKE '%" . $_POST['search'] . "%'"),0);
 237  
 238  $total_pages = ceil($total_results / $max_results);
 239  
 240  echo "<center>Select a Page<br>";
 241  
 242  // Build Previous Link

 243  if($page > 1){
 244      $prev = ($page - 1);
 245      echo "<a href=\"a_pages.php?view=search&page=$prev\"><<Previous</a>&nbsp;";
 246  }
 247  
 248  for($i = 1; $i <= $total_pages; $i++){
 249      if(($page) == $i){
 250          echo "$i&nbsp;";
 251          } else {
 252              echo "<a href=\"a_pages.php?view=search&page=$i\">$i</a>&nbsp;";if (($i/25) == (int)($i/25)) {echo "<br>";}
 253      }
 254  }
 255  
 256  // Build Next Link

 257  if($page < $total_pages){
 258      $next = ($page + 1);
 259      echo "<a href=\"a_pages.php?view=search&page=$next\">Next>></a>";
 260  }
 261  echo "</center>";
 262  
 263  }
 264  if (($_GET['view'] == "manage") && ($_GET['edit'] == "2")) {
 265  
 266     while (list(, $i) = each ($_POST['id'])) {
 267  
 268     $r = mysql_query("UPDATE onecms_pages SET name = '".$_POST["name_$i"]."', url = '".$_POST["url_$i"]."', content = '".addslashes($_POST["content_$i"])."', online = '".$_POST["online_$i"]."' WHERE id = '".$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());
 269     }
 270  if ($r == TRUE) {
 271  echo re_direct("1500", "a_pages.php");
 272  echo "The page(s) have been updated. <a href='a_pages.php'>Return to Page Manager Home</a>";
 273  }
 274  }
 275  }
 276  }
 277  }
 278  }include  ("a_footer.inc");
 279  ?>


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