mySQLSafe($_POST['code']); $record["name"] = $db->mySQLSafe($_POST['name']); $record["symbolLeft"] = $db->mySQLSafe(validHTML($_POST['symbolLeft'])); $record["symbolRight"] = $db->mySQLSafe(validHTML($_POST['symbolRight'])); $record["value"] = $db->mySQLSafe($_POST['value']); $record["decimalPlaces"] = $db->mySQLSafe($_POST['decimalPlaces']); $record["lastUpdated"] = $db->mySQLSafe(time()); if($_POST['currencyId']>0){ $where = "currencyId = ".$db->mySQLSafe($_POST['currencyId']); $update = $db->update($glob['dbprefix']."CubeCart_currencies", $record, $where); if($update == TRUE){ $msg = "

'".$_POST['name']."' ".$lang['admin']['settings']['update_success']."

"; } else { $msg = "

'".$_POST['name']."' ".$lang['admin']['settings']['update_fail']."

"; } } else { $insert =$db->insert($glob['dbprefix']."CubeCart_currencies", $record); if($insert == TRUE){ $msg = "

'".$_POST['name']."' ".$lang['admin']['settings']['add_success']."

"; } else { $msg = "

'".$_POST['name']."' ".$lang['admin']['settings']['add_fail']."

"; } } } elseif(isset($_GET['deleteCurrency'])) { $where = "currencyId = ".$db->mySQLSafe($_GET['deleteCurrency']); $delete = $db->delete($glob['dbprefix']."CubeCart_currencies", $where, ""); if($delete == TRUE){ $msg = "

".$lang['admin']['settings']['delete_success']."

"; } else { $msg = "

".$lang['admin']['settings']['delete_failed']."

"; } $where = "currencyId = ".$db->mySQLSafe($_GET['deleteCurrency']); $delete = $db->delete($glob['dbprefix']."CubeCart_currencies", $where, ""); } elseif(isset($_GET['active']) && $_GET['currencyId']>0){ $record["active"] = $_GET['active']; $where = "currencyId = ".$db->mySQLSafe($_GET['currencyId']); $update =$db->update($glob['dbprefix']."CubeCart_currencies", $record, $where); } $currenciesPerPage = 20; // get countries $query ="SELECT * FROM ".$glob['dbprefix']."CubeCart_currencies ORDER BY name ASC"; if(isset($_GET['page'])){ $page = $_GET['page']; } else { $page = 0; } $currencies = $db->select($query, $currenciesPerPage, $page); $numrows = $db->numrows($query); $pagination = $db->paginate($numrows, $currenciesPerPage, $page, "page"); include("../includes/header.inc.php"); ?>

0){ $editCurrency = $db->select("select * FROM ".$glob['dbprefix']."CubeCart_currencies WHERE currencyId = ".$db->mySQLsafe($_GET['editCurrency'])); } ?>
0){ ?> href="?currencyId=&active=0" class="txtLink"> href="?currencyId=&active=1" class="txtLink"> href="?editCurrency=" class="txtLink"> href="javascript:decision('','?deleteCurrency=');" class="txtLink">