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

This is on install or your homepage after install ?
- If on thr home page and not an Install error in the XML.

1)
Admincp => vBulletin Options => Honorable Member
Change setting
Save

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

The value is set to change your member every 23 hours.
If this is ok.



Notes:
- You can change the time in the Scheduled Task Manager
Admincp => vBulletin Options => Honorable Member

- You can change the settings a member is selected in
Admincp => Scheduled Tasks => Scheduled Task Manager => Honorable Member

[TamCaVBoy3]

Originally Posted by Zachariah

This is on install or your homepage after install ?
- If on thr home page and not an Install error in the XML.

1)
Admincp => vBulletin Options => Honorable Member
Change setting
Save

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

The value is set to change your member every 23 hours.
If this is ok.



Notes:
- You can change the time in the Scheduled Task Manager
Admincp => vBulletin Options => Honorable Member

- You can change the settings a member is selected in
Admincp => Scheduled Tasks => Scheduled Task Manager => Honorable Member

this is after i installed it and set up schedule and everything, then i go to the forum and i recieved that error

[Zachariah]

Originally Posted by TamCaVBoy3

this is after i installed it and set up schedule and everything, then i go to the forum and i recieved that error

Step 2
[RUN NOW]

The script has not run yet. (in 23 hours it will run)
The 1st member has not been selected so there is no data for the hack to show.

[TamCaVBoy3]

awsome !, thank you !

[TamCaVBoy3]

nevermind, when i run the schedule, error:

Database error in vBulletin 3.5.3:

Invalid SQL:

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

FROM unique_user AS user
LEFT JOIN unique_honorable AS honorable on (user.userid=honorable.userid)
LEFT JOIN unique_userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN unique_usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

WHERE
usergroupid NOT in ()
AND user.posts >= 0
AND lastactivity >= 1138229114
AND lastpost >= 1138229114
AND user.reputation >= 0
AND (honorable.dateline < 1137624314 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 >= 0
AND lastactivity >= 1138229114

Error Number : 1064

[Zachariah]

I ran into a few problems if values were blank in AdminCP vs. "0" Zerro.
- Things i'll iron out. "if blank skip ect ..."

Take a look if you would and give me a heads up.

[Zachariah]

Install readme were fixed up a bit.
- No code changes yet.

[sinaluna]

Thank you for the help Zachariah!

[TamCaVBoy3]

thanks for the fix, i will try to install for the last time

[Boofo]

Can this be made to not use the avatar as a setting?