Hello again Daniel,
after some experiments I found an easy way to create a simple list of all hotspots in a new tab. It based on your explanation for creating a new tab:
http://compojoom.com/forum/27-hotspots/52-newbie-area/9661-adding-new-tab#p11098
The only thing I did, was to replace the code in Line 317
with this code:
$user = "PUT HERE THE USERNAME OF YOUR DATABASE";
$pass = "PUT HERE THE PASSWORD OF YOUR DATABASE";
$dbase = "PUT HERE THE NAME OF YOUR DATABASE";
$db = mysql_connect($host, $user, $pass) or die ("connection error");
mysql_select_db($dbase, $db) or die ("no connection to the database");
$select = "select * from jos_hotspots_marker";
$result = mysql_query($select,$db);
if($result){
echo "<table>";
while($row = mysql_fetch_array($result)){
echo "<tr><td rowspan=\"4\"><img src=\"http://YOUR.DOMAIN.COM/media/com_hotspots/images/thumbs/".$row['picture_thumb']."\" /></td><td><a href=\"http://YOUR.DOMAIN.COM/index.php?option=com_hotspots&view=hotspot&id=".$row['id']."\"><strong>".$row['name']."</strong></a></td></tr>";
echo "<tr><td>".$row['street']."</td></tr>";
echo "<tr><td>".$row['plz']." ".$row['town']."</td></tr>";
echo "<tr><td>".$row['description_small']."</td></tr>";
}
echo "</table>";
}
You just have to replace the BIG LETTERS with your data and it creates a simple list with tumbnail, name with link, adress and short description in a new tab. One problem I have is, that special letters (like ä,ö,ü,ß) don't showed correctly. Maybe you know why? Another: If someone kicks on one of links in the list there is no link one the page of the hotspot to get back to list and not to the map.
Maybe someone here can use it or can make some suggestions to make this little part of code better...
Here is a link to the page where I tested it:
http://leertest.klapperfeld.de/index.php?option=com_hotspots&view=all&Itemid=54
(plaese ignore the design, it is only for testing)
)
