table = "reakce"; $this->filtr = true; $this->insert = true; $this->delete = true; $this->edit = true; $this->dataid = "id"; $this->order = "ORDER BY reakce.idreakce,reakce.uroven,reakce.id"; $this->tepmlate_prefix = "reakce"; } function get($id, $field = NULL) { $dt = parent::get($id, $field); $dt['sirka'] = 20 * ($dt['uroven'] - 1); $dt['urovenP'] = ($dt['uroven'] + 1); return $dt; } function new_id($old, $add) { $add = "$add" . "_"; while (strlen("$add") < 7) { $add = "0" . "$add"; } return "$old" . "$add"; } function insert_post($POST) { $id = parent::insert_post($POST); $query_upd = "UPDATE reakce SET idreakce='" . $this->new_id($POST['row_idreakce'], $id) . "' WHERE id='$id'"; query($query_upd); return $id; } } ?>table = "reakcen"; $this->filtr = true; $this->insert = true; $this->delete = true; $this->edit = true; $this->dataid = "id"; $this->order = "ORDER BY reakcen.idreakce,reakcen.uroven,reakcen.id"; $this->tepmlate_prefix = "reakcen"; } function get($id, $field = NULL) { $dt = parent::get($id, $field); $dt['sirka'] = 20 * ($dt['uroven'] - 1); $dt['urovenP'] = ($dt['uroven'] + 1); return $dt; } function new_id($old, $add) { $add = "$add" . "_"; while (strlen("$add") < 7) { $add = "0" . "$add"; } return "$old" . "$add"; } function insert_post($POST) { $id = parent::insert_post($POST); $query_upd = "UPDATE reakcen SET idreakce='" . $this->new_id($POST['row_idreakce'], $id) . "' WHERE id='$id'"; query($query_upd); return $id; } } ?>table = "countries"; $this->filtr = true; $this->insert = true; $this->delete = true; $this->edit = true; $this->dataid = "IDCntr"; $this->order = "ORDER BY IDCntr<>55, Name_$lang DESC"; $this->tepmlate_prefix = "countries"; $this->lang = $lang; } function get($id, $field = NULL) { $dt = parent::get($id, $field); $dt['nazev'] = $dt["Name_$this->lang"]; return $dt; } } ?>table = "objednavky"; $this->filtr = true; $this->insert = true; $this->delete = true; $this->edit = true; $this->dataid = "IDO"; $this->order = "ORDER BY Objednano DESC, IDO DESC"; $this->tepmlate_prefix = "objednavky"; $this->IDC=$IDC; $this->where = " WHERE IDC='$this->IDC' "; } } ?> table = "admins"; $this->filtr = true; $this->insert = true; $this->delete = true; $this->edit = true; $this->dataid = "id"; $this->tepmlate_prefix = "admins"; } function get($id, $field = NULL) { $dt = parent::get($id, $field); $dt['admin_menu'] = array(); $res = query("SELECT admin_menu.*,admin2menu.AMID FROM admin_menu LEFT JOIN admin2menu ON admin_menu.MID=admin2menu.MID AND admin2menu.id='$id' order by admin_menu.radek, admin_menu.poradi,admin_menu.MID"); while ($row = mysqli_fetch_assoc($res)) { $dt['admin_menu'][] = $row; } return $dt; } function save_prava($POST, $id) { //echo "pracuji: "; query("DELETE FROM admin2menu WHERE id='$id'"); /* foreach ($POST as $key => $value) { echo $key." ".$value."
"; } */ reset($POST); while (list($k, $v) = each($POST)) { if (strstr($k, "oprav_")) { $mid = substr($k, 6, 3); //echo $k." "; query("INSERT INTO admin2menu SET MID='$mid', id='$id'"); } } } function save_post($POST) { parent::save_post($POST); $this->save_prava($POST, $POST['row_id']); } function set_vazby() { $menu = new admin_menu($this->smarty, -1); $this->smarty->assign("admin_menu", $menu->getall()); } function insert_post($POST) { $id = parent::insert_post($POST); $this->save_prava($POST, $id); return $id; } function process_post($POST) { if ((strlen($POST['heslo1']) > 1)) $POST['row_passwd'] = md5($POST['heslo1']); $dt = parent::process_post($POST); return $dt; } } ?> table = "poh_admins"; $this->filtr = true; $this->insert = true; $this->delete = true; $this->edit = true; $this->dataid = "id"; $this->tepmlate_prefix = "poh_admins"; } function get($id, $field = NULL) { $dt = parent::get($id, $field); $dt['admin_menu'] = array(); $res = query("SELECT poh_admin_menu.*,poh_admin2menu.AMID FROM poh_admin_menu LEFT JOIN poh_admin2menu ON poh_admin_menu.MID=poh_admin2menu.MID AND poh_admin2menu.id='$id' order by poh_admin_menu.radek, poh_admin_menu.poradi,poh_admin_menu.MID"); while ($row = mysqli_fetch_assoc($res)) { $dt['admin_menu'][] = $row; } return $dt; } function save_prava($POST, $id) { query("DELETE FROM poh_admin2menu WHERE id='$id'"); reset($POST); while (list($k, $v) = each($POST)) { if (strstr($k, "oprav_")) { $mid = substr($k, 6, 3); query("INSERT INTO poh_admin2menu SET MID='$mid', id='$id'"); } } } function save_post($POST) { parent::save_post($POST); $this->save_prava($POST, $POST['row_id']); } function set_vazby() { $menu = new poh_admin_menu($this->smarty, -1); $this->smarty->assign("admin_menu", $menu->getall()); } function insert_post($POST) { $id = parent::insert_post($POST); $this->save_prava($POST, $id); return $id; } function process_post($POST) { if ((strlen($POST['heslo1']) > 1)) $POST['row_passwd'] = md5($POST['heslo1']); $dt = parent::process_post($POST); return $dt; } } ?>user = $user; $this->table = "admin_menu"; $this->filtr = true; $this->insert = true; $this->delete = true; $this->edit = true; $this->dataid = "MID"; $this->join = " JOIN admin2menu ON admin2menu.MID=admin_menu.MID "; $this->order = "ORDER BY radek, poradi,MID"; $this->tepmlate_prefix = "admin_menu"; if ($user != -1) $this->where = "WHERE admin2menu.id='$user'"; } function get($id, $field = '') { $dt = parent::get($id, $field); $id = $dt['MID']; $res = query("SELECT * FROM admin2menu WHERE MID='$id' AND id='$this->user'"); if ($row = mysqli_fetch_assoc($res)) $dt['allowed'] = true; return $dt; } } ?>user=$user; $this->table = "poh_admin_menu"; $this->filtr = true; $this->insert = true; $this->delete = true; $this->edit = true; $this->dataid = "MID"; $this->join=" JOIN poh_admin2menu ON poh_admin2menu.MID=poh_admin_menu.MID "; $this->order = "ORDER BY radek, poradi,MID"; $this->tepmlate_prefix = "admin_menu"; if ($user!=-1) $this->where="WHERE poh_admin2menu.id='$user'"; } function get($id,$field='') { $dt=parent::get($id,$field); $id=$dt['MID']; $res=query("SELECT * FROM poh_admin2menu WHERE MID='$id' AND id='$this->user'"); if ($row=mysqli_fetch_assoc($res)) $dt['allowed']=true; return $dt; } } ?>table = "poh_pohledavky"; $this->filtr = true; $this->insert = true; $this->delete = true; $this->edit = true; $this->dataid = "IDPO"; $this->join = " LEFT JOIN poh_admins ON poh_admins.id=poh_pohledavky.ida "; $this->fields = " ,poh_admins.login as predat,poh_admins.email as email "; $this->tepmlate_prefix = "poh_pohledavky"; } function save_post($POST) { global $_COOKIE; $old = serialize($this->get($POST["row_" . $this->dataid])); parent :: save_post($POST); $new = serialize($this->get($POST["row_" . $this->dataid])); if ($old != $new) { $user = mysqli_result(query("SELECT login FROM poh_admins WHERE id=" . $_COOKIE['auth_validuser']), 0); query("UPDATE poh_pohledavky SET zmeneno=now(),zmenil='$user' WHERE $this->dataid='" . $POST["row_" . $this->dataid] . "' LIMIT 1"); $new = $this->get($POST["row_" . $this->dataid]); $old = unserialize($old); $this->smarty->assign("old", $old); $this->smarty->assign("new", $new); if ($new['ida'] != $old['ida']) mail_attach($new['email'], $old['email'], "Předání pohledávky " . $new['protistrana'], $this->smarty->fetch("../modules/poh_pohledavky/poh_pohledavky.email.tpl")); } } function insert_post($POST) { global $_COOKIE, $db; $id = parent :: insert_post($POST); mysqli_query($db, "update poh_files set poh = $id where poh = 0"); $user = mysqli_result(query("SELECT login FROM poh_admins WHERE id=" . $_COOKIE['auth_validuser']), 0); $from = mysqli_result(query("SELECT email FROM poh_admins WHERE id=" . $_COOKIE['auth_validuser']), 0); query("UPDATE poh_pohledavky SET zmeneno=now(),zmenil='$user' WHERE $this->dataid='$id' LIMIT 1"); $new = $this->get($id); $this->smarty->assign("new", $new); if ($new['predat'] != $new['zmenil']) mail_attach($new['email'], $from, "Předání pohledávky " . $new['protistrana'], $this->smarty->fetch("../modules/poh_pohledavky/poh_pohledavky.email.tpl")); return $id; } function set_vazby() { $admins = new poh_admins($this->smarty); $this->smarty->assign("admins", $admins->getall()); } } ?>table = "zmeny"; $this->dataid = "id"; $this->order = "ORDER BY cas"; //$this->tepmlate_prefix = "customers"; } function insert($table, $columnId, $columnIdValue) { global $db; mysqli_query($db, "INSERT INTO $this->table (cas,tabulka,typupravy,sloupecId,hodnotaId,uzivatel) VALUES ( '" . date("Y-m-d H:i:s") . "','$table','INSERT','$columnId','$columnIdValue','shop' )"); } function delete($table, $columnId, $columnIdValue) { global $db; mysqli_query($db, "INSERT INTO $this->table (cas,tabulka,typupravy,sloupecId,hodnotaId,uzivatel) VALUES ( '" . date("Y-m-d H:i:s") . "','$table','DELETE','$columnId','$columnIdValue','shop' )"); } function updateColumn($table, $columnId, $columnIdValue, $data) { global $db; $res = mysqli_query($db, "SELECT * FROM $table WHERE $columnId='$columnIdValue' LIMIT 1"); $oldData = mysqli_fetch_array($res); foreach ($data as $key => $value) { if (substr($key, 0, 4) == "row_") { if (substr($key, 4) == $columnId) { if ($value != $oldData[substr($key, 4)]) { mysqli_query($db, "INSERT INTO $this->table (cas,tabulka,typupravy,sloupecId,hodnotaId,data1,uzivatel) VALUES ( '" . date("Y-m-d H:i:s") . "','$table','IDCHANGE','" . substr($key, 4) . "','" . $oldData[substr($key, 4)] . "','$value','shop' )"); } } else { if ($value != $oldData[substr($key, 4)]) { mysqli_query($db, "INSERT INTO $this->table (cas,tabulka,typupravy,sloupecId,hodnotaId,data1,data2,data3,uzivatel) VALUES ( '" . date("Y-m-d H:i:s") . "','$table','UPDATECOLUMN','$columnId','$columnIdValue','" . substr($key, 4) . "','" . $oldData[substr($key, 4)] . "','$value','shop' )"); } } } } } } ?> * version 1.01 * * constructor transparentWatermark( $stampFile="") * public function markImageFile ( $imageFile, $resultImageFile="") * public function markImage ( $imageResource) * public function setStampPosition ( $Xposition, $Yposition) * public function setStamp( $stampFile) * public function getLastErrror() */ error_reporting(E_ALL & ~E_DEPRECATED & ~E_NOTICE & ~E_STRICT & ~E_WARNING); ini_set("display_errors", 1); // position constants define ("transparentWatermarkOnTop", -1); define ("transparentWatermarkOnMiddle", 0); define ("transparentWatermarkOnBottom", 1); define ("transparentWatermarkOnLeft", -1); define ("transparentWatermarkOnCenter", 0); define ("transparentWatermarkOnRight", 1); // randomize level constants define ("transparentWatermarkRandPixelLightLevel", 7); define ("transparentWatermarkRandPixelPositionLevel", 2); class transparentWatermark { var $stampImage=0; var $stampWidth; var $margin=5; var $alpha=140; var $stampHeight; var $stampPositionX= transparentWatermarkOnRight; var $stampPositionY= transparentWatermarkOnBottom; var $errorMsg=""; /** * Constructor * * @param string $stampFile filename of stamp image * @return boolean * @access public * @uses setStamp() */ function transparentWatermark( $stampFile="",$alpha=140) { $this->alpha=$alpha; return( $this->setStamp( $stampFile)); } /** * mark an image file and display/save it * * @param int $imageFile image file (JPEG or PNG format) * @param int $resultImageFile new image file (same format) * @return boolean * @access public * @uses readImage() * @uses markImage() * @uses writeImage() * @uses readImage() * @uses errorMsg */ function markImageFile ( $imageFile, $resultImageFile="") { if (!$this->stampImage) { $this->errorMsg="Stamp image is not set."; return(false); } $imageinfos = @getimagesize($imageFile); $type = $imageinfos[2]; $image=$this->readImage($imageFile, $type); if (!$image) { $this->errorMsg="Error on loading '$imageFile', image must be a valid PNG or JPEG file."; return(false); } $this->markImage ( $image); if ($resultImageFile!="") { $this->writeImage( $image, $resultImageFile, $type); } else { $this->displayImage( $image, $type); } return( true); } /** * mark an image * * @param int $imageResource resource of image * @return boolean * @access public * @uses stampWidth * @uses stampHeight * @uses stampImage * @uses stampPositionX * @uses stampPositionY */ function markImage ( &$imageResource) { if (!$this->stampImage) { $this->errorMsg="Stamp image is not set."; return(false); } $imageWidth = imagesx( $imageResource); $imageHeight = imagesy( $imageResource); //set position of logo switch ($this->stampPositionX) { case transparentWatermarkOnLeft: $leftStamp=$this->margin; break; case transparentWatermarkOnCenter: $leftStamp=($imageWidth - $this->stampWidth)/2; break; case transparentWatermarkOnRight: $leftStamp=$imageWidth - $this->stampWidth-$this->margin; break; default : $leftStamp=$this->margin; } switch ($this->stampPositionY) { case transparentWatermarkOnTop: $topStamp=$this->margin; break; case transparentWatermarkOnMiddle: $topStamp=($imageHeight - $this->stampHeight)/2; break; case transparentWatermarkOnBottom: $topStamp=$imageHeight - $this->stampHeight-$this->margin; break; default: $topStamp=$this->margin; } // randomize position $leftStamp+=rand(-transparentWatermarkRandPixelPositionLevel, +transparentWatermarkRandPixelPositionLevel); $topStamp+=rand(-transparentWatermarkRandPixelPositionLevel, +transparentWatermarkRandPixelPositionLevel); // for each pixel of stamp for ($x=0; $x<$this->stampWidth; $x++) { if (($x+$leftStamp<0)||($x+$leftStamp>=$imageWidth)) continue; for ($y=0; $y<$this->stampHeight; $y++) { if (($y+$topStamp<0)||($y+$topStamp>=$imageHeight)) continue; // search RGB values of stamp image pixel $indexStamp=ImageColorAt($this->stampImage, $x, $y); $rgbStamp=imagecolorsforindex ( $this->stampImage, $indexStamp); // search RGB values of image pixel $indexImage=ImageColorAt( $imageResource, $x+$leftStamp, $y+$topStamp); $rgbImage=imagecolorsforindex ( $imageResource, $indexImage); if ($rgbStamp[alpha]==0) { //Alpha-Blending $r=($rgbImage["red"]*$this->alpha+$rgbStamp["red"]*(256-$this->alpha))/256; $g=($rgbImage["green"]*$this->alpha+$rgbStamp["green"]*(256-$this->alpha))/256; $b=($rgbImage["blue"]*$this->alpha+$rgbStamp["blue"]*(256-$this->alpha))/256; /* Additive-Blending // randomize light shift $stampAverage=($rgbStamp["red"]+$rgbStamp["green"]+$rgbStamp["blue"])/3; if ($stampAverage>10) $randomizer=rand(-transparentWatermarkRandPixelLightLevel, +transparentWatermarkRandPixelLightLevel); else $randomizer=0; // compute new values of colors pixel $r=max( min($rgbImage["red"]+$rgbStamp["red"]+$randomizer-0x80, 0xFF), 0x00); $g=max( min($rgbImage["green"]+$rgbStamp["green"]+$randomizer-0x80, 0xFF), 0x00); $b=max( min($rgbImage["blue"]+$rgbStamp["blue"]+$randomizer-0x80, 0xFF), 0x00); */ // change image pixel imagesetpixel ( $imageResource, $x+$leftStamp, $y+$topStamp, ($r<<16)+($g<<8)+$b); } } } return( true); } /** * set stamp position on image * * @param int $Xposition x position * @param int $Yposition y position * @return void * @access public * $this->stampPositionX * $this->stampPositionY * @uses errorMsg */ function setStampPosition ( $Xposition, $Yposition) { // set X position switch ($Xposition) { case transparentWatermarkOnLeft: case transparentWatermarkOnCenter: case transparentWatermarkOnRight: $this->stampPositionX=$Xposition; break; } // set Y position switch ($Yposition) { case transparentWatermarkOnTop: case transparentWatermarkOnMiddle: case transparentWatermarkOnBottom: $this->stampPositionY=$Yposition; break; } } /** * set stamp image for watermak * * @param string $stampFile image file (JPEG or PNG) * @return boolean * @access public * @uses readImage() * @uses stampImage * @uses stampWidth * @uses stampHeight * @uses errorMsg */ function setStamp( $stampFile) { $imageinfos = @getimagesize($stampFile); $width = $imageinfos[0]; $height = $imageinfos[1]; $type = $imageinfos[2]; if ($this->stampImage) imagedestroy( $this->stampImage); $this->stampImage=$this->readImage($stampFile, $type); if (!$this->stampImage) { $this->errorMsg="Error on loading '$stampFile', stamp image must be a valid PNG or JPEG file."; return(false); } else { $this->stampWidth=$width; $this->stampHeight=$height; return(true); } } /** * retrieve last error message * * @return string * @access public * @uses errorMsg */ function getLastErrror() { return($this->errorMsg); } /** * read image from file * * @param string $file image file (JPEG or PNG) * @param int $type file type (2:JPEG or 3:PNG) * @return resource * @access protected * @uses errorMsg */ function readImage( $file, $type) { switch ($type) { case 1: //GIF return(ImageCreateFromGIF($file)); case 2: //JPEG return(ImageCreateFromJPEG($file)); case 3: //PNG return(ImageCreateFromPNG($file)); default: $this->errorMsg="File format not supported."; return(false); } } /** * write image to file * * @param resource $image image * @param string $file image file (JPEG or PNG) * @param int $type file type (2:JPEG or 3:PNG) * @return void * @access protected * @uses errorMsg */ function writeImage( $image, $file, $type) { switch ($type) { case 2: //JPEG Imagejpeg( $image, $file); break; case 3: //PNG Imagepng( $image, $file); break; default: $this->errorMsg="File format not supported."; } } /** * send image to stdout * * @param resource $image image * @param int $type image type (2:JPEG or 3:PNG) * @return void * @access protected * @uses errorMsg */ function displayImage( $image, $type) { switch ($type) { case 2: //JPEG header("Content-Type: image/jpeg"); Imagejpeg( $image); break; case 3: //PNG header("Content-Type: image/png"); Imagepng( $image); break; default: $this->errorMsg="File format not supported."; } } } ?> Alt_$lang"); //// print_p(strtolower(iso2_to_seo(stripslashes($v["Alt_$lang"]))), "1"); //// print_p(strtolower($_GET['sekce' . $i]), "2"); // if (strtolower(iso2_to_seo(stripslashes($v["Alt_$lang"]))) == strtolower($_GET['sekce' . $i])) { //// print_p($v["Alt_$lang"]); // if (count($v['subsections']) && ($sec = seo_down($v['subsections'], $i + 1))) { // return $sec; // } else { // return $v['id']; // } // } // } // return ""; //} // print_p($secs); //if ($sek = seo_down($secs, 1)) { // $sec = $sek; // $main = "shop"; //} $last = ""; //print_p($_GET); foreach ($_GET AS $key => $value) { if (strpos($key, "sekce") !== FALSE) { // print_p($key); $last = $value; } } //print_p($value, $value); if ($last) { $sec = dbSection::getBySeoName($last)->id; if ($sec) { $main = "shop"; } } ?> GMcentrum s.r.o.