<?php
/**
* SeekQuarry/Yioop --
* Open Source Pure PHP Search Engine, Crawler, and Indexer
*
* Copyright (C) 2009 - 2015 Chris Pollett chris@pollett.org
*
* LICENSE:
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*
* END LICENSE
*
* This script can be used to set up the database and filesystem for the
* seekquarry database system. The SeekQuarry system is deployed with a
* minimal sqlite database so this script is not strictly needed.
*
* @author Chris Pollett chris@pollett.org
* @package seek_quarry
* @subpackage configs
* @license http://www.gnu.org/licenses/ GPL3
* @link http://www.seekquarry.com/
* @copyright 2009 - 2015
* @filesource
*/
if(isset($_SERVER['DOCUMENT_ROOT']) && strlen($_SERVER['DOCUMENT_ROOT']) > 0) {
echo "BAD REQUEST";
exit();
}
/**
* Calculate base directory of script
* @ignore
*/
define("BASE_DIR", substr(
dirname(realpath($_SERVER['PHP_SELF'])), 0,
-strlen("/configs")));
require_once BASE_DIR.'/configs/config.php';
/* get the database library */
require_once BASE_DIR."/models/datasources/".DBMS."_manager.php";
/** Get base class for profile_model.php*/
require_once BASE_DIR."/models/model.php";
/** For ProfileModel::createDatabaseTables method*/
require_once BASE_DIR."/models/profile_model.php";
/** For GroupModel::setPageName method*/
require_once BASE_DIR."/models/group_model.php";
/** For crawlHash function */
require_once BASE_DIR."/lib/utility.php";
$profile_model = new ProfileModel(DB_NAME, false);
$db_class = ucfirst(DBMS)."Manager";
$dbinfo = array("DBMS" => DBMS, "DB_HOST" => DB_HOST, "DB_USER" => DB_USER,
"DB_PASSWORD" => DB_PASSWORD, "DB_NAME" => DB_NAME);
if(!in_array(DBMS, array('sqlite', 'sqlite3'))) {
$db = new $db_class();
$db->connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
/* postgres doesn't let you drop a database while connected to it so drop
tables instead first
*/
$profile_model->initializeSql($db, $dbinfo);
$database_tables = array_keys($profile_model->create_statements);
foreach($database_tables as $table) {
$db->execute("DROP TABLE ".$table);
}
$db->execute("DROP DATABASE IF EXISTS ".DB_NAME);
$db->execute("CREATE DATABASE ".DB_NAME);
$db->disconnect();
$db->connect(); // default connection goes to actual DB
} else {
@unlink(CRAWL_DIR."/data/".DB_NAME.".db");
$db = new $db_class();
$db->connect();
}
if(!$profile_model->createDatabaseTables($db, $dbinfo)) {
echo "\n\nCouldn't create database tables!!!\n\n";
exit();
}
$db->execute("INSERT INTO VERSION VALUES (".YIOOP_VERSION.")");
$creation_time = microTimestamp();
//numerical value of the blank password
$profile = $profile_model->getProfile(WORK_DIRECTORY);
$new_profile = $profile;
$new_profile['FIAT_SHAMIR_MODULUS'] = generateFiatShamirModulus();
$profile_model->updateProfile(WORK_DIRECTORY, $new_profile, $profile);
$sha1_of_blank_string = bchexdec(sha1(''));
//calculating V = S ^ 2 mod N
$temp = bcpow($sha1_of_blank_string . '', '2');
$zkp_password = bcmod($temp, $new_profile['FIAT_SHAMIR_MODULUS']);
//default account is root without a password
$sql ="INSERT INTO USERS VALUES (".ROOT_ID.", 'admin', 'admin','root',
'root@dev.null', '".crawlCrypt('')."', '".ACTIVE_STATUS.
"', '".crawlCrypt('root'.AUTH_KEY.$creation_time)."','$creation_time',
0, 0, '$zkp_password')";
$db->execute($sql);
/* public account is an inactive account for used for public permissions
default account is root without a password
*/
$sql ="INSERT INTO USERS VALUES (".PUBLIC_USER_ID.", 'all', 'all','public',
'public@dev.null', '".crawlCrypt('')."', '".INACTIVE_STATUS.
"', '".crawlCrypt('public' . AUTH_KEY . $creation_time)."',
'$creation_time', 0, 0, '$zkp_password')";
$db->execute($sql);
//default public group with group id 1
$creation_time = microTimestamp();
$sql = "INSERT INTO GROUPS VALUES(".PUBLIC_GROUP_ID.",'Public','".
$creation_time."','".ROOT_ID."', '".PUBLIC_JOIN."', '".GROUP_READ.
"', ".NON_VOTING_GROUP.", " . FOREVER . ")";
$db->execute($sql);
$now = time();
$db->execute("INSERT INTO ROLE VALUES (".ADMIN_ROLE.", 'Admin' )");
$db->execute("INSERT INTO ROLE VALUES (".USER_ROLE.", 'User' )");
$db->execute("INSERT INTO USER_ROLE VALUES (".ROOT_ID.", ".ADMIN_ROLE.")");
$db->execute("INSERT INTO USER_GROUP VALUES (".ROOT_ID.", ".
PUBLIC_GROUP_ID.", ".ACTIVE_STATUS.", $now)");
$db->execute("INSERT INTO USER_GROUP VALUES (".PUBLIC_USER_ID.", ".
PUBLIC_GROUP_ID.", ".ACTIVE_STATUS.", $now)");
//Create a Group for Wiki HELP.
$sql = "INSERT INTO GROUPS VALUES(" . HELP_GROUP_ID . ",'Help','" .
$creation_time . "','" . ROOT_ID . "',
'" . PUBLIC_BROWSE_REQUEST_JOIN . "', '" . GROUP_READ_WIKI .
"', " . UP_DOWN_VOTING_GROUP . ", " . FOREVER . ")";
$db->execute($sql);
$now = time();
$db->execute("INSERT INTO USER_GROUP VALUES (" . ROOT_ID . ", " .
HELP_GROUP_ID . ", " . ACTIVE_STATUS . ", $now)");
$db->execute("INSERT INTO USER_GROUP VALUES (" . PUBLIC_USER_ID . ", " .
HELP_GROUP_ID . ", " . ACTIVE_STATUS . ", $now)");
$public_pages = array();
$public_pages["404"] = <<<EOD
title=Page Not Found
description=The page you requested cannot be found on our server
END_HEAD_VARS
==The page you requested cannot be found.==
EOD;
$public_pages["409"] = <<<EOD
title=Conflict
description=Your request would result in an edit conflict.
END_HEAD_VARS
==Your request would result in an edit conflict, so will not be processed.==
EOD;
$public_pages["captcha_time_out"] = <<<EOD
title=Captcha/Recover Time Out
END_HEAD_VARS
==Account Timeout==
A large number of captcha refreshes or recover password requests
have been made from this IP address. Please wait until
%s to try again.
EOD;
$public_pages["bot"] = <<<EOD
title=Bot
description=Describes the web crawler used with this
web site
END_HEAD_VARS
==My Web Crawler==
Please Describe Your Robot
EOD;
$public_pages["privacy"] = <<<EOD
title=Privacy Policy
description=Describes what information this site collects and retains about
users and how it uses that information
END_HEAD_VARS
==We are concerned with your privacy==
EOD;
$public_pages["register_time_out"] = <<<EOD
title=Create/Recover Account
END_HEAD_VARS
==Account Timeout==
A number of incorrect captcha responses or recover password requests
have been made from this IP address. Please wait until
%s to access this site.
EOD;
$public_pages["suggest_day_exceeded"] = <<<EOD
EOD;
$public_pages["terms"] = <<<EOD
=Terms of Service=
Please write the terms for the services provided by this website.
EOD;
$public_pages["Syntax"] = <<<EOD
=Yioop Wiki Syntax=
Wiki syntax is a lightweight way to markup a text document so that
it can be formatted and drawn nicely by Yioop.
This page briefly describes the wiki syntax supported by Yioop.
==Headings==
In wiki syntax headings of documents and sections are written as follows:
<nowiki>
=Level1=
==Level2==
===Level3===
====Level4====
=====Level5=====
======Level6======
</nowiki>
and would look like:
=Level1=
==Level2==
===Level3===
====Level4====
=====Level5=====
======Level6======
==Paragraphs==
In Yioop two new lines indicates a new paragraph. You can control
the indent of a paragraph by putting colons followed by a space in front of it:
<nowiki>
: some indent
:: a little more
::: even more
:::: that's sorta crazy
</nowiki>
which looks like:
: some indent
:: a little more
::: even more
:::: that's sorta crazy
==Horizontal Rule==
Sometimes it is convenient to separate paragraphs or sections with a horizontal
rule. This can be done by placing four hyphens on a line by themselves:
<nowiki>
----
</nowiki>
This results in a line that looks like:
----
==Text Formatting Within Paragraphs==
Within a paragraph it is often convenient to make some text bold, italics,
underlined, etc. Below is a quick summary of how to do this:
===Wiki Markup===
{|
|<nowiki>''italic''</nowiki>|''italic''
|-
|<nowiki>'''bold'''</nowiki>|'''bold'''
|-
|<nowiki>'''''bold and italic'''''</nowiki>|'''''bold and italic'''''
|}
===HTML Tags===
Yioop also supports several html tags such as:
{|
|<nowiki><del>delete</del></nowiki>|<del>delete</del>
|-
|<nowiki><ins>insert</ins></nowiki>|<ins>insert</ins>
|-
|<nowiki><s>strike through</s> or
<strike>strike through</strike> </nowiki>|<s>strike through</s>
|-
|<nowiki><sup>superscript</sup> and
<sub>subscript</sub></nowiki>|<sup>superscript</sup> and
<sub>subscript</sub>
|-
|<nowiki><tt>typewriter</tt></nowiki>|<tt>typewriter</tt>
|-
|<nowiki><u>underline</u></nowiki>|<u>underline</u>
|}
===Spacing within Paragraphs===
The HTML entity
<nowiki> </nowiki>
can be used to create a non-breaking space. The tag
<nowiki><br></nowiki>
can be used to produce a line break.
==Preformatted Text and Unformatted Text==
You can force text to be formatted as you typed it rather
than using the layout mechanism of the browser using the
<nowiki><pre>preformatted text tag.</pre></nowiki>
Alternatively, a sequence of lines all beginning with a
space character will also be treated as preformatted.
Wiki markup within pre tags is still parsed by Yioop.
If you would like to add text that is not parsed, enclosed
it in `<`nowiki> `<`/nowiki> tags.
==Styling Text Paragraphs==
Yioop wiki syntax offers a number of templates for
control the styles, and alignment of text for
a paragraph or group of paragraphs:<br />
`{{`left| some text`}}`,<br /> `{{`right| some text`}}`,<br />
and<br />
`{{`center| some text`}}`<br /> can be used to left-justify,
right-justify, and center a block of text. For example,
the last command, would produce:
{{center|
some text
}}
If you know cascading style sheets (CSS), you can set
a class or id selector for a block of text using:<br />
`{{`class="my-class-selector" some text`}}`<br />and<br />
`{{`id="my-id-selector" some text`}}`.<br />
You can also apply inline styles to a block of text
using the syntax:<br />
`{{`style="inline styles" some text`}}`.<br />
For example, `{{`style="color:red" some text`}}` looks
like {{style="color:red" some text}}.
==Lists==
The Yioop Wiki Syntax supported of ways of listing items:
bulleted/unordered list, numbered/ordered lists, and
definition lists. Below are some examples:
===Unordered Lists===
<nowiki>
* Item1
** SubItem1
** SubItem2
*** SubSubItem1
* Item 2
* Item 3
</nowiki>
would be drawn as:
* Item1
** SubItem1
** SubItem2
*** SubSubItem1
* Item 2
* Item 3
===Ordered Lists===
<nowiki>
# Item1
## SubItem1
## SubItem2
### SubSubItem1
# Item 2
# Item 3
</nowiki>
# Item1
## SubItem1
## SubItem2
### SubSubItem1
# Item 2
# Item 3
===Mixed Lists===
<nowiki>
# Item1
#* SubItem1
#* SubItem2
#*# SubSubItem1
# Item 2
# Item 3
</nowiki>
# Item1
#* SubItem1
#* SubItem2
#*# SubSubItem1
# Item 2
# Item 3
===Definition Lists===
<nowiki>
;Term 1: Definition of Term 1
;Term 2: Definition of Term 2
</nowiki>
;Term 1: Definition of Term 1
;Term 2: Definition of Term 2
==Tables==
A table begins with {`|` and ends with `|`}. Cells are separated with | and
rows are separated with |- as can be seen in the following
example:
<nowiki>
{|
|a||b
|-
|c||d
|}
</nowiki>
{|
|a||b
|-
|c||d
|}
Headings for columns and rows can be made by using an exclamation point, !,
rather than a vertical bar |. For example,
<nowiki>
{|
!a!!b
|-
|c|d
|}
</nowiki>
{|
!a!!b
|-
|c|d
|}
Captions can be added using the + symbol:
<nowiki>
{|
|+ My Caption
!a!!b
|-
|c|d
|}
</nowiki>
{|
|+ My Caption
!a!!b
|-
|c|d
|}
Finally, you can put a CSS class or style attributes (or both) on the first line
of the table to further control how it looks:
<nowiki>
{| class="wikitable"
|+ My Caption
!a!!b
|-
|c|d
|}
</nowiki>
{| class="wikitable"
|+ My Caption
!a!!b
|-
|c|d
|}
Within a cell attributes like align, valign, styles, and class can be used. For
example,
<nowiki>
{|
| style="text-align:right;"| a| b
|-
| lalala | lalala
|}
</nowiki>
{|
| style="text-align:right;"| a| b
|-
| lalala | lalala
|}
==Math==
Math can be included into a wiki document by either using the math tag:
<nowiki>
<math>
\sum_{i=1}^{n} i = frac{(n+1)(n)}{2}
</math>
</nowiki>
<math>
\sum_{i=1}^{n} i = frac{(n+1)(n)}{2}
</math>
==Adding Resources to a Page==
Yioop wiki syntax supports adding search bars, audio, images, and video to a
page. The magnifying class edit tool icon can be used to add a search bar via
the GUI. This can also be added by hand with the syntax:
<nowiki>
{{search:default|size:small|placeholder:Search Placeholder Text}}
</nowiki>
This syntax is split into three parts each separated by a vertical bar |. The
first part search:default means results from searches should come from the
default search index. You can replace default with the timestamp of a specific
index or mix if you do not want to use the default. The second group size:small
indicates the size of the search bar to be drawn. Choices of size are small,
medium, and large. Finally, placeholder:Search Placeholder Text indicates the
grayed out background text in the search input before typing is done should
read: Search Placeholder Text. Here is what the above code outputs:
{{search:default|size:small|placeholder:Search Placeholder Text}}
In a given pages edit mode at the bottom of the page there is a form that allows
one to upload resources such as audio, images, or video for that page. After
uploading an item it will appear underneath this form with a link to preview
what the item looks like followed by a button to add the resource to the page,
followed by a link [X] to delete the item. Clinking on the add button will
insert into the wiki page a line like:
<pre>
( (resource:myphoto.jpg|Resource Description))
</pre>
Here myphoto.jpg is the resource that will be inserted and Resource Description
is the alternative text to use in case the viewing browser can't display jpg
files.
==Page Settings, Page Type==
In edit mode for a wiki page, next to the page name, is a link [Settings].
Clicking this link expands a form which can be used to control global settings
for a wiki page. This form contains a drop down for the page type and then text
fields or areas for the page title, author, meta robots, and page description.
Page title is displayed in the browser title base when the wiki page is accessed
with the Activity Panel collapsed or when not logged. Similar, in this mode,
if one looks as the HTML page source for the page, in the head of document,
<meta> tags for author, robots, and description are set according to these
fields. The robots meta tag. Wikipedia has more information on
[[https://en.wikipedia.org/wiki/Meta_element|Meta Elements]].
The default page
type is Standard which means treat the page as a usual wiki page.
The type Media List means that the page when read should just display the
resources in the page and the links for the resources go to a separate page
used to display this resource. This kind of page is useful for a gallery of
images or a collection of audio or video files. Presentation
mode is for a wiki page whose purpose is a slide presentation. In this mode,
....
on a line by itself is used to separate one slide. When the Activity panel is
not collapse and you are reading a presentation, it just displays as a single
page with all slides visible. Collapsing the Activity panel presents the slides
as a typical slide presentation using the
[[www.w3.org/Talks/Tools/Slidy2/Overview.html|Slidy]] javascript.
EOD;
$group_model = new GroupModel(DB_NAME, false);
$group_model->db = $db;
foreach($public_pages as $page_name => $page_content) {
$page_content = str_replace("&", "&", $page_content);
$page_content = @htmlentities($page_content, ENT_QUOTES, "UTF-8");
$group_model->setPageName(ROOT_ID, PUBLIC_USER_ID, $page_name,
$page_content, "en-US", "Creating Default Pages",
"$page_name Wiki Page Created!", "Discuss the page in this thread!");
}
$help_pages = array();
$docUrl = "https://www.seekquarry.com/?c=static&p=Documentation";
$help_pages["Add_Locale"] = <<<EOD
page_type=standard
page_border=solid-border
toc=true
title=Add Locale
description=Help article describing how to add a Locale.
END_HEAD_VARS==Adding a Locale==
The Manage Locales activity can be used to configure Yioop for use with
different languages and for different regions.
* The first form on this activity allows you to create a new "Locale"
-- an object representing a language and a region.
* The first field on this form should be filled in with a name for the locale in
the language of the locale.
* So for French you would put :Français. The locale tag should be the
IETF language tag.
EOD;
$help_pages["Database_Setup"] = <<<EOD
page_type=standard
page_border=solid-border
title=Database Setup
END_HEAD_VARSThe database is used to store information about what users are
allowed to use the admin panel and what activities and roles these users have.
* The Database Set-up field-set is used to specify what database management
system should be used, how it should be connected to, and what user name and
password should be used for the connection.
* Supported Databases
** PDO (PHP's generic DBMS interface).
** Sqlite3 Database.
** Mysql Database.
* Unlike many database systems, if an sqlite3 database is being used then the
connection is always a file on the current filesystem and there is no notion of
login and password, so in this case only the name of the database is asked for.
For sqlite, the database is stored in WORK_DIRECTORY/data.
* For single user settings with a limited number of news feeds, sqlite is
probably the most convenient database system to use with Yioop. If you think you
are going to make use of Yioop's social functionality and have many users,
feeds, and crawl mixes, using a system like Mysql or Postgres might be more
appropriate.
EOD;
$help_pages["Locale_Writing_Mode"] = <<<EOD
page_type=standard
page_border=solid-border
title=Locale Writing Mode
END_HEAD_VARSThe last field on the form is to specify how the language is
written. There are four options:
# lr-tb -- from left-to-write from the top of the page to the bottom as in
English.
# rl-tb from right-to-left from the top the page to the bottom as in Hebrew
and Arabic.
# tb-rl from the top of the page to the bottom from right-to-left as in
Classical Chinese.
# tb-lr from the top of the page to the bottom from left-to-right as in
non-cyrillic Mongolian or American Sign Language.
''lr-tb and rl-tb support work better than the vertical language support. As of
this writing, Internet Explorer and WebKit based browsers (Chrome/Safari) have
some vertical language support and the Yioop stylesheets for vertical languages
still need some tweaking. For information on the status in Firefox check out
this writing mode bug.''
EOD;
$help_pages["Locale_List"] = <<<EOD
page_type=standard
page_border=solid-border
title=Locale List
END_HEAD_VARSBeneath the Add Locale form is a table listing some of the current
locales.
* The Show Dropdown let's you control how many of these locales are displayed in
one go.
* The Search link lets you bring up an advance search form to search for
particular locales and also allows you to control the direction of the listing.
The Locale List table
* The first column in the table has a link with the name of the locale.
Clicking on this link brings up a page where one can edit the strings for that
locale.
* The next two columns of the Locale List table give the locale tag and writing
direction of the locale, this is followed by the percent of strings translated.
Clicking the Edit link in the column let&#039;s you edit the locale tag, and
text direction of a locale.
* Finally, clicking the Delete link let&#039;s one delete a locale and all
its strings.
EOD;
$docLink = "#Managing%20Users,%20Roles,%20and%20Groups";
$help_pages["Browse_Groups"] = <<<EOD
page_type=standard
page_border=solid-border
toc=true
title=Browse Groups
END_HEAD_VARS==Creating or Joining a group==
You can create or Join a Group all in one place using this Text field.
Simply enter the Group Name You want to create or Join. If the Group Name
already exists, you will simply join the group. If the group name doesn't
exist, you will be presented with more options to customize and create your
new Group.
==Browse Existing Groups==
You can use the [Browse] hyper link to browse the existing Groups.
You will then be presented with a web form to narrow your search followed by
a list of all visible groups to you beneath.
{{right|[[$docUrl$docLink| Learn More..]]}}
EOD;
$docLink = "#GUI%20for%20Managing%20Machines%20and%20Servers";
$help_pages["Machine_Information"] = <<<EOD
page_type=standard
page_border=solid-border
toc=true
title=Machine Information
END_HEAD_VARS'''Machine Information listings:'''
<br />
This shows the currently known about machines. This list always begins with
the '''Name Server''' itself and a toggle to control whether or not the
News Updater process is running on the Name Server. This allows you to
control whether or not Yioop attempts to update its RSS (or Atom) search
sources on an hourly basis.
<br />There is also a link to the log file of the News Updater process.
Under the Name Server information is a dropdown that can be used to control
the number of current machine statuses that are displayed for all other
machines that have been added. It also might have next and previous arrow
links to go through the currently available machines.
<br />
{{right|[[$docUrl$docLink| Learn More.]]}}
EOD;
$docLink = "#GUI%20for%20Managing%20Machines%20and%20Servers";
$help_pages["Manage_Machines"] = <<<EOD
page_type=standard
page_border=solid-border
toc=true
title=Manage Machines
END_HEAD_VARS'''Add Machine:'''
<br /><br />
The Add machine form allows you to add a new machine to be controlled by this
Yioop instance. The '''Machine Name''' field lets you give this machine an easy
to remember name. The Machine URL field should be filled in with the URL to the
installed Yioop instance.
<br />
The '''Mirror''' check-box says whether you want the given Yioop installation
to act as a mirror for another Yioop installation. Checking it will reveal a
drop-down menu that allows you to choose which installation among-st the
previously entered machines you want to mirror. The '''Has Queue Server'''
check-box is used to say whether the given Yioop installation will be running a
queue server or not.
<br />
Finally, the '''Number of Fetchers''' drop down allows you to say how many
fetcher instances you want to be able to manage for that machine.
{{right|[[$docUrl$docLink|Learn More..]]}}
EOD;
$help_pages["Discover_Groups"] = <<<EOD
page_type=standard
page_border=solid-border
toc=true
title=Discover Groups
END_HEAD_VARS'''Name''' Field is used to specify the name of the Group to
search for.
'''Owner''' Field lets you search a Group using it's Owner name.
<br />
'''Register''' dropdown says how other users are allowed to join the group:
* <u>No One</u> means no other user can join the group (you can still invite
other users).
* <u>By Request</u> means that other users can request the group owner to join
the group.
* <u>Anyone</u> means all users are allowed to join the group.
<br />
''It should be noted that the root account can always join any group.
The root account can also always take over ownership of any group.''
<br />
The '''Access''' dropdown controls how users who belong/subscribe to a group
other than the owner can access that group.
* <u>No Read</u> means that a non-owner member of the group cannot read or
write the group news feed and cannot read the group wiki.
* <u>Read</u> means that a non-owner member of the group can read the group
news feed and the groups wiki page.
* <u>Read</u> Comment means that a non-owner member of the group can read the
group feed and wikis and can comment on any existing threads, but cannot start
new ones.
* <u>Read Write</u>, means that a non-owner member of the group can start new
threads and comment on existing ones in the group feed and can edit and create
wiki pages for the group's wiki.
<br />
The access to a group can be changed by the owner after a group is created.
* <u>No Read</u> and <u>Read</u> are often suitable if a group's owner wants to
perform some kind of moderation.
* <u>Read</u> and <u>Read Comment</u> groups are often suitable if someone wants
to use a Yioop Group as a blog.
* <u>Read</u> Write makes sense for a more traditional bulletin board.
EOD;
$help_pages["Create_Group"] = <<<EOD
page_type=standard
page_border=solid-border
title=Create Group
END_HEAD_VARS''You will get to this form when the Group Name is available to
create a new Group. ''
----
'''Name''' Field is used to specify the name of the new Group.
<br />
'''Register''' dropdown says how other users are allowed to join the group:
* <u>No One</u> means no other user can join the group (you can still invite
other users).
* <u>By Request</u> means that other users can request the group owner to join
the group.
* <u>Anyone</u> means all users are allowed to join the group.
<br />
The '''Access''' dropdown controls how users who belong/subscribe to a group
other than the owner can access that group.
* <u>No Read</u> means that a non-owner member of the group cannot read or
write the group news feed and cannot read the group wiki.
* <u>Read</u> means that a non-owner member of the group can read the group
news feed and the groups wiki page.
* <u>Read</u> Comment means that a non-owner member of the group can read the
group feed and wikis and can comment on any existing threads, but cannot start
new ones.
* <u>Read Write</u>, means that a non-owner member of the group can start new
threads and comment on existing ones in the group feed and can edit and create
wiki pages for the group's wiki.
'''Voting'''
* Specify the kind of voting allowed in the new group. + Voting allows users to
vote up, -- Voting allows users to vote down. +/- allows Voting up and down.
'''Post Life time''' - Specifies How long the posts should be kept.
EOD;
$help_pages["Captcha_Type"] = <<<EOD
page_type=standard
page_border=solid-border
title=Captcha Type
END_HEAD_VARSThe Captcha Type field set controls what kind of
[[https://en.wikipedia.org/wiki/CAPTCHA|captcha]] will be used during account
registration, password recovery, and if a user wants to suggest a url.
* The choices for captcha are:
** '''Text Captcha''', the user has to select from a series of dropdown answers
to questions of the form: ''Which in the following list is the most/largest/etc?
or Which is the following list is the least/smallest/etc?; ''
** '''Graphic Captcha''', the user needs to enter a sequence of characters from
a distorted image;
** '''Hash captcha''', the user's browser (the user doesn't need to do anything)
needs to extend a random string with additional characters to get a string
whose hash begins with a certain lead set of characters.
- Of these, Hash Captcha is probably the least intrusive but requires
Javascript and might run slowly on older browsers. A text captcha might be used
to test domain expertise of the people who are registering for an account.
Finally, the graphic captcha is probably the one people are most familiar with.
EOD;
$help_pages["Authentication_Type"] = <<<EOD
page_type=standard
page_border=solid-border
title=Authentication Type
END_HEAD_VARSThe Authentication Type field-set is used to control the protocol
used to log people into Yioop.
* Below is a list of Authentication types supported.
** '''Normal Authentication''', passwords are checked against stored as
salted hashes of the password; or
** '''ZKP (zero knowledge protocol) authentication''', the server picks
challenges at random and send these to the browser the person is logging in
from, the browser computes based on the password an appropriate response
according to the Fiat Shamir protocol.cThe password is never sent over the
internet and is not stored on the server. These are the main advantages of
ZKP, its drawback is that it is slower than Normal Authentication as to prove
who you are with a low probability of error requires several browser-server
exchanges.
* You should choose which authentication scheme you want before you create many
users as if you switch everyone will need to get a new password.
EOD;
$help_pages["Account_Registration"] = <<<EOD
page_type=standard
page_border=solid-border
title=Account Registration
END_HEAD_VARSThe Account Registration field-set is used to control how user's
can obtain accounts on a Yioop installation.
* The dropdown at the start of this fieldset allows you to select one of four
possibilities:
** '''Disable Registration''', users cannot register themselves, only the root
account can add users.
*** When Disable Registration is selected, the Suggest A Url form and link on
the tool.php page is disabled as well, for all other registration type this
link is enabled.
** '''No Activation''', user accounts are immediately activated once a user
signs up.
** '''Email Activation''', after registering, users must click on a link which
comes in a separate email to activate their accounts.
*** If Email Activation is chosen, then the reset of this field-set can be used
to specify the email address that the email comes to the user. The checkbox Use
PHP mail() function controls whether to use the mail function in PHP to send
the mail, this only works if mail can be sent from the local machine.
Alternatively, if this is not checked like in the image above, one can
configure an outgoing SMTP server to send the email through.
** '''Admin Activation''', after registering, an admin account must activate
the user before the user is allowed to use their account.
EOD;
$help_pages["Ad_Server"] = <<<EOD
page_type=standard
page_border=solid-border
title=Ad Server
END_HEAD_VARS* The Ad Server field-set is used to control whether, where,
and what external advertisements should be displayed by this Yioop instance.
EOD;
$help_pages["Proxy_Server"] = <<<EOD
page_type=standard
page_border=solid-border
title=Proxy server
END_HEAD_VARS* Yioop can make use of a proxy server to do web crawling.
EOD;
//Insert Help pages
foreach($help_pages as $page_name => $page_content) {
$page_content = str_replace("&", "&", $page_content);
$page_content = @htmlentities($page_content, ENT_QUOTES, "UTF-8");
$group_model->setPageName(ROOT_ID, HELP_GROUP_ID, $page_name,
$page_content, "en-US", "Creating Default Pages",
"$page_name Help Page Created!", "Discuss the page in this thread!");
}
/* End Help content insertion. */
/* we insert 1 by 1 rather than comma separate as sqlite
does not support comma separated inserts
*/
$locales = array(
array('en-US', 'English', 'lr-tb'),
array('ar', 'العربية', 'rl-tb'),
array('de', 'Deutsch', 'lr-tb'),
array('es', 'Español', 'lr-tb'),
array('fr-FR', 'Français', 'lr-tb'),
array('he', 'עברית', 'rl-tb'),
array('in-ID', 'Bahasa', 'lr-tb'),
array('it', 'Italiano', 'lr-tb'),
array('ja', '日本語', 'lr-tb'),
array('ko', '한국어', 'lr-tb'),
array('pl', 'Polski', 'lr-tb'),
array('pt', 'Português', 'lr-tb'),
array('ru', 'Русский', 'lr-tb'),
array('th', 'ไทย', 'lr-tb'),
array('vi-VN', 'Tiếng Việt', 'lr-tb'),
array('zh-CN', '中文', 'lr-tb'),
array('kn', 'ಕನ್ನಡ', 'lr-tb'),
array('hi', 'हिन्दी', 'lr-tb'),
array('tr', 'Türkçe', 'lr-tb'),
array('fa', 'فارسی', 'rl-tb'),
array('te', 'తెలుగు', 'lr-tb'),
);
$i = 1;
foreach($locales as $locale) {
$db->execute("INSERT INTO LOCALE VALUES ($i, '{$locale[0]}',
'{$locale[1]}', '{$locale[2]}', '1')");
$locale_index[$locale[0]] = $i;
$i++;
}
$activities = array(
"manageAccount" => array('db_activity_manage_account',
array(
"en-US" => 'Manage Account',
"fa" => 'مدیریت حساب',
"fr-FR" => 'Modifier votre compte',
"ja" => 'アカウント管理',
"ko" => '사용자 계정 관리',
"vi-VN" => 'Quản lý tài khoản',
"zh-CN" => '管理帳號',
)),
"manageUsers" => array('db_activity_manage_users',
array(
"en-US" => 'Manage Users',
"fa" => 'مدیریت کاربران',
"fr-FR" => 'Modifier les utilisateurs',
"ja" => 'ユーザー管理',
"ko" => '사용자 관리',
"vi-VN" => 'Quản lý tên sử dụng',
"zh-CN" => '管理使用者',
)),
"manageRoles" => array('db_activity_manage_roles',
array(
"en-US" => 'Manage Roles',
"fa" => 'مدیریت نقشها',
"fr-FR" => 'Modifier les rôles',
"ja" => '役割管理',
"ko" => '사용자 권한 관리',
"vi-VN" => 'Quản lý chức vụ',
)),
"manageGroups" => array('db_activity_manage_groups',
array(
"en-US" => 'Manage Groups',
"fr-FR" => 'Modifier les groupes',
)),
"manageCrawls" => array('db_activity_manage_crawl',
array(
"en-US" => 'Manage Crawl',
"fa" => 'مدیریت خزشها',
"fr-FR" => 'Modifier les indexes',
"ja" => '検索管理',
"ko" => '크롤 관리',
"vi-VN" => 'Quản lý sự bò',
)),
"groupFeeds" => array('db_activity_group_feeds',
array(
"en-US" => 'Feeds and Wikis',
)),
"mixCrawls" => array('db_activity_mix_crawls',
array(
"en-US" => 'Mix Crawls',
"fa" => 'ترکیبهای خزشها',
"fr-FR" => 'Mélanger les indexes',
)),
"manageClassifiers" => array('db_activity_manage_classifiers',
array(
"en-US" => 'Manage Classifiers',
"fa" => '',
"fr-FR" => 'Classificateurs',
)),
"pageOptions" => array('db_activity_file_options',
array(
"en-US" => 'Page Options',
"fa" => 'تنظیمات صفحه',
"fr-FR" => 'Options de fichier',
)),
"resultsEditor" => array('db_activity_results_editor',
array(
"en-US" => 'Results Editor',
"fa" => 'ویرایشگر نتایج',
"fr-FR" => 'Éditeur de résultats',
)),
"searchSources" => array('db_activity_search_services',
array(
"en-US" => 'Search Sources',
"fa" => 'منابع جستجو',
"fr-FR" => 'Sources de recherche',
)),
"manageMachines" => array('db_activity_manage_machines',
array(
"en-US" => 'Manage Machines',
"fa" => 'مدیریت دستگاهها',
"fr-FR" => 'Modifier les ordinateurs',
)),
"manageLocales" => array('db_activity_manage_locales',
array(
"en-US" => 'Manage Locales',
"fa" => 'مدیریت زبانها',
"fr-FR" => 'Modifier les lieux',
"ja" => 'ローケル管理',
"ko" => '로케일 관리',
"vi-VN" => 'Quản lý miền địa phương',
)),
"serverSettings" => array('db_activity_server_settings',
array(
"en-US" => 'Server Settings',
"fr-FR" => 'Serveurs',
)),
"security" => array('db_activity_security',
array(
"en-US" => 'Security',
"fr-FR" => 'Sécurité',
)),
"configure" => array('db_activity_configure',
array(
"en-US" => 'Configure',
"fa" => 'پیکربندی',
"fr-FR" => 'Configurer',
"ja" => '設定',
"ko" => '구성',
"vi-VN" => 'Sắp xếp hoạt động dựa theo hoạch định',
))
);
$i = 1;
foreach($activities as $activity => $translation_info) {
// set-up activity
$db->execute("INSERT INTO ACTIVITY VALUES ($i, $i, '$activity')");
//give admin role the ability to have that activity
$db->execute("INSERT INTO ROLE_ACTIVITY VALUES (".ADMIN_ROLE.", $i)");
$db->execute("INSERT INTO TRANSLATION
VALUES($i, '{$translation_info[0]}')");
foreach($translation_info[1] as $locale_tag => $translation) {
$index = $locale_index[$locale_tag];
$db->execute("INSERT INTO TRANSLATION_LOCALE VALUES ($i, $index,
'$translation')");
}
$i++;
}
$new_user_activities = array(
"manageAccount",
"manageGroups",
"mixCrawls",
"groupFeeds"
);
foreach($new_user_activities as $new_activity) {
$i = 1;
foreach($activities as $key => $value) {
if($new_activity == $key){
//give new user role the ability to have that activity
$db->execute("INSERT INTO ROLE_ACTIVITY VALUES (".
USER_ROLE.", $i)");
}
$i++;
}
}
$db->execute("INSERT INTO MEDIA_SOURCE VALUES ('1342634195',
'YouTube', 'video', 'http://www.youtube.com/watch?v={}&',
'http://i1.ytimg.com/vi/{}/default.jpg', '')");
$db->execute("INSERT INTO MEDIA_SOURCE VALUES ('1342634196',
'MetaCafe', 'video', 'http://www.metacafe.com/watch/{}/',
'http://www.metacafe.com/thumb/{}.jpg', '')");
$db->execute("INSERT INTO MEDIA_SOURCE VALUES ('1342634197',
'DailyMotion', 'video', 'http://www.dailymotion.com/video/{}',
'http://www.dailymotion.com/thumbnail/video/{}', '')");
$db->execute("INSERT INTO MEDIA_SOURCE VALUES ('1342634198',
'Vimeo', 'video', 'http://player.vimeo.com/video/{}',
'http://www.yioop.com/resources/blank.png?{}', '')");
$db->execute("INSERT INTO MEDIA_SOURCE VALUES ('1342634199',
'Break.com', 'video', 'http://www.break.com/index/{}',
'http://www.yioop.com/resources/blank.png?{}', '')");
$db->execute("INSERT INTO MEDIA_SOURCE VALUES ('1342634200',
'Yahoo News', 'rss', 'http://news.yahoo.com/rss/',
'###//content/@url', 'en-US')");
$db->execute("INSERT INTO CRAWL_MIXES VALUES (2, 'images', ".ROOT_ID.", -1)");
$db->execute("INSERT INTO MIX_FRAGMENTS VALUES(2, 0, 1)");
$db->execute("INSERT INTO MIX_COMPONENTS VALUES(
2, 0, 1, 1, 'media:image site:doc')");
$db->execute("INSERT INTO CRAWL_MIXES VALUES (3, 'videos', ".ROOT_ID.", -1)");
$db->execute("INSERT INTO MIX_FRAGMENTS VALUES(3, 0, 1)");
$db->execute("INSERT INTO MIX_COMPONENTS VALUES(
3, 0, 1, 1, 'media:video site:doc')");
$db->execute("INSERT INTO CRAWL_MIXES VALUES (4, 'news', ".ROOT_ID.", -1)");
$db->execute("INSERT INTO MIX_FRAGMENTS VALUES(4, 0, 1)");
$db->execute("INSERT INTO MIX_COMPONENTS VALUES(4, 0, 1, 1,
'media:news')");
$db->execute("INSERT INTO SUBSEARCH VALUES('db_subsearch_images',
'images','m:2', 50)");
$db->execute("INSERT INTO TRANSLATION VALUES (1002,'db_subsearch_images')");
$db->execute("INSERT INTO TRANSLATION_LOCALE VALUES
(1002, 1, 'Images' )");
$db->execute("INSERT INTO TRANSLATION_LOCALE VALUES
(1002, 2, 'الصور' )");
$db->execute("INSERT INTO TRANSLATION_LOCALE VALUES
(1002, 5, 'Images' )");
$db->execute("INSERT INTO TRANSLATION_LOCALE VALUES
(1002, 15, 'Hình' )");
$db->execute("INSERT INTO TRANSLATION_LOCALE VALUES
(1002, 16, '图象' )");
$db->execute("INSERT INTO TRANSLATION_LOCALE VALUES
(1002, 20, 'تصاویر' )");
$db->execute("INSERT INTO SUBSEARCH VALUES ('db_subsearch_videos',
'videos','m:3', 10)");
$db->execute("INSERT INTO TRANSLATION VALUES (1003,'db_subsearch_videos')");
$db->execute("INSERT INTO TRANSLATION_LOCALE VALUES
(1003, 1, 'Videos' )");
$db->execute("INSERT INTO TRANSLATION_LOCALE VALUES
(1003, 2, 'فيديو' )");
$db->execute("INSERT INTO TRANSLATION_LOCALE VALUES
(1003, 5, 'Vidéos' )");
$db->execute("INSERT INTO TRANSLATION_LOCALE VALUES
(1003, 15, 'Thâu hình' )");
$db->execute("INSERT INTO TRANSLATION_LOCALE VALUES
(1003, 16, '录影' )");
$db->execute("INSERT INTO TRANSLATION_LOCALE VALUES
(1003, 20, 'ویدیوها' )");
$db->execute("INSERT INTO SUBSEARCH VALUES ('db_subsearch_news',
'news','m:4',20)");
$db->execute("INSERT INTO TRANSLATION VALUES (1004,'db_subsearch_news')");
$db->execute("INSERT INTO TRANSLATION_LOCALE VALUES
(1004, 1, 'News' )");
$db->execute("INSERT INTO TRANSLATION_LOCALE VALUES
(1004, 2, 'أخبار' )");
$db->execute("INSERT INTO TRANSLATION_LOCALE VALUES
(1004, 5, 'Actualités' )");
$db->execute("INSERT INTO TRANSLATION_LOCALE VALUES
(1004, 15, 'Tin tức' )");
$db->execute("INSERT INTO TRANSLATION_LOCALE VALUES
(1004, 16, '新闻' )");
$db->execute("INSERT INTO TRANSLATION_LOCALE VALUES
(1004, 20, 'اخبار' )");
if(stristr(DB_HOST, "pgsql") !== false) {
/* For postgres count initial values of SERIAL sequences
will be screwed up unless do
*/
$auto_tables = array("ACTIVITY" =>"ACTIVITY_ID",
"GROUP_ITEM" =>"GROUP_ITEM_ID", "GROUP_PAGE" => "GROUP_PAGE_ID",
"GROUPS" => "GROUP_ID", "LOCALE"=> "LOCALE_ID", "ROLE" => "ROLE_ID",
"TRANSLATION" => "TRANSLATION_ID", "USERS" => "USER_ID");
foreach($auto_tables as $table => $auto_column) {
$sql = "SELECT MAX($auto_column) AS NUM FROM $table";
$result = $db->execute($sql);
$row = $db->fetchArray($result);
$next = $row['NUM'];
$sequence = strtolower("{$table}_{$auto_column}_seq");
$sql = "SELECT setval('$sequence', $next)";
$db->execute($sql);
$sql = "SELECT nextval('$sequence')";
$db->execute($sql);
}
}
$db->disconnect();
if(in_array(DBMS, array('sqlite','sqlite3' ))){
chmod(CRAWL_DIR."/data/".DB_NAME.".db", 0666);
}
echo "Create DB succeeded\n";
?>