https://WEBSITE/SEO-URL-OF-SUBJECT?page=3?highlight=SEARCHED_KEYWORD

https://WEBSITE/SEO-URL-OF-SUBJECT?page=3&highlight=SEARCHED_KEYWORD

<error>
	<dateline>1775677572</dateline>
	<script>inc/plugins/google_seo/url.php</script>
	<line>1622</line>
	<type>2</type>
	<friendly_type>Warning</friendly_type>
	<message>Undefined variable $newurl</message>
	<back_trace>#0  errorHandler->error() called at [/inc/class_error.php:157]
#1  errorHandler->error_callback() called at [/inc/plugins/google_seo/url.php:1622]
#2  google_seo_url_multipage() called at [/inc/functions.php:1148]
#3  multipage() called at [/inc/functions.php:4819]
#4  build_breadcrumb() called at [/inc/functions.php:298]
#5  parse_page() called at [/inc/functions.php:22]
#6  output_page() called at [/showthread.php:1652]
</back_trace>
</error>

<error>
	<dateline>1775677573</dateline>
	<script>inc/plugins/inferno/class_core.php</script>
	<line>93</line>
	<type>2</type>
	<friendly_type>Warning</friendly_type>
	<message>Trying to access array offset on false</message>
	<back_trace>#0  errorHandler->error() called at [/inc/class_error.php:157]
#1  errorHandler->error_callback() called at [/inc/plugins/inferno/class_core.php:93]
#2  inferno_shoutbox->is_banned() called at [/inc/plugins/inferno/class_core.php:60]
#3  inferno_shoutbox->__construct() called at [/inc/plugins/inferno/class_core.php:76]
#4  inferno_shoutbox::get_instance() called at [/inc/plugins/inferno.php:40]
#5  inferno_init() called at [/inc/plugins/inferno.php:82]
#6  inferno_global() called at [/inc/class_plugins.php:142]
#7  pluginSystem->run_hooks() called at [/global.php:498]
#8  require_once() called at [/showthread.php:28]
</back_trace>
</error>

<error>
	<dateline>1775677573</dateline>
	<script>inc/plugins/google_seo/url.php</script>
	<line>846</line>
	<type>2</type>
	<friendly_type>Warning</friendly_type>
	<message>Undefined array key 3128</message>
	<back_trace>#0  errorHandler->error() called at [/inc/class_error.php:157]
#1  errorHandler->error_callback() called at [/inc/plugins/google_seo/url.php:846]
#2  google_seo_url_cache() called at [/inc/plugins/google_seo/url.php:1360]
#3  google_seo_url_profile() called at [/inc/functions.php:6444]
#4  get_profile_link() called at [/inc/functions_post.php:280]
#5  build_postbit() called at [/showthread.php:1122]
</back_trace>
</error>

<error>
	<dateline>1775677573</dateline>
	<script>inc/plugins/google_seo.php</script>
	<line>198</line>
	<type>2</type>
	<friendly_type>Warning</friendly_type>
	<message>Trying to access array offset on null</message>
	<back_trace>#0  errorHandler->error() called at [/inc/class_error.php:157]
#1  errorHandler->error_callback() called at [/inc/plugins/google_seo.php:198]
#2  google_seo_tid() called at [/inc/plugins/google_seo/url.php:1465]
#3  google_seo_url_post() called at [/inc/functions.php:6608]
#4  get_post_link() called at [/inc/functions_post.php:722]
#5  build_postbit() called at [/showthread.php:1122]
</back_trace>
</error>

<?php
/**
 * xp plugin for MyBB 1.8.x.
 */

if (!defined('IN_MYBB')) {
    die('Direct initialization of this file is not allowed.');
}

if (!defined('AURUN_XP_MIN_GLORY_DISPLAY')) {
    define('AURUN_XP_MIN_GLORY_DISPLAY', 0.01);
}

$plugins->add_hook('admin_config_settings_change', 'aurun_xp_settings_changed');
$plugins->add_hook('global_start', 'aurun_xp_global_start');
$plugins->add_hook('index_start', 'aurun_xp_index_start');
$plugins->add_hook('stats_start', 'aurun_xp_stats_start');
$plugins->add_hook('member_profile_end', 'aurun_xp_member_profile_end');
$plugins->add_hook('memberlist_user', 'aurun_xp_memberlist_user');
$plugins->add_hook('postbit', 'aurun_xp_postbit');
$plugins->add_hook('postbit_prev', 'aurun_xp_postbit');
$plugins->add_hook('postbit_pm', 'aurun_xp_postbit');
$plugins->add_hook('postbit_announcement', 'aurun_xp_postbit');

$plugins->add_hook('datahandler_post_insert_post_end', 'aurun_xp_handle_insert_post');
$plugins->add_hook('datahandler_post_insert_thread_end', 'aurun_xp_handle_insert_thread');
$plugins->add_hook('datahandler_post_update_end', 'aurun_xp_handle_update_post');
$plugins->add_hook('xmlhttp_update_post', 'aurun_xp_handle_inline_edit');
$plugins->add_hook('editpost_do_editpost_end', 'aurun_xp_handle_editpost_end');
$plugins->add_hook('editpost_deletepost', 'aurun_xp_mark_dirty_event');
$plugins->add_hook('editpost_restorepost', 'aurun_xp_mark_dirty_event');
$plugins->add_hook('editpost_start', 'aurun_xp_handle_author_change_request');

