Here are two simple SQL queries solving both:

Query for generate random date of birth in whole table

UPDATE

people

SET

date_of_birth=CONCAT_WS('-',(FLOOR( 1900 + RAND( ) *100)),(FLOOR( 1 + RAND( ) *12 )),(FLOOR( 1 + RAND( ) *28 )))

Query for selecting date of birth and calculation of age in MySQL:

SELECT
date_of_birth,
DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(date_of_birth, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(date_of_birth, '00-%m-%d')) AS age
FROM people

When You download and start installation of the client (mine was: vpnclient-winx64-msi-5.0.07.0290-k9.exe), You can start installation, but in one of the first steps will error occur:

installation ended prematurely because of an error

Fix which worked for me was following:

1. Delete whole registry key (better do backup first, by right-click this key and select Export): HKEY_CURRENT_USER\SOFTWARE\Classes\Wow6432Node\CLSID\{B54F3741-5B07-11CF-A4B0-00AA004A55E8}
2. Start commnad line as an administrator and type: regsvr32 c:\windows\syswow64\vbscript.dll
3. Start installation again and it should work
4. Restart your machine after install when promted

JRequest::getInt('catid');

or

JRequest::getInt('catid', '', 'get');

Maybe they worked in some other version of Joomla, but only working code I found is this (little modified by me to return integer values):

function getCategory() {
$iId = JRequest::getVar('id',0);
$database = &JFactory::getDBO();
if(JRequest::getVar('view', 0) == "section"){
return (int) JRequest::getVar( 'id', 0);
}else if(Jrequest::getVar( 'view', 0) == "category"){
$sql = "SELECT id FROM #__categories WHERE id = '$iId'";
$database->setQuery( $sql );
$row=$database->loadResult();
return (int) $row;
}else if(Jrequest::getVar('view', 0) == "article"){
$temp = explode(":",JRequest::getVar('id',0));
$sql = "SELECT catid FROM #__content WHERE id = ".$temp[0];
$database->setQuery( $sql );
$row=$database->loadResult();
return (int) $row;
}
}
$categoryId = getCategory();

Connect to your database and find the table called: yourStorePrefix_eav_attribute and find row containing name of attribute: tax_class_id (this may differ in some versions/installations of magento!) - mine had ID: 81

Now we have to find out what value is assigned to the prefered tax class, which we want assign to all products. You can find it out in the table called: yourStorePrefix_tax_class. Mine was: 2

Than go to you sql query editor and run the following command:

UPDATE yourStorePrefix_catalog_product_entity_int SET value=2 WHERE attribute_id=81

P.S.: Do not forget to renew all cache and rebuild all catalogue indexes – otherwise this change will not work on frontend!

That`s all folks!

I am using Suhosin php extension and I had to change one of the config values from:

suhosin.session.encrypt = On

to:

suhosin.session.encrypt = Off

This solved my whole problem with sessions. Hope it helps to you too.

Today I found a solution how to enable this feature for any case. It is so simple
Just open new tab in your Firefox browser and type:

about:config

Than just confirm the dialog, that you will be careful on this page and you will get to the Firefox config page, where you can edit almost any Firefox feature.
Find this value:

browser.ctrlTab.previews

and set it to true
That`s it!

Now you can close config window and your keyboard shortcuts: Ctrl+Tab & Ctrl+Shift+Tab will get new dimension It works as follow:

• If You hit Ctrl+Tab quickly it will browse your tabs as default – immediately switch into last viewed tab
• If You hold Ctrl and continuously click Tab button it shows you just small previews of tabs (I can see only 6 of them) – from this preview windows is also one of the options how to get to large tabs preview, where you can see all opened tabs at once – it can be done by activation button: “Show all XY tabs” (by navigating via Tab or by clicking button with mouse cursor)
• Last option is to use shortcut Crtl+Shift+Tab – this will navigate you directly into iLayer with all opened tabs listed. At the moment when this large list will appear, you can also start typing name of the tab you are looking for and Fireox will filter them out for you.

By this I also closed and issue in bugzilla (mentioned in previous article), because it is solved now. Enjoy!

Lets say, that I have following form:

<form action="#" method="post">
		<input id="googleCity" name="googleCity" type="hidden" />
		<input id="googleDistinct" name="googleDistinct" type="hidden" />
		<input id="googleCountry" name="googleCountry" type="hidden" />
		<input id="googleCompleteAddress" name="googleCompleteAddress" type="hidden" />
		<input id="googleLatitude" name="googleLatitude" type="hidden" />
		<input id="googleLongtitude" name="googleLongtitude" type="hidden" />
		<input id="googleStatus" name="googleStatus" type="hidden" />
<!-- Some other fields like name etc. -->
	<label for="street">
		<input id="street" name="street" type="text" />
	</label>
	<label for="city">
		<input id="city" name="city" type="text" />
	</label>
	<label for="zip">
		<input id="zip" name="zip" type="text" />
	</label>
<!-- Some other fields like email etc.-->
		<input type="submit" value="Register" />
</form>

Now I have to parse typed values by user into the javascript code, which will immidiately send this string into Google Maps API. This part of code is fit for a jQuery library and You have to also include Google Maps API with Your API key which can be genarated on Google Maps API Sign Up page.
Here is the basic code for loading all neccessary libraries:

<script type="text/javascript" src="http://www.google.com/jsapi?key=HereGoesYourGoogleMapsApiKeyGeneratedOnLinkAbove"></script>
            <script type="text/javascript" charset="utf-8">
                    google.load("maps", "2.x");
                    google.load("jquery", "1.4.2");
              </script>

