PHP get_relationships_to_update Examples

Example #1

File: news_to_image_sorting.php Project: hunter2814/reason_package

        }
    }
    if (add_is_sortable_column($test_mode)) {
        if ($test_mode) {
            echo '<p>Would have added is_sortable column to the allowable relationship table</p>';
        } else {
            echo '<p>Added is_sortable column to the allowable_relationships table</p>';
        }
    }
    $result = update_allowable_relationship($left_side_entity_type, $right_side_entity_type, $relationship_type, $test_mode);
    if ($test_mode) {
        echo '<p>Would have set is_sortable in the allowable relationships table to "yes"</p>';
    } else {
        echo '<p>Set is_sortable in the allowable relationship table for ' . $relationship_type . ' relationship to "yes"</p>';
    }
    $process_array = get_relationships_to_update($left_side_entity_type, $right_side_entity_type, $relationship_type, $left_side_relation_limiter, $ordering);
    $count = 0;
    if ($test_mode) {
        echo 'Would have updated ' . count($process_array) . ' relationships:';
    } else {
        foreach ($process_array as $k => $v) {
            $q = 'UPDATE relationship SET rel_sort_order=' . $v . ' WHERE id=' . $k;
            db_query($q, 'could not update relationship');
            $count++;
        }
        if ($count > 0) {
            echo 'Updated ' . $count . ' relationships:';
        }
    }
    pray($process_array);
} else {

Example #2

File: text_blurb_reorient.php Project: hunter2814/reason_package

function do_action2($test_mode = true)
{
    $left_side_entity_type = 'minisite_page';
    $right_side_entity_type = 'text_blurb';
    $relationship_type = 'minisite_page_to_text_blurb';
    $left_side_relation_limiter = '';
    $ordering = 'sortable.sort_order ASC';
    $rel_sort_order_array = get_relationships_to_update($left_side_entity_type, $right_side_entity_type, $relationship_type, $left_side_relation_limiter, $ordering);
    $count = set_rel_sort_order($rel_sort_order_array, $test_mode);
    if ($test_mode) {
        echo '<p>Would establish sort order for ' . $count . ' relationships</p>';
    } else {
        echo '<p>Established sort order for ' . $count . ' relationships</p>';
    }
    pray($rel_sort_order_array);
}