[Mod] More Statistics for your visitors

[rustynet]

Thanks V@no  



boti

[jengwen]

To see total images rated, add this to stats.php

Code: [Select]

//-----------------------------------------------------
//--- Ratings------------------------------------------
//-----------------------------------------------------
   $sql = "SELECT COUNT(image_rating) AS sum
          FROM ".IMAGES_TABLE.
          " WHERE image_rating > 0";
  $row = $site_db->query_firstrow($sql);

  $sum = (isset($row['sum'])) ? $row['sum'] : 0;
  $total_rating = "".$lang['total_rating']."<B> ".$row['sum']."</B>\n";
 
  $site_template->register_vars("total_rating", $total_rating);
unset($total_rating);


You will also have to add to main.php

Code: [Select]

$lang['total_rating'] = "Total Images Rated:";

You can now use {total_rating} in your templates.  Here is an example of mine:

Code: [Select]


<table width="450" border="0" cellspacing="0" cellpadding="1">
                    <tr>
                      <td class="head1">
                        <table width="100%" border="0" cellspacing="0" cellpadding="3">
                          <tr>
                            <td valign="top" class="head1">Gallery Statistics</td>
                          </tr>
                          <tr>
                            <td valign="top" class="row2"> {total_users}<br>
                              {total_votes} <br>
                              {total_comments}<br>
                              {total_hits}<br>
                              {total_downloads}<br>
                              {total_rating} </td>
                          </tr>
                        </table>
                      </td>
                    </tr>
                    </table>


I tried to make this a template of its own, like whos_online, but couldn't get it to work.  I created it as a separate template called stats.html and added it to the templates used in index.php.  Nothing showed up, so I just hard-coded the html into my home and top templates.  This works, but isn't as nice, so if anyone has it working a cleaner way, could you please let me know what to do.

[rustynet]

hey thats coll, thanks jengwen  


boti

[Maweryk]

@v@no: Can U explain me how to extend the gallery stats to

- New Images
- Sent postcards
- ...

like on your website.

Thanks a lot and cheers,

Markus

[V@no]

@v@no: Can U explain me how to extend the gallery stats

I did it in a "dirty" way, messing up the USERS_TABLE...but then, Jan suggested me this:

Create a new table like this:
Code:
CREATE TABLE 4images_cat_stats (
  user_id mediumint(8) unsigned NOT NULL default '0',
  cat_id mediumint(8) unsigned NOT NULL default '0',
  cat_hits int(10) unsigned NOT NULL default '0',
  image_hits int(10) unsigned NOT NULL default '0',
  downloads int(10) unsigned NOT NULL default '0',
  postcards int(10) unsigned NOT NULL default '0',
  KEY user_id (user_id),
  KEY cat_id (cat_id)
) TYPE=MyISAM;

The fields user_id and cat_id are reference fields, the other fields contains the hit counts.

You can now store entries for each user_id depending on categories. User with ID 1 visits category with ID 1 the first time: The entry will be created and will be referenced on the user_id and cat_id. If the user visits category with ID 1 again, the entry will be updated depending on his user_id and the cat_id. If he visits category with ID 2, a new entry will be created with user_id = 1 and cat_id = 2. And so on...



You can pull infos about what you want. Relating on user_id's or cat_id's.

Examples:

Fetch 10 users most visited category with ID <cat_id>:
Code:
$sql = "SELECT u.user_id, u.user_name, cs.cat_hits, c.cat_name [...]
        FROM ".USERS_TABLE." u, ".CATEGORIES_TABLE." c, 4images_cat_stats cs
        WHERE cs.cat_id = <cat_id> AND u.user_id = c.user_id AND c.cat_id = cs.cat_id
        ORDER BY cs.cat_hits DESC
        LIMIT 10";

$site_db->query($sql);  


Fetch 10 categories who are most visited by user with ID <user_id>:
Code:
$sql = "SELECT u.user_id, u.user_name, cs.cat_hits, c.cat_name [...]
        FROM ".USERS_TABLE." u, ".CATEGORIES_TABLE." c, 4images_cat_stats cs
        WHERE cs.user_id = <user_id> AND c.cat_id = cs.cat_id AND u.user_id = cs.user_id
        ORDER BY cs.cat_hits DESC
        LIMIT 10";

$site_db->query($sql);  

Jan

I will try do this way somethimes soon, if I successed, I might post it as MOD here ;)

[Maweryk]

@v@no: Can U explain me how to extend the gallery stats

