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

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

index d77e3b3..af0404a 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-28  Ingmar Schlecht  <ingmar@typo3.org>
 
        * New login image for t3skin by Ture Andersen
index fa80a83..40a26b7 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
                                        );
 
@@ -891,8 +891,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 76ef0cd..848daea 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,