FUDforum: How To » How to search for attachments to messages

Home » FUDforum » How To » How to search for attachments to messages

Show: Today's Messages :: Polls :: Message Navigator

How to search for attachments to messages [message #158372]

Sun, 22 February 2009 15:14

Peter Vendike

Messages: 65
Registered: February 2009
Location: Denmark

Karma: 0

Member
Translator

I can't see a way to search for either messages with any attachment or for a particular attached file name

Is this possible?

Peter

Report message to a moderator

Re: How to search for attachments to messages [message #158373 is a reply to message #158372]

Sun, 22 February 2009 15:39

naudefj

Messages: 3772
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Hi Peter,

Currently, no. Someone (possibly you) will have to write a patch to add this feature to the code base.

Best regards.

Frank

Report message to a moderator

Re: How to search for attachments to messages [message #158374 is a reply to message #158373]

Sun, 22 February 2009 15:57

Peter Vendike

Messages: 65
Registered: February 2009
Location: Denmark

Karma: 0

Member
Translator

Hi Frank

Any ideas where to start?

Where are the attachment names saved, in the 'files' directory I only see "1.atch, 2.atch, 3.atch ........."

Peter

Report message to a moderator

Re: How to search for attachments to messages [message #158375 is a reply to message #158374]

Sun, 22 February 2009 16:20

naudefj

Messages: 3772
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

The data is stored within the database in a table called fud26_attach.

CREATE TABLE {SQL_TABLE_PREFIX}attach
(
	id		INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	location	VARCHAR(255) NOT NULL DEFAULT '',
	original_name	VARCHAR(255),
	owner		INT NOT NULL DEFAULT 0,
	attach_opt	INT NOT NULL DEFAULT 0,
	message_id	INT NOT NULL DEFAULT 0,
	dlcount		INT NOT NULL DEFAULT 0,
	mime_type	INT NOT NULL DEFAULT 0,
	fsize		INT NOT NULL DEFAULT 0
);

Report message to a moderator