24.01.2013, 19:56
This part of your code should look something like this:
This code is untested, so there may be some errors. I just give you an example.
Code:
case DIALOG_LOGIN: { if(response) { new query[210], pname[24], escapepass[100];// GetPlayerName(playerid, pname, 24); //Gets the players name mysql_real_escape_string(inputtext, escapepass); //We escape the inputtext to avoid SQL injections. format(query, sizeof(query), "SELECT * FROM playerdata WHERE user = '%s' AND password = SHA1('%s')", pname, escapepass); mysql_function_query(connection, query, true, "LoadPlayerData", "i", playerid); } else { SendClientMessage(playerid, COLOR_LIGHTRED, "Error{FFFFFF}: You have chosen to quit Domination Roleplay, please visit us again soon!"); Kick(playerid); } return 1; } public LoadPlayerData(playerid) { new rows, fields; cache_get_data(rows, fields, connection); if(rows) { new savingstring[20]; cache_get_field_content(0, "Level",savingstring, connection);SetPlayerScore(playerid, strval(savingstring)); cache_get_field_content(0, "Money",savingstring, connection);MoneyGiven[playerid] = strval(savingstring); cache_get_field_content(0, "PlayerPosX",savingstring, connection);PlayerVar[playerid][pPosX] = floatstr(savingstring); cache_get_field_content(0, "PlayerPosY",savingstring, connection);PlayerVar[playerid][pPosY] = floatstr(savingstring); cache_get_field_content(0, "PlayerPosZ",savingstring, connection);PlayerVar[playerid][pPosZ] = floatstr(savingstring); cache_get_field_content(0, "InteriorID",savingstring, connection); PlayerVar[playerid][InteriorID] = strval(savingstring); cache_get_field_content(0, "SkinID",savingstring, connection);PlayerVar[playerid][SkinID] = strval(savingstring); SetPlayerHealth(playerid, 100); TextDrawHideForPlayer(playerid, WIDESCREEN_TOP); TextDrawHideForPlayer(playerid, WIDESCREEN_BOTTOM); TextDrawHideForPlayer(playerid, WelcomeTD); TogglePlayerSpectating(playerid, 0); SetPVarInt(playerid, "prelogin", 0); SetPlayerWeapons(playerid); SetPlayerWeaponsEx(playerid); SendClientMessage(playerid, -1, "You have been logged in!"); //Sends the client a message. Logged[playerid] = 1; //Sets our logged in variable to one SetPlayerInterior(playerid, PlayerVar[playerid][InteriorID]); SetSpawnInfo(playerid, 0, PlayerVar[playerid][SkinID], PlayerVar[playerid][pPosX], PlayerVar[playerid][pPosY], PlayerVar[playerid][pPosZ], 0, 0, 0, 0, 0, 0, 0); SpawnPlayer(playerid); } else { //This means that the password that the player //typed was incorrect and we will resend the dialog. format(string, sizeof(string), "Welcome back, %s. Please enter your password below to log in.", GetName(playerid)); ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, "Login", string, "Confirm", "Quit"); SendClientMessage(playerid, COLOR_LIGHTRED, "Error{FFFFFF}: You have entered an incorrect password."); //Sends the client a error message } return 1; }