PHP sp_date函数代码示例

function spa_toolbox_errorlog_form()
{
    ?>
<script type="text/javascript">
    jQuery(document).ready(function() {
    	spjAjaxForm('sfclearlog', 'sfreloadel');
    });
</script>
<?php 
    $sflog = spa_get_errorlog_data();
    spa_paint_open_tab(spa_text('Toolbox') . ' - ' . spa_text('Error Log'), true);
    spa_paint_open_fieldset(spa_text('Error Log'), false);
    echo '<p>' . spa_text('Error Logging can be disabled in the Global Options panel') . '<br /></p>';
    echo "<table class='sfhelptext'><tr>";
    echo "<td class='spaErrError spaErrCell'><b>" . spa_text('Error') . '</b></td>';
    echo "<td class='spaErrWarning spaErrCell'><b>" . spa_text('Warning') . '</b></td>';
    echo "<td class='spaErrNotice spaErrCell'><b>" . spa_text('Notice') . '</b></td>';
    echo "<td class='spaErrStrict spaErrCell'><b>" . spa_text('Strict') . '</b></td>';
    echo "</tr><tr>";
    echo "<td class='spaErrCellDesc'>" . spa_text('Errors should be reported to Simple:Press support as they may effect the proper behaviour of your forum') . '</td>';
    echo "<td class='spaErrCellDesc'>" . spa_text('Warnings suggest a code conflict of some type that should be investigated but which will not stop Simple:Press execution') . '</td>';
    echo "<td class='spaErrCellDesc'>" . spa_text('Notices are generally non-important and have no effect on Simple:Press execution. We make every effort to clear these when we are informed of them') . '</td>';
    echo "<td class='spaErrCellDesc'>" . spa_text('If you receive any Strict entries they are non-urgent but please inform Simple:Press support so we can deal with them') . '</td>';
    echo "</tr></table><p>&nbsp;</p>";
    if (!$sflog) {
        echo '<p>' . spa_text('There are no Error Log Entries') . '</p>';
    } else {
        echo "<table class='wp-list-table widefat'>";
        foreach ($sflog as $log) {
            echo '<tr>';
            echo "<td class='sferror " . $log['error_cat'] . "'>" . sp_date('d', $log['error_date']) . ' ' . sp_date('t', $log['error_date']) . ' | ' . $log['error_cat'] . ' | ' . $log['error_count'] . ' | ' . $log['error_type'] . '<hr />';
            echo $log['error_text'] . '</td>';
            echo '</tr>';
        }
        echo '</table>';
    }
    spa_paint_close_fieldset();
    do_action('sph_toolbox_error_panel');
    spa_paint_close_container();
    $ahahURL = SFHOMEURL . 'index.php?sp_ahah=toolbox-loader&amp;sfnonce=' . wp_create_nonce('forum-ahah') . '&amp;saveform=sfclearlog';
    ?>
	<form action="<?php 
    echo $ahahURL;
    ?>
" method="post" id="sfclearlog" name="sfclearlog">
	<?php 
    echo sp_create_nonce('forum-adminform_clearlog');
    ?>
	<div class="sfform-submit-bar">
	<input type="submit" class="button-primary" id="saveit" name="saveit" value="<?php 
    spa_etext('Empty Error Log');
    ?>
" />
	</div>
	</form>
<?php 
    spa_paint_close_tab();
}

function spa_toolbox_log_form()
{
    $sflog = spa_get_log_data();
    #== log Tab ==========================================================
    spa_paint_open_tab(spa_text('Toolbox') . " - " . spa_text('Install Log'), true);
    if (!$sflog) {
        spa_etext("There are no Install Log Entries");
        return;
    }
    spa_paint_open_panel();
    spa_paint_open_fieldset(spa_text('Install Log'), false);
    echo "<table class='wp-list-table widefat'><tr>";
    echo '<th>' . spa_text('Version') . '</th>';
    echo "<th class='logDetail'>" . "</th>";
    echo '<th>' . spa_text('Build') . '</th>';
    echo "<th class='logRelease'>" . spa_text('Release') . "</th>";
    echo '<th>' . spa_text('Installed') . '</th>';
    echo "<th class='logBy'>" . spa_text('By') . "</th>";
    echo '</tr>';
    foreach ($sflog as $log) {
        $idVer = 'version' . str_replace('.', '', $log['version']);
        $idQVer = str_replace('.', '-', $log['version']);
        echo '<tr>';
        echo "<td class='sflabel'>" . $log['version'] . "</td>";
        $site = SFHOMEURL . 'index.php?sp_ahah=install-log&amp;sfnonce=' . wp_create_nonce('forum-ahah') . '&amp;log=' . $idQVer;
        $gif = SFCOMMONIMAGES . 'working.gif';
        echo '<td class="logDetail"><input type="button" class="logDetail button" value="' . spa_text('Details') . '" onclick="spjLoadAhah(\'' . $site . '\', \'' . $idVer . '\', \'' . $gif . '\');" /></td>';
        echo "<td class='sflabel'>" . $log['build'] . "</td>";
        echo "<td class='sflabel logRelease'>" . $log['release_type'] . "</td>";
        echo "<td class='sflabel'>" . sp_date('d', $log['install_date']) . "</td>";
        echo "<td class='sflabel logBy'>" . sp_filter_name_display($log['display_name']) . "</td>";
        echo '</tr>';
        echo "<tr><td style='display:none;' class='sflabel' id='" . $idVer . "' colspan='6'></td></tr>";
    }
    echo '</table>';
    spa_paint_close_fieldset();
    spa_paint_close_panel();
    do_action('sph_toolbox_install_panel');
    spa_paint_close_container();
    echo '<div class="sfform-panel-spacer"></div>';
    spa_paint_close_tab();
}

function sp_ProfileShowLastVisit($args = '', $label = '')
{
    global $spProfileUser;
    if (!sp_get_auth('view_profiles')) {
        return;
    }
    $defs = array('tagClass' => 'spProfileShowLastVisit', 'leftClass' => 'spColumnSection spProfileLeftCol', 'middleClass' => 'spColumnSection spProfileSpacerCol', 'rightClass' => 'spColumnSection spProfileRightCol', 'echo' => 1, 'get' => 0);
    $a = wp_parse_args($args, $defs);
    $a = apply_filters('sph_ProfileShowLastVisit_args', $a);
    extract($a, EXTR_SKIP);
    # sanitize before use
    $tagClass = esc_attr($tagClass);
    $leftClass = esc_attr($leftClass);
    $middleClass = esc_attr($middleClass);
    $rightClass = esc_attr($rightClass);
    $label = sp_filter_title_display($label);
    $echo = (int) $echo;
    $get = (int) $get;
    if ($get) {
        return $spProfileUser->lastvisit;
    }
    # output first name
    $out = '';
    $out .= "<div class='{$leftClass}'>";
    $out .= "<p class='{$tagClass}'>{$label}:</p>";
    $out .= '</div>';
    $out .= "<div class='{$middleClass}'></div>";
    $out .= "<div class='{$rightClass}'>";
    $out .= "<p class='{$tagClass}'>" . sp_date('d', $spProfileUser->lastvisit) . ' ' . sp_date('t', $spProfileUser->lastvisit) . '</p>';
    $out .= "</div>\n";
    $out = apply_filters('sph_ProfileShowLastVisit', $out, $spProfileUser, $a);
    if ($echo) {
        echo $out;
    } else {
        return $out;
    }
}

