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
Referrals In Postbit Details »»
Referrals In Postbit
Version: 1.1.0, by Developer Developer is offline
Developer Last Online: Nov 2010 Show Printable Version Email this Page

Version: 3.5.4 Rating:
Released: 02-20-2006 Last Update: 06-08-2006 Installs: 53
Uses Plugins Template Edits
 
No support by the author.

Number Of Referrals In Postbit
Version 1.1.0
Description::.
This hack shows in postbit Number Of Referrals[Requested By cmiller1014 ]
Hack Features::.
1-easy yo install
[See Screen Shot]

Installation::.
1-Import The product.
2-run this script admincp/misc.php?do=referrals to insert number of referrals into the new field
3-Edit Template postbit
Find:
Code:
<if condition="$post['joindate']"><div>$vbphrase[join_date]: $post[joindate]</div></if>
Add after it
Code:
<if condition="$vboptions['usereferrer']">
			<div class="smallfont">
			<strong>$vbphrase[referrals]</strong> $post[referrals]
				</div>
                                                   </if>
2-Edit Template postbit_legacy
Find:

Code:
<if condition="$post['joindate']"><div>$vbphrase[join_date]: $post[joindate]</div></if>
Add after it

Code:
<if condition="$vboptions['usereferrer']">
			<div class="smallfont">
			<strong>$vbphrase[referrals]:</strong> $post[referrals]
				</div>
                                                   </if>
History::.
1.0.0 On 21. Feb 2006 Initial Version.
1.1.1 On 26 Apr 2006 Fix Major BUG.
Hack Languages::.
  • English
Details::.
2 plugins, 3 phrases, 0 option, 0 query

Donation::.
Feel Free To
aT lAsT::.
IF YOu lIkE iT cLIcK INSTALL
vbulletin.org
[/B]
Support Given For Who Clicked Install {ONLY}

Show Your Support

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

Comments
  #12  
Old 02-24-2006, 02:33 AM
proxx proxx is offline
 
Join Date: Oct 2003
Posts: 117
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

could someone tell me how to fix this error, i get many of these emailed to me:


Database error in vBulletin 3.5.2:

Invalid SQL:
SELECT COUNT(*) AS count FROM user WHERE referrerid =;

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 : Tuesday, February 21st 2006 @ 09:50:38 PM
Script : http://***/showthread.php?p=6720
Referrer :
IP Address : 65.54.111.69
Username : Unregistered
Classname : vb_database
Reply With Quote
  #13  
Old 03-04-2006, 09:31 AM
Lea Verou Lea Verou is offline
 
Join Date: Jul 2005
Location: Greece
Posts: 1,856
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Doesn't this add one query to EACH post?
Reply With Quote
  #14  
Old 03-04-2006, 09:17 PM
Scratz Scratz is offline
 
Join Date: Nov 2004
Location: Cape Breton
Posts: 8
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Just thought i would let the developer know that when I applied the plugin and edited the templates that it was calling for the referrals vbphrase when in my 3.5.4 forum the phrase was referrers..

Don't know if it was due some change I did but putting it out there anyway.
Reply With Quote
  #15  
Old 04-21-2006, 10:19 PM
trackpads's Avatar
trackpads trackpads is offline
 
Join Date: Aug 2003
Location: Armyville
Posts: 1,074
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I am having this same issue, The cause is from the post being by a guest or user 0. Since I have some USENET posts these have no userid and the plugin crashes the thread.

Any idea if we can get an update that eliminates the referall call on guest posts?

Thanks!

-Jason
Reply With Quote
  #16  
Old 04-22-2006, 03:03 AM
Developer's Avatar
Developer Developer is offline
 
Join Date: Sep 2005
Location: EgYpT
Posts: 662
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i'll update this hack soon
Reply With Quote
  #17  
Old 04-22-2006, 10:45 AM
trackpads's Avatar
trackpads trackpads is offline
 
Join Date: Aug 2003
Location: Armyville
Posts: 1,074
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks! It is a great hack!!
Reply With Quote
  #18  
Old 04-24-2006, 08:08 PM
trackpads's Avatar
trackpads trackpads is offline
 
Join Date: Aug 2003
Location: Armyville
Posts: 1,074
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Any luck?
Reply With Quote
  #19  
Old 04-25-2006, 11:56 PM
trackpads's Avatar
trackpads trackpads is offline
 
Join Date: Aug 2003
Location: Armyville
Posts: 1,074
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ok, had some other folks here help me on this and here is the patch:

Go into your Admincp, plugins and edit the plugin: Number Of Referrals in postbit-by Developer

Replace this:

Code:
if ($vbulletin->options['usereferrer'])
With this:

Code:
if ($this->post['userid'])
And it will work with USENET and Guest posts!

(Thanks to tnguy3n, Hambil, gio~logist and Zachery!)
Reply With Quote
  #20  
Old 04-26-2006, 12:12 AM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Still, a problem with this hack is it runs an addtional query for each post.

It would much better to do an update for each user and log their total user referals. Then log new referals from then on out.
Reply With Quote
  #21  
Old 04-26-2006, 08:03 AM
Developer's Avatar
Developer Developer is offline
 
Join Date: Sep 2005
Location: EgYpT
Posts: 662
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Fixing It now i'll add a plugin in update counters so you have to run something after installing the hack so it counts referrals and then insert it in a field in user's table using datamanger.
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 07:53 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04875 seconds
  • Memory Usage 2,306KB
  • 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
  • (6)bbcode_code
  • (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