コード例 #1
0
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;
}
コード例 #2
0
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;
}
コード例 #3
0
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);
}