FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » How to search for attachments to messages
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
How to search for attachments to messages [message #158372] Sun, 22 February 2009 10:14 Go to next message
Peter Vendike is currently offline  Peter Vendike   Denmark
Messages: 65
Registered: February 2009
Location: Denmark
Karma: 0
Member
Translator
add to buddy list
ignore all messages by this user
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
Re: How to search for attachments to messages [message #158373 is a reply to message #158372] Sun, 22 February 2009 10:39 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3624
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
Hi Peter,

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

Best regards.

Frank
Re: How to search for attachments to messages [message #158374 is a reply to message #158373] Sun, 22 February 2009 10:57 Go to previous messageGo to next message
Peter Vendike is currently offline  Peter Vendike   Denmark
Messages: 65
Registered: February 2009
Location: Denmark
Karma: 0
Member
Translator
add to buddy list
ignore all messages by this user
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

Re: How to search for attachments to messages [message #158375 is a reply to message #158374] Sun, 22 February 2009 11:20 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3624
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
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
);
Re: How to search for attachments to messages [message #159361 is a reply to message #158375] Mon, 25 May 2009 05:51 Go to previous messageGo to next message
Peter Vendike is currently offline  Peter Vendike   Denmark
Messages: 65
Registered: February 2009
Location: Denmark
Karma: 0
Member
Translator
add to buddy list
ignore all messages by this user
How do you get all the "CREATE TABLE" things out of let us say the install file for 2.8.1 so one could have a overview of all sql-tables?
Re: How to search for attachments to messages [message #159362 is a reply to message #159361] Mon, 25 May 2009 10:49 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3624
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
The DDL in the data/sql/ directory.
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: "Fatal error"...forum move
Next Topic: Forum Integration
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Oct 23 18:44:53 EDT 2017

Total time taken to generate the page: 0.00744 seconds