Currency last update visible in currencies box

[Druide]

add in catalog/includes/functions/general.php

before ?>

////

// Return currencies update date

// TABLES: currencies



 function tep_get_currencies_date($last_update_currencies) {

   

   $currencies_date_query = tep_db_query("select last_updated from " . TABLE_CURRENCIES . " where code = '" . CURRENCY_UPDATE . "'");

   $currencies_date = tep_db_fetch_array($currencies_date_query);



   return $currencies_date['last_updated'];

 }

 

add into your MySQL database:

INSERT INTO configuration VALUES ('', 'Currency Code for Update', 'CURRENCY_UPDATE', 'USD', 'Currency Code for Update<br>(take from TABLE currencies Field: code)', 1, 99999, NULL, '2003-03-18 00:59:38', NULL, NULL);

 

you can configure the above at

Admin > Configuration > My Store > Currency Code for Update

 

find at the end of catalog/includes/boxes/currencies.php

 

  $select_box .= $hidden_get_variables;



 $info_box_contents = array();

 $info_box_contents[] = array('form'  => '<form name="currencies" method="get" action="' . tep_href_link(basename($PHP_SELF), '', $connection, false) . '">',

                              'align' => 'left',

                              'text'  => $select_box

                             );



 new infoBox($info_box_contents);

?>

           </td>

         </tr>

<!-- currencies_eof //-->

 

replace by

 

$select_box .= $hidden_get_variables;



 $currencies_update = tep_get_currencies_date(DEFAULT_CURRENCY);



 $info_box_contents = array();

 $info_box_contents[] = array('form'  => '<form name="currencies" method="get" action="' . tep_href_link(basename($PHP_SELF), '', $connection, false) . '">',

                              'align' => 'left',

                              'text'  => $select_box . ' <center>updated at<br>' . $currencies_update . ' </center>'

                             );



 new infoBox($info_box_contents);

?>

           </td>

         </tr>

<!-- currencies_eof //-->

 

preview at http://www.ruddlesmills.com/default.php

 

let me know if you think its usefull