Beach Jeté. More fun in the Philippines

Check out Jayvee Fernandez’s tutorial on how to create your own “More fun in the Philippines” meme. I did this using GIMP (it’s like Photoshop but it’s free!). To add text and change the opacity click on the links here and here.

Don Henricos’ Fun Run 2011 (for the benefit of Sagip Buhay) Results

3K (Male)

1. Mervin Guarte 9:05.48

2. Michael Bacong 9:06.68

3. Willie Rotich 9:07.70

3K (Female)

1. Luisa Raterta 15:39.30

2. Mary Grace Dela Torre 15:43.93

3. Lovely Gemeroy 15:51.37

5K (Male)

1. Alquin Bolivar 17:18.00

2. Jojit De Asis 18:20.60

3. Rami Lacson 18:58.79

5K (Female)

1. Irine Kipchumba 17:51:07

2. Nhe-Ann Barcena 17:58.00

3. Michelle De Vera 18:06.79

10K (Male)

1. S. Tuwei 28:50.58

2. James Midei 29:05.50

3. Justin Tabunda 30:44.25

10K (Female)

1. Joan Jeruto 32:42.25

2. Susan Jemutai 32:43:14

3. Janet Lomibao 38:24.61

The Don Henrico’s Run proved to be a great run – over 2,000 actually signed up and ran – the singlet’s and finisher’s shirt included in the kit had a 500 GC and ALL THE PROCEEDS went to SAGIP BUHAY (how many races can say that?). The water and Gatorade at the water stations were overflowing and even the Hawaiian (!!!) pizza at the end proved to be a hit! There’s not a lot of sunset runs nowadays and being on a Saturday – it’s a good time to run if you’re into back-to-back runs to simulate your glycogen depletion.  The race director could have improved on the marshalls and the markers but I’m sure they can work on that next year.  Congratulations to Heidi Ng and Don Henrico’s for this race – not bad for a first-timer!

(disclaimer: Heidi is a friend)

Philippine Game Development Festival 2011 results!

And the winners are:

Best Handheld/Mobile Game: Crazy Kite by Zeenoh Games

Best PC/Mac Game: Circle Speedster by Roan Contreras

Best Browser-based Game: Lords and Colonies by Anino Games

Innovation Award: Circle Speedster by Roan Contreras

Cultural Awards: Jan-Jan the Jeepney by Anino Games

Best Indie Game: Circle Speedster by Roan Contreras

GAME ON! (Student Project Awards)

People’s Choice Award: Hala! by Typhoon Games

Student Project Award Grand Champion for PGDF 2011: Gates of Heaven by TAM-OWL

16-year old Roan Contreras scored a hat-trick by winning 3 awards – the Innovation Award, Best PC/Mac Game and the coveted Best Indie Awards. Anino games scored a brace by winning the Best Browser-based Game and the Cultural Award. Crazy Kite by Zeenoh Games won in the Best Mobile/Handheld Game category. For the Best Student Project award – the public voting went in favor to eventual People’s Choice award winner Hala! by Typhoon Games but the Best Student Project Award for PGDF 2011 went to the addicting (It reminds me of the oldskool Typing Tutor games) Gates of Heaven by TAM-OWL. The victory was all the more sweeter for the TAM-OWL team because the group members were also part of GUILD (the professional student organization of the Game Development and Design Program of DLS-CSB) who were handling the logistics of organizing the Philippine Game Development Festival 2011. Special mention must be given to Charles Que and his team – he had them most number of nominations but wasn’t able to bag an award. But aren’t all nominees already winners in their own right just for being the pioneer nominees for these awards? To the nominees, winners and organizers – Congratulations! See you all at the Philippine Game Development Festival 2012

posted by Paul Pajo

Empire Avenue Verification

{EAV_BLOG_VER:a8aa881b79379c95}

that’s the Empire Avenue verification for blogs

If you haven’t been to Empire Avenue then check it out here.

see you at Empire Avenue!

Philippines’ TFR (Total Fertility Rate) vs. Contraceptive Prevalence

I’ll let you draw your own conclusions from this graph. Take note, when you say majority, it’s 50% + a little bit more. The contraceptive prevalence rate is now at 50.7% – can you actually use the word “majority” now?

I’ll probably update this post again.

 

MySQL notes on Foreign Key Contraints

If you go to this part on “foreign key relationships” in Introduction to Databases and MySQL:

you will see these SQL statements:

insert into orders set FK_cust_no=10;
insert into orders set FK_cust_no=11;

The problem with this is that it will trigger the foreign key constraint – how do you drop this?

If you go to W3Schools.com’s SQL Foreign Key Constraint, you will see these statements:

ALTER TABLE Orders
ADD CONSTRAINT fk_PerOrders
FOREIGN KEY (P_Id)
REFERENCES Persons(P_Id)

So if you wanted to drop the foreign key constraint you would type:

ALTER TABLE Orders
ADD FOREIGN KEY (P_Id)
REFERENCES Persons(P_Id)

the problem is you probably didn’t name your foreign key constraint and it was generated automatically by MySQL (maybe InnoDB was active?)

so what to do? Type in:

SHOW CREATE TABLE orders;

where the table you where you want to drop the foreign key constraint is, and you’ll get this message:

Aha! So the name of the foreign key constraint is actuall

orders_ibfk_1

(who knew?)

Drop the foreign key constraint by typing:

ALTER TABLE orders
DROP FOREIGN KEY orders_ibfk_1;

You can then proceed to typing in these statements:

insert into orders set FK_cust_no=10;
insert into orders set FK_cust_no=11;

Not getting any errors? Good!

What if you now try to put back the foreign key constraint using:

ALTER TABLE orders
ADD CONSTRAINT orders_ibfk_1 FOREIGN KEY(FK_cust_no) REFERENCES customer(cust_no);

You can’t! You’ll get another error (actually, more of the same …) :

ERROR 1452 (23000): Cannot add or update  a child row: a foreign key constraint

What to do?

Delete the rows that you added:

DELETE FROM orders WHERE order_no>11;

After deleting those rows type:

ALTER table orders
ADD FOREIGN KEY(FK_cust_no) REFERENCES customer(cust_no);

you should find the foreign key constraint back if you type:

SHOW CREATE table orders;

Happy MySQL-ing!

Step 7 for deploying fat_free_crm on heroku ryanwood style

from here:

see:

The Batman Equation

Apparently, the Batman Equation first appeared at [H]ard|OCP - there’s a nice breakdown of it at the Geometry section of MathUnderflow - also, check out the equations at PasteBin.

If you’d like to graph the equations, here the are:

( (x/7)^2 sqrt(abs(abs(x)-3)/(abs(x)-3)) + (y/3)^2 sqrt(abs(y+ 3/7 sqrt(33))/(y+ 3/7 sqrt(33))) - 1 )

( abs(x/2)-(3 sqrt(33)-7) x^2/112 -3 +sqrt(1-(abs((abs(x)-2))-1)^2)-y)

(9 sqrt(abs((abs(x)-1)(abs(x)-.75))/((1-abs(x))(abs(x)-.75)))- 8 abs(x)-y)

(3 abs(x) + .75 sqrt(abs((abs(x)-.75)(abs(x)-.5))/((.75-abs(x))(abs(x)-.5)))-y)

(2.25 sqrt(abs((abs(x)-.5)(abs(x)-.5))/((.5-abs(x))(abs(x)-.5)))-y)

(6 sqrt(10)/7 + (1.5-.5 abs(x)) sqrt(abs(abs(x)-1)/(abs(x)-1)) - 6 sqrt(10)/14 sqrt(4-(abs(x)-1)^2) -y) =0

ard|OCP”]

