mySQLgame 2.0

Tired of the monotonous online games represent only a set of buttons that sends queries to databases? Meet Lone lord — a game in which no buttons in which we writing queries in the database.




Sending some queries format similar to the syntax of MongoDB, you can: build and upgrade castles and towers, to recover the diamonds and wood, to attack neighbors, to trade on the markets to exchange resources in the State Bank Lone lord, to unite with other players in a clique and fight in large-scale feudal wars!

Despite the title, the game is not a continuation of mySQLgame, but is its logical evolutionary development: in contrast to the “first part” in the Lone lord is the trade, exchange and resource extraction, merging into clicks and easy game chat. And we have bots.

Yes, unlike most online games, bots in Lone lord is not prohibited, and welcome! Just 10 diamonds you will receive faithful servant, assistant in trade and resource extraction, the postman, head of the casino gaming – the possibilities of bots only limited by your imagination and the lax rules.

Don't wait, register right now and get the 2.5 x bonus to your starting resources!

Technology



Article on technical resource would be incomplete without a description of technologies used and the generation process.

The game was developed for exactly a month under the impression from the above mySQLgame with the desire to make improvements and to eliminate the fatal flaw.

Both server and client side is written in CoffeeScript, a language similar to Ruby syntax, which compiles to JavaScript. The server used Node.js with Engine.io to handle requests, JADE for the layout, Stylus for styles. Database – SQLite.

The client is traditsionnoi jQuery decided to use Zepto.js that is compatible with the first at the level of syntax. Size inficirovannye JS file, the latter turned out 4 times smaller than the more famous library, but lost support for all versions of IE. They say it can somehow patch and add support for IE9-10, but I was unable to do it.

Chat and log in game implemented on web sockets with the help of the Engine.IO, so that you are attacked or that one of your towers brought the long-awaited diamond, you will know instantly. :)

To parse the queries from the command line used library that ran on Stack Overflow – jsonlite. It allows you to write JSON queries without quotation marks everywhere, where possible, which is very convenient when a large number of commands.

Links


the Game
the Game (compact version)
Wiki (get started, command syntax)

PS Be careful. It is possible that under all this lies a really interesting game...
Article based on information from habrahabr.ru

Комментарии

Популярные сообщения из этого блога

March Habrameeting in Kiev

PostgreSQL load testing using JMeter, Yandex.Tank and Overload

Monitoring PostgreSQL with Zabbix