So far, I've gotten the script (without changes) to connect to the gateway server and try to import messages. If the messages are killfiled, it bypasses them as expected (as seen in debug mode). But once it comes to the first message it should truly import, it stops. I haven't figured out why.

I hope someone with more php experience than me has some ideas. -- Rik

I forgot something in this post.

I'll be back with that...

This is the story:

My newsservers motherboard died in november, so I had to order a new one. This server has now been reinstalled from scratch so the Xref, which gateway.php uses is reset. Lastmsg in the nntp_groups-table therefore got useless, especially when the server resynched older posts again.

Fetching all posts again after resetting the lastmsg will result in duplicate messages. This has been fixed with a small patch.


Find the row:
$message =& $nntp['message'];

Add this code after that row:

PHP Code:

---

                          /*
                           * Find duplicates by message-id against the forumid!
                           *
                           * Matching against forumid, so crosspostings to other groups
                           * can proceed to posting.
                           *
                           */
                          $isduplicate = false;
                          $msgid = $message['message-id'];
                          $msgdupe = $db->query_first("
                                  SELECT p.postid,p.threadid,p.msgid,t.forumid FROM post AS p
                                          INNER JOIN thread AS t
                                                  ON p.threadid = t.threadid
                                          WHERE msgid = '".$db->escape_string($msgid)."'
                                  ");
                          if ($group['forum'] == $msgdupe['forumid'])
                          {
                                  $isduplicate = true;
                                  logging("Skip, Message-ID already found.");
                                  // No continue should be used here, since the lastmsg-counter must work
                                  //continue;
                          } 


---

Then go find the row for the post-insert (it?s actually the thread-insert), it should look like this:

$postid = insert_post($threadid, $forumid, $foruminfo, $subject, $from_name, $from_email, $date, $parentid);

Before that line, add?

PHP Code:

---

                                          // If this isn't a duplicate
                                          if (!$isduplicate)
                                          { 


---

Then, after the line ?
exec_send_notification($threadid, "0", $postid);

Add this:

PHP Code:

---

                                           } // Isduplicate Finish 


---

Right after this, you have to add similar code to the insertcode for posts, so directly after

} else {


?add this again:

PHP Code:

---

                                          // If this isn't a duplicate
                                          if (!$isduplicate)
                                          { 


---

?and finish this with an ending ?}? after the line

logging("'$subject' from ". $from_name . ". New thread.");


Now, the gateway should?nt post a message with the same Message-ID twice?

Sorry that I can't help with a Gateway code fix, but your message solved my importing problem mentioned above (message #671) by letting me know to turn off the similar thread search:
admincp -> Message Search Options

Now the Gateway is importing threads on a 4.0 installation. Thanks. -- Rik

EDIT: You can still display the similar threads:
admincp -> Thread Display Options (showthread) -> Show Similar Threads = Yes.

Since similar threads aren't being updated during the import, I expect (unless they are somehow updated as one of the scheduled tasks) one has to update them regularly with:
admincp -> Maintenance -> Updated Counters -> Rebuild Similar Threads

Anyone gotten this to work on 4.0 gold?

Guys,

Would just like to thank you for spending time getting this mod to work on V4. I havent installed yet, however i'm just setting up a test forum based under 4.0.2.

Just wondering if one of you guys might be able to assist by passing on current working files, with any patches added to allow it to work (esp under v4).

I could trawl through the thread and apply patches, however there's so many "try this" - then - "This doesnt work, this does it better" that i think i may be here for days/weeks just taking the original files and altering code! It's like re-inventing the wheel!!

If anyone could assist, it would be much appreciated :)

On a side note, i would be happy to contribute alongside others, to a developer polishing this up or rebuilding it to work under 4.0.2 nicely, as it did back in the early days!!

Paul

This mod is the only thing holding me back from going to 4.0.

I have a few services which email me information and this is the only hack I know which can check mailboxes and if new messages are found post them to the forum as new threads.

If anyone know a program which does the same thing let me know. I dont really use the usenet portion of the program.

I've been messing around with this, and If I can get it cleaned up and working Ok (and can somehow get ahold of the developer, to request permission to take over) I'll see about releasing a 3.8 (and 4.0) version. That's IF I can get it worked out, and permission from the developer.

SecondV,

I posted this yesterday in Paid Mods.

https://vborg.vbsupport.ru/showthread.php?t=236324

Not sure, however i suspect there's a fair few people on the list that would contribute maybe $20 each to get a decent supported working version. I know i would!!

It's the one thing that (like others) is stopping my forum migrating!!!

Paul

id drop at least 60 bucks to see this happen on 4.0