PHP sc_tag_member Exemples

Exemple #1

Fichier : chat.php Projet : secret715/Secret-Center

$includepath = true;
require_once '../../Connections/SQL.php';
require_once '../../config.php';
$_SESSION_scratch = $_SESSION;
session_write_close();
if (!isset($_SESSION_scratch['Center_Username'])) {
    exit;
}
if (isset($_GET['sent'])) {
    if (isset($_POST['content']) && trim($_POST['content']) != '') {
        $_chat = sc_get_result("SELECT * FROM `chat` ORDER BY `mktime` ASC");
        if ($_chat['num_rows'] > 50) {
            $SQL->query("TRUNCATE TABLE `chat`");
        }
        $SQL->query("INSERT INTO `chat` (`content`, `mktime`, `author`) VALUES ('%s', now(), '%s')", array(htmlspecialchars($_POST['content']), $_SESSION_scratch['Center_Id']));
        sc_tag_member(htmlspecialchars($_POST['content']), rtrim(sc_get_headurl(), 'include/ajax') . '/chat.php', $_SESSION_scratch['Center_Username'] . '在聊天室提到你', $_SESSION_scratch['Center_Id']);
        header("Content-type: application/json");
        echo json_encode(array("success" => true));
    }
} elseif (isset($_POST['last'])) {
    $_last = intval($_POST['last']);
    $_timeout = 20;
    $i = 0;
    while ($i < $_timeout) {
        $_result = sc_get_result("SELECT * FROM `chat` WHERE `mktime` > '%s'", array(date('Y-m-d H:i:s', $_last)));
        $_data = array();
        $_data['last'] = time();
        if ($_result['num_rows'] > 0) {
            do {
                $_member = $SQL->query("SELECT `username` FROM `member` WHERE `id` = '%d'", array($_result['row']['author']))->fetch_assoc();
                $t = strtotime($_result['row']['mktime']);

Exemple #2

Fichier : forumview.php Projet : secret715/Secret-Center

if ($_post['num_rows'] <= 0) {
    header("Location: forum.php");
    exit;
}
if (isset($_GET['reply'])) {
    if ($_SESSION['Center_UserGroup'] == 0) {
        header("Location: forumview.php?banned&id=" . $_GET['id']);
        exit;
    }
}
if (isset($_GET['reply']) && isset($_POST['content']) && trim($_POST['content'], "&nbsp;") != '') {
    $SQL->query("INSERT INTO `forum_reply` ( `post_id`,`content`, `mktime`, `author`) VALUES ('%s','%s',now(),'%d')", array($_post['row']['id'], sc_xss_filter($_POST['content']), $_SESSION['Center_Id']));
    if ($_SESSION['Center_Id'] != $_post['row']['author']) {
        sc_add_notice(sc_get_headurl() . 'forumview.php?id=' . $_post['row']['id'], $_SESSION['Center_Username'] . '在您的帖子中發表回覆', $_SESSION['Center_Id'], $_post['row']['author']);
    }
    sc_tag_member(sc_xss_filter($_POST['content']), sc_get_headurl() . 'forumview.php?id=' . $_post['row']['id'], $_SESSION['Center_Username'] . '在論壇提到你', $_SESSION['Center_Id']);
    header("Location: forumview.php?replying&id=" . $_GET['id']);
}
$_block = sc_get_result("SELECT * FROM `forum_block` WHERE `id`='%d'", array($_post['row']['block']));
$limit_row = $center['forum']['limit'];
if (isset($_GET['page'])) {
    $limit_start = abs(intval(($_GET['page'] - 1) * $limit_row));
    $_reply = sc_get_result("SELECT * FROM `forum_reply` WHERE `post_id`='%d' ORDER BY `mktime` ASC LIMIT %d,%d", array($_post['row']['id'], $limit_start, $limit_row));
} else {
    $limit_start = 0;
    $_reply = sc_get_result("SELECT * FROM `forum_reply` WHERE `post_id`='%d' ORDER BY `mktime` ASC LIMIT %d,%d", array($_post['row']['id'], $limit_start, $limit_row));
}
$_author = sc_get_result("SELECT `username` FROM `member` WHERE `id` = '%d'", array($_post['row']['author']));
$view = new View('include/theme/default.html', 'include/nav.php', NULL, $center['site_name'], $_post['row']['title']);
$view->addScript("include/js/notice.js");
if (isset($_GET['replying'])) {