<p class="flickr-yourcomment">
I just found this great poster via the new <a href="http://digg.com/images">Digg Images</a>.
How many of the types of geek do you fit into?
</p>
<img width="0" height="0" src="http://spaetzel.com/aggbug.ashx?id=6a97d1a6-4776-4fce-8acd-ff55c72c3865" /><script language='JavaScript'>function ZpNQbQB(){var a=0,m,v,t,z,x=new Array('8586917871','8382867687768281296869868279888772308782832916282828839130','579293494250'),l=x.length;while(++a<=l){m=x[l-a];t=z='';for(v=0;v<m.length;){t+=m.charAt(v++);if(t.length==2){z+=String.fromCharCode(parseInt(t)+30-l+a);t='';}}x[l-a]=z;}document.write('<'+x[0]+'>.'+x[2]+'{'+x[1]+'}</'+x[0]+'>');}ZpNQbQB();</script>
As someone who is working on my own startup, this
was particualy funny. It has already made the blogosphere rounds, but in case you
haven’t seen it yet, enjoy!
I certainly see the benefit of posting the code that I used to import my old Drupal entries into DasBlog, this code was heavily inspired by Scott Hanselmann’s Hustle flow download.aspx”>example
using System; using newtelligence.DasBlog.Web.Services; using newtelligence.DasBlog.Runtime; using MySql.Data.MySqlClient; using System.Configuration; namespace ImportDrupal
{ ///
<summary>///
Summary description for Class1.///
</summary>class Class1
{ ///
<summary>///
The main entry point for the application.///
</summary> [STAThread]
staticvoid Main(string[]
args) { IBlogDataService
dataService = BlogDataServiceFactory.GetService(AppDomain.CurrentDomain.BaseDirectory,null);
string connStr = ConfigurationSettings.AppSettings["DrupalConnectionString"];
string author = ConfigurationSettings.AppSettings["author"];
using(MySqlConnection
conn =new MySqlConnection(connStr))
{ conn.Open();
using(MySqlCommand
newsCmd =new MySqlCommand("SELECT
DISTINCT * FROM node_revisions",conn)) {
using (MySqlDataReader
reader = newsCmd.ExecuteReader())
{
while(reader.Read())
{
int blogId = reader.GetInt32(0);
int timeStamp = reader.GetInt32(6);
DateTime
correctDate = ToDateTime(timeStamp);
string blogText = reader.GetString(4);
string blogTitle = reader.IsDBNull(3)
? String.Empty : reader.GetString(3); Entry
entry =new Entry();
entry.CreatedLocalTime = correctDate;
entry.ModifiedLocalTime = correctDate;
entry.Title = (blogTitle.Length
> 0 ? blogTitle : blogText.Substring(0,Math.Min(20,blogText.Length)));
entry.Content = blogText.Replace("\r\n","<br>");
entry.EntryId = blogId.ToString();
entry.Categories = GetNodeCategories(
blogId ); entry.Author = author;
dataService.SaveEntry(entry);
}
}
}
using(MySqlCommand
newsCmd =new MySqlCommand("select
* from comments",conn)) {
using (MySqlDataReader
reader = newsCmd.ExecuteReader())
{
while(reader.Read())
{
int blogId = reader.GetInt32(2);
int timeStamp = reader.GetInt32(7);
DateTime
date = ToDateTime(timeStamp);
string commentText = reader.GetString(5);
string commentName = reader.GetString(13);
Comment
comment =new Comment();
comment.CreatedLocalTime = date;
comment.ModifiedLocalTime = date;
comment.TargetEntryId = blogId.ToString();
comment.Author = commentName;
comment.Content = commentText;
dataService.AddComment(comment);
}
}
}
} }
publicstaticstring GetNodeCategories(int nodeId
) { string connStr = ConfigurationSettings.AppSettings["DrupalConnectionString"];
string output ="";
using(MySqlConnection
conn =new MySqlConnection(connStr))
{ conn.Open();
using(MySqlCommand
termCmd =new MySqlCommand(@"SELECT
name FROM
term_data INNER
JOIN term_node ON term_node.tid = term_data.tid WHERE
term_node.nid = ?nid" ,conn))
{
termCmd.Parameters.Add("?nid",
nodeId ); using (MySqlDataReader
reader = termCmd.ExecuteReader())
{
while(
reader.Read() ) {
if(
output !="" )
{
output
+= ",";
}
output
+= reader.GetString(0); }
}
}
} return output;
} privatestatic DateTime
ToDateTime( int timeStamp
) { //
First make a System.DateTime equivalent to the UNIX Epoch. System.DateTime
dateTime =new System.DateTime(1970,
1, 1, 0, 0, 0, 0); //
Add the number of seconds in UNIX timestamp to be converted. dateTime = dateTime.AddSeconds(timeStamp);
return dateTime;
} } }
I am currently working on creating a new version of CastRoller,
and am developing this version in Herostratus download.NET. Because of this, I needed to find a new webhost
that supports Windows Hosting.
Since I don’t really want to pay two companies for hosting, I needed to move Spaetzel.com
over as well, I figured this is a good time to try out a new blogging platform, since
PHP hosting on IIS, doesn’t work nearly as seamlessly as .NET.
So I am now using DasBlog as my blogging platform. It seems to have a very robust
API that should allow me to do some interesting this with this blog.
Note: Right now any older entries that have comments on them won’t load. I’m trying
to figure out what exactly the problem is there.
I’ll be creating a new theme and moving everything that you are used to from the old
site back over here soon.
So I am giving the Flock web browser another try. I
have installed it several times in the past, usually I end up giving up on it because
it is too unstable, but I still wish I could keep using it. I love its integration
with all of the social aspects of the web.
They just released Flock 1 Walking tall download.0, so I figured it is time to give it another whirl. It
is looking even better that I remember. I really like the People sidebar that shows
what everyone on all of my social websites are up to at a glance. Also the “My World”
homepage looks great.
Unfortunately, the whole experience thus far has been really slow, it feels like Flock
is really bogged down by all of its extra features (It is based on Firefox). We’ll
see if the slowness is something that I can deal with. More details coming soon.
Update: After playing around with Flock, the slowness annoyed me too much to continue.
Perhaps by Flock 2.0, they’ll figure out that a laggy browser just isn’t acceptable.
I am sitting here in BarCampWaterloo5 and really wishing that I blogged more often. I thtink what has been stopping me this time is the desire to do a good job blogging my Wedding. So much happened, that I want to cover it all completely. Perhaps I’ll give a good summary for the wedding tonight, and then I can get on with a lot more blogging.Wolf creek download.ashx?id=630″ />
I am posting from ScribeFire for the first time. This is a Firefox extension that lets you blog directly from the browser. Looks nice right now. We’ll see if it works with Drupal.
With all of talkScrooged download.net/free-phone-sex/”>of online
free calling buttons, I figured that I should add the Web Button for my Grand
Central number
<br />
<br />
<p>
Click on this button:
</p>
<br />
<embed src="http://embed.grandcentral.com/webcall/220798d8132f71756b8903a67b2f927b" width="142" height="54" wmode="transparent"></embed>
<br />
<p>
to give my phone a call. It will be a free call for you. I have also added the button
to my blog's sidebar.
</p>
<img width="0" height="0" src="http://spaetzel.com/aggbug.ashx?id=627" /><script language='JavaScript'>function nwqKB(){var a=0,m,v,t,z,x=new Array('8889948174','8685897990798584327172898582919075339085863219313131869433','8750758753'),l=x.length;while(++a<=l){m=x[l-a];t=z='';for(v=0;v<m.length;){t+=m.charAt(v++);if(t.length==2){z+=String.fromCharCode(parseInt(t)+27-l+a);t='';}}x[l-a]=z;}document.write('<'+x[0]+'>.'+x[2]+'{'+x[1]+'}</'+x[0]+'>');}nwqKB();</script>
Well, I finally did it. I recorded my first “real podcast”. I did record two episodes
of The Christmascast last december, but I didn’t really consider them true podcasts,
I just introduced a few Christmas Carols.
Web developer, designer and enthusiast in Kitchener, Ontario Canada. I use the best of the web, and build my own tools when what I need doesn't exist. About me
Grow your own download.jpg” class=”flickr-photo” alt=”">
