Xenforo için faydalı SQL sorguları

UPDATE xf_user SET language_id = 2

DELETE FROM xf_permission_entry_content WHERE content_id = X;

DELETE FROM `xenforo`.`xf_permission_entry_content` WHERE `xf_permission_entry_content`.`content_id` = X;

TRUNCATE TABLE xf_permission_entry_content;

UPDATE xf_user_profile set signature = ''

UPDATE xf_user_option SET email_on_conversation = 0

UPDATE xf_user_option SET receive_admin_email = 1

UPDATE xf_user_option SET creation_watch_state = 'watch_no_email'

UPDATE xf_user_option SET interaction_watch_state = 'watch_no_email'

UPDATE xf_user SET timezone = 'Africa/Nairobi'

UPDATE xf_user
SET register_date = UNIX_TIMESTAMP('yyyy-mm-dd 00:00:00')
WHERE user_id = 2

UPDATE xf_user SET language_id = 2;

UPDATE xf_user SET style_id = 2;

UPDATE xf_post

SET

message = REPLACE(message, 'değiştirmek istediğiniz eski cümle', 'yeni cümle bu alana gelecek');

UPDATE xf_user_authenticate

SET data = BINARY

    CONCAT(

        CONCAT(

            CONCAT('a:3:{s:4:"hash";s:40:"', SHA1(CONCAT(SHA1('Buraya yeni parolayı girin'), 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;