<?

function switchcategories ($id, $value){
  global $db_users;	
  $sql = "update $db_users set max_categories = '$value' where selector = '$id' limit 1";
  mysql_query($sql) or die(mysql_error());
}

function switchmemberships ($selector, $flag, $section, $job)

{

	global $db_users;
	global $db_images;
	global $db_offers;
	global $db_category;
	global $db_subcategory;
	global $db_subsubcategory;

	if ($section == "admin") $folder = "../"; else $folder = "";

	include ($folder . "./conf/memberships.php");


	$logo_enabled = "def_" . $flag . "_logo";
	$banner_enabled = "def_" . $flag . "_banner";
	$banner2_enabled = "def_" . $flag . "_banner2";

	$images_enabled = "def_" . $flag . "_images";
	$set_images = "def_" . $flag . "_setimages";

	$products_enabled = "def_" . $flag . "_products";
	$set_products = "def_" . $flag . "_setproducts";

	$sql = "SELECT selector, flag, category, prices, images FROM $db_users
          WHERE selector = '$selector' LIMIT 1";

	$r = mysql_query ($sql);

	if ( !$r ) error ( "mySQL error", mysql_error() );

	$f = mysql_fetch_array ( $r );

	if ( $$logo_enabled != "YES" )

	{


		@unlink ( $folder . "./logo/$selector.gif" );
		@unlink ( $folder . "./logo/$selector.bmp" );
		@unlink ( $folder . "./logo/$selector.jpg" );
		@unlink ( $folder . "./logo/$selector.png" );

	}


	if ( ( $$banner_enabled != "YES" ) or (( $def_onlypaid == "YES" ) and ( $flag == "D" )) )

	{

		@unlink ( $folder . "./banner/$selector.gif" );
		@unlink ( $folder . "./banner/$selector.bmp" );
		@unlink ( $folder . "./banner/$selector.jpg" );
		@unlink ( $folder . "./banner/$selector.png" );

	}

	if ( ( $$banner2_enabled != "YES" ) or (( $def_onlypaid == "YES" ) and ($flag == "D" ) ) )

	{

		@unlink ( $folder . "./banner2/$selector.gif" );
		@unlink ( $folder . "./banner2/$selector.bmp" );
		@unlink ( $folder . "./banner2/$selector.jpg" );
		@unlink ( $folder . "./banner2/$selector.png" );

	}


	if ( ( $def_onlypaid == "YES" ) and ( $flag == "D" ) and ( $f[flag] != "D" ) and ($job == "cron") )

	{

		$category = explode (":", $f[category]);

		for ($index = 0; $index < count ( $category ); $index++)

		{

			$new_cat = explode ("#", $category[$index]);

			if ($new_cat[0] != $prev_cat)

			mysql_query("UPDATE $db_category SET fcounter = fcounter-1 where selector=$new_cat[0]") or die (mysql_error());

			if (($new_cat[1] != "") and ($new_cat[1] != "0") and ($new_cat[1] != $prev_subcat))

			mysql_query("UPDATE $db_subcategory SET fcounter = fcounter-1 where catsel=$new_cat[0] and catsubsel=$new_cat[1]") or die (mysql_error());

			if (($new_cat[1] != "") and ($new_cat[1] != "0") and ($new_cat[2] != "") and ($new_cat[2] != "0"))

			mysql_query("UPDATE $db_subsubcategory SET fcounter = fcounter-1 where catsel=$new_cat[0] and catsubsel=$new_cat[1] and catsubsubsel=$new_cat[2]") or die (mysql_error());

			$prev_cat=$new_cat[0];
			$prev_subcat=$new_cat[1];

		}

	}

        $sql = "SELECT * FROM $db_images where firmselector = '$selector'";
	$ra = mysql_query ($sql );
	if (!$ra) error ("mySQL error", mysql_error() . $sql );

	$results_amount_images = mysql_numrows ( $ra );

	if ( (( $def_onlypaid == "YES" ) and ( $flag == "D") ) or ($$images_enabled != "YES") or ( $results_amount_images > $$set_images ) )

	{

		for ( $i2=0; $i2<$results_amount_images; $i2++ )

		{

			$fa = mysql_fetch_array ( $ra );

			@unlink($folder . "./gallery/$fa[num].gif");
			@unlink($folder . "./gallery/$fa[num].bmp");
			@unlink($folder . "./gallery/$fa[num].jpg");
			@unlink($folder . "./gallery/$fa[num].png");

			@unlink($folder . "./gallery/$fa[num]-small.gif");
			@unlink($folder . "./gallery/$fa[num]-small.bmp");
			@unlink($folder . "./gallery/$fa[num]-small.jpg");
			@unlink($folder . "./gallery/$fa[num]-small.png");
		}

		mysql_query("DELETE FROM $db_images where firmselector='$selector'");

	}

	if ( ( ( $def_onlypaid == "YES" ) and ( $flag == "D" ) ) or ( $$images_enabled != "YES" ) )

	$imageSQL = ", images = 0";

	else

	$imageSQL = ", images = " . $$set_images;

        $sql = "SELECT * FROM $db_offers where firmselector = '$selector'";
	$ra = mysql_query ( $sql );
	if ( !$ra ) error ( "mySQL Errors", mysql_error() + $sql );

	$results_amount_products = mysql_numrows ( $ra );

	if ( ( ( $def_onlypaid == "YES" ) and ($flag == "D") ) or ( $results_amount_products > $$set_products ) )

	{

		for ( $i3=0; $i3<$results_amount_products; $i3++ )

		{

			$fa = mysql_fetch_array ( $ra );

			@unlink($folder . "./offer/$fa[num].gif");
			@unlink($folder . "./offer/$fa[num].bmp");
			@unlink($folder . "./offer/$fa[num].jpg");
			@unlink($folder . "./offer/$fa[num].png");

			@unlink($folder . "./offer/$fa[num]-small.gif");
			@unlink($folder . "./offer/$fa[num]-small.bmp");
			@unlink($folder . "./offer/$fa[num]-small.jpg");
			@unlink($folder . "./offer/$fa[num]-small.png");
		}

		mysql_query("DELETE FROM $db_offers where firmselector='$selector'");

	}


	if ( ( ( $def_onlypaid == "YES" ) and ( $flag == "D" ) ) or ( $$products_enabled != "YES" ) )

	$productSQL = ", prices = 0";

	else

	$productSQL = ", prices = " . $$set_products;


	if ($flag != "D")

	$date_upgrade = date ("Y-m-d");

	else

	$date_upgrade = "0";

	$date_changed = date ("Y-m-d");

	mysql_query ( "UPDATE $db_users SET flag='$flag', comment='Membership downgraded automatically from $f[flag] to $flag on $date_changed', date_upgrade='$date_upgrade' $productSQL $imageSQL WHERE selector='$selector'" ) or die (mysql_error());

}


