forward ShowDialog(playerid); public ShowDialog(playerid) { new query[300]; GetPlayerName(playerid, pName[playerid], MAX_PLAYER_NAME); mysql_format(mysql, query, sizeof(query), "SELECT * FROM `playerchar` WHERE `charname` = '%e' || `username` = '%e' LIMIT 1", pName[playerid], pName[playerid]); mysql_tquery(mysql, query, "Dialog", "d", playerid); return 1; } forward Dialog(playerid); public Dialog(playerid) { new rows = cache_num_rows(); if(!rows) { ShowPlayerDialog(playerid, 15000, DIALOG_STYLE_MSGBOX, "OPS...!","Kamu {FF0000}BELUM TERDAFTAR","Quit",""); } if(rows == 1) { foreach(Player, i) { cache_get_field_content(0, "charname", PlayerInfo[playerid][cName], mysql, 24); cache_get_field_content(0, "username", PlayerInfo[playerid][uName], mysql, 12); if(strcmp(pName[playerid],"PlayerInfo[playerid][cName]",true) == 0) { ShowPlayerDialog(playerid, 15500, DIALOG_STYLE_PASSWORD, "Login","Your user is {FF0000}registered{FFFFFF}! Please {0000FF}login{FFFFFF} with your password below!","Login","Cancel"); } else if(strcmp(pName[playerid],"PlayerInfo[playerid][uName]",true) == 0) { ShowPlayerDialog(playerid, 15555, DIALOG_STYLE_MSGBOX, "OPS...!","OKE","Quit",""); } return 1; } return 1; }
You should use format for that. Anyways, i made a tutorial for that. Click here.
|