SQL Commands

This topic is full of SQL commands to help admins with IPB acp

n = new group
o = old group
x = number
f = new forum
z = current forum
m = moderator's user id

Mass Move Members to a New Group

UPDATE ibf_members SET mgroup = n WHERE mgroup = o

DELETE FROM ibf_profile_comments WHERE comment_by_member_id = x

UPDATE ibf_members SET mgroup = n WHERE posts = 0

UPDATE ibf_members SET mgroup = n WHERE posts = 0 AND mgroup = o

DELETE FROM ibf_members WHERE posts=0

UPDATE ibf_forums SET parent_id = f WHERE parent_id = z

UPDATE ibf_topics SET views = '100' WHERE views = '0'

DELETE FROM ibf_moderators WHERE member_id = m

TRUNCATE TABLE ibf_sessions

TRUNCATE TABLE ibf_admin_login_logs

TRUNCATE TABLE ibf_admin_logs

TRUNCATE TABLE ibf_badwords

TRUNCATE TABLE ibf_banfilters

TRUNCATE TABLE ibf_email_logs

TRUNCATE TABLE ibf_profile_comments

 

TRUNCATE TABLE ibf_profile_friends

TRUNCATE TABLE ibf_profile_ratings

TRUNCATE TABLE ibf_spider_logs

TRUNCATE TABLE ibf_task_logs

UPDATE ibf_downloads_files SET file_updated=0

UPDATE ibf_downloads_files SET file_approver='0' AND file_approvedon='0'

UPDATE ibf_members SET members_profile_views = 0

UPDATE ibf_members SET members_profile_views = 0 WHERE id=x

UPDATE ibf_forums SET parent_id = f WHERE parent_id = z

 

DELETE FROM ibf_message_text WHERE msg_author_id = x 

DELETE FROM ibf_message_topics WHERE mt_from_id = x

UPDATE ibf_members SET warn_level = 0

UPDATE ibf_posts SET author_id='1' WHERE pid=' p - i -d';

update ibf_topics set title='title', starter_id='member id' where tid='id of the topic'

UPDATE ibf_members SET mgroup = 4 WHERE id = x

UPDATE ibf_topics SET state='open' WHERE state='closed'

UPDATE ibf_topics SET state='closed' WHERE state='open'

update ibf_forums set parent_id = X where parent_id = Y

UPDATE ibf_topics SET views = '100' WHERE views = '0'

Komentarze:

Brak komentarzy