Changeset 19962


Ignore:
Timestamp:
May 20, 2020, 6:24:40 PM (3 months ago)
Author:
dorner
Message:
added information on who is also in magic
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/www/dch/memberlist.php

    r19098 r19962  
    102102    //members where not isnull(start) and not isnull(stop) group by username;
    103103
    104     $selectcurrent="SELECT userid, firstname, middlename, lastname, inst.institutename, also.institutefullname, inst.institutefullname, inst.instituteadresse ";
     104    $selectcurrent="SELECT userid, firstname, middlename, lastname, inst.institutename, also.institutefullname, inst.institutefullname, inst.instituteadresse, alsomagic ";
    105105    $selectall="SELECT username, Date(start) AS 'from', if(stop='2020-12-31 23:59:59', 'unlimited', Date(stop)) AS 'until',";
    106106    $selectall.=" DATE(ADDDATE(start, INTERVAL 6 MONTH)) AS 'author since', ";
     
    123123        break;
    124124    }
    125     $selectlist.="inst.institutename, also.institutefullname, inst.institutefullname, inst.instituteadresse  ";
     125    $selectlist.="inst.institutename, also.institutefullname, inst.institutefullname, inst.instituteadresse, alsomagic ";
    126126    $from=" FROM memberlist.members ";
    127127    $join=" LEFT JOIN memberlist.institutes inst USING(instituteid) ";
     
    162162//    echo $querylist."<br>\n<br>\n";
    163163    echo $_GET["corresponding"];
    164     echo "<h3>Current Author List:</h3>\n";
     164    $result  = mysql_query($querycurrent);
     165    $num_rows = mysql_num_rows($result);
     166    echo "<h3>Current Author List: ".$num_rows." authors</h3>\n";
    165167    echo "<table border='1'>\n";
    166     echo "<thead><tr><th>*</th><th>First Middle Lastname</th><th>Institute (#)</th><th>also at</th></tr></thead>\n";
     168    echo "<thead><tr><th>*</th><th>First Middle Lastname</th><th>Institute (#)</th><th>also at</th><th>also MAGIC</th></tr></thead>\n";
    167169    echo "<tbody>\n";
    168     $result  = mysql_query($querycurrent);
    169170    $counter=0;
    170171    $letter=a;
     
    196197                $letter++;
    197198            }
    198             echo "<td>".$row[5]." (".array_search($row[5], $alsos).") </td></tr>";
    199         }
     199            echo "<td>".$row[5]." (".array_search($row[5], $alsos).") </td>";
     200        }
     201        else
     202            echo "<td></td>";
     203        if ($row[8])
     204            echo "<td>y</td></tr>";
    200205        else
    201206            echo "<td></td></tr>";
     
    282287    else
    283288        echo "<input type=radio name='textformat' value='text'> text <br>";
     289    if ($_GET["magic"]=="on")
     290        echo "<input type=checkbox name='magic' checked> show magic <br>";
     291    else
     292        echo "<input type=checkbox name='magic'> show magic <br>";
    284293    echo "<br><input type='submit' value='Get List'>\n";
    285294    echo "</form>\n";
     
    315324        if ($row[2])
    316325            echo GetSup($textformat, array_search($row[2], $alsos));
     326        if ($_GET["magic"]=="on" && $row[5])
     327            echo GetSup($textformat, "*");
    317328        echo GetEndl($textformat, ",");
    318329    }
     
    341352            if ($row[2])
    342353                echo GetSup($textformat, array_search($row[2], $alsos));
     354            if ($row[5])
     355                echo GetSup($textformat, "*");
    343356            echo GetEndl($textformat, ",");
    344357        }
     
    350363    foreach ($alsos as $num => $name)
    351364        echo GetSup($textformat, $num)." also at ".GetBla($textformat, $name).GetEndl($textformat, "");
     365    if ($_GET["magic"]=="on")
     366        echo GetSup($textformat, "*")." also in MAGIC ";
    352367
    353368
Note: See TracChangeset for help on using the changeset viewer.