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?

[mholtum]

Database error in vBulletin 3.5.3:

Invalid SQL:
SELECT dateline, userid FROM vb353_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
Date : Thursday, February 16th 2006 @ 09:41:23 AM
Script : http://www.fshfanatic.com/
Referrer :
IP Address : 70.162.7.101
Username : mholtum
Classname : vb_database

[Zachariah]

Originally Posted by mholtum

SELECT dateline, userid FROM vb353_customavatar WHERE userid =;

No Honorable Member ID.

Admincp => Scheduled Tasks => Scheduled Task Manager => Honorable Member
[RUN NOW]

[mholtum]

Originally Posted by Zachariah

No Honorable Member ID.

Admincp => Scheduled Tasks => Scheduled Task Manager => Honorable Member
[RUN NOW]

Not sure what I am supposed to do. Could you elaborate?

Ok I am installing it on another board and so far so good. I did the forumhome and CMPS version. Works great on the forumhome, but when I hit the portal I get

Database error in vBulletin 3.5.3:

Invalid SQL:
SELECT dateline, userid FROM vb3_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
Date : Thursday, February 16th 2006 @ 11:20:36 AM
Script : http://www.theflyfishingforum.com/?
Referrer : http://www.theflyfishingforum.com/forums/index.php?
IP Address : 70.162.7.101
Username : fshfanatic
Classname : vb_database

[MR-2ZZ]

this isnt working with 3.5.4

[Tyegurl]

can you make work please????? i have 3.5.4 too and am interested in it

[yinyang]

is there an option, and if there isn't can it easily be done, where you can designate the member instead of it being randomly chosen?

[Oddjob]

Originally Posted by MR-2ZZ

this isnt working with 3.5.4

Glad i read that b4 installing, thanks.

[Zachariah]

Havent had time to try in 3.5.4, but I do not see a reason why it should not work.

[vinston vega]

I don't know what I've done wrong, but it is not showing the users avatar.

Can anyone help me?

[GamerJunk.net]

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT dateline, userid FROM vb3_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
Date : Wednesday, March 22nd 2006 @ 07:36:39 PM

Damn it this thing never works