[RC] Display posts anywhere 1.2.0RC5

[acctman]

lol... i have basic php coding skills and i bet I can tweak the old TopicAnywhere phpbb2 script before post anywhere is released. give me a week guys i'll mess with the old TopicAnywhere

[braven112]

lol... i have basic php coding skills and i bet I can tweak the old TopicAnywhere phpbb2 script before post anywhere is released. give me a week guys i'll mess with the old TopicAnywhere

Lets see it!

[Arkantos Khan]

lol... i have basic php coding skills and i bet I can tweak the old TopicAnywhere phpbb2 script before post anywhere is released. give me a week guys i'll mess with the old TopicAnywhere

That'd be great!!! "TopicsAnywhere" is a must-have mod for phpBB3. I don't understand why nobody has came forward with this issue since the release of phpBB3.

Looking forward to the TopicsAnywhere for phpBB3...

[deejay87]

Hi all,

it's true , very difficult to use over mods or script when you have you topics anywhere, it's easy to use and put in website, do you think one day someone can do the update for phpbb3 ?

Thanks

[ges8529]

Code: Select all

<?

// change to the path to your forum
$path = '';

// amount of topics to show
$amount = 6;

// forum ids to NOT show topics forum, separated by commas
$exclude = '';

// ------ no need to edit below ------ //

require_once("{$path}config.php");

$conid = mysql_connect($dbhost, $dbuser, $dbpasswd);
$db    = mysql_select_db($dbname, $conid);

unset($dbpasswd);

$sql_where = 'WHERE `forum_id` > -1 ';

if($exclude != '')
{     
    $exclude_forums = explode(',', $exclude);
    foreach ($exclude_forums as $id)
    {
        if ($id > 0)
        {
            $sql_where .= ' AND `forum_id` <> ' . trim($id);
        }
    }
}

$sql = "SELECT `topic_id`, `topic_last_post_id`, `topic_last_post_time`, `topic_last_poster_name`, `topic_title` FROM `{$table_prefix}topics`  {$sql_where} ORDER BY `topic_last_post_time`DESC LIMIT 0, {$amount}";
$result = mysql_query($sql, $conid);
$the_date = date('g:i A M j, Y', $topic['topic_last_post_time']);


$topics_html = '';
while($topic = mysql_fetch_array($result))
{
    $topics_html .= "<p><a target=\"_blank\" href=\"{$path}/forums/viewtopic.php?t={$topic['topic_id']}#p{$topic['topic_last_post_id']}\">{$topic['topic_title']}</a><br>Posted by {$topic['topic_last_poster_name']} at " . date('g:i A o\n D, M j Y', $topic['topic_last_post_time']) . "</p>";
}
mysql_close($conid);

echo $topics_html;
?>


This is what I'm using; however, I do not want announcements and sticky posts included any more than I want posts pending moderator approval included. Reason being: my boards require that new users post X posts before becoming bona fide users. I know this may seem strict, but I am sick and tired of people's using my boards to redirect to TV networks, celeb buzz, porn, and similar bogus sites. I am also tired of people's posting stuff like, "Hi, I'm in line for blah blah blah, but I need your votes." They do this in spite of the CAPCHA, ToS, and THREE anti-spam questions on the registration page. *Sigh*

Long story short: when someone clicks the link to a post awaiting approval, they get a message saying the topic does not exist. I want to mitigate that.

Any way to tweak the above code per what I'm looking for would be immensely appreciated. Thanks.

[marian0810]

next update should be sometime this month… if all goes well.
At least that's the plan.

Just curious if there's been any progress on this since January?

[Handyman`]

next update should be sometime this month… if all goes well.
At least that's the plan.

Just curious if there's been any progress on this since January?

Yes, there has been progress made on it.
I had it on the calendar to finish this month, but I think it's going to be pushed out one more month as some stuff came up - I have to finish it for the project I'm working on as I will (finally) be using it myself with an ACP.
I have the code working nicely on the next version without an ACP, but that doesn't do well for most people.

[jwig]

Hi, put me in line for the notification when this is done- Topics Anywhere was the 2nd most useful mod to my existing 2.0 board (the first being the attachments mod).

So please let me know when it's done.

Thanks!

JWig

[Jarode]

It's not for asking for a public release, sorry.
Just to ask you if this MOD display title OR body of the choosen topics/Posts ?

Thanks

[Handyman`]

It's not for asking for a public release, sorry.
Just to ask you if this MOD display title OR body of the choosen topics/Posts ?

Thanks

Yes.

As for the release, I have it scheduled on the project I'm working on, but there's been a few delays in the project, so this has been pushed back a bit.
Looking like I will get to finishing the ACP in December.

[Handyman`]

This MOD has now been updated to 1.2.0RC2

Changelog from 1.2.0B3 to 1.2.0RC1

1. Completely rewritten (again)
2. Added all possibilities of forums/topics/posts to display in each instance.
3. Added more instance options
4. Added UMIL installer for the database install.
5. Added simple header for a possible header output/styling on pages outside phpBB.
6. Included SubSilver2 and Prosilver templates for posts and topics.
7. Added MOD Version Check file to automatically check for updates through the ACP in your phpBB installation.

Changelog from 1.2.0RC1 to 1.2.0RC2

1. Fixed incorrect templates.
2. Fixed missing end div and end span in the templates.
3. Changed language in the ACP since we're using a dropdown instead of the old 0, 1 system
4. Fixed errors in view post_id
5. Fixed errors in view topic_id
6. Fixed switched dropdown menus in the ACP

[marian0810]

Nice When will it be available for everyone?

[Handyman`]

This MOD has now been updated to 1.2.0RC4 (1/1/2009)

1.2.0RC3 (12/30/2009)
Changelog from 1.2.0RC2 to 1.2.0RC3

1. Fixed bug in displaying post author signatures. (Reported by Manik)

Update from 1.2.0RC2
Copy root/includes/posts_anywhere.php to includes/posts_anywhere.php
Copy root/adm/mods/posts_anywhere_mod_version.php to adm/mods/posts_anywhere_mod_version.php


1.2.0RC4 (1/1/2010)
Changelog from 1.2.0RC3 to 1.2.0RC4

1. Fixed a bug where post authors would show as "Guest" if they didn't have a sesion. (Reported by: Manik)

Update from 1.2.0RC3
Copy root/includes/posts_anywhere.php to includes/posts_anywhere.php
Copy root/adm/mods/posts_anywhere_mod_version.php to adm/mods/posts_anywhere_mod_version.php

[jwig]

Hello, I'm having trouble downloading the file... can someone re-post a link to this mod? Thanks!

JWig

[somaring]

fantastic !

my main page is made by HTML , is this mod can work with it ? or it is a must that it will be made by php ?