Improvements for Stattraq plugin.

Posted on Thursday the 29th of March, 2007 at 3:06 pm in WordPress

Ever since I originally started using Stattraq a few things bothered me about the way it worked. Here are the fixes to a few of them.

Include pages with posts in your stats.

Open stattraq.php
Find:
global $doing_rss, $p
Replace With:
global $doing_rss, $p, $page_id, $pagename,
Find:
1. if (($p != '')){
2. $p = intval($p);
3. $article_id = $p;
4. }
Replace with:
1. if (($p != '')){
2. $p = intval($p);
3. $article_id = $p;
4. }elseif (($page_id != '')){
5. $page_id = intval($page_id);
6. $article_id = $page_id;
7. }elseif (($pagename != '')){
8. $reqpage = get_page_by_path($pagename);
9. if ( !empty($reqpage) )
10. $article_id = $reqpage->ID;
11. }
12. Use the following to copy and paste the code.
  if (($p != '')){ $p = intval($p); $article_id = $p; }elseif (($page_id != '')){ $page_id = intval($page_id); $article_id = $page_id; }elseif (($pagename != '')){ $reqpage = get_page_by_path($pagename); if ( !empty($reqpage) ) $article_id = $reqpage->ID; }

To add a list of all Pages that link to your site grouped by Website (excluding Google):
Open “wp-stattraq/reporter/summary.php”

Find:

<?php echo PrintTimestamp();?>
</div>
<div id="queryTerms">

Before Add:

<table id="referrersTable">
<thead>
<tr>
<th>#</th>
<th>Referrer</th>
<th>Pages</th>
</tr>
</thead>
<tfoot>
<tr>
<th>#</th>
<th>Referrer</th>
<th>Pages</th>
</tr>
</tfoot>
<tbody>
<?php
if($results){
$i=0;
foreach($results as $row){
preg_match('/(http.*?\:\/\/.*?)(\/.*)/', htmlentities($row->ref), $matches);
$ref_array[$matches[1]][] = $matches[2];
}
while( list($site, $pages) = @each($ref_array) ){
if(strpos($site,'google') ==false && $site != ''){?>
<tr class="<?php echo ($i % 2 == 0 ? 'even' : 'odd' );?>"><td><?php echo ++$i;?></td>
<td>
<a href="<?php echo $site;?>"><?php echo substr($site,0,50);?></a></td>
<td class="right">
<?php foreach($pages as $page){?>
<a href="<?php echo $site.$page;?>"><?php echo substr($page,0,50);?></a><br/>
<?php}?>
</td>
</tr>
<?php }
}
}?>
</tbody>
</table>
Use the following to copy and paste the code.
<table id="referrersTable"> <thead> <tr> <th>#</th> <th>Referrer</th> <th>Pages</th> </tr> </thead> <tfoot> <tr> <th>#</th> <th>Referrer</th> <th>Pages</th> </tr> </tfoot> <tbody> <?php if($results){ $i=0; foreach($results as $row){ preg_match('/(http.*?\:\/\/.*?)(\/.*)/', htmlentities($row->ref), $matches); $ref_array[$matches[1]][] = $matches[2]; } while( list($site, $pages) = @each($ref_array) ){ if(strpos($site,'google') ==false && $site != ''){?> <tr class="<?php echo ($i % 2 == 0 ? 'even' : 'odd' );?>"><td><?php echo ++$i;?></td> <td> <a href="<?php echo $site;?>"><?php echo substr($site,0,50);?></a></td> <td class="right"> <?php foreach($pages as $page){?> <a href="<?php echo $site.$page;?>"><?php echo substr($page,0,50);?></a><br/> <?php}?> </td> </tr> <?php } } }?> </tbody> </table>