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; }