The Arcive of Official vBulletin Modifications Site.

Attachment Database · **Released**: 11-16-2002

It's self-explanatory and easy to install. You can view a demo here: http://forums.ffdiscovery.com/attach.php

Instalation
===========

Installation is extremely easy. First open the attach.php file and check the configuration. It's designed to work with the private attachments hack and the attachment viewer. After checking the config, upload the file to your forums directory, create a new template called attachment with the contents of the attachment.txt file and a new template called attachmentbit with the contents of the attachmentbit.txt file. That's it.

Feedback is always appreciated. You can get assistance, if needed, either through an e-mail or through my forums.

Oblivion Knight · #72 05-30-2003, 07:51 PM

I love the concept of the hack, but I had no idea where to place a link to it..
It's an awkward thing to place since it's only really an archive and doesn't add any kind of functionality to the forums..

I placed it below my $logincode in the welcome panel for now..

Excellent work though!

[Edit]
There still seems to be an issue with the amount of MySQL load this requires.
I'm using the latest file and ran the query, but I came to the server this morning and it was running at snails pace. Also on the Microstats, the MySQL % had shot up from around an average of 50% to a whopping 95%+. Upon removal, both the speed and MySQL load statistic returned back to normal.

Anyone wanting to remove the query can use this:
ALTER TABLE `post` DROP INDEX ( `attachmentid` )

tkeil69575 · #73 07-14-2003, 07:54 AM

hi rake,
nice hack.

however, there seems to be a small problem with the page link. if you klick on "last page" you come to e.g. page 55. the listing is blank. the previous 5 or 6 page also. any ideas?

tina

Steve123 · #74 07-31-2003, 10:27 PM

Ive followed all the instructions..

It makes me server load jump to 100%...

gota have to uninstall.. o well it looked good :S

Steve123 · #75 07-31-2003, 10:34 PM

ALTER TABLE `post` DROP INDEX ( `attachmentid` )

ERROR 1064: You have an error in your SQL syntax near '( `attachmentid` )' at line 1

Oblivion Knight · #76 08-01-2003, 06:34 AM

Quote:

Today at 12:34 AM Steve123 said this in Post #74
ALTER TABLE `post` DROP INDEX ( `attachmentid` )

ERROR 1064: You have an error in your SQL syntax near '( `attachmentid` )' at line 1

There's nothing wrong with the syntax.. All it's doing is reversing the original query that was run.

Did the original query run successfully?
ALTER TABLE `post` ADD INDEX ( `attachmentid` )

gmarik · #77 08-02-2003, 12:04 PM

It's good to see it working now.

Johnny · #78 02-07-2004, 01:37 PM

can someone tell me how I can limit this so it displays attatcments from certain forums instead of all of them

350Chevy · #79 03-22-2004, 05:11 PM

Any updates on this that wont crash my server and have the options to manage the attachments (ie. delete...prun)?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04816 seconds Memory Usage 2,281KB Queries Executed 23 (?)
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)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 (2)pagenav_pagelink (9)post_thanks_box (9)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (9)post_thanks_postbit_info (8)postbit (9)postbit_onlinestatus (9)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 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!