MyBB Community Forums

(2011-03-18, 07:46 PM)bigoliver Wrote: [ -> ]...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

Been playing around with the alignment of the flag. I have found that using:

<img src="images/flags/{$post['fid31']}.png" ALIGN=ABSBOTTOM ></a>

Looks a little better then using:

<img src="images/flags/{$post['fidX']}.png" ALIGN=ABSMIDDLE></a> 

But have a play and decide which looks best for you.

Thanks for mycode

My doesnt show up... :L

(2011-03-18, 08:30 PM)AJS Wrote: [ -> ]{$userfields['fidX']}

Thank you so much for the assistance AJS.

i

(2011-02-13, 02:32 AM)Sammyed Wrote: [ -> ]

(2011-02-13, 12:57 AM)pinguy Wrote: [ -> ]If it is showing the X its because you forgot to remove the X and add the ID number for the fid

LMAO

I wish I did that.

But no, what I did @ postbit template was:

Quote:<strong><span class="largetext">{$post['profilelink']}</span></strong> <img src="images/flags/{$post['fid10']}.png" ALIGN=ABSMIDDLE></img>

Works good.

What I did for memberlist page @ memberlist_user template was:

Quote:<td class="{$alt_bg}">{$user['profilelink']} <img src="images/flags/{$user['fid10']}.png" ALIGN=ABSMIDDLE></img><br />

Works good

Now as for profile page @ member_profile template:

Quote:<span class="largetext"><strong>{$formattedname}</strong> <img src="images/flags/{$memprofile['fid10']}.png" ALIGN=ABSMIDDLE></img><br /></span><br />

A red X right after the forum member. , and when I get the properties to that red X image it says: "/images/flags/.png".

If the variable, in this case, is not $memprofile .Then what I should try with?. I already tried with $user, $profilefield, and some others LOL with no luck.

Thanks for replying Pinguy.

Cheers.

i tried it working but if we put ".png" we can get the image we want to put the Flag name here then it working.it produce bug because it can't change to members choice..how can we made it work it as members selected country

I don´t understand, it works with users or members selected countries. You must upload all the flags given by Pinguy in the "images/flags/" directory and follow his instructions.

i did but .png is not working if i enter a country flag name in .png place it will work but we can't change it as our need to different countries

It's cool just if we force users on registration to write their provenience, or are they already forced?

it's not works

I paste this code

Quote:<a target="blank" href="http://en.wikipedia.org/wiki/Especial:Search?search={$post['fidX']}&fulltext=&go=Go" title="Look up {$post['fidX']} on wikipedia"
style="cursor:help;" class="wiki"><img src="images/flags/{$post['fid5']}.png" ALIGN=ABSMIDDLE></a>

below this code

Quote:<strong><span class="largetext">{$post['profilelink']}</span></strong> [Place Flag Postbit Code Here]