Esempio n. 1
0
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) : '&nbsp;') . '</a></li>';
        } while ($r_res = mysql_fetch_assoc($res));
        $c .= '</ul></div>';
        return $c;
    }
    mysql_free_result($res);
}
Esempio n. 2
0
                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']);
Esempio n. 3
0
                        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/>小&nbsp;区&nbsp;名:' . $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';
Esempio n. 4
0
    } 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);
}
Esempio n. 5
0
            $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;
                }
Esempio n. 6
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'] . '\'';
Esempio n. 7
0
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;
}