connect,$var);
}
function setZero($num){
if (strlen($num) == 1){
$num = "0".$num;
}
return $num;
}
function cutstring($string, $length,$add = '...'){
if (strlen($string) > $length){
$string = substr($string,0,$length);
$string = $string.$add;
};
return $string;
}
function get_extension($filename)
{
$pathinfo = pathinfo($filename);
if (isset($pathinfo['extension'])){
$ext = $pathinfo['extension'];
}else{
$ext = "";
}
return strtolower($ext);;
}
function make_password($length) {
$salt = "abchefghjkmnpqrstuvwxyz0123456789";
$pass = "";
srand((double)microtime()*1000000);
$i = 0;
while ($i <= $length) {
$num = rand() % 33;
$tmp = substr($salt, $num, 1);
$pass = $pass . $tmp;
$i++;
}
return $pass;
};
function generate_page_nav($table,$length,$offset,$vars,$where){
global $db;
$list_length = $length;
$navi = "";
$current_offset = $offset;
$query = "SELECT COUNT(*) AS total FROM !pfx->$table WHERE ".$where;
$result = $db->execute_query($query);
$num_rows = $result['data_table'][0]['total'];
$pages = ceil($num_rows / $list_length);
$to_view = ceil($num_rows - $offset);
$page = ceil(($num_rows - $to_view) / $list_length) +1;
$info = "rijen : ".$num_rows." - pagina : ".$page." van ".$pages;
$last_offset = $offset - $list_length;
$next_offset = $offset + $list_length;
if ($current_offset > 0){
$navi .= ' <-';
}
for ($i=0; $i < $pages; $i++){
$offset = $i * $list_length;
$ipage = $i+1;
if ($page == $ipage){
$navi .= ' '.$ipage.'';
}else{
$navi .= ' '.$ipage.'';
}
}
if ($current_offset < ($num_rows - $list_length)){
$navi .= ' ->';
}
$page_nav = array();
$page_nav['info'] = $info;
$page_nav['navi'] = $navi;
return $page_nav;
}
function string2object($string){
$myObj = array();
$vars = explode("&",$string);
foreach($vars as $var){
if ($var != ""){
$var = explode("=",$var);
if(!isset($var[1])){
$var[1] = "";
}
$myObj[$var[0]] = $var[1];
}
}
return $myObj;
}
function make_pictures($vars){
$pictures = array();
$myPics = explode("|-|",$vars);
$i = 0;
foreach($myPics as $pic){
if ($pic != ""){
$picData = explode("||",$pic);
if (count($picData) == 4){
if ($picData[3] != ""){
$picture = array();
$picture['id'] = $picData[0];
$picture['div'] = make_picture($picData[3],"",$picData[2]);
$picture['alt'] = $picData[2];
$picture['i'] = $i;
$pictures[] = $picture;
}else{
$picture = array();
$picture['id'] = $picData[0];
$picture['div'] = make_picture("id=".$picData[0]."&ext=".$picData[1]."&x=0&y=0&pic_width=330&pic_height=210","",$picData[2]);
$picture['alt'] = $picData[2];
$picture['i'] = $i;
$pictures[] = $picture;
}
}else{
if ($picData[2] != ""){
$picture = array();
$picture['id'] = $picData[0];
$picture['div'] = make_picture($picData[2],"",$picData[1]);
$picture['alt'] = $picData[1];
$picture['i'] = $i;
$pictures[] = $picture;
}
}
}
$i ++;
}
return $pictures;
}
function make_picture($data,$domain = "",$alt = ""){
global $pic_num;
$data = string2object($data);
if(!empty($data['my_width'])){
$width = 'width:'.$data['my_width'].'px;';
}else{
$width = "";
}
if(!empty($data['my_width']) && $data['my_width'] == 200 && $data['my_height'] == 200){
$width = "";
}
$picture = '';
if (isset($data['pic_width'])){
$picture = '';
$picture .= '
';
$picture .= '