I don't know …

I still haven’t exactly figured out how or why it happened, but somebody must have called IT to install a firewall to protect me from the outside world. I suppose it was for the best initially because exposing my reckless behavior unprotected would have led to much longer and undesirable consequences later on in time.

I’ve been sniffing ports for quite some time to better understand how to compromise this firewall. But I haven’t had much luck yet. Brute forcing through it has just led to much frustration and aborted attempts at self expression.

I don’t believe IT is out to get me. In fact I believe IT has my best interests at heart and for that reason can’t allow me to compromise the firewall. So with that realization I think there may be a far more soft touched answer that I need to come upon.

My firewall just kicked in again and is prodding me to erase all I’ve written. I will quickly post this now to pre-empt it. Good luck on the other side.

So I’ve got to say that I must confess that I’ve had an epiphany earlier today. Sure it may not seem like much to most who’ve mastered the art of moving without thinking, however this task is somewhat more difficult to those of us a little bit more considerate of the effects that each of our actions would have on all matter around us.

And so it went that I was hungry but would not budge. The temptation of clicking on the Windows Start Menu was just to great to pass by. Visiting frivolously the same websites, myspace, facebook, google reader, and gmail, in a for if else then next while as if loop was just too exciting to pass up.

Then it stopped. I got up, refused to engage in meaningful and ever so unconstructive banter with myself to debate as to whether the action I wish to take is an action that is more important than the Start menu clicking phenomenon. And as if to disobey myself, I simply left the house, and headed to El Pollo loco, with no questions asked and no consideration given to the incessant need to delay myself.

It was very interesting I have to say to move as an automaton without a thought to question the movement. Is that what it feels like to be a robotic human, eating, shitting, sleeping, and fucking through space time without a care in the world?

Mind blowing …

Tell me someone, since I’m at a loss for ideas. How do I refresh myself? I have no F5 button that I can press so I’m somewhat confused with this idea.

A refresh would be a wonderful thing right now. I’d be able to easily clear all the leaks from my memory and retain that which I find to be of value. Everything else could be easily recycled into the bin or even better: trashed.

So the predicament remains; how do I refresh myself? Would uploading a new photo on my myspace profile make me a new man? Somebody I can front off into the online frontier with a new air of confidence about me? Perhaps if I splashed some new skins across my page with some hip new colors? What if I spammed leafs of mary jane and bob marley across the various sections of my page?

Would that refresh who I am into a new being that can set forth on this brand new journey?

I’m at such a loss for ideas that even this blog has to end prematurely for a lack of further ideas.

ALT 43
IRON 174
TOTAL IRON BINDING CAPACITY 305
IRON SAT 57
CHOLESTEROL 218
TRIGLYCERIDE 93
HDL 48
LDL CALCULATED 151
CHOLESTEROL/HIGH DENSITY LIPOPROTEIN 4.5

I’m curious to know if there are still people out there who are visiting, subscribing, or reading my blog? I know I haven’t updated for quite so I must have lost quite a few readers in the process. Is anyone still out there reading this?

Comment and let me know alright?

In the meantime, listen to this album.

I was listening to the Sail Radio Edit by Armin Van Buuren when the gardeners outside started up the lawnmower .. As the lawnmower went off with its whirring noise it strangely resonated with my trance music, enlivening it. It was cool ..

Financial Manager got its first “official” theme based on the new css setup. Its called crimson and sports an ubercool dark look for those of us that are brightness challenged.

I’ve also added a new favicon for kicks. Pretty slick

[me] are the most intense, profound, powerful characters in the zodiac. Even when they appear self-controlled and calm there is a seething intensity of emotional energy under the placid exterior. They are like the volcano not far under the surface of a calm sea; it may burst into eruption at any moment. But those of us who are particularly perceptive will be aware of the harnessed aggression, the immense forcefulness, magnetic intensity, and often strangely hypnotic personality under the tranquil, but watchful composure of [me].

Does this mean I’m an uber-sexy man-beast? Or an highly unstable element with incredible amount of potential energy with the potential to earth destroy worlds in kinetic form?

You decide!

(Note: Those are the only two options)

The last few features I added to the Financial Manager didn’t have proper “theme” support via the style sheets. Unfortunately this was because as I was building it, I threw together the html and css in a very quick and messy way. I was using tables to style the pages rather than layers and other such things.

Because I have to add style support for the last new feature I took this moment to “redo” the css support. I took it from trailer trash to supermodel.

The good thing about this is that it is now supports “true” dynamic css templates since the javascript style changing code is out. This should also speed up the Financial Manager considerably. On the flip side though, I’m sure Internet Explorer is now not supported.

Behold, my beautiful css code.

.ns_page_title { font-size: 200%; }
.ns_page_title a { color: #252525; text-decoration: none; }

.ns_month_nav { border: 1px solid #555; background: #b7b7b7; margin-bottom: 15px; }
.ns_month_nav ul { list-style: none; padding: 6px; margin: 0; text-align: center; font-family: "Trebuchet MS", sans-serif; font-size: 75%; }
.ns_month_nav ul li { display: inline; font-weight: bolder; }
.ns_month_nav ul li.selected { font-size: 140%; color: #363636; }
.ns_month_nav ul li a { color: #363636; text-decoration: none; }
.ns_month_nav ul li a:hover { color: #00746b; }

.ns_parent_title { font-size: 170%; }
.ns_parent_title a { color: #252525; text-decoration: none; }

.ns_parent { margin-bottom: 15px; }
.ns_parent table { border: 1px solid #555; width: 100%; border-collapse: collapse; }
.ns_parent table td { padding: 6px 10px 6px 6px; font-family: "Trebuchet MS", sans-serif; font-size: 75%; }
.ns_parent table td.amount { width: 110px; }
.ns_parent table td.estimated { width: 110px; }
.ns_parent table td.actual { width: 110px; }
.ns_parent table tr.head { background: #b7b7b7; }
.ns_parent table tr.head td { color: #363636; font-weight: bold; }
.ns_parent table tr.head td.account { text-align: left; }
.ns_parent table tr.head td.amount { text-align: center; }
.ns_parent table tr.head td.estimated { text-align: center; }
.ns_parent table tr.head td.actual { text-align: center; }
.ns_parent table tr.content { background: #f6f6f6; }
.ns_parent table tr.content:hover { background: #ececec; cursor: pointer; }
.ns_parent table tr.content td.amount { text-align: right; }
.ns_parent table tr.content td.estimated { text-align: right; }
.ns_parent table tr.content td.actual { text-align: right; }
.ns_parent table tr.buttons { background: #ebebeb; }
.ns_parent table tr.buttons input { font-family: sans-serif; font-size: 80%; }
.ns_parent table tr.foot { background: #e1e1e1; font-weight: bold; }
.ns_parent table tr.foot td.amount { text-align: right; }
.ns_parent table tr.foot td.estimated { text-align: right; }
.ns_parent table tr.foot td.actual { text-align: right; }

.ns_child_title { font-size: 135%; margin-left: 50px; }
.ns_child_title a { color: #223344; text-decoration: none; }
.ns_child_title span a { color: #999; font-size: 60%; font-style: italic; }

.ns_child { margin-bottom: 15px; margin-left: 50px; }
.ns_child table { border: 1px solid #555; width: 100%; border-collapse: collapse; }
.ns_child table td { padding: 6px 10px 6px 6px; font-family: "Trebuchet MS", sans-serif; font-size: 75%; }
.ns_child table td.date { width: 110px; }
.ns_child table td.amount { width: 110px; }
.ns_child table td.estimated { width: 110px; }
.ns_child table td.actual { width: 110px; }
.ns_child table tr.head { background: #b7b7b7; }
.ns_child table tr.head td { color: #363636; font-weight: bold; }
.ns_child table tr.head td.date { text-align: left; }
.ns_child table tr.head td.description { text-align: left; }
.ns_child table tr.head td.amount { text-align: center; }
.ns_child table tr.head td.estimated { text-align: center; }
.ns_child table tr.head td.actual { text-align: center; }
.ns_child table tr.content { background: #f6f6f6; }
.ns_child table tr.content:hover { background: #ececec; cursor: pointer; }
.ns_child table tr.content td.amount { text-align: right; }
.ns_child table tr.content td.estimated { text-align: right; }
.ns_child table tr.content td.actual { text-align: right; }
.ns_child table tr.fields { background: #ebebeb; }
.ns_child table tr.fields input { font-family: sans-serif; font-size: 80%; width: 100%; }
.ns_child table tr.buttons { background: #e1e1e1; font-weight: bold; }
.ns_child table tr.buttons td { text-align: right; }
.ns_child table tr.buttons input { font-family: sans-serif; font-size: 80%; font-weight: normal; }

.ns_edit { margin-bottom: 15px; margin-left: 50px; }
.ns_edit table { border: 1px solid #555; width: 100%; border-collapse: collapse; }
.ns_edit table td { padding: 6px 10px 6px 6px; font-family: sans-serif; font-size: 75%; }
.ns_edit table td.date { width: 110px; }
.ns_edit table td.amount { width: 110px; }
.ns_edit table td.estimated { width: 110px; }
.ns_edit table td.actual { width: 110px; }
.ns_edit table tr.fields { background: #f6f6f6; }
.ns_edit table tr.fields input { font-family: sans-serif; font-size: 80%; width: 100%; }
.ns_edit table tr.buttons { background: #e1e1e1; }
.ns_edit table tr.buttons td { text-align: right; }
.ns_edit table tr.buttons input { font-family: sans-serif; font-size: 80%; }

So with all the spam (features) I’ve coded into the Financial Manager recently, I’ve decided to take a step back and do some tweaking to make it execute more efficiently.

Running one of these and storing the results in a memory array for usage,

$sql = "
select catid, sum(actual) as actual, sum(estimated) as estimated
from expenses_items
where userid = '" . $_COOKIE['UserID'] . "'
and date like '" . substr( $date, 0, 7 ) . "%'
group by catid
";
$rx = $conn->Execute($sql);

is always better than running two of these in a loop and using them directly.

$sql = "
select sum(estimated) as estimated
from expenses_items
where userid = '" . $_COOKIE['UserID'] . "'
and catid = " . $r1->fields['id'] . "
and date like '" . substr( $date, 0, 7 ) . "%'
";
$r2 = $conn->Execute( $sql );

$sql = "
select sum(actual) as actual
from expenses_items
where userid = '" . $_COOKIE['UserID'] . "'
and catid = " . $r1->fields['id'] . "
and date like '" . substr( $date, 0, 7) . "%'
";
$r2 = $conn->Execute( $sql );

But when you’re in a hurry to code things to a level of functionality, who has time to think of efficiency I don’t pay myself enough for that.

In any case, on my test server the execution time went from 0.30 seconds to 0.12 seconds. On my live server, the execution time is now 0.05 seconds — super fast!