I did it in a "dirty" way, messing up the USERS_TABLE...but then, Jan suggested me this:

Create a new table like this:
Code:
CREATE TABLE 4images_cat_stats (
  user_id mediumint( unsigned NOT NULL default '0',
  cat_id mediumint( unsigned NOT NULL default '0',
  cat_hits int(10) unsigned NOT NULL default '0',
  image_hits int(10) unsigned NOT NULL default '0',
  downloads int(10) unsigned NOT NULL default '0',
  postcards int(10) unsigned NOT NULL default '0',
  KEY user_id (user_id),
  KEY cat_id (cat_id)
) TYPE=MyISAM;

The fields user_id and cat_id are reference fields, the other fields contains the hit counts.

You can now store entries for each user_id depending on categories. User with ID 1 visits category with ID 1 the first time: The entry will be created and will be referenced on the user_id and cat_id. If the user visits category with ID 1 again, the entry will be updated depending on his user_id and the cat_id. If he visits category with ID 2, a new entry will be created with user_id = 1 and cat_id = 2. And so on...



You can pull infos about what you want. Relating on user_id's or cat_id's.

Examples:

Fetch 10 users most visited category with ID <cat_id>:
Code:
$sql = "SELECT u.user_id, u.user_name, cs.cat_hits, c.cat_name [...]
        FROM ".USERS_TABLE." u, ".CATEGORIES_TABLE." c, 4images_cat_stats cs
        WHERE cs.cat_id = <cat_id> AND u.user_id = c.user_id AND c.cat_id = cs.cat_id
        ORDER BY cs.cat_hits DESC
        LIMIT 10";

$site_db->query($sql);  


Fetch 10 categories who are most visited by user with ID <user_id>:
Code:
$sql = "SELECT u.user_id, u.user_name, cs.cat_hits, c.cat_name [...]
        FROM ".USERS_TABLE." u, ".CATEGORIES_TABLE." c, 4images_cat_stats cs
        WHERE cs.user_id = <user_id> AND c.cat_id = cs.cat_id AND u.user_id = cs.user_id
        ORDER BY cs.cat_hits DESC
        LIMIT 10";

$site_db->query($sql);  

Jan

I will try do this way somethimes soon, if I successed, I might post it as MOD here

Short question! Do U have finished the mod???

Thanks!!!

Cheers,

Markus

[V@no]

Short question! Do U have finished the mod???

Sorry, no. After all I did to my database and 4images code itself I dont know what is what anymore. Maybe after major cleaning up or starting everything over, I will try finish with this one.

[Bomba]

how can i have stats like this?

http://www.newman.d2g.com/index.php?template=sitestats
they look great!

[Chris]

Yes and no.  Those stats are a combination of this mod and from a logging tool called pphlogger from www.phpee.com

[tmacisnbr1]

hello

ive done everything correct i think, but im not sure where to add the tags or how to add them in the html files. When i add the tags, i guess i add them to the wrong place, because when i go to the site, it just gives some weird number, like "total downloads: 5738" or something. Can anyone please help?

[www.girls-on-bikes.com]

Hello All,
This looks like a great mod, but I wanna include it on every page on my nav bar (click on link below, you will see the "Site Statistics" section where I want them).

Problem is the templating I'm using uses a file called 4gmenu.php, which is included on all pages and I am able to add things to that file and have them show up on every page (the "Navigation" and "Sponsors" sections are stored in this file).

Is there any way I can have the stats in this file too?
When I try to include stats.php in 4gmenu.php, I get this error:

Fatal error: Call to a member function on a non-object in /home/gob/public_html/new/gallery/includes/stats.php on line 9

Line 9 contains:

Code: [Select]

$row = $site_db->query_firstrow($sql);

Anybody have any ideas what the problem is?
Thanks!

[V@no]

try add this before your stats.php include:

Code: [Select]

define('ROOT_PATH', './');
@include(ROOT_PATH.'config.php');
include(ROOT_PATH.'includes/constants.php');
include(ROOT_PATH.'includes/db_'.strtolower($db_servertype).'.php');
$site_db = new Db($db_host, $db_user, $db_password, $db_name);

[www.girls-on-bikes.com]

New Error:

Fatal error: Cannot redeclare class db in /home/gob/public_html/new/gallery/includes/db_mysql.php on line 28

[V@no]

I ment inside 4gmenu.php ....?

[www.girls-on-bikes.com]

Yep, that's inside 4gmenu.php