Halcyon Repose

Crazy week so far.

It seems like I have been walking a tight rope bridge at work the past two days. Nothing too awfully bad, but bad enough that the stress was building up. Thankfully I was able to resolve the problems at work today (It is always good to see the customer happy, even if it was your mess up that caused them to get irate in the first place), and everyone was extremely happy on the forums as I left work. I can only hope that maintenance tomorrow goes nice and smooth, and that the rest of the week flows smoothly as well.

After work, I headed to the gym for a much needed work out. Not only have I not been able to go for the last few weeks, but I was in serious need of the stress relief. I hate being as out of shape as I am, but I have to keep a nice steady pace lest I reinjure my back. I am all paranoid about it now, but of course in this instance I feel that my paranoia is justified and actually required to keep me up on my feet throughout the competitive fencing season.

Afterwards my gym visit I am now nice and relaxed, and I am working on plowing through all the photos that have piled up on my camera. Who knows, maybe I will actually be able to get to one of the wide variaty of side projects that have been piling up on me lately…

On the lighter side of things the fencing floor should now have the last coat of varnish on it. And so we complete yet another construction project at the fencing center. It always amazes me that we continually get emails from other fencing centers asking for advice after they see the photos up on our website. It’s always strange to think you are good at something, because deep down I know there are plenty of people who have much more experience, but the clubs contacting us always ask the same questions we asked as we started our projects. The only difference is that we had an absolutely wonderful pool of members with a wide variaty of talents which allowed us to really bang out some amazing things. From the fencing floor, to the overhead mounted reels, we truly are thankful for everyone’s contribution. If another club isn’t as lucky to have the expertise necessary to undertake their own projects within their club, then we are always glad to answer any questions and lend them the experience that our labors have given us (read: school of hard knocks).

Current Music: The Eagles – Take it Easy

Spent today at Blizzcon, and I had a fun time. I didn’t really do anything but wander and chat with people but I am totally drained. I am really glad to see that the convention was such a huge success. I’ll be posting pictures when I get the time to upload them. I didn’t really get a chance to take pictures of friends, but I did decide to put my camera to use getting as many costume pictures as I could.

Till then, I shall tank up on Nyquil so that I can sleep through this gosh awful cold, and hopefully by morning it will have decided to completely clear out of my system.. Meh, we can call dream can’t we?

Connect to MySQL from the command line:

msql -u *username* -p

Connect to the database (schema):

USE *database name*

Check to see what database you are currently set to:

SELECT DATABASE();

NOTES on SCFC Database

CREATE TABLE users (
ID INT PRIMARY KEY,
FirstName varchar(30) NOT NULL,
LastName varchar(30) NOT NULL,
Email varchar(50) NOT NULL,
Phone varchar(20),
Password varchar(20) NOT NULL,
CoachID INT Not NULL
);

CREATE TABLE Lesson_Slots(
ID int primary key,
InstructorID int,
StartTime datetime,
StudentID INT DEFAULT 0,
Weapon INT DEFAULT 0
);

insert into users Values (1, ‘Jaime’, ‘Wood’, ‘jaime@southcoastfencing.com’, ‘(714) 836-9505′,’temp’,0);

insert into Lesson_Slots values (1, 1, ’2005-10-21 19:00:00′, 1, 1);
insert into Lesson_Slots values (2, 1, ’2005-10-21 19:20:00′, 1, 1);
insert into Lesson_Slots values (3, 1, ’2005-10-22 19:00:00′, 1, 1);
insert into Lesson_Slots values (4, 1, ’2005-10-22 19:20:00′, 1, 1);

select date_format(StartTime,’%M %d, %Y – %a’) from Lesson_Slots;

PERL Code;
#Initialize
use DBI;

my $dsn = ‘DBI:mysql:southcoa_scfc:localhost’;
my $db_user_name = ‘southcoa_scfc’;
my $db_password = ‘RealFencing’;
my ($id, $password);
my $dbh = DBI->connect($dsn, $db_user_name, $db_password);

# Query (using arguments
my $rs = $dbh->prepare(‘SELECT firstname, lastname from users
WHERE upper(firstname) = upper(?)
and upper(lastname) = upper(?)
and password = ?
and CoachID > -1′);

$rs->execute($in_fname, $in_lname, $in_code);
my ($sFirstName, $sLastName) = $rs->fetchrow_array();

$rs->finish();

