#!/usr/bin/perl -w use DBI; use CGI ':all'; use strict; use Time::Local; use POSIX qw(locale_h); use locale; use vars qw($opt_z); use Getopt::Std; getopts('z'); open STDERR, ">/var/tmp/errors1"; my $newsurl='http://news.chgk.info/'; my $reklama="../dimrub/db/reklama.html"; $reklama="../reklama.html" if $opt_z; my $HTMLDIR="/znatoki/dimrub/db/baza/"; my $realHTMLDIR; if ($^O =~ /win/i) { $realHTMLDIR="/html/znatoki/baza/"; } else { $realHTMLDIR="/home/znatoki/public_html/dimrub/db/baza/"; } my $usehtml=1; my $usewas=0; my $cashednumber=500; my $outputnumber=10; my ($proxyptext,$proxysstr); my $printqueries=0; my $url=url||''; my $qs=query_string; my $globaloutput; my %forbidden=(); my $debug=0; #added by R7 my $outputkvo=param('kvo') ||$outputnumber; $outputkvo=100 if $outputkvo>100; if (param('debug')) {$debug=1; $printqueries=1} *STDERR=*STDOUT if $debug; if ($url !~ /db\.chgk\.info/ && $url !~ /localhost/ && $url !~ /bilbo/) { my $u="http://db.chgk.info/cgi-bin/db.cgi?$qs"; Redirect ($u); exit; } if (!param('sstr') && param('all')) { my $destination='http://db.chgk.info/all.html'; Redirect($destination); exit; } my $thislocale; if ($^O =~ /win/i) { $thislocale = "Russian_Russia.20866"; } else { $thislocale = "ru_RU.KOI8-R"; } POSIX::setlocale( &POSIX::LC_ALL, $thislocale ); if ((uc 'а') ne 'А') {print STDERR "Koi8-r locale not installed!\n"}; my %fieldname= (0,'Question', 1, 'Answer', 2, 'Comments', 3, 'Authors', 4, 'Sources'); my %rusfieldname=('Question','Вопрос', 'Answer', 'Ответ', 'Comments', 'Комментарии', 'Authors', 'Автор', 'Sources', 'Источник','old','Старый','rus','Новый', 'chgk', 'ЧГК', 'brain', 'Брейн-ринг','game', 'Своя игра', 'ehruditka', 'Эрудитка', 'beskrylka', 'Бескрылка', 'igp', 'Интернет' ); my %searchin; my $rl=qr/[йцукенгшщзхъфывапролджэячсмитьбюё]/; my $RL=qr/[ЙЦУКЕНГШЩЗХЪЭЖДЛОРПАВЫФЯЧСМИТЬБЮЁ]/; my $RLrl=qr/(?:(?:${rl})|(?:${RL}))+/; my $l=qr/(?:(?:${RLrl})|(?:[\w\-]))+/; my $Ll=qr/(?:[A-Z])|(?:${RL})/; my %metodchar=('rus',1,'old',2); $searchin{$_}=1 foreach param('searchin'); my %TypeName=('children'=>'Д', 'game'=>'Я', 'igp'=>'И', 'chgk'=>'Ч', 'brain'=>'Б', 'beskrylka'=>'Л','ehruditka'=>'Э'); my $all=param('all'); $all=0 if lc $all eq 'no'; my ($PWD) = `pwd` if $^O!~/win/i; chomp $PWD if $PWD; my ($SRCPATH) = "/home/piataev/public_html/dimrub/src"; my ($ZIP) = "/usr/local/bin/zip"; my $DUMPFILE = "/tmp/chgkdump"; my ($SENDMAIL) = "/usr/sbin/sendmail"; my ($TMPDIR) = "/var/tmp"; my ($TMSECS) = 30*24*60*60; my (%RevMonths) = ('Jan', '0', 'Feb', '1', 'Mar', '2', 'Apr', '3', 'May', '4', 'Jun', '5', 'Jul', '6', 'Aug', '7', 'Sep', '8', 'Oct', '9', 'Nov', '10', 'Dec', '11', 'Янв', '0', 'Фев', 1, 'Мар', 2, 'Апр', 3, 'Май', '4', 'Июн', '5', 'Июл', 6, 'Авг', '7', 'Сен', '8', 'Окт', '9', 'Ноя', '19', 'Дек', '11'); my @months=('000','Jan',"Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct", "Nov","Dec"); # Determine whether the given time is within 2 months from now. sub NewEnough { my ($a) = @_; my ($year, $month, $day) = split('-', $a); $month=1 if ($month<=0); $day=1 if ($day<=0); return (time - timelocal(0, 0, 0, $day, $month -1, $year) < $TMSECS); } # Reads one question from the DB. Gets DB handler and Question ID. sub Redirect { my ($destination) = @_; print < Redirection

Redirection

It appears that your browser cannot handle redirections automatically. You can proceed to the randomly-selected page by clicking here.

EndOfHTML ; } sub GetTournament { my ($dbh, $Id) = @_; my (%Tournament, $field, @arr); return %Tournament if ($Id == 0); my ($sth) = $dbh->prepare("SELECT * FROM Tournaments WHERE Id=$Id"); $sth->execute; @arr = $sth->fetchrow; my($i, $name) = 0; foreach $name (@{$sth->{NAME}}) { $Tournament{$name} = $arr[$i++]; } $sth->finish; return %Tournament; } sub fetchquestion { my ($sth,$q,$WithTour)=@_; if ($WithTour) { ($$q{'Question'},$$q{'Answer'},$$q{'Comments'},$$q{'Authors'}, $$q{'Number'}, $$q{'Title'}, $$q{'TourTitle'}, $$q{'FileName'},$$q{'PlayedAt'},$$q{'TourNumber'}) = $sth->fetchrow; } else { ($$q{'Question'},$$q{'Answer'},$$q{'Comments'},$$q{'Authors'}, $$q{'Number'})= $sth->fetchrow; } } sub SelectQuestions { my ($dbh,$q,$WithTour) = @_; my %q=(); $_ = "QuestionId=$_" foreach @$q; my $where=join " OR ",@$q; $where||=1; $where="($where) AND Questions.ParentId=t1.Id AND t1.ParentId=t2.Id" if $WithTour; my $query; if ($WithTour) { $query="SELECT Questions.Question, Answer, Comments, Authors, Questions.Number , t2.Title, t1.Title, t2.FileName, t2.PlayedAt,t1.Number from Questions,Tournaments as t1, Tournaments as t2 WHERE $where"; } else { $query="SELECT Questions.Question, Answer, Comments, Authors, Questions.Number from Questions WHERE $where"; } my $sth; $sth=$dbh->prepare($query); $sth->execute; return $sth; } # Reads one question from the DB. Gets DB handler and Question ID. sub GetQuestion { my ($dbh, $QuestionId) = @_; my (%Question, $field, @arr); my($sth) = $dbh->prepare(" SELECT * FROM Questions WHERE QuestionId=$QuestionId "); $sth->execute; @arr = $sth->fetchrow; my($i, $name) = 0; foreach $name (@{$sth->{NAME}}) { $Question{$name} = $arr[$i++]; } $sth->finish; return %Question; } sub tourhref { my ($t,$a,$gr)=@_; my $res; if ($usehtml) { $res=$t; $res.=$a?"-a":"-q" unless $gr; $res.=".html"; $res=~s/(\#\d+)(.*)$/$2$1/; $res="$HTMLDIR$res" unless $opt_z; return $res; } else { $res=$url; $res.="?tour=$t"; $res.=$a?"?answers=1":""; return $res; } } # Gets numbers of all the questions from the given tour. sub GetTourQuestions { my ($dbh, $ParentId) = @_; my (@arr, @Questions); my ($sth) = $dbh->prepare("SELECT QuestionId FROM Questions WHERE ParentId=$ParentId order by Number"); $sth->execute; while (@arr = $sth->fetchrow) { push @Questions, $arr[0]; } $sth->finish; return @Questions; } # Returns list of children of the given tournament. sub GetTours { my ($dbh, $ParentId) = @_; my (@arr, @Tours); my ($sth) = $dbh->prepare("SELECT Id FROM Tournaments WHERE ParentId=$ParentId ORDER BY Id"); $sth->execute; while (@arr = $sth->fetchrow) { push @Tours, $arr[0]; } $sth->finish; return @Tours; } sub count { my ($dbh,$word)=@_; $word=$dbh->quote(uc $word); my $query="SELECT number from nests,nf where $word=w1 AND w2=nf.id"; my $sth=$dbh->prepare($query); $sth->execute; my @a=$sth->fetchrow; $sth->finish; $a[0]||0; } sub printform { my $qnumber=(" "x10)."Выводить по "; #textfield(-name=>'kvo', # -default=>6, # -size=>3, # -maxlength=>5)." вопросов"; my $sstr=param('sstr'); my @df=keys %searchin; my %checked; $checked{lc $_}="" foreach ('Question','Answer','Comments','Authors','Sources','old','rus', 'chgk','brain','igp','game','ehruditka','beskrylka'); @df=('Question', 'Answer') unless @df; $checked{lc $_}="checked" foreach @df; my $fields=checkbox_group('searchin',['Question','Answer','Comments','Authors','Sources'], [@df], 'false',\%rusfieldname); @df=param('type'); @df=('chgk','brain','igp','game','ehruditka','beskrylka') unless @df; $checked{lc $_}="checked" foreach @df; my $all=param('all') && param('all') eq 'yes'; $checked{'all'}=$all?"checked":""; $checked{'any'}=$all?"":"checked"; $checked{lc param('metod')}="checked"; $checked{'rus'}=1 unless $checked{'rus'} || $checked{'old'}; ################################################# return <

Поиск в базе вопросов

$qnumber

Вариант поиска: Простой (старый)  "Что? Где? Когда?"  "Брейн-Ринг"  "Интернет"
 "Своя игра"  "Эрудитка"  "Бескрылка"
