Page 1 of 1

Rename upload to Member Name

Posted: 2013-03-22 13:40
by charmed_ones
HI Folks,
Looking for a way to rename the upload of a CSV file the member is uploading to his membership name. I have no clue where to even start looking. If I say rename file it changes it to random numbers, or if I don't it leaves it to what every they name it. I need the files to be named after their member name. Any one have a clue where I would look to replace the $post [membername]? so the files is automatically changed to membername?

Re: Rename upload to Member Name

Posted: 2021-03-14 04:22
by charmed_ones
Here is the code we use to capture the database field name and rename the three images we allow to be uploaded
in the hooks/database.php file add

We have a field NAMED TAG and we are renaming all the images as the inserted TAG number

function Rename_FileName($filename, $tag_number)
{
$extension = end(explode('.', $filename));
if (!rename("/images/$filename", "/images/$tag_number.$extension"))
die('can not rename the file');
return $extension;
}



function Rename_Image_Filename_After_Insert_Or_Update($data){
$data = (object) $data;
$sql = "select TAG_Number from Defective_Returns where id='{$data->TAG}'";
$tag_number = sqlValue($sql);

if ( $data->Images ){

$extension = Rename_FileName($data->Images,"$tag_number");
$query="UPDATE YOUR_DATABASE_TABLE SET Images= '{$tag_number}.{$extension}' WHERE id=$data->id";
sqlValue($query);
}

if ( $data->image2){
$extension = Rename_FileName($data->image2,"$tag_number-1");
$query="UPDATE YOUR_DATABASE_TABLE SET image2= '{$tag_number}-1.{$extension}' WHERE id=$data->id";
sqlValue($query);
}

if ( $data->image3){
$extension = Rename_FileName($data->image3,"$tag_number-2");
$query="UPDATE YOUR_DATABASE_TABLE SET image3= '{$tag_number}-2.{$extension}' WHERE id=$data->id";
sqlValue($query);
}
return TRUE;
}




function YOUR_DATABASE_NAME_after_update($data, $memberInfo, &$args)
{
return Rename_Image_Filename_After_Insert_Or_Update($data);
}




Then call it after insert


function YOUR_DATABASE_NAME_after_insert($data, $memberInfo, &$args)
{

return Rename_Image_Filename_After_Insert_Or_Update($data);
}