<?php
// assumes $mode is set
// variables
$folder_ext = '../../';
$singular_tag_cap = 'Skill';
$table_name = 'skill';
$unique_id = 'name';
$paragraph_desc_edit = "";
$paragraph_desc_create = 'Skills are active actions that a player/creature can perform. This is usually done outside of combat. Skill success is determined by a d20 roll against a DM defined difficulty. Skills have modifiers that can modify the d20 roll.';
// assumes $mode is set
require_once $folder_ext . 'php/form_helper_start.php';
$html_form .= createDatalistInput($get_row['attribute'], $form_id, "attribute", "Attribute:", $required, array('STR', 'DEX', 'INF', 'WIS'), NULL, $L_DATALIST_HINT . '<br>' . $L_ATTRIBUTE_HINT);
$sql = "SELECT * FROM skill GROUP BY type";
$statement = $database->prepare($sql);
$statement->execute();
$query_results = $statement->fetchAll(PDO::FETCH_ASSOC);
$html_form .= createDatalistAnyInput($get_row['type'], $form_id, "type", "Type:", $required, $query_results, "type", $L_DATALIST_ANY_HINT . '<br>' . $L_SKILL_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';
if ($_POST['data'] === 'Consumable') {
$sql = "SELECT * FROM itemType WHERE primaryType='Consumable'";
$statement = $database->prepare($sql);
$statement->execute();
$query_results = $statement->fetchAll(PDO::FETCH_ASSOC);
$json_return['form_extra'] .= createDatalistInput($get_secondaryType['secondaryType'], $_POST['form'], "secondaryType", "Secondary type:", $required, $query_results, "secondaryType", $L_DATALIST_HINT . '<br>' . $L_SECONDARY_CONSUMABLE_TYPE_HINT);
$sql = "SELECT * FROM rarity";
$statement = $database->prepare($sql);
$statement->execute();
$query_results = $statement->fetchAll(PDO::FETCH_ASSOC);
$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);
$html_form .= createNumberInput($get_row['manaCost'], $form_id, "manaCost", "Mana cost:", "1000", "0", NULL, $L_DATALIST_ANY_HINT . '<br>' . $L_MANA_COST_HINT); $sql = "SELECT * FROM spell GROUP BY castTime"; $statement = $database->prepare($sql); $statement->execute(); $query_results = $statement->fetchAll(PDO::FETCH_ASSOC); $html_form .= createDatalistAnyInput($get_row['castTime'], $form_id, "castTime", "Cast time:", $required, $query_results, "castTime", $L_DATALIST_ANY_HINT . '<br>' . $L_CAST_TIME_HINT); $sql = "SELECT * FROM spell GROUP BY components"; $statement = $database->prepare($sql); $statement->execute(); $query_results = $statement->fetchAll(PDO::FETCH_ASSOC); $html_form .= createDatalistAnyInput($get_row['components'], $form_id, "components", "Components:", NULL, $query_results, "components", $L_DATALIST_ANY_HINT . '<br>' . $L_COMPONENTS_HINT); $sql = "SELECT * FROM spell GROUP BY duration"; $statement = $database->prepare($sql); $statement->execute(); $query_results = $statement->fetchAll(PDO::FETCH_ASSOC); $html_form .= createDatalistAnyInput($get_row['duration'], $form_id, "duration", "Duration:", NULL, $query_results, "duration", $L_DATALIST_ANY_HINT . '<br>' . $L_DURATION_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 .= createDiceInput($get_row['damage'], $form_id, "damage", "Damage:", NULL, $L_DICE_HINT . '<br>' . $L_DAMAGE_HINT); $sql = "SELECT * FROM damageType";
