<?php // assumes $mode is set // variables $folder_ext = '../../'; $singular_tag_cap = 'Item'; $table_name = 'item'; $unique_id = 'name'; $paragraph_desc_edit = ""; $paragraph_desc_create = 'Items are objects that can be carried and used by characters.'; // assumes $mode is set require_once $folder_ext . 'php/form_helper_start.php'; $html_form .= createNumberInput($get_row['weight'], $form_id, "weight", "Weight (lbs):", "10000", "0", NULL, $L_NUMBER_HINT . '<br>' . $L_WEIGHT_HINT); $html_form .= createNumberInput($get_row['value'], $form_id, "value", "Value (gold):", "1000000", "0", NULL, $L_NUMBER_HINT . '<br>' . $L_VALUE_HINT); // get ability types from server $sql = "SELECT * FROM itemType GROUP BY primaryType"; $statement = $database->prepare($sql); $statement->execute(); $query_results = $statement->fetchAll(PDO::FETCH_ASSOC); $html_form .= createDatalistInputExpand($get_row['primaryType'], $form_id, "primaryType", "Primary type:", $required, $query_results, "primaryType", $L_DATALIST_HINT . '<br>' . $L_PRIMARY_TYPE_ITEM_HINT); // extra area where all the expanded form fields can go $html_form .= '<div id="' . $table_name . '_expand"></div>'; $html_form .= createTextareaInput($get_row['description'], $form_id, "description", "Description:", "7", $required, $L_DESCRIPTION_HINT); require_once $folder_ext . 'php/form_helper_end.php';
$json_return['form_extra'] .= createDatalistInput($get_row['rarity'], $_POST['form'], "rarity", "Rarity:", $required, $query_results, "rarity", $L_DATALIST_HINT . '<br>' . $L_RARITY_HINT); $sql = "SELECT * FROM consumable GROUP BY locality"; $statement = $database->prepare($sql); $statement->execute(); $query_results = $statement->fetchAll(PDO::FETCH_ASSOC); $json_return['form_extra'] .= createDatalistAnyInput($get_row['locality'], $_POST['form'], "locality", "Locality of Ingredient:", NULL, $query_results, "locality", $L_DATALIST_ANY_HINT . '<br>' . $L_LOCALITY_HINT); $json_return['form_extra'] .= createTextareaInput($get_row['hiddenProperty'], $_POST['form'], "hiddenProperty", "Hidden property:", "7", NULL, $L_HIDDEN_PROPERTY_HINT); } else { if ($_POST['data'] === 'Gear' || $_POST['data'] === 'Miscellaneous' || $_POST['data'] === 'Tool') { // nothing! same as item } else { if ($_POST['data'] === 'Melee Weapon' || $_POST['data'] === 'Ranged Weapon') { if ($_POST['data'] === 'Melee Weapon') { $json_return['form_extra'] .= createNumberInput($get_row['throw'], $_POST['form'], "throw", "Throw range:", "1000", "0", NULL, $L_NUMBER_HINT . '<br>' . $L_THROW_HINT); } else { $json_return['form_extra'] .= createNumberInput($get_row['range'], $_POST['form'], "range", "Range:", "1000", "0", NULL, $L_NUMBER_HINT . '<br>' . $L_WEAPON_RANGE_HINT); $sql = "SELECT * FROM ammunition GROUP BY ammunitionType"; $statement = $database->prepare($sql); $statement->execute(); $query_results = $statement->fetchAll(PDO::FETCH_ASSOC); $json_return['form_extra'] .= createDatalistInput($get_row['ammunitionType'], $_POST['form'], "ammunitionType", "Ammunition type:", $required, $query_results, "ammunitionType", $L_DATALIST_HINT . '<br>' . $L_DAMAGE_TYPE_HINT); } $sql = "SELECT * FROM property WHERE appliesTo='weapon'"; $statement = $database->prepare($sql); $statement->execute(); $query_results = $statement->fetchAll(PDO::FETCH_ASSOC); $json_return['form_extra'] .= createDatalistInput($get_row['property'], $_POST['form'], "property", "Property:", NULL, $query_results, "property", $L_DATALIST_HINT . '<br>' . $L_DAMAGE_TYPE_HINT); $json_return['form_extra'] .= createDiceInput($get_row['damage'], $_POST['form'], "damage", "Damage:", $required, $L_DICE_HINT . '<br>' . $L_DAMAGE_HINT); $sql = "SELECT * FROM damageType"; $statement = $database->prepare($sql); $statement->execute();
// assumes $mode is set // variables $folder_ext = '../../'; $singular_tag_cap = 'Ability'; $table_name = 'ability'; $unique_id = 'name'; $paragraph_desc_edit = ""; $paragraph_desc_create = 'Abilities are passive actions that are automatically applied or active actions that a player/creature can perform.'; // assumes $mode is set require_once $folder_ext . 'php/form_helper_start.php'; // get ability types from server $sql = "SELECT * FROM abilityType"; $statement = $database->prepare($sql); $statement->execute(); $query_results = $statement->fetchAll(PDO::FETCH_ASSOC); $html_form .= createDatalistInput($get_row['type'], $form_id, "type", "Type of ability:", $required, $query_results, "type", $L_DATALIST_HINT . '<br>' . $L_TYPE_ABILITY_HINT); $sql = "SELECT * FROM target"; $statement = $database->prepare($sql); $statement->execute(); $query_results = $statement->fetchAll(PDO::FETCH_ASSOC); $html_form .= createDatalistInput($get_row['target'], $form_id, "target", "Target:", $required, $query_results, "target", $L_DATALIST_HINT . '<br>' . $L_TARGET_HINT); $html_form .= createNumberInput($get_row['targetNum'], $form_id, "targetNum", "Number of targets:", "200", "0", NULL, $L_NUMBER_HINT . '<br>' . $L_NUM_TARGET_HINT); $html_form .= createNumberInput($get_row['range'], $form_id, "range", "Range (ft):", "10000", "0", NULL, $L_NUMBER_HINT . '<br>' . $L_RANGE_HINT); $html_form .= createNumberInput($get_row['radius'], $form_id, "radius", "Radius (ft):", "10000", "0", NULL, $L_NUMBER_HINT . '<br>' . $L_RADIUS_HINT); $sql = "SELECT * FROM radiusType"; $statement = $database->prepare($sql); $statement->execute(); $query_results = $statement->fetchAll(PDO::FETCH_ASSOC); $html_form .= createDatalistInput($get_row['radiusType'], $form_id, "radiusType", "Radius type:", NULL, $query_results, 'radiusType', $L_DATALIST_HINT . '<br>' . $L_RADIUS_TYPE_HINT); $html_form .= createTextareaInput($get_row['description'], $form_id, "description", "Description:", "7", $required, $L_DESCRIPTION_HINT); require_once $folder_ext . 'php/form_helper_end.php';