# # # # require "../settings.php"; require "../core-settings.php"; if (isset($_POST["key"])) { // Make all the keys lowecase to maintain consistency $_POST["key"] = strtolower($_POST["key"]); switch ($_POST["key"]) { default: case "display": $OUTPUT = display(); break; case "customize": $OUTPUT = customize($_POST); break; case "update": $OUTPUT = update($_POST); break; } } else { $OUTPUT = display(); } function customize() { print metaphone("That's just wack"); $fields = array(); $fields["heading_1"] = COMP_NAME; $fields["heading_2"] = date("d/m/Y"); $fields["heading_3"] = "Balance Sheet";
function update($_POST) { extract($_POST); if ($key == "add" && isset($naccount) && $naccount != 0) { // Has this account been added already? db_conn("cubit"); $sql = "SELECT * FROM saved_tb_accounts WHERE accid='{$naccount}'"; $stb_rslt = db_exec($sql) or errDie("Unable to retrieve saved trial balance accounts from Cubit."); if (pg_num_rows($stb_rslt) > 0) { return customize($_POST); } // Retrieve the account info with the accid db_conn("core"); $sql = "SELECT * FROM accounts WHERE accid='{$naccount}' AND div='" . USER_DIV . "'"; $acc_rslt = db_exec($sql) or errDie("Unable to retrieve account information from Cubit."); $acc_data = pg_fetch_array($acc_rslt); // Insert into the db db_conn("cubit"); $sql = "\n\t\t\tINSERT INTO saved_tb_accounts (\n\t\t\t\taccid, topacc, accnum, accname\n\t\t\t) VALUES (\n\t\t\t\t'{$acc_data['accid']}', '{$acc_data['topacc']}', '{$acc_data['accnum']}', '{$acc_data['accname']}'\n\t\t\t)"; $stbacc_rslt = db_exec($sql) or errDie("Unable to update your customization settings to Cubit."); } // Remove selected items if ($key == "remove selected" && isset($rem)) { foreach ($rem as $id) { db_conn("cubit"); $sql = "DELETE FROM saved_tb_accounts WHERE id='{$id}'"; $stbacc_rslt = db_exec($sql) or errDie("Unable to remove account from the accounts list."); } } return customize($_POST); }
<table width="300" border="0" cellpadding="2px"> <?php } ?> <?php if (isset($_POST['customize'])) { $name = $_POST['char_c_name']; $status = check_if_online($name, $CHDB); if ($status == -1) { echo "<p align='center'><font color='red'>The character doesnt exsist! </font></p>"; exit(); } if ($status == 1) echo "<p align='center'><font color='red'>This character is online. Please try again later</font></p>"; else { customize($name, $CHDB, $DB); $DB->query("UPDATE `voting_points` SET `points`=(`points` - ".$char_custom_points."), `points_spent`=(`points_spent` + ".$char_custom_points.") WHERE id=?d",$account_id); echo "<p align='center'><font color='blue'>Success! You are able to customize you character at next login!</font></p>"; } } ?> </table> </center> </td> </tr> </table> </td></tr></table> </td></tr></table> </center> <br />
function update($_POST) { extract($_POST); if ($key == "add" && $account != 0) { // has this account already been added db_conn("cubit"); $sql = "SELECT * FROM saved_bs_accounts WHERE accid='{$account}'"; $sbsacc_rslt = db_exec($sql) or errDie("Unable to retieve accounts list from Cubit."); if (pg_num_rows($sbsacc_rslt) == 0) { db_conn("core"); $sql = "SELECT * FROM accounts WHERE accid='{$account}'"; $acc_rslt = db_exec($sql) or errDie("Unable to retrieve accounts from Cubit."); $acc_data = pg_fetch_array($acc_rslt); db_conn("cubit"); $sql = "\n\t\t\t\tINSERT INTO saved_bs_accounts (\n\t\t\t\t\taccid, topacc, accnum, accname, toptype\n\t\t\t\t) VALUES (\n\t\t\t\t\t'{$acc_data['accid']}', '{$acc_data['topacc']}', '{$acc_data['accnum']}', '{$acc_data['accname']}', '{$acc_data['toptype']}'\n\t\t\t\t)"; $sbsacc_rslt = db_exec($sql) or errDie("Unable to save the account to the accounts list."); } } if ($key == "update") { foreach ($toptype as $accid => $value) { db_conn("cubit"); $sql = "UPDATE saved_bs_accounts SET toptype='{$value}' WHERE accid='{$accid}'"; $rslt = db_exec($sql); } } if ($key == "remove selected" && isset($rem)) { foreach ($rem as $accid => $value) { db_conn("cubit"); $sql = "DELETE FROM saved_bs_accounts WHERE accid='{$accid}'"; $sbsacc_rslt = db_exec($sql) or errDie("Unable to delete selected entries from the accounts list."); } } return customize($_POST); }