Honorable Member

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

Cerdits: Vb 3.0x Ver
Rigel Kentaurus (http://www.cemzoo.com)

Redesign:
Zachariah (http://www.gzhq.net)

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

This hack lets you "elect" @ random a Honorable Member.

The member is someone randomly picked from all the users in
your forum that met a certain criteria.

By default it appers in top of the forumhome. It is a nice way for members
of the forum to get to know each other.

DEMO - CMPS Block: Honorable Member

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

================================================== =====
1 Query added to page load.

File edit: 1-2
Upload: 1-2 file
Add: 1-2 templates
Plugins: 0-2

Tested on:
- vBulletin 3.5.3
- vBadvanced CMPS v2.0.0 (vB 3.5)
- PhotoPost vBGallery v1.0.1 (vB 3.5) - add-ons soon
================================================== =====


Shows: (At the moment)
- Member Name
- Avatar
- Post Count w/ link to show all posts
- Reputation Count
- Age
- Most active forum w/ link (forum the member posts in the most)

Options: (At the moment)
- Minimum posts that the user must have
- The user must had logged in the forum in the last x days
- The user must had posted in the forum in the last x days
- Minimum reputation the user must have
- If a user is elected he cannot be elected again in this number of days
- Your private or hidden forums so they are not shown in the "favorite forum"

To Do's:
- BBCodes
- Smiles
- Photopost vBGallery (links to Images and posts)
- Photopost other 3 products (links)
- VBPortal Block
- VBA Links (links ot submited)
- Any others?

[prettyboi]

Originally Posted by Zachariah

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.p...roductinfo&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...cron&cronid=17

[prettyboi]

Still don't understand?

[cdoyle]

You need to install this
http://www.vbadvanced.com/products.p...roductinfo&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/a...cron&cronid=18
Referrer : http://www.lets-yada-yada-yada.com/a....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]

Originally Posted by TamCaVBoy3

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

Ill take a look @ that.