vb.org Archive - Attachments as files

Page 30 of 41

« First

Last »

Show 40 post(s) from this thread on one page

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

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - Attachments as files (https://vborg.vbsupport.ru/showthread.php?t=35193)

Stud_Muffin

03-21-2003 11:33 AM

Quote:

03-12-03 at 12:52 PM GamerForums said this in Post #290
OK I've found a solution for anyone wishing to remove this hack so that they can continue with versions 2.3.x onwards.

BY DOING THIS YOU WILL LOSE ALL OF YOUR ATTACHMENTS

Uninstall the hack using the install file.

Run this query...

Code:

DROP TABLE IF EXISTS attachment; CREATE TABLE attachment ( attachmentid smallint(5) unsigned NOT NULL auto_increment, userid int(10) unsigned NOT NULL, dateline int(10) unsigned NOT NULL, filename varchar(100) NOT NULL, filedata mediumtext NOT NULL, visible smallint(5) unsigned NOT NULL, counter smallint(5) unsigned NOT NULL, PRIMARY KEY (attachmentid) );

You can now delete the folder with attachments as files inside.

You will lose ALL attachments in your BB, do not blame me if what I tell you to do here messes anything in your site up - MAKE A BACKUP.

Over and out. :)

Did that, lots of files to sieve through now :cry:

FleaBag

03-21-2003 04:04 PM

What do you mean?

Stud_Muffin

03-21-2003 04:08 PM

I still have the attachments on my server but not on the forum. Just loads of files like so. beca544936ecfacf43c7076feb61d140.file so i need to load them up to see if i need to keep or delete them, that was all.

FleaBag

03-21-2003 04:10 PM

Ah I see what you mean. I didn't go to that much effort... My site has been open for 15 months, so there was a fair few to look through... I just deleted them all. :(

Bison

03-21-2003 06:39 PM

IMO ... this thread and this hack needs to be removed since no one's gonna help anyone with this !

wolfman

03-22-2003 02:53 PM

Well I am glad I was able to see this before installing this hack.

wooolF[RM]

03-29-2003 12:46 PM

]or just run 2.2.9 :D and no problems

storing all attachments in the database is pain in the ass as for the speed of it and as for backuping

FleaBag

03-29-2003 01:45 PM

But still, your attachments won't work in version 3.x.

Bison

03-29-2003 07:17 PM

Quote:

Today at 09:46 AM wooolF[RM] said this in Post #297
or just run 2.2.9 :D and no problems

storing all attachments in the database is pain in the ass as for the speed of it and as for backuping

I Guess you don't plan on updating to vB3! :smoke:

wooolF[RM]

03-29-2003 09:12 PM

]exactly my point, Rolodex! ;) :D

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

Page 30 of 41

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02670 seconds Memory Usage 1,735KB 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 (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: