Monday, September 29, 2014

Hearthstone SQLite database

In the past two weeks I have been doing something interesting, I was developing a Hearthstone database in SQLite 3.7.9. I built it mainly to practice some SQLite programming.
Some guy managed to collect all information from some internal Hearthstone file and put it on this website: http://hearthstonejson.com/
I used a php script which I built to export the data from the json file to my SQLite database.
You can download the comple sql file from here: https://dl.dropboxusercontent.com/u/66845602/hearthstone/sqlhearthstone.sql

or you can restore the complete database into you sqlite3 from this file: https://dl.dropboxusercontent.com/u/66845602/hearthstone/sqlhearthstone.db

I have some other plans to do next, so maybe there will be hearthstone db version 2.0. I don't know.

I am not affiliated with Hearthstone or Blizzard in any way.

All information in the sql file and the db file belongs to Hearthstone © Heroes of Warcraft and Blizzard © Entertainment developers.

If you have some suggestions I would gladly hear them.

Tuesday, July 29, 2014

Change of Blogger's url address

I am planning to change my address to vladtheterran.blogspot.com

Just to note all my readers :) so spinnerbox.blogspot.com will stay but I will continue my work on the new address :)

Tumblr page changed address

Know what? I just changed my tumblr page address, it is: http://vladtheterran.tumblr.com/
I am also planning in the future to change my Blogger blog address to something similar like the tumblr's one.

What do you think? Is this blog name good?

Let me know?

Monday, July 28, 2014

Tumblr page

while playing some games I was making screenshots so tumblr turned to a good place for them. Visit my tumblr page at http://spinnerbox.tumblr.com/

Wednesday, July 23, 2014

Solarmax 2 - review

Hello guys, in this post I will share my thoughts on a game called Solarmax 2. It a successor of a game called Solarmax.

Game details

Genre: strategy, tactics, space, RTS alike, science fiction
Mechanics: real time
Player mode: single-player
Platforms: web based flash version, mobile, iOS, Android and Steam Greenlight/WindowsWeb page: http://nicotuason.itch.io/solarmax2
wiki/help page: (couldn't find any)

My thoughts

I finished the game three times, once on medium difficulty and two times on hard difficulty. So the first time I started the game, really pulled my attention because I like science fiction genre. It has awesome visual/graphical elements and every thing runs smoothly, as it should be. The beautiful music really fills the 
sci-fi experience... man kind set for conquering the stars :) However when I play sci-fi games what I like is the story or the comics that gives that fiction element. In this release there wasn't a story and the space ships look like a little light particles which is a bit disappointing. When I want to explain the game, I think of particles, not a space ships :)

This game should be a tactics game right? Well it does have tactics but you cannot really feel it. Basically in its core is just: be faster and collect bigger army so that you don't loose the level. You don't get to feel change in a single game when you send ships to one or to another planet, it is just collect bigger army. There should be levels with bigger maps, with more planets/(turret stations)/(warp gates) where you are going to feel a change with the distance between planets and the planet size. It is however a good time waster and kept me entertained up until I finished the game on both medium and hard modes. After that it became a bit boring so I lost interest. More levels are needed and perhaps map editor and multiplayer mode. Don't forget to add a short story.

To be honest I  finished all levels on medium mode without knowing that there is a slider for how much percentage of ships you want to send. The tutorial level with the slider is a bit inconvenient. The slider is also a bit clumsy. You may slide to a value you didn't wanted by accident and then you could perhaps loose a level. From my opinion I think a radio button group would do better, for example you have a set of predefined values, 15%, 30%, 50%, not sure about this, just a thought.

I would also like to see a kongregate badge for finishing all levels on hard mode. It gives you motivation to play it more. The AI is fierce and cunning which gives depth and value to the game. However there is still space for level refinement. Some levels are just too easy and some levels are a bit pain. 

I really like the thing that you get 10 tutorial levels, you have army advantage up until tenth level, which is nice. I also like the variety of game objects and elements, like bigger/smaller planets, warp gates, turret stations, space stations, obstacles, moving planets etc... Then variety in players/AIs, the possibility to experience game against four AIs. To note, the moment when black particles appeared, it was mind blowing :) and also the moment when you finish the game, all solar systems get white (that is why a short story is needed).

Tips and Tricks

While playing this game I concluded some general tips about it. 
  • Generally you should always try to take over static objects like planets and turret stations, since moving objects are harder to take and more riskier. 
  • Use constantly small amount of ships and transfer to enemy's planets to stop his unit production at least a short period of time. The AI will not be always able to clear his planets from your ships. You can do this by taking over two or three planets and keep you bigger army on one of the planets. While your empty planets generate new units, send them to enemy's unguarded planets. 
  • You will want to use often percents like 25%, 50%, 75% and 100% of your ships. Usually you start off by taking new planet with 100% of your units and then in the middle of the current game you switch to 50%  or 25% so that you can leave the current planet guarded. Black particle's AI is very fierce and fast. If able it attacks immediately a planet that has zero or smaller amount of units. 
  • Some levels have a pattern or trick. For example on level  2, divide in half your army and send it to one of opponent's planets. 
  • On level 13 you should first take over one half of the screen (upper or lower) and then conquer the other. 
  • Level 36 is just a trick, destroy the lower left AI, take over his planets and station and then with the warp gate transfer all your troops to the circular station in the middle of the screen. Wait a little to fight off black ships and then you are done with it. 
