vb.org Archive
Page 18 of 23 « First 81617 18 1920 Last »
Show 40 post(s) from this thread on one page

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


All times are GMT. The time now is 03:11 PM.
Page 18 of 23 « First 81617 18 1920 Last »
Show 40 post(s) from this thread on one page

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.01267 seconds
  • Memory Usage 1,735KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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