Find all e-mails sent or received in Gmail after office hours

Someone gave me a task to find all e-mail messages sent or received in Gmail:

  • in given period of day — after 16:00 given day and before 08:00 the next day and
  • in given period of week — between 00:00 and 23:59 during weekends,

so, generally speaking, outside office hours.

Gmail has a quite powerful filtering mechanism, but it:

For some internal reasons I couldn’t follow the “automatic way” suggestion (i.e. to upload messages from Gmail to Google Sheets and try to filter them there) and thus I decided into semi-automatic way.

Meaning that I wrote an Excel sheet which generated Gmail’s filtering queries for me for all required dates and I only have to manually copy-paste them into Gmail’s search box.

You can get similar results Epoch Converter’s batch tool, but I wanted to play a little bit with Excel instead.

Read More “Find all e-mails sent or received in Gmail after office hours”

Let’s talk about game economy!

I am old and thus I still remember these pretty days of Diablo I, back in 1996 — where each and every pieces of Tristram was filled with a pile of 5 000 gold pieces (the biggest amount you could store in single map’s cell) — because Diablo I’s economy had so poor design that most of the players were earning millions by the end of the game, without a real ability of spending this.

Game economy is an extremely important part of each game design and you are deeply wrong, if you think that it plays key role only in economy-based games. I have intentionally mentioned Diablo 1 to show you an example of a dark fantasy game. Some economy-related mistakes for match-three like game are also mentioned here.

In this article I would like to focus on some economy-related issues and mistakes that you must consider when designing money and resources layer in your game, no mater what kind of game you’re currently developing.

Crafting is an important part of game economy, but I have written a separate article on this subject.

Read More “Let’s talk about game economy!”

Google Play Games: The good and the bad approach

Google Play Games on Android and Apple Game Center on iOS is a really good tool for developers and gamedev companies that provides them with a powerful tools to build, analyze and retain your audience and optimize your game.

As for the game players — it allows them to share and compare their results and build their common game profile or even portfolio, by getting experience, achievements and ladder positions across many different games in the same time.

And, as with everything, this can be a base for your success or a begin to your complete failure.

Here is a quick review and compare on how game creators of two different games for Android approached this topic. And, in the same time, a very quick info on two quite different games.

Read More “Google Play Games: The good and the bad approach”

Simple ways and mistakes to ruin a gameplay in your game

I’ve been playing Puzzle Forge 2 game way to much. I spent so many hours playing this game that I managed to get some nice achievements in it and in Google Play Games in general.

In addition, I found a quite nice number of gameplay-related bugs in this game. Large enough to use it as a model scenario in discussion on ruining your game and a gameplay in it, by makings simple, yet stupid mistakes and wrong design assumptions.

Read More “Simple ways and mistakes to ruin a gameplay in your game”

A Farewell to Arms in Puzzle Forge 2

I have finally said “good bye” to the Puzzle Forge 2 game. My decision was made because:

While doing above, I managed to capture some interesting (?) screenshots that I’d like to share here.

Read More “A Farewell to Arms in Puzzle Forge 2”

Migrate all your messages to Gmail or other mail account using imapsync

This article covers:

  • all the information, that I managed to find out or figure out,
  • all the bottlenecks I had to resolve and all the walls, I hit,
  • some additional info or alternative methods,

about migrating all messages from some mail account to Gmail, using imapsync and IMAP protocol.

The imapsync is an extremely flexible and powerful tool, that also has an on-line counterpart (so you don’t get your hands too dirty), and its documentation simply surpasses imagination, so it is certainly able to transfer all the messages between virtually any IMAP servers, not just between Gmail.

But this article focuses on external IMAP server –> Gmail scenario. For other scenarios, you should find some tips here, but you may need to consult imapsync documentation and the Internet or to use another solution.

Read More “Migrate all your messages to Gmail or other mail account using imapsync”

All legendary weapons in Puzzle Forge 2

This is basically a shortcut and my personal memo of a corresponding forum thread — a complete (?) list of all forty legendary weapons that you can create in Puzzle Forge 2. With a little bit cleanup.

The game itself hasn’t been updated since July 2016 (and most forum threads ceased even earlier, somewhere in 2014 or 2015), but even today it has a large number of players and certainly — a massive gameplay!

BTW: Using ugly, dully, unreadable and lame phpBB (a forum engine last time updated in 2007!) for supporting game players that are actually bringing you money is so… so… lame!

Read More “All legendary weapons in Puzzle Forge 2”

What is PUBG and what’s all about all those battle royale games

