Joomla!是一套获得过多个奖项的内容管理系统(Content Management System, CMS)。Joomla!采用PHP+MySQL数据库开发

								/**				 * @version		$Id: message.php 10381 2008-06-01 03:35:53Z pasamio $				 * @package		Joomla				 * @copyright	Copyright (C) 2005 - 2008 Open Source Matters. All rights reserved.				 * @license		GNU/GPL, see LICENSE.php				 * Joomla! is free software. This version may have been modified pursuant				 * to the GNU General Public License, and as distributed it includes or				 * is derivative of works licensed under the GNU General Public License or				 * other free or open source software licenses.				 * See COPYRIGHT.php for copyright notices and details.				 */								// Check to ensure this file is included in Joomla!				defined('_JEXEC') or die( 'Restricted access' );								jimport('joomla.database.table');								class TableMessage extends JTable				{					/**					 * Primary Key					 *					 * @access	public					 * @var		int					 */					var $message_id	= null;									/**					 * Sender's userid					 *					 * @access	public					 * @var		int					 */					var $user_id_from	= null;									/**					 * Recipient's userid					 *					 * @access	public					 * @var		int					 */					var $user_id_to		= null;									/**					 * @access	public					 * @var		int					 */					var $folder_id			= null;									/**					 * Message creation timestamp					 *					 * @access	public					 * @var		datetime					 */					var $date_time		= null;									/**					 * Message state					 *					 * @access	public					 * @var		int					 */					var $state				= null;									/**					 * Priority level of the message					 *					 * @access	public					 * @var		int					 */					var $priority			= null;									/**					 * The message subject					 *					 * @access	public					 * @var		string					 */					var $subject			= null;									/**					 * The message body					 *					 * @access	public					 * @var		text					 */					var $message			= null;									/**					 * Constructor					 *					 * @access	protected					 * @param database A database connector object					 */					function __construct(& $db)					{						parent::__construct('#__messages', 'message_id', $db);					}									/**					* Validation and filtering					*/					function check() {						return true;					}									/**					 * Method to send a private message					 *					 * @access	public					 * @param	int		$fromId		Sender's userid					 * @param	int		$toId		Recipient's userid					 * @param	string	$subject	The message subject					 * @param	string	$message	The message body					 * @return	boolean	True on success					 * @since	1.5					 */					function send($fromId = null, $toId = null, $subject = null, $message = null, $mailfrom = null, $fromname = null)					{						global $mainframe;						$db =& JFactory::getDBO();										if (is_object($this))						{							$fromId		= $fromId	? $fromId	: $this->user_id_from;							$toId		= $toId		? $toId		: $this->user_id_to;							$subject	= $subject	? $subject	: $this->subject;							$message	= $message	? $message	: $this->message;						}										$query = 'SELECT cfg_name, cfg_value' .								' FROM #__messages_cfg' .								' WHERE user_id = '.(int) $toId;						$db->setQuery($query);										$config = $db->loadObjectList('cfg_name');						$locked = @ $config['lock']->cfg_value;						$domail = @ $config['mail_on_new']->cfg_value;										if (!$locked)						{							$this->user_id_from	= $fromId;							$this->user_id_to	= $toId;							$this->subject		= $subject;							$this->message		= $message;							$date =& JFactory::getDate();							$this->date_time	= $date->toMySQL();											if ($this->store())							{								if ($domail)								{									$query = 'SELECT name, email' .											' FROM #__users' .											' WHERE id = '.(int) $fromId;									$db->setQuery($query);									$fromObject = $db->loadObject();									$fromname	= $fromObject->name;									$mailfrom	= $fromObject->email;									$siteURL		= JURI::base();									$sitename 		= $mainframe->getCfg( 'sitename' );													$query = 'SELECT email' .											' FROM #__users' .											' WHERE id = '.(int) $toId;									$db->setQuery($query);									$recipient	= $db->loadResult();													$subject	= sprintf (JText::_('A new private message has arrived'), $sitename);									$msg		= sprintf (JText::_('Please login to read your message'), $siteURL);													JUtility::sendMail($mailfrom, $fromname, $recipient, $subject, $msg);								}								return true;							}						}						else						{							if (is_object($this)) {								$this->setError(JText::_('MESSAGE_FAILED'));							}						}						return false;					}				}