private function regularwildsearch($fieldname, $fieldvalue, $startresult = 0, $totalresults = 20)
{
$userid = $this->userid;
$db = new Database();
$db->connect();
$dtime = date('Y-m-d H:i:s');
$db->select('user', 'distinct SQL_CALC_FOUND_ROWS id', "`" . $fieldname . "` LIKE '%" . $fieldvalue . "%' and `accountstatusid`>0 and `schoolid`='" . $this->schoolid . "'", "id DESC", NULL, $startresult . ', ' . $totalresults);
$tmp = $db->getresult();
//print_r($tmp);die;
if (empty($tmp[0]['id'])) {
$tmp2[0]['id'] = $tmp['id'];
} else {
$tmp2 = $tmp;
}
$farray = array();
foreach ($tmp2 as $spaceid => $frienddata) {
$farray[] = $frienddata['id'];
}
//print_r($farray);die;
$this->set_totalrows($db->getTotalRows());
//print_r($farray);die;
return $farray;
}
public function network_classes($uid, $startresults = 0, $totalresults = 20, $orderby = "friend", $orderdirection = "DESC")
{
$db = new Database();
$db->connect();
$sess = new SessionData('account');
$id = $sess->Retrieve('id');
$classesquery = "\n\t\t\t\t\tselect distinct SQL_CALC_FOUND_ROWS\n\t\t\t\t\tcl.userid as friend\n\t\t\t\t\tfrom classlink r\n\t\t\t\t\tjoin classlink cl on cl.classid=r.classid\n\t\t\t\t\tjoin user u on u.id=cl.userid\n\t\t\t\t\tjoin user us on u.schoolid=us.schoolid and us.id=r.userid\n\t\t\t\t\tWHERE r.userid IN (" . $uid . ")\n\t\t\t\t\tand cl.userid != '" . $id . "'\n\t\t\t\t\tand u.accountstatusid>1\n\t\t\t\t\torder by " . $orderby . " " . $orderdirection . "\n\t\t\t\t\tlimit " . $startresults . ", " . $totalresults . "\n\t\t\t\t\t";
//echo $classesquery;
$db->query($classesquery);
$tmp = $db->getresult();
if ($tmp[0]['friend'] < 1) {
$tmp2[0]['friend'] = $tmp['friend'];
} else {
$tmp2 = $tmp;
}
$farray = array();
foreach ($tmp2 as $spaceid => $frienddata) {
$farray[$spaceid] = $frienddata['friend'];
}
Profile::set_totalrows($db->getTotalRows());
//$fof=array_merge($friendslist,$friendsoffriends);
//print_r($fof);
return $farray;
}
