0) { $ot1=51; $ot2=$uart; } $MAXOPI_ON_ROW=1; $maxopi1=30; $maxopi2=31; $maxaut1=50; $maxaut2=51; $sname1="goa.php"; //$Snm32; $sname2="enda.php"; $base1=1; $cType=1; // typ komentaru...1=web mista $lreport[]=0; $maxart1=$maxfreeart; $maxart2=$maxfreeart2; $infotxt1="4019"; //$artforthis = "8095"; $BaseDir="ma/grf/"; // CESTA K ADRESARI S OBRAZKY $MAX_ON_ROW=5; //pocet objektu na jedne radce $overmax1=0; $baseslot=1; $color0="#DECFAD"; $color1="#FFFAE5"; $color2="#FFFFF0"; $color3="#FFF0E0"; $color4="#FFF8E8"; $color5="#606060"; $color6="#DCBEA0"; $color7="#EBD8B7"; if ($whoisid>0) { } else { $uc1=1; $uc2=1; $uc3=1; $uc4=1; $uc5=0; $uc6=0; $uc7=1; $uc8=0; $uc9=1; $uartgrf=1; } $mname0="IKONKY"; $mname1="Rubriky s vybranými příspěvky"; $mname2="Zajímavé odkazy"; $mname3="Publikovat nový příspěvek"; $mname4="Vlastní fotky / obrázky"; $mname5="Nápověda"; $mname6="Tvé další možnosti"; $mname7="Pomůžeme, poradíme"; $mname8="Potřebujete-li radu, napište nám zprávu na redakce@totem.cz nebo na nick redakce."; $mname9="Publikovat foto, obrázek"; $mname10="Publikovat formulářem"; //$tname0="Vaše fotky/obrázky"; $tname0="Časopis"; $tname1="Kategorie, kde se nacházíte"; $tname2="Seznam kategorií"; $tname3="Další podkategorie"; $tname4="Ikony v této kategorii"; $tname5="Nejnovější fotky/obrázky"; $tname6="Vložit FOTKU/OBRÁZEK"; $tname7="Vaše nové obrázky můžete vložit "; $tname8="Vložit tuto fotku/obrázek"; $tname9="Vložení nové fotky/obrázku"; $tname10="Editace údajů o obrázcích"; $tname11="Fotky/obrázky Tebou vložené"; $tname12="Zatím žádné neexistuje..."; $tname13="Čte si Příspěvky"; //============================================================ /* // TADY SE PRECTOU VSECHNY KATEGORIE $sqlsc1 = "SELECT * from categories,users where users.IDU=categories.cautorid ORDER BY corder"; echo $sqlsc1; mysql_select_db("totem"); $repsc1 = mysql_query( $sqlsc1); if (!$repsc1) { echo "Doslo k chybe pri cteni z DB v tab kategorii 1!!!"; // $lreport[]=137; } else { $cntcat= MySQL_NumRows($repsc1); } // TADY SE PRECTOU VSECHNY PODKATEGORIE AKTUALNI KATEGORIE $sqlsc2 = "SELECT * from categories,users where users.IDU=categories.cautorid and categories.cthread=$c1 ORDER BY corder"; echo $sqlsc2; mysql_select_db("totem"); $repsc2 = mysql_query( $sqlsc2); if (!$repsc2) { echo "Doslo k chybe pri cteni z DB v tab kategorii 2!!!"; // $lreport[]=137; } else { $cntcat2= MySQL_NumRows($repsc2); } */ $whoisonline=""; if ($whoisid>0) { $sqlaut = "SELECT IDU,uusername,upassword,upswmd5,uemail,uchatcol,uchatdelay,uchattime,uchaticon,uchatsmile,uchatobject,uchatlines,uhidden,umember,c1,c2,c3,c4,c5,c6,c7,c8,c9,uslots,ushow,artgrf,artmax FROM users WHERE IDU='$whoisid'"; mysql_select_db("totem"); $repaut = mysql_query( $sqlaut); if (!$repaut) { echo "Nedari se spojit s DB"; } else { $cntaut = MySQL_NumRows($repaut); if ($cntaut) { $arraut = MySQL_Fetch_Array($repaut); $whois=$arraut["uusername"]; $whoisid=$arraut["IDU"]; $whoismail=$arraut["uemail"]; $whocol=$arraut["uchatcol"]; $whodel=$arraut["uchatdelay"]; $whotime=$arraut["uchattime"]; $whoicon=$arraut["uchaticon"]; $whosmile=$arraut["uchatsmile"]; $whoobject=$arraut["uchatobject"]; $wholines=$arraut["uchatlines"]; $whohidden=$arraut["uhidden"]; $whomember=$arraut["umember"]; $whoismd5=$arraut["upswmd5"]; $whoisonline=$whoismd5.$whoisid; $uc1=$arraut["c1"]; $uc2=$arraut["c2"]; $uc3=$arraut["c3"]; $uc4=$arraut["c4"]; $uc5=$arraut["c5"]; $uc6=$arraut["c6"]; $uc7=$arraut["c7"]; $uc8=$arraut["c8"]; $uc9=$arraut["c9"]; $uslots=$arraut["uslots"]; $ushow=$arraut["ushow"]; $uartgrf=$arraut["artgrf"]; $uartmax=$arraut["artmax"]; if ($uartmax>0) { $maxart1=$uartmax; $maxart2=$uartmax+1; } } //cntaut } //repaut } //idu & idp if (StrLen($whoisid)==0) $whoisid=0; if (!IsSet($ot1)) $ot1=11; //pokud nebyl vybran typ zobrazeni // POKUD BYLO ZVOLENO OHODNOCENI KONKRETNIHO WEB MISTA if (IsSet($w1)) $fc=11; // POKUD NENI KATEGORIE URCENA BUDE NASTAVENA OBSAHOVA KATEGORIE if (!IsSet($c1)) $c1=$base1; if (!IsSet($pg)) $pg=1; $minart1=($pg*$maxart1)-$maxart1; $minopi1=($pg*$maxopi1)-$maxopi1; $minaut1=($pg*$maxaut1)-$maxaut1; $rdate=Date("Y-m-d H:i:s"); if ($whoisid>0) { // TADY SE ZAKTUALIZUJE POLOZKA UDATELAST **************************************************************************** $usrstate=$tname13; UsrLastMove($DTB_NAME,$Tbl1,$usrstate,$whoisid); /* $sqlup1 = "UPDATE users SET udatelast='$rdate', uwhereis='$tname13' WHERE IDU='$whoisid'"; mysql_select_db("totem"); $repup1 = mysql_query( $sqlup1); if (!$repup1) { // echo "Doslo k chybe pri update dat v DB v tab users !!!"; $goareport=1; } else { // echo "Polozky byly updatovany"; $goareport=2; } */ } $sql="SELECT IDS,sname,acounter,idsort,idsnum,sorder FROM slots WHERE "; if ($whoisid>0) { if ($IsUsr34>0) { $sql=$sql."(idsort=1 OR idsort=3 OR idsort=4 OR idsort=12 OR idsort=16 OR idsort=48)"; } else { $sql=$sql."(idsort=4 OR idsort=12 OR idsort=16 OR idsort=48)"; } } else { $sql=$sql."(idsort=16 OR idsort=48)"; } // $sql=$sql." AND sforgallery=1"; $sql=$sql." ORDER BY sorder"; mysql_select_db("totem");$vysledek = mysql_query( $sql); if (!$vysledek) { echo "error pri pristupu k tab Rubrik"; } else $cntslt=MySQL_NumRows($vysledek); $C0=0; $cntnav=0; $os1=""; for ($i1=1; $i1<=$cntslt; $i1++): $whichc1="C".$i1; eval("\$whichc2=\$\$whichc1;"); if ($whichc2<>0): // echo "$whichc1>$whichc2 "; $os1=$os1."&$whichc1=".$whichc2; $cntnav++; if ($aktslt==0) $aktslt=$whichc2; endif; endfor; //echo "Navigace:".$os1; if ($cntnav==0) { $aktslt=$baseslot; $C0=$baseslot; } //echo "AKTUALNI:".$aktslt; $sqlslot1 = "SELECT * FROM slots WHERE IDSnum=$aktslt"; mysql_select_db("totem");$repslot1 = mysql_query( $sqlslot1); if (!$repslot1) { echo "Doslo k chybe pri pristupu k tab slots !!!"; } else { $cntselslt = MySQL_NumRows($repslot1); // echo "CNT:".$cntselslt; if ($cntselslt>0) { $goawhere=$C0; $arrslot1 = MySQL_Fetch_Array($repslot1); $sbgrgrf=$arrslot1["sbgrgrf"]; $sbgrsnd=$arrslot1["sbgrsnd"]; $sloopsnd=$arrslot1["sloopsnd"]; $sbgrcol=$arrslot1["sbgrcol"]; $ssigngrf=$arrslot1["ssigngrf"]; $sintroord=$arrslot1["sintroord"]; $ssympord=$arrslot1["ssympord"]; $sselectord=$arrslot1["sselectord"]; $sneword=$arrslot1["sneword"]; $scountord=$arrslot1["scountord"]; $soutroord=$arrslot1["soutroord"]; $suserid=$arrslot1["suserid"]; $suserord=$arrslot1["suserord"]; $svoteord=$arrslot1["svoteord"]; $sordselect=$arrslot1["sordselect"]; $aktsltord=$arrslot1["sorder"]; // echo $sintroord.$ssympord.$sselectord.$sneword.$scountord.$soutroord; // CounterSltUp1($kde); } } if (IsSet($ot1)) $nav=$nav."ot1=".$ot1; if (IsSet($ot2)) $nav=$nav."&ot2=".$ot2; if (IsSet($ot3)) $nav=$nav."&ot3=".$ot3; if (IsSet($os1)) $nav=$nav.$os1; ?> TOTální E Magazín - <? echo $tname0 ?> "") echo ""; //echo "IDPU:".$idpu; ?> "") echo " bgcolor=#$sbgrcol"; ?> link="#000000" vlink="#000000" alink="#800000">
0) { include "inc/goa2user.php"; } ?> 0 AND whichissue<='$lastinum' ORDER by whichissue DESC"; mysql_select_db("totem"); $repi = mysql_query( $sqli); if (!$repi) { echo "Doslo k chybe pri pristupu k tab cisel !!!"; // break; } else { $cntpg=MySql_NumRows($repi); if ($cntpg>0) // echo "CNT:".$cntpg; { $lastpg=0; $allpg=0; while ($arri = MySQL_Fetch_Array($repi)) { $allpg = $allpg+1; // echo "o:".$allpg; $ititle[$allpg] = $arri["title"]; $idetail[$allpg] = $arri["detail"]; $iwhichissue[$allpg] = $arri["whichissue"]; $iorderissue[$allpg] = $arri["orderissue"]; $istate[$allpg] = $arri["state"]; $ibggrf[$allpg] = $arri["ibggrf"]; $ibgsnd[$allpg] = $arri["ibgsnd"]; $iloopsnd[$allpg] = $arri["iloopsnd"]; $ilock[$allpg] = $arri["alock"]; $itype[$allpg] = $arri["type"]; // echo $ititle[0]; if ($allpg>$lastpg) $lastpg=$allpg; // echo $lastpg; } } $lastpg=$cntpg; } if (($IsUsr34!=1) && ($IsUsr1!=1)) UpdateInTable2($DTB_NAME,$Tbl7,"iaccess=iaccess+1","whichissue=0"." AND orderissue=0"); if ($whoisid>0): $rdate=Date("Y-m-d H:i:s"); if ($nm<=$lastinum) $whereinend="Čte $nm.číslo a $pg.stranu"; else $whereinend="Čte si číslo"; UsrLastMove($DTB_NAME,$Tbl1,$whereinend,$whoisid); // if ($a<>0) $whereinend=$whereinend.">".$a; // else $whereinend=$whereinend.">".$c; $sqlwho = "SELECT * FROM users WHERE IDU='$whoisid'"; mysql_select_db("totem"); $repwho = mysql_query( $sqlwho); if (!$repwho): echo "Doslo k chybe pri pristupu k tab Uzivatelu !!!"; // break; else: $arrwho = MySQL_Fetch_Array($repwho); $visitdate= $arrwho["ulastvisit"]; $redfordate= $arrwho["ulastredfor"]; endif; endif; ?> ?>

