/**
* {@inheritDoc}
*/
public function deleteTopic(EloquentTopic $topic)
{
// Clean and convert ids
$ids = implode(',', array_filter($topic->pathExplode(), 'is_numeric'));
$query = "UPDATE forums\n\t\t\t SET posts = posts - ?, topics_count = topics_count - 1\n\t\t\t WHERE id IN ({$ids})";
return \DB::update($query, [$topic->posts_count]);
}
public function run()
{
DB::table('lforums_topics')->delete();
$forumsSeeder = new KaamaruForumsTableSeeder();
EloquentTopic::create(['id' => 1, 'title' => 'Test Topic', 'slug' => 'test-topic', 'posts_count' => 1, 'forum_id' => $forumsSeeder->ids['news'], 'author_id' => 2, 'last_post_user' => 2, 'last_post' => 1, 'views' => 0, 'sticky' => false, 'updated_at' => strtotime('1 week ago'), 'created_at' => strtotime('1 week ago')]);
EloquentTopic::create(['id' => 2, 'title' => 'Hello!', 'slug' => 'hello', 'posts_count' => 2, 'views' => 0, 'forum_id' => $forumsSeeder->ids['news'], 'author_id' => 1, 'last_post_user' => 2, 'last_post' => 2, 'updated_at' => strtotime('yesterday'), 'created_at' => strtotime('2 days ago'), 'sticky' => false]);
EloquentTopic::create(['id' => 3, 'title' => 'Suggestion', 'slug' => 'suggestion', 'posts_count' => 1, 'forum_id' => $forumsSeeder->ids['suggestions'], 'author_id' => 2, 'last_post_user' => 2, 'last_post' => 1, 'views' => 0, 'sticky' => false, 'updated_at' => strtotime('3 weeks ago'), 'created_at' => strtotime('2 weeks ago'), 'tag' => 'Closed']);
EloquentTopic::create(['id' => 4, 'title' => 'test', 'slug' => 'test-test-test', 'posts_count' => 1, 'author_id' => 2, 'last_post_user' => 2, 'last_post' => 1, 'views' => 0, 'sticky' => false, 'updated_at' => strtotime('3 weeks ago'), 'created_at' => strtotime('2 weeks ago'), 'forum_id' => $forumsSeeder->ids['suggestions']]);
}
