Example #1
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);