function getTableNameOptions()
 {
     $options = array();
     $stmts = sqlStatement("SHOW TABLES");
     for ($iter = 0; $row = sqlFetchArray($stmts); $iter++) {
         foreach ($row as $key => $value) {
             array_push($options, array("id" => out($value), "label" => out(xl($value))));
         }
     }
     return $options;
 }

/**
 * Render the div full of chat messages.
 * @param $chatlength Essentially the limit on the number of messages.
**/
function render_chat_messages($chatlength, $show_elipsis = null)
{
    // Eventually there might be a reason to abstract out get_chats();
    $sql = new DBAccess();
    $sql->Query("SELECT sender_id, uname, message, age(now(), date) as ago FROM chat join players on chat.sender_id = player_id ORDER BY chat_id DESC LIMIT {$chatlength}");
    // Pull messages
    $chats = $sql->fetchAll();
    $message_rows = '';
    $messageCount = $sql->QueryItem("select count(*) from chat");
    if (!isset($show_elipsis) && $messageCount > $chatlength) {
        $show_elipsis = true;
    }
    $res = "<div class='chatMessages'>";
    $previous_date = null;
    $skip_interval = 3;
    // minutes
    foreach ($chats as $messageData) {
        $l_ago = time_ago($messageData['ago'], $previous_date);
        $message_rows .= "<li>&lt;<a href='player.php?player_id={$messageData['sender_id']}'\n\t\t     target='main'>{$messageData['uname']}</a>&gt; " . out($messageData['message']) . " <span class='chat-time'>{$l_ago}</span></li>";
        $previous_date = $messageData['ago'];
        // Store just prior date.
    }
    $res .= $message_rows;
    if ($show_elipsis) {
        // to indicate there are more chats available
        $res .= ".<br>.<br>.<br>";
    }
    $res .= "</div>";
    return $res;
}

 function __destruct()
 {
     out($this->Comment);
     // this line doesn't crash PHP
     out("\n<!-- End Section: " . $this->Comment . "-->");
     // this line
 }

 public function uninstall()
 {
     out(_("Removing Settings table"));
     $sql = "DROP TABLE IF EXISTS miscdests";
     $q = $this->db->prepare($sql);
     $q->execute();
 }

function generic_error($error = 'unspecified')
{
    global $session;
    header('503 Unavailable');
    $session->log(sprintf('JSON API error: "%s"', print_r($error, true)));
    out(array('error' => $error));
}

function showHelp()
{
    global $argv;
    out("USAGE:");
    out("  " . $argv[0] . " --create|delete --exten <extension> [optional parameters]");
    out("");
    out("OPERATIONS (exactly one must be specified):");
    out("  --create, -c");
    out("      Create a new extension");
    out("  --modify, -m");
    out("      Modify an existing extension, the extension must exist and all values execept");
    out("      those specified will remain the same");
    out("  --delete, -d");
    out("      Delete an extension");
    out("PARAMETERS:");
    out("  --exten extension_number");
    out("      Extension number to create or delete. Must be specified.");
    out("OPTIONAL PARAMETERS:");
    out("  --name name");
    out("      Display Name, defaults to specified extension number.");
    out("  --outboundcid cid_number");
    out("      Outbound CID Number, defaults to specified extension number.");
    out("  --directdid did_number");
    out("      Direct DID Number, defaults to extension number.");
    out("  --vm-password password");
    out("      Voicemail Password, defaults to specified extension number.");
    out("  --sip-secret secret");
    out("      SIP Secret, defaults to md5 hash of specified extension number.");
    out("  --debug");
    out("      Display debug messages.");
    out("  --no-warnings");
    out("      Do Not display warning messages.");
    out("  --help, -h, -?           Show this help");
}

function install($rootFolder)
{
    out('Installing');
    chdir("{$rootFolder}/htdocs");
    getFile("{$rootFolder}/htdocs/dashboard.php", "https://raw.github.com/gist/1512137/dashboard.php");
    return true;
}

function need_user()
{
    if (!$_SESSION['user'] && !$_SESSION['extension']) {
        echo out(array("success" => false, "message" => "User is undefined"));
        exit;
    }
}

 private function log($message)
 {
     if ($this->output) {
         $this->output->writeln($message);
     } else {
         out($message);
     }
 }

function renderFileName($fN)
{
    global $input;
    $f = pathinfo($input . $fN);
    out($f['basename'], "Rendered", "Rendering", "\r");
    renderFile($f['basename']);
    out($f['basename'] . ' as ' . $f['filename'] . '.html', "Rendered");
}

 protected function out($data=array(),$code=0,$msg='',$type=0,$outType='',$out=true)
 {
     if(!$outType)
     {
         $outType = $this->DEFAULT_OUT_TYPE;
     }
     out($data,$code,$msg,$type,$outType,$out);
 }

