05.08.2015, 17:10
hey guys.
i am having some problems with login and register script.
I dont really know what is wrong with it.
When i connect to server and it shows the textdraws and all things but the dialogs wont appear and if i press spawn it wont do anything if u need pics or script add me on skype di.ti7 please help me out
Mysql - Register script
Mysql - logins
Dialogs.
please someone help me out with this.
i am having some problems with login and register script.
I dont really know what is wrong with it.
When i connect to server and it shows the textdraws and all things but the dialogs wont appear and if i press spawn it wont do anything if u need pics or script add me on skype di.ti7 please help me out
Mysql - Register script
PHP код:
MySQL_Register(playerid, passwordstring[])
{
if (PLAYERLIST_authed[playerid]) return SendClientMessage(playerid,COLOR_SYSTEM_GM,"Already authed.");
//==============================================================================
new query[ 150 ], pname[ 150 ];
GetPlayerName(playerid, pname, MAX_PLAYER_NAME);
format(query,sizeof(query),"INSERT INTO PlayerInfo (user, password) VALUES ('%s', ('%s'));",pname, passwordstring);
mysql_query(query);
format(iStr, sizeof(iStr), "3[ REGISTER ] %s[%d] has registered.", PlayerName(playerid), playerid);
iEcho(iStr);
printf("%s's account created.",PlayerName(playerid));
if(refunding == 1) // Refunding system
{
format(query, sizeof(query), "UPDATE PlayerInfo SET curmoney=250000, bank=250000, namechanges=1, playerlvl=5, rpoints=5 WHERE user='%s'", pname);
mysql_query(query);
}
format(query, sizeof(query), "UPDATE `PlayerInfo` SET `Skin`=299 WHERE `user`='%s'", pname);
mysql_query(query);
MySQL_Login(playerid);
TextDrawHideForPlayer(playerid, TextDraw__Top1);
TextDrawHideForPlayer(playerid, TextDraw__Bottom1);
format(iStr, sizeof(iStr), "%s you need to set your characters ethnicity! (%s)\n\nPlease select \"next \" to continue", RPName(playerid));
ShowPlayerDialog(playerid, 64, DIALOG_STYLE_MSGBOX, "Registration Ethnicity", iStr, "Next", "");
return 1;
}
Код HTML:
stock MySQL_LoginFailed(playerid) // Determins wether the player has the right password and the outcome of it..
{
new string[ 128 ];
format(string, sizeof(string), "7[ LOGIN ] %s[%d] has failed to log in.", PlayerName(playerid), playerid);
iEcho(string);
//===========================================
PlayerTemp[playerid][WrongPass]++;
ShowPlayerDialog(playerid, 2, DIALOG_STYLE_PASSWORD, "Sicilian Mafia | Account Login", "Please enter your password in order to login.\n\nIf you have lost it, please contact siclian-roleplay.com", "Login", " ");
if(PlayerTemp[playerid][WrongPass] >= 3)
{
format(string, sizeof(string), "[NOTICE] %s has been kicked for too many invalid password attempts.", PlayerName(playerid));
SendClientMessageToAdmins(string,COLOR_GREENYELLOW);
SendClientMessage(playerid, COLOR_HELPEROOC, "================= YOU HAVE BEEN KICKED =================");
SendClientMessage(playerid, COLOR_LIGHTGREY, " You have been kicked for entering an invalid password too many times.");
PlayerTemp[playerid][WrongPass] = 0;
Kick(playerid);
TextDrawHideForPlayer(playerid, TextDraw__Top1);
TextDrawHideForPlayer(playerid, TextDraw__Bottom1);
}
mysql_free_result();
return 1;
}
stock MySQL_Login(playerid)
{
/*================================================
MySQL Fetch for account
==================================================*/
new query[1024], pname[24], savingstring[1028];
GetPlayerName(playerid, pname, 24);
format(query, sizeof(query), "SELECT * FROM `PlayerInfo` WHERE `user` = '%s'", pname);
mysql_query(query);
mysql_store_result();
while(mysql_fetch_row_format(query, "|"))
{
mysql_fetch_field_row(savingstring, "bank"); PlayerInfo[playerid][bank] = strval(savingstring);
mysql_fetch_field_row(savingstring, "curmoney"); PlayerTemp[playerid][sm] = strval(savingstring);
SetPlayerMoney(playerid, strval(savingstring));
mysql_fetch_field_row(savingstring, "playerlvl"); PlayerInfo[playerid][playerlvl] = strval(savingstring);
SetPlayerScore(playerid, strval(savingstring));
mysql_fetch_field_row(savingstring, "rpoints"); PlayerInfo[playerid][rpoints] = strval(savingstring);
mysql_fetch_field_row(savingstring, "playertime"); PlayerInfo[playerid][playertime] = strval(savingstring);
mysql_fetch_field_row(savingstring, "jail"); PlayerInfo[playerid][jail] = strval(savingstring);
mysql_fetch_field_row(savingstring, "jailreason"); myStrcpy(PlayerInfo[playerid][jailreason], savingstring);
mysql_fetch_field_row(savingstring, "jailtime"); PlayerInfo[playerid][jailtime] = strval(savingstring);
mysql_fetch_field_row(savingstring, "banned"); PlayerInfo[playerid][banned] = strval(savingstring);
mysql_fetch_field_row(savingstring, "banreason"); myStrcpy(PlayerInfo[playerid][banreason], savingstring);
mysql_fetch_field_row(savingstring, "whobannedme"); myStrcpy(PlayerInfo[playerid][whobannedme], savingstring);
mysql_fetch_field_row(savingstring, "whenigotbanned"); myStrcpy(PlayerInfo[playerid][whenigotbanned], savingstring);
mysql_fetch_field_row(savingstring, "forumname"); myStrcpy(PlayerInfo[playerid][forumname], savingstring);
mysql_fetch_field_row(savingstring, "Skin"); PlayerInfo[playerid][Skin] = strval(savingstring);
mysql_fetch_field_row(savingstring, "ranklvl"); PlayerInfo[playerid][ranklvl] = strval(savingstring);
mysql_fetch_field_row(savingstring, "rentprice"); PlayerInfo[playerid][rentprice] = strval(savingstring);
mysql_fetch_field_row(savingstring, "driverlic"); PlayerInfo[playerid][driverlic] = strval(savingstring);
mysql_fetch_field_row(savingstring, "flylic"); PlayerInfo[playerid][flylic] = strval(savingstring);
mysql_fetch_field_row(savingstring, "namechanges"); PlayerInfo[playerid][namechanges] = strval(savingstring);
mysql_fetch_field_row(savingstring, "boatlic"); PlayerInfo[playerid][boatlic] = strval(savingstring);
mysql_fetch_field_row(savingstring, "weaplic"); PlayerInfo[playerid][weaplic] = strval(savingstring);
mysql_fetch_field_row(savingstring, "jobtime"); PlayerInfo[playerid][jobtime] = strval(savingstring);
mysql_fetch_field_row(savingstring, "jobskill"); PlayerInfo[playerid][jobskill] = strval(savingstring);
mysql_fetch_field_row(savingstring, "pbkills"); PlayerInfo[playerid][pbkills] = strval(savingstring);
mysql_fetch_field_row(savingstring, "pbdeaths"); PlayerInfo[playerid][pbdeaths] = strval(savingstring);
mysql_fetch_field_row(savingstring, "totalpayt"); PlayerInfo[playerid][totalpayt] = strval(savingstring);
mysql_fetch_field_row(savingstring, "housenum"); PlayerInfo[playerid][housenum] = strval(savingstring);
mysql_fetch_field_row(savingstring, "tracker"); PlayerInfo[playerid][tracker] = strval(savingstring);
mysql_fetch_field_row(savingstring, "loan"); PlayerInfo[playerid][loan] = strval(savingstring);
mysql_fetch_field_row(savingstring, "guns"); PlayerInfo[playerid][guns] = strval(savingstring);
mysql_fetch_field_row(savingstring, "sguns"); PlayerInfo[playerid][sguns] = strval(savingstring);
mysql_fetch_field_row(savingstring, "sdrugs"); PlayerInfo[playerid][sdrugs] = strval(savingstring);
mysql_fetch_field_row(savingstring, "power"); PlayerInfo[playerid][power] = strval(savingstring);
mysql_fetch_field_row(savingstring, "female"); PlayerInfo[playerid][female] = strval(savingstring);
mysql_fetch_field_row(savingstring, "ethnic"); PlayerInfo[playerid][ethnic] = strval(savingstring);
mysql_fetch_field_row(savingstring, "bail"); PlayerInfo[playerid][bail] = strval(savingstring);
mysql_fetch_field_row(savingstring, "premium"); PlayerInfo[playerid][premium] = strval(savingstring);
mysql_fetch_field_row(savingstring, "gotphone"); PlayerInfo[playerid][gotphone] = strval(savingstring);
mysql_fetch_field_row(savingstring, "phonenumber"); PlayerInfo[playerid][phonenumber] = strval(savingstring);
mysql_fetch_field_row(savingstring, "phonebook"); PlayerInfo[playerid][phonebook] = strval(savingstring);
mysql_fetch_field_row(savingstring, "laptop"); PlayerInfo[playerid][laptop] = strval(savingstring);
mysql_fetch_field_row(savingstring, "age"); PlayerInfo[playerid][age] = strval(savingstring);
mysql_fetch_field_row(savingstring, "premiumexpire"); PlayerInfo[playerid][premiumexpire] = strval(savingstring);
mysql_fetch_field_row(savingstring, "playerteam"); PlayerInfo[playerid][playerteam] = strval(savingstring);
mysql_fetch_field_row(savingstring, "radio"); PlayerInfo[playerid][radio] = strval(savingstring);
mysql_fetch_field_row(savingstring, "freq1"); PlayerInfo[playerid][freq1] = strval(savingstring);
mysql_fetch_field_row(savingstring, "freq2"); PlayerInfo[playerid][freq2] = strval(savingstring);
mysql_fetch_field_row(savingstring, "freq3"); PlayerInfo[playerid][freq3] = strval(savingstring);
mysql_fetch_field_row(savingstring, "tutorial"); PlayerInfo[playerid][tutorial] = strval(savingstring);
mysql_fetch_field_row(savingstring, "tbanned"); PlayerInfo[playerid][tbanned] = strval(savingstring);
mysql_fetch_field_row(savingstring, "city"); myStrcpy(PlayerInfo[playerid][city], savingstring);
mysql_fetch_field_row(savingstring, "PTeamName"); myStrcpy(PlayerInfo[playerid][PTeamName], savingstring);
mysql_fetch_field_row(savingstring, "job"); myStrcpy(PlayerInfo[playerid][job], savingstring);
mysql_fetch_field_row(savingstring, "totalruns"); PlayerInfo[playerid][totalruns] = strval(savingstring);
mysql_fetch_field_row(savingstring, "fpay"); PlayerInfo[playerid][fpay] = strval(savingstring);
mysql_fetch_field_row(savingstring, "warns"); PlayerInfo[playerid][warns] = strval(savingstring);
mysql_fetch_field_row(savingstring, "helper"); PlayerInfo[playerid][helper] = strval(savingstring);
mysql_fetch_field_row(savingstring, "curfreq"); PlayerInfo[playerid][curfreq] = strval(savingstring);
mysql_fetch_field_row(savingstring, "rankname"); myStrcpy(PlayerInfo[playerid][rankname], savingstring);
mysql_fetch_field_row(savingstring, "phonechanges"); PlayerInfo[playerid][phonechanges] = strval(savingstring);
mysql_fetch_field_row(savingstring, "iPod"); PlayerInfo[playerid][iPod] = strval(savingstring);
mysql_fetch_field_row(savingstring, "finvite"); PlayerInfo[playerid][finvite] = strval(savingstring);
mysql_fetch_field_row(savingstring, "fradio"); PlayerInfo[playerid][fradio] = strval(savingstring);
mysql_fetch_field_row(savingstring, "fstock"); PlayerInfo[playerid][fstock] = strval(savingstring);
mysql_fetch_field_row(savingstring, "fwarehouse"); PlayerInfo[playerid][fwarehouse] = strval(savingstring);
mysql_fetch_field_row(savingstring, "fbarrier"); PlayerInfo[playerid][fbarrier] = strval(savingstring);
mysql_fetch_field_row(savingstring, "fweplic"); PlayerInfo[playerid][fweplic] = strval(savingstring);
mysql_fetch_field_row(savingstring, "bslot"); PlayerInfo[playerid][bslot] = strval(savingstring);
mysql_fetch_field_row(savingstring, "hslot"); PlayerInfo[playerid][hslot] = strval(savingstring);
mysql_fetch_field_row(savingstring, "vslot"); PlayerInfo[playerid][vslot] = strval(savingstring);
mysql_fetch_field_row(savingstring, "togspawn"); PlayerTemp[playerid][togspawn] = strval(savingstring);
mysql_fetch_field_row(savingstring, "accent"); myStrcpy(PlayerInfo[playerid][accent], savingstring);
mysql_fetch_field_row(savingstring, "spawnX"); PlayerInfo[playerid][spawnX] = floatstr(savingstring);
mysql_fetch_field_row(savingstring, "spawnY"); PlayerInfo[playerid][spawnY] = floatstr(savingstring);
mysql_fetch_field_row(savingstring, "spawnZ"); PlayerInfo[playerid][spawnZ] = floatstr(savingstring);
mysql_fetch_field_row(savingstring, "spawnINT"); PlayerInfo[playerid][spawnINT] = strval(savingstring);
mysql_fetch_field_row(savingstring, "spawnVW"); PlayerInfo[playerid][spawnVW] = strval(savingstring);
//==============================================================================
mysql_fetch_field_row(savingstring, "hasdrugs");
sscanf(savingstring, "p<,>iiiiiiiii", PlayerInfo[playerid][hasdrugs][0], PlayerInfo[playerid][hasdrugs][1], PlayerInfo[playerid][hasdrugs][2], PlayerInfo[playerid][hasdrugs][3],
PlayerInfo[playerid][hasdrugs][4], PlayerInfo[playerid][hasdrugs][5], PlayerInfo[playerid][hasdrugs][6], PlayerInfo[playerid][hasdrugs][7], PlayerInfo[playerid][hasdrugs][8]);
//==============================================================================
PLAYERLIST_authed[playerid]=true;
JustLogged[playerid]=true;
}
mysql_free_result();
if(PlayerTemp[playerid][togspawn]) SpawnToga[playerid]=true;
DefaultSpawn(playerid);
TogglePlayerControllable(playerid,true);
return 1;
}
Код HTML:
if(dialogid == DIALOG_REGISTER) //Dialog Register
{
if(response)
{
if(!strlen(inputtext) || strlen(inputtext) > 20)
{
SendClientError(playerid, "You need to login, otherwise you can not spawn");
Kick(playerid);
}
else if(strlen(inputtext) > 0 && strlen(inputtext) < 20)
{
new escpass[20];
mysql_real_escape_string(inputtext, escpass);
MySQL_Register(playerid, escpass);
}
}
if(!response)
{
SendClientInfo(playerid, "You need to login before you can play here");
Kick(playerid);
}
}
if(dialogid == DIALOG_LOGIN) //Dialog login
{
if(!response) //If they click the cancel button
{
SendClientError(playerid, "You must login before you spawn!"); //Sends the client a error message
Kick(playerid);
}
if(response) //If the player clicked login
{
new query[200], 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 `user` = '%s' FROM `PlayerInfo` WHERE `user` = '%s' AND password = '%s'", pname, pname, escapepass);
mysql_query(query);
mysql_store_result();
new numrows = mysql_num_rows();
if(numrows == 1) MySQL_Login(playerid);
if(!numrows) MySQL_LoginFailed(playerid);
mysql_free_result();
return 1;
}
}
