Honorable Member

[Zachariah]

Honorable Member 1.0 - (day / week /month / year)

Cerdits: Vb 3.0x Ver (https://vborg.vbsupport.ru/showthread.php?t=60368)
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 (http://www.gzhq.net/index.php?page=Hacks) - 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]

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 (https://vborg.vbsupport.ru/showpost.php?p=881107&postcount=4)
* Place the block where you want on the FORUMHOME (https://vborg.vbsupport.ru/showpost.php?p=881135&postcount=5)

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]

[The Chief]

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

[Zachariah]

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.


$search_text = '$navbar';
$vbulletin->templatecache['FORUMHOME'] = str_replace($search_text,
$search_text.fetch_template('forumhome_honorable') ,$vbulletin->templatecache['FORUMHOME']);


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

Edit Plugin: Honorable Member: Forumhome

Find:
$search_text = '$navbar';

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

[Zachariah]

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:

$search_text = '$navbar';
$vbulletin->templatecache['FORUMHOME'] = str_replace($search_text,
$search_text.fetch_template('forumhome_honorable') ,$vbulletin->templatecache['FORUMHOME']);


with

eval('$honorable = "' . fetch_template('forumhome_honorable') . '";');

Edit FORUMHOME: Place in location of choice.
$honorable

[Snake]

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

[cdoyle]

thank you!!

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

[jilly]

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

[Zachariah]

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:

[Mastar]

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.

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

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.php?p=881085&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'

[Zachariah]

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]

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]

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?

[Zachariah]

Can this be made to not use the avatar as a setting?
- Sure boss. I'll add as a AdminCP setting on next ver.

[PennylessZ28]

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.

[Boofo]

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

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

[cbr929rrerion]

ouch.. what did I do wrong..



Database error in vBulletin 3.5.0:

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

[Zachariah]

ouch.. what did I do wrong..



Database error in vBulletin 3.5.0:

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


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.

[cbr929rrerion]

Thank you.. you rock !

[cdoyle]

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

[cbr929rrerion]

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

[cdoyle]

Great Thanks!

[PennylessZ28]

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

[Dreiko]

I have the problem that I set the member update every 24 hours, but my member isn't changing and when I use the "RUN NOW" it says:

"Couldn't elect a member of the day, not enough members"

And my board has like 140 members and a lot of then can be chosen

[Zachariah]

I have the problem that I set the member update every 24 hours, but my member isn't changing and when I use the "RUN NOW" it says:

"Couldn't elect a member of the day, not enough members"

And my board has like 140 members and a lot of then can be chosen

Generic message:
If there are no users in your DB that is with in paramaters set in AdminCP.

#########
Settings ##
#########

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

[Dreiko]

Generic message:
If there are no users in your DB that is with in paramaters set in AdminCP.

#########
Settings ##
#########

Admincp => vBulletin Options => Honorable Member
Change setting
SaveYes, when I said "and a lot of them can be chosen" I was talking about that a lot of them enter in the settings that I chosed for Honorable Member

[Zachariah]

Yes, when I said "and a lot of them can be chosen" I was talking about that a lot of them enter in the settings that I chosed for Honorable Member

I see the hack @ your site :)

? Miembro del d?a

- What was the problem ?

BTW: Nice clean Style :bunny:

[Dreiko]

I see the hack @ your site :)

? Miembro del d?a

- What was the problem ?The thing is, that member has been there since... 3 days ago, and the hack works every 24 hours at "12:00 AM", and when I try to run it now, it displays the message that I posted before.

I don't know what it could be :ermm:

BTW: Nice clean Style :bunny: Thx :)

[Zachariah]

Last Activity
The member must have logged in the forum in the last X days.

Time limit
The member can not be elected again for X number of days.

Are setting I would take a look @.

[Dreiko]

Problem fixed, it was the post count... I had it in "50" and changed it to 40 and now is working perfect

Is there a minimum number of members that has to match with the settings? because I do have some members that have all the requeriments, including the 50 posts

PD: Sorry for such a bad english -_-

BTW: Thx for the help ^^

[Zachariah]

Is there a minimum number of members that has to match with the settings? because I do have some members that have all the requeriments, including the 50 posts


No I did the test w/ 1 member - 34,000+ in the forums.

[prettyboi]

What is Vba & CMPS? How do I add the module? Please, be a little bit more specific? Thankyou!!!

[Zachariah]

What is Vba & CMPS? How do I add the module? Please, be a little bit more specific? Thankyou!!!

vBadvanced CMPS (Content Management & Portal System) is an advanced portal / content management system that will allow you to easily include different elements from your vBulletin message board on your web site's homepage. It also allows you to easily create and manage new pages in which you can set different settings other than the default. It's module system also makes it very easy to add custom modules without hacking any of the files, plus it is very easy to integrate with other vBulletin pages and hacks. Everything is also template based and completely integrated with vBulletin, so it is very easy to customize and change everything through your Admin CP.

http://www.vbadvanced.com/products.php?do=productinfo&p=4

[prettyboi]

vBadvanced CMPS (Content Management & Portal System) is an advanced portal / content management system that will allow you to easily include different elements from your vBulletin message board on your web site's homepage. It also allows you to easily create and manage new pages in which you can set different settings other than the default. It's module system also makes it very easy to add custom modules without hacking any of the files, plus it is very easy to integrate with other vBulletin pages and hacks. Everything is also template based and completely integrated with vBulletin, so it is very easy to customize and change everything through your Admin CP.

http://www.vbadvanced.com/products.php?do=productinfo&p=4

Thanks for the info Zach!!! But I don't see any CMPS on my AdminCP. Where can I go to find it? I'm having a hard time with this and this is my first time too first of all. Please explain!!! Thanks

[TamCaVBoy3]

installed, click on RUN in scheduled

Database error in vBulletin 3.5.3:

Invalid SQL:

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

FROM uniqueuser AS user
LEFT JOIN uniquehonorable AS honorable ON(user.userid=honorable.userid)
LEFT JOIN uniqueuserfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN uniqueusertextfield AS usertextfield ON(usertextfield.userid = user.userid)

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

Error Number : 1064
Date : Sunday, January 29th 2006 @ 10:35:42 AM
Script : http://www.ds-ent.net/custom/admincp/cronadmin.php?do=runcron&cronid=17

[prettyboi]

Still don't understand?

[cdoyle]

You need to install this
http://www.vbadvanced.com/products.php?do=productinfo&p=4

Before that option will appear in your admincp.

[Zachariah]

TamCaVBoy3
- What are your settings in AdminCP ?
- What (if any) fields do your have blank with out a value ?

[TamCaVBoy3]

i leave the usergroup id blank, you know, the first option

[TamCaVBoy3]

