/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$faker = Faker\Factory::create();
try {
// DB::table('phpbb_forums')->delete();
// DB::table('phpbb_topics')->delete();
// DB::table('phpbb_posts')->delete();
$forums = [];
$beatmapCount = App\Models\Beatmapset::count();
if ($beatmapCount > 0) {
// Create beatmap threads
$f = App\Models\Forum\Forum::create(['forum_name' => 'Beatmap Threads', 'forum_desc' => 'Beatmap thread info for beatmaps', 'forum_type' => 0]);
$f2 = $f->subforums()->save(factory(App\Models\Forum\Forum::class, 'child')->make(['parent_id' => 1, 'forum_name' => 'Beatmap Threads', 'forum_desc' => 'Beatmap thread info for beatmaps']));
$bms = App\Models\Beatmapset::all();
foreach ($bms as $set) {
$t = $f2->topics()->save(factory(App\Models\Forum\Topic::class)->make(['forum_id' => $f2->forum_id, 'topic_poster' => $set->creator, 'topic_title' => $set->artist . ' - ' . $set->title]));
$p = $t->posts()->save(factory(App\Models\Forum\Post::class)->make(['forum_id' => $f2->forum_id, 'poster_id' => $set->user_id, 'post_username' => $set->creator, 'post_subject' => $set->artist . ' - ' . $set->title, 'post_text' => '---------------']));
$t->refreshCache();
$set->thread_id = $t->topic_id;
$set->save();
}
$f2->refreshCache();
}
// Create 3 forums
factory(App\Models\Forum\Forum::class, 'parent', 3)->create()->each(function ($f) {
for ($i = 0; $i < 4; $i++) {
// Subforums for each forum.
$f2 = $f->subforums()->save(factory(App\Models\Forum\Forum::class, 'child')->make());
// Topics for each subforum
for ($j = 0; $j < 3; $j++) {
$t = $f2->topics()->save(factory(App\Models\Forum\Topic::class)->make(['forum_id' => $f2->forum_id]));
// Replies to the topic
for ($k = 0; $k < 5; $k++) {
$p = $t->posts()->save(factory(App\Models\Forum\Post::class)->make(['forum_id' => $f2->forum_id]));
}
// Refresh topic cache (updates last post times etc)
$t->refreshCache();
}
// Refresh forum cache
$f2->refreshCache();
}
});
} catch (\Illuminate\Database\QueryException $e) {
echo $e->getMessage() . "\r\n";
} catch (Exception $ex) {
echo $ex->getMessage() . "\r\n";
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
// DB::table('osu_scores')->delete();
// DB::table('osu_scores_high')->delete();
// DB::table('osu_scores_taiko')->delete();
// DB::table('osu_scores_taiko_high')->delete();
// DB::table('osu_scores_fruits')->delete();
// DB::table('osu_scores_fruits_high')->delete();
$beatmaps = App\Models\Beatmap::orderByRaw('RAND()')->get();
$beatmapCount = count($beatmaps);
if ($beatmapCount === 0) {
$this->command->info('Can\'t seed Scores due to having no beatmap data.');
return;
}
$faker = Faker::create();
$users = App\Models\User::all();
App\Models\Score\Model::unguard();
$allBeatmapsets = App\Models\Beatmapset::all();
$possible_ranks = ['A', 'S', 'B', 'SH', 'XH', 'X'];
foreach ($users as $k => $u) {
$osuBeatmaps = $beatmaps->where('playmode', 0)->take(20);
$taikoBeatmaps = $beatmaps->where('playmode', 1)->take(20);
$fruitsBeatmaps = $beatmaps->where('playmode', 2)->take(20);
$maniaBeatmaps = $beatmaps->where('playmode', 3)->take(20);
//add 20 osu! Standard scores
foreach ($osuBeatmaps as $bm) {
$bms = $allBeatmapsets->find($bm->beatmapset_id);
$maxcombo = rand(1, $bm->countTotal);
$possible_mods = [0, 16, 24, 64, 72];
// hr, hd/hr, dt, hd/dt
$sc = App\Models\Score\Osu::create(['user_id' => $u->user_id, 'beatmap_id' => $bm->beatmap_id, 'beatmapset_id' => $bm->beatmapset_id, 'score' => rand(50000, 100000000), 'maxcombo' => $maxcombo, 'count300' => round($maxcombo * 0.8), 'count100' => rand(0, round($maxcombo * 0.15)), 'count50' => rand(0, round($maxcombo * 0.05)), 'countgeki' => round($maxcombo * 0.3), 'countmiss' => round($maxcombo * 0.05), 'countkatu' => round($maxcombo * 0.05), 'enabled_mods' => array_rand_val($possible_mods), 'date' => rand(1451606400, time()), 'pass' => $faker->boolean(85), 'rank' => array_rand_val($possible_ranks)]);
$sc2 = App\Models\Score\Best\Osu::create(['user_id' => $u->user_id, 'beatmap_id' => $bm->beatmap_id, 'beatmapset_id' => $bm->beatmapset_id, 'score' => rand(50000, 100000000), 'maxcombo' => $maxcombo, 'count300' => round($maxcombo * 0.8), 'count100' => rand(0, round($maxcombo * 0.15)), 'count50' => rand(0, round($maxcombo * 0.05)), 'countgeki' => round($maxcombo * 0.3), 'countmiss' => round($maxcombo * 0.05), 'countkatu' => round($maxcombo * 0.05), 'enabled_mods' => array_rand_val($possible_mods), 'date' => rand(1451606400, time()), 'pp' => $faker->biasedNumberBetween(10, 100) * 1.5 * $bm->difficultyrating, 'rank' => array_rand_val($possible_ranks)]);
}
//Taiko scores
foreach ($taikoBeatmaps as $bm) {
$bms = $allBeatmapsets->find($bm->beatmapset_id);
$maxcombo = rand(1, $bm->countTotal);
$possible_mods = [0, 16, 24, 64, 72];
$sc3 = App\Models\Score\Taiko::create(['user_id' => $u->user_id, 'beatmap_id' => $bm->beatmap_id, 'beatmapset_id' => $bm->beatmapset_id, 'score' => rand(50000, 100000000), 'maxcombo' => $maxcombo, 'count300' => round($maxcombo * 0.8), 'count100' => rand(0, round($maxcombo * 0.15)), 'count50' => rand(0, round($maxcombo * 0.05)), 'countgeki' => round($maxcombo * 0.3), 'countmiss' => round($maxcombo * 0.05), 'countkatu' => round($maxcombo * 0.05), 'enabled_mods' => array_rand_val($possible_mods), 'date' => rand(1451606400, time()), 'pass' => $faker->boolean(85), 'rank' => array_rand_val($possible_ranks)]);
$sc4 = App\Models\Score\Best\Taiko::create(['user_id' => $u->user_id, 'beatmap_id' => $bm->beatmap_id, 'beatmapset_id' => $bm->beatmapset_id, 'score' => rand(50000, 100000000), 'maxcombo' => $maxcombo, 'rank' => array_rand_val($possible_ranks), 'count300' => round($maxcombo * 0.8), 'count100' => rand(0, round($maxcombo * 0.15)), 'count50' => rand(0, round($maxcombo * 0.05)), 'countgeki' => round($maxcombo * 0.3), 'countmiss' => round($maxcombo * 0.05), 'countkatu' => round($maxcombo * 0.05), 'enabled_mods' => array_rand_val($possible_mods), 'date' => rand(1451606400, time()), 'pp' => $faker->biasedNumberBetween(10, 100) * 1.3 * $bm->difficultyrating]);
}
// end taiko
//Fruits scores
foreach ($fruitsBeatmaps as $bm) {
$bms = $allBeatmapsets->find($bm->beatmapset_id);
$maxcombo = rand(1, $bm->countTotal);
$possible_mods = [0, 16, 24, 64, 72];
$sc5 = App\Models\Score\Fruits::create(['user_id' => $u->user_id, 'beatmap_id' => $bm->beatmap_id, 'beatmapset_id' => $bm->beatmapset_id, 'score' => rand(50000, 100000000), 'maxcombo' => $maxcombo, 'rank' => array_rand_val($possible_ranks), 'count300' => round($maxcombo * 0.8), 'count100' => rand(0, round($maxcombo * 0.15)), 'count50' => rand(0, round($maxcombo * 0.05)), 'countgeki' => round($maxcombo * 0.3), 'countmiss' => round($maxcombo * 0.05), 'countkatu' => round($maxcombo * 0.05), 'enabled_mods' => array_rand_val($possible_mods), 'date' => rand(1451606400, time()), 'pass' => $faker->boolean(85)]);
$sc6 = App\Models\Score\Best\Fruits::create(['user_id' => $u->user_id, 'beatmap_id' => $bm->beatmap_id, 'beatmapset_id' => $bm->beatmapset_id, 'score' => rand(50000, 100000000), 'maxcombo' => $maxcombo, 'rank' => array_rand_val($possible_ranks), 'count300' => round($maxcombo * 0.8), 'count100' => rand(0, round($maxcombo * 0.15)), 'count50' => rand(0, round($maxcombo * 0.05)), 'countgeki' => round($maxcombo * 0.3), 'countmiss' => round($maxcombo * 0.05), 'countkatu' => round($maxcombo * 0.05), 'enabled_mods' => array_rand_val($possible_mods), 'date' => rand(1451606400, time()), 'pp' => $faker->biasedNumberBetween(10, 100) * 1.3 * $bm->difficultyrating]);
}
// end fruits
//Mania scores
foreach ($maniaBeatmaps as $bm) {
$bms = $allBeatmapsets->find($bm->beatmapset_id);
$maxcombo = rand(1, $bm->countTotal);
$possible_mods = [0, 16, 24, 64, 72];
// hr, hd/hr, dt, hd/dt
$sc7 = App\Models\Score\Mania::create(['user_id' => $u->user_id, 'beatmap_id' => $bm->beatmap_id, 'beatmapset_id' => $bm->beatmapset_id, 'score' => rand(50000, 100000000), 'maxcombo' => $maxcombo, 'rank' => array_rand_val($possible_ranks), 'count300' => round($maxcombo * 0.8), 'count100' => rand(0, round($maxcombo * 0.15)), 'count50' => rand(0, round($maxcombo * 0.05)), 'countgeki' => round($maxcombo * 0.3), 'countmiss' => round($maxcombo * 0.05), 'countkatu' => round($maxcombo * 0.05), 'enabled_mods' => array_rand_val($possible_mods), 'date' => rand(1451606400, time()), 'pass' => $faker->boolean(85)]);
$sc8 = App\Models\Score\Best\Mania::create(['user_id' => $u->user_id, 'beatmap_id' => $bm->beatmap_id, 'beatmapset_id' => $bm->beatmapset_id, 'score' => rand(50000, 100000000), 'maxcombo' => $maxcombo, 'rank' => array_rand_val($possible_ranks), 'count300' => round($maxcombo * 0.8), 'count100' => rand(0, round($maxcombo * 0.15)), 'count50' => rand(0, round($maxcombo * 0.05)), 'countgeki' => round($maxcombo * 0.3), 'countmiss' => round($maxcombo * 0.05), 'countkatu' => round($maxcombo * 0.05), 'enabled_mods' => array_rand_val($possible_mods), 'date' => rand(1451606400, time()), 'pp' => $faker->biasedNumberBetween(10, 100) * 2 * $bm->difficultyrating]);
}
// end mania
}
App\Models\Score\Model::reguard();
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$faker = Faker\Factory::create();
try {
// Create appropriate forum permissions
$authOptionIds = [];
foreach (['f_post', 'f_reply'] as $authOption) {
$option = new App\Models\Forum\AuthOption();
$option->auth_option = $authOption;
$option->save();
$authOptionIds[] = $option->auth_option_id;
}
$beatmapCount = App\Models\Beatmapset::count();
if ($beatmapCount > 0) {
// Create beatmap threads
$f = App\Models\Forum\Forum::create(['forum_name' => 'Beatmap Threads', 'forum_desc' => 'Beatmap thread info for beatmaps', 'forum_type' => 0]);
$f2 = $f->subforums()->save(factory(App\Models\Forum\Forum::class, 'child')->make(['parent_id' => 1, 'forum_name' => 'Beatmap Threads', 'forum_desc' => 'Beatmap thread info for beatmaps']));
$bms = App\Models\Beatmapset::all();
foreach ($bms as $set) {
$t = $f2->topics()->save(factory(App\Models\Forum\Topic::class)->make(['forum_id' => $f2->forum_id, 'topic_poster' => $set->creator, 'topic_title' => $set->artist . ' - ' . $set->title]));
$p = $t->posts()->save(factory(App\Models\Forum\Post::class)->make(['forum_id' => $f2->forum_id, 'poster_id' => $set->user_id, 'post_username' => $set->creator, 'post_subject' => $set->artist . ' - ' . $set->title, 'post_text' => '---------------']));
$t->refreshCache();
$set->thread_id = $t->topic_id;
$set->save();
}
$f2->refreshCache();
}
// Create 3 forums
factory(App\Models\Forum\Forum::class, 'parent', 3)->create()->each(function ($f) {
for ($i = 0; $i < 4; $i++) {
// Subforums for each forum.
$f2 = $f->subforums()->save(factory(App\Models\Forum\Forum::class, 'child')->make());
// Topics for each subforum
for ($j = 0; $j < 3; $j++) {
$t = $f2->topics()->save(factory(App\Models\Forum\Topic::class)->make(['forum_id' => $f2->forum_id]));
// Replies to the topic
for ($k = 0; $k < 5; $k++) {
$p = $t->posts()->save(factory(App\Models\Forum\Post::class)->make(['forum_id' => $f2->forum_id]));
}
// Refresh topic cache (updates last post times etc)
$t->refreshCache();
}
// Refresh forum cache
$f2->refreshCache();
}
});
foreach (App\Models\Forum\Forum::all() as $forum) {
foreach ($authOptionIds as $optionId) {
$group = new App\Models\Forum\Authorize();
$group->group_id = App\Models\UserGroup::GROUPS['default'];
$group->forum_id = $forum->forum_id;
$group->auth_option_id = $optionId;
$group->auth_setting = 1;
$group->save();
}
}
} catch (\Illuminate\Database\QueryException $e) {
echo $e->getMessage() . "\r\n";
} catch (Exception $ex) {
echo $ex->getMessage() . "\r\n";
}
}
