diff options
author | donncha <donncha@7be80a69-a1ef-0310-a953-fb0f7c49ff36> | 2006-02-17 11:50:11 +0000 |
---|---|---|
committer | donncha <donncha@7be80a69-a1ef-0310-a953-fb0f7c49ff36> | 2006-02-17 11:50:11 +0000 |
commit | f3af365bb32a140aa1379f35b2b8606d6a950ebe (patch) | |
tree | d708c0fc72b5945f7c697746624dc2e5dd4492df /wp-inst | |
parent | 2ab4faee68383698b06cc23eef6ce8f41612f58d (diff) | |
download | wordpress-mu-f3af365bb32a140aa1379f35b2b8606d6a950ebe.tar.gz wordpress-mu-f3af365bb32a140aa1379f35b2b8606d6a950ebe.tar.xz wordpress-mu-f3af365bb32a140aa1379f35b2b8606d6a950ebe.zip |
Use wpdb object for table name (thanks macgruder)
git-svn-id: http://svn.automattic.com/wordpress-mu/trunk@529 7be80a69-a1ef-0310-a953-fb0f7c49ff36
Diffstat (limited to 'wp-inst')
-rw-r--r-- | wp-inst/wp-content/mu-plugins/invites.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/wp-inst/wp-content/mu-plugins/invites.php b/wp-inst/wp-content/mu-plugins/invites.php index 3cddc09..730d580 100644 --- a/wp-inst/wp-content/mu-plugins/invites.php +++ b/wp-inst/wp-content/mu-plugins/invites.php @@ -306,7 +306,7 @@ function invites_admin_content() { <li> Free Invites: <?php echo $wpdb->get_var( "SELECT sum( meta_value ) FROM $wpdb->usermeta WHERE meta_key = 'invites_left'" ); ?></li> <li> <?php echo $wpdb->get_var( "SELECT count(*) FROM $wpdb->usermeta WHERE meta_key LIKE '%invited_by'" ) ?> Invites sent, of which <?php echo $wpdb->get_var( "SELECT count(*) FROM $wpdb->usermeta WHERE meta_key='invite'" ); ?> are pending and have not been used yet.</li> <li> Invites Per User:<ul> - <?php $invite_groups = $wpdb->get_results( "SELECT count(*) as c, meta_value FROM `wp_usermeta` WHERE `meta_key` = 'invites_left' group by meta_value", ARRAY_A ); + <?php $invite_groups = $wpdb->get_results( "SELECT count(*) as c, meta_value FROM {$wpdb->usermeta} WHERE `meta_key` = 'invites_left' group by meta_value", ARRAY_A ); while( list( $key, $val ) = each( $invite_groups ) ) { print "<li> {$val[ 'c' ]} users have {$val[ 'meta_value' ]} invites.</li>"; |