ok, nevermind, fixed, but then where will it show in the forum the honorable member? i don't see that block anywhere

[kofoid]

HELP my whole SITE is down now!!!!!!!!!!!!!!!!!!!!!

I have THIS when I try to vierw my forums:
Database error in vBulletin 3.5.2:

Invalid SQL:
SELECT dateline, userid FROM Yadacustomavatar 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 : Sunday, January 29th 2006 @ 11:08:39 AM
Script : http://lets-yada-yada-yada.com/index.php
Referrer : http://lets-yada-yada-yada.com/showthread.php?p=38802
IP Address : 24.8.201.245
Username : Laura
Classname : vb_database


And THIS from my admin CP
Database error in vBulletin 3.5.2:

Invalid SQL:

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

FROM Yadauser AS user
LEFT JOIN Yadahonorable AS honorable ON(user.userid=honorable.userid)
LEFT JOIN Yadauserfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN Yadausertextfield AS usertextfield ON(usertextfield.userid = user.userid)

WHERE
usergroupid NOT in (1,3,4)
AND user.posts >= 100
AND lastactivity >= 1130782334
AND lastpost >= 1135966334
AND user.reputation >= 0
AND (honorable.dateline < 1137953534 OR honorable.dateline IS NULL)
ORDER BY RAND()
LIMIT 1;

MySQL Error : Table 'kofoid.Yadahonorable' doesn't exist
Error Number : 1146
Date : Sunday, January 29th 2006 @ 11:12:15 AM
Script : http://www.lets-yada-yada-yada.com/admincp/cronadmin.php?do=runcron&cronid=18
Referrer : http://www.lets-yada-yada-yada.com/admincp/cronadmin.php?do=modify
IP Address : 24.8.201.245
Username : Laura
Classname : vb_database

[Zachariah]

kofoid - Table prefixs on the hack should work.
- Have you ?


========================
FORUMHOME
- forums/index.php

--------------------
search for this code
--------------------

