################################################## #################### 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.
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?
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
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!
Hi, had this hack working for ages. Now started getting this error message:
Quote:
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
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..