One Hat Cyber Team

Edit File: view_credentials090814.php

<?
//include "inc/header.php";
include "inc/config.php";
$stud_id=$_GET['stud_id'];

include "../inc/fxn.php";

echo "<a href=\"Javascript:;\" onclick=\"window.history.back();\">Go Back</a><br>";
$details=GetMany("corp_mem",$stud_id,"stud_id");
mysql_query("UPDATE corp_mem SET checked='1' WHERE stud_id='$stud_id'");

$surname=$details['surname'];
$othernames=$details['othernames'];
$name= $surname." ".$othernames;
$school=GetAny("universities",$details['school'],"id","name");
$email=$details['email'];
$prop1=$details['proposer1'];
$prop2=$details['proposer2'];
$sponsor1=GetAny("nsemem",$prop1,"nseregno","title")." ".GetAny("nsemem",$prop1,"nseregno","firstname")." ".GetAny("nsemem",$prop1,"nseregno","othernames")." ".GetAny("nsemem",$prop1,"nseregno","middlename");
$sponsor2=GetAny("nsemem",$prop2,"nseregno","title")." ".GetAny("nsemem",$prop2,"nseregno","firstname")." ".GetAny("nsemem",$prop2,"nseregno","othernames")." ".GetAny("nsemem",$prop2,"nseregno","middlename");
$amount1=getAmountOwing($prop1);
$amount2=getAmountOwing($prop2);
$amount1=number_format($amount1);
$amount2=number_format($amount2);

$img_name="pix$stud_id.jpg";
$file_name="../passport"."/".$img_name;

echo "APPLICANT NAME: ".$surname." ".$othernames."<br>";
echo "SCHOOL: ".$school;
echo "<br>Proposer 1: $prop1---$sponsor1----Amount Owing: N$amount1 <br>";
echo "Proposer 2: $prop2---$sponsor2-----Amount Owing: N$amount2 <br><hr />";
?>
<?
if(isset($_POST['rearrange'])){
	$up=mysql_query("UPDATE corp_mem SET qual='$q',work='$w' WHERE stud_id='$student_id'");
	if($up){
		echo "Details Re-arranged";
		header("refresh: 1; url=view_credentials.php?stud_id=$student_id");
	}
	else{
		echo mysql_error();
	}
}
?>
<form action="" method="post">
<table border="1">
<tr>
<td>Passport</td><td><img src=<?=$file_name?> width=\"130\" height=\"137\" /></td>
</tr>
<tr>
<td>Educational Qualification</td><td><textarea name="q" rows="5" cols="35"><?=$details['qual'] ?></textarea></td>
</tr>
<tr>
<td>Position & Place of Work</td><td><textarea name="w" rows="5" cols="35"><?=$details['work'] ?></textarea><input type="hidden" name="student_id" value="<?=$stud_id ?>" /></td>
</tr>
<tr>
<td colspan="2"><input type="submit" name="rearrange" value="Re-arrange" /></td>
</tr>
</table>
</form>
<script type="text/javascript" src="thumbscroller.js"></script>
<script type="text/javascript">
        //create an image scroller object
        var isFlowers;
        //delay all code execution untill after page load
        window.onload = loadMyScroller;
            function loadMyScroller() {
        
		        isFlowers = new ImageScroller("isFlowersFrame", "isFlowersImageRow");
				isFlowers.addThumbnail("../passport/ssce<?=$stud_id?>.jpg", "../passport/ssce<?=$stud_id?>.jpg", "SSCE", " Screen Shot 2 Description.");
			    isFlowers.addThumbnail("../passport/deg<?=$stud_id?>.jpg", "../passport/deg<?=$stud_id?>.jpg", "DEGREE", " Screen Shot 3 Description.");
			    isFlowers.addThumbnail("../passport/nysc<?=$stud_id?>.jpg", "../passport/nysc<?=$stud_id?>.jpg", "NYSC", " Screen Shot 4 Description.");
				isFlowers.addThumbnail("../passport/prop<?=$stud_id?>.jpg", "../passport/prop<?=$stud_id?>.jpg", "PROPOSERS", " Screen Shot Description.");
				isFlowers.addThumbnail("../passport/state<?=$stud_id?>.jpg", "../passport/state<?=$stud_id?>.jpg", "STATEMENT OF EXPERIENCE", " Screen Shot Description.");
				isFlowers.addThumbnail("../passport/hnd<?=$stud_id?>.jpg", "../passport/hnd<?=$stud_id?>.jpg", "HND CERTIFICATE", " Screen Shot Description.");
				isFlowers.addThumbnail("../passport/pgd<?=$stud_id?>.jpg", "../passport/pgd<?=$stud_id?>.jpg", "PGD CERTIFICATE", " Screen Shot Description.");

//**    [end]   Modify these to change your images  **//								
			    isFlowers.setThumbnailHeight(600);
			    isFlowers.setThumbnailWidth(400);
			    isFlowers.setThumbnailPadding(3);
			    isFlowers.setScrollType(0);
			    isFlowers.enableThumbBorder(true);
			    isFlowers.setClickOpenType(1);
			    isFlowers.setThumbsShown(2);
			    isFlowers.setNumOfImageToScroll(1);
			    isFlowers.renderScroller();
	        };

