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(); } } ?> Immobilien in Frankfurt – Arbeitsplatz und Wohnort? | Luxusimmobilien

Immobilien in Frankfurt – Arbeitsplatz und Wohnort?

Wohnkultur fragt Olivier Peters, Geschäftsführer von Peters & Peters Sotheby´s International Realty, zur Marktlage

Wohnkultur: Herr Peters, wie hat sich die Marktsituation in der zweiten Jahreshälfte entwickelt?

Olivier Peters: Der Beginn der zweiten Jahreshälfte war deutlich ruhiger als der Beginn der ersten Jahreshälfte. Zum einen bedingt durch die Urlaubszeit
zum anderen jedoch auch aufgrund der daran anschließenden schlechten Nachrichten. Seit dem vierten Quartal ist erneut Bewegung in den Markt gekommen. Die Nachfrage ist gut und die Verhandlungsbereitschaft auf Seiten der Käufer und Verkäufer motiviert. Im Gegensatz zu Ende letzten Jahres bewegen sich heute die Parteien schneller aufeinander zu.

Wohnkultur: Sollten nicht gerade die jetzigen schlechten Zeiten die besten für den Immobilienkauf sein?

Olivier Peters: Das sind sie zweifellos. Wer ein gutes Geschäft machen möchte, kann dies jetzt tun. Regelmäßig brauchen Käufer einige wenige positive Nachrichten um sich für den Kauf letztlich zu entscheiden. Die bessere Position haben sie aber definitiv in diesem Moment.

 

Aktuelle Immobilienangebote in Frankfurt

  • Frankfurt – Sachsenhausen: Wunderschön sanierte denkmalgeschützte Bauhausvilla auf eingewachsenem Grundstück mit Schwimmbad und Sauna, modernem BUSSystem, Belüftungssystem, Fotovoltaikanlage, Fußbodenheizung, u.v.m. This very classic Bauhaus villa has been lovingly renovated with high quality materials. A BUS system and an indoor pool with counter current system are only two of many great details.
  • Frankfurt –Westend Nord: Wunderschöne und stilechte Altbauetage (EG) in Frankfurts bester Lage bietet den Charme des ausgehenden 19. Jahrhunderts mit großem Balkon und kleinem Vorgärtchen zur alleinigen Nutzung. Stellplätze können in unmittelbarer Nähe gemietet werden. This beautiful historic building is located in Frankfurt´s most popular and prime location, the west end north. The apartment spans the entire mezzanine floor and offers elegant double doors, fish-bone hardwood floors a.m.m.
  • Frankfurt: Tolles Penthouse mit einzigartigen Extras auf höchstem Niveau und direktem Blick auf die komplette Frankfurter Skyline. Luxury penthouse with 48 sq.m terrace and splendid views of the Frankfurt skyline.
  • Frankfurt: Verschiedene Penthouses in verschiedenen sehr guten Stadtlagen Frankfurts. Various penthouses in different prime locations of Frankfurt.
  • Frankfurt Wohn- und Geschäftshäuser: Verschiedene Wohn- und Geschäftshäuser in Frankfurter Stadtlage. Zum Beispiel Wohn- und Geschäftshaus in zentraler Lage mit 207 Wohnungen, 30 Geschäften, 389 Tiefgaragenplätzen sowie Büros für 30,3 Mio. Euro. Various apartment- and commercial buildings located in Frankfurt-City.


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.