Required Attachment

[SOL00]

This add-on allows you to require an attachment with a specific extension for every forum.

I used it for a site with an picture gallery where every new pictures also needed a thread. To prevent users from posting empty thread, i write this add-on.

It's very easy to install and doesn't need any template changes.

Installation information on add-on:
Files edited: 0
Templates edited: 0
Files to upload: 2
Time to install: 5 minutes max

Please note you'll need to add a record for every forum you wish to require attachments in. The parent/child structure doesn't work.

This add-on has been linked to the attachment section of the forum so you can only select valid extensions.

[shadowevil]

screenshot/ demo ???

[Eagle Creek]

They have been posted :).

[Ntfu2]

Database error in vBulletin 3.6.0:

Invalid SQL:

SELECT forumid, title
FROM vb3_forumrequiredattachment
INNER JOIN vb3_forum USING(forumid);

MySQL Error : Column 'forumid' in field list is ambiguous

[taxick]

Hey.. It dont work :( Get SQL error :(

[SOL00]

Database error in vBulletin 3.6.0:

Invalid SQL:

SELECT forumid, title
FROM vb3_forumrequiredattachment
INNER JOIN vb3_forum USING(forumid);

MySQL Error : Column 'forumid' in field list is ambiguous
Fixed

[Hornstar]

If this works the way I think it does it will be awesome, because I have about 5 or so forums on my site where it is downloads only, so that means people have to upload an attachment. However people often ask questions which is annoying.

The only problem I would then face, is a few people still upload larger attachements to like rapidshare, so would you have a solution for them?

[SOL00]

Urhm, don't have a real solution for your problem mate.
You might want to edit my plugin so the attachment is only required for several groups.

After that, put the 'large file uploaders' in a specific group which isnt required to post attachments.

[Pitboss]

We're having a bit of an issue with this hack and I'm not sure why.

First of all we are running 3.6.1 so could this be a backwards compatibility issue?

Here is the issue:

Installed the hack. Install went fine. Added the forums we wanted to require attachments as directed.

Now though, every forum is requiring attachments, whether they were added or not. Checked database with phpmyadmin and the forum id is not listed in forumrequiredattachment and yet when trying to post in that forum the "Required Attachement Missing" screen comes up and stops everyone in their tracks.

We really love this hack as 90% of our forums should have files attached and this is a huge moderation saver however if it kills off the 10% of the forums where attachements are not required we'll have to stop using it which would really suck.

Ideas?

[jyajay]

I only have required attachments enabled for a few forums (just jpg) but still this mod wants attachments on every forum no matter if the usergroup is not allowed to upload in this forum or not.

Please fix this or I have to uninstall this mod!

[Jelmertjee]

yeah, i have the same problem.. great mod, just a little mistake, fix it please!

[manuelsechi]

same problem here, please help us :-)

[JohnBee]

Ah great idea... but it doesn't work and despite the complaints, has not been addressed.

[rabidkevin]

Hi, this still does not work based on selecting forums, it applies to the entire forum index

please address!

[Fearlessninja]

Waiting for this to work....then will install :)

[JulianD]

My forum needs this hack but it didn't work as expected. I just fixed it and I'm sharing my code with you... I haven't tested it for performance or other installations...

Replace the content of the 'Required Attachment check' plugin to:


if($type=='thread')
{

$q = "
SELECT r.forumid, IF(r.extensions LIKE concat( '%*', a.extension, '*%' ), '1', '0') AS ext
FROM forumrequiredattachment r
LEFT JOIN " . TABLE_PREFIX . "attachment a ON a.posthash = '" . $vbulletin->db->escape_string($post['posthash']) . "'
AND a.userid = " . $vbulletin->userinfo['userid'] . "
WHERE r.forumid ='" . $foruminfo['forumid'] . "'
ORDER BY a.attachmentid
";
$attachs = $vbulletin->db->query_first_slave($q);
if(sizeof($attachs) > 0 and $attachs['ext'] == '0')
$errors[] = $vbphrase['required_attachment_missing'];
}

[andrewy3k]

works great.. thanks julian

[andrewy3k]

this is the best hack ive ever installed for my board.. thanks a trillion...thanks to Julian of course .. please continue to make newer versions..

Suggestion:

Make it easier to add attachment requirements for each forum..

example..
https://vborg.vbsupport.ru/attachment.php?attachmentid=55064&d=1161700258

see how you can highlight attachment types.. have the same for forums :) instead of drop down.. that would be a HUGE improvement on an already awesome attachment.

[Magnumutz]

If this actually works, is great, cuz i've got a report section on my forum, and some users forget to attach screenshots.

SO, this would save both me and the users a lot of time !

[dutchbb]

SOL00 please update your hack with JulianD's post info!

[vijayninel]

Doesnt work on 3.8.4. Can someone update hack to work on 3.8 please.

[vijayninel]

Ok..apparently the database error occurs only if you have put a prefix before your database like vb_forumrequiredattachment.

Otherwise it is working fine with JulianD's plugin mod on vB 3.8.4. Without JulianD's mod it starts demanding attachments in all the forums even the ones which have not been selected.

Thanks so much for this. Installed. :)

[jluerken]

DB error on 3.8.4

Datenbankfehler in vBulletin 3.8.4:

Invalid SQL:
SELECT a.attachmentid
FROM vb305_attachment a
INNER JOIN forumrequiredattachment r ON r.forumid ='57' AND r.extensions LIKE concat( '%*', a.extension, '*%' )
WHERE a.posthash = 'ccb9d7cb0f8eeef98ac84df3ef418d69'
AND a.userid = 11981
ORDER BY a.attachmentid;

MySQL-Fehler : Table 'db274701_1.forumrequiredattachment' doesn't exist
Fehler-Nr. : 1146
Fehler-Zeit : Wednesday, 03.03.2010 @ 13:31:22

Forum has prefix option activated. Any idea?