function ewiki_database_moodle($action, &$args, $sw1, $sw2)
{
global $wiki, $wiki_entry, $CFG, $DB;
#-- result array
$r = array();
switch ($action) {
/* Returns database entry as array for the page whose name was given
with the "id" key in the $args array, usually fetches the latest
version of a page, unless a specific "version" was requested in
the $args array.
*/
# Ugly, but we need to choose which wiki we are about to change/read
case "GET":
$params = array('id' => $args["id"]);
if ($version = 0 + @$args["version"]) {
$params['version'] = $version;
$versionsql = "AND version = :version";
} else {
$versionsql = "";
}
# $result = mysql_query("SELECT * FROM " . EWIKI_DB_TABLE_NAME
# . " WHERE (pagename=$id) $version ORDER BY version DESC LIMIT 1"
#);
#if ($result && ($r = mysql_fetch_array($result, MYSQL_ASSOC))) {
# $r["id"] = $r["pagename"];
# unset($r["pagename"]);
#}
#if (strlen($r["meta"])) {
# $r["meta"] = @unserialize($r["meta"]);
#}
$select = "(pagename=:id) AND wiki= :weid {$versionsql} ";
$params['weid'] = $wiki_entry->id;
$sort = "version DESC";
if ($result_arr = $DB->get_records_select(EWIKI_DB_TABLE_NAME, $select, $params, $sort, "*", 0, 1)) {
//Iterate to get the first (and unique!)
foreach ($result_arr as $obj) {
$result_obj = $obj;
}
}
if ($result_obj) {
//Convert to array
$r = get_object_vars($result_obj);
$r["id"] = $r["pagename"];
unset($r["pagename"]);
$r["meta"] = @unserialize($r["meta"]);
}
break;
/* Increases the hit counter for the page name given in $args array
with "id" index key.
*/
/* Increases the hit counter for the page name given in $args array
with "id" index key.
*/
case "HIT":
#mysql_query("UPDATE " . EWIKI_DB_TABLE_NAME . " SET hits=(hits+1) WHERE pagename='" . anydb_escape_string($args["id"]) . "'");
# $DB->set_field does not work because of the "hits+1" construct
#print "DO ".anydb__escape_string($args["id"]); exit;
$DB->execute("UPDATE {" . EWIKI_DB_TABLE_NAME . "} SET hits=(hits+1) WHERE pagename=? and wiki=?", array($args["id"], $wiki_entry->id));
break;
/* Stores the $data array into the database, while not overwriting
existing entries (using WRITE); returns 0 on failure and 1 if
saved correctly.
*/
/* Stores the $data array into the database, while not overwriting
existing entries (using WRITE); returns 0 on failure and 1 if
saved correctly.
*/
case "OVERWRITE":
$COMMAND = "REPLACE";
break;
case "WRITE":
$COMMAND = "WRITE";
$args["pagename"] = $args["id"];
unset($args["id"]);
if (is_array($args["meta"])) {
$args["meta"] = serialize($args["meta"]);
}
#$sql1 = $sql2 = "";
#foreach ($args as $index => $value) {
# if (is_int($index)) {
# continue;
# }
# $a = ($sql1 ? ', ' : '');
# $sql1 .= $a . $index;
# $sql2 .= $a . "'" . anydb_escape_string($value) . "'";
#}
#strlen(@$COMMAND) || ($COMMAND = "INSERT");
foreach ($args as $index => $value) {
if (is_int($index)) {
continue;
}
$args[$index] = anydb_escape_string($value);
}
$args["wiki"] = $wiki_entry->id;
# Check if Record exists
if ($COMMAND == "REPLACE") {
if ($DB->count_records(EWIKI_DB_TABLE_NAME, array("wiki" => $wiki_entry->id, "pagename" => $args["pagename"], "version" => $args["version"]))) {
$DB->delete_record(EWIKI_DB_TABLE_NAME, array("wiki" => $wiki_entry->id, "pagename" => $args["pagename"], "version" => $args["version"]));
}
}
# Write
$result = $DB->insert_record(EWIKI_DB_TABLE_NAME, (object) $args, false);
#$result = mysql_query("$COMMAND INTO " . EWIKI_DB_TABLE_NAME .
# " (" . $sql1 . ") VALUES (" . $sql2 . ")"
#);
#return($result && mysql_affected_rows() ?1:0);
return $result;
break;
/* Checks for existence of the WikiPages whose names are given in
the $args array. Returns an array with the specified WikiPageNames
associated with values of "0" or "1" (stating if the page exists
in the database). For images/binary db entries returns the "meta"
field instead of an "1".
*/
/* Checks for existence of the WikiPages whose names are given in
the $args array. Returns an array with the specified WikiPageNames
associated with values of "0" or "1" (stating if the page exists
in the database). For images/binary db entries returns the "meta"
field instead of an "1".
*/
case "FIND":
$select = "";
$params = array();
$p = 0;
foreach (array_values($args) as $id) {
if (strlen($id)) {
$p++;
$pname = "par{$p}";
$r[$id] = 0;
$select .= ($select ? " OR " : "") . "(pagename= :{$pname})";
$params[$pname] = $id;
}
}
if ($select) {
$select = "(" . $select . ") AND wiki= :weid ";
$params['weid'] = $wiki_entry->id;
$result = $DB->get_records_select(EWIKI_DB_TABLE_NAME, $select, $params);
while (list($key, $val) = @each($result)) {
$r[$val->pagename] = strpos($val->meta, 's:5:"image"') ? $val->meta : 1;
}
}
break;
/* Counts the number of Versions
*/
/* Counts the number of Versions
*/
case "COUNTVERSIONS":
$sql = "SELECT pagename AS id, count(*) as versioncount" . " FROM {" . EWIKI_DB_TABLE_NAME . "}\n WHERE wiki = ?" . " GROUP BY pagename";
#print "$sql";
$result = $DB->get_records_sql($sql, array($wiki_entry->id));
while (list($key, $val) = each($result)) {
$r[$key] = $val->versioncount;
}
break;
/* Returns an array of the lastest versions of __all__ pages,
where each entry is made up of the fields from the database
requested with the $args array, e.g.
array("flags","meta","lastmodified");
*/
/* Returns an array of the lastest versions of __all__ pages,
where each entry is made up of the fields from the database
requested with the $args array, e.g.
array("flags","meta","lastmodified");
*/
case "GETALL":
switch ($DB->get_db_family()) {
case 'postgres':
// All but the latest version eliminated by DISTINCT
// ON (pagename)
$sql = "SELECT DISTINCT ON (pagename) pagename AS id, " . implode(", ", $args) . " FROM {" . EWIKI_DB_TABLE_NAME . "}" . " WHERE wiki = ?" . " ORDER BY pagename, version DESC";
break;
case 'mysql':
// All but the latest version eliminated by
// mysql-specific GROUP BY-semantics
$sql = "SELECT pagename AS id, " . implode(", ", $args) . " FROM {" . EWIKI_DB_TABLE_NAME . "}" . " WHERE wiki = ?" . " GROUP BY id, version DESC ";
default:
// All but the latest version are here eliminated in
// $DB->get_records_sql, since it will return an array
// with only one result per id-field value. Note,
// that for this to work the query needs to order the
// records ascending by version, so later versions
// will overwrite previous ones in
// recordset_to_array. This is not pretty.
$sql = "SELECT pagename AS id, " . implode(", ", $args) . " FROM {" . EWIKI_DB_TABLE_NAME . "}" . " WHERE wiki = ?" . " ORDER BY version";
}
$result = $DB->get_records_sql($sql, array($wiki_entry->id));
$r = new ewiki_dbquery_result($args);
if ($result) {
foreach ($result as $val) {
$r->add(get_object_vars($val));
}
}
break;
/* Returns array of database entries (also arrays), where the one
specified column matches the specified content string, for example
$args = array("content" => "text...piece")
is not guaranteed to only search/return the latest version of a page
*/
/* Returns array of database entries (also arrays), where the one
specified column matches the specified content string, for example
$args = array("content" => "text...piece")
is not guaranteed to only search/return the latest version of a page
*/
case "SEARCH":
$field = implode("", array_keys($args));
$content = strtolower(implode("", $args));
if ($field == "id") {
$field = "pagename";
}
$sql = "SELECT pagename AS id, version, flags" . (EWIKI_DBQUERY_BUFFER && $field != "pagename" ? ", {$field}" : "") . " FROM {" . EWIKI_DB_TABLE_NAME . "}" . " WHERE {$field} " . $DB->sql_ilike() . " ? and wiki= ?" . " ORDER BY id, version ASC";
$result = $DB->get_records_sql($sql, array("%{$content}%", $wiki_entry->id));
$r = new ewiki_dbquery_result(array("id", "version", $field));
$drop = "";
#while ($result && ($row = mysql_fetch_array($result, MYSQL_ASSOC))) {
# $i = EWIKI_CASE_INSENSITIVE ? strtolower($row["id"]) : $row["id"];
# if ($i != $drop) {
# $drop = $i;
# $r->add($row);
# }
#}
while (list($key, $val) = @each($result)) {
$row = get_object_vars($val);
$i = EWIKI_CASE_INSENSITIVE ? strtolower($row["id"]) : $row["id"];
if ($i != $drop) {
$drop = $i;
$r->add($row);
}
}
break;
case "DELETE":
$id = $args["id"];
$version = $args["version"];
#mysql_query("DELETE FROM " . EWIKI_DB_TABLE_NAME ."
# WHERE pagename='$id' AND version=$version");
# print "DELETING wiki:".$wiki_entry->id."Pagename: $id Version: $version <br />\n";
$DB->delete_records(EWIKI_DB_TABLE_NAME, array("wiki" => $wiki_entry->id, "pagename" => $id, "version" => $version));
break;
case "INIT":
#mysql_query("CREATE TABLE " . EWIKI_DB_TABLE_NAME ."
# (pagename VARCHAR(160) NOT NULL,
# version INTEGER UNSIGNED NOT NULL DEFAULT 0,
# flags INTEGER UNSIGNED DEFAULT 0,
# content MEDIUMTEXT,
# author VARCHAR(100) DEFAULT 'ewiki',
# created INTEGER UNSIGNED DEFAULT ".time().",
# lastmodified INTEGER UNSIGNED DEFAULT 0,
# refs MEDIUMTEXT,
# meta MEDIUMTEXT,
# hits INTEGER UNSIGNED DEFAULT 0,
# PRIMARY KEY id (pagename, version) )
# ");
#echo mysql_error();
break;
default:
}
return $r;
}
function SEARCH($field, $content, $ci = "i", $regex = 0, $mask = 0, $filter = 0)
{
if ($ci && !$regex) {
$content = strtolower($content);
}
$r = new ewiki_dbquery_result(array($field));
foreach ($this->ALLFILES() as $id) {
$page = ewiki_db::GET($id);
if ($regex) {
$check = preg_match("{$content}{$ci}", $page[$field]);
} elseif ($ci) {
$check = strpos(strtolower($page[$field]), $content) !== false;
} else {
$check = strpos($page[$field], $content) !== false;
}
if ($check) {
$r->add($page);
}
}
return $r;
}
function ewiki_database_mysql($action, &$args, $sw1, $sw2)
{
#-- reconnect to the database (if multiple are used)
#<off># mysql_ping($GLOBALS["db"]);
#-- result array
$r = array();
switch ($action) {
/* Returns database entry as array for the page whose name was given
with the "id" key in the $args array, usually fetches the latest
version of a page, unless a specific "version" was requested in
the $args array.
*/
case "GET":
$id = "'" . mysql_escape_string($args["id"]) . "'";
$version = 0 + @$args["version"] and $version = "AND (version={$version})" or $version = "";
$result = mysql_query("SELECT * FROM " . EWIKI_DB_TABLE_NAME . " WHERE (pagename={$id}) {$version} ORDER BY version DESC LIMIT 1");
if ($result && ($r = mysql_fetch_array($result, MYSQL_ASSOC))) {
$r["id"] = $r["pagename"];
unset($r["pagename"]);
}
if (strlen($r["meta"])) {
$r["meta"] = @unserialize($r["meta"]);
}
break;
/* Increases the hit counter for the page name given in $args array
with "id" index key.
*/
/* Increases the hit counter for the page name given in $args array
with "id" index key.
*/
case "HIT":
mysql_query("UPDATE " . EWIKI_DB_TABLE_NAME . " SET hits=(hits+1) WHERE pagename='" . mysql_escape_string($args["id"]) . "'");
break;
/* Stores the $data array into the database, while not overwriting
existing entries (using WRITE); returns 0 on failure and 1 if
saved correctly.
*/
/* Stores the $data array into the database, while not overwriting
existing entries (using WRITE); returns 0 on failure and 1 if
saved correctly.
*/
case "OVERWRITE":
// fall-through
$COMMAND = "REPLACE";
case "WRITE":
$args["pagename"] = $args["id"];
unset($args["id"]);
if (is_array($args["meta"])) {
$args["meta"] = serialize($args["meta"]);
}
$sql1 = $sql2 = "";
foreach ($args as $index => $value) {
if (is_int($index)) {
continue;
}
$a = $sql1 ? ', ' : '';
$sql1 .= $a . $index;
$sql2 .= $a . "'" . mysql_escape_string($value) . "'";
}
strlen(@$COMMAND) || ($COMMAND = "INSERT");
$result = mysql_query("{$COMMAND} INTO " . EWIKI_DB_TABLE_NAME . " (" . $sql1 . ") VALUES (" . $sql2 . ")");
return $result && mysql_affected_rows() ? 1 : 0;
break;
/* Checks for existence of the WikiPages whose names are given in
the $args array. Returns an array with the specified WikiPageNames
associated with values of "0" or "1" (stating if the page exists
in the database). For images/binary db entries returns the "meta"
field instead of an "1".
*/
/* Checks for existence of the WikiPages whose names are given in
the $args array. Returns an array with the specified WikiPageNames
associated with values of "0" or "1" (stating if the page exists
in the database). For images/binary db entries returns the "meta"
field instead of an "1".
*/
case "FIND":
$sql = "";
foreach (array_values($args) as $id) {
if (strlen($id)) {
$r[$id] = 0;
$sql .= ($sql ? " OR " : "") . "(pagename='" . mysql_escape_string($id) . "')";
}
}
$result = mysql_query($sql = "SELECT pagename AS id, meta FROM " . EWIKI_DB_TABLE_NAME . " WHERE {$sql} ");
while ($result && ($row = mysql_fetch_row($result))) {
$r[$row[0]] = strpos($row[1], 's:5:"image"') ? $row[1] : 1;
}
break;
/* Returns an array of __all__ pages, where each entry is made up
of the fields from the database requested with the $args array,
e.g. array("flags","meta","lastmodified");
*/
/* Returns an array of __all__ pages, where each entry is made up
of the fields from the database requested with the $args array,
e.g. array("flags","meta","lastmodified");
*/
case "GETALL":
$result = mysql_query("SELECT pagename AS id, " . implode(", ", $args) . " FROM " . EWIKI_DB_TABLE_NAME . " GROUP BY id, version DESC");
$r = new ewiki_dbquery_result($args);
$drop = "";
while ($result && ($row = mysql_fetch_array($result, MYSQL_ASSOC))) {
$i = EWIKI_CASE_INSENSITIVE ? strtolower($row["id"]) : $row["id"];
if ($i != $drop) {
$drop = $i;
$r->add($row);
}
}
break;
/* Returns array of database entries (also arrays), where the one
specified column matches the specified content string, for example
$args = array("content" => "text...piece")
is not guaranteed to only search/return the latest version of a page
*/
/* Returns array of database entries (also arrays), where the one
specified column matches the specified content string, for example
$args = array("content" => "text...piece")
is not guaranteed to only search/return the latest version of a page
*/
case "SEARCH":
$field = implode("", array_keys($args));
$content = strtolower(implode("", $args));
if ($field == "id") {
$field = "pagename";
}
$result = mysql_query("SELECT pagename AS id, version, flags" . (EWIKI_DBQUERY_BUFFER && $field != "pagename" ? ", {$field}" : "") . " FROM " . EWIKI_DB_TABLE_NAME . " WHERE LOCATE('" . mysql_escape_string($content) . "', LCASE({$field})) " . " GROUP BY id, version DESC");
$r = new ewiki_dbquery_result(array("id", "version", $field));
$drop = "";
while ($result && ($row = mysql_fetch_array($result, MYSQL_ASSOC))) {
$i = EWIKI_CASE_INSENSITIVE ? strtolower($row["id"]) : $row["id"];
if ($i != $drop) {
$drop = $i;
$r->add($row);
}
}
break;
case "DELETE":
$id = mysql_escape_string($args["id"]);
$version = $args["version"];
mysql_query("DELETE FROM " . EWIKI_DB_TABLE_NAME . "\n WHERE pagename='{$id}' AND version={$version}");
break;
case "INIT":
mysql_query("CREATE TABLE " . EWIKI_DB_TABLE_NAME . "\n (pagename VARCHAR(160) NOT NULL,\n version INTEGER UNSIGNED NOT NULL DEFAULT 0,\n flags INTEGER UNSIGNED DEFAULT 0,\n content MEDIUMTEXT,\n author VARCHAR(100) DEFAULT 'ewiki',\n userid INTEGER UNSIGNED DEFAULT 0,\n created INTEGER UNSIGNED DEFAULT " . time() . ",\n lastmodified INTEGER UNSIGNED DEFAULT 0,\n refs MEDIUMTEXT,\n meta MEDIUMTEXT,\n hits INTEGER UNSIGNED DEFAULT 0,\n PRIMARY KEY id (pagename, version) )\n ");
echo mysql_error();
break;
default:
}
return $r;
}
function SEARCH($field, $content, $ci = "i", $regex = 0, $mask = 0, $filter = 0)
{
$r = new ewiki_dbquery_result(array($field));
if ($ci && !$regex) {
$content = strtolower($content);
}
foreach ($this->ALLFILES() as $id) {
$row = $this->GET($id);
if ($regex) {
$match = preg_match("{$content}{$ci}", $row[$field]);
} elseif ($ci) {
$match = false !== strpos(strtolower($row[$field]), $content);
} else {
$match = false !== strpos($row[$field], $content);
}
if ($match) {
$r->add($row);
}
}
return $r;
}
function SEARCH($field, $content, $ci = "i", $regex = 0, $mask = 0, $filter = 0)
{
if ($ci && !$regex) {
$content = strtolower($content);
}
$r = new ewiki_dbquery_result($args);
#-- fast title search
if (!$mask && $field == "id") {
foreach ($this->ALL() as $id) {
if ($regex && preg_match("{$content}{$ci}", $id) or $ci && strpos(strtolower($id), $content) or !$ci && strpos($id, $content)) {
$this->entries[] = $id;
}
}
} else {
foreach ($this->ALL() as $id) {
$row = ewiki_database_dzf2::GET($id);
if ($mask && $filter != ($row["flags"] & $mask)) {
continue;
}
if ($regex && preg_match("{$content}{$ci}", $row[$field]) or $ci && strpos(strtolower($row[$field]), $content) or !$ci && strpos($row[$field], $content)) {
$r->add($row);
}
}
}
return $r;
}
function GETALL($fields, $mask = 0, $filter = 0)
{
$r = new ewiki_dbquery_result($fields);
foreach ($this->LS() as $fn) {
if ($data = $this->GET($fn)) {
$r->add($data);
}
}
return $r;
}
function AS_DBQUERY_RESULT(&$result, $fields)
{
$r = new ewiki_dbquery_result($fields);
$last = "";
if ($result) {
while ($row = anydb_fetch_array($result)) {
if (EWIKI_DB_UTF8) {
$this->UTF8_DECODE($row);
}
$drop = EWIKI_CASE_INSENSITIVE ? strtolower($row["id"]) : $row["id"];
if ($last != $drop && ($last = $drop)) {
if (EWIKI_DB_UTF8) {
$this->UTF8_DECODE($row);
}
if (EWIKI_DB_BIN64) {
$this->BIN64_DECODE($row);
}
$r->add($row);
}
}
}
return $r;
}
function SEARCH($field, $content, $ci = "i", $regex = 0, $mask = 0, $filter = 0)
{
$r = new ewiki_dbquery_result($args);
if ($ci && !$regex) {
$content = strtolower($content);
}
$ALL = $this->GETALL(array($field), $mask, $filter);
while ($row = $ALL->get()) {
if ($regex) {
$match = preg_match("{$content}{$ci}", $row["field"]);
} elseif ($ci) {
$match = strpos(strtolower($row[$field]), $content) !== false;
} else {
$match = strpos($row[$field], $content) !== false;
}
if ($match) {
$r->add($row);
}
}
return $r;
}
