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']=='susp') {//suspend
      $susquery="UPDATE saace_areas SET booked='0', reserved='1' WHERE id='".$_GET['id']."'";
      mysql_query($susquery);
    } elseif ($_GET['act']=='del') {//delete
      $susquery="UPDATE saace_areas SET booked='0', reserved='0', comp_id='0' WHERE id='".$_GET['id']."'";
      mysql_query($susquery);
    } elseif ($_GET['act']=='acti') {//restore
      $susquery="UPDATE saace_areas SET booked='1', reserved='0' WHERE id='".$_GET['id']."'";
      mysql_query($susquery);
      
      $staquery="SELECT * FROM saace_areas WHERE id='".$_GET['id']."'";
      $stares=mysql_query($staquery);
      if ($stares) {
        $starow=mysql_fetch_assoc($stares);
        $selquery="SELECT * FROM saace_company WHERE id='".$starow['comp_id']."'";
        $selres=mysql_query($selquery);
        if ($selres) {
          $selrow=mysql_fetch_assoc($selres);
          $mstr="<html><body><p>
Dear ".$selrow['contact']." (".$selrow['name'].") <br/><br/>Your reservations for the follow stand(s) have been approved. <b>Please note</b> that costs for social areas are R4000.<br/><br/>Stand ".$starow['name']."<br/><br/>Should you have selected the incorrect area and wish to cancel your registration please contact <a href='mailto:events@cesa.co.za'>events@cesa.co.za</a> or Bonolo at +27 (0)11 463 2022 with all your details.<br/><br/>CESA RELAY Admin. <br/><br/><a href='mailto:events@cesa.co.za'>events@cesa.co.za</a><br/><img src='http://www.cesa.co.za/relay/img/eMailLogo.gif' alt=''Logo></p></body></html>";
      //mail client
          $headers = "From: ".$admin_email."\r\n"."Reply-To: ".$admin_email."\r\nMIME-Version: 1.0\r\nContent-type: text/html; charset=iso-8859-1\r\nBcc: events@cesa.co.za\r\nBcc: athromethm@cesa.co.za\r\n";
          mail($selrow['email'],'CESA Social Area booking approved',$mstr,$headers);
          }
      } else {
        echo "Mail could not be sent\n";
      }
    } 
    echo "<script type='text/javascript'>window.location = 'http://www.cesa.co.za/relay/index.php?sec=soci'</script>";
  }
    ?>
      <h1>Confirm Social Area Reservations</h1>
      <table border='0' cellpadding='0' cellspacing='0' width='100%'>
        <tr>
          <th width="10%" align='left'>Stand #</th>
          <th width="71%" align='left'>Company Name (Contact Details)</th>
          <th width="10%" align='left'>Cost</th>
          <th width="9%" align='left'>Approved</th>
        </tr>
        <?php
          $query="SELECT * FROM saace_areas WHERE (reserved=1 OR booked=1) ORDER BY comp_id ASC";
          $result=mysql_query($query);
          if ($result) {
            while ($row=mysql_fetch_assoc($result)) {
              echo "<tr>\n";
                echo "<td>".$row['name']."</td>\n";
                $selquery="SELECT * FROM saace_company WHERE id='".$row['comp_id']."'";
                $selres=mysql_query($selquery);
                if ($selres) {
                  $selrow=mysql_fetch_assoc($selres);
                  echo "<td><strong>".$selrow['name']."</strong>"."  (".$selrow['contact']." - ".$selrow['tele'].")</td>\n";
                } else {
                  echo "<td></td>\n";
                }
                
                $costs=4000;
                if ($row['tent']==1) {
                  $costs+=950;
                } elseif ($row['tent']==2) {
                  $costs+=1100;
                }
                $costs+=($row['chairs']*4.5);
                $costs+=($row['tbles']*15);
                $costs+=($row['rubbish']*17.50);
                $costs+=($row['bath']*24);
                echo "<td>".$costs."</td>\n";
                echo "<td align='center' width='5%'>\n";
                if ($row['booked']=='0') {
                  echo "  <a href='".$pagename."?sec=soci&act=acti&id=".$row['id']."'><img border='0' src='img/restore.gif' alt='Activate'/></a>\n";
                } else {
                  echo "  <a href='".$pagename."?sec=soci&act=susp&id=".$row['id']."'><img border='0' src='img/suspend.gif' alt='Suspend'/></a>\n";
                }
                echo "  <a href='".$pagename."?sec=soci&act=del&id=".$row['id']."' onclick='javascript: return confirm(\"Are you sure you want to delete this reservation for stand ".$row['name']."?\");'><img border='0' src='img/delete.gif' alt='Delete'/></a>\n";
                echo "</td>\n";
              echo "</tr>\n";
            } //end while
          } else {
            echo "<tr><td colspan='4'>No companies have applied yet</td></tr>\n";
          }
        ?>
</table>