[Karolukas123]

Hey, i try make friend system, and i get name, status he is on or off, but number i always get 0.. mysql save normal number.. like nick Samp_Player 123456789, but in server it say Samp_Player 0

Код:

}
CMD:friends(playerid, params[])
{
    new query[254],
	i[254],
	name[512], nr[512],string2[512];
	format(query,sizeof(query),"SELECT * FROM `drgbaze` WHERE `VardasD` = '%s'",GetPlayerNameEx(playerid));
	mysql_query(query);
	mysql_store_result();

	if(mysql_num_rows() != 0)
	{

		while(mysql_fetch_row_format(query, "|"))
		{
			FriendsData[playerid][TotalFriends] ++;
		 	mysql_fetch_field_row(i,"Fvardas"); format(name,sizeof(name),i);
		 	mysql_fetch_field_row(i,"numeris"); format(nr,sizeof(nr),i);
		 	if(IsPlayerOnline(name))
		 	{
	        	format(name,sizeof(name),"%s %d- on\n", name, nr);
	        	strcat(string2,name);
			}
			else
			{
			    format(name,sizeof(name),"%s %d- off\n", name, nr);
			    strcat(string2,name);
			}
            ShowPlayerDialog(playerid, 9999, DIALOG_STYLE_MSGBOX, "lentuke", string2, "uzdaryt", "");
		}
	}
	else
	{
		ShowPlayerDialog(playerid, 9999, DIALOG_STYLE_MSGBOX, "lentuke","Neturi draugu blede", "uzdarau", "");
	}
	return 1;

mysql foto:



game:

[Karolukas123]

Rewrite little bit system.. but still number not showing normal

[Karolukas123]

maybe help ? :d

[CodeStyle175]

Pls write querys in english, then i can help you.

[CodeStyle175]

PHP код:

CMD:friends(playerid)
{
    new str[70],bigstr[300],name[24],nr;
    format(str,sizeof(str),"SELECT * FROM `drgbaze` WHERE `VardasD` = '%s'",GetPlayerNameEx(playerid));
    mysql_query(str);
    mysql_store_result();
    if(mysql_num_rows()){
        while(mysql_fetch_row_format(str,"|")){
            sscanf(str,"p<|>s[24]d",name,nr);
            if(IsPlayerOnline(name))format(str,sizeof(str),"%s %d- on\n", name, nr);
            else format(str,sizeof(str),"%s %d- off\n", name, nr);
            strcat(bigstr,str);            
        }
        ShowPlayerDialog(playerid, 9999, DIALOG_STYLE_MSGBOX, "lentuke", bigstr, "uzdaryt", "");
    }else{
        ShowPlayerDialog(playerid, 9999, DIALOG_STYLE_MSGBOX, "lentuke","Neturi draugu blede", "uzdarau", "");
    }
    mysql_free_result();
    return 1;
} 


[Karolukas123]

Quote:

Originally Posted by CodeStyle175 PHP код: CMD:friends(playerid) {     new str[70],bigstr[300],name[24],nr;     format(str,sizeof(str),"SELECT * FROM `drgbaze` WHERE `VardasD` = '%s'",GetPlayerNameEx(playerid));     mysql_query(str);     mysql_store_result();     if(mysql_num_rows()){         while(mysql_fetch_row_format(str,"|")){             sscanf(str,"p<|>s[24]d",name,nr);             if(IsPlayerOnline(name))format(str,sizeof(str),"%s %d- on\n", name, nr);             else format(str,sizeof(str),"%s %d- off\n", name, nr);             strcat(bigstr,str);                     }         ShowPlayerDialog(playerid, 9999, DIALOG_STYLE_MSGBOX, "lentuke", bigstr, "uzdaryt", "");     }else{         ShowPlayerDialog(playerid, 9999, DIALOG_STYLE_MSGBOX, "lentuke","Neturi draugu blede", "uzdarau", "");     }     mysql_free_result();     return 1; }

No its not working.

[Mencent]

PHP код:

CMD:friends(playerid,params[])
{
    new query[254],name[MAX_PLAYER_NAME],nr[128],string2[512];
    format(query,sizeof(query),"SELECT * FROM `drgbaze` WHERE `VardasD`='%s'",GetPlayerNameEx(playerid));
    mysql_query(query);
    mysql_store_result();
    if(mysql_num_rows() != 0)
    {
        while(mysql_fetch_row_format(query,"|"))
        {
            FriendsData[playerid][TotalFriends] ++;
            mysql_fetch_field_row(name,"Fvardas");
            mysql_fetch_field_row(nr,"numeris");
            if(IsPlayerOnline(name))
            {
                format(name,sizeof(name),"%s %s- on\n",name,nr);
                strcat(string2,name);
            }
            else
            {
                format(name,sizeof(name),"%s %s- off\n",name,nr);
                strcat(string2,name);
            }
        }
        ShowPlayerDialog(playerid, 9999, DIALOG_STYLE_MSGBOX, "lentuke", string2, "uzdaryt", "");
    }
    else
    {
        ShowPlayerDialog(playerid, 9999, DIALOG_STYLE_MSGBOX, "lentuke","Neturi draugu blede", "uzdarau", "");
    }
    return 1;
} 


You have to use %s instead of %i / %d because nr (number) is a string.

[CodeStyle175]

Mencent are you stupid ors, number is never a string.

[Mencent]

PHP код:

mysql_fetch_field_row(nr,"numeris"); 


PHP код:

format(name,sizeof(name),"%s %s- on\n",name,nr); 


Where is your problem? "nr" is a string...