vb.org Archive - Add-On Releases - Required Attachment

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

- vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)

- - Add-On Releases - Required Attachment (https://vborg.vbsupport.ru/showthread.php?t=129844)

SOL00

10-23-2006 10:00 PM

Required Attachment

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

10-24-2006 01:29 PM

screenshot/ demo ???

Eagle Creek

10-24-2006 01:32 PM

They have been posted :).

Ntfu2

10-24-2006 02:23 PM

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

10-24-2006 06:11 PM

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

SOL00

10-25-2006 05:55 AM

Quote:

Originally Posted by Ntfu2

Fixed

Hornstar

10-25-2006 09:26 AM

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

10-26-2006 06:11 AM

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

11-04-2006 08:51 PM

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

12-09-2006 04:47 PM

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

01-19-2007 11:40 AM

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

manuelsechi

01-21-2007 11:34 AM

same problem here, please help us :-)

JohnBee

02-10-2007 02:35 AM

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

rabidkevin

03-26-2007 01:36 AM

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

please address!

Fearlessninja

03-26-2007 02:22 AM

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

JulianD

07-06-2007 04:45 AM

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:

PHP Code:


		
			
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

10-27-2007 06:15 AM

works great.. thanks julian

andrewy3k

10-28-2007 07:20 AM

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/attachmen...4&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

10-28-2007 05:22 PM

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

02-07-2008 10:06 PM

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

vijayninel

01-24-2010 11:24 AM

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

vijayninel

02-24-2010 11:46 AM

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

03-03-2010 10:33 AM

DB error on 3.8.4

Datenbankfehler in vBulletin 3.8.4:

Code:

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?

All times are GMT. The time now is 06:25 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01208 seconds Memory Usage 1,765KB 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 (1)bbcode_code_printable (1)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (23)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: