Try this file. I have edited it, make sure that you have all your setting correct in it though. And please let me know if it works for you. :) This is set up to not count users in usergroups 1,3, and 4

It works! awsome. I couldnt understand the lingo but I see now what you mean.

I am very intrested in having this only accept people who refer new users and the people they refer also refers a person. (WAHHHT?)

I am giving away on my site $100 to each user that refers 5 people. the only catch is the 5 have to be full members and have to refer 5 themselves. (the last 5 dont have to be full members). of course the next set is 90% near their 100$ All they have to do is make sure their 5 also brings 5. It will start a large boost to the site.

In other words you have to bring someone that knows 5 people. (You would need to know 5 people in total like this to win the money)

I am willing to make a donation if you can do that for me.

Excellent mod here! I installed it and then setup a contest where the most referrals in a month earns them an award that goes under their avatar that I setup a basic conditional for. So far this has been very productive, thanks!

t3media - sorry man, that would require a lot more hacking for this hack... I dont have the time right now since I opened a new business. :(

Sorry, but thanks for installing. :)

hey you do what you can right?
That is good enough for me.

I think I did everything right but heres what i get
Database error in vBulletin 3.0.3:

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

mysql error number: 1146

Date: Saturday 01st of January 2005 10:29:39 PM
Script: http://www.djjeffa.com/vb/referrals.php
Referer: http://www.djjeffa.com/vb/home.php

any ideals?

Hi... Great Hack

/me Clicks Install

I would suggest something liek this for a referral promo..

Refer 5 friends and those five refer another 2 each and be eligible to win something as a Prize. We could probably have another few levels of referrals.
Besides...each referred person again can be eligible for the prizes based on referrals.
And similiarly on those lines.

Any help on this ... much Appreciated

Also, does this work with Erwin's refer a Friend ? or works as a stand alone hack ??

Thanks

djeffa - it was a problem in the referrals.php file. ITS BEEN FIXED.

PurpleCow - Someone else even recommended this addon for my hack, I will start looking into it, but however it may take me a few weaks to release it. Thanks for clicking install :)

I dont suppose u can help with this:

https://vborg.vbsupport.ru/showthrea...t=67407&page=3