Showing posts with label Tutorials. Show all posts
Showing posts with label Tutorials. Show all posts

Monday, 27 August 2012

Lock folder without any software in winXp




Suppose you want to lock the folder movies in d: which has the path D:\movies.In the same drive create a text file and type


ren movies movies.{21EC2020-3AEA-1069-A2DD-08002B30309D}
Now save this text file as lock.bat


Create another text file and type in it


ren movies.{21EC2020-3AEA-1069-A2DD-08002B30309D} movies
Now save this text file as unlock.bat

Wednesday, 22 August 2012

Tutorial of Bit Torrent


The first things you need to know about using Bit Torrent:
-- Bit Torrent is aimed at broadband users (or any connection better than dialup).
-- Sharing is highly appreciated, and sharing is what keeps bit torrent alive.
-- A bit torrent file (*.torrent) contains information about the piece structure of the download (more on this later)
-- The method of downloading is not your conventional type of download. Since downloads do not come in as one
big chunk, you are able to download from many people at once, increasing your download speeds. There may be
100 "pieces" to a file, or 20,000+ pieces, all depending on what you're downloading. Pieces are usually small (under 200kb)
-- The speeds are based upon people sharing as they download, and seeders. Seeders are people who constantly
share in order to keep torrents alive. Usually seeders are on fast connections (10mb or higher).

In this tutorial, I will be describing it all using a bit torrent client called Azureus. This client is used to decode the .torrent files into a useable format to download from other peers. From here on out, I will refer to Bit Torrent as BT.

