public function run()
{
DB::table('profile_field_options')->delete();
DB::table('profile_fields')->delete();
DB::table('profile_field_groups')->delete();
$profileFieldGroups = [['name' => 'About You', 'slug' => 'about-you'], ['name' => 'Contact Details', 'slug' => 'contact-details']];
DB::table('profile_field_groups')->insert($profileFieldGroups);
$profileFields = [['type' => 'text', 'name' => 'Favourite Pet', 'description' => "What's the name of your favourite pet?", 'display_order' => 4, 'profile_field_group_id' => DB::table('profile_field_groups')->where('slug', 'about-you')->pluck('id')], ['type' => 'select', 'name' => 'Sex', 'description' => '', 'display_order' => 1, 'profile_field_group_id' => DB::table('profile_field_groups')->where('slug', 'about-you')->pluck('id')], ['type' => 'text', 'name' => 'Location', 'description' => 'Where in the world do you live?', 'display_order' => 2, 'profile_field_group_id' => DB::table('profile_field_groups')->where('slug', 'about-you')->pluck('id')], ['type' => 'textarea', 'name' => 'Bio', 'description' => 'Enter a few short details about yourself, your life story etc.', 'display_order' => 3, 'profile_field_group_id' => DB::table('profile_field_groups')->where('slug', 'about-you')->pluck('id')], ['type' => 'url', 'name' => 'Website', 'description' => 'Must be a valid URL.', 'display_order' => 1, 'profile_field_group_id' => DB::table('profile_field_groups')->where('slug', 'contact-details')->pluck('id'), 'validation_rules' => 'required|url'], ['type' => 'text', 'name' => 'Skype', 'description' => '', 'display_order' => 2, 'profile_field_group_id' => DB::table('profile_field_groups')->where('slug', 'contact-details')->pluck('id')], ['type' => 'text', 'name' => 'Twitter', 'description' => 'Must be in the format @username.', 'display_order' => 1, 'profile_field_group_id' => DB::table('profile_field_groups')->where('slug', 'contact-details')->pluck('id'), 'validation_rules' => 'regex:/^@\\w+$/']];
foreach ($profileFields as $profileField) {
\MyBB\Core\Database\Models\ProfileField::create($profileField);
}
$options = [['profile_field_id' => DB::table('profile_fields')->where('name', 'Sex')->pluck('id'), 'name' => 'Male', 'value' => 'Male'], ['profile_field_id' => DB::table('profile_fields')->where('name', 'Sex')->pluck('id'), 'name' => 'Female', 'value' => 'Female'], ['profile_field_id' => DB::table('profile_fields')->where('name', 'Sex')->pluck('id'), 'name' => 'Undisclosed', 'value' => 'Undisclosed'], ['profile_field_id' => DB::table('profile_fields')->where('name', 'Sex')->pluck('id'), 'name' => 'Other', 'value' => 'Other']];
DB::table('profile_field_options')->insert($options);
}
/**
* @param int $id
*/
public function delete($id)
{
$this->profileField->newQuery()->getQuery()->delete($id);
}
