T3MEDIA - OPEN UP REFERRALSTATS.PHP

FIND:
$info=$DB_site->query("SELECT * FROM user WHERE username = '".$_POST['member']."'");

REPLACE WITH:
$info=$DB_site->query("SELECT * FROM " . TABLE_PREFIX . "user WHERE username = '".$_POST['member']."'");

Sorry - I forgot to add the table_prefix to the script on this option. This will be fixed in the next release. :)

http://www.wizarding-wireless.net/referrals.php

I'm helping a friend with her board.

Anyhow, I'm getting that line 18 error thingy and I've installed it correctly. I have the path set as www.wizarding-wireless.net/ and everything looks fine but that one thing.

I'm not sure what the deal is? She has a table prefix of vb3_ does that need to go somewhere in the referrals.php file?

This one is fantastic however. I have the older version on my board and I totally need to upgrade, LOL.

The path is the absolute path for example: /home/wizarding-wireless/public_html/forums/

If you dont know the absolute path, contact the hosting company to find out. :)

I had the same problem but instead of posting the full directory i just put a / where Im suppose to put the full directory and that worked.

Ah - I'll try both and see which one works - thank you to you both :0)

edit: the / worked :) Thank you Babolo :)

babolo - please click install if you have installed my hack. And I had no idea that would work. :)

Hey man... that is why we are wokin' together... catch all the bugs!

It would be nice to remove referrals from this list while not touching the over all vbulletin list. in other words jen got 10 new members. peter got 5. that is 15 in all. reset... now jen has 0 new members but has 10 from the past. peter has 1 (joinned last night) now he has 6 1 now and 5 from the past...

then the global erase will remove everything.

No problem

lol sorry... sometimes I forget.

I have downloaded this hack and as soon as I upgrade from 3.06 to 3.07 I plan on installing, but I have a minor question; I see all the screen shots but does this referral stats allow a member to actually send a referral to someone or is that another hack I need?

ITs another hack you need. It can be found at https://vborg.vbsupport.ru/showthread.php?t=59708

I would like to thank you GSpot for all your effort in regard to this hack. What an amazing job you have done working out the kinks and providing everyone with such great support and such a wonderful hack!!

Since you seem to be the expert on this board when it comes to "Referal" type hacks, I was just wondering if there is any way that this hack could be adapted to meet this request from this thread?

Is there or can someone create a way for the following to happen?

A user(u1) refers two new users (u2)&(u3) to the site.
For every post that (u2) or (u3) makes, a tally(refered posts?) is given to (u1).

User (u2) refers user (u4).
For every post that user (u4) makes a tally is given to (u2) and (u1).

I would like this to be seperate from the users own post count.

The idea stems from a way to not only encourage users to refer new users, but refer quality users and continue to encourage them to be active members of the board. I see it like a pyramid scheme. User (u1) gets "points" for every post someone he refers makes. The tree continues down the line of referals. Damn, I wish I could explain it more clearly.

If possible, integration with a points system (uCash/uShop) would be great.

I think that it would be extremely useable and help a lot of forums out with gaining and retaining memberships and forum content.

If anyone has any ideas, I'd love to hear them. Please bear in mind I am not a programer or coder, just a guy with an idea. Feel free to tell me it's impossible.

Thanks in advance!!

P.S. When this wins hack of the month, please mention me in your acceptance speech. J/K

Installed, only problem I had was with a typo in the copy/paste peice during the editing of the footer link.

Otherwise, flawless.

Where is the typo? I can't find it.. :)

Also, I have edited this hack and a new release will be coming soon... I have added some great features into this hack including:
1) admin ability to add a 2nd navigation to the bottom of the results (on/off)
2) admin ability to show total number of referrals for each member since joined (on/off)
3) No more inserting your forums path manually. (auto fix)
4) Less queries
5) Bug fixed in reset referrals by member (thx T3MEDIA :) )
6) admin ability to show last reset date (on/off)

** I know you all still want the limit results by referrers referrals, but trust me I'm working on it and its a pain in the a$$... Can't seem to get it to work without way to many queries.. Huge server load...

Let me know what u think guys :)

Is there any way to get it to track referrals that become a part of a usergroup (i.e. follow through on a subscription)?

Greg

Ohhh GOOD one. Affiliates... Nice idea.

Any updates on the blank page when clicking referral statistics

debo - Im looking into it.

