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?

I am very busy @ the moment.
I will pop in and out of this hack @ odd times w/ Add-Ons and support.

Responce Time: 1-2 days

:rambo:


FAQ:

Q: Why don't the member's info update on the hack after selected ?
A: All the info is cached when the selection process is done. Updates to the member will not update untill they are selected again.

* How to move location of the FORUMHOME
* Place the block where you want on the FORUMHOME

Add-ons:
Soon

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

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

Template options:

forumhome_honorable
adv_portal_honorable

- $mday[userid] - User ID
- $mday[username] - Username
- $mday[usertitle] - Usergroup name
- $mday[birthday] - Date of B-Day
- $mday[age] - Age
- $mday[reputation] - User reputation
- $mday[posts] - Post count
- $mday[forumid] - Fav. forum ID
- $mday[forumname] - Fav. forum name
- $mday[fieldX] - X = profile Field # you wish to show up
- $mday[icq] , $mday[yahoo], $mday[aim], $mday[scype] - IM data
- $mday[styleid] - Style ID
- Many more (I'll list them later)

Everything about the person in tables:
- user
- userfield
- usertextfield

$mday[fieldname]

this looks really cool, ill take a look at this later on :D

How to move location of the FORUMHOME.

To make it a hackless install (no template edits) this places a template on a unique "anchor" within the FORUMHOME template.

This says SEARCH for $navbar in template FORUMHOME and place template "forumhome_honorable" after.

Edit Plugin: Honorable Member: Forumhome

Find:
Change $navbar to where you wish to place the hack.

Anchor spots: (this will place in FORUMHOME)
$header - Above the Navbar
$navbar - Below the Navbar
<!-- what's going on box --> - Above what's going on box.
<!-- end what's going on box --> - Below what's going on box.

Many others explore :squareeyed: :D
(text / comment that is different than anything else in the template.)

Place the block where you want

You will want to edit the forumhome template and place the block where you want vs. use an anchor:

Edit plugin: Honorable Member: Forumhome
Replace:
with

Edit FORUMHOME: Place in location of choice.

Thank you for releasing a great hack such as this one! :D

thank you!!

I've been waiting for this, can't wait to install it.

I think for starters, it would be easier if you broke the install details up completely, one set for if it is used without CMPS, and one set for if it is with CMPS. It's hard for me to pick out the differences.

Also, need to know about the other files - I assume we are uploading them into the proper directories, but you may just want to add that in as a step..

Going to try and install now and see how it goes :)

Ya it's a mess :D
- Was burning some midnight oil.
- I'll break it up. (day or so)
- It's like the directions for for putting your kids new bike together @ the moment. :tired:

I got it on the first try but I had to check my edits and read the installations instructions many times... LOL! Agreed Instructions needs refining but great job.

Great hack! Thanks! :)

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

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)

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

THANKS!!!!

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?

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

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:

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

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'

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

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.

awsome !, thank you !

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

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.

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

Thank you for the help Zachariah! :)

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

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

- Sure boss. I'll add as a AdminCP setting on next ver.

Look at this, it broke my forum, and I didnt' back up my site, and then my house cuaght fire. Its all your fualt!!!!!!

Nah, just kidding, awesome product, think I'm going to install it right now.

Great! Let me know when you do it, please. ;)

ouch.. what did I do wrong..

Fixed :D
- In your case you have the CMPS sideblock embeded into your FORUMHOME.

Fix:
- Edit forums/index.php And cmps_index.php and add file edit.

You can then use the CMPS (only) XML install file if you want only CMPS block not and not show on FORUMHOME.

Thank you.. you rock !

This is great!

Just had a simple question, I have this on my CMPS page, in the center block.
Is there a way to make the font a little bigger? Maybe bold?

I just want the member of the week to stand out a little more.

Thanks

Yes.. in the template adv_portal_honorable you can add things and change fonts etc

Great Thanks!

THANK GOD DUDE, cuase I was about to go WTF. But i got it working, glad someone else had that problem and you fixed it. Good work Zach. See ya on IM.