Limit Attachments Per Time

Allows you to limit the number of attachments one can post in X (defined) hours.
There is also an option to exclude mods and admins from this limit.

To install this hack download the attached file (lapt.hack.php), upload to your /admin folder and use vbHacker.

A demo (screen shot of the new settings in the Admin CP) can be found here:
https://vborg.vbsupport.ru/attachmen...&postid=232927

[Admin]

Ok, it tells you to find this, right?

    // sort attachement
    if ($permissions[canpostattachment] and trim($attachment)!="none" and trim($attachment)!="" and trim($attachment_name)!="") {

Disregard the first line (the // comment), and just look for the second line.

[Boofo]

This is why I couldn't find it. I had to narrow the search down to just canpostattachment. Usually any code you say to look for is right on target for me. I must have installed some hack somewhere that changed something.

Sorry I bothered you with it. I feel kindof stupid now.

if ($permissions['canpostattachment'] and trim($attachment) != 'none' and trim($attachment) != '' and trim($attachment_name) != '') {

Originally posted by FireFly
Ok, it tells you to find this, right?

    // sort attachement
    if ($permissions[canpostattachment] and trim($attachment)!="none" and trim($attachment)!="" and trim($attachment_name)!="") {

Disregard the first line (the // comment), and just look for the second line.

[Boofo]

Here's the code I found it in in newreply. There are actually 2 places here that have that code. I should replace the first one?

case 'new':
				if ($permissions['canpostattachment'] and trim($attachment) != 'none' and trim($attachment) != '' and trim($attachment_name) != '') {
					$attachmentid = acceptupload(1);
					$DB_site->query("
	DELETE FROM attachment
	WHERE attachmentid = $oldattachid
					");
					$postinfo = $DB_site->query_first("
	SELECT attachmentid, filename FROM attachment
	WHERE attachmentid = $attachmentid
					");
				}
				break;
			default:
				$attachmentid = $oldattachid;
		}
	} elseif ($permissions['canpostattachment'] and trim($attachment) != 'none' and trim($attachment) != '' and trim($attachment_name) != '') {
		$attachmentid = acceptupload(1);
		$oldattachid = true;
		$postinfo = $DB_site->query_first('
			SELECT attachmentid, filename FROM attachment
			WHERE attachmentid = '.intval($attachmentid).' AND visible = 0
		');

[Admin]

Ahh, you installed another hack that changes that part (my Save Attachments on Preview). Sorry.

[Boofo]

Guess I should have installed this one first huh? Was I right, only the first part under case new gets changed? Thanks for helping me figure it out though. I was starting to think I was losing the ability to install hacks.

Originally posted by FireFly
Ahh, you installed another hack that changes that part (my Save Attachments on Preview). Sorry.

[Admin]

I think you only need to update the 'new' case, but I'm not sure.

[Boofo]

Well, the board didn't blow up or lock me out, so I think we did it. The options are there in the Admin settings so I guess that means it is working? Thanks, Chen, for all of your help on this one.

BTW: PM on the way.

Originally posted by FireFly
I think you only need to update the 'new' case, but I'm not sure.

[blazin]

i have had this hack installed for quite some time, but ecently it has taken the forum very long to post a new thread or submit a reply.

I found out the slowness was due to this hack, particulary this line of code:

$attachcount = $DB_site->query_first('SELECT COUNT(*) AS total FROM attachment WHERE userid='.$bbuserinfo['userid'].' AND dateline>('.time().'-3600*'.$limitattachtime.')');

My attachment table is about 370MB with 7,700 records. When I make a simple query to this table in phpmyadmin, its very slow to respond also.

The rest of the site is extremely fast, any suggestions?

[blazin]

any ideas on the above? anyone?

[pimpfelix]

Is this hack available for 3.6?