public function user_ships() { error_reporting(E_ALL); global $sapi; require_once SC_USER_DIR . "/library/sc_user_misc.class.php"; $misc = new sc_user_misc(); if (empty($_GET['user'])) { $sapi->error("Please set the 'user' variable in order to use this feature"); } if (is_numeric($_GET['user'])) { $ships = $misc->get_user_ships($_GET['user']); $userid = $_GET['user']; } else { $users = $misc->get_users($_GET['user']); $userdata = array_values($users); $userid = $userdata[0]['ID']; if (empty($users)) { $sapi->error("user not found"); } $ships = $misc->get_user_ships($userid); // grabbing first result } return array("user" => $userid, "ships" => $ships); }
<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); } ?> <script src="//code.jquery.com/jquery-1.10.2.js"></script>
// update user table if (!empty($_POST['rank']) && !empty($_POST['uoltt_role'])) { $userdata = array("sc1" => $_POST['sc1'], "sc2" => $_POST['sc2'], "forum" => $_POST['forum'], "rank" => $_POST['rank'], "role" => $_POST['uoltt_role']); } else { $userdata = array("sc1" => $_POST['sc1'], "sc2" => $_POST['sc2'], "forum" => $_POST['forum']); } $scdb->update("lttname", $userdata, array("nameUID" => get_user_meta($user_id, 'nameUID', true))); $scdb->update("points", array("milrank" => $_POST['rank']), array("pioletUID" => get_user_meta($user_id, 'nameUID', true))); // push to RucDoc $url = "http://insanemaths.com/api/api.php?action=update_user&user_id=" . get_user_meta($user_id, 'nameUID', true) . "&data=" . str_replace(" ", "+", json_encode($userdata)); file_get_contents($url); // update ship info $_POST['ships'] = array_values(array_unique(array_filter($_POST['ships']))); $add = array(); $remove = array(); $current = $misc->get_user_ships(get_user_meta($user_id, 'nameUID', true)); 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(get_user_meta($user_id, 'nameUID', true), $add, $remove); } $saved = true; } return true;