Hey VB developers!! Don't miss this thread, there's definitely issues with the php vbcode!! The above "&n" actually reads "LIMIT 100", even when I edit it but no matter what i do it shows as &n
weird.

note that the code I gave you got chopped, run it w/ the limit 100...

I thought an extra row may show up w/ some missing data....if not I'll look at the code again....somehow reflistbit is being called one time too many...

I had to take out the &n because it said it was an invalid SQL statement... Could that be the problem?

You have an error in your SQL syntax near '&n LIMIT 0, 30' at line 7

since the php vbcode isn't working, once again, here's the proper code to try:

"SELECT COUNT(*) AS referrals, user.username, user.userid FROM user AS users
LEFT JOIN user ON (users.referrerid = user.userid)
WHERE users.referrerid <> 0 AND
user.userid NOT IN (0)
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT 100"

You have an error in your SQL syntax near 'LIMIT 0, 30' at line 7

You're using an old version of phpMyAdmin....just pull off the LIMIT 100 portion...then scan the results.

If there's more than 30, be sure to go to the next page and check that every line is ok.

I am using the newest version of phpmyadmin... Everything that was pulled with that SQL looks alright... BTW whats your URL?

My boss won't let me post my url :(

OK, I have a question. How many rows were returned from the sql statement? It should have been 7.


Josh
Kckazdude
pug
DonnieD
cryzten
1gigkid
Andrew

Yes, that is correct. Maybe its just a mistake in the php file or one of my templates...

I'm looking but this is very weird. Your reflistbit template is being called 8 times. If you view the source of your page you can see that and count it yourself. But the code will only loop thru as many times as your mysql statement comes back with...so how it can call the template 8 times when there's only 7 rows is just wacko.

found it!

Pull out

eval("\$reflistbits .= \"".gettemplate("referrer_listbit")."\";");
$referrerlist="";

from AFTER the TOP REFERRER section and you'll be fine...you WERE calling that listbit 8 times!

Thanks so much!

Thanks everyone. I've got a JS pop up hacklette which lets your members send an email with the referral code automatically inserted.

See:

https://vborg.vbsupport.ru/showthrea...838#post212838

demo please. :(

I requested this in the request thing & bumped myself..

What I would like to see is some kind of hack where I can let users donate their gained referral points to other users.

Let say I as an admin have 5 points, and wich to give it to userX, it would be nice of I could select a referral and type in a referrers name. So he gets the points.

If this is not possible 1.2.3, then I would be happy with a script in the admin dir, which makes it more easy to do , then running manual mysql query's to replace referral points.

It's a really great Job, Thanks
But, is there a way to insert the top 10 referals at the bottom of the main page of the forum,
please help

could someone please elaborate on the above instructions??? i understand the rest of them except those..

1. where does referrerlist.php go? whats Config $shownorefs??
4. ??
5. ??

Can we get new instructions for vb 2.2.6, cuz the top referrer on forumhome thing doesn't seem to work!!

nice

Any working demos?

All the ones in this thread seem to have 404 errors.

Um...In this thread I see 5 pages with big chunks of code in each post, and it seems as if the original post hasn't been updated.

What is the correct code to make this hack work? Is it in the original post?

I'd like to see this updated, with a final .txt of the least load version or whatever in one place. :) dwh's? It's not all in one place and the thread got nuts...

Anyone up to it?