Installing and configuring DotnetNuke 7.0

Before we begin let’s see how your IIS is configured!!

Did you look at all those check/un-check things in the IIS it should be similar, or rather I say it should be same for sound working of DotNetNuke (DNN) 7.0 well because I had a tough time finding solution for my problem, watching several videos and landed up fiddling IIS settings so I just want you people to do the same in less time, or rather I don’t want you people to make the same mistakes which I did!!

Once you are done with the IIS Part you should Install SQL Server 2008 R2 or Express and its Management studio.

I have Installed SQL Server 2008 Express and its Management Studio!! No special configuration is required for SQL Server 2008, ya but you need a user with SQL Authentication! For the timing I am using my ‘sa’ user. I don’t mind you people doing the same! But it’s not a good practice.
 

Once you are done with the database Installation and configuration lets jump to downloading the files for DotNetNuke which will be used for our hosting, for downloading use this link
https://dotnetnuke.codeplex.com/downloads/get/671130
 

Once you are done with your download let’s begin the installation.

1.       Go to the zip file and extract it.

2.       No go to the extracted folder (say for DotNetNuke_Community_07.00.06_Deploy) open it now you will find another folder DotNetNuke inside that now copy the content of that folder.

3.       Go to some place where you would like to place your hosting files.

4.       Make a new folder named dnn or something you prefer.

5.       Now paste all the files which you have copied into that folder.

6.       Now open your Internet Information Service (IIS) Manager using shortcut ‘inetmgr’ (go to run and type it).

7.       Now create a virtual directory inside Default web site say for dnn with Alias and specify the Physical Path (this should be pointing to the folder something like x:\Bridewin\dnn).

8.       Now right click the same and click on convert to application, Now it should look like this

9.       Once you have done that go to that folder and specify the permission for the same.

10.   You need to give 2 users permission 1. IIS_IUSRS and 2. IUSR, as shown in the screenshot if you have ever hosted and configured a web application you will find this step a bit easy. In normal cases you don’t need IUSR but for DotNetNuke we need this.

11.   Great now we have done with the hosting part.

