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

Home » FUDforum » How To » NNTP Server Message Cancellation
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
NNTP Server Message Cancellation [message #158437] Wed, 25 February 2009 18:08 Go to next message
jm2morri is currently offline  jm2morri   United States
Messages: 225
Registered: January 2009
Location: Stratford, Ontario, Canad...
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
Hello,

I mirror a small news server that isn't part of the main, public servers. The owners of this server allow users to make use of the cancel protocol that is part of nttp and pull messages back. They also will do it if spam is posted.

But the FUD forums don't handle the case if the message is no longer on the original server. At least I can't see where. Are there any plans to add this? I'd like to see messages that no longer exist on the original server be deleted/hidden in the FUD Forums.

The owners of the server are nice enough to send me an automated message each time this cancellation occurs. But I can't figure out a way to correlate that to a specific message. This info contains the NNTP ID.

So in the meantime (before handling the cancellation is part of FUD forums--if ever), I need a script that can take the NNTP ID (unique identifier) and either:

1) return enough info that I can confidently delete the message (the main reason this happens is because a user will post something twice and the times are very close together, plus it looks the time that is displayed isn't the time of posting but rather the time of syncing--so it doesn't match the info I get).

or

2) automatically delete/hide the message

Any suggestions/comments?

James.
Re: NNTP Server Message Cancellation [message #158451 is a reply to message #158437] Thu, 26 February 2009 03:41 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3632
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
FUDforum doesn't currently store the NNTP post IDs. So, the first step would be to modify the database schema to add such a field. Maybe we can add a column called "external_ref" to "fud28_msg".

Will you be able to start working on this? I will be able to assist, however someone needs to take the lead on this.
Re: NNTP Server Message Cancellation [message #158816 is a reply to message #158451] Sun, 29 March 2009 04:14 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3632
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Hi James,

I've started looking at the code and discovered that the Message ID's are already in the database. To see them, execute a query like this:

select subject, mlist_msg_id from fud26_msg;


Best regards.

Frank

Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Custom Profiles
Next Topic: HELP - messages disappeared after database repair
Goto Forum:
  

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

Current Time: Wed Dec 13 15:35:05 EST 2017

Total time taken to generate the page: 0.00646 seconds