vb.org Archive - Honorable Member

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)

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

Quote:

Originally Posted by 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
Save

Quote:

Originally Posted by Zachariah

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

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

Quote:

Originally Posted by Dreiko

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:

Quote:

Originally Posted by Zachariah

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:

Quote:

Originally Posted by Zachariah

BTW: Nice clean Style :bunny:

Thx :)

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

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

Quote:

Originally Posted by Dreiko

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.

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

Quote:

Originally Posted by prettyboi

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.p...roductinfo&p=4

Quote:

Originally Posted by Zachariah

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:

Quote:

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

Quote:

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

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

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

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

Code:

$specialtemplates = array(

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

Code:

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

Quote:

Originally Posted by TamCaVBoy3

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

Ill take a look @ that.

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

Quote:

Originally Posted by TamCaVBoy3

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.

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

this is what i have

Code:

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

Quote:

Originally Posted by TamCaVBoy3

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:

Code:

$search_text = '$navbar';

Replace:

Code:

$search_text = '$header';

thanks, everything works fine now :0

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

:cool:

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

Quote:

Originally Posted by Mastar

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

Edit Template: forumhome_honorable

Template options:
https://vborg.vbsupport.ru/showpost....85&postcount=2

Quote:

Originally Posted by Zachariah

Edit Template: forumhome_honorable

Template options:
https://vborg.vbsupport.ru/showpost....85&postcount=2

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

Quote:

Originally Posted by Mastar

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.

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

Quote:

Originally Posted by mholtum

SELECT dateline, userid FROM vb353_customavatar WHERE userid =;

No Honorable Member ID.

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

Quote:

Originally Posted by Zachariah

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

Quote:

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

this isnt working with 3.5.4

can you make work please????? i have 3.5.4 too and am interested in it

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?

Quote:

Originally Posted by MR-2ZZ

this isnt working with 3.5.4

Glad i read that b4 installing, thanks.

Havent had time to try in 3.5.4, but I do not see a reason why it should not work.

I don't know what I've done wrong, but it is not showing the users avatar.

Can anyone help me?

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

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02139 seconds Memory Usage 1,931KB 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 (5)bbcode_code_printable (20)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
Messages: