Thursday, September 22, 2022

NEW Spritesheet Tool in town!

Ever heard of the 2D animation tool called, Kage Studio?  It has the Macromedia Flash feel to it.  Yes, Macromedia Flash -- not Adobe Animate.

Kage Studio is a free vector art animation tool which handles vector editing pretty much like Inkscape.  You draw the shapes and modify them with Select Tool and/or Node Tool.

I'll write a different article on how to use this free animation tool, but for now, let's focus on how we can make game art out of this tool.

Kage Studio is free and open source, currently hosted on SourceForge so, nothing to worry.  Now, download and install Kage Studio then open the demo file included with it, called demo.ksf

Adjust the Width and Height to fit the current artwork.  Make note of the Width and Height you set -- you might need it on your code to specify the width and height of each frame on your spritesheet.

Now. you are ready to export it as Spritesheet.  Click on File -> Export -> PNG... Spritesheet PNG.

Set the filename then check the Spritesheet for your self.

Load that to your game engine and see it get animated.

I've made a quick test with Phaser.  It should be doable with any other game engines.

With Kage Studio, you can have your sprite animation previewed inside the tool before loading inside your game.  Even reuse your sprites to create your cut scenes or cinematic and vice versa.


~creek23

Saturday, March 20, 2021

[SOLUTION] Cannot Create Foreign Key

Been a long while since I last needed to have Foreign Key in my Database.

Much of my applications are not so complex that I don't bother employ a Foreign Key.

Now that I have to, it took me about three whole hours figuring out the problem.

I cannot create Foreign Key with HeidiSQL!

I've been using HeidiSQL for over ten years now.  It's only now that I faced problem with this MySQL GUI.

My latest Wamp Server uses MariaDB.

Thinking it could be MariaDB having a problem and not HeidiSQL, I tried using MySQL instead.

Still, with MySQL, I could not successfully create Foreign Key!  And I've been pulling my hairs off!

Somehow, this problem has been discussed over at HeidiSQL forums a year ago.  Even the author of HeidiSQL couldn't figure out why because the problem isn't happening on his side.

Luckily, a user named, Patsy, figured out why.

For some reason, my Wamp Server used MyISAM as default Table Engine instead of the more common, InnoDB.

So, in the end, it wasn't a bug in HeidiSQL.  Neither a bug in MariaDB nor MySQL.

It was a compatibility problem with MyISAM not being able to support Foreign Key

Hope this blog post will save you hours of hair pulling.

Happy hacking!

~creek23

Friday, April 3, 2020

Tatsulok Lyrics by Buklod

Been searching for this for a while.  Sadly, most Lyric websites either have the wrong lyrics, or are using Bamboo's version.

To give justice to the song, I listened to the original which can be heard on Youtube, thanks to the uploader, Rvmer Rivera.  Here's the original lyrics released in 1989.

Totoy bilisan mo, bilisan mo ang takbo
Ilagan ang mga bombang nakatutok sa ulo mo
Totoy tumalon ka, dumapa kung kailangan
At baka tamaan pa ng mga balang ligaw

Totoy makinig ka, wag nang magpa-gabi
Baka pagkamalan pa't humandusay dyan sa tabi
Totoy alam mo ba kung ano ang puno't dulo
Ng di matapos-tapos na kaguluhang ito

Hindi pula't dilaw tunay na magkalaban
Ang kulay at tatak ay di syang dahilan
Hangga't mas marami ang lugmok sa kahirapan
At ang hustisya ay para lang sa mayaman

Habang may tatsulok at sila ang nasa tuktok
Hindi matatapos itong gulo

Hindi ligtas ang hininga ng kay raming mga tao
At ang dating munting bukid, ngayo'y sementeryo
Totoy kumilos ka, baliktarin ang tatsulok
Katulad mong mga dukha ang ilagay mo sa tuktok

Hindi pula't dilaw tunay na magkalaban
Ang kulay at tatak ay di syang dahilan
Hangga't mas marami ang lugmok sa kahirapan
At ang hustisya ay para lang sa mayaman

Habang may tatsulok at sila ang nasa tuktok
Hindi matatapos itong gulo
Habang may tatsulok at sila ang nasa tuktok
Hindi matatapos itong gulo


Happy Singing!