Lines Matching refs:sqladd
53 $sqladd = '';
55 $sqladd = "uid='$uid'";
57 $sqladd = "uid='$uid' AND direction='1'";
59 $sqladd = "friendid='$uid' AND direction='1'";
61 $sqladd = "uid='$uid' AND direction='3'";
63 …$totalnum = $this->db->result_first("SELECT COUNT(*) FROM ".UC_DBTABLEPRE."friends WHERE $sqladd");
69 $sqladd = '';
71 $sqladd = "f.uid='$uid'";
73 $sqladd = "f.uid='$uid' AND f.direction='1'";
75 $sqladd = "f.friendid='$uid' AND f.direction='1'";
77 $sqladd = "f.uid='$uid' AND f.direction='3'";
79 if($sqladd) {
80 …riends f LEFT JOIN ".UC_DBTABLEPRE."members m ON f.friendid=m.uid WHERE $sqladd LIMIT $start, $pag…
89 $sqladd = '';
91 $sqladd = "uid='$uid'";
93 $sqladd = "uid='$uid' AND friendid IN ('$friendid_str') AND direction='1'";
95 $sqladd = "friendid='$uid' AND uid IN ('$friendid_str') AND direction='1'";
97 $sqladd = "uid='$uid' AND friendid IN ('$friendid_str') AND direction='3'";
99 …if($this->db->result_first("SELECT COUNT(*) FROM ".UC_DBTABLEPRE."friends WHERE $sqladd") == count…