WordPress.org

1. Fernando Yet To Die
   Member
   Posted 11 months ago #

   Hi.

   I have added this function on my functions.php

   function commentCount() {
       global $wpdb;
       $count = $wpdb->get_var('SELECT COUNT(comment_ID) FROM ' . $wpdb->comments. ' WHERE comment_author = "' . get_comment_author() . '"');
       echo $count . '';
   }

   And this code <?php commentCount(); ?> to call forth the Total of Comment posted by each individual Visitor.

   The function above, searches for a "Name" used by a visitor when he posted his Comments, and so collects the total of comments for each unique "Name".

   All works great so far!

   Now... I want to create a "IF" conditions to Print a different "Title" depending on how many comments a certain Name has.

   To my knowledge the variable commentCount() has the value of the current comment name... So, I would use this on my If conditions? See below...

   <?php 
   
   if ($commentCount > 10) {
   	echo "Level 10"; }
   if ($commentCount > 1) {
   	echo "Level 01";
   }
   
   ?>

   What I am trying is. IF commentCount is bigger than 10, echo "Level 10". IF commentCount is bigger than 1, echo "Level 1".

   Can anyone help please?

2. alchymyth
   The Sweeper
   Posted 11 months ago #

   your function echos the count;
   however, for use in a comparitive if statement, you would need the function to return the count.

   possibly write a new function:

   function get_commentCount() {
       global $wpdb;
       $count = $wpdb->get_var('SELECT COUNT(comment_ID) FROM ' . $wpdb->comments. ' WHERE comment_author = "' . get_comment_author() . '"');
       return $count;
   }

   and:
   

   <?php 
   
   if (get_commentCount() > 10) {
   	echo "Level 10"; }
   if (get_commentCount() > 1) {
   	echo "Level 01";
   }
   
   ?>

3. Fernando Yet To Die
   Member
   Posted 11 months ago #

   Omg, it works. You are a heavenly angel! (lol) Thank you!

   I am getting two echo's for a post higher than 1, any solution for this?

   I basically want to get:

   If 5 posts, return "Level 1".
   If 20 posts, return "Level 2".

   <?php 
   
   if (get_commentCount() < 5) {
   	echo "Level 1"; }
   
   	else 
   
   if (get_commentCount() < 10) {
   	echo "Level 2"; }
   
   	else
   
   if (get_commentCount() < 20) {
   	echo "Level 3"; }
   
   	else
   	echo "Level 10";
   
   ?>

4. Fernando Yet To Die
   Member
   Posted 11 months ago #

   Cant believe its already working:

   <?php 
   
   if (get_commentCount() < 2) {
   	echo "1"; }
   	else
   if (get_commentCount() < 5) {
   	echo "2"; }
   	else
   if (get_commentCount() < 8) {
   	echo "3"; }
   	else
   if (get_commentCount() < 12) {
   	echo "4"; }
   	else
   if (get_commentCount() < 18) {
   	echo "5"; }
   	else
   if (get_commentCount() < 25) {
   	echo "6"; }
   	else
   if (get_commentCount() < 28) {
   	echo "7"; }
   	else
   if (get_commentCount() < 35) {
   	echo "8"; }
   	else
   if (get_commentCount() < 40) {
   	echo "9"; }
   	else
   if (get_commentCount() < 50) {
   	echo "10"; }
   	else
   if (get_commentCount() < 60) {
   	echo "15"; }
   	else
   if (get_commentCount() < 70) {
   	echo "20"; }
   	else
   if (get_commentCount() < 85) {
   	echo "25"; }
   	else
   if (get_commentCount() < 100) {
   	echo "30"; }
   	else
   if (get_commentCount() < 120) {
   	echo "35"; }
   	else
   if (get_commentCount() < 140) {
   	echo "40"; }
   	else
   if (get_commentCount() < 160) {
   	echo "45"; }
   	else
   if (get_commentCount() < 200) {
   	echo "50"; }
   	else
   if (get_commentCount() < 250) {
   	echo "55"; }
   
   	else
   	echo "60";
   
   ?>

   Any idea how to put this as a function, rendering the result in a $resulthere so I can call it <?php resulthere() ?> by just a line on my comments?

   Thou, I am happy already, this works perfect!!! YEYE!!

Reply

You must log in to post.