How to Copy a PICO-8 Game From a PocketCHIP

  • November 19, 2016
  • James Skemp
Having recently received my PocketCHIP I decided to start going through PICO-8 Zine #1 and its first tutorial. However, being the person I am, I hadn’t written too many lines before I started wondering how I could source control the games I work on on my new PocketCHIP. Since I’m using a MacBook Pro, here’s how I was able to copy my games off of my PocketCHIP and get them into git.

Read More

Setting up a Raspberry Pi 2 Samba server (in early January 2016)

  • January 9, 2016
  • James Skemp
The following is how I configured a Raspberry Pi 2 as a samba server, using a Seagate Backup Plus Slim, 1TB, drive. For ease I purchased the CanaKit Raspberry Pi 2 Complete Starter Kit. It runs about $70 and includes enough to get up and running with the Raspberry Pi 2, with the Pi itself, a nice case, power supply, HDMI cable, WiFi adapter, and SD card with NOOBS/Raspbian installer.

Read More

Google Services on the Amazon Fire HD 8

  • December 13, 2015
  • James Skemp
xda-developers has a post, Installing Google Framework/Playstore without Root (5th Gen Amazon Fire 2015), that includes a couple different sets of instructions. What worked for me was grabbing the mega.nz zip download and then: Make sure you're a developer and you allow apps from unknown sources. Install ES File Explorer via the Amazon Appstore. It's something I install on all my Android devices. Extract the contents of the zip you downloaded from Mega somewhere.

Read More

Example libGDX orthographic camera controller

  • June 20, 2015
  • James Skemp
The following class can be used in a libGDX project as a framework for your own orthographic camera controller. This has been tested with libGDX 1.6.2, but should work in versions back to at least 1.4.x. View the code snippet on GitHub. OrthographicCameraController.java

Read More

Configuring a libGDX project to run as a desktop application in Android Studio

  • March 13, 2015
  • James Skemp
The following will quickly cover how to setup a newly imported libGDX project to run a desktop application, via Android Studio 1.1.0. This assumes that you have already created a new libGDX project and have already imported it into Android Studio. If you have not, please review Creating your first libgdx project with Android Studio 1.1.0. With the project imported, select the configurations drop-down, or navigate to Run Edit Configurations.

Read More

Creating your first libGDX project with Android Studio 1.1.0

  • February 28, 2015
  • James Skemp
This is a quick 'tutorial' on how to get started with libGDX with Android Studio 1.1.0. Unfortunately while libGDX can be used with Android Studio 1.x, documentation regarding it is sparse. I'll assume that you have Android Studio 1.1.0 (1.x generally) installed and properly running. If you haven't already, download libgdx from the official site. The file name should be gdx-setup.jar, and will be run whenever you need to create a new project.

Read More

Enabling ADB on a Lenovo A7600-F TAB A10

  • November 6, 2014
  • James Skemp
As of this post, Lenovo does not have an ADB Interface Driver for their Lenovo A7600-F TAB A10. However, since I'd like to develop on it, I had to find a solution. An initial forum post pointed me to the older ADB Interface Driver for their ThinkPad Tablet. However, trying to update the android_winusb.inf with the necessary information was throwing a signature error when I tried to install it on Windows 8.

Read More

Rough guide on manually setting up Git on Windows

  • October 6, 2013
  • James Skemp
For both machines I'm doing this on (running Windows 7 and Windows 8) I had already installed Github for Windows. However, since I've been converted to posh-git, I wanted to do an install that would get me away from continuing to use it. The below is roughly what I did, and may not be completely correct. Install the latest version of msysgit (currently 1.8.4). Set execution policy (run as administrator).

Read More

Converting from Subversion to Git on Windows

  • February 9, 2013
  • James Skemp
With the news that Visual Studio 2012 will support Git out-of-the-box, and me deciding to stop storing my repositories locally, I decided to switch to Git this weekend. They say the best way to do this is via svn2git, which unfortunately uses Ruby. Since I'm on Windows, and haven't done Ruby development, I needed to download Ruby using RubyInstaller for Windows. Next I needed to have RubyGems support, which meant downloading from RubyForge.

Read More

Windows Phone 7: Taking and restoring a SQL database

  • April 22, 2012
  • James Skemp