"; //echo ""; //while ($arri = MySQL_Fetch_Array($repi)) for ($actpg=$firstpg;$actpg<=$lastpg;$actpg++) { // $ititle = $arri["title"]; // $idetail = $arri["detail"]; // $iwhichissue = $arri["whichissue"]; // $iorderissue = $arri["orderissue"]; // $istate = $arri["state"]; echo ""; echo ""; } /* for ($i=0;$i<=StrLen($thisslot)-3;$i++) { $aktual = SubStr($thisslot,0,3+$i); echo ""; $sql4 = "SELECT * FROM slots WHERE IDS LIKE '$aktual'"; mysql_select_db("totem"); $vysledek4 = mysql_query( $sql4); if (!$vysledek4) { echo "Doslo k chybe pri pristupu k tab Sekce !!!"; break; } else { $pocet4=MySQL_NumRows($vysledek4); if ($pocet4>0) { $zaznam4 = MySQL_Fetch_Array($vysledek4); $lastslot=$zaznam4["sname"]; echo $lastslot."
"; } } } */ ?>
 Seznam čísel časopisu Totem.cz "; //if ($idetail[$intropg]!='') echo "...".$idetail[$intropg].""; echo "
 
"; else echo ">"; // echo "$iorderissue[$actpg]. echo " "; else echo ">"; echo "".$ititle[$actpg].""; if ($idetail[$actpg]!='') echo " - ".$idetail[$actpg]; echo " 
  
 
0): $wasityet=0; $showslt=0; while ($zaznam3 = MySQL_Fetch_Array($vysledek)): $slotid=$zaznam3["IDS"]; $slotname=$zaznam3["sname"]; $slotsort=$zaznam3["idsort"]; $slotnum=$zaznam3["idsnum"]; $slotthread=$zaznam3["idsthread"]; $slotorder=$zaznam3["sorder"]; if ($wasityet==0): $wasityet=1; endif; if ($slotorder==1000000) { // echo ""; } if ($slotorder<3000000 || $IsUsr1>0) //ZABLOKOVANO PRO SPRAVCE!!!!!!!!!! { $showslt++; // if (StrLen($kde)>1) // { // if ($slotid==$kde) // { // include "goa-dsn8.php"; // } // else // { if ($slotnum==$baseslot) { echo ""; } else { $ch1="C".$showslt; eval("\$ch2=\$\$ch1;"); if (StrLen($slotid)<4) { $displayslot=""; $displayslot.=$slotname.""; // if ($slotid=="mas") $displayslot.="\"English\""; echo ""; $ch3="C".$showslt; eval("\$ch4=\$\$ch3;"); } else { // if (StrLen($slotid)>3) { if (($ch4!=0) || ($ch2!=0) || ($C1==$slotnum)) { $displayslot=""; $displayslot.=$slotname.""; // if ($slotid=="mas") $displayslot.="\"English\""; echo ""; } } } } // } // else // { // } // echo ""; endwhile; echo ""; endif; ?>

"; echo ""; else echo ">"; if (StrLen($slotid)>3) echo "  "; //> else echo ""; echo ""; echo $slotname.""; // if ($slotid=="mas") echo "\"English\""; if (StrLen($slotid)<4) echo ""; echo "
"; echo "
"; echo ""; else echo ">"; echo ""; echo $displayslot; echo "
"; echo "
"; if ($ch2!=0 || $C1==$slotnum) echo ""; else echo "     "; //> echo $displayslot; echo "
"; echo "
  

  
"; echo ""; if ($IsUsr1>0) { ?>

 

 
 
 
 Nápovida  Redakce Totemu
 Seznam Anket 
 Nápovida

 
 

 


    "; ?>


"; //include "reklama/ticket1.inc"; //include "reklama/xpress1.inc"; //echo "
"; //include "reklama/obryskmen1.inc"; //echo "
"; include "reklama/alnamura.php"; echo "
"; include "reklama/edicex.php"; echo "
"; //include "reklama/ceskacentra.php"; //echo "
"; //include "reklama/moje1noviny1.php"; //echo "
"; //include "reklama/neknihy1.inc"; include "reklama/gentleman1.php"; echo "
"; echo "
"; ?>
"; //include "reklama/xpress-sl3.php"; ?>  
"; ?> $tname7ZDE"); //ShowHead(3,"
 Publikované příspěvky ve Vašem prostoru - ".$pg.". strana
"); ShowHead(3,""); ?>
"; for ($ilrep=1;$ilrep<$pom;$ilrep++): //echo "HODNOTA:".$lreport[$ilrep]."
"; echo "
"; switch ($lreport[$ilrep]) // NEJPRVE SE VYPISI STAVOVE A ERROROVE HLASKY ********************************** { case 1: Showlrep1("Název webu může být dlouhý maximálně 50 znaků"); break; case 2: Showlrep1("Jméno vlastníka může být dlouhé maximálně 50 znaků"); break; case 3: Showlrep1("Adresa WEBu může být dlouhé maximálně 50 znaků"); break; case 51: Showlrep2("Údaje byly vloženy do databáze WEB míst"); break; case 54: Showlrep1("Údaje o WEB místu nelze vymazat"); break; case 55: Showlrep2("Údaje o WEB místu byly vymazány"); break; case 56: Showlrep1("Údaje o WEB místu nelze aktualizovat"); break; case 57: Showlrep2("Údaje o WEB místu byly aktualizovány"); break; default: echo "Nejaka jina hlaska odpovidajici stavu: ".$lreport; break; } endfor; // ZDE SE ZJISTI AKTUALNI FCE A ROZSKOCI SE DLE NI NA VYPISY HLAVNICH OBSAHU PROSTREDKU PrintArt1($artforthis); // Vytiskne artile s timhle cislem if ($who>0) $ot1=510; switch ($ot1) { case 21: case 22: case 23: case 24: case 25: case 26: case 27: case 28: case 29: case 61: case 62: case 63: case 64: case 65: case 66: { /* $sqlaut1 = "SELECT * FROM users WHERE (uintroduce=1 OR uintroduce=3 OR uintroduce=5 OR uintroduce=7) AND (TO_DAYS(udatereg) >= (TO_DAYS(NOW()) - $HowToNew)) ORDER BY uusername"; mysql_select_db("totem"); $repaut1 = mysql_query( $sqlaut1); if (!$repaut1): echo "Doslo k chybe pri pristupu k tab uzivatelu !!!"; $goareport=30; break; else: */ echo "
"; echo ""; ?>
 Vyhledat autora podle jména:

"; //dup...zobrazeni autoru podle abecedy vzestupne nebo sestupne switch ($ot1) { case 21: $stext1="Seznam autorů od A do Z"; break; case 22: $stext1="Seznam nejvíce diskutovaných autorů"; break; case 23: $stext1="Seznam nejvíce zobrazovaných autorů"; break; case 24: $stext1="Seznam nejvíce ukládaných autorů"; break; case 25: $stext1="Seznam nejvíce doporučovaných autorů"; break; case 26: $stext1="Seznam autorů podle počtu hodnocení"; break; case 27: $stext1="Seznam autorů podle součtu bodů"; break; case 28: $stext1="Seznam autorů podle výsledného průměru"; break; case 61: $stext1="Seznam autorů s nejvíce příspěvky"; break; case 62: $stext1="Seznam autorů, kteří napsali nejvíce poznámek"; break; case 63: $stext1="Seznam autorů podle data posledního publikovaní"; break; case 64: $stext1="Seznam nových autorů za poslední měsíc"; break; case 65: $stext1="Seznam pravidelných autorů"; break; case 66: $stext1="Seznam autorů podle času stráveného na Totemu"; break; } ShowLabel3($stext1,"FFF8E8",0); echo "
"; echo "
 "; if ($ot1==21 && $ot3==1) echo "\"\""; echo "".Všichni." "; echo " "; if ($ot1==64 || $ot3==2) echo "\"\""; echo "Noví "; echo " "; if ($ot1==65 || $ot3==3) echo "\"\""; echo "Pravidelní "; echo " "; if ($ot1==66 || $ot3==4) echo "\"\""; echo "Stálí "; echo "Začínající na: "; for ($i3=1;$i3<=26;$i3++): $abclink=StrToLower(Chr($i3+64)); // if (IsUserLike($abclink)==1) if ($ot3==$abclink) echo "\"\""; echo "".Chr($i3+64)." "; endfor; echo " 
