If you have never been using Yii 1.x database migrations before, you may be sceptic (as I was before starting to using them), if they’re so good? And whether it is worth to waste time on dumping database scheme or rewriting .sql files into Yii migrations.
This document outlines most important pros of using Yii migration system.
Read More “Why to use Yii migrations instead of plain SQL files?”So… you want to have a Flightradar24 Premium account for free or you want to make the world better and you decided to start feeding data to this service, right? Well, great! But, information provided by FR4 about installation, configuration and feeding process itself have a lot of crappy and irrelevant parts. So, I decided to write my own mini-serie of articles on how to start, what to purchase and what to look for. So you can avoid all the pitfalls I felt into.
IMPORTANT! Read the next article, about software BEFORE you even plug your DVB-T stick to USB port. If you do this, you’ll waste some additional time on uninstalling Windows drivers, which are completely useless in this scenario (since we want to receive flight data, not the actual TV signal, right).
Read More “Feeding data to Flightradar24 using DVB-T stick. Part 1. Hardware”
Providing correct plural form of countable words in English is easy, because there is a difference only between one (1 item) and other (0 items, 2 items, 5 items etc.).
In Polish (and some other languages) this is much harder, because Polish has two different plural forms and plural form of countable words is way, way more complicated and based sometimes not only on whole number but also on last digit of this number etc.
Read More “Plural formula in PHP to evaluate ending for a number in Polish language”
Akshaya K Sahu’s answer to this question at Stack Overflow is a great example of text parsing function that can truncate any HTML-encoded string at given length, taking care of all the needed aspects, i.e.:
I have actually nothing to add to it, so I keep a copy of this code only for my own reference. And only because the original answer lacks some comments.
Read More “Text truncating function that secures both HTML tags and full words”If you’re unable to run MySQL through XAMPP Control Panel, first thing to do, is to check error log file. If you find entry saying, that table ./mysql/db (or similar) is marked as crashed and should be repaired then you may find some help in this article.
This article shows simple examples (and disscusses most important side-effects) of using ssmtp for sending emails from console windows or from Bash script. I’m not a very experienced Linux user (actually, I’m very beginner), so consider possible mistakes in this text.
Read More “Sending emails from console using ssmtp”Software licensed under COA, OEM and similar licenses can be legally sold on European Union area, according to Court of Justice of the European Union’s verdict dated July 3, 2012. It judged that both private persons and companies can sold original software and licensees purchased from companies like Microsoft.
This judgement is a direct interpretation of the law of European Union directive 2001/29/WE, which says that producer’s law for an exclusive distribution ceases with the moment of software selling for the first time and producer or IT company cannot legally block any attempt of re-selling such software attempted by the person or company, who initially purchased it.
I have just downloaded a bunch of .mp4 files, which are accompanied by .mp4sub files. If you also wonder, what is this, and what kind of software can be used to play these wideo files, then read on.
Layouts in Yii 1.x may be a little bit mistery to someone, who never worked with some layout framework.
This article tries to explain basics to such people.
If you have just purchased new Microsoft Lumia phone (or any other device, that uses Windows Mobile system), added your Google account to this device and you found out, that even though synchronization was successful, you have absolutely no contacts imported, then you’re in the same situation, as I was and this article should help.
Read More “No contacts on Windows Mobile after adding Google account”
Because Gerrit is evil and wrong (see here for details), even such simple task,like creating a new project, requires a separate document and todo list.
Also, keep in mind, that you can’t delete a project through web GUI of Gerrit. This is most wanted and requested feature of this dully project management tool, but still hasn’t been implemented for years.
So, create your new project wisely, because you won’t be able to delete them, without playing around console, installing some third-party plugins or doing stupidities similar to this.
Read More “Setting up new project in Gerrit”When I decided to purchase a new digital camera, I nearly immediately felt in love with Panasonic Lumix DMC-TZ35. Mainly because its 20x optical zoom in a piece of hardware available for a reasonable price. I have purchased it and… nearly immediately returned it to the shop. I found some glitches. Not many, but serious enough to make shooting a photos with this device nearly pointless.
I’m a an audiobook maniac. Listening to audiobooks requires MP3 player to have a special feature, which remembers last file/track played in a folder and last position within that file, for all folders, not just current one. This allows to listen to many audiobooks simultaneously, just as you’d be making bookmarks to a regular, printed book. All MP3 player, that I tested so far, hasn’t got than feature. Once you switched from folder/book A to folder/book B and then back to A, book/folder A was “reset” and play started from the very beginning. In this situation, I decided to write my own audiobook player in PhoneGap and release it as open source. Pity, but I failed to finish this project. Thus, I’m publishing only an unfinished sources and links to resources.
Here, you’ll find some tips on how to add (review and merge) a change to Gerrit. And a list of common pitfalls. Article is focused on detailed flow of described process with a short version (checklist) of it provided at the very end of this long text.
Read More “Git+Gerrit workflow for modern projects”This is the short version of “Remove sensitive data” article in GitHub Help. And an alternative solution to the one presented [here](Remove file from repository and from all revisions.txt). It assumes, that you are the only collaborator to repository, so you can perform steps at once (you don’t have to contact others and wait until they rebase your changes) and that your repository doesn’t use tags, so you don’t have to perform all steps.
If any these two assumptions is not correct in your case, then avoid this article and rather follow to mentioned article. Keep in mind, however, that in some certain situations, you have to contact GitHub Support in order to finish entire procedure.
Read More “Completely remove file from local and remote (GitHub) repository”If you’re new to Yii migrations, these sources might be a help for you:
How to create initial migration basing on current database state, explains this Stack Overflow question and GitHub Gist (with InitialDbMigrationCommand class’ code) to support it.
To use migrations, you have to properly configure console version of your Yii application. Details follows.
Read More “An introduction to database migrations in Yii”There are probably thousands of websites telling you, how to undo the last Git commit. For example, one of the most voted up questions on Stack Overflow. But none of them (or actually nearly none of them) answers, how to do this using git undo-commit. Simply because, such command does not exist! :> Therefore, the title of this text should rather sound “Defining own Git alias to undo last Git commit“, since this article is focused on git aliases rather than on undoing last commit in Git.
You can find this error during for example Skype or Java Runtime Environment installation. And probably many more. It just means that another program’s installation is in progress and current one can’t continue.
It happens in most case, when you try to install some software, when Windows Update is installing heavy portion of updates. And current program can’t install or update some system elements, that are being updated by Windows Update in the same time.
Solution? Wait some time (until end of Windows Update process?) and then restart installer of your program.
Microsoft has changed offline installation policy and you can’t download any offline installer, until you don’t provide your product key and you don’t login with your Microsoft account. If you don’t have it or you don’t want to use it, then the only option, you’re left with is to download offline installer from unofficial sources.
Read More “Offline installer for Microsoft Office 2010 and other products”
There are some key differences between SSH keys generated by ssh-keygen and Puttygen so you may run into problems importing or adding keys generated by the latter one, while importing ssh-keygen‘s keys goes swimmingly.
Here are some tips on this problem. Of course, we’re talking about public SSH keys, as private one are secret and shouldn’t be added or imported anywhere.
Read More “Differences between SSH key generated by ssh-keygen and Puttygen”No, you don’t need to install any extra program, to edit contents of Send to... context menu in Windows (source).
Instead, open any Explorer window and paste this as folder path:
%APPDATA%\Microsoft\Windows\SendTo
or hit Win+R, enter or paste shell:sendto and hit Enter.
This was proven to work in Windows 7 and 8. Most likely this works in Windows XP, Vista and 2000 as well.
[update] This still works nine years after writing this article, in Windows 10 and 11.
So, you’d like to make a webpage that looks like terminal or command-line, right?
With a little bit of HTML, CSS and Javascript, it is as easy as snapping a finger. Note, that I underlined “looks like”, because we’re going to do just a look & feel. This will not be a full-blown command line interpreter, where you can enter commands and get results. It will only be a simple, cool-looking… thing.
This article is a slight port of the code that can be found at fludotlove.com (done by Nathan Marshall).
Read More “Make a webpage looking like terminal or command-line”Forcing CKEditor 4’s toolbars to look exactly as you’d like is a bit hard task. Somewhere in official docs it is said, that you should use config.toolbarGroups configuration settings for this purpose. This is, of course, a complete mistake.
Benefits are weak and you’re actually loosing all the control over which button, in which group and in which line of toolbar should appear. This article will help you design CKEditor 4’s toolbars exactly, as you wish to have them, using old, good config.toolbar-way.
Let’s say that we have some posts, movies, files or other items that should be visible to end user in two situations:
0000-00-00 00:00:00) orHere is how.
Read More “Select records only with availability dates in future”
You can easily add any event to your user’s calendar, using properly crafted URL or file, that your users will click or download.
Details and examples can be found in this Stack Overflow answer, at taskboy.com blog and in Google Help.