sql_fetchrow($db->sql_query("SELECT catid FROM ".$prefix."_stories_cat WHERE title LIKE '%$VAR1%' LIMIT 1")); if ($VAR2 == "") {//If Second Var is Zero then $result1 = $db->sql_query("SELECT sid, title, hometext FROM ".$prefix."_stories ORDER BY sid DESC LIMIT 150"); } else { $VAR2 = intval($VAR2); $result1 = $db->sql_query("SELECT sid, title, hometext FROM ".$prefix."_stories WHERE catid='$catid' ORDER BY sid DESC LIMIT 150"); } } else { $result1 = $db->sql_query("SELECT sid, title, hometext FROM ".$prefix."_stories ORDER BY sid DESC LIMIT 150"); } $VAR3 = intval($VAR3); //Varible name for Forums if ($VAR3 !=""){ //If Varible 3 is ZERO then $VAR4 = $db->sql_fetchrow($db->sql_query("SELECT post_id, post_subject , post_text FROM ".$prefix."_bbposts_text WHERE post_subject LIKE '%$VAR3%' LIMIT 30")); if (VAR4 =="") { //If Fourth Varible is Zero then $result2 = $db->sql_query("SELECT post_id, post_subject , post_text FROM ".$prefix."_bbposts_text ORDER BY post_id DESC LIMIT 30"); }else{ $VAR4 = intval($VAR4); $result2 = $db->sql_query("SELECT post_id, post_subject , post_text FROM ".$prefix."_bbposts_text ORDER BY post_id DESC LIMIT 0, 30"); } } else { $result2 = $db->sql_query("SELECT post_id, post_subject , post_text FROM ".$prefix."_bbposts_text ORDER BY post_id DESC LIMIT 0, 30"); } $VAR5 = intval($VAR5);//Varible Name for Weblinks if ($VAR5 != "") {//If Varible 5 is Zero Then $VAR6 = $db->sql_fetchrow($db->sql_query("SELECT catid FROM ".$prefix."_links_categories WHERE title LIKE '%$VAR6%' LIMIT 1")); if ($VAR6 == "") {//If Sixth Varible is Zero Then $result3 = $db->sql_query("SELECT lid, title, description, url FROM ".$prefix."_links_links ORDER BY lid DESC LIMIT 1500"); } else { $VAR6 = intval($VAR6); $result3 = $db->sql_query("SELECT lid, title, description, url FROM ".$prefix."_links_links WHERE catid='$catid' ORDER BY lid DESC LIMIT 1500"); } } else { $result3 = $db->sql_query("SELECT lid, title, description, url FROM ".$prefix."_links_links ORDER BY lid DESC LIMIT 1500"); } //DISPLAYS PRIMARY HEADER INFO FOR RSS FEED and FOR NEWS FIRST. echo "\n\n"; echo "\n\n"; echo "\n\n"; echo "\n"; echo "\n"; echo "$nukeurl\n"; echo "".htmlspecialchars($backend_title)."\n"; echo "$backend_language\n\n"; while ($row = $db->sql_fetchrow($result1)) { // $result1 gets data from query dealing with your News Articles $rsid = intval($row['sid']); $rtitle = $row['title']; $rtext = $row['hometext']; echo "\n"; echo "\n"; echo "$nukeurl/modules.php?name=News&file=article&sid=$rsid\n"; echo "".htmlspecialchars($rtext)."\n"; echo "http://www.devilsoulblack.com/img-devil/botoncito.jpg\n"; //YOU MAY CHANGE THIS LINE ONLY TO FIT YOUR NEWS LOGO echo "\n\n"; } //STARTS TO LIST RSS FEED FOR FORUM while ($row = $db->sql_fetchrow($result2)) { // $results2 gets data from your Forum SQL QUERY and Loops, $ROW is a Gobal Varible in the mainfile.php $rid = intval($row['post_id']); $rsubject = $row['post_subject']; $rtext = $row['post_text']; echo "\n"; echo "\n"; echo "$nukeurl/modules.php?name=Forums&file=viewtopic&p=$rid\n"; echo "".htmlspecialchars($rtext)."\n"; echo "http://www.devilsoulblack.com/img-devil/botoncito.jpg\n"; //YOU MAY CHANGE THIS LINE ONLY TO FIT YOUR FORUM LOGO echo "\n\n"; } //STARTS TO LIST RSS FEED FOR WEBLINKS while ($row = $db->sql_fetchrow($result3)) {//$results3 is data from your sql query of the Weblinks $rlid = intval($row['lid']); $rtitle = $row['title']; $rtext = $row['description']; echo "\n"; echo "\n"; echo "$nukeurl/modules.php?name=Web_Links&l_op=visit&lid=$rlid\n"; echo "".htmlspecialchars($rtext)."\n"; echo "http://www.devilsoulblack.com/img-devil/botoncito.jpg\n"; //YOU MAY CHANGE THIS LINE ONLY TO FIT YOUR WEBLINKS LOGO echo "\n\n"; } //Closes out your FEED echo "\n"; echo ""; ?>