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

<?php
 if (isset($_GET['act'])) {
 if ($_GET['act']=='susp') {//suspend
 $susquery="UPDATE saace_team SET paid='0' WHERE id='".$_GET['id']."'";
 mysql_query($susquery);
 } elseif ($_GET['act']=='acti') {//restore
 $susquery="UPDATE saace_team SET paid='1' WHERE id='".$_GET['id']."'";
 mysql_query($susquery);
 
 $tquery="SELECT * FROM saace_team WHERE id='".$_GET['id']."'";
 $tres=mysql_query($tquery);
 if ($tres) {
 $trow=mysql_fetch_assoc($tres);
 $selquery="SELECT * FROM saace_company WHERE id='".$trow['comp_id']."'";
 $selres=mysql_query($selquery);
 if ($selres) {
 $selrow=mysql_fetch_assoc($selres);
 $mstr="<html><body>
Dear ".$selrow['contact']." Your payment for the following team(s) have been approved. ".$trow['name']." Should you have any questions 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. CESA Admin <a href='mailto:events@cesa.co.za'>events@cesa.co.za</a> <img src='http://www.cesa.co.za/relay/img/eMailLogo.gif' alt=''Logo></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\n";
 mail($selrow['email'],'CESA Team Payment acknowledged',$mstr,$headers);
 }
 } else {
 echo "Mail could not be sent\n";
 }
 } elseif ($_GET['act']=='asusp') {//suspend
 $susquery="UPDATE saace_areas SET paid='0' WHERE id='".$_GET['id']."'";
 mysql_query($susquery);
 } elseif ($_GET['act']=='aacti') {//restore
 $susquery="UPDATE saace_areas SET paid='1' 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>
Dear ".$selrow['contact']." Your payment for the follow area(s) have been approved. Stand ".$starow['name']." 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. CESA Admin. <a href='mailto:events@cesa.co.za'>events@cesa.co.za</a> <img src='http://www.cesa.co.za/relay/img/eMailLogo.gif' alt=''Logo></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\n";
 mail($selrow['email'],'CESA Social Area Payment acknowledged',$mstr,$headers);
 }
 } else {
 echo "Mail could not be sent\n";
 }
 }
 }
 ?>
 
 <h1>Payment Approval</h1>
 <table border='0' cellpadding='0' cellspacing='0' width='100%'>
 <tr>
 <th align='left'>Company</th>
 <th align='left'>Team</th>
 <th align='left'>Social Area</th>
 <th align='left'>Approved</th>
 </tr>
 <?php
 $bgcnt=1;
 $query="SELECT * FROM saace_company WHERE status='1' ORDER BY name ASC";
 $result=mysql_query($query);
 if ($result) {
 while ($row=mysql_fetch_assoc($result)) {
 $selquery="SELECT * FROM saace_team WHERE comp_id='".$row['id']."'";
 $selres=mysql_query($selquery);
 if ($selres && mysql_num_rows($selres)>0) {
 while ($selrow=mysql_fetch_assoc($selres)) {
 echo "<tr";
 if ($bgcnt%2==0) {
 echo " class='odd'";
 } else {
 echo " class='even'";
 }
 echo ">\n";
 echo "<td>".$row['name']."</td>\n";
 echo "<td>".$selrow['name'];
 $typquery="SELECT * FROM saace_teamtype WHERE id='".$selrow['type']."'";
 $typres=mysql_query($typquery);
 if ($typres) {
 $typrow=mysql_fetch_assoc($typres);
 echo " - ".$typrow['name']."</td>\n";
 }
 echo "<td></td>\n";
 echo "<td align='center'>\n";
 if ($selrow['paid']=='0') {
 echo " <a href='".$pagename."?sec=pay&act=acti&id=".$selrow['id']."'><img border='0' src='img/restore.gif' alt='Activate'/></a>\n";
 } else {
 echo " <a href='".$pagename."?sec=pay&act=susp&id=".$selrow['id']."'><img border='0' src='img/suspend.gif' alt='Suspend'/></a>\n";
 }
 echo "</td>\n";
 echo "</tr>\n";
 $bgcnt++;
 }
 }
 //social areas//
 $selquery="SELECT * FROM saace_areas WHERE comp_id='".$row['id']."'";
 $selres=mysql_query($selquery);
 if ($selres && mysql_num_rows($selres)>0) {
 while ($selrow=mysql_fetch_assoc($selres)) {
 echo "<tr";
 if ($bgcnt%2==0) {
 echo " class='odd'";
 } else {
 echo " class='even'";
 }
 echo ">\n";
 echo "<td>".$row['name']."</td>\n";
 echo "<td></td>\n";
 echo "<td>Stand ".$selrow['name']."</td>\n";
 echo "<td align='center'>\n";
 if ($selrow['paid']=='0') {
 echo " <a href='".$pagename."?sec=pay&act=aacti&id=".$selrow['id']."'><img border='0' src='img/restore.gif' alt='Activate'/></a>\n";
 } else {
 echo " <a href='".$pagename."?sec=pay&act=asusp&id=".$selrow['id']."'><img border='0' src='img/suspend.gif' alt='Suspend'/></a>\n";
 }
 echo "</td>\n";
 echo "</tr>\n";
 $bgcnt++;
 }
 }
 } //end while
 }
 ?>
</table>