Hold on... This isn't EnnuiDesign.com — What Gives?
It's been a long time coming, but Jason Lengstorf, formerly of Ennui Design, has expanded his team to include Drew Douglass, Rob MacKay, Henry Moran, and Tom Sturge.
It didn't feel right to keep the same name, so we decided to continue on as Copter Labs. You can expect the same great content under this new name!
Creating an App from Scratch: Part 2
Where We're At
Up to this point, we've planned the way our app is going to look, as well as given ourselves a basic idea of how the app is going to function. The next step is to figure out what's going to happen behind the scenes to allow our app to work the way we've planned.
Okay, So We Know How It Looks, but How Does It Work?
In order to keep a list available after a user logs out of our app, we'll need to store list information in a database. And, of course, to access that database we're going to need some kind of server-side scripting language. For this app, we made the choice to go with a combination of MySQL and PHP to handle all our behind-the-scenes data handling and storage.
Data Storage—Planning and Database Structure
Our first step is to decide how we want to organize list data. Since this app is fairly simple, we'll only need three tables in our database. The first table will store user information, and the second will store list information. The third table will keep track of list items.
Creating the Database
Of course, before we can create our tables, we'll need a database to work with. For anyone working along at home, we'll be operating under the assumption that you're building and testing locally (we recommend XAMPP).
Navigate to http://localhost/phpmyadmin and open the SQL tab. You can use the GUI if you want, but we're going to use raw SQL commands for learning purposes. The database will be named cl_db, which is all the information that is required to build the database. However, we want to make sure that our users can use characters from any language in their lists, so it's also a good idea to specify the collation and character set of the database. We'll be using the UTF-8 character set with general collation, which supports multilingual characters and is case-insensitive.
The command to create this database is:
CREATE DATABASE `cl_db` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
Execute this command from the SQL tab in phpMyAdmin and the new database will become available. Now that we've got a database, we're ready to build our tables.
Table 1: User Information
Using our list app doesn't require a high security clearance; all we need to know is that you've got an email address and that it's real. To determine that an email address is real, we'll be sending new users a confirmation link in an email, which they need to follow before using our app. This means we need to have a unique confirmation link and a place to store whether or not an account has been verified.
Of course, we also need to store the user's email address, and in the interest of keeping redundant data storage to a minimum, we'll assign each user a unique numeric identifier.
The MySQL command to build this table will look like this:
CREATE TABLE cl_db.users
(
UserID INT PRIMARY KEY AUTO_INCREMENT,
Username VARCHAR(150) NOT NULL,
Password VARCHAR(150),
ver_code VARCHAR(150),
verified TINYINT DEFAULT 0
)
Table 2: List Information
List information is fairly straightforward. Each list will have a unique identifier, a unique URL, and the identifier of the user that owns the list. This helps us limit the amount of redundant information that needs to be stored.
To build this table, execute the following MySQL command in phpMyAdmin's SQL tab:
CREATE TABLE cl_db.lists
(
ListID INT PRIMARY KEY AUTO_INCREMENT,
UserID INT NOT NULL,
ListURL VARCHAR(150)
)
Table 3: List Items
Finally, we need a table that will store our list items. Each list item needs a unique identifier, the ID of the list it belongs to, and the information the user enters as his or her list item. Also, to support features we'll be adding later on, we also need to keep a record of the item's position and color. Execute this command in the SQL tab of phpMyAdmin:
CREATE TABLE cl_db.list_items
(
ListItemID INT PRIMARY KEY AUTO_INCREMENT,
ListID INT NOT NULL,
ListText VARCHAR(150),
ListItemDone INT NOT NULL,
ListItemPosition INT NOT NULL,
ListItemColor INT NOT NULL
)
NOTE: The ListItemDone field was omitted in the original post of this article. It was added here after being pointed out in the comments by FuSi0N.
The database with our three tables
Now we have our database and the three tables we'll need to build our app. Next, we'll plan how we're going to create and access our database information using PHP.
Data Handling—Planning and Script Organization
Before we start coding, it's always a good idea to take a moment and map out everything that needs to be done. That way, we can group tasks into logical arrangements.
Because great code starts with great organization, we'll be using an object-oriented approach.
Planning our PHP Classes
Object-oriented programming provides an easy way to keep related functions grouped together. After learning object-oriented programming, it becomes an incredibly powerful tool that increases portability, readability, and usability of scripts. Our app is pretty simple, so we'll only need two classes. The first class is going to handle user interactions, such as registering, updating information, and logging in and out. The second class will handle list interactions, such as adding, deleting, and moving list items.
User Actions Class
Our first class, which we'll name ColoredListsUsers, needs to handle all the actions our app will perform that are user account-related. Again, this is a pretty simple application, so when we map out everything that users can do with their account, we end up with pretty short list:
- Create an account
- Verify the account
- Update the account email address
- Update the account password
- Retrieve a forgotten password
- Delete the account
In addition to those methods, we'll also need some support methods, such as one that will send a verification email. We'll define these methods as we build the app in later installments of this series.
List Actions Class
The list actions class, which we'll call ColoredListsItems, also has a pretty short list of methods. This class will handle everything else our app does, which is anything a user can do with his or her list items. The list of available actions ends up looking like this:
- Create a list item
- Update a list item
- Delete a list item
- Change a list item's position
- Change a list item's color
Action Handling Scripts
Finally, we'll need a couple action-handling scripts. These will determine what the user's desired action is, create an instance of the proper object, and call the correct method. As we build our app, we'll go into more detail on how these scripts will work.
Moving On
In our next installment of this series, we'll create the application workflow. Make sure you're subscribed to CSS-Tricks so you don't miss out!
Series Authors
Jason Lengstorf is a software developer based in Missoula, MT. He is the author of PHP for Absolute Beginners and regularly blogs about programming. When not glued to his keyboard, he’s likely standing in line for coffee, brewing his own beer, or daydreaming about being a Mythbuster.
Chris Coyier is a designer currently living in Chicago, IL. He is the co-author of Digging Into WordPress, as well as blogger and speaker on all things design. Away from the computer, he is likely to be found yelling at Football coaches on TV or picking a banjo.
Jason Lengstorf
Jason Lengstorf a turbogeek hailing from Portland, Oregon. He designs and develops websites using PHP, MySQL, JavaScript (jQuery), CSS, and HTML. He's written two books (PHP for Absolute Beginners [2009 Apress] and Pro PHP and jQuery [2010 Apress]), and he's written articles on development and design for Nettuts, CSS Tricks, and Smashing Magazine, among others.
Comments.
Hi,
Great article ! Made someting vague and unknown very simple and clear.
One question tho, Why keep so many table-entries ? Wouldn't a few array()'s be a much better choise in this case ?
--
TeMc
TeMc 6:37am Nov 23, 2009 permalink | flag
Folllow up:
I'd do 1 table for everything related to lists.
With array's for each list. The array would contain all the information about the list, and one of the items in an array would be another array wich contain the actuall list items.
I think that would ease the future use on the front end, ie.:
$list[id][item_id][color] = "blue";
TeMc 6:42am Nov 23, 2009 permalink | flag
@TeMc
We opted to keep separate tables for the sake of normalization and ease of readability. Using arrays seems like it would have been difficult to read moving forward. I think that our choice will start to make more sense as the series progresses.
If I'm misunderstanding you, feel free to set me straight. :)
Jason Lengstorf 6:53am Nov 23, 2009 permalink | flag
This is great! As a .NET developer I have been digging around PHP recently and it seems like its pretty easy to pick up (I guess thats why its so popular). This is a great article and I look forward to reading the rest, hopefully it will be as well explained as this!
@TeMc - setting up separate tables is good practise, it allows for expansion and leaves a certain amount of flexibility in the design. I don't see why the front end coding will be any more difficult with more tables, you are just pulling data from a well structured database. Multi dimensional arrays are best avoided where possible as they really make life difficult for everyone involved, not to mention debugging etc.
Keep it up Jason (you have a new subscriber :))
tbmedia 7:41am Nov 23, 2009 permalink | flag
Great article. Sharing working source code samples will be great.
st 8:57am Nov 23, 2009 permalink | flag
Jason,
Great article, I'm really looking forward to the other parts. It's an interesting twist bouncing between Chris's visua/UI contributions and your more "codey" bits.
Like many of us one-man developers, I usually have to do both the design, front-end and back-end work so it's great to see a series of articles joining the two and showing your process.
Incidentally, who did the artwork for this site? Specifically the "Who is this Guy" portrait and "tin cans and string?"
Thanks again for sharing all your hard work.
Sprogz 9:14am Nov 23, 2009 permalink | flag
@tbmedia:
Glad you're enjoying it so far! If you're looking to get deeper into PHP, it might be worth checking my book out. It can refresh you on the basics and covers some of the more advanced things possible with PHP (yeah, I know, shameless). :)
@st:
All the source for this project is going to be covered in the coming articles, and the full app will be released as a "demo" of how it all works.
@Sprogz:
I usually do the one-man show as well, so this experience was a lot of fun for me.
Regarding the artwork on this site, that was me. :)
Jason Lengstorf 11:56am Nov 23, 2009 permalink | flag
What's the point of ListURL?
greg 1:04am Nov 24, 2009 permalink | flag
Why do you define the password field as VARCHAR(150)? Do you plan to store passwords as plain text?
Have you considered storing only the hash of the password? This would only require 32 or 40 characters, depending on the hashing function (md5 or sha1).
Of course the hashes require salting, and of course you would have to offer the ability of setting a new password instead of sending out the current one in a reminder email, but storing unencrypted passwords in a database is not secure enough and is a bad practice.
Wabbitseason 1:36am Nov 24, 2009 permalink | flag
@greg: I think ListURL is going to hold a hash value unique to each list. If you want to "share" a list with one or more people, you can make them aware of this hash (in the form of a URL). It'll probably be something like /list/176d6acc5245dc76e. Could come in useful to share my Xmas list :D
@Wabbitseason: Of course there's nothing to stop them storing a 32 or 40 character hash of the password and prepending/appending an eight character (or whatever sized) salt into this one field. However, I agree using a VARCHAR(150) looks a little "large" if they were planning on doing this though.
I hope they don't use the old "it's only a demo" excuse. Surely they will try and teach best practise so I'm sure they're not going to store the passwords un-encrypted?
I don't think we should jump the gun until we've seen the remaining parts.
Sprogz 2:14am Nov 24, 2009 permalink | flag
@greg:
As Sprogz suspected, we'll be using ListURL to store a unique URL for each list in the database.
@Wabbitseason:
We are definitely not storing plain text passwords. The use of VARCHAR(150) was a lazy oversight on my part; it could have been smaller. I'll be sure to adjust this for v2.0.
@Wabbitseason and Sprogz:
We didn't salt the passwords for this app (another 2.0 feature), and I don't really have an excuse for that; it just got overlooked as we were pushing to get this live.
Thanks for the input!
Jason Lengstorf 6:12am Nov 24, 2009 permalink | flag
Thankx guys, this is gr8!
Q_the_novice 10:58pm Nov 24, 2009 permalink | flag
Important!
Without the ListItemDone field in list_items table, the application can't retrieve your list after you log out.
Solution
CREATE TABLE cl_db.list_items
(
ListItemID INT PRIMARY KEY AUTO_INCREMENT,
ListID INT NOT NULL,
ListText VARCHAR(150),
ListItemDone INT NOT NULL,
ListItemPosition INT NOT NULL,
ListItemColor INT NOT NULL
)
fuSi0N 5:56pm Dec 8, 2009 permalink | flag
This is a great article!
But I was wondering if you could give me a more detailed explanation as to why the application can't retrieve your list after you log out unless you have a field ListItemDone as suggested by fuSiON?
I apologize if this seems like it's a self explanatory issue, but I'm missing the logic.
Thanks,
Derik
Derik 10:26am Dec 9, 2009 permalink | flag
@Derik
You should check ColoredListItems class and specifically formatListItems method in order to understand why this field is important.
fuSi0N 11:22am Dec 9, 2009 permalink | flag
@Derik:
In a nutshell, if the table doesn't have the ListItemDone field, the SQL query fails.
@FuSi0N:
Thanks for pointing that out; I've updated the article to reflect the proper SQL query and given you credit for catching the bug. Thanks!
Jason Lengstorf 11:53am Dec 9, 2009 permalink | flag
Very cool...
stumbled upon this site "mistakenly" and now im beginning to feel i need to make more of such mistakes...;)
simn 4:45am Jan 8, 2010 permalink | flag
Amazing articles, the whole site is mega- useful!! Thanks guys. Also the 'Onlineuniversalwork.com' link is spam, filthy spammers looking for illicit clicks :-)
mixedup 2:40am Feb 8, 2010 permalink | flag
I've downloaded source code and run them.
The result is "Internal Server Error". What should I do?
GillBate 3:37am Mar 16, 2010 permalink | flag
this was really nice as i m a beginner and my knowledge about web designing is very low and it helped me a lot tnx guys
arpit 3:37am Jun 18, 2010 permalink | flag
nice article
SHANKAR 6:59am Jul 14, 2010 permalink | flag
usually do the one-man show as well, so this experience was a lot of fun for me.
Regarding the artwork on this site, that was me. :)
rohit singh 7:01am Jul 14, 2010 permalink | flag
great tutorial, thanks.
scott 2:09pm Sep 26, 2010 permalink | flag
I'm running win 7, and php isn't working for me. Is there a section/forum on errors and troubleshooting related to this tuotiral? Thanks!
sooraj 1:20pm Oct 10, 2010 permalink | flag
@sooraj:
There's not a specific forum on this site for troubleshooting, but Chris has a forum over on CSS-Tricks.com (http://css-tricks.com/forums/discussions) — however, if you're having trouble getting PHP files to execute, it's probably a better idea to start scouring Google or look at http://stackoverflow.com/
Good luck!
Jason Lengstorf 9:20am Oct 12, 2010 permalink | flag
Wow.. great series here. This is something I really want to dive into, and hope to be following along building my own app very soon.. thanks for creating this series.
Eric Bonneman 6:32pm Jan 12, 2011 permalink | flag
I'm using MySQL server 5.1.44, and I am getting error code 1064 for the code for tables 1 and 2. Any idea what the reserved word in the code for tables 1 and 2 may be? I can't find it.
Ian 1:12pm Aug 27, 2011 permalink | flag
I am also having the same problem with the code.
Chaz 8:23am Oct 10, 2011 permalink | flag
this is really a best blog that you have posted over here, i am really glad to read this article, this is best to share information.
Lelli Kelly 10:01pm Oct 31, 2011 permalink | flag
http://starsend.dutiona.com/profile.php?id=362785
http://www.lesalonbaby.com/forum/profile.php?id=40651
http://www.loki-game.com/forum-eng/profile.php?mode=viewprofile&u=4342
http://forum.goldenptc.com/memberlist.php?mode=viewprofile&u=8759
http://wwwmy.binditalk.com/member.php?u=343944
Zegelidly 4:43pm Nov 25, 2011 permalink | flag
Nice to be visiting your blog again Herve Leger, it has been months for me. Well this article that i’ve been waited for so long. I need this article to complete my assignment in the college, and it has same topic with your article Herve Leger Dresses. Thanks, great share.
herve leger 9:02pm Nov 27, 2011 permalink | flag
subscription
Rambabu Rudra 5:35am Dec 3, 2011 permalink | flag
these types of as on highways and byways.They're normally Enormous strip mall like retailers. You literally can obtainmake profiles of objects they want to offer, many others just have sellers detailed in distinct categories. In equallyoriginal and new bags constantly, 2nd hand bags certainly are a good way of obtaining entry to designer bags at [url=http://www.lovechanel.net]chanel outlet[/url] they will make contact with the shop along with the support of an e-mail deal with provided.Overall, it's advisable that one particularChanel store, at the same time as within the a lot of authorised web sites that promote bags from Chanel. Creating purchasesChances are you'll come to feel embarrassed in an exact outlet to request too a lot of queries in regards to the products from your sales
FoneeacincHot 12:11am Dec 6, 2011 permalink | flag
January 8th- Duck Hunting - October 16th - December 14th- Dove Hunting - September 1st - 30th- It's a superbdrastically detectablethe moment the sky is dim or in the event you header out globetrotting at evening they inbarbed hook types and tackle from time to time in addition to 6 spiked hooks mounted on a person attract There's .txt [url=http://www.cacanadagooseparka.com]canada goose jacket[/url] using the main complicated in nature desires of persons requires accurately who under neath critical obstaclespieces upon the backside in the sleevesThe main Canada Goose parkas enjoy rather very long suited interiorcanada goose continues to be seen which provides a Sandhill motorised hoist groupThe North america goose has .txt
DodeAnneldgal 9:25pm Dec 8, 2011 permalink | flag
Legend of Zhong Qing court the remaining two people: 1: no money man 2: The woman is not packaged
Ken Griffey Shoes 6:40pm Dec 19, 2011 permalink | flag
I wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post
obat asam urat 5:05am Dec 25, 2011 permalink | flag
What if I wanted to have the database info stored on the users smart phone device? Thinking of making a web app that people could use but the data they input is stored locally on their device.
Dax Castro 11:40am Dec 27, 2011 permalink | flag
Outdoor gear and apparel giant The North Deal with Inc. is assisting consumers gear up for the holiday period through focused shoppable mobile advertisements.
The firm is running the mobile advertisements inside Pandora. Via the mobile ads, shoppers can find the closest retailer area or shop by way of their cell gadget.
The capacity for just about any retailers [url=http://www.thenorthfacemarket.com]buy the north face[/url]
customers to be in a position to store through the cell for an immediate invest in is starting to be much more and a lot more vital nowadays, mentioned Marci Troutman, CEO of Siteminis, Atlanta.
Buyers are checking their email by way of cell, ensuring the email advertisement lands them on the cell friendly-site for an immediate ROI exhibits the capability to hyperlink the e-mail campaign to a print ad, to a social media marketing piece, to signage and delivers the entire campaign full circle with a provable buy brought on by the chain reaction, she mentioned.
Marci Troutman is just not affiliated with the North Experience. She commented according to her expertise around the topic.
The North Confront, a division of VF Outdoor Inc., is an outdoor product firm specializing in outerwear, fleece, footwear and equipment including backpacks, tents and sleeping bags.
The clothing and equipment lines are catered in the direction of the wilderness chic, climbers, mountaineers, skiers, snowboarders, hikers and endurance athletes.
The corporation didn't reply to media inquiries soon enough for publication.
When consumers tap on the mobile advertisement they are redirected to some mobile-optimized page exactly where they are able to either obtain the closest shop, view their account or shop for winter season gear.
Consumers may also utilize the search purpose on the leading of the display if they may be on the lookout for a specific product.
arrangush 6:21am Dec 29, 2011 permalink | flag
I haven't seen you for weeks! forward: Oral Jelly suppliers Europe Kamagra tablets Kamagra kaufen jolly and - Buy Generic Kamagra and get a rock hard erection Kamagra Oral Jelly without health is Kamagra illegal UK Kamagra USA Mexico Canada Order Kamagra overnight shipping no prescription Super Kamagra Jelly Buy Buy Kamagra Online India classifieds Cheap Kamagra Buy c.o.d. Kamagra Online Kamagra Oral Jelly review four christmases Kamagra gel usa online Kamagra without a prescription Kamagra blister Kamagra 100mg new zealand kwick Kamagra Kamagra uses without prescription Buy Kamagra Oral Jelly get Kamagra in Toronto ... Goodbye! Kamagra kaufen ......http://eurovids.us - Hot porn new - go sex stories lesbians oral 69 and teens porn naughty pimp ..!!!
HenSmance 2:18pm Jan 1, 2012 permalink | flag
[url=http://www.uggelcorteingles.eu]ugg españa[/url]
Otra ventaja de con entre la adición de soporte de chat en vivo es, de hecho los todo da tu increÃble hora por que mejores Además que no a nuestro calor de la con un rebelde de los clientes.
,[url=http://www.uggelcorteingles.eu]botas ugg[/url]
¿Quieres con el fin de realmente desarrollar que se hábito de redes propias? Aquà 's las mejores maneras de a un fabuloso sana, basada, por iniciar para después de la creación de relaciones con Agradecimientos con el fin de realmente mejores clientes.
[url=http://www.uggelcorteingles.eu]botas ugg[/url]
 Algunos de los oscura muestra tu página de inicio su actual imagen sugestiva similar a mediante algunos murciélagos, pero lo que nos gustaba de particulares Página web siempre que los expertos del estado se ha convertido en no se considera relación en a que simplemente se puede ver.
http://www.botauggbaratas.com
GelmVacerer 2:25am Jan 2, 2012 permalink | flag
How are things?! interestingly you: super Kamagra Buy differemce between Kamagra and viagra and - Kamagra online doctors selling Kamagra online Kamagra store side affects of Kamagra where to Buy Kamagra store Cheap Generic Kamagra Kamagra Oral Jelly 100mg used prescription for Kamagra online pharmacy prescription medications Kamagra leveren Kamagra viagra Generic Kamagra mastercard Kamagra Oral Jelly without otc Kamagra side effects get Kamagra Online without a prescription Cheap Kamagra what kind of pill is this Order Oral Jelly Buy Kamagra no prescription Order Kamagra Canada delivery overnight Fedex Cheap order Kamagra under without RX ... Good-bye! Kamagra holland ......http://eurovids.us - Hot porn new - go sex toys in tampa fl and russian sex videos ..!!!
AbosqueAppabs 2:55pm Jan 2, 2012 permalink | flag
Your writing is very motivational and you really took command of the subject. This article is a must read. It was a pleasure to read this article I am look forward to your future articles. http://www.samsung1080phdtv.net/
samsung 1080p hdtv 11:26pm Jan 11, 2012 permalink | flag
Good morning! you look: purchase Kamagra without prescription Kamagra tablets Online 100mg and - Oral Jelly canada Online Kamagra Generic online Kamagra Buy online Kamagra au maroc next day delivery Kamagra no prescrption Cheap Generic Kamagra Online pharmacy impotence viagra 100mg Kamagra Oral Jelly online drug stores Kamagra UPS Kamagra Cheap ajanta Super Buy Kamagra in UK Kamagra shop Oral Kamagra stoke on trent Kamagra tablets in china Kamagra Oral Jelly Online Cheap Kamagra tablets Order Kamagra Online fast shipping Kamagra 100mg new zealand Kamagra tablets next day birth Buy Generic Kamagra purchase Online ... See you later! Kamagra Oral Jelly 100mg free shipping ......http://eurovids.us - Hot porn new - go amateur long porn videos and porn sex fuck ..!!! News! - Mobile Porn - free space tv porn apple or horse sex videos and porn apple ....
Lyncdyday 12:38pm Jan 12, 2012 permalink | flag
Dear Reader! call: long term affects of Kamagra Generic online Kamagra overnight and - Buy Kamagra Generic medicine Kamagra women Kamagra Oral Jelly for women find Cheap Kamagra delivered c.o.d. Fedex Kamagra leverans stockholm Oral Jelly australia Cheapest Kamagra lowest price for Kamagra Online no prescription online pharmacy Kamagra from Canada Cheap Kamagra for rent Kamagra by ajanta on line discount Kamagra prescription Kamagra kaufen no prescription Kamagra Online next day Kamagra tablets next day delivery Kamagra supplier viagra Kamagra Oral Jelly Online shop for shop for Kamagra UK Generic Kamagra overnight shipping Cheap ... Goodbye! Online purchase Kamagra delivered overnight ......http://eurovids.us - Hot porn new - go hacked passwords porn sites and free streaming porn viedo ..!!! News! - Hot Porn - free lesbien porn videos or lunch date comic porn ....
vowaffowbap 3:23pm Jan 12, 2012 permalink | flag
Dear Sirs! forward: Oral Jelly Order Kamagra tablets Kamagra Oral Jelly 100mg Buy sildenafil citrate and - Kamagra mg totalise UK Cheap Kamagra Oral Jelly UK no RX Kamagra online for Cheap Kamagra Oral Jelly review twilight Kamagra suppliers in stoke on trent Kamagra many orgasms Cheap Kamagra paypal UK pharmacy sale Kamagra overnight delivery 100mg usa Kamagra Oral Jelly Kamagra Oral Jelly 100mg offers Generic viagra online Kamagra Online Fedex overnight shipping new york Kamagra about viagra Buying Kamagra Soft Tabs Online Cheap Kamagra Online pharmacy Generic viagra Buy Cheap Kamagra what kind of pill is this Kamagra Oral Jelly 100mg get Generic viagra Online best Kamagra online no prescription Order Kamagra India ... Let's keep in touch! Cheap Generic Kamagra online pharmacy impotence ......http://eurovids.us - Hot porn new - go porn star stormy daniels and debble does dallas shower sense porn ..!!! News! - Hot Porn - x stream porn or amature next door home porn tgp ....
Hefeguevy 4:10am Jan 13, 2012 permalink | flag
Is it ... ?! present: is Kamagra illegal UK Kamagra Oral Jelly 100mg get Generic levitra and - is Kamagra legitimate Kamagra what is it tablets Buy Cheap Kamagra Kamagra 50p Generic Kamagra for sale prescription Kamagra c.o.d. overnight free Kamagra online Kamagra Oral Jelly usa super UK Kamagra Jelly Kamagra Indian fast delivery kgr Kamagra US pharmacies Kamagra Kamagra Oral Jelly suppliers UK sildenafil Online Kamagra no doctor prescription online pharmacy Kamagra delivered overnight Kamagra Oral Jelly review australia kgr 100 prescription Kamagra online Cheapest Kamagra 100 ... See you soon! Kamagra Oral Jelly movie reviews ......http://eurovids.us - Hot porn new - go wmv porn for windows 5 and spray porn rabbit review ..!!! News! - Hot Porn - free young porn solo or hot young porn ....
lealomegype 6:14am Jan 13, 2012 permalink | flag
We are glad to see you! forward: order Generic Kamagra India best price Kamagra deutschland and - Kamagra Oral Jelly 100mg visa no RX Kamagra Online no prescription Online pharmacy Kamagra no doctor prescription Kamagra Oral Jelly 100mg Europe sildenafil citrate Kamagra Jelly supplier Oral Jelly suppliers usa Kamagra online Buying Kamagra wholesale article Kamagra Kamagra Oral Jelly australia free shipping ajanta pharma Kamagra 100mg Online Cheap Generic viagra sell Kamagra Kamagra gell Buying online Kamagra overnight fed ex delivery Cheap Kamagra approval overnight mexican purchase Kamagra Oral Jelly for women Buy Kamagra pattaya thailand Kamagra direct Kamagra Oral Jelly 100mg no prescription ... Goodbye! Kamagra gel sildenafil citrate ......http://eurovids.us - Hot porn new - go porn puls and 100 free porn access ..!!! News! - Hot Porn - porn video staring blondie 1978-1980 or big ass free porn movie galleries ....
ignitlyMaibly 11:58pm Jan 13, 2012 permalink | flag
Good night! interestingly you: Order Kamagra overnight fed ex Buy Kamagra pound and - cialis and Kamagra together get Kamagra online pharmacy Kamagra with an online prescription no prescription order Kamagra online overnight Generic Kamagra UK Kamagra Oral Jelly suppliers usa rapid heartbeat Kamagra shop Cheap Kamagra tablets next day store Cheap Kamagra online prescription Kamagra erection Kamagra Oral Jelly 100mg Buy Kamagra Oral Jelly montreal how to get a Kamagra overnight fed ex Order Kamagra Online overnight delivery Cheap Kamagra in UK Kamagra pillen Oral Jelly suppliers usa Cheap Kamagra Generic Kamagra with money order ... Goodbye! overnight cash on delivery Kamagra Online without a prescription ......http://eurovids.us - Hot porn new - go christopher reid porn star spokane wa and internet usage statistics porn ..!!! News! - Hot Porn - belami porn or 0800 freepost porn ....
DutWeanyuncen 2:32am Jan 14, 2012 permalink | flag
Dear Sir or Madam! you look: Buying Generic Kamagra US Cheap Kamagra Online prescription and - Kamagra 100mg Online Kamagra Oral Jelly UK contains> Kamagra UK forzest Kamagra Oral Jelly 100mg UK ajanta pharma quick Kamagra no prescription Kamagra Oral Jelly Europe Generic medicines super Kamagra Jelly Buy Kamagra side effects in women Kamagra supplies Kamagra Oral Jelly review canada Cheap Buy Buy Kamagra online in UK purchase Generic Kamagra non prescription Kamagra achat Cheap Kamagra pills impotence viagra vs Kamagra Cheap Kamagra ajanta Kamagra 100mg safe take ajanta Kamagra pharmacy ... Good-bye! Cheap Generic Kamagra caverta zenegra ......http://eurovids.us - Hot porn new - go porn industry christians and taylor ware porn star ..!!! News! - Hot Porn - youngleaf porn gallery or porn story artists ....
DutWeanyuncen 4:21am Jan 14, 2012 permalink | flag
Good afternoon! forward: Kamagra Oral Jelly mastercard Kamagra Indian Online and - Kamagra homosex Kamagra apcalis UK Online pharmacy Cheap Kamagra Online stores find Kamagra for sale online Kamagra Australia Kamagra tablets review Buy online Kamagra Oral Jelly 100mg new york 100mg UK Buy Kamagra discount sale Kamagra online without prescription Order Kamagra free mail shipping Cheap Kamagra for discount order Generic Kamagra India best price doctor online Kamagra Buying online Kamagra Cheap overnight delivery Kamagra shop verkaufen where can i Buy Kamagra 100mg tadalafil Kamagra tablets Kamagra problems ... See you soon! Cheap Kamagra ajanta ......http://eurovids.us - Hot porn new - go coach bangs football player porn and coco porn star ..!!! News! - Hot Porn - russian granny porn free or cumfiesta porn trailers ....
enenidsinvero 12:14pm Jan 14, 2012 permalink | flag
Good afternoon! forward: prescription drugs Kamagra Online Order Kamagra delivered overnight and - get Kamagra non prescription tablets c.o.d. saturday Kamagra US online Kamagra 100mg sildenafil citrate ajanta pharma Kamagra Oral Jelly check online order Kamagra no prescription Kamagra diet pills Buy Kamagra the Kamagra viagra UK where can I Buy Kamagra overnight Cheap overnight Kamagra without a prescription Kamagra online doctors Kamagra 100mg sydney Super Kamagra UK ajanta pharma Cheap online Kamagra next day no prescription Kamagra for sale fast delivery Kamagra women Kamagra Oral Jelly 100mg without prescription sildenafil citrate Cheap Kamagra Canada ... Good-bye! About Kamagra Oral Jelly ......http://eurovids.us - Hot porn new - go porn star scope and porn newsgroup ..!!! News! - Hot Porn - the evil empire porn actresses or brianna banks porn ....
enenidsinvero 2:13pm Jan 14, 2012 permalink | flag
We are glad to see you! you look: Buying Kamagra Generic medicine viagra Kamagra cialis and - Kamagra Oral Jelly online consultation Buying Kamagra without prescription online pharmacy Buy Kamagra Generic medicine super Kamagra UK Kamagra 4x100 Buy Kamagra medication Online Kamagra Bulgaria Kamagra Oral Jelly suppliers australia ajanta pharma Indian importers of Kamagra Oral Jelly free shipping Buy Kamagra Cheap Generic Kamagra Online overnight drug Kamagra Buying online fast Kamagra Online fast shipping Order Kamagra Online fast delivery Kamagra for sale Online Kamagra India Kamagra no prescription express shipping site ebaycoUK Kamagra viagra sildenafil ... I'm looking forward to seeing you again! purchase Cheap Kamagra sales ......http://eurovids.us - Hot porn new - go back to the future porn and hosre porn ..!!! News! - Hot Porn - indiana porn or gay porn videos black cocks ....
Amurnnede 6:23am Jan 15, 2012 permalink | flag
Is it ... ?! it for you: Kamagra finland and - Kamagra Oral Jelly 100mg get Generic viagra online Kamagra ajanta pharma limited Buy c.o.d. Kamagra Online Kamagra wholesale Kamagra snd viagra canadian Kamagra rx Kamagra generique order Kamagra Cheapest online pharmacy Kamagra suppliers online UK only australia Online Buy Kamagra Oral Jelly price of Kamagra from Canada sildenafil citrate Kamagra 100mg tablets Kamagra Oral Jelly Order 100mg www Kamagra nl Kamagra 100mg university of kentucky Kamagra nachnahme Kamagra compare Buy viagra Kamagra ... I'm looking forward to seeing you again! Kamagra gell ......http://eurovids.us - Hot porn new - go cartoon porn kim possibe and sleep country porn ..!!! News! - Hot Porn - christy carlson romano porn or bizzare sex porn ....
GuattyBug 5:07am Jan 17, 2012 permalink | flag
Good morning! check: chewable Kamagra and - Cheap Kamagra Generic viagra Buy Online pharmacy Kamagra 100mg tadalafil Generic levitra Online purchase Cheap Kamagra overnight delivery Kamagra Online canadiain Kamagra deliver to UK Fed Ex overnight blue diamond Kamagra online drug stores Kamagra meds online best price for Kamagra Generic Kamagra questions Kamagra Jelly UK paypal Kamagra 100mg Oral Jelly products Cheap Kamagra in India Kamagra Oral review Jelly Online 100mg canada Kamagra tablets UK classifieds Cheap Generic viagra Kamagra us pharmacy selling Kamagra Oral Jelly review canada Kamagra soft tabs Kamagra online UK ... I'm looking forward to seeing you again! where to Buy Kamagra Generic Order ......http://eurovids.us - Hot porn new - go xxxfree porn and hardcore hotel porn ..!!! News! - Hot Porn - spy porn movie or dildo fucking porn ....
insitouff 1:30pm Jan 18, 2012 permalink | flag
What a pleasant suprise! forward: Buy Kamagra Online From The Best Overseas Pharmacy Store and - Buy c.o.d. Kamagra online now canadian drugs Kamagra how to get Kamagra fast Kamagra Oral Jelly UK genuine purchase Cheap Kamagra pay online check Buy Cheap Kamagra us Kamagra 100mg Oral Jelly India Generic Kamagra with money order Buy Kamagra Generic and boost your sexlife Oral Jelly review canada Buy Kamagra Kamagra Oral Jelly 100mg Buy ajanta pharma Canada Buy Kamagra online Kamagra Oral Jelly orange fed ex Cheap Kamagra pills impotence Cheapest Kamagra st ordering Kamagra with no prescription Cheap Kamagra Oral Jelly Generic viagra Online get a prescription for Kamagra ... Goodbye! Kamagra Oral Jelly free shipping sildenafil citrate ......http://eurovids.us - Hot porn new - go free gay porn greek and 3gp porn gallery ..!!! News! - Hot Porn - brutal online porn or heather interracial porn ....
insitouff 5:46pm Jan 18, 2012 permalink | flag
Good afternoon! forward: Kamagra information and - online pharmacy Kamagra Cheapest get a prescription for Kamagra Online US pharmacy Kamagra prices Kamagra jellies Generics Kamagra Jelly Cheapest Kamagra 100mg sildenafil citrate Generic viagra Kamagra Oral Jelly orange fed ex Kamagra UK erectalis Kamagra postal order no RX Kamagra Cheap next day online ordering Kamagra without a RX Kamagra Oral Jelly 100mg wholesale lowest price Kamagra costs US find Cheap Kamagra Online Buy Kamagra with next day delivery without prescription with free shipping Kamagra 100mg calgary Kamagra tablets next day shipping order Kamagra c.o.d. ... Good-bye! Kamagra Cheap viagra ......http://eurovids.us - Hot porn new - go madthumbs xxx porn and what porn sammy case was in ..!!! News! - Hot Porn - honey wilder porn star or native american porn star ....
insitouff 7:54pm Jan 18, 2012 permalink | flag
How are you doing?! call: Kamagra rx review and - no prescription needed for Kamagra Kamagra Oral Jelly australia sildenafil Kamagra Europe purchase Cheap Kamagra pay online check royal mail next day Kamagra pills Kamagra without a prescription no RX Kamagra online no prescription next day Kamagra UK Kamagra Oral Jelly 100mg order Kamagra 1000mg Cheap Kamagra for discount Kamagra Oral Jelly without prescription sildenafil Buy Cheap Generic Kamagra Buy Kamagra with next day delivery without prescription with free shipping super Kamagra inexpensive Buy Generic online Kamagra Cheap without prescription Kamagra Oral Jelly canada sildenafil citrate Cheapest prices for Kamagra free shipping ... See you later! Kamagra samples ......http://eurovids.us - Hot porn new - go porn sotogrande and free lesbin internet porn ..!!! News! - Hot Porn - you tube and porn or oma free porn ....
onefSmakemo 8:04am Jan 21, 2012 permalink | flag
How are you?! call: Kamagra ups delivery and - soft Kamagra Kamagra foam India Buy Cheap Kamagra overnight Fedex US pharmacies Kamagra Kamagra apcalis UK Online pharmacy Kamagra Generic shop kaufen Kamagra Oral Buy Kamagra Online without a prescription order Kamagra c.o.d. cora Kamagra kamagra silagra generic cialis where can I purchase Kamagra USA Kamagra for women Super Kamagra discount Kamagra UK equipment fast Kamagra Online fast shipping Buy Kamagra in London Kamagra UK Viagra ... With kind regards! Oral Jelly 100mg suppliers Kamagra pills ......http://eurovids.us - Hot porn new - go ipod porn rss channels and meredith murnane porn ..!!! News! - Hot Porn - zshare porn sohh or young girls free porn ....
Zenaciche 10:44am Jan 21, 2012 permalink | flag
Hello! call: Kamagra directly India blister and - Cheap Kamagra fast Buy Kamagra 100 mg jel Kamagra 100 delivery online overnight Kamagra order overnight shipping Viagra Kamagra UK Cheaper way to Buy Kamagra Kamagra 100mg pfiagara adresse Kamagra belgique Generic Kamagra meridia Kamagra Oral Jelly new york Kamagra Oral Jelly credit card Generic Kamagra for sale Cheap Generic overnight Kamagra online Cheap Cheap online UK Kamagra pills Kamagra Oral Jelly 100mg mastercard Buy Kamagra us dollar online US pharmacy Kamagra made in India Kamagra test ... See you soon! Kamagra online ......http://eurovids.us - Hot porn new - go top 10 lesbian porn and free porn search ..!!! News! - Hot Porn - mia moore porn star or panty fetish porn ....
Zenaciche 12:59pm Jan 21, 2012 permalink | flag
Dear Sir or Madam! call: Kamagra tablets Online 100mg and - Buy Generic Kamagra order Canada Generic Kamagra Oral Jelly review usa Buy Kamagra Kamagra tablets in us Cheap Kamagra prescriptions Kamagra dealers UK Buy now online Kamagra Kamagra Oral Jelly suppliers usa Kamagra Oral Jelly review UK ajanta pharma Kamagra shop net Oral Jelly canada online Kamagra Kamagra Oral Jelly 100mg Europe sildenafil citrate online Kamagra no prescription Kamagra tablets review 100mg UK online Kamagra tablets and Jelly gel mit Kamagra Kamagra Oral Jelly suppliers usa stockholm hotell Kamagra test results ... Good-bye! online consultant Generic Kamagra ......http://eurovids.us - Hot porn new - go jp porn and pussy streaching porn ..!!! News! - Hot Porn - read porn story or british porn channelx ....
diNamireser 1:32pm Jan 21, 2012 permalink | flag
Good night! present: Kamagra Oral Jelly review california and - Cheap online Kamagra pharmacy Buy how to Buy Kamagra now online 100mg tadalafil Kamagra tablets viagra Kamagra side effects Kamagra mail Order Cheap guide on taking Kamagra Kamagra lowest Online prices without prescription Kamagra shipping no prescription Kamagra Buying Online online ordering Kamagra without prescription online US pharmacy Kamagra online Cheap get a prescription for Kamagra Kamagra from usa Kamagra tabs Kamagra Oral Jelly Europe Generic medicines Super Kamagra Online bestellen order Kamagra online New Zealand Australia Kamagra supplier ... I'm looking forward to seeing you again! Cheap Kamagra softabs ......http://eurovids.us - Hot porn new - go republic of georgia porn stars and anatomia porn ..!!! News! - Hot Porn - porn movies with a story or cougar cash gay porn ....
viediankiny 7:08am Jan 25, 2012 permalink | flag
Join In.
Have something to say? By all means, speak up!
But first, a few rules:
Happy commenting!