"Programming" open Source (opensource)-Reverse link (referrers) system

Source: Internet
Author: User
Tags one table
Reverse link (referrers) system can display the reverse link very well, the newest source (Referer) statistics that present on many sites are using Stephen's referrer statistic system, such as Booso reverse link (referrers) statistic system, There is also a Zhu Zhunwei of the Reverse Link Statistics Service does not know that it is not his own implementation.


in short, the Internet to provide these backlinks (referrers) system is not a good service, that is, poor customization, so, simply, I am bored, I spent a day to write a, and open the source code, basically the structure and functions are used, but still need to improve.


because I do not support ASP + Access host, so I can not provide services, I hope that some colleagues can provide this service? Or CSDN will offer this service to me? The effect figure is as follows:





Basic Architecture:


using ASP + Access


use the following script to add a reverse link record to the page that needs to be counted


<script language=javascript src= "/lib/refadd.js" ></script>


use the following script to add a reverse link display to the page you want to display


<script language=javascript src= "/lib/refcnt.js" ></script>


Database:


database requires only one table


ID: Integer


IP: String (255)


Agent: String (255)


to: String (255)


Name: String (255)


from: String (255)


Date: DateTime


where the value of the "Name" field is the result of the from processing, such as from= "http://www.google.com/" name= "Google"


Analysis:


just a simple SQL query can be:


SELECT [Name],count (*) from [referrer] GROUP by [NAME] ORDER by COUNT (*) DESC "


If you want, you can also add the necessary conditions, such as displaying records with access times greater than 3 times:


SELECT [Name],count (*) from [referrer] GROUP by [NAME] have COUNT (*) >3 ORDER by Count (*) DESC "


Basic function:


Reverse Link Record


Reverse Link display (supports multiple parameters)


file list:


lib/refadd.asp


Lib/refadd.js


lib/refcnt.asp


Lib/refcnt.js


lib/refcon.asp


Lib/images/percent.gif


Dat/refdb.mdb


Source code:


because CSDN does not provide file download function, so I also want to find a place to upload source code, do not know where there is, colleagues please inform


Default.asp


<html>


<head>


<title>top refering sites</title>


Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.