'.$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.=' '.t('Questa istanza è blacklistata per questo motivo','This instance is blacklisted for this reason').': '.hspech($srow['PublicComment']).' '.N;
} else {
$out.=''.t('Questa istanza è blacklistata, ma nella blacklist non è specificato il motivo','This instance is blacklisted, but the blacklist entry doesn’t specify a reason').'. '.N;
}
} else {
$out.=''.t('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','This instance has the “Blacklisted” flag on, but it is not present in the “Blacklist” table: prabably it has been removed from there but the crawler has not yet updated its record').'. '.N;
}
}
$out.=''.N;
$out.=''.tc('Instances.Title').': '.nully($row['Title'],false,'strip').' '.N;
$out.=''.tc('Instances.Thumb').': '.nully($row['Thumb'],true,'image').' '.N;
$out.=''.tc('Instances.ShortDesc').': '.nully($row['ShortDesc'],true,'strip').' '.N;
$out.=''.tc('Instances.LongDesc').': '.nully($row['LongDesc'],true,'strip').' '.N;
// 'strip' o 'htmlent' per la descrizione nostra?
$out.=''.trimname(tc('Instances.OurDesc')).': '.nully($row['OurDesc'],true,'strip').' '.N;
$out.=''.trimname(tc('Instances.OurDescEN')).': '.nully($row['OurDescEN'],true,'strip').' '.N;
$out.=''.trimname(tc('Localities.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.=''.t('Non definita','Undefined').''.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);
$out.=''.tc('InstLangs').': ';
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.=implode('; ',$buf);
} else {
$out.=''.t('Non definite','Undefined').'';
}
$out.=' '.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);
$out.=''.trimname(tc('InstOurLangs')).': ';
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.=implode('; ',$buf);
} else {
$out.=''.t('Non definite','Undefined').'';
}
($row['OurLangsLock']>0) ? $out.=' ('.t('bloccate','locked').')' : $out.=' ('.t('non bloccate','not locked').')';
$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);
$out.=''.trimname(tc('InstFinancing')).': ';
if (mysqli_num_rows($sres)>0) {
$i=0;
$buf=array();
while ($srow=mysqli_fetch_assoc($sres)) {
$i++;
$buf[]=$i.': '.hspech($srow['Type']);
}
$out.=implode('; ',$buf);
} else {
$out.=''.t('Non definite','Undefined').'';
}
$out.=' '.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);
$out.=''.trimname(tc('InstPolicies')).': ';
if (mysqli_num_rows($sres)>0) {
$i=0;
$buf=array();
while ($srow=mysqli_fetch_assoc($sres)) {
$i++;
$buf[]=$i.': '.hspech($srow['Name']);
}
$out.=implode('; ',$buf);
} else {
$out.=''.t('Non definite','Undefined').'';
}
$out.=' '.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);
$out.=''.trimname(tc('InstTags')).': ';
if (mysqli_num_rows($sres)>0) {
$i=0;
$buf=array();
while ($srow=mysqli_fetch_assoc($sres)) {
$i++;
$buf[]=$i.': '.hspech($srow['Name']);
}
$out.=implode('; ',$buf);
} else {
$out.=''.t('Non definite','Undefined').'';
}
$out.=' '.N;
if (!is_null($row['GuestID'])) {
$guestinf=''.t('SI','YES').'';
$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.=''.t('Admin invitat*?','Admin has been invited?').' '.$guestinf.' '.N;
$out.=''.trimname(tc('Instances.LastGuestEdit')).': '.nully($row['LastGuestEdit'],true,'timestamp').' '.N;
$out.=''.tc('Instances.Email').': '.nully($row['Email'],true,'email').' '.N;
$out.=''.tc('Instances.Software').': '.nully($row['Software'],false,'strip').' '.N;
$out.=''.tc('Instances.Version').': '.nully($row['Version'],true,'strip').' '.N;
$out.=''.tc('Instances.UserCount').': '.nully($row['UserCount'],false,'strip').' '.N;
$out.=''.tc('Instances.StatusCount').': '.nully($row['StatusCount'],false,'strip').' '.N;
$out.=''.tc('Instances.DomainCount').': '.nully($row['DomainCount'],false,'strip').' '.N;
$out.=''.tc('Instances.ActiveUsersMonth').': '.nully($row['ActiveUsersMonth'],false,'strip').' '.N;
$out.=''.tc('Instances.ActiveUsersHalfYear').': '.nully($row['ActiveUsersHalfYear'],false,'strip').' '.N;
$out.=''.tc('Instances.RegOpen').': '.nully($row['RegOpen'],false,'boolt').' '.N;
$out.=''.tc('Instances.RegReqApproval').': '.nully($row['RegReqApproval'],false,'boolf').' '.N;
$out.=''.tc('Instances.MaxTootChars').': '.nully($row['MaxTootChars'],false,'strip','500').' '.N;
$out.=''.tc('Instances.AdmAccount').': '.nully($row['AdmAccount'],false,'strip').' '.N;
$out.=''.tc('Instances.AdmDisplayName').': '.nully($row['AdmDisplayName'],false,'strip').' '.N;
$out.=''.tc('Instances.AdmCreatedAt').': '.nully($row['AdmCreatedAt'],true,'timestamp').' '.N;
$out.=''.tc('Instances.AdmURL').': '.nully($row['AdmURL'],true,'url').' '.N;
$out.=''.tc('Instances.AdmAvatar').': '.nully($row['AdmAvatar'],false,'image').' '.N;
$out.=''.tc('Instances.AdmNote').': '.nully($row['AdmNote'],false,'strip').' '.N;
$out.=' |
'.N;
$out.='