1 |
<? |
2 |
|
3 |
// ----------------------------------------------- |
4 |
// exit_local() |
5 |
// ----------------------------------------------- |
6 |
function exit_local($print_err = 1) { |
7 |
drop_temp_table($print_err); |
8 |
exit; |
9 |
} |
10 |
|
11 |
// ----------------------------------------------- |
12 |
// print_error_local($str) |
13 |
// ----------------------------------------------- |
14 |
function print_error_local($str){ |
15 |
global $error; |
16 |
|
17 |
$error=$str; |
18 |
|
19 |
print_template('error'); |
20 |
print_template('bottom'); |
21 |
|
22 |
exit_local(0); |
23 |
} |
24 |
|
25 |
// ----------------------------------------------- |
26 |
// get_dict_tab(word) |
27 |
// ----------------------------------------------- |
28 |
function get_dict_tab($word) { |
29 |
global $dict_table; |
30 |
|
31 |
if (strlen($word)>16) return $dict_table[17]; |
32 |
return $dict_table[strlen($word)]; |
33 |
} |
34 |
|
35 |
// ----------------------------------------------- |
36 |
// is_stopword($word) |
37 |
// ----------------------------------------------- |
38 |
function is_stopword($word) { |
39 |
global $DEBUG; |
40 |
global $stopword_arr; |
41 |
|
42 |
if ($stopword_arr[$word]) return ($stopword_arr[$word]); |
43 |
|
44 |
$query="SELECT count(*) FROM stopword WHERE word='$word'"; |
45 |
if($DEBUG) echo "is_stopword(): ",$query,"<BR><HR>"; |
46 |
|
47 |
if (!($res=db_query($query))) print_error_local('Query error: '.$query."\n<BR>".db_error()); |
48 |
|
49 |
$row=db_fetchrow($res); |
50 |
db_freeresult($res); |
51 |
|
52 |
$stopword_arr[$word]=$row[0]; |
53 |
|
54 |
return ($row[0]); |
55 |
} |
56 |
|
57 |
// ----------------------------------------------- |
58 |
// get_doc_count() |
59 |
// ----------------------------------------------- |
60 |
function get_doc_count() { |
61 |
global $DEBUG; |
62 |
|
63 |
$query="SELECT count(*) FROM url"; |
64 |
if($DEBUG) echo "get_doc_count(): ",$query,"<BR><HR>"; |
65 |
|
66 |
if (!($res=db_query($query))) print_error_local('Query error: '.$query."\n<BR>".db_error()); |
67 |
|
68 |
$row=db_fetchrow($res); |
69 |
db_freeresult($res); |
70 |
|
71 |
return ($row[0]); |
72 |
} |
73 |
|
74 |
|
75 |
// ----------------------------------------------- |
76 |
// drop_temp_table() |
77 |
// ----------------------------------------------- |
78 |
function drop_temp_table($print_err) { |
79 |
global $temp_table; |
80 |
global $DEBUG; |
81 |
global $error; |
82 |
|
83 |
if ($temp_table != "") { |
84 |
$drop_temp_query="DROP TABLE $temp_table"; |
85 |
if($DEBUG) echo "drop_temp_table(): ",$drop_temp_query,"<BR><HR>"; |
86 |
|
87 |
if (!db_query($drop_temp_query)) { |
88 |
if (! $print_err) { |
89 |
print('Query error: '.$drop_temp_query."\n<BR>".db_error()); |
90 |
} else { |
91 |
$error='Query error: '.$drop_temp_query."\n<BR>".db_error(); |
92 |
print_template('error'); |
93 |
print_template('bottom'); |
94 |
} |
95 |
exit(); |
96 |
} |
97 |
} |
98 |
} |
99 |
|
100 |
// ----------------------------------------------- |
101 |
// track_query($query,$time,$found) |
102 |
// ----------------------------------------------- |
103 |
function track_query($query,$time,$found) { |
104 |
global $trackquery; |
105 |
global $DEBUG; |
106 |
|
107 |
if ($trackquery != 'yes') return; |
108 |
|
109 |
$q="INSERT INTO qtrack VALUES ( '$query', $time, $found)"; |
110 |
if($DEBUG) echo "track_query(): ",$q,"<BR><HR>"; |
111 |
|
112 |
if (!db_query($q)) print('Query error: '.$q."\n<BR>".db_error()); |
113 |
} |
114 |
|
115 |
// ----------------------------------------------- |
116 |
// format_lastmod($lastmod) |
117 |
// ----------------------------------------------- |
118 |
function format_lastmod($lastmod) { |
119 |
global $db_format; |
120 |
|
121 |
$temp=$lastmod; |
122 |
if ($db_format == '3.1') { |
123 |
if (!$temp) $temp = 'undefined'; |
124 |
else $temp = strftime('%a, %d %b %Y %H:%M:%S %Z',$temp); |
125 |
} else { |
126 |
if ($temp == '') $temp = 'undefined'; |
127 |
} |
128 |
|
129 |
return $temp; |
130 |
} |
131 |
|
132 |
// ----------------------------------------------- |
133 |
// format_dp($dp) |
134 |
// ----------------------------------------------- |
135 |
function format_dp($dp) { |
136 |
$result=0; |
137 |
|
138 |
while ($dp != '') { |
139 |
if (preg_match('/^([\-\+]?\d+)([sMhdmy]?)/',$dp,$param)) { |
140 |
switch ($param[2]) { |
141 |
case 's': $multiplier=1; break; |
142 |
case 'M': $multiplier=60; break; |
143 |
case 'h': $multiplier=3600; break; |
144 |
case 'd': $multiplier=3600*24; break; |
145 |
case 'm': $multiplier=3600*24*31; break; |
146 |
case 'y': $multiplier=3600*24*365; break; |
147 |
default: $multiplier=1; |
148 |
} |
149 |
|
150 |
$result += $param[1]*$multiplier; |
151 |
$dp=preg_replace("/^[\-\+]?\d+$param[2]/",'',$dp); |
152 |
} else { |
153 |
return 0; |
154 |
} |
155 |
} |
156 |
|
157 |
return $result; |
158 |
} |
159 |
|
160 |
// ----------------------------------------------- |
161 |
// format_userdate($date) |
162 |
// ----------------------------------------------- |
163 |
function format_userdate($date) { |
164 |
$result=0; |
165 |
|
166 |
if (preg_match('/^(\d+)\/(\d+)\/(\d+)$/',$date,$param)) { |
167 |
$day=$param[1]; |
168 |
$mon=$param[2]; |
169 |
$year=$param[3]; |
170 |
|
171 |
$result=mktime(0,0,0,$mon,$day,$year); |
172 |
} |
173 |
|
174 |
return $result; |
175 |
} |
176 |
|
177 |
// ----------------------------------------------- |
178 |
// load_cs($cat) |
179 |
// ----------------------------------------------- |
180 |
function load_cs($cat) { |
181 |
global $DEBUG; |
182 |
global $self; |
183 |
|
184 |
$query="SELECT path,link,name |
185 |
FROM categories |
186 |
WHERE path LIKE '$cat"."__' |
187 |
ORDER BY NAME ASC"; |
188 |
|
189 |
if($DEBUG) echo "load_cs(): ",$query,"<BR><HR>"; |
190 |
|
191 |
if (!($res=db_query($query))) print('Query error: '.$query."\n<BR>".db_error()); |
192 |
|
193 |
while($row=db_fetchrow($res)) { |
194 |
$path=$row[0]; |
195 |
$link=$row[1]; |
196 |
$name=$row[2]; |
197 |
|
198 |
if (substr($path,strlen($path)-2,2)=='@@') { |
199 |
$result .= "<a href=\"$self?cat=$link\">@ $name</a><br>\n"; |
200 |
} else { |
201 |
$result .= "<a href=\"$self?cat=$path\">$name</a><br>\n"; |
202 |
} |
203 |
} |
204 |
db_freeresult($res); |
205 |
|
206 |
return $result; |
207 |
} |
208 |
|
209 |
// ----------------------------------------------- |
210 |
// load_cp($cat) |
211 |
// ----------------------------------------------- |
212 |
function load_cp($cat) { |
213 |
global $DEBUG; |
214 |
global $self; |
215 |
global $cp_arr; |
216 |
|
217 |
if ($cp_arr[$cat]) return ($cp_arr[$cat]); |
218 |
|
219 |
$link_path=$cat; |
220 |
$link_name=''; |
221 |
|
222 |
while ($link_path!='') { |
223 |
$query="SELECT name FROM categories WHERE path='$link_path'"; |
224 |
|
225 |
if($DEBUG) echo "load_cp(): ",$query,"<BR><HR>"; |
226 |
|
227 |
if (!($res=db_query($query))) { |
228 |
print_error_local('Query error: '.$query."\n<BR>".db_error()); |
229 |
} |
230 |
|
231 |
$row=db_fetchrow($res); |
232 |
db_freeresult($res); |
233 |
|
234 |
if (!$row) { |
235 |
$link_path=substr($link_path,0,strlen($link_path)-2); |
236 |
continue; |
237 |
} |
238 |
|
239 |
$row[0]=htmlspecialchars($row[0]); |
240 |
|
241 |
$link_name = " > <a href=\"$self?cat=$link_path\">$row[0]</a>".$link_name; |
242 |
|
243 |
$link_path=substr($link_path,0,strlen($link_path)-2); |
244 |
} |
245 |
|
246 |
$query="SELECT name FROM categories WHERE path='' OR path IS NULL"; |
247 |
|
248 |
if($DEBUG) echo "load_cp(): ",$query,"<BR><HR>"; |
249 |
|
250 |
if (!($res=db_query($query))) { |
251 |
print_error_local('Query error: '.$query."\n<BR>".db_error()); |
252 |
} |
253 |
|
254 |
$row=db_fetchrow($res); |
255 |
db_freeresult($res); |
256 |
|
257 |
if ($row) { |
258 |
$row[0]=htmlspecialchars($row[0]); |
259 |
$link_name = " > <a href=\"$self?cat=\">$row[0]</a>".$link_name; |
260 |
} else { |
261 |
$link_name=''; |
262 |
} |
263 |
|
264 |
$cp_arr[$cat]=$link_name; |
265 |
|
266 |
return $link_name; |
267 |
} |
268 |
|
269 |
|
270 |
// ----------------------------------------------- |
271 |
// get_micro_time() |
272 |
// ----------------------------------------------- |
273 |
function get_micro_time() { |
274 |
if (function_exists('microtime')) { |
275 |
$result=microtime(); |
276 |
if (ereg('([0-9\.\,]+) +([0-9]+)',$result,$param)) { |
277 |
$result=$param[2]+$param[1]; |
278 |
} |
279 |
} else { |
280 |
$result=time(); |
281 |
} |
282 |
return $result; |
283 |
} |
284 |
|
285 |
// ----------------------------------------------- |
286 |
// suggest_soundex($word) |
287 |
// ----------------------------------------------- |
288 |
function suggest_soundex($word) { |
289 |
global $DEBUG; |
290 |
global $soundex_words; |
291 |
global $all_words; |
292 |
|
293 |
global $ps,$o,$m,$cat,$dt, $dp, $dx, $dm, $dy, $dd, $db, $de; |
294 |
global $ul_local,$ue_local,$t_local,$db_local,$de_local,$lang_local; |
295 |
|
296 |
if (preg_match('/\d/',$word)) return ''; |
297 |
|
298 |
$sdx = soundex($word); |
299 |
if($DEBUG) echo "suggest_soundex($word): sdx=$sdx<BR>\n"; |
300 |
|
301 |
if ($sdx == '0000') return ''; |
302 |
|
303 |
$query="SELECT word FROM soundex WHERE soundex='$sdx'"; |
304 |
|
305 |
if($DEBUG) echo "suggest_soundex($word): ",$query,"<BR><HR>\n"; |
306 |
|
307 |
if (!($res=db_query($query))) { |
308 |
print_error_local('Query error: '.$query."\n<BR>".db_error()); |
309 |
} |
310 |
|
311 |
if($DEBUG) echo "suggest_soundex($word): words found: "; |
312 |
while ($row=db_fetchrow($res)) { |
313 |
$word=$row[0]; |
314 |
|
315 |
if ($soundex_words[$word]) continue; |
316 |
|
317 |
$flag=0; |
318 |
for($i=0; $i<count($all_words); $i++) { |
319 |
if ($all_words[$i] == $word) { |
320 |
$flag=1; |
321 |
break; |
322 |
} |
323 |
} |
324 |
if ($flag) continue; |
325 |
|
326 |
$soundex_words[$word] = 1; |
327 |
|
328 |
if($DEBUG) echo "$word "; |
329 |
$word_local=urlencode($word); |
330 |
$result .= "<a href=\"$PHP_SELF?q=$word_local&m=$m". |
331 |
($ps==20?'':"&ps=$ps"). |
332 |
($t==''?'':"&t=$t_local"). |
333 |
($ul==''?'':"&ul=$ul_local"). |
334 |
($ue==''?'':"&ue=$ue_local"). |
335 |
(!$o?'':"&o=$o"). |
336 |
($dt=='back'?'':"&dt=$dt"). |
337 |
(!$dp?'':"&dp=$dp"). |
338 |
(!$dx?'':"&dx=$dx"). |
339 |
($dd=='01'?'':"&dd=$dd"). |
340 |
(!$dm?'':"&dm=$dm"). |
341 |
($dy=='1970'?'':"&dy=$dy"). |
342 |
($db=='01/01/1970'?'':"&db=$db_local"). |
343 |
($de=='31/12/2020'?'':"&de=$de_local"). |
344 |
($cat==''?'':"&cat=$cat"). |
345 |
($lang==''?'':"&lang=$lang_local"). |
346 |
"\">$word</a> "; |
347 |
} |
348 |
if($DEBUG) echo "<br>"; |
349 |
|
350 |
db_freeresult($res); |
351 |
|
352 |
return $result; |
353 |
|
354 |
} |
355 |
|
356 |
?> |