AlegroCart

Code: Select all

DROP TABLE IF EXISTS currencies;
CREATE TABLE currencies (
  currencies_id int(11) NOT NULL auto_increment,
  title varchar(32) NOT NULL default '',
  code char(3) NOT NULL default '',
  symbol_left varchar(24) default NULL,
  symbol_right varchar(24) default NULL,
  decimal_point char(1) default NULL,
  thousands_point char(1) default NULL,
  decimal_places char(1) default NULL,
  value float(13,8) default NULL,
  last_updated datetime default NULL,
  PRIMARY KEY  (currencies_id)
) ENGINE=MyISAM;

Code: Select all

CREATE TABLE IF NOT EXISTS `currency` (
  `currency_id` int(11) NOT NULL auto_increment,
  `title` varchar(32) collate utf8_unicode_ci NOT NULL default '',
  `code` varchar(3) collate utf8_unicode_ci NOT NULL default '',
  `symbol_left` varchar(12) collate utf8_unicode_ci default NULL,
  `symbol_right` varchar(12) collate utf8_unicode_ci default NULL,
  `decimal_place` char(1) collate utf8_unicode_ci default NULL,
  `value` double(13,8) default NULL,
  `date_modified` datetime default NULL,
  PRIMARY KEY  (`currency_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Code: Select all

$string .= number_format(round($value, $decimal_place), $decimal_place, (($format) ? $this->language->get('decimal_point') : '.'), (($format) ? $this->language->get('thousand_point') : NULL));

Code: Select all

#phpinfo .a, #phpinfo .b {
	margin: 20px;
	padding: 10px;
}

#phpinfo table, td, tr {font-family: sans-serif; font-size: 11px; text-align: left;}
#phpinfo .p {text-align: center;}
#phpinfo .e {background-color: #ccccff; font-weight: bold; font-size: 11px;}
#phpinfo .h {background-color: #9999cc; font-weight: bold; font-size: 11px;}
#phpinfo .v {background-color: #cccccc; font-size: 12px;}
#phpinfo i {color: #666666; font-size: 11px;}
#phpinfo hr {display: none; font-size: 11px;}