vb.org Archive - Forum Home Enhancements - Latest Paid Subscribers v1.1

Page 3 of 10

Show 40 post(s) from this thread on one page

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)

rmxs	10-11-2006 05:42 PM

Maybe for the Reminder to dispayed in all pages

jgommel

10-11-2006 10:15 PM

Okay, this time around it installed just fine. Thanks for the update paul41598. I hope you don't mind, but because I'm meticulous about appearance and placement. I decided to code this into it's own FORUMHOME "What's Going On" box and remove it from within the "Currently Active Users" box.

For those who want to do the same, here's what I did...

Disregard Step 1 (Edit Templates) in paul41598's instructions and instead, do this...

Template Name: forumhome

Find:

PHP Code:


		
			
<!-- end logged-in users -->

</if>

Add below:

PHP Code:


		
			
<!-- Latest Paid Subscribers -->

<tbody>

    <tr>

        <td class="thead" colspan="2">

        <a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('paid_subscribers')"><img id="collapseimg_paid_subscribers" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_paid_subscribers].gif" alt="" border="0" /></a>

        <phrase 1="$show[subscribers]">$vbphrase[last_paid_subscribers_display]</phrase>

    </tr>

</tbody>

<tbody id="collapseobj_paid_subscribers" style="$vbcollapse[collapseobj_paid_subscribers]">

    <tr>

        <td class="alt2"><img src="$stylevar[imgdir_misc]/whos_online.gif" alt="Paid Subscribers" border="0" /></td>

        <td class="alt1" width="100%"><div class="smallfont">$showsubscribers</div></td>

    </tr>

</tbody>

Find:

PHP Code:


		
			
$navbar

Add Below:

PHP Code:


		
			
<if condition="$show['subscribers']">$expiryalert</if>

Continue with Step 2 (Load The Product)

I'm going to look at your vBAdvanced module too and see if there's anything else I can do to it as well.

Thanks!

whitetigergrowl

10-11-2006 11:03 PM

Quote:

Database error in vBulletin 3.6.2:

Invalid SQL:

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

MySQL Error : Unknown column 'subscriptionlog.userid' in 'on clause'
Error Number : 1054
Date : Wednesday, October 11th 2006 @ 07:01:23 PM
Script : http://www.mywebsite.com/community/index.php
Referrer : http://www.mywebsite.com/community/a...ex.php?do=head
IP Address : *********
Username : ********
Classname : vB_Database

Sensite info blocked out. I have followed this to a T and this is the sql error I recieve. I use php and sql 5+.

jgommel

10-11-2006 11:10 PM

Did you download 'latest paid subscribers 1.1.zip' or 'latest paid subscribers 1.1 update.zip'

Uninstall the one on your vBulletin board and then Download the 'latest paid subscribers 1.1 update.zip' from here and install this one.

Lionel

10-12-2006 12:43 AM

Quote:

Originally Posted by paul41598

Now I've never created a vbadvanced module before, so bare with me. However, below is the module I created. I've tested and it seems to work on my forums. Just follow the directions and hopefully it will work for you too. ;)

Thanks. I kept it at global hook and simply put the variable in vbadavanced global

whitetigergrowl

10-12-2006 02:19 AM

Quote:

Database error in vBulletin 3.6.2:

Invalid SQL:

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

MySQL Error : Unknown column 'subscriptionlog.userid' in 'on clause'
Error Number : 1054
Date : Wednesday, October 11th 2006 @ 10:17:55 PM
Script : http://www..com/community/index.php
Referrer : http://www..com/community/admincp/index.php?do=head
IP Address :
Username :
Classname : vB_Database

Tried both. This is the error with the update one. (Minus sensitive info)

TVNettet

10-12-2006 04:09 AM

Tried both your files, got db error on vb3.6.2 Read about your fresh install, unfortunately have too much stuff already installed to go through all of those again, but nice try all the same.
Had a similar product working in earleir vB version and it was gr8!!
I'll keep an eye out for any updates you release...

Quarterbore

10-13-2006 12:25 PM

If you don't mind... I would like some help changing the hover from the "Subscription Expires On DATE" to a message that says "Subscription to "SUBSCRIPTION NAME" on DATE"

For new subscribers, it isn't urgent that they resubscribe... but I would like to recognize them for their contribution as I have several levels of contributor!

Also, I tried to move the pluggin code for the subscription expiring to a new pluggin and I hooked it to global_start. Then I used the template change and added the notification to SHOWTHREAD template.

It works for a base install but it will not work on my site because of the way I use vbAdvanced (my site is linked below). I'll figure it out one of these days...

scottct1

10-18-2006 03:10 PM

How do I set the message shown to users when there subscription is about to expire.

I searched for the phrase expiryalert and did not find anything.

paul41598

10-18-2006 05:41 PM

Quote:

Originally Posted by scottct1

How do I set the message shown to users when there subscription is about to expire.

I searched for the phrase expiryalert and did not find anything.

Its in the template "expirydatebits"

All times are GMT. The time now is 02:04 PM.

Page 3 of 10

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01287 seconds Memory Usage 1,763KB 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 (4)bbcode_php_printable (4)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
Messages: