meta-status;<?php // this status.php file tells publite2 about the number of available freeciv-web servers in the metaserver. ini_set("include_path", ini_get("include_path") . ":" . $_SERVER["DOCUMENT_ROOT"]); include_once "php_code/settings.php"; if ($error_msg != NULL) { $config_problem = true; } if (!$config_problem) { include_once "php_code/php_code_find.php"; // includes for support routines include_once php_code_find("fcdb.php"); include_once php_code_find("versions_file.php"); include_once php_code_find("img.php"); include_once php_code_find("html.php"); fcdb_metaserver_connect(); } $stmt = "select count(*) as count from servers UNION ALL select count(*) as count from servers where " . "type = 'singleplayer' and state = 'Pregame' and stamp >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) " . "UNION ALL select count(*) as count from servers where type = 'multiplayer' and state = 'Pregame' and stamp >= DATE_SUB(NOW(), INTERVAL 1 MINUTE)"; $res = fcdb_exec($stmt); $nr = fcdb_num_rows($res); if ($nr != 3) { print "error"; } else { $row = fcdb_fetch_array($res, 0); print db2html($row["count"]); print ";"; $row = fcdb_fetch_array($res, 1); print db2html($row["count"]); print ";"; $row = fcdb_fetch_array($res, 2); print db2html($row["count"]); }
<td><b>Supported</b> <td><b>Comment</b> <? $res=pg_exec("select * from version where productid=".$prod["productid"]." order by version"); $ln=pg_numrows($res); for($i=0;$i<$ln;$i++){ $ar=pg_fetch_array($res,$i); print("<tr>"); print("<td>".db2html($ar["version"])); print("<td>".$ar["costs_initial"]); print("<td>".$ar["costs_fix"]); print("<td>".$ar["costs_bytime"]."/".$ar["costs_timeframe"]); print("<td>".($ar["supported"]?"yes":"no")); print("<td>".db2html($ar["comment"])); print("</tr>\n"); } pg_freeresult($res); ?> </table><br> [<? print("<a href=\"version.php?newversion=1&product=".$prod["productid"]."\">New Version</a>"); ?>]<p> <? if(isset($HTTP_VARS["newversion"])){ ?> <h2>New Version</h2> <form action="version.php" method="POST">
} $lower_fixed = 1; } $upper_bound = $lid; } ?> <body> <?php // TEXT ____________________ if ($mode != 'nest') { $segs = "SELECT * FROM {$table} WHERE audio_file = '{$audio_file}' AND id >= {$lower_bound} AND id <= {$upper_bound}"; $segs = mysql_query($segs); $stringy = db2html($segs); print "<div class=\"txt\">" . $stringy . "</div>"; //print $divs; } if ($mode == 'nest') { ?> <div class="iframe"> <iframe name="text" frameborder="0" width="525" height="256" scrolling="auto" src=<?php echo "\"?line_key={$id}&corpus={$corpus}&size={$size}&mode=text\""; ?> > </iframe> </div> <?php } // !TEXT ____________________
<table frame="1" border="1"> <tr> <td><b>Product</b> <td><b>Version</b> <td><b>License</b> <td><b>Status</b> <? $res=pg_exec("select * from product,version,license,status where ". "product.productid=version.productid AND ". "version.versionid=license.versionid AND ". "status.statusid=license.statusid AND ". "license.adminid='".$user->getusername()."' ". "ORDER BY product.product,version.version,status.status"); $ln=pg_numrows($res); for($i=0;$i<$ln;$i++){ $ar=pg_fetch_array($res,$i); print("<tr>"); print("<td>".db2html($ar["product"])); print("<td>".db2html($ar["version"])); print("<td>".db2html($ar["licensenumber"])); print("<td>".db2html($ar["status"])); print("</tr>\n"); } pg_freeresult($res); ?> </table> <? printfooter() ?>