Mappeo.com has been dropped

The mappeo.com project has been dropped due to lack of time and I’ve decided to release the code under GNU/GPL licence and it’s free for download.

The code is not complete but it’s at a very advanced stage and you shall quickly grasp the go-along of it.

Requires:

  • PHP 5 (With GD enabled)
  • MySQL 5+
  • A browser with JS enabled and AJAX support
  • Apache webserver (With mod_rewrite enabled)
  • A Google API key

More: http://mappeo.com

It’s been a while (again)

Well, well, how am I supposed to get this post going? No idea!

I have been working way too much lately and I really haven’t been able to find any time to write anything, although I have found quite a few interesting things about the Leopard OS I figure they’re not worth posting since you probably found them on a million other sites out there, besides, who reads my blog anyway?

I’m still going to film school and it’s actually quite interesting, I must say I’m learning a lot and I’m really exited to get working with it someday pretty soon, but on the other hand I realize I’ve gotten my self into probably the most complicated career, having so much competitors and all of them so strong, some simply brilliant, having said all that I must also say that I’m not the type of guy that let’s go easily:

If I want something then I’ll go for it, no matter what.

Know what that means?, exactly, you’ll be hearing a lot more of me in the not-so-distant future.

Cheers! ;)

5 days gone

I haven´t been around for 5 days now, actually I have been but very busy, finding solutions for projects and projecting new ideas onto my HDD.

Life is better when you have ideas.

Yesterday I started school, cinema school, and it was pretty nice, the only bad thing was that I had my at the shop for a regular revision and therefor had to go back and forth using public transport: “Metro”. I don’t have anything against public transport but sometimes it gets heavily crowded and it really makes me sick. However, I hope to have my bike back on track today and spare me the whole “Metro” part.

I´ll keep you posted on how school and my projects go, meanwhile I have work to do.

Cheers!

MySQL select by day, month or year

I’ve had quite a hard time these last few minutes. I needed to select certain values from my DB based only on the month, for example I had a date field in my DB and I needed to get only the values for a certain month. I guess I have to refresh my MySQL knowledge as this is something you should know.

Here’s the code and the way to do it:

Table: members
Field in DB: member_since (datetime field)

Rows in the “member_since” column:

2003-02-13 17:00:02
2006-02-11 14:32:01
1998-03-14 11:29:02
2001-02-19 04:52:09

And now select only the values where month is february:

$sql = ” SELECT * FROM members WHERE MONTH(member_since) = ’2′ “;

You could also use:

$sql = ” SELECT * FROM members WHERE MONTHNAME(member_since) = ‘February’ “;

To select values based on year or day you could use: DAY() or YEAR() in the query instead of MONTH().

Latest ongoings…

I have been away from my Mac for a couple of days and I’m just getting back to it. I really enjoyed the break and not having to worry about my -useless- email, chats and so on, I just kicked back and enjoyed my Xbox Live gaming, which by the way rocks!

Another thing I would like to mention is that last night I was up until 5:40 AM, not playing Xbox but working on a 1000 piece puzzle. I started to work on it at around 10:00 PM and by 5:30 I had it all completed, a thousand pieces in about 5 and a half hours is not that bad, is it? For those who might be wondering, it was a “The Simpson” puzzle on which you can find everyone on the show. I will update this and post a picture of it as soon as I can get my camera over here and download the picture, I guess I’m just too lazy to do it right now.

I also did some serious cooking today and it turned out to be pretty tasty, I actually love to cook but usually I don’t have enough time so the weekend is just perfect for it.

OK, I gotta scram now, need to take a shower and do something more before the day is over. Take it easy and enjoy the reading.

Cheers!