View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000027 | XMB1 | Meta | public | 2008-07-21 23:03 | 2008-11-19 23:36 |
| Reporter | miqrogroove | Assigned To | miqrogroove | ||
| Priority | normal | Severity | feature | Reproducibility | N/A |
| Status | closed | Resolution | fixed | ||
| Target Version | 1.9.11 | Fixed in Version | 1.9.11 | ||
| Summary | 0000027: Overhaul the Attachment System | ||||
| Description | XMB desperately needs a new file attachment system. All aspects will be considered. | ||||
| Additional Information | http://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'; | ||||
| Tags | No tags attached. | ||||
| MySQL Version | |||||
| PHP Version | |||||
| Web Server | |||||
| Browser | |||||
| Flags | Schema Updates | ||||
| Original Reporter | |||||
| SVN Revision | 1281 | ||||
| parent of | 0000019 | closed | miqrogroove | Enable Attachment Persistence for Post Previews |
| parent of | 0000028 | closed | miqrogroove | Image Attachment Limit |
| parent of | 0000029 | closed | miqrogroove | Multiple Attachments |
| parent of | 0000030 | closed | miqrogroove | Inline Attachment Caching |
| parent of | 0000031 | closed | miqrogroove | Thumbnails for Attached Images |
| parent of | 0000032 | closed | miqrogroove | Disk Storage Option for Attachments |
| parent of | 0000128 | closed | miqrogroove | Thumbnails for Hotlinked Images |
| parent of | 0000135 | closed | miqrogroove | "Pretty" URLs for Attachments |
| parent of | 0000137 | closed | miqrogroove | Add New Attachment Options to Admin Panel |
| parent of | 0000116 | closed | miqrogroove | Check for Output Corruption for Attachments |
| parent of | 0000140 | closed | miqrogroove | Links from Virtual URL Errors Need to Point to $full_url |
|
|
topicadmin needs work |
|
|
The attachment system is officially overhauled. Lots of alpha testing and debugging are in store, I am sure. |
|
|
Changing the default image size limit because older PHP installations have a memory limit of 8M. |
| 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 |
