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());
if ($user->guest) {
echo "You must login to see the content.
";
}
else {
echo "You are logged in, you can see the content.
";
//CREATE CONNECTION TO DATABASE
try {
$conDB = new mysqli($dbServer,$nameUser,$passName,$dbName);
}
//IF CONNECTION FAILS, PROVIDE ERROR MESSAGE AND DIE
catch(Exception $e){
die( print_r( $e->getMessage() ) );
}
//VALIDATE DB CONNECTION
if ($conDB->connect_error) {
die("Connection Failed: " . $conDB->connect_error);
}
//echo "Connected Successfully
";
//CHECK IF USER RECORD EXISTS
//CREATE QUERY TO SELECT RECORD
$dbQuery = "SELECT * ";
$dbQuery .= "FROM jos_user_tos ";
$dbQuery .= "WHERE userid=$user->id ";
//RUN QUERY
$results = $conDB->query($dbQuery);
//SEE HOW MANY ROWS WERE FOUND
if ($results->num_rows > 0 ) {
//GET DETAILS OF RECORD
while($rows = $results->fetch_assoc()) {
//ASSIGN FIELD TO VARIABLE TO CHECK IF USER HAS AGREED TO TOS
$tosagree = $rows["agreetos"];
//CHECK IF USER HAS AGREED TO TOS
if ($tosagree==0) {
//IF USER NEEDS TO AGREE, PROVIDE FORM TO FILL OUT
echo "Terms and Conditions
";
echo "Grant County Press has recently update the terms and conditions. You must agree to these terms and conditions in order use the site. If you do not agree, your access to material will be limited. To read the complete terms and conditions you may click here.";
}
//USE HAS AGREED MOVE ON
else{
//SEND USER TO SPLASH PAGE
//echo "user is good";
header("Location: https://www.grantcountypress.com/index.php/splash-page");
}
}
}
//IF USER IS NOT FOUND IN DATABASE
else {
//ADD RECORD TO DB FOR USERID
$dbQuery = "INSERT INTO jos_user_tos (userid,userip,userdttme) ";
$dbQuery .= "VALUES ($user->id,'$machIP','$dtme') ";
//RUN QUERY TO ADD RECORD
if ($conDB->query($dbQuery) === TRUE) {
//RECORD HAS ADDED SUCCESSFULLY SHOW FORM TO AGREE TO TOS
//echo "New record created successfully";
}
//RECORD NOT ADDED TO DB
else {
//SHOW ERROR
echo "Error: " . $dbQuery . "
" . $conDB->error;
}
}
//CLOSE CONNECTION TO DB
$conDB->close();
};;
return get_defined_vars();
;}