link for each user for inviting members

[all-the-vb]

hello everyone

hack name: link for each user for inviting members

by : all-the-vb

time to install: 7 to 12 min

How the hack works:
We remember how I carried out the programming of the invention in vb2.
https://vborg.vbsupport.ru/showthread.php?s=&threadid=57656

But in vb3 this character is automatically present but in different way, as when the member is coming for register ,there is a little box for the name of the member whose invites him to join ,
After installing this hack, there will be there a link for every member to invite the members to register, and when the visitor follow the link which received it from the member to register, the little box that ask him about the name of member invited will not appear .
but if the visitor register in the usual way the box will appear.
and off course there will be the numbers of the members that follow the links + the numbers of the members that register with typing the name of member invited
and more than that,
so the number of new members that the member invited them what ever the way of their rigesteration.
and more than that, make a form in the main page to let the member invite the members by his e-mail, and will present the link of the member invited
in main e-mail and in reply
and show the number of referrals in a postbit
and each user can see he link in usercp.

++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++
Queries >> 0
Files to Modify >> 3
Templates Added >> 1
Templates to Modify >> 5
add a phrases >> 4
++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++

[all-the-vb]

example

[SnowBot]

This sounds interesting :) I will have a look :) THANKS

[SnowBot]

OK all installed BUT when i go to the usercp and click on the invite link i get this

Our records show that you have already registered under the name of Snowy. If you have lost your password, click here. If you would like to modify your profile, click here.
Any ideas?

[nexialys]

can be interesting if everything is merged inside a single script: affiliates, tell-a-fiend, email thread to friends, contact friends, etc... we really need something efficient.

[all-the-vb]

OK all installed BUT when i go to the usercp and click on the invite link i get this

Any ideas?

hello
the link in usercp
no't to you use,
but for guest
to REGISTER in forum

but you a member

you'r welcome
sorry for my bad english :ermm:

[SnowBot]

hello
the link in usercp
no't to you use,
but for guest
to REGISTER in forum

but you a member

you'r welcome
sorry for my bad english :ermm:
I dont understand, if they are not registered they can not see the usercp anyway so why is the link there?

[nexialys]

when you're not registered, you are not linked to any userID, so why have access to this system anyway ?!

Referers is for members that gain points because they advertise...

[SnowBot]

when you're not registered, you are not linked to any userID, so why have access to this system anyway ?!

Referers is for members that gain points because they advertise...OK what is the link for in the usercp? I may be misunderstanding you here. If you are NOT registered you can NOT see the usercp so the link is for members in some way but if you are already a member then what use is this link? Like i said i may have got this wrong so please tell me what is supposed to happen with this link in the usercp.

my link is

http://www.synergyforums.com/forum/register.php?refuserid=1
Also your phrase for this is

Phrase Type: GLOBAL
Varname: your_linkinv
Text: a special link for inviting members That suggests to me that the link SHOULD be for members to invite NEW members to the forum BUT when clicked it just says you are already reged.

[Pyrix]

That's the link you would give them. So you might send out an e-mail with that link in it to a few friends, and when they sign up you'd get a referral point.

Ollie

[SnowBot]

hhhm I keep getting this db error

Database error in vBulletin 3.0.3:

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 2

mysql error number: 1064

Date: Tuesday 20th of July 2004 04:05:05 PM
Script: http://www.synergyforums.com/forum/showthread.php?t=307
Referer:
Username: Unregistered

[all-the-vb]

That's the link you would give them. So you might send out an e-mail with that link in it to a few friends, and when they sign up you'd get a referral point.

Ollie
SnowBot

ya that's true
thank you Pyrix & nexialys
for help me :)

[all-the-vb]

hhhm I keep getting this db error
try this:

open File: includes/functions_showthread.php

find:

