Profile Fields in Postbits

[emin3m]

Show Profile Fields in Postbits

For German Users goto http://www.vbhacks-germany.com/forum/showthread.php?t=3236

Features
1. Shows Profile fields in the postbits.
2. Dosent shows if field is blank.
3. Admin can set which profile field to show and in which order.
4. Admin can set where to show under posts by user or under username NEW

Why Use it
As am running my university forums so, setting "roll no" (student-id-no) in postbit made easy to recognize ppl posting..
you can add fields like "Favourite music", "Favourite movie", "Favourite book" and add them in postbits..

REFERSH THE ADMIN PANEL AFTER INSTALLING IT

there might be such plugin b4 but am unable to find it,, is it?
Works on all 3.5.x .....
and on 3.6.0 special thanks to nicedreams (https://vborg.vbsupport.ru/member.php?u=73247)
here for 3.6.0 users (https://vborg.vbsupport.ru/showthread.php?t=123619)

Liked it?
How about https://vborg.vbsupport.ru/external/2010/02/12.gif (https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=hasnat.ullah%40gmail%2ecom&item_name=Profile_Post_Bits&item_number=1&no_shipping=1&return=http%3a%2f%2fwww%2evbulletin%2eorg&cancel_return=http%3a%2f%2fwww%2evbulletin%2eorg&no_note=1&tax=0&currency_code=USD&bn=PP%2dDonationsBF&charset=UTF%2d8)

[Rickie3]

thats brilliant thanx *installed*

[Daniel]

Great idea!

[jugo]

This is one of those, "Why didn't I think of that?" Plugins.

Great job.

[Reeve of shinra]

Good stuff :)

[Floris]

Very cool, I would re-design the postbit template a bit to use the space a bit smarter, but thank you for sharin this great tweak - I might just use this on my vb fans sites :D

[Neosoul]

I was wondering is there anyway to get them to show up in your signature?..

[offsidex]

sorry but how do activate it ? I have just installed it but I can see it's settings anywhere.

would appreciate some help on this and thank you for the great work.

[offsidex]

sorry my bad, sorted now!

[rnmcd]

Very cool, I would re-design the postbit template a bit to use the space a bit smarter, but thank you for sharin this great tweak - I might just use this on my vb fans sites :D
I second that suggestion!

It would be nice to have the option to choose where to display the fields in the postbit. For example:

left-side (under username)

right-side

[amizone143]

excellent well i click install :nervous:

[emin3m]

I second that suggestion!

It would be nice to have the option to choose where to display the fields in the postbit. For example:

left-side (under username)
center
right-side


ill add this if i update it!

[Developer]

great hack :) installed

[rnmcd]

Emin3m, did you update this hack since the original? If so, what changes did you make?

[emin3m]

Emin3m, did you update this hack since the original? If so, what changes did you make?

this is same as one i provided you before

[GamerJunk.net]

does this work for postbit_legacy also?

[emin3m]

does this work for postbit_legacy also?

never tested

[rnmcd]

Emin3m, what is that text in the image below? Is it a profile field?

Thanks!!!

[emin3m]

Emin3m, what is that text in the image below? Is it a profile field?

Thanks!!!

its known as "Custom User Title" can be set by usercp, if allowed by admin

[rnmcd]

Then what is "Forum's Super Mod" (as seen in your first image)? Isn't that a user title?

[rasp187]

does this work for postbit_legacy also?

Yes it does.

[emin3m]

Then what is "Forum's Super Mod" (as seen in your first image)? Isn't that a user title?

thats by user rank

[ShadowOne]

This Doesnt Work If You Have Tables In Your Postbit....Nice Hack Though...

[bplinson]

Installed and works great! My users have been asking for this!

[BabyNameAddict]

What should I enter for Product and Hook Location?

[emin3m]

What should I enter for Product and Hook Location?

press upload leave other fields blank!
press "upload" not "save"

[BabyNameAddict]

Ah! I thought this was a plug-in. I guess it's a product ;)

[BabyNameAddict]

Beautiful!

Is there a way to edit WHERE in the postbit it will show? Something is showing on the bottom and I want it on the top.

Thanks :nervous:

[FudgeBalls2002]

It doesn't work for the multiple selection ones, it just shows a number instead of the options.

[Nathan2006]

Just what I've been looking for :)

