Beispiel #1
0
                                    $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();
                                $query_results = $statement->fetchAll(PDO::FETCH_ASSOC);
                                $json_return['form_extra'] .= createDatalistInput($get_row['damageType'], $_POST['form'], "damageType", "Damage type:", $required, $query_results, "damageType", $L_DATALIST_HINT . '<br>' . $L_DAMAGE_TYPE_HINT);
                                $json_return['form_extra'] .= createDiceInput($get_row['secondaryDamage'], $_POST['form'], "secondaryDamage", "Secondary Damage:", NULL, $L_DICE_HINT . '<br>' . $L_SECONDARY_DAMAGE_HINT);
                                $json_return['form_extra'] .= createDatalistInput($get_row['secondaryDamageType'], $_POST['form'], "secondaryDamageType", "Secondary damage type:", NULL, $query_results, "damageType", $L_DATALIST_HINT . '<br>' . $L_SECONDARY_DAMAGE_TYPE_HINT);
                            } else {
                                $json_return['status'] = "FAILED";
                                $json_return['message'] = 'Not a recognized type.';
                            }
                        }
                    }
                }
            }
        }
    }
} catch (PDOException $e) {
    $json_return['status'] = "FAILED";
    $json_return['message'] = $e->getMessage();
}
Beispiel #2
0
$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";
$statement = $database->prepare($sql);
$statement->execute();
$query_results = $statement->fetchAll(PDO::FETCH_ASSOC);
$html_form .= createDatalistInput($get_row['damageType'], $form_id, "damageType", "Damage type:", NULL, $query_results, "damageType", $L_DATALIST_HINT . '<br>' . $L_DAMAGE_TYPE_HINT);
$html_form .= createDiceInput($get_row['secondaryDamage'], $form_id, "secondaryDamage", "Secondary Damage:", NULL, $L_DICE_HINT . '<br>' . $L_SECONDARY_DAMAGE_HINT);
$html_form .= createDatalistInput($get_row['secondaryDamageType'], $form_id, "secondaryDamageType", "Secondary damage type:", NULL, $query_results, "damageType", $L_DATALIST_HINT . '<br>' . $L_SECONDARY_DAMAGE_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';