• Installing Uphotogallery on your webspace ( Access Version )
• Installing Uphotogallery on your webspace ( MS SQL Version )
• Administering Uphotogallery

• Modifying Uphotogallery skin
• Integrating Uphotogallery into your web site
• Writing your own language file and installing it

1. Check that your web space is running on Windows NT4, 2000, 2003 operating system, with IIS 4+ and is ASP enabled.
2. Check with your web hosting provider that you can use a DSN-less connection to an Access database on your web space and that you have sufficient permissions to write to this database.
3. Unzip the zip file into your hard drive keeping the files and images in the original directories.
4. Open the file settings.asp, inside the include directory, in a text editor like Notepad, locally on your own machine, and change the lines 7-55 ( change the parts shown in blue ) :
   
   line 7 --> strDatabaseType = "Access" [ type of database used ]
   
   line 24 --> StrPathDb = "mdb-database/Uphotogallery.mdb" [ database path - make sure that this is a valid path to the database ]
   
   line 34 --> Cookie_Name = "UG" [ it is the gallery cookie name; this is useful if you run multiple copies of Uphotogallery on the same site ]
   
   line 38 --> Ugallery_address = "http://www.yourdomain.com/gallery/" [ is your gallery's URL: for example, 'http://www.yourdomain.com/gallery/' - remember final slash ! ]
   
   line 41 --> folder_upload = "public" [ general upload directory - make sure that this directory have sufficient permissions to write ]
   
   line 45 --> StrPathShortImage = folder_upload & "/images_upload/" [ images upload directory - make sure that this folder have sufficient permissions to write and remember final slash ! ]
   
   line 49 --> imageuploadext = "jpg,gif,bmp,png" [ kind of image file allowed to upload; don't change this value ]
   
   line 52 --> imageuploadsize = 50000 [ max size allowed for each uploaded images - 50000 = 50 Kb ]
   
   line 55 --> PagesPerBlock = 10 [ number of pages per block ]
   
   Once you have finished amending the settings.asp file, save the amended version.
   
5. Upload the files and the directories images, include and language through FTP to your webspace, keeping the files and images in the original directories.
6. Upload the file Uphotogallery.mdb , founded in the folder mdb-database ( on your hard drive ), through FTP to your webspace inside the directory that you have indicate as "database directory" ( line 24 in settings.asp file - in this example mdb-database ). Make sure that this folder have sufficient permissions to write and that is not available from web.
7. Upload the directory images_upload , founded in the folder public ( on your hard drive ), through FTP to your webspace inside the directory that you have indicate as "general upload directory" ( line 41 in settings.asp file - in this example public ).
8. Optional : if you want to publish directly some images in Uphotogallery, you need to upload them , through FTP, inside the directory images_upload on your webspace.
9. Run the file setup.asp , which you can find into the main folder of Uphotogallery, in your browser (that is go to the url http://www.yourdomain.com/setup.asp ) . This file will verify the settings.asp file values and, if you attain at the point 8, will insert in the database the images that are inside the images_upload directory.
   
   It is highly recommend for security purposes that you delete this file from the Web Server once the installation is complete.
   
   
10. Now you can use the Gallery.

1. Check that your web space is running on Windows NT4, 2000, 2003 operating system, with IIS 4+ and is ASP enabled. You will also need an MS SQL Server Database to run this version.
2. Make sure that you have access to an MS SQL Server Database.
3. Create an empty database on the MS SQL Server or use an existing one.
4. Unzip the zip file into your hard drive keeping the files and images in the original directories.
5. Open the file setting.asp, inside the include directory, in a text editor like Notepad, locally on your own machine, and change the lines 7-55 ( change the parts shown in blue ):
   
   line 7 --> strDatabaseType = "SQLServer" [ type of database used ]
   
   line 11 --> MSSQLSVR = "my_mssql_server_name" ( MS SQL Server Name )
   
   line 14 --> MSSQLUID = "username" ( MS SQL Server Username - for MS SQL Server Authentication )
   
   line 17 --> MSSQLPWD = "password" ( MS SQL Server Password - for MS SQL Server Authentication )
   
   line 20 --> MSSQLDB = "Db_Name" ( MS SQL server database name - the name of the empty database you created on the MS SQL Server )
   
   line 29 --> Table_Prefix = "ug_" [ it is the database table name prefix ; this is useful if you are running multiple galleries from one database ]
   
   line 30 --> SP_Prefix = "ug_" [ it is the database stored procedures name prefix ; this is useful if you are running multiple galleries from one database; do not name stored procedures with the "sp_" prefix ]
   
   line 34 --> Cookie_Name = "UG" [ it is the gallery cookie name; this is useful if you run multiple copies of Uphotogallery on the same site ]
   
   line 38 --> Ugallery_address = "http://www.yourdomain.com/gallery/" [ is your gallery's URL: for example, 'http://www.yourdomain.com/gallery/' - remember final slash ! ]
   
   line 41 --> folder_upload = "public" [ general upload directory - make sure that this directory have sufficient permissions to write ]
   
   line 45 --> StrPathShortImage = folder_upload & "/images_upload/" [ images upload directory - make sure that this folder have sufficient permissions to write and remember final slash ! ]
   
   line 49 --> imageuploadext = "jpg,gif,bmp,png" [ kind of image file allowed to upload; don't change this value ]
   
   line 52 --> imageuploadsize = 50000 [ max size allowed for each uploaded images - 50000 = 50 Kb ]
   
   line 55 --> PagesPerBlock = 10 [ number of pages per block ]
   
   Once you have finished amending the settings.asp file, save the amended version.
   
6. Upload the files and the directories images, include and language through FTP to your webspace, keeping the files and images in the original directories.
7. Upload the directory images_upload , founded in the folder public ( on your hard drive ), through FTP to your webspace inside the directory that you have indicate as "general upload directory" ( line 41 in settings.asp file - in this example public ).
8. Optional : if you want to publish directly some images in Uphotogallery, you need to upload them , through FTP, inside the directory images_upload on your webspace.
9. Run the file setup.asp , which you can find into the main folder of Uphotogallery, in your browser (that is go to the url http://www.yourdomain.com/setup.asp ). This file will verify the settings.asp file values, will create all the tables and default values in the empty database you created on the MS SQL Server and, if you attain at the point 8, will insert in the database the images that are inside the images_upload directory.
   
   It is highly recommend for security purposes that you delete this file from the Web Server once the installation is complete.
   
   
10. Now you can use the Gallery.

1. Once your Uphotogallery is up and running you can administer and set up your gallery by logging in through the login page ( http://www.yourdomain.com/login.asp or clicking on the "Admin Panel" link in the botton of the gallery ) with the default admin username and password :
   • Username: admin
   • Password: admin
2. In the admin section of Uphotogallery you can find the following options :
   • Edit/Delete Images
   • Categories Management
   • Bad Words Management
   • Gallery Configuration ( change the default admin username and password - highly recommend )

You can easily create your own unique looking gallery. To do this simply go to the url http://www.yourdomain.com/config.asp and change the background color, the font color, the font face and the font size of the titles, text etc.

For more advanced options open the file css_common.inc, inside the include directory, in an HTML editor, locally on your own machine. This file contains the Cascading Style Sheet (CSS) which controls the fonts for the text and links etc..; the CSS part looks like the following:

.tablemenu {
border-width : 1;
border-style : solid;
border-color : <% = Ugallery_color1 %>
}

Don't change the parts shown in blue between the tags "<% ; %>".

Once you have finished altering the CSS file save the edited version and test your gallery to see if it looks like it should.

If you want to enter another CSS file ( for example your_style.css ), open locally on your machine the file metatag.asp, inside the include directory, and put , at the end of the code , this line:

<LINK href="your_styles.css" rel=stylesheet>

Once you have finished editing the metatag.asp file save it and upload both the files ( your_styles.css and metatag.asp ) through FTP to your webspace ( always in the directory "include" ) and test the gallery in your browser to see if it looks and runs correctly.

If you want to change the Uphotogallery package images, download the original stages ( .png format ) by clicking on the link below :

Download Now!

In the file metatag.asp you can also put your additional "javascript code"!

You can also easily integrate the gallery into your web site by editing two files in order to add ( for example ) your site logo across the top, and any info in the footer of your site [ the following needs to be done locally on your machine and then upload to your web space through FTP].

1. Make a back-up of the files, header.asp and footer.asp, inside the include directory.
2. Open the file header.asp in an HTML editor, locally on your machine, and add your own web site logo or any other content you wish display at the top of each page of the gallery.
3. Once you have finished editing the header.asp file, save it, upload to your web space, and test the gallery in your browser to see if it looks and runs correctly.
4. Open the file footer.asp in an HTML editor, locally on your machine, and add any content that you would like displayed at the bottom of each page of the gallery.
5. Once you have finished editing the footer.asp file save the edited version, upload to your web space, and test the gallery in your browser to see if it looks and runs correctly.

The default languages available with Uphotogallery package are "english" and "italian".
If your language is not one of these you can easily translate the gallery into your own language. To do this simply follow the instructions below:

1. Open the directory language , locally on your machine, and make a copy of one of the two files present in it.
2. Rename this copy file with the name of your language ( i.e.: french.inc or chinese.inc )
3. Open this file in a text editor like Notepad.
4. In this file you will see a lots of lines that look like the line below:
   
   strLangSelectAdminSection = "Admin Panel"
   
   
5. Translate the parts shown above in blue between the quotation marks into your own language.
6. Remember to change ( at the beginning of the code ) the CharSet Code Page that looks like the line below:
   
   strLangSelectCharset = "iso-8859-1"
   
   Change the part shown above in blue between the quotation marks; i.e., codepage gb2312 provides character codes required in the Chinese language. The codepage allows the system to provide the appropriate character code to an application when a user presses a key on the keyboard.
   
7. Once you have finished altering the file save and upload it through FTP to your webspace (always in the directory "language"). To change the default language of your gallery, go to the url http://www.yourdomain.com/config.asp and select the new language file in the "language select menu".