public static function setLocationByText($uid, $loc_text)
{
global $fp;
$loc = getLocationByText($loc_text);
$fp->log($loc);
$db = DB::get()->getConnection();
$stmt = $db->prepare("UPDATE user SET lon = :lon, lat = :lat, place = :p WHERE uid = :u");
if (!$stmt->execute(array(':u' => $uid, ':lon' => $loc->lon, ':lat' => $loc->lat, ':p' => $loc->text))) {
error_log("ERROR(setLocationByText): Update on the server failed!->" . join(", ", $stmt->errorInfo()));
return false;
}
return true;
}
public static function createEvent($owner, $name, $description, $location, $time, $phone_number, $hide_lastname, $quota, $gender)
{
global $fp;
$fp->log($location);
$loc = getLocationByText($location);
$fp->log($loc);
$db = DB::get()->getConnection();
$stmt = $db->prepare("INSERT INTO event (owner_uid, name, description, loc_text, loc_lon, loc_lat, time, phone, hide_last_name, quota, gender) VALUES (:uid, :name, :desc, :p, :lon, :lat, :t, :ph, :hide, :q, :g) ON DUPLICATE KEY UPDATE name=:name, description=:desc, loc_text=:p, loc_lat=:lat, loc_lon= :lon, phone= :ph, hide_last_name = :hide, quota = :q, gender = :g");
if (!$stmt->execute(array(':uid' => $owner, ':name' => $name, ':desc' => $description, ':p' => $loc->text, ':lon' => $loc->lon, ':lat' => $loc->lat, ':t' => gmdate("Y-m-d H:i:s", $time), ':ph' => $phone_number, ':hide' => $hide_lastname, ':q' => $quota, ':g' => $gender))) {
$err = "ERROR(CreateEvent): Update on the server failed!->" . join(", ", $stmt->errorInfo());
error_log($err);
$fp->log($err);
return false;
}
return true;
}
