vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Forum Home Enhancements - Latest Paid Subscribers v1.1 (https://vborg.vbsupport.ru/showthread.php?t=128735)

Robbed 10-18-2006 11:47 PM

The link to edit the phrase doesn't work.

us44ever 10-19-2006 08:37 PM

paul41598
what about 3.5.4 ?
there is no support or any assistance and still have the same problem in the databese.
please i need this hack , could you help me with that .
with regards

sunnycher 10-27-2006 05:37 AM

Installed! THANK YOU!!

Now if I could just figure out how to get my what's going on box at top instead of the bottom! lol

dennisuello 11-27-2006 05:25 PM

Quote:

Originally Posted by whitetigergrowl (Post 1095090)
Tried both. This is the error with the update one. (Minus sensitive info)

I get the same error
Quote:

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT subscriptionlog.userid, subscriptionlog.subscriptionid, subscription.subscriptionid, subscriptionlog.expirydate,
user.userid, user.username
FROM vb3_subscriptionlog AS subscriptionlog, vb3_subscription AS subscription
LEFT JOIN vb3_user AS user ON (subscriptionlog.userid = user.userid)
WHERE subscriptionlog.status != '0' AND subscriptionlog.subscriptionid = subscription.subscriptionid AND user.userid = 1 AND subscriptionlog.expirydate < 1167247465
ORDER BY subscriptionlog.expirydate ASC LIMIT 5;

MySQL Error : Unknown column 'subscriptionlog.userid' in 'on clause'
Error Number : 1054
Date : Monday, November 27th 2006 @ 11:24:25 AM
Script : http://www.reno4x4.com/forum/
Referrer : http://www.reno4x4.com/
IP Address : ******
Username : ******
Classname : vB_Database

dennisuello 11-27-2006 05:40 PM

I selected No for the "Display Reminder Window for Subscribers (ForumHome)?" option, and now forumhome works. But I would like the reminder to work too.

Bounce 12-10-2006 07:21 PM

Quote:

Originally Posted by Robbed (Post 1099836)
The link to edit the phrase doesn't work.

Yip same here..Running 3.6.4 ... also if you have more than 5 selected it takes the width of the forums way beyond what it should be and you need to scroll instead of starting a new line?

Great Hack thou ..

*Installed*

Quote:

Originally Posted by sunnycher (Post 1105328)
Installed! THANK YOU!!

Now if I could just figure out how to get my what's going on box at top instead of the bottom! lol

http://www.vbulletin.com/forum/showp...02&postcount=4

Quote:

Originally Posted by simsim (Post 1240702)
AdminCP => Styles & Templates => Style Manager => <>

Then choose the FORUMHOME template, which you'll find under Forum Home Templates.

There, search for the code that indicates the begininng & end of the What's Going on box. It should begin like this:
Code:

<!-- what's going on box -->
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<thead>
    <tr>
        <td class="tcat" colspan="2">$vbphrase[whats_going_on]</td>
    </tr>
</thead>
<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>
</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>
<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>
<br />
<!-- end what's going on box -->

Cut that code at of your FORUMHOME template & put right under $navbar.
Code:

</head>
<body>
$header
$navbar

PUT IT HERE

<!-- main -->
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<thead>

My What's Going On box is modified so yours might not look the same, but be sure to copy all code between <!-- what's going on box --> &<!-- end what's going on box --> comments.


Caerydd 12-30-2006 07:32 AM

This looks like a great hack, but is there any update on those sql errors and such like, and also the issue about a forumhome only query? I don't need this to be a global call.

And yes, I am aware of the previous discussion, but subsequent posts also report errors, and I prefer to work from the main installation post knowing that it is a relatively stable hack.

paul41598 12-30-2006 11:09 PM

the updated zip file has the hook location at forumhome. The hack works.

b.t.w, for those who cant edit the phrase directly through the hyperlink, you can fix it by editing the phrase: (setting_latest_paid_subscribers_desc)

and change:

&e[1]

to:

&e[global]

bada_bing 01-18-2007 01:49 AM

Does this hack work with vb 3.6.4 ?

Raptor 01-19-2007 05:56 AM

works great on 3.6.4


All times are GMT. The time now is 03:38 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.01255 seconds
  • Memory Usage 1,767KB
  • 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
  • (2)bbcode_code_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (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