Mercurial > hg > fapweb
annotate msite.inc.php @ 72:63a6caf59e5c
Fix creation of boolean settings, and add '%b' formatter into stPrepareSQL().
author | Matti Hamalainen <ccr@tnsp.org> |
---|---|
date | Thu, 17 Oct 2013 15:01:20 +0300 |
parents | d74fb8cf0062 |
children | 3da47d3e6a3c |
rev | line source |
---|---|
0 | 1 <? |
2 // | |
9
fa9b66f596bb
More work on settings storage.
Matti Hamalainen <ccr@tnsp.org>
parents:
8
diff
changeset
|
3 // FAPWEB - Demo Party Website System System |
33 | 4 // Generic and miscellaneous site support code |
9
fa9b66f596bb
More work on settings storage.
Matti Hamalainen <ccr@tnsp.org>
parents:
8
diff
changeset
|
5 // (C) Copyright 2012 Matti 'ccr' Hamalainen <ccr@tnsp.org> |
0 | 6 // |
9
fa9b66f596bb
More work on settings storage.
Matti Hamalainen <ccr@tnsp.org>
parents:
8
diff
changeset
|
7 |
fa9b66f596bb
More work on settings storage.
Matti Hamalainen <ccr@tnsp.org>
parents:
8
diff
changeset
|
8 // Globals and definitions |
0 | 9 $errorSet = FALSE; |
10 $errorMsg = ""; | |
11 | |
8
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
12 define("VT_STR", 1); |
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
13 define("VT_INT", 2); |
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
14 define("VT_BOOL", 3); |
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
15 define("VT_TEXT", 4); |
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
16 |
51 | 17 define("SESS_USER", "user"); |
18 define("SESS_ADMIN", "admin"); | |
19 | |
8
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
20 |
32 | 21 if (function_exists("ini_set")) |
22 { | |
23 // Use cookies to store the session ID on the client side | |
24 @ini_set("session.use_only_cookies", 1); | |
25 | |
26 // Disable transparent Session ID support | |
27 @ini_set("session.use_trans_sid", 0); | |
28 } | |
29 | |
30 | |
0 | 31 function stError($msg) |
32 { | |
33 global $errorSet, $errorMsg; | |
34 $errorSet = TRUE; | |
35 $errorMsg .= "<li>".$msg."</li>\n"; | |
36 } | |
37 | |
38 | |
39 function stCheckHTTPS() | |
40 { | |
41 return isset($_SERVER["HTTPS"]) && ($_SERVER["HTTPS"] != "" && $_SERVER["HTTPS"] != "off"); | |
42 } | |
43 | |
44 | |
5
76c3b89d7b11
Improve voting, clean up the code, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
0
diff
changeset
|
45 function stSetupCacheControl() |
76c3b89d7b11
Improve voting, clean up the code, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
0
diff
changeset
|
46 { |
8
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
47 header("Cache-Control: must-revalidate, no-store, private"); |
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
48 header("Expires: Sat, 26 Jul 1997 05:00:00 GMT"); // Date in the past |
5
76c3b89d7b11
Improve voting, clean up the code, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
0
diff
changeset
|
49 } |
76c3b89d7b11
Improve voting, clean up the code, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
0
diff
changeset
|
50 |
76c3b89d7b11
Improve voting, clean up the code, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
0
diff
changeset
|
51 |
8
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
52 function stReloadSettings() |
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
53 { |
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
54 global $siteSettings; |
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
55 $res = stExecSQL("SELECT * FROM settings"); |
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
56 if ($res !== FALSE) |
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
57 { |
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
58 foreach ($res as $row) |
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
59 { |
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
60 switch ($row["vtype"]) |
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
61 { |
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
62 case VT_INT: $val = intval($row["vint"]); break; |
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
63 case VT_BOOL: $val = intval($row["vint"]) ? true : false; break; |
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
64 case VT_STR: $val = $row["vstr"]; break; |
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
65 case VT_TEXT: $val = $row["vtext"]; break; |
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
66 } |
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
67 $siteSettings[$row["key"]] = $val; |
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
68 } |
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
69 } |
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
70 else |
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
71 die("Error fetching site settings."); |
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
72 } |
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
73 |
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
74 |
5
76c3b89d7b11
Improve voting, clean up the code, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
0
diff
changeset
|
75 function stGetSetting($name) |
0 | 76 { |
8
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
77 global $siteSettings; |
0 | 78 if (isset($siteSettings[$name])) |
79 return $siteSettings[$name]; | |
80 else | |
8
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
81 die("No config value for '".$name."'.\n"); |
0 | 82 } |
83 | |
84 | |
85 function stChkSetting($name) | |
86 { | |
87 global $siteSettings; | |
88 return isset($siteSettings[$name]) && $siteSettings[$name]; | |
89 } | |
90 | |
91 | |
92 function dhentities($str) | |
93 { | |
94 return str_replace(array("<",">"), array("<", ">"), htmlentities($str, ENT_NOQUOTES, "UTF-8")); | |
95 } | |
96 | |
97 | |
98 function chentities($str) | |
99 { | |
100 return htmlentities($str, ENT_NOQUOTES, "UTF-8"); | |
101 } | |
102 | |
103 | |
12
358534308c61
Clean up some of the html item generation code.
Matti Hamalainen <ccr@tnsp.org>
parents:
9
diff
changeset
|
104 function stGetIDName($name, $id, $prefix = "") |
358534308c61
Clean up some of the html item generation code.
Matti Hamalainen <ccr@tnsp.org>
parents:
9
diff
changeset
|
105 { |
358534308c61
Clean up some of the html item generation code.
Matti Hamalainen <ccr@tnsp.org>
parents:
9
diff
changeset
|
106 return |
358534308c61
Clean up some of the html item generation code.
Matti Hamalainen <ccr@tnsp.org>
parents:
9
diff
changeset
|
107 ($id != "" ? "id=\"".$prefix.$name.$id."\" " : ""). |
358534308c61
Clean up some of the html item generation code.
Matti Hamalainen <ccr@tnsp.org>
parents:
9
diff
changeset
|
108 ($name != "" ? "name=\"".$prefix.$name.$id."\" " : ""); |
358534308c61
Clean up some of the html item generation code.
Matti Hamalainen <ccr@tnsp.org>
parents:
9
diff
changeset
|
109 } |
358534308c61
Clean up some of the html item generation code.
Matti Hamalainen <ccr@tnsp.org>
parents:
9
diff
changeset
|
110 |
358534308c61
Clean up some of the html item generation code.
Matti Hamalainen <ccr@tnsp.org>
parents:
9
diff
changeset
|
111 |
0 | 112 function stGetFormCheckBoxInput($name, $id, $prefix, $checked, $label, $extra = "") |
113 { | |
114 return | |
12
358534308c61
Clean up some of the html item generation code.
Matti Hamalainen <ccr@tnsp.org>
parents:
9
diff
changeset
|
115 "<input ".$extra." type=\"checkbox\" ".stGetIDName($name, $id, $prefix). |
358534308c61
Clean up some of the html item generation code.
Matti Hamalainen <ccr@tnsp.org>
parents:
9
diff
changeset
|
116 ($checked ? "checked=\"checked\" " : "")." />". |
358534308c61
Clean up some of the html item generation code.
Matti Hamalainen <ccr@tnsp.org>
parents:
9
diff
changeset
|
117 ($label != "" ? "<label for=\"".$name."\">".$label."</label>" : ""); |
0 | 118 } |
119 | |
120 | |
26
7be3f8cf1f7a
Lots of cleanups, preparing for adding entry submission support.
Matti Hamalainen <ccr@tnsp.org>
parents:
24
diff
changeset
|
121 function stGetFormRadioButtonInput($name, $id, $prefix, $value, $checked, $label, $extra = "") |
7be3f8cf1f7a
Lots of cleanups, preparing for adding entry submission support.
Matti Hamalainen <ccr@tnsp.org>
parents:
24
diff
changeset
|
122 { |
7be3f8cf1f7a
Lots of cleanups, preparing for adding entry submission support.
Matti Hamalainen <ccr@tnsp.org>
parents:
24
diff
changeset
|
123 return |
7be3f8cf1f7a
Lots of cleanups, preparing for adding entry submission support.
Matti Hamalainen <ccr@tnsp.org>
parents:
24
diff
changeset
|
124 "<input ".$extra." type=\"radio\" ".stGetIDName($name, $id, $prefix). |
7be3f8cf1f7a
Lots of cleanups, preparing for adding entry submission support.
Matti Hamalainen <ccr@tnsp.org>
parents:
24
diff
changeset
|
125 ($checked ? "checked=\"checked\" " : "")." value=\"".$value."\" />". |
7be3f8cf1f7a
Lots of cleanups, preparing for adding entry submission support.
Matti Hamalainen <ccr@tnsp.org>
parents:
24
diff
changeset
|
126 ($label != "" ? "<label for=\"".$name."\">".$label."</label>" : ""); |
7be3f8cf1f7a
Lots of cleanups, preparing for adding entry submission support.
Matti Hamalainen <ccr@tnsp.org>
parents:
24
diff
changeset
|
127 } |
7be3f8cf1f7a
Lots of cleanups, preparing for adding entry submission support.
Matti Hamalainen <ccr@tnsp.org>
parents:
24
diff
changeset
|
128 |
7be3f8cf1f7a
Lots of cleanups, preparing for adding entry submission support.
Matti Hamalainen <ccr@tnsp.org>
parents:
24
diff
changeset
|
129 |
0 | 130 function stGetFormButtonInput($name, $id, $prefix, $label, $onclick = "") |
131 { | |
132 return | |
12
358534308c61
Clean up some of the html item generation code.
Matti Hamalainen <ccr@tnsp.org>
parents:
9
diff
changeset
|
133 "<input type=\"button\" ".stGetIDName($name, $id, $prefix). |
26
7be3f8cf1f7a
Lots of cleanups, preparing for adding entry submission support.
Matti Hamalainen <ccr@tnsp.org>
parents:
24
diff
changeset
|
134 "value=\" ".chentities($label)." \" ". |
0 | 135 ($onclick != "" ? "onClick=\"".$onclick."\"" : "")." />"; |
136 } | |
137 | |
138 | |
139 function stGetFormTextArea($rows, $cols, $name, $id, $prefix, $value, $extra = "") | |
140 { | |
141 return | |
12
358534308c61
Clean up some of the html item generation code.
Matti Hamalainen <ccr@tnsp.org>
parents:
9
diff
changeset
|
142 "<textarea ".$extra." ".stGetIDName($name, $id, $prefix). |
358534308c61
Clean up some of the html item generation code.
Matti Hamalainen <ccr@tnsp.org>
parents:
9
diff
changeset
|
143 "rows=\"".$rows."\" cols=\"".$cols."\">". |
0 | 144 (isset($value) ? chentities($value) : ""). |
145 "</textarea>"; | |
146 } | |
147 | |
148 | |
149 function stGetFormTextInput($size, $len, $name, $id, $prefix, $value, $extra = "") | |
150 { | |
151 return | |
12
358534308c61
Clean up some of the html item generation code.
Matti Hamalainen <ccr@tnsp.org>
parents:
9
diff
changeset
|
152 "<input ".$extra." type=\"text\" ".stGetIDName($name, $id, $prefix). |
358534308c61
Clean up some of the html item generation code.
Matti Hamalainen <ccr@tnsp.org>
parents:
9
diff
changeset
|
153 "size=\"".$size."\" maxlength=\"".$len."\"". |
0 | 154 (isset($value) ? " value=\"".chentities($value)."\"" : ""). |
155 " />"; | |
156 } | |
157 | |
158 | |
159 function stGetFormPasswordInput($name, $id, $prefix) | |
160 { | |
161 return | |
13 | 162 "<input type=\"password\" ".stGetIDName($name, $id, $prefix)." />"; |
0 | 163 } |
164 | |
165 | |
26
7be3f8cf1f7a
Lots of cleanups, preparing for adding entry submission support.
Matti Hamalainen <ccr@tnsp.org>
parents:
24
diff
changeset
|
166 function stGetFormSubmitInput($name, $label, $onclick = "") |
7be3f8cf1f7a
Lots of cleanups, preparing for adding entry submission support.
Matti Hamalainen <ccr@tnsp.org>
parents:
24
diff
changeset
|
167 { |
7be3f8cf1f7a
Lots of cleanups, preparing for adding entry submission support.
Matti Hamalainen <ccr@tnsp.org>
parents:
24
diff
changeset
|
168 return |
7be3f8cf1f7a
Lots of cleanups, preparing for adding entry submission support.
Matti Hamalainen <ccr@tnsp.org>
parents:
24
diff
changeset
|
169 "<input type=\"submit\" name=\"".$name. |
7be3f8cf1f7a
Lots of cleanups, preparing for adding entry submission support.
Matti Hamalainen <ccr@tnsp.org>
parents:
24
diff
changeset
|
170 "\" value=\" ".chentities($label)." \" ". |
7be3f8cf1f7a
Lots of cleanups, preparing for adding entry submission support.
Matti Hamalainen <ccr@tnsp.org>
parents:
24
diff
changeset
|
171 ($onclick != "" ? "onClick=\"".$onclick."\"" : "")." />"; |
7be3f8cf1f7a
Lots of cleanups, preparing for adding entry submission support.
Matti Hamalainen <ccr@tnsp.org>
parents:
24
diff
changeset
|
172 } |
7be3f8cf1f7a
Lots of cleanups, preparing for adding entry submission support.
Matti Hamalainen <ccr@tnsp.org>
parents:
24
diff
changeset
|
173 |
7be3f8cf1f7a
Lots of cleanups, preparing for adding entry submission support.
Matti Hamalainen <ccr@tnsp.org>
parents:
24
diff
changeset
|
174 |
0 | 175 function stGetFormHiddenInput($name, $value) |
176 { | |
12
358534308c61
Clean up some of the html item generation code.
Matti Hamalainen <ccr@tnsp.org>
parents:
9
diff
changeset
|
177 return |
358534308c61
Clean up some of the html item generation code.
Matti Hamalainen <ccr@tnsp.org>
parents:
9
diff
changeset
|
178 "<input type=\"hidden\" name=\"".$name. |
358534308c61
Clean up some of the html item generation code.
Matti Hamalainen <ccr@tnsp.org>
parents:
9
diff
changeset
|
179 "\" value=\"".chentities($value)."\" />"; |
0 | 180 } |
181 | |
182 | |
26
7be3f8cf1f7a
Lots of cleanups, preparing for adding entry submission support.
Matti Hamalainen <ccr@tnsp.org>
parents:
24
diff
changeset
|
183 function stGetFormStart($name, $action = "", $method = "post") |
7be3f8cf1f7a
Lots of cleanups, preparing for adding entry submission support.
Matti Hamalainen <ccr@tnsp.org>
parents:
24
diff
changeset
|
184 { |
7be3f8cf1f7a
Lots of cleanups, preparing for adding entry submission support.
Matti Hamalainen <ccr@tnsp.org>
parents:
24
diff
changeset
|
185 return |
7be3f8cf1f7a
Lots of cleanups, preparing for adding entry submission support.
Matti Hamalainen <ccr@tnsp.org>
parents:
24
diff
changeset
|
186 "<form name=\"".$name."\" action=\"". |
7be3f8cf1f7a
Lots of cleanups, preparing for adding entry submission support.
Matti Hamalainen <ccr@tnsp.org>
parents:
24
diff
changeset
|
187 ($action != "" ? $action : $name). |
7be3f8cf1f7a
Lots of cleanups, preparing for adding entry submission support.
Matti Hamalainen <ccr@tnsp.org>
parents:
24
diff
changeset
|
188 "\" method=\"".$method."\">\n"; |
7be3f8cf1f7a
Lots of cleanups, preparing for adding entry submission support.
Matti Hamalainen <ccr@tnsp.org>
parents:
24
diff
changeset
|
189 } |
7be3f8cf1f7a
Lots of cleanups, preparing for adding entry submission support.
Matti Hamalainen <ccr@tnsp.org>
parents:
24
diff
changeset
|
190 |
7be3f8cf1f7a
Lots of cleanups, preparing for adding entry submission support.
Matti Hamalainen <ccr@tnsp.org>
parents:
24
diff
changeset
|
191 |
0 | 192 function stGetTDEditTextItem($edit, $size, $len, $name, $id, $prefix, $value, $extra = "") |
193 { | |
194 return | |
195 "<td class=\"".$name."\">". | |
196 ($edit ? stGetFormTextInput($size, $len, $name, $id, $prefix, $value, $extra) : chentities($value)). | |
197 "</td>"; | |
198 } | |
199 | |
200 | |
201 function stPrintFormTextInput($text1, $text2, $size, $len, $name, $extra="") | |
202 { | |
203 echo " <tr><th>".chentities($text1)."</th><td>". | |
15
ea0f98a0bed8
Fix some issues and bugs caused by recent changes.
Matti Hamalainen <ccr@tnsp.org>
parents:
13
diff
changeset
|
204 stGetFormTextInput($size, $len, $name, "", "", stGetRequestItem($name), $extra). |
0 | 205 "</td><td>".chentities($text2)."</td></tr>\n"; |
206 } | |
207 | |
208 | |
209 function stPrintFormHiddenInput($name, $value) | |
210 { | |
211 echo " ".stGetFormHiddenInput($name, $value)."\n"; | |
212 } | |
213 | |
214 | |
215 function stChkDataItem($name) | |
216 { | |
217 return !isset($_REQUEST[$name]) || strlen(trim($_REQUEST[$name])) < 1; | |
218 } | |
219 | |
220 | |
221 function stChkRequestItem($name) | |
222 { | |
223 return isset($_REQUEST[$name]); | |
224 } | |
225 | |
226 | |
227 function stGetRequestItem($name, $default = "") | |
228 { | |
229 return isset($_REQUEST[$name]) ? trim($_REQUEST[$name]) : $default; | |
230 } | |
231 | |
232 | |
233 function stGetDRequestItem($name, $default = "") | |
234 { | |
235 return trim(urldecode(stGetRequestItem($name, $default))); | |
236 } | |
237 | |
238 | |
239 function stLogSQLError($sql) | |
240 { | |
241 global $db; | |
242 error_log("SQL error ".implode("; ", $db->errorInfo())." in statement \"".$sql."\""); | |
243 } | |
244 | |
245 | |
246 function stConnectSQLDB() | |
247 { | |
248 global $db; | |
249 try { | |
8
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
250 $db = new PDO(stGetSetting("sqlDB")); |
0 | 251 } |
252 catch (PDOException $e) { | |
253 error_log("Could not connect to SQL database: ".$e->getMessage()."."); | |
254 return FALSE; | |
255 } | |
256 return TRUE; | |
257 } | |
258 | |
259 | |
260 function stGetSQLParam($type, $value) | |
261 { | |
262 global $db; | |
263 switch ($type) | |
264 { | |
265 case "d": | |
266 return intval($value); | |
267 | |
268 case "s": | |
269 return $db->quote($value); | |
270 | |
72
63a6caf59e5c
Fix creation of boolean settings, and add '%b' formatter into stPrepareSQL().
Matti Hamalainen <ccr@tnsp.org>
parents:
71
diff
changeset
|
271 case "b": |
63a6caf59e5c
Fix creation of boolean settings, and add '%b' formatter into stPrepareSQL().
Matti Hamalainen <ccr@tnsp.org>
parents:
71
diff
changeset
|
272 return intval($value) ? 1 : 0; |
63a6caf59e5c
Fix creation of boolean settings, and add '%b' formatter into stPrepareSQL().
Matti Hamalainen <ccr@tnsp.org>
parents:
71
diff
changeset
|
273 |
0 | 274 case "D": |
275 return intval(stGetRequestItem($value)); | |
276 | |
277 case "S": | |
278 return $db->quote(stGetDRequestItem($value)); | |
279 | |
280 case "Q": | |
281 return $db->quote(stripslashes(stGetDRequestItem($value))); | |
282 | |
283 case "B": | |
284 return intval(stGetRequestItem($value)) ? 1 : 0; | |
285 } | |
286 } | |
287 | |
288 | |
289 function stPrepareSQL() | |
290 { | |
291 $argc = func_num_args(); | |
292 $argv = func_get_args(); | |
293 if ($argc < 1) | |
294 { | |
295 error_log("Invalid stPrepareSQL() call, no arguments!"); | |
296 return FALSE; | |
297 } | |
298 | |
299 $fmt = $argv[0]; | |
300 $len = strlen($fmt); | |
301 $sql = ""; | |
302 $argn = 1; | |
303 $pos = 0; | |
304 while ($pos < $len) | |
305 { | |
306 if ($fmt[$pos] == "%") | |
307 { | |
308 if ($argn < $argc) | |
309 $sql .= stGetSQLParam($fmt[++$pos], $argv[$argn++]); | |
310 else | |
311 { | |
312 error_log("Invalid SQL statement format string '".$fmt. | |
313 "', not enough parameters specified (".$argn." of ".$argc.")"); | |
314 return FALSE; | |
315 } | |
316 } | |
317 else | |
318 $sql .= $fmt[$pos]; | |
319 $pos++; | |
320 } | |
321 | |
322 return $sql; | |
323 } | |
324 | |
325 | |
326 function stPrepareSQLUpdate($table, $cond, $pairs) | |
327 { | |
328 $sql = array(); | |
329 foreach ($pairs as $name => $attr) | |
330 { | |
331 $sql[] = $name."=".stGetSQLParam($attr, $name); | |
332 } | |
333 return | |
334 "UPDATE ".$table." SET ".implode(",", $sql). | |
335 ($cond != "" ? " ".$cond : ""); | |
336 } | |
337 | |
338 | |
339 function stExecSQL($sql) | |
340 { | |
341 global $db; | |
342 if (($res = $db->query($sql)) !== FALSE) | |
343 return $res; | |
344 else | |
345 { | |
346 stLogSQLError($sql); | |
347 stError("Oh noes! SQL error #23!"); | |
348 return FALSE; | |
349 } | |
350 } | |
351 | |
352 | |
353 function stFetchSQL($sql) | |
354 { | |
355 global $db; | |
356 if (($res = $db->query($sql)) !== FALSE) | |
357 { | |
358 return $res->fetch(); | |
359 } | |
360 else | |
361 { | |
362 stLogSQLError($sql); | |
363 stError("Oh noes! SQL error #31!"); | |
364 return FALSE; | |
365 } | |
366 } | |
367 | |
368 | |
369 function stFetchSQLColumn($sql, $column = 0) | |
370 { | |
371 global $db; | |
372 if (($res = $db->query($sql)) !== FALSE) | |
373 { | |
374 return $res->fetchColumn($column); | |
375 } | |
376 else | |
377 { | |
378 stLogSQLError($sql); | |
379 stError("Oh noes! SQL error #81!"); | |
380 return FALSE; | |
381 } | |
382 } | |
383 | |
384 | |
8
4c5f651aa107
Migrate certain settings to SQL database, cleanups, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
7
diff
changeset
|
385 // |
37 | 386 // Site-specific common functions .. these should be elsewhere |
387 // | |
388 function stPrintAttendee($item, $row, $edit, $eclass = "") | |
389 { | |
390 $id = $item["id"]; | |
391 $prefix = "at"; | |
71
d74fb8cf0062
Adjust attendee output again, we're separating vote keys from there once more. Durr.
Matti Hamalainen <ccr@tnsp.org>
parents:
70
diff
changeset
|
392 echo " <tr class=\"".($row % 2 == 1 ? "rodd" : "reven")."\" id=\"attendee".$id."\">"; |
53
71256605546b
More work on admin interface.
Matti Hamalainen <ccr@tnsp.org>
parents:
52
diff
changeset
|
393 |
71
d74fb8cf0062
Adjust attendee output again, we're separating vote keys from there once more. Durr.
Matti Hamalainen <ccr@tnsp.org>
parents:
70
diff
changeset
|
394 echo |
37 | 395 stGetTDEditTextItem(FALSE, 20, 40, "name", $id, $prefix, $item["name"]). |
396 stGetTDEditTextItem(FALSE, 20, 40, "groups", $id, $prefix, $item["groups"]). | |
71
d74fb8cf0062
Adjust attendee output again, we're separating vote keys from there once more. Durr.
Matti Hamalainen <ccr@tnsp.org>
parents:
70
diff
changeset
|
397 "<td class=\"regtime\">".date("d.m. H:i", $item["regtime"])."</td>". |
37 | 398 stGetTDEditTextItem($edit, 30, 64, "oneliner", $id, $prefix, $item["oneliner"], "autocomplete=\"off\""); |
399 | |
400 if ($edit) | |
401 { | |
402 echo | |
403 stGetTDEditTextItem($edit, 20, 40, "email", $id, $prefix, $item["email"], "autocomplete=\"off\""). | |
404 "<td>". | |
71
d74fb8cf0062
Adjust attendee output again, we're separating vote keys from there once more. Durr.
Matti Hamalainen <ccr@tnsp.org>
parents:
70
diff
changeset
|
405 "<button class=\"button\" id=\"atupd".$id."\" type=\"button\" onclick=\"updateAttendee(".$id.")\"> Upd </button>". |
d74fb8cf0062
Adjust attendee output again, we're separating vote keys from there once more. Durr.
Matti Hamalainen <ccr@tnsp.org>
parents:
70
diff
changeset
|
406 "<button class=\"button\" id=\"atdel".$id."\" type=\"button\" onclick=\"deleteAttendee(".$id.")\"> Del </button>". |
d74fb8cf0062
Adjust attendee output again, we're separating vote keys from there once more. Durr.
Matti Hamalainen <ccr@tnsp.org>
parents:
70
diff
changeset
|
407 "</td>"; |
37 | 408 } |
409 | |
410 echo "</tr>\n"; | |
411 } | |
412 | |
413 | |
414 function stPrintNewsItem($item, $edit = "") | |
415 { | |
416 echo | |
417 "<div class=\"newsitem\" id=\"news".$item["id"]."\">\n". | |
418 " <h2>".chentities($item["title"])."</h2>\n". | |
419 " <div class=\"text\">".dhentities($item["text"])."</div>\n". | |
420 " <div class=\"sig\">-- ".chentities($item["author"])."<br />". | |
421 date("d M Y / H:i", $item["utime"]). | |
422 $edit."</div>\n". | |
423 "</div>\n"; | |
424 } | |
425 | |
426 | |
427 function stGetCompoList($fvisible, $fvoting = FALSE) | |
428 { | |
429 global $compos; | |
430 | |
431 // Get entries and competitions into an array structure | |
432 $sql = "SELECT * FROM compos"; | |
433 if ($fvisible || $fvoting) | |
434 { | |
435 $sql .= " WHERE ".implode(" AND ", array($fvisible ? "visible<>0" : "", $fvoting ? "voting<>0" : "")); | |
436 } | |
437 foreach (stExecSQL($sql) as $compo) | |
438 { | |
439 $id = $compo["id"]; | |
440 | |
441 $compos[$compo["id"]] = array( | |
442 "name" => $compo["name"], | |
443 "entries" => array() | |
444 ); | |
445 | |
446 $sql = stPrepareSQL("SELECT * FROM entries WHERE compo_id=%d", $id); | |
447 foreach (stExecSQL($sql) as $entry) | |
448 { | |
449 $compos[$id]["entries"][$entry["id"]] = $entry; | |
450 } | |
451 } | |
452 } | |
453 | |
454 | |
69
30a4420e85ab
stGenerateUserKey() simply returns a generated key now (string) or FALSE if
Matti Hamalainen <ccr@tnsp.org>
parents:
66
diff
changeset
|
455 function stGenerateUserKey() |
65
72b22729ae7e
Add function for generating vote keys into site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
53
diff
changeset
|
456 { |
69
30a4420e85ab
stGenerateUserKey() simply returns a generated key now (string) or FALSE if
Matti Hamalainen <ccr@tnsp.org>
parents:
66
diff
changeset
|
457 global $db; |
65
72b22729ae7e
Add function for generating vote keys into site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
53
diff
changeset
|
458 $keyChars = "abcdefghjkmnpqrstuvwxyzABCDEFGHJKLMNPQRSTUVWXYZ23456789"; |
72b22729ae7e
Add function for generating vote keys into site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
53
diff
changeset
|
459 |
72b22729ae7e
Add function for generating vote keys into site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
53
diff
changeset
|
460 while (TRUE) |
72b22729ae7e
Add function for generating vote keys into site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
53
diff
changeset
|
461 { |
69
30a4420e85ab
stGenerateUserKey() simply returns a generated key now (string) or FALSE if
Matti Hamalainen <ccr@tnsp.org>
parents:
66
diff
changeset
|
462 // Generate one randomized keycode |
65
72b22729ae7e
Add function for generating vote keys into site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
53
diff
changeset
|
463 $key = ""; |
72b22729ae7e
Add function for generating vote keys into site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
53
diff
changeset
|
464 for ($n = 0; $n < stGetSetting("userKeyLength"); $n++) |
72b22729ae7e
Add function for generating vote keys into site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
53
diff
changeset
|
465 $key .= $keyChars[rand() % strlen($keyChars)]; |
72b22729ae7e
Add function for generating vote keys into site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
53
diff
changeset
|
466 |
72b22729ae7e
Add function for generating vote keys into site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
53
diff
changeset
|
467 // Check if it already exists, to avoid duplicates |
69
30a4420e85ab
stGenerateUserKey() simply returns a generated key now (string) or FALSE if
Matti Hamalainen <ccr@tnsp.org>
parents:
66
diff
changeset
|
468 // We need custom query code here, because stFetchSQLColumn() |
30a4420e85ab
stGenerateUserKey() simply returns a generated key now (string) or FALSE if
Matti Hamalainen <ccr@tnsp.org>
parents:
66
diff
changeset
|
469 // won't work due to it returning FALSE in error cases. |
65
72b22729ae7e
Add function for generating vote keys into site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
53
diff
changeset
|
470 $sql = stPrepareSQL("SELECT * FROM attendees WHERE key=%s", $key); |
72b22729ae7e
Add function for generating vote keys into site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
53
diff
changeset
|
471 if (($res = @$db->query($sql)) !== FALSE) |
72b22729ae7e
Add function for generating vote keys into site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
53
diff
changeset
|
472 { |
69
30a4420e85ab
stGenerateUserKey() simply returns a generated key now (string) or FALSE if
Matti Hamalainen <ccr@tnsp.org>
parents:
66
diff
changeset
|
473 // Did we get results? |
65
72b22729ae7e
Add function for generating vote keys into site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
53
diff
changeset
|
474 if ($res->fetchColumn() === FALSE) |
72b22729ae7e
Add function for generating vote keys into site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
53
diff
changeset
|
475 { |
69
30a4420e85ab
stGenerateUserKey() simply returns a generated key now (string) or FALSE if
Matti Hamalainen <ccr@tnsp.org>
parents:
66
diff
changeset
|
476 // Nope, return key |
30a4420e85ab
stGenerateUserKey() simply returns a generated key now (string) or FALSE if
Matti Hamalainen <ccr@tnsp.org>
parents:
66
diff
changeset
|
477 return $key; |
65
72b22729ae7e
Add function for generating vote keys into site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
53
diff
changeset
|
478 } |
72b22729ae7e
Add function for generating vote keys into site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
53
diff
changeset
|
479 } |
72b22729ae7e
Add function for generating vote keys into site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
53
diff
changeset
|
480 else |
72b22729ae7e
Add function for generating vote keys into site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
53
diff
changeset
|
481 { |
72b22729ae7e
Add function for generating vote keys into site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
53
diff
changeset
|
482 stLogSQLError($sql); |
72b22729ae7e
Add function for generating vote keys into site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
53
diff
changeset
|
483 return FALSE; |
72b22729ae7e
Add function for generating vote keys into site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
53
diff
changeset
|
484 } |
72b22729ae7e
Add function for generating vote keys into site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
53
diff
changeset
|
485 } |
72b22729ae7e
Add function for generating vote keys into site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
53
diff
changeset
|
486 } |
66
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
487 |
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
488 |
70
d31fc2c53b2b
Added stUpdateUserKey(uid) for updating / regenerating a vote key for given UID.
Matti Hamalainen <ccr@tnsp.org>
parents:
69
diff
changeset
|
489 function stUpdateUserKey($uid) |
d31fc2c53b2b
Added stUpdateUserKey(uid) for updating / regenerating a vote key for given UID.
Matti Hamalainen <ccr@tnsp.org>
parents:
69
diff
changeset
|
490 { |
d31fc2c53b2b
Added stUpdateUserKey(uid) for updating / regenerating a vote key for given UID.
Matti Hamalainen <ccr@tnsp.org>
parents:
69
diff
changeset
|
491 if (($res = stGenerateUserKey()) !== FALSE) |
d31fc2c53b2b
Added stUpdateUserKey(uid) for updating / regenerating a vote key for given UID.
Matti Hamalainen <ccr@tnsp.org>
parents:
69
diff
changeset
|
492 { |
d31fc2c53b2b
Added stUpdateUserKey(uid) for updating / regenerating a vote key for given UID.
Matti Hamalainen <ccr@tnsp.org>
parents:
69
diff
changeset
|
493 // Nope, add key into database |
d31fc2c53b2b
Added stUpdateUserKey(uid) for updating / regenerating a vote key for given UID.
Matti Hamalainen <ccr@tnsp.org>
parents:
69
diff
changeset
|
494 $sql = stPrepareSQL( |
d31fc2c53b2b
Added stUpdateUserKey(uid) for updating / regenerating a vote key for given UID.
Matti Hamalainen <ccr@tnsp.org>
parents:
69
diff
changeset
|
495 "UPDATE attendees SET key=%s,active=0 WHERE id=%d", |
d31fc2c53b2b
Added stUpdateUserKey(uid) for updating / regenerating a vote key for given UID.
Matti Hamalainen <ccr@tnsp.org>
parents:
69
diff
changeset
|
496 $key, $uid); |
d31fc2c53b2b
Added stUpdateUserKey(uid) for updating / regenerating a vote key for given UID.
Matti Hamalainen <ccr@tnsp.org>
parents:
69
diff
changeset
|
497 |
d31fc2c53b2b
Added stUpdateUserKey(uid) for updating / regenerating a vote key for given UID.
Matti Hamalainen <ccr@tnsp.org>
parents:
69
diff
changeset
|
498 return stExecSQL($sql); |
d31fc2c53b2b
Added stUpdateUserKey(uid) for updating / regenerating a vote key for given UID.
Matti Hamalainen <ccr@tnsp.org>
parents:
69
diff
changeset
|
499 } |
d31fc2c53b2b
Added stUpdateUserKey(uid) for updating / regenerating a vote key for given UID.
Matti Hamalainen <ccr@tnsp.org>
parents:
69
diff
changeset
|
500 else |
d31fc2c53b2b
Added stUpdateUserKey(uid) for updating / regenerating a vote key for given UID.
Matti Hamalainen <ccr@tnsp.org>
parents:
69
diff
changeset
|
501 return FALSE; |
d31fc2c53b2b
Added stUpdateUserKey(uid) for updating / regenerating a vote key for given UID.
Matti Hamalainen <ccr@tnsp.org>
parents:
69
diff
changeset
|
502 } |
d31fc2c53b2b
Added stUpdateUserKey(uid) for updating / regenerating a vote key for given UID.
Matti Hamalainen <ccr@tnsp.org>
parents:
69
diff
changeset
|
503 |
d31fc2c53b2b
Added stUpdateUserKey(uid) for updating / regenerating a vote key for given UID.
Matti Hamalainen <ccr@tnsp.org>
parents:
69
diff
changeset
|
504 |
66
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
505 function stSetStatus($val, $msg) |
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
506 { |
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
507 global $statusSet; |
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
508 if (!$statusSet) |
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
509 { |
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
510 header("Status: ".$val." ".$msg); |
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
511 } |
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
512 $statusSet = TRUE; |
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
513 } |
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
514 |
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
515 |
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
516 function stExecSQLCond($sql, $okmsg) |
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
517 { |
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
518 if (($res = stExecSQL($sql)) !== FALSE) |
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
519 { |
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
520 if ($okmsg != "") |
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
521 stSetStatus(200, $okmsg); |
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
522 return $res; |
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
523 } |
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
524 else |
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
525 { |
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
526 stSetStatus(900, "Error in SQL execution."); |
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
527 return FALSE; |
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
528 } |
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
529 } |
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
530 |
230aacc22cb4
Move some functions to site lib.
Matti Hamalainen <ccr@tnsp.org>
parents:
65
diff
changeset
|
531 |
0 | 532 ?> |