//.........这里部分代码省略.........
    if (!empty($beforeUser)) {
        $beforeUser = trim($beforeUser) . ' ';
    }
    if (!empty($beforeDate)) {
        $beforeDate = trim($beforeDate) . ' ';
    }
    if (!empty($afterForum)) {
        $afterForum = ' ' . trim($afterForum);
    }
    if (!empty($afterTopic)) {
        $afterTopic = ' ' . trim($afterTopic);
    }
    if (!empty($afterUser)) {
        $afterUser = ' ' . trim($afterUser);
    }
    if (!empty($afterDate)) {
        $afterDate = ' ' . trim($afterDate);
    }
    $fLink = $tLink = $aLink = false;
    if ($linkScope == 'forum') {
        $fLink = $tLink = true;
    }
    if ($linkScope == 'all') {
        $aLink = true;
    }
    # Start building dislay
    $out = $listTags ? "<ul id='{$tagId}' class='{$tagClass}'>" : "<div id='{$tagId}' class='{$tagClass}'>";
    # start the loop
    if (sp_has_postlist()) {
        while (sp_loop_postlist()) {
            sp_the_postlist();
            $thisId = str_ireplace('%ID%', $spThisPostList->topic_id, $listId);
            $out .= $listTags ? "<li id='{$thisId}' class='{$listClass}'>" : "<div id='{$thisId}' class='{$listClass}'>";
            $title = $postTip ? "title='{$spThisPostList->post_tip}'" : '';
            if ($aLink) {
                $out .= "<a class='{$linkClass}' {$title} href='{$spThisPostList->post_permalink}'>";
            }
            for ($x = 0; $x < strlen($itemOrder); $x++) {
                switch (substr($itemOrder, $x, 1)) {
                    case 'F':
                        # Forum
                        $out .= $beforeForum;
                        if ($fLink) {
                            $out .= "<a class='{$linkClass}' href='{$spThisPostList->forum_permalink}'>";
                        }
                        $out .= sp_truncate($spThisPostList->forum_name, $truncate);
                        if ($fLink) {
                            $out .= '</a>';
                        }
                        $out .= $afterForum;
                        break;
                    case 'T':
                        # Topic
                        $out .= $beforeTopic;
                        if ($tLink) {
                            $out .= "<a class='{$linkClass}' {$title} href='{$spThisPostList->post_permalink}'>";
                        }
                        $out .= sp_truncate($spThisPostList->topic_name, $truncate);
                        if ($tLink) {
                            $out .= '</a>';
                        }
                        $out .= $afterTopic;
                        break;
                    case 'A':
                        # Avatar
                        $spx = $avatarSize + 10 . 'px';
                        $out .= sp_UserAvatar("tagClass={$avatarClass}&size={$avatarSize}&link=none&context=user&echo=0", $spThisPostList);
                        break;
                    case 'U':
                        # user
                        $out .= "<span class='{$textClass}'>{$spThisPostList->display_name}{$afterUser}</span>";
                        break;
                    case 'D':
                        # date
                        if ($niceDate) {
                            $out .= "<span class='{$textClass}'>" . $beforeDate . sp_nicedate($spThisPostList->post_date) . "{$afterDate}</span>\n";
                        } else {
                            $out .= "<span class='{$textClass}'>" . $beforeDate . sp_date('d', $spThisPostList->post_date) . "{$afterDate}</span>\n";
                        }
                        break;
                    default:
                        # Invalid code
                        $out .= '<br />' . __('Invalid Tag Code Found', 'sp-ttags') . '<br />';
                        break;
                }
            }
            if ($aLink) {
                $out .= '</a>';
            }
            $out .= $listTags ? '</li>' : '</div>';
        }
    }
    $out .= $listTags ? '</ul>' : '</div>';
    $out = apply_filters('sph_UnansweredPostsTag', $out);
    if ($echo) {
        echo $out;
    } else {
        return $out;
    }
}

function sp_MemberListRegistered($args = '', $label = '')
{
    global $spThisMember;
    if (!sp_get_auth('view_members_list')) {
        return;
    }
    $defs = array('tagId' => 'spMembersListRegistration%ID%', 'tagClass' => 'spInRowCount', 'labelClass' => 'spInRowLabel', 'dateClass' => 'spInRowDate', 'stack' => 1, 'echo' => 1, 'get' => 0);
    $a = wp_parse_args($args, $defs);
    $a = apply_filters('sph_MemberListRegistered_args', $a);
    extract($a, EXTR_SKIP);
    # sanitize before use
    $tagId = esc_attr($tagId);
    $tagClass = esc_attr($tagClass);
    $labelClass = esc_attr($labelClass);
    $dateClass = esc_attr($dateClass);
    $stack = (int) $stack;
    $echo = (int) $echo;
    $get = (int) $get;
    $tagId = str_ireplace('%ID%', $spThisMember->user_id, $tagId);
    $att = $stack ? '<br />' : ': ';
    if ($get) {
        return $spThisMember->user_registered;
    }
    $out = "<div id='{$tagId}' class='{$tagClass}'>";
    $out .= "<span class='{$labelClass}'>" . sp_filter_title_display($label) . "{$att}</span>";
    $out .= "<span class='{$dateClass}'>" . sp_date('d', $spThisMember->user_registered) . '<br />' . sp_date('t', $spThisMember->user_registered) . '</span>';
    $out .= "</div>\n";
    $out = apply_filters('sph_MemberListRegistered', $out, $a);
    if ($echo) {
        echo $out;
    } else {
        return $out;
    }
}

}
if (empty($spProfileUser->timezone_string)) {
    $spProfileUser->timezone_string = get_option('timezone_string');
}
if (substr($spProfileUser->timezone_string, 0, 3) == 'UTC') {
    $spProfileUser->timezone_string = 'UTC';
}
date_default_timezone_set($spProfileUser->timezone_string);
$tout = '';
$tout .= '<div class="spColumnSection spProfileLeftCol">';
$tout .= '<p class="spProfileLabel">' . sp_text('Your Timezone') . ': </p>';
$tout .= '</div>';
$tout .= '<div class="spColumnSection spProfileSpacerCol"></div>';
$tout .= '<div class="spColumnSection spProfileRightCol">';
$tout .= '<p class="spProfileLabel">' . $spProfileUser->timezone_string . '</p>';
$tout .= '<p><small>' . sp_text('Local Time') . ': ' . sp_date('d', date(SFDATES)) . ' ' . sp_date('t', date(SFTIMES)) . '</small></p>';
$tout .= '<p><small>' . sp_text('Change your timezone on options - display') . '</small></p>';
$tout .= '</div>';
$out .= apply_filters('sph_ProfileUserTimezone', $tout, $userid, $thisSlug);
$out = apply_filters('sph_ProfileOverviewFormBottom', $out, $userid);
$out = apply_filters('sph_ProfileFormBottom', $out, $userid, $thisSlug);
$tout = '';
$tout .= '<div class="spColumnSection spProfileLeftCol"></div>';
$tout .= '<div class="spColumnSection spProfileSpacerCol"></div>';
$tout .= '<div class="spColumnSection spProfileRightCol">';
$tout .= '<form action="' . SFHOMEURL . 'index.php?sp_ahah=search&amp;sfnonce=' . wp_create_nonce('forum-ahah') . '" method="post" id="searchposts" name="searchposts">';
$tout .= '<input type="hidden" class="sfhiddeninput" name="searchoption" id="searchoption" value="2" />';
$tout .= '<input type="hidden" class="sfhiddeninput" name="userid" id="userid" value="' . $userid . '" />';
$tout .= '<div class="spProfileFormSubmit">';
$tout .= '<input type="submit" class="spSubmit" name="membersearch" value="' . sp_text('List Topics You Have Posted To') . '" />';
$tout .= '<input type="submit" class="spSubmit" name="memberstarted" value="' . sp_text('List Topics You Started') . '" />';

