input->getInt('Itemid');
if (is_array($src_variables)) {foreach ($src_variables as $src_key => $src_value) {${$src_key} = $src_value;}}
$dbServer = "localhost";
$nameUser = "ctsadmin_jos5";
$passName = "T&F3WvItVi1tia&y*i*35(^3";
$dbName = "ctsadmin_jos5";
date_default_timezone_set('America/New_York');
$machIP = gethostbyaddr($_SERVER['REMOTE_ADDR']);
$user = JFactory::getUser();
$dtme = date(DATE_ATOM, time());
echo $machIP;
echo "
";
echo $user->id;
echo "
";
echo $user->username;
echo "
";
echo $dtme;
if ($user->guest) {
echo "You must login to see the content. I want your email address.
";
}
else {
echo "You are logged in, you can see the content.
";
try {
$conDB = new mysqli($dbServer,$nameUser,$passName,$dbName);
}
catch(Exception $e){
die( print_r( $e->getMessage() ) );
}
if ($conDB->connect_error) {
die("Connection Failed: " . $conDB->connect_error);
}
echo "Connected Successfully
";
//Check if Record Exists
$dbQuery = "SELECT userid ";
$dbQuery .= "FROM jos_user_tos ";
$dbQuery .= "WHERE userid=$user->id ";
echo $dbQuery
;
$results = $conDB->query($dbQuery);
if ($results->num_rows > 0 ) {
echo "
RECORD EXISTS
";
}
else {
//Add Record if not already there.
$dbQuery = "INSERT INTO jos_user_tos (userid,userip,userdttme) ";
$dbQuery .= "VALUES ($user->id,'$machIP','$dtme') ";
if ($conDB->query($dbQuery) === TRUE) {
echo "New record created successfully";
} else {
echo "Error: " . $dbQuery . "
" . $conDB->error;
}
}
$conDB->close();
};;
return get_defined_vars();
;}