Index: /trunk/www/dch/memberlist.php =================================================================== --- /trunk/www/dch/memberlist.php (revision 18887) +++ /trunk/www/dch/memberlist.php (revision 18887) @@ -0,0 +1,80 @@ + + + + + FACT Project + + +\n"; + echo "
\n"; + echo "FACT Collaboration status of date "; + printf("\n", $date); + echo " \n"; + + include ("db.php"); + $db_id = mysql_connect($host, $user, $pw); + + //without institute: + //select username, Date(Min(start)) as 'from', if(Max(stop)='2020-12-31 + //23:59:59', 'unlimited', Date(Max(stop))) as 'until', + //Date(Adddate(Min(start), interval 6 MONTH)) as 'author since', + //if(Max(stop)='2020-12-31 23:59:59', 'unlimited', + //Date(Adddate(Max(stop), interval 1 year))) as 'author until' from + //members where not isnull(start) and not isnull(stop) group by username; + + $query="SELECT username, Date(start) AS 'from', if(stop='2020-12-31 23:59:59', 'unlimited', Date(stop)) AS 'until',"; + $query.=" DATE(ADDDATE(start, INTERVAL 6 MONTH)) AS 'author since', "; + $query.=" IF(stop='2020-12-31 23:59:59', 'unlimited', DATE(ADDDATE(stop, INTERVAL 1 YEAR))) AS 'author until', "; + $query.=" institutename, MID(username, LOCATE(' ', username)+1) AS surname, "; + $query.=" MID(username, 1, LOCATE(' ', username)) AS firstname "; + $query.=" FROM memberlist.members LEFT JOIN memberlist.institutes USING(instituteid) "; + $query.=" WHERE NOT start='0000-00-00 00:00:00' AND NOT stop='0000-00-00 00:00:00' "; + $querycurrent=$query." AND ADDDATE(start, INTERVAL 6 MONTH) < '".$date."' AND ADDDATE(stop, INTERVAL 1 YEAR) > '".$date."' "; + $querycurrent=$querycurrent." ORDER BY surname"; + $queryall=$query." ORDER BY surname"; + + echo "
\n
\n"; + echo "

Current Author List:

\n"; + echo "\n"; + echo "\n"; + echo "\n"; + $result = mysql_query($querycurrent); + while ($row = mysql_fetch_row($result)) + echo ""; + echo "\n"; + echo "
SurnameFirstnameinstitute
".$row[6]."".$row[7]."".$row[5]."
\n
\n"; + mysql_free_result($result); + + echo "
\n
\n"; + echo "

Full list:

\n"; + echo "\n"; + echo "\n"; + $result = mysql_query($queryall); + echo "\n"; + while ($row = mysql_fetch_row($result)) + echo ""; + echo "\n"; + echo "
NameInstituteMember sinceMember untilAuthor sinceAuthor until
".$row[0]."".$row[5]."".$row[1]."".$row[2]."".$row[3]."".$row[4]."
\n
\n"; + mysql_free_result($result); + + mysql_close($db_id); + + echo "
\n"; + echo "\n"; + echo "\n"; + +?>