[Code Modification] 244 Countries Flags with Wiki Links in Postbit

[bigoliver]

...set all users automatically to Undisclosed unless they have selected otherwise.

Run this in phpMyAdmin, replacing X with the actual custom field ID:

UPDATE `mybb_userfields` SET `fidX` = 'Undisclosed' WHERE `fidX` = '';

[/quote]

Hi, thanks for taking the time to reply.

I believe I did this correctly, I went to phpmyadmin, clicked SQL pasted your code (replacing the fid"x" to the correct fid number) but after clicking "Go" it came back with...

0 row(s) affected. ( Query took 0.0005 sec )

I tried changing your code to this...

UPDATE mybb_userfields SET fidX = 'Undisclosed' WHERE fidX = 'N/A';

But that didn't work either.

Any ideas?

Cheers,

Oliver

---

Hi again,

I did a little more searching and found this code...

UPDATE mybb_userfields SET fidx = 'Undisclosed' WHERE fidx IS NULL

changing the x to my fid number.

It worked for me

Hope this helps others