SA-MP Forums Archive
mysql number getting - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql number getting (/showthread.php?tid=599982)


mysql number getting - Karolukas123 - 01.02.2016

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:


Re: mysql number getting - Karolukas123 - 01.02.2016

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

Re: mysql number getting - Karolukas123 - 02.02.2016

maybe help ? :d

Re: mysql number getting - CodeStyle175 - 02.02.2016

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

Re: mysql number getting - CodeStyle175 - 02.02.2016

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;
} 


Re: mysql number getting - Karolukas123 - 02.02.2016

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.

Re: mysql number getting - Mencent - 02.02.2016

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.

Re: mysql number getting - CodeStyle175 - 02.02.2016

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

Re: mysql number getting - Mencent - 02.02.2016

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