Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 03 Nov 2001, 10:44
Palmer ofShinra's Avatar
Palmer ofShinra Palmer ofShinra is offline
 
Join Date: Oct 2001
Massive user update...

OK... I've whipped up a custom hack that allows certain users to use [color=] style BBcode in their custom titles, but not HTML (staff can use both though)

Thing is... all the people who are currently allowed BBcoded titles have HTML titles set.

So what I need to do... is to change one database field for over 60 users... and I don't want to do it manually.

All I need to do, in the USER table, is find everyone in usergroup 25 and 26 and change their customtitle value to 3.

Could someone whip me up a quick script to do that?

Or is a mass query possible? Like

UPDATE user SET customtitle=3 WHERE usergroupid=25

And then repeat it for 26.

Would that work?
Reply With Quote
  #2  
Old 03 Nov 2001, 23:22
Mark Hensler's Avatar
Mark Hensler Mark Hensler is offline
 
Join Date: Oct 2001
UPDATE user SET customtitle=3 WHERE usergroupid=25 OR usergroupid=26
Reply With Quote
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Miscellaneous Hacks EPC Massive User Creator :: Using PHP and .NET (ALL SOURCES) blogtorank vBulletin 3.6 Add-ons 61 02 Mar 2011 17:03
[Release - MiniHack] Make update user info update post counts DarkReaper vBulletin 2.x Full Releases 5 19 Jan 2002 05:47



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 16:32.

Layout Options | Width: Wide Color: