<?php
require_once './inc/func_main.php';
if (is_numeric($_REQUEST['rid']) && $usrinfo['right_text']) {
$sql_a = "SELECT * FROM " . DB_PREFIX . "c2s WHERE " . DB_PREFIX . "c2s.idsolver=" . $usrinfo['id'] . " AND " . DB_PREFIX . "c2s.idcase=" . $_REQUEST['rid'];
$res_a = MySQL_Query($sql_a);
$rec_a = MySQL_Fetch_array($res_a);
$res = MySQL_Query("SELECT * FROM " . DB_PREFIX . "cases WHERE id=" . $_REQUEST['rid']);
$rec = MySQL_Fetch_Assoc($res);
if ($usrinfo['right_text'] && ($rec['secret'] == 0 || $usrinfo['right_power'] || $rec_a['iduser'])) {
$symbolbutton = ' <a href="symbols.php">přiřadit symboly</a>';
} else {
$symbolbutton = '';
}
$res = MySQL_Query("SELECT * FROM " . DB_PREFIX . "cases WHERE id=" . $_REQUEST['rid']);
if ($rec_c = MySQL_Fetch_Assoc($res)) {
if (($rec_c['secret'] == 1 || $rec_c['deleted'] == 1) && !$usrinfo['right_power']) {
unauthorizedAccess(3, $rec_c['secret'], $rec_c['deleted'], $_REQUEST['rid']);
}
auditTrail(3, 1, $_REQUEST['rid']);
pageStart('Úprava případu');
mainMenu(3);
sparklets('<a href="./cases.php">případy</a> » <strong>úprava případu</strong>', $symbolbutton);
if ($rec['secret'] == 1 && !$usrinfo['right_power'] && !$rec_a['iduser']) {
echo '<div id="obsah"><p>Hezký pokus.</p></div>';
goto end;
}
?>
<div id="obsah">
<script type="text/javascript">
<!--
<form action="results.php" method="post"><?php
$con = mysql_connect($address, $user, $pass);
if (!$con) {
echo '<div class="alert alert-error">' . mysql_error() . '</div>';
} else {
echo '<div class="alert alert-success">Successfully Connected</div>';
}
echo '<div class="alert alert-info">You can only search one field currently</div>';
print "<center>";
mysql_select_db($database, $con);
$rows = mysql_query("SELECT DISTINCT _faction FROM characters");
print "<div class='input-prepend'>\n <span class='add-on'>Faction</span>\n <select class='span2' name='faction'>\n";
//Get a row
while ($row = MySQL_Fetch_array($rows)) {
//get a feild
for ($i = 0; $i < count($row); $i++) {
//Grab an element in the array
$array = next($row);
//A function I just learned :)
//make sure there is something in it
if ($array != "") {
//echo it
echo "<option>{$array}</option>";
}
}
}
echo "<option value='' selected='selected'> </option>";
print "</select></div>";
?>
