View Issue Details

IDProjectCategoryView StatusLast Update
0000027XMB1Metapublic2008-11-19 23:36
Reportermiqrogroove Assigned Tomiqrogroove  
PrioritynormalSeverityfeatureReproducibilityN/A
Status closedResolutionfixed 
Target Version1.9.11Fixed in Version1.9.11 
Summary0000027: Overhaul the Attachment System
DescriptionXMB desperately needs a new file attachment system. All aspects will be considered.
Additional Informationhttp://forums.xmbforum.com/viewthread.php?tid=765278

Official schema change:

ALTER TABLE `$table_attachments` ADD `img_size` VARCHAR( 9 ) NOT NULL ;
ALTER TABLE `$table_attachments` ADD `parentid` INT NOT NULL DEFAULT '0';
ALTER TABLE `$table_attachments` ADD `subdir` VARCHAR( 15 ) NOT NULL ;
ALTER TABLE `$table_attachments` ADD `uid` INT NOT NULL DEFAULT '0';
ALTER TABLE `$table_attachments` ADD `updatetime` TIMESTAMP NOT NULL default current_timestamp;
ALTER TABLE `$table_attachments` ADD INDEX ( `parentid` ) ;
ALTER TABLE `$table_attachments` ADD INDEX ( `uid` ) ;

ALTER TABLE `$table_attachments` DROP `tid`

ALTER TABLE `$table_settings` ADD `attach_remote_images` SET( 'on', 'off' ) NOT NULL DEFAULT 'off';
ALTER TABLE `$table_settings` ADD `files_min_disk_size` MEDIUMINT NOT NULL DEFAULT '9216';
ALTER TABLE `$table_settings` ADD `files_storage_path` VARCHAR( 100 ) NOT NULL ;
ALTER TABLE `$table_settings` ADD `files_subdir_format` TINYINT NOT NULL DEFAULT '1';
ALTER TABLE `$table_settings` ADD `file_url_format` TINYINT NOT NULL DEFAULT '1';
ALTER TABLE `$table_settings` ADD `files_virtual_url` VARCHAR( 60 ) NOT NULL ;
ALTER TABLE `$table_settings` ADD `filesperpost` TINYINT NOT NULL DEFAULT '10';
ALTER TABLE `$table_settings` ADD `max_image_size` VARCHAR( 9 ) NOT NULL DEFAULT '1000x1000';
ALTER TABLE `$table_settings` ADD `max_thumb_size` VARCHAR( 9 ) NOT NULL DEFAULT '200x200';
TagsNo tags attached.
MySQL Version
PHP Version
Web Server
Browser
FlagsSchema Updates
Original Reporter
SVN Revision1281

Relationships

parent of 0000019 closedmiqrogroove Enable Attachment Persistence for Post Previews 
parent of 0000028 closedmiqrogroove Image Attachment Limit 
parent of 0000029 closedmiqrogroove Multiple Attachments 
parent of 0000030 closedmiqrogroove Inline Attachment Caching 
parent of 0000031 closedmiqrogroove Thumbnails for Attached Images 
parent of 0000032 closedmiqrogroove Disk Storage Option for Attachments 
parent of 0000128 closedmiqrogroove Thumbnails for Hotlinked Images 
parent of 0000135 closedmiqrogroove "Pretty" URLs for Attachments 
parent of 0000137 closedmiqrogroove Add New Attachment Options to Admin Panel 
parent of 0000116 closedmiqrogroove Check for Output Corruption for Attachments 
parent of 0000140 closedmiqrogroove Links from Virtual URL Errors Need to Point to $full_url 

Activities

miqrogroove

2008-08-21 10:57

administrator   ~0000053

topicadmin needs work

miqrogroove

2008-08-22 02:48

administrator   ~0000054

The attachment system is officially overhauled. Lots of alpha testing and debugging are in store, I am sure.

miqrogroove

2008-11-19 23:36

administrator   ~0000072

Changing the default image size limit because older PHP installations have a memory limit of 8M.

Issue History

Date Modified Username Field Change
2008-07-21 23:03 miqrogroove New Issue
2008-07-21 23:03 miqrogroove Flags => Schema Updates
2008-07-21 23:05 miqrogroove Assigned To => miqrogroove
2008-07-21 23:05 miqrogroove Status new => assigned
2008-07-21 23:05 miqrogroove Relationship added parent of 0000019
2008-07-21 23:11 miqrogroove Relationship added parent of 0000028
2008-07-21 23:14 miqrogroove Relationship added parent of 0000029
2008-07-21 23:36 miqrogroove Relationship added parent of 0000030
2008-07-21 23:36 miqrogroove ETA none => > 1 month
2008-07-21 23:37 miqrogroove Projection none => redesign
2008-07-21 23:47 miqrogroove Relationship added parent of 0000031
2008-07-22 00:02 miqrogroove Relationship added parent of 0000032
2008-08-18 20:40 miqrogroove Relationship added parent of 0000128
2008-08-18 21:12 miqrogroove Additional Information Updated
2008-08-18 22:34 miqrogroove Additional Information Updated
2008-08-18 23:38 miqrogroove Additional Information Updated
2008-08-19 07:27 miqrogroove Additional Information Updated
2008-08-19 08:37 miqrogroove Additional Information Updated
2008-08-19 10:20 miqrogroove Additional Information Updated
2008-08-19 12:40 miqrogroove Additional Information Updated
2008-08-19 15:19 miqrogroove Relationship added parent of 0000135
2008-08-19 18:28 miqrogroove Relationship added parent of 0000137
2008-08-19 18:33 miqrogroove Additional Information Updated
2008-08-19 18:33 miqrogroove Additional Information Updated
2008-08-19 23:21 miqrogroove Additional Information Updated
2008-08-20 13:28 miqrogroove Additional Information Updated
2008-08-20 13:28 miqrogroove Additional Information Updated
2008-08-20 13:43 miqrogroove Additional Information Updated
2008-08-20 14:54 miqrogroove Relationship added parent of 0000116
2008-08-20 17:30 miqrogroove Additional Information Updated
2008-08-20 17:30 miqrogroove Additional Information Updated
2008-08-20 18:35 miqrogroove Additional Information Updated
2008-08-20 18:43 miqrogroove Additional Information Updated
2008-08-21 09:35 miqrogroove Additional Information Updated
2008-08-21 10:23 miqrogroove SVN Revision => 1276
2008-08-21 10:23 miqrogroove Status assigned => resolved
2008-08-21 10:23 miqrogroove Fixed in Version => 1.9.11
2008-08-21 10:23 miqrogroove Resolution open => fixed
2008-08-21 10:57 miqrogroove Note Added: 0000053
2008-08-21 10:57 miqrogroove Status resolved => assigned
2008-08-21 18:41 miqrogroove Relationship added parent of 0000140
2008-08-22 02:48 miqrogroove SVN Revision 1276 => 1281
2008-08-22 02:48 miqrogroove Note Added: 0000054
2008-08-22 02:48 miqrogroove Status assigned => resolved
2008-08-22 03:39 miqrogroove Status resolved => closed
2008-11-19 23:36 miqrogroove Note Added: 0000072
2008-11-19 23:36 miqrogroove Additional Information Updated