The Best Resources Blog

Fix for Joomla ‘JFolder::create: Could not create directory’ Error

noreply@blogger.com (DOM) — Wed, 18 Jan 2012 20:19:18 PST

Unlike other Errors, the fix for this error is pretty Simple. Follow the steps below to fix it.
#1 Goto your Hosting panel >> File Manager >> Select your Domain/Sub-Domain and then open the configuration.php file.
#2 Find var $log_path, it will contain the Directory path of your Old Server. Just replace the whole line with the code var $log_path = './logs';
#3 Find var $tmp_path, it will also have the Directory path of your Old Server. Replace the whole line with the code var $tmp_path = './tmp';

Convert DateTime to Month/Year(SQLServer)

noreply@blogger.com (DOM) — Tue, 10 Jan 2012 19:24:16 PST

Convert DateTime to Month/Year(SQLServer)

select convert(varchar(2),datepart(month,getdate())) + '/' +
convert(varchar(4),datepart(year,getdate()))

DATE FORMATE OF MYSQL AND SQLSERVER

noreply@blogger.com (DOM) — Thu, 05 Jan 2012 00:51:38 PST

SQLSERVER

date>='mm-dd-yyyy' and date<='mm-dd-yyyy'

MYSQL

date>='yyyy-mm-dd' and date<='yyyy-mm-dd'

Khmer Unicode for iPhone, iPod and iPad

noreply@blogger.com (DOM) — Thu, 29 Dec 2011 18:56:53 PST

Now you can get Khmer Unicode Font and Keyboard on your jailbroken iPhone, iPod and iPad. Please follow the 7 steps below to install Khmer Unicode Font and Keyboard on your devices.

1. Go to Cydia > Manage > Sources.

2. Click Edit > Add.

3. Enter Cydia/APT URL as the following: http://iphonekhmer.com/ and then click Add Source.

4. After the source has been added, click Done and go to the source: “iphonekhmer.com.”

5. Select the right version of Khmer Unicode Font and Keyboard that correspond to your devices.

6. Click install > Confirm and then allow the installation proceeds. Click Return to Cydia or Reboot Device when finished.

7. Leave Cydia and go to Settings > General > Keyboard > International Keyboards > Add New Keyboard… and then scroll to find and select Khmer.

Now your Khmer Unicode Font and Keyboard installation is set. To test if it works, please open a New Note. To change your keyboard from English to Khmer, tab on the world button next to the space bar. Now you are ready to type in Khmer on your devices.

Good luck!

5 useful url rewriting examples using .htaccess

noreply@blogger.com (DOM) — Tue, 20 Dec 2011 00:43:55 PST

If you are looking for the examples of URL rewriting then this post might be useful for you. In this post, I’ve given five useful examples of URL rewriting using .htacess. If you don’t know something about url rewriting then please check my older post about url rewriting using .htaccess.

Now let’s look at the examples

1)Rewriting product.php?id=12 to product-12.html

It is a simple redirection in which .php extension is hidden from the browser’s address bar and dynamic url (containing “?” character) is converted into a static URL.

RewriteEngine on
RewriteRule ^product-([0-9]+)\.html$ product.php?id=$1

2) Rewriting product.php?id=12 to product/ipod-nano/12.html

SEO expert always suggest to display the main keyword in the URL. In the following URL rewriting technique you can display the name of the product in URL.

RewriteEngine on
RewriteRule ^product/([a-zA-Z0-9_-]+)/([0-9]+)\.html$ product.php?id=$2

3) Redirecting non www URL to www URL

If you type yahoo.com in browser it will be redirected to www.yahoo.com. If you want to do same with your website then put the following code to .htaccess file. What is benefit of this kind of redirection?? Please check the post about SEO friendly redirect (301) redirect in php and .htaccess.

RewriteEngine On
RewriteCond %{HTTP_HOST} ^optimaxwebsolutions\.com$
RewriteRule (.*) http://www.optimaxwebsolutions.com/$1 [R=301,L]

4) Rewriting yoursite.com/user.php?username=xyz to yoursite.com/xyz

Have you checked zorpia.com.If you type http://zorpia.com/roshanbh233 in browser you can see my profile over there. If you want to do the same kind of redirection i.e http://yoursite.com/xyz to http://yoursite.com/user.php?username=xyz then you can add the following code to the .htaccess file.

RewriteEngine On
RewriteRule ^([a-zA-Z0-9_-]+)$ user.php?username=$1
RewriteRule ^([a-zA-Z0-9_-]+)/$ user.php?username=$1

5) Redirecting the domain to a new subfolder of inside public_html.

Suppose the you’ve redeveloped your site and all the new development reside inside the “new” folder of inside root folder.Then the new development of the website can be accessed like “test.com/new”. Now moving these files to the root folder can be a hectic process so you can create the following code inside the .htaccess file and place it under the root folder of the website. In result, www.test.com point out to the files inside “new” folder.

RewriteEngine On
RewriteCond %{HTTP_HOST} ^test\.com$ [OR]
RewriteCond %{HTTP_HOST} ^www\.test\.com$
RewriteCond %{REQUEST_URI} !^/new/
RewriteRule (.*) /new/$1

How to make PHP Crosstab?

noreply@blogger.com (DOM) — Thu, 15 Dec 2011 01:17:15 PST

