More efficent attachment manager

[Ben_S]

Could someone possibly knock together an enhancment for the attachment manager,

Currently it is set accross a single page, so when you have a lot off attachments the page takes a while to load.

I've just loaded mine and Opera tells me the page is 1.8Mb and it took about 6 mins to load.

[edit] The page is actually 14mb, thank god for gzip [/edit]

Basically what needed it for it to diaplay say 50 on a page then have page numbers for the rest.

Cheers

[Ben_S]

I see what my problem is...

Total Attachments: 96480

When in reality there is only about 650.

For some reason it thinks every post has an attachment and is showing them on the attachment manager page.

Looking at a new install the messages table should have be NULL for attachment filename where there isnt one, so I just need to run a query to set it to null where its blank.

Code Select Expand

UPDATE yabbse_messages SET attachmentFilename = NULL WHERE attachmentFilename = '';
Did the trick, suppose I must have installed a mod thats stopping it automatically sticking the null in.

Anyway still think a mod to display them over numerous pages would be a good idea but for now I can live with 600 on one page