Little request

[stdio]

Hello,

I am displaying my stats on my website. I wish to display my stats in this format: (example: Hits: xxx,xxx and not Hits: xxxxxx). You see, there is a comma in the first version. I know it is possible because I saw it on a website but sadly I don't know how to do it. Can anyone help please?

Thank you!

[V@no]

In includes/functions.php find:
    "image_hits" => $image_row['image_hits'],

Replace with:
    "image_hits" => number_format($image_row['image_hits']),

[stdio]

Hi V@no!

Thanks for your reply. I did as you said but nothing is changed. I think it's because I am using the mini-stats mod and the stats are displayed from the stats.php file. I think something needs to be changed in this file:

Code: [Select]

//-----------------------------------------------------
//--- Hits --------------------------------------------
//-----------------------------------------------------
        $sql = "SELECT SUM(image_hits) AS sum
          FROM ".IMAGES_TABLE;
  $row = $site_db->query_firstrow($sql);

  $sum = (isset($row['sum'])) ? $row['sum'] : 0;
  $total_hits = "".$lang['total_hits']."<B> ".$row['sum']."</B>\n";

  $site_template->register_vars("total_hits", $total_hits);
unset($total_hits);

Please help.

Thank you very much!

[V@no]

  $total_hits = "".$lang['total_hits']."<B> ".number_format($row['sum'])."</B>\n";

[stdio]

Thank you very much! Works perfectly!

Happy Easter!

[stdio]

Hi V@no!

Can you help me with this issue for another "version" of stats?

Code: [Select]

    $sql = "SELECT COUNT(*) as all_total_users
          FROM ".USERS_TABLE."
                  WHERE user_id <> ".GUEST;
  $row = $site_db->query_firstrow($sql);
  $all_total_users = $row['all_total_users'];
  $lang_all_total_users = $lang['all_total_users'];

  $site_template->register_vars("all_total_users", $all_total_users);
  $site_template->register_vars("lang_all_total_users", $lang_all_total_users);
  unset($all_total_users);
  unset($lang_all_total_users);
I want the , in this code again. I tried to modify it but I always get a Parse error. Please help.

Thank you!

[V@no]

  $site_template->register_vars("all_total_users", number_format($all_total_users));

should do it.

[stdio]

Thank you very much! Works wonders!

Have a great day!

I have like 2-3 versions of different stats (total hits, total members, etc). Could you advise me how to change this code:

Code: [Select]

       $sql = "SELECT SUM(image_hits) AS sum
          FROM ".IMAGES_TABLE;
  $row = $site_db->query_firstrow($sql);

  $sum = (isset($row['sum'])) ? $row['sum'] : 0;
$total_hits = "".$lang['total_hits']."<B> ".number_format($row['sum'])."</B>\n";

  $site_template->register_vars("total_hits", $total_hits);
unset($total_hits);into a more friendly one like:

Code: [Select]

   $sql = "SELECT COUNT(*) as all_total_users
          FROM ".USERS_TABLE."
                  WHERE user_id <> ".GUEST;
  $row = $site_db->query_firstrow($sql);
  $all_total_users = $row['all_total_users'];
  $lang_all_total_users = $lang['all_total_users'];

  $site_template->register_vars("all_total_users", number_format($all_total_users));
  $site_template->register_vars("lang_all_total_users", $lang_all_total_users);
  unset($all_total_users);
  unset($lang_all_total_users);
As you see, total hits is very different than total users. I want to have all stats code the same way. I like order. Hope you understand.

Thank you very much for your time!

[stdio]

Hi V@no!

I am writing again because you probably didn't notice that I updated my previous post. Can you help in regards to that?

Thank you!

[V@no]

Sorry, I don't understand your question...

[stdio]

Dear V@no,

I want to turn this version:

Code: [Select]

        $sql = "SELECT SUM(image_hits) AS sum
          FROM ".IMAGES_TABLE;
  $row = $site_db->query_firstrow($sql);

  $sum = (isset($row['sum'])) ? $row['sum'] : 0;
$total_hits = "".$lang['total_hits']."<B> ".number_format($row['sum'])."</B>\n";

  $site_template->register_vars("total_hits", $total_hits);
unset($total_hits);into this version:

Code: [Select]

    $sql = "SELECT COUNT(*) as all_total_users
          FROM ".USERS_TABLE."
                  WHERE user_id <> ".GUEST;
  $row = $site_db->query_firstrow($sql);
  $all_total_users = $row['all_total_users'];
  $lang_all_total_users = $lang['all_total_users'];

  $site_template->register_vars("all_total_users", number_format($all_total_users));
  $site_template->register_vars("lang_all_total_users", $lang_all_total_users);
  unset($all_total_users);
  unset($lang_all_total_users);.

You understand now? If not I will try to explain better. Basically I am using 2 versions of stats, collected from different threads but both do the same thing.