Which BT client you use, is purely up to you. I have tried them all, and my personal favorite is Azureus for many reasons. A big problem with most BT clients out there, is that they are extremely CPU intensive, usually using 100% of your cpu power during the whole process. This is the number one reason I use Azureus. Another, is a recently released plug-in that enables you to browse all current files listed on suprnova.org (the #1 source for torrent downloads).

Before you use the plug-in, take a look at /http://www.suprnova.org, and browse the files. Hold your mouse over the links, and you'll notice every file ends in .torrent. This is the BT file extension. Usually, .torrent files are very small, under 200kb. They contain a wealth of information about the file you want to download. A .torrent file can contain just 1 single file, or a a directory full of files and more directories. But regardless, every download is split up into hundreds or thousands of pieces. The pieces make it much easier to download at higher speeds. Back to suprnova.org. Look at the columns:

Added | Name | Filesize | Seeds | DLs (and a few more which aren't very useful.)

I'll break this down.
Added: Self explanitory, its the date the torrent was added.
Name: Also self explanitory.
Filesize: Duh
Seeds: This is how many people are strictly UPLOADING, or sharing. These people are the ones that keep .torrent files alive. By "alive", I mean, if there's no one sharing the .torrent file, no one can download.
DLs: This is how many people currently downloading that particular torrent. They also help keep the torrent alive as they share while they download.

It's always best to download using a torrent that has a decent amount of seeders and downloaders, this way you can be assured there's a good chance your download will finish. The more the better.

Now that you should understand how torrent files work, and how to use them, on to Azureus!
First, get JAVA! You need this to run Azureus, as java is what powers it. Get Java here: /http://java.sun.com/j2se/1.4.2/download.html
Next, get Azureus at: /http://azureus.sourceforge.net
Next, get the Suprnovalister plugin from /http://s93732957.onlinehome.us/storage/suprnovalister.jar

Install Java JRE before you do ANYTHING.

Install Azureus, and then in the installation folder, create 2 more folders. ./Plugins/suprnovalister (For example, if you installed Azureus to C:\PROGRAM FILES\AZUREUS, create C:\PROGRAM FILES\AZUREUS\PLUGINS\SUPRNOVALISTER). Next, put the suprnovalister.jar file that you downloaded, in that folder.

Load up Azureus, and if you want, go through the settings and personalize it.

The tab labeled "My Torrents" is the section of Azureus you need the most often. That lists all your transfers, uploads and downloads. It shows every bit of information you could possibly want to know about torrents you download.

In the menu bar, go to View > Plugins > Suprnova Lister. This will open up a new tab in Azureus. Click on "Update Mirror". This will get a mirror site of suprnova.org containing all current torrent files available. Once a mirror is grabbed, choose a category from the drop-down box to the left and click "Update". Wah-lah, all the available downloads appear in the main chart above. Just double click a download you want, and bang its starting to download. Open the "My Torrents" tab again to view and make sure your download started.

After your download has finished, be nice, and leave the torrent transferring. So people can get pieces of the file from you, just as you got pieces from other people.

Alternatively, if you don't want to use the plugin... you can just head to suprnova.org and download files to any folder. Then go to File > Open > .torrent File in Azureus.

This should about wrap it up for the Bit Torrent Tutorial. If you guys think of anything I should add, or whatnot, just let me know and I'll check into it.

Tuesday, 21 August 2012

MySql Queries

MySql Queries
There are two parts of Mysql Database, which are used to create complete database. Database is using many platforms like in website, software etc


  1. Data Manipulation Language.
  2. Data defination Language.

  1. Data Manipulation Language(DML):
Create table Student
(SID                     NUMBER ,
NAME                CHAR(20)          NOT NULL,
ADDRESS           VARCHAR(50),
CONSTRAINT   MY1          PRIMARY KEY (SID));

ALTER TABLE STUDENT
DROP        CONSTRAINT             MY1;

ALTER TABLE STUDENT
ADD          CONSTRAINT   MY1          PRIMARY KEY  (SID);


ALTER TABLE STUDENT
ADD          CITY           CHAR(10);

INSERT     INTO         STUDENT (SID, NAME)
VALUES(2, “ADEEL”);


CREATE TABLE          COURSE
(CC             CHAR(6),
TITLE         CHAR(20),
CREDITS   NUMBER,
CONSTRAINT             COURSEPK                 PRIMARY KEY  (CC));

CREATE TABLE          REGISTER
(SID           NUMBER,
COURSE             CHAR(10),
DOR                    DATE,
CONSTRAINT   REGFK1    FOREIGN              KEY (SID)       
REFERENCES   STUDENT,
CONSTRAINT   REGFK2    FOREIGN KEY (COURSE) REFERENCES COURSE);

    2. Data defination Language:

SELECT * FROM TABLE_NAME WHERE ID=4;

INSERT INTO table_name
VALUES (value1, value2, value3,...)

How to Build a Database with MS Access


my access database
Building a database with MS Access is not difficult, but it can be confusing. In order to build a working database, you must create the database file as well as a table to enter your information. By creating each item one at a time, you will be ready to enter your data within the hour.

Instructions
1.  Building the Database in MS Access
  • Open MS Access. A box will pop up giving you options. Choose the radio button next to "Blank Access Database." Click "OK."
  • Save your database. A file box will pop up asking you for a file name. Make sure you are saving your database in the location you wish, such as "My Documents."
  • Type your file name, and click "Create." You will now see your database window open within the Access program.




  1. 2. Creating a Table Within Your Access Database:
Create a table for your data. The easiest way is to choose "Create Table in Design View." You will see this within your database window. Double-click on this choice to open.


o    2. Define the fields you need for your data. Think of the information you need in your database. Are you creating a mailing list? Then the first field you need to define would be "Name." Type "Name" under the field name column.
o    3. Tab over to the Data Type column. Most data you will be entering will be text. That should be the default you are seeing. If so, and you do not want to change it, tab over to Description column. Type a description of the field, such as "Customer's name."
o    4. Push the tab key again to return to the Field Name column. Type the name of the next field you need. If you are making a mailing list, then the next field you would need would be "Street Address." Tab over and continue creating your table in the same way until all the fields you need are included. If making a mailing list, then possible fields would be Name, Street Address, City, State and Zip Code. You may also want to add fields such as "Phone Number."
o    5. Choose a Primary Key for your table. This is for the search function of the program. This can be a customer number or the customer name. It's usually the first field in the table. Click on "Customer Name" in the Field Name column. You should see an arrow to the left of the row. Look at the toolbar at the top of the screen. Find an icon of a yellow key. Click that picture. You have just made "Customer Name" your primary key.
o    6. Save your table. Your table will automatically ask you to save when you close it. Click on the "X" on the top right of your table. When you are asked if you want to save the table, say "Yes". A box will come up asking you to name your table. Name your table, and click "OK."
3.  3. Adding Data to Your Access Database
o    1. Open your table and enter data. You will now be back at your main Access screen where you will see your database window open. You will see your table in this window listed by name. Now you can start entering data. To open your table, double-click on its icon.
o    2. Enter your data. Starting at "Customer Name," begin entering the data from your current mailing list. After the entry in each column, tab over until you have entered all of the information for that person. As you complete each row, another row will automatically be added below the selected row.
o    3. Finish working, and close the program. To finish working in the table, click the "X" on the right side of the table. It will automatically save. To close the database window, click "X" on the right side of the database window. To close the program, click "X" on the upper right of the screen. Your database is finished. You can add more data to the table whenever it's needed. You can also go back to design view and add more fields if needed.

Monday, 20 August 2012

Keyboard Shortcuts


Keyboard shorcuts
Getting used to using your keyboard exclusively and leaving your mouse behind will make you much more efficient at performing any task on any Windows system. I use the following keyboard shortcuts every day:

Windows key + R = Run menu

This is usually followed by:
cmd = Command Prompt
iexplore + "web address" = Internet Explorer
compmgmt.msc = Computer Management
dhcpmgmt.msc = DHCP Management
dnsmgmt.msc = DNS Management
services.msc = Services
eventvwr = Event Viewer
dsa.msc = Active Directory Users and Computers
dssite.msc = Active Directory Sites and Services
Windows key + E = Explorer

ALT + Tab = Switch between windows

ALT, Space, X = Maximize window

CTRL + Shift + Esc = Task Manager

Windows key + Break = System properties

Windows key + F = Search

Windows key + D = Hide/Display all windows

CTRL + C = copy

CTRL + X = cut

CTRL + V = paste

Also don't forget about the "Right-click" key next to the right Windows key on your keyboard. Using the arrows and that key can get just about anything done once you've opened up any program.


Keyboard Shortcuts

[Alt] and [Esc] Switch between running applications

[Alt] and letter Select menu item by underlined letter

[Ctrl] and [Esc] Open Program Menu

[Ctrl] and [F4] Close active document or group windows (does not work with some applications)

[Alt] and [F4] Quit active application or close current window

[Alt] and [-] Open Control menu for active document

Ctrl] Lft., Rt. arrow Move cursor forward or back one word

Ctrl] Up, Down arrow Move cursor forward or back one paragraph

