Gossamer Forum: Products: Gossamer Links: Discussions: Display file size for attachment

May 18, 2009, 9:03 AM

Piers1

User (153 posts)

May 18, 2009, 9:03 AM

Post #1 of 9

Shortcut

Display file size for attachment

Hi there,

Is it possible to make a global that will display the file size of an attachment? i.e. I am successfully uploading CAD files using a new file column but it would lovely to display the file size when displaying the link.

Cheers,

Piers

May 18, 2009, 9:21 AM

Andy

Veteran / Moderator (17297 posts)

May 18, 2009, 9:21 AM

Post #2 of 9

Shortcut

Re: [Piers1] Display file size for attachment In reply to

Sure, use this globals:

get_file_size

Code:
sub { 
  my $size = $DB->table('Links_Files')->select ( [File_Size''], { ForeignColName => $_[1],  ForeignColKey => $_[0] } )->fetchrow; 
  $size = $size / 131072; 
  return sprintf("%.2f", $size); 
}

..then call with:

<%get_file_size($ID,"Attachment")%>

..replace "Attachment" with the name of your field.

Untested, but should work =)

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

May 18, 2009, 9:50 AM

Piers1

User (153 posts)

May 18, 2009, 9:50 AM

Post #3 of 9

Shortcut

Re: [Andy] Display file size for attachment In reply to

Hello Andy,

Fatal error.
Comes back with "panic: pp_iter at GT::Template::dump line 538"

Why are you causing it to panic? It's like a minister having its expenses examined.

Thanks for your help.

Cheers,

Piers

May 18, 2009, 9:59 AM

Andy

Veteran / Moderator (17297 posts)

May 18, 2009, 9:59 AM

Post #4 of 9

Shortcut

Re: [Piers1] Display file size for attachment In reply to

Mmmm, I can't see any reason why it would do that :/

Quote:

Why are you causing it to panic? It's like a minister having its expenses examined.

LMAO!!!!

Cheers

Andy (mod)
andy@ultranerds.co.uk

Aug 21, 2009, 4:02 PM

Piers1

User (153 posts)

Aug 21, 2009, 4:02 PM

Post #5 of 9

Shortcut

Re: [Andy] Display file size for attachment In reply to

Hey Andy,

I never got this to work. Would it be broken because the actuals files are not directly accessible from the web? I did this to stop people guessing the directory, but the attachment scripts still downloads them ok in Links.

I now have quite a few CAD files being downloaded and displaying the file size would be really helpful.

Cheers,

Piers

Aug 22, 2009, 12:31 AM

Andy

Veteran / Moderator (17297 posts)

Aug 22, 2009, 12:31 AM

Post #6 of 9

Shortcut

Re: [Piers1] Display file size for attachment In reply to

Which global are you using? The one a few posts up?

Cheers

Andy (mod)
andy@ultranerds.co.uk

Aug 22, 2009, 12:48 AM

Piers1

User (153 posts)

Aug 22, 2009, 12:48 AM

Post #7 of 9

Shortcut

Re: [Andy] Display file size for attachment In reply to

Yes - I just tried it again, and get an exciting '500 Internal Server Error' on any pages where I try it.

Cheers,

Piers

Aug 22, 2009, 1:02 AM

Andy

Veteran / Moderator (17297 posts)

Aug 22, 2009, 1:02 AM

Post #8 of 9

Shortcut

Re: [Piers1] Display file size for attachment In reply to

Do you have any error logs you can look at?

Otherwise, try changing it to a much simpler bit of code - with some debugging, so we can see whats going on.

Code:
sub { 
  my $size = $DB->table('Links_Files')->select ( [File_Size''], { ForeignColName => $_[1], ForeignColKey => $_[0] } )->fetchrow; 
 return "FOO, got size: $size, for ForeignColName => $_[1], ForeignColKey => $_[0] "; 
#     $size = $size / 131072; 
#  return sprintf("%.2f", $size); 
}

Cheers

Andy (mod)
andy@ultranerds.co.uk

Aug 25, 2009, 5:58 AM

Piers1

User (153 posts)

Aug 25, 2009, 5:58 AM

Post #9 of 9

Shortcut

Re: [Andy] Display file size for attachment In reply to

Follows is now working thanks to Andy;

Global named 'get_file_size'

Code:
sub { 
 my $size = $DB->table('Links_Files')->select ( ['File_Size'], { ForeignColName => $_[1], ForeignColKey => $_[0] } )->fetchrow; 
 $size = $size / 1048576; 
 return sprintf("%.2f", $size); 
}

Add to 'Detailed' Template

Code:
File size: <%get_file_size($ID,'attachment_field_name')%>Mb

Change 'attachment_field_name' to the name of the field you wish to find the file size for.

Cheers,

Piers