Ramen Junkie

Code Project – JavaScript Dice Roller Game

I mentioned in my Python Class posts that I really enjoyed the instructor and I planned to eventually move to doing her Web Dev Course. Well, I’ve started working on that one. It’s not a “100 Days of Projects” so I’ve not been quite blitzing through it like I did the Python Course, and it’s a lot of material I am already way more familiar with. Hell, I skipped over the first third of the course because it was the same HTML/CSS content included int he Python Course.

My main goal here, is to get much more familiar with JavaScript. I have dabbled, lightly, in JavaScript (ok, let’s go with JS from here on), and well, it’s a coding language, so I already have a lot of the “logic” side down. At some point, learning new programming languages just becomes about learning the syntax and maybe some of the special uses for a particular language. I’d only say I am Intermediate or above in Python and HTML/PHP, but I’m familiar with several other languages including BASIC, C, C++, LSL (Linden Scripting Language), Arduino (mostly just C), Bash Shell scripting, SQL, Cold Fusion, and probably some other I am forgetting.

It all mostly works the same on the base level, a loop is a loop, conditionals are conditional, and it’s just a matter of remembering if the language uses braces or parenthesis or semi colons and if tabs matter. And that’s where Google becomes your friend.

Anyway, the first real stand along project of this course is a simple Dice rolling game. And I have to say, “game” is the loosest sense of the word. It’s a webpage you refresh to see if Player 1 or Player 2 has the higher dice face. I might actually try to make a more complex version of this later where you select from different Dice and it rolls them, for you know, gaming. Sure there are plenty of D&D Dice roller apps, but it would be a fun exercise.

The class provided the basic HTML Structure and graphics, since the focus was on the JavaScript side of things. It’s not an overly complex project, but here is the JS Code.

function setImage(diceImage, roll) {
    console.log(roll);
    if(roll === 1) { rolled = "images/dice1.png"; }
    else if(roll === 2) { rolled = "images/dice2.png"; }
    else if(roll === 3) { rolled = "images/dice3.png"; }
    else if(roll === 4) { rolled = "images/dice4.png"; }
    else if(roll === 5) { rolled = "images/dice5.png"; }
    else { rolled = "images/dice6.png"; }


    diceImage.src = rolled;
}

let player1Roll = Math.floor(Math.random()*6)+1;
let player2Roll = Math.floor(Math.random()*6)+1;

let dice1Image = document.querySelector("img.img1");
let dice2Image = document.querySelector("img.img2");

if( player1Roll > player2Roll) {
    document.getElementById("headtext").textContent = "Player 1 Wins!";
}
else if (player2Roll > player1Roll) {
    document.getElementById("headtext").textContent = "Player 2 Wins!";
}
else {
    document.getElementById("headtext").textContent = "Its a Tie!";
}

setImage(dice1Image,player1Roll);
setImage(dice2Image,player2Roll);

So what’s the process here. Let’s skip the function at the top for now. Step one is to roll two dice. This is done with Math.random, which selects a random value between 0 and 1. Dice have 6 sides, so we multiply this by 6, to get a number between 0 and 6. But technically it’s a number between 0 and 5.999999~ into infinity, not 6. And Math.floor rounds things down, so it’s actually between 0 and 5. So we need to add one.

let player1Roll = Math.floor(Math.random()*6)+1;
let player2Roll = Math.floor(Math.random()*6)+1;

After this is some selectors to pick the the two dice images off the page, so they can be updated to reflect the rolls later.

let dice1Image = document.querySelector("img.img1");
let dice2Image = document.querySelector("img.img2");

Next we get to use a conditional chain to determine the winner and update the h1 tag on the webpage to display the winner, or if it was a tie. I’m not going to repeat that code here again.

Lastly we make two calls to that function I mentioned before, the one at the top of the script, that updates the image for each dice. The function takes the document selector, and the value of each roll as an input. It runs the roll value (1-6) through a selector and then sets the dice image on the HTML document to the appropriate image.

Could this code all be cleaner, probably, but it gets the job done and is easy to follow. There is probably a simpler way to set the images. The image selector could also just look for 0-5 mapped to 1-6 instead of adding 1. But what if I needed this function to do more based on these rolls. Maybe it becomes part of a larger game and deals damage or something. Personally, this is why I prefer code like this, that isn’t perfectly compact, because it becomes functionally more useful down the road.

