//<<--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 = true; //htaccess rewrite engine (z.B. test.html anstatt test_de.php)
$wpf_dontuse_mobilemode = true; //mobilmode
$wpf_phptags_active = true; //[PHP][/PHP] in seiteninhalten erlaubt (Sicherheitsrisiko - aus Userübergaben entfernen!)
$wpf_phptags_maxlength = 50; //erlaubte Zeichenanzahl für Anweisungen (um aus Sicherheitsgründen komplexe Abfragen (z.B. DB) zu verhindern)
//<<--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
//<<--Theme
$wpf_theme = "reim";
//<<--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
$modul_sites_count = 99;
$modul_sites_parts = 99;
$wpf_basesiteedit = false; //false = nur Abschnitte, true = Seitenkopf als normalen Abschnitt behandeln (z.B. wenn keine Abscnhittüberschriften benötigt werden)
$wpf_parthumbsize_w = 980; //Thumb Breite
$wpf_parthumbsize_h = 0; //Thumb Höhe
$wpf_partzoomsize_w = 1000; //max. Breite
$wpf_partzoomsize_h = 0; //max. Hoehe (standard:0 -> inaktiv)
$wpf_sendpicfuncs = false; //Sendto
$wpf_partpreview_textcut = 200; //Vorschau - Infotext-Abschnitt (Zeichen)
$wpf_paragraphs_stillshowallinshortviewmode = false; //wenn vorschau aktiviert und paragraph abgeklickt... normal nur aktiven anzeigen (false)
$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)
$sites_sitesearch_textpreview_length = 450;
$sites_sitesearch_autosearch_list_limit = 10;
$wpf_sitesearch_result_modtarget_references = "portfolio_".$wpf_language.".php"; //result link target 4 search (just add like $wpf_sitesearch_result_modtarget_XXX)
$wpf_sitepics_thumbsize_h = 0;
$wpf_sitepics_thumbsize_w = 980;
$wpf_sitepics_zoomsize_h = 0;
$wpf_sitepics_zoomsize_w = 1200;
//<<--Contacts
$wpf_contacts_thumbsize_h = 0;
$wpf_contacts_thumbsize_w = 400;
$wpf_contacts_zoomsize_h = 200;
$wpf_contacts_zoomsize_w = 160;
$wpf_contact_antispam_retries = 10;
$wpf_contacts_ajaxsave = false;
//<<--Community
$wpf_community_userpic_thumb = 80;
$wpf_community_userpic_pic_h = 400;
$wpf_community_userpic_pic_w = 200;
//<<--Newsletter
$wpf_newsletterpic_w = 400; //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
$wpf_guestbook_ajaxsave = false;
//<<--Gallery
$wpf_gallery_thumbsize_h = 0;
$wpf_gallery_thumbsize_w = 800;
$wpf_gallery_zoomsize_h = 0;
$wpf_gallery_zoomsize_w = 980;
$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_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 = true; //System-Sammelgruppen der Module ausblenden?
$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
$wpf_pics_sortby = "manual";
$wpf_gallery_detail_link = "gallery"; //detail target link
//<<--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_downloads_thumbsize_h = 0;
$wpf_downloads_thumbsize_w = 800;
$wpf_downloads_zoomsize_h = 0;
$wpf_downloads_zoomsize_w = 980;
$wpf_downloads_sortby = "manual"; //Sortierung der Bilder: "name" = alphabetisch, "added" = nach anlegereihenfolge, "manual" = manuelle reihenfolge
$wpf_downloads_detail_link = "downloads"; //detail target link
//<<--Showcase
$wpf_showcase_videoplayer_w = 560;
$wpf_showcase_videoplayer_h = 315;
//<<--Videos
$wpf_videos_thumbsize_h = 0;
$wpf_videos_thumbsize_w = 600;
$wpf_videos_zoomsize_h = 0;
$wpf_videos_zoomsize_w = 980;
$wpf_videoplayer_w = 650; //Interner Player
$wpf_videoplayer_h = 400;
$wpf_videoplayer_embed_w = 650; //Externe Player
$wpf_videoplayer_embed_h = 400;
$wpf_videos_sortby = "manual"; //Sortierung der Bilder: "name" = alphabetisch, "added" = nach anlegereihenfolge, "manual" = manuelle reihenfolge
$wpf_videos_groups_sortby = "manual";
$wpf_videos_detail_link = "videos"; //detail target link
//<<--Audio
$wpf_audio_sortby = "manual"; //Sortierung der Bilder: "name" = alphabetisch,"added" = nach anlegereihenfolge, "manual" = manuelle reihenfolge
$wpf_audio_groups_sortby = "manual";
$wpf_audio_thumbsize_h = 0;
$wpf_audio_thumbsize_w = 600;
$wpf_audio_zoomsize_h = 0;
$wpf_audio_zoomsize_w = 980;
$wpf_audio_groups_thumbsize_h = 0;
$wpf_audio_groups_thumbsize_w = 600;
$wpf_audio_groups_zoomsize_h = 0;
$wpf_audio_groups_zoomsize_w = 980;
$wpf_audio_hidepaths = true;
//<<--News
$wpf_news_thumbsize_h = 0;
$wpf_news_thumbsize_w = 980;
$wpf_news_zoomsize_h = 0;
$wpf_news_zoomsize_w = 1000;
$wpf_newspreview_textcut = 300; //Vorschau - Infotext-Abschnitt (Zeichen)
$wpf_news_detail_link = "news"; //detail target link
//<<--Events
$wpf_events_thumbsize_h = 0;
$wpf_events_thumbsize_w = 980;
$wpf_events_zoomsize_h = 0;
$wpf_events_zoomsize_w = 1000;
$wpf_eventspreview_textcut = 400; //Vorschau - Infotext-Abschnitt (Zeichen)
$wpf_events_detail_link = "events"; //detail target link
//<<--References
$wpf_references_textpreview_length = 150;
$wpf_references_thumbsize_h = 0;
$wpf_references_thumbsize_w = 650;
$wpf_references_zoomsize_h = 0;
$wpf_references_zoomsize_w = 980;
$wpf_references_distributors_thumbsize_h = 0;
$wpf_references_distributors_thumbsize_w = 100;
$wpf_references_distributors_zoomsize_h = 0;
$wpf_references_distributors_zoomsize_w = 980;
$wpf_references_manufacturers_thumbsize_h = -1;
$wpf_references_manufacturers_thumbsize_w = 300;
$wpf_references_manufacturers_zoomsize_h = 500;
$wpf_references_manufacturers_zoomsize_w = 0;
$wpf_references_sortby = "manual";
$wpf_references_groups_sortby = "manual";
$wpf_references_detail_link = "portfolio"; //detail target link
//<<--Slider
$wpf_slider_thumbsize_h = 0;
$wpf_slider_thumbsize_w = 650;
$wpf_slider_zoomsize_h = 0;
$wpf_slider_zoomsize_w = 980;
$wpf_slider_sortby = "manual";
//<<--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 = "ssl/reim/"; //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 = true; //htaccess rewrite engine (z.B. test.html anstatt test_de.php)
$wpf_dontuse_mobilemode = true; //mobilmode
$wpf_phptags_active = true; //[PHP][/PHP] in seiteninhalten erlaubt (Sicherheitsrisiko - aus Userübergaben entfernen!)
$wpf_phptags_maxlength = 50; //erlaubte Zeichenanzahl für Anweisungen (um aus Sicherheitsgründen komplexe Abfragen (z.B. DB) zu verhindern)
//<<--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
//<<--Theme
$wpf_theme = "reim";
//<<--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
$modul_sites_count = 99;
$modul_sites_parts = 99;
$wpf_basesiteedit = false; //false = nur Abschnitte, true = Seitenkopf als normalen Abschnitt behandeln (z.B. wenn keine Abscnhittüberschriften benötigt werden)
$wpf_parthumbsize_w = 980; //Thumb Breite
$wpf_parthumbsize_h = 0; //Thumb Höhe
$wpf_partzoomsize_w = 1000; //max. Breite
$wpf_partzoomsize_h = 0; //max. Hoehe (standard:0 -> inaktiv)
$wpf_sendpicfuncs = false; //Sendto
$wpf_partpreview_textcut = 200; //Vorschau - Infotext-Abschnitt (Zeichen)
$wpf_paragraphs_stillshowallinshortviewmode = false; //wenn vorschau aktiviert und paragraph abgeklickt... normal nur aktiven anzeigen (false)
$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)
$sites_sitesearch_textpreview_length = 450;
$sites_sitesearch_autosearch_list_limit = 10;
$wpf_sitesearch_result_modtarget_references = "portfolio_".$wpf_language.".php"; //result link target 4 search (just add like $wpf_sitesearch_result_modtarget_XXX)
$wpf_sitepics_thumbsize_h = 0;
$wpf_sitepics_thumbsize_w = 980;
$wpf_sitepics_zoomsize_h = 0;
$wpf_sitepics_zoomsize_w = 1200;
//<<--Contacts
$wpf_contacts_thumbsize_h = 0;
$wpf_contacts_thumbsize_w = 400;
$wpf_contacts_zoomsize_h = 200;
$wpf_contacts_zoomsize_w = 160;
$wpf_contact_antispam_retries = 10;
$wpf_contacts_ajaxsave = false;
//<<--Community
$wpf_community_userpic_thumb = 80;
$wpf_community_userpic_pic_h = 400;
$wpf_community_userpic_pic_w = 200;
//<<--Newsletter
$wpf_newsletterpic_w = 400; //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
$wpf_guestbook_ajaxsave = false;
//<<--Gallery
$wpf_gallery_thumbsize_h = 0;
$wpf_gallery_thumbsize_w = 800;
$wpf_gallery_zoomsize_h = 0;
$wpf_gallery_zoomsize_w = 980;
$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_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 = true; //System-Sammelgruppen der Module ausblenden?
$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
$wpf_pics_sortby = "manual";
$wpf_gallery_detail_link = "gallery"; //detail target link
//<<--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_downloads_thumbsize_h = 0;
$wpf_downloads_thumbsize_w = 800;
$wpf_downloads_zoomsize_h = 0;
$wpf_downloads_zoomsize_w = 980;
$wpf_downloads_sortby = "manual"; //Sortierung der Bilder: "name" = alphabetisch, "added" = nach anlegereihenfolge, "manual" = manuelle reihenfolge
$wpf_downloads_detail_link = "downloads"; //detail target link
//<<--Showcase
$wpf_showcase_videoplayer_w = 560;
$wpf_showcase_videoplayer_h = 315;
//<<--Videos
$wpf_videos_thumbsize_h = 0;
$wpf_videos_thumbsize_w = 600;
$wpf_videos_zoomsize_h = 0;
$wpf_videos_zoomsize_w = 980;
$wpf_videoplayer_w = 650; //Interner Player
$wpf_videoplayer_h = 400;
$wpf_videoplayer_embed_w = 650; //Externe Player
$wpf_videoplayer_embed_h = 400;
$wpf_videos_sortby = "manual"; //Sortierung der Bilder: "name" = alphabetisch, "added" = nach anlegereihenfolge, "manual" = manuelle reihenfolge
$wpf_videos_groups_sortby = "manual";
$wpf_videos_detail_link = "videos"; //detail target link
//<<--Audio
$wpf_audio_sortby = "manual"; //Sortierung der Bilder: "name" = alphabetisch,"added" = nach anlegereihenfolge, "manual" = manuelle reihenfolge
$wpf_audio_groups_sortby = "manual";
$wpf_audio_thumbsize_h = 0;
$wpf_audio_thumbsize_w = 600;
$wpf_audio_zoomsize_h = 0;
$wpf_audio_zoomsize_w = 980;
$wpf_audio_groups_thumbsize_h = 0;
$wpf_audio_groups_thumbsize_w = 600;
$wpf_audio_groups_zoomsize_h = 0;
$wpf_audio_groups_zoomsize_w = 980;
$wpf_audio_hidepaths = true;
//<<--News
$wpf_news_thumbsize_h = 0;
$wpf_news_thumbsize_w = 980;
$wpf_news_zoomsize_h = 0;
$wpf_news_zoomsize_w = 1000;
$wpf_newspreview_textcut = 300; //Vorschau - Infotext-Abschnitt (Zeichen)
$wpf_news_detail_link = "news"; //detail target link
//<<--Events
$wpf_events_thumbsize_h = 0;
$wpf_events_thumbsize_w = 980;
$wpf_events_zoomsize_h = 0;
$wpf_events_zoomsize_w = 1000;
$wpf_eventspreview_textcut = 400; //Vorschau - Infotext-Abschnitt (Zeichen)
$wpf_events_detail_link = "events"; //detail target link
//<<--References
$wpf_references_textpreview_length = 150;
$wpf_references_thumbsize_h = 0;
$wpf_references_thumbsize_w = 650;
$wpf_references_zoomsize_h = 0;
$wpf_references_zoomsize_w = 980;
$wpf_references_distributors_thumbsize_h = 0;
$wpf_references_distributors_thumbsize_w = 100;
$wpf_references_distributors_zoomsize_h = 0;
$wpf_references_distributors_zoomsize_w = 980;
$wpf_references_manufacturers_thumbsize_h = -1;
$wpf_references_manufacturers_thumbsize_w = 300;
$wpf_references_manufacturers_zoomsize_h = 500;
$wpf_references_manufacturers_zoomsize_w = 0;
$wpf_references_sortby = "manual";
$wpf_references_groups_sortby = "manual";
$wpf_references_detail_link = "portfolio"; //detail target link
//<<--Slider
$wpf_slider_thumbsize_h = 0;
$wpf_slider_thumbsize_w = 650;
$wpf_slider_zoomsize_h = 0;
$wpf_slider_zoomsize_w = 980;
$wpf_slider_sortby = "manual";
//<<--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 = "ssl/reim/"; //pfad ggfls. manuell setzen (falls pfad, inkl slash am ende!) || bei keinem unterordner = " " setzen!
?>
//License
$wpf_licence_name = "SEMMEL CONCERTS Bayreuth";
$wpf_licence_pass = "s3mm3l";
$wpf_adminmail = "online@semmel.de";
//Db-login
$wpf_dbhost = "localhost";
$wpf_dbuser = "1_semmel";
$wpf_dbpass = "semwp12";
$wpf_dbname = "1_kondolenzbuch";
//Ftp-login
$wpf_ftphost = "web3.semmel.de";
$wpf_ftpuser = "fb@semmel.de";
$wpf_ftppass = "s3mm3l";
$wpf_ftproot = "";
?>
//License
$wpf_licence_name = "SEMMEL CONCERTS Bayreuth";
$wpf_licence_pass = "s3mm3l";
$wpf_adminmail = "online@semmel.de";
//Db-login
$wpf_dbhost = "localhost";
$wpf_dbuser = "1_semmel";
$wpf_dbpass = "semwp12";
$wpf_dbname = "1_kondolenzbuch";
//Ftp-login
$wpf_ftphost = "web3.semmel.de";
$wpf_ftpuser = "fb@semmel.de";
$wpf_ftppass = "s3mm3l";
$wpf_ftproot = "";
?>
//<<--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)
{
global $wpf_soundcloud_client_id;
if( empty($wpf_soundcloud_client_id) ) $wpf_soundcloud_client_id = "b66807c553aeb65dd92196a10ba98ea0";
$return = json_decode(file_get_contents("http://api.soundcloud.com/resolve?client_id=".$wpf_soundcloud_client_id."&format=json&url=".$url), true);
//print_r($return);
return $return;
}
function wpf_embed_soundcloud($url, $noecho=true)
{
global $wpf_customdir, $wpf_templatedir;
$track = wpf_embed_soundcloud_data($url);
if( $track[id]<>'' && $track[id]<>false )
{
$putin[1] = $track[id];
$putin[2] = 'Ftracks'; //Fplaylists
$return = wpf_buffer($wpf_templatedir."embedding/soundcloud.htm", $putin);
if( !$noecho ) echo $return;
}
else
{
$return = false;
}
return $return;
}
//-->>soundcloud
?>
function wpf_slider($group_id=-1, $noecho=false)
{
global $wpf_customdir, $wpf_templatedir;
if ($group_id > 0)
{
$sql = "SELECT Slp_id, Name, Subtitle, File, Link, Info, Evg_id, Vid_id 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];
$subtitle = $row[2];
$link = $row[4];
$info = $row[5];
$reference = $row[6];
$video = $row[7];
if( $reference>0 )
{
//Änderung für WuF, falls Zuordnung, dann das Billboard extern von Semmel-DB laden
//$thumb = wpf_getpic_path($mod_identifier="references", $reference, $pic_identifier="pic1", true);
//$pic = wpf_getpic_path($mod_identifier="references", $reference, $pic_identifier="pic1", false);
$res = wpf_db_external("select P.File_original, G.Folder from WPF_Pics P, WPF_Pic_groups G, WPF_Event_groups_Picgroups_Lnk L, WPF_Event_groups EG where P.Pig_id = G.Pig_id and L.Pig_id = G.Pig_id AND L.Evg_id = EG.Evg_id AND EG.Evg_id = ".$reference." and P.Keywords = 'BILLBOARD'", true);
$thumb = 'http://www.semmel.de/_wpframe_custom/gallery/files/'.$res[1].$res[0];
$pic = 'http://www.semmel.de/_wpframe_custom/gallery/files/'.$res[1].$res[0];
$get = wpf_db_external("SELECT Name, Info, FROM WPF_Event_groups WHERE Evg_id='$reference'", true);
$title = $row[0];
if( empty($info) ) $info = nl2br($row[1]);
if( empty($subtitle) ) $subtitle = $row[2];
//Zusätzlich noch direkten Ticketlink auslesen für Eventim-Eventreihe
$tic = wpf_db_external("SELECT E.Link FROM WPF_Events E, WPF_Event_locations L WHERE E.Elo_id = L.Elo_id AND Evg_id = '$reference' AND (E.Ueberregional_Nachname = 'Wykrota' OR L.City LIKE '%Köln%' ) GROUP BY E.Evg_id", true);
$eventim_expl = explode('$',$tic[0]);
$ticketlink = $eventim_expl[0];
}
if( $video>0 )
{
$get = wpf_db("SELECT Name, Info, Embed FROM WPF_Videos WHERE Vid_id='$video'", true);
$title = $get[0];
if( empty($info) ) $info = nl2br($get[1]);
$subtitle = "";
$pic = wpf_videoplayer($video, $autostart=false, true);
$thumb = wpf_getpic_path($mod_identifier="videos", $video, $pic_identifier="pic1", true);
if( empty($thumb) && !empty($get[2]) ) $thumb = wpf_video_get_externalthumb($video);
}
if( $video<1 && $reference<1 && empty($thumb) )
{
$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] = $subtitle;
$wpf_puti[4] = $link;
$wpf_puti[8] = $thumb;
$wpf_puti[9] = $pic;
$wpf_puti[10] = $reference;
$wpf_puti[11] = $video;
$wpf_puti[12] = $ticketlink;
//'
'.$title.' ';
$tabs .= wpf_buffer($wpf_templatedir."slider/tabs.htm", $wpf_puti);
//' ';
$pics .= wpf_buffer($wpf_templatedir."slider/pics.htm", $wpf_puti);
}
$wpf_putin[0] = $group_id;
$wpf_putin[1] = $tabs;
$wpf_putin[2] = $pics;
$return = wpf_buffer($wpf_templatedir."slider/slider.htm", $wpf_putin);
}
if(!$noecho) echo $return;
return $return;
}
?>
//<<--Copyright / Info
//Andreas Fachtan
//WebProjaggt.de
//V. 22.06.2010
//-->>Copyright / Info
//<<--Ausgabe der Downloads mit Gruppenauswahl
function wpf_showdownloads_grouped($group_id="", $limit="", $langonly=false, $noecho=false)
{
//<--gruppe
if( isset($_GET['wpf_downloadgroup']) )
{
$group_id = wpf_clean($_GET['wpf_downloadgroup']);
}
else
{
if( empty($group_id) ) $group_id = 1;
}
//-->gruppe
$groups = wpf_downloads_groups($group_id, true);
$list = wpf_downloads($group_id, "", true, false, false, $langonly);
if( !$noecho ) echo $groups.$list;
return $groups.$list;
}
//-->Ausgabe der Downloads mit Gruppenauswahl
//<<--Download-Gruppen listen
function wpf_downloads_groups($group_id="", $noecho=false, $template=false, $dropdown=false, $langonly=false) //alias
{
//<<--sets
global $wpf_customdir, $wpf_templatedir;
$customdir = $wpf_customdir."downloads/";
$customdir_templ = $wpf_templatedir."downloads/";
$tabez = "Download_groups";
$idbez = "Dog_id";
include( wpf_mod_language("_cms") );
//-->>sets
//<<--template
if( $template && !empty($template) )
$templ = $customdir_templ.$template;
else
$templ = $customdir_templ."downloads_groups_listing.htm";
//-->>template
//<<--sortby
$sortby = wpf_cms_sortby("downloads", "Dog_id");
//-->>sortby
//<<--nur für login-level x?!
$loginlevel = wpf_getloginlevel($_SESSION['wpf_login_id']);
$limit_sql = " AND Regonly_level<=".$loginlevel;
//-->>nur für login-level x?!
//<<--nur in aktiver sprache?!
if( $langonly )
{
$limit_sql .= " AND Langu='$sprache' ";
}
//-->>nur in aktiver sprache?!
//<-suche
if( isset($_POST["wpf_search"]) )
{
$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
//<-selected
if( !empty($group_id) ) $sel = $group_id;
if( !empty($_GET['wpf_downloads_group']) ) $sel = wpf_clean($_GET['wpf_downloads_group']);
if( empty($sel) ) $sel = wpf_downloads_groups_getfirst();
//->selected
//<<--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
//<--template
if( $sel==$id ) $selected = true; else $selected = false;
$wpf_putin[0] = $id;
$wpf_putin[1] = $name;
$wpf_putin[2] = $info;
$wpf_putin[3] = $keywords;
$wpf_putin[4] = wpf_ts2de($created);
$wpf_putin[51] = $selected;
if( @file_exists($templ) )
$article = wpf_buffer($templ, $wpf_putin);
else
wpf_debugmessage($s_cms_frontend_templatemissing.$template, $sender="wpf_downloads_groups", $forceshow=true, $level=1);
$return .= str_replace("wpf.templ_pics/", $wpf_templatedir."downloads/wpf.templ_pics/", $article);
//-->template
//<--dropdown
if( $id == $sel ) $sele = " selected"; else $sele = "";
$group_dropdown .= ''.$name.' ';
//-->dropdown
$i++;
}
//-->>ausgabe
//<<--dropdown
if( $dropdown )
{
$group_dropdown = ''.$group_dropdown.' ';
$group_dropdown = '';
$return = $dropdown;
}
//-->>dropdown
//if( $i==0 ) $return = $ms01;
if(!$noecho) echo $return;
return $return;
}
//-->>Download-Gruppen listen
//<<--Downloads auflisten
function wpf_downloads($group_id="", $dow_id="", $noecho=false, $limit=false, $download_linkonly=false, $listonly=false, $langonly=false, $top=false)
{
global $wpf_userip, $wpf_moddir, $wpf_customdir, $wpf_templatedir, $wpf_downpath;
//<<--sets
$wpframe_moddir = $wpf_moddir;
$downpath = $wpf_downpath; //-> cms
$customdir = $wpf_customdir."downloads/";
$customdir_files = $customdir."files/";
$customdir_templ = $wpf_templatedir."downloads/";
$sprache = $_SESSION['wpf_language'];
$tabez = "Downloads";
$idbez = "Dow_id";
//-->>sets
//<<--sortby
$sortby = wpf_cms_sortby("downloads", "Dow_id");
//-->>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($_GET['wpf_downloads_group']) ) $group_id = wpf_clean($_GET['wpf_downloads_group']);
if( !empty($group_id) && !$detail )
{
$gr = wpf_clean($group_id);
$search_sql .= " AND Dog_id = '$gr' ";
}
//-->>nur aus gewählter gruppe
//<<--top
if( $top )
{
$search_sql .= " AND Marked = '1' ";
}
//-->>top
//<<--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 )
{
$counter = counterupdate($cou_id);
}
else
{
$counter = wpf_counterstate($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] = $file_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 = "details";
else
$templ = "listing";
$templ = $customdir_templ.strtolower($tabez)."_".$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 ) echo $return;
return $return;
}
//-->>Downloads auflisten
//<<--Auto Autowahl
function wpf_downloads_getlatest()
{
$latest = wpf_db("SELECT MAX(Dow_id) from WPF_Downloads where State > 0", true);
$id = $latest[0];
return $id;
}
function wpf_downloads_groups_getfirst()
{
$sortby = wpf_cms_sortby("download_groups", "Dog_id");
$latest = wpf_db("SELECT Dog_id from WPF_Download_groups where State > 0 ORDER BY ".$sortby, true);
$group_id = $latest[0];
return $group_id;
}
//-->>Auto Autowahl
?>
//<<--Copyright / Info
//Andreas Fachtan
//WebProjaggt.de
//V. 20.01.2011
//-->>Copyright / Info
//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_news_arrows($news_id=false)
{
//<<--sets
global $wpf_userip, $wpf_urldomain, $wpf_newspreview_textcut, $wpf_customdir, $wpf_newsdetail, $wpf_downpath, $wpf_templatedir;
$downpath = $wpf_downpath; //-> cms
$customdir = $wpf_customdir."news/";
$customdir_pics = $customdir."pic.uploads/";
$customdir_templ = $wpf_templatedir."news/";
$sprache = $_SESSION['wpf_language'];
include( wpf_mod_language("_cms") );
//-->>sets
if ($_GET['wpf_news_id']>1)
$news_id=$_GET['wpf_news_id'];
if ($news_id<1)
{
$sql = "SELECT MAX(New_id) FROM WPF_News WHERE State='1'";
$res = wpf_db($sql, true);
$news_id = $res[0];
}
$sql = "SELECT Released, Name FROM WPF_News WHERE New_id='$news_id'";
$res = wpf_db($sql, true);
$current = $res[0];
$sql = "SELECT New_id FROM WPF_News WHERE State=1 AND Released>'$current' and Released cms
$customdir = $wpf_customdir."news/";
$customdir_pics = $customdir."pic.uploads/";
$customdir_templ = $wpf_templatedir."news/";
$sprache = $_SESSION['wpf_language'];
include( wpf_mod_language("_cms") );
//-->>sets
if ($_GET['wpf_news_id']>1)
$news_id=$_GET['wpf_news_id'];
if ($news_id<1)
{
$sql = "SELECT MAX(New_id) FROM WPF_News WHERE State='1'";
$res = wpf_db($sql, true);
$news_id = $res[0];
}
$sql = "SELECT Released, Name, Released FROM WPF_News WHERE State='1' AND New_id='$news_id' ".$sql_flick2 ."";
$res = wpf_db($sql, true);
$current = $res[0];
$current_name = $res[1];
$current_date = wpf_ts2de($res[2]);
if ($showall)
{
$sql = "SELECT New_id, Name, Released FROM WPF_News WHERE State='1' ORDER BY Released";
$res = wpf_db($sql);
if ($res!=false) foreach ($res as $row)
$article .= ''.wpf_ts2de($row[2]).' ';
}
else
{
$sql = "SELECT New_id, Name, Released FROM WPF_News WHERE State='1' AND Released > '$current' and Released'.wpf_ts2de($row[2]).'';
$i++;
}
$limit = 6-$i;
$a=0;
$sql = "SELECT New_id, Name, Released FROM WPF_News WHERE State='1' AND Released < '$current' ORDER BY Released LIMIT $limit";
$res = wpf_db($sql);
if ($res!=false) foreach ($res as $row)
{
$article2 .= ''.wpf_ts2de($row[2]).' ';
$i++;
$a++;
}
if ($i<6)
{
$limit = 6-$a;
$sql = "SELECT New_id, Name, Released FROM WPF_News WHERE State='1' AND Released > '$current' and Released'.wpf_ts2de($row[2]).'';
$i++;
}
}
$article = $article2.''.$current_date.' '.$article;
}
return $article;
}*/
function wpf_news_menu ($news_id=false, $showall=false)
{
//<<--sets
global $wpf_userip, $wpf_urldomain, $wpf_newspreview_textcut, $wpf_customdir, $wpf_newsdetail, $wpf_downpath, $wpf_templatedir;
$downpath = $wpf_downpath; //-> cms
$customdir = $wpf_customdir."news/";
$customdir_pics = $customdir."pic.uploads/";
$customdir_templ = $wpf_templatedir."news/";
$sprache = $_SESSION['wpf_language'];
include( wpf_mod_language("_cms") );
//-->>sets
if ($_GET['wpf_news_id']>1)
$news_id=$_GET['wpf_news_id'];
if ($news_id<1)
{
$sql = "SELECT MAX(New_id) FROM WPF_News WHERE State='1'";
$res = wpf_db($sql, true);
$news_id = $res[0];
}
$sql = "SELECT Released, Name, Released FROM WPF_News WHERE State='1' AND New_id='$news_id' ".$sql_flick2 ."";
$res = wpf_db($sql, true);
$current = $res[0];
$current_name = $res[1];
$current_date = wpf_ts2de($res[2]);
if ($showall)
{
$sql = "SELECT New_id, Name, Released FROM WPF_News WHERE State='1' ORDER BY Released";
$res = wpf_db($sql);
if ($res!=false) foreach ($res as $row)
$article .= ''.wpf_ts2de($row[2]).' ';
}
else
{
//$article .= ''.wpf_ts2de($row[2]).' ';
$sql = "SELECT New_id, Name, Released FROM WPF_News WHERE State='1' ORDER BY Released";
$res = wpf_db($sql);
$i=0;
$a=0;
$marker=-1;
if ($res!=false) foreach ($res as $row)
{
if ($news_id==$row[0])
{
$marker = $a;
$fields[$a][$i] = ''.$current_date.' ';
}
else
$fields[$a][$i] .= ''.wpf_ts2de($row[2]).' ';
$targets[$a][$i] = $_SERVER['PHP_SELF'].'?wpf_news_id='.$row[0];
$i++;
if ($i==7) { $i=0; $a++; };
}
}
if ($marker>0)
$return = '<< ';
foreach ($fields[$marker] as $field)
{
$return .= $field;
}
if ($a>$marker)
$return .= '>> ';
return $return;
}
function wpf_news_write_comment($news_id=false)
{
//<<--sets
global $wpf_userip, $wpf_urldomain, $wpf_newspreview_textcut, $wpf_customdir, $wpf_newsdetail, $wpf_downpath, $wpf_templatedir;
$downpath = $wpf_downpath; //-> cms
$customdir = $wpf_customdir."news/";
$customdir_pics = $customdir."pic.uploads/";
$customdir_templ = $wpf_templatedir."news/";
$sprache = $_SESSION['wpf_language'];
include( wpf_mod_language("_cms") );
//-->>sets
if ($_POST['new_id']>0)
$news_id = $_POST['new_id'];
else
{
if ($_GET['wpf_news_id']>1)
$news_id = $_GET['wpf_news_id'];
}
//Newstitle&Date
$sql = "SELECT Name, Released FROM WPF_News WHERE State='1' AND New_id='$news_id'";
$res = wpf_db($sql, true);
$news_title = $res[0];
$news_date = $res[1];
$news_date = wpf_ts2de($news_date);
$wpf_putin[0] = $news_title;
$wpf_putin[1] = $news_date;
$templ = strtolower($customdir_templ."news_article_comments_head.htm");
$article = wpf_buffer($templ, $wpf_putin);
$wpf_putin[0] = "";
$wpf_putin[1] = "";
if ($_POST['action']=="insert")
{
$id = $_POST['new_id'];
$name = $_POST['name'];
$emai = $_POST['email'];
$info = $_POST['info'];
$ok = true;
if ($id<1)
$ok = false;
if (empty($name) || empty($info))
{
$ok = false;
$mess = "Bitte alle Pflichtfelder ausfüllen. Danke!";
}
if ($ok)
{
$sql = "INSERT INTO WPF_News_comments (Name, Email, Info, Created, New_id, State) VALUES ('$name', '$email', '$info', NOW(), '$id', 1)";
$res = wpf_db($sql);
/*$mess = "Vielen Dank für deinen Kommentar";*/
header("LOCATION: news_de__kommentare.php?wpf_news_id=$id");
}
}
if (!empty($mess))
$wpf_putin[0] = $mess;
$templ = strtolower($customdir_templ."news_article_comments_form.htm");
$article .= wpf_buffer($templ, $wpf_putin);
return $article;
}
function wpf_news_comments($news_id=false, $justcount=false)
{
//<<--sets
global $wpf_userip, $wpf_urldomain, $wpf_newspreview_textcut, $wpf_customdir, $wpf_newsdetail, $wpf_downpath, $wpf_templatedir;
$downpath = $wpf_downpath; //-> cms
$customdir = $wpf_customdir."news/";
$customdir_pics = $customdir."pic.uploads/";
$customdir_templ = $wpf_templatedir."news/";
$sprache = $_SESSION['wpf_language'];
include( wpf_mod_language("_cms") );
//-->>sets
if ($_GET['wpf_news_id']>1)
$news_id=$_GET['wpf_news_id'];
if ($news_id>0)
{
//Newstitle&Date
$sql = "SELECT Name, Released FROM WPF_News WHERE State='1' AND New_id='$news_id'";
$res = wpf_db($sql, true);
$news_title = $res[0];
$news_date = $res[1];
$news_date = wpf_ts2de($news_date);
$wpf_putin[0] = $news_title;
$wpf_putin[1] = $news_date;
$templ = strtolower($customdir_templ."news_article_comments_head.htm");
$article = wpf_buffer($templ, $wpf_putin);
//Button
if (!$justcount)
{
if ($_SESSION['fan'])
$button = 'Kommentar schreiben ';
else
$button = "";
}
//Kommentare
$sql = "SELECT New_id, Name, Info, Email, Created FROM WPF_News_comments WHERE State='1' AND New_id='$news_id'";
$res = wpf_db($sql);
if ($res!=false) foreach ($res as $row)
{
$id = $row[0];
$name = $row[1];
$info = nl2br($row[2]);
$email = $row[3];
$created = wpf_ts2de($row[4]);
$wpf_putin[0] = $id;
$wpf_putin[1] = $name;
$wpf_putin[2] = $info;
$wpf_putin[3] = $email;
$wpf_putin[4] = $created;
$templ = strtolower($customdir_templ."news_article_comments.htm");
$article .= wpf_buffer($templ, $wpf_putin);
}
if ($justcount)
return count($res);
else
return $article.$button;
}
}
function wpf_news($group_id=false, $news_id=false, $noecho=false, $top=false, $limit="", $template=false, $search="", $groupmonths=false, $listonly=false, $langonly=false)
{
//<<--sets
global $wpf_userip, $wpf_urldomain, $wpf_newspreview_textcut, $wpf_customdir, $wpf_newsdetail, $wpf_downpath, $wpf_templatedir;
$downpath = $wpf_downpath; //-> cms
$customdir = $wpf_customdir."news/";
$customdir_pics = $customdir."pic.uploads/";
$customdir_templ = $wpf_templatedir."news/";
$sprache = $_SESSION['wpf_language'];
include( wpf_mod_language("_cms") );
//-->>sets
//<<--sprache
global $wpf_language;
if( $wpf_language=="de" )
{
$ms01 = "Momentan keine vorhanden";
$ms_soldout = "ausverkauft";
$ms_shifted = "verschoben";
$ms_canceled = "abgesagt";
}
else
{
$ms01 = "None exist at the moment";
$ms_soldout = "sold out";
$ms_shifted = "shifted";
$ms_canceled = "canceled";
}
//-->>sprache
//<<--mode
$tabez = "News";
$idbez = "New_id";
$modadd = strtolower($tabez);
//-->>mode
//<<--nur in aktiver sprache?!
if( $langonly )
{
$limit_sql = " AND Langu='$sprache' ";
}
else
$limit_sql = "";
//-->>nur in aktiver sprache?!
//<<--nur für login-level x?!
$loginlevel = wpf_getloginlevel($_SESSION['wpf_login_id']);
$limit_sql .= " AND Regonly_level<=".$loginlevel;
//-->>nur für login-level x?!
//<<--limit
if( !empty($limit) )
{
$limit = wpf_clean($limit);
if( is_numeric($limit) ) $limit_sql2 = " LIMIT $limit";
}
else
$limit_sql2 = "";
//-->>limit
//<-suche
if( isset($_POST["wpf_search"]) || isset($_GET["wpf_search"]) || !empty($search) )
{
if( isset($_POST["wpf_search"]) )
$se = wpf_clean($_POST["wpf_search"]);
else
$se = wpf_clean($_GET["wpf_search"]);
if( !empty($search) ) $se = $search;
$se = strtolower($se);
$search_sql .= " AND ((LOWER(Keywords) LIKE '%".$se."%') OR (LOWER(Info) LIKE '%".$se."%') OR (LOWER(Name) LIKE '%".$se."%')) ";
}
else
$search_sql = "";
//->suche
//<<--aufrufe
$detail = false;
//<-einzelner
if( isset($_GET["wpf_news_id"]) && $listonly==false )
{
$id = wpf_clean($_GET["wpf_news_id"]);
$res = wpf_db("SELECT $idbez FROM WPF_$tabez WHERE State > 0 AND $idbez = '$id'");
if( $res!=false )
{
$search_sql .= " AND $idbez = '$id'";
$detail = true;
}
}
//->einzelner
//-->>aufrufe
//<<--ausgabe
$return="";
$order_sql = " ORDER BY Created DESC ";
//<-top
if( $top )
{
if( strlen($top)>2 )
$sql_flick2 = " AND Marked<>1 ";
else
$sql_flick2 = " AND Marked=1 ";
}
else
{
$sql_flick2 = "";
}
//->top
if( $group_id>0 ) $sql_flick2 .= " AND Neg_id='$group_id'";
$sql = "SELECT $idbez, Created, Edited, State, Langu, Name, Info, Link, Name, Keywords, Cou_id, Log_id_creater, Log_id_lastedi, State_langonly, Dow_id, Marked, Neg_id, Vid_id, Released FROM WPF_$tabez WHERE (State > 0) AND Released < NOW() ".$sql_flick2.$search_sql." ".$limit_sql.$order_sql.$limit_sql2;
$res = wpf_db($sql);
$i=0; if($res!=false) foreach($res as $row)
{
//<-Details
$id = $row[0];
$created = $row[1];
$edited = $row[2];
$aktiv = $row[3];
$sprache = $row[4];
$name = $row[5];
$info = $row[6];
$link = $row[7];
$bild = $row[8];
if( !empty($link) )
$link = $row[7];
else
$link = "";
$anker = "#news".$id;
$keywords = $row[9];
$cou_id = $row[10];
$log_id_creater = $row[11];
$log_id_lastedi = $row[12];
$langonly = $row[13];
$dow_id = $row[14];
$wochentag = strftime('%w', strtotime($row[1]));
$wochentag = wpf_dayname($wochentag);
$marked = $row[15];
$group = $row[16];
$get = wpf_db("SELECT Name FROM WPF_News_groups WHERE Neg_id='$group'", true);
$group_name = $get[0];
$vid_id = $row[17];
$released = $row[18];
//
if( $listonly==false )
$openfile = $_SERVER['PHP_SELF'];
else
$openfile = wpf_clean( str_replace("http://", "", $listonly) );
if( substr_count($openfile, "?") > 0 )
$geto = "&"; //falls mit listonly bereits eine get-übergabe
else
$geto = "?";
$params = $geto.'wpf_'.$modadd.'_id='.$id.'#'.$modadd.$id;
$detail_link = $openfile.$params;
$detaillink = ''; //Details /7&wpf.template=_wpf.template_popnews
//->Details
//<-Download-Anhang
if( wpf_modactive("downloads") && !empty($dow_id) )
{
$download = wpf_showdownloads("", "", $dow_id, true, true);
}
else $download = "";
//<-Download-Anhang
//<-Infos
if( $log_id_creater==0 )
$creater = "Admin";
else
$creater = "User #".$log_id_creater;
if( $log_id_lastedi==0 )
$editor = "Admin";
else
$editor = "User #".$log_id_lastedi;
$created = wpf_ts2de($created);
$edited = wpf_ts2de($edited);
$released = wpf_ts2de($released);
//->Infos
//<<--zählen
if( $detail )
{
$counter = wpf_updatecounter($cou_id);
}
else
{
$counter = wpf_counterstate($cou_id);
}
//-->>zählen
//<<--bild
$pic_tag = wpf_pixbox($pic_id=false, $mod_identifier=$modadd, $mod_id=$id, "pic1", $disablezoom=!$detail);
//->bild
//<--line template
$wpf_putin[0] = $id;
$wpf_putin[1] = $name;
$wpf_putin[2] = $info;
$wpf_putin[3] = $link;
$wpf_putin[4] = $sprache;
$wpf_putin[5] = $keywords;
$wpf_putin[6] = $counter;
$wpf_putin[7] = $released;
$wpf_putin[8] = $creater;
$wpf_putin[9] = $pic_tag;
$wpf_putin[10] = $detaillink;
$wpf_putin[11] = $detail_link;
$wpf_putin[12] = $vid_id;
if( @function_exists("wpf_videoplayer") && $vid_id>0 ) $player = wpf_videoplayer($vid_id, false, true); else $player = "";
$wpf_putin[13] = $player;
$wpf_putin[21] = wpf_truncate($info, $wpf_newspreview_textcut);
$wpf_putin[22] = $wochentag;
$wpf_putin[23] = $marked;
$wpf_putin[24] = $bild_gross;
$wpf_putin[25] = $download;
$wpf_putin[30] = $params;
$wpf_putin[31] = $group;
$wpf_putin[32] = $group_name;
$wpf_putin[50] = wpf_links("news", $id, true, $private=false, $link_names=false);
//
if( $detail )
{
$templ = "details";
}
else
{
if( $marked==1 )
$templ = "listing-top";
else
$templ = "listing";
}
$templ = strtolower($customdir_templ.$tabez."_".$templ.".htm");
if( (!$detail) && ($template<>false) )
{
if( @file_exists($customdir_templ.$template) )
$templ = $customdir_templ.$template;
else
wpf_debugmessage($s_cms_frontend_templatemissing.$template, $sender="wpf_news", $forceshow=true, $level=1);
}
$article = wpf_buffer($templ, $wpf_putin);
if( ($grouped==false) || (($grouped==true) && ($monthcount < $groupmonths+1)) )
$return .= $monthecho.str_replace("wpf.templ_pics/", $customdir_templ."wpf.templ_pics/", $article);
//-->line template
$i++;
}
//-->>ausgabe
//if( $i==0 ) $return = ''.$ms01.'
'; //keine
if( !$noecho ) echo $return;
return $return;
}
?>
//<<--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 $res[0];
}
else
{
//kein gültiger login
if( isset($_SESSION['wpf_login_name']) )
{
wpf_logout(true);
}
return false;
}
}
function wpf_loginok()
{
//alias
return wpf_checklogin();
}
//-->>login check
//<<--register
function wpf_register($login_group_id=1, $noecho=false, $min_age=false, $syscreate=false, $mail_attachments=false) //syscreate = register wird vom system aufgerufen, um zugang automatisch zu erstellen (commununity - groups etc) - gibt login-id zurück
{
//<<--sets
global $wpf_userip, $wpf_fullurlpa, $wpframe_moddir, $wpf_captchaforms, $wpf_password_salt, $wpf_save_clearpass, $wpf_templatedir;
global $wpf_customdir, $username_has2be_email, $login_register_username_minchars, $wpf_downpath;
if( empty($login_register_username_minchars) ) $login_register_username_minchars = 4;
$downpath = $wpf_downpath; //downpath 2 wpf-root
$customdir = $wpf_customdir."logins/";
$showtempl = true;
//-->>sets
//<<--sprache
include( wpf_mod_language("logins") );
$s_logins_register_username2short = str_replace("[login_register_username_minchars]", $login_register_username_minchars, $s_logins_register_username2short);
$s_logins_register_errorminage = str_replace("[min_age]", $min_age, $s_logins_register_errorminage);
//-->>sprache
//<-captcha
if( $syscreate<>true )
{
$captcha = wpf_captcha(); //captcha form
}
//->captcha
//<<--spam-abbruch
if( !empty($_POST['name']) || !empty($_POST['email']) )
{
if( !isset($_SESSION['wpf_reg_count']) )
{
$_SESSION['wpf_reg_count'] = 1;
}
else
{
$_SESSION['wpf_reg_count'] += 1;
}
if( $_SESSION['wpf_reg_count'] > 9 )
{
$wpf_mess = $s_general_spamstop;
$showtempl = false;
$antispam_stop = true;
}
}
//-->>spam-abbruch
//<<--parameters
$parameters = wpf_clean($_REQUEST['parameters']); //reg_shops_only = registers 4 shops only
if( substr_count($parameters, "reg_shops_only")>0 ) $reg_shops_only = true;
//-->>parameters
if( $syscreate ) $wpf_mess = "";
//<<--
if( (!$antispam_stop) && (isset($_POST['name']) || isset($_POST['email'])) )
{
//<<--captcha
if($syscreate<>true && $wpf_captchaforms) $captcha_ok = wpf_captchacheck();
if($syscreate) $captcha_ok = true;
//-->>captcha
$name = wpf_clean($_POST['name']);
$email = wpf_clean($_POST['email']);
$email_confirm = wpf_clean($_POST['email_confirm']);
$firma = wpf_clean($_POST['firma']);
$anrede = wpf_clean($_POST['anrede']);
$titel = wpf_clean($_POST['titel']);
$nachname = wpf_clean($_POST['nachname']);
$vorname = wpf_clean($_POST['vorname']);
$str = wpf_clean($_POST['strasse']);
$plz = wpf_clean($_POST['plz']);
$ort = wpf_clean($_POST['ort']);
$lan_id = wpf_clean($_POST['land']);
$telefon = wpf_clean($_POST['telefon']);
$telefax = wpf_clean($_POST['telefax']);
$mobil = wpf_clean($_POST['handy']);
$agb = wpf_clean($_POST['agb']);
$birthdate_day = wpf_clean($_POST['birthdate_day']);
$birthdate_month = wpf_clean($_POST['birthdate_month']);
$birthdate_year = wpf_clean($_POST['birthdate_year']);
$birthdate = wpf_clean($_POST['birthdate']);
$user_type = wpf_clean($_POST['user_type']);
$geschlecht = wpf_clean($_POST['geschlecht']);
$email_news = wpf_clean($_POST['join_nl']);
$password = wpf_clean($_POST['password']);
$password_confirm = wpf_clean($_POST['password_confirm']);
//
$name = str_replace(' ', '', $name);
$name = strtolower($name);
$name = wpf_killuml($name);
if( !$syscreate && !$username_has2be_email )
{
$name = wpf_killspecs_html($name);
}
$email = trim($email);
//
$log_id=-1;
//
$res = wpf_db("SELECT L.Log_id, L.Name, L.Pass, L.Kon_id FROM WPF_Logins L, WPF_Login_groups G WHERE (L.Gro_id=G.Gro_id) AND (L.Name='$name' AND L.State>-1)", false, true);
if( $res>0 )
{
//login vorhanden
$wpf_mess = $s_logins_register_userexists;
}
else
{
//<--eingaben checken
//kontakt zu login erstellen? - oder nur login ohne personeninfo (dann muss user-name=email sein)
if( isset($_POST['nachname']) )
{
$addcontact = true;
}
else
{
$addcontact = false;
$email = $name;
}
//passwort
if( isset($_POST['password']) )
{
$manualpassword = true;
}
else
{
$manualpassword = false;
}
//geburtsdatum
if( !empty($birthdate_day) )
$birthdate = $birthdate_day.'.'.$birthdate_month.'.'.$birthdate_year;
//eingaben
$ok = true;
/*
if( $syscreate<>true && isset($_SESSION['wpf_reg_done']) ) //nur 1 registrierung pro session
{
$ok = false;
$wpf_mess .= $s_logins_register_done;
}
*/
if( $wpf_captchaforms && !$captcha_ok )
{
$ok = false;
$wpf_mess .= $s_general_wrongcaptcha;
}
if( $syscreate<>true && empty($agb) )
{
$ok = false;
$wpf_mess .= $s_logins_register_errorterms;
}
if( $syscreate<>true && isset($_POST['email_confirm']) && ($email<>$email_confirm) )
{
$ok = false;
$wpf_mess .= $s_logins_register_erroremailconfirm;
}
if( $syscreate<>true && isset($_POST['password_confirm']) && ($password<>$password_confirm) )
{
$ok = false;
$wpf_mess .= $s_logins_register_errorpasswordconfirm;
}
if( strlen($name)< $login_register_username_minchars )
{
$ok = false;
$wpf_mess .= $s_logins_register_username2short;
}
if( $username_has2be_email && wpf_checkmail($name)==false )
{
$ok = false;
$wpf_mess .= $s_general_usernamemustbeemail;
}
if( $addcontact && wpf_checkmail($email)==false )
{
$ok = false;
$wpf_mess .= $s_general_emailinvalid;
}
if( $addcontact && strlen($nachname)<3 )
{
$ok = false;
$wpf_mess .= $s_logins_register_errorlastname;
}
if( $addcontact==false && wpf_checkmail($name)==false )
{
$ok = false;
$wpf_mess .= $s_logins_register_errornamemustbemail;
}
if( $manualpassword && strlen($password)<6 )
{
$ok = false;
$wpf_mess .= $meldung_passwort;
}
if( $min_age<>false && wpf_age($birthdate)<$min_age )
{
$ok = false;
$wpf_mess .= $s_logins_register_errorminage;
}
//
$checkname = wpf_db("SELECT Name FROM WPF_Logins WHERE LOWER(Name)=LOWER('$name')", false, true);
if( (strlen($name)>=$login_register_username_minchars) && $checkname > 0 )
{
$ok = false;
$wpf_mess .= $s_logins_register_userexists;
}
//-->eingaben checken
//<--erstellen
if( $ok )
{
$user = 0; //Admin
$email_news = 1; //Newsletter
if( $syscreate ) $email_news = 0;
//
if( $manualpassword )
$pass = $password;
else
$pass = wpf_keygen(6); //Pass
$pass_crypted = wpf_cryptpassword($pass);
if( $wpf_save_clearpass==false ) $pass = "";
$birthdate_ts = wpf_de2dt($birthdate);
//<-Kontakt erstellen
if( $addcontact )
{
$vorhanden = wpf_db("SELECT Kon_id FROM WPF_Kontakte WHERE ((Email<>'' AND Nachname<>'') AND (Email='$email' AND Vorname='$vorname' AND Nachname='$nachname')) OR ((Plz<>'' AND Strasse<>'' AND Nachname<>'') AND (Plz='$plz' AND Strasse='$str' AND Vorname='$vorname' AND Nachname='$nachname'))", true);
if( $vorhanden[0]<>"" )
$person = $vorhanden[0];
else
$person = wpf_db("INSERT INTO WPF_Kontakte (Created, Nummer, Name, Firma, Anrede, Titel, Vorname, Nachname, Strasse, Plz, Ort, Lan_id, Telefon, Telefax, Handy, Email, Homepage, Email_news, Sms_news, Log_id_creater, Log_id_lastedi, Wpf_lock, Birthdate, Geschlecht)
VALUES (NOW(), '$nummer', '', '$firma', '$anrede', '$titel', '$vorname', '$nachname', '$strasse', '$plz', '$ort', '$lan_id', '$telefon', '$telefax', '$mobil', '$email', '$homepage', '$email_news', '0', '$user', '$user', 1, '$birthdate_ts', '$geschlecht')");
}
else
$person = "";
//->Kontakt erstellen
if( $syscreate ) $state = 1; else $state = 0;
//<-Login erstellen
//Counter
$cou_id = wpf_createcounter();
//
$gruppe = $login_group_id; $sprache="";
$res = wpf_db("INSERT INTO WPF_Logins (Created, Edited, State, Langu, Name, Log_id_creater, Log_id_lastedi, Gro_id, Kon_id, Last_login, Cou_id, Pass, Pass_crypted)
VALUES (NOW(), NOW(), '$state', '$sprache', '$name', '$user', '$user', '$gruppe', '$person', NOW(), '$cou_id', '$pass', '$pass_crypted')");
$log_id = $res;
$created = wpf_db("SELECT Created FROM WPF_Logins WHERE Log_id='".$res."'", true);
$created = $created[0];
if( $syscreate<>true )
{
//Confirmation-Link generieren
$add = "name=".$name."&stamp=".md5($created)."#wpf_confirm";
$link_direkt = $wpf_fullurlpa.$wpframe_moddir."logins/confirm.php?".$add;
$link = $wpf_fullurlpa."_wpf.modloader.php?wpf_mod=confirm&".$add;
$linka = ''.$s_logins_register_confirm.' ';
//Mail
$wpf_putin[0] = $linka;
$wpf_putin[1] = $name;
$wpf_putin[2] = $pass;
$wpf_putin[3] = $link;
$text = wpf_buffer($wpf_templatedir."logins/confirm_mail.htm", $wpf_putin);
wpf_sendmail($email, "Login", $text, $mail_attachments);
$_SESSION['wpf_reg_done'] = true;
}
//->Login erstellen
//<-Account erstellen
if( @function_exists('wpf_user') ) $com_mod_active = true; //standard
if( $com_mod_active )
{
//Counter
$cou_id = wpf_createcounter();
$res = wpf_db("INSERT INTO WPF_User_accounts (Created, Edited, State, Langu, Name, Log_id_creater, Log_id_lastedi, Cou_id, Info, Log_id, User_type)
VALUES (NOW(), NOW(), '$state', '$sprache', '$name', '$user', '$user', '$cou_id', '', $log_id, '$user_type')");
//
if( $reg_shops_only )
$param = wpf_db("UPDATE WPF_User_accounts SET Shops_user_only=1 WHERE Usa_id='$res' LIMIT 1");
}
//->Account erstellen
//
$showtempl = false;
$wpf_mess = $s_logins_register_created;
}
else
{
$wpf_mess = $s_logins_register_missing.$wpf_mess;
}
//-->erstellen
}
}
//-->>
//<<--
$geschlecht = wpf_sex($geschlecht);
$anrede = wpf_appell($_SESSION['wpf_language'], $anrede);
$land = wpf_country($_SESSION['wpf_language']); //, $lan_id
$wpf_putin[0] = $wpf_mess;
$wpf_putin[1] = $name;
$wpf_putin[2] = $email;
$wpf_putin[3] = $firma;
$wpf_putin[4] = $anrede;
$wpf_putin[5] = $titel;
$wpf_putin[6] = $nachname;
$wpf_putin[7] = $vorname;
$wpf_putin[8] = $str;
$wpf_putin[9] = $plz;
$wpf_putin[10] = $ort;
$wpf_putin[11] = $land;
$wpf_putin[12] = $telefon;
$wpf_putin[13] = $telefax;
$wpf_putin[14] = $mobil;
$wpf_putin[15] = $password;
$wpf_putin[16] = $birthdate_day;
$wpf_putin[17] = $birthdate_month;
$wpf_putin[18] = $birthdate_year;
$wpf_putin[19] = $birthdate;
$wpf_putin[20] = $geschlecht;
$wpf_putin[21] = $user_type;
$wpf_putin[22] = $parameters;
$wpf_putin[23] = $email_confirm;
//
if( $showtempl )
{
$article = wpf_buffer($wpf_templatedir."logins/register_form.htm", $wpf_putin);
//<-captcha
if( $wpf_captchaforms )
{
$article = str_replace("[WPF_CAPTCHA]", $captcha, $article);
}
//->captcha
$templ = str_replace('"'."wpf.templ_pics/", '"'.$wpf_templatedir."logins/wpf.templ_pics/", $article);
}
else $templ = $wpf_mess;
//
$_SESSION['wpf_login_register_errormessage'] = $wpf_mess;
//
if( $syscreate<>true )
{
echo $templ;
return $templ;
}
else
{
if( !empty($wpf_mess) ) wpf_debugmessage($wpf_mess, "wpf_register");
return $log_id;
}
//-->>
}
//-->>register
//<<--passwort vergessen
function wpf_password_reset($login_id)
{
global $wpf_customdir, $wpf_password_salt, $wpf_save_clearpass;
$pass = wpf_keygen(6);
$pass_crypted = wpf_cryptpassword($pass);
$return = $pass;
if( $wpf_save_clearpass==false ) $pass = "";
$res = wpf_db("UPDATE WPF_Logins L SET L.Pass_crypted='$pass_crypted', L.Pass='$pass', L.Edited=NOW(), L.Log_id_lastedi=0 WHERE L.Log_id='$login_id' LIMIT 1");
return $return;
}
function wpf_password()
{
//<<--sets
global $wpf_customdir, $wpf_password_salt, $wpf_save_clearpass, $wpf_fullurlpa, $wpf_templatedir;
$downpath = "../../../"; //downpath 2 wpf-root
$customdir = $wpf_customdir."logins/"; //Bilder
$showtempl = true;
global $wpf_userip;
//-->>sets
//<<--sprache
include( wpf_mod_language("logins") );
//-->>sprache
//<<--spam-abbruch
if( isset($_POST['name']) )
{
if( !isset($_SESSION['wpf_pw_count']) )
{
$_SESSION['wpf_pw_count'] = 1;
}
else
{
$_SESSION['wpf_pw_count'] += 1;
}
if( $_SESSION['wpf_pw_count'] > 3 )
{
$wpf_mess = $s_general_spamstop;
//$showtempl = false;
}
}
//-->>spam-abbruch
if( !empty($_GET['reset']) )
{
//Zurücksetzen Link angeklickt
$reset = wpf_clean($_GET['reset']);
$stamp = wpf_clean($_GET['stamp']);
$get = wpf_db("SELECT Edited FROM WPF_Logins WHERE Log_id='$reset'", true);
$stamp_check = md5($get[0]);
if( $stamp==$stamp_check )
{
$new = wpf_password_reset($reset);
echo $s_logins_password_reset_page_yourpassword." ".$new;
}
else
{
echo $s_logins_password_reset_page_error;
}
}
else
{
//Passwort bzw. Neusetzen-Link zusenden lassen
if( ($wpf_mess != $s_general_spamstop) && isset($_POST['name']) )
{
$name = wpf_clean($_POST['name']);
if( empty($name) )
{
$wpf_mess = $s_logins_password_fieldsmissing;
}
else
{
$res = wpf_db("SELECT L.Log_id, L.Name, L.Pass, L.Kon_id, L.Pass_crypted FROM WPF_Logins L, WPF_Login_groups G WHERE (L.Gro_id=G.Gro_id) AND (L.Name='$name' AND G.State>0 AND L.State>0)", true);
$id = $res[0];
$name = $res[1];
$pass = $res[2];
$contact = $res[3];
if( empty($id) )
{
$wpf_mess = $s_logins_password_usernotfound;
}
else
{
//übergebener Login-Name = Email
if( wpf_checkmail($name) )
{
$email = $name;
$wpf_mess = $s_logins_password_sent;
}
//email aus Kontakt zu Login
$res = wpf_db("SELECT Email, Birthdate FROM WPF_Kontakte WHERE Kon_id='$contact'", true);
$birthdate = $res[1];
if( !empty($res[0]) )
$email = $res[0];
//only crypted password exists -> create new
if( empty($pass) )
{
//kein unverschlüsseltes passwort vorhanden -> link zur neusetzung zuschicken
$set = wpf_db("UPDATE WPF_Logins SET Edited=NOW(), Log_id_lastedi=0 WHERE Log_id='$id' LIMIT 1");
$get = wpf_db("SELECT Edited FROM WPF_Logins WHERE Log_id='$id'", true);
$stamp = md5($get[0]);
$param = $id.'&stamp='.$stamp;
$lnk = ' '.$s_logins_password_reset_mail_lnktext.' ';
$text = $s_logins_password_reset_mail_text.$lnk;
wpf_sendmail($email, $s_logins_password_reset_mail_subject, $text);
$showtempl = false;
$wpf_mess = $s_logins_password_resetlinksent;
}
else
{
//unverschlüsseltes passwort vorhanden -> gleich zuschicken
$text = $s_logins_password_yourpassis." ".$pass;
wpf_sendmail($email, $s_logins_password_mail_subject, $text);
$showtempl = false;
$wpf_mess = $s_logins_password_sent;
}
}
}
}
$article = wpf_buffer($wpf_templatedir."logins/password_form.htm", $wpf_mess);
$templ = str_replace('"'."wpf.templ_pics/", '"'.$wpf_templatedir."logins/wpf.templ_pics/", $article);
echo $templ;
return $templ;
}
}
//-->>passwort vergessen
//<<--login / logout
function wpf_logout($noecho=false)
{
//<<--sprache
include( wpf_mod_language("logins") );
//-->>sprache
//<<--logout
//unset -> error
$_SESSION['wpf_login_name']="";
$_SESSION['wpf_login_pass']="";
$_SESSION['wpf_login_count']="";
$_SESSION['wpf_login_id']="";
unset($_SESSION['wpf_login_name']);
unset($_SESSION['wpf_login_pass']);
unset($_SESSION['wpf_login_count']);
unset($_SESSION['wpf_login_id']);
//@session_destroy();
//
if( isset($_COOKIE['wpf_login_name']) )
{
setcookie("wpf_login_name", "", time()-3600);
setcookie("wpf_login_pass", "", time()-3600);
}
//
if( isset($_SESSION['wpf_login_name']) )
{
if( isset($_GET['wpf_logout']) )
{
$wpf_mess = "".$s_logins_logout_out."
"; //"Logged out!";
}
}
else
{
$wpf_mess = ''.$s_logins_logout_logout_link.' ';
}
//-->>logout
if( !$noecho ) echo $wpf_mess;
return $wpf_mess;
}
function wpf_login($noecho=false, $forward2site="", $syslogin=false) //gibt true bzw. false zurück
{
//<<--sets
if( session_id()=="" ) { @session_start(); }
global $wpf_customdir, $wpf_password_salt, $wpf_templatedir, $wpf_downpath;
$downpath = $wpf_downpath; //downpath 2 wpf-root
$customdir = $wpf_customdir."logins/"; //Bilder
$showtempl = true;
$return = false;
global $wpf_userip;
//-->>sets
//<<--sprache
include( wpf_mod_language("logins") );
//-->>sprache
if( !isset($_GET['wpf_logout']) )
{
//<<--login
if( !isset($_SESSION['wpf_login_name']) )
{
if( isset($_POST['login_name']) )
{
$ok=false;
$user = wpf_clean($_POST['login_name']);
$pass = wpf_clean($_POST['login_pass']);
$pass_crypted = wpf_cryptpassword($pass); //noch unverschlüsselt (altes system) verschlüsselt (aktuell) auto-übergabe - nur verschlüsseltes vorhanden
//<-spam-abbruch
if( !$syslogin )
{
if( !isset($_SESSION['wpf_login_count']) )
{
$_SESSION['wpf_login_count'] = 1;
}
else
{
$_SESSION['wpf_login_count'] += 1;
}
if( $_SESSION['wpf_login_count'] > 5 )
{
$wpf_mess = $s_general_spamstop;
$antispam_stop = true;
//$showtempl = false;
}
}
//->spam-abbruch
//<-check
if( !$antispam_stop )
{
$res = wpf_db("SELECT L.Log_id, L.Name, MD5(L.Pass), L.Last_login, L.Pass_crypted FROM WPF_Logins L, WPF_Login_groups G WHERE (L.Gro_id=G.Gro_id) AND (L.Name='$user' AND ((L.Pass<>'' AND L.Pass='$pass') OR (L.Pass_crypted<>'' AND L.Pass_crypted='$pass_crypted') ) AND (G.State>0) AND (L.State>0))", true);
if( $res[0]!="" )
{
if( !empty($res[4]) )
$pass = $res[4];
else
$pass = $res[2];
//
$_SESSION['wpf_login_id'] = $res[0];
$_SESSION['wpf_login_name'] = $res[1];
$_SESSION['wpf_login_pass'] = $pass;
if( !empty($_POST['login_remember']) )
{
$days = time()+60*60*24*30; //30 tage
setcookie("wpf_login_name", $res[1], $days);
setcookie("wpf_login_pass", $pass, $days);
}
//<-last login
$_SESSION['wpf_login_last_beforethis'] = $res[3];
wpf_db("UPDATE WPF_Logins SET Last_login=NOW() WHERE Log_id='$res[0]'");
//->last login
$wpf_mess = $s_logins_login_loginokay;
$forward = true;
$showtempl = false;
$return = true;
}
else
{
$wpf_mess = $s_logins_login_invalid;
}
}
//->check
}
else
{
//$wpf_mess = $s_logins_login_nologin;
}
}
else
{
//...bereits eingeloggt
$wpf_mess = "";//$s_logins_login_loginokay;
$return = true;
$showtempl = false;
}
//-->>login
}
else
{
//<<--logout
$wpf_mess = wpf_logout(true);
$showtempl = true;
//-->>logout
}
//<<--template
$putin[0] = $wpf_mess;
if( $forward && strlen($forward2site)>1 ) $forwarder = wpf_siteforwarder($forward2site, true);
if( $noecho==false )
{
if( $showtempl )
{
$templ = wpf_buffer($wpf_templatedir."/logins/login_form.htm", $putin);
$templ = str_replace('"'."wpf.templ_pics/", '"'.$wpf_templatedir."logins/wpf.templ_pics/", $templ);
echo $templ;
}
else
echo $forwarder.$wpf_mess;
}
//-->>template
return $return;
}
//-->>login / logout
?>
//<<--Copyright / Info
//Andreas Fachtan
//WebProjaggt.de
//V. 20.04.2012
//-->>Copyright / Info
//<<--Player ausgabe
function wpf_videoplayer($videofile_id="", $autostart=false, $noecho=false, $width="", $height="", $configfile="")
{
//<<--sets
global $wpf_userip, $wpf_videoplayer_w, $wpf_videoplayer_h, $wpf_showcase_videoplayer_w, $wpf_showcase_videoplayer_h, $wpf_customdir, $wpf_templatedir, $wpf_downpath;
$wpf_videos_player = "jplayer";
$downpath = $wpf_downpath; //-> cms
$customdir = $wpf_customdir."videos/";
//-->>sets
//<<--grösse
if( empty($width) )
{
$width = $wpf_videoplayer_w;
$height = $wpf_videoplayer_h;
}
//-->>grösse
//<<--abzuspielendes video
if( !empty($videofile_id) )
{
$id = wpf_clean($videofile_id);
}
if( isset($_GET['wpf_video']) )
{
$id = wpf_clean($_GET['wpf_video']); //alt
}
if( isset($_GET['wpf_vid_id']) )
{
$id = wpf_clean($_GET['wpf_vid_id']);
}
if( empty($id) ) $id = wpf_getlatestvideo();
//-->>abzuspielendes video
//<<--video
if( $id>0 )
{
$sql = "SELECT Videofile, Link, Cou_id, Embed, Name, Info FROM WPF_Videos WHERE Vid_id = '".$id."'";
$res = wpf_db($sql, true);
$video = $res[0];
$video_extern = $res[1];
$cou_id = $res[2];
$embedded_player = $res[3];
$name = $res[4];
$info = $res[5];
//<--formats
$formats = wpf_db("SELECT Videofile2, Videofile3 FROM WPF_Videos WHERE Vid_id = '".$id."'", true);
$flv = $video;
$mp4 = $formats[0];
$ogv = $formats[1];
//-->formats
//<--pic
$pic = wpf_getpic_path($mod_identifier="videos", $id, $pic_identifier="pic1");
//-->pic
//<--pfad
if( !empty($flv) ) $flv = $wpf_customdir."videos/files/".$flv;
if( !empty($mp4) ) $mp4 = $wpf_customdir."videos/files/".$mp4;
if( !empty($ogv) ) $ogv = $wpf_customdir."videos/files/".$ogv;
//-->pfad
//<--counter updaten
$counter = wpf_updatecounter($cou_id);
//-->counter updaten
//<--typ
if( !empty($video_extern) )
{
$video_file = $video_extern;
}
else
{
$video_file = "../files/".$video; //pfad in player vorher: flv/1.flv
if( @!file_exists($video_file) )
{
//aus showcase-iframe
$video_file = "../../videos/files/".$video;
}
}
//-->typ
//<--config file
if( empty($configfile) )
$config = "configuration.xml";
else
$config = $configfile;
//-->config file
//<--aufruf aus showcase-iframe?
if( @!file_exists($customdir) )
$path = "../../videos/".$wpf_videos_player."/";
else
$path = $customdir.$wpf_videos_player."/";
//-->aufruf aus showcase-iframe?
//<--details
$wpf_putin[0] = $video_file;
$wpf_putin[1] = $config;
$wpf_putin[2] = $width;
$wpf_putin[3] = $height;
$wpf_putin[4] = $path;
$wpf_putin[5] = $id;
$wpf_putin[6] = $name;
$wpf_putin[7] = $info;
$wpf_putin[8] = $counter;
$wpf_putin[9] = $pic;
$wpf_putin[10] = "_wpframe/jquery/plugins_wpf/jplayer/scripts"; //$wpf_customdir."videos/";
$wpf_putin[11] = $flv;
$wpf_putin[12] = $mp4;
$wpf_putin[13] = $ogv;
//-->details
//<--templates
if( strlen($embedded_player)>1 )
{
$player = wpf_videoplayer_embed($id, true, $width, $height, $thumbclick_beforeplay=false, $thumb_width=-1, $thumb_height=-1, $external_video_link=false);
}
else
{
$templ = $wpf_templatedir."videos/".$wpf_videos_player."/jplayer.htm";
if( @!file_exists($templ) ) $templ = $downpath.$templ; //aus showcase-iframe
$player = wpf_buffer($templ, $wpf_putin);
}
//-->templates
//<--main templ
$templ = $wpf_templatedir."videos/videoplayer.htm";
if( @!file_exists($templ) ) $templ = $downpath.$templ; //aus showcase-iframe
$wpf_putin[100] = $player;
$player = wpf_buffer($templ, $wpf_putin);
//-->main templ
}
else $player = false;
//-->>video
if( !$noecho ) echo $player;
return $player;
}
//-->>Player ausgabe
//<<--Video in Liste mit Gruppen und Player
function wpf_video($autostart=true, $group_id="", $group_search="", $video_id="", $top=false)
{
//<<--sets
global $wpf_customdir, $wpf_templatedir, $wpf_downpath;
$downpath = $wpf_downpath; //-> cms
$customdir = $wpf_customdir."videos/";
//-->>sets
if( isset($_GET['wpf_videogroup']) ) $group_id = wpf_clean($_GET['wpf_videogroup']);
if( empty($group_id) )
{
$firstgroup_id = wpf_video_groups($group_id, true, false, "", "", $group_search, true);
if( !empty($firstgroup_id) ) $group_id = $firstgroup_id;
}
$groups = wpf_video_groups($group_id, true, false, "", "", $group_search);
$list = wpf_videos($group_id, "", true, false, true, false, false, false, false, false, $top);
if( !empty($_GET['wpf_vid_id']) ) $video_id = wpf_clean($_GET['wpf_vid_id']);
if( !empty($video_id) )
{
$get = wpf_db("SELECT Embed, Name, Info FROM WPF_Videos WHERE Vid_id='$video_id'", true);
if( $get[0]<>"" ) $embedded = true;
//
if( $embedded )
$player = wpf_videoplayer_embed($video_id, $noecho=true);
else
$player = wpf_videoplayer($video_id, $autostart, true);
}
else
$player = "";
$wpf_putin[0] = $group_id;
$wpf_putin[1] = $player;
$wpf_putin[2] = $list;
$wpf_putin[3] = $groups;
if( !empty($video_id) )
{
$wpf_putin[4] = $get[1];
$wpf_putin[5] = nl2br($get[2]);
$wpf_putin[6] = wpf_video_get_pic($video_id);
}
$wpf_putin[10] = $video_id;
//<--player nicht anzeigen, wenn keine videos
if( $list!=false )
{
$templ = $wpf_templatedir."videos/video_frame.htm";
$return = wpf_buffer($templ, $wpf_putin);
$return = str_replace('"'."wpf.templ_pics/", '"'.$wpf_templatedir."videos/wpf.templ_pics/", $return);
}
else $return = "";
//-->player nicht anzeigen, wenn keine videos
echo $return;
return $return;
}
//-->>Video in Liste mit Gruppen und Player
//<<--Gruppen listen
function wpf_videos_groups($group_id="", $noecho=false, $template=false)
{
return wpf_video_groups($group_id, $noecho, $template);
}
function wpf_video_groups($group_id="", $noecho=false, $template=false, $langonly=false, $dropdown=false, $search="", $return1groupid=false)
{
//<<--sets
global $wpf_customdir, $wpf_videodetail, $wpf_templatedir;
$customdir = $wpf_customdir."videos/";
$customdir_templ = $wpf_templatedir."videos/";
$tabez = "Video_groups";
$idbez = "Vig_id";
include( wpf_mod_language("_cms") );
//-->>sets
//<<--template
if( $template && !empty($template) )
$templ = $customdir_templ.$template;
else
$templ = $customdir_templ."video_groups_listing.htm";
//-->>template
//<<--sortby
$sortby = wpf_cms_sortby("videos", "Vig_id");
//-->>sortby
//<<--nur für login-level x?!
$loginlevel = wpf_getloginlevel($_SESSION['wpf_login_id']);
$limit_sql = " AND Regonly_level<=".$loginlevel;
//-->>nur für login-level x?!
//<<--nur in aktiver sprache?!
if( $langonly )
{
$limit_sql .= " AND Langu='$sprache' ";
}
//-->>nur in aktiver sprache?!
//<--suche
if( isset($_POST["wpf_search"]) || !empty($search) )
{
$se = wpf_clean($_POST["wpf_search"]);
if( !empty($search) ) $se = $search;
$se = strtolower($se);
$search_sql .= " AND ((LOWER(Keywords) LIKE '%".$se."%') OR (LOWER(Info) LIKE '%".$se."%') OR (LOWER(Name) LIKE '%".$se."%')) ";
}
else
$search_sql = "";
//-->suche
//<--sel
if( !empty($group_id) ) $sel = $group_id;
if( isset($_GET['wpf_videogroup']) ) $sel = wpf_clean($_GET['wpf_videogroup']);
if( empty($sel) ) $sel = wpf_videos_groups_getfirst();
//-->sel
//<<--ausgabe
$return="";
$group_dropdown=""; $group="";
$order_sql = " ORDER BY $sortby ";
$sql = "SELECT $idbez, Created, Edited, State, Langu, Name, Info, Keywords, Log_id_creater, Log_id_lastedi, State_langonly FROM WPF_$tabez WHERE (State > 0) ".$search_sql." ".$limit_sql.$order_sql;
$res = wpf_db($sql);
$i=0; if($res!=false) foreach($res as $row)
{
//<-details
$id = $row[0];
$created = $row[1];
$edited = $row[2];
$aktiv = $row[3];
$sprache = $row[4];
$name = $row[5];
$info = nl2br($row[6]);
$keywords = $row[7];
$log_id_creater = $row[8];
$log_id_lastedi = $row[9];
$langonly = $row[10];
//->details
//Detaillink anhand Detailvariable in Config
$openfile = $wpf_videodetail.'_'.$_SESSION['wpf_language'].'.php';
//<<--bild
$pic_tag = wpf_pixbox($pic_id=false, $mod_identifier="video_groups", $mod_id=$id, "pic1", $disablezoom=!$detail);
//->bild
//
if( $i==0 ) $firstid = $id;
//<--dropdown
if( $id == $sel ) $sele = " selected"; else $sele = "";
$group_dropdown .= ''.$name.' ';
//-->dropdown
//<--normal
if( $sel==$id ) $selected = true; else $selected = false;
$group = ''.$name.' ';
//<-template
$wpf_putin[0] = $id;
$wpf_putin[1] = $name;
$wpf_putin[2] = $info;
$wpf_putin[3] = $pic;
$wpf_putin[4] = $group;
$wpf_putin[51] = $selected;
$article = wpf_buffer($templ, $wpf_putin);
$return .= str_replace("wpf.templ_pics/", $customdir_templ."wpf.templ_pics/", $article);
//->template
//-->normal
$i++;
}
//-->>ausgabe
//<<--template - dropdown
if( $dropdown )
{
$group_dropdown = ''.$group_dropdown.' ';
$group_dropdown = '';
$wpf_putin[0] = $group_dropdown;
$article = wpf_buffer($templ, $wpf_putin);
$return .= str_replace("wpf.templ_pics/", $customdir_templ."wpf.templ_pics/", $article);
}
//-->>template - dropdown
//<<--erste gruppe zurückgeben
if( $return1groupid )
{
$return = $firstid;
$noecho = true;
}
//-->>erste gruppe zurückgeben
//if( $i==0 ) $return = $ms01;
if( !$noecho ) echo $return;
return $return;
}
//-->>Gruppen listen
//<<--Videos auflisten
//iframe_target = name der zieldatei... -> iframe name = iframe_target-file minus dateiendung (/_custom/test.php -> test)
function wpf_videos($group_id="", $vid_id="", $noecho=false, $limit="", $listonly=false, $langonly=false, $search="", $showmessages=false, $iframe_target=false, $template="", $top=false, $justreturn_firstvideo=false)
{
//<<--sets
//$ms01 = nixda_meldung();
global $wpf_userip, $wpframe_moddir, $wpf_customdir, $wpf_videodetail, $wpf_downpath, $wpf_templatedir;
$downpath = $wpf_downpath; //-> cms
$customdir = $wpf_customdir."videos/";
$customdir_files = $customdir."files/";
$customdir_templ = $wpf_templatedir."videos/";
$sprache = $_SESSION['wpf_language'];
$tabez = "Videos";
$idbez = "Vid_id";
//-->>sets
//<<--sortby
$sortby = wpf_cms_sortby("videos", "Vid_id");
//-->>sortby
//<<--sprache
global $wpf_language;
if( $wpf_language=="de" )
$ms01 = "Momentan keine vorhanden";
else
$ms01 = "None exist at the moment";
$ms01 = "$ms01
";
//-->>sprache
//<<--nur in aktiver sprache?!
if( $langonly )
{
//$limit_sql = " AND Langu='$sprache' ";
}
//-->>nur in aktiver sprache?!
//<<--nur für login-level x?!
$loginlevel = wpf_getloginlevel($_SESSION['wpf_login_id']);
$limit_sql = " AND Regonly_level<=".$loginlevel;
//-->>nur für login-level x?!
//<<--limit
if( !empty($limit) )
{
$limit = wpf_clean($limit);
if( is_int($limit) ) $limit_sql2 = " LIMIT $limit";
}
else
$limit_sql2 = "";
//-->>limit
//<-suche
if( isset($_POST["wpf_search"]) || !empty($search) )
{
$se = wpf_clean($_POST["wpf_search"]);
if( !empty($search) ) $se = $search;
$se = strtolower($se);
$search_sql .= " AND ((LOWER(Info) LIKE '%".$se."%') OR (LOWER(Name) LIKE '%".$se."%')) ";
}
else
$search_sql = "";
//->suche
//<- Top
if( $top )
$search_sql .=" AND Top = 1";
//-> Top
//<-einzeln via id-übergabe
/* if( !empty($vid_id) || isset($_GET['wpf_vid_id']) )
{
$search_sql .= " AND $idbez='$vid_id' ";
}*/
//->einzeln via id-übergabe
$return="";
//<<--aufrufe
$detail = false;
//<-einzelner
if( isset($_GET["wpf_vid_id"]) && !$listonly )
{
$id = wpf_clean($_GET["wpf_vid_id"]);
$res = wpf_db("SELECT $idbez FROM WPF_$tabez WHERE State > 0 AND $idbez = '$id'");
if( $res!=false )
{
$search_sql .= " AND $idbez = '$id'";
$detail = true;
$return .= ' ';
}
}
//->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_video_get_pic($id);
//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
//$url
$url = "media_".$wpf_language.".php";
$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 = "_details";
}
else $addtempl = "_listing";
//-->>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".$addtempl.".htm";
$manual_templ = $customdir_templ.$template;
if( !empty($template) && file_exists($manual_templ) ) $templ = $manual_templ;
//->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, $wpf_downpath, $wpf_templatedir;
$downpath = $wpf_downpath;
$templ_dir = $wpf_customdir."videos/embed_codes/";
if( isset($_GET['wpf_vid_id']) )
{
$video_id = wpf_clean($_GET['wpf_vid_id']);
}
//
$video = wpf_db("SELECT Embed, Cou_id, Name, Info, Vid_id FROM WPF_Videos WHERE State>0 AND Embed<>'' AND Vid_id = '".$video_id."'", true);
$cou_id = $res[1];
$name = $video[2];
$info = $video[3];
$id = $video[4];
$video = $video[0];
//
if( $external_video_link<>false && !empty($external_video_link) )
{
$id = -1;
$cou_id = -1;
$video = $external_video_link;
}
else $external_video_link = false;
//
$height = $wpf_videoplayer_embed_h; $width = $wpf_videoplayer_embed_w;
if( empty($height) ) { $height = 640; $width = 480; }
if( $cwidth>-1 ){ $width = $cwidth; $height = $cheight; }
//
$wpf_putin[5] = $name;
$wpf_putin[6] = $info;
//
if( !empty($id) )
{
//$counter = wpf_updatecounter($cou_id);
if( !file_exists($templ_dir."youtube.htm") ) $templ_dir = $downpath.$templ_dir; //showcase aufruf
//youtube
if( substr_count($video, "youtube.com")>0 )
{
$external_id = wpf_video_extract_externalid($video_id, $external_video_link);
$putin[0] = $external_id;
$putin[1] = $height;
$putin[2] = $width;
$putin[3] = '&enablejsapi=1&playerapiid=ytplayer'.$video_id;
$embed = wpf_buffer($templ_dir."youtube.htm", $putin);
$img = wpf_video_get_externalthumb($video_id, $external_video_link);
$type = "youtube";
}
//vimeo
elseif( substr_count($video, "vimeo.com")>0 )
{
$external_id = wpf_video_extract_externalid($video_id, $external_video_link);
$putin[0] = $external_id;
$putin[1] = $height;
$putin[2] = $width;
$putin[3] = "";
$embed = wpf_buffer($templ_dir."vimeo.htm", $putin);
$img = wpf_video_get_externalthumb($video_id, $external_video_link);
$type = "vimeo";
}
//myvideo
elseif( substr_count($video, "myvideo.de")>0 )
{
$external_id = wpf_video_extract_externalid($video_id, $external_video_link);
$putin[0] = $external_id;
$putin[1] = $height;
$putin[2] = $width;
$putin[3] = "";
$embed = wpf_buffer($templ_dir."myvideo.htm", $putin);
$img = wpf_video_get_externalthumb($video_id, $external_video_link);
$type = "myvideo";
}
//
if( empty($embed) ) wpf_debugmessage("Embedding error - invalid code?!", "wpf_embedplayer");
else
{
if( $thumbclick_beforeplay )
{
if( $thumb_height>-1 ) $size = ' width="'.$thumb_width.'" height="'.$thumb_height.'"';
//
if( $id==-1 )
{
$video_id = date("isu").rand(11, 999);
$ucount = "";
}
else
{
$ucount = 'wpf_updatecounter4video('.$video_id.');';
}
//
if( $type=="youtube" && substr_count($embed, $putin[3])>0 )
$jsadd = " ytplayer".$video_id.".playVideo();";
else
$jsadd = "";
//
$embed = ''.$embed.'
'; //video
$embed = ''.$embed; //thumb
}
//
if( !$noecho ) echo $embed;
$return = $embed;
}
}
else wpf_debugmessage("Couldn't find video or no valid Embed code!", "wpf_embedplayer");
return $return;
}
//-->>Eingebettete Player
//<<--externes thumb
function wpf_video_get_externalthumb($video_id, $external_video_link=false)
{
global $wpf_themedir;
$video = wpf_db("SELECT Embed, Cou_id, Name, Info, Vid_id FROM WPF_Videos WHERE State>0 AND Embed<>'' AND Vid_id = '".$video_id."'", true);
$video = $video[0];
$external_id = wpf_video_extract_externalid($video_id, $external_video_link);
if( $external_video_link<>false )
$video = $external_video_link;
$video = strtolower($video);
//youtube
if( substr_count($video, "youtube.com")>0 )
{
if( substr_count($video, "https://")>0 )
$pre = "https://";
else
$pre = "http://";
$img = $pre."img.youtube.com/vi/".$external_id."/default.jpg";
}
//vimeo
elseif( substr_count($video, "vimeo.com")>0 )
{
$img = get_vimeo_info($external_id);
}
//myvideo etc
elseif( substr_count($video, "myvideo.de")>0 )
{
$img = false; //fuck myvideo
}
//
return $img;
}
//-->>externes thumb
//<<--pic
function wpf_video_get_pic($id)
{
global $wpf_themedir;
$get = wpf_db("SELECT Embed FROM WPF_Videos WHERE Vid_id='$id'", true);
$embed = $get[0];
$pic_tag = wpf_pixbox($pic_id=false, $mod_identifier="videos", $mod_id=$id, "pic1", $disablezoom=true);
if( $pic_tag==false && !empty($embed) ) $pic_tag = wpf_video_get_externalthumb($id);
if( $pic_tag==false ) $pic_tag = $wpf_themedir."images/main_design/nopic.png";
if( substr_count($pic_tag, ' ';
return $pic_tag;
}
//-->>pic
//<<--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
//<<--Auto Autowahl
function wpf_getlatestvideo() //alias
{
return wpf_videos_getlatest();
}
function wpf_videos_getlatest()
{
$latest = wpf_db("SELECT MAX(Vid_id) from WPF_Videos where State > 0", true);
$id = $latest[0];
return $id;
}
function wpf_videos_groups_getfirst()
{
$sortby = wpf_cms_sortby("videos_groups", "Vig_id");
$latest = wpf_db("SELECT Vig_id from WPF_Video_groups where State > 0 ORDER BY ".$sortby, true);
$group_id = $latest[0];
return $group_id;
}
//-->>Auto Autowahl
?>
//<<--Copyright / Info
//Andreas Fachtan
//WebProjaggt.de
//V. 10.11.2011
//-->>Copyright / Info
function passkey($size)
{
$result = "";
srand((double)microtime()*1000000);
for($i=0; $i < $size; $i++)
{
$num = rand(48,120);
while (($num >= 58 && $num <= 64) || ($num >= 91 && $num <= 96))
$num = rand(48,120);
$result .= chr($num);
}
return $result;
}
//<<--search
function wpf_contactsearch($groups=false, $seperate_results=false, $noecho=false)
{
global $wpf_customdir, $wpf_downpath, $wpf_templatedir;
$templdir = $wpf_templatedir."contacts/";
//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, $wpf_templatedir;
$templdir = $wpf_templatedir."contacts/";
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, $wpf_templatedir;
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_templatedir."contacts/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, $noecho=false, $prefix="address_", $ajax_save=false, $template=false) //falls insert & best. gruppe - via editmode übergeben
{
$return = wpf_contactshow($contact_id, $template, $noecho, $editmode, $prefix);
return $return;
}
function wpf_contactshow($contact_id=1, $template=false, $noecho=true, $editmode=false, $prefix="", $ajax_save=false)
{
global $wpf_customdir, $wpf_templatedir, $wpf_loginid, $wpf_downpath;
$templ_dir = $wpf_templatedir."contacts/";
if( !@file_exists($templ_dir) ) $templ_dir = $wpf_downpath.$templ_dir;
include( wpf_mod_language("_cms") );
$_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"]);
$mobile = wpf_clean($_POST[$prefix."mobile"]);
$vat_nr = wpf_clean($_POST[$prefix."vat_nr"]);
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', Vat_nr='$vat_nr', Edited=NOW(), Log_id_lastedi='$wpf_loginid' 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, Vat_nr, Handy, Created, Log_id_creater)
VALUES ('$first', '$last', '$str', '$code', '$place', '$company', '$web', '$email', '$kog_id', '$vat_nr', '$mobile', NOW(), '$wpf_loginid')");
$_SESSION['wpf_contact_addressnew_return'] = $ins;
}
else $_SESSION['wpf_contact_addressnew_return'] = $check[0];
}
}
else
{
$_SESSION['wpf_contact_addressnew_return'] = false;
}
}
//echo "SELECT Kon_id, Langu, Nummer, Name, Firma, Anrede, Titel, Vorname, Nachname, Strasse, Plz, Ort, Lan_id, Telefon, Telefax, Handy, Email, Homepage, Notiz, Lan_id, Vat_nr FROM WPF_Kontakte WHERE (State <> '-1') AND Kon_id='$contact_id'";
$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, Vat_nr FROM WPF_Kontakte WHERE (State <> '-1') AND Kon_id='$contact_id'", true);
$id = $row[0];
if( empty($id) ) $id = -1;
$pic_tag = wpf_pixbox($pic_id=false, $mod_identifier="contacts", $mod_id=$id, "pic1", true);
$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[17] = $row[20]; //vat
$wpf_putin[18] = wpf_getpic_path($mod_identifier="contacts", $row[0], $pic_identifier="pic1", true);
$wpf_putin[19] = $pic_tag;
$wpf_putin[50] = wpf_links("contacts", $id, true, $private=false, $link_names=false);
$wpf_putin[100] = $prefix;
$wpf_putin[101] = $ajax_save; //TODO
if( $template<>false )
{
$templ = $template;
if( !file_exists($templ_dir.$template) ) wpf_debugmessage($s_cms_frontend_templatemissing.$template, $sender="wpf_address", $forceshow=true, $level=1);
}
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 : required_fields = array("vorname", "nachname")
function wpf_contact($mode="contact", $noecho=false, $template=false, $required_field=false, $mail2user=false, $recipients=false, $justcheck=false) //aufruf -> emailnews / smsnews / contact
{
global $wpf_dbuser, $wpf_dbpass, $wpf_fullurlpa, $wpframe_moddir, $wpf_captchaforms, $php_eol, $wpf_templatedir, $wpf_downpath, $wpf_customdir;
global $wpf_userip, $wpf_language, $wpf_newsletter_confirmjoin, $wpf_fullurlpa, $wpframe_moddir, $dbsupport, $wpf_contact_antispam_retries;
//<<--modus
if( $mode!="emailnews" && $mode!="smsnews" && $mode!="contact" && $mode!="videowall" && $mode!="fanbrief") $mode = "contact";
if( $mail2user==true && $mode=="smsnews" ) $mail2user = false;
if( $mode=="newsletter" ) $mode = "emailnews";
//-->>modus
//<<--sets
$downpath = $wpf_downpath; //downpath 2 wpf-root
$customdir = $wpf_customdir."contacts/"; //Bilder
$showtempl = true;
$wpf_mess="";
//-->>sets
//<--db
$dbsupport = wpf_dbactive();
//-->db
//<<--sprache
include( wpf_mod_language("contacts") );
include( wpf_mod_language("newsletter") );
//-->>sprache
//<-captcha
$captcha = wpf_captcha($mode); //captcha form
//->captcha
//<<--abgeschickt
$saved = false;
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($mode); else $captcha_ok = true;
//-->>captcha
//<<--felder
$fields = array("nummer", "firma", "anrede", "titel", "vorname", "nachname", "strasse", "plz", "ort", "land", "telefon", "telefax", "email", "homepage", "handy", "info", "join_nl", "akzeptiert");
foreach( $fields as $field )
{
${$field} = wpf_clean($_POST[$field]);
${$field."_pflicht"} = wpf_clean($_POST[$field."_mandatory"]);
//ausnahmen
if( $field=="land" )
{
$lan_id = $land;
if( empty($lan_id) ) $lan_id = 34;
}
if( $field=="email" )
{
$email = trim( strtolower($email) );
}
}
//<<--zusatzfelder
$zusatzfelder="";
for($i=1;$i<21;$i++) //bis zu 20
{
//<<--pflichtfelder
if( isset($_POST['additional_field'.$i."_mandatory"]) )
$pflicht = $_POST['additional_field'.$i."_mandatory"];
else
$pflicht = false;
if( $pflicht && empty($_POST['additional_field'.$i]) )
{
$adds_needed_fields_missing = true;
}
//-->>pflichtfelder
if( isset($_POST['additional_field'.$i]) )
{
$zus = wpf_clean($_POST['additional_field'.$i]);
$additional_field[$i] = $zus;
if( isset($_POST['additional_field'.$i."_description"]) )
$bez = wpf_clean($_POST['additional_field'.$i."_description"]).": ";
else
$bez = "";
$additional_field_description[$i] = $bez;
$additional_field_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
//<<--newsletter kategorien
$cats = wpf_clean($_POST["newsletter_categories"]);
//-->>newsletter kategorien
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)) ) // || empty($strasse) || empty($plz) || empty($ort)
$ok = false;
if( ($mode=="videowall") && (empty($vorname) || empty($email) || empty($ort) || empty($info)) )
$ok = false;
if( ($mode=="fanbrief") && (empty($vorname) || empty($nachname) || empty($email) || empty($ort) || $ort == "Headline*" || $vorname == "Vorname*" || $nachname == "Name*" || empty($info) || $info == "Textfeld*" ) )
$ok = false;
if( ($mode=="emailnews") && empty($email) )
$ok = false;
if( ($mode=="smsnews") && empty($handy) )
$ok = false;
if( $adds_needed_fields_missing )
$ok = false;
foreach($fields as $field)
{
if( empty(${$field}) && !empty(${$field."_pflicht"}) )
{
$ok = false;
}
}
if( !$captcha_ok ) $wpf_mess = $s_contacts_error_antispam_code.' '.$s_contacts_photo_error;
if( !$ok ) $wpf_mess = $s_contacts_error_general.' '.$s_contacts_photo_error;
if( $ok && !empty($email) )
{
if( wpf_checkemail($email)==false )
{
$ok = false;
$wpf_mess .= " ".$s_contacts_error_email;
}
}
//-->>fcheck
//<--check
if( $ok && $captcha_ok )
{
$showtempl = false;
//<-spam-abbruch
if( empty($wpf_contact_antispam_retries) ) $max_tries = 10; $max_tries = $wpf_contact_antispam_retries;
if( !isset($_SESSION['wpf_contact_count']) )
{
$_SESSION['wpf_contact_count'] = 1;
}
else
{
$_SESSION['wpf_contact_count'] += 1;
}
if( $_SESSION['wpf_contact_count'] > $max_tries )
{
$wpf_mess = $s_contacts_ok_received;
}
//->spam-abbruch
//<-speichern und verschicken
if( $wpf_mess != $s_contacts_ok_received )
{
if( $dbsupport )
{
$dontshowform = false;
// NL
if ( ($mode=="videowall" || $mode=="fanbrief") && !empty($_POST['nl']) )
{
$group = 101; //newslettergruppe
$nl_ok = true;
$check = wpf_db_external("SELECT Kon_id FROM WPF_Kontakte WHERE Email='$email' AND Kog_id='$group'", false, true);
if ($check>0)
$nl_ok = false;
if ($nl_ok)
{
$res = wpf_db_external("INSERT INTO WPF_Kontakte (Created, State, Vorname, Nachname, Email, Email_news, Kog_id) VALUES (NOW(), '0', '$vorname', '$nachname', '$email', '0', '$group')");
$kon_id = $res;
// Katgeorie Schlager
//alt $res2 = wpf_db_external("INSERT INTO WPF_Kontakt_Kategorien_Links (State, Kon_id, Kat_id) VALUES ('1', ".$res.", '3')");
//Kategorien
$ins = wpf_db_external("INSERT INTO WPF_Kontakt_Kategorien_Links (Kon_id, Kat_id, State) VALUES ('$kon_id', '3', '1')");
/*if( $kon_id>0 && !empty($kategorien) )
{
foreach($kategorien as $kategorie)
{
$ins = wpf_db_external("INSERT INTO WPF_Kontakt_Kategorien_Links (Kon_id, Kat_id, State) VALUES ('$kon_id', '$kategorie', '1')");
}
}*/
//Regionen
/*if( $kon_id>0 && !empty($regionen) )
{
foreach($regionen as $region)
{
$ins = wpf_db_external("INSERT INTO WPF_Kontakt_Region_Links (Kon_id, Reg_id, State) VALUES ('$kon_id', '$region', '1')");
}
}*/
//Confirm
$stamp = wpf_db_external("SELECT Created FROM WPF_Kontakte WHERE Kon_id='".$kon_id."'", true);
$stamp = md5($stamp[0]);
$link = 'http://www.semmel.de/de/verify/?email='.$email.'&stamp='.$stamp.'&kog_id='.$group; //$wpframe_moddir."newsletter/confirm.php";
$link_full = ''.$link.' ';
$wpf_putin[0] = $link_full;
$wpf_putin[1] = $link;
$btext = wpf_buffer('_wpframe_themes/reim/templates/contacts/contact_mail_semmel.htm',$wpf_putin);
//$btext = wpf_mailtemplate_paths($btext);
wpf_sendmail($email, "Newsletteranmeldung", $btext);
//$wpf_mess = 'Vielen Dank für Ihre Anmeldung! Wir haben Ihnen soeben eine Email mit Bestätigungslink zugesandt.
';
}
/*// Prüfen ob vorhanden
$sql = "SELECT Email, Kon_id FROM WPF_Kontakte WHERE Email='".$email."'";
$res = wpf_db_external($sql, true);
if (count($res)>0)
{
$kon_id=$res[1];
$nl_mess = "Hinweis: Ihre Emailadresse befindet sich bereits in unserem Newsletterverteiler.";
$sql = "UPDATE WPF_Kontakte SET Herkunft='Semino Rossi $mode' WHERE Kon_id='$kon_id'";
$res = wpf_db_external($sql);
}
else
{
// Key
$passkey = passkey(16);
$sql_key = ", Added4Newsletter, Passkey";
$sql_key_value = ", '1', '$passkey'";
// Eintrag
$herkunft_db = 'Semino Rossi '.$mode;
$res = wpf_db_external("INSERT INTO WPF_Kontakte (Created, Nummer, Name, Firma, Anrede, Titel, Vorname, Nachname, Strasse, Plz, Ort, Lan_id, Telefon, Telefax, Handy, Email, Homepage, Email_news, Sms_news".$sql_key.", Herkunft, Kuenstler_fav)
VALUES (NOW(), '$nummer', '', '$firma', '$anrede', '$titel', '$vorname', '$nachname', '$strasse', '$plz', '$ort', '$lan_id', '$telefon', '$telefax', '$mobil', '$email', '$homepage', '0', '$sms_news'".$sql_key_value.", '$herkunft_db', '$kuenstler_fav')");
// Katgeorie Schlager
$res2 = wpf_db_external("INSERT INTO WPF_Kontakt_Kategorien_Links (State, Kon_id, Kat_id) VALUES ('1', ".$res.", '3')");
// DoubleOpt Mail
$stamp = wpf_db_external("SELECT Created FROM WPF_Kontakte where Kon_id='".$res."'", true);
$stamp = $stamp[0];
$link = "http://www.semmel.de/_wpframe/_wpf.mods/contacts/verify.php";
$link = ''.$link.' ';
$wpf_putin[0] = $link;
//$btext = wpf_buffer($customdir."templates/confirmjoin_mail.htm",$wpf_putin);
$btext = wpf_buffer($wpf_templatedir."newsletter/newsletter_confirmjoin_mail.htm",$wpf_putin);
wpf_sendmail($email, "Ihre Newsletter-Anmeldung auf Semino Rossi", $btext);
}*/
}
//Videowall > Extra
if ($mode=="videowall")
{
$file = $_POST['newfile'];
$res = wpf_db("INSERT INTO WPF_Videowall (Vorname, Email, Stadt, Text, File) VALUES ('$vorname', '$email', '$ort', '$info', '$file')");
$dontshowform = true;
wpf_sendmail("m.streng@webprojaggt.de", "Neuer Eintrag für die Semino Rossi Konzertgrüße", "$name $vorname: $ort $info");
echo 'Vielen Dank '.$vorname.' für Deine Teilnahme!'.$nl_mess.'
';
}
elseif ($mode=="fanbrief")
{
$file = $_POST['newfile'];
//echo "INSERT INTO WPF_Fanbrief (Name, Vorname, Email, Headline, Info, Created, File, State) VALUES ('$nachname', '$vorname', '$email', '$ort', '$info', NOW(), '$file', '1')";
$res = wpf_db("INSERT INTO WPF_Fanbrief (Name, Vorname, Email, Headline, Info, Created, File, State, Langu) VALUES ('$nachname', '$vorname', '$email', '$ort', '$info', NOW(), '$file', '0', '".$_SESSION['wpf_language']."')");
$dontshowform = true;
wpf_sendmail("online@semmel.de", "Neuer Eintrag für das James Last Kondolenzbuch", 'Name: '.$nachname.' '.$vorname.' Haedline: '.$ort.' Nachricht: '.$info.' JETZT FREISCHALTEN ');
//wpf_sendmail("s.heinl@webprojaggt.de", "Neuer Eintrag für das James Last Kondolenzbuch", 'Name: '.$nachname.' '.$vorname.' Haedline: '.$ort.' Nachricht: '.$info.' JETZT FREISCHALTEN ');
echo ''.$s_contacts_success_info.'
';
$wpf_putin[0] = $s_contacts_success_mail;
$mailtext = wpf_buffer("_wpframe_themes/reim/templates/contacts/contact_mail.htm", $wpf_putin);
wpf_sendmail($email, $s_contacts_success_mail_subject, $mailtext);
}
else
{
/*//<-vorhanden?
if( $mode=="emailnews" ) $sql = "SELECT Email FROM WPF_Kontakte WHERE LOWER(Email)='".$email."' AND Kog_id=10 AND State<>-1";
elseif( $mode=="smsnews" ) $sql = "SELECT Handy FROM WPF_Kontakte WHERE Handy='".$handy."' AND Kog_id=10 AND State<>-1";
else $sql = "SELECT Info, IP FROM WPF_Kontakte_Anfragen WHERE Info='".$info."' AND Zusatzfelder='$zusatzfelder' AND State<>-1 AND IP='".$wpf_userip."'"; //zeitlich noch eingrenzen!!
$res = wpf_db($sql, false, true);
if( $res==0 )
{
//<-save
//email + sms news
if( $mode=="emailnews" || $mode=="smsnews" )
{
if( empty($nachname) )
{
if( $mode=="emailnews" )
$nachname = $email;
else
$nachname = $sms;
}
//mark
if( $mode=="emailnews" )
$added4 = 1;
else
$added4 = 0;
//erst via mail-link bestätigen
if( ($mode=="emailnews") && ($wpf_newsletter_confirmjoin) )
{
$confirm = true;
$email_news=0;
}
else
{
$confirm = false;
$email_news=1;
}
//newsletter
$res = wpf_db("INSERT INTO WPF_Kontakte (Created, State, Nummer, Name, Firma, Anrede, Titel, Vorname, Nachname, Strasse, Plz, Ort, Lan_id, Telefon, Telefax, Handy, Email, Homepage, Email_news, Sms_news, Added4Newsletter, Kog_id)
VALUES (NOW(), 1, '$nummer', '', '$firma', '$anrede', '$titel', '$vorname', '$nachname', '$strasse', '$plz', '$ort', '$lan_id', '$telefon', '$telefax', '$handy', '$email', '$homepage', '$email_news', '$sms_news', '$added4', 10)");
$kon_id = $res;
//kategorien
if( $kon_id>0 && !empty($cats) )
{
foreach($cats as $cat)
{
$ins = wpf_db("INSERT INTO WPF_Kontakt_Kategorien_Links (Kon_id, Kat_id) VALUES ('$kon_id', '$cat')");
}
}
//erst via mail-link bestätigen
if( $confirm )
{
$stamp = wpf_db("SELECT Created FROM WPF_Kontakte WHERE Kon_id='".$res."'", true);
$stamp = md5($stamp[0]);
$link = $wpf_fullurlpa."_wpf.modloader.php?wpf_mod=confirm_newsletter";//$wpframe_moddir."newsletter/confirm.php";
$link = ''.$link.' ';
$wpf_putin[0] = $link;
$btext = wpf_buffer($wpf_templatedir."newsletter/newsletter_confirmjoin_mail.htm",$wpf_putin);
wpf_sendmail($email, $s_newsletter_mail_subject, $btext);
}
}
else
{
//contact form
//kontakt vorhanden? -> verwenden!
if( !empty($nachname) && !empty($strasse) && !empty($plz) && !empty($email) )
{
$res = wpf_db("SELECT Kon_id FROM WPF_Kontakte WHERE (Kog_id='2') AND ((Nachname='$nachname' AND Strasse='$strasse' AND Plz='$plz') OR (Nachname='$nachname' AND Plz='$plz' AND Email='$email'))", true);
if( !empty($res[0]) ) $kon_id = $res[0];
}
//nicht vorhanden->anlegen
if( !isset($kon_id) )
{
$res = wpf_db("INSERT INTO WPF_Kontakte (Created, Nummer, Name, Firma, Anrede, Titel, Vorname, Nachname, Strasse, Plz, Ort, Lan_id, Telefon, Telefax, Handy, Email, Homepage, Email_news, Sms_news, State, Kog_id)
VALUES (NOW(), '$nummer', '', '$firma', '$anrede', '$titel', '$vorname', '$nachname', '$strasse', '$plz', '$ort', '$lan_id', '$telefon', '$telefax', '$handy', '$email', '$homepage', '$email_news', '$sms_news', 1, 2)");
$kon_id = $res;
}
//anfrage
if( $kon_id>0 ) // && (!empty($info) || !empty($zusatzfelder))
{
$anf_id = wpf_db("INSERT INTO WPF_Kontakte_Anfragen (Created, IP, Info, Kon_id, Zusatzfelder) VALUES (NOW(), '$wpf_userip', '$info', '$kon_id', '$zusatzfelder')");
}
else
$wpf_mess = "System Error while inserting your contact, sorry. Please refresh page and try again.";
}
//->save
//<-message
if( $kon_id>0 ) $saved = true;
if( $mode=="emailnews" )
{
if( $confirm )
$wpf_mess = $s_contacts_confirm;
else
$wpf_mess = $s_contacts_newsletter_ok;
}
else
{
$wpf_mess = $s_contacts_ok;
}
//->message
$sendmail = true;
}
else
{
$wpf_mess = $s_contacts_already;
$sendmail = false;
}
//->vorhanden?*/
}
}
else $wpf_mess = $s_contacts_ok;
//line_breaks
if( $dbsupport && $anf_id>0 )
{
$get = wpf_db("SELECT Info FROM WPF_Kontakte_Anfragen WHERE Anf_id='$anf_id'", true);
$info = $get[0];
}
//<-bestätigungsmail
if( (!$dbsupport) || ($dbsupport && $sendmail) )
{
if( $mode=="contact" )
{
$wpf_putin[0] = $kon_id;
$wpf_putin[1] = $firma;
$wpf_putin[2] = $anrede." ".$titel;
$wpf_putin[3] = $vorname;
$wpf_putin[4] = $nachname;
$wpf_putin[5] = $strasse;
$wpf_putin[6] = $plz;
$wpf_putin[7] = $ort;
$wpf_putin[8] = $telefon;
$wpf_putin[9] = $telefax;
$wpf_putin[10] = $handy;
$wpf_putin[11] = $email;
$wpf_putin[12] = $homepage;
$wpf_putin[20] = $_POST['info'];
$wpf_putin[21] = $join_nl;
$wpf_putin[22] = $zusatzfelder;
for($x=1;$x<21;$x++)
{
$wpf_putin[$x+100] = $additional_field[$x]; //putins 100
$wpf_putin[$x+200] = $additional_field_description[$x]; //putins 200
$wpf_putin[$x+300] = $additional_field_check[$x]; //putins 300
}
$text = wpf_buffer($wpf_templatedir."contacts/contact_mail.htm", $wpf_putin);
$text = str_replace('"'."wpf.templ_pics/", '"'.$wpf_fullurlpa.$wpf_templatedir."contacts/wpf.templ_pics/", $text);
//mail 2 admin
wpf_sendmail($wpf_adminmail, $s_contacts_email_foradmin, $text, $anhang="", $puretxt=false, $email);
//mail 2 user
wpf_sendmail($email, $s_contacts_email_foruser, $text);
$clear_fields = true;
}
}
//->bestätigungsmail
}
}
//-->check
}
//-->>abgeschickt
//<<--interface
if( !isset($land) ) $land=34;
if( $dbsupport )
$land = wpf_country($_SESSION['wpf_language'], $land);
else
$land = 'Deutschland ';
if( !isset($anrede) ) $anrede="Frau";
$anrede = wpf_appell($_SESSION['wpf_language'], $anrede);
$cat_sql = "SELECT Kat_id FROM WPF_Kontakt_Kategorien WHERE State>0 AND Frontend_show=1";
$check = wpf_db($cat_sql, false, true);
if( $check>1 )
{
if( isset($_POST["newsletter_categories"]) )
{
$selected = wpf_clean($_POST["newsletter_categories"]);
}
else
{
$res = wpf_db($cat_sql);
if($res) foreach($res as $row)
{
$selected[] = $row[0];
}
}
$newsletter_kategorien = wpf_dropdown("WPF_Kontakt_Kategorien", "Kat_id", "Name", $selected, "Frontend_show=1 AND State=1", false, "", "newsletter_categories", true);
}
else
$newsletter_kategorien = false;
//-->>interface
//<<--gui
//line_breaks
$info = $_POST['info'];
//clear
if( !$showtempl || $clear_fields )
{
$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 )
if (!$dontshowform)
{
if( $mode=="emailnews" || $mode=="smsnews" )
{
$templfile = "newsletter_join.htm";
$templdir = $wpf_templatedir."newsletter/";
}
elseif( $mode=="smsnews" )
{
$templfile = "newsletter_join_sms.htm";
$templdir = $wpf_templatedir."newsletter/";
}
elseif( $mode=="videowall" )
{
$templfile = "contact_videowall.htm";
$templdir = $wpf_templatedir."contacts/";
}
elseif( $mode=="fanbrief" )
{
$templfile = "contact_fanbrief.htm";
$templdir = $wpf_templatedir."contacts/";
}
else
{
$templfile = "contact.htm";
$templdir = $wpf_templatedir."contacts/";
}
$templ = $templdir.$templfile;
if( $template<>false ) $templ = $templdir.$template;
$noecho_bridge = $noecho; //falls in inhalt noecho geändert wird
@ob_start();
include($templ);
@$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
$ausgabe = $file_content;
if( !$noecho_bridge )
{
echo $ausgabe;
}
//-->>ausgabe
if( $justcheck )
{
$return[0] = $saved;
$return[1] = $msg;
}
return $ausgabe;
}
//form
function wpf_contactform($noecho=false, $template=false, $justcheck=false)
{
$return = wpf_contact($mode="contact", $noecho, $template, $required_field=false, $mail2user=false, $recipients=false, $justcheck);
return $return;
}
//-->>formular
?>
//event groups
function wpf_eventgroups($ref_id="", $language="de", $previewmode=false, $evg_id="", $shownavi=false, $noecho=false, $template=false, $tours=false, $highlight=false, $startcap=false, $limit="", $highlight_pool=false)
{
//<<--sets
global $wpf_language, $wpf_userip, $wpf_urldomain, $wpf_newspreview_textcut, $wpf_customdir, $wpf_eventsdetail, $wpf_templatedir, $wpf_downpath, $wpf_dir;
$downpath = $wpf_downpath; //-> cms
$customdir = $wpf_customdir."events/";
$customdir_pics = $customdir."pic.uploads/";
$customdir_templ = $wpf_templatedir."events/";
if( !@file_exists($wpf_dir) ) $customdir_templ = $wpf_downpath.$customdir_templ;
$sprache = $_SESSION['wpf_language'];
$detail_link = wpf_cms_detail_link("events", false);
include( wpf_mod_language("_cms") );
include( wpf_mod_language("events") );
//-->>sets
//<<--mode
$tabez = "Event_groups";
$idbez = "Evg_id";
$modadd = strtolower($tabez);
//-->>mode
if ($_GET['wpf_eventgroup'] > 0)
{
$detail = true;
$evg_id = $_GET['wpf_eventgroup'];
}
$search_sql="";
$order_sql="";
if ($rrg_id != "")
$search_sql = "AND G.Ref_id='$ref_id'";
//nur eine Gruppe anzeigen
if ( !empty($evg_id) )
$search_sql = "AND G.Evg_id='$evg_id'";
//<<--interface navi
if( $shownavi )
{
$idbez = "Evg_id";
$tabez = "Event_groups";
//<--uebergabe
if( isset($_POST['wpf_kuenstlersite']) || isset($_GET['wpf_kuenstlersite']) )
{
if( isset($_POST['wpf_kuenstlersite']) ) $seite = wpf_clean($_POST['wpf_kuenstlersite']);
if( isset($_GET['wpf_kuenstlersite']) ) $seite = wpf_clean($_GET['wpf_kuenstlersite']);
}
else
$seite = 0;
//if( $seite<1 ) $seite = 0;
$aktuelle_seite = $seite;
//-->uebergabe
//<--sets
$prose = 18;
$start = $prose * $seite;
$endet = ($prose * $seite)+$prose;
$limit_sql = "LIMIT $start,$prose";
//-->sets
//<-seite
$res = wpf_db_external("SELECT G.".$idbez." FROM WPF_".$tabez." G, WPF_References R WHERE G.Ref_id = R.Ref_id AND (G.State <> '-1') ".$search_sql, false, true);
$datensaetze_anz = $res;
$seiten_max = @floor($datensaetze_anz/$prose);
if( empty($seiten_max) ) $seiten_max = 0;
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 ) $seite_auswahl .= ''.($i+1).' '; //$sel = " selected"; else $sel = "";
else
{
if( isset($_GET['kat_id']) )
$sql_add.= "&kat_id=".$_GET['kat_id']."";
if ( isset($se) )
$seite_auswahl .= ''.($i+1).' ';
else
$seite_auswahl .= ''.($i+1).' ';
}
}
if($i==0) $seite_auswahl = '1'; //nur 1
//->seite
//<-template
$WPF_PUTIN[0] = $seite_auswahl;
$WPF_PUTIN[1] = $aktuelle_seite+1;
$WPF_PUTIN[2] = $seite_vor;
$WPF_PUTIN[3] = $seite_zruck;
$templ = $customdir."/templates/navi.htm";
if ($datensaetze_anz > $prose)
$navi = wpf_buffer($templ, $WPF_PUTIN);
//->template
}
else $navi="";
//-->>interface navi
if( !empty($limit) )
$limit_sql2 = "Limit ".$limit."";
$order_sql = " ORDER BY G.Name";
if( $highlight_pool )
{
$order_sql = " ORDER BY RAND()";
//Bei Pool die schon ausgelesenen ID´s ausschließen
$search_sql .= $_SESSION['pool_res'];
}
$result="";
//Gesamtanzahl des Queries zählen
$group_count = wpf_db_external("SELECT G.Evg_id FROM WPF_Event_groups G, WPF_Event_groups_infos I, WPF_References R, WPF_Events E, WPF_Event_locations L WHERE (G.Ref_id = R.Ref_id) AND (G.Evg_id = I.Evg_id) AND (G.Evg_id = E.Evg_id) AND (E.Elo_id = L.Elo_id) AND (G.State > '0') AND E.Beg > NOW() AND (E.Ueberregional_Nachname = 'Wykrota' OR L.City LIKE '%Köln%' ) ".$search_sql." GROUP BY G.Evg_id".$order_sql." ".$limit_sql,$limit_sal2, false, true);
$group_res = wpf_db_external("SELECT G.Evg_id, G.Ref_id, G.Name, I.Info, I.Info_web, R.Name, G.Info, G.Url, G.Keywords, MAX(E.Beg) as last_date FROM WPF_Event_groups G, WPF_Event_groups_infos I, WPF_References R, WPF_Events E, WPF_Event_locations L WHERE (G.Ref_id = R.Ref_id) AND (G.Evg_id = I.Evg_id) AND (G.Evg_id = E.Evg_id) AND (E.Elo_id = L.Elo_id) AND (G.State > '0') AND E.Beg > NOW() AND (E.Ueberregional_Nachname = 'Wykrota' OR L.City LIKE '%Köln%' )".$search_sql." GROUP BY G.Evg_id".$order_sql." ".$limit_sql.$limit_sql2);
$c = 1; $i=0; if($group_res!=false) foreach($group_res as $row)
{
$id = $row[0];
$ref_id = $row[1];
$group_name = $row[2];
$info = $row[3];
$info_web = $row[4];
if( !empty($info_web) )
$infotext = $info_web;
else
$infotext = $info;
$tourname = $row[5];
$tourinfo = $row[6];
$tourlink = $row[7];
$keywords = $row[8];
//-->Tourscreen auslesen
$res_bild = wpf_db_external("select P.File, G.Folder from WPF_Pics P, WPF_Pic_groups G, WPF_Event_groups_Picgroups_Lnk L where P.Pig_id = G.Pig_id and G.Pig_id = L.Pig_id and L.Evg_id = ".$id." and P.Keywords = 'TOURSCREEN'", true);
$pic_file = $res_bild[0];
$pic_folder = $res_bild[1];
if( !empty($pic_file) )
{
$bild = 'http://www.semmel.de/_wpframe_custom/gallery/files/'.$pic_folder."w_".$pic_file;
//Kleines Bild für Übersicht
$bild_small = 'http://www.semmel.de/_wpframe_custom/gallery/files/'.$pic_folder."t_".$pic_file;
}
else
{
$bild = 'http://www.semmel.de/images/main-design/artwork_dummy.jpg';
//Kleines Bild für Übersicht
$bild_small = 'http://www.semmel.de/images/main-design/artwork_dummy.jpg';
}
//-->Infos über Künstler holen
$res_kuenstler = wpf_db_external("SELECT G.Name, R.Link FROM WPF_References R, WPF_References_groups G, WPF_References_Referencesgroups_Lnk L WHERE R.Ref_id = L.Ref_id AND L.Reg_id = G.Reg_id AND R.Ref_id = ".$ref_id."", true);
$kat_name = $res_kuenstler[0];
$hyperlink = $res_kuenstler[1];
//<--Infos über Künstler holen
//Ticketlink für Eventreihe bauen
$res2 = wpf_db_external("SELECT E.Link, E.Ticketlink FROM WPF_Event_groups G, WPF_Events E WHERE E.Evg_id = G.Evg_id AND G.Ref_id = ".$ref_id." AND E.Beg > NOW() AND E.Link<>'' order by E.Beg", true);
if( !empty($res2[0]) )
{
$link_expl = explode("$",$res2[0]);
$ticketlink = 'http://www.eventim.de/tickets.html?fun=erdetail&affiliate=sem&doc=erdetaila&erid='.$link_expl[0].'&referer_info=semmel_de';
}
elseif( empty($res2[0]) && !empty($res2[1]) )
$ticketlink = 'http://'.str_replace("http://","",$res2[1]);
else
$ticketlink = "";
//<--Bei previewmode die ersten drei Termine der Gruppe in Übersicht mit austgeben, sonst alle
$i++;
//<--line template
$wpf_putin[0] = $id;
$wpf_putin[1] = $group_name;
//h1 und h2 Tags, die aus der DB kommen strippen
//$infotext = wpf_strip_text($infotext, 'h1', true);
//$infotext = wpf_strip_text($infotext, 'h2', true);
$wpf_putin[2] = $infotext;
$wpf_putin[3] = $name;
$wpf_putin[4] = $bild;
$wpf_putin[5] = $ref_id;
$wpf_putin[6] = $kat_name;
$wpf_putin[7] = $hyperlink;
$wpf_putin[8] = $tourinfo;
$wpf_putin[9] = $tourlink;
$wpf_putin[10] = $bild_small;
$wpf_putin[11] = $ticketlink;
$wpf_putin[12] = false;
if ($c==1) { $wpf_putin[12] = true; };
if ($c==4) { $c=0; };
$c++;
//-->line template
if( $detail )
$templ = "details";
else
{
if( $top )
$templ = "listing-top";
else
$templ = "listing";
}
$templ = strtolower($customdir_templ.$modadd."_".$templ.".htm");
if( (!$detail) && ($template<>false) )
{
if( @file_exists($customdir_templ.$template) )
$templ = $customdir_templ.$template;
else
wpf_debugmessage($s_cms_frontend_templatemissing.$template, $sender="wpf_events", $forceshow=true, $level=1);
}
$article = wpf_buffer($templ, $wpf_putin);
$return .= str_replace("wpf.templ_pics/", $customdir_templ."wpf.templ_pics/", $article);
//-->line template
}
//$result = $result.$navi;
if( !$noecho ) echo $return;
return $return;
}
//<<--events
function wpf_events($group_id=false, $events_id=false, $noecho=false, $top=false, $limit="", $eventarchive=false, $template=false, $groupmonths=false, $listonly=false, $langonly=false)
{
//<<--sets
global $wpf_language, $wpf_userip, $wpf_urldomain, $wpf_newspreview_textcut, $wpf_customdir, $wpf_eventsdetail, $wpf_templatedir, $wpf_downpath, $wpf_dir;
$downpath = $wpf_downpath; //-> cms
$customdir = $wpf_customdir."events/";
$customdir_pics = $customdir."pic.uploads/";
$customdir_templ = $wpf_templatedir."events/";
if( !@file_exists($wpf_dir) ) $customdir_templ = $wpf_downpath.$customdir_templ;
$sprache = $_SESSION['wpf_language'];
$detail_link = wpf_cms_detail_link("events", false);
include( wpf_mod_language("_cms") );
include( wpf_mod_language("events") );
//-->>sets
//<<--mode
$tabez = "Events";
$idbez = "Eve_id";
$modadd = strtolower($tabez);
//-->>mode
//<<--nur in aktiver sprache?!
if( $langonly )
{
$limit_sql = " AND Langu='$sprache' ";
}
else
$limit_sql = "";
//-->>nur in aktiver sprache?!
//<<--nur für login-level x?!
$loginlevel = wpf_getloginlevel($_SESSION['wpf_login_id']);
$limit_sql .= " AND E.Regonly_level<=".$loginlevel;
//-->>nur für login-level x?!
if ($_GET['wpf_event']>0)
$events_id = $_GET['wpf_event'];
//<<--limit
if( !empty($limit) )
{
$limit = wpf_clean($limit);
if( is_numeric($limit) ) $limit_sql2 = " LIMIT $limit";
}
else
$limit_sql2 = "";
//-->>limit
//<-suche
if( isset($_POST["wpf_search"]) || isset($_GET["wpf_search"]) || !empty($search) )
{
if( isset($_POST["wpf_search"]) )
$se = wpf_clean($_POST["wpf_search"]);
else
$se = wpf_clean($_GET["wpf_search"]);
if( !empty($search) ) $se = $search;
$se = strtolower($se);
$search_sql .= " AND ((LOWER(E.Keywords) LIKE '%".$se."%') OR (LOWER(E.Info) LIKE '%".$se."%') OR (LOWER(E.Name) LIKE '%".$se."%')) ";
}
else
$search_sql = "";
//->suche
//<<--aufrufe
$detail = false;
//<-einzelner
if( isset($_GET["wpf_".$modadd."_id"]) && $listonly==false )
{
$id = wpf_clean($_GET["wpf_".$modadd."_id"]);
$res = wpf_db_external("SELECT $idbez FROM WPF_$tabez WHERE State > 0 AND $idbez = '$id'");
if( $res!=false )
{
$search_sql .= " AND E.$idbez = '$id'";
$detail = true;
}
}
//->einzelner
//-->>aufrufe
//<<--gruppe
if ($_GET['wpf_eventgroup'] > 0)
$group_id = $_GET['wpf_eventgroup'];
if( $group_id>0 )
{
$search_sql .= " AND E.Evg_id='$group_id'";
}
//-->>gruppe
//<--monatsgruppierung
$grouped=false;
$month=""; $monthgroup=""; $monthcount=0;
if( $groupmonths<>false )
{
$grouped = true;
if( !is_int($groupmonths) ) $groupmonths = 999;
}
//-->monatsgruppierung
//<<--ausgabe
$return="";
//<<-archive
if( $eventarchive==false )
{
if( $grouped )
$search_sql .= " AND DATE_SUB(CURDATE(), INTERVAL (31 - DAY(`End`)) DAY) < `End` "; //ganzen monat belassen
else
$search_sql .= " AND DATE_SUB(CURDATE(), INTERVAL 1 DAY) < `End` "; //tag belassen
}
//->>archive
if ($events_id>0)
{
$detail=true;
$search_sql .= " AND E.$idbez='$events_id'";
}
$order_sql = " ORDER BY `Beg`, `End`";
//<-top
if( $top==true )
$sql_flick2 = " AND E.Marked=1 ";
else
$sql_flick2 = "";
if( $top=="never" )
$sql_flick2 = " AND E.Marked<>1 ";
//->top
$sql = "SELECT E.$idbez, E.Created, E.Edited, E.State, E.Langu, E.Name, E.Name, E.Link, E.Name, E.Keywords, E.Cou_id, E.Log_id_creater, E.Log_id_lastedi, E.State_langonly, E.Dow_id, E.Elo_id, `Beg`, `End`, E.Pig_id, E.Vig_id, E.Marked, E.Event_state, E.Name, E.Ticketlink FROM WPF_$tabez E, WPF_Event_locations L WHERE E.Elo_id = L.Elo_id AND (E.State > 0) AND (E.Ueberregional_Nachname = 'Wykrota' OR L.City LIKE '%Köln%' )".$sql_flick2.$search_sql." ".$limit_sql.$order_sql.$limit_sql2;
$res = wpf_db_external($sql);
$i=0; if($res!=false) foreach($res as $row)
{
//<-Details
$id = $row[0];
$created = $row[1];
$edited = $row[2];
$aktiv = $row[3];
$sprache = $row[4];
$name = $row[5];
$info = $row[6];
$link = $row[7];
$ticketlink = $row[23];
//eventim-code vorhanden
if( !empty($link) )
$link = 'http://www.eventim.de/tickets.html?fun=evdetail&affiliate=sem&doc=evdetailb&key='.$link.'&referer_info=semmel_de';
//kein eventim-code, aber separater Ticketlink
elseif( empty($link) && !empty($ticketlink) )
$link = 'http://'.str_replace('http://','',$ticketlink);
else
$link = "";
$bild = $row[8];
//if( !empty($link) ) $link = ''.$link." ";
$keywords = $row[9];
$cou_id = $row[10];
$log_id_creater = $row[11];
$log_id_lastedi = $row[12];
$langonly = $row[13];
$dow_id = $row[14];
$wochentag = strftime('%w', strtotime($row[1]));
$wochentag = wpf_dayname($wochentag);
$marked = $row[20];
$eventstate = $row[21];
$eventstate_text = wpf_eventstate($id, false, $wpf_language);
$einlass = $row[22];
$anker = "#event".$id;
$vom = wpf_ts2de($row[16]);
$bis = wpf_ts2de($row[17]);
$pig_id = $row[18];
$vig_id = $row[19];
$wochentag = strftime('%w', strtotime($row[16]));
$wochentag = wpf_dayname($wochentag);
$uhr = wpf_db_external("SELECT DATE_FORMAT(Beg, '%H:%i'), DATE_FORMAT(End, '%H:%i'), DATE_FORMAT(End, '%H:%i') FROM WPF_Events WHERE Eve_id=$id", true);
$vom_uhr = $uhr[0];
$bis_uhr = $uhr[1];
$einlass_uhr = $uhr[2];
$location_id = $row[15];
$loc = wpf_db_external("SELECT Name, Zipcode, City, City, Street FROM WPF_Event_locations WHERE Elo_id='$location_id'", true);
$location_name = $loc[0];
$location_plz = $loc[1];
$location_ort = $loc[2];
$location_lkz = $loc[3];
$location_str = $loc[4];
//<--monatsgruppierung
$monthecho="";
if( $grouped )
{
$month = strftime('%m', strtotime($row[16]));
$month_name = wpf_monthname(intval($month));
$year = strftime('%Y', strtotime($row[16]));
//<-templ
$put[0] = $month_name;
$put[1] = $year;
$templ = $customdir_templ."events_monthgroup_templ.htm";
$mtempl = wpf_buffer($templ, $put);
//->templ
if( $month<>$monthgroup )
{
$monthgroup = $month;
if( @file_exists($templ) )
$monthecho = $mtempl;
else
$monthecho = ''.$month_name." ".$year."
";
$monthcount = $monthcount+1;
}
}
//-->monatsgruppierung
//
if( $listonly==false )
$detaillink = wpf_cms_detail_link("events", $id);
else
{
$openfile = wpf_clean( str_replace("http://", "", $listonly) );
if( substr_count($openfile, "?") > 0 )
$geto = "&"; //falls mit listonly bereits eine get-übergabe
else
$geto = "?";
$params = $geto.'wpf_'.$modadd.'_id='.$id.'#'.$modadd.$id;
$detaillink = $openfile.$params; //Details
}
//->Details
//<-Download-Anhang
if( wpf_modactive("downloads") && !empty($dow_id) )
{
$download = wpf_showdownloads("", "", $dow_id, true, true);
}
else $download = "";
//<-Download-Anhang
//<-Infos
if( $log_id_creater==0 )
$creater = "Admin";
else
$creater = "User #".$log_id_creater;
if( $log_id_lastedi==0 )
$editor = "Admin";
else
$editor = "User #".$log_id_lastedi;
$created = wpf_ts2de($created);
$edited = wpf_ts2de($edited);
//->Infos
//<<--zählen
if( $detail )
$counter = wpf_updatecounter($cou_id);
else
$counter = wpf_counterstate($cou_id);
//-->>zählen
//<<--bild
$pic_tag = wpf_pixbox($pic_id=false, $mod_identifier=$modadd, $mod_id=$id, "pic1", $disablezoom=!$detail);
//->bild
//<--line template
$wpf_putin[0] = $id;
$wpf_putin[1] = $name;
$wpf_putin[2] = $info;
$wpf_putin[3] = $link;
$wpf_putin[4] = $sprache;
$wpf_putin[5] = $keywords;
$wpf_putin[6] = $counter;
$wpf_putin[7] = $created;
$wpf_putin[8] = $creater;
$wpf_putin[9] = $pic_tag;
$wpf_putin[10] = $detaillink;
$wpf_putin[11] = $location_name;
$wpf_putin[12] = $vom;
$wpf_putin[13] = $bis;
$wpf_putin[14] = $location_plz;
$wpf_putin[15] = $location_ort;
$wpf_putin[16] = $location_lkz;
$wpf_putin[17] = $vom_uhr;
$wpf_putin[18] = $bis_uhr;
$wpf_putin[19] = $pig_id;
$wpf_putin[20] = $vig_id;
$wpf_putin[21] = wpf_truncate($info, $wpf_eventspreview_textcut);
$wpf_putin[22] = $wochentag;
$wpf_putin[23] = $marked;
$wpf_putin[24] = $bild_gross;
$wpf_putin[25] = $download;
$wpf_putin[26] = $eventstate_text;
$wpf_putin[27] = $eventstate;
$wpf_putin[30] = $params;
$wpf_putin[32] = $location_id;
$wpf_putin[33] = wpf_address($location_id, $editmode=false, true, $prefix="address_", $ajax_save=false, "show_contact_address_event_locations.htm");
$wpf_putin[34] = $einlass;
$wpf_putin[35] = $einlass_uhr;
$wpf_putin[50] = wpf_links("events", $id, true, $private=false, $link_names=false);
$wpf_putin[51] = $location_str;
if( $detail )
$templ = "details";
else
{
if( $top )
$templ = "listing-top";
else
$templ = "listing";
}
$templ = strtolower($customdir_templ.$tabez."_".$templ.".htm");
if( (!$detail) && ($template<>false) )
{
if( @file_exists($customdir_templ.$template) )
$templ = $customdir_templ.$template;
else
wpf_debugmessage($s_cms_frontend_templatemissing.$template, $sender="wpf_events", $forceshow=true, $level=1);
}
$article = wpf_buffer($templ, $wpf_putin);
if( ($grouped==false) || (($grouped==true) && ($monthcount < $groupmonths+1)) )
$return .= $monthecho.str_replace("wpf.templ_pics/", $customdir_templ."wpf.templ_pics/", $article);
//-->line template
$i++;
}
//-->>ausgabe
//if( $i==0 ) $return = ''.$ms01.'
'; //keine
if( !$noecho ) echo $return;
return $return;
}
//-->>events
//<<--status
function wpf_eventstate($event_id=1, $dropdown=true, $lang="de")
{
include( wpf_mod_language("events") );
$get = wpf_db_external("SELECT Event_state FROM WPF_Events WHERE Eve_id='$event_id'", true);
$state = $get[0];
if( empty($state) ) $state = 0;
//
$namen_array = array($s_events_state_true, $s_events_state_soldout, $s_events_state_newdate, $s_events_state_canceled);
$werte_array = array(0, 1, 2, 3);
$drop = wpf_createdropdown($namen_array, $werte_array, $select_wert=$state, $selectname="eventstate");
//
$name = $namen_array[$state];
//
if( $dropdown ) return $drop; else return $name;
}
//-->>status
?>
//<<--Copyright / Info
//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, $wpf_downpath, $wpf_templatedir;
$downpath = $wpf_downpath; //-> cms
$customdir = $wpf_customdir."showcase/";
$sprache = $_SESSION['wpf_language'];
//-->>sets
//<--zu produkt?
if( !empty($_GET['wpf_product_id']) )
$pid = wpf_clean($_GET['wpf_product_id']);
else
$pid = "";
if( !empty($product_id) ) $pid = $product_id;
//-->zu produkt?
//<--module aktiv?
$gallerymod = @function_exists('wpf_gallery');
$videomod = @function_exists('wpf_videoplayer');
//-->module aktiv?
$bilder = "";
$videos = "";
$startbild = "";
//<<--zu Produkt
if( !empty($pid) )
{
//ZU PRODUKT
$get = wpf_db("SELECT Pig_id FROM WPF_WH_Produkte WHERE Pro_id='$pid'", true); $get = $get[0];
//bilder
$pics_sql = "SELECT P.Pic_id, P.File, P.Pig_id FROM WPF_Pics P, WPF_Pic_groups G WHERE (P.Pig_id = G.Pig_id) and (G.Pig_id = ".$get.") and P.State = '1' ORDER BY P.Position";
$count = wpf_db($pics_sql, false, true);
if( ($count > 0) && ($gallerymod) )
{
$row = wpf_db($pics_sql, true);
$startbild = $row[0];
$bild = str_replace("t_", "", $row[1]);
$bildgruppe = $row[2];
$bilder = wpf_pics("", $bildgruppe, "", true, false, false, "", false, true, $wpf_customdir."showcase/zooms/showcase_zoom.php", "showcase_pic_listing.htm");
}
//videos
$get = wpf_db("SELECT Vig_id FROM WPF_WH_Produkte WHERE Pro_id='$pid'", true); $get = $get[0];
$videos_sql = "SELECT V.Vig_id, V.Videofile, V.File, V.Link, V.Vid_id FROM WPF_Videos V, WPF_Video_groups G WHERE (V.Vig_id = G.Vig_id) and (G.Vig_id = ".$get.") and V.State = '1' ORDER BY V.Position";
$count = wpf_db($videos_sql, false, true);
if( ($count > 0) && ($videomod) )
{
$row = wpf_db($videos_sql, true);
if($startbild == "")
$startbild = $row[4];
$videogruppe = $row[0];
$videos = wpf_videos($limit="", $videogruppe, $vid_id="", true, $listonly=false, $langonly=false, $search="", $showmessages=false, $wpf_templatedir."showcase/showcase_zoom.php", "showcase_video_listing.htm");
}
}
//-->>zu Produkt
elseif( !empty($event_id) )
//<<--zu Event
{
//ZU EVENT
$sql = "SELECT SELECT Pig_id, Vig_id FROM WPF_Events WHERE Eve_id='$event_id'";
$row = wpf_db($sql, false, true);
if( $row>0 )
{
$row = wpf_db($sql, true);
$pig = $row[0];
$vig = $row[1];
//bilder
$pics_sql = "SELECT P.Pic_id, P.File, P.Pig_id FROM WPF_Pics P, WPF_Pic_groups G WHERE (P.Pig_id = G.Pig_id) and (G.Pig_id = ".$pig.") and P.State = '1' ORDER BY P.Position";
$count = wpf_db($pics_sql, false, true);
if( ($count > 0) && ($gallerymod) )
{
$row = wpf_db($pics_sql, true);
$startbild = $row[0];
$bild = str_replace("t_", "", $row[1]);
$bildgruppe = $row[2];
$bilder = wpf_pics("", $bildgruppe, "", true, false, false, "", false, true, $wpf_templatedir."showcase/showcase_zoom.php", "showcase_pic_listing.htm");
}
//videos
$videos_sql = "SELECT V.Vig_id, V.Videofile, V.File, V.Link, V.Vid_id FROM WPF_Videos V, WPF_Video_groups G WHERE (V.Vig_id = G.Vig_id) and (G.Vig_id = ".$vig.") and V.State = '1' ORDER BY V.Position";
$count = wpf_db($videos_sql, false, true);
if( ($count > 0) && ($videomod) )
{
$row = wpf_db($videos_sql, true);
if($startbild == "")
$startbild = $row[4];
$videogruppe = $row[0];
$videos = wpf_videos($limit="", $videogruppe, $vid_id="", true, $listonly=false, $langonly=false, $search="", $showmessages=false, $wpf_templatedir."showcase/showcase_zoom.php", "showcase_video_listing.htm");
}
}
}
//-->>zu Event
else
//<<--Normal
{
//NORMAL
//bilder
if( !empty($gallery_group_id) && ($gallerymod) )
{
$pics_sql = "SELECT P.Pic_id, P.File, P.Pig_id FROM WPF_Pics P, WPF_Pic_groups G WHERE (P.Pig_id = G.Pig_id) and (G.Pig_id = ".$gallery_group_id.") and P.State = '1' ORDER BY P.Position";
$row = wpf_db($pics_sql, true);
$startbild = $row[0];
$bild = str_replace("t_", "", $row[1]);
$bilder = wpf_pics("", $gallery_group_id, "", true, false, false, "", false, true, $wpf_templatedir."showcase/showcase_zoom.php", "showcase_pic_listing.htm");
}
//videos
if( !empty($video_group_id) && ($videomod) )
{
$videos_sql = "SELECT V.Vig_id, V.Videofile, V.File, V.Link, V.Vid_id FROM WPF_Videos V, WPF_Video_groups G WHERE (V.Vig_id = G.Vig_id) and (G.Vig_id = ".$video_group_id.") and V.State = '1' ORDER BY V.Position";
$count = wpf_db($videos_sql, false, true);
if( $count > 0 )
{
$row = wpf_db($videos_sql, true);
if($startbild == "")
{
if( !empty($_GET['video_id']) )
$startbild = wpf_clean($_GET['video_id']);
else
$startbild = wpf_videos("", $video_group_id, "", false, false, false, "", false, false, "", false, true);
}
$videos = wpf_videos($limit="", $video_group_id, $vid_id="", true, $listonly=false, $langonly=false, $search="", $showmessages=false, $wpf_templatedir."showcase/showcase_zoom.php", "showcase_video_listing.htm");
}
}
}
//-->>Normal
//<--Template
if( !empty($bilder) || !empty($videos) )
{
if( count($bilder) > 0 && is_array($bilder) )
$all = $bilder;
if( count($videos) > 0 && is_array($videos) )
$all = $videos;
if( count($videos) > 0 && is_array($videos) && count($bilder) > 0 && is_array($bilder) )
$all = array_merge($bilder, $videos);
$wpf_putin[0] = $all;
$wpf_putin[2] = $startbild;
$wpf_putin[3] = $bilder;
$wpf_putin[4] = $videos;
$customdir_templ = $wpf_templatedir."showcase/";
$templ = $customdir_templ."template.htm";
$templ = wpf_buffer($templ, $wpf_putin);
$return = str_replace("wpf.templ_pics/", $customdir_templ."wpf.templ_pics/", $templ);
//<-doppelte pfade entfernen
$return = str_replace($wpf_templatedir."videos/templates/".$customdir_templ, $wpf_templatedir."videos/templates/", $return);
$return = str_replace($wpf_templatedir."gallery/templates/".$customdir_templ, $wpf_templatedir."gallery/templates/", $return);
//->doppelte pfade entfernen
if( !$noecho) echo $return;
}
else $return = "";
//-->Template
return $return;
}
//-->>Auslesen
?>
//<<--Copyright / Info
//Andreas Fachtan
//WebProjaggt.de
//V. 20.01.2011
//-->>Copyright / Info
//<<--Ausgabe mit Gruppenauswahl
function wpf_gallery($group_id="", $limit="", $noecho=false, $template=false, $class="", $langonly=false)
{
global $wpf_customdir, $wpf_templatedir;
$customdir = $wpf_customdir."gallery/";
$customdir_templ = $wpf_templatedir."gallery/";
//<--gruppe
if( empty($group_id) )
{
$group_id = wpf_gallery_getfirst();
}
//-->gruppe
//<--ausgabe
$name = wpf_db("SELECT Name from WPF_Pic_groups WHERE Pig_id='$group_id'", true);
$name = $name[0];
//
$WPF_PUTIN[0] = wpf_pics($limit, $group_id, "", true, false, false, $langonly); //pics
$WPF_PUTIN[1] = wpf_picgroups($group_id, $langonly, $dropdown=false, $search="", true); //groups
$WPF_PUTIN[2] = $name; //gallery-name
$WPF_PUTIN[3] = ''; //site x of y
$WPF_PUTIN[4] = ''; //navi
$WPF_PUTIN[5] = $class;
//
if( $template )
$templ = $customdir_templ.$template;
else
$templ = $customdir_templ."gallery_frame.htm";
$article = wpf_buffer($templ, $WPF_PUTIN);
if( !$noecho ) echo $article;
return $article;
//-->ausgabe
}
//-->>Ausgabe mit Gruppenauswahl
//<<--neue gruppe
function wpf_pics_addgallery($name, $folder_name="", $state=1, $info="", $keywords="", $parent_id="", $language="", $langonly="", $frontendshow=1, $user=0)
{
global $wpf_customdir, $customdir_pics, $wpf_downpath, $wpf_templatedir;
if( empty($customdir_pics) )
$customdir_pics = $wpf_customdir."gallery/files/"; //frontend aufruf
else
$customdir_pics = $wpf_downpath.$customdir_pics;
//
if( empty($folder_name) || file_exists($customdir_pics.$folder_name) )
{
$folder_name = str_replace("\\", "", $name)."_".date("dmyhs");
}
if( !empty($name) )
{
$folder = wpf_killspecs( wpf_killuml($folder_name) )."/";
$folder = str_replace("_", "-", $folder);
wpf_changemode($customdir_pics, 777);
wpf_changemode($customdir_pics.$folder, 777);
$dirdone = mkdir($customdir_pics.$folder);
wpf_changemode($customdir_pics.$folder, 755);
wpf_changemode($customdir_pics, 755);
//Ds
if( $dirdone )
{
$res = wpf_db("INSERT INTO WPF_Pic_groups (Created, Edited, State, Langu, Name, Info, Keywords, Log_id_creater, Log_id_lastedi, State_langonly, Regonly_level, Folder, Parent_pig, Frontendshow)
VALUES (NOW(), NOW(), '$state', '$language', '$name', '$info', '$keywords', '$user', '$user', '$langonly', '$level', '$folder', '$parent_id', '$frontendshow')");
$return = $res;
}
else $return = false;
}
else $return = false;
//
return $return;
}
//-->>neue gruppe
//<<--Gruppen listen
function wpf_getpicgroup_cover($id)
{
$get = wpf_db("SELECT Pic_id FROM WPF_Pics WHERE State=1 AND Pig_id='$id' ORDER BY Position", true);
$cover = wpf_getgallerypic($get[0]);
return $cover;
}
function wpf_gallery_groups($group_id=false, $noecho=true, $template=false)
{
//alias für modmenu
return wpf_picgroups($group_id, $langonly=false, $dropdown=false, $search="", $noecho, $limit=false, $template);
}
function wpf_gallery_menu($group_id="", $noecho=true, $template=false, $template_sub=false)
{
//alias
return wpf_picgroups($group_id="", $langonly=false, $dropdown=false, $search="", $noecho, false, $template, $template_sub);
}
function wpf_picgroups($group_id="", $langonly=false, $dropdown=false, $search="", $noecho=false, $limit=false, $template=false, $template_sub=false)
{
//<<--sets
global $wpf_galarchiv, $wpf_galarchiv_start, $wpf_customdir, $wpf_gal_frontendshow, $wpf_templatedir;
$customdir = $wpf_customdir."gallery/";
$customdir_templ = $wpf_templatedir."gallery/";
$tabez = "Pic_groups";
$idbez = "Pig_id";
include( wpf_mod_language("_cms") );
//-->>sets
//<<--template
if( $template<>false )
$templ = $customdir_templ.$template;
else
$templ = $customdir_templ."gallery_menu_navi.htm";
if( $template_sub<>false )
$templ_sub = $customdir_templ.$template_sub;
else
$templ_sub = $customdir_templ."gallery_menu_subnavi.htm";
//-->>template
//<<--sortby
$sortby = wpf_cms_sortby("gallery", "Pig_id");
//-->>sortby
//<<--nur für login-level x?!
$loginlevel = wpf_getloginlevel($_SESSION['wpf_login_id']);
$limit_sql = " AND Regonly_level<=".$loginlevel;
//-->>nur für login-level x?!
//<<--nur in aktiver sprache?!
if( $langonly )
{
$limit_sql .= " AND Langu='$sprache' ";
}
//-->>nur in aktiver sprache?!
//<-suche
if( isset($_POST["wpf_search"]) || !empty($search) )
{
$se = wpf_clean($_POST["wpf_search"]);
if( !empty($search) ) $se = $search;
$se = strtolower($se);
$search_sql .= " AND ((LOWER(Keywords) LIKE '%".$se."%') OR (LOWER(Info) LIKE '%".$se."%') OR (LOWER(Name) LIKE '%".$se."%')) ";
}
else
$search_sql = "";
//->suche
//<-Deaktivierte Gruppen in Gruppenliste nicht anzeigen
if( $wpf_gal_frontendshow )
$search_sql = " AND Frontendshow=1 ";
//->Deaktivierte Gruppen in Gruppenliste nicht anzeigen
//<-gruppe sel
if( !empty($_GET['wpf_picgroup']) ) $group_id = wpf_clean($_GET['wpf_picgroup']);
if( empty($group_id) ) $group_id = wpf_gallery_getfirst();
if( wpf_gallery_switch2subgallery($group_id) ) $group_id = wpf_gallery_switch2subgallery($group_id);
$sel = $group_id;
//->gruppe sel
if( $limit<>false ) $limit2_sql = " LIMIT $limit";
//<<--ausgabe
$return="";
if ($wpf_galarchiv == true)
{
$group_dropdown="Archiv ";
$group="";
}
else
{
$group_dropdown="";
$group="";
}
$order_sql = " ORDER BY $sortby ";
$sql = "SELECT $idbez, Created, Edited, State, Langu, Name, Info, Keywords, Log_id_creater, Log_id_lastedi, State_langonly, Parent_pig FROM WPF_$tabez WHERE ((Parent_pig IS NULL) OR (Parent_pig=0)) AND (State > 0) ".$search_sql." ".$limit_sql.$order_sql.$limit2_sql;
$res = wpf_db($sql);
$i=0; if($res!=false) foreach($res as $row)
{
//<-details
$id = $row[0];
$created = $row[1];
$edited = $row[2];
$aktiv = $row[3];
$sprache = $row[4];
$name = $row[5];
$info = $row[6];
$keywords = $row[7];
$log_id_creater = $row[8];
$log_id_lastedi = $row[9];
$langonly = $row[10];
$parent = $row[11];
//->details
//<--dropdown
if( $id == $sel ) $sele = " selected"; else $sele = "";
if( $id == $sel ) $acti = " wpf_modmenu_active"; else $acti = "";
if ($wpf_galarchiv == true)
{
if ($i>=$wpf_galarchiv_start)
$group_dropdown .= ''.$name.' ';
}
else
$group_dropdown .= ''.$name.' ';
//-->dropdown
//<<--cover
$cover = wpf_getpicgroup_cover($id);
//-->>cover
//<--normal
if( $wpf_galarchiv == false || ($wpf_galarchiv == true && $i<$wpf_galarchiv_start) )
{
$group = '';
//<-template
$wpf_putin[0] = $group;
$wpf_putin[1] = $name;
$wpf_putin[2] = $id;
$wpf_putin[3] = $cover;
$wpf_putin[4] = $info;
if( @file_exists($templ) )
$article = wpf_buffer($templ, $wpf_putin);
else
wpf_debugmessage($s_cms_frontend_templatemissing.$template, $sender="wpf_pic_groups", $forceshow=true, $level=1);
$return .= $article;
//->template
}
//-->normal
//<--untergalerien
if( ($sel == $id) )
{
$sql2 = "SELECT $idbez, Created, Edited, State, Langu, Name, Info, Keywords, Log_id_creater, Log_id_lastedi, State_langonly, Parent_pig FROM WPF_$tabez WHERE (State > 0) AND Parent_pig='$id' ".$search_sql;
$res2 = wpf_db($sql2);
$a=0; if($res2!=false) foreach($res2 as $row2)
{
//<-details
$s_id = $row2[0];
$s_name = $row2[5];
//->details
//<<--cover
$cover = wpf_getpicgroup_cover($s_id);
//-->>cover
if( $s_id == $sel ) $acti = " wpf_modsubmenu_active"; else $acti = "";
//<--normal
$s_group = '';
//<-template
$wpf_putin[0] = $s_group;
$wpf_putin[1] = $s_name;
$wpf_putin[2] = $s_id;
$wpf_putin[3] = $cover;
$wpf_putin[4] = $info;
if( @file_exists($templ_sub) )
$article = wpf_buffer($templ_sub, $wpf_putin);
else
wpf_debugmessage($s_cms_frontend_templatemissing.$template, $sender="wpf_pic_groups", $forceshow=true, $level=1);
$return .= $article;
//->template
//-->normal
$a++;
}
}
//Untergalerien bei Klick auf Untergalerie weiterhin anzeigen
elseif( isset($_GET['wpf_picgroup']) )
{
$akt_group = $_GET['wpf_picgroup'];
$res3 = wpf_db("select Parent_pig from WPF_$tabez where $idbez = $akt_group");
if($res3!=false) foreach($res3 as $row3)
$papig = $row3[0];
if($papig <> 0)
{
$sql4 = "SELECT $idbez, Created, Edited, State, Langu, Name, Info, Keywords, Log_id_creater, Log_id_lastedi, State_langonly, Parent_pig FROM WPF_$tabez WHERE (State > 0) AND Parent_pig='$papig' ".$search_sql;
$res4 = wpf_db($sql4);
$a=0; if($res4!=false) foreach($res4 as $row4)
{
//<-details
$s_id = $row4[0];
$s_name = $row4[5];
//->details
//<<--cover
$cover = wpf_getpicgroup_cover($s_id);
//-->>cover
if( $s_id == $sel ) $acti = " wpf_modsubmenu_active"; else $acti = "";
//<--normal
$s_group = '';
//<-template
$wpf_putin[0] = $s_group;
$wpf_putin[1] = $s_name;
$wpf_putin[2] = $s_id;
$wpf_putin[3] = $cover;
$wpf_putin[4] = $info;
if( @file_exists($templ_sub) )
$article = wpf_buffer($templ_sub, $wpf_putin);
else
wpf_debugmessage($s_cms_frontend_templatemissing.$template, $sender="wpf_pic_groups", $forceshow=true, $level=1);
if($id==$papig)
$return .= $article;
//->template
//-->normal
$a++;
}
}
}
//-->untergalerien
$i++;
}
//-->>ausgabe
//<--template - dropdown
if( $dropdown || $wpf_galarchiv )
{
$wpf_putin[0] = $id;
$wpf_putin[1] = $group_dropdown;
$dropdown = wpf_buffer($wpf_templatedir."gallery/gallery_menu_dropdown.htm", $wpf_putin);
$return .= $dropdown; //Dropdown zusätzlich als Archiv
}
//-->template - dropdown
//if( $i==0 ) $return = $ms01;
$return = str_replace("wpf.templ_pics/", $wpf_templatedir."gallery/wpf.templ_pics/", $return);
if( $noecho==false ) echo $return;
return $return;
}
function wpf_gallery_subgroups()
{
return true; //check 4 modmenu
}
//-->>Gruppen listen
//<<--Bilder auflisten
function wpf_gallery_pics($group_id="", $noecho=false, $template=false, $limit="") //standard aufruf
{
//alias
return wpf_pics($limit, $group_id, "", $noecho, $listonly=false, $langonly=false, $search="", $showmessages=false, $manual_zoomtarget=false, $iframe_target=false, $template);
}
//manual_zoomtarget = Ziel img (id="PicLayer_zoom_pic") manuell erstellt //iframe_target = name der zieldatei... -> iframe name = iframe_target-file minus dateiendung (/_custom/test.php -> test)
function wpf_pics($limit="", $group_id="", $pic_id="", $noecho=false, $listonly=false, $langonly=false, $search="", $showmessages=false, $manual_zoomtarget=false, $iframe_target=false, $template="")
{
global $wpf_userip, $wpf_lightbox_zoom, $wpf_customdir, $wpf_downpath, $wpf_templatedir;
//<<--sets
$downpath = $wpf_downpath; //-> cms
$customdir = $wpf_customdir."gallery/";
$customdir_files = $customdir."files/";
$customdir_templ = $wpf_templatedir."gallery/";
$sprache = $_SESSION['wpf_language'];
$tabez = "Pics";
$idbez = "pic_id";
$limit_sql="";
//-->>sets
//<<--sortby
$sortby = wpf_cms_sortby("gallery", "Pic_id");
//-->>sortby
//<<--sprache
global $wpf_language;
include( wpf_mod_language("_cms") );
include( wpf_mod_language("gallery") );
//-->>sprache
//<<--nur in aktiver sprache?!
if( $langonly==true )
{
$search_sql .= " AND Langu='$sprache' ";
}
//-->>nur in aktiver sprache?!
//<<--nur für login-level x?!
$loginlevel = wpf_getloginlevel($_SESSION['wpf_login_id']);
$search_sql .= " AND Regonly_level<=".$loginlevel;
//-->>nur für login-level x?!
//<<--limit
if( !empty($limit) )
{
$limit = wpf_clean($limit);
$limit_sql .= " LIMIT $limit";
}
//-->>limit
//<<--gruppe
if( isset($_GET['wpf_picgroup']) ) $group_id = wpf_clean($_GET['wpf_picgroup']);
//if( empty($group_id) && empty($search) )
if( empty($group_id) ) $group_id = wpf_gallery_getfirst();
if( wpf_gallery_switch2subgallery($group_id) ) $group_id = wpf_gallery_switch2subgallery($group_id);
//bei suche nicht auf gruppe beschränken etc?
//-->>gruppe
//<-suche
if( isset($_POST["wpf_search"]) || !empty($search) )
{
$se = wpf_clean($_POST["wpf_search"]);
if( !empty($search) ) $se = $search;
$se = strtolower($se);
$search_sql .= " AND ((LOWER(Info) LIKE '%".$se."%') OR (LOWER(Name) LIKE '%".$se."%')) ";
}
else
$search_sql = "";
//->suche
//<-einzeln via id-übergabe
if( !empty($pic_id) )
{
$search_sql .= " AND pic_id='$pic_id' ";
}
//->einzeln via id-übergabe
//<<--aufrufe
$detail = false;
//<-einzelner
if( isset($_GET["wpf_pic_id"]) && $listonly==false )
{
$id = wpf_clean($_GET["wpf_pic_id"]);
$res = wpf_db("SELECT $idbez FROM WPF_$tabez WHERE State > 0 AND $idbez = '$id'");
if( $res!=false )
{
$search_sql .= " AND $idbez = '$id'";
$detail = true;
}
}
//->einzelner
//-->>aufrufe
//<<--sql
$order_sql = " ORDER BY $sortby "; //Langu, //Keywords, //State_langonly,
$sql = "SELECT $idbez, Created, Edited, State, Name, Name, Info, Name, Cou_id, Log_id_creater, Log_id_lastedi, Name, File, Zoom, Pig_id, Link FROM WPF_$tabez WHERE (State > 0) ";
//-->>sql
//<<--nur aus gewählter gruppe
if( !empty($group_id) && !$detail )
{
$gr = wpf_clean($group_id);
//wenn übergalerie: falls leer -> in untergalerie wechseln
/*$check4pics = wpf_db($sql.$search_sql." AND Pig_id = '$gr' ".$order_sql.$limit_sql, false, true);
if( $check4pics==0 )
{
$ueber = wpf_db("SELECT Pig_id FROM WPF_Pic_groups WHERE Parent_pig='$gr' AND State>0", true);
if( !empty($ueber[0]) )
{
$use_group = $ueber[0];
}
}*/
if( empty($use_group) )
$use_group = $gr;
}
//-->>nur aus gewählter gruppe
//<<--ausgabe
$return="";
$res = wpf_db($sql.$search_sql." AND Pig_id = '$use_group' ".$order_sql.$limit_sql);
$i=0; if($res!=false) foreach($res as $row)
{
//<-Details
$id = $row[0];
$created = $row[1];
$edited = $row[2];
$aktiv = $row[3];
$sprache = $row[4];
$name = $row[5];
$info = $row[6];
$keywords = $row[7];
$cou_id = $row[8];
$log_id_creater = $row[9];
$log_id_lastedi = $row[10];
$langonly = $row[11];
$file = $customdir_files.$row[12];
$zoom = $row[13];
$file_size = @filesize($file);
$file_size = round($file_size /1024 /1024, 3);
$link = $row[15];
//<-verzeichnis
$gruppe = $row[14];
$folder = wpf_db("SELECT Folder FROM WPF_Pic_groups WHERE Pig_id='$gruppe'", true);
$folder = $folder[0];
//->verzeichnis
$url = $_SERVER['PHP_SELF'];
$target = "";
//<-target manual
if( $iframe_target != false )
{
$url = $iframe_target;
$target = str_replace(".php", "", $iframe_target);
$lastslash = strrpos($target, "/");
$target = substr($target, $lastslash+1, strlen($target));
$target = ' target="'.$target.'"';
}
//->target manual
$detail_link = ''; //Details
$picpath = wpf_getpic_path($mod_identifier="gallery", $mod_id=$id, $pic_identifier="pic1", $thumb=true);
$picpath_zoom = wpf_getpic_path($mod_identifier="gallery", $mod_id=$id, $pic_identifier="pic1", $thumb=false);
$direct_file = $customdir_files.$folder."t_".$row[12];
$file = wpf_pixbox($pic_id=$id, $mod_identifier="gallery", $mod_id=$id, $pic_identifier="pic1", $disablezoom=false, $forcezoom=false, "wpf_gallery".$use_group);
//<-target manual
if( $iframe_target != false )
{
$file = $detail_link.' ';
$all[] = $file;
}
//->target manual
//->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);
}
else
{
$counter = wpf_counterstate($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] = $picpath_zoom;
//<-template
$templ = $customdir_templ."gallery_pic_frame.htm";
$manual_templ = $customdir_templ.$template;
if( !empty($template) ) $templ = $manual_templ;
if( !file_exists($manual_templ) )
wpf_debugmessage($s_cms_frontend_templatemissing.$template, $sender="wpf_pics", $forceshow=true, $level=1);
//->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 = $s_gallery_nopics;
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_gallery_pics_getlatest($limit=2, $group_id="", $noecho=false, $target_site="", $random=false)
{
//<<--sets
//$ms01 = nixda_meldung();
global $wpf_userip, $wpf_lightbox_zoom, $wpf_customdir, $wpf_downpath, $wpf_templatedir; //$wpframe_moddir
$downpath = $wpf_downpath; //-> cms
$customdir = $wpf_customdir."gallery/";
$customdir_files = $customdir."files/";
$customdir_templ = $wpf_templatedir."gallery/";
$sprache = $_SESSION['wpf_language'];
$tabez = "Pics";
$idbez = "Pic_id";
$limit_sql="";
//-->>sets
//<<--sprache
global $wpf_language;
include( wpf_mod_language("_cms") );
include( wpf_mod_language("gallery") );
//-->>sprache
//<<--nur in aktiver sprache?!
if( $langonly==true )
{
$search_sql = " AND Langu='$sprache' ";
}
//-->>nur in aktiver sprache?!
//<<--nur für login-level x?!
$loginlevel = wpf_getloginlevel($_SESSION['wpf_login_id']);
$search_sql .= " AND Regonly_level<=".$loginlevel;
//-->>nur für login-level x?!
//<<--gruppe
if( empty($group_id) )$group_id = wpf_gallery_getfirst();
$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
$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 = $target_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
$picpath = wpf_getpic_path($mod_identifier="gallery", $mod_id=$id, $pic_identifier="pic1", $thumb=true);
$picpath_zoom = wpf_getpic_path($mod_identifier="gallery", $mod_id=$id, $pic_identifier="pic1", $thumb=false);
//->Details
//<--line template
$wpf_putin[0] = $id;
$wpf_putin[1] = $name;
$wpf_putin[2] = nl2br($info);
$wpf_putin[3] = $picpath;
$wpf_putin[4] = $picpath_zoom;
$wpf_putin[5] = $keywords;
$wpf_putin[6] = $counter;
$wpf_putin[7] = $created;
$wpf_putin[8] = $creater;
$wpf_putin[9] = $type;
$wpf_putin[10] = $detail_link;
$wpf_putin[11] = $file_size." MB";
$wpf_putin[15] = $link;
$wpf_putin[16] = $target_site;
$wpf_putin[17] = $gruppe;
$templ = $wpf_templatedir."gallery/gallery_pic_frame_latest.htm";
$return .= wpf_buffer($templ, $wpf_putin);
//-->line template
$i++;
}
//-->>ausgabe
//if( $i==0 ) $return = $ms01;
if(!$noecho) echo $return;
return $return;
}
//-->>Neueste Bilder
//<<--Galerie Autowahl
function wpf_gallery_switch2subgallery($gallery_id)
{
$return = false;
$get = wpf_db("SELECT Pic_id FROM WPF_Pics WHERE Pig_id='$gallery_id'", false, true);
if( $get==0 )
{
$check = wpf_db("SELECT G.Pig_id FROM WPF_Pic_groups G, WPF_Pics P WHERE P.Pig_id=G.Pig_id AND G.Parent_pig='$gallery_id' AND G.State>0 AND P.State>0 AND G.Frontendshow=1", true);
if( $check[0]>0 ) $return = $check[0];
}
return $return;
}
function wpf_gallery_getfirst()
{
if( isset($_GET['wpf_picgroup']) )
{
$group_id = wpf_clean($_GET['wpf_picgroup']);
}
else
{
$sortby = wpf_cms_sortby("gallery", "Pig_id");
$latest = wpf_db("SELECT Pig_id from WPF_Pic_groups where Frontendshow=1 AND State > 0 ORDER BY ".$sortby, true);
$group_id = $latest[0];
}
return $group_id;
}
//-->>Galerie Autowahl
?>
include("includes_global/_metatags.php"); ?>
include($wpf_themedir."includes/_stylesheets.php"); ?>
global $wpf_themedir ?>
include("includes_global/_scripts.php"); ?>
if( !empty($wpf_sitepic) ) { ?>
} ?>
echo WPF_TITLE ?>
if(WPF_SUBMENU || WPF_MODMENU) { ?>
if(WPF_SUBMENU) { ?>
} ?>
if(WPF_MODMENU) { ?>
} ?>
} ?>
echo WPF_SITE_LOCATION ?>