1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
|
<?php
$module = array("page" => "faq_page",
"admin" => "faq_admin");
function faq_page() {
global $theme;
$result = db_query("SELECT * FROM faqs ORDER BY weight");
while ($faq = db_fetch_object($result)) {
$header .= "<LI><A HREF=\"#$faq->id\">". check_output($faq->question) ."</A></LI>\n";
$output .= "<DT><B><A NAME=\"$faq->id\">". check_output($faq->question) ."</A></B></DT>\n";
$output .= "<DD>". check_output($faq->answer, 1) ."<P></DT>\n";
}
$output = "<DL>$output</DL>";
$theme->header();
$theme->box(t("Frequently Asked Questions"), $header);
$theme->box(t("Frequently Asked Questions"), $output);
$theme->footer();
}
function faq_add() {
global $allowed_html;
$output .= "<FORM ACTION=\"admin.php?mod=faq\" METHOD=\"post\">\n";
$output .= "<B>Question:</B><BR>\n";
$output .= "<INPUT TYPE=\"text\" NAME=\"edit[question]\" SIZE=\"50\" MAXLENGTH=\"128\"><BR>\n";
$output .= "<B>Answer:</B><BR>\n";
$output .= "<TEXTAREA WRAP=\"virtual\" COLS=\"50\" ROWS=\"10\" NAME=\"edit[answer]\" MAXLENGTH=\"20\"></TEXTAREA><BR>\n";
$output .= "<SMALL><I>Allowed HTML tags: ". htmlspecialchars($allowed_html) .".</I></SMALL><P>\n";
$output .= "<B>Weight:</B><BR>\n";
for ($count = 0; $count < 20; $count++) $weight .= "<OPTION VALUE=\"$count\">$count</OPTION>\n";
$output .= "<SELECT NAME=\"edit[weight]\">$weight</SELECT><P>\n";
$output .= "<INPUT TYPE=\"submit\" NAME=\"op\" VALUE=\"Add FAQ\">\n";
$output .= "</FORM>\n";
print $output;
}
function faq_add_save($edit) {
db_query("INSERT INTO faqs (question, answer, weight) VALUES ('". check_input($edit[question]) ."', '". check_input($edit[answer]) ."', '". check_input($edit[weight]) ."')");
watchdog("message", "faq: added '$edit[question]'");
}
function faq_delete($id) {
db_query("DELETE FROM faqs WHERE id = '$id'");
}
function faq_edit($id) {
global $allowed_html;
$result = db_query("SELECT * FROM faqs WHERE id = '$id'");
$faq = db_fetch_object($result);
$output .= "<FORM ACTION=\"admin.php?mod=faq&id=$id\" METHOD=\"post\">\n";
$output .= "<B>Question:</B><BR>\n";
$output .= "<INPUT TYPE=\"text\" NAME=\"edit[question]\" SIZE=\"50\" MAXLENGTH=\"128\" VALUE=\"". check_textfield($faq->question) ."\"><P>\n";
$output .= "<B>Answer:</B><BR>\n";
$output .= "<TEXTAREA WRAP=\"virtual\" COLS=\"50\" ROWS=\"10\" NAME=\"edit[answer]\">". check_textarea($faq->answer) ."</TEXTAREA><BR>\n";
$output .= "<SMALL><I>Allowed HTML tags: ". htmlspecialchars($allowed_html) .".</I></SMALL><P>\n";
$output .= "<B>Weight:</B><BR>\n";
for ($count = 0; $count < 20; $count++) $weight .= "<OPTION VALUE=\"$count\"". (($faq->weight == $count) ? " SELECTED" : "") .">$count</OPTION>\n";
$output .= "<SELECT NAME=\"edit[weight]\">$weight</SELECT><P>\n";
$output .= "<INPUT TYPE=\"submit\" NAME=\"op\" VALUE=\"Save FAQ\">\n";
$output .= "</FORM>\n";
print $output;
}
function faq_edit_save($id, $edit) {
db_query("UPDATE faqs SET question = '". check_input($edit[question]) ."', answer = '". check_input($edit[answer]) ."', weight = '". check_input($edit[weight]) ."' WHERE id = '$id'");
watchdog("message", "faq: modified `$edit[question]'");
}
function faq_display() {
$result = db_query("SELECT * FROM faqs ORDER BY weight");
$output .= "<TABLE BORDER=\"1\" CELLPADDING=\"2\" CELLSPACING=\"2\">\n";
$output .= " <TR><TH>question</TH><TH>weight</TH><TH COLSPAN=\"2\">operations</TH><TR>\n";
while ($faq = db_fetch_object($result)) {
$output .= " <TR><TD>". check_output($faq->question) ."</TD><TD ALIGN=\"center\">$faq->weight</TD><TD><A HREF=\"admin.php?mod=faq&op=edit&id=$faq->id\">edit</A></TD><TD><A HREF=\"admin.php?mod=faq&op=delete&id=$faq->id\">delete</A></TD>\n";
}
$output .= "</TABLE>\n";
print $output;
}
function faq_admin() {
global $op, $id, $edit;
print "<SMALL><A HREF=\"admin.php?mod=faq&op=add\">add new faq</A> | <A HREF=\"admin.php?mod=faq\">overview</A></SMALL><HR>\n";
switch ($op) {
case "add":
faq_add();
break;
case "delete":
faq_delete(check_input($id));
faq_display();
break;
case "edit":
faq_edit(check_input($id));
break;
case "Add FAQ":
faq_add_save($edit);
faq_display();
break;
case "Save FAQ":
faq_edit_save(check_input($id), $edit);
// fall through:
default:
faq_display();
}
}
?>
|