1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
|
/* Begin User-Map by Viktor */
$user_id = $wbbuserdata['userid'];
if(isSet($_POST['longitude'])) $longitude = (float)($_POST['longitude']);
if(isSet($_POST['latitude'])) $latitude = (float)($_POST['latitude']);
if(isSet($_POST['zipcode'])) $zipcode = $_POST['zipcode'];
if(isSet($_POST['place'])) $place = $_POST['place'];
if ($longitude != '' && $latitude != '' && $zipcode != '' && $place != '') {
$vguser_map = $db->query_first("SELECT user_id FROM bb".$n."_map_mod_user WHERE user_id = '$wbbuserdata[userid]'");
if(!$vguser_map['user_id']) {
$db->query("INSERT INTO bb".$n."_map_mod_user (user_id,longitude,latitude,zipcode,place) VALUES ('".$wbbuserdata[userid]."', '".(float)$longitude."', '".(float)$latitude."', '".addslashes($zipcode)."', '".addslashes($place)."')");
} else {
$db->unbuffered_query("UPDATE bb".$n."_map_mod_user SET longitude='".(float)$longitude."', latitude='".(float)$latitude."', zipcode='".addslashes($zipcode)."', place='".addslashes($place)."' WHERE user_id ='$wbbuserdata[userid]'",1);
}
}
else{
$vguser_map = $db->query_first("SELECT user_id FROM bb".$n."_map_mod_user WHERE user_id = '$wbbuserdata[userid]'");
if($vguser_map['user_id']) {
$db->unbuffered_query("DELETE FROM bb".$n."_map_mod_user WHERE user_id = '$wbbuserdata[userid]'", 1);
}
}
/* End User-Map by Viktor */
|