Passport

I finally went to get a passport today, which I should have done long ago, so I’ll be ready the next time I have to go to Vancouver. It was a lot faster & easier than I expected.

GP2X Problems

I still haven’t been able to get my bricked gp2x working again. The firmware was damaged badly enough by the attempted firmware upgrade that it can’t be restored by normal means. Neither Gamepark Holdings ore their US distributor has been able to resolve the problem. Gamepark & gp32z haven’t replied to any of my emails, although I’ve contacted gp32z via AIM. They need to find out from Gamepark how to fix it & they can’t replace it because the damage was caused by a firmware upgrade. From what I’ve seen on several gp2x message boards, a lot of other people are having the same problem. Needless to say, I’m NOT happy with this situation.

CPU Usage update

The changes I made to MacMegasite seem to have helped the CPU usage situation. It’s reduced the CPU usage by each execution of PHP.CGI by at least 50% as well as reducing the overall CPU usages. Here are the resource usage stats for the last few days, only counting CPU usage by PHP.CGI.

Date Total CPU time # php.cgi Avg CPU
12/05 3780.4000 32005 0.118
12/04 4786.4100 32526 0.147
12/03 3713.8700 31634 0.117
12/02 3720.8000 30562 0.122
12/01 4409.1400 17624 0.250
12/30 5685.9700 21089 0.270
12/29 5281.2200 21208 0.249

Prayers Needed

My mom is back in the hospital. This morning I got a call that she was being sent to the ER with possible congestive heart failure. I started freaking out because that’s what my father died from. I was at the ER around 10AM and they wouldn’t tell me anything or let me in until about 12:30. When I finally got to see her, she was awake & alert, so I asked how she was and she said “my backside hurts from laying here”. Thankfully it wasn’t life threatening, but they had to drain a lot of fluid from her lungs. She’ll be in the hospital for a few days. The last few weeks have been very difficult & I’ve been spending most of my time doing errands for her.

Eek-A-Mouse jamming with Irish pub musicians

Via Boing Boing:
Here’s a six-minute MP3 of reggae hero Eek-A-Mouse jamming with a bunch of traditional Irish pub musicians — fiddles, pipes, etc — at his 50th birthday party. The result is great; Eek-A-Mouse’s schtick is to sing in a high, Chinese-sounding falsetto, but to groovy reggae beats. Add to that some lively Irish fiddlers and you’ve really got something. Link (Thanks, Matt!)

Eek-a-mouse is my favorite living reggae performer & one who always brightens my day.

Lightweight Drupal home page

I’ve cleaned up my code for MacMegasite’s new page by breaking it up into separate include files for the left & right sidebars. The entire code is less than 50 lines and uses only a single database query and no calls to Drupal code.

Here’s the full code, not including the style sheet and sidebar content:

<html>
<head>
<meta http-equiv=content-type content="text/html; charset=utf-8">
<title>MacMegasite</title>
<style type="text/css" title="text/css">
<!--
@import url(INC/style.css);
-->
</style>
</head>
<body>
<img src="INC/logo.gif" class=logo>
<br>

<div class="left">
<?php include "INC/left.inc" ?>
</div>

<div class="right">
<?php include "INC/right.inc" ?>
</div>

<table class=content>
<?php
$dbname="your_database_name";
$host="your_host_name";
$user="your_user_name";
$pass="your_password";

$dbi = mysql_connect($host,$user,$pass);
mysql_select_db($dbname);

$query = "select nid, title, teaser from node where status=1 and promote=1 order by nid desc limit 10";
$res = mysql_query($query,$dbi);
while (list($nid,$title,$teaser) = mysql_fetch_row($res)) {
   print "<tr><td>";
   print "<h1><a href='http://www.macmegasite.com/drupal/node/".$nid."'>".$title."</a></h1>\n";
   print $teaser;
   print "<hr width=75% align=center><br>\n</td></tr>\n";
}
?>
</table>

</body>
</html>

CPU Usage

I think I may have come up with a real solution to MacMegasite’s CPU usage problem. I’ve created a new lightweight front page which doesn’t use Drupal but lists the content from the database. When you view an article from the front page, it uses Drupal to display it. The front page code is very simple, consisting only of a single database query to Drupal’s node table.

Bricked!

I managed to brick my Gp2x beyond repair when I tried to install the firmware upgrade. I got the ‘upgrading firmware’ screen for 15 minutes, followed by a black screen with nothing happening for 10 minutes. At that point, I reset it & got a white screen. It looks like the boot loader was damaged, since I don’t even get the initial black logo screen. I tried the unbrick most gp2x procedure with no luck.

I see that the SD card I was using was formatted FAT16 rather than FAT32 which is preferable. Maybe that’s why the flashing failed.

My new GP2X

I posted a few more pictures at Flickr.

It still has quite a few glitches, but it’s full of potential. It doesn’t seem to like USB 2.0 ports. It works perfectly with my G4 minitower, which has USB 1.1 only. I was able to get it working with my PowerBook by using a USB 1.1 hub, even an unpowered one. It also uses up the batteries very fast. It went through the non-rechargable batteries they included in less than an hour. I’m now using a set of NIMH rechargables and it’s lasting much longer.