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; }