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.");
     }
 }
Example #3
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);
Example #4
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