aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/phpbb/textreparser/plugins/poll_title.php
diff options
context:
space:
mode:
authorJoshyPHP <s9e.dev@gmail.com>2015-05-01 08:47:01 +0200
committerJoshyPHP <s9e.dev@gmail.com>2015-05-30 17:26:00 +0200
commit986af43f37342953bff548630aa33904c21234f4 (patch)
tree07cb503a0ef5dce28b1344c749397bd3a28f66f1 /phpBB/phpbb/textreparser/plugins/poll_title.php
parente11ae7e9cd5573658b763b1ef72cb889f547f2dd (diff)
downloadforums-986af43f37342953bff548630aa33904c21234f4.tar
forums-986af43f37342953bff548630aa33904c21234f4.tar.gz
forums-986af43f37342953bff548630aa33904c21234f4.tar.bz2
forums-986af43f37342953bff548630aa33904c21234f4.tar.xz
forums-986af43f37342953bff548630aa33904c21234f4.zip
[ticket/13803] Added plugins
PHPBB3-13803
Diffstat (limited to 'phpBB/phpbb/textreparser/plugins/poll_title.php')
-rw-r--r--phpBB/phpbb/textreparser/plugins/poll_title.php50
1 files changed, 50 insertions, 0 deletions
diff --git a/phpBB/phpbb/textreparser/plugins/poll_title.php b/phpBB/phpbb/textreparser/plugins/poll_title.php
new file mode 100644
index 0000000000..e794780eba
--- /dev/null
+++ b/phpBB/phpbb/textreparser/plugins/poll_title.php
@@ -0,0 +1,50 @@
+<?php
+/**
+*
+* This file is part of the phpBB Forum Software package.
+*
+* @copyright (c) phpBB Limited <https://www.phpbb.com>
+* @license GNU General Public License, version 2 (GPL-2.0)
+*
+* For full copyright and license information, please see
+* the docs/CREDITS.txt file.
+*
+*/
+
+namespace phpbb\textreparser\plugins;
+
+class poll_title extends \phpbb\textreparser\row_based_plugin
+{
+ /**
+ * {@inheritdoc}
+ */
+ protected function get_columns()
+ {
+ return array(
+ 'id' => 'topic_id',
+ 'text' => 'poll_title',
+ );
+ }
+
+ /**
+ * {@inheritdoc}
+ */
+ protected function get_records_query($min_id, $max_id)
+ {
+ $sql = 'SELECT t.topic_id AS id, t.poll_title AS text, p.bbcode_uid
+ FROM ' . TOPICS_TABLE . ' t, ' . POSTS_TABLE . ' p
+ WHERE t.topic_id BETWEEN ' . $min_id . ' AND ' . $max_id .'
+ AND t.poll_max_options > 0
+ AND p.post_id = t.topic_first_post_id';
+
+ return $sql;
+ }
+
+ /**
+ * {@inheritdoc}
+ */
+ protected function get_table_name()
+ {
+ return TOPICS_TABLE;
+ }
+}