本文整理汇总了PHP中StringUtil::formatInteger方法的典型用法代码示例。如果您正苦于以下问题：PHP StringUtil::formatInteger方法的具体用法？PHP StringUtil::formatInteger怎么用？PHP StringUtil::formatInteger使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类StringUtil的用法示例。
在下文中一共展示了StringUtil::formatInteger方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: execute
/**
* @see EventListener::execute()
*/
public function execute($eventObj, $className, $eventName)
{
/* OptionTypeMemberslistcolumns */
if ($eventName == 'construct') {
$eventObj->staticColumns['posts'] = 'wcf.user.posts';
} else {
if ($eventName == 'readParameters') {
$eventObj->specialSortFields[] = 'posts';
} else {
if ($eventName == 'readData') {
if ($eventObj->sortField == 'posts') {
$eventObj->userTable = 'wbb' . WBB_N . '_user';
} else {
$eventObj->sqlSelects .= 'wbb_user.posts,';
$eventObj->sqlJoins .= ' LEFT JOIN wbb' . WBB_N . '_user wbb_user
ON (wbb_user.userID = user.userID) ';
}
} else {
if ($eventName == 'assignVariables') {
if (in_array('posts', $eventObj->activeFields)) {
foreach ($eventObj->members as $key => $memberData) {
$user = $memberData['user'];
$username = $memberData['encodedUsername'];
$eventObj->members[$key]['posts'] = '<a href="index.php?form=Search&types[]=post&userID=' . $user->userID . SID_ARG_2ND . '" title="' . WCF::getLanguage()->get('wcf.user.profile.search', array('$username' => $username)) . '">' . StringUtil::formatInteger(intval($user->posts)) . '</a>';
}
}
}
}
}
}
}示例2: __construct
public function __construct($data, $boxname = "")
{
$this->TopData['templatename'] = "topthreads";
$this->getBoxStatus($data);
$this->TopData['boxID'] = $data['boxID'];
if (!defined('TOPTHREADS_COUNT')) {
define('TOPTHREADS_COUNT', 10);
}
if (!defined('TOPTHREADS_TITLELENGTH')) {
define('TOPTHREADS_TITLELENGTH', 25);
}
if (!defined('TOPTHREADS_SBCOLOR_ACP')) {
define('TOPTHREADS_SBCOLOR_ACP', 2);
}
require_once WBB_DIR . 'lib/data/board/Board.class.php';
$boardIDs = Board::getAccessibleBoards();
if (!empty($boardIDs)) {
$sql = "SELECT thread.*" . "\n FROM wbb" . WBB_N . "_thread thread" . "\n WHERE thread.boardID IN (0" . $boardIDs . ")" . "\n ORDER BY thread.replies DESC" . "\n LIMIT 0, " . TOPTHREADS_COUNT;
$result = WBBCore::getDB()->sendQuery($sql);
while ($row = WBBCore::getDB()->fetchArray($result)) {
$row['replies'] = StringUtil::formatInteger($row['replies']);
$row['title'] = StringUtil::encodeHTML($row['topic']) . ' - ' . $row['replies'];
if (TOPTHREADS_TITLELENGTH != 0 && strlen($row['topic']) > TOPTHREADS_TITLELENGTH) {
$row['topic'] = StringUtil::substring($row['topic'], 0, TOPTHREADS_TITLELENGTH - 3) . '...';
}
$row['topic'] = StringUtil::encodeHTML($row['topic']);
$this->TopData['threads'][] = $row;
}
}
}示例3: execute
/**
* @see EventListener::execute()
*/
public function execute($eventObj, $className, $eventName)
{
if ($eventName == 'init') {
$eventObj->sqlSelects .= 'wbb_user.posts,';
$eventObj->sqlJoins .= ' LEFT JOIN wbb' . WBB_N . '_user wbb_user
ON (wbb_user.userID = user.userID) ';
} else {
if ($eventName == 'assignVariables') {
$user = $eventObj->frame->getUser();
$eventObj->generalInformation[] = array('icon' => StyleManager::getStyle()->getIconPath('postM.png'), 'title' => WCF::getLanguage()->get('wcf.user.posts'), 'value' => '<a href="index.php?form=Search&types[]=post&userID=' . $user->userID . SID_ARG_2ND . '" title="' . WCF::getLanguage()->get('wcf.user.profile.search', array('$username' => StringUtil::encodeHTML($user->username))) . '">' . StringUtil::formatInteger(intval($user->posts)) . ($user->getProfileAge() > 1 ? ' ' . WCF::getLanguage()->get('wcf.user.postsPerDay', array('$posts' => StringUtil::formatDouble($user->posts / $user->getProfileAge()))) : '') . '</a>');
// show last 5 posts
if (PROFILE_SHOW_LAST_POSTS) {
require_once WBB_DIR . 'lib/data/post/ViewablePost.class.php';
require_once WBB_DIR . 'lib/data/board/Board.class.php';
$boardIDArray = Board::getAccessibleBoardIDArray(array('canViewBoard', 'canEnterBoard', 'canReadThread'));
if (count($boardIDArray)) {
$posts = array();
$sql = "SELECT\t\tpost.postID, post.time,\n\t\t\t\t\t\t\t\tCASE WHEN post.subject <> '' THEN post.subject ELSE thread.topic END AS subject\n\t\t\t\t\t\tFROM\t\twbb" . WBB_N . "_user_last_post user_last_post\n\t\t\t\t\t\tLEFT JOIN\twbb" . WBB_N . "_post post\n\t\t\t\t\t\tON\t\t(post.postID = user_last_post.postID)\n\t\t\t\t\t\tLEFT JOIN\twbb" . WBB_N . "_thread thread\n\t\t\t\t\t\tON\t\t(thread.threadID = post.threadID)\n\t\t\t\t\t\tWHERE\t\tuser_last_post.userID = " . $user->userID . "\n\t\t\t\t\t\t\t\tAND post.isDeleted = 0\n\t\t\t\t\t\t\t\tAND post.isDisabled = 0\n\t\t\t\t\t\t\t\tAND thread.boardID IN (" . implode(',', $boardIDArray) . ")\n\t\t\t\t\t\t\t\t" . (count(WCF::getSession()->getVisibleLanguageIDArray()) ? "AND thread.languageID IN (" . implode(',', WCF::getSession()->getVisibleLanguageIDArray()) . ")" : "") . "\n\t\t\t\t\t\tORDER BY\tuser_last_post.time DESC";
$result = WCF::getDB()->sendQuery($sql, 5);
while ($row = WCF::getDB()->fetchArray($result)) {
$posts[] = new ViewablePost(null, $row);
}
if (count($posts)) {
WCF::getTPL()->assign(array('posts' => $posts, 'user' => $user));
WCF::getTPL()->append('additionalContent2', WCF::getTPL()->fetch('userProfileLastPosts'));
}
}
}
}
}
}示例4: __construct
public function __construct($data, $boxname = "")
{
$this->TopData['templatename'] = "topthanksgivinguser";
$this->getBoxStatus($data);
$this->TopData['boxID'] = $data['boxID'];
if (!defined('TOPTHANKSGIVINGUSER_COUNT_ACP')) {
define('TOPTHANKSGIVINGUSER_COUNT_ACP', 10);
}
if (!defined('TOPTHANKSGIVINGUSER_TITLELENGTH_ACP')) {
define('TOPTHANKSGIVINGUSER_TITLELENGTH_ACP', 28);
}
if (!defined('TOPTHANKSGIVINGUSER_SBCOLOR_ACP')) {
define('TOPTHANKSGIVINGUSER_SBCOLOR_ACP', 2);
}
if (!defined('TOPTHANKSGIVINGUSER_HITS_ACP')) {
define('TOPTHANKSGIVINGUSER_HITS_ACP', true);
}
$sql = "SELECT wcf.userID, wcf.username, wbb.thanks_got" . "\n FROM wcf" . WCF_N . "_user wcf" . "\n LEFT JOIN wbb" . WBB_N . "_user wbb ON (wbb.userid = wcf.userid)" . "\n WHERE wbb.thanks_got > 0" . "\n ORDER BY wbb.thanks_got DESC, wcf.username" . "\n LIMIT 0, " . TOPTHANKSGIVINGUSER_COUNT_ACP;
$result = WBBCore::getDB()->sendQuery($sql);
while ($row = WBBCore::getDB()->fetchArray($result)) {
$plainUser = $row['username'];
$row['thanks_got'] = StringUtil::formatInteger($row['thanks_got']);
if (TOPTHANKSGIVINGUSER_TITLELENGTH_ACP != 0 && strlen($plainUser) > TOPTHANKSGIVINGUSER_TITLELENGTH_ACP) {
$row['username'] = StringUtil::substring($plainUser, 0, TOPTHANKSGIVINGUSER_TITLELENGTH_ACP - 3) . '...';
}
$row['username'] = StringUtil::encodeHTML($row['username']);
$this->TopData['thanksgivinguser'][] = $row;
}
WCF::getTPL()->assign('TOPTHANKSGIVINGUSER_SBCOLOR_ACP', intval(TOPTHANKSGIVINGUSER_SBCOLOR_ACP));
WCF::getTPL()->assign('TOPTHANKSGIVINGUSER_HITS_ACP', TOPTHANKSGIVINGUSER_HITS_ACP);
}示例5: execute
/**
* @see EventListener::execute()
*/
public function execute($eventObj, $className, $eventName)
{
// ip address
if (WCF::getUser()->getPermission('admin.general.canViewIpAddress') && $eventObj->container instanceof ThreadPage) {
foreach ($eventObj->messageSidebars as $id => $sidebar) {
if ($sidebar->getSidebarObject()->ipAddress) {
$title = WCF::getLanguage()->getDynamicVariable('wbb.thread.ipAddress', array('username' => $sidebar->getUser()->username, 'ipAddress' => $sidebar->getSidebarObject()->ipAddress));
$sidebar->addUserContact('<a href="index.php?page=IpAddress&postID=' . $sidebar->getSidebarObject()->postID . SID_ARG_2ND . '"><img src="' . StyleManager::getStyle()->getIconPath('ipAddressS.png') . '" alt="' . $title . '" title="' . $title . '" /></a>');
}
}
}
// thread starter icon
if (MESSAGE_SIDEBAR_ENABLE_THREAD_STARTER_ICON == 1 && $eventObj->container instanceof ThreadPage && $eventObj->container->thread->userID != 0) {
foreach ($eventObj->messageSidebars as $id => $sidebar) {
if ($eventObj->container->thread->userID == $sidebar->getUser()->userID) {
$title = WCF::getLanguage()->getDynamicVariable('wbb.thread.starter', array('username' => $sidebar->getUser()->username));
$sidebar->addUserSymbol('<img src="' . StyleManager::getStyle()->getIconPath('threadStarterS.png') . '" alt="' . $title . '" title="' . $title . '" />');
}
}
}
// post count
if (MESSAGE_SIDEBAR_ENABLE_USER_POSTS == 1) {
foreach ($eventObj->messageSidebars as $id => $sidebar) {
if ($sidebar->getUser()->userID != 0 && $sidebar->getSidebarObject()->posts !== null) {
$sidebar->userCredits = array_merge(array(array('name' => WCF::getLanguage()->get('wcf.user.posts'), 'value' => StringUtil::formatInteger($sidebar->getSidebarObject()->posts), 'url' => 'index.php?form=Search&types[]=post&userID=' . $sidebar->getUser()->userID . SID_ARG_2ND)), $sidebar->userCredits);
}
}
}
}示例6: readEntries
public function readEntries($sortField = 'updateDate', $sortOrder = 'DESC', $pageNo = 1, $itemsPerPage = 20)
{
$ret = array();
$i = 0;
if (preg_match('/(userID|avatarID)/', $sortField)) {
$sortField = 'u.' . $sortField;
}
require_once WCF_DIR . 'lib/data/user/UserProfile.class.php';
require_once WCF_DIR . 'lib/data/user/avatar/Avatar.class.php';
$sql = "SELECT uwp.*, IFNULL(SUM(attachmentSize),0) + LENGTH(uwp.text) AS size, COUNT(attachmentID) AS aCnt, u.*, a.*, rank.*, uo.*" . "\n FROM wcf" . WCF_N . "_user_wanted_poster uwp" . "\n JOIN wcf" . WCF_N . "_user u ON u.userID = uwp.userID" . "\n LEFT JOIN wcf" . WCF_N . "_attachment wat ON (wat.userID = uwp.userID AND wat.messageType = 'wantedPoster')" . "\n LEFT JOIN wcf" . WCF_N . "_avatar a ON (a.avatarID = u.avatarID)" . "\n LEFT JOIN wcf" . WCF_N . "_user_rank rank ON (rank.rankID = u.rankID)" . "\n LEFT JOIN wcf" . WCF_N . "_user_option_value uo ON (uo.userID = u.userID)";
if (!WCF::getUser()->getPermission('mod.wantedPoster.canLockEntries')) {
$sql .= "\n WHERE uwp.locked != 1";
}
$sql .= "\n GROUP BY uwp.userID, uwp.insertDate, uwp.updateDate, uwp.text, uwp.views, uwp.enableSmilies, uwp.enableHtml, uwp.enableBBCodes, uwp.locked, uwp.lockDate, uwp.lockUser" . "\n ORDER BY " . $sortField . " " . $sortOrder . "\n LIMIT " . $itemsPerPage . "\nOFFSET " . ($pageNo - 1) * $itemsPerPage;
$result = WCF::getDB()->sendQuery($sql);
while ($row = WCF::getDB()->fetchArray($result)) {
$ret[$i]['userID'] = $row['userID'];
$ret[$i]['insertDate'] = $row['insertDate'];
$ret[$i]['updateDate'] = $row['updateDate'];
$ret[$i]['views'] = $row['views'];
$ret[$i]['locked'] = $row['locked'];
$ret[$i]['size'] = StringUtil::formatInteger($row['size']);
$ret[$i]['aCnt'] = StringUtil::formatInteger($row['aCnt']);
// username
$user = new UserProfile(null, $row);
$username = StringUtil::encodeHTML($row['username']);
$protectedProfile = $user->protectedProfile && WCF::getUser()->userID != $user->userID;
$userData = array('user' => $user, 'encodedUsername' => $username, 'protectedProfile' => $protectedProfile);
$userData['username'] = '<div class="containerIconSmall">';
if ($user->isOnline()) {
$title = WCF::getLanguage()->get('wcf.user.online', array('$username' => $username));
$userData['username'] .= '<img src="' . RELATIVE_WCF_DIR . 'icon/onlineS.png" alt="' . $title . '" title="' . $title . '" />';
} else {
$title = WCF::getLanguage()->get('wcf.user.offline', array('$username' => $username));
$userData['username'] .= '<img src="' . RELATIVE_WCF_DIR . 'icon/offlineS.png" alt="' . $title . '" title="' . $title . '" />';
}
$userData['username'] .= '</div><div class="containerContentSmall">';
$title = WCF::getLanguage()->get('wcf.user.viewProfile', array('$username' => $username));
$userData['username'] .= '<p><a href="index.php?page=User&userID=' . $row['userID'] . SID_ARG_2ND . '" title="' . $title . '">' . $username . '</a></p>';
if ($user->getUserTitle()) {
$userData['username'] .= '<p class="smallFont">' . $user->getUserTitle() . ' ' . ($user->getRank() ? $user->getRank()->getImage() : '') . '</p>';
}
$userData['username'] .= '</div>';
$ret[$i]['username'] = $userData['username'];
// avatar
if (empty($row['disableAvatar']) && !empty($row['avatarID']) && !empty($row['avatarExtension'])) {
$avatar = new Avatar(null, $row);
$avatar->setMaxHeight(50);
$title = WCF::getLanguage()->get('wcf.user.viewProfile', array('$username' => $row['username']));
$ret[$i]['avatar'] = '<a href="index.php?page=User&userID=' . $row['userID'] . SID_ARG_2ND . '" title="' . $title . '">' . $avatar->__toString() . '</a>';
} else {
$ret[$i]['avatar'] = ' ';
}
$i++;
}
return $ret;
}示例7: makeLink
/**
* Generates html code of a link.
*
* @param string $link
* @param integer $pageNo
* @param integer $activePage
* @paraM boolean $break
* @return string
*/
protected function makeLink($link, $pageNo, $activePage, $break = false)
{
// first page
if ($activePage != $pageNo) {
return '<li' . ($break ? ' class="break"' : '') . '><a href="' . $this->insertPageNumber($link, $pageNo) . '">' . StringUtil::formatInteger($pageNo) . '</a></li>' . "\n";
} else {
return '<li class="' . ($break ? 'break ' : '') . 'active"><span>' . StringUtil::formatInteger($pageNo) . '</span></li>' . "\n";
}
}示例8: __construct
public function __construct($data, $boxname = "")
{
$this->TopPosterData['templatename'] = "topposter";
$this->getBoxStatus($data);
$this->TopPosterData['boxID'] = $data['boxID'];
if (!defined('TOPPOSTER_COUNT')) {
define('TOPPOSTER_COUNT', 10);
}
if (!defined('TOPPOSTER_SBCOLOR_ACP')) {
define('TOPPOSTER_SBCOLOR_ACP', 2);
}
WCF::getTPL()->assign('TOPPOSTER_SBCOLOR_ACP', intval(TOPPOSTER_SBCOLOR_ACP));
$sql = "SELECT wcu.userid, wcu.username, wbu.posts" . "\n FROM wcf" . WCF_N . "_user wcu" . "\n LEFT JOIN wbb" . WBB_N . "_user wbu ON (wbu.userid = wcu.userid)" . "\n ORDER BY wbu.posts DESC, wcu.username" . "\n LIMIT 0, " . TOPPOSTER_COUNT;
$result = WBBCore::getDB()->sendQuery($sql);
while ($row = WBBCore::getDB()->fetchArray($result)) {
$row['username'] = StringUtil::encodeHTML($row['username']);
$row['posts'] = StringUtil::formatInteger($row['posts']);
$this->TopPosterData['users'][] = $row;
}
}示例9: __construct
public function __construct($data, $boxname = "")
{
$this->TopData['templatename'] = "topthanksgivingposts";
$this->getBoxStatus($data);
$this->TopData['boxID'] = $data['boxID'];
if (!defined('TOPTHANKSGIVING_COUNT_ACP')) {
define('TOPTHANKSGIVING_COUNT_ACP', 10);
}
if (!defined('TOPTHANKSGIVING_TITLELENGTH_ACP')) {
define('TOPTHANKSGIVING_TITLELENGTH_ACP', 28);
}
if (!defined('TOPTHANKSGIVING_SBCOLOR_ACP')) {
define('TOPTHANKSGIVING_SBCOLOR_ACP', 2);
}
if (!defined('TOPTHANKSGIVING_HITS_ACP')) {
define('TOPTHANKSGIVING_HITS_ACP', true);
}
require_once WBB_DIR . 'lib/data/board/Board.class.php';
$boardIDs = Board::getAccessibleBoards();
if (!empty($boardIDs)) {
$sql = "SELECT thread.topic AS subject, MIN(post.postID) AS postID, COUNT(*) AS cnt" . "\n FROM wbb" . WBB_N . "_thread thread" . "\n LEFT JOIN (wbb" . WBB_N . "_post post, wbb" . WBB_N . "_thank_guests tg, wbb" . WBB_N . "_thank_user tu)" . "\n ON (post.threadID = thread.threadID AND (post.postID = tu.postID OR post.postID = tg.postID))" . "\n WHERE thread.isDisabled = 0" . "\n AND thread.isDeleted = 0" . "\n AND thread.boardID IN (" . $boardIDs . ")" . "\n AND post.isDeleted = 0" . "\n AND post.isDisabled = 0" . "\n GROUP BY thread.threadID" . "\n ORDER BY cnt DESC" . "\n LIMIT 0, " . TOPTHANKSGIVING_COUNT_ACP;
$result = WBBCore::getDB()->sendQuery($sql);
while ($row = WBBCore::getDB()->fetchArray($result)) {
$plainSubject = $row['subject'];
$row['thanks'] = StringUtil::formatInteger($row['cnt']);
$row['title'] = StringUtil::encodeHTML($plainSubject) . ' - ' . $row['thanks'];
if (TOPTHANKSGIVING_TITLELENGTH_ACP != 0 && strlen($plainSubject) > TOPTHANKSGIVING_TITLELENGTH_ACP) {
$row['subject'] = StringUtil::substring($plainSubject, 0, TOPTHANKSGIVING_TITLELENGTH_ACP - 3) . '...';
}
$row['subject'] = StringUtil::encodeHTML($row['subject']);
$this->TopData['thanksgiving'][] = $row;
}
}
WCF::getTPL()->assign('TOPTHANKSGIVING_SBCOLOR_ACP', intval(TOPTHANKSGIVING_SBCOLOR_ACP));
WCF::getTPL()->assign('TOPTHANKSGIVING_HITS_ACP', TOPTHANKSGIVING_HITS_ACP);
}示例10: __construct
//.........这里部分代码省略.........
if (empty($boColor)) {
$boColor = 'FFFFFF';
}
if (empty($textColor)) {
$textColor = '000000';
}
$boardIDs = Board::getAccessibleBoards();
$user = new UserProfile(WCF::getUser()->userID);
// RANK
if ($user->rankImage) {
if (PERSONALBOX_REPEATRANKIMAGE_ACP && $user->repeatImage) {
$pbRankImage = '';
for ($i = 0; $i < $user->repeatImage; $i++) {
$pbRankImage .= '<img src="' . RELATIVE_WCF_DIR . $user->rankImage . '" alt="" title="' . WCF::getLanguage()->get($user->rankTitle) . '" />';
}
} else {
$pbRankImage = '<img src="' . RELATIVE_WCF_DIR . $user->rankImage . '" alt="" title="' . WCF::getLanguage()->get($user->rankTitle) . '" />';
}
}
$user->username = StringUtil::encodeHTML(WCF::getUser()->username);
$user->searchTime = $searchTime;
$user->bgColor = $bgColor;
$user->boColor = $boColor;
$user->textColor = $textColor;
$user->posts = 0;
$user->cntNewPosts = 0;
$user->cntLastPosts = 0;
$user->cntReported = 0;
$user->cntSub = 0;
if (WCF::getUser()->getPermission('user.profile.personalbox.cntOwnPosts')) {
// Anzahl Postings...
$sql = "SELECT wbu.posts" . "\n FROM wbb" . WBB_N . "_user wbu" . "\n WHERE wbu.userid = " . WCF::getUser()->userID;
$result = WBBCore::getDB()->getFirstRow($sql);
$user->posts = StringUtil::formatInteger($result['posts']);
}
// Instant Messenger by Tatzelwurm
if (INSTANTMESSENGER_AKTIV && (WCF::getUser()->getPermission('user.board.instantmessenger.canUseInstantMessenger') || WCF::getUser()->getPermission('user.instantmessenger.canUseInstantMessenger'))) {
if (@(require_once WCF_DIR . 'lib/data/InstantMessage/IM.class.php')) {
if (WCF::getUser()->getPermission('user.profile.personalbox.canSetIM') && WCF::getUser()->personalbox_show_im == 'enabled') {
$pbShowIM = true;
} else {
if (WCF::getUser()->getPermission('user.profile.personalbox.canSetIM') && WCF::getUser()->personalbox_show_im == 'disabled') {
$pbShowIM = false;
} else {
$pbShowIM = PERSONALBOX_SHOW_IM_ACP;
}
}
$imcount = IM::countNewIM();
}
}
// userOnlineMarking...
if (PERSONALBOX_SHOWUSERMARKING_ACP) {
$sql = "SELECT wcg.userOnlineMarking" . "\n FROM wcf" . WCF_N . "_group wcg" . "\n JOIN wcf" . WCF_N . "_user wcu ON (wcu.userOnlineGroupID = wcg.groupID)" . "\n WHERE wcu.userID = " . WCF::getUser()->userID;
$result = WBBCore::getDB()->getFirstRow($sql);
$userOnlineMarking = $result['userOnlineMarking'];
if ($userOnlineMarking && $userOnlineMarking != '%s') {
$user->username = sprintf($userOnlineMarking, StringUtil::encodeHTML(WCF::getUser()->username));
}
}
// neue Beitraege seit letztem Besuch und n Tagen, Abonnements...
if ($pbShowSearch) {
if (WCF::getUser()->getPermission('user.profile.personalbox.cntCurPosts')) {
$sql = "SELECT COUNT(*) cntNewPosts" . "\n FROM wbb" . WBB_N . "_thread wbt" . "\n WHERE wbt.boardID IN (0" . $boardIDs . ")" . "\n AND wbt.lastPostTime >= " . WCF::getUser()->boardLastActivityTime;
$result = WBBCore::getDB()->getFirstRow($sql);
$user->cntNewPosts = $result['cntNewPosts'];
}示例11: createBlock
/**
* Creates a valid block for the report.
*
* @param array data
* @return string
*/
protected function createBlock($data)
{
$block = '';
$dataSets = array();
foreach ($data as $date) {
$dataSets[] = '<td>' . $date['name'] . '</td><td id="' . $date['id'] . '">' . StringUtil::formatInteger($date['count']) . '</td>';
}
$rows = array_chunk($dataSets, $this->colCount);
foreach ($rows as $row) {
$block .= '<tr>';
foreach ($row as $dataSet) {
$block .= $dataSet;
}
$block .= '</tr>';
}
return $block;
}示例12: intval
}
$parse['FLOTA_TEST'] = $user['authlevel'] == 1 || $user['authlevel'] == 3 ? '<tr><td><div align="center"><font color="#FFFFFF"><a href="buildings.php?mode=fleet" accesskey="u" target="{mf}">KLIKNIJ TUTAJ NA TEST FLOTY</a></font></div></td></tr>
' : '';
$parse = $lang;
$parse['moon_img'] = "";
$parse['moon'] = "";
//}
$moon = WCF::getDB()->getFirstRow("SELECT * FROM ugml" . LW_N . "_planets WHERE galaxy = '" . $planetrow['galaxy'] . "' AND system = '" . $planetrow['system'] . "' AND planet = '" . $planetrow['planet'] . "' AND planet_type = '3'");
if (intval($moon['galaxy']) && WCF::getUser()->planetClassName == 'UserPlanet') {
$parse['moon'] = $moon['name'] . '<br /><a href="overview.php?cp=' . $moon['id'] . '&re=0"><img src="' . $dpath . 'planeten/small/s_' . $moon['image'] . '.jpg" height="50" width="50" /></a>';
}
$parse['planet_name'] = $planetrow['name'];
$parse['planet_diameter'] = $planetrow['diameter'];
$parse['planet_field_current'] = LWCore::getPlanet()->getUsedFields();
$parse['planet_field_max'] = LWCore::getPlanet()->getMaxFields();
//$parse['planet_field_max'] = 10;
$parse['planet_temp_min'] = $planetrow['temp_min'];
$parse['planet_temp_max'] = $planetrow['temp_max'];
$parse['galaxy_galaxy'] = $planetrow['galaxy'];
$parse['galaxy_planet'] = $planetrow['planet'];
$parse['galaxy_system'] = $planetrow['system'];
$parse['user_points'] = StringUtil::formatInteger(intval(WCF::getUser()->wotPoints));
//$parse['user_fleet'] = pretty_number($user['points_fleet_old']/1000); + pretty_number($user['points_builds2']/1000);
//$parse['user_buili'] = pretty_number($user['points_builds']/1000);
//$parse['player_points_tech'] = pretty_number($user['points_tech_old']/1000);
$parse['user_rank'] = intval(WCF::getUser()->wotRank);
$ile = $user['rank_old'] - $user['rank'];
if ($ile >= 1) {
$parse['ile'] = "<font color=lime>+" . $ile . "</font>";
}
if ($ile < 0) {示例13: makeLink
/**
* Generates html code of a link.
*
* @param string $link
* @param integer $pageNo
* @return string
*/
protected function makeLink($link, $pageNo)
{
return '<li><a href="' . $this->insertPageNumber($link, $pageNo) . '" title="' . WCF::getLanguage()->getDynamicVariable('wcf.page.pageNo', array('pageNo' => $pageNo)) . '">' . StringUtil::formatInteger($pageNo) . '</a></li>' . "\n";
}示例14: getGuestbookList
public function getGuestbookList($sortField = 'lastEntry', $sortOrder = 'DESC', $pageNo = 1, $itemsPerPage = 20)
{
$ret = array();
$i = 0;
$optID = self::getOptionID('userGuestbook_enable');
if (preg_match('/(userID|avatarID)/', $sortField)) {
$sortField = 'u.' . $sortField;
}
require_once WCF_DIR . 'lib/data/user/avatar/Avatar.class.php';
$gbUserIDs = 0;
$sql = "SELECT ugb.*, u.*, rank.*, a.*, uo.*, leu.username AS lastEntryUser, lv.username AS lastVisitor" . "\n FROM wcf" . WCF_N . "_user_guestbook_header ugb" . "\n JOIN wcf" . WCF_N . "_user u ON (u.userID = ugb.userID)" . "\n LEFT JOIN wcf" . WCF_N . "_user leu ON (leu.userID = ugb.lastEntryUserID)" . "\n LEFT JOIN wcf" . WCF_N . "_user lv ON (lv.userID = ugb.visitorID)" . "\n LEFT JOIN wcf" . WCF_N . "_avatar a ON (a.avatarID = u.avatarID)" . "\n LEFT JOIN wcf" . WCF_N . "_user_rank rank ON (rank.rankID = u.rankID)" . "\n LEFT JOIN wcf" . WCF_N . "_user_option_value uo ON (uo.userID = u.userID)" . "\n LEFT JOIN wcf" . WCF_N . "_user_option_value ov ON (ov.userID = ugb.userID)" . "\n LEFT JOIN wcf" . WCF_N . "_user_to_groups ug ON (ug.userID = ugb.userID)" . "\n LEFT JOIN wcf" . WCF_N . "_group_option_value gv ON (gv.groupID = ug.groupID)" . "\n LEFT JOIN wcf" . WCF_N . "_group_option go ON (go.optionID = gv.optionID)" . "\n WHERE ov.userOption" . $optID . " = '1'" . "\n AND gv.optionValue = '1'" . "\n AND go.optionName = 'user.guestbook.canUseOwn'";
if (!WCF::getUser()->getPermission('mod.guestbook.canLock')) {
$sql .= "\n AND ugb.locked != 1";
$sql .= "\n AND ugb.entries > 0";
} else {
$sql .= "\n AND (ugb.locked = 1 OR ugb.entries > 0)";
}
$sql .= "\n GROUP BY ugb.userID, ugb.userLastVisit, ugb.lastEntryUserID, ugb.lastEntry, ugb.entries, ugb.newEntries, ugb.views, ugb.visitorID, ugb.visitorLastVisit, ugb.locked, ugb.lockTime, ugb.lockUserID" . "\n ORDER BY " . $sortField . " " . $sortOrder . "\n LIMIT " . $itemsPerPage . "\nOFFSET " . ($pageNo - 1) * $itemsPerPage;
$result = WCF::getDB()->sendQuery($sql);
while ($row = WCF::getDB()->fetchArray($result)) {
$user = new UserProfile(null, $row);
if (!$user->userGuestbook_enable) {
continue;
}
$gbUserIDs .= ',' . $row['userID'];
$ret[$i]['curUserEntry'] = false;
$ret[$i]['userID'] = $row['userID'];
$ret[$i]['userLastVisit'] = $row['userLastVisit'];
$ret[$i]['userLastCommentTime'] = $row['userLastCommentTime'];
$ret[$i]['lastEntry'] = $row['lastEntry'];
$ret[$i]['visitorLastVisit'] = $row['visitorLastVisit'];
$ret[$i]['entries'] = StringUtil::formatInteger($row['entries']);
$ret[$i]['newEntries'] = StringUtil::formatInteger($row['newEntries']);
$ret[$i]['views'] = StringUtil::formatInteger($row['views']);
$ret[$i]['locked'] = $row['locked'];
if (empty($row['lastEntryUser'])) {
$ret[$i]['lastEntryUser'] = StringUtil::encodeHTML($row['lastEntryUsername']);
$ret[$i]['lastEntryUserID'] = 0;
} else {
$ret[$i]['lastEntryUser'] = StringUtil::encodeHTML($row['lastEntryUser']);
$ret[$i]['lastEntryUserID'] = $row['lastEntryUserID'];
}
$ret[$i]['lastVisitor'] = StringUtil::encodeHTML($row['lastVisitor']);
$ret[$i]['lastVisitorID'] = $row['visitorID'];
// username
$username = StringUtil::encodeHTML($row['username']);
$protectedProfile = $user->protectedProfile && WCF::getUser()->userID != $user->userID;
$userData = array('user' => $user, 'encodedUsername' => $username, 'protectedProfile' => $protectedProfile);
$userData['username'] = '<div class="containerIconSmall">';
if ($user->isOnline()) {
$title = WCF::getLanguage()->get('wcf.user.online', array('$username' => $username));
$userData['username'] .= '<img src="' . RELATIVE_WCF_DIR . 'icon/onlineS.png" alt="' . $title . '" title="' . $title . '" />';
} else {
$title = WCF::getLanguage()->get('wcf.user.offline', array('$username' => $username));
$userData['username'] .= '<img src="' . RELATIVE_WCF_DIR . 'icon/offlineS.png" alt="' . $title . '" title="' . $title . '" />';
}
$userData['username'] .= '</div><div class="containerContentSmall">';
$title = WCF::getLanguage()->get('wcf.user.viewProfile', array('$username' => $username));
$userData['username'] .= '<p><a href="index.php?page=User&userID=' . $row['userID'] . SID_ARG_2ND . '" title="' . $title . '">' . $username . '</a></p>';
if ($user->getUserTitle()) {
$userData['username'] .= '<p class="smallFont">' . $user->getUserTitle() . ' ' . ($user->getRank() ? $user->getRank()->getImage() : '') . '</p>';
}
$userData['username'] .= '</div>';
$ret[$i]['username'] = $userData['username'];
// avatar
if (empty($row['disableAvatar']) && !empty($row['avatarID']) && !empty($row['avatarExtension'])) {
$avatar = new Avatar(null, $row);
$avatar->setMaxHeight(50);
$title = WCF::getLanguage()->get('wcf.user.viewProfile', array('$username' => $row['username']));
$ret[$i]['avatar'] = '<a href="index.php?page=User&userID=' . $row['userID'] . SID_ARG_2ND . '" title="' . $title . '">' . $avatar->__toString() . '</a>';
} else {
$ret[$i]['avatar'] = ' ';
}
$i++;
}
if (!empty($gbUserIDs) && WCF::getUser()->userID) {
$sql = "SELECT DISTINCT userID" . "\n FROM wcf" . WCF_N . "_user_guestbook" . "\n WHERE userID IN (" . $gbUserIDs . ")" . "\n AND fromUserID = " . WCF::getUser()->userID;
$result = WCF::getDB()->sendQuery($sql);
while ($row = WCF::getDB()->fetchArray($result)) {
foreach ($ret as $k => $v) {
if ($ret[$k]['userID'] == $row['userID']) {
$ret[$k]['curUserEntry'] = true;
}
}
}
}
return $ret;
}示例15: execute
/**
* @see Action::execute()
*/
public function execute()
{
parent::execute();
// check permission
WCF::getUser()->checkPermission('admin.user.canPMToUserGroups');
$sql = "SELECT COUNT(DISTINCT u.userID) AS cnt" . "\n FROM wcf" . WCF_N . "_user u" . "\n LEFT JOIN wcf" . WCF_N . "_user_to_groups g ON (g.userID = u.userID)" . "\n LEFT JOIN wcf" . WCF_N . "_group_option_value v ON (v.groupID = g.groupID)" . "\n LEFT JOIN wcf" . WCF_N . "_group_option o ON (o.optionID = v.optionID)" . "\n WHERE o.optionName = 'user.pm.canUsePm'" . "\n AND v.optionValue = '1'" . "\n AND u.userID != " . $this->userID . "\n AND g.groupID IN (" . $this->pmData['groupIDs'] . ")";
$row = WCF::getDB()->getFirstRow($sql);
$count = $row['cnt'];
if (!$count > 0) {
// clear session
if (isset($this->pmData)) {
$pmData = WCF::getSession()->getVar('pmData');
unset($pmData[$this->pmSessionID]);
WCF::getSession()->register('pmData', $pmData);
}
$this->finish('wcf.pmToUgrps.error.noRecipients', 'index.php?form=PMToUserGroups&packageID=' . PACKAGE_ID . SID_ARG_2ND_NOT_ENCODED);
}
if ($count <= $this->limit * $this->loop) {
$endTime = TIME_NOW;
$lf = "\n";
// remove from outbox
$sql = "UPDATE wcf" . WCF_N . "_pm" . "\n SET saveInOutbox = 0" . "\n WHERE pmID = " . $this->pmID;
WCF::getDB()->sendQuery($sql);
// groups...
$groups = '';
$sql = "SELECT groupName" . "\n FROM wcf" . WCF_N . "_group" . "\n WHERE groupID IN (" . $this->pmData['groupIDs'] . ")" . "\n ORDER BY groupName";
$result = WCF::getDB()->sendQuery($sql);
while ($row = WCF::getDB()->fetchArray($result)) {
if (!empty($groups)) {
$groups .= ', ';
}
$groups .= StringUtil::decodeHTML($row['groupName']);
}
// log...
$log = '';
$subject = WCF::getLanguage()->get('wcf.pmToUgrps.log.subject', array('$pmID' => $this->pmID)) . ' ' . $this->pmData['subject'];
if ($this->pmData['enableHtml']) {
$log .= '<pre>';
}
$log .= WCF::getLanguage()->get('wcf.pmToUgrps.log.started', array('$startTime' => DateUtil::formatDate('%d.%m.%Y %H:%M:%S', $this->pmData['startTime']))) . $lf;
$log .= WCF::getLanguage()->get('wcf.pmToUgrps.log.finished', array('$endTime' => DateUtil::formatDate('%d.%m.%Y %H:%M:%S', $endTime))) . $lf;
$log .= WCF::getLanguage()->get('wcf.pmToUgrps.log.recipients', array('$groups' => $groups, '$count' => StringUtil::decodeHTML(StringUtil::formatInteger($count)))) . $lf;
$log .= str_repeat('-', 60) . $lf;
if ($this->pmData['enableHtml']) {
$log .= '</pre>' . $lf;
}
$log .= $this->pmData['text'];
$this->recipientArray = $this->blindCopyArray = array();
$this->recipientArray[0]['userID'] = $this->userID;
$this->recipientArray[0]['username'] = $this->username;
PMEditor::create($this->draft, $this->recipientArray, $this->blindCopyArray, $subject, $log, $this->userID, $this->username, array('enableSmilies' => $this->pmData['enableSmilies'], 'enableHtml' => $this->pmData['enableHtml'], 'enableBBCodes' => $this->pmData['enableBBCodes'], 'showSignature' => false));
// clear session
$pmData = WCF::getSession()->getVar('pmData');
unset($pmData[$this->pmSessionID]);
WCF::getSession()->register('pmData', $pmData);
$this->calcProgress();
$msg = WCF::getLanguage()->get('wcf.pmToUgrps.finish', array('$count' => StringUtil::decodeHTML(StringUtil::formatInteger($count)), '$startTime' => DateUtil::formatShortTime('%H:%M:%S', $this->pmData['startTime']), '$endTime' => DateUtil::formatShortTime('%H:%M:%S', $endTime)));
$this->finish($msg, 'index.php?form=PMToUserGroups&packageID=' . PACKAGE_ID . SID_ARG_2ND_NOT_ENCODED);
}
// get users
$sql = "SELECT DISTINCT u.userID, u.username" . "\n FROM wcf" . WCF_N . "_user u" . "\n LEFT JOIN wcf" . WCF_N . "_user_to_groups g ON (g.userID = u.userID)" . "\n LEFT JOIN wcf" . WCF_N . "_group_option_value v ON (v.groupID = g.groupID)" . "\n LEFT JOIN wcf" . WCF_N . "_group_option o ON (o.optionID = v.optionID)" . "\n WHERE o.optionName = 'user.pm.canUsePm'" . "\n AND v.optionValue = '1'" . "\n AND u.userID != " . $this->userID . "\n AND g.groupID IN (" . $this->pmData['groupIDs'] . ")" . "\n ORDER BY u.userID";
$this->blindCopyArray = array();
$i = 0;
$result = WCF::getDB()->sendQuery($sql, $this->limit, $this->limit * $this->loop);
while ($row = WCF::getDB()->fetchArray($result)) {
$this->blindCopyArray[$i]['userID'] = $row['userID'];
$this->blindCopyArray[$i]['username'] = $row['username'];
$i++;
}
if (count($this->blindCopyArray)) {
if (empty($this->pmID)) {
$tmp = PMEditor::create($this->draft, $this->recipientArray, $this->blindCopyArray, $this->pmData['subject'], $this->pmData['text'], $this->userID, $this->username, array('enableSmilies' => $this->pmData['enableSmilies'], 'enableHtml' => $this->pmData['enableHtml'], 'enableBBCodes' => $this->pmData['enableBBCodes'], 'showSignature' => $this->pmData['showSignature']));
if ($tmp->pmID) {
$this->pmID = intval($tmp->pmID);
$pmData = WCF::getSession()->getVar('pmData');
$pmData[$this->pmSessionID]['pmID'] = $this->pmID;
WCF::getSession()->register('pmData', $pmData);
$mlt = intval($this->pmData['maxLifeTime']);
if ($mlt > 0) {
$mlt = $this->pmData['startTime'] + 86400 * $mlt;
} else {
$mlt = 0;
}
$sql = "INSERT IGNORE INTO wcf" . WCF_N . "_pm_bulk_mailing" . "\n (pmID, elapsedTime, time, userID)" . "\nVALUES (" . $this->pmID . ", " . $mlt . ", " . $this->pmData['startTime'] . ", " . $this->userID . ")";
WCF::getDB()->sendQuery($sql);
}
} else {
$recipientIDs = $inserts = '';
foreach ($this->blindCopyArray as $k => $v) {
$username = WCF::getDB()->escapeString($this->blindCopyArray[$k]['username']);
if (!empty($recipientIDs)) {
$recipientIDs .= ',';
}
$recipientIDs .= $this->blindCopyArray[$k]['userID'];
if (!empty($inserts)) {
$inserts .= ',';
}
//.........这里部分代码省略.........