$specialtemplates = array(

------------------
change it to this:
------------------

$specialtemplates = array(
'honorable',

#############
Settings ##
#############

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

######################
RUN Scheduled TASK ##
######################

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.

[Zachariah]

i leave the usergroup id blank, you know, the first option

Ill take a look @ that.

[TamCaVBoy3]

my forum www.ds-ent.net/custom , installed it, save options, run the schedule. don't see the effect

[Zachariah]

my forum www.ds-ent.net/custom , installed it, save options, run the schedule. don't see the effect

You have a custom style in place.
- Do you know if you still have $navbar in your FORUMHOME template ?
- Please test on default style to see if the hack is working. If it is we can make it work on your cudtom style also.

[TamCaVBoy3]

i thikn that's the problem. :)
i don't have "$navbar" in m forum home

this is what i have

$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
<!-- no cache headers -->
<meta http-equiv="Pragma" content="no-cache" />
<meta http-equiv="Expires" content="-1" />
<meta http-equiv="Cache-Control" content="no-cache" />
<!-- end no cache headers -->
$headinclude
<title>$vboptions[bbtitle]</title>
</head>
<body>
$header
<div style="padding: 5px;"></div>
<table width="100%" border="0" cellspacing="0" cellpadding="1">
<tr>
<td width="50%" align="left" valign="top">
<table width="98%" border="0" cellspacing="1" cellpadding="5" class="border1">

<tbody>
<tr>
<td align="left" valign="top" class="thead">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_stats2')"><img id="collapseimg_forumhome_stats2" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_stats].gif" alt="" border="0" /></a>
<phrase 1="$vboptions[bbtitle]"><strong>Forum Stats:</strong></phrase>
</td>
</tr>
</tbody>

<tbody id="collapseobj_forumhome_stats2" style="$vbcollapse[collapseobj_forumhome_stats]">
<tr>

<td class="stat" align="left" valign="middle" height="55" width="100%">
<div class="smallfont">
<div>$vbphrase[threads]: $totalthreads, $vbphrase[posts]: $totalposts, $vbphrase[members]: $numbermembers</div>
<div><phrase 1="member.php?$session[sessionurl]u=$newuserid" 2="$newusername">$vbphrase[welcome_to_our_newest_member_x]</phrase></div>
</div>
</td>
</tr>
</tbody>
</table>
<!-- bottom table setup -->
<table width="98%" class="thead" cellpadding="0" cellspacing="0">
<tr>
<td width="100%" height="2"><img src="$stylevar[imgdir_misc]/trans.gif" height="2" alt=" " border="0" /></td>
</tr>
</table>
<!-- End bottom table setup -->
</td>
<td width="50%" align="right" valign="top">
<table width="98%" border="0" cellspacing="1" cellpadding="5" class="border1">

<tbody>
<tr>
<td align="left" valign="top" class="thead">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_userinfotable')"><img id="collapseimg_forumhome_userinfotable" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_userinfotable].gif" alt="" border="0" /></a>

<if condition="$bbuserinfo['userid']"><b>User Welcome:</b><else /><b>Login</b></if></td>
</tr>
</tbody>
<tbody id="collapseobj_forumhome_userinfotable" style="$vbcollapse[collapseobj_forumhome_userinfotable]">

<tr>
<if condition="$bbuserinfo['userid']">

<td class="login" align="left" valign="middle" height="55" width="100%">
<div class="smallfont">
<!--<span style="float:$stylevar[left]">[<a href="login.php?$session[sessionurl]do=logout&amp;u=$bbuserinfo[userid]" onclick="return log_out()">$vbphrase[log_out]</a>]</span>-->
<strong><phrase 1="$bbuserinfo[username]">$vbphrase[welcome_x]</phrase></strong><br />
<phrase 1="$pmbox[lastvisitdate]" 2="$pmbox[lastvisittime]">$vbphrase[last_visited_x_at_y]</phrase>
<if condition="$show['pmstats']"><br /><phrase 1="$vbphrase[unread_x_nav_compiled]" 2="$vbphrase[total_x_nav_compiled]" 3="$session[sessionurl]">$vbphrase[private_messages_nav]</phrase></if>
</div>
</td>

<else />

<td class="alt1" height="55" nowrap="nowrap" style="padding:0px" align="left">

<!-- login form -->
<form action="login.php" method="post" onsubmit="md5hash(vb_login_password,vb_login_md5password)">
<script type="text/javascript" src="clientscript/vbulletin_md5.js"></script>
<table width="100%" border="0" cellspacing="1" cellpadding="5" class="border1" style="background: #ffffff url(cobalt/misc/top_user.gif) center no-repeat; border: 1px solid #CFDAE5">
<tr>
<td class="smallfont">$vbphrase[username]</td>
<td><input type="text" class="button" name="vb_login_username" id="navbar_username" size="10" accesskey="u" tabindex="1" value="$vbphrase[username]" onfocus="if (this.value == '$vbphrase[username]') this.value = '';" /></td>
<td class="smallfont" colspan="2" nowrap="nowrap"><label for="cb_cookieuser_navbar"><input type="checkbox" name="cookieuser" value="1" tabindex="3" id="cb_cookieuser_navbar" accesskey="c" checked="checked" />$vbphrase[remember_me]</label></td>
</tr>
<tr>
<td class="smallfont">$vbphrase[password]</td>
<td><input type="password" class="button" name="vb_login_password" size="10" accesskey="p" tabindex="2" /></td>
<td><input type="submit" class="button" value="$vbphrase[log_in]" tabindex="4" title="$vbphrase[enter_username_to_login_or_register]" accesskey="s" /></td>
</tr>
</table>
<input type="hidden" name="s" value="$session[sessionhash]" />
<input type="hidden" name="do" value="login" />
<input type="hidden" name="forceredirect" value="1" />
<input type="hidden" name="vb_login_md5password" />
</form>
<!-- / login form -->

</td>

</if>
</tr>

</tbody>

</table>
<!-- bottom table setup -->
<table width="98%" class="thead" cellpadding="0" cellspacing="0">
<tr>
<td width="100%" height="2"><img src="$stylevar[imgdir_misc]/trans.gif" height="2" alt=" " border="0" /></td>
</tr>
</table>
<!-- End bottom table setup -->
</td>
</tr>
</table>
<div style="padding: 5px;"></div>

<!-- main -->
$forumbits
<!-- /main -->


<!-- what's going on box -->

<!-- top category table setup -->
<table width="100%" class="tborder" cellpadding="1" cellspacing="1">
<tr>
<td width="100%" class="tcat" align="center"><div class="smallfont"><strong>$vbphrase[whats_going_on]</strong></div></td>
</tr>
</table>
<!-- End top category table setup -->

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<if condition="$show['loggedinusers']">
<!-- logged-in users -->
<tbody>
<tr>
<td class="thead" colspan="2">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_activeusers')"><img id="collapseimg_forumhome_activeusers" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_activeusers].gif" alt="" border="0" /></a>
<a href="online.php$session[sessionurl_q]" rel="nofollow">$vbphrase[currently_active_users]</a>: $totalonline (<phrase 1="$numberregistered" 2="$numberguest">$vbphrase[x_members_and_y_guests]</phrase>)
</td>
</tr>
</tbody>
<tbody id="collapseobj_forumhome_activeusers" style="$vbcollapse[collapseobj_forumhome_activeusers]">
<tr>
<td class="alt2"><a href="online.php$session[sessionurl_q]" rel="nofollow"><img src="$stylevar[imgdir_misc]/whos_online.gif" alt="$vbphrase[view_whos_online]" border="0" /></a></td>
<td class="alt1" width="100%">
<div class="smallfont">
<div style="white-space: nowrap"><phrase 1="$recordusers" 2="$recorddate" 3="$recordtime">$vbphrase[most_users_ever_online_was_x_y_at_z]</phrase></div>
<div>$activeusers</div>
</div>
</td>
</tr>
<tr><td class="thead" colspan="2">Legend</td></tr>
<tr><td class="alt1" colspan="2" ><span class="smallfont">$legend</span></td></tr>
</tbody>
<!-- end logged-in users -->
</if>
<tbody>
<tr>
<td class="thead" colspan="2">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_stats')"><img id="collapseimg_forumhome_stats" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_stats].gif" alt="" border="0" /></a>
<phrase 1="$vboptions[bbtitle]">$vbphrase[x_statistics]</phrase>
</td>
</tr>
</tbody>
<tbody id="collapseobj_forumhome_stats" style="$vbcollapse[collapseobj_forumhome_stats]">
<tr>
<td class="alt2"><img src="$stylevar[imgdir_misc]/stats.gif" alt="<phrase 1="$vboptions[bbtitle]">$vbphrase[x_statistics]</phrase>" border="0" /></td>
<td class="alt1" width="100%">
<div class="smallfont">
<div>
$vbphrase[threads]: $totalthreads,
$vbphrase[posts]: $totalposts,
$vbphrase[members]: $numbermembers<if condition="$show['activemembers']">,
<span title="<phrase 1="$vboptions[activememberdays]">$vbphrase[within_the_last_x_days]</phrase>">$vbphrase[active_members]: $activemembers</span>
</if>
</div>
<div><phrase 1="member.php?$session[sessionurl]u=$newuserid" 2="$newusername">$vbphrase[welcome_to_our_newest_member_x]</phrase></div>
</div>
</td>
</tr>
</tbody>
<!-- Start Haggis Mod -->
<tbody>
<tr>
<td class="thead" colspan="2">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_haggis')"><img id="collapseimg_forumhome_stats" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_stats].gif" alt="" border="0" /></a>
<phrase 1="$vboptions[bbtitle]">Top Posters</phrase>
</td>
</tr>
</tbody>
<tbody id="collapseobj_forumhome_haggis" style="$vbcollapse[collapseobj_forumhome_haggis]">
<tr>
<td class="alt2"><img src="$stylevar[imgdir_misc]/top.gif" alt="Top Posters" border="0" /></td>
<td class="alt1" width="100%">
<div class="smallfont">
<div>$test</div>

</div>
</td>
</tr>
</tbody>
<!-- End Haggis Mod -->
<if condition="$show['birthdays']">
<!-- today's birthdays -->
<tbody>
<tr>
<td class="thead" colspan="2">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_birthdays')"><img id="collapseimg_forumhome_birthdays" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_birthdays].gif" alt="" border="0" /></a>
$vbphrase[todays_birthdays]
</td>
</tr>
</tbody>
<tbody id="collapseobj_forumhome_birthdays" style="$vbcollapse[collapseobj_forumhome_birthdays]">
<tr>
<td class="alt2"><a href="calendar.php?$session[sessionurl]do=getday&amp;day=$today&amp;sb=1"><img src="$stylevar[imgdir_misc]/birthday.gif" alt="$vbphrase[view_birthdays]" border="0" /></a></td>
<td class="alt1" width="100%"><div class="smallfont">$birthdays</div></td>
</tr>
</tbody>
<!-- end today's birthdays -->
</if>
<if condition="$show['upcomingevents']">
<tbody>
<tr>
<td class="thead" colspan="2">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_events')"><img id="collapseimg_forumhome_events" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_events].gif" alt="" border="0" /></a>
<if condition="$show['todaysevents']">$vbphrase[todays_events]<else /><phrase 1="$vboptions[showevents]">$vbphrase[upcoming_events_for_the_next_x_days]</phrase></if>
</td>
</tr>
</tbody>
<tbody id="collapseobj_forumhome_events" style="$vbcollapse[collapseobj_forumhome_events]">
<tr>
<td class="alt2"><a href="calendar.php$session[sessionurl_q]"><img src="$stylevar[imgdir_misc]/calendar.gif" alt="$vbphrase[calendar]" border="0" /></a></td>
<td class="alt1" width="100%"><div class="smallfont">$upcomingevents</div></td>
</tr>
</tbody>
</if>
</table>
<!-- bottom table setup -->
<table width="100%" class="thead" cellpadding="0" cellspacing="0">
<tr>
<td width="100%" height="2"><img src="$stylevar[imgdir_misc]/trans.gif" height="2" alt=" " border="0" /></td>
</tr>
<tbody>
<tr>
<td class="thead" colspan="2">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('referral_links')"><img id="collapseimg_referral_links" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_activeusers].gif" alt="" border="0" /></a>
$vbphrase[referral_links_title]
</td>
</tr>
</tbody>
</table>
<!-- End bottom table setup -->

<div class="spacer"></div>
<!-- end what's going on box -->

<!-- icons and login code -->
<table width="100%" cellpadding="4" cellspacing="4" style="border: 1px solid #CEDCFA; background-color: #FFFFFF;">
<tr align="center" valign="middle">
<td class="alt2"><img src="$stylevar[imgdir_statusicon]/forum_new.gif" alt="$vbphrase[contains_new_posts]" align="middle" border="0" /></td>
<td class="alt1">Forum Has New Posts:</td>
<td class="alt2"><img src="$stylevar[imgdir_statusicon]/forum_old.gif" alt="$vbphrase[contains_no_new_posts]" align="middle" border="0" /></td>
<td class="alt1">Forum Has No New Posts:</td>
<td class="alt2"><img src="$stylevar[imgdir_statusicon]/forum_old_lock.gif" alt="$vbphrase[a_closed_forum]" align="middle" border="0" /><img src="$stylevar[imgdir_statusicon]/forum_new_lock.gif" alt="$vbphrase[a_closed_forum]" align="middle" border="0" /></td>
<td class="alt1">Forum Posts Are Locked:</td>
</tr>
</table>
<!-- / icons and login code -->

$footer
</body>
</html>

[Zachariah]

i thikn that's the problem. :)
i don't have "$navbar" in m forum home

this is what i have




Edit Plugin : Honorable Member: Forumhome

Find:
$search_text = '$navbar';

Replace:
$search_text = '$header';

[TamCaVBoy3]

thanks, everything works fine now :0

[Zachariah]

Good to hear, it's in a baby stage.
- I have many places in mind to place the data.

:cool:

[Mastar]

how can I adjust the Honorable Member window on the forumhome page?

[Zachariah]

how can I adjust the Honorable Member window on the forumhome page?

Edit Template: forumhome_honorable

Template options:
https://vborg.vbsupport.ru/showpost.php?p=881085&postcount=2

[Mastar]

Edit Template: forumhome_honorable

Template options:
https://vborg.vbsupport.ru/showpost.php?p=881085&postcount=2

I stil don't see where to adjust the width & height of the window.

[Zachariah]

I stil don't see where to adjust the width & height of the window.

Edit template:
forumhome_honorable

The looks of the block is there. The link gives a small list of info collected per member.

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

SELECT dateline, userid FROM vb353_customavatar WHERE userid =;


No Honorable Member ID.

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

[mholtum]

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]

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

[vinston vega]

I have it displaying the avatars now but, the path is not the same for all users. for one user the IMG URL will be something like: "http://www.yoursite.com/images/avatars/example_40_4.gif" while for another the path would be "http://www.yoursite.com/images/avatars/example_40_2.gif"

Please help me. This is one awesome mod and I would like to get it working right.

[Zachariah]

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

No Honorable Member ID.

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

[Zachariah]

I have it displaying the avatars now but, the path is not the same for all users. for one user the IMG URL will be something like: "http://www.yoursite.com/images/avatars/example_40_4.gif" while for another the path would be "http://www.yoursite.com/images/avatars/example_40_2.gif"

Please help me. This is one awesome mod and I would like to get it working right.

Take a look in the Plugin:
- Honorable Member: Forumhome
- forum\modules\honorable.php

Find:
$vbulletin->userinfo[avatarrevision] . ".gif"

Replace:
$mday[avatarrevision] . ".gif"

[Tyegurl]

No Honorable Member ID.

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



Database error in vBulletin 3.5.4:

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
Date : Wednesday, March 22nd 2006 @ 09:11:15 PM
Script : http://www.teamrespawn.com/vBulletin/index.php
Referrer :


and in the vbulletin options.....ummmm there are no words for this mod....just blank space lol you click on it and you bring up a screen with numbers in a box no lettering at all....

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

anyone?

[Zachariah]

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?
Location: Los Angeles :o
- Hey come to the Valley I need some beer. :banana:

I'll take a look when I recode it as an option in AdminCP ;)

[yinyang]

Location: Los Angeles :o
- Hey come to the Valley I need some beer. :banana:

I'll take a look when I recode it as an option in AdminCP ;)

actually, i am in studio city. how much beer you need? :D

[vinston vega]

Take a look in the Plugin:
- Honorable Member: Forumhome
- forum\modules\honorable.php

Find:
$vbulletin->userinfo[avatarrevision] . ".gif"

Replace:
$mday[avatarrevision] . ".gif"

Hey first off, Thanks for the quick reply.

I am still having the same problem.

[49er]

Thank You, nice mod... Just need to ask if i could change the words "Honorable Member" that shows on the forumhome box with words of my own? if so where can i change them.

Thank you. ;)

[Gizmo5h1t3]

id be interested to see other members on here that have this installed check their scheduled tasks log....

as mine runs almost every minute...lol

even thought its set to run at 11pm only..once per day..

any one else had this prblem????

[mariannet]

id be interested to see other members on here that have this installed check their scheduled tasks log....

as mine runs almost every minute...lol

even thought its set to run at 11pm only..once per day..

any one else had this prblem????
At midnight it starts to rotate members for a while and then it stays with one for the next 24 hours :)

[Zachariah]

id be interested to see other members on here that have this installed check their scheduled tasks log....

as mine runs almost every minute...lol

even thought its set to run at 11pm only..once per day..

any one else had this prblem????

Thats odd.
- I'll take a look and see if its a hack problem or VB cron job timmer issue.

[Tory H]

Is it possible to have this mod without the CPMS?

[Zachariah]

Is it possible to have this mod without the CPMS?
- yes both ver. CMPS and FORUMHOME is included.

[Smiry Kin's]

could you please make a seperate one, for change the avatar image, to the profile picture please! :) or to a photo in photoplog

[Gizmo5h1t3]

At midnight it starts to rotate members for a while and then it stays with one for the next 24 hours :)


mine starts rotating, and just doesnt stop...lmao

[bada_bing]

pretty cool will save for a later date

[Tyegurl]

i still can't run on 3.5.4

[Royal]

i still can't run on 3.5.4

Me neither


Database error in vBulletin 3.5.4:

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
Date : Thursday, April 13th 2006 @ 10:49:27 PM
Script : ***/index.php
Referrer : ***/index.php?do=head
IP Address : ***
Username : roy
Classname : vb_database


And i allready ran the scheduled task manager 2 times, no result

[Tyegurl]

Me neither


Database error in vBulletin 3.5.4:

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
Date : Thursday, April 13th 2006 @ 10:49:27 PM
Script : ***/index.php
Referrer : ***/index.php?do=head
IP Address : ***
Username : roy
Classname : vb_database


And i allready ran the scheduled task manager 2 times, no result


i did everything i was supposed to....i try every now and then but same result....

[Zachariah]

I'll put some time in this and see about an update on this by the weekend.

[Tyegurl]

tyvm :)

[jilly]

My users are now clamoring for an archive list showing which member was honorable member of the day on x-day. Sometimes there are offline a day or more, and they want to come back and find if they missed their day to be the honored one :) IS there any way we could have a link at the bottom of the honorable member info box, and the link would say
"view the past x honorable members' - and/or a 'view all past honorable members'

[Zachariah]

My users are now clamoring for an archive list showing which member was honorable member of the day on x-day. Sometimes there are offline a day or more, and they want to come back and find if they missed their day to be the honored one :) IS there any way we could have a link at the bottom of the honorable member info box, and the link would say
"view the past x honorable members' - and/or a 'view all past honorable members'

Good idea
- I'll take a look @ that durring revamp :D

[:Judge:]

I am getting this error on the CMPS:

Database error in vBulletin 3.5.4:

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 see the error from a few people, I ran the task a few times and still get the same result.

Thank you in advanced :)

[robgeo]

Is there a way to make the Title of the Block on the Home page say "Member of the Week" (or something like that) instead of "Honorable Member"?

[Zachariah]

Is there a way to make the Title of the Block on the Home page say "Member of the Week" (or something like that) instead of "Honorable Member"?

Template: forumhome_honorable

Find:
<b>$vbphrase[hm_honorable] $vbphrase[member]</b>
Replace:
<b>$vbphrase[member] of the Week</b>

[Tyegurl]

I am getting this error on the CMPS:

Database error in vBulletin 3.5.4:

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 see the error from a few people, I ran the task a few times and still get the same result.

Thank you in advanced :)


correct me if i am wrong but i think this has been stated before.

this is not compatible with 3.5.4 he is working on updating it to be compatible and we are all waiting on the edges of our seats for it to be released ;)

[robgeo]

Template: forumhome_honorable

Find:
<b>$vbphrase[hm_honorable] $vbphrase[member]</b>
Replace:
<b>$vbphrase[member] of the Week</b>


Thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[Royal]

I'll put some time in this and see about an update on this by the weekend.

Been a week ago, you found a fix allready? If you need more time just say so, but i cant wait to install this hack on my 3.5.4.

Thanks in advance.

[foulplay]

Installed!

[plateau]

hello, good job, can u pls further develop this hack and make it display the Top 10 users who meet the conditions set in ACP, and display them as a list on both VBA and VB homepages.

if so, that would be great, cause it would be very nice for the members to get a Top 10 once a week/X days.

Thanks a lot!!!

[foulplay]

I have it installed on 3.5.4 and it works fine. How do I get it to where members can click the avatar icon and it will direct you to their profile?

[Tyegurl]

I have it installed on 3.5.4 and it works fine. How do I get it to where members can click the avatar icon and it will direct you to their profile?


you got it to work? i will have to try yet again...wonder if its because my forum is sooo HEAVILY modded....but i have vbadvance too...

[Tyegurl]

wow it kind of worked lol

2 questions... if i am using vbadvance and i want it on forum home and vbadvance home... which file do i edit? the forum or the vbadvance?

secondly which xml do i upload? if i want it on both?

okay 3 questions now...sorry....i noticed some people were having problems with it running all the time...

i set my cron task to

Monday
*
23
59 59 59 59

so does this mean every monday at midnight (basically) it will pick a new "Member Spotlight"?

[Ambie]

I have 3.5.4 It worked for two days with no problem, but now the cron task is telling me : Couldn't elect a member of the day, not enough members. (there are 135 members on my site)

[Zachariah]

I have 3.5.4 It worked for two days with no problem, but now the cron task is telling me : Couldn't elect a member of the day, not enough members. (there are 135 members on my site)

Parameters set for the choice in the AdminCP were not met.

[MR-2ZZ]

I still have no luck with it on 3.5.4

[Zachariah]

Updates:
- I am working on a new output page. (forums/honorable.php)
- This will work on 3.5.4

Working on:
- Photopost Support - all 4 product. (last additions)
- AdminCP menu redesign

To Do's:
- Hooks
- History (last 10,20,30, All in list format)
- Other

[yinyang]

awesome, can't wait. do you have an ETA? also, please, if possible, don't forget to let admin have the choice to also choose who a member is...

hey, you're a neighbor. studio city here.

[Kyderoy]

I have 3.5.4 It worked for two days with no problem, but now the cron task is telling me : Couldn't elect a member of the day, not enough members. (there are 135 members on my site)


I am having this problem also. I changed every setting and it is still doing the same thing.

[PennylessZ28]

this is a gay hack :p

haha! zboren84 !!!

[Zachariah]

this is a gay hack :p

haha! zboren84 !!!

:surprised: :lick:

[Boofo]

I am having this problem also. I changed every setting and it is still doing the same thing.

I'm getting the same exact problem now. Check your datastore and see if the honorable column is there anymore. I think there might be a nasty bug in this hack. ;)

[Boofo]

I am getting this error on the CMPS:

Database error in vBulletin 3.5.4:

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 see the error from a few people, I ran the task a few times and still get the same result.

Thank you in advanced :)

I am also getting this error.

[Shelly]

I love this hack, but i am having a problem with the avatars.
our members use photobucket for their avatars and the path that this mod points to includes my site url and photobuckets url so it doesnt find the pic, any ideas?
example
http://www.globalmommies.com/http://i38.photobucket.com/albums/e113/Blinkies2006/Avatars/Avatar165.gif

[Boofo]

