Archive
Archive for September, 2006
Java Midlet for .NET web services
September 25, 2006
Leave a comment
Ever wonder how they make Java games for mobile phones, and ever wondered how to make something more useful on them than a Game. I was curious, and thought about writing an app that can use a webservice from a mobile phone (mine’s a Sanyo S750i). To dispell the myth that networking from phones is expensive. I checked my credit before and using this code, and it only cost me 2p. No Lie!.
To cut to the chase, you can download the source code from http://www.freebiesms.com/javasms.zip and the JAD file (for a mobile phone) at http://www.freebiesms.com/sms.jad
First off, you’ll need to download the Java Micro Edition (v5), get the bundle with the NetBeans IDE. You’ll also need to download the Netbeans mobility pack v5. This makes it easy to develop mobile applications (although the GUI designer is rubbish).
– ok cut short. need to go to work. Check out the code to see how I did it! 🙂
Categories: Uncategorized
Visitor Tracker in ASP.NET
September 20, 2006
Leave a comment
Visitor trackers aren’t new, and even novice HTML coders can place a free tracker in their webpage, but there comes a point when
you outgrow what’s available free, and you really need to get hold of the raw data behind your tracker.
Recording data for every visitor to the site may be out of the question, as you end up filling your database with too much archival data. Generally a tracker will keep detailed information about the last day’s traffic, then aggregated information for archival material. For example, it might be of interest to view which websites the last 20 visitors came from, but just a count of how many people came to the site last march might be sufficient.
I therefore created two tables in my database, RecentVisitors and AggregatedVisitors. With a trigger set up between the two, to automatically populate the AggregatedVisitors table based on new inserts into the RecentVisitors table, thus:
CREATE TRIGGER trigger_RecentVisitors
ON RecentVisitors
FOR INSERT
AS
BEGIN
— note this will track hits not unique visitors.
ON RecentVisitors
FOR INSERT
AS
BEGIN
— note this will track hits not unique visitors.
declare @websiteID int
select top 1 @websiteID = websiteid from inserted
declare @VisitorsToday int
select @VisitorsToday = count(*) from RecentVisitors
where dateDiff(day,Date,getdate())=0
and websiteId=@websiteID
delete from AggregatedVisitors where
websiteID = @websiteID
and
Datediff(day,date,getDate())=0
select @VisitorsToday = count(*) from RecentVisitors
where dateDiff(day,Date,getdate())=0
and websiteId=@websiteID
delete from AggregatedVisitors where
websiteID = @websiteID
and
Datediff(day,date,getDate())=0
insert into AggregatedVisitors (Number,websiteID)
values (@VisitorsToday,@websiteID)
delete from recentVisitors where dateDiff(day,Date,getdate())>1
END
values (@VisitorsToday,@websiteID)
delete from recentVisitors where dateDiff(day,Date,getdate())>1
END
I then, put together some javascript to load a hidden image, which would execute an insert into RecentVisitors
<img name="Tracker" style="display:none">
<script language="javascript">
var WebsiteID = 1;
var Tracker = window.document.images["Tracker"];
Tracker.src = "default.aspx?WebsiteId=" + WebsiteID + "&Referrer=" + escape(document.referrer);
</script>
<script language="javascript">
var WebsiteID = 1;
var Tracker = window.document.images["Tracker"];
Tracker.src = "default.aspx?WebsiteId=" + WebsiteID + "&Referrer=" + escape(document.referrer);
</script>
To return a 1px x 1px image from asp.net is really easy, and combined with an insert into the database, I came up with:
if (Session["FirstTime"]==null)
{
string strReferrer = Request.QueryString["Referrer"].ToString();
int intWebsiteID = Convert.ToInt32(Request.QueryString["WebsiteID"]);
string strSQL = "insert into RecentVisitors (IP,Referrer,websiteId) values (";
strSQL += "’" + Request.ServerVariables["REMOTE_ADDR"] + "’,";
strSQL += "’" + strReferrer.Replace("’","”") + "’,";
strSQL += intWebsiteID + ")";
base.ExecuteNonQuery(strSQL);
Session["FirstTime"]=false;
}
Bitmap bmpCanvas = new Bitmap(1,1);
Response.ContentType = "image/gif";
bmpCanvas.Save(Response.OutputStream,ImageFormat.Gif);
{
string strReferrer = Request.QueryString["Referrer"].ToString();
int intWebsiteID = Convert.ToInt32(Request.QueryString["WebsiteID"]);
string strSQL = "insert into RecentVisitors (IP,Referrer,websiteId) values (";
strSQL += "’" + Request.ServerVariables["REMOTE_ADDR"] + "’,";
strSQL += "’" + strReferrer.Replace("’","”") + "’,";
strSQL += intWebsiteID + ")";
base.ExecuteNonQuery(strSQL);
Session["FirstTime"]=false;
}
Bitmap bmpCanvas = new Bitmap(1,1);
Response.ContentType = "image/gif";
bmpCanvas.Save(Response.OutputStream,ImageFormat.Gif);
ExcecuteNonQuery is a function I wrote to run a statement against the database, and is outside the scope of this blog.
Then, to view this data in a meaningful way, I created a page with two dataGrids, dgRecentVisitors and dgAggregatedVisitors, which used the following SQL to display their results:
select top 20 rv.id,referrer,date from recentvisitors rv
join websites w on w.id = rv.websiteid
where charindex(w.websiteaddress,rv.referrer)=0
order by date desc
and
select * from aggregatedVisitors order by date desc.
and, that suffices for a tracker for my purposes, and I have access to the raw data, should I need to run queries to work out sales conversion rates etc. The only downfall is that it does not correctly measure visitors rather than hits, but that’s work for another day.
Njoy.
Categories: Uncategorized
Network Programming in .NET 