faq.php

<?php
require "include/bittorrent.php";
dbconn();
require_once(get_langfile_path());
loggedinorreturn();

stdhead($lang_faq['head_faq']);
$Cache->new_page('faq', 900, true);
if (!$Cache->get_page())
{
$Cache->add_whole_row();
begin_main_frame();

echo '<h1>' . $lang_faq['text_welcome_to'].$SITENAME." - ".$SLOGAN . '</h1>';
print($lang_faq['text_welcome_content_one'].$lang_faq['text_welcome_content_two']);

$lang_id = get_guest_lang_id();
$is_rulelang = get_single_value("language","rule_lang","WHERE id = ".sqlesc($lang_id));
if (!$is_rulelang){
	$lang_id = 6; //English
}
$res = sql_query("SELECT `id`, `link_id`, `question`, `flag` FROM `faq` WHERE `type`='categ' AND `lang_id` = ".sqlesc($lang_id)." ORDER BY `order` ASC");
while ($arr = _mysql_fetch_array($res)) {
	$faq_categ[$arr['link_id']]['title'] = $arr['question'];
	$faq_categ[$arr['link_id']]['flag'] = $arr['flag'];
	$faq_categ[$arr['link_id']]['link_id'] = $arr['link_id'];
}

$res = sql_query("SELECT `id`, `link_id`, `question`, `answer`, `flag`, `categ` FROM `faq` WHERE `type`='item' AND `lang_id` = ".sqlesc($lang_id)." ORDER BY `order` ASC");
while ($arr = _mysql_fetch_assoc($res)) {
	$faq_categ[$arr['categ']]['items'][$arr['id']]['question'] = $arr['question'];
	$faq_categ[$arr['categ']]['items'][$arr['id']]['answer'] = $arr['answer'];
	$faq_categ[$arr['categ']]['items'][$arr['id']]['flag'] = $arr['flag'];
	$faq_categ[$arr['categ']]['items'][$arr['id']]['link_id'] = $arr['link_id'];
}

if (isset($faq_categ)) {
  begin_frame("<span id=\"top\">".$lang_faq['text_contents'] . "</span>", '', '', '', '', true);
	foreach ($faq_categ as $id => $temp)
	{
		if ($temp['flag'] == "1")
		{
			print("<ul><li><a href=\"#id". $id ."\"><b>". $temp['title'] ."</b></a><ul>\n");
   			if (array_key_exists("items", $temp)) 
			{
    				foreach ($temp['items'] as $id2 => $temp2)
				{
	 				if ($temp2['flag'] == "1") print("<li><a href=\"#id". $id2 ."\" class=\"faqlink\">". $temp2['question'] ."</a></li>\n");
	 				elseif ($temp2['flag'] == "2") print("<li><a href=\"#id". $id2 ."\" class=\"faqlink\">". $temp2['question'] ."</a> <img class=\"faq_updated\" src=\"pic/trans.gif\" alt=\"Updated\" /></li>\n");
	 				elseif ($temp2['flag'] == "3") print("<li><a href=\"#id". $id2 ."\" class=\"faqlink\">". $temp2['question'] ."</a> <img class=\"faq_new\" src=\"pic/trans.gif\" alt=\"New\" /></li>\n");
    				}
			}
			print("</ul></li></ul><br />");
		}
	}
	end_frame();

	foreach ($faq_categ as $id => $temp) {
		if ($temp['flag'] == "1")
		{
			$frame = $temp['title'] ." - <a href=\"#top\"><img class=\"top\" src=\"pic/trans.gif\" alt=\"Top\" title=\"Top\" /></a>";
			begin_frame($frame, '', '', '', '', true);
			print("<span id=\"id". $id ."\"></span>");
			if (array_key_exists("items", $temp))
			{
				foreach ($temp['items'] as $id2 => $temp2)
				{
					if ($temp2['flag'] != "0")
					{
						print("<br /><span id=\"id".$id2."\"><b>". $temp2['question'] ."</b></span><br />\n");
						print("<br />". $temp2['answer'] ."\n<br /><br />\n");
					}
				}
			}
			end_frame();
		}
	}
}
end_main_frame();
	$Cache->end_whole_row();
	$Cache->cache_page();
}
echo $Cache->next_row();
stdfoot();