vb.org Archive - Referrers On Forumhome v.1.3

Page 2 of 2

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)

- - Referrers On Forumhome v.1.3 (https://vborg.vbsupport.ru/showthread.php?t=101324)

kurtbarker

12-03-2005 09:21 PM

maybe i'm missing it aye, but that 'edit' looks like it's for a different error?

cbr929rrerion

12-04-2005 02:18 AM

It shows the wrong date for "Date Joined". It has the same date for everyone..

Can this be fixed?

tnguy3n

12-04-2005 02:43 AM

Quote:

Originally Posted by cbr929rrerion

It shows the wrong date for "Date Joined". It has the same date for everyone..

Can this be fixed?

I think I missed out the joindate field in my query.

In the plugin,

FIND:

PHP Code:


		
			
    $referrers = $db->query_read("SELECT user.userid, user.username, user.referrerid, users.username AS refname FROM " . TABLE_PREFIX . "user AS users LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.referrerid = users.userid) WHERE user.referrerid = '" . intval($vbulletin->GPC['referrerid']) . "' ORDER BY user.username DESC LIMIT 0, $count");

REPLACE WITH:

PHP Code:


		
			
    $referrers = $db->query_read("SELECT user.userid, user.username, user.referrerid, users.username AS refname, user.joindate FROM " . TABLE_PREFIX . "user AS users LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.referrerid = users.userid) WHERE user.referrerid = '" . intval($vbulletin->GPC['referrerid']) . "' ORDER BY user.username DESC LIMIT 0, $count");

[high]* tnguy3n updated hack.[/high]

cbr929rrerion

12-04-2005 03:02 AM

Done.. Awesome.. fixed.. Thanks

smokering

12-04-2005 04:12 AM

excellent hack thank you

Developer

12-06-2005 06:39 AM

v.nice hack

NoCo7

12-18-2005 02:06 PM

An alternative fix I found for the mysql 'usergroup' table related errors is to adding 'AS usergroup' on the second LEFT JOIN in the initial $referrals query resolves the problem and allows the group markup to work.

Code:

$referrals = $db->query_read("SELECT COUNT(*) AS totalref, user.username, user.userid, user.usergroupid, usergroup.usergroupid, usergroup.opentag, usergroup.closetag

    FROM " . TABLE_PREFIX . "user AS users

    LEFT JOIN " . TABLE_PREFIX . "user AS user ON (users.referrerid = user.userid)

    LEFT JOIN " . TABLE_PREFIX . "usergroup AS usergroup ON (usergroup.usergroupid = user.usergroupid)

    WHERE users.referrerid != 0

        GROUP BY users.referrerid

        ORDER BY totalref

        DESC LIMIT 0,$num");

tnguy3n

12-19-2005 11:04 PM

thanks for pointing that out, NoCo7.

update the hack!

neutek

01-06-2006 07:48 PM

thanks :)
+install

cbr929rrerion

01-13-2006 06:38 PM

when I click on the members name it takes me to a page but it dont list them, you can see where they should be but they are not there..

www.crotchrocketracing.com

Its at the bottom.. any idea?

tnguy3n

01-13-2006 07:11 PM

It's supposed to popup in new window. Check if you have all the template modded correctly.

cbr929rrerion

01-13-2006 07:21 PM

I will have to check because it dont do a new window..

cbr929rrerion

01-18-2006 08:04 PM

well i completely reinstalled and it does not work, any idea what I am missing..

Take a look at www.crotchrocketracing.com

Thanks for the help..

MorrisMcD

02-03-2006 04:32 AM

I started getting this error shortly after having this hack installed.. It was fine, but I registered as a new user to test and put the only other user in the database as the referral.. After that I continued to get this error until I disabled the plugins for this hack, and ultimately deleted :(

Quote:

Fatal error: Cannot use object of type vB_Session as array in /home/html/index.php(485) : eval()'d code on line 172

Any idea why? I like the idea of this mod

payamix1

02-03-2006 05:25 AM

I think you mistaked in editing of FORUMHOME style.

Celtkin

02-03-2006 02:47 PM

Thank you. Clicked install

cbr929rrerion

02-03-2006 02:56 PM

Quote:

Originally Posted by cbr929rrerion

well i completely reinstalled and it does not work, any idea what I am missing..

Take a look at www.crotchrocketracing.com

Thanks for the help..

I will be UN_INSTALLING THIS since no one can assist in pointing out why this is not working correctly for me.

If I can get someone to take a look at it and see what its doing then I would appreciate it, if not I will have to un-install it...

:devious:

o0Hubba0o

02-12-2006 05:26 AM

Nice little add-on, I like it.
/me clicks install

GamerJunk.net

02-14-2006 02:13 AM

Its listing referral links from my forums...if someone views someone's profile and clicks the link to go back it is counting it

GamerJunk.net

02-14-2006 02:14 AM

<a href="http://www.gsnforce.com/forum/referrals.php" target="_blank">http://www.gsnforce.com/forum/referrals.php</a>

See how its showing from my own forum?

tnguy3n

02-14-2006 02:39 AM

Quote:

Originally Posted by cbr929rrerion

check your FORUMHOME template if you have this javascript:

HTML Code:

<SCRIPT TYPE="text/javascript">

<!--

function popup(url, referrers)

{

if (! window.focus)return true;

var href;

if (typeof(url) == 'string')

   href=url;

else

   href=url.href;

window.open(href, referrers, 'width=300,height=250,scrollbars=yes');

return false;

}

//-->

</SCRIPT>

GamerJunk.net

02-14-2006 10:35 PM

I even blocked the gsnforce from showing up yet it still does.

guamdude

02-15-2006 07:25 PM

works just fine.

ubblite

02-19-2006 04:54 AM

It's been a while since the earlier posts, so I was wondering if anyone has been able to get this Mod working with vbAdvanced CMPS?

nonet

02-21-2006 03:00 PM

The popup window does not work for me either. I checked and the code changes are done correctly.

SlowRoasted

02-22-2006 03:51 AM

How can i get this to display in another template? It wont let me just put $showreferrers in another template.

SlowRoasted

02-23-2006 01:54 AM

*bump* anyone know how to get this in another template? I want to put it in my sidebar template but it won't work if I just put $showreferrers in it.

tnguy3n

02-23-2006 02:14 AM

I think if you change the hook to global_start, it would show anywhere on vBulletin powered page.

Drache

03-02-2006 08:37 PM

Does this work with 3.5.4?

budswope

03-02-2006 11:48 PM

I get the message "No Referrer Found" even after new signups?

I love this idea!

kira	03-05-2006 07:56 PM

Quote:

Originally Posted by Drache

Does this work with 3.5.4?

It's working in mine so far, although it's only a test board (i.e. not 'live' yet).

Many thanks for this nifty little plugin. I think it'll add a nice incentive to refer more people to a community!

sunnycher

03-09-2006 03:00 PM

Thank you! This works perfectly! was just inquiring about one of these!

Treak

03-10-2006 03:59 AM

amazing hack thanks again.. very useful for a contest i am running!!

GuaRRand

03-10-2006 10:26 AM

completely screwed up my forum :(

cant even load the main page anymore...

www.glcoti.com

Pls help!!!!!

MorrisMcD

03-10-2006 12:32 PM

Quote:

Originally Posted by GuaRRand

completely screwed up my forum :(

cant even load the main page anymore...

www.glcoti.com

Pls help!!!!!

Same thing happened to me.. could never get this working for some reason

go to http://yoursite/admincp

It should allow you there.. Then you can go into the product manager and disable this hack or uninstall it (I would suggest disabling in case you do it to the wrong plugin)

The Chief

03-29-2006 03:50 AM

installed and works great!!

http://www.myetalk.com/forums/index.php

[high]* The Chief clicks install[/high]

hypnoticpimp

05-31-2006 02:25 AM

Hey does this work for 3.5.4 cause i tried it and got an error this error
Fatal error: Cannot use object of type vB_Session as array in /home/wshh/public_html/forums/index.php(485) : eval()'d code on line 195

Let me know how i can fix this error

BryceW

06-15-2006 01:41 PM

I am looking to install this in 3.5.4 as well. Does this work on 3.5.4?

sunnycher

02-10-2007 10:59 PM

I'd love to have this for 3.6.4, anyone install it yet?

All times are GMT. The time now is 12:25 PM.

Page 2 of 2

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01488 seconds Memory Usage 1,802KB 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 (1)bbcode_code_printable (1)bbcode_html_printable (2)bbcode_php_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (39)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: