function ContactJoinGet($lang, $id)
{
$result = mysql_query(createJoinQuery($lang) . " WHERE Main.id='" . $id . "'");
return ContactFillAll($result, 0);
}
$searchcriteria = SearchCriteriaCreateFromPost();
$lang = getGet("lang", getPost("lang", "language1"));
include "top.php";
//echo("start ".microtime_float()."<br/>");
//$starttime = microtime_float();
$query = createQuery($lang, $searchcriteria->group, $searchcriteria->location, $searchcriteria->media, $searchcriteria->searchterm, "true");
//echo $query;
$result = mysql_query($query);
//echo "<br/>".mysql_error();
$num = mysql_numrows($result);
include "form.php";
$i = 0;
echo "<div class=\"listarea\">\n";
while ($i < $num) {
echo "<div class=\"listelement\">\n";
$contact = ContactFillAll($result, $i);
$contact->prepareForHTML();
echo "<h3 class=\"structuretitle\">" . $contact->m[1] . "</h3>\n";
//name
echo "<table class=\"shortlistelement\" width=\"100%\"" . ($num == 1 ? "style=\"display: none\"" : "") . ">\n";
echo "<tr><td width=\"61.8%\">" . $contact->m[2] . "</td>\n";
//kurzbeschreibung
echo "<td style=\"padding-left: 15px\" >" . $contact->m[5] . "<br/><br/></td>\n";
//BasisAdresse
echo "<td align=\"right\"><a class=\"showdetaillink\"><img src=\"TEX/down.png\" alt=\"down\" border=\"0\"/></a></td></tr>\n";
echo "</table>\n";
echo "<table class=\"longlistelement\" width=\"100%\" " . ($num > 1 ? "style=\"display: none\"" : "") . ">\n";
echo "<tr><td valign=\"top\" width=\"300\">\n";
if (!empty($contact->m[13])) {
echo "<img src=\"TEX/" . $contact->m[13] . "\" alt=\"imgage or logo\" width=\"200\" /><br/><br/>\n";
}
$httpendpos = strlen($address);
if (strpos($address, " ", $httppos)) {
$httpendpos = strpos($address, " ", $httppos) - 1;
} else {
if (strpos($address, "\n", $httppos) && strpos($address, "\n", $httppos) < $httpendpos) {
$httpendpos = strpos($address, "\n", $httppos) - 1;
}
}
$link = substr($address, $httppos, $httpendpos - $httppos);
$linklist = $linklist . $link . ", ";
$address = substr($address, $httpendpos);
}
$contact->prepareForHTML();
$query_language2 = createQueryById("language2", $contact->m[0]);
$result_language2 = mysql_query($query_language2);
$contact_language2 = ContactFillAll($result_language2, 0);
$contact_language2->prepareForHTML();
$id = $contact->m[0];
echo "<td rowspan=\"2\"><a href=\"edit.php?id=" . $id . "\">edit</a><br/><a href=\"delete.php?id=" . $id . "\">delete</a></td>\n";
$maillist = $maillist . (strlen($contact->m[$map["e_mail"]]) > 0 ? $contact->m[$map["e_mail"]] . ", " : "");
echo "<td>" . $l_language_id["language1"] . "</td>";
for ($j = 0; $j < $numColumns; $j++) {
echo "<td>" . $contact->m[$j] . "</td>\n";
}
echo "</tr><tr><td>" . $l_language_id["language2"] . "</td>\n";
for ($j = 0; $j < $numColumns; $j++) {
echo "<td>" . $contact_language2->m[$j] . "</td>\n";
}
echo "</tr>\n";
$i++;
}