Also, the game is available to play at this link.

Code Project: Fresh RSS to WordPress Digest

I actually briefly mentioned this project when I write about moving from TinyTinyRSS to FreshRSS. This has become a bit of an evolving and ongoing project however, so I’ve decided to catalogue it in it’s own page. This little script worked out much better than I expected, and I’ve modified it a bit over time, and have ideas to modify it going forward even more. Starting off, the code can be found here in this Github GIST.

I’ve left a bit of commented out code that i might use later for troubleshooting or adding additional features. The general gist of the code, it pulls the last 24 hours worth of news stories I have favorited from my FreshRSS install, then formats them into a digest format and posts it here, in this blog. They get sorted into their own category, you can find them here.

This is basically a thing I’ve seen others do that I’ve wanted to do for a while. It’s also partially just for my reference more than anything, it’s sort of a log of everything I have found interesting on a particular day more than anything. Others may or may not find it interest, which is why I also filter that category out of the home page feed.

Originally, it was just a list of URLs and titles. I realized that it might be useful to have SOME idea what the link was about before clicking it, so I have been playing with the summary as well. My first attempt was a bit dodgy because it actually posted the entire article as the summary. Currently, it just arbitrarily chops it off at a few hundred characters. I want to improve it even farther at some point by pushing it through some summarizing AI and getting an actual proper summary but I have not gotten there yet.

There re a few other things I want to add but I’m not sure they re easily possible. Firstly, I would love to be able to parse some sort of categories into the digest. So say, all the “Video Game” links are together and Music links are together. FreshRSS has categories but they don’t seem to show up in the feed anywhere.

This would also allow me to split these posts between this blog and my other blog, Lameazoid. I do share interesting video games news from FreshRSS, but I mostly don’t share Toy related articles, because it feels a little TOO FAR out there for what I want to post to this blog. If there were a way to have the categories, I could easily have the script split the feed by categories and post a digest to each blog.

I also wish there was a way to add my own notes and commentary occasionally. I don’t think it showed up in the feed either, but TinyTinyRSS had a notes feature. I am not sure if FreshRSS has that as well. I probably should try to at least suggest these features to the creators on GitHub, or maybe get really adventurous and create my own plug-ins for FreshRSS to accomplish these tasks.

Code Project: VLC Portable Playlist to Text Dump

It’s kind of funny how one post can lead to another sometimes.  This one is pretty basic but it also just shows a bit how useful I find knowing my way around computer systems to be.  Yesterday I posted about my little annual music playlists.  And as part of that, I wanted to actually post the playlist. I am pretty sure there is a fairly universal “playlist file type” out there and being open source, I had assumed that VLC on my phone stored the playlists somewhere in playlist files.

That assumption was wrong, it uses a .db file.  A little portable database.  There is an option to dump this file to the root of the phone, presumably for backup purposes, but it’s also useful to just browse it like I am doing here.  The file itself can be opened and browsed with SQL Lite’s DB manager.  It’s standard databases inside for tracks and artists and playlists.

Fortunately, I have had some experience dealing with database queries, so I set about building what was needed tog et the data I wanted.  Pull the Playlist I want, in this case “2023 Best” but I could change that to do any available Playlist.  This gives the tracks by id, but the tracks themselves are stored in a separate table for media.  So that needs joined in.  The media table stores track names, but not artist names, so an additional join is needed to get the artist names.  This complicated things a bit because both the playlist table and artist table have a column “name” so more clarity needed to be added.

The result was this little query that dumps out a basic table of Artist and Song title.

SELECT Artist.name, Media.title 
FROM Playlist
Inner Join playlistmediarelation ON playlist_id=id_playlist
Inner Join Media ON id_media=media_id
Inner Join Artist ON media.artist_id=Artist.id_artist
WHERE Playlist.name = '2023 Best'
ORDER BY Artist.name

Now, I could have done some cute clever trick now to merge the two into a new column and add in a ” – ” between but it was easier to drop it all into a notepad file and do a fine/replace on the weird space character that it stick in between the Artist and track title.

The added bonus here is I can easily use this query again anytime I want to dump a Playlist to text.

The Annual Playlist for 2023

A few years ago, I was sorting through some older music, and came across old Mix Tapes and CD-Rs.  It’s really fun because unlike digital music, these are essentially static playlists.  This is a window into what I was listening to at that time.  And no, you didn’t misread that, Mix Tapes.  and they were mostly from the 90s era.  My first car didn’t have a CD player, it just had a cassette deck.  Teenage me would regularly visit the local library and check out a variety of CDs, then spend the week picking out my favorite tracks and recording them to tapes.  I also recorded some from the radio.  I had a stereo with a dual cassette deck so I could easily copy some back and forth among my tapes.

Here is a fun blast from the past for ya. I had a thing for a while where I would make little custom art for my tapes too, most of them had Gunsmith Cats artwork but I also did some for Dance Dance Revolution as well.

Something really amusing I noticed here is that “Car Tape 3” includes 2 Alanis Morrisette songs, both of which are on my 2023 playlist (below).

Digital playlists aren’t quite as robust.  They are honestly kind of a pain to deal with over time, because the files can move around and then the playlists essentially just break.  But I did try to sort of replicate the experience of an annual playlist after the nostalgia trip of these tapes and CDs.  Basically, usually sometimes in January, I make a new playlist for the year, simply named, for example, “2023 Playlist.”  For the first few I would star with the previous year and seriously trim it down.  More recently I just start from scratch.  The idea is, it can evolve over the year though.  Essentially, i start with a “best of” from previous years, music I want to listen to “now” in January, then over the course of the year, I might remove some songs, and I might add some songs.  

The bigger point is, I have the old lists, if I wanted to go back and listen to things, though, that would also still have the digital music problem of, “The music was moved/removed and the list is broken.”  

But at least I do still have the list.      

More recently though I have been thinking of sticking these in a more meaningful file for future nostalgia (Ironically, a song that I debated adding to this year’s list but decided not to in favor of other Dua Lipa tracks).  Probably some sort of simple Excel file or something, then I can eventually manipulate the listings in 5 year when I decided to do some sort of retrospective blog post and list out “This song was on 8 out of 12 Playlists!” sort of nonsense.

For now, I wanted to just, post the list, for the start of this year.  I’ll alphabetize it by artist, but the order doesn’t matter, these are always just played on shuffle.

