1. Alex
  2. Newbie area
  3. Wednesday, 19 March 2014
  4.  Subscribe via email
I am creating a custom list of hotspots directly from the database.
I need to build a HREF link to individual hotspot from the database.
I've noticed the individual hotspot URL is excellent for SEF but quite complex to generate from the database, example
You have both category name and spot name, with special characters stripped or substituted, and length capped at 45 chars...
Can you please help? Perhaps there is an easier way to generate a link just by using the ID?

PS so far my SQL query:
SELECT j0385_hotspots_marker.name as Name, cat_name as Type, CASE left(plz,1) WHEN '0' THEN 'Northern Territory' WHEN '2' THEN 'New South Wales' WHEN '3' THEN 'Victoria' WHEN '4' THEN ' Queensland ' WHEN '5' THEN ' South Australia' WHEN '6' THEN 'Unknown' WHEN '7' THEN 'Tasmania' ELSE 'Unknown' END as State , town as Suburb, plz as Postcode, street as Address FROM j0385_hotspots_marker, j0385_hotspots_categorie where j0385_hotspots_categorie.id = catid
Responses (0)

There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Last questions

Show all markers (and keep paginated list)?
For my particular use case it makes more sense to do marker clusters than tiles....
1 Replies
Posted on Thursday, 19 May 2022
  • New
  • Two message dialogs when submitting hotspot
    Hi! I noticed that there are two Joomla messages shown when a hotspot is subm...
    1 Replies
    Posted on Thursday, 05 May 2022
    Error when category filters return fewer results t
    Basically what I said. Easy way to reproduce: Go to a map with lots of ho...
    0 Replies
    Posted on Thursday, 19 May 2022
  • New
  • Filter by custom field and/or date?
    Hi and happy Monday! First of all, thanks for your patience and support while...
    17 Replies
    Posted on Monday, 25 April 2022
  • Resolved
  • Landscape certificate
    Hello Compojoom Team. We need the PDFs of the certificates to have a horizontal ...
    0 Replies
    Posted on Wednesday, 18 May 2022
  • New