function matching($array, $search) { global $found; foreach ($search as $key => $value) { // var_dump($key,$value,$array); echo "<br>------<br>"; if ($key == "location" || $key == "categories") { continue; } if (!isset($array[$key])) { $found = false; break; } if (is_string($value)) { if (!preg_match('"' . $value . '"', $array[$key])) { $found = false; break; } } if (is_array($value)) { matching($array[$key], $value); } } return $found; }
function ComputeAssignment(&$tpl, $db, $maxReviewers) { // Decompose the blocks of the template $tpl->set_block("content", "MEMBER_DETAIL", "MEMBERS"); $tpl->set_block("content", "PAPER_DETAIL", "PAPERS"); $tpl->set_block("content", "GROUP_DETAIL", "GROUP"); $tpl->set_block("PAPER_DETAIL", "ASSIGNMENT_DETAIL", "ASSIGNMENTS"); // This function might take a while to execute... ini_set("max_execution_time", "900"); // 15 mns, should be enough... $tpl->set_var("MEMBERS", ""); $tpl->set_var("PAPERS", ""); $tpl->set_var("RESULTS", ""); $tpl->set_var("ASSIGNMENTS", ""); // Get global parameters $nbReviewers = Config::countAllReviewers(); $nbPapers = Config::countAllPapers(); $refPerPap = $maxReviewers; // How many papers for each referee ? $papRef = $nbPapers * $refPerPap; $papForRef = floor($papRef / $nbReviewers) + 1; // Templates assignment $tpl->set_var("NUMBER_PAPERS", $nbPapers); $tpl->set_var("NUMBER_REVIEWERS", $nbReviewers); $tpl->set_var("REVIEWERS_PAPERS", $refPerPap); $tpl->set_var("MAX_PAPERS_REVIEWER", $papForRef); if (isset($_REQUEST['idMin'])) { // A group must be computed $idMin = $_REQUEST['idMin']; $idMax = $_REQUEST['idMax']; $nbGroups = 1; } else { if ($nbPapers > MAX_PAPERS_IN_ROUND) { $tpl->set_file("TxtAssignmentGroups", "assigngroup.xml"); $tpl->set_block("TxtAssignmentGroups", "GROUP_DETAIL", "GROUPS"); $tpl->set_var("GROUPS", ""); $tpl->set_var("MAX_PAPERS_IN_ROUND", MAX_PAPERS_IN_ROUND); // How many groups do we create? $nbGroups = $nbPapers / MAX_PAPERS_IN_ROUND + 1; $nb_papers_per_group = $nbPapers / $nbGroups; // Compute the groups $rPapers = $db->execRequete("SELECT * FROM Paper ORDER BY id"); $iPaper = 0; $idMin = $idMax = -1; $iGroup = 1; $groups = array(); while ($paper = $db->objetSuivant($rPapers)) { if ($idMin == -1) { $idMin = $paper->id; } if ($paper->id > $idMax) { $idMax = $paper->id; } $iPaper++; if ($iPaper > $nb_papers_per_group) { // Create a group $groups[$iGroup++] = array("idMin" => $idMin, "idMax" => $idMax); $idMin = $idMax = -1; $iPaper = 0; } } // Create the last group $groups[$iGroup] = array("idMin" => $idMin, "idMax" => $idMax); foreach ($groups as $key => $val) { $idMin = $val['idMin']; $idMax = $val['idMax']; $tpl->set_var("GROUP_ID", "{$key}"); $tpl->set_var("ID_MIN", $idMin); $tpl->set_var("ID_MAX", $idMax); $tpl->append("GROUPS", "GROUP_DETAIL"); } $tpl->assign("content", "assigngroup"); return; } else { $nbGroups = 1; $nb_papers_per_group = $nbPapers; } } /* Not useful if one priviledges the number of reviewers for each paper $papRef = $maxReviewers * $nbPapers; $papForRef = floor((float) $papRef / (float) $ if ($papRef % $nbReviewers != 0) floor($papForRef++); */ // Create two arrays, one for members, one for papers $members = $papers = array(); $qMembers = "SELECT * FROM User WHERE roles LIKE '%R%' ORDER BY last_name"; $rMembers = $db->execRequete($qMembers); $iMember = 1; while ($member = $db->objetSuivant($rMembers)) { $members[$iMember++] = $member->id; } $nbReviewers = $iMember - 1; if (isset($idMin)) { $qPapers = "SELECT * FROM Paper WHERE id BETWEEN {$idMin} AND {$idMax} ORDER BY id"; } else { $qPapers = "SELECT * FROM Paper ORDER BY id"; } $rPapers = $db->execRequete($qPapers); $iPaper = 1; while ($paper = $db->objetSuivant($rPapers)) { $papers[$iPaper++] = $paper->id; } $nbPapers = $iPaper - 1; // OK, let's do the assignment if ($nbPapers > $nbReviewers) { $n = $nbPapers; } else { $n = $nbReviewers; } /* echo "Nbpapers = $nbPapers Nb rev.=$nbReviewers N=$n<br>"; return; */ // Create the matrix $weight = array(); reset($papers); while (list($iPaper, $idPaper) = each($papers)) { reset($members); while (list($iRef, $id_user) = each($members)) { $weight[$iRef][$iPaper] = GetRatingValue($idPaper, $id_user, $db); } // Complete to obtain a square matrix if ($nbReviewers < $n) { for ($i = $nbReviewers + 1; $i <= $n; $i++) { $weight[$i][$iPaper] = 0; } } } // Complete to obtain a square matrix if nbPapers < nbReviewers if ($nbPapers < $n) { for ($i = $nbPapers + 1; $i <= $n; $i++) { reset($members); while (list($iRef, $email) = each($members)) { $weight[$iRef][$i] = 0; } } } // End of init **** // Initialize the arrays $assignedPapers = $chosenPapers = $Rmate = $Lmate = $choice = array(); for ($i = 1; $i <= $nbPapers; $i++) { $chosenPapers[$i] = 0; } for ($i = 1; $i <= $nbReviewers; $i++) { $assignedPapers[$i] = 0; for ($j = 1; $j <= $nbPapers; $j++) { $choice[$i][$j] = 0; } } $wsum = 1; // dummy for first iteration for ($i = 1; $wsum > 0; $i++) { for ($j = 1; $j <= $n; $j++) { $Rmate[$j] = $Lmate[$j] = 0; } // Compute the matching for the current ballot matching($n, $Lmate, $Rmate, $weight); // Make the assignment - Remove choices already made takeout($nbReviewers, $nbPapers, $Lmate, $weight, $choice, $chosenPapers, $assignedPapers, $wsum, $maxReviewers, $papForRef); // if ($i >= $maxReviewers) break; } // Insert results in the DB $db->execRequete("DELETE FROM Assignment"); reset($papers); while (list($iPaper, $idPaper) = each($papers)) { $weightPaper = 0; reset($members); $tabMails = array(); while (list($iRef, $id_user) = each($members)) { $weight = $choice[$iRef][$iPaper]; if ($weight != 0) { $tabMails[] = $id_user; $query = "INSERT INTO Assignment(idPaper, id_user, weight)" . "VALUES ('{$idPaper}', '{$id_user}', '{$weight}')"; $db->execRequete($query); } } // Insert the assignment in the Review table // SQLReview ($idPaper, $tabMails, $db); } // Report the result ReportAssignment($tpl, $members, $papers, $choice, $db); if (isset($idMin)) { $tpl->set_var("ID_MIN", $idMin); $tpl->set_var("ID_MAX", $idMax); $tpl->parse("GROUP", "GROUP_DETAIL"); } else { $tpl->set_var("GROUP", ""); } }
function probe_url($url, $mode = PROBE_NORMAL, $level = 1) { require_once 'include/email.php'; $result = array(); if (!$url) { return $result; } $result = Cache::get("probe_url:" . $mode . ":" . $url); if (!is_null($result)) { $result = unserialize($result); return $result; } $network = null; $diaspora = false; $diaspora_base = ''; $diaspora_guid = ''; $diaspora_key = ''; $has_lrdd = false; $email_conversant = false; $connectornetworks = false; $appnet = false; if (strpos($url, 'twitter.com')) { $connectornetworks = true; $network = NETWORK_TWITTER; } // Twitter is deactivated since twitter closed its old API //$twitter = ((strpos($url,'twitter.com') !== false) ? true : false); $lastfm = strpos($url, 'last.fm/user') !== false ? true : false; $at_addr = strpos($url, '@') !== false ? true : false; if (!$appnet && !$lastfm && !$connectornetworks) { if (strpos($url, 'mailto:') !== false && $at_addr) { $url = str_replace('mailto:', '', $url); $links = array(); } else { $links = lrdd($url); } if (count($links)) { $has_lrdd = true; logger('probe_url: found lrdd links: ' . print_r($links, true), LOGGER_DATA); foreach ($links as $link) { if ($link['@attributes']['rel'] === NAMESPACE_ZOT) { $zot = unamp($link['@attributes']['href']); } if ($link['@attributes']['rel'] === NAMESPACE_DFRN) { $dfrn = unamp($link['@attributes']['href']); } if ($link['@attributes']['rel'] === 'salmon') { $notify = unamp($link['@attributes']['href']); } if ($link['@attributes']['rel'] === NAMESPACE_FEED) { $poll = unamp($link['@attributes']['href']); } if ($link['@attributes']['rel'] === 'http://microformats.org/profile/hcard') { $hcard = unamp($link['@attributes']['href']); } if ($link['@attributes']['rel'] === 'http://webfinger.net/rel/profile-page') { $profile = unamp($link['@attributes']['href']); } if ($link['@attributes']['rel'] === 'http://portablecontacts.net/spec/1.0') { $poco = unamp($link['@attributes']['href']); } if ($link['@attributes']['rel'] === 'http://joindiaspora.com/seed_location') { $diaspora_base = unamp($link['@attributes']['href']); $diaspora = true; } if ($link['@attributes']['rel'] === 'http://joindiaspora.com/guid') { $diaspora_guid = unamp($link['@attributes']['href']); $diaspora = true; } if ($link['@attributes']['rel'] === 'diaspora-public-key') { $diaspora_key = base64_decode(unamp($link['@attributes']['href'])); if (strstr($diaspora_key, 'RSA ')) { $pubkey = rsatopem($diaspora_key); } else { $pubkey = $diaspora_key; } $diaspora = true; } if ($link['@attributes']['rel'] === 'http://ostatus.org/schema/1.0/subscribe' and $mode == PROBE_NORMAL) { $diaspora = false; } } // Status.Net can have more than one profile URL. We need to match the profile URL // to a contact on incoming messages to prevent spam, and we won't know which one // to match. So in case of two, one of them is stored as an alias. Only store URL's // and not webfinger user@host aliases. If they've got more than two non-email style // aliases, let's hope we're lucky and get one that matches the feed author-uri because // otherwise we're screwed. foreach ($links as $link) { if ($link['@attributes']['rel'] === 'alias') { if (strpos($link['@attributes']['href'], '@') === false) { if (isset($profile)) { if ($link['@attributes']['href'] !== $profile) { $alias = unamp($link['@attributes']['href']); } } else { $profile = unamp($link['@attributes']['href']); } } } } // If the profile is different from the url then the url is abviously an alias if ($alias == "" and $profile != "" and !$at_addr and normalise_link($profile) != normalise_link($url)) { $alias = $url; } } elseif ($mode == PROBE_NORMAL) { // Check email $orig_url = $url; if (strpos($orig_url, '@') && validate_email($orig_url)) { $x = q("SELECT `prvkey` FROM `user` WHERE `uid` = %d LIMIT 1", intval(local_user())); $r = q("SELECT * FROM `mailacct` WHERE `uid` = %d AND `server` != '' LIMIT 1", intval(local_user())); if (count($x) && count($r)) { $mailbox = construct_mailbox_name($r[0]); $password = ''; openssl_private_decrypt(hex2bin($r[0]['pass']), $password, $x[0]['prvkey']); $mbox = email_connect($mailbox, $r[0]['user'], $password); if (!$mbox) { logger('probe_url: email_connect failed.'); } unset($password); } if ($mbox) { $msgs = email_poll($mbox, $orig_url); logger('probe_url: searching ' . $orig_url . ', ' . count($msgs) . ' messages found.', LOGGER_DEBUG); if (count($msgs)) { $addr = $orig_url; $network = NETWORK_MAIL; $name = substr($url, 0, strpos($url, '@')); $phost = substr($url, strpos($url, '@') + 1); $profile = 'http://' . $phost; // fix nick character range $vcard = array('fn' => $name, 'nick' => $name, 'photo' => avatar_img($url)); $notify = 'smtp ' . random_string(); $poll = 'email ' . random_string(); $priority = 0; $x = email_msg_meta($mbox, $msgs[0]); if (stristr($x[0]->from, $orig_url)) { $adr = imap_rfc822_parse_adrlist($x[0]->from, ''); } elseif (stristr($x[0]->to, $orig_url)) { $adr = imap_rfc822_parse_adrlist($x[0]->to, ''); } if (isset($adr)) { foreach ($adr as $feadr) { if (strcasecmp($feadr->mailbox, $name) == 0 && strcasecmp($feadr->host, $phost) == 0 && strlen($feadr->personal)) { $personal = imap_mime_header_decode($feadr->personal); $vcard['fn'] = ""; foreach ($personal as $perspart) { if ($perspart->charset != "default") { $vcard['fn'] .= iconv($perspart->charset, 'UTF-8//IGNORE', $perspart->text); } else { $vcard['fn'] .= $perspart->text; } } $vcard['fn'] = notags($vcard['fn']); } } } } imap_close($mbox); } } } } if ($mode == PROBE_NORMAL) { if (strlen($zot)) { $s = fetch_url($zot); if ($s) { $j = json_decode($s); if ($j) { $network = NETWORK_ZOT; $vcard = array('fn' => $j->fullname, 'nick' => $j->nickname, 'photo' => $j->photo); $profile = $j->url; $notify = $j->post; $pubkey = $j->pubkey; $poll = 'N/A'; } } } if (strlen($dfrn)) { $ret = scrape_dfrn($hcard ? $hcard : $dfrn, true); if (is_array($ret) && x($ret, 'dfrn-request')) { $network = NETWORK_DFRN; $request = $ret['dfrn-request']; $confirm = $ret['dfrn-confirm']; $notify = $ret['dfrn-notify']; $poll = $ret['dfrn-poll']; $vcard = array(); $vcard['fn'] = $ret['fn']; $vcard['nick'] = $ret['nick']; $vcard['photo'] = $ret['photo']; } } } if ($diaspora && $diaspora_base && $diaspora_guid) { if ($mode == PROBE_DIASPORA || !$notify) { $notify = $diaspora_base . 'receive/users/' . $diaspora_guid; $batch = $diaspora_base . 'receive/public'; } if (strpos($url, '@')) { $addr = str_replace('acct:', '', $url); } } if ($network !== NETWORK_ZOT && $network !== NETWORK_DFRN && $network !== NETWORK_MAIL) { if ($diaspora) { $network = NETWORK_DIASPORA; } elseif ($has_lrdd and $notify) { $network = NETWORK_OSTATUS; } if (strpos($url, '@')) { $addr = str_replace('acct:', '', $url); } $priority = 0; if ($hcard && !$vcard) { $vcard = scrape_vcard($hcard); // Google doesn't use absolute url in profile photos if (x($vcard, 'photo') && substr($vcard['photo'], 0, 1) == '/') { $h = @parse_url($hcard); if ($h) { $vcard['photo'] = $h['scheme'] . '://' . $h['host'] . $vcard['photo']; } } logger('probe_url: scrape_vcard: ' . print_r($vcard, true), LOGGER_DATA); } if ($diaspora && $addr) { // Diaspora returns the name as the nick. As the nick will never be updated, // let's use the Diaspora nickname (the first part of the handle) as the nick instead $addr_parts = explode('@', $addr); $vcard['nick'] = $addr_parts[0]; } /* if($twitter) { logger('twitter: setup'); $tid = basename($url); $tapi = 'https://api.twitter.com/1/statuses/user_timeline.rss'; if(intval($tid)) $poll = $tapi . '?user_id=' . $tid; else $poll = $tapi . '?screen_name=' . $tid; $profile = 'http://twitter.com/#!/' . $tid; //$vcard['photo'] = 'https://api.twitter.com/1/users/profile_image/' . $tid; $vcard['photo'] = 'https://api.twitter.com/1/users/profile_image?screen_name=' . $tid . '&size=bigger'; $vcard['nick'] = $tid; $vcard['fn'] = $tid; } */ if ($lastfm) { $profile = $url; $poll = str_replace(array('www.', 'last.fm/'), array('', 'ws.audioscrobbler.com/1.0/'), $url) . '/recenttracks.rss'; $vcard['nick'] = basename($url); $vcard['fn'] = $vcard['nick'] . t(' on Last.fm'); $network = NETWORK_FEED; } if (!x($vcard, 'fn')) { if (x($vcard, 'nick')) { $vcard['fn'] = $vcard['nick']; } } $check_feed = false; if (stristr($url, 'tumblr.com') && !stristr($url, '/rss')) { $poll = $url . '/rss'; $check_feed = true; // Will leave it to others to figure out how to grab the avatar, which is on the $url page in the open graph meta links } if ($appnet || !$poll) { $check_feed = true; } if (!isset($vcard) || !x($vcard, 'fn') || !$profile) { $check_feed = true; } if ($at_addr && !count($links)) { $check_feed = false; } if ($connectornetworks) { $check_feed = false; } if ($check_feed) { $feedret = scrape_feed($poll ? $poll : $url); logger('probe_url: scrape_feed ' . ($poll ? $poll : $url) . ' returns: ' . print_r($feedret, true), LOGGER_DATA); if (count($feedret) && ($feedret['feed_atom'] || $feedret['feed_rss'])) { $poll = x($feedret, 'feed_atom') ? unamp($feedret['feed_atom']) : unamp($feedret['feed_rss']); if (!x($vcard)) { $vcard = array(); } } if (x($feedret, 'photo') && !x($vcard, 'photo')) { $vcard['photo'] = $feedret['photo']; } require_once 'library/simplepie/simplepie.inc'; $feed = new SimplePie(); $xml = fetch_url($poll); logger('probe_url: fetch feed: ' . $poll . ' returns: ' . $xml, LOGGER_DATA); $a = get_app(); logger('probe_url: scrape_feed: headers: ' . $a->get_curl_headers(), LOGGER_DATA); // Don't try and parse an empty string $feed->set_raw_data($xml ? $xml : '<?xml version="1.0" encoding="utf-8" ?><xml></xml>'); $feed->init(); if ($feed->error()) { logger('probe_url: scrape_feed: Error parsing XML: ' . $feed->error()); $network = NETWORK_PHANTOM; } if (!x($vcard, 'photo')) { $vcard['photo'] = $feed->get_image_url(); } $author = $feed->get_author(); if ($author) { $vcard['fn'] = unxmlify(trim($author->get_name())); if (!$vcard['fn']) { $vcard['fn'] = trim(unxmlify($author->get_email())); } if (strpos($vcard['fn'], '@') !== false) { $vcard['fn'] = substr($vcard['fn'], 0, strpos($vcard['fn'], '@')); } $email = unxmlify($author->get_email()); if (!$profile && $author->get_link()) { $profile = trim(unxmlify($author->get_link())); } if (!$vcard['photo']) { $rawtags = $feed->get_feed_tags(SIMPLEPIE_NAMESPACE_ATOM_10, 'author'); if ($rawtags) { $elems = $rawtags[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]; if (x($elems, 'link') && $elems['link'][0]['attribs']['']['rel'] === 'photo') { $vcard['photo'] = $elems['link'][0]['attribs']['']['href']; } } } // Fetch fullname via poco:displayName $pocotags = $feed->get_feed_tags(SIMPLEPIE_NAMESPACE_ATOM_10, 'author'); if ($pocotags) { $elems = $pocotags[0]['child']['http://portablecontacts.net/spec/1.0']; if (isset($elems["displayName"])) { $vcard['fn'] = $elems["displayName"][0]["data"]; } if (isset($elems["preferredUsername"])) { $vcard['nick'] = $elems["preferredUsername"][0]["data"]; } } } else { $item = $feed->get_item(0); if ($item) { $author = $item->get_author(); if ($author) { $vcard['fn'] = trim(unxmlify($author->get_name())); if (!$vcard['fn']) { $vcard['fn'] = trim(unxmlify($author->get_email())); } if (strpos($vcard['fn'], '@') !== false) { $vcard['fn'] = substr($vcard['fn'], 0, strpos($vcard['fn'], '@')); } $email = unxmlify($author->get_email()); if (!$profile && $author->get_link()) { $profile = trim(unxmlify($author->get_link())); } } if (!$vcard['photo']) { $rawmedia = $item->get_item_tags('http://search.yahoo.com/mrss/', 'thumbnail'); if ($rawmedia && $rawmedia[0]['attribs']['']['url']) { $vcard['photo'] = unxmlify($rawmedia[0]['attribs']['']['url']); } } if (!$vcard['photo']) { $rawtags = $item->get_item_tags(SIMPLEPIE_NAMESPACE_ATOM_10, 'author'); if ($rawtags) { $elems = $rawtags[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]; if (x($elems, 'link') && $elems['link'][0]['attribs']['']['rel'] === 'photo') { $vcard['photo'] = $elems['link'][0]['attribs']['']['href']; } } } } } // Workaround for misconfigured Friendica servers if ($network == "" and strstr($url, "/profile/")) { $noscrape = str_replace("/profile/", "/noscrape/", $url); $noscrapejson = fetch_url($noscrape); if ($noscrapejson) { $network = NETWORK_DFRN; $poco = str_replace("/profile/", "/poco/", $url); $noscrapedata = json_decode($noscrapejson, true); if (isset($noscrapedata["addr"])) { $addr = $noscrapedata["addr"]; } if (isset($noscrapedata["fn"])) { $vcard["fn"] = $noscrapedata["fn"]; } if (isset($noscrapedata["key"])) { $pubkey = $noscrapedata["key"]; } if (isset($noscrapedata["photo"])) { $vcard["photo"] = $noscrapedata["photo"]; } if (isset($noscrapedata["dfrn-request"])) { $request = $noscrapedata["dfrn-request"]; } if (isset($noscrapedata["dfrn-confirm"])) { $confirm = $noscrapedata["dfrn-confirm"]; } if (isset($noscrapedata["dfrn-notify"])) { $notify = $noscrapedata["dfrn-notify"]; } if (isset($noscrapedata["dfrn-poll"])) { $poll = $noscrapedata["dfrn-poll"]; } } } if (!$vcard['photo'] && strlen($email)) { $vcard['photo'] = avatar_img($email); } if ($poll === $profile) { $lnk = $feed->get_permalink(); } if (isset($lnk) && strlen($lnk)) { $profile = $lnk; } if (!$network) { $network = NETWORK_FEED; // If it is a feed, don't take the author name as feed name unset($vcard['fn']); } if (!x($vcard, 'fn')) { $vcard['fn'] = notags($feed->get_title()); } if (!x($vcard, 'fn')) { $vcard['fn'] = notags($feed->get_description()); } if (strpos($vcard['fn'], 'Twitter / ') !== false) { $vcard['fn'] = substr($vcard['fn'], strpos($vcard['fn'], '/') + 1); $vcard['fn'] = trim($vcard['fn']); } if (!x($vcard, 'nick')) { $vcard['nick'] = strtolower(notags(unxmlify($vcard['fn']))); if (strpos($vcard['nick'], ' ')) { $vcard['nick'] = trim(substr($vcard['nick'], 0, strpos($vcard['nick'], ' '))); } } if (!$priority) { $priority = 2; } } } if (!x($vcard, 'photo')) { $a = get_app(); $vcard['photo'] = $a->get_baseurl() . '/images/person-175.jpg'; } if (!$profile) { $profile = $url; } // No human could be associated with this link, use the URL as the contact name if ($network === NETWORK_FEED && $poll && !x($vcard, 'fn')) { $vcard['fn'] = $url; } if ($notify != "" and $poll != "") { $baseurl = matching(normalise_link($notify), normalise_link($poll)); $baseurl2 = matching($baseurl, normalise_link($profile)); if ($baseurl2 != "") { $baseurl = $baseurl2; } } if ($baseurl == "" and $notify != "") { $baseurl = matching(normalise_link($profile), normalise_link($notify)); } if ($baseurl == "" and $poll != "") { $baseurl = matching(normalise_link($profile), normalise_link($poll)); } $baseurl = rtrim($baseurl, "/"); if (strpos($url, '@') and $addr == "" and $network == NETWORK_DFRN) { $addr = str_replace('acct:', '', $url); } $vcard['fn'] = notags($vcard['fn']); $vcard['nick'] = str_replace(' ', '', notags($vcard['nick'])); $result['name'] = $vcard['fn']; $result['nick'] = $vcard['nick']; $result['url'] = $profile; $result['addr'] = $addr; $result['batch'] = $batch; $result['notify'] = $notify; $result['poll'] = $poll; $result['request'] = $request; $result['confirm'] = $confirm; $result['poco'] = $poco; $result['photo'] = $vcard['photo']; $result['priority'] = $priority; $result['network'] = $network; $result['alias'] = $alias; $result['pubkey'] = $pubkey; $result['baseurl'] = $baseurl; logger('probe_url: ' . print_r($result, true), LOGGER_DEBUG); if ($level == 1) { // Trying if it maybe a diaspora account if ($result['network'] == NETWORK_FEED or $result['addr'] == "") { require_once 'include/bbcode.php'; $address = GetProfileUsername($url, "", true); $result2 = probe_url($address, $mode, ++$level); if ($result2['network'] != "") { $result = $result2; } } // Maybe it's some non standard GNU Social installation (Single user, subfolder or no uri rewrite) if ($result['network'] == NETWORK_FEED and $result['baseurl'] != "" and $result['nick'] != "") { $addr = $result['nick'] . '@' . str_replace("http://", "", $result['baseurl']); $result2 = probe_url($addr, $mode, ++$level); if ($result2['network'] != "" and $result2['network'] != NETWORK_FEED) { $result = $result2; } } } // Only store into the cache if the value seems to be valid if ($result['network'] != NETWORK_PHANTOM) { Cache::set("probe_url:" . $mode . ":" . $url, serialize($result), CACHE_DAY); } return $result; }
<?php require_once 'mysqli.class.php'; $post = $_GET; if (empty($post['id'])) { die("ポストがないです"); } $select_user = new db('SELECT tag1, tag2, tag3, X(geo) as lng, Y(geo) as lat FROM user WHERE id = "' . $post['id'] . '"'); if ($select_user->result_rows() > 0) { $user = $select_user->result_row_array(); $tag['tag1'] = matching($user['tag1'], $user['lng'], $user['lat']); $tag['tag2'] = matching($user['tag2'], $user['lng'], $user['lat']); $tag['tag3'] = matching($user['tag3'], $user['lng'], $user['lat']); echo json_encode($tag); } else { die("そんなユーザーないです"); } function matching($tag, $x, $y) { $sql = "SELECT id, fb_id, name, X(geo) as lng, Y(geo) as lat," . "GLength(GeomFromText(CONCAT('LineString({$x} {$y},', X(geo), ' ', Y(geo),')'))) AS len " . "FROM user " . "WHERE (`tag1` = '{$tag}' OR `tag2` = '{$tag}' OR `tag3` = '{$tag}') " . "ORDER BY len ASC " . "LIMIT 10"; $maching = new db($sql); return $maching->result_array(); }