Thank you:D

Install

[heynurse]

Great Hack,

But I got one problem, one of my profile fields that is a multiple choice list, and for some reason the optin is not showing up properly in the post bit. It is showing a number instead of one of the correct options. I have screen shots of my user profile fielld options and screen of the post bits showing the numbers? Any idea how to fix this so it shows the correct option?

I have a country field that works fine with this hack, but that is a text box option, not multiple choice box. Any ideas?

[rnmcd]

I think that you set up your multiple choice as a multiple selection? Is that they way you wanted it?

[heynurse]

ya, it is possible that a member could be two options. Is that what might be messing it up?

I wonder if I change the settings now, would it mess up everyones profile?

[nicedreams]

I think that you set up your multiple choice as a multiple selection? Is that they way you wanted it?

I was able to change the plugin to allow multiple selection checkboxes and show all the values and not the number value. Here's the code I used in the PB - Postbits plugin under postbit_display_complete.
find:
$Query = "select title from ".TABLE_PREFIX."profilefield where profilefieldid=".substr($value, 5);
change to:
$Query = "select title, type, profilefieldid from ".TABLE_PREFIX."profilefield where profilefieldid=".substr($value, 5);
find:
$row2=$GLOBALS['vbulletin']->db->query_first($Query);
add below:
if ($row2[type] == 'checkbox')
{
if ($row2[profilefieldid] == 15)
{
$fieldvalue = '';
if ($post[$value] & 1){$fieldvalue = 'A ';}
if ($post[$value] & 2){if ($fieldvalue != ''){$fieldvalue .= ', ';}$fieldvalue .= 'I ';}
if ($post[$value] & 4){if ($fieldvalue != ''){$fieldvalue .= ', ';}$fieldvalue .= 'C ';}
if ($post[$value] & 8){if ($fieldvalue != ''){$fieldvalue .= ', ';}$fieldvalue .= 'F ';}
if ($post[$value] & 16){if ($fieldvalue != ''){$fieldvalue .= ', ';}$fieldvalue .= 'D ';}
if ($post[$value] & 32){if ($fieldvalue != ''){$fieldvalue .= ', ';}$fieldvalue .= 'S ';}
if ($post[$value] & 64){if ($fieldvalue != ''){$fieldvalue .= ', ';}$fieldvalue .= 'H ';}
if ($post[$value] & 128){if ($fieldvalue != ''){$fieldvalue .= ', ';}$fieldvalue .= 'N ';}
if ($fieldvalue != ''){$post[$value] = $fieldvalue;}
}
if ($row2[profilefieldid] == 19)
{
$fieldvalue = '';
if ($post[$value] & 1){$fieldvalue = 'A ';}
if ($post[$value] & 2){if ($fieldvalue != ''){$fieldvalue .= ', ';}$fieldvalue .= 'S ';}
if ($post[$value] & 4){if ($fieldvalue != ''){$fieldvalue .= ', ';}$fieldvalue .= 'D ';}
if ($post[$value] & 8){if ($fieldvalue != ''){$fieldvalue .= ', ';}$fieldvalue .= 'S ';}
if ($post[$value] & 16){if ($fieldvalue != ''){$fieldvalue .= ', ';}$fieldvalue .= 'I ';}
if ($post[$value] & 32){if ($fieldvalue != ''){$fieldvalue .= ', ';}$fieldvalue .= 'C ';}
if ($post[$value] & 64){if ($fieldvalue != ''){$fieldvalue .= ', ';}$fieldvalue .= 'M ';}
if ($post[$value] & 128){if ($fieldvalue != ''){$fieldvalue .= ', ';}$fieldvalue .= 'M ';}
if ($post[$value] & 256){if ($fieldvalue != ''){$fieldvalue .= ', ';}$fieldvalue .= 'O ';}
if ($fieldvalue != ''){$post[$value] = $fieldvalue;}
}
}

I had to hardcode the field values for each multiple selection box. So the above example is for 2 of them. The 15 and 19 values are the profile field ids(field15 & field19). You would change those to your field ids.

Jim

[heynurse]

Thanks, I'll give that a shot!!! and let you know how it goes :) Thanks

[unknowngiver]

can i modify it 2 a link
so its like
CLICK HERE 2 GO TO _____
n then the field's stuff is a link...instead of showing the whole URL...

[rnmcd]

ya, it is possible that a member could be two options. Is that what might be messing it up?

I wonder if I change the settings now, would it mess up everyones profile?
I have read that multiple selections can cause this problem with displaying profile fields in postbits when using this hack or not. I'm sure I've read a way to fix it but, I think, the fix was on vbulletin.com

[Lost_Prophet]

I'm using the Collapsible Postbit (postbit legacy) and this doesn't work for me :(

[kushtiUK]

I would like to put a line-break between the start and end of the displayed fields as it falls to close to the data above and below - also to make it bold would be handy - anyone know how?

[Krose]

my members just asked me to add more info in their postbit..this is the one
i really needed..thanx for this nice hack..*clicked install*

[dirtycrow]

just updated to new version. when i click update the field "show in Postbit under username" goes blank and changes are not saved.

[emin3m]

just updated to new version. when i click update the field "show in Postbit under username" goes blank and changes are not saved.
uninstall previous version
install new version
refresh your admin panel
try then
weird error btw

[jazde86]

Hey, why you don't have the version number increased?

Is it possible to change the order of fields? I mean the begin of the manuelly fields.

[IceBurn3000]

uninstall previous version
install new version
refresh your admin panel
try then
weird error btw
I had the same problem, attempted to do this, but when I tried to unininstall the product i got this error:

Database error in vBulletin 3.5.4:

Invalid SQL:
delete from vBb_datastore where title='showinpostbit' title='showunderus';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'title='showunderus'' at line 1
Error Number : 1064

[jazde86]

Overwrite the new version, with the old code - than the uninstallation works.

[emin3m]

those having problem while uninstalling product, please goto edit product and change the uninstall code to this
$Query = "delete from ".TABLE_PREFIX."datastore where title='showinpostbit' or title='showunderus'";
$Query_Res=$vbulletin->db->query($Query);

then save and uninstall this product
download new and install it
sorry about this :knockedout:

[Reeftanksonline]

I cant get mine working and also I get an error to uninstall it.

[snakes1100]

Thanx....

[bada_bing]

Does this work for vb 3.5.4 ?

[jazde86]

Sure, it works well on vB 3.5.4. Most Plugins for 3.5.x are going well on it.

[bada_bing]

Great Hack.. Clicked install

[Hiranmanu]

Superb hack, been trying to find out how to do this.

Thanks alot keep up the good work

Clicked install

[Reolien01]

In the 1st image it shows up top "Show profile fields in Postbits". I don't even have that menu in my admincp. All i have is the User profile fields.

In summary, I can make new fields, delete and edit them, but I cannot set which will be shows in the postbit. Can anyone help?

[dlan]

So any update on Multiple-Selection Checkboxs?

[redlabour]

Will it work in the Future with vBulletin 3.6 (http://www.vbulletin.com/forum/showthread.php?t=187654) ?

[gsipromotions]

Very kewl, I like this one.

Anyone know how I can make a new field text display as a clickable link?

[redlabour]

This Product does not work with 3.6. Will there be a Update soon ?

Invalid SQL:
select title from vb3_profilefield where profilefieldid=2;

MySQL-Fehler : Unknown column 'title' in 'field list'
Fehler-Nr. : 1054

[redlabour]

Anybody out there ? ;)

[redlabour]

Invalid SQL:
select title from vb3_profilefield where profilefieldid=2;

MySQL-Fehler : Unknown column 'title' in 'field list'
Fehler-Nr. : 1054

Can nobody else fix this for 3.6 ?

[nicedreams]

Can nobody else fix this for 3.6 ?

I fixed it for 3.6.0. This is what I did:

$Query = "select type, profilefieldid from ".TABLE_PREFIX."profilefield where profilefieldid=".substr($value, 5);
$row2=$GLOBALS['vbulletin']->db->query_first($Query);

$phrasefield = "field".$row2[profilefieldid]."_title";
$wherephrase = " varname LIKE '$phrasefield' LIMIT 1";
$Query2 = "select text FROM phrase WHERE" . $wherephrase;
$custom_titles=$GLOBALS['vbulletin']->db->query_first($Query2);

$this->post['posts']=$this->post['posts'].'</div><div><strong>' . $custom_titles['text'] . ':</strong> '.$this->post[$value];


Changed the query line by dropping the title. Added the 4 lines to get the title of the custom field from the phrases.

Jimmy

[Wired1]

This is similar to my dropdown hack that I created before this one existed, in October 2005. Mine doesn't require an additional SQL table, although it does require another hack I did, as well as some manual editing.

[redlabour]

This is similar to my dropdown hack that I created before this one existed, in October 2005. Mine doesn't require an additional SQL table, although it does require another hack I did, as well as some manual editing.

Link ?

And is this a Answer to get this work for 3.6 ? :cross-eyed:

[nicedreams]

I fixed it for 3.6.0. This is what I did:

$Query = "select type, profilefieldid from ".TABLE_PREFIX."profilefield where profilefieldid=".substr($value, 5);
$row2=$GLOBALS['vbulletin']->db->query_first($Query);

$phrasefield = "field".$row2[profilefieldid]."_title";
$wherephrase = " varname LIKE '$phrasefield' LIMIT 1";
$Query2 = "select text FROM phrase WHERE" . $wherephrase;
$custom_titles=$GLOBALS['vbulletin']->db->query_first($Query2);

$this->post['posts']=$this->post['posts'].'</div><div><strong>' . $custom_titles['text'] . ':</strong> '.$this->post[$value];


Changed the query line by dropping the title. Added the 4 lines to get the title of the custom field from the phrases.

Jimmy

Forgot to mention this is in the PB - Postbits plugin code under plugins.

[redlabour]

Sorry but i have to "search for" and "replace it with" in the *.xml ?

[redlabour]

Forgot to mention this is in the PB - Postbits plugin code under plugins.

Does not work :

Datenbankfehler in vBulletin 3.6.0:

Invalid SQL:
select text FROM phrase WHERE varname LIKE 'field2_title' LIMIT 1;

MySQL-Fehler : Table 'usrdb_poltbofu.phrase' doesn't exist
Fehler-Nr. : 1146
Datum : Thursday, August 10th 2006 @ 10:38:07 PM
Skript : http://www.politikstube.de/forum/showthread.php?p=48675
Referrer : http://www.politikstube.de/forum/newthread.php?do=newthread&f=34
IP-Adresse : 88.130.109.124
Benutzername : redlabour
Klassenname : vb_database

Here is the edited code :

<title>PB - Postbits</title>
<hookname>postbit_display_complete</hookname>
−
<phpcode>
$Query = "select data from ".TABLE_PREFIX."datastore where title='showinpostbit'";
$row=$GLOBALS['vbulletin']->db->query_first($Query);
$toshow=explode(',',$row['data']);
foreach($toshow as $value){
if($this->post[$value]!=''){
$Query = "select type, profilefieldid from ".TABLE_PREFIX."profilefield where profilefieldid=".substr($value, 5);
$row2=$GLOBALS['vbulletin']->db->query_first($Query);

$phrasefield = "field".$row2[profilefieldid]."_title";
$wherephrase = " varname LIKE '$phrasefield' LIMIT 1";
$Query2 = "select text FROM phrase WHERE" . $wherephrase;
$custom_titles=$GLOBALS['vbulletin']->db->query_first($Query2);

$this->post['posts']=$this->post['posts'].'</div><div><strong>' . $custom_titles['text'] . ':</strong> '.$this->post[$value];
}
}
$Query = "select data from ".TABLE_PREFIX."datastore where title='showunderus'";
$row=$GLOBALS['vbulletin']->db->query_first($Query);
$toshow=explode(',',$row['data']);
foreach($toshow as $value){
if($this->post[$value]!=''){
$Query = "select title from ".TABLE_PREFIX."profilefield where profilefieldid=".substr($value, 5);
$row2=$GLOBALS['vbulletin']->db->query_first($Query);
$this->post['rank']=$this->post['rank'].'</div><div class="smallfont">'.$row2[title].': '.$this->post[$value];
}
}

Did you forget the Tableprefix vb3_ ?

[nicedreams]

Did you forget the Tableprefix vb3_ ?


I don't have a table prefix. But change the line to:

$Query2 = "select text FROM ".TABLE_PREFIX."phrase WHERE" . $wherephrase;

[emin3m]

thanks nicedreams,
added the 3.6.0 version here
https://vborg.vbsupport.ru/showthread.php?t=123619