3.2: Latest topics on external homepage

[beta5]

Hello: I want to show the titles and dates of the latest topics (topics with the latest post). I found this tutorial (with is mentioned quiete often):

https://wiki.phpbb.com/Practical.Displa ... rnal_pages

But it seems to be not suitable for phpBB 3.2 as I always get an error.

Allgemeiner Fehler
SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND topic_status <> 2 AND topic_visibility = 1 ORDER B' at line 3 [1064]

Beim Laden der Seite ist ein SQL-Fehler aufgetreten. Bitte kontaktiere die Board-Administration, falls dieses Problem fortlaufend auftritt.

The example 1 or the the example 2 should provide the necessary information for my purpose.

I assume the problem is somewhere in the code block functions. This block is not necessary for example 4 and that does work (see also http://www.cricketmx.com/articles/read/ ... in-phpbb3/).

[kasimi]

What's the complete value of your SQL query (the $topics variable in example 1)?

[beta5]

I do not understand your question. As described above, I simply put the code into a file and upload it and then get that error message in the browser.

[kasimi]

You need to define $forum_id_where to formulate a correct SQL query, for example:

Code: Select all

$forum_id_where = 'WHERE topic_id = 123';

[beta5]

Why not use the code that is listed there and simply adapt the forum_id and topic_id and leave in blank for example which is explained to mean no restrictions on topics or forums.

Code: Select all

$search_limit = 5;

    $forum_id = array();
    $forum_id_where = create_where_clauses($forum_id, 'forum');

    $topic_id = array();
    $topic_id_where = create_where_clauses($topic_id, 'topic');