public function replies($time = null)
{
$replies = Mod::query()->whereNotNull('parent_item_id')->where('beatmapset_id', '=', $this->beatmapset_id)->orderBy('created_at', 'asc');
if ($time) {
// also grab soft-deleted posts
$replies = $replies->where(function ($query) use($time) {
$query->where(DB::raw('UNIX_TIMESTAMP(`created_at`)'), '>', $time);
$query->orWhere(DB::raw('UNIX_TIMESTAMP(`updated_at`)'), '>', $time);
})->withTrashed();
}
$replies = $replies->get()->load('creator');
$new = [];
foreach ($replies as $reply) {
if (!isset($new[$reply->parent_item_id])) {
$new[$reply->parent_item_id] = [];
}
$new[$reply->parent_item_id][$reply->item_id] = $reply->toArray();
}
return $new;
}
public function replies($time = null)
{
$replies = Mod::query()->whereNotNull("parent_item_id")->where("beatmapset_id", "=", $this->beatmapset_id)->orderBy("created_at", "asc");
if ($time) {
// also grab soft-deleted posts
$replies = $replies->where(function ($query) use($time) {
$query->where(DB::raw("UNIX_TIMESTAMP(`created_at`)"), ">", $time);
$query->orWhere(DB::raw("UNIX_TIMESTAMP(`updated_at`)"), ">", $time);
})->withTrashed();
}
$replies = $replies->get()->load("creator");
$new = [];
foreach ($replies as $reply) {
if (!isset($new[$reply->parent_item_id])) {
$new[$reply->parent_item_id] = [];
}
$new[$reply->parent_item_id][$reply->item_id] = $reply->toArray();
}
return $new;
}