$plugins->add_hook('class_moderation_delete_post_start', 'aurun_xp_capture_post_delete_start');
$plugins->add_hook('class_moderation_delete_thread_start', 'aurun_xp_capture_thread_delete_start');
$plugins->add_hook('class_moderation_delete_post', 'aurun_xp_mark_dirty_event');
$plugins->add_hook('class_moderation_delete_thread', 'aurun_xp_mark_dirty_event');
$plugins->add_hook('class_moderation_soft_delete_posts', 'aurun_xp_mark_dirty_event');
$plugins->add_hook('class_moderation_restore_posts', 'aurun_xp_mark_dirty_event');
$plugins->add_hook('class_moderation_soft_delete_threads', 'aurun_xp_mark_dirty_event');
$plugins->add_hook('class_moderation_restore_threads', 'aurun_xp_mark_dirty_event');
$plugins->add_hook('class_moderation_move_thread_redirect', 'aurun_xp_mark_dirty_event');
$plugins->add_hook('class_moderation_move_simple', 'aurun_xp_mark_dirty_event');
$plugins->add_hook('class_moderation_copy_thread', 'aurun_xp_mark_dirty_event');
$plugins->add_hook('class_moderation_move_threads', 'aurun_xp_mark_dirty_event');
$plugins->add_hook('class_moderation_merge_posts', 'aurun_xp_mark_dirty_event');
$plugins->add_hook('class_moderation_merge_threads', 'aurun_xp_mark_dirty_event');
$plugins->add_hook('class_moderation_split_posts', 'aurun_xp_mark_dirty_event');
$plugins->add_hook('class_moderation_approve_posts', 'aurun_xp_mark_dirty_event');
$plugins->add_hook('class_moderation_unapprove_posts', 'aurun_xp_mark_dirty_event');
$plugins->add_hook('class_moderation_approve_threads', 'aurun_xp_mark_dirty_event');
$plugins->add_hook('class_moderation_unapprove_threads', 'aurun_xp_mark_dirty_event');

function aurun_xp_info()
{
    return [
        'name' => 'Aurun XP / Ruhm',
        'description' => 'counting words and adding xp.',
        'website' => '',
        'author' => 'Allvater',
        'authorsite' => '',
        'version' => '1.1.0',
        'compatibility' => '18*',
    ];
}

function aurun_xp_is_installed()
{
    global $db;

    return $db->field_exists('xp_words', 'posts') && $db->field_exists('xp_glory_total', 'users');
}

function aurun_xp_install()
{
    aurun_xp_ensure_schema();
    aurun_xp_create_settings();
    aurun_xp_mark_dirty(true, 'install');
    aurun_xp_rebuild_all();
}

function aurun_xp_uninstall()
{
    global $db;

    aurun_xp_remove_settings();
    aurun_xp_drop_column_if_exists('posts', 'xp_words');
    aurun_xp_drop_column_if_exists('posts', 'xp_glory');
    aurun_xp_drop_column_if_exists('users', 'xp_glory_total');
    $db->delete_query('datacache', "title IN ('aurun_xp_stats', 'aurun_xp_dirty', 'aurun_xp_delete_snapshot')");
}

function aurun_xp_activate()
{
    aurun_xp_ensure_schema();
}

function aurun_xp_deactivate()
{
    // Keine Template-Edits oder Template-Insertions.
}

function aurun_xp_ensure_schema()
{
    global $db;

    if (!$db->field_exists('xp_words', 'posts')) {
        $db->add_column('posts', 'xp_words', 'INT UNSIGNED NOT NULL DEFAULT 0');
    }

    if (!$db->field_exists('xp_glory', 'posts')) {
        $db->add_column('posts', 'xp_glory', 'DECIMAL(12,2) NOT NULL DEFAULT 0.00');
    }

    if (!$db->field_exists('xp_glory_total', 'users')) {
        $db->add_column('users', 'xp_glory_total', 'DECIMAL(14,2) NOT NULL DEFAULT 0.00');
    }
}

function aurun_xp_drop_column_if_exists($table, $column)
{
    global $db;

    if ($db->field_exists($column, $table)) {
        $db->drop_column($table, $column);
    }
}

function aurun_xp_create_settings()
{
    global $db;

    $gid = (int) $db->fetch_field($db->simple_select('settinggroups', 'gid', "name='aurun_xp'"), 'gid');

    if (!$gid) {
        $gid = (int) $db->insert_query('settinggroups', [
            'name' => 'aurun_xp',
            'title' => 'Aurun XP / Ruhm',
            'description' => 'Einstellungen für Wortzählung, Ruhm und Anzeigevariablen.',
            'disporder' => 90,
            'isdefault' => 0,
        ]);
    }

    $settings = [
        'aurun_xp_scored_forums' => [
            'title' => 'Gewertete Foren',
            'description' => 'Kommaseparierte Foren-IDs. Nur diese Foren zählen für User-Ruhm, Gesamtruhm, RPG-Beiträge, RPG-Themen und längsten RPG-Beitrag.',
            'optionscode' => 'text',
            'value' => '',
            'disporder' => 1,
        ],
        'aurun_xp_scored_groups' => [
            'title' => 'Gewertete Gruppen',
            'description' => 'Kommaseparierte Gruppen-IDs. Es wird nur die primäre Gruppe eines Users geprüft.',
            'optionscode' => 'text',
            'value' => '',
            'disporder' => 2,
        ],
        'aurun_xp_inactive_groups' => [
            'title' => 'Inaktive Gruppen',
            'description' => 'Kommaseparierte Gruppen-IDs. Diese User behalten ihren Ruhm, zählen weiter zum Gesamtruhm, werden aber in Listen, Top-Spieler und Krone ausgeblendet.',
            'optionscode' => 'text',
            'value' => '',
            'disporder' => 3,
        ],
        'aurun_xp_glory_per_word' => [
            'title' => 'Ruhm pro Wort',
            'description' => 'Numerischer Wert, z. B. 0.01. Gilt nur für Beiträge in gewerteten Foren von Usern in gewerteten Gruppen.',
            'optionscode' => 'numeric',
            'value' => '0.01',
            'disporder' => 4,
        ],
    ];

    foreach ($settings as $name => $setting) {
        $where = "name='" . $db->escape_string($name) . "'";
        $existing = (int) $db->fetch_field($db->simple_select('settings', 'sid', $where), 'sid');

        $payload = [
            'name' => $name,
            'title' => $setting['title'],
            'description' => $setting['description'],
            'optionscode' => $setting['optionscode'],
            'value' => $setting['value'],
            'disporder' => $setting['disporder'],
            'gid' => $gid,
            'isdefault' => 0,
        ];

        if ($existing) {
            $db->update_query('settings', $payload, $where);
        } else {
            $db->insert_query('settings', $payload);
        }
    }

    rebuild_settings();
}

