| Author |
 Topic  |
|
burthold
Junior Member
USA
426 Posts |
 Posted - 21 August 2002 : 00:43:55
|
New album out! 1.80.
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=36637
Mod Name: Photo Album v1.50 for Snitz 3.3.05 /3.4.02
Version: v1.50
Tested on: 3.3.05/3.4.02 should work with any 3.3.x/3.4.x forums though
Databases: Tested on MySQL v3.23.40NT, MS Access, and MS-SQL 2000 should work with 7.0 as well though not tested with it.
OS Tested: Windows 2000/IIS5
Creator Name: Wesley Brown
Contributors: Aecio Lemos, Lewis Moten, Mike Shaffer(whether they know it or not)
Creator Email: Burthold@yahoo.com
Download at: www.wesworld.net/mods/default.asp
Demo Site: www.wesworld.net/snitzdemo/default.asp
AS WITH ANY MOD, TEST IT BEFORE YOU GO LIVE WITH IT!
Major Changes from 1.20
Paging for large albums, not all pictures are shown on one page
Single album mode. Now administrators can set the album in single mode. Categories are tied to the Admin account. IF THE Admin doesn't have an album SINGLE ALBUM MODE WILL NOT WORK!
Administrators can set the option to have a photo displayed in a pop-up window OR under the thumbnails
Administrators can allow users to pick a photo to displayed on the category page.
No duplicates in the database or on disk now.
More error messages! There is more error trapping if a file doesn't upload the album should tell you and give some reason.
Security added in the form of SQL Insertion protection. There are funtions that filter illegal charaters and illegal words.
Bug Fixes:
DB doesn't get a record if the file doesn't exist on disk.
Now handles spaces in user names.
Admin page honors secure admin mode properly now instead of erroring out.
Thumbnails for all file types now generated.
Limitations:
You cannot use show in pop up window feature and use tiff image types. The browser doesn't know how to handle the image type and will open up a download file dialog.
Major Changes from 1.00
Code base re-written using response writes.
All functions moved to a seprate include to clean up code.
Tons of error checking for valid insert strings and setup/update error checking
Setup now run from the admin_album.asp
Administrators can have the setup create a folder as well as add all the tables
Administrators can now update tables from admin page
Administrators can now remove all tables and uploaded files from admin page.
Bug fixed: Users are now deleted from file system as well as the database when removed
Major Changes from v.05
Code base reduced to one set of files no more components and non components versions.
Accepts 5 file types, Gif, Jpeg, Tiff, Png, and Bmp.
Using nconvert.exe from xnview to generate thumbnails this keeps all code under the GPL.
Sub-categories added so users can have multiple albums.
Users can move photos one at a time using the edit photo.
Users can move whole sub-categories to other categories using the file upload page.
Pictures now displayed on same page as thumbnails/photo list.
Users have the option of making photos viewable or not without having to delete it from the album. This still counts towards your picture count stored though.
Administrators can turn on photo approval so photos are not viewable until approved.
Administrators can upload/delete/modify any photo album just as if it were the Administrator album.
Administrators can choose which file types to allow or disallow.
Administrators can limit the number of categories.
Administrators can now add users in bulk. The option will add all forum users not currently holding an album account. -- Original code written by Aecio Lemos.
Notes:
This mod was developed as a true modular add on for snitz. You must have FileSystemObject access for this to work! You must have write access to the folder you want to use! It can be a virtual directory as long as you have write permission!
If you wish to use the thumbnail generator instead of just resizing the image copy the nconvert.exe to a folder that has permission to run executables. You will also need to download the asp component called aspexec, it is available on my website as well. You will need to have this installed and registered on your server. Nconvert is part of xnview. This is a GPL'ed program and should be registered if used on sites that are commercial in nature. Support the authors of this fine product. You will need the absolute path to the executable i.e. c:\thumbnailer\ you will need this to setup your photo album please see the configuration item under admin_album.asp. With all the components and programs installed the photo album will generate thumbnails of the original picture about 1.2k in size and save the thumbnail as a Jpeg to save on space. If you don't use the nconvert.exe to make thumbnails the photo album gives you the option to turn thumbnail images on and off. If for some reason the thumbnail images don't get generated the album will use the resize option unless the display thumbnail option is turned off. If a valid thumbnail image is available it will use it regardless of the thumbnail option being turned on or off. The thumbnail on/off option is for those not using the thumbnail generator to save on bandwidth.
Upgrading current albums:
Copy the new album files into your forums directory. run update from admin_album.asp. It will update the database.
Installing for the first time:
Please check the readme for the install instructions for your forum version.
If you have any questions just email me at burthold@yahoo.com.
updated to v1.20 08/27/2002
updated to v1.50 09/02/2002 |
Edited by - burthold on 10 October 2002 12:55:15 |
|
|
burthold
Junior Member
USA
426 Posts |
Posted - 21 August 2002 : 00:45:39
|
Give it a swing. I did test under all three DB platforms I can't find any additional bugs if you find anything please send me an email I check my mail often and all day long. I will now start converting to 3.4. It DOES NOT work with 3.4 there have been some changes from 3.3.x to 3.4. There is a beta for people running 3.4 there will be no database changes I had to change all the includes but the code works. you will need to add this to the admin_home.asp around line 94
" <LI><span class=""spnMessageText""><a href=""admin_album.asp"">Photo Album Administration</a></LI>" & vbNewLine & _
The only thing I will be doing is converting everything to response.writes to conform to 3.4 standards right now. I have tested it with 3.4 on access and all appears good. As with all mods TEST IT FIRST! If you find anything wrong email me!
Thanks everyone!
Wes |
Edited by - burthold on 21 August 2002 01:38:15 |
 |
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 21 August 2002 : 02:00:15
|
Thanks for the MOD, wes!
Just downloaded it. Will play with it and see how it goes. I really appreciate it. Thanks again!
Cheers,
Etymon |
|
|
|
randykirkpatrick
New Member
73 Posts |
Posted - 21 August 2002 : 11:09:50
|
I have install and ran the photo_album_setup.asp and get this message can someone tell what i did wrong?
There was an error Field 'Photo_Status' already exists in table 'FORUM_ALBUM'.
There was an error Field 'Photo_Cat' already exists in table 'FORUM_ALBUM'.
There was an error Field 'Photo_Cat' already exists in table 'FORUM_ALBUM'.
There was an error Field 'Photo_Cat' already exists in table 'FORUM_ALBUM'.
There was an error Field 'img_type' already exists in table 'FORUM_ALBUM_CONFIG'.
There was an error Field 'approve' already exists in table 'FORUM_ALBUM_CONFIG'.
There was an error Field 'num_cat' already exists in table 'FORUM_ALBUM_CONFIG'.
There was an error Field 'num_cat' already exists in table 'FORUM_ALBUM_CONFIG'.
insert into FORUM_ALBUM_CONFIG (num_files,file_size,thumbnails,base_dir,thumbnailer,img_type,approve,num_cat) VALUES (10,120000,1,'uploads','c:\Eyebatch\','1,1,1,1,1',0,5)
If any of these errors are "already exists" or "must be unique" or "Duplicate column name" errors then ignore them.
If you are running this file to upgrade your installation these errors are normal.
If it is something else investigate it.
Return To Forum
|
Thank you
Randy K |
|
|
|
burthold
Junior Member
USA
426 Posts |
Posted - 21 August 2002 : 12:02:39
|
Those are "already exists" errors. Just like the message says. Looks like the instal went just fine.
|
|
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 21 August 2002 : 21:50:00
|
quote:
Originally posted by burthold
Download at: www.wesworld.net/mods/photoalbum/
Not sure what's going on? but i can't link to your website....
i try it many times... just show me the TCP_Error.... |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 21 August 2002 : 22:02:31
|
quote:
Originally posted by DoraMoon
quote:
Originally posted by burthold
Download at: www.wesworld.net/mods/photoalbum/
Not sure what's going on? but i can't link to your website....
i try it many times... just show me the TCP_Error....
I just double-checked because last night I downloaded the files and the links were there.
The page looks like a FTP site. At the top it says www.wesworld.net - /mods/photoalbum/ in large font. Below that is [To Parent Directory] and below this the files are listed. |
|
|
|
burthold
Junior Member
USA
426 Posts |
Posted - 21 August 2002 : 22:05:05
|
They are direct downloads no page just a directory listing. The files should be blue like a normal link just click and download. If needed I will put a page up instead with links.
Wes |
|
|
|
randykirkpatrick
New Member
73 Posts |
Posted - 22 August 2002 : 07:47:51
|
Ok I got this Mod installed but when I upload a picture then check it it shows the file name but where the picture should be there is a square with a red X in it. Where did I go wrong why is the file not showing up?
Thank you
Randy K
|
Thank you
Randy K |
|
|
|
burthold
Junior Member
USA
426 Posts |
Posted - 22 August 2002 : 11:52:07
|
Did you make a folder for the files to go to? The mod doesn't create the base folder only user folders. Once that is done the folder name must be the same in the administraton page as well. My folder is called Uploads. Thats what is on the admin page.
Wes |
|
|
|
randykirkpatrick
New Member
73 Posts |
Posted - 22 August 2002 : 21:19:15
|
| Where do I put that folder? |
Thank you
Randy K |
|
|
|
burthold
Junior Member
USA
426 Posts |
Posted - 22 August 2002 : 21:58:08
|
It can be in your snitz folder just make sure it has write access to it.
|
|
|
|
randykirkpatrick
New Member
73 Posts |
Posted - 22 August 2002 : 22:26:35
|
How should the link look in the root dir in the admin section all that is there is Uploads do i need it to point to the URL www.sitename.com/Upload
or not
|
Thank you
Randy K |
|
|
|
burthold
Junior Member
USA
426 Posts |
Posted - 22 August 2002 : 22:43:19
|
no just the name of the directory. It will map the path on its own.
Wes |
|
|
|
burthold
Junior Member
USA
426 Posts |
Posted - 22 August 2002 : 23:06:03
|
There has been a very small bug fix in photo_album_upload.asp Please download the new pack and copy over that file.
Wes |
|
|
|
randykirkpatrick
New Member
73 Posts |
Posted - 23 August 2002 : 07:49:32
|
| is that the 34beta? |
Thank you
Randy K |
|
|
|
Topic |
|
Topic Locked
