Post Reply 
Deleting Old Attachments
Author Message
Mr. Shizzy
ɯɹ˙ sɥızzʎ

Posts: 2,973.4020
Threads: 415
Joined: 21st Feb 2007
Reputation: -2.36574
E-Pigs: 160.1496
Offline
Post: #1
Deleting Old Attachments
I am going to go through all my Attachments here at EP and deleting obsolete files.

[Image: 339oha8.jpg]

I posted the thread in case there is something that someone doesn't want deleted.

Really though I only plan on deleting things like emulators/homebrew/plugins that have received numerous updates making the older revisions obsolete.

PSP 2001 [TA-088v2]: 6.39 ME-9.7
[Image: 4kly6c1.gif]
Sig by Mr_Nick666
28/06/2011 10:32 AM
Find all posts by this user Quote this message in a reply
Joom
WOOP
Worlds End

Posts: 4,206.7320
Threads: 417
Joined: 20th Mar 2009
Reputation: 5.41709
E-Pigs: 134.1772
Offline
Post: #2
RE: Deleting Old Attachments
Damn you have a lot.

[Image: ROVBdMh.png]
3DS Friend Code: 5000-6045-4964
28/06/2011 10:40 AM
Find all posts by this user Quote this message in a reply
Mr. Shizzy
ɯɹ˙ sɥızzʎ

Posts: 2,973.4020
Threads: 415
Joined: 21st Feb 2007
Reputation: -2.36574
E-Pigs: 160.1496
Offline
Post: #3
RE: Deleting Old Attachments
(28/06/2011 10:40 AM)Joom Wrote:  Damn you have a lot.

Yeah, I figured my attachments needed a good douche...     LOL   :P

PSP 2001 [TA-088v2]: 6.39 ME-9.7
[Image: 4kly6c1.gif]
Sig by Mr_Nick666
28/06/2011 10:49 AM
Find all posts by this user Quote this message in a reply
Mr. Shizzy
ɯɹ˙ sɥızzʎ

Posts: 2,973.4020
Threads: 415
Joined: 21st Feb 2007
Reputation: -2.36574
E-Pigs: 160.1496
Offline
Post: #4
RE: Deleting Old Attachments
Hmmm.  Deleted a couple files, and now my attachment stats look like this:

[Image: 21lj1c8.jpg]

That's weird..  Hmmm

PSP 2001 [TA-088v2]: 6.39 ME-9.7
[Image: 4kly6c1.gif]
Sig by Mr_Nick666
28/06/2011 10:58 AM
Find all posts by this user Quote this message in a reply
Joom
WOOP
Worlds End

Posts: 4,206.7320
Threads: 417
Joined: 20th Mar 2009
Reputation: 5.41709
E-Pigs: 134.1772
Offline
Post: #5
RE: Deleting Old Attachments
:|

How u use 144 GB o bandwidth?

[Image: ROVBdMh.png]
3DS Friend Code: 5000-6045-4964
28/06/2011 11:02 AM
Find all posts by this user Quote this message in a reply
I ♥ GUCCI
I ♥ POOP

Posts: 991.7700
Threads: 20
Joined: 4th Jun 2011
Reputation: 3.37413
E-Pigs: 28.4520
Offline
Post: #6
RE: Deleting Old Attachments
LOL:)

[Image: stickerw.png]
GUCCI?
Well that too! BUT Not exactly the brand GUCCI!
GUCCI is what I call the girl I'm in ♥ with :)
It's kind of like her pet name!
LOL :)
28/06/2011 11:09 AM
Find all posts by this user Quote this message in a reply
lembas
yuri princess

Posts: 4,365.2931
Threads: 184
Joined: 30th Apr 2008
Reputation: -2.56923
E-Pigs: 154.3525
Offline
Post: #7
RE: Deleting Old Attachments
holy bandwidth batman

I'm gay.
Spoiler for online game stuff:
[Image: 76561198003967361.png]
[Image: thelemmingbas.png]
3DS FC: 4184-1632-9353
Spoiler:
[Image: wQZsI.jpg]
Spoiler:
In the words of the wise trademark91:
windows Proud
28/06/2011 11:40 AM
Visit this user's website Find all posts by this user Quote this message in a reply
xBu
Jedi

Posts: 4,999.4590
Threads: 55
Joined: 15th Apr 2007
Reputation: 3.44876
E-Pigs: 44.0477
Offline
Post: #8
RE: Deleting Old Attachments
lol, damn. I don't have any....
28/06/2011 11:44 AM
Find all posts by this user Quote this message in a reply
ZiNgA BuRgA
Smart Alternative

Posts: 17,022.2988
Threads: 1,174
Joined: 19th Jan 2007
Reputation: -1.71391
E-Pigs: 446.1274
Offline
Post: #9
RE: Deleting Old Attachments
I don't really mind space usage, and there's enough bandwidth for now.

I have a feeling MyBB may be screwing up the bandwidth estimation from overflowing or similar.

EDIT: uh, I see the problem - looks like whoever coded the attachment statistics code had a brain fart:

PHP Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
	$end = $start + $perpage;
	$lower = $start+1;

	$query = $db->query("
		SELECT a.*, p.subject, p.dateline, t.tid, t.subject AS threadsubject
		FROM ".TABLE_PREFIX."attachments a
		LEFT JOIN ".TABLE_PREFIX."posts p ON (a.pid=p.pid)
		LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid)
		WHERE a.uid='".$mybb->user['uid']."'
		ORDER BY p.dateline DESC LIMIT {$start}, {$perpage}
	");

	$bandwidth = $totaldownloads = 0;
	while($attachment = $db->fetch_array($query))
	{
// ...
			// Add to bandwidth total
			$bandwidth += ($attachment['filesize'] * $attachment['downloads']);
			$totaldownloads += $attachment['downloads'];
	}


I presume the stats are different if you're viewing a different page?

The space used should be correct in the above picture.  If you're interested in the real stats for you:
# attachments: 235
Total # downloads: 91967
Estimated bandwidth usage (which is just # downloads × size of attachment): 135.76GB

(This post was last modified: 28/06/2011 04:21 PM by ZiNgA BuRgA.)
28/06/2011 04:11 PM
Visit this user's website Find all posts by this user Quote this message in a reply
bsanehi
Always use protection!

Posts: 988.2911
Threads: 151
Joined: 17th Jan 2010
Reputation: 1.21296
E-Pigs: 113.2728
Offline
Post: #10
RE: Deleting Old Attachments
Here is my attachment statistics........

[Image: bsanehi.png]

[Image: pluginslist2.png]
28/06/2011 04:32 PM
Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread:

 Quick Theme: