$wisdom = $_POST["wisdom"]; $HP = $_POST["HP"]; $MP = $_POST["MP"]; $stamina = $_POST["stamina"]; $will = $_POST["will"]; $item1ID = $_POST["item1ID"]; $item2ID = $_POST["item2ID"]; $item3ID = $_POST["item3ID"]; $item4ID = $_POST["item4ID"]; $item5ID = $_POST["item5ID"]; $sql = "INSERT INTO srp63.character"; $sql .= "(characterID,FK_placeID,FK_userID,name,gender,agility,strength,"; $sql .= "intellect,wisdom,maxHP,curHP,maxMP,curMP,maxStamina,curStamina,"; $sql .= "maxWill,curWill,experience,level) "; $sql .= "VALUES (?,'55a4ccfd-5c33-4ddc-9445-1a4af176099b',?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,0,1);"; $db1 = new DbUtilities(); $db1->executeQuery($sql, "ssssiiiiiiiiiiii", array($guid, $userID, $name, $gender, $agility, $strength, $intellect, $wisdom, $HP, $HP, $MP, $MP, $stamina, $stamina, $will, $will)); $sql1 = "INSERT INTO srp63.item (itemID, FK_characterID, type, itemName, "; $sql1 .= "defence, weight, durability, isEquipped, equipSlot) VALUES "; $sql1 .= "(?,?,?,?,?,?,?,?,?);"; $db2 = new DbUtilities(); $db2->executeQuery($sql1, "ssssiiiss", array($item1ID, $guid, "clothing", "Peasant Clothes", 1, 2, 100, "true", "body")); echo $item1ID . "," . $userID . "," . "clothing" . "," . "Peasant Clothes" . "," . 1 . "," . 2 . "," . 100 . "," . "true" . "," . "body"; $sql2 = "INSERT INTO srp63.item (itemID, FK_characterID, type, itemName, "; $sql2 .= "defence, weight, durability, isEquipped, equipSlot) VALUES "; $sql2 .= "(?,?,?,?,?,?,?,?,?);"; $db3 = new DbUtilities(); $db3->executeQuery($sql2, "ssssiiiss", array($item2ID, $guid, "clothing", "Simple Shoes", 0, 1, 100, "true", "body")); ?>
<?php require "classes/dbutils.php"; $email = $_POST["email"]; $password = $_POST["password"]; $displayName = $_POST["displayName"]; $sendNews = $_POST["sendNews"]; $age = $_POST["age"]; $userID = $_POST["userID"]; $hashPass = md5($password); $sql = "INSERT INTO user (userID,email,displayName,passW,sendNews,age,timeS) "; $sql .= "VALUES (?,?,?,?,?,?, NOW());"; $db = new DbUtilities(); $db->executeQuery($sql, "sssssi", array($userID, $email, $displayName, $hashPass, $sendNews, $age)); ?>
<?php session_start(); require "../classes/dbutils.php"; $userID = $_SESSION["userID"]; $guid = $_POST["guid"]; $content = $_POST["content"]; $threadID = $_POST["threadID"]; $sql = "INSERT INTO post (postID,FK_userID,FK_threadID,content,timeS) "; $sql .= "VALUES (?,?,?,?,NOW());"; $db = new DbUtilities(); $db->executeQuery($sql, "ssss", array($guid, $userID, $threadID, $content)); $sql = "INSERT INTO post (postID,FK_userID,FK_threadID,content,timeS) "; $sql .= "VALUES ({$guid},{$userID},{$threadID},{$content},NOW());"; echo $sql;
} else { //$userID = $_SESSION["drupalUserID"]; //$attemptID = $_SESSION["gameAttemptID"]; //$levelAccess = "level1.php"; } function insertData($table) { $sql = "INSERT INTO $table (userID,attemptID,levelAccess) "; $sql .= "VALUES (?,?,?);"; $db = new DbUtilities; $db->executeQuery($sql, "sss", array($userID, $attemptID, $levelAccess)); } */ //if (isset($_POST["firstName"])){ require "../classes/dbutils.php"; $firstName = $_POST["fName"]; $lastName = $_POST["lName"]; $dateSubmitted = $_POST["dateSubmitted"]; $WorkExperience = $_POST["workExpSE"]; $Appearance = $_POST["appearanceSE"]; $Education = $_POST["educationSE"]; $Enthusiasm = $_POST["enthusiasmSE"]; $whyWork = $_POST["whyWork"]; $strengths = $_POST["majorStrengths"]; $language = $_POST["languages"]; $other = $_POST["other"]; $sql = "INSERT INTO Applicant (fName,lName,dateSubmitted,workExpSE,appearanceSE,educationSE,enthusiasmSE,whyWork,majorStrengths,languages,other) "; $sql .= "VALUES (?,?,?,?,?,?,?,?,?,?,?);"; $db = new DbUtilities(); $db->executeQuery($sql, "sssssssssss", array($firstName, $lastName, $dateSubmitted, $WorkExperience, $Appearance, $Education, $Enthusiasm, $whyWork, $strengths, $language, $other)); //}
<?php require "../classes/dbutils.php"; $itemID = $_POST["itemID"]; $isEquipped = $_POST["isEquipped"]; $sql = "UPDATE srp63.item SET isEquipped = ? WHERE itemID = ?;"; $db = new DbUtilities(); $db->executeQuery($sql, "ss", array($isEquipped, $itemID)); ?>
} else { //$userID = $_SESSION["drupalUserID"]; //$attemptID = $_SESSION["gameAttemptID"]; //$levelAccess = "level1.php"; } function insertData($table) { $sql = "INSERT INTO $table (userID,attemptID,levelAccess) "; $sql .= "VALUES (?,?,?);"; $db = new DbUtilities; $db->executeQuery($sql, "sss", array($userID, $attemptID, $levelAccess)); } */ //if (isset($_POST["firstName"])){ require "../classes/dbutils.php"; $firstName = $_POST["fName"]; $lastName = $_POST["lName"]; $dateSubmitted = $_POST["dateSubmitted"]; $Happiness = $_POST["happinessSE"]; $Appearance = $_POST["appearanceSE"]; $Education = $_POST["educationSE"]; $Enthusiasm = $_POST["enthusiasmSE"]; $whyDate = $_POST["whyDate"]; $greatGF = $_POST["greatGF"]; $phone = $_POST["phone"]; echo "stuff"; $sql = "INSERT INTO GFapplicants (fName,lName,dateSubmitted,happiness,appearance,education,enthusiasm,whyDate,greatGF,phone) "; $sql .= "VALUES (?,?,?,?,?,?,?,?,?,?);"; $db = new DbUtilities(); $db->executeQuery($sql, "ssssssssss", array($firstName, $lastName, $dateSubmitted, $Happiness, $Appearance, $Education, $Enthusiasm, $whyDate, $greatGF, $phone)); //}