Re: PHP Lead Developer Interview: Your suggestions please!
Posted: Wed Oct 15, 2008 8:37 pm
I should clarify that jaoudestudios's and Arjan's text based layout posts were also very helpful. All these bits helped create this conceptual layout in my head.
So here is my current MySQL export; I've seeded some data manually so when I regain consciousness in the morning I won't have much trouble kick-starting on implementing this.
Thoughts? Opinions? If nothing overly critical then I'll post a second zip file in the morning once I feel it's solid enough.
I feel very confident about this now. If I land this job I look forward to working in a professional environment where my learning will be accelerated by necessity and not just by my pure personal internal motivation.
Any way here is the MySQL export...I'm going to go ensure where I fall over is springy and covered with lots of cloth or cloth like material.
Again thanks to all of you for posting.
* Edit *: I thought I had the game_category table's id column set to auto-increment? Those shouldn't be all zeroes...I'll fix it in the morning when I reread my post and any new replies.
So here is my current MySQL export; I've seeded some data manually so when I regain consciousness in the morning I won't have much trouble kick-starting on implementing this.
Thoughts? Opinions? If nothing overly critical then I'll post a second zip file in the morning once I feel it's solid enough.
I feel very confident about this now. If I land this job I look forward to working in a professional environment where my learning will be accelerated by necessity and not just by my pure personal internal motivation.
Any way here is the MySQL export...I'm going to go ensure where I fall over is springy and covered with lots of cloth or cloth like material.
* Edit *: I thought I had the game_category table's id column set to auto-increment? Those shouldn't be all zeroes...I'll fix it in the morning when I reread my post and any new replies.
Code: Select all
-- phpMyAdmin SQL Dump-- version 2.11.6-- http://www.phpmyadmin.net---- Host: localhost-- Generation Time: Oct 15, 2008 at 09:29 PM-- Server version: 5.0.27-- PHP Version: 5.2.5 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; ---- Database: `gamer`-- -- -------------------------------------------------------- ---- Table structure for table `category`-- CREATE TABLE IF NOT EXISTS `category` ( `id` INT(10) NOT NULL AUTO_INCREMENT, `name` VARCHAR(128) NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=hp8 AUTO_INCREMENT=9 ; ---- Dumping data for table `category`-- INSERT INTO `category` (`id`, `name`) VALUES(1, 'Action'),(2, 'Adventure'),(3, 'Arcade'),(4, 'Family'),(5, 'Puzzle'),(6, 'RPG'),(7, 'Sports'),(8, 'Turned Based'); -- -------------------------------------------------------- ---- Table structure for table `games`-- CREATE TABLE IF NOT EXISTS `games` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(128) NOT NULL, `name_base` VARCHAR(128) NOT NULL, `author_name` VARCHAR(128) NOT NULL, `author_comments` VARCHAR(8192) NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=hp8 AUTO_INCREMENT=34 ; ---- Dumping data for table `games`-- INSERT INTO `games` (`id`, `name`, `name_base`, `author_name`, `author_comments`) VALUES(5, 'Football Fanatics 2009', 'football_fanatics_2009', 'John A. Bilicki III', 'A football game for couch potatoes!'),(3, 'Angry Gopher Golfers', 'angry_gopher_golfers', 'John A. Bilicki III', 'They''re gophers, they''re angry, and they''re out to tear the greens up!'),(4, 'Destroy All Humans', 'destroy_all_humans', 'John A. Bilicki III', 'Your goal is to steal the human''s money, DNA, and cattle!'),(2, 'Heroes of Might & Magic III', 'heroes_of_might_and_magic_iii', 'John A. Bilicki III', 'Turned based strategy at the height of sprite based graphics.'),(1, 'Diablo II', 'diablo_ii', 'John A. Bilicki III', 'Addictive though game play is a bit repetitive.'); -- -------------------------------------------------------- ---- Table structure for table `game_category`-- CREATE TABLE IF NOT EXISTS `game_category` ( `id` INT(10) NOT NULL, `category_id` VARCHAR(128) NOT NULL, `game_id` VARCHAR(128) NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=hp8; ---- Dumping data for table `game_category`-- INSERT INTO `game_category` (`id`, `category_id`, `game_id`) VALUES(0, '7', '5'),(0, '7', '3'),(0, '2', '3'),(0, '1', '4'),(0, '2', '4'),(0, '5', '4'),(0, '2', '2'),(0, '8', '2'),(0, '6', '1'),(0, '2', '1'),(0, '1', '1');