function sample_group_create($user_id, $comment = NULL) { $con = db_open(); $sql = sample_group_insert_SQL($user_id, $comment); db_table_lock("SampleGroups", $con); $result = mysql_query($sql, $con); $id = mysql_insert_id($con); db_table_unlock($con); return $id; }
function sample_create($datetime, $latitude, $longitude, $location_error, $computed_location, $location_name, $temperature, $humidity, $co, $co2, $pm2_5, $pm10, $no, $no2, $so2, $o3, $group_id, $user_id) { global $con; $con = db_open(); $sql = sample_insert_SQL($datetime, $latitude, $longitude, $location_error, $computed_location, $location_name, $temperature, $humidity, $co, $co2, $pm2_5, $pm10, $no, $no2, $so2, $o3, $group_id, $user_id); //echo "SQL: $sql\n"; db_table_lock("Samples", $con); $result = mysql_query($sql, $con); $id = mysql_insert_id($con); db_table_unlock($con); return $id; }
function user_password_set($user_id, $new_password) { if (!isset($user_id) || !isset($new_password)) { return; } $con = db_open(); db_table_lock("Users", $con); $salt = uniqid(); $hash = sha1($salt . $new_password . $salt); $sql = "UPDATE `Users` SET `password_hash`='{$hash}', `password_salt`='{$salt}' WHERE `id`={$user_id}"; $result = mysql_query($sql, $con); db_table_unlock($con); }