#include <a_samp>
#include <a_mysql>

/*
* Rejestracja MySQL
*
* Autor:     	 Krzyzan
* Credits:   	 Krzyzan
* Wersja:        0.1 Beta
* Rozpoczęcie:   12.01.12
*
* Copyright (C) Krzyzan
*
* Na samym dole notatki i potrzebne info!
*/


//                Dane Bazy Danych
#define SQL_HOST "localhost"
#define SQL_USER "root"
#define SQL_PASS ""
#define SQL_DBNM "pstruck"

enum Info
{
	login,
    pass,
	pieniadze,
	score
};
new PlayerInfo[MAX_PLAYERS][Info];

new query[128];

stock playerName(playerid)
{
    new n[24];
    GetPlayerName(playerid, n, 24);
    return n;
}

public OnFilterScriptInit()
{
	print("		Rejestracja MySQL Ładowanie");
	print("			0%----");
	print("			0%-------");
	print("			0%----------");
	print("			0%-------------");
	print("			0%----------------100%");
	print("		Rejestracja MySQL Załadowana");
	print("				POMYŚLNIE");


	print("		Rejestracja MySQL Łączenie");

//          Łączenie skryptu do bazy danych
    mysql_connect(SQL_HOST, SQL_USER, SQL_DBNM, SQL_PASS);
	print("		Rejestracja MySQL Połączono");

	print("		Rejestracja MySQL Zapisano");
	mysql_debug(1);
	return 1;
}

public OnFilterScriptExit()
{
	mysql_close();
	return 1;
}


public OnPlayerConnect(playerid)
{
    GetPlayerName(playerid, PlayerInfo[playerid][login], MAX_PLAYER_NAME);
    format(query, sizeof(query), "SELECT * FROM `gracze` WHERE `login` = '%s'", playerName(playerid));
    mysql_query(query);
    mysql_store_result();

    if(mysql_num_rows())
        ShowPlayerDialog(playerid, 1, DIALOG_STYLE_PASSWORD, "Logowanie.", "Aby zalogować się, wpisz hasło poniżej.", "Zaloguj", "Wyjdź");
    else
        ShowPlayerDialog(playerid, 2, DIALOG_STYLE_INPUT, "Rejestracja", "Witaj, nie posiadasz konta!\nZarejestruj się.\nPodaj swoje hasło:", "Rejestruj", "Anuluj");
	mysql_free_result();
//	SetPVarInt(playerid, "NieZalogowany", 1);

	return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
    format(query, 128, "UPDATE `gracze` SET `pieniadze`=%d, `score`=%d WHERE `login`='%s'", GetPlayerMoney(playerid), GetPlayerScore(playerid), playerName(playerid));
    mysql_query(query);
	return 1;
}

public OnPlayerSpawn(playerid)
{
    format(query, 128, "SELECT `pieniadze`, `score` FROM `gracze` WHERE `login` = '%s'", playerName(playerid));
    GivePlayerMoney(playerid, PlayerInfo[playerid][pieniadze]);
    SetPlayerScore(playerid, PlayerInfo[playerid][score]);
	return 1;
}

public OnPlayerDeath(playerid, killerid, reason)
{
	return 1;
}

public OnVehicleSpawn(vehicleid)
{
	return 1;
}

public OnVehicleDeath(vehicleid, killerid)
{
	return 1;
}

public OnPlayerText(playerid, text[])
{
	return 1;
}

public OnPlayerCommandText(playerid, cmdtext[])
{
	if (strcmp("/mycommand", cmdtext, true, 10) == 0)
	{
		// Do something here
		return 1;
	}
	return 0;
}

public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
{
	return 1;
}

public OnPlayerExitVehicle(playerid, vehicleid)
{
	return 1;
}

public OnPlayerStateChange(playerid, newstate, oldstate)
{
	return 1;
}

public OnPlayerEnterCheckpoint(playerid)
{
	return 1;
}

public OnPlayerLeaveCheckpoint(playerid)
{
	return 1;
}

public OnPlayerEnterRaceCheckpoint(playerid)
{
	return 1;
}

public OnPlayerLeaveRaceCheckpoint(playerid)
{
	return 1;
}

public OnRconCommand(cmd[])
{
	return 1;
}

public OnPlayerRequestSpawn(playerid)
{
	return 1;
}

public OnObjectMoved(objectid)
{
	return 1;
}

public OnPlayerObjectMoved(playerid, objectid)
{
	return 1;
}

public OnPlayerPickUpPickup(playerid, pickupid)
{
	return 1;
}

public OnVehicleMod(playerid, vehicleid, componentid)
{
	return 1;
}

public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
{
	return 1;
}

public OnVehicleRespray(playerid, vehicleid, color1, color2)
{
	return 1;
}

public OnPlayerSelectedMenuRow(playerid, row)
{
	return 1;
}

public OnPlayerExitedMenu(playerid)
{
	return 1;
}

public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
{
	return 1;
}

public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
	return 1;
}

public OnRconLoginAttempt(ip[], password[], success)
{
	return 1;
}

public OnPlayerUpdate(playerid)
{
	return 1;
}

public OnPlayerStreamIn(playerid, forplayerid)
{
	return 1;
}

public OnPlayerStreamOut(playerid, forplayerid)
{
	return 1;
}

public OnVehicleStreamIn(vehicleid, forplayerid)
{
	return 1;
}

public OnVehicleStreamOut(vehicleid, forplayerid)
{
	return 1;
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
	return 1;
}

public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
	return 1;
}

/*          NOTATKI

TWORZENIE TABELI

CREATE TABLE `gracze` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`login` VARCHAR( 24 ) NOT NULL ,
`pass` VARCHAR( 24 ) NOT NULL ,
`pieniadze` INT NOT NULL DEFAULT '0',
`score` INT( 3 ) NOT NULL DEFAULT '0',
UNIQUE (`login`)
)

*/