SELECT DATE_FORMAT(tracked_date,'%Y-%m-%d') as my_tracked_date,
sum(ss.term_id IN (3) OR tt.parent IN (3)) AS category3,
sum(ss.term_id IN (4) OR tt.parent IN (4)) AS category4,
sum(ss.term_id IN (5) OR tt.parent IN (5)) AS category5,
sum(ss.term_id IN (6) OR tt.parent IN (6)) AS category6
FROM wp_terms AS t LEFT JOIN a AS ss ON t.term_id = ss.term_id LEFT JOIN b AS tt
ON ss.term_id = tt.term_id
WHERE DATE_FORMAT(tracked_date,'%Y-%m-%d') IS NOT NULL
GROUP BY my_tracked_date ORDER BY my_tracked_date

IQ Test (Sample)

noreply@blogger.com (DOM) — Tue, 04 Oct 2011 21:34:44 PDT

Test preparation questions

Take a look at these sample questions before attempting the test as they will give you a very good idea of what to expect. Each question is designed to test various aspects of your mental abilities. Explanations are included where appropriate.

1.Verbal
2.Mathematical
3.Spatial
4.Visualization
5.Classification
6.Logic
7.Pattern recognition

Verbal Intelligence
It is said that to have a mastery of words is to have in one’s possession the ability to produce order out of chaos and that command of vocabulary is a true measure of intelligence. Verbal intelligence measures your capacity to use language in order to express yourself, comprehend stories and understand other people. Verbal abilities include reading, writing and communicating with words. The verbal component of this test examines your vocabulary and your capacity to learn verbal material. It also measures your ability to employ verbal skills in reasoning and problem solving.
1. Rearrange the following letters to make a word and choose the category in which it fits.
RAPETEKA
A. city
B. fruit
C. bird
D. vegetable
Correct answer: bird (parakeet)
2. Find the answer that best completes the analogy
people : democracy :: wealthy :
A. oligarchy
B. oligopoly
C. plutocracy
D. timocracy
E. autocracy
Correct answer: plutocracy
3. Find the answer that best completes the analogy
languages : meaning :: philology :
A. erudition
B. philosophy
C. ethics
D. semantics
E. grammar
Correct answer: semantics
4. Which one of the sets of letters below can be arranged into a five letter English word.
A. A T R U N
B. P O D E B
C. R N A S L
D. M O H A T
E. E T L R N
Correct answer: R N A S L (snarl)
5. What is the missing letter?

E C O

B A B

G B N

D B ?

Correct answer: H
Explanation: Convert each letter to its numerical equivalent in the alphabet e.g. the letter “C” is assigned the number “3″. Afterwards, for each row, multiply the numerical equivalents of the first two columns in order to calculate the letter in the third column.
6. Find two words, one from each group, that are closest in meaning.

Group A
raise
floor
stairs Group B
top
elevate
basement

A. raise and elevate
B. raise and top
C. floor and basement
D. stairs and top
E. floor and elevate
Correct answer: raise and elevate

Mathematical Intelligence
We all require some numerical skills in our lives, whether it is to calculate our weekly shopping bill or to budget how to use our monthly income. Flexibility of thought and lateral thinking processes are a few skills which are needed in order to solve these problems. Mathematical intelligence generally represents your ability to reason and to calculate basic arithmetic computations. It also helps you to understand geometric shapes and manipulate equations. Mathematical intelligence is a strong indicator of general intelligence because many every day mental tasks require arithmetical operations even though numbers may not be involved.
1. Which number should come next in this series?
25,24,22,19,15
A. 4
B. 5
C. 10
D. 14
Correct answer: C
Explanation: The pattern decreases progressively: -1, -2, -3, -4, -5
2. Which number should come next in this series?
3,5,8,13,21,
A. 4
B. 21
C. 31
D. 34
Correct answer: D
Explanation: 3+5=8, 5+8=13 and so on.
3. Which number should replace the question mark?

17 8 5 5

13 7 5 4

6 12 6 3

10 6 4 ?

A. 4
B. 5
C. 6
D. 7
Correct answer: A
(For each row the sum of the first two columns is equal to the multiple of the last two columns)
4. Which number should replace the question mark?

8 5 21

35 32 12

32 28 31

4 ? 28

A. 3
B. -2
C. -6
D. 48
Correct answer: C
(For each row subtract the second column from the first column. The result is equal to the sum of the digits in the last column.)
Spatial

Spatial abilities are the perceptual and cognitive abilities that enable a person to deal with spatial relations, in other words the visualization and orientation of objects in space. Put simply spatial skills assess your ability to manipulate 3D objects by flipping and rotating them. Spatial intelligence questions test raw intelligence without the influence of prior knowledge and as such performance on this scale is indicative of general intelligence. At a first glance, such questions may appear daunting but the trick is not to give up too quickly. Often a second look at the problem will reveal a different approach, and a solution will appear because the brain has been given the opportunity to process information further.

1. Which diagram results from folding the diagram on the left?

Correct answer: A
2. Which of the cubes is the same as the unfolded cube below?

A B C D

Correct answer: A
3. Which one of the Rubik’s cube below can be part of the sequence?

A B C D

Correct answer: C
Visualization

Visual intelligence measures the ability to process visual material and to employ both physical and mental images in thinking. As a result people with a high visualization IQ find it easier to comprehend information and communicate it to others. Your visualization skills determine how well you perceive visual patterns and extract information for further use. Visualization also facilitates the ability to form associations between pieces of information something which helps improve long term memory.