function aurun_xp_remove_settings()
{
    global $db;

    $db->delete_query('settings', "name IN ('aurun_xp_scored_forums','aurun_xp_scored_groups','aurun_xp_inactive_groups','aurun_xp_glory_per_word')");
    $db->delete_query('settinggroups', "name='aurun_xp'");
    rebuild_settings();
}

function aurun_xp_settings_changed()
{
    aurun_xp_reset_config_cache();
    aurun_xp_mark_dirty(true, 'settings_changed');
}

function aurun_xp_reset_config_cache()
{
    $GLOBALS['aurun_xp_config_cache'] = null;
}

function aurun_xp_mark_dirty($dirty = true, $reason = '')
{
    global $cache;

    $current = $cache->read('aurun_xp_dirty');
    if (!is_array($current)) {
        $current = [];
    }

    $payload = [
        'dirty' => (int) $dirty,
        'updated_at' => TIME_NOW,
        'reason' => (string) $reason,
        'rebuilding' => 0,
    ];

    if (!$dirty && !empty($current['rebuilding'])) {
        $payload['rebuilding'] = 0;
    }

    $cache->update('aurun_xp_dirty', $payload);
}

function aurun_xp_set_rebuilding_flag($rebuilding)
{
    global $cache;

    $state = $cache->read('aurun_xp_dirty');
    if (!is_array($state)) {
        $state = [];
    }

    $state['dirty'] = (int) ($state['dirty'] ?? 0);
    $state['updated_at'] = TIME_NOW;
    $state['reason'] = (string) ($state['reason'] ?? '');
    $state['rebuilding'] = (int) $rebuilding;
    $cache->update('aurun_xp_dirty', $state);
}

function aurun_xp_parse_id_list($raw)
{
    $raw = trim((string) $raw);
    if ($raw === '') {
        return [];
    }

    $ids = [];
    foreach (preg_split('/\s*,\s*/', $raw, -1, PREG_SPLIT_NO_EMPTY) as $part) {
        $value = (int) $part;
        if ($value > 0) {
            $ids[$value] = $value;
        }
    }

    return array_values($ids);
}

function aurun_xp_get_config()
{
    global $mybb;

    if (isset($GLOBALS['aurun_xp_config_cache']) && is_array($GLOBALS['aurun_xp_config_cache'])) {
        return $GLOBALS['aurun_xp_config_cache'];
    }

    $GLOBALS['aurun_xp_config_cache'] = [
        'scored_forums' => aurun_xp_parse_id_list($mybb->settings['aurun_xp_scored_forums'] ?? ''),
        'scored_groups' => aurun_xp_parse_id_list($mybb->settings['aurun_xp_scored_groups'] ?? ''),
        'inactive_groups' => aurun_xp_parse_id_list($mybb->settings['aurun_xp_inactive_groups'] ?? ''),
        'glory_per_word' => round((float) ($mybb->settings['aurun_xp_glory_per_word'] ?? 0), 2),
    ];

    return $GLOBALS['aurun_xp_config_cache'];
}

function aurun_xp_is_scored_forum($fid)
{
    return in_array((int) $fid, aurun_xp_get_config()['scored_forums'], true);
}

function aurun_xp_is_scored_group($groupId)
{
    return in_array((int) $groupId, aurun_xp_get_config()['scored_groups'], true);
}

function aurun_xp_is_inactive_group($groupId)
{
    return in_array((int) $groupId, aurun_xp_get_config()['inactive_groups'], true);
}

function aurun_xp_is_active_user(array $user)
{
    $uid = (int) ($user['uid'] ?? 0);
    $groupId = (int) ($user['usergroup'] ?? 0);

    return $uid > 0 && $uid !== 3 && !aurun_xp_is_inactive_group($groupId);
}

function aurun_xp_format_glory($value)
{
    return number_format((float) $value, 2, ',', '');
}

function aurun_xp_count_words($message)
{
    $message = (string) $message;
    if ($message === '') {
        return 0;
    }

    $message = preg_replace('#https?://\S+#iu', ' ', $message);
    $message = preg_replace('#www\.\S+#iu', ' ', $message);
    $message = preg_replace('#\[(?:/?)(?:[^\]\s=]+)(?:=[^\]]+)?\]#u', ' ', $message);
    $message = html_entity_decode(strip_tags($message), ENT_QUOTES, 'UTF-8');

    preg_match_all('/\p{L}{2,}(?:-\p{L}{2,})*/u', $message, $matches);

    return count($matches[0]);
}

function aurun_xp_calculate_glory($fid, $usergroup, $wordCount)
{
    $config = aurun_xp_get_config();

    if ($wordCount <= 0 || !aurun_xp_is_scored_forum($fid) || !aurun_xp_is_scored_group($usergroup)) {
        return 0.00;
    }

    return round($wordCount * (float) $config['glory_per_word'], 2);
}

function aurun_xp_get_post_snapshot($pid)
{
    global $db;

    $query = $db->query(
        "SELECT p.pid, p.tid, p.uid, p.fid, p.message, p.subject, p.visible, p.dateline, p.xp_words, p.xp_glory,
                t.visible AS threadvisible
         FROM " . TABLE_PREFIX . "posts p
         LEFT JOIN " . TABLE_PREFIX . "threads t ON (t.tid = p.tid)
         WHERE p.pid='" . (int) $pid . "'
         LIMIT 1"
    );

    return $db->fetch_array($query);
}

function aurun_xp_get_user_snapshot($uid)
{
    global $db;

    $uid = (int) $uid;
    if ($uid <= 0) {
        return null;
    }

    if (!isset($GLOBALS['aurun_xp_user_snapshot_cache'])) {
        $GLOBALS['aurun_xp_user_snapshot_cache'] = [];
    }

    if (array_key_exists($uid, $GLOBALS['aurun_xp_user_snapshot_cache'])) {
        return $GLOBALS['aurun_xp_user_snapshot_cache'][$uid];
    }

    $GLOBALS['aurun_xp_user_snapshot_cache'][$uid] = $db->fetch_array($db->simple_select('users', 'uid,username,usergroup,displaygroup,xp_glory_total', 'uid=' . $uid));

    return $GLOBALS['aurun_xp_user_snapshot_cache'][$uid];
}

function aurun_xp_extract_pid_from_datahandler($dataHandler)
{
    if (is_object($dataHandler)) {
        foreach (['pid', 'post_insert_data'] as $property) {
            if ($property === 'pid' && !empty($dataHandler->pid)) {
                return (int) $dataHandler->pid;
            }
            if ($property === 'post_insert_data' && !empty($dataHandler->post_insert_data['pid'])) {
                return (int) $dataHandler->post_insert_data['pid'];
            }
        }
        if (!empty($dataHandler->data['pid'])) {
            return (int) $dataHandler->data['pid'];
        }
        if (!empty($dataHandler->return_values['pid'])) {
            return (int) $dataHandler->return_values['pid'];
        }
    }

    global $pid, $mybb;
    if (!empty($pid)) {
        return (int) $pid;
    }
    if (isset($mybb)) {
        return (int) $mybb->get_input('pid', MyBB::INPUT_INT);
    }

    return 0;
}

function aurun_xp_guard_once($pid, $context)
{
    $pid = (int) $pid;
    if ($pid <= 0) {
        return false;
    }

    if (!isset($GLOBALS['aurun_xp_once_guard'])) {
        $GLOBALS['aurun_xp_once_guard'] = [];
    }

    $key = (string) $pid;
    if (isset($GLOBALS['aurun_xp_once_guard'][$key])) {
        return false;
    }

    $GLOBALS['aurun_xp_once_guard'][$key] = true;

    return true;
}

function aurun_xp_handle_insert_post($dataHandler = null)
{
    $pid = aurun_xp_extract_pid_from_datahandler($dataHandler);
    if ($pid > 0) {
        aurun_xp_apply_post_change($pid, 'insert_post');
    }
}

function aurun_xp_handle_insert_thread($dataHandler = null)
{
    $pid = aurun_xp_extract_pid_from_datahandler($dataHandler);
    if ($pid > 0) {
        aurun_xp_apply_post_change($pid, 'insert_thread');
    }
}

function aurun_xp_handle_update_post($dataHandler = null)
{
    $pid = aurun_xp_extract_pid_from_datahandler($dataHandler);
    if ($pid > 0 && aurun_xp_guard_once($pid, 'update_post')) {
        aurun_xp_apply_post_change($pid, 'update_post');
    }
}

function aurun_xp_handle_inline_edit()
{
    global $mybb, $pid;

    $inlinePid = (int) $mybb->get_input('pid', MyBB::INPUT_INT);
    if ($inlinePid <= 0 && !empty($pid)) {
        $inlinePid = (int) $pid;
    }

    if ($inlinePid > 0 && aurun_xp_guard_once($inlinePid, 'inline_edit')) {
        aurun_xp_apply_post_change($inlinePid, 'inline_edit');
    }
}

function aurun_xp_handle_editpost_end()
{
    global $pid;

    if ((int) $pid > 0 && aurun_xp_guard_once((int) $pid, 'editpost')) {
        aurun_xp_apply_post_change((int) $pid, 'editpost');
    }
}

function aurun_xp_handle_author_change_request()
{
    global $mybb;

    if (
        $mybb->request_method === 'post'
        && $mybb->get_input('action') === 'do_author'
        && ($mybb->settings['aj_changeauthor'] == 1 || $mybb->settings['aj_admin_changeauthor'] == 1)
    ) {
        $pid = (int) $mybb->get_input('pid', MyBB::INPUT_INT);
        if ($pid > 0) {
            register_shutdown_function('aurun_xp_refresh_post_metrics_after_shutdown', $pid, 'author_change');
        }
    }
}

function aurun_xp_refresh_post_metrics_after_shutdown($pid, $reason = '')
{
    $pid = (int) $pid;
    if ($pid <= 0) {
        return;
    }

    if (aurun_xp_guard_once($pid, 'shutdown_update')) {
        aurun_xp_apply_post_change($pid, 'shutdown_update');
    }
}

function aurun_xp_get_stats_cache_for_update()
{
    global $cache;

    $stats = $cache->read('aurun_xp_stats');
    if (!is_array($stats)) {
        aurun_xp_rebuild_all();
        $stats = $cache->read('aurun_xp_stats');
    }

    return is_array($stats) ? $stats : [];
}

function aurun_xp_write_stats_cache(array $stats)
{
    global $cache;

    $cache->update('aurun_xp_stats', $stats);
}

