function yjl_user_gz() { global $user_id, $cuid, $uadb, $yjl_dbprefix, $dbprefix; $q_res = sprintf('select b.uid, b.face, c.nc from %s as a, %s as b, %s as c where a.uid=%s and a.buddyid=b.uid and b.uid=c.uid order by a.dateline desc limit 6', $dbprefix . 'buddys', $dbprefix . 'members', $yjl_dbprefix . 'members', $cuid); $res = mysql_query($q_res) or die(''); $r_res = mysql_fetch_assoc($res); if (mysql_num_rows($res) > 0) { $c = '<div class="box2"> <h3>' . ($user_id == $cuid ? '我' : 'TA') . '关注的人</h3> <ul class="friend clearfix">'; do { $c .= '<li><a href="user-' . $r_res['uid'] . '.html" title="' . $r_res['nc'] . '"><img src="' . yjl_face($r_res['uid'], $r_res['face']) . '" /><br />' . ($r_res['nc'] != '' ? yjl_substrs($r_res['nc'], 4) : ' ') . '</a></li>'; } while ($r_res = mysql_fetch_assoc($res)); $c .= '</ul></div>'; return $c; } mysql_free_result($res); }
if (isset($xqdb) && $xqid == $r_rep['xqid']) { $xqname[$r_rep['xqid']] = $xqdb['name']; } else { $q_res = sprintf('select name from %s where xqid=%s and iskf=1 limit 1', $yjl_dbprefix . 'xq', $r_rep['xqid']); $res = mysql_query($q_res) or die(''); $r_res = mysql_fetch_assoc($res); if (mysql_num_rows($res) > 0) { $xqname[$r_rep['xqid']] = $r_res['name']; } mysql_free_result($res); } } $xqn = $r_rep['xqid'] > 0 ? $xqname[$r_rep['xqid']] : ''; $c .= '<li><div class="flt_lt"> <div class="pic_text clearfix"> <a href="user-' . $r_rep['uid'] . '.html"><img src="' . yjl_face($r_rep['uid'], $r_rep['face']) . '" /></a> <p class="memb"><a href="user-' . $r_rep['uid'] . '.html">' . $r_rep['nc'] . '</a></p>'; if (isset($a_tsgz[$r_rep['qx']])) { $c .= '<p class="memb">' . $a_tsgz[$r_rep['qx']][$r_rep['gzfl']] . '</p>'; } $c .= '<p>' . $xqn . '</p> </div> </div>'; $c .= '<div class="flt_rt" id="gz_' . $r_rep['uid'] . '">'; if ($user_id > 0 && $user_id == $cuid) { if (isset($a_fz)) { $ufzid = 0; if ($fzid > 0) { $ufzid = $fzid; } else { $q_res = sprintf('select fzid from %s where zuid=%s and uid=%s limit 1', $yjl_dbprefix . 'ffz_f', $user_id, $r_rep['uid']);
if (!isset($a_xqname[$uadb[$r_rep['uid']]['xqid']])) { if ($uadb[$r_rep['uid']]['xqid'] == $xqid && $xqid > 0) { $a_xqname[$uadb[$r_rep['uid']]['xqid']] = $xqdb['name']; } else { $q_reu = sprintf('select name from %s where xqid=%s limit 1', $yjl_dbprefix . 'xq', $uadb[$r_rep['uid']]['xqid']); $reu = mysql_query($q_reu) or die(''); $r_reu = mysql_fetch_assoc($reu); if (mysql_num_rows($reu) > 0) { $a_xqname[$uadb[$r_rep['uid']]['xqid']] = $r_reu['name']; } mysql_free_result($reu); } } $xqname = $a_xqname[$uadb[$r_rep['uid']]['xqid']]; } $c .= '<div style="border-bottom: 1px dotted #eee;padding-top: 10px;padding-bottom: 10px;" id="shu_' . $r_rep['huid'] . '"><div style="width: 80px;text-align: center;float: left;">' . ($r_rep['uid'] > 0 ? '<a href="user-' . $r_rep['uid'] . '.html" title="' . $uadb[$r_rep['uid']]['nc'] . '"><img src="' . yjl_face($r_rep['uid'], $uadb[$r_rep['uid']]['face']) . '" width="50" height="50" /><br />' . yjl_substrs($uadb[$r_rep['uid']]['nc'], 4) . '</a>' : '<img src="images/no_50.gif" width="50" height="50" /><br />未注册') . '</div><div style="width: 240px;float: left;"><div style="padding: 5px;">' . ($r_rep['uid'] == $r_res['uid'] ? '发起人' : '姓 名:' . $r_rep['name'] . '<br/>联系方式:' . $r_rep['lxfs'] . '<br/>邮 箱:' . $r_rep['email'] . '<br/>小 区 名:' . $xqname) . '</div></div><div style="clear: both;"></div></div>'; } while ($r_rep = mysql_fetch_assoc($rep)); } mysql_free_result($rep); $c .= '</div></div>'; } if (isset($htmlfj)) { $c .= $htmlfj; } } else { echo '<script type="text/javascript">location.href=\'active-' . $xqid . '.html\';</script>'; exit; } mysql_free_result($res); } else { require_once 'party_inc_2.php';
} else { $q_res = sprintf('select validate_true_name from %s where uid=%s limit 1', $dbprefix . 'memberfields', $adb['uid']); $res = mysql_query($q_res) or die(mysql_error()); $r_res = mysql_fetch_assoc($res); if (mysql_num_rows($res) > 0) { $adb['zsname'] = $r_res['validate_true_name']; } mysql_free_result($res); $c .= '<tr class="altbg1"><td>真实姓名:</td><td>' . $adb['zsname'] . '</td></tr> <tr class="altbg2"><td>生日:</td><td>' . $adb['bday'] . '</td></tr> <tr class="altbg1"><td>居住小区:</td><td>'; if ($adb['xqid'] > 0) { $q_rep = sprintf('select name from %s where xqid=%s and iskf=1', $yjl_dbprefix . 'xq', $adb['xqid']); $rep = mysql_query($q_rep) or die(''); $r_rep = mysql_fetch_assoc($rep); if (mysql_num_rows($rep) > 0) { $c .= $r_rep['name']; } mysql_free_result($rep); } $c .= '</td></tr> <tr class="altbg2"><td>详细地址:</td><td>' . $adb['xq_0'] . '栋/号 ' . $adb['xq_1'] . '室</td></tr> <tr class="altbg1"><td>邮编:</td><td>' . $adb['postcode'] . '</td></tr>'; } $c .= '<tr class="altbg2"><td>QQ:</td><td>' . $adb['qq'] . '</td></tr> <tr class="altbg1"><td>MSN:</td><td>' . $adb['msn'] . '</td></tr> <tr class="altbg2"><td>' . ($adb['qx'] == 5 || $adb['qx'] == 6 ? '特长' : '自我介绍') . ':</td><td>' . $adb['aboutme'] . '</td></tr> <tr class="altbg1"><td>头像:</td><td><img src="' . yjl_face($adb['uid'], $adb['face'], 1) . '"/></td></tr> </table>'; echo yjl_adminhtml($c); }
$reu = mysql_query($q_reu) or die(''); $r_reu = mysql_fetch_assoc($reu); if (mysql_num_rows($reu) > 0) { $c_hd = 1; $r_wb = $r_reu; $r_zf[$r_wb['tid']] = $r_res; if (!isset($uadb[$r_reu['uid']])) { $uadb[$r_reu['uid']] = yjl_udb($r_reu['uid']); } } else { $r_wb = $r_res; } mysql_free_result($reu); $c .= '<li id="wb_' . $r_wb['tid'] . '"> <div class="left"> <a href="user-' . $r_wb['uid'] . '.html"><img src="' . yjl_face($r_wb['uid'], $uadb[$r_wb['uid']]['face']) . '" /></a>'; if ($uadb[$r_wb['uid']]['qx'] == 5) { $c .= '<div class="m_sp1">监理师</div>'; } $c .= '</div> <div class="right"> <h3><a href="user-' . $r_wb['uid'] . '.html">' . $uadb[$r_wb['uid']]['nc'] . '</a>:'; if ($r_wb['longtextid'] > 0) { $q_reu = sprintf('select `longtext` from %s where id=%s and tid=%s limit 1', $dbprefix . 'topic_longtext', $r_wb['longtextid'], $r_wb['tid']); $reu = mysql_query($q_reu) or die(''); $r_reu = mysql_fetch_assoc($reu); if (mysql_num_rows($reu) > 0) { $c .= $r_reu['longtext']; } else { $r_wb['longtextid'] = 0; }
<div class="end"> <p>' . $r_res['name'] . ' 创建成功<br />你可以发送邀请让好友们来参加你的活动</p> </div> <br /> <div class="wt_mail clearfix"> <form method="post" class="main_form" id="login_form" action=""> <table> <tr> <th width="70">好友<b></b></th> <td><input type="text" class="text" name="touser" id="touser" jq_ise="1" value="' . $ic . '" /></td> </tr>'; if ($c_fri > 0) { $c .= '<tr><th></th><td><div class="friend clearfix"><ul>'; foreach ($a_fri as $k => $v) { $c .= '<li><a href="#" jq_flink="' . $k . '" title="' . $v['nc'] . '"><img id="fimg_' . $k . '" src="' . yjl_face($k, $v['face']) . '" style="border: 2px solid #fff;" /><br />' . yjl_substrs($v['nc'], 4) . '</a><input type="hidden" name="u_' . $k . '" id="u_' . $k . '" value="0"/></li>'; } $c .= '</ul></div></td></tr>'; } $c .= '<tr> <td valign="top"></td> <td><a href="active-' . $xqid . '-' . $hdid . '.html">跳过</a><input type="submit" value="发送邀请" class="submit sub_reg" id="submit_bt" /></td> </tr> </table> </form> <br class="clear" /><br /><br /> </div>'; } else { $isupimg = 1; $js_a = 'upimg_a_7(response, \'tt_iv\');'; $js_s = ', \'m\':\'hd\', \'hdid\':\'' . $r_res['hdid'] . '\'';
function yjl_homeqz($r_res) { global $yjl_dbprefix, $dbprefix, $uadb, $yjl_tpath, $a_qzca; $c_hd = 0; $q_reu = sprintf('select b.* from %s as a, %s as b where a.qzid=%s and a.tid=b.tid and a.uid<>%s order by a.datetime desc limit 1', $yjl_dbprefix . 'qz_topic', $dbprefix . 'topic', $r_res['qzid'], $r_res['uid']); $reu = mysql_query($q_reu) or die(''); $r_reu = mysql_fetch_assoc($reu); if (mysql_num_rows($reu) > 0) { $c_hd = 1; $r_wb = $r_reu; $r_zf[$r_wb['tid']] = $r_res; if (!isset($uadb[$r_reu['uid']])) { $uadb[$r_reu['uid']] = yjl_udb($r_reu['uid']); } } else { $r_wb = $r_res; } mysql_free_result($reu); $c = '<li id="wb_' . $r_wb['tid'] . '"><div class="left"> <a href="user-' . $r_wb['uid'] . '.html"><img src="' . yjl_face($r_wb['uid'], $uadb[$r_wb['uid']]['face']) . '" /></a> <div class="m_sp1">监理师</div> </div><div class="right"> <h3><a href="#"><a href="user-' . $r_wb['uid'] . '.html">' . yjl_substrs($uadb[$r_wb['uid']]['nc']) . '</a></a>:'; if ($r_wb['longtextid'] > 0) { $q_reu = sprintf('select `longtext` from %s where id=%s and tid=%s limit 1', $dbprefix . 'topic_longtext', $r_wb['longtextid'], $r_wb['tid']); $reu = mysql_query($q_reu) or die(''); $r_reu = mysql_fetch_assoc($reu); if (mysql_num_rows($reu) > 0) { $c .= $r_reu['longtext']; } else { $r_wb['longtextid'] = 0; } mysql_free_result($reu); } if ($r_wb['longtextid'] == 0) { $c .= yjl_wbdecode($r_wb['content']); } $c .= '</h3>'; if ($r_wb['imageid'] != '') { $ai = explode(',', $r_wb['imageid']); foreach ($ai as $v) { $q_reu = sprintf('select photo, width, height from %s where id=%s limit 1', $dbprefix . 'topic_image', $v); $reu = mysql_query($q_reu) or die(''); $r_reu = mysql_fetch_assoc($reu); if (mysql_num_rows($reu) > 0) { $ou = str_replace('./', '', $r_reu['photo']); $bu = str_replace('_o.jpg', '_s.jpg', $ou); $img_a[$r_wb['tid']][$v] = '<a href="#" onclick="openimg(\'' . $yjl_tpath . $ou . '\', ' . $r_reu['width'] . ', ' . $r_reu['height'] . ');return false;" title="点击查看大图"><img src="' . $yjl_tpath . $bu . '" alt=""/></a>'; } mysql_free_result($reu); } } if ($r_wb['videoid'] > 0) { $q_reu = sprintf('select video_url, video_img from %s where id=%s limit 1', $dbprefix . 'topic_video', $r_wb['videoid']); $reu = mysql_query($q_reu) or die(''); $r_reu = mysql_fetch_assoc($reu); if (mysql_num_rows($reu) > 0) { $img_a[$r_wb['tid']]['v' . $r_wb['videoid']] = '<a href="' . $r_reu['video_url'] . '" target="_blank" title="点击查看视频"><img src="images/blank.gif" style="background: #fff url(' . ($r_reu['video_img'] != '' ? $yjl_tpath . str_replace('./', '', $r_reu['video_img']) : 'images/vi_d.jpg') . ') no-repeat center;" alt=""/></a>'; } mysql_free_result($reu); } if (isset($img_a[$r_wb['tid']])) { $c .= join(' ', $img_a[$r_wb['tid']]); } if (isset($r_zf[$r_wb['tid']])) { $r_z = $r_zf[$r_wb['tid']]; $c .= '<div class="active_bg"></div><div class="active clearfix"><h3><a href="user-' . $r_z['uid'] . '.html">' . $uadb[$r_z['uid']]['nc'] . '</a>:'; if ($r_z['longtextid'] > 0) { $q_reu = sprintf('select `longtext` from %s where id=%s and tid=%s limit 1', $dbprefix . 'topic_longtext', $r_z['longtextid'], $r_z['tid']); $reu = mysql_query($q_reu) or die(''); $r_reu = mysql_fetch_assoc($reu); if (mysql_num_rows($reu) > 0) { $c .= $r_reu['longtext']; } else { $r_z['longtextid'] = 0; } mysql_free_result($reu); } if ($r_z['longtextid'] == 0) { $c .= yjl_wbdecode($r_z['content']); } $c .= '</h3>'; if ($r_z['imageid'] != '') { $ai = explode(',', $r_z['imageid']); foreach ($ai as $v) { $q_reu = sprintf('select photo, width, height from %s where id=%s limit 1', $dbprefix . 'topic_image', $v); $reu = mysql_query($q_reu) or die(''); $r_reu = mysql_fetch_assoc($reu); if (mysql_num_rows($reu) > 0) { $ou = str_replace('./', '', $r_reu['photo']); $bu = str_replace('_o.jpg', '_s.jpg', $ou); $img_a[$r_z['tid']][$v] = '<a href="#" onclick="openimg(\'' . $yjl_tpath . $ou . '\', ' . $r_reu['width'] . ', ' . $r_reu['height'] . ');return false;" title="点击查看大图"><img src="' . $yjl_tpath . $bu . '" alt=""/></a>'; } mysql_free_result($reu); } } if ($r_z['videoid'] > 0) { $q_reu = sprintf('select video_url, video_img from %s where id=%s limit 1', $dbprefix . 'topic_video', $r_z['videoid']); $reu = mysql_query($q_reu) or die(''); $r_reu = mysql_fetch_assoc($reu); if (mysql_num_rows($reu) > 0) { $img_a[$r_z['tid']]['v' . $r_z['videoid']] = '<a href="' . $r_reu['video_url'] . '" target="_blank" title="点击查看视频"><img src="images/blank.gif" style="background: #fff url(' . ($r_reu['video_img'] != '' ? $yjl_tpath . str_replace('./', '', $r_reu['video_img']) : 'images/vi_d.jpg') . ') no-repeat center;" alt=""/></a>'; } mysql_free_result($reu); } if (isset($img_a[$r_z['tid']])) { $c .= join(' ', $img_a[$r_z['tid']]); } $c .= '<p class="other">' . yjl_wbdate($r_z['dateline']) . '</p></div>'; } $c .= '<p class="other">'; $a[$r_res['qzid']][] = '<a href="faq-c' . $r_res['cid'] . '.html">' . $a_qzca[$r_res['cid']] . '</a>'; if ($r_res['c_zan'] > 0) { $a[$r_res['qzid']][] = ' 赞(' . $r_res['c_zan'] . ')'; } $a[$r_res['qzid']][] = '<a href="faq-' . $r_res['qzid'] . '.html">详情</a>'; $c .= (isset($a[$r_res['qzid']]) ? '<span>' . join(' |', $a[$r_res['qzid']]) : '') . '</span>'; $c .= yjl_wbdate($r_wb['dateline']); $c .= '</p></div></li>'; return $c; }