from phpbb forum tracker to smf tracker !

[crisje]

Hi guys, I`m new here and I like a lot this smf stuff. I stepped over from phpbb because of the spam I got on my forum ... so I have the following problem:

On my site I have a forum tracker that dozen`t match any more with the new smf forum, so please I need some help with it !

php context:
<?php
                           include_once( "lib/sql.php" );
                           $sql =& Sql::getInstance();
                           $queryObj = $sql->runInstantQuery( "SELECT phpbb_posts.topic_id, phpbb_posts.post_time, phpbb_topics.topic_title FROM phpbb_posts, phpbb_topics WHERE phpbb_posts.topic_id=phpbb_topics.topic_id GROUP BY phpbb_posts.topic_id ORDER BY post_time DESC LIMIT 0,10" );
                           while( $r = $queryObj->fetchArray() ) {
                              $date = date( "H:i", $r[post_time] );
                              echo "<span style=\"font-size: 10px\">".$date.":</span> <a href=\"forum/viewtopic.php?t=".$r[topic_id]."\" >".$r[topic_title]."</a><br>";

the site is www.auto-rijbewijs.nl [nofollow] and for the forum is auto-rijbewijs.nl/forum [nofollow] check it out and let me know!

[Dannii]

What does that code do? You can probably do it with SSI.php.. but I'm not sure what it does so I can't be certain.

[crisje]

what it does ... is calling the data from the old phbb form and place it in the forum tracker op the main page ...

now that I`ve changed the forum to smf the forum tracker does not match anymore !

so I need some help guys ....

[Dannii]

You haven't explained what it does. What data? What is a forum tracker?

[crisje]

have you checked the site ? on the right just up from the poll option!
it`s similar with the torrent tracker, but it collects info about the nieuw posts in the smf ....

[crisje]

Problem resolved ! by changing data from mysql in the php script (the id tags and names ...)

[Tony Reid]

You might like to look at using SSI.php

Its great for doing things like this - http://www.simplemachines.org/community/ssi_examples.php

Also the SSI FAQ's are very helpful http://www.simplemachines.org/community/index.php?topic=14906.0