End of January is the beginning of the test of the new, free and less resource hunger PlayerUnknown’s Battlegrounds (PUBG). It should be possible to run this game in Lite version even with integrated graphics card. And, as said it will be available free for everyone at no cost.

Hold your horses, because “free” may mean Thailand or Asia. Currently tests are limited only to this country and it is not sure, if PUBG Lite version won’t be limited only Asian market.

PlayerUnknown’s Battlegrounds is a battle royale-type game (see below) in which up to 100 players can compete on a single server. I will discuss some game details and battle royale games here as well.

Read More “What is PUBG and what’s all about all those battle royale games”

Early access model in game development

Steam Early Access (March 2013), Xbox Game Preview and Playstation Early Access (both in June 2015) are all early access models for financing and distribution of games (most often, an independent studio’s creations) that is pretty much the same as crowdfunding in the rest of the world.

If you’re interested in any of these subjects then this article may be a good starting point for you. It is an introduction-level text, so pros in this area might quickly get bored.

Read More “Early access model in game development”

Finding TP-Link router in your local network

Most TP-Link routers is accessible using admin/admin credentials under one of these URLs:

Of course, you must try to access these URLs from the computer or mobile that is connected (via cable or Wi-Fi) to the same local network, your TP-Link router is connected to.

If above fails and you don’t know current router’s IP address, you may try accessing:

URLs from the same local network, your TP-Link router is connected to.

Most TP-Link routers registers a virtual URL (like above) and you can access their control panel even without knowing their actual IP address.

Photos made with Galaxy J5 seems not rotated in IrfanView

There’s a known (yet very strange) bug in IrfanView, which causes photos made with Samsung Galaxy J5 (2016) to stay in original rotation. Since this occurs only:

  • in IrfanView (images are actually rotated and appears correctly in all other media browsers) and
  • only for photos made by Samsung Galaxy J5 (images made by other phones are unaffected)

this issue may simply be ignored by most of the users. However, I decided to write it here, as this seems to be an interesting (yet weird) IT issue.

Read More “Photos made with Galaxy J5 seems not rotated in IrfanView”

A word about crafting in games

Crafting is a computer games-related aspect in which game player needs to gather certain elements, puzzle pieces or resources in order to develop a new object. It can be found in:

  • fantasy games (mixtures, elixirs, spells),
  • war-games (armour and weapons modifications),
  • survival games (food crafting, tools creation, healing).

In most cases, in order to create these you need:

  • resources (which can be found by exploring game, doing quests or purchasing),
  • knowledge (either learned yourself or by using NPCs-offered services),
  • sometimes money (for paying for these services).

It is mostly popular in RPGs and MMOs.

Read More “A word about crafting in games”

Install Optware (IPKG) on QNAP TS-210 with QTS 4.x

With introduction of QTS 4.x:

  • there are a lot of changes in QNAP’s Control Panel, including the fact that “Application Servers” component is gone,
  • neither Optware nor IPKG or QPKG elements are available for download in the “App Center”.

This causes my “Installing Optware (IPKG) on QNAP TS-210” (6,5 year old!) article to be completely outdated.

Currently then only way to install Optware is to go through Manual instalation as described in QNAP Wiki.

Since I went through this guide and can confirm that it is working, I will be enough nasty to copy-paste that article here (removing stuff not related to QNAP TS-210 and fixing some bugs).

To go through these steps you need a shell access to your QNAP. Using the PuTTY is the most obvious answer.

But wait! There’s a much better way. QNAP introduced a gem called “shellinabox“, available in App Center (or here or here). I strongly recommend to use it, because with it, you need a web browser!

Read More “Install Optware (IPKG) on QNAP TS-210 with QTS 4.x”

Convert Webex’s WRF files to some other video format

I had some serious troubles converting Webex’s video session, saved to .wrf file, to some other video format (namely, .mp4). I have ended up using Webex WRF2WMV Converter, but only after contacting Webex support (mostly due to a lot of incorrect information on their website).

To avoid others wasting the time the same way, here is a short memo on this topic.

Read More “Convert Webex’s WRF files to some other video format”

Using Sieve for server-side mail filtering

If your mail server supports Sieve mail filtering language, you can use a simple text scripts to enable powerful mail filtering and management that is applied directly on server-side. This allows you to create filters that will works client-independenty (a true saviour for those enforced to use Microsoft Outlook).

Sieve has no variables, and no loops (but does have conditionals). Thus, it is limited to simple filtering operations.

But that is enough for:

  • developing simple anti-spam system,
  • managing and organising mails, but auto-moving incoming messages to corresponding folders,
  • rejecting certain e-mails automatically (i.e. if they’re too big or contain invalid attachment).