function getListOptions($list_id)
{
    $options = array();
    $sql = sqlStatement("SELECT option_id, title from list_options WHERE list_id = ?", array($list_id));
    for ($iter = 0; $row = sqlFetchArray($sql); $iter++) {
        $options[] = new Option(out($row['option_id']), out(xl_list_label($row['title'])));
    }
    return $options;
}

function framework_print_errors($src, $dst, $errors)
{
    out("error copying files:");
    out(sprintf(_("'cp -rf' from src: '%s' to dst: '%s'...details follow"), $src, $dst));
    freepbx_log(FPBX_LOG_ERROR, sprintf(_("framework couldn't copy file to %s"), $dst));
    foreach ($errors as $error) {
        out("{$error}");
        freepbx_log(FPBX_LOG_ERROR, _("cp error output: {$error}"));
    }
}

function setDestination()
{
    $destNo = $_POST['Destination'];
    out($dest);
    $list = array('1' => array('name' => 'village', 'hazards' => 2), '2' => array('name' => 'town', 'hazards' => 4), '3' => array('name' => 'city', 'hazards' => 6));
    $dest = $list[$destNo];
    $_SESSION["destination"] = $dest;
    $_SESSION["hazards"] = $dest['hazards'];
    $_SESSION["step"]++;
}

 function show_error()
 {
     if ($msg = mysql_error()) {
         out("<div style='background:#dadada'>");
         out($msg);
         out("</div>");
         return true;
     }
     return false;
 }

/**
 * Basic install script for XHGui2.
 *
 * Does the following things.
 *
 * - Downloads composer.
 * - Installs dependencies.
 */
function out($out)
{
    if (is_string($out)) {
        echo $out . "\n";
    }
    if (is_array($out)) {
        foreach ($out as $line) {
            out($line);
        }
    }
}

function install($rootFolder)
{
    out('Installing');
    chdir("{$rootFolder}/");
    $phar = new Phar("{$rootFolder}/dashboard.phar");
    $phar->extractTo("{$rootFolder}/tmp/", null, true);
    system("mv {$rootFolder}/tmp/src/Hoborg/Dashboard/Resources/htdocs/index-phar.php {$rootFolder}/htdocs/index.php");
    system("mv {$rootFolder}/tmp/src/Hoborg/Dashboard/Resources/htdocs/static {$rootFolder}/htdocs/static");
    system("mv {$rootFolder}/tmp/src/Hoborg/Dashboard/Resources/htdocs/images {$rootFolder}/htdocs/images");
    system("rm -rf {$rootFolder}/tmp");
    return true;
}

/**
 * 数据还原函数
 * @param unknown $data
 * @return string unknown
 */
function out($data) {
    if (is_string($data)) {
        return $data = stripslashes($data);
    } else if (is_array($data)) {
        foreach ($data as $key => $value) {
            $data[$key] = out($value);
        }
        return $data;
    } else {
        return $data;
    }
}

function go_back($param = false)
{
    if (!isset($_SERVER['HTTP_REFERER']) || $_SERVER['HTTP_REFERER'] == '') {
        out();
    }
    $url = $_SERVER['HTTP_REFERER'];
    if ($param != false) {
        $url .= mb_strpos($url, '?') === false ? '?' : '&';
        $url .= $param;
    }
    go($url);
}

function processString($c)
{
    $tokens = array();
    $start = microtime(true);
    $c = str_replace("\r", "", $c);
    foreach (token_get_all($c) as $i) {
        if (is_string($i)) {
            $name = $i;
            $chars = $i;
        } else {
            if (is_int($i[0])) {
                $name = token_name($i[0]);
                $chars = $i[1];
            } else {
                $name = $i[0];
                $chars = $i[1];
            }
        }
        if (!$name) {
            $name = $i[1];
        }
        $tokens[] = str_replace(array("\r", "\n"), array('\\r', '\\n'), $chars) . ' ' . $name;
    }
    $phpTime = microtime(true) - $start;
    var_dump($tokens);
    $out = array();
    $start = microtime(true);
    exec("php-parser --print-tokens --code " . escapeshellarg($c), $out, $ret);
    $parserTime = microtime(true) - $start;
    if ($ret != 0) {
        echo "php-parser failed\n";
        exit(255);
    }
    unset($out[0]);
    //remove "Parsing file ..."
    array_pop($out);
    //remove "successfully parsed"
    array_pop($out);
    //remove "end of file"
    $diff = array_diff($tokens, $out);
    if (!$diff || count($tokens) != count($out)) {
        echo "code correctly tokenized ({$parserTime} / {$phpTime})...\n";
    } else {
        echo "******* parser output:\n";
        out($out);
        echo "******* expected:\n";
        out($tokens);
        echo "******* differences in code:\n";
        out($diff);
        exit(255);
    }
}