05.05.2013, 14:34
So i made a login-register system ,
@ OnPlayerConnect
The LoadAcc
As you can see i placed SpawnPlayer more than once , but it doesn't work ,i still have to press "spawn" myself .
@ OnPlayerConnect
pawn Код:
public OnPlayerConnect(playerid)
{
gettime(clockhour, clockminute);
SetPlayerTime(playerid,clockhour,clockminute);
ResetPVar(playerid);
new plname[MAX_PLAYER_NAME];
GetPlayerName(playerid, plname, sizeof(plname));
PlayerInfo[playerid][SQLID] = CheckAccount(plname);
SetPlayerColor(playerid,culoare);
TextDrawShowForPlayer(playerid, Textdraw1);
if(PlayerInfo[playerid][SQLID]==0)
{
ShowPlayerDialog(playerid,1,DIALOG_STYLE_INPUT,"Registred User","Choose your password","Register","Cancel");
return 0;
}
else
{
ShowPlayerDialog(playerid,2,DIALOG_STYLE_INPUT,"This Name Is Taken","Enter Password","Login","Cancel");
return 1;
}
}
pawn Код:
public LoadAccount(playerid,pass[])
{
new query[128];
new value[32];
new wholeacc[1024];
new string[72];
Encrypt(pass);
format(query, sizeof(query), "SELECT `Password` FROM `players` WHERE `id` = %d LIMIT 1", PlayerInfo[playerid][SQLID]);
mysql_query(query);
mysql_store_result();
mysql_fetch_row(value);
PlayerInfo[playerid][pKey] = value;
if(strcmp(PlayerInfo[playerid][pKey],pass, true ) == 0 )
{
format(query, sizeof(query), "SELECT * FROM `players` WHERE `id` = '%d' LIMIT 1", PlayerInfo[playerid][SQLID]);
mysql_query(query);
mysql_store_result();
mysql_fetch_row(wholeacc);
mysql_fetch_field("Banned", value);
PlayerInfo[playerid][Banned] = strval(value);
if(PlayerInfo[playerid][Banned] != 0)
{
SendClientMessage(playerid,culoare,"You Are Banned On This Server");
Kick(playerid);
return 1;
}
else
{
mysql_fetch_field("AdminLevel", value);
PlayerInfo[playerid][AdminLevel] = strval(value);
mysql_fetch_field("Money", value);
PlayerInfo[playerid][Money] = strval(value);
mysql_fetch_field("Deaths", value);
PlayerInfo[playerid][Deaths] = strval(value);
mysql_fetch_field("Kills", value);
PlayerInfo[playerid][Kills] = strval(value);
mysql_fetch_field("BankMoney", value);
PlayerInfo[playerid][BankMoney] = strval(value);
mysql_fetch_field("Leader", value);
PlayerInfo[playerid][Leader] = strval(value);
mysql_fetch_field("Faction", value);
PlayerInfo[playerid][Faction] = strval(value);
mysql_fetch_field("Spawn", value);
PlayerInfo[playerid][Spawn] = strval(value);
mysql_fetch_field("Level", value);
PlayerInfo[playerid][Level] = strval(value);
mysql_fetch_field("Xp", value);
PlayerInfo[playerid][Xp] = strval(value);
mysql_fetch_field("Rp", value);
PlayerInfo[playerid][Rp] = strval(value);
mysql_fetch_field("Job", value);
PlayerInfo[playerid][Job] = strval(value);
mysql_fetch_field("Wanted", value);
PlayerInfo[playerid][Wanted] = strval(value);
mysql_fetch_field("BizzOwned", value);
PlayerInfo[playerid][BizzOwned] = strval(value);
mysql_fetch_field("HouseOwned", value);
PlayerInfo[playerid][HouseOwned] = strval(value);
mysql_fetch_field("JackTime", value);
PlayerInfo[playerid][JackTime] = strval(value);
mysql_fetch_field("BustedTime", value);
PlayerInfo[playerid][BustedTime] = strval(value);
mysql_fetch_field("HelperLevel", value);
PlayerInfo[playerid][HelperLevel] = strval(value);
mysql_fetch_field("HeadValue", value);
PlayerInfo[playerid][HeadValue] = strval(value);
mysql_fetch_field("Rank", value);
PlayerInfo[playerid][Rank] = strval(value);
mysql_fetch_field("Warnings", value);
PlayerInfo[playerid][Warnings] = strval(value);
mysql_fetch_field("MuteTime", value);
PlayerInfo[playerid][MuteTime] = strval(value);
mysql_fetch_field("Beer", value);
PlayerInfo[playerid][Beer] = strval(value);
mysql_fetch_field("Wine", value);
PlayerInfo[playerid][Wine] = strval(value);
mysql_fetch_field("Ganja", value);
PlayerInfo[playerid][Ganja] = strval(value);
mysql_fetch_field("Soda", value);
PlayerInfo[playerid][Soda] = strval(value);
mysql_fetch_field("Hat", value);
PlayerInfo[playerid][Hat] = strval(value);
mysql_fetch_field("Helment", value);
PlayerInfo[playerid][Helment] = strval(value);
mysql_fetch_field("CarOwned", value);
PlayerInfo[playerid][CarOwned] = strval(value);
mysql_fetch_field("Carlic", value);
PlayerInfo[playerid][Carlic] = strval(value);
mysql_fetch_field("jskill", value);
PlayerInfo[playerid][jskill] = strval(value);
mysql_fetch_field("mskill", value);
PlayerInfo[playerid][mskill] = strval(value);
mysql_fetch_field("dskill", value);
PlayerInfo[playerid][dskill] = strval(value);
PlayerInfo[playerid][Loggedin] = 1;
SpawnPlayer(playerid);
mysql_free_result();
if(PlayerInfo[playerid][Leader] > 0)
{
format(string, sizeof(string), "Welcome,You are the leader of %s",FactionInfo[PlayerInfo[playerid][Leader]][Nume] );
SendClientMessage(playerid,culoare,string);
SetPlayerSkin(playerid,FactionInfo[PlayerInfo[playerid][Leader]][Skin]);
}
if(PlayerInfo[playerid][Faction] > 0)
{
format(string, sizeof(string), "Welcome,You are a member of %s",FactionInfo[PlayerInfo[playerid][Faction]][Nume] );
SendClientMessage(playerid,culoare,string);
SetPlayerSkin(playerid,FactionInfo[PlayerInfo[playerid][Leader]][Skin]);
}
if(PlayerInfo[playerid][AdminLevel]>0)
{
format(string, sizeof(string), "You are logged in has an level %d admin",PlayerInfo[playerid][AdminLevel] );
SendClientMessage(playerid,culoare,string);
}
SetPlayerWantedLevel(playerid,PlayerInfo[playerid][Wanted]);
SetPlayerScore(playerid,PlayerInfo[playerid][Level]);
GivePlayerMoney(playerid,PlayerInfo[playerid][Money]);
SpawnPlayer(playerid);
SpawnPlayer(playerid);
SpawnPlayer(playerid);
SpawnPlayer(playerid);
return 1;
}
}
else
{
ShowPlayerDialog(playerid,2,DIALOG_STYLE_INPUT,"E R R O R","Wrong Password","Login","Dissconect");
return 0;
}
}