'', 'title' => 'Home', 'url' => 'Home', 'link_id' => 'id_wiki_home_0' ]; $sql_extra = item_permissions_sql($channel_id, $observer_hash); $r = q("select * from item where resource_type = 'nwikipage' and resource_id = '%s' and uid = %d and item_deleted = 0 $sql_extra order by title asc", dbesc($resource_id), intval($channel_id) ); if ($r) { $x = []; $y = []; foreach ($r as $rv) { if (!in_array($rv['mid'], $x)) { $y[] = $rv; $x[] = $rv['mid']; } } $items = fetch_post_tags($y, true); foreach ($items as $page_item) { $title = get_iconfig($page_item['id'], 'nwikipage', 'pagetitle', t('(No Title)')); if (urldecode($title) !== 'Home') { $pages[] = [ 'resource_id' => $resource_id, 'title' => escape_tags($title), //'url' => str_replace('%2F','/',urlencode(str_replace('%2F','/',urlencode($title)))), 'url' => NativeWiki::name_encode($title), 'link_id' => 'id_' . substr($resource_id, 0, 10) . '_' . $page_item['id'] ]; } } } return ['pages' => $pages, 'wiki' => $w]; } static public function create_page($channel, $observer_hash, $name, $resource_id, $mimetype = 'text/bbcode') { logger('mimetype: ' . $mimetype); if (!in_array($mimetype, ['text/markdown', 'text/bbcode', 'text/plain', 'text/html'])) $mimetype = 'text/markdown'; $w = NativeWiki::get_wiki($channel['channel_id'], $observer_hash, $resource_id); if (!$w['wiki']) { return ['content' => null, 'message' => 'Error reading wiki', 'success' => false]; } // backslashes won't work well in the javascript functions $name = str_replace('\\', '', $name); $uuid = new_uuid(); $mid = z_root() . '/item/' . $uuid; // create an empty activity $arr = []; $arr['aid'] = $channel['channel_account_id']; $arr['uid'] = $channel['channel_id']; $arr['mid'] = $mid; $arr['parent_mid'] = $w['wiki']['mid']; $arr['parent'] = $w['wiki']['parent']; $arr['uuid'] = $uuid; $arr['item_hidden'] = $w['wiki']['item_hidden']; $arr['plink'] = $mid; $arr['llink'] = z_root() . '/display/' . gen_link_id($mid); $arr['author_xchan'] = $observer_hash; $arr['mimetype'] = $mimetype; $arr['title'] = $name; $arr['resource_type'] = 'nwikipage'; $arr['resource_id'] = $resource_id; $arr['allow_cid'] = $w['wiki']['allow_cid']; $arr['allow_gid'] = $w['wiki']['allow_gid']; $arr['deny_cid'] = $w['wiki']['deny_cid']; $arr['deny_gid'] = $w['wiki']['deny_gid']; $arr['item_private'] = $w['wiki']['item_private']; $arr['item_wall'] = 1; $arr['item_origin'] = 1; $arr['item_thread_top'] = 1; $arr['verb'] = ACTIVITY_CREATE; $arr['obj_type'] = 'Document'; // TODO: add an object? $arr['public_policy'] = map_scope(PermissionLimits::Get($channel['channel_id'], 'view_wiki'), true); // We may wish to change this some day. $arr['item_unpublished'] = 1; set_iconfig($arr, 'nwikipage', 'pagetitle', (($name) ? $name : t('(No Title)')), true); $p = item_store($arr, false, false); if ($p['item_id']) { $page = [ 'rawName' => $name, 'htmlName' => escape_tags($name), //'urlName' => urlencode($name), 'urlName' => NativeWiki::name_encode($name) ]; return ['page' => $page, 'item_id' => $p['item_id'], 'item' => $p['activity'], 'wiki' => $w, 'message' => '', 'success' => true]; } return ['success' => false, 'message' => t('Wiki page create failed.')]; } static public function rename_page($arr) { $pageUrlName = ((array_key_exists('pageUrlName', $arr)) ? $arr['pageUrlName'] : ''); $pageNewName = ((array_key_exists('pageNewName', $arr)) ? $arr['pageNewName'] : ''); $resource_id = ((array_key_exists('resource_id', $arr)) ? $arr['resource_id'] : ''); $observer_hash = ((array_key_exists('observer_hash', $arr)) ? $arr['observer_hash'] : ''); $channel_id = ((array_key_exists('channel_id', $arr)) ? $arr['channel_id'] : 0); $w = NativeWiki::get_wiki($channel_id, $observer_hash, $resource_id); if (!$w['wiki']) { return ['message' => t('Wiki not found.'), 'success' => false]; } $ic = q("select * from iconfig left join item on iconfig.iid = item.id where uid = %d and cat = 'nwikipage' and k = 'pagetitle' and v = '%s'", intval($channel_id), dbesc($pageNewName) ); if ($ic) { return ['success' => false, 'message' => t('Destination name already exists')]; } $ids = []; $ic = q("select *, item.id as item_id from iconfig left join item on iconfig.iid = item.id where uid = %d and cat = 'nwikipage' and k = 'pagetitle' and v = '%s'", intval($channel_id), dbesc($pageUrlName) ); if ($ic) { foreach ($ic as $c) { set_iconfig($c['item_id'], 'nwikipage', 'pagetitle', $pageNewName); $ids[] = $c['item_id']; } $str_ids = implode(',', $ids); q("update item set title = '%s' where id in ($str_ids)", dbesc($pageNewName) ); $page = [ 'rawName' => $pageNewName, 'htmlName' => escape_tags($pageNewName), //'urlName' => urlencode(escape_tags($pageNewName)) 'urlName' => NativeWiki::name_encode($pageNewName) ]; return ['success' => true, 'page' => $page]; } return ['success' => false, 'message' => t('Page not found')]; } static public function get_page_content($arr) { $resource_id = ((array_key_exists('resource_id', $arr)) ? $arr['resource_id'] : ''); $observer_hash = ((array_key_exists('observer_hash', $arr)) ? $arr['observer_hash'] : ''); $channel_id = ((array_key_exists('channel_id', $arr)) ? intval($arr['channel_id']) : 0); $w = NativeWiki::get_wiki($channel_id, $observer_hash, $resource_id); if (!$w['wiki']) { return ['content' => null, 'message' => 'Error reading wiki', 'success' => false]; } $item = self::load_page($arr); if ($item) { $content = $item['body']; return [ 'content' => $content, 'mimeType' => $w['mimeType'], 'pageMimeType' => $item['mimetype'], 'message' => '', 'success' => true ]; } return ['content' => null, 'message' => t('Error reading page content'), 'success' => false]; } static public function page_history($arr) { $resource_id = ((array_key_exists('resource_id', $arr)) ? $arr['resource_id'] : ''); $observer_hash = ((array_key_exists('observer_hash', $arr)) ? $arr['observer_hash'] : ''); $channel_id = ((array_key_exists('channel_id', $arr)) ? $arr['channel_id'] : 0); $w = NativeWiki::get_wiki($channel_id, $observer_hash, $resource_id); if (!$w['wiki']) { return ['history' => null, 'message' => 'Error reading wiki', 'success' => false]; } $items = self::load_page_history($arr); $history = []; if ($items) { $processed = 0; foreach ($items as $item) { if ($processed > 1000) break; $processed++; $history[] = [ 'revision' => $item['revision'], 'date' => datetime_convert('UTC', date_default_timezone_get(), $item['edited']), 'name' => $item['author']['xchan_name'], 'title' => get_iconfig($item, 'nwikipage', 'commit_msg') ]; } return ['success' => true, 'history' => $history]; } return ['success' => false]; } static public function load_page($arr) { $pageUrlName = ((array_key_exists('pageUrlName', $arr)) ? $arr['pageUrlName'] : ''); $resource_id = ((array_key_exists('resource_id', $arr)) ? $arr['resource_id'] : ''); $observer_hash = ((array_key_exists('observer_hash', $arr)) ? $arr['observer_hash'] : ''); $channel_id = ((array_key_exists('channel_id', $arr)) ? $arr['channel_id'] : 0); $revision = ((array_key_exists('revision', $arr)) ? $arr['revision'] : (-1)); $w = NativeWiki::get_wiki($channel_id, $observer_hash, $resource_id); if (!$w['wiki']) { return ['content' => null, 'message' => 'Error reading wiki', 'success' => false]; } $ids = ''; $ic = q("select * from iconfig left join item on iconfig.iid = item.id where uid = %d and cat = 'nwikipage' and k = 'pagetitle' and v = '%s'", intval($channel_id), dbesc($pageUrlName) ); if ($ic) { foreach ($ic as $c) { if ($ids) $ids .= ','; $ids .= intval($c['iid']); } } $sql_extra = item_permissions_sql($channel_id, $observer_hash); if ($revision == (-1)) $sql_extra .= " order by revision desc "; elseif ($revision) $sql_extra .= " and revision = " . intval($revision) . " "; $r = null; if ($ids) { $r = q("select * from item where resource_type = 'nwikipage' and resource_id = '%s' and uid = %d and id in ( $ids ) $sql_extra limit 1", dbesc($resource_id), intval($channel_id) ); if ($r) { $items = fetch_post_tags($r, true); return $items[0]; } } return null; } static public function load_page_history($arr) { $pageUrlName = ((array_key_exists('pageUrlName', $arr)) ? $arr['pageUrlName'] : ''); $resource_id = ((array_key_exists('resource_id', $arr)) ? $arr['resource_id'] : ''); $observer_hash = ((array_key_exists('observer_hash', $arr)) ? $arr['observer_hash'] : ''); $channel_id = ((array_key_exists('channel_id', $arr)) ? $arr['channel_id'] : 0); $w = NativeWiki::get_wiki($channel_id, $observer_hash, $resource_id); if (!$w['wiki']) { return ['content' => null, 'message' => 'Error reading wiki', 'success' => false]; } $ids = ''; $ic = q("select * from iconfig left join item on iconfig.iid = item.id where uid = %d and cat = 'nwikipage' and k = 'pagetitle' and v = '%s'", intval($channel_id), dbesc($pageUrlName) ); if ($ic) { foreach ($ic as $c) { if ($ids) $ids .= ','; $ids .= intval($c['iid']); } } $sql_extra = item_permissions_sql($channel_id, $observer_hash); $sql_extra .= " order by revision desc "; $r = null; if ($ids) { $r = q("select * from item where resource_type = 'nwikipage' and resource_id = '%s' and uid = %d and id in ( $ids ) and item_deleted = 0 $sql_extra", dbesc($resource_id), intval($channel_id) ); if ($r) { xchan_query($r); $items = fetch_post_tags($r, true); return $items; } } return null; } static public function save_page($arr) { $pageUrlName = ((array_key_exists('pageUrlName', $arr)) ? $arr['pageUrlName'] : ''); $content = ((array_key_exists('content', $arr)) ? $arr['content'] : ''); $resource_id = ((array_key_exists('resource_id', $arr)) ? $arr['resource_id'] : ''); $observer_hash = ((array_key_exists('observer_hash', $arr)) ? $arr['observer_hash'] : ''); $channel_id = ((array_key_exists('channel_id', $arr)) ? $arr['channel_id'] : 0); $w = NativeWiki::get_wiki($channel_id, $observer_hash, $resource_id); if (!$w['wiki']) { return ['message' => t('Error reading wiki'), 'success' => false]; } // fetch the most recently saved revision. $item = self::load_page($arr); if (!$item) { return ['message' => t('Page not found'), 'success' => false]; } $mimetype = $item['mimetype']; // change just the fields we need to change to create a revision; unset($item['id']); unset($item['author']); $item['parent'] = 0; $item['body'] = $content; $item['author_xchan'] = $observer_hash; $item['revision'] = (($arr['revision']) ? intval($arr['revision']) + 1 : intval($item['revision']) + 1); $item['edited'] = datetime_convert(); $item['mimetype'] = $mimetype; if ($item['iconfig'] && is_array($item['iconfig']) && count($item['iconfig'])) { for ($x = 0; $x < count($item['iconfig']); $x++) { unset($item['iconfig'][$x]['id']); unset($item['iconfig'][$x]['iid']); } } $ret = item_store($item, false, false); if ($ret['item_id']) return ['message' => '', 'item_id' => $ret['item_id'], 'filename' => $pageUrlName, 'success' => true]; else return ['message' => t('Page update failed.'), 'success' => false]; } static public function delete_page($arr) { $pageUrlName = (array_key_exists('pageUrlName', $arr) ? $arr['pageUrlName'] : ''); $resource_id = (array_key_exists('resource_id', $arr) ? $arr['resource_id'] : ''); $observer_hash = (array_key_exists('observer_hash', $arr) ? $arr['observer_hash'] : ''); $channel_id = (array_key_exists('channel_id', $arr) ? $arr['channel_id'] : 0); $w = NativeWiki::get_wiki($channel_id, $observer_hash, $resource_id); if (!$w['wiki']) { return ['success' => false, 'message' => t('Error reading wiki')]; } $ids = []; $ic = q("select * from iconfig left join item on iconfig.iid = item.id where uid = %d and cat = 'nwikipage' and k = 'pagetitle' and v = '%s'", intval($channel_id), dbesc($pageUrlName) ); if ($ic) { foreach ($ic as $c) { $ids[] = intval($c['iid']); } } if ($ids) { drop_items($ids, true, DROPITEM_PHASE1); return ['success' => true]; } return ['success' => false, 'message' => t('Nothing deleted')]; } static public function revert_page($arr) { $resource_id = ((array_key_exists('resource_id', $arr)) ? $arr['resource_id'] : ''); $commitHash = ((array_key_exists('commitHash', $arr)) ? $arr['commitHash'] : null); $observer_hash = ((array_key_exists('observer_hash', $arr)) ? $arr['observer_hash'] : ''); $channel_id = ((array_key_exists('channel_id', $arr)) ? $arr['channel_id'] : 0); if (!$commitHash) { return ['message' => 'No commit was provided', 'success' => false]; } $w = NativeWiki::get_wiki($channel_id, $observer_hash, $resource_id); if (!$w['wiki']) { return ['message' => 'Error reading wiki', 'success' => false]; } $x = $arr; if (intval($commitHash) > 0) { unset($x['commitHash']); $x['revision'] = intval($commitHash) - 1; $loaded = self::load_page($x); if ($loaded) { $content = $loaded['body']; return ['content' => $content, 'success' => true]; } return ['success' => false]; } } static public function compare_page($arr) { $resource_id = ((array_key_exists('resource_id', $arr)) ? $arr['resource_id'] : ''); $compareCommit = ((array_key_exists('compareCommit', $arr)) ? $arr['compareCommit'] : 0); $observer_hash = ((array_key_exists('observer_hash', $arr)) ? $arr['observer_hash'] : ''); $channel_id = ((array_key_exists('channel_id', $arr)) ? $arr['channel_id'] : 0); $w = NativeWiki::get_wiki($channel_id, $observer_hash, $resource_id); if (!$w['wiki']) { return ['message' => t('Error reading wiki'), 'success' => false]; } $x = $arr; $x['revision'] = (-1); $currpage = self::load_page($x); if ($currpage) $currentContent = $currpage['body']; $x['revision'] = $compareCommit; $comppage = self::load_page($x); if ($comppage) $compareContent = $comppage['body']; if ($currpage && $comppage) { require_once('library/class.Diff.php'); $diff = \Diff::toTable(\Diff::compare($currentContent, $compareContent)); return ['success' => true, 'diff' => $diff]; } return ['success' => false, 'message' => t('Compare: object not found.')]; } static public function commit($arr) { $commit_msg = ((array_key_exists('commit_msg', $arr)) ? $arr['commit_msg'] : t('Page updated')); $observer_hash = ((array_key_exists('observer_hash', $arr)) ? $arr['observer_hash'] : ''); $channel_id = ((array_key_exists('channel_id', $arr)) ? $arr['channel_id'] : 0); if (array_key_exists('resource_id', $arr)) { $resource_id = $arr['resource_id']; } else { return ['message' => t('Wiki resource_id required for git commit'), 'success' => false]; } $w = NativeWiki::get_wiki($channel_id, $observer_hash, $resource_id); if (!$w['wiki']) { return ['message' => t('Error reading wiki'), 'success' => false]; } $page = self::load_page($arr); if ($page) { set_iconfig($page['id'], 'nwikipage', 'commit_msg', escape_tags($commit_msg), true); return ['success' => true, 'item_id' => $page['id'], 'page' => $page]; } return ['success' => false, 'message' => t('Page not found.')]; } static public function convert_links($s, $wikiURL) { if (strpos($s, '[[') !== false) { preg_match_all("/\[\[(.*?)\]\]/", $s, $match); $pages = $pageURLs = []; foreach ($match[1] as $m) { // TODO: Why do we need to double urlencode for this to work? //$pageURLs[] = urlencode(urlencode(escape_tags($m))); $titleUri = explode('|', $m); $page = $titleUri[0] ?? ''; $title = $titleUri[1] ?? $page; $pageURLs[] = NativeWiki::name_encode(escape_tags($page)); $pages[] = $title; } $idx = 0; while (strpos($s, '[[') !== false) { $replace = '' . $pages[$idx] . ''; $s = preg_replace("/\[\[(.*?)\]\]/", $replace, $s, 1); $idx++; } } return $s; } static public function render_page_history($arr) { $pageUrlName = ((array_key_exists('pageUrlName', $arr)) ? $arr['pageUrlName'] : ''); $resource_id = ((array_key_exists('resource_id', $arr)) ? $arr['resource_id'] : ''); $pageHistory = self::page_history([ 'channel_id' => App::$profile_uid, 'observer_hash' => get_observer_hash(), 'resource_id' => $resource_id, 'pageUrlName' => $pageUrlName ]); return replace_macros(get_markup_template('nwiki_page_history.tpl'), [ '$pageHistory' => $pageHistory['history'], '$permsWrite' => $arr['permsWrite'], '$name_lbl' => t('Name'), '$msg_label' => t('Message', 'wiki_history'), '$date_lbl' => t('Date'), '$revert_btn' => t('Revert'), '$compare_btn' => t('Compare') ]); } /** * Replace the instances of the string [toc] with a list element that will be populated by * a table of contents by the JavaScript library * @param string $s * @return string */ static public function generate_toc($s) { if (strpos($s, '[toc]') !== false) { //$toc_md = wiki_toc($s); // Generate Markdown-formatted list prior to HTML render $toc_md = '