Simple Machines Community Forum

Customizing SMF => SMF Coding Discussion => Topic started by: steelerguy26 on February 24, 2006, 09:15:16 PM

Title: Changing V-bulliten codeto SMF code
Post by: steelerguy26 on February 24, 2006, 09:15:16 PM
Ok I recently switched from V-Bullet to SMF forums. My enite site is set up to read the V-bullet.

My quest is this.

I have pages that currently are set to read Forum threads from the v-bullet forums and I want them to now read the SMF forum threads.

Here is example from one of the php files reading the v-bullt threads

Example 1.    $mysql_query = "SELECT post.title, post.pagetext FROM post, thread WHERE post.threadid=thread.threadid and username=\"$team\" and forumid=24.0 ORDER BY post.dateline DESC LIMIT 2";

Example 2 $mysql_query = "SELECT thread.threadid as threadid, thread.title as title, lastposter FROM thread, post WHERE thread.threadid=post.threadid and (post.username=\"$team\"  or thread.title like '% " . $team . " %') and forumid in (10.0,11.0,13.0,22.0,9.0) and thread.title not like '%CLOSE%' GROUP BY thread.threadid ORDER BY post.dateline DESC LIMIT 12";


I need to know which code to edit so they read the SMF threads instead.

Please help. I can be contacted on YIM at steelerguy26
Title: Re: Changing V-bulliten codeto SMF code
Post by: Dannii on February 24, 2006, 09:23:28 PM
You want to use SSI probably.
[README] SSI FAQ's" (http://www.simplemachines.org/community/index.php?topic=14906.0)