Hotspots by Waindigo [Deleted]

Is there any special reason why you're using VARCHAR(255 for lat & lng?
I'm curious because i've seen many different types being used ( http://dev.mysql.com/doc/refman/5.7/en/spatial-extensions.html, mediumtext, double, float,..) in different applications

https://developers.google.com/maps/articles/phpsqlsearch_v3?hl=de


I'm helpless because i don't know what to use for my application on mysql side for best performance, that's also the reason why we want to use elasticsearch http://www.elasticsearch.org/blog/geo-location-and-search/ for the search for the search, but this doesn't solve the question for the perfect data type :D
 
I don't know where to post this so I'll post it here.

Fatal error: Call to undefined function get_called_class() in /home/xxx/public_html/2dmods.com/library/Waindigo/Listener/ControllerPreDispatch/20130625.php on line 79

If I rename the Waindigo directory to Waindigo1 I get this error above the forum.

Template Errors: PAGE_CONTAINER
  1. array_key_exists() [<a href='function.array-key-exists'>function.array-key-exists</a>]: The second argument should be either an array or an object in /home/xxx/public_html/2dmods.com/library/XenForo/Template/Abstract.php(265) : eval()'d code, line 1845:
    1844: ';
    1845: if ((strpos($controllerName, ('Waindigo')) === 0 || array_key_exists($controllerName, $xenOptions['waindigo_loadClassHints'])) && !$waindigoCopyrightShown)
    1846: {
 
Matthew Hawley said:
I don't know where to post this so I'll post it here.

Fatal error: Call to undefined function get_called_class() in /home/xxx/public_html/2dmods.com/library/Waindigo/Listener/ControllerPreDispatch/20130625.php on line 79

If I rename the Waindigo directory to Waindigo1 I get this error above the forum.

Template Errors: PAGE_CONTAINER
  1. array_key_exists() [<a href='function.array-key-exists'>function.array-key-exists</a>]: The second argument should be either an array or an object in /home/xxx/public_html/2dmods.com/library/XenForo/Template/Abstract.php(265) : eval()'d code, line 1845:
    1844: ';
    1845: if ((strpos($controllerName, ('Waindigo')) === 0 || array_key_exists($controllerName, $xenOptions['waindigo_loadClassHints'])) && !$waindigoCopyrightShown)
    1846: {
Click to expand...

Anyone? Waindigo?
 
Matthew Hawley said:
I don't know where to post this so I'll post it here.

Fatal error: Call to undefined function get_called_class() in /home/xxx/public_html/2dmods.com/library/Waindigo/Listener/ControllerPreDispatch/20130625.php on line 79

If I rename the Waindigo directory to Waindigo1 I get this error above the forum.

Template Errors: PAGE_CONTAINER
  1. array_key_exists() [<a href='function.array-key-exists'>function.array-key-exists</a>]: The second argument should be either an array or an object in /home/xxx/public_html/2dmods.com/library/XenForo/Template/Abstract.php(265) : eval()'d code, line 1845:
    1844: ';
    1845: if ((strpos($controllerName, ('Waindigo')) === 0 || array_key_exists($controllerName, $xenOptions['waindigo_loadClassHints'])) && !$waindigoCopyrightShown)
    1846: {
Click to expand...
Why would you rename the Waindigo directory?
 
Matthew Hawley said:
Because I get this error on every page.

Fatal error: Call to undefined function get_called_class() in /home/xxx/public_html/2dmods.com/library/Waindigo/Listener/ControllerPreDispatch/20130625.php on line 79
Click to expand...
That error is because you have PHP 5.2 installed. I will post a fix for this soon.
 
xf_phantom said:
Is there any special reason why you're using VARCHAR(255 for lat & lng?
I'm curious because i've seen many different types being used ( http://dev.mysql.com/doc/refman/5.7/en/spatial-extensions.html, mediumtext, double, float,..) in different applications

https://developers.google.com/maps/articles/phpsqlsearch_v3?hl=de

I'm helpless because i don't know what to use for my application on mysql side for best performance, that's also the reason why we want to use elasticsearch http://www.elasticsearch.org/blog/geo-location-and-search/ for the search for the search, but this doesn't solve the question for the perfect data type :D
Click to expand...
Probably it is not the most efficient data type, but it works. I guess the main reason we selected it is because accuracy is so important, particularly for the client who we originally developed for.
 
Stuart Wright said:
Is it possible to have multiple maps?
Click to expand...
Sorry for the late reply. No, this is not really possible but is something that could be easily added. I would like to make map nodes so that each map could have its own permissions, and then you could decide which maps you want tabs for etc. using Nodes As Tabs. Let me know if you have anything left in your budget to contribute for this.
 
Waindigo said:
Sorry for the late reply. No, this is not really possible but is something that could be easily added. I would like to make map nodes so that each map could have its own permissions, and then you could decide which maps you want tabs for etc. using Nodes As Tabs. Let me know if you have anything left in your budget to contribute for this.
Click to expand...
John we use maps in a couple of scenarios:
  1. A map of custom installers/calibrators. People have to pay us to be listed here http://www.avforums.com/forums/cust...ok-here-find-custom-installer-calibrator.html
  2. A map of UK food eating challenges which I would like our members to be able to contribute to but with with the restriction that the establishment must have a web page which details the challenge. Members must be able to report bad entries. http://www.avforums.com/forums/gene...allenge-venues-view-map-suggest-new-ones.html
In the second case, people can comment.

Hadn't considered doing anything more sophisticated than this until I spotted this resource. How long do you think it would take you?
 
Is it possible to add a comments section? This can be great for store reviews, business reviews, user reviews etc. I think I saw in the image you can link it to a thread, but can this be done automatically, or rather a section which allows users to comment?

Thanks.
 
Dynamic said:
Is it possible to add a comments section? This can be great for store reviews, business reviews, user reviews etc. I think I saw in the image you can link it to a thread, but can this be done automatically, or rather a section which allows users to comment?

Thanks.
Click to expand...
Adding a comments section or linking to a thread automatically are not possible at the moment but could be added. If you require comments you may wish to discuss with @Stuart Wright as this is one of the requirements he mentioned here.
 
Actually there will be no map loaded .. i have no errors in xf 1.2.0 beta5
 

Attachments

  • no-map.webp
    no-map.webp
    7.3 KB · Views: 7
You must log in or register to reply here.
Top Bottom