1 |
1 |
-- phpMyAdmin SQL Dump
|
2 |
2 |
-- Date of creation: 2012-11-17 12:37am
|
3 |
3 |
-- Server Version: 5.1.41
|
4 |
|
--
|
|
4 |
-- Revision $Revision$
|
|
5 |
-- Link $HeadURL$
|
|
6 |
-- Date of modified $Date$
|
5 |
7 |
-- initial data for table `{TABLE_PREFIX}search`
|
6 |
8 |
--
|
7 |
|
INSERT INTO `{TABLE_PREFIX}search` VALUES(1, 'header', '<h1>[TEXT_SEARCH]</h1>\r\n<form name="searchpage" action="[WB_URL]/search/index.php" method="get">\r\n<table cellpadding="3" cellspacing="0" border="0" style="width:100%; max-width:500px">\r\n<tr>\r\n<td>\r\n<input type="hidden" name="search_path" value="[SEARCH_PATH]" />\r\n<input type="hidden" name="referrer" value="[REFERRER_ID]" />\r\n<input type="text" name="string" value="[SEARCH_STRING]" style="width: 100%;" />\r\n</td>\r\n<td width="100">\r\n<input type="submit" value="[TEXT_SEARCH]" style="width: 100%;" />\r\n</td>\r\n</tr>\r\n<tr>\r\n<td colspan="2">\r\n<input type="radio" name="match" id="match_all" value="all"[ALL_CHECKED] />\r\n<label for="match_all">[TEXT_ALL_WORDS]</label>\r\n<input type="radio" name="match" id="match_any" value="any"[ANY_CHECKED] />\r\n<label for="match_any">[TEXT_ANY_WORDS]</label>\r\n<input type="radio" name="match" id="match_exact" value="exact"[EXACT_CHECKED] />\r\n<label for="match_exact">[TEXT_EXACT_MATCH]</label>\r\n</td>\r\n</tr>\r\n</table>\r\n</form>\r\n<hr />', '');
|
8 |
|
INSERT INTO `{TABLE_PREFIX}search` VALUES(2, 'footer', '', '');
|
9 |
|
INSERT INTO `{TABLE_PREFIX}search` VALUES(3, 'results_header', '<p>[TEXT_RESULTS_FOR] <strong>[SEARCH_STRING]</strong>:</p>\r\n<div class="searchresults">', '');
|
10 |
|
INSERT INTO `{TABLE_PREFIX}search` VALUES(4, 'results_loop', '<h3 style="margin:10px 0 3px 0;"><a href="[LINK]">[TITLE]</a></h3>\r\n<div style="font-size:0.8em;">[TEXT_LAST_UPDATED_BY] [DISPLAY_NAME] [TEXT_ON] [DATE]</div>\r\n<p style="padding: 0 0 5px 0; margin: 2px 0 10px 0; border-bottom: 1px solid #777;">[DESCRIPTION].. [EXCERPT]</p>', '');
|
11 |
|
INSERT INTO `{TABLE_PREFIX}search` VALUES(5, 'results_footer', '</div>', '');
|
12 |
|
INSERT INTO `{TABLE_PREFIX}search` VALUES(6, 'no_results', '<p>[TEXT_NO_RESULTS]</p>', '');
|
13 |
|
INSERT INTO `{TABLE_PREFIX}search` VALUES(7, 'module_order', 'faqbaker,manual,wysiwyg', '');
|
14 |
|
INSERT INTO `{TABLE_PREFIX}search` VALUES(8, 'max_excerpt', '5', '');
|
15 |
|
INSERT INTO `{TABLE_PREFIX}search` VALUES(9, 'time_limit', '0', '');
|
16 |
|
INSERT INTO `{TABLE_PREFIX}search` VALUES(10, 'cfg_enable_old_search', 'true', '');
|
17 |
|
INSERT INTO `{TABLE_PREFIX}search` VALUES(11, 'cfg_search_keywords', 'true', '');
|
18 |
|
INSERT INTO `{TABLE_PREFIX}search` VALUES(12, 'cfg_search_description', 'true', '');
|
19 |
|
INSERT INTO `{TABLE_PREFIX}search` VALUES(13, 'cfg_show_description', 'true', '');
|
20 |
|
INSERT INTO `{TABLE_PREFIX}search` VALUES(14, 'cfg_enable_flush', 'true', '');
|
21 |
|
INSERT INTO `{TABLE_PREFIX}search` VALUES(15, 'template', '', '');
|
|
9 |
INSERT INTO `{TABLE_PREFIX}search` SET
|
|
10 |
`name`='header',
|
|
11 |
`value`='<h1>[TEXT_SEARCH]</h1>\r\n<form name="searchpage" action="[WB_URL]/search/index.php" method="get">\r\n<table cellpadding="3" cellspacing="0" border="0" style="width:100%; max-width:500px">\r\n<tr>\r\n<td>\r\n<input type="hidden" name="search_path" value="[SEARCH_PATH]" />\r\n<input type="hidden" name="referrer" value="[REFERRER_ID]" />\r\n<input type="text" name="string" value="[SEARCH_STRING]" style="width: 100%;" />\r\n</td>\r\n<td width="100">\r\n<input type="submit" value="[TEXT_SEARCH]" style="width: 100%;" />\r\n</td>\r\n</tr>\r\n<tr>\r\n<td colspan="2">\r\n<input type="radio" name="match" id="match_all" value="all"[ALL_CHECKED] />\r\n<label for="match_all">[TEXT_ALL_WORDS]</label>\r\n<input type="radio" name="match" id="match_any" value="any"[ANY_CHECKED] />\r\n<label for="match_any">[TEXT_ANY_WORDS]</label>\r\n<input type="radio" name="match" id="match_exact" value="exact"[EXACT_CHECKED] />\r\n<label for="match_exact">[TEXT_EXACT_MATCH]</label>\r\n</td>\r\n</tr>\r\n</table>\r\n</form>\r\n<hr />',
|
|
12 |
`extra`='';
|
|
13 |
INSERT INTO `{TABLE_PREFIX}search` SET
|
|
14 |
`name`='footer',
|
|
15 |
`value`='',
|
|
16 |
`extra`='';
|
|
17 |
INSERT INTO `{TABLE_PREFIX}search` SET
|
|
18 |
`name`='results_header',
|
|
19 |
`value`='<p>[TEXT_RESULTS_FOR] <strong>[SEARCH_STRING]</strong>:</p>\r\n<div class="searchresults">',
|
|
20 |
`extra`='';
|
|
21 |
INSERT INTO `{TABLE_PREFIX}search` SET
|
|
22 |
`name`='results_loop',
|
|
23 |
`value`='<h3 style="margin:10px 0 3px 0;"><a href="[LINK]">[TITLE]</a></h3>\r\n<div style="font-size:0.8em;">[TEXT_LAST_UPDATED_BY] [DISPLAY_NAME] [TEXT_ON] [DATE]</div>\r\n<p style="padding: 0 0 5px 0; margin: 2px 0 10px 0; border-bottom: 1px solid #777;">[DESCRIPTION].. [EXCERPT]</p>',
|
|
24 |
`extra`='';
|
|
25 |
INSERT INTO `{TABLE_PREFIX}search` SET
|
|
26 |
`name`='results_footer',
|
|
27 |
`value`='</div>',
|
|
28 |
`extra`='';
|
|
29 |
INSERT INTO `{TABLE_PREFIX}search` SET
|
|
30 |
`name`='no_results',
|
|
31 |
`value`='<p>[TEXT_NO_RESULTS]</p>',
|
|
32 |
`extra`='';
|
|
33 |
INSERT INTO `{TABLE_PREFIX}search` SET
|
|
34 |
`name`='module_order',
|
|
35 |
`value`='faqbaker,manual,wysiwyg',
|
|
36 |
`extra`='';
|
|
37 |
INSERT INTO `{TABLE_PREFIX}search` SET
|
|
38 |
`name`='max_excerpt',
|
|
39 |
`value`='5',
|
|
40 |
`extra`='';
|
|
41 |
INSERT INTO `{TABLE_PREFIX}search` SET
|
|
42 |
`name`='time_limit',
|
|
43 |
`value`='0',
|
|
44 |
`extra`='';
|
|
45 |
INSERT INTO `{TABLE_PREFIX}search` SET
|
|
46 |
`name`='cfg_enable_old_search',
|
|
47 |
`value`='true',
|
|
48 |
`extra`='';
|
|
49 |
INSERT INTO `{TABLE_PREFIX}search` SET
|
|
50 |
`name`='cfg_search_keywords',
|
|
51 |
`value`='true',
|
|
52 |
`extra`='';
|
|
53 |
INSERT INTO `{TABLE_PREFIX}search` SET
|
|
54 |
`name`='cfg_search_description',
|
|
55 |
`value`='true',
|
|
56 |
`extra`='';
|
|
57 |
INSERT INTO `{TABLE_PREFIX}search` SET
|
|
58 |
`name`='cfg_show_description',
|
|
59 |
`value`='true',
|
|
60 |
`extra`='';
|
|
61 |
INSERT INTO `{TABLE_PREFIX}search` SET
|
|
62 |
`name`='cfg_enable_flush',
|
|
63 |
`value`='true',
|
|
64 |
`extra`='';
|
|
65 |
INSERT INTO `{TABLE_PREFIX}search` SET
|
|
66 |
`name`='template',
|
|
67 |
`value`='',
|
|
68 |
`extra`='';
|
22 |
69 |
-- End of file
|
23 |
70 |
|
! /install/sql/wb_search_data.sql recoding initial data for table `search` without primary index value