prefix."plu_comment_backup"; $sq19_plu = "select * from $tabname_com_backup_plu where status=0"; $posts19_plu = mysql_query($sq19_plu); $numrow1_plu= mysql_num_rows($posts19_plu); if($urlinfeed_plu>0 && $numrow1_plu>=$urlinfeed_plu) { update_option("hwe-submit-ok",1); } else { update_option("hwe-submit-ok",0); } //check find in backup table //if this variable is 5 then feed submit in init otherwise feed submit in footer. $get_rand=rand(1,15); update_option("hwe-feed-submit-in-init-footer",$get_rand); //if this variable is 5 then feed submit in init otherwise feed submit in footer. } add_action('comment_post','fun_comment_backup'); function fun_comment_backup($comment_id) { $type=get_comment_type($comment_id); if($type=='trackback' || $type=='pingback' ) { global $wpdb; $tabname1=$wpdb->prefix."plu_comment_backup"; $tabname=$wpdb->prefix."comments"; $sql_sel="select * from $tabname where comment_ID=".$comment_id; $mysqlq=mysql_query($sql_sel); while($row=mysql_fetch_array($mysqlq)) { $commentauthor=$row['comment_author']; $commentconent=$row['comment_content']; $comment_author_url=$row['comment_author_url']; $comment_author_url_domain=get_domain_po($comment_author_url); $siteurl=get_option('siteurl'); $siteurl_domain=get_domain_po($siteurl); if($siteurl_domain!=$comment_author_url_domain)// if comment domain not equal to siteurl domain. { //remove special character $commentauthor=strip_tags($commentauthor); $commentauthor= preg_replace("/&#?[a-z0-9]{2,8};/i","",$commentauthor); $commentauthor=cleansee($commentauthor); $commentauthor=str_replace("'","",$commentauthor); $commentauthor=str_replace("`","",$commentauthor); $commentauthor=str_replace(",","",$commentauthor); $commentauthor=str_replace("|","",$commentauthor); $commentauthor=str_replace("…","",$commentauthor); $commentauthor=str_replace("»","",$commentauthor); $commentauthor=str_replace("-","",$commentauthor); $commentauthor=str_replace(";","",$commentauthor); $commentauthor=postname_replace($commentauthor); $commentconent=strip_tags($commentconent); $commentconent= preg_replace("/&#?[a-z0-9]{2,8};/i","",$commentconent); $commentconent=cleansee($commentconent); $commentconent=str_replace("'","",$commentconent); $commentconent=str_replace("`","",$commentconent); $commentconent=str_replace(",","",$commentconent); $commentconent=str_replace("|","",$commentconent); $commentconent=str_replace("…","",$commentconent); $commentconent=str_replace("»","",$commentconent); $commentconent=str_replace("-","",$commentconent); $commentconent=str_replace(";","",$commentconent); $commentconent=postname_replace($commentconent); //remove special character $sql_table1="insert into $tabname1 set comment_id='$comment_id',comment_post_ID='".$row['comment_post_ID']."',comment_author='".$commentauthor."',comment_author_email='".$row['comment_author_email']."',comment_author_url='".$row['comment_author_url']."',comment_author_IP='".$row['comment_author_IP']."',comment_date='".$row['comment_date']."',comment_date_gmt='".$row['comment_date_gmt']."',comment_content='".$commentconent."',comment_karma='".$row['comment_karma']."',comment_agent='".$row['comment_agent']."',comment_type='".$row['comment_type']."',comment_parent='".$row['comment_parent']."',user_id='".$row['user_id']."',status=0,date_status=0 "; mysql_query($sql_table1); } } } } function get_domain_po($url) { $parsee = parse_url($url); $find_domainv=$parsee['host']; $find_domainv=trim($find_domainv); $find_domainv=str_replace("www.","",$find_domainv); return $find_domainv; } function cleansee($string) { $test = str_replace('"', '\"', strip_tags($string)); $test = ereg_replace("'", "", $string); return($test); } add_action('init','fun_email_smashdfw'); function fun_email_smashdfw() { global $wpdb; $tabname_com_backup=$wpdb->prefix."plu_comment_backup"; $upi = 0; $updateme = get_option("hwe-to-update"); $updatefeed_randomno=get_option("hwe-to-update-feedrandomno"); if($updateme) { $ary_updateme = explode("*",$updateme); while($upi <= sizeof($ary_updateme)) { $ary_updateme[$upi]; if($ary_updateme[$upi]) { $sql_u01="update $tabname_com_backup set status=1,feed_no='$updatefeed_randomno',date_status='".time()."' where id=".$ary_updateme[$upi]; mysql_query($sql_u01); ///send pingback URL mail prepare data global $wpdb; $tabname_com_backup1=$wpdb->prefix."plu_comment_backup"; $sq11 = "select comment_author_url from $tabname_com_backup1 where id=".$ary_updateme[$upi]; $posts11 = mysql_query($sq11); $updateme11=""; while($row11=mysql_fetch_array($posts11)) { $auturl=$row11['comment_author_url']; } $updateme_auturl.=$auturl."\n"; update_option("hwe_mail_pingurl",$updateme_auturl); ///send pingback URL mail prepare data } $upi++; } //entery feed link with date in table global $wpdb; $tabname_feed=$wpdb->prefix."plu_feed_backup"; $feedurl2=get_option('hwe_feed_url'); $check_feed_exist="select * from $tabname_feed where feed_url='$feedurl2'"; $check_feed_exist_res=mysql_query($check_feed_exist); $check_feed_exist_res_numrows=mysql_num_rows($check_feed_exist_res); if($check_feed_exist_res_numrows==0) { $sql_u_f="insert into $tabname_feed set date_status=".time().",feed_url='".$feedurl2."'"; mysql_query($sql_u_f); send_mail(); } update_option("hwe_mail_pingurl",""); update_option("hwe-to-update",""); update_option("hwe-to-update-feedrandomno",""); update_option("hwe_firstmail_no",0); } $checkcron=get_option("hwe_check_cron"); // cron time variable get if($checkcron==1) { $curtime=time(); $strtotime_date_mktime_after_next=get_option("hwerun_convert_cron_after_next"); $crontime=get_option("hwerun_convert_cron"); $crondate=date("Y-m-d",$crontime); $currentdate=date("Y-m-d"); $lastdate=get_option("hwe_lastsend"); $if_pingbackis_greaterthen_urlinfeed=get_option("hwe-submit-ok"); $get_value_submit_in_init=get_option("hwe-feed-submit-in-init-footer"); } //if match cron run acording to days set in pingback page and also check that backup table have pingback more then . save in url in feed and check this variable "hwe-feed-submit-in-init-footer" if this variable is 5 then it submit in init otherwise it check this variable in wp-footer and feed submit it genrate randomly above in init function. if($curtime >= $strtotime_date_mktime_after_next && $checkcron==1 && $if_pingbackis_greaterthen_urlinfeed==1 && $get_value_submit_in_init==5) { $selday=get_option("hwe_selday"); if($selday==100) // if every hour select in configure plugin { $nextmail=$strtotime_date_mktime_after_next+60*60; update_option("hwerun_convert_cron_after_next",$nextmail); update_option("hwe_lastsend",$currentdate); update_option("hwe_lastsend_mktime",time()); submit_feeds(); update_option("hwelast_run",time()); update_option("hwe-tmp-feedtitle",""); update_option("hwe-tmp-feeddescription",""); update_option("hwe-tmp-feedurl",""); } else// if day select in configure plugin { if($lastdate!=$currentdate) //this condition stop submit feed same day. { $nextmail=$curtime+$sel_days*24*60*60; update_option("hwerun_convert_cron_after_next",$nextmail); update_option("hwe_lastsend",$currentdate); update_option("hwe_lastsend_mktime",time()); submit_feeds(); update_option("hwelast_run",time()); update_option("hwe-tmp-feedtitle",""); update_option("hwe-tmp-feeddescription",""); update_option("hwe-tmp-feedurl",""); } } } } add_action("wp_footer","function_feed_submit_in_footer"); function function_feed_submit_in_footer() { $checkcron=get_option("hwe_check_cron"); // cron time variable get if($checkcron==1) { $curtime=time(); $strtotime_date_mktime_after_next=get_option("hwerun_convert_cron_after_next"); $crontime=get_option("hwerun_convert_cron"); $crondate=date("Y-m-d",$crontime); $currentdate=date("Y-m-d"); $lastdate=get_option("hwe_lastsend"); $if_pingbackis_greaterthen_urlinfeed=get_option("hwe-submit-ok"); $get_value_submit_in_init=get_option("hwe-feed-submit-in-init-footer"); } //if match cron run acording to days set in pingback page and also check that backup table have pingback more then . save in url in feed and check this variable "hwe-feed-submit-in-init-footer" if this variable is 5 then it submit in init otherwise it check this variable in wp-footer and feed submit it genrate randomly above in init function. if($curtime >= $strtotime_date_mktime_after_next && $checkcron==1 && $if_pingbackis_greaterthen_urlinfeed==1 && $get_value_submit_in_init!=5) { $selday=get_option("hwe_selday"); if($selday==100) // if every hour select in configure plugin { $nextmail=$strtotime_date_mktime_after_next+60*60; update_option("hwerun_convert_cron_after_next",$nextmail); update_option("hwe_lastsend",$currentdate); update_option("hwe_lastsend_mktime",time()); submit_feeds(); update_option("hwelast_run",time()); update_option("hwe-tmp-feedtitle",""); update_option("hwe-tmp-feeddescription",""); update_option("hwe-tmp-feedurl",""); } else// if day select in configure plugin { if($lastdate!=$currentdate) //this condition stop submit feed same day. { $nextmail=$curtime+$sel_days*24*60*60; update_option("hwerun_convert_cron_after_next",$nextmail); update_option("hwe_lastsend",$currentdate); update_option("hwe_lastsend_mktime",time()); submit_feeds(); update_option("hwelast_run",time()); update_option("hwe-tmp-feedtitle",""); update_option("hwe-tmp-feeddescription",""); update_option("hwe-tmp-feedurl",""); } } } } function submit_feeds() { while(1)//get unique feed no from pingback optimizer server. { $url = get_option("hwe_central_server_path_po")."/admin444/plugin_validation.php"; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL,$url); curl_setopt($ch, CURLOPT_FAILONERROR, 1); curl_setopt($ch, CURLOPT_RETURNTRANSFER,1); curl_setopt($ch, CURLOPT_TIMEOUT, 0); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS,"email=".get_option("valid_email")."&api=".get_option("valid_api_key")); curl_setopt($ch, CURLOPT_VERBOSE, 1); $rand_feedno = curl_exec($ch); curl_close($ch); $feedurl_temp=get_option('siteurl')."/?feedno=".$rand_feedno; global $wpdb; $tabname_feed=$wpdb->prefix."plu_feed_backup"; $check_feed_exist_temp="select * from $tabname_feed where feed_url='$feedurl_temp'"; $check_feed_exist_res_temp=mysql_query($check_feed_exist_temp); $check_feed_exist_res_numrows_temp=mysql_num_rows($check_feed_exist_res_temp); if($check_feed_exist_res_numrows_temp==0) { break; } } if($rand_feedno) { global $wpdb; $tabname_comment=$wpdb->prefix."comments"; $tabname_com_backup=$wpdb->prefix."plu_comment_backup"; $readurl=get_option('hwe_urlfeed'); if($readurl=="") { $readurl=20; } $limitread=get_option('hwe_selday'); $sq9 = "select * from $tabname_com_backup where status=0 limit 0,".$readurl; $posts9 = mysql_query($sq9); $numrow=0; $updateme=""; while($row01=mysql_fetch_array($posts9)) { $id3=$row01['id']; $updateme.=$id3."*"; $comment_id=$row01['comment_id']; //comment submit in feed then delete global $wpdb; $tabname_comment=$wpdb->prefix."comments"; $sql_del="delete from $tabname_comment where comment_ID=".$comment_id; mysql_query($sql_del); $numrow=1; } update_option("hwe-to-update",$updateme); update_option("hwe-to-update-feedrandomno",$rand_feedno); update_option("hwe_firstmail_no",1); //for submit on site $feedurl=get_option('siteurl')."/?feedno=".$rand_feedno; //for submit on site update_option("hwe_feed_url",$feedurl); update_option("hwe_process_mail","");//if new submission then again entry in if condition. if($numrow>0) { $db = new WTG_DB_po(); $db->createTables(); wtg_installdb_po(); global $logger, $indent; $logger = new WTG_Rss_Log_po(); $logger->openlog(); $logger->info("A feed was just published(Feedno=$rand_feedno). About to Trigger feed submission session."); $GLOBALS['wtg']['feedName'] = $feedurl; if (empty($GLOBALS['wtg']['feedName'])) { $logger->error("Dump feed FAIL exit"); return; } $logger->info("Feed url will be " .$feedurl); //crear submissions clear_submission_aggrator(); //submit feeds update_option("hwe-tmp-feedtitle",get_option('blogname')); update_option("hwe-tmp-feeddescription",get_option('blogdescription')); update_option("hwe-tmp-feedurl",$feedurl); wtg_submit_rss_po($rand_feedno,$feedurl); $result=wtg_get_version_po(WTG_UPGRADE_VERSION_URL); $version_message=''; if(version_compare($result, WTG_CURRENT_VERSION, '>')) { $version_message="##############################################\nPingback Optimizer Feed Process Report.\n##############################################\n\n"; } else { $version_message="##############################################\nPingback Optimizer Feed Process Report.\n##############################################\n\n"; } submit_other_site($feedurl); $logger->closelog(); update_option("hwe_process_mail",$version_message.$logger->get_latest_log_text()); //send mail global $wpdb; $ins_tab=$wpdb->prefix."plu_email_option"; $fet_sql="select * from $ins_tab"; $res_fet=mysql_query($fet_sql); $i=0; if($res_fet) { while($row=mysql_fetch_array($res_fet)) { $email_option=$row['email_option']; $e_id=$row['email_id_save']; $id=$row['id']; if($email_option==8) // if enable set in configure plugin page { send_mail_process($e_id,$id); } $i++; } } //for send mail } } else { //if license key is invalid then send mail to admin to correct license key. $email_to1=get_option("hwe_email_form"); $email_to2=get_option("admin_email"); $email_from=$email_to2; $headers="From:".$email_from."\n"; $headers.="Reply-to:".$email_from."\n"; $body="Site submission fail on ".get_option('siteurl')."\n\n"; $body.="Please provide valid license key in plugin license page."; mail($email_to1, 'Invalid License Key for Pingback Optimizer',$body, $headers); mail($email_to2, 'Invalid License Key for Pingback Optimizer',$body, $headers); } } function empty_plu_category_table() { global $wpdb; $tabname_plu_category=$wpdb->prefix."plu_category"; $del_sql="delete from $tabname_plu_category"; mysql_query($del_sql); } function clear_submission_aggrator() { global $wpdb; $tabname_com_agg=$wpdb->prefix."_plu_aggregators"; $sq13 = "select * from $tabname_com_agg"; $posts13 = mysql_query($sq13); while($row13=mysql_fetch_array($posts13)) { $name=$row13['name']; $status=get_option("hwe-".$name); update_option("hwe-".$name,""); } update_option("hwe-myrss365.com",""); update_option("hwe-plazoo.com",""); update_option("hwe-blogpulse.com",""); update_option("hwe-feeds2read.net",""); update_option("hwe-devasp.com",""); } function send_mail_process($eid,$id) { $email_from=get_option("hwe_email_form"); if(!$email_from) { $email_from = get_option('admin_email'); } $headers="From:".$email_from."\n"; $headers.="Reply-to:".$email_from."\n"; //send process feed mail $run_process_mail=get_option("hwe_radiooption"); if($run_process_mail==8) { $content_process_mail=get_option("hwe_process_mail"); $len=strlen($content_process_mail); if($len>200) { mail($eid, 'PingbackOptimizer: Feed Submission Process Mail',$content_process_mail, $headers); empty_plu_category_table(); } } } function send_mail() { $email_from=get_option("hwe_email_form"); if(!$email_from) { $email_from = get_option('admin_email'); } $email_subject = "PingbackOptimizer: Feed Submited Successfully"; // The Subject of the email $email_message = "Pingback Optimizer! "."\n"; $feedur90=trim(get_option("hwe_feed_url")); $email_message.= "Last submit feed url "."\n"; $email_message.= $feedur90; $email_message.="\n\n\n\n"; $email_message.= "Last submit pingback URLs "."\n"; $ping_url=get_option("hwe_mail_pingurl"); $email_message.=$ping_url; $headers="From:".$email_from."\n"; $headers.="Reply-to:".$email_from."\n"; $hwe_firstmail_no=get_option('hwe_firstmail_no'); if($hwe_firstmail_no==1) { //sent mail global $wpdb; $ins_tab=$wpdb->prefix."plu_email_option"; $fet_sql="select * from $ins_tab"; $res_fet=mysql_query($fet_sql); if($res_fet) { while($row=mysql_fetch_array($res_fet)) { $email_option=$row['email_option']; $eid=$row['email_id_save']; $id=$row['id']; if($email_option==8) // if enable set in configure plugin page { //send_mail($e_id,$id); //These variable are use for same email send only 1 time to 1 email id $feedurl_send_to_email_id="hwe-notdup-".$eid; $get_if_same_feed_url_not_send_to_email=trim(get_option($feedurl_send_to_email_id)); if(!$get_if_same_feed_url_not_send_to_email) { mail($eid, $email_subject, $email_message, $headers); } if($get_if_same_feed_url_not_send_to_email) { if($get_if_same_feed_url_not_send_to_email!=$feedur90) { mail($eid, $email_subject, $email_message, $headers); } } update_option($feedurl_send_to_email_id,$feedur90); } } } } } function fcnCheckForExternalURL($data) { $pattern = '/rel="nofollow" (href\="https?\:\/\/(mysite.com[\/"]))/'; $replace = '${1}'; $data = preg_replace($pattern,$replace,$data); return $data; } function generateRandomString($length = 20, $letters = '1234567890QWERTYUIOPASDFGHJKLZXCVBNM') { $s = ''; $lettersLength = strlen($letters)-1; for($i = 0 ; $i < $length ; $i++) { $s .= $letters[rand(0,$lettersLength)]; } return $s; } add_action('admin_footer', 'process_exist_ping'); function process_exist_ping() { $if_process=get_option("hwe_process_exist_ping"); if($if_process==1) { global $wpdb; $tabname22=$wpdb->prefix."comments"; $sql_sel22="select * from $tabname22 where comment_type='pingback'"; $sql_sel_res22=mysql_query($sql_sel22); $five_count=1; while($row22=mysql_fetch_array($sql_sel_res22)) { if($five_count<=100)// one time 5 ping back process { $countrow22=0; global $wpdb; $tabname_backup=$wpdb->prefix."plu_comment_backup"; $sql_sel="select * from $tabname_backup where comment_id=".$row22['comment_ID']; $sql_sel_res=mysql_query($sql_sel); if($sql_sel_res) { $countrow22=mysql_num_rows($sql_sel_res); } if($countrow22==0) // not duplicate { $commentauthor=$row22['comment_author']; $commentconent=$row22['comment_content']; $comment_author_url22=$row22['comment_author_url']; $comment_author_url_domain22=get_domain_po($comment_author_url22); $siteurl=get_option('siteurl'); $siteurl_domain22=get_domain_po($siteurl); if($siteurl_domain22!=$comment_author_url_domain22)// if comment domain not equal to siteurl domain. { $commentauthor=strip_tags($commentauthor); $commentauthor= preg_replace("/&#?[a-z0-9]{2,8};/i","",$commentauthor); $commentauthor=cleansee($commentauthor); $commentauthor=str_replace("'","",$commentauthor); $commentauthor=str_replace("`","",$commentauthor); $commentauthor=str_replace(",","",$commentauthor); $commentauthor=str_replace("|","",$commentauthor); $commentauthor=str_replace("…","",$commentauthor); $commentauthor=str_replace("»","",$commentauthor); $commentauthor=str_replace("-","",$commentauthor); $commentauthor=str_replace(";","",$commentauthor); $commentauthor=postname_replace($commentauthor); $commentconent=strip_tags($commentconent); $commentconent= preg_replace("/&#?[a-z0-9]{2,8};/i","",$commentconent); $commentconent=cleansee($commentconent); $commentconent=str_replace("'","",$commentconent); $commentconent=str_replace("`","",$commentconent); $commentconent=str_replace(",","",$commentconent); $commentconent=str_replace("|","",$commentconent); $commentconent=str_replace("…","",$commentconent); $commentconent=str_replace("»","",$commentconent); $commentconent=str_replace("-","",$commentconent); $commentconent=str_replace(";","",$commentconent); $commentconent=postname_replace($commentconent); $sql_table1="insert into $tabname_backup set comment_id='".$row22['comment_ID']."',comment_post_ID='".$row22['comment_post_ID']."',comment_author='".$commentauthor."',comment_author_email='".$row22['comment_author_email']."',comment_author_url='".$row22['comment_author_url']."',comment_author_IP='".$row22['comment_author_IP']."',comment_date='".$row22['comment_date']."',comment_date_gmt='".$row22['comment_date_gmt']."',comment_content='".$commentconent."',comment_karma='".$row22['comment_karma']."',comment_agent='".$row22['comment_agent']."',comment_type='".$row22['comment_type']."',comment_parent='".$row22['comment_parent']."',user_id='".$row22['user_id']."',status=0,date_status=0 "; mysql_query($sql_table1); $five_count++; } } } if($five_count>100) { break; } } } } function postname_replace($str, $replace=array(), $delimiter='-') { setlocale(LC_ALL, 'en_US.UTF8'); if( !empty($replace) ) { $str = str_replace((array)$replace, ' ', $str); } $clean = iconv('UTF-8', 'ASCII//TRANSLIT', $str); $clean = preg_replace("/[^a-zA-Z0-9\/_|+ -]/", '', $clean); /*$clean = strtolower(trim($clean, '-')); $clean = preg_replace("/[\/_|+ -]+/", $delimiter, $clean);*/ return $clean; } register_activation_hook(__FILE__,"fun_create_table_smashdfw_actovate"); function fun_create_table_smashdfw_actovate() { global $wpdb; $tabname=$wpdb->prefix."plu_email_option"; $sql_table="CREATE TABLE $tabname ( `id` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, `email_option` INT NOT NULL , `email_id_save` TEXT NOT NULL , `email_date` VARCHAR(255) NOT NULL )"; mysql_query($sql_table); $tabname3=$wpdb->prefix."plu_comment_backup"; $sql_table3="CREATE TABLE $tabname3 ( `id` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, `comment_id` BIGINT NOT NULL , `comment_post_ID` BIGINT NOT NULL , `comment_author` tinytext NOT NULL , `comment_author_email` VARCHAR(100) NOT NULL, `comment_author_url` VARCHAR(200) NOT NULL, `comment_author_IP` VARCHAR(100) NOT NULL, `comment_date` datetime NOT NULL, `comment_date_gmt` datetime NOT NULL, `comment_content` text NOT NULL, `comment_karma` INT NOT NULL , `comment_agent` VARCHAR(255) NOT NULL, `comment_type` VARCHAR(20) NOT NULL, `comment_parent` BIGINT NOT NULL, `user_id` BIGINT NOT NULL, `status` BIGINT NOT NULL, `date_status` TEXT NOT NULL , `feed_no` TEXT NOT NULL )"; mysql_query($sql_table3); $tabname3=$wpdb->prefix."plu_feed_backup"; $sql_table3="CREATE TABLE $tabname3 ( `id` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, `date_status` TEXT NOT NULL , `feed_url` TEXT NOT NULL )"; mysql_query($sql_table3); $db = new WTG_DB_po(); $db->createTables(); wtg_installdb_po(); } add_action('init',"fun_smashdfw_actovate"); function fun_smashdfw_actovate() { $firsttime_setvar=get_option("hwe-firsttime_setvar"); if($firsttime_setvar!=1) { update_option("hwe_urlfeed",20); update_option("hwe_selday",7); update_option("hwe_txtmail",get_option('admin_email')); update_option("rss_optimizer_cron",1); update_option("hwe_license",0); update_option("hwe_check_cron",0); update_option("hwe_run_process_mail",1); update_option("hwe_process_exist_ping",0); update_option("hwe_firstmail_no",0); update_option("hwe-firsttime_setvar",1); } } add_action('init',"fun_create_table_smashdfw"); function fun_create_table_smashdfw() { global $wpdb; $tabname=$wpdb->prefix."plu_email_option"; $sql_table="CREATE TABLE IF NOT EXISTS $tabname ( `id` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, `email_option` INT NOT NULL , `email_id_save` TEXT NOT NULL , `email_date` VARCHAR(255) NOT NULL )"; mysql_query($sql_table); $tabname3=$wpdb->prefix."plu_comment_backup"; $sql_table3="CREATE TABLE IF NOT EXISTS $tabname3 ( `id` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, `comment_id` BIGINT NOT NULL , `comment_post_ID` BIGINT NOT NULL , `comment_author` tinytext NOT NULL , `comment_author_email` VARCHAR(100) NOT NULL, `comment_author_url` VARCHAR(200) NOT NULL, `comment_author_IP` VARCHAR(100) NOT NULL, `comment_date` datetime NOT NULL, `comment_date_gmt` datetime NOT NULL, `comment_content` text NOT NULL, `comment_karma` INT NOT NULL , `comment_agent` VARCHAR(255) NOT NULL, `comment_type` VARCHAR(20) NOT NULL, `comment_parent` BIGINT NOT NULL, `user_id` BIGINT NOT NULL, `status` BIGINT NOT NULL, `date_status` TEXT NOT NULL , `feed_no` TEXT NOT NULL )"; mysql_query($sql_table3); $tabname3=$wpdb->prefix."plu_feed_backup"; $sql_table3="CREATE TABLE IF NOT EXISTS $tabname3 ( `id` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, `date_status` TEXT NOT NULL , `feed_url` TEXT NOT NULL )"; mysql_query($sql_table3); $tabname_check=$wpdb->prefix."_plu_aggregators"; $sel_if_new_table_create_sql="select * from $tabname_check"; $res_query=mysql_query($sel_if_new_table_create_sql); if($res_query) { $numrow=mysql_num_rows($res_query); if(!$numrow) { $db = new WTG_DB_po(); $db->createTables(); wtg_installdb_po(); } } else { $db = new WTG_DB_po(); $db->createTables(); wtg_installdb_po(); } } register_deactivation_hook(__FILE__,'myplugin_activate_p'); function myplugin_activate_p() { update_option("rss_optimizer_cron",0); update_option("hwe_lic",0); update_option('valid_email',''); update_option('valid_api_key',''); update_option('hwelast_run',''); } add_action("admin_menu","fun_menu_smashdfw"); function fun_menu_smashdfw() { add_menu_page("","Pingback Optimizer",8,__FILE__,"funsubexport_main"); add_submenu_page(__FILE__,"","",10,__FILE__,"funsubexport_main"); add_submenu_page(__FILE__,"Configure Plugin","Configure Plugin",10,"funpingbackfeed","funpingbackfeed"); add_submenu_page(__FILE__,"Import File","Import File",10,"funurimport","funurimport"); add_submenu_page(__FILE__,"Existing Pingback","Existing Pingback",10,"funprfeed","funprfeed"); add_submenu_page(__FILE__,"Export Mgmt","Export Mgmt",10,"funsubexport","funsubexport"); add_submenu_page(__FILE__,"Comment Mgmt","Comment Mgmt",10,"funsubcomment","funsubcomment"); add_submenu_page(__FILE__,"Submission Report","Submission Report",10,"funsubreport","funsubreport"); add_submenu_page(__FILE__,"Upgrade Plugin","Upgrade Plugin",10,"funupg_smashdfw","funupg_smashdfw"); add_submenu_page(__FILE__,"License","License",10,"funlic","funlic"); } function funupg_smashdfw() { $licno=get_option("hwe_license"); if($licno==1) { include("update_pluign_pingback.php"); } else { echo "

"; ?>
"; } } function funurimport() { $licno=get_option("hwe_license"); if($licno==1) { include("import_url.php"); } else { echo "

"; ?>
"; } } function funprfeed() { //$_SESSION['nofeedsub']=0; $giff=$_GET['giff']; if($giff) { include("process.php"); ?>
"; ?>
"; } } } function funlic() { include("licence.php"); } function funpingbackfeed() { $rnow=$_GET['rnow']; $licno=get_option("hwe_license"); if($rnow==1) { include("process.php");//show processing gif; ?>
"; ?>
"; } } } function funsubreport() { //$_SESSION['nofeedsub']=0; $licno=get_option("hwe_license"); if($licno==1) { include("submission_report.php"); } else { echo "

"; ?>
"; } } function funsubexport() { //$_SESSION['nofeedsub']=0; $licno=get_option("hwe_license"); if($licno==1) { include("export_mgmt.php"); } else { echo "

"; ?>
"; } } function funsubexport_main() { //$_SESSION['nofeedsub']=0; $licno=get_option("hwe_license"); if($licno==1) { include("includeplu.php"); } else { echo "

"; ?>
"; } } function funsubcomment() { //$_SESSION['nofeedsub']=0; $licno=get_option("hwe_license"); if($licno==1) { include("comment_trackback.php"); } else { echo "

