<?php require('config.php'); require('macros.php');
      require('../share/SRC/assign.php'); 
list ($home,$url,$users,$assign,$msg,$host,$sql,$MYCookie,$applet,$os)=courseAll();
$user_nbr=getaUserNbr($$MYCookie);
list ($user_name,$user_home,$user_url,$user_profile)=userid($user_nbr);

myheader("Assignments",'..',$myPermit);

if ($please_check=="t"){	       	# ----- Update $chk database
  $db=SQLconnect($host, $sql);
  $cmd="SELECT as_id FROM assignments WHERE profile='$user_profile';";
  $assignment=SQLquery($db,$cmd);
  for ($row=0; $row < SQLnumrows($assignment); $row++) {
    $as = SQLobject ($assignment, $row);
    $chk="chk".str_replace(".","_",$as->as_id);
    if ($$chk=="" || $$chk=="f") 
      $$chk="0";
    else
      $$chk="1";
    $cmd = "UPDATE solutions SET checkme = '".$$chk."' ".
           "WHERE (sol_id='$as->as_id' AND user_nbr = $user_nbr);";
    $r=SQLquery($db,$cmd);
  }
  SQLclose($db);
  echo "
    <b>Thank you: your request has been submitted.</b> All the assignments 
    where the <i>CheckMe</i> button is pushed will be checked as soon as
    possible and in accordance with the service provided in your learning 
    scheme.<br>";
}

assign($$MYCookie,$please_check);
myfooter($user_nbr,'..',$myPermit);
?>