function aurun_xp_refresh_top_player_cache(array &$stats = null)
{
    if ($stats === null) {
        $stats = aurun_xp_get_stats_cache_for_update();
    }

    $topPlayer = aurun_xp_fetch_top_player();
    $stats['xp_top_glory_uid'] = (int) ($topPlayer['uid'] ?? 0);
    $stats['xp_top_glory_value'] = number_format((float) ($topPlayer['xp_glory_total'] ?? 0), 2, '.', '');

    return $stats;
}

function aurun_xp_recount_longest_post()
{
    global $db;

    $longestPost = [
        'pid' => 0,
        'tid' => 0,
        'uid' => 0,
        'subject' => '',
        'dateline' => 0,
        'words' => 0,
    ];

    $query = $db->query(
        "SELECT p.pid, p.tid, p.uid, p.subject, p.dateline, p.xp_words
         FROM " . TABLE_PREFIX . "posts p
         LEFT JOIN " . TABLE_PREFIX . "threads t ON (t.tid = p.tid)
         WHERE p.visible = 1
           AND t.visible = 1
           AND p.fid IN (" . aurun_xp_sql_id_list(aurun_xp_get_config()['scored_forums']) . ")
         ORDER BY p.xp_words DESC, p.pid ASC
         LIMIT 1"
    );

    if ($query) {
        $row = $db->fetch_array($query);
        if ($row) {
            $longestPost = [
                'pid' => (int) $row['pid'],
                'tid' => (int) $row['tid'],
                'uid' => (int) $row['uid'],
                'subject' => (string) $row['subject'],
                'dateline' => (int) $row['dateline'],
                'words' => (int) $row['xp_words'],
            ];
        }
    }

    return $longestPost;
}

function aurun_xp_refresh_longest_post_cache(array &$stats, $pid, $wordCount, $isCandidate)
{
    $currentPid = (int) ($stats['xp_longest_post_pid'] ?? 0);
    $currentWords = (int) ($stats['xp_longest_post_words'] ?? 0);

    if ($isCandidate && (int) $wordCount > $currentWords) {
        $post = aurun_xp_get_post_snapshot($pid);
        $stats['xp_longest_post_pid'] = (int) $pid;
        $stats['xp_longest_post_words'] = (int) $wordCount;
        $stats['xp_longest_post_tid'] = (int) ($post['tid'] ?? 0);
        $stats['xp_longest_post_uid'] = (int) ($post['uid'] ?? 0);
        $stats['xp_longest_post_subject'] = (string) ($post['subject'] ?? '');
        $stats['xp_longest_post_dateline'] = (int) ($post['dateline'] ?? 0);

        return $stats;
    }

    if ($currentPid === (int) $pid && (!$isCandidate || (int) $wordCount < $currentWords)) {
        $longestPost = aurun_xp_recount_longest_post();
        $stats['xp_longest_post_pid'] = $longestPost['pid'];
        $stats['xp_longest_post_words'] = $longestPost['words'];
        $stats['xp_longest_post_tid'] = $longestPost['tid'];
        $stats['xp_longest_post_uid'] = $longestPost['uid'];
        $stats['xp_longest_post_subject'] = $longestPost['subject'];
        $stats['xp_longest_post_dateline'] = $longestPost['dateline'];
    }

    return $stats;
}

function aurun_xp_adjust_user_glory_total($uid, $delta)
{
    global $db;

    $uid = (int) $uid;
    $delta = round((float) $delta, 2);

    if ($uid <= 0 || abs($delta) < 0.01) {
        return false;
    }

    $user = aurun_xp_get_user_snapshot($uid);
    if (!$user) {
        return false;
    }

    $newTotal = round(max(0, (float) $user['xp_glory_total'] + $delta), 2);

    $db->update_query('users', [
        'xp_glory_total' => number_format($newTotal, 2, '.', ''),
    ], 'uid=' . $uid);

    if (!isset($GLOBALS['aurun_xp_user_snapshot_cache'])) {
        $GLOBALS['aurun_xp_user_snapshot_cache'] = [];
    }
    if ($user) {
        $user['xp_glory_total'] = number_format($newTotal, 2, '.', '');
        $GLOBALS['aurun_xp_user_snapshot_cache'][$uid] = $user;
    }

    return true;
}

function aurun_xp_accountswitcher_author_changed($pid, $oldUid, $newUid)
{
    $pid = (int) $pid;
    $oldUid = (int) $oldUid;
    $newUid = (int) $newUid;

    if ($pid <= 0 || $oldUid <= 0 || $newUid <= 0 || $oldUid === $newUid) {
        return false;
    }

    $post = aurun_xp_get_post_snapshot($pid);
    if (!$post) {
        return false;
    }

    $isVisible = ((int) $post['visible'] === 1 && (int) ($post['threadvisible'] ?? 1) === 1);
    $glory = round((float) ($post['xp_glory'] ?? 0), 2);

    if (!$isVisible || $glory <= 0) {
        return true;
    }

    aurun_xp_adjust_user_glory_total($oldUid, -$glory);
    aurun_xp_adjust_user_glory_total($newUid, $glory);

    $stats = aurun_xp_get_stats_cache_for_update();
    aurun_xp_refresh_top_player_cache($stats);
    aurun_xp_write_stats_cache($stats);

    return true;
}

function aurun_xp_refresh_post_metrics($pid)
{
    global $db;

    $post = aurun_xp_get_post_snapshot($pid);
    if (!$post) {
        return;
    }

    $user = aurun_xp_get_user_snapshot((int) $post['uid']);
    $wordCount = aurun_xp_count_words($post['message']);
    $glory = aurun_xp_calculate_glory((int) $post['fid'], (int) ($user['usergroup'] ?? 0), $wordCount);

    $db->update_query('posts', [
        'xp_words' => $wordCount,
        'xp_glory' => number_format($glory, 2, '.', ''),
    ], 'pid=' . (int) $pid);
}

function aurun_xp_apply_post_change($pid, $context = 'update_post', array $options = [])
{
    global $db;

    $pid = (int) $pid;
    if ($pid <= 0) {
        return false;
    }

    $post = aurun_xp_get_post_snapshot($pid);
    if (!$post) {
        return false;
    }

    $isInsert = in_array($context, ['insert_post', 'insert_thread'], true);
    $oldWords = (int) ($options['old_words'] ?? ($isInsert ? 0 : ($post['xp_words'] ?? 0)));
    $oldGlory = round((float) ($options['old_glory'] ?? ($isInsert ? 0 : ($post['xp_glory'] ?? 0))), 2);
    $oldVisible = (int) ($options['old_visible'] ?? ($isInsert ? 0 : ($post['visible'] ?? 0)));
    $oldThreadVisible = (int) ($options['old_threadvisible'] ?? ($isInsert ? 0 : ($post['threadvisible'] ?? 0)));
    $oldUid = (int) ($options['old_uid'] ?? ($post['uid'] ?? 0));

    $user = aurun_xp_get_user_snapshot((int) $post['uid']);
    $newWords = aurun_xp_count_words($post['message']);
    $newGlory = aurun_xp_calculate_glory((int) $post['fid'], (int) ($user['usergroup'] ?? 0), $newWords);

    $db->update_query('posts', [
        'xp_words' => $newWords,
        'xp_glory' => number_format($newGlory, 2, '.', ''),
    ], 'pid=' . $pid);

    $newVisible = ((int) $post['visible'] === 1 && (int) ($post['threadvisible'] ?? 1) === 1);
    $oldVisibleCounted = ($oldVisible === 1 && $oldThreadVisible === 1);
    $oldContribution = $oldVisibleCounted ? $oldGlory : 0.00;
    $newContribution = $newVisible ? $newGlory : 0.00;

    if ($oldUid === (int) $post['uid']) {
        $delta = round($newContribution - $oldContribution, 2);
        if (abs($delta) >= 0.01) {
            aurun_xp_adjust_user_glory_total((int) $post['uid'], $delta);
        }
    } else {
        if ($oldContribution > 0) {
            aurun_xp_adjust_user_glory_total($oldUid, -$oldContribution);
        }
        if ($newContribution > 0) {
            aurun_xp_adjust_user_glory_total((int) $post['uid'], $newContribution);
        }
    }

    $stats = aurun_xp_get_stats_cache_for_update();
    $stats['xp_total_glory'] = number_format(round((float) ($stats['xp_total_glory'] ?? 0) + ($newContribution - $oldContribution), 2), 2, '.', '');

    if ($context === 'insert_post' && $newVisible && aurun_xp_is_scored_forum((int) $post['fid'])) {
        $stats['xp_rpg_posts_total'] = (int) ($stats['xp_rpg_posts_total'] ?? 0) + 1;
    } elseif ($context === 'insert_thread' && $newVisible && aurun_xp_is_scored_forum((int) $post['fid'])) {
        $stats['xp_rpg_posts_total'] = (int) ($stats['xp_rpg_posts_total'] ?? 0) + 1;
        $stats['xp_rpg_threads_total'] = (int) ($stats['xp_rpg_threads_total'] ?? 0) + 1;
    }

    $isLongestCandidate = $newVisible && aurun_xp_is_scored_forum((int) $post['fid']);
    aurun_xp_refresh_longest_post_cache($stats, $pid, $newWords, $isLongestCandidate);
    aurun_xp_refresh_top_player_cache($stats);
    $stats['rebuilt_at'] = TIME_NOW;
    aurun_xp_write_stats_cache($stats);

    return true;
}

function aurun_xp_capture_post_delete_start($pid)
{
    global $cache;

    $cache->update('aurun_xp_delete_snapshot', [
        'type' => 'post',
        'pid' => (int) $pid,
        'updated_at' => TIME_NOW,
    ]);

    return $pid;
}

function aurun_xp_capture_thread_delete_start($tid)
{
    global $cache;

    $cache->update('aurun_xp_delete_snapshot', [
        'type' => 'thread',
        'tid' => (int) $tid,
        'updated_at' => TIME_NOW,
    ]);

    return $tid;
}

function aurun_xp_mark_dirty_event($payload = null)
{
    aurun_xp_mark_dirty(true, 'moderation');

    return $payload;
}

function aurun_xp_maybe_run_dirty_rebuild()
{
    global $cache;
    static $running = false;

    if ($running) {
        return;
    }

    $state = $cache->read('aurun_xp_dirty');
    if (!is_array($state) || empty($state['dirty'])) {
        return;
    }

    if (!empty($state['rebuilding'])) {
        return;
    }

    $running = true;
    aurun_xp_set_rebuilding_flag(true);
    aurun_xp_rebuild_all();
    $running = false;
}