Alanis Morissette - All I Really Want
Alanis Morissette - Ironic
Alice Merton - No Roots
Alice Merton - 2 Kids
Alice Merton - Funny Business
Alice Merton - Easy
Alice Merton - Lash Out
Aurora - The Woman I Am (Vevo Live)
Aurora - Giving In To The Love
Aurora - Cure For Me
Aurora - A Temporary High
Aurora - Blood In The Wine
Aurora - Animal
Aurora - Hunger
Aurora - The Seed
Aurora - I Went Too Far
Aurora - Murder Song (5, 4, 3, 2, 1)
Aurora - Gentle Earthquakes
Aurora - All Is Soft Inside
Aurora - Churchyard
Avril Lavigne - Here's To Never Growing Up
Avril Lavigne - Things I'll Never Say
Bt - Never Gonna Come Back Down
Bt - Movement in Still Life
Bt - Satellite
Bt - Smartbomb
CHVRCHES - The Killing Moon (Amazon Original)
CHVRCHES - The Mother We Share
CHVRCHES - Gun
CHVRCHES - Recover
CHVRCHES - Killer
CHVRCHES - Screaming
CHVRCHES - Bitter End
CHVRCHES - Violent Delights
CHVRCHES - Good Girls Explicit
CHVRCHES - Death Stranding
CHVRCHES - Never Ending Circles
CHVRCHES - Clearest Blue
CHVRCHES - Graffiti
CHVRCHES - Forever
CHVRCHES - Graves
dodie - Monster (Vevo Live)
dodie - Hate Myself
dodie - Cool Girl
dodie - Monster
Dua Lipa - Physical
Dua Lipa - Good In Bed Explicit
Dua Lipa - Cool
Fred V & Grafix ft. Ruth Royall - Sunrise (Season Mix)
Griff ft Sigrid - Head on Fire
Juno Reactor - Guardian Angel
Juno Reactor - Samurai
Katy Perry - Electric
Kim Petras - Icey (Vevo Live)
King Princess - PAIN
M83 - Midnight City
Magdalena Bay - Killshot
Magdalena Bay - Mercurial World
Metallica - Enter Sandman
Metallica - The Unforgiven
Neil Frances - On the Lookout (feat. Raffaella)
Nigel Stanford - Automatica
Nirvana - Smells Like Teen Spirit
Nirvana - Come as You Are
Nirvana - On a Plain
Orla Gartland - Things That I've Learned
Orla Gartland - You're Not Special, Babe [Explicit]
Orla Gartland - Pretending [Explicit]
Orla Gartland - Flatline
Paramore - Misery Business
Radiohead - Everything In Its Right Place
Raffaella - Grown Up (Vevo Live)
Raffaella - Blonde (Vevo Live)
Raffaella - Hell Yeah
Raffaella - Sororicide
Raffaella - Bardot
Raffaella - BUICK
Sigrid - A Driver Saved My Night (Vevo Live)
Sigrid - It Gets Dark (VevoLive)
Sigrid - Deep
Sigrid - Dip My Heart in Confetti
Sigrid - Dancer
Sigrid - Mistake Like You
Sigrid - A Driver Saved My Night
Sofi Tukker - Hey Lion
Sofi Tukker - Awoo (feat. Betta Lemme)
Taylor Swift - Getaway Car
Taylor Swift - This Is Why We Can’t Have Nice Things
Taylor Swift - New Romantics
Taylor Swift - Fearless (Taylor’s Version)
Taylor Swift - Love Story (Taylor’s Version)
Taylor Swift - You Need to Calm Down
Taylor Swift - Lavender Haze
Taylor Swift - Anti‐Hero
Taylor Swift - Vigilante Shit
Taylor Swift - Mastermind
Tessa Violet - Bad Ideas
Tessa Violet - Games
The Cranberries - Dreams
The Cranberries - Zombie
Wolf Alice - Smile

SQL Woes

For the most part, managing my web server is pretty straightforward, especially because I don’t really get a ton of traffic. Its mostly just keeping things up to date through standard channels.

Occasionally I have a bit of a brain fart moment. I recently was doing regular Linux updates on the server. I noticed a message I had seen before about some packages being held back. Occasionally I will go through and update these, because I am not real sure why they are being held back, but don’t really see any reason they should be.

Then MySQL broke.

So I went digging in some logs and searching for solutions, and decided I needed to roll back the version. Following a guide I found, I discovered… I had done this before, which I now vaguely remebered. Because the old .deb file was still there from last time I broke it.

Anyway, this didn’t fix it, MySQL still was not launching.

I decided that maybe it was time to just switch to MariaDB, which I believe is the spiritual successor to MySQL. And the process was simple enough, I would not even need to dump my Databases. So I uninstalled MySQL, installed MariaDB and… It worked!

Then it stopped working.

I restarted the SQL service and it worked!

Then it…. Stopped working… Again…

So I checked logs again and corrected some issues there and again it worked, then a half hour or so later it stopped working.

One thing I had come across in troubleshooting the original MySQL issue was that there was a command, mysql_upgrade that needed to be run to change how some tables are configured. I couldn’t do that before because I couldn’t even get MySQL to run. But I could get MariaDB to run at least for a bit, and had successfully gotten this upgrade command to run.

So I decided to, once again, try MySQL again, so I uninstalled MariaDB, and purged everything out, rebooting a few times to be sure. And MySQL would not even install anymore, so more purging, this time, including the Databases.

One thing I was glad I had decided to do, “Just in Case” when MariaDB was “working” was dump the databases out with backups. I was glad I did at this point. So with absolutely everything purged, MySQL installed and was working.

I set about recreating the databases from the dumps, and while I was at it updated all the passwords, since I had to recreate the user accounts used by WordPress anyway.

And now everything is working smoothly again.

A couple of links that were actually helpful in solving my problem.

https://stackoverflow.com/questions/67564215/problems-installing-mysql-on-ubuntu-20-04

https://learnubuntu.com/install-mysql/