search.php
2.21 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
<?php
/**
* 搜索
*
* @version $Id: search.php 1 8:38 2010年7月9日Z tianya $
* @package DedeCMS.Member
* @copyright Copyright (c) 2007 - 2010, DesDev, Inc.
* @license http://help.dedecms.com/usersguide/license.html
* @link http://www.dedecms.com
*/
require_once(dirname(__FILE__).'/config.php');
CheckRank(0,0);
require_once(DEDEINC.'/enums.func.php');
require_once(DEDEINC.'/datalistcp.class.php');
$menutype = 'mydede';
//检查用户是否被禁言
CheckNotAllow();
$addsqls = array();
$province = empty($province) ? 0 : intval($province);
$city = empty($city) ? 0 : intval($city);
$minage = empty($minage) ? 0 : intval($minage);
$maxage = empty($maxage) ? 0 : intval($maxage);
if(empty($sex)) $sex = '';
if(empty($keyword)) $keyword = '';
$keyword = FilterSearch(stripslashes($keyword));
$keyword = addslashes(cn_substr($keyword,20));
if(!empty($keyword)) {
$addsqls[] = " (mb.userid like '%$keyword%' Or mb.uname like '%$keyword%') ";
}
if(empty($city)) {
$place = $province;
}
else {
$place = $city;
}
if( $place%500 != 0 )
{
$addsqls[] = " mp.place='$place' ";
}
else
{
if($place!=0)
{
$minp = $place - 1;
$maxp = $place + 500;
$addsqls[] = " mp.place>'$minp' And mp.place<'$maxp' ";
}
}
if($sex!='') $addsqls[] = " mp.sex = '$sex' ";
if($minage!=0) $addsqls[] = " YEAR(CURDATE())-YEAR(mp.birthday)>='$minage' ";
if($maxage!=0) $addsqls[] = " YEAR(CURDATE())-YEAR(mp.birthday)<='$maxage' ";
$addsqls_str = join(' And ',$addsqls);
if($addsqls_str!='') {
$addsqls_str = ' And '.$addsqls_str;
}
$addsql = " WHERE mb.spacesta > -1 ".$addsqls_str;
$query = "SELECT mb.*,mp.place,YEAR(CURDATE())-YEAR(mp.birthday) AS age,mp.lovemsg,mp.birthday FROM `#@__member` mb
LEFT JOIN `#@__member_person` mp ON mp.mid = mb.mid
{$addsql} ORDER BY mb.logintime DESC";
$dlist = new DataListCP();
$dlist->pageSize = 8;
$dlist->SetParameter('keyword',$keyword);
$dlist->SetParameter('province',$province);
$dlist->SetParameter('city',$city);
$dlist->SetParameter('minage',$minage);
$dlist->SetParameter('maxage',$maxage);
$dlist->SetParameter('sex',$sex);
$dlist->SetTemplate(DEDEMEMBER.'/templets/search.htm');
$dlist->SetSource($query);
$dlist->Display();