N1dp

#include <a_samp>
#include <a_mysql>

#define DIALOG_REGISTER 1
#define DIALOG_LOGIN 2

enum playerinfo {
        ORM:ORM_ID,
        SQL_ID,
        Name[MAX_PLAYER_NAME],
        Password[129],
        Money,
        Xp,
        AdminLvl,
        Float:SpawnX,
        Float:SpawnY,
        Float:SpawnZ
};

new pInfo[MAX_PLAYERS][playerinfo];


new DbHandle;

main ()
{
}


public OnGameModeInit()
{
	mysql_log();
	DbHandle = mysql_connect("localhost","root","serveris","");
	SetGameModeText("GM 0.1");
	AddPlayerClass(0,0,0,3,0,0,0,0,0,0,0);
	return 1;
}

public OnGameModeExit()
{
	return 1;
}

public OnPlayerRequestClass(playerid, classid)
{
	SetPlayerPos(playerid, 1958.3783, 1343.1572, 15.3746);
	SetPlayerCameraPos(playerid, 1958.3783, 1343.1572, 15.3746);
	SetPlayerCameraLookAt(playerid, 1958.3783, 1343.1572, 15.3746);
	return 1;
}

public OnPlayerConnect(playerid)
{
        GetPlayerName(playerid,pInfo[playerid][Name],24); // Gauname þaidëjo vardà, nestebuklas.
        pInfo[playerid][ORM_ID] = orm_create("zaidejai",DbHandle); // Sukuriame ryðá su lentele "zaidejai"
        orm_addvar_int(pInfo[playerid][ORM_ID],pInfo[playerid][SQL_ID],"SQL_ID"); //Pridedame integer tipo kintamajá "SQL_ID" prie duombazës lentelës stulpelio pavadinimu "SQL_ID"
        orm_addvar_string(pInfo[playerid][ORM_ID],pInfo[playerid][Name],24,"Name");// Pridedame string tipo "Name" prie duomenø bazës stulpelio "Name"
        orm_addvar_string(pInfo[playerid][ORM_ID],pInfo[playerid][Password],129,"Password");
        orm_addvar_int(pInfo[playerid][ORM_ID],pInfo[playerid][Money],"Money");
        orm_addvar_int(pInfo[playerid][ORM_ID],pInfo[playerid][Xp],"Xp");
        orm_addvar_int(pInfo[playerid][ORM_ID],pInfo[playerid][AdminLvl],"AdminLvl");
        orm_addvar_float(pInfo[playerid][ORM_ID],pInfo[playerid][SpawnX],"SpawnX"); //Pridedame float tipo kintamàjá prie duomenø bazës stulpelio "SpawnX"
        orm_addvar_float(pInfo[playerid][ORM_ID],pInfo[playerid][SpawnY],"SpawnY");
        orm_addvar_float(pInfo[playerid][ORM_ID],pInfo[playerid][SpawnZ],"SpawnZ");

        // Dabar jau galëtume siøsti áprastas uþklausas á duomenø bazæ...Bet jie dar neþinos á kieno eilutæ áraðinëti duomenis

        orm_setkey(pInfo[playerid][ORM_ID],"Name"); //Nurodome kad áaðinëtø ten kur vardas bus lygus kintamajam "pInfo[playerid][Name]"
        orm_select(pInfo[playerid][ORM_ID],"OnPlayerCheck","d",playerid); // Iðsiunèiame uþklausà á duomenø bazæ kuri parinks visus duomenis ir iðkvies "OnPlayerCheck" funckijà su rezultatu
        return 1;
}

public OnPlayerDisconnect(playerid,reason)
{
        if(pInfo[playerid][SQL_ID] != 0) orm_update(pInfo[playerid][ORM_ID]); // Jeigu þaidëjo informacija buvo uþkrauta, iðsaugom visus duomenis.
        orm_destroy(pInfo[playerid][ORM_ID]); // Paðalinam ryðt su lentele tam þaidëjui.
        return 1;
}

public OnPlayerSpawn(playerid)
{
	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(cmdtext,"/test"))
        {
                printf("SQLID:%d",pInfo[playerid][SQL_ID]);
                printf("Name:%s",pInfo[playerid][Name]);
                printf("Password:%s",pInfo[playerid][Password]);
                printf("Money:%d",pInfo[playerid][Money]);
                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[])
{
        if(dialogid == DIALOG_REGISTER) // Jeigu tai regsitracijos lentelë
        {
                if(!response) return Kick(playerid); // Jeigu paspaudë "Iðeiti", iðmetame já lauk.
                if(strlen(inputtext) < 6)  // Jeigu ávesto slaptaþodis trumpesnis uþ 6.
                {
                        SendClientMessage(playerid,-1,"Slaptaþodá turi sudaryti bent 6 simboliai");
                        ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_PASSWORD,"Registracija","Ávesktie savo slaptaþodá þemiau","Registruotis","Iðeiti");
                        return 1;
                }
                strins(pInfo[playerid][Password],inputtext,0); // Áraðom á kintamajá "pInfo[playerid][Password]" þaidëjo slaptaþodá.
                orm_insert(pInfo[playerid][ORM_ID],"OnPlayerRegister","d",playerid); // Áraðome á lentelæ naujà eilutæ skirta þaidëjui.
                return 1;
        }
        else if(dialogid == DIALOG_LOGIN) // Jeigu tai prisijungimo lentelë.
        {
                if(!response) return Kick(playerid); // Jeigu þaidëjas paspaudë "Iðeiti" - iðmetam.
                if(strlen(inputtext) < 6)
                {
                        SendClientMessage(playerid,-1,"Slaptaþodá turi sudaryti bent 6 simboliai");
                        ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Prisijungimas","Áveskite savo slaptaþodá þemiau","Prisijungti","Iðeiti");
                        return 1;
                }
                if(!strcmp(pInfo[playerid][Password],inputtext)) //Jeigu ávestas slaptaþodis yra lygus áraðytam duomenø bazëje(jau uþkrautas jis buvo, prisijungiant)
                {
                        SendClientMessage(playerid,-1,"Sëkmingai prisijungëte, gero þaidimo!");
                        return 1;
                }
                else SendClientMessage(playerid,-1,"Slaptaþodis neteisingas");
        }
        return 0;
}
forward OnPlayerRegister(playerid);
public OnPlayerRegister(playerid)
{
        if(orm_errno(pInfo[playerid][ORM_ID]) == ERROR_OK) // Jeigu nebuvo klaidø siunèiant uþklausà.
        {
                SendClientMessage(playerid,-1,"Registracija sëkminga! Gero þaidimo");
        }
        return 1;
}

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


forward OnPlayerCheck(playerid);
public OnPlayerCheck(playerid)
{
        switch(orm_errno(pInfo[playerid][ORM_ID]))
        {
                //Jeigu nebuvo jokiø klaidø siunèiant uþklausà.
                case ERROR_OK: ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Prisijungimas","Áveskite savo slaptaþodá þemiau","Prisijungti","Iðeiti");
                //Jeigu gauta "nëra duomenø" klaida. Reiðkia þaidëjo nëra duomenø bazëje.
                case ERROR_NO_DATA: ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_PASSWORD,"Registracija","Ávesktie savo slaptaþodá þemiau","Registruotis","Iðeiti");
        }
        // Nurodome kad eilutes nuo dabar skirsime pagal "SQL_ID".
        orm_setkey(pInfo[playerid][ORM_ID],"SQL_ID");
        return 1;
}