$(document).ready(function(){
													 					    
	$("#clear-all").click(function(){
		$("p#result").remove();
		$("#oldurl").val()='';
		$("#newurl").val()='';
		return false;
	});
	
	$("#cform-submit").click(function(){					   				   
		$(".error").hide();
		var hasError = false;
		var emailReg = /^([\w-\.]+@([\w-]+\.)+[\w-]{2,4})?$/;
		
		var oldurlVal = $("#oldurl").val();
		
		if((oldurlVal == '')) {
			$("#oldurl1").addClass("red-error");
			$("#oldurl").addClass("red-error");
			hasError = true;
		}else{
			$("#oldurl1").removeClass("red-error");
			$("#oldurl").removeClass("red-error");
		}
		
		var newurlVal = $("#newurl").val();
		
		if((newurlVal == '')) {
			$("#newurl1").addClass("red-error");
			$("#newurl").addClass("red-error");
			hasError = true;
		}else{
			$("#newurl1").removeClass("red-error");
			$("#newurl").removeClass("red-error");
		}
				
			
		var templateurlVal = $("#templateurl").val();
		
		var imageVal = '<li class="loading"><img src="'+templateurlVal+'/images/loading.gif" alt="Loading" id="loading" /></li>';
				
		
		if(hasError == false) {
			
			$("p#result").remove();
			
			var output = 
			
			'<p id="result">UPDATE wp_comments SET comment_author_url = REPLACE(comment_author_url, \''+oldurlVal+'\', \''+newurlVal+'\');<br>UPDATE wp_options SET option_value = REPLACE(option_value, \''+oldurlVal+'\', \''+newurlVal+'\');<br>UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, \''+oldurlVal+'\', \''+newurlVal+'\');<br>UPDATE wp_posts SET post_content = REPLACE(post_content, \''+oldurlVal+'\', \''+newurlVal+'\');<br>UPDATE wp_posts SET post_excerpt = REPLACE(post_excerpt, \''+oldurlVal+'\', \''+newurlVal+'\');<br>UPDATE wp_posts SET guid = REPLACE(guid, \''+oldurlVal+'\', \''+newurlVal+'\');<br>UPDATE wp_usermeta SET meta_value = REPLACE(meta_value, \''+oldurlVal+'\', \''+newurlVal+'\');<br>UPDATE wp_users SET user_email = REPLACE(user_email, \''+oldurlVal+'\', \''+newurlVal+'\');<br>UPDATE wp_users SET user_url = REPLACE(user_url, \''+oldurlVal+'\', \''+newurlVal+'\');</p>';
			
					
			$("form#mysql").after(output);
			
			
		} else {
			
			$("p.buttons").after('<li class="error">* Please enter all the fields correctly</li>');
		}
		
		return false;
	});						   
});