<?php

ob_start();

include("ajax_db_connec.php");



if($_REQUEST['topic']=="valid_cat_name")

{

	if($_REQUEST['screen'] != "")

	{

			$qry="select cat_name from classified_cat_masters  where cat_name='".$_REQUEST['screen']."'";

			$cat_name_exists=mysql_num_rows(mysql_query($qry));

			if($cat_name_exists>0)

			{

				$str = ob_get_clean();

				echo "Classified category name already exists";

				echo $str."^chkcatname";

			}

	}

 }

 if($_REQUEST['topic']=="valid_cat_name_edit")

{

	if($_REQUEST['screen'] != "")

	{

			$qry="select cat_name from classified_cat_masters  where cat_name = '".$_POST['screen']."' and cat_name not in ('".$_POST['prev']."')";

			$cat_name_exists=mysql_num_rows(mysql_query($qry));

			if($cat_name_exists>0)

			{

				$str = ob_get_clean();

				echo "Classified category name already exists";

				echo $str."^chkcatnameedit";

			}

	}

 }

 if($_REQUEST['topic']=="valid_subcat_name")

{

	if($_REQUEST['screen'] != "")

	{

			$qry="select cat_name from classified_cat_masters  where cat_name='".$_REQUEST['screen']."'";

			$cat_name_exists=mysql_num_rows(mysql_query($qry));

			if($cat_name_exists>0)

			{

				$str = ob_get_clean();

				echo "Classified sub category name already exists";

				echo $str."^chksubcatname";

			}

	}

 }

 if($_REQUEST['topic']=="valid_subcat_name_edit")

{

	if($_REQUEST['screen'] != "")

	{

			$qry="select cat_name from classified_cat_masters  where cat_name = '".$_POST['screen']."' and cat_name not in ('".$_POST['prev']."')";

			$cat_name_exists=mysql_num_rows(mysql_query($qry));

			if($cat_name_exists>0)

			{

				$str = ob_get_clean();

				echo "Classified sub category name already exists";

				echo $str."^chksubcatnameedit";

			}

	}

 }

if($_REQUEST['topic']=="valid_abuse")

{

	if($_REQUEST['screen'] != "")

	{

			$qry="select words from abusive_words  where words='".$_REQUEST['screen']."'";

			$cat_name_exists=mysql_num_rows(mysql_query($qry));

			if($cat_name_exists>0)

			{

				$str = ob_get_clean();

				echo "Abusive word already exists";

				echo $str."^chkabusive";

			}

	}

 }

?>