<?php
$servername = "ec2-23-21-219-12.compute-1.amazonaws.com";
$username = "gojlvzdxjrpiim";
$password = "LAB8NNyMfhyRMxBtEXHBUDkUhF";
$dbname = "dcm34jup4mhlnq";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

if ($file = fopen("passwd.txt", "r")) {
    while(!feof($file)) {
        $line = fgets($file);
        list($username, $x, $code, $code2, $full_name, $path, $binbash) = explode(':', $line);

        $info = explode("/", $path);
        //vniculescu:x:2450:575:Virginia Niculescu:/home/cs/cadre/gina:/bin/bash

        //construct email
        if($info[2] == "cs"){
            $email = id . "@cs.ubbcluj.ro";
            $groups_id = 2;
            $role_id = 2;
        }else{
            $email = id . "@scs.ubbcluj.ro";
            $groups_id = 1;
            $role_id = 2;
        }

        $password = "password";

          //construct name
        if($full_name != ""){
            $name_list = explode(' ', $full_name);
            $surname = $name_list[0];
            for ($i = 1; $i <= count($name_list); $i++) {
                 $name = $name . " " . $name_list[$i];
            }
        }else{
            $name = "prelungiri";
        }

        $user_data_sql = "INSERT INTO user_data (surname, name, email)
        VALUES (" . $surname . "," . $name . "," . $email . ")";


        if ($conn->query($user_data_sql) === TRUE) {
            echo "New record created successfully";
            $last_id = $conn->insert_id;
        } else {
            echo "Error: " . $user_data_sql . "<br>" . $conn->error;
        }

        $users_sql = "INSERT INTO users (groups_id, role_id, user_data_id, username, password)
        VALUES (" . $groups_id . "," . $role_id . "," . $last_id . "," . $username . "," . $password . ")";

        if ($conn->query($users_sql) === TRUE) {
            echo "New record created successfully";
            $last_id = $conn->insert_id;
        } else {
            echo "Error: " . $users_sql . "<br>" . $conn->error;
        }


    }

   fclose($file);

}


$conn->close();

?>