wherever

Server move update

All files moved back to server…finally. The web cam is online and kicking. Last time I checked, it’s pointing at Joe the frog. Page counts were lost again, no big deal. Also, the site stats reflect all of the moves, no data lost.

Distributed.net stats are working…kind of

I wrote the code for the stats engine based on these “guidelines.” To say the least, I screwed up by not dealing with changing IP addresses in the code when I made the stupid thing. So, I cannot change the code to deal with different IP addresses since the new IP addresses were used by other machines six months ago. Bummer. Also, the graphs are not being drawn correctly. If the error checking works as designed, it should just say “Fatal error…” or something like that. Alas, I’m sure I will find a solution.

SETI stats

SETI queue is causing some problems. For some unknown reason, it is not allowing external IP addresses to connect to the queue. I have set it up to allow any IP address to connect, but it’s still not working. Works fine with internal IP’s.

E-commerce working sample

Not sure why it’s a big deal, but this is still offline. I have fixed the errors with moving everything. No time to move the files over. Plus, working on the July update anyway. Guess I will do a major update. I decided it was too time consuming to convert the database over to anything besides Access. The data integrity is rather poor, containing all of the characters that screw with SQL to no end. Alas, I decided to simply create stored procedures in Access to speed up the transactions. I know they are not true stored procedures, but response time on the pages improved greatly with the move.

Photos database

Functioning normally. Added support for video files to the database. Example of the newly supported formats.

Book reviews site

Newly created site using ASP and Access. I’ve spent approximately 25 hours creating the site. It’s coming together, not quite there. The hardest part so far is again dealing with Access and the problems of having users updating data while other users are trying to read reviews. I think I have worked it as best as possible. The site is created piecemeal, using many include files. Also, the SQL queries output the entire rows of data into arrays so that I can immediately close the database connection. I then loop through the array to output the reviews. Not a complicated site at all, but the error checking is the best part. In looking back, I think the site would be better if written in PHP, but oh well. The hardest part so far is to have a look that is inviting to all, especially youngsters.