1. Eliecer Marchante
  2. Tricks
  3. Tuesday, 26 June 2012
  4.  Subscribe via email
[color=#000088][b]FIRST PART[/color][/b]

To follow this tutorial you will need:
- OpenOffice.org 3.3.0 Calc
- Notepad ++
- Access to your website's PHPmyadmin


- Go to your PHPadmin and Select Databases
http://www.virtualbc.ca/images/11.jpg


- Select the database you are using with hotspots
http://www.virtualbc.ca/images/12.jpg

- These are the elements related with hotspots
http://www.virtualbc.ca/images/13.jpg

- Click on Browse
http://www.virtualbc.ca/images/14.jpg

-These are the fields to use with the OpenOffice.org Calc,
http://www.virtualbc.ca/images/15.jpg


but they must be in these order:
id - catid - name - street - plz - town - country - gmlat - gmlng - description - description_small - picture - picture_thumb - autor - autorip - autoruserid - postdate - vote - votenum - published
http://www.virtualbc.ca/images/16.jpg


The id and the catid, will match the category id number.
plz corresponds to the postal code
published - value 1 (the hotspot will be published), and value 0 (the hotspot won't be published)
Responses (6)


There are %s replies to this question. If you want to see them you need a valid subscription.
If you have a valid subscription, please login now.
Visit store now

Last questions

Hotspots Pro 6.0.13 compatability with Joomla 5.3.
Running Hotspots Pro 6.0.13 on Joomla 4.4.13 and want to upgrade to Joomla 5.3.1...
2 Replies
Posted on Friday, 04 July 2025
  • New
  • some questions on Hotspots
    Hi, On Hotspots extension : 1) is it possible to add our own map layer / v...
    0 Replies
    Posted on Thursday, 03 July 2025
    Trying to resize the image in the comments
    Hey everyone, Basically I am trying to make the images in the comments smalle...
    9 Replies
    Posted on Wednesday, 12 August 2009
    J5 compatibility for Hotspots
    Hi guys, Just started to update my old J3x website. Is there J5 compatibility p...
    2 Replies
    Posted on Monday, 24 February 2025
    • #Hotspots
    • #hotspots Joomla 5
    error message when adding/cofiguring email address
    When configuring the email plugin that send a email message to admin when a new ...
    0 Replies
    Posted on Friday, 09 May 2025