function exec($args, $stdin, &$stdout, &$stderr, &$system)
{
$object = new mObject(getNode($_SESSION['murrix']['path']));
$user = $object->getUser();
$stdout .= "<table cellspacing=\"0\">";
$stdout .= "<tr><td class=\"titlename\">Name</td><td>".cmd($object->getName(), "exec=show'&node_id=".$object->getNodeId())."</td></tr>";
$stdout .= "<tr><td class=\"titlename\">Icon</td><td>".img(geticon($object->getIcon(), 16))."</td></tr>";
$stdout .= "<tr><td class=\"titlename\">Id</td><td>".$object->getNodeId()."</td></tr>";
$stdout .= "<tr><td class=\"titlename\">Revision</td><td>".$object->getVersion()."</td></tr>";
$stdout .= "<tr><td class=\"titlename\">Language</td><td>".$object->getLanguage()."</td></tr>";
$stdout .= "<tr><td class=\"titlename\">Class</td><td>".$object->getClassName()."</td></tr>";
$stdout .= "<tr><td class=\"titlename\">Rights</td><td>".$object->getRights()."</td></tr>";
$stdout .= "<tr><td class=\"titlename\">User</td><td>".$user->username."</td></tr>";
$stdout .= "<tr><td class=\"titlename\">Time</td><td>".$object->getCreated()."</td></tr>";
$stdout .= "</table>";
return true;
}
function actionSave(&$system, $args)
{
$bError = false;
if (empty($args['name']))
{
$system->addAlert(ucf(i18n("please enter a name")));
$bError = true;
}
if (!(strpos($args['name'], "\\") === false) || !(strpos($args['name'], "/") === false) || !(strpos($args['name'], "+") === false))
{
$system->addAlert(ucf(i18n("you can not use '\\', '/' or '+' in the name")));
$bError = true;
}
if (!$bError)
{
$object = new mObject($this->getNodeId($args));
if ($object->getNodeId() > 0)
{
if ($object->hasRight("write"))
{
$object->name = trim($args['name']);
$object->icon = trim($args['icon']);
$newlang = ($object->getLanguage() != trim($args['language']));
$object->language = trim($args['language']);
$vars = $object->getVars();
foreach ($vars as $var)
{
$key = "v".$var->id;
$value = (isset($args[$key]) ? $args[$key] : (isset($args[$var->id]) ? $args[$var->id] : ""));
if (empty($value) && $var->getRequired() && $var->getType() != "boolean")
{
$system->addAlert(utf8e(ucf(str_replace("_", " ", i18n($var->getName(true))))." ".i18n("is a required field")));
return;
}
$object->setVarValue($var->name, $value);
}
if ($args['newversion'] == "on" || $newlang)
$ret = $object->save();
else
$ret = $object->saveCurrent();
if ($ret)
{
$system->addRedirect("exec=show&node_id=".$object->getNodeId());
clearNodeFileCache($object->getNodeId());
$links = $object->getLinks();
foreach ($links as $link)
{
if ($link['type'] == "sub")
clearNodeFileCache($link['remote_id']);
}
}
else
{
$message = "Operation unsuccessfull.<br/>";
$message .= "Error output:<br/>";
$message .= $object->getLastError();
$system->addAlert($message);
}
}
}
}
}
function fetch($query, $debug = false)
{
if (isset($_SESSION['murrix']['querycache'][$query]) && !$debug)
return $_SESSION['murrix']['querycache'][$query];
$query2 = $query;
$commands = array("FETCH", "WHERE", "NODESORTBY", "SORTBY");
$cmdstr = implode("|", $commands);
$links = false;
$vars = 0;
$return = "object";
$sort = array();
$vars_array = array();
$nodesortby = "";
foreach ($commands as $ord)
{
if (preg_match("/^[ ]*($ord) (.+?)( ($cmdstr|$)|$)/", $query, $matches))
{
switch ($matches[1])
{
case "FETCH":
switch (trim($matches[2]))
{
case "count":
$select = "SELECT count(objects.id) AS count ";
$return = "count";
break;
case "node":
$select = "SELECT objects.id AS id, objects.node_id AS node_id, objects.language AS language, objects.version AS version ";
$return = "node";
break;
case "object":
default:
$select = "SELECT objects.id AS id ";
$return = "object";
break;
}
break;
case "WHERE":
$org_where = trim($matches[2]);
if (preg_match_all("/[ ]*(.+?)( AND| OR|$)/", $org_where, $wmatches))
{
$wmatches = $wmatches[1];
//PrintPre($wmatches);
foreach ($wmatches AS $match)
{
$match = trim($match);
if ($match{0} == "(")
$match = substr($match, 1, strlen($match)-1);
$parts = explode(":", $match, 2);
$invert = "";
if ($parts[0]{0} == "!")
{
$invert = "!";
$parts[0] = substr($parts[0], 1, strlen($parts[0])-1);
}
switch ($parts[0])
{
case "property":
$org_where = str_replace($match, "$invert(objects.".$parts[1].")", $org_where);
break;
case "var":
$parts2 = explode("=", $parts[1]);
if (!isset($vars_array[$parts2[0]]))
{
$vars++;
$vars_array[$parts2[0]] = $vars;
}
$num = $vars_array[$parts2[0]];
$org_where = str_replace($match, "values$num.data$invert=".$parts2[1], $org_where);
break;
case "link":
$parts2 = explode("=", $parts[1]);
switch ($parts2[0])
{
case "node_top":
$org_where = str_replace($match, "$invert(links.node_top=".$parts2[1]." AND links.node_bottom=objects.node_id)", $org_where);
break;
case "node_bottom":
$org_where = str_replace($match, "$invert(links.node_bottom=".$parts2[1]." AND links.node_top=objects.node_id)", $org_where);
break;
case "type":
$org_where = str_replace($match, "$invert(links.type=".$parts2[1].")", $org_where);
break;
case "node_id":
default:
$org_where = str_replace($match, "$invert((links.node_bottom=".$parts2[1]." AND links.node_top=objects.node_id) OR (links.node_top=".$parts2[1]." AND links.node_bottom=objects.node_id))", $org_where);
break;
}
$links = true;
break;
}
}
}
$where_more = "";
foreach ($vars_array as $key => $value)
{
$where_more .= "(values$value.object_id=objects.id AND values$value.var_id=vars$value.id AND vars$value.name='$key') AND ";
}
$where = "WHERE $where_more ($org_where)";
break;
case "NODESORTBY":
$org_sort = trim($matches[2]);
if (preg_match_all("/[ ]*(.+?)(,|$)/", $org_sort, $wmatches))
{
$wmatches = $wmatches[1];
foreach ($wmatches AS $match)
{
$match = trim($match);
$parts = explode(":", $match, 2);
$invert = " DESC";
if ($parts[0]{0} == "!")
{
$invert = " ASC";
$parts[0] = substr($parts[0], 1, strlen($parts[0])-1);
}
switch ($parts[0])
{
case "property":
$org_sort = str_replace($match, "objects.".$parts[1].$invert, $org_sort);
break;
}
}
}
$nodesortby = "ORDER BY $org_sort";
break;
case "SORTBY":
$org_sort = trim($matches[2]);
if (preg_match_all("/[ ]*(.+?)(,|$)/", $org_sort, $wmatches))
{
$wmatches = $wmatches[1];
foreach ($wmatches AS $match)
{
$match = trim($match);
$parts = explode(":", $match, 2);
$invert = false;
if ($parts[0]{0} == "!")
{
$invert = true;
$parts[0] = substr($parts[0], 1, strlen($parts[0])-1);
}
switch ($parts[0])
{
case "property":
$sort[] = array("property:".$parts[1], $invert);
//$org_sort = str_replace($match, "objects.".$parts[1].($invert ? "" : " DESC"), $org_sort);
break;
case "var":
$sort[] = array($parts[1], $invert);
break;
}
}
}
//if (!empty($org_sort))
// $sortby = "ORDER BY $org_sort";
break;
}
$len = strlen($matches[0]) - strlen($matches[3]);
$query = trim(substr($query, $len, strlen($query)-$len));
}
else
{
if (!empty($query))
{
echo "nåt galet hände..\n";
echo $query;
}
}
}
global $db_prefix;
$from = "FROM `".$db_prefix."objects` AS `objects`";
for ($n = 1; $n <= $vars; $n++)
$from .= ", `".$db_prefix."vars` AS `vars$n`, `".$db_prefix."values` AS `values$n`";
if ($links)
$from .= ", `".$db_prefix."links` AS `links`";
$sql = "$select $from $where $nodesortby";
$result = mysql_query($sql) or die("fetch " . mysql_errno() . " " . mysql_error());
if ($return == "count")
{
$row = mysql_fetch_array($result, MYSQL_ASSOC);
//$_SESSION['debug'] += microtime_float()-$time;
$_SESSION['murrix']['querycache'][$query2] = $row['count'];
return $row['count'];
}
if ($return == "object")
{
$objects = array();
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
$object = new mObject();
if (!$object->loadByObjectId($row['id']))
echo $object->getLastError();
$objects[] = $object;
}
}
else if ($return == "node")
{
$objects = array();
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
$object = new mObject();
$object->node_id = $row['node_id'];
$object->id = $row['id'];
$object->version = $row['version'];
$object->language = $row['language'];
$objects[] = $object;
}
$nodes = array();
$node_list = array();
foreach ($objects as $object)
{
// We have a prior version already
if (isset($node_list[$object->getNodeId()]))
{
if ($node_list[$object->getNodeId()] != $_SESSION['murrix']['language']) // Not a perfect match
{
if ($object->getLanguage() == $_SESSION['murrix']['language']) // We have a better match
{
$nodes[$object->getNodeId()] = $object;
$node_list[$object->getNodeId()] = $object->getLanguage();
}
}
/*else // Perfect language match
{
if ($node_list[$object->getNodeId()]->version < $object->version)// Do we have a better version
{
$nodes[$object->getNodeId()] = $object;
$node_list[$object->getNodeId()] = $object->getLanguage();
}
}*/
}
else // We have no prior match
{
$nodes[$object->getNodeId()] = $object;
$node_list[$object->getNodeId()] = $object->getLanguage();
}
}
$objects2 = array_values($nodes);
$objects = array();
foreach ($objects2 as $object2)
{
$object = new mObject();
if (!$object->loadByObjectId($object2->getId()))
echo $object->getLastError();
$objects[] = $object;
}
}
if (!empty($sort))
{
$sort = array_reverse($sort);
foreach ($sort as $sortby)
{
SortBy(&$objects, $sortby[0], $sortby[1]);
}
}
$_SESSION['murrix']['querycache'][$query2] = $objects;
return $objects;
}
