Array ( [http] => Array ( [method] => POST [header] => Content-Type: application/x-www-form-urlencoded [content] => query=%7B%22lat%22%3A%2246.793%22%2C%22lng%22%3A%2224.714%22%2C%22lang%22%3A%22en%22%7D ) )


https://localapi.adverto.sale/v1/get_location_by_gps.php
responce =
( ! ) Warning: pg_connect(): Unable to connect to PostgreSQL server: could not connect to server: Connection refused Is the server running on host "10.10.10.11" and accepting TCP/IP connections on port 5432? in /data/www/api.adverto.sale/v1/vendor/pomm-project/foundation/sources/lib/Session/Connection.php on line 212
Call Stack
#TimeMemoryFunctionLocation
10.0001394464{main}( ).../get_location_by_gps.php:0
20.0078598816getCountryAndCityByGPS( $latitude = '46.793', $longitude = '24.714' ).../get_location_by_gps.php:50
30.0078598840getLocationByGPS( $lat = '46.793', $lng = '24.714' ).../lib.php:1370
40.0094692728PommProject\Foundation\QueryManager\SimpleQueryManager->query( $sql = 'SELECT location_id FROM location_polygons WHERE ST_Intersects($*::text::geography, geom::geography)', $parameters = [0 => 'POINT(24.714 46.793)'] ).../lib.php:1300
50.0096694624PommProject\Foundation\QueryManager\SimpleQueryManager->doQuery( $sql = 'SELECT location_id FROM location_polygons WHERE ST_Intersects($*::text::geography, geom::geography)', $parameters = [0 => 'POINT(24.714 46.793)'] ).../SimpleQueryManager.php:53
60.0096694784PommProject\Foundation\Session\Connection->sendQueryWithParameters( $query = 'SELECT location_id FROM location_polygons WHERE ST_Intersects($1::text::geography, geom::geography)', $parameters = [0 => 'POINT(24.714 46.793)'] ).../SimpleQueryManager.php:88
70.0096694784PommProject\Foundation\Session\Connection->getHandler( ).../Connection.php:418
80.0096694784PommProject\Foundation\Session\Connection->launch( ).../Connection.php:132
90.0097694896pg_connect( $connection_string = 'user=adv_geo dbname=adv_geo host=10.10.10.11 port=5432 password=OhPha9ux', $connect_type = 2 ).../Connection.php:212

( ! ) Fatal error: Uncaught PommProject\Foundation\Exception\ConnectionException: Error connecting to the database with parameters 'user=adv_geo dbname=adv_geo host=10.10.10.11 port=5432 password=xxxx'. in /data/www/api.adverto.sale/v1/vendor/pomm-project/foundation/sources/lib/Session/Connection.php on line 215
( ! ) PommProject\Foundation\Exception\ConnectionException: Error connecting to the database with parameters 'user=adv_geo dbname=adv_geo host=10.10.10.11 port=5432 password=xxxx'. in /data/www/api.adverto.sale/v1/vendor/pomm-project/foundation/sources/lib/Session/Connection.php on line 215
Call Stack
#TimeMemoryFunctionLocation
10.0001394464{main}( ).../get_location_by_gps.php:0
20.0078598816getCountryAndCityByGPS( $latitude = '46.793', $longitude = '24.714' ).../get_location_by_gps.php:50
30.0078598840getLocationByGPS( $lat = '46.793', $lng = '24.714' ).../lib.php:1370
40.0094692728PommProject\Foundation\QueryManager\SimpleQueryManager->query( $sql = 'SELECT location_id FROM location_polygons WHERE ST_Intersects($*::text::geography, geom::geography)', $parameters = [0 => 'POINT(24.714 46.793)'] ).../lib.php:1300
50.0096694624PommProject\Foundation\QueryManager\SimpleQueryManager->doQuery( $sql = 'SELECT location_id FROM location_polygons WHERE ST_Intersects($*::text::geography, geom::geography)', $parameters = [0 => 'POINT(24.714 46.793)'] ).../SimpleQueryManager.php:53
60.0096694784PommProject\Foundation\Session\Connection->sendQueryWithParameters( $query = 'SELECT location_id FROM location_polygons WHERE ST_Intersects($1::text::geography, geom::geography)', $parameters = [0 => 'POINT(24.714 46.793)'] ).../SimpleQueryManager.php:88
70.0096694784PommProject\Foundation\Session\Connection->getHandler( ).../Connection.php:418
80.0096694784PommProject\Foundation\Session\Connection->launch( ).../Connection.php:132
Array ( [http] => Array ( [method] => POST [header] => Content-Type: application/x-www-form-urlencoded [content] => query=%7B%22lang%22%3A%22en%22%2C%22id%22%3A%22RdZbEf%22%2C%22uid%22%3A%22%22%2C%22timestamp%22%3A1614580256%2C%22usr_latitude%22%3A%2246.793%22%2C%22usr_longitude%22%3A%2224.714%22%2C%22app_id%22%3A%22adverto.sale%22%7D ) )


https://localapi.adverto.sale/v1/product.php
responce = {"data":{"id":"RdZbEf","id_lang":"ru","lang_advert":"ru","owner":{"display_phone_num":"79655823378","settings":{"display_phone":"true","location":{"description":"Kazan, Russia"}},"id":"DiWB0kYG","name":"Регина С.","date_registered":"1548086773","is_shop":"false","image":{"id":"","url":"","sort":""},"isOnline":"false","onlineText":"Offline","rating_mark":"5","rating_mark_cnt":"0","prods_active_cnt":"148","prods_sold_cnt":"0","subscription_date_added":"0","is_subscribed":"false"},"name_original":"Надувной матрас 2 штуки","description_original":"Новые матрасы, каждый по 250 руб, оба 400","name":"Air mattress 2 pieces","description":"New mattresses, each for 250 rubles, both 400","slug":"air-mattress-2-pieces-RdZbEf","price":"400","currency":{"code":"RUB","symbol":"₽","symbol_html":"\u0026#x584;"},"old_price":"","date_created":"1548086828","date_updated":"1548086828","date_published":"1548086828","date_sold":"0","date_archivation":"1553270828","date_deleted":"0","date_blocked":"0","is_published":"true","is_sold":"false","sold_mode":"0","is_deleted":"false","is_blocked":"false","is_expiring":"false","is_new":"1","is_allocated":"false","block_mode":"0","block_type":"0","block_type_text":"","is_archived":"false","archive_mode":"1","images":[{"id":"0075lcwe33amj14og53bresk","sort":"0","url":"https://cache.adverto.sale/files/images/original/00/75/0075lcwe33amj14og53bresk.jpg","width":"2000","height":"1500"},{"id":"0095slotrkghn5fyjps9wmlj","sort":"1","url":"https://cache.adverto.sale/files/images/original/00/95/0095slotrkghn5fyjps9wmlj.jpg","width":"2000","height":"1500"}],"location":{"city":"Kazan","description":"Kazan, Tatarstan, Russia","latitude":"55.81974","longitude":"49.147096","dist":{"value":26,"units":"km"}},"category":"10796","is_favorite":"false","date_favorited":"0","views":"653","favorite_counter":"0","group_id":1,"url":"/RU/kazan/category/air-mattress-2-pieces-RdZbEf","url_branch":"https://i.adverto.sale/K34a/RdZbEf","short_url":"https://adverto.sale/RdZbEf","contacts_visible":"true","degradation":"2","fields":[],"is_price_subscribed":"false"},"status":200,"detail":"Advert","uri":"/advert/RdZbEf"} Air mattress 2 pieces, city Kazan - Advert to sell, price 400 RUB, Posted: 21.01.2019
Location
Ad location
Kazan, Tatarstan, Russia
Kazan, Tatarstan, Russia 26 km from you
View on map
Регина С.
Kazan, Russia
I speak:
  • New knitted suit
  • New knitted suit
  • New suit
  • Clothing for babies package
  • 653 Views
  • Posted 21.01.19
Description from Seller
New

New mattresses, each for 250 rubles, both 400

Новые матрасы, каждый по 250 руб, оба 400

Ad location
Kazan, Tatarstan, Russia
Kazan, Tatarstan, Russia 26 km from you
View on map
Array ( [http] => Array ( [method] => POST [header] => Content-Type: application/x-www-form-urlencoded [content] => query=%7B%22lang%22%3A%22en%22%2C%22adv_id%22%3A%22RdZbEf%22%2C%22uid%22%3A%22%22%2C%22timestamp%22%3A1614580256%2C%22usr_latitude%22%3A%2246.793%22%2C%22usr_longitude%22%3A%2224.714%22%2C%22limit%22%3A12%2C%22app_id%22%3A%22adverto.sale%22%2C%22do_not_count_views%22%3A1%7D ) )


https://localapi.adverto.sale/v1/products.php
responce = {"data":[{"id":"J42jC8","id_lang":"ru","category":10796,"lang_advert":"ru","price":"1200","old_price":"","name_original":"Спальный мешок туристический+одеяло синтепон","description_original":"спальник с капюшоном до +5С*\nнаполнитель холлофайбер\nполотно стёганое не сваливается.\nразмеры на фото.\nрасстёгивается в большое одеяло.\n+доп. комплектация надувная подушка (доп. оплата 150р.)\nновое не б/у\nсамовывоз /отправлю почтой","name":"Tourist sleeping bag + synthetic winterizer blanket","description":"sleeping bag with a hood up to + 5C *\nhollofiber filler\nthe quilted cloth does not fall.\nsizes in the photo.\nunfastens in a large blanket.\n+ add. air bag pillow (extra charge 150 rub.)\nnew not used\npickup / send by mail","slug":"tourist-sleeping-bag-synthetic-winterizer-blanket-J42jC8","date_created":1569997357,"date_updated":1569997357,"date_published":1569997357,"url":"/RU/kazan/category/tourist-sleeping-bag-synthetic-winterizer-blanket-J42jC8","url_branch":"https://i.adverto.sale/K34a/J42jC8","short_url":"https://adverto.sale/J42jC8","group_id":1,"group_text":"","favorite_counter":0,"distance":"","is_published":true,"is_sold":false,"is_deleted":false,"is_blocked":false,"is_expiring":false,"is_allocated":false,"is_archived":false,"is_favorite":false,"is_top":false,"viewed":false,"views":596,"owner":{"id":"t0lTkNMN"},"currency":{"code":"RUB","symbol":"₽","symbol_html":"\u0026#x584;"},"location":{"city":"Kazan","description":"RU, Kazan","latitude":55.83448,"longitude":49.132213},"images":[{"hash":"00jfl71aok1k9aui6axmcks7","url":"https://cache.adverto.sale/files/images/original/00/jf/00jfl71aok1k9aui6axmcks7.jpg","width":400,"height":400,"sort":0},{"hash":"00efab04bobnc10hy5bjx9pm","url":"https://cache.adverto.sale/files/images/original/00/ef/00efab04bobnc10hy5bjx9pm.jpg","width":400,"height":400,"sort":1},{"hash":"00n8b8qyz8usu5pkowjfrhmr","url":"https://cache.adverto.sale/files/images/original/00/n8/00n8b8qyz8usu5pkowjfrhmr.jpg","width":800,"height":800,"sort":2},{"hash":"00wz8w2oxk8tyxlpfnqul8r1","url":"https://cache.adverto.sale/files/images/original/00/wz/00wz8w2oxk8tyxlpfnqul8r1.jpg","width":400,"height":400,"sort":3}]},{"id":"p0anSB","id_lang":"ru","category":10796,"lang_advert":"ru","price":"1500","old_price":"","name_original":"Самонадувающийся коврик матрас туристический","description_original":"Нескользящий материал: Оксфорд\nНагрузка до 150 кг\nРазмер коврика (см): 183 * 57 * 2.5\nРазмер упаковки : 36 * 16 см\n\nсамонадувной коврик защищает от холода и влажности.\nв походе, на даче, на природе, на пляже.\nНаполнитель вспененный полиуретан, обладает высоким теплоизолирующим свойством и упругостью, имеет структуру которая легко заполняется воздухом.\nоткрутить клапан и подождать 3 минуты. .\nразмеры на фото\nновое не б/у\nотправлю почтой в регионы.","name":"Self-inflating mat tourist mattress","description":"Non-slip Material: Oxford\nLoad up to 150 kg\nMat Size (cm): 183 * 57 * 2.5\nPacking size: 36 * 16 cm\n\nSelf-inflating mat protects against cold and humidity.\nin a campaign, in a country house, in nature, on a beach.\nThe filler is a foamed polyurethane, has a high heat-insulating property and elasticity, has a structure that is easily filled with air.\nunscrew the valve and wait 3 minutes. .\nsizes in the photo\nnew not used\nsend by mail to the regions.","slug":"self-inflating-mat-tourist-mattress-p0anSB","date_created":1569997354,"date_updated":1569997354,"date_published":1569997354,"url":"/RU/kazan/category/self-inflating-mat-tourist-mattress-p0anSB","url_branch":"https://i.adverto.sale/K34a/p0anSB","short_url":"https://adverto.sale/p0anSB","group_id":1,"group_text":"","favorite_counter":0,"distance":"","is_published":true,"is_sold":false,"is_deleted":false,"is_blocked":false,"is_expiring":false,"is_allocated":false,"is_archived":false,"is_favorite":false,"is_top":false,"viewed":false,"views":599,"owner":{"id":"t0lTkNMN"},"currency":{"code":"RUB","symbol":"₽","symbol_html":"\u0026#x584;"},"location":{"city":"Kazan","description":"RU, Kazan","latitude":55.834287,"longitude":49.1329},"images":[{"hash":"00vgw75aaq98l6zsutee1fvp","url":"https://cache.adverto.sale/files/images/original/00/vg/00vgw75aaq98l6zsutee1fvp.jpg","width":750,"height":970,"sort":0},{"hash":"001y7vab1gbez1qlflrk3lny","url":"https://cache.adverto.sale/files/images/original/00/1y/001y7vab1gbez1qlflrk3lny.jpg","width":521,"height":382,"sort":1},{"hash":"00x13dwt58avkkh29i04z14i","url":"https://cache.adverto.sale/files/images/original/00/x1/00x13dwt58avkkh29i04z14i.jpg","width":724,"height":450,"sort":2}]},{"id":"MUfpn0","id_lang":"ru","category":10796,"lang_advert":"ru","price":"100","old_price":"","name_original":"Сумка - мешок","description_original":"С универсиады. Новая\n\nГорки. Дубравная. Возможна доставка\n\nОбновляю гардероб. Готовлюсь к переезду. Смотрите больше в моем профиле. Оптом дешевле)","name":"Bag - Bag","description":"From the Universiade. New\n\nGorki. Dubravnaya. Delivery is possible\n\nUpdate wardrobe. I am preparing for the move. See more in my profile. Wholesale cheaper)","slug":"bag---bag-MUfpn0","date_created":1560255989,"date_updated":1560255989,"date_published":1560255989,"url":"/RU/kazan/category/bag---bag-MUfpn0","url_branch":"https://i.adverto.sale/K34a/MUfpn0","short_url":"https://adverto.sale/MUfpn0","group_id":1,"group_text":"","favorite_counter":0,"distance":"","is_published":true,"is_sold":false,"is_deleted":false,"is_blocked":false,"is_expiring":false,"is_allocated":false,"is_archived":false,"is_favorite":false,"is_top":false,"viewed":false,"views":629,"owner":{"id":"4A8jhl4w"},"currency":{"code":"RUB","symbol":"₽","symbol_html":"\u0026#x584;"},"location":{"city":"Kazan","description":"RU, Kazan","latitude":55.744423,"longitude":49.20284},"images":[{"hash":"00vnc9slsohyl0igvdlg4r60","url":"https://cache.adverto.sale/files/images/original/00/vn/00vnc9slsohyl0igvdlg4r60.jpg","width":1500,"height":2000,"sort":0}]},{"id":"XcYoVb","id_lang":"ru","category":10796,"lang_advert":"ru","price":"2500","old_price":"","name_original":"НОВЫЙ Спальный мешок для похода женский","description_original":"ПРОДАЕТСЯ НОВЫЙ Спальный мешок для похода женский Outventure Trek +3 левосторонний","name":"NEW Sleeping bag for a campaign female","description":"FOR SALE NEW Sleeping bag for trekking female Outventure Trek +3 left-sided","slug":"new-sleeping-bag-for-a-campaign-female-XcYoVb","date_created":1548241744,"date_updated":1548241744,"date_published":1548241744,"url":"/RU/kazan/category/new-sleeping-bag-for-a-campaign-female-XcYoVb","url_branch":"https://i.adverto.sale/K34a/XcYoVb","short_url":"https://adverto.sale/XcYoVb","group_id":1,"group_text":"","favorite_counter":0,"distance":"","is_published":true,"is_sold":false,"is_deleted":false,"is_blocked":false,"is_expiring":false,"is_allocated":false,"is_archived":false,"is_favorite":false,"is_top":false,"viewed":false,"views":657,"owner":{"id":"SwBj9Al9"},"currency":{"code":"RUB","symbol":"₽","symbol_html":"\u0026#x584;"},"location":{"city":"Kazan","description":"RU, Kazan","latitude":55.763302,"longitude":49.226111},"images":[{"hash":"00psj76bka7wxp3cozgd8emc","url":"https://cache.adverto.sale/files/images/original/00/ps/00psj76bka7wxp3cozgd8emc.jpg","width":318,"height":800,"sort":0}]},{"id":"si2b8r","id_lang":"ru","category":10796,"lang_advert":"ru","price":"550","old_price":"","name_original":"Пляжный коврик антипесок (1.5×2)","description_original":"Благодаря своей структуре, покрывало не пропускает песок. Больше не придется каждый раз стряхивать скопившийся песок на покрывале. Достаточно прилечь и наслаждаться солнце и морем. А его размеры позволяют с комфортом разместить сразу несколько людей. Эластичная ткань, из которой он состоит, делает коврик универсальным,его можно брать с собой на отдых вне зависимости от местности. Пикник, поход, отдых на берегу реки или моря теперь не будет омрачёны песком, который просачивается даже в самые мелкие щели и дырочки.","name":"Beach anti-sandbag (1.5 × 2)","description":"Due to its structure, the cover does not let sand pass. No longer have to shake off the accumulated sand on the blanket every time. It's enough to lie down and enjoy the sun and the sea. And its size allows you to comfortably accommodate several people at once. The elastic fabric, from which it consists, makes the mat universal, it can be taken with you to rest, regardless of the terrain. A picnic, trekking, rest on the bank of the river or the sea will no longer be overshadowed by sand, which seeps even into the smallest cracks and holes.","slug":"beach-anti-sandbag-15--2-si2b8r","date_created":1536680364,"date_updated":1536680364,"date_published":1536680364,"url":"/RU/kazan/category/beach-anti-sandbag-15--2-si2b8r","url_branch":"https://i.adverto.sale/K34a/si2b8r","short_url":"https://adverto.sale/si2b8r","group_id":1,"group_text":"","favorite_counter":0,"distance":"","is_published":true,"is_sold":false,"is_deleted":false,"is_blocked":false,"is_expiring":false,"is_allocated":false,"is_archived":false,"is_favorite":false,"is_top":false,"viewed":false,"views":663,"owner":{"id":"f5fURAxg"},"currency":{"code":"RUB","symbol":"₽","symbol_html":"\u0026#x584;"},"location":{"city":"Kazan","description":"RU, Kazan","latitude":55.838625,"longitude":49.13719},"images":[{"hash":"003oz4s2bjk11lqoga1q6sj6","url":"https://cache.adverto.sale/files/images/original/00/3o/003oz4s2bjk11lqoga1q6sj6.jpg","width":720,"height":716,"sort":0}]}],"status":200,"detail":"Adverts list","uri":"/adverts","meta":{"search_id":"ZpkvunJUhwUnj75i","engine":1,"sid":"8qEyXyncf1Ag9dAz"}}
  • Location
  • City

Use your mouse to drag and select the location where you want to find goods or services. You can then expand or contract the search radius around your selected point

  • Clear
  • Apply
  • Clear
  • Apply
Contact Support
Contact Support

Your message has been successfully sent

Log in or Register
Choose a country

A message with an activation code was sent to the specified phone number

By signing in or registering, you agree to the Terms & Conditions and Privacy Policy

A message with an activation code was sent to the specified phone number

Enter the received code. If you have not received the code within 1 minute, then press the button to be send again.

Contact Support

The activation code was sent to the specified email address.

Enter the code from email

Contact Support
Register as a private person

If you are not a store, you do not have a legal entity and you want to publish ads without quantity limits, then select this option

Register your store

If you are a private entrepreneur or company and want to publish ads without quantity limits, you want to download ads from your website in one-click, and set delivery rates for different regions and countries, then select this option

Register as a private person
Register your store
By signing in or registering, you agree to the Terms & Conditions and Privacy Policy