1. Pick the piece that’s missing from the diagram below

A B C D

Correct answer: A
2. Which figure is the odd one out?

Correct answer: D
3. Which of the following figures is the odd one out?

Correct answer: A
4.Which of the following figures is the odd one out?

Correct answer: C
5. How many four sided shapes does this diagram have?

A. 5-10
B. 11-15
C. 16-20
D. 21-25
E. 26-30
Correct answer: E
Classification

This intelligence is closely related to the concept of general intelligence and measures the ability to organize collections of items by finding similarities and differences between them. By grouping together items such as words, ideas, songs or pictures you are able to achieve a more conceptual understanding of the relationships between them. Classification skills enable you to discern relevant data and this helps you gain a better general understanding of the world.

1. Which word does not belong?
apple, marmalade, orange, cherry, grape
A. apple
B. marmalade
C. orange
D. cherry
E. grape
Correct answer: B

2. Which number does not belong?

4 32 144

17 28 122

18 64 188

322 14 202

Correct answer: 17
Explanation: 17 is the only odd number.
3. Which of the following diagrams is the odd one out?

Correct answer: D
Explanation: D is the only diagram where the intersection does not form the original shape.

Logic

Logical thinking is the ability to make deductions that lead rationally to a certain conclusion. It is important to have good logic skills because they help you think things through and they also give you a good understanding of cause and effect relationships. In this test your logic IQ was assessed through your ability to comprehend and follow certain rules and conditions set forth in many of the questions. Generally speaking logic skills make divergent thinkers and have proven to be very successful in our daily lives. Furthermore when combined with social insight and and self awareness logic skills make us into effective human beings. Improving these skills will increase your IQ and give you a good base for academic and personal success.

1. At the end of a banquet 10 people shake hands with each other. How many handshakes will there be in total?
A. 100
B. 20
C. 45
D. 50
E. 90Correct answer: C
2. The day before the day before yesterday is three days after Saturday. What day is it today?
A. Monday
B. Tuesday
C. Wednesday
D. Thursday
E. Friday
Correct answer: E
3. Select the number that best completes the analogy
10 : 6 :: 3 : ?
A. 2
B. 1
C. -1
D. 12
E. 4
Correct answer: -1
4. Which number should come next in the series
1, 3, 6, 10, 15,
A. 8
B. 11
C. 24
D. 21
E. 27
Correct answer: 21
5. 165135 is to peace as 1215225 is to
A. lead
B. love
C. loop
D. castle
Correct answer: love
6. Library is to book as book is to
Binding Copy Page Cover
A. page
B. copy
C. binding
D. cover
Correct answer: page
Pattern recognition

Out of all mental abilities this type of intelligence is said to have the highest correlation with the general intelligence factor, g. This is primarily because pattern recognition is the ability to see order in a chaotic environment; the primary condition for life. Patterns can be found in ideas, words, symbols and images and pattern recognition is a key determinant of your potential in logical, verbal, numerical and spatial abilities. It is essential for reasoning because your capacity to think logically is based on your perception of the logic around you. Your pattern recognition skills are expressed verbally through your long term exposure to language and your mathematical and spatial abilities are based on your perception of numerical data and 3D objects.

1. Find the picture that follows logically from the diagrams to the right.
Correct answer: A
2. Find the picture that follows logically from the diagrams to the right.

Correct answer: C
3. Please enter the missing figure: 4, 5, 8, 17, 44,
A. 80
B. 125
C. 112
D. 60
E. 84
Correct answer: B
Explanation: The difference between the numbers follows the series 1,3,9,27,81
4. Please enter the missing figure: 13, 57, 911, 1315, 1719
A. 2123
B. 1879
C. 3002
D. 5004
E. 1784
Correct answer: A
Explanation: All odd numbers in a series.
5. Which of the diagrams follows?

Correct answer: A
Explanation: All the characters are letters back to back (C,D,E,F)

10 Awesome jQuery Count Down Scripts

noreply@blogger.com (DOM) — Thu, 29 Sep 2011 18:48:37 PDT

We have seen enough samples of the countdown features in most site like RapidShare, MegaUpload etc that allows you to download files but make you wait specified number of seconds before giving you the download link. We have probably also seen sites that are not online yet using a countdown to tell visitors to come back in a very dynamic manner. A countdown script has a lot of useful cases and the good news is that there are some really good jQuery scripts you can use for your site.
Check out our list of 10 Awesome jQuery Count Down Scripts below. Enjoy!

1. jQuery Countdown with Background and Overlay

Really cool countdown script. There is a full package for download with script, images, CSS etc.

Source

2. littlewebthings CountDown

This is an Easy to use animated countdown JavaScript. It is jQuery compatible and easily skinable.

Source

3. jQuery Countdown plugin that doesn’t suck!

This countdown has a great animation.

Source

4. The Great Cornholio Countdown

Very simple countdown, all it does is it transforms a sql timestamp (YYYYMMDDHHMMSS) into a countdown timer.

Source

5. jQuery Countdown

This is a jQuery plugin that sets a div or span to show a countdown to a given time. There are tons of options available and everything is supported by good examples and code snippets.

Source

6. Countdown timer jQuery Plugin

A simple jQuery Plugin that countdowns how long it is from a date. Very easy to use and a good download package with everything needed to get started.

