CMPS Module: Contributors

[Zachariah]

/* ---------------------------------------------------
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.php?p=483743&postcount=33

I did some personal Mods my self:
https://vborg.vbsupport.ru/showpost.php?p=483914&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

[Sean S]

Thank you, I was actually looking for this for my new site :)

[y2krazy]

You might want to include the contrib_bit template as well... ;)

[Zachariah]

You might want to include the contrib_bit template as well... ;)

Fixed :o

[wanga]

uh, where does it fetch who contributed or not?

[Zachariah]

uh, where does it fetch who contributed or not?

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

[Holidazed]

I am getting a database error when I use this module.

mysql error: Unknown column 'contrib' in 'where clause'

I saw no instructions that said I needed to execute a mysql commmand. Also, how do I add a contributer to the list?

[Holidazed]

NM, you did not say in the instructions that this hack required that the hack at https://vborg.vbsupport.ru/showthread.php?t=61082 (Mark User as Contributor) be installed first.

In addition, when this hack is installed, my portal page has a link to "contributors.php" but your file is named "contrib.php". I renamed it.

When I click on the "Contributors" link, I get an error. It is as follows:

Fatal error: Call to a member function on a non-object in /home/dungeon/public_html/forums/contributors.php on line 28

Help!!

[Zachariah]

NM, you did not say in the instructions that this hack required that the hack at https://vborg.vbsupport.ru/showthread.php?t=61082 (Mark User as Contributor) be installed first.

In addition, when this hack is installed, my portal page has a link to "contributors.php" but your file is named "contrib.php". I renamed it.

When I click on the "Contributors" link, I get an error. It is as follows:

Fatal error: Call to a member function on a non-object in /home/dungeon/public_html/forums/contributors.php on line 28

Help!!

Sorry man - 70 or so add-ons installed :surprised: ... This is a display page.
https://vborg.vbsupport.ru/showpost.php?p=483743&postcount=33

I did some personal Mods my self:
https://vborg.vbsupport.ru/showpost.php?p=483914&postcount=37

Out come
http://www.gzhq.net/forums/contributors.php

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

[HiDeo]

Nice job, thanks

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

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]

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:
$getusers = $DB_site->query("
SELECT userid,username
FROM user
WHERE contrib = '1'
");


With:

$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 :D

[Zachariah]

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

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

[Zachariah]

1.3 Update - Killed 2 extra queries !! :banana: - Updated 1st post.

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

[docvader]

Awesome. But you might want to mention that you need to alter the global php after the second 'adv_portal' mention. I put it after the first mention and it wiped out my index page, lol.

Nice job. My community will like the mentions.

[Zachariah]

Will this work for 3.07? Thanks ;-)

yes.