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);
 }
Example #5
0
<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 
    }
Example #7
0
<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');
            }