vb.org Archive - Attachment Count in MB

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)

- - Attachment Count in MB (https://vborg.vbsupport.ru/showthread.php?t=53416)

Attachment Count in MB

Can anyone please tell me how to pull the MB out of an attachment query? Here is the code for pulling out the KB but I can't seem to find the right code for the MB. I know it is simple, but I must not be very good in the math department.

PHP Code:


		
			
SUM(LENGTH(attachment.filedata))/1024 AS KBbytes

PHP Code:


		
			
SUM(LENGTH(attachment.filedata))/1048576 AS KBbytes

?:confused:

I had that but I want to get it like 2.12 MB. instead of just 2 MB. How do I get it to go the 2 decimal places?

<a href="http://www.php.net/round" target="_blank">http://www.php.net/round</a>

I tried that, too. When I round 2,174,891, I get 2 MB. This is how I used round:

PHP Code:


		
			
$attachs['MBbytes'] = round($attachs['MBbytes']);

Then:
[sql]
...SUM(LENGTH(attachment.filedata)) / 1024 * 1024 * 1024 AS mbytesum...
[/sql]
...then round it. :)

That threw it way off. ;) Here's the code I am working with if that will help.

PHP Code:


		
			
/** Count of Attachments Per Forum and Bytes **/

$attachs=$DB_site->query_first("SELECT forum.title AS forum, COUNT(attachment.attachmentid) AS count, SUM(LENGTH(attachment.filedata)) AS bytes, SUM(LENGTH(attachment.filedata))/1024 AS KBbytes, SUM(LENGTH(attachment.filedata))/1048576 AS MBbytes

FROM attachment,post,thread,forum

WHERE attachment.attachmentid = post.attachmentid

AND post.threadid=thread.threadid

AND forum.forumid=thread.forumid

AND forum.forumid=$forumid

GROUP BY thread.forumid

ORDER BY count DESC");



$attachs['count'] = number_format($attachs['count']);

$attachs['bytes'] = number_format($attachs['bytes']);

$attachs['KBbytes'] = number_format($attachs['KBbytes']);

$attachs['MBbytes'] = number_format($attachs['MBbytes']);

$attachs['MBbytes'] = round($attachs['MBbytes']);

If ($attachs['MBbytes']<1) {

$attachs['MBbytes']='';

} else {

$attachs['MBbytes']="=" .$attachs['MBbytes']. "MB";

}

If ($attachs['count'] !="0") {

$attachinfo="<tr>

        <td nowrap><smallfont><b>Total Attachments:</b> $attachs[count]</smallfont></td>

        <td nowrap><smallfont><b>Total Attachments Bytes:</b> $attachs[bytes] bytes ($attachs[KBbytes] KB$attachs[MBbytes])</smallfont></td>

</tr>";

} else {

$attachinfo="";

}

/** Count of Attachments Per Forum and Bytes **/

Use the php modulus operator to work with the remainder.

http://us3.php.net/manual/en/languag...arithmetic.php

LOL I just tried that and I was way off. All I am trying to do is go 2 decimal places with the MB and have it rouind up if it needs to.

Okay, get the sum in bytes, and assume it's in the $bytes variable.

PHP Code:


		
			
$megabytes = $bytes / (1024 * 1024);

$megabytes = number_format($megabytes, 2); // add commas and only 2 dec places

I have something like that here:

PHP Code:


		
			
$attachs['MBbytes'] = number_format($attachs['MBbytes'], 2);

But it won't round the last decimal up if the one before it is 5 or more, will it? It just chops it off there, right?

It won't round at all, probably.

Is there any way to make it round up or is what I got the best I can get?

<a href="http://www.php.net/round" target="_blank">http://www.php.net/round</a>

Quote:

Today at 06:01 PM Gary W said this in Post #14
http://www.php.net/round

I tried that already. Thanks, anyway.

And it doesn't work?

No, it rounds 2.12 MB to 2 MB and if I use number_format(attachsmb), 2), then it rounds it to 2.00. It must be the way I am trying to cache it.

round will still work. Look at the second argument.

Quote:

05-28-03 at 08:07 PM filburt1 said this in Post #18
round will still work. Look at the second argument.

You totally lost me now. What 2nd argument?

PHP Code:


		
			
$megabytes = $bytes / (1024 * 1024); 

$megabytes = number_format($megabytes, 2); // add commas and only 2 dec places

Already tried that and it doesn't work either.

There was a fine solution in HiveMail,
Chen is a really perfect php coder - clean and nice.

Nobody's a perfect coder...

Nope, I doen't believe you, Fil.
Chen has coded this and that and it's all so smooth, the functions and, oh, I just love it.

Quote:

Yesterday at 01:52 PM filburt1 said this in Post #23
Nobody's a perfect coder...

Agreed.

You see, gmarik, nobody is perfect.

That all depends on your idea of perfection. Maybe perfection for him [high]IS[/high] Chen's coding ability. Nothing wrong with that.

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01865 seconds Memory Usage 1,778KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (7)bbcode_php_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (26)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: