break; } $chassisSize = '<param name="Размер рамы">' . htmlspecialchars($row['razmer_rami']) . '</param>' . PHP_EOL; $wheelSize = '<param name="Размер колес">' . htmlspecialchars($row['razmer_koles']) . '</param>' . PHP_EOL; $color = '<param name="Цвет">' . htmlspecialchars($row['color']) . '</param>' . PHP_EOL; if (is_null($lastSiteId) || $lastSiteId != $row['id'] || $lastParamsString == '') { $lastParamsString = ''; $pq = ' SELECT `l`.`name` AS `name`, `v`.`value` AS `value` FROM `prop_values` AS v INNER JOIN `prop_list` l ON l.id = v.pid WHERE v.tid = ' . $row['id']; $pquery = db_q($pq); while ($prow = mysql_fetch_assoc($pquery)) { if ($prow['name'] != '' && !is_null($prow['name']) && $prow['value'] != '' && !is_null($prow['value'])) { $lastParamsString .= '<param name="' . htmlspecialchars($prow['name'], ENT_COMPAT | ENT_HTML401, 'cp1251') . '">' . htmlspecialchars($prow['value'], ENT_COMPAT | ENT_HTML401, 'cp1251') . '</param>' . PHP_EOL; } } } $available = $row['o_sklad'] + $row['t_sklad'] + $row['m_sklad'] > 0 ? 'true' : 'false'; $availableInEShop = $row['o_sklad'] + $row['t_sklad'] + $row['m_sklad'] > 0 ? 'true' : 'false'; $availableInBrinkAndMortar = $row['m_sklad'] > 0 ? 'true' : 'false'; $offers .= "<offer id='{$row['id_1c']}' groupId='{$row['group_id']}' type='vendor.model' available='{$available}'>\n <url>http://www.velosite.ru/catalog/{$category}/{$brand}/{$year}/{$row['alias']}/?f=yama&utm_source=Yandex.Market&utm_medium=cpc&utm_campaign=Market_MSK&utm_content={$row['id']}</url>\n <price>" . (int) $row['price'] . "</price>\n <currencyId>RUR</currencyId>\n <categoryId>{$row['pid']}</categoryId>\n {$img}\n <store>{$availableInEShop}</store>\n <pickup>{$availableInBrinkAndMortar}</pickup>\n <delivery>" . ($row['sklad_osnov'] + $row['sklad_tranzit'] + $row['sklad_marketplace'] > 0 ? 'true' : 'false') . "</delivery>\n <local_delivery_cost>0</local_delivery_cost>\n <typePrefix>" . ($category == 'velosipedy' ? 'Велосипед' : '') . "</typePrefix>\n <vendor>{$row['brand']}</vendor>\n <model>{$row['name']} " . (!empty($row['year']) ? ' (' . $row['year'] . ')' : '') . "</model>\n <description>{$row['small']}</description>\n <year>{$row['year']}</year>\n {$chassisSize}\n {$wheelSize}\n {$color}\n {$lastParamsString}\n </offer>"; } echo "<?xml version=\"1.0\" encoding=\"windows-1251\" ?>\n"; echo "<!DOCTYPE yml_catalog SYSTEM \"shops.dtd\">\n"; ?> <yml_catalog date="<?php
print '</div>'; print '<div>'; // Chat thread: if ($talker) { print '<td valign="top"><table border="0" class="ff"><tr>' . "\n"; if (!$start) { $start = "0"; } // are we in the first page? $nume = get_num_lines($tslice_table, $user_id, $talker, $server); // number of chat lines if ($start > $nume) { $start = $nume - $num_lines_bro; } // checking start variable $result = db_q($user_id, $server, $tslice_table, $talker, $search_p, "3", $start, $xmpp_host, $num_lines_bro, $time_s = "", $end_s = "", $resource_id); if ($result == "f") { header("Location: main.php"); } $talker_name = get_user_name($talker, $xmpp_host); $server_name = get_server_name($server, $xmpp_host); $nickname = query_nick_name($bazaj, $token, $talker_name, $server_name); if ($nickname == "f") { $nickname = $not_in_r[$lang]; } $predefined = "{$talker_name}@{$server_name}"; $predefined = encode_url($predefined, $token, $url_key); $predefined_s = "from:{$talker_name}@{$server_name}"; $predefined_s = encode_url($predefined_s, $token, $url_key); print '<table id="maincontent" border="0" cellspacing="0" class="ff">' . "\n"; // if we come from chat maps put the link back...its the same link as "show all chats" but, it is more self explaining
} if ($time2_start or $time2_end) { if (validate_date($time2_start == "f")) { unset($time2_start); } if (validate_date($time2_start == "f")) { unset($time2_end); } if ($time2_start and $time2_end) { if (strtotime("{$time2_start}") > strtotime("{$time2_end}")) { $alert = $time_range_w[$lang]; unset($search_phase); } } } $result = db_q($user_id, $server, $tslice_table, $talker, $search_p, 1, $offset_arch, $xmpp_host); while ($results = mysql_fetch_array($result)) { $r++; $to_tble[$r] = $results[at]; } print '<select class="cc" name="time2_start" style="text-align: center;">' . "\n"; print '<option value="">' . $time_range_from[$lang] . '</option>' . "\n"; for ($t = 1; $t <= $r; $t++) { print '<option value="' . $to_tble[$t] . '"'; if ($time2_start == $to_tble[$t]) { print 'selected="selected"'; } print '>' . $to_tble[$t] . '</option>' . "\n"; } print '</select>' . "\n"; print ' ';
while ($entry = mysql_fetch_array($result)) { $external++; $time_slice = $entry["at"]; // sub query if ($search_phase) { $type = "4"; } if ($user_chat_search) { if ($qquery['words'] == "t") { $type = "5"; } elseif ($qquery['words'] == "f") { $type = "7"; } } $a++; $search_result = db_q($user_id, $server, $time_slice, $user_name, $search_phase, $type, $start_from, $xmpp_host); if ($search_result == "f") { header("Location: search_v2.php"); } $num_rows = mysql_num_rows($search_result); $day_mark = 0; if ($num_rows != "0") { while ($results = mysql_fetch_array($search_result)) { // if there is no "from:" clausule perform normal search if ($type != "7") { $body_safe = base64_encode($results[body]); // ensure that we will preserve right message format... mysql_query("insert into results_table (ts,time_slice,peer_name_id,peer_server_id,direction,body,score,ext) values (\n\t\t\t\t\t'{$results['ts']}',\n\t\t\t\t\t'{$time_slice}',\n\t\t\t\t\t'{$results['peer_name_id']}',\n\t\t\t\t\t'{$results['peer_server_id']}',\n\t\t\t\t\t'{$results['direction']}',\n\t\t\t\t\t'{$body_safe}',\n\t\t\t\t\t'{$results['score']}',\n\t\t\t\t\t'{$results['ext']}'\n\t\t\t\t\t)") or die("Internal Error"); } else { $internal++; $day_mark++;