deaprtment database design (1)

http://localhost/ubc_surgery_pub/demosite/
 http://139.173.32.21/ubc_surgery_pub/demosite/
http://myopia.sourceforge.net/
https://sites.google.com/site/2013webservernote/chapter-10-october-2013/chapter-10-1-3-department-publication-database
database name: ubc_surgery_pub
http://jiansenlucodelogger.blogspot.ca/2013/10/design-department-database.html  
C:\Users\jiansen\Desktop\CAS\jiansen_dir\www_cesei0_mobile\ubc_surgery_pub\scripts\manage\superadmin\index.php, line 483
change
/div>  
to  
</div>
C:\Users\jiansen\Desktop\CAS\jiansen_dir\www_cesei0_mobile\ubc_surgery_pub\scripts\manage\superadmin\querylog.php 
line 62 change
?><tr><td><a href="<?php echo $config[pageshomeurl] ?>manage/?action=edit&pubid=<?php echo $row['pubid'] ?>" target="_blank"><?php echo htmlspecialchars($row['pubid'])
to
?><tr><td><a href="<?php echo $config[pageshomeurl] ?>?action=edit&pubid=<?php echo $row['pubid'] ?>" target="_blank"><?php echo htmlspecialchars($row['pubid']) 
C:\Users\jiansen\Desktop\CAS\jiansen_dir\www_cesei0_mobile\ubc_surgery_pub\scripts\people\listallusers.php, line 26 change
 $line = "<li><a href='$config[pageshomeurl]?users%5B%5D=$row[userid]&action=search'><strong>$row[lastname]</strong>, $row[firstname]</a> <small>";
to
 $line = "<li><a href='$config[pageshomeurl]manage/?users%5B%5D=$row[userid]&action=search'><strong>$row[lastname]</strong>, $row[firstname]</a> <small>"; 

issue: how to convert authorlist to userlist in table ubc_surgery_pub.publications p; 

1)  http://localhost/ubc_surgery_pub/scripts/manage/
Add an entry: convert author list to user id.
C:\Users\jiansen\Desktop\CAS\jiansen_dir\www_cesei0_mobile\ubc_surgery_pub\scripts\manage\index.php, line 578 add
  <li><a href="./?action=convertauthor">Convert author list to user id (new)</a></li>
line 67 add
case 'convertauthor':
  require_once('superadmin/convertauthor.php');
  break; 
  C:\Users\jiansen\Desktop\CAS\jiansen_dir\www_cesei0_mobile\ubc_surgery_pub\scripts\manage\superadmin\querylog.php, line 62 change
    ?><tr><td><a href="<?php echo $config[pageshomeurl] ?>?action=edit&pubid=<?php echo $row['pubid'] ?>" target="_blank"><?php echo htmlspecialchars($row['pubid']);
to
    ?><tr><td><a href="<?php echo $config[pageshomeurl] ?>/manage/?action=edit&pubid=<?php echo $row['pubid'] ?>" target="_blank"><?php echo htmlspecialchars($row['pubid']);