adminemail bitfield - vb.org Archive

		vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
adminemail bitfield

Reply

#1

Old

07-09-2006, 03:03 AM

Kirk Y

Kirk Y is offline

Join Date: Apr 2005

Location: Tallahassee, Florida

Posts: 2,604

Благодарил(а): 0 раз(а)

Поблагодарили: 0 раз(а) в 0 сообщениях

Default

adminemail bitfield

Would someone mind posting a query for me that sets a users adminemail to 0? It's bit 5, bitfield 16. I'm still confused with the whole bitfield and sql thing.

Reply With Quote

#2

Old

07-09-2006, 10:07 AM

Paul M

Paul M is offline

Join Date: Sep 2004

Location: Nottingham, UK

Posts: 23,748

Благодарил(а): 0 раз(а)

Поблагодарили: 0 раз(а) в 0 сообщениях

Default

UPDATE user SET options = options - 16 WHERE (options & 16) AND userid = 123

Reply With Quote

#3

Old

07-09-2006, 02:20 PM

Kirk Y

Kirk Y is offline

Join Date: Apr 2005

Location: Tallahassee, Florida

Posts: 2,604

Благодарил(а): 0 раз(а)

Поблагодарили: 0 раз(а) в 0 сообщениях

Default

Thanks Paul.

Reply With Quote

Reply

« Previous Thread | Next Thread »

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 Forum Rules

Forum Jump

All times are GMT. The time now is 10:02 AM.