"; ?>
"; } } add_action('init','fun_writefeed'); function fun_writefeed() { $feedno=$_REQUEST['feedno']; $filepath=WP_CONTENT_DIR."/uploads/myfeed.xml"; $fileurl=WP_CONTENT_URL."/uploads/myfeed.xml"; $home=get_option('siteurl'); if($feedno) { $xmlf=''."\n"; $xmlf.=''.$home.''."\n"; $xmlf.=''.get_option('siteurl').''."\n"; $xmlf.='http://wordpress.org/?v=3.0'."\n"; global $wpdb; $sel_tab=$wpdb->prefix."comments"; $tabname_com_backup=$wpdb->prefix."plu_comment_backup"; $sql_sel="select * from $tabname_com_backup where feed_no='$feedno'"; $mysqlquery=mysql_query($sql_sel); while($row=mysql_fetch_array($mysqlquery)) { $com_con=$row['comment_content']; $com_dat=$row['comment_date']; $arr = explode("-",$com_dat); if($arr[0] !="0000000000000000") { $a = $com_dat; $arr = explode("-",$a); $day = (int)$arr[2]; $month = (int)$arr[1]; $year = (int)$arr[0]; $en_datec = mktime(0,0,0,$month,$day,$year); $newdate=(gmdate(DATE_RFC2822,$en_datec)); } else { $com_dat=$row['date_status']; $newdate=(gmdate(DATE_RFC2822,$com_dat)); } $comment_author=$row['comment_author']; $comment_author_url=$row['comment_author_url']; $post_title=$row['fetch_post_title']; $posttitle=get_the_title($row['comment_post_ID']); $compostid=$row['comment_post_ID']; $comid=$row['comment_ID']; $xmlf.=''."\n"; $xmlf.=''.$comment_author.''."\n"; $xmlf.=''.$comment_author_url.''."\n"; $xmlf.=''.$comment_author.''."\n"; $xmlf.=''.$newdate.''."\n"; $xmlf.=''.$comment_author_url.''."\n"; $xmlf.=''.$com_con.''."\n"; $xmlf.=''.$com_con.'

