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++; }