<?php
##############################################################
# FILENAME  : acp_rivals_edit_subladders.php
# COPYRIGHT : (c) 2008, Tyler N. King <aibotca@yahoo.ca>
# http://opensource.org/licenses/gpl-license.php GNU Public License
##############################################################
if ( !defined ( 'IN_PHPBB' ) )
{
	exit;
}

/**
 * Edit Sub-Ladders
 * Called from acp_rivals with mode == 'edit_subladders'
 */
function acp_rivals_edit_subladders ( $id, $mode, $u_action )
{
	global	$config, $db, $user, $auth, $template;
	global	$phpbb_root_path, $phpbb_admin_path, $phpEx;

	$submit		= request_var ( 'submit', '' );
	$ladder_id	= request_var ( 'ladder_id', 0 );

	// Are we submitting a form?
	if ( !empty ( $submit ) )
	{
		// Yes, handle the form.
		$delete		= request_var ( 'delete', 0 );

		// Are we deleting?
		if ( !empty ( $delete ) )
		{
			// Yes. Delete the ladder.
			$sql	= "DELETE FROM " . LADDERS_TABLE . " WHERE ladder_id = " . $ladder_id;
			$db->sql_query ( $sql );

			// Now, remove the clans from the ladder.
			$sql	= "DELETE FROM " . CLANDATA_TABLE . " WHERE clan_ladder = " . $ladder_id;
			$db->sql_query ( $sql );

			// Completed. Let the user know.
			trigger_error ( 'LADDER_UPDATED' );
		}

		$ladder_name	= $db->sql_escape ( utf8_normalize_nfc ( request_var ( 'ladder_name', '', true ) ) );
		$ladder_desc	= $db->sql_escape ( utf8_normalize_nfc ( request_var ( 'ladder_desc', '', true ) ) );

		// Update the ladder.
		$sql	= "UPDATE " . LADDERS_TABLE . " SET ladder_name = '$ladder_name', ladder_desc = '$ladder_desc' WHERE ladder_id = " . $ladder_id;
		$db->sql_query ( $sql );
	}
	else
	{
		$move	= request_var ( 'move', 0 );

		// Moving a ladder position.
		if ( !empty ( $move ) )
		{
			re_order ( $move, $ladder_id );
			trigger_error ( 'LADDER_MOVED' );
		}

		// Get the sub-ladders and order them.
		$sql	= "SELECT * FROM " . LADDERS_TABLE . " WHERE ladder_parent <> 0 ORDER BY subladder_order ASC";
		$result	= $db->sql_query ( $sql );

		while ( $row = $db->sql_fetchrow ( $result ) )
		{
			// Assign each sub-ladder to the template.
			$template->assign_block_vars ( 'block_subladders', array (
				'U_ACTION' => $u_action,
				'U_MOVEUP' => $u_action . '&amp;move=up&amp;ladder_id=' . $row[ 'ladder_id' ],
				'U_MOVEDOWN' => $u_action . '&amp;move=down&amp;ladder_id=' . $row[ 'ladder_id' ],
				'LADDER_NAME' => $row[ 'ladder_name' ],
				'LADDER_DESC' => $row[ 'ladder_desc' ],
				'LADDER_ID' => $row[ 'ladder_id' ],
				'LADDER_PARENT' => $row[ 'ladder_id' ] )
			);
		}
	}
}

?>