Jump to content

Archived

This topic is now archived and is closed to further replies.

gaspower

Why Is Database Not Updating With Admin File

Recommended Posts

Hello,

 

I have this file below to do a mass price update for SPPC groups. I am using OSC2.31, but for some reason it is not updating the database tables? I am not getting any errors. If the file looks correct, can the database permissions be set incorrectly?

 

Thanks JR

 

<?php
 require('includes/application_top.php');

?>
<!DOCTYPE html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<script language="javascript" src="includes/general.js"></script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF" onload="SetFocus();">
<div id="popupcalendar" class="text"></div>
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'template_top.php'); ?>
<!-- header_eof //-->


<?php
if (isset($_POST['Update']))
{
$sppc_query_raw = "select * from " . TABLE_CUSTOMERS_GROUPS . " order by customers_group_id";
$sppc_query = tep_db_query($sppc_query_raw);
while( $sppc = tep_db_fetch_array( $sppc_query ) ) {

 if ($sppc["customers_group_name"] != "Retail"){
//$sppc['customers_group_id']
$c = "CG_".$sppc['customers_group_id'];
$tmp = $_POST[$c];
if ($tmp != 0)
{
$p = (100-$_POST[$c])/100;
tep_db_query("delete from products_groups where customers_group_id = ".$sppc['customers_group_id']);

tep_db_query ("insert into products_groups select '". $sppc['customers_group_id'] ."' as customers_group_id, ( " . $p . " * p.products_price) as customers_group_price, p.products_id from products p");
}  //if not 0
}  //if not Retail
}
}

?>
<!-- body //-->
<table border="0" width="100%" cellspacing="2" cellpadding="2">
 <tr>
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
</table></td>
<!-- body_text //-->
<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
  <tr>
	<td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">
	  <tr>
		<td class="pageHeading"><?php echo "Special Pricing Discount Setup"; ?></td>
		<td class="specialPrice" align="right"> </td>
	  </tr>
	</table></td>
  </tr>

  <tr>
	<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
	  <tr>
		<td valign="top"><table border="0" width="100%" cellspacing="2" cellpadding="2">
		  <tr class="dataTableHeadingRow">
			<td class="dataTableHeadingContent" align="left">
			<?php
			if (isset($_POST['Update']))
			{
				echo "<center>Updated!</center>";
			}
			?>
			 </td>
		  </tr>
<?php

$sppc_query_raw = "select * from " . TABLE_CUSTOMERS_GROUPS . " order by customers_group_id";
$sppc_query = tep_db_query($sppc_query_raw);
while( $sppc = tep_db_fetch_array( $sppc_query ) ) {
?>
		  <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)">
			 <td class="dataTableContent" align="left">
			  <?php
			  if ($sppc["customers_group_name"] != "Retail"){
				  echo $sppc["customers_group_name"];
			  }
			  if (isset($_POST['Update']))
			  {
					if ($sppc["customers_group_name"] != "Retail"){
					$c = "CG_".$sppc['customers_group_id'];
					$tmp = $_POST[$c];
					echo " Current Discount is $tmp%" ;

					}
			  }
			  ?>

			  </td>
		  </tr>
<?php
 }
?>
	</table></td>
  </tr>
  <tr>
   <td valign="top">
   <form action="" method="post">
	<table border="0" width="40%" cellspacing="0" cellpadding="2">
		  <tr>
			<td class="smallText" align="left"> </td>
			<td> </td>
		  </tr>
<?php
$sppc_query_raw = "select * from " . TABLE_CUSTOMERS_GROUPS . " order by customers_group_id";
$sppc_query = tep_db_query($sppc_query_raw);
while( $sppc = tep_db_fetch_array( $sppc_query ) ) {

if ($sppc["customers_group_name"] != "Retail"){
?>
		  <tr>
			<td class="smallText" align="left">Set New Percentage (%) Discount for <?=$sppc["customers_group_name"]?> :</td>
			<td><input name="CG_<?=$sppc['customers_group_id']?>" type="text" size="5" value="0"></td>
		  </tr>
<?php
		  }
 }
?>
		  <tr>
			<td colspan="2" align="center"><input type="submit" name="Update" value="Update"></td>
		  </tr>
	</table>
	</form>
   </td>
  </tr>
</table></td>
<!-- body_text_eof //-->
 </tr>
</table>
<!-- body_eof //-->
<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Share this post


Link to post
Share on other sites

any errors displayed?


Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here!

8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself.

Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues.

Any issues with oscommerce, I am here to help you.

Share this post


Link to post
Share on other sites

Hello,

 

Thank you for the response. No errors, it performs as everything is working fine. It just does not insert on the first try. Can this be a table issue and not the script issue?

 

Thanks

Share this post


Link to post
Share on other sites

×