Nubuilder Pro 3 – Example Web Application Deletion and Creation – Race Number system

Objective :

Create a simple online web application that can be used to type in race numbers. Once a number is typed in the time will automatically posted to a field. This could be used to manually record numbers of competitors coming across a finish line on mobile phones provided all phones have access to a web browser and they have 4G connection or wifi connection.

First go to the administrator url and sign in with the Global Administrator username and password to get into the design form.

The format of this is

If you wish to delete a project go to the delete tab within the site select the site you wish to delete then hit Delete

It will then present you with a sanity check window

Pressing enter again you get a site administration check box again

Adding a New Site in Nubuilder Pro
Go back to the opening screen and this time go to the Add Tab.

You should be presented with an Add Dialog window.
Type in the name you wish your new project to be here I call it racenumber – note the name has to be all lower case.
Hit create after which there will be a short delay while the site is created.

There will be a short delay while the site is created

You will then be presented with the Administration panel with your new site created something like the following

Now click on the site you are interested in this case race number which will take you to the login panel

Now enter the global username and password that you were originally handed out.

Once logged in you should be presented with the following screen.

Hitting the database button will take you to the php-myadmin control panel

The First step is to create a table to hold all the data

This can be done buy using the create table button on the bottom left.

Here I am creating a table called T002Time to which I add three columns. I set the AI which stands for Auto Increment to yes and I set this field as an index I also add a time field and set the default to current_time – note that in phpmyadmin fields will not necessarily accept default functions but Time variable type accepts current_time. Current_time function returns date and time.

Here I have forgotten the racenumber field so I create some SQL to add this in.

Now we want to go back to the Nubuilder web application panel

Hit the form wizard – now select the T002Time drop down in the table name and use the add to Browse column and add to Form Objects button to transfer everything across to the respective columns as follows.

This will run and in the background create a form which you can see by going through the User Home screen as follows

Now lets remove some fields we no longer need
Go to objects we can see that three columns relate to to the T002Time(form) Lets do several things
1. Remove DTime from the form
2. Remove the Race FKID from the form
3. Change the label of the home Form button T002Timebtn to Race Numbers

Firstly in the objects button go into the two lines you wish to remove from the form

and when the object details appear delete them.

After a warning message you should be presented with the new list of object without the object recently deleted.

The new form should look something like this.

That’s 1 and 2 done now lets try and get that button bigger.

Now in here I am going to remove the RACEFKID and make the DTIME much wider

Now we see

Now lets see if we can move this field to the centre of the screen this can be done while in global administration mode by clicking on the following button

Reposition then add users and that should be you.

Mafia Game

Starting Instructions

Mafia is a game for 7 or more players where everyone imagines they live in a village. I will hand out cards and according to what the cards are you will adopt a different role. The cards have the character you will be playing on them. The game’s objective is for everyone to identify who are the Mafia players in the village. The game ends when there are more Mafia players

The Mafia wins if they equal or outnumber the civilians.

The Civilians win if they successfully eliminate all Mafia members.
There will be a day night cycle …

Roles for nine people
1 Narrator
4 Civilians
2 Mafia
1 Sheriff
1 Doctor

Start of the game

Introduction
In our sleepy village, rumors have begun to spread. Whispers of a hidden Mafia in our midst have turned our peaceful days into ones of suspicion. We have gathered a small group of brave civilians, but some of us are not who we seem. Among us are those who would destroy our community, and it is up to the Sheriff, the Doctor, and all of you as civilians to work together to find and eliminate them. To maintain the safety of the Sheriff and the Doctor they cannot reveal themselves

Start of the NIGHT cycle

“As the moon rises over our quiet village, the Mafia wake up in the shadows. Their eyes gleam as they plan their next move. The Doctor, however, is always watching for signs of danger, ready to protect the innocent.”.

Everyone close your eyes
Night Phase:
Mafia: “Mafia, open your eyes and silently point to your next victim. Remember, you are hiding among the villagers, and your decision must be made in secret.”

Sheriff: “Sheriff, you are waking up to investigate. Open your eyes and silently point to the person you suspect to be Mafia, and your decision must be made in secret.”

Doctor: “Doctor, now it’s your turn to act. Open your eyes and point to the person to save from the Mafia’s wrath.”

Civilians please wake up and I will give each of you a chance to talk and say what you think consecutively.

But first I have news from last night

Narrator chooses the option
Version 1 (Mafia kills a civilian): “The Mafia struck again last night. One of our dear citizens, Civilian X, was found lifeless this morning. Let us honor their memory and continue our search for the culprits.”

Version 2 (Doctor saves the victim): “A chilling night has passed, but thanks to our Doctor’s quick thinking, the Mafia’s attack failed. Our target survives—but the threat still lingers in the shadows.”

Version 3 (Sheriff arrests Mafia): “The Sheriff has acted swiftly tonight. A Mafia member has been captured! Civilian B was hiding among us, but no more. They have been removed from the game.”

Player Discussion
Players consecutively discuss their suggestions as to who is innocent and who is not innocent

Voting Process (Day Cycle):
The voting process should be more structured and emphasize the importance of discussion and deduction. Consider adding a formal structure for the voting process.
Voting Process:

Discuss: “You now have 15 minutes to discuss among yourselves who you believe is a Mafia member. Use your intuition and any clues from the night cycle.”

Vote: “Once the discussion is over, each civilian will raise their hand to vote on who they believe is a Mafia member.”

Outcome: “The narrator will reveal whether the vote was correct or not. The voted civilian will be removed from the game, regardless of whether they are Mafia or not.”
Repeat to the Night Cycle
Endgame and Victory Conditions:
Make sure the game’s end conditions are explicitly stated at the beginning and reiterated as the game progresses.
Game End Conditions:

The Mafia wins if they equal or outnumber the civilians.

The Civilians win if they successfully eliminate all Mafia members.