[F1] Open Help for active application

Windows+M Minimize all open windows

Shift+Windows+M Undo minimize all open windows

Windows+F1 Open Windows Help

Windows+Tab Cycle through the Taskbar buttons

Windows+Break Open the System Properties dialog box



acessability shortcuts

Right SHIFT for eight seconds........ Switch FilterKeys on and off.

Left ALT +left SHIFT +PRINT SCREEN....... Switch High Contrast on and off.

Left ALT +left SHIFT +NUM LOCK....... Switch MouseKeys on and off.

SHIFT....... five times Switch StickyKeys on and off.

NUM LOCK...... for five seconds Switch ToggleKeys on and off.

explorer shortcuts

END....... Display the bottom of the active window.

HOME....... Display the top of the active window.

NUM LOCK+ASTERISK....... on numeric keypad (*) Display all subfolders under the selected folder.

NUM LOCK+PLUS SIGN....... on numeric keypad (+) Display the contents of the selected folder.

NUM LOCK+MINUS SIGN....... on numeric keypad (-) Collapse the selected folder.

LEFT ARROW...... Collapse current selection if it's expanded, or select parent folder.

RIGHT ARROW....... Display current selection if it's collapsed, or select first subfolder.




Type the following commands in your Run Box (Windows Key + R) or Start Run

devmgmt.msc = Device Manager
msinfo32 = System Information
cleanmgr = Disk Cleanup
ntbackup = Backup or Restore Wizard (Windows Backup Utility)
mmc = Microsoft Management Console
excel = Microsoft Excel (If Installed)
msaccess = Microsoft Access (If Installed)
powerpnt = Microsoft PowerPoint (If Installed)
winword = Microsoft Word (If Installed)
frontpg = Microsoft FrontPage (If Installed)
notepad = Notepad
wordpad = WordPad
calc = Calculator
msmsgs = Windows Messenger
mspaint = Microsoft Paint
wmplayer = Windows Media Player
rstrui = System Restore
netscp6 = Netscape 6.x
netscp = Netscape 7.x
netscape = Netscape 4.x
waol = America Online
control = Opens the Control Panel
control printers = Opens the Printers Dialog


internetbrowser

type in u're adress "google", then press [Right CTRL] and [Enter]
add www. and .com to word and go to it

Put a button in your webpage, so people will set your website as a homepage


  

<a href="#"onClick="this.style.behavior='url(#default#homepage)';this.setHomePage('http://punial.com');">Set as home Page</a>

How to Create Google adsense Account

Its very simple to earn money through Google adsense account. First of all design a website and purchase domain+hosting update the site.


  1. After updating website create a gmail account.
  2. Now read policies of google adsense and according to google adsense  policy update website.
  3. Upload daily posts on your website so visitors will visit daily your website. 
  4. Attract users by uploading fresh contents.
  5. Now apply for google adsense account by filling the application form on www.google.com/adsense
  6. After aplying to adsense now wait for review of website for two or three days.
  7. After completing review of website google adsense will sent message in gmail account.
  8. Now design ads and put code in your website content.
  9. Now you will start to earn money.

Basic steps to design Web site in Dreamweaver

To start designing website in dreamweaver you just install any version of Dreamweaver software in your Computer and click on the icon.


      1. Go to File in menu
  1. Then click on new
  2. Then click on Blank Page
  3. Now Again go to File and click on save as, type index.html
  4. Now set location oof file to save and click on save button
  5. Page is created and start designing in page and save it 
  6. Now run it in internet explorer