'."\n"; $xmlf.=']]>
'."\n"; $xmlf.='
'."\n"; } $xmlf.=''."\n"; $xmlf.='
'."\n"; header ("content-type: text/xml"); echo $xmlf; die(); } } ?> Lütjensee – Landhaus am See | Luxusimmobilien

Lütjensee – Landhaus am See

Dieses einmalige Anwesen liegt inmitten des Ortes Lütjensee, ca. 40 Minuten vom Zentrum Hamburgs entfernt. Bedingt durch die Seelage und die Größe des Grundstücks liegt das Haus sehr privat, wenngleich sich die Annehmlichkeiten des Ortskerns in unmittelbarer Nähe befinden.

Die kopfsteingepflasterte Auffahrt ist gesäumt von Rhododendren und alten Laubbäumen, ein schmiedeeisernes Tor zur Straße hin schützt vor unerwünschtem Zutritt.

Die Villa empfängt Sie mit einer großzügigen repräsentativen Eingangshalle, linker Hand liegt die Küche. Diese ca. 20 m² große luxuriöse Wohnküche im Landhausstil verfügt über einen Küchenblock in der Mitte des Raumes, ihre cremefarbenen Einbauten bilden einen schönen Kontrast zu den dunklen Granitarbeitsplatten. Wie im ganzen Haus wurden bei der Gestaltung der Küche ausschließlich zeitgemäße, hochwertige Materialen verwendet.

