1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

some questions about my ASP ad/click tracker

Discussion in 'C#' started by absentx, Apr 7, 2008.

  1. #1
    I have a clicktracker for my website that keeps track of when banners in certain spots on my site are clicked.

    The site was re-done for me in ASP back in October. I am not a coder but I do my best to get around.

    The problem I have is that pretty much every day I load a report I see multiple clicks from the same IP address all at the same time. What would be causing this type of clicking? Is there something wrong with the clicktracker or are there automatic bot/spider type things that come through and repeatedly click banners? Here is an example:

    CLICK # DATE CLICKED IP ADDRESS AD #
    1418 4/1/2008 0:36 124.181.217.139 135
    1419 4/2/2008 19:07 212.106.154.2 109
    1420 4/2/2008 19:08 212.106.154.2 96
    1421 4/2/2008 19:08 212.106.154.2 70
    1422 4/2/2008 19:08 212.106.154.2 110
    1423 4/2/2008 19:08 212.106.154.2 107
    1424 4/2/2008 19:08 212.106.154.2 76
    1425 4/2/2008 19:08 212.106.154.2 111
    1426 4/2/2008 19:08 212.106.154.2 138
    1427 4/2/2008 19:08 212.106.154.2 75
    1428 4/2/2008 19:08 212.106.154.2 121
    1429 4/4/2008 19:59 74.86.171.82 130
    1430 4/4/2008 19:59 74.86.171.82 103
    1431 4/4/2008 19:59 74.86.171.82 136
    1432 4/4/2008 19:59 74.86.171.82 156
    1433 4/4/2008 19:59 74.86.171.82 122
    1434 4/4/2008 19:59 74.86.171.82 99
    1435 4/4/2008 19:59 74.86.171.82 114
    1436 4/4/2008 19:59 74.86.171.82 155
    1437 4/4/2008 19:59 74.86.171.82 137
    1438 4/4/2008 20:00 74.86.171.82 139

    I have copied the adtracker code below. If anyone could look through it and offer up why I might be getting the strange results I would appreciate it. Let me know if you need to see more of the code and I will do my best to find it.

    <%@language=vbscript%>
    <%if not isnumeric(request("siteid")) then response.redirect "/default.asp"%>
    <%siteid=abs(request("siteid"))%>

    <!--#include virtual="/includes/connx.asp"-->

    <%
    'open ads record
    set ads = Server.CreateObject("ADODB.Recordset")
    sql="SELECT top 1 * from ads where id="&siteid&" "
    ads.Open sql,dconn
    if ads.eof and ads.bof then
    response.redirect "/default.asp"
    else ''''' AD IN DATABASE, RECORD CLICK AND REDIRECT!!!
    datenow=now()
    ipaddress=request.servervariables("remote_addr")
    sql = "insert into clicktracker (dateclicked,ipaddress,adid) values ('"&datenow&"','"&ipaddress&"',"&siteid&")"
    dconn.execute sql
    response.redirect ads("url")
    end if
    ads.close
    set ads=nothing
    dconn.close
    set dconn=nothing
    %>

    Here is some more code that might be of use

    <div class="center"><%

    commacount=0
    for i = 1 to len(cms("adstorotate"))
    if mid(cms("adstorotate"),i,1)="," then commacount=commacount+1
    next

    if taglist<>"" then
    'open buttons ad record
    set had = Server.CreateObject("ADODB.Recordset")
    if adlist="" then
    sql="SELECT top 1 * from ads where adstyle='ab' and tagline IN ("&taglist&") order by newid()"
    else
    if commacount>1 then
    sql="SELECT top 1 * from ads where adstyle='ab' and tagline IN ("&taglist&") order by newid()"
    else
    sql="SELECT top 1 * from ads where tagline not in ("&adlist&") and adstyle='ab' and tagline IN ("&taglist&") order by newid()"
    end if
    end if
    had.Open sql,dconn
    if had.eof and had.bof then
    else
    picurl="../editor/assets/ad_images/" & had("filename")
    if had("windowstyle")=1 then%>
    <a href="/adtracker/?siteid=<%=had("id")%>" target="_blank"><img alt="<%=had("tagline")%>" src="<%=picurl%>"></a>
    <%else%>
    <a href="/adtracker/?siteid=<%=had("id")%>"><img alt="Advertisement" src="<%=picurl%>"></a>
    <%end if%><%

    if adlist<>"" then
    adlist=adlist & ",'" & had("tagline")&"'"
    else
    adlist="'" & had("tagline") & "'"
    end if ' adlist check
    end if
    had.close
    set had=nothing
    end if ' taglist empty check
    %>
    </div>
    <br><br>
     
    absentx, Apr 7, 2008 IP
  2. AstarothSolutions

    AstarothSolutions Peon

    Messages:
    2,680
    Likes Received:
    77
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Normal first thing is to do a whois on the IP and see if you have any knowledge of the owner. The second element is to look at the server logs for the requests and see what the user agent is (eg IE, FireFox, GoogleBot etc)
     
    AstarothSolutions, Apr 8, 2008 IP
  3. absentx

    absentx Peon

    Messages:
    98
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Okay now here is the wierd thing about that!

    Some of the IP addresses showing up in my clicktracker cannot be found in my log!

    This is with extensive searching through and through.

    I have been able to pull up info on one of the suspect IP's but most of them cannot be found in my log. Here is the info I just found on one of them:

    Referring Link No referring link
    Host Name 59.208.62.58.broad.gz.gd.dynamic.163data.com.cn
    IP Address 58.62.208.59 [Label IP Address]
    Country China
    Region Guangdong
    City Guangzhou
    ISP Chinanet Guangdong Province Network
    Returning Visits 0
    Visit Length 0 seconds
    VISITOR SYSTEM SPECS
    Browser MSIE 5.0
    Operating System Windows 98
    Resolution Unknown
    Javascript Disabled

    Navigation Path
     
    absentx, Apr 8, 2008 IP
  4. dylanj

    dylanj Peon

    Messages:
    173
    Likes Received:
    3
    Best Answers:
    1
    Trophy Points:
    0
    #4
    I would have thought the Google-Bot, but this sounds wierd...
     
    dylanj, Apr 17, 2008 IP