</script>
			<table cellpadding="0" cellspacing="0" align="center" width="75%">
        <tr valign="top">
            <td>
                <a id="isFlowersFirstButton" href="javascript:isFlowers.scrollBegin();">
                    <img src="images2/first.gif" margin-right: 6px;" alt="See previous images" style="margin-top: 3px;" border="0" /></a>
            </td>
            <td>
                <a id="isFlowersPreviousButton" href="javascript:isFlowers.scrollReverse();">
                    <img src="images2/arrow_left.gif" alt="See previous images"
                        style="margin-top: 3px;" border="0" /></a>
            </td>
            <td>
                <div id="isFlowersFrame" name="isFlowersFrame" style="margin: 0px; padding: 0px;
                    position: relative; overflow: hidden;">
                    <div id="isFlowersImageRow" name="isFlowersImageRow" style="position: absolute; top: 0px;
                        left: 0px;">
                    </div>
                </div>
            </td>
            <td>
                <a id="isFlowersNextButton" href="javascript:isFlowers.scrollForward();">
                    <img src="images2/arrow_right.gif" alt="See next images"
                        style="margin-top: 3px;" border="0" /></a>
            </td>
            <td>
                <a id="isFlowersLastButton" href="javascript:isFlowers.scrollEnd();">
                    <img src="images2/last.gif" margin-left: 6px;" alt="See next images" style="margin-top: 3px;" border="0" /></a>
            </td>
        </tr>
    </table>  
    <table cellpadding="10" cellspacing="5">
    <form action="" method="post" name="form1">
    <tr>
    <td>Message</td><td>
    <textarea name="message" rows="5" cols="35"></textarea></td>
    </tr>
    <tr>
    <td colspan="2"><input type="submit" name="submit" value="Send Mail" /></td>
    </tr>
    </form>
    </table>
      <?
   if(isset($submit)){
	   $str = "Nigerian Society of Engineers: 2012 Corporate Membership Application";
		 $html_data = '<html><head><title>'.$str.'</title></head><body bgcolor="#fff0ff" text="#990000"><table width="100%" align="center" border="0" cellspacing="0" cellpadding="0" bgcolor="#A2A1A6">
		<tr><td><img src="http://www.nse.org.ng/images/banner.jpg" /></td></tr> <tr>
    <td width="47%" bgcolor="#944B2A"><H1><span style="color:#ffffff">NSE CORPORATE MEMBERSHIP APPLICATION</span></H1></td>
  </tr>
  </table></td></tr></table><h4>Dear '.$name.' </h4><br><h3>NSE CORPORATE MEMBERSHIP APPLICATION
</h3><br><br><h5>'.$message.'</h5><br><br><br><h6>Engr. Ovens F. Ehimatie, <i>MNSE</i><br>Head, Membership Services<br>Nigerian Society Enginner<br>National Engineering Center,<br>Off National Mosque - Labour House Road,<br>Central Business District, Abuja.</h6>';

include("mimemail/MIME.class");
$mime = new MIME_mail("application@nse.org.ng", $email, $str);
$mime->attach($html_data, "", HTML, BASE64);
$mime->send_mail();

//}
if($mime){
	echo "Message Sent";
}
else{ echo "Message cannot be sent";}
}

function getAmountOwing($nseregno){
	$sql=mysql_query("SELECT * FROM payitem_amount WHERE nseregno='$nseregno'");
	while ($row=mysql_fetch_array($sql)){
		$prev_out=$row['prev_out'];
	$annual_sub=$row['annualsub'];
	$abujaneclevy=$row['abujaneclevy'];
	$buildinglevy=$row['buildinglevy'];
	$benevolentfund=$row['benevolentfund'];
	$inter=$row['internationallevy'];
	$otherlevy=$row['otherlevy'];
	$welfare=$row['welfarepremium'];
	$advanced=$row['advanced_pay'];
	$enrol=$row['enrollment'];
	$material=$row['material'];
	$processing=$row['processingfee'];
	
	$total=$prev_out+$annual_sub+$abujaneclevy+$buildinglevy+$benevolentfund+$inter+$otherlevy+$welfare+$advanced+$enrol+$material+$processing;
	}
	return $total;
}
?>