/**
* Create new user
* @access public
* @param user_group_id: user group ID (1 [admin] or 2 [user])
* login: login name
* pwd: password
* email: email
* first_name: first name
* last_name: last name
* @return user id, if successful
* false and add error into global var $msg, if unsuccessful
* @author Cindy Qi Li
*/
public function Create($user_group_id, $login, $pwd, $email, $first_name, $last_name, $is_author, $organization, $phone, $address, $city, $province, $country, $postal_code, $status)
{
global $addslashes;
/* email check */
$login = $addslashes(strtolower(trim($login)));
$email = $addslashes(trim($email));
$first_name = $addslashes(str_replace('<', '', trim($first_name)));
$last_name = $addslashes(str_replace('<', '', trim($last_name)));
$organization = $addslashes(trim($organization));
$phone = $addslashes(trim($phone));
$address = $addslashes(trim($address));
$city = $addslashes(trim($city));
$province = $addslashes(trim($province));
$country = $addslashes(trim($country));
$postal_code = $addslashes(trim($postal_code));
if ($this->isFieldsValid('new', $user_group_id, $login, $email, $first_name, $last_name, $is_author, $organization, $phone, $address, $city, $province, $country, $postal_code)) {
if ($status == "") {
if (defined('TR_EMAIL_CONFIRMATION') && TR_EMAIL_CONFIRMATION) {
$status = TR_STATUS_UNCONFIRMED;
} else {
$status = TR_STATUS_ENABLED;
}
}
/* insert into the db */
$sql = "INSERT INTO " . TABLE_PREFIX . "users\n\t\t\t (login,\n\t\t\t password,\n\t\t\t user_group_id,\n\t\t\t first_name,\n\t\t\t last_name,\n\t\t\t email,\n\t\t\t is_author,\n\t\t\t organization,\n\t\t\t phone,\n\t\t\t address,\n\t\t\t city,\n\t\t\t province,\n\t\t\t country,\n\t\t\t postal_code,\n\t\t\t web_service_id,\n\t\t\t status,\n\t\t\t create_date\n\t\t\t )\n\t\t\t VALUES ('" . $login . "',\n\t\t\t '" . $pwd . "',\n\t\t\t " . $user_group_id . ",\n\t\t\t '" . $first_name . "',\n\t\t\t '" . $last_name . "', \n\t\t\t '" . $email . "',\n\t\t\t " . $is_author . ",\n\t\t\t '" . $organization . "',\n\t\t\t '" . $phone . "',\n\t\t\t '" . $address . "',\n\t\t\t '" . $city . "',\n\t\t\t '" . $province . "',\n\t\t\t '" . $country . "',\n\t\t\t '" . $postal_code . "',\n\t\t\t '" . Utility::getRandomStr(32) . "',\n\t\t\t " . $status . ", \n\t\t\t now())";
if (!$this->execute($sql)) {
$msg->addError('DB_NOT_UPDATED');
return false;
} else {
return mysql_insert_id();
}
} else {
return false;
}
}
/**
* Create a new consumer record
* @access public
* @param consumer
* @return consumer id, if successful
* false and add error into global var $msg, if unsuccessful
* @author Cindy Qi Li
*/
public function Create($consumer, $expire_threshold)
{
global $addslashes, $msg;
$missing_fields = array();
/* email check */
$consumer = $addslashes(trim($consumer));
/* login name check */
if ($consumer == '') {
$missing_fields[] = _AT('consumer');
}
if ($missing_fields) {
$missing_fields = implode(', ', $missing_fields);
$msg->addError(array('EMPTY_FIELDS', $missing_fields));
}
if (!$msg->containsErrors()) {
/* insert into the db */
$consumer_key = Utility::getRandomStr(16);
$consumer_secret = Utility::getRandomStr(16);
$sql = "INSERT INTO " . TABLE_PREFIX . "oauth_server_consumers\n\t\t\t (consumer,\n\t\t\t consumer_key,\n\t\t\t consumer_secret,\n\t\t\t expire_threshold,\n\t\t\t create_date\n\t\t\t )\n\t\t\t VALUES ('" . $consumer . "',\n\t\t\t '" . $consumer_key . "',\n\t\t\t '" . $consumer_secret . "',\n\t\t\t " . $expire_threshold . ",\n\t\t\t now()\n\t\t\t )";
if (!$this->execute($sql)) {
$msg->addError('DB_NOT_UPDATED');
return false;
} else {
return mysql_insert_id();
}
} else {
return false;
}
}
if (isset($_GET['tile'])) {
header('Location: ' . $_base_path . 'tools/tile/index.php');
} else {
header('Location: ../index.php');
}
exit;
}
/* check if ../content/import/ exists */
$import_path = TR_TEMP_DIR . 'import/';
$content_path = TR_TEMP_DIR;
if (!is_dir($import_path)) {
if (!@mkdir($import_path, 0700)) {
$msg->addError('IMPORTDIR_FAILED');
}
}
$import_path .= Utility::getRandomStr(16) . '/';
if (is_dir($import_path)) {
clr_dir($import_path);
}
if (!@mkdir($import_path, 0700)) {
$msg->addError('IMPORTDIR_FAILED');
}
if ($msg->containsErrors()) {
if (isset($_GET['tile'])) {
header('Location: ' . $_base_path . 'tools/tile/index.php');
} else {
header('Location: ../index.php');
}
exit;
}
/* extract the entire archive into TR_COURSE_CONTENT . import/$course using the call back function to filter out php files */
function new_access_token($token, $consumer)
{
/*{{{*/
$access_token_key = Utility::getRandomStr(18);
$access_token_secret = Utility::getRandomStr(18);
$request_token_row = $this->oauthServerTokensDAO->getByTokenAndType($token, 'request');
$this->oauthServerTokensDAO->Create($request_token_row[0]['consumer_id'], $access_token_key, 'access', $access_token_secret, $request_token_row[0]['user_id']);
$this->oauthServerTokensDAO->deleteByTokenAndType($token, 'request');
$access_token = new OAuthToken($access_token_key, $access_token_secret);
return $access_token;
}
