public function onAfterThankyou($target, $actor, $message) {
$username = KunenaFactory::getUser($actor)->username;
$msg = AwdwallHelperUser::formatUrlInMsg($msg);
$wall =& JTable::getInstance('Wall', 'Table');
$wall->user_id = $target;
$wall->group_id = NULL;
$wall->type = 'text';
$wall->commenter_id = JFactory::getUser()->id;
$wall->user_name = '';
$wall->avatar = '';
$wall->message = JText::sprintf( 'PLG_KUNENA_JOMWALL_ACTIVITY_THANKYOU_TITLE', $username );
$wall->reply = 0;
$wall->is_read = 0;
$wall->is_pm = 0;
$wall->is_reply = 0;
$wall->posted_id = NULL;
$wall->wall_date = time();
if (!$wall->store()){
}
}
public function getCommentBlock($tpl = null)
{
$cid = JRequest::getInt('cid', 0);
$wid = JRequest::getInt('wid', 0);
//$msg = JRequest::getString('awd_comment_' . $cid);
//$msg = JRequest::getString('awd_comment_' . $cid);
$msg= JRequest::getString('awd_comment_' . $cid);
$msg = AwdwallHelperUser::formatUrlInMsg($msg);
$this->assignRef('wid', $wid);
$this->assignRef('msg', nl2br($msg));
$this->assignRef('postedTime', time());
$app = JFactory::getApplication('site');
$config = & $app->getParams('com_awdwall');
$display_profile_link = $config->get('display_profile_link', 1);
$this->assignRef('display_profile_link', $display_profile_link);
parent::display($tpl);
}
function addComment()
{
require_once (JPATH_COMPONENT . DS . 'models' . DS . 'wall.php');
$mainframe =& JFactory::getApplication();
$cid = JRequest::getInt('cid', 0);
//msg = JRequest::getString('awd_comment_' . $cid);
$msg= JRequest::getString('awd_comment_' . $cid);
$receiverId = JRequest::getInt('c_receiver_id_' . $cid, 0);
$wallId = JRequest::getInt('c_wall_id_' . $cid, 0);
$isReply = JRequest::getInt('c_isreply_' . $cid, 0);
$user = &JFactory::getUser();
$db = &JFactory::getDBO();
// deleting the notifcation and counter in message
if($isReply==1)
{
$query = "DELETE FROM #__awd_wall_notification WHERE nwallid=".$cid." and ntype='pm' ";
$db->setQuery($query);
$db->query();
}
$itemId = AwdwallHelperUser::getComItemId();
if((int)$user->id){
$wall =& JTable::getInstance('Wall', 'Table');
$msg = AwdwallHelperUser::formatUrlInMsg($msg);
$wall->user_id = $receiverId;
$wall->type = 'text';
$wall->commenter_id = $user->id;
$wall->user_name = '';
$wall->avatar = '';
$wall->message = nl2br($msg);
$wall->reply = $wallId;
$wall->is_read = 0;
$wall->is_pm = 0;
$wall->is_reply = $isReply;
$wall->posted_id = NULL;
$wall->wall_date = time();
// store wall to database
if (!$wall->store()){
$this->setRedirect(JRoute::_('index.php?option=com_awdwall&&view=awdwall&layout=main&Itemid='.$itemId , false ), JText::_('Post Failed'));
}
//insert into awd_wall_notification table.
$query = "SELECT id FROM #__awd_wall_images WHERE wall_id = " . $cid;
$db->setQuery($query);
$photoid = $db->loadResult();
if($photoid==NULL || $photoid=='')
$photoid =0;
$ndate=date("Y-m-d H:i:s");
$query = 'INSERT INTO #__awd_wall_notification(ndate, nuser, ncreator, ntype, nwallid, ngroupid, nphotoid, nalbumid, nread) VALUES( "'.$ndate.'" , "'.$receiverId.'", "' . $user->id . '", "text", "'.$wall->id.'", "' . $groupId . '"," '.$photoid.'", "","0")';
$db->setQuery($query);
$db->query();
// set wall id to view
JRequest::setVar('wid', $wall->id);
$db =& JFactory::getDBO();
$query='select * from #__awd_wall where reply='.$wallId.' and commenter_id!='.$user->id.' and commenter_id!='.$receiverId.' and wall_date IS NOT NULL';
$db->setQuery($query);
$commentorlist = $db->loadObjectList();
// send email if is enabled
//$config = &JComponentHelper::getParams('com_awdwall');
$app = JFactory::getApplication('site');
$config = & $app->getParams('com_awdwall');
$displayName = $config->get('display_name', 1);
$query = 'SELECT group_id FROM #__awd_wall WHERE id = ' . (int)$wallId;
$db->setQuery($query);
$group_id = $db->loadResult();
if($config->get('email_auto', 0) && ($receiverId != $user->id)){
if($group_id)
{
$walllink=JRoute::_(JURI::base().'index.php?option=com_awdwall&task=viewgroup&groupid='.$group_id.'&Itemid='.$itemId.'#here'.$wallId,false) ;
}
else
{
$walllink=JRoute::_(JURI::base().'index.php?option=com_awdwall&view=awdwall&layout=mywall&wuid='.$receiverId.'&Itemid='.$itemId.'#here'.$wallId,false) ;
}
$receiver = &JFactory::getUser($receiverId);
$rName = AwdwallHelperUser::getDisplayName($receiverId);
$sName = AwdwallHelperUser::getDisplayName($user->id);
if($group_id)
{
$query = 'SELECT creator FROM #__awd_groups WHERE id = ' . (int)$group_id;
$db->setQuery($query);
$creator = $db->loadResult();
$query = 'SELECT title FROM #__awd_groups WHERE id = ' . (int)$group_id;
$db->setQuery($query);
$grpname = $db->loadResult();
$grplink=JRoute::_(JURI::base().'index.php?option=com_awdwall&task=viewgroup&groupid='.$group_id.'&Itemid='.$itemId,false) ;
$emailbody=JText::sprintf('COM_COMAWDWALL_EMAIL_NEW_GROUP_POST_COMMENT_BODY',$grplink,$grpname,$sName);
$emailsubject=$mainframe->getCfg('fromname').' '.JText::sprintf('COM_COMAWDWALL_EMAIL_SUBJECT_NEW_GROUP_COMMENT', $sName);
}
else
{
$emailbody=JText::sprintf('COM_COMAWDWALL_EMAIL_NEW_POST_COMMENT_BODY',$sName);
$emailsubject=$mainframe->getCfg('fromname').' '.JText::sprintf('COM_COMAWDWALL_EMAIL_SUBJECT_NEW_COMMENT', $sName);
}
$sitename=$mainframe->getCfg('fromname');
$siteaddress=JURI::base();
$useravatarimage=AwdwallHelperUser::getBigAvatar51($user->id);
$emailgreeting=JText::sprintf('COM_COMAWDWALL_EMAIL_GREETING', $rName);
$emailtext1=JText::_('COM_COMAWDWALL_EMAIL_NEW_POST_VIEW_CONVERSATION');
$emailtext2=JText::_('COM_COMAWDWALL_EMAIL_NEW_POST_SEE_POST');
$emailfooter=JText::sprintf('COM_COMAWDWALL_EMAIL_FOOTER',$siteaddress,$sitename);
$reciverurl=JURI::base().'index.php?option=com_awdwall&view=awdwall&layout=mywall&wuid='.$user->id.'&Itemid='.$itemId;
$emailcontent='<table cellspacing="0" cellpadding="0" style="border-collapse:collapse;width:620px"><tbody><tr><td style="font-size:16px;font-family:lucida grande,tahoma,verdana,arial,sans-serif;background:#313131;color:#ffffff;font-weight:bold;vertical-align:baseline;letter-spacing:-0.03em;text-align:left;padding:10px 38px 4px"><a target="_blank" href="'.$siteaddress.'" style="text-decoration:none" title="'.$siteaddress.'"><span style="background:#313131;color:#ffffff;font-weight:bold;font-family:lucida grande,tahoma,verdana,arial,sans-serif;vertical-align:middle;font-size:16px;letter-spacing:-0.03em;text-align:left;vertical-align:baseline"><span class="il">'.$sitename.'</span></span></a></td></tr></tbody></table><table cellspacing="0" cellpadding="0" style="border-collapse:collapse;width:620px"><tbody><tr><td style="border-right:1px solid #ccc;color:#333333;font-size:11px;border-bottom:1px solid #ccc;font-family:LucidaGrande,tahoma,verdana,arial,sans-serif;border-top:1px solid #ccc;padding:10px 25px;border-left:1px solid #ccc; background-color:#f7f7f7"><table width="100%" cellspacing="0" cellpadding="0" style="border-collapse:collapse"><tbody><tr><td style="font-size:11px;font-family:LucidaGrande,tahoma,verdana,arial,sans-serif;padding:10px 25px;color:#333333;width:620px"><table width="100%" cellspacing="0" cellpadding="0" style="border-collapse:collapse"><tbody><tr><td style="font-size:11px;font-family:LucidaGrande,tahoma,verdana,arial,sans-serif;padding-bottom:10px"><table cellspacing="0" cellpadding="0" style="border-collapse:collapse"><tbody><tr><td colspan="2" valign="top" style="height:30px;"><span style="font-size:13px;">'.$emailgreeting.'</span></td></tr><tr><td valign="top" style="width:100%;"><span style="font-size:13px">'.$emailbody.'</span></td><td valign="top" style="padding-right:10px;font-size:0px"><a target="_blank" style="color:#3b5998;text-decoration:none" href="'.$reciverurl.'" title="'.$rName.'"><img style="border:0" src="'.$useravatarimage.'" /></a></td></tr></tbody></table></td></tr><tr><td style="font-size:11px;font-family:LucidaGrande,tahoma,verdana,arial,sans-serif"><table cellspacing="0" cellpadding="0" border="0" style="border-collapse:collapse;width:100%"><tbody><tr><td style="font-size:11px;font-family:LucidaGrande,tahoma,verdana,arial,sans-serif;padding:0px;border-left:none;border-right:none;"><table cellspacing="0" cellpadding="0" style="border-collapse:collapse"><tbody><tr><td style="font-size:11px;font-family:LucidaGrande,tahoma,verdana,arial,sans-serif;padding-right:10px"><table cellspacing="0" cellpadding="0" style="border-collapse:collapse"><tbody><tr><td ><table cellspacing="0" cellpadding="0" style="border-collapse:collapse"><tbody><tr><td style="font-size:13px;font-family:LucidaGrande,tahoma,verdana,arial,sans-serif;padding:2px 6px 4px 0px;">'.$emailtext1.'</td></tr></tbody></table></td></tr></tbody></table></td><td style="font-size:11px;font-family:LucidaGrande,tahoma,verdana,arial,sans-serif"><table cellspacing="0" cellpadding="0" style="border-collapse:collapse"><tbody><tr><td style="border-width:1px;border-style:solid;border-color:#E3C823;background-color:#FFF9D9"><table cellspacing="0" cellpadding="0" style="border-collapse:collapse"><tbody><tr><td style="font-size:11px;font-family:LucidaGrande,tahoma,verdana,arial,sans-serif;padding:2px 6px 4px;border-top:1px solid #fff"><a target="_blank" style="color:#6176b7;text-decoration:none" href="'.$walllink.'"><span style="font-weight:bold;white-space:nowrap;color:#3b5b98;font-size:11px">'.$emailtext2.'</span></a></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table></td></tr><tr><td> </td></tr><tr><td style="font-size:13px;font-family:LucidaGrande,tahoma,verdana,arial,sans-serif;padding:0px;border-left:none;border-right:none;">'.$emailfooter.'</td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table>';
$body=$emailcontent;
$mailer = & JFactory::getMailer();
$mailer->setSender(array($mainframe->getCfg('mailfrom'), $mainframe->getCfg('fromname')));
$mailer->setSubject($emailsubject);
$mailer->setBody($body);
$mailer->IsHTML(1);
$mailer->addRecipient($receiver->email);
$rs = $mailer->Send();
// sending email to the
// send copy to who comments on
// $sName = AwdwallHelperUser::getDisplayName($receiverId);
// $rName = AwdwallHelperUser::getDisplayName($user->id);
// $body = JText::sprintf('Email Body Comment Poster', $rName,$walllink, $sName, JURI::base(), JURI::base());
// $mailer = & JFactory::getMailer();
// $mailer->setSender(array($mainframe->getCfg('mailfrom'), $mainframe->getCfg('fromname')));
// $mailer->setSubject(JText::_($mainframe->getCfg('fromname').' Notification system'));
// $mailer->setBody($body);
// $mailer->IsHTML(1);
// $mailer->addRecipient($user->email);
// $rs = $mailer->Send();
}
if($config->get('email_auto', 0) )
{
if($commentorlist)
{
foreach($commentorlist as $c)
{
if($c->commenter_id!=$user->id)
{
$ccc = &JFactory::getUser($c->commenter_id);
$rName = AwdwallHelperUser::getDisplayName($c->commenter_id);
$sName = AwdwallHelperUser::getDisplayName($user->id);
$wName = AwdwallHelperUser::getDisplayName($receiverId);
if($group_id)
{
$walllink=JRoute::_(JURI::base().'index.php?option=com_awdwall&task=viewgroup&groupid='.$group_id.'&Itemid='.$itemId.'#here'.$wallId,false) ;
}
else
{
$walllink=JRoute::_(JURI::base().'index.php?option=com_awdwall&view=awdwall&layout=mywall&wuid='.$receiverId.'&Itemid='.$itemId.'#here'.$wallId,false) ;
}
if($group_id)
{
$query = 'SELECT creator FROM #__awd_groups WHERE id = ' . (int)$group_id;
$db->setQuery($query);
$creator = $db->loadResult();
$query = 'SELECT title FROM #__awd_groups WHERE id = ' . (int)$group_id;
$db->setQuery($query);
$grpname = $db->loadResult();
$grplink=JRoute::_(JURI::base().'index.php?option=com_awdwall&task=viewgroup&groupid='.$group_id.'&Itemid='.$itemId,false) ;
$emailbody=JText::sprintf('COM_COMAWDWALL_EMAIL_NEW_GROUP_POST_COMMENT_BODY',$grplink,$grpname,$sName);
$emailsubject=$mainframe->getCfg('fromname').' '.JText::sprintf('COM_COMAWDWALL_EMAIL_SUBJECT_NEW_GROUP_COMMENT', $sName);
}
else
{
$emailbody=JText::sprintf('COM_COMAWDWALL_EMAIL_NEW_POST_COMMENT_BODY',$sName);
$emailsubject=$mainframe->getCfg('fromname').' '.JText::sprintf('COM_COMAWDWALL_EMAIL_SUBJECT_NEW_COMMENT', $sName);
}
$sitename=$mainframe->getCfg('fromname');
$siteaddress=JURI::base();
$useravatarimage=AwdwallHelperUser::getBigAvatar51($user->id);
$emailgreeting=JText::sprintf('COM_COMAWDWALL_EMAIL_GREETING', $rName);
$emailtext1=JText::_('COM_COMAWDWALL_EMAIL_NEW_POST_VIEW_CONVERSATION');
$emailtext2=JText::_('COM_COMAWDWALL_EMAIL_NEW_POST_SEE_POST');
$emailfooter=JText::sprintf('COM_COMAWDWALL_EMAIL_FOOTER',$siteaddress,$sitename);
$reciverurl=JURI::base().'index.php?option=com_awdwall&view=awdwall&layout=mywall&wuid='.$user->id.'&Itemid='.$itemId;
$emailcontent='<table cellspacing="0" cellpadding="0" style="border-collapse:collapse;width:620px"><tbody><tr><td style="font-size:16px;font-family:lucida grande,tahoma,verdana,arial,sans-serif;background:#313131;color:#ffffff;font-weight:bold;vertical-align:baseline;letter-spacing:-0.03em;text-align:left;padding:10px 38px 4px"><a target="_blank" href="'.$siteaddress.'" style="text-decoration:none" title="'.$siteaddress.'"><span style="background:#313131;color:#ffffff;font-weight:bold;font-family:lucida grande,tahoma,verdana,arial,sans-serif;vertical-align:middle;font-size:16px;letter-spacing:-0.03em;text-align:left;vertical-align:baseline"><span class="il">'.$sitename.'</span></span></a></td></tr></tbody></table><table cellspacing="0" cellpadding="0" style="border-collapse:collapse;width:620px"><tbody><tr><td style="border-right:1px solid #ccc;color:#333333;font-size:11px;border-bottom:1px solid #ccc;font-family:LucidaGrande,tahoma,verdana,arial,sans-serif;border-top:1px solid #ccc;padding:10px 25px;border-left:1px solid #ccc; background-color:#f7f7f7"><table width="100%" cellspacing="0" cellpadding="0" style="border-collapse:collapse"><tbody><tr><td style="font-size:11px;font-family:LucidaGrande,tahoma,verdana,arial,sans-serif;padding:10px 25px;color:#333333;width:620px"><table width="100%" cellspacing="0" cellpadding="0" style="border-collapse:collapse"><tbody><tr><td style="font-size:11px;font-family:LucidaGrande,tahoma,verdana,arial,sans-serif;padding-bottom:10px"><table cellspacing="0" cellpadding="0" style="border-collapse:collapse"><tbody><tr><td colspan="2" valign="top" style="height:30px;"><span style="font-size:13px;">'.$emailgreeting.'</span></td></tr><tr><td valign="top" style="width:100%;"><span style="font-size:13px">'.$emailbody.'</span></td><td valign="top" style="padding-right:10px;font-size:0px"><a target="_blank" style="color:#3b5998;text-decoration:none" href="'.$reciverurl.'" title="'.$rName.'"><img style="border:0" src="'.$useravatarimage.'" /></a></td></tr></tbody></table></td></tr><tr><td style="font-size:11px;font-family:LucidaGrande,tahoma,verdana,arial,sans-serif"><table cellspacing="0" cellpadding="0" border="0" style="border-collapse:collapse;width:100%"><tbody><tr><td style="font-size:11px;font-family:LucidaGrande,tahoma,verdana,arial,sans-serif;padding:0px;border-left:none;border-right:none;"><table cellspacing="0" cellpadding="0" style="border-collapse:collapse"><tbody><tr><td style="font-size:11px;font-family:LucidaGrande,tahoma,verdana,arial,sans-serif;padding-right:10px"><table cellspacing="0" cellpadding="0" style="border-collapse:collapse"><tbody><tr><td ><table cellspacing="0" cellpadding="0" style="border-collapse:collapse"><tbody><tr><td style="font-size:13px;font-family:LucidaGrande,tahoma,verdana,arial,sans-serif;padding:2px 6px 4px 0px;">'.$emailtext1.'</td></tr></tbody></table></td></tr></tbody></table></td><td style="font-size:11px;font-family:LucidaGrande,tahoma,verdana,arial,sans-serif"><table cellspacing="0" cellpadding="0" style="border-collapse:collapse"><tbody><tr><td style="border-width:1px;border-style:solid;border-color:#E3C823;background-color:#FFF9D9"><table cellspacing="0" cellpadding="0" style="border-collapse:collapse"><tbody><tr><td style="font-size:11px;font-family:LucidaGrande,tahoma,verdana,arial,sans-serif;padding:2px 6px 4px;border-top:1px solid #fff"><a target="_blank" style="color:#6176b7;text-decoration:none" href="'.$walllink.'"><span style="font-weight:bold;white-space:nowrap;color:#3b5b98;font-size:11px">'.$emailtext2.'</span></a></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table></td></tr><tr><td> </td></tr><tr><td style="font-size:13px;font-family:LucidaGrande,tahoma,verdana,arial,sans-serif;padding:0px;border-left:none;border-right:none;">'.$emailfooter.'</td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table>';
$body = $emailcontent;
$mailer = & JFactory::getMailer();
$mailer->setSender(array($mainframe->getCfg('mailfrom'), $mainframe->getCfg('fromname')));
$mailer->setSubject($emailsubject);
$mailer->setBody($body);
$mailer->IsHTML(1);
$mailer->addRecipient($ccc->email);
$rs = $mailer->Send();
}
}
}
}
// prepend html to main wall
// AUP POINTS
if($isReply!=1)
{
$query='select type from #__awd_wall where id='.$cid.' and wall_date IS NOT NULL';
$db->setQuery($query);
$type = $db->loadResult();
$query='select commenter_id from #__awd_wall where id='.$cid.' and wall_date IS NOT NULL';
$db->setQuery($query);
$commenter_id = $db->loadResult();
if($commenter_id!=$user->id)
{
$api_AUP = JPATH_SITE.DS.'components'.DS.'com_alphauserpoints'.DS.'helper.php';
if ( file_exists($api_AUP)){
require_once ($api_AUP);
$keyreference = AlphaUserPointsHelper::buildKeyreference('plgaup_points4jomwallupdate', $cid );
if($type=='image')
{
AlphaUserPointsHelper::newpoints('plgaup_points4jomwallphotocomment','', $keyreference);
}
else
{
AlphaUserPointsHelper::newpoints('plgaup_points4jomwallwallcomment','', $keyreference);
}
}
}
}
$view = &$this->getView('awdwall', 'html');
$view->setLayout('comment_block');
$view->getCommentBlock();
}else{
$this->setRedirect(JRoute::_('index.php?option=com_awdwall&&view=awdwall&layout=main&Itemid='.$itemId, false), JText::_('Need to login'));
}
exit;
}