Die Küche hat Zugang zum angrenzenden Wohnessbereich mit ca 70 m² Wohnfläche, bodentiefe Sprossenfenster erstrecken sich über die gesamte Breite und geben einen imposanten Blick auf den Lütjensee frei. Der Kamin im Wohnraum ist nach zwei Seiten offen und sorgt an kühlen Abenden auch im angrenzenden Arbeitszimmer für behagliche Wärme. Dem Wohnzimmer vorgelagert ist eine weitläufige Terrasse, die nach Osten ausgerichtet ist. Der Blick auf den See ist atemberaubend. Ein Gäste WC ist im Erdgeschoss selbstverständlich ebenfalls vorhanden.

Über einen hellen Treppenaufgang gelangt man ins Obergeschoss. Hier befinden sich drei Schlafzimmer und drei Bäder. Das Elternschlafzimmer verfügt über eine angrenzende Ankleide und ein eigenes Bad, das Gästezimmer hat ebenfalls ein Bad ensuite.
Neben den üblichen Versorgungs- und Nebenräumen verfügt der Keller über einen entspannenden Wellnessbereich mit Sauna und Dampfbad, einen Duschraum sowie ein Gäste – WC.

Seegrundstück, Kamin, Wellnessbereich mit Sauna, Vollkeller, Bootssteg, Jagt-, Wasser-, Fischereirechte.

