Refer Script

[kaz]

Its a script that displays all referers and all people who have visited your site from where, including search engines, its miles better than the awfull 300 latest visitors that cpanel gives, it displays them in simple format, and it takes 10 seconds to install one mysql table, the problem is, that I cant install it, can someone do this? Ive attached the file

Refer.zip

[TCH-Thomas]

There seems to be some installation instructions a bit down on this page. Have you tried them?

[TCH-Rob]

I installed it following the instructions on the page Thomas gave the link to. What problems are you having when trying to install it?

[carbonize]

I stopped paying attention to referers that much due to the fact that spammers are sending fake referers in requests to sites in the hope that the site is showing a list of referers somewhere.

[kaz]

I installed it following the instructions on the page Thomas gave the link to.  What problems are you having when trying to install it?

<{POST_SNAPBACK}>

 

Please can you do it for me? The problem is I get a MySQL error when trying to install it Very Strange as my details are correct ive doubled and trebble checked

 

I stopped paying attention to referers that much due to the fact that spammers are sending fake referers in requests to sites in the hope that the site is showing a list of referers somewhere.

<{POST_SNAPBACK}>

 

Erm .. say what?

[marie b.]

What is the error? That script should only take a couple seconds to install.

[kaz]

What is the error? That script should only take a couple seconds to install.

<{POST_SNAPBACK}>

 

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/deathea/public_html/setupdb.php on line 48

 

Warning: in_array(): Wrong datatype for second argument in /home/deathea/public_html/setupdb.php on line 52

could not create table refer2

[marie b.]

Are you sure that your database information (including permissions) is correct and correctly entered in refer.php?

 

I just set this up on another of my domains in the last few minutes, and it works perfectly.

[kaz]

All details I have entered are correct, permissions? There should be nothing to do with permissions im the webmaster I have permission over everything. I used a MySQL creation database from CPanel

[marie b.]

You must add permissions for each user when you create a new database.

 

You should have a user and a database, with permissions (usually 'ALL') set between the two.

[kaz]

Dont know what you mean nor how to do this

[marie b.]

Go to the place where you created your MySQL databse.

 

At the bottom, there's a place to create a user ID and to assign permissions to a database.

 

Select the User ID and the database, then click the ALL box.

[kaz]

I created a new user with permissions to all on the refer database and updated my config but still get

 

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/deathea/public_html/setupdb.php on line 48

 

Warning: in_array(): Wrong datatype for second argument in /home/deathea/public_html/setupdb.php on line 52

could not create table refer1

[carbonize]

Please can you do it for me? The problem is I get a MySQL error when trying to install it    Very Strange as my details are correct ive doubled and trebble checked

Erm .. say what?

<{POST_SNAPBACK}>

 

 

What I mean is that spammers are sending requests to your site for webpages and putting in a fake referer in the hope that you have a publically available list of refers

[marie b.]

I'm trying everything to see if I can re-create that error, and I'm just not getting anything. I've no idea.

[TCH-Bruce]

When you enter the database name and database user are you entering it as: yourcpanelname_databasename and yourcpanelname_username?

[kaz]

When you enter the database name and database user are you entering it as: yourcpanelname_databasename and yourcpanelname_username?

<{POST_SNAPBACK}>

 

 

Yes, my cpanel name is "deathea"

 

My code is (for the file refer.php)

 

Never mind done it!!!!!!! thanks everyone the problem was I had

 

$dbname='somethinghere ';

 

and I had a space after the name, it should be "dbname" not "dbname "

 

Edited August 9, 2005 by kaz

[kaz]

Wait Im getting this error in refer.php

 

Fatal error: Cannot redeclare rcfg() (previously declared in /home/deathea/public_html/refer.php:22) in /home/deathea/public_html/refer.php on line 17

 

Line 17 Reads

 

function rcfg()

 

 

and line 22 reads

 

 

>[I]$rcfg['usr']   = 'deathea_superman'; [/I]     //line 22
$rcfg['pw']    = 'xxxxxxxxx';      
$rcfg['host']  = 'localhost';   
$rcfg['db']    = 'deathea_oicaracta';      
$rcfg['table'] = 'referdata';