12.   Now for database! Open your SQL Server 2008 and create a database dotnetnuke, if you are in a lazy mood please use the attached script. Click here (http://rapidshare.com/files/4153866180/DotNetNuke_Create_Database.txt) to download.

13.   Once you have done with the database creation part, Open your browser and type http://localhost/dnn or whatever alias you have given.

14.   Now fill in the information as shown

15.   The username and password which you will be entering will be used as super user so make sure you remember the username and password.

16.   Enter the website name or leave it as it is! You can change it later.

17.   Template it’s better to keep as it is anyhow you can change it later on.

18.   Language will be the language which you prefer! In case if you are interested in localization you can change it to the preferred one!

19.   Now let’s go to the database part.

20.    Now as show above select custom.

21.   Select SQL Server/Express database

22.   Now in the server name key in the instance name if you have an Instance otherwise just keep the period as it is ’.’ and remove everything else.

23.   Enter dotnetnuke as Database Name.

24.   Now enter Database user name and password say for ‘sa’ as username and password ‘your password’.

25.   Now click on continue. If you did everything as I have mentioned above you will get a page with progress bar indicating the status of installation.

26.   Finally!! after reaching 100% you can view your website by clicking Visit Website.

That’s it now you can start adding/editing controls from the menu, it’s very simple Enjoy!

Wasn’t that very simple?? :P

Do mention your views, any suggestions or whatever you like to say do comment me I will surely reply back!!

A day Hacking and Cracking Office 2013

A day with Office 2013! It was a wonderful experience installing Office 2013 and taking a peek at its new sky drive facility! To be honest I am using a pirated version of Office 2013!

Installation was very smooth on my Windows 8 PC. Later on I found an activator or can be said as a crack which is to be used for activating the Office 2013. My fun turned to be misery when I realized that the crack is not working for me since I installed my office 2013 in my ‘G’ drive.

Whole of a sudden it was terror for me! Now what?!?! Should I get back to my previous version of Office or should I reinstall Office 2013 in my ‘C’ drive after uninstalling some application?!?!

Now at this point my Misery turned into fun guess what I thought of writing my own Crack for Office 2013 so that I can fix it once and for all! And why not share it with other peoples too who might be having same problem.

Slowly and slowly I started to look for loop hole and the way to hack Office 2013! Later by noon time I found some ways and wrote my own first Crack application for Office 2013 and voila it’s working!!!

You can find the source code for the same below:

Public Class Main #Region " Variable Declaration " Private Const _osppFile As String = "OSPP.VBS" Private Const _osppRearmFile As String = "OSPPREARM.EXE" #End Region #Region " Events Declaration " Private Sub Main_Load(sender As Object, e As EventArgs) Handles MyBase.Load Me.tbOffice15FolderPath.Text = Me.lDefaultOffice15.Text.Trim End Sub Private Sub bSelect_Click(sender As Object, e As EventArgs) Handles bSelect.Click Me.fbdOffice15.Description = "Office 15 Folder" Me.fbdOffice15.RootFolder = Environment.SpecialFolder.MyComputer If fbdOffice15.ShowDialog() = DialogResult.OK Then Me.tbOffice15FolderPath.Text = Me.fbdOffice15.SelectedPath Else Me.tbOffice15FolderPath.Text = Me.lDefaultOffice15.Text.Trim End If End Sub Private Sub bActivateOffice2013_Click(sender As Object, e As EventArgs) Handles bActivateOffice2013.Click Dim permission As PrincipalPermission Try permission = New PrincipalPermission(Nothing, "BUILTIN\Administrators", True) permission.Demand() Call Me.ActivateOffice2013() Catch ex As Exception MessageBox.Show(ex.Message, "Unhandled Exception") End Try End Sub #End Region #Region " Subroutine Declaration " Private Sub ActivateOffice2013() Dim exe As String Dim osppPath As String Dim osppRearmPath As String Dim status As String Dim remHst As String Dim rearm As String Dim act As String exe = "cmd" osppPath = "/c @cscript /nologo " & """" & Me.tbOffice15FolderPath.Text.Trim & "\" & Main._osppFile & """" osppRearmPath = "/c @cscript /nologo " & """" & Me.tbOffice15FolderPath.Text.Trim & "\" & Main._osppRearmFile & """" status = Me.ExecuteWithResult(exe, osppPath & " /dstatus") remHst = Me.ExecuteWithResult(exe, osppPath & " /remhst") Call Me.Execute(exe, osppPath & " /sethst:127.0.0.1") Call Me.Execute(exe, osppPath & " /setprt:1688") Call Me.Execute(exe, osppPath & " /inpkey:YC7DK-G2NP3-2QQC3-J6H88-GVGXT") rearm = Me.ExecuteWithResult(exe, osppRearmPath) act = Me.ExecuteWithResult(exe, osppPath & " /act") MessageBox.Show("Status: " & Environment.NewLine & status & Environment.NewLine & _ "Remove Host: " & Environment.NewLine & remHst & Environment.NewLine & _ "Rearm: " & rearm & Environment.NewLine & _ "Activation: " & act, "Result") End Sub Private Sub Execute(ByVal exe As String, ByVal param As String) Dim processStartInfo As ProcessStartInfo Dim process As Process processStartInfo = New ProcessStartInfo(exe, param) processStartInfo.RedirectStandardOutput = True processStartInfo.UseShellExecute = False processStartInfo.CreateNoWindow = True process = New Process process.StartInfo = processStartInfo process.Start() process.WaitForExit() process.StandardOutput.ReadToEnd() End Sub #End Region #Region " Function Declaration " Private Function ExecuteWithResult(ByVal exe As String, ByVal param As String) As String Dim text As String Dim processStartInfo As ProcessStartInfo Dim process As Process processStartInfo = New ProcessStartInfo(exe, param) processStartInfo.RedirectStandardOutput = True processStartInfo.UseShellExecute = False processStartInfo.CreateNoWindow = True process = New Process() process.StartInfo = processStartInfo process.Start() process.WaitForExit() text = process.StandardOutput.ReadToEnd() Return text End Function #End Region End Class

If you are interested in the EXE then please click here (from Rapidshare) to download the zip file and then extract it.

To use this crack you must be having KMS emulator or qemu running on your machine and then execute my crack. Everything will go fine!


This is how it should look when you run it!

 

Enjoy Office 2013 for free!

Sorry my post was down for some time due to Infringement Notification you know from whom! ;)

