0) { echo ""; echo "<<<\n "; } for( $i=0;$i<10;$i++) { if ($start+$i*20 == $from) { echo ($start+$i*20+1)."\n"; } else { if (( $start+$i*20) > $cnt) {break;}; echo ""; echo ($start+$i*20+1)."\n "; }; } if (( $start+$i*20+20) < $cnt) { echo ""; echo ">>>\n "; } } } ?>

DATAB�ZE D�STOJN�K� A SPOLUPRACOVN�K� II. SPR�VY StB
(Boj proti vnit�n�mu nep��teli)

Hledat v d�stojn�c�ch StB
D�stojn�ci:

Filtr:
>
Hledat ve spolupracovn�c�ch StB
Filtr:
>
Typ spolupr�ce:

N�pov�da
'agent', 'B' => 'konspira�n� byt', 'T' => 'tajn� spolupracovn�k', 'D' => 'd�v�rn�k', 'R' => 'rezident' ); if (( $ag ) && ( !empty( $what ) || $field==101 )) { $fld_hash= array( '101' => '', '102' => 'jmeno', '103' => 'prijmeni', '104' => 'alias', '105' => 'cislo', '106' => 'narozen', '107' => '*'); if ($field==101) { $sWhere = "".($priznak?" where priznak='$priznak'":"");}; if ($field>101 && $field<107) { $sWhere= " where (".$fld_hash[$field]." like '$what')".($priznak?" and (priznak='$priznak')":""); } if ($field == 107) { $sWhere = " where ((jmeno like '$what') or (prijmeni like '$what') or (alias like '$what')". " or (narozen like '$what') or (cislo like '$what') or (priznak like '$what'))". ($priznak?" and (priznak='$priznak')":""); } if ( empty( $cnt )) { $sSQL = "select count(*) from agenti " . $sWhere; $vysl = mysql_query( $sSQL ); $row = mysql_fetch_row($vysl); $cnt=$row[0]; mysql_free_result($vysl); }; if (empty( $from )) { $from = 0;} if (empty( $to )) { $to = 20;} $sSQL = "select * from agenti " . $sWhere . " order by prijmeni "; $sSQL.= "LIMIT $from,".($to-$from); $vysl = mysql_query( $sSQL ); $TimeSQLEnd = time(); echo "Spolupracovn�ci
\n"; $tmpto=($to<$cnt)?$to:$cnt; echo "Zobrazuj� se z�znamy ".($from+1)." - $tmpto z celkov�ho po�tu $cnt.
\n"; echo "Dotaz trval: ". ($TimeSQLEnd - $TimeStart)." s.
"; PrintRef( $from, $to, $cnt ); ?> ". "\n"; } ?>
Po�ad� P��jmen� Jm�no Datum narozen� ��slo v reg. svazk� Kryc� jm�no Typ
".(++$poradi)."$row[0]$row[1]$row[2]$row[3]$row[4]". $typ_hash[$row[5]]."
'', '2' => 'hodnost', '3' => 'jmeno', '4' => 'narozen', '5' => 'ulice', '6' => 'mesto', '7' => '*'); if ($field==1) { $sWhere = "".($priznak?" where (priznak='$priznak')":"");}; if ($field>1 && $field<7) { $sWhere= " where (".$fld_hash[$field]." like '$what')".($priznak?" and (priznak='$priznak')":""); } if ($field == 7) { $sWhere = " where ((hodnost like '$what') or (jmeno like '$what') or (narozen like '$what')". " or (ulice like '$what') or (mesto like '$what'))". ($priznak?" and (priznak='$priznak)'":""); } if ( empty( $cnt )) { $sSQL = "select count(*) from dustojnici " . $sWhere; $vysl = mysql_query( $sSQL ); $row = mysql_fetch_row($vysl); $cnt=$row[0]; mysql_free_result($vysl); }; if (empty( $from )) { $from = 0;} if (empty( $to )) { $to = 20;} $sSQL = "select * from dustojnici " . $sWhere . " order by jmeno "; $sSQL.= "LIMIT $from,".($to-$from); $vysl = mysql_query( $sSQL ); $TimeSQLEnd = time(); echo "D�stojn�ci
\n"; $tmpto=($to<$cnt)?$to:$cnt; echo "Zobrazuj� se z�znamy ".($from+1)." - $tmpto z celkov�ho po�tu $cnt.
\n"; echo "Dotaz trval: ". ($TimeSQLEnd - $TimeStart)." s.
"; PrintRef( $from, $to, $cnt ); ?> \n"; } ?>
Po�ad� Hodnost Jm�no Rodn� ��slo Ulice M�sto
".(++$poradi)." $row[0] $row[1] $row[2] $row[3] $row[4]

Domovsk� str�nka  Registr svazk� StB  Zp�t na vyhled�v�n�
Vyrobil MarkKing s.r.o.