Attachments as files

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

[kidney]

I seem llike I can't upload anything anymore, Can anyone help!!
I re-applied the hack, and still no result.....
I'm running a heavelly hacked 2.2.3.
I can send you my function.php files if required.

[Freddie Bingham]

ALTER TABLE attachment DROP filedata

..if I was you I wouldn't do that though as that can only cause you problems when you upgrade to v3.0

This would be better:

UPDATE attachment SET filedata = ''

[waddy]

Thanks Freddie,

I was concerned about dropping the filedata column = issues on future updates.

I hope v 3.0 has Attachments as files. My database has never run better since I did this hack.

[Freddie Bingham]

It might give you the option to choose at your whim

[NitroSimSev]

PPN - I am currently running PHP portals and I am trying to get the attachment mod to work with a news program. Below is a block of code I would like to modify to get it to work. right now the images do not show up:

function centerblocks_topstories_block($row) {
include("config.php");
global $DB_site,$dateformat,$bburl;

$result=$DB_site->query("SELECT dateline,title,threadid FROM thread WHERE forumid=$topStoryForum ORDER BY dateline DESC LIMIT $topStoryNum");


$cc=1;
while ($topStory=$DB_site->fetch_array($result)) {
$postdate{$cc}=vbdate($dateformat,$topStory[dateline]);
$topStoryTitle{$cc}=$topStory[title];
$topStoryID{$cc}=$topStory[threadid];

$result1=$DB_site->query("SELECT pagetext,postid FROM post WHERE threadid=$topStory[threadid]");
$postinfo=$DB_site->fetch_array($result1);
$topStoryTeaser{$cc}=$postinfo[pagetext];
$topStoryImage{$cc}="$bburl/attachment.php?s=&postid=$postinfo[postid]";

The
$topStoryImage{$cc}="$bburl/attachment.php?s=&postid=$postinfo[postid]";
is the part of code I cant seem to get to work right. Any Ideas?

[waddy]

BUG ? : When Editing or Delelting a thread with an attachment i am now getting this in the header of the page

Warning: Unlink failed (No such file or directory) in /users/waddy/www.xp-erience.org/forum/admin/functions.php on line 1696

ALSO :

One of my users is uploading an attachment, yet when we try to view the image we get this error

Warning: stat failed for /users/waddy/attchvb/958a09ca32b93cb743bf90ce001d58c0.file (errno=2 - No such file or directory) in /users/waddy/www.xp-erience.org/forum/attachment.php on line 60

[HellRazor]

The only problem I am having is that once you select the file for uploading, the "Use Custom Avatar?" radio button turns off. People often miss that, and what happens is the avatar defaults to the first avatar in the normal list.

Is there any way to make this default to "use custom avatar" when a file is uploaded?

[Wayne2k1.com]

Originally posted by HellRazor
The only problem I am having is that once you select the file for uploading, the "Use Custom Avatar?" radio button turns off. People often miss that, and what happens is the avatar defaults to the first avatar in the normal list.

Is there any way to make this default to "use custom avatar" when a file is uploaded?

Same problem 4 me...

[Scott MacVicar]

I'll look into this now, I presume that the avatar upload uses the accept_upload function within the admin panel and it might require a bit of editing.

[xware]

Originally posted by HellRazor
The only problem I am having is that once you select the file for uploading, the "Use Custom Avatar?" radio button turns off. People often miss that, and what happens is the avatar defaults to the first avatar in the normal list.

Is there any way to make this default to "use custom avatar" when a file is uploaded?

Same to me.
IS a bug?