"; $sql="SELECT DISTINCT users.uintroduce,users.urights,users.uvirtlife,users.IDU,users.uusername,users.uface,users.udatereg,users.udatelast,users.usex,users.uage,users.umessage,users.umember,users.uwww,userdetails.saves,userdetails.tips,userdetails.votes,userdetails.points,userdetails.notes,userdetails.ownarticles,userdetails.ownopinions,userdetails.lastarticle,userdetails.shows,userdetails.result FROM articles,users,slots,userdetails WHERE articles.IDU=users.IDU AND articles.IDS1=slots.IDS AND articles.idsort>2 AND articles.idsort<5 AND articles.adate5<='$rdate' AND users.IDU=userdetails.IDU"; //AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' if (IsSet($C100)) $sql=$sql." AND articles.sale>0"; //echo "CNT:".$cntslt; include "inc/slotscheck.php"; if (StrLen($ot3)>0) { if ($ot3==1 || $ot3==2 || $ot3==3 || $ot3==4) { if ($ot3==3) $sql=$sql." AND users.uvirtlife>1000"; if ($ot3==4) $sql=$sql." AND users.uvirtlife>3000"; } else $sql=$sql." AND users.uusername LIKE '$ot3%'"; } $sql=$sql." AND userdetails.ownarticles>0"; $HowLastOld1=30; $HowLastOld2=7; $HowLastOld3=30; $HowRegOld1=30; $HowRegOld2=30; $HowRegOld3=365; switch ($ot1) { /* case 21: $stext1="Seznam autorů od A do Z"; break; case 22: $stext1="Seznam nejvíce diskutovaných autorů"; break; case 23: $stext1="Seznam nejvíce zobrazovaných autorů"; break; case 24: $stext1="Seznam nejvíce ukládaných autorů"; break; case 25: $stext1="Seznam nejvíce doporučovaných autorů"; break; case 26: $stext1="Seznam autorů podle počtu hodnocení"; break; case 27: $stext1="Seznam autorů podle součtu bodů"; break; case 28: $stext1="Seznam autorů podle výsledného průměru"; break; case 61: $stext1="Seznam autorů s nejvíce příspěvky"; break; case 62: $stext1="Seznam autorů, kteří napsali nejvíce poznámek"; break; case 63: $stext1="Seznam pravidelných autorů"; break; case 64: $stext1="Seznam nových autorů za poslední měsíc"; break; */ case 21: $sql=$sql." ORDER BY users.uusername LIMIT $minaut1,$maxaut2"; break; case 22: $sql=$sql." ORDER BY userdetails.notes DESC LIMIT $minaut1,$maxaut2"; break; case 23: $sql=$sql." ORDER BY userdetails.shows DESC LIMIT $minaut1,$maxaut2"; break; case 24: $sql=$sql." ORDER BY userdetails.saves DESC LIMIT $minaut1,$maxaut2"; break; case 25: $sql=$sql." ORDER BY userdetails.tips DESC LIMIT $minaut1,$maxaut2"; break; case 26: $sql=$sql." ORDER BY userdetails.votes DESC LIMIT $minaut1,$maxaut2"; break; case 27: $sql=$sql." ORDER BY userdetails.points DESC LIMIT $minaut1,$maxaut2"; break; case 28: $sql=$sql." ORDER BY userdetails.result DESC LIMIT $minaut1,$maxaut2"; break; case 61: $sql=$sql." ORDER BY userdetails.ownarticles DESC LIMIT $minaut1,$maxaut2"; break; case 62: $sql=$sql." ORDER BY userdetails.ownopinions DESC LIMIT $minaut1,$maxaut2"; break; case 63: $sql=$sql." ORDER BY userdetails.lastarticle DESC LIMIT $minaut1,$maxaut2"; break; case 64: $sql=$sql." AND (TO_DAYS(users.udatereg) >= (TO_DAYS(NOW()) - $HowRegOld1)) AND (TO_DAYS(users.udatelast) >= (TO_DAYS(NOW()) - $HowLastOld1)) ORDER BY users.udatereg DESC LIMIT $minaut1,$maxaut2"; break; case 65: $sql=$sql." AND users.uvirtlife>1000 AND (TO_DAYS(users.udatereg) <= (TO_DAYS(NOW()) - $HowRegOld2)) AND (TO_DAYS(users.udatelast) >= (TO_DAYS(NOW()) - $HowLastOld2)) ORDER BY users.uvirtlife DESC LIMIT $minaut1,$maxaut2"; break; case 66: $sql=$sql." AND users.uvirtlife>3000 AND (TO_DAYS(users.udatereg) <= (TO_DAYS(NOW()) - $HowRegOld3)) AND (TO_DAYS(users.udatelast) >= (TO_DAYS(NOW()) - $HowLastOld3)) ORDER BY users.uvirtlife DESC LIMIT $minaut1,$maxaut2"; break; default: $sql=$sql." ORDER BY users.uusername DESC LIMIT $minaut1,$maxaut2"; break; } //echo "SQL:".$sql; mysql_select_db("totem");$rep = mysql_query( $sql); if (!$rep) { echo "Doslo k chybe pri cteni dat z DB !!!:"; } else { $cntsql= MySQL_NumRows($rep); if ($cntsql>0) { ?> "; //if ($uc3==1) { if ($coltype1==$color3) $coltype1=$color4; else $coltype1=$color3; echo ""; //} //if ($uc3==1) { if ($coltype1==$color3) $coltype1=$color4; else $coltype1=$color3; echo ""; //} //if ($uc3==1) { if ($coltype1==$color3) $coltype1=$color4; else $coltype1=$color3; echo ""; //} if ($coltype1==$color3) $coltype1=$color4; else $coltype1=$color3; echo ""; $coltype1=$color4; //if ($uc7==1) { if ($coltype1==$color3) $coltype1=$color4; else $coltype1=$color3; echo ""; //} //if ($uc4==1) { if ($coltype1==$color3) $coltype1=$color4; else $coltype1=$color3; echo ""; //} //if ($uc6==1) { if ($coltype1==$color3) $coltype1=$color4; else $coltype1=$color3; echo ""; //} //if ($uc5==1) { if ($coltype1==$color3) $coltype1=$color4; else $coltype1=$color3; echo ""; //} /* if ($uc9==1) { if ($coltype1==$color3) $coltype1=$color4; else $coltype1=$color3; echo ""; } */ //if ($uc8==1) { if ($coltype1==$color3) $coltype1=$color4; else $coltype1=$color3; echo ""; //} //if ($uc9==1) { if ($coltype1==$color3) $coltype1=$color4; else $coltype1=$color3; echo ""; //} echo ""; echo ""; $cntshow=0; $cntrow=0; while ($arr= MySQL_Fetch_Array($rep)) { $coltype1=$color4; // if ($cntrow==0) echo ""; $cntshow++; $cntrow++; if ($cntshow<=$maxaut1) { $idunum=$arr["IDU"]; $idusign=$arr["uface"]; $usex=$arr["usex"]; $uage=$arr["uage"]; $uname=$arr["uusername"]; $umessage=$arr["umessage"]; $uartall=$arr["ownarticles"]; $uopiall=$arr["ownopinions"]; $ulastarticle=$arr["lastarticle"]; $udatereg=$arr["udatereg"]; $udatelast=$arr["udatelast"]; $udshows=$arr["shows"]; $udsaves=$arr["saves"]; $udtips=$arr["tips"]; $udvotes=$arr["votes"]; $udnotes=$arr["notes"]; $udpoints=$arr["points"]; $udresult=$arr["result"]; $uvirtlife=$arr["uvirtlife"]; $urights=$arr["urights"]; $uintroduce=$arr["uintroduce"]; // $otype=$arr["osuffix"]; // $tooltip=$arr["otooltip"]; // $filename=$idanum.".".$otype; // $fileload=$BaseDir.$oname; if (StrLen($idusign)>0 && File_Exists("./usr/grf/".$idusign) && filesize("./usr/grf/".$idusign)>0) $fileload="usr/grf/".$idusign; else $fileload="usr/grf/0.gif"; // $fileload=usr/$oname; $velxy=GetImageSize($fileload); $velx=40; $vely=50; echo ""; // if ($uc3==1) { if ($coltype1==$color3) $coltype1=$color4; else $coltype1=$color3; echo ""; // } if ($coltype1==$color3) $coltype1=$color4; else $coltype1=$color3; echo ""; if ($coltype1==$color3) $coltype1=$color4; else $coltype1=$color3; echo ""; if ($coltype1==$color3) $coltype1=$color4; else $coltype1=$color3; echo ""; if ($coltype1==$color3) $coltype1=$color4; else $coltype1=$color3; echo ""; if ($coltype1==$color3) $coltype1=$color4; else $coltype1=$color3; echo ""; if ($coltype1==$color3) $coltype1=$color4; else $coltype1=$color3; echo ""; if ($coltype1==$color3) $coltype1=$color4; else $coltype1=$color3; echo ""; //if ($coltype1==$color3) $coltype1=$color4; else $coltype1=$color3; // echo ""; if ($coltype1==$color3) $coltype1=$color4; else $coltype1=$color3; echo ""; // $udrating= SubStr(($udpoints/$udvotes),0,4); if ($coltype1==$color3) $coltype1=$color4; else $coltype1=$color3; echo ""; echo ""; echo ""; } else { //echo "KONEC"; $overmax1=1; } } echo "
 "; if ($ot1==21) echo "\"\""; echo "Jméno a info"; echo "Vlastních