# Number of rows returned
$rs->rows()
– Table to hold each individual class
DROP TABLE class_dates;
CREATE TABLE class_dates(
class_id integer(5) not null primary key auto_increment,
session_id integer(5) not null,
class_date date not null,
class_start time not null,
class_end time not null,
class_type integer(2) not null,
class_title varchar(100) not null,
order_id integer(2) not null,
deleted
);
ALTER TABLE class_dates ADD INDEX(session_id);

– Table to hold sessions (class groupings)
DROP TABLE class_session;
CREATE TABLE class_session(
session_id integer(5) not null primary key auto_increment,
session_title varchar(100) not null,
start_date date not null,
post_date date not null
);
ALTER TABLE class_session ADD INDEX(post_date);

– Table to hold email bodies
DROP TABLE mail_body;
CREATE TABLE mail_body(
Mail_ID integer(5) not null primary key auto_increment,
Mail_Type varchar(255),
Mail_Body text
);

– Table to hold all the class templates
DROP TABLE class_template;
CREATE TABLE class_template(
Template_ID integer(5) not null primary key auto_increment,
Class_Title varchar(100) not null,
Class_Type int(2) not null,
Class_Notes text,
Class_DayTime varchar(255),
Class_Length varchar(20),
Class_Cost varchar(10),
Class_Day int(1),
Class_Default int(1) default 0,
Deleted int(1) default 0
);
ALTER TABLE class_template ADD INDEX(Template_ID);

– Table to hold each individual who registers for class
DROP TABLE class_registration;
CREATE TABLE class_registration(
Registration_ID integer(5) not null primary key auto_increment,
Template_ID integer(5) not null,
Session_ID integer(5) not null,
Class_Date date not null,
Deleted int(1) default 0
);
ALTER TABLE class_registration ADD INDEX(Registration_ID);

– User Table
DROP TABLE scfc_users;
CREATE TABLE scfc_users(
User_ID integer(5) not null primary key auto_increment,
First_Name varchar(25),
Last_Name varchar(25),
Email varchar(50),
Address text,
Phone varchar(15),
Release binary(1),
Notes text,
Username varchar(25),
Password varchar(32)
);
ALTER TABLE scfc_users ADD INDEX(First_Name, Last_Name);
ALTER TABLE scfc_users ADD INDEX(Username);

– User Class Registration
DROP TABLE class_users;
CREATE TABLE class_users(
User_ID integer(5) not null,
Class_ID integer(5) not null,
Paid binary(1),
Comments text
);
ALTER TABLE class_users ADD INDEX (Class_ID);

– Instructor Table
DROP TABLE Instructor;
CREATE TABLE Instructor(
Instructor_ID integer(5) not null primary key auto_increment,
Instructor_Name varchar(30)
);

– Private Lesson Templates
DROP TABLE Lesson_Template;
CREATE TABLE Lesson_Template(
Template_ID integer(5) not null primary key auto_increment,
Instructor_ID integer(5) not null,
Time time not null,
Day integer(2) not null,
Student_ID integer(5) default NULL,
Status integer(2) default 0
);
ALTER TABLE Lesson_Template ADD INDEX (Instructor_ID);
ALTER TABLE Lesson_Template ADD INDEX (Day);

– Private Lesson Table
DROP TABLE Private_Lesson;
CREATE TABLE Private_Lesson(
Lesson_ID integer(5) not null primary key auto_increment,
Instructor_ID integer(5) not null,
Lesson_Date DateTime not null,
Student_ID integer(5),
Status integer(2) default 0
);
ALTER TABLE Private_Lesson ADD INDEX (Instructor_ID);
ALTER TABLE Private_Lesson ADD INDEX (Lesson_Date);

– For use on the web page, gets the next session that has not already passed
select min(post_date) from class_session where post_date > now();

SQL Scraps

select cd.class_id, ct.type_desc, date_format(cd.class_date, ‘%W’),
date_format(cd.class_date,’%M %D’), date_format(cd.class_start,’%l:%i’),
date_format(cd.class_end,’%l:%i %p’), cd.class_title
from class_dates cd, class_type ct
where cd.session_id = ?
order by ct.type_id, cd.order_id;

select min(session_id) from class_session
where start_date < CURDATE()
and post_date > CURDATE();

select session_id from class_session
where start_date = (SELECT max(start_date) from class_session);

(my $Class_ID, $Class_Type, $Class_Date, $Class_Start, $Class_end, $Class_Title) = $rs->fetchrow_array();

select date_format(class_end,’%l:%i %p’)
from class_dates;

– Class List
SELECT cr.Registration_ID, ct.Class_Title, ct.Class_Notes, ct.Class_DayTime,
cr.Class_Date, ct.Class_Length, ct.Class_Cost
FROM class_template ct, class_registration cr
WHERE cr.Session_ID = 14
AND cr.Template_ID = ct.Template_ID
AND cr.Deleted = 0;

DROP TABLE Whats_New;
CREATE TABLE Whats_New(
ID int not null primary key auto_increment,
PostDate datetime,
PostSubject varchar(255),
PostBody text,
Deleted int(1) default 0,
Visible int(1) default 1,
DisplayOrder int(1) default 0
);
ALTER TABLE Whats_New ADD INDEX(ID);
ALTER TABLE Whats_New ADD INDEX(PostDate);

DROP TABLE Image_Rotate;
CREATE TABLE Image_Rotate(
ID int not null primary key auto_increment,
Image_Location varchar(100),
Image_Comment varchar(75),
Display_Order int(2) default 0,
Date_Created timestamp
);
ALTER TABLE Image_Rotate ADD INDEX(ID);

–Payment Table
DROP TABLE Payment;
CREATE TABLE Payment(
ID int not null primary key auto_increment,
User_ID integer(5) not null,
Payment_Amt float(4,2),
Pay_Start datetime,
Pay_End datetime,
Payment_Type integer(1),
Payment_Note TEXT,
Payment_Currency integer(1),
Date_Entered datetime,
Entered_By integer(5)
);

ALTER TABLE Payment ADD INDEX(Pay_Start, Pay_End);
ALTER TABLE Payment ADD INDEX(User_ID);

– Credit Table
DROP TABLE Payment_Credit;
CREATE TABLE Payment_Credit(
ID int not null primary key auto_increment,
User_ID integer(5) not null,
Credit_Amt float(4,2),
Credit_Remain float(4,2),
Credit_Note TEXT,
Date_Entered datetime,
Entered_By integer(5)
);

ALTER TABLE Payment_Credit ADD INDEX(User_ID);

– Payment Types
DROP TABLE Payment_Type;
CREATE TABLE Payment_Type(
ID int not null primary key auto_increment,
Payment_Type varchar(25)
);

insert into Payment_Type values (1,’Dues’);
insert into Payment_Type values (2,’Class’);
insert into Payment_Type values (3,’Equipment’);

– Payment Types
DROP TABLE Payment_Currency;
CREATE TABLE Payment_Currency(
ID int not null primary key auto_increment,
Currency varchar(25)
);

insert into Payment_Currency values (1,’Cash’);
insert into Payment_Currency values (2,’Check’);
insert into Payment_Currency values (3,’Credit Card’);
insert into Payment_Currency values (4,’SCFC Credit’);

Links:

Tutorial
Date and Time Functions

I finally got out of my funk. I seem to go through these periods where I am super depressed, everything pisses me off, and I just want to be left alone to mop by myself for awhile. Typically these spells only last for a few days, but this last one lasted for about a week. I hate being in those moods, because there is nothing I can do about it, I just have to ride it out.

At least life is all shiney happy again, and just in time for the upstairs reconstruction at the fencing center. Nothing like some good manual labor to feel better about yourself. And I scheduled a massage appointment for myself on Sunday, ever since I got back into the active side of life again, my back has been one big knot… What I need is to hire a big Russian woman named Ulga to beat my back into submission…

I have been a fan of Joss Whedon’s for a really long time. My friend Shane got me into Buffy the Vampire Slayer at the beginning of the second season, and I never really looked back. When he spawned off Angel, I added it to my list of must see TV and when he started Firefly, I was really excited about the fresh start he was making with the show.

Joss’s writing has always had an indefinable something for me that always kept me coming back for more. He can take some serious issues, and tackle them in a way that brings out the humor and yet still stays poignant. His dialogue is always witty, and he has a way of giving his characters a voice or style of speaking that is instantly recognizable. Every character interacts with everyone else as a person, not a plot device, yet they still fulfill the same purpose in the end. I know that Joss must spend much of his time working on his projects, but some how they come off so brilliantly tongue in cheek that they seem to spring fully formed from his mind.

It saddens me that I don’t get my dose of Joss every week now. Firefly was cancelled, and Buffy and Angel both drew to a close, so I feel like there is a hole in my life, and it is Joss shaped. I can only hope that Serenity does well enough to warrant some more movies, and that Joss can continue to work his magic. He is working on the screen play for Wonder Woman, so gives me good hopes for the film, and he also works on a number of comic books, which causes the little geek in me to squeal like a little girl. I haven’t done comics in ages, but I would go back for Joss.

Finally the whole reason for this little Joss tribute has to do with an article written by Orson Scott Card about Serenity. I have read numerous books by Orson, chief among them the Ender’s Game and the Seventh Son books. His character development is some of the best I have seen, and for him to give props to Joss in this way really raises my opinion of both of them.

Serenity was absolutely phenomenal. Go out and see it. Don’t worry if you haven’t seen the tv show, the movie still packs a punch. As always, Joss’s writing is biting and leaves a lasting impression. The dialogue is witty, and the cast pulled off another excellent job.

The Long Beach Invitational went well today. I fenced horribly, but then I haven’t competed for around 2 years. I hated that the first tournament of the season was such a strong one, but no helping that, I have a few more tournaments before I can hope to back up to where I was. This was my obligatory “you haven’t fenced in a while, so you have to get your arse kicked” tournament… hopefully I have gotten that out of the way now.

It is Serenity Day!

Everyone, make sure you check this movie out. Do it for the kids

Now that I have bared my soul, on to the rest of my gritty life.

Apparently I have a whole block of my life missing. I say this because I received a letter in the mail two days ago from the LA Sheriff’s department telling me that I am past due on paying a parking ticket. A ticket I received at 9am August 29th. Not only was I apparently not at work that morning, but I was in a part of LA I have never been in before.

Assuming work calms down tomorrow, I will be giving them a call to let them know that apparently there has been a mistake. I’ll tell them what happened, or what didn’t happen as the case may be, and I will listen to them tell me that there is nothing that can be done and I will have to pay the ticket. I mean there is my license plate number in the letter along with a rough description of my car, and without some sort of concrete proof, that will probably be all she wrote.

This is just totally crazy, the sort of thing you would expect to see on some cheesy TV show at 10 o’clock at night. Regardless of how crazy it is, I guess it is better to pay the $45 ticket than to have that go on my “permanent record”. Crazy…..

On the lighter side of things I actually got my Death Cap For Cutie tickets.. So very very happy.

The Long Beach Invitational tournament is this weekend. I have actually signed up for the first time in 3 years. I don’t expect to do great, as I spent all summer recovering from a sprained back, but gosh darn it, I plan on enjoying myself.

Family truly is important. I have friends that are not very close to their parents, and are even further removed from their extended family, and in a way that is very sad. I take that back, it is sad in almost all ways. They have their reasons for not keeping in touch, and to tell the truth, if I was in the same situation, I would probably do the same thing. Not everyone can have a wonderful family, but thankfully I do. I have a loving sister and parents, and all my aunts, uncles and cousins are great.

I truly enjoy spending time with them, and now that I can actually afford a plane ticket to pay them a visit from time to time, I am a much happier boy. My family is, and always will be, the balm for my soul. Sure there is the usual family politicking that goes on, but most of them are capable of putting all of that aside when the holidays come around. There really is a love that runs through my family and I am honored to be a part of it.

The only reason I bring all of this up is I just got back from visiting Newnan for my cousin’s wedding. It was a great trip, I got to visit everyone briefly, and I was able to see the beautiful bride on her wedding day. My only complaint is that it was all over with too quickly. It was a short weekend from the get go, but at least I now have something to look forward to come December.

For now I have some passable photos to remind me of this past weekend, and I have a new Photo Album link on the right side of the page that can take me there anytime I want. Feel free to look around, just remember to close the door behind you; we don’t want the cats to get out.

How rare the rain here is in Southern California. A storm has been threatening all night, lightening cutting through the air, and the sound of thunder echoing through the night.

Such thunder storms are not common here, and they bring back memories of my years in Nashville. I miss the storms, for the first time in all my life I felt something akin to fear when the thunder started rolling this evening. I wouldn’t exactly call it fear, but I was in awe of the wonders of nature. I could certainly understand how many people could fear a thunderstorm, or why dogs hide under the bed as lightening cracks across the sky. Back in Nashville it was a common occurrence, but either I have been so long without it, or there was a something different that was present in the storm tonight.

Either way it seemed to be more primal, even if the storm didn’t last that long. It called to mind images and reminded me of days gone by. Good days, fun days, days that I am more than happy to lose myself in.

I need to call my parents……