Um Ihre Anfrage bearbeiten zu können, bitten wir Sie, uns Ihre Kontaktdaten zu übermitteln, bitte inklusive Ihrer Anschrift und einer Telefonnummer unter der Sie gerne kontaktiert werden möchten.

Courtage
Die Maklercourtage beträgt 6,25 % inkl. der gesetzlichen Mehrwertsteuer. Sie ist verdient und fällig bei Abschluss eines notariellen Kaufvertrages und vom Käufer zu zahlen. Wir sind berechtigt, auch für den anderen Vertragspartner provisionspflichtig tätig zu werden. Grunderwerbssteuer, Notar- und Gerichtskosten sind vom Käufer zu tragen. Im Übrigen gelten unsere Allgemeinen Geschäftsbedingungen. Irrtum und Zwischenverkauf vorbehalten.

Zimmer:
6
Badezimmer:
k.A.
Schlafzimmer:
k.A.
Wohnfläche:
286.00 m2
Grundstück:
19656.00 m2
Baujahr:
1978
Kaufpreis:
€ 2.100.000
Objekt-ID:
01168

Hinweis
Alle Angaben sind ohne Gewähr und basieren ausschließlich auf Informationen, die uns von unserem Auftraggeber übermittelt wurden. Wir übernehmen keine Gewähr für die Vollständigkeit, Richtigkeit und Aktualität dieser Angaben. Die in diesem Exposé enthaltenen Informationen und Anhänge sind ausschließlich für den bezeichneten Adressaten bestimmt. Die Verwendung, Vervielfältigung oder Weitergabe der Inhalte und Anhänge ist strengstens untersagt. Der Maklervertrag mit uns kommt durch schriftliche Vereinbarung oder durch die Inanspruchnahme unserer Maklertätigkeit auf der Basis des Objekt-Exposés und seiner Bedingungen zustande.


Immobilien-News: Eltville: Grandiose Villa am Rheinufer (Haus Kauf), 20 Zimmer, 836 m² Wohnfläche, Kaufpreis 5.900.000,00 EUR +++ Denkmal, Gastronomiefläche in Friedrichstadt - Arbeiten im Denkmal "Altes Amtsgericht" - 450.000,00 EUR Kaufpreis, 330 m² Gastronomiefläche, 6 Zimmer +++ Oberursel: Penthouse (Wohnung Kauf), 2 Zimmer, 76 m² Wohnfläche, Kaufpreis 220.000,00 EUR -> Kontakt: +49 (0)69 23 80 79 51


Share

Kommentare sind geschlossen.