Changing V-bulliten codeto SMF code

Started by steelerguy26, February 24, 2006, 09:15:16 PM

Previous topic - Next topic

steelerguy26

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

Dannii

"Never imagine yourself not to be otherwise than what it might appear to others that what you were or might have been was not otherwise than what you had been would have appeared to them to be otherwise."

Advertisement: