1. ";
27. $result = dbquery("SELECT * FROM ".DB_FAQ_CATS." ORDER BY faq_cat_name");
28. $rows = dbrows($result);
29. if ($rows) {
30. $columns = 2; $counter = 0;
31. echo "\n\n";
32. while($data = dbarray($result)) {
33. if ($counter != 0 && ($counter % $columns == 0)) { echo "
\n\n"; }
34. $num = dbcount("(faq_id)", DB_FAQS, "faq_cat_id='".$data['faq_cat_id']."'");
35. echo "".$data['faq_cat_name']." ($num)\n";
36. if ($data['faq_cat_description']) { echo "
\n".$data['faq_cat_description'].""; }
37. echo " | \n";
38. $counter++;
39. }
40. echo "
\n
\n";
41. } else {
42. echo "
\n".$locale['410']."
\n
\n";
43. }
44. echo "";
45. closetable();
46. } else {
47. if ($data = dbarray(dbquery("SELECT * FROM ".DB_FAQ_CATS." WHERE faq_cat_id='".$_GET['cat_id']."'"))) {
48. add_to_title($locale['global_201'].$data['faq_cat_name']);
49. opentable($locale['401'].": ".$data['faq_cat_name']);
50. echo "";
51. $rows = dbcount("(faq_id)", DB_FAQS, "faq_cat_id='".$_GET['cat_id']."'");
52. if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
53. if ($rows != 0) {
54. $result = dbquery("SELECT * FROM ".DB_FAQS." WHERE faq_cat_id='".$_GET['cat_id']."' ORDER BY faq_id LIMIT ".$_GET['rowstart'].",15");
55. $numrows = dbrows($result);
56. $tbl = 2; $i = 0;
57. echo "\n\n";
58. while ($data = dbarray($result)) {
59. if ($i != 0 && ($i % $tbl == 0)) { echo "
\n\n"; }
60. echo "".$data['faq_question']."
\n".nl2br(stripslashes($data['faq_answer']));
61. echo ($i != $numrows ? "
\n" : "\n");
62. echo " | ";
63. $i++;
64. }
65. echo "
\n
\n";
66. echo "";
67. closetable();
68. if ($rows != 0) { echo "".makepagenav($_GET['rowstart'], 15, $rows, 3, FUSION_SELF."?cat_id=".$_GET['cat_id']."&")."\n
\n"; }
69. } else {
70. echo $locale['411']."\n";
71. echo "";
72. closetable();
73. }
74. } else {
75. redirect(FUSION_SELF);
76. }
77. }
78.
79. require_once THEMES."templates/footer.php";
80. ?>