<?php


   function minsPassed($start, $end)
   {

      If ($end > $start)
      {
         $time = $end - $start;
      }
      else
      {
         $time = $start - $end;
      }

      $elapsed = floor($time/60);

      return $elapsed;

   }

   function secsPassed($start, $end)
   {

      If ($end > $start)
      {
         $time = $end - $start;
      }
      else
      {
         $time = $start - $end;
      }

      return $time;

   }

   function getRealIpAddr()
   {

      if (!empty($_SERVER['HTTP_CLIENT_IP']))   //check ip from share internet
      {
         $ip=$_SERVER['HTTP_CLIENT_IP'];
      }
         elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR']))   //to check ip is pass from proxy
      {
         $ip=$_SERVER['HTTP_X_FORWARDED_FOR'];
      }
      else
      {
         $ip=$_SERVER['REMOTE_ADDR'];
      }

      return $ip;
   }


   function genUID()
   {
 
      $stamp = date("Ymdhis");
      $ip = getRealIPAddr();
      $orderid = "$stamp-$ip";
      $orderid = str_replace(".", "", "$orderid");
      return $orderid; 

   }

   function getImg($lastID)
   {
     $result = mysql_query("SELECT * FROM imgrotate WHERE id = '$lastID'");

     $row = mysql_fetch_array($result);

     return $row;
   }

   function getRandImg($lastID)
   {
     $result = mysql_query("SELECT * FROM imgrotate WHERE id NOT IN ('$lastID') ORDER BY Rand()");

     $row = mysql_fetch_array($result);
 
     $itemID = $row["id"];
 
     mysql_query("UPDATE imgrotate SET uses = uses + 1 WHERE id = '$itemID'") or die("ERROR:".mysql_error());

     return $row;
   }

define( "UPDATETIME", 1800 );

$server = "localhost";
$uName = "kwarcouk_be";
$sqlPass = "B1ng0B4ng0";

mysql_connect ($server, $uName, $sqlPass);
mysql_select_db ('kwarcouk_SitesDB');


?>