Gdevelop Casual Game Development Stream Part 25 [Add MySQL Scheduled Events And Heroku Cron Jobs]


Create MySQL scheduled event: 02:44 to 15:45 (The finally created event has some problem in its logic so you should only watch this part to know how to create the event and write your own logic for whatever you want to do. Watch the final 5 minutes of the video to learn more about this (58:48 to [End of Video]))

Provision Heroku Scheduler in your web app and add a PHP script in it which executes every 10 minutes: 22:27 to [End of Video] (This section is a little haphazardly done and sometimes I was working on MySQL events and sometimes on Heroku Scheduler but in the end it worked. I have put the source code in the github repository for the game server. You can download it and use it in your own projects freely. Get it here: https://github.com/ayushraj1024/soulhunterdowntownpublicserver)

(You can watch the video at 2x speed to save time)

Download the final apk from here (for the standalone version of the game. That is, the version with no networking capabilities): https://github.com/ayushraj1024/soulhunterdowntownstandalone/tree/master/apk

At this point I have made two repositories for the game. One is the old repository where the game has networking and leader-board functionality (Which is yet to be implemented). The other one is the new one made today and that version of the game does not contain networking functionality and is a self contained standalone game. I did that because not all games require networking and leader-boards so if you are building a game without networking capabilities then you can download the source from the new repository. The link is here: https://github.com/ayushraj1024/soulhunterdowntownstandalone

Get the Ninja Girl Sprite from Gameart2d: https://www.gameart2d.com/ninja-girl—free-sprites.html

The background art is from Craftpix. Get it for free from here: https://craftpix.net/freebies/free-pixel-art-street-2d-backgrounds/

Rest of the art has been made in Piskel from within Gdevelop πŸ™‚ Watch this video to learn how to do that: https://youtu.be/Go5PzcQWArg

Get the game source code from here (You don’t need this source code if you are building a game without networking functionalities): https://github.com/ayushraj1024/SoulHunterDowntown

(Note: The source will be updated everyday till the time this tutorial series is running.)

Get the server source code from here (You don’t need server source code if you are building a game without networking functionalities):

https://github.com/ayushraj1024/soulhunterdowntownpublicserver

(Note: The above link will take you to a repository which is exactly similar to the actual repository which I have connected to my Heroku web app. There is, however, one difference. And that is, the config values are not present in the above listed repository. This has been done for security reasons. You can find your own config values by following the steps shown in this video: https://youtu.be/il3sfD2mPnE)

This is a game development stream in which I am making a casual game called Soul Hunter Downtown. I am using Gdevelop to make this and while I am working on the game I will be telling you important things along the way so that you can learn to use the Gdevelop engine while watching this video. I do not speak fast or tell lots of details in one sentence so you can watch this video at higher speeds to get it done quickly. I have put some timestamps for important concepts in the description :).

Thank you for watching!

Follow this blog please πŸ™‚

Follow me here if you want to:

Facebook: https://www.facebook.com/ayushraj1024

Twitter: https://www.twitter.com/ayushraj1024

Instagram: https://www.instagram.com/ayushraj1024

Linkedin: https://www.linkedin.com/in/ayushraj1024

Also check out my game studio website: https://redseed.cc

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s