public static function format_long_text($text) { $ret = htmlspecialchars($text); $ret = str_replace("\n", '<br>', $ret); $ret = Utils_BBCodeCommon::parse($ret); return $ret; }
<?php /** * Simple RSS Feed applet * @author jtylek@telaxus.com * @copyright 2008 Telaxus LLC * @license MIT * @version 1.0 * @package epesi-applets * @subpackage rssfeed */ if (!isset($_POST['feed']) || !isset($_POST['number']) || !isset($_POST['cid'])) { die('Invalid request'); } define('CID', $_POST['cid']); define('READ_ONLY_SESSION', 1); require_once '../../../include.php'; ModuleManager::load_modules(); require_once "rsslib.php"; function handle_rss_error($type, $message, $errfile, $errline, $errcontext) { die(__('Error getting RSS: %s', array($message))); } set_error_handler('handle_rss_error'); $feed = $_POST['feed']; $num = $_POST['number']; echo Utils_BBCodeCommon::parse(RSS_Display($feed, $num)); exit;
public function history($uid = null) { $th = $this->init_module(Base_Theme::module_name()); $th->assign('header', __('Shoutbox History')); $qf = $this->init_module(Libs_QuickForm::module_name()); if (ModuleManager::is_installed('CRM_Contacts') >= 0) { $emps = DB::GetAssoc('SELECT l.id,' . DB::ifelse('cd.f_last_name!=\'\'', DB::concat('cd.f_last_name', DB::qstr(' '), 'cd.f_first_name'), 'l.login') . ' as name FROM user_login l LEFT JOIN contact_data_1 cd ON (cd.f_login=l.id AND cd.active=1) WHERE l.active=1 ORDER BY name'); } else { $emps = DB::GetAssoc('SELECT id,login FROM user_login WHERE active=1 ORDER BY login'); } $qf->addElement('select', 'user', __('User'), array('all' => '[' . __('All') . ']') + $emps); $qf->addElement('datepicker', 'from_date', __('From')); $qf->addElement('datepicker', 'to_date', __('To')); $qf->addElement('text', 'search', __('Search for')); $qf->addElement('submit', 'submit_button', __('Filter')); $to_date =& $this->get_module_variable('to_date'); $from_date =& $this->get_module_variable('from_date'); $user =& $this->get_module_variable('to', "all"); $qf->setDefaults(array('from_date' => $from_date, 'to_date' => $to_date, 'user' => $uid)); //if submited if ($qf->validate()) { $from_date = $qf->exportValue('from_date'); $to_date = $qf->exportValue('to_date'); $user = $qf->exportValue('user'); $search_word = $qf->exportValue('search'); } $qf->assign_theme('form', $th); $uid = is_numeric($user) ? $user : null; $date_where = ''; if ($from_date) { $date_where .= 'AND posted_on>=' . DB::DBDate($from_date); } if ($to_date) { $date_where .= 'AND posted_on<=' . DB::DBDate($to_date); } if (isset($search_word) && $search_word) { $search_word = explode(' ', $search_word); foreach ($search_word as $word) { if ($word) { $date_where .= ' AND message ' . DB::like() . ' ' . DB::Concat(DB::qstr('%'), DB::qstr(htmlspecialchars($word, ENT_QUOTES, 'UTF-8')), DB::qstr('%')); } } } $gb = $this->init_module(Utils_GenericBrowser::module_name(), null, 'shoutbox_history'); $gb->set_table_columns(array(array('name' => __('From'), 'width' => 10), array('name' => __('To'), 'width' => 10), array('name' => __('Message'), 'width' => 64), array('name' => __('Date'), 'width' => 16))); // $gb->set_default_order(array(__('Date')=>'DESC')); $myid = Base_AclCommon::get_user(); $where = '(' . ($uid ? '(base_user_login_id=' . $myid . ' AND to_user_login_id=' . $uid . ') OR (base_user_login_id=' . $uid . ' AND to_user_login_id=' . $myid . ') OR (to_user_login_id is null AND base_user_login_id=' . $uid . ')' : 'to_user_login_id is null OR to_user_login_id=' . $myid . ' OR base_user_login_id=' . $myid) . ')' . $date_where; $query = 'SELECT base_user_login_id, to_user_login_id, message, posted_on FROM apps_shoutbox_messages WHERE ' . $where . ' ORDER BY posted_on DESC'; $query_qty = 'SELECT count(id) FROM apps_shoutbox_messages WHERE ' . $where; $ret = $gb->query_order_limit($query, $query_qty); if ($ret) { while ($row = $ret->FetchRow()) { $ulogin = Base_UserCommon::get_user_label($row['base_user_login_id']); if ($row['to_user_login_id'] !== null) { $tologin = Base_UserCommon::get_user_label($row['to_user_login_id']); } else { $tologin = '******' . __('All') . ']'; } $gb->add_row('<span class="author">' . $ulogin . '</span>', '<span class="author">' . $tologin . '</span>', array('value' => Utils_BBCodeCommon::parse($row['message']), 'overflow_box' => false), Base_RegionalSettingsCommon::time2reg($row['posted_on'])); } } $gb->set_inline_display(true); $th->assign('messages', $this->get_html_of_module($gb)); $th->display(); return true; }
//print it out foreach ($arr as $row) { $daydiff = floor((time() - strtotime($row['posted_on'])) / 86400); switch (true) { case $daydiff < 1: $fcolor = '#000000'; break; case $daydiff < 3: $fcolor = '#444444'; break; case $daydiff < 7: $fcolor = '#888888'; break; default: $fcolor = '#AAAAAA'; } $user_label = Apps_ShoutboxCommon::create_write_to_link($row['from_login_id']); if ($row['to_login_id']) { $user_label .= ' -> ' . Apps_ShoutboxCommon::create_write_to_link($row['to_login_id']); } print '<span class="author border_radius_3px dark_blue_gradient">' . $user_label . '</span><span class="time"> [' . Base_RegionalSettingsCommon::time2reg($row['posted_on'], 2) . ']</span><br/><span class="shoutbox_textbox"style="color:' . $fcolor . ';">' . ($row['to_login_id'] == $myid && $uid === null ? '<b>' : '') . Utils_BBCodeCommon::parse($row['message']) . ($row['to_login_id'] == $myid && $uid === null ? '</b>' : '') . '</span><hr/>'; } $content = ob_get_contents(); ob_end_clean(); require_once 'libs/minify/HTTP/Encoder.php'; $he = new HTTP_Encoder(array('content' => $content)); if (MINIFY_ENCODE) { $he->encode(); } $he->sendAll(); exit;
public static function display_note($row, $nolink = false, $a=null,$view=false) { $inline_img = ''; $link_href = ''; $link_img = ''; $icon = ''; $crypted = Utils_RecordBrowserCommon::get_value('utils_attachment',$row['id'],'crypted'); if(!$crypted || isset($_SESSION['client']['cp'.$row['id']])) { $files = DB::GetAll('SELECT id, created_by, created_on, original, (SELECT count(*) FROM utils_attachment_download uad WHERE uaf.id=uad.attach_file_id) as downloads FROM utils_attachment_file uaf WHERE uaf.attach_id=%d AND uaf.deleted=0', array($row['id'])); foreach ($files as $f) { $f_filename = DATA_DIR.'/Utils_Attachment/'.$row['id'].'/'.$f['id']; if(file_exists($f_filename)) { $filename = $f['original']; $filetooltip = __('Filename: %s',array($filename)).'<br>'.__('File size: %s',array(filesize_hr($f_filename))).'<hr>'. __('Last uploaded by %s', array(Base_UserCommon::get_user_label($f['created_by'], true))).'<br/>'. __('On: %s',array(Base_RegionalSettingsCommon::time2reg($f['created_on']))).'<br/>'. __('Number of downloads: %d',array($f['downloads'])); $view_link = ''; $lb = array(); $lb['aid'] = $row['id']; $lb['crypted'] = $crypted; $lb['original'] = $f['original']; $lb['id'] = $f['id']; $link_href = Utils_TooltipCommon::open_tag_attrs($filetooltip).' '.self::get_file_leightbox($lb,$view_link); $link_img = Base_ThemeCommon::get_template_file('Utils_Attachment','z-attach.png'); if(Utils_AttachmentCommon::is_image($filename) && $view_link) $inline_img .= '<hr><a href="'.$view_link.'" target="_blank"><img src="'.$view_link.'" style="max-width:700px" /></a><br>'; } else { $filename = __('Missing file: %s',array($f_filename)); $link_href = Utils_TooltipCommon::open_tag_attrs($filename); $link_img = Base_ThemeCommon::get_template_file('Utils_Attachment','z-attach-off.png'); } if ($link_href) $icon .= '<div class="file_link"><a '.$link_href.'><img src="'.$link_img.'"><span class="file_name">'.$filename.'</span></a></div>'; } } if($crypted) { $text = false; if(isset($_SESSION['client']['cp'.$row['id']])) { $note_pass = $_SESSION['client']['cp'.$row['id']]; $decoded = Utils_AttachmentCommon::decrypt($row['note'],$note_pass); if($decoded!==false) { $text = $decoded; Utils_WatchdogCommon::notified('utils_attachment', $row['id']); // notified only when decrypted } } if($text===false) { $text = '<div id="note_value_'.$row['id'].'"><a href="javascript:void(0);" onclick="utils_attachment_password(\''.Epesi::escapeJS(__('Password').':').'\',\''.Epesi::escapeJS(__('OK')).'\','.$row['id'].')" style="color:red">'.__('Note encrypted').'</a></div>'; $icon = ''; $files = array(); } else { $text = Utils_BBCodeCommon::parse($text); } } else { $text = $row['note']; $text = Utils_BBCodeCommon::parse($text); // mark as read all 'browsed' records foreach (self::$mark_as_read as $note_id) { Utils_WatchdogCommon::notified('utils_attachment', $note_id); } self::$mark_as_read = array(); } $text = (!$view?'<b style="float:left;margin-right:30px;">'.$row['title'].'</b> ':'').$text.$icon.$inline_img; if($row['sticky']) $text = '<img src="'.Base_ThemeCommon::get_template_file('Utils_Attachment','sticky.png').'" hspace=3 align="left"> '.$text; return $text; }