Source

7. jQuery CountDown Plugin

This script allows you to create a rapidshare.com like countdown and to animate the CSS font-size of each second and present a reward at the end.

Source

8. KK Countdown

Plug-in counts time to a particular date in the future.

Source

9. The Final Countdown

A really simple and abstract date countdown plugin for jQuery.

Source

10. Fancy Countdown

A fancy countdown timer which is visually stunning. It looks like the one Google I/O used in their website.

Source

37 Fresh jQuery Image And Gallery Display Solutions

noreply@blogger.com (DOM) — Wed, 28 Sep 2011 06:28:53 PDT

jQuery is already very popular because it is very fast and concise Javacript library simplifing and different event handling, smooth animation with very little code. With jQuery you can enjoy new way of web development and image galleries are the best way to use it effectively! Here you’ll have more than 35 different unique jQuery Javascript solutions for beautiful image galleries and great ways to display your images with light code.

To make it even easier for you to choose, I also added live demo link under every jQuery plugin! However if you are searching for even more alternatives with Flash, plain CSS or another Javascript library, check out this post -57+ Free Image Gallery, Slideshow And Lightbox Solutions.

1. PhotoSquare Photography WordPress Theme ($79)

PhotoSquares is very flexible premium gallery WordPress theme that is perfect way for designers and photographers to display their portfolio.
This theme allows you to set your own thumbnail sizes so everyone will be able to create most suitable layout.

2. GalleryView: A jQuery Content Gallery Plugin

GalleryView aims to provide jQuery users with a flexible, attractive content gallery that is both easy to implement and a snap to customize.

View Demo

2.1. Sexy Slider

SexySlider is a JQuery plugin that lets you easily create powerful javascript Sliders with very nice transition effects. Enhance your website by adding a unique and attractive slider!

View Demo

3. Sliding Image Gallery jQuery Plug-in

The SlidingGallery plug-in will take a group of images and turn them into a cyclical gallery of images which the user can click through. One image will be centered on the screen, with two smaller images off to the sides. The user can click either of the smaller images to bring them to the center, or the center image to enlarge it. For optimal use, this plug-in should be applied to seven or more images, but can work with fewer (images will be duplicated in order to bring the total to seven).

View Demo

4. PrettyPhoto jQuery Lightbox Clone

PrettyPhoto is a jQuery based lightbox clone. Not only does it support images, it also add support for videos, flash, YouTube, iFrames. It’s a full blown media lightbox. The setup is easy and quick, plus the script is compatible in every major browser.

View Demo

5. Create Beautiful jQuery slider tutorial

This tutorial explains how to develop Create Beautiful jQuery sliders tutorial with image description and name.

View Demo

6. AD Gallery – a jQuery gallery plugin

A highly customizable gallery/showcase plugin for jQuery.

View Demo

7. FancyBox

FancyBox is a tool for displaying images, html content and multi-media in a Mac-style “lightbox” that floats overtop of web page.

View Demo

8. Shadowbox

Shadowbox is an online media viewer application that supports all of the web’s most popular media publishing formats. Shadowbox is written entirely in JavaScript and CSS and is highly customizable. Using Shadowbox, website authors can showcase a wide assortment of media in all major browsers without navigating users away from the linking page.

View Demo

8.1.AviaSlider – jQuery Slideshow

AviaSlider is a very flexible and easy to use Image slideshow plugin for jQuery with a set of really unique transitions that were nver available before, as well as some basic transitions, so the slider will fit into every project.
It comes with an image preloader so the slider starts when images are ready to be shown. No clumsy animations with half loaded images.

View Demo

9. Galleriffic

Galleriffic is a jQuery plugin that provides a rich, post-back free experience optimized to handle high volumes of photos while conserving bandwidth. I am not so great at spelling, and it was much later that I realized that the more appropriate spellings would be Gallerific or Gallerrific, but is too late now for a name change, so Galleriffic remains.

View Demo

10. Colorbox

A light-weight, customizable lightbox plugin for jQuery 1.3.

View Demo

11. The Lightbox Clones Matrix

Comparison of various scripts that display images and other objects in somehow cool CSS popups

12. Full screen image gallery using jQuery and Flickr

It’s a full screen image gallery that automatically scales the image with kept aspect ratio to fill the browser background. It also supports a flickr search engine, thumbnails, captions, preloader and some other goodies.

View Demo

13. Moving Boxes

View Demo

13.1. DDSlider – 10 Transitions – Inline Content Support

DDSlider introduces a new easy-to-go slider with 9 different unique transitions (+fading & random—11 total) that support Inline Content. You can also have multiple sliders in the same page.

View Demo

14. Creating a Slick Auto-Playing Featured Content Slider

View Demo

15. Start/Stop Slider

View Demo

16. SlideViewerPro 1.0

SlideViewerPro is a fully customizable jQuery image gallery engine wich allows to create outstanding sliding image galleries for your projects and/or interactive galleries within blog posts.

View Demo

17. Pirobox V.1.2.1

View Demo

18. s3Slider jQuery plugin

