Beiträge von ChrisX

stock getAccountData(playerid)
{
	new EscapedName[MAX_PLAYER_NAME];
	if(GetPVarInt(playerid, "Authentication") == 1)
	{
    	mysql_real_escape_string(GetName(playerid), EscapedName);
		format(Query, sizeof(Query), "SELECT * FROM `user_info` WHERE `username` = '%s'", EscapedName);
		mysql_query(Query);
		mysql_store_result();


		mysql_fetch_row_format(Query, "|");
		print(Query);
		sscanf(Query, "e<p<|>ds[45]dds[34]ffffffds[16]ddd>",pUserData[playerid]);
	}
	else print("[MySQL ERROR] getAccountData() was called, but to a non-connected ID.");
	mysql_free_result();
}

enum PlayerData
{
pUserID,
pName[MAX_PLAYER_NAME],
pSkin,
pMoney,
pPass[34],
Float: pPosX,
Float: pPosY,
Float: pPosZ,
Float: pPosA,
Float: pHealth,
Float: pArmour,
pLevel,
pIP[16],
pPlaytime,
pSpeedo,
pLastLogin
};
new pUserData[MAX_PLAYERS][PlayerData];

new EscapedName[MAX_PLAYER_NAME];
    mysql_real_escape_string(GetName(playerid), EscapedName);
format(Query, sizeof(Query), "SELECT * FROM `user_info` WHERE `username` = '%s'", EscapedName);
mysql_query(Query);
mysql_store_result();


// Die Daten werden zwar mit print() in der Konsole ausgegeben, kommen aber nicht im Enum an
mysql_fetch_row_format(Query, "|");
print(Query);
sscanf(Query, "e<p<|>ds[45]dds[34]ffffddds[16]ddd>",pUserData[playerid]);

stock InitPlayerConnection(playerid)
{
    format(Query, sizeof(Query), "SELECT * FROM `user_info` WHERE `userName` = '%s'", GetName(playerid));
mysql_query(Query);
mysql_store_result();


if(mysql_num_rows() >= 1) // hat der user einen ingame Acc dann hier weiter, PW abfragen
{
mysql_free_result();


new plrIP[16];
GetPlayerIp(playerid, plrIP, sizeof(plrIP));


format(Query, sizeof(Query), "SELECT userIP FROM `user_info` WHERE `userName` = '%s' AND `userIP` = '%s'", GetName(playerid),plrIP);
mysql_query(Query);
mysql_store_result();


if(mysql_num_rows() != 0)// war der User schonmal hier mit dieser IP-Adresse
    {
SetPVarInt(playerid, "JustLogged", 1); // Wenn wir mit der IP schonmal da waren
        SendClientMessage(playerid, 0x009600AA, "Auto Logged in!");
    }
else// ansonsten das Passwort abfragen
{
format(Query, sizeof(Query), "SELECT userPass FROM `user_info` WHERE `userName` = '%s'", GetName(playerid));
mysql_query(Query);
mysql_store_result();


mysql_free_result();
ShowPlayerDialog(playerid, 1, DIALOG_STYLE_INPUT, "Login / Authentication Process", "Hallo Spieler.\n\nBitte gibt dein Password hier ein.", "Login", "Abbrechen");
SendClientMessage(playerid, COLOR_WHITE, "Your account exists. Please enter your password to proceed.");
}
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
switch(dialogid)
{
case 1: // registrierte User Login Dialog
{
    if(!response)
    {
        SendClientMessage(playerid, COLOR_BRIGHTRED, "Auf Wiedersehen!");
        Kick(playerid);
}
else if(strlen(inputtext) == 0) // wenn kein PW eingegeben wird, 0 = kein Zeichen
{
SendClientMessage(playerid, COLOR_ORANGE, "Du hast kein Password eingegeben. Bitte gib das richtige ein!");
   ShowPlayerDialog(playerid, 1, DIALOG_STYLE_INPUT, "Authentication", "Welcome!\n\nI need you to input the password for this account.", "Login", "Cancel");
}
    else
    {
        //new string[700];
        new pwstr[34];
        new teststr1[800];
        new teststr2[800];


GetFromAccount(GetName(playerid), "userPass", pwstr);
new str[34];
str = MD5_Hash(inputtext);


if(!strcmp(str,pwstr, true))
{
       SetPVarInt(playerid, "Authentication", 1);
       SetPVarInt(playerid, "JustLogged", 1);


getAccountData(playerid);


                format(teststr1, sizeof(teststr1), "userID: %s; Name: %s; Skin: %s; Money: %s; Pass: %s;",
pUserData[playerid][pUserID],
pUserData[playerid][pName],
pUserData[playerid][pSkin],
pUserData[playerid][pMoney],
pUserData[playerid][pPass]);
                print(teststr1);


           format(teststr2, sizeof(teststr2), "PosX: %s;  PosY: %s; PosZ: %s; PosA: %s;",
pUserData[playerid][pPosX],
pUserData[playerid][pPosY],
pUserData[playerid][pPosZ],
pUserData[playerid][pPosA]);
print(teststr2);


SetPlayerColor(playerid, COLOR_WHITE);
//TogglePlayerSpectating(playerid, 0);


SetSpawnInfo(playerid, 0, pUserData[playerid][pSkin], pUserData[playerid][pPosX], pUserData[playerid][pPosY], pUserData[playerid][pPosZ], pUserData[playerid][pPosA], 0, 0, 0, 0, 0, 0);
SetPlayerScore(playerid, pUserData[playerid][pPlaytime]); //Sets players score
}
else
{
SendClientMessage(playerid, COLOR_WHITE, "test case 1 - Incorrect password. Please try again!");
ShowPlayerDialog(playerid, 1, DIALOG_STYLE_INPUT, "Authentication", "Welcome!\n\nI need you to input the password for this account.", "Login", "Cancel");
}
}
}
}

public OnPlayerSpawn(playerid)
{
if(GetPVarInt(playerid, "JustLogged") == 1)
{
GivePlayerMoney(playerid, pUserData[playerid][pMoney]);
SetPlayerScore(playerid, pUserData[playerid][pPlaytime]);
SetPlayerSkin(playerid, pUserData[playerid][pSkin]);
SetPlayerPos(playerid, pUserData[playerid][pPosX], pUserData[playerid][pPosY], pUserData[playerid][pPosZ]+3);
SetPlayerFacingAngle(playerid, pUserData[playerid][pPosA]);
DeletePVar(playerid, "JustLogged");
}