$invited = DB::table('inviteds')
->select(DB::raw('count(*) as count, referer'))
->join('users AS refererJoin', 'inviteds.referer', '=', 'refererJoin.id')
->join('users AS userJoin', 'inviteds.user_id', '=', 'userJoin.id')
->where('inviteds.created_at', '>', $comp->start)
->where('inviteds.created_at', '<', $comp->end)
->groupBy('referer')
->orderBy('count', 'desc')
->get();
->where('userJoin.banned', '=', 0)
<?
echo strlen("йцу");
?>
$file_read = explode("\r\n", file_get_contents($this->path));
$elCounts = array_count_values($file_read);
$result = array();
for ($i = 0; $i < count($file_read); ++$i) {
foreach ($elCounts as $k => $v) {
if ($file_read[$i] == $k && $v == 1) {
$result[] = $file_read[$i];
break;
}
}
}