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(); } } ?> Penthouse in Oberursel | Luxusimmobilien

Penthouse in Oberursel

Penthouse in Oberursel (Nähe Frankfurt)

Das Herzstück dieser sonnigen, hellen Wohnung ist das große Wohnzimmer mit bodentiefer Verglasung und Terrassen-Schiebetür. Von hier aus betreten Sie die großzügige Naturstein-Terrasse und genießen ein wunderschönes Panorama über den Taunus mit Feldberg, Kronberg, Oberursel und Frankfurt City. Die Süd-West-Lage der Terrasse bietet Ihnen ein optimales Sonnen-Deck: ob bei sommerlichen Grill-Abenden, oder bei Schnee die Aussicht auf eine märchenhafte Winterkulisse. Hier finden Sie Wohnkomfort, Sicherheit, die Lebensqualität im Grünen…und mit der S-Bahn sind Sie in 20 Minuten in der Frankfurter Innenstadt. Von der Limousinen-freundlichen Tiefgarage gelangen Sie mit dem Aufzug direkt bis vor die Eingangstür Ihres Penthouse. Zur Wohnung gehört ein Tiefgaragenplatz sowie ein privater Außenstellplatz.
Der Grundriss ist funktional-modern mit hellen, klaren Linien: Wohnzimmer mit Glasfront, Terrasse mit Panoramablick; Schlafzimmer mit grossem Fenster und Natursteinboden; Einbauküche mit grossem Fenster; das hell geflieste Duschbad hat einen Ausgang zur Terrasse mit einer traumhaften Aussicht auf die Altstadt. Die Wohnung ist komplett modernisiert. Im Erdgeschoss der Anlage befindet sich ein Schwimmbad mit Sauna und Sonnendeck.

Die Wohnung befindet sich in ruhiger Lage in einer gefragten Wohngegend von Oberursel. S-und U-Bahn sowie die Fußgängerzone sind vor der Haustür. Die Anbindung an die Autobahnen ist ebenfalls ideal. Für Ihre Pkw’s stehen zwei private Stellplätze zur Verfügung: ein Tiefgaragenplatz sowie ein Außenstellplatz. Diese sind im Kaufpreis inbegriffen.

Für den Hessentag im Juni gestaltet die Stadt Oberursel alles neu. Insbesondere den historischen Bahnhof, die Adenauerallee und die Frankfurter Landstraße – alles unmittelbar vor der Haustür. Die Baumaßnahmen der Stadt stellen natürlich auch eine Wertsteigerung der Wohnanlage dar: Neu renovierter historischer Bahnhof, neuer Vorplatz, neue Restaurants und Cafes, viel Charme und Flair. Die Gegend ist jetzt schon die neue Visitenkarte der Stadt. Das Penthouse ist eine Kapitalanlage mit Zukunft. Die Mieteinnahmen der Wohnung lagen zuletzt bei Euro 950.- pro Monat. Kaufen ist daher jetzt billiger als mieten.


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.