if ($result->num_rows > 0) { echo "Name already exists in this campaign"; } else { $race = CheckExists("race", "Unknown"); $base = "" . CheckExists("size", "M") . "," . CheckExists("age", 0) . "," . CheckExists("gender", "-") . "," . CheckExists("height", 0) . "," . CheckExists("weight", 0) . "," . CheckExists("speed", 0); $attr = CheckExists("str", 0) . "," . CheckExists("dex", 0) . "," . CheckExists("con", 0) . "," . CheckExists("int", 0) . "," . CheckExists("wis", 0) . "," . CheckExists("cha", 0); $def = CheckExists("ac", 0) . "," . CheckExists("hp", 0) . "," . CheckExists("fac", 0) . "," . CheckExists("tac", 0); $skills = CheckExists("ap", 0) . "," . CheckExists("au", 0) . "," . CheckExists("ba", 0) . "," . CheckExists("bl", 0) . "," . CheckExists("cl", 0) . "," . CheckExists("conc", 0) . "," . CheckExists("cont", 0) . "," . CheckExists("cal", 0) . "," . CheckExists("car", 0) . "," . CheckExists("cb", 0) . "," . CheckExists("cw", 0) . "," . CheckExists("ct", 0) . "," . CheckExists("de", 0) . "," . CheckExists("dip", 0) . "," . CheckExists("disa", 0) . "," . CheckExists("disg", 0) . "," . CheckExists("e", 0) . "," . CheckExists("f", 0) . "," . CheckExists("g", 0) . "," . CheckExists("ha", 0) . "," . CheckExists("he", 0) . "," . CheckExists("hi", 0) . "," . CheckExists("i", 0) . "," . CheckExists("j", 0) . "," . CheckExists("l", 0) . "," . CheckExists("m", 0) . "," . CheckExists("o", 0) . "," . CheckExists("pe", 0) . "," . CheckExists("ps", 0) . "," . CheckExists("pr", 0) . "," . CheckExists("r", 0) . "," . CheckExists("sea", 0) . "," . CheckExists("sen", 0) . "," . CheckExists("sl", 0) . "," . CheckExists("spea", 0) . "," . CheckExists("spel", 0) . "," . CheckExists("spo", 0) . "," . CheckExists("su", 0) . "," . CheckExists("sw", 0) . "," . CheckExists("t", 0) . "," . CheckExists("um", 0) . "," . CheckExists("up", 0) . "," . CheckExists("ur", 0) . "," . CheckExists("arc", 0) . "," . CheckExists("ae", 0) . "," . CheckExists("dun", 0) . "," . CheckExists("geo", 0) . "," . CheckExists("his", 0) . "," . CheckExists("loc", 0) . "," . CheckExists("nat", 0) . "," . CheckExists("nob", 0) . "," . CheckExists("psi", 0) . "," . CheckExists("rel", 0) . "," . CheckExists("pla", 0); $weapons = CheckExists("weapon", "-") . "," . CheckExists("dmg", 0) . "," . CheckExists("bab", 0); $classes = ""; $count = 1; while (CheckExists("clsName" . $count, false)) { if ($count == 1) { $classes = CheckExists("clsName1", "Class1") . "," . CheckExists("clsLvl1", 1); } else { $classes = $classes . "," . CheckExists("clsName" . $count, "Class1") . "," . CheckExists("clsLvl" . $count, 1); } $count++; } echo "INSERT INTO Characters (player_id, char_name, player_name, race, attributes, base_stats, defense_stats, weapon_stats, classes, skills) \n\t\t\t\t\t\t\tVALUES ('" . $_SESSION['user_id'] . "', '" . $char . "', '" . $player . "', '" . $race . "', '" . $attr . "', '" . $base . "', '" . $def . "', '" . $weapons . "', '" . $classes . "', '" . $skills . "')"; $result = $con->query("INSERT INTO Characters (player_id, char_name, player_name, race, attributes, base_stats, defense_stats, weapon_stats, classes, skills) \n\t\t\t\t\t\t\tVALUES ('" . $_SESSION['user_id'] . "', '" . $char . "', '" . $player . "', '" . $race . "', '" . $attr . "', '" . $base . "', '" . $def . "', '" . $weapons . "', '" . $classes . "', '" . $skills . "')"); if ($result === TRUE) { echo "Record created successfully"; } } $con->close(); echo " End!"; /*$xml = new DOMDocument(); //Root $xml_root = $xml->createElement("root"); $xml->appendChild($xml_root);
<?php $race_name = CheckExists("race", "Unknown"); if ($race_name == "Unknown") { echo "null"; exit; } $host = "sql5.freemysqlhosting.net"; $port = 3306; $socket = ""; $user = "******"; $password = "******"; $dbname = "sql591042"; $con = new mysqli($host, $user, $password, $dbname, $port, $socket) or die('Could not connect to the database server' . mysqli_connect_error()); $result = $con->query("SELECT * FROM Races WHERE name='" . $race_name . "'"); if ($result->num_rows != 1) { echo "error"; exit; } $row = $result->fetch_row(); echo $row[1] . ":" . $row[2] . ":" . $row[3] . ":" . $row[4]; exit; function CheckExists($varName, $defaultVal) { if (isset($_POST[$varName])) { return $_POST[$varName]; } else { return $defaultVal; } }