'.$dir.'scores.php GregoBase A database of gregorian scores '; $start = array_key_exists('start-index', $_GET)?intval($_GET['start-index']):0; $max = array_key_exists('max-results', $_GET)?intval($_GET['max-results']):50; $sql1 = 'SELECT * FROM '.db('changesets').' ORDER BY `time` DESC LIMIT '.$start.','.$max; $req1 = $mysqli->query($sql1) or die('Erreur SQL !
'.$sql1.'
'.$mysqli->error); $m = $req1->fetch_assoc(); echo ''.date(DATE_ATOM,$m['time']).' '; $user_info = get_userdata($m['user_id']); echo ' '.chant_from_id($m['chant_id'])[1].' '.htmlspecialchars($m['comment']).' '.date(DATE_ATOM,$m['time']).' '.$user_info->display_name.' '.$dir.'history.php?changeset='.$m['time'].'%7C'.$m['chant_id'].'%7C'.$m['user_id'].' '; while($m = $req1->fetch_assoc()) { $t = chant_from_id($m['chant_id']); if($t) { $user_info = get_userdata($m['user_id']); echo ' '.$t[1].' '.htmlspecialchars($m['comment']).' '.date(DATE_ATOM,$m['time']).' '.$user_info->display_name.' '.$dir.'history.php?changeset='.$m['time'].'%7C'.$m['chant_id'].'%7C'.$m['user_id'].' '; } } echo '
'; ?>