Password Protecting Your Pages with htaccess

Source: http://www.elated.com/articles/password-protecting-your-pages-with-htaccess/

Creating the password file using htpasswd

If you have SSH access to your web server (or you're running Apache on a local machine), you can encrypt your password and add it to your password file in one go by using the htpasswd utility that comes with Apache. Simply SSH to your server or open up a terminal window on your local machine, cd to the folder where you want to create your password file, and type:

htpasswd -c .htpasswd fred

(where fred is the username you want to use). You'll be prompted to enter and retype your password, then the .htpasswd file will be created for you.

Protecting a folder

To password protect a folder on your site, you need to put the following code in your.htaccess file:

AuthUserFile /full/path/to/.htpasswd
AuthType Basic
AuthName "My Secret Folder"
Require valid-user

/full/path/to/.htpasswd should be the full path to the .htpasswd file that you uploaded earlier. The full path is the path to the file from the Web server's volume root - for example, /home/username/.htpasswd or C:\wwwroot\username\.htpasswd. (If you're not sure of the full path to your site or home directory, ask your Web hosting company for this info.)
The above .htaccess file will password protect all files in the folder that it is placed in, and all sub-folders under that folder too. So if you wanted to password protect your entire site, you would place the .htaccess file in your Web root folder.

Protecting a file

To password protect just a single file in a folder, use the following .htaccess file:

AuthUserFile /full/path/to/.htpasswd
AuthType Basic
AuthName "My Secret Page"

<Files "mypage.html">
  Require valid-user
</Files>

This will password protect just the mypage.html file in the folder where you put the.htaccess file.

Mysql Order / Sort by before Group by

Every developer knows the horror of mysql sort/order by or select distinct using with group by. Mysql does group by before order by and you get mixed results not what you expected. This is a small solution with less performance problem:

SELECT * FROM 

(
select * from `my_table` order by timestamp desc
) as my_table_tmp

group by catid

order by nid desc

In this example we get latest news in each category. We create a temp table by sorting by timestamp and group by after it. It worked for me.

Extract tar.gz File

tar is used to create a Tape ARchive.  The resulting file is known as a tarball.  It's pretty much the same concept as a ZIP file, if you know what they are, but without the compression.  To get the files out of a tarball, you can use the following commands: tar xvf something.tar If the tarball has also been gzipped (compressed), you can use the following command: tar xvfz something.tar.gz If you only want certain directories from the tarball, do this: tar xvzf something.tar.gz */dir.you.want/* If you have a .tar.bz2 file, then you need bzip2 installed (/usr/ports/archivers/bzip2), and you issue this command: tar yxf something.tar.bz2

tar

To tar up *.db in the current directory into a tarball called blah.tar.gz, issue this command: tar cfz blah.tar.gz *.db The z option compresses.

listing the contents

To see a list of the files within a tarball, issue the following command: tar -tzf blah.tar.gz The -t provides a list.  the -z indicates that the tarball is compressed.   The -f identifies the tarball. Here's an example: # tar -tzf makeworld.991126.tgz etc/ etc/protocols etc/aliases etc/services etc/hosts

Swipe JS a very useful tool for native-like swiping

Swipe JS brings content sliding to the mobile web to preserve space and allow for new types of interaction. Many mobile web sliders currently exist but few embody all the rules a slider like this should follow.

1:1 touch movement

1:1 movement, as described above, is about tracking the position of the touch and moving the content exactly how the touch interacts. This interaction is very common in native apps.

Resistant bounds

When Swipe is at the left-most position, sliding any more left will increase the resistance to slide, making it obvious that you have reached the end. This detection/resistance occurs at both left and right bounds.

Rotation/resize adjustment

When a user rotates their device (in turn resizing the browser window), the slider resets to make sure the sliding elements are the right size. This is only necessary for sliders without declared widths.

Variable width containers

Swipe allows you to set a width to the container, which designates the width of each slide element. This is important if you do not want a full width slider (the default).

Scroll prevention

Scroll prevention is one of the most overlooked pieces of mobile sliders. Swipe detects if you’re trying to scroll down the page or slide content left to right.

Library agnostic

Swipe doesn’t rely on any library. Trust me this is a good thing. All you have to do is pass in the container element, set some parameters, and BOOM goes the dynamite– you're all set. You may choose to pass the element to Swipe with a library, but it’s not necessary.

Showing Or Saving An Image Retrieved Via cURL

As a developer cURL can be a very handy for numerous reasons. In my case I have used it for my plugin Twitter Stream, but here we are going to look at a little tip I stumbled across while playing with cURL.

cURL is used to make a connection to an external source to retrieve the content at the source. What most people new to cURL don’t realize is that it can be used to retrieve any content, including images.

Piping Output from One Command to Another

Piping allows the user to do several fantastic thing by combining utilities. I will cover only very basic uses for piping. I most commonly use the pipe command, |, to pipe text that is output from one command through the grep command to search for text.
 
Examples:

See if a program, centericq, is running:$ ps ax | grep centericq 25824 pts/2 S 0:18 centericq Count the number of files in a directory (nl counts things):$ ls | nl 1 #.emacs# 2 BitchX 3 Outcast double cd.lst 4 bm.shader 5 bmtexturesbase.pk3 If my memory serves using RPM to check if a package is installed:$ rpm -qa | grep package_name A more advance example:$ cat /etc/passwd | awk -F: '{print $1 "\t" $6}' | sort > ./users This sequence takes the information if the file passwd, pipes it to awk, which takes the first and sixth fields (the user name and home directory respectively), pipes these fields separated by a tab ("\t") to sort, which sorts the list alphabetically, and puts it into a file called users.