Problem with Show String in /stats command

Problem with Show String in /stats command - 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: Problem with Show String in /stats command (/showthread.php?tid=594462)

Problem with Show String in /stats command - Opeal - 18.11.2015

I confuse about this.

I load my database like this.

Код:

stock LoadDataString(playerid)
{
    new query[300], pName[24], savingstring[10];
    GetPlayerName(playerid, pName, 24);
    format(query, sizeof(query), "SELECT * FROM `playerchar` WHERE `charname` = '%s'", pName);
    mysql_query(query);
    mysql_store_result();
    while(mysql_fetch_row_format(query,"|"))
    {
	     mysql_fetch_field_row(savingstring[1], "username"); strmid(PlayerInfo[playerid][uName], savingstring[1], 0, strlen(savingstring[1]), 255);
	     mysql_fetch_field_row(savingstring[2], "origin"); strmid(PlayerInfo[playerid][pOrigin], savingstring[2], 0, strlen(savingstring[2]), 255);
    }
    mysql_free_result();
}

and my command /stats like this.

Код:

CMD:stats(playerid, params[])
{
        if(IsPlayerConnected(playerid))
        {
	         new str[128];
                 format(str, sizeof(str), "Username: %s | Origin: %s", PlayerInfo[playerid][uName], PlayerInfo[playerid][pOrigin]);
	         SendClientMessage(playerid ,0xFFFFFFAA, str);
	         return 1;
        }
        return SendClientMessage(playerid, 0xAFAFAFAA, "Kamu harus login terlebih dahulu untuk menggunakan command ini.");
}

and this showed when i ingame.

why i found two times same word?

please help!

Re: Problem with Show String in /stats command - Opeal - 18.11.2015

Any one can help me? please..

Re: Problem with Show String in /stats command - Opeal - 18.11.2015

BUMP, please help...

Re: Problem with Show String in /stats command - Mencent - 18.11.2015

Hello!

Try this:

PHP код:



stock LoadDataString(playerid)

{

    new query[300],pName[24];

    GetPlayerName(playerid,pName,sizeof(pName));

    format(query,sizeof query,"SELECT * FROM `playercar` WHERE `charname`='%s'",pName);

    mysql_query(query);

    mysql_store_result();

    while(mysql_fetch_row_format(quey,"|"))

    {

        mysql_fetch_field_row(PlayerInfo[playerid][uName],"username");

        mysql_fetch_field_row(PlayerInfo[playerid][pOrigin],"origin");

    }

    mysql_free_result();

}

Your problem is that you forgot to declare the length of the string where you save this:

PHP код:



savingstring[10];

You can put the "username" and the "origin" directly in the arrays.

Re: Problem with Show String in /stats command - gurmani11 - 18.11.2015

Код HTML:

 while(mysql_fetch_row_format(query,"|"))
    {
	     mysql_fetch_field_row(savingstring[1], "username"); strmid(PlayerInfo[playerid][uName], savingstring[1], 0, strlen(savingstring[1]), 255);
	     mysql_fetch_field_row(savingstring[2], "origin"); strmid(PlayerInfo[playerid][pOrigin], savingstring[2],  strlen(savingstring[1]), strlen(savingstring[2]), 255);
    }

i think you forgot to limit your string start with

PHP код:



strmid(string, "Extract 'HELLO' without the !!!!: HELLO!!!!", 34, 39); //string contains "HELLO"

Re: Problem with Show String in /stats command - Opeal - 18.11.2015

Quote:

Originally Posted by Mencent

Hello!

Try this:

PHP код:



stock LoadDataString(playerid)

{

    new query[300],pName[24];

    GetPlayerName(playerid,pName,sizeof(pName));

    format(query,sizeof query,"SELECT * FROM `playercar` WHERE `charname`='%s'",pName);

    mysql_query(query);

    mysql_store_result();

    while(mysql_fetch_row_format(quey,"|"))

    {

        mysql_fetch_field_row(PlayerInfo[playerid][uName],"username");

        mysql_fetch_field_row(PlayerInfo[playerid][pOrigin],"origin");

    }

    mysql_free_result();

}

Your problem is that you forgot to declare the length of the string where you save this:

PHP код:



savingstring[10];

You can put the "username" and the "origin" directly in the arrays.

i have try this and my /stats ingame is the same. I can't show my /stats ingame like my database.

Re: Problem with Show String in /stats command - Opeal - 18.11.2015

Quote:

Originally Posted by gurmani11

Код HTML:

 while(mysql_fetch_row_format(query,"|"))
    {
	     mysql_fetch_field_row(savingstring[1], "username"); strmid(PlayerInfo[playerid][uName], savingstring[1], 0, strlen(savingstring[1]), 255);
	     mysql_fetch_field_row(savingstring[2], "origin"); strmid(PlayerInfo[playerid][pOrigin], savingstring[2],  strlen(savingstring[1]), strlen(savingstring[2]), 255);
    }

i think you forgot to limit your string start with

PHP код:



strmid(string, "Extract 'HELLO' without the !!!!: HELLO!!!!", 34, 39); //string contains "HELLO"

Can you give me example? please..

Re: Problem with Show String in /stats command - gurmani11 - 18.11.2015

Try it

PHP код:



stock LoadDataString(playerid)
{
    new query[300], pName[24], savingstr1[10], savingstr2[10];
    GetPlayerName(playerid, pName, 24);
    format(query, sizeof(query), "SELECT * FROM `playerchar` WHERE `charname` = '%s'", pName);
    mysql_query(query);
    mysql_store_result();
    while(mysql_fetch_row_format(query,"|"))
    {
         mysql_fetch_field_row(savingstr1, "username");
             strmid(PlayerInfo[playerid][uName], savingstr1, 0, strlen(savingstr1));
         mysql_fetch_field_row(savingstr2, "origin");
             strmid(PlayerInfo[playerid][pOrigin], savingstr2, 0, strlen(savingstr2));
    }
    mysql_free_result();
}

Re: Problem with Show String in /stats command - Opeal - 18.11.2015

Quote:

Originally Posted by gurmani11

Try it

PHP код:



stock LoadDataString(playerid)

{

    new query[300], pName[24], savingstr1[10], savingstr2[10];

    GetPlayerName(playerid, pName, 24);

    format(query, sizeof(query), "SELECT * FROM `playerchar` WHERE `charname` = '%s'", pName);

    mysql_query(query);

    mysql_store_result();

    while(mysql_fetch_row_format(query,"|"))

    {

         mysql_fetch_field_row(savingstr1, "username");

             strmid(PlayerInfo[playerid][uName], savingstr1, 0, strlen(savingstr1));

         mysql_fetch_field_row(savingstr2, "origin");

             strmid(PlayerInfo[playerid][pOrigin], savingstr2, 0, strlen(savingstr2));

    }

    mysql_free_result();

}

i use it can't show anything, but i add this.

Код:

 {
	     mysql_fetch_field_row(savingstr1, "username");
		 	strmid(PlayerInfo[playerid][uName], savingstr1, 0, strlen(savingstr1), 255);
	     mysql_fetch_field_row(savingstr2, "origin");
		 	strmid(PlayerInfo[playerid][pOrigin], savingstr2, 0, strlen(savingstr2), 255);
    }

Show the origin success, but not username.

Re: Problem with Show String in /stats command - Opeal - 18.11.2015

Please, someone help me ...