I love this hack, but i am having a problem with the avatars.
our members use photobucket for their avatars and the path that this mod points to includes my site url and photobuckets url so it doesnt find the pic, any ideas?
example
http://www.globalmommies.com/http://i38.photobucket.com/albums/e113/Blinkies2006/Avatars/Avatar165.gif

Contact me via PM and I MIGHT be bale to help you as I have a fully working version of this under testing right now. ;)

[NineToez]

Just curious, are the bugs worked out on this hack before I try to install?

[vbreal]

is there anyway to choose a member to display.
i want to use ur system for 2 different things.
i want u use it to display a member of the week that was the top member for that week based off of stats and other contributions to the board. i don't want it to be random. i would like to enter a name for that person.

i installed it on 3.5.4 and now know its not compatible. but i didn't' see a way to change it from 1 day, a week, or a month. i guess i would make the change in the cron. just making sure

also how can it work for some 3.5.4 versions and not others?

[Zachariah]

is there anyway to choose a member to display.
i want to use ur system for 2 different things.
i want u use it to display a member of the week that was the top member for that week based off of stats and other contributions to the board. i don't want it to be random. i would like to enter a name for that person.

i installed it on 3.5.4 and now know its not compatible. but i didn't' see a way to change it from 1 day, a week, or a month. i guess i would make the change in the cron. just making sure

also how can it work for some 3.5.4 versions and not others?


Good idea, and in the works. I have not had a lot of time to work on this other than porting it over to 3.5x. from 3.0.

yes, change the time when cron runs.


I have a lot of ideas for this hack.
One was a full page with an output of info on this member.

[vbreal]

Good idea, and in the works. I have not had a lot of time to work on this other than porting it over to 3.5x. from 3.0.

yes, change the time when cron runs.


I have a lot of ideas for this hack.
One was a full page with an output of info on this member.

oh wow thats whats up. so when u say thats in the works you talking about my suggestion? just want to be sure what to look out for haaaaa:banana:


that full page sounds nice?

[NineToez]

Okay, I've installed it on a seperate test forums that I setup just for little tweaks and mods I want to test out. Installation is fine along with my own minor modifications, however any tips on how to modify the .XML file so that it changes the position in forumhome and adds a seperate module toward the bottom under 'What's Going On?' like what's in the attached image?

[NineToez]

^^ Anyone? Anyone? Bueller?

[vbreal]

has anyone got this to work for 3.5.4

[Tyegurl]

i had it working on 3.5.4 but couldn't get vbadvance to put the module on the Homepage....but it was on my forum pages...but i upgraded vbulletin

I installed it on my 3.6.0 beta 3 also and works great thanks!!

edit: [3.6.0 beta3] had a small problem with it constantly changing the Honorable Member when I refreshed the page....so i went to task manager and set it to "Honorable Member" for the product at the bottom of the setting for this mod....stopped switching the member now. I will keep an eye on it.

edit: still changing everytime i refresh...worked for a few times back back to changing again...

[NineToez]

I got it to work on my vB 3.5.4 too however I'd love to have this as a module instead of a heading on forumhome.

[Tyegurl]

yes that would be nice.

i couldn't get it to work...i got db errors...wish i could help. :(

[Skedoozy]

I got the same error everyone else got in 3.5.4

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

No fix for this??

I would love to use it on my home page as a module.

[NineToez]

i couldn't get it to work...i got db errors...
I know that it's in the .XML file as to how it is to be "displayed" in the forums, however this is an area where I'm not so great at custom coding. I know that if I spent an afternoon or a few hours at least reverse engineering another module, I'm sure I can get it on my own. I was hoping another more experienced coder would lend advise, however it looks like this one will have to be upon me (or amongst us at least) if we really want this to be reality.

[NineToez]

A little experimenting and it's more that just the .XML; it's three templates too that need to be modded. Let's keep our fingers crossed.

[Skedoozy]

*crossed*

[Zachariah]

Ok I got this installed into vB3.5.4 , VB3.6 and it is worken ok.
- I have some add-ons I am working on also.

More to come

If anyone has some custom things they have done and would like to share shoot me an PM.

[Tyegurl]

Ok I got this installed into vB3.5.4 , VB3.6 and it is worken ok.
- I have some add-ons I am working on also.

More to come

If anyone has some custom things they have done and would like to share shoot me an PM.

yes so did on i on 3.5.4 and i do on 3.6.0....it stopped randomly changing the member every refresh....now it keeps my member for a week...but..........

excuse me for a second.....

I WANT THE MODULE TO WORK!!!!! I WANT IT ON MY CMPS INDEX....okay thanks for listening lol

and that wasn't meant to be rude or mean. that was a temper tantrum cuz i have done something wrong obviously for it to not work ;)

[Zachariah]

I got the same error everyone else got in 3.5.4

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

No fix for this??

I would love to use it on my home page as a module.


AdminCP / Scheduled Tasks / Scheduled Task Manager
- RUN: Honorable Member


yes so did on i on 3.5.4 and i do on 3.6.0....it stopped randomly changing the member every refresh....now it keeps my member for a week...but..........

excuse me for a second.....

I WANT THE MODULE TO WORK!!!!! I WANT IT ON MY CMPS INDEX....okay thanks for listening lol

and that wasn't meant to be rude or mean. that was a temper tantrum cuz i have done something wrong obviously for it to not work ;)


There were some changes on the CRON table.

Run this:
UPDATE `cron` SET `weekday` = -1, `day` = -1, `hour` = 23, `minute` = 'a:1:{i:0;i:-1;}', `filename` = './includes/cron/honorable_member.php', `loglevel` = 1, `active` = 1, `varname` = 'hm_task', `volatile` = 1, `product` = 'gz_honorable_member' WHERE `varname` = 'hm_task';

If this does not work:

AdminCP / Scheduled Tasks / Scheduled Task Manager
- Edit: Honorable Member


Varname: hm_task
Title: Honorable Member
Description: Honorable Member
Active: Yes
Log Entries: Yes
Filename: ./includes/cron/honorable_member.php
Product: Honorable Member
vBulletin Default: Yes






*** NOTE to SELF: re-do the installer w/ low requirements and atuorun on install to stop errors.

Reff.

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

[Tyegurl]

okay i ran it no changes to table ;) now i will run the cron and see what happens....

also should i redo the template lol i took it off because it took the whole site down....i know i must have done something wrong....

[Tyegurl]

one question....

"Product: Honorable Member
vBulletin Default: Yes"

ummmm what do you mean.....

in product i have vBulletin and changed it to Honorable Member....

i don't see a vbulletin default anything unless you mean to have the product set to vbulletin instead of honorable member....you confused me lol

[Zachariah]

one question....

"Product: Honorable Member
vBulletin Default: Yes"

ummmm what do you mean.....

in product i have vBulletin and changed it to Honorable Member....