The s3Slider jQuery plugin is made by example of jd`s smooth slide show script.

View Demo

18.1. Advanced Slider – jQuery XML slider

Advanced Slider is a jQuery plugin that allows you to easily create powerfull sliders using either XML , thus making the slider much easier to setup and maintain, or using HTML markup. The plugin also provides an easy to use API which will allow to further enhance the functionality of the slider and make it possible to integrate it into your own application. Please take a look at the list of features below.

View Demo

19. CSS and Jquery – Creating an Image Slider

View Demo

20. Create an Image Rotator with Description (CSS/jQuery)

An image rotator is one great way to display portfolio pieces, eCommerce product images, or even as an image gallery. Although there are many great plugins already, this tutorial will help you understand how the image rotator works and helps you create your own from scratch.

View Demo

21. jQuery spherical panorama viewer

A javascript viewer for displaying spherical panoramas. An alternative to Java and QuickTime technology.

View Demo

22. Zoomimage – jQuery plugin

Present you images in stylish way. The links are unobtrusively highjacked to open the images in an inpage popup with drop shadow and border.

View Demo

23. Building a jQuery Image Scroller

View Demo

24. Easy Slider 1.5 – The Easiest jQuery Plugin For Sliding Images and Content

View Demo

25. jQuery Panel Gallery Plugin

No slicing or editing of the images is needed
It’s just 5K
Easily configurable
Reusable on multiple containers

View Demo

25.1. uBillboard – Premium Slider for WordPress

uBillboard is a Premium Slider for WordPress. It is a jQuery based slider with a multitude of transitions and options for you to be able to customize it to your needs while not overwhelming you with options you never wanted or needed. Version 3 is a revolutionary release with most of the codebase rewritten from scratch. This has enabled us to integrate many features that you have been requesting during the first year.

View Demo

26. Supersized – Full Screen Background/Slideshow jQuery Plugin

View Demo

27. Pikachoose

Pikachoose is a lightweight Jquery plugin that allows easy presentation of photos with options for slideshows, navigation buttons, and auto play. Pikachoose is designed to be easily installed, easy to setup, and well… all around easy. Creating an image gallery shouldn’t be a complex thing. I’ve created a new plugin that I’m packaging with PikaChoose called SliderJS.

View Demo

28. jQuery Image Overlay Plugin

The image overlay plugin is a simple jQuery plugin that attempts to present an image with an overlaid title/caption. The overlay drops in on hover, as you can see above.

View Demo

29. imgAreaSelect

imgAreaSelect is a jQuery plugin for selecting a rectangular area of an image. It allows web developers to easily implement image cropping functionality, as well as other user interface features, such as photo notes (like those on Flickr).
Plugin features:

Highly configurable
Customizable with CSS styling
Handles scaled images
Keyboard support for moving and resizing the selection
Supports callback functions
Provides API functions for easier integration with other application components
Lightweight — the packed version is less than 8KB

View Demo

30. PFeloader

This is a preloader, it scans DOM and loaded StyleSheet’s for occurence of images (in sheet, style, as element).
StyleSheet file has to be in the same domain as page using it.

View Demo

30.1. jQuery Horizontal Image Scroller w/ Lightbox

This is a jQuery image scroller with lightbox. The scroll bar/indexes and directional buttons allow for easy navigation of your image gallery. Image click can either open the included lightbox or a regular link. The scroller is also re-sizable and fully configurable through the plugin’s parameters.

View Demo

31. Image Reveal using jQuery

View Demo

32. The jQuery Cycle Plugin

The jQuery Cycle Plugin is a lightweight slideshow plugin. It supports pause-on-hover, auto-stop, auto-fit, before/after callbacks, click triggers and many transition effects. It also supports, but does not require, the Metadata Plugin and the Easing Plugin.

View Demo

33. Galleria Plugin

This demonstration shows you aome more advanced effects you can accomplish with the Galleria plugin. The history object is also active, so feel free to try the back button in your browser and bookmark a page. The next and previous links are simple to create since the galleria object has two public functions for traversing the images in your list.

View Demo

34. CrossSlide jQuery plugin

CrossSlide is a jQuery plugin that implements in Javascript some common slide-show animations, traditionally only available to the web developer via Adobe Flash™ or other proprietary plugins. CrossSlide builds upon jQuery’s animation facility, so it is as portable across browsers as jQuery itself (a lot.)

View Demo

35. Fancy Thumbnail Hover Effect w/ jQuery

View Demo

36. Apple-like Slideshow Gallery

View Demo

36.1. li JQuery Slider/Image Rotator

li jQuery Image Slider / Banner Image Rotator is carefully crafted slider/image rotator, full of features, very easy to install and customize. Whenever you need a full featured slider image rotator or you need a simple ad banner, li jQuery Image slider will do the job with ease!
This robust and yet elegant guy, has everything you need to build your next “to-impress” image slider.

View Demo

37. JQZoom

JQZoom is a javascript image magnifier built at the top of the popular jQuery javascript framework.jQzoom is a great and a really easy to use script to magnify what you want.

View Demo

38. ImageFlow

ImageFlow is an unobtrusive and userfriendly JavaScript image gallery.

View Demo

MySQL BIT in PHP

noreply@blogger.com (DOM) — Tue, 27 Sep 2011 05:57:10 PDT

MySQL BIT in PHP

Ok, if you subscribe to my blog for personal reasons, this isn’t very relevant to you, but for those of you here for the programming, on a recent project I had some problems getting the BIT field in MySQL to be interpreted as a boolean in PHP. There are a couple of discussions on the net about it here and here, but I couldn’t find any simply stated solutions on the net. So here’s what I ended up doing. You can also download the file here, rename the file .php to use it.



function mysql_bit($bit) {

return ord($bit) == 1;

}

If you found any of the software useful, please consider supporting its further developement by donating.

Convert existing MySQL database from one charset encoding to another

noreply@blogger.com (DOM) — Wed, 13 Jul 2011 16:30:15 PDT

Convert existing MySQL database from one charset encoding to another

Warning: Always make backups.

Convert existing MySQL database from one charset encoding to another

ALTER DATABASE db_name DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

Convert existing table from one charset encoding to another

ALTER TABLE db_table CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

MYSQL UNICODE

noreply@blogger.com (DOM) — Sat, 02 Jul 2011 04:08:34 PDT

Character set= utf8 -- UTF-8 Unicode
Collation=utf8_bin

PHP calculate the difference in time between a past date and a future date

noreply@blogger.com (DOM) — Mon, 13 Jun 2011 20:16:51 PDT

 function nicetime($date)

{

    if(empty($date)) {

        return "No date provided";

    }

    

    $periods         = array("second", "minute", "hour", "day", "week", "month", "year", "decade");

    $lengths         = array("60","60","24","7","4.35","12","10");

    

    $now             = time();

    $unix_date         = strtotime($date);

    

       // check validity of date

    if(empty($unix_date)) {    

        return "Bad date";

    }



    // is it future date or past date

    if($now > $unix_date) {    

        $difference     = $now - $unix_date;

        $tense         = "ago";

        

    } else {

        $difference     = $unix_date - $now;

        $tense         = "from now";

    }

    

    for($j = 0; $difference >= $lengths[$j] && $j < count($lengths)-1; $j++) {

        $difference /= $lengths[$j];

    }

    

    $difference = round($difference);

    

    if($difference != 1) {

        $periods[$j].= "s";

    }

    

    return "$difference $periods[$j] {$tense}";

}



$date = "2009-03-04 17:45";

$result = nicetime($date); // 2 days ago



?>

Date Function Formatting of PHP

noreply@blogger.com (DOM) — Mon, 13 Jun 2011 18:12:41 PDT

DAYS
d - day of the month 2 digits (01-31)
j - day of the month (1-31)
D - 3 letter day (Mon - Sun)
l - full name of day (Monday - Sunday)
N - 1=Monday, 2=Tuesday, etc (1-7)
S - suffix for date (st, nd, rd)
w - 0=Sunday, 1=Monday (0-6)
z - day of the year (1=365)
WEEK
W - week of the year (1-52)
MONTH
F - Full name of month (January - December)
m - 2 digit month number (01-12)
n - month number (1-12)
M - 3 letter month (Jan - Dec)
t - Days in the month (28-31)
YEAR
L - leap year (0 no, 1 yes)
o - ISO-8601 year number (Ex. 1979, 2006)
Y - four digit year (Ex. 1979, 2006)
y - two digit year (Ex. 79, 06)
TIME
a - am or pm
A - AM or PM
B - Swatch Internet time (000 - 999)
g - 12 hour (1-12)
G - 24 hour c (0-23)
h - 2 digit 12 hour (01-12)
H - 2 digit 24 hour (00-23)
i - 2 digit minutes (00-59)
s 0 2 digit seconds (00-59)
OTHER
e - timezone (Ex: GMT, CST)
I - daylight savings (1=yes, 0=no)
O - offset GMT (Ex: 0200)
Z - offset in seconds (-43200 - 43200)
r - full RFC 2822 formatted date

Set unicode database for sqlserver

noreply@blogger.com (DOM) — Sun, 05 Jun 2011 04:14:13 PDT

Right click database--> Property-->Option-->Collation: Corsican_100_BIN2

Database field: Chose NVARCHAR

by cno

SQL to Select a random row from a database table

noreply@blogger.com (DOM) — Sun, 08 May 2011 07:05:51 PDT

There are lots of ways to select a random record or row from a database table. Here are some example SQL statements that don't require additional application logic, but each database server requires different SQL syntax.

Select a random row with MySQL:

SELECT column FROM table
ORDER BY RAND()
LIMIT 1

Select a random row with PostgreSQL:

SELECT column FROM table
ORDER BY RANDOM()
LIMIT 1

Select a random row with Microsoft SQL Server:

SELECT TOP 1 column FROM table
ORDER BY NEWID()

Select a random row with IBM DB2

SELECT column, RAND() as IDX 
FROM table 
ORDER BY IDX FETCH FIRST 1 ROWS ONLY

Thanks Tim

Select a random record with Oracle:

SELECT column FROM
( SELECT column FROM table
ORDER BY dbms_random.value )
WHERE rownum = 1

Guide:How to connect CentOS to internet (Bridge connection)

noreply@blogger.com (DOM) — Sat, 30 Apr 2011 02:39:15 PDT

This simple guide is for those who cant still connect their CentOS to internet using a router. I'm using "Bridge" connection.

1. Disable first VMware network adapter (right click then click disable).

2.. Right click your Local Area Connection, click properties then tick or enable VMware bridge protocol. click OK

3.Open your Vmware Workstation then change Ethernet to "Bridge".

Click "start this virtual machine".
Login as " root ".

4. (CentOS) Go to System,Administration,Network.
Click DNS tab then check if you have Primary/Secondary DNS & DNS search path filled.

If those are blank then go to you Windows click Start,Run type cmd click ok then on DOS windows type "ipconfig /all"

Save. then try to browse internet. If doesnt work restart CentOS.

Note: If you want to set Centos IP static, the same as the pattern of you windows IP address click Devices then click etho (make sure it is active) then
click edit, click or tick "Statically set IP addresses" then fill in.

Ex. if your Windows ip is 192.168.0.101 then type 192.168.0.102 or (other IP which is not yet assigned by your router to other computer in your network.)
then just copy your Windows Subnet mask and Default gateway.
Click ok then save and try to browse internet, if doesnt work restart CentOS.

Using SQLCMD to Execute Multiple SQL Server Scripts

noreply@blogger.com (DOM) — Tue, 22 Feb 2011 18:50:51 PST

In the root C:\ folder, I create a file called create_db.bat which I use to create the database with all objects

SQLCMD -E -ddatabasename -ic:\SQL\CMS_Avatar.sql
PAUSE

Double clicking the .bat file, I see that each script processed and that the database created successfully.

Chat MSN Emoticons

noreply@blogger.com (DOM) — Mon, 14 Feb 2011 18:48:29 PST

Emoticons

Use emoticons when you're messaging with friends to show them how you really feel. Emoticons are emotional graphics--visual ways to express the way you feel when words alone just aren't enough. Try out all of the Messenger emoticons:

To send this:		Type this:
	Smile	:-) or :)	Open-mouthed	:-D or :d
	Surprised	:-O or :o	Tongue out	:-P or :p
	Wink	;-) or ;)	Sad	:-( or :(
	Confused	:-S or :s	Disappointed	:-\| or :\|
	Crying	:'(	Embarrassed	:-$ or :$
	Hot	(H) or (h)	Angry	:-@ or :@
	Angel	(A) or (a)	Devil	(6)
	Don't tell anyone	:-#	Baring teeth	8o\|
	Nerd	8-\|	Sarcastic	^o)
	Secret telling	:-*	Sick	+o(
	I don't know	:^)	Thinking	*-)
	Party	<:o)	Eye-rolling	8-)
	Sleepy	\|-)	Coffee cup	(C) or (c)
	Thumbs up	(Y) or (y)	Thumbs down	(N) or (n)
	Beer mug	(B) or (b)	Martini glass	(D) or (d)
	Girl	(X) or (x)	Boy	(Z) or (z)
	Left hug	({)	Right hug	(})
	Vampire bat	:-[ or :[	Birthday cake	(^)
	Red heart	(L) or (l)	Broken heart	(U) or (u)
	Red lips	(K) or (k)	Gift with a bow	(G) or (g)
	Red rose	(F) or (f)	Wilted rose	(W) or (w)
	Camera	(P) or (p)	Filmstrip	(~)
	Cat face	(@)	Dog face	(&)
	Telephone receiver	(T) or (t)	Light bulb	(I) or (i)
	Note	(8)	Sleeping half-moon	(S)
	Star	(*)	E-mail	(E) or (e)
	Clock	(O) or (o)	MSN Messenger icon	(M) or (m)
	Snail	(sn)	Black Sheep	(bah)
	Plate	(pl)	Bowl	(\|\|)
	Pizza	(pi)	Soccer ball	(so)
	Auto	(au)	Airplane	(ap)
	Umbrella	(um)	Island with a palm tree	(ip)
	Computer	(co)	Mobile Phone	(mp)
	Stormy cloud	(st)	Lightning	(li)
	Money	(mo)

Google Talk Hidden Emoticons

noreply@blogger.com (DOM) — Mon, 14 Feb 2011 18:36:49 PST

http://mail.google.com/mail/e/350 –
http://mail.google.com/mail/e/351 –
http://mail.google.com/mail/e/352 –
And the list goes on …
Here’s a list of utterly new emoticons/smileys:

Classic	Round	Square	Type this
Cowbell	Cowbell	Cowbell	+/’\
Crab	Crab	Crab	V.v.V
Devil	Devil	Devil	}:-)
Equal sad	Equal sad	Equal sad	=(
Equal slant	Equal slant	Equal slant	=/
Equal tongue	Equal tongue	Equal tongue	=P
Nose sad	Nose sad	Nose sad	:-(
Smile	Smile	Smile	:)
Wince	Wince	Wince	>.<
Nose tongue	Nose tongue	Nose tongue	:-P

Pig	Pig	Pig	:(:)
Broken Heart	Broken Heart	Broken Heart
Kiss	Kiss	Kiss	:-x
Kiss	Kiss	Kiss	:*
Mustache	Mustache	Mustache	:{

Beneath are emoticons from my previous post. For reference I am again displaying them here.

Classic	Round	Square	Type this
Heart/Love	Heart/Love	Heart/Love	<3
It’s a monkey!	It’s a monkey!	It’s a monkey!	:(\|)
Rock out.	Rock out.	Rock out.	\m/
Shocked	Shocked	Shocked	:-o
Grin	Grin	Grin	:D
Frown	Frown	Frown	:(
Angry	Angry	Angry	x-(
Cool	Cool	Cool	B-)
Cry	Cry	Cry	:’(
Equal Grin	Equal Grin	Equal Grin	=D
Wink	Wink	Wink	;)
Straight Face	Straight Face	Straight Face	:-\|
Equal Smile	Equal Smile	Equal Smile	=)
Nose Grin	Nose Grin	Nose Grin	:-D
Big nose wink	Big nose wink	Big nose wink	;^)
Nose wink	Nose wink	Nose wink	;-)
Nose smile	Nose smile	Nose smile	:-)
Slant	Slant	Slant	:-/
Tongue	Tongue	Tongue	:P

Yahoo chat emotion icon

noreply@blogger.com (DOM) — Mon, 14 Feb 2011 18:49:09 PST

	`:)`	happy
	`:(`	sad
	`;)`	winking
	`:D`	big grin
	`;;)`	batting eyelashes
	`>:D<`	big hug
	`:-/`	confused
	`:x`	love struck
	`:">`	blushing
	`:P`	tongue
	`:-*`	kiss
	`=((`	broken heart
	`:-O`	surprise
	`X(`	angry
	`:>`	smug
	`B-)`	cool
	`:-S`	worried
	`#:-S`	whew!
	`>:)`	devil
	`:((`	crying
	`:))`	laughing

	`:\|`	straight face
	`/:)`	raised eyebrows
	`=))`	rolling on the floor
	`O:-)`	angel
	`:-B`	nerd
	`=;`	talk to the hand
	`:-c`	call me
	`:)]`	on the phone
	`~X(`	at wits' end
	`:-h`	wave
	`:-t`	time out
	`8->`	day dreaming
	`I-)`	sleepy
	`8-\|`	rolling eyes
	`L-)`	loser
	`:-&`	sick
	`:-$`	don't tell anyone
	`[-(`	no talking
	`:O)`	clown
	`8-}`	silly
	`<:-P`	party

	`(:\|`	yawn
	`=P~`	drooling
	`:-?`	thinking
	`#-o`	d'oh
	`=D>`	applause
	`:-SS`	nail biting
	`@-)`	hypnotized
	`:^o`	liar
	`:-w`	waiting
	`:-<`	sigh
	`>:P`	phbbbbt
	`<):)`	cowboy
	`X_X`	I don't want to see
	`:!!`	hurry up!
	`\m/`	rock on!
	`:-q`	thumbs down
	`:-bd`	thumbs up
	`^#(^`	it wasn't me
	`:ar!`	pirate*

	`:o3`	puppy dog eyes
	`:-??`	I don't know
	`%-(`	not listening
	`:@)`	pig
	`3:-O`	cow
	`:(\|)`	monkey
	`~:>`	chicken
	`@};-`	rose
	`%%-`	good luck
	`**==`	flag
	`(~~)`	pumpkin
	`~O)`	coffee
	`*-:)`	idea

	`8-X`	skull
	`=:)`	bug
	`>-)`	alien
	`:-L`	frustrated
	`[-O<`	praying
	`$-)`	money eyes
	`:-"`	whistling
	`b-(`	feeling beat up
	`:)>-`	peace sign
	`[-X`	shame on you
	`\:D/`	dancing

	`>:/`	bring it on
	`;))`	hee hee
	`:-@`	chatterbox
	`^:)^`	not worthy
	`:-j`	oh go on
	`(*)`	star
	`o->`	hiro
	`o=>`	billy
	`o-+`	april
	`(%)`	yin yang
	`:bz`	bee
	`[..]`	transformer*

