phpBB.de

Code: Alles auswählen

//
        // query the database
        //
        if(!($result = $db->sql_query($sql)))
        {
                message_die(GENERAL_ERROR, 'Could not query announcements information', '', __LINE__, __FILE__, $sql);
        }
        //
        // fetch all postings
        //

Code: Alles auswählen

if ( !defined('IN_PHPBB') )
{
        die("Hacking attempt");
}

//
// Begin simply CMS Mod
// Type in all the cats-ids you want to display in the simply CMS.
// Separate the cat_ids in $cont_cat with an ',' (comma)
// e.g. $cont_cat = "(1, 2, 5, 7)";

$cont_cat = "(1, 2, 3, 4, 5, 6, 7)";

//
// End simply CMS Mod
//
error_reporting  (E_ERROR | E_WARNING | E_PARSE); // This will NOT report uninitialized variables
set_magic_quotes_runtime(0); // Disable magic_quotes_runtime

// The following code (unsetting globals)
// Thanks to Matt Kavanagh and Stefan Esser for providing feedback as well as patch files

Code: Alles auswählen

                       FROM
                          ' . TOPICS_TABLE . ' AS t,
                          ' . USERS_TABLE . ' AS u,
                          ' . POSTS_TEXT_TABLE . ' AS pt,
                          ' . POSTS_TABLE . ' AS p
                        WHERE
                          t.forum_id IN (' . $forum_sql . ') AND
                          t.topic_time <= ' . time() . ' AND
                          t.topic_poster = u.user_id AND
                          t.topic_first_post_id = pt.post_id AND
                          t.topic_first_post_id = p.post_id AND
                          t.topic_status <> 2
                        ORDER BY
                          t.topic_time DESC';
        if ($number_of_posts != 0)
        {
                $sql .= '
                        LIMIT
                          0,' . $number_of_posts;
        }
        //
        // query the database
        //
        if(!($result = $db->sql_query($sql)))
        {
                message_die(GENERAL_ERROR, 'Could not query announcements information', '', __LINE__, __FILE__, $sql);
        }
        //
        // fetch all postings
        //
        $posts = array();
        if ($row = $db->sql_fetchrow($result))
        {
                $i = 0;
                do
                {
                        $posts[$i]['bbcode_uid'] = $row['bbcode_uid'];
                        $posts[$i]['enable_smilies'] = $row['enable_smilies'];
                        $posts[$i]['post_text'] = $row['post_text'];
                        $posts[$i]['topic_id'] = $row['topic_id'];
                        $posts[$i]['topic_replies'] = $row['topic_replies'];
                        $posts[$i]['topic_time'] = create_date($board_config['default_dateformat'], $row['topic_time'], $board_config['board_timezone']);
                        $posts[$i]['topic_title'] = $row['topic_title'];
                        $posts[$i]['user_id'] = $row['user_id'];
                        $posts[$i]['username'] = $row['username'];

Code: Alles auswählen

} // phpbb_fetch_posts

function phpbb_fetch_poll($forum_sql)
{
global $db;

$sql = 'SELECT
t.*,
vd.*
FROM
' . TOPICS_TABLE . ' AS t,
' . VOTE_DESC_TABLE . ' AS vd
WHERE
t.forum_id IN (' . $forum_sql . ') AND
t.topic_status <> 1 AND
t.topic_status <> 2 AND
t.topic_vote = 1 AND
t.topic_id = vd.topic_id
ORDER BY
t.topic_time DESC
LIMIT
0,1';

if (!$query = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Could not query poll information', '', __LINE__, __FILE__, $sql);
}

$result = $db->sql_fetchrow($query);

if ($result)
{
$sql = 'SELECT
*
FROM
' . VOTE_RESULTS_TABLE . '
WHERE
vote_id = ' . $result['vote_id'] . '
ORDER BY
vote_option_id';

if (!$query = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Could not query vote result information', '', __LINE__, __FILE__, $sql);
}

while ($row = $db->sql_fetchrow($query))
{
$result['options'][] = $row;
}
}

return $result;
} // end func phpbb_fetch_poll

Code: Alles auswählen

if ( !defined('IN_PHPBB') )
{
        die("Hacking attempt");
}

error_reporting(E_ERROR | E_WARNING | E_PARSE);
set_magic_quotes_runtime(0);

include_once($phpbb_root_path . 'includes/bbcode.'.$phpEx);


function phpbb_fetch_posts($forum_sql, $number_of_posts, $text_length)
{
        global $db, $board_config;

        $sql = 'SELECT
                          t.topic_id,
                          t.topic_time,
                          t.topic_title,
                          pt.post_text,
                          u.username,
                          u.user_id,
                          t.topic_replies,
                          pt.bbcode_uid,
                          t.forum_id,
                          t.topic_poster,
                          t.topic_first_post_id,
                          t.topic_status,
                          pt.post_id,
                          p.post_id,
                          p.enable_smilies
                        FROM
                          ' . TOPICS_TABLE . ' AS t,
                          ' . USERS_TABLE . ' AS u,
                          ' . POSTS_TEXT_TABLE . ' AS pt,
                          ' . POSTS_TABLE . ' AS p
                        WHERE
                          t.forum_id IN (' . $forum_sql . ') AND
                          t.topic_time <= ' . time() . ' AND
                          t.topic_poster = u.user_id AND
                          t.topic_first_post_id = pt.post_id AND
                          t.topic_first_post_id = p.post_id AND
                          t.topic_status <> 2
                        ORDER BY
                          t.topic_time DESC';
        if ($number_of_posts != 0)
        {
                $sql .= '
                        LIMIT
                          0,' . $number_of_posts;
        }
        //
        // query the database
        //