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

Home » FUDforum » How To » How to extract a message from the msg_X0000 file ?
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 extract a message from the msg_X0000 file ? [message #40267] Wed, 30 January 2008 16:19 Go to next message
Arafel is currently offline  Arafel   France
Messages: 18
Registered: July 2006
Location: France
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Hello, i'm trying to use a subforum to post news on it and publish them on my website.

I know:
-How to get the thread
-How to get the first message
-In which file the content of the message is
-The lenght of the message

But i don't know how to extract only the content of the message.

foff is post's first offset in the file ?
Shall i use a:

"SELECT sum(lenght) FROM fud**_msg WHERE file_id = '10000' AND id < '".$thepostiwant_id."' ORDER BY id"

Then use fread and use %8192 until i reach the beginning of the content that i need ?

(considering i want a message's content that is in file id 10000)

Is there an other way ?

Thanks for awnsering and my apologies for my bad english.


Edit:

Ok, i used fopen, fseek with foff and fgets, i had to do a while strlen(result) < length

And as fgets param, i used length-strlen(result)+1

[Updated on: Wed, 30 January 2008 18:21]

Report message to a moderator

Re: How to extract a message from the msg_X0000 file ? [message #40270 is a reply to message #40267] Thu, 31 January 2008 12:09 Go to previous messageGo to next message
Ilia is currently offline  Ilia   United States
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
You can use FUDAPI for this purpose. However, if you want to do it directly you need to use foff (file offset) and length parameter. Then you look at the file_id for the message and you know which file you need to open, seek to offset and read length bytes.

FUDforum Core Developer
Re: How to extract a message from the msg_X0000 file ? [message #40370 is a reply to message #40267] Wed, 20 February 2008 16:32 Go to previous message
Arafel is currently offline  Arafel   France
Messages: 18
Registered: July 2006
Location: France
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Thanks, i succeeded.
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: how can i set the time to local clock?
Next Topic: Preview image in topic
Goto Forum:
  

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

Current Time: Mon Oct 23 02:14:30 EDT 2017

Total time taken to generate the page: 0.00679 seconds