vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Honorable Member (https://vborg.vbsupport.ru/showthread.php?t=106188)

Zachariah 09-21-2006 06:03 PM

I do not know
I have not tested

I will see about making some time.

NineToez 09-22-2006 04:09 AM

Quote:

Originally Posted by JenniferK
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 09-22-2006 11:01 AM

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

Zachariah 09-22-2006 11:44 AM

Quote:

Originally Posted by Skedoozy
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 09-22-2006 03:50 PM

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 09-22-2006 07:53 PM

Quote:

Originally Posted by 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 09-22-2006 10:18 PM

Quote:

Originally Posted by vbreal
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 10-31-2006 08:36 PM

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 12-01-2006 07:38 AM

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.

Quote:

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

sduckie2k5 12-04-2006 02:26 PM

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 12-04-2006 03:23 PM

Quote:

Originally Posted by sduckie2k5 (Post 1131621)
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 01-01-2007 02:45 PM

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
Any suggestions?

ngocha85 02-06-2007 03:40 AM

Not working with 3.5.4 & 3.6.x!:D

SimplyBen 03-03-2007 06:20 AM

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

BreeBears 03-03-2007 09:49 AM

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

Always -Bree

Mrdby 05-23-2007 08:14 PM

3.6.7? And The Latest Version Of Cmps?

Zachariah 05-23-2007 10:30 PM

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

jilly 06-27-2007 06:50 PM

Quote:

Originally Posted by Zachariah (Post 1253515)
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 06-27-2007 08:37 PM

love it

Ingmar 07-14-2007 05:48 AM

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 07-14-2007 11:15 PM

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 07-14-2007 11:58 PM

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

rainyleaves 07-15-2007 02:29 PM

Thanks, for Ingmar and Zachariah.

I tried install.

This messages from scheduled task run.
Quote:

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

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 07-15-2007 05:15 PM

Quote:

Originally Posted by rainyleaves (Post 1291839)
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 07-16-2007 04:21 AM

Thanks, for Ingmar and Zachariah.

Works perfectly!! :)
Awesome mod.

Thanks again Ingmar.

jilly 07-20-2007 07:40 PM

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 07-22-2007 08:08 PM

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

Becca 07-24-2007 08:34 AM

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 07-28-2007 01:16 PM

I'm another person waiting for a 3.6.8 version.

jilly 08-06-2007 07:30 PM

Quote:

Originally Posted by Becca (Post 1299931)
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 08-21-2007 09:18 AM

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 09-13-2007 08:55 PM

3.6.8 version is eagerly anticipated here too!

The Fat Boy 10-01-2007 06:06 PM

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 10-01-2007 06:31 PM

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 10-21-2007 01:08 PM

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

esck 10-23-2007 05:10 PM

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

Acrobat 01-04-2008 03:50 PM

Any chance this will be updated to 3.6.x?

Zachariah 01-04-2008 04:31 PM

Quote:

Originally Posted by Acrobat (Post 1415409)
Any chance this will be updated to 3.6.x?

I have it working I'll post soon.

deezelpope 01-04-2008 04:37 PM

Quote:

Originally Posted by Acrobat (Post 1415409)
Any chance this will be updated to 3.6.x?

Quote:

Originally Posted by Zachariah (Post 1415434)
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 01-12-2008 05:05 AM

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.


All times are GMT. The time now is 12:44 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01483 seconds
  • Memory Usage 1,824KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (15)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete