echo 'Populating the entity table<br/>'; $fields = array('location' => 'tinytext', 'price' => 'decimal(10,2)', 'classified_print_content' => 'text', 'classified_date_available' => 'datetime', 'classified_duration_days' => 'int', 'classified_contact_email' => 'tinytext', 'display_contact_info' => 'boolean'); foreach ($fields as $key => $value) { $fields[$key] = array('db_type' => $value); } $updater = new FieldToEntityTable('classified_table', $fields); $updater->update_entity_table(); $updater->report(); } echo 'Checking for classified category type... '; if (reason_unique_name_exists('classified_category_type')) { echo 'Classified category type already exists. Proceeding.<br/>'; $classified_category = id_of('classified_category_type'); } else { echo 'Creating classified category type.<br/>'; $classified_category = create_type($admin_site, id_of('type'), $user, 'Classified Category', array('new' => 0, 'plural_name' => 'Classified categories', 'unique_name' => 'classified_category_type')); echo 'Creating allowable relationship with classifieds<br/>'; create_allowable_relationship($classified, $classified_category, 'classified_to_classified_category'); } echo 'Putting entity tables on classified type<br/>'; $rel = relationship_id_of('type_to_table'); foreach (array('classified_table', 'meta', 'chunk', 'dated') as $t) { if (name_exists($t)) { create_relationship($classified, id_of_name($t), $rel); } else { echo "Missing name {$t}!<br/>"; } } echo "Install was successful!<br/>"; } ?>
<?php //echo "0 "; $connection = new PDO("mysql:host=localhost;dbname=peeps", "root", ""); switch ($_POST["function_to_be_called"]) { case "create": create_type(trim($_POST['new_trait']), (bool) $_POST['discrete']); break; case "list": display_all(); break; case "delete": delete($_POST['type']); break; case "delete_trait": delete_trait($_POST['id']); break; case "change_rank": change_rank($_POST['id'], $_POST['is_direction_up']); break; case "create_trait": create_trait($_POST['profile_id'], $_POST['trait_id'], $_POST['trait_type'], $_POST['trait_value'], $_POST['trait_discrete']); break; } function change_rank($id, $is_direction_up) { global $connection; $statement = $connection->prepare("select * from traits where id=?"); $statement->bindValue(1, $id, PDO::PARAM_INT); $statement->execute(); $main_record = $statement->fetchObject();