$stat=pg_fetch_array($stati,$i);
$amtr=pg_exec("select count(licenseid) from license where adminid='".$user->getusername()."' and statusid=".$stat["statusid"]);
$amt=pg_result($amtr,0,0);
pg_freeresult($amtr);
print("<tr><td><font color=\"".$stat["colordef"]."\">".($amt>0?"<b>":"").$stat["status"].($amt>0?"</b>":"")."</font><td>");
print($amt."</tr>\n");
}
pg_freeresult($stati);
?>
</table>
<h2>Expirations</h2>
(yet not working)<p>
<table frame=1 border=1>
<tr>
<td><b>Product</b>
<td><b>Version</b>
<td><b>Licensenumber</b>
<td><b>Possessor</b>
</table>
<?
printfooter();
?>
function makeCaptions($new_captions)
{
global $baseURL, $scriptPath, $dir, $jheadBinary;
# If there are new captions
if (!empty($new_captions)) {
# Get the old captions
$captions = get_captions(true);
# Append new captions to those already there
foreach ($new_captions as $i => $c) {
# Base 64 was the best way (I thought of) of dealing with oddly named images in the input form.
$captions[base64_decode($i)][] = trim($c);
# If the jhead binary is executable.
if (is_executable($jheadBinary)) {
setExifCaption(base64_decode($i), trim($c));
}
}
# Write the captions to disk.
@file_put_contents($scriptPath . "cache/" . $dir . "captions.txt", serialize($captions));
# If the function was called from AJAX... (Only one update at a time).
if (count($new_captions) == 1) {
exit;
}
}
$captions = get_captions();
$folder_scan_results = folder_scan();
$images_with_thumbs = images_with_thumbnails($folder_scan_results['images']);
foreach ($images_with_thumbs as $idx => $image) {
if (!array_key_exists($image, $captions)) {
$captions[$image] = getExifCaption($image);
}
}
/*
Ajax Function. Compressed version of "The Ultimate Ajax Object"
http://www.hunlock.com/blogs/The_Ultimate_Ajax_Object
*/
$title = "Captions: " . $dir;
if (function_exists("printheader")) {
printheader($title);
} else {
html_header($title);
}
?>
<script type="text/javascript">
function ajaxObject(b,a){var c=this;this.updating=false;this.abort=function(){if(c.updating){c.updating=false;c.AJAX.abort();c.AJAX=null}};this.update=function(g,e){if(c.updating){return false}c.AJAX=null;if(window.XMLHttpRequest){c.AJAX=new XMLHttpRequest()}else{c.AJAX=new ActiveXObject("Microsoft.XMLHTTP")}if(c.AJAX==null){return false}else{c.AJAX.onreadystatechange=function(){if(c.AJAX.readyState==4){c.updating=false;c.callback(c.AJAX.responseText,c.AJAX.status,c.AJAX.responseXML);c.AJAX=null}};c.updating=new Date();if(/post/i.test(e)){var f=d+"?"+c.updating.getTime();c.AJAX.open("POST",f,true);c.AJAX.setRequestHeader("Content-type","application/x-www-form-urlencoded");c.AJAX.setRequestHeader("Content-Length",g.length);c.AJAX.send(g)}else{var f=d+"?"+g+"×tamp="+(c.updating.getTime());c.AJAX.open("GET",f,true);c.AJAX.send(null)}return true}};var d=b;this.callback=a||function(){}};
// Update the caption. Setup to be called in an 'on change' so that all the comments are saved automatically
// and Submit doesn't need to be pressed.
function updateCaption(object) {
var myRequest = new ajaxObject("<?php
echo rrawurlencode($baseURL . "captions/" . $dir);
?>
");
myRequest.update(encodeURIComponent(object.name)+"="+encodeURIComponent(object.value),"POST");
//location.reload();
}
</script>
<a href="<?php
echo rrawurlencode($baseURL . $dir);
?>
">Return To Gallery</a>
<form action="<?php
echo rrawurlencode($baseURL . "captions/" . $dir);
?>
" method="POST">
<table>
<tr>
<td align="right">
Album Title:
</td>
<td>
<input type="text" name="<?php
echo base64_encode('title');
?>
" id="title" size="20" value="<?php
echo $captions['title'];
?>
" tabindex="1" onchange="updateCaption(this)">
</td>
</tr>
<?php
if (count($images_with_thumbs)) {
foreach ($images_with_thumbs as $idx => $image) {
$pictures .= "\t<tr><td align=\"right\">";
$pictures .= "<a href=\"" . rrawurlencode($baseURL . $dir . $image) . "\"><img src=\"" . rrawurlencode($baseURL . "cache/" . $dir . "preview/" . $image) . "\" alt=\"" . htmlentities($image) . "\"></a>";
$pictures .= "</td><td valign=\"bottom\"><textarea id=\"caption{$idx}\" name=\"" . base64_encode($image) . "\" rows=\"20\" cols=\"30\" tabindex=\"" . ($idx + 2) . "\" onchange=\"updateCaption(this)\">" . $captions[$image] . "</textarea></td></tr>\n";
}
}
echo $pictures;
?>
<tr>
<td colspan="2" align="center">
<input type="submit" value="Change Captions">
</td>
</tr>
</table>
</form>
<?php
if (function_exists("printfooter")) {
printfooter($title);
} else {
html_footer($title);
}
}
if (file_exists($localfile)) {
echo "<b>Or:</b><input type='checkbox' name='localfile'> use {$localfile}";
}
echo "</td>\n";
echo "<td align='center'> <table><tr>\n <td><input type='radio' name='delimiter_type' value='comma'> comma</td>\n <td><input type='radio' name='delimiter_type' value='tab' checked> tab</td>\n <td><input type='radio' name='delimiter_type' value='space'> space</td></tr>\n <tr><td><input type='radio' name='delimiter_type' value='semi-colon'> ;</td>\n <td colspan=2><input type='radio' name='delimiter_type' value='other'> other:\n <input type='text' name='delimiter' value='{$delimiter}' size='2'></td></tr>\n </table></td>\n";
echo "<td align='center'> <table><tr>\n <td><input type='radio' name='quote_type' value='doublequote'> \" </td>\n <td><input type='radio' name='quote_type' value='singlequote'> ' </td>\n <td><input type='radio' name='quote_type' value='none' checked> none</td></tr>\n <tr><td> </td></tr>\n </table></td>\n";
$query = "SELECT label,id FROM tableoftables LEFT JOIN groupxtable_display on tableoftables.id=groupxtable_display.tableid where display='Y' AND permission='Users' AND (groupid={$USER['group_array'][0]} ";
for ($i = 1; $i < sizeof($USER['group_array']); $i++) {
$query .= "OR groupid='" . $USER['group_array'][$i] . "' ";
}
$query .= ') ORDER BY sortkey';
$r = $db->Execute($query);
$menu = $r->GetMenu2('tableid', $tableid);
echo "<td>{$menu}</td>\n";
if ($permissions & $SUPER) {
$query = 'SELECT login,id FROM users ORDER By login';
$r = $db->Execute($query);
if ($r) {
$menu2 = $r->GetMenu2('ownerid', $ownerid);
}
echo "<td>{$menu2}</td>\n";
} else {
echo "<td><input type='hidden' name='ownerid' value={$USER['id']}>";
echo "{$USER['login']}</td>\n";
}
echo "</tr>\n";
echo "<tr><td colspan='4' align='center'><input type='submit' name='dataupload' value='Continue'></td></tr>\n";
echo "</table>\n";
echo "</form>\n";
printfooter($db, $USER);
/**
* presents the login screen when authenticating witth sessions
*
*/
function loginscreen($message = "<h3>Login to PhpLabWare</h3>")
{
global $_SERVER, $system_settings;
$PHP_SELF = $_SERVER['PHP_SELF'];
if ($system_settings['secure_server']) {
$server = getenv('HTTP_HOST');
if (!$server) {
$server = $_SERVER['HTTP_HOST'];
}
$addres = "https://{$server}{$PHP_SELF}";
} else {
$addres = $PHP_SELF;
}
$addres = url_get_string($addres);
// prevent cross-site scripting:
$addres = strip_xss_stuff($addres);
printheader("Login to PhpLabWare");
echo "<noscript><br><align='center'><b><div id='nojs'>Javascript is not used. Although navigation of phplabware is possible without javascript, it is not actively supported and will limit functionality drastically. Please enable JavaScript to view this page properly.</div></b></align></br></noscript>\n";
echo "<form name='loginform' method='post' action='{$addres}' onSubmit='this.javascript_enabled.value=\"true\"'>\n";
echo "<input type='hidden' name='logon' value='true'>\n";
echo "<input type='hidden' name='javascript_enabled' value='0'>\n";
echo "<table align=center>\n";
echo "<tr><td colspan=2 align='center'>{$message}</td>\n";
$imstring = randomimage("frontims");
if ($imstring) {
}
echo "<td rowspan=6>   {$imstring}</td>";
echo "</tr>\n";
echo "<tr><td>Your login name:</td>\n";
echo "<td><input name='user' size=10 value=''></td></tr>\n";
echo "<tr><td>Password:</td>\n";
echo "<td><input type='password' name='pwd' size=10 value=''></td></tr>\n";
echo "<tr><td colspan=2 align='center'>";
if ($system_settings["secure_server"]) {
echo "<input type='checkbox' name='ssl' checked>Keep a secure connection";
}
echo "</td></tr>\n";
echo "<tr><td colspan=2 align='center'>";
echo "<input type='submit' name='submit' value='Login'></td></tr>\n";
echo "<tr><td colspan=2 align='center'>";
//echo "Note: Cookies must be enabled beyond this point</td></tr>\n";
echo "</table>\n</form>\n";
printfooter();
}
<option value="posessor">Possessor <option value="licensenumber">License Number <option value="expiration">Expiration </select> <input type="checkbox" name="ascend1">Descending<br> 2. <select name="sort2"> <option value="-">None <option value="status">Status <option value="admin">Admin <option value="project">Project <option value="posessor">Possessor <option value="licensenumber">License Number <option value="expiration">Expiration </select> <input type="checkbox" name="ascend2">Descending<br> 3. <select name="sort3"> <option value="-">None <option value="status">Status <option value="admin">Admin <option value="project">Project <option value="posessor">Possessor <option value="licensenumber">License Number <option value="expiration">Expiration </select> <input type="checkbox" name="ascend3">Descending<p> <input type="submit" name="search" value="Search"> </form> <? printfooter() ?>
