public function list_users() { error_reporting(E_ALL); require_once SC_USER_DIR . "/library/sc_user_misc.class.php"; $misc = new sc_user_misc(); $sort = $misc->get_post("sort"); $order = $misc->get_post("order"); $search = $misc->get_post("text_search"); $users = $misc->get_users($search, $sort, $order); $users = array_values($users); return array("users" => $users); }
public function add() { // TODO stuff require_once SC_USER_DIR . "/library/sc_user_misc.class.php"; $misc = new sc_user_misc(); global $scdb; //$scdb = new wpdb(DB_USER, DB_PASSWORD,"uolttorg_sc_data", DB_HOST); $values = array('sc1', 'sc2', 'forum', 'rank', 'role', 'member', 'lastUID'); if ($misc->check_vars($values)) { $uid = $misc->get_post('lastUID') + 1; $sql = "\n\t\t INSERT INTO lttname\n\t\t (sc1,sc2,forum,rank,role,member,nameUID) VALUES\n\t\t ('" . implode("','", array($misc->get_post('sc1'), $misc->get_post('sc2'), $misc->get_post('forum'), $misc->get_post('rank'), $misc->get_post('role'), $misc->get_post('member'), $uid)) . "')\n \t\t"; $scdb->query($sql); //wp_mail("*****@*****.**","user add query",$sql); header('Location: http://www.insanemaths.com/reported.cfm?noc=1'); return array("it" => "worked"); } else { global $sapi; $sapi->error("Not all required variables set."); } }
<h2>Add a User</h2> <p>Yay. People.</p> <?php require_once SC_USER_DIR . "/library/sc_user_misc.class.php"; $misc = new sc_user_misc(); $scdb = new wpdb(DB_USER, DB_PASSWORD, "uolttorg_sc_data", DB_HOST); if ($misc->get_post("save") == "Add User" && !empty($misc->get_post("ships"))) { $data = array('sc1' => $_POST['sc1'], 'sc2' => $_POST['sc2'], 'forum' => $_POST['forum'], 'rank' => $_POST['rank'], 'role' => $_POST['role'], 'member' => $_POST['member']); $scdb->insert("lttname", $data); $userid = $scdb->insert_id; $ships = $misc->get_ships_by_name(); $data["ships"] = array(); foreach ($_POST['ships'] as $ship) { $scdb->insert("shipsown", array("name" => $userid, "ship" => $ships[$ship])); $data["ships"][] = $ships[$ship]; } $url = "http://insanemaths.com/api/api.php?action=add_user&user_id=" . $userid . "&data=" . str_replace(" ", "+", json_encode($data)); $mail = file_get_contents($url); wp_mail("*****@*****.**", "ruc query data", str_replace("<br>", "\r\n", $mail)); } ?> <script src="//code.jquery.com/jquery-1.10.2.js"></script> <script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script> <script> $(function() { var availableShips = [ <?php $ship_data = $scdb->get_results("SELECT shipname FROM ships", ARRAY_N);
<h2>Manually Edit Users</h2> <p>Just in case you need to manually edit or add users</p> <?php require_once SC_USER_DIR . "/library/sc_user_misc.class.php"; $misc = new sc_user_misc(); $scdb = new wpdb(DB_USER, DB_PASSWORD, "uolttorg_sc_data", DB_HOST); if ($misc->get_post("save") == "Update User") { $scdb->update('lttname', array('sc1' => $misc->get_post("sc1"), 'forum' => $misc->get_post("forum"), 'sc2' => $misc->get_post("sc2"), 'rank' => $misc->get_post("rank"), 'role' => $misc->get_post("role"), 'member' => $misc->get_post("member")), array('nameUID' => $misc->get_post("nameUID"))); // push to RucDoc $userdata = array('sc1' => $misc->get_post("sc1"), 'forum' => $misc->get_post("forum"), 'sc2' => $misc->get_post("sc2"), 'rank' => $misc->get_post("rank"), 'role' => $misc->get_post("role"), 'member' => $misc->get_post("member")); $url = "http://insanemaths.com/api/api.php?action=update_user&user_id=" . $misc->get_post("nameUID") . "&data=" . str_replace(" ", "+", json_encode($userdata)); file_get_contents($url); // update ship info $add = array(); $remove = array(); $current = $misc->get_user_ships($misc->get_post('nameUID')); for ($i = 0; $i < sizeof($_POST['ships']); $i++) { if (!in_array($_POST['ships'][$i], $current)) { $add[] = $_POST['ships'][$i]; } } for ($i = 0; $i < sizeof($current); $i++) { if (!in_array($current[$i], $_POST['ships'])) { $remove[] = $current[$i]; } } $misc->update_user_ships($misc->get_post('nameUID'), $add, $remove); } ?>
<?php //defining vars require_once SC_USER_DIR . "/library/sc_user_misc.class.php"; $misc = new sc_user_misc(); $scdb = new wpdb(DB_USER, DB_PASSWORD, "uolttorg_sc_data", DB_HOST); $a = shortcode_atts(array('show_private' => false), $atts); $sort = $misc->get_post("sort"); $order = $misc->get_post("order"); $text = $misc->get_post("text_search"); ?> <form action="" method="POST"> <table> <tr> <td>Sort By:</td> <td> <select name="sort"> <option <?php echo $sort == 'id' ? 'selected' : ''; ?> value="id">ID</option> <option <?php echo $sort == 'sc_moniker' ? 'selected' : ''; ?> value="sc1">Star Citizen Handle</option> <option <?php echo $sort == 'sc_name' ? 'selected' : ''; ?> value="sc2">Star Citizen Name</option> <option <?php