paintballer.ie
01-03-2010, 03:43 PM
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
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