Useful links

Game alikes

Obviously the game mechanics is nothing new. There are many games, mobile or web that roughly have the same game mechanics. I made a small collection of links which you might want to check. 

Tentacle Wars - The Purple Menace

Conclusion

This game pulled my attention, but it didn't keep going. Needs more levels, multiplayer, map editor and story. Some tools should be improved and it is roughly a clone of other games. It will be a wonderful and immersive experience only the first time and will leave you wanting for more, but the tactics and level maps currently do not promise much. It has a potential to become something bigger and better that it is right now. We'll see. The visuals and the music are awesome which make this game a game you want :) From my point of view I give it 3.9/5

Gallery

http://vladtheterran.tumblr.com/post/92901566852/solarmax-2-part-1
http://vladtheterran.tumblr.com/post/92901680077/solarmax-2-part-2
http://vladtheterran.tumblr.com/post/92901782967/solarmax-2-part-3
http://vladtheterran.tumblr.com/post/92901854042/solarmax-2-part-4









Friday, May 2, 2014

Playing Heroes of Might and Magic 3 - Part 1

In this review I will play Heroes of Might and Magic 3. This will be part one in which I cover the game with screenshots, details and videos. In the second part perhaps I will cover the campaign mode of the game.

Release date: 28-th February, 1999
Genre: Strategy, RPG, fantasy, tactics
Mechanics: Turn based
Player mode: single-player, multi-player
Platforms: Windows XP, Vista, 7, 8, Ubuntu/Linux/Wine
web page: http://www.heroesofmightandmagic.com/heroes3/heroesofmightandmagic3iii.shtml
http://www.gog.com/game/heroes_of_might_and_magic_3_complete_edition
wiki/help page:  http://en.wikipedia.org/wiki/Heroes_of_Might_and_Magic_III

Screenshots: 
main menu
starting a mission
Fortress - City
Fortress buildings
Fortress creatures
Battle, Necropolis vs Neutral
Mission options
Hero inventory
Playing a map
List of heroes page
Earth view spell
Ladder
Single scenarios
Campaigns
You can also play the game in multi-player mode with up to 8 other remote players, using third party software like Hamachi VPN or GameRanger. I would recommend using GameRanger. How to play HoMM3 on GameRanger

Hosting HoMM3 game on GameRanger is easy

Chat options in GameRanger

Screenshot of a multiplayer game. See green text on the bottom left
Videos:









Friday, March 21, 2014

Card Sprite sheet Generator

During development of Wonders in Math Land I had to recreate card animations many times. Therefore I developed this script called: Card Sprite sheet Generator.
It enables you to create two way sprite sheet animation with just two images, in my case front and back side of a card. I had some bright ideas to improve it. Let me know our thought on it.





StarCraft2 Achievements application

I have been busy these days, developing a custom application for StarCraft2 using Blizzard's battle.net web service. If you are a SC2 fan and play it alot this application will enable you to browse trough the complete list of SC2 achievements when you don't play the game. Choose a region and locale/language, then filter the list by category, points and keyword. Finally, let me know your thoughts on it and what can be improved.

The link to the application is: http://sc2ach-blueplayer.rhcloud.com/

Browse achievements by category name
Browse achievements by category name

Browse achievements by points and category name
Browse achievements by points and category name

Browser achievements by title and description keyword
Browse achievements by title and description keyword

Saturday, March 15, 2014

Mochi Media is dead?! :(

Yup mochi media is dead :(

If you really like some of my games I can send you file for upload, just email me:

spinnerbox2000@gmail.com

It was fun with mochi media. Great platform for sharing free games but that is life :(

Wednesday, February 26, 2014

Latest patch of Wonders in Math Land

Play the latest patch of Wonders in Math Land here: http://www.stencyl.com/game/play/22553
Clear browser cache and press ingame reset button if it doesn't work.

Here is the walktrough video:


Screenshots:






Wednesday, February 19, 2014

Links: Learn basic and advanced SQL

I searched the net for some good online quizes about SQL

Here are some links I found:

A basic quiz about SQL from W3Schools
http://www.w3schools.com/quiztest/quiztest.asp?qtest=SQL

Basic SQL quiz:
http://www.sqlquiz.com/sql-quiz.php

SQL Guide with onsite SQL console
http://sqlzoo.net/wiki/Main_Page

My personal best are:


Beautiful Javascript quiz on NetTuts:
http://code.tutsplus.com/articles/nettuts-quiz-11-do-you-know-sql--net-24439

Desktop application for practicing SQL. Uses SQLite and 3D galaxy with stars as data.
http://sourceforge.net/projects/galaxql/



More thorough website covering basic aswell as advanced database concepts:
http://www.indiabix.com/database/questions-and-answers/

Enables you 10/20 or 25 question timed or casual quiz:
http://withoutbook.com/OnlineTestStart.php?quizId=15

Wednesday, January 22, 2014

Friday, January 10, 2014

Upload a mochi game to your site

Guys when you upload one of my games please use the embed tag. When a user comes to your site to play my game it will always be the LATEST version of the game.