Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
reporting	[ DIR ]	drwxr-sr-x	2020-01-14 08:25
2010_team.php	23.67 KB	-rw-r--r--	2017-07-03 10:50
approvals.php	3.7 KB	-rw-r--r--	2018-08-20 08:15
approvals_uni.php	3.51 KB	-rw-r--r--	2018-08-20 08:15
areas.php	8.49 KB	-rw-r--r--	2019-08-01 13:22
com_reg.php	6.77 KB	-rw-r--r--	2019-08-01 13:23
con_area.php	2.08 KB	-rw-r--r--	2017-08-02 09:09
con_man.php	8.61 KB	-rw-r--r--	2014-07-04 12:12
countrylist.php	11.91 KB	-rw-r--r--	2014-07-04 12:12
db.php	729 B	-rw-r--r--	2019-08-31 09:37
db.php.bak	323 B	-rw-r--r--	2014-07-04 12:12
entrants.php	2.22 KB	-rw-r--r--	2014-07-04 12:12
error_log	17.92 KB	-rw-r--r--	2014-07-04 12:12
footer.php	137 B	-rw-r--r--	2014-07-04 13:40
generateXML.php	649 B	-rw-r--r--	2014-07-04 12:12
index20130626.php	4.14 KB	-rw-r--r--	2014-07-04 12:12
login.php	1.4 KB	-rw-r--r--	2018-09-03 08:01
mailer.php	1.99 KB	-rw-r--r--	2017-07-03 10:50
menu.php	5.54 KB	-rw-r--r--	2019-06-12 10:15
payments.php	6.37 KB	-rw-r--r--	2018-08-20 08:15
phpinfo.php	24 B	-rw-r--r--	2014-07-04 12:12
reg.php	567 B	-rw-r--r--	2019-08-31 09:46
reports.php	1.81 KB	-rw-r--r--	2014-07-04 12:14
sec.php	650 B	-rw-r--r--	2014-07-04 12:14
social_app.php	4.48 KB	-rw-r--r--	2018-08-20 08:15
team.php	33.2 KB	-rw-r--r--	2019-08-01 13:25
team_mail.php	2.81 KB	-rw-r--r--	2017-07-03 10:50
timing_report.php	1.57 KB	-rw-r--r--	2014-07-04 12:14
timing_report_2012.php	10.96 KB	-rw-r--r--	2015-08-19 08:40
uni_reg.php	5.5 KB	-rw-r--r--	2019-08-01 13:26
uni_team.php	33.04 KB	-rw-r--r--	2019-08-01 13:23

Rename

