clockwerk-www – Diff between revs 67 and 68

Subversion Repositories:
Rev:
Show entire file – Ignore whitespace
Rev 67 Rev 68
Line 57... Line 57...
57 switch((bool)$member->value->boolean) { 57 switch((bool)$member->value->boolean) {
58 case TRUE: 58 case TRUE:
59 try { 59 try {
60 $mysql = new PDO('mysql:host='.$MYSQL_HOSTNAME.';dbname='.$MYSQL_DATABASE.';', $MYSQL_USERNAME, $MYSQL_PASSWORD); 60 $mysql = new PDO('mysql:host='.$MYSQL_HOSTNAME.';dbname='.$MYSQL_DATABASE.';', $MYSQL_USERNAME, $MYSQL_PASSWORD);
61 $mysql->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 61 $mysql->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
62 $query = $mysql->prepare("SELECT RegionName FROM regions WHERE owner_uuid=(SELECT PrincipalID FROM UserAccounts WHERE FirstName=:first AND LastName=:last)"); 62 $query = $mysql->prepare("SELECT Name FROM land WHERE OwnerUUID=(SELECT PrincipalID FROM UserAccounts WHERE FirstName=:first AND LastName=:last)");
63 $query->bindParam(':first', $first); 63 $query->bindParam(':first', $first);
64 $query->bindParam(':last', $last); 64 $query->bindParam(':last', $last);
65 $query->execute(); 65 $query->execute();
66 } 66 }
67 catch(PDOException $e) { 67 catch(PDOException $e) {