Actually this is already implemented guys :) all you need to do is insert in that usergroupid number that you want it to only track and boom there it is... :) ENJOY

Thanks ... I will work on that tonight ...

Thanks,
Greg

Fixed - See Edit at bottom of message
-------------------------------------------
Stats works wonderfully as long as I don't select any of the Limit By options.

When I select either the limit by posts or usergroup id's, I get the following database error (any recommendations on what to look for?):

Database error in vBulletin 3.0.6:

Invalid SQL: SELECT COUNT(referrerid) as getusers FROM user WHERE referrerid > 0 AND posts 9
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '9' at line 1

mysql error number: 1064

Date: Wednesday 16th of March 2005 08:38:36 PM
Script: http://www.barrreport.com/forums/adm...rralstatistics
Referer: http://www.barrreport.com/forums/admincp/
Username: Admin
IP Address: 63.162.87.195

***********EDIT**************************
This error is created if you do not set a "conditional" in the field:

That is / are:

Set the conditional to Equals and all works well ...

Greg

Same problem here.

You need to define your problem, if it is the same as gregs, read his whole post you need to have all the conditions setup if not tell me the error.. :)

He may not know how to edit his database to "fix" the problem ...

Once this error message is created, there is no way to fix it from the admincp without manually going into the database and editing limit1, limit2, and limit3 as necessary ...

There really *does* need to be an error trap coded to catch this "problem" ...

Greg

greg - I will have this fixed in the next release. Also please click install if you have installed my hack :) until then I will make a rollback file later tonight that you will need to run if you have this same problem.

FOR ALL OF YOU GETTING A BLANK SCREEN IN THE ADMINCP:

open referralstats.php and find:

// ########################## REQUIRE BACK-END ############################
require_once('./global.php');


After it add:

require_once('./includes/adminfunctions_template.php');
require_once('./includes/functions_misc.php');

Let me know if this resolves your issue. It should. :)

Once I figured out what the problem was (looking at the error message kind of made it obvious <grin> ... it was missing the conditional) ... then it was simply a matter of pouring through to code only to figure out that it was in the database ... fixing problems in the database is easy <grin> ... fixing code without breaking something else is a different story <grin> ...

I clicked install earlier ...

One sad thing about the Installl button ... it only lets you do it once ... I have 8 vBulletin licenses ... and your hack will be on at least three of them by the end of this weekend ...

Greg

Thats my error when I open up Referral Statistics... anyone else getting it or did I do something wrong?

Nevermind, I read a previous post that explained it, thanks.

Download this fix and upload it to your admincp directory. Open the file in your browser and once completed, delete this file from your admincp directory. This error will be fixed on the next release. :)

This will not fix the blank page error!!

so, if installing this hack, do we still need to use the above fix?

Only if you dont follow the instructions when limiting the referral results by either usergroupid or number of posts. Most people never got that error, but if you add a limit to the results, and forget to setup all limits, then yes youll need to run it once. But you should be fine. :)

How far away is the new version you talked about? Maybe a month, a couple of days.

I'm getting ready to install this hack and was wondering if I should wait.

NEW VERSION: to be released in the next couple of months :)

Thanks for that. Now I feel better about doing the install tonight :)

Will it keep track of total refferals "and" last time since reset per user?

Example:
Joe_user (26) 12

Where (26) would be joe's all time refferal count and 12 would be the number since last reset.

Not sure if you can view it but heres mine
http://www.discussionjunction.com/forums/referrals.php
It shows current and since joining.

Tried the usual fixes

Its the common one!

chdir(): No such file or directory (errno 2) in /referrals.php on line 18

I have set my path inside the control panel to what i see in ftp programs
/public_html/forum but it is still giving this error - even though the page actually works.

I also have trouble getting the vbadv page and the Vb forums pages to have working URLs.

Please help

Steve

I have followed the instructions to install this hack and now I got this mySQL error message on referrals.php:

Database error in vBulletin 3.0.7:

Invalid SQL: SELECT COUNT(referrerid) as getusers FROM vb3user WHERE referrerid > 0 AND posts =< 25
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '=< 25' at line 1

mysql error number: 1064

Date: Saturday 26th of March 2005 10:06:22 PM

Can someone please help me out?

Please disregard my last post but a lil issue still remains...

chdir(): No such file or directory (errno 2) in /referrals.php on line 18
on the referrals.php page

How can I fix this???

Whats your web address? I will try to help u get the full path.