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

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

Still don't understand?

You need to install this
http://www.vbadvanced.com/products.p...roductinfo&p=4

Before that option will appear in your admincp.

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

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

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

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

I have THIS when I try to vierw my forums:

And THIS from my admin CP

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


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

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

------------------
change it to this:
------------------
#############
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.

Ill take a look @ that.