[Opeal]

I have problem when i filter my fieldname from my database to show my dialog.
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;
}

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 ..

[Opeal]

Quote:

Originally Posted by Karan007 You should use format for that. Anyways, i made a tutorial for that. Click here.

Thank's for you response.
But i don't filter username and charname from my "GetPlayerName".
Can you filter it?

[Opeal]

please help ......

[Opeal]

BUMP..
Please Help ...