<br/><?php
  if (isset($_GET['act'])) {
    if ($_GET['act']=='add') {//add
      if (isset($_POST['frm_sub'])) {
        $maxquery="SELECT MAX(rank) AS rank FROM saace_content";
        $maxresult=mysql_query($maxquery);
        $maxrow=mysql_fetch_assoc($maxresult);
        $max=$maxrow['rank'];
        $insquery="INSERT INTO saace_content (name,content,rank,status,home) VALUES ('".$_POST['name']."','".$_POST['content']."','".($max+1)."','0','0')";
        mysql_query($insquery);
        echo "<h1>Page Added</h1><a href='".$pagename."?sec=con'>Go to content</a>\n";
      } else {
        echo "<form  method='POST' action='".$pagename."?sec=con&act=add'>\n";
        ?>
          <table width='100%' border='0' cellpadding='0' cellspacing='0'>
          <tr>
            <th colspan='2' align='left'>Add new page</th>
          </tr>
          <tr>
            <td>Name</td>
            <td><input type='text' name='name'></td>
          </tr>
          <script type='text/javascript' src='fckeditor/fckeditor.js'></script>
         <script type='text/javascript'>
         window.onload = function() {
         var sBasePath = 'fckeditor/'
         var oFCKeditor = new FCKeditor( 'content' ) ;
         oFCKeditor.BasePath	= sBasePath ;
         oFCKeditor.ReplaceTextarea() ;
         }
         </script>
          <tr>
            <td>Content</td>
            <td><textarea name='content'></textarea></td>
          </tr>
          <tr>
            <td colspan='2'><input type='submit' name='frm_sub' value='Add Page'/></td>
          </tr>
          </table>
          </form>
        <?php
      }
    } elseif ($_GET['act']=='edi') {//edit
      if (isset($_POST['frm_sub'])) {
        $updquery="UPDATE saace_content SET name='".$_POST['name']."',content='".$_POST['content']."' WHERE id='".$_GET['id']."'";
        mysql_query($updquery);
        echo "<h1>Page Edited</h1><a href='".$pagename."?sec=con'>Go to content</a>\n";
      } else {
        $query="SELECT * FROM saace_content WHERE id='".$_GET['id']."'";
        $result=mysql_query($query);
        if ($result) {
          $row=mysql_fetch_assoc($result);
          echo "<form  method='POST' action='".$pagename."?sec=con&act=edi&id=".$_GET['id']."'>\n";
          ?>
            <table width='100%' border='0' cellpadding='0' cellspacing='0'>
            <tr>
              <th colspan='2' align='left'>Edit page</th>
            </tr>
            <tr>
              <td>Name</td>
              <td><input type='text' name='name' value='<?php echo $row['name'];?>'></td>
            </tr>
            <script type='text/javascript' src='fckeditor/fckeditor.js'></script>
         <script type='text/javascript'>
         window.onload = function() {
         var sBasePath = 'fckeditor/'
         var oFCKeditor = new FCKeditor( 'content' ) ;
         oFCKeditor.BasePath	= sBasePath ;
         oFCKeditor.ReplaceTextarea() ;
         }
         </script>
            <tr>
              <td>Content</td>
              <td><textarea name='content'><?php echo $row['content'];?></textarea></td>
            </tr>
            <tr>
              <td colspan='2'><input type='submit' name='frm_sub' value='Edit Page'/></td>
            </tr>
            </table>
            </form>
          <?php
        }
      }
    } elseif ($_GET['act']=='del') {//delete
      $delquery="DELETE FROM saace_content WHERE id='".$_GET['id']."'";
      mysql_query($delquery);
      echo "<h1>Page Deleted</h1><a href='".$pagename."?sec=con'>Go to content</a>\n";
    } elseif ($_GET['act']=='susp') {//suspend
      $susquery="UPDATE saace_content SET status='0' WHERE id='".$_GET['id']."'";
      mysql_query($susquery);
      echo "<h1>Page Suspended</h1><a href='".$pagename."?sec=con'>Go to content</a>\n";
    } elseif ($_GET['act']=='acti') {//restore
      $susquery="UPDATE saace_content SET status='1' WHERE id='".$_GET['id']."'";
      mysql_query($susquery);
      echo "<h1>Page Activated</h1><a href='".$pagename."?sec=con'>Go to content</a>\n";
    } elseif ($_GET['act']=='rdo') {//rank up
      //look for one less
      $query="SELECT rank FROM saace_content WHERE id='".$_GET['id']."'";
      $res1=mysql_query($query);
      $orow=mysql_fetch_assoc($res1);
      $query="SELECT id,rank FROM saace_content WHERE rank<'".$orow['rank']."' ORDER BY rank DESC LIMIT 1";
      $res2=mysql_query($query);
      $nrow=mysql_fetch_assoc($res2);
      $updquery="UPDATE saace_content SET rank='".$orow['rank']."' WHERE id='".$nrow['id']."'";
      mysql_query($updquery);
      $updquery="UPDATE saace_content SET rank='".$nrow['rank']."' WHERE id='".$_GET['id']."'";
      mysql_query($updquery);
      echo "<h1>Rank Adjusted</h1><a href='".$pagename."?sec=con'>Go to content</a>\n";
    } elseif ($_GET['act']=='rup') {//rank down
      //look for one less
      $query="SELECT rank FROM saace_content WHERE id='".$_GET['id']."'";
      $res1=mysql_query($query);
      $orow=mysql_fetch_assoc($res1);
      $query="SELECT id,rank FROM saace_content WHERE rank>'".$orow['rank']."' ORDER BY rank ASC LIMIT 1";
      $res2=mysql_query($query);
      $nrow=mysql_fetch_assoc($res2);
      $updquery="UPDATE saace_content SET rank='".$orow['rank']."' WHERE id='".$nrow['id']."'";
      mysql_query($updquery);
      $updquery="UPDATE saace_content SET rank='".$nrow['rank']."' WHERE id='".$_GET['id']."'";
      mysql_query($updquery);
      echo "<h1>Rank Adjusted</h1><a href='".$pagename."?sec=con'>Go to content</a>\n";
    } elseif ($_GET['act']=='hom') {//set home
      $susquery="UPDATE saace_content SET home='0'";
      mysql_query($susquery);
      $susquery="UPDATE saace_content SET home='1' WHERE id='".$_GET['id']."'";
      mysql_query($susquery);
      echo "<h1>Page Set as home</h1><a href='".$pagename."?sec=con'>Go to content</a>\n";
    } 
  } else {//list
    ?>
      <table width='100%' border='0' cellpadding='0' cellspacing='0'>
        <tr>
          <th colspan='2' align='left'>Rank</th>
          <th align='left'>Page Name</th>
          <th align='left'>Actions</th>
        </tr>
        <?php
          $query="SELECT * FROM saace_content ORDER BY rank ASC";
          $result=mysql_query($query);
          if ($result) {
            $minquery="SELECT MIN(rank) AS rank FROM saace_content";
            $minresult=mysql_query($minquery);
            $minrow=mysql_fetch_assoc($minresult);
            $min=$minrow['rank'];
            $maxquery="SELECT MAX(rank) AS rank FROM saace_content";
            $maxresult=mysql_query($maxquery);
            $maxrow=mysql_fetch_assoc($maxresult);
            $max=$maxrow['rank'];
            while ($row=mysql_fetch_assoc($result)) {
              echo "<tr>\n";
                if ($row['rank']==$min) { //lowest rank
                  echo "<td></td>\n";
                } else {
                  echo "<td><a href='".$pagename."?sec=con&act=rdo&id=".$row['id']."'><img border='0' src='img/down.gif' alt='Move down'/></a></td>\n";
                }
                if ($row['rank']==$max) { //lowest rank
                  echo "<td></td>\n";
                } else {
                  echo "<td><a href='".$pagename."?sec=con&act=rup&id=".$row['id']."'><img border='0' src='img/up.gif' alt='Move up'/></a></td>\n";
                }
                echo "<td>".$row['name']."</td>\n";
                echo "<td>\n";
                echo "  <a href='".$pagename."?sec=con&act=edi&id=".$row['id']."'><img border='0' src='img/edit.gif' alt='Edit'/></a>\n";
                if ($row['status']=='0') {
                  echo "  <a href='".$pagename."?sec=con&act=acti&id=".$row['id']."'><img border='0' src='img/restore.gif' alt='Activate'/></a>\n";
                } else {
                  echo "  <a href='".$pagename."?sec=con&act=susp&id=".$row['id']."'><img border='0' src='img/suspend.gif' alt='Suspend'/></a>\n";
                }
                echo "  <a href='".$pagename."?sec=con&act=del&id=".$row['id']."' onclick='javascript: return confirm(\"Are you sure you want to delete this page - ".$row['name']."?\");'><img border='0' src='img/delete.gif' alt='Delete'/></a>\n";
                if ($row['home']=='0') {
                  echo "  <a href='".$pagename."?sec=con&act=hom&id=".$row['id']."'><img border='0' src='img/nothome.gif' alt='Set as home'/></a>\n";
                } else {
                  echo "  <img border='0' src='img/home.gif' alt='This is the home'/>\n";
                }
                echo "</td>\n";
              echo "</tr>\n";
            } //end while
            echo "<tr><td colspan='4'><a href='".$pagename."?sec=con&act=add'>Add New Page</a></td></tr>\n";
          } else {
            echo "<tr><td colspan='4'>No pages have been added yet</td></tr>\n";
          }
        ?>
      </table>
    <?php
  }
?>