From 202da8020dc63cc0f12fb782ba7deb618029ca3b Mon Sep 17 00:00:00 2001
From: uckelman <uckelman@nomic.net>
Date: Wed, 24 Mar 2010 19:48:42 +0000
Subject: Added get_topic_id().

git-svn-id: https://vassalengine.svn.sourceforge.net/svnroot/vassalengine/site-src/trunk@6630 67b53d14-2c14-4ace-a08f-0dab2b34000c
---
 src/PhpBB3Lib.php | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)

(limited to 'src')

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'];
+}
+
 ?>
-- 
cgit v1.2.3