Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 12 Jan 2011, 08:29
SnapOff Racing SnapOff Racing is offline
 
Join Date: Apr 2006
Need help with an SQL Query

I am trying to delete all the signatures of every member that is in the banned user group. I have created a select statement that does what I want but now I just need some help creating an UPDATE or DELETE statement.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Thanks in Advance!
Reply With Quote
  #2  
Old 13 Jan 2011, 10:52
SnapOff Racing SnapOff Racing is offline
 
Join Date: Apr 2006
bump^^
Reply With Quote
  #3  
Old 13 Jan 2011, 11:07
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
I haven't tried this, but I think it would be:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

ETA: I did a quick test on a junk db and it seems to work.

Last edited by kh99; 13 Jan 2011 at 11:18.
Reply With Quote
  #4  
Old 13 Jan 2011, 13:18
SnapOff Racing SnapOff Racing is offline
 
Join Date: Apr 2006
Twice in two days! Damn I need to put you on the payroll!

Thanks for your help AGAIN I really appreciate it!
Reply With Quote
  #5  
Old 13 Jan 2011, 14:03
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
I have coded a mod that does that if you don''t want to do it manually.

http://www.vbulletin.org/forum/showthread.php?t=249634
__________________
My mods.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 08:21.

Layout Options | Width: Wide Color: