Profile Fields in Postbits

Show Profile Fields in Postbits

For German Users goto http://www.vbhacks-germany.com/forum...ead.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
here for 3.6.0 users

Liked it?
How about

[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]

Originally Posted by 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.

Link ?

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

[nicedreams]

Originally Posted by nicedreams

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

PHP Code:

                $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]

Originally Posted by nicedreams

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/new...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]

Originally Posted by redlabour

Did you forget the Tableprefix vb3_ ?

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

PHP Code:

$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