Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.5 > vBulletin 3.5 Add-ons
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Latest Paid Subscribers v1.0 Details »»
Latest Paid Subscribers v1.0
Version: 1.00, by paul41598 paul41598 is offline
Developer Last Online: Jun 2013 Show Printable Version Email this Page

Version: 3.5.4 Rating:
Released: 08-22-2006 Last Update: 02-24-2007 Installs: 21
Uses Plugins Template Edits
 
No support by the author.

Brought to you by myself with credits to Kaezul as well
From the guys who brought you
"Incomplete Profile Fields"


We Bring To You:
Latest Paid Subscribers v1.0

This Hack Does Use The Usergroups Markup Color For A More Accurate Display Of Subscription Members!! This Hack Has It All!

Description:
This hack is fully functional and flexible allowing you to display the latest [x] subscribers on your forumhome! It also allows you to display a reminder/alert to your users who's subscriptions are expiring.

Features:
  • Activate The System (Latest Paid Subscribers)
  • Select The Number Of Subscribers To Show On ForumHome
  • Display A Reminder/Alert Window To Warn Subscribers When Their Subscription Is Up
  • Select The Number Of Days Before That Reminder Shows
  • Never Show This Again For Reminder Alert!
  • Allow The Subscriber Info In The Title HoverOver Or Turn It Off
  • Select A Date Format For That HoverOver

Installation:
1.) 1 Template Edit
2.) 1 Product Upload
3.) Enjoy Release

Notes:
- Adds 1 extra query
- Advanced Options (if you see fit to use)


If you find any bugs, have comments, questions feel free to post them. I'll do my best to accomidate anything.
Disclaimer: Any modification to this hack, must get prior consent/authorization by me first.


This is now a premium hack only, available through myself

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #42  
Old 10-20-2006, 04:49 PM
paul41598's Avatar
paul41598 paul41598 is offline
 
Join Date: Jun 2004
Location: MI
Posts: 732
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

update attached for this hack with latest bug fixes. Non-tested though
Reply With Quote
  #43  
Old 10-20-2006, 06:16 PM
Konstantinos Konstantinos is offline
 
Join Date: Apr 2006
Posts: 443
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

tested in 3.5.4 and works cool so far and no sql errors
Reply With Quote
  #44  
Old 10-20-2006, 07:05 PM
paul41598's Avatar
paul41598 paul41598 is offline
 
Join Date: Jun 2004
Location: MI
Posts: 732
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Konstantinos
tested in 3.5.4 and works cool so far and no sql errors
Cool
Reply With Quote
  #45  
Old 10-20-2006, 07:30 PM
us44ever us44ever is offline
 
Join Date: Aug 2005
Posts: 7
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

here is the msg after adding the product
Database error in vBulletin 3.5.4:
Quote:
Invalid SQL:

INSERT INTO product
(productid, title, description, version, active)
VALUES
('Latest Paid Subscribers v1.1',
'Latest Paid Subscribers',
'Display The Latest Subscribers v1.1',
'1.1',
1);

MySQL Error : Duplicate entry 'Latest Paid Subscribers v' for key 1
Error Number : 1062
Date : Friday, October 20th 2006 @ 11:28:40 PM
Script : ******
Referrer : ******
do=productadd
IP Address : ******
Username : bokhalaf
Classname : vB_Database_MySQLi
Reply With Quote
  #46  
Old 10-20-2006, 07:54 PM
paul41598's Avatar
paul41598 paul41598 is offline
 
Join Date: Jun 2004
Location: MI
Posts: 732
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by us44ever
here is the msg after adding the product
Database error in vBulletin 3.5.4:
hopefully you uninstalled the old one..and then reinstalled the new one "overwrite" selected to YES
Reply With Quote
  #47  
Old 10-20-2006, 11:09 PM
us44ever us44ever is offline
 
Join Date: Aug 2005
Posts: 7
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by paul41598
hopefully you uninstalled the old one..and then reinstalled the new one "overwrite" selected to YES
now i uninstall the old one and install the update version
this proeblem has bees fixed " erorr while install it"
but still the same Erorr in database, when i keep you hack enable i face this erorr when i turn it off everything working fine.
btw i install new vbulletin on my machine and install the hack , also i face the same problem .
Quote:
Database error in vBulletin 3.5.4:

Invalid SQL:

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

MySQL Error : Unknown column 'subscriptionlog.userid' in 'on clause'
Error Number : 1054
Date : Saturday, October 21st 2006 @ 03:05:54 AM
Script : http://******
Referrer : http://******
IP Address : ********
Username : bokhalaf
Classname : vB_Database_MySQLi
thanks in advance
Reply With Quote
  #48  
Old 10-21-2006, 12:46 AM
paul41598's Avatar
paul41598 paul41598 is offline
 
Join Date: Jun 2004
Location: MI
Posts: 732
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm sorry, I cannot go further unless I gain access to your forums with an administrator password for your admincp
Reply With Quote
  #49  
Old 12-17-2006, 06:13 AM
Konstantinos Konstantinos is offline
 
Join Date: Apr 2006
Posts: 443
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

does it work in 3.6.4 ?
Reply With Quote
  #50  
Old 12-17-2006, 01:06 PM
paul41598's Avatar
paul41598 paul41598 is offline
 
Join Date: Jun 2004
Location: MI
Posts: 732
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

<a href="https://vborg.vbsupport.ru/showthread.php?t=128735" target="_blank">https://vborg.vbsupport.ru/showthread.php?t=128735</a>
Reply With Quote
  #51  
Old 01-14-2007, 09:06 PM
BraindGee BraindGee is offline
 
Join Date: Feb 2006
Posts: 36
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

For the ppl getting the SQL errors, ive amended the xml file. adding VB3_ before the user tables, works a treat on my site now.

*Clicks install.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 03:55 AM.


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.05589 seconds
  • Memory Usage 2,314KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (5)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete