Burn My Time

I have to say that being able to script has to be one of the handiest skills I have. I spend a lot of time in front of a computer just ‘making shit happen’. There’s nothing cooler than running into a predicament working on a certain project and busting into the ‘scripts’ folder to finding a clearly labeled problem solver that I threw together some time earlier. I even enjoy noticing the amount of scripts I have growing. Or passing time browsing through old archives of scripts stored for absolutely no reason. I’m not a fan of losing even the least used scripts. Fuck a live Flickr frame, I need a frame demonstrating and describing the volumes of short scripts I’ve crapped out. Functional art?

“Oh fuckit, I’ll just make a script”

And never again manually repeat that task.

Purelydreaming has a little site-wide chat at the bottom of the page respectively called ‘The Commons’. It’s always been kinda lame so I hit it withi some AJAX using the MyBIC framework. It was amazingly easy to impliment. Mixing the AJAX base in with a teeeeny bit of extra Javascript made it pretty cool. It’s more like a ‘live’ chat now. I think it’s pretty spiffy. Note: the commons chat is for people who are logged in. heh. Removed the anon comments due to annoying people.

Ontop of that I added RSS feeds to peoples submissions. I don’t know why I didn’t do that any sooner. RSS feeds for people submitting their poetry, essays, short stories, etc only makes sense. I personaly enjoy the addition. I also have to work on RSS feeds into the journals and such.

Although I don’t write much in the way of stories or poetry anymore but I’m still quite proud of Purelydreaming.

I was coding on PD a lot today which leaves me with nothing interesting to say. I've been making little scripts to take all the content out of the old table style, parse it accordingly, then throw it in a new db. Once I hit a certain amount of traffic my old ways of organizing tables & databases started showing their lack of efficiency.

Great.

Over the past 3 years I've made some big things in PHP. 80% of it sucks & should go straight to the lethal injection without trial. Whats realy been frustrating me lately is back when I started learning PHP I did all my Mysql Queries like this.

————————————————–
mysql_connect(localhost,$dusername,$dpassword);
@mysql_select_db($ddatabase) or die( “Unable to select database”);
$query=”SELECT * FROM notes WHERE id='$id'”;
$result=mysql_query($query);
$num=mysql_numrows($result);

$i=0;
while ($i < $num)
{
$date=mysql_result($result,$i,”date”);
$name=mysql_result($result,$i,”name”);
$note=mysql_result($result,$i,”note”);

echo “$date - $name $note”;
$i++;
}
————————————————–

Now thats horrid. Unfortunately I started off with a shitload of bad habbits from a book whos name i can't remember. Arg. Although it would be outdated anyway, needless to say it's not in publish anymore. Now realy lame shit like the script above isn't to annoying to dig through & clean up. Even if it is 50,000+ lines of it. heh. What gets me worse is the horrid way I formatted mysql inserts.

————————————————–
$query1=”INSERT INTO people values('','$fname1','$mi1','$lname1','M','$bday1','$bmonth1','$byear1','$address','$city','$state','$zip','$county');
$result1=mysql_query($query1);
————————————————–

So I have to find every one of those old insert statements & fix it before I can make any changes to the db otherwise shit just comes to a screetching hault. arg. I think carrying around the book I had & using it more as a reference manual totaly skrewed me from the start. That & I'm lazy. and I picked one hell of a dull scripting language to devote so much time to.

It's almost as annoying as it is cool to watch how I'm learning this stuff. It's painfully slow & I don't seem to catch onto the realy usefull shit until knowing such things will cause more work becuase I have to mop up behind myself. I should just go to school for this shit n' quit trying to re-invent the wheel.

I get way to cought up in making things happen with what I know to just say “skrew all the projects, I'm learning this to know this”. I know I'd save myself from so much discomfort it wouldn't even be funny. But then I'd have t

My BSD server at work is starting to top the charts of 'old' shit. Time for some upgrades today. We'll see how quickly this is accomlpished.

Lately I've been essentialy *living* off of my Ev1 dedicated server (where this blog is hosted). I started migrating my everyday shit back to 'Remind', my server @ home. The fact my Ev1 server is a glutton for punishment fades sometimes. It hasn't been hacked for the better part of two years now. Unfortunatley, it hasn't very well been ugpraded much either. I've already stripped all my junk off of it. Now I just need to make heads or tails of my backups & I can start upgrading it. I've been meaning to streamline it for quite a while. I'd realy like to strip it down a bit n' get all the fluffy crap off it like the Plesk back end. The only minor problem with that is if/when the server gets compramised they just plug in a new one and slave my old hdd so it's back to the drawing boards.

Time for upgrades.

——-
Things are Hap'nen!

Battle spam at it's best. I remember installing X from source on my 64bit AMD system just for shits. I realized later that I didn't have full 64bit support, but that wasn't until after the poor little machine hammered away for a few days.