예제 #1
0
<?php

require_once "login.inc.php";
?>

<?php 
require_once "conn_dialogix.php";
$query = "\n\tSELECT ID, InstrumentName, ActionPhrase, AnswerOptions, DisplayType\n\tFROM InstrumentTranslations\n\twhere ActionType != \"e\" and (LanguageName = \"en\" or LanguageName = \"en_US\") and InstrumentTranslations.DisplayType != \"nothing\"\n\torder by ActionPhrase, AnswerOptions, DisplayType\n\tLIMIT 0,200";
$res = mysql_query($query);
if (!$res) {
    DialogixError("Could not successfully run query ({$sql}) from DB: " . mysql_error());
}
$num_rows = mysql_num_rows($res);
if ($num_rows == 0) {
    DialogixError("No rows found");
}
?>

<?php 
include "Dialogix_Table_PartA.php";
?>

<table border=1 width=100% align='left'>
<tr><td colspan="10" align="center"><FONT SIZE="5">rows (<?php 
echo "{$num_rows}";
?>
)</FONT></td></tr>
<tr>
	<td><b>#</b></td>
	<td><b>Survey Question Text</b></td>
	<td><b>Answer List</b></td>	
예제 #2
0
        }
        $statusMessage .= "({$query}) succeeded<br>";
        if (mysql_num_rows($dbq) == 1) {
            $r = mysql_fetch_assoc($dbq);
            extract($r);
            $time = time();
            if ($time - $LastAccess > 600) {
                $session_timedout = 1;
                $statusMessage .= "Session Timedout!<br>";
            } else {
                $_COOKIE['dgx_authenticated'] = 1;
                $_COOKIE['dgx_username'] = $sidarray[0];
                $statusMessage .= "Successfully Authenticated!<br>";
                $query = "update AuthenticatedUsers set LastAccess={$time} where UserID='{$sidarray['0']}'";
                if (!($dbq = mysql_query($query))) {
                    DialogixError("Unable to update database" . mysql_error());
                }
            }
        }
    } else {
        $statusMessage .= "Could not find cookie<BR>";
    }
}
if (!($_COOKIE['dgx_authenticated'] == 1)) {
    include "Dialogix_Table_PartA.php";
    //	echo "$statusMessage\n";
    $php_self = $_SERVER['PHP_SELF'];
    echo "<Form Action='{$php_self}' METHOD=POST>";
    echo "<DIV ALIGN='center'>";
    echo "<H1>Dialogix Management Interface</H1>";
    if ($session_timedout == 1) {