Added getFirstPostId().

git-svn-id: https://vassalengine.svn.sourceforge.net/svnroot/vassalengine/site-src/trunk@6705 67b53d14-2c14-4ace-a08f-0dab2b34000c

2 files changed, 28 insertions, 0 deletions

diff --git a/src/PhpBB3.php b/src/PhpBB3.php
index 48361a6..ca75c24 100644
--- a/src/PhpBB3.php
+++ b/src/PhpBB3.php
@@ -120,6 +120,18 @@ class PhpBB3 {
     return $row ? $row['post_time'] : false;
   }
 
+  public function getFirstPostId($topicId) {
+    throw_if_null($topicId);
+
+    global $db;
+
+    $sql = 'SELECT topic_first_post_id FROM ' . TOPICS_TABLE . ' ' .
+           'WHERE topic_id = ' . $topicId;
+
+    $row = $this->get_exactly_one_row($sql);
+    return $row ? $row['topic_first_post_id'] : false;
+  }
+
   public function postMessage($postType, $forumId, $topicId, $msg) {
     throw_if_null($msg);
 
diff --git a/test/PhpBB3Test.php b/test/PhpBB3Test.php
index fbd68e2..ee9246a 100644
--- a/test/PhpBB3Test.php
+++ b/test/PhpBB3Test.php
@@ -132,4 +132,20 @@ EOF;
     return array(
     );
   }
+
+  /**
+   * @dataProvider providerGetFirstPostId
+   */
+  public function testGetFirstPostId($topic_id, $expected, $ex) {
+    $this->markTestIncomplete();
+
+    if ($ex) $this->setExpectedException($ex);
+    $run = 'getFirstPostId(' . $topic_id . ')';
+    $this->assertEquals($expected, $this->exec_kludge($run));
+  }
+
+  public function providerGetFirstPostId() {
+    return array(
+    );
+  }
 }