/applyoar.php |
@@ -0,0 +1,66 @@ |
<?php |
|
/////////////////////////////////////////////////////////////////////////// |
// Copyright (C) Wizardry and Steamworks 2014 - License: MIT // |
/////////////////////////////////////////////////////////////////////////// |
|
// Hostname or IP of your OpenSim MySQL server. |
$MYSQL_HOSTNAME='localhost'; |
// Username of the OpenSim MySQL user. |
$MYSQL_USERNAME='opensim'; |
// Password of the OpenSim MySQL user. |
$MYSQL_PASSWORD='***'; |
// Name of the OpenSim database on the MySQL server. |
$MYSQL_DATABASE='opensim'; |
|
require_once 'lib/recaptchalib.php'; |
require_once 'lib/wasRemoteAdmin.php'; |
|
define('RECAPTCHA_PRIVATE_KEY', '6Lcz9ukSAAAAAC3u90rcOIdnNnaK_JgMjrOsSzZr'); |
|
$first = $_POST["first"]; |
$last = $_POST["last"]; |
$region = $_POST["region"]; |
$file = $_FILES["file"]["tmp_name"]; |
$password = $_POST["password"]; |
|
$resp = recaptcha_check_answer(RECAPTCHA_PRIVATE_KEY, |
$_SERVER["REMOTE_ADDR"], |
$_POST["recaptcha_challenge_field"], |
$_POST["recaptcha_response_field"]); |
|
if ($resp->is_valid) { |
$req = new wasRemoteAdmin('http://127.0.0.1:10000', 'opensim'); |
$ret = $req->admin_authenticate_user($first, $last, MD5($password), '1'); |
$rep = new SimpleXMLElement($ret); |
foreach($rep->params->param->value->struct->member as $member) { |
if ($member->name == "success" && $member->value->boolean == "0") { |
echo 'Sorry, wrong password.'; |
exit; |
} |
} |
try { |
$mysql = new PDO('mysql:host='.$MYSQL_HOSTNAME.';dbname='.$MYSQL_DATABASE.';', $MYSQL_USERNAME, $MYSQL_PASSWORD); |
$mysql->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); |
$query = $mysql->prepare("SELECT RegionName FROM regions WHERE owner_uuid=(SELECT PrincipalID FROM UserAccounts WHERE FirstName=:first AND LastName=:last)"); |
$query->bindParam(':first', $first); |
$query->bindParam(':last', $last); |
$query->execute(); |
} |
catch(PDOException $e) { |
print 'The given agent is not the owner of the region to download.'; |
return 1; |
} |
while ($result = $query->fetchObject()) { |
if ($result->RegionName == $region) { |
if (file_exists($file)) { |
$req->admin_console_command('change region '.$region); |
$req->admin_console_command('load oar '.$file); |
header('Location: welcome.php'); |
exit; |
} |
} |
} |
} |
|
echo '<p>Sorry, incorrect CAPTCHA. Please try again.</p>'; |