<?php
include "../classes/db.class.php";
session_start();

$db = new db();
$username = strtoupper($_GET['username']);

$results = $db->exec_query('users', ['*'], '', '', '', '', "username = '$username' AND password='{$_GET['password']}'");
if ($results->num_rows > 0) {
    $data = $results->fetch_assoc();
    $_SESSION['username'] = $data['username'];
    $_SESSION['user_type'] = $data['user_type'];
    $_SESSION['user_id'] = $data['record_id'];
    $_SESSION['admin'] = $data['admin'];
    $_SESSION['farm_id'] = $data['farm_id'];
    if ($data['change_password'] == 1) {
        echo 2;
    }else{
        echo 1;
    }
} else {
    echo "USERNAME OR PASSWORD INCORRECT";
}