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?

[sinaluna]

Great hack! Thanks!

[Zia]

Dear Zachariah ..

The idea is TOO KOOL..hope it will help us a lot

in our bord we are using "Best Thread Author For Month"/Best Poster Of The Month/
Arcade King/ etc etc

Regarding :Best Thread Author & Best Poster
hope can we impliment this hack with this idea..

can u plz provide that? That this Module will show 3 or 4 honorable member randomly or scrolling on cmps ?

Thankx...it would be really appriciatebale.

Thankx

[sinaluna]

Is there a way to disable the display of age and reputation?

Thanks!

[Zachariah]

Originally Posted by sinaluna

Is there a way to disable the display of age and reputation?

Thanks!

$mday[age]
$mday[reputation]

Template options: (Add / Remove)
https://vborg.vbsupport.ru/showpost....85&postcount=2


Templates:
forumhome_honorable (forumhome)
adv_portal_honorable (CMPS portal)

[jilly]

Got it working, it looks great! I love the settings in the admincp instead of having to edit a file
Excellent job Zachariah!!

THANKS!!!!

[jilly]

I tried to add joindate, and got an error message - well, not error message but the join date came out as like 8 numbers. Any hints on how to add join date?

[jilly]

Can this be coded so that only logged in members can see it?
I don't want guests etc to be able to see this info..

[Zachariah]

Hello,

I got some extra time to work on the readme.txt and more refinement today of the outputs. Later on I'll post updates.

@Jilly
- CMPS disable the Block from being seen by that usergroup.
- Forumhome

Edit: forumhome_honorable (template)

Wrap around the content:

<if condition="$bbuserinfo[userid]">
Content of template
</if>

[TamCaVBoy3]

installed it on a fresh 3.5.3 and cobaltx skin

Database error in vBulletin 3.5.3:

Invalid SQL:
SELECT dateline, userid FROM customavatar WHERE userid =;

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 '' at line 1
Error Number : 1064

[mariannet]

I get the following da error:

Invalid SQL:

SELECT thread.forumid,forum.title,count(*) total
FROM post AS post
INNER JOIN thread AS thread ON post.threadid=thread.threadid
INNER JOIN forum AS forum ON forum.forumid=thread.forumid
WHERE
post.userid='152'
AND forum.forumid NOT IN (42,4,5,700,586,)
group by thread.forumid
order by total desc 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 ')
group by thread.forumid
order by total desc limit 1'