/* serwer, na którym siedzi baza */
$db_host = 'localhost' ;
/* użytkownik */
$db_user = 'gniazdka_dzieci' ;
/* hasło */
$db_pass = 'WSA)pnsRTRw4' ;
/* prefiks dla tabel, będzie użyty jako: prefix+nazwa tabeli
np.: kf_firmy, kf_opinie
*/
$prefix = 'kf_' ;
/* nazwa bazy danych */
$db_db = 'gniazdka_dzieciaki' ;
/* wpisz dowolny ciąg znaków */
/* pamiętaj, po zmianie ciągu znaków wszyscy zarejestrowani użytkownicy stracą dostęp do swoich kont */
$losowy_ciag_znakow = '326534745874578' ;
?>
function trim_page_0( $str ) {
global $config ;
$str = str_replace( '?page=0&', '?', $str ) ;
$str = str_replace( '?page=0', '', $str ) ;
return $str ;
}
function cena_4( $cena ) {
$cena += "" ;
if( !eregi( "\.", $cena )) {
if( empty( $cena )) $wynik = "0.00" ;
else $wynik = $cena.".00" ;
}
else {
$s = explode( ".", $cena ) ;
if( strlen( $s[1] ) < 2 ) $wynik = $cena."0" ;
else $wynik = $cena ;
}
return $wynik ;
}
function generuj_fakture( $dane ) {
global $baza, $config ;
// print_r( $dane ) ;
// exit() ;
include "engine/tcpdf/tcpdf.php";
// create new PDF document
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
// set document information
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetFillColor(255, 255, 255);
$pdf->setLanguageArray("pl");
$pdf->setPrintHeader(false);
$pdf->setPrintFooter(false);
$sprzedawca = $baza->unserialize( $dane['sprzedawca'] ) ;
$kupujacy = $baza->unserialize( $dane['kupujacy'] ) ;
$pdf->AddPage();
$pdf->SetFont('freesans' , 'B' , 14);
$data = $dane['data'] ; //date( 'Y-m-d' ) ;
$data2 = date( 'Y-m-d', strtotime( $dane['data'].' + 7 days' )) ;
if( file_exists( 'img/faktura.png' )) {
$pdf->Image('img/faktura.png', 10, 10, '', '', 'PNG', '', '', false, 150, '', false, false, 0, false, false, false);
// $pdf->Ln();
}
elseif( file_exists( 'img/faktura.jpg' )) {
//$img = getimagesize( 'img/faktura.jpg' ) ;
$pdf->Image('img/faktura.jpg', 10, 10, '', '', 'JPEG', '', '', false, 150, '', false, false, 0, false, false, false);
// $pdf->Ln();
}
$row = $dane['rok'] - 1 ;
$numer = $dane['numer'] ;
if( $dane['typ'] == 'dodanie' ) $tytulem = $config['fvat_dodanie'] ; //'Dodanie wpisu do katalogu firm aaa lll vvv' ;
else $tytulem = $config['fvat_promo'] ; //'Wykupienie pakietu promocyjnego: '.$dane['typ'] ;
$dane['numer'] = $numer.'/'.$dane['rok'].'/'.$config['fvat_nazwa'] ;
//$pdf->writeHTMLCell($w=0, $h=0, $x='', $y='', 'Faktura nr '.$config['faktura_numer'], $border=0, $ln=1, $fill=0, $reseth=true, $align='', $autopadding=true);
//
$pdf->MultiCell(250, 5, "\r\n".'Faktura nr '.$dane['numer']."\r\n\r\n", 0, 'C', 1, 1, '', '', true, 0, false, true, 40, 'T');
$pdf->SetFont('freesans' , '' , 10);
$pdf->MultiCell(120, 5, 'Data wystawienia: '.$data, 0, 'R', 1, 0, '', '', true, 0, false, true, 40, 'T');
$pdf->MultiCell(60, 5, 'Data sprzedaży: '.$data, 0, 'R', 1, 1, '', '', true, 0, false, true, 40, 'T');
$pdf->MultiCell(120, 5, 'Data płatości: '.$data2, 0, 'R', 1, 0, '', '', true, 0, false, true, 40, 'T');
$pdf->MultiCell(60, 5, 'Metoda płatości: przelew', 0, 'R', 1, 1, '', '', true, 0, false, true, 40, 'T');
$pdf->Ln();
$pdf->SetFont('freesans' , 'B' , 14);
$pdf->MultiCell(90, 5, 'Sprzedawca', 0, 'J', 1, 0, '', '', true, 0, false, true, 40, 'T');
$pdf->MultiCell(90, 5, 'Nabywca', 0, 'J', 1, 1, '', '', true, 0, false, true, 40, 'T');
$sprzedawca_dane = $sprzedawca['nazwa']."\r\n".$sprzedawca['adres']."\r\n".$sprzedawca['nip']."\r\n".$sprzedawca['konto'] ;
$kupujacy_dane = $kupujacy['nazwa']."\r\n".$kupujacy['adres']."\r\n".$kupujacy['nip'] ;
$pdf->SetFont('freesans' , '' , 12);
$pdf->MultiCell(90, 5, $sprzedawca_dane, 0, 'J', 1, 0, '', '', true, 0, false, true, 40, 'T');
$pdf->MultiCell(90, 5, $kupujacy_dane, 0, 'J', 1, 1, '', '', true, 0, false, true, 40, 'T');
$pdf->Ln() ;
$pdf->SetFont('freesans' , 'B' , 14);
$pdf->MultiCell(180,7,"Oryginał" , 0 , "R" , 0,1);
$pdf->SetFont('freesans' , '' , 10);
// MultiCell($w, $h, $txt, $border=0, $align='J', $fill=0, $ln=1, $x='', $y='', $reseth=true, $stretch=0, $ishtml=false, $autopadding=true, $maxh=0)
// set cell padding
$pdf->setCellPaddings(1, 1, 1, 1);
// set cell margins
$pdf->setCellMargins(0, 0, 0, 0);
$pdf->MultiCell(10,7,"Lp", 1, "C", 0,0);
$pdf->MultiCell(50,7,"Nazwa" , 1 , "C" , 0,0,NULL,NULL,1);
$pdf->MultiCell(10,7,"Jedn" , 1 , "C" , 0,0);
$pdf->MultiCell(10,7,"Ilość" , 1 , "C" , 0,0);
$pdf->MultiCell(30,7,"Cena netto" , 1 , "C" , 0,0);
$pdf->MultiCell(16,7,"Stawka" , 1 , "C" , 0,0);
$pdf->MultiCell(30,7,"Wartość netto" , 1 , "C" , 0,0);
$pdf->MultiCell(30,7,"Wartość brutto" , 1 , "C" , 0,1);
$netto = round(($dane['kwota']*100)/(100+$config['fvat_vat']),2) ;
$vat = $dane['kwota'] - $netto ;
$pdf->MultiCell(10,7,"1", 1, "C", 0,0);
$pdf->MultiCell(50, 7, $tytulem, 1, 'C', 0, 0, null, null, true, 0, false, true, 7, 'M', true);
//$pdf->MultiCell(50,7,$tytulem , 1 , "C" , 0,0,NULL,NULL,1);
$pdf->MultiCell(10,7,"szt." , 1 , "C" , 0,0);
$pdf->MultiCell(10,7,"1" , 1 , "C" , 0,0);
$pdf->MultiCell(30,7,cena_4($netto) , 1 , "C" , 0,0);
$pdf->MultiCell(16,7,$config['fvat_vat']."%" , 1 , "C" , 0,0);
$pdf->MultiCell(30,7,cena_4($netto) , 1 , "C" , 0,0);
$pdf->MultiCell(30,7,cena_4($dane['kwota']) , 1 , "C" , 0,1);
$pdf->Ln() ;
$pdf->MultiCell(30,7,"Stawka VAT", 1, "C", 0,0);
$pdf->MultiCell(30,7,"Wartość netto" , 1 , "C" , 0,0,NULL,NULL,1);
$pdf->MultiCell(30,7,"Kwota VAT" , 1 , "C" , 0,0);
$pdf->MultiCell(30,7,"Wartość brutto" , 1 , "C" , 0,0);
$pdf->MultiCell(30,7,"Zapłacono", 0, "R", 0,0);
$pdf->MultiCell(30,7,cena_4($dane['kwota']).' PLN' , 0 , "R" , 0,1);
$pdf->MultiCell(30,7,$config['fvat_vat']."%", 1, "C", 0,0);
$pdf->MultiCell(30,7,cena_4($netto) , 1 , "C" , 0,0,NULL,NULL,1);
$pdf->MultiCell(30,7,cena_4($vat) , 1 , "C" , 0,0);
$pdf->MultiCell(30,7,cena_4($dane['kwota']) , 1 , "C" , 0,0);
$pdf->MultiCell(30,7,"Do zapłaty" , 0 , "R" , 0,0);
$pdf->MultiCell(30,7,cena_4( 0 ).' PLN' , 0 , "R" , 0,1);
$pdf->MultiCell(30,7,"Razem", 1, "C", 0,0);
$pdf->MultiCell(30,7,cena_4($netto) , 1 , "C" , 0,0,NULL,NULL,1);
$pdf->MultiCell(30,7,cena_4($vat) , 1 , "C" , 0,0);
$pdf->MultiCell(30,7,cena_4($dane['kwota']) , 1 , "C" , 0,0);
$pdf->MultiCell(30,7,"Razem" , 0 , "R" , 0,0);
$pdf->MultiCell(30,7,cena_4($dane['kwota']).' PLN', 0 , "R" , 0,1);
$razem_brutto = round( $dane['kwota'], 2 ) ;
$grosze = round(($razem_brutto-(int)floor($razem_brutto))*100);
//echo (($razem_brutto-floor( $razem_brutto ))*100) ;
//echo (string)floor( ($razem_brutto-floor($razem_brutto))*100) ;
$slownie = str_replace(range(0,9),array("zero*","jed*","dwa*","trzy*","czt*","pie*","sze*","sie*","osi*","dzie*"),(string)floor($razem_brutto))."zł*".str_replace(range(0,9),array("zero*","jed*","dwa*","trzy*","czt*","pie*","sze*","sie*","osi*","dzie*"),(string)(($grosze)))."gr" ;
$pdf->MultiCell(180,7,"Słownie" , 0 , "R" , 0,1);
$pdf->MultiCell(180,7,$slownie, 0 , "R" , 0,1);
$pdf->Ln(); $pdf->Ln(); $pdf->Ln(); $pdf->Ln(); $pdf->Ln(); $pdf->Ln(); $pdf->Ln(); $pdf->Ln(); $pdf->Ln(); $pdf->Ln();
$pdf->SetFont('freesans' , '' , 9);
$pdf->Multicell( 90, 7, 'Imię i nazwisko osoby uprawnionej'."\r\n".'do wystawiania faktury', 0, 'C', 0, 0 ) ;
$pdf->Multicell( 90, 7, 'Imię i nazwisko osoby uprawnionej'."\r\n".'do odbioru faktury', 0, 'C', 0, 1 ) ;
$pdf->AddPage();
$pdf->SetFont('freesans' , 'B' , 14);
$data = date( 'Y-m-d' ) ;
$data2 = date( 'Y-m-d', strtotime( 'Today + 7 days' )) ;
if( file_exists( 'img/faktura.png' )) {
$pdf->Image('img/faktura.png', 10, 10, '', '', 'PNG', '', '', false, 150, '', false, false, 0, false, false, false);
// $pdf->Ln();
}
elseif( file_exists( 'img/faktura.jpg' )) {
//$img = getimagesize( 'img/faktura.jpg' ) ;
$pdf->Image('img/faktura.jpg', 10, 10, '', '', 'JPEG', '', '', false, 150, '', false, false, 0, false, false, false);
// $pdf->Ln();
}
$pdf->MultiCell(250, 5, "\r\n".'Faktura nr '.$dane['numer']."\r\n\r\n", 0, 'C', 1, 1, '', '', true, 0, false, true, 40, 'T');
$pdf->SetFont('freesans' , '' , 10);
$pdf->MultiCell(120, 5, 'Data wystawienia: '.$data, 0, 'R', 1, 0, '', '', true, 0, false, true, 40, 'T');
$pdf->MultiCell(60, 5, 'Data sprzedaży: '.$data, 0, 'R', 1, 1, '', '', true, 0, false, true, 40, 'T');
$pdf->MultiCell(120, 5, 'Data płatości: '.$data2, 0, 'R', 1, 0, '', '', true, 0, false, true, 40, 'T');
$pdf->MultiCell(60, 5, 'Metoda płatości: przelew', 0, 'R', 1, 1, '', '', true, 0, false, true, 40, 'T');
$pdf->Ln();
$pdf->SetFont('freesans' , 'B' , 14);
$pdf->MultiCell(90, 5, 'Sprzedawca', 0, 'J', 1, 0, '', '', true, 0, false, true, 40, 'T');
$pdf->MultiCell(90, 5, 'Nabywca', 0, 'J', 1, 1, '', '', true, 0, false, true, 40, 'T');
$sprzedawca_dane = $sprzedawca['nazwa']."\r\n".$sprzedawca['adres']."\r\n".$sprzedawca['nip']."\r\n".$sprzedawca['konto'] ;
$kupujacy_dane = $kupujacy['nazwa']."\r\n".$kupujacy['adres']."\r\n".$kupujacy['nip'] ;
$pdf->SetFont('freesans' , '' , 12);
$pdf->MultiCell(90, 5, $sprzedawca_dane, 0, 'J', 1, 0, '', '', true, 0, false, true, 40, 'T');
$pdf->MultiCell(90, 5, $kupujacy_dane, 0, 'J', 1, 1, '', '', true, 0, false, true, 40, 'T');
$pdf->Ln() ;
$pdf->SetFont('freesans' , 'B' , 14);
$pdf->MultiCell(180,7,"Kopia" , 0 , "R" , 0,1);
$pdf->SetFont('freesans' , '' , 10);
// MultiCell($w, $h, $txt, $border=0, $align='J', $fill=0, $ln=1, $x='', $y='', $reseth=true, $stretch=0, $ishtml=false, $autopadding=true, $maxh=0)
// set cell padding
$pdf->setCellPaddings(1, 1, 1, 1);
// set cell margins
$pdf->setCellMargins(0, 0, 0, 0);
$pdf->MultiCell(10,7,"Lp", 1, "C", 0,0);
$pdf->MultiCell(50,7,"Nazwa" , 1 , "C" , 0,0,NULL,NULL,1);
$pdf->MultiCell(10,7,"Jedn" , 1 , "C" , 0,0);
$pdf->MultiCell(10,7,"Ilość" , 1 , "C" , 0,0);
$pdf->MultiCell(30,7,"Cena netto" , 1 , "C" , 0,0);
$pdf->MultiCell(16,7,"Stawka" , 1 , "C" , 0,0);
$pdf->MultiCell(30,7,"Wartość netto" , 1 , "C" , 0,0);
$pdf->MultiCell(30,7,"Wartość brutto" , 1 , "C" , 0,1);
$netto = round(($dane['kwota']*100)/(100+$config['fvat_vat']),2) ;
$vat = $dane['kwota'] - $netto ;
$pdf->MultiCell(10,7,"1", 1, "C", 0,0);
$pdf->MultiCell(50,7,$tytulem , 1 , "C" , 0,0,NULL,NULL,1);
$pdf->MultiCell(10,7,"szt." , 1 , "C" , 0,0);
$pdf->MultiCell(10,7,"1" , 1 , "C" , 0,0);
$pdf->MultiCell(30,7,cena_4($netto) , 1 , "C" , 0,0);
$pdf->MultiCell(16,7,$config['fvat_vat']."%" , 1 , "C" , 0,0);
$pdf->MultiCell(30,7,cena_4($netto) , 1 , "C" , 0,0);
$pdf->MultiCell(30,7,cena_4($dane['kwota']) , 1 , "C" , 0,1);
$pdf->Ln() ;
$pdf->MultiCell(30,7,"Stawka VAT", 1, "C", 0,0);
$pdf->MultiCell(30,7,"Wartość netto" , 1 , "C" , 0,0,NULL,NULL,1);
$pdf->MultiCell(30,7,"Kwota VAT" , 1 , "C" , 0,0);
$pdf->MultiCell(30,7,"Wartość brutto" , 1 , "C" , 0,0);
$pdf->MultiCell(30,7,"Zapłacono", 0, "R", 0,0);
$pdf->MultiCell(30,7,cena_4($dane['kwota']).' PLN' , 0 , "R" , 0,1);
$pdf->MultiCell(30,7,$config['fvat_vat']."%", 1, "C", 0,0);
$pdf->MultiCell(30,7,cena_4($netto) , 1 , "C" , 0,0,NULL,NULL,1);
$pdf->MultiCell(30,7,cena_4($vat) , 1 , "C" , 0,0);
$pdf->MultiCell(30,7,cena_4($dane['kwota']) , 1 , "C" , 0,0);
$pdf->MultiCell(30,7,"Do zapłaty" , 0 , "R" , 0,0);
$pdf->MultiCell(30,7,cena_4( 0 ).' PLN' , 0 , "R" , 0,1);
$pdf->MultiCell(30,7,"Razem", 1, "C", 0,0);
$pdf->MultiCell(30,7,cena_4($netto) , 1 , "C" , 0,0,NULL,NULL,1);
$pdf->MultiCell(30,7,cena_4($vat) , 1 , "C" , 0,0);
$pdf->MultiCell(30,7,cena_4($dane['kwota']) , 1 , "C" , 0,0);
$pdf->MultiCell(30,7,"Razem" , 0 , "R" , 0,0);
$pdf->MultiCell(30,7,cena_4($dane['kwota']).' PLN', 0 , "R" , 0,1);
$razem_brutto = round( $dane['kwota'], 2 ) ;
$grosze = round(($razem_brutto-(int)floor($razem_brutto))*100);
//echo (($razem_brutto-floor( $razem_brutto ))*100) ;
//echo (string)floor( ($razem_brutto-floor($razem_brutto))*100) ;
$slownie = str_replace(range(0,9),array("zero*","jed*","dwa*","trzy*","czt*","pie*","sze*","sie*","osi*","dzie*"),(string)floor($razem_brutto))."zł*".str_replace(range(0,9),array("zero*","jed*","dwa*","trzy*","czt*","pie*","sze*","sie*","osi*","dzie*"),(string)(($grosze)))."gr" ;
$pdf->MultiCell(180,7,"Słownie" , 0 , "R" , 0,1);
$pdf->MultiCell(180,7,$slownie, 0 , "R" , 0,1);
$pdf->Ln(); $pdf->Ln(); $pdf->Ln(); $pdf->Ln(); $pdf->Ln(); $pdf->Ln(); $pdf->Ln(); $pdf->Ln(); $pdf->Ln(); $pdf->Ln();
$pdf->SetFont('freesans' , '' , 9);
$pdf->Multicell( 90, 7, 'Imię i nazwisko osoby uprawnionej'."\r\n".'do wystawiania faktury', 0, 'C', 0, 0 ) ;
$pdf->Multicell( 90, 7, 'Imię i nazwisko osoby uprawnionej'."\r\n".'do odbioru faktury', 0, 'C', 0, 1 ) ;
//Close and output PDF document
$pdf->Output('img/upload/faktura_'.$dane['id'].'.pdf', 'F');
}
function przelicz_kategorie() {
global $baza, $prefix ;
$baza->query( "select * from ".$prefix."firma_kategoria" ) ;
while( $row = $baza->get_array() ) {
$lista[$row['id_kategorii']]++ ;
}
$baza->query( "update ".$prefix."kategoria set liczba = 0" ) ;
foreach( $lista as $id_kat => $value ) {
$baza->query( "
UPDATE
".$prefix."kategoria k1
LEFT JOIN
".$prefix."kategoria k2 ON k1.rodzic = k2.id
SET
k1.liczba = k1.liczba+$value,
k2.liczba = k2.liczba+$value
WHERE
k1.id = '$id_kat'" ) ;
//$baza->query(( "update ".$prefix."kategorie set liczba = '$value' where id = '$'" )
}
}
function get_url_var( $var ) {
if( !empty( $_GET[$var] )) return $_GET[$var] ;
$vars = parse_url( ''.$_SERVER['REQUEST_URI'] ) ;
if( empty( $vars['query'] )) return ;
parse_str( $vars['query'], $vars ) ;
$_GET[$var] = $vars[$var] ;
return $vars[$var] ;
}
function get_url_vars() {
$vars = parse_url( ''.$_SERVER['REQUEST_URI'] ) ;
parse_str( $vars['query'], $vars ) ;
return $vars ;
}
function array_diff_ORG_NEW(&$org, &$new, $type='VALUES'){
switch($type){
case 'VALUES':
$int = array_values(array_intersect($org, $new)); //C = A ^ B
$org = array_values(array_diff($org, $int)); //A' = A - C
$new= array_values(array_diff($new, $int)); //B' = B - C
break;
case 'KEYS':
$int = array_values(array_intersect_key($org, $new)); //C = A ^ B
$org = array_values(array_diff_key($org, $int)); //A' = A - C
$new= array_values(array_diff_key($new, $int)); //B' = B - C
break;
}
}
function zapisz_slowa( $tab, $id ) {
global $baza, $prefix ;
foreach( $tab as $slowo ) {
$slowo = trim( $slowo ) ;
if( !empty( $slowo )) {
$slowo = $baza->safe_string( $slowo ) ;
$tab_id[$slowo] = 0 ;
$slowa[] = $slowo ;
}
}
$new_id = array() ;
$slowa = implode( "','", $slowa ) ;
$baza->query( "select id, nazwa from ".$prefix."tagi where nazwa in ('$slowa')" ) ;
while( $row = $baza->get_array() ) {
$tab_id[$row['nazwa']] = $row['id'] ;
$new_id[] = $row['id'] ;
}
$data = date( 'Y-m-d' ) ;
foreach( $tab_id as $slowo => $i ) {
if( empty( $i )) {
$baza->query( "insert into ".$prefix."tagi ( nazwa, data_dodania, widoczny ) values ( '$slowo', '$data', 1)" ) ;
$id_slowa = mysql_insert_id() ;
$tab_id[$slowo] = $id_slowa ;
$new_id[] = $id_slowa ;
}
}
$old_id = array() ;
$baza->query( "select id_tagu from ".$prefix."firma_tagi where id_firmy = '$id'" ) ;
while( $row = $baza->get_array() ) {
$old_id[] = $row['id_tagu'] ;
}
$baza->query( "delete from ".$prefix."firma_tagi where id_firmy = '$id'" ) ;
foreach( $new_id as $id_slowa ) {
$baza->query( "insert into ".$prefix."firma_tagi (id_firmy, id_tagu) values ( '$id', '$id_slowa')" ) ;
}
// $diff1 = array_diff( $old_id, $new_id ) ;
// $diff2 = array_diff( $new_id, $old_id ) ;
array_diff_ORG_NEW( $old_id, $new_id ) ;
if( !empty( $old_id ) ) {
$old = implode( "','", $old_id ) ;
$baza->query( "update ".$prefix."tagi set liczba = liczba - 1 where id in ('$old')" ) ;
}
if( !empty( $new_id ) ) {
$new = implode( "','", $new_id ) ;
$baza->query( "update ".$prefix."tagi set liczba = liczba + 1 where id in ('$new')" ) ;
}
// print_r( $old_id ) ;
// print_r( $new_id ) ;
// print_r( $diff1 ) ;
// print_r( $diff2 ) ;
}
function array_sort($array, $on, $order='SORT_ASC')
{
$new_array = array();
$sortable_array = array();
if (count($array) > 0) {
foreach ($array as $k => $v) {
if (is_array($v)) {
foreach ($v as $k2 => $v2) {
if ($k2 == $on) {
$sortable_array[$k] = $v2;
}
}
} else {
$sortable_array[$k] = $v;
}
}
switch($order)
{
case 'SORT_ASC':
// echo "ASC";
asort($sortable_array);
break;
case 'SORT_DESC':
// echo "DESC";
arsort($sortable_array);
break;
}
foreach($sortable_array as $k => $v) {
$new_array[] = $array[$k];
}
}
return $new_array;
}
function bbcode( &$txt ) {
$tags = array( 'strong', 'b', 'em', 'u', 'i', 'ul', 'ol', 'li', 'strike', 'p' ) ;
foreach( $tags as $tag ) {
$txt = str_replace( '<'.$tag.'>', '['.$tag.']', $txt ) ;
$txt = str_replace( ''.$tag.'>', '[/'.$tag.']', $txt ) ;
}
}
function unbbcode( &$txt ) {
$tags = array( 'strong', 'b', 'em', 'u', 'i', 'ul', 'ol', 'li', 'strike', 'p' ) ;
foreach( $tags as $tag ) {
$txt = str_replace( '['.$tag.']', '<'.$tag.'>', $txt ) ;
$txt = str_replace( '[/'.$tag.']',''.$tag.'>', $txt ) ;
}
$txt = str_replace( '\r\n', '
', $txt ) ;
$txt = str_replace( '
', $txt ) ; } function sprawdz_dane_firmy( &$tab ) { global $baza ; $wynik = true ; if( !empty( $tab['alias'] )) { $tmp_alias = preg_replace("/[^0-9a-zA-Z]/","", $tab['alias'] ); if( $tmp_alias != $tab['alias'] ) $wynik = false ; else { $baza->query( "select count(*) as liczba from ".$prefix."firma where alias = '$tmp_alias'" ) ; $row = $baza->get_array() ; if( $row['liczba'] > 0 ) { $wynik = false ; } } } if( !empty( $tab['www'] ) && !eregi( 'http', $tab['www'] )) { $tab['www'] = 'http://'.$tab['www'] ; } bbcode($tab['dlugi_opis']) ; bbcode($tab['promocje']) ; bbcode($tab['cennik']) ; foreach( $tab as $key => $value ) { if( $key != 'podkategoria' && $key != 'tagi' ) $tab[$key] = ( $value ) ; } $kategorie = $tab['podkategoria'] ; $wyn = array() ; foreach( $kategorie as $id ) { $val = $id+ 0 ; if( $val != 0 ) { $wyn[] = $id ; } } $tab['kategoria'] = $wyn ; $tagi = $tab['tagi'] ; $wyn = array() ; foreach( $tagi as $id ) { $wyn[] = $baza->safe_string( $id ) ; } $tab['tagi'] = $wyn ; $required = array( 'nazwa', 'kategoria', 'miasto', 'adres', 'email' ) ; foreach( $required as $str ) { if( empty( $tab[$str] )) { $wynik = false ; //echo $str ; } } //echo (int)$wynik ; return $wynik ; } function checkEmail($email) { if(preg_match("/^([a-zA-Z0-9])+([a-zA-Z0-9\._-])*@([a-zA-Z0-9_-])+([a-zA-Z0-9\._-]+)+$/", $email)){ /* list($username,$domain)=split('@',$email); if(!checkdnsrr($domain,'MX')) { return false; } */ return true; } return false; } function wyslij_maila( $email, $subject, $body, $from = '', $attach = '' ) { global $config ; // $from = '' ; if( $config['smtp_host'] != '' ) { $mail = new PHPMailer(); $mail->SMTPDebug = 1; // enables SMTP debug information (for testing) $mail->IsSMTP(); // telling the class to use SMTP $mail->IsHTML( true ) ; $mail->SMTPAuth = true; // enable SMTP authentication if( $config['smtp_tls' ] == 1 ) $mail->SMTPSecure = "tls"; else $mail->SMTPSecure = 'ssl' ; $mail->Host = $config['smtp_host']; // SMTP server $mail->Username = $config['smtp_user']; // SMTP account username $mail->Password = $config['smtp_pass']; // SMTP account password $mail->Port = $config['smtp_port']; if( empty( $from )) { $mail->SetFrom($config['smtp_from'],$config['smtp_from_name']); $mail->AddReplyTo($config['smtp_from'],$config['smtp_from_name']); } else { $mail->SetFrom($config['smtp_from'],$config['smtp_from_name']); //$mail->SetFrom($from,$from); $mail->AddReplyTo($from,$from); } if( !empty( $attach )) { $mail->AddAttachment( $attach, 'faktura.pdf' ) ; } $mail->Subject = $subject; $mail->MsgHTML($body); $mail->AltBody = strip_tags( $body ) ; $mail->AddAddress($email); if(!$mail->Send()) { // echo "Mailer Error: " . $mail->ErrorInfo; return false ; } else { // echo "Message sent!"; return true ; } } /* wysyłka przy pomocy mail*/ else { if( empty( $config['smtp_from2'] )) $config['smtp_from2'] = $config['smtp_from'] ; if( empty( $config['smtp_from_name'] )) $config['smtp_from_name'] = $config['smtp_user'] ; $headers = 'From: '.$config['smtp_from_name'].' <'.$config['smtp_from2'] . ">\r\n" . 'Reply-To: '.$config['smtp_from_name'].' <'.$config['smtp_from2'] . ">\r\n" . 'X-Mailer: PHP/' . phpversion(); mail($email, $subject, $body, $headers); } } function longWordWrap($string) { $string = str_replace("\n", "\n ", $string); // add a space after newline characters, so that 2 words only seperated by \n are not considered as 1 word $words = explode(" ", $string); // now split by space foreach ($words as $word) { $outstring .= chunk_split($word, 20, " ") . " "; } return $outstring; } function dateDiff( $data1, $data2 ) { if( empty( $data1 )) return 0 ; if( $data1 == '0000-00-00' ) return 0 ; $data1 = explode( "-", $data1 ) ; $data2 = explode( "-", $data2 ) ; $d1=mktime(0,0,0,$data1[1],$data1[2],$data1[0]); $d2=mktime(0,0,0,$data2[1],$data2[2],$data2[0]); return floor(abs($d2-$d1)/86400) ; } //PageRank Lookup v1.1 by HM2K (update: 31/01/07) //based on an alogoritham found here: http://pagerank.gamesaga.net/ //settings - host and user agent $googlehost='toolbarqueries.google.com'; $googleua='Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.6) Gecko/20060728 Firefox/1.5'; //convert a string to a 32-bit integer function StrToNum($Str, $Check, $Magic) { $Int32Unit = 4294967296; // 2^32 $length = strlen($Str); for ($i = 0; $i < $length; $i++) { $Check *= $Magic; //If the float is beyond the boundaries of integer (usually +/- 2.15e+9 = 2^31), // the result of converting to integer is undefined // refer to http://www.php.net/manual/en/language.types.integer.php if ($Check >= $Int32Unit) { $Check = ($Check - $Int32Unit * (int) ($Check / $Int32Unit)); //if the check less than -2^31 $Check = ($Check < -2147483648) ? ($Check + $Int32Unit) : $Check; } $Check += ord($Str{$i}); } return $Check; } //genearate a hash for a url function HashURL($String) { $Check1 = StrToNum($String, 0x1505, 0x21); $Check2 = StrToNum($String, 0, 0x1003F); $Check1 >>= 2; $Check1 = (($Check1 >> 4) & 0x3FFFFC0 ) | ($Check1 & 0x3F); $Check1 = (($Check1 >> 4) & 0x3FFC00 ) | ($Check1 & 0x3FF); $Check1 = (($Check1 >> 4) & 0x3C000 ) | ($Check1 & 0x3FFF); $T1 = (((($Check1 & 0x3C0) << 4) | ($Check1 & 0x3C)) <<2 ) | ($Check2 & 0xF0F ); $T2 = (((($Check1 & 0xFFFFC000) << 4) | ($Check1 & 0x3C00)) << 0xA) | ($Check2 & 0xF0F0000 ); return ($T1 | $T2); } //genearate a checksum for the hash string function CheckHash($Hashnum) { $CheckByte = 0; $Flag = 0; $HashStr = sprintf('%u', $Hashnum) ; $length = strlen($HashStr); for ($i = $length - 1; $i >= 0; $i --) { $Re = $HashStr{$i}; if (1 === ($Flag % 2)) { $Re += $Re; $Re = (int)($Re / 10) + ($Re % 10); } $CheckByte += $Re; $Flag ++; } $CheckByte %= 10; if (0 !== $CheckByte) { $CheckByte = 10 - $CheckByte; if (1 === ($Flag % 2) ) { if (1 === ($CheckByte % 2)) { $CheckByte += 9; } $CheckByte >>= 1; } } return '7'.$CheckByte.$HashStr; } //return the pagerank checksum hash function getch($url) { return CheckHash(HashURL($url)); } //return the pagerank figure function getpr($url) { global $googlehost,$googleua; $ch = getch($url); $fp = fsockopen($googlehost, 80, $errno, $errstr, 30); if ($fp) { $out = "GET /tbr?client=navclient-auto&ch=$ch&features=Rank&q=info:$url HTTP/1.1\r\n"; //echo "
$out\n"; //debug only $out .= "User-Agent: $googleua\r\n"; $out .= "Host: $googlehost\r\n"; $out .= "Connection: Close\r\n\r\n"; fwrite($fp, $out); echo $out ; //$pagerank = substr(fgets($fp, 128), 4); //debug only //echo $pagerank; //debug only while (!feof($fp)) { $data = fgets($fp, 128); // echo $data.'
Debug: '.$this->sqlq.' zapytań, strona w '.$czas.' sekund | |||||||||
'.$q.' '.$l.' '.$qc.' s | |||||||||
'.mysql_field_name($result, $i).' | ' ; } echo '|||||||||
'.$value.' | ' ; else echo ''.$value.' | ' ; $d++ ; } echo '