UltraBB Forums Home 
Home Search search Menu menu Not logged in - Login | Register
UltraBB Forums > UltraBB > Software Assistance > Removing a member from Ignore list?

Welcome to the UltraBB public support forum! Did you know there is an inexpensive totally integrated gallery available for UltraBB? Read more here: Gallery Details

 Moderated by: Jim
New Topic Reply Printer Friendly
Removing a member from Ignore list?  Rate Topic 
AuthorPost
 Posted: Tue Apr 6th, 2010 07:18 pm
  PM Quote Reply
1st Post
wingnutter
Forever Learning


Joined: Wed May 14th, 2008
Location: Ireland
Posts: 1843
Status: 
Offline
Mana: 
User Gallery
For a long time now (since we got the Ignore function), one of my forum members keeps popping up on peoples Ignore list. These members PM me and say they didn't add him and there is no reason why they should, so I believe them. It's just one member all the time appearing on their Ignore.

Is there an SQL query I can do to remove a member from all the other members Ignore lists he is on?

Back To Top PM Quote Reply  

 Posted: Tue Apr 6th, 2010 07:29 pm
  PM Quote Reply
2nd Post
tanygaer
TOIDI


Joined: Mon Jun 16th, 2008
Location: Rhosgadfan, North Wales, United Kingdom
Posts: 2776
Status: 
Online
Mana: 
User Gallery
The short answer is YES, the long answer is :- the ignore member field is a comma separated list of user id's so a replace would need to be done, on a like where clause...

I will have a look in the morning and get you a SQL statement.

Back To Top PM Quote Reply

 Posted: Tue Apr 6th, 2010 07:46 pm
  PM Quote Reply
3rd Post
Devans
License Holder


Joined: Tue May 27th, 2008
Location: Iowa USA
Posts: 1398
Status: 
Offline
Mana: 
User Gallery
I have had the same is with a couple of our members Steve. Problem was, the member never added them to the ignore list and then when he tried to removed them, it would not allow him to remove the member from the ignore list.

Jim done something to clear his ignore list and "so far" I haven't heard that people are added that he didnt add.

Back To Top PM Quote Reply  

 Posted: Tue Apr 6th, 2010 08:01 pm
  PM Quote Reply
4th Post
tanygaer
TOIDI


Joined: Mon Jun 16th, 2008
Location: Rhosgadfan, North Wales, United Kingdom
Posts: 2776
Status: 
Online
Mana: 
User Gallery
this is what you want Steve, you need not adjust it

update wowbb_users set user_ignore = replace(user_ignore, '1998,', '')

Back To Top PM Quote Reply

 Posted: Tue Apr 6th, 2010 11:29 pm
  PM Quote Reply
5th Post
wingnutter
Forever Learning


Joined: Wed May 14th, 2008
Location: Ireland
Posts: 1843
Status: 
Offline
Mana: 
User Gallery
That worked Dave, thanks very much.

Back To Top PM Quote Reply  

 Posted: Tue Apr 6th, 2010 11:33 pm
  PM Quote Reply
6th Post
wingnutter
Forever Learning


Joined: Wed May 14th, 2008
Location: Ireland
Posts: 1843
Status: 
Offline
Mana: 
User Gallery
Devans wrote: ...Problem was, the member never added them to the ignore list and then when he tried to removed them, it would not allow him to remove the member from the ignore list.

Yes that has also happened with us a couple of times, where the member couldn't remove someone from their Ignore list. I went into the dreaded CPanel and manually remove the ignored member. It's a last resort doing that (in case something gets messed up), but it does work.

Dave's SQL will have fixed the problem of old Redwing mysteriously getting onto Ignore lists.

Back To Top PM Quote Reply

Current time is 09:25 am  
UltraBB Forums > UltraBB > Software Assistance > Removing a member from Ignore list? Top



Hosting

UltraBB 1.17 Copyright © 2007-2011 Data 1 Systems, INC.
Page processed in 0.1962 seconds (18% database + 82% PHP). 26 queries executed.