$sql = "SELECT objekt_id, convert(pealkiri using utf8) as pealkiri, keel, tyyp_id FROM objekt WHERE tyyp_id in (".implode(',', array_keys($objects_with_alias_types)).") and (friendly_url = '' or friendly_url is null) and (sys_alias = '' || sys_alias is null)";
	$sth = new SQL($sql);
	$objekti_arv += $sth->rows;

	if ($site->fdat['run'] && $sth->rows)
	{
		include_once($class_path.'adminpage.inc.php');
		
		echo "
		<tr>
		<td><b>Create aliases: </b><br>".$sql."</td>
		</tr>
		";
		while ($tmp = $sth->fetch()) {
			
			$alias = create_alias_for_object($tmp['pealkiri'], $tmp['keel']);
			
			if($alias !== '')
			{
				$sql = $site->db->prepare('update objekt set friendly_url = ? where objekt_id = ?', $alias, $tmp['objekt_id']);
				new SQL($sql);
			}
			
			echo "
				<tr bgcolor=\"FFFFFF\">
				<td nowrap>objekt_id: ".$tmp['objekt_id']."; type: ".$objects_with_alias_types[$tmp['tyyp_id']]."; title: \"".$tmp['pealkiri']."\"; ".($alias !== '' ? 'alias: <b>'.$alias.'</b>': 'Could not create alias')."</td>
				<td nowrap>keel: ".$tmp['keel']."</td>
				<td nowrap>&nbsp;</td>
				<td nowrap>objekt</td>
				</tr>
				";
 */
header('Content-type: text/javascript');
$class_path = '../classes/';
// for multi-upload session, the flash does not send cookie values
if (isset($_POST['PHPSESSID'])) {
    session_id($_POST['PHPSESSID']);
    session_start();
}
include $class_path . 'port.inc.php';
$site = new Site(array());
// so there would be no parse errors in json
ini_set('display_errors', 0);
// generate alias
if ($site->user->user_id && $_REQUEST['op'] == 'generate_alias' && isset($_REQUEST['string']) && isset($_REQUEST['language_id'])) {
    include_once $class_path . 'adminpage.inc.php';
    $alias = create_alias_for_object($_REQUEST['string'], $_REQUEST['language_id']);
    echo '{"alias": "' . $alias . '"}';
    exit;
}
// check if a file exists
if ($site->user->user_id && $_REQUEST['op'] == 'check_file' && $site->fdat['name']) {
    include_once $class_path . 'adminpage.inc.php';
    $pathinfo = str_replace(array('../', './', '..\\', '.\\'), '', $site->fdat['name']);
    $pathinfo = explode('/', $pathinfo);
    $filename = create_alias_from_string($pathinfo[count($pathinfo) - 1], true);
    unset($pathinfo[count($pathinfo) - 1]);
    $dirname = implode('/', $pathinfo);
    if (file_exists($site->absolute_path . $dirname . '/' . $filename)) {
        echo '{"file_exists": 1}';
    } else {
        echo '{"file_exists": 0}';