Please do not use this post for illegal purpose!

Change color of Visual Studio Text Editor

Change color of Visual Studio Text Editor

 

Every young developer likes to play around with the tools they use for development! Moreover we have always learned programming in Turbo C compiler which has a blue background. But Visual studio is altogether different! And what if you are a black hat? You must be liking Black background most of the time?

So want some change in visual studio text editor? Then follow bellow mentioned steps its plain and simple!

1.       Open Visual Studio (for me its Visual Studio 2010)

2.       Now Go to menu bar on top and select Tools - > Options - > Environment - > Fonts and Colors

3.       Now you must be getting a window similar to this!

4.       Now once you get this window try changing the Item foreground color to White and Item background color to Black Now for trial just click on Ok!

5.       Now you should be getting the background color and foreground color just as shown in bellow screen!

  6.       Now once you have mastered all the option you can simply try your own combination!

7.       Otherwise you can stick up to bellow mentioned combination

a.      Plain Text – White

b.      Line Numbers – Silver

c.       Comments  – 213,0,213 {R,G,B} (Purple)

d.      Identifier  – 253,223,57 {R,G,B}  (Mustard)

e.       Keyword  – 244,122,0 {R,G,B}  (Orange)

f.        Operator – White

g.      String – Lime

h.      User Types  – 179,179,0 {R,G,B}  (Mustardy)

Well! Hope that was satisfactory!

Reference:

MSDN - http://msdn.microsoft.com/en-us/library/ms165337.aspx

ASP .Net Web Handlers

ASP .Net Generic Handlers

Generic handlers are also called as web handlers. Just as ASPX files can be compiled on the fly (just-in-time), so can handlers. Generic handlers have an extension of ASHX. They contain classes that fully implement IHttpHandler. They're convenient in the same way ASPX files are convenient. You simply surf to them and they're compiled automatically.

Now you would probably have a question in your mind that “why should I use a generic handlers when I can do same thing using web service? “ Now if you know web service needs a consumer event or page to consume its output but in case of Generic Handler you do not need a consumer service. You just can browse through the page where IHttpHandler will do the rest of the work for you or maybe you are in a situation where you need output from something without calling any function, in such scenario web handlers are very handy!

So suppose you want to start using a web handler you can learn to use the same thing from here:

http://www.c-sharpcorner.com/UploadFile/prathore/ASHXfileHandler03272009023910AM/ASHXfileHandler.aspx

My point is to help people know things as easily as possible so I use copy paste since everything is available in internet! Ctrl+C and Ctrl+V the most prominent tool!

My main reason to come across Web handlers is due to auto complete feature in my project where I was not allowed to use Ajax since I work in a domain which is mainly linked to banking sector, where security and machine speed is considered at high end! In short there are lot of bankers who are very high profiled and they don’t have high configuration machine and they have requirement of security and high functional application with less trouble. So I was enforced to use Jquery.

Ah!! I was at auto complete. Now you must have seen in www.google.com when you type something you get the rest of the things coming up in text box! Ya that is auto complete. Now this one I got it from some site which seems to be worthy for me http://www.aspsnippets.com/Articles/Using-jQuery-AutoComplete-Plugin-in-ASP.Net.aspx try it out!

So Happy Learning!

How to develop an application from the Scratch?

