Miscellaneous Hacks - Mark User as Contributor

Mark User as Contributor
(By Boofo)

Original vB 3 version: assassingod

Thanks to assassingod for allowing me to port his hack to vBulletin 3.5 RC 2 and creating the original hack. And to Revan for teaching me about product management.

// Description:
This allows you as an Administrator to mark users if they have donated to your web site. The setting in in the Admin CP profile for each user.

You can use text/icon, whatever you want by editing the phrase. It appears in the postbit and the user's profile.

[VMB]

How would I get the contributor title to show up above avatars on the postbit_legacy?

[brvheart]

any chance for this on 3.6.x? I sure hope so

[phpdevrus]

yep would definitely be great for 3.6.x :-)

[spaghie]

It worked for me on 3.6.1! thanks.

[brvheart]

sweet thank you

[Sax on the Web]

Got following error message. What am I doing wrong?

There seems to have been a problem with the The Sax on the Web Forum database.
Please try again by clicking the Refresh button in your web browser.

An E-Mail has been dispatched to our Technical Staff, whom you can also contact if the problem persists.
We apologise for any inconvenience.

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT `userid`, `username`, `usergroupid`, `displaygroupid`
FROM `user`
WHERE `contrib` = '1';

MySQL Error : Unknown column 'contrib' in 'where clause'
Error Number : 1054
Date : Friday, December 8th 2006 @ 11:41:05 AM
Script : http://forum.saxontheweb.net/contributors.php
Referrer :
IP Address : 84.249.42.17
Username : Harri Rautiainen
Classname : vB_Database

[MrPHD]

Great job. Thanks and installed

[BuRNZau]

I have an old database and I wanted to know if I can use phpMyAdmin to list all my users in the database marked as contributors?

[ozmazdaclub]

Originally Posted by Zachariah

Try:
<a href="$vboptions[bburl]/contributors.php">$vbphrase[contribs]</a>

between worlds - Have you tried that?