quote:

---

Originally posted by madfiddler

Someone posted about the photo album setup not being correct for Access 97 (the CREATE TABLE statements are wrong).

Here is a mod fix that I've just made http://www.shnforum.com/forum/topic.asp?TOPIC_ID=2818

The same fix is also required for the File Lister mod.

---

quote:

---

Originally posted by Jag24

Philnguyen44 If you read the entire thread you will see that there are many many problems witht his mod...very few have been successful at managing to have it work.....& very little support Wish I could help !

---

quote:

---

Originally posted by dibley

quote:

---

Originally posted by madfiddler

Someone posted about the photo album setup not being correct for Access 97 (the CREATE TABLE statements are wrong).

Here is a mod fix that I've just made http://www.shnforum.com/forum/topic.asp?TOPIC_ID=2818

The same fix is also required for the File Lister mod.

---

Hmmm... I may have to check that out.... After not getting anywhere with this mod for weeks, I installed shnForum on space at Parcom.net.(for only a small monthly cost!) Once the correct folder permissions where set, I have not had any more photo album problems.... I do still have a forum on 1asp with half an album installed, so may try again, now I have seen that!

Super!

---

quote:

---

Originally posted by P3TER

Well, I have played around with this code, and have created a function that fixes the specific problem I was experiencing. My users were attempting to upload files with non alpha-numeric characters in the filename (spaces, parentheses, hyphens etc) which in every case caused the thumbnailing function to fail, and in many cases caused the image display function to fail. another side effect was that a copied shortcut embedded in a forum posting within (img)(/img) tags would fail since it sometimes contained characters that are treated as risky and therefore stripped by the forum post functions..

I must warn you that I DO NOT consider myself to be a programmer, therefore I would be happy for anyone to tell me that my code sucks, as long as their response contains the source code to how it should be done!

Adding the code
Insert just above the last line "%>" at around Line 354 of inc_photo_album_functions.asp

quote:

---

function purify_filename( FileName )
'**********************************************************
'* P3TER's filename purifier function
'* ----------------------------------
'* Turns a filename into pure alpha numeric, removing all
'* characters other than numbers, letters, and "."
'**********************************************************
For ParseFileName = 1 to len(FileName)
ASCII = Asc(Mid(FileName,ParseFileName,1))
if ASCII <46 THEN Dirty = TRUE
'Flag these characters as dirty = !"#$%&'()*+,-

if ASCII >=58 AND ASCII <65 THEN Dirty = TRUE
'Flag these chars as dirty = :;<=>?@

if ASCII >=91 AND ASCII <97 THEN Dirty = TRUE
'Flag these chars as dirty = [\]^_`

if ASCII >=123 THEN Dirty = TRUE
'Flag these chars as dirty = {|}~ onwards

If Dirty = True then
FileName = Replace (FileName,chr(ASCII),"/")
End If
Dirty=false
next
FileName = Replace (FileName,"/","")
purify_filename = FileName
end function

---

Then, add this entry to around line 294 of ToFileSystem.asp, immediately above the "' Compile path to save file to" comment line.

quote:

---

'Call Filename purifier function
strFileName = purify_filename (strFileName)
'End of Filename purifier function

---

Removing the effect of this function is simple - just comment out the middle of the 3 lines above, and resave ToFileSystem.asp

Using this function when uploading a file means that a file named "F [i-l_e#-n'a me%1.jpg" would upload a file named "Filename1.jpg"

I would like to hear any feedback from anyone who tries this code. - please post it here!

---