mirror of
https://github.com/NamelessMC/Nameless
synced 2026-08-18 06:29:04 -04:00
ab2fed32a1
* Improve online staff/users widget caching * lint * format sql, order by group id * same for staff widget
64 lines
2.5 KiB
PHP
64 lines
2.5 KiB
PHP
<?php
|
|
|
|
class ForumPostSeeder extends Seeder
|
|
{
|
|
public array $tables = [
|
|
'nl2_posts',
|
|
'nl2_forums_reactions',
|
|
];
|
|
|
|
protected function run(DB $db, \Faker\Generator $faker): void
|
|
{
|
|
$topics = $db->get('topics', ['id', '<>', '0'])->results();
|
|
$users = $db->get('users', ['id', '<>', '0'])->results();
|
|
|
|
foreach ($topics as $topic) {
|
|
$created = $faker->dateTimeBetween('-1 years');
|
|
|
|
$db->insert('posts', [
|
|
'forum_id' => $topic->forum_id,
|
|
'topic_id' => $topic->id,
|
|
'post_creator' => $topic->topic_creator,
|
|
'post_content' => $faker->sentences($faker->numberBetween(3, 30), true),
|
|
'post_date' => $created->format('Y-m-d H:i:s'),
|
|
'created' => $created->format('U'),
|
|
]);
|
|
|
|
$this->times(FORUM_POST_COUNT, function () use ($db, $faker, $topic, $users) {
|
|
$user = $faker->randomElement($users);
|
|
$created = $this->since($user->joined, $faker);
|
|
|
|
$db->insert('posts', [
|
|
'forum_id' => $topic->forum_id,
|
|
'topic_id' => $topic->id,
|
|
'post_creator' => $user->id,
|
|
'post_content' => $faker->sentences($faker->numberBetween(3, 30), true),
|
|
'post_date' => $created->format('Y-m-d H:i:s'),
|
|
'created' => $created->format('U'),
|
|
]);
|
|
$post_id = $db->lastId();
|
|
|
|
$db->update('forums', ['id', $topic->forum_id], [
|
|
'last_post_date' => $created->format('U'),
|
|
'last_user_posted' => $user->id,
|
|
'last_topic_posted' => $topic->id,
|
|
]);
|
|
|
|
if ($faker->boolean(60)) {
|
|
return;
|
|
}
|
|
|
|
$reactions = DB::getInstance()->get('reactions', ['id', '<>', '0'])->results();
|
|
$this->times($faker->numberBetween(15, 50), function () use ($db, $faker, $user, $users, $post_id, $created, $reactions) {
|
|
$db->insert('forums_reactions', [
|
|
'post_id' => $post_id,
|
|
'user_received' => $user->id,
|
|
'user_given' => $faker->randomElement($users)->id,
|
|
'reaction_id' => $faker->randomElement($reactions)->id,
|
|
'time' => $this->since($created->format('U'), $faker)->format('U'),
|
|
]);
|
|
});
|
|
});
|
|
}
|
|
}
|
|
}
|