File field improvements

Gosling Cools

Junior Member

Posts: 20

9 years 9 months ago - 9 years 9 months ago #698 by Gosling Cools

File field improvements was created by Gosling Cools

Make file extension lower case (for all those .JPG files!)

Add the second line to your table/your-item.php

$filename[0] = preg_replace("/[^A-Za-z0-9]/i", "-", $filename[0]);
$filename[1] = strtolower($filename[1]);

A current file might exist, if so delete it. Else you will end up with lots of files that don't get deleted.
After this line:

if(!JFile::exists($uploadPath)){

insert:

if($array['id'] != 0)
{ 
   // do a db query on this current item to get the current filename
   // delete this file from the server
}

Hope this is of any use :-)

Last edit: 9 years 9 months ago by Gosling Cools.

The following user(s) said Thank You: Andres Maeso, Juanjo vazquez real, RIP Graphics

Please Log in or Create an account to join the conversation.

logic

New Member

Posts: 2

8 years 4 months ago #1401 by logic

Replied by logic on topic File field improvements

i am facing following error when i try to save file filed

Error
Save failed with the following error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select FROM #__pdfperfectuploader_ WHERE id = 0' at line 1 SQL=SELECT select FROM #__pdfperfectuploader_ WHERE id = 0

Please Log in or Create an account to join the conversation.

Time to create page: 0.049 seconds