Task Hour/Day + Countdown Timer + Prevent Hacking


Yup! I got it…


THank You So much for all effort


Hay personas que quieren todo frito y cocido, Pixii. Por eso mismo dejé yo de hacer tutoriales.
Agradecen muy poco nuestro tiempo.
Tú eres genial PixxiBoomb.


is it possible to make with mysql database and php?
connected with web component.


can you please tell my if i want to make it for a month with date component how to do this


What have you tried yourself?


I made an app but i want to know how to how to make a monthly leaderboard like start date of every month the system show users new score


Hello mam I am your a patron member.can i make a project bucket of timestamp and store the value with 0 with username tag. i mean when a user register in app i WANT MAKE A PROJECT BUCKET OF TIMES STAMP AND STORE DATA WITH USER NAME TAG AND VLUE WITH 0.BUT WHEN USER CLICK ON A BUTTON THE TIMESTAMP VALUE STORE USERNAME TAG .Untitled


Yes you could do that. That’s 100% up to your preferences and how you like to organize things.
There is nothing wrong with that method, you just need to create a system to help you remember how you organized your data. You can still do this using ONE Firebase Component. Just create your own variables to access each of your tags.

Personally, I really really don’t like Firebase for user data. I think it’s extremely disorganized and it’s much more difficult to handle a large database of user information.

I prefer SQL based databases like mySQL, SQLite or Fusion Table, but that’s my personal preference.
The reason is because I prefer a table layout where I can see all of the data in rows and columns.
And I can use SQL commands to easily access/manipulate that data.


Hi @PixiiBomb What would you prefer, fusion table or airtable?


yes i tried in fuison table .but when user open task screen they not get time of loading data .they quikly click and the procedure break and they can click the button .its happen with me


i mean when screen instilize they dont get time to loading data they quikly click anywere on screen and the get data procedure not work .thats why i want try with firebase i think its little fuison table also in fuison table server somtime user data not store due to server failuer.sorry my english is very bad


Thank You Dear .Problem Slove.is it posible to make leaderborad with firebase like Fuison Table


Hello, I don’t mean to bother but I went through the tutorial a couple times and verified that the blocks were correct with the tutorial but I keep getting this error and i’m not sure whats causing it because i’d understand if I messed up somewhere in my app but I ended up downloading the .aia file to test it out in the official file and it’s still giving me the same error. Before anyone asks yes I went in and changed all the fusion table information and put my userid in for my table so it was in fact not using pixii’s information. I did however manage to get it to work a few times and add the timestamp into the fusion table so I know it can send information to it but it only works when I press the event button multiple times and just not on the first click, this is the error I get can anyone possibly help?

the stars after update is my fusion table ID, blocked it out just in case

Error in SendQuery
Error 2601: Fusion tables returned an error. The query was: UPDATE ******** SET timestamp= WHERE USERID=23123123. The response was: 400 Bad Request invalid query: PArse error near ‘WHERE’ (line 1, postion 64).


to set a timestamp to nothing does not work very good, does it?
It would really help if you provided a screenshot of your relevant blocks, so we can see what you are trying to do, and where the problem may be.


Trying to push the limits! Snippets, Tutorials and Extensions from Pura Vida Apps by Taifun.


this error and the blocks are a part of the actual .aia file attached on pixii’s tutorial this is why i’m wondering whats going on.

it does get set to something though?, it just doesn’t show up when the statement is called [See blocks below] The “global timestamp_new” should be set as soon as the screen starts but when I first press the button it gives me the error but if I wait a few and try to press it again usually it will add the timestamp to my fusion table and then do the count down, my assumption is that the website is pretty slow so it takes a lot longer to reach and then respond to it. So my only thoughts is to manually add the timestamp instead of waiting on the website when the user first clicks the button. But then again that would completely defeat the whole purpose of this tutorial.


as you can see from the error message, your global variable timestamp_new was empty while sending the update statement…

I’m not familiar with that tutorial, but what about sending the update statement to the table only after a timestamp has been received in the Web.GotText event? @PixiiBomb might want to check…



Hey Guyz Please Help Me In This Toturial Given Site for timestamp Not Working Showing Error

Anyone Can solve this problem If have any other site so please tell me



Hi @PixiiBomb, just like M_Arslan the website seems to be down for me. I can’t get the API for the tutorial. Is there another version of the API that I could use somewhere, or is there another way to get the API you’re aware of? Thank you for your time and the tutorial.