mirror of
https://github.com/Neetpone/ponepaste.git
synced 2025-03-11 14:10:06 +01:00
97 lines
3.1 KiB
PHP
97 lines
3.1 KiB
PHP
<?php
|
|
/** @noinspection PhpDefineCanBeReplacedWithConstInspection */
|
|
define('IN_PONEPASTE', 1);
|
|
require_once(__DIR__ . '/../includes/common.php');
|
|
|
|
use Illuminate\Support\Facades\DB;
|
|
use PonePaste\Models\User;
|
|
use PonePaste\Models\Paste;
|
|
|
|
if (empty($_GET['user'])) {
|
|
// No username provided
|
|
flashError('User not found.');
|
|
goto Render;
|
|
}
|
|
|
|
$profile_username = trim($_GET['user']);
|
|
|
|
$profile_info = User::with('favourites')
|
|
->where('username', $profile_username)
|
|
->select('id', 'created_at', 'badge', 'role')
|
|
->first();
|
|
|
|
if (!$profile_info) {
|
|
// Invalid username
|
|
flashError('User not found.');
|
|
goto Render;
|
|
}
|
|
|
|
$can_administrate = can('administrate', $profile_info);
|
|
|
|
$p_title = $profile_username . "'s Public Pastes";
|
|
|
|
// There has to be a way to do the sum in SQL rather than PHP, but I can't figure out how to do it in Eloquent.
|
|
$total_pfav = array_sum(
|
|
array_column(
|
|
Paste::select('id')
|
|
->where('user_id', $profile_info->id)
|
|
->withCount('favouriters')
|
|
->get()->toArray(),
|
|
'favouriters_count'
|
|
)
|
|
);
|
|
$total_yfav = $profile_info->favourites->count();
|
|
|
|
// Badges
|
|
$profile_badge = match ((int) $profile_info['badge']) {
|
|
1 => '<img src="/img/badges/donate.png" title="[Donated] Donated to Ponepaste" style="margin:5px" alt="Donated to PonePaste" />',
|
|
2 => '<img src="/img/badges/spoon.png" title="[TheWoodenSpoon] You had one job" style="margin:5px" alt="You had one job" />',
|
|
3 => '<img src="/img/badges/abadge.png" title="[>AFuckingBadge] Won a PasteJam Competition" style="margin:5px" alt="Won a PasteJam competition" />',
|
|
4 => '<img src="/img/badges/abadge2023.png" title="[>AFuckingBadge] Winner of /PJ2023/" style="margin:5px">',
|
|
5 => '<span class="badge--padded badge--bgcolor-dark"><img src="/img/badges/hackerhorse.svg" title="[HackerHorse] Made a CTF write-up for a /mlp/ CTF and posted it on the site." /></span>',
|
|
default => ''
|
|
};
|
|
|
|
|
|
|
|
$profile_total_pastes = $profile_info->pastes->count();
|
|
$profile_total_public = $profile_info->pastes->where('visible', 0)->count();
|
|
$profile_total_unlisted = $profile_info->pastes->where('visible', 1)->count();
|
|
$profile_total_private = $profile_info->pastes->where('visible', 2)->count();
|
|
|
|
|
|
$profile_total_paste_views = Paste::select('views')
|
|
->where('user_id', $profile_info->id)
|
|
->sum('views');
|
|
|
|
$profile_join_date = $profile_info->created_at->format('Y-m-d');
|
|
|
|
$profile_favs = $profile_info->favourites;
|
|
$is_current_user = ($current_user !== null) && ($profile_info->id == $current_user->id);
|
|
|
|
// Pastes filtering
|
|
$filter_value = '';
|
|
list($per_page, $current_page) = pp_setup_pagination();
|
|
|
|
$total_results = $profile_info->pastes->count();
|
|
$profile_pastes = $profile_info->pastes()
|
|
->limit($per_page)
|
|
->offset($per_page * $current_page)
|
|
->get();
|
|
|
|
updatePageViews();
|
|
|
|
$csrf_token = setupCsrfToken();
|
|
|
|
Render:
|
|
|
|
if (isset($profile_info)) {
|
|
$page_title = 'Profile of ' . $profile_username;
|
|
$page_template = 'user_profile';
|
|
$script_bundles[] = 'user_profile';
|
|
} else {
|
|
$page_title = 'User not found';
|
|
$page_template = 'errors';
|
|
}
|
|
|
|
require_once(__DIR__ . '/../theme/' . $default_theme . '/common.php');
|