Facebook smileys - chat emotions

noreply@blogger.com (DOM) — Sun, 13 Feb 2011 19:43:42 PST

Facebook smile emotion
:) or :-)

Facebook grin emotion
:D or :-D

Facebook wink emotion
;) or ;-)

Facebook happy eyes emotion
^_^

Facebook laughing eyes emotion
>:o

Facebook cat smile emotion
:3

Facebook grumpy emotion
>:-(

Facebook sad emotion
:( or :-(

Facebook crying emotion
:'(

Facebook shocked emotion
:o or :-o

Facebook glasses emotion
8) or 8-) or B)

Facebook cool shades emotion
8-|

Facebook tongue out emotion
:p or :-p

Facebook woot emotion
O.o

Facebook closed eyes emotion
-_-

Facebook worried emotion
:/ or :

Facebook devil emotion
3:)

Facebook angel emotion
O:)

Facebook kiss emotion
:-* or :*

Facebook heart emotion
<3

Facebook Pac Man emotion
:v

Facebook robot emotion
:|]

Facebook face emotion
:putnam:

Facebook shark emotion (recently added thanks to Holly's comment below) - NEW!
(^^^)

Facebook penguin emotion - NEW!
<(")

Facebook 42 emotion - NEW!
:42:

Skype-emotion icon

noreply@blogger.com (DOM) — Sun, 13 Feb 2011 19:42:07 PST

Finger (finger)

Bandit (bandit)

Drunk (drunk)

Smoking (smoking)(smoke)(ci)

Toivo (toivo)

Rock (rock)

Headbang (headbang)(banghead)

Bug (bug)

Fubar (fubar)

Poolparty (poolparty)

Swearing (swear)

TMI (tmi)

Heidy (heidy)

Mooning (mooning)

Get only file name in OpenFileDialog VB.NET

noreply@blogger.com (DOM) — Sun, 30 Jan 2011 05:27:59 PST

Imports system.IO
Path.GetFileName(fullpath)
VB.NET

Subtract month in .NET

noreply@blogger.com (DOM) — Tue, 18 Jan 2011 20:21:30 PST

Dim dt As DateTime = Date.Today
dt = dt.AddMonths(-2)

Dim x As String = dt.ToString()