function aurun_xp_rebuild_all()
{
    global $db, $cache;

    aurun_xp_ensure_schema();

    $db->write_query('UPDATE ' . TABLE_PREFIX . "users SET xp_glory_total='0.00'");

    $userGroups = [];
    $query = $db->simple_select('users', 'uid,usergroup');
    while ($user = $db->fetch_array($query)) {
        $userGroups[(int) $user['uid']] = (int) $user['usergroup'];
    }

    $activeGloryByUser = [];
    $totalGlory = 0.00;
    $rpgPostsTotal = 0;
    $longestPost = [
        'pid' => 0,
        'tid' => 0,
        'uid' => 0,
        'subject' => '',
        'dateline' => 0,
        'words' => 0,
    ];

    $postsQuery = $db->query(
        "SELECT p.pid, p.tid, p.uid, p.fid, p.message, p.subject, p.visible, p.dateline,
                t.visible AS threadvisible
         FROM " . TABLE_PREFIX . "posts p
         LEFT JOIN " . TABLE_PREFIX . "threads t ON (t.tid = p.tid)
         ORDER BY p.pid ASC"
    );

    while ($post = $db->fetch_array($postsQuery)) {
        $uid = (int) $post['uid'];
        $wordCount = aurun_xp_count_words($post['message']);
        $glory = aurun_xp_calculate_glory((int) $post['fid'], (int) ($userGroups[$uid] ?? 0), $wordCount);

        $db->update_query('posts', [
            'xp_words' => $wordCount,
            'xp_glory' => number_format($glory, 2, '.', ''),
        ], 'pid=' . (int) $post['pid']);

        $isVisible = ((int) $post['visible'] === 1 && (int) $post['threadvisible'] === 1);
        if (!$isVisible) {
            continue;
        }

        if (aurun_xp_is_scored_forum((int) $post['fid'])) {
            ++$rpgPostsTotal;

            if ($wordCount > $longestPost['words']) {
                $longestPost = [
                    'pid' => (int) $post['pid'],
                    'tid' => (int) $post['tid'],
                    'uid' => $uid,
                    'subject' => (string) $post['subject'],
                    'dateline' => (int) $post['dateline'],
                    'words' => $wordCount,
                ];
            }
        }

        if ($glory > 0) {
            $activeGloryByUser[$uid] = round(($activeGloryByUser[$uid] ?? 0) + $glory, 2);
            $totalGlory = round($totalGlory + $glory, 2);
        }
    }

    foreach ($activeGloryByUser as $uid => $gloryTotal) {
        $db->update_query('users', [
            'xp_glory_total' => number_format($gloryTotal, 2, '.', ''),
        ], 'uid=' . (int) $uid);
    }

    $rpgThreadsTotal = 0;
    $threadQuery = $db->query(
        "SELECT COUNT(*) AS total
         FROM " . TABLE_PREFIX . "threads
         WHERE fid IN (" . aurun_xp_sql_id_list(aurun_xp_get_config()['scored_forums']) . ")
           AND visible = 1
           AND closed NOT LIKE 'moved|%'"
    );
    if ($threadQuery) {
        $rpgThreadsTotal = (int) $db->fetch_field($threadQuery, 'total');
    }

    $topPlayer = aurun_xp_fetch_top_player();

    $cache->update('aurun_xp_stats', [
        'xp_total_glory' => number_format($totalGlory, 2, '.', ''),
        'xp_rpg_posts_total' => $rpgPostsTotal,
        'xp_rpg_threads_total' => $rpgThreadsTotal,
        'xp_longest_post_pid' => $longestPost['pid'],
        'xp_longest_post_words' => $longestPost['words'],
        'xp_longest_post_tid' => $longestPost['tid'],
        'xp_longest_post_uid' => $longestPost['uid'],
        'xp_longest_post_subject' => $longestPost['subject'],
        'xp_longest_post_dateline' => $longestPost['dateline'],
        'xp_top_glory_uid' => (int) ($topPlayer['uid'] ?? 0),
        'xp_top_glory_value' => number_format((float) ($topPlayer['xp_glory_total'] ?? 0), 2, '.', ''),
        'rebuilt_at' => TIME_NOW,
    ]);

    aurun_xp_set_rebuilding_flag(false);
    aurun_xp_mark_dirty(false, 'rebuilt');
}

function aurun_xp_sql_id_list(array $ids)
{
    $ids = array_map('intval', $ids);
    $ids = array_filter($ids, static function ($id) {
        return $id > 0;
    });

    if (empty($ids)) {
        return '0';
    }

    return implode(',', $ids);
}

function aurun_xp_fetch_top_player($limit = 1)
{
    global $db;

    $limit = (int) max(1, $limit);
    $config = aurun_xp_get_config();
    $inactiveGroups = aurun_xp_sql_id_list($config['inactive_groups']);
    $inactiveClause = $inactiveGroups !== '0' ? " AND usergroup NOT IN (" . $inactiveGroups . ")" : '';

    $query = $db->query(
        "SELECT uid, username, usergroup, displaygroup, xp_glory_total
         FROM " . TABLE_PREFIX . "users
         WHERE uid <> 3
           AND xp_glory_total >= '0.01'" . $inactiveClause . "
         ORDER BY xp_glory_total DESC, username ASC
         LIMIT " . $limit
    );

    if ($limit === 1) {
        $user = $db->fetch_array($query);

        return $user ?: null;
    }

    $users = [];
    while ($user = $db->fetch_array($query)) {
        $users[] = $user;
    }

    return $users;
}

function aurun_xp_get_ranked_users($limit = 0)
{
    global $db;

    $config = aurun_xp_get_config();
    $inactiveGroups = aurun_xp_sql_id_list($config['inactive_groups']);
    $inactiveClause = $inactiveGroups !== '0' ? " AND usergroup NOT IN (" . $inactiveGroups . ")" : '';
    $sqlLimit = $limit > 0 ? ' LIMIT ' . (int) $limit : '';
    $query = $db->query(
        "SELECT uid, username, usergroup, displaygroup, xp_glory_total
         FROM " . TABLE_PREFIX . "users
         WHERE xp_glory_total >= '0.01'
           AND uid <> 3" . $inactiveClause . "
         ORDER BY xp_glory_total DESC, username ASC" . $sqlLimit
    );

    $users = [];
    while ($user = $db->fetch_array($query)) {
        $users[] = $user;
    }

    return $users;
}

function aurun_xp_get_cached_stats()
{
    global $cache;

    aurun_xp_maybe_run_dirty_rebuild();

    $stats = $cache->read('aurun_xp_stats');

    return is_array($stats) ? $stats : [];
}

