$sql

"; } function prepareMouseGIF ($gifname,$gifpath,$x,$y) { print "". "\n"; } function printMouseGIF ($gifname,$gifpath,$x,$y,$id,$onClick,$href="",$alt="",$additional="") { print makeMouseGIF ($gifname,$gifpath,$x,$y,$id,$onClick,$href,$alt,$additional); } function makeMouseGIF ($gifname,$gifpath,$x,$y,$id,$onClick,$href="",$alt="",$additional="") { $vystup= "". ""; return $vystup; } function printtryint ($cislo) {print maketryint ($cislo);} function maketryint ($cislo) { if (floor($cislo)==$cislo) return floor($cislo); else return $cislo; } function makeworddate($to_datum,$def_lang="") { if (!$def_lang) { global $default_language; $def_lang=$default_language; } if (!$def_lang) $def_lang="cz"; $mesice["cz"]=array("ledna","února","března","dubna","května","června","července","srpna","září","října","listopadu","prosince"); $mesice["en"]=array("January","February","March","April","May","June","July","August","Septembre","Octobre","Novembre","Decembre"); $mesice["fr"]=array("janvier","février","mars","avril","mai","juin","juillet","aoűt","septembre","octobre","novembre","décembre"); if ($to_datum!="" && $to_datum!=0) switch ($def_lang) { case "cz": return date("j",$to_datum).". ".$mesice[$def_lang][date("m",$to_datum)-1]." ".date("Y",$to_datum);break; case "en": return $mesice[$def_lang][date("m",$to_datum)-1]." ".date("j",$to_datum)." ".date("Y",$to_datum);break; case "fr": return date("j",$to_datum)." ".$mesice[$def_lang][date("m",$to_datum)-1]." ".date("Y",$to_datum);break; } else return ""; } function printworddate($to_datum) { print makeworddate($to_datum); } function makeWordDateTime($to_datum) { $mesice=array("ledna","února","března","dubna","května","června","července","srpna","září","října","listopadu","prosince"); if ($to_datum!="" && $to_datum!=0) return date("j",$to_datum).". ".$mesice[date("m",$to_datum)-1]." ".date("Y",$to_datum)." ".date("H:i",$to_datum); else return ""; } function printWordDateTime($to_datum) { print makeWordDateTime($to_datum); } function makedate($to_datum) { if ($to_datum!="" && $to_datum!=0) return date("j",$to_datum).".".(date("m",$to_datum)/1).".".date("Y",$to_datum); else return ""; } function printdate($to_datum) { print makedate($to_datum); } function makemailto($adresa,$jmeno="") { if ($jmeno=="") $jmeno=$adresa; if ($adresa!="") return "".$jmeno.""; else return ""; } function makehref($adresa,$target="",$text="",$class="") { if (!$text)$text=$adresa; if ($class) $class="class=\"$class\""; if ($adresa!="") return "$text"; else return $text; } function printhref($adresa,$target="",$text="",$class="") { print makehref($adresa,$target,$text); } function printmailto($adresa,$jmeno="") { print makemailto($adresa,$jmeno); } function makenbsp($text="") { if ($text!="") return $text; else return " "; } function printnbsp($text="") { print makenbsp($text); } function makered($text) { if ($text!="") return "$text"; } function printred($text) { print makered($text); } function maketag($text,$tag,$details="") { if ($text!="") if ($tag!="") return "<$tag $details>$text"; else return "$text"; } function printtag($text,$tag,$details="") { print maketag($text,$tag,$details); } function makefillby ($text,$fillby,$kolik,$strana) //$strana ... "r" nebo "l" tradicne: fillby ($id,"0",3,"l") { $rozdil = $kolik-strlen($text); while ($rozdil>0) { if (strtolower($strana)=="r") $text=$text.$fillby; if (strtolower($strana)=="l") $text=$fillby.$text; $rozdil--; } return $text; } function makefillby3 ($text) { return makefillby ($text,"0",3,"l");} function makefillby4 ($text) { return makefillby ($text,"0",4,"l");} function printfillby ($text,$fillby,$kolik,$strana) { print (makefillby ($text,$fillby,$kolik,$strana)); } // ------- vypustit, az bude vymiceno -------- function fillby ($text,$fillby,$kolik,$strana) //$strana ... "r" nebo "l" tradicne: fillby ($id,"0",3,"l") { return makefillby ($text,$fillby,$kolik,$strana); } function printfill ($text,$fillby,$kolik,$strana) { print (makefillby ($text,$fillby,$kolik,$strana)); } // ------ konec vypustky ---------- function makesubstr($text,$mala,$limit) { $outtext=""; if ($mala<$limit && strlen($text)>$mala) $outtext=""; if (strlen($text)>$limit) $outtext=$outtext.substr($text,0,$limit).".."; else $outtext=$outtext.$text; if ($mala<$limit && strlen($text)>$mala) $outtext=$outtext.""; return $outtext; } function printsubstr ($text,$mala,$limit) { print (makesubstr($text,$mala,$limit)); } function makecenavel ($castka,$mena,$starttag,$stoptag,$vel) { if ($vel==2) { $celkova_sirka=117;$cena_sirka=80;$mena_sirka=37; } else if ($vel==3) { $celkova_sirka=147;$cena_sirka=105;$mena_sirka=42; } else if ($vel==1) { $celkova_sirka=104;$cena_sirka=65;$mena_sirka=30; } return "". "". "". "
$starttag".number_format($castka, 2, ',', ' ')." $stoptag$starttag ".$mena."$stoptag
"; } function printcenavel ($castka,$mena,$starttag,$stoptag,$vel) { print (makecenavel ($castka,$mena,$starttag,$stoptag,$vel)); } function makecena ($castka,$mena,$starttag,$stoptag) { return makecenavel ($castka,$mena,$starttag,$stoptag,2); } function printcena ($castka,$mena,$starttag,$stoptag) { print (makecena ($castka,$mena,$starttag,$stoptag)); } function makecenatimes ($castka,$mena,$starttag,$stoptag) { return makecena ($castka,$mena,$starttag."","".$stoptag); } function printcenatimes ($castka,$mena,$starttag,$stoptag) { print (makecenatimes ($castka,$mena,$starttag,$stoptag)); } function makekvantum ($kolik,$jedna,$dva_az_ctyri,$od_peti) { if (abs($kolik)==1) return $jedna; else if (abs($kolik)>=2 && abs($kolik)<=4) return $dva_az_ctyri; else return $od_peti; } function printkvantum ($kolik,$jedna,$dva_az_ctyri,$od_peti) { print makekvantum ($kolik,$jedna,$dva_az_ctyri,$od_peti); } function printMetaRefresh ($TimeOut,$TheURL) { print makeMetaRefresh ($TimeOut,$TheURL);} function makeMetaRefresh ($TimeOut,$TheURL) { return "\n"; } function printMetaCharset ($Charset) { print makeMetaCharset ($Charset);} function makeMetaCharset ($Charset) { return "\n"; } function makeHead ($Charset,$title,$StyleSheet,$RefreshTimeOut=0,$RefreshTheURL="", $body_properties="") //,$bodyTOPMARGIN,$bodyLEFTMARGIN { $ret= "\n"; $ret.= "\n"; if ($Charset!="") $ret.=makeMetaCharset ($Charset); if ($RefreshTheURL!="") $ret.=makeMetaRefresh ($RefreshTimeOut,$RefreshTheURL); $ret.= "$title\n"; $ret.= "\n"; if ($StyleSheet!="") $ret.= "\n"; $ret.= "\n"; return $ret; } function printHead ($Charset,$title,$StyleSheet,$RefreshTimeOut=0,$RefreshTheURL="", $body_properties="") //,$bodyTOPMARGIN,$bodyLEFTMARGIN { print makeHead ($Charset,$title,$StyleSheet,$RefreshTimeOut,$RefreshTheURL,$body_properties); } function printZpatky ($adresa="") { print "Hned to bude... za chvíli bude stránka zpátky."; } function printChyba ($test="") { print makeChyba ($test); } function makeChyba ($test="") { return "Nastala nějaká chyba. $test
"; } function print2log ($test) { $f = fopen("log.txt","a"); global $PHP_SELF; fwrite ($f,date("Y-m-d H:i")." ".basename($PHP_SELF)." ".$test."\n\r"); } function printOtaznik ($text="") { print makeOtaznik ($text); } function makeOtaznik ($text="") { if (!empty($text) && $text>0) return "$text"; else return "?";} function makeNotNula ($text="") { if (!empty($text) && $text>0) return "$text"; else return "";} function printNotNula ($text="") { print makeNotNula ($text);} function printObdobi ($datum_narozeni,$datum_umrti) { print makeObdobi ($datum_narozeni,$datum_umrti); } function makeObdobi ($datum_narozeni,$datum_umrti) { if ($datum_narozeni+$datum_umrti) { return "(".makeOtaznik(makedate($datum_narozeni))." - ".makeOtaznik(makedate($datum_umrti)).")"; } return ""; } function printObdobiRoky ($rok_narozeni,$rok_umrti) { print makeObdobiRoky ($rok_narozeni,$rok_umrti); } function makeObdobiRoky ($rok_narozeni,$rok_umrti) { if ($rok_narozeni+$rok_umrti) { //if ($rok_narozeni) $out="(".makeOtaznik($rok_narozeni); if ($rok_umrti) $out.=" - ".makeOtaznik($rok_umrti); $out.=")"; } return $out; } function makeTD ($text,$align="",$width="",$details="") { return "".makenbsp($text)."";} function makeTR ($text,$color="", $details="") { if ($color) $color="bgcolor=\"$color\""; return maketag(makenbsp($text),"tr","$color $details"); } function printTD ($text,$align="",$width="",$details="") { print makeTD ($text,$align,$width,$details);} function printTR ($text,$color="",$details="") { print makeTR ($text,$color,$details);} function makeUpDownButtons($up_action,$down_action,$up_comment="Posuň nahoru",$down_comment="Posuň dolu") { $out=""; $out=$out.makeTR(makeTD(makehref($up_action,"","\"$up_comment\""))); $out=$out.makeTR(makeTD(makehref($down_action,"","\"$down_comment\""))); $out=$out."
"; return $out; } function printUpDownButtons($up_action,$down_action,$up_comment="Posuň nahoru",$down_comment="Posuň dolu") { print makeUpDownButtons($up_action,$down_action,$up_comment,$down_comment); } function makeTableHead ($width=12,$border="0",$details="") { return "";} function printTableHead ($width=12,$border="0",$details="") { print makeTableHead ($width,$border,$details);} function makeTableFoot () { return "
";} function printTableFoot () { print makeTableFoot ();} function makeZCyklu ($cyklus) { if ($cyklus!="") return " z cyklu $cyklus"; } function makeSelectArray ($input_name,$pole,$selected=0,$onChange="",$null_text="") { if (!count($pole)) $ret .= "žádné možnosti"; else if (count($pole)==1) { list($key,$value) = each ($pole); $ret .= "$value "; } else { $ret = ""; if ($null_text) $ret.=""; while (list($key,$value) = db_fetch_array ($result)) { if ($key=="#num;") $key=++$i; $ret .= ""; } $ret .= ""; } return $ret; } function printSelectResult ($input_name,$result,$selected=0,$onChange="",$details="",$null_text="") { print makeSelectResult ($input_name,$result,$selected,$onChange,$details,$null_text); } function makeSelectTable ($conn,$input_name,$table,$selected=0,$popis_field,$where="",$orderby="",$onChange="",$null_text="",$sql="") { if ($sql=="") { $sql = "select * from $table"; if ($where!="") $sql .= " where $where"; if ($orderby!="") $sql .= " order by $orderby"; } if ($res = db_query ($conn,$sql)) { if (db_num_rows($res)==0) $ret .= "žádné možnosti"; else if (db_num_rows($res)==1) { $row = db_fetch_array($res); if ($row) $ret .= "$row[$popis_field] "; } else { $ret = ""; else return ""; } function printFormEdit ($input_name,$value,$size="10",$rows="1",$extended="") { print makeFormEdit ($input_name,$value,$size,$rows,$extended); } function makeFormPassword ($input_name,$value="",$size="10",$extended="") { return "";} function printFormPassword ($input_name,$value="",$size="10",$extended="") { print makeFormPassword ($input_name,$value,$size,$extended); } function printFormCheckbox ($input_name,$value,$checked=true,$extended="") { print makeFormCheckbox ($input_name,$value,$checked,$extended); } function makeFormCheckbox ($input_name,$value,$checked=true,$extended="") { return ""; } function printFormHidden ($input_name,$value) { print makeFormHidden ($input_name,$value); } function makeFormHidden ($input_name,$value) { return ""; } function printFormRadio ($input_name,$value,$checked=true,$extended="") { print makeFormRadio ($input_name,$value,$checked,$extended); } function makeFormRadio ($input_name,$value,$checked=true,$extended="") { return ""; } function printFormButton ($input_name,$value,$extended="") { print makeFormButton ($input_name,$value,$extended); } function makeFormButton ($input_name,$value,$extended="") { return ""; } function printFormSubmit ($input_name,$value,$extended="") { print makeFormSubmit ($input_name,$value,$extended); } function makeFormSubmit ($input_name,$value,$extended="") { return ""; } function printVerticalText ($popis) { print makeVerticalText ($popis); } function makeVerticalText ($popis) { return ""; } function makeDateTime ($datum,$jazyk="cz") { if (ereg ("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})", $datum, $regs)) switch ($jazyk) { case "cz": default: return (int)$regs[3].".".(int)$regs[2].".$regs[1] $regs[4]:$regs[5]"; break; } else return $row->datum; } $gt=array(); $gt["FileManager"]["cz"]="Správce souborů"; $gt["FileManager"]["en"]="File manager"; $gt["DirectoryListing"]["cz"]="Výpis adresáře"; $gt["DirectoryListing"]["en"]="Directory listing"; $gt["velikost"]=array("cz"=>"velikost","en"=>"Size"); $gt["datum"]=array("cz"=>"datum","en"=>"Date"); $gt["filename"]=array("cz"=>"jméno souboru","en"=>"Filename"); $gt["CreateDir"]=array("cz"=>"Vytvoř adresář","en"=>"Create directory"); $gt["Send"]=array("cz"=>"Odeslat","en"=>"Send"); $gt["UploadFile"]=array("cz"=>"Vlož soubor","en"=>"Upload file"); $gt["NotEnoughRights"]=array("cz"=>"Nemáte potřebná práva pro tuto stránku.","en"=>"Not enough rights for this page, sorry."); $gt["Return"]=array("cz"=>"Vraťte se","en"=>"Go"); $gt["back"]=array("cz"=>"zpátky","en"=>"back"); $gt["ConnectionClosed"]=array("cz"=>"Spojení bylo přerušeno","en"=>"Connection closed"); $gt["Passive"]=array("cz"=>"neaktivní","en"=>"Passive for"); $gt["vsem"]=array("cz"=>"všem","en"=>"for all"); $gt["nastav"]=array("cz"=>"nastav","en"=>"set up"); $gt["challenge"]=array("cz"=>"Vyzvi mailem","en"=>"Challenge by mail"); $gt["reload"]=array("cz"=>"Aktualizuj","en"=>"Reload"); $gt["adresar_title"]=array("cz"=>"Adresy a telefony","en"=>"Addresses and phone numbers"); $gt["delete_row?"]=array("cz"=>"Chcete vymazat tuto položku?","en"=>"Are you sure to delete this row?"); $gt["jmeno"]=array("cz"=>"Jméno","en"=>"Name"); $gt["telefon"]=array("cz"=>"Telefon","en"=>"Phone"); $gt["e-mail"]=array("cz"=>"e-mail","en"=>"e-mail"); $gt["pozn"]=array("cz"=>"Pozn","en"=>"Note"); $gt["adresa"]=array("cz"=>"Adresa","en"=>"Address"); $gt["hl./nas."]=array("cz"=>"Hl./nás.","en"=>"Diagn."); $gt["zadne_polozky"]=array("cz"=>"Nebyly nalezeny žádné položky","en"=>"No available data"); $gt["SendMail"]=array("cz"=>"Pošli masáž","en"=>"Send message"); $gt["Send_again"]=array("cz"=>"Pošli znovu","en"=>"Send again"); $gt["sentdata"]=array("cz"=>"Odeslaná data","en"=>"Sent data"); $gt["MailNotSent"]=array("cz"=>"Mail nebyl odeslán","en"=>"Mail not sent"); $gt["komu"]=array("cz"=>"Komu","en"=>"To"); $gt["odesilatel"]=array("cz"=>"Odesilatel","en"=>"From"); $gt["kopie"]=array("cz"=>"Kopie","en"=>"Copy"); $gt["smazat"]=array("cz"=>"Smazat","en"=>"Reset"); $gt["login"]=array("cz"=>"Přihlášení","en"=>"Login"); $gt["heslo"]=array("cz"=>"Heslo","en"=>"Password"); $gt["connection"]=array("cz"=>"Spojení","en"=>"Connection"); $gt["add"]=array("cz"=>"Přidej","en"=>"Add"); $gt["NoServers"]=array("cz"=>"Žádný server nebyl definován","en"=>"No POP3 servers defined"); $gt["uplne"]=array("cz"=>"úplné","en"=>"total"); $gt["jen_pocet"]=array("cz"=>"jen počet","en"=>"only number"); $gt["spatne_heslo"]=array("cz"=>"Zadal/a jste špatné jméno/heslo.","en"=>"Bad password."); $gt["try_to_"]=array("cz"=>"Zkus se znovu","en"=>"Try to"); $gt["_login_again"]=array("cz"=>"přihlásit","en"=>"login again"); $gt["nech_si_heslo"]=array("cz"=>"Nechte si heslo","en"=>"Demand to "); $gt["poslat_mailem"]=array("cz"=>"poslat mailem","en"=>"send the password by e-mail"); $gt["login_result"]=array("cz"=>"Výsledek přihlášení","en"=>"Login result"); $gt["logged_in"]=array("cz"=>"Přihlášení proběhlo.","en"=>"You are logged in."); $gt["text_mailu_s_heslem"]["cz"]="Tady je to zapomenute heslo. Pokud jsi o nej nezadal/a, tak se nekdo hlasil do ". "chranych stranek Tvym jmenem. Heslo najdes o stranku niz.$endl$endl". "Hodne dusevniho zdravi preje PHP automat Bimbo.".$endl.$endl. "PS. Heslo se da zmenit na zalozce Nastaveni. "; $gt["text_mailu_s_heslem"]["en"]="Here is your forgotten password.$endl You will find it one page below. Bonne chance.".$endl.$endl. "You can change it at the site Personal after you login."; $gt["zapomenute_heslo"]=array("cz"=>"Zapomenute heslo","en"=>"Forgotten password"); $gt["connecting_to"]=array("cz"=>"Připojuje se","en"=>"Connecting to"); $gt["connected"]=array("cz"=>"připojeno","en"=>"connected"); $gt["not_connected_to"]=array("cz"=>"Problém s připojením k","en"=>"not connected to"); $gt["znaku"]=array("cz"=>"Znaků","en"=>"Chars"); $gt["pocet_zprav"]=array("cz"=>"Počet zpráv","en"=>"Number of new messages"); $gt["no_new_messages"]=array("cz"=>"Žádné nové zprávy","en"=>"No new messages"); $gt["vyber_skupinu"]=array("cz"=>"Vyber skupinu","en"=>"Choose a group"); $gt["adresa_prijemce"]=array("cz"=>"Adresa příjemce","en"=>"Address of the recipient is missing."); $gt["typ"]=array("cz"=>"typ","en"=>"type"); $gt["bez_jmena"]=array("cz"=>"bez názvu","en"=>"no name"); $gt["no_data"]=array("cz"=>"Nebyly nalezeny žádné položky","en"=>"No data available"); $gt["imgb_Select"]=array("cz"=>"Vyber","en"=>"Select"); $gt["imgb_Insert"]=array("cz"=>"Vlož fotku","en"=>"Insert"); $gt["imgb_CreatinIcon"]=array("cz"=>"Vytvářím ikonu ...","en"=>"Creating Icon ..."); $gt["imgb_MoveFailed"]=array("cz"=>"Kopírování souboru se nepodařilo ...","en"=>"failed to copy ..."); $gt["imgb_MoveSuccess"]=array("cz"=>"Soubor úspěsně přesunut!","en"=>"Successfully moved!!"); $gt["imgb_DeleteWarn1"]=array("cz"=>"To chceš natrvalo smazat tenhle obrázek?","en"=>"This will delete the picture\\'s file and free the object from the Imagebank.\\nAre you 200% sure?"); $gt["imgb_DeleteWarn2"]=array("cz"=>"Nepude to vzít zpátky!!\\nJe určitě ke smazání?","en"=>"It appears, you have made error, because you are going to delete the file from it\\'s location.\\n There is no backup!"); $gt["imgb_CreateIcon"]=array("cz"=>"Vytvořit ikonu","en"=>"Create Icon"); $gt["imgb_AdjustPicture"]=array("cz"=>"Uprav obrázek...","en"=>"Adjust picture..."); $gt["imgb_Delete"]=array("cz"=>"Smazat","en"=>"Delete"); $gt["imgb_Keep"]=array("cz"=>"Držet","en"=>"Keep"); $gt["imgb_RotateLeft"]=array("cz"=>"Otoč vlevo","en"=>"Rotate Left"); $gt["imgb_RotateRight"]=array("cz"=>"Otoč vpravo","en"=>"Rotate Right"); $gt["save"]=array("cz"=>"Ulož","en"=>"Save"); $gt["SaveAndNext"]=array("cz"=>"Ulož a jdi na další","en"=>"Save and edit next one"); $gt["imgb_RotateWarn"]=array("cz"=>"Dojde k obrazove degradaci obrazku!!!!","en"=>"Loss of the picture quality!!!!"); //$gt[""]=array("cz"=>"","en"=>""); //+ěščřžýáíé= rtdn //+ĚŠČŘŽÝÁÍÉ= řťďň function gt ($zkratka,$jazyk="") { global $gt;global $default_language; if ($jazyk=="") { if ($default_language!="") $jazyk=$default_language; else $jazyk="cz"; } return $gt[$zkratka][$jazyk]; } function printgt ($zkratka,$jazyk="") { print gt ($zkratka,$jazyk);} function makeNoData($kolik=1,$table_bgcolor_="#FFFFFF") { return makeTR("".makenbsp(gt("no_data"))."\n")."\n"; } function printNoData($kolik=1,$table_bgcolor_="#FFFFFF") { print makeNoData($kolik,$table_bgcolor_); } function printStrankaChoose($nstranek,$akt_stranka,$search) { global $PHP_SELF;if ($search) $asearch="&$search"; for ($i=0;$i<$nstranek;$i++) { if ($i==$akt_stranka) print "".($i+1)." "; else print "".($i+1)." "; } } function printStrankaChooseTR($nstranek,$akt_stranka,$colspan=1,$search="") { global $table_head_bgcolor;if ($search) $asearch="?$search"; print "
". ""; print "Stránka: "; printStrankaChoose($nstranek,$akt_stranka,$search); print "\n
\n"; } function makeB($text) { if ($text) return maketag($text,"b");} function GetFirstEmail($email) { if (strlen($email)) if ($poz=strpos($email,";")) $email=substr($email,0,$poz); return $email; } function StandatizeEmails($email) { $email=ereg_replace("\n"," ",$email); $email=ereg_replace("\t"," ",$email); $email=ereg_replace("\r"," ",$email); $email=ereg_replace(","," ",$email); $email=ereg_replace(";"," ",$email); $email=trim($email); $email=ereg_replace(" +",";",$email); return $email; } class HTTPresponse { var $headers=""; var $body=""; function header($text) { $this->headers.=$text; } function body($text) { $this->body.=$text; } function finalize() { print $this->headers; print $this->body; } } function startsWith($s, $pre){ return (int)ereg("^$pre", $s); } function printr($i){ print "
";
  print_r($i);
  print "
"; } ?>