public static function getTemplateInfo($templateId)
{
$db = new DBconnection();
$query = "SELECT * FROM " . self::getTableName() . " WHERE " . $db->getWherePart(self::getTableKeyField(), $templateId);
$result = $db->selectQuery($query, self::getTableFields());
return $result[0];
}
/**
* return module id by search parameters
*
* @param Array $values
* @return data array
*/
public static function getModuleVisibility($values)
{
$db = new DBconnection();
$query = "SELECT * FROM " . self::getTableName();
$where = $db->getWherePart(self::getTableFields(), $values);
if ($where != "") {
$query .= " WHERE {$where}";
}
$query .= " ORDER BY `" . self::$fields["requestOrder"] . "`";
$result = $db->selectQuery($query, self::getTableFields());
return $result;
}
public static function login($login, $pass)
{
$values = array();
$values["login"] = $login;
$values["pass"] = $pass;
$db = new DBconnection();
$query = "SELECT * FROM " . self::getTableName() . " WHERE " . $db->getWherePart(self::getTableFields(), $values);
$result = $db->selectQuery($query, self::getTableFields());
if (isset($result[0])) {
unset($result[0]["pass"]);
return $result[0];
}
return null;
}