<?

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

{

	global $db_users;
	global $db_images;
	global $db_exelp;
	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";

	$exel_enabled = "def_" . $flag . "_exel";
	$set_exel = "def_" . $flag . "_setexel";


	$sql = "SELECT selector, flag, category, prices, images, exel 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];

		}

	}


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

	$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;


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

	$results_amount_exel = mysql_numrows ( $ra );

	if ( (( $def_onlypaid == "YES" ) and ( $flag == "D") ) or ($$exel_enabled != "YES") or ( $results_amount_exel > $$set_exel ) )

	{

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

		{

			$fa = mysql_fetch_array ( $ra );

			@unlink($folder . "./exel/$fa[num].xls");
		}

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

	}

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

	$exelSQL = ", exel = 0";

	else

	$exelSQL = ", exel = " . $$set_exel;


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

	$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 $exelSQL 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>

<title>
<? IF ($incomingline == $def_catalogue ) {echo $def_title;} else
{
IF (!$incomingline_firm) {title ($incomingline);} else
{ echo $incomingline_firm . "-" . $def_title; }
}
?>
</title>
 <META http-equiv="Content-Type" content="text/html; charset=<? echo"$def_charset"; ?>">
 <META NAME="Description" CONTENT="<? echo "$descriptions_meta"; ?>" >
 <META NAME="Keywords" CONTENT="<? echo "$keywords_meta"; ?>">
 <META name="author" content="vkaragande.info">
 <META name="copyright" CONTENT="Copyright, vkaragande.info. All rights reserved">
 <META name="robots" CONTENT="index, follow">
 <META name="revisit-after" content="7 days">

 <? echo "$def_style"; ?>

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

</head>

<body>

<table width="1000" border="0" align="center" cellpadding="0" cellspacing="0" class="bodyborder">
  <tr>
    <td background="<? echo "$def_mainlocation/template/$def_template/images"; ?>/bg_tb.gif"><table width="1000" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td height="261" valign="top" background="<? echo "$def_mainlocation/template/$def_template/images"; ?>/header.jpg"><table width="998" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td style="padding-left:15px; padding-top:5px;"><img src="<? echo "$def_mainlocation/template/$def_template/images"; ?>/izbr.gif" width="20" height="20" align="absmiddle"><a href="javascript:window.external.AddFavorite('http://vkaragande.info/', 'Каталог организаций')" class="izbr">В избранное</a> </td>
            <td>&nbsp;</td>
            <td valign="top">&nbsp;</td>
          </tr>
          <tr>
            <td width="270" style="padding-left:15px; padding-top:25px;"><table width="240" border="0" cellspacing="0" cellpadding="0">
              
              <tr>
                <td align="left"><img src="<? echo "$def_mainlocation/template/$def_template/images"; ?>/menu_top_v.gif" width="22" height="22" align="absmiddle"><a href="<? echo "$def_mainlocation"; ?>/index.php" class="mainmenu">Главная</a></td>
              </tr>
              <tr>
                <td align="left"><img src="<? echo "$def_mainlocation/template/$def_template/images"; ?>/menu_top_v.gif" width="22" height="22" align="absmiddle"><a href="<? echo "$def_mainlocation"; ?>/viewstatic.php?vs=catalog" class="mainmenu">О каталоге</a> </td>
              </tr>
              <tr>
                <td align="left"><img src="<? echo "$def_mainlocation/template/$def_template/images"; ?>/menu_top_v.gif" width="22" height="22" align="absmiddle"><a href="<? echo "$def_mainlocation"; ?>/viewstatic.php?vs=info" class="mainmenu">Правила</a></td>
              </tr>
              <tr>
                <td align="left"><img src="<? echo "$def_mainlocation/template/$def_template/images"; ?>/menu_top_v.gif" width="22" height="22" align="absmiddle"><a href="<? echo "$def_mainlocation"; ?>/compare.php" class="mainmenu">Тарифные планы</a> </td>
              </tr>
              <tr>
                <td align="left"><img src="<? echo "$def_mainlocation/template/$def_template/images"; ?>/menu_top_v.gif" width="22" height="22" align="absmiddle"><a href="<? echo "$def_mainlocation"; ?>/ratingtop.php" class="mainmenu">Рейтинг компаний. ТОП20</a> </td>
              </tr>
              <tr>
                <td align="left"><img src="<? echo "$def_mainlocation/template/$def_template/images"; ?>/menu_top_v.gif" width="22" height="22" align="absmiddle"><a href="<? echo "$def_mainlocation"; ?>/stat.php" class="mainmenu">Статистика каталога</a> </td>
              </tr>
              <tr>
                <td align="left"><img src="<? echo "$def_mainlocation/template/$def_template/images"; ?>/menu_top_v.gif" width="22" height="22" align="absmiddle"><a href="<? echo "$def_mainlocation"; ?>/contact.php" class="mainmenu">Контакты</a></td>
              </tr>
              <tr>
                <td width="530">&nbsp;</td>
              </tr>
              <tr>
                <td width="530">&nbsp;</td>
              </tr>
            </table></td>
            <td>&nbsp;</td>
            <td width="200" valign="top"><table width="180" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td>&nbsp;</td>
              </tr>
              <tr>
                <td>&nbsp;</td>
              </tr>
              <tr>
                <td height="25" align="center" background="<? echo "$def_mainlocation/template/$def_template/images"; ?>/enter_login.gif"><a href="<? echo "$def_mainlocation"; ?>/user.php">Вход для клиентов</a></td>
              </tr>
              <tr>
                <td>&nbsp;</td>
              </tr>
              <tr>
                <td height="25" align="center" background="<? echo "$def_mainlocation/template/$def_template/images"; ?>/enter_reg.gif"><a href="<? echo "$def_mainlocation"; ?>/reg.php">Новая регистрация</a></td>
              </tr>
              <tr>
                <td>&nbsp;</td>
              </tr>
              <tr>
                <td align="left"><img src="<? echo "$def_mainlocation/template/$def_template/images"; ?>/pda.gif" width="18" height="18" align="absmiddle"><a href="<? echo "$def_mainlocation"; ?>/m/index.php">Мобильная версия</a></td>
              </tr>
              <tr>
                <td align="left"><img src="<? echo "$def_mainlocation/template/$def_template/images"; ?>/r_search.gif" width="18" height="18" align="absmiddle"><a href="<? echo "$def_mainlocation"; ?>/search.php">Расширенный поиск</a></td>
              </tr>
            </table></td>
          </tr>
          <tr>
            <td height="25" colspan="3" style="padding-left:5px;"><? include ("./includes/top_line.php"); ?></td>
            </tr>
        </table></td>
      </tr>
    </table>
      <table width="1000" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td><table width="1000" border="0" cellspacing="0" cellpadding="0">
            <tr>
              <td width="220" valign="top">

    <? include ( "./menu_basic.inc" ); ?>

    <div align=center><? if ( $def_banner2_allowed == "YES" ) include ("./banner.php"); ?></div><br><br>

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

    <? if ($def_kurs == "YES") include ("./kurs.php"); ?>

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

	      </td>
              <td valign="top" width="560">


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

   <br /> <a href=http://www.uafirms.com/view.php?id=2&amp;cat=17&amp;subcat=122&amp;subsubcat=0&amp;type=banner target=new> <img src=http://www.uafirms.com/./banner/2.gif border=0 alt=""><br /></a><br>

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


  <form name=login action="user.php?REQ=authorize" method=post>

<? main_table_top($def_user); ?>

  <br><table cellpadding=5 cellspacing=1 border=0 width="100%">
     <tr><td bgColor="#D0E4E2" align=right>Панель управления: <input type=text name=login style=\"width:$def_update_form_size;\" maxlength=100></td></tr>
     <tr><td bgColor="#D0E4E2" align=right>Пароль: <input type=password name=pass style=\"width:$def_update_form_size;\" maxlength=100></td></tr>

<script type="text/javascript"><!--
document.login.login.focus();
//--></script>

<tr><td align=right bgColor="#D8E7E2"><input type=submit value="Войти" name="inbut"></td></tr>

<tr><td align=center><br><a href="remind.php"><u>Напомнить пароль</u></a><br></td></tr>

<tr><td align=center></td></tr>

</table></form>
 

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

       <!-- FOOTER -->

</td>
              <td width="220" valign="top">

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

	<div align=center><? if ( $def_banner2_allowed == "YES" )	include ("./banner.php"); ?></div><br><br>

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

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

	<? if ($def_holidays == "YES") include("./holidays.php"); ?>

        <? include ("./options.php"); ?>

	      </td>
            </tr>
          </table></td>
        </tr>
        <tr>
          <td height="45"><table width="1000" border="0" cellspacing="0" cellpadding="0">
            <tr>
              <td width="500" align="left" style="padding-left:10px;"><a href="http://vkaragande.info/" target="_blank" title="Скрипт каталога организаций I-Soft Bizness">&copy; 2008 Каталог организаций</a></td>
              <td align="right" style="padding-right:10px;"><? if ($def_counter_images == "YES") {print "<a href=info.php target=_blank><img src=counter.php width=88 height=31 border=0></a>";} ?></td>
            </tr>
          </table></td>
        </tr>
      </table></td>
  </tr>
</table>

 </body>
</html>