Verfasst: 31.12.2003 16:33
Ich hatte mir von http://www.bananeweizen.de/ die aktuellste Version heruntergeladen ...da steht´s drin.
phpBB.de - Die deutsche phpBB-Community
https://www.phpbb.de/community/
Code: Alles auswählen
$sql = "SELECT u.user_id, u.username, u.user_from, m.longitude, m.latitude
FROM " . USERS_TABLE . " u, " . MAP_MOD_USER_TABLE . " m
WHERE u.user_id = m.user_id
AND (m.longitude != 0 OR m.latitude != 0)";
Code: Alles auswählen
$sql = "SELECT u.user_id, u.username, u.user_from, u.user_motorrad, m.longitude, m.latitude
FROM " . USERS_TABLE . " u, " . MAP_MOD_USER_TABLE . " m
WHERE u.user_id = m.user_id
AND (m.longitude != 0 OR m.latitude != 0)";
Code: Alles auswählen
'ID' => $user['user_id'],
'USERNAME' => $user['username'],
'LOCATION' => $user['user_from'],
'DISTANCE' => $user['distance'],
'LONGITUDE' => $user['longitude'],
'LATITUDE' => $user['latitude'],
'U_PROFILE' => $user['u_profile'],
'U_MAP' => $user['u_map']
Code: Alles auswählen
'ID' => $user['user_id'],
'USERNAME' => $user['username'],
'LOCATION' => $user['user_from'],
'MOTORRAD' => $user['user_motorrad'],
'DISTANCE' => $user['distance'],
'LONGITUDE' => $user['longitude'],
'LATITUDE' => $user['latitude'],
'U_PROFILE' => $user['u_profile'],
'U_MAP' => $user['u_map']
Code: Alles auswählen
'NAME' => $user_row['username'],
'LOCATION' => $user_row['user_from'],
'DISTANCE' => distance_string($d),
'LONGITUDE' => coord_to_string($row['longitude']),
'LATITUDE' => coord_to_string($row['latitude']),
Code: Alles auswählen
'NAME' => $user_row['username'],
'LOCATION' => $user_row['user_from'],
'MOTORRAD' => $user_row['user_motorrad'],
'DISTANCE' => distance_string($d),
'LONGITUDE' => coord_to_string($row['longitude']),
'LATITUDE' => coord_to_string($row['latitude']),
Code: Alles auswählen
'L_LATITUDE_HELP' => $lang['map_latitudehelp'],
'L_USER' => $lang['Username'],
'L_LOCATION' => $lang['Location'],
'L_TITLE' => $lang['map_page_title'],
'L_USER_DETAILS' => $lang['map_user_details'],
Code: Alles auswählen
'L_LATITUDE_HELP' => $lang['map_latitudehelp'],
'L_USER' => $lang['Username'],
'L_LOCATION' => $lang['Location'],
'L_MOTORRAD' => $lang['Motorrad'],
'L_TITLE' => $lang['map_page_title'],
'L_USER_DETAILS' => $lang['map_user_details'],
Code: Alles auswählen
<tr>
<th class="thCornerL" height="25" nowrap align="left"> {L_NAME} </th>
<th class="thTop" nowrap align="left"> {L_LOCATION} </th>
<th class="thCornerR" nowrap align="right"> {L_DISTANCE} </th>
</tr>
<!-- BEGIN users_near -->
<tr>
<td class="row1" align="left"><span class="gen"><a href="{switch_users_near.users_near.U_PROFILE}">{switch_users_near.users_near.NAME}</a></span></td>
<td class="row2" align="left"><span class="gen"><a href="{switch_users_near.users_near.U_LOCATION}">{switch_users_near.users_near.LOCATION}</a></span></td>
<td class="row1" align="right"><span class="gen">{switch_users_near.users_near.DISTANCE}</span></td>
</tr>
<!-- END users_near -->
Code: Alles auswählen
<tr>
<th class="thCornerL" height="25" nowrap align="left"> {L_NAME} </th>
<th class="thTop" nowrap align="left"> {L_LOCATION} </th>
<th class="thTop" nowrap align="left"> {L_MOTORRAD} </th>
<th class="thCornerR" nowrap align="right"> {L_DISTANCE} </th>
</tr>
<!-- BEGIN users_near -->
<tr>
<td class="row1" align="left"><span class="gen"><a href="{switch_users_near.users_near.U_PROFILE}">{switch_users_near.users_near.NAME}</a></span></td>
<td class="row2" align="left"><span class="gen"><a href="{switch_users_near.users_near.U_LOCATION}">{switch_users_near.users_near.LOCATION}</a></span></td>
<td class="row2" align="left"><span class="gen">{switch_users_near.users_near.MOTORRAD}</span></td>
<td class="row1" align="right"><span class="gen">{switch_users_near.users_near.DISTANCE}</span></td>
</tr>
<!-- END users_near -->