"; if ($ot1==61) echo "\"\""; echo "příspěvků
"; echo "Vlastních
"; if ($ot1==62) echo "\"\""; echo "poznámek
"; echo "Naposled
"; if ($ot1==63) echo "\"\""; echo "publikoval
"; echo ""; if ($ot1==22) echo "\"\""; echo "Poznámek"; echo ""; if ($ot1==23) echo "\"\""; echo "Zobrazen"; echo ""; if ($ot1==24) echo "\"\""; echo "Uložen"; echo ""; if ($ot1==25) echo "\"\""; echo "Doporučen"; echo ""; if ($ot1==26) echo "\"\""; echo "Hodnocen"; echo ""; if ($ot1==27) echo "\"\""; echo "Bodů"; echo ""; if ($ot1==28) echo "\"\""; echo "Průměr
$tooltip"; echo "$uname"; echo ""; if ($usex==1) echo "
(muž)"; elseif ($usex==2) echo "
(žena)"; else echo "
"; if ($uage>0) echo " - ".$uage."let"; echo "
"; ShowSigns($idunum,"",0,0,$udatereg,$udatelast,$uintroduce,$uvirtlife,$urights,"#000000",$sname1."?ot1=51&ot2=$idunum",$sname1."?ot1=51&ot2=$idunum",1,0); echo "
Na Totemu: ".$uvirtlife."x"; echo "
"; echo "
$uartall$uopiall"; if ($ulastarticle!="") ShowOkDate1($ulastarticle,1); echo "$udnotes$udshows$udsaves$udtips$udvotes$udpoints".$udresult."
"; echo "
 "; if ($ot1==21 && $ot3==1) echo "\"\""; echo "".Všichni." "; echo " "; if ($ot1==64 || $ot3==2) echo "\"\""; echo "Noví "; echo " "; if ($ot1==65 || $ot3==3) echo "\"\""; echo "Pravidelní "; echo " "; if ($ot1==66 || $ot3==4) echo "\"\""; echo "Pamětníci "; echo " Začínající na: "; for ($i3=1;$i3<=26;$i3++) { $abclink=StrToLower(Chr($i3+64)); // if (IsUserLike($abclink)==1) if ($ot3==$abclink) echo "\"\""; echo "".Chr($i3+64)." "; } echo " 
"; $pg1=$pg-1; $pg2=$pg+1; ShowNavig3($pg,$pg.".strana autorů","předchozí strana","další strana","FFF8E8",$cntsql,$maxaut1,$pg1,$nav."&ot3=".$ot3."&pg",$pg2,$nav."&ot3=".$ot3."&pg",$sname1,$ref1); } else echo "
Ve vybrané rubrice zatím žádný autor nepublikoval.
"; } //not SQL error /* if ($pg>1) echo "«Předchozí "; if (($pg>1) || ($cntsql>$maxaut1)) echo "   ".$pg.".strana autorů   "; if ($cntsql>$maxaut1) echo " Následující»"; */ PrintArt1($artforthis6); } break; case 51: case 52: case 53: case 54: case 55: case 56: case 57: case 71: case 72: case 73: case 74: case 75: case 76: case 77: case 81: case 82: case 83: case 84: case 85: case 86: case 87: case 91: case 92: case 93: case 94: case 95: case 96: case 97: case 101: case 102: case 103: case 104: case 105: case 106: case 107: case 111: case 112: case 113: case 114: case 115: case 116: case 117: //dup...Zobrazeni prispevku od vybraneho autora { ?>
2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU AND articles.IDU=$ot2"; //AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' AND articles.IDS1=slots.IDS AND articles.IDSnum=slots.idsnum } break; case 52: { $sql="SELECT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU AND articles.IDU=$ot2"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' } break; case 53: { $sql="SELECT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU AND articles.IDU=$ot2"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' } break; case 54: { $sql="SELECT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU AND articles.IDU=$ot2"; //AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' } break; case 55: { $sql="SELECT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU AND articles.IDU=$ot2"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' AND articles.averdict>0 } break; case 56: { $sql="SELECT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.averdict>0 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU AND articles.IDU=$ot2"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' } break; case 57: { $sql="SELECT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU AND articles.IDU=$ot2"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' } break; case 71: { $sql="SELECT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots WHERE articles.aselect=12 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU AND articles.IDU=$ot2"; //AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' AND articles.IDS1=slots.IDS AND articles.IDSnum=slots.idsnum } break; case 72: { $sql="SELECT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots WHERE articles.aselect=12 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU AND articles.IDU=$ot2"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' } break; case 73: { $sql="SELECT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots WHERE articles.aselect=12 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU AND articles.IDU=$ot2"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' } break; case 74: { $sql="SELECT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots WHERE articles.aselect=12 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU AND articles.IDU=$ot2"; //AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' } break; case 75: { $sql="SELECT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots WHERE articles.aselect=12 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU AND articles.IDU=$ot2"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' AND articles.averdict>0 } break; case 76: { $sql="SELECT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots WHERE articles.aselect=12 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.averdict>0 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU AND articles.IDU=$ot2"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' } break; case 77: { $sql="SELECT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots WHERE articles.aselect=12 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU AND articles.IDU=$ot2"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' } break; case 81: { //AUTOROVY DOPORUCENE *************************************************************************** // $sql="SELECT DISTINCT articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,articles.atip,articles.asave,users.uusername,articles.sname FROM articles,users,opinions,slots "; $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum"; $sql.=" FROM articles,users,opinions,slots WHERE articles.IDU=users.IDU AND articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' "; $sql.=" AND articles.IDA=opinions.about AND opinions.IDU=$ot2 AND opinions.tip=1"; } break; case 82: { $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots,opinions WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' $sql.=" AND articles.IDA=opinions.about AND opinions.IDU=$ot2 AND opinions.tip=1"; } break; case 83: { $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots,opinions WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' $sql.=" AND articles.IDA=opinions.about AND opinions.IDU=$ot2 AND opinions.tip=1"; } break; case 84: { $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots,opinions WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; //AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' $sql.=" AND articles.IDA=opinions.about AND opinions.IDU=$ot2 AND opinions.tip=1"; } break; case 85: { $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots,opinions WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' AND articles.averdict>0 $sql.=" AND articles.IDA=opinions.about AND opinions.IDU=$ot2 AND opinions.tip=1"; } break; case 86: { $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots,opinions WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.averdict>0 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' $sql.=" AND articles.IDA=opinions.about AND opinions.IDU=$ot2 AND opinions.tip=1"; } break; case 87: { $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots,opinions WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' $sql.=" AND articles.IDA=opinions.about AND opinions.IDU=$ot2 AND opinions.tip=1"; } break; case 91: { //AUTOROVY ULOZENE *************************************************************************** $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum"; $sql.=" FROM articles,users,opinions,slots WHERE articles.IDU=users.IDU AND articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' "; $sql.=" AND articles.IDA=opinions.about AND opinions.IDU=$ot2 AND opinions.save=1"; } break; case 92: { $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots,opinions WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' $sql.=" AND articles.IDA=opinions.about AND opinions.IDU=$ot2 AND opinions.save=1"; } break; case 93: { $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots,opinions WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' $sql.=" AND articles.IDA=opinions.about AND opinions.IDU=$ot2 AND opinions.save=1"; } break; case 94: { $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots,opinions WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; //AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' $sql.=" AND articles.IDA=opinions.about AND opinions.IDU=$ot2 AND opinions.save=1"; } break; case 95: { $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots,opinions WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' AND articles.averdict>0 $sql.=" AND articles.IDA=opinions.about AND opinions.IDU=$ot2 AND opinions.save=1"; } break; case 96: { $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots,opinions WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.averdict>0 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' $sql.=" AND articles.IDA=opinions.about AND opinions.IDU=$ot2 AND opinions.save=1"; } break; case 97: { $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots,opinions WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' $sql.=" AND articles.IDA=opinions.about AND opinions.IDU=$ot2 AND opinions.save=1"; } break; case 101: { //OSTATNI DOPORUCUJI TYTO PRISPEVKY VYBRANEHO AUTORA *************************************************************************** // $sql="SELECT DISTINCT articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,articles.atip,articles.asave,users.uusername,articles.sname FROM articles,users,opinions,slots "; $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum"; $sql.=" FROM articles,users,opinions,slots WHERE articles.IDU=users.IDU AND articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' "; $sql.=" AND articles.IDU=$ot2 AND articles.IDA=opinions.about AND opinions.IDU<>$ot2 AND opinions.tip=1"; } break; case 102: { $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots,opinions WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' $sql.=" AND articles.IDU=$ot2 AND articles.IDA=opinions.about AND opinions.IDU<>$ot2 AND opinions.tip=1"; } break; case 103: { $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots,opinions WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' $sql.=" AND articles.IDU=$ot2 AND articles.IDA=opinions.about AND opinions.IDU<>$ot2 AND opinions.tip=1"; } break; case 104: { $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots,opinions WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; //AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' $sql.=" AND articles.IDU=$ot2 AND articles.IDA=opinions.about AND opinions.IDU<>$ot2 AND opinions.tip=1"; } break; case 105: { $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots,opinions WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' AND articles.averdict>0 $sql.=" AND articles.IDU=$ot2 AND articles.IDA=opinions.about AND opinions.IDU<>$ot2 AND opinions.tip=1"; } break; case 106: { $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots,opinions WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.averdict>0 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' $sql.=" AND articles.IDU=$ot2 AND articles.IDA=opinions.about AND opinions.IDU<>$ot2 AND opinions.tip=1"; } break; case 107: { $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots,opinions WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' $sql.=" AND articles.IDU=$ot2 AND articles.IDA=opinions.about AND opinions.IDU<>$ot2 AND opinions.tip=1"; } break; case 111: { ////OSTATNI SI ULOZILI TYTO PRISPEVKY VYBRANEHO AUTORA *************************************************************************** $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum"; $sql.=" FROM articles,users,opinions,slots WHERE articles.IDU=users.IDU AND articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' "; $sql.=" AND articles.IDU=$ot2 AND articles.IDA=opinions.about AND opinions.IDU<>$ot2 AND opinions.save=1"; } break; case 112: { $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots,opinions WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' $sql.=" AND articles.IDU=$ot2 AND articles.IDA=opinions.about AND opinions.IDU<>$ot2 AND opinions.save=1"; } break; case 113: { $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots,opinions WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' $sql.=" AND articles.IDU=$ot2 AND articles.IDA=opinions.about AND opinions.IDU<>$ot2 AND opinions.save=1"; } break; case 114: { $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots,opinions WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; //AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' $sql.=" AND articles.IDU=$ot2 AND articles.IDA=opinions.about AND opinions.IDU<>$ot2 AND opinions.save=1"; } break; case 115: { $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots,opinions WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' AND articles.averdict>0 $sql.=" AND articles.IDU=$ot2 AND articles.IDA=opinions.about AND opinions.IDU<>$ot2 AND opinions.save=1"; } break; case 116: { $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots,opinions WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.averdict>0 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' $sql.=" AND articles.IDU=$ot2 AND articles.IDA=opinions.about AND opinions.IDU<>$ot2 AND opinions.save=1"; } break; case 117: { $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots,opinions WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' $sql.=" AND articles.IDU=$ot2 AND articles.IDA=opinions.about AND opinions.IDU<>$ot2 AND opinions.save=1"; } break; } //switch if (IsSet($C100)) $sql=$sql." AND articles.sale>0"; include "inc/slotscheck.php"; $sql.=" AND articles.IDSnum=slots.idsnum"; switch ($ot1) { case 51: $sql=$sql." ORDER BY articles.adate5 DESC LIMIT $minart1,$maxart2"; break; case 52: $sql=$sql." ORDER BY articles.acounter DESC,articles.averdict ASC LIMIT $minart1,$maxart2"; break; case 53: $sql=$sql." ORDER BY articles.ahasnote DESC,articles.acounter DESC LIMIT $minart1,$maxart2"; break; case 54: $sql=$sql." ORDER BY articles.atip DESC,articles.acounter DESC LIMIT $minart1,$maxart2"; break; case 55: $sql=$sql." ORDER BY articles.asave DESC,articles.acounter DESC LIMIT $minart1,$maxart2"; break; case 56: $sql=$sql." ORDER BY articles.averdict ASC,articles.acounter DESC LIMIT $minart1,$maxart2"; break; case 57: $sql=$sql." ORDER BY articles.avotesum DESC,articles.acounter DESC LIMIT $minart1,$maxart2"; break; case 71: $sql=$sql." ORDER BY articles.adate5 DESC LIMIT $minart1,$maxart2"; break; case 72: $sql=$sql." ORDER BY articles.acounter DESC,articles.averdict ASC LIMIT $minart1,$maxart2"; break; case 73: $sql=$sql." ORDER BY articles.ahasnote DESC,articles.acounter DESC LIMIT $minart1,$maxart2"; break; case 74: $sql=$sql." ORDER BY articles.atip DESC,articles.acounter DESC LIMIT $minart1,$maxart2"; break; case 75: $sql=$sql." ORDER BY articles.asave DESC,articles.acounter DESC LIMIT $minart1,$maxart2"; break; case 76: $sql=$sql." ORDER BY articles.averdict ASC,articles.acounter DESC LIMIT $minart1,$maxart2"; break; case 77: $sql=$sql." ORDER BY articles.avotesum DESC,articles.acounter DESC LIMIT $minart1,$maxart2"; break; case 81: case 91: case 101: case 111: $sql=$sql." ORDER BY articles.adate5 DESC LIMIT $minart1,$maxart2"; break; case 82: case 92: case 102: case 112: $sql=$sql." ORDER BY articles.acounter DESC,articles.averdict ASC LIMIT $minart1,$maxart2"; break; case 83: case 93: case 103: case 113: $sql=$sql." ORDER BY articles.ahasnote DESC,articles.acounter DESC LIMIT $minart1,$maxart2"; break; case 84: case 94: case 104: case 114: $sql=$sql." ORDER BY articles.atip DESC,articles.acounter DESC LIMIT $minart1,$maxart2"; break; case 85: case 95: case 105: case 115: $sql=$sql." ORDER BY articles.asave DESC,articles.acounter DESC LIMIT $minart1,$maxart2"; break; case 86: case 96: case 106: case 116: $sql=$sql." ORDER BY articles.averdict ASC,articles.acounter DESC LIMIT $minart1,$maxart2"; break; case 87: case 97: case 107: case 117: $sql=$sql." ORDER BY articles.avotesum DESC,articles.acounter DESC LIMIT $minart1,$maxart2"; break; } //switch //echo "SQL:".$sql; mysql_select_db("totem");$rep = mysql_query( $sql); if (!$rep) { echo "Doslo k chybe pri cteni dat z DB !!!:"; } else { $cntsql= MySQL_NumRows($rep); switch ($ot1) { case 51: case 52: case 53: case 54: case 55: case 56: case 57: ShowList1($pg,$maxart1,"a2",$ot1,$ot2,$cntsql,$cntsql,$cntsql,$rep,1,0,"","Příspěvky od vybraného autora","Příspěvky od vybraného autora","Příspěvky od vybraného autora","Příspěvky od vybraného autora","Žádné příspěvky od vybraného autora",1,"ot1=$ot1&ot2=$ot2&ot3=$ot3&pg","ot1=$ot1&ot2=$ot2&ot3=$ot3&pg","Další příspěvky","novější","starší","Další příspěvky","novější","starší",$refn1); break; case 71: case 72: case 73: case 74: case 75: case 76: case 77: ShowList1($pg,$maxart1,"a3",$ot1,$ot2,$cntsql,$cntsql,$cntsql,$rep,1,0,"","Kolekce od vybraného autora","Příspěvky od vybraného autora","Příspěvky od vybraného autora","Příspěvky od vybraného autora","Žádné příspěvky od vybraného autora",1,"ot1=$ot1&ot2=$ot2&ot3=$ot3&pg","ot1=$ot1&ot2=$ot2&ot3=$ot3&pg","Další příspěvky","novější","starší","Další příspěvky","novější","starší",$refn1); break; case 81: case 82: case 83: case 84: case 85: case 86: case 87: ShowList1($pg,$maxart1,"a4",$ot1,$ot2,$cntsql,$cntsql,$cntsql,$rep,1,0,"","Autor doporučuje tyto příspěvky ostatních","Autor doporučuje tyto příspěvky ostatních","Autor doporučuje tyto příspěvky ostatních","Autor doporučuje příspěvky ostatních","Autor nedoporučuje žádné příspěvky jiných autorů",1,"ot1=$ot1&ot2=$ot2&ot3=$ot3&pg","ot1=$ot1&ot2=$ot2&ot3=$ot3&pg","Další příspěvky","novější","starší","Další příspěvky","novější","starší",$refn1); break; case 91: case 92: case 93: case 94: case 95: case 96: case 97: ShowList1($pg,$maxart1,"a5",$ot1,$ot2,$cntsql,$cntsql,$cntsql,$rep,1,0,"","Autor si uložil tyto příspěvky ostatních","Autor si uložil tyto příspěvky ostatních","Autor si uložil tyto příspěvky ostatních","Autor si uložil tyto příspěvky ostatních","Autor si neuložil žádné příspěvky jiných autorů",1,"ot1=$ot1&ot2=$ot2&ot3=$ot3&pg","ot1=$ot1&ot2=$ot2&ot3=$ot3&pg","Další příspěvky","novější","starší","Další příspěvky","novější","starší",$refn1); break; case 101: case 102: case 103: case 104: case 105: case 106: case 107: ShowList1($pg,$maxart1,"a6",$ot1,$ot2,$cntsql,$cntsql,$cntsql,$rep,1,0,"","Ostatní doporučují tyto příspěvky autora","Ostatní doporučují tyto příspěvky autora","Ostatní doporučují tyto příspěvky autora","Ostatní doporučují tyto příspěvky autora","Ostatní zatím nedoporučují žádné příspěvky autora",1,"ot1=$ot1&ot2=$ot2&ot3=$ot3&pg","ot1=$ot1&ot2=$ot2&ot3=$ot3&pg","Další příspěvky","novější","starší","Další příspěvky","novější","starší",$refn1); break; case 111: case 112: case 113: case 114: case 115: case 116: case 117: ShowList1($pg,$maxart1,"a7",$ot1,$ot2,$cntsql,$cntsql,$cntsql,$rep,1,0,"","Ostatní si uložili tyto příspěvky autora","Ostatní si uložili tyto příspěvky autora","Ostatní si uložili tyto příspěvky autora","Ostatní si uložili tyto příspěvky autora","Ostatní zatím neuložili žádné příspěvky autora",1,"ot1=$ot1&ot2=$ot2&ot3=$ot3&pg","ot1=$ot1&ot2=$ot2&ot3=$ot3&pg","Další příspěvky","novější","starší","Další příspěvky","novější","starší",$refn1); break; } } //not SQL error ?>
0 || $IsUsr34>0) { echo "
Chci změnit, nebo upravit údaje"; } } break; case 510: // TADY JE STAV KDY SE ZOBRAZI FORMULAR PRO ZPRAVU PRO UZIVATELE, KTERY NENI ZAREGISTROVAN, ABY MOHL NAPSAT AUTOROVI ************* ?>
Pokud chcete poslat zprávu, musíte být prihlášeni.
Vpravo nahore vyplnte jméno a heslo, prípadne se zaregistrujte. Jestli máte problém s registrací, ozvete se nám na redakce@totem.cz.
0 || $IsUsr34>0) { echo "Chci změnit, nebo upravit údaje o sobě"; } } break; case 530: { echo "Brzy se zde objeví nová verze redakční stránky..."; //Fotky z akci } break; case 540: { echo "Brzy se zde objeví nová verze redakční stránky..."; //Jazz } break; case 550: { echo "Brzy se zde objeví nová verze redakční stránky..."; //Salmovska } break; case 600: { echo "Jednotlivá čísla časopisu..."; } break; case 31: case 32: case 33: case 35: { if (strLen($tfil1)>0) $fil1="&tfil1=".$tfil1; //nastavi filtr podle jmena if (strLen($tfil2)>0) $fil1.="&tfil2=".$tfil2; //nastavi filtr podle jmena switch ($ot1) { // VYPISOVANI VLASTNICH POZNAMEK OPRO OSTATNI UZIVATELE //case 31: $sql="SELECT opinions.id FROM opinions,articles,slots // WHERE articles.aselect<>13 AND opinions.about<>1538 AND (opinions.note<>'' OR opinions.verdict>0) AND articles.idsort>2 AND articles.idsort<5 AND articles.adate5<='$rdate' AND opinions.about=articles.IDA AND (articles.IDSnum=slots.idsnum OR articles.IDSnum=slots.idsthread) "; // if (strLen($tfil1)>0) $sql.="AND UCASE(users.uusername) LIKE UCASE('$tfil1') "; // if (strLen($tfil2)>0) $sql.="AND opinions.note LIKE '%$tfil2%' "; case 31: $sql="SELECT opinions.tip,opinions.id,opinions.IDU,opinions.about,opinions.note,opinions.verdict,opinions.datestamp,users.uusername,users.uface,users.udatereg,users.udatelast,users.uintroduce,users.uvirtlife,users.urights,users.uage,users.usex,articles.atitle FROM opinions,users,articles WHERE articles.aselect<>13 AND articles.idsort>2 AND articles.idsort<5 AND articles.adate5<='$rdate' AND (opinions.note<>'' OR opinions.verdict>0) AND opinions.IDU=users.IDU AND opinions.about=articles.IDA"; if (strLen($tfil1)>0) $sql.=" AND UCASE(users.uusername) LIKE UCASE('$tfil1') "; if (strLen($tfil2)>0) $sql.=" AND opinions.note LIKE '%$tfil2%' "; break; case 32: $sql="SELECT opinions.tip,opinions.id,opinions.IDU,opinions.about,opinions.note,opinions.verdict,opinions.datestamp,users.uusername,users.uface,users.udatereg,users.udatelast,users.uintroduce,users.uvirtlife,users.urights,users.uage,users.usex,articles.atitle FROM opinions,articles,users WHERE articles.aselect<>13 AND articles.idsort>2 AND articles.idsort<5 AND articles.adate5<='$rdate' AND (opinions.note<>'' OR opinions.verdict>0) AND opinions.IDU=$whoisid AND opinions.IDU=users.IDU AND opinions.about=articles.IDA"; if (strLen($tfil2)>0) $sql.=" AND opinions.note LIKE '%$tfil2%' "; break; case 33: $sql="SELECT opinions.tip,opinions.id,opinions.IDU,opinions.about,opinions.note,opinions.verdict,opinions.datestamp,users.uusername,users.uface,users.udatereg,users.udatelast,users.uintroduce,users.uvirtlife,users.urights,users.uage,users.usex,articles.atitle FROM opinions,articles,users WHERE articles.aselect<>13 AND articles.idsort>2 AND articles.idsort<5 AND articles.adate5<='$rdate' AND (opinions.note<>'' OR opinions.verdict>0) AND articles.IDU=$whoisid AND opinions.IDU=users.IDU AND opinions.about=articles.IDA"; if (strLen($tfil1)>0) $sql.=" AND UCASE(users.uusername) LIKE UCASE('$tfil1') "; if (strLen($tfil2)>0) $sql.=" AND opinions.note LIKE '%$tfil2%' "; break; // VYPISOVANI VLASTNICH POZNAMEK OPRO OSTATNI UZIVATELE case 35: $sql="SELECT opinions.tip,opinions.id,opinions.IDU,opinions.about,opinions.note,opinions.verdict,opinions.datestamp,users.uusername,users.uface,users.udatereg,users.udatelast,users.uintroduce,users.uvirtlife,users.urights,users.uage,users.usex,articles.atitle FROM opinions,articles,users WHERE articles.aselect<>13 AND articles.idsort>2 AND articles.idsort<5 AND articles.adate5<='$rdate' AND (opinions.note<>'' OR opinions.verdict>0) AND opinions.IDU=$ot2 AND opinions.IDU=users.IDU AND opinions.about=articles.IDA"; // if ($ot2>0) $sql.="AND opinions.IDU=$ot2 "; break; } /*if ($ot1==31) $sql="SELECT opinions.id,opinions.IDU,opinions.note,opinions.verdict,opinions.ouname,opinions.ouemail,articles.IDA,articles.atitle,articles.asigngrf,articles.acounter,articles.acntvote,articles.averdict,users.uusername,slots.sname,articles.sale,articles.adate5 FROM articles,users,slots,opinions WHERE opinions.about=articles.IDA AND articles.IDS1=slots.IDS AND articles.idsort>2 AND articles.idsort<5 AND articles.adate5<='$rdate' AND (opinions.note<>'' OR opinions.verdict>0) AND opinions.IDU=users.IDU"; // AND articles.asigngrf<>'' AND slots.sforgallery=1 AND articles.gallery=1 elseif ($ot1==32) $sql="SELECT opinions.id,opinions.IDU,opinions.note,opinions.verdict,opinions.ouname,opinions.ouemail,articles.IDA,articles.atitle,articles.asigngrf,articles.acounter,articles.acntvote,articles.averdict,users.uusername,slots.sname,articles.sale,articles.adate5 FROM articles,users,slots,opinions WHERE opinions.IDU=$whoisid AND opinions.about=articles.IDA AND articles.IDS1=slots.IDS AND articles.idsort>2 AND articles.idsort<5 AND articles.adate5<='$rdate' AND (opinions.note<>'' OR opinions.verdict>0) AND opinions.IDU=users.IDU"; //AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' elseif ($ot1==33) $sql="SELECT opinions.id,opinions.IDU,opinions.note,opinions.verdict,opinions.ouname,opinions.ouemail,articles.IDA,articles.atitle,articles.asigngrf,articles.acounter,articles.acntvote,articles.averdict,users.uusername,slots.sname,articles.sale,articles.adate5 FROM articles,users,slots,opinions WHERE articles.IDU=$whoisid AND opinions.about=articles.IDA AND articles.IDS1=slots.IDS AND articles.idsort>2 AND articles.idsort<5 AND articles.adate5<='$rdate' AND (opinions.note<>'' OR opinions.verdict>0) AND opinions.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' elseif ($ot1==35) $sql="SELECT opinions.id,opinions.IDU,opinions.note,opinions.verdict,opinions.ouname,opinions.ouemail,articles.IDA,articles.atitle,articles.asigngrf,articles.acounter,articles.acntvote,articles.averdict,users.uusername,slots.sname,articles.sale,articles.adate5 FROM articles,users,slots,opinions WHERE opinions.IDU=$ot2 AND opinions.about=articles.IDA AND articles.IDS1=slots.IDS AND articles.idsort>2 AND articles.idsort<5 AND articles.adate5<='$rdate' AND (opinions.note<>'' OR opinions.verdict>0) AND opinions.IDU=users.IDU"; //AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' if (IsSet($C100)) $sql=$sql." AND articles.sale>0"; //echo "CNT:".$cntslt; $sqluo.=" ORDER BY articles.adate5 DESC LIMIT $minart1,$maxart2"; */ //include "inc/slotscheck.php"; $sql.=" ORDER BY opinions.datestamp DESC"; // LIMIT $minart1,$maxart2"; //AND articles.IDA=opinions.about $sql.=" LIMIT $minopi1,$maxopi2"; //if ($whoisid==2) echo "SQL:".$sql; //echo "Dočasně byla tato funkce zrušena, ale brzy ji zase obnovíme...Děkujeme za pochopení."; mysql_select_db("totem"); $repuo = mysql_query($sql); if (!$repuo) { echo "Doslo k chybe 1!!!"; break; } else { // echo "SQL:".$sql; $cntrows = MySQL_NumRows($repuo); $maxo1=$maxopi1*($pg-1); $maxo2=$maxopi1*($pg); // echo "
"; echo ""; switch ($ot1) { case 31: echo "
"; echo ""; ?>
Vyhledat poznámky podle:
1.Přezdívky: 2.Obsahující slovo:

Další poznámky: ",$sname1); break; case 32: echo "
"; echo ""; ?>
Vyhledat poznámky podle:
1.Přezdívky: 2.Obsahující slovo:

Další poznámky: ",$sname1); break; case 33: echo "
"; echo ""; ?>
Vyhledat poznámky podle:
1.Přezdívky: 2.Obsahující slovo:

"; } } //case 0: break; case 100: { echo "Zde bude nápověda"; } break; case 11: case 12: case 13: case 14: case 15: case 16: case 17: default: { $adate=Date("Y-m-d H:i:s"); $cntparts=0; if ($pg==1) { // TED SE BUDE RESIT JESTLI TISKNOUT UVODNIIIIIIIIIIIIIKKKKKKKKKKKKKKKKKKKKKKKKKK*************************** if ($sintroord>0) { echo "
"; // TABULKA ROZDELUJICI VRCHNI CAST NA CAST PRO UVODNIK A CAST PRO VYBRANE POTAZMO ANKETU //echo "AKTSLT:".$aktslt; $sqlintro = "SELECT srctxt.srctext FROM articles,srctxt WHERE articles.IDT=srctxt.IDT AND articles.IDSnum=$aktslt AND articles.aselect=5 AND articles.idsort=4 AND articles.idstate>2 ORDER BY articles.adate2 DESC,articles.adate1 DESC"; mysql_select_db("totem"); $repintro = mysql_query( $sqlintro); // echo "SQL:".$sqlintro; if (!$repintro) { echo "Doslo k chybe pri pristupu k tabulce Prispevku"; break; } else { $cntintroes = MySQL_NumRows($repintro); // ZJISTI POCET OBDRZENYCH RADKU if ($cntintroes>0) { // TADY SE ZPRACUJE TEN DANY UVODNIK $arrbody = MySQL_Fetch_Array($repintro); $showbody=$arrbody["srctext"]; $showbody=StripSlashes($showbody); if ($findPos = StrPos($showbody,"[ANKETA")) { $body2= Ereg_replace("(.*)\[ANKETA ID=([0-9]+)\](.*)","\\2","$showbody"); $pollFile="./allpolls/".$body2.".html"; if (File_Exists($pollFile)) { $fo=FOpen($pollFile,"r"); $createUI=FRead($fo, FileSize($pollFile)); FClose($fo); $showbody= Ereg_replace("(.*)\[ANKETA ID=([0-9]+)\]([^\[ANKETA ID=]*)","\\1".$createUI."\\3","$showbody"); } else { include "phppolls/phpPollConfig.php3"; include "phppolls/phpPollUI.php3"; $showbody=CheckForPoll($showbody); } } echo $showbody; // $cntparts++; } else echo " 
"; } echo "
"; } //UVODNIK K SOUTEZIM if ($aktsltord>1000000 && $aktsltord<3000000) { echo "
"; $sqlintro = "SELECT srctxt.srctext FROM articles,srctxt WHERE articles.IDT=srctxt.IDT AND articles.IDS1 LIKE 'con' AND articles.aselect=5 AND articles.idsort=4 AND articles.idstate>2 ORDER BY articles.adate2 DESC,articles.adate1 DESC"; mysql_select_db("totem"); $repintro = mysql_query( $sqlintro); // echo "SQL:".$sqlintro; if (!$repintro) { echo "Doslo k chybe pri pristupu k tabulce Prispevku"; break; } else { $cntintroes = MySQL_NumRows($repintro); // ZJISTI POCET OBDRZENYCH RADKU if ($cntintroes>0) { // TADY SE ZPRACUJE TEN DANY UVODNIK $arrbody = MySQL_Fetch_Array($repintro); $showbody=$arrbody["srctext"]; $showbody=StripSlashes($showbody); if ($findPos = StrPos($showbody,"[ANKETA")) { $body2= Ereg_replace("(.*)\[ANKETA ID=([0-9]+)\](.*)","\\2","$showbody"); $pollFile="./allpolls/".$body2.".html"; if (File_Exists($pollFile)) { $fo=FOpen($pollFile,"r"); $createUI=FRead($fo, FileSize($pollFile)); FClose($fo); $showbody= Ereg_replace("(.*)\[ANKETA ID=([0-9]+)\]([^\[ANKETA ID=]*)","\\1".$createUI."\\3","$showbody"); } else { include "phppolls/phpPollConfig.php3"; include "phppolls/phpPollUI.php3"; $showbody=CheckForPoll($showbody); } } echo $showbody; // $cntparts++; } else echo " 
"; } echo "
"; } // *** VYBRANE *** PRISPEVKY V RUBRICEEEEEEEEE********************************************************************************* if ($sordselect==400) { //PROVEDE SELECT Z DANE RUBRIKY A JEJICH PODRUBRIK $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.ahasnote,articles.atip,articles.asave FROM articles,users,slots WHERE articles.IDU=users.IDU"; //articles.IDS1=slots.IDS AND $sql.=" AND articles.IDSnum=slots.IDSnum AND ((articles.aselect=1 OR articles.aselect=3) OR (articles.aselect=2 OR articles.aselect=3)) AND articles.IDA<>articles.collection AND articles.idsort=4 AND articles.idstate>2 AND articles.adate2<'$adate' AND articles.adate3>'$adate' "; include "inc/slotscheck.php"; $sql.=" ORDER BY articles.adate5 DESC,articles.adate1 DESC LIMIT $minart1,$maxart1"; mysql_select_db("totem"); $repshow3 = mysql_query( $sql); $cntshow3 = MySQL_NumRows($repshow3); // if ($whoisid==2) echo "CNT1:".$cntshow1." CNT2:".$cntshow2." CNT3:".$cntshow3."SQL:".$sql; if ($aktslt==$baseslot) ShowList1($pg,$maxselart,"s0",$ot1,$ot2,$cntshow3,$cntshow3,$cntshow3,$repshow3,1,0,"","Vybrané příspěvky","Vybrané příspěvky","Vybrané příspěvky","Vybrané příspěvky","Žádné vybrané příspěvky",0,"ot1=16".$os1."&pg","ot1=16".$os1."&pg","Další příspěvky","novější","starší","Další příspěvky","novější","starší",$refs1); else ShowList1($pg,$maxvotart,"s1",$ot1,$ot2,$cntshow3,$cntshow3,$cntshow3,$repshow3,1,0,"","Vybrané příspěvky","Vybrané příspěvky","Vybrané příspěvky","Vybrané příspěvky","Žádné vybrané příspěvky",0,"ot1=16".$os1."&pg","ot1=16".$os1."&pg","Další příspěvky","novější","starší","Další příspěvky","novější","starší",$refs1); // echo "
"; } // *** VYBRANE *** PRISPEVKY ALE DEMOKRATICKYM HLASOVANIM V RUBRICEEEEE**************************************************************** if ($svoteord==400) { // PROVEDE SELECT Z DANE RUBRIKY A JEJICH PODRUBRIK $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.ahasnote,articles.atip,articles.asave FROM articles,users,slots WHERE articles.IDU=users.IDU"; //AND articles.IDS1=slots.IDS $sql.=" AND articles.IDSnum=slots.IDSnum AND articles.IDA<>articles.collection AND articles.aselect<5 AND articles.idsort=4 AND articles.idstate>2 AND articles.adate2<'$adate' AND articles.adate3>'$adate' AND articles.averdict>0 AND articles.IDA>$VoteFrom AND articles.acntvote>=$minvote AND articles.averdict<=$minnumvote "; include "inc/slotscheck.php"; $sql.=" ORDER BY articles.adate5 DESC,articles.adate1 DESC LIMIT $minart1,$maxart1"; // echo "SQL:".$sql; mysql_select_db("totem"); $repshow3 = mysql_query( $sql); $cntshow3 = MySQL_NumRows($repshow3); // echo "CNTVOTE:".$cntshow3; ShowList1($pg,$maxvotart,"v1",$ot1,$ot2,$cntshow3,$cntshow3,$cntshow3,$repshow3,1,0,"","Nejlépe hodnocené příspěvky","Nejlépe hodnocené příspěvky","Nejlépe hodnocené příspěvky","Nejlépe hodnocené příspěvky","Žádné ohodnocené příspěvky",0,"ot1=17".$os1."&pg","ot1=17".$os1."&pg","Další příspěvky","novější","starší","Další příspěvky","novější","starší",$refv1); } } //prvni strana echo ""; ?>
2 AND articles.adate2<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' if (IsSet($C100)) $sql=$sql." AND articles.sale>0"; include "inc/slotscheck.php"; $sql=$sql." AND articles.IDS1=slots.IDS ORDER BY articles.acounter DESC,articles.averdict ASC LIMIT $minart1,$maxart2"; } elseif ($ot1==13) { $sql="SELECT users.uusername,users.uage,users.uvirtlife,users.uintroduce,users.urights,users.udatereg,users.udatelast,slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots WHERE articles.aselect<5 AND articles.idsort=4 AND articles.idstate>2 AND articles.adate2<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' if (IsSet($C100)) $sql=$sql." AND articles.sale>0"; include "inc/slotscheck.php"; $sql=$sql." AND articles.IDS1=slots.IDS ORDER BY articles.ahasnote DESC,articles.acounter DESC LIMIT $minart1,$maxart2"; } elseif ($ot1==14) { $sql="SELECT users.uusername,users.uage,users.uvirtlife,users.uintroduce,users.urights,users.udatereg,users.udatelast,slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots WHERE articles.aselect<5 AND articles.idsort=4 AND articles.idstate>2 AND articles.adate2<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; //AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' if (IsSet($C100)) $sql=$sql." AND articles.sale>0"; include "inc/slotscheck.php"; $sql=$sql." AND articles.IDS1=slots.IDS ORDER BY articles.atip DESC,articles.acounter DESC LIMIT $minart1,$maxart2"; } elseif ($ot1==15) { $sql="SELECT users.uusername,users.uage,users.uvirtlife,users.uintroduce,users.urights,users.udatereg,users.udatelast,slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots WHERE articles.aselect<5 AND articles.idsort=4 AND articles.idstate>2 AND articles.adate2<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' AND articles.averdict>0 if (IsSet($C100)) $sql=$sql." AND articles.sale>0"; include "inc/slotscheck.php"; $sql=$sql." AND articles.IDS1=slots.IDS ORDER BY articles.asave DESC,articles.acounter DESC LIMIT $minart1,$maxart2"; } elseif ($ot1==16) { $sql="SELECT users.uusername,users.uage,users.uvirtlife,users.uintroduce,users.urights,users.udatereg,users.udatelast,slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots WHERE articles.aselect<5 AND articles.idsort=4 AND articles.idstate>2 AND articles.averdict>0 AND articles.adate2<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' if (IsSet($C100)) $sql=$sql." AND articles.sale>0"; include "inc/slotscheck.php"; $sql=$sql." AND articles.IDS1=slots.IDS ORDER BY articles.averdict DESC,articles.acounter DESC LIMIT $minart1,$maxart2"; } elseif ($ot1==17) { $sql="SELECT users.uusername,users.uage,users.uvirtlife,users.uintroduce,users.urights,users.udatereg,users.udatelast,slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots WHERE articles.aselect<5 AND articles.idsort=4 AND articles.idstate>2 AND articles.averdict>0 AND articles.adate2<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' if (IsSet($C100)) $sql=$sql." AND articles.sale>0"; include "inc/slotscheck.php"; $sql=$sql." AND articles.IDS1=slots.IDS ORDER BY articles.avotesum DESC,articles.acounter DESC LIMIT $minart1,$maxart2"; } elseif ($ot1==41) { $sql="SELECT users.uusername,users.uage,users.uvirtlife,users.uintroduce,users.urights,users.udatereg,users.udatelast,slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots WHERE articles.aselect=12 AND articles.collection=articles.IDA AND articles.idsort>2 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; //AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' AND articles.IDS1=slots.IDS AND // $sql="SELECT articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip FROM articles WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate'"; //AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' AND articles.IDS1=slots.IDS AND if (IsSet($C100)) $sql=$sql." AND articles.sale>0"; include "inc/slotscheck.php"; $sql=$sql." AND articles.IDS1=slots.IDS ORDER BY articles.adate5 DESC LIMIT $minart1,$maxart2"; } elseif ($ot1==42) { $sql="SELECT users.uusername,users.uage,users.uvirtlife,users.uintroduce,users.urights,users.udatereg,users.udatelast,slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots WHERE articles.aselect=12 AND articles.collection=articles.IDA AND articles.idsort>2 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' if (IsSet($C100)) $sql=$sql." AND articles.sale>0"; include "inc/slotscheck.php"; $sql=$sql." AND articles.IDS1=slots.IDS ORDER BY articles.acounter DESC,articles.averdict ASC LIMIT $minart1,$maxart2"; } elseif ($ot1==43) { $sql="SELECT users.uusername,users.uage,users.uvirtlife,users.uintroduce,users.urights,users.udatereg,users.udatelast,slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots WHERE articles.aselect=12 AND articles.idsort>2 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' if (IsSet($C100)) $sql=$sql." AND articles.sale>0"; include "inc/slotscheck.php"; $sql=$sql." AND articles.IDS1=slots.IDS ORDER BY articles.ahasnote DESC,articles.acounter DESC LIMIT $minart1,$maxart2"; } elseif ($ot1==44) { $sql="SELECT users.uusername,users.uage,users.uvirtlife,users.uintroduce,users.urights,users.udatereg,users.udatelast,slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots WHERE articles.aselect=12 AND articles.idsort>2 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; //AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' if (IsSet($C100)) $sql=$sql." AND articles.sale>0"; include "inc/slotscheck.php"; $sql=$sql." AND articles.IDS1=slots.IDS ORDER BY articles.atip DESC,articles.acounter DESC LIMIT $minart1,$maxart2"; } elseif ($ot1==45) { $sql="SELECT users.uusername,users.uage,users.uvirtlife,users.uintroduce,users.urights,users.udatereg,users.udatelast,slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots WHERE articles.aselect=12 AND articles.idsort>2 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' if (IsSet($C100)) $sql=$sql." AND articles.sale>0"; include "inc/slotscheck.php"; $sql=$sql." AND articles.IDS1=slots.IDS ORDER BY articles.asave DESC,articles.acounter DESC LIMIT $minart1,$maxart2"; } elseif ($ot1==46) { $sql="SELECT users.uusername,users.uage,users.uvirtlife,users.uintroduce,users.urights,users.udatereg,users.udatelast,slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots WHERE articles.aselect=12 AND articles.idsort>2 AND articles.idstate>2 AND articles.averdict>0 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' if (IsSet($C100)) $sql=$sql." AND articles.sale>0"; include "inc/slotscheck.php"; $sql=$sql." AND articles.IDS1=slots.IDS ORDER BY articles.averdict DESC,articles.acounter DESC LIMIT $minart1,$maxart2"; } elseif ($ot1==47) { $sql="SELECT users.uusername,users.uage,users.uvirtlife,users.uintroduce,users.urights,users.udatereg,users.udatelast,slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots WHERE articles.aselect=12 AND articles.idsort>2 AND articles.idstate>2 AND articles.avotesum>0 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; // AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' if (IsSet($C100)) $sql=$sql." AND articles.sale>0"; include "inc/slotscheck.php"; $sql=$sql." AND articles.IDS1=slots.IDS ORDER BY articles.avotesum DESC,articles.acounter DESC LIMIT $minart1,$maxart2"; } else { $sql="SELECT users.uusername,users.uage,users.uvirtlife,users.uintroduce,users.urights,users.udatereg,users.udatelast,slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.aselect,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots WHERE articles.aselect<5 AND articles.idsort=4 AND articles.idstate>2 AND articles.adate2<='$rdate' AND articles.adate3>'$rdate' AND articles.IDU=users.IDU"; //AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' AND articles.IDS1=slots.IDS AND articles.IDSnum=slots.idsnum // $sql="SELECT articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,articles.sname,articles.IDSnum,articles.ahasnote,articles.atip FROM articles WHERE articles.aselect<5 AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<='$rdate' AND articles.adate3>'$rdate'"; //AND slots.sforgallery=1 AND articles.gallery=1 AND articles.asigngrf<>'' AND articles.IDS1=slots.IDS AND if (IsSet($C100)) $sql=$sql." AND articles.sale>0"; include "inc/slotscheck.php"; $sql=$sql." AND articles.IDSnum=slots.idsnum ORDER BY articles.adate2 DESC LIMIT $minart1,$maxart2"; } //echo "SQL:".$sql; mysql_select_db("totem");$rep = mysql_query( $sql); if (!$rep) { echo "Doslo k chybe pri cteni dat z DB !!!:"; } else { $cntsql= MySQL_NumRows($rep); if ($ot1==41 || $ot1==42 || $ot1==43 || $ot1==44 || $ot1==45 || $ot1==46 || $ot1==47) { ShowList1($pg,$maxart1,"c1",$ot1,$ot2,$cntsql,$cntsql,$cntsql,$rep,1,0,"","Kolekce v rubrikách","Nové kolekce v rubrikách","Kolekce v rubrice","Nové kolekce v rubrice","Žádné nové kolekce",1,"ot1=$ot1".$os1."&pg","ot1=$ot1".$os1."&pg","Další kolekce","novější","starší","Další kolekce","novější","starší",$refn1); } else { switch ($ot1) { case 11: $newer="novější"; $older="starší"; break; case 12: $newer="předchozí"; $older="další"; break; case 13: $newer="více poznámek"; $older="méně poznámek"; break; case 14: $newer="předchozí"; $older="další"; break; case 15: $newer="předchozí"; $older="další"; break; case 16: $newer="předchozí"; $older="další"; break; case 17: $newer="předchozí"; $older="další"; break; } ShowList1($pg,$maxart1,"a1",$ot1,$ot2,$cntsql,$cntsql,$cntsql,$rep,1,0,"","Příspěvky vybrané redakcí","Příspěvky vybrané redakcí","Příspěvky vybrané redakcí","Příspěvky vybrané redakcí","Příspěvky vybrané redakcí",1,"ot1=$ot1".$os1."&pg","ot1=$ot1".$os1."&pg","Další příspěvky",$newer,$older,"Další příspěvky",$newer,$older,$refn1); } } //not SQL error if ($pg==1) { // *** NEJDOPORUCOVANEJSI *** PRISPEVKY V RUBRICEEEEEEEEE********************************************************************************* $HowTipOld1=30; /* //if ($sordselect==400) //{ //PROVEDE SELECT Z DANE RUBRIKY A JEJICH PODRUBRIK $sql="SELECT DISTINCT slots.sdate2start,slots.sdate3stop,slots.sdate4vote,slots.sdate5end,slots.sorder,articles.IDA,articles.IDS1,articles.atitle,articles.aintro,articles.asigngrf,articles.IDU,articles.idstate,articles.idsort,articles.adate2,articles.adate3,articles.adate5,articles.collection,articles.acounter,articles.acntvote,articles.averdict,users.uusername,articles.sname,articles.ahasnote,articles.atip,articles.asave,articles.avotesum FROM articles,users,slots WHERE articles.IDU=users.IDU"; //articles.IDS1=slots.IDS AND $sql.=" AND articles.IDSnum<>79 AND articles.IDSnum=slots.IDSnum AND articles.aselect<5 AND articles.IDA<>articles.collection AND articles.idsort>2 AND articles.idsort<5 AND articles.idstate>2 AND articles.adate5<'$adate' AND articles.adate3>'$adate' "; include "inc/slotscheck.php"; $sql.=" AND articles.atip>0 AND (TO_DAYS(articles.adate5) >= (TO_DAYS(NOW()) - $HowTipOld1)) ORDER BY articles.atip DESC,articles.adate5 DESC LIMIT $minart1,$maxart1"; mysql_select_db("totem"); $repshow3 = mysql_query( $sql); $cntshow3 = MySQL_NumRows($repshow3); // if ($whoisid==2) echo "CNT1:".$cntshow1." CNT2:".$cntshow2." CNT3:".$cntshow3."SQL:".$sql; echo "
"; if ($aktslt==$baseslot) ShowList1($pg,$maxselart,"s0",$ot1,$ot2,$cntshow3,$cntshow3,$cntshow3,$repshow3,1,0,"","Nejvíce doporučované příspěvky za poslední měsíc","Nejvíce doporučované příspěvky za poslední měsíc","Nejvíce doporučované příspěvky za poslední měsíc","Nejvíce doporučované příspěvky za poslední měsíc","Žádné doporučované příspěvky",0,"ot1=16".$os1."&pg","ot1=16".$os1."&pg","Další příspěvky","novější","starší","Další příspěvky","novější","starší",$refs1); else ShowList1($pg,$maxvotart,"s1",$ot1,$ot2,$cntshow3,$cntshow3,$cntshow3,$repshow3,1,0,"","Nejvíce doporučované příspěvky za poslední měsíc","Nejvíce doporučované příspěvky za poslední měsíc","Nejvíce doporučované příspěvky za poslední měsíc","Nejvíce doporučované příspěvky za poslední měsíc","Žádné doporučované příspěvky",0,"ot1=16".$os1."&pg","ot1=16".$os1."&pg","Další příspěvky","novější","starší","Další příspěvky","novější","starší",$refs1); // echo "
"; //} */ // TED SE BUDE RESIT JESTLI TISKNOUT ZAVER*************************** if ($soutroord>40) { //echo "
"; //echo "GOGOGO"; $sqlintro = "SELECT srctext FROM articles,srctxt WHERE articles.IDT=srctxt.IDT AND articles.IDSnum=$aktslt AND articles.aselect=6 AND articles.idsort=4 AND articles.idstate>2 ORDER BY articles.adate2 DESC,articles.adate1 DESC"; mysql_select_db("totem"); $repintro = mysql_query( $sqlintro); if (!$repintro) { echo "Doslo k chybe pri pristupu k tabulce Prispevku"; break; } else { $cntintroes = MySQL_NumRows($repintro); // ZJISTI POCET OBDRZENYCH RADKU if ($cntintroes>0) { // TADY SE ZPRACUJE TEN DANY UVODNIK echo ""; echo ""; echo "
"; $arrbody = MySQL_Fetch_Array($repintro); $showbody=$arrbody["srctext"]; $showbody=StripSlashes($showbody); if ($findPos = StrPos($showbody,"[ANKETA")) { // include "phppolls/phpPollConfig.php3"; // include "phppolls/phpPollUI.php3"; $showbody=CheckForPoll($showbody); } if ($cntparts>0) echo "
"; echo $showbody; echo "
"; } } } } //pg==1 // KONEC CASTI, KDE SE TISKNOU PRISPEVKY ?>
align=center> 1) echo "«Předchozí "; if (($pg>1) || ($cntsql>$maxart1)) echo "   Další příspěvky   "; if ($cntsql>$maxart1) echo " Následující»"; */ ?>
align=center> $mname3
"; ?>
"; } //case 0: break; } //switch ?>
"; ?>           0) require("bill-ban3.inc"); ?>   0) echo $time2." - ".$time1."=".$time2-$time1; ?>
free web hit counter