$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> </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}';