From 35889f8a58fb6fc9e1d9856acb237bc29d90de68 Mon Sep 17 00:00:00 2001 From: Max Kremmel Date: Wed, 1 Feb 2006 18:42:23 +0000 Subject: detikify liberty --- BitMailer.php | 16 ++++++++-------- 1 file changed, 8 insertions(+), 8 deletions(-) (limited to 'BitMailer.php') diff --git a/BitMailer.php b/BitMailer.php index a061a6a..e732322 100644 --- a/BitMailer.php +++ b/BitMailer.php @@ -1,12 +1,12 @@ * - * @version $Revision: 1.16 $ $Date: 2006/01/31 20:18:49 $ $Author: bitweaver $ + * @version $Revision: 1.17 $ $Date: 2006/02/01 18:42:23 $ $Author: squareing $ */ /** @@ -169,9 +169,9 @@ class BitMailer extends phpmailer { global $gBitDb; $ret = NULL; if( is_array( $pLookup ) ) { - $query = "SELECT mq.*, tc.title, tct.*, uu.`real_name`, uu.`login`, uu.`email` FROM `".BIT_DB_PREFIX."mail_queue` mq - INNER JOIN `".BIT_DB_PREFIX."tiki_content` tc ON( mq.`content_id`=tc.`content_id` ) - INNER JOIN `".BIT_DB_PREFIX."tiki_content_types` tct ON( tct.`content_type_guid`=tc.`content_type_guid` ) + $query = "SELECT mq.*, lc.title, tct.*, uu.`real_name`, uu.`login`, uu.`email` FROM `".BIT_DB_PREFIX."mail_queue` mq + INNER JOIN `".BIT_DB_PREFIX."liberty_content` lc ON( mq.`content_id`=lc.`content_id` ) + INNER JOIN `".BIT_DB_PREFIX."liberty_content_types` tct ON( tct.`content_type_guid`=lc.`content_type_guid` ) LEFT OUTER JOIN `".BIT_DB_PREFIX."users_users` uu ON( mq.`user_id`=uu.`user_id` ) WHERE mq.`".key( $pLookup )."`=? "; $ret = $gBitDb->getRow( $query, array( current( $pLookup ) ) ); @@ -187,10 +187,10 @@ class BitMailer extends phpmailer { if( is_array( $pMixed ) ) { $col = key( $pMixed ); $bindVars[] = current( $pMixed ); - $query = "SELECT ms.`nl_content_id` AS `hash_key`, ms.*, uu.*, tc.title + $query = "SELECT ms.`nl_content_id` AS `hash_key`, ms.*, uu.*, lc.title FROM `".BIT_DB_PREFIX."mail_subscriptions` ms LEFT OUTER JOIN `".BIT_DB_PREFIX."users_users` uu ON( ms.`user_id`=uu.`user_id` ) - LEFT OUTER JOIN `".BIT_DB_PREFIX."tiki_content` tc ON( ms.`nl_content_id`=tc.`content_id` ) + LEFT OUTER JOIN `".BIT_DB_PREFIX."liberty_content` lc ON( ms.`nl_content_id`=lc.`content_id` ) WHERE ms.`$col`=? "; $ret = $gBitDb->getAssoc( $query, $bindVars ); } -- cgit v1.3