[Loadstone] point share exchange

Milos Przic milos.przic at gmail.com
Sat Jul 20 14:28:25 BST 2013


Hello Shawn,
For me it now works very well! Excuse me for being late with my response, 
and thanks!
Best,
          Miloš Pržic
twitter: MilosPrzic
skype: Milosh-hs
----- Original Message ----- 
From: "Shawn Kirkpatrick" <shawn at loadstone-gps.com>
To: <loadstone at loadstone-gps.com>
Sent: Friday, July 19, 2013 1:45 AM
Subject: Re: [Loadstone] point share exchange


Thanks for this report. This should now be fixed so give it another try.

On Fri, 19 Jul 2013, Ari Moisio wrote:

> Hi
>
> Here the selection works but when donwloading data i got only message like
> this as an exported  data:
>
>   #!lsdb #Downloaded from pse.loadstone-gps.com on July 18 2013 23:18:45 
> GMT
> #Point share points
>
>                                                      LoadStone PointShare
>
> Error
>
>   An unexpected error has occured while processing your request. The
> information below may help us debug the problem.
>   Please include it in any bug reports.
>
>   error class pear
>   message DB Error: syntax error
>   debug info declare point cursor for select name, 
> cast(Y(latlong)*10000000
> as integer) as latitude,
>   cast(X(latlong)*10000000 as integer) as longitude,
> accuracy,satellites,priority,userid,id from point where latlong &&
> 
> '0106000020E61000000200000001030000000100000035000000100000C0ADCB394000000020A9134F401000000076CB3940000000C016134F4030
> 
> 0000E0E9CD3940080000E009134F4040000080B1CD39400000002077124F403000004025D03940080000006A124F4030000000EDCF394000000080D
> 
> 7114F40300000C0B4CF39400000002045114F404000002027D239400800000038114F4030000020F0D1394000000080A5104F40100000A0B7D13940
> 
> 2800000013104F401000008044CF3940100000C01F104F4050000060D1CC3940200000E02C104F40100000409ACC3940100000209A0F4F405000006
> 
> 061CC394010000040070F4F40500000A029CC3940F8FFFF1F750E4F40F0FFFF3FF1CB394008000060E20D4F4030000080B9CB3940180000E04F0D4F
> 
> 40300000C081CB394008000060BD0C4F403000008049CB3940000000A02A0C4F40F0FFFFFFD6C83940100000C0370C4F403000006064C6394010000
> 
> 080440C4F40300000209CC6394000000040D70C4F40F0FFFF9F29C4394010000020E40C4F4030000000B7C13940100000E0F00C4F40300000E043BF
> 
> 3940100000A0FD0C4F40000000807BBF394020000060900D4F404000006008BD3940F8FFFF3F9D0D4F40100000C095BA3940F8FFFFFFA90D4F40500
> 
> 000E0CCBA3940080000C03C0E4F40100000A004BB394010000040CF0E4F40200000C03BBB3940200000C0610F4F400000004073BB394010000080F4
> 
> 0F4F4040000060AABB39400000000087104F4040000020E2BB39402800008019114F40100000606EB939401000004026114F4020000000A6B939401
> 
> 0000020B9114F404000002032B73940100000E0C5114F4040000000BFB43940100000A0D2114F4010000020F6B439400000002065124F4010000040
> 
> 69B739400000006058124F4010000000A1B7394028000020EB124F4020000000D8B73940000000A07D134F40400000E04BBA3940000000E070134F4
> 
> 0300000A0BFBC3940080000C063134F40300000E087BC394018000040D1124F40100000C0FBBE394018000080C4124F40300000A06FC13940080000
> 
> A0B7124F4030000060A7C13940100000204A134F40500000201BC43940100000603D134F40500000408EC63940100000A030134F4010000000C6C63
> 
> 94000000020C3134F40F0FFFF7F3AC9394028000040B6134F40100000C0ADCB394000000020A9134F4001030000000100000081000000000000C07F
> 
> D239400000002069254F405000004047D23940280000A0D6244F40000000C0BDD4394000000080C9244F40200000A084D439402800000037244F40F
> 
> 0FFFFDF0ED239400000002044244F40400000E0D5D1394010000060B1234F40500000809DD13940100000401F234F40F0FFFF1F65D1394010000060
> 
> 8C224F4010000000DBD33940100000607F224F400000006051D639400000004072224F405000006018D63940100000C0DF214F40200000A0A2D3394
> 
> 010000080EC214F40000000206AD33940200000005A214F401000004031D33940080000A0C7204F40F0FFFFBFF8D239401800002035204F40000000
> 
> E0BFD2394018000040A21F4F400000002088D23940000000E00F1F4F40100000204FD23940280000607D1E4F4010000000DACF3940280000208A1E4
> 
> F40200000A0A1CF3940000000A0F71D4F403000004069CF394010000020651D4F403000000031CF394010000000D21C4F4040000000A6D139400000
> 
> 00A0C51C4F40000000401BD4394028000080B81C4F40500000C0E2D3394000000000261C4F4050000080AAD3394010000080931B4F402000004035D
> 
> 1394020000060A01B4F4020000000FDD03940F8FFFFDF0D1B4F40300000A0C4D03940080000607B1A4F40000000408CD03940180000A0E8194F4040
> 
> 00008054D03940180000C055194F4000000060DFCD3940080000E062194F4010000000A7CD3940100000C0D0184F40500000A06ECD3940000000003
> 
> E184F4050000000FACA3940200000004B184F4000000080C2CA394010000040B8174F40F0FFFFFF4DC8394010000000C5174F40F0FFFFBF15C83940
> 
> 0800008032174F40200000A0DEC7394008000020A0164F40F0FFFF5F69C53940080000E0AC164F40000000A0F5C23940080000A0B9164F401000004
> 
> 02DC33940080000804C174F40400000A0B8C039402800004059174F40F0FFFF1F81C03940000000C0C6164F40500000A00CBE394000000080D3164F
> 
> 40500000E0D4BD3940100000C040164F40200000209DBD394020000040AE154F403000006029BB394020000000BB154F4010000080B5B83940F8FFF
> 
> F1FC8154F400000000041B6394008000040D5154F401000002078B639400800006067164F40F0FFFF3F04B439400800002074164F40500000C08FB1
> 
> 3940080000A080164F40300000C0C6B13940F8FFFF5F13174F401000006052AF39400800004020174F405000008089AF3940080000A0B2174F40500
> 
> 000E014AD394018000080BF174F40300000E04BAD3940F8FFFFDF51184F4020000060D7AA3940080000C05E184F40000000600EAB394008000020F1
> 
> 184F404000008045AB39400800000084194F40500000007CAB394010000080161A4F405000006007A93940200000E0221A4F4000000060D0A839400
> 
> 80000C090194F40500000805AA63940080000409D194F40100000E024A63940180000C00A194F4040000060B0A339401800004017194F4000000040
> 
> 3BA13940080000A023194F40F0FFFFBF04A139401800002091184F4010000040909E3940180000A09D184F40300000E0599E3940080000200B184F4
> 
> 0F0FFFFBFE49B3940080000A017184F40F0FFFF1F709939402800006024184F40000000E0FB963940280000E030184F404000006031973940080000
> 
> 40C3184F40200000E067973940180000C055194F40000000609E973940180000A0E8194F4000000000D4973940080000607B1A4F40500000A05F953
> 
> 940080000E0871A4F40F0FFFF9F94953940080000401A1B4F40300000C0CB95394008000020AD1B4F402000008001963940100000A03F1C4F401000
> 
> 00E03796394010000000D21C4F40400000A0AD983940000000A0C51C4F4000000060E398394010000060581D4F4030000020599B3940100000A04B1
> 
> D4F40400000A08F9B394000000060DE1D4F40000000E0C59B3940280000E0701E4F4010000060FC9B3940280000C0031F4F4010000020729E394028
> 
> 000040F71E4F40200000A0A89E3940000000C0891F4F40500000E0DE9E3940080000801C204F4030000000699C39400800000029204F40400000809
> 
> F9C394018000080BB204F4050000000D69C3940080000404E214F40400000604C9F39401800002042214F40200000E0829F3940F8FFFF3FD4214F40
> 
> 10000040F9A1394020000020C7214F40400000006FA4394010000000BB214F4020000080E5A6394010000040AE214F40100000C01BA739402000000
> 
> 041224F402000006092A939400000004034224F40000000E008AC3940100000E027224F40500000E03FAC394010000040BA224F40100000A0B5AE39
> 
> 4028000080AD224F4010000060EDAE3940100000A040234F404000002063B139400000008033234F4010000040DAB33940000000C026234F4020000
> 
> 06011B4394008000040B9234F40100000C087B63940080000C0AC234F40500000E0FEB8394008000000A0234F402000000036B93940F8FFFF7F3224
> 
> 4F4010000060ACBB3940100000C025244F40F0FFFFDF22BE3940200000E018244F4030000020EBBD39401000002086234F4020000080B3BD3940080
> 
> 000A0F3224F405000004029C03940200000E0E6224F40000000C09FC23940100000C0D9224F4040000060D7C23940000000806C234F40300000C00F
> 
> C3394028000000FF234F401000004086C5394028000040F2234F4010000080BEC539400000000085244F4010000040F6C539400800008017254F405
> 
> 00000606DC83940F8FFFF1F0A254F4040000040E3CA3940F8FFFF9FFD244F40000000A01BCB3940100000C08F254F40400000C092CD394010000000
> 
> 83254F400000000009D039401000004076254F40000000C07FD239400000002069254F40'
> and priority & 1 != 1 and ((priority & 2) !=
>   2 or can_export_point(1674,userid)) and limit 150000 [nativecode=ERROR:
> syntax error at or near "limit" LINE 9:
>   can_export_point(1674,userid)) and limit 150000 ^]
>   HTTP_USER_AGENT Lynx/2.8.8dev.5 libwww-FM/2.14 SSL-MM/1.4.1 GNUTLS/2.8.6
>   REMOTE_ADDR 193.185.8.218
>   REQUEST_URI
> /export.php?_qf__export=&loclist=53812&submit%5Bdownload%5D=Download&datasource=both&osmdata=both&username=
>   REQUEST_TIME 2013-07-18 16:18:45
>
>     * [1]Home
>     * [2]Share your points
>     * [3]Get data near a point
>     * [4]Get data by civic location
>     * [5]Manage phone users
>     * [6]Manage QuickPoints
>     * [7]Erase your data
>     * [8]Account changes
>     * [9]Log out
>     * [10]LoadStone Home
>
> References
>
>   1. file://localhost/tmp/
>   2. file://localhost/tmp/import.php
>   3. file://localhost/tmp/export.php
>   4. file://localhost/tmp/export3.php
>   5. file://localhost/tmp/user.php
>   6. file://localhost/tmp/quickpoint.php
>   7. file://localhost/tmp/purge.php
>   8. file://localhost/tmp/account.php
>   9. file://localhost/tmp/logout.php
>  10. http://www.loadstone-gps.com/
>
>
>
>
> -- 
> mr. M01510 & guide Loadstone-GPS
> Lat: 62.38718, lon: 25.64672
> hkp://wwwkeys.pgp.net B784D020
> 0C1F 6A76 DC9D DD58 3383 8B5D 0E76 9600  B784 D02
>
>
> Shawn Kirkpatrick kirjoitti
>> Subject: Re: [Loadstone] point share exchange
>> Date: Thu, 18 Jul 2013 15:54:31 -0700 (PDT)
>> From: Shawn Kirkpatrick <shawn at loadstone-gps.com>
>> To: loadstone at loadstone-gps.com
>>
>> Then you're skipping the other combo box selections. When you make a
>> selection of the country other combo boxes will appear depending on the
>> country. The same will apply to these combo boxes. When there are no more
>> subregions for a country a list of checkboxes will appear letting you
>> select one or more locations.
>>
>> On Thu, 18 Jul 2013, Milos Przic wrote:
>>
>>> Hello Shawn,
>>> I do exactly as I should
>>> 1. I log in.
>>> 2. I click the link "get data by cyvic location"
>>> 3. I find the combo box and select the country (I tried with Poland,
>>> Serbia and US and then click next
>>> Then a page appears and it is titled "get data near a point". On that 
>>> page
>>> I can select whether I want pointshare, osm or boath, to enter latitude
>>> and longitude, to restrict the radius etc. So it just switches me to the
>>> wrong page.
>>> Best!
>>>         Milo? Pr?ic
>>> twitter: MilosPrzic
>>> skype: Milosh-hs
>>> ----- Original Message ----- From: "Shawn Kirkpatrick"
>>> <shawn at loadstone-gps.com>
>>> To: <loadstone at loadstone-gps.com>
>>> Sent: Thursday, July 18, 2013 3:08 AM
>>> Subject: Re: [Loadstone] point share exchange
>>>
>>>
>>> What are you doing that does this? If you go to the get data by civic
>>> location link you should end up at a page with instructions and below 
>>> that
>>> the first thing you'll see is a selection box for country. The only way
>>> you
>>> end up at the page where you can enter coordinates is if you don't 
>>> select
>>> anything and just click export.
>>> A step by step of what you're doing would help to solve this problem.
>>>
>>> On Thu, 18 Jul 2013, Milos Przic wrote:
>>>
>>>> Hello Shawn,
>>>> No, it doesn't work. It takes me to the section where one can get data
>>>> near a
>>>> point. So Itere are no further divisions of a country but edit fields
>>>> with
>>>> the stars for entering latitude and longitude.
>>>> That's not how it should work when getting data by cyvic location, 
>>>> right?
>>>> Thanks for your efforts!
>>>> Best,
>>>>         Milo? Pr?ic
>>>> twitter: MilosPrzic
>>>> skype: Milosh-hs
>>>> ----- Original Message ----- From: "Shawn Kirkpatrick"
>>>> <shawn at loadstone-gps.com>
>>>> To: <loadstone at loadstone-gps.com>
>>>> Sent: Thursday, July 18, 2013 1:40 AM
>>>> Subject: Re: [Loadstone] point share exchange
>>>>
>>>>
>>>> This problem should now be fixed so give it another try and see what
>>>> happens.
>>>>
>>>> On Wed, 17 Jul 2013, Ondrej Rosik wrote:
>>>>
>>>>> Hi,
>>>>> It doesn't work here:
>>>>> I click Get Points By Civic Location. The url is
>>>>> http://pse.loadstone-gps.com/export2.php
>>>>> But here are just instructions, no form fields.
>>>>>
>>>>>
>>>>> D?a 7/17/2013 7:34 AM Jacob Kruger  wrote / napísal(a):
>>>>>> Ok, sorry, found page on normal loadstone site now:
>>>>>> http://www.loadstone-gps.com/pointshare/
>>>>>>
>>>>>> I had looked for it under other list of tools, on the tools page.
>>>>>>
>>>>>> Stay well
>>>>>>
>>>>>> Jacob Kruger
>>>>>> Blind Biker
>>>>>> Skype: BlindZA
>>>>>> '...fate had broken his body, but not his spirit...'
>>>>>>
>>>>>> ----- Original Message ----- From: "Shawn Kirkpatrick"
>>>>>> <shawn at loadstone-gps.com>
>>>>>> To: <loadstone at loadstone-gps.com>
>>>>>> Sent: Wednesday, July 17, 2013 3:21 AM
>>>>>> Subject: Re: [Loadstone] point share exchange
>>>>>>
>>>>>>
>>>>>>> The point share has always had an export points by civic location
>>>>>>> function. The previous version didn't always work propperly thoe and
>>>>>>> the location data was rather lacking.
>>>>>>>
>>>>>>> On Tue, 16 Jul 2013, Jacob Kruger wrote:
>>>>>>>
>>>>>>>> Sorry, but, where do we test/try this out?
>>>>>>>>
>>>>>>>> TIA
>>>>>>>>
>>>>>>>> Jacob Kruger
>>>>>>>> Blind Biker
>>>>>>>> Skype: BlindZA
>>>>>>>> '...fate had broken his body, but not his spirit...'
>>>>>>>>
>>>>>>>> ----- Original Message ----- From: "Shawn Kirkpatrick"
>>>>>>>> <shawn at loadstone-gps.com>
>>>>>>>> To: <loadstone at loadstone-gps.com>
>>>>>>>> Sent: Tuesday, July 16, 2013 3:22 AM
>>>>>>>> Subject: [Loadstone] point share exchange
>>>>>>>>
>>>>>>>>
>>>>>>>>> Hello list.
>>>>>>>>> The export points by civic location function of the point share
>>>>>>>>> exchange has been rewritten and is now back online. All countries
>>>>>>>>> should now be included and be broken down by at least one region.
>>>>>>>>> The java version should now work propperly in all versions of
>>>>>>>>> internet explorer and firefox. The text version should work in all
>>>>>>>>> browsers.
>>>>>>>>> These exporters are quite new and will need some testing so please
>>>>>>>>> report any problems you may have.
>>>>>>>>>
>>>>>>>>> _______________________________________________
>>>>>>>>> Loadstone mailing list
>>>>>>>>> Loadstone at loadstone-gps.com
>>>>>>>>> http://www.loadstone-gps.com/mailman/listinfo/loadstone
>>>>>>>>>
>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> Loadstone mailing list
>>>>>>>> Loadstone at loadstone-gps.com
>>>>>>>> http://www.loadstone-gps.com/mailman/listinfo/loadstone
>>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> Loadstone mailing list
>>>>>>> Loadstone at loadstone-gps.com
>>>>>>> http://www.loadstone-gps.com/mailman/listinfo/loadstone
>>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> Loadstone mailing list
>>>>>> Loadstone at loadstone-gps.com
>>>>>> http://www.loadstone-gps.com/mailman/listinfo/loadstone
>>>>>>
>>>>> _______________________________________________
>>>>> Loadstone mailing list
>>>>> Loadstone at loadstone-gps.com
>>>>> http://www.loadstone-gps.com/mailman/listinfo/loadstone
>>>>>
>>>>>
>>>>
>>>>
>>>> __________ Information from ESET NOD32 Antivirus, version of virus
>>>> signature
>>>> database 8454 (20130616) __________
>>>>
>>>> The message was checked by ESET NOD32 Antivirus.
>>>>
>>>> http://www.eset.com
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> --------------------------------------------------------------------------------
>>>>
>>>>
>>>>> _______________________________________________
>>>>> Loadstone mailing list
>>>>> Loadstone at loadstone-gps.com
>>>>> http://www.loadstone-gps.com/mailman/listinfo/loadstone
>>>>>
>>>>>
>>>>>
>>>>> __________ Information from ESET NOD32 Antivirus, version of virus
>>>>> signature database 8454 (20130616) __________
>>>>>
>>>>> The message was checked by ESET NOD32 Antivirus.
>>>>>
>>>>> http://www.eset.com
>>>>>
>>>>>
>>>>
>>>>
>>>> __________ Information from ESET NOD32 Antivirus, version of virus
>>>> signature
>>>> database 8454 (20130616) __________
>>>>
>>>> The message was checked by ESET NOD32 Antivirus.
>>>>
>>>> http://www.eset.com
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Loadstone mailing list
>>>> Loadstone at loadstone-gps.com
>>>> http://www.loadstone-gps.com/mailman/listinfo/loadstone
>>>>
>>>>
>>>
>>>
>>> __________ Information from ESET NOD32 Antivirus, version of virus
>>> signature database 8454 (20130616) __________
>>>
>>> The message was checked by ESET NOD32 Antivirus.
>>>
>>> http://www.eset.com
>>>
>>>
>>>
>>>
>>>
>>>
>>> --------------------------------------------------------------------------------
>>>
>>>
>>>> _______________________________________________
>>>> Loadstone mailing list
>>>> Loadstone at loadstone-gps.com
>>>> http://www.loadstone-gps.com/mailman/listinfo/loadstone
>>>>
>>>>
>>>>
>>>> __________ Information from ESET NOD32 Antivirus, version of virus
>>>> signature database 8454 (20130616) __________
>>>>
>>>> The message was checked by ESET NOD32 Antivirus.
>>>>
>>>> http://www.eset.com
>>>>
>>>>
>>>
>>>
>>> __________ Information from ESET NOD32 Antivirus, version of virus
>>> signature database 8454 (20130616) __________
>>>
>>> The message was checked by ESET NOD32 Antivirus.
>>>
>>> http://www.eset.com
>>>
>>>
>>>
>>> _______________________________________________
>>> Loadstone mailing list
>>> Loadstone at loadstone-gps.com
>>> http://www.loadstone-gps.com/mailman/listinfo/loadstone
>>>
>>
>
> _______________________________________________
> Loadstone mailing list
> Loadstone at loadstone-gps.com
> http://www.loadstone-gps.com/mailman/listinfo/loadstone
>
>


__________ Information from ESET NOD32 Antivirus, version of virus signature 
database 8454 (20130616) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com




--------------------------------------------------------------------------------


> _______________________________________________
> Loadstone mailing list
> Loadstone at loadstone-gps.com
> http://www.loadstone-gps.com/mailman/listinfo/loadstone
>
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus 
> signature database 8454 (20130616) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
> 


__________ Information from ESET NOD32 Antivirus, version of virus signature database 8454 (20130616) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com





More information about the Loadstone mailing list