add('header', ERROR_CREDIT_CARD_NAME, 'error'); $error = true; } if ($error === false) { if (isset($_GET['ccID']) && is_numeric($_GET['ccID'])) { $Qcc = $osC_Database->query('update :table_credit_cards set credit_card_name = :credit_card_name, pattern = :pattern, credit_card_status = :credit_card_status, sort_order = :sort_order where id = :id'); $Qcc->bindInt(':id', $_GET['ccID']); } else { $Qcc = $osC_Database->query('insert into :table_credit_cards (credit_card_name, pattern, credit_card_status, sort_order) values (:credit_card_name, :pattern, :credit_card_status, :sort_order)'); } $Qcc->bindTable(':table_credit_cards', TABLE_CREDIT_CARDS); $Qcc->bindValue(':credit_card_name', $_POST['credit_card_name']); $Qcc->bindValue(':pattern', $_POST['pattern']); $Qcc->bindInt(':credit_card_status', (isset($_POST['credit_card_status']) && ($_POST['credit_card_status'] == '1') ? '1' : '0')); $Qcc->bindInt(':sort_order', $_POST['sort_order']); $Qcc->execute(); if ($Qcc->affectedRows()) { osC_Cache::clear('credit-cards'); $osC_MessageStack->add_session('header', SUCCESS_DB_ROWS_UPDATED, 'success'); } else { $osC_MessageStack->add_session('header', WARNING_DB_ROWS_NOT_UPDATED, 'warning'); } osc_redirect(osc_href_link_admin(FILENAME_CREDIT_CARDS, 'page=' . $_GET['page'] . '&ccID=' . ((isset($_GET['ccID']) && is_numeric($_GET['ccID'])) ? $_GET['ccID'] : $osC_Database->nextID()))); } else { if ($action == 'insert') { $action = 'new'; } else { $action = 'configure'; } } break; case 'deleteconfirm': if (isset($_GET['ccID']) && is_numeric($_GET['ccID'])) { $Qdel = $osC_Database->query('delete from :table_credit_cards where id = :id'); $Qdel->bindTable(':table_credit_cards', TABLE_CREDIT_CARDS); $Qdel->bindInt(':id', $_GET['ccID']); $Qdel->execute(); if ($Qdel->affectedRows()) { osC_Cache::clear('credit-cards'); $osC_MessageStack->add_session('header', SUCCESS_DB_ROWS_UPDATED, 'success'); } else { $osC_MessageStack->add_session('header', WARNING_DB_ROWS_NOT_UPDATED, 'warning'); } } osc_redirect(osc_href_link_admin(FILENAME_CREDIT_CARDS, 'page=' . $_GET['page'])); break; } } $page_contents = 'credit_cards.php'; require('templates/default.php'); require('includes/application_bottom.php'); ?>