'.$sql1.'
'.$mysqli->error); } if(isset($_POST['pleasefix']) && $_POST['pleasefix'] > '') { $mysqli->query('INSERT into '.db('pleasefix').' (chant_id,pleasefix,time,'.($logged_in ? 'user_id' : 'ip').') VALUES ('.$id.',"'.$mysqli->real_escape_string($_POST['pleasefix']).'",'.time().',"'.($logged_in ? $current_user->ID : $_SERVER['REMOTE_ADDR']).'")') or die('Erreur SQL !
'.$sql1.'
'.$mysqli->error); } $c_p = array(); $sql1 = 'SELECT * FROM '.db('chant_sources').' WHERE chant_id = '.$id.' ORDER BY source'; $req1 = $mysqli->query($sql1) or die('Erreur SQL !
'.$sql1.'
'.$mysqli->error); while ($s = $req1->fetch_assoc()) { $c_s = array($s['source'], $s['page']); if(is_dir('./sources/'.$s['source'])) { if(is_array($sources[$s['source']]['pages'])) { $p = array_search($s['page'],$sources[$s['source']]['pages']); } else { $p = $s['page']; } if($p !== false) { $c_p[] = array($s['source'], $s['page'], $p, intval($s['extent']), intval($s['sequence'])); } else { $c_p[] = $c_s; } } else { $c_p[] = $c_s; } } usort($c_p, function($a, $b) { global $sources; if($sources[$a[0]]['year'] == $sources[$b[0]]['year']) { // Date if($a[0] == $b[0]) { // Source if(count($a) > 2) { if($a[2] == $b[2]) { // Page return $a[4] <=> $b[4]; // Sequence } else { return $a[2] <=> $b[2]; } } else { return strnatcasecmp($a[1], $b[1]); } } else { return $a[0] <=> $b[0]; } } else { return $sources[$b[0]]['year'] <=> $sources[$a[0]]['year']; } }); echo '
'; if($c['copyrighted']) { echo 'This tune is still under copyright.'; } elseif($c['gabc'] > '') { echo '
'.$sql.'
'.$mysqli->error); echo '
'.format_incipit($title);
if($req->num_rows > 0) {
echo ' 
';
}
if($logged_in) {
echo ' Edit';
}
echo '
';
if($req->num_rows > 0) {
echo '"; echo '
'.nl2br(htmlspecialchars($fix['pleasefix']))."
Cantus ID
\n"; if($c['version'] > '') echo 'Version
- '.$c['version']."
Usage
- '.$txt['usage'][$c['office-part']]."
'.$sql.'
'.$mysqli->error); while ($t = $req->fetch_assoc()) { $sql1 = 'SELECT * FROM '.db('tags').' WHERE id = '.$t['tag_id']; $req1 = $mysqli->query($sql1) or die('Erreur SQL !
'.$sql1.'
'.$mysqli->error); $tt = $req1->fetch_assoc(); $tags[$tt['id']] = $tt['tag']; } natcasesort($tags); if(count($tags) > 0) { echo "
Tags
- \n";
foreach($tags as $t) echo "
- ".$t." \n"; echo "
Sources
\n- \n";
$cnt = 1;
foreach($c_p as $s) {
$source_label = "".$sources[$s[0]]['title'].", ".$sources[$s[0]]['editor'].", ".($sources[$s[0]]['period']?$sources[$s[0]]['period']:$sources[$s[0]]['year'])."".($s[1]>''?", p. ".$s[1]:'');
$urls = $sources[$s[0]]['urls'];
if (count($s) > 2) {
echo '
- '.$source_label." \n"; $sources_img .= '
- ".$source_label." \n"; } $cnt += 1; } echo "
'.$source_label." ";
$chants = array();
$sql1 = 'SELECT * FROM '.db('chant_sources').' WHERE `source` = "'.$s[0].'" ORDER BY sequence ASC';
$req1 = $mysqli->query($sql1) or die('Erreur SQL !
'.$sql1.'
'.$mysqli->error);
while($co = $req1->fetch_assoc()) {
$chants[$co['page']][] = array(intval($co['chant_id']),intval($co['sequence']),intval($co['extent']));
}
$prev = false;
if(array_search([$id,$s[4],$s[3]], $chants[$s[1]]) > 0) {
$prev = $chants[$s[1]][array_search([$id,$s[4],$s[3]], $chants[$s[1]])-1];
} elseif(is_array($sources[$s[0]]['pages'])) {
$j = $s[2];
while($j > 0) {
$j--;
if(array_key_exists($sources[$s[0]]['pages'][$j], $chants) && count($chants[$sources[$s[0]]['pages'][$j]]) > 0) {
$prev = end($chants[$sources[$s[0]]['pages'][$j]]);
break;
}
}
} else {
uksort($chants, 'strnatcmp');
// TODO
}
if($prev) $sources_img .= ' ◀';
$next = false;
if(count($chants[$s[1]]) > 1 && array_search([$id,$s[4],$s[3]], $chants[$s[1]]) < count($chants[$s[1]])-1) {
$next = $chants[$s[1]][array_search([$id,$s[4],$s[3]], $chants[$s[1]])+1];
} elseif(is_array($sources[$s[0]]['pages'])) {
$j = $s[2];
while($j < count($sources[$s[0]]['pages'])) {
$j++;
if(array_key_exists($sources[$s[0]]['pages'][$j], $chants) && count($chants[$sources[$s[0]]['pages'][$j]]) > 0) {
$next = $chants[$sources[$s[0]]['pages'][$j]][0];
break;
}
}
} else {
uksort($chants, 'strnatcmp');
// TODO
}
if($next) $sources_img .= ' ▶';
$sources_img .= "
\n";
for($i = 0; $i < max(1, $s[3]); $i++) {
if(is_array($urls)) $sources_img .= '';
$sources_img .= '.'.png)
';
if(is_array($urls)) $sources_img .= '';
$sources_img .= '
'."\n";
}
$sources_img .= "
\n"; } else { echo "
'.$sql1.'
'.$mysqli->error); $proof = array(); $proof_done = False; while ($r = $req1->fetch_assoc()) { $proof[] = $r; if($logged_in && $r['user_id'] == $current_user->ID) $proof_done = True; } if(count($proof) > 0 || $logged_in) { echo "
Proofread by:
\n- \n";
}
if($logged_in && !$proof_done) {
echo ''."\n";
}
foreach($proof as $r) {
$user_info = get_userdata($r['user_id']);
echo "
- ".$user_info->display_name." (".date("M d, Y",$r['time']).") \n"; } if(count($proof) > 0 || $logged_in) { echo "
$report_form
Download
\n- \n";
$content = json_decode($c['gabc']);
if(is_string($content)) {
echo '
- GABC '."\n"; } elseif(is_array($content)) { $gabcs = array(); foreach($content as $e) { if($e[0] == 'gabc') $gabcs[] = $e[1]; } if(count($gabcs) > 1) { echo "
- GABC
- ";
for($i = 0; $i < count($gabcs); $i++) {
echo '
- Element '.($i+1)." \n"; } echo "
\n";
} else {
echo ' - GABC '."\n"; } } foreach(array('pdf','svg','eps','png') as $a) { echo '
- '.strtoupper($a).' '."\n"; } echo "
- \n";
foreach(array('gabc','pdf','svg','eps','png') as $a) {
echo '
- '.strtoupper($a).' (1st verse only) '."\n"; } echo "
Open with external tool
\n- \n";
$gabc = (($c['office-part'] && $txt['usage_s'][$c['office-part']] > '')?'annotation: '.$txt['usage_s'][$c['office-part']]."\n":'');
$mode_r = False;
if($c['mode'] > '') {
if($c['mode'] == 'p') {
$mode = "T. pereg.";
} elseif(in_array($c['mode'], array('c','d','e'))) {
$mode = strtoupper($c['mode']).($c['mode_var']?' '.$c['mode_var']:'');
} else {
$mode = $c['mode'].($c['mode_var']?' '.$c['mode_var']:'');
}
}
if($mode) $gabc .= "annotation: $mode\n";
$gabc .= "%%\n";
$pure_gabc = '';
if(is_string($content)) {
$pure_gabc .= $content."\n";
} elseif(is_array($content)) {
foreach($content as $e) {
if($e[0] == 'gabc') $pure_gabc .= $e[1]."\n";
}
}
$gabc .= $pure_gabc;
echo '
- Source & Summit Editor
- Illuminare Score editor
- Neumz NABC Renderer '; echo "
Remarks
\n".nl2br($c['remarks'])."
\n"; } $sql1 = 'SELECT * FROM '.db('changesets').' WHERE chant_id = '.$c['id'].' ORDER BY time DESC'; $req1 = $mysqli->query($sql1) or die('Erreur SQL !'.$sql1.'
'.$mysqli->error); if($req1->num_rows > 0 || $c['transcriber'] > '') { echo "
History
\n- \n";
}
while ($m = $req1->fetch_assoc()) {
$user_info = get_userdata($m['user_id']);
echo "
- ".date("M d, Y",$m['time']).": ".htmlspecialchars($m['comment'])." (".$user_info->display_name.') ? \n"; } if($c['transcriber'] > '') { echo "
- Original transcriber: ".$c['transcriber']." \n"; } if($req1->num_rows > 0 || $c['transcriber'] > '') { echo "
\n"; echo $sources_img; echo ''; echo << SCRIPT; include('include/footer.php'); ?>