• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[Pawn] mysql_query suggest
#1
How can I?improve this code?



PHP Code:
Account_PromptLogin(playerid) {

? ? new

? ? ? ? 
query[81],

? ? ? ? 
playerHash[62],

? ? ? ? 
playerDate[11],

? ? ? ? 
playerTime[9],

? ? ? ? 
playerIP[16],

? ? ? ? 
rows;



? ? 
mysql_format(MySQL_GetHandle(), querysizeof query

? ? 
"\

? ? ? ? SELECT * FROM `players` WHERE `username` = '%e' LIMIT 1\

? ? "


? ? ? ? 
Player_GetName(playerid)

? ? );

? ? 
mysql_query(MySQL_GetHandle(), query);



? ? 
cache_get_row_count(rows);



? ? if (!
rows) {

? ? ? ? 
Player_Kick(playerid);

? ? ? ? return 
0;

? ? }



? ? 
cache_get_value_name(0"password"playerHashsizeof(playerHash));

? ? 
cache_get_value_name(0"date_reg"playerDatesizeof(playerDate));

? ? 
cache_get_value_name(0"time_reg"playerTimesizeof(playerTime));

? ? 
cache_get_value_name(0"ip"playerIPsizeof(playerIP));



? ? 
Player_SetAccountHash(playeridplayerHash);

? ? 
Player_SetAccountDate(playeridplayerDate);

? ? 
Player_SetAccountTime(playeridplayerTime);

? ? 
Player_SetAccountIP(playeridplayerIP);



? ? 
Dialog_ShowCallback(playerid,

? ? ? ? 
using public Account_Login<iiiis>, 

? ? ? ? 
DIALOG_STYLE_PASSWORD

? ? ? ? 
SERVER_NAME

? ? ? ? 
"Welcome"

? ? ? ? 
"Login",

? ? ? ? 
"Exit"

? ? );

? ? return 
1;

}



forward Account_Login(playeriddialogidresponselistitemstring:inputtext[]);

public 
Account_Login(playeriddialogidresponselistitemstring:inputtext[]) {

? ? if (
response) {

? ? ? ? 
bcrypt_verify(playerid"OnPasswordVerify"inputtextPlayer_GetAccountHash(playerid));

? ? }

? ? else {

? ? ? ? 
Kick(playerid);

? ? }

? ? return 
1;





PHP Code:
forward OnPasswordVerify(playeridbool:success);

public 
OnPasswordVerify(playeridbool:success) {

? ? if (
success)

? ? {

? ? ? ? 
CallLocalFunction("OnPlayerLogin""d"playerid);

? ? }

? ? else

? ? {

? ? ? ? 
Account_PromptLogin(playerid);

? ? }


  Reply


Messages In This Thread
mysql_query suggest - by Zow - 2021-03-19, 09:49 PM
RE: mysql_query suggest - by Y_Less - 2021-03-21, 12:12 PM
RE: mysql_query suggest - by Zow - 2021-03-22, 05:08 PM
RE: mysql_query suggest - by Virsenas - 2021-03-22, 07:25 PM
RE: mysql_query suggest - by Zow - 2021-03-22, 08:49 PM

Forum Jump: