Added get_topic_id().

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

1 files changed, 19 insertions, 0 deletions

diff --git a/src/PhpBB3Lib.php b/src/PhpBB3Lib.php
index 874591c..ccaa527 100644
--- a/src/PhpBB3Lib.php
+++ b/src/PhpBB3Lib.php
@@ -42,4 +42,23 @@ function get_user_name($id) {
   return $names[$id];
 }
 
+function get_topic_id($post_id) {
+  global $db;
+
+// FIXME: should get topic_id, forum_id at the same time
+  $sql = 'SELECT topic_id FROM ' . POSTS_TABLE .
+         ' WHERE post_id = "' . $db->sql_escape($post_id) . '"';
+
+  $result = $db->sql_query($sql);
+// FIXME: what to do if more than one row is returned?
+  $row = $db->sql_fetchrow($result);
+  $db->sql_freeresult($result);
+
+  if (!$row) {
+    trigger_error("Unknown post id: $post_id", E_USER_ERROR);
+  }
+
+  return $row['topic_id'];
+}
+
 ?>