All pastes #71073 Raw Edit

Ryan Rules

public php v1 · immutable
#71073 ·published 2006-06-25 05:59 UTC
rendered paste body
<?require_once('../ver.php');require_once('../auth.php');sec_verify();require_once('../v2s.php');require_once("conf/conf.php");require_once("functions/database.php");mysqlConnect($dbdb, $dbserver, $dbuser, $dbpass);?><html><head><title>Untitled Document</title><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><?include_once("includes/css.php");?></head><body topmargin="0" leftmargin="0" bgcolor="#0066FF"><?$Reference_ID = $_GET['Reference_ID'];$verify_reference = mysql_query("SELECT Reference_ID FROM reference WHERE Reference_ID=\"$Reference_ID\" LIMIT 1");  //set review rows  $verify = mysql_fetch_array($verify_reference);  $Reference_ID_db = $verify["Reference_ID"];$branch_location = mysql_query("SELECT City FROM branch WHERE Branch_ID=\"$Branch_ID\" LIMIT 1");  $branch = mysql_fetch_array($branch_location);  $branch_location_db = $branch["City"];?><div class="topbar"><table width="700" height="20" border="1" cellspacing="0" cellpadding="2" bgcolor="#0099FF">  <tr>    <td><font class="normal">User:<strong> <?=strtoupper($Username);?></strong> Branch: <strong><?=strtoupper($Branch_ID."(".$branch_location_db.")");?></strong> Reference: <strong><?=($Reference_ID);?></strong></font></td>  </tr></table></div><div class="menu"><table width="150" height="400" border="1" cellspacing="0" cellpadding="2" bgcolor="#0099FF">  <tr>    <td height="80" align="center"><font class="normal">Step 1:<br />Starting Information</font></td>  </tr>  <tr>    <td height="80" align="center"><a href="">Step 2:<br />Client/Vendor<br />Information</a></td>  </tr>  <tr>    <td height="80" align="center"><a href="">Step 3:<br />Shipment Information</a></td>  </tr>  <tr>    <td height="80" align="center"><a href="">Step 4:<br />CCI Completion</a></td>  </tr>  <tr>    <td height="80" align="center"><a href="">Step 5:<br />Verify Shipment</a></td>  </tr></table></div><div class="main"><table width="530" height="400" border="1" cellspacing="0" cellpadding="5" bgcolor="#0099FF">  <tr>    <td align="left" valign="top"><?        if(isset($_GET['started']) && isset($_GET['Reference_ID']))  {          if($_GET['started'] == "1")  {            if($Reference_ID == $Reference_ID_db)  {?>	<h2 align="center">Starting Information:</h2>	<br />	<form action="entry2.php?verify=1&Reference_ID=<?=($Reference_ID);?>" method="post">	<table width="500" border="0" cellspacing="0" cellpadding="5">      <tr>        <td width="200"><strong>Company ID:</td>        <td width="300"><input type="text" name="Company_ID" value="11" size="2" /></td>      </tr>      <tr>        <td width="200"><strong>Client:</td>        <td width="300"><input type="text" name="Client_ID" size="6" /> <a href="#"onClick="window.open('csearch.php','lswWin2','toolbar=no,scrollbars=yes,resizable=no,width=510,height=400')">(Search)</a></td>      </tr>      <tr>        <td width="200"><strong>Release Type:</td>        <td width="300"><input type="text" name="Release_Type" size="2" /></td>      </tr>      <tr>        <td width="200"><strong>Is Shipment EDI:</td>        <td width="300"><input type="text" name="Is_EDI" value="Y" size="2" /></td>      </tr>      <tr>        <td width="200"><strong>Port Of Exit:</td>        <td width="300"><input type="text" name="Port_Of_Exit" size="3" /></td>      </tr>      <tr>        <td width="200"><strong>Direct Date Of Shipment:</strong></td>        <td width="300"><input type="text" name="Date_Of_Shipment" size="6" /></td>      </tr>      <tr>        <td width="200"><strong>Value:</strong></td>        <td width="300"><input type="text" name="Value" size="16" /></td>      </tr>      <tr>        <td width="200"><strong>Currency:</strong></td>        <td width="300"><input type="text" name="Currency" size="3" /></td>      </tr>    </table><br />        <input type="hidden" name="Reference_ID" value= "<?=($Reference_ID);?>" />        <input type="hidden" name="User_ID" value= "<?=($User_ID);?>" />	<input type="submit" value="Submit">	</form><?}}}        if(isset($_GET['verify']))  {          if($_GET['verify'] === "1")  {          $Reference_ID = $_POST['Reference_ID'];          $Company_ID = trim($_POST['Company_ID']);          $Client_ID = trim($_POST['Client_ID']);          $Date_Of_Shipment = $_POST['Date_Of_Shipment'];          $Value = $_POST['Value'];          $Port_Of_Exit = $_POST['Port_Of_Exit'];          $Currency = strtoupper($_POST['Currency']);          $User_ID = strtoupper($_POST['User_ID']);          $Date_Of_Shipment = strtoupper($_POST['Date_Of_Shipment']);          $Is_EDI = strtoupper($_POST['Is_EDI']);          $Release_Type = strtoupper($_POST['Release_Type']);$client_details = mysql_query("SELECT Business_Name, Business_Number, Address1, Address2, Address3, Postal_Code, City, State, Country FROM clients WHERE Client_ID=\"$Client_ID\" LIMIT 1");  while ($client = mysql_fetch_array($client_details))  {  $client_details_db_business_name = $client["Business_Name"];  $client_details_db_business_number = $client["Business_Number"];  $client_details_db_address1 = $client["Address1"];  $client_details_db_address2 = $client["Address2"];  $client_details_db_address3 = $client["Address3"];  $client_details_db_postal_code = $client["Postal_Code"];  $client_details_db_city = $client["City"];  $client_details_db_state = $client["State"];  $client_details_db_country = $client["Country"];}$company_name = mysql_query("SELECT Name FROM company WHERE Company_ID=\"$Company_ID\" LIMIT 1");  $company = mysql_fetch_array($company_name);  $company_name_db = $company["Name"];?>          <form action="process.php?verify=page1" method="post">          <input type="hidden" name="Reference_ID" value="<?=$Reference_ID;?>" />          <input type="hidden" name="Company_ID" value="<?=$Company_ID;?>" />          <input type="hidden" name="Client_ID" value="<?=$Client_ID;?>" />          <input type="hidden" name="Date_Of_Shipment" value="<?=$Date_Of_Shipment;?>" />          <input type="hidden" name="Value" value="<?=$Value;?>" />          <input type="hidden" name="Currency" value="<?=$Currency;?>" />          <input type="hidden" name="User_ID" value="<?=$User_ID;?>" />          <input type="hidden" name="Port_Of_Exit" value="<?=$Port_Of_Exit;?>" />          <input type="hidden" name="Date_Of_Shipment" value="<?=$Date_Of_Shipment;?>" />          <input type="hidden" name="Is_EDI" value="<?=$Is_EDI;?>" />          <input type="hidden" name="Release_Type" value="<?=$Release_Type;?>" /><font class="normal">	<table width="500" border="0" cellspacing="0" cellpadding="5">      <tr>        <td width="200"><strong>Company Name:</strong></td>        <td width="300"><?=$Company_ID." - ".$company_name_db;?></td>      </tr>      <tr>        <td width="200" align="top"><strong>Client:</td>        <td width="300">        <?=$client_details_db_business_name;?><br />        <?=$client_details_db_business_number;?><br />        <?=$client_details_db_address1;?><br />        <?=$client_details_db_address2;?><br />        <?=$client_details_db_address3;?><br />        <?=$client_details_db_city;?>,         <?=$client_details_db_state;?>,         <?=$client_details_db_country;?><br />        <?=$client_details_db_postal_code;?></td>      </tr>      <tr>        <td width="200"><strong>Direct Date Of Shipment:</strong></td>        <td width="300"><?=$Date_Of_Shipment;?></td>      </tr>      <tr>        <td width="200"><strong>Port Of Exit:</strong></td>        <td width="300"><?=$Port_Of_Exit;?></td>      </tr>      <tr>        <td width="200"><strong>Is Shipment EDI:</strong></td>        <td width="300"><?=$Is_EDI;?></td>      </tr>      <tr>        <td width="200"><strong>Release_Type:</strong></td>        <td width="300"><?=$Release_Type;?></td>      </tr>      <tr>        <td width="200"><strong>Value:</strong></td>        <td width="300"><?=$Value;?></td>      </tr>      <tr>        <td width="200"><strong>Currency:</strong></td>        <td width="300"><?=$Currency;?></td>      </tr>    </table><br /><font class="normal">Are you absolutely sure this information is correct?<br /><br /></font>          <input type="submit" value="Yes">          </form><br /><br />          <form action="entry2.php?started=1&Reference_ID=<?=$Reference_ID;?>" method="post">          <input type="submit" value="No">          </form><?         }         else { echo "You're doing something wrong...";}      }?>	</td>  </tr></table></div><div class="bottombar"><table width="700" height="20" border="1" cellspacing="0" cellpadding="2" bgcolor="#0099FF">  <tr>    <td><a href="entry1.php">Exit release</a></td>  </tr></table></div></body></html>