Nice update -- thanks again Dean.

If anyone is seeing the "Unknown modifier" warnings below (due to running an older version of PHP, like 4.1.2 in my case), you can put "error_reporting(0);" near the beginning of the refer() function to hide them. Everything seems to work fine despite the warnings.

Warning: Unknown modifier 'p' in /export/home/johnk/www/refer/refer.php on line 122
Warning: Unknown modifier 'r' in /export/home/johnk/www/refer/refer.php on line 122

John
http://johnkeyes.com/

Edited by author 06-23-2003 11:21 AM
I've just upgraded to 2.01, and I'm getting a tiny PHP error at the top of index.php: display.php%[»?»?ÂmBIN‚?¨–

This looks like something that might happen if the file was uploaded in binary, so I checked that (text format), emptied my cache - still there. Any thoughts welcome - thanks for the update!

Anyone else getting an 'Cannot open file: it does not appear to be a valid archive' error on the refer201.zip?

Here's my error (in setupdb.php):

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /path/to/my/doc/root/refer/setupdb.php on line 42

Warning: in_array(): Wrong datatype for second argument in /path/to/my/doc/root/refer/setupdb.php on line 46
could not create table mytablename

buh?

Edited by author 06-23-2003 02:07 PM
no problems getting it up and running, it's just picking up referrals from the same domain with I use auto_prepend_file. would be nice if refer ignored those.

thanks dean.

-jason

Edited by author 06-23-2003 03:10 PM
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /.../refer/display.php on line 254

when I try to glimpse things.

email me if you figure it out

i just deleted the table and created it again, and it works. completely. so the problem must have been when I ran setupdb.php to update it...

thank you for the release of 2.01
i didn't get 2.0 to run at all, but the new version works perfectly for me

Quick question that I know someone can answer: is there a way I can tweak Refer 2.01 to display all page loads, including those with no referrers (i.e., when someone types my site directly into their address bar or clicks their bookmark)? I love the Refer interface and organization and would like to have both referrals and plain page loads listed together (the latter would have nothing in the "from" column, of course). Thanks to anyone who can help, and thanks again to DEAN DEAN DEAN. ;)

Edited by author 06-23-2003 11:40 PM
Is it just me, or is the "Next ->" link working incorrectly? Mine continually says "next 6", despite the fact that there are a number of pages of 50 following it.

http://coinz.org/about/referer/

I also needed to make a slight change to refer.php to get the URI functionality to work on my Windows 2000/IIS 5.0 box.

// $uri = dbPrep('REQUEST_URI');
// Windows 2000/IIS 5.0 fix
  $uri = dbPrep('SCRIPT_NAME');

Other than that, this new version cooks. Thanks, Dean.

Edited by author 06-24-2003 11:08 AM
There are a few things which worked well with my setup in Refer 1.0, but now in 2.01 they do not work:

In the exclude list, I want to exclude any referrers from my MovableType installation, which starts with the following URL: homepage.macos.net/~drubin/

• In Refer 1.0, I just had to list the above URL snippet in the exclude list, but now, Refer 2.01 will not accept the tilde (~) as a valid character. Please fix, or let me know how to fix this.
• The "from" column used to show just the top-level URL, with the entire link to the referring page in the link itself. This worked much better for a fixed-width layout (which my site currently uses), but now Refer 2.01 lists the entire URL in the column, which makes the table cell (and thus, the table) resize to the width of the longest referrer URL. This is not as useful as the old behavior.

Otherwise, the only thing I'd like to see is a way to transfer all my old referrers from Refer 1.0 to the new table -- any ideas? I would like to archive my referrers for a long period of time, if possible.

Cheers,

Dan (http://superfluousbanter.org/)

Edited by author 06-24-2003 04:38 PM
Dan - Here's how I'd suggest going about it. It worked for me in my development environment. Going to update prod this evening.

1) Change the 'time' column's type in the 'refer' database to varchar(14)

2) Execute the following SQL (assuming you are upgrading from version 1.x):

INSERT refer (time, host, page, refer)
SELECT log_hits.time,
 log_hosts.host,
 log_pages.page,
 log_refers.refer
FROM log_hits
LEFT JOIN log_pages on log_pages.id = log_hits.page
LEFT JOIN log_refers on log_refers.id = log_hits.refer
LEFT JOIN log_hosts on log_hosts.id = log_hits.host
WHERE log_hits.refer > 0

3) Change the 'time' column type back to timestamp

