diff options
| author | Max Kremmel <xing@synapse.plus.com> | 2006-02-01 18:42:23 +0000 |
|---|---|---|
| committer | Max Kremmel <xing@synapse.plus.com> | 2006-02-01 18:42:23 +0000 |
| commit | 35889f8a58fb6fc9e1d9856acb237bc29d90de68 (patch) | |
| tree | 0f6a43e8608e7f7305111b6cf62728690c17839b /BitNewsletterEdition.php | |
| parent | a2b80f6af640a971f3d59855aba09380350910a4 (diff) | |
| download | newsletters-35889f8a58fb6fc9e1d9856acb237bc29d90de68.tar.gz newsletters-35889f8a58fb6fc9e1d9856acb237bc29d90de68.tar.bz2 newsletters-35889f8a58fb6fc9e1d9856acb237bc29d90de68.zip | |
detikify liberty
Diffstat (limited to 'BitNewsletterEdition.php')
| -rw-r--r-- | BitNewsletterEdition.php | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/BitNewsletterEdition.php b/BitNewsletterEdition.php index 8ccaebc..32bd6b2 100644 --- a/BitNewsletterEdition.php +++ b/BitNewsletterEdition.php @@ -1,12 +1,12 @@ <?php /** - * $Header: /cvsroot/bitweaver/_bit_newsletters/BitNewsletterEdition.php,v 1.17 2006/01/31 20:18:49 bitweaver Exp $ + * $Header: /cvsroot/bitweaver/_bit_newsletters/BitNewsletterEdition.php,v 1.18 2006/02/01 18:42:23 squareing Exp $ * * Copyright (c) 2004 bitweaver.org * All Rights Reserved. See copyright.txt for details and a complete list of authors. * Licensed under the GNU LESSER GENERAL PUBLIC LICENSE. See license.txt for details * - * $Id: BitNewsletterEdition.php,v 1.17 2006/01/31 20:18:49 bitweaver Exp $ + * $Id: BitNewsletterEdition.php,v 1.18 2006/02/01 18:42:23 squareing Exp $ * * Class that handles editions of newsletters * @package newsletters @@ -15,7 +15,7 @@ * * @author spiderr <spider@steelsun.com> * - * @version $Revision: 1.17 $ $Date: 2006/01/31 20:18:49 $ $Author: bitweaver $ + * @version $Revision: 1.18 $ $Date: 2006/02/01 18:42:23 $ $Author: squareing $ */ /** @@ -87,9 +87,9 @@ class BitNewsletterEdition extends LibertyAttachable { $this->getServicesSql( 'content_load_function', $selectSql, $joinSql, $whereSql, $bindVars ); - $query = "SELECT ne.*, tc.* + $query = "SELECT ne.*, lc.* FROM `".BIT_DB_PREFIX."newsletters_editions` ne - INNER JOIN `".BIT_DB_PREFIX."tiki_content` tc ON( ne.`content_id`=tc.`content_id` ) + INNER JOIN `".BIT_DB_PREFIX."liberty_content` lc ON( ne.`content_id`=lc.`content_id` ) WHERE ne.`$lookupColumn`=? $whereSql"; if ( $result = $this->mDb->query($query,$bindVars) ) { $this->mInfo = $result->fetchRow(); @@ -147,15 +147,15 @@ class BitNewsletterEdition extends LibertyAttachable { if( $pListHash['find'] ) { $findesc = '%' . $pListHash['find'] . '%'; - $mid .= (empty( $mid ) ? 'WHERE' : 'AND').' (tc.`title` like ? or tc.`data` like ?)'; + $mid .= (empty( $mid ) ? 'WHERE' : 'AND').' (lc.`title` like ? or lc.`data` like ?)'; $bindVars[] = $findesc; $bindVars[] = $findesc; } - $query = "SELECT `edition_id` AS `hash_key`, ne.*, tc.*, tc2.`title` AS `newsletter_title` + $query = "SELECT `edition_id` AS `hash_key`, ne.*, lc.*, tc2.`title` AS `newsletter_title` FROM `".BIT_DB_PREFIX."newsletters_editions` ne - INNER JOIN `".BIT_DB_PREFIX."tiki_content` tc ON( tc.`content_id`=ne.`content_id` ) + INNER JOIN `".BIT_DB_PREFIX."liberty_content` lc ON( lc.`content_id`=ne.`content_id` ) INNER JOIN `".BIT_DB_PREFIX."newsletters` n ON( ne.`nl_content_id`=n.`content_id` ) - LEFT OUTER JOIN `".BIT_DB_PREFIX."tiki_content` tc2 ON( n.`content_id`=tc2.`content_id` ) + LEFT OUTER JOIN `".BIT_DB_PREFIX."liberty_content` tc2 ON( n.`content_id`=tc2.`content_id` ) $mid ORDER BY ".$this->mDb->convert_sortmode( $pListHash['sort_mode'] ); $query_cant = "select count(*) from `".BIT_DB_PREFIX."newsletters` n INNER JOIN `".BIT_DB_PREFIX."newsletters_editions` ne ON(n.`content_id`=ne.`nl_content_id`) $mid"; $ret = $gBitDb->getAssoc( $query, $bindVars, $pListHash['max_records'], $pListHash['offset'] ); |