function sp_PostForumToolButton($args = '', $label = '', $toolTip = '')
{
    global $spThisTopic, $spThisPost, $spThisPostUser, $spThisUser, $spGuestCookie, $spGlobals;
    if ($spGlobals['lockdown'] == true && $spThisUser->admin == false) {
        return;
    }
    $show = false;
    if ($spThisUser->admin || $spThisUser->moderator) {
        $show = true;
    } else {
        $edit_days = sp_get_option('editpostdays');
        $post_date = strtotime(sp_date('d', $spThisPost->post_date));
        $date_diff = floor((time() - $post_date) / (60 * 60 * 24));
        if (sp_get_auth('view_email', $spThisTopic->forum_id) || sp_get_auth('pin_posts', $spThisTopic->forum_id) || sp_get_auth('edit_any_post', $spThisTopic->forum_id) || sp_get_auth('edit_own_posts_forever', $spThisTopic->forum_id) && $spThisUser->member && $spThisPostUser->ID == $spThisUser->ID || sp_get_auth('edit_own_posts_forever', $spThisTopic->forum_id) && $spThisUser->guest && $spThisPost->guest_email == $spGuestCookie->guest_email || sp_get_auth('edit_own_posts_reply', $spThisTopic->forum_id) && $spThisUser->member && $spThisPostUser->ID == $spThisUser->ID && $spThisPost->last_post || sp_get_auth('edit_own_posts_reply', $spThisTopic->forum_id) && $spThisUser->guest && $spThisPost->guest_email == $spGuestCookie->guest_email && $spThisPost->last_post || sp_get_auth('edit_own_posts_for_time', $spThisTopic->forum_id) && $spThisUser->member && $spThisPostUser->ID == $spThisUser->ID && $date_diff <= $edit_days || sp_get_auth('move_posts', $spThisTopic->forum_id) || sp_get_auth('reassign_posts', $spThisTopic->forum_id) || sp_get_auth('delete_any_post', $spThisTopic->forum_id) || sp_get_auth('delete_own_posts', $spThisTopic->forum_id) && $spThisPostUser->user_id == $spThisUser->ID || sp_get_auth('moderate_posts', $spThisTopic->forum_id) && $spThisPost->post_status != 0) {
            $show = true;
        }
    }
    $show = apply_filters('sph_forum_tools_topic_show', $show);
    if (!$show) {
        return;
    }
    $defs = array('tagId' => 'spForumToolButton%ID%', 'tagClass' => 'spToolsButton', 'icon' => 'sp_ForumTools.png', 'iconClass' => 'spIcon', 'hide' => 1, 'containerClass' => 'spTopicPostSection');
    $a = wp_parse_args($args, $defs);
    $a = apply_filters('sph_PostForumToolButton_args', $a);
    extract($a, EXTR_SKIP);
    # sanitize before use
    $tagId = esc_attr($tagId);
    $tagClass = esc_attr($tagClass);
    $icon = sanitize_file_name($icon);
    $iconClass = esc_attr($iconClass);
    $containerClass = esc_attr($containerClass);
    $hide = (int) $hide;
    $toolTip = esc_attr($toolTip);
    $label = sp_filter_title_display($label);
    $tagId = str_ireplace('%ID%', $spThisPost->post_id, $tagId);
    $addStyle = '';
    if ($hide) {
        $addStyle = " style='display: none;' ";
    }
    $last = $spThisPost->last_post ? 1 : 0;
    $site = SFHOMEURL . 'index.php?sp_ahah=admintoollinks&amp;sfnonce=' . wp_create_nonce('forum-ahah') . "&amp;action=posttools&amp;post={$spThisPost->post_id}&amp;page={$spThisTopic->display_page}&amp;postnum={$spThisPost->post_index}&amp;name=" . urlencode($spThisPostUser->display_name) . "&amp;forum={$spThisTopic->forum_id}&amp;last={$last}";
    $out = "<a class='{$tagClass}' id='{$tagId}' title='{$toolTip}' rel='nofollow' href='javascript:void(null)' {$addStyle} ";
    $title = esc_js(sp_text('Forum Tools'));
    $out .= "onclick='spjDialogAjax(this, \"" . $site . "\", \"" . $title . "\", 350, 0, 0);' >";
    if (!empty($icon)) {
        $out .= sp_paint_icon($iconClass, SPTHEMEICONSURL, $icon);
    }
    if (!empty($label)) {
        $out .= $label;
    }
    $out .= "</a>\n";
    $out = apply_filters('sph_PostForumToolButton', $out, $a);
    echo $out;
    # Add script to hover admin buttons - just once
    if ($spThisTopic->tools_flag && $hide) {
        ?>
		<script type='text/javascript'>
		/* <![CDATA[ */
		var sptb = {
			toolclass : '.<?php 
        echo $containerClass;
        ?>
'
		};
		/* ]]> */
		</script>
<?php 
        add_action('wp_footer', 'spjs_AddPostToolsHover');
        $spThisTopic->tools_flag = false;
    }
}

