Kod XenForo SQL ile Şifre Değiştirme

ooo

UPDATE xf_user_authenticate
SET data = BINARY
    CONCAT(
        CONCAT(
            CONCAT('a:3:{s:4:"hash";s:40:"', SHA1(CONCAT(SHA1('Yeni_Şifre'), SHA1('salt')))),
            CONCAT('";s:4:"salt";s:40:"', SHA1('salt'))
        ),
        '";s:8:"hashFunc";s:4:"sha1";}'
    ),
scheme_class = 'XenForo_Authentication_Core'
WHERE user_id = 1;

WHERE user_id = 1;

UPDATE xf_user_authenticate
SET data = BINARY
    CONCAT(
        CONCAT(
            CONCAT('a:3:{s:4:"hash";s:40:"', SHA1(CONCAT(SHA1('YOU PASS HERE'), SHA1('salt')))),
            CONCAT('";s:4:"salt";s:40:"', SHA1('salt'))
        ),
        '";s:8:"hashFunc";s:4:"sha1";}'
    ),
scheme_class = 'XF:Core'
WHERE user_id = USER ID HERE;

xf_job

TRUNCATE `xf_admin_log`;
TRUNCATE `xf_change_log`;
TRUNCATE `xf_moderator_log`;
TRUNCATE `xf_session_activity`;

DELETE FROM xf_sitemap;

DELETE FROM xf_registration_spam_cache;

DELETE FROM xf_username_change;

DELETE FROM xf_change_log;

TRUNCATE TABLE xf_file_check;

DELETE FROM xf_email_bounce_log;

DELETE FROM xf_spam_trigger_log;

TRUNCATE TABLE xf_moderator_log;

TRUNCATE TABLE xf_admin_log;