Please Help.. All I want to do is move a small peice of code???

peter rabbit · December 28, 2009

Hi,

I am modify a how products information is displayed and simply want to place $extra_fields['value']; after the products price, what am i doing wrong??

Please see bellow:

<?php

// RCI code start

echo $cre_RCI->get('global', 'top');

echo $cre_RCI->get('productinfo', 'top');

// RCI code eof

echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')); ?>

<?php

if ($product_check['total'] < 1) {

?>

<tr>

<td><?php new infoBox(array(array('text' => TEXT_PRODUCT_NOT_FOUND))); ?></td>

</tr>

<tr>

</tr>

<tr>

<tr>

<td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_template_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td>

</tr>

</table></td>

</tr>

</table></td>

</tr>

<?php

} else {

// BOF MaxiDVD: Modified For Ultimate Images Pack!

$product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, p.products_image_med, p.products_image_lrg, p.products_image_sm_1, p.products_image_xl_1, p.products_image_sm_2, p.products_image_xl_2, p.products_image_sm_3, p.products_image_xl_3, p.products_image_sm_4, p.products_image_xl_4, p.products_image_sm_5, p.products_image_xl_5, p.products_image_sm_6, p.products_image_xl_6, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

// EOF MaxiDVD: Modified For Ultimate Images Pack!

$product_info = tep_db_fetch_array($product_info_query);

tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'");

if (tep_not_null($product_info['products_model'])) {

$products_name = $product_info['products_name'];

} else {

$products_name = $product_info['products_name'];

}

if ($product_has_sub > '0'){ // if product has sub products

$products_price ='';// if you like to show some thing in place of price add here

} else {

$pf->loadProduct($product_info['products_id'],$languages_id);

$products_price = $pf->getPriceStringShort();

} // end sub product check

// BOF: Dave added to show stars

$rating = 5;

$query = tep_db_query("SELECT AVG(reviews_rating) as rating FROM ".TABLE_REVIEWS." WHERE products_id='".$data['products_id']."'");

if($rec = tep_db_fetch_array($query)){

if($rec['rating'] > 0){

$rating = ceil($rec['rating']);

}

// BOF: WebMakers.com Added: Show Featured Products

if (SHOW_HEADING_TITLE_ORIGINAL=='yes') {

$header_text = ' ';

?>

<tr>

<tr>

<tr>

<td> <?php

if ($product_info['products_image_med']!='') {

$new_image = $product_info['products_image_med'];

$image_width = MEDIUM_IMAGE_WIDTH;

$image_height = MEDIUM_IMAGE_HEIGHT;

} else {

$new_image = $product_info['products_image'];

$image_width = SMALL_IMAGE_WIDTH;

$image_height = SMALL_IMAGE_HEIGHT;

}

echo tep_javascript_image(DIR_WS_IMAGES . $new_image, 'product' . $product_info['products_id'], addslashes($product_info['products_name']), $image_width, $image_height, 'hspace="5" vspace="5"', 'true');

?></td>

</tr>

</table>

<?php

//affiliate build a link begin

if (tep_session_is_registered('affiliate_id')) {

echo '<br><br><a href="' . tep_href_link(FILENAME_AFFILIATE_BANNERS_BUILD, 'individual_banner_id=' . $product_info['products_id']) .'" target="_self">' . tep_template_image_button('button_affiliate_build_a_link.gif', LINK_ALT) . ' </a>'; ?>

<?php

}

//affiliate build a link begin

?>

</div></td><td width="35%" align="left" valign="top" class="pageHeading"><table border="1" CELLSPACING="0" cellpadding="0" width="50" height="264" bordercolor="#CCCCCC">

<tbody>

<tr>

</td>

</tr>

<tr>

<!--

.style1 {font-size: 12px}

-->

</style>

<span class="productlisting-headingPrice style1">Overall Rating:</span> '.tep_image(DIR_WS_TEMPLATES . TEMPLATE_NAME . '/images/stars_'.$rating.'.gif').'

'?>

<br/>

<a href="<?php echo tep_href_link(FILENAME_PRODUCT_REVIEWS_INFO, tep_get_all_get_params());?>" class="subnavBlue">Read all reviews</a> <a href="<?php echo tep_href_link(FILENAME_PRODUCT_REVIEWS_WRITE, tep_get_all_get_params());?>" class="subnavBlue">Write a Review</a> </div>

</div>

</tr>

<tr>

<td>

<tr>

<td>

<tr>

<?php {?>

<?php }?>

</tr>

</table>

</td>

</tr>

</table>

<tr>

</tr>

</table></td>

</tr>

<tr>

</td>

<tr>

</td>

</tr>

</tbody>

</table></td>

</tr>

</table></td>

</tr>

<tr>

</tr>

<?php

} else {

?>

</tr><tr>

</td></td></tr></table><td>

<?php

}

// BOF: Lango Added for template MOD

if (MAIN_TABLE_BORDER == 'yes'){

table_image_border_top(false, false, $header_text);

} else {

echo $header_text ;

}

// EOF: Lango Added for template MOD

?>

<tr>

<tr>

<?php if (tep_not_null($product_info['products_image'])) { ?>

</table>

<?php } ?>

<?php echo tep_draw_separator('pixel_trans.gif', '100%', '10');

$products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' ");

$products_attributes = tep_db_fetch_array($products_attributes_query);

if ($products_attributes['total'] > 0) {

?>

<tr>

</tr>

<?php

$products_options_query = tep_db_query("select pa.options_id, pa.options_values_id, pa.options_values_price, pa.price_prefix, po.options_type, po.options_length, pot.products_options_name, pot.products_options_instruct from

" . TABLE_PRODUCTS_ATTRIBUTES . " AS pa,

" . TABLE_PRODUCTS_OPTIONS . " AS po,

" . TABLE_PRODUCTS_OPTIONS_TEXT . " AS pot

where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'

and pa.options_id = po.products_options_id

and po.products_options_id = pot.products_options_text_id and pot.language_id = '" . (int)$languages_id . "'

order by pa.products_options_sort_order

");

// Store the information from the tables in arrays for easy of processing

$options = array();

$options_values = array();

while ($po = tep_db_fetch_array($products_options_query)) {

// we need to find the values name

if ( $po['options_type'] != 1 && $po['options_type'] != 4 ) {

$options_values_query = tep_db_query("select products_options_values_name from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id ='". $po['options_values_id'] . "' and language_id = '" . (int)$languages_id . "'");

$ov = tep_db_fetch_array($options_values_query);

} else {

$ov['products_options_values_name'] = '';

}

$options[$po['options_id']] = array('name' => $po['products_options_name'], 'type' => $po['options_type'], 'length' => $po['options_length'], 'instructions' => $po['products_options_instruct']);

$options_values[$po['options_id']][$po['options_values_id']] = array('name' => stripslashes($ov['products_options_values_name']), 'price' => $po['options_values_price'], 'prefix' => $po['price_prefix']);

}

foreach ($options as $oID => $op_data) {

switch ($op_data['type']) {

case 1:

$maxlength = ( $op_data['length'] > 0 ? ' maxlength="' . $op_data['length'] . '"' : '' );

$tmp_html = '<input type="text" name="id[' . $oID . '][t]"' . $maxlength . ' />';

?>

<tr>

<td class="main"><?php echo $op_data['name'] . ':' . ($op_data['instructions'] != '' ? '<br /><span class="smallText">' . $op_data['instructions'] . '</span>' : '' ); ?></td>

</tr>

<?php

break;

case 4:

$text_area_array = explode(';',$op_data['length']);

$cols = $text_area_array[0];

if ( $cols == '' ) $cols = '100%';

$rows = $text_area_array[1];

$tmp_html = '<textarea name="id[' . $oID . '][t]" rows="'.$rows.'" cols="'.$cols.'" wrap="virtual"></textarea>';

?>

<tr>

<td class="main"><?php echo $op_data['name'] . ':' . ($op_data['instructions'] != '' ? '<br /><span class="smallText">' . $op_data['instructions'] . '</span>' : '' ); ?></td>

</tr>

<?php

break;

case 2:

$tmp_html = '';

foreach ( $options_values[$oID] as $vID => $ov_data ) {

if ( (float)$ov_data['price'] == 0 ) {

$price = ' ';

} else {

$price = '( ' . $ov_data['prefix'] . ' ' . $currencies->display_price($ov_data['price'], $tax_rate) . ' )';

}

$tmp_html .= '<input type="radio" name="id[' . $oID . ']" value="' . $vID . '">' . $ov_data['name'] . ' ' . $price . '<br />';

} // End of the for loop on the option value

?>

<tr>

<td class="main"><?php echo $op_data['name'] . ':' . ($op_data['instructions'] != '' ? '<br /><span class="smallText">' . $op_data['instructions'] . '</span>' : '' ); ?></td>

</tr>

<?php

break;

case 3:

$tmp_html = '';

$i = 0;

foreach ( $options_values[$oID] as $vID => $ov_data ) {

if ( (float)$ov_data['price'] == 0 ) {

$price = ' ';

} else {

$price = '( '.$ov_data['prefix'] . ' ' . $currencies->display_price($ov_data['price'], $tax_rate).' )';

}

$tmp_html .= '<input type="checkbox" name="id[' . $oID . '][c][' . $i . ']" value="' . $vID . '">' . $ov_data['name'] . ' ' . $price . '<br />';

$i++;

}

?>

<tr>

<td class="main"><?php echo $op_data['name'] . ':' . ($op_data['instructions'] != '' ? '<br /><span class="smallText">' . $op_data['instructions'] . '</span>' : '' ); ?></td>

</tr>

<?php

break;

case 0:

$tmp_html = '<select name="id[' . $oID . ']">';

foreach ( $options_values[$oID] as $vID => $ov_data ) {

if ( (float)$ov_data['price'] == 0 ) {

$price = ' ';

} else {

$price = '( '.$ov_data['prefix'] . ' ' . $currencies->display_price($ov_data['price'], $tax_rate).' )';

}

$tmp_html .= '<option value="' . $vID . '">' . $ov_data['name'] . ' ' . $price .'</option>';

} // End of the for loop on the option values

$tmp_html .= '</select>';

?>

<tr>

<td class="main"><?php echo $op_data['name'] . ':' . ($op_data['instructions'] != '' ? '<br /><span class="smallText">' . $op_data['instructions'] . '</span>' : '' ); ?></td>

</tr>

<?php

break;

} //end of switch

} //end of while

?>

</table>

<?php

} // end of ($products_attributes['total'] > 0)

?>

</td>

</tr>

</table></td>

</tr>

<tr>

</tr>

<?php

// BOF MaxiDVD: Modified For Ultimate Images Pack!

if (ULTIMATE_ADDITIONAL_IMAGES == 'enable') { include(DIR_WS_MODULES . 'additional_images.php'); }

// BOF MaxiDVD: Modified For Ultimate Images Pack!

?>

<tr>

</tr>

<?php

$reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'");

$reviews = tep_db_fetch_array($reviews_query);

if ($reviews['count'] > 0) {

?>

<tr>

</tr>

<tr>

</tr>

<?php

}

// Extra Products Fields are checked and presented

// START: Extra Fields Contribution DMG

$extra_fields_query = tep_db_query("SELECT pef.products_extra_fields_status as status, pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value

FROM ". TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS ." ptf,

". TABLE_PRODUCTS_EXTRA_FIELDS ." pef

WHERE ptf.products_id='".(int)$HTTP_GET_VARS['products_id']."'

and ptf.products_extra_fields_value <> ''

and ptf.products_extra_fields_id = pef.products_extra_fields_id

and (pef.languages_id='0' or pef.languages_id='".$languages_id."')

ORDER BY products_extra_fields_order");

if ( tep_db_num_rows($extra_fields_query) > 0 ) {

?>

<tr>

<?php

while ($extra_fields = tep_db_fetch_array($extra_fields_query)) {

if (! $extra_fields['status']) // show only enabled extra field

continue;

?>

<tr>

</tr>

<?php

}

?>

</table></td>

</tr>

<?php

}

// END: Extra Fields Contribution

if (tep_not_null($product_info['products_url'])) {

?>

<tr>

</tr>

<tr>

</tr>

<?php

}

if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) {

?>

<tr>

</tr>

<?php

} else {

?>

<tr>

</tr>

<?php

}

// BOF: Lango Added for template MOD

if (MAIN_TABLE_BORDER == 'yes'){

$header_text= ' ';

table_image_border_bottom(false, false, $header_text);

}

// EOF: Lango Added for template MOD

///////////////////////////////////////////////////////////////////////////////////////////////////////////

// MOD begin of sub product

if(STOCK_ALLOW_CHECKOUT =='false')

{$allowcriteria=" and p.products_quantity >0";}else{$allowcriteria="";}

// get sort order

$csort_order = tep_db_fetch_array(tep_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'CATEGORIES_SORT_ORDER'"));

$select_order_by = '';

switch ($csort_order['configuration_value']) {

case 'PRODUCT_LIST_MODEL':

$select_order_by .= 'p.products_model';

break;

case 'PRODUCT_LIST_NAME':

$select_order_by .= 'pd.products_name';

break;

//commented out - do subproducts have different manufacturers?

// case 'PRODUCT_LIST_MANUFACTURER':

// $select_order_by .= 'm.manufacturers_name, ';

// break;

case 'PRODUCT_LIST_PRICE':

$select_order_by .= 'p.products_price';

break;

default:

$select_order_by .= 'p.products_model';

break;

}

$sub_products_sql = tep_db_query("select p.products_id, p.products_price, p.products_tax_class_id, p.products_image, pd.products_name, pd.products_description, p.products_model from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_parent_id = " . (int)$HTTP_GET_VARS['products_id'] . " ".$allowcriteria." and p.products_id = pd.products_id and pd.language_id = " . (int)$languages_id . " order by " . $select_order_by);

if (tep_db_num_rows($sub_products_sql) > 0) {

// BOF: Lango Added for template MOD

if (MAIN_TABLE_BORDER == 'yes'){

$header_text= ' ';

table_image_border_top(false, false, $header_text);

}

// EOF: Lango Added for template MOD

?>

<tr>

<table>

<?php

while ($sub_products = tep_db_fetch_array($sub_products_sql)) {

$subname = substr( $sub_products['products_name'], strlen( $product_info['products_name'] . ' - ' ));

$pf->loadProduct($sub_products['products_id'],$languages_id);

$sub_products_price = $pf->getPriceStringShort();

?>

</tr>

<?php

}

?>

</table>

</td>

</tr>

<?php

// BOF: Lango Added for template MOD

if (MAIN_TABLE_BORDER == 'yes'){

table_image_border_bottom();

}

// EOF: Lango Added for template MOD

}

// MOD end of sub product

///////////////////////////////////////////////////////////////////////////////////////////////////////////

if ($product_check['total'] > 0) {

?>

<tr>

<tr>

<td class="main" valign="middle"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params()) . '">' . tep_template_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS,'align="absmiddle"') . '</a>'; ?></td>

<?php

if (DESIGN_BUTTON_WISHLIST == 'true') {

echo '<td align="right" class="main" valign="middle">';

if( (!tep_session_is_registered('customer_id')) || (!tep_session_is_registered('SESSION_WISHLIST')) ){

$SESSION_WISHLIST = $product_info['products_id'];

tep_session_register('SESSION_WISHLIST');

}

echo '<a href="javascript:document.cart_quantity.action=\'' . tep_href_link(FILENAME_PRODUCT_INFO, 'action=add_wishlist') . '\'; document.cart_quantity.submit();">' . tep_template_image_button('button_add_wishlist.gif', IMAGE_BUTTON_ADD_WISHLIST,'align="absmiddle"') . '</a>' ;

echo '</td>';

}

?>

<?php } ; ?>

<tr>

<?php if (tep_db_num_rows($sub_products_sql) ==0) {?>

<?php }?>

</tr>

</table></form></td>

</tr>

</table></td>

</tr>

</table></td>

</tr>

<tr>

</tr>

<?php

// RCI code start

echo $cre_RCI->get('productinfo', 'bottom');

echo $cre_RCI->get('global', 'bottom');

// RCI code eof

if ( (USE_CACHE == 'true') && !SID) {

echo tep_cache_also_purchased(3600);

include(DIR_WS_MODULES . FILENAME_XSELL_PRODUCTS);

} else {

include(DIR_WS_MODULES . FILENAME_XSELL_PRODUCTS_BUYNOW);

echo tep_draw_separator('pixel_trans.gif', '100%', '10');

include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);

}

// }

?>

</td>

</tr>

<tr>

<td>

<?php

if(B2B_PRICE_BREAK=='true') {

echo tep_draw_separator('pixel_trans.gif', '100%', '10');

include(DIR_WS_MODULES . FILENAME_PRODUCT_QUANTITY_TABLE);

}

}?>

</td>

</tr>

</table>

harkly · January 13, 2010

1st of all you need to put your code in the code box

 like this

it is very hard to read

2nd there is so much code, condense it down to just the problem area. Getting ride of the extra can also help you troubleshoot the issue.

Sign In

Please Help.. All I want to do is move a small peice of code???

Recommended Posts

peter rabbit

Link to comment

Share on other sites

harkly

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information