Now I will type some code, which will handle typed strings into the form and send them to Google Maps API. Here is the code:

    $(document).ready(function(){
      var geo = new GClientGeocoder();
//live function checks all the time fields street, city and zip for their blur action, at this moment it tries to get Geo data from Google - in regular way it should take max. 3 calls to Google
            $("input#street,input#city,input#zip").live("blur", function(){
//here is being built a variable including data from all address fields
                var address = $('input#frmregisterUserForm-ulice').val() + ', '+ $('input#frmregisterUserForm-cisloPopisne').val() + ', ' + $('input#frmregisterUserForm-mesto').val();
//let`s send complete address to Google and try to request data from API
                geo.getLocations(address, function (result){
                    statusCode = result.Status.code;
                    if (statusCode && statusCode == '200') {
//status code 200 means, that response is OK and Google found the place I was looking for and it returns me all data I want - so I will store them into hidden fields inside form defined above
                        $("input#googleDistinct").val( result.Placemark[0].AddressDetails.Country.AdministrativeArea.AdministrativeAreaName );
                        $("input#googleCity").val( result.Placemark[0].AddressDetails.Country.AdministrativeArea.Locality.LocalityName );
                        $("input#googleCountry").val( result.Placemark[0].AddressDetails.Country.CountryName );
                        $("input#googleCompleteAddress").val( result.Placemark[0].address );
                        $("input#googleLongitude").val( geocode[0] );
                        $("input#googleLatitude").val( geocode[1] );
                        $("input#googleStatus").val( result.Status.code );
                    } else {
                        $("input#frmregisterUserForm-googleStatus").val( result.Status.code );
                    }
                });
            });
    });

As You can see, if You will provide to google just the partial address, Google Maps API will return to You complete address incl. distinct, country and much more information about this location incl. coordinates of that place – what we wanted the most.

_xdc_._0g7bwexyl && _xdc_._0g7bwexyl( {
  "name": "Václavské náměstí, 1, Praha",
  "Status": {
    "code": 200,
    "request": "geocode"
  },
  "Placemark": [ {
    "id": "p1",
    "address": "Václavské náměstí 846/1, 110 00 Praha 1-Nové Město, Česká republika",
    "AddressDetails": {
   "Accuracy" : 8,
   "Country" : {
      "AdministrativeArea" : {
         "AdministrativeAreaName" : "Hlavní město Praha",
         "SubAdministrativeArea" : {
            "Locality" : {
               "DependentLocality" : {
                  "DependentLocalityName" : "Nové Město",
                  "PostalCode" : {
                     "PostalCodeNumber" : "110 00"
                  },
                  "Thoroughfare" : {
                     "ThoroughfareName" : "Václavské náměstí 846/1"
                  }
               },
               "LocalityName" : "Praha 1"
            },
            "SubAdministrativeAreaName" : "Praha"
         }
      },
      "CountryName" : "Česká republika",
      "CountryNameCode" : "CZ"
   }
},
    "ExtendedData": {
      "LatLonBox": {
        "north": 50.0873298,
        "south": 50.0810346,
        "east": 14.4271808,
        "west": 14.4208856
      }
    },
    "Point": {
      "coordinates": [ 14.4240332, 50.0841822, 0 ]
    }
  } ]
}
 )

Now I must store all these data into the database. I will not describe here some main procedure of how to insert some data into the MySQL database. But I will describe how get closest places stored in the database from the defined coordinates.

I will describe this procedure in the next article

UPDATE: I reported this to Firefox bugzilla under id: 566741. So we will see, what they will do or tell us about this.

Everything is fine now, our servers are secured and attacker stealed only public available information searchable via WHOIS.

At this moment I said ok … everyone can have some security issue, which can be used by an attacker. They sent me a new password for the administration and I changed it to new one. But 2 days after that, was this company hacked again and at this moment I also received an email with my public WHOIS info, but also md5 has of my new password I did steup after first attack … Now I was sure, that banan.cz is not being too honest to their clients and they were lying in every official statement they made. They also lied at their second official statement, which was actually almost same as first one, but they added an info about last attack, that no new data were stolen and in fact attacker just sent new emails to the all clients of banan.cz using email database from the first attack … pfff liars how could attacker get my latest password hash with database from first attack? Maybe attacker is an magician or something like that …

Here is an email I got from an attacker:

Immidiately after I read this email I started proccess of the server setup and domain transfer. I asked my friend to setup a server for me and place it in the serverhousing datacenter in Prague. Whole thing took about a week and now I am free. Free from being depend on company who is lying to me.

I have my own server and banan is hosting 42 domain less

DBDesigner 4

MySQL Workbench

DBDesigner seems to work more smoother and faster (I mean from the view of the perfomance of the computer) but this is probably only one difference I found between these programs. I decided to stay with DBDesigner 4 mainly because of its wider support for the different databases. Give it a try and choose Yours:
MySQL Workbench
DBDesigner 4

UPDATE:

DB DESIGNER 4 – localhost connection problem

I found a little problem with the DBDesigner 4 and it is its connection to the localhost server and probably any other. You will get and error, that You have wrong username aor password in the connection settings. Here is the guide how to fix the problem:

1. Create a new MySQL user for Your mysql database
2. Add global privilleges to this user
3. Run following query:

   SELECT * FROM mysql.`user`

4. One of the result lines should be something like this:

   'localhost', 'dbd4', '*DBC24926E0821352A2CE9593D8909FBFFE85CA74', 'Y',
   'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y',
   'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', '', '', '', '',
   0, 0, 0, 0

   …in case, that You will add a username db4 and password db4 too.

5. Now run another query:

   UPDATE mysql.user SET Password = OLD_PASSWORD('dbd4')
   WHERE Host = 'localhost' AND User = 'dbd4';

6. Now should connection to the localhost work from the DBDesigner 4
7. If not, please make sure, that Your MySQL server is running on port 3306, otherwise DBDesigner 4 will not be able to connect to Your database!