jatin1726's Forum Posts

  • It's easy, first display that top 10 select. Under it add another textbox or whatever C2 object you use to display the first 10, so add one under it (i guess it's a textbox).

    Make it smaller and assign the following select to it

    SELECT

    *

    FROM scores

    where Name = <C2 variable holding his nickname>

    This will display one line with the player's nickname, and since you put the textbox under it, it will show as separate.

    It is possible to make a select to display everything in the same C2 object but i'm in a bit of a hurry right now. I'll see if I can make that work as well a bit later.

    Hi,

    Thanks for response. As I shared above I hve no idea about php and sql. Can you help me by updating sample capx (of tutorial) to the one showing current user id? That will be big help for me.

  • Sorry, I was under the impression that you had some knowledge of database operation.

    Okay, you see in this image:

    towards the bottom where he has the parameter $sql="SELECT * FROM scores ORDER BY score DESC LIMIT 10"

    You simply need to remove the "LIMIT 10" and it will return all of the scores in the database ordered by score descending.

    That is what that select statement is asking for:

    SELECT (tells the database to get data)

    * (tells it to return all data)

    FROM scores (from the "scores" table)

    ORDER BY score (order the data lexicographically by score)

    DESC (in a descending order from highest to lowest)

    LIMIT 10 (only return the top 10 scores)

    > How can I turn it to use 3 columns instead of 3.

    >

    Also this question makes no sense.

    Thanks a lot Gumshoe for such details replay, really really helpful and I understood that removing the limit of 10 will display all results. But in sample capx creator is using array and I have made it 10x10 to display data in 5 lines in text boxes. If I will try to show all list (might be scrolable) then how it can be done (I think it needs to create scrollalbe list with data filling from server, right)? any help in this? To cut short the things I am sharing screenshot of leaderboard similar to my requirement. I will be very thankful to you if can help me in getting close to this.

    Regarding colum 3 to 3 statement, it was my mistake. Actually creator is using 2 column (through array) and I need 3 colmn (index no. , player name, score). Also explaining this through screenshot.

    Thanks again.

    waiting for your reply. below is screenshot of required leader board and question which I have.

  • >

    > > PixelRebirth

    > > A Match-3 demo capx, using PixelRebirth's much overlooked jMatch3 plugin.

    > >

    > > screenshot-

    > > https://drive.google.com/open?id=0B4jH2 ... y1VaVFobWc

    > >

    > > Rar file-

    > > https://drive.google.com/open?id=0B4jH2 ... EpyMG5Gczg

    > >

    >

    > There is issue here. Matches should be activated only when it happens either vertical 3 or horizontal 3 or more. But it matches even L shapes also. How to fix it?

    >

    This is by design and mentioned in the first post. To currently change this you would have to edit the jMatch3 lib itself, so it's probably better to go for another solution.

    Thanks pixel.

    Can you suggest me any easy sample or plugin for creating game close to real candy crush?

  • PixelRebirth

    A Match-3 demo capx, using PixelRebirth's much overlooked jMatch3 plugin.

    screenshot-

    https://drive.google.com/open?id=0B4jH2 ... y1VaVFobWc

    Rar file-

    https://drive.google.com/open?id=0B4jH2 ... EpyMG5Gczg

    There is issue here. Matches should be activated only when it happens either vertical 3 or horizontal 3 or more. But it matches even L shapes also. How to fix it?

  • You should be able to have the MySQL engine sort the results of a SELECT script.

    Like this:

    https://www.tutorialspoint.com/mysql/my ... esults.htm

    Hi Thanks a lot for response.

    But I have no knowledge about php and mysql. I was following sample capx file used in tutorial. Currently it is displaying only two columns, name and score. Can you help me in displaying 3rd element which is ranking. In sample author has used array. How can I turn it to use 3 columns instead of 3. and how to fetch from db and display in construct 2 file.

    I will be really greatful to you if you can help me in modifying the sample capx of tutorial.

    Thanks in advance.

    Jatin

  • May be it need to send through https or needs to be uploaded to server first before making a call.. Just a guess.

  • Hi Everyone,

    I am currently trying to create leaderbaord by following this tutorial "https://www.scirra.com/tutorials/4839/creating-your-own-leaderboard-highscores-easy-and-free-php-mysql"

    Can anyone please tell me how to display position of ranking of current user/scorer. (I.e. If current user is standing at ranking 101th position in leaderboard then how to display the ranking(101th) below 10 top scores table.

    sample capx is attached in the tutorial itself. I am using same.

    Need help very urgently.

    Regards,

    Jatin

  • finally fixed it. if someone got questions on the new events hit me up fam.

    Benhh can u plz share capx. searching it badly but couldnt find one.

  • Great Example. But how can be turn it into smooth swipe interaction game like happens in real candy crush. Right now we have to tap on each block to interchange.

  • I don't think you can do that with construct 2.

  • Try Construct 3

    Develop games in your browser. Powerful, performant & highly capable.

    Try Now Construct 3 users don't see these ads

  • Edit your first post and from there you can change the title, or add solved.

    Thanks CurryPuff

  • How to put "Solved" in front of this post? can anyone help me in this?

  • You could try playing around with the 'set time scale' event in 'system', set it to something like 25% speed and then wait for 1 second (which will be 4 seconds in real time) and then set it back to 100% speed.

    Thanks a Lot. Time scale is working perfect. Also attaching capx so that if anyone else want to use the slow motion behavior this will be helpful.

    https://touch.affle.com/ads/bullet/slow ... ullet.capx

    Regards,

    Jatin

  • It works with the Buttons condition 'On clicked'. If you want to use the Touch condition 'On tap' you can use a sprite instead of a Button object.

    Thanks Pandadoor. It worked great. Tap on sprite worked as u said. But I still couldn't understand why touch action on button component couldn't activate bullet behavior.

  • You could try playing around with the 'set time scale' event in 'system', set it to something like 25% speed and then wait for 1 second (which will be 4 seconds in real time) and then set it back to 100% speed.

    I tried to create your solution but now bullet is not even moving on click on button. Attaching capx of the file.

    https://touch.affle.com/ads/bullet/bullet.capx

    can u let me know why bullet is not moving on ok button click