Расширенный (с учетом грамматики, в вопросах всех типов)
Искать: Все слова Любое слово
Поля для поиска: Вопрос Ответ
 Комментарии
 Автор
 Источник
EOT .endform .hr } sub proxy { my ($dbh,$ptext,$allnf)=@_; my $sstr=makeproxysstr($dbh,$ptext,$allnf); return russearch($dbh,$sstr,0,$allnf); } sub makeproxysstr { my ($dbh,$ptext)=@_; my $text=$$ptext; $text=~tr/ёЁ/еЕ/; $text=~s/(${RLrl})p(${RLrl})/$1p$2/gom; $text=~s/p(${RLrl})/р$1/gom; $text=~s/(${RLrl})p/$1р/gom; $text=~s/\s+/ /gmo; $text=~s/[^йцукенгшщзхъфывапролджэячсмитьбюЙЦУКЕНГШЩЗХЪФЫВАПРОЛДЖЭЯЧСМИТЬБЮQWERTYUIOPASDFGHJKLZXCVBNM0-9]/ /g; $text=uc $text; my @list= $text=~m/(?:(?:${RLrl})+)|(?:[A-Za-z0-9]+)/gom; my (%c, %good,$sstr); foreach (@list) { $c{$_}=count($dbh,$_)||10000; } my @words=sort {$c{$a}<=> $c{$b}} @list; # $good{$words[$_]}=1 foreach 0..4; foreach (@words) { $good{$_}=1 if $c{$_}<200; } $good{$words[$_]}=0 foreach 16..$#words; $sstr.=" $_" foreach grep {$good{$_}} @list; $$ptext=$sstr; return $sstr; } sub russearch { my ($dbh, $sstr, $all,$allnf)=@_; my (@qw,@w,@tasks,$qw,@arr,$nf,$sth,@nf,$w,$where,$e,@where,%good,$i,%where,$from); my($number,@good,$t,$task,@rho,$rank,%rank,$r2,$r1,$word,$n,@last,$good,@words,%number,$taskid); my ($hi, $lo, $wordnumber,$query,$blob,$field,$sf,$ii); my @frequence; my (@arr1,@ar,@sf,@arr2); my %tasks; my $tasks; my @verybad; my %nf; my %tasksof; my %wordsof; my %relevance; my @blob; my %count; $sstr=~tr/йцукенгшщзхъфывапролджэячсмитьбю/ЙЦУКЕНГШЩЗХЪФЫВАПРОЛДЖЭЯЧСМИТЬБЮ/; @qw=@w =split (' ', uc $sstr); #----------- foreach $i (0..$#w) # заполняем массив @nf начальных форм # $nf[$i] -- ссылка на массив возможных # начальных форм словоформы $i { $qw= $dbh->quote (uc $w[$i]); $query=" select distinct w2 from nests where w1=$qw"; $sth=$dbh -> prepare($query); $sth -> execute; @{$nf[$i]}=(); while (@arr = $sth->fetchrow) { push (@{$nf[$i]},$arr[0]) } $sth->finish; } my @bad=grep {!@{$nf[$_]}} 0..$#w; # @bad -- номера словоформ, # которых нет в словаре if (@bad) #есть неопознанные словоформы { require "cw.pl"; foreach $i(@bad) { if (@arr=checkword($dbh,$w[$i])) {push (@{$nf[$i]}, @arr);} else {push (@verybad,$i);} } } return () if ($all && @verybad); my $kvo=0; push @$allnf, @{$_} foreach @nf; foreach $i (0..$#w) #запросы в базу... { @arr=@{$nf[$i]} if $nf[$i]; @arr2=@arr1=@arr; $_= " word2question.word=$_" foreach @arr; $_= " nf.id=".$_. ' ' foreach @arr1; # @arr=(0) unless @arr; $query="select questions from word2question where (". (join ' OR ', @arr).") AND length(questions)<80000"; $sth=$dbh -> prepare($query); $sth->execute; @blob=(); while (@arr=$sth->fetchrow) { @blob=(@blob,unpack 'C*',$arr[0]); } $sth->finish; $query="select number from nf where ".(join ' OR ', @arr1); $sth=$dbh -> prepare($query); $sth->execute; while (@arr=$sth->fetchrow) { $frequence[$i]+=$arr[0]; } $sth->finish; if (@blob < 4) { $tasksof{$i}=undef; } else { $kvo++; $ii=0; while ($ii<$#blob) # создаём хэш %tasksof, ключи которого -- # номера искомых словоформ, а значения -- # списки вопросов, в которых есть соответствующа # словоформа. # Каждый список в свою очередь также оформлен в # виде хэша, ключи которого -- номера вопросов, # а значения -- списки номеров вхождений. Вот. { ($field,$lo,$hi,$wordnumber)=@blob[$ii..($ii+3)]; $ii+=4; my $addnumber=($field >> 4) << 16; $number=(($field >> 4) << 16)+($hi << 8) + $lo; $field=$fieldname{$field & 0xF}; if ($searchin{$field}) { push @{$tasksof{$i}{$number}}, $wordnumber; # дополнили в хэше, висящем на # словоформе $i в %tasksof список # вхождений $i в вопрос $number. push @{$wordsof{$number}{$i}}, $wordnumber; # дополнили в хэше, висящем на # вопросе $number в %wordsof список # вхождений $i в вопрос $number. } } #while ($ii<$#blob) } } #foreach $i #Ищем пересечение или объединение списков вопросов (значений %tasksof) foreach $sf (keys %tasksof) { $count{$_}++ foreach keys %{$tasksof{$sf}}; } @tasks= ($all ? (grep {$count{$_}==$kvo} keys %count) : keys %count) ; ############ Сортировка найденных вопросов foreach (keys %wordsof) { $relevance{$_}=&relevance($#w,$wordsof{$_},\@frequence) if $_ } @tasks=sort {$relevance{$b}<=>$relevance{$a}} @tasks; ############ return @tasks; } sub distance { # на входе -- номера словоформ и ссылки на # списки вхождений. На выходе -- расстояние, # вычисляемое по формуле min(|b-a-pb+pa|) # pb,pa # (pb и pa -- позиции слов b и a) my ($a,$b,$lista,$listb)=@_; my ($pa,$pb,$min,$curmin); $min=10000; foreach $pa (@$lista) { foreach $pb (@$listb) { $curmin=abs($b-$a-$pb+$pa); $min= $curmin if $curmin<$min; } } return $min; } sub relevance { # На входе -- количество искомых словоформ -1 и # ссылка на hash, ключи которого -- # номера словоформ, а значения -- списки вхождений my ($n,$words,$frequence)=@_; my $relevance=0; my ($first,$second,$d); foreach $first (0..$n) { $relevance+=scalar @{$$words{$first}}+1000+1000/$$frequence[$first] if $$words{$first}; foreach $second ($first+1..$n) { $d=&distance($first,$second,$$words{$first},$$words{$second}); $relevance+=($d>10?0:10-$d)*10; } } return $relevance; } # Returns list of QuestionId's, that have the search string in them. sub Search { my ($dbh, $s,$metod,$all,$allnf) = @_; my $sstr=$$s; my (@arr, @Questions, @fields); my (@sar, $i, $sth,$where,$query); if ($metod eq 'rus') { my @tasks=russearch($dbh,$sstr,$all,$allnf); return @tasks } elsif ($metod eq 'proxy') { my @task=proxy($dbh,$s,$allnf); return @task } ###Simple and advanced query processing. Added by R7 if ($metod eq 'simple' || $metod eq 'advanced') { foreach (qw/Question Answer Sources Authors Comments/) { if (param($_)) { push @fields, $_; } } @fields=(qw/Question Answer Sources Authors Comments/) unless scalar @fields; my $fields=join ",", @fields; my $q=new Text::Query($sstr, -parse => 'Text::Query::'. (($metod eq 'simple') ? 'ParseSimple':'ParseAdvanced'), -solve => 'Text::Query::SolveSQL', -build => 'Text::Query::BuildSQLMySQL', -fields_searched => $fields); $where= $$q{'matchexp'}; $query= "SELECT Questionid FROM Questions WHERE $where"; $sth = $dbh->prepare($query); } else ###### { # foreach (qw/Question Answer Sources Authors Comments/) { foreach (param('searchin')) { # if (param($_)) { push @fields, "IFNULL($_, '')"; # } } @sar = split " ", $sstr; for $i (0 .. $#sar) { $sar[$i] = $dbh->quote("%${sar[$i]}%"); } $_.=' ' foreach (@fields); # Это чтобы последнее слово поля # не сливалось с первым словом # следующего поля, R7 my($f) = "CONCAT(" . join(',', @fields) . ")"; if (param('all') eq 'yes') { $sstr = join " AND $f LIKE ", @sar; } else { $sstr = join " OR $f LIKE ", @sar; } my $query; $query="SELECT QuestionId FROM Questions WHERE ($f LIKE $sstr) AND (".&makewhere.") ORDER BY QuestionId"; $sth = $dbh->prepare($query) } #else -- processing old-style query (R7) $sth->execute; while (@arr = $sth->fetchrow) { push @Questions, $arr[0] unless $forbidden{$arr[0]}; } $sth->finish; return @Questions; } sub makewhere { my @type=param('type'); my $type=''; $type .= ($_=$TypeName{$_}) foreach @type; my $where=' 0 '; foreach (@type) { $where.= " OR (Type ='$_') OR (Type ='$_Д') "; } $where.= "OR (Type='ЧБ')" if ($type=~/Ч|Б/); return $where; } # Substitute every letter by a pair (for case insensitive search). my (@letters) = qw/аА бБ вВ гГ дД еЕ жЖ зЗ иИ йЙ кК лЛ мМ нН оО пП рР сС тТ уУ фФ хХ цЦ чЧ шШ щЩ ьЬ ыЫ эЭ юЮ яЯ/; sub NoCase { my ($sstr) = shift; my ($res); if (($res) = grep(/$sstr/, @letters)) { return "[$res]"; } else { return $sstr; } } sub PrintList { my ($dbh,$Questions,$shablon,$was)=@_; my $Output; my $first=param('first') ||1; $first=$first-($first-1)%$outputkvo; my $fkvo=param('fkvo')||($#$Questions+1); my $last=$first+$outputkvo-1; $last=$fkvo if $fkvo<$last; my($f,$l); my $nav=''; my $qs=query_string; $qs=~s/\;/\&/g; $qs=~s/\&first\=[^\&]+//g; my $sstr=param('sstr')||''; $qs=~s/sstr=[^\&]+/sstr=$sstr/; if ($usewas) { $qs=~s/\&was=[^\&]+//; $qs.="&was=$was" if $was; $qs.="&fkvo=$fkvo" if $was; } if ($first>$outputkvo*3+1) { $nav.= (" "x4). a({href=>$url."?".$qs."\&first=1"},"<<").(" "x4). a({href=>($url."?".$qs."\&first=".($first-$outputkvo))},"<").(" "x4) } else {$nav.=' 'x15;} my ($fprint,$lprint); my $llprint=$fkvo- ($fkvo)%$outputkvo+1; # if ($fkvo<=$outputkvo*7) { $fprint=1; $lprint=$llprint; } elsif ($first>$outputkvo*3 && $fkvo-$first>$outputkvo*3) { $fprint=$first-$outputkvo*3; $lprint=$first+$outputkvo*3; } elsif ($first<=$outputkvo*3) { $fprint=1; $lprint=6*$outputkvo+1; } else { $lprint=$llprint; $fprint=$lprint-$outputkvo*6 } # my $fprint=($first>$outputkvo*3) ? $first-$outputkvo*3 : 1; # my $lprint=$#$Questions+1-$fprint>$outputkvo*7 ? $outputkvo*7 :$#$Questions+1; # if ($lprint-$fprint<$outputkvo*6 && $fprint>1) # { # $fprint=$lprint-$outputkvo*6; # $fprint=1 if ($fprint<=0) # } for($f=$fprint; $f<=$lprint; $f+=$outputkvo) { # next if $first-$f>$outputkvo*3; $l=$f+$outputkvo-1; $l=$fkvo if $l>$fkvo+1; if ($f==$first) {$nav.="[$f-$l] ";} else { $nav.= "[".a({href=>($url."?".$qs."\&first=$f")},"$f-$l")."] ";} } if ($lprint+$outputkvo<$fkvo) { $nav.= (" "x4). a({href=>($url."?".$qs."\&first=".($first+$outputkvo))},">").(" "x4). a({href=>$url."?".$qs."\&first=$llprint"},">>").(" "x4) } $Output.= "$nav".br."\n"; my @q=@$Questions[$first-1..$last-1]; my %q=(); my $sth=SelectQuestions($dbh,\@q,1); for (my $i = $first; $i <= $last; $i++) { fetchquestion($sth,\%q,1); my $output; $output = &PrintQuestion($dbh, \%q, 1, 0, 1,0,1 ); if (param('metod') && (param('metod') eq 'rus' || param('metod') eq 'proxy')) { $output=~s/\b($shablon)\b/\$1\<\/strong\>/gi; } else { $output=~s/($shablon)/\$1\<\/strong\>/gi; } $Output.= $output; } $sth->finish; $Output.= "$nav".br."\n"; return $Output; } sub PrintSearch { my $Output=''; my ($dbh, $sstr, $metod,$was) = @_; my $t=time; $Output.= printform; my @allnf; my @Questions; $was=0 if $metod eq 'proxy'; if ($usewas && $was && ($metod ne 'proxy')) { my $sth=$dbh->prepare ("select sstr,questions,allnf from lastqueries where id=".param('was')); $sth->execute; my ($q,$nf); ($sstr, $q,$nf)=($sth->fetchrow); @Questions=unpack 'L*',$q; @allnf=unpack 'L*',$nf; $sth->finish; } if (!$was || ($metod eq 'proxy') || (param('first')+$outputkvo>$cashednumber)) { @Questions=&Search($dbh, \$sstr,$metod,$all,\@allnf); $cashednumber=$#Questions if $cashednumber>$#Questions; my $tmp=$dbh->quote(pack("L*",@Questions[0..$cashednumber])); my $qsstr=$dbh->quote($sstr); my $nf=$dbh->quote(pack("L*", @allnf)); my $ss=200; if ($usewas) { do { $was=int rand(32000); } while (--$ss && (!$dbh->do ("insert into lastqueries (id,sstr,questions,allnf) values ($was, $qsstr,$tmp,$nf)"))); $Output.= "Something is wrong...".br unless $ss; } } $Output.= p. "Время поиска: " . (time-$t) ." сек.".p; my ($output, $i, $suffix, $hits) = ('', 0, '', $#Questions + 1); my $shablon; $metod='rus' if $metod eq 'proxy'; if ($metod eq 'rus') { my $where='0'; $where.= " or w2=$_ " foreach @allnf; my $query="select w1 from nests where $where"; my $sth=$dbh->prepare($query); $sth->execute; my @shablon; while (my @arr = $sth->fetchrow) { push @shablon,"(?:$arr[0])"; } $sth->finish; $shablon= join "|", @shablon; $shablon=~s/[её]/\[ЕЁ\]/gi; # $shablon=~s/([йцукенгшщзхъфывапролджэячсмитьбюЙЦУКЕНГШЩЗХЪФЫВАПРОЛДЖЭЯЧСМИТЬБЮ])/&NoCase($1)/ge; $shablon=qr/$shablon/i; } $hits=param("fkvo")||$hits; if ($hits =~ /1.$/ || $hits =~ /[5-90]$/) { $suffix = 'й'; } elsif ($hits =~ /1$/) { $suffix = 'е'; } else { $suffix = 'я'; } $Output.= p({align=>"center"}, "Результаты поиска на " . strong($sstr) . " : $hits попадани$suffix."); if (param('word')) { $sstr = '[ \.\,:;]' . $sstr . '[ \.\,:\;]'; } # $sstr =~ s/(.)/&NoCase($1)/ge; my @sar; if ($metod ne 'rus') { my $ss=$sstr; (@sar) = split(' ', $ss); s/(\W)/\\$1/g foreach (@sar); $shablon=join "|",@sar; } $Output.=PrintList($dbh,\@Questions,$shablon,$was); return $Output; } sub PrintRandom { my ($dbh, $type, $num, $text) = @_; my $razd=param('razd'); my %q; my $answer=$razd?0:1; my @answers; my (@Questions) = &Get12Random($dbh, $type, $num); my ($output, $i) = ('', 0); if ($text) { $output .= " $num случайных вопросов.\n\n"; } else { $output .= h2({align=>"center"}, "$num случайных вопросов."); } my $sth=SelectQuestions($dbh,\@Questions,0); for ($i = 0; $i <= $#Questions; $i++) { fetchquestion($sth,\%q,0); $output .= &PrintQuestion($dbh, \%q, $answer, $i + 1, 0, $text,1); push @answers, $q{'Answer'}; } $sth->finish; unless ($answer ) { $output.=$text?"\n".('-'x 20)."\nОтветы\n~~~~~~\n\n":h2('Ответы'); $sth=SelectQuestions($dbh,\@Questions,0); for ($i = 0; $i <= $#Questions; $i++) { # fetchquestion($sth,\%q,0); # $output .= # &PrintQuestion($dbh, \%q, -1, $i + 1, 0, $text,1); $output.=$text?("Ответ ". ($i+1).": $answers[$i]\n\n"): b("Ответ ". ($i+1).": "). $answers[$i].p; } } return $output; } sub PrintEditor { my $t=shift; #ссылка на Хэш с полями my $ed=$$t{'Editors'}||''; my $edname=($ed=~/\,/ ) ? "Редакторы" : "Редактор" ; return $ed? h4({align=>"center"},"$edname: $ed" ): ''; } sub PrintTournament { my ($dbh, $Id, $answer) = @_; my (%Tournament, @Tours, $i, $list, $qnum, $imgsrc, $alt, $SingleTour); my ($output) = ''; %Tournament = &GetTournament($dbh, $Id) if ($Id); my ($URL) = $Tournament{'URL'}; $URL=~s/http:\/znatoki\/boris\/reports\//$newsurl/ if $url=~/kulichki/; $URL=~s/\/znatoki\/boris\/reports\//$newsurl/ if url=~/kulichki/;; my ($Info) = $Tournament{'Info'}; my ($Copyright) = $Tournament{'Copyright'}; my $fname=$Tournament{'FileName'}; @Tours = &GetTours($dbh, $Id); $list=''; my $textid; if ($Id) { for ($Tournament{'Type'}) { /Г/ && do { $output .= h2({align=>"center"}, "Группа: $Tournament{'Title'} ", $Tournament{'PlayedAt'}||'') . p . "\n"; last; }; /Ч/ && do { return &PrintTour($dbh, $Tours[0], $answer) if ($#Tours == 0); my $title="Пакет: $Tournament{'Title'}"; if ($Tournament{'PlayedAt'}) { $title .= " $Tournament{'PlayedAt'}"; } $output .= h2({align=>"center"}, "$title") . p . "\n"; $output.=&PrintEditor(\%Tournament); last; }; /Т/ && do { return &PrintTour($dbh, $Id, $answer); }; } } else { my ($qnum) = GetQNum($dbh); $output .= h2("Банк Вопросов: $qnum вопрос".&Suffix($qnum)) . p . "\n"; } for ($i = 0; $i <= $#Tours; $i++) { %Tournament = &GetTournament($dbh, $Tours[$i]); if ($Tournament{'Type'} =~ /Ч/) { $SingleTour = 0; my (@Tours) = &GetTours($dbh, $Tournament{'Id'}); $SingleTour = 1 if ($#Tours == 0); } if ($Tournament{'QuestionsNum'} > 0) { $qnum = " ($Tournament{'QuestionsNum'} вопрос" . &Suffix($Tournament{'QuestionsNum'}) . ")\n"; } else { $qnum = ''; } if ($Tournament{'Type'} !~ /[ТЧ]/) { $SingleTour=0; $imgsrc = "/icons/folder.gif"; $alt = "[*]"; } else { $imgsrc = "/icons/folder.gif"; $alt = "[-]"; } my $textid; if ($textid=$Tournament{'FileName'}) { $textid=~s/\.txt//; } elsif ($textid=$Tournament{'Number'}) { $fname=~s/\.txt//; $textid="$fname.$textid"; } else {$textid=$Tournament{'Id'}}; if ($SingleTour or ($Tournament{'Type'} =~ /Т/)) { $list .= dd(img({src=>$imgsrc, alt=>$alt}) . " " . $Tournament{'Title'} . " " . ($Tournament{'PlayedAt'}||"") . $qnum) . dl( dd("[" . a({href=>tourhref($textid,0)}, "вопросы") . "] [" . a({href=>tourhref($textid,1)}, "вопросы + ответы") . "]") ); } else { $list .= dd(a({href=> $url . "?tour=$textid&comp=1"}, img({src=>'/icons/compressed.gif', alt=>'[ZIP]', border=>1})). " " . img({src=>$imgsrc, alt=>$alt}) . " " . a({href=>tourhref($textid,0,1)}, $Tournament{'Title'}. " ". ($Tournament{'PlayedAt'}||'')) . $qnum); } } $output .= dl($list); if ($URL) { if ($url=~/zaba\.ru/ && $URL=~/^\//){$URL="http://info.chgk.info$URL"} $output .= p("Дополнительная информация об этом турнире - по адресу " . a({-'href'=>$URL}, $URL)); } if ($Copyright) { $output .= p("Копирайт: " . $Copyright); } if ($Info) { $output .= p($Info); } return $output; } sub Suffix { my ($qnum) = @_; my ($suffix) = 'а' if $qnum =~ /[234]$/; $suffix = '' if $qnum =~ /1$/; $suffix = 'ов' if $qnum =~ /[567890]$/ || $qnum =~ /1.$/; return $suffix; } sub IsTour { my ($dbh, $Id,$n) = @_; my ($sth) ; if (defined $n) { $sth=$dbh->prepare ("select Id FROM Tournaments WHERE ParentId=$Id AND Number=$n"); } else { $sth=$dbh->prepare("SELECT Id FROM Tournaments WHERE Id=$Id"); } $sth->execute; my $a=($sth->fetchrow)[0]; $sth->finish; return $a; } # Gets a DB handler (ofcourse) and a tour Id. Prints all the # question of that tour, according to the options. sub PrintTour { my ($dbh, $Id, $answer) = @_; my ($output, $q, $bottom, $field) = ('', 0, '', ''); my (%Tour) = &GetTournament($dbh, $Id); my (@Tours) = &GetTours($dbh, $Tour{'ParentId'}); my (%Tournament) = &GetTournament($dbh, $Tour{'ParentId'}); my %q; return 0 if ($Tour{'Type'} !~ /Т/); my ($fname)=$Tournament{'FileName'}; $fname=~s/\.txt//; my ($qnum) = $Tour{'QuestionsNum'}; my ($suffix) = &Suffix($qnum); $output .= h2({align=>"center"}, $Tournament{"Title"}, $Tournament{'PlayedAt'}||'', "
", $Tour{"Title"} . " ($qnum вопрос$suffix)\n") . p; $output .=&PrintEditor(\%Tour); my (@Questions) = &GetTourQuestions($dbh, $Id); my $sth=SelectQuestions($dbh,\@Questions,0); for ($q = 0; $q <= $#Questions; $q++) { fetchquestion($sth,\%q,0); $output .= &PrintQuestion($dbh, \%q, $answer, 0,0,0,1); } $sth->finish; $output .= hr({-'align'=>'center', -'width'=>'80%'}); if ($Tournament{'URL'}) { $output .= p("Дополнительная информация об этом турнире - по адресу " . a({-'href'=>$Tournament{'URL'}}, $Tournament{'URL'})); } if ($Tournament{'Copyright'}) { $output .= p("Копирайт: " . $Tournament{'Copyright'}); } if ($Tournament{'Info'}) { $output .= p($Tournament{'Info'}); } my $n=$Tour{'Number'}; if ($answer == 0) { $bottom .= "[" . a({href=>tourhref($fname,1)}, "ответы") . "] " . br; } if ($n>1) { $bottom .= "[" . a({href=>tourhref("$fname.".($n-1),0)}, "предыдущий тур") . "] "; $bottom .= "[" . a({href=>tourhref("$fname.".($n-1),1)}, "предыдущий тур с ответами") . "] " . br; } if (&IsTour($dbh, $Tour{'ParentId'}, $n + 1)) { $bottom .= "[" . a({href=>tourhref("$fname.".($n+1),0)}, "следующий тур") . "] "; $bottom .= "[" . a({href=>tourhref("$fname.".($n+1),1)}, "следующий тур с ответами") . "] "; } $output .= p({align=>"center"}, font({size=>-1}, $bottom)); return $output; } sub PrintField { my ($header, $value, $text) = @_; if ($text) { $value =~ s/<[\/\w]*?>//sg; } else { $value =~ s/^\s+/
    /mg; $value =~ s/^\|([^\n]*)/

$1<\/pre>/mg;
	    $value =~ s/\s+-+\s+/ – /mg;
	    $value =~ s/(http:\/\/\S+[^\s\)\(\,\.])/$1<\/a>/g if $header !~ /^Авто/;
#	    $value =~ s/(http:\/\/(?:\w+.)+[\w\\\~]+(\?[^\s.]+)?)/$1<\/a>/g if $header !~ /^Авто/;
#	    $value =~ s/(\s)"/$1“/mg;
#	    $value =~ s/^"/“/mg;
#	    $value =~ s/"/”/mg;
	}


	return $text ? "$header:\n$value\n\n" :
		strong("$header: ") . $value . p . "\n";
}

