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