DBAL compliancy patch for indexed_search
authorKarsten Dambekalns <karsten.dambekalns@typo3.org>
Thu, 1 Mar 2007 09:43:48 +0000 (09:43 +0000)
committerKarsten Dambekalns <karsten.dambekalns@typo3.org>
Thu, 1 Mar 2007 09:43:48 +0000 (09:43 +0000)
git-svn-id: https://svn.typo3.org/TYPO3v4/Core/branches/TYPO3_4-0@2165 709f56b5-9817-0410-a4d7-c38de5d9e867

ChangeLog
typo3/sysext/indexed_search/class.crawler.php
typo3/sysext/indexed_search/ext_tables.sql

index 9e49101..6b82e69 100755 (executable)
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,3 +1,7 @@
+2007-03-01  Karsten Dambekalns <karsten@typo3.org>
+
+       * typo3/sysext/indexed_search: DBAL compliancy patch
+
 2007-02-27  Oliver Hader  <oh@inpublica.de>
 
        * Fixed bug: #5052: Form action URL is not htmlspecialchared (patch by Michael Stucki)
index 971e623..15bee34 100755 (executable)
@@ -176,7 +176,7 @@ class tx_indexedsearch_crawler {
                                        $params = array(
                                                'indexConfigUid' => $cfgRec['uid'],             // General
                                                'procInstructions' => array('[Index Cfg UID#'.$cfgRec['uid'].']'),      // General
-                                               'url' => $cfgRec['alternative_source_pid'],     // Partly general... (for URL and file types and page tree (root))
+                                               'url' => intval($cfgRec['alternative_source_pid']),     // Partly general... (for URL and file types and page tree (root))
                                                'depth' => 0    // Specific for URL and file types and page tree
                                        );
 
@@ -851,8 +851,8 @@ class tx_indexedsearch_crawler {
                                                AND type=1
                                                AND table2index='.$GLOBALS['TYPO3_DB']->fullQuoteStr($table,'index_config').'
                                                AND (
-                                                               (alternative_source_pid='.$GLOBALS['TYPO3_DB']->fullQuoteStr('','index_config').' AND pid='.intval($currentRecord['pid']).')
-                                                               OR (alternative_source_pid='.$GLOBALS['TYPO3_DB']->fullQuoteStr($currentRecord['pid'],'index_config').')
+                                                               (alternative_source_pid=0 AND pid='.intval($currentRecord['pid']).')
+                                                               OR (alternative_source_pid='.intval($currentRecord['pid']).')
                                                        )
                                                AND records_indexonchange=1
                                                '.t3lib_BEfunc::deleteClause('index_config')
index abf0611..3b96b82 100755 (executable)
@@ -164,7 +164,7 @@ CREATE TABLE index_config (
     type varchar(30) DEFAULT '' NOT NULL,
     depth int(11) unsigned DEFAULT '0' NOT NULL,
     table2index tinytext NOT NULL,
-    alternative_source_pid blob NOT NULL,
+    alternative_source_pid int(11) unsigned DEFAULT '0' NOT NULL,
     get_params tinytext NOT NULL,
     fieldlist tinytext NOT NULL,
        externalUrl tinytext NOT NULL,