//<<--SYSTEM generell-->>
//<<--Sets
$wpf_languages = array("de", "en"); //Aktive Sprachen
$wpf_captchaforms = true; //Anti bot-spam
$no_phpftp = true; //Kein Chmode via Php (empfohlen bei Servern, die Standardrechte sowieso auf Schreibzugriff haben oder Probleme machen (zB Strato))
$wpf_ftpfuncs = true; //changemod etc. via FTP (im Normfall immer true belassen)
$wpf_hardkill = true; //Löscht Daten physisch, false=Papierkorbmodus (-1)
$wpf_htaccess_rewrite = false; //htaccess rewrite engine (z.B. test.html anstatt test_de.php)
$wpf_dontuse_mobilemode = true; //mobilmode
//<<--Images
$wpf_savepics2db = false; //Bilder werden in der Datenbank abgelegt (NICHT empfohlen!)
$wpf_keeporiginalpics = true; //Originaldateien von Bilduploaden speichern (empfohlen, falls genug Speicherplatz zur Verfügung steht)
$wpf_pics_hidepaths = true; //false = Direkter Pfad in den Link; true = Pfade werden versteckt und Bilder über Bufferdatei (_wpf.img.php) geladen
$wpf_dynpic_hg = true; //Falls true Dynpic-Tag nur Pfad zum Bild (z.B. für Hintergrund), bei true kompletter img-Tag
$wpf_lightbox_zoom = true; //Fancybox (AJAX) für Zoom verwenden
//<<--CMS ONLY-->>
//<<--Sets
$wpf_language = "de"; //CMS Sprache
$wpf_cms_events_showgroups = false;
$wpf_cms_news_showgroups = false;
$wpf_cms_entriespersite = 30; //Einträge in Übersichtlisten pro Seite (-1 keine Seitennavi)
$wpf_cms_sites_plugins = true; //Modul-Plugins einbindbar in Seiteninhalte
//<<--CMS & FRONTEND-->>
//<<--Buttons
$wpf_buttons_standard_size = 24;
$wpf_buttons_standard_shadow = true;
$wpf_buttons_standard_color = "light";
//<<--Menu
$wpf_temps4menu = true; //Templates für Menü
$wpf_mmenubreak = ''; //Trenner Main
$wpf_smenubreak = ''; //Trenner Sub
$wpf_sub2mainmenu = false; //Submenu an Mainmenu anschliessen
$wpf_subsub2submenu = true; //Sub-Submenu an Submenu anschliessen
$wpf_sub4dropdown = false; //Submenu als Dropdown behandeln
$wpf_mmenunocload = false; //Hauptmenüpunkt hat nur Dropdown-Funktion (keinen Inhalt laden)
$wpf_part_preview = 400; //Zeichenangabe ab wo die Abschnittsvorschau enden soll (leer = autoamtisch -> 150)
$wpf_showpar_desc = false; //Anzeigereihenfolge der Abschnitte - wenn aktiv: neuester unten
//<<--Sitemanager
$wpf_basesiteedit = false; //false = nur Abschnitte, true = Seitenkopf als normalen Abschnitt behandeln (z.B. wenn keine Abscnhittüberschriften benötigt werden)
$wpf_parthumbsize = 300; //Thumb
$wpf_parthumbsize_w = 980; //Thumb Breite
$wpf_parthumbsize_h = 360; //Thumb Höhe
$wpf_partzoomsize = 980; //Zoom
$wpf_partzoomsize_w = 980; //max. Breite
$wpf_partzoomsize_h = 0; //max. Hoehe (standard:0 -> inaktiv)
$wpf_sendpicfuncs = false; //Sendto
$wpf_partpreview_textcut = 200; //Vorschau - Infotext-Abschnitt (Zeichen)
$wpf_site_location_spacer = '»';
$wpf_site_preview_all_paragraphs = false; //Grundsätzlich alle Abschnitte erst als Vorschau
$wpf_sites_piconly_parag_usethumb = false; //nur bild - abschnitte: bild als normales thumb anzeigen (anstatt full-size layer)
//<<--Contacts
$wpf_contacts_thumbsize = 80;
$wpf_contacts_pic_h = 200;
$wpf_contacts_pic_w = 160;
//<<--Community
$wpf_community_userpic_thumb = 80;
$wpf_community_userpic_pic_h = 400;
$wpf_community_userpic_pic_w = 200;
//<<--Newsletter
$wpf_newsletterpic_w = 640; //max. Breite
$wpf_newsletterpic_h = 0; //max. Hoehe (standard:0 -> inaktiv)
$wpf_newsletter_confirmjoin = true; //User muss Eintrag in Nl über Mail-Link bestätigen
//<<--Guestbook
$wpf_maxgbentries = 10; //Einträge pro Seite
$wpf_gbentryactivation = false; //Einträge müssen vom Admin aktiviert werden
$wpf_informadmin_onnewentry = false; //Dem Administrator bei neuem Eintrag eine E-Mail schicken
//<<--Galerie
$wpf_galthumbsize = 300; //Thumb
$wpf_galzoomdsize_w = 1000; //max. Breite
$wpf_galzoomdsize_h = 0; //max. Hoehe (standard:0 -> inaktiv)
$wpf_galpicspersite = 8; //4er-schritte
$wpf_galmmenubreak = "
"; //Hauptmenu-break
$wpf_galsmenubreak = "
"; //Submenu-break
$wpf_galarchiv = false; //Archivmodus für Galeriegruppen
$wpf_galarchiv_start = 5; //Nach wievielter Gruppe Archivmodus einschalten (Dropdown)
$wpf_gallery_backend_dontshowsysgroups = false; //System-Sammelgruppen der Module ausblenden?
$wpf_showcasepics = false; //Separate Bildgrößen für Showcase generieren?
$wpf_showcasepics_w = 680; //max. Breite Showcasepics
$wpf_showcasepics_h = 556; //max. Höhe Showcasepics (standard:0 -> inaktiv)
$wpf_gal_frontendshow = true; // true -> Gruppen mit Attribut Frontend = nein werden in der Gruppenliste der Galerie nicht ausgegeben
$wpf_gallery_sortby = "manual"; //Sortierung der Bilder: "name" = alphabetisch, "added" = nach anlegereihenfolge, "manual" = manuelle reihenfolge
//<<--Downloads
$wpf_downloadnoedit = true; //Keine nachträgliche Änderung von Dateien und Nummern für Downloads erlauben (für lückenloses Archiv zum Nachweis von Dokumenten z.B.)
$wpf_downloadsthumbsize = 120; //Thumb
$wpf_downloadsthumbsize_w = 140; //Thumb Breite
$wpf_downloadsthumbsize_h = 120; //Thumb Höhe
$wpf_downloadszoomsize_w = 350; //max. Breite
$wpf_downloadszoomsize_h = 180; //max. Hoehe (standard:0 -> inaktiv)
$wpf_downloads_sortby = "manual"; //Sortierung der Bilder: "name" = alphabetisch, "added" = nach anlegereihenfolge, "manual" = manuelle reihenfolge
//<<--Warehouse
$wpf_warehousethumb_cube = false; // true: Quadratischer Ausschnitt als Thumb (Größe von $wpf_warehousethumbsize_w), false: Ausschnitt mit festgelegter Höhe und Breite
$wpf_warehousethumbsize_w = 250; //Thumb Breite, falls 0, Standard 120
$wpf_warehousethumbsize_h = 80; //Thumb Breite, falls 0, Standard 120
$wpf_warehousezoomsize_w = 980; //Breite
$wpf_warehousezoomsize_h = 0; //Höhe
$wpf_warehouse_textcut = 400; //Textvorschau x Zeichen
$wpf_warehouse_manu_h = 60; //Hersteller Logo h
$wpf_warehouse_manu_w = 60; //Hersteller Logo b
//<<--Showcase
$wpf_showcase_videoplayer_w = 560;
$wpf_showcase_videoplayer_h = 315;
//<<--Videos
$wpf_videosthumbsize = 120; //Thumb
$wpf_videoplayer_w = 400; //Interner Player
$wpf_videoplayer_h = 233;
$wpf_videoplayer_embed_w = 560; //Externe Player
$wpf_videoplayer_embed_h = 315;
$wpf_videos_sortby = "manual"; //Sortierung der Bilder: "name" = alphabetisch, "added" = nach anlegereihenfolge, "manual" = manuelle reihenfolge
//<<--Audio
$wpf_audiosthumbsize = 120; //Thumb
$wpf_audioplayer_w = 698; //Interner Player
$wpf_audioplayer_h = 476;
$wpf_audio_sortby = "added"; //Sortierung der Bilder: "name" = alphabetisch, "added" = nach anlegereihenfolge, "manual" = manuelle reihenfolge
$wpf_audiogroups_thumbsize_h = 120;
$wpf_audiogroups_thumbsize_w = 120;
$wpf_audiogroups_pic_height = 0;
$wpf_audiogroups_pic_width = 620;
//<<--News
$wpf_newsthumbsize_h = 100; //Thumb
$wpf_newsthumbsize_w = 100; //Thumb
$wpf_newspic_width = 700; //Big
$wpf_newspic_height = -1; //Big
$wpf_newspreview_textcut = 200; //Vorschau - Infotext-Abschnitt (Zeichen)
//<<--Events
$wpf_eventthumbsize_h = 100; //Thumb
$wpf_eventthumbsize_w = 100; //Thumb
$wpf_eventpic_width = 680; //Big
$wpf_eventpic_height = 550; //Big
$wpf_eventspreview_textcut = 400; //Vorschau - Infotext-Abschnitt (Zeichen)
//<<--References
$wpf_references_thumbsize_h = 100;
$wpf_references_thumbsize_w = 100;
$wpf_references_pic_height = 500;
$wpf_references_pic_width = 500;
$wpf_references_textpreview_length = 150;
//<<--Slider
$wpf_sliderpic_height = -1;
$wpf_sliderpic_width = 1000;
$wpf_sliderthumbsize_h = -1;
$wpf_sliderthumbsize_w = 120;
//<<--EXPERT SETS - Know what you do!-->>
//<<--Zusätliche Ablagespeicher für Sitemanager
$wpf_sites_use_database_contents = true; //Sitemanager Datenspeicher DB
$wpf_sites_use_file_contents = false; //Sitemanager Datenspeicher Dateien
$wpf_createhtm4fla = true; //Sitemanager: Html-File für Flash-Inhalte schreiben
$wpf_createxmlfile = true; //Sitemanager: Pro Seite 1 Xml-File (Flash-frame etc.)
//<<--Sonstige Verschlüsselung & Passwörter
$wpf_crypt_key = "webprojaggt2cool4scriptkiddie247"; //16 chars for 128 bit, 24 for 192 bit, or 32 for a 256 bit key
$wpf_password_salt = "Salt4Jaggt";
//<<--Hauptunterordner für CMS aus (FTP-)Root-Sicht - wird normal automatisch gesetzt
$wpf_subfolder_manual = false; //pfad ggfls. manuell setzen (falls pfad, inkl slash am ende!) || bei keinem unterordner = " " setzen!
?>
//<<--SYSTEM generell-->>
//<<--Sets
$wpf_languages = array("de", "en"); //Aktive Sprachen
$wpf_captchaforms = true; //Anti bot-spam
$no_phpftp = true; //Kein Chmode via Php (empfohlen bei Servern, die Standardrechte sowieso auf Schreibzugriff haben oder Probleme machen (zB Strato))
$wpf_ftpfuncs = true; //changemod etc. via FTP (im Normfall immer true belassen)
$wpf_hardkill = true; //Löscht Daten physisch, false=Papierkorbmodus (-1)
$wpf_htaccess_rewrite = false; //htaccess rewrite engine (z.B. test.html anstatt test_de.php)
$wpf_dontuse_mobilemode = true; //mobilmode
//<<--Images
$wpf_savepics2db = false; //Bilder werden in der Datenbank abgelegt (NICHT empfohlen!)
$wpf_keeporiginalpics = true; //Originaldateien von Bilduploaden speichern (empfohlen, falls genug Speicherplatz zur Verfügung steht)
$wpf_pics_hidepaths = true; //false = Direkter Pfad in den Link; true = Pfade werden versteckt und Bilder über Bufferdatei (_wpf.img.php) geladen
$wpf_dynpic_hg = true; //Falls true Dynpic-Tag nur Pfad zum Bild (z.B. für Hintergrund), bei true kompletter img-Tag
$wpf_lightbox_zoom = true; //Fancybox (AJAX) für Zoom verwenden
//<<--CMS ONLY-->>
//<<--Sets
$wpf_language = "de"; //CMS Sprache
$wpf_cms_events_showgroups = false;
$wpf_cms_news_showgroups = false;
$wpf_cms_entriespersite = 30; //Einträge in Übersichtlisten pro Seite (-1 keine Seitennavi)
$wpf_cms_sites_plugins = true; //Modul-Plugins einbindbar in Seiteninhalte
//<<--CMS & FRONTEND-->>
//<<--Buttons
$wpf_buttons_standard_size = 24;
$wpf_buttons_standard_shadow = true;
$wpf_buttons_standard_color = "light";
//<<--Menu
$wpf_temps4menu = true; //Templates für Menü
$wpf_mmenubreak = ''; //Trenner Main
$wpf_smenubreak = ''; //Trenner Sub
$wpf_sub2mainmenu = false; //Submenu an Mainmenu anschliessen
$wpf_subsub2submenu = true; //Sub-Submenu an Submenu anschliessen
$wpf_sub4dropdown = false; //Submenu als Dropdown behandeln
$wpf_mmenunocload = false; //Hauptmenüpunkt hat nur Dropdown-Funktion (keinen Inhalt laden)
$wpf_part_preview = 400; //Zeichenangabe ab wo die Abschnittsvorschau enden soll (leer = autoamtisch -> 150)
$wpf_showpar_desc = false; //Anzeigereihenfolge der Abschnitte - wenn aktiv: neuester unten
//<<--Sitemanager
$wpf_basesiteedit = false; //false = nur Abschnitte, true = Seitenkopf als normalen Abschnitt behandeln (z.B. wenn keine Abscnhittüberschriften benötigt werden)
$wpf_parthumbsize = 300; //Thumb
$wpf_parthumbsize_w = 980; //Thumb Breite
$wpf_parthumbsize_h = 360; //Thumb Höhe
$wpf_partzoomsize = 980; //Zoom
$wpf_partzoomsize_w = 980; //max. Breite
$wpf_partzoomsize_h = 0; //max. Hoehe (standard:0 -> inaktiv)
$wpf_sendpicfuncs = false; //Sendto
$wpf_partpreview_textcut = 200; //Vorschau - Infotext-Abschnitt (Zeichen)
$wpf_site_location_spacer = '»';
$wpf_site_preview_all_paragraphs = false; //Grundsätzlich alle Abschnitte erst als Vorschau
$wpf_sites_piconly_parag_usethumb = false; //nur bild - abschnitte: bild als normales thumb anzeigen (anstatt full-size layer)
//<<--Contacts
$wpf_contacts_thumbsize = 80;
$wpf_contacts_pic_h = 200;
$wpf_contacts_pic_w = 160;
//<<--Community
$wpf_community_userpic_thumb = 80;
$wpf_community_userpic_pic_h = 400;
$wpf_community_userpic_pic_w = 200;
//<<--Newsletter
$wpf_newsletterpic_w = 640; //max. Breite
$wpf_newsletterpic_h = 0; //max. Hoehe (standard:0 -> inaktiv)
$wpf_newsletter_confirmjoin = true; //User muss Eintrag in Nl über Mail-Link bestätigen
//<<--Guestbook
$wpf_maxgbentries = 10; //Einträge pro Seite
$wpf_gbentryactivation = false; //Einträge müssen vom Admin aktiviert werden
$wpf_informadmin_onnewentry = false; //Dem Administrator bei neuem Eintrag eine E-Mail schicken
//<<--Galerie
$wpf_galthumbsize = 300; //Thumb
$wpf_galzoomdsize_w = 1000; //max. Breite
$wpf_galzoomdsize_h = 0; //max. Hoehe (standard:0 -> inaktiv)
$wpf_galpicspersite = 8; //4er-schritte
$wpf_galmmenubreak = "
"; //Hauptmenu-break
$wpf_galsmenubreak = "
"; //Submenu-break
$wpf_galarchiv = false; //Archivmodus für Galeriegruppen
$wpf_galarchiv_start = 5; //Nach wievielter Gruppe Archivmodus einschalten (Dropdown)
$wpf_gallery_backend_dontshowsysgroups = false; //System-Sammelgruppen der Module ausblenden?
$wpf_showcasepics = false; //Separate Bildgrößen für Showcase generieren?
$wpf_showcasepics_w = 680; //max. Breite Showcasepics
$wpf_showcasepics_h = 556; //max. Höhe Showcasepics (standard:0 -> inaktiv)
$wpf_gal_frontendshow = true; // true -> Gruppen mit Attribut Frontend = nein werden in der Gruppenliste der Galerie nicht ausgegeben
$wpf_gallery_sortby = "manual"; //Sortierung der Bilder: "name" = alphabetisch, "added" = nach anlegereihenfolge, "manual" = manuelle reihenfolge
//<<--Downloads
$wpf_downloadnoedit = true; //Keine nachträgliche Änderung von Dateien und Nummern für Downloads erlauben (für lückenloses Archiv zum Nachweis von Dokumenten z.B.)
$wpf_downloadsthumbsize = 120; //Thumb
$wpf_downloadsthumbsize_w = 140; //Thumb Breite
$wpf_downloadsthumbsize_h = 120; //Thumb Höhe
$wpf_downloadszoomsize_w = 350; //max. Breite
$wpf_downloadszoomsize_h = 180; //max. Hoehe (standard:0 -> inaktiv)
$wpf_downloads_sortby = "manual"; //Sortierung der Bilder: "name" = alphabetisch, "added" = nach anlegereihenfolge, "manual" = manuelle reihenfolge
//<<--Warehouse
$wpf_warehousethumb_cube = false; // true: Quadratischer Ausschnitt als Thumb (Größe von $wpf_warehousethumbsize_w), false: Ausschnitt mit festgelegter Höhe und Breite
$wpf_warehousethumbsize_w = 250; //Thumb Breite, falls 0, Standard 120
$wpf_warehousethumbsize_h = 80; //Thumb Breite, falls 0, Standard 120
$wpf_warehousezoomsize_w = 980; //Breite
$wpf_warehousezoomsize_h = 0; //Höhe
$wpf_warehouse_textcut = 400; //Textvorschau x Zeichen
$wpf_warehouse_manu_h = 60; //Hersteller Logo h
$wpf_warehouse_manu_w = 60; //Hersteller Logo b
//<<--Showcase
$wpf_showcase_videoplayer_w = 560;
$wpf_showcase_videoplayer_h = 315;
//<<--Videos
$wpf_videosthumbsize = 120; //Thumb
$wpf_videoplayer_w = 400; //Interner Player
$wpf_videoplayer_h = 233;
$wpf_videoplayer_embed_w = 560; //Externe Player
$wpf_videoplayer_embed_h = 315;
$wpf_videos_sortby = "manual"; //Sortierung der Bilder: "name" = alphabetisch, "added" = nach anlegereihenfolge, "manual" = manuelle reihenfolge
//<<--Audio
$wpf_audiosthumbsize = 120; //Thumb
$wpf_audioplayer_w = 698; //Interner Player
$wpf_audioplayer_h = 476;
$wpf_audio_sortby = "added"; //Sortierung der Bilder: "name" = alphabetisch, "added" = nach anlegereihenfolge, "manual" = manuelle reihenfolge
$wpf_audiogroups_thumbsize_h = 120;
$wpf_audiogroups_thumbsize_w = 120;
$wpf_audiogroups_pic_height = 0;
$wpf_audiogroups_pic_width = 620;
//<<--News
$wpf_newsthumbsize_h = 100; //Thumb
$wpf_newsthumbsize_w = 100; //Thumb
$wpf_newspic_width = 700; //Big
$wpf_newspic_height = -1; //Big
$wpf_newspreview_textcut = 200; //Vorschau - Infotext-Abschnitt (Zeichen)
//<<--Events
$wpf_eventthumbsize_h = 100; //Thumb
$wpf_eventthumbsize_w = 100; //Thumb
$wpf_eventpic_width = 680; //Big
$wpf_eventpic_height = 550; //Big
$wpf_eventspreview_textcut = 400; //Vorschau - Infotext-Abschnitt (Zeichen)
//<<--References
$wpf_references_thumbsize_h = 100;
$wpf_references_thumbsize_w = 100;
$wpf_references_pic_height = 500;
$wpf_references_pic_width = 500;
$wpf_references_textpreview_length = 150;
//<<--Slider
$wpf_sliderpic_height = -1;
$wpf_sliderpic_width = 1000;
$wpf_sliderthumbsize_h = -1;
$wpf_sliderthumbsize_w = 120;
//<<--EXPERT SETS - Know what you do!-->>
//<<--Zusätliche Ablagespeicher für Sitemanager
$wpf_sites_use_database_contents = true; //Sitemanager Datenspeicher DB
$wpf_sites_use_file_contents = false; //Sitemanager Datenspeicher Dateien
$wpf_createhtm4fla = true; //Sitemanager: Html-File für Flash-Inhalte schreiben
$wpf_createxmlfile = true; //Sitemanager: Pro Seite 1 Xml-File (Flash-frame etc.)
//<<--Sonstige Verschlüsselung & Passwörter
$wpf_crypt_key = "webprojaggt2cool4scriptkiddie247"; //16 chars for 128 bit, 24 for 192 bit, or 32 for a 256 bit key
$wpf_password_salt = "Salt4Jaggt";
//<<--Hauptunterordner für CMS aus (FTP-)Root-Sicht - wird normal automatisch gesetzt
$wpf_subfolder_manual = false; //pfad ggfls. manuell setzen (falls pfad, inkl slash am ende!) || bei keinem unterordner = " " setzen!
?>
//License
$wpf_licence_name = "Beate Kuchenreuther";
$wpf_licence_pass = "a55829be040a5b012efd1bd71a2f57e8";
$wpf_adminmail = "bea@fotocreativ-art.de";
$modul_sites_count = 99;
$modul_sites_parts = 99;
//Db-login
$wpf_dbhost = "localhost";
$wpf_dbuser = "14_beate2014";
$wpf_dbpass = "beatewp14";
$wpf_dbname = "14_beate2014";
//Ftp-login
$wpf_ftphost = "ftp.beatekuchenreuther.com";
$wpf_ftpuser = "ftp@beatekuchenreuther.com";
$wpf_ftppass = "beatewp14";
$wpf_ftproot = "/htdocs/";
?>
//<<--Logins
$wpf_save_clearpass = false;
$wpf_allow_email2login = false; //neben login-namen auch email zulassen (ist das aktiv, wird bei registrierung auch nur 1 account pro email adresse zugelassen)
$username_has2be_email = false;
$login_register_username_minchars = 4;
?>
//<<--Copyright / Info
//Andreas Fachtan
//WebProjaggt.de
//V. 06.11.2011
//-->>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 true;
}
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;
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($customdir."templates/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($customdir."templates/register_form.htm", $wpf_putin);
//<-captcha
if( $wpf_captchaforms )
{
$article = str_replace("[WPF_CAPTCHA]", $captcha, $article);
}
//->captcha
$templ = str_replace('"'."wpf.templ_pics/", '"'.$customdir."templates/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;
$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($customdir."templates/password_form.htm", $wpf_mess);
$templ = str_replace('"'."wpf.templ_pics/", '"'.$customdir."templates/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;
$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') OR (L.Pass_crypted<>'' AND L.Pass_crypted='$pass')) 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($customdir."/templates/login_form.htm", $putin);
$templ = str_replace('"'."wpf.templ_pics/", '"'.$customdir."templates/wpf.templ_pics/", $templ);
echo $templ;
}
else
echo $forwarder.$wpf_mess;
}
//-->>template
return $return;
}
//-->>login / logout
?>
//<<--Medienlinks umwandeln
if( !function_exists("wpf_convertmedialinks") )
{
function wpf_convertmedialinks($link_array, $onlyfirst=true)
{
global $user_updates_video_width, $user_updates_video_height, $user_updates_video_thumb_width, $user_updates_video_thumb_height,
$user_updates_img_thumb_width, $user_updates_img_thumb_height;
//
$return="";
$i=0; if( !empty($link_array) ) foreach($link_array as $url)
{
if( !$onlyfirst || ($onlyfirst && $i==0) )
{
//$url = str_replace("www.", "http://www.", $url);
//$url = str_replace("http://http://www.", "http://www.", $url);
//video
if( $converted<>true && (substr_count($url, "youtube.com/watch?") > 0 || substr_count($url, "vimeo.com/") > 0 || substr_count($url, "myvideo.de/watch/") > 0) )
{
$video = wpf_videoplayer_embed(-1, true, $user_updates_video_width, $user_updates_video_height, true, $user_updates_video_thumb_width, $user_updates_video_thumb_height, $url);
if( $video<>false )
{
$return .= $video;
$converted = true;
}
}
//soundcloud
if( $converted<>true && substr_count($url, "soundcloud.com/") )
{
$embed = wpf_embed_soundcloud($url);
if( $embed<>false )
{
$return .= $embed;
$converted = true;
}
}
//bild
if( $converted<>true && (substr_count($url, ".jpg") > 0 || substr_count($url, ".gif") > 0 || substr_count($url, ".png") > 0) ) //sonst zu langsam
{
$is_pic = @getimagesize($url);
if( $is_pic<>false && in_array($is_pic[2], array(1,2,3)) && $is_pic['bits']>=8 )
{
if( $user_updates_video_thumb_height>-1 )
$height_set = ' height="'.$user_updates_img_thumb_height.'"';
if( $user_updates_video_thumb_width>-1 )
$width_set = ' width="'.$user_updates_img_thumb_width.'"';
$return .= ''.'
'.'';
$converted = true;
}
}
//link
if( $converted<>true && wpf_validateurl($url) )
{
$lnk = wpf_extracturls($url, $forwarder="_wpf.modloader.php?wpf_mod=externallink");
$return .= $lnk;
$converted = true;
}
//nix
if( $converted<>true )
{
$return .= $url;
$converted = true;
}
$converted = false;
$i++;
}
}
return $return;
}
}
//-->>Medienlinks umwandeln
//<<--soundcloud
function wpf_embed_soundcloud_data($url)
{
$soundcloud_client_id = "b66807c553aeb65dd92196a10ba98ea0";
$return = json_decode(file_get_contents("http://api.soundcloud.com/resolve?client_id=".$soundcloud_client_id."&format=json&url=".$url), true);
//print_r($return);
return $return;
}
function wpf_embed_soundcloud($url, $noecho=true)
{
global $wpf_customdir;
$track = wpf_embed_soundcloud_data($url);
if( $track[id]<>'' && $track[id]<>false )
{
$putin[1] = $track[id];
$putin[2] = 'Ftracks'; //Fplaylists
$return = wpf_buffer($wpf_customdir."embedding/templates/soundcloud.htm", $putin);
if( !$noecho ) echo $return;
}
else
{
$return = false;
}
return $return;
}
//-->>soundcloud
?>
//<<--Copyright / Info
//Andreas Fachtan
//WebProjaggt.de
//V. 10.11.2011
//-->>Copyright / Info
//<<--search
function wpf_contactsearch($groups=false, $seperate_results=false, $noecho=false)
{
global $wpf_customdir, $wpf_downpath;
$templdir = $wpf_customdir."contacts/templates/";
//mask
$mask = wpf_buffer($templdir."search_mask.htm", $wpf_putin);
//results
if( !$seperate_results )
{
$results = wpf_contactsearch_results($groups, true);
}
$wpf_putin[0] = $groups;
$wpf_putin[1] = $mask;
$wpf_putin[2] = $results;
$return = wpf_buffer($templdir."search_main.htm", $wpf_putin);
if( !$noecho ) echo $return;
return $return;
}
function wpf_contactsearch_results($groups=false, $noecho=false, $search_fields=false)
{
global $wpf_customdir, $wpf_downpath, $wpf_contactsearch_maxresults;
$templdir = $wpf_customdir."contacts/templates/";
if( empty($wpf_contactsearch_maxresults) ) $wpf_contactsearch_maxresults = 999999;
if( isset($_REQUEST['wpf_contactsearch']) )
{
if( isset($_REQUEST['wpf_contactsearch_all']) )
{
$search_all = wpf_clean($_REQUEST['wpf_contactsearch_all']);
$searchall = true;
}
$search_zip = wpf_clean($_REQUEST['wpf_contactsearch_zip']);
$search_name = wpf_clean($_REQUEST['wpf_contactsearch_name']);
$search_place = wpf_clean($_REQUEST['wpf_contactsearch_place']);
$search_company = wpf_clean($_REQUEST['wpf_contactsearch_company']);
if( $groups<>false )
{
$sadd = " AND (";
foreach($groups as $group )
{
$sadd .= "Kog_id='$group' OR ";
}
$sadd .= ") ";
$sadd = str_replace("OR )", ")", $sadd);
}
$search="";
if( !empty($search_zip) ) $search .= " AND (LOWER(Plz) LIKE LOWER('$search_zip%'))";
if( !empty($search_name) ) $search .= " AND (LOWER(Nachname) LIKE LOWER('%$search_name%'))";
if( !empty($search_place) ) $search .= " AND (LOWER(Place) LIKE LOWER('%$search_place%'))";
if( !empty($search_company) ) $search .= " AND (LOWER(Firma) LIKE LOWER('%$search_company%'))";
if( $searchall ) $search = " AND (LOWER(Plz) LIKE LOWER('$search_zip%') OR LOWER(Nachname) LIKE LOWER('%$search_name%') OR LOWER(Place) LIKE LOWER('%$search_place%') OR LOWER(Firma) LIKE LOWER('%$search_company%'))";
if( !empty($search) )
{
$sql = "SELECT Kon_id FROM WPF_Kontakte WHERE State>0".$sadd.$search;
//echo $sql;
$res = wpf_db($sql);
$i=0; if($res!=false) foreach($res as $row)
{
$wpf_putin[0] = $row[0];
$wpf_putin[1] = wpf_address($row[0]);
$i++;
if( $i <= $wpf_contactsearch_maxresults )
{
$return .= wpf_buffer($templdir."search_results_list.htm", $wpf_putin);
}
}
}
}
return $return;
}
//-->>search
//<<--addons
function wpf_user_bankaccount($kon_id, $user_id=false, $private=false, $noecho=true)
{
global $wpf_customdir, $wpf_downpath;
if( !empty($user_id) ) $kon_id = wpf_userdetail("", "K.Kon_id", $user_id);
if( isset($_POST['bankname']) && $private && !empty($kon_id) )
{
$bankname = wpf_clean($_POST['bankname']);
$bankcode = wpf_clean($_POST['bankcode']);
$owner = wpf_clean($_POST['owner']);
$accountnr = wpf_clean($_POST['accountnr']);
$iban = wpf_clean($_POST['iban']);
$bic = wpf_clean($_POST['bic']);
$xists = wpf_db("SELECT * FROM WPF_Kontakte_bankaccounts WHERE Kon_id='$kon_id'", false, true);
if( $xists )
$save = wpf_db("UPDATE WPF_Kontakte_bankaccounts SET Bankname='$bankname', Bankcode='$bankcode', Owner='$owner', Accountnr='$accountnr', IBAN='$iban', BIC='$bic' WHERE Kon_id='$kon_id'");
else
$save = wpf_db("INSERT INTO WPF_Kontakte_bankaccounts (Kon_id, Bankname, Bankcode, Owner, Accountnr, IBAN, BIC) VALUES ('$kon_id', '$bankname', '$bankcode', '$owner', '$accountnr', '$iban', '$bic')");
}
$get = wpf_db("SELECT Bankname, Bankcode, Owner, Accountnr, IBAN, BIC FROM WPF_Kontakte_bankaccounts WHERE Kon_id='$kon_id'", true);
$wpf_putin[0] = $kon_id;
$wpf_putin[1] = $get[0];
$wpf_putin[2] = $get[1];
$wpf_putin[3] = $get[2];
$wpf_putin[4] = $get[3];
$wpf_putin[5] = $get[4];
$wpf_putin[6] = $get[5];
if( $private ) $add = "_private";
$templ = $wpf_customdir."contacts/templates/bankaccount".$add.".htm";
if( @!file_exists($templ) ) $templ = $wpf_downpath.$templ;
$return = wpf_buffer($templ, $wpf_putin);
if( !$noecho ) echo $return;
return $return;
}
function wpf_getcountry($id, $name=false, $langu=false)
{
global $wpf_language;
$std_langu = "de";
if( $langu==false ) $langu = $wpf_language;
if( empty($langu) ) $langu = $std_langu;
if( $name<>false ) $add = "Name_".$langu."='".strtolower($name)."'"; else $add = "Lan_id='$id'";
$res = wpf_db("select Lan_id, Name_".$langu." from WPF_Land WHERE ".$add, true);
if( empty($res[0]) )
{
$res = wpf_db("select Lan_id, Name_".$std_langu." from WPF_Land WHERE ".$add, true);
}
return $res[1];
}
//-->>addons
//<<--contact view
function wpf_address($contact_id, $editmode=false, $prefix="address_", $ajax_save=false, $template="") //falls insert & best. gruppe - via editmode übergeben
{
if ( !empty($template) )
$return = wpf_contactshow($contact_id, $template, true, $editmode, $prefix);
else
$return = wpf_contactshow($contact_id, false, true, $editmode, $prefix);
return $return;
}
function wpf_contactshow($contact_id=1, $template=false, $noecho=true, $editmode=false, $prefix="", $ajax_save=false)
{
global $wpf_customdir;
$templ_dir = $wpf_customdir."contacts/templates/";
$_SESSION['wpf_contact_addressnew_return'] = false;
if( isset($_POST[$prefix."lastname"]) && $editmode )
{
//save
if( strlen($editmode)<1 ) $kog_id = 1; else $kog_id = $editmode;
$id = wpf_clean($_POST[$prefix."contact_id"]);
$company = wpf_clean($_POST[$prefix."company"]);
$first = wpf_clean($_POST[$prefix."firstname"]);
$last = wpf_clean($_POST[$prefix."lastname"]);
$str = wpf_clean($_POST[$prefix."street"]);
$code = wpf_clean($_POST[$prefix."zipcode"]);
$place = wpf_clean($_POST[$prefix."place"]);
$tel = wpf_clean($_POST[$prefix."phone"]);
$email = wpf_clean($_POST[$prefix."email"]);
$web = wpf_clean($_POST[$prefix."web"]);
if( (!empty($last) || !empty($company) ) && !empty($code) && !empty($place) && !empty($str) )
{
if( !empty($id) && intval($id)>0 )
{
$upd = wpf_db("UPDATE WPF_Kontakte SET Vorname='$first', Nachname='$last', Strasse='$str', Plz='$code', Ort='$place', Firma='$company', Homepage='$web', Email='$email' WHERE Kon_id='$id'");
$_SESSION['wpf_contact_addressnew_return'] = true;
}
else
{
$check = wpf_db("SELECT Kon_id FROM WPF_Kontakte WHERE (Vorname='$first' AND Nachname='$last' AND Firma='$company') AND (Plz='$code' AND Strasse='$str') AND Kog_id='$kog_id'", true);
if( $check[0]=="" )
{
$ins = wpf_db("INSERT INTO WPF_Kontakte (Vorname, Nachname, Strasse, Plz, Ort, Firma, Homepage, Email, Kog_id)
VALUES ('$first', '$last', '$str', '$code', '$place', '$company', '$web', '$email', '$kog_id')");
$_SESSION['wpf_contact_addressnew_return'] = $ins;
}
else $_SESSION['wpf_contact_addressnew_return'] = $check[0];
}
}
else
{
$_SESSION['wpf_contact_addressnew_return'] = false;
}
}
$row = wpf_db("SELECT Kon_id, Langu, Nummer, Name, Firma, Anrede, Titel, Vorname, Nachname, Strasse, Plz, Ort, Lan_id, Telefon, Telefax, Handy, Email, Homepage, Notiz, Lan_id FROM WPF_Kontakte WHERE (State <> '-1') AND Kon_id='$contact_id'", true);
$id = $row[0];
if( empty($id) ) $id = -1;
$wpf_putin[0] = $id;
$wpf_putin[1] = $row[3]; //name
$wpf_putin[2] = $row[4]; //firma
$wpf_putin[3] = $row[6]; //titel
$wpf_putin[4] = $row[7]; //vn
$wpf_putin[5] = $row[8]; //nn
$wpf_putin[6] = $row[9]; //str
$wpf_putin[7] = $row[10]; //plz
$wpf_putin[8] = $row[11]; //ort
$wpf_putin[9] = $row[13]; //Tel
$wpf_putin[10] = $row[14]; //Fax
$wpf_putin[11] = $row[16]; //E-Mail
$wpf_putin[12] = $row[17]; //Web
$wpf_putin[13] = str_replace("http://", "", $row[17]); //Web ohne www
$wpf_putin[14] = $row[15]; //Handy
$wpf_putin[15] = $row[19]; //Land
$wpf_putin[16] = wpf_getcountry($row[19]); //Land
$wpf_putin[100] = $prefix;
$wpf_putin[101] = $ajax_save; //TODO
if( $template<>false )
{
$templ = $template;
}
else
{
if( $editmode )
$templ = "show_contact_address_edit.htm";
else
$templ = "show_contact_address.htm";
}
$templ = wpf_buffer($templ_dir.$templ, $wpf_putin);
$templ = str_replace('"'."wpf.templ_pics/", '"'.$templ_dir."wpf.templ_pics/", $templ);
$return = $templ;
if( !$noecho ) echo $return;
return $return;
}
//-->>contact view
//<<--formular
//contact form
function wpf_contact($mode="contact", $mail2user=false, $template=false, $noecho=false, $recipients=false) //aufruf -> emailnews / smsnews / contact
{
global $wpf_dbuser, $wpf_dbpass, $wpf_fullurlpa, $wpframe_moddir, $wpf_captchaforms, $php_eol, $wpf_adminmail;
//<<--modus
if( $mode!="emailnews" && $mode!="smsnews" && $mode!="contact" ) $mode = "contact";
if( $mail2user==true && $mode=="smsnews" ) $mail2user = false;
if( $mode=="newsletter" ) $mode = "emailnews";
//-->>modus
//<<--sets
global $wpf_customdir;
$downpath = "../../../"; //downpath 2 wpf-root
$customdir = $wpf_customdir."contacts/"; //Bilder
$showtempl = true;
global $wpf_userip, $wpf_language, $wpf_newsletter_confirmjoin, $wpf_fullurlpa, $wpframe_moddir, $dbsupport;
$wpf_mess="";
//-->>sets
//<--db
if( $wpf_dbuser=="" ) { $dbsupport = false; } else { $dbsupport = true; }
//-->db
//<<--sprache
if( $_SESSION['wpf_language']=="de" )
{
$meldung_fehler_email='E-Mail Adresse nicht korrekt! ';
$meldung_fehler='Daten nicht vollständig eingebgeben.
Bitte alle benötigten Felder(*) ausfüllen!';
$meldung_ok='Wir haben Ihre Anfrage erhalten und werden sie schnellstmöglich beantworten. Vielen Dank! ';
$meldung_ok_email='Du wurdest in unseren Verteiler aufgenommen. Vielen Dank!';
$meldung_ok_emailc='Vielen Dank für Deinen Eintrag! Bitte bestätige Deine Aufnahme in unseren Verteiler über die gerade zugesandte E-Mail. ';
$meldung_spam='Wir haben Ihre Anfrage bereits erhalten! Vielen Dank.';
$meldung_schondrin=' Ihre Adresse bzw. Anfrage ist bereits in unserer Datenbank. Vielen Dank! ';
$ms_antispam_code = "Antispam-Code fehlerhaft!";
}
else
{
$meldung_fehler_email=' Emal address invalid!';
$meldung_fehler='An error occured while sending your inquiry:
Please fill out all required (*) fields.';
$meldung_ok='We have received your inquiry and will answer it as soon as possible. Thank you! ';
$meldung_ok_email='Du wurdest in unseren Verteiler aufgenommen. Vielen Dank! ';
$meldung_ok_emailc='Vielen Dank für Deinen Eintrag! Bitte bestätige Deine Aufnahme in unseren Verteiler über die gerade zugesandte E-Mail.';
$meldung_spam=' We have already received your inquiry. Thank you! ';
$meldung_schondrin=' Your address resp. inquiry is already in our database. Thanks! ';
$ms_antispam_code = "Wrong Antispam-Code!";
}
//-->>sprache
//<-captcha
$captcha = wpf_captcha(); //captcha form
//->captcha
//<<--abgeschickt
if( isset($_POST['wpf_contactform']) && ($mode==wpf_clean($_POST['wpf_contactform'])) ) //isset($_POST['anrede']) || isset($_POST['email'])
{
//<<--captcha
if($wpf_captchaforms) $captcha_ok = wpf_captchacheck(); else $captcha_ok = true;
//-->>captcha
//<<--felder
$nummer = wpf_clean($_POST['kunr']);
$firma = wpf_clean($_POST['firma']);
$anrede = wpf_clean($_POST['anrede']);
$titel = wpf_clean($_POST['titel']);
$vorname = wpf_clean($_POST['vorname']);
$nachname = wpf_clean($_POST['nachname']);
$strasse = wpf_clean($_POST['strasse']);
$plz = wpf_clean($_POST['plz']);
$ort = wpf_clean($_POST['ort']);
$land = wpf_clean($_POST['land']);
$lan_id = $land; if( empty($lan_id) ) $lan_id = 34; //dt
$telefon = wpf_clean($_POST['telefon']);
$telefax = wpf_clean($_POST['telefax']);
$email = wpf_clean($_POST['email']); $email = trim( strtolower($email) );
$homepage = wpf_clean($_POST['homepage']);
$handy = wpf_clean($_POST['handy']);
$info = wpf_clean($_POST['textfeld']);
$join_nl = wpf_clean($_POST['join_nl']);
//<<--zusatzfelder
$zusatzfelder="";
for($i=1;$i<21;$i++) //bis zu 20
{
if( isset($_POST['zusatz'.$i]) )
{
$zus = wpf_clean($_POST['zusatz'.$i]);
$zusatz[$i] = $zus;
if( isset($_POST['zusatz'.$i."_bez"]) )
$bez = $_POST['zusatz'.$i."_bez"].": ";
else
$bez = "";
$zusatz_bez[$i] = $bez;
$zusatz_check[$i] = ' checked="checked"';
//
$zusatzfelder .= $bez.$zus.$php_eol; //"\n\r"
}
}
if( $mode=="emailnews" || strlen($join_nl)>0 )
$email_news = 1;
else
$email_news = 0;
//-->>zusatzfelder
if( $mode=="smsnews" )
$sms_news = 1;
else
$sms_news = 0;
//-->>felder
//<<--fcheck
$ok = true;
if( ($mode=="contact") && (empty($vorname) || empty($nachname) || empty($email) || empty($info)) || !$captcha_ok ) // || empty($strasse) || empty($plz) || empty($ort)
$ok = false;
if( ($mode=="emailnews") && empty($email) || !$captcha_ok )
$ok = false;
if( ($mode=="smsnews") && empty($handy) || !$captcha_ok )
$ok = false;
if( !$ok ) $wpf_mess = $meldung_fehler;
//
if( !empty($email) )
{
if( wpf_checkemail($email)==false )
{
$ok = false;
$wpf_mess .= " ".$meldung_fehler_email;
}
}
//-->>fcheck
//<--check
if( $ok )
{
$showtempl = false;
//<-spam-abbruch
if( !isset($_SESSION['wpf_contact_count']) )
{
$_SESSION['wpf_contact_count'] = 1;
}
else
{
$_SESSION['wpf_contact_count'] += 1;
}
if( $_SESSION['wpf_contact_count'] > 10 )
{
$wpf_mess = $meldung_spam;
}
//->spam-abbruch
//<-speichern und verschicken
if( $wpf_mess != $meldung_spam )
{
if( $dbsupport )
{
//<-vorhanden?
if( $mode=="emailnews" ) $sql = "SELECT Email FROM WPF_Kontakte WHERE LOWER(Email)='".$email."' AND State<>-1";
elseif( $mode=="smsnews" ) $sql = "SELECT Handy FROM WPF_Kontakte WHERE Handy='".$handy."' AND State<>-1";
else $sql = "SELECT Info, IP FROM WPF_Anfragen WHERE Info='".$info."' AND State<>-1 AND IP='".$wpf_userip."'"; //zeitlich noch eingrenzen!!
$res = wpf_db($sql, false, true);
if( $res==0 )
{
//<-ab in die db!
//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', 2)");
//erst via mail-link bestätigen
if( $confirm )
{
$stamp = wpf_db("SELECT Created FROM WPF_Kontakte WHERE Kon_id='".$res."'", true);
$stamp = $stamp[0];
$link = $wpf_fullurlpa.$wpframe_moddir."contacts/confirm.php";
$link = ''.$link.'';
$wpf_putin[0] = $link;
$btext = wpf_buffer($customdir."templates/confirmjoin_mail.htm",$wpf_putin);
wpf_sendmail($email, "Newsletter", $btext);
}
}
else
{
//anfrage
//kontakt vorhanden? -> verwenden!
if( !empty($nachname) && !empty($strasse) && !empty($plz) && !empty($email) )
{
$res = wpf_db("SELECT Kon_id FROM WPF_Kontakte WHERE (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;
}
if( $res!=false )
{
$res = wpf_db("INSERT INTO WPF_Anfragen (Created, IP, Info, Kon_id, Zusatzfelder) VALUES (NOW(), '$wpf_userip', '$info', '$kon_id', '$zusatzfelder')");
}
}
//->ab in die db!
//<-message
if( $mode=="emailnews" )
{
if( $confirm )
$wpf_mess = $meldung_ok_emailc;
else
$wpf_mess = $meldung_ok_email;
}
else
{
$wpf_mess = $meldung_ok;
}
//->message
$sendmail = true;
}
else
{
$wpf_mess = $meldung_schondrin;
$sendmail = false;
}
//->vorhanden?
}
else $wpf_mess = $meldung_ok;
//<-bestätigungsmail
if( (!$dbsupport) || ($dbsupport && $sendmail) )
{
if( $mode=="contact" )
{
$wpf_putin[0] = $anrede." ".$titel.$vorname." ".$nachname;
$wpf_putin[1] = $strasse;
$wpf_putin[2] = $plz.' '.$ort;
$wpf_putin[4] = $telefon;
$wpf_putin[5] = $email;
$wpf_putin[6] = nl2br($info);
$wpf_putin[7] = $telefax;
$wpf_putin[8] = $handy;
$wpf_putin[9] = $homepage;
$wpf_putin[10] = nl2br($zusatzfelder);
$wpf_putin[11] = $join_nl;
$wpf_putin[12] = $anrede;
$wpf_putin[13] = $titel;
$wpf_putin[14] = $vorname;
$wpf_putin[15] = $nachname;
$wpf_putin[16] = $firma;
for($x=1;$x<21;$x++)
{
$wpf_putin[$x+100] = $zusatz[$x]; //putins 100
$wpf_putin[$x+200] = $zusatz_bez[$x]; //putins 200
$wpf_putin[$x+300] = $zusatz_check[$x]; //putins 300
}
$text = wpf_buffer($customdir."/templates/contact_mail.htm", $wpf_putin);
$text = str_replace('"'."wpf.templ_pics/", '"'.$wpf_fullurlpa.$customdir."templates/wpf.templ_pics/", $text);
//mail 2 admin
wpf_sendmail($wpf_adminmail, "Website Contact", $text, $anhang="", $puretxt=false, $email);
//mail 2 user
wpf_sendmail($email, "Website Contact", $text);
//echo "E-Mail ging an: ".$wpf_adminmail." & ".$email;
}
}
//->bestätigungsmail
}
else
{
if( !$captcha_ok ) $add = "
$ms_antispam_code"; else $add = ""; //captcha
$return .= $ms02." ".$add;
$wpf_mess .= $add;
}
}
//-->check
}
//-->>abgeschickt
//<<--interface
if( !isset($land) ) $land=34;
if( $dbsupport )
$land = wpf_country($_SESSION['wpf_language'], $land);
else
$land = '';
if( !isset($anrede) ) $anrede="Frau";
$anrede = wpf_appell($_SESSION['wpf_language'], $anrede);
//-->>interface
//<<--gui
if( !$showtempl )
{
$firma = "";
$vorname = "";
$nachname = "";
$strasse = "";
$plz = "";
$ort = "";
$telefon = "";
$email = "";
$info = "";
$handy = "";
$homepage = "";
$zusatzfelder = "";
for($i=1;$i<21;$i++)
{
$zusatz[$i] = "";
$zusatz_check[$i] = "";
}
}
//if( $showtempl )
{
$standard_templ = $customdir."templates/".$mode.".htm";
$sprachen_templ = $customdir."templates/".$mode."_".$wpf_language.".htm";
//<-manuelles template
if( $template<>false )
{
if( @file_exists($customdir."templates/".$template) )
{
$standard_templ = $customdir."templates/".$template;
$sprachen_templ = $customdir."templates/".$template;
}
else
echo "Angegebenes Template nicht vorhanden!
";
}
//->manuelles template
if( @file_exists($sprachen_templ) )
$file = $sprachen_templ; //sprachspezifisch
else
$file = $standard_templ; //standard
$noecho_bridge = $noecho;
ob_start();
include($file);
$file_content = ob_get_contents();
ob_end_clean();
//captcha
if( $wpf_captchaforms )
$file_content = str_replace("[WPF_CAPTCHA]", $captcha, $file_content);
else
$file_content = str_replace("[WPF_CAPTCHA]", "", $file_content);
}
//-->>gui
//<<--ausgabe
if( empty($wpf_mess) )
$wpf_mess="";
else
$wpf_mess = ''.$wpf_mess."
";
$ausgabe = $wpf_mess.$file_content;
if( !$noecho_bridge )
{
echo $ausgabe;
}
//-->>ausgabe
return $ausgabe;
}
//form
function wpf_contactform($noecho=false, $template=false)
{
$return = wpf_contact($mode="contact", $mail2user=false, $template, true, $recipients=false);
if( !$noecho ) echo $return;
}
//email
function wpf_newsletter($mail2user=false) //alias emailnews ^^
{
wpf_contact("emailnews", $mail2user);
}
//sms
function wpf_newsletter_sms($mail2user=false) //alias emailnews ^^
{
wpf_contact("smsnews", $mail2user);
}
//-->>formular
?>
//(C) Andreas Fachtan
//VERSION: 04.04.2007
//Beschraenkt auf Seiten mit Abschnittvorschau
function wpf_sitesearch($noecho=false)
{
//suchmaske
global $wpf_customdir;
$mask = wpf_buffer($wpf_customdir."sitesearch/templates/search_mask.htm");
if( !$noecho ) echo $mask;
return $mask;
}
function wpf_sitesearch_results($listen_to_field="wpf_search", $marktext=true)
{
global $wpf_sites_use_database_contents;
//suchergebnisse
$searchfield = $listen_to_field;
global $customdir, $wpf_customdir;
$sites_sitesearch_textpreview_length = 440;
$abkenn="-_-";
//<<--sprach strings
if( $_SESSION['wpf_language']=="de" )
{
$mse01 = "Leider wurden zu Ihrer Suche nach";
$mse02 = "keine Ergebnisse gefunden.";
$mse03 = "Bitte geben Sie ein oder mehrere Suchwörter ein.";
$mse04 = "Fehler: Keine Suchanfrage übergeben!";
}
else
{
$mse01 = "Sorry. Your search for";
$mse02 = "brought no results.";
$mse03 = "Please enter one or more keywords.";
$mse04 = "Error: No search query entered!";
}
//-->>sprach strings
if( !empty($_POST[$searchfield]) || !empty($_GET[$searchfield]) )
{
if( !empty($_GET[$searchfield]) )
$suche = strtolower( wpf_clean($_GET[$searchfield]) );
else
$suche = strtolower( wpf_clean($_POST[$searchfield]) );
if( strlen($suche)>2 )
{
$i=0;
if( $wpf_sites_use_database_contents )
{
$res = wpf_db("SELECT P.Sit_id, P.Name, P.Info, P.Created, P.Link, P.Position FROM WPF_Sites_paragraphs P WHERE P.State>0 AND ( (LOWER(P.Name) LIKE LOWER('%$suche%')) OR (LOWER(P.Info) LIKE LOWER('%$suche%')) OR (LOWER(P.Keywords) LIKE LOWER('%$suche%')))");
$i=0; if($res!=false) foreach($res as $row)
{
$id = $row[0];
$seiten_titel = $row[1];
$seiten_inhalt_text = $row[2];
$seiten_name = $row[4];
$abschnitt = $row[5];
if( strlen($abschnitt)<2 ) $abschnitt = "0".$abschnitt;
$seiten_inhalt_text = strip_tags($seiten_inhalt_text);
$seiten_inhalt_text = "...".substr($seiten_inhalt_text, strpos($seiten_inhalt_text, $suche)-100, $sites_sitesearch_textpreview_length)."...";
$search_file_date = wpf_ts2de($row[3]);
$link = $seiten_name.'.php?part='.$abschnitt;
$link_fullsite = $seiten_name.'.php#'.$seiten_name.$abkenn.$abschnitt;
$search_result_point = $link.str_replace($abkenn," part", $search_result_name).'';
$putin[0] = $id;
$putin[1] = $seiten_inhalt_text;
$putin[2] = $seiten_titel;
$putin[3] = $link;
$putin[4] = $search_file_date;
$putin[5] = $seiten_name;
$putin[6] = $abschnitt;
$putin[7] = $link_fullsite;
$result_form = wpf_buffer($wpf_customdir."sitesearch/templates/result_template.htm", $putin);
$ausgabe .= $result_form;
$i++;
}
}
else
{ //TODO!
$verz=opendir("./");
while( $die_datei=readdir($verz) )
{
$postfix = substr($die_datei, -3, 3);
$seiten_name = str_replace(".".$postfix, "", $die_datei); //=abschnitt
if( (filesize($die_datei)>0) && is_file($die_datei) && (substr_count($seiten_name,$abkenn)==1) && ($postfix == "htm") && (file_exists($seiten_name.".php")) )
{
$hauptseite = substr($seiten_name,-5,5); $hauptseite = str_replace($hauptseite,"",$seiten_name);
$seiten_inhalt="zyx-dummy";
//inhalt
//if( $i<11 ) //max 10 ergebnisse
//{
$seiten_inhalt = wpf_buffer($seiten_name.".htm");
//$seiten_inhalt = strtolower($seiten_inhalt);
//}
//titel
$titel_datei = $unterpfad.str_replace(".htm", ".php", $die_datei);
$seiten_titel = wpf_sitetitle($titel_datei);
//check
$seiten_inhalt_text = strip_tags($seiten_inhalt);
$seiten_inhalt = strtolower($seiten_inhalt_text);
$seiten_titel = strtolower($seiten_titel);
$suche = strtolower($suche);
if( (substr_count($seiten_inhalt, $suche)>0) || (substr_count($seiten_titel, $suche)>0) )
{
$seiten_inhalt_text = strip_tags($seiten_inhalt_text);
$seiten_inhalt_text = "...".substr($seiten_inhalt_text, strpos($seiten_inhalt_text, $suche)-100, $sites_sitesearch_textpreview_length)."...";
if( $marktext )
$seiten_inhalt_text = str_replace($suche, ''.$suche.'
', $seiten_inhalt_text);
//
if( substr_count($seiten_name, $abkenn)>0 )
$search_result_name = str_replace(substr($seiten_name,-5,5),"", $seiten_name);
else
$search_result_name = $seiten_name;
$search_file_date = date("d.m.Y - H:i", filemtime($seiten_name.".htm"));
$abschnitt = "";
$link = $hauptseite.'.php?part='.$seiten_name;
$search_result_point = $link.str_replace($abkenn," part", $search_result_name).'';
$i++;
$putin[0] = $abschnitt;
$putin[1] = $seiten_inhalt_text;
$putin[2] = $seiten_titel;
$putin[3] = $link;
$putin[4] = $search_file_date;
$putin[5] = $seiten_name;
$putin[6] = $abschnitt;
$result_form = wpf_buffer($wpf_customdir."sitesearch/templates/result_template.htm", $putin);
$ausgabe .= $result_form;
}
}
}
closedir($verz);
}
if( $i<1 ) $ausgabe = "$mse01 \"".$suche."\" $mse02
"; //Leider...
}
else $ausgabe = "$mse03
"; //Bitte geben Sie...
}
else $ausgabe = "$mse04
"; //Keine Suchanfr.
//
if( !$noecho ) echo $ausgabe;
return $ausgabe;
}
?>
//<<--Copyright / Info
//Andreas Fachtan
//WebProjaggt.de
//V. 31.07.2008
//-->>Copyright / Info
//<<--externer link
function wpf_forward2link($link)
{
global $wpf_language;
//<<--sprache
if( $wpf_language=="de" )
{
$ms01 = "Sie werden weitergeleitet auf:";
$ms02 = "Dieser Link ist ungültig!";
}
else
{
$ms01 = "You're being forwarded to:";
$ms02 = "Invalid link!";
}
//-->>sprache
if( !empty($_GET['wpf_link']) ) $link = wpf_clean($_GET['wpf_link']);
if( empty($link) || (substr_count($link, "http://")<1 && substr_count($link, "https://")<1) )
{
$return = $ms02." ($link)";
}
else
{
$forward = '';
$return = $forward . $ms01.''.$link.'';
//
$save = wpf_linkcollector($link);
}
echo $return;
}
//-->>externer link
//<<--link sammler
function wpf_linkcollector($link)
{
global $wpf_loginid;
if( !empty($link) )
{
$name = str_replace("http://", "", $link); $name = str_replace("https://", "", $link);
$sql = "SELECT Cou_id FROM WPF_Linkcollector WHERE Link='$link'";
$check = wpf_db($sql, false, true);
if( $check==0 )
{
$cou_id = wpf_createcounter();
$save = wpf_db("INSERT INTO WPF_Linkcollector (Created, Edited, Log_id_creater, Log_id_lastedi, Name, Link, Cou_id) VALUES (NOW(), NOW(), '$wpf_loginid', '$wpf_loginid', '$name', '$link', '$cou_id')");
}
else
{
$get = wpf_db($sql, true);
$upd = wpf_updatecounter($get[0]);
}
return true;
}
else
return false;
}
//-->>link sammler
//<<--weiterempfehlen
function wpf_siteforward()
{
//<<--sets
global $wpf_language, $wpf_urldomain, $wpf_userip, $wpf_dbsupport, $wpf_customdir;
$customdir = $wpf_customdir."siteforward/";
$customdir_templ = $customdir."templates/";
//-->>sets
//<<--sprache
if( $wpf_language=="de" )
{
$ms01 = "Vielen Dank für Ihre Empfehlung! :-)";
$ms02 = "Bitte überprüfen Sie die E-Mail Adressen!";
$ms03 = "Website Empfehlung";
$ms_antispam_code = "Antispam-Code fehlerhaft!";
}
else
{
$ms01 = "Thanks for your recommendation! :-)";
$ms02 = "Please check the E-Mail adresses!";
$ms03 = "Website recommendation";
$ms_antispam_code = "Wrong Antispam-Code!";
}
//-->>sprache
//<-captcha
$captcha = wpf_captcha(); //captcha form
//->captcha
//<<--bei login -> daten holen
$login_id = $_SESSION['wpf_login_id'];
$sql = "SELECT L.Kon_id, K.Email, K.Vorname, K.Nachname FROM WPF_Logins L, WPF_Kontakte K where L.Kon_id=K.Kon_id AND L.Log_id='".$login_id."'";
$res = wpf_db($sql, true);
$from = $res[0];
$from_name = $res[1]." ".$res[2];
//-->>bei login -> daten holen
//<<--eingaben
$return=""; $message="";
$showform = true;
if( isset($_POST['forward_to']) )
{
//<--post
$to = wpf_clean($_POST['forward_to']);
if( empty($from) )
$from = wpf_clean(@$_POST['forward_from']);
$text = wpf_clean(@$_POST['forward_text']);
$to_name = wpf_clean(@$_POST['forward_to_name']);
$from_name = wpf_clean(@$_POST['forward_from_name']);
//-->post
//<<--captcha
if($wpf_captchaforms) $captcha_ok = wpf_captchacheck(); else $captcha_ok = true;
//-->>captcha
//<--check
$ok = true;
if( isset($to) && (empty($to) || wpf_checkmail($to)==false) )
$ok = false;
if( isset($from) && (empty($from) || wpf_checkmail($from)==false) )
$ok = false;
if( !$captcha_ok )
$ok = false;
//
if( !$ok )
{
if( !$captcha_ok ) $add = "
$ms_antispam_code"; else $add = ""; //captcha
$message = $ms02." ".$add;
$showform = true;
}
else
{
$message = $ms01;
$showform = false;
}
//-->check
}
else $ok = false;
$wpf_putin[0] = $wpf_urldomain;
$wpf_putin[1] = $from;
$wpf_putin[2] = $from_name;
$wpf_putin[3] = $to;
$wpf_putin[4] = $to_name;
$wpf_putin[5] = $text;
//-->>eingaben
//<<--mail raus
if( $ok )
{
//<--templ
echo $ms01;
$templ = $customdir_templ."email.htm";
$article = wpf_buffer($templ, $wpf_putin);
$mailtext = str_replace("wpf.templ_pics/", $customdir_templ."wpf.templ_pics/", $article);
//-->templ
//<--mail
$betreff = $ms03;
if( empty($to_name) ) $to_name = $to;
if( empty($from_name) ) $from_name = $from;
wpf_sendmail($to, $betreff, $mailtext, "", false);
//-->mail
//<--db
if( $wpf_dbsupport )
{
$sql = "INSERT INTO WPF_Siteforward (Created, Ip, Kon_id, From_name, From_email, To_name, To_email, Text) VALUES (NOW(), '$wpf_userip', '$login_id', '$from_name', '$from', '$to_name', '$to', '$text')";
$res = wpf_db($sql, true);
}
//-->db
}
//-->>mail raus
//<--template
if( $showform )
{
if( !empty($message) ) $message = ''.$message."
";
$templ = $customdir_templ."template.htm";
$article = wpf_buffer($templ, $wpf_putin);
$article = str_replace("[WPF_CAPTCHA]", $captcha, $article); //captcha
$return = $message.str_replace("wpf.templ_pics/", $customdir_templ."wpf.templ_pics/", $article);
}
//-->template
echo $return;
return $return;
}
//-->>weiterempfehlen
?>
//<<--Copyright / Info
//Andreas Fachtan
//WebProjaggt.de
//V. 20.01.2011
//-->>Copyright / Info
//<<--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;
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_menu()
{
//alias
return wpf_picgroups();
}
function wpf_picgroups($group_id="", $langonly=false, $dropdown=false, $search="", $noecho=false, $limit=false, $template=false)
{
//<<--sets
global $wpf_galarchiv, $wpf_galarchiv_start, $wpf_customdir, $wpf_gal_frontendshow;
$customdir = $wpf_customdir."gallery/";
$customdir_templ = $customdir."templates/";
$tabez = "Pic_groups";
$idbez = "Pig_id";
if( $template<>false )
$templ = $customdir_templ.$template;
else
$templ = $customdir_templ."menu_navi.htm";
$templ_sub = $customdir_templ."menu_subnavi.htm";
//-->>sets
//<<--sortby
global $wpf_gallery_sortby;
$sortby = $wpf_gallery_sortby;
if( $sortby == "manual" )
$sortby = "Name"; //später mal Reihenfolge
elseif( $sortby == "added" )
$sortby = $idbez." DESC"; //Id
else
$sortby ="Name"; //Name
//-->>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($group_id) ) $group_id = wpf_getlatestgallery();
$sel = $group_id;
//->gruppe sel
if( $limit<>false ) $limit2_sql = " LIMIT $limit";
//<<--ausgabe
$return="";
if ($wpf_galarchiv == true)
{
$group_dropdown="";
$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_gallery_menu_active"; else $acti = "";
if ($wpf_galarchiv == true)
{
if ($i>=$wpf_galarchiv_start)
$group_dropdown .= '';
}
else
$group_dropdown .= '';
//-->dropdown
//<<--cover
$cover = wpf_getpicgroup_cover($id);
//-->>cover
//<--normal
if( $wpf_galarchiv == true )
{
if( $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;
$article = wpf_buffer($templ, $wpf_putin);
//$return .= str_replace("wpf.templ_pics/", $customdir_templ."wpf.templ_pics/", $article);
$return .= $article;
//->template
}
}
else
{
$group = '';
//<-template
$wpf_putin[0] = $group;
$wpf_putin[1] = $name;
$wpf_putin[2] = $id;
$wpf_putin[3] = $cover;
$wpf_putin[4] = $info;
$article = wpf_buffer($templ, $wpf_putin);
//$return .= str_replace("wpf.templ_pics/", $customdir_templ."wpf.templ_pics/", $article);
$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_gallery_submenu_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;
$article = wpf_buffer($templ_sub, $wpf_putin);
//$return .= str_replace("wpf.templ_pics/", $customdir_templ."wpf.templ_pics/", $article);
$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_gallery_submenu_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;
$article = wpf_buffer($templ_sub, $wpf_putin);
//$return .= str_replace("wpf.templ_pics/", $customdir_templ."wpf.templ_pics/", $article);
if($id==$papig)
$return .= $article;
//->template
//-->normal
$a++;
}
}
}
//-->untergalerien
$i++;
}
//-->>ausgabe
//<--template - dropdown
if( $dropdown || $wpf_galarchiv==true )
{
$group_dropdown = '';
$group_dropdown = '';
$wpf_putin[0] = $group_dropdown;
$article = wpf_buffer($templ, $wpf_putin);
//Dropdown zusätzlich als Archiv
if ($wpf_galarchiv == true)
$return .= $article;
}
//-->template - dropdown
//if( $i==0 ) $return = $ms01;
$return = str_replace("wpf.templ_pics/", $customdir_templ."wpf.templ_pics/", $return);
if( $noecho==false ) echo $return;
return $return;
}
//-->>Gruppen listen
//<<--Bilder auflisten
function wpf_gallery_pics($group_id="")
{
//alias
return wpf_pics($limit="", $group_id);
}
//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="")
{
//<<--sets
//$ms01 = nixda_meldung();
global $wpf_userip, $wpf_lightbox_zoom, $wpf_customdir, $wpf_downpath; //$wpframe_moddir
$downpath = "../../../"; //-> cms
$customdir = $wpf_customdir."gallery/";
$customdir_files = $customdir."files/";
$customdir_templ = $customdir."templates/";
$sprache = $_SESSION['wpf_language'];
$tabez = "Pics";
$idbez = "pic_id";
$limit_sql="";
//-->>sets
//<<--sortby
global $wpf_gallery_sortby;
$sortby = $wpf_gallery_sortby;
if( $sortby == "manual" )
$sortby = "Name"; //später mal Reihenfolge
elseif( $sortby == "added" )
$sortby = $idbez." DESC"; //Id
else
$sortby ="Name"; //Name
//-->>sortby
//<<--sprache
global $wpf_language;
if( $wpf_language=="de" )
$ms01 = "Momentan keine Bilder in dieser Galerie vorhanden";
else
$ms01 = "No pics exist in this gallery at the moment";
if( $showmessages )
$ms01 = "$ms01
";
else
$ms01 = "";
//-->>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_getlatestgallery();
//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, Original_name 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];
$original_name = $row[16];
//<-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);
$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, $galleriamode=true);
//<-target manual
if( $iframe_target != false )
{
$file = $detail_link.'
';
$all[] = $file;
}
//->target manual
//SWIPE
$file = '_wpframe/_wpf.img.php?wpf_pic_id='.$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
//<<--zählen
if( $detail )
{
$counter = wpf_updatecounter($cou_id);
}
//-->>zählen
//<<--bilder die aus anderen modulen ausser galerie hinzugefügt wurden ignorieren
//$ignorieren = wpf_db("SELECT N.Pic_id, E.Pic_id FROM WPF_News N, WPF_Events E WHERE N.Pic_id=$id OR E.Pic_id=$id", true, true);
if( $ignorieren>0 ) $ignorieren = true; else $ignorieren = false;
//-->>bilder die aus anderen modulen ausser galerie hinzugefügt wurden ignorieren
//<--line template
$wpf_putin[0] = $id;
$wpf_putin[1] = $name;
$wpf_putin[2] = nl2br($info);
$wpf_putin[3] = $file;
$wpf_putin[4] = $sprache;
$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] = $folder;
$wpf_putin[17] = $row[12]; //pic
$wpf_putin[18] = "gallery/files/";
$wpf_putin[19] = $picpath;
$wpf_putin[20] = $direct_file;
$wpf_putin[21] = $original_name;
//<-template
$templ = $customdir_templ."pic_frame.htm";
$manual_templ = $customdir_templ.$template;
if( !empty($template) && file_exists($manual_templ) ) $templ = $manual_templ;
//->template
$article = wpf_buffer($templ, $wpf_putin);
if( !$ignorieren)
$return .= str_replace("wpf.templ_pics/", $customdir_templ."wpf.templ_pics/", $article);
//-->line template
$i++;
}
//-->>ausgabe
if( $i==0 ) $return = $ms01;
if( $noecho==false ) echo $return;
if( $iframe_target != false )
return $all;
else
return $return;
}
//-->>Bilder auflisten
//<<--Neueste Bilder
// Anzahl bestimmte Gruppe Zielseite Galerie Zufall
function wpf_latest_pics($limit=2, $group_id="", $site="", $random=false)
{
//<<--sets
//$ms01 = nixda_meldung();
global $wpf_userip, $wpf_lightbox_zoom, $wpf_customdir; //$wpframe_moddir
$downpath = "../../../"; //-> cms
$customdir = $wpf_customdir."gallery/";
$customdir_files = $customdir."files/";
$customdir_templ = $customdir."templates/";
$sprache = $_SESSION['wpf_language'];
$tabez = "Pics";
$idbez = "Pic_id";
$limit_sql="";
//-->>sets
//<<--sprache
global $wpf_language;
if( $wpf_language=="de" )
$ms01 = "Momentan keine Bilder in dieser Galerie vorhanden";
else
$ms01 = "No pics exist in this gallery at the moment";
if( $showmessages )
$ms01 = "$ms01
";
else
$ms01 = "";
//-->>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?!
//<<--gruppe
if( empty($group_id) )$group_id = wpf_getlatestgallery();
$search_sql .= " AND Pig_id='$group_id'";
//bei suche nicht auf gruppe beschränken etc?
//-->>gruppe
//<<--limit
if( !empty($limit) )
{
$limit_sql .= " LIMIT $limit";
}
//-->>limit
//>>--Random
if ($random)
$order_sql = " ORDER BY RAND()";
else
$order_sql = " ORDER BY $idbez DESC";
//-->>Random
//<<--sql
//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
//<<--ausgabe
$return="";
$res = wpf_db($sql.$search_sql.$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 = "t_".$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];
$file = $customdir_files."/".$folder."/t_".$row[12];
//->verzeichnis
$url = $site;
$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
//->Details
//<--line template
$wpf_putin[0] = $id;
$wpf_putin[1] = $name;
$wpf_putin[2] = nl2br($info);
$wpf_putin[3] = $file;
$wpf_putin[4] = $sprache;
$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;
//<-template
$templ = $customdir_templ."pic_frame_latest.htm";
$manual_templ = $customdir_templ.$template;
if( !empty($template) && file_exists($manual_templ) ) $templ = $manual_templ;
//->template
$return .= wpf_buffer($templ, $wpf_putin);
//-->line template
$i++;
}
//-->>ausgabe
if( $i==0 ) $return = $ms01;
echo $return;
}
//-->>Neueste Bilder
//<<--Galerie Autowahl
function wpf_getlatestgallery()
{
if( isset($_GET['wpf_picgroup']) )
{
$group_id = wpf_clean($_GET['wpf_picgroup']);
}
else
{
$latest = wpf_db("SELECT MAX(Pig_id) from WPF_Pic_groups where State > 0", true);
$group_id = $latest[0];
}
return $group_id;
}
//-->>Galerie Autowahl
//<<--Ausgabe mit Gruppenauswahl
function wpf_gallery($group_id="", $limit="", $langonly=false, $noecho=false, $class="")
{
global $wpf_customdir;
$customdir = $wpf_customdir."gallery/";
$customdir_templ = $customdir."templates/";
//<--gruppe
if( empty($group_id) )
{
$group_id = wpf_getlatestgallery();
}
//-->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); //gallerys
$WPF_PUTIN[2] = $name; //gallery-name
$WPF_PUTIN[3] = ''; //site x of y
$WPF_PUTIN[4] = ''; //navi
$WPF_PUTIN[5] = $class;
//
$templ = $customdir_templ."gallery_frame.htm";
$article = wpf_buffer($templ, $WPF_PUTIN);
if( !$noecho ) echo $article;
return $article;
//-->ausgabe
}
//-->>Ausgabe mit Gruppenauswahl
?>
//<<--Copyright / Info
//Andreas Fachtan
//WebProjaggt.de
//V. 22.06.2010
//-->>Copyright / Info
//<<--sprache
function nixda_meldung()
{
global $wpf_language;
if( $wpf_language=="de" )
$ms01 = "Momentan keine vorhanden";
else
$ms01 = "None exist at the moment";
$ms01 = "$ms01
";
return $ms01;
}
//-->>sprache
//<<--Download-Gruppen listen
function wpf_downloads_menu($group_id="")
{
//alias
return wpf_showdlgroups($group_id);
}
function wpf_showdlgroups($group_id="", $langonly=false)
{
//<<--sets
global $wpf_customdir;
$ms01 = nixda_meldung();
$customdir = $wpf_customdir."downloads/";
$customdir_templ = $customdir."templates/";
$tabez = "Download_groups";
$idbez = "Dog_id";
//-->>sets
//<<--sortby
global $wpf_downloads_sortby;
$sortby = $wpf_downloads_sortby;
if( $sortby == "manual" )
$sortby = "Name"; //später mal Reihenfolge
elseif( $sortby == "added" )
$sortby = $idbez." DESC"; //Id
else
$sortby ="Name"; //Name
//-->>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"]) )
{
$se = wpf_clean($_POST["wpf_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_downloadgroup']) ) $sel = wpf_clean($_GET['wpf_downloadgroup']);
//->sel
//<<--ausgabe
$return="";
$group_dropdown="";
$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 = $row[6];
$keywords = $row[7];
$log_id_creater = $row[8];
$log_id_lastedi = $row[9];
$langonly = $row[10];
//->details
//<--dropdown
if( $id == $sel ) $sele = " selected"; else $sele = "";
$group_dropdown .= '';
//-->dropdown
$i++;
}
$group_dropdown = '';
$group_dropdown = '';
//-->>ausgabe
//<--template
$wpf_putin[0] = $group_dropdown;
$templ = $customdir_templ.strtolower($tabez).".htm";
$article = wpf_buffer($templ, $wpf_putin);
$return .= str_replace("wpf.templ_pics/", $customdir_templ."wpf.templ_pics/", $article);
//-->template
if( $i==0 ) $return = $ms01;
echo $return;
return $return;
}
//-->>Download-Gruppen listen
//<<--Downloads auflisten
function wpf_downloads_list($group_id)
{
//alias
return wpf_showdownloads($limit="", $group_id);
}
function wpf_showdownloads($limit="", $group_id="", $dow_id="", $noecho=false, $download_linkonly=false, $listonly=false, $langonly=false)
{
//<<--sets
global $wpf_userip, $wpf_moddir, $wpf_customdir;
$wpframe_moddir = $wpf_moddir;
$downpath = "../../../"; //-> cms
$customdir = $wpf_customdir."downloads/";
$customdir_files = $customdir."files/";
$customdir_templ = $customdir."templates/";
$sprache = $_SESSION['wpf_language'];
$tabez = "Downloads";
$idbez = "Dow_id";
//-->>sets
//<<--sortby
global $wpf_downloads_sortby;
$sortby = $wpf_downloads_sortby;
if( $sortby == "manual" )
$sortby = "Name"; //später mal Reihenfolge
elseif( $sortby == "added" )
$sortby = $idbez." DESC"; //Id
else
$sortby ="Name"; //Name
//-->>sortby
//<<--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"]) )
{
$se = wpf_clean($_POST["wpf_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
//<-einzel-download via id-übergabe
if( !empty($dow_id) )
{
$search_sql .= " AND Dow_id='$dow_id' ";
}
//->einzel-download via id-übergabe
//<<--aufrufe
$detail = false;
//<-einzelner
if( isset($_GET["wpf_download_id"]) && $listonly==false )
{
$id = wpf_clean($_GET["wpf_download_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
//<<--nur aus gewählter gruppe
if( !empty($group_id) && !$detail )
{
$gr = wpf_clean($group_id);
$search_sql .= " AND Dog_id = '$gr' ";
}
//-->>nur aus gewählter gruppe
//<<--ausgabe
$return="";
$order_sql = " ORDER BY $sortby ";
$sql = "SELECT $idbez, Created, Edited, State, Langu, Name, Info, Keywords, Cou_id, Log_id_creater, Log_id_lastedi, State_langonly, File, Type, Linkcode 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 = $row[6];
$keywords = $row[7];
$cou_id = $row[8];
$log_id_creater = $row[9];
$log_id_lastedi = $row[10];
$langonly = $row[11];
$file = $row[12];
$file_type = $row[13];
$linkcode = $row[14];
$file_size = filesize($customdir_files.$file);
$file_size = round($file_size /1024 /1024, 2);
$dl_link = $wpframe_moddir."downloads/afile.php?wpf_download_code=".$linkcode;
$file_link = '';
$detail_link = ''; //Details
//->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
//<<--zählen
if( $detail )
{
$res = counterupdate($cou_id);
}
//-->>zählen
//<<--bild
$pic_tag = wpf_pixbox($pic_id=false, $mod_identifier="downloads", $mod_id=$id, "pic1", $disablezoom=false);
//->bild
//<--line template
$wpf_putin[0] = $id;
$wpf_putin[1] = $name;
$wpf_putin[2] = nl2br($info);
$wpf_putin[3] = $file_link;
$wpf_putin[4] = $sprache;
$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[12] = $pic_tag;
$wpf_putin[13] = $dl_link;
if( $detail )
$templ = "detail";
else
$templ = "listing";
$templ = $customdir_templ.strtolower($tabez)."_article_".$templ.".htm";
$article = wpf_buffer($templ, $wpf_putin);
if( $download_linkonly )
{
$return .= $file_link.$name."";
}
else
{
$return .= str_replace("wpf.templ_pics/", $customdir_templ."wpf.templ_pics/", $article);
}
//-->line template
$i++;
}
//-->>ausgabe
if( $noecho==false ) echo $return;
return $return;
}
//-->>Downloads auflisten
//<<--Ausgabe der Downloads mit Gruppenauswahl
function wpf_showdownloads_grouped($group_id="", $limit="", $langonly=false)
{
//<<--sprache
$ms01 = nixda_meldung();
//-->>sprache
//<--gruppe
if( isset($_GET['wpf_downloadgroup']) )
{
$group_id = wpf_clean($_GET['wpf_downloadgroup']);
}
else
{
if( empty($group_id) ) $group_id = 1;
}
//-->gruppe
if( wpf_showdlgroups($group_id, $langonly) != $ms01 ) wpf_showdownloads($limit, $group_id, "", false, false, false, $langonly);
}
function wpf_downloads($group_id="")
{
//alias
return wpf_showdownloads_grouped($group_id);
}
//-->Ausgabe der Downloads mit Gruppenauswahl
?>
//<<--Copyright / Info
//Andreas Fachtan
//WebProjaggt.de
//V. 20.01.2011
//-->>Copyright / Info
//<<--Alias
function wpf_news($limit="", $listonly=false, $langonly=false, $top=false, $noecho=false, $template=false)
{
return wpf_shownews($limit, $listonly, $langonly, false, "", $top, $noecho, $template);
}
//-->>Alias
//listonly = false -> öffnen an include-stelle
//listonly = dateiadresse(z.b. news.php) -> dort öffnen
//langonly = nur für aktive sprache
//archive = auch vergangende events anzeigen
//template = normal->false / ansonsten->datei.htm = spezielles template im custom-ordner angeben
//top = false->alle / true->nur top / "never"->alle ausser top
//groupmonth = false -> keine gruppierung / true -> gruppierung / anzahl -> maximale ausgabe
function wpf_shownews($limit="", $listonly=false, $langonly=false, $eventarchive=false, $search="", $top=false, $noecho=false, $template=false, $groupmonths=false)
{
//<<--sets
global $wpf_userip, $wpf_urldomain, $wpf_newspreview_textcut, $wpf_customdir, $wpf_newsdetail;
$downpath = "../../../"; //-> cms
$customdir = $wpf_customdir."news/";
$customdir_pics = $customdir."pic.uploads/";
$customdir_templ = $customdir."templates/";
$sprache = $_SESSION['wpf_language'];
//-->>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(Article) LIKE '%".$se."%') OR (LOWER(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("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="";
$sql_flick = "Name, Name, Name, Name, Name, Name, Marked, Marked "; //dummy
$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
$sql = "SELECT $idbez, Created, Edited, State, Langu, Name, Article, Link, Name, Keywords, Cou_id, Log_id_creater, Log_id_lastedi, State_langonly, Dow_id ".$sql_flick." FROM WPF_$tabez WHERE (State > 0) ".$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 = ''.$link."";
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[20];
//
$eventstate = $row[21];
if( $eventstate==1 )
$eventstate_text = $ms_soldout;
elseif( $eventstate==2 )
$eventstate_text = $ms_shifted;
elseif( $eventstate==3 )
$eventstate_text = $ms_canceled;
//
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 = "?";
$detail_link = $openfile.$geto.'wpf_'.$modadd.'_id='.$id.'#'.$modadd.$id;
$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);
//$res = wpf_db("SELECT Count, Last_ip FROM WPF_Counter WHERE Cou_id='$cou_id'", true);
$counter = wpf_counterstate($cou_id);
//->Infos
//<<--zählen
if( $detail )
{
$counter = wpf_updatecounter($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] = $detail_link;
$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;
//
if( $detail )
{
$templ = "detail";
}
else
{
if( $marked==1 )
$templ = "listing-top";
else
$templ = "listing";
}
$templ = strtolower($customdir_templ.$tabez."_article_".$templ.".htm");
if( (!$detail) && ($template<>false) )
{
if( @file_exists($customdir_templ.$template) )
$templ = $customdir_templ.$template;
else
echo "
Angegebenes Template nicht vorhanden!";
}
$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
function wpf_events($limit="", $listonly=false, $langonly=false, $eventarchive=false, $top=false, $noecho=false, $template=false, $groupmonths=false, $group_id=-1)
{
//<<--sets
global $wpf_language, $wpf_userip, $wpf_urldomain, $wpf_newspreview_textcut, $wpf_customdir, $wpf_eventsdetail;
$downpath = "../../../"; //-> cms
$customdir = $wpf_customdir."events/";
$customdir_pics = $customdir."pic.uploads/";
$customdir_templ = $customdir."templates/";
$sprache = $_SESSION['wpf_language'];
$eventmode = true;
//-->>sets
//<<--mode
if( $eventmode )
{
$tabez = "Events";
$idbez = "Eve_id";
}
else
{
$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(Article) LIKE '%".$se."%') OR (LOWER(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("SELECT $idbez FROM WPF_$tabez WHERE State > 0 AND $idbez = '$id'");
if( $res!=false )
{
$search_sql .= " AND $idbez = '$id'";
$detail = true;
}
}
//->einzelner
//-->>aufrufe
//<<--gruppe
if( $group_id>0 )
{
$search_sql .= " AND 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="";
if( $eventmode )
{
$sql_flick = "Elo_id, Elo_id, `Beg`, `End`, Pig_id, Vig_id, Marked, Event_state "; //DATE_SUB( ,INTERVAL 0 DAY)
if( $eventarchive==false )
{
//$tage_bis_monatsende = date("t") - date("d");
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
}
$order_sql = " ORDER BY `Beg`, `End`";
}
//<-top
if( $top==true )
$sql_flick2 = " AND Marked=1 ";
else
$sql_flick2 = "";
if( $top=="never" )
$sql_flick2 = " AND Marked<>1 ";
//->top
$sql = "SELECT $idbez, Created, Edited, State, Langu, Name, Article, Link, Name, Keywords, Cou_id, Log_id_creater, Log_id_lastedi, State_langonly, Dow_id ".$sql_flick." FROM WPF_$tabez WHERE (State > 0) ".$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 = ''.$link."";
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);
$monthecho="";
if( $eventmode )
{
$anker = "#event".$id;
$elo_id = $row[15];
$elo = wpf_db("SELECT Name, Zipcode, City, Areacode, Street FROM WPF_Event_locations WHERE Elo_id = '$elo_id'", true);
$location = $elo[0];
$plz = $elo[1];
$ort = $elo[2];
$landkreis = $elo[3];
$str = $elo[4];
$vom = wpf_ts2de($row[16]);
$bis = wpf_ts2de($row[17]);
$uhr = wpf_db("SELECT DATE_FORMAT(Beg, '%H:%i'), DATE_FORMAT(End, '%H:%i') FROM WPF_Events WHERE Eve_id=$id", true);
$vom_uhr = $uhr[0];
$bis_uhr = $uhr[1];
$pig_id = $row[18];
$vig_id = $row[19];
$wochentag = strftime('%w', strtotime($row[16]));
$wochentag = wpf_dayname($wochentag);
//<--monatsgruppierung
if( $grouped )
{
$month = strftime('%m', strtotime($row[16]));
$month_name = wpf_monthname(intval($month));
$year = strftime('%Y', strtotime($row[16]));
//<-templ
$WPF_PUTIN[0] = $month_name;
$WPF_PUTIN[1] = $year;
$templ = $customdir_templ."name_monthgroup_templ.htm";
$mtempl = wpf_buffer($templ, $wpf_putin);
//->templ
if( $month<>$monthgroup )
{
$monthgroup = $month;
if( @file_exists($downpath.$templ) )
$monthecho = $mtempl;
else
$monthecho = ''.$month_name." ".$year."
";
$monthcount = $monthcount+1;
}
}
//-->monatsgruppierung
}
$marked = $row[20];
//
$eventstate = $row[21];
$eventstate_text = wpf_eventstate($id, false, $wpf_language);
//
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 = "?";
$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);
//$res = wpf_db("SELECT Count, Last_ip FROM WPF_Counter WHERE Cou_id='$cou_id'", true);
$counter = wpf_counterstate($cou_id);
//->Infos
//<<--zählen
if( $detail )
{
//$counter = $counter+1;
//$res = wpf_db("UPDATE WPF_Counter SET Count='".($counter)."', Last_ip='$wpf_userip' WHERE Cou_id='$cou_id' AND Last_ip<>'$wpf_userip'");
$counter = wpf_updatecounter($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[21] = wpf_truncate($info, $wpf_newspreview_textcut);
$wpf_putin[22] = $wochentag;
if( $eventmode )
{
if( $landkreis<>"" )
{
if( $ort<>"" )
$ort .= " ($landkreis)";
else
$ort = $landkreis;
}
$wpf_putin[11] = $location;
$wpf_putin[12] = $vom;
$wpf_putin[13] = $bis;
$wpf_putin[14] = $plz;
$wpf_putin[15] = $ort;
$wpf_putin[16] = $street;
$wpf_putin[17] = $vom_uhr;
$wpf_putin[18] = $bis_uhr;
$wpf_putin[19] = $pig_id;
$wpf_putin[20] = $vig_id;
$wpf_putin[21] = wpf_textcut($info, $wpf_eventspreview_textcut);
$wpf_putin[22] = $wochentag;
$wpf_putin[26] = $eventstate_text;
}
$wpf_putin[23] = $marked;
$wpf_putin[24] = $bild_gross;
$wpf_putin[25] = $download;
//
if( $detail )
$templ = "detail";
else
$templ = "listing";
$templ = strtolower($customdir_templ.$tabez."_article_".$templ.".htm");
if( (!$detail) && ($template<>false) )
{
if( @file_exists($customdir_templ.$template) )
$templ = $customdir_templ.$template;
else
echo "
Angegebenes Template nicht vorhanden!";
}
$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
//<<--rss
if( !$eventmode )
{
//$rss_link = $wpf_urldomain.$customdir."rss/news.xml";
//$return .= '';
}
//-->>rss
if( !$noecho ) echo $return;
return $return;
}
//-->>events
//<<--status
function wpf_eventstate($event_id=1, $dropdown=true, $lang="de")
{
$get = wpf_db("SELECT Event_state FROM WPF_Events WHERE Eve_id='$event_id'", true);
$state = $get[0];
if( empty($state) ) $state = 0;
//
$namen_array = array("findet statt", "ausverkauft", "auf unbestimmte Zeit verschoben", "abgesagt");
$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
?>
function wpf_slider($group_id=-1, $noecho=false)
{
global $wpf_customdir;
if ($group_id > 0)
{
$sql = "SELECT Slp_id, Name, Subtitle, File, Link, Info FROM WPF_Slider WHERE Slg_id='$group_id' AND State='1' ORDER BY Position";
$res = wpf_db($sql);
if ($res != 0) foreach ($res as $row)
{
$id = $row[0];
$title = $row[1];
$subtitel = $row[2];
$link = $row[4];
//$file = '_wpframe_custom/slider/files/'.$row[3];
$info = $row[5];
$thumb = wpf_getpic_path($mod_identifier="slider", $id, $pic_identifier="pic1", true);
$pic = wpf_getpic_path($mod_identifier="slider", $id, $pic_identifier="pic1", false);
$wpf_puti[0] = $id;
$wpf_puti[1] = $title;
$wpf_puti[2] = $info;
$wpf_puti[3] = $subtitel;
$wpf_puti[4] = $link;
$wpf_puti[8] = $thumb;
$wpf_puti[9] = $pic;
//''.$title.'';
$tabs .= wpf_buffer($wpf_customdir."slider/templates/tabs.htm", $wpf_puti);
//'
';
$pics .= wpf_buffer($wpf_customdir."slider/templates/pics.htm", $wpf_puti);
}
$wpf_putin[0] = $group_id;
$wpf_putin[1] = $tabs;
$wpf_putin[2] = $pics;
$return = wpf_buffer($wpf_customdir."slider/templates/slider.htm", $wpf_putin);
}
if(!$noecho) echo $return;
return $return;
}
?>
$wpf_references_pic_width = 500;
$wpf_references_pic_height = 400;
$wpf_references_thumb_width = 100;
$wpf_references_thumb_height = 100;
?>
//<<--Copyright / Info
//Andreas Fachtan
//WebProjaggt.de
//V. 08.02.2012
//-->>Copyright / Info
function wpf_references($group_id=false, $reference_id=false, $noecho=false, $template=false, $justcount=false, $language=false, $search=false)
{
global $wpf_customdir, $wpf_references_textpreview_length;
if( $language<>false )
{
$add = " AND R.Langu='$language'";
}
if( !empty($_REQUEST['wpf_reference_group']) )
{
$group_id = wpf_clean($_REQUEST['wpf_reference_group']);
}
if( $group_id>0 || is_array($group_id) )
{
if( is_array($group_id) )
{
foreach( $group_id as $grp )
{
$groups = " OR G.Reg_id='$grp'";
}
if( !empty($groups) )
{
$add .= " AND (G.Reg_id>-1".$groups.")";
}
}
else
{
$add .= " AND (G.Reg_id='$group_id')";
}
}
else
{
$add .= " AND (G.Reg_id>-1)";
}
if( !empty($reference_id) )
{
$id = $reference_id;
}
if( !empty($_REQUEST['wpf_reference']) && empty($id) )
{
$id = wpf_clean($_REQUEST['wpf_reference']);
}
if( !empty($id) )
{
$add .= " AND (R.Ref_id='$id')";
}
if( !empty($search) && strlen($search)>2 )
{
$add .= " AND ((LOWER(R.Name) LIKE LOWER('%$search%')) OR (LOWER(R.Info) LIKE LOWER('%$search%')) OR (LOWER(R.Keywords) LIKE LOWER('%$search%')))";
}
$sql = "SELECT R.Ref_id, R.Name, R.Info, R.Keywords, R.Created, R.Edited, R.State_langonly, R.Regonly_level, R.Langu, R.Cou_id, R.Kon_id, G.Reg_id FROM WPF_References R, WPF_References_groups G, WPF_References_Referencesgroups_Lnk L WHERE (R.State > 0) AND (L.Ref_id=R.Ref_id AND L.Reg_id=G.Reg_id) ".$add." GROUP BY R.Ref_id ORDER BY R.Position, R.Name";
if( $justcount )
{
$return = wpf_db($sql, false, true);
}
else
{
$res = wpf_db($sql);
if($res!=false) foreach($res as $row)
{
if( $id==$row[0] )
{
$detailmode = true;
$counter = wpf_updatecounter($row[9]);
}
else
{
$detailmode = false;
$counter = wpf_counterstate($row[9]);
}
$pic_tag = wpf_pixbox($pic_id=false, $mod_identifier="references", $row[0], "pic1", $disablezoom=!$detail);
$pic_path = wpf_getpic_path($mod_identifier="references", $row[0], $pic_identifier="pic1", true);
$wpf_putin[0] = $row[0];
$wpf_putin[1] = $row[1];
$wpf_putin[2] = $row[2];
$wpf_putin[3] = $row[3];
$wpf_putin[4] = $counter;
$wpf_putin[5] = wpf_ts2de($row[4]);
$wpf_putin[6] = wpf_ts2de($row[5]);
$wpf_putin[7] = $pic_tag;
$wpf_putin[8] = $detailmode;
$wpf_putin[9] = $pic_path;
$wpf_putin[10] = wpf_truncate($row[2], $wpf_references_textpreview_length);
$wpf_putin[11] = nl2br($row[2]);
//<<--addons
$kon_id = $row[10];
$dog = wpf_db("SELECT Dog_id FROM WPF_References_Downloadgroups_Lnk WHERE Ref_id='$row[0]'", true); $dog = $dog[0];
$pig = wpf_db("SELECT Pig_id FROM WPF_References_Picgroups_Lnk WHERE Ref_id='$row[0]'", true); $pig = $pig[0];
$vig = wpf_db("SELECT Vig_id FROM WPF_References_Videogroups_Lnk WHERE Ref_id='$row[0]'", true); $vig = $vig[0];
$aug = wpf_db("SELECT Aug_id FROM WPF_References_Audiogroups_Lnk WHERE Ref_id='$row[0]'", true); $aug = $aug[0];
$evg = wpf_db("SELECT Evg_id FROM WPF_References_Eventgroups_Lnk WHERE Ref_id='$row[0]'", true); $evg = $evg[0];
$wpf_putin[30] = $kon_id;
if( !empty($kon_id) )
$wpf_putin[20] = wpf_address($kon_id);
else
$wpf_putin[20] = "";
$wpf_putin[31] = $dog;
if( !empty($dog) )
$wpf_putin[21] = wpf_showdownloads("", $dog, "", true);
else
$wpf_putin[21] = "";
$wpf_putin[32] = $pig;
if( !empty($pig) )
$wpf_putin[22] = wpf_pics("", $pig, "", true);
else
$wpf_putin[22] = "";
$wpf_putin[33] = $vig;
if( !empty($vig) )
$wpf_putin[23] = wpf_videos("", $vig, "", true);
else
$wpf_putin[23] = "";
$wpf_putin[34] = $aug;
if( !empty($aug) )
$wpf_putin[24] = wpf_audios("", $aug, "", false);
else
$wpf_putin[24] = "";
$wpf_putin[35] = $evg;
if( !empty($evg) )
$wpf_putin[25] = wpf_events("", false, false, false, false, true, false, false, $evg);
else
$wpf_putin[25] = "";
//-->>addons
if( $template<>false ) $templ = $template; else $templ = "references_list.htm";
$line_templ = $wpf_customdir."references/templates/".$templ;
$return .= wpf_buffer($line_templ, $wpf_putin);
}
}
if( !$noecho ) echo $return;
return $return;
}
function wpf_references_groups($group_id=false, $noecho=false, $template=false, $justcount=false, $language=false)
{
global $wpf_customdir;
if( !empty($_REQUEST['wpf_reference_group']) )
{
$group_id = wpf_clean($_REQUEST['wpf_reference_group']);
}
if( $language<>false )
{
$add = " AND Langu='$language'";
}
$sql = "SELECT Reg_id, Name, Info, Keywords, Created, Edited, State_langonly Regonly_level, Langu FROM WPF_References_groups WHERE State>0 ".$add." ORDER BY Position, Reg_id";
if( $justcount )
{
$return = wpf_db($sql, false, true);
}
else
{
$res = wpf_db($sql);
if($res!=false) foreach($res as $row)
{
$sel = ($group_id==$row[0]);
$wpf_putin[0] = $row[0];
$wpf_putin[1] = $row[1];
$wpf_putin[2] = nl2br($row[2]);
$wpf_putin[3] = $row[3];
$wpf_putin[4] = $sel;
if( $template<>false ) $templ = $template; else $templ = "references_groups_list.htm";
$line_templ = $wpf_customdir."references/templates/".$templ;
$return .= wpf_buffer($line_templ, $wpf_putin);
}
}
if( !$noecho ) echo $return;
return $return;
}
?>
//<<--Copyright / Info
//Andreas Fachtan
//WebProjaggt.de
//V. 20.04.2012
//-->>Copyright / Info
//<<--Player ausgabe
function wpf_videoplayer($autostart=false, $videofile_id="", $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_videos_player = "jplayer";
$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] = $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 = $customdir.$wpf_videos_player."/index.html";
if( @!file_exists($templ) ) $templ = $downpath.$templ; //aus showcase-iframe
$player = wpf_buffer($templ, $wpf_putin);
}
//-->templates
//<--main templ
$templ = $customdir."templates/videoplayer_frame.htm";
if( @!file_exists($templ) ) $templ = $downpath.$templ; //aus showcase-iframe
$wpf_putin[11] = $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;
$downpath = "../../../"; //-> cms
$customdir = $wpf_customdir."videos/";
//-->>sets
$groups = wpf_videogroups($group_id, true, "", "", $group_search);
$firstgroup_id = wpf_videogroups($group_id, true, "", "", $group_search, true);
if( !empty($firstgroup_id) ) $group_id = $firstgroup_id;
$list = wpf_videos("", $group_id, "", true, $top);
if( !empty($_GET['wpf_vid_id']) ) $video_id = wpf_clean($_GET['wpf_vid_id']);
if( !empty($video_id) )
{
$get = wpf_db("SELECT Embed 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($autostart, $video_id, true);
}
else
$player = "";
$wpf_putin[0] = $player;
$wpf_putin[1] = $list;
$wpf_putin[2] = $groups;
//<--player nicht anzeigen, wenn keine videos
if( $list!=false )
{
$templ = $customdir."templates/videos.htm";
$return = wpf_buffer($templ, $wpf_putin);
$return = str_replace('"'."wpf.templ_pics/", '"'.$customdir."templates/wpf.templ_pics/", $return);
}
else $return = "";
//-->player nicht anzeigen, wenn keine videos
echo $return;
return $return;
}
//-->>Video in Liste mit Gruppen und Player
//<<--Galerie Autowahl
function wpf_getlatestvideo()
{
$latest = wpf_db("SELECT MAX(Vid_id) from WPF_Videos where State > 0", true);
$id = $latest[0];
return $id;
}
//-->>Galerie Autowahl
//<<--Gruppen listen
function wpf_videogroups($group_id="", $noecho=false, $langonly=false, $dropdown=false, $search="", $return1groupid=false)
{
//<<--sets
global $wpf_customdir, $wpf_videodetail;
$customdir = $wpf_customdir."videos/";
$customdir_templ = $customdir."templates/";
$tabez = "Video_groups";
$idbez = "Vig_id";
$templ = $customdir_templ."groups.htm";
//-->>sets
//<<--sortby
global $wpf_videos_sortby;
$sortby = $wpf_videos_sortby;
if( $sortby == "manual" )
$sortby = "Position"; //später mal Reihenfolge
elseif( $sortby == "added" )
$sortby = $idbez." DESC"; //Id
else
$sortby ="Name"; //Name
//-->>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']);
//-->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 = $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';
//
if( $i==0 ) $firstid = $id;
//<--dropdown
if( $id == $sel ) $sele = " selected"; else $sele = "";
$group_dropdown .= '';
//-->dropdown
//<--normal
$group = ''.$name.'';
//<-template
$wpf_putin[0] = $group;
$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 = '';
$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($limit="", $group_id="", $vid_id="", $noecho=false, $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;
$downpath = "../../../"; //-> cms
$customdir = $wpf_customdir."videos/";
$customdir_files = $customdir."files/";
$customdir_pics = $wpf_customdir."gallery/files/wpf_video";
$customdir_templ = $customdir."templates/";
$sprache = $_SESSION['wpf_language'];
$tabez = "Videos";
$idbez = "Vid_id";
//-->>sets
//<<--sortby
global $wpf_videos_sortby;
$sortby = $wpf_videos_sortby;
if( $sortby == "manual" )
$sortby = "Position"; //später mal Reihenfolge
elseif( $sortby == "added" )
$sortby = $idbez." DESC"; //Id
else
$sortby ="Name"; //Name
//-->>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 .= '';
}
}
//->einzelner
//-->>aufrufe
//<<--nur aus gewählter gruppe
if( !empty($group_id) ) // && !$detail
{
$gr = wpf_clean($group_id);
$search_sql .= " AND Vig_id = '$gr' ";
}
//-->>nur aus gewählter gruppe
//<<--ausgabe
$order_sql = " ORDER BY $sortby"; //Langu, //Keywords, //State_langonly, AND (Embed='')
$sql = "SELECT $idbez, Created, Edited, State, Name, Name, Info, Name, Cou_id, Log_id_creater, Log_id_lastedi, Name, File, Zoom, Videofile, Link, Type, Embed FROM WPF_$tabez WHERE (State > 0) ".$search_sql." ".$limit_sql.$order_sql;
//echo $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];
$cou_id = $row[8];
$log_id_creater = $row[9];
$log_id_lastedi = $row[10];
$langonly = $row[11];
//$file = $customdir_pics.$row[12];
//$picfile = $file;
$zoom = $row[13];
$file_size = @filesize($file);
$file_size = round($file_size /1024 /1024, 3);
$video = $row[14];
$link = $row[15];
$type = $row[16];
$embed = $row[17];
//Bilder aus Pic-Tabelle auslesen
$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 = "images/nopic.jpg";
if( substr_count($pic_tag, '
';
//<-target url
if( !empty($wpf_videodetail) )
$url = $wpf_videodetail.'_'.$_SESSION['wpf_language'].'.php';
else
$url = $_SERVER['PHP_SELF'];
if( $listonly<>false && strlen($listonly)>2 ) $url = $listonly;
//->target url
//<-target manual
$target = "";
if( $iframe_target != false )
{
$url = $iframe_target;
$target = str_replace(".php", "", $iframe_target);
$lastslash = strrpos($target, "/");
if( $lastslash>0 ) $lastslash = $lastslash+1; else $lastslash = 0;
$target = substr($target, $lastslash, strlen($target));
$target = ' target="'.$target.'"';
}
//->target manual
$detail_link = ''; //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 = '
';
}
//->bild
//<<--zählen
if( $detail )
{
$counter = wpf_updatecounter($counter);
$addtempl = "_detail";
}
//-->>zählen
//<--line template
$wpf_putin[0] = $id;
$wpf_putin[1] = $name;
if( $detail )
$wpf_putin[2] = nl2br($info);
else
$wpf_putin[2] = wpf_textcut($info, 200);
$wpf_putin[3] = $file;
$wpf_putin[4] = $sprache;
$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[12] = $linkfile;
$wpf_putin[13] = $pic_tag;
$wpf_putin[14] = $linkonly;
$wpf_putin[15] = $pic_thumb;
$wpf_putin[16] = nl2br($info);
//<-template
$templ = $customdir_templ."video_frame".$addtempl.".htm";
$manual_templ = $customdir_templ.$template;
if( !empty($template) && file_exists($manual_templ) ) $templ = $manual_templ;
if($type=="swf")
$templ = $customdir_templ."showcase_swf_frame.htm";
//->template
$article = wpf_buffer($templ, $wpf_putin);
$return .= str_replace("wpf.templ_pics/", $customdir_templ."wpf.templ_pics/", $article);
//showcase etc. rückgabe
if( $iframe_target!=false )
$all[] = $article;
//-->line template
if( $i==0 ) $firstvideo = $id;
$i++;
}
//-->>ausgabe
$return .= ''; //
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; $downpath = "../../../";
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);
$templ_dir = $wpf_customdir."videos/embed_codes/";
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)
{
$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
elseif( substr_count($video, "myvideo.de")>0 )
{
$img = "wpf.templ_pics/nopic.jpg"; //fuck myvideo
}
//
return $img;
}
//-->>externes thumb
//<<--externe video-id
function wpf_video_extract_externalid($video_id, $external_video_link=false)
{
$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];
if( $external_video_link<>false ) $video = $external_video_link;
$video = str_replace('"', '', $video);
if( substr_count($video, "https://")>0 )
$pre = "https://";
else
$pre = "http://";
//youtube
if( substr_count($video, "youtube.com")>0 )
{
$url_string = parse_url($video, PHP_URL_QUERY);
parse_str($url_string, $args);
if( isset($args['v']) )
$external_id = $args['v'];
else
$external_id = false;
}
//vimeo
elseif( substr_count($video, "vimeo.com")>0 )
{
$external_id = str_replace($pre.'vimeo.com/', '', $video);
$external_id = str_replace($pre.'www.vimeo.com/', '', $external_id);
}
//myvideo
elseif( substr_count($video, "myvideo.de")>0 )
{
$external_id = str_replace($pre.'www.myvideo.de/watch/', '', $video);
}
//
return $external_id;
}
//-->>externe video-id
//<<--vimeo img
function get_vimeo_info($id, $info = 'thumbnail_medium')
{
$url = "http://vimeo.com/api/v2/video/$id.php";
if( !function_exists('curl_init') )
{
//wpf_debugmessage('CURL is not installed!', 'get_vimeo_info');
$contents = @file_get_contents($url);
$thumb = @unserialize(trim($contents));
if( !empty($thumb[0][thumbnail_small]) )
$return = $thumb[0][thumbnail_small];
else
$return = false;
}
else
{
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_TIMEOUT, 10);
$output = unserialize(curl_exec($ch));
$output = $output[0][$info];
curl_close($ch);
$return = $output;
}
return $return;
}
//-->>vimeo img
//<<----------------------------------------Alte Ausgaben - Abwärtskompatibilität-->>
//<<--Ausgabe mit Gruppenauswahl
function wpf_videos_grouped($group_id="", $limit="", $langonly=false)
{
//<<--sprache
//$ms01 = nixda_meldung();
//-->>sprache
//<--gruppe
if( isset($_GET['wpf_videogroup']) )
{
$group_id = wpf_clean($_GET['wpf_videogroup']);
}
else
{
if( empty($group_id) ) $group_id = 1;
}
//-->gruppe
wpf_videogroups($group_id, $langonly);
//if( wpf_picgroups($group_id, $langonly) != $ms01 )
wpf_videos($limit, $group_id, "", false, false, false, $langonly);
}
//-->>Ausgabe mit Gruppenauswahl
//<<--SWF-Player ausgabe
function wpf_swfplayer($autostart=false, $videofile_id="", $noecho=false, $width="", $height="", $configfile="")
{
//<<--sets
global $wpf_userip, $wpf_swfplayer_w, $wpf_swfplayer_h, $wpf_showcase_swfplayer_w, $wpf_showcase_swfplayer_h, $wpf_customdir;
$downpath = "../../../"; //-> cms
$customdir = $wpf_customdir."videos/";
//-->>sets
//<<--grösse
if( empty($width) )
{
$width = $wpf_swfplayer_w;
$height = $wpf_swfplayer_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']);
}
//-->>abzuspielendes video
//<<--video
$sql = "SELECT Videofile, Link, Cou_id FROM WPF_Videos WHERE Vid_id = '".$id."'";
$res = wpf_db($sql, true);
$video = $res[0];
$video_extern = $res[1];
$cou_id = $res[2];
//<--counter updaten
$counter = wpf_updatecounter($cou_id);
//-->counter updaten
//<--typ
if( !empty($video_extern) )
$wpf_putin[0] = $video_extern;
else
{
$wpf_putin[0] = "../files/".$video; //pfad in player vorher: flv/1.flv
if( @!file_exists($wpf_putin[0]) ) $wpf_putin[0] = "../../videos/files/".$video; //aus showcase-iframe
}
//-->typ
//<--config file
if( empty($configfile) )
$wpf_putin[1] = "configuration.xml";
else
$wpf_putin[1] = $configfile;
//-->config file
//<--aufruf aus showcase-iframe?
if( @!file_exists($customdir) )
$path = "../../videos/swfplayer/";
else
$path = $customdir."swfplayer/";
//-->aufruf aus showcase-iframe?
$wpf_putin[2] = $width;
$wpf_putin[3] = $height;
$wpf_putin[4] = $path;
$templ = $customdir."swfplayer/index.html";
if( @!file_exists($templ) ) $templ = $downpath.$templ; //aus showcase-iframe
$player = wpf_buffer($templ, $wpf_putin);
//-->>video
if( !$noecho ) echo $player;
return $player;
}
//-->>SWF-Player ausgabe
?>
//<<--Copyright / Info
//Andreas Fachtan
//WebProjaggt.de
//V. 06.05.2009
//-->>Copyright / Info
//<<--gb
function wpf_guestbook($admin_activation_needed=false, $noecho=false)
{
global $wpf_customdir;
$new_form = wpf_guestbook_new($admin_activation_needed, true, true);
$new_link = $_SERVER['php_self'].'?wpf_guestbook_new=1';
$navi = wpf_guestbook_list("", true, true);
$list = wpf_guestbook_list("", true, false);
//<<--main template
$wpf_putin[0] = $navi;
$wpf_putin[1] = $list;
$wpf_putin[2] = $new_form;
$wpf_putin[3] = $new_link;
$templ = $wpf_customdir."guestbook/templates/guestbook.htm";
$return = wpf_buffer($templ, $wpf_putin);
//-->>main template
if( !$noecho ) echo $return;
return $return;
}
//-->>gb
//<<--auflisten
function wpf_gbentrynr($entry_id)
{
//fortlaufende eintrags-nr
$nr = 0;
$sql = "SELECT Gue_id FROM WPF_Guestbook WHERE (State > 0) ORDER BY Gue_id DESC";
$ct = wpf_db($sql, false, true);
$res = wpf_db($sql);
$i=0; if($res!=false) foreach($res as $row)
{
$id = $row[0];
if( $id == $entry_id )
$nr = $ct - $i;
$i++;
}
return $nr;
}
function wpf_guestbook_list($limit="", $noecho=false, $return_navi_only=false)
{
//<<--sets
global $wpf_userip, $wpframe_moddir, $wpf_maxgbentries, $wpf_language, $wpf_maxgbentries, $wpf_customdir;
//$downpath = $wpf_downpath; //"../../../"; //-> cms
$customdir = $wpf_customdir."guestbook/";
$customdir_files = $customdir."files/";
$customdir_templ = $customdir."templates/";
$customdir_templpics = "wpf.templ_pics/";
$tabez = "Guestbook";
$idbez = "Gue_id";
//-->>sets
//<<--sprache
if( $wpf_language=="de" )
{
$ms01 = "Momentan keine vorhanden";
$ms02 = "Kommentar";
$ms03 = "Einen neuen Eintrag schreiben";
}
else
{
$ms01 = "None exist at the moment";
$ms02 = "Comment";
$ms03 = "Write a new comment";
}
$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"]) )
{
$se = wpf_clean($_POST["wpf_search"]);
$se = strtolower($se);
//$search_sql .= " AND ((LOWER(Keywords) LIKE '%".$se."%') OR (LOWER(Info) LIKE '%".$se."%') OR (LOWER(Name) LIKE '%".$se."%')) ";
$search_sql .= " AND ((LOWER(Name) LIKE '%".$se."%')) ";
}
else
$search_sql = "";
//->suche
//<<--aufrufe
$detail = false;
//<-einzelner
if( isset($_GET["wpf_guestbook_id"]) && $listonly==false )
{
$id = wpf_clean($_GET["wpf_guestbook_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
//<<--nur aus gewählter gruppe
if( !empty($group_id) && !$detail )
{
$gr = wpf_clean($group_id);
$search_sql .= " AND Grp_id = '$gr' ";
}
//-->>nur aus gewählter gruppe
//<<--interface navi
//<--uebergabe
if( isset($_POST['wpf_gbsite']) || isset($_GET['wpf_gbsite']) )
{
if( isset($_POST['wpf_gbsite']) ) $seite = wpf_clean($_POST['wpf_gbsite']);
if( isset($_GET['wpf_gbsite']) ) $seite = wpf_clean($_GET['wpf_gbsite']);
}
else
$seite = 0;
//if( $seite<1 ) $seite = 0;
$aktuelle_seite = $seite;
//-->uebergabe
//<--sets
$prose = $wpf_maxgbentries;
$start = $prose * $seite;
$endet = ($prose * $seite)+$prose;
$limit_sql = "LIMIT $start,$prose";
//-->sets
//<-seite
$res = wpf_db("SELECT ".$idbez." FROM WPF_".$tabez." WHERE (State <> '-1') ".$search_sql, false, true);
$datensaetze_anz = $res;
$seiten_max = floor($datensaetze_anz/$prose);
//if( $seite>$seiten_max ) $seite = $seiten_max;
//$aktuelle_seite = $seite;
if( $seite==$seiten_max ) $seite_vor = 0; else $seite_vor = $seite+1;
if( $seite==0 ) $seite_zruck = 0; else $seite_zruck = $seite-1;
$seite_auswahl="";
for($i=0; $i<=$seiten_max; $i++)
{
if( $i == $seite ) $sel = " selected"; else $sel = "";
$seite_auswahl .= '';
}
if($i==0) $seite_auswahl = ''; //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_templ."navi.htm";
$navi = wpf_buffer($templ, $WPF_PUTIN);
//->template
//-->>interface navi
//<<--ausgabe
$return="";
$order_sql = " ORDER BY Created DESC ";
$sql = "SELECT $idbez, Created, Edited, State, Langu, Name, Log_id_creater, Log_id_lastedi, Article, Link, Email, Email_news, Email_pub, Comment, Place FROM WPF_$tabez WHERE (State > 0) ".$search_sql." ".$order_sql.$limit_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];
$log_id_creater = $row[6];
$log_id_lastedi = $row[7];
$info = $row[8];
$link = $row[9];
$email = $row[10];
$email_news = $row[11];
$email_pub = $row[12];
$comment = $row[13];
$place = $row[14];
if( empty($place) ) $place = "?";
if( !empty($comment) ) $comment = "$ms02:
".$comment."
";
/*
$keywords = $row[9];
$cou_id = $row[10];
$langonly = $row[11];
$bild = $row[12];
*/
if( !empty($email) )
{
if( $email_pub == 0 )
$email = '
';
else
$email = '
';
}
if( !empty($link) )
{
$link = '
';
}
$detail_link = ''; //Details
//
$nr = wpf_gbentrynr($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
//<<--zählen
/*
if( $detail )
{
$counter = $counter+1;
$res = wpf_db("UPDATE WPF_Counter SET Count='".($counter)."', Last_ip='$wpf_userip' WHERE Cou_id='$cou_id' AND Last_ip<>'$wpf_userip'");
}
*/
//-->>zählen
//Uhrzeit
$uhr = wpf_db("SELECT DATE_FORMAT(Created, '%H:%i') FROM WPF_Guestbook WHERE Gue_id=$id", true); $uhr = $uhr[0];
//<--line template
$wpf_putin[0] = $id;
$wpf_putin[1] = $name;
$wpf_putin[2] = nl2br($info);
$wpf_putin[3] = $created.", ".$uhr;
$wpf_putin[4] = $email;
$wpf_putin[5] = $link;
$wpf_putin[6] = $place;
$wpf_putin[7] = $info;
$wpf_putin[8] = nl2br($comment);
$wpf_putin[9] = $nr;
//
if( $detail ) $templ = "detail";
else $templ = "listing";
$templ = $customdir_templ.$templ.".htm";
$article = wpf_buffer($templ, $wpf_putin);
//
//if( $i<=$wpf_maxgbentries )
$return .= $article;
//-->line template
$i++;
}
//-->>ausgabe
if( $i==0 ) $return = $ms01;
if( $return_navi_only ) $return = $navi;
if( $noecho==false ) echo $return;
return $return;
}
//-->>auflisten
//<<--neu
function wpf_guestbook_new($admin_activation_needed=false, $always_on_top=false, $noecho=false)
{
//<--sets
$return = "";
global $wpfcdir, $wpf_ip, $wpf_date_de, $wpf_language, $wpf_captchaforms, $wpf_informadmin_onnewentry, $wpf_adminmail, $wpf_gbentryactivation, $wpf_customdir;
$tabez = "Guestbook";
$idbez = "Gue_id";
$customdir = $wpf_customdir."guestbook/";//$wpfcdir."guestbook/";
$customdir_templ = $customdir."templates/";
//
if( isset($_GET['wpf_guestbook_new']) || ($always_on_top) )
$showform = true;
else
$showform = false;
//-->sets
//<<--sprache
if( $wpf_language=="de" )
{
$ms01 = "Einen neuen Eintrag schreiben";
$ms02 = "Ihr Eintrag wurde bereits gespeichert. Danke!";
$ms03 = "Bitte Name, Kommentarfeld und evtl. korrekte E-Mail eingeben!";
$ms04 = "Ihr Eintrag wurde erfolgreich gespeichert. Vielen Dank!";
$ms05 = "Vorschau";
$ms06 = "AntiSpam stop!";
$ms07 = "Ihr Eintrag wurde erfolgreich gespeichert. Dieser wird nach Überprüfung vom Systemverwalter freigeschalten!";
$ms_antispam_code = "Antispam-Code fehlerhaft!";
}
else
{
$ms01 = "Make a new entry";
$ms02 = "Your entry has already been saved. Thanks!";
$ms03 = "Please enter Name, Commentar and poss. correct Email!";
$ms04 = "Your entry has been saved. Thanks a lot!";
$ms05 = "Preview";
$ms06 = "AntiSpam stop!";
$ms07 = "Your entry has been saved. It will be activated after the system-admin has verified it!";
$ms_antispam_code = "Wrong Antispam-code!";
}
//-->>sprache
//<-captcha
$captcha = wpf_captcha(); //captcha form
//->captcha
//<--eingaben
if( isset($_POST['name']) )
{
$showform = true;
//<<--captcha
if($wpf_captchaforms) $captcha_ok = wpf_captchacheck(); else $captcha_ok = true;
//-->>captcha
//<-felder
$name = wpf_clean($_POST['name']);
$email = wpf_clean($_POST['email']);
$place = wpf_clean($_POST['place']);
$info = wpf_clean($_POST['info']);
$link = wpf_clean($_POST['link']);
if( !empty($link) && substr_count($link, "http://")<1 ) $link = "http://".$link;
$email_news = wpf_clean($_POST['email_news']);
$email_pub = wpf_clean($_POST['email_pub']);
$bild = "";
if( empty($email_news) ) $email_news = 0;
if( empty($email_pub) ) $email_pub = 0;
$ip = $wpf_ip;
//->felder
/*//<-spam?!
if( !isset($_SESSION['wpf_guestbook_count']) ) $_SESSION['wpf_guestbook_count'] = 1;
$res = wpf_db("SELECT Name FROM WPF_Guestbook WHERE Ip='$ip' AND State<>'-1' AND (DATE_SUB(CURDATE(),INTERVAL 0 DAY) < Created)", false, true);
if( $res>=2 || $_SESSION['wpf_guestbook_count']>2 ) $spam = true; else $spam = false;
if( $spam )
{
$return = "$ms06
";
$showform = false;
}
//->spam?!*/
//<-eintrag
if( !$spam )
{
$ok=false;
if( empty($email) || (!empty($email) && wpf_checkmail($email)) ) $mailok = true; else $mailok = false;
if( strlen($name)>2 && strlen($info)>2 && $mailok && $captcha_ok ) $ok = true;
if( !empty($_POST['preview']) )
{
//preview
$return = "".$ms05.'';
}
else
{
if( $ok )
{
$showform = false;
$res = wpf_db("SELECT Name FROM WPF_Guestbook WHERE Name='$name' AND Article='$info' AND State<>'-1' AND Ip='$wpf_ip'", false, true);
if( $res==0 )
{
//admin muss freischalten?!
if( $wpf_gbentryactivation )
{
$return = "$ms07
";
$status = 0;
}
else
{
$return = "$ms04
";
$status = 1;
}
if( $wpf_informadmin_onnewentry )
{
wpf_sendmail($wpf_adminmail, "Neuer GB-Eintrag", "Neuer Eintrag von $name ($email):
".$info);
}
$res = wpf_db("INSERT INTO WPF_$tabez (Created, Edited, State, Name, Article, Log_id_creater, Log_id_lastedi,Email, Email_news, Link, Place, Email_pub, Ip)
VALUES (NOW(), NOW(), '$status', '$name', '$info', 0, 0, '$email', '$email_news', '$link', '$place', '$email_pub', '$ip')");
$_SESSION['wpf_guestbook_count'] = $_SESSION['wpf_guestbook_count']+1;
//<-flash
include("edit_createflashtml.php");
createflashtml($customdir, "");
//->flash
}
else
$return = "$ms02
"; //Doppelposting!
}
else
{
if( !$captcha_ok ) $add = "
$ms_antispam_code"; else $add = ""; //captcha
$return = "$ms03 $add
"; //Falsch
}
}
}
//->eintrag
}
//-->eingaben
//<--templ
$templ = $customdir_templ."new.htm";
$wpf_putin[0] = $name;
$wpf_putin[1] = $email;
$wpf_putin[2] = $link;
$wpf_putin[3] = $info;
$article = wpf_buffer($templ, $wpf_putin);
if( $showform )
{
$article = str_replace($customdir_templpics, $customdir_templ.$customdir_templpics, $article);
//captcha
if( $wpf_captchaforms )
$article = str_replace("[WPF_CAPTCHA]", $captcha, $article);
else
$article = str_replace("[WPF_CAPTCHA]", "", $article);
//
$return .= $article;
}
else
{
if( $show_newentry_link )
$return .= ''.$ms01.'
'; //Neuer Eintrag
else
$return .= '';
}
//-->templ
if( $noecho==false ) echo $return;
return $return;
}
//-->>neu
?>
//<<--Copyright / Info
//Andreas Fachtan
//WebProjaggt.de
//V. 01.08.2008
//-->>Copyright / Info
//<<--Auslesen
function wpf_showcase($product_id="", $event_id="", $gallery_group_id="", $video_group_id="", $noecho=false)
{
//<<--sets
global $wpf_customdir;
$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_frame.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_customdir."showcase/zooms/showcase_zoom.php", "showcase_video_frame.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_customdir."showcase/zooms/showcase_zoom.php", "showcase_pic_frame.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_customdir."showcase/zooms/showcase_zoom.php", "showcase_video_frame.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_customdir."showcase/zooms/showcase_zoom.php", "showcase_pic_frame.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_customdir."showcase/zooms/showcase_zoom.php", "showcase_video_frame.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 = $customdir."templates/";
$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_customdir."videos/templates/".$customdir_templ, $wpf_customdir."videos/templates/", $return);
$return = str_replace($wpf_customdir."gallery/templates/".$customdir_templ, $wpf_customdir."gallery/templates/", $return);
//->doppelte pfade entfernen
if( !$noecho) echo $return;
}
else $return = "";
//-->Template
return $return;
}
//-->>Auslesen
?>