public MySQLConnect()
{
    handle = mysql_connect(mysql_host, mysql_user, mysql_db, mysql_pass);
    if(mysql_errno() != 0)
    {
        printf("Conexiunea la baza de date %s a esuat ---> Server Inchis ~~~", mysql_db);
        SendRconCommand("exit");
    }
    else
    {
        printf("Conexiunea la baza de date '%s' cu user-ul '%s' a reusit!!!", mysql_db, mysql_user);
    }
    return 1;
}

public OnGameModeInit()
{
	 MySQLConnect();
   	 LoadTextdraws();
	return 1;
}

public OnGameModeExit()
{
    mysql_close(handle);
    KillTimer(tutorialtimer);
	return 1;
}

public OnPlayerConnect(playerid)
{
    PlayAudioStreamForPlayer(playerid, "https://www.youtube.com/watch?v=GDV1SBkTXbI");

	new newtext[41], name[MAX_PLAYER_NAME];
 	GetPlayerName(playerid, name, MAX_PLAYER_NAME);
 	format(newtext, sizeof(newtext), " %s / SKYNET.RO", name);
 	TextDrawSetString(gzonetd[playerid], newtext);
 	TextDrawShowForPlayer(playerid, gzonetd[playerid]);

    new query[100];
	TutTime[playerid] = 0;
    mysql_format(handle, query, sizeof(query), "SELECT * FROM conturi WHERE Nume = '%s'", GetName(playerid));
    mysql_tquery(handle, query, "OnPlayerLogin", "i", playerid);

	return 1;
}

public OnPlayerLogin(playerid)
{
    new rows, fields;
    cache_get_data(rows, fields);
    InterpolateCameraPos(playerid, 1152.1400, -1670.4702, 57.6976, 203.3979, -1678.8987, 57.6976, 30000, CAMERA_MOVE);
	InterpolateCameraLookAt(playerid, 1152.1489, -1671.4734, 57.4624, 203.4068, -1679.9019, 57.4674, 30000, CAMERA_MOVE);
	if(rows)
    {
		SendClientMessage(playerid, COLOR_GENANNOUNCE, "SERVER: {FFFFFF}Welcome to Skynet RPG.");
		SendClientMessage(playerid, COLOR_GENANNOUNCE, "SERVER: {FFFFFF}You already have a registered account, please enter your password into the dialog box.");
		ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "SERVER: Login", "Welcome to the RPG Server!\n\nPlease enter password below:", "Login", "Cancel");    }
    else
    {

		SendClientMessage(playerid, COLOR_GENANNOUNCE, "SERVER: {FFFFFF}Welcome to Skynet RPG.");
		SendClientMessage(playerid, COLOR_GENANNOUNCE, "SERVER: {FFFFFF}You aren't registered yet. Please enter your desired password in the dialog box to register.");
        ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "SERVER: Register", "Welcome to the RPG Server.\nPlease enter your desired password below:", "Register", "Cancel");
    }
    return 1;
}

public OnLogin(playerid)
{
    new rows, fields,temporar[200];
    cache_get_data(rows, fields);
    if(rows)
    {
        PlayerInfo[playerid][pParola] = cache_get_field_content(0, "Parola",temporar);
        PlayerInfo[playerid][pID] = cache_get_field_content_int(0, "ID");
        SpawnPlayer(playerid);
    }
    else
    {
        ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "SERVER: Login", "Welcome to the Skynet RPG!\n\nPlease enter the corect password for login to server.", "Login", "Cancel");
    }
    return 1;
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
    new query[128], ip[25];

    switch(dialogid)
    {
        case DIALOG_REGISTER:
        {
            if(!response) return Kick(playerid);

            if(response)
            {
                if(!strlen(inputtext)) return ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "SERVER: Register", "Welcome to RPG Server\n\nEnter a new password below:", "Register", "Cancel"),
				InterpolateCameraPos(playerid, 1152.1400, -1670.4702, 57.6976, 203.3979, -1678.8987, 57.6976, 30000, CAMERA_MOVE),
				InterpolateCameraLookAt(playerid, 1152.1489, -1671.4734, 57.4624, 203.4068, -1679.9019, 57.4674, 30000, CAMERA_MOVE);


                GetPlayerIp(playerid, ip, sizeof(ip));
                mysql_format(handle, query, sizeof(query), "INSERT INTO players (Nume, Parola, IP) VALUES ('%s', '%e', '%s')", GetName(playerid), inputtext, ip);
                mysql_query(handle, query);

				TutTime[playerid] ++;
				format(gString, 5000, "%s - Tutorial\nTe-ai inregistrat cu succes. Acum urmareste tutorialul, iti va fi de ajutor pe parcurs!", GetName(playerid));
				ShowPlayerDialog(playerid, DIALOG_FINISH_REGISTER, DIALOG_STYLE_MSGBOX, "SERVER: Finish", gString, "Ok", "");
            }
            return 1;
        }
        case DIALOG_LOGIN:
        {
            if(!response) return Kick(playerid);

            if(response)
            {
                if(!strlen(inputtext)) return ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "SERVER: Login", "Welcome to the RPG Server!\n\nPlease enter the correct password for login to server", "Login", "Cancel");

                mysql_format(handle, query, sizeof(query), "SELECT * FROM conturi WHERE Parola = '%e' LIMIT 0,1", inputtext);
                mysql_tquery(handle, query, "OnLogin", "i", playerid);
            }
            return 1;
        }
        case DIALOG_FINISH_REGISTER:
        {
            if(!response) return format(gString, 5000, "%s - Tutorial\nTe-ai inregistrat cu succes. Acum urmareste tutorialul, iti va fi de ajutor pe parcurs!", GetName(playerid)),
						  ShowPlayerDialog(playerid, DIALOG_FINISH_REGISTER, DIALOG_STYLE_MSGBOX, "SERVER: Finish", gString, "Ok", "");
        }
    }
    return 1;
}