Simple Machines Community Forum

SMF Development => Feature Requests => Applied or Declined Requests => Topic started by: crisje on December 28, 2006, 07:54:07 AM

Title: from phpbb forum tracker to smf tracker !
Post by: crisje on December 28, 2006, 07:54:07 AM
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 and for the forum is auto-rijbewijs.nl/forum check it out and let me know!
Title: Re: from phpbb forum tracker to smf tracker !
Post by: Dannii on December 28, 2006, 08:55:30 AM
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.
Title: Re: from phpbb forum tracker to smf tracker !
Post by: crisje on December 28, 2006, 03:30:11 PM
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 ....
Title: Re: from phpbb forum tracker to smf tracker !
Post by: Dannii on December 28, 2006, 11:26:54 PM
You haven't explained what it does. What data? What is a forum tracker?
Title: Re: from phpbb forum tracker to smf tracker !
Post by: crisje on December 29, 2006, 05:52:38 AM
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 ....
Title: Re: from phpbb forum tracker to smf tracker !
Post by: crisje on December 29, 2006, 05:57:15 AM
Problem resolved ! by changing data from mysql in the php script (the id tags and names ...)
Title: Re: from phpbb forum tracker to smf tracker !
Post by: Tony Reid on December 29, 2006, 06:10:23 AM
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