#!/usr/bin/php -q
<?php
/***************************************************************************
* You can find the license in the docs directory
*
* Unicode Reminder メモ
***************************************************************************/
$opt['rootpath'] = '../../';
// chdir to proper directory (needed for cronjobs)
chdir(substr(realpath($_SERVER['PHP_SELF']), 0, strrpos(realpath($_SERVER['PHP_SELF']), '/')));
require $opt['rootpath'] . 'lib2/cli.inc.php';
require $opt['rootpath'] . 'util2/demodb/settings.inc.php';
require $opt['rootpath'] . 'config2/sqlroot.inc.php';
$db['debug'] = false;
$opt['db']['placeholder']['export'] = $export['dbname'];
if (sql_connect_root() == false) {
$cli->fatal("Could not connect to DB as root!");
}
/*
$sDBName = sql_value("SHOW DATABASES LIKE '&1'", '', $export['dbname']);
if ($sDBName != '')
$cli->fatal("Export DB already exist!");
sql("CREATE DATABASE `&1` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci", $export['dbname']);
sql("USE `&1`", $opt['db']['placeholder']['db']);
$rsTables = sql("SHOW TABLES");
while ($rTable = sql_fetch_array($rsTables))
{
$sTable = $rTable[0];
$cli->out($sTable);
function resetIds()
{
global $translang, $tpl;
if (sql_connect_root() == false) {
$tpl->error(ERROR_DB_NO_ROOT);
}
// clean up dead refs
sql_temp_table('transDeadIds');
sql("CREATE TEMPORARY TABLE &transDeadIds (`trans_id` INT(11) PRIMARY KEY) SELECT `sys_trans_ref`.`trans_id` FROM `sys_trans_ref` LEFT JOIN `sys_trans` ON `sys_trans_ref`.`trans_id`=`sys_trans`.`id` WHERE ISNULL(`sys_trans`.`id`)");
sql("DELETE `sys_trans_ref` FROM `sys_trans_ref`, &transDeadIds WHERE `sys_trans_ref`.`trans_id`=&transDeadIds.`trans_id`");
sql_drop_temp_table('transDeadIds');
sql_temp_table('transDeadIds');
sql("CREATE TEMPORARY TABLE &transDeadIds (`trans_id` INT(11) PRIMARY KEY) SELECT `sys_trans_text`.`trans_id` FROM `sys_trans_text` LEFT JOIN `sys_trans` ON `sys_trans_text`.`trans_id`=`sys_trans`.`id` WHERE ISNULL(`sys_trans`.`id`)");
sql("DELETE `sys_trans_text` FROM `sys_trans_text`, &transDeadIds WHERE `sys_trans_text`.`trans_id`=&transDeadIds.`trans_id`");
sql_drop_temp_table('transDeadIds');
// table sys_trans
if (sql_value("SELECT COUNT(*) FROM `sys_trans` WHERE `id`=1", 0) == 0) {
useId(1);
}
$lastId = sql_value("SELECT MAX(`id`) FROM `sys_trans`", 0);
while ($id = sql_value("SELECT `s1`.`id`+1 FROM `sys_trans` AS `s1` LEFT JOIN `sys_trans` AS `s2` ON `s1`.`id`+1=`s2`.`id` WHERE ISNULL(`s2`.`id`) AND `s1`.`id`<'&1' ORDER BY `s1`.`id` LIMIT 1", 0, $lastId)) {
if ($lastId + 1 == $id) {
break;
}
setId($lastId, $id);
$lastId = sql_value("SELECT MAX(`id`) FROM `sys_trans`", 0);
}
// need alter privileges
$lastId = sql_value("SELECT MAX(`id`) FROM `sys_trans`", 0);
sql("ALTER TABLE `sys_trans` AUTO_INCREMENT = &1", $lastId + 1);
$tpl->redirect('translate.php?translang=' . $translang);
}
