Add Custom Profile Fields in Postbit

[glennrocksvb]

Glad you figured it out.

The database error seems to be related to something else and not to this mod.

Btw, I removed something from your posted SQL error as you posted too much information.

[poldigit]

Uninstalled the MOD...

Restarted with a fresh install ==> no errors were reported now. Seems to be ok now

[poldigit]

I got database errors! Please help… Problems with posting!

1) with photos

Database error in vBulletin 5.2.2:

Invalid SQL:
INSERT INTO closure (`parent`,`child`,`depth`,`publishdate`)
VALUES(38,38,0,1469506299)
/**closure**/;

MySQL Error : Duplicate entry '38-38' for key 'closure_uniq'
Error Number : 1062
Request Date : Tuesday, July 26th 2016 @ 06:11:39 AM
Error Date : Tuesday, July 26th 2016 @ 06:11:39 AM
Script : http:///forums/create-content/gallery
Referrer : http://wfcfotovisie.be/forums/new-content/19
IP Address : <removed>
Username : <removed>
Classname : vB_Database_MySQLi
MySQL Version : 5.6.23

2) With text only

Database error in vBulletin 5.2.2:

Invalid SQL:
INSERT INTO closure (`parent`,`child`,`depth`,`publishdate`)
VALUES(44,44,0,'1469507583')
/**closure**/;

MySQL Error : Duplicate entry '44-44' for key 'closure_uniq'
Error Number : 1062
Request Date : Tuesday, July 26th 2016 @ 06:33:03 AM
Error Date : Tuesday, July 26th 2016 @ 06:33:03 AM
Script : http:///forums/create-content/text/
Referrer : http://wfcfotovisie.be/forums/new-content/16
IP Address : <removed>
Username : <removed>
Classname : vB_Database_MySQLi
MySQL Version : 5.6.23

[glennrocksvb]

By default, vBulletin 5 only displays the Join Date and Post count in the postbit area (avatar and username section) in the thread view of a topic. There may be other tutorials out there to add custom fields in postbit but some require you to edit the existing postbit template. Editing existing templates is not good for maintenance reasons as you would have to resolve template merge conflicts every time you upgrade. Or some might require you to create a template hook and repeatedly copy/paste template code for adding multiple fields and change instances of profile field variable names. Another maintenance nightmare.

Don't look any further, here's the mod that is simple but rocks! Simply download the zip file, uncompress it and upload the XML in AdminCP > Products & Hooks > Manage Products > [Add/Import Product] and you're good to go. By default, it adds Location and Occupation profile fields. You can configure what profile fields to add in AdminCP > Settings > Options > Custom Profile Fields in Postbit Settings.

As a bonus, the mod also adds "Send PM" link to the postbit to make it easier for users to send a private message to a user while reading a thread. You can also configure that in the Custom Profile Fields in Postbit Settings.

Demo:
Look at the postbit section on this thread.

Upgrade Instructions:
If you are upgrading this mod from an older version, choose Yes in the "Allow Overwrite" radio button when importing the XML file.

Customizations:
To add the existing envelope icon in the default icon sprite image to the Send PM link, add the below custom CSS in css_additional template in AdminCP or in Sitebuilder > Style > CSS Editor.

.send-pm-in-postbit:before {
    content: '';
    width: 15px;
    height: 14px;
    position: relative;
    bottom: -1px;
    background: transparent url('images/css/sprite_icons_vb_ltr.png') no-repeat scroll -16px -176px;
    display: inline-block;
    margin-right: 3px;
}

For dark colored themes, you can use the light colored envelope icon by changing -16px to 0 in the background value above.

[Feb 21, 2022 Update]: The sprite image containing all the icons used in vB5 has changed since this mod was posted. That's why the image icon will not show up using the sprite_icons_vb_ltr.png image path in the above code. To find where the new location of the sprite image file is, right-click any of the icons on your forum and then choose Inspect. Observe the background used and locate the image path inside the "url(" and ")". Copy that path and use it to replace the image path in the above code.

Version History:
v1.1

• Added rel="nofollow" to Send PM link to prevent search engines to follow the link and get Access denied error.

v1.0

• Initial version.

NOTE: With recent updates from vBulletin 5, you can now show profile fields on postbit without a third-party plugin. This is done by setting "Show on Post" to Yes when creating/updating a profile field in the User Profile Field Manager and it will show on postbit.

But if you want to show icons instead of text, then you still need a plugin to do that. I just released new mods for displaying Gender icons and Country Flag icons on postbit.