'.wpf_ts2de($row[2]).'';
$i++;
}
}
$article = $article2.''.$current_date.' '.wpf_ts2de($row[2]).' '.wpf_ts2de($row[2]).' '.$current_date.' '.wpf_ts2de($row[2]).' << >> Kommentar schreiben ';
else
$button = "";
}
//Kommentare
$sql = "SELECT New_id, Name, Info, Email, Created FROM WPF_News_comments WHERE State='1' AND New_id='$news_id'";
$res = wpf_db($sql);
if ($res!=false) foreach ($res as $row)
{
$id = $row[0];
$name = $row[1];
$info = nl2br($row[2]);
$email = $row[3];
$created = wpf_ts2de($row[4]);
$wpf_putin[0] = $id;
$wpf_putin[1] = $name;
$wpf_putin[2] = $info;
$wpf_putin[3] = $email;
$wpf_putin[4] = $created;
$templ = strtolower($customdir_templ."news_article_comments.htm");
$article .= wpf_buffer($templ, $wpf_putin);
}
if ($justcount)
return count($res);
else
return $article.$button;
}
}
function wpf_news($group_id=false, $news_id=false, $noecho=false, $top=false, $limit="", $template=false, $search="", $groupmonths=false, $listonly=false, $langonly=false)
{
//<<--sets
global $wpf_userip, $wpf_urldomain, $wpf_newspreview_textcut, $wpf_customdir, $wpf_newsdetail, $wpf_downpath, $wpf_templatedir;
$downpath = $wpf_downpath; //-> cms
$customdir = $wpf_customdir."news/";
$customdir_pics = $customdir."pic.uploads/";
$customdir_templ = $wpf_templatedir."news/";
$sprache = $_SESSION['wpf_language'];
include( wpf_mod_language("_cms") );
//-->>sets
//<<--sprache
global $wpf_language;
if( $wpf_language=="de" )
{
$ms01 = "Momentan keine vorhanden";
$ms_soldout = "ausverkauft";
$ms_shifted = "verschoben";
$ms_canceled = "abgesagt";
}
else
{
$ms01 = "None exist at the moment";
$ms_soldout = "sold out";
$ms_shifted = "shifted";
$ms_canceled = "canceled";
}
//-->>sprache
//<<--mode
$tabez = "News";
$idbez = "New_id";
$modadd = strtolower($tabez);
//-->>mode
//<<--nur in aktiver sprache?!
if( $langonly )
{
$limit_sql = " AND Langu='$sprache' ";
}
else
$limit_sql = "";
//-->>nur in aktiver sprache?!
//<<--nur für login-level x?!
$loginlevel = wpf_getloginlevel($_SESSION['wpf_login_id']);
$limit_sql .= " AND Regonly_level<=".$loginlevel;
//-->>nur für login-level x?!
//<<--limit
if( !empty($limit) )
{
$limit = wpf_clean($limit);
if( is_numeric($limit) ) $limit_sql2 = " LIMIT $limit";
}
else
$limit_sql2 = "";
//-->>limit
//<-suche
if( isset($_POST["wpf_search"]) || isset($_GET["wpf_search"]) || !empty($search) )
{
if( isset($_POST["wpf_search"]) )
$se = wpf_clean($_POST["wpf_search"]);
else
$se = wpf_clean($_GET["wpf_search"]);
if( !empty($search) ) $se = $search;
$se = strtolower($se);
$search_sql .= " AND ((LOWER(Keywords) LIKE '%".$se."%') OR (LOWER(Info) LIKE '%".$se."%') OR (LOWER(Name) LIKE '%".$se."%')) ";
}
else
$search_sql = "";
//->suche
//<<--aufrufe
$detail = false;
//<-einzelner
if( isset($_GET["wpf_news_id"]) && $listonly==false )
{
$id = wpf_clean($_GET["wpf_news_id"]);
$res = wpf_db("SELECT $idbez FROM WPF_$tabez WHERE State > 0 AND $idbez = '$id'");
if( $res!=false )
{
$search_sql .= " AND $idbez = '$id'";
$detail = true;
}
}
//->einzelner
//-->>aufrufe
//<<--ausgabe
$return="";
$order_sql = " ORDER BY Created DESC ";
//<-top
if( $top )
{
if( strlen($top)>2 )
$sql_flick2 = " AND Marked<>1 ";
else
$sql_flick2 = " AND Marked=1 ";
}
else
{
$sql_flick2 = "";
}
//->top
if( $group_id>0 ) $sql_flick2 .= " AND Neg_id='$group_id'";
$sql = "SELECT $idbez, Created, Edited, State, Langu, Name, Info, Link, Name, Keywords, Cou_id, Log_id_creater, Log_id_lastedi, State_langonly, Dow_id, Marked, Neg_id, Vid_id, Released FROM WPF_$tabez WHERE (State > 0) AND Released < NOW() ".$sql_flick2.$search_sql." ".$limit_sql.$order_sql.$limit_sql2;
$res = wpf_db($sql);
$i=0; if($res!=false) foreach($res as $row)
{
//<-Details
$id = $row[0];
$created = $row[1];
$edited = $row[2];
$aktiv = $row[3];
$sprache = $row[4];
$name = $row[5];
$info = $row[6];
$link = $row[7];
$bild = $row[8];
if( !empty($link) )
$link = $row[7];
else
$link = "";
$anker = "#news".$id;
$keywords = $row[9];
$cou_id = $row[10];
$log_id_creater = $row[11];
$log_id_lastedi = $row[12];
$langonly = $row[13];
$dow_id = $row[14];
$wochentag = strftime('%w', strtotime($row[1]));
$wochentag = wpf_dayname($wochentag);
$marked = $row[15];
$group = $row[16];
$get = wpf_db("SELECT Name FROM WPF_News_groups WHERE Neg_id='$group'", true);
$group_name = $get[0];
$vid_id = $row[17];
$released = $row[18];
//
if( $listonly==false )
$openfile = $_SERVER['PHP_SELF'];
else
$openfile = wpf_clean( str_replace("http://", "", $listonly) );
if( substr_count($openfile, "?") > 0 )
$geto = "&"; //falls mit listonly bereits eine get-übergabe
else
$geto = "?";
$params = $geto.'wpf_'.$modadd.'_id='.$id.'#'.$modadd.$id;
$detail_link = $openfile.$params;
$detaillink = ''; //Details /7&wpf.template=_wpf.template_popnews
//->Details
//<-Download-Anhang
if( wpf_modactive("downloads") && !empty($dow_id) )
{
$download = wpf_showdownloads("", "", $dow_id, true, true);
}
else $download = "";
//<-Download-Anhang
//<-Infos
if( $log_id_creater==0 )
$creater = "Admin";
else
$creater = "User #".$log_id_creater;
if( $log_id_lastedi==0 )
$editor = "Admin";
else
$editor = "User #".$log_id_lastedi;
$created = wpf_ts2de($created);
$edited = wpf_ts2de($edited);
$released = wpf_ts2de($released);
//->Infos
//<<--zählen
if( $detail )
{
$counter = wpf_updatecounter($cou_id);
}
else
{
$counter = wpf_counterstate($cou_id);
}
//-->>zählen
//<<--bild
$pic_tag = wpf_pixbox($pic_id=false, $mod_identifier=$modadd, $mod_id=$id, "pic1", $disablezoom=!$detail);
//->bild
//<--line template
$wpf_putin[0] = $id;
$wpf_putin[1] = $name;
$wpf_putin[2] = $info;
$wpf_putin[3] = $link;
$wpf_putin[4] = $sprache;
$wpf_putin[5] = $keywords;
$wpf_putin[6] = $counter;
$wpf_putin[7] = $released;
$wpf_putin[8] = $creater;
$wpf_putin[9] = $pic_tag;
$wpf_putin[10] = $detaillink;
$wpf_putin[11] = $detail_link;
$wpf_putin[12] = $vid_id;
if( @function_exists("wpf_videoplayer") && $vid_id>0 ) $player = wpf_videoplayer($vid_id, false, true); else $player = "";
$wpf_putin[13] = $player;
$wpf_putin[21] = wpf_truncate($info, $wpf_newspreview_textcut);
$wpf_putin[22] = $wochentag;
$wpf_putin[23] = $marked;
$wpf_putin[24] = $bild_gross;
$wpf_putin[25] = $download;
$wpf_putin[30] = $params;
$wpf_putin[31] = $group;
$wpf_putin[32] = $group_name;
$wpf_putin[50] = wpf_links("news", $id, true, $private=false, $link_names=false);
//
if( $detail )
{
$templ = "details";
}
else
{
if( $marked==1 )
$templ = "listing-top";
else
$templ = "listing";
}
$templ = strtolower($customdir_templ.$tabez."_".$templ.".htm");
if( (!$detail) && ($template<>false) )
{
if( @file_exists($customdir_templ.$template) )
$templ = $customdir_templ.$template;
else
wpf_debugmessage($s_cms_frontend_templatemissing.$template, $sender="wpf_news", $forceshow=true, $level=1);
}
$article = wpf_buffer($templ, $wpf_putin);
if( ($grouped==false) || (($grouped==true) && ($monthcount < $groupmonths+1)) )
$return .= $monthecho.str_replace("wpf.templ_pics/", $customdir_templ."wpf.templ_pics/", $article);
//-->line template
$i++;
}
//-->>ausgabe
//if( $i==0 ) $return = ''.$ms01.'
'; //keine
if( !$noecho ) echo $return;
return $return;
}
?>>Copyright / Info
//<<--remote login
//url liefert daten json formatiert - bsp.: {"user_id":318,"name":"FG","vorname":"Florian","nachname":"Test"}
function wpf_login_remote($user, $pass)
{
$password = md5(strtoupper($pass));
global $wpf_login_remote_url; //'https://semmel.esuc.de/authenticate_knb.asp?user='.$user.'&pass='.$password;
if(function_exists("curl_init"))
{
$channel = curl_init($wpf_login_remote_url);
$set = curl_setopt($channel, CURLOPT_URL, $wpf_login_remote_url);
$set = curl_setopt($channel, CURLOPT_RETURNTRANSFER, true);
$result = curl_exec($channel);
$channel = curl_close($channel);
$arr = json_decode($result);
$id = $arr->{'user_id'};
$user = $arr->{'name'};
$vorname = $arr->{'vorname'};
$nachname = $arr->{'nachname'};
if( !empty($id) && $id!="null" )
{
$return[0] = $id;
$return[1] = $user;
$return[2] = $pass;
$return[3] = $lastlogin;
$return[4] = ""; //wpf_cryptpassword($pass);
$return[5] = $vorname;
$return[6] = $nachname;
}
else $return = false;
}
return $return;
}
//-->>remote login
//<<--functions
function wpf_cryptpassword($pass)
{
global $wpf_password_salt;
if( empty($wpf_password_salt) ) wpf_debugmessage("No Salt for Password found!", "wpf_cryptpassword");
return md5($wpf_password_salt.$pass);
}
//-->>functions
//<<--login check
function wpf_checklogin()
{
global $wpf_password_salt, $wpf_save_clearpass;
$user = $_SESSION['wpf_login_name'];
$pass = $_SESSION['wpf_login_pass'];
//
if( empty($user) )
{
if( isset($_COOKIE['wpf_login_name']) && isset($_COOKIE['wpf_login_pass']) )
{
$user = $_COOKIE['wpf_login_name'];
$pass = $_COOKIE['wpf_login_pass'];
$cookie4login = true;
}
}
// auch unverschlüsselte zulassen (alte version)
$res = wpf_db("SELECT L.Log_id, L.Name, MD5(L.Pass), L.Last_login, Pass_crypted FROM WPF_Logins L, WPF_Login_groups G WHERE (L.Gro_id=G.Gro_id) AND (L.Name='$user' AND ((MD5(L.Pass)='$pass' AND L.Pass<>'') OR (L.Pass_crypted<>'' AND L.Pass_crypted='$pass')) AND G.State>0 AND L.State>0)", true);
if( !empty($res[0]) )
{
$_SESSION['wpf_login_id'] = $res[0];
$_SESSION['wpf_login_name'] = $user;
$_SESSION['wpf_login_pass'] = $pass;
$set = wpf_db("UPDATE WPF_Logins SET Last_activity=NOW() WHERE Log_id='$res[0]'"); //letzte user-aktivität für online-status
if( $cookie4login )
{
$_SESSION['wpf_login_last_beforethis'] = $res[3];
$set = wpf_db("UPDATE WPF_Logins SET Last_login=NOW() WHERE Log_id='$res[0]'"); //last login (via cookie)
}
return $res[0];
}
else
{
//kein gültiger login
if( isset($_SESSION['wpf_login_name']) )
{
wpf_logout(true);
}
return false;
}
}
function wpf_loginok()
{
//alias
return wpf_checklogin();
}
//-->>login check
//<<--register
function wpf_register($login_group_id=1, $noecho=false, $min_age=false, $syscreate=false, $mail_attachments=false) //syscreate = register wird vom system aufgerufen, um zugang automatisch zu erstellen (commununity - groups etc) - gibt login-id zurück
{
//<<--sets
global $wpf_userip, $wpf_fullurlpa, $wpframe_moddir, $wpf_captchaforms, $wpf_password_salt, $wpf_save_clearpass, $wpf_templatedir;
global $wpf_customdir, $username_has2be_email, $login_register_username_minchars, $wpf_downpath;
if( empty($login_register_username_minchars) ) $login_register_username_minchars = 4;
$downpath = $wpf_downpath; //downpath 2 wpf-root
$customdir = $wpf_customdir."logins/";
$showtempl = true;
//-->>sets
//<<--sprache
include( wpf_mod_language("logins") );
$s_logins_register_username2short = str_replace("[login_register_username_minchars]", $login_register_username_minchars, $s_logins_register_username2short);
$s_logins_register_errorminage = str_replace("[min_age]", $min_age, $s_logins_register_errorminage);
//-->>sprache
//<-captcha
if( $syscreate<>true )
{
$captcha = wpf_captcha(); //captcha form
}
//->captcha
//<<--spam-abbruch
if( !empty($_POST['name']) || !empty($_POST['email']) )
{
if( !isset($_SESSION['wpf_reg_count']) )
{
$_SESSION['wpf_reg_count'] = 1;
}
else
{
$_SESSION['wpf_reg_count'] += 1;
}
if( $_SESSION['wpf_reg_count'] > 9 )
{
$wpf_mess = $s_general_spamstop;
$showtempl = false;
$antispam_stop = true;
}
}
//-->>spam-abbruch
//<<--parameters
$parameters = wpf_clean($_REQUEST['parameters']); //reg_shops_only = registers 4 shops only
if( substr_count($parameters, "reg_shops_only")>0 ) $reg_shops_only = true;
//-->>parameters
if( $syscreate ) $wpf_mess = "";
//<<--
if( (!$antispam_stop) && (isset($_POST['name']) || isset($_POST['email'])) )
{
//<<--captcha
if($syscreate<>true && $wpf_captchaforms) $captcha_ok = wpf_captchacheck();
if($syscreate) $captcha_ok = true;
//-->>captcha
$name = wpf_clean($_POST['name']);
$email = wpf_clean($_POST['email']);
$email_confirm = wpf_clean($_POST['email_confirm']);
$firma = wpf_clean($_POST['firma']);
$anrede = wpf_clean($_POST['anrede']);
$titel = wpf_clean($_POST['titel']);
$nachname = wpf_clean($_POST['nachname']);
$vorname = wpf_clean($_POST['vorname']);
$str = wpf_clean($_POST['strasse']);
$plz = wpf_clean($_POST['plz']);
$ort = wpf_clean($_POST['ort']);
$lan_id = wpf_clean($_POST['land']);
$telefon = wpf_clean($_POST['telefon']);
$telefax = wpf_clean($_POST['telefax']);
$mobil = wpf_clean($_POST['handy']);
$agb = wpf_clean($_POST['agb']);
$birthdate_day = wpf_clean($_POST['birthdate_day']);
$birthdate_month = wpf_clean($_POST['birthdate_month']);
$birthdate_year = wpf_clean($_POST['birthdate_year']);
$birthdate = wpf_clean($_POST['birthdate']);
$user_type = wpf_clean($_POST['user_type']);
$geschlecht = wpf_clean($_POST['geschlecht']);
$email_news = wpf_clean($_POST['join_nl']);
$password = wpf_clean($_POST['password']);
$password_confirm = wpf_clean($_POST['password_confirm']);
//
$name = str_replace(' ', '', $name);
$name = strtolower($name);
$name = wpf_killuml($name);
if( !$syscreate && !$username_has2be_email )
{
$name = wpf_killspecs_html($name);
}
$email = trim($email);
//
$log_id=-1;
//
$res = wpf_db("SELECT L.Log_id, L.Name, L.Pass, L.Kon_id FROM WPF_Logins L, WPF_Login_groups G WHERE (L.Gro_id=G.Gro_id) AND (L.Name='$name' AND L.State>-1)", false, true);
if( $res>0 )
{
//login vorhanden
$wpf_mess = $s_logins_register_userexists;
}
else
{
//<--eingaben checken
//kontakt zu login erstellen? - oder nur login ohne personeninfo (dann muss user-name=email sein)
if( isset($_POST['nachname']) )
{
$addcontact = true;
}
else
{
$addcontact = false;
$email = $name;
}
//passwort
if( isset($_POST['password']) )
{
$manualpassword = true;
}
else
{
$manualpassword = false;
}
//geburtsdatum
if( !empty($birthdate_day) )
$birthdate = $birthdate_day.'.'.$birthdate_month.'.'.$birthdate_year;
//eingaben
$ok = true;
/*
if( $syscreate<>true && isset($_SESSION['wpf_reg_done']) ) //nur 1 registrierung pro session
{
$ok = false;
$wpf_mess .= $s_logins_register_done;
}
*/
if( $wpf_captchaforms && !$captcha_ok )
{
$ok = false;
$wpf_mess .= $s_general_wrongcaptcha;
}
if( $syscreate<>true && empty($agb) )
{
$ok = false;
$wpf_mess .= $s_logins_register_errorterms;
}
if( $syscreate<>true && isset($_POST['email_confirm']) && ($email<>$email_confirm) )
{
$ok = false;
$wpf_mess .= $s_logins_register_erroremailconfirm;
}
if( $syscreate<>true && isset($_POST['password_confirm']) && ($password<>$password_confirm) )
{
$ok = false;
$wpf_mess .= $s_logins_register_errorpasswordconfirm;
}
if( strlen($name)< $login_register_username_minchars )
{
$ok = false;
$wpf_mess .= $s_logins_register_username2short;
}
if( $username_has2be_email && wpf_checkmail($name)==false )
{
$ok = false;
$wpf_mess .= $s_general_usernamemustbeemail;
}
if( $addcontact && wpf_checkmail($email)==false )
{
$ok = false;
$wpf_mess .= $s_general_emailinvalid;
}
if( $addcontact && strlen($nachname)<3 )
{
$ok = false;
$wpf_mess .= $s_logins_register_errorlastname;
}
if( $addcontact==false && wpf_checkmail($name)==false )
{
$ok = false;
$wpf_mess .= $s_logins_register_errornamemustbemail;
}
if( $manualpassword && strlen($password)<6 )
{
$ok = false;
$wpf_mess .= $meldung_passwort;
}
if( $min_age<>false && wpf_age($birthdate)<$min_age )
{
$ok = false;
$wpf_mess .= $s_logins_register_errorminage;
}
//
$checkname = wpf_db("SELECT Name FROM WPF_Logins WHERE LOWER(Name)=LOWER('$name')", false, true);
if( (strlen($name)>=$login_register_username_minchars) && $checkname > 0 )
{
$ok = false;
$wpf_mess .= $s_logins_register_userexists;
}
//-->eingaben checken
//<--erstellen
if( $ok )
{
$user = 0; //Admin
$email_news = 1; //Newsletter
if( $syscreate ) $email_news = 0;
//
if( $manualpassword )
$pass = $password;
else
$pass = wpf_keygen(6); //Pass
$pass_crypted = wpf_cryptpassword($pass);
if( $wpf_save_clearpass==false ) $pass = "";
$birthdate_ts = wpf_de2dt($birthdate);
//<-Kontakt erstellen
if( $addcontact )
{
$vorhanden = wpf_db("SELECT Kon_id FROM WPF_Kontakte WHERE ((Email<>'' AND Nachname<>'') AND (Email='$email' AND Vorname='$vorname' AND Nachname='$nachname')) OR ((Plz<>'' AND Strasse<>'' AND Nachname<>'') AND (Plz='$plz' AND Strasse='$str' AND Vorname='$vorname' AND Nachname='$nachname'))", true);
if( $vorhanden[0]<>"" )
$person = $vorhanden[0];
else
$person = wpf_db("INSERT INTO WPF_Kontakte (Created, Nummer, Name, Firma, Anrede, Titel, Vorname, Nachname, Strasse, Plz, Ort, Lan_id, Telefon, Telefax, Handy, Email, Homepage, Email_news, Sms_news, Log_id_creater, Log_id_lastedi, Wpf_lock, Birthdate, Geschlecht)
VALUES (NOW(), '$nummer', '', '$firma', '$anrede', '$titel', '$vorname', '$nachname', '$strasse', '$plz', '$ort', '$lan_id', '$telefon', '$telefax', '$mobil', '$email', '$homepage', '$email_news', '0', '$user', '$user', 1, '$birthdate_ts', '$geschlecht')");
}
else
$person = "";
//->Kontakt erstellen
if( $syscreate ) $state = 1; else $state = 0;
//<-Login erstellen
//Counter
$cou_id = wpf_createcounter();
//
$gruppe = $login_group_id; $sprache="";
$res = wpf_db("INSERT INTO WPF_Logins (Created, Edited, State, Langu, Name, Log_id_creater, Log_id_lastedi, Gro_id, Kon_id, Last_login, Cou_id, Pass, Pass_crypted)
VALUES (NOW(), NOW(), '$state', '$sprache', '$name', '$user', '$user', '$gruppe', '$person', NOW(), '$cou_id', '$pass', '$pass_crypted')");
$log_id = $res;
$created = wpf_db("SELECT Created FROM WPF_Logins WHERE Log_id='".$res."'", true);
$created = $created[0];
if( $syscreate<>true )
{
//Confirmation-Link generieren
$add = "name=".$name."&stamp=".md5($created)."#wpf_confirm";
$link_direkt = $wpf_fullurlpa.$wpframe_moddir."logins/confirm.php?".$add;
$link = $wpf_fullurlpa."_wpf.modloader.php?wpf_mod=confirm&".$add;
$linka = ''.$s_logins_register_confirm.' ';
//Mail
$wpf_putin[0] = $linka;
$wpf_putin[1] = $name;
$wpf_putin[2] = $pass;
$wpf_putin[3] = $link;
$text = wpf_buffer($wpf_templatedir."logins/confirm_mail.htm", $wpf_putin);
wpf_sendmail($email, "Login", $text, $mail_attachments);
$_SESSION['wpf_reg_done'] = true;
}
//->Login erstellen
//<-Account erstellen
if( @function_exists('wpf_user') ) $com_mod_active = true; //standard
if( $com_mod_active )
{
//Counter
$cou_id = wpf_createcounter();
$res = wpf_db("INSERT INTO WPF_User_accounts (Created, Edited, State, Langu, Name, Log_id_creater, Log_id_lastedi, Cou_id, Info, Log_id, User_type)
VALUES (NOW(), NOW(), '$state', '$sprache', '$name', '$user', '$user', '$cou_id', '', $log_id, '$user_type')");
//
if( $reg_shops_only )
$param = wpf_db("UPDATE WPF_User_accounts SET Shops_user_only=1 WHERE Usa_id='$res' LIMIT 1");
}
//->Account erstellen
//
$showtempl = false;
$wpf_mess = $s_logins_register_created;
}
else
{
$wpf_mess = $s_logins_register_missing.$wpf_mess;
}
//-->erstellen
}
}
//-->>
//<<--
$geschlecht = wpf_sex($geschlecht);
$anrede = wpf_appell($_SESSION['wpf_language'], $anrede);
$land = wpf_country($_SESSION['wpf_language']); //, $lan_id
$wpf_putin[0] = $wpf_mess;
$wpf_putin[1] = $name;
$wpf_putin[2] = $email;
$wpf_putin[3] = $firma;
$wpf_putin[4] = $anrede;
$wpf_putin[5] = $titel;
$wpf_putin[6] = $nachname;
$wpf_putin[7] = $vorname;
$wpf_putin[8] = $str;
$wpf_putin[9] = $plz;
$wpf_putin[10] = $ort;
$wpf_putin[11] = $land;
$wpf_putin[12] = $telefon;
$wpf_putin[13] = $telefax;
$wpf_putin[14] = $mobil;
$wpf_putin[15] = $password;
$wpf_putin[16] = $birthdate_day;
$wpf_putin[17] = $birthdate_month;
$wpf_putin[18] = $birthdate_year;
$wpf_putin[19] = $birthdate;
$wpf_putin[20] = $geschlecht;
$wpf_putin[21] = $user_type;
$wpf_putin[22] = $parameters;
$wpf_putin[23] = $email_confirm;
//
if( $showtempl )
{
$article = wpf_buffer($wpf_templatedir."logins/register_form.htm", $wpf_putin);
//<-captcha
if( $wpf_captchaforms )
{
$article = str_replace("[WPF_CAPTCHA]", $captcha, $article);
}
//->captcha
$templ = str_replace('"'."wpf.templ_pics/", '"'.$wpf_templatedir."logins/wpf.templ_pics/", $article);
}
else $templ = $wpf_mess;
//
$_SESSION['wpf_login_register_errormessage'] = $wpf_mess;
//
if( $syscreate<>true )
{
echo $templ;
return $templ;
}
else
{
if( !empty($wpf_mess) ) wpf_debugmessage($wpf_mess, "wpf_register");
return $log_id;
}
//-->>
}
//-->>register
//<<--passwort vergessen
function wpf_password_reset($login_id)
{
global $wpf_customdir, $wpf_password_salt, $wpf_save_clearpass;
$pass = wpf_keygen(6);
$pass_crypted = wpf_cryptpassword($pass);
$return = $pass;
if( $wpf_save_clearpass==false ) $pass = "";
$res = wpf_db("UPDATE WPF_Logins L SET L.Pass_crypted='$pass_crypted', L.Pass='$pass', L.Edited=NOW(), L.Log_id_lastedi=0 WHERE L.Log_id='$login_id' LIMIT 1");
return $return;
}
function wpf_password()
{
//<<--sets
global $wpf_customdir, $wpf_password_salt, $wpf_save_clearpass, $wpf_fullurlpa, $wpf_templatedir;
$downpath = "../../../"; //downpath 2 wpf-root
$customdir = $wpf_customdir."logins/"; //Bilder
$showtempl = true;
global $wpf_userip;
//-->>sets
//<<--sprache
include( wpf_mod_language("logins") );
//-->>sprache
//<<--spam-abbruch
if( isset($_POST['name']) )
{
if( !isset($_SESSION['wpf_pw_count']) )
{
$_SESSION['wpf_pw_count'] = 1;
}
else
{
$_SESSION['wpf_pw_count'] += 1;
}
if( $_SESSION['wpf_pw_count'] > 3 )
{
$wpf_mess = $s_general_spamstop;
//$showtempl = false;
}
}
//-->>spam-abbruch
if( !empty($_GET['reset']) )
{
//Zurücksetzen Link angeklickt
$reset = wpf_clean($_GET['reset']);
$stamp = wpf_clean($_GET['stamp']);
$get = wpf_db("SELECT Edited FROM WPF_Logins WHERE Log_id='$reset'", true);
$stamp_check = md5($get[0]);
if( $stamp==$stamp_check )
{
$new = wpf_password_reset($reset);
echo $s_logins_password_reset_page_yourpassword." ".$new;
}
else
{
echo $s_logins_password_reset_page_error;
}
}
else
{
//Passwort bzw. Neusetzen-Link zusenden lassen
if( ($wpf_mess != $s_general_spamstop) && isset($_POST['name']) )
{
$name = wpf_clean($_POST['name']);
if( empty($name) )
{
$wpf_mess = $s_logins_password_fieldsmissing;
}
else
{
$res = wpf_db("SELECT L.Log_id, L.Name, L.Pass, L.Kon_id, L.Pass_crypted FROM WPF_Logins L, WPF_Login_groups G WHERE (L.Gro_id=G.Gro_id) AND (L.Name='$name' AND G.State>0 AND L.State>0)", true);
$id = $res[0];
$name = $res[1];
$pass = $res[2];
$contact = $res[3];
if( empty($id) )
{
$wpf_mess = $s_logins_password_usernotfound;
}
else
{
//übergebener Login-Name = Email
if( wpf_checkmail($name) )
{
$email = $name;
$wpf_mess = $s_logins_password_sent;
}
//email aus Kontakt zu Login
$res = wpf_db("SELECT Email, Birthdate FROM WPF_Kontakte WHERE Kon_id='$contact'", true);
$birthdate = $res[1];
if( !empty($res[0]) )
$email = $res[0];
//only crypted password exists -> create new
if( empty($pass) )
{
//kein unverschlüsseltes passwort vorhanden -> link zur neusetzung zuschicken
$set = wpf_db("UPDATE WPF_Logins SET Edited=NOW(), Log_id_lastedi=0 WHERE Log_id='$id' LIMIT 1");
$get = wpf_db("SELECT Edited FROM WPF_Logins WHERE Log_id='$id'", true);
$stamp = md5($get[0]);
$param = $id.'&stamp='.$stamp;
$lnk = ' '.$s_logins_password_reset_mail_lnktext.' ';
$text = $s_logins_password_reset_mail_text.$lnk;
wpf_sendmail($email, $s_logins_password_reset_mail_subject, $text);
$showtempl = false;
$wpf_mess = $s_logins_password_resetlinksent;
}
else
{
//unverschlüsseltes passwort vorhanden -> gleich zuschicken
$text = $s_logins_password_yourpassis." ".$pass;
wpf_sendmail($email, $s_logins_password_mail_subject, $text);
$showtempl = false;
$wpf_mess = $s_logins_password_sent;
}
}
}
}
$article = wpf_buffer($wpf_templatedir."logins/password_form.htm", $wpf_mess);
$templ = str_replace('"'."wpf.templ_pics/", '"'.$wpf_templatedir."logins/wpf.templ_pics/", $article);
echo $templ;
return $templ;
}
}
//-->>passwort vergessen
//<<--login / logout
function wpf_logout($noecho=false)
{
//<<--sprache
include( wpf_mod_language("logins") );
//-->>sprache
//<<--logout
//unset -> error
$_SESSION['wpf_login_name']="";
$_SESSION['wpf_login_pass']="";
$_SESSION['wpf_login_count']="";
$_SESSION['wpf_login_id']="";
unset($_SESSION['wpf_login_name']);
unset($_SESSION['wpf_login_pass']);
unset($_SESSION['wpf_login_count']);
unset($_SESSION['wpf_login_id']);
//@session_destroy();
//
if( isset($_COOKIE['wpf_login_name']) )
{
setcookie("wpf_login_name", "", time()-3600);
setcookie("wpf_login_pass", "", time()-3600);
}
//
if( isset($_SESSION['wpf_login_name']) )
{
if( isset($_GET['wpf_logout']) )
{
$wpf_mess = "".$s_logins_logout_out."
"; //"Logged out!";
}
}
else
{
$wpf_mess = ''.$s_logins_logout_logout_link.' ';
}
//-->>logout
if( !$noecho ) echo $wpf_mess;
return $wpf_mess;
}
function wpf_login($noecho=false, $forward2site="", $syslogin=false) //gibt true bzw. false zurück
{
//<<--sets
if( session_id()=="" ) { @session_start(); }
global $wpf_customdir, $wpf_password_salt, $wpf_templatedir, $wpf_downpath;
$downpath = $wpf_downpath; //downpath 2 wpf-root
$customdir = $wpf_customdir."logins/"; //Bilder
$showtempl = true;
$return = false;
global $wpf_userip;
//-->>sets
//<<--sprache
include( wpf_mod_language("logins") );
//-->>sprache
if( !isset($_GET['wpf_logout']) )
{
//<<--login
if( !isset($_SESSION['wpf_login_name']) )
{
if( isset($_POST['login_name']) )
{
$ok=false;
$user = wpf_clean($_POST['login_name']);
$pass = wpf_clean($_POST['login_pass']);
$pass_crypted = wpf_cryptpassword($pass); //noch unverschlüsselt (altes system) verschlüsselt (aktuell) auto-übergabe - nur verschlüsseltes vorhanden
//<-spam-abbruch
if( !$syslogin )
{
if( !isset($_SESSION['wpf_login_count']) )
{
$_SESSION['wpf_login_count'] = 1;
}
else
{
$_SESSION['wpf_login_count'] += 1;
}
if( $_SESSION['wpf_login_count'] > 5 )
{
$wpf_mess = $s_general_spamstop;
$antispam_stop = true;
//$showtempl = false;
}
}
//->spam-abbruch
//<-check
if( !$antispam_stop )
{
$res = wpf_db("SELECT L.Log_id, L.Name, MD5(L.Pass), L.Last_login, L.Pass_crypted FROM WPF_Logins L, WPF_Login_groups G WHERE (L.Gro_id=G.Gro_id) AND (L.Name='$user' AND ((L.Pass<>'' AND L.Pass='$pass') OR (L.Pass_crypted<>'' AND L.Pass_crypted='$pass_crypted') ) AND (G.State>0) AND (L.State>0))", true);
if( $res[0]!="" )
{
if( !empty($res[4]) )
$pass = $res[4];
else
$pass = $res[2];
//
$_SESSION['wpf_login_id'] = $res[0];
$_SESSION['wpf_login_name'] = $res[1];
$_SESSION['wpf_login_pass'] = $pass;
if( !empty($_POST['login_remember']) )
{
$days = time()+60*60*24*30; //30 tage
setcookie("wpf_login_name", $res[1], $days);
setcookie("wpf_login_pass", $pass, $days);
}
//<-last login
$_SESSION['wpf_login_last_beforethis'] = $res[3];
wpf_db("UPDATE WPF_Logins SET Last_login=NOW() WHERE Log_id='$res[0]'");
//->last login
$wpf_mess = $s_logins_login_loginokay;
$forward = true;
$showtempl = false;
$return = true;
}
else
{
$wpf_mess = $s_logins_login_invalid;
}
}
//->check
}
else
{
//$wpf_mess = $s_logins_login_nologin;
}
}
else
{
//...bereits eingeloggt
$wpf_mess = "";//$s_logins_login_loginokay;
$return = true;
$showtempl = false;
}
//-->>login
}
else
{
//<<--logout
$wpf_mess = wpf_logout(true);
$showtempl = true;
//-->>logout
}
//<<--template
$putin[0] = $wpf_mess;
if( $forward && strlen($forward2site)>1 ) $forwarder = wpf_siteforwarder($forward2site, true);
if( $noecho==false )
{
if( $showtempl )
{
$templ = wpf_buffer($wpf_templatedir."/logins/login_form.htm", $putin);
$templ = str_replace('"'."wpf.templ_pics/", '"'.$wpf_templatedir."logins/wpf.templ_pics/", $templ);
echo $templ;
}
else
echo $forwarder.$wpf_mess;
}
//-->>template
return $return;
}
//-->>login / logout
?>>Copyright / Info
//<<--Player ausgabe
function wpf_videoplayer($videofile_id="", $autostart=false, $noecho=false, $width="", $height="", $configfile="")
{
//<<--sets
global $wpf_userip, $wpf_videoplayer_w, $wpf_videoplayer_h, $wpf_showcase_videoplayer_w, $wpf_showcase_videoplayer_h, $wpf_customdir, $wpf_templatedir, $wpf_downpath;
$wpf_videos_player = "jplayer";
$downpath = $wpf_downpath; //-> cms
$customdir = $wpf_customdir."videos/";
//-->>sets
//<<--grösse
if( empty($width) )
{
$width = $wpf_videoplayer_w;
$height = $wpf_videoplayer_h;
}
//-->>grösse
//<<--abzuspielendes video
if( !empty($videofile_id) )
{
$id = wpf_clean($videofile_id);
}
if( isset($_GET['wpf_video']) )
{
$id = wpf_clean($_GET['wpf_video']); //alt
}
if( isset($_GET['wpf_vid_id']) )
{
$id = wpf_clean($_GET['wpf_vid_id']);
}
if( empty($id) ) $id = wpf_getlatestvideo();
//-->>abzuspielendes video
//<<--video
if( $id>0 )
{
$sql = "SELECT Videofile, Link, Cou_id, Embed, Name, Info FROM WPF_Videos WHERE Vid_id = '".$id."'";
$res = wpf_db($sql, true);
$video = $res[0];
$video_extern = $res[1];
$cou_id = $res[2];
$embedded_player = $res[3];
$name = $res[4];
$info = $res[5];
//<--formats
$formats = wpf_db("SELECT Videofile2, Videofile3 FROM WPF_Videos WHERE Vid_id = '".$id."'", true);
$flv = $video;
$mp4 = $formats[0];
$ogv = $formats[1];
//-->formats
//<--pic
$pic = wpf_getpic_path($mod_identifier="videos", $id, $pic_identifier="pic1");
//-->pic
//<--pfad
if( !empty($flv) ) $flv = $wpf_customdir."videos/files/".$flv;
if( !empty($mp4) ) $mp4 = $wpf_customdir."videos/files/".$mp4;
if( !empty($ogv) ) $ogv = $wpf_customdir."videos/files/".$ogv;
//-->pfad
//<--counter updaten
$counter = wpf_updatecounter($cou_id);
//-->counter updaten
//<--typ
if( !empty($video_extern) )
{
$video_file = $video_extern;
}
else
{
$video_file = "../files/".$video; //pfad in player vorher: flv/1.flv
if( @!file_exists($video_file) )
{
//aus showcase-iframe
$video_file = "../../videos/files/".$video;
}
}
//-->typ
//<--config file
if( empty($configfile) )
$config = "configuration.xml";
else
$config = $configfile;
//-->config file
//<--aufruf aus showcase-iframe?
if( @!file_exists($customdir) )
$path = "../../videos/".$wpf_videos_player."/";
else
$path = $customdir.$wpf_videos_player."/";
//-->aufruf aus showcase-iframe?
//<--details
$wpf_putin[0] = $video_file;
$wpf_putin[1] = $config;
$wpf_putin[2] = $width;
$wpf_putin[3] = $height;
$wpf_putin[4] = $path;
$wpf_putin[5] = $id;
$wpf_putin[6] = $name;
$wpf_putin[7] = $info;
$wpf_putin[8] = $counter;
$wpf_putin[9] = $pic;
$wpf_putin[10] = "_wpframe/jquery/plugins_wpf/jplayer/scripts"; //$wpf_customdir."videos/";
$wpf_putin[11] = $flv;
$wpf_putin[12] = $mp4;
$wpf_putin[13] = $ogv;
//-->details
//<--templates
if( strlen($embedded_player)>1 )
{
$player = wpf_videoplayer_embed($id, true, $width, $height, $thumbclick_beforeplay=false, $thumb_width=-1, $thumb_height=-1, $external_video_link=false);
}
else
{
$templ = $wpf_templatedir."videos/".$wpf_videos_player."/jplayer.htm";
if( @!file_exists($templ) ) $templ = $downpath.$templ; //aus showcase-iframe
$player = wpf_buffer($templ, $wpf_putin);
}
//-->templates
//<--main templ
$templ = $wpf_templatedir."videos/videoplayer.htm";
if( @!file_exists($templ) ) $templ = $downpath.$templ; //aus showcase-iframe
$wpf_putin[100] = $player;
$player = wpf_buffer($templ, $wpf_putin);
//-->main templ
}
else $player = false;
//-->>video
if( !$noecho ) echo $player;
return $player;
}
//-->>Player ausgabe
//<<--Video in Liste mit Gruppen und Player
function wpf_video($autostart=true, $group_id="", $group_search="", $video_id="", $top=false)
{
//<<--sets
global $wpf_customdir, $wpf_templatedir, $wpf_downpath;
$downpath = $wpf_downpath; //-> cms
$customdir = $wpf_customdir."videos/";
//-->>sets
if( isset($_GET['wpf_videogroup']) ) $group_id = wpf_clean($_GET['wpf_videogroup']);
if( empty($group_id) )
{
$firstgroup_id = wpf_video_groups($group_id, true, false, "", "", $group_search, true);
if( !empty($firstgroup_id) ) $group_id = $firstgroup_id;
}
$groups = wpf_video_groups($group_id, true, false, "", "", $group_search);
$list = wpf_videos($group_id, "", true, false, true, false, false, false, false, false, $top);
if( !empty($_GET['wpf_vid_id']) ) $video_id = wpf_clean($_GET['wpf_vid_id']);
if( !empty($video_id) )
{
$get = wpf_db("SELECT Embed, Name, Info FROM WPF_Videos WHERE Vid_id='$video_id'", true);
if( $get[0]<>"" ) $embedded = true;
//
if( $embedded )
$player = wpf_videoplayer_embed($video_id, $noecho=true);
else
$player = wpf_videoplayer($video_id, $autostart, true);
}
else
$player = "";
$wpf_putin[0] = $group_id;
$wpf_putin[1] = $player;
$wpf_putin[2] = $list;
$wpf_putin[3] = $groups;
if( !empty($video_id) )
{
$wpf_putin[4] = $get[1];
$wpf_putin[5] = nl2br($get[2]);
$wpf_putin[6] = wpf_video_get_pic($video_id);
}
$wpf_putin[10] = $video_id;
//<--player nicht anzeigen, wenn keine videos
if( $list!=false )
{
$templ = $wpf_templatedir."videos/video_frame.htm";
$return = wpf_buffer($templ, $wpf_putin);
$return = str_replace('"'."wpf.templ_pics/", '"'.$wpf_templatedir."videos/wpf.templ_pics/", $return);
}
else $return = "";
//-->player nicht anzeigen, wenn keine videos
echo $return;
return $return;
}
//-->>Video in Liste mit Gruppen und Player
//<<--Gruppen listen
function wpf_videos_groups($group_id="", $noecho=false, $template=false)
{
return wpf_video_groups($group_id, $noecho, $template);
}
function wpf_video_groups($group_id="", $noecho=false, $template=false, $langonly=false, $dropdown=false, $search="", $return1groupid=false)
{
//<<--sets
global $wpf_customdir, $wpf_videodetail, $wpf_templatedir;
$customdir = $wpf_customdir."videos/";
$customdir_templ = $wpf_templatedir."videos/";
$tabez = "Video_groups";
$idbez = "Vig_id";
include( wpf_mod_language("_cms") );
//-->>sets
//<<--template
if( $template && !empty($template) )
$templ = $customdir_templ.$template;
else
$templ = $customdir_templ."video_groups_listing.htm";
//-->>template
//<<--sortby
$sortby = wpf_cms_sortby("videos", "Vig_id");
//-->>sortby
//<<--nur für login-level x?!
$loginlevel = wpf_getloginlevel($_SESSION['wpf_login_id']);
$limit_sql = " AND Regonly_level<=".$loginlevel;
//-->>nur für login-level x?!
//<<--nur in aktiver sprache?!
if( $langonly )
{
$limit_sql .= " AND Langu='$sprache' ";
}
//-->>nur in aktiver sprache?!
//<--suche
if( isset($_POST["wpf_search"]) || !empty($search) )
{
$se = wpf_clean($_POST["wpf_search"]);
if( !empty($search) ) $se = $search;
$se = strtolower($se);
$search_sql .= " AND ((LOWER(Keywords) LIKE '%".$se."%') OR (LOWER(Info) LIKE '%".$se."%') OR (LOWER(Name) LIKE '%".$se."%')) ";
}
else
$search_sql = "";
//-->suche
//<--sel
if( !empty($group_id) ) $sel = $group_id;
if( isset($_GET['wpf_videogroup']) ) $sel = wpf_clean($_GET['wpf_videogroup']);
if( empty($sel) ) $sel = wpf_videos_groups_getfirst();
//-->sel
//<<--ausgabe
$return="";
$group_dropdown=""; $group="";
$order_sql = " ORDER BY $sortby ";
$sql = "SELECT $idbez, Created, Edited, State, Langu, Name, Info, Keywords, Log_id_creater, Log_id_lastedi, State_langonly FROM WPF_$tabez WHERE (State > 0) ".$search_sql." ".$limit_sql.$order_sql;
$res = wpf_db($sql);
$i=0; if($res!=false) foreach($res as $row)
{
//<-details
$id = $row[0];
$created = $row[1];
$edited = $row[2];
$aktiv = $row[3];
$sprache = $row[4];
$name = $row[5];
$info = nl2br($row[6]);
$keywords = $row[7];
$log_id_creater = $row[8];
$log_id_lastedi = $row[9];
$langonly = $row[10];
//->details
//Detaillink anhand Detailvariable in Config
$openfile = $wpf_videodetail.'_'.$_SESSION['wpf_language'].'.php';
//<<--bild
$pic_tag = wpf_pixbox($pic_id=false, $mod_identifier="video_groups", $mod_id=$id, "pic1", $disablezoom=!$detail);
//->bild
//
if( $i==0 ) $firstid = $id;
//<--dropdown
if( $id == $sel ) $sele = " selected"; else $sele = "";
$group_dropdown .= ''.$name.' ';
//-->dropdown
//<--normal
if( $sel==$id ) $selected = true; else $selected = false;
$group = ''.$name.' ';
//<-template
$wpf_putin[0] = $id;
$wpf_putin[1] = $name;
$wpf_putin[2] = $info;
$wpf_putin[3] = $pic;
$wpf_putin[4] = $group;
$wpf_putin[51] = $selected;
$article = wpf_buffer($templ, $wpf_putin);
$return .= str_replace("wpf.templ_pics/", $customdir_templ."wpf.templ_pics/", $article);
//->template
//-->normal
$i++;
}
//-->>ausgabe
//<<--template - dropdown
if( $dropdown )
{
$group_dropdown = ''.$group_dropdown.' ';
$group_dropdown = '';
$wpf_putin[0] = $group_dropdown;
$article = wpf_buffer($templ, $wpf_putin);
$return .= str_replace("wpf.templ_pics/", $customdir_templ."wpf.templ_pics/", $article);
}
//-->>template - dropdown
//<<--erste gruppe zurückgeben
if( $return1groupid )
{
$return = $firstid;
$noecho = true;
}
//-->>erste gruppe zurückgeben
//if( $i==0 ) $return = $ms01;
if( !$noecho ) echo $return;
return $return;
}
//-->>Gruppen listen
//<<--Videos auflisten
//iframe_target = name der zieldatei... -> iframe name = iframe_target-file minus dateiendung (/_custom/test.php -> test)
function wpf_videos($group_id="", $vid_id="", $noecho=false, $limit="", $listonly=false, $langonly=false, $search="", $showmessages=false, $iframe_target=false, $template="", $top=false, $justreturn_firstvideo=false)
{
//<<--sets
//$ms01 = nixda_meldung();
global $wpf_userip, $wpframe_moddir, $wpf_customdir, $wpf_videodetail, $wpf_downpath, $wpf_templatedir;
$downpath = $wpf_downpath; //-> cms
$customdir = $wpf_customdir."videos/";
$customdir_files = $customdir."files/";
$customdir_templ = $wpf_templatedir."videos/";
$sprache = $_SESSION['wpf_language'];
$tabez = "Videos";
$idbez = "Vid_id";
//-->>sets
//<<--sortby
$sortby = wpf_cms_sortby("videos", "Vid_id");
//-->>sortby
//<<--sprache
global $wpf_language;
if( $wpf_language=="de" )
$ms01 = "Momentan keine vorhanden";
else
$ms01 = "None exist at the moment";
$ms01 = "$ms01
";
//-->>sprache
//<<--nur in aktiver sprache?!
if( $langonly )
{
//$limit_sql = " AND Langu='$sprache' ";
}
//-->>nur in aktiver sprache?!
//<<--nur für login-level x?!
$loginlevel = wpf_getloginlevel($_SESSION['wpf_login_id']);
$limit_sql = " AND Regonly_level<=".$loginlevel;
//-->>nur für login-level x?!
//<<--limit
if( !empty($limit) )
{
$limit = wpf_clean($limit);
if( is_int($limit) ) $limit_sql2 = " LIMIT $limit";
}
else
$limit_sql2 = "";
//-->>limit
//<-suche
if( isset($_POST["wpf_search"]) || !empty($search) )
{
$se = wpf_clean($_POST["wpf_search"]);
if( !empty($search) ) $se = $search;
$se = strtolower($se);
$search_sql .= " AND ((LOWER(Info) LIKE '%".$se."%') OR (LOWER(Name) LIKE '%".$se."%')) ";
}
else
$search_sql = "";
//->suche
//<- Top
if( $top )
$search_sql .=" AND Top = 1";
//-> Top
//<-einzeln via id-übergabe
/* if( !empty($vid_id) || isset($_GET['wpf_vid_id']) )
{
$search_sql .= " AND $idbez='$vid_id' ";
}*/
//->einzeln via id-übergabe
$return="";
//<<--aufrufe
$detail = false;
//<-einzelner
if( isset($_GET["wpf_vid_id"]) && !$listonly )
{
$id = wpf_clean($_GET["wpf_vid_id"]);
$res = wpf_db("SELECT $idbez FROM WPF_$tabez WHERE State > 0 AND $idbez = '$id'");
if( $res!=false )
{
$search_sql .= " AND $idbez = '$id'";
$detail = true;
$return .= ''; //Details
$linkfile = $detail_link; //'';
$file = $linkfile.$pic.' ';
$linkonly = $url.'?wpf_vid_id='.$id.'#vid'.$id;
//->Details
//<-Infos
if( $log_id_creater==0 )
$creater = "Admin";
else
$creater = "User #".$log_id_creater;
if( $log_id_lastedi==0 )
$editor = "Admin";
else
$editor = "User #".$log_id_lastedi;
$created = wpf_ts2de($created);
$edited = wpf_ts2de($edited);
$res = wpf_db("SELECT Count, Last_ip FROM WPF_Counter WHERE Cou_id='$cou_id'", true);
$counter = $res[0];
$last_ip = $res[1];
//->Infos
//<-bild
$pic_tag = wpf_pixbox($pic_id=false, $mod_identifier="videos", $mod_id=$id, "pic1", $disablezoom=!$detail);
//wenn bei embed kein bild -> thumb von hoster übernehmen:
if( $pic_tag==false && !empty($embed) )
{
$pic = wpf_video_get_externalthumb($id);
$pic_tag = '
if( $i==0 )
{
if( $showmessages )
$return = $ms01;
else
$return = false;
}
if( !$noecho && !$justreturn_firstvideo ) echo $return;
if( $justreturn_firstvideo )
{
return $firstvideo;
}
else
{
if( $iframe_target <> false )
return $all; ////Return für Showcase-Slider z.B.
else
return $return;
}
}
//-->>Videos auflisten
//<<--Eingebettete Player
function wpf_videoplayer_embed($video_id, $noecho=false, $cwidth=-1, $cheight=-1, $thumbclick_beforeplay=false, $thumb_width=-1, $thumb_height=-1, $external_video_link=false)
{
global $wpf_customdir, $wpf_videoplayer_embed_w, $wpf_videoplayer_embed_h, $wpf_downpath, $wpf_templatedir;
$downpath = $wpf_downpath;
$templ_dir = $wpf_customdir."videos/embed_codes/";
if( isset($_GET['wpf_vid_id']) )
{
$video_id = wpf_clean($_GET['wpf_vid_id']);
}
//
$video = wpf_db("SELECT Embed, Cou_id, Name, Info, Vid_id FROM WPF_Videos WHERE State>0 AND Embed<>'' AND Vid_id = '".$video_id."'", true);
$cou_id = $res[1];
$name = $video[2];
$info = $video[3];
$id = $video[4];
$video = $video[0];
//
if( $external_video_link<>false && !empty($external_video_link) )
{
$id = -1;
$cou_id = -1;
$video = $external_video_link;
}
else $external_video_link = false;
//
$height = $wpf_videoplayer_embed_h; $width = $wpf_videoplayer_embed_w;
if( empty($height) ) { $height = 640; $width = 480; }
if( $cwidth>-1 ){ $width = $cwidth; $height = $cheight; }
//
$wpf_putin[5] = $name;
$wpf_putin[6] = $info;
//
if( !empty($id) )
{
//$counter = wpf_updatecounter($cou_id);
if( !file_exists($templ_dir."youtube.htm") ) $templ_dir = $downpath.$templ_dir; //showcase aufruf
//youtube
if( substr_count($video, "youtube.com")>0 )
{
$external_id = wpf_video_extract_externalid($video_id, $external_video_link);
$putin[0] = $external_id;
$putin[1] = $height;
$putin[2] = $width;
$putin[3] = '&enablejsapi=1&playerapiid=ytplayer'.$video_id;
$embed = wpf_buffer($templ_dir."youtube.htm", $putin);
$img = wpf_video_get_externalthumb($video_id, $external_video_link);
$type = "youtube";
}
//vimeo
elseif( substr_count($video, "vimeo.com")>0 )
{
$external_id = wpf_video_extract_externalid($video_id, $external_video_link);
$putin[0] = $external_id;
$putin[1] = $height;
$putin[2] = $width;
$putin[3] = "";
$embed = wpf_buffer($templ_dir."vimeo.htm", $putin);
$img = wpf_video_get_externalthumb($video_id, $external_video_link);
$type = "vimeo";
}
//myvideo
elseif( substr_count($video, "myvideo.de")>0 )
{
$external_id = wpf_video_extract_externalid($video_id, $external_video_link);
$putin[0] = $external_id;
$putin[1] = $height;
$putin[2] = $width;
$putin[3] = "";
$embed = wpf_buffer($templ_dir."myvideo.htm", $putin);
$img = wpf_video_get_externalthumb($video_id, $external_video_link);
$type = "myvideo";
}
//
if( empty($embed) ) wpf_debugmessage("Embedding error - invalid code?!", "wpf_embedplayer");
else
{
if( $thumbclick_beforeplay )
{
if( $thumb_height>-1 ) $size = ' width="'.$thumb_width.'" height="'.$thumb_height.'"';
//
if( $id==-1 )
{
$video_id = date("isu").rand(11, 999);
$ucount = "";
}
else
{
$ucount = 'wpf_updatecounter4video('.$video_id.');';
}
//
if( $type=="youtube" && substr_count($embed, $putin[3])>0 )
$jsadd = " ytplayer".$video_id.".playVideo();";
else
$jsadd = "";
//
$embed = ''.$embed.'
'; //video
$embed = ''.$embed; //thumb
}
//
if( !$noecho ) echo $embed;
$return = $embed;
}
}
else wpf_debugmessage("Couldn't find video or no valid Embed code!", "wpf_embedplayer");
return $return;
}
//-->>Eingebettete Player
//<<--externes thumb
function wpf_video_get_externalthumb($video_id, $external_video_link=false)
{
global $wpf_themedir;
$video = wpf_db("SELECT Embed, Cou_id, Name, Info, Vid_id FROM WPF_Videos WHERE State>0 AND Embed<>'' AND Vid_id = '".$video_id."'", true);
$video = $video[0];
$external_id = wpf_video_extract_externalid($video_id, $external_video_link);
if( $external_video_link<>false )
$video = $external_video_link;
$video = strtolower($video);
//youtube
if( substr_count($video, "youtube.com")>0 )
{
if( substr_count($video, "https://")>0 )
$pre = "https://";
else
$pre = "http://";
$img = $pre."img.youtube.com/vi/".$external_id."/default.jpg";
}
//vimeo
elseif( substr_count($video, "vimeo.com")>0 )
{
$img = get_vimeo_info($external_id);
}
//myvideo etc
elseif( substr_count($video, "myvideo.de")>0 )
{
$img = false; //fuck myvideo
}
//
return $img;
}
//-->>externes thumb
//<<--pic
function wpf_video_get_pic($id)
{
global $wpf_themedir;
$get = wpf_db("SELECT Embed FROM WPF_Videos WHERE Vid_id='$id'", true);
$embed = $get[0];
$pic_tag = wpf_pixbox($pic_id=false, $mod_identifier="videos", $mod_id=$id, "pic1", $disablezoom=true);
if( $pic_tag==false && !empty($embed) ) $pic_tag = wpf_video_get_externalthumb($id);
if( $pic_tag==false ) $pic_tag = $wpf_themedir."images/main_design/nopic.png";
if( substr_count($pic_tag, ''.$link.' ';
$wpf_putin[0] = $link_full;
$wpf_putin[1] = $link;
$btext = wpf_buffer('_wpframe_themes/reim/templates/contacts/contact_mail_semmel.htm',$wpf_putin);
//$btext = wpf_mailtemplate_paths($btext);
wpf_sendmail($email, "Newsletteranmeldung", $btext);
//$wpf_mess = 'Vielen Dank für Ihre Anmeldung!
';
}
/*// Prüfen ob vorhanden
$sql = "SELECT Email, Kon_id FROM WPF_Kontakte WHERE Email='".$email."'";
$res = wpf_db_external($sql, true);
if (count($res)>0)
{
$kon_id=$res[1];
$nl_mess = "Hinweis: Ihre Emailadresse befindet sich bereits in unserem Newsletterverteiler.";
$sql = "UPDATE WPF_Kontakte SET Herkunft='Semino Rossi $mode' WHERE Kon_id='$kon_id'";
$res = wpf_db_external($sql);
}
else
{
// Key
$passkey = passkey(16);
$sql_key = ", Added4Newsletter, Passkey";
$sql_key_value = ", '1', '$passkey'";
// Eintrag
$herkunft_db = 'Semino Rossi '.$mode;
$res = wpf_db_external("INSERT INTO WPF_Kontakte (Created, Nummer, Name, Firma, Anrede, Titel, Vorname, Nachname, Strasse, Plz, Ort, Lan_id, Telefon, Telefax, Handy, Email, Homepage, Email_news, Sms_news".$sql_key.", Herkunft, Kuenstler_fav)
VALUES (NOW(), '$nummer', '', '$firma', '$anrede', '$titel', '$vorname', '$nachname', '$strasse', '$plz', '$ort', '$lan_id', '$telefon', '$telefax', '$mobil', '$email', '$homepage', '0', '$sms_news'".$sql_key_value.", '$herkunft_db', '$kuenstler_fav')");
// Katgeorie Schlager
$res2 = wpf_db_external("INSERT INTO WPF_Kontakt_Kategorien_Links (State, Kon_id, Kat_id) VALUES ('1', ".$res.", '3')");
// DoubleOpt Mail
$stamp = wpf_db_external("SELECT Created FROM WPF_Kontakte where Kon_id='".$res."'", true);
$stamp = $stamp[0];
$link = "http://www.semmel.de/_wpframe/_wpf.mods/contacts/verify.php";
$link = ''.$link.' ';
$wpf_putin[0] = $link;
//$btext = wpf_buffer($customdir."templates/confirmjoin_mail.htm",$wpf_putin);
$btext = wpf_buffer($wpf_templatedir."newsletter/newsletter_confirmjoin_mail.htm",$wpf_putin);
wpf_sendmail($email, "Ihre Newsletter-Anmeldung auf Semino Rossi", $btext);
}*/
}
//Videowall > Extra
if ($mode=="videowall")
{
$file = $_POST['newfile'];
$res = wpf_db("INSERT INTO WPF_Videowall (Vorname, Email, Stadt, Text, File) VALUES ('$vorname', '$email', '$ort', '$info', '$file')");
$dontshowform = true;
wpf_sendmail("m.streng@webprojaggt.de", "Neuer Eintrag für die Semino Rossi Konzertgrüße", "$name $vorname: Vielen Dank '.$vorname.' für Deine Teilnahme!'.$nl_mess.'
';
}
elseif ($mode=="fanbrief")
{
$file = $_POST['newfile'];
//echo "INSERT INTO WPF_Fanbrief (Name, Vorname, Email, Headline, Info, Created, File, State) VALUES ('$nachname', '$vorname', '$email', '$ort', '$info', NOW(), '$file', '1')";
$res = wpf_db("INSERT INTO WPF_Fanbrief (Name, Vorname, Email, Headline, Info, Created, File, State, Langu) VALUES ('$nachname', '$vorname', '$email', '$ort', '$info', NOW(), '$file', '0', '".$_SESSION['wpf_language']."')");
$dontshowform = true;
wpf_sendmail("online@semmel.de", "Neuer Eintrag für das James Last Kondolenzbuch", 'Name: '.$nachname.' '.$vorname.' JETZT FREISCHALTEN JETZT FREISCHALTEN '.$s_contacts_success_info.'
';
$wpf_putin[0] = $s_contacts_success_mail;
$mailtext = wpf_buffer("_wpframe_themes/reim/templates/contacts/contact_mail.htm", $wpf_putin);
wpf_sendmail($email, $s_contacts_success_mail_subject, $mailtext);
}
else
{
/*//<-vorhanden?
if( $mode=="emailnews" ) $sql = "SELECT Email FROM WPF_Kontakte WHERE LOWER(Email)='".$email."' AND Kog_id=10 AND State<>-1";
elseif( $mode=="smsnews" ) $sql = "SELECT Handy FROM WPF_Kontakte WHERE Handy='".$handy."' AND Kog_id=10 AND State<>-1";
else $sql = "SELECT Info, IP FROM WPF_Kontakte_Anfragen WHERE Info='".$info."' AND Zusatzfelder='$zusatzfelder' AND State<>-1 AND IP='".$wpf_userip."'"; //zeitlich noch eingrenzen!!
$res = wpf_db($sql, false, true);
if( $res==0 )
{
//<-save
//email + sms news
if( $mode=="emailnews" || $mode=="smsnews" )
{
if( empty($nachname) )
{
if( $mode=="emailnews" )
$nachname = $email;
else
$nachname = $sms;
}
//mark
if( $mode=="emailnews" )
$added4 = 1;
else
$added4 = 0;
//erst via mail-link bestätigen
if( ($mode=="emailnews") && ($wpf_newsletter_confirmjoin) )
{
$confirm = true;
$email_news=0;
}
else
{
$confirm = false;
$email_news=1;
}
//newsletter
$res = wpf_db("INSERT INTO WPF_Kontakte (Created, State, Nummer, Name, Firma, Anrede, Titel, Vorname, Nachname, Strasse, Plz, Ort, Lan_id, Telefon, Telefax, Handy, Email, Homepage, Email_news, Sms_news, Added4Newsletter, Kog_id)
VALUES (NOW(), 1, '$nummer', '', '$firma', '$anrede', '$titel', '$vorname', '$nachname', '$strasse', '$plz', '$ort', '$lan_id', '$telefon', '$telefax', '$handy', '$email', '$homepage', '$email_news', '$sms_news', '$added4', 10)");
$kon_id = $res;
//kategorien
if( $kon_id>0 && !empty($cats) )
{
foreach($cats as $cat)
{
$ins = wpf_db("INSERT INTO WPF_Kontakt_Kategorien_Links (Kon_id, Kat_id) VALUES ('$kon_id', '$cat')");
}
}
//erst via mail-link bestätigen
if( $confirm )
{
$stamp = wpf_db("SELECT Created FROM WPF_Kontakte WHERE Kon_id='".$res."'", true);
$stamp = md5($stamp[0]);
$link = $wpf_fullurlpa."_wpf.modloader.php?wpf_mod=confirm_newsletter";//$wpframe_moddir."newsletter/confirm.php";
$link = ''.$link.' ';
$wpf_putin[0] = $link;
$btext = wpf_buffer($wpf_templatedir."newsletter/newsletter_confirmjoin_mail.htm",$wpf_putin);
wpf_sendmail($email, $s_newsletter_mail_subject, $btext);
}
}
else
{
//contact form
//kontakt vorhanden? -> verwenden!
if( !empty($nachname) && !empty($strasse) && !empty($plz) && !empty($email) )
{
$res = wpf_db("SELECT Kon_id FROM WPF_Kontakte WHERE (Kog_id='2') AND ((Nachname='$nachname' AND Strasse='$strasse' AND Plz='$plz') OR (Nachname='$nachname' AND Plz='$plz' AND Email='$email'))", true);
if( !empty($res[0]) ) $kon_id = $res[0];
}
//nicht vorhanden->anlegen
if( !isset($kon_id) )
{
$res = wpf_db("INSERT INTO WPF_Kontakte (Created, Nummer, Name, Firma, Anrede, Titel, Vorname, Nachname, Strasse, Plz, Ort, Lan_id, Telefon, Telefax, Handy, Email, Homepage, Email_news, Sms_news, State, Kog_id)
VALUES (NOW(), '$nummer', '', '$firma', '$anrede', '$titel', '$vorname', '$nachname', '$strasse', '$plz', '$ort', '$lan_id', '$telefon', '$telefax', '$handy', '$email', '$homepage', '$email_news', '$sms_news', 1, 2)");
$kon_id = $res;
}
//anfrage
if( $kon_id>0 ) // && (!empty($info) || !empty($zusatzfelder))
{
$anf_id = wpf_db("INSERT INTO WPF_Kontakte_Anfragen (Created, IP, Info, Kon_id, Zusatzfelder) VALUES (NOW(), '$wpf_userip', '$info', '$kon_id', '$zusatzfelder')");
}
else
$wpf_mess = "System Error while inserting your contact, sorry. Please refresh page and try again.";
}
//->save
//<-message
if( $kon_id>0 ) $saved = true;
if( $mode=="emailnews" )
{
if( $confirm )
$wpf_mess = $s_contacts_confirm;
else
$wpf_mess = $s_contacts_newsletter_ok;
}
else
{
$wpf_mess = $s_contacts_ok;
}
//->message
$sendmail = true;
}
else
{
$wpf_mess = $s_contacts_already;
$sendmail = false;
}
//->vorhanden?*/
}
}
else $wpf_mess = $s_contacts_ok;
//line_breaks
if( $dbsupport && $anf_id>0 )
{
$get = wpf_db("SELECT Info FROM WPF_Kontakte_Anfragen WHERE Anf_id='$anf_id'", true);
$info = $get[0];
}
//<-bestätigungsmail
if( (!$dbsupport) || ($dbsupport && $sendmail) )
{
if( $mode=="contact" )
{
$wpf_putin[0] = $kon_id;
$wpf_putin[1] = $firma;
$wpf_putin[2] = $anrede." ".$titel;
$wpf_putin[3] = $vorname;
$wpf_putin[4] = $nachname;
$wpf_putin[5] = $strasse;
$wpf_putin[6] = $plz;
$wpf_putin[7] = $ort;
$wpf_putin[8] = $telefon;
$wpf_putin[9] = $telefax;
$wpf_putin[10] = $handy;
$wpf_putin[11] = $email;
$wpf_putin[12] = $homepage;
$wpf_putin[20] = $_POST['info'];
$wpf_putin[21] = $join_nl;
$wpf_putin[22] = $zusatzfelder;
for($x=1;$x<21;$x++)
{
$wpf_putin[$x+100] = $additional_field[$x]; //putins 100
$wpf_putin[$x+200] = $additional_field_description[$x]; //putins 200
$wpf_putin[$x+300] = $additional_field_check[$x]; //putins 300
}
$text = wpf_buffer($wpf_templatedir."contacts/contact_mail.htm", $wpf_putin);
$text = str_replace('"'."wpf.templ_pics/", '"'.$wpf_fullurlpa.$wpf_templatedir."contacts/wpf.templ_pics/", $text);
//mail 2 admin
wpf_sendmail($wpf_adminmail, $s_contacts_email_foradmin, $text, $anhang="", $puretxt=false, $email);
//mail 2 user
wpf_sendmail($email, $s_contacts_email_foruser, $text);
$clear_fields = true;
}
}
//->bestätigungsmail
}
}
//-->check
}
//-->>abgeschickt
//<<--interface
if( !isset($land) ) $land=34;
if( $dbsupport )
$land = wpf_country($_SESSION['wpf_language'], $land);
else
$land = 'Deutschland '.($i+1).' '; //$sel = " selected"; else $sel = "";
else
{
if( isset($_GET['kat_id']) )
$sql_add.= "&kat_id=".$_GET['kat_id']."";
if ( isset($se) )
$seite_auswahl .= ''.($i+1).' ';
else
$seite_auswahl .= ''.($i+1).' ';
}
}
if($i==0) $seite_auswahl = '1'; //nur 1
//->seite
//<-template
$WPF_PUTIN[0] = $seite_auswahl;
$WPF_PUTIN[1] = $aktuelle_seite+1;
$WPF_PUTIN[2] = $seite_vor;
$WPF_PUTIN[3] = $seite_zruck;
$templ = $customdir."/templates/navi.htm";
if ($datensaetze_anz > $prose)
$navi = wpf_buffer($templ, $WPF_PUTIN);
//->template
}
else $navi="";
//-->>interface navi
if( !empty($limit) )
$limit_sql2 = "Limit ".$limit."";
$order_sql = " ORDER BY G.Name";
if( $highlight_pool )
{
$order_sql = " ORDER BY RAND()";
//Bei Pool die schon ausgelesenen ID´s ausschließen
$search_sql .= $_SESSION['pool_res'];
}
$result="";
//Gesamtanzahl des Queries zählen
$group_count = wpf_db_external("SELECT G.Evg_id FROM WPF_Event_groups G, WPF_Event_groups_infos I, WPF_References R, WPF_Events E, WPF_Event_locations L WHERE (G.Ref_id = R.Ref_id) AND (G.Evg_id = I.Evg_id) AND (G.Evg_id = E.Evg_id) AND (E.Elo_id = L.Elo_id) AND (G.State > '0') AND E.Beg > NOW() AND (E.Ueberregional_Nachname = 'Wykrota' OR L.City LIKE '%Köln%' ) ".$search_sql." GROUP BY G.Evg_id".$order_sql." ".$limit_sql,$limit_sal2, false, true);
$group_res = wpf_db_external("SELECT G.Evg_id, G.Ref_id, G.Name, I.Info, I.Info_web, R.Name, G.Info, G.Url, G.Keywords, MAX(E.Beg) as last_date FROM WPF_Event_groups G, WPF_Event_groups_infos I, WPF_References R, WPF_Events E, WPF_Event_locations L WHERE (G.Ref_id = R.Ref_id) AND (G.Evg_id = I.Evg_id) AND (G.Evg_id = E.Evg_id) AND (E.Elo_id = L.Elo_id) AND (G.State > '0') AND E.Beg > NOW() AND (E.Ueberregional_Nachname = 'Wykrota' OR L.City LIKE '%Köln%' )".$search_sql." GROUP BY G.Evg_id".$order_sql." ".$limit_sql.$limit_sql2);
$c = 1; $i=0; if($group_res!=false) foreach($group_res as $row)
{
$id = $row[0];
$ref_id = $row[1];
$group_name = $row[2];
$info = $row[3];
$info_web = $row[4];
if( !empty($info_web) )
$infotext = $info_web;
else
$infotext = $info;
$tourname = $row[5];
$tourinfo = $row[6];
$tourlink = $row[7];
$keywords = $row[8];
//-->Tourscreen auslesen
$res_bild = wpf_db_external("select P.File, G.Folder from WPF_Pics P, WPF_Pic_groups G, WPF_Event_groups_Picgroups_Lnk L where P.Pig_id = G.Pig_id and G.Pig_id = L.Pig_id and L.Evg_id = ".$id." and P.Keywords = 'TOURSCREEN'", true);
$pic_file = $res_bild[0];
$pic_folder = $res_bild[1];
if( !empty($pic_file) )
{
$bild = 'http://www.semmel.de/_wpframe_custom/gallery/files/'.$pic_folder."w_".$pic_file;
//Kleines Bild für Übersicht
$bild_small = 'http://www.semmel.de/_wpframe_custom/gallery/files/'.$pic_folder."t_".$pic_file;
}
else
{
$bild = 'http://www.semmel.de/images/main-design/artwork_dummy.jpg';
//Kleines Bild für Übersicht
$bild_small = 'http://www.semmel.de/images/main-design/artwork_dummy.jpg';
}
//-->Infos über Künstler holen
$res_kuenstler = wpf_db_external("SELECT G.Name, R.Link FROM WPF_References R, WPF_References_groups G, WPF_References_Referencesgroups_Lnk L WHERE R.Ref_id = L.Ref_id AND L.Reg_id = G.Reg_id AND R.Ref_id = ".$ref_id."", true);
$kat_name = $res_kuenstler[0];
$hyperlink = $res_kuenstler[1];
//<--Infos über Künstler holen
//Ticketlink für Eventreihe bauen
$res2 = wpf_db_external("SELECT E.Link, E.Ticketlink FROM WPF_Event_groups G, WPF_Events E WHERE E.Evg_id = G.Evg_id AND G.Ref_id = ".$ref_id." AND E.Beg > NOW() AND E.Link<>'' order by E.Beg", true);
if( !empty($res2[0]) )
{
$link_expl = explode("$",$res2[0]);
$ticketlink = 'http://www.eventim.de/tickets.html?fun=erdetail&affiliate=sem&doc=erdetaila&erid='.$link_expl[0].'&referer_info=semmel_de';
}
elseif( empty($res2[0]) && !empty($res2[1]) )
$ticketlink = 'http://'.str_replace("http://","",$res2[1]);
else
$ticketlink = "";
//<--Bei previewmode die ersten drei Termine der Gruppe in Ãœbersicht mit austgeben, sonst alle
$i++;
//<--line template
$wpf_putin[0] = $id;
$wpf_putin[1] = $group_name;
//h1 und h2 Tags, die aus der DB kommen strippen
//$infotext = wpf_strip_text($infotext, 'h1', true);
//$infotext = wpf_strip_text($infotext, 'h2', true);
$wpf_putin[2] = $infotext;
$wpf_putin[3] = $name;
$wpf_putin[4] = $bild;
$wpf_putin[5] = $ref_id;
$wpf_putin[6] = $kat_name;
$wpf_putin[7] = $hyperlink;
$wpf_putin[8] = $tourinfo;
$wpf_putin[9] = $tourlink;
$wpf_putin[10] = $bild_small;
$wpf_putin[11] = $ticketlink;
$wpf_putin[12] = false;
if ($c==1) { $wpf_putin[12] = true; };
if ($c==4) { $c=0; };
$c++;
//-->line template
if( $detail )
$templ = "details";
else
{
if( $top )
$templ = "listing-top";
else
$templ = "listing";
}
$templ = strtolower($customdir_templ.$modadd."_".$templ.".htm");
if( (!$detail) && ($template<>false) )
{
if( @file_exists($customdir_templ.$template) )
$templ = $customdir_templ.$template;
else
wpf_debugmessage($s_cms_frontend_templatemissing.$template, $sender="wpf_events", $forceshow=true, $level=1);
}
$article = wpf_buffer($templ, $wpf_putin);
$return .= str_replace("wpf.templ_pics/", $customdir_templ."wpf.templ_pics/", $article);
//-->line template
}
//$result = $result.$navi;
if( !$noecho ) echo $return;
return $return;
}
//<<--events
function wpf_events($group_id=false, $events_id=false, $noecho=false, $top=false, $limit="", $eventarchive=false, $template=false, $groupmonths=false, $listonly=false, $langonly=false)
{
//<<--sets
global $wpf_language, $wpf_userip, $wpf_urldomain, $wpf_newspreview_textcut, $wpf_customdir, $wpf_eventsdetail, $wpf_templatedir, $wpf_downpath, $wpf_dir;
$downpath = $wpf_downpath; //-> cms
$customdir = $wpf_customdir."events/";
$customdir_pics = $customdir."pic.uploads/";
$customdir_templ = $wpf_templatedir."events/";
if( !@file_exists($wpf_dir) ) $customdir_templ = $wpf_downpath.$customdir_templ;
$sprache = $_SESSION['wpf_language'];
$detail_link = wpf_cms_detail_link("events", false);
include( wpf_mod_language("_cms") );
include( wpf_mod_language("events") );
//-->>sets
//<<--mode
$tabez = "Events";
$idbez = "Eve_id";
$modadd = strtolower($tabez);
//-->>mode
//<<--nur in aktiver sprache?!
if( $langonly )
{
$limit_sql = " AND Langu='$sprache' ";
}
else
$limit_sql = "";
//-->>nur in aktiver sprache?!
//<<--nur für login-level x?!
$loginlevel = wpf_getloginlevel($_SESSION['wpf_login_id']);
$limit_sql .= " AND E.Regonly_level<=".$loginlevel;
//-->>nur für login-level x?!
if ($_GET['wpf_event']>0)
$events_id = $_GET['wpf_event'];
//<<--limit
if( !empty($limit) )
{
$limit = wpf_clean($limit);
if( is_numeric($limit) ) $limit_sql2 = " LIMIT $limit";
}
else
$limit_sql2 = "";
//-->>limit
//<-suche
if( isset($_POST["wpf_search"]) || isset($_GET["wpf_search"]) || !empty($search) )
{
if( isset($_POST["wpf_search"]) )
$se = wpf_clean($_POST["wpf_search"]);
else
$se = wpf_clean($_GET["wpf_search"]);
if( !empty($search) ) $se = $search;
$se = strtolower($se);
$search_sql .= " AND ((LOWER(E.Keywords) LIKE '%".$se."%') OR (LOWER(E.Info) LIKE '%".$se."%') OR (LOWER(E.Name) LIKE '%".$se."%')) ";
}
else
$search_sql = "";
//->suche
//<<--aufrufe
$detail = false;
//<-einzelner
if( isset($_GET["wpf_".$modadd."_id"]) && $listonly==false )
{
$id = wpf_clean($_GET["wpf_".$modadd."_id"]);
$res = wpf_db_external("SELECT $idbez FROM WPF_$tabez WHERE State > 0 AND $idbez = '$id'");
if( $res!=false )
{
$search_sql .= " AND E.$idbez = '$id'";
$detail = true;
}
}
//->einzelner
//-->>aufrufe
//<<--gruppe
if ($_GET['wpf_eventgroup'] > 0)
$group_id = $_GET['wpf_eventgroup'];
if( $group_id>0 )
{
$search_sql .= " AND E.Evg_id='$group_id'";
}
//-->>gruppe
//<--monatsgruppierung
$grouped=false;
$month=""; $monthgroup=""; $monthcount=0;
if( $groupmonths<>false )
{
$grouped = true;
if( !is_int($groupmonths) ) $groupmonths = 999;
}
//-->monatsgruppierung
//<<--ausgabe
$return="";
//<<-archive
if( $eventarchive==false )
{
if( $grouped )
$search_sql .= " AND DATE_SUB(CURDATE(), INTERVAL (31 - DAY(`End`)) DAY) < `End` "; //ganzen monat belassen
else
$search_sql .= " AND DATE_SUB(CURDATE(), INTERVAL 1 DAY) < `End` "; //tag belassen
}
//->>archive
if ($events_id>0)
{
$detail=true;
$search_sql .= " AND E.$idbez='$events_id'";
}
$order_sql = " ORDER BY `Beg`, `End`";
//<-top
if( $top==true )
$sql_flick2 = " AND E.Marked=1 ";
else
$sql_flick2 = "";
if( $top=="never" )
$sql_flick2 = " AND E.Marked<>1 ";
//->top
$sql = "SELECT E.$idbez, E.Created, E.Edited, E.State, E.Langu, E.Name, E.Name, E.Link, E.Name, E.Keywords, E.Cou_id, E.Log_id_creater, E.Log_id_lastedi, E.State_langonly, E.Dow_id, E.Elo_id, `Beg`, `End`, E.Pig_id, E.Vig_id, E.Marked, E.Event_state, E.Name, E.Ticketlink FROM WPF_$tabez E, WPF_Event_locations L WHERE E.Elo_id = L.Elo_id AND (E.State > 0) AND (E.Ueberregional_Nachname = 'Wykrota' OR L.City LIKE '%Köln%' )".$sql_flick2.$search_sql." ".$limit_sql.$order_sql.$limit_sql2;
$res = wpf_db_external($sql);
$i=0; if($res!=false) foreach($res as $row)
{
//<-Details
$id = $row[0];
$created = $row[1];
$edited = $row[2];
$aktiv = $row[3];
$sprache = $row[4];
$name = $row[5];
$info = $row[6];
$link = $row[7];
$ticketlink = $row[23];
//eventim-code vorhanden
if( !empty($link) )
$link = 'http://www.eventim.de/tickets.html?fun=evdetail&affiliate=sem&doc=evdetailb&key='.$link.'&referer_info=semmel_de';
//kein eventim-code, aber separater Ticketlink
elseif( empty($link) && !empty($ticketlink) )
$link = 'http://'.str_replace('http://','',$ticketlink);
else
$link = "";
$bild = $row[8];
//if( !empty($link) ) $link = ''.$link." ";
$keywords = $row[9];
$cou_id = $row[10];
$log_id_creater = $row[11];
$log_id_lastedi = $row[12];
$langonly = $row[13];
$dow_id = $row[14];
$wochentag = strftime('%w', strtotime($row[1]));
$wochentag = wpf_dayname($wochentag);
$marked = $row[20];
$eventstate = $row[21];
$eventstate_text = wpf_eventstate($id, false, $wpf_language);
$einlass = $row[22];
$anker = "#event".$id;
$vom = wpf_ts2de($row[16]);
$bis = wpf_ts2de($row[17]);
$pig_id = $row[18];
$vig_id = $row[19];
$wochentag = strftime('%w', strtotime($row[16]));
$wochentag = wpf_dayname($wochentag);
$uhr = wpf_db_external("SELECT DATE_FORMAT(Beg, '%H:%i'), DATE_FORMAT(End, '%H:%i'), DATE_FORMAT(End, '%H:%i') FROM WPF_Events WHERE Eve_id=$id", true);
$vom_uhr = $uhr[0];
$bis_uhr = $uhr[1];
$einlass_uhr = $uhr[2];
$location_id = $row[15];
$loc = wpf_db_external("SELECT Name, Zipcode, City, City, Street FROM WPF_Event_locations WHERE Elo_id='$location_id'", true);
$location_name = $loc[0];
$location_plz = $loc[1];
$location_ort = $loc[2];
$location_lkz = $loc[3];
$location_str = $loc[4];
//<--monatsgruppierung
$monthecho="";
if( $grouped )
{
$month = strftime('%m', strtotime($row[16]));
$month_name = wpf_monthname(intval($month));
$year = strftime('%Y', strtotime($row[16]));
//<-templ
$put[0] = $month_name;
$put[1] = $year;
$templ = $customdir_templ."events_monthgroup_templ.htm";
$mtempl = wpf_buffer($templ, $put);
//->templ
if( $month<>$monthgroup )
{
$monthgroup = $month;
if( @file_exists($templ) )
$monthecho = $mtempl;
else
$monthecho = ''.$month_name." ".$year."
";
$monthcount = $monthcount+1;
}
}
//-->monatsgruppierung
//
if( $listonly==false )
$detaillink = wpf_cms_detail_link("events", $id);
else
{
$openfile = wpf_clean( str_replace("http://", "", $listonly) );
if( substr_count($openfile, "?") > 0 )
$geto = "&"; //falls mit listonly bereits eine get-übergabe
else
$geto = "?";
$params = $geto.'wpf_'.$modadd.'_id='.$id.'#'.$modadd.$id;
$detaillink = $openfile.$params; //Details
}
//->Details
//<-Download-Anhang
if( wpf_modactive("downloads") && !empty($dow_id) )
{
$download = wpf_showdownloads("", "", $dow_id, true, true);
}
else $download = "";
//<-Download-Anhang
//<-Infos
if( $log_id_creater==0 )
$creater = "Admin";
else
$creater = "User #".$log_id_creater;
if( $log_id_lastedi==0 )
$editor = "Admin";
else
$editor = "User #".$log_id_lastedi;
$created = wpf_ts2de($created);
$edited = wpf_ts2de($edited);
//->Infos
//<<--zählen
if( $detail )
$counter = wpf_updatecounter($cou_id);
else
$counter = wpf_counterstate($cou_id);
//-->>zählen
//<<--bild
$pic_tag = wpf_pixbox($pic_id=false, $mod_identifier=$modadd, $mod_id=$id, "pic1", $disablezoom=!$detail);
//->bild
//<--line template
$wpf_putin[0] = $id;
$wpf_putin[1] = $name;
$wpf_putin[2] = $info;
$wpf_putin[3] = $link;
$wpf_putin[4] = $sprache;
$wpf_putin[5] = $keywords;
$wpf_putin[6] = $counter;
$wpf_putin[7] = $created;
$wpf_putin[8] = $creater;
$wpf_putin[9] = $pic_tag;
$wpf_putin[10] = $detaillink;
$wpf_putin[11] = $location_name;
$wpf_putin[12] = $vom;
$wpf_putin[13] = $bis;
$wpf_putin[14] = $location_plz;
$wpf_putin[15] = $location_ort;
$wpf_putin[16] = $location_lkz;
$wpf_putin[17] = $vom_uhr;
$wpf_putin[18] = $bis_uhr;
$wpf_putin[19] = $pig_id;
$wpf_putin[20] = $vig_id;
$wpf_putin[21] = wpf_truncate($info, $wpf_eventspreview_textcut);
$wpf_putin[22] = $wochentag;
$wpf_putin[23] = $marked;
$wpf_putin[24] = $bild_gross;
$wpf_putin[25] = $download;
$wpf_putin[26] = $eventstate_text;
$wpf_putin[27] = $eventstate;
$wpf_putin[30] = $params;
$wpf_putin[32] = $location_id;
$wpf_putin[33] = wpf_address($location_id, $editmode=false, true, $prefix="address_", $ajax_save=false, "show_contact_address_event_locations.htm");
$wpf_putin[34] = $einlass;
$wpf_putin[35] = $einlass_uhr;
$wpf_putin[50] = wpf_links("events", $id, true, $private=false, $link_names=false);
$wpf_putin[51] = $location_str;
if( $detail )
$templ = "details";
else
{
if( $top )
$templ = "listing-top";
else
$templ = "listing";
}
$templ = strtolower($customdir_templ.$tabez."_".$templ.".htm");
if( (!$detail) && ($template<>false) )
{
if( @file_exists($customdir_templ.$template) )
$templ = $customdir_templ.$template;
else
wpf_debugmessage($s_cms_frontend_templatemissing.$template, $sender="wpf_events", $forceshow=true, $level=1);
}
$article = wpf_buffer($templ, $wpf_putin);
if( ($grouped==false) || (($grouped==true) && ($monthcount < $groupmonths+1)) )
$return .= $monthecho.str_replace("wpf.templ_pics/", $customdir_templ."wpf.templ_pics/", $article);
//-->line template
$i++;
}
//-->>ausgabe
//if( $i==0 ) $return = ''.$ms01.'
'; //keine
if( !$noecho ) echo $return;
return $return;
}
//-->>events
//<<--status
function wpf_eventstate($event_id=1, $dropdown=true, $lang="de")
{
include( wpf_mod_language("events") );
$get = wpf_db_external("SELECT Event_state FROM WPF_Events WHERE Eve_id='$event_id'", true);
$state = $get[0];
if( empty($state) ) $state = 0;
//
$namen_array = array($s_events_state_true, $s_events_state_soldout, $s_events_state_newdate, $s_events_state_canceled);
$werte_array = array(0, 1, 2, 3);
$drop = wpf_createdropdown($namen_array, $werte_array, $select_wert=$state, $selectname="eventstate");
//
$name = $namen_array[$state];
//
if( $dropdown ) return $drop; else return $name;
}
//-->>status
?>>Copyright / Info
//<<--Auslesen
function wpf_showcase($product_id="", $event_id="", $gallery_group_id="", $video_group_id="", $noecho=false)
{
//<<--sets
global $wpf_customdir, $wpf_downpath, $wpf_templatedir;
$downpath = $wpf_downpath; //-> cms
$customdir = $wpf_customdir."showcase/";
$sprache = $_SESSION['wpf_language'];
//-->>sets
//<--zu produkt?
if( !empty($_GET['wpf_product_id']) )
$pid = wpf_clean($_GET['wpf_product_id']);
else
$pid = "";
if( !empty($product_id) ) $pid = $product_id;
//-->zu produkt?
//<--module aktiv?
$gallerymod = @function_exists('wpf_gallery');
$videomod = @function_exists('wpf_videoplayer');
//-->module aktiv?
$bilder = "";
$videos = "";
$startbild = "";
//<<--zu Produkt
if( !empty($pid) )
{
//ZU PRODUKT
$get = wpf_db("SELECT Pig_id FROM WPF_WH_Produkte WHERE Pro_id='$pid'", true); $get = $get[0];
//bilder
$pics_sql = "SELECT P.Pic_id, P.File, P.Pig_id FROM WPF_Pics P, WPF_Pic_groups G WHERE (P.Pig_id = G.Pig_id) and (G.Pig_id = ".$get.") and P.State = '1' ORDER BY P.Position";
$count = wpf_db($pics_sql, false, true);
if( ($count > 0) && ($gallerymod) )
{
$row = wpf_db($pics_sql, true);
$startbild = $row[0];
$bild = str_replace("t_", "", $row[1]);
$bildgruppe = $row[2];
$bilder = wpf_pics("", $bildgruppe, "", true, false, false, "", false, true, $wpf_customdir."showcase/zooms/showcase_zoom.php", "showcase_pic_listing.htm");
}
//videos
$get = wpf_db("SELECT Vig_id FROM WPF_WH_Produkte WHERE Pro_id='$pid'", true); $get = $get[0];
$videos_sql = "SELECT V.Vig_id, V.Videofile, V.File, V.Link, V.Vid_id FROM WPF_Videos V, WPF_Video_groups G WHERE (V.Vig_id = G.Vig_id) and (G.Vig_id = ".$get.") and V.State = '1' ORDER BY V.Position";
$count = wpf_db($videos_sql, false, true);
if( ($count > 0) && ($videomod) )
{
$row = wpf_db($videos_sql, true);
if($startbild == "")
$startbild = $row[4];
$videogruppe = $row[0];
$videos = wpf_videos($limit="", $videogruppe, $vid_id="", true, $listonly=false, $langonly=false, $search="", $showmessages=false, $wpf_templatedir."showcase/showcase_zoom.php", "showcase_video_listing.htm");
}
}
//-->>zu Produkt
elseif( !empty($event_id) )
//<<--zu Event
{
//ZU EVENT
$sql = "SELECT SELECT Pig_id, Vig_id FROM WPF_Events WHERE Eve_id='$event_id'";
$row = wpf_db($sql, false, true);
if( $row>0 )
{
$row = wpf_db($sql, true);
$pig = $row[0];
$vig = $row[1];
//bilder
$pics_sql = "SELECT P.Pic_id, P.File, P.Pig_id FROM WPF_Pics P, WPF_Pic_groups G WHERE (P.Pig_id = G.Pig_id) and (G.Pig_id = ".$pig.") and P.State = '1' ORDER BY P.Position";
$count = wpf_db($pics_sql, false, true);
if( ($count > 0) && ($gallerymod) )
{
$row = wpf_db($pics_sql, true);
$startbild = $row[0];
$bild = str_replace("t_", "", $row[1]);
$bildgruppe = $row[2];
$bilder = wpf_pics("", $bildgruppe, "", true, false, false, "", false, true, $wpf_templatedir."showcase/showcase_zoom.php", "showcase_pic_listing.htm");
}
//videos
$videos_sql = "SELECT V.Vig_id, V.Videofile, V.File, V.Link, V.Vid_id FROM WPF_Videos V, WPF_Video_groups G WHERE (V.Vig_id = G.Vig_id) and (G.Vig_id = ".$vig.") and V.State = '1' ORDER BY V.Position";
$count = wpf_db($videos_sql, false, true);
if( ($count > 0) && ($videomod) )
{
$row = wpf_db($videos_sql, true);
if($startbild == "")
$startbild = $row[4];
$videogruppe = $row[0];
$videos = wpf_videos($limit="", $videogruppe, $vid_id="", true, $listonly=false, $langonly=false, $search="", $showmessages=false, $wpf_templatedir."showcase/showcase_zoom.php", "showcase_video_listing.htm");
}
}
}
//-->>zu Event
else
//<<--Normal
{
//NORMAL
//bilder
if( !empty($gallery_group_id) && ($gallerymod) )
{
$pics_sql = "SELECT P.Pic_id, P.File, P.Pig_id FROM WPF_Pics P, WPF_Pic_groups G WHERE (P.Pig_id = G.Pig_id) and (G.Pig_id = ".$gallery_group_id.") and P.State = '1' ORDER BY P.Position";
$row = wpf_db($pics_sql, true);
$startbild = $row[0];
$bild = str_replace("t_", "", $row[1]);
$bilder = wpf_pics("", $gallery_group_id, "", true, false, false, "", false, true, $wpf_templatedir."showcase/showcase_zoom.php", "showcase_pic_listing.htm");
}
//videos
if( !empty($video_group_id) && ($videomod) )
{
$videos_sql = "SELECT V.Vig_id, V.Videofile, V.File, V.Link, V.Vid_id FROM WPF_Videos V, WPF_Video_groups G WHERE (V.Vig_id = G.Vig_id) and (G.Vig_id = ".$video_group_id.") and V.State = '1' ORDER BY V.Position";
$count = wpf_db($videos_sql, false, true);
if( $count > 0 )
{
$row = wpf_db($videos_sql, true);
if($startbild == "")
{
if( !empty($_GET['video_id']) )
$startbild = wpf_clean($_GET['video_id']);
else
$startbild = wpf_videos("", $video_group_id, "", false, false, false, "", false, false, "", false, true);
}
$videos = wpf_videos($limit="", $video_group_id, $vid_id="", true, $listonly=false, $langonly=false, $search="", $showmessages=false, $wpf_templatedir."showcase/showcase_zoom.php", "showcase_video_listing.htm");
}
}
}
//-->>Normal
//<--Template
if( !empty($bilder) || !empty($videos) )
{
if( count($bilder) > 0 && is_array($bilder) )
$all = $bilder;
if( count($videos) > 0 && is_array($videos) )
$all = $videos;
if( count($videos) > 0 && is_array($videos) && count($bilder) > 0 && is_array($bilder) )
$all = array_merge($bilder, $videos);
$wpf_putin[0] = $all;
$wpf_putin[2] = $startbild;
$wpf_putin[3] = $bilder;
$wpf_putin[4] = $videos;
$customdir_templ = $wpf_templatedir."showcase/";
$templ = $customdir_templ."template.htm";
$templ = wpf_buffer($templ, $wpf_putin);
$return = str_replace("wpf.templ_pics/", $customdir_templ."wpf.templ_pics/", $templ);
//<-doppelte pfade entfernen
$return = str_replace($wpf_templatedir."videos/templates/".$customdir_templ, $wpf_templatedir."videos/templates/", $return);
$return = str_replace($wpf_templatedir."gallery/templates/".$customdir_templ, $wpf_templatedir."gallery/templates/", $return);
//->doppelte pfade entfernen
if( !$noecho) echo $return;
}
else $return = "";
//-->Template
return $return;
}
//-->>Auslesen
?>>Copyright / Info
//<<--Ausgabe mit Gruppenauswahl
function wpf_gallery($group_id="", $limit="", $noecho=false, $template=false, $class="", $langonly=false)
{
global $wpf_customdir, $wpf_templatedir;
$customdir = $wpf_customdir."gallery/";
$customdir_templ = $wpf_templatedir."gallery/";
//<--gruppe
if( empty($group_id) )
{
$group_id = wpf_gallery_getfirst();
}
//-->gruppe
//<--ausgabe
$name = wpf_db("SELECT Name from WPF_Pic_groups WHERE Pig_id='$group_id'", true);
$name = $name[0];
//
$WPF_PUTIN[0] = wpf_pics($limit, $group_id, "", true, false, false, $langonly); //pics
$WPF_PUTIN[1] = wpf_picgroups($group_id, $langonly, $dropdown=false, $search="", true); //groups
$WPF_PUTIN[2] = $name; //gallery-name
$WPF_PUTIN[3] = ''; //site x of y
$WPF_PUTIN[4] = ''; //navi
$WPF_PUTIN[5] = $class;
//
if( $template )
$templ = $customdir_templ.$template;
else
$templ = $customdir_templ."gallery_frame.htm";
$article = wpf_buffer($templ, $WPF_PUTIN);
if( !$noecho ) echo $article;
return $article;
//-->ausgabe
}
//-->>Ausgabe mit Gruppenauswahl
//<<--neue gruppe
function wpf_pics_addgallery($name, $folder_name="", $state=1, $info="", $keywords="", $parent_id="", $language="", $langonly="", $frontendshow=1, $user=0)
{
global $wpf_customdir, $customdir_pics, $wpf_downpath, $wpf_templatedir;
if( empty($customdir_pics) )
$customdir_pics = $wpf_customdir."gallery/files/"; //frontend aufruf
else
$customdir_pics = $wpf_downpath.$customdir_pics;
//
if( empty($folder_name) || file_exists($customdir_pics.$folder_name) )
{
$folder_name = str_replace("\\", "", $name)."_".date("dmyhs");
}
if( !empty($name) )
{
$folder = wpf_killspecs( wpf_killuml($folder_name) )."/";
$folder = str_replace("_", "-", $folder);
wpf_changemode($customdir_pics, 777);
wpf_changemode($customdir_pics.$folder, 777);
$dirdone = mkdir($customdir_pics.$folder);
wpf_changemode($customdir_pics.$folder, 755);
wpf_changemode($customdir_pics, 755);
//Ds
if( $dirdone )
{
$res = wpf_db("INSERT INTO WPF_Pic_groups (Created, Edited, State, Langu, Name, Info, Keywords, Log_id_creater, Log_id_lastedi, State_langonly, Regonly_level, Folder, Parent_pig, Frontendshow)
VALUES (NOW(), NOW(), '$state', '$language', '$name', '$info', '$keywords', '$user', '$user', '$langonly', '$level', '$folder', '$parent_id', '$frontendshow')");
$return = $res;
}
else $return = false;
}
else $return = false;
//
return $return;
}
//-->>neue gruppe
//<<--Gruppen listen
function wpf_getpicgroup_cover($id)
{
$get = wpf_db("SELECT Pic_id FROM WPF_Pics WHERE State=1 AND Pig_id='$id' ORDER BY Position", true);
$cover = wpf_getgallerypic($get[0]);
return $cover;
}
function wpf_gallery_groups($group_id=false, $noecho=true, $template=false)
{
//alias für modmenu
return wpf_picgroups($group_id, $langonly=false, $dropdown=false, $search="", $noecho, $limit=false, $template);
}
function wpf_gallery_menu($group_id="", $noecho=true, $template=false, $template_sub=false)
{
//alias
return wpf_picgroups($group_id="", $langonly=false, $dropdown=false, $search="", $noecho, false, $template, $template_sub);
}
function wpf_picgroups($group_id="", $langonly=false, $dropdown=false, $search="", $noecho=false, $limit=false, $template=false, $template_sub=false)
{
//<<--sets
global $wpf_galarchiv, $wpf_galarchiv_start, $wpf_customdir, $wpf_gal_frontendshow, $wpf_templatedir;
$customdir = $wpf_customdir."gallery/";
$customdir_templ = $wpf_templatedir."gallery/";
$tabez = "Pic_groups";
$idbez = "Pig_id";
include( wpf_mod_language("_cms") );
//-->>sets
//<<--template
if( $template<>false )
$templ = $customdir_templ.$template;
else
$templ = $customdir_templ."gallery_menu_navi.htm";
if( $template_sub<>false )
$templ_sub = $customdir_templ.$template_sub;
else
$templ_sub = $customdir_templ."gallery_menu_subnavi.htm";
//-->>template
//<<--sortby
$sortby = wpf_cms_sortby("gallery", "Pig_id");
//-->>sortby
//<<--nur für login-level x?!
$loginlevel = wpf_getloginlevel($_SESSION['wpf_login_id']);
$limit_sql = " AND Regonly_level<=".$loginlevel;
//-->>nur für login-level x?!
//<<--nur in aktiver sprache?!
if( $langonly )
{
$limit_sql .= " AND Langu='$sprache' ";
}
//-->>nur in aktiver sprache?!
//<-suche
if( isset($_POST["wpf_search"]) || !empty($search) )
{
$se = wpf_clean($_POST["wpf_search"]);
if( !empty($search) ) $se = $search;
$se = strtolower($se);
$search_sql .= " AND ((LOWER(Keywords) LIKE '%".$se."%') OR (LOWER(Info) LIKE '%".$se."%') OR (LOWER(Name) LIKE '%".$se."%')) ";
}
else
$search_sql = "";
//->suche
//<-Deaktivierte Gruppen in Gruppenliste nicht anzeigen
if( $wpf_gal_frontendshow )
$search_sql = " AND Frontendshow=1 ";
//->Deaktivierte Gruppen in Gruppenliste nicht anzeigen
//<-gruppe sel
if( !empty($_GET['wpf_picgroup']) ) $group_id = wpf_clean($_GET['wpf_picgroup']);
if( empty($group_id) ) $group_id = wpf_gallery_getfirst();
if( wpf_gallery_switch2subgallery($group_id) ) $group_id = wpf_gallery_switch2subgallery($group_id);
$sel = $group_id;
//->gruppe sel
if( $limit<>false ) $limit2_sql = " LIMIT $limit";
//<<--ausgabe
$return="";
if ($wpf_galarchiv == true)
{
$group_dropdown="Archiv ";
$group="";
}
else
{
$group_dropdown="";
$group="";
}
$order_sql = " ORDER BY $sortby ";
$sql = "SELECT $idbez, Created, Edited, State, Langu, Name, Info, Keywords, Log_id_creater, Log_id_lastedi, State_langonly, Parent_pig FROM WPF_$tabez WHERE ((Parent_pig IS NULL) OR (Parent_pig=0)) AND (State > 0) ".$search_sql." ".$limit_sql.$order_sql.$limit2_sql;
$res = wpf_db($sql);
$i=0; if($res!=false) foreach($res as $row)
{
//<-details
$id = $row[0];
$created = $row[1];
$edited = $row[2];
$aktiv = $row[3];
$sprache = $row[4];
$name = $row[5];
$info = $row[6];
$keywords = $row[7];
$log_id_creater = $row[8];
$log_id_lastedi = $row[9];
$langonly = $row[10];
$parent = $row[11];
//->details
//<--dropdown
if( $id == $sel ) $sele = " selected"; else $sele = "";
if( $id == $sel ) $acti = " wpf_modmenu_active"; else $acti = "";
if ($wpf_galarchiv == true)
{
if ($i>=$wpf_galarchiv_start)
$group_dropdown .= ''.$name.' ';
}
else
$group_dropdown .= ''.$name.' ';
//-->dropdown
//<<--cover
$cover = wpf_getpicgroup_cover($id);
//-->>cover
//<--normal
if( $wpf_galarchiv == false || ($wpf_galarchiv == true && $i<$wpf_galarchiv_start) )
{
$group = '';
//<-template
$wpf_putin[0] = $group;
$wpf_putin[1] = $name;
$wpf_putin[2] = $id;
$wpf_putin[3] = $cover;
$wpf_putin[4] = $info;
if( @file_exists($templ) )
$article = wpf_buffer($templ, $wpf_putin);
else
wpf_debugmessage($s_cms_frontend_templatemissing.$template, $sender="wpf_pic_groups", $forceshow=true, $level=1);
$return .= $article;
//->template
}
//-->normal
//<--untergalerien
if( ($sel == $id) )
{
$sql2 = "SELECT $idbez, Created, Edited, State, Langu, Name, Info, Keywords, Log_id_creater, Log_id_lastedi, State_langonly, Parent_pig FROM WPF_$tabez WHERE (State > 0) AND Parent_pig='$id' ".$search_sql;
$res2 = wpf_db($sql2);
$a=0; if($res2!=false) foreach($res2 as $row2)
{
//<-details
$s_id = $row2[0];
$s_name = $row2[5];
//->details
//<<--cover
$cover = wpf_getpicgroup_cover($s_id);
//-->>cover
if( $s_id == $sel ) $acti = " wpf_modsubmenu_active"; else $acti = "";
//<--normal
$s_group = '';
//<-template
$wpf_putin[0] = $s_group;
$wpf_putin[1] = $s_name;
$wpf_putin[2] = $s_id;
$wpf_putin[3] = $cover;
$wpf_putin[4] = $info;
if( @file_exists($templ_sub) )
$article = wpf_buffer($templ_sub, $wpf_putin);
else
wpf_debugmessage($s_cms_frontend_templatemissing.$template, $sender="wpf_pic_groups", $forceshow=true, $level=1);
$return .= $article;
//->template
//-->normal
$a++;
}
}
//Untergalerien bei Klick auf Untergalerie weiterhin anzeigen
elseif( isset($_GET['wpf_picgroup']) )
{
$akt_group = $_GET['wpf_picgroup'];
$res3 = wpf_db("select Parent_pig from WPF_$tabez where $idbez = $akt_group");
if($res3!=false) foreach($res3 as $row3)
$papig = $row3[0];
if($papig <> 0)
{
$sql4 = "SELECT $idbez, Created, Edited, State, Langu, Name, Info, Keywords, Log_id_creater, Log_id_lastedi, State_langonly, Parent_pig FROM WPF_$tabez WHERE (State > 0) AND Parent_pig='$papig' ".$search_sql;
$res4 = wpf_db($sql4);
$a=0; if($res4!=false) foreach($res4 as $row4)
{
//<-details
$s_id = $row4[0];
$s_name = $row4[5];
//->details
//<<--cover
$cover = wpf_getpicgroup_cover($s_id);
//-->>cover
if( $s_id == $sel ) $acti = " wpf_modsubmenu_active"; else $acti = "";
//<--normal
$s_group = '';
//<-template
$wpf_putin[0] = $s_group;
$wpf_putin[1] = $s_name;
$wpf_putin[2] = $s_id;
$wpf_putin[3] = $cover;
$wpf_putin[4] = $info;
if( @file_exists($templ_sub) )
$article = wpf_buffer($templ_sub, $wpf_putin);
else
wpf_debugmessage($s_cms_frontend_templatemissing.$template, $sender="wpf_pic_groups", $forceshow=true, $level=1);
if($id==$papig)
$return .= $article;
//->template
//-->normal
$a++;
}
}
}
//-->untergalerien
$i++;
}
//-->>ausgabe
//<--template - dropdown
if( $dropdown || $wpf_galarchiv )
{
$wpf_putin[0] = $id;
$wpf_putin[1] = $group_dropdown;
$dropdown = wpf_buffer($wpf_templatedir."gallery/gallery_menu_dropdown.htm", $wpf_putin);
$return .= $dropdown; //Dropdown zusätzlich als Archiv
}
//-->template - dropdown
//if( $i==0 ) $return = $ms01;
$return = str_replace("wpf.templ_pics/", $wpf_templatedir."gallery/wpf.templ_pics/", $return);
if( $noecho==false ) echo $return;
return $return;
}
function wpf_gallery_subgroups()
{
return true; //check 4 modmenu
}
//-->>Gruppen listen
//<<--Bilder auflisten
function wpf_gallery_pics($group_id="", $noecho=false, $template=false, $limit="") //standard aufruf
{
//alias
return wpf_pics($limit, $group_id, "", $noecho, $listonly=false, $langonly=false, $search="", $showmessages=false, $manual_zoomtarget=false, $iframe_target=false, $template);
}
//manual_zoomtarget = Ziel img (id="PicLayer_zoom_pic") manuell erstellt //iframe_target = name der zieldatei... -> iframe name = iframe_target-file minus dateiendung (/_custom/test.php -> test)
function wpf_pics($limit="", $group_id="", $pic_id="", $noecho=false, $listonly=false, $langonly=false, $search="", $showmessages=false, $manual_zoomtarget=false, $iframe_target=false, $template="")
{
global $wpf_userip, $wpf_lightbox_zoom, $wpf_customdir, $wpf_downpath, $wpf_templatedir;
//<<--sets
$downpath = $wpf_downpath; //-> cms
$customdir = $wpf_customdir."gallery/";
$customdir_files = $customdir."files/";
$customdir_templ = $wpf_templatedir."gallery/";
$sprache = $_SESSION['wpf_language'];
$tabez = "Pics";
$idbez = "pic_id";
$limit_sql="";
//-->>sets
//<<--sortby
$sortby = wpf_cms_sortby("gallery", "Pic_id");
//-->>sortby
//<<--sprache
global $wpf_language;
include( wpf_mod_language("_cms") );
include( wpf_mod_language("gallery") );
//-->>sprache
//<<--nur in aktiver sprache?!
if( $langonly==true )
{
$search_sql .= " AND Langu='$sprache' ";
}
//-->>nur in aktiver sprache?!
//<<--nur für login-level x?!
$loginlevel = wpf_getloginlevel($_SESSION['wpf_login_id']);
$search_sql .= " AND Regonly_level<=".$loginlevel;
//-->>nur für login-level x?!
//<<--limit
if( !empty($limit) )
{
$limit = wpf_clean($limit);
$limit_sql .= " LIMIT $limit";
}
//-->>limit
//<<--gruppe
if( isset($_GET['wpf_picgroup']) ) $group_id = wpf_clean($_GET['wpf_picgroup']);
//if( empty($group_id) && empty($search) )
if( empty($group_id) ) $group_id = wpf_gallery_getfirst();
if( wpf_gallery_switch2subgallery($group_id) ) $group_id = wpf_gallery_switch2subgallery($group_id);
//bei suche nicht auf gruppe beschränken etc?
//-->>gruppe
//<-suche
if( isset($_POST["wpf_search"]) || !empty($search) )
{
$se = wpf_clean($_POST["wpf_search"]);
if( !empty($search) ) $se = $search;
$se = strtolower($se);
$search_sql .= " AND ((LOWER(Info) LIKE '%".$se."%') OR (LOWER(Name) LIKE '%".$se."%')) ";
}
else
$search_sql = "";
//->suche
//<-einzeln via id-übergabe
if( !empty($pic_id) )
{
$search_sql .= " AND pic_id='$pic_id' ";
}
//->einzeln via id-übergabe
//<<--aufrufe
$detail = false;
//<-einzelner
if( isset($_GET["wpf_pic_id"]) && $listonly==false )
{
$id = wpf_clean($_GET["wpf_pic_id"]);
$res = wpf_db("SELECT $idbez FROM WPF_$tabez WHERE State > 0 AND $idbez = '$id'");
if( $res!=false )
{
$search_sql .= " AND $idbez = '$id'";
$detail = true;
}
}
//->einzelner
//-->>aufrufe
//<<--sql
$order_sql = " ORDER BY $sortby "; //Langu, //Keywords, //State_langonly,
$sql = "SELECT $idbez, Created, Edited, State, Name, Name, Info, Name, Cou_id, Log_id_creater, Log_id_lastedi, Name, File, Zoom, Pig_id, Link FROM WPF_$tabez WHERE (State > 0) ";
//-->>sql
//<<--nur aus gewählter gruppe
if( !empty($group_id) && !$detail )
{
$gr = wpf_clean($group_id);
//wenn übergalerie: falls leer -> in untergalerie wechseln
/*$check4pics = wpf_db($sql.$search_sql." AND Pig_id = '$gr' ".$order_sql.$limit_sql, false, true);
if( $check4pics==0 )
{
$ueber = wpf_db("SELECT Pig_id FROM WPF_Pic_groups WHERE Parent_pig='$gr' AND State>0", true);
if( !empty($ueber[0]) )
{
$use_group = $ueber[0];
}
}*/
if( empty($use_group) )
$use_group = $gr;
}
//-->>nur aus gewählter gruppe
//<<--ausgabe
$return="";
$res = wpf_db($sql.$search_sql." AND Pig_id = '$use_group' ".$order_sql.$limit_sql);
$i=0; if($res!=false) foreach($res as $row)
{
//<-Details
$id = $row[0];
$created = $row[1];
$edited = $row[2];
$aktiv = $row[3];
$sprache = $row[4];
$name = $row[5];
$info = $row[6];
$keywords = $row[7];
$cou_id = $row[8];
$log_id_creater = $row[9];
$log_id_lastedi = $row[10];
$langonly = $row[11];
$file = $customdir_files.$row[12];
$zoom = $row[13];
$file_size = @filesize($file);
$file_size = round($file_size /1024 /1024, 3);
$link = $row[15];
//<-verzeichnis
$gruppe = $row[14];
$folder = wpf_db("SELECT Folder FROM WPF_Pic_groups WHERE Pig_id='$gruppe'", true);
$folder = $folder[0];
//->verzeichnis
$url = $_SERVER['PHP_SELF'];
$target = "";
//<-target manual
if( $iframe_target != false )
{
$url = $iframe_target;
$target = str_replace(".php", "", $iframe_target);
$lastslash = strrpos($target, "/");
$target = substr($target, $lastslash+1, strlen($target));
$target = ' target="'.$target.'"';
}
//->target manual
$detail_link = ''; //Details
$picpath = wpf_getpic_path($mod_identifier="gallery", $mod_id=$id, $pic_identifier="pic1", $thumb=true);
$picpath_zoom = wpf_getpic_path($mod_identifier="gallery", $mod_id=$id, $pic_identifier="pic1", $thumb=false);
$direct_file = $customdir_files.$folder."t_".$row[12];
$file = wpf_pixbox($pic_id=$id, $mod_identifier="gallery", $mod_id=$id, $pic_identifier="pic1", $disablezoom=false, $forcezoom=false, "wpf_gallery".$use_group);
//<-target manual
if( $iframe_target != false )
{
$file = $detail_link.''; //Details
$picpath = wpf_getpic_path($mod_identifier="gallery", $mod_id=$id, $pic_identifier="pic1", $thumb=true);
$picpath_zoom = wpf_getpic_path($mod_identifier="gallery", $mod_id=$id, $pic_identifier="pic1", $thumb=false);
//->Details
//<--line template
$wpf_putin[0] = $id;
$wpf_putin[1] = $name;
$wpf_putin[2] = nl2br($info);
$wpf_putin[3] = $picpath;
$wpf_putin[4] = $picpath_zoom;
$wpf_putin[5] = $keywords;
$wpf_putin[6] = $counter;
$wpf_putin[7] = $created;
$wpf_putin[8] = $creater;
$wpf_putin[9] = $type;
$wpf_putin[10] = $detail_link;
$wpf_putin[11] = $file_size." MB";
$wpf_putin[15] = $link;
$wpf_putin[16] = $target_site;
$wpf_putin[17] = $gruppe;
$templ = $wpf_templatedir."gallery/gallery_pic_frame_latest.htm";
$return .= wpf_buffer($templ, $wpf_putin);
//-->line template
$i++;
}
//-->>ausgabe
//if( $i==0 ) $return = $ms01;
if(!$noecho) echo $return;
return $return;
}
//-->>Neueste Bilder
//<<--Galerie Autowahl
function wpf_gallery_switch2subgallery($gallery_id)
{
$return = false;
$get = wpf_db("SELECT Pic_id FROM WPF_Pics WHERE Pig_id='$gallery_id'", false, true);
if( $get==0 )
{
$check = wpf_db("SELECT G.Pig_id FROM WPF_Pic_groups G, WPF_Pics P WHERE P.Pig_id=G.Pig_id AND G.Parent_pig='$gallery_id' AND G.State>0 AND P.State>0 AND G.Frontendshow=1", true);
if( $check[0]>0 ) $return = $check[0];
}
return $return;
}
function wpf_gallery_getfirst()
{
if( isset($_GET['wpf_picgroup']) )
{
$group_id = wpf_clean($_GET['wpf_picgroup']);
}
else
{
$sortby = wpf_cms_sortby("gallery", "Pig_id");
$latest = wpf_db("SELECT Pig_id from WPF_Pic_groups where Frontendshow=1 AND State > 0 ORDER BY ".$sortby, true);
$group_id = $latest[0];
}
return $group_id;
}
//-->>Galerie Autowahl
?>