Welcome to the TexasWebDevelopers Upload Photo Gallery Application. With these few ASP pages you can (1) browse your files for an image (2) create a caption for the image (3) upload it into a folder on your web site AND write the image information to a database (4) On a "show me" database results page you can -- view the image; a link to the image; the path to the image; and delete images, etc. (5) Provide your users with a great Photo Gallery experience. There is no limit to what you can do with this application on your web site! The Photo Gallery is "cross-broswer friendly" and works in the modern versions of Mozilla FireFox, Opera, Netscape and Microsoft Internet Explorer. Installation of the application is fairly straight-forward and we will walk through all of the bits here in this instruction page. First you simply un-zip all of the files into your web site folder on your hard drive. Once un-zipped you will find three folders and eleven files. The first folder named "database" contains the actual Microsoft Access Database named "upload.mdb". The database is ready to use but contains no data. Your will find a second folder named "gallery_images". This is where your images for the photo gallery will be stored. You will also find a third folder named "images" that contains four (4) image files: (1) banner.png (2) index_r1_c1.jpg (3) index_r1_c2.jpg and (4) spacer.gif The (1) banner.png file contains the original layered graphics that created the jpg files for the banner at the top of this page. The PNG file is fully editable with a graphics editor like Adobe Photoshop or Macromedia Fireworks or Microsoft's Acrylic should you desire to keep the current layout. The (2) and (3) images comprise the actual banner images used in the layout. The (4) spacer.gif is used in the photo gallery layout. After uploading the Database and gallery_images folders to your web site you MUST GIVE BOTH FOLDERS READ/WRITE PERMISSIONS. You may do this using Microsoft's FrontPage; or perhaps in your host server's control panel; or you may need to call your hosting company and have them do this for you. Please do not contact us for information on setting permissions on your server unless you are hosting with us. There are eleven (11) other files that comprise the image upload and Photo Gallery application: (1) index.asp --The landing page of the web application. It contains the same text as the "readme.txt" file. (2) readme.txt--The installation notes for the application. (3) twddebug.asp -- This is a bonus file--we set a default path to the database on line 5 and the name of the table on line 6 and an image directory on line 7. You may have to alter the paths to reflect your own web site parameters. This page will help troubleshoot your database connections and let you see if your folders have the correct permissions set. You can use this again and again in other web sites! (4) insert.asp -- A simple asp form page that posts to the insert1.asp page (5) insert1.asp -- This is where all the action is. The page first calls "loader.asp" which creates the file scripting object. Then it loads the object and shoots it off to the folder you have chosen on line 43 (we defaulted this to the folder "gallery_images") . Note: Make sure the folder has read/write permissions set. There is some error trapping and some confirmation text if the file uploads to the folder correctly. Then the form information is sent to a database named upload.mdb. You set the full path to the image folder in line 191 (you must do this yourself) and the path to the database is set on line 193 (which we defaulted to the folder named "database"). Then there is more error trapping and confirmation text if the information successfully posts into the database. You can add a CDOsys or ASPemail bit of code to send eMails to all parties at this point in the code. (6) loader.asp -- creates the FSO (7) show.asp -- is a simple database results page that generates a table with a link to the image, the size of the image, the image, the path to the image written out, and a delete button next to each image so that you can remove that image from the database application. Clicking the delete button does not physically remove the image from the image folder named "gallery_images". (8) showFSO.asp -- is an optional bonus page that shows a link to the image and the size of the image using the FileSystemObject method of retrieving the information (instead of a database connection). This simply goes to the folder the images are located in (designated on lines 28 and 34) and writes them out. Yes, you can use this bit to see any files in any folder--the FSO is a very powerful ASP tool. (9) login.asp --All of your ASP administration pages are secured by an ASP login application with the exception of the index.asp page and the gallery.asp page. At the top of each secured page is a bit of ASP code that looks like this (in the html view of a web editor) you will NOT see the code if you browse to the page and try to "view source" since the code has already been "parsed" (run) at the server level: <% If Session("accessok")=false then Response.redirect "login.asp" End if %> This code directs the administrative users to the login.asp to provide a username and password in order to upload images, etc. Removing the code simply makes the page viewable to the general public without having to log in. The default username and password are ADMIN and ADMIN. You can changes these to whatever you would like on line 2 of the login.asp page. Please note that the username and password should be in ALL CAPITAL letters in the html view of the page. The actual username/password fields in the form are not case sensitive. Upon successful login the user is directed to the "show.asp" page. You may change this redirect on line 4 of the login.asp page. (10) gallery.asp -- Here is where your images are displayed to the public. Simply move the mouse over the lower images in the scroll area and a larger image will appear with a caption that you inputted when you uploaded the image. The smaller images are the same byte size as the larger images. It is possible to use .NET to re-sample the thumbnail images to a smaller byte size but we have not included the function in this version of the gallery since most hosted sites to not reside on .NET servers. (11) styles.css -- is the style sheet for the current layout. The application does not depend on the style sheet for functionality. The gallery.asp page does have one CSS style in between the and tags (around line 42) that IS REQUIRED for the gallery application to function properly. Most installation errors for this application will center around the lack of read/write permissions on the database and gallery_images folders and on setting the paths to these folders in the above referenced files. Although we have produced the code with default settings that should "run right out of the box" we understand that you may need to change some of these settings yourself. We do not warranty this application but we will respond to most questions within one business day at photogallery@texaswebdevelopers.com Warranty Exclusion You agree that this software is a non-commercially developed program that may contain "bugs" (as that term is used in the industry) and that it may not function as intended. The software is licensed "as is". TexasWebDevelopers makes no, and hereby expressly disclaims all, warranties, express, implied, statutory, or otherwise with respect to the software, including non-infringement and the implied warranties of merchantability and fitness for a particular purpose. Limitation of Liability In no event will TexasWebDevelopers be liable for any damages, including loss of data, lost profits, cost of cover, or other special, incidental, consequential, direct or indirect damages arising from the software or the use thereof, however caused and on any theory of liability. This limitation will apply even if TexasWebDevelopers has been advised of the possibility of such damage. You acknowledge that this is a reasonable allocation of risk.