CMPS Module: Contributors

/* ---------------------------------------------------
This is a Module for CMPS to place Contributors in a block. :alien:
Hope it helps !!! Zack - http://www.gzhq.net

NEEDED To Install:

vBadvanced CMPS
https://vborg.vbsupport.ru/showthread.php?t=65797
Coded by: Tigga

Mark User as Contributor [vB3]
https://vborg.vbsupport.ru/showthread.php?t=61082
Coded by: assassingod
Original: MarkB

=== Display page for all Contributors ======

This is a display page. (contributors.php)
https://vborg.vbsupport.ru/showpost....3&postcount=33

I did some personal Mods my self:
https://vborg.vbsupport.ru/showpost....4&postcount=37


--------------------------------------------------*/

11.24.04 - Fixed the code to remove 2 extra queries from uncached templates. (edit global.php) Added ".TABLE_PREFIX." to the contrib.php placed in the Moduel folder.

Edit global.php find:

'adv_portal',

After add:

'contrib_bit',
'adv_portal_contrib',

Upload new contrib.php to Moduel folder

9.13.04 - requested - post 14
Added option for desired number of users to display on block and a link in template to full user list.

Upgrade: replace contrib.php file and adv_portal_contrib template.

7.22.04
Fixed - missing template

[Holidazed]

Very cool. It is working flawlessly. Even with your own personal customizations. Can you write this up and have all those instructions and the image in the first post?

Also, I love that it lists contributors. But I would love to see a way to display what they contributed (a service, money, equipment, etc.)

[Holidazed]

Originally Posted by HarryButt

BTW: Location: Van Nuys, CA -- AKKKKKKKKKKK BUDWEISER HOPS !!!!

I live 5 minutes from the Budweiser plant.

[y2krazy]

/me clicks install!

[Rich]

Hello,
Is there a way that we could have this shows a "more" button like the smilies do? For sites that have a large contribution list,this will look very odd as it lengthens with names. A cut off point of like 5-10 names would be great and then a "more" button/link to display all of them.

[Zachariah]

Originally Posted by iguanairs

Hello,
Is there a way that we could have this shows a "more" button like the smilies do? For sites that have a large contribution list,this will look very odd as it lengthens with names. A cut off point of like 5-10 names would be great and then a "more" button/link to display all of them.

Yes

Edit contrib.php

Find:

// query to get the users who are contributors
	$getusers = $DB_site->query("
		SELECT userid,username
		FROM user
		WHERE contrib = '1'
	");

replace: ( "LIMIT 10" was added. * change to a desired value*)

// query to get the users who are contributors
	$getusers = $DB_site->query("
		SELECT userid,username
		FROM user
		WHERE contrib = '1' LIMIT 10
	");

Edit:
adv_portal_contrib

Find:
$contrib_bit

After add:

<br>[<a href="../forums/contributors.php">more</a>]<br>

That should do it.

[Rich]

Hello,
Thanks for the response! I really appreciate it. I will give this a whirl and see how well it goes. Thanks again.

[Hialls]

Hmm i didn't find where contrib was added while users paid to a subscription...

so i changed the code slightly if anyone else wants it here is what to do..

Replace:

PHP Code:

$getusers = $DB_site->query("
        SELECT userid,username
        FROM user
        WHERE contrib = '1'
    "); 


With:

PHP Code:

$getusers = $DB_site->query("
        SELECT userid,username
        FROM user
        WHERE (usergroupid IN (7) OR CONCAT(',', membergroupids, ',') LIKE '%,7,%')
    "); 


Where 7 is the usergroup users are added to when they subscribe.

[Hialls]

this can also work with multiple usergroups, and ofcourse this way you can add who's a gold/silver/bronze contributor

[Zachariah]

Originally Posted by Hialls

this can also work with multiple usergroups, and ofcourse this way you can add who's a gold/silver/bronze contributor

Nice !!! :speechless:

[twoseven]

 
// query to get the users who are contributors
	$getusers = $DB_site->query("
		SELECT userid,username
		FROM " . TABLE_PREFIX . "user
		WHERE contrib = '1' LIMIT $limit
	");

you forgot the table prefix