Exemple #1
0
        <div id="divTestContainer">
            <div align="center" style="color: red; font-weight: bold;"><noscript>Your browser does not support JavaScript!</noscript></div>
            <br/>
            <div align="center"><img src="cms/css/img/logo.png" /> v<?php 
echo Ini::$version;
?>
</div>
            <div align="center">
                <div style="display: table;">
                    <fieldset class="ui-widget-content">
                        <legend>available tests</legend>
                        <select id="selectTest" class="ui-widget-content" onchange="Concerto.selectTest()">
                            <option value="0">&lt;none selected&gt;</option>
                            <?php 
$query = array();
$sql = sprintf("SELECT `id`,`db_name` FROM `%s`.`%s`", Ini::$db_master_name, UserWorkspace::get_mysql_table());
$z = mysql_query($sql);
while ($r = mysql_fetch_array($z)) {
    $sql = sprintf("(SELECT `id`,%s as `wid`,`name` FROM `%s`.`%s` WHERE `type`=1)", $r['id'], $r['db_name'], Test::get_mysql_table());
    array_push($query, $sql);
}
$query = implode(" UNION ", $query) . " ORDER BY `name` ASC";
$z = mysql_query($query);
while ($r = mysql_fetch_array($z)) {
    ?>
                                <option value="<?php 
    echo $r['id'];
    ?>
" workspace="<?php 
    echo $r["wid"];
    ?>
Exemple #2
0
echo Language::string(679);
?>
:</td>
            <td><span class="tooltip spanIcon ui-icon ui-icon-help" title="<?php 
echo Language::string(680);
?>
"></span></td>
            <td class="fullWidth">
                <div class="horizontalMargin">
                    <select id = "selectUserWorkspaceShareDialog" class = "fullWidth ui-widget-content ui-corner-all">
                        <option value = "0">&lt;<?php 
echo Language::string(650);
?>
&gt;</option>
                        <?php 
$sql = sprintf("SELECT * FROM `%s`.`%s` WHERE `owner_id`='%s' ORDER BY `name` ASC", Ini::$db_master_name, UserWorkspace::get_mysql_table(), $owner->id);
$z = mysql_query($sql);
while ($r = mysql_fetch_array($z)) {
    $ws = UserWorkspace::from_mysql_result($r);
    $ignore = false;
    if (!$ignore) {
        ?>
                                <option value="<?php 
        echo $ws->id;
        ?>
" name="<?php 
        echo $ws->name;
        ?>
" <?php 
        echo array_key_exists("current_workspace_id", $_POST) && $_POST['current_workspace_id'] == $ws->id ? "selected" : "";
        ?>
Exemple #3
0
 public static function get_all_db()
 {
     $result = array();
     $sql = sprintf("SELECT `db_name` FROM `%s`.`%s`", Ini::$db_master_name, UserWorkspace::get_mysql_table());
     $z = mysql_query($sql);
     while ($r = mysql_fetch_array($z)) {
         array_push($result, $r['db_name']);
     }
     return $result;
 }