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
  require('db.php');
  $email="events@cesa.co.za";
  if (isset($_GET['mail'])&&$_GET['mail']=='1') {
    $tcost=0;
    $teamq="SELECT * FROM saace_team WHERE comp_id='".$_GET['comp']."' AND paid='0'";
    $teamr=mysql_query($teamq);
    $mstr="";
    while ($row=mysql_fetch_assoc($teamr)) {
      $mstr.="\t\t\t<tr>\n\t\t\t\t<td>".$row['name']."</td><td>";
      $ttq="SELECT * FROM saace_teamtype WHERE id='".$row['type']."'";
      $ttr=mysql_query($ttq);
      if ($ttrow=mysql_fetch_assoc($ttr)) {
        $mstr.=$ttrow['name']."</td><td>R ".$ttrow['cost']."</td>\n";
        $tcost+=$ttrow['cost'];
      } else {
        $mstr.="No team type</td><td>R 0</td>";
      }
      $mstr.="\t\t\t</tr>\n";
    }
    $mstr.="\t\t\t<tr><td colspan='3'>Total: R ".$tcost."</td></tr>";
    $mstr.="\n\t\t</table>\n";
    $mstr.="\t</body>\n</html>";
    
    $headers="From: ".$email."\r\n"."Reply-To: ".$email."\r\nMIME-Version: 1.0\r\nContent-type: text/html; charset=iso-8859-1\r\nBcc: webmaster@ssi.co.za\r\n";
    $cq="SELECT * FROM saace_company WHERE id='".$_GET['comp']."'";
    $cres=mysql_query($cq);
    $cr=mysql_fetch_assoc($cres);
    $nmstr="<html>\n\t<body>\n\t<p>Dear ".$cr['contact']."<br/><br/>Thank you for entering your team(s) for the CESA Relay race.  <br/><br/>\n\t\t<table border='0' cellpadding='1' cellspacing='1'>\n".$mstr."<br/><br/>You will be issued with an invoice on which you will find the banking details.<br/><br/>CESA Admin. <br/><br/><a href='events@cesa.co.za'>events@cesa.co.za</a><br/><img src='http://www.cesa.co.za/relay/img/eMailLogo.gif' alt=''Logo></p>";
    if (mail($cr['email'],'CESA Team Invoice',$nmstr,$headers)) {
      echo "Mail sent";
    } else {
      echo "Mail not sent";
    }
  } elseif (isset($_GET['comp'])) {
    $tcost=0;
    $teamq="SELECT * FROM saace_team WHERE comp_id='".$_GET['comp']."' AND paid='0'";
    $teamr=mysql_query($teamq);
    echo "<html>\n\t<body>\n\t\t<table border='0' cellpadding='1' cellspacing='1'>\n";
    while ($row=mysql_fetch_assoc($teamr)) {
      echo "\t\t\t<tr>\n\t\t\t\t<td>".$row['name']."</td><td>";
      $ttq="SELECT * FROM saace_teamtype WHERE id='".$row['type']."'";
      $ttr=mysql_query($ttq);
      if ($ttrow=mysql_fetch_assoc($ttr)) {
        echo $ttrow['name']."</td><td>R ".$ttrow['cost']."</td>\n";
        $tcost+=$ttrow['cost'];
      } else {
        echo "No team type</td><td>R 0</td>";
      }
      echo "\t\t\t</tr>\n";
      
    }
    echo "\t\t\t<tr><td colspan='3'>R ".$tcost."</td></tr>";
    echo "\n\t\t</table>\n\t\t<a href='?comp=".$_GET['comp']."&mail=1'>Send Mail</a>\n";
    echo "\t</body>\n</html>";
  } else {
    $compq="SELECT * FROM saace_company ORDER BY name ASC";
    $compr=mysql_query($compq);
    while ($row=mysql_fetch_assoc($compr)) {
      echo $row['name']." - <a href='?comp=".$row['id'],"'>Mail</a><br/>\n";
    }
  }
?>