function update_categories ($oldflag, $flag, $oldcategories, $newcategories, $section)

{

	global $db_category;
	global $db_subcategory;
	global $db_subsubcategory;

	if ($section == "admin") $folder = "../"; else $folder = "";

	include ($folder . "./conf/memberships.php");


 	if ( ( ( $def_onlypaid == "YES" ) and ($oldflag != "D") ) or ( $def_onlypaid != "YES" ) )


	{

		$category = explode (":", $oldcategories);

		for ($index = 0; $index < count ( $category ); $index++)

		{


			$new_cat = explode ("#", $category[$index]);

			if ( $new_cat[0] != $prev_cat )

			mysql_query ("UPDATE $db_category SET fcounter = fcounter-1 where selector=$new_cat[0]");

			if (($new_cat[1] != "") and ($new_cat[1] != "0") and ($new_cat[1] != $prev_subcat))

			mysql_query ("UPDATE $db_subcategory SET fcounter = fcounter-1 where catsel=$new_cat[0] and catsubsel=$new_cat[1]");

			if (($new_cat[1] != "") and ($new_cat[1] != "0") and ($new_cat[2] != "") and ($new_cat[2] != "0"))

			mysql_query ("UPDATE $db_subsubcategory SET fcounter = fcounter-1 where catsel=$new_cat[0] and catsubsel=$new_cat[1] and catsubsubsel=$new_cat[2]");

			$prev_cat=$new_cat[0];
			$prev_subcat=$new_cat[1];

		}

	}

unset($prev_cat);
unset($prev_subcat);

	$index_category = 1;

	for ($index = 0; $index < count ( $newcategories ); $index++)

	{

		if ($newcategories[$index] != "") {

			$category_index[$index_category] = $newcategories[$index];$index_category++;


			if ( ( ( $def_onlypaid == "YES" ) and ( $flag != "D" ) ) or ( $def_onlypaid != "YES" ) )

			{


				$new_cat = explode ("#", $newcategories[$index]);

				if ($new_cat[0] != $prev_cat)

				mysql_query ("UPDATE $db_category SET fcounter = fcounter+1 where selector=$new_cat[0]");

				if (($new_cat[1] != "") and ($new_cat[1] != "0") and ($new_cat[1] != $prev_subcat))

				mysql_query ("UPDATE $db_subcategory SET fcounter = fcounter+1 where catsel=$new_cat[0] and catsubsel=$new_cat[1]");

				if (($new_cat[1] != "") and ($new_cat[1] != "0") and ($new_cat[2] != "") and ($new_cat[2] != "0"))

				mysql_query ("UPDATE $db_subsubcategory SET fcounter = fcounter+1 where catsel=$new_cat[0] and catsubsel=$new_cat[1] and catsubsubsel=$new_cat[2]");

			}

			$prev_cat=$new_cat[0];
			$prev_subcat=$new_cat[1];

		}

	}

	@ $category = join(":", $category_index);

	return $category;

}
?><? include ("includes/common_header.php"); ?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html dir="ltr">
 <head>

 <META name="author" content="domain.com">
 <META name="copyright" CONTENT="Copyright, domain.com. All rights reserved">
 <META name="robots" CONTENT="index, follow">
 <META name="revisit-after" content="7 days">

 <META http-equiv="Content-Type" content="text/html; charset=<? echo"$def_charset"; ?>">

 <? echo "$def_style"; ?>

  <title>

  <? title ($incomingline); ?>

  </title>

 <? include ("includes/js.php"); ?>

 </head>

