query('update :table_administrators set user_name = :user_name where id = :id'); $Qadmin->bindInt(':id', $_GET['aID']); } else { $Qadmin = $osC_Database->query('insert into :table_administrators (user_name) values (:user_name)'); } $Qadmin->bindTable(':table_administrators', TABLE_ADMINISTRATORS); $Qadmin->bindValue(':user_name', $_POST['user_name']); $Qadmin->execute(); if (($osC_Database->isError() === false) && !empty($_POST['user_password'])) { $id = ((isset($_GET['aID']) && is_numeric($_GET['aID'])) ? $_GET['aID'] : $osC_Database->nextID()); $Qadmin = $osC_Database->query('update :table_administrators set user_password = :user_password where id = :id'); $Qadmin->bindTable(':table_administrators', TABLE_ADMINISTRATORS); $Qadmin->bindValue(':user_password', osc_encrypt_string(trim($_POST['user_password']))); $Qadmin->bindInt(':id', $id); $Qadmin->execute(); } if ($osC_Database->isError() === false) { $osC_MessageStack->add_session('header', SUCCESS_DB_ROWS_UPDATED, 'success'); } else { $osC_MessageStack->add_session('header', ERROR_DB_ROWS_NOT_UPDATED, 'error'); } osc_redirect(osc_href_link_admin(FILENAME_ADMINISTRATORS, 'page=' . $_GET['page'] . '&aID=' . $id)); break; case 'deleteconfirm': if (isset($_GET['aID']) && is_numeric($_GET['aID'])) { $Qdel = $osC_Database->query('delete from :table_administrators where id = :id'); $Qdel->bindTable(':table_administrators', TABLE_ADMINISTRATORS); $Qdel->bindInt(':id', $_GET['aID']); $Qdel->execute(); $osC_MessageStack->add_session('header', SUCCESS_DB_ROWS_UPDATED, 'success'); } osc_redirect(osc_href_link_admin(FILENAME_ADMINISTRATORS, 'page=' . $_GET['page'])); break; } } $page_contents = 'administrators.php'; require('templates/default.php'); require('includes/application_bottom.php'); ?>