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

Home » FUDforum » How To » NNTP Server Message Cancellation
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
NNTP Server Message Cancellation [message #158437] Wed, 25 February 2009 23: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
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 08:41 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
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 08:14 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
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

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

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

Current Time: Thu Nov 21 18:00:41 GMT 2024

Total time taken to generate the page: 0.04367 seconds