Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 2.x > vBulletin 2.x Full Releases
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Create files from attachments Details »»
Create files from attachments
Version: 1.00, by Scott MacVicar Scott MacVicar is offline
Developer Last Online: Mar 2016 Show Printable Version Email this Page

Version: 2.2.x Rating:
Released: 03-04-2002 Last Update: Never Installs: 24
 
No support by the author.

This is not like the attachments as files hack, it is simply a way to import files from the attachment table to real files for whatever reason, maybe you just wanted an actualy backup of the files instead of the database.

Simply upload the file into your admin directory.

Open up /admin/index.php

look for

PHP Code:
makenavoption("Back-up Database","backup.php?action=choose","<br>"); 
below it add

PHP Code:
makenavoption("Export Attachments","attachment_export.php?action=import","<br>"); 
done

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #12  
Old 03-06-2002, 10:28 AM
Scott MacVicar Scott MacVicar is offline
 
Join Date: Oct 2001
Location: Glasgow, Scotland
Posts: 1,199
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

nope thats definately beyhond the limitations of php, yes it wouldn't be hard to zip a couple of files, but it would have a limit of about 30mb worth of files as if you tried to zip any more i'm sure that php would run out of memory.

You can simply tar then gzip it in shell

tar -cvf attachments.tar attachments
gzip attachments.tar

and you get attachments.tar.gz
Reply With Quote
  #13  
Old 03-06-2002, 06:56 PM
Tim Wheatley's Avatar
Tim Wheatley Tim Wheatley is offline
 
Join Date: Nov 2001
Location: England
Posts: 489
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Does this export all files, or can you choose only certain attachments? I don't want people to be able to download all the file without having to do some through the board (because it gives download counts).
Reply With Quote
  #14  
Old 03-06-2002, 07:43 PM
Scott MacVicar Scott MacVicar is offline
 
Join Date: Oct 2001
Location: Glasgow, Scotland
Posts: 1,199
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It exports all files, though I'm workin on an attachment manager which allows you to manipulate attachments via the admin panel, delete attachments, view attachments, rename attachment, make attachment to file or upload a new attachment. You can also sort the attachments via size and search and other things really.
Reply With Quote
  #15  
Old 03-07-2002, 07:25 PM
Tim Wheatley's Avatar
Tim Wheatley Tim Wheatley is offline
 
Join Date: Nov 2001
Location: England
Posts: 489
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Oh that's great thanks

If you need a beta tester let me know
Reply With Quote
  #16  
Old 03-07-2002, 08:56 PM
Scrooge Scrooge is offline
 
Join Date: Nov 2001
Posts: 40
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm getting the following error:

Warning: fopen("/home/reefaqua/public_html/forums/attachments/hermit crab small.jpg", "wb") - Permission denied in /home/reefaqua/public_html/forums/admin/attachment_export.php on line 32

Warning: Supplied argument is not a valid File-Handle resource in /home/reefaqua/public_html/forums/admin/attachment_export.php on line 33

Any ideas?
Reply With Quote
  #17  
Old 03-07-2002, 09:59 PM
Scott MacVicar Scott MacVicar is offline
 
Join Date: Oct 2001
Location: Glasgow, Scotland
Posts: 1,199
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

chmod the attachments folder to 666
Reply With Quote
  #18  
Old 03-08-2002, 12:07 PM
Admin's Avatar
Admin Admin is offline
Coder
 
Join Date: Oct 2023
Location: Server
Posts: 1
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

w00t now I have a huge folder with all attachments. That was fun...
Reply With Quote
  #19  
Old 03-10-2002, 10:49 AM
eva2000's Avatar
eva2000 eva2000 is offline
 
Join Date: Oct 2001
Location: Brisbane, Australia
Posts: 577
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

PPN i love this hack!!

i wanted this for sooooooooooooo long.. actually check out my sig request at https://vborg.vbsupport.ru/showthrea...threadid=32024

maybe a further extension of this hack ?
Reply With Quote
  #20  
Old 03-10-2002, 10:56 AM
eva2000's Avatar
eva2000 eva2000 is offline
 
Join Date: Oct 2001
Location: Brisbane, Australia
Posts: 577
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

does this hack actually delete the original attachments in the database or keeps them after exporting?

looked at my attachment table and it's 225mb in size!
Reply With Quote
  #21  
Old 03-10-2002, 10:58 AM
Scott MacVicar Scott MacVicar is offline
 
Join Date: Oct 2001
Location: Glasgow, Scotland
Posts: 1,199
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It leaves them in the database though if you want to have all attachments as files instead ot the databse then look in my huge long sig and the attachments as files imports all the attachments and when you upload attachments it puts them into a folder.

I could do the forum gallery hack but I have too little time spread too thinly (is that a word?)
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 10:07 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.04235 seconds
  • Memory Usage 2,301KB
  • Queries Executed 27 (?)
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
  • (2)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)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_postinfo_query
  • fetch_postinfo
  • 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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete