<?php
ob_start();
session_start();
?>
<?php require_once('Connections/conn_tr.php'); ?>

<?php
$currentPage = $HTTP_SERVER_VARS["PHP_SELF"];

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
			$theValue = ($theValue != "") ? "'" . date("Y-m-d",strtotime($theValue)) . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
?>
<?php require_once('../Connections/mms.php'); ?>
<?php
mysql_select_db($database_conn_tr, $conn_tr);
$query_rs_login = "SELECT * FROM tbl_users";
$rs_login = mysql_query($query_rs_login, $conn_tr) or die(mysql_error());
$row_rs_login = mysql_fetch_assoc($rs_login);
$totalRows_rs_login = mysql_num_rows($rs_login);

$colname_rsUserDetails = "1";
if (isset($HTTP_SESSION_VARS['sv_login'])) {
  $colname_rsUserDetails = (get_magic_quotes_gpc()) ? $HTTP_SESSION_VARS['sv_login'] : addslashes($HTTP_SESSION_VARS['sv_login']);
}
mysql_select_db($database_conn_tr, $conn_tr);
$query_rsUserDetails = sprintf("SELECT *, date_format(login_timestamp, '%%a %%e %%b') as user_last_login_date FROM tbl_users, tbl_user_login, tbl_location WHERE user_name = '%s' AND location_id = user_location", $colname_rsUserDetails);
$rsUserDetails = mysql_query($query_rsUserDetails, $conn_tr) or die(mysql_error());
$row_rsUserDetails = mysql_fetch_assoc($rsUserDetails);
$totalRows_rsUserDetails = mysql_num_rows($rsUserDetails);

$colname_rs_Last_login_LOCAL = "-1";
if (isset($HTTP_SESSION_VARS['sv_login'])) {
  $colname_rs_Last_login_LOCAL = (get_magic_quotes_gpc()) ? $HTTP_SESSION_VARS['sv_login'] : addslashes($HTTP_SESSION_VARS['sv_login']);
}
mysql_select_db($database_conn_tr, $conn_tr);
$query_rs_Last_login_LOCAL = sprintf("SELECT *, DATE_FORMAT(DATE_ADD(login_timestamp, INTERVAL location_timezone HOUR),  '%%W, %%b %%e %%Y') AS DateOutput, login_user_name FROM tbl_user_login, tbl_users, tbl_location WHERE user_name = '%s' AND location_id = user_location ORDER BY login_id DESC LIMIT 1,2", $colname_rs_Last_login_LOCAL);
$rs_Last_login_LOCAL = mysql_query($query_rs_Last_login_LOCAL, $conn_tr) or die(mysql_error());
$row_rs_Last_login_LOCAL = mysql_fetch_assoc($rs_Last_login_LOCAL);
$totalRows_rs_Last_login_LOCAL = mysql_num_rows($rs_Last_login_LOCAL);

$colname_rs_Last_login_GMT = "-1";
if (isset($HTTP_SESSION_VARS['sv_login'])) {
  $colname_rs_Last_login_GMT = (get_magic_quotes_gpc()) ? $HTTP_SESSION_VARS['sv_login'] : addslashes($HTTP_SESSION_VARS['sv_login']);
}
mysql_select_db($database_conn_tr, $conn_tr);
$query_rs_Last_login_GMT = sprintf("SELECT *, DATE_FORMAT(login_timestamp, '%%W, %%b %%e %%Y %%T') AS logintimestamp FROM tbl_user_login, tbl_users WHERE user_name = '%s' ORDER BY login_id DESC LIMIT 1,2", $colname_rs_Last_login_GMT);
$rs_Last_login_GMT = mysql_query($query_rs_Last_login_GMT, $conn_tr) or die(mysql_error());
$row_rs_Last_login_GMT = mysql_fetch_assoc($rs_Last_login_GMT);
$totalRows_rs_Last_login_GMT = mysql_num_rows($rs_Last_login_GMT);

mysql_select_db($database_conn_tr, $conn_tr);
$query_rs_Users_online = "SELECT DISTINCT file FROM useronline";
$rs_Users_online = mysql_query($query_rs_Users_online, $conn_tr) or die(mysql_error());
$row_rs_Users_online = mysql_fetch_assoc($rs_Users_online);
$totalRows_rs_Users_online = mysql_num_rows($rs_Users_online);

