XMB Forum Software
Not logged in [Login - Register]
Search the forums Search   FAQ   Member List   Today's Posts   Stats   Board Rules  Git Git   Bugs Bugs   Docs Docs  Back to: XMB Forum Home Page
XMB Forum Software » Support » XMB Support 1.9.11 » [Resolved] Raw SQL request. Go To Bottom

Printable Version  
Author: Subject: [Resolved] Raw SQL request.
Plastic
Member
***



Posts: 19
Registered: 5-18-2012
Member Is Offline
posted on 8-24-2012 at 04:43 AM Edit Post Reply With Quote
[Resolved] Raw SQL request.

Full Board URL: http://www.heybritneyforums.com
XMB Version: 1.9.11

I want a SQL code to reset all the custom status made by admins to users of the forums.
View user's profile View All Posts By User
lottos
Administrator
********



Posts: 483
Registered: 6-3-2002
Member Is Offline

Mood: pass me a TimTam
posted on 8-24-2012 at 02:13 PM Edit Post Reply With Quote



Backup xmb_members table first, then

update xmb_members set customstatus = '' where customstatus <> '' and status = 'Member'
View user's profile View All Posts By User
Plastic
Member
***



Posts: 19
Registered: 5-18-2012
Member Is Offline
posted on 8-27-2012 at 01:49 AM Edit Post Reply With Quote



Works perfect. :thumbup:
View user's profile View All Posts By User

 XMB Forum Software » Support » XMB Support 1.9.11 » [Resolved] Raw SQL request.   Go To Top

Powered by XMB 1.10.00-alpha (Debug Mode)
XMB Forum Software © 2001-2025 The XMB Group
[Queries: 14] [PHP: 45.3% - SQL: 54.7%]