vBulletin Mods

The Official vBulletin Modifications Site

Help with creating a short SQL Quiery Please
by paintballer.ie
03 Jan 2010 16:43

Hey lads, I have the community news letter by Provb but I can not get proper support from them

The installation creates a profile option to subscribe to the community news letter. However this option yes or no are blank by default. I need to run an sql query to set all members to 'yes'.

What I got so far was:

PHP Code:
UPDATE userfield set fieldX = 'yes'

If you have a table prefix, include it. Replace X with the profile field ID Make sure you've double checked what you replaced, otherwise you may change the wrong one
Here is where I am stuck and have not got help. I use the prefix vb_ , so where where to I put this?

Thanks in advance for pointing me in the right direction

051119 03 Jan 2010 17:16

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

paintballer.ie 03 Jan 2010 17:39


All times are GMT. The time now is 00:15.

Powered by vBulletin® Version 3.8.12
Copyright © 2019, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.