{"id":424,"date":"2015-01-12T10:46:32","date_gmt":"2015-01-12T15:46:32","guid":{"rendered":"http:\/\/blog.scad.edu\/ascarb21\/?p=424"},"modified":"2015-01-12T10:46:32","modified_gmt":"2015-01-12T15:46:32","slug":"php-code-for-the-story-event-creation-ui","status":"publish","type":"post","link":"https:\/\/itgm-thesis.aliciascarborough.com\/blog\/2015\/01\/12\/php-code-for-the-story-event-creation-ui\/","title":{"rendered":"PHP code for the Story Event Creation UI"},"content":{"rendered":"


\n\/\/1) set specific actions to choose from
\n\/\/ -fight
\n\/\/ -clear out (specify item to clear the effect)
\n\/\/ -get an item from
\n\/\/Give a list of available items as well
\n\/\/allow for on the fly item creation (generic icon) - this might wait for future releases
\n\/\/ -investigate and\/or confirm
\n\/\/ -listen to conversation
\n\/\/ - weather related? aka rain spiders, flood of bunnies - this will enable the choose odd weather ui to choose the odd weather elements<\/code><\/p>\n

\/\/2) set specific actors to choose from<\/p>\n

\/\/3) set reward\/consequence based on action
\n\/\/ – does it block the next step? Y\/N
\n\/\/ – if chained then the consequence could be fights or whatever!!<\/p>\n

\/\/Step one choose actions – these can CHAIN!!
\nconnect_error) {
\ndie(“Connection failed: ” . $conn->connect_error);
\n}<\/p>\n

$sql = “SELECT id,name,type FROM Story_Actions WHERE area = $areaid”;
\n$results = $conn->query($sql);<\/p>\n

if($result->num_rows > 0) {
\n\/\/Build Array
\nwhile($row = $result->fetch_assoc()) {
\necho “ID: ” . $row[“id”] . “, Name: ” . $row[“name”] . “, Type: ” . $row[“type”] . ”
\n“;
\n}
\n} else {
\necho “0 results”;
\n}<\/p>\n

$conn->close();
\n?><\/p>\n

\/\/Step two pull NPCs choices based on area to accomendate the action
\nconnect_error) {
\ndie(“Connection failed: ” . $conn->connect_error);
\n}<\/p>\n

$sql = “SELECT id,name,type FROM NPC WHERE area = $areaid”;
\n$results = $conn->query($sql);<\/p>\n

if($result->num_rows > 0) {
\n\/\/Build Array
\nwhile($row = $result->fetch_assoc()) {
\necho “ID: ” . $row[“id”] . “, Name: ” . $row[“name”] . “, Type: ” . $row[“type”] . ”
\n“;
\n}
\n} else {
\necho “0 results”;
\n}<\/p>\n

$conn->close();
\n?><\/p>\n

\/\/Step three select consequence
\n\/\/is this based on a previous action?
\n\/\/does this chain?
\nconnect_error) {
\ndie(“Connection failed: ” . $conn->connect_error);
\n}<\/p>\n

$sql = “SELECT id,name,type FROM Reward_Punish_Action WHERE area = $areaid”;
\n$results = $conn->query($sql);<\/p>\n

if($result->num_rows > 0) {
\n\/\/Build Array
\nwhile($row = $result->fetch_assoc()) {
\necho “ID: ” . $row[“id”] . “, Name: ” . $row[“name”] . “, Type: ” . $row[“type”] . ”
\n“;
\n}
\n} else {
\necho “0 results”;
\n}<\/p>\n

$conn->close();
\n?><\/p>\n

\/\/Item Creation
\n\/\/Need to select what base type whether it is a potion or weapon
\n\/\/Step One choose item base first
\nconnect_error) {
\ndie(“Connection failed: ” . $conn->connect_error);
\n}<\/p>\n

$sql = “SELECT id,name,type FROM Items;
\n$results = $conn->query($sql);<\/p>\n

if($result->num_rows > 0) {
\n\/\/Build Array
\nwhile($row = $result->fetch_assoc()) {
\necho “ID: ” . $row[“id”] . “, Name: ” . $row[“name”] . “, Type: ” . $row[“type”] . ”
\n“;
\n}
\n} else {
\necho “0 results”;
\n}<\/p>\n

