Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 01-26-2009, 07:57 PM
Xtrato's Avatar
Xtrato Xtrato is offline
 
Join Date: Feb 2005
Location: New Jersey
Posts: 510
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Attachemnts outside DB

Is there a hack that allows this? an attachment outside the actual database, im helping a customer and his old wm didnt installed something , so his database is 700MB!!! , its crazy.. hard time porting it over..

So is there a hack that does this, saving attachments outside database.

Thanks you for your time.

--------------- Added [DATE]1233007200[/DATE] at [TIME]1233007200[/TIME] ---------------

i think i found where..
However , now how do i move the attachments FROM database to like some other place , yet still retaining the post and images.

Thanks
Reply With Quote
  #2  
Old 01-26-2009, 08:05 PM
cellarius's Avatar
cellarius cellarius is offline
 
Join Date: Aug 2005
Posts: 1,987
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

That's basic vB functionality, no need for a mod. Go to AdminCP, Attachments, the last menu entry there (dont know exact english phrasing, mine is German). Something like Save mode. There you can move the attachments from the database to the file system and vice versa.

Nothing will break if you use this. After you moved the attachments to file system, you there can move them to another folder, too.
Reply With Quote
  #3  
Old 01-26-2009, 08:15 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You need to create a folder first to move them to. Make sure to chmod it to 777 and it should be above your forum root. Then just go to Attachments > Attachment Storage Type > Move to Filesystem (or something like that) and it will ask for where and you put in the full path (/home/yoursite/attachments) and then Continue
Reply With Quote
  #4  
Old 01-26-2009, 09:15 PM
Xtrato's Avatar
Xtrato Xtrato is offline
 
Join Date: Feb 2005
Location: New Jersey
Posts: 510
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

ok thank you both

another quick question, will the "Current" attachments be moved from the database into the newly created folder or no?

thanks
Reply With Quote
  #5  
Old 01-26-2009, 10:57 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yes they will be moved.
Reply With Quote
  #6  
Old 01-26-2009, 11:06 PM
Xtrato's Avatar
Xtrato Xtrato is offline
 
Join Date: Feb 2005
Location: New Jersey
Posts: 510
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Great stuff, thanks for the info! , hopefuly wont take years.
Reply With Quote
  #7  
Old 01-27-2009, 04:03 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Also, you should place the attachments directory behind the web root (i.e. /home/user/attachments, not /home/user/public_html/attachments).
Reply With Quote
  #8  
Old 02-04-2009, 05:29 PM
Xtrato's Avatar
Xtrato Xtrato is offline
 
Join Date: Feb 2005
Location: New Jersey
Posts: 510
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

oh ,

i already moved them to pubilc_html/etc/ , if i change directories , will it also move the files once again?

thanks
Reply With Quote
  #9  
Old 02-04-2009, 05:42 PM
lasto lasto is offline
 
Join Date: Jan 2002
Posts: 1,514
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Dismounted View Post
Also, you should place the attachments directory behind the web root (i.e. /home/user/attachments, not /home/user/public_html/attachments).
Can u explain why - and will members still be able to access that Dir - reason asking is because i have my attachment folder inside the VB folder.

Cheers
Reply With Quote
  #10  
Old 02-04-2009, 08:18 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

From the manual:

Quote:
The attachment file path is the location on your server that you wish to store attachments in. We suggest you create a path that is above your web root, which means a directory that is not below public_html. If you wish to create the directory in your web root, we then suggest you place a .htaccess file to block people from accessing it directly. If you do not do this, then anyone will be able to open your attachments directly by navigating this directory in their browser.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 08:20 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04224 seconds
  • Memory Usage 2,243KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete