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.0000394464{main}( ).../get_location_by_gps.php:0
20.0041598816getCountryAndCityByGPS( $latitude = '46.793', $longitude = '24.714' ).../get_location_by_gps.php:50
30.0041598840getLocationByGPS( $lat = '46.793', $lng = '24.714' ).../lib.php:1370
40.0046692728PommProject\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.0046694624PommProject\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.0047694784PommProject\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.0047694784PommProject\Foundation\Session\Connection->getHandler( ).../Connection.php:418
80.0047694784PommProject\Foundation\Session\Connection->launch( ).../Connection.php:132
90.0047694896pg_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.0000394464{main}( ).../get_location_by_gps.php:0
20.0041598816getCountryAndCityByGPS( $latitude = '46.793', $longitude = '24.714' ).../get_location_by_gps.php:50
30.0041598840getLocationByGPS( $lat = '46.793', $lng = '24.714' ).../lib.php:1370
40.0046692728PommProject\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.0046694624PommProject\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.0047694784PommProject\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.0047694784PommProject\Foundation\Session\Connection->getHandler( ).../Connection.php:418
80.0047694784PommProject\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%22G3bOLF%22%2C%22uid%22%3A%22%22%2C%22timestamp%22%3A1614572285%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":"G3bOLF","id_lang":"ru","lang_advert":"ru","owner":{"display_phone_num":"79029226431","settings":{"display_phone":"true","location":{"description":"Krasnoyarsk, Russia"}},"id":"sQecv6Wy","name":"Ирина И.","date_registered":"1533537445","is_shop":"false","image":{"id":"","url":"","sort":""},"isOnline":"false","onlineText":"Offline","rating_mark":"5","rating_mark_cnt":"0","prods_active_cnt":"100","prods_sold_cnt":"0","subscription_date_added":"0","is_subscribed":"false"},"name_original":"Заколка","description_original":"","name":"Barrette","description":"","slug":"barrette-G3bOLF","price":"10","currency":{"code":"RUB","symbol":"₽","symbol_html":"\u0026#x584;"},"old_price":"","date_created":"1533542367","date_updated":"1602041291","date_published":"1602041291","date_sold":"0","date_archivation":"1538726367","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":"2","is_allocated":"false","block_mode":"0","block_type":"0","block_type_text":"","is_archived":"false","archive_mode":"1","images":[{"id":"00zampofle069ql0zmv6uam9","sort":"0","url":"https://cache.adverto.sale/files/images/original/00/za/00zampofle069ql0zmv6uam9.jpg","width":"2000","height":"1500"},{"id":"00r9k9tav2ofufb5oik96n8y","sort":"1","url":"https://cache.adverto.sale/files/images/original/00/r9/00r9k9tav2ofufb5oik96n8y.jpg","width":"1500","height":"2000"}],"location":{"city":"","description":"Russia","latitude":"56.038454","longitude":"92.873663","dist":{"value":68.8,"units":"km"}},"category":"914","is_favorite":"false","date_favorited":"0","views":"770","favorite_counter":"0","group_id":1,"url":"/RU/all/category/barrette-G3bOLF","url_branch":"https://i.adverto.sale/K34a/G3bOLF","short_url":"https://adverto.sale/G3bOLF","contacts_visible":"true","degradation":"2","fields":[],"is_price_subscribed":"false"},"status":200,"detail":"Advert","uri":"/advert/G3bOLF"} Barrette - Advert to sell, price 10 RUB, Posted: 07.10.2020
Location
Ad location
Russia
Russia 68.8 km from you
View on map
Ирина И.
Krasnoyarsk, Russia
I speak:
  • Flowerpot for macrame flowers
  • Slippers for girls
  • Cut fabric 106 * 50
  • Candles for children
  • 770 Views
  • Posted 07.10.20
Description from Seller
Used

Ad location
Russia
Russia 68.8 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%22G3bOLF%22%2C%22uid%22%3A%22%22%2C%22timestamp%22%3A1614572286%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":"tuqrTS","id_lang":"ru","category":914,"lang_advert":"ru","price":"50","old_price":"","name_original":"Браслет","description_original":"","name":"A bracelet","description":"","slug":"a-bracelet-tuqrTS","date_created":1535040631,"date_updated":1609250338,"date_published":1535040631,"url":"/RU/all/category/a-bracelet-tuqrTS","url_branch":"https://i.adverto.sale/K34a/tuqrTS","short_url":"https://adverto.sale/tuqrTS","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":704,"owner":{"id":"TqHNKdR1"},"currency":{"code":"RUB","symbol":"₽","symbol_html":"\u0026#x584;"},"location":{"city":"","description":"RU","latitude":56.066433,"longitude":92.916796},"images":[]},{"id":"3An67x","id_lang":"ru","category":914,"lang_advert":"ru","price":"50","old_price":"","name_original":"Кольцо","description_original":"","name":"Ring","description":"","slug":"ring-3An67x","date_created":1535036918,"date_updated":1609246695,"date_published":1535036918,"url":"/RU/all/category/ring-3An67x","url_branch":"https://i.adverto.sale/K34a/3An67x","short_url":"https://adverto.sale/3An67x","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":647,"owner":{"id":"TqHNKdR1"},"currency":{"code":"RUB","symbol":"₽","symbol_html":"\u0026#x584;"},"location":{"city":"","description":"RU","latitude":56.066433,"longitude":92.916796},"images":[]},{"id":"EXkB0D","id_lang":"ru","category":914,"lang_advert":"ru","price":"50","old_price":"","name_original":"Подвеска","description_original":"Бижутерия","name":"Suspension","description":"Bijouterie","slug":"suspension-EXkB0D","date_created":1535040227,"date_updated":1609163961,"date_published":1535040227,"url":"/RU/all/category/suspension-EXkB0D","url_branch":"https://i.adverto.sale/K34a/EXkB0D","short_url":"https://adverto.sale/EXkB0D","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":"TqHNKdR1"},"currency":{"code":"RUB","symbol":"₽","symbol_html":"\u0026#x584;"},"location":{"city":"","description":"RU","latitude":56.066433,"longitude":92.916796},"images":[]},{"id":"kCper3","id_lang":"ru","category":914,"lang_advert":"ru","price":"150","old_price":"","name_original":"Подвеска и кольцо","description_original":"Цена за все ","name":"Pendant and ring","description":"Price for all","slug":"pendant-and-ring-kCper3","date_created":1535036963,"date_updated":1609128794,"date_published":1535036963,"url":"/RU/all/category/pendant-and-ring-kCper3","url_branch":"https://i.adverto.sale/K34a/kCper3","short_url":"https://adverto.sale/kCper3","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":628,"owner":{"id":"TqHNKdR1"},"currency":{"code":"RUB","symbol":"₽","symbol_html":"\u0026#x584;"},"location":{"city":"","description":"RU","latitude":56.066433,"longitude":92.916796},"images":[]},{"id":"FJOQKh","id_lang":"ru","category":914,"lang_advert":"ru","price":"50","old_price":"","name_original":"Кольцо","description_original":"","name":"Ring","description":"","slug":"ring-FJOQKh","date_created":1535038543,"date_updated":1609120786,"date_published":1535038543,"url":"/RU/all/category/ring-FJOQKh","url_branch":"https://i.adverto.sale/K34a/FJOQKh","short_url":"https://adverto.sale/FJOQKh","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":683,"owner":{"id":"TqHNKdR1"},"currency":{"code":"RUB","symbol":"₽","symbol_html":"\u0026#x584;"},"location":{"city":"","description":"RU","latitude":56.066433,"longitude":92.916796},"images":[]},{"id":"HiKbqA","id_lang":"ru","category":914,"lang_advert":"ru","price":"50","old_price":"","name_original":"Кольцо","description_original":"","name":"Ring","description":"","slug":"ring-HiKbqA","date_created":1535037373,"date_updated":1609120699,"date_published":1535037373,"url":"/RU/all/category/ring-HiKbqA","url_branch":"https://i.adverto.sale/K34a/HiKbqA","short_url":"https://adverto.sale/HiKbqA","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":669,"owner":{"id":"TqHNKdR1"},"currency":{"code":"RUB","symbol":"₽","symbol_html":"\u0026#x584;"},"location":{"city":"","description":"RU","latitude":56.066433,"longitude":92.916796},"images":[]},{"id":"Vmqyo3","id_lang":"ru","category":914,"lang_advert":"ru","price":"1500","old_price":"","name_original":"Серебряный комплект","description_original":"","name":"Silver set","description":"","slug":"silver-set-Vmqyo3","date_created":1535040483,"date_updated":1609085598,"date_published":1535040483,"url":"/RU/all/category/silver-set-Vmqyo3","url_branch":"https://i.adverto.sale/K34a/Vmqyo3","short_url":"https://adverto.sale/Vmqyo3","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":671,"owner":{"id":"TqHNKdR1"},"currency":{"code":"RUB","symbol":"₽","symbol_html":"\u0026#x584;"},"location":{"city":"","description":"RU","latitude":56.066433,"longitude":92.916796},"images":[]},{"id":"CbZ1nb","id_lang":"ru","category":914,"lang_advert":"ru","price":"50","old_price":"","name_original":"Кольцо","description_original":"","name":"Ring","description":"","slug":"ring-CbZ1nb","date_created":1535036192,"date_updated":1609052372,"date_published":1535036192,"url":"/RU/all/category/ring-CbZ1nb","url_branch":"https://i.adverto.sale/K34a/CbZ1nb","short_url":"https://adverto.sale/CbZ1nb","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":675,"owner":{"id":"TqHNKdR1"},"currency":{"code":"RUB","symbol":"₽","symbol_html":"\u0026#x584;"},"location":{"city":"","description":"RU","latitude":56.066433,"longitude":92.916796},"images":[]},{"id":"hFtFe3","id_lang":"ru","category":914,"lang_advert":"ru","price":"50","old_price":"","name_original":"Брошь","description_original":"","name":"Brooch","description":"","slug":"brooch-hFtFe3","date_created":1535036137,"date_updated":1609023485,"date_published":1535036137,"url":"/RU/all/category/brooch-hFtFe3","url_branch":"https://i.adverto.sale/K34a/hFtFe3","short_url":"https://adverto.sale/hFtFe3","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":635,"owner":{"id":"TqHNKdR1"},"currency":{"code":"RUB","symbol":"₽","symbol_html":"\u0026#x584;"},"location":{"city":"","description":"RU","latitude":56.066433,"longitude":92.916796},"images":[]},{"id":"V6gEdh","id_lang":"ru","category":914,"lang_advert":"ru","price":"1500","old_price":"","name_original":"Серьги от Диор ","description_original":"Продам новые серьги булавки ","name":"Earrings from Dior","description":"Selling new earrings pins","slug":"earrings-from-dior-V6gEdh","date_created":1534936376,"date_updated":1608541110,"date_published":1534936376,"url":"/RU/all/category/earrings-from-dior-V6gEdh","url_branch":"https://i.adverto.sale/K34a/V6gEdh","short_url":"https://adverto.sale/V6gEdh","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":714,"owner":{"id":"LpDrD9Lt"},"currency":{"code":"RUB","symbol":"₽","symbol_html":"\u0026#x584;"},"location":{"city":"","description":"RU","latitude":55.995796,"longitude":92.759499},"images":[{"hash":"00omn16mhsoasvo4uc9b50a0","url":"https://cache.adverto.sale/files/images/original/00/om/00omn16mhsoasvo4uc9b50a0.jpg","width":1500,"height":2000,"sort":0}]},{"id":"AqDJIC","id_lang":"ru","category":914,"lang_advert":"ru","price":"2000","old_price":"","name_original":"Жемчужная нить","description_original":"Продам жемчужную нить длинную .жемчуг настоящий .","name":"Pearl thread","description":"Selling pearl thread is long.","slug":"pearl-thread-AqDJIC","date_created":1534933573,"date_updated":1608485287,"date_published":1534933573,"url":"/RU/all/category/pearl-thread-AqDJIC","url_branch":"https://i.adverto.sale/K34a/AqDJIC","short_url":"https://adverto.sale/AqDJIC","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":688,"owner":{"id":"LpDrD9Lt"},"currency":{"code":"RUB","symbol":"₽","symbol_html":"\u0026#x584;"},"location":{"city":"","description":"RU","latitude":55.995796,"longitude":92.759499},"images":[{"hash":"00ozbvlv8armqtw0qo98yrhb","url":"https://cache.adverto.sale/files/images/original/00/oz/00ozbvlv8armqtw0qo98yrhb.jpg","width":780,"height":1040,"sort":0}]},{"id":"1dSJYu","id_lang":"ru","category":914,"lang_advert":"ru","price":"1200","old_price":"","name_original":"Браслет","description_original":"Новый браслет из жемчуга","name":"A bracelet","description":"New pearl bracelet","slug":"a-bracelet-1dSJYu","date_created":1526280564,"date_updated":1606476573,"date_published":1526280564,"url":"/RU/all/category/a-bracelet-1dSJYu","url_branch":"https://i.adverto.sale/K34a/1dSJYu","short_url":"https://adverto.sale/1dSJYu","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":718,"owner":{"id":"LN2tSYFh"},"currency":{"code":"RUB","symbol":"₽","symbol_html":"\u0026#x584;"},"location":{"city":"","description":"RU","latitude":56.016988,"longitude":92.961999},"images":[{"hash":"00jqzsocoqdcpx9pnyu7jn60","url":"https://cache.adverto.sale/files/images/original/00/jq/00jqzsocoqdcpx9pnyu7jn60.jpg","width":918,"height":1632,"sort":0},{"hash":"0083rjpaot0eyho9amab7u2p","url":"https://cache.adverto.sale/files/images/original/00/83/0083rjpaot0eyho9amab7u2p.jpg","width":1632,"height":918,"sort":1}]}],"status":200,"detail":"Adverts list","uri":"/adverts","meta":{"search_id":"K4OfQNnMtiLP4jKs","engine":1,"sid":"IETyZuZwUGaPNarz"}}
  • 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