Drupal: crowdsource features

<?php//$Id$/** * Implementation of _get_redirect_user * @param unknown $profile_type_label * @return string with links of profile type */function _get_redirect_user($profile_type_label) {    switch ($profile_type_label) {        case 'Requester':            $ss__label = t('A Requester');            $ss__link = 'requester';             break;         case 'Bidder':            $ss__label = t('A Bidder');            $ss__link = 'bidder';             break;      }          return  '<div><div class="user_label_class_teacher">' . l($ss__label, 'user/register/'. $ss__link) . '</div></div>'; }/** * Implementation of hook_form_alter * @param unknown $form * @param unknown $form_state * @param unknown $form_id */ function custom_form_alter(&$form, $form_state, $form_id) {    global $user;    switch ($form_id) {                case 'comment_node_request_content_form':                        if(isset($form['#node']) && $form['#node']->type == 'request_content') {                if($form['#node']->uid != $user->uid) {                    $sn__nid = $form['#node']->nid;                    $result = db_select('flag_content', 'fc')                            ->fields('fc', array('fcid'))                            ->condition('content_type', 'node')                            ->condition('content_id', $sn__nid)                            ->condition('uid', $user->uid)                            ->orderBy('timestamp', 'DESC')                            ->execute();                    $record = $result->fetchAssoc();                    if(empty($record['fcid'])) {                        $form['comment_body']['#access'] = 0;                        $form['actions']['submit']['#access'] = 0;                    }                                }            }                                break;        case 'bidder_content_node_form':            // hide combo box            $form['field_requesting_content']['und']['#prefix'] = '<div style="display:none;">';            $form['field_requesting_content']['und']['#suffix'] = '</div>';                        $sn__nid = arg(3);            if(arg(2) != 'edit') {                                if(empty($form['field_requesting_content']['und']['#default_value'])) {                    $form['field_requesting_content']['und']['#default_value'] =  array($sn__nid);                }                                    $query = db_select('comment', 'c');                $query->join('flag_content', 'fc', 'fc.content_id = c.cid');                $query->fields('c', array('nid'))                ->condition('fc.fid', 4, '=')//hard coded award bid flag id                  ->condition('c.nid', $sn__nid, '=')                ->condition('c.uid', $user->uid, '=');                                    $result = $query->execute();                                    $records = $result->fetchAssoc();                if(empty($records['nid'])) {                    drupal_access_denied();                }                // query for bidder can add content of request once                $query = db_select('node', 'n');                $query->join('field_data_field_requesting_content', 'fc', 'fc.field_requesting_content_nid = n.nid');                $query->fields('fc', array('entity_id'))                ->condition('n.nid', $sn__nid, '=')                ->condition('n.type', 'request_content', '=');                                    $result = $query->execute();                                    $records = $result->fetchAssoc();                                if(!empty($records['entity_id'])) {                    drupal_goto('node/' . $records['entity_id'] . '/edit');                }                            }                        $form['field_requesting_content']['und']['#disabled'] = TRUE;                        break;        case 'views_exposed_form':                        if(isset($form['flagged']) && !empty($form['flagged'])) {                $form['flagged']['#options'][1] = 'Success';                $form['flagged']['#options'][0] = 'Fail';            }                        break;                        default:            ;        break;    }}/** * Implementation of completed node type (_custom_check_completed_node)  * @param int $sn__nid * @return boolean */function _custom_check_completed_node($sn__nid) {    global $user;    $query = db_select('node', 'n');    $query->join('flag_content', 'fc', 'fc.content_id = n.nid');    $query->fields('n', array('nid'))    ->condition('fc.fid', 5, '=')//hard coded award bid flag id    ->condition('fc.content_type', 'node', '=')    ->condition('n.nid', $sn__nid, '=');            $result = $query->execute();            $records = $result->fetchAssoc();    if(empty($records['nid'])) {        return FALSE;    }    return TRUE;}/** * Implementation of awarde node type (_custom_check_awarded_node) * @param int $sn__nid * @param int $sn__cid * @return boolean */function _custom_check_awarded_node($sn__nid, $sn__cid = NULL) {    global $user;        $query = db_select('comment', 'c');    $query->join('flag_content', 'fc', 'fc.content_id = c.cid');    $query->fields('c', array('nid'))    ->condition('fc.fid', 4, '=')//hard coded award bid flag id    ->condition('fc.content_type', 'comment', '=')    ->condition('c.nid', $sn__nid, '=')    ;    //->condition('c.uid', $user->uid, '=');    ($sn__cid != NULL) ? $query->condition('fc.content_id', $sn__cid, '=') : '';                $result = $query->execute();    $records = $result->fetchAssoc();    if(empty($records['nid'])) {        return FALSE;    }    return TRUE;}/** * Implementation of hook_node_view_alter * @param unknown $build */function custom_node_view_alter(&$build) {    global $user;    if($build['#bundle'] == 'request_content') {        $sn__nid = $build['body']['#object']->nid;            $build['#node']->content['bidder_content_link'] = array(                    '#markup' => l(t('View Submitted Content'), 'bidder-content/' . $sn__nid),                    '#weight' => 10,            );            $build['#node']->content['submit_content_link'] = array(                    '#markup' => l(t(' Submit Content'), 'node/add/bidder-content/' . $sn__nid),                    '#weight' => 12,            );                if(_custom_check_awarded_node($sn__nid)) {            foreach ($build['comments']['comments'] as $key => $value) {                if(!_custom_check_awarded_node($sn__nid, $key)) {                    if(isset($build['comments']['comments'][$key]['links']['flag']))                        unset($build['comments']['comments'][$key]['links']['flag']);                                    }            }        }                        }    if($build['#bundle'] == 'bidder_content') {        $build['#node']->field_requesting_content['und'][0]['access'] = 1;    }}/** * Implementation of publish a node * publish content * @param Object $node */function _custom_publish_node($node) {        $sn__nid = $node->nid;    $query = db_select('node', 'n');    $query->join('field_data_field_requesting_content', 'fc', 'fc.field_requesting_content_nid = n.nid');    $query->fields('fc', array('entity_id'))    ->condition('n.nid', $sn__nid, '=')    ->condition('n.type', 'request_content', '=');            $result = $query->execute();                        $records = $result->fetchAssoc();    if(!empty($records['entity_id'])) {        //Update         $num_updated = db_update('node') // Table name no longer needs {}        ->fields(array(                'status' => 1,        ))        ->condition('nid', $records['entity_id'], '=')        ->execute();                $num_updated = db_update('node_revision') // Table name no longer needs {}        ->fields(array(                'status' => 1,        ))        ->condition('nid', $records['entity_id'], '=')        ->execute();    } }?>