<body>

 <table width="100%" cellspacing="0" class="bodyborder" cellpadding="0" border="0">
  <tr>
   <td valign="top" align="left" width="100%">

   <table width="100%" cellspacing="0" cellpadding="0" border="0">
    <tr>
     <td width="100%" align="left" valign="top">

     <? include ("includes/top_line.php"); ?>

      <table width="100%" cellspacing="0" cellpadding="0" border="0">
       <tr>
        <td align="left" valign="top"><div align="center"><a href="http://www.bodymindexpo.com"><img src="images/header_finder.jpg" alt="Yoga Search" width="612" height="163" border="0"></a><br>         
              <br>        
        </div></td>
        </tr>
      </table>    

     </td>
    </tr>

    <tr>
     <td valign="middle" align="left" width="100%" bgcolor="<? echo "$def_help_background"; ?>">

   <table width="100%" cellspacing="0" cellpadding="0" border="0">
    <tr>
     <td valign="top" align="center" width="20%">

    <? include ( "menu.inc" ); ?>

    <? if ( $def_banner2_allowed == "YES" ) include ("banner.php"); ?>

    <? if ($def_top_categories_show == "YES") include ("topcats.php"); ?>

    <? if ($def_last10show == "YES") include ("last.php"); ?>

   <br />

  </td>
  <td valign="top" align="center" width="60%" bgcolor="#FFFFFF">

 
 <table cellpadding="0" cellspacing="0" border="0" width="100%">
  <tr>
   <td valign="middle" align="center" width="100%">

   
   </td>
  </tr>
 </table>

     <!-- HEADER END -->