$refcount = $DB_site->query_first("SELECT
COUNT(*) AS count FROM " . TABLE_PREFIX . "user WHERE referrerid =
$post[userid]");
$referrals = vb_number_format($refcount['count']);


Replace it with:

$refcount = @$DB_site->query_first("SELECT
COUNT(*) AS count FROM " . TABLE_PREFIX . "user AS user WHERE user.referrerid =
$post[userid]");
$referrals = @vb_number_format($refcount['count']);

[SnowBot]

Still getting some DB errors

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT
COUNT(*) AS count FROM user AS user WHERE user.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 2

mysql error number: 1064

Date: Wednesday 21st of July 2004 09:39:20 AM
Script: http://www.synergy-4ums.com/forum/showthread.php?t=562 (http://www.synergy-4ums.com/forum/showthread.php?t=562)
Referer:
Username: Unregistered


Database error in vBulletin 3.0.3:

Invalid SQL: SELECT
COUNT(*) AS count FROM user AS user WHERE user.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 2

mysql error number: 1064

Date: Tuesday 20th of July 2004 10:55:17 PM
Script: http://www.synergyforums.com/forum/showthread.php?t=1240 (http://www.synergyforums.com/forum/showthread.php?t=1240)
Referer: http://www.synergyforums.com/forum/forumdisplay.php?s=&daysprune=&f=88 (http://www.synergyforums.com/forum/forumdisplay.php?s=&daysprune=&f=88)
Username: crayolacrayons
Any help would be great :)

[all-the-vb]

Still getting some DB errors
Any help would be great :)
:rolleyes:


try this:

open File: includes/functions_showthread.php

find:

if ($vboptions['usereferrer'])
{
$refcount = @$DB_site->query_first("SELECT
COUNT(*) AS count FROM " . TABLE_PREFIX . "user AS user WHERE user.referrerid =
$post[userid]");
$referrals = @vb_number_format($refcount['count']);
}


Replace it with:

if($bbuserinfo['userid']!=0 AND $post['userid']!=0){
if ($vboptions['usereferrer'])
{
$refcount = @$DB_site->query_first("SELECT
COUNT(*) AS count FROM " . TABLE_PREFIX . "user AS user WHERE user.referrerid =
$post[userid]");
$referrals = @vb_number_format($refcount['count']);
}
}

[SnowBot]

OK trying that now :) THANKS. Will report back as soon as i know :)

[all-the-vb]

hmmm im sorry i forgot one edit
see now
https://vborg.vbsupport.ru/showthread.php?p=535575#post535575

[SnowBot]

