HELP! Script needs advice.

[systm]

OK I was given this script by a co-worker some time ago and we have kept adding to it and now we need so help with a few minor issues.

1. We are using this line to check the data entered into text field 'code1' against values in another table. It displays the error just fine but we have 4 code boxes in total to check, we need to display 'error code X invalid' for each but when we add this for the other boxes, using ELSE IF they work for errors but not SUCCESS! message. (Suspect a { or } somewhere is the issue just can't find which one)

2. We are writing the information into a CSV file as well (I know, not the best practise but we have a KEA! script that processes this into TELNET commands) we find that if multiple people post at same time, sometimes the data isn't written into the csv, I recently changed to using FLOCK but wonder if there is a better way to 'lock' access to file until a command is done.

==========================================================

if(!mysql_num_rows(mysql_query("SELECT code FROM sc_codes WHERE code = '$c1'"))){

if(isset($_REQUEST['submit'])) {
	$system = $_REQUEST['SYSTEM'];
	$from   = $_REQUEST['EMAIL'];
	$tech   = $_REQUEST['TECH'];
	$sc     = $_REQUEST['CALLNUMBER'];
	$c1     = $_REQUEST['CODE1'];

if(empty($tech) || empty($sc) || empty($c1) || strlen($sc) !=8 || !is_numeric($sc) || !is_numeric($c1) || strlen($c1) !=3) {
	$message = "<font color=\"red\">CALL POST: FAILED! // INVALID POST! CHECK VALUES.</font><br>";

} else {
	$c2    = $_REQUEST['CODE2'];
	$c3    = $_REQUEST['CODE3'];
	$c4    = $_REQUEST['CODE4'];

	$t1    = $_REQUEST['TIME1'];
	$t2    = $_REQUEST['TIME2'];
	$ta = $s2 . $t2;
	$f7 = $_REQUEST['ACCOUNT'];
	$f8 = implode("-", (array)$NOTE);
	$f9 = $_REQUEST['DISPATCH'];
	$s1 = ' // ';
	$s2 = ' - ';
	$spins = $f7 . $s1 . $t1 . $ta . $f8 . $f9;
	$nd    = $_REQUEST['DROP'];
	$ns    = $_REQUEST['CBS'];

	require_once 'login.php';
	$db_server = mysql_connect($db_hostname, $db_username, $db_password);

	if (!$db_server) die("Unable to connect to server: " . mysql_error());

	mysql_select_db($db_database, $db_server)
		or die("Unable to select database: " .mysql_error());

	if(!mysql_num_rows(mysql_query("SELECT code FROM sc_codes WHERE code = '$c1'"))){
		$message = "<font color=\"red\">CALL POST: FAILED! // INVALID CODE[1]</font><br>";

	} else {

		$query = "INSERT INTO post VALUES" .
			"(NOW(), '$tech', '$sc', '$c1', '$c2', '$c3', '$c4', '$spins', '$nd', '$ns', '$system')";


		if (!mysql_query($query, $db_server))
			$message = "<font color=\"red\">CALL POST: FAILED! // ALREADY PREVIOUSLY POSTED.</font><br>";		

	$post = "\"$tech\",\"$sc\",\"\",\"$c1\",\"$c2\",\"$c3\",\"$c4\",\"$f9\",\"$nd\",\"$ns\"\r\n";

	if(!file_exists("/home/systm/public_html/sjrb/posting/_store/101.csv")) {
		//if file doesn't exist, create it and add headers.
		$fp = fopen("/home/systm/public_html/sjrb/posting/_store/101.csv","a");
		$headers = "\"TECH_NUMBER\",\"SERVICE_CALL_NUMBER\",\"ACCOUNT_NUMBER\",\"CODE_1\",\"CODE_2\",\"CODE_3\",\"CODE_4\",\"SPECIAL_INSTRUCTIONS\",\"DROP_NOTES\",\"CBS_NOTES\"\r\n";
		fwrite($fp,$headers);
		fwrite($fp,$post);
		fclose($fp);
		chmod("/home/systm/public_html/sjrb/posting/_store/101.csv", 0777);
	} else {
		$fp = fopen("/home/systm/public_html/sjrb/posting/_store/101.csv","a");
		fwrite($fp,$post);
		fclose($fp);
	}


	$message = "<font color=\"red\">CALL POST: SUCCESSFUL!</font><br>";

	//send email

	if(!empty($_REQUEST['ACCOUNT'])) {

	$to = '[e-mail]'.',[e-mail]';
	//$to = '[e-mail]';
	$subject = "$tech has submitted TSD Notes for Service Call: $sc";

	$body = "";
	$spins = preg_replace("/\s+/", " ", $spins);
	$aspins = str_split($spins, 745);
	$body .= sprintf("ACCOUNT: %-45s\r\n", $aspins[0]);
	array_shift($aspins);
	foreach($aspins as $a) {
		$body .= sprintf("      %-45s\r\n", $a);
	}
	// To send HTML mail                  
           <[e-mail]>\r\n";
        $headers = 'From: '.$from."\r\n".
        $headers = "MIME-Version: 1.0 \r\n" ; 
	        $headers .= "Content-Type: text/html; charset=\"iso-8859-1\"\r\n"; 
	        $headers .= "X-Priority: 1 (Higuest) \r\n"; 
	        $headers .= "X-MSMail-Priority: High \r\n"; 
	        $headers .= "Importance: High \r\n"; 

	mail($to,$subject, $body, $headers);
	$message = "<font color=\"red\">CALL POST: SUCCESSFUL! // TSD NOTES SUBMITTED.</font><br>";

	}
	if(isset($_REQUEST['COACHING'])) {
		header("Location: http://xxxxxxxx/coaching/index.php?tech=" . $_REQUEST['TECH'] . "&sc=" . $_REQUEST['CALLNUMBER'] . "&message=Service Call : Posted!");

		}

	}

}
}

[jorgepinho]

isnt there a spelling error in "/home/systm/" ?

[systm]

no we did that on purpose 🙂

[mad_baron1]

$headers .= "Content-Type: text/html; charset="iso-8859-1\"\r\n"; wich is on about line 88.

now this may not be your issue but it looks like one.

maby change it to $headers .= "Content-Type: text/html; charset='iso-8859-1 r n'";

😛

[systm]

Thanks for that, It was pointed out in another tread and I have changed them. Can you or anyone confirm the { } locations, I seem to have ALL of them at the end of the script and I am not sure if that is ideal or should I be moving them? I would love to have this re-written to be better and more efficiently laid out, with validation on CODE1, CODE2, CODE3, CODE4 against the codes in my sc_codes table. I would be happy to pay someone for their efforts.

[mad_baron1]

i will be happy to help =D sense its like 12pm im going to work on it tomorrow. ill make it look all pretty for ya. may take a little bit ive been buzy working on a big project of my own. as for pay it would be nice but you can keep your money. i love to code. if i help you maby you could help me...do you know how to post paypal subscribe button's information with php?

[systm]

subscribe? do you mean paypal 'pay' buttons? I have worked with them a little, perhaps but I would warn you I am still a n00b at this 🙂 and thanks for the help. I do appreciate it, Its been easy for me to learn the PHP once I see the final product and I am able to take it and break it down, helps me understand the 'structure' of the functions... this script though is very 'busy' to me and i need to add more to add, problem is everytime i do it seems to 'break' the $message function.

example : I added that CODE1 check to the other 3 CODES using if else statements with their own $message CODE-X invalid and it worked, but the $message saying SUCCESS suddenly stopped... ????

Thanks again, have a good night.

[mad_baron1]

can i get both the php and the html source?

[systm]

<?php
	require_once('/home/systm/public_html/xxx/xxxxxxx.php');
?>
<!-- CALLPOST PHP --> // THIS FILE IS THE PHP
<?php include("core_post-pkg.php"); ?>

<!-- NAVIGATION -->
<?php include("../core_nav-pkg.php"); ?>


<!-- POSTING FORM -->
<div id="form" style="position: absolute; width: 424px; height: 100px; z-index: 1; top: 338px; left: 20px;">
<form name="callpost" action='index.php' method='post'  class="post-form" style="width: 424px">
    <input type="hidden" name="TECH"  maxlength="4" style="width: 70px" value="<?php echo $_SESSION['SESS_MEMBER_ID'];?>">
	<input type="hidden" name="EMAIL"  maxlength="4" style="width: 70px" value="<?php echo $_SESSION['SESS_EMAIL'];?>">
	<input type="hidden" name="SYSTEM" style="width: 70px" value="<?php echo $_SESSION['SESS_SYSTEM'];?>">
	<label><strong>CALL NUMBER<br></strong></label>
	<input type="text" name="CALLNUMBER"  maxlength="8" style="width: 120px"><br>

<br><label><strong>CODES</strong></label><br>
<input type="text" name="CODE1" maxlength="3" style="width: 45px"> <br>
<input type="text" name="CODE2" maxlength="3" style="width: 45px"> <br>
<input type="text" name="CODE3" maxlength="3" style="width: 45px"> <br>
<input type="text" name="CODE4" maxlength="3" style="width: 45px"><br>&nbsp;<strong><br>ADDITIONAL INFORMATION</strong>
<br><hr width="100" noshade="noshade" style="width: 100%; color: #666666">
<label><b>TSD NOTES</b> (TSD/CBS/DROP NOTES)<span class="info-error">
<br><b> !- </b>ACCOUNT NUMBER REQUIRED FOR ALL TSD NOTES!<b> -!</b></span><br>
<br><strong>ACCOUNT NUMBER<br></strong></label>
<input type="text" name="ACCOUNT" style="width: 220px" maxlength="13"> <br> 
<br>
	<input type="checkbox" name="NOTE[]" value="CUSTOMER NOT HOME"><b> CUSTOMER NOT HOME </b><br>
	<input type="checkbox" name="NOTE[]" value=" - LEFT VM "> VM <input type="checkbox" name="NOTE[]" value=" - LEFT DK "> DK <input type="checkbox" name="NOTE[]" value=" - ABLE TO RETURN  "> ABLE TO RETURN<br>
<br>
<textarea name="DISPATCH" style="height: 119px; width: 400px;"></textarea><br>
<br>
<input type="hidden" name="DROP">
<input type="hidden" name="CBS">
<br>
<input type="checkbox" name="COACHING">SUBMIT COACHING
<br><br>
<input type='submit' name="submit" value='POST CALL'> 
</form>
<br><br>
<br><br>               
</div>
<div id="post-err" style="position: absolute; width: 460px; height: 22px; z-index: 2; top: 312px; left: 14px;">
<?php if(isset($message)) { echo $message; } ?>
</div>

==========================================================

<?php // Posting System - Version 3.0

if(isset($_REQUEST['submit'])) {
	$system = $_REQUEST['SYSTEM'];
	$from   = $_REQUEST['EMAIL'];
	$tech   = $_REQUEST['TECH'];
	$sc     = $_REQUEST['CALLNUMBER'];
	$c1     = $_REQUEST['CODE1'];

if(empty($tech) || empty($sc) || empty($c1) || strlen($sc) !=8 || !is_numeric($sc) || !is_numeric($c1) || strlen($c1) !=3) {
	$message = "<font color=\"red\">CALL POST: FAILED! // INVALID POST! CHECK VALUES.</font><br>";

} else {
	$c2    = $_REQUEST['CODE2'];
	$c3    = $_REQUEST['CODE3'];
	$c4    = $_REQUEST['CODE4'];

	$t1    = $_REQUEST['TIME1'];
	$t2    = $_REQUEST['TIME2'];
	$ta = $s2 . $t2;
	$f7 = $_REQUEST['ACCOUNT'];
	$f8 = implode("-", (array)$NOTE);
	$f9 = $_REQUEST['DISPATCH'];
	$s1 = ' // ';
	$s2 = ' - ';
	$spins = $f7 . $s1 . $t1 . $ta . $f8 . $f9;
	$nd    = $_REQUEST['DROP'];
	$ns    = $_REQUEST['CBS'];

	require_once 'login.php';
	$db_server = mysql_connect($db_hostname, $db_username, $db_password);

	if (!$db_server) die("Unable to connect to server: " . mysql_error());

	mysql_select_db($db_database, $db_server)
		or die("Unable to select database: " .mysql_error());

	if(!mysql_num_rows(mysql_query("SELECT code FROM sc_codes WHERE code = '$c1'"))){
		$message = "<font color=\"red\">CALL POST: FAILED! // INVALID CODE[1]</font><br>";

	} else {

		$check = "SELECT * FROM post WHERE callnumber = '$sc'";
		$result = mysql_query($check) or die("Unable to execute<br />$sql<br />".mysql_error());

		if(mysql_num_rows($result) == 1) {
			$message = "<font color=\"red\">CALL POST: FAILED! // PREVIOUSLY POSTED.</font><br>";		

	} else {

		$query = "INSERT INTO post VALUES" .
			"(NOW(), '$tech', '$sc', '$c1', '$c2', '$c3', '$c4', '$spins', '$nd', '$ns', '$system')";

	if (!mysql_query($query, $db_server))
			//echo "POST FAILED: $query<br />" .
			mysql_error() . "<br /><br />";

	$message = "<font color=\"red\">Call Post: Successful!</font><br>";


	$post = "\"$tech\",\"$sc\",\"\",\"$c1\",\"$c2\",\"$c3\",\"$c4\",\"$f9\",\"$nd\",\"$ns\"\r\n";

	if(!file_exists("/home/systm/public_html/sjrb/posting/_store/101.csv")) {
		//if file doesn't exist, create it and add headers.
		$fp = fopen("/home/systm/public_html/sjrb/posting/_store/101.csv","a");
		$headers = "\"TECH_NUMBER\",\"SERVICE_CALL_NUMBER\",\"ACCOUNT_NUMBER\",\"CODE_1\",\"CODE_2\",\"CODE_3\",\"CODE_4\",\"SPECIAL_INSTRUCTIONS\",\"DROP_NOTES\",\"CBS_NOTES\"\r\n";
		fwrite($fp,$headers);
		fwrite($fp,$post);
		fclose($fp);
		chmod("/home/systm/public_html/sjrb/posting/_store/101.csv", 0777);
	} else {
		$fp = fopen("/home/systm/public_html/sjrb/posting/_store/101.csv","a");
		fwrite($fp,$post);
		fclose($fp);
	}


	$message = "<font color=\"red\">CALL POST: SUCCESSFUL!</font><br>";

	//send email

	if(!empty($_REQUEST['ACCOUNT'])) {

	$to = 'xxxxxx@xxxxxx'.',xxxxxx@xxxxxxx';
	//$to = 'xxxxxxx@xxxxx';
	$subject = "$tech has submitted TSD Notes for Service Call: $sc";

	$body = "";
	$spins = preg_replace("/\s+/", " ", $spins);
	$aspins = str_split($spins, 745);
	$body .= sprintf("ACCOUNT: %-45s\r\n", $aspins[0]);
	array_shift($aspins);
	foreach($aspins as $a) {
		$body .= sprintf("      %-45s\r\n", $a);
	}
	// To send HTML mail, the Content-type header must be set
		//$headers = "From: FieldPortal | AutoPost Management <[e-mail]>\r\n";
        $headers = 'From: '.$from."\r\n".
        $headers = "MIME-Version: 1.0\r\n" ; 
	    $headers .= "Content-Type: text/html; charset=\"iso-8859-1\"\r\n"; 
	    $headers .= "X-Priority: 1 (Higuest)\r\n"; 
	    $headers .= "X-MSMail-Priority: High\r\n"; 
	    $headers .= "Importance: High\r\n"; 

	mail($to,$subject, $body, $headers);
	$message = "<font color=\"red\">CALL POST: SUCCESSFUL! // TSD NOTES SUBMITTED.</font><br>";

	}
	if(isset($_REQUEST['COACHING'])) {
		header("Location: http://xxxxxxxxxxx/coaching/index.php?tech=" . $_REQUEST['TECH'] . "&sc=" . $_REQUEST['CALLNUMBER'] . "&message=Service Call : Posted!");

		}

	}

}
}
}
?>

[mad_baron1]

thanks! ill prolly start work on it tommorrow or the day after. 😃

[mad_baron1]

i have made the code a bit more easyer on the eyes im not sure how it will display on the form tho...

<?php // Posting System - Version 3.0 

if(isset($_REQUEST['submit'])) { 
    							$system = $_REQUEST['SYSTEM']; 
   								$from   = $_REQUEST['EMAIL']; 
  								$tech   = $_REQUEST['TECH']; 
  								$sc     = $_REQUEST['CALLNUMBER']; 
  								$c1     = $_REQUEST['CODE1']; 

							if(empty($tech) || empty($sc) || empty($c1) || strlen($sc) !=8 || !is_numeric($sc) || !is_numeric($c1) || strlen($c1) !=3) 
								{ 
   								 	$message = "<font color=\"red\">CALL POST: FAILED! // INVALID POST! CHECK VALUES.</font><br>"; 
 								} 
							else 
								{ 
									$c2    = $_REQUEST['CODE2']; 
									$c3    = $_REQUEST['CODE3']; 
									$c4    = $_REQUEST['CODE4']; 

									$t1    = $_REQUEST['TIME1']; 
									$t2    = $_REQUEST['TIME2']; 
									$ta = $s2 . $t2; 
									$f7 = $_REQUEST['ACCOUNT']; 
									$f8 = implode("-", (array)$NOTE); 
									$f9 = $_REQUEST['DISPATCH']; 
									$s1 = ' // '; 
									$s2 = ' - '; 
									$spins = $f7 . $s1 . $t1 . $ta . $f8 . $f9; 
									$nd    = $_REQUEST['DROP']; 
									$ns    = $_REQUEST['CBS']; 

									require_once 'login.php'; 
									$db_server = mysql_connect($db_hostname, $db_username, $db_password); 

									if (!$db_server) die("Unable to connect to server: " . mysql_error()); 

									mysql_select_db($db_database, $db_server) or die("Unable to select database: " .mysql_error()); 

									if(!mysql_num_rows(mysql_query("SELECT code FROM sc_codes WHERE code = '$c1'")))
										{ 
											$message = "<font color=\"red\">CALL POST: FAILED! // INVALID CODE[1]</font><br>"; 
										} 
									else
										{ 
       			 							$check = "SELECT * FROM post WHERE callnumber = '$sc'"; 
       			 							$result = mysql_query($check) or die("Unable to execute<br />$sql<br />".mysql_error()); 

       			 							if(mysql_num_rows($result) == 1)
												{ 
           										 	$message = "<font color=\"red\">CALL POST: FAILED! // PREVIOUSLY POSTED.</font><br>";         
           										} 
											else
												{ 

       												$query = "INSERT INTO post VALUES" . 
       												"(NOW(), '$tech', '$sc', '$c1', '$c2', '$c3', '$c4', '$spins', '$nd', '$ns', '$system')"; 

       												if (!mysql_query($query, $db_server)) 
                     								//echo "POST FAILED: $query<br />" . 
       												mysql_error() . "<br /><br />"; 

       												$message = "<font color=\"red\">Call Post: Successful!</font><br>"; 


       												$post = "\"$tech\",\"$sc\",\"\",\"$c1\",\"$c2\",\"$c3\",\"$c4\",\"$f9\",\"$nd\",\"$ns\"\r\n"; 

       												if(!file_exists("/home/systm/public_html/sjrb/posting/_store/101.csv")) 
														{ 
       														//if file doesn't exist, create it and add headers. 
       														$fp = fopen("/home/systm/public_html/sjrb/posting/_store/101.csv","a"); 
       														$headers = "\"TECH_NUMBER\",\"SERVICE_CALL_NUMBER\",\"ACCOUNT_NUMBER\",\"CODE_1\",\"CODE_2\",\"CODE_3\",\"CODE_4\",\"SPECIAL_INSTRUCTIONS\",\"DROP_NOTES\",\"CBS_NOTES\"\r\n"; 
       														fwrite($fp,$headers); 
       														fwrite($fp,$post); 
       														fclose($fp); 
       														chmod("/home/systm/public_html/sjrb/posting/_store/101.csv", 0777); 
       													} 
													else 
														{ 
       														$fp = fopen("/home/systm/public_html/sjrb/posting/_store/101.csv","a"); 
       														fwrite($fp,$post); 
       														fclose($fp); 
       													} 


													$message = "<font color=\"red\">CALL POST: SUCCESSFUL!</font><br>"; 

													//send email 

													if(!empty($_REQUEST['ACCOUNT'])) 
														{ 

															$to = 'xxxxxx@xxxxxx'.',xxxxxx@xxxxxxx'; 
															//$to = 'xxxxxxx@xxxxx'; 
															$subject = "$tech has submitted TSD Notes for Service Call: $sc"; 

															$body = ""; 
															$spins = preg_replace("/\s+/", " ", $spins); 
															$aspins = str_split($spins, 745); 
															$body .= sprintf("ACCOUNT: &#37;-45s\r\n", $aspins[0]); 
															array_shift($aspins); 

															foreach($aspins as $a) 
															{ 
															$body .= sprintf("      %-45s\r\n", $a); 
															} 

															// To send HTML mail, the Content-type header must be set 
															//$headers = "From: FieldPortal | AutoPost Management <[e-mail]>\r\n"; 
															$headers = 'From: '.$from."\r\n". 
															$headers = "MIME-Version: 1.0\r\n" ; 
															$headers .= "Content-Type: text/html; charset=\"iso-8859-1\"\r\n"; 
															$headers .= "X-Priority: 1 (Higuest)\r\n"; 
															$headers .= "X-MSMail-Priority: High\r\n"; 
															$headers .= "Importance: High\r\n"; 

															mail($to,$subject, $body, $headers); 
															$message = "<font color=\"red\">CALL POST: SUCCESSFUL! // TSD NOTES SUBMITTED.</font><br>"; 

														} 
													if(isset($_REQUEST['COACHING'])) 
														{ 
															header("Location: http://xxxxxxxxxxx/coaching/index.php?tech=" . $_REQUEST['TECH'] . "&sc=" . $_REQUEST['CALLNUMBER'] . "&message=Service Call : Posted!"); 
														} 

												} 

										} 
								} 
						  } 
?> 

i cant see why the var $message isnt showing.

[bradgrafelman]

mad_baron1;10983365 wrote:

i cant see why the var $message isnt showing.

That's probably because you define such a variable in several places, but you never attempt to actually do anything with it.

[systm]

If I wanted to use this over and over to check CODES 2, 3, and 4 as well can I do it with the else statement or is there a better approach... should I 'die' or 'exit' after?

I been struggling getting this into the code more than once without it breaking.

                                                  $check = "SELECT * FROM post WHERE callnumber = '$sc'";
                                                    $result = mysql_query($check) or die("Unable to execute<br />$sql<br />".mysql_error());

                                                if(mysql_num_rows($result) == 1) 
                                                { 

[systm]

Anyone know why the validation isn't working here? It's suppose to say INVALID CODE 'X' (1-4) for each field. Also check if record exists and display ALREADY POSTED error

The problem seems to be the $message part, but even using ECHO hasn't worked.

My code is in the next post! Thanks.

[systm]

<?php // Posting System

if(isset($_REQUEST['submit'])) { 
                                $system = $_REQUEST['SYSTEM']; 
                                   $from   = $_REQUEST['EMAIL']; 
                                  $tech   = $_REQUEST['TECH']; 
                                  $sc     = $_REQUEST['CALLNUMBER']; 
                                  $c1     = $_REQUEST['CODE1']; 

                              if(empty($tech) || empty($sc) || empty($c1) || strlen($sc) !=8 || !is_numeric($sc) || !is_numeric($c1) || strlen($c1) !=3)
                                { 
                                        $message = "<font color=\"red\">CALL POST: FAILED! // INVALID POST! CHECK VALUES.</font><br>";
                                 } else {
                                    $c2    = $_REQUEST['CODE2']; 
                                    $c3    = $_REQUEST['CODE3']; 
                                    $c4    = $_REQUEST['CODE4']; 

                                    $t1    = $_REQUEST['TIME1']; 
                                    $t2    = $_REQUEST['TIME2']; 
                                    $ta = $s2 . $t2; 
                                    $f7 = $_REQUEST['ACCOUNT']; 
                                    $f8 = implode("-", (array)$NOTE); 
                                    $f9 = $_REQUEST['DISPATCH']; 
                                    $s1 = ' // '; 
                                    $s2 = ' - '; 
                                    $spins = $f7 . $s1 . $t1 . $ta . $f8 . $f9; 
                                    $nd    = $_REQUEST['DROP']; 
                                    $ns    = $_REQUEST['CBS']; 

                                    require_once 'login.php'; 
                                    $db_server = mysql_connect($db_hostname, $db_username, $db_password);

                                    if (!$db_server) die("Unable to connect to server: " . mysql_error());

                                    mysql_select_db($db_database, $db_server) or die("Unable to select database: " .mysql_error());

                                         $check = "SELECT * FROM post WHERE callnumber = '$sc'";
                                         $result = mysql_query($check) or die("Unable to execute<br />$sql<br />".mysql_error());

                                                if(mysql_num_rows($result) == 1) {
                                                         $message = "<font color=\"red\">CALL POST: FAILED! // PREVIOUSLY POSTED.</font><br>";          

							 		  } else { 


                                   		 if(!mysql_num_rows(mysql_query("SELECT code FROM sc_codes WHERE code = '$c1'"))) { 
                                            $message = "<font color=\"red\">CALL POST: FAILED! // INVALID CODE[1]</font><br>";

									  } else if(!empty($c2)) {

									 	 if(!mysql_num_rows(mysql_query("SELECT code FROM sc_codes WHERE code = '$c2'"))) { 
                                            $message = "<font color=\"red\">CALL POST: FAILED! // INVALID CODE[2]</font><br>";

									  } else if(!empty($c3)) {

									 	 if(!mysql_num_rows(mysql_query("SELECT code FROM sc_codes WHERE code = '$c3'"))) { 
                                            $message = "<font color=\"red\">CALL POST: FAILED! // INVALID CODE[3]</font><br>";

									  } else if(!empty($c4)) {

									 	 if(!mysql_num_rows(mysql_query("SELECT code FROM sc_codes WHERE code = '$c4'"))) { 
                                            $message = "<font color=\"red\">CALL POST: FAILED! // INVALID CODE[4]</font><br>";

									   } else {

                                                       $query = "INSERT INTO post VALUES" . 
                                                       "(NOW(), '$tech', '$sc', '$c1', '$c2', '$c3', '$c4', '$spins', '$nd', '$ns', '$system')";

                                                       if (!mysql_query($query, $db_server)) 
                                                       //echo "POST FAILED: $query<br />" . 
                                                       mysql_error() . "<br /><br />"; 


                                                       $post = "\"$tech\",\"$sc\",\"\",\"$c1\",\"$c2\",\"$c3\",\"$c4\",\"$f9\",\"$nd\",\"$ns\"\r\n";

                                                       if(!file_exists("/home/systm/public_html/sjrb/posting/_store/101.csv"))
                                                        { 
                                                               //if file doesn't exist, create it and add headers.
                                                               $fp = fopen("/home/systm/public_html/sjrb/posting/_store/101.csv","a");
                                                               $headers = "\"TECH_NUMBER\",\"SERVICE_CALL_NUMBER\",\"ACCOUNT_NUMBER\",\"CODE_1\",\"CODE_2\",\"CODE_3\",\"CODE_4\",\"SPECIAL_INSTRUCTIONS\",\"DROP_NOTES\",\"CBS_NOTES\"\r\n";
                                                               fwrite($fp,$headers); 
                                                               fwrite($fp,$post); 
                                                               fclose($fp); 
                                                               chmod("/home/systm/public_html/sjrb/posting/_store/101.csv", 0777);

                                                           } else { 

													     $fp = fopen("/home/systm/public_html/sjrb/posting/_store/101.csv","a");
                                                               fwrite($fp,$post); 
                                                               fclose($fp); 
                                                           } 
                                                         }
													   }	
                   									}

                                                    $message = "<font color=\"red\">CALL POST: SUCCESSFUL!</font><br>";

                                                    //send email 

                                                    if(!empty($_REQUEST['ACCOUNT'])) 
                                                        { 

                                                            $to = 'xxxxxxxxx'.',xxxxxxxxxx';
                                                            $subject = "$tech has submitted TSD Notes for Service Call: $sc";

                                                            $body = ""; 
                                                            $spins = preg_replace("/\s+/", " ", $spins);
                                                            $aspins = str_split($spins, 745);
                                                            $body .= sprintf("ACCOUNT: %-45s\r\n", $aspins[0]);
                                                            array_shift($aspins); 

                                                            foreach($aspins as $a) 
                                                            { 
                                                            $body .= sprintf("      %-45s\r\n", $a);
                                                            } 

                                                            // To send HTML mail, the Content-type header must be set
                                                            //$headers = "From: xxxxxx <[e-mail]>\r\n";
                                                            $headers = 'From: '.$from."\r\n".
                                                            $headers = "MIME-Version: 1.0\r\n" ;
                                                            $headers .= "Content-Type: text/html; charset=\"iso-8859-1\"\r\n";
                                                            $headers .= "X-Priority: 1 (Higuest)\r\n";
                                                            $headers .= "X-MSMail-Priority: High\r\n";
                                                            $headers .= "Importance: High\r\n";

                                                            mail($to,$subject, $body, $headers);
                                                            $message = "<font color=\"red\">CALL POST: SUCCESSFUL! // TSD NOTES SUBMITTED.</font><br>";

                                                        } 
                                                    if(isset($_REQUEST['COACHING'])) 
                                                        { 
                                                            header("Location: http://xxxxxxxxxxxxx/index.php?tech=" . $_REQUEST['TECH'] . "&sc=" . $_REQUEST['CALLNUMBER'] . "&message=Service Call : Posted!");
                                                        } 

                                                } 

                                        } 
                                } 
                          } 
?>