FB Login and Google Maps now Working!

Facebook login and Google Maps are now working!! Quite a pain. Latest version is updated on BitBucket. The login concept art might need to change to accomodate facebook login instead of managing logins our selves.

Design development

More UI development

Benni Otting

UI Testing

I started doing some user interface testing. Realised there were some issues with navigation between pages, so need to rethink some of the design. Getting somewhere though.

Benni Otting

Further developments

Benni Otting

UI Design concepts

Benni Otting

Logo Concepts

Benni Otting

Decided to use Restful Approach

Hey guys i decided to go with Sergey suggestion to use Codeigniter PHP framework. It pretty awesome and simple to use, currently I have tested at against the Database I built and it is correctly posting and getting Database entries. For now i am making it return all the data in a XML format, so far no problems.

So far it can:

•  Add a New Place to the Database
• Get all the Places.
• Add a Image Location (Possible a link to Flikr address of the image) to the database.
• Get all the images of Place based on its ID.
• Add a Post for a Place to the database.
• Get all the Posts from the database for a Place.

Example Output for getting all the Places:

<root>

<element>

<ID>1</ID>

<Name>happy place</Name>

<Latitude>-41.318278</Latitude>

<Longitude>174.79735</Longitude>

<DateFound>2013-05-26 16:28:28</DateFound>

</element>

<element>

<ID>2</ID>

<Name>WonderLand</Name>

<Latitude>-41.318278</Latitude>

<Longitude>174.79735</Longitude>

<DateFound>2013-05-26 16:29:05</DateFound>

</element>

</root>

Next step is putting the controller into the Amazon Web Server.

Created Database

I have created a database, that matched the application current needs. So far there is three tables:

• Place table: Which represents each Discovered Place.
• Photo Table: Which is  table that contains an images location and the Place it belongs to.
• Posts  table: Contains a table filled with posts relating to places and other meta data such as a Time stamp.

I having been testing this Database out in my WAMP server at home. Next Step will be adding this to Amazon Web Server.

CREATE TABLE IF NOT EXISTS `place` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` text NOT NULL,
  `Latitude` double NOT NULL,
  `Longitude` double NOT NULL,
  `DateFound` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

CREATE TABLE IF NOT EXISTS `photos` (
  `PhotoID` int(11) NOT NULL AUTO_INCREMENT,
  `PlaceID` int(11) NOT NULL,
  `ImageURL` text NOT NULL,
  PRIMARY KEY (`PhotoID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `posts` (
  `PostID` int(11) NOT NULL AUTO_INCREMENT,
  `PlaceID` int(11) NOT NULL,
  `Post` text NOT NULL,
  `DatePosted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UserID` int(11) NOT NULL,
  `Rating` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`PostID`)

) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

I got a free domain name spotson.tk. Its slow though haha. Also only works when the server is running.

http://spotson.tk/api/users :

Hey guys! I've decided we would be better off with an Amazon server so I've set up an instance. You can check it out here: http://ec2-54-214-76-117.us-west-2.compute.amazonaws.com/index.html

@Devyish pm me for access details

Edit: actually it might not work because I will try to keep the server offline when we aren't working on it. It's a free but limited instance and I don't want to go over out limit and have to pay. Cheers.