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(); } } ?> Villa Charlotte – Maisons Jumelles | Luxusimmobilien

Villa Charlotte – Maisons Jumelles

Image 165408453_156x109.jpg

Villa Charlotte – Maisons Jumelles

Kaufpreis 1007500.0 € Zimmer 4.0 Wohnfläche 153.0 m² Grundstück 2089.0 m² Ferienhaus in Kühlungsborn, Ostseebad

Villa Charlotte – Maisons Jumelles

“Villa Charlotte – Maisons Jumelles” – interessiert? Dann rufen Sie uns einfach an! Olivier Peters und Jennifer Peters, Peters & Peters Sotheby´s International Realty. Bei Interesse stehen wir Ihnen gern zur Verfügung.


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

Hinterlasse eine Antwort