[Loinal]

I have 2 players then the textdraw show the one who have less money than other

PHP код:

stock Topcash()
{
    mysql_tquery(mysql ,"SELECT Username,Money FROM players WHERE ID ORDER BY Money LIMIT 1;", "ShowBestCash","");
    return true;
}
forward ShowBestCash();
public ShowBestCash()
{
      new rows;
    cache_get_row_count(rows);
    if(rows)
    {
        new playername[35];
        new playermoney;
        new str[1303];
        cache_get_value_index(0, 0, playername);
        cache_get_value_name_int(0,"Money",playermoney);
        cache_get_value_index_int(0,1, playermoney);
        format(str, sizeof(str), "~b~~h~N~b~~h~e~b~~h~~h~w~b~~h~~h~s~w~:~y~~h~%s~w~ Is the reachest player (~r~%d~r~~h~ cash~w~)~n~~n~", playername, playermoney);
        TextDrawSetString(Textdraw7,str);
        TextDrawShowForAll(Textdraw7);
    }
    return 1;
} 


[kloning1]

can you show your code when server creating textdraw?

using side money ( textdraw ) you have to set the textdraw to player not to global.
i recommended use
https://sampwiki.blast.hk/wiki/CreatePlayerTextDraw

[Vince]

Default sort order is ascending. Append the DESC keyword to sort in descending order (ORDER BY money DESC).

[Loinal]

Quote:

Originally Posted by kloning1 can you show your code when server creating textdraw? using side money ( textdraw ) you have to set the textdraw to player not to global. i recommended use https://sampwiki.blast.hk/wiki/CreatePlayerTextDraw

Do you need my textdraw codes?

[Loinal]

Quote:

Originally Posted by Vince Default sort order is ascending. Append the DESC keyword to sort in descending order (ORDER BY money DESC).

didn't understand

[Loinal]

Any help?

[Macronix]

He means that you should add "DESC" to your mysql query.

PHP код:

mysql_tquery(mysql ,"SELECT Username,Money FROM players WHERE ID ORDER BY Money DESC LIMIT 1;", "ShowBestCash","") 


[Loinal]

Quote:

Originally Posted by Macronix He means that you should add "DESC" to your mysql query. PHP код: mysql_tquery(mysql ,"SELECT Username,Money FROM players WHERE ID ORDER BY Money DESC LIMIT 1;", "ShowBestCash","")

what should i do in it?

[Macronix]

Nothing. I already added it to your query in my post. Try that line.

[Loinal]

PHP код:

 Topscore()
{
    mysql_tquery(mysql ,"SELECT Username,Score FROM players WHERE ID ORDER BY Score DESC LIMIT 1;", "ShowBestScore","");
    return true;
}
forward ShowBestScore();
public ShowBestScore()
{
      new rows;
    cache_get_row_count(rows);
    if(rows)
    {
        new playername[35];
        new playerscore;
        new str[1303];
        
        cache_get_value_index(0, 0, playername);
        cache_get_value_name_int(0,"Score",playerscore);
        cache_get_value_index_int(0,1, playerscore);

        format(str, sizeof(str), "~b~~h~N~b~~h~e~b~~h~~h~w~b~~h~~h~s~w~: Player with the most score is~y~~h~ %s~w~ have (~r~%d~r~~h~ score~w~)~n~~n~", playername, playerscore);
        TextDrawSetString(Textdraw7,str);
        TextDrawShowForAll(Textdraw7);
    }
    return 1;
}
stock Topcash()
{
    mysql_tquery(mysql ,"SELECT Username,Money FROM players WHERE ID ORDER BY Money DESC LIMIT 1;", "ShowBestCash","");
    return true;
}
forward ShowBestCash();
public ShowBestCash()
{
      new rows;
    cache_get_row_count(rows);
    if(rows)
    {
        new playername[35];
        new playermoney;
        new str[1303];

        cache_get_value_index(0, 0, playername);
        cache_get_value_name_int(0,"Money",playermoney);
        cache_get_value_index_int(0,1, playermoney);

        format(str, sizeof(str), "~b~~h~N~b~~h~e~b~~h~~h~w~b~~h~~h~s~w~:~y~~h~%s~w~ Is the reachest player (~r~%d~r~~h~ cash~w~)~n~~n~", playername, playermoney);
        TextDrawSetString(Textdraw7,str);
        TextDrawShowForAll(Textdraw7);
    }
    return 1;
} 


Not getting the higher score or the reachest one it only get the last one who registered