I don't see a vbulletin default anything unless you mean to have the product set to vbulletin instead of honorable member....you confused me lol

I live in debug mode for DEV work and may see a few other things.

If so, Fill out what you can :)

[Tyegurl]

lol okay i gotcha! i have a few radio buttons missing on my end but i don't have that default one either but i remember have before i upgraded lol...

not your doing on the error either...

anyway i will try to enable the module when i have no users on line and let you know if it's fixed

thanks for the help!

[vbreal]

i looked at the update date and i see there hasn't been an update in a while. so is there still an issue with this showing up in the camps.

hey zach are you still trying to incorporate that idea i had a few pages back.

[NineToez]

Yay, activity from the OP again! Zachariah, can you post a mod to make this a module on forumhome instead? Hope you don't take the request in offense, however I (and looks like many others) don't like how it appears on the home page at the top.

[Skedoozy]

Ran the task and that did the trick. Thank you, sir!

[Zachariah]

Yay, activity from the OP again! Zachariah, can you post a mod to make this a module on forumhome instead? Hope you don't take the request in offense, however I (and looks like many others) don't like how it appears on the home page at the top.

Oh yes, many plans in the mix.
I do not take offense of people adding input and requests. (I can not think of it all :D )

I'll work on some FAQ's and findings as I rebuild.

[Skedoozy]

I keep getting the "Couldn't elect a member of the day, not enough members" error now and there are plenty of members that fall into the numbers I inputed.

[TheProphet]

/installed thx Zachariah

[TheProphet]

I have it installed on 3.5.4 and it works fine. How do I get it to where members can click the avatar icon and it will direct you to their profile?

Easy

edit:
template: forumhome_honorable

Find:
$avatarurl

Replace by:
<a href="$vboptions[bburl]/member.php?&u=$mday[userid]">$avatarurl</a>

Save and done.

:banana:

[vbreal]

hey zach you still working on this?

[Zachariah]

hey zach you still working on this?

Yes

I have a lot of things on my plate. I have many plans for this mod.

[Roxie]

I have it working (so far) on 3.6 Gold. I'm using it on vbadvanced.

[Dermo-MIO]

iv tried installing this on 3.6 but it just shuts down my forum i hope you can upgrade this for 3.6 and also it would be cool to use in a side column

[JenniferK]

So does this actually work in 3.6.1 then?

[Zachariah]

I do not know
I have not tested

I will see about making some time.

[NineToez]

So does this actually work in 3.6.1 then?Theoretically it should, however I'm going to wait until Zachariah unveils the next updated version to install it. ;)

[Skedoozy]

Not working for me in 3.6.1. I get a database error about the avatar table in the db being wrong. :/

[Zachariah]

Not working for me in 3.6.1. I get a database error about the avatar table in the db being wrong. :/

Thanks for the info.
There were a lot of changes from 3.5 - 3.6.

[JenniferK]

Thanks for the reply :) I know you said you have alot on your plate right now - any idea of where this is in the hierarchy of things?

[vbreal]

is there anyway to choose a member to display.
i want to use ur system for 2 different things.
i want u use it to display a member of the week that was the top member for that week based off of stats and other contributions to the board. i don't want it to be random. i would like to enter a name for that person.

i installed it on 3.5.4 and now know its not compatible. but i didn't' see a way to change it from 1 day, a week, or a month. i guess i would make the change in the cron. just making sure

also how can it work for some 3.5.4 versions and not others?
zach,

do u still plan to have this inc int the updated version?

[Zachariah]

zach,

do u still plan to have this inc int the updated version?

Yes when I get back into the code, I'll collect all wants and need of the people who use the hack :)

[imported_infitech]

I just installed this...
Great hack...
I think the CMPS people out there should know that at the end of the honorable template they should replace the <br />
<div><img src="$vboptions[bburl]/$vboptions[cleargifurl]" height="$vba_style[portal_vspace]" alt="" /></div>

[DeeNice]

I've placed the honorable member MOD in my left colum.
It works fine on FormHome but i get database error on every other page.

How must i edit your code to make it work in my colum on everypage? My colum is a part of the header template.

eval('$honorable = "' . fetch_template('forumhome_honorable') . '";');

[sduckie2k5]

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!

[Zachariah]

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!

plans yes :)

[Mr Morningstarr]

Hi, had this hack working for ages. Now started getting this error message:

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

Any suggestions?

[ngocha85]

Not working with 3.5.4 & 3.6.x!:D

[SimplyBen]

This would definitely be in use for 3.6. Hope your considering it :]

[BreeBears]

CMPS v2.2.1 | vBulletin 3.6.5 (using on CMPS page) Works great, thanks soo much!!

Always -Bree

[Mrdby]

3.6.7? And The Latest Version Of Cmps?

[Zachariah]

I have this on the drawing board for re-design. I'll see about some updates :) in the 3.6.x section.

[jilly]

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

[Rickeo]

love it

[Ingmar]

Fantastic work Zachariah!

CMPS v3.0 RC1 and vB v3.6.7 notes:


Missing the TABLE_PREFIX in the CREATE TABLE query on line 10 of the CMPS XML file.
Apparently there is no longer a $vbphrase[member] phrase var name in 3.6.7.
Had to add the Scheduled Task manually.


Really minor stuff really...

Fantastic work though Zachariah! Thank you!

[Ingmar]

I've been asked for the updated files for vB v3.6.7/CMPS v3.0 so here they are. I've however not full error tested them but seems to work great for me (sorry, only made the changes to the CMPS only files).

I've only made a couple minor changes to Zachariah fantastic work so definitely can't take any credit for this fantastic mod.

Changes:

Added: TABLE_PREFIX to XML file.
Stripped: Module shell from the adv_portal_honorable template.
(set "Use Module Wrapper Template" to YES)
Replaced: $vbphrase[member] with "Member" in the adv_portal_honorable template.
Added: "Registered: (date joined)" field to the adv_portal_honorable template.
Added: Dateformat to honorable_member.php.


That's it, just download the attached files and follow Zachariah's updated install_smps_only.txt instructions and your all set.

Thanks again to Zachariah for this great mod!

Cheers!

[Zachariah]

Thanks for the help Ingmar . I'll take a look before next update.

[rainyleaves]

Thanks, for Ingmar and Zachariah.

I tried install.

This messages from scheduled task run.
Honorable Member
Couldn't elect a member of the day, not enough members
My site has 10 members.
Because my site is just testing site.
Do I need minimum members?

And this messages from index page.
Database error in vBulletin 3.6.7:

Invalid SQL:
SELECT dateline, userid FROM quadnine_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

What am I wrong?

Thanks. :)

[Zachariah]

Thanks, for Ingmar and Zachariah.

