<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"><none selected></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"]; ?>
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"><<?php echo Language::string(650); ?> ></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" : ""; ?>
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; }