<?php

    require_once 'inc/DbConnector.php';
    require_once 'mssql/DbConnector.php';
    ini_set ("max_execution_time", '30000');
    ini_set("memory_limit", '-1');


    $db = new DbConnector();
    $MSdb = new MSSQL();

    $members = array();

    $qry = $db-> query('SELECT
                        CONCAT(UCASE(MID(ime,1,1)), MID(ime, 2)) as Firstname,
                        CONCAT(UCASE(MID(priimek, 1,1)), MID(priimek, 2)) as Lastname,
                        naslov as Address,
                        postna_stevilka as PostCode,
                        email,
                        FROM_UNIXTIME(birthday) as DateOfBirth,
                        FROM_UNIXTIME(datump) as Registered,
                        FROM_UNIXTIME(zadnjaPrijava) as LastVisit,
                        uporabniskoime as Username,
                        geslo as Pass,
                        REPLACE(gsm, "/", "") as gsm,
                        event, promotor, enabled, geslo_plaintext,facebook
                        FROM uporabniki');
    while($member = mysql_fetch_array($qry))
    {
        array_push($members, $member);
    }
    foreach($members as $member)
    {
        $check = $MSdb->fetchArr("SELECT * FROM Member WHERE gsm = '$member[gsm]'");

        if(!$check || (!$check && $check != null))
        {
            $facebook = $member['facebook'] == 'da' && $member['facebook'] != '' ? 1 : 0;

            $MSdb -> query("INSERT INTO Member (Firstname, Lastname, Address, Email, DateOfBirth, Registered, Unregistered, LastVisit, Username, Password,Gsm, Confirmed, Facebook, Active)
                        VALUES('$member[Firstname]', '$member[Lastname]', '$member[Address], $member[PostCode]', '$member[email]','$member[DateOfBirth]',
                        '$member[Registered]', '', '$member[LastVisit]', '$member[Username]', '$member[Pass]', '$member[gsm]', 1, $facebook, $member[enabled])");
            $memberID = $MSdb-> getScalar("SELECT id FROM Member WHERE Gsm = '$member[gsm]'");

            if($member['promotor'] && $member['event'])
            {
                $promotorID = $MSdb-> getScalar("SELECT id FROM Promotors WHERE Promotor = '$member[promotor]'");
                $eventID = $MSdb-> getScalar("SELECT id FROM Events WHERE Event = '$member[event]'");

                $MSdb-> query("INSERT INTO Promotions(MemberId, EventId, PromotorId) VALUES ('$memberID', '$eventID', '$promotorID')");

            }
        }
        elseif($check && ($member['geslo_plaintext'] != null && $member['geslo_plaintext']))
        {
            $facebook = $member['facebook'] == 'da' && $member['facebook'] != '' ? 1 : 0;
            $MSdb-> query("UPDATE Member SET Password = '$member[geslo_plaintext]', Active = '$member[enabled]', Facebook = $facebook");
        }

        unset($promotorID, $eventID, $memberID, $member);
        if(count($members)%500 == 0)
        {
            $MSdb = null;
            sleep(5);
            $MSdb = new MSSQL();
        }
    }
    /*$MSdb -> query("USE MygiggPortal");
    $membersOld = $MSdb -> fetchArr("SELECT fullname, '' as address, '' as email, dob, GETDATE() as registered, null as unregistered, '' as lastvisit, LOWER(REPLACE(fullname, ' ', '')) as                                     username, password, gsm, isactivated as confirmed, '' as hash, '' as facebook
                                FROM Users");*/
?>