hmmm im sorry i forgot one edit
see now
https://vborg.vbsupport.ru/showthread.php?p=535575#post535575
Sorry about this but i still have an error :(

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT
COUNT(*) AS count FROM user AS user WHERE user.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 2

mysql error number: 1064

Date: Thursday 22nd of July 2004 07:53:18 AM
Script: http://www.synergyforums.com/forum/showthread.php?t=1243&highlight=reloaded
Referer: http://www.synergyforums.com/forum/search.php?searchid=6700
Username: kritters

[all-the-vb]

find:

if($bbuserinfo['userid']!=0 AND $post['userid']!=0){
if ($vboptions['usereferrer'])
{
$refcount = @$DB_site->query_first("SELECT
COUNT(*) AS count FROM " . TABLE_PREFIX . "user AS user WHERE user.referrerid =
$post[userid]");
$referrals = @vb_number_format($refcount['count']);
}
}


Replace it with:

if($post['userid']!=0){
if ($vboptions['usereferrer'])
{
$refcount = @$DB_site->query_first("SELECT
COUNT(*) AS count FROM " . TABLE_PREFIX . "user AS user WHERE user.referrerid = '$post[userid]' ");
$referrals = @vb_number_format($refcount['count']);
}
}

[Elmer]

I though that he link in the form was already there but nice hack instead ;)

[GamerForums.net]

Yes, this is a feature already in vBulletin: https://vborg.vbsupport.ru/faq.php?s=&do=search&q=refer&match=all&titlesonly=0

Nice work in having the same feature in your board twice.

[SnowBot]

still got DB errors :(

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT
COUNT(*) AS count FROM user AS user WHERE user.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 2

mysql error number: 1064

Date: Friday 23rd of July 2004 08:14:59 PM
Script: http://www.synergyforums.com/forum/showthread.php?t=307
Referer: http://www.synergyforums.com/forum/search.php?searchid=7115
Username: Sorry i think i will have to un-install :( shame as it was/is a nice hack.

[SnowBot]

Why all these DB errors ?

[SnowBot]

Any news on this issue ? please, i love the hack but cant sort it out :(

[SnowBot]

Sorry for keep asking but any solution yet ?

[all-the-vb]

Sorry for keep asking but any solution yet ?
i don't no what your problem with this code
and it worked with all,
delete only this code
and anyone want see referrals numbers
go to user profile. :ermm:

[Battle_Ring]

is there a way to give the main admin the refer if the person registerign dont put down a referer

[Lionel]

Hi, it works for me except the received email has no subject, even though it shows on the form

[DWard]

Not sure if it has been raised yet, but the navbar doesn't display on the send invitation page... so you will need to do this:

Find:
eval('print_output("' . fetch_template('inviting_form') . '");');
Above, add:
$navbits = construct_navbits(array('' => 'Invite new user'));
eval('$navbar = "' . fetch_template('navbar') . '";');

[allhandl]

just loaded this hack however I have the same db issues as snowbot.

was there ever a fix snowbot? if not did you just delete the whole hack?


Database error in vBulletin 3.0.3:

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 2

mysql error number: 1064

Date: Wednesday 29th of December 2004 07:00:55 AM
Script: http://www.newarknight.com/forum/showthread.php?p=168
Referer:
Username: Unregistered
IP Address: 65.54.188.102

[hello]

how do i make it so that it doesn;t not keep putting the 1st admin as the referer because it looks a bit odd

[MajorFm.com]

Im getting a error, please advise, on clicking the following link:

http://www.majorfm.com/forum/register.php?refuserid=1

i get:

Parse error: parse error, unexpected ')' in /usr/local/apache/www/crazyapes/majorfmforum.com/htdocs/forum/register.php on line 123

[MajorFm.com]

ok i fixed it... thanks, great hack!

[T3MEDIA]

Is there a way to have people join by referals only?

That would be hot. like gmail.

[MajorFm.com]

ok there is a problem with this and i need help asap please...

Even if a new member doesnt click my link, uses the normal register link and leaves the referrer box empty, its going under my referrer id, please advise!

My referrer id is 1

[MajorFm.com]

ahhhhhh im running a competition and we are getting about 100 members a day and most of them are going under my name!! WHY? i did not reffer them! the refer box was empty! can sum1 help?

[allhandl]

major,

there are quite a few of us with that very same problem here. To date i havent seen a fix for it that works.

I think your gonna have to take yourself out of the mix or dont let the users see the statistics. This hack appears to be un-supported.

[T3MEDIA]

Gota love vb.org. Gota pay to be here to test free stuff on your own site.

[MajorFm.com]

major,

there are quite a few of us with that very same problem here. To date i havent seen a fix for it that works.

I think your gonna have to take yourself out of the mix or dont let the users see the statistics. This hack appears to be un-supported.

I can't believe it, this is drivin me mad... lol

I got nearly 500 people sending me congradulations for getting so many members, its gotta be something simple, if the user doesnt come from any link, it doesn't go as a refferal to any member, any other coder willing to help us with this... i/we would really appreciate it!

[MajorFm.com]

$5 for the first person that can fix it via paypal!! :p

This is causin even more headache now as i have uShop installed and coz i got so many referred members, i got about 1500 points!!! :devious:

I can't even un-install it as i have about 200 members useing the links which they have posted here, there and everywhere...

Need help...

Anyone...?

[MajorFm.com]

*bump*

[MajorFm.com]

ehum....

[MajorFm.com]

Anyone? this has ****** up my forums man, when the new user enters a username in the referrer box, it still goes to me...

Can someone please help?

[Marco van Herwaarden]

Had a quick run through the code and didn't see a reason why it would use userid = 1 (if i understand you correct) in case no referer is given.

Will do a test install and test to see what i can come up with tomorrow.

Please bump again if i haven;t replied by tomorrow afternoon (CET).

[Skyline_GT]

is it possible to register only on invitation?
so normally you don't allow for guest to register unless you have a inivitation link.

[Marco van Herwaarden]

$5 for the first person that can fix it via paypal!! :p

This is causin even more headache now as i have uShop installed and coz i got so many referred members, i got about 1500 points!!! :devious:

I can't even un-install it as i have about 200 members useing the links which they have posted here, there and everywhere...

Need help...

Anyone...?

Think i found the problem.

Open your file 'register.php'.
Find:
$testreferrerid['userid']=$testreferrerid;
Replace this line by:
$testreferrerid['userid']=$refuserid;

This should fix your problem.

[MajorFm.com]

I now get the following error

Warning: chdir(): No such file or directory (errno 2) in /usr/local/apache/www/crazyapes/majorfmforum.com/htdocs/forum/referrals.php on line 29

Please advise...

...and its only showing my referrels... but it has seemed to have fixed the all registrations under my name problem...

[MajorFm.com]

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

[Marco van Herwaarden]

There is no file called ./referrals.php in the standard vBulletin distribution or in this hack.

Seems to be a custom script, or a script from another hack. Without more info i can't help you on this.

PS It would help if you posted the contents of this script here.

[MajorFm.com]

My apologies, your right, it was another hack, i need to make sure the other one is working again so i can test this one... thanks for your help!

[ekool]

The subject line doesnt work for me either, it just comes through blank.. I suspect it may be qmail related?

[MajorFm.com]

Think i found the problem.

Open your file 'register.php'.
Find:
$testreferrerid['userid']=$testreferrerid;
Replace this line by:
$testreferrerid['userid']=$refuserid;

This should fix your problem.

Problem finally fixed, thank you...

[iSpanish]

Nice hack all-the-vb

Thanks 3dam

installed

[H2k]

:rolleyes:


try this:

open File: includes/functions_showthread.php

find:

if ($vboptions['usereferrer'])
{
$refcount = @$DB_site->query_first("SELECT
COUNT(*) AS count FROM " . TABLE_PREFIX . "user AS user WHERE user.referrerid =
$post[userid]");
$referrals = @vb_number_format($refcount['count']);
}


Replace it with:

if($bbuserinfo['userid']!=0 AND $post['userid']!=0){
if ($vboptions['usereferrer'])
{
$refcount = @$DB_site->query_first("SELECT
COUNT(*) AS count FROM " . TABLE_PREFIX . "user AS user WHERE user.referrerid =
$post[userid]");
$referrals = @vb_number_format($refcount['count']);
}
}

very good hack .. i was searching somethign like this

when my board is closed from new Regisiter only the member whe is already Regisiter in the forums can invite their friend..

Or regisiter for them or just send them the new password and user name .. anyway nice hack :)

[Thug]

how many ppl can u mail at 1 time? please pm me the answer

[all-the-vb]

Originally Posted by MarcoH64
Think i found the problem.

Open your file 'register.php'.
Find:


$testreferrerid['userid']=$testreferrerid;


Replace this line by:


$testreferrerid['userid']=$refuserid;



This should fix your problem.

thank MarcoH64 for help :)

[Marco van Herwaarden]

Your welcome :D

[hoangminh]

when I send invite to my friend to register, http://www.tinhyeutraiviet.com/forum/register.php?refuserid=6, but when enter next steps, refuserid=0 (view source) and at the enter profile information screen, the Referrer still appear with empty input.

And if new member submited data, he was registered, but the old member (userid=6) is not the Referrer for this new member.

Please help me !!!

[BradM]

when I send invite to my friend to register, http://www.tinhyeutraiviet.com/forum/register.php?refuserid=6, but when enter next steps, refuserid=0 (view source) and at the enter profile information screen, the Referrer still appear with empty input.

And if new member submited data, he was registered, but the old member (userid=6) is not the Referrer for this new member.

Please help me !!!
Seems to be a script problem. This thing was just poorly written. I am stripping it out of my code now. Waste of time.