CheckLogin()) { $fgmembersite->RedirectToURL("login.php"); exit; } if(!$fgmembersite->DBLogin()) { echo "Database Login failed! Please make sure that the DB login credentials provided are correct"; return false; } // Initialize variables $valid_formats = array( array("zip"), array("pdf", "PDF"), array("mpg", "mpeg", "mp4", "ogg", "mkv", "avi") ); $max_file_size = 1024 * 100000; //30 Mb $filenames = array('code_path', 'report_path', 'video_path'); if(isset($_POST) and $_SERVER['REQUEST_METHOD'] == "POST" and isset($_POST['fileupload'])) { // --------------- FILE UPLOAD ---------------- // $f_groupid = $_POST['idgroup']; $path = "uploads/group$f_groupid/"; // Upload directory $count = 0; // Loop $_FILES to execute all files foreach ($_FILES['files']['name'] as $f => $name) { $filename=$_FILES['files']['name'][$f]; if ($_FILES['files']['error'][$f] == 4) { continue; // Skip file if any error found } if ($_FILES['files']['error'][$f] == 0) { if ($_FILES['files']['size'][$f] > $max_file_size) { $fgmembersite->HandleError("File $name is too large!"); continue; // Skip large files } elseif( ! in_array(pathinfo($name, PATHINFO_EXTENSION), $valid_formats[$f]) ){ $fgmembersite->HandleError("File $name is not a valid format!"); continue; // Skip invalid file formats } else { // No error found! Move uploaded files if(move_uploaded_file($_FILES["files"]["tmp_name"][$f], $path.$name)) { $count++; // Number of successfully uploaded file $idx_name = $filenames[$f]; $qry = "select * from $fgmembersite->database.$fgmembersite->media_tab ". "where note = \"$idx_name\" and id_group=$f_groupid"; $result = mysql_query($qry, $fgmembersite->connection); if(!$result) { $fgmembersite->HandleDBError("Error inserting data to the table\nquery:$qry"); } else { if(mysql_num_rows($result) == 0) { $qry = "insert into $fgmembersite->database.$fgmembersite->media_tab ". " (name, id_group, note) ". " VALUES ". " (\"$path$name\", ". $f_groupid . ",". " \"$idx_name\")"; } else { $row = mysql_fetch_assoc($result); $filetoremove = $row['name']; $qry = "update $fgmembersite->database.$fgmembersite->media_tab ". "set name = \"$path$name\" ". "where note=\"$idx_name\" and id_group = $f_groupid"; } // echo "$qry
"; if(!mysql_query( $qry ,$fgmembersite->connection)) { $fgmembersite->HandleDBError("Error inserting data to the table\nquery:$qry"); } unlink($filetoremove); } } else { $fgmembersite->HandleError("Error uploading file $name."); } } } } } ?>
GetErrorMessage(); if (!empty($err_msg)) { ?>

Welcome back UserFullName(); ?>

This page provides an interface to all the functionalities related to the IEEE CIS competition. Here you can modify your personal infomation and manage your submissions.

If there are open competitions to which you can register, a button will appear in the gray bar right under this section. If you are already registered for a competition, you will instead be allowed to modify your submission at the bottom part of this page.

News

2016-06-30 Website for the 2016 IEEE CIS Studend Competition is up.

                     Theme: Interactive Web Learning Systems

2016-07-05 Sumbission for the IEEE 2016 Student Competition is now open.

database.$fgmembersite->comp_tab ". "where active=TRUE and id_comp not in ". "(select id_comp from ". "$fgmembersite->database.$fgmembersite->group_tab, $fgmembersite->database.$fgmembersite->usergroupconn_tab ". "where id_user=".$fgmembersite->UserId()." and $fgmembersite->group_tab.id_group= $fgmembersite->usergroupconn_tab.id_group)"; //echo $sql."
"; $result = mysql_query($sql, $fgmembersite->connection); if(!$result) { echo "Fallimento nell'esecuzione della query ($qry) dal DB: " . mysql_error(); exit; } if(mysql_num_rows($result) == 0) { $add_group = false; } else { $add_group = true; } ?>

WHAT YOU CAN DO

Modify personal info Register for the competition'; } ?>

database.$fgmembersite->usergroupconn_tab.id_group,". " $fgmembersite->group_tab.name as group_name, $fgmembersite->comp_tab.name as comp_name, materialdeadline, ". " id_teamleader". " FROM ". " $fgmembersite->database.$fgmembersite->usergroupconn_tab, $fgmembersite->database.$fgmembersite->group_tab,". " $fgmembersite->comp_tab". " where id_user=".$fgmembersite->UserId() . " and $fgmembersite->comp_tab.id_comp=$fgmembersite->group_tab.id_comp". " and $fgmembersite->usergroupconn_tab.id_group=$fgmembersite->group_tab.id_group". " order by $fgmembersite->comp_tab.materialdeadline desc"; //echo $qry; //echo "
"; $result = mysql_query($qry,$fgmembersite->connection); if (!$result) { echo "Fallimento nell'esecuzione della query ($qry) dal DB: " . mysql_error(); exit; } if (mysql_num_rows($result) == 0) { echo "

NO REGISTERED GROUP.

"; } else { //echo mysql_num_rows($result)."
"; while ($row = mysql_fetch_assoc($result)) { //echo $row['id_group'] ."
"; //Ottieni tutti i membri del gruppo $sql = "select $fgmembersite->user_tab.id_user, name, email, university, ieeecode ". "from $fgmembersite->database.$fgmembersite->user_tab, $fgmembersite->database.$fgmembersite->usergroupconn_tab ". "where ". "id_group=".$row['id_group'] . " and $fgmembersite->database.$fgmembersite->user_tab.id_user = $fgmembersite->database.$fgmembersite->usergroupconn_tab.id_user"; // echo $sql; // echo "
"; $res = mysql_query($sql,$fgmembersite->connection); if (!$res) { echo "Fallimento nell'esecuzione della query ($qry) dal DB: " . mysql_error(); exit; } //Visualizza i dati ?>
"; // echo "group name: ".$row['group_name']."
"; echo "

".$row['comp_name']."

"; // echo "competition name: ".$row['comp_name']."
"; // if ($row['id_teamleader'] == $fgmembersite->UserId()) { // echo "You are the team leader
"; // } else { // echo "Team Leader: ".$row['id_teamleader']."
"; // } ?>
"; echo "

Material Submission Deadline: ".$row['materialdeadline']."

"; echo "

Group Members:

"; echo ""; $UserNb = 1; while ($row2 = mysql_fetch_assoc($res)) { // echo $row2['id_user']." ".$row2['name']." ".$row2['email']." ".$row2['university']; echo ""; echo "";//" (".$row2['id_user'].")"; echo ""; echo ""; echo ""; echo ""; if ($row2['id_user'] == $row['id_teamleader']) { echo ""; } else { echo ""; } echo ""; $UserNb++; } ?>
# Name e-mail University IEEE code
".$UserNb."".$row2['name']."".$row2['email']."".$row2['university']."".$row2['ieeecode']."Leader

'>Modify group information

Files:

We expect to receive three documents: the source code, a description of the application and a video showing application features.
Several restrictions have been imposed on the file types and dimensions:

  • source code: a single zip file (maximum size of 100Mb)
  • report: a single pdf file (maximum size of 100Mb)
  • video: any video format with maximum size of 100Mb (supported files are "mpg", "mpeg", "mp4", "ogg", "mkv", "avi")

database.$fgmembersite->media_tab where id_group = $groupid"; $result_el = mysql_query( $qry ,$fgmembersite->connection); $code_file = ''; $report_file = ''; $video_file = ''; while ($row_el = mysql_fetch_assoc($result_el)) { if (strcmp($row_el['note'], $filenames[0]) == 0) $code_file=$row_el['name']; else if (strcmp($row_el['note'], $filenames[1]) == 0) $report_file=$row_el['name']; else if (strcmp($row_el['note'], $filenames[2]) == 0) $video_file= $row_el['name']; else { printf("Error unknown media type"); return; } } //printf("
query: %s
", $qry); //printf("code: %s
", $code_file); //printf("report: %s
", $report_file); //printf("video: %s
", $video_file); // if (date('Y-m-d H:i:s') < $matDeadline) { ?>
"; } else { echo ""; } ?> "; } else { echo ""; } ?> "; } else { echo ""; } ?>
Source Code: zip file '; } else { echo '

Missing file

'; } ?>
Report: pdf file '; } else { echo '

Missing file

'; } ?>
Video: any video format (max 100Mb) '; } else { echo '

Missing file

'; } ?>
'.basename($code_file).''; // } else { // echo 'Missing file'; // } ?> '.basename($report_file).''; // } else { // echo 'Missing file'; // } ?> '.basename($video_file).''; // } else { // echo 'Missing file'; // } ?>