SELECT * FROM table WHERE id IN (1,5,8,73,5,4,88)

This will return rows ordered by its primary key (in my case column id). Here is updated query, which will keep order of items listed in WHERE IN clause:

SELECT * FROM table WHERE id IN (1,5,8,73,5,4,88) ORDER BY (id,1,5,8,73,5,4,88)

Please note first item in brackets behind ORDER BY – there should be set same column, which was used at WHERE IN clause.

1. on the left side choose You app
2. than on the top right click on “Edit App” button
3. On the left should be choosen: Settings -> Basic
4. Go down into the section called: “Select how your app integrates with Facebook”
5. Find setup for Page Tab and check if you have set correct width of used app layout (mine was 520px)
6. Save changes, if anything changed
7. Than on the left choose Settings -> Advanced
8. In the section “Canvas Settings” should be following setup for canvas height: fluid

If above described setup is ok, than we have to fix it in our application. It is simple, with two code snippets. Just add following before </body> tag (If You are not using Facebook init script already):

<script type="text/javascript" src="http://connect.facebook.net/en_US/all.js"></script><script type="text/javascript">// <![CDATA[
	FB.init({
		appId : '399179393429469',
		status : true, // check login status
		cookie : true, // enable cookies to allow the server to access the session
		xfbml : true // parse XFBML
	});
// ]]></script>

And put this code just before closing tag :

  <script type="text/javascript">
	window.fbAsyncInit = function() {
		FB.Canvas.setSize();
	}
	function sizeChangeCallback() {
		FB.Canvas.setSize();
	}
	</script>

Now, If your page is coded correctly into desired width, You should not see scrollbars anymore in it.
Hope it helps.

The easiest way, how to get his/her UID  is to load user`s facebook profile and right click his/her main profile image and select Inspect element in submenu. It will open Your Firebug or browser/DOM inspector (new Firefox or Chrome). In the inspector, You should see and URL of image. What I found out, is, that user`s facebook profile ID is second number in the photo name. Mine was like this: 157184_1317732574_574480779_n.jpg

If You are using Facebook timeline, You could check Facebook profile ID also from the bigger profile picture. In my case it was third number: 425232_3326820732162_1317732574_3347250_1064723857_n.jpg

The easiest way, how to check, if the number is correct is to add selected number behind this URL and load it in the broswer:

https://www.facebook.com/profile.php?id=AddYourNumberHere

If You will want to add more moderators or admins into Your facebook app using these IDs, just find out all of them and insert them into text input separated with comma without spaces. Facebook will handle this numbers and it will add selected profiles into the list of moderators automatically (than just hit Save button at the bottom of the moderation setup dialog/page).

Hope it will help You

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