MySQL Charset Setup

I found very confusing settings for right charset with MySQL server.

For PHP, first Query should be:

mysql_query("SET NAMES 'utf8' COLLATE 'utf8_unicode_ci';",$connect);

SEO - Keywords Finder

1. Find right keywords:
http://tools.seobook.com/keyword-tools/seobook/

2. Check keywords of your competitiors:
http://seodigger.com/

3. Competing keywords and pages:
http://tools.seobook.com/general/keyword-information/

4. Deep: keyword density & prominence:
http://www.ranks.nl/cgi-bin/ranksnl/spider/spider.cgi?lang=


Freeware Windows Maintanace

Advanced WindowsCare Personal 100% Freeware

A Click A Day For Computer Repair, Protection & Optimization. This comprehensive PC-care utility has a one-click approach. Advanced WindowsCare Personal helps protect, optimize, clean, and repair your computer and Registry –– with daily use. 

IObit SmartDefrag 100% Freeware

The Fastest, Most Efficient Defragmenter. It’s free. It’s fast. It’s IObit SmartDefrag. It works automatically and quietly in the background on your PC to keep your hard disk running at maximum speed. 

http://www.iobit.com/


.htaccess 301, 404


SEO - basic web tools

Webmasters tools for submitting sitemaps:

YAHOO: https://siteexplorer.search.yahoo.com/mysites

GOOLGE: https://www.google.com/webmasters/tools/siteoverview

MSN/LIVE: http://search.msn.co.uk/docs/submit.aspx

Sitemap generator:

http://www.xml-sitemaps.com/

Sitemap hint in robots.txt:

Sitemap: http://www.example.com/sitemap.xml
User-agent: *
Disallow: /cgi-bin/
Disallow: /images/

Ping sitemap changes:

ASK: http://submissions.ask.com/ping?sitemap=[URLENCODED]

Google: http://www.google.com/webmasters/sitemaps/ping?sitemap=[URLENCODED]

Yahoo: http://search.yahooapis.com/SiteExplorerService/V1/ping?sitemap=[URLENCODED]

i.e. http%3A%2F%2Fwww.makads.com%2Fsitemap.xml


CSS layout sources

There are  couple of layouts that is easy to modify.

3 column :

PIXY: http://www.pixy.cz/blogg/clanky/css-3col-layout/

Different sources with notes and compatibility

http://www.saila.com/usage/layouts/

 Free XHTML/CSS templates

CSS Creator

 Tutorial CSS floats

List of a lot of CSS sources and templates


You Must Have Perian for QuickTime - MacOS X

Perian is a free, open source QuickTime component that adds native support for many popular video formats.

What I like is I can use internal movie player (AppleTV style) with comfort of remote controller  and paly all XVID/DIVX movies ;-)

Very nice. Swiss Army Knife for QuickTime 


Handle large files: Freeware multi-platform file splitters

I have tried a couple of programs but this one works on large files (10 Gb and more). There are version for join for Linux, Mac even PHP. 

http://www.freebyte.com/hjsplit/


Extend Size of Virtual HD in VMware

I need to extend my virtual Windows HD from 2GB to 4GB.

1. in terminal type (NOTE: HD must be clear from snapshots - delete them from menu: Virtual Machine > Discard Snapshot )

sudo /Library/Application\ Support/VMware\ Fusion/vmware-vdiskmanager -x 4Gb [DON'T PRESS ENTER]

2.  drag and drop into terminal your virtual HD (in your Documents : Virtual Machines : YOUR_VM and Show Package)

/Users/Albert/Documents/Virtual\ Machines/Windows\ XP\ Professional\ copy.vmwarevm/Windows\ XP\ Professional.vmdk

3.  RUN long command

4. when it is finished, You have to change permition back to you just in file Windows\ XP\ Professional.vmdk

5. run Virtual Windows (VM shows 4Gb but disk c: shows still 2Gb) - we need to expand parttion:

6. in windows run command: diskpart.exe

7.  Type list volume to display the existing volumes on the computer.

8. Type Select volume # where # is number of the volume that you want to extend. 

9. Type extend size=2000 where 2000 is extended size in MB.

that's it! enjoy Cool

 

Panorama pages

Stiching, SW Tools: 

SmartBlend - http://smartblend.panotools.info/

Panotools (active and VOF no limit!)  -  http://photocreations.ca/panotools/index.html

Dersch - PanoTools 2.6 (old copy) - http://www.all-in-one.ee/%7edersch/

Blending Tests using PTGui - Enblend - Smartblend and the new Photoshop CS3 Auto-Blend 

STITCHING AND AUTHORING PANORAMAS  

download - http://webuser.fh-furtwangen.de/~dersch/  

Viewers:

Flash panorama FAST, Full screen!! - http://flashpanoramas.com