# Gets a DB handler (ofcourse) and a question Id. Prints
# that question, according to the options.
sub PrintQuestion {
	my ($dbh, $Id, $answer, $qnum, $title, $text,$h) = @_;
	my ($output, $titles) = ('', '');
	my (%Question);
	if ($h) {
	  %Question=%$Id;
	} else {
		%Question = &GetQuestion($dbh, $Id);
		if ($title) {
			my (%Tour) = GetTournament($dbh, $Question{'ParentId'});
			my (%Tournament) = GetTournament($dbh, $Tour{'ParentId'});
			$Question{'FileName'}=$Tournament{'FileName'};
			$Question{'Title'}=$Tournament{'Title'};
			$Question{'PlayedAt'}=$Tournament{'PlayedAt'};
			$Question{'TourNumber'}=$Tour{'Number'};
			$Question{'TourTitle'}=$Tour{'Title'};
		}

        }
		$qnum = $Question{'Number'}
		if ($qnum == 0);
	if (!$text) {
		$output .= hr({width=>"50%"}) if $answer>=0;
		if ($title) {
			my $fname=$Question{'FileName'};
			$fname=~s/\.txt//;
			$titles .=
				dd(img({src=>"/icons/folder.open.gif"}) . " " .
					 a({href=>tourhref($fname,0,1)}, 
                               $Question{'Title'}, $Question{'PlayedAt'}||''));
			$titles .=
				dl(dd(img({src=>"/icons/folder.open.gif"}) . " " .
					a({href=>tourhref("$fname.$Question{'TourNumber'}#$qnum",1)}, 
                          $Question{'TourTitle'})));
		}
		$output .= dl(strong($titles));
	}


	$output.= "" unless $text;

	if ($answer>=0) {$output .=
		&PrintField("Вопрос $qnum", $Question{'Question'}, $text);}
	else {$output .="$qnum. "}
	if ($answer==1|| $answer==-1) {
		$output .=
			&PrintField("Ответ", $Question{'Answer'}, $text);

		if ($Question{'Authors'} ) {
                      my $q=$Question{'Authors'};
###АВТОРА!!
# 		      my $sth=$dbh->prepare("select Authors.CharId,Name, Surname, Nicks from Authors, A2Q
#                                  where Authors.Id=Author And Question=$Id");
#                       $sth->execute;
#                       my ($AuthorId,$Name, $Surname,$other,$Nicks);
#                      if (!$text) {
#                       while ((($AuthorId,$Name, $Surname,$Nicks)=$sth->fetchrow),$AuthorId)
#                       {
#                          my ($firstletter)=$Name=~m/^./g;
#                          $Name=~s/\./\\\./g;
#                          $Name=~s/ё/[её]/g;
#                          $Surname=~s/ё/[её]/g;
#                           my $sha="(?:$Name\\s+$Surname)|(?:$Surname\\s+$Name)|(?:$firstletter\\.\\s*$Surname)|(?:$Surname\\s+$firstletter\\.)|(?:$Surname)";
#                           if ($Nicks)
#                           {
#                             $Nicks=~s/^\|//;
#                             foreach (split /\|/, $Nicks)
#                             {
#                               s/\s+/ /g;
#                               s/\s+$//;
#                               s/ /\\s+/g;
#                               s/\./\\\./g;
#                               if (s/>$//) {$sha="$sha|(?:$_)"}
#                               else        {$sha="(?:$_)|$sha"}
#                             }
#                           }
#                           $q=~s/($sha)/a({href=>url."?qofauthor=$AuthorId"},$1)/ei;
#                           unless ($1) 
#                             {   
#                                 $q=~s/$Name/a({href=>url."?qofauthor=$AuthorId"},$1)/ei;
#                             }
#                       }
#                      }
			$output .= &PrintField("Автор(ы)", $q, $text);

		}

		if ($Question{'Sources'}) {
			$output .= &PrintField("Источник(и)", $Question{'Sources'}, $text);
		}

		if ($Question{'Comments'}) {
			$output .= &PrintField("Комментарии", $Question{'Comments'}, $text);
		}
	}
	elsif ($answer==2) {
	  my $text=$Question{'Answer'};
	  $text=~s/\n/