Hi,
I recently updated my /includes/functions/functions_prices.php file to enable MAP pricing. I replaced:
return $final_display_price . $free_tag . $call_tag; (around line 296) to:
//Map Pricing by SlickRicky Design : http://www.slickricky.com
$database = mysql_connect('<DATABASE HOST>', '<DATABASE NAME>', '<DATABASE PASSWORD>')
or die('Could not connect: ' . mysql_error());
mysql_select_db('<DATABASE NAME>') or die('Could not select database');
$query = sprintf("SELECT map_enabled FROM ".TABLE_PRODUCTS." where products_id = '" . $products_id . "'" . " limit 1");
$result = mysql_query($query);
$is_map_enabled = mysql_result($result, 0);
if ($is_map_enabled == 1){
return '<span class="map_pricing">'.MAP_PRICE_STORE_FRONT_TEXT.'</span>';
} else {
return $final_display_price . $free_tag . $call_tag;
}
//End Edit SlickRicky Design : http://www.slickricky.com
I entered mysql.shop.thebricktongroup.com as my db host and I entered the name of my db "store" and the correct password.
Now when I try to access my site I get the following error:
Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host '<mysql.shop.thebricktongroup.com>' (1) in /home/.frowsy/bgroup01/shop.thebricktongroup.com/includes/functions/functions_prices.php on line 282
Could not connect:
Any ideas would be greatly appreciated.
Nate



