function mediaForm($form, &$form_state)
{
global $user;
$UID = $user->uid;
$params = drupal_get_query_parameters();
if (isset($params['MID'])) {
$MID = $form_state['MID'] = $params['MID'];
} else {
if (isset($form_state['MID'])) {
$MID = $form_state['MID'];
} else {
drupal_set_message('No media selected.', 'error');
return;
}
}
$media = dbGetMedia($MID);
if (isset($media['OID'])) {
$form_state['OID'] = $media['OID'];
}
$form['fields'] = array('#type' => 'fieldset', '#title' => t('Assign Media'));
$form['fields']['back'] = array('#prefix' => '<left>', '#limit_validation_errors' => array(), '#submit' => array('backToMedia'), '#type' => 'submit', '#value' => '⇦ Cancel Changes', '#attributes' => array('OnSubmit' => 'if(!confirm("Back?")){return false;}'), '#suffix' => '</left>');
$form['fields']['title'] = array('#prefix' => '<table id="table-fields"><tr><td>', '#type' => 'textfield', '#title' => t('Media Name'), '#suffix' => '</td>', '#default_value' => $media['title']);
$form['fields']['picture'] = array('#prefix' => '<td>', '#type' => 'item', '#markup' => '<img src="' . generateURL($media['FID']) . '" style="max-width:200px; width:auto; height:auto;">', '#suffix' => '</td></tr>');
$form['fields']['description'] = array('#prefix' => '<tr><td>', '#type' => 'textarea', '#title' => t('Description'), '#suffix' => '</td></tr>', '#default_value' => $media['description']);
$team = getCurrentTeam();
$teams = dbGetTeamsForUser($UID);
$form_state['teams'] = $teams;
$TID = $team['TID'];
$form_state['oldTID'] = $TID;
if (count($teams) != 1) {
$choices = array();
foreach ($teams as $userTeam) {
$choices[$userTeam['TID']] = $userTeam['number'];
}
$form['fields']['team'] = array('#prefix' => '<tr><td>', '#type' => 'select', '#title' => t('Team to be Associated With'), '#default_value' => $TID, '#options' => $choices, '#chosen' => true, '#suffix' => '</td></tr>', '#ajax' => array('callback' => 'modify', 'limit_validation_errors' => array(), 'wrapper' => 'div_OID_wrapper'));
} else {
$form['fields']['team'] = array('#markup' => '<tr><td></td></tr>');
}
$outreachList = dbGetOutreachListForTeam(getCurrentTeam()['TID']);
$form_state['outreachList'] = $outreachList;
if (empty($outreachList)) {
drupal_set_message("You don't have any outreaches to assign this to.", 'error');
drupal_goto($_SERVER['HTTP_REFERER']);
return;
}
$form['fields']['OID-header'] = array('#markup' => '<tr><td>');
$form['fields']['OID'] = array('#prefix' => '<div id="div_OID_wrapper">', '#type' => 'select', '#title' => t('Outreach Event to be Associated With'), '#default_value' => $media['OID'], '#validated' => true, '#options' => $form_state["outreachList"], '#chosen' => true, '#suffix' => '</div>');
$form['fields']['OID-footer'] = array('#markup' => '</td></tr>');
$form['fields']['remove'] = array('#prefix' => '<tr><td>', '#type' => 'submit', '#value' => t('Delete Picture'), '#limit_validation_errors' => array(), '#submit' => array("removeMediaFromForm"), '#attributes' => array('onclick' => 'if(!confirm("Are you sure you want to delete this file?")){return false;}'), '#suffix' => '</td>');
$form['fields']['submit'] = array('#prefix' => '<td style="text-align:right">', '#type' => 'submit', '#value' => t('Submit'), '#suffix' => '</td></tr>');
$form['tableFooter'] = array('#markup' => '</table>');
return $form;
}
function dbDeleteMedia($MID)
{
$media = dbGetMedia($MID);
$FID = $media['FID'];
$sql = "DELETE FROM media ";
$sql .= "WHERE MID = :MID LIMIT 1;";
$proxyFields = array(":MID" => $MID);
$result = db_query($sql, $proxyFields);
return $FID;
}
