Referrals In Postbit Template
 

I am not a master hacker *lol* and I spent a while trying to figure out how to get this damn thing to work!

Requested By : Mist

What Does It Do?
Simply allows you to use $referrals in the postbit template. This will display the users total number of referrals.

Hack temporarily Retracted ;)

This is a *bad idea*.

Here it is....

why? just wondering :lick:

I was about to ask the same *lol*

I haven't seen the file but I guess it adds a query per user on showthread.php.

Anyway, Matt, take a look at freddie's query here:
https://vborg.vbsupport.ru/showthrea...threadid=25170 (when I started and had no clue :eek: )
It should give you a basic idea of how to implement this.

Thanks for replying, Freddie vanished after he said that and I was totally confused by what he meant.

It did add a query per user yes. I will have a look into trying to get rid of that, just being new to all of this I saw it worked and posted. :(

Thanks again!

*goes off to try and fix it*

I was actually thinking of just creating a new table in user and storing the total referrals, as then I could just pull it out with the rest. Is that a bad idea?

It's either that or another query in showthread.php. I really don't know enough to tell you what's better performance wise, but I do have a feeling another field on the already busy user table for larger boards would be bad.

Thanks. I am just confused as to how you can get the info I need without looping through the members.