".sprintf(_AL_BROWSE, title_link($storyinfo)).""; $favquery = dbquery("SELECT uid FROM ".TABLEPREFIX."fanfiction_favorites WHERE item = '$sid' AND type = 'ST'"); $favcount = dbnumrows($favquery); if($favcount > 0) { while($favau = dbassoc($favquery)) { $authlist[] = $favau['uid']; } $authlist = implode(",", $authlist); } $alquery = dbquery("SELECT item FROM ".TABLEPREFIX."fanfiction_favorites WHERE type = 'ST' AND FIND_IN_SET(uid, '$authlist') > 0 AND item != '$sid' GROUP BY item"); while($al = dbassoc($alquery)){ $alist[] = $al['item']; } $alist = isset($alist) ? implode(",", $alist) : array( ); $searchVars['sid'] = $sid; $storyquery .= " AND FIND_IN_SET(sid, '$alist') > 0 "; $countquery .= " AND FIND_IN_SET(sid, '$alist') > 0 "; $numrows = search(_STORYQUERY.$storyquery, _STORYCOUNT.$countquery, "browse.php?type=alsolike&sid=$sid&"); ?>