• ')); } elseif ($filter=='htmlchars') { return(hspech($val)); } elseif ($filter=='timestamp') { return(strftime('%c',$val)); } elseif ($filter=='email') { return(''.strip_tags($val).''); } elseif ($filter=='url') { return(''.strip_tags($val).''); } elseif ($filter=='image') { return(''); } elseif ($filter=='boolt') { if ($val) return('Si'); else return('No'); } elseif ($filter=='boolf') { if ($val) return('Si'); else return('No'); } else { return($val); } } else { if (is_null($ntext)) { if ($fem) return('Non definita'); else return('Non definito'); } else { return(''.$ntext.''); } } } function booly($pre,$val,$nottoobad=false,$invcol=false) { if ($val) { if (!$invcol) { $p='

      '; } else { if (!$nottoobad) { $p='

      '; } else { $p='

      '; } } return($p.$pre.'SI

      '); } else { if (!$invcol) { if (!$nottoobad) { $p='

      '; } else { $p='

      '; } } else { $p='

      '; } return($p.$pre.'NO

      '); } } function trimname($str) { return(substr($str,1,strlen($str)-2)); } // $row deve essere una riga ritornata da una query tipo "SELECT *, ID AS IID FROM Instances WHERE ..." function dispinst(&$row,&$cols,&$link,&$dlang,&$account,$showcount,$finst,$cinsts) { $out=''; $out.=''.N; // $out.=''.N; $out.=''.N; $out.=''.N; $out.=''.N; if ($account['Level']!='guest') { if (!is_null($row['GuestID'])) { $out.=''.N; } elseif (trim($row['Email'])=='') { $out.=''.N; } else { $out.=''.N; } } $attr=booly(trimname($cols['Instances.Blacklisted']['name']).': ',$row['Blacklisted'],false,true).N; $attr.=booly(trimname($cols['Instances.New']['name']).': ',$row['New'],true).N; $attr.=booly(trimname($cols['Instances.Good']['name']).': ',$row['Good']).N; $attr.=booly(trimname($cols['Instances.Chosen']['name']).': ',$row['Chosen']).N; $attr.=booly(trimname($cols['Instances.Visible']['name']).': ',$row['Visible']).N; /*$attr.=booly($cols['Instances.RegOpen']['name'].': ',$row['RegOpen']).N; $attr.=booly($cols['Instances.RegReqApproval']['name'].': ',$row['RegReqApproval'],true,true).N;*/ $sres=mysqli_query($link,'SELECT * FROM InstChecks WHERE InstID='.$row['IID'].' ORDER BY Time DESC') or muoribene(mysqli_error($link),true); $csres=mysqli_num_rows($sres); if ($csres>0) { $bene=0; while ($srow=mysqli_fetch_assoc($sres)) { if ($srow['Status']==1) $bene++; } $width=str_replace(',','.',100/$csres*$bene); $attr.='
      Percentuale di risposta ai nostri check ('.$csres.'): '.round($width,1).'%
      '; $attr.='
      '.N; mysqli_data_seek($sres,0); $srow=mysqli_fetch_assoc($sres); $attr.='
      Ultimo check '.strftime('%e %b %Y, %T',$srow['Time']).': '.(($srow['Status']) ? 'OK' : 'KO').'
      '; } else { $attr.='
      Percentuale di risposta ai nostri check
      '.N; $attr.='
      Non disponibile (?!?!?!)
      '.N; } $attr.='
      Attività delle ultime 12 settimane
      '.N; $sres=mysqli_query($link,'SELECT SUM(Statuses) AS tstatuses, SUM(Logins) AS tlogins, SUM(Registrations) AS tregs FROM InstActivity WHERE InstID='.$row['IID']) or muoribene(mysqli_error($link),true); $tot=mysqli_fetch_assoc($sres); $sres=mysqli_query($link,'SELECT * FROM InstActivity WHERE InstID='.$row['IID'].' ORDER BY Week DESC') or muoribene(mysqli_error($link),true); if (mysqli_num_rows($sres)>0) { $attr.='
      Stati: '.$tot['tstatuses'].'
      Accessi: '.$tot['tlogins'].'
      Registrazioni: '.$tot['tregs'].'
      '.N; while ($srow=mysqli_fetch_assoc($sres)) { $attr.='
      '.strftime('%e %b %Y',$srow['Week']).'
      '.N; ($tot['tstatuses']==0) ? $width=0 : $width=str_replace(',','.',100/$tot['tstatuses']*$srow['Statuses']); $attr.='
      '.$srow['Statuses'].' stati
      '.N; ($tot['tlogins']==0) ? $width=0 : $width=str_replace(',','.',100/$tot['tlogins']*$srow['Logins']); $attr.='
      '.$srow['Logins'].' accessi
      '.N; ($tot['tregs']==0) ? $width=0 : $width=str_replace(',','.',100/$tot['tregs']*$srow['Registrations']); $attr.='
      '.$srow['Registrations'].' registrazioni
      '.N; } } else { $attr.='
      Non disponibile
      '.N; } $attr.='
      Hashtags più usati durante l’ultima settimana
      '.N; $sres=mysqli_query($link,'SELECT * FROM InstTrends WHERE InstID='.$row['IID'].' ORDER BY Pos ASC') or muoribene(mysqli_error($link),true); if (mysqli_num_rows($sres)>0) { $attr.='
        '.N; while ($srow=mysqli_fetch_assoc($sres)) { $attr.='
      1. '.hspech($srow['Name']).'
        2. '.N; } $attr.='
      '.N; } else { $attr.='
      Non disponibili
      '.N; } $out.=''.N; $out.=''.N; $out.='
      AttributiInfo
      '.$row['URI']; if ($showcount) $out.=' ('.$finst.'/'.$cinsts.')'; $out.='
      '.$attr.''.N; if ($row['Blacklisted']>0) { $sres=mysqli_query($link,'SELECT * FROM Blacklist WHERE Domain=\''.myesc($link,$row['URI']).'\'') or muoribene(mysqli_error($link),true); if (mysqli_num_rows($sres)>0) { $srow=mysqli_fetch_assoc($sres); if (!is_null($srow['PublicComment']) && preg_match('/^\s*$/',$srow['PublicComment'])!==1) { $out.='
      Questa istanza è blacklistata per questo motivo: '.hspech($srow['PublicComment']).'
      '.N; } else { $out.='
      Questa istanza è blacklistata, ma nella blacklist non è specificato il motivo.
      '.N; } } else { $out.='
      Questa istanza risulta blacklistata nella tabella delle istanze, ma nella tabella “Blacklist” non è presente: probabilmente è stata rimossa dalla tabella “Blacklist” e il crawler non l’ha ancora aggiornata.
      '.N; } } $out.='
      '.$cols['Instances.URI']['name'].': '.$row['URI'].'
      '.N; $out.='
      '.$cols['Instances.Title']['name'].': '.nully($row['Title'],false,'strip').'
      '.N; $out.='
      '.$cols['Instances.Thumb']['name'].': '.nully($row['Thumb'],true,'image').'
      '.N; $out.='
      '.$cols['Instances.ShortDesc']['name'].': '.nully($row['ShortDesc'],true,'strip').'
      '.N; $out.='
      '.$cols['Instances.LongDesc']['name'].': '.nully($row['LongDesc'],true,'strip').'
      '.N; // 'strip' o 'htmlent' per la descrizione nostra? $out.='
      '.trimname($cols['Instances.OurDesc']['name']).': '.nully($row['OurDesc'],true,'strip').'
      '.N; $out.='
      '.trimname($cols['Instances.OurDescEN']['name']).': '.nully($row['OurDescEN'],true,'strip').'
      '.N; $out.='
      '.trimname($cols['Localities.Name']['name']).': '; if (!is_null($row['LocalityID'])) { $sres=mysqli_query($link,'SELECT * FROM Localities WHERE Localities.ID='.$row['LocalityID']) or muoribene(mysqli_error($link),true); $srow=mysqli_fetch_assoc($sres); $out.=hspech($srow['NameOrig']).'
      '.N; } else { $out.='Non definita'.N; } $sres=mysqli_query($link,'SELECT * FROM InstLangs LEFT JOIN Languages ON Languages.ID=LangID WHERE InstID='.$row['IID'].' ORDER BY Pos ASC') or muoribene(mysqli_error($link),true); if (mysqli_num_rows($sres)>0) { $i=0; $buf=array(); while ($srow=mysqli_fetch_assoc($sres)) { $i++; $buf[]=$i.': '.hspech($srow['Name'.$dlang].' ['.$srow['Code'].']'); } $out.='
      '.$cols['InstLangs']['name'].': '.implode('; ',$buf).'
      '.N; } else { $out.='
      '.$cols['InstLangs']['name'].': Non definite
      '.N; } $sres=mysqli_query($link,'SELECT * FROM InstOurLangs LEFT JOIN Languages ON Languages.ID=OurLangID WHERE InstID='.$row['IID'].' ORDER BY Pos ASC') or muoribene(mysqli_error($link),true); if (mysqli_num_rows($sres)>0) { $i=0; $buf=array(); while ($srow=mysqli_fetch_assoc($sres)) { $i++; $buf[]=$i.': '.hspech($srow['Name'.$dlang].' ['.$srow['Code'].']'); } $out.='
      '.trimname($cols['InstOurLangs']['name']).': '.implode('; ',$buf); } else { $out.='
      '.trimname($cols['InstOurLangs']['name']).': Non definite'; } ($row['OurLangsLock']>0) ? $out.=' (bloccate)' : $out.=' (non bloccate)'; $out.='
      '.N; $sres=mysqli_query($link,'SELECT * FROM InstFinancing LEFT JOIN Financing ON Financing.ID=FinID WHERE InstID='.$row['IID'].' ORDER BY Pos ASC') or muoribene(mysqli_error($link),true); if (mysqli_num_rows($sres)>0) { $i=0; $buf=array(); while ($srow=mysqli_fetch_assoc($sres)) { $i++; $buf[]=$i.': '.hspech($srow['Type']); } $out.='
      '.trimname($cols['InstFinancing']['name']).': '.implode('; ',$buf).'
      '.N; } else { $out.='
      '.trimname($cols['InstFinancing']['name']).': Non definite
      '.N; } $sres=mysqli_query($link,'SELECT * FROM InstPolicies LEFT JOIN Policies ON Policies.ID=PolID WHERE InstID='.$row['IID'].' ORDER BY Pos ASC') or muoribene(mysqli_error($link),true); if (mysqli_num_rows($sres)>0) { $i=0; $buf=array(); while ($srow=mysqli_fetch_assoc($sres)) { $i++; $buf[]=$i.': '.hspech($srow['Name']); } $out.='
      '.trimname($cols['InstPolicies']['name']).': '.implode('; ',$buf).'
      '.N; } else { $out.='
      '.trimname($cols['InstPolicies']['name']).': Non definite
      '.N; } $sres=mysqli_query($link,'SELECT * FROM InstTags LEFT JOIN Tags ON Tags.ID=TagID WHERE InstID='.$row['IID'].' ORDER BY Pos ASC') or muoribene(mysqli_error($link),true); if (mysqli_num_rows($sres)>0) { $i=0; $buf=array(); while ($srow=mysqli_fetch_assoc($sres)) { $i++; $buf[]=$i.': '.hspech($srow['Name']); } $out.='
      '.trimname($cols['InstTags']['name']).': '.implode('; ',$buf).'
      '.N; } else { $out.='
      '.trimname($cols['InstTags']['name']).': Non definite
      '.N; } if (!is_null($row['GuestID'])) { $guestinf='SI'; $sres=mysqli_query($link,'SELECT Email FROM Admins WHERE ID='.$row['GuestID']) or muoribene(__LINE__.': '.mysqli_error($link),true); $srow=mysqli_fetch_assoc($sres); $guestinf.=' ('.$srow['Email'].')'; } else { $guestinf='NO'; } $out.='
      Admin invitat*? '.$guestinf.'
      '.N; $out.='
      '.trimname($cols['Instances.LastGuestEdit']['name']).': '.nully($row['LastGuestEdit'],true,'timestamp').'
      '.N; $out.='
      '.$cols['Instances.Email']['name'].': '.nully($row['Email'],true,'email').'
      '.N; $out.='
      '.$cols['Instances.Software']['name'].': '.nully($row['Software'],false,'strip').'
      '.N; $out.='
      '.$cols['Instances.Version']['name'].': '.nully($row['Version'],true,'strip').'
      '.N; $out.='
      '.$cols['Instances.UserCount']['name'].': '.nully($row['UserCount'],false,'strip').'
      '.N; $out.='
      '.$cols['Instances.StatusCount']['name'].': '.nully($row['StatusCount'],false,'strip').'
      '.N; $out.='
      '.$cols['Instances.DomainCount']['name'].': '.nully($row['DomainCount'],false,'strip').'
      '.N; $out.='
      '.$cols['Instances.ActiveUsersMonth']['name'].': '.nully($row['ActiveUsersMonth'],false,'strip').'
      '.N; $out.='
      '.$cols['Instances.ActiveUsersHalfYear']['name'].': '.nully($row['ActiveUsersHalfYear'],false,'strip').'
      '.N; $out.='
      '.$cols['Instances.RegOpen']['name'].': '.nully($row['RegOpen'],false,'boolt').'
      '.N; $out.='
      '.$cols['Instances.RegReqApproval']['name'].': '.nully($row['RegReqApproval'],false,'boolf').'
      '.N; $out.='
      '.$cols['Instances.MaxTootChars']['name'].': '.nully($row['MaxTootChars'],false,'strip','500').'
      '.N; $out.='
      '.$cols['Instances.AdmAccount']['name'].': '.nully($row['AdmAccount'],false,'strip').'
      '.N; $out.='
      '.$cols['Instances.AdmDisplayName']['name'].': '.nully($row['AdmDisplayName'],false,'strip').'
      '.N; $out.='
      '.$cols['Instances.AdmCreatedAt']['name'].': '.nully($row['AdmCreatedAt'],true,'timestamp').'
      '.N; $out.='
      '.$cols['Instances.AdmURL']['name'].': '.nully($row['AdmURL'],true,'url').'
      '.N; $out.='
      '.$cols['Instances.AdmAvatar']['name'].': '.nully($row['AdmAvatar'],false,'image').'
      '.N; $out.='
      '.$cols['Instances.AdmNote']['name'].': '.nully($row['AdmNote'],false,'strip').'
      '.N; $out.='
      '.N; return($out); } ?>