That is wierd then, I don't get that, and I have checked with many other hacks and all of them are set-up the same way as mine... I even followed this thread on creating hacks and other modifications for vb3.x.x

How to create vb pages??

** ALSO PLEASE NOTE: DON'T USE GENERIC_SHELL... Thats has nothing to do with this hack anymore.. **

REMEMBER TO CLICK INSTALL AS WELL ONCE YOUR HAVE IT ON YOUR SITE.

Heh.. nevermind. It's not that. It's the adcolumn hack which will not cache for anything.

GSpot, can you PLEASE message me when you get on. I keep not seeing you for days wondering when you will appear. Thanks. :)

Are you going to be adding a pagenav to this so we can list all of the referrers? ;)

You can list all the referrers, just by not giving it a limit in the referals.php page.

And what happens when you get 100 or 150 of them and no pagenav? ;)

yeh i was on about pagination earlier :P

Still working on the pagination scripting... :( sorry for the delay guys

naww don't be silly

we appreciate your work :)

I have installed and it is working fine....nice work :)

Ok -- what's the secret format for the //path to your vbulletin directory?

I getting the below error


my forums are at www.moparstyle.com/forums

For you it would be: /home/moparsty/public_html/forums/

REMEMBER CLICK INSTALL :)

Ok thanx -- that got me one step further -- but now I have a blank screen

http://www.moparstyle.com/forums/referals.php

Suggestions?

I modified includes/functions_online.php and uploaded it

I created the two templates (in one of my 12 styles to test) in my 64 Imperial style

I added the path to the referals.php and put it in my main forum directory

I added the call in the footer of the style with the templates http://www.moparstyle.net/forums/index.php?styleid=36

But I get a white screen.

Fixed -- I gave the full URL to the referals.php so I could also use it in the footer of the Portal.

Thanx

I'll click install as soon as I update the other styles.

I'm missing the big picture here -- how does it relate new members to the person that referred them? Is this something that occurs this moment forward as a person registers?

I already have an extra field in the user CP that has the person registering leave the name of the person refering them. Any way to use that data?

What version are u using for vbulletin? This hack is to show statistics on referrals that have been made. For instance, if you referred 5 people, it will show the 5 people you referred as well as a count of referrals for you which would be 5 and your username as the referrer. This is just for statistics. I'm currently finishing an addon for this hack that will be used for competitions. Say you only want to show statistics for members who have referred new members that have posted a certain amount of times. This will show the results based on this condition. Hope this helps.. By the way, did you get it up and working??

** Change that I have visited your site and you didn't copy and paste the information for the templates correctly. Please re-copy the templates and make sure they are named: refer & referbit .. Then this hack will work properly, it works for all referrals made prior to this hack and for future referrals. :)

this is the template refer

this is the template referbit

I copied and paste exactly as the .txt file instructed. Am I seeing something different than you?

although the instructions has referbit (singular) -- I see the refer wants to call $referbits (plural)

That doesn't matter.. It's how the script actually works. Do you actually have members at this time that have made referrals?? Please feel free to AIM me my username is: gspot003

I changed $referbits to $referbit in the refer template -- but that didn't change anything.

What I don't understand is what is the link between the referrer and the referred? I tried a throwdown registration -- and I was not asked who referred me. No where in the instructions did I do anything to perform a database modification.

These were the instructions from the hack I downloaded earlier today.

I've gone over the steps outline above, plus the path to my forum in the referal.php, and put that in my forum's directory. I've had a long day and it is possible that I'm missing something obvious -- but I've gone over the instructions many times and can't see it.

I might also suggest that it may help alieviate a little confusion if your above instructions indicate what directory to upload the referal.php file to -- and a little clarity on the directory change you need to make to the file first.

In your admincp panel make sure that under vbulletin options - user registration options - you have selected to use the "user referrer". This will give a credit towards each referrer in which the referred member has signed up from them. Automatically adding a field in the user registration for this to work, once you have this feature enabled.

Ok -- I misunderstood how this worked. Instead of referral by a link -- I thought it was a question asked in New User Registration "Who Referred You?"

Thanx

Actually it's by both.. No matter if you follow a link with the referrers information or if you type in the referrers name during registration. It will work the same.. But you wont see any statistics until someone has referred someone else. No matter in the past or in the future.. :)

OK -- I'm back to confused again since I tried a throwdown registration and didn't see anywhere the referrer's name was asked in a new registration.

Was something suppose to be modified in the database (because I didn't see it happen) to add a field for the name of the person that referred a member?

YES, you do have a referrer spot in your new user registration. Please see the attachment.. You will only get statistics if someone has referred someone else. But, they have to either type in the members name in this field during new registration, or they have to follow the link sent to them by the use of your other hack refer friends..

If you still can't get it, I would be more than happy to check out your settings myself, if you want to give me access. Else, I would recommend you to seek some assistance by a website designer. Many people have installed this hack with no problems. Just read the instructions word for word and everything should work properly. :) GOOD LUCK.

got this database error when i click on the "refer stats" link any ideas???

Database error in vBulletin 3.0.1:

Invalid SQL: SELECT COUNT(*) AS referrals, user.username, user.userid FROM user AS users
LEFT JOIN user ON (users.referrerid = user.userid)
WHERE user.userid > 0
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT 10

Did you use a table prefix while installing vbulletin? If so you will need to edit that query to fit your tables database prefix...

There should have been more to that error as well, if you can please post it all. :)

here is the rest of the error message. Yeah it looks like that table does not exist. Umm if you could point me in the right direction that would be swell :)



Invalid SQL: SELECT COUNT(*) AS referrals, user.username, user.userid FROM user AS users
LEFT JOIN user ON (users.referrerid = user.userid)
WHERE user.userid > 0
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT 10
mysql error: Table 'precisi_forums.user' doesn't exist

mysql error number: 1146

Looks to me that u need to change all instances for the mysql querys that have "FROM user" to "FROM precisi_forums.user" since you used a table prefix when installing vbulletin. So edit the referals.php file to meet your needs.. Let me know. I hope this helps.

Samething. does the table have to be created in the database? thanks for all your help by the way :)


Database error in vBulletin 3.0.1:

Invalid SQL: SELECT COUNT(*) AS referrals, user.username, user.userid FROM precisi_forums.user AS users
LEFT JOIN user ON (users.referrerid = user.userid)
WHERE user.userid > 0
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT 10
mysql error: Table 'precisi_forums.user' doesn't exist

mysql error number: 1146

Very simple fix. In the referals.php file

Find:

REPLACE it with:

Umm you want me to replace the code i find with the same code? still got the error. sorry to be a bother.

Database error in vBulletin 3.0.1:

Invalid SQL: SELECT COUNT(*) AS referrals, user.username, user.userid FROM user AS users
LEFT JOIN user AS user ON (users.referrerid = user.userid)
WHERE user.userid > 0
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT 10
mysql error: Table 'precisi_forums.user' doesn't exist

mysql error number: 1146

I changed the second line in the query to user AS user ON. Anytime there is a table prefix being used, all tables must must delared like that in a query if you are accessing more than one table in the query.

same error message as post #73

TRY THIS:

AND THEN CHANGE THE OTHER QUERY TO:

Once those changes are made, that should work.. Just let me know. :)

Did this work for u?? :speechless:

Samething. I think i am doing something wrong here. it cannot be that difficult. also everytime i have to run queries for any hack it gives me an error. I am in the middle of building vB3.01 for an upgrade from vB2.3.4 so it is just in a test directory. Could this be causing my problems? I did set up a new database to run the test dir. ugh this bites. Thanks for all the help.

Database error in vBulletin 3.0.1:

Invalid SQL: SELECT COUNT(*) AS referrals, user.username, user.userid FROM precisi_forums.user AS users
LEFT JOIN user ON (users.referrerid = user.userid)
WHERE user.userid > 0
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT 10
mysql error: Table 'precisi_forums.user' doesn't exist

mysql error number: 1146

What about the LEFT JOIN table? ;)

Did you make this test site for vbulletin with a table prefix?? If so, please post the prefix that you used for the installation of vbulletins sql tables.. This will help me eliminate the problem you are having.