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

[Freddie Bingham]

This is a *bad idea*.

[Matt]

Here it is....

[Recluse]

Originally posted by freddie
This is a *bad idea*.

why? just wondering :lick:

[Matt]

I was about to ask the same *lol*

[Admin]

Originally posted by freddie
This is a *bad idea*.

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 )
It should give you a basic idea of how to implement this.

[Matt]

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*

[Matt]

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?

[Admin]

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.

[Matt]

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