$conn->close();
\n?>
\n\/\/Step Two select Effect
\n\/\/Base weapon stats
\n\/\/Or magical health potion
\nconnect_error) {
\ndie(“Connection failed: ” . $conn->connect_error);
\n}<\/p>\n

$sql = “SELECT id,name,type FROM Item_effect WHERE itemtype = $itemtype”;
\n$results = $conn->query($sql);<\/p>\n

if($result->num_rows > 0) {
\n\/\/Build Array
\nwhile($row = $result->fetch_assoc()) {
\necho “ID: ” . $row[“id”] . “, Name: ” . $row[“name”] . “, Type: ” . $row[“type”] . ”
\n“;
\n}
\n} else {
\necho “0 results”;
\n}<\/p>\n

$conn->close();
\n?><\/p>\n

\/\/Step three save new item to DB
\nconnect_error) {
\ndie(“Connection failed: ” . $conn->connect_error);
\n}<\/p>\n

$sql = “INSERT INTO Items (colnames) VALUES (values of colnames)”;
\n$results = $conn->query($sql);<\/p>\n

if($conn->query($sql) === TRUE) {
\necho “Success”;
\n} else {
\necho “Error: ” . $sql . ”
\n” . $conn->error;
\n}<\/p>\n

$conn->close();
\n?><\/p>\n

\/\/Odd Weather
\nconnect_error) {
\ndie(“Connection failed: ” . $conn->connect_error);
\n}<\/p>\n

$sql = “SELECT id,name,type FROM Weather WHERE area = $areaid”;
\n$results = $conn->query($sql);<\/p>\n

if($result->num_rows > 0) {
\n\/\/Build Array
\nwhile($row = $result->fetch_assoc()) {
\necho “ID: ” . $row[“id”] . “, Name: ” . $row[“name”] . “, Type: ” . $row[“type”] . ”
\n“;
\n}
\n} else {
\necho “0 results”;
\n}<\/p>\n

$conn->close();
\n?>
\n\/\/Select critter
\nconnect_error) {
\ndie(“Connection failed: ” . $conn->connect_error);
\n}<\/p>\n

$sql = “SELECT id,name,type FROM Critters WHERE area = $areaid”;
\n$results = $conn->query($sql);<\/p>\n

if($result->num_rows > 0) {
\n\/\/Build Array
\nwhile($row = $result->fetch_assoc()) {
\necho “ID: ” . $row[“id”] . “, Name: ” . $row[“name”] . “, Type: ” . $row[“type”] . ”
\n“;
\n}
\n} else {
\necho “0 results”;
\n}<\/p>\n

$conn->close();
\n?><\/p>\n","protected":false},"excerpt":{"rendered":"

\/\/1) set specific actions to choose from \/\/ -fight \/\/ -clear out (specify item to clear the effect) \/\/ -get an item from \/\/Give a list of available items as well \/\/allow for on the fly item creation (generic icon)…<\/p>\n

Read more →<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,17],"tags":[],"class_list":["post-424","post","type-post","status-publish","format-standard","hentry","category-continued","category-prototype-continued"],"_links":{"self":[{"href":"https:\/\/itgm-thesis.aliciascarborough.com\/blog\/wp-json\/wp\/v2\/posts\/424","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itgm-thesis.aliciascarborough.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itgm-thesis.aliciascarborough.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itgm-thesis.aliciascarborough.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itgm-thesis.aliciascarborough.com\/blog\/wp-json\/wp\/v2\/comments?post=424"}],"version-history":[{"count":0,"href":"https:\/\/itgm-thesis.aliciascarborough.com\/blog\/wp-json\/wp\/v2\/posts\/424\/revisions"}],"wp:attachment":[{"href":"https:\/\/itgm-thesis.aliciascarborough.com\/blog\/wp-json\/wp\/v2\/media?parent=424"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itgm-thesis.aliciascarborough.com\/blog\/wp-json\/wp\/v2\/categories?post=424"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itgm-thesis.aliciascarborough.com\/blog\/wp-json\/wp\/v2\/tags?post=424"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}