$title .= '班级活动';
$s_a_dbc = sprintf('select a.*, b.name from %s as a, %s as b where a.aid=b.id and a.disp=0 order by a.closed, a.sticky desc, a.datetime desc', $dbprefix . 'camp', $dbprefix . 'member');
$q_a_dbc = mysql_query($s_a_dbc) or die('');
$c_dbc = mysql_num_rows($q_a_dbc);
if ($c_dbc > 0) {
$p_dbc = ceil($c_dbc / $config['pagesize']);
if ($page > $p_dbc) {
$page = $p_dbc;
}
$s_dbc = sprintf('%s limit %d, %d', $s_a_dbc, ($page - 1) * $config['pagesize'], $config['pagesize']);
$q_dbc = mysql_query($s_dbc) or die('');
$r_dbc = mysql_fetch_assoc($q_dbc);
do {
$ca[$r_dbc['id']][] = '发起人：<a href="?m=user&id=' . $r_dbc['aid'] . '">' . $r_dbc['name'] . '</a>, ' . ($r_dbc['closed'] > 0 ? '已结束' : getldate($r_dbc['datetime']));
if ($r_dbc['content'] != '') {
$ca[$r_dbc['id']][] = gbookencode($r_dbc['content']) . '<br/>';
}
if ($r_dbc['closed'] == 0) {
if ($r_dbc['cdate'] != '') {
$ca[$r_dbc['id']][] = '<strong>活动时间：</strong>' . $r_dbc['cdate'];
}
if ($r_dbc['cloc'] != '') {
$ca[$r_dbc['id']][] = '<strong>活动地点：</strong>' . $r_dbc['cloc'];
}
if ($r_dbc['cpay'] != '') {
$ca[$r_dbc['id']][] = '<strong>活动费用：</strong>' . $r_dbc['cpay'];
}
$s_dbu = sprintf('select sum(tid) as ctid from %s where cid=%s', $dbprefix . 'cuser', $r_dbc['id']);
$q_dbu = mysql_query($s_dbu) or die('');
$r_dbu = mysql_fetch_assoc($q_dbu);
if (mysql_num_rows($q_dbu) > 0 && $r_dbu['ctid'] > 0) {
do {
if (isset($_GET['did']) && $_GET['did'] == $r_dba['id']) {
$d_db = sprintf('delete from %s where id=%s', $dbprefix . 'adminop', $r_dba['id']);
$result = mysql_query($d_db) or die('');
header('Location:./?m=setting&t=adminop');
exit;
} else {
$content .= '<li class="l_list"><a href="?m=user&id=' . $r_dba['aid'] . '"><img src="avator.php?id=' . $r_dba['aid'] . '" alt="" title="' . $r_dba['name'] . '" class="photo" width="55" height="55"/></a><div class="list_r"><div class="list_title"><span class="gmod"><img src="images/o_2.gif" alt="" title="删除" name="del" data-id="' . $r_dba['id'] . '" class="f_link"/></span>' . getalink($r_dba['aid'], $r_dba['name']) . ' <span class="gdate">' . getldate($r_dba['datetime']) . '</span></div><div class="list_c">';
switch ($r_dba['tid']) {
case 1:
$pr = getpinfo($r_dba['sid']);
$content .= '<a href="?m=album&id=' . $r_dba['sid'] . '"><img src="' . getthu($pr) . '" alt="" title="' . $pr['title'] . '" width="70" height="70" class="al_t"/></a><br/>';
break;
case 2:
$pr = getcinfo($r_dba['sid'], 'title');
$content .= '<a href="?m=camp&id=' . $r_dba['sid'] . '">' . $pr['title'] . '</a><br/><br/>';
break;
}
$content .= gbookencode($r_dba['content']) . '</div></div></li>';
}
} while ($r_dba = mysql_fetch_assoc($q_dba));
mysql_free_result($q_dba);
$content .= '</ul>';
if ($p_dba > 1) {
$content .= getpage($page, $p_dba);
}
} else {
$content .= '<li><div class="title">管理记录</div><div class="lcontent">没有记录</div></li></ul>';
}
mysql_free_result($q_a_dba);
}
$tb_i = trim($t_u);
unset($a_u[$l_u]);
}
$u = join('[/]', $a_u);
}
}
if ($pr['vid'] > 0) {
$content .= '<img src="' . getthu($pr) . '" width="70" height="70" class="f_link video_slink al_t" alt="" title="观看视频" data-id="' . $r_dbl['id'] . '"/><div id="video_div_' . $r_dbl['id'] . '"></div><textarea id="video_text_' . $r_dbl['id'] . '" style="display: none;">' . htmlspecialchars($u, ENT_QUOTES) . '</textarea><a href="?m=album&id=' . $r_dbl['sid'] . '">' . ($pr['title'] != '' ? $pr['title'] : '视频 #' . $pr['id']) . '</a>';
} else {
$content .= '<img src="' . getthu($pr) . '" alt="" title="点击查看原图" width="70" height="70" class="f_link img_lb al_t" data-img="' . ($config['slink'] > 0 || $pr['upload'] == 0 ? ($pr['upload'] > 0 ? 'file/' : '') . $u : 'img.php?id=' . $pr['id']) . '"/><br/><a href="?m=album&id=' . $r_dbl['sid'] . '">' . ($pr['title'] != '' ? $pr['title'] : '照片 #' . $pr['id']) . '</a>';
}
break;
case 3:
$pr = getcinfo($r_dbl['sid'], 'content, closed, cdate, cloc, cpay, title');
if ($pr['content'] != '') {
$ca[$r_dbl['id']][] = gbookencode($pr['content']);
}
if ($pr['closed'] == 0) {
if ($pr['cdate'] != '') {
$ca[$r_dbl['id']][] = '<strong>活动时间：</strong>' . $pr['cdate'];
}
if ($pr['cloc'] != '') {
$ca[$r_dbl['id']][] = '<strong>活动地点：</strong>' . $pr['cloc'] . ' <span class="mlink f_link img_lb" data-img="http://api.map.baidu.com/staticimage?center=' . urlencode($pr['cloc']) . '&zoom=16&markers=' . urlencode($pr['cloc']) . '">查看地图</span>';
}
if ($pr['cpay'] != '') {
$ca[$r_dbl['id']][] = '<strong>活动费用：</strong>' . $pr['cpay'];
}
$s_dbu = sprintf('select sum(tid) as ctid from %s where cid=%s', $dbprefix . 'cuser', $r_dbl['sid']);
$q_dbu = mysql_query($s_dbu) or die('');
$r_dbu = mysql_fetch_assoc($q_dbu);
if (mysql_num_rows($q_dbu) > 0 && $r_dbu['ctid'] > 0) {
$ucontent = gbookencode($r_dbr['content'], 1);
$ucontent = strip_tags($ucontent);
if ($ucontent != '') {
$a[] = array($ucontent, $r_dbr['sync_p'], $r_dbr['id'], 'pcomment');
}
} while ($r_dbr = mysql_fetch_assoc($q_dbr));
}
mysql_free_result($q_dbr);
}
if (!isset($a)) {
$s_dbr = sprintf('select id, content, sync_p from %s where aid=%s and length(sync_p)>0', $dbprefix . 'ccomment', $_SESSION[$config['u_hash']]);
$q_dbr = mysql_query($s_dbr) or die('');
$r_dbr = mysql_fetch_assoc($q_dbr);
if (mysql_num_rows($q_dbr) > 0) {
do {
$ucontent = gbookencode($r_dbr['content'], 1);
$ucontent = strip_tags($ucontent);
if ($ucontent != '') {
$a[] = array($ucontent, $r_dbr['sync_p'], $r_dbr['id'], 'ccomment');
}
} while ($r_dbr = mysql_fetch_assoc($q_dbr));
}
mysql_free_result($q_dbr);
}
if (isset($a)) {
$aid = $_SESSION[$config['u_hash']];
$u_db = sprintf('update %s set sync_p=%s where id=%s', $dbprefix . $a[0][3], SQLString('', 'text'), $a[0][2]);
$result = mysql_query($u_db) or die('');
$am = explode('|', $a[0][1]);
if ($config['is_sina'] > 0 && $config['sina_key'] != '' && $config['sina_se'] != '' && in_array('sina', $am)) {
$s_dby = sprintf('select s_t from %s where aid=%s and name=%s limit 1', $dbprefix . 'm_sync', $aid, SQLString('sina', 'text'));
function getaco($c, $i, $r = 0)
{
$m = 200;
return ($r > 0 && strstr($c, "\r") ? '<br/>' : '') . (strlen($c) > $m ? '<span id="k_' . $i . '">' . gbookencode(substrs($c, $m - 5)) . '<br/><span name="alllink" data-id="' . $i . '" class="mlink f_link">查看全部 >></span></span><span id="s_' . $i . '" style="display: none;">' : '') . gbookencode($c) . (strlen($c) > $m ? '</span>' : '');
}
$q_a_dbg = mysql_query($s_a_dbg) or die('');
$c_dbg = mysql_num_rows($q_a_dbg);
if ($c_dbg > 0) {
$p_dbg = ceil($c_dbg / $config['pagesize']);
if ($page > $p_dbg) {
$page = $p_dbg;
}
$s_dbg = sprintf('%s limit %d, %d', $s_a_dbg, ($page - 1) * $config['pagesize'], $config['pagesize']);
$q_dbg = mysql_query($s_dbg) or die('');
$r_dbg = mysql_fetch_assoc($q_dbg);
$js_c .= '
$("img[name=\'del_img\']").click(function(){
if(confirm(\'确认要删除？\'))location.href=\'?m=message&did=\'+$(this).data(\'id\');
});';
do {
$content .= '<li class="l_list"><a href="?m=user&id=' . $r_dbg['aid'] . '"><img src="avator.php?id=' . $r_dbg['aid'] . '" alt="" title="' . $r_dbg['name'] . '" class="photo" width="55" height="55"/></a><div class="list_r"><div class="list_title"><span class="gmod"><img src="images/o_2.gif" alt="" title="删除" name="del_img" data-id="' . $r_dbg['id'] . '" class="f_link"/></span><a href="?m=message&id=' . $r_dbg['aid'] . '#m' . $r_dbg['id'] . '">' . $r_dbg['name'] . ' 致 我</a>' . ($r_dbg['readed'] > 0 ? ' <img src="images/new.gif" alt="" title="新消息"/>' : '') . ' <span class="gdate">' . getldate($r_dbg['datetime']) . '</span></div><div class="list_c">' . gbookencode($r_dbg['content']) . '</div></div></li>';
if ($r_dbg['readed'] > 0) {
$u_db = sprintf('update %s set readed=0 where id=%s', $dbprefix . 'message', $r_dbg['id']);
$result = mysql_query($u_db) or die('');
}
} while ($r_dbg = mysql_fetch_assoc($q_dbg));
mysql_free_result($q_dbg);
$content .= '</ul>';
if ($p_dbg > 1) {
$content .= getpage($page, $p_dbg);
}
} else {
$content .= '<li><div class="gcontent">没有短消息</div></li></ul>';
}
mysql_free_result($q_a_dbg);
}
if ($c_log) {
$cr = getuinfo($r_dbu, 1);
$content .= $cr . ($cr != '' ? '<br/>' : '');
if ($r_dbu['jaid'] > 0) {
$jadb = getainfo($r_dbu['jaid'], 'name');
$content .= '邀请人：<a href="?m=user&id=' . $jadb['id'] . '">' . $jadb['name'] . '</a><br/>';
}
}
$content .= '最后访问：' . ($r_dbu['visitdate'] > 0 ? date('Y-n-j H:i', $r_dbu['visitdate']) : '从未') . (isset($l_ip) ? '<br/>最后IP：' . ($config['ip'] != '' ? str_replace('[ip]', $l_ip, $config['ip']) : $l_ip) : '') . ($r_dbu['visit'] > 0 ? '<br/>访问次数：' . $r_dbu['visit'] : '') . (isset($a_sync_i) ? '<br/>' . join(' ', $a_sync_i) . '<br/><br/>' : '') . (isset($a_sync_v) ? join('', $a_sync_v) : '') . '</div></div>';
$s_dbt = sprintf('select content, datetime from %s where aid=%s and disp=0 and tid=0 and mid=0 order by datetime desc limit 5', $dbprefix . 'topic', $r_dbu['id']);
$q_dbt = mysql_query($s_dbt) or die('');
$r_dbt = mysql_fetch_assoc($q_dbt);
if (mysql_num_rows($q_dbt) > 0) {
$content .= '<br/><div class="title">最近留言</div><br/><ul class="clist">';
do {
$content .= '<li class="l_list"><img src="avator.php?id=' . $r_dbu['id'] . '" alt="" title="' . $r_dbu['name'] . '" class="photo" width="55" height="55"/><div class="list_r"><div class="list_title"><span class="gdate">' . getldate($r_dbt['datetime']) . '</span></div><div class="list_c">' . gbookencode($r_dbt['content']) . '</div></div></li>';
} while ($r_dbt = mysql_fetch_assoc($q_dbt));
$content .= '</ul>';
}
mysql_free_result($q_dbt);
$s_dbp = sprintf('select id, title, url, vid, upload, disp from %s where aid=%s and disp=0 order by datetime desc limit 10', $dbprefix . 'photo', $r_dbu['id']);
$q_dbp = mysql_query($s_dbp) or die('');
$r_dbp = mysql_fetch_assoc($q_dbp);
if (mysql_num_rows($q_dbp) > 0) {
$content .= '<br/><div class="title">最近照片视频</div><div class="gcontent">';
do {
$content .= '<div class="al_list"><a href="?m=album&id=' . $r_dbp['id'] . '"><img src="' . getthu($r_dbp) . '" width="70" height="70" class="' . ($r_dbp['disp'] > 0 ? 'del_' : '') . 'al_t" alt="" title="' . ($r_dbp['vid'] > 0 ? '[视频]' : '') . ($r_dbp['title'] != '' ? $r_dbp['title'] : '') . '"/></a></div>';
} while ($r_dbp = mysql_fetch_assoc($q_dbp));
$content .= '<div class="extr"></div><a href="?m=album&user='******'id'] . '">查看全部…</a></div>';
}
mysql_free_result($q_dbp);
mysql_free_result($q_dbu);
echo '<div class="chat_list chat_t_0">' . gbookencode($c) . '<div>' . date('H:i', getftime()) . '</div></div>';
}
break;
case 1:
$lid = isset($_GET['l']) && intval($_GET['l']) > 0 ? intval($_GET['l']) : 0;
$tid = isset($_GET['t']) && intval($_GET['t']) > 0 ? $_GET['t'] : time();
$ldb = $lid > 0 ? 'id>' . $lid : 'datetime>' . $tid;
$s_dbg = sprintf('select id, content, datetime from %s where tid=%s and aid=%s and (readed=1 or %s) order by datetime', $dbprefix . 'message', $_SESSION[$config['u_hash']], $i, $ldb);
$q_dbg = mysql_query($s_dbg) or die('');
$r_dbg = mysql_fetch_assoc($q_dbg);
if (mysql_num_rows($q_dbg) > 0) {
do {
$tn = getftime($r_dbg['datetime']);
$tc = getftime();
echo '<div class="chat_list chat_t_1">' . gbookencode($r_dbg['content']) . '<input type="hidden" name="chat_lid_' . $i . '" value="' . $r_dbg['id'] . '"/><div>' . (date('Ymd', $tn) != date('Ymd', $tc) ? date('Y-n-j', $tn) . ' ' : '') . date('H:i', $tn) . '</div></div>';
$u_db = sprintf('update %s set readed=0 where id=%s', $dbprefix . 'message', $r_dbg['id']);
$result = mysql_query($u_db) or die('');
} while ($r_dbg = mysql_fetch_assoc($q_dbg));
}
mysql_free_result($q_dbg);
break;
default:
$s_dbg = sprintf('select a.aid, b.name from %s as a, %s as b where a.tid=%s and a.aid=b.id and a.readed=1 order by a.datetime desc', $dbprefix . 'message', $dbprefix . 'member', $_SESSION[$config['u_hash']]);
$q_dbg = mysql_query($s_dbg) or die('');
$r_dbg = mysql_fetch_assoc($q_dbg);
if (mysql_num_rows($q_dbg) > 0) {
do {
$a_mid[$r_dbg['aid']] = $r_dbg['aid'];
$a_name[$r_dbg['aid']] = $r_dbg['name'];
} while ($r_dbg = mysql_fetch_assoc($q_dbg));