4) Run the following query to populate any empty page fields (otherwise they'll be discarded):

UPDATE refer
SET page = 'index.html'
WHERE page = ''

Note: You should replace index.html with the name of your main home page filename

You now should have your archives imported.

Edited by author 06-24-2003 05:07 PM
setupdb.php sets the table name as 'refer' and ignores the $table variable from refer.php, which gave me a few errors on my first attempt at installing. To avoid errors, leave $table as 'refer' in the refer.php file. I think you can rename your table and change the variable later, if you want.

(This should be pretty easy to fix in future versions, right Dean?)

Just updated to Refer 2.01 and it seems that the code I have to add in the .htaccess file breaks my index.php page in IE for PC. All this browser sees is a blank white page, although on every mac we checked, there was no problem at all. Thank for any help.

This is the first time I've attempted to install Refer, and I'm not terribly up to speed with MySQL. I've gone back and forth with my webhost, and everything appears to be configured correctly (.htaccess is fine, php is working, etc.). However, when I run setupdb.php, I get "Database connection OK. Create refer table?" with a "create" button, and when I click "create," nothing happens. The page just reloads. Then, if I attempt to load refer/index.html, I get the following --

Warning: Supplied argument is not a valid MySQL result resource in ./display.php on line 272

-- because setupdb.php is not creating the table. Any ideas?

Dean, you rock! Refer rocks! No problems. Just gratitude. Thank you.

Yegads, I was wondering why this support list was so quiet, and now I see that, unlike the 2.0 list, I have to subscribe manually. Piddle.

Dale, try removing the

DirectoryIndex index.html index.htm index.php

line from .htaccess

Daniel,
Thank you, yes, there are two other places where it's relying on the database table to be called 'refer' instead of whatever you set in prefs.

This is fixed in 2.02.

"Unknown modifier" messasges and filtering failures due to special characters should clear up in 2.02 - I'd neglected to escape those for regexp matching.

I did try removing

DirectoryIndex index.html index.htm index.php

but those on IE6 PC still get a blank page.

weird.

Um... never mind w/r/t my message below. (Sigh.) My hosting provider had failed to mention that while they are indeed running PHP4, they're not running it on the server my site is currently on, but on the server I'm going to be migrated to soon. Grr.

I have a question or maybe a suggestion for the next release of Refer.

I'd like to view only the IP-numbers of people instead of the name of the provider. Is that possible somehow? And is there a way to make a choice between - viewing provider name and viewing IP-numbers?

Edited by author 06-27-2003 10:30 PM
i sincerely hope i'm not doing something completely stupid and just overlooking it, but i cannot get this to work. i've installed it just fine and everything -seems- to be working, but it's not catching any referrers at all. what would be a common cause for that? and yes, my pages are php-aware....i've been using php for quite some time now.

Edited by author 06-28-2003 07:05 AM
Just bumping message #2, all the way back at the beginning; any thoughts?

When I try downloading the zip file, it says it has an invalid archive. Why is that?

There is something wrong with the download.

After trying various configurations I managed to get a table of all my recent hints, including all the running hits I am making while checking, but it doesn't seem to be registering anybody else's hits (I do know there is traffic to the site).

Any suggestions how to fix this?
Thanks.

I'm using refer 2.01 but every referline is showed twice ! And I only changed the userid/password stuff in the refer.php file ?!

Are there any security concerns I should be aware of. Installation was easy I like it.

strike mine, figured it out. :)

The best remedy seems to be: just leaving it alone. Eventually everything will fall into place.

It's working.

I don't know how, but thanks, let's see how it goes.

I used to use an old release and everything worked fine.

However, I recently upgraded to 2.1 and whilst it says it installed fine, I am not showing any referrers: http://www.tankgreen.com/refer/

When you look at - http://www.tankgreen.com/refer/refer.php - you can see I am getting an error message. I am not familiar with php to understand it.

Any help would ge grately appreciated.

Thanks!

Edited by author 07-01-2003 09:18 AM
tank, it looks like you may have forgotten to remove the script from your individual page files that was used in the old referrer script......it's most likely on the bottom of your files after the </html>.

thanks reb, but i double checked and all the old script is definitely gone.

any other suggestions..?

using the .htaccess method, how can i exclude specific folders/files from being tracked?

How can I block my IP address so that it doesn't log my visits? I frequently update my site and refresh it a couple of times. Thanks!

Hello, I just installed refer 2.01, created a table on a MySQL database, all went well, added the lines in the .htaccess file, everything ok.

When I try to see the stats I receive this:

Fatal error: Cannot redeclare refer() (previously declared in /home/alt1040/public_html/refer/refer.php:97) in /home/alt1040/public_html/refer/refer.php on line 95

URL: http://ALT1040.com/refer/


Hope anyone can help me....

Question #1: Does it record visitors from other pages of my site?

Question #2: If I want it to keep the old referrers forever, what do I do with the $expire variable? Do I set it to "0" or some infinitely big number?

Also, after making this change, do I just have to upload the config.php file, or do I have to re-create the table?

Thanks everyone.

Edited by author 07-04-2003 09:36 AM
Can any tell my how to exclude any url that's STARTS with www.flabber.nl/123

www.flabber.nl itself should be recorded !

$exclude[] = 'www.flabber.nl/123';
in the refer.php file doesn't seem to work :-(

Where abouts do you find the </html> tag in order to append Refer's record-only-this-page tag?

<?php include '/refer/refer.php' ?>

Great script, I have it running at http://john.hoke.org/refer.php inside a MovableType site.

I hacked up the code to change the way it displays information, so if anyone is interested in what I did, let me know via the contact form on my site.

since my post is slowly going away lol, using the .htaccess method, how can i exclude specific folders/files from being tracked?

I'm trying to view the RSS feed (index.php?format=rss) in my news aggregator, but it gives a parsing error "XML Parsing error: :2:0: xml declaration not at start of external entity".

I poked around trying to find a quick fix solution, in tweaking some of the code, but I couldn't get it to parse correctly. Any ideas?

I would also like to know how to block certain IPs or hosts from being logged. Is this possible? Thanks.