The Arcive of Official vBulletin Modifications Site.

About Developer · **Released**: 02-17-2002

Well after alot of time leaving it in the beta hacks forums without any problems, I'm now moving it to the Full Releases, I'm satisfied that there isn't any bugs that need to be addressed. Thanks to Jawelin he pointed out most of the mistakes through alot of his testing.
I've attached it as an installer file here, as it needs to make changes to the database. Two new rows to settings and a new column in the attachment table.

Scott

Updated some more

Note the > is missing off the bottom of the file after the ?, add it before trying to install

ranger2kxlt · #**352** 06-21-2003, 02:20 PM

Was wondering if this hack is kinda like what vb3 does now? It saves attachments as files and your database size will be greatly reduced correct? But Diskspace will be increase??

The main benefit that i can see and want is ease of transfering to a new server without dealing with the attachments in the database. Let me know.

Sabrina · #**353** 06-23-2003, 09:55 PM

Oh my god, you do not know what this hack has done to my forum! THANK YOU SO MUCH!

I had to disable attachments due to such a large database, anyways, this is a miracle hack!!

Very good work! Best Hack Ever Made!!!

:banana: :banana: :banana:

john_rsd · #**354** 06-26-2003, 03:43 PM

After some problems initially the hack now works on my 2.3.0 test site & I have tried attach, edit & delete attachments.

Although I delete an attachment in a post, or delete the whole post itself, the file attachment still remains in the /home/mystuff/attachments folder

Why does it not delete the attachments at the same time as the thread?

Have I missed something in editing another file?

Thanks

john

skc · #**355** 06-30-2003, 02:22 PM

any idea when the attachments as files hack will be ready for vb3?

WCW Fan · #**356** 07-15-2003, 02:48 AM

Im just wondering if this is even worth installing alot of people have had errors so is it worth installing

ontherun · #**357** 07-25-2003, 05:32 PM

This is a excelent hack, but I need to uninstall it and placed files back into the data base to upgrade to vB 3.0 Beta 4 on my development site.

Is there a easy way ?

ontherun · #**358** 07-26-2003, 05:55 PM

Quote:

06-30-03 at 08:22 AM skc said this in Post #354
any idea when the attachments as files hack will be ready for vb3?

skc vB 3.0 has this hack built in as of beta 4

bitbender · #**359** 08-07-2003, 04:57 AM

WOOOOOTTT!!!

FIxed as of Beta 5 for me !!

W000TTT!!

PARTY ON !!

( i know, it doesn't take much for me)

shorty · #**360** 08-07-2003, 05:32 AM

Quote:

Today at 06:57 AM bitbender said this in Post #358
WOOOOOTTT!!!

FIxed as of Beta 5 for me !!

W000TTT!!

PARTY ON !! ( i know, it doesn't take much for me)

If this is true.. Im installing this hack tonight!

Thanks for the information BB that it works with beta 5.

bitbender · #**361** 08-07-2003, 02:36 PM

Quote:

Today at 01:32 AM shorty said this in Post #359
If this is true.. Im installing this hack tonight!

Thanks for the information BB that it works with beta 5.

Yep, it IS true !! It was Soo true I did it three times!! (ok, so I couldn't sleep last nite)

Be SURE to follow the instructions closely, and be patient.

MY issue was that even thou I altered the attachpath variable to be the CORRECT value, the cache was still point back to the place I restored it FROM (an invalid path).

So, I flushed cache, and ran again, and log and behold, it worked just fine.

So....here is what I did.

Create a backup (I have a cron script, but it's the same as reccomended by the VB3.0 upgrade)
Create a database for VB 3.0 (if your host only allows one, of course you cannot do this)
Restore the new DB using the backup just made (Skip this is you only have one DB available to you)
Using PHPmyAdmin, add the field filedata back to the attachments table;
Code:
```
ALTER TABLE attachment ADD filedata mediumtext NOT NULL
```
Run Repair, and Optimize on the attachment table using the functions in PHPMyAdmin
Again, using PHPmyAdmin, select the settings table, and locate the variable attachpath Edit this to ensure you have the CORRECT path there. What's key here is that it is an absolute path;
Code:
```
For my installation it was;
/home/virtual/site22/fst/var/www/html/vb30/attach_folder
```
Execute admin/attachment_upgrade.php - On the BBF test Server, a full copy of VB 2.3.0 was already place in the VB30 directory structure, so that prior to the VB30 cutover I could still access it as 2.3.0. The script attachment_upgrade.php depends on the vb 2.x struture to be intact and in place to work correctly. Believe me, I called it's bluff.
Once That completed, I proceeded thru the install/upgrade.php, no issues, or worries, straight thru. It DID take some time, as 1.3 GB worth of attachment files takes a bit of time.

Next up? Pushing them BACK out to the file system, along with the Av's!

PARTY on VB!! I'm renewing today! Totally pleased, am I!

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.08707 seconds Memory Usage 2,308KB 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_code (3)bbcode_quote (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 (4)pagenav_pagelink (1)pagenav_pagelinkrel (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
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!