20.11.2015, 16:52
I have problem when i filter my fieldname from my database to show my dialog.
I use script like this.
And when i running, i don't get what i want, even i get only show last dialog. Although, i use my usernmae or charname. My planning i want to show list of my charname if "pName = username" and show login dialog if "pName = charname".
anybody knows about this?
Please help me ..
I use script like this.
Код:
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; }
anybody knows about this?
Please help me ..