This post is for LISTING ONLY not discussing.
To search and replace an avatar link location
UPDATE fbb_user_info
SET info_avatar = REPLACE(info_avatar, 'http://www.yourdomain.com/ubbthreads/', 'http://www.yourdomain.com/fusion/')
WHERE `info_fsa` LIKE '%http://www.yourdomain.com/ubbthreads/%'
To change the color for a group
UPDATE fbb_user_info a, fbb_user_groups b
SET a.info_name_color = '#000066'
WHERE a.user_id = b.user_id
AND b.group_id = '1'
To change the color for a group but only if no color is already set
UPDATE fbb_user_info a, fbb_user_groups b
SET a.info_name_color = '#000066'
WHERE a.user_id = b.user_id
AND b.group_id = '1'
AND a.info_name_color IS NULL
Query to see how many unique users has logged into the forums in the past 24 hours
select user_id, info_user_login, info_last_online
from fbb_user_info
where info_last_online >= (UNIX_TIMESTAMP(NOW()) - 86400)
Force everyone to use a default skin
update fbb_user_info set info_userskin = 'always.use.default'
Count to see how many users use a particular skin
SELECT info_userskin, COUNT( info_userskin ) AS total_used
FROM fbb_user_info
GROUP BY info_userskin
ORDER BY total_used DESC
Since the newer versions are sorted by user names instead of user numbers, it makes it nearly impossible to lookup a user by the number. Here's the query for that. by Dman
SELECT info_display_name
FROM fbb_user_info
WHERE fbb_user_info.user_id =
(insert user number for the ???)
Is there a MYSQL query I can run in order to put all my users in the "Users" group ?
UPDATE fbb_user_groups
SET group_id = 'new group id'
WHERE group_id 'old group id'
is there a MYSQL Query I can run to set "Receive mass emails from board administration" to "yes"?
UPDATE fbb_user_info
SET info_receive_emails = 1
ow I can get the e-mail addresses of users who have not been on line for more than a month
SELECT info_real_email,info_user _login, info_last_online
FROM fbb_user_info
WHERE info_last_online <= ((UNIX_TIMESTAMP(NOW()) - 2592000)) AND info_receive_emails = 1
how can I turn everyones email settings who want admin mail to non-html
UPDATE fbb_user_info
SET info_html_email = 0
How Can I Change the default topic view from 30 days or newer to all dates.
update fbb_forums
set forum_topic_age = '0'
How can I perform a mass move of topics
UPDATE fbb_files SET forum_id = 'X' WHERE forum_id = 'Y'
UPDATE fbb_polls SET forum_id = 'X' WHERE forum_id = 'Y'
UPDATE fbb_posts SET forum_id = 'X' WHERE forum_id = 'Y'
UPDATE fbb_topics SET forum_id = 'X' WHERE forum_id = 'Y'
substitute new forum ID number for X and the old forum id number for Y.
If table fbb_page_cache crashes and needs to be wiped clean: thanx Gregori
TRUNCATE TABLE fbb_page_cache
To clear all titles
UPDATE fbb_user_info SET info_title_custom = ''
To clear out specific titles
UPDATE fbb_user_info SET info_title_custom = '' WHERE info_title_custom = '1234'
How to turn all signatures on
UPDATE fbb_user_info SET info_hide_sigs = 0
How to force birthdays to Show
update fbb_user_info set info_sharebirthday = 1
How to add a group of users into another group as well
insert into fbb_user_groups (group_id, user_id) select group_id, user_id from fbb_user_info, fbb_groups where user_id > 1 and group_id = #
where # is the group_id of the group you want to place them..
How do I force all users visible
UPDATE fbb_user_info SET info_visible = 1;
How do I alter someone's post count?
UPDATE fbb_user_info SET info_total_posts = '999' WHERE user_id = '123'
