$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));