public function showAccountLinkNews() { // $db = gdo_db(); // $users = GWF_TABLE_PREFIX.'user'; //// $history = GWF_TABLE_PREFIX.'wc_user_history'; // $regat = GWF_TABLE_PREFIX.'wc_regat'; // $sites = GWF_TABLE_PREFIX.'wc_site'; //// $time = GWF_Time::getTimeWeekStart(); // $today = GWF_Time::getDate(GWF_Date::LEN_DAY); // $query = // "SELECT user_name, site_name, regat_solved ". // "FROM $regat ". // "LEFT JOIN $users ON user_id=regat_uid ". // "LEFT JOIN $sites ON site_id=regat_sid ". // "WHERE regat_linkdate='$today' AND regat_solved>0"; // if (false === ($result = $db->queryAll($query))) { // return ''; // } $result = $this->getFirstLinkNews(); if (count($result) === 0) { return ''; } $msg = ''; foreach ($result as $row) { $un = $row['fili_username']; $sn = $row['fili_sitename']; // $site_link = sprintf('[url=%s]%s[/url]', GWF_WEB_ROOT, urlencode($sn), GWF_HTML::display($sn)); $site_link = sprintf('[b]%s[/b]', $sn); $perc = sprintf('%.02f', $row['fili_percent']); $profile_link = sprintf('[url=/profile/%s]%s[/url]', $un, $un); $msg .= $this->lang('newsrow_link', array($profile_link, $site_link, $perc)) . PHP_EOL; // $msg .= sprintf('%s', $this->lang('newsrow_link', sprintf('<a href="%sprofile/%s">%s</a>', GWF_WEB_ROOT, urlencode($un), GWF_HTML::display($row['fili_username'])), , )).PHP_EOL; } $title = $this->lang('newsrow_linkt'); $wechalluser = $this->cfgWeChallUser(); $english = GWF_Language::getEnglish(); $news = GWF_News::newNews(GWF_Time::getDate(GWF_Date::LEN_SECOND), 0, $wechalluser->getID(), $english->getID(), $title, $msg, true); return Module_News::displayItem($news); }