<?php

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

include 'connection.php';
$base_url = "https://translator.translateme.market/";

if (isset($_GET['code']) && !empty(trim($_GET['code']))) {
    $link = trim($_GET['code']);
    $arr = explode('_', $link);

    if (sizeof($arr) == 2) {
        $code = $arr[0];
        $loginid = $arr[sizeof($arr) - 1];

        /* -------- User account activation ------------ */
        $sql = 'SELECT `verify_link_code` FROM `tbl_translators` WHERE verify_link_code = "' . addslashes($link) . '" and id = "' . $loginid . '"';
        $result = $mysqli->query($sql);
        if ($result->num_rows > 0) {

            $sql1 = 'UPDATE `tbl_translators` SET `is_verified`= 1 WHERE `verify_link_code` = "' . addslashes($link) . '" and id = "' . $loginid . '"';
            $result1 = $mysqli->query($sql1);

            if (isset($_SESSION['tm_id'])) {
                $_SESSION['tm_is_verified'] = 1;
                header('Location: ' . $base_url . '/index.php?activated=1');
            } else {
                header('Location: ' . $base_url . '/login.php?activated=1');
            }
            exit;
        }
        /* --------------------------------------------- */
    }
}
if (isset($_SESSION['tm_id'])) {
    header('Location: ' . $base_url . '/index.php?invalid=1');
} else {
    header('Location: ' . $base_url . '/login.php?invalid=1');
}