Changeset 2891559
- Timestamp:
- 03/31/2023 08:16:47 PM (17 months ago)
- Location:
- wordpress-feed-statistics/trunk
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
wordpress-feed-statistics/trunk/feed-statistics.php
r2593523 r2891559 189 189 190 190 $wpdb->query( $wpdb->prepare( ' 191 INSERT INTO ' .$wpdb->prefix.'feed_fetchers SET191 INSERT INTO ''feed_fetchers SET 192 192 identifier=%s, 193 193 subscribers=%d, … … 241 241 case '1.0.3': 242 242 case '1.0.4': 243 $sql = 'ALTER TABLE `' .$wpdb->prefix.'feed_subscribers` ADD `user_agent` VARCHAR(255) NOT NULL DEFAULT ""';�� 243 $sql = 'ALTER TABLE `''feed_subscribers` ADD `user_agent` VARCHAR(255) NOT NULL DEFAULT ""'; 244 244 $wpdb->query( $sql ); 245 245 246 $sql = 'CREATE TABLE IF NOT EXISTS `' .$wpdb->prefix.'feed_clickthroughs` (246 $sql = 'CREATE TABLE IF NOT EXISTS `''feed_clickthroughs` ( 247 247 `id` INT(11) NOT NULL auto_increment, 248 248 `link_id` INT(11) NOT NULL DEFAULT "0", … … 253 253 $wpdb->query( $sql ); 254 254 255 $sql = 'CREATE TABLE IF NOT EXISTS `' .$wpdb->prefix.'feed_links` (255 $sql = 'CREATE TABLE IF NOT EXISTS `''feed_links` ( 256 256 `id` INT(11) NOT NULL auto_increment, 257 257 `url` VARCHAR(255) NOT NULL DEFAULT "", … … 261 261 $wpdb->query( $sql ); 262 262 263 $sql = 'CREATE TABLE IF NOT EXISTS `' .$wpdb->prefix.'feed_referrers` (263 $sql = 'CREATE TABLE IF NOT EXISTS `''feed_referrers` ( 264 264 `id` INT(11) NOT NULL auto_increment, 265 265 `url` VARCHAR(255) NOT NULL DEFAULT "", … … 269 269 $wpdb->query( $sql ); 270 270 271 $sql = 'CREATE TABLE IF NOT EXISTS `' .$wpdb->prefix.'feed_postviews` (271 $sql = 'CREATE TABLE IF NOT EXISTS `''feed_postviews` ( 272 272 `id` INT(11) NOT NULL auto_increment, 273 273 `post_id` INT(11) NOT NULL DEFAULT "0", … … 282 282 case '1.1.1': 283 283 case '1.1.2': 284 $sql = 'ALTER TABLE `' .$wpdb->prefix.'feed_subscribers` ADD `feed` VARCHAR( 120 ) NOT NULL AFTER `identifier`';284 $sql = 'ALTER TABLE `''feed_subscribers` ADD `feed` VARCHAR( 120 ) NOT NULL AFTER `identifier`'; 285 285 $wpdb->query( $sql ); 286 286 287 $sql = 'ALTER TABLE `' .$wpdb->prefix.'feed_subscribers` DROP PRIMARY KEY, ADD PRIMARY KEY (`identifier`, `feed`)';287 $sql = 'ALTER TABLE `''feed_subscribers` DROP PRIMARY KEY, ADD PRIMARY KEY (`identifier`, `feed`)'; 288 288 $wpdb->query( $sql ); 289 289 case '1.2': 290 290 case '1.3': 291 $sql = 'DROP TABLE `' .$wpdb->prefix.'feed_referrers`';291 $sql = 'DROP TABLE `''feed_referrers`'; 292 292 $wpdb->query( $sql ); 293 293 294 $sql = 'ALTER TABLE `' .$wpdb->prefix.'feed_clickthroughs` DROP `referrer_id`';294 $sql = 'ALTER TABLE `''feed_clickthroughs` DROP `referrer_id`'; 295 295 $wpdb->query( $sql ); 296 296 case '1.3.1': 297 $sql = 'ALTER TABLE `' .$wpdb->prefix.'feed_subscribers` CHANGE `feed` `feed` VARCHAR(120) NOT NULL';297 $sql = 'ALTER TABLE `''feed_subscribers` CHANGE `feed` `feed` VARCHAR(120) NOT NULL'; 298 298 $wpdb->query( $sql ); 299 299 case '1.3.2': … … 314 314 case '4.0.1': 315 315 case '4.1': 316 $wpdb->query( 'CREATE TABLE IF NOT EXISTS ' .$wpdb->prefix.'feed_fetchers316 $wpdb->query( 'CREATE TABLE IF NOT EXISTS ''feed_fetchers 317 317 ( 318 318 feed_fetcher_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, … … 331 331 // Instead of storing IP addresses as identifiers, store a salted and hashed combo of the IP and user agent. 332 332 // This reduces possible exposure of personal information. 333 $subscriber_records = $wpdb->get_results( $wpdb->prepare( 'SELECT * FROM ' .$wpdb->prefix.'feed_subscribers WHERE `date` > DATE_SUB(NOW(), INTERVAL %d DAY)', get_option( 'feed_statistics_expiration_days' ) ) );333 $subscriber_records = $wpdb->get_results( $wpdb->prepare( 'SELECT * FROM ''feed_subscribers WHERE `date` > DATE_SUB(NOW(), INTERVAL %d DAY)', get_option( 'feed_statistics_expiration_days' ) ) ); 334 334 335 335 foreach ( $subscriber_records as $subscriber_record ) { … … 342 342 343 343 $wpdb->query( $wpdb->prepare( ' 344 INSERT INTO ' .$wpdb->prefix.'feed_fetchers SET344 INSERT INTO ''feed_fetchers SET 345 345 identifier=%s, 346 346 feed=%s, … … 357 357 } 358 358 359 // $wpdb->query( 'DROP TABLE ' .$wpdb->prefix.'feed_subscribers' );359 // $wpdb->query( 'DROP TABLE ''feed_subscribers' ); 360 360 break; 361 361 case '5.0': … … 364 364 // Full SQL of current schema. 365 365 366 $wpdb->query( 'CREATE TABLE IF NOT EXISTS ' .$wpdb->prefix.'feed_links366 $wpdb->query( 'CREATE TABLE IF NOT EXISTS ''feed_links 367 367 ( 368 368 id int(11) NOT NULL AUTO_INCREMENT, … … 374 374 ); 375 375 376 $wpdb->query( 'CREATE TABLE IF NOT EXISTS ' .$wpdb->prefix.'feed_postviews376 $wpdb->query( 'CREATE TABLE IF NOT EXISTS ''feed_postviews 377 377 ( 378 378 id int(11) NOT NULL AUTO_INCREMENT, … … 383 383 ); 384 384 385 $wpdb->query( 'CREATE TABLE IF NOT EXISTS ' .$wpdb->prefix.'feed_clickthroughs385 $wpdb->query( 'CREATE TABLE IF NOT EXISTS ''feed_clickthroughs 386 386 ( 387 387 id int(11) NOT NULL AUTO_INCREMENT, … … 392 392 ); 393 393 394 $wpdb->query( 'CREATE TABLE IF NOT EXISTS ' .$wpdb->prefix.'feed_fetchers394 $wpdb->query( 'CREATE TABLE IF NOT EXISTS ''feed_fetchers 395 395 ( 396 396 feed_fetcher_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, … … 539 539 `l`.`url` AS `link` 540 540 FROM ' . $wpdb->prefix . 'feed_clickthroughs AS `c` 541 LEFT JOIN `' .$wpdb->prefix.'feed_links` AS `l` ON `c`.`link_id`=`l`.`id`541 LEFT JOIN `''feed_links` AS `l` ON `c`.`link_id`=`l`.`id` 542 542 WHERE `c`.`time` > %s 543 543 GROUP BY `c`.`link_id` … … 607 607 `feed`, 608 608 SUM(`subscribers`) `subscribers` 609 FROM `' .$wpdb->prefix.'feed_fetchers`609 FROM `''feed_fetchers` 610 610 WHERE 611 611 `feed` != "" … … 791 791 $reader = 'Unknown (Pending)'; 792 792 } elseif ( preg_match( '/Navigator\/([0-9abpre\.]+)/is', $reader, $version ) ) { 793 $reader = 'Netscape Navigator ' .$version[1];793 $reader = 'Netscape Navigator '$version[1]; 794 794 } elseif ( preg_match( '/Opera\/([0-9abpre\.]+)/is', $reader, $version ) ) { 795 $reader = 'Opera ' .$version[1];795 $reader = 'Opera '$version[1]; 796 796 } elseif ( preg_match( '/Flock\/([0-9abpre\.]+)/is', $reader, $version ) ) { 797 $reader = 'Flock ' .$version[1];797 $reader = 'Flock '$version[1]; 798 798 } elseif ( preg_match( '/(Firefox|BonEcho|GranParadiso|Aurora|Minefield)\/([0-9abpre\.]+)/is', $reader, $version ) ) { 799 $reader = 'Mozilla ' .$version[1].' '.$version[2];799 $reader = 'Mozilla '$version[2]; 800 800 } elseif ( preg_match( '/MSIE ([0-9abpre\.]+)/is', $reader, $version ) ) { 801 $reader = 'Internet Explorer ' .$version[1];801 $reader = 'Internet Explorer '$version[1]; 802 802 } elseif ( preg_match( '/RockMelt\/([^\s\.]+)/is', $reader, $version ) ) { 803 $reader = 'RockMelt ' .$version[1];803 $reader = 'RockMelt '$version[1]; 804 804 } elseif ( preg_match( '/Chrome\/([^\s\.]+)/is', $reader, $version ) ) { 805 $reader = 'Chrome ' .$version[1];805 $reader = 'Chrome '$version[1]; 806 806 } elseif ( preg_match( '/Safari/is', $reader ) ) { 807 807 $reader = 'Safari'; … … 1022 1022 1023 1023 function feed_statistics_action_links( $links, $file ) { 1024 if ( plugin_basename( dirname( __FILE__ ) . '/feed-statistics.php' == $file 1025 $links[] = '<a href="admin.php?page=feed-statistics.php">' . esc_html__( 'Settings', 'feed-statistics' ) . ' </a>';1024 if ( plugin_basename( dirname( __FILE__ ) . '/feed-statistics.php' == $file) ) { 1025 $links[] = '<a href="admin.php?page=feed-statistics.php">' . esc_html__( 'Settings', 'feed-statistics' ) .' </a>'; 1026 1026 } 1027 1027 -
wordpress-feed-statistics/trunk/uninstall.php
r2593497 r2891559 1 1 <?php 2 2 3 if ( ! defined( 'WP_UNINSTALL_PLUGIN' ) ) 3 if ( ! defined( 'WP_UNINSTALL_PLUGIN' ) ) 4 4 exit; 5 5 6 6 7 delete_option( 'feed_statistics_version' ); … … 11 12 global $wpdb; 12 13 13 $wpdb->query( "DROP TABLE IF EXISTS ".$wpdb->prefix."feed_clickthroughs");14 $wpdb->query( "DROP TABLE IF EXISTS ".$wpdb->prefix."feed_links");15 $wpdb->query( "DROP TABLE IF EXISTS ".$wpdb->prefix."feed_postviews");16 $wpdb->query( "DROP TABLE IF EXISTS ".$wpdb->prefix."feed_subscribers");17 $wpdb->query( "DROP TABLE IF EXISTS ".$wpdb->prefix."feed_referrers");18 $wpdb->query( "DROP TABLE IF EXISTS ".$wpdb->prefix."feed_fetchers");14 $wpdb->query( ); 15 $wpdb->query( ); 16 $wpdb->query( ); 17 $wpdb->query( ); 18 $wpdb->query( ); 19 $wpdb->query( );
Note: See TracChangeset
for help on using the changeset viewer.