Here you will find some general info and a few simple script examples.

Read More “Using Sieve for server-side mail filtering”

The “Couldn’t agree a key algorithm” error in Git for Windows

When trying to perform any authentication-related operation in Git for Windows you may hit the wall with:

Couldn’t agree a key algorithm (available: list of available methods)

Some people says (here and here for example, but also in many other places) that this is due to your PuTTY not being up-to-date and ordering getting latest version of PuTTY as a cure. You’re lucky, if that works for you! :>

I wasn’t that lucky and it turned out that in case of my Git for Windows TortisePlink was actually the problem.

Read More “The “Couldn’t agree a key algorithm” error in Git for Windows”

Use Gmail with different account than in Chrome

There’s a well know bug in Google Chrome that forces you to use the same Google Account (let’s name it account A) both in Google Chrome and in all Google apps that you have run in this browser. Logging-off this account in any of Google apps causes immediate log-off in Google Chrome as well and also causes your Google data synchronisation to stop.

This may be obvious and convenient in most cases, but fails completely in certain scenarios.

For example, I am using Google Chrome in my office and I am syncing all Google data to a separate account B (to have i.e. separate set of bookmarks, for my work only and to not mix them up with my private bookmarks), but when opening Gmail, I want to be logged in to account A (private one), because I’m checking my private e-mails this way (I am using Outlook for office e-mails).

There’s a workaround for this problem (“best answer” here). However, it turned out to be not working for me.

Read More “Use Gmail with different account than in Chrome”

Always display certain pages in mobile mode

I pretty much like and enjoy Wikipedia in mobile version, even when browsing it on desktop PC. I would like to see it that way anytime. I asked about this on two Stack Exchange sites and got a great answers that this is possible both in Wikipedia itself and in browser.

The second solution maybe thus used for virtually any website, not just for Wikipedia.

Read More “Always display certain pages in mobile mode”

Git workflow for modern projects

After four years of a break for doing some management stuff and other non-development tasks I have decided to get back into coding (or at least to start thinking about getting back to it). First thing was to prepare development environment in general and refresh git flow knowledge in particular.

This article is a mixture of both my old article about Git+Gerrit workflows and Git workflow for Yii 2 contributors article. I assumed minimalist approach to make it possible to use this new workflow for virtually any Git-based project. Thus, I have purged most of, if not all of the things that are specific to Gerrit and Yii2.

Before continuing with this article, make sure that:

In addition, you may want to change the Git Bash’s prompt to something, you are more familiar with.

Read More “Git workflow for modern projects”

ISO image locked in Windows 10

After 25+ years of glorious development of Windows, witch-doctors at Microsoft village finally managed to discover that you can mount .iso image as fully-featured drive directly in system and you don’t need extra tools for this purpose:

The same group of maniacs smoked out too much weed and figured out that it will be so cool to not automatically unmount this image during system reset or shutdown.

Read More “ISO image locked in Windows 10”

My private Windows 10 check-list

I won’t deny. I hate Windows 10 and I hate Microsoft for making Windows 10 the way they made it. And… I hate my company’s IT support for forcing me into using it. But since I was forced to and there was no way avoiding this madness, I made my personal list of things you have to disable, uninstall, tweak up or change in order to make this stupid operating system a little less stupid.

Read More “My private Windows 10 check-list”

My private Microsoft Office check-list

Whether it is Office 2010 or 2013 (haven’t tried newer and already forgot about earlier) and whether it is on Windows 7, 8.1 or 10, the set of my preferred configuration options and elements is usually the same. So I decided to write it down here to keep track of it whenever I have to fresh-install Microsoft Office anywhere.

This article covers only configuration of each Office component that I use. For other things that I usually do or change during fresh-install of Office, please, refer to this article.

Notice that Office 2013 under Windows 10 is not the same as Office 2013 under Windows 7. It ships with a completely different configuration and thus many options listed in this article you will have to change only under Windows 10, because under Windows 7 they can be already in designated values.

Read More “My private Microsoft Office check-list”

Remove garbage from Windows 10

Even after years since initial publication, being mature and stable operating system right now, Windows 10 comes to your computer literally bloated with unnecessary stuff. And you need to clean it up by yourself.

Certain things can be uninstalled “the normal way” (i.e. as easy as going to Add/Remove programs section of Settings and clicking Uninstall next to each of unwanted items). Some other requires more sophisticated moves as some jerks at Microsoft decided that making uninstallation of these as complex and problematic as possible is funny.

Read More “Remove garbage from Windows 10”