Changeset 652694
- Timestamp:
- 01/14/2013 11:27:04 PM (13 years ago)
- Location:
- counterize/trunk
- Files:
-
- 16 edited
-
counterize.php (modified) (17 diffs)
-
counterize_admin.php (modified) (3 diffs)
-
counterize_deprecated.php (modified) (17 diffs)
-
counterize_install.php (modified) (1 diff)
-
counterize_iptocountry.php (modified) (2 diffs)
-
counterize_plugin_browsers.php (modified) (4 diffs)
-
counterize_plugin_countries.php (modified) (3 diffs)
-
counterize_plugin_ip.php (modified) (5 diffs)
-
counterize_plugin_keywords.php (modified) (3 diffs)
-
counterize_plugin_os.php (modified) (4 diffs)
-
counterize_plugin_outlinks.php (modified) (5 diffs)
-
counterize_plugin_pages.php (modified) (5 diffs)
-
counterize_plugin_referers.php (modified) (7 diffs)
-
counterize_plugin_traffic.php (modified) (1 diff)
-
license.txt (modified) (1 diff)
-
readme.txt (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
counterize/trunk/counterize.php
r497973 r652694 4 4 Plugin URI: http://www.gabsoftware.com/products/scripts/counterize/ 5 5 Description: Complete counter and statistics plugin for Wordpress with no external libs. See Readme for more details. 6 Version: 3.1. 36 Version: 3.1.4 7 7 Author: Gabriel Hautclocq 8 8 Author URI: http://www.gabsoftware.com/ … … 43 43 define( 'COUNTERIZE_VERSION_MAJ', 3 ); 44 44 define( 'COUNTERIZE_VERSION_MIN', 1 ); 45 define( 'COUNTERIZE_VERSION_REV', 3);45 define( 'COUNTERIZE_VERSION_REV', 4 ); 46 46 47 47 // Specify width and height for icons here … … 462 462 if( $_SERVER['REQUEST_URI'] ) 463 463 { 464 $requesturl = $ wpdb->prepare( $_SERVER['REQUEST_URI'] );464 $requesturl = $_SERVER['REQUEST_URI']; 465 465 $sql = "SELECT `count` " 466 466 . " FROM `" . counterize_pageTable() . "`" … … 834 834 { 835 835 $first = false; 836 $sql .= " m.`IP` {$comparator} '" . $wpdb->prepare( $filter ) ."' ";836 $sql .= " m.`IP` {$comparator} '" . $wpdb->prepare( "%s", $filter ) ."' "; 837 837 } 838 838 else … … 843 843 $logical = 'AND'; 844 844 } 845 $sql .= " {$logical} m.`IP` {$comparator} '" . $wpdb->prepare( $filter ) ."' ";845 $sql .= " {$logical} m.`IP` {$comparator} '" . $wpdb->prepare( "%s", $filter ) ."' "; 846 846 } 847 847 } … … 872 872 { 873 873 $first = false; 874 $sql .= " c.`code` {$comparator} '" . $wpdb->prepare( $filter ) ."' ";874 $sql .= " c.`code` {$comparator} '" . $wpdb->prepare( "%s", $filter ) ."' "; 875 875 } 876 876 else … … 881 881 $logical = 'AND'; 882 882 } 883 $sql .= " {$logical} c.`code` {$comparator} '" . $wpdb->prepare( $filter ) ."' ";883 $sql .= " {$logical} c.`code` {$comparator} '" . $wpdb->prepare( "%s", $filter ) ."' "; 884 884 } 885 885 } … … 910 910 { 911 911 $first = false; 912 $sql .= " p.`url` {$comparator} '" . $wpdb->prepare( $filter ) ."' ";912 $sql .= " p.`url` {$comparator} '" . $wpdb->prepare( "%s", $filter ) ."' "; 913 913 } 914 914 else … … 919 919 $logical = 'AND'; 920 920 } 921 $sql .= " {$logical} p.`url` {$comparator} '" . $wpdb->prepare( $filter ) . "' ";921 $sql .= " {$logical} p.`url` {$comparator} '" . $wpdb->prepare( "%s", $filter ) . "' "; 922 922 } 923 923 } … … 948 948 { 949 949 $first = false; 950 $sql .= " r.`name` {$comparator} '" . $wpdb->prepare( $filter ) ."' ";950 $sql .= " r.`name` {$comparator} '" . $wpdb->prepare( "%s", $filter ) ."' "; 951 951 } 952 952 else … … 957 957 $logical = 'AND'; 958 958 } 959 $sql .= " {$logical} r.`name` {$comparator} '" . $wpdb->prepare( $filter ) . "' ";959 $sql .= " {$logical} r.`name` {$comparator} '" . $wpdb->prepare( "%s", $filter ) . "' "; 960 960 } 961 961 } … … 986 986 { 987 987 $first = false; 988 $sql .= " ua.`name` {$comparator} '" . $wpdb->prepare( $filter ) ."' ";988 $sql .= " ua.`name` {$comparator} '" . $wpdb->prepare( "%s", $filter ) ."' "; 989 989 } 990 990 else … … 995 995 $logical = 'AND'; 996 996 } 997 $sql .= " {$logical} ua.`name` {$comparator} '" . $wpdb->prepare( $filter ) . "' ";997 $sql .= " {$logical} ua.`name` {$comparator} '" . $wpdb->prepare( "%s", $filter ) . "' "; 998 998 } 999 999 } … … 1024 1024 { 1025 1025 $first = false; 1026 $sql .= " k.`keyword` {$comparator} '" . $wpdb->prepare( $filter ) ."' ";1026 $sql .= " k.`keyword` {$comparator} '" . $wpdb->prepare( "%s", $filter ) ."' "; 1027 1027 } 1028 1028 else … … 1033 1033 $logical = 'AND'; 1034 1034 } 1035 $sql .= " {$logical} k.`keyword` {$comparator} '" . $wpdb->prepare( $filter ) . "' ";1035 $sql .= " {$logical} k.`keyword` {$comparator} '" . $wpdb->prepare( "%s", $filter ) . "' "; 1036 1036 } 1037 1037 } … … 1055 1055 $where = TRUE; 1056 1056 $sql .= $clause; 1057 $sql .= " m.`timestamp` BETWEEN '" . $wpdb->prepare( $datefilter1 ) . "' AND '" . $wpdb->prepare($datefilter2 ) . "' ) \n";1057 $sql .= " m.`timestamp` BETWEEN '" . $wpdb->prepare( "%s", $datefilter1 ) . "' AND '" . $wpdb->prepare( "%s", $datefilter2 ) . "' ) \n"; 1058 1058 } 1059 1059 … … 1063 1063 $clause = $where === FALSE ? 'WHERE' : 'AND'; 1064 1064 $where = TRUE; 1065 $sql .= "{$clause} m.`id` = '" . $wpdb->prepare( $entryID ) . "' \n";1065 $sql .= "{$clause} m.`id` = '" . $wpdb->prepare( "%s", $entryID ) . "' \n"; 1066 1066 } 1067 1067 -
counterize/trunk/counterize_admin.php
r497973 r652694 1053 1053 { 1054 1054 //retrieve the pageID to decount 1055 $pageid = $wpdb->get_var( 'SELECT `pageID` FROM `' . counterize_pageTable() . "` WHERE `url`='" . $wpdb->prepare( $page ) . "' LIMIT 1" );1055 $pageid = $wpdb->get_var( 'SELECT `pageID` FROM `' . counterize_pageTable() . "` WHERE `url`='" . $wpdb->prepare( "%s", $page ) . "' LIMIT 1" ); 1056 1056 } 1057 1057 1058 1058 //retrieve the refererID to decount 1059 $refererid = $wpdb->get_var( 'SELECT `refererID` FROM `' . counterize_refererTable() . "` WHERE `name`='" . $wpdb->prepare( $referer ) . "' LIMIT 1" );1059 $refererid = $wpdb->get_var( 'SELECT `refererID` FROM `' . counterize_refererTable() . "` WHERE `name`='" . $wpdb->prepare( "%s", $referer ) . "' LIMIT 1" ); 1060 1060 1061 1061 //get the number of records to decount from page and referer tables … … 1461 1461 $page_cnt++; 1462 1462 1463 $sql_pages_1_1 .= $wpdb->prepare( $id );1464 $sql_pages_1_2 .= '"' . $wpdb->prepare( $agent['page'] ). '"';1465 $sql_pages_1_3 .= '"' . $wpdb->prepare( $agent['referer'] ). '"';1466 1467 $sql_logtable_1_1 .= $wpdb->prepare( $id );1468 $sql_logtable_1_2 .= '"' . $wpdb->prepare( $agent['page'] ). '"';1469 $sql_logtable_1_3 .= '"' . $wpdb->prepare( $agent['referer'] ). '"';1463 $sql_pages_1_1 .= $wpdb->prepare( "%s", $id ); 1464 $sql_pages_1_2 .= '"' . $wpdb->prepare( "%s", $agent['page'] ). '"'; 1465 $sql_pages_1_3 .= '"' . $wpdb->prepare( "%s", $agent['referer'] ). '"'; 1466 1467 $sql_logtable_1_1 .= $wpdb->prepare( "%s", $id ); 1468 $sql_logtable_1_2 .= '"' . $wpdb->prepare( "%s", $agent['page'] ). '"'; 1469 $sql_logtable_1_3 .= '"' . $wpdb->prepare( "%s", $agent['referer'] ). '"'; 1470 1470 } 1471 1471 else … … 1482 1482 $nopage_cnt++; 1483 1483 1484 $sql_pages_2_1 .= $wpdb->prepare( $id );1485 $sql_pages_2_2 .= '"' . $wpdb->prepare( $agent['referer'] ). '"';1486 1487 $sql_logtable_2_1 .= $wpdb->prepare( $id );1488 $sql_logtable_2_2 .= '"' . $wpdb->prepare( $agent['referer'] ). '"';1484 $sql_pages_2_1 .= $wpdb->prepare( "%s", $id ); 1485 $sql_pages_2_2 .= '"' . $wpdb->prepare( "%s", $agent['referer'] ). '"'; 1486 1487 $sql_logtable_2_1 .= $wpdb->prepare( "%s", $id ); 1488 $sql_logtable_2_2 .= '"' . $wpdb->prepare( "%s", $agent['referer'] ). '"'; 1489 1489 } 1490 1490 } -
counterize/trunk/counterize_deprecated.php
r491617 r652694 97 97 { 98 98 global $wpdb; 99 $number = $wpdb->prepare( $number );99 $number = $wpdb->prepare( "%d", $number ); 100 100 $sql = "SELECT c.`postID`, c.`count` AS amount , c.`url` AS url, w.`post_title` AS label, w.`post_title` AS label2 " 101 101 . " FROM `" . counterize_pageTable() . "` c, `" . $wpdb->posts . "` w " … … 136 136 global $wpdb; 137 137 $onedayago = date( 'Y-m-d H:i:s', time() - 86400 ); 138 $number = $wpdb->prepare( $number );138 $number = $wpdb->prepare( "%d", $number ); 139 139 $sql = "SELECT COUNT( l.`id` ) AS amount, c.`postID`, c.`url` AS url, w.`post_title` AS label, w.`post_title` AS label2 " 140 140 . " FROM `" . counterize_logTable() . "` l, `" . counterize_pageTable() . "` c, `" . $wpdb->posts . "` w " … … 175 175 { 176 176 global $wpdb; 177 $number = $wpdb->prepare( $number );177 $number = $wpdb->prepare( "%d", $number ); 178 178 $sql = "SELECT `count` AS amount , `url` AS url, `url` AS label, `url` AS label2 " 179 179 . " FROM `" . counterize_pageTable() . "`" … … 223 223 . " FROM `" . counterize_refererTable() . "`" 224 224 . " WHERE `name` <> 'unknown' " 225 . " AND `name` NOT LIKE '" . $wpdb->prepare( get_option( "home" ) ) . "%%' "226 . " AND `name` NOT LIKE '" . $wpdb->prepare( get_option( "siteurl" ) ) . "%%' "225 . " AND `name` NOT LIKE '" . $wpdb->prepare( "%s", get_option( "home" ) ) . "%%' " 226 . " AND `name` NOT LIKE '" . $wpdb->prepare( "%s", get_option( "siteurl" ) ) . "%%' " 227 227 . " ORDER BY amount DESC " 228 228 . " LIMIT {$number}"; … … 242 242 . " WHERE m.refererID = r.refererID " 243 243 . " AND r.name <> 'unknown' " 244 . " AND r.name NOT LIKE '" . $wpdb->prepare( get_option( "home" ) ) . "%%' "245 . " AND r.name NOT LIKE '" . $wpdb->prepare( get_option( "siteurl" ) ) . "%%' "244 . " AND r.name NOT LIKE '" . $wpdb->prepare( "%s", get_option( "home" ) ) . "%%' " 245 . " AND r.name NOT LIKE '" . $wpdb->prepare( "%s", get_option( "siteurl" ) ) . "%%' " 246 246 . " AND m.timestamp >= '{$onedayago}'" 247 247 . " GROUP BY r.name " … … 263 263 { 264 264 global $wpdb; 265 $geoip = $wpdb->prepare( counterize_get_option( 'geoip' ) );266 $number = $wpdb->prepare( $number );265 $geoip = $wpdb->prepare( "%s", counterize_get_option( 'geoip' ) ); 266 $number = $wpdb->prepare( "%d", $number ); 267 267 $sql = "SELECT COUNT(`IP`) AS amount, `IP` AS label, `IP` AS label2, CONCAT('{$geoip}', `IP`) AS url " 268 268 . " FROM `" . counterize_logTable() . "`" … … 284 284 global $wpdb; 285 285 $onedayago = date( "Y-m-d H:i:s", time() - 86400 ); 286 $number = $wpdb->prepare( $number );287 $geoip = $wpdb->prepare( counterize_get_option( 'geoip' ) );286 $number = $wpdb->prepare( "%d", $number ); 287 $geoip = $wpdb->prepare( "%s", counterize_get_option( 'geoip' ) ); 288 288 $sql = "SELECT COUNT(`IP`) AS amount, `IP` AS label, `IP` AS label2, CONCAT('{$geoip}', `IP`) AS url " 289 289 . " FROM `" . counterize_logTable() . "`" … … 307 307 { 308 308 global $wpdb; 309 $number = $wpdb->prepare( $number );309 $number = $wpdb->prepare( "%d", $number ); 310 310 $sql = "SELECT `count` AS amount, `keyword` AS label, `keyword` AS label2 " 311 311 . " FROM `" . counterize_keywordTable() . "`" … … 325 325 global $wpdb; 326 326 $today = date( 'Y-m-d' ); 327 $number = $wpdb->prepare( $number );327 $number = $wpdb->prepare( "%d", $number ); 328 328 $sql = "SELECT COUNT(1) AS amount, k.keyword AS label, k.keyword AS label2 " 329 329 . " FROM " . counterize_keywordTable() . " k, " . counterize_logTable() . " l, " . counterize_refererTable() . " r " … … 353 353 { 354 354 global $wpdb; 355 $number = $wpdb->prepare( $number );355 $number = $wpdb->prepare( "%d", $number ); 356 356 $sql = "SELECT `count` AS amount , `code`, `code` AS label, `code` AS label2 " 357 357 . " FROM `" . counterize_countryTable() . "`" … … 389 389 global $wpdb; 390 390 $onedayago = date( "Y-m-d H:i:s", time() - 86400 ); 391 $number = $wpdb->prepare( $number );391 $number = $wpdb->prepare( "%d", $number ); 392 392 $sql = "SELECT COUNT(m.id) AS amount, c.code AS code, c.code AS label, c.code AS label2 " 393 393 . " FROM `" . counterize_logTable() . "` m, `" . counterize_countryTable() . "` c " … … 430 430 global $wpdb; 431 431 432 $nb_parent_items = (int) $wpdb->prepare( $nb_parent_items );433 $nb_child_items = (int) $wpdb->prepare( $nb_child_items );432 $nb_parent_items = (int) $wpdb->prepare( "%d", $nb_parent_items ); 433 $nb_child_items = (int) $wpdb->prepare( "%d", $nb_child_items ); 434 434 435 435 $sql_parents = … … 482 482 { 483 483 global $wpdb; 484 $number = $wpdb->prepare( $number );484 $number = $wpdb->prepare( "%d", $number ); 485 485 $sql = "SELECT SUM(`count`) AS amount, `browserName` AS label, `browserName` AS label2, `browserCode` AS code, `browserURL` AS url " 486 486 . " FROM `" . counterize_agentsTable() . "`" … … 513 513 { 514 514 global $wpdb; 515 $number = $wpdb->prepare( $number );515 $number = $wpdb->prepare( "%d", $number ); 516 516 $sql = "SELECT " 517 517 . " SUM(`count`) AS amount, " … … 556 556 global $wpdb; 557 557 558 $nb_parent_items = (int) $wpdb->prepare( $nb_parent_items );559 $nb_child_items = (int) $wpdb->prepare( $nb_child_items );558 $nb_parent_items = (int) $wpdb->prepare( "%d", $nb_parent_items ); 559 $nb_child_items = (int) $wpdb->prepare( "%d", $nb_child_items ); 560 560 561 561 $sql_parents = … … 607 607 { 608 608 global $wpdb; 609 $number = $wpdb->prepare( $number );609 $number = $wpdb->prepare( "%d", $number ); 610 610 $sql = "SELECT SUM(`count`) AS amount, `osName` AS label, `osName` AS label2, `osCode` AS code, `osURL` AS url " 611 611 . " FROM `" . counterize_agentsTable() . "`" … … 640 640 { 641 641 global $wpdb; 642 $number = $wpdb->prepare( $number );642 $number = $wpdb->prepare( "%d", $number ); 643 643 $sql = "SELECT SUM( `count` ) AS amount, CONCAT( CONCAT( `osName`, ' ' ), `osVersion` ) AS label, CONCAT( CONCAT( `osName`, ' ' ), `osVersion` ) AS label2, `osCode`, `osURL` AS url " 644 644 . " FROM `" . counterize_agentsTable() . "`" -
counterize/trunk/counterize_install.php
r497973 r652694 882 882 } 883 883 884 if( $Revision < 3)885 { 886 $Revision = 3;887 } 888 // Here we have Counterize 3.1. 3884 if( $Revision < 4 ) 885 { 886 $Revision = 4; 887 } 888 // Here we have Counterize 3.1.4 889 889 } 890 890 } -
counterize/trunk/counterize_iptocountry.php
r491617 r652694 46 46 { 47 47 global $counterize_countries; 48 if( $code2 != '00' )48 if( $code2 != '00' && isset( $counterize_countries[$code2] ) ) 49 49 { 50 50 return $counterize_countries[$code2][0]; … … 60 60 { 61 61 global $counterize_countries; 62 if( $code2 != '00' )62 if( $code2 != '00' && isset( $counterize_countries[$code2] ) ) 63 63 { 64 64 return $counterize_countries[$code2][1]; -
counterize/trunk/counterize_plugin_browsers.php
r497973 r652694 4 4 Plugin URI: http://www.gabsoftware.com/products/scripts/counterize/plugins/browsers 5 5 Description: Display some information about the browsers used by your visitors, for the Counterize plugin 6 Version: 3.1. 36 Version: 3.1.4 7 7 Author: Gabriel Hautclocq 8 8 Author URI: http://www.gabsoftware.com/ … … 279 279 { 280 280 global $wpdb; 281 $nb_parent_items = (int) $wpdb->prepare( $nb_parent_items );282 $nb_child_items = (int) $wpdb->prepare( $nb_child_items );281 $nb_parent_items = (int) $wpdb->prepare( "%d", $nb_parent_items ); 282 $nb_child_items = (int) $wpdb->prepare( "%d", $nb_child_items ); 283 283 284 284 $sql_parents = … … 400 400 { 401 401 global $wpdb; 402 $number = $wpdb->prepare( $number );402 $number = $wpdb->prepare( "%d", $number ); 403 403 $sql = "SELECT SUM(`count`) AS `count`, `browserName` AS label, `browserCode` AS `code`, `browserURL` AS `url` " 404 404 . " FROM `" . counterize_agentsTable() . "`" … … 480 480 { 481 481 global $wpdb; 482 $number = $wpdb->prepare( $number );482 $number = $wpdb->prepare( "%d", $number ); 483 483 $sql = "SELECT " 484 484 . " SUM( `count` ) AS `count`, " -
counterize/trunk/counterize_plugin_countries.php
r497973 r652694 4 4 Plugin URI: http://www.gabsoftware.com/products/scripts/counterize/plugins/countries 5 5 Description: Display some information about the countries for the Counterize plugin 6 Version: 3.1. 36 Version: 3.1.4 7 7 Author: Gabriel Hautclocq 8 8 Author URI: http://www.gabsoftware.com/ … … 269 269 { 270 270 global $wpdb; 271 $number = $wpdb->prepare( $number );271 $number = $wpdb->prepare( "%d", $number ); 272 272 $sql = "SELECT `count` , `code` " 273 273 . " FROM `" . counterize_countryTable() . "`" … … 339 339 { 340 340 global $wpdb; 341 $number = $wpdb->prepare( $number );341 $number = $wpdb->prepare( "%d", $number ); 342 342 $onedayago = date( 'Y-m-d H:i:s', time() - 86400 ); 343 343 $sql = "SELECT COUNT( m.id ) AS `count`, c.code, c.code AS label " -
counterize/trunk/counterize_plugin_ip.php
r497973 r652694 4 4 Plugin URI: http://www.gabsoftware.com/products/scripts/counterize/plugins/ip 5 5 Description: Display some information about the IP addresses of your visitors for the Counterize plugin 6 Version: 3.1. 36 Version: 3.1.4 7 7 Author: Gabriel Hautclocq 8 8 Author URI: http://www.gabsoftware.com/ … … 304 304 { 305 305 global $wpdb; 306 $number = $wpdb->prepare( $number );307 $geoip = $wpdb->prepare( counterize_get_option( 'geoip' ) );308 $sql = "SELECT COUNT(`IP`) AS `count`, `IP` AS `label`, CONCAT( '{$geoip}', `IP` ) AS `url` "306 $number = $wpdb->prepare( "%d", $number ); 307 $geoip = $wpdb->prepare( "%s", counterize_get_option( 'geoip' ) ); 308 $sql = "SELECT COUNT(`IP`) AS `count`, `IP` AS `label`, CONCAT( {$geoip}, `IP` ) AS `url` " 309 309 . " FROM `" . counterize_logTable() . "`" 310 310 . " WHERE `IP` <> 'unavailable' " … … 353 353 global $wpdb; 354 354 $onedayago = date( 'Y-m-d H:i:s', time() - 86400 ); 355 $number = $wpdb->prepare( $number );356 $geoip = $wpdb->prepare( counterize_get_option( 'geoip' ) );357 $sql = "SELECT COUNT(`IP`) AS `count`, `IP` AS `label`, CONCAT( '{$geoip}', `IP` ) AS `url` "355 $number = $wpdb->prepare( "%d", $number ); 356 $geoip = $wpdb->prepare( "%s", counterize_get_option( 'geoip' ) ); 357 $sql = "SELECT COUNT(`IP`) AS `count`, `IP` AS `label`, CONCAT( {$geoip}, `IP` ) AS `url` " 358 358 . " FROM `" . counterize_logTable() . "`" 359 359 . " WHERE `IP` <> 'unavailable' " … … 402 402 { 403 403 global $wpdb; 404 $number = $wpdb->prepare( $number );405 $geoip = $wpdb->prepare( counterize_get_option( 'geoip' ) );406 $sql = "SELECT COUNT(`IP`) AS `count`, `IP` AS `label`, CONCAT( '{$geoip}', `IP` ) AS `url` "404 $number = $wpdb->prepare( "%d", $number ); 405 $geoip = $wpdb->prepare( "%s", counterize_get_option( 'geoip' ) ); 406 $sql = "SELECT COUNT(`IP`) AS `count`, `IP` AS `label`, CONCAT( {$geoip}, `IP` ) AS `url` " 407 407 . " FROM `" . counterize_logTable() . "`" 408 408 . " WHERE `IP` <> 'unavailable' " … … 448 448 global $wpdb; 449 449 $onedayago = date( 'Y-m-d H:i:s', time() - 86400 ); 450 $number = $wpdb->prepare( $number );451 $geoip = $wpdb->prepare( counterize_get_option( 'geoip' ) );452 $sql = "SELECT COUNT(`IP`) AS `count`, `IP` AS `label`, CONCAT( '{$geoip}', `IP` ) AS `url` "450 $number = $wpdb->prepare( "%d", $number ); 451 $geoip = $wpdb->prepare( "%s", counterize_get_option( 'geoip' ) ); 452 $sql = "SELECT COUNT(`IP`) AS `count`, `IP` AS `label`, CONCAT( {$geoip}, `IP` ) AS `url` " 453 453 . " FROM `" . counterize_logTable() . "`" 454 454 . " WHERE `IP` <> 'unavailable' " -
counterize/trunk/counterize_plugin_keywords.php
r497973 r652694 4 4 Plugin URI: http://www.gabsoftware.com/products/scripts/counterize/plugins/keywords 5 5 Description: Display some information about the keywords written by your visitors to access your website for the Counterize plugin 6 Version: 3.1. 36 Version: 3.1.4 7 7 Author: Gabriel Hautclocq 8 8 Author URI: http://www.gabsoftware.com/ … … 272 272 { 273 273 global $wpdb; 274 $number = $wpdb->prepare( $number );274 $number = $wpdb->prepare( "%d", $number ); 275 275 $sql = "SELECT `count`, `keyword` AS `label` " 276 276 . " FROM `" . counterize_keywordTable() . "`" … … 315 315 { 316 316 global $wpdb; 317 $number = $wpdb->prepare( $number );317 $number = $wpdb->prepare( "%d", $number ); 318 318 $onedayago = date( 'Y-m-d H:i:s', time() - 86400 ); 319 319 $sql = "SELECT COUNT( 1 ) AS `count`, k.keyword AS `label` " -
counterize/trunk/counterize_plugin_os.php
r497973 r652694 4 4 Plugin URI: http://www.gabsoftware.com/products/scripts/counterize/plugins/os 5 5 Description: Display some information about the operating systems used by your visitors, for the Counterize plugin 6 Version: 3.1. 36 Version: 3.1.4 7 7 Author: Gabriel Hautclocq 8 8 Author URI: http://www.gabsoftware.com/ … … 279 279 { 280 280 global $wpdb; 281 $nb_parent_items = (int) $wpdb->prepare( $nb_parent_items );282 $nb_child_items = (int) $wpdb->prepare( $nb_child_items );281 $nb_parent_items = (int) $wpdb->prepare( "%d", $nb_parent_items ); 282 $nb_child_items = (int) $wpdb->prepare( "%d", $nb_child_items ); 283 283 284 284 $sql_parents = … … 397 397 { 398 398 global $wpdb; 399 $number = $wpdb->prepare( $number );399 $number = $wpdb->prepare( "%d", $number ); 400 400 $sql = "SELECT SUM(`count`) AS `count`, `osName` AS `label`, `osCode` AS `code`, `osURL` AS `url` " 401 401 . " FROM `" . counterize_agentsTable() . "`" … … 470 470 { 471 471 global $wpdb; 472 $number = $wpdb->prepare( $number );472 $number = $wpdb->prepare( "%d", $number ); 473 473 $sql = "SELECT SUM( `count` ) AS `count`, CONCAT( CONCAT( `osName`, ' ' ), `osVersion` ) AS `label`, `osCode` AS `code`, `osURL` AS `url` " 474 474 . " FROM `" . counterize_agentsTable() . "`" -
counterize/trunk/counterize_plugin_outlinks.php
r497973 r652694 4 4 Plugin URI: http://www.gabsoftware.com/products/scripts/counterize/plugins/outlinks 5 5 Description: Display some information about the outlinks for the Counterize plugin 6 Version: 3.1. 36 Version: 3.1.4 7 7 Author: Gabriel Hautclocq 8 8 Author URI: http://www.gabsoftware.com/ … … 306 306 { 307 307 global $wpdb; 308 $number = $wpdb->prepare( $number );308 $number = $wpdb->prepare( "%d", $number ); 309 309 $sql = "SELECT `count` , `url`, `url` AS label " 310 310 . " FROM `" . counterize_outlinksTable() . "`" … … 349 349 { 350 350 global $wpdb; 351 $number = $wpdb->prepare( $number );351 $number = $wpdb->prepare( "%d", $number ); 352 352 $onedayago = date( 'Y-m-d H:i:s', time() - 86400 ); 353 353 $sql = "SELECT COUNT( m.`id` ) AS `count`, o.`url` AS url, o.`url` AS label " … … 397 397 { 398 398 global $wpdb; 399 $number = $wpdb->prepare( $number );399 $number = $wpdb->prepare( "%d", $number ); 400 400 $sql = "SELECT COUNT( m.`id` ) AS `count`, p.`url` AS url, p.`url` AS label " 401 401 . " FROM `" . counterize_logTable() . "` m, `" . counterize_pageTable() . "` p " … … 450 450 { 451 451 global $wpdb; 452 $number = $wpdb->prepare( $number );452 $number = $wpdb->prepare( "%d", $number ); 453 453 $onedayago = date( 'Y-m-d H:i:s', time() - 86400 ); 454 454 $sql = "SELECT COUNT( m.`id` ) AS `count`, p.`url` AS url, p.`url` AS label " -
counterize/trunk/counterize_plugin_pages.php
r497973 r652694 4 4 Plugin URI: http://www.gabsoftware.com/products/scripts/counterize/plugins/pages 5 5 Description: Display some information about popular pages and posts, and the most requested URLs, for the Counterize plugin 6 Version: 3.1. 36 Version: 3.1.4 7 7 Author: Gabriel Hautclocq 8 8 Author URI: http://www.gabsoftware.com/ … … 300 300 { 301 301 global $wpdb; 302 $number = $wpdb->prepare( $number );302 $number = $wpdb->prepare( "%d", $number ); 303 303 $sql = "SELECT `count` , `url` AS url, `url` AS label " 304 304 . " FROM `" . counterize_pageTable() . "`" … … 346 346 { 347 347 global $wpdb; 348 $number = $wpdb->prepare( $number );348 $number = $wpdb->prepare( "%d", $number ); 349 349 $onedayago = date( 'Y-m-d H:i:s', time() - 86400 ); 350 350 $sql = "SELECT COUNT( m.`id` ) AS `count`, p.`url` AS url, p.`url` AS label " … … 399 399 { 400 400 global $wpdb; 401 $number = $wpdb->prepare( $number );401 $number = $wpdb->prepare( "%d", $number ); 402 402 $sql = "SELECT c.`postID`, SUM( c.`count`) AS `count`, c.`url`, w.`post_title` AS label " 403 403 . " FROM `" . counterize_pageTable() . "` c, `" . $wpdb->posts . "` w " … … 472 472 global $wpdb; 473 473 $onedayago = date( 'Y-m-d H:i:s', time() - 86400 ); 474 $number = $wpdb->prepare( $number );474 $number = $wpdb->prepare( "%d", $number ); 475 475 $sql = "SELECT COUNT( l.`id` ) AS `count`, c.`postID`, c.`url` AS url, w.`post_title` AS label " 476 476 . " FROM `" . counterize_logTable() . "` l, `" . counterize_pageTable() . "` c, `" . $wpdb->posts . "` w " -
counterize/trunk/counterize_plugin_referers.php
r497973 r652694 4 4 Plugin URI: http://www.gabsoftware.com/products/scripts/counterize/plugins/referers 5 5 Description: Display some information about the referers for the Counterize plugin 6 Version: 3.1. 36 Version: 3.1.4 7 7 Author: Gabriel Hautclocq 8 8 Author URI: http://www.gabsoftware.com/ … … 306 306 { 307 307 global $wpdb; 308 $number = $wpdb->prepare( $number );308 $number = $wpdb->prepare( "%d", $number ); 309 309 $sql = "SELECT `count`, `name` AS label, `name` AS url " 310 310 . " FROM `" . counterize_refererTable() . "`" 311 311 . " WHERE `name` <> 'unknown' " 312 . " AND `name` NOT LIKE '" . $wpdb->prepare( get_option( 'home' ) ) . "%%'"313 . " AND `name` NOT LIKE '" . $wpdb->prepare( get_option( 'siteurl' ) ) . "%%'"312 . " AND `name` NOT LIKE " . $wpdb->prepare( "%s", get_option( 'home' ) . "%%" ) . " " 313 . " AND `name` NOT LIKE " . $wpdb->prepare( "%s", get_option( 'siteurl' ) . "%%" ) . " " 314 314 . " ORDER BY `count` DESC " 315 315 . " LIMIT {$number}"; … … 354 354 { 355 355 global $wpdb; 356 $number = $wpdb->prepare( $number );356 $number = $wpdb->prepare( "%d", $number ); 357 357 $onedayago = date( 'Y-m-d H:i:s', time() - 86400 ); 358 358 $sql = "SELECT COUNT( m.id ) AS `count`, r.name AS label, r.name AS url " … … 360 360 . " WHERE m.`refererID` = r.`refererID` " 361 361 . " AND r.`name` <> 'unknown' " 362 . " AND r.`name` NOT LIKE '" . $wpdb->prepare( get_option( "home" ) ) . "%%'"363 . " AND r.`name` NOT LIKE '" . $wpdb->prepare( get_option( "siteurl" ) ) . "%%'"362 . " AND r.`name` NOT LIKE " . $wpdb->prepare( "%s", get_option( "home" ) . "%%" ) . " " 363 . " AND r.`name` NOT LIKE " . $wpdb->prepare( "%s", get_option( "siteurl" ) . "%%" ) . " " 364 364 . " AND m.`timestamp` >= '{$onedayago}'" 365 365 . " GROUP BY r.`name` " … … 406 406 { 407 407 global $wpdb; 408 $number = $wpdb->prepare( $number );408 $number = $wpdb->prepare( "%d", $number ); 409 409 $sql = 'SELECT SUM( `count` ) AS `count`, SUBSTRING_INDEX( SUBSTRING_INDEX( TRIM( LEADING "https://" FROM TRIM( LEADING "http://" FROM TRIM( `name` ) ) ), "/", 1 ), ":", 1 ) AS `domain` ' 410 410 . " FROM `" . counterize_refererTable() . "`" 411 411 . " WHERE `name` <> 'unknown' " 412 . " AND `name` NOT LIKE '" . $wpdb->prepare( get_option( 'home' ) ) . "%%'"413 . " AND `name` NOT LIKE '" . $wpdb->prepare( get_option( 'siteurl' ) ) . "%%'"412 . " AND `name` NOT LIKE " . $wpdb->prepare( "%s", get_option( 'home' ) . "%%" ) . " " 413 . " AND `name` NOT LIKE " . $wpdb->prepare( "%s", get_option( 'siteurl' ) . "%%" ) . " " 414 414 . " GROUP BY `domain` " 415 415 . " ORDER BY `count` DESC " … … 455 455 { 456 456 global $wpdb; 457 $number = $wpdb->prepare( $number );457 $number = $wpdb->prepare( "%d", $number ); 458 458 $onedayago = date( 'Y-m-d H:i:s', time() - 86400 ); 459 459 $sql = 'SELECT COUNT( m.id ) AS `count`, SUBSTRING_INDEX( SUBSTRING_INDEX( TRIM( LEADING "https://" FROM TRIM( LEADING "http://" FROM TRIM( r.`name` ) ) ), "/", 1 ), ":", 1 ) AS `domain` ' … … 461 461 . " WHERE m.`refererID` = r.`refererID` " 462 462 . " AND r.`name` <> 'unknown' " 463 . " AND r.`name` NOT LIKE '" . $wpdb->prepare( get_option( "home" ) ) . "%%'"464 . " AND r.`name` NOT LIKE '" . $wpdb->prepare( get_option( "siteurl" ) ) . "%%'"463 . " AND r.`name` NOT LIKE " . $wpdb->prepare( "%s", get_option( "home" ) . "%%" ) . " " 464 . " AND r.`name` NOT LIKE " . $wpdb->prepare( "%s", get_option( "siteurl" ) . "%%" ) . " " 465 465 . " AND m.`timestamp` >= '{$onedayago}'" 466 466 . " GROUP BY `domain` " -
counterize/trunk/counterize_plugin_traffic.php
r497973 r652694 4 4 Plugin URI: http://www.gabsoftware.com/products/scripts/counterize/plugins/traffic 5 5 Description: Display some information about the traffic for the Counterize plugin 6 Version: 3.1. 36 Version: 3.1.4 7 7 Author: Gabriel Hautclocq 8 8 Author URI: http://www.gabsoftware.com/ -
counterize/trunk/license.txt
r389455 r652694 1 Copyright (c) 2011 GabSoftware <gabriel@gabsoftware.com>1 Copyright (c) 2011 - 2013 GabSoftware <gabriel@gabsoftware.com> 2 2 3 3 Permission to use, copy, modify, and/or distribute this software for any -
counterize/trunk/readme.txt
r498009 r652694 4 4 Tags: hits, visit, counter, traffic, statistics, stats, browser, operating, system, graph, chart, diagram 5 5 Requires at least: 3.3.0 6 Tested up to: 3. 3.17 Stable tag: 3.1. 36 Tested up to: 3.5.0 7 Stable tag: 3.1.4 8 8 9 9 Counter and statistics plugin for WordPress. … … 585 585 == Changelog == 586 586 587 = 3.1.4 = 588 * This is a maintenance release for WP 3.5 compatibility. Nothing new has been added. 589 * Fixed warnings caused by $wpdb->prepare() called with only one argument and so fixed some possible SQL injection vulnerabilities. 590 * Fixed warnings caused by unknown countries 591 587 592 = 3.1.3 = 588 593 * Fixed a race condition in email reports: Counterize now checks if a report should be sent after all the Counterize plugins have been loaded.
Note: See TracChangeset
for help on using the changeset viewer.