The Batman Equation via [H

One major reason why I would want to join the Reebok Zigtech Run on June 5 2011

Reebok Zigtech Run June 5 2011

I probably have another race that I’m running but hey – how many opportunities do you have to see everyone running in Zigtechs?

TONIGHT! SonicLogo.TV presents Paul David Hewson Day

SonicLogo.TV

presents

Paul David Hewson Day
“Music Can Change The World Because It Can Change People”

with

Julianne (covers “Beautiful Day”)
Lampara (covers “New Year’s Day”)
Wilderness
Flying Ipis (covers “With or Without You”)
Turbo Goth
The Bernadettes (covers “The Sweetest Thing”)
College Coed
Stela Mariz (covers “I Will Follow”)
The Jeffrey Zulueta Experience

9pm Tuesday
May 10 2011
Cafe Saguijo

gig-poster download at: http://farm3.static.flickr.com/2209/5705110700_975d3e6cee_o.jpg
credits to VectorPortal for the gig-poster image:
http://www.flickr.com/photos/vectorportal/4130838887/

Uhm, ***WHO*** are these bands?

Here’s the concept – you only have ONE NIGHT a MONTH to attend an indie music prodnight because either you are too busy or because of budgetary constraints – here’s something for you – different sounds from different bands (sometimes there’s a theme! sometimes!) .

Many times, some of the songs are so new it’s not even that complete yet. You get the picture. Drop by and start appreciating our very own Filipino independent (yes that’s indie!) music scene!

The Requisite BAND PAGES:
http://www.facebook.com/juliannetarrojamusic
http://www.facebook.com/lamparamusika
http://www.facebook.com/ohmywilderness
http://www.facebook.com/TheRoachClub
http://www.facebook.com/turbogoth
http://www.facebook.com/thebernadettes
http://www.facebook.com/CollegeCoed
http://www.facebook.com/pages/Stela-Mariz/183630161672165
http://www.facebook.com/pages/The-Jeffrey-Zulueta-Experience/74468842429

10 tips to enjoy the SonicLogo.TV experience:

1. Sometimes, we have themes – in this instance it’s Bono’s birthday so try to ask the band what song they are covering and expect them to give it their signature sound. Imagine what Turbo Goth can do to a U2 song – you get my drift?

2. Come early – we start on time – so if you’re trying to catch one of your favorite bands or you want to listen to one for the first time – you’ll miss your chance if you’re late. Really. Ask around

3. The requisite band pages are there for a reason – check out the band’s demos, like their fb pages, buzz them that you’re going, find out the lyrics of the songs and sing along come prodnight time

4. Bring your friends – it’s great to experience indie music prodnights with people who share your love for music.

5. Find out who the members of the bands are and try to say hello to them – they’ll appreciate it!

6. If the bands have schwags/merch – try to get it (t-shirts, stickers, EPs, CDs, demos etc.) and have it autographed. Oh bring your own silver/gold/black/blue marker please!

7. Bring a camera or a video and capture the experience. Ask the band or the manager permission first. Try not to use blinding flash/or point it directly to the band – try pointing your flash to the ceiling. Take about 10-15 pix and just get 1-2; have fun getting DECENT pix in Saguijo’s low-light atmosphere.

8. Patronize Saguijo – the food there is great! Check out the street food in and outside of Saguijo also – the fishballs are awesome if they’re there!

9. Ask the band/s when their next gigs are (and go there!). Check out the gig board also outside SaGuijo – there’s almost always a prodnight/gig happening there except on Mondays & Sundays (yes, SaGuijo honors the Sabbath that’s probably why it’s so successful! Biblical principles FTW!)

10. Post your pix/videos/shout-outs on your Facebook/Plurk/Twitter/Foursquare while you’re there (hey, it’s the 21st Century!) and show your friends who didn’t come what they missed! Bring them to the next SonicLogo.TV prodnight. Or better yet support the other prodnights also!

11. This is extra – like this page and share it also Please follow me on twitter.com/pageman and say hello if you bump into me in SaGuijo Feel free to add me on Facebook also – facebook.com/paulamerigo