Beispiel #1
0
$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"));
?>
Beispiel #2
0
<?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));
?>
Beispiel #3
0
<?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;
Beispiel #4
0
  } 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));
//}
Beispiel #5
0
<?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));
?>
Beispiel #6
0
  } 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));
//}