Pre-requisite:

1. You should know to copy paste (Ctrl+C and Ctrl+V). This helps to increase your speed since there is no point in reinventing the wheels.
   
2. You should know OOPS .If you don't know OOPS refer to this section before proceeding further (http://www.codeproject.com/KB/architecture/OOP_Concepts_and_manymore.aspx). Now you must be knowing basics of OOPS and how to apply it.
   
3. Once you are done with OOPS you should know what is Three-Tier Architecture? If you don't know what is Three-Tier Architecture you can refer to this link http://www.codeproject.com/KB/architecture/three_tier_architecture.aspx .In today's world all application is build in Three-Tier and N-Tier architecture. So following this structure is most important since it reduces programming complexity and redundant coding as well as helps to maintain integrity and consistency.
   
4. Now if you want to Most Valued Professional then you should follow a Coding Standard. I have chosen a best coding standard specified by dotnetspider.com http://www.dotnetspider.com/tutorials/CodingStandards.doc here is it!
   
5. You must have noticed by this time that I am copy pasting most of the contents and links from most of the sites since this is available easily. So without explaining itself you should know how to search using search engine.
   
6. You should know how to create a database either in Ms Access, Ms SQL Server or Oracle.
   
7. You should have good knowledge of programming either .net or free sources such as Java.
   
8. As well as you should know how to use IDE such as Visual Studio or Eclipse or Net Beans.
   

Application Development

1. This is the simplest phase of a project. Once you have done with the Pre-requisite you would be having good knowledge about OOPS and programming so in no time or with less time you will be able to make an Application.
   
2. The first and most important thing you need to know is what you are going to develop. You should have a proper idea in your mind about how thing should flow.
   
3. The other important part if you are developing an application for a client you should cull out entire proper requirement from your client so that you can develop application efficiently if you have not done the same in Software Engineering Phase otherwise simply ignores this.
   
4. Now you must choose a language to use during software development. For my flexibility I am choosing C# .net so that I get most of the content easily available in internet as most of the developer stick with this. Remember Copy Paste!
   
5. Now you should make
   1. Database (Ms Access, SQL Server or Oracle)
      
   2. DAL (Data Access Layer)
      
   3. BAL (Business Access Layer) or BLL (Business Logic Layer)
      
   4. UI (User Interface)
      
   5. You can follow the same as shown in this sample project http://www.codeproject.com/KB/vb/N-Tier_Application_VB.aspx. Just follow this structure you will be able to reach proper end. Now in this DAL should be made first then BAL or BLL then UI. As per the sequence.
      
6. I hope you have used proper coding standards! Now your application would be able to run at most of the condition. Now slowly and slowly you can enhance your application if you have used proper coding standards as I have mentioned.
   

Code Enhancement:

1. When you go for a bigger application you should always make sure that you should not use stored procedure just to avoid SQL injection. Instead you can validate the same with the help of replace ' with '' and trim.
   For Eg.:
   
   String QueryString(String str)
   
   {
   
   Return Str.Replace("'","''").trim();
   
   }
   
   http://www.4guysfromrolla.com/webtech/061902-1.shtml as shown in this link you can make a Common.cs file (in case you are choosing C#) containing such validations in DAL.
   
2. Always remember you should not mix up programming logic with database logic. Always keep them at there on place.
   

There are several such tips for development which I will be explaining in my coming articles.

4G Technology Our Future....

We all are the prominent users of mobile technology. At present 2G Technology (GSM) is widely used worldwide. The problem with 2G technology is that the data rates are limited. This makes it inefficient for Data Transfer applications like video conferencing, music or video downloads, etc. To increase the speed various new technologies have come into picture. The first is 2.5G (GPRS) and second is 2.75G (EDGE) technologies that allows data transfer at a better rate than 2G and recently 3G (WCDMA/UMTS) technology has come into picture. The maximum theoretical data transfer with this 3G technology is 2Mbps (practically it could be a 384Kbps max or even less).


