Honorable Member

Honorable Member 1.0 - (day / week /month / year)

Cerdits: Vb 3.0x Ver
Rigel Kentaurus (http://www.cemzoo.com)

Redesign:
Zachariah (http://www.gzhq.net)

################################################## ####################

This hack lets you "elect" @ random a Honorable Member.

The member is someone randomly picked from all the users in
your forum that met a certain criteria.

By default it appers in top of the forumhome. It is a nice way for members
of the forum to get to know each other.

DEMO - CMPS Block: Honorable Member

################################################## ####################
There is 2 Options to this Hack:
- Forumhome and/or CMPS
- CMPS (only)
- Do not install both XML files.

================================================== =====
1 Query added to page load.

File edit: 1-2
Upload: 1-2 file
Add: 1-2 templates
Plugins: 0-2

Tested on:
- vBulletin 3.5.3
- vBadvanced CMPS v2.0.0 (vB 3.5)
- PhotoPost vBGallery v1.0.1 (vB 3.5) - add-ons soon
================================================== =====


Shows: (At the moment)
- Member Name
- Avatar
- Post Count w/ link to show all posts
- Reputation Count
- Age
- Most active forum w/ link (forum the member posts in the most)

Options: (At the moment)
- Minimum posts that the user must have
- The user must had logged in the forum in the last x days
- The user must had posted in the forum in the last x days
- Minimum reputation the user must have
- If a user is elected he cannot be elected again in this number of days
- Your private or hidden forums so they are not shown in the "favorite forum"

To Do's:
- BBCodes
- Smiles
- Photopost vBGallery (links to Images and posts)
- Photopost other 3 products (links)
- VBPortal Block
- VBA Links (links ot submited)
- Any others?

[Zachariah]

Originally Posted by sduckie2k5

Any plan on updating this for 3.6.4? I tried running this on my board and even after running the cron, I still received errors very similar to those here. Would love to use this one. Thanks!

plans yes

[Mr Morningstarr]

Hi, had this hack working for ages. Now started getting this error message:

Database error in vBulletin 3.6.0:

Invalid SQL:

SELECT user.*,userfield.*,usertextfield.*

FROM user AS user
LEFT JOIN honorable AS honorable ON(user.userid=honorable.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

WHERE
usergroupid NOT in ()
AND user.posts >= 1
AND lastactivity >= 1165076691
AND lastpost >= 1165076691
AND user.reputation >= 0
AND (honorable.dateline < 1167063891 OR honorable.dateline IS NULL)
ORDER BY RAND()
LIMIT 1;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND user.posts >= 1
AND lastactivity >= 1165076691

Any suggestions?

[ngocha85]

Not working with 3.5.4 & 3.6.x!

[SimplyBen]

This would definitely be in use for 3.6. Hope your considering it :]

[BreeBears]

CMPS v2.2.1 | vBulletin 3.6.5 (using on CMPS page) Works great, thanks soo much!!

Always -Bree

[Mrdby]

3.6.7? And The Latest Version Of Cmps?

[Zachariah]

I have this on the drawing board for re-design. I'll see about some updates in the 3.6.x section.

[jilly]

Originally Posted by Zachariah

I have this on the drawing board for re-design. I'll see about some updates in the 3.6.x section.

It's a great, GREAT hack, and I would love to see the ability to have more than one 'honorable member' of the day so that multiple instances could be used at the same time on forumhome.... For example, I'd like to be able to have the regular honorable member at the top, then I'd like to pull a random member from my mod/admin team, and have them show up as 'Valued Volunteer' of the day by the honorable member, to help recognize my hard-working staff, and who knows, maybe even a 'newbie' of the day, or an 'oldie' of the day, etc..

[Rickeo]

love it

[Ingmar]

Fantastic work Zachariah!

CMPS v3.0 RC1 and vB v3.6.7 notes:

• Missing the TABLE_PREFIX in the CREATE TABLE query on line 10 of the CMPS XML file.
• Apparently there is no longer a $vbphrase[member] phrase var name in 3.6.7.
• Had to add the Scheduled Task manually.

Really minor stuff really...

Fantastic work though Zachariah! Thank you!