80 |
if (!$nesto && !$spec_0) $error |= 32; |
if (!$nesto && !$spec_0) $error |= 32; |
81 |
if (!$username) { $userok = true; $error |= 64; } |
if (!$username) { $userok = true; $error |= 64; } |
82 |
if ($username) { |
if ($username) { |
83 |
$sql = "SELECT user_id FROM users WHERE (username = '$username')"; |
$sql = "SELECT username FROM users WHERE (username = '$username')"; |
84 |
$sth = $dbh->prepare($sql); |
$sth = $dbh->prepare($sql); |
85 |
if (!$sth) error("Cannot prepare query: \"$sql\""); |
if (!$sth) error("Cannot prepare query: \"$sql\""); |
86 |
if (!$sth->execute()) error("Cannot execute query: \"$sql\""); |
if (!$sth->execute()) error("Cannot execute query: \"$sql\""); |
107 |
$drzava = $drzava ? my_quote($drzava) : "NULL"; |
$drzava = $drzava ? my_quote($drzava) : "NULL"; |
108 |
$sql = "INSERT INTO users (titula, ime, prezime, email, zanimanje, godrod, ustanova, adresa, mjesto, drzava, newsletter, promo, username, password) VALUES ($titula, $ime, $prezime, $email2, $zanimanje, $godrod, $ustanova, $adresa, $mjesto, $drzava, ".($newsletter?"true":"false").", ".($promo?"true":"false").", $username2, '".md5($password1)."')"; |
$sql = "INSERT INTO users (titula, ime, prezime, email, zanimanje, godrod, ustanova, adresa, mjesto, drzava, newsletter, promo, username, password) VALUES ($titula, $ime, $prezime, $email2, $zanimanje, $godrod, $ustanova, $adresa, $mjesto, $drzava, ".($newsletter?"true":"false").", ".($promo?"true":"false").", $username2, '".md5($password1)."')"; |
109 |
$dbh->dbh_do($sql); |
$dbh->dbh_do($sql); |
|
$sql = "SELECT currval('users_user_id_seq')::text"; |
|
|
$sth = $dbh->prepare($sql); |
|
|
if (!$sth) error("Cannot prepare query: \"$sql\""); |
|
|
if (!$sth->execute()) error("Cannot execute query: \"$sql\""); |
|
|
$row = $sth->fetchrow_array(); |
|
|
$sth->finish(); |
|
|
$row = array_shift($row); |
|
110 |
for ($i = 0; $i < count($specs); $i++) { |
for ($i = 0; $i < count($specs); $i++) { |
111 |
if ($specs[0]["checked"]) continue; |
if ($specs[0]["checked"]) continue; |
112 |
if (!$specs[$i]["checked"]) continue; |
if (!$specs[$i]["checked"]) continue; |
113 |
if ($specs[$i]["id"] == 0) continue; |
if ($specs[$i]["id"] == 0) continue; |
114 |
$sql = "INSERT INTO user_spec (user_id, spec_id) VALUES ($row, ".$specs[$i]["id"].")"; |
$sql = "INSERT INTO user_spec (username, spec_id) VALUES ('$username2', ".$specs[$i]["id"].")"; |
115 |
$dbh->dbh_do($sql); |
$dbh->dbh_do($sql); |
116 |
} |
} |
117 |
$mail = " |
$mail = " |