public function afterStoreCallback()
{
if (!$this->material['host_id'] && $this->material['user_id'] !== $GLOBALS['user']->id) {
PersonalNotifications::add($this->material['user_id'], URLHelper::getURL("plugins.php/lernmarktplatz/market/details/" . $this->material->getId() . "#review_" . $this->getId()), $this->isNew() ? sprintf(_("%s hat ein Review zu '%s' geschrieben."), $this['host_id'] ? LernmarktplatzUser::find($this['user_id'])->name : get_fullname($this['user_id']), $this->material['name']) : sprintf(_("%s hat ein Review zu '%s' verändert."), $this['host_id'] ? LernmarktplatzUser::find($this['user_id'])->name : get_fullname($this['user_id']), $this->material['name']), "review_" . $this->getId(), Icon::create("support", "clickable"));
}
//only push if the comment is from this server and the material-server is different
if ($this->material['host_id'] && !$this['host_id'] && $this->isDirty()) {
$remote = new LernmarktplatzHost($this->material['host_id']);
$myHost = LernmarktplatzHost::thisOne();
$data = array();
$data['host'] = array('name' => $myHost['name'], 'url' => $myHost['url'], 'public_key' => $myHost['public_key']);
$data['data'] = $this->toArray();
$data['data']['foreign_review_id'] = $data['data']['review_id'];
unset($data['data']['review_id']);
unset($data['data']['id']);
unset($data['data']['user_id']);
unset($data['data']['host_id']);
$user_description_datafield = DataField::find(get_config("LERNMARKTPLATZ_USER_DESCRIPTION_DATAFIELD")) ?: DataField::findOneBySQL("name = ?", array(get_config("LERNMARKTPLATZ_USER_DESCRIPTION_DATAFIELD")));
if ($user_description_datafield) {
$datafield_entry = DatafieldEntryModel::findOneBySQL("range_id = ? AND datafield_id = ?", array($this['user_id'], $user_description_datafield->getId()));
}
$data['user'] = array('user_id' => $this['user_id'], 'name' => get_fullname($this['user_id']), 'avatar' => Avatar::getAvatar($this['user_id'])->getURL(Avatar::NORMAL), 'description' => $datafield_entry ? $datafield_entry['content'] : null);
if (!$remote->isMe()) {
$remote->pushDataToEndpoint("add_review/" . $this->material['foreign_material_id'], $data);
}
}
}
public function afterStoreCallback()
{
if ($this->isDirty()) {
//add notification to writer of review
if (!$this->review['host_id'] && $this->review['user_id'] !== $this['user_id']) {
PersonalNotifications::add($this->review['user_id'], URLHelper::getURL("plugins.php/lernmarktplatz/market/discussion/" . $this['review_id'] . "#comment_" . $this->getId()), sprintf(_("%s hat einen Kommentar zu Ihrem Review geschrieben."), $this['host_id'] ? LernmarktplatzUser::find($this['user_id'])->name : get_fullname($this['user_id'])), "comment_" . $this->getId(), Icon::create("support", "clickable"));
}
//add notification to all users of this servers who discussed this review but are neither the new
//commentor nor the writer of the review
$statement = DBManager::get()->prepare("\n SELECT user_id\n FROM lernmarktplatz_comments\n WHERE review_id = :review_id\n AND host_id IS NULL\n GROUP BY user_id\n ");
$statement->execute(array('review_id' => $this->review->getId()));
foreach ($statement->fetchAll(PDO::FETCH_COLUMN, 0) as $user_id) {
if (!in_array($user_id, array($this->review['user_id'], $this['user_id']))) {
PersonalNotifications::add($user_id, URLHelper::getURL("plugins.php/lernmarktplatz/market/discussion/" . $this['review_id'] . "#comment_" . $this->getId()), sprintf(_("%s hat auch einen Kommentar geschrieben."), $this['host_id'] ? LernmarktplatzUser::find($this['user_id'])->name : get_fullname($this['user_id'])), "comment_" . $this->getId(), Icon::create("support", "clickable"));
}
}
//only push if the comment is from this server and the material-server is different
if (!$this['host_id']) {
$myHost = LernmarktplatzHost::thisOne();
$data = array();
$data['host'] = array('name' => $myHost['name'], 'url' => $myHost['url'], 'public_key' => $myHost['public_key']);
$data['data'] = $this->toArray();
$data['data']['foreign_comment_id'] = $data['data']['comment_id'];
unset($data['data']['comment_id']);
unset($data['data']['id']);
unset($data['data']['user_id']);
unset($data['data']['host_id']);
$user_description_datafield = DataField::find(get_config("LERNMARKTPLATZ_USER_DESCRIPTION_DATAFIELD")) ?: DataField::findOneBySQL("name = ?", array(get_config("LERNMARKTPLATZ_USER_DESCRIPTION_DATAFIELD")));
if ($user_description_datafield) {
$datafield_entry = DatafieldEntryModel::findOneBySQL("range_id = ? AND datafield_id = ?", array($this['user_id'], $user_description_datafield->getId()));
}
$data['user'] = array('user_id' => $this['user_id'], 'name' => get_fullname($this['user_id']), 'avatar' => Avatar::getAvatar($this['user_id'])->getURL(Avatar::NORMAL), 'description' => $datafield_entry ? $datafield_entry['content'] : null);
$statement = DBManager::get()->prepare("\n SELECT host_id\n FROM lernmarktplatz_comments\n WHERE review_id = :review_id\n AND host_id IS NOT NULL\n GROUP BY host_id\n ");
$statement->execute(array('review_id' => $this->review->getId()));
$hosts = $statement->fetchAll(PDO::FETCH_COLUMN, 0);
if ($this->review['host_id'] && !in_array($this->review['host_id'], $hosts)) {
$hosts[] = $this->review['host_id'];
}
if ($this->review->material['host_id'] && !in_array($this->review->material['host_id'], $hosts)) {
$hosts[] = $this->review->material['host_id'];
}
foreach ($hosts as $host_id) {
$remote = new LernmarktplatzHost($host_id);
if (!$remote->isMe()) {
$review_id = $this->review['foreign_review_id'] ?: $this->review->getId();
if ($this->review['foreign_review_id']) {
if ($this->review->host_id === $remote->getId()) {
$host_hash = null;
} else {
$host_hash = md5($this->review->host['public_key']);
}
} else {
$host_hash = md5($myHost['public_key']);
}
$remote->pushDataToEndpoint("add_comment/" . $review_id . "/" . $host_hash, $data);
}
}
}
}
}
</tbody>
</table>
<h2><?php
echo _("Statistik");
?>
</h2>
<table class="default nohover">
<tr>
<td><?php
echo _("Anzahl verbundener Server");
?>
</td>
<td><?php
echo LernmarktplatzHost::countBySQL("1=1") - 1;
?>
</td>
</tr>
<tr>
<td><?php
echo _("Anzahl eigener Materialien");
?>
</td>
<td><?php
echo LernmarktplatzMaterial::countBySQL("host_id IS NULL");
?>
</td>
</tr>
<tr>
<td><?php
public function fetchData()
{
if ($this['host_id']) {
$host = new LernmarktplatzHost($this['host_id']);
if ($host) {
$data = $host->fetchItemData($this['foreign_material_id']);
if (!$data) {
return false;
}
if ($data['deleted']) {
return "deleted";
}
//user:
$user = LernmarktplatzUser::findOneBySQL("foreign_user_id", array($data['user']['user_id'], $host->getId()));
if (!$user) {
$user = new LernmarktplatzUser();
$user['foreign_user_id'] = $data['user']['user_id'];
$user['host_id'] = $host->getId();
}
$user['name'] = $data['user']['name'];
$user['avatar'] = $data['user']['avatar'] ?: null;
$user['description'] = $data['user']['description'] ?: null;
$user->store();
//material:
$material_data = $data['data'];
unset($material_data['material_id']);
unset($material_data['user_id']);
unset($material_data['mkdate']);
$this->setData($material_data);
$this->store();
//topics:
$this->setTopics($data['topics']);
foreach ((array) $data['reviews'] as $review_data) {
$currenthost = LernmarktplatzHost::findOneByUrl(trim($review_data['host']['url']));
if (!$currenthost) {
$currenthost = new LernmarktplatzHost();
$currenthost['url'] = trim($review_data['host']['url']);
$currenthost['last_updated'] = time();
$currenthost->fetchPublicKey();
if ($currenthost['public_key']) {
$currenthost->store();
}
}
if ($currenthost && $currenthost['public_key'] && !$currenthost->isMe()) {
$review = LernmarktplatzReview::findOneBySQL("foreign_review_id = ? AND host_id = ?", array($review_data['foreign_review_id'], $currenthost->getId()));
if (!$review) {
$review = new LernmarktplatzReview();
$review['foreign_review_id'] = $review_data['foreign_review_id'];
$review['material_id'] = $this->getId();
$review['host_id'] = $currenthost->getId();
}
$review['review'] = $review_data['review'];
$review['rating'] = $review_data['rating'];
if ($review_data['chdate']) {
$review['chdate'] = $review_data['chdate'];
}
if ($review_data['mkdate']) {
$review['mkdate'] = $review_data['mkdate'];
}
$user = LernmarktplatzUser::findOneBySQL("foreign_user_id", array($review_data['user']['user_id'], $currenthost->getId()));
if (!$user) {
$user = new LernmarktplatzUser();
$user['foreign_user_id'] = $review_data['user']['user_id'];
$user['host_id'] = $currenthost->getId();
}
$user['name'] = $review_data['user']['name'];
$user['avatar'] = $review_data['user']['avatar'] ?: null;
$user['description'] = $review_data['user']['description'] ?: null;
$user->store();
$review['user_id'] = $user->getId();
$review->store();
}
}
}
}
return true;
}
public function pushDataToEndpoint($endpoint, $data, $curl_multi_request = false)
{
$data = studip_utf8encode($data);
$payload = json_encode($data);
$myHost = LernmarktplatzHost::thisOne();
$endpoint_url = $this['url'] . $endpoint;
$request = curl_init();
curl_setopt($request, CURLOPT_URL, $endpoint_url);
curl_setopt($request, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($request, CURLOPT_VERBOSE, 0);
curl_setopt($request, CURLOPT_CONNECTTIMEOUT, 5);
curl_setopt($request, CURLOPT_POST, true);
curl_setopt($request, CURLOPT_POSTFIELDS, $payload);
curl_setopt($request, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($request, CURLOPT_SSL_VERIFYHOST, false);
$header = array($GLOBALS['LERNMARKTPLATZ_HEADER_SIGNATURE'] . ": " . base64_encode($myHost->createSignature($payload)), $GLOBALS['LERNMARKTPLATZ_HEADER_PUBLIC_KEY_HASH'] . ": " . md5($myHost['public_key']));
curl_setopt($request, CURLOPT_HTTPHEADER, $header);
if ($curl_multi_request) {
return $request;
} else {
$result = curl_exec($request);
$response_code = curl_getinfo($request, CURLINFO_HTTP_CODE);
curl_close($request);
return $response_code < 300;
}
}
/**
* Adds or edits a comment to the material on this server from a client of another server.
* Use this request only as a POST request, the body must be a JSON-object that carries all the
* necessary variables.
* The review_id is the foreign_review_id if the host_hash is not empty or the review_id if the host_hash is empty.
* @param $material_id : ID of the item on this server.
*/
public function add_comment_action($review_id, $host_hash = null)
{
if (Request::isPost()) {
$public_key_hash = $_SERVER['HTTP_' . str_replace("-", "_", strtoupper($GLOBALS['LERNMARKTPLATZ_HEADER_PUBLIC_KEY_HASH']))];
//MD5_HASH_OF_RSA_PUBLIC_KEY
$signature = base64_decode($_SERVER['HTTP_' . str_replace("-", "_", strtoupper($GLOBALS['LERNMARKTPLATZ_HEADER_SIGNATURE']))]);
//BASE64_RSA_SIGNATURE
$host = LernmarktplatzHost::findOneBySQL("MD5(public_key) = ?", array($public_key_hash));
if ($host && !$host->isMe()) {
$body = file_get_contents('php://input');
if ($host->verifySignature($body, $signature)) {
if ($host_hash) {
/*$review = LernmarktplatzReview::findOneBySQL("INNER JOIN lernmarktplatz_hosts ON (lernmarktplatz_hosts.host_id = lernmarktplatz_reviews.host_id) WHERE foreign_review_id = :id AND MD5(lernmarktplatz_hosts.public_key) = :host_hash", array(
'id' => $review_id,
'host_hash' => $host_hash
));*/
$review = LernmarktplatzReview::findOneByForeign_review_id($review_id);
} else {
$review = LernmarktplatzReview::find($review_id);
}
if (!$review) {
throw new Exception("Unknown material.");
}
$data = studip_utf8decode(json_decode($body, true));
$user = LernmarktplatzUser::findOneBySQL("host_id = ? AND foreign_user_id = ?", array($host->getId(), $data['user']['user_id']));
if (!$user) {
$user = new LernmarktplatzUser();
$user['host_id'] = $host->getId();
$user['foreign_user_id'] = $data['user']['user_id'];
}
$user['name'] = $data['user']['name'];
$user['avatar'] = $data['user']['avatar'];
$user['description'] = $data['user']['description'] ?: null;
$user->store();
$comment = new LernmarktplatzComment();
$comment['user_id'] = $user->getId();
$comment['foreign_comment_id'] = $data['data']['foreign_comment_id'];
$comment['host_id'] = $host->getId();
$comment['review_id'] = $review->getId();
$comment['comment'] = $data['data']['comment'];
$comment['mkdate'] = $data['data']['mkdate'];
$comment['chdate'] = $data['data']['chdate'];
$comment->store();
echo "stored ";
} else {
throw new Exception("Wrong signature, sorry.");
}
}
$this->render_text("");
} else {
throw new Exception("USE POST TO PUSH.");
}
}
public function toggle_index_server_action()
{
if (Request::isPost()) {
$host = new LernmarktplatzHost(Request::option("host_id"));
if ($host->isMe()) {
$host['index_server'] = Request::int("active", 0);
$host->store();
//distribute this info to adjacent server
$data = array('data' => array('public_key' => $host['public_key'], 'url' => $host['url'], 'name' => $host['name'], 'index_server' => $host['index_server']));
foreach (LernmarktplatzHost::findAll() as $remote) {
if (!$remote->isMe()) {
$remote->pushDataToEndpoint("update_server_info", $data);
}
}
/*$curl_multi_handle = curl_multi_init();
$requests = array();
foreach (LernmarktplatzHost::findAll() as $remote) {
if (!$remote->isMe()) {
$request = $remote->pushDataToEndpoint("update_server_info", $data, true);
curl_multi_add_handle($curl_multi_handle, $request);
$requests[] = $request;
}
}
$active = null;
do {
$mrc = curl_multi_exec($curl_multi_handle, $active);
} while ($mrc == CURLM_CALL_MULTI_PERFORM);
while ($active && $mrc == CURLM_OK) {
if (curl_multi_select($curl_multi_handle) != -1) {
do {
$mrc = curl_multi_exec($curl_multi_handle, $active);
} while ($mrc == CURLM_CALL_MULTI_PERFORM);
}
}
foreach ($requests as $request) {
curl_multi_remove_handle($curl_multi_handle, $request);
}
curl_multi_close($curl_multi_handle);
*/
} else {
$host['allowed_as_index_server'] = Request::int("active", 0);
$host->store();
}
}
$this->render_text(Icon::create("checkbox-" . (Request::int("active") ? "" : "un") . "checked"));
}
