Text only | Text with Images

Vice City: Multiplayer

VC:MP Discussion => Support => Topic started by: Nihongo^ on Dec 27, 2018, 07:11 AM

Title: Topclan not in one line
Post by: Nihongo^ on Dec 27, 2018, 07:11 AM
Hi i am trying to add top clan and facing a problem
top clans are not in line you can see after "Top 5 Killers MD" its start showing from down any solution ? Here's my code

(https://i.postimg.cc/13pMQbyr/2018-12-26-23-05-03-0366.png)

Code Select
else if ( cmd == "topclan" )
        {
          local
     query = "SELECT Clan, Kills FROM ClanStats ORDER BY Kills DESC LIMIT 5", //Top 5
      q,
      name1, name2, name3, name4, name5,
      kills1, kills2, kills3, kills4, kills5, i = 1;
   
     q = QuerySQL( db, query );
     while( GetSQLColumnData( q, 0 ) )
     {
             switch(i)
             {
                    case 1:
                              name1 = GetSQLColumnData( q, 0 );
                              kills1 = GetSQLColumnData( q, 1 );
                              break;

                   case 2:
                              name2 = GetSQLColumnData( q, 0 );
                              kills2 = GetSQLColumnData( q, 1 );
                              break;

                   case 3:
                             name3 = GetSQLColumnData( q, 0 );
                             kills3 = GetSQLColumnData( q, 1 );
                             break;

           case 4:
                             name4 = GetSQLColumnData( q, 0 );
                             kills4 = GetSQLColumnData( q, 1 );
                             break;

                case 5:
                             name5 = GetSQLColumnData( q, 0 );
                             kills5 = GetSQLColumnData( q, 1 );
                             break;
            }

             GetSQLNextRow( q );
             i++;
     }
     FreeSQLQuery(q);
      ClientMessage( "Top 5 Killers: " + name1 + " Kills: " + kills1 + " | " + name2 + " Kills: " + kills2 + " | " + name3 + " Kills: " + kills3 + " | " + name4 + " Kills: " + kills4 + " | " + name5 + " Kills: " + kills5 + "." player, 255, 255,  0  );
}
Title: Re: Topclan not in one line
Post by: D4rkR420R on Dec 27, 2018, 07:12 PM
Use the escape sequence for "new line", using \n.
Title: Re: Topclan not in one line
Post by: Nihongo^ on Dec 28, 2018, 11:21 AM
not work with /n
Code Select
ClientMessage( "Top 5 Killers: \n" + name1 + " Kills: " + kills1 + " | " + name2 + " Kills: " + kills2 + " | " + name3 + " Kills: " + kills3 + " | " + name4 + " Kills: " + kills4 + " | " + name5 + " Kills: " + kills5 + "." player, 255, 255,  0  );
Title: Re: Topclan not in one line
Post by: D4rkR420R on Dec 28, 2018, 05:19 PM
Quote from: Nihongo^ on Dec 28, 2018, 11:21 AMnot work with /n
Code Select
ClientMessage( "Top 5 Killers: \n" + name1 + " Kills: " + kills1 + " | " + name2 + " Kills: " + kills2 + " | " + name3 + " Kills: " + kills3 + " | " + name4 + " Kills: " + kills4 + " | " + name5 + " Kills: " + kills5 + "." player, 255, 255,  0  );

Code Select
ClientMessage( "Top 5 Killers:\n "+ name1 + " Kills: " + kills1 + "\n" + name2 + " Kills: " + kills2 + "\n" + name3 + " Kills: " + kills3 + "\n" + name4 + " Kills: " + kills4 + "\n" + name5 + " Kills: " + kills5 + ".", player, 255, 255, 0 );
Title: Re: Topclan not in one line
Post by: Nihongo^ on Dec 29, 2018, 05:40 AM
Not work bro

(https://i.postimg.cc/XJBgnKJk/2018-12-29-10-39-18-0966.png)
Title: Re: Topclan not in one line
Post by: MEGAMIND on Dec 29, 2018, 05:56 AM
Quote from: KuRuMi^ on Dec 28, 2018, 05:19 PM
Quote from: Nihongo^ on Dec 28, 2018, 11:21 AMnot work with /n
Code Select
ClientMessage( "Top 5 Killers: \n" + name1 + " Kills: " + kills1 + " | " + name2 + " Kills: " + kills2 + " | " + name3 + " Kills: " + kills3 + " | " + name4 + " Kills: " + kills4 + " | " + name5 + " Kills: " + kills5 + "." player, 255, 255,  0  );

Code Select
ClientMessage( "Top 5 Killers:\n "+ name1 + " Kills: " + kills1 + "\n" + name2 + " Kills: " + kills2 + "\n" + name3 + " Kills: " + kills3 + "\n" + name4 + " Kills: " + kills4 + "\n" + name5 + " Kills: " + kills5 + ".", player, 255, 255, 0 );
this is what actually he told u too \n means a newline so as u  can see there are many \n so obviously each clan tag will start from new line
Title: Re: Topclan not in one line
Post by: Nihongo^ on Dec 29, 2018, 08:04 AM
Quote from: MEGAMIND on Dec 29, 2018, 05:56 AM
Quote from: KuRuMi^ on Dec 28, 2018, 05:19 PM
Quote from: Nihongo^ on Dec 28, 2018, 11:21 AMnot work with /n
Code Select
ClientMessage( "Top 5 Killers: \n" + name1 + " Kills: " + kills1 + " | " + name2 + " Kills: " + kills2 + " | " + name3 + " Kills: " + kills3 + " | " + name4 + " Kills: " + kills4 + " | " + name5 + " Kills: " + kills5 + "." player, 255, 255,  0  );

Code Select
ClientMessage( "Top 5 Killers:\n "+ name1 + " Kills: " + kills1 + "\n" + name2 + " Kills: " + kills2 + "\n" + name3 + " Kills: " + kills3 + "\n" + name4 + " Kills: " + kills4 + "\n" + name5 + " Kills: " + kills5 + ".", player, 255, 255, 0 );
this is what actually he told u too \n means a newline so as u  can see there are many \n so obviously each clan tag will start from new line
I know bro the question is how can i appear "MD" in one line /n seems not work for me
Title: Re: Topclan not in one line
Post by: DizzasTeR on Dec 29, 2018, 09:54 AM
You guys can't be serious, he is literally asking to show it on one line, not show each in separate line, damn.

As for your issue, it seems like the clan "MD" has a new line char in it, try checking the db or wherever you are storing them and make sure the clan names don't have a new line.
Title: Re: Topclan not in one line
Post by: Nihongo^ on Dec 29, 2018, 11:50 AM
Quote from: Doom_Kill3R on Dec 29, 2018, 09:54 AMAs for your issue, it seems like the clan "MD" has a new line char in it, try checking the db or wherever you are storing them and make sure the clan names don't have a new line.
Ah my bad Thank you so much Doom Solved
Title: Re: Topclan not in one line
Post by: Strike Eagle on Dec 29, 2018, 12:00 PM
Quote from: Nihongo^ on Dec 29, 2018, 11:50 AM
Quote from: Doom_Kill3R on Dec 29, 2018, 09:54 AMAs for your issue, it seems like the clan "MD" has a new line char in it, try checking the db or wherever you are storing them and make sure the clan names don't have a new line.
Ah my bad Thank you so much Doom Solved

Btw Thanks all
Text only | Text with Images