by Yahwho | Jan 14, 2021 | Unity
Over the last few weeks (when not writing my Medieval Realms plugin) I’ve been spending a little time working out how to do 2D animation transitions in Unity. Here’s a little video. Currently there’s an idle animation, blink animation, walk...
by Yahwho | Jan 14, 2021 | Windows
In order to add and remove items from Windows 10 Start menu (like adding shortcuts to scripts) open a run box and head over to the following directory. %ProgramData%\Microsoft\Windows\Start Menu\Programs\
by Yahwho | Dec 19, 2020 | WordPress
Normally I like to drop into the code to see what’s wrong. But on this occasion time was at a premium. Using the plugin Fix Another Update In Progress by P Roy did the job in seconds, even if it wasn’t tested up to the version I was running. Deleted...
by Yahwho | Dec 19, 2020 | SQL
I’m currently developing a new database, requiring the initialisation code to be run over and over again. Creating tables with IF EXISTS is easy. Delete a foreign key if one had been created already was a little more problematic. set @var=if((SELECT true FROM...
by Yahwho | Nov 21, 2020 | SQL
Today I have decided to take a look at the redesign of the Medieval Realms database. This is the first production database I’ve ever written. It’s ugly. It’s not really relational. And it’s bloated to 34 tables. This database has grown...