mysql_select_db($database_conn_tr, $conn_tr);
$query_rs_Users_online_last = "SELECT DISTINCT file, 'and, ' FROM useronline ORDER BY file DESC LIMIT 0,1";
$rs_Users_online_last = mysql_query($query_rs_Users_online_last, $conn_tr) or die(mysql_error());
$row_rs_Users_online_last = mysql_fetch_assoc($rs_Users_online_last);
$totalRows_rs_Users_online_last = mysql_num_rows($rs_Users_online_last);

mysql_select_db($database_conn_tr, $conn_tr);
$query_ts_Users_online_allbutlast = "SELECT DISTINCT file FROM useronline ";
$ts_Users_online_allbutlast = mysql_query($query_ts_Users_online_allbutlast, $conn_tr) or die(mysql_error());
$row_ts_Users_online_allbutlast = mysql_fetch_assoc($ts_Users_online_allbutlast);
$totalRows_ts_Users_online_allbutlast = mysql_num_rows($ts_Users_online_allbutlast);

$colname_rs_Last_login_LOCAL_time = "-1";
if (isset($HTTP_SESSION_VARS['sv_login'])) {
  $colname_rs_Last_login_LOCAL_time = (get_magic_quotes_gpc()) ? $HTTP_SESSION_VARS['sv_login'] : addslashes($HTTP_SESSION_VARS['sv_login']);
}
mysql_select_db($database_conn_tr, $conn_tr);
$query_rs_Last_login_LOCAL_time = sprintf("SELECT *, DATE_FORMAT(DATE_ADD(login_timestamp, INTERVAL location_timezone HOUR),  '%%T') AS DateOutputlocaltime, login_user_name FROM tbl_user_login, tbl_users, tbl_location WHERE user_name = '%s' AND user_location = location_id ORDER BY login_id DESC LIMIT 1,2", $colname_rs_Last_login_LOCAL_time);
$rs_Last_login_LOCAL_time = mysql_query($query_rs_Last_login_LOCAL_time, $conn_tr) or die(mysql_error());
$row_rs_Last_login_LOCAL_time = mysql_fetch_assoc($rs_Last_login_LOCAL_time);
$totalRows_rs_Last_login_LOCAL_time = mysql_num_rows($rs_Last_login_LOCAL_time);

$colname_rs_my_plans = "1";
if (isset($HTTP_SESSION_VARS['sv_login'])) {
  $colname_rs_my_plans = (get_magic_quotes_gpc()) ? $HTTP_SESSION_VARS['sv_login'] : addslashes($HTTP_SESSION_VARS['sv_login']);
}
mysql_select_db($database_conn_tr, $conn_tr);
$query_rs_my_plans = sprintf("SELECT * FROM tbl_plans, tbl_users WHERE plans_person = user_id AND user_name = '%s'", $colname_rs_my_plans);
$rs_my_plans = mysql_query($query_rs_my_plans, $conn_tr) or die(mysql_error());
$row_rs_my_plans = mysql_fetch_assoc($rs_my_plans);
$totalRows_rs_my_plans = mysql_num_rows($rs_my_plans);

$maxRows_rs_all_plans = 10;
$pageNum_rs_all_plans = 0;
if (isset($HTTP_GET_VARS['pageNum_rs_all_plans'])) {
  $pageNum_rs_all_plans = $HTTP_GET_VARS['pageNum_rs_all_plans'];
}
$startRow_rs_all_plans = $pageNum_rs_all_plans * $maxRows_rs_all_plans;

mysql_select_db($database_conn_tr, $conn_tr);
$query_rs_all_plans = "SELECT * FROM tbl_plans";
$query_limit_rs_all_plans = sprintf("%s LIMIT %d, %d", $query_rs_all_plans, $startRow_rs_all_plans, $maxRows_rs_all_plans);
$rs_all_plans = mysql_query($query_limit_rs_all_plans, $conn_tr) or die(mysql_error());
$row_rs_all_plans = mysql_fetch_assoc($rs_all_plans);

if (isset($HTTP_GET_VARS['totalRows_rs_all_plans'])) {
  $totalRows_rs_all_plans = $HTTP_GET_VARS['totalRows_rs_all_plans'];
} else {
  $all_rs_all_plans = mysql_query($query_rs_all_plans);
  $totalRows_rs_all_plans = mysql_num_rows($all_rs_all_plans);
}
$totalPages_rs_all_plans = ceil($totalRows_rs_all_plans/$maxRows_rs_all_plans)-1;

mysql_select_db($database_conn_tr, $conn_tr);
$query_rs_random_users = "SELECT *, date_format(login_timestamp, '%a %e %b') as user_last_login_date FROM tbl_users, tbl_user_login, tbl_location";
$rs_random_users = mysql_query($query_rs_random_users, $conn_tr) or die(mysql_error());
$row_rs_random_users = mysql_fetch_assoc($rs_random_users);
$totalRows_rs_random_users = mysql_num_rows($rs_random_users);

$maxRows_rs_news = 10;
$pageNum_rs_news = 0;
if (isset($HTTP_GET_VARS['pageNum_rs_news'])) {
  $pageNum_rs_news = $HTTP_GET_VARS['pageNum_rs_news'];
}
$startRow_rs_news = $pageNum_rs_news * $maxRows_rs_news;

mysql_select_db($database_conn_tr, $conn_tr);
$query_rs_news = "SELECT *, date_format(submitted_timestamp, '%a %e %b %Y') as submitted FROM tbl_news";
$query_limit_rs_news = sprintf("%s LIMIT %d, %d", $query_rs_news, $startRow_rs_news, $maxRows_rs_news);
$rs_news = mysql_query($query_limit_rs_news, $conn_tr) or die(mysql_error());
$row_rs_news = mysql_fetch_assoc($rs_news);

if (isset($HTTP_GET_VARS['totalRows_rs_news'])) {
  $totalRows_rs_news = $HTTP_GET_VARS['totalRows_rs_news'];
} else {
  $all_rs_news = mysql_query($query_rs_news);
  $totalRows_rs_news = mysql_num_rows($all_rs_news);
}
$totalPages_rs_news = ceil($totalRows_rs_news/$maxRows_rs_news)-1;

mysql_select_db($database_conn_tr, $conn_tr);
$query_rs_images = "SELECT *, date_format(upload_date, '%a %e %b %Y') as uploaded FROM tbl_images, tbl_albums GROUP BY name ORDER BY rand() limit 2 ";
$rs_images = mysql_query($query_rs_images, $conn_tr) or die(mysql_error());
$row_rs_images = mysql_fetch_assoc($rs_images);
$totalRows_rs_images = mysql_num_rows($rs_images);

mysql_select_db($database_conn_tr, $conn_tr);
$query_rs_images2 = "SELECT *, date_format(upload_date, '%a %e %b %Y') as uploaded FROM tbl_images, tbl_albums GROUP BY name ORDER BY rand() limit 2 ";
$rs_images2 = mysql_query($query_rs_images2, $conn_tr) or die(mysql_error());
$row_rs_images2 = mysql_fetch_assoc($rs_images2);
$totalRows_rs_images2 = mysql_num_rows($rs_images2);

$maxRows_rsTopics = 10;
$pageNum_rsTopics = 0;
if (isset($HTTP_GET_VARS['pageNum_rsTopics'])) {
  $pageNum_rsTopics = $HTTP_GET_VARS['pageNum_rsTopics'];
}
$startRow_rsTopics = $pageNum_rsTopics * $maxRows_rsTopics;

mysql_select_db($database_conn_tr, $conn_tr);
$query_rsTopics = "SELECT * FROM blg_topic_top ORDER BY title_top ASC";
$query_limit_rsTopics = sprintf("%s LIMIT %d, %d", $query_rsTopics, $startRow_rsTopics, $maxRows_rsTopics);
$rsTopics = mysql_query($query_limit_rsTopics, $conn_tr) or die(mysql_error());
$row_rsTopics = mysql_fetch_assoc($rsTopics);

if (isset($HTTP_GET_VARS['totalRows_rsTopics'])) {
  $totalRows_rsTopics = $HTTP_GET_VARS['totalRows_rsTopics'];
} else {
  $all_rsTopics = mysql_query($query_rsTopics);
  $totalRows_rsTopics = mysql_num_rows($all_rsTopics);
}
$totalPages_rsTopics = ceil($totalRows_rsTopics/$maxRows_rsTopics)-1;

mysql_select_db($database_conn_tr, $conn_tr);
$query_rsArticleDates = "SELECT date_format(date_art, '%Y-%c-%e') as ArticleDate FROM blg_article_art";
$rsArticleDates = mysql_query($query_rsArticleDates, $conn_tr) or die(mysql_error());
$row_rsArticleDates = mysql_fetch_assoc($rsArticleDates);
$totalRows_rsArticleDates = mysql_num_rows($rsArticleDates);

$maxRows_rsArticles = 10;
$pageNum_rsArticles = 0;
if (isset($HTTP_GET_VARS['pageNum_rsArticles'])) {
  $pageNum_rsArticles = $HTTP_GET_VARS['pageNum_rsArticles'];
}
$startRow_rsArticles = $pageNum_rsArticles * $maxRows_rsArticles;

mysql_select_db($database_conn_tr, $conn_tr);
$query_rsArticles = "SELECT * FROM blg_article_art";
$query_limit_rsArticles = sprintf("%s LIMIT %d, %d", $query_rsArticles, $startRow_rsArticles, $maxRows_rsArticles);
$rsArticles = mysql_query($query_limit_rsArticles, $conn_tr) or die(mysql_error());
$row_rsArticles = mysql_fetch_assoc($rsArticles);

if (isset($HTTP_GET_VARS['totalRows_rsArticles'])) {
  $totalRows_rsArticles = $HTTP_GET_VARS['totalRows_rsArticles'];
} else {
  $all_rsArticles = mysql_query($query_rsArticles);
  $totalRows_rsArticles = mysql_num_rows($all_rsArticles);
}
$totalPages_rsArticles = ceil($totalRows_rsArticles/$maxRows_rsArticles)-1;

$queryString_rsArticles = "";
if (!empty($HTTP_SERVER_VARS['QUERY_STRING'])) {
  $params = explode("&", $HTTP_SERVER_VARS['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_rsArticles") == false && 
        stristr($param, "totalRows_rsArticles") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_rsArticles = "&" . implode("&", $newParams);
  }
}
$queryString_rsArticles = sprintf("&totalRows_rsArticles=%d%s", $totalRows_rsArticles, $queryString_rsArticles);

$maxRows_rsArticles = 4;
$pageNum_rsArticles = 0;
if (isset($_GET['pageNum_rsArticles'])) {
  $pageNum_rsArticles = $_GET['pageNum_rsArticles'];
}
$startRow_rsArticles = $pageNum_rsArticles * $maxRows_rsArticles;

mysql_select_db($database_mms, $mms);
$query_rsArticles = "SELECT *, date_format(date_art, '%a %e %b %Y') as date FROM blg_article_art INNER JOIN blg_topic_top ON idtop_art=id_top ORDER BY date_art DESC";
$query_limit_rsArticles = sprintf("%s LIMIT %d, %d", $query_rsArticles, $startRow_rsArticles, $maxRows_rsArticles);
$rsArticles = mysql_query($query_limit_rsArticles, $mms) or die(mysql_error());
$row_rsArticles = mysql_fetch_assoc($rsArticles);

if (isset($_GET['totalRows_rsArticles'])) {
  $totalRows_rsArticles = $_GET['totalRows_rsArticles'];
} else {
  $all_rsArticles = mysql_query($query_rsArticles);
  $totalRows_rsArticles = mysql_num_rows($all_rsArticles);
}
$totalPages_rsArticles = ceil($totalRows_rsArticles/$maxRows_rsArticles)-1;

$user_online_name = $row_rsUserDetails['user_first_name']
?>


<?php
// Configuration

$timeoutseconds = 600; // length of session, 20 minutes is the standard

$timestamp=time();
$timeout=$timestamp-$timeoutseconds;
$ip = substr($REMOTE_ADDR, 0, strrpos($REMOTE_ADDR,"."));

// Connect to MySQL Database


// Add this user to database
$loopcap = 0;
while ($loopcap<3 && @mysql_query("insert into useronline values('$timestamp','$ip','$user_online_name')"))
{ // in case of collision
$timestamp = $timestamp+$ip{0}; $loopcap++;
}

// Delete users that have been online for more then "$timeoutseconds" seconds
@mysql_query("delete from useronline where timestamp<$timeout");

// Select users online
$result = @mysql_query("select distinct file from useronline");
$user = @mysql_num_rows($result);

mysql_free_result($result);
@mysql_close();

?>


<html>
<head>
<title>In time of chimpanzees, I was a penguin....</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">


<link href="../css/style.css" rel="stylesheet" type="text/css">

<!-- begin rollover -->
<script language="JavaScript" type="text/JavaScript">
<!--

function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
//-->
</script>

<link href="/css/style.css" rel="stylesheet" type="text/css">


</head>
<body>
<br>
<table width="800" height="600" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>


<td height="600" colspan="5"><p><font size="2"><strong>Tim Reeve</strong> is an internet executive,
        venture capitalist, and mentor to technology start-ups. He has a proven
        track record in leadership, strategy, and implementation of projects;
        focussing on rigorous planning and execution to ensure objectives
        are
        met. Excelling in strategic and financial forecasting, project and
        man management, and pursuasive sales pitching; he is at home in
        high
        pressure  environments, is an excellent
      communicator, and a natural team leader.</font></p>
      <p><font size="2">Currently he is helping build <strong><a href="http://www.georeach.com/" target="_blank" class="style1"><span class="style2">Geo</span><span class="style3">Reach.com</span></a></strong>; an internet start up exploiting disruptive technology in the risk management world of GPS tracking and threat awareness.</font></p>
        <p><font size="2">His</font><font size="2"> experience includes appointments
        such as the Managing Director of <strong>CES
          plc</strong> (now <strong><a href="http://www.funtechnologies.com" target="_blank">FUN
            plc</a></strong> - a leading
        provider of gaming technology and games of skill products);  the
        Chief Executive Officer of <strong>ensurePay Ltd</strong> (a UK internet
        payments company);  the Chief Technology Officer at <strong><a href="http://corporate.betfair.com/" target="_blank">Betfair.com
          plc</a></strong> (the global leader in B2C exchange betting); and as
        the Chief Technology Officer for <strong><a href="http://www.uswitch.com" target="_blank">uSwitch.com</a></strong> (the
        UK's leading consumer comparison site). </font></p>
      <p><font size="2"> Previously he worked
        in the defence sector;  commisioned into the Grenadier Guards,
        Tim served
        worldwide in  military, security, and intelligence orientated
        roles - notably running covert surveillance operations in Northern
        Ireland,
        commanding
        the British Army's Urban Counter
        Terrorism
        school (SOTAT),
        serving
        in UKSF,
        consulting to the <strong>Defense Evaluation and Research Agency</strong> (now <a href="http://www.qinetiq.com" target="_blank"><strong>Qinetiq
          plc</strong></a>), and working in
        the private security sector for <a href="http://www.aegisworld.com/" target="_blank"><strong>Aegis World</strong></a>.</font></p>
      <p> </p>
      <p><font size="2">He also likes paragliding....</font></p>
      <p>&nbsp;</p>
      <p><font size="2">For a full CV, please <a href="mailto:mail@timreeve.com">get
        in touch</a>.</font></p></td>
  </tr>
  
<tr>


<td height="0" colspan="4"></td>
  </tr>
  <tr>
    <td height="0" colspan="5"></td>
  </tr>
  <tr>
  </tr>
  <tr>
    <td height="13" nowrap><a href="index.html">Home</a> | <a href="cv.html" target="_self"> CV</a> |
      <a href="http://www.linkedin.com/in/twreeve" target="_blank"><img src="images/linkedin-small-icon.gif" alt="LinkedIn" width="16" height="16" align="absbottom"></a>  | &#169; 2016
    Tim Reeve| <a href="mailto:mail@timreeve.com">Contact</a> </td>

    <td nowrap><a href="mb.html" target="_self">Elvis on Mont Blanc</a></td>
	<td nowrap><a href="w2mb.html" target="_self">Wellington to Mont Blanc</a></td>
    <td nowrap><a href="hampshire.html" target="_self">Tea in Hampshire</a></td>
  <tr>
    <td height="1" colspan="5" class="footerline"></td>
  </tr>
</table>
</body>
</html>
<?php
mysql_free_result($rs_login);

mysql_free_result($rsUserDetails);

mysql_free_result($rs_Last_login_LOCAL);

mysql_free_result($rs_Last_login_GMT);

mysql_free_result($rs_Users_online);

mysql_free_result($rs_Users_online_last);

mysql_free_result($ts_Users_online_allbutlast);

mysql_free_result($rs_Last_login_LOCAL_time);

mysql_free_result($rs_my_plans);

mysql_free_result($rs_all_plans);

mysql_free_result($rs_random_users);

mysql_free_result($rs_news);

mysql_free_result($rs_images);

mysql_free_result($rs_images2);

mysql_free_result($rsTopics);

mysql_free_result($rsArticleDates);

mysql_free_result($rsArticles);
?>