4G refers to the fourth generation of cellular wireless and is a successor to 3G and 2G standards. The 4G technology which is at its infancy is suppose to allow data transfer upto 100Mbps outdoor I.e while moving and 1Gbps indoor I.e while on stable position.4G is capable of providing users with streaming high-definition television, the content of a DVD-5 (for example a movie) can be downloaded within about 5 minutes for offline access. The main objective of the 4G technology is to accommodate the Quality of Service and rate requirements set by forthcoming applications like wireless broadband access, Multimedia Messaging Service (MMS), video chat, mobile TV, HDTV content, Digital Video Broadcasting (DVB), minimal services like voice and data, and other services that utilize bandwidth.




For getting Quality of Service 4G working group has set some standards such as spectrally efficient system (in bits/s/Hz and bits/s/Hz/site) , High network capacity: more simultaneous users per cell, smooth handoff across heterogeneous networks (that means there won’t be any call failure if there is change in network), Seamless connectivity and global roaming across multiple networks, High quality of service for next generation multimedia support, Interoperability with existing wireless standards (so that the old model cell phone can also be used with the new network without any changes) , An all IP packet switched network.




As described in 4G consortia including WINNER (Wireless-World-Initiative-New-Radio) and WWRF (Wireless World Research Forum), where WINNER is a consortium to enhance mobile communication systems and a key technology based approach has summarized and considered points as "Coverage, radio environment, spectrum, services, business models and deployment types, users".




The principal technologies used are :

• Baseband techniques:
1. OFDM: To exploit the frequency selective channel property
2. MIMO: To attain ultra high spectral efficiency
3. Turbo principle: To minimize the required SNR at the reception side
• Adaptive radio interface
• Modulation, spatial processing including multi-antenna and multi-user MIMO
• Relaying, including fixed relay networks (FRNs), and the cooperative relaying concept, known as multi-mode protocol

Unlike 3G, which is based on two parallel infrastructures consisting of circuit switched and packet switched network nodes respectively, 4G will be based on packet switching only. This will require low-latency data transmission.

By the time that 4G is deployed, the process of IPv4 address exhaustion is expected to be in its final stages. Therefore, in the context of 4G, IPv6 support is essential in order to support a large number of wireless-enabled devices. By increasing the number of IP addresses, IPv6 removes the need for Network Address Translation (NAT), a method of sharing a limited number of addresses among a larger group of devices, although NAT will still be required to communicate with devices that are on existing IPv4 networks.

The current 4G service providers in the world are Clear, Sprint & T-Mobile and some other very few worthy to be counted on our fingers. But these services are not full fledge and it is available in only few cities across the world like Atlanta, Charlotte, Chicago, Philadelphia etc.

Where as in India current technology being used is 2G and 3G, where as 3G is only provided by only BSNL & MTNL service provider. Any how these technology has not fully flourish since MTNL is still testing its connection in Delhi. Moreover BSNL 3G service charges Rs. 1/MB for limited type connection and Rs. 3000 Monthly for Unlimited connection.

comparing 4G technology with 3G technology we can easily find that resource utilization is less hence we can expect low cost if 4G technology is implemented in India. According to a recent news item, China has decided to move to 4G networks, bypassing 3G. Since there are many problems in allocating 3G spectrum to telecom networks and in setting up 3G mobile networks at high costs and China have been examining these issues since 2003.

Some of the mobile phone that support 3G technology are like Nokia, Lure, Motorola, BlackBerry where as some of the mobile phone that support 4G technology are like HTC, iPhone, Motorola. So its not difficult adopt to changing technology with a little bit of high cost for a new Mobile Phone!!

Anyhow who does not want a 1Gbps connection...!! Everyone love’s to have the fastest technology on there hands!! so lets hope for the 4G connection to be launched in India as soon as possible like it happened in China!! Since other service providers did not launch 3G so we can still have a hope..!!


- Palakal Bridewin Durandose

B.E.(I.T)