function spa_get_members_info($userid)
{
    $data = sp_get_member_row($userid);
    if (empty($data)) {
        return '';
    }
    $first = spdb_select('row', '
			SELECT ' . SFPOSTS . '.forum_id, forum_name, forum_slug, ' . SFPOSTS . '.topic_id, topic_name, topic_slug, post_date
			FROM ' . SFPOSTS . '
			JOIN ' . SFTOPICS . ' ON ' . SFTOPICS . '.topic_id = ' . SFPOSTS . '.topic_id
			JOIN ' . SFFORUMS . ' ON ' . SFFORUMS . '.forum_id = ' . SFPOSTS . '.forum_id
			WHERE ' . SFPOSTS . ".user_id={$userid}\n\t\t\tORDER BY post_date ASC\n\t\t\tLIMIT 1");
    if ($first) {
        $url = '<a href="' . sp_build_url($first->forum_slug, $first->topic_slug, 1, 0) . '">' . sp_filter_title_display($first->topic_name) . '</a>';
        $data['first'] = sp_filter_title_display($first->forum_name) . '<br />' . $url . '<br />' . sp_date('d', $first->post_date);
    } else {
        $data['first'] = spa_text('No Posts');
    }
    $last = spdb_select('row', '
			SELECT ' . SFPOSTS . '.forum_id, forum_name, forum_slug, ' . SFPOSTS . '.topic_id, topic_name, topic_slug, post_date
			FROM ' . SFPOSTS . '
			JOIN ' . SFTOPICS . ' ON ' . SFTOPICS . '.topic_id = ' . SFPOSTS . '.topic_id
			JOIN ' . SFFORUMS . ' ON ' . SFFORUMS . '.forum_id = ' . SFPOSTS . '.forum_id
			WHERE ' . SFPOSTS . ".user_id={$userid}\n\t\t\tORDER BY post_date DESC\n\t\t\tLIMIT 1");
    if ($last) {
        $url = '<a href="' . sp_build_url($last->forum_slug, $last->topic_slug, 1, 0) . '">' . sp_filter_title_display($last->topic_name) . '</a>';
        $data['last'] = sp_filter_title_display($last->forum_name) . '<br />' . $url . '<br />' . sp_date('d', $last->post_date);
    } else {
        $data['last'] = spa_text('No posts');
    }
    if ($data['admin']) {
        $user_memberships = 'Admin';
        $status = 'Admin';
        $start = 0;
    } else {
        if ($data['moderator']) {
            $status = 'Moderator';
            $start = 1;
        } else {
            $status = 'User';
            $start = 1;
        }
    }
    $memberships = spdb_table(SFMEMBERSHIPS, "user_id={$userid}", '', '', '', ARRAY_A);
    if ($memberships) {
        foreach ($memberships as $membership) {
            $name = spdb_table(SFUSERGROUPS, 'usergroup_id=' . $membership['usergroup_id'], 'usergroup_name');
            if ($start) {
                $user_memberships = $name;
                $start = 0;
            } else {
                $user_memberships .= ', ' . $name;
            }
        }
    } else {
        if ($start) {
            $user_memberships = 'No Memberships';
        }
    }
    $data['memberships'] = $user_memberships;
    $rank = sp_get_user_forum_rank($status, $userid, $data['posts']);
    $data['rank'] = $rank[0]['name'];
    $user = get_userdata($userid);
    $data['login'] = $user->user_login;
    return $data;
}

function sp_do_sp_AuthorPostsTag($args = '')
{
    #check if forum displayed
    if (sp_abort_display_forum()) {
        return;
    }
    $defs = array('tagId' => 'spAuthorPostsTag', 'tagClass' => 'spLinkTag', 'authorId' => '', 'showForum' => 1, 'showDate' => 1, 'limit' => 5, 'listTags' => 0, 'echo' => 1);
    $a = wp_parse_args($args, $defs);
    $a = apply_filters('sph_AuthorPostsTag_args', $a);
    extract($a, EXTR_SKIP);
    # sanitize before use
    $tagId = esc_attr($tagId);
    $tagClass = esc_attr($tagClass);
    $authorId = (int) $authorId;
    $showForum = (int) $showForum;
    $showDate = (int) $showDate;
    $limit = (int) $limit;
    $listTags = (int) $listTags;
    $echo = (int) $echo;
    if (empty($authorId)) {
        return;
    }
    sp_forum_api_support();
    if ($limit == 0) {
        $limit = '';
    }
    # limit to viewable forums based on permissions
    $where = SFPOSTS . '.user_id = ' . $authorId . ' AND ' . SFPOSTS . '.post_status=0 ';
    $forum_ids = sp_get_forum_memberships();
    # create where clause based on forums that current user can view
    if ($forum_ids != '') {
        $where .= "AND " . SFPOSTS . ".forum_id IN (" . implode(",", $forum_ids) . ")";
    } else {
        return '';
    }
    $spdb = new spdbComplex();
    $spdb->table = SFPOSTS;
    $spdb->distinct = true;
    $spdb->fields = SFPOSTS . '.post_id, ' . SFPOSTS . '.forum_id, ' . SFPOSTS . '.topic_id, ' . spdb_zone_datetime('post_date') . ',
							  post_index, forum_slug, forum_name, topic_slug, topic_name';
    $spdb->join = array(SFTOPICS . ' ON ' . SFPOSTS . '.topic_id = ' . SFTOPICS . '.topic_id', SFFORUMS . ' ON ' . SFPOSTS . '.forum_id = ' . SFFORUMS . '.forum_id');
    $spdb->where = $where;
    $spdb->orderby = 'post_date DESC';
    $spdb->limits = $limit;
    $sfposts = $spdb->select();
    if (!$listTags) {
        $out = "<div id='{$tagId}' class='{$tagClass}'>";
        $open = '<div>';
        $close = '</div>';
    } else {
        $out = "<ul id='{$tagId}' class='{$tagClass}'>";
        $open = '<li>';
        $close = '</li>';
    }
    if ($sfposts) {
        foreach ($sfposts as $sfpost) {
            $out .= $open;
            if ($showForum) {
                $out .= sp_filter_title_display($sfpost->forum_name) . '<br />';
            }
            $out .= '<a href="' . sp_build_url($sfpost->forum_slug, $sfpost->topic_slug, 0, $sfpost->post_id, $sfpost->post_index) . '">' . sp_filter_title_display($sfpost->topic_name) . '</a><br />' . "\n";
            if ($showDate) {
                $out .= sp_date('d', $sfpost->post_date) . '<br />';
            }
            $out .= $close;
        }
    } else {
        $out .= $open . __('No posts by this author', 'sp-ttags') . $close;
    }
    if (!$listTags) {
        $out .= '</div>';
    } else {
        $out .= '</ul>';
    }
    $out = apply_filters('sph_AuthorPostsTag', $out);
    if ($echo) {
        echo $out;
    } else {
        return $out;
    }
}

function sp_LastVisitLabel($args = '', $label = '')
{
    # should we show the last visit label?
    global $spThisUser;
    if (empty($spThisUser->lastvisit)) {
        return;
    }
    $defs = array('tagId' => 'spLastVisitLabel', 'tagClass' => 'spLabelSmall', 'echo' => 1, 'get' => 0);
    $a = wp_parse_args($args, $defs);
    $a = apply_filters('sph_LastVisitLabel_args', $a);
    extract($a, EXTR_SKIP);
    # sanitize before use
    $tagId = esc_attr($tagId);
    $tagClass = esc_attr($tagClass);
    $echo = (int) $echo;
    $get = (int) $get;
    if ($get) {
        return $spThisUser->lastvisit;
    }
    $label = sp_filter_title_display(str_replace('%LASTVISIT%', sp_date('d', $spThisUser->lastvisit), $label));
    $out = "<span id='{$tagId}' class='{$tagClass}'>{$label}</span>\n";
    $out = apply_filters('sph_LastVisitLabel', $out, $a);
    if ($echo) {
        echo $out;
    } else {
        return $out;
    }
}

function sp_ListFirstPost($args = '', $label = '')
{
    global $spThisListTopic;
    $defs = array('tagId' => 'spListFirstPost%ID%', 'tagClass' => 'spListPostLink', 'labelClass' => 'spListLabel', 'linkClass' => 'spLink', 'iconClass' => 'spIcon', 'icon' => 'sp_ArrowRight.png', 'labelLink' => 0, 'tip' => 1, 'niceDate' => 1, 'date' => 0, 'time' => 0, 'user' => 1, 'truncateUser' => 0, 'break' => 0, 'echo' => 1, 'get' => 0);
    $a = wp_parse_args($args, $defs);
    $a = apply_filters('sph_ListFirstPost_args', $a);
    extract($a, EXTR_SKIP);
    # sanitize before use
    $tagId = esc_attr($tagId);
    $tagClass = esc_attr($tagClass);
    $labelClass = esc_attr($labelClass);
    $linkClass = esc_attr($linkClass);
    $iconClass = esc_attr($iconClass);
    $labelLink = (int) $labelLink;
    $tip = (int) $tip;
    $niceDate = (int) $niceDate;
    $date = (int) $date;
    $time = (int) $time;
    $user = (int) $user;
    $truncateUser = (int) $truncateUser;
    $break = (int) $break;
    $icon = sanitize_file_name($icon);
    $echo = (int) $echo;
    $get = (int) $get;
    $tagId = str_ireplace('%ID%', $spThisListTopic->topic_id, $tagId);
    if ($tip && !empty($spThisListTopic->first_post_tip)) {
        $title = "title='{$spThisListTopic->first_post_tip}'";
        $linkClass .= '';
    } else {
        $title = '';
    }
    $sp = ' ';
    $out = "<div id='{$tagId}' class='{$tagClass}'>\n";
    if ($labelLink) {
        $out .= "<a class='{$linkClass}' {$title} href='{$spThisListTopic->first_post_permalink}'>\n";
    }
    $out .= "<span class='{$labelClass}'>" . sp_filter_title_display($label) . " \n";
    if ($labelLink) {
        $out .= "</a>\n";
    }
    # Link to post
    $out .= "<a class='{$linkClass}' {$title} href='{$spThisListTopic->first_post_permalink}'>\n";
    $out .= sp_paint_icon($iconClass, SPTHEMEICONSURL, $icon);
    $out .= "</a></span>\n";
    # user
    $poster = sp_build_name_display($spThisListTopic->first_user_id, sp_truncate($spThisListTopic->first_display_name, $truncateUser));
    if (empty($poster)) {
        $poster = sp_truncate($spThisListTopic->first_guest_name, $truncateUser);
    }
    if ($user) {
        $out .= "<span class='{$labelClass}'>{$poster}</span>\n";
    }
    if ($get) {
        $getData = new stdClass();
        $getData->permalink = $spThisListTopic->first_post_permalink;
        $getData->topic_name = $spThisListTopic->topic_name;
        $getData->post_date = $spThisListTopic->first_post_date;
        $getData->tooltip = $spThisListTopic->first_post_tip;
        $getData->user = $poster;
        return $getData;
    }
    if ($break) {
        $sp = "<br />";
    }
    # date/time
    if ($niceDate) {
        $out .= "<span class='{$labelClass}'>" . $sp . sp_nicedate($spThisListTopic->first_post_date) . "</span>\n";
    } else {
        if ($date) {
            $out .= "<span class='{$labelClass}'>" . $sp . sp_date('d', $spThisListTopic->first_post_date);
            if ($time) {
                $out .= '-' . sp_date('t', $spThisListTopic->first_post_date);
            }
            $out .= "</span>\n";
        }
    }
    $out .= "</div>\n";
    $out = apply_filters('sph_ListFirstPost', $out, $a);
    if ($echo) {
        echo $out;
    } else {
        return $out;
    }
}

function sp_render_post_tools($post, $forum, $topic, $page, $postnum, $useremail, $guestemail, $displayname, $last)
{
    global $spThisUser;
    $out = '';
    $out .= '<div id="spMainContainer" class="spForumToolsPopup">';
    $out .= '<div class="spForumToolsHeader">';
    $out .= '<div class="spForumToolsHeaderTitle">' . sp_filter_title_display($topic['topic_name']) . '</div>';
    $out .= '<div class="spForumToolsHeaderTitle">' . sp_text('Post') . ' #' . $postnum . '</div>';
    $out .= '</div>';
    $out .= sp_render_common_tools($forum, $topic, $post, $page);
    if ($post['post_status'] != 0 && sp_get_auth('moderate_posts', $forum['forum_id'])) {
        $out .= '<div class="spForumToolsModerate">';
        $out .= sp_paint_icon('spIcon', SPTHEMEICONSURL, 'sp_ToolsApprove.png');
        $out .= '<a href="javascript:document.postapprove' . $post['post_id'] . '.submit();">' . sp_text('Approve this post') . '</a>';
        $out .= '<form action="' . sp_build_url($forum['forum_slug'], $topic['topic_slug'], $page, $post['post_id'], $post['post_index']) . '" method="post" name="postapprove' . $post['post_id'] . '">';
        $out .= '<input type="hidden" name="approvepost" value="' . $post['post_id'] . '" />';
        $out .= '</form>';
        $out .= '</div>';
    }
    if ($post['post_status'] == 0 && sp_get_auth('moderate_posts', $forum['forum_id'])) {
        $out .= '<div class="spForumToolsModerate">';
        $out .= sp_paint_icon('spIcon', SPTHEMEICONSURL, 'sp_ToolsUnapprove.png');
        $out .= '<a href="javascript:document.unapprovepost' . $post['post_id'] . '.submit();">' . sp_text('Unapprove this post') . '</a>';
        $out .= '<form action="' . sp_build_url($forum['forum_slug'], $topic['topic_slug'], $page, $post['post_id'], $post['post_index']) . '" method="post" name="unapprovepost' . $post['post_id'] . '">';
        $out .= '<input type="hidden" name="unapprovepost" value="' . $post['post_id'] . '" />';
        $out .= '</form>';
        $out .= '</div>';
    }
    if (sp_get_auth('view_email', $forum['forum_id'])) {
        $email = !empty($useremail) ? $useremail : $guestemail;
        $content = '';
        if ($post['user_id']) {
            $content .= '<div>' . sp_text('User ID') . ': ' . $post['user_id'] . ' - ' . $displayname . '</div>';
        } else {
            $content .= '<div>' . sp_text('Guest') . '</div>';
        }
        $content .= '<div>' . $email . '</div><div>' . $post['poster_ip'] . '</div>';
        $out .= '<div class="spForumToolsEmail">';
        $out .= sp_paint_icon('spIcon', SPTHEMEICONSURL, 'sp_ToolsEmail.png');
        $title = sp_text("Users email and IP");
        $out .= '<a href="javascript:void(null)" onclick="spjDialogHtml(this, \'' . $content . '\', \'' . esc_js($title) . '\', 300, 0, \'center\');">' . $title . '</a>';
        $out .= '</div>';
    }
    if (sp_get_auth('pin_posts', $forum['forum_id'])) {
        $pintext = $post['post_pinned'] ? sp_text('Unpin this post') : sp_text('Pin this post');
        $out .= '<div class="spForumToolsPin">';
        $out .= sp_paint_icon('spIcon', SPTHEMEICONSURL, 'sp_ToolsPin.png');
        $ajaxUrl = SFHOMEURL . 'index.php?sp_ahah=admintools&amp;sfnonce=' . wp_create_nonce('forum-ahah') . '&amp;action=pin-post&amp;post=' . $post['post_id'];
        $out .= "<a href='javascript:void(null)' onclick='spjPinPost(\"{$ajaxUrl}\");'>{$pintext}</a>";
        $out .= '</div>';
    }
    if ($spThisUser->admin) {
        $out .= '<div class="spForumToolsOrder">';
        $out .= sp_paint_icon('spIcon', SPTHEMEICONSURL, 'sp_ToolsSort.png');
        $site = SFHOMEURL . 'index.php?sp_ahah=admintools&amp;sfnonce=' . wp_create_nonce('forum-ahah') . '&amp;action=sort-topic&amp;topicid=' . $topic['topic_id'];
        $out .= '<a href="javascript:void(null)" onclick="spjLoadTool(\'' . $site . '\', \'spMainContainer\', \'\');">' . sp_text('Reverse sort this topic') . '</a>';
        $out .= '</div>';
    }
    $edit_days = sp_get_option('editpostdays');
    $post_date = strtotime(sp_date('d', $post['post_date']));
    $date_diff = floor((time() - $post_date) / (60 * 60 * 24));
    if (sp_get_auth('edit_any_post', $forum['forum_id']) || $post['user_id'] == $spThisUser->ID && (sp_get_auth('edit_own_posts_forever', $forum['forum_id']) || sp_get_auth('edit_own_posts_reply', $forum['forum_id']) && $last || sp_get_auth('edit_own_posts_for_time', $forum['forum_id']) && $date_diff <= $edit_days)) {
        $out .= '<div class="spForumToolsEdit">';
        $out .= sp_paint_icon('spIcon', SPTHEMEICONSURL, 'sp_ToolsEdit.png');
        $out .= '<a href="javascript:document.admineditpost' . $post['post_id'] . '.submit();">' . sp_text('Edit this post') . '</a>';
        $out .= '<form action="' . sp_build_url($forum['forum_slug'], $topic['topic_slug'], $page, $post['post_id'], $post['post_index']) . '" method="post" name="admineditpost' . $post['post_id'] . '">';
        $out .= '<input type="hidden" name="postedit" value="' . $post['post_id'] . '" />';
        $out .= '</form>';
        $out .= '</div>';
    }
    if (sp_get_auth('delete_any_post', $post['forum_id']) || sp_get_auth('delete_own_posts', $forum['forum_id']) && $spThisUser->ID == $post['user_id']) {
        $out .= '<div class="spForumToolsDelete">';
        $out .= sp_paint_icon('spIcon', SPTHEMEICONSURL, 'sp_ToolsDelete.png');
        $msg = esc_js(sp_text('Are you sure you want to delete this post?'));
        $ajaxUrl = SFHOMEURL . 'index.php?sp_ahah=admintools&amp;sfnonce=' . wp_create_nonce('forum-ahah') . '&amp;action=delete-post&amp;killpost=' . $post['post_id'] . '&amp;killposttopic=' . $post['topic_id'] . '&amp;killpostforum=' . $post['forum_id'] . '&amp;killpostposter=' . $post['user_id'] . '&amp;page=' . $page;
        $out .= "<a href='javascript:void(null)' onclick='spjDeletePost(\"{$ajaxUrl}\", {$post['post_id']}, {$post['topic_id']});'>";
        $out .= sp_text('Delete this post');
        $out .= '</a>';
        $out .= '</div>';
    }
    if (sp_get_auth('move_posts', $post['forum_id'])) {
        $out .= '<div class="spForumToolsMove">';
        $out .= sp_paint_icon('spIcon', SPTHEMEICONSURL, 'sp_ToolsMove.png');
        $site = SFHOMEURL . 'index.php?sp_ahah=admintools&amp;sfnonce=' . wp_create_nonce('forum-ahah') . '&amp;action=move-post&amp;id=' . $post['topic_id'] . '&amp;pid=' . $post['post_id'] . '&amp;pix=' . $post['post_index'];
        $title = sp_text('Move this post');
        $out .= '<a rel="nofollow" href="javascript:void(null)" onclick="spjDialogAjax(this, \'' . $site . '\', \'' . esc_js($title) . '\', 400, 0, \'center\');">' . $title . '</a>';
        $out .= '</div>';
    }
    if (sp_get_auth('reassign_posts', $post['forum_id'])) {
        $out .= '<div class="spForumToolsReassign">';
        $out .= sp_paint_icon('spIcon', SPTHEMEICONSURL, 'sp_ToolsReassign.png');
        $site = SFHOMEURL . 'index.php?sp_ahah=admintools&amp;sfnonce=' . wp_create_nonce('forum-ahah') . '&amp;action=reassign&amp;id=' . $post['topic_id'] . '&amp;pid=' . $post['post_id'] . '&amp;uid=' . $post['user_id'];
        $title = sp_text('Reassign This Post');
        $out .= '<a rel="nofollow" href="javascript:void(null)" onclick="spjDialogAjax(this, \'' . $site . '\', \'' . esc_js($title) . '\', 400, 0, \'center\');">' . $title . '</a>';
        $out .= '</div>';
    }
    if ($spThisUser->admin || $spThisUser->moderator) {
        $out .= '<div class="spForumToolsNofity">';
        $out .= sp_paint_icon('spIcon', SPTHEMEICONSURL, 'sp_ToolsNotify.png');
        $site = SFHOMEURL . 'index.php?sp_ahah=admintools&amp;sfnonce=' . wp_create_nonce('forum-ahah') . '&amp;action=notify&amp;pid=' . $post['post_id'];
//.........这里部分代码省略.........

function sp_ListSearchUserDate($args = '')
{
    global $spThisPostList;
    $defs = array('tagId' => 'spListPostUserDate%ID%', 'tagClass' => 'spPostUserDate', 'nicedate' => 0, 'date' => 1, 'time' => 1, 'stackdate' => 0, 'echo' => 1, 'get' => 0);
    $a = wp_parse_args($args, $defs);
    $a = apply_filters('sph_ListSearchUserDate_args', $a);
    extract($a, EXTR_SKIP);
    # sanitize before use
    $tagId = esc_attr($tagId);
    $tagClass = esc_attr($tagClass);
    $nicedate = (int) $nicedate;
    $date = (int) $date;
    $time = (int) $time;
    $stackdate = (int) $stackdate;
    $echo = (int) $echo;
    $get = (int) $get;
    $dlb = $stackdate ? '<br />' : ' ';
    $tagId = str_ireplace('%ID%', $spThisPostList->post_id, $tagId);
    if ($get) {
        return $spThisPostList->post_date;
    }
    $out = "<div id='{$tagId}' class='{$tagClass}'>";
    # date/time
    if ($nicedate) {
        $out .= sp_nicedate($spThisPostList->post_date);
    } else {
        if ($date) {
            $out .= sp_date('d', $spThisPostList->post_date);
            if ($time) {
                $out .= $dlb . sp_date('t', $spThisPostList->post_date);
            }
        }
    }
    $out .= "</div>\n";
    $out = apply_filters('sph_ListSearchUserDate', $out, $a);
    if ($echo) {
        echo $out;
    } else {
        return $out;
    }
}

function sp_ForumIndexLastPost($args = '', $lastPostLabel = '', $noTopicsLabel = '')
{
    global $spThisForum;
    $defs = array('tagId' => 'spForumIndexLastPost%ID%', 'tagClass' => 'spInRowPostLink', 'labelClass' => 'spInRowLabel', 'infoClass' => 'spInRowInfo', 'linkClass' => 'spInRowLastPostLink', 'includeSubs' => 1, 'tip' => 1, 'order' => 'UTD', 'nicedate' => 1, 'date' => 0, 'time' => 0, 'stackdate' => 0, 'user' => 1, 'truncate' => 0, 'truncateUser' => 0, 'itemBreak' => '<br />', 'echo' => 1, 'get' => 0);
    $a = wp_parse_args($args, $defs);
    $a = apply_filters('sph_ForumIndexLastPost_args', $a);
    extract($a, EXTR_SKIP);
    # sanitize before use
    $tagId = esc_attr($tagId);
    $tagClass = esc_attr($tagClass);
    $labelClass = esc_attr($labelClass);
    $infoClass = esc_attr($infoClass);
    $linkClass = esc_attr($linkClass);
    $includeSubs = (int) $includeSubs;
    $tip = (int) $tip;
    $order = esc_attr($order);
    $nicedate = (int) $nicedate;
    $date = (int) $date;
    $time = (int) $time;
    $stackdate = (int) $stackdate;
    $user = (int) $user;
    $truncate = (int) $truncate;
    $truncateUser = (int) $truncateUser;
    $echo = (int) $echo;
    $get = (int) $get;
    if ($includeSubs && $spThisForum->forum_id_sub == 0) {
        $includeSubs = 0;
    }
    $postCount = $includeSubs ? $spThisForum->post_count_sub : $spThisForum->post_count;
    if ($postCount) {
        $tagId = str_ireplace('%ID%', $spThisForum->forum_id, $tagId);
        $posttip = $includeSubs ? $spThisForum->post_tip_sub : $spThisForum->post_tip;
        if ($tip && !empty($posttip)) {
            $title = "title='{$posttip}'";
            $linkClass .= ' vtip';
        } else {
            $title = '';
        }
        $stackdate ? $dlb = '<br />' : ($dlb = ' - ');
        # user
        $poster = $includeSubs ? sp_build_name_display($spThisForum->user_id_sub, sp_truncate($spThisForum->display_name_sub, $truncateUser)) : sp_build_name_display($spThisForum->user_id, sp_truncate($spThisForum->display_name, $truncateUser));
        if (empty($poster)) {
            $poster = $includeSubs ? sp_truncate($spThisForum->guest_name_sub, $truncateUser) : sp_truncate($spThisForum->guest_name, $truncateUser);
        }
        # other items
        $permalink = $includeSubs ? $spThisForum->post_permalink_sub : $spThisForum->post_permalink;
        $topicname = $includeSubs ? sp_truncate($spThisForum->topic_name_sub, $truncate) : sp_truncate($spThisForum->topic_name, $truncate);
        $postdate = $includeSubs ? $spThisForum->post_date_sub : $spThisForum->post_date;
        if ($get) {
            $getData = new stdClass();
            $getData->permalink = $permalink;
            $getData->topic_name = $topicname;
            $getData->post_date = $postdate;
            $getData->user = $poster;
            return $getData;
        }
        $U = $poster;
        $T = "<a class='{$linkClass}' {$title} href='{$permalink}'>{$topicname}</a>";
        if ($nicedate) {
            $D = sp_nicedate($postdate);
        } else {
            if ($date) {
                $D = sp_date('d', $postdate);
                if ($time) {
                    $D .= $dlb . sp_date('t', $postdate);
                }
            }
        }
    } else {
        if ($get) {
            $getData = new stdClass();
            return $getData;
        }
    }
    $out = "<div id='{$tagId}' class='{$tagClass}'>\n";
    if ($postCount) {
        $out .= "<span class='{$labelClass}'>" . sp_filter_title_display($lastPostLabel) . " \n";
        for ($x = 0; $x < strlen($order); $x++) {
            $i = substr($order, $x, 1);
            switch ($i) {
                case 'U':
                    if ($user) {
                        if ($x != 0) {
                            $out .= "<span class='{$labelClass}'>";
                        }
                        $out .= $U . "</span>\n";
                    }
                    if ($x != strlen($order) - 1) {
                        if (substr($order, $x + 1, 1) != 'L') {
                            $out .= "<span class='{$labelClass}'>{$itemBreak}</span>";
                        }
                    }
                    break;
                case 'T':
                    if ($x == 0) {
                        $out .= $itemBreak . "</span>";
                    }
                    $out .= "<span class='{$linkClass}'>";
                    $out .= $T . "</span>\n";
                    if ($x != strlen($order) - 1) {
//.........这里部分代码省略.........

function sp_save_edited_post()
{
    global $spThisUser, $spVars, $spGlobals;
    # post id of edited post
    $newpost = array();
    $newpost['postid'] = sp_esc_int($_POST['pid']);
    # no post editng if guest, in post edit mode or lockdwon
    if ($spVars['displaymode'] == 'edit' && $spVars['postedit'] == $newpost['postid']) {
        return;
    }
    if ($spGlobals['lockdown']) {
        return;
    }
    # data for the post - want to ensure absolute forum id plus used for notifications later
    $post = spdb_table(SFPOSTS, "post_id={$newpost['postid']}", 'row');
    $topic = spdb_table(SFTOPICS, "topic_id={$post->topic_id}", 'row');
    # verify we can edit this post
    $canEdit = false;
    if (sp_get_auth('edit_any_post', $post->forum_id)) {
        $canEdit = true;
    } else {
        if ($post->user_id == $spThisUser->ID) {
            $last_post = $newpost['postid'] == $topic->post_id || $post->post_status == 1 && $newpost['postid'] == $topic->post_id_held;
            $edit_days = sp_get_option('editpostdays');
            $post_date = strtotime(sp_date('d', $post->post_date));
            $date_diff = floor((time() - $post_date) / (60 * 60 * 24));
            if (sp_get_auth('edit_own_posts_forever', $post->forum_id) || sp_get_auth('edit_own_posts_reply', $post->forum_id) && $last_post || sp_get_auth('edit_own_posts_for_time', $post->forum_id) && $date_diff <= $edit_days) {
                $canEdit = true;
            }
        }
    }
    if (!$canEdit) {
        sp_notify(SPFAILURE, sp_text('Edit failed - you do not have permission'));
        return;
    }
    # post info
    $newpost['postcontent'] = $_POST['postitem'];
    $newpost['postcontent'] = sp_filter_content_save($newpost['postcontent'], 'edit', true, SFPOSTS, 'post_content');
    $newpost['forumid'] = sp_esc_int($_POST['forumid']);
    $newpost['forumslug'] = sp_esc_str($_POST['forumslug']);
    $newpost['topicid'] = sp_esc_int($_POST['topicid']);
    $newpostt['topicslug'] = sp_esc_str($_POST['topicslug']);
    # post edit array
    $history = spdb_select('var', 'SELECT post_edit FROM ' . SFPOSTS . " WHERE post_id='{$newpost['postid']}'", ARRAY_A);
    $postedits = !empty($history) ? unserialize($history) : array();
    $x = count($postedits);
    $edittime = current_time('mysql');
    $postedits[$x]['by'] = sp_filter_name_save($spThisUser->display_name);
    $postedits[$x]['at'] = strtotime($edittime);
    $newpost['postedits'] = serialize($postedits);
    $newpost['postcontent'] = apply_filters('sph_post_edit_data', $newpost['postcontent'], $newpost['postid'], $spThisUser->ID);
    $date_update = '';
    if (!empty($_POST['editTimestamp'])) {
        $yy = sp_esc_int($_POST['tsYear']);
        $mm = sp_esc_int($_POST['tsMonth']);
        $dd = sp_esc_int($_POST['tsDay']);
        $hh = sp_esc_int($_POST['tsHour']);
        $mn = sp_esc_int($_POST['tsMinute']);
        $ss = sp_esc_int($_POST['tsSecond']);
        $dd = $dd > 31 ? 31 : $dd;
        $hh = $hh > 23 ? $hh - 24 : $hh;
        $mn = $mn > 59 ? $mn - 60 : $mn;
        $ss = $ss > 59 ? $ss - 60 : $ss;
        $newpost['postdate'] = sprintf('%04d-%02d-%02d %02d:%02d:%02d', $yy, $mm, $dd, $hh, $mn, $ss);
        $date_update = ', post_date = "' . $newpost['postdate'] . '"';
    }
    $sql = 'UPDATE ' . SFPOSTS . " SET post_content='{$newpost['postcontent']}', post_edit='{$newpost['postedits']}'{$date_update} WHERE post_id={$newpost['postid']}";
    if (spdb_query($sql) == false) {
        sp_notify(SPFAILURE, sp_text('Update failed'));
    } else {
        sp_notify(SPSUCCESS, sp_text('Updated post saved'));
        # set up some data for notifications
        $link = sp_permalink_from_postid($newpost['postid']);
        # notify admins/mods of edit
        $users = spdb_select('set', 'SELECT user_id, admin_options FROM ' . SFMEMBERS . " WHERE admin=1 OR moderator=1");
        if ($users) {
            $time = time() + 7 * 24 * 60 * 60;
            $text = sp_text('A user has edited the post');
            foreach ($users as $user) {
                $options = unserialize($user->admin_options);
                if ($options['notify-edited'] && $spThisUser->ID != $user->user_id) {
                    # dont notify self
                    $nData = array();
                    $nData['user_id'] = $user->user_id;
                    $nData['guest_email'] = '';
                    $nData['post_id'] = $newpost['postid'];
                    $nData['link'] = $link;
                    $nData['link_text'] = $topic->topic_name;
                    $nData['message'] = $text;
                    $nData['expires'] = $time;
                    # 7 days; 24 hours; 60 mins; 60secs
                    sp_add_notice($nData);
                }
            }
        }
        # notify author of change
        $sfadminsettings = sp_get_option('sfadminsettings');
        if ($sfadminsettings['editnotice'] && $spThisUser->ID != $post->user_id) {
            $nData = array();
            $nData['user_id'] = $post->user_id;
//.........这里部分代码省略.........