$db=@mysql_connect($bdhost,$bdlogin,$bdpass);
mysql_query ("set character_set_client='cp1251'");
mysql_query ("set character_set_results='cp1251'");
mysql_query ("set collation_connection='cp1251_general_ci'");
mysql_select_db($bdname,$db);
// адрес страницы
$tadress = ''; // Пока результат пуст
$default_port = 80; // Порт по-умолчанию
// А не в защищенном-ли мы соединении?
if (isset($_SERVER['HTTPS']) && ($_SERVER['HTTPS']=='on')) {
// В защищенном! Добавим протокол...
$tadress .= 'https://';
// ...и переназначим значение порта по-умолчанию
$default_port = 443;
} else {
// Обычное соединение, обычный протокол
$tadress .= 'https://';
}
// Имя сервера, напр. site.com или www.site.com
$tadress .= $_SERVER['SERVER_NAME'];
// А порт у нас по-умолчанию?
if ($_SERVER['SERVER_PORT'] != $default_port) {
// Если нет, то добавим порт в URL
$tadress .= ':'.$_SERVER['SERVER_PORT'];
}
// Последняя часть запроса (путь и GET-параметры).
$tadress .= $_SERVER['REQUEST_URI'];
$tadress=ereg_replace('\/$','',$tadress);
// адрес страницы
// метатеги
$result = @mysql_query("SELECT * FROM $seotable where page='$tadress' order by ID LIMIT 1");
if (mysql_num_rows($result) != 0)
{
while($myrow=mysql_fetch_array($result)) {
$metatitle_top=$myrow["metatitle"];
$metadescription_top=$myrow["metadescription"];
$metakeywords_top=$myrow["metakeywords"];
}
if ($metatitle_top != '' and $metatitle == '') {echo "
$metatitle_top";}
if ($metadescription_top != '' and $metadescription == '') {echo "";}
if ($metakeywords_top != '' and $metakeywords == '') {echo "";}
}
if ($metatitle_top == '' and $metatitle == '' and $metatitledef != '') {echo "$metatitledef";}
// start wseo canonical
$wscanonical = 'https://' . $_SERVER['HTTP_HOST'] . str_replace('index.php', '', $_SERVER['REQUEST_URI']);
?>
bootstrap.min.css" as="style" onload="this.onload=null;this.rel='stylesheet'">
main.css?v=1" as="style" onload="this.onload=null;this.rel='stylesheet'">
flexslider.css" as="style" onload="this.onload=null;this.rel='stylesheet'">
$n = getenv('REQUEST_URI');
if ($deltext == 'TRUE')
{
// окончание срока за 3 дня
/*
$res1 = @mysql_query("SELECT * FROM $vactable WHERE (status != 'archive' and (date + INTERVAL 86400*(period-$sendletterperiod) SECOND) < now()) and sended = '0000-00-00 00:00:00' and (top = '0000-00-00 00:00:00' and bold = '0000-00-00 00:00:00' and block = '0000-00-00 00:00:00' and topblock = '0000-00-00 00:00:00')");
while ($myrow=@mysql_fetch_array($res1))
{
$blockID1=$myrow["ID"];
$blockaid1=$myrow["aid"];
$profecy_top=$myrow["profecy"];
$blocktxt1="Здравствуйте! Заканчивается срок размещения вакансии \"$profecy_top\" на сайте $siteadress
Вакансия будет переведена в архив через $sendletterperiod дня";
$result1 = @mysql_query("SELECT * FROM $autortable where ID=$blockaid1");
while ($myrow1=mysql_fetch_array($result1)) {
$blockemail1=$myrow1["email"];
}
mail($blockemail1,"Окончание размещения вакансии через $sendletterperiod дня",$blocktxt1,"From: $adminemail\nReturn-Path:$adminemail\nMime-Version: 1.0\nContent-Type: text/html; charset=windows-1251\nContent-Transfer-Encoding:8bit\n");
$delvac=mysql_query("update $vactable SET sended=now() where ID=$blockID1");
}
*/
// окончание срока за 3 дня
// окончание срока за 3 дня базовый
$res1 = @mysql_query("SELECT * FROM $vactable WHERE (base != '0000-00-00 00:00:00' and (base + INTERVAL 86400*(periodforbase-$sendletterperiod) SECOND) < now()) and sendedbase = '0000-00-00 00:00:00'");
while ($myrow=@mysql_fetch_array($res1))
{
$blockID1=$myrow["ID"];
$blockaid1=$myrow["aid"];
$profecy_top=$myrow["profecy"];
$blocktxt1="Здравствуйте! Заканчивается срок базового статуса вакансии \"$profecy_top\" на сайте $siteadress
Услуга будет отключена через $sendletterperiod дня";
$result1 = @mysql_query("SELECT * FROM $autortable where ID=$blockaid1");
while ($myrow1=mysql_fetch_array($result1)) {
$blockemail1=$myrow1["email"];
}
mail($blockemail1,"Окончание поднятия вакансии через $sendletterperiod дня",$blocktxt1,"From: $adminemail\nReturn-Path:$adminemail\nMime-Version: 1.0\nContent-Type: text/html; charset=windows-1251\nContent-Transfer-Encoding:8bit\n");
$delvac=mysql_query("update $vactable SET sendedbase=now() where ID=$blockID1");
}
// окончание срока за 3 дня базовый
// окончание срока за 3 дня TOP
$res1 = @mysql_query("SELECT * FROM $vactable WHERE (top != '0000-00-00 00:00:00' and (top + INTERVAL 86400*(periodfortop-$sendletterperiod) SECOND) < now()) and sendedtop = '0000-00-00 00:00:00'");
while ($myrow=@mysql_fetch_array($res1))
{
$blockID1=$myrow["ID"];
$blockaid1=$myrow["aid"];
$profecy_top=$myrow["profecy"];
$blocktxt1="Здравствуйте! Заканчивается срок поднятия вакансии \"$profecy_top\" на сайте $siteadress
Услуга будет отключена через $sendletterperiod дня";
$result1 = @mysql_query("SELECT * FROM $autortable where ID=$blockaid1");
while ($myrow1=mysql_fetch_array($result1)) {
$blockemail1=$myrow1["email"];
}
mail($blockemail1,"Окончание поднятия вакансии через $sendletterperiod дня",$blocktxt1,"From: $adminemail\nReturn-Path:$adminemail\nMime-Version: 1.0\nContent-Type: text/html; charset=windows-1251\nContent-Transfer-Encoding:8bit\n");
$delvac=mysql_query("update $vactable SET sendedtop=now() where ID=$blockID1");
}
// окончание срока за 3 дня TOP
// окончание срока за 3 дня BOLD
$res1 = @mysql_query("SELECT * FROM $vactable WHERE (bold != '0000-00-00 00:00:00' and (bold + INTERVAL 86400*(periodforbold-$sendletterperiod) SECOND) < now()) and sendedbold = '0000-00-00 00:00:00'");
while ($myrow=@mysql_fetch_array($res1))
{
$blockID1=$myrow["ID"];
$blockaid1=$myrow["aid"];
$profecy_top=$myrow["profecy"];
$blocktxt1="Здравствуйте! Заканчивается срок выделения вакансии \"$profecy_top\" на сайте $siteadress
Услуга будет отключена через $sendletterperiod дня";
$result1 = @mysql_query("SELECT * FROM $autortable where ID=$blockaid1");
while ($myrow1=mysql_fetch_array($result1)) {
$blockemail1=$myrow1["email"];
}
mail($blockemail1,"Окончание выделения вакансии через $sendletterperiod дня",$blocktxt1,"From: $adminemail\nReturn-Path:$adminemail\nMime-Version: 1.0\nContent-Type: text/html; charset=windows-1251\nContent-Transfer-Encoding:8bit\n");
$delvac=mysql_query("update $vactable SET sendedbold=now() where ID=$blockID1");
}
// окончание срока за 3 дня BOLD
// окончание срока за 3 дня BLOCK
$res1 = @mysql_query("SELECT * FROM $vactable WHERE (block != '0000-00-00 00:00:00' and (block + INTERVAL 86400*(periodforblock-$sendletterperiod) SECOND) < now()) and sendedblock = '0000-00-00 00:00:00'");
while ($myrow=@mysql_fetch_array($res1))
{
$blockID1=$myrow["ID"];
$blockaid1=$myrow["aid"];
$profecy_top=$myrow["profecy"];
$blocktxt1="Здравствуйте! Заканчивается срок выделения вакансии \"$profecy_top\" на сайте $siteadress
Услуга будет отключена через $sendletterperiod дня";
$result1 = @mysql_query("SELECT * FROM $autortable where ID=$blockaid1");
while ($myrow1=mysql_fetch_array($result1)) {
$blockemail1=$myrow1["email"];
}
mail($blockemail1,"Окончание выделения вакансии через $sendletterperiod дня",$blocktxt1,"From: $adminemail\nReturn-Path:$adminemail\nMime-Version: 1.0\nContent-Type: text/html; charset=windows-1251\nContent-Transfer-Encoding:8bit\n");
$delvac=mysql_query("update $vactable SET sendedblock=now() where ID=$blockID1");
}
// окончание срока за 3 дня BLOCK
// окончание срока за 3 дня TOPBLOCK
$res1 = @mysql_query("SELECT * FROM $vactable WHERE (topblock != '0000-00-00 00:00:00' and (topblock + INTERVAL 86400*(periodfortopblock-$sendletterperiod) SECOND) < now()) and sendedtopblock = '0000-00-00 00:00:00'");
while ($myrow=@mysql_fetch_array($res1))
{
$blockID1=$myrow["ID"];
$blockaid1=$myrow["aid"];
$profecy_top=$myrow["profecy"];
$blocktxt1="Здравствуйте! Заканчивается срок выделения вакансии \"$profecy_top\" на сайте $siteadress
Услуга будет отключена через $sendletterperiod дня";
$result1 = @mysql_query("SELECT * FROM $autortable where ID=$blockaid1");
while ($myrow1=mysql_fetch_array($result1)) {
$blockemail1=$myrow1["email"];
}
mail($blockemail1,"Окончание выделения вакансии через $sendletterperiod дня",$blocktxt1,"From: $adminemail\nReturn-Path:$adminemail\nMime-Version: 1.0\nContent-Type: text/html; charset=windows-1251\nContent-Transfer-Encoding:8bit\n");
$delvac=mysql_query("update $vactable SET sendedtopblock=now() where ID=$blockID1");
}
// окончание срока за 3 дня TOPBLOCK
// Блокировка вакансии базовая
$delres=mysql_query("update $vactable set basedate='0000-00-00 00:00:00' where base='0000-00-00 00:00:00'");
$res1 = @mysql_query("SELECT * FROM $vactable WHERE (base != '0000-00-00 00:00:00' and (base + INTERVAL 86400*(periodforbase) SECOND) < now())");
while ($myrow=@mysql_fetch_array($res1))
{
$blockID=$myrow["ID"];
$blockaid1=$myrow["aid"];
$profecy_top=$myrow["profecy"];
$result1 = @mysql_query("SELECT * FROM $autortable where ID=$blockaid1");
while ($myrow1=mysql_fetch_array($result1)) {
$blockemail1=$myrow1["email"];
}
$blocktxt="Здравствуйте! Закончился срок размещения вакансии \"$profecy_top\" на сайте $siteadress
";
mail($blockemail1,"Окончание размещения вакансии",$blocktxt,"From: $adminemail\nReturn-Path:$adminemail\nMime-Version: 1.0\nContent-Type: text/html; charset=windows-1251\nContent-Transfer-Encoding:8bit\n");
$delres=mysql_query("update $vactable set base='0000-00-00 00:00:00',basedate='0000-00-00 00:00:00',sendedbase='0000-00-00 00:00:00' where ID='$blockID'");
}
// Блокировка вакансии базовая
// Блокировка вакансии
//$res1 = @mysql_query("SELECT * FROM $vactable WHERE status != 'archive' and (date + INTERVAL 86400*period SECOND) < now() and top = '0000-00-00 00:00:00' and bold = '0000-00-00 00:00:00' and block = '0000-00-00 00:00:00' and base = '0000-00-00 00:00:00' and topblock = '0000-00-00 00:00:00'");
$res1 = @mysql_query("SELECT * FROM $vactable WHERE status = 'ok' and top = '0000-00-00 00:00:00' and bold = '0000-00-00 00:00:00' and block = '0000-00-00 00:00:00' and base = '0000-00-00 00:00:00' and topblock = '0000-00-00 00:00:00'");
while ($myrow=@mysql_fetch_array($res1))
{
$blockID=$myrow["ID"];
$blockaid1=$myrow["aid"];
$profecy_top=$myrow["profecy"];
$result1 = @mysql_query("SELECT * FROM $autortable where ID=$blockaid1");
while ($myrow1=mysql_fetch_array($result1)) {
$blockemail1=$myrow1["email"];
}
$blocktxt="Здравствуйте! Закончился срок размещения вакансии \"$profecy_top\" на сайте $siteadress
Вакансия переведена в архив";
mail($blockemail1,"Окончание размещения вакансии",$blocktxt,"From: $adminemail\nReturn-Path:$adminemail\nMime-Version: 1.0\nContent-Type: text/html; charset=windows-1251\nContent-Transfer-Encoding:8bit\n");
$delres=mysql_query("update $vactable set status='archive',archivedate = now(),sended='0000-00-00 00:00:00' where ID='$blockID'");
}
// Блокировка вакансии
// Блокировка вакансии TOP
$delres=mysql_query("update $vactable set topdate='0000-00-00 00:00:00' where top='0000-00-00 00:00:00'");
$res1 = @mysql_query("SELECT * FROM $vactable WHERE (top != '0000-00-00 00:00:00' and (top + INTERVAL 86400*(periodfortop) SECOND) < now())");
while ($myrow=@mysql_fetch_array($res1))
{
$blockID=$myrow["ID"];
$blockaid1=$myrow["aid"];
$profecy_top=$myrow["profecy"];
$result1 = @mysql_query("SELECT * FROM $autortable where ID=$blockaid1");
while ($myrow1=mysql_fetch_array($result1)) {
$blockemail1=$myrow1["email"];
}
$blocktxt="Здравствуйте! Закончился срок поднятия вакансии \"$profecy_top\" на сайте $siteadress
";
mail($blockemail1,"Окончание поднятия вакансии",$blocktxt,"From: $adminemail\nReturn-Path:$adminemail\nMime-Version: 1.0\nContent-Type: text/html; charset=windows-1251\nContent-Transfer-Encoding:8bit\n");
$delres=mysql_query("update $vactable set top='0000-00-00 00:00:00',topdate='0000-00-00 00:00:00',sendedtop='0000-00-00 00:00:00' where ID='$blockID'");
}
// Блокировка вакансии TOP
// Блокировка вакансии BOLD
$res1 = @mysql_query("SELECT * FROM $vactable WHERE (bold != '0000-00-00 00:00:00' and (bold + INTERVAL 86400*(periodforbold) SECOND) < now())");
while ($myrow=@mysql_fetch_array($res1))
{
$blockID=$myrow["ID"];
$blockaid1=$myrow["aid"];
$profecy_top=$myrow["profecy"];
$result1 = @mysql_query("SELECT * FROM $autortable where ID=$blockaid1");
while ($myrow1=mysql_fetch_array($result1)) {
$blockemail1=$myrow1["email"];
}
$blocktxt="Здравствуйте! Закончился срок выделения вакансии \"$profecy_top\" на сайте $siteadress
";
mail($blockemail1,"Окончание выделения вакансии",$blocktxt,"From: $adminemail\nReturn-Path:$adminemail\nMime-Version: 1.0\nContent-Type: text/html; charset=windows-1251\nContent-Transfer-Encoding:8bit\n");
$delres=mysql_query("update $vactable set bold='0000-00-00 00:00:00',sendedbold='0000-00-00 00:00:00' where ID='$blockID'");
}
// Блокировка вакансии BOLD
// Блокировка вакансии BLOCK
$res1 = @mysql_query("SELECT * FROM $vactable WHERE (block != '0000-00-00 00:00:00' and (block + INTERVAL 86400*(periodforblock) SECOND) < now())");
while ($myrow=@mysql_fetch_array($res1))
{
$blockID=$myrow["ID"];
$blockaid1=$myrow["aid"];
$profecy_top=$myrow["profecy"];
$result1 = @mysql_query("SELECT * FROM $autortable where ID=$blockaid1");
while ($myrow1=mysql_fetch_array($result1)) {
$blockemail1=$myrow1["email"];
}
$blocktxt="Здравствуйте! Закончился срок выделения вакансии \"$profecy_top\" на сайте $siteadress
";
mail($blockemail1,"Окончание выделения вакансии",$blocktxt,"From: $adminemail\nReturn-Path:$adminemail\nMime-Version: 1.0\nContent-Type: text/html; charset=windows-1251\nContent-Transfer-Encoding:8bit\n");
$delres=mysql_query("update $vactable set block='0000-00-00 00:00:00',sendedblock='0000-00-00 00:00:00' where ID='$blockID'");
}
// Блокировка вакансии BLOCK
// Блокировка вакансии TOPBLOCK
$res1 = @mysql_query("SELECT * FROM $vactable WHERE (topblock != '0000-00-00 00:00:00' and (topblock + INTERVAL 86400*(periodfortopblock) SECOND) < now())");
while ($myrow=@mysql_fetch_array($res1))
{
$blockID=$myrow["ID"];
$blockaid1=$myrow["aid"];
$profecy_top=$myrow["profecy"];
$result1 = @mysql_query("SELECT * FROM $autortable where ID=$blockaid1");
while ($myrow1=mysql_fetch_array($result1)) {
$blockemail1=$myrow1["email"];
}
$blocktxt="Здравствуйте! Закончился срок выделения вакансии \"$profecy_top\" на сайте $siteadress
";
mail($blockemail1,"Окончание выделения вакансии",$blocktxt,"From: $adminemail\nReturn-Path:$adminemail\nMime-Version: 1.0\nContent-Type: text/html; charset=windows-1251\nContent-Transfer-Encoding:8bit\n");
$delres=mysql_query("update $vactable set topblock='0000-00-00 00:00:00',sendedtopblock='0000-00-00 00:00:00' where ID='$blockID'");
}
// Блокировка вакансии TOPBLOCK
// Блокировка резюме
$res1 = @mysql_query("SELECT * FROM $restable WHERE (status != 'archive' and (date + INTERVAL 86400*(period) SECOND) < now())");
while ($myrow=@mysql_fetch_array($res1))
{
$blockID=$myrow["ID"];
$blockaid1=$myrow["aid"];
$profecy_top=$myrow["profecy"];
$result1 = @mysql_query("SELECT * FROM $autortable where ID=$blockaid1");
while ($myrow1=mysql_fetch_array($result1)) {
$blockemail1=$myrow1["email"];
}
$blocktxt="Здравствуйте! Закончился срок размещения резюме \"$profecy_top\" на сайте $siteadress
Резюме переведено в архив";
mail($blockemail1,"Окончание размещения резюме",$blocktxt,"From: $adminemail\nReturn-Path:$adminemail\nMime-Version: 1.0\nContent-Type: text/html; charset=windows-1251\nContent-Transfer-Encoding:8bit\n");
$delres=mysql_query("update $restable set status='archive',archivedate = now(),sended='0000-00-00 00:00:00' where ID='$blockID'");
}
// Блокировка резюме
// Блокировка резюме TOP
$res1 = @mysql_query("SELECT * FROM $restable WHERE (top != '0000-00-00 00:00:00' and (top + INTERVAL 86400*(periodfortop) SECOND) < now())");
while ($myrow=@mysql_fetch_array($res1))
{
$blockID=$myrow["ID"];
$blockaid1=$myrow["aid"];
$profecy_top=$myrow["profecy"];
$result1 = @mysql_query("SELECT * FROM $autortable where ID=$blockaid1");
while ($myrow1=mysql_fetch_array($result1)) {
$blockemail1=$myrow1["email"];
}
$blocktxt="Здравствуйте! Закончился срок поднятия резюме \"$profecy_top\" на сайте $siteadress
";
mail($blockemail1,"Окончание поднятия резюме",$blocktxt,"From: $adminemail\nReturn-Path:$adminemail\nMime-Version: 1.0\nContent-Type: text/html; charset=windows-1251\nContent-Transfer-Encoding:8bit\n");
$delres=mysql_query("update $restable set top='0000-00-00 00:00:00',sendedtop='0000-00-00 00:00:00' where ID='$blockID'");
}
// Блокировка резюме TOP
// Блокировка резюме BOLD
$res1 = @mysql_query("SELECT * FROM $restable WHERE (bold != '0000-00-00 00:00:00' and (bold + INTERVAL 86400*(periodforbold) SECOND) < now())");
while ($myrow=@mysql_fetch_array($res1))
{
$blockID=$myrow["ID"];
$blockaid1=$myrow["aid"];
$profecy_top=$myrow["profecy"];
$result1 = @mysql_query("SELECT * FROM $autortable where ID=$blockaid1");
while ($myrow1=mysql_fetch_array($result1)) {
$blockemail1=$myrow1["email"];
}
$blocktxt="Здравствуйте! Закончился срок выделения резюме \"$profecy_top\" на сайте $siteadress
";
mail($blockemail1,"Окончание выделения резюме",$blocktxt,"From: $adminemail\nReturn-Path:$adminemail\nMime-Version: 1.0\nContent-Type: text/html; charset=windows-1251\nContent-Transfer-Encoding:8bit\n");
$delres=mysql_query("update $restable set bold='0000-00-00 00:00:00',sendedbold='0000-00-00 00:00:00' where ID='$blockID'");
}
// Блокировка резюме BOLD
// Блокировка резюме BLOCK
$res1 = @mysql_query("SELECT * FROM $restable WHERE (block != '0000-00-00 00:00:00' and (block + INTERVAL 86400*(periodforblock) SECOND) < now())");
while ($myrow=@mysql_fetch_array($res1))
{
$blockID=$myrow["ID"];
$blockaid1=$myrow["aid"];
$profecy_top=$myrow["profecy"];
$result1 = @mysql_query("SELECT * FROM $autortable where ID=$blockaid1");
while ($myrow1=mysql_fetch_array($result1)) {
$blockemail1=$myrow1["email"];
}
$blocktxt="Здравствуйте! Закончился срок выделения резюме \"$profecy_top\" на сайте $siteadress
";
mail($blockemail1,"Окончание выделения резюме",$blocktxt,"From: $adminemail\nReturn-Path:$adminemail\nMime-Version: 1.0\nContent-Type: text/html; charset=windows-1251\nContent-Transfer-Encoding:8bit\n");
$delres=mysql_query("update $restable set block='0000-00-00 00:00:00',sendedblock='0000-00-00 00:00:00' where ID='$blockID'");
}
// Блокировка резюме BLOCK
// Блокировка резюме TOPBLOCK
$res1 = @mysql_query("SELECT * FROM $restable WHERE (topblock != '0000-00-00 00:00:00' and (topblock + INTERVAL 86400*(periodfortopblock) SECOND) < now())");
while ($myrow=@mysql_fetch_array($res1))
{
$blockID=$myrow["ID"];
$blockaid1=$myrow["aid"];
$profecy_top=$myrow["profecy"];
$result1 = @mysql_query("SELECT * FROM $autortable where ID=$blockaid1");
while ($myrow1=mysql_fetch_array($result1)) {
$blockemail1=$myrow1["email"];
}
$blocktxt="Здравствуйте! Закончился срок выделения резюме \"$profecy_top\" на сайте $siteadress
";
mail($blockemail1,"Окончание выделения резюме",$blocktxt,"From: $adminemail\nReturn-Path:$adminemail\nMime-Version: 1.0\nContent-Type: text/html; charset=windows-1251\nContent-Transfer-Encoding:8bit\n");
$delres=mysql_query("update $restable set topblock='0000-00-00 00:00:00',sendedtopblock='0000-00-00 00:00:00' where ID='$blockID'");
}
// Блокировка резюме TOPBLOCK
}
if ($paycontacttrue == 'TRUE') {
$updpaycont=mysql_query("update $autortable set paycontact='0000-00-00 00:00:00' where ((paycontact + INTERVAL 86400*$periodforcontact SECOND) < now())");
}
$updres=mysql_query("update $restable set top='0000-00-00 00:00:00' where ((top + INTERVAL 86400*periodfortop SECOND) < now())");
$updres=mysql_query("update $restable set bold='0000-00-00 00:00:00' where ((bold + INTERVAL 86400*periodforbold SECOND) < now())");
$updres=mysql_query("update $restable set block='0000-00-00 00:00:00' where ((block + INTERVAL 86400*periodforblock SECOND) < now())");
$srcitymy=$_COOKIE['srcitymy'];
if (isset($srcitymy) and $srcitymy != '' and !isset($srcity)) {$srcity=$srcitymy;}
if ($srcity != '')
{ // city
if (eregi("^[r]",$srcity)) {
$srcityshow1=@substr($srcity,1,1000);
$qwerypromo="and (country = '$srcityshow1' or country = '0')";
}
if (eregi("^[p]",$srcity)) {
$srcityshow1=@substr($srcity,1,1000);
$qwerypromo="and (region = '$srcityshow1' or region = '0')";
}
if (eregi("^[c]",$srcity)) {
$srcityshow1=@substr($srcity,1,1000);
$qwerypromo="and (city = '$srcityshow1' or city = '0')";
}
} // city
if ($srcity == "") {$qwerypromo='';}
$srcitymy=$_COOKIE['srcitymy'];
if (isset($srcitymy) and $srcitymy != '' and !isset($srcity)) {$srcity=$srcitymy;}
if ($srcity == '') {$srcityshowtop = 'Все города';$chpucity_top='vse_goroda';}
if ($srcity != '')
{ // city
if (eregi("^[r]",$srcity)) {
$srcityshow=@substr($srcity,1,1000);
$resultadd2 = @mysql_query("SELECT * FROM $citytable WHERE ID='$srcityshow' LIMIT 1");
while($myrow1=mysql_fetch_array($resultadd2)) {
$srcityshowtop=$myrow1["razdel"];
}
}
if (eregi("^[p]",$srcity)) {
$srcityshow=@substr($srcity,1,1000);
$resultadd2 = @mysql_query("SELECT * FROM $citytable WHERE ID='$srcityshow' LIMIT 1");
while($myrow1=mysql_fetch_array($resultadd2)) {
$srcityshowtop=$myrow1["podrazdel"];
$chpucity_top=$myrow1["chpu"];
}
}
if (eregi("^[c]",$srcity)) {
$srcountryshow=@substr($srcity,1,1000);
$resultadd1 = @mysql_query("SELECT * FROM $citytable WHERE ID='$srcountryshow' LIMIT 1");
while($myrow2=mysql_fetch_array($resultadd1)) {
$srcityshowtop=$myrow2["categ"];
}
}
} // city
if (isset($_COOKIE['sid'])) {$sid=$_COOKIE['sid'];}
if (isset($_COOKIE['slogin'])) {$slogin=$_COOKIE['slogin'];}
if (isset($_COOKIE['spass'])) {$spass=$_COOKIE['spass'];}
if (!isset($sid) or $sid == '') {$sid=$_SESSION['sid'];}
if (!isset($slogin) or $slogin == '') {$slogin=$_SESSION['slogin'];}
if (!isset($spass) or $spass == '') {$spass=$_SESSION['spass'];}
if ($_SERVER[QUERY_STRING] == "autor") {
$alogin=$_POST['alogin'];
$apass=$_POST['apass'];
$resultaut1 = @mysql_query("SELECT ID,email,fio,pass,status,category FROM $autortable WHERE (email = '$alogin' and pass = '$apass' and status != 'wait')");
if (@mysql_num_rows($resultaut1) != 0) {
if (!isset($spass) or $spass == '') {$_SESSION['spass']=$apass;$spass=$apass;}
if (!isset($slogin) or $slogin == '') {$_SESSION['slogin']=$alogin;$slogin=$alogin;}
$resultaut = @mysql_query("SELECT ID,email,fio,pass,status,category FROM $autortable WHERE (email = '$alogin' and pass = '$apass' and status != 'wait')");
while ($myrow=mysql_fetch_array($resultaut)) {
$_SESSION['sid']=$myrow["ID"];
$categoryaut=$myrow["category"];
}
}
}
$resultaut = @mysql_query("SELECT ID,email,fio,pass,status,category,social FROM $autortable WHERE (email = '$slogin' and pass = '$spass' and status != 'wait')");
if ((!isset($slogin) or !isset($spass)) or @mysql_num_rows($resultaut) == 0)
{ // no aut
$topautorized=0;
} // no aut
elseif ((isset($slogin) and isset($spass)) and @mysql_num_rows($resultaut) != 0)
{ // aut
while ($myrow=mysql_fetch_array($resultaut)) {
$categoryaut=$myrow["category"];
$fioaut=$myrow["fio"];
$social_top=$myrow["social"];
if ($fioaut != '') {$fioaut = " $fioaut";}
}
if ($categoryaut=='soisk') {$categaut='Соискатель';}
if ($categoryaut=='rab') {$categaut='Работодатель';}
if ($categoryaut=='agency') {$categaut='Агентство';}
if ($categoryaut=='user') {$categaut='Пользователь';}
$topautorized=1;
} // aut
?>
$res13 = @mysql_query("SELECT * FROM $citytable WHERE podrazdel != '' and categ='' and notshow = ''");
$totcity=mysql_num_rows($res13);
$totcity1=(int)($totcity/4);
$ttt=0;
?>
$res13 = @mysql_query("SELECT * FROM $citytable WHERE podrazdel != '' and categ='' and notshow = '' order by sort DESC,ID");
if (@mysql_num_rows($res13) != 0) {
while($myrow5=mysql_fetch_array($res13)) {
$city12top=$myrow5["categ"];
$region12top=$myrow5["podrazdel"];
$cityIDtop=$myrow5["ID"];
$chputop=$myrow5["chpu"];
if ($ttt >= $totcity1) {
$ttt=0;
?>
}
if (!eregi('<',$city12top) and !eregi('<',$region12top))
{ // bez
echo "
";
if ($city12top == '') {echo "$region12top";}
if ($city12top != '') {echo "$city12top";}
echo "
";
} // bez
$ttt=$ttt+1;
}
}
?>
">
if (!eregi("index2.php",$n))
{
?>
">
if (!eregi('gorodastrani.php',$n))
{ // не gorodastrani.php
if ($link == '' or ($link != '' and ($top == '0000-00-00 00:00:00' and $bold == '0000-00-00 00:00:00' and $block == '0000-00-00 00:00:00' and $topblock == '0000-00-00 00:00:00')))
{ // не платная вакансия
?>
if (!eregi("autor.php",$n) and !eregi("mylist",$n) and !eregi("addvac.php",$n) and !eregi("addres.php",$n) and !eregi("change",$n) and !eregi("payvac.php",$n) and !eregi("payob.php",$n) and !eregi("payres.php",$n) and !eregi("admin",$n))
{ // не личный кабинет
?>
if ($qwerypromo == '')
{
if (!eregi('.php',$n) or eregi('/index.php',$n)) {$resultprtop = mysql_query("select * from $promotable where status='ok' and wheres = 'top' and (place = 'index' or place = 'all') order by RAND() limit $promotoplimit");}
elseif (eregi('/listvac.php',$n) or eregi('/linkvac.php',$n) or eregi('/searchv.php',$n) or eregi('/orderv.php',$n)) {$resultprtop = mysql_query("select * from $promotable where status='ok' and wheres = 'top' and (place = 'vac' or place = 'all') order by RAND() limit $promotoplimit");}
elseif (eregi('/listres.php',$n) or eregi('/linkres.php',$n) or eregi('/searchr.php',$n) or eregi('/orderr.php',$n)) {$resultprtop = mysql_query("select * from $promotable where status='ok' and wheres = 'top' and (place = 'res' or place = 'all') order by RAND() limit $promotoplimit");}
else {$resultprtop = mysql_query("select * from $promotable where status='ok' and wheres = 'top' and (place = 'other' or place = 'all') order by RAND() limit $promotoplimit");}
}
if ($qwerypromo != '')
{
if (!eregi('.php',$n) or eregi('/index.php',$n)) {$resultprtop = mysql_query("select * from $promotable where status='ok' and wheres = 'top' and (place = 'index' or place = 'all') $qwerypromo order by RAND() limit $promotoplimit");}
elseif (eregi('/listvac.php',$n) or eregi('/linkvac.php',$n) or eregi('/searchv.php',$n) or eregi('/orderv.php',$n)) {$resultprtop = mysql_query("select * from $promotable where status='ok' and wheres = 'top' and (place = 'vac' or place = 'all') $qwerypromo order by RAND() limit $promotoplimit");}
elseif (eregi('/listres.php',$n) or eregi('/linkres.php',$n) or eregi('/searchr.php',$n) or eregi('/orderr.php',$n)) {$resultprtop = mysql_query("select * from $promotable where status='ok' and wheres = 'top' and (place = 'res' or place = 'all') $qwerypromo order by RAND() limit $promotoplimit");}
else {$resultprtop = mysql_query("select * from $promotable where status='ok' and wheres = 'top' and (place = 'other' or place = 'all') $qwerypromo order by RAND() limit $promotoplimit");}
}
$rows = mysql_num_rows($resultprtop);
if($rows != 0)
{
while($myrow=mysql_fetch_array($resultprtop))
{
$ptitle=$myrow["title"];
$plink=$myrow["link"];
$pfoto=$myrow["foto"];
$pcity=$myrow["city"];
if ($pfoto != '') {echo " ";}
if ($pfoto == '') {echo "
";}
}
}
//if ($rows == 0 or $rows < $promotoplimit) {echo "Разместить рекламу на этом месте";}
?>
if ($qwerypromo == '')
{
if (!eregi('.php',$n) or eregi('/index.php',$n)) {$resultprtop = mysql_query("select * from $promotable where status='ok' and wheres = 'comp' order by RAND() limit $promocomplimit");}
}
if ($qwerypromo != '')
{
if (!eregi('.php',$n) or eregi('/index.php',$n)) {$resultprtop = mysql_query("select * from $promotable where status='ok' and wheres = 'comp' $qwerypromo order by RAND() limit $promocomplimit");}
}
$rows = mysql_num_rows($resultprtop);
$st=0;
if($rows != 0)
{
echo ("
");
while($myrow=mysql_fetch_array($resultprtop))
{
$ptitle=$myrow["title"];
$plink=$myrow["link"];
$pfoto=$myrow["foto"];
if ($st==4) {
$st=0;
if ($pfoto != '') {echo " ";}
if ($pfoto == '') {echo " $ptitle";}
$st=$st+1;}
elseif ($st < 4) {
if ($pfoto != '') {echo " ";}
if ($pfoto == '') {echo " $ptitle";}
$st=$st+1;}
}
echo "
";
}
//if ($rows == 0 or $rows < $promocomplimit) {echo " ";}
?>
// seo h1
$result = @mysql_query("SELECT * FROM $seotable where page='$tadress' and zagolovok != '' order by ID LIMIT 1");
if (mysql_num_rows($result) != 0)
{
while($myrow=mysql_fetch_array($result)) {
$zagolovok_top=$myrow["zagolovok"];
echo "
$zagolovok_top
";
}
}
// seo h1
?>
/*
блок ссылок для страницы /ekaterinburg
Начало
Скопировать данный блок и заменить везде в ссылках ЧПУ города на нужный новый город
*/
if ($n == '/ekaterinburg')
{
?>
}
/*
блок ссылок для страницы /ekaterinburg
конец
*/
/*
блок ссылок для страницы /vse_goroda/vakansii/rabota_dlya_devushek_dosug
Начало
Скопировать данный блок и заменить везде в ссылках ЧПУ города на нужный новый город
*/
elseif ($n == '/vse_goroda/vakansii/rabota_dlya_devushek_dosug')
{
?>
}
/*
блок ссылок для страницы /vse_goroda/vakansii/rabota_dlya_devushek_dosug
конец
*/
/*
блок ссылок для страницы /moskva
Начало
Скопировать данный блок и заменить везде в ссылках ЧПУ города на нужный новый город
*/
elseif ($n == '/moskva')
{
?>
Высокооплачиваемая работа для девушек в Москве со свободным графиком. Заработок от 700 000 руб/месяц. Ваканcии экскортницы. Работа для девушек в Москве в сфере досуга поможет вам достигнуть ваших целей за быстрое время!
}
?>
Быстрый поиск
} // не личный кабинет
?>
// вип 2
if (!eregi("autor.php",$n) and !eregi("mylist",$n) and !eregi("addvac.php",$n) and !eregi("addres.php",$n) and !eregi("change",$n) and !eregi("payvac.php",$n) and !eregi("payob.php",$n) and !eregi("payres.php",$n) and !eregi("admin",$n))
{ // не личный кабинет
if (!eregi("res",$n) and !eregi("resume",$n))
{ // вакансии
$result = @mysql_query("SELECT *,DATE_FORMAT(date,'%d.%m.%Y') as dateq FROM $vactable WHERE status='ok' and topblock != '0000-00-00 00:00:00' $qwery1 order by RAND()");
if (@mysql_num_rows($result) != 0)
{ //has
?>
Рекомендуемые вакансии
while ($myrow=@mysql_fetch_array($result))
{ //4
$ID_top=$myrow["ID"];
$profecy_top=$myrow["profecy"];
$zp_top=$myrow["zp"];
$aid_top=$myrow["aid"];
$date_top=$myrow["dateq"];
$razdel_top=$myrow["razdel"];
$podrazdel_top=$myrow["podrazdel"];
$bold_top=$myrow["bold"];
$date=$myrow["date"];
$boldstl='b-ad-teaser_highlighted2';
$boldcity_top=$myrow["boldcity"];
$boldrazdel_top=$myrow["boldrazdel"];
$uslov_top=$myrow["uslov"];
if (strlen($uslov_top) > 200) {$uslov_top=substr($uslov_top,0,200); $uslov_top=$uslov_top.';...';}
if ($bold_top != '0000-00-00 00:00:00' and $boldcity_top == 0 and $boldrazdel_top == 0) {$boldstl="b-ad-teaser_highlighted1";}
$resultadd2 = @mysql_query("SELECT ID,podrazdel FROM $catable WHERE notshow != 'checked' and dopcat != 'checked' and ID='$podrazdel_top'");
while($myrow1=mysql_fetch_array($resultadd2)) {
$podrazdel1_top=$myrow1["podrazdel"];
}
$resultadd1 = @mysql_query("SELECT ID,razdel,podrazdel FROM $catable WHERE notshow != 'checked' and dopcat != 'checked' and podrazdel = '' and ID='$razdel_top'");
while($myrow1=mysql_fetch_array($resultadd1)) {
$razdel1_top=$myrow1["razdel"];
}
if (strlen($profecy_top) > 100) {$profecy_top=substr($profecy_top,0,100); $profecy_top=$profecy_top.'...';}
$resultaut = @mysql_query("SELECT * FROM $autortable WHERE ID='$aid_top'");
while ($myrow2=mysql_fetch_array($resultaut)) {
//$foto2_top=$myrow2["foto2"];
$acountry=$myrow["country"];
$aregion=$myrow["region"];
$acity=$myrow["city"];
$citytar=$acity;
if ($acity=='0') {$citytar=$aregion;}
if ($aregion=='0' and $acity=='0') {$citytar=$acountry;}
$resultadd3c = @mysql_query("SELECT * FROM $citytable WHERE ID='$citytar'");
while($myrowc=mysql_fetch_array($resultadd3c)) {
$acitys=$myrowc["categ"];
if ($acity=='0') {$acitys=$myrowc["podrazdel"];}
if ($acity=='0' and $aregion=='0') {$acitys=$myrowc["razdel"];}
}
}
?>
" style="min-height:200px;">
$resultfoto = @mysql_query("SELECT * FROM $phototable WHERE aid='$ID_top' and category='vac' order by main DESC,ID limit 1");
$totalfoto=@mysql_num_rows($resultfoto);
if ($totalfoto != 0) {
while ($myrow=mysql_fetch_array($resultfoto))
{
$fotoID=$myrow["ID"];
$foto1=$myrow["foto"];
//if (file_exists("$upath$photodir".'l'.$foto1)) {$wfoto1="l$foto1";} elseif (!file_exists("$upath$photodir".'l'.$foto1)) {$wfoto1="$foto1";}
$wfoto1="l$foto1";
echo ("
");
}
}
?>
} //has
} // вакансии
if (eregi("res",$n) or eregi("resume",$n))
{ // резюме
$result = @mysql_query("SELECT *,DATE_FORMAT(date,'%d.%m.%Y') as dateq FROM $restable WHERE status='ok' and topblock != '0000-00-00 00:00:00' $qwery1 order by RAND() LIMIT 10");
if (@mysql_num_rows($result) != 0)
{ //has
?>
while ($myrow=@mysql_fetch_array($result))
{ //4
$ID_top=$myrow["ID"];
$profecy_top=$myrow["profecy"];
$zp_top=$myrow["zp"];
$aid_top=$myrow["aid"];
$date_top=$myrow["dateq"];
$razdel_top=$myrow["razdel"];
$podrazdel_top=$myrow["podrazdel"];
$bold_top=$myrow["bold"];
$date=$myrow["date"];
$boldstl='b-ad-teaser_highlighted2';
$boldcity_top=$myrow["boldcity"];
$boldrazdel_top=$myrow["boldrazdel"];
if ($bold_top != '0000-00-00 00:00:00' and $boldcity_top == 0 and $boldrazdel_top == 0) {$boldstl="b-ad-teaser_highlighted1";}
$resultadd2 = @mysql_query("SELECT ID,podrazdel FROM $catable WHERE notshow != 'checked' and dopcat != 'checked' and ID='$podrazdel_top'");
while($myrow1=mysql_fetch_array($resultadd2)) {
$podrazdel1_top=$myrow1["podrazdel"];
}
$resultadd1 = @mysql_query("SELECT ID,razdel,podrazdel FROM $catable WHERE notshow != 'checked' and dopcat != 'checked' and podrazdel = '' and ID='$razdel_top'");
while($myrow1=mysql_fetch_array($resultadd1)) {
$razdel1_top=$myrow1["razdel"];
}
if (strlen($profecy_top) > 100) {$profecy_top=substr($profecy_top,0,100); $profecy_top=$profecy_top.'...';}
$resultaut = @mysql_query("SELECT * FROM $autortable WHERE ID='$aid_top'");
while ($myrow2=mysql_fetch_array($resultaut)) {
//$foto2_top=$myrow2["foto1"];
$acountry=$myrow["country"];
$aregion=$myrow["region"];
$acity=$myrow["city"];
$citytar=$acity;
if ($acity=='0') {$citytar=$aregion;}
if ($aregion=='0' and $acity=='0') {$citytar=$acountry;}
$resultadd3c = @mysql_query("SELECT * FROM $citytable WHERE ID='$citytar'");
while($myrowc=mysql_fetch_array($resultadd3c)) {
$acitys=$myrowc["categ"];
if ($acity=='0') {$acitys=$myrowc["podrazdel"];}
if ($acity=='0' and $aregion=='0') {$acitys=$myrowc["razdel"];}
}
}
?>
" style="min-height:200px;">
$resultfoto = @mysql_query("SELECT * FROM $phototable WHERE aid='$ID_top' and category='res' order by main DESC,ID limit 1");
$totalfoto=@mysql_num_rows($resultfoto);
if ($totalfoto != 0) {
while ($myrow=mysql_fetch_array($resultfoto))
{
$fotoID=$myrow["ID"];
$foto1=$myrow["foto"];
//if (file_exists("$upath$photodir".'l'.$foto1)) {$wfoto1="l$foto1";} elseif (!file_exists("$upath$photodir".'l'.$foto1)) {$wfoto1="$foto1";}
$wfoto1="l$foto1";
echo ("
");
}
}
?>
";
$line=ereg_replace('&page=1','',$line);
if ($totaltexts != 0)
{ //2
if (!isset($ord) or $ord == "") {$qweryord='date DESC';}
if (isset($ord) and $ord != "") {$qweryord=$ord;}
$result = @mysql_query("SELECT *,DATE_FORMAT(date,'%d.%m.%Y') as dateq FROM $vactable WHERE status='ok' $qwery1 order by topdate DESC,top DESC,random,$qweryord LIMIT $initialMsg, $maxThread");
include("anketa.php");
if ($pages > 1) {echo "$line";}
} //2
$result1 = @mysql_query("SELECT * FROM $vactable WHERE status='ok' and top = '0000-00-00 00:00:00' $qwery1");
$totaltexts1=@mysql_num_rows($result1);
if ($totaltexts1 == 0) {
// нет бесплатных объявлений
//$result = @mysql_query("SELECT *,DATE_FORMAT(date,'%d.%m.%Y') as dateq FROM $vactable WHERE status='ok' order by RAND() LIMIT 10");
//include("anketa.php");
} // нет бесплатных объявлений
?>