$$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; } ?> <? IF ($incomingline == $def_catalogue ) {echo $def_title;} else { IF (!$incomingline_firm) {title ($incomingline);} else { echo $incomingline_firm . "-" . $def_title; } } ?> "> " > ">
/bg_tb.gif">
/header.jpg">
/izbr.gif" width="20" height="20" align="absmiddle">В избранное    
/menu_top_v.gif" width="22" height="22" align="absmiddle">/index.php" class="mainmenu">Главная
/menu_top_v.gif" width="22" height="22" align="absmiddle">/viewstatic.php?vs=catalog" class="mainmenu">О каталоге
/menu_top_v.gif" width="22" height="22" align="absmiddle">/viewstatic.php?vs=info" class="mainmenu">Правила
/menu_top_v.gif" width="22" height="22" align="absmiddle">/compare.php" class="mainmenu">Тарифные планы
/menu_top_v.gif" width="22" height="22" align="absmiddle">/ratingtop.php" class="mainmenu">Рейтинг компаний. ТОП20
/menu_top_v.gif" width="22" height="22" align="absmiddle">/stat.php" class="mainmenu">Статистика каталога
/menu_top_v.gif" width="22" height="22" align="absmiddle">/contact.php" class="mainmenu">Контакты
 
 
 
 
 
/enter_login.gif">/user.php">Вход для клиентов
 
/enter_reg.gif">/reg.php">Новая регистрация
 
/pda.gif" width="18" height="18" align="absmiddle">/m/index.php">Мобильная версия
/r_search.gif" width="18" height="18" align="absmiddle">/search.php">Расширенный поиск






Панель управления:
Пароль:

Напомнить пароль


© 2008 Каталог организаций ";} ?>