function updateDb()
{
$params = array();
$toReturn = array();
$toReturn['updated'] = true;
$toReturn['message'] = "";
$db = new RecordSet($this->dbConnectionInfo, false, true);
$rows = $db->Open("SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '" . $this->dbConnectionInfo['dbName'] . "' AND TABLE_NAME = 'webhelp'");
if ($rows > 0) {
$db->Open("SELECT * FROM webhelp;");
while ($db->MoveNext()) {
$assoc = $db->getAssoc();
$params[$db->Field("parameter")] = $db->Field("value");
}
$db->Close();
if ($params['databaseVersion'] != '1') {
$toReturn['updated'] = false;
$toReturn['message'] = "Incompatible database version found!";
}
} else {
$toReturn['updated'] = false;
$toReturn['message'] = "Database structure does not exist! In order to create a compatible database structure you must check option <strong>\"Create new database structure\"</strong> from previous instalation page.";
}
return $toReturn;
}
/**
* export Comments for a specified page
*
* @param IExporter $exporter exporter to be used
* @param String fields to be exported separated by comma
* @param String orderClause to be used in selecting records
*/
function export($exporter, $fields = null, $orderClause = null)
{
$whereClause = "";
$whereFromFilter = $exporter->getFilter()->getSqlFilterClause();
if ($whereFromFilter != null) {
$whereClause = "WHERE " . $whereFromFilter;
}
$db = new RecordSet($this->dbConnectionInfo);
$select = "*";
if ($fields != null) {
//$select=Utils::arrayToString($fields,",");
$select = $fields;
}
$sql = "SELECT " . $select . " FROM " . $this->tableName . " " . $whereClause;
if ($orderClause != null) {
$sql .= " " . $orderClause;
}
$sql .= ";";
if ($db->Open($sql)) {
$rowArray = $db->getAssoc();
while ($rowArray) {
if (is_array($rowArray)) {
$exporter->exportRow($rowArray);
}
$rowArray = $db->getAssoc();
}
}
$db->Close();
}
/**
* export Comments for a specified page
* @param array $info exporting information
* @param IExporter $exporter exporter to be used
*/
function exportForPage($info, $exporter, $fields = null)
{
$toReturn = "";
$whereClause = " WHERE ";
if ($info["filter_version"] != "" && $info["filter_product"] != "") {
$whereClause .= " version='" . $info["filter_version"] . "' AND product='" . $info["filter_product"] . "'";
} else {
$whereClause = "";
}
if ($this->isLoggedModerator()) {
$db = new RecordSet($this->dbConnectionInfo);
$select = "*";
if ($fields != null) {
$select = Utils::arrayToString($fields, ",");
}
$sql = "SELECT " . $select . " FROM comments " . $whereClause . " ORDER BY date DESC";
if ($db->Open($sql)) {
$rowArray = $db->getAssoc();
while ($rowArray) {
if (is_array($rowArray)) {
$exporter->exportRow($rowArray);
}
$rowArray = $db->getAssoc();
}
}
$db->Close();
} else {
$exporter->exportRow(array('ERROR' => 'Your user rights does not permit this opperation!'));
}
}