I tried install.

This messages from scheduled task run.

My site has 10 members.
Because my site is just testing site.
Do I need minimum members?

And this messages from index page.


What am I wrong?

Thanks. :)

Admincp => vBulletin Options => Honorable Member
Change setting

You need to set the requirements to be chosen very low.
Then re run the Scheduled Task for the "Honorable Member" hack to choose a user.

When a user is selected you problem will go away.
On the new version I am working on there will have a default random user chosen on install

[rainyleaves]

Thanks, for Ingmar and Zachariah.

Works perfectly!! :)
Awesome mod.

Thanks again Ingmar.

[jilly]

Did I suggest this before? If not, my users have asked if there could be a list showing the past 'honorable members' that were chosen. They are sometimes curious about if they were honorable memebr but missed it because they were offline for some reason. :)

[Shelly]

nice, my members love this mod, thanks for updating it for 3.6.7

[Becca]

Why does it cycle through members every time it tries to elect a new one? This means that it selects lots of members, for only 1 minute each, which means they then can't be selected again in the number of days you have put in the settings. This is why it keeps saying there aren't any members, because it has already selected them. The only way i can see to get round this is to set the number of days before users can be chosen again to 0, but then will it cycle through members until there are none left or does it only cycle for a certain length of time?

[Zaiaku]

I'm another person waiting for a 3.6.8 version.

[jilly]

Why does it cycle through members every time it tries to elect a new one? This means that it selects lots of members, for only 1 minute each, which means they then can't be selected again in the number of days you have put in the settings. This is why it keeps saying there aren't any members, because it has already selected them. The only way i can see to get round this is to set the number of days before users can be chosen again to 0, but then will it cycle through members until there are none left or does it only cycle for a certain length of time?

I think it cycles through the members, but unless they were actually selected as the member of the day, it doesn't keep them out of the next day's running.
Are you having trouble with it not finding enough choices to pick a member of the day from?

[Becca]

I was having trouble with that, but now i've set the conditions lower it manages to pick one, trouble is it just seems to pick the same 3 all the time, when i have well over 10 that it could pick. Could just be coincidence.

[Zinzara]

3.6.8 version is eagerly anticipated here too!

[The Fat Boy]

oops... tried to get this to work for 3.6.8 without the CMPS... killed the site. I just removed it, everything is fine.

I want this for my board!

[Zachariah]

I have this back on the worktable.
- I'll put a 3.6.x version out and link to the update.

I am sorry for the delay.

[hddstudio]

still waiting for 3.6.8......thanks !

[esck]

Just found this mod, and would love to use it on 3.6.8

[Acrobat]

Any chance this will be updated to 3.6.x?

[Zachariah]

Any chance this will be updated to 3.6.x?

I have it working I'll post soon.

[deezelpope]

Any chance this will be updated to 3.6.x?

I have it working I'll post soon.
Ooooh, this excites me!:up: I've had my eye on this for quite some time now, Zachariah!:)

[Roxie]

If you are getting the customavatar database error, make sure you make the edit to your cmps_index file. I have this working on 3.6.8.

[TCE Killa]

^I have that error and I don't understand what you mean by editing my cmps index file, where do I find it and what do I edit in? Thanks.

I'm using 3.6.8 btw.

[TCE Killa]

Importing the forumhome XML keeps giving me the customavatar db error. I've added the honorable after the specialtemplates array on my index.php, anyone know what I am doing wrong? Thanks.

[Zachariah]

If your using 3.6x+ don't bother I have something different I am working on.
- I'll dump in 3.7 mods area and add "OK on versions xxx and up" It may also include vB3.5. I'll let ya know.

[Roxie]

^I have that error and I don't understand what you mean by editing my cmps index file, where do I find it and what do I edit in? Thanks.

I'm using 3.6.8 btw.

The instructions say to change a line in your cmps index file.

Importing the forumhome XML keeps giving me the customavatar db error. I've added the honorable after the specialtemplates array on my index.php, anyone know what I am doing wrong? Thanks.

Don't add it after. Replace it.

I just upgraded to 3.7 and it's still working on vbadvanced.

[m002.p]

If your using 3.6x+ don't bother I have something different I am working on.
- I'll dump in 3.7 mods area and add "OK on versions xxx and up" It may also include vB3.5. I'll let ya know.

Awesome, would love to see a similar mod say along the lines of this mod and a "member of the month" doo dah.

Good Luck ill be sure to keep a look out :)

[TCE Killa]

The instructions say to change a line in your cmps index file.



Don't add it after. Replace it.

I just upgraded to 3.7 and it's still working on vbadvanced.

I replaced it but still get the error... I'll just wait for Zachariah to release a newer and better one, thanks for the help.

[Roxie]

Hmmm. I wonder why I was able to get it working. Working great on 3.7.

[jilly]

then i can finally upgrade my board :)

[jilly]

I find it's not working in 3.7 beta 4..

Database error in vBulletin 3.7.0 Beta 4:

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
Date : Monday, February 4th 2008 @ 08:48:35 PM
Script : http://www.bmww.org/forums/index.php
Referrer : http://www.bmww.org/forums/admincp/index.php?do=head

MySQL Version : 4.1.20

[Roxie]

I have it working with 3.7 RC1, however, it seems to pull from the same handful of members. About 15 of them.

[cdoyle]

Did this ever get upgraded for 3.7 and CMPS 3.0?

I really liked this mod, but cant' seem to get the 3.5 version to work with CMPS

[Zachariah]

I am deep in a project at the moment. I have it on the worktable to get updated.
- I'll try to get it done after I launch this new VB site.

[jilly]

So Zach, how is it going? My memebrs really miss the fun they had with this mod!! Please tell me you can take a look at it again soon :)

[Ingmar]

Yes, we really liked this mod too!

Any chance of a new version coming out that will run on vB 3.7.3 / vBa 3.0.1 ? :)

Cheers!

[Zachariah]

Yes, we really liked this mod too!

Any chance of a new version coming out that will run on vB 3.7.3 / vBa 3.0.1 ? :)

Cheers!

Ya I have it on the design table. :D

[aranthorn]

YAY! on the table!

[sunrainme]

Can't wait.

[Reef Man]

Waiting for the update.

Do you have an estimate of time?

[jilly]

My people are anxiously awaiting the return of this mod! They really are - please please move it from the table to the plugin!! :P

[Zachariah]

thanks for the nudge :D , working on it today.

[cdoyle]

Any updates on this one?
It was a great mod, and would love to see it back.

[Gorgias]

Any updates on this one?
It was a great mod, and would love to see it back.

So am I...

[jilly]

Years later, my members STILL miss this add-on, and wish we had it back again.. I am still running vb 3.8 if anyone can get it working!!