Author: sevein
Date: Sat Apr 28 21:50:14 2012
New Revision: 11541
Log:
Use global table names
Modified:
branches/2.0/apps/qubit/modules/search/actions/autocompleteAction.class.php
Modified:
branches/2.0/apps/qubit/modules/search/actions/autocompleteAction.class.php
==============================================================================
--- branches/2.0/apps/qubit/modules/search/actions/autocompleteAction.class.php
Sat Apr 28 21:39:19 2012 (r11540)
+++ branches/2.0/apps/qubit/modules/search/actions/autocompleteAction.class.php
Sat Apr 28 21:50:14 2012 (r11541)
@@ -64,13 +64,13 @@
{
$sql = '
SELECT
- term.id,
- term_i18n.name
+ t.id,
+ ti18n.name
FROM
- term
- LEFT JOIN term_i18n ON (term.id = term_i18n.id AND term_i18n.culture =
?)
+ '.QubitTerm::TABLE_NAME.' AS t
+ LEFT JOIN '.QubitTermI18n::TABLE_NAME.' AS ti18n ON (t.id = ti18n.id
AND ti18n.culture = ?)
WHERE
- term.taxonomy_id = ?';
+ t.taxonomy_id = ?';
$this->levelsOfDescription = array();
foreach (QubitPdo::fetchAll($sql, array('en',
QubitTaxonomy::LEVEL_OF_DESCRIPTION_ID)) as $item)
--
You received this message because you are subscribed to the Google Groups
"Qubit Toolkit Commits" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/qubit-commits?hl=en.
