Previous Thread
Next Thread
Print Thread
Hop To
Joined: Jul 2006
Posts: 62
C
journeyman
OP Offline
journeyman
C
Joined: Jul 2006
Posts: 62
Hi,

I want to change the value for 1 field in a table for all records in that table.

Specifically, in the Forum_permissions table, I think the default for the field ad_island is 0, I want to update every record so that the value for that field is 1.

Which in truth, it should be. Having that value set to one for every group is fine and won't change anything unless you actually designate a post island to be displayed in the forum details side.

Anyway, could someone help me out with the sql statement for that?

Joined: Jul 2006
Posts: 62
C
journeyman
OP Offline
journeyman
C
Joined: Jul 2006
Posts: 62
Bleh, nevermind, got it. I'm a lazy bastard is all tongue

Joined: Apr 2007
Posts: 3,940
SD Offline
Former Developer
Offline
Former Developer
Joined: Apr 2007
Posts: 3,940
SQL Query
UPDATE ubbt_USERS u, ubbt_USER_PROFILE up
SET u.USER_LAZY_BASTARD=1
WHERE u.USER_ID=up.USER_ID
AND up.USER_DISPLAY_NAME='Carte Blanche'

laugh

Joined: Jul 2006
Posts: 62
C
journeyman
OP Offline
journeyman
C
Joined: Jul 2006
Posts: 62
/facepalm so true.


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
IMG Options
by mmem700 - 06/12/2021 10:14 AM
Custom Island database updates
by Pak Chan - 06/09/2021 2:11 PM
PHP 8 support + which php engine is used in IIS?
by luket - 06/08/2021 7:05 AM
7.7.5 Update error
by ECNet - 05/30/2021 8:08 PM
Re: Custom Island Questions
by ECNet - 05/30/2021 5:00 PM
Who's Online Now
1 members (Ruben), 61 guests, and 97 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
gallery test
gallery test
by Mors, September 23
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Powered by UBB.threads™ PHP Forum Software 7.7.5