Register Globals vs Extra Fields

[ApedroF]

Hi there,

 

I'm getting this annoying problem that i simply can not work around.

 

After my host provider inform me that they needed to set register globals - OFF, my instalation just stopped working.

 

I search for some contribution to solve this problem and i found it:

http://www.oscommerce.com/community/contri...ter+globals+off

(thank you Richard Bentley)

 

Then i made some changes also to Easy Populate and that work out fine.

 

However, the extra-fields contribution stop working.

I mean, it can't display those values. The database has it, but the product_info.php can not display them

 

Does anyone know this problem and how to solve it?

I think is something about variables, but i'm no programmer and i can't solve by it myself.

 

I thank you in advance.

Take care

Pedro

 

 

the code in product_info.php is:

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

// START: Extra Fields Contribution v2.0a

$extra_fields_query = tep_db_query("

SELECT pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value

FROM ". TABLE_PRODUCTS_EXTRA_FIELDS ." pef

LEFT JOIN ". TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS ." ptf

ON ptf.products_extra_fields_id=pef.products_extra_fields_id

WHERE ptf.products_id=".(int)$products_id." and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='".$languages_id."')

ORDER BY products_extra_fields_order");

 

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

echo ' '.$extra_fields['name'].' ';

echo '<b>'.$extra_fields['value'].'</b>   ';

 

}

 

// END: Extra Fields Contribution

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