<br><br><center><b>NOTE: <font color=red>*</font> Required Fields</center></b><br>
<center><br><b>Contact Form</b><br><br>
<table cellpadding=1 cellspacing=0 border=0 width=450>
<form action="contact.php?REQ=send" ENCTYPE="multipart/form-data" method=post>
<tr><td align=right colspan=2><br></td></tr>
<tr><td align=right width=40%>Name: <font color=red>*</font></td><td align=left width=60%></font>&nbsp;<input type=text name=name  value="<? echo "$_POST[name]"; ?>" maxlength=50 size=35></td></tr>
<tr><td align=right width=40%>Phone: &nbsp;&nbsp;</td><td align=left width=60%></font>&nbsp;<input type=text name=phone  value="<? echo "$_POST[phone]"; ?>" maxlength=50 size=35></td></tr>
<tr><td align=right width=40%>E-mail: <font color=red>*</font></td><td align=left width=60%></font>&nbsp;<input type=text name=mail maxlength=50  value="<? echo "$_POST[mail]"; ?>" size=35><br></td></tr>
<tr><td align=right width=40%>Where did you find us?: &nbsp;&nbsp;</td><td align=left width=60%></font>&nbsp;<select name=search><option value=...>Select one
<option value="Alltheweb" <? if ($_POST[search] == "Alltheweb") echo "SELECTED";?>>Alltheweb
<option value="AltaVista" <? if ($_POST[search] == "AltaVista") echo "SELECTED";?>>AltaVista
<option value="America Online" <? if ($_POST[search] == "America Online") echo "SELECTED";?>>America Online
<option value="AOLFind" <? if ($_POST[search] == "AOLFind") echo "SELECTED";?>>AOLFind
<option value="Ask Jeeves" <? if ($_POST[search] == "Ask Jeeves") echo "SELECTED";?>>Ask Jeeves
<option value="Excite" <? if ($_POST[search] == "Excite") echo "SELECTED";?>>Excite
<option value="Google" <? if ($_POST[search] == "Google") echo "SELECTED";?>>Google
<option value="Go" <? if ($_POST[search] == "Go") echo "SELECTED";?>>Go
<option value="Goto" <? if ($_POST[search] == "Goto") echo "SELECTED";?>>Goto
<option value="Other" <? if ($_POST[search] == "Other") echo "SELECTED";?>>Other</td></tr>
<tr><td align=right width=40%>Interested In: <font color=red>*</font></td><td align=left width=60%></font>&nbsp;<input type=radio name=interest value=Advertising <? if ($_POST[interest] == "Advertising") echo "CHECKED";?>>Advertising<br>&nbsp;<input type=radio name=interest value=Listing <? if ($_POST[interest] == "Listing") echo "CHECKED";?>>Listing<br></td></tr>
<tr><td align=middle width=100% colspan=2><br>Comments / Questions:<br><br></td></tr>
<tr><td align=middle width=100% colspan=2><textarea name=text cols=60 rows=10><? echo "$_POST[text]"; ?></textarea><br></td></tr>

<tr><td align=right colspan=2><input type=submit name="inbut" value="Send" border=0></td></tr>
</form></table><br>
<br>
<br>
       <!-- FOOTER -->

       </td>
       <td valign="top" align="center" width="20%">

	<? include ("help.php"); ?>

	<? if ( $def_banner2_allowed == "YES" )	include ("banner.php"); ?>

	<? if ($def_featured_show == "YES") include("featured.php"); ?>

        <? if ($def_top10show == "YES") include("top.php"); ?>

        <br />

       </td>
      </tr>
     </table>

        <br />
        <br />

     </td>
    </tr>

    <tr>
     <td width="100%" height="1" bgcolor=#DADADA>
      <img src="<? echo "$def_mainlocation/template/$def_template/images/"; ?>pixel.gif" alt=""><br>
     </td>
    </tr>

    <tr>
     <td colspan=3 width="100%" >

  <div align=center>

   <br /> 

   BodyMindExpo.com

     All Rights Reserved.
   <br />

	All logos and trademarks in this site are property 
	of their respective owners.

       <br />
       <a href="http://www.ivisionx.com" target="_blank">website design</a> and <a href="http://www.ivisionx.com" target="_blank">web development</a> by Visionx Media Solutions <br />
      <br />


  </div>

   </td>
  </tr>
 </table>

 </body>
</html>

<pre>
</pre>