[Проблема]

I am trying to show external link clicks next to links in post, like how twitter forums do:


I have everything ready, I just need help getting the count to show next to links in post through plugins.



plugin:
postbit_display_complete

$this->post['message'] = str_replace('href="', 'href="./out.php?link=', $this->post['message']);
$this->post['signature'] = str_replace('href="', 'href="./out.php?link=', $this->post['signature']);

this captures any link posted and sends it through out.php

out.php which captures the link to the database:

PHP Code:

define('NO_REGISTER_GLOBALS', 1);
define('THIS_SCRIPT', 'drc-lf');
require_once('./global.php');

if (isset($_GET['link'])) {
    // format passed url
    $drc_url = $_GET['link'];
    unset($_GET['link']);
    if(count($_GET))
        $drc_url = $drc_url . '&' . http_build_query($_GET);

    // deals w/ the display if $drc_url is a valid URL
    if (filter_var($drc_url, FILTER_VALIDATE_URL)) {
        $site = parse_url($_SERVER['HTTP_HOST']);
        $site = $site['path'];
        $url = parse_url($drc_url);
        
        // the passed url is not an external link
        if ($site == $url['host']) {
            Header( "Location: ". $drc_url);
        }
        // the passed url is an external link
        else {
          $query = $db->query_first("SELECT * FROM ". TABLE_PREFIX ."redirect WHERE url = '" . $drc_url . "'"); 
          if (!$query){ 
              $db->query_write("INSERT INTO ". TABLE_PREFIX ."redirect (url, hits) VALUES ('" . $drc_url . "', 1)");
          } else { 
              $db->query_write("UPDATE ". TABLE_PREFIX ."redirect SET hits = hits + 1 WHERE url = '" . $drc_url . "'"); 
          }  
           
            eval('print_output("' . fetch_template('drc_lf') . '");');
        }
    // open invalid link
    } else {
        Header( "Location: ". $drc_url);
    }
} 


So I have the data I need, I just don't know where to go from here.
Something like this should return the results:

$vbulletin->db->query_first("
  SELECT SUM(hits) AS hits
  FROM " . TABLE_PREFIX . "redirect
  WHERE url = '$drc_url'
");

I just don't know what to do with it, what plugin to create it in, or maybe even a cron task. I just need some help getting the final result like the first IMG

PHP Code:

filter_var($drc_url, FILTER_VALIDATE_URL) 


this function (filter_var) won't work with national domains like россия.рф
PHP does not support yet http://php.net/manual/ru/function.filter-var.php#111828
debug:

PHP Code:

$url1 = 'http://россия.рф/';
$url2 = 'http://russia.ru/';
print '<pre>';
var_dump(filter_var($url1, FILTER_VALIDATE_URL));
print '<br />';
var_dump(filter_var($url2, FILTER_VALIDATE_URL));
print '</pre>'; 


result


more reasons do not use this function in your projects
http://php.net/manual/ru/function.filter-var.php#118257
http://php.net/manual/ru/function.filter-var.php#108769
http://php.net/manual/ru/function.filter-var.php#118676