FrontPage Web Site, Web Page, Database, User Level, Logon / Login
Scripts and Applications.
Password Scripts
- WebWizGuide
- Webs Unlimited
- FrontPage Database
Interface Wizard (DIW)
Modification
|
- FrontPage Wiz User
Level Web Site Protection
|
|
There are many needs/ways to implement a login script or
application. Depending on what your needs are, will dictate what you
use.
First we will look at individual page protection, then a registration
system (must login to access the site), FrontPage
DRW and DIW protection
and finally a user level system (different uses have a different level
of access to the site).
All scripts will use ASP, Access 2000 databases, hosting provider
with FrontPage server
extensions, FrontPage 2002 or better, Access 2000 or better and Windows 2000 Pro or better, unless otherwise noted. If
your hosting provider has ODBC connections, and you are familiar with
them, then by all means use it.
For individual page protection, I am going to use a Free
Script by WebWizGuide, then a add-in for FrontPage by Webs Unlimited and
Finally a modification of FrontPages own DIW (Database Interface
Wizard). For folder protection ask your hosting provider to set a
network password for you, this should be different than the one you
upload your web site to if anybody other than yourself is going use it.
WebWizGuide: ASP Web Page Protection
- First Download the Database Login script.
- Unzip the file and extract all to a file named fppw. Don't
extract these to your web site. For extra security, right click the
extracted users.mdb and rename it something else.
- FrontPage 97/98, 2000, has a tendency to add code. This makes
asp files that where not developed in FrontPage a bit hard to edit.
Even 2002 and 2003 add code, so whenever possible use Notepad to
edit these files. There not much editing in this tutorial, so don't
be alarmed.
If you do use FrontPage to edit, save your work often, make a backup
copy and test often.
To use Notepad:
>Right click the file
>Choose open with: Notepad
>Choose Program, If not on the list.
- Next, click:
>View >Folder List
On the left hand side you now have a list of all the folders/files
in your web site.
Click once on the folder at the very top to highlight it. Now go to:
>File > Import, use the expand arrow if you don't see Import.
>Choose Add Folder
>Browse to the the fppw folder you extracted your WebWizGuide files
to. FrontPage will ask you if you want to make a database
connection. Change the Database1 to something that you will
associate the script with. Then click yes.
i.e. wwLoginDB
Next FrontPage will ask you if want to store your user.mdb database
in a special folder called fpdb, click yes, if you don't already
have a folder called fpdb, FrontPage will create one for you.
FrontPage will also create a special file called global.asa, this
stores your database connection. Don't edit this file.
When done, click on your top folder
in the Folder List Pane
and hit your F5 key
this will refresh your web.
-
We placed the user.mdb in the special FrontPage
folder fpdb, because it's more secure. But the script is written for
the database to be in the same folder, so we need to change that.
-
Open the file called check_user.asp in notepad or
html/code view.
Find the line of code that says (about line 21):
strCon = "DRIVER={Microsoft Access Driver (*.mdb)};uid=;pwd=letmein;
DBQ=" & Server.MapPath(strAccessDB)
Now copy the code below, and paste it over the line above (in red)
on the check_user.asp page.
- Now on the check_user.asp page. change
letmein (in the code you just pasted) to a more secure
password.
- Open Microsoft Access.
>Choose >File >Open
>browse to the disk path to the user.mdb.
C:\Inetpub\wwwroot\Yourweb\fpdb
or
C:\Documents and Settings\Administrator\My Documents\My Web Sites
Click once to highlight it, then click on the arrow next to the open
button for more options. Choose >Open Exclusive
Type letmein
- The first thing we want to do is reset the password.
>Tools >Security >UnSet Database Password
-
Now ReSet it.
>Tools >Security >Set Database Password
-
Now click on the table tblUsers and change the
UserID and Password, these are the ones you will use on your web
site.
- When your finished, close Access.
Note: FrontPage will not update the database until you close Access
and return to FrontPage.
- Now just add this code to all of the pages you want to protect,
they must end in .asp. The code goes above the <html> tag.
<%
'If the session variable is False or does not exsist then redirect
the user to the unauthorised user page
If Session("blnIsUserGood") = False or IsNull(Session("blnIsUserGood"))
= True then
'Redirect to unathorised user page
Response.Redirect"unauthorised_user_page.htm"
End If
%>
You may or may not want to put a link to login page on the
unauthorised_user_page.htm.
Depending on where your password protected pages are relative to
unauthorised_user_page.htm, you will
want to either drop the authorised_user_page.asp and
unauthorised_user_page.htm in that directory.
OR
Set the path in the above code in red. You can use an absolute path
or relative path.
Absolute:
http://www.frontpagewiz.com/fppw/unauthorised_user_page.htm
Relative:
Under: /fppw/Yourname/unauthorised_user_page.htm
Above: ../yourname/unauthorised_user_page.htm
- Create a test_ww_login.asp page and try to access it.
- The page works on
session cookies. That means when
- You can stylize the pages any way you want, as I did on the
login page.
- If you want to remove the
logo, send them a small donation!!
- Read the License.txt and ReadMe.txt that came with your software
from WebWizGuide.
- ..."Permission can be obtained from Web Wiz Guide to remove the
powered by logo's, text or, images by purchasing removal keys/rights
from Web Wiz Guide to remove these from
http://www.webwizguide.info/purchase . This helps support the
development and update of this and future software from Web Wiz
Guide.
Permission can be obtained from Web Wiz Guide to remove the powered
by logo's, text or, images by making a donation to Web Wiz Guide to
help support the development and update of this and future software."...
Password Scripts
- WebWizGuide
- Webs Unlimited
- FrontPage Database
Interface Wizard (DIW)
Modification
|
- FrontPage Wiz User
Level Web Site Protection
|
|
|