function aurun_xp_crown_html($uid)
{
    $stats = aurun_xp_get_cached_stats();

    if ((int) $uid > 0 && (int) ($stats['xp_top_glory_uid'] ?? 0) === (int) $uid) {
        return '<span class="aurunxp-crown" title="Ruhmreichster Charakter">👑</span>';
    }

    return '';
}

function aurun_xp_global_start()
{
    global $mybb;

    aurun_xp_maybe_run_dirty_rebuild();

    if ((int) ($mybb->user['uid'] ?? 0) <= 0) {
        return;
    }

    $mybb->user['aurunxp_glory'] = aurun_xp_format_glory((float) ($mybb->user['xp_glory_total'] ?? 0));
    $mybb->user['aurunxp_crown'] = aurun_xp_crown_html((int) $mybb->user['uid']);
}

function aurun_xp_index_start()
{
    global $aurunxp_total_glory, $aurunxp_rpg_posts_total, $aurunxp_rpg_threads_total, $aurunxp_top_list, $aurunxp_longest_post;

    $stats = aurun_xp_get_cached_stats();
    $aurunxp_total_glory = aurun_xp_format_glory((float) ($stats['xp_total_glory'] ?? 0));
    $aurunxp_rpg_posts_total = my_number_format((int) ($stats['xp_rpg_posts_total'] ?? 0));
    $aurunxp_rpg_threads_total = my_number_format((int) ($stats['xp_rpg_threads_total'] ?? 0));

    $topList = [];
    foreach (aurun_xp_fetch_top_player(10) as $user) {
        $topList[] = build_profile_link(
            format_name(htmlspecialchars_uni($user['username']), (int) $user['usergroup'], (int) $user['displaygroup']),
            (int) $user['uid']
        ) . ' (' . aurun_xp_format_glory((float) $user['xp_glory_total']) . ')';
    }
    $aurunxp_top_list = implode(', ', $topList);

    $aurunxp_longest_post = '';
    if (!empty($stats['xp_longest_post_pid'])) {
        $author = aurun_xp_get_user_snapshot((int) $stats['xp_longest_post_uid']);
        $authorLink = $author ? build_profile_link(htmlspecialchars_uni($author['username']), (int) $author['uid']) : 'Unbekannt';
        $title = htmlspecialchars_uni($stats['xp_longest_post_subject'] ?: ('Beitrag #' . (int) $stats['xp_longest_post_pid']));
        $aurunxp_longest_post = '<a href="' . get_post_link((int) $stats['xp_longest_post_pid']) . '">' . $title . '</a> | ' .
            $authorLink . ' | ' .
            my_number_format((int) $stats['xp_longest_post_words']) . ' Wörter | ' .
            my_date('relative', (int) $stats['xp_longest_post_dateline']);
    }
}

function aurun_xp_stats_start()
{
    global $aurunxp_stats_rpg_posts_total, $aurunxp_stats_rpg_threads_total, $aurunxp_stats_longest_post, $aurunxp_stats_top_user, $aurunxp_stats_top_ten;

    $stats = aurun_xp_get_cached_stats();
    $aurunxp_stats_rpg_posts_total = my_number_format((int) ($stats['xp_rpg_posts_total'] ?? 0));
    $aurunxp_stats_rpg_threads_total = my_number_format((int) ($stats['xp_rpg_threads_total'] ?? 0));
    $aurunxp_stats_longest_post = my_number_format((int) ($stats['xp_longest_post_words'] ?? 0));

    $topUser = aurun_xp_fetch_top_player();
    $aurunxp_stats_top_user = '';
    if ($topUser) {
        $aurunxp_stats_top_user = build_profile_link(htmlspecialchars_uni($topUser['username']), (int) $topUser['uid']) .
            ' (' . aurun_xp_format_glory((float) $topUser['xp_glory_total']) . ')';
        if (aurun_xp_crown_html((int) $topUser['uid']) !== '') {
            $aurunxp_stats_top_user .= ' ' . aurun_xp_crown_html((int) $topUser['uid']);
        }
    }

    $topTen = [];
    foreach (aurun_xp_fetch_top_player(10) as $user) {
        $entry = build_profile_link(htmlspecialchars_uni($user['username']), (int) $user['uid']) .
            ' (' . aurun_xp_format_glory((float) $user['xp_glory_total']) . ')';
        $topTen[] = $entry;
    }
    $aurunxp_stats_top_ten = implode(', ', $topTen);
}

function aurun_xp_member_profile_end()
{
    global $memprofile;

    $memprofile['aurunxp_glory'] = aurun_xp_format_glory((float) ($memprofile['xp_glory_total'] ?? 0));
    $memprofile['aurunxp_crown'] = aurun_xp_crown_html((int) ($memprofile['uid'] ?? 0));
}

function aurun_xp_memberlist_user(&$user)
{
    $user['aurunxp_glory'] = aurun_xp_format_glory((float) ($user['xp_glory_total'] ?? 0));
    $user['aurunxp_crown'] = aurun_xp_crown_html((int) ($user['uid'] ?? 0));
}

function aurun_xp_postbit(&$post)
{
    $post['aurunxp_words'] = my_number_format((int) ($post['xp_words'] ?? 0));
    $post['aurunxp_glory'] = aurun_xp_format_glory((float) ($post['xp_glory'] ?? 0));

    if (isset($post['xp_glory_total'])) {
        $post['aurunxp_user_glory'] = aurun_xp_format_glory((float) $post['xp_glory_total']);
    } else {
        $author = aurun_xp_get_user_snapshot((int) ($post['uid'] ?? 0));
        $post['aurunxp_user_glory'] = aurun_xp_format_glory((float) ($author['xp_glory_total'] ?? 0));
    }

    $post['aurunxp_crown'] = aurun_xp_crown_html((int) ($post['uid'] ?? 0));
}