Previous Thread
Next Thread
Print Thread
Rate Thread
#19557 02/25/04 10:17 PM
Joined: Feb 2002
Posts: 7,203
Likes: 11
Community Owner
OP Offline
Community Owner
Joined: Feb 2002
Posts: 7,203
Likes: 11
Ok, I'm working on making an error handling script so that I can see who's exactly linking to what files... How it works is when a user clicks the link from an external site (such as google's link down below) it'll forward the person to the 403.php page which is my custom error page for access denied.

The script simply takes the server relayed data and inserts it into a mysql table "ugn_errors" on database "undergroundc". script_uri is only valid if the page has a referrer, if they don't have a referrer they wouldn't get the 403 error since it's set to allow nonexistant referrals.

Now, the problem is, when the page loads it loads fine, I couldn't ask for more, well other than it work. It doesn't give out ANY errors whatsoever, I had an if/else statement and it kept saying that it parsed correctly. However the data never got entered into the database.

Anyone care to take a shot?

MySQL table
Code
CREATE TABLE ugn_errors (
  id int(15) NOT NULL auto_increment,
  type char(3) NOT NULL default '',
  date timestamp(14) NOT NULL,
  ip varchar(15) NOT NULL default '',
  referrer text NOT NULL,
  file text NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
connect.php
Code
<?php
// Change below to your MySQL Host.
$host = "127.0.0.1";

// change below is your assigned mySQL username
$user = "myusername";

// change to the pw below is your assigned mySQL password
$pw = "mypassword";

// change to the database you have permission to connect to
$db = "mydb";
?>
403.php
Code
<?php require "connect.php"; ?>
<?php
$mysql_access = mysql_connect($host, $user, $pw) or die(mysql_error());
mysql_select_db($db) or die(mysql_error());
?>
<?php
	$ip = $_SERVER["REMOTE_ADDR"]; 
	$refer = $_SERVER["HTTP_REFERER"];
	$company = "VNC Web Design";
      $companylink = "http://www.virtualnightclub.net/";
      $scriptname = "Custom Error Manager";
      $linked = $_SERVER["SCRIPT_URI"];
      $type = "403";
      $name = "Access Denied";
{
?>
<?php
   mysql_query("INSERT INTO ugn_errors (type , date , ip , referrer , file) VALUES ('$type', NOW(), '$ip', '$refer', '$linked'");
?>
<html><head>
<title>Error <?php echo"$type"; ?> :: <?php echo"$name"; ?></title>
</head><body>
<center><b>403 Error: Access Denied</b>

</center>

<center>Your IP address of <?php echo"$ip"; ?> has been logged with the referrer of: 
<?php echo"$refer"; ?></center>





<center>
You are not authorized to view this page or file.  Most likely the address that you're linking to this file from is not authorized 
in our .htaccess file.  Please ASK to be added to this file, we don't appreciate direct linking to our files from un-authorized sites.  
We spend a lot on our bandwidth monthly just to have our generosity tornto shreads by sites who are too lazy to find their own original 
content.
</center>





<center>
Since you probably don't care about this issue (since all we wanted was the log of this error), for your convieniance, the requested 
file that you were linking to is:

<a href="<?php echo"$linked"; ?>"><?php echo"$linked"; ?></a>
</center>




<hr>
<a href="<?php echo"$companylink"; ?>"><?php echo"$company"; ?></a> :: <?php echo"$scriptname"; ?> :: Error <?php echo"$type"; ?> :: <?php echo"$name"; ?>

</body></html>
<?php
}
?>
#6 on the list will send you to the 403 error page (till I re-add google to my .htaccess file).


Donate to UGN Security here.
UGN Security, Back of the Web, and VNC Web Services Owner
Joined: Feb 2002
Posts: 7,203
Likes: 11
Community Owner
OP Offline
Community Owner
Joined: Feb 2002
Posts: 7,203
Likes: 11
In case you don't notice, the link is "#6"


Donate to UGN Security here.
UGN Security, Back of the Web, and VNC Web Services Owner
Joined: Dec 2002
Posts: 3,255
Likes: 3
UGN Elite
Offline
UGN Elite
Joined: Dec 2002
Posts: 3,255
Likes: 3
lol got our p/m

Code
 mysql_query("INSERT INTO ugn_errors (type , date , ip , referrer , file) VALUES ('$type', NOW(), '$ip', '$refer', '$linked'");
  
change to
Code
$dg = mysql_query("INSERT INTO ugn_errors (type , date , ip , referrer , file) VALUES ('$type', NOW(), '$ip', '$refer', '$linked')");
  
Notice the ( after mysql_query and ( after errors... Well you had only 1 ) on the end. yours ended

'$linked'");

should be

'$linked')");

See the difference

Now do this

Code
$dg = mysql_query("INSERT INTO ugn_errors (type , date , ip , referrer , file) VALUES ('$type', NOW(), '$ip', '$refer', '$linked')");

if($dg){
}else{
mysq_error();  
/*
change this after bugs are worked out so you do not give away system info
*/
}
  

Joined: Feb 2002
Posts: 7,203
Likes: 11
Community Owner
OP Offline
Community Owner
Joined: Feb 2002
Posts: 7,203
Likes: 11
Oh baby, it works smile . Thanks heh...


Donate to UGN Security here.
UGN Security, Back of the Web, and VNC Web Services Owner
Joined: Feb 2002
Posts: 7,203
Likes: 11
Community Owner
OP Offline
Community Owner
Joined: Feb 2002
Posts: 7,203
Likes: 11
Also have the 404 logger working lol... woot...


Donate to UGN Security here.
UGN Security, Back of the Web, and VNC Web Services Owner

Link Copied to Clipboard
Member Spotlight
Posts: 30
Joined: June 2002
Forum Statistics
Forums41
Topics33,840
Posts68,858
Average Daily Posts1
Members2,176
Most Online3,253
Jan 13th, 2020
Latest Postings
Where and how do you torrent?
by danni75 - 03/01/24 05:58 AM
Animation,
by JohanKaariainen - 08/15/19 01:18 AM
Blackbeard.....
by Gremelin - 10/03/18 07:02 PM
my old account still exists!
by Crime - 08/10/18 02:47 PM
Okay WTF?
by HenryMiring - 09/27/17 01:45 AM
The History Thread...
by Gremelin - 08/11/17 12:11 PM
My friend NEEDS your HELP!
by Lena01 - 07/21/17 12:06 AM
I'm having fun with this guy.
by gabithompson730 - 07/20/17 01:50 AM
I want to upgrade my phone
by gabithompson730 - 07/20/17 01:49 AM
Doom 3
by Cyrez - 09/11/14 08:58 PM
Amazon Gift Card Generator/KeyGen?te
by Gecko666 - 08/22/14 09:21 AM
AIM scene 99-03
by lavos - 09/02/13 08:06 AM
Planetside 2
by Crime - 03/04/13 07:10 AM
Beta Testers Wanted
by Crime - 03/04/13 06:55 AM
Hello Everyone
by Gremelin - 02/12/12 06:01 PM
Tracfone ESN Generator
by Zanvin Green - 01/18/12 01:31 PM
Python 3 issue
by Testing - 12/17/11 09:28 PM
tracfone airtime
by Drache86 - 07/30/11 03:37 AM
Backdoors and the Infinite
by ZeroCoolStar - 07/10/11 03:52 AM
HackThisZIne #12 Releaseed!
by Pipat2 - 04/28/11 09:20 PM
gang wars? l33t-wars?
by Gremelin - 04/28/11 05:56 AM
Consolidate Forums
by diggin2deep - 04/21/11 10:02 AM
LAN Hacking Noob
by Gremelin - 03/12/11 12:42 AM
Top Posters
UGN Security 41,392
Gremelin 7,203
§intå× 3,255
SilentRage 1,273
Ice 1,146
pergesu 1,136
Infinite 1,041
jonconley 955
Girlie 908
unreal 860
Top Likes Received
Ghost 2
Crime 1
Ice 1
Dartur 1
Cyrez 1
Powered by UBB.threads™ PHP Forum Software 7.7.5