function uoltt_api_v1_user_dict(WP_REST_Request $request) { require_once SC_USER_DIR . "/library/sc_user_misc.class.php"; $misc = new sc_user_misc(); $search = $request->get_param("search"); $sort = $request->get_param("sort"); $order = $request->get_param("order"); $users = $misc->get_users($search, $sort, $order, TRUE); $users = array_values($users); $dict = array(); for ($i = 0; $i < sizeof($users); $i++) { $dict[$users[$i]["ID"]] = $users[$i]; } return array("users" => $dict); }
function imd_v1_add(WP_REST_Request $request) { require_once SC_USER_DIR . "/library/sc_user_misc.class.php"; $misc = new sc_user_misc(); global $scdb; $values = array('sc1', 'sc2', 'forum', 'rank', 'role', 'member', 'lastUID'); if ($misc->check_vars($values)) { $uid = $request->get_param("lastUID") + 1; $sql = "\n\t\t\tINSERT INTO lttname\n\t\t\t(sc1,sc2,forum,rank,role,member,nameUID) VALUES\n\t\t\t('" . implode("','", array($request->get_param("sc1"), $request->get_param("sc2"), $request->get_param("forum"), $request->get_param("rank"), $request->get_param("role"), $request->get_param("member"), $uid)) . "')\n\t\t"; $scdb->query($sql); wp_redirect("http://www.insanemaths.com/reported.cfm?noc=1"); die; // Keeping just in case ^^ does not work //header('Location: http://www.insanemaths.com/reported.cfm?noc=1'); } else { return new WP_Error('imd_api_v1_incomplete_request', "Not all required variables set", array('status' => 418)); } }
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."); } }
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); }
<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);
public function verified_user() { global $scdb; require_once SC_USER_DIR . "/library/sc_user_misc.class.php"; $misc = new sc_user_misc(); $user_data = $misc->get_users($this->ltt_id, NULL, NULL, true); //$usr = $user_data['users'][$this->ltt_id]; $usr = array_values($user_data); $usr = $usr[0]; ?> <tr> <th><label for="sc1">Star Citizen Moniker/Handle</label></th> <td> <input type="text" name="sc1" id="sc1" class="regular-text" value="<?php echo $usr['SC Handle']; ?> " /><br /> <span class="description">Enter your Star Citizen Moniker</span> </td> </tr> <tr> <th><label for="forum">LinusTechTips.com User</label></th> <td> <input type="text" name="forum" id="forum" class="regular-text" value="<?php echo $usr['LTT Name']; ?> " /><br /> <span class="description">Enter your LinusTechTips.com Username</span> </td> </tr> <tr> <th><label for="sc2">Star Citizen Name</label></th> <td> <input type="text" name="sc2" id="sc2" class="regular-text" value="<?php echo $usr['SC Name']; ?> " /><br /> <span class="description">Enter your Star Citizen Name</span> </td> </tr> <tr> <th><label for="rank">UOLTT Rank</label></th> <td> <input <?php $this->disabled(); ?> type="text" name="rank" id="rank" class="regular-text sc-rank" value="<?php echo $usr['Rank']['military']; ?> " /><br /> <span class="description">Your Star Citizen Rank</span> </td> </tr> <tr> <th><label for="role">UOLTT Role</label></th> <td> <input <?php $this->disabled(); ?> type="text" name="uoltt_role" id="uoltt_role" class="regular-text sc-role" value="<?php echo $usr['Role']; ?> " /><br /> <span class="description">Your UOLTT Role</span> </td> </tr> <tr> <th><label for="uoltt_member_status">UOLTT Membership Status</label></th> <td> <input disabled type="text" name="uoltt_member_status" id="uoltt_member_status" class="regular-text" value="<?php echo esc_attr(get_the_author_meta('uoltt_member_status', $this->user_id)); ?> " /><br /> <span class="description">Your UOLTT Membership Status</span> </td> </tr> <tr> <th><label for="ships">Owned Ships</label></th> <td> <?php $ships = $usr['Ships']; if (!empty($ships)) { foreach ($ships as $ship) { ?> <input type="text" id="ships" name="ships[]" class="regular-text sc-ships" value="<?php echo $ship; ?> "><br> <?php } } else { ?> <input type="text" id="ships" name="ships[]" class="regular-text sc-ships" value="You have no ships"> <?php } ?> <input type="button" class="button button-primary" id="add_ship_button" value="Add Ship"> <span class="description">The ships you own (blank entries will be deleted)</span> </td> </tr> <tr> <th><label for="sc_profile_visibility">UOLTT Profile Visibility</label></th> <td> <?php $name = esc_attr(get_the_author_meta('sc_profile_visibility', $this->user_id)); ?> <select name='sc_profile_visibility'> <option <?php $this->option_selected("Public", $name); ?> value='Public'>Public</option> <option <?php $this->option_selected("UOLTT Only", $name); ?> value='UOLTT Only'>UOLTT Only</option> </select><br> <span class="description">Toggle to switch between publicly available and visible UOLTT members only</span> </td> </tr> <?php }
<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
<?php global $scdb; global $wpdb; require_once SC_USER_DIR . "/library/sc_user_misc.class.php"; $misc = new sc_user_misc(); $saved = false; if (current_user_can('edit_user', $user_id)) { $status = get_the_author_meta('uoltt_member_status', $user_id); if ($status == "pending") { $key = get_the_author_meta('uoltt_auth_key', $user_id); if ($_POST['uoltt_key'] == $key) { // user verified $sc_data = $scdb->get_results("SELECT * FROM lttname WHERE forum = '" . get_user_meta($user_id, 'forum', true) . "' LIMIT 1", ARRAY_A); delete_user_meta($user_id, 'uoltt_auth_key'); update_user_meta($user_id, 'uoltt_member_status', 'Verified & Linked'); update_user_meta($user_id, 'sc_profile_visibility', 'Public'); // finds user data in database if (sizeof($sc_data) > 0) { $ships = $scdb->get_results("\n SELECT ship FROM shipsown WHERE name = " . $sc_data[0]['nameUID'], ARRAY_N); $shiplist = array(); foreach ($ships as $ship) { $shiplist[] = $ship[0]; } update_user_meta($user_id, 'nameUID', $sc_data[0]['nameUID']); } else { // add into database $scdb->query("\n INSERT INTO lttname\n (rank,role,member,forum) VALUES\n ('Trainee','none','no','" . get_the_author_meta('forum', $user_id) . "')\n "); update_user_meta($user_id, 'nameUID', $scdb->insert_id); delete_user_meta($user_id, 'forum'); }