As I develop my first Windows Phone 7 application, My Video Game Tracker, I want to make sure that the many games I've added won't accidentally be lost (as I'm deploying test versions to my physical phone). The below assumes you're using Windows PowerShell, but they should run on the standard command line. Taking screenshots of the application's data When you install the Windows Phone SDK the Isolated Storage Explorer Tool is also installed.

Read More

Script to simplify Netflix activity pages (in progress)

  • March 18, 2012
  • James Skemp
I love Netflix, but there's no easy way to get a listing of the movies I've rated through the service. To ease with that, I've finally started on a script that will clean the Netflix output, so it's a bit easier to parse. Fire up Chrome, visit either https://www2.netflix.com/RentalActivity?all=true or https://account.netflix.com/WiViewingActivity?all=true, open a console, and use the following two scripts: Script 1: Load jQuery var GM_JQ = document.createElement('script'); GM_JQ.src = 'https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js'; GM_JQ.type = 'text/javascript'; document.

Read More

Migration from CollabNet Subversion to VisualSVN Server

  • November 18, 2011
  • James Skemp
Since it doesn't seem CollabNet is really going to keep their non-Edge Subversion application, I've decided to migrate to VisualSVN Server. Roughly, here are the steps I went through to migrate, which also includes a 1.6.x upgrade. VisualSVN migration Installed VisualSVN. Repositories saved to C:\Repositories Setup existing users. Import existing repositories. Should already be upgraded, but upgrade to 1.5, just in case. Upgrade TortoiseSVN. Upgrade working copies to 1.

Read More

mvc-mini-profiler for users in a particular role

  • June 24, 2011
  • James Skemp
When Jeff Atwood announced the release of the mvc-mini-profiler for ASP.NET MVC Web sites I was intrigued. Just the other day he wrote an article Performance is a Feature and I decided I could hold off no longer. Tonight (for better or worse) I finally got this up and running on one of my sites, and fully intend on adding it to at least one more. To install it I naturally used NuGet, but note that it's called MiniProfiler there.

Read More

How to easily clear the window.applicationCache on select browsers

  • April 2, 2011
  • James Skemp
While I was working on tweaking my video game listing, and creating my offline Web application manager, I kept running into issues with the cache manifest holding onto data much longer than I would have liked. After some research I found that Chrome's interface can easily be found by going to chrome://appcache-internals/. On Safari, on the iPod Touch and iPad, you can stop/close Safari (hold down the home button on the home screen, and close the application) and then start it back up to clear the data.

Read More

Raw: Using OpenSSL to create a certificate authority and update IIS 7.5

  • December 29, 2010
  • James Skemp
A raw dump of information on how to create a certificate authority and etcetera. Step 1: Basic folder and file structure creation Directories: certs, keys, requests Files: database.txt (empty), serial.txt (01, then new line), openssl.cnf (based on OpenSSL file) Step 2: Create key "c:\Program Files (x86)\Apache Software Foundation\Apache2.2\bin\openssl.exe" genrsa -des3 -out keys/_ca.key 2048 Step 3: Create certificate authority certificate "c:\Program Files (x86)\Apache Software Foundation\Apache2.2\bin\openssl.exe" req -config openssl.cnf -new -x509 -days 365 -key keys/_ca.

Read More

Getting started with StatSVN (0.7.0) and CollabNet Subversion Server

  • October 31, 2010
  • James Skemp
This past week I was looking at advanced statistical information about a couple Subversion repositories we use at work. While TortoiseSVN has some basic reporting, the downside is that, out of the box, users must have access to the repository to access this information. StatSVN, seemingly the most popular solution, works rather well as an alternative to granting this access. The downside (or upside, depending upon your perspective) is that viewers of the report can see what files changed, and how many lines, but not what the actual changes were (outside of the logged message).

Read More

Subversion repository dump: WPF and Silverlight application, with MVVM (revision 25)

  • October 24, 2010
  • James Skemp
As alluded to in a previous post, in regards to an excellent Silverlight/WPF with MVVM tutorial, I've begun looking into the MVVM pattern, as I begin moving towards WPF and Silverlight for applications. Having fully watched the series twice, and begun a third watch working through the example, albeit with the Northwind sample database, I decided to share my labor with others. To that end I present a Subversion repository dump with a fairly step-by-step look at how to go from nothing to a simple application with WPF and Silverlight support.

Read More

iTunes Playlists to Xml: Parsing categories with LINQ

  • October 20, 2010
  • James Skemp
I recently had the need to determine what types of music I had within my collection of music. Since I created iTunes Playlists to Xml so that I could export out my library on my iPod, it was easy enough to run that and then open LINQPad to run the following query. Obviously, you must export the Genre field in order for the following query to work. // Location to the XML from iTunes Playlists to XML String playlistXml = @“C:\Users\James\Projects\services\WcfRestService\App_Data\playlistXml.

Read More

Excellent Silverlight/WPF MVVM video series

  • October 17, 2010
  • James Skemp
Here’s an excellent video series on Silverlight/WPF (XAML basically) and the MVVM pattern. He does, what I believe to be, an excellent job of covering XAML and MVVM during this series, and includes a bit of unit testing as well. Part one is included below, but another user on YouTube created a Playlist with the eight videos released. Update: Or you can view his blog post, time cockpit at NRWConf.

Read More

Fragile Dreams: Farewell Ruins of the Moon (Wii) - leveling and initial thoughts

  • October 16, 2010
  • James Skemp
A little over an hour into Fragile Dreams: Farewell Ruins of the Moon I have three levels of information, and some preliminary thoughts. Leveling information I'll put this into an XML file at some point, I'm sure, but here are the first three levels. Level - HP - Base Attack - Experience to next level 1 - 100 - 4 - 1000 2 - 120 - 6 - 3000 3 - 140 - 8 - 6775

Read More

The benefits of using a file for Log Parser SQL queries

  • September 26, 2010
  • James Skemp
One of the things I always forget about when I'm using Microsoft Log Parser is that you can define your SQL query in a file and run it, instead of putting it in the command line. For example, the following will run whatever SQL is defined in strivinglife.robots.sql. logparser -i:w3c -o:xml file:strivinglife.robots.sql Where this comes in handy is for something like the Log Parser query I defined today, that parses IIS logs for requests to the robots.

Read More

Importing a custom namespace / custom type into an XSD

  • September 5, 2010
  • James Skemp
I have a custom type that I use in a couple of my documents. Unfortunately, in the past I was adding this to each xsd, as I needed it. However, I've now figured out how to import it into xsd files as needed. Original schema Currently I'm adding the following at the top of each xsd: <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"> <xs:simpleType name="customDateType"> <xs:restriction base="xs:string"> <xs:annotation> <xs:documentation><![CDATA[Allows for a year, a year and a month, or a year, month, and day, to be defined.

Read More

Onimusha: Dawn of Dreams data

  • September 3, 2010
  • James Skemp
From the archives, I've created an XML Schema and XML data file for Onimusha: Dawn of Dreams, for the Playstation 2. Currently the data only includes armor leveling information, from level 1 to 100. The data comes from an OpenDocument Spreadsheet (OnimushaDawnofDreams.ods) from way back in May of 2006. My characters and core weapons being completely maxed (not to mention souls), I may decide to replay the game to track this information as well, or just upgrade weapons.

Read More

Windows 7 Home Premium changes for IIS 7.5 access of Users directories

  • August 28, 2010
  • James Skemp
Not feeling much like debugging it too much, I made a couple of modifications to my IIS installation to allow access to files contained within my user directory. Background I turned the Internet Information Services feature on on my Windows 7 Home Premium machine before using the Web Platform Installer to add additional functionality. However, I kept running into a permissions issue, as the sites I setup were located in my Users directory (C:\Users\James).

Read More

Visual Studio 2010 complaints about ELMAH on a 64-bit machine - fixed

  • August 23, 2010
  • James Skemp
My laptop has quickly become my development machine for smaller projects, especially after I purchased a low-end desktop to host the Subversion repositories. I recently added ELMAH support to one of my sites, but since I run 64-bit, and have been using the built-in Cassini for quick development, I started getting a message in Visual Studio 2010 saying "ASP.NET runtime error: Could not load file or assembly 'System.Data.SQLite' or one of its dependencies.

Read More

ASP.NET charts example: Odin Sphere: Part 3 - Creating the chart

  • August 15, 2010
  • James Skemp
In part one of this series we covered what we'd be doing, and what data model we'd be using. In part two of this series we used LINQ to XML to query the XML file with the data we want to display. This time we'll be doing the heavy lifting of actually creating the chart and displaying it to the user. For ease, I'll be implementing very basic caching. Preliminary requirement Before you can use the charting functionality you need to have a reference to System.

Read More

ASP.NET charts example: Odin Sphere: Part 2 - Parsing the XML

  • August 14, 2010
  • James Skemp
In part one of this series we covered what we'd be doing, and what model we'd be using for the data. This time we'll parse the XML file that contains the data we need, and populate the objects. Loading the XML file The XML file we'll be loading is located at http://jamesrskemp.com/files/OdinSphere.xml, and to keep it simple, we'll load it in assuming we're on a different server/domain. First we'll need to add the following so we can make use of XDocument.

Read More

ASP.NET charts example: Odin Sphere: Part 1 - Introduction and model

  • August 13, 2010
  • James Skemp
For a while now I've been meaning to work with ASP.NET 4's built-in charting functionality. While I was going to use it alongside my gas tracking, I think I'm instead going to use my Odin Sphere leveling guide, so I don't have to create an XSLT for the output. In this part of the series I'll outline the data model I'll be using, and preliminary setups. Method So that this can easily be deployed anywhere, I'm going to opt not to use the control itself, but rather programmatically create the charts/graphs.

Read More

Odin Sphere: Character data file

  • July 30, 2010
  • James Skemp
Similar to my Resonance of Fate data file and Muramasa demon blade listing, I've begun work on converting a notepad file's data to XML. The data is still raw, but ... I plan on completing it as much as I can. View/download the Odin Sphere data file. As noted in the file, data is licensed under the Creative Commons License Attribution-Noncommercial-Share Alike 3.0.

Read More

Function to Parse a Microsoft JSON DateTime returned from a WCF service in JavaScript

  • July 4, 2010
  • James Skemp
When a DateTime is converted to JSON in a WCF Web service (WebHttp in this particular case) it's semi-difficult to convert that to something we can use when we return the date to a client via JavaScript. For example: "LastPlayed":"\/Date(1278187099000-0400)\/" After almost an hour of research and goofing around with this, I've come up with the following, which seems to work just fine on Internet Explorer 8, Firefox 3.6, and Chrome 5.

Read More

Referring to JavaScript documentation in Visual Studio via reference

  • July 3, 2010
  • James Skemp
While I don't use Microsoft or Google's CDNs for jQuery, I do have a separate sub-domain where I serve these files from (and will eventually use a CDN, I'm sure). However, this means that in Visual Studio I miss out on the helpful documentation functionality. Based on a comment on 3 reasons why you should let Google host jQuery for you it turns out there's a fairly easy way to get Intellisense; simply include the following in your JavaScript file.

Read More

Windows Server 2008 R2, SQL Server Express 2008 R2, and LINQPad

  • June 26, 2010
  • James Skemp
This weekend I finally installed SQL Server 2008 R2 to my Windows Server 2008 R2 machine. After a bit of back-and-forth about which version to install (since my MSDN subscription allows me to install seemingly every version), I opted to just install SQL Server Express 2008 R2. Being part of the Web Platform Installer, the entire process was extremely easy. Step 1: Start Web Platform Installer. Step 2: Select SQL Server Express 2008 R2 and SQL Server 2008 R2 Management Studio Express from under Database.

Read More

Tutorial: ASP.NET (C#) WCF WebHttp service with jQuery: Part 3 - Pulling JSON with jQuery

  • June 25, 2010
  • James Skemp
See the table of contents for more information. In this series we’ve started with a new loan class, that contains information about a loan, including the total amount due, how much is to be paid per payment, the interest rate, and etcetera. A method is available that will generate information about the number of payments required to pay off the loan. In the second part we created a WCF WebHttp service, or a WCF REST service, to use the class/assembly from that loan object and return XML data for GET requests.

Read More

Tutorial: ASP.NET (C#) WCF WebHttp service with jQuery: Part 2 - WCF WebHttp service

  • June 24, 2010
  • James Skemp
See the table of contents for more information. In the last part we created a Loan object, that we determined we would later use to power our Web service. Ths object has a handful of properties and a method to update a list of payments to bring the loan to $0. This time we’re going to create a Web service to respond to requests from data. Requirements As this seems to be built for .

Read More

Tutorial: ASP.NET (C#) WCF WebHttp service with jQuery: Part 1 - Loan object

  • June 22, 2010
  • James Skemp
See the table of contents for more information. As already noted in the table of contents, the end goal will to have a service that returns enough information to be able to generate an amortization schedule for a loan. I’m not in financial services, and haven’t been very good in math since some point in high school, but this seems to work fairly well. The first thing we’re going to do is generate an assembly that we’ll then use in the WCF WebHttp service.

Read More

Tutorial: ASP.NET (C#) WCF WebHttp service with jQuery: Table of Contents

  • June 21, 2010
  • James Skemp
A while ago (a year and a quarter) I created an amortization schedule generator in ASP.NET, as an attempt to help me determine when I could expect to have a loan paid off, depending upon how much money I threw at it. For better or worse, some of the practices I put in place aren't the best, and either way I've been meaning to tweak the interface so that I could do various comparisons.

Read More

Vehicle gas DTD .NET objects and XML parsing with LINQ

  • June 10, 2010
  • James Skemp
The code contained below is a rough draft, and will eventually be moved into an assembly, and the code posted. At some point in 2007 I started keeping track of my gas mileage in an XML file, with a custom DTD for validation (and intellisense in oXygen). I present below the code necessary to create an rough object from the XML, and the LINQ to parse it out. C# objects public class Vehicle { public int Id { get; set; } public String Make { get; set; } public String Model { get; set; } public int Year { get; set; } public IEnumerable Fillups { get; set; } }

Read More

Windows Server 2008 R2 Enterprise Edition - setup for sharing files

  • June 6, 2010
  • James Skemp
When I first started downloading files, almost a decade and a half ago, I would just download everything to one directory, using whatever name the file originally had when I was downloading it. In the last couple of years I've been trying (despite Chrome's default method trying to push be back) to be much better about saving files, by creating a directory with the full name of the application - "Microsoft Web Platform Installer"

Read More

Windows Server 2008 R2 Enterprise Edition - setup for Web development

  • June 5, 2010
  • James Skemp
This afternoon I setup a machine for the following purposes: to serve as a test bed for Web development to serve as an always-available Subversion repository server to serve as a repository for shared downloads, across all my machines As time goes by the scope of the server may also change. But for now, this will work just fine. Choosing an edition The first step was to install Windows Server 2008 R2.

Read More

Basic .NET (C#) Traceroute library

  • May 9, 2010
  • James Skemp
Spending the day researching all things DNS, I eventually came upon Jim Scott's post on C# Traceroute using .net framework. After a bit of tweaking, I've got something that I like a bit more, because I really want to know what the IP address means. The code for the assembly and console application are included below. Written against .NET Framework 4 (in Visual Studio 2010), but if you change the String.

Read More

Manually updating CollabNet Subversion Server and TortoiseSVN

  • April 27, 2010
  • James Skemp
With CollabNet releasing a new version of Subversion Server (1.6.11), and TortoiseSVN having a release a few days earlier, it's time to do an actual update, instead of a comment like I did last time. Environment I'm currently running CollabNet Subversion Server version 1.6.9.1 on Windows 7 Home Premium, 64-bit. The install directory is C:\Program Filies (x86)\CollabNet\Subversion Server\, and I'm installing version 1.6.9.11. These instructions should work, with minor changes, for other versions of CollabNet Subversion and Windows.

Read More

Dynamically generating a list of videos for OSFLV Player with ASP.NET

  • April 13, 2010
  • James Skemp
I've had this code for a while, but here's some simple code to pull a listing of Flash videos (FLV) from a directory, display them in a drop down, and have a video player dynamically generated based on what's picked. This uses OSFLV Player, version 3 specifically, but can be tweaked for the current (as of this post) version 4.0. Default.aspx <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %> <!DOCTYPE html PUBLIC "

Read More

Resonance of Fate: General data file

  • April 11, 2010
  • James Skemp
Resonance of Fate, available for the Playstation 3 and Xbox 360 (I purchased for the former), has a vast amount of data associated with it, as RPGs usually do. Because I usually do, I started keeping track of levels and etcetera for the game, which is available as an XML data file. The data is currently raw (and as of this post need to finish adding data that I've got on paper and on another computer), without styling, but I've been sitting on the information for far too long.

Read More

JavaScript object dump

  • March 27, 2010
  • James Skemp
I thought I posted this before, but I guess I did not. Here’s one way to dump a JavaScript object for analysis (if you don’t have access to Firebug, or a similar tool). Note it only dumps one level of data, and the code below is specifically for dumping an exception (catch ex), but swap ex in the three spots one spot with whatever object you’d like dumped. var objectInfo = “”; // Change ex to whatever object you want to debug.

Read More

Installing WordPress 2.9.2 on Windows Server 2003 using Microsoft's Web Platform Installer

  • March 12, 2010
  • James Skemp
I recently had need to install and test WordPress for some possible work. While I was tempted to go the Linux route, shortly after the OS was setup I decided to skip that and stick with Windows. Since Microsoft has released a platform that supposedly makes it easy to install Web-related applications, I decided to give it a try to determine just how simple it was. What follows is an overview of the setup process to install WordPress 2.

Read More

Connection String encryption (connectionString element) in ASP.NET

  • February 1, 2010
  • James Skemp
From what I've been able to determine, setting up an ODBC connection in Windows and using that for ASP.NET generally seems to be frowned upon. Instead, ASP.NET uses a Web.config file to store a number of settings, including all the connection strings you'll be using (whether you're using Windows authentication or user names and passwords). For example: <?xml version="1.0"?> <configuration> <appSettings/> <connectionStrings> <add name="TestDatabase001Reader" connectionString="Data Source=192.168.56.102,1433;Initial Catalog=TestingDatabase001;User Id=DataReader;Password=DataReader" providerName="System.Data.SqlClient"/> </connectionStrings> <system.web> .

Read More

Determine BlogEngine.NET comments that haven't been published - with LINQPad

  • December 31, 2009
  • James Skemp
At the beginning of the month I wrote a post on how to find BlogEngine.NET comments that had not yet been published/approved. Having purchased a copy of LINQPad a short while ago (autocompletion costs, the program with all other functionality does not; give it a try if you develop in .NET - it's very cool), and having got slammed this morning with some spammer who had an hour to kill, I decided to adapt my code for LINQPad.

Read More

XML Schema Definition creation: Journal - Part 3: XSLT sample

  • December 27, 2009
  • James Skemp
Having created an overview of how I wanted to craft a simple journal in XML, I next created an XML Schema Definition for the simple journal to validate against. Having now crafted a Web application to create the XML files I'm able to move onto the prettier aspects of display for the XML files. I've created a sample simple journal that uses an XSLT (XSL Transforms, or extensible stylesheet language transformations) to make the display a little prettier.

Read More

XML Schema Definition creation: Journal - Part 2: XSD file with <oXygen/> XML Editor

  • December 23, 2009
  • James Skemp
In the first part of this series I had outlined a sample layout that I wanted to use for a series of XML files that I would be creating over the course of 2010. This time I'm going to create the actual XML Schema Definition file with <oXygen/> XML Editor, version 11.1. I've been using <oXygen/> since January 2008, and wouldn't trade it for any other XML editor. If you don't have <oXygen/> you can still follow along.

Read More

XML Schema Definition creation: Journal - Part 1: Primary layout

  • December 21, 2009
  • James Skemp
In a previous series, I went over the process of creating a new XML document to store my video games. (Although in that case I used a DTD.) This time I’m going to work on a schema to store quasi-journal entries, which I’m hoping will help with my goal to write every day. What I hope to accomplish Ultimately I want to store a bit of text for any particular day.

Read More

Installing SQL Server Express 2008 on Windows Server 2003

  • December 20, 2009
  • James Skemp
SQL Server Express is an easy way to add Microsoft SQL Server to a Windows-based server. While limited in functionality, SQL Server Express is still a viable solution. In this article I'll be covering a custom install of SQL Server Express 2008 on Windows Server 2003. Server system For this install I was running Windows Server 2003 R2, Enterprise Edition, Service Pack 2 on Sun VirtualBox, with 256 MB of RAM.

Read More

Determine BlogEngine.NET comments that haven't been published

  • December 6, 2009
  • James Skemp
Unfortunately, BlogEngine.NET doesn't currently have a very good way to determine, at a glance, all of the comments that haven't been approved. While this will certainly be coming in a future release, or as an extension, I figured writing something simple to do this would be a good LINQ to XML test for me. You can download the built executable, or play with the code, which is included below. Download the executable (7-Zip format).

Read More

Example batch file to dump Subversion repositories

  • November 19, 2009
  • James Skemp
I have a large collection of repositories, and until now ran a single batch file that had to be updated each time I created a new repository, to add the new directory. To combat that, I did some research and created a new batch file that does all the heavy lifting for me. To save others time, I present it below. SET timeVar=%date:~10,4%%date:~4,2%%date:~7,2% SET repoDumpDir=..\repos_dump FOR /D %%G IN (*) DO svnadmin dump %%G > %repoDumpDir%%%G%timeVar%.

Read More

Using SQLite as a membership, profile, and role provider in ASP.NET MVC

  • October 25, 2009
  • James Skemp
I'd really like to implement membership providers in my Web applications, but just don't have the user-base that requires SQL Server (Express), nor the memory on my production server. Having looked at SQLite before, I figured it would be exactly what I'd need, without going to the alternative of XML. After some research I found Roger Martin's SQLite Membership, Role, and Profile Providers, and finally decided yesterday to implement these on a dummy MVC site.

Read More

Steps to setting up a Windows Server 2003 Web Server on VirtualBox

  • October 24, 2009
  • James Skemp
The following goes through the steps needed to setup Windows Server 2003, with Web server capabilities (IIS 6 in this instance), on a Sun VirtualBox virtual machine. Why Windows Server 2003 when Server 2008 is out and available? Because a large number of hosts (mine included) haven't made the switch yet. Requirements Sun VirtualBox. We want this in particular for the great networking functionality, but other apps, like Microsoft Virtual PC, will work fine as well.

Read More

Muramasa: The Demon Blade - Complete weapon listing

  • October 12, 2009
  • James Skemp
There aren't too many good gamer's games on the Nintendo Wii, so when Muramasa: The Demon Blade started getting advertised, I started getting really excited. Finally, a reason to dust off the Wii and play something other than Virtual Console games. With 108 blades available, Muramasa is also a completionist's dream. With the interest of making it a little easier to determine what weapons are available, I've crafted the following file, listing all the blades with their type, attack, secret arts, and effects, as well as which of the two character's trees it belongs to (those shared blades are noted as such, however some I still need to set).

Read More

Parsing Yahoo! Music's Artist Web Services with C# and LINQ to XML - Search for artists

  • September 12, 2009
  • James Skemp
Similar to my post on parsing Last.fm's artist.getSimilar, I've been working with Yahoo! Music's Web services today. Unfortunately, Yahoo!'s services aren't quite as friendly as those made available by Last.fm. So that I remember, and others don't have to tackle this as well, here's the class I've created. (Download JamesRSkemp.WebServices.YahooMusic.cs.) /* Created by James Skemp - http://jamesrskemp.com/ Version 1.0 More information at http://strivinglife.com/words/post/Parsing-Yahoo!-Musics-Artist-Web-Services-with-C-and-LINQ-to-XML-Search-for-artists.aspx Shared under a Creative Commons Attribution 3.0 United States License - http://creativecommons.

Read More

Parsing Last.fm Web Services' artist.getSimilar with C# and LINQ to XML

  • September 12, 2009
  • James Skemp
The following covers how to parse the XML response of artist.getSimilar, from Last.fm's Web Services. Setup and assumptions The first step is sign up for a free API account at Last.fm. You'll also need to target .NET Framework 3.5 when you setup your project, so as to access LINQ functionality. When writing the steps listed below, I was working on a Windows Forms Application, but the steps should be the same, or very similar, for other project types.

Read More

Installing CollabNet Subversion Server 1.6.3 and TortoiseSVN 1.6.3 on Windows Server 2003

  • July 3, 2009
  • James Skemp
For a business to implement version control, they typically want some kind of support, preferrably that they need to pay for, and that may or may not be used, and that may or may not be helpful. Luckily, CollabNet offers certified binaries of Subversion, available for the low price of the time needed to register. Additionally, they offer support, training, installation, and hosted solutions, in addition to the large Subversion community. Compared to the other solutions out there, including Microsoft's, there's really no question on what your first choice should be.

Read More

Multiple network adapters in VirtualBox, for Windows guests

  • July 2, 2009
  • James Skemp
Having just upgraded to VirtualBox 3.0.0, I was running into an issue with being able to access a Windows Server 2003 guest from my Windows Vista host machine. By default, when creating a Windows Server 2003 guest machine the Network settings are set such that Adapter 1 is PCnet-FAST III, attached to NAT. This allows the virtual machine to get outside, but not in. However, it's possible to add a second adapter, attached to the host-only adapter.

Read More

Muenchian Method grouping in XSLT

  • July 1, 2009
  • James Skemp
I owe a deal of thanks for figuring out the Muenchian Method of grouping in XSLT (1.0) to Jeni's article Grouping Using the Muenchian Method. It took, however, a while for me to get my mind around the method completely, and some experimentation, which I'm sharing below. Specifically I was looking to get a listing of tracks, from my iTunes Playlists to Xml application's output, and group them by album.

Read More

jQuery: Query an Xml document and output data

  • May 3, 2009
  • James Skemp
I back-dated my first piece of jQuery code, but have decided not to with my second. Anyways, I had a hard time finding code, written in jQuery, to pull data from an Xml file and add it to a page. Combining a couple of tutorials online, I created the following (on April 27). This was for a message, so I started out with the Xml file, creating something like this:

Read More

Upgrading Subversion 1.5.x to 1.6.0 on Windows Vista - checklist

  • March 23, 2009
  • James Skemp
The following is how I went about performing an upgrade of Subversion 1.5.4 to Subversion 1.6.0. For this I'll be continuing to use the current Windows build of Apache 2.2.x, TortoiseSVN, and of course Subversion. At this time, that's Subversion 1.6.0, TortoiseSVN 1.6.0, and Apache 2.2.11. Determine current setup. Opening the Apache Service Monitor will show the version of Apache and Subversion. In my case, that's 2.

Read More

Microsoft Log Parser timestamp formats

  • February 6, 2009
  • James Skemp
The following article covers the timestamp format specifiers accepted by Microsoft Log Parser. Date Year y, yy, yyy, yyyy = last 1, 2, 3, or 4 digits, relative to 2000 Month M = no leading zero MM = leading zero MP = leading space MX = no leading zero, or with or without zero when parsing MMM = 3-character abbreviation MMMM = full name of month Day d = no leading zero dd = leading zero dp = leading space dx = no leading zero, or with or without zero when parsing ddd = 3-character abbreviation dddd = full name of day Time Hour h or H = no leading zero hh or HH = leading zero hp or HP = leading space hx or HX = leading zero, or with or without leading zero when parsing Minute m = no leading zero mm = leading zero mp = leading space mx = leading zero, or with or without leading zero when parsing Second s = no leading zero ss = leading zero sp = leading space sx = leading zero, or with or without leading zero when parsing Millisecond l = no leading zero ll = leading zero lp = leading space lx = leading zero, or with or without leading zero when parsing Nanosecond n = no leading zero nn = leading zero np = leading space nx = leading zero, or with or without leading zero when parsing Other tt = AM/PM ?

Read More

Disabling Messenger auto sign-in on the Xbox 360

  • January 19, 2009
  • James Skemp
Shortly after logging into Xbox Live the Xbox 360 will attempt to log into Windows Messenger, by default. While I tried to find how to disable this, all of the articles I found were irrelevant, since they were written during the 'blades' interface. Here's how I stumbled on it. Press the Xbox button on your controller. Go to the Settings tab. Select Profile.

Read More

Shadow Hearts: From the New World leveling information

  • December 27, 2008
  • James Skemp
A leveling 'guide' for Shadow Hearts: From the New World is now available; Shadow Hearts: From the New World leveling. Not only should it have been written up and posted a while ago, it gave me a good chance to use XSD (XML Schema Definition). I tried creating one for my tracking my vehicles' gas usage, but failed. Having worked through the issues on this one, I think I now know what I did wrong.

Read More

How to get started with Microsoft Log Parser

  • November 7, 2008
  • James Skemp
I've written about Microsoft Log Parser before, and even started a site around it. But, I noticed the other day that I hadn't written on how to get started with this powerful tool. Getting Log Parser The current version of Log Parser is version 2.2, which you can download from Microsoft. Installing Log Parser While it says supported operating systems are "Windows 2000; Windows Server 2003; Windows XP Professional Edition," it appears to run fine on Windows XP Home Edition and Windows Vista (at least Ultimate has been personally confirmed).

Read More

.NET DataSet dump (C#)

  • October 18, 2008
  • James Skemp
One thing that I really like about ColdFusion is the powerful cfdump. Use the cfdump tag to get the elements, variables, and values of most kinds of ColdFusion objects. Useful for debugging. You can display the contents of simple and complex variables, objects, components, user-defined functions, and other elements.  Of all the tags in ColdFusion, cfoutput is probably the only tag that I use more. Unfortunately, most other languages, JavaScript and .

Read More

Backing up my iTunes library - how I do it

  • October 14, 2008
  • James Skemp
Here's how I backup my iTunes library. My environment I have a HP Pavilion a620n with Windows XP Home, SP3, where I do my iTunes purchasing and copying to my iPod. I have an iPod Classic, 80 GB, that I manually sync from my a620n. I have a HP Pavilion a6360t with Windows Vista Ultimate, SP1. I have a HP Pocket Media Drive, 160 GB.

Read More

Subversion 1.5.3 and TortoiseSVN 1.5.4 released

  • October 12, 2008
  • James Skemp
The newest versions of Subversion and TortoiseSVN were released just last week. My install guides for Subversion on Vista (and another with Subversion on Vista with Apache 2.2.x) and TortoiseSVN on Vista are still applicable. If installing Subversion with Apache 2.2.x, make sure you stop Apache before replacing files.

Read More

Specialists guide/listing for Disgaea: Hour of Darkness (Playstation 2 Greatest Hits)

  • October 12, 2008
  • James Skemp
A brief guide/listing of specialists for Disgaea: Hour of Darkness (Playstation 2 Greatest Hits) is now available. While there are other guides available, I didn't find one that I could easily print out and make note of which character had which specialists. Now I've got one. Comments appreciated.

Read More

Connecting to a WRT54G with a HP iPAQ 110

  • October 4, 2008
  • James Skemp
After playing around with settings, I was finally able to access my wireless network with my HP iPAQ 110. Here's what I did. Under Wireless > Wireless Security, set the model to WEP, setting a passphrase and generating keys. Make sure your wireless is enabled. Once the network shows in your iPAQ, set the Authentication to Shared and the Data Encryption to WEP. Select the key index and enter the key equal to the Default Transmit Key from the WRT54G.

Read More

Subversion and TortoiseSVN: Moving a repository

  • September 12, 2008
  • James Skemp
This evening I had to rename a project folder, since I was creating a site with the same name. Since I had the project (application) under Subversion, I also needed to move the repository. Here's what I did: svnadmin create b:\repos\_newName_ svnadmin dump b:\repos\_oldName_ > b:\repos_dump\_oldName_.dump svnadmin load b:\repos\_newName_ < b:\repos_dump\_oldName_.dump At this point I could either checkout the repository, or change where the checked out directory points to.

Read More

Installing Subversion binaries for Apache 2.2.x

  • August 19, 2008
  • James Skemp
Recently I went ahead and installed Apache 2.2.9 to my Windows Vista Ultimate machine. The purpose of doing that was to move towards a Subversion install running on Apache. In this article, I'll be covering that installation. Getting Subversion Obviously, the first thing to do is to get Subversion. We're looking for the Windows Apache 2.2.x binaries, in particular. At the time of this writing, that's svn-win32-1.5.1.zip. In a previous guide, which you may have followed, I installed the Windows installer with the basic win32 binaries.

Read More

Install Apache 2.2.9 to Windows Vista (Ultimate)

  • August 15, 2008
  • James Skemp
In this article I'll be covering an installation of Apache 2.2.9 to Windows Vista Ultimate. I'll be installing Apache so that you can run IIS as well (hence, Apache will be on a different port). You may want to do this if you want to run Subversion on Apache (as I do). Installing Apache 2.2 Currently the Apache HTTP Server has both a 2.0 and 2.2 version. For new development, the 2.

Read More

Importing an existing Web site into Subversion

  • July 13, 2008
  • James Skemp
Last time, I played around with Subversion in order to determine just how Subversion worked. This time I'm actually going to create a repository for a site to store the current version, and work through making a couple of updates. Existing site structure The site that I'll be working with is DoNotDenyMyUnicorn.com. It's a small, stable, site, that has just a few files. It's also relatively clean, with no previous versions floating about.

Read More

Playing around with Subversion with a test repository

  • July 12, 2008
  • James Skemp
I've flirted with source/version/revision control since September 2006 (with Subversion), but have never really dug in to actually do anthing with it. But now, that changes. The following guide was created using Subversion 1.4.6 and TortoiseSVN 1.4.8. However, this should still be applicable. Also, because of the number and size of the images, I've limited the images shown directly in the guide. All links to these images should open in a new window.

Read More

How to change your default language in Visual Studio 2008 (the right way)

  • July 2, 2008
  • James Skemp
There's a number of resources online on how to change the default language in Visual Studio. However, none of them are correct. They all state that you should reset your settings to default and then re-setup your settings. Huh? Instead, if you modify the CurrentSettings.vssettings file, you can keep all your other settings, without the pain of having to re-import everything else. First, find your settings file, which appears to default to the My Documents\Visual Studio x\Settings\ directory.

Read More

Domain name XML

  • June 15, 2008
  • James Skemp
In XML creation: Part 1, I went about creating an XML document, with both a CSS and XSLT, that was used to store my video game information. Yesterday I was going through my domains, and realized that it would be pretty helpful to have an XML document where I could store domain name information, since I've got too many to keep track of in my head. The layout Using lists, this the version 1 that I came up with yesterday:

Read More

Installing TortoiseSVN to Windows Vista

  • June 8, 2008
  • James Skemp
In a previous article, I installed Subversion and TortoiseSVN to a Windows XP Home Edition machine. Later, I upgraded the installation. Just recently I covered installing Subversion 1.4.6 to Windows Vista. This time I'll be installing TortoiseSVN on that same machine. The setup The system I'm using is a HP Pavilion a6360t, with 4GB install RAM, 2.20 GHz, with two cores, running Windows Vista Ultimate SP1, 32-bit. Downloading TortoiseSVN Since TortoiseSVN is for Windows, it makes it even easier to find the version to download.

Read More

Installing Subversion to Windows Vista

  • June 7, 2008
  • James Skemp
In a previous article, I installed Subversion and TortoiseSVN to a Windows XP Home Edition machine. Later, I upgraded the installation. This time I'll be installing Subversion on a Windows Vista Ultimate SP1 machine. The setup The system I'm using is a HP Pavilion a6360t, with 4GB install RAM, 2.20 GHz, with two cores, running Windows Vista Ultimate SP1, 32-bit. I'm already running IIS 7, so I won't be installing Apache to run Subversion.

Read More

Regular Expression tester - ASP.NET

  • May 4, 2008
  • James Skemp
I've posted code in ColdFusion and JavaScript for a regular expression tester. Since I'm looking at ASP.NET development ... here's one built on ASP.NET (3.5, but it should run fine on 2.0), in C#. RegularExpression.aspx <%@ Page Language="C#" AutoEventWireup="true"  CodeFile="RegularExpression.aspx.cs" Inherits="_Default" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server">     <title>ASP.NET 3.5 Regular Expression tester</title>     <style type="text/css">   form {

Read More

Adding .NET functionality to Windows Vista Home Premium Internet Information Services

  • March 22, 2008
  • James Skemp
I had previously covered how to install IIS 7 on Windows Vista Home Premium. This time I'll be briefly covering what you need to enable ASP.NET as well. As before, you'll want to select Control Panel from the Start menu, then click on the Programs link. Next, click on Turn Windows features on or off. Expand Internet Information Services, followed by the World Wide Web Services and Application Development Features.

Read More

How to install Internet Information Services (IIS) 7 on Windows Vista Home Premium

  • March 21, 2008
  • James Skemp
This guide covers Windows Vista Home Premium SP1, and may differ for other versions. I'll also only be covering the basic, default, installation. A guide covering the addition of additional features, like .NET capabilities, may be released as well. While limited, Windows Vista Home Premium allows Internet Information Services (IIS) 7 to be installed with little fuss, using the Control Panel interface. First, select Start > Control Panel.

Read More

HP Pavilion a6360t clean-up

  • March 4, 2008
  • James Skemp
With a new HP Pavilion a6360t, a number of things needed to be done to clean the machine up, from it's default factory setup. Uninstall Norton Internet Security (there's an uninstall option through the program's Start menu). After a restart, I still needed to go back and delete the empty directory from the Start menu. Uninstall My HP Games through the Control Panel.

Read More

Tips on using the Microsoft Access Upsizing Wizard

  • February 24, 2008
  • James Skemp
In no particular order, here are some tips if you're using the Microsoft Access Upsizing Wizard to convert your Access database to SQL (SQL Express 2005, in my case). The tips Make sure you've downloaded the Microsoft SQL Server Management Studio Express tools as well. When connecting with the above, make note of the server you're connecting to; you'll need this for later. For example, PAVA620N\SQLEXPRESS (that's computer name \ instance name of SQL Server).

Read More

Using Xml4Ssp 1.3 Rev 1

  • February 24, 2008
  • James Skemp
Xml4Ssp is a Windows XML generator for SlideShowPro. While the program still needs some work, it's pretty usable as it is. Since there's no real documentation, I'll be covering how I ended up using it to generate my latest gallery. Starting folder structure I began with the following folder structure: casio_images  Pearl FullsizeImage Images Thumb The only folder that contained content was the FullsizeImage directory, in which I dumped my JPG originals.

Read More

Regular Expression tester - JavaScript

  • January 21, 2008
  • James Skemp
In a previous post, I posted the code I used for a ColdFusion regular expression tester. This time I've got an attempt at a JavaScript version. There's a number of TODOs, but ... <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>JavaScript Regular Expression Tester</title> <style type="text/css">  #form_help {   float:right;   font-size:.8em;   width:50%;  }  #form_results {   margin:1em;   width:45%;  }  .highlight {   background-color:#ff9;  }  #form_highlighttext {   border:1px dashed #ccc;   margin-left:1em;   width:45%;  } </style> <script type="

Read More

Making oXygen XML Editor (9.1) portable

  • January 21, 2008
  • James Skemp
The below information is correct for version 9.1. Comments on other versions are appreciated. With flash drives becoming more and relevant, it's always good to find programs that can be run on these powerful drives. <oXygen/> XML Editor is one such program. Making <oXygen/> portable On the official site, there's a post regarding making <oXygen/> portable. However, what does it really involve? Easily enough, it doesn't involve much more than is stated in the post.

Read More

Warhawk: Game Mode: Top 25,000(s) Analysis - 1/18/2008

  • January 18, 2008
  • James Skemp
I'm a statistics kind of guy. I like numbers, since they're logical. I also like trends, and all that. So, here's a look at the current trends for what it takes to get into the top 25k, 50k, 75k, 100k, 150k, 200k, and 300k in the various game modes in Warhawk. Undoubtedly I'll have another post like this next month, around the same time. With over 417,000 players, total, these equate to around the top 6%, 12.

Read More

Regular Expression tester - ColdFusion

  • January 10, 2008
  • James Skemp
I stumbled upon some code I had written back in September, for testing regular expressions. This uses ColdFusion, and is currently 'running' on ColdFusion MX 6.1 and ColdFusion 7.0. It's a pity to not make it available, since it's such an easy template ... <!--- --- --- DESCRIPTION:  Basic way to test a regular expression. CALLED BY: ??? CALLS: ??? ASSUMPTIONS: ??? MODIFICATION HISTORY: DATE USER ACTION 09/24/2007 J.Skemp Created template.

Read More

Dragon Quest VIII: Character leveling overview

  • January 8, 2008
  • James Skemp
A guide covering the necessary experience to, and benefits of, leveling the four major characters in Dragon Quest VIII is now available. View the Dragon Quest VIII leveling overview. Comments and corrections appreciated.

Read More

XML creation: Part 8

  • January 1, 2008
  • James Skemp
In this guide, I'll be creating an XML file to store the Playstation games I own, and ultimately make the XML file 'pretty' for Web browsers. I've done this in the past, with my vehicle gas XML document. In part eight I'll be expanding upon our XSLT to group games based upon the system they belong to, as well as modify our XSLT to use xsl:appy-templates. This time ... I won't be going into a recap of what I've done in all seven of the previous parts.

Read More

XML creation: Part 7

  • December 31, 2007
  • James Skemp
In this guide, I'll be creating an XML file to store the Playstation games I own, and ultimately make the XML file 'pretty' for Web browsers. I've done this in the past, with my vehicle gas XML document. In part seven I'll be expanding upon our XSLT to remove elements that are empty, and change the sort order, for our existing XML file. Last time ... Up until now we've decided what we want to store, and how we want to store it, in an XML file.

Read More

XML creation: Part 6

  • December 30, 2007
  • James Skemp
In this guide, I'll be creating an XML file to store the Playstation games I own, and ultimately make the XML file 'pretty' for Web browsers. I've done this in the past, with my vehicle gas XML document. In part six I'll be using XSLT to modify the display of the XML document's contents so that it looks like the CSS-based output. Last time ... Up until now we've decided what we want to store, and how we want to store it, in an XML file.

Read More

XML creation: Part 5

  • December 29, 2007
  • James Skemp
In this guide, I'll be creating an XML file to store the Playstation games I own, and ultimately make the XML file 'pretty' for Web browsers. I've done this in the past, with my vehicle gas XML document. In part five I'll be using CSS to modify the display of the contents of the XML document. Last time ... Up until now we've decided what we want to store, and how we want to store it, in an XML file.

Read More

XML creation: Part 4

  • December 28, 2007
  • James Skemp
In this guide, I'll be creating an XML file to store the Playstation games I own, and ultimately make the XML file 'pretty' for Web browsers. I've done this in the past, with my vehicle gas XML document. In part four, I'll be adding a DTD so our XML document validates. Last time ... Up until now we've decided what we want to store, and how we want to store it, in an XML file.

Read More

XML creation: Part 3

  • December 27, 2007
  • James Skemp
In this guide, I'll be creating an XML file to store the Playstation games I own, and ultimately make the XML file 'pretty' for Web browsers. I've done this in the past, with my vehicle gas XML document. In part three, I'll be adding the actual data that we'll start with. Last time ... In part one, I went over what kind of data would be stored in our XML document.

Read More

XML creation: Part 2

  • December 26, 2007
  • James Skemp
In this guide, I'll be creating an XML file to store the Playstation games I own, and ultimately make the XML file 'pretty' for Web browsers. I've done this in the past, with my vehicle gas XML document. In part two, I'll be creating the layout, that I think will work. Last time ... If you recall, in part one, I went over the idea of what the XML file would store, and what layout I thought it might need.

Read More

XML creation: Part 1

  • December 25, 2007
  • James Skemp
In this guide, I'll be creating an XML file to store the Playstation games I own, and ultimately make the XML file 'pretty' for Web browsers. I've done this in the past, with my vehicle gas XML document. In part one, I'll be going over the idea and a layout that I think will work. The idea The XML file that I want to create should be able to store all of my Playstation games.

Read More

Playstation 3 and the Linksys WRT54G Wireless-G Boardband Router

  • November 24, 2007
  • James Skemp
While I initially hooked up my Playstation 3 a week ago, when I was posting to the official PS forums today, my second post, I was doing so to recommend a version of the router I'm using. Since both items are pretty popular now, it makes sense to write up a quick guide on them, I suppose. My equipment First off, there's my setup. I've had pretty experiences with Linksys, but poor experiences with Netgear, so Linksys I am.

Read More

W3C extended log format fields and IIS 6.0

  • November 6, 2007
  • James Skemp
In a previous article, I gave an overview of the World Wide Web Consortium (W3C) extended log format, in relation to Internet Information Services (IIS) 6.0. This time, I'd like to cover what each field provides, again in relation to IIS and a Web site, for statistical and debugging purposes. What fields are available Again, we've covered what fields are available in the W3C extended log format in a previous article.

Read More

A brief overview of IIS 6.0 and the W3C extended log format

  • November 3, 2007
  • James Skemp
In Microsoft Internet Information Services (IIS) 6.0, you can choose to use a number of different formats for your access logs. Access logs contain information about what files are requested, whether the request was successful or not. Of all the available formats, the World Wide Web Consortium (W3C) extended log file format is by far the most flexible format available, as you can select the information that you would like to log.

Read More

Log Parser SQL query syntax (high-level)

  • October 25, 2007
  • James Skemp
The following is a high-level look at Log Parser's (version 2.2) SQL syntax. This does assume that you understand the specifics of each part, but for those that do not, this will be covered in a future tutorial. (This is more for my use.)  Bolded elements are required for any valid query, whereas the other elements are optional. SELECT USING INTO FROM WHERE GROUP BY HAVING ORDER BY Again, details about the specific parts, with real-world examples, will be covered in a future tutorial.

Read More

Determining which IIS 6.0 Application Pool belongs to which application

  • October 6, 2007
  • James Skemp
In IIS 6.0, you can setup Application Pools for each of your sites. My knowledge of the exact benefits of this is somewhat lacking, but what I do understand is that these help applications (Web sites) stay within their own bounds, and prevent them from having a bad effect upon each other. For example, if one application is preforming poorly, as long as it's not a server-wide issue, the other sites on the server will be impacted minimally.

Read More

Log Parser script: Percent of status codes across all hits/requests

  • October 1, 2007
  • James Skemp
Note: This article was written using Log Parser 2.2. Therefore, while it may work for a different version, it may not. The following SQL can be used by Log Parser to generate a chart with the total requests (for a day, month, or year) and what percent each status code is of those requests. An example chart can be found at the end of this article. First, I assume that the below is put in the same directory as the logs you would like to parse.

Read More

How to ensure that performance counters continue after a restart

  • September 19, 2007
  • James Skemp
A few days ago my server was restarted in the early morning hours. I had been logging network and processor usage using Windows built-in performance monitoring, but when the server restarted, the logs did not. A bit of research later, it appears that there is a way to have Windows restart the logging after a system restart. To enable this, it seems you just need to have the log stop after a certain amount of time (for example, after x hours, or x days).

Read More

Using Log Parser to find users accounts used to log into an FTP site

  • September 13, 2007
  • James Skemp
The following Log Parser query can be used on FTP log files in order to determine what user names were used to login, or attempt to login, to an FTP site. logparser "select cs-uri-stem, count(cs-method) from ex*.log where cs-method like '%USER' group by cs-uri-stem order by count(cs-method),cs-uri-stem"  This assumes that you've added Log Parser to your path, and that you're running this from your log file directory.

Read More

Log Parser queries to find 400 and 500 http status codes

  • September 9, 2007
  • James Skemp
Note: This article was written using Log Parser 2.2. Therefore, while it may work for a different version, it may not. In a previous article, I discussed how to use Log Parser to find 404 errors in IIS log files. This time, I've made it a little broader, by giving some queries to find all 400 codes, and all 500 codes, through log files. There may be a better way to find these codes (instead of my IN statement), but a standard LIKE doesn't seem to work.

Read More

Compiling BlogEngine.NET source with Microsoft Visual C# 2005 Express Edition

  • September 5, 2007
  • James Skemp
The follow covers how to compile BlogEngine.NET from the most recently available source code. This was originally posted to the Codeplex discussions for BlogEngine.NET, and will eventually get moved into the wiki. (Update Sept 8, 2007: Added to the BlogEngine.NET wiki, but not yet linked from other pages. Also made a minor change to step one.) Compiling source with Microsoft Visual C# 2005 Express Edition 1) Download the current source code from the Releases tab or the Source code tab on CodePlex.

Read More

Is it really that simple - redirecting a single file on IIS

  • September 2, 2007
  • James Skemp
For various reasons, I've been working towards migrating from an Apache server to an IIS one for my sites. For Gavin's site, I couldn't get away with it, but I don't have any problem making things more difficult for myself :D However, this means that old URLs may not be working as they should. My experience with IIS is a working knowledge of it, and therefore I know what I need to know, picking up what I can.

Read More

Find 404 errors using Log Parser

  • August 4, 2007
  • James Skemp
Note: This article was written using Log Parser 2.2. Therefore, while it may work for a different version, it may not. The following code will generate a listing of calls that generated a 404 error. logparser "SELECT cs-uri-stem, cs-uri-query, date, sc-status, cs(Referer) INTO 404report.txt FROM ex.log WHERE sc-status = 404 ORDER BY date, cs-uri-stem, cs-uri-query" This assumes that you've currently got a command line open in the folder containing your IIS logs, and that you are logging the above information, as well as that logparser is setup in your PATH line.

Read More

Ubuntu 7.04 - Server Edition installed

  • June 26, 2007
  • James Skemp

Just about finished ... Quite the process, but things seem to be running okay - now I just have to determine whether it was worth it ...

Read More

Ubuntu Quickie: MySQL and PostgreSQL passwords

  • June 23, 2007
  • James Skemp
Another Ubuntu Quickie, this time on the default passwords for MySQL and PostgreSQL. MySQL mysql -u root UPDATE mysql.user SET Password = OLD_PASSWORD(’password’) WHERE User = ‘root’; FLUSH PRIVILEGES; \q PostgreSQL sudo -u postgres psql template1 ALTER USER postgres WITH PASSWORD ‘password’; \q

Read More

Ubuntu Quickie: Installing MySQL and PostgreSQL

  • June 21, 2007
  • James Skemp

For SQL on Ubuntu Linux, I decided it was easiest to just use the repositories to just install MySQL and PostgreSQL.

Read More

Configuring Apache for per-user pages

  • June 18, 2007
  • James Skemp

In a previous post, I covered installing Apache 2.2.4 on Ubuntu. Unfortunately, if you want to create content for this server, you need to either use the root account, or change the permissions on the /usr/local/apache2/htdocs directory. Let's keep things that way.

Read More

Quickie: Install ColdFusion 7.02 on Ubuntu 7.04 with Apache 2.2.4

  • June 15, 2007
  • James Skemp

Once again, may not be the best, but installing ColdFusion 7.02 on Ubuntu 7.04 (Apache 2.2.4 already installed).

Read More

Quickie: Install Apache 2.2.4 on Ubuntu

  • June 15, 2007
  • James Skemp
May not be the best, but ... here's how I installed Apache 2.2.4 on Ubuntu (7.04), based on David Winter's guide Building Apache 2.2 from source for Ubuntu Dapper. All code from a terminal, unless otherwise noted. sudo apt-get install build-essential cd mkdir src cd src I downloaded zlib from http://www.zlib.net/ (zlib source code, version 1.2.3, tar.gz format) into the src folder, and extracted it to the same.

Read More

Eclipse SDK 3.2.2 to Ubuntu 7.04

  • June 12, 2007
  • James Skemp

Having already installed JDK 5.0 on Ubuntu, it's time to install what I really wanted in the first place - Eclipse.

Read More

Installing Sun's Java Development Kit 5.0 Update 12 on Ubuntu 7.04

  • June 11, 2007
  • James Skemp

I don't have much desire to update from the repositories all the time, for whatever reason. Supposedly, if you run Eclipse from the download manager on Ubuntu, you can expect one slow experience. So ... time to start by installing Sun's Java.

Read More

Installing Apache 2.2.4 to a Windows-based computer, locally: Part 1

  • March 17, 2007
  • James Skemp

In February 2006, I wrote an article covering the installation of Apache 1.3.34, which can be found on my site, StrivingLife.net. In August 2006, I covered the installation of Apache 2.0.59. This time, I'll be covering the installation of the current version of Apache 2.2.x, Apache 2.2.4, to a Windows XP machine, for the purpose of local development.

Read More

Upgrading PHP (4.4.2 to 4.4.4 and 5.1.4 to 5.2.0)

  • November 26, 2006
  • James Skemp

In this article, we'll be upgrading PHP on our local, Windows, Web server. In previous guides we installed PHP 4.4.2 as well as PHP 5.1.4, both on the same machine, with the ability to switch as we like. However, we've yet to cover how to upgrade either installation (and upgrading is definitely a need).

At the time of this writing, the current versions of PHP are 4.4.4 and 5.2.0, for the 4.x and 5.x versions, respectively.

Read More

Upgrading Subversion and TortoiseSVN on Windows (1.4.0 to 1.4.2)

  • November 26, 2006
  • James Skemp

In a previous article, Installing Subversion and TortoiseSVN to a Windows XP, Home Edition, SP2, local machine with Dreamweaver 8, we installed Subversion 1.4.0 and TortoiseSVN 1.4.0 to our Windows machine. This time, we'll be quickly going over how to upgrade our installation.

Read More

PHP Forum Software Showdown Part 6: phpBB

  • November 25, 2006
  • James Skemp
It's that time again. This time, we'll be looking at phpBB. “phpBB is a high powered, fully scalable, and highly customizable Open Source bulletin board package. phpBB has a user-friendly interface, simple and straightforward administration panel, and helpful FAQ. Based on the powerful PHP server language and your choice of MySQL, MS-SQL, PostgreSQL or Access/ODBC database servers, phpBB is the ideal free community solution for all web sites.” Lot's of features, so let's get to it.

Read More

PHP Forum Software Showdown Part 5: PunBB

  • November 24, 2006
  • James Skemp

Almost there. This time, we'll be looking at PunBB. First, I did donate to PunBB development some time ago. At the time, I liked PunBB, and received some great support. It's been sometime since that time, so I don't know how things stand.

Anywho, “PunBB is a fast and lightweight PHP-powered discussion board. It is released under the GNU General Public License. Its primary goals are to be faster, smaller and less graphically intensive as compared to other discussion boards. PunBB has fewer features than many other discussion boards, but is generally faster and outputs smaller, semantically correct XHTML-compliant pages.”

Read More

PHP Forum Software Showdown Part 4: MyBB

  • November 22, 2006
  • James Skemp

This time, we'll be looking at MyBB. “MyBB is a powerful, efficient and free forum package developed in PHP and MySQL. MyBB has been designed with the end users in mind, you and your subscribers. Full control over your discussion system is presented right at the tip of your fingers, from multiple styles and themes to the ultimate customisation of your forums using the template system.”

Read More

PHP Forum Software Showdown Part 3: Simple Machines

  • November 21, 2006
  • James Skemp

Curiously, in late-September 2006, Simple Machines Forum turned three (it had been three years since 1.0 beta 1). That's curious because the current stable version of Simple Machines is 1.0.9, and there's a 1.1 RC3 out as well (as of late-October 2006).

Read More

PHP Forum Software Showdown Part 2: Vanilla

  • November 20, 2006
  • James Skemp

While the Vanilla forum's are fairly unknown, it's been around for a little over a year. “Vanilla is an open-source, standards-compliant, multi-lingual, fully extensible discussion forum for the web.” The version we'll be installing, 1.0.1, was released in late-August 2006.

File and folder size

The zip file for Vanilla 1.0.1 (which is the only download type) weighs in at just under 400 KB. Unzipped, it's almost 1.2 MB in size. Overall, that's pretty small.

Read More

PHP Forum Software Showdown Part 1: bbPress

  • November 19, 2006
  • James Skemp

A relative new-comer, bbPress “is forum software with a twist from the creators of WordPress”. The first public version, 0.72, was released in mid-October 2006, and the version we'll be installing, 0.73, was released a couple of weeks later. Downloading bbPress is fairly easy, since there's only two options – one for the installer in .zip, and one in .tar.gz.

File and folder size

At 170 KB, the zip file is extremely small, and is less than 500 KB unzipped. Of the six pieces of forum software that I'll be reviewing, bbPress is the smallest, but we'll see what that translates into as far as functionality.

Read More

PHP Forum Software Showdown

  • November 18, 2006
  • James Skemp

Hopefully by the end of the month, I'll have posted six reviews for six different pieces of forum software, that run on PHP (and MySQL).

Read More

Installing Python on a local Windows-based, Apache, server

  • October 7, 2006
  • James Skemp

In this article, we'll be installing Python on our local server via ActiveState's ActivePython. You can download the current version of ActivePython (2.4.3.12), as well as a select number of previous versions, from http://www.activestate.com/Products/ActivePython/

Since we're installing to Windows, download the 18.7 MB Windows (x86) MSI file (ActivePython-2.4.3.12-win32-x86.msi).

Read More

Installing Subversion and TortoiseSVN to a Windows XP, Home Edition, SP2, local machine with Dreamweaver 8

  • September 16, 2006
  • James Skemp
The Subversion aspect has been updated for Windows Vista. So too has the TortoiseSVN installation. The Dreamweaver aspect has not been touched. I also have an article about using Subversion.  When projects become large, or you have the need to keep information on what files you’ve modified, for any coding project, you may look for some kind of version control system. There’s software like Microsoft’s SourceSafe, but that can be costly, and according to some, it’s a clunky solution.

Read More

Installing Apache 2.0.59 to a Windows-based computer, locally: Part 4

  • August 28, 2006
  • James Skemp
In the previous three parts of this guide, we setup Apache 2.0.59 and then created the necessary connections to use ActivePerl, mod_perl, ColdFusion MX 6.1, ColdFusion MX 7.0.2, PHP 4.4.2, PHP 5.1.4, MySQL 4.1.18, and PostgreSQL 8.1.3. This time, we're going to bring everything together by creating a number of batch files to fairly easily switch between various Web server setups. What is a batch file? A batch file is basically a way to run a number of Windows prompts at once.

Read More

Installing Apache 2.0.59 to a Windows-based computer, locally: Part 3

  • August 26, 2006
  • James Skemp
In Part 1 of this Apache 2.0.59 guide, we setup Apache 2.0.59 on a Windows XP SP2 machine. We also setup Perl and mod_perl, attempting to mimic our Apache 1.3.34 install. In Part 2 of this Apache 2.0.59 guide, we setup ColdFusion MX 6.1 and 7.0. This time, we'll be continuing in our quest by adding support for both PHP 4 and PHP 5. In previous guides, we installed PHP 4 and PHP 5, so if you need to install either one, do so with the above directions.

Read More

Installing Apache 2.0.59 to a Windows-based computer, locally: Part 1

  • August 22, 2006
  • James Skemp
In a previous article, I described how to install Apache 1.3.34 to an average home computer, running Windows XP. Since then, only Apache 1.3.35 has been released that would allow me to update my guide, even though the current 1.3.x version is 1.3.37. There's also a desire on my part to use Apache 2.0, even though my host has not yet begun using them. For that reason, I'll be walking through a second installation of Apache on a home computer, so that both Apache 1.

Read More

Installing Eclipse 3.2 to a Windows XP SP2 machine

  • August 19, 2006
  • James Skemp
In this guide, we'll be installing Eclipse 3.2. The environment I'll be using is as follows. HP Pavilion a620n 2.20 Ghz, 960 MB (1 GB) of RAM Windows XP Home, SP2 What is Eclipse? “Eclipse is an open source community whose projects are focused on providing a vendor-neutral open development platform and application frameworks for building software.” (From the Eclipse.org Web site.) In other words, Eclipse is an open source editor capable of helping you write the necessary code for a number of programming languages.

Read More

Dual-installing PHP: Running PHP 5 and 4 on the same local, Windows-based, Apache, server

  • July 18, 2006
  • James Skemp
In previous guides, we installed PHP 4.4.2 and later moved our installation to a different folder. This time, we'll be installing the current release of PHP 5 (5.1.4) so that we can still switch back to PHP 4.4.2 if we'd like. Downloading PHP 5.x The current version of PHP 5.x is 5.1.4, so we'll begin by downloading that from PHP.net. We’ll want to download the (Windows Binaries) zip file, even though it is significantly larger in size than the installer (the zip file is almost 9 MB, compared to less than 3 MB for the executable), but allows us a deal more flexibility.

Read More

Upgrading our installation of ColdFusion MX 7.0.1 on a local Windows-based, Apache, server

  • July 12, 2006
  • James Skemp
In a previous guide, we installed ColdFusion MX 6.1 and ColdFusion MX 7.0.1. In this guide, we'll be leaving our installation of ColdFusion MX 6.1, and upgrading our installation of ColdFusion MX 7.0.1 to 7.0.2. Downloading the updater ColdFusion MX 7.0.2 can either be downloaded as a full installer, or as a simple updater. Since we've already installed 7.0.1, we can just use the updater. Go to http://www.adobe.com/support/coldfusion/downloads_updates.html and download the current updater, ColdFusion MX 7 Updater 2 (7.

Read More

Moving the location of PHP on your hard drive

  • July 1, 2006
  • James Skemp
In this article, we'll be moving our installation of PHP 4.4.2 from c:\php\ to c:\php4\. We'll be doing this primarily because we may like the ability to run multiple versions of PHP at one time, on our development server. This will pave the way for our future installation of PHP 5.1.4 (or the current version of PHP 5.x). The added benefit is that we'll have an idea of just how many documents are involved in a relatively simple change.

Read More

Upgrading phpMyAdmin (2.7.0-pl2 to 2.8.1) on a local, Windows-based, Apache server

  • June 20, 2006
  • James Skemp

In a previous post, we installed phpMyAdmin 2.7.0-pl2 to our local Web server. We did this so that we would have an easy way to administer our MySQL databases, from a PHP-based interface. This time, we'll be upgrading phpMyAdmin to version 2.8.1.

Downloading and unzipping

First, we'll need to grab the download for phpMyAdmin, from http://www.phpmyadmin.net/. As of this writing, the current version is 2.8.1. The zip file runs about 3.5 MB.

Read More

Upgrading to Zend Optimizer 3.0.1 on a local Windows-based, Apache, server

  • June 8, 2006
  • James Skemp
In a previous guide, we installed Zend Optimizer 2.6.2 to a local Windows-based Apache 1.x server, running PHP 4.4.2. This time, we'll be upgrading Zend Optimizer from 2.6.2 to 3.0.1. Downloading and backups First, we'll need to download a copy from http://www.zend.com/products/zend_optimizer/. We've already setup an account when we downloaded 2.6.2, so we can simply log in. Of course, if you've forgotten your password you can request assistance, and if you haven't downloaded Zend Optimizer before, you can setup an account.

Read More

Creating a Microsoft Management Console for our local Windows-based, Apache server

  • June 3, 2006
  • James Skemp

In a previous tutorials, we discussed how to access the Services control panel from Windows. In this tutorial, we'll be setting up a custom console that will provide us an easy way to access both our Services control panel, an Event Viewer, as well as other management tools.

First, we'll need to go to "Start" > "Run…", or press Windows + R on our keyboards. This will bring up a Run window. Type 'mmc', without the quotes, and press enter or OK.

Read More

Upgrading (our local install of) ActivePerl

  • May 26, 2006
  • James Skemp
In a previous guide, we walked through installing ActivePerl on a local machine. This time, we'll be upgrading ActivePerl. For this guide, we'll be upgrading from ActivePerl 5.8.7.815 to 5.8.8.817. However, since the installation requires the uninstallation of previous versions of ActivePerl, we'll simply be installing a new version of ActivePerl. If you have not installed Perl before, you can skip ahead to "Installing Perl" below. Please note that this guide will work equally well for the installation of, or upgrade to, ActivePerl 5.

Read More

Using a standard template to create a simple Web site

  • April 2, 2006
  • James Skemp

As stated in a previous article, there's a site, http://blog.html.it/layoutgala/, that offers free templates. Using these templates, you can easily create a site, so long as you have the content you need to fill the pages.

Read More

Installing ColdFusion MX 7.0.1 on a local Windows-based, Apache, server

  • March 31, 2006
  • James Skemp
Note: For information on updating to ColdFusion MX 7.0.2, see Upgrading our installation of ColdFusion MX 7.0.1 on a local Windows-based, Apache, server. Update: October 10, 2006 @ 7:11 pm - Thanks to Michael Bryce for his helpful comments regarding this documentation. In this article, we'll be walking through an installation of ColdFusion MX 7.0.1, Developer's Edition. Since we've already covered the installation of ColdFusion MX 6.

Read More

'Just enough HTML to be dangerous'

  • March 27, 2006
  • James Skemp

This time, we'll be covering the minimum HTML knowledge required to be truly dangerous. While an expanded understanding of HTML is not, per se, required, having at least some understanding will help in a number of ways. Of course, the more HTML you know, the less you rely on tools to do the work (which is a good thing, since we're not always able to use the tools that we're familar with).

Read More

Web site development: Content and Audience

  • March 25, 2006
  • James Skemp
There’s two major topics that come up when you’re talking with someone who wants to create a Web site, and they have a number of questions revolving around them. This article will be discussing these two major topics - content and audience - and raise the major questions that must be answered. Content is obviously one of the major topics because that’s what a Web site is - the display of content.

Read More

Adding PostgreSQL connectivity to ColdFusion MX on a local Windows-based, Apache, server

  • March 19, 2006
  • James Skemp
Having already added MySQL support for ColdFusion MX, it's time to look at adding PostgreSQL. For many of the same reasons we installed PostgreSQL with PHP, we'll be doing this to add to our potential resources. However, unlike our connection of MySQL with ColdFusion MX, we'll need to install some additional features to ColdFusion MX. (This guide assumes you've already installed PostgreSQL.) Downloading and installing the JDBC Driver The first thing we'll need to do is install a special driver for ColdFusion.

Read More

Adding MySQL connectivity to ColdFusion MX on a local Windows-based, Apache, server

  • March 18, 2006
  • James Skemp
Until now, we've yet to setup a connection to MySQL from ColdFusion MX. This has meant that while we can do cool database things in PHP (like WordPress), we can't in ColdFusion. Until now. This time, we'll be setting up MySQL 4.1.18 and ColdFusion MX 6.1 on our local server. Because of some of the choices that we've made before, this installation is going to be fairly quick. Setting up MySQL database and user First, we'll need to setup a MySQL database and user for ColdFusion.

Read More

Installing PostgreSQL on a local Windows-based, Apache, server

  • March 15, 2006
  • James Skemp
While we've already setup MySQL, another popular SQL server is PostgreSQL. Like MySQL, PostgreSQL is absolutely free, and will allow us to create databases on our local server. Downloading PostgreSQL We'll be downloading the most current version of PostgreSQL, which is 8.1.3 at the time of this writing. You can download the installation file from http://www.postgresql.org/ftp/win32. We'll want to download the regular zip file, called postgresql-8.1.3-1.zip, and weighing in at 21 MB.

Read More

Upgrading (our local install of) WordPress

  • March 11, 2006
  • James Skemp

In a previous guide, we walked through installing WordPress on a local machine. This time, we'll be upgrading WordPress. For this guide, we'll be upgrading from WordPress 2.0.1 to 2.0.2. Note that this guide will work equally well for upgrading to 2.0.3, 2.0.4 or 2.0.5.

Downloading WordPress

Read More

Setting up WordPress on a local Web server

  • February 28, 2006
  • James Skemp

Note: This guide should work equally well for WordPress 2.0.2 and above. For a guide on upgrading this 2.0.1 install, see Upgrading (our local install of) WordPress.

In our previous tutorials, we setup an Apache-based Web server, on a Windows XP home computer. The Web server is also running PHP and MySQL, as well as ColdFusion MX. This time, we'll be installing WordPress onto our local Web server. This installation will require us to work with both PHP and MySQL, and we'll be able to setup any number of WordPresses after we have completed this one.

Downloading WordPress

Read More

Installing ColdFusion on a local Windows-based, Apache, server

  • February 27, 2006
  • James Skemp

Note: For information on installing, or upgrading to ColdFusion MX 7.0.1, see Installing ColdFusion MX 7.0.1 on a local Windows-based, Apache, server.

In this tutorial, we'll be working through an installation of ColdFusion MX 6.1, Developer's Edition, on a local, Windows-based, Apache server. On this server, we've setup Apache, PHP, and MySQL, but will also want to have the ability to work with ColdFusion code (however, not necessarily on the same sites that we'll be using PHP). We'll be doing this to experience a more corporate Web-programming language – corporate primarily because of the costs associated with ColdFusion.

From the marketing, we see that "the [ColdFusion MX 6.1] Developer Edition, [is] a fully functional server for local development purposes only that helps you learn ColdFusion MX 6.1 or deploy to third-party hosting providers. Access is limited to localhost and one remote IP address.".

Read More

A local, Apache Web server, on a Windows XP computer

  • February 27, 2006
  • James Skemp
My intention is to write a number of guides that will help someone build a functional Web server for testing purposes. Since Windows is fairly popular, I've decided to outline how to install Web server programs on it. Since Apache is both powerful and free, I've opted to use it as the core, instead of IIS, or the like. I also plan on keeping the various technologies up-to-date, yet continuing to provide the instructions for past versions used, just in case.

Read More

Installing Zend Optimizer on a local Windows-based, Apache, server

  • February 26, 2006
  • James Skemp

Note: This guide should work equally well for Zend Optimizer 3.0.1 and above. For a guide on upgrading this 2.6.2 install, see Upgrading to Zend Optimizer 3.0.1 on a local Windows-based, Apache, server.

From Zend's FAQ,

Why use the Zend Optimizer; isn't PHP supposed to be quite fast already?

The standard Zend run-time compiler used by PHP is indeed extremely fast, generating code that is usually 2 to 10 times faster. But an application that uses the Zend Optimizer typically executes another 40% to 100% faster.

So, Zend Optimizer will help decrease the time spent on processing code. If you run the file we created a few steps back, probably called http://localhost/phpinfo.php (which basically runs <?php phpinfo(); ?>), you'll notice a line that says "This program makes use of the Zend Scripting Language Engine: Zend Engine v1.3.0, Copyright © 1998-2004 Zend Technologies". This is the standard Zend run-time compiler that is mentioned above. Once we download and install the Zend Optimizer, we'll see some additional lines here.

Download Zend Optimizer

Read More

Installing MySQL Administrator on a local Windows-based, Apache, server

  • February 25, 2006
  • James Skemp
Last time, we successfully installed both MySQL and phpMyAdmin on our local server. However, we only had one user. This time, we'll be installing MySQL Administrator, to give us the ability to add administer MySQL in a way that we can't do with phpMyAdmin. Before we go, please note that the MySQL Administrator does not take away the value of phpMyAdmin. In fact, phpMyAdmin is usually how you'll be able to administer your MySQL databases in the real world.

Read More

Installing MySQL and phpMyAdmin on a local Windows-based, Apache, server

  • February 24, 2006
  • James Skemp
Note: This guide should work equally well for phpMyAdmin 2.8.1 and above. For a guide on upgrading this 2.7.0-pl2 install, see Upgrading phpMyAdmin (2.7.0-pl2 to 2.8.1) on a local, Windows-based, Apache server. MySQL will allow us to create databases on our local server. With PHP, this will allow us to install applications like the free WordPress, as well as number of open source content management systems, not to mention bulletin boards and the like.

Read More

Installing PHP on a local Windows-based, Apache, server

  • February 22, 2006
  • James Skemp
While our previous article walked through adding Perl to our local server, Perl just isn't going to cut it for creating dynamic content. For that, we're going to have to install a more powerful language. As I said quite a few articles ago, if we would have gone the IIS route, we could have the use of ASP. However, since we're going the Apache route, that means PHP is our best choice.

Read More

Installing Perl on a local Windows-based, Apache, server

  • February 21, 2006
  • James Skemp

Note: This guide should work equally well for ActivePerl 5.8.8.817 and above. For a guide on upgrading this 5.8.7.815 install, see Upgrading (our local install of) ActivePerl.

Read More

Log file analysis of our Windows-based, Apache, Web sites

  • February 20, 2006
  • James Skemp
In our previous articles, we walked through installing Apache to a Windows XP home computer.  This time, we'll be setting up our log files for analysis, and installing a way to view the log file information. Log files are created by Web sites to track page views and visitors.  For example, if we go to a page on one of our local Web sites with Firefox, like http://website.localhost/, it adds the following lines to a file called access.

Read More

Setting up Dreamweaver and Nvu to recognize your server

  • February 19, 2006
  • James Skemp

Now that we've setup Apache on our local computer, and effectively created a basic Web server, it's time to look at setting up some popular programs to work with these sites. I'll be looking at two programs, the costly Dreamweaver (8) and the free Nvu (1.0).

Read More

Creating additional testing sites in Apache, on a local Windows computer

  • February 18, 2006
  • James Skemp

It may happen that you'd like to test multiple sites on one machine. There's a number of ways to do this. Following our previous tutorial, Installing Apache to a Windows-based computer, locally, we can either dump additional folders in our Apache root, or we can create additional subdomains under localhost.

Read More

Installing Apache to a Windows-based computer, locally

  • February 16, 2006
  • James Skemp

In this tutorial, we'll be walking through the installation of Apache 1.3 to an average home computer running Windows XP, Home Edition (SP1). Anyone running an average home computer, with a newer version of Windows, like XP, should be able to follow these steps and have an installation of their own. Older versions of Windows, like 98 and Me, should also be able to handle an installation, although some steps may differ slightly.

Read More

Great PHP and MySQL tutorial

  • November 5, 2005
  • James Skemp

There's a great tutorial over at http://www.freewebmasterhelp.com/tutorials/phpmysql detailing how to use PHP with MySQL. I worked through this tutorial, along with a couple of others, to setup a pretty simple PHP script. I'll be adding to it for a new gallery (as the old one is too bulky ... ).

Read More

StrivingLife.net network popularity

  • October 7, 2005
  • James Skemp

As I said this morning, site popularity can be determined by how many people are viewing the content, and how many people are using the content.

Read More

Network popularity

  • October 7, 2005
  • James Skemp

On Wednesday I said I was going to talk about how popular the various sites are. I didn't get to that on Thursday, so I'll be discussing that today.

Read More

Creating the network - the host

  • October 6, 2005
  • James Skemp

While in my last post I said host-singular, really there's two major 'hosts', in a manner of speaking. Usually, this will be the case. JamesRSkemp.net, for example, was one host. So, let's look at JamesRSkemp.net when it was one host.

Read More

Creating the network - locally

  • October 6, 2005
  • James Skemp
Today I'll be talking about how the StrivingLife.net network runs. In my opinion, you can break the network down into two large parts; my computer and my host's computer.  There are certainly other things that come into play, such as the Internet in general, and the support of Google and the sites that it brings up in the various searches I (need to) do, but they are (almost) always applicable when you talk about the Internet.

Read More

Rank and File Cheat Sheets

  • November 18, 2004
  • James Skemp
Since I'm a fan of rank and file puzzles, I've created a couple of sheets that can be helpful in solving these puzzles. You can download them below, in PDF format. These two sheets will allow you to have a guide you can use to cross off numbers as you use them. These are basically the same, save one has highlighted cells. Cheat sheet #1 Cheat sheet #1 with highlighting Rank and File is a logistical puzzle, common to The Original Logic & Math Puzzles™ by Ebb.

Read More

Using Disk Investigator to Regain Files

  • October 9, 2003
  • James Skemp
I've already discussed Disk Investigator in some detail (see Overview of Disk Investigator). However, what I really want to have is an example of the great use Disk Investigator is. In order to do this, I'm going to set up an example - an example of a situation that is not too uncommon - in order to show just how powerful it is. I urge you to follow along, with my example, on your own computer.

Read More

JRSs Terragen Water Window Guide

  • September 17, 2003
  • James Skemp
Description: Information regarding the Water window in Terragen™. Written during the release of 0.9.08, but, information should apply to various versions. This article is available in PDF format only. Read the article.

Read More

JRSs Terragen Atmosphere Window Guide

  • August 9, 2003
  • James Skemp
Description: Information regarding the Atmosphere window in Terragen™. Written during the release of 0.9.08, but, information should apply to various versions. This article is available in PDF format only. Read the article.

Read More

JRSs Terragen Terrain Genesis Window Guide

  • August 9, 2003
  • James Skemp
Description: Information regarding the Landscape window in Terragen™ - specifically the Generate Terrain option. Written during the release of 0.9.08, but, information should apply to various versions. This article is available in PDF format only. Read the article.

Read More

Bioform 0.99g: Basic Worms

  • April 17, 2003
  • James Skemp
The following covers the following worms in Bioform 0.99g. Worms: Spiral Worm Curl Worm Double Spiral Predef Worm (not yet contained here) Worm Predef (not yet contained here) Form Worm TwoD Worm Torus Spline Configs: Fan Wheel Trilobyt Anemone Horn Hull Cluster   none Fan Wheel Trilobyt Spiral Worm Curl Worm Double Spiral Form Worm TwoD Worm Torus Spline   none Fan Wheel Trilobyt  

Read More