Kód: Vybrať všetko

--
-- Table structure for table `search_table`
--

CREATE TABLE IF NOT EXISTS `search_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vendor_id` tinyint(1) NOT NULL DEFAULT '1',
  `sid` varchar(32) COLLATE utf8_czech_ci NOT NULL,
  `name_orig` varchar(128) COLLATE utf8_czech_ci NOT NULL,
  `name` varchar(128) COLLATE utf8_czech_ci NOT NULL,
  `name_preg` varchar(128) COLLATE utf8_czech_ci NOT NULL,
  `help1` varchar(255) COLLATE utf8_czech_ci NOT NULL,
  `help2` varchar(255) COLLATE utf8_czech_ci NOT NULL,
  `type` tinyint(4) NOT NULL,
  `priority` smallint(6) NOT NULL,
  `active` tinyint(1) NOT NULL,
  `lang` varchar(3) COLLATE utf8_czech_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `vendor_id` (`vendor_id`,`type`,`active`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=2731231 ;

Kód: Vybrať všetko

INSERT INTO `search_table` (`id`, `vendor_id`, `sid`, `name_orig`, `name`, `name_preg`, `help1`, `help2`, `type`, `priority`, `active`, `lang`) VALUES
(2731209, 0, '4748389', 'Julian Assange: Neautorizovaná autobiografie', 'julian assange: neautorizovana autobiografie', 'julianassangeneautorizovanaautobiografie', '9788074620126', '978-80-7462-012-6', 1, 0, 1, ''),
(2731215, 0, '4748397', 'Když jsme zhubly my, zhubnete i vy', 'kdyz jsme zhubly my, zhubnete i vy', 'kdyzjsmezhublymyzhubneteivy', '9788072175253', '978-80-7217-525-3', 1, 0, 1, '');

Kód: Vybrať všetko

		$sresults[1] = mq_select_a("search_table", "sid", "sid", "(name LIKE '%{$keyword}%' OR help1 LIKE '{$keyword}' OR help2 LIKE '{$keyword}%') AND `type`=1 AND active=1 AND vendor_id={$domain->vendor}", "sid", "ORDER BY priority DESC");
		if(count($sresults[1]) == 0) {
			$skeyword = preg_replace("/[^a-z0-9]*/i","",$keyword);
			$sresults[1] = mq_select_a("search_table", "sid", "sid", "name_preg LIKE '%{$skeyword}%' AND `type`=1 AND active=1 AND vendor_id={$domain->vendor}", "sid", "ORDER BY priority DESC");
		}