clockwerk-www – Diff between revs 67 and 68
?pathlinks?
Rev 67 | Rev 68 | |||
---|---|---|---|---|
Line 56... | Line 56... | |||
56 | } |
56 | } |
|
57 | } |
57 | } |
|
58 | try { |
58 | try { |
|
59 | $mysql = new PDO('mysql:host='.$MYSQL_HOSTNAME.';dbname='.$MYSQL_DATABASE.';', $MYSQL_USERNAME, $MYSQL_PASSWORD); |
59 | $mysql = new PDO('mysql:host='.$MYSQL_HOSTNAME.';dbname='.$MYSQL_DATABASE.';', $MYSQL_USERNAME, $MYSQL_PASSWORD); |
|
60 | $mysql->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); |
60 | $mysql->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); |
|
61 | $query = $mysql->prepare("SELECT RegionName FROM regions WHERE owner_uuid=(SELECT PrincipalID FROM UserAccounts WHERE FirstName=:first AND LastName=:last)"); |
61 | $query = $mysql->prepare("SELECT Name FROM land WHERE OwnerUUID=(SELECT PrincipalID FROM UserAccounts WHERE FirstName=:first AND LastName=:last)"); |
|
62 | $query->bindParam(':first', $first); |
62 | $query->bindParam(':first', $first); |
|
63 | $query->bindParam(':last', $last); |
63 | $query->bindParam(':last', $last); |
|
64 | $query->execute(); |
64 | $query->execute(); |
|
65 | } |
65 | } |
|
66 | catch(PDOException $e) { |
66 | catch(PDOException $e) { |