text:
CREATE DATABASE  IF NOT EXISTS `autotrader_v_0_0_1` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `autotrader_v_0_0_1`;
-- MySQL dump 10.13  Distrib 5.5.49, for debian-linux-gnu (x86_64)
--
-- Host: 127.0.0.1    Database: autotrader_v_0_0_1
-- ------------------------------------------------------
-- Server version	5.5.49-0ubuntu0.14.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `address_type`
--

DROP TABLE IF EXISTS `address_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `address_type` (
  `address_type_id` int(11) NOT NULL AUTO_INCREMENT,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`address_type_id`),
  UNIQUE KEY `address_type_id_UNIQUE` (`address_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `address_type`
--

LOCK TABLES `address_type` WRITE;
/*!40000 ALTER TABLE `address_type` DISABLE KEYS */;
/*!40000 ALTER TABLE `address_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `address_type_definition`
--

DROP TABLE IF EXISTS `address_type_definition`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `address_type_definition` (
  `address_type_definition_id` int(11) NOT NULL AUTO_INCREMENT,
  `address_type_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `address_name` varchar(55) NOT NULL,
  `address_description` varchar(255) NOT NULL,
  PRIMARY KEY (`address_type_definition_id`),
  UNIQUE KEY `address_type_definition_id_UNIQUE` (`address_type_definition_id`),
  KEY `fk_address_type_definition_1_idx` (`address_type_id`),
  CONSTRAINT `fk_address_type_definition_1` FOREIGN KEY (`address_type_id`) REFERENCES `address_type` (`address_type_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `address_type_definition`
--

LOCK TABLES `address_type_definition` WRITE;
/*!40000 ALTER TABLE `address_type_definition` DISABLE KEYS */;
/*!40000 ALTER TABLE `address_type_definition` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `addresses`
--

DROP TABLE IF EXISTS `addresses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `addresses` (
  `address_id` int(11) NOT NULL AUTO_INCREMENT,
  `address_line_1` varchar(145) NOT NULL,
  `address_line_2` varchar(145) DEFAULT NULL,
  `address_line_3` varchar(145) DEFAULT NULL,
  `postcode` varchar(45) NOT NULL,
  `town` varchar(145) NOT NULL,
  `county` varchar(145) NOT NULL,
  `county_code` varchar(3) NOT NULL,
  PRIMARY KEY (`address_id`),
  UNIQUE KEY `addresse_id_UNIQUE` (`address_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `addresses`
--

LOCK TABLES `addresses` WRITE;
/*!40000 ALTER TABLE `addresses` DISABLE KEYS */;
/*!40000 ALTER TABLE `addresses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `country_list`
--

DROP TABLE IF EXISTS `country_list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `country_list` (
  `country_list_id` int(11) NOT NULL AUTO_INCREMENT,
  `alpha-2_code` varchar(2) NOT NULL,
  `alpha-3_code` varchar(3) NOT NULL,
  `numeric_code` int(5) NOT NULL,
  `locale` varchar(10) NOT NULL,
  PRIMARY KEY (`country_list_id`),
  UNIQUE KEY `alpha-2_code_UNIQUE` (`alpha-2_code`),
  UNIQUE KEY `alpha-3_code_UNIQUE` (`alpha-3_code`),
  UNIQUE KEY `numeric_code_UNIQUE` (`numeric_code`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `country_list`
--

LOCK TABLES `country_list` WRITE;
/*!40000 ALTER TABLE `country_list` DISABLE KEYS */;
INSERT INTO `country_list` VALUES (1,'SK','SVK',703,''),(2,'GB','GBR',826,'');
/*!40000 ALTER TABLE `country_list` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `country_list_definition`
--

DROP TABLE IF EXISTS `country_list_definition`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `country_list_definition` (
  `country_list_definition_id` int(11) NOT NULL AUTO_INCREMENT,
  `country_list_id` int(11) NOT NULL,
  `language_code` varchar(2) NOT NULL,
  `native_name` varchar(145) NOT NULL,
  PRIMARY KEY (`country_list_definition_id`),
  KEY `fk_country_list_definition_1_idx` (`country_list_id`),
  KEY `fk_country_list_definition_2_idx` (`language_code`),
  CONSTRAINT `fk_country_list_definition_1` FOREIGN KEY (`country_list_id`) REFERENCES `country_list` (`country_list_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_country_list_definition_2` FOREIGN KEY (`language_code`) REFERENCES `language_list` (`639-1`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `country_list_definition`
--

LOCK TABLES `country_list_definition` WRITE;
/*!40000 ALTER TABLE `country_list_definition` DISABLE KEYS */;
INSERT INTO `country_list_definition` VALUES (1,1,'en','Slovakia'),(2,1,'sk','Slovensko'),(3,1,'ar','سلوفاكيا'),(4,2,'en','United Kingdom'),(5,2,'sk','Spojene kralovstvo'),(6,2,'ar','المملكة المتحدة');
/*!40000 ALTER TABLE `country_list_definition` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `language_list`
--

DROP TABLE IF EXISTS `language_list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `language_list` (
  `language_list_id` int(11) NOT NULL AUTO_INCREMENT,
  `language family` varchar(75) NOT NULL,
  `language_name` varchar(45) NOT NULL,
  `native_name` varchar(150) NOT NULL,
  `639-1` varchar(2) NOT NULL,
  `639-2/T` varchar(3) NOT NULL,
  `639-2/B` varchar(3) NOT NULL,
  PRIMARY KEY (`language_list_id`),
  UNIQUE KEY `639-1_UNIQUE` (`639-1`),
  UNIQUE KEY `639-2/T_UNIQUE` (`639-2/T`),
  UNIQUE KEY `639-2/B_UNIQUE` (`639-2/B`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `language_list`
--

LOCK TABLES `language_list` WRITE;
/*!40000 ALTER TABLE `language_list` DISABLE KEYS */;
INSERT INTO `language_list` VALUES (1,'Afro-Asiatic','Arabic','العربية','ar','ara','ara'),(2,'Indo-European','English','English','en','eng','eng'),(3,'Indo-European','Slovak','slovenčina, slovenský jazyk','sk','slk','slo');
/*!40000 ALTER TABLE `language_list` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `status`
--

DROP TABLE IF EXISTS `status`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `status` (
  `status_id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `status_created` datetime NOT NULL,
  `status_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`status_id`),
  UNIQUE KEY `status_id_UNIQUE` (`status_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `status`
--

LOCK TABLES `status` WRITE;
/*!40000 ALTER TABLE `status` DISABLE KEYS */;
INSERT INTO `status` VALUES (1,'2016-06-02 14:00:00','2016-06-02 12:24:40'),(2,'2016-06-10 11:12:20','2016-06-10 09:12:20'),(3,'2016-06-10 11:14:44','2016-06-10 09:14:44'),(9,'2016-06-10 11:46:17','2016-06-10 09:46:17');
/*!40000 ALTER TABLE `status` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `status_definition`
--

DROP TABLE IF EXISTS `status_definition`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `status_definition` (
  `status_definition_id` int(11) NOT NULL AUTO_INCREMENT,
  `status_id` tinyint(4) NOT NULL,
  `language_code` varchar(2) NOT NULL,
  `status_name` varchar(45) NOT NULL,
  `status_description` varchar(255) NOT NULL,
  `status_definition_created` datetime NOT NULL,
  `status_definition_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`status_definition_id`),
  UNIQUE KEY `status_definition_id_UNIQUE` (`status_definition_id`),
  KEY `fk_status_definition_1_idx` (`status_id`),
  KEY `fk_status_definition_2_idx` (`language_code`),
  CONSTRAINT `fk_status_definition_1` FOREIGN KEY (`status_id`) REFERENCES `status` (`status_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_status_definition_2` FOREIGN KEY (`language_code`) REFERENCES `language_list` (`639-1`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `status_definition`
--

LOCK TABLES `status_definition` WRITE;
/*!40000 ALTER TABLE `status_definition` DISABLE KEYS */;
INSERT INTO `status_definition` VALUES (1,1,'en','ACTIVE','Status of the record in database','2016-06-02 14:00:00','2016-06-03 15:38:40'),(2,1,'sk','AKTíVNY','Stav záznamu v databáze','2016-06-02 14:00:00','2016-06-03 15:38:10'),(3,1,'ar','فعال','وضع السجل في قاعدة البيانات','2016-06-02 14:00:00','2016-06-03 15:37:09'),(9,2,'en','INACTIVE','Status of the record in database','2016-06-10 11:46:17','2016-06-10 09:48:36');
/*!40000 ALTER TABLE `status_definition` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `default_language_id` int(11) NOT NULL,
  `user_account_id` int(11) NOT NULL,
  `user_type_id` int(11) NOT NULL,
  `status_id` tinyint(4) NOT NULL,
  `f_name` varchar(45) NOT NULL,
  `s_name` varchar(45) NOT NULL,
  `email_address` varchar(75) NOT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `user_id_UNIQUE` (`user_id`),
  KEY `fk_users_1_idx` (`user_account_id`),
  KEY `fk_users_2_idx` (`user_type_id`),
  KEY `fk_users_3_idx` (`status_id`),
  CONSTRAINT `fk_users_1` FOREIGN KEY (`user_account_id`) REFERENCES `users_accounts` (`user_account_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_users_2` FOREIGN KEY (`user_type_id`) REFERENCES `users_types` (`user_type_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_users_3` FOREIGN KEY (`status_id`) REFERENCES `status` (`status_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users_accounts`
--

DROP TABLE IF EXISTS `users_accounts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_accounts` (
  `user_account_id` int(11) NOT NULL AUTO_INCREMENT,
  `status_id` tinyint(4) NOT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`user_account_id`),
  UNIQUE KEY `user_account_id_UNIQUE` (`user_account_id`),
  KEY `fk_users_accounts_1_idx` (`status_id`),
  CONSTRAINT `fk_users_accounts_1` FOREIGN KEY (`status_id`) REFERENCES `status` (`status_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users_accounts`
--

LOCK TABLES `users_accounts` WRITE;
/*!40000 ALTER TABLE `users_accounts` DISABLE KEYS */;
/*!40000 ALTER TABLE `users_accounts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users_accounts_definitions`
--

DROP TABLE IF EXISTS `users_accounts_definitions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_accounts_definitions` (
  `users_accounts_definitions_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_account_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `status_id` tinyint(4) NOT NULL,
  `account_name` varchar(55) NOT NULL,
  `account description` varchar(255) NOT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`users_accounts_definitions_id`),
  UNIQUE KEY `users_accounts_definitions_id_UNIQUE` (`users_accounts_definitions_id`),
  KEY `fk_users_accounts_definitions_1_idx` (`user_account_id`),
  KEY `fk_users_accounts_definitions_2_idx` (`status_id`),
  CONSTRAINT `fk_users_accounts_definitions_1` FOREIGN KEY (`user_account_id`) REFERENCES `users_accounts` (`user_account_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_users_accounts_definitions_2` FOREIGN KEY (`status_id`) REFERENCES `status` (`status_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users_accounts_definitions`
--

LOCK TABLES `users_accounts_definitions` WRITE;
/*!40000 ALTER TABLE `users_accounts_definitions` DISABLE KEYS */;
/*!40000 ALTER TABLE `users_accounts_definitions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users_r_addresses`
--

DROP TABLE IF EXISTS `users_r_addresses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_r_addresses` (
  `user_r_addresse_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `address_id` int(11) NOT NULL,
  `status_id` tinyint(4) NOT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`user_r_addresse_id`),
  UNIQUE KEY `user_r_addresse_id_UNIQUE` (`user_r_addresse_id`),
  KEY `fk_users_r_addresses_1_idx` (`user_id`),
  KEY `fk_users_r_addresses_2_idx` (`address_id`),
  KEY `fk_users_r_addresses_3_idx` (`status_id`),
  CONSTRAINT `fk_users_r_addresses_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_users_r_addresses_2` FOREIGN KEY (`address_id`) REFERENCES `addresses` (`address_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_users_r_addresses_3` FOREIGN KEY (`status_id`) REFERENCES `status` (`status_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users_r_addresses`
--

LOCK TABLES `users_r_addresses` WRITE;
/*!40000 ALTER TABLE `users_r_addresses` DISABLE KEYS */;
/*!40000 ALTER TABLE `users_r_addresses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users_types`
--

DROP TABLE IF EXISTS `users_types`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_types` (
  `user_type_id` int(11) NOT NULL AUTO_INCREMENT,
  `status_id` tinyint(4) NOT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`user_type_id`),
  UNIQUE KEY `users_types_id_UNIQUE` (`user_type_id`),
  KEY `fk_users_types_1_idx` (`status_id`),
  CONSTRAINT `fk_users_types_1` FOREIGN KEY (`status_id`) REFERENCES `status` (`status_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users_types`
--

LOCK TABLES `users_types` WRITE;
/*!40000 ALTER TABLE `users_types` DISABLE KEYS */;
/*!40000 ALTER TABLE `users_types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users_types_definitions`
--

DROP TABLE IF EXISTS `users_types_definitions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_types_definitions` (
  `users_types_definitions_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_type_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `status_id` tinyint(4) NOT NULL,
  `type_name` varchar(55) NOT NULL,
  `type_description` varchar(255) NOT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`users_types_definitions_id`),
  UNIQUE KEY `users_types_definitions_id_UNIQUE` (`users_types_definitions_id`),
  KEY `fk_users_types_definitions_1_idx` (`user_type_id`),
  KEY `fk_users_types_definitions_2_idx` (`status_id`),
  CONSTRAINT `fk_users_types_definitions_1` FOREIGN KEY (`user_type_id`) REFERENCES `users_types` (`user_type_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_users_types_definitions_2` FOREIGN KEY (`status_id`) REFERENCES `status` (`status_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users_types_definitions`
--

LOCK TABLES `users_types_definitions` WRITE;
/*!40000 ALTER TABLE `users_types_definitions` DISABLE KEYS */;
/*!40000 ALTER TABLE `users_types_definitions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'autotrader_v_0_0_1'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2016-06-14 10:17:52


Hi, It's been a while since I last did any sort of CFD simulations. I was wondering if it was possible to simulate draining water from an IBC container into open air to look at how the flow changes throughout the drain cycle, producing a time vs volume remaining in the tank for validation agaist real world tests. Any help is appriciated.
Ah. I know my university has access to ANSYS packages, do you know if such simulations are possible on this?


text:
Q: How to merge a list of dataframes by a single column? I have a list of dataframes, each of which has a "Name" column and a "Sample" column.
df1:

Name Sample1
A 23
B 445
C 456

df2:

Name Sample2
A 45
B 984
C 374

How can I merge all the dataframes in my list so they end up like so:
merged:

Name Sample1 Sample2
A 23 45
B 445 984
C 456 374

I have tried answers from similar questions on SO but none of them have produced the desired result. E.g. merged.data.frame = Reduce(function(...) merge(..., all=T), list.of.data.frames)
Edit:
My original script is listed below
# List all files in current working directory
fs <- list.files()

# Load the data from each file into a list of data frames
dfs <- lapply(fs, read.table, header=TRUE, sep="\t")

# Select only the Name and Concentration columns from the list of data frames
dfs <- lapply(dfs, subset, select=c(Name, Concentration))

# Sort each dataframe alphabetically by the Name column
dfs <- lapply(dfs, function(df){df[order(df$Name),]})

# Rename each Concentration heading with the basename of the filename where the data originates
for (i in 1:length(dfs)){colnames(dfs[[i]])[2] <- substr(fs[i], 1, nchar(fs[i]) - 4)}

# Merge all the dataframes together by the Name column

# Write merged dataframe out to a tab-delimited file
write.table(dfs, ".", sep="\t")

A: It should work (as follows):
dats <- list(df1=data.frame(Name=c("A", "B", "C"), Sample1=c(23, 445, 456), stringsAsFactors=FALSE),
             df2=data.frame(Name=c("A", "B", "C"), Sample2=c(45, 984, 374), stringsAsFactors=FALSE),
             df3=data.frame(Name=c("A", "B", "C"), Sample3=c(66, 111, 2), stringsAsFactors=FALSE))

dats

## $df1
##   Name Sample1
## 1    A      23
## 2    B     445
## 3    C     456
##
## $df2
##   Name Sample2
## 1    A      45
## 2    B     984
## 3    C     374
##
## $df3
##   Name Sample3
## 1    A      66
## 2    B     111
## 3    C       2

# with by="Name"
merged.data.frame <- Reduce(function(...) merge(..., by="Name", all=TRUE), dats)

merged.data.frame

##   Name Sample1 Sample2 Sample3
## 1    A      23      45      66
## 2    B     445     984     111
## 3    C     456     374       2

# without by="Name" (same result)
merged.data.frame <- Reduce(function(...) merge(..., all=TRUE), dats)

##   Name Sample1 Sample2 Sample3
## 1    A      23      45      66
## 2    B     445     984     111
## 3    C     456     374       2

A: It works for me. Is this an accurate reproduction of the problem you are trying to solve?
> X <- replicate(20, data.frame(name=letters, r=runif(26)), simplify=FALSE)
> for(i in 1:20) names(X[[i]])[2] <- paste0("Sample", i)
> M <- Reduce(function(x,y)merge(x,y,by="name"), X)
> str(M)
'data.frame':   26 obs. of  21 variables:
 $ name    : Factor w/ 26 levels "a","b","c","d",..: 1 2 3 4 5 6 7 8 9 10 ...
 $ Sample1 : num  0.17 0.957 0.443 0.181 0.113 ...
 $ Sample2 : num  0.8983 0.1802 0.7817 0.0818 0.7741 ...
 $ Sample3 : num  0.7473 0.6888 0.0195 0.9815 0.9674 ...
 $ Sample4 : num  0.557 0.331 0.902 0.177 0.504 ...
 $ Sample5 : num  0.0784 0.1561 0.5524 0.2631 0.2082 ...
 $ Sample6 : num  0.7455 0.5604 0.7232 0.5651 0.0727 ...
 $ Sample7 : num  0.721 0.807 0.902 0.965 0.41 ...
 $ Sample8 : num  0.209 0.17 0.207 0.303 0.258 ...
 $ Sample9 : num  0.736 0.566 0.125 0.417 0.521 ...
 $ Sample10: num  0.639 0.778 0.499 0.57 0.934 ...
 $ Sample11: num  0.0104 0.1629 0.4513 0.4821 0.383 ...
 $ Sample12: num  0.20123 0.95563 0.39992 0.00256 0.69283 ...
 $ Sample13: num  0.466 0.735 0.857 0.695 0.673 ...
 $ Sample14: num  0.562 0.873 0.269 0.151 0.628 ...
 $ Sample15: num  0.809 0.75 0.414 0.644 0.953 ...
 $ Sample16: num  0.7729 0.0129 0.5654 0.5705 0.7514 ...
 $ Sample17: num  0.239 0.454 0.538 0.596 0.743 ...
 $ Sample18: num  0.29 0.1 0.806 0.66 0.668 ...
 $ Sample19: num  0.461 0.739 0.474 0.64 0.418 ...
 $ Sample20: num  0.631 0.369 0.913 0.655 0.641 ...

redpajama_set_name: RedPajamaStackExchange


text:
Luke Paul Hoare Shaw (n. 12 iulie 1995) este un fotbalist englez care joacă pentru Manchester United și echipa națională de fotbal a Angliei pe postul de fundaș stânga.

Note

Legături externe

Profilul lui Rickie Lambert pe site-ul clubului Liverpool F.C.

Nașteri în 1995
Fotbaliști englezi
Fotbaliști internaționali englezi
Fotbaliști ai Premier League
Fotbaliști ai Campionatului Mondial de Fotbal 2014
Oameni în viață
Fotbaliști ai Manchester United FC

redpajama_set_name: RedPajamaWikipedia


The Lewisville Science Fiction Book Group will meet Friday March 8, 2013 to discuss John Scalzi's RED SHIRTS. As they do every second Friday of the month, they will meet at 7:30 PM at the IHOP in Lewisville, located at 2345 S Stemmons Fwy.
I haven't had a chance to attend in over a year, but I will do my best to be there this Friday. So, as I type this, I listen to Wil Wheaton read RED SHIRTS and I have to say that I'm enjoying it. I hope to see some of you there, because even though you may not have read this or finished it, you are still welcome to and sit with us.
What are you reading (or listening) right now?


eat, and how much to eat helps you adjust or control how your body responds to the consumption of food.
Whole Foods are a critical element in diabetic (and overall human) nutrition.
the environment in order to grow, reproduce and survive.
• Oxygen - We breathe air to acquire oxygen our cells need to survive.
• Water - We drink water to replenish vital supplies of liquid.
• Food - We eat various whole foods to provide us with energy sources.
• Clothes - Needed for protection of the body.
• Shelter - A place to raise our young.
• Love - Everyone needs Love.
of simpler living begins with being able to sort values, what matters and what doesn't.
creation of the foundations of the world and mankind.
health, happiness, and well-being. Learn how to sort values, what matters and what doesn't.
mind, body, soul, attitudes, and emotions.
By returning to the basics - simpler living can be achieved.
Come .... You will learn how to feed the body and the soul!


text:
Q: Running Laravel project on XAMPP:" NotFoundHttpException in RouteCollection.php line 179" I'm using XAMPP to run my Laravel project, and it runs on "localhost/myproject/public" but when I click on the login link I get this error:

NotFoundHttpException
  in RouteCollection.php line 179

But the strange thing is that, when I run the project on my Windows CMD using "php artisan serve" and then go to my browser and type "http://127.0.0.1:8000" my project works fully and I don't get any error.
What am I doing wrong with XAMPP? How can I get to run my project properly using XAMPP?
Thanks in advance :)


text:
Q: How can I add a css property to the first div with a specific class name? I'm trying to add a bottom margin to the first
 with a class "unit".

...

...
 //add margin-bottom to this one!!!!

...

...

#wrapper-related-albums .unit:first-child {margin-bottom:20px;} // doesn't work!!!
#wrapper-related-albums .unit:first-of-type {margin-bottom:20px;} // doesn't work!!!

A: More General/Flexible Solution
Wesley's answer serves well for your particular html markup, as it assumes the .unit is going to be the second element in the listing. So in your case, that may be so, and his solution works well. However, if someone were seeking a more general solution the following is what should be done:
#wrapper-related-albums .unit {
    /* code for the first one */
    margin-bottom: 20px;
}
#wrapper-related-albums .unit ~ .unit {
    /* code for all the following ones */
    margin-bottom: 0px;
}

Using the general sibling selector (~) like this will override all but the first .unit, allowing the first .unit to be anywhere in the wrapper (not just in position #2, and the position need not be known in advance). Here's a fiddle that illustrates it using a color change.

A: There's a few options, depending on your markup:
Second child with class unit:
#wrapper-related-albums .unit:nth-of-type(2) { }
#wrapper-related-albums .unit:nth-child(2) { }

Adjacent sibling (with class unit) of the first element:
#wrapper-related-albums :first-child + .unit {  }

I don't believe there's any way to simply select "the first .unit", but you can add the margin to all except the last one, if it always falls last:
#wrapper-related-albums .unit { margin-bottom: 20px; }

/* negate the above rule */
#wrapper-related-albums .unit:last-child { margin-bottom: 0px; }


Riley the mouse, Starla the badger and Horatio the hedgehog are the best of friends. Together they're ready for anything – almost! But when they decide to camp out in Riley's garden, they don't realise there will be so many scary noises. Who's afraid of the dark? A second funny and charming tale from the flower-filled meadows and dales of Willow Valley.


text:
Die Liste der Baudenkmale in Salzgitter enthält Listen von Baudenkmalen in den sieben Ortschaften der  niedersächsischen Stadt Salzgitter. Die Einträge in den Listen basieren auf dem Denkmalatlas Niedersachsen.

Listen nach Ortschaften:

 Liste der Baudenkmale in der Ortschaft Nord
 Liste der Baudenkmale in der Ortschaft Nordost
 Liste der Baudenkmale in der Ortschaft Nordwest
 Liste der Baudenkmale in der Ortschaft Ost
 Liste der Baudenkmale in der Ortschaft Süd (ohne Salzgitter-Bad) und Liste der Baudenkmale in Salzgitter-Bad
 Liste der Baudenkmale in der Ortschaft Südost
 Liste der Baudenkmale in der Ortschaft West

Weblinks

Salzgitter
!
Baudenkmale in Salzgitter


text:
CFB 24/7
Panthers sign Shaq Thompson to 4-year, $54.2M deal
By Grant Gordon NFL.com
Published: Dec. 7, 2019 at 01:47 p.m.
Updated: Dec. 8, 2019 at 08:59 a.m.
Friend(s) Email Your Email
More Columns >
These are some uncertain times in Carolina, but the Panthers have left no doubt that linebacker Shaq Thompson is a big part of the franchise's future.
The team announced on Saturday that Thompson signed a four-year contract extension. The deal is for four years, a $54.2 million extension with a max value of $57 million, NFL Network Insider Ian Rapoport reported per a source. Rapoport added the deal includes a $16 million signing bonus and $28 million guaranteed.
"Shaq is our type of person and our type of player," general manager Marty Hurney said in a statement to the team website. "He's proven that he can play linebacker at a very high level, and he's got all the traits you want. He's smart, he's physical, he can run and he's very versatile. He fits the blueprint for what we want at the position."
A 2015 first-round pick, Thompson was playing under a fifth-year option during a career season.
Thus far, he's tallied a career-high 93 tackles and the 25 year old has added three sacks and three passes defended for a young and promising Panthers defense.
Carolina is 5-7 and plays the host Falcons (3-9) on Sunday.
"Adams: Pack have 'better way to attack' 49ers..."
Jason Garrett agrees to become New York Giants OC
Connor Barwin joins Eagles as special assistant to GM
NFL injury report for Championship Games
Chiefs DT Chris Jones (calf) questionable vs. Titans
Titans-Chiefs: AFC Championship Game preview
Harbaugh: Ravens' goal is to re-sign Matthew Judon
Roundup: Jags interview Ben McAdoo for OC job
Burrow's father says QB would be happy with Bengals
Davante Adams: Pack have 'better' plan for rematch
Top moments of the decade
Here's a look at the best moments from the past decade in the NFL. View

redpajama_set_name: RedPajamaCommonCrawl


Schoology is the school's Virtual Learning Environment. Students and teachers use Schoology to share information and resources as well as to submit work for assessment.
Parent accounts on Schoology allow parents to view their child's learning activity as well as to track homework and assignments.
To login to Schoology Click Here.
For information on how to create a Parent Account using your Parent Access Code, Click Here.
If you do not know the Parent Access Code for your child, contact their Caomhnóir for assistance.


Once you've created a Sales Campaign you can start setting up the products you plan to sell.
You can do this from within the sales campaign by clicking on the Items For Sale tab.
Or you can maintain items for sale in all sales campaigns by selecting Merchandise Items from the Maintain Sales Campaigns submenu on the Sales menu.
When you first create a Sale Campaign, this list will be empty.
If you selected a National Sales Campaign on the Campaign Details tab, you will see a link to that campaign at the top of the page. This link will allow you to view the merchandise descriptions that we have prepared for this campaign.
The Add Merchandise From National Campaign button will copy those items into this sales campaign. You will then be able to update the descriptions as needed.
Of course, you can also click Add a New Item to manually add a new item to offer for sale in this campaign.
The Item Name will be displayed on the order form. It should match the name on your paper order form, if you have one for this campaign.
The Description will only appear if the user clicks on a link when on the order form; this will display a page describing this item, which includes the lengthier description. This can contain HTML tags for formatting.
The Photo is optional, but highly recommended. A small "thumbnail" image will be displayed on the scout's order form and the public order form.
The Display Sequence Number determines the order in which this item will be displayed on the order form, relative to the other items for this campaign. Items with a lower number will be displayed before items with a higher number.
Click the Donation Only box for those items which do not require delivery of a physical product. These items will be excluded from some reports that are used to manage the delivery process.
The Price Per Unit is the amount you plan to charge for one of these items.
The Quantity Required For Discount is optional. If you enter it, the system will apply the Discount Percent to orders for this item when at least this many units have been ordered.
The Discount Percent is the percentage discount that will be computed on orders for this item if the quantity ordered exceeds the Quantity Required For Discount. It should be entered as a whole number between 0 and 100.
The Wholesale Cost Per Unit is optional. It will allow you to produce the Profit By Scout report that shows the gross profit produced by each scout's sales.
Click Save & Exit to save your work, or Save and Add Another to add the next item to this campaign.
When you've entered all of the items for this campaign, you can proceed to setting up the prizes for achieving certain sales levels, as shown on the next page.


text:
ECB Board Member Admits Central Bank's Monetary Policy Risks "Tearing Up Social Fabric"
By David Stockman. Posted On Tuesday, September 27th, 2016
Time to toss yet another "conspiracy theory" on the composite heap of "theories that became fact." A recurring theme we have pounded the table on over the past nearly 8 years is that central bank policy has been the primary driver leading to not only a record wealth and income divide, but to such manifestations of populist (and nationalist) fury as Brexit, the gradual collapse of the Eurozone and, of course, Trump.
Moments ago, ECB board member Benoit Coeure, speaking in Rome, said that "low forever" rates would risk tearing up the social fabric. Translated: if extended indefinitely, the ECB's monetary policy risks the collapse of not only the Eurozone, but also could lead to social unrest, violence and even civil war.
Quoted by Bloomberg, Coeure said that "moving from interest rates being 'low for long' to being 'low forever' would severely limit the room for maneuver for conventional monetary policy tools, but even more worryingly, it would threaten the contract between generations as well as risk tearing up our social fabric." Which is a more polite phrasing of what we have said all along: that it is central banks themselves, and their idiotic policies that have led the world to the current unstable state, when mass shootings and/or terrorist activity has become an almost daily event.
Couere then adds that "if fiscal and economic policies do not in fact play this role, we risk being trapped in a low growth, low interest rate equilibrium." What Couere does not say is that it is the ECB's policies - again - which enable governments to avoid engaging in politically costly and potentially career-ending structural reforms, if not so much "fiscal policies", which ultimately are nothing more than issuing more debt, something which the status quo delights in, yet which merely kicks the can just down the street.
The unexpected bashing of national governments continues, when Coeure said they "need to live up to this responsibility: economic and fiscal policies need to be used more decisively so as to reduce structural unemployment and boost potential output growth in the euro area." He concluded that the EU finds itself in a "difficult phase," needs a "clear and consistent path of integration to avoid half-built houses." Or insolvent banks with trillions of derivatives on their books?
And in the pinnacle of irony, as Coeure was warning listeners about the potentially deadly risks of the ECB's ruinous monetary policy continuing far too long, at the same time Mario Draghi was addressing European lawmakers where among many other things, he admitted that he is fully aware that "low rates "penalize" savers, but they also benefit "whoever borrows money" and the latter effect "more than offsets" the former.
Hear that savers: the frout of your many years of labor may generate no income (or may be even negative in some cases) but your sacrifice is a noble one: it is for the greater good, especially as it benefits those who live beyond their means and - of course - those market speculators who just have to "BTFD."
Pressed on this issue, Draghi said that it's not just the ECB's fault but also the economy: "we have to accept the fact" that low interest rates are "a symptom of low growth" and not a pure creation of central banks.
The otherwise glib ECB head, however, had nothing to say about Deutsche Bank: he has refused to comment on Europe's largest bank crashing to all time lows.
Source: ECB Board Member Admits Central Bank's Monetary Policy Risks "Tearing Up Social Fabric"


Edit on Nov 8, 2012: Guess what showed up at the US App Store today? (Haven't managed to find it at the Canadian one yet.) The direct link's in the caption under the screenshot.
If this is too long a read, just go to the product page at http://itunes.apple.com/jp/app/puzzle-dragons/id493470467?l=en&mt=8 and oggle at the cuteness! But the real incentive to check it out is the totally machine-translated Engrish description!
Those 3 critters may be cute and happy but they are totally out to murder your little band of monsters.
I downloaded this semi-social, cute puzzle/monster collecting freemium game on a whim after purchasing Epic Astro Story from the Japanese App Store. Unfortunately, I don't believe the game is available outside of Japan.
Developed and published by GungHo Online Entertainment, it's a dungeon crawler kind of like those old school, first person turn-based RPGs. In Puzzle & Dragons, you "control" a party of 5 monsters. Well, there's six in the screenshot above since you can always bring a guest along with you! These monster guests are courtesy of other players but I'll get more into that a bit later.
Puzzle & Dragons is super simple to figure out! Just match up rows or columns of the same type of coloured orbs/elements based on fire, water, air, light, and darkness. The minimum is 3 but if you manage a group of 5+ elements, it will invoke an area attack where you will hit all enemies on the screen. Of course, this is all dependent on whether or not your party contains monsters of the same elements as those orbs you match up.
Although this whole matching colours business is quite old by now, Puzzle & Dragons differs in that it's turn-based, and within your turn, you can move any one orb anywhere in the puzzle grid. This allows you to set up combos to deal massive damage. However, selecting a puzzle piece triggers a countdown which limits the amount of time you have to figure out where to move it. On top of that, there's a number on top of an enemy's head that indicates the number of turns you have before it attacks so you have to think fast.
While grouping trios of the elements is all fine and dandy, you won't get very far that way. To effectively get through a dungeon, you will need to strategize and create combos. Combos are basically multiple groups of 3 or more elements that are achieved within your turn. The main advantage is the increase in damage output and also the bonus effect of replenishing a greater amount of health if the combo includes a string of 3 or more Hearts.
As Puzzle & Dragons is a freemium game, it contains in-app purchases as well as a restriction of how much time you can spend playing. The restriction in this case is known as Stamina.
But wait!! Don't stop reading yet! It's not as bad as you think!
If you're impatient, you can always use Magic Stones to restore your Stamina gauge to maximum. Of course, free Magic Stones are conveniently difficult to come by in-game. In fact, the Shop icon is a subtle reminder that you can always purchase more!
Dungeons are categorized as Normal Dungeon or Special Dungeon. The main differences between the two types are dungeon length, stamina cost, and enemy levels/strength.
Normal Dungeons have less stages that require low stamina to enter. They also contain more or less managable opponents. Special Dungeons are the exact opposite. Actually, Special Dungeons are only available for a certain amount of days and are a good source for money (and probably rare monsters).
Both dungeon types have stages that vary in length and number of enemies, but the final stage always contains a boss battle where you can either fight one beefy monster or take on several beefy monsters at once. If I remember correctly, the screencap at the top is a boss fight within one of the special dungeons.
There's no real objective in the game, I don't think. All you do is go around beating up other monsters and collect gold and eggs. These eggs are hatched upon completion of a dungeon stage and you will either get a regular monster (which come from a polka-dotted egg) or a rare monster (which pop up out a striped egg).
Oh yeah, completing dungeons nets you experience too! When your EXP bar is full, you will level up in rank and your Stamina gauge will replenish. You also unlock the feature to gift friends once you reach rank 20. There are probably other features that are dependent on rank that I'm not sure about though. .___.
Currently, there are 200 collectible monsters but I'm not sure if they can all be captured since the ones in the compedium seem to be either the ones you own or the enemy monsters. For some reason, ally monsters from other users don't show up.
Most monsters have special active or passive skills that can be used in battle if the conditions are met. The conditions I've seen so far only call for a fixed number of turns. In terms of active abilities, they can be buffs, debuffs, restoration of the team's health bar, or some sort of attack. Passive skills can consist actions like of counterattacking when hit or restoring a small amount of HP per user turn.
There are also monsters that have a Leader Skill which obviously only become available when placed in Leader slot. I'm uncertain of this but I think the party member you assign as a Leader becomes the guest character that other players can take with them into their fights.
You are free to configure your party in any way by choosing from the available monsters in your inventory. While variety is a good idea, adding several of the same elemental type will increase their attack power. The only catch when outfitting the team is that their combined cost — in the right image above, each monster's value is indicated below their level — cannot exceed the allotted team cost. Using the screenshot on the right, you can see that my limit is 26 but I've only used up 22.
Fusing monsters is the only way to level them up or evolve them. The latter requires them to be at their maximum level where you can then synthesize them with other maxed out monsters. The resulting monster will be one of higher grade. I'm not sure any fusion can fail but given the rarity of some of the "ingredients", as well as the cost of the whole process, I don't believe it's possible.
Monster grades are indicated as stars on their profile cards. One star is the lowest possible grade and usually max out at level 10. As the stars increase, the maximum level also rises. As I'm early in the game, I don't know what the highest grade would be but I'm guessing it's 4 or 5 stars.
I don't them and they don't know me but we're friends!
I opened this overview by stating that Puzzle & Dragons is a semi-social game. By this, I meant that part of the gameplay gimmick is that you can obtain Friendship Points (FP) from opting to take someone else's monsters out with your group. Er, incidentally, the games labels the name of these points in Japanese which is 友情ポイント.
Everyone starts off as strangers and it will remain so unless you actually go out of your way to become acquainted with them through the game's messaging and gifting system. You only gain 5 FP from an outting from strangers. However, once they become "friends", you will get the obtain 10 FP. Unfortunately, all these Friendship Points, whether they're from strangers or friends, can only be received once by day.
Oh, I forgot to mention, since this is a free title from the Japanese App Store, you can create an iTunes Japan account to download it to try it it out for yourself! You don't need to enter any credit card information at all~!
Hi there! I was searching for some english sites about this game and chanced upon your blog! how far are you into the game now? There is something about the increasing of level of your monsters' skill that i don't know about.
dont really understand the japanese but i've played for quite some time haha. nice to know that english speakers play this too!
Hooray! Another player! XD I'm actually surprised GungHo hasn't released a localized version yet. In a way, I hope they don't or else I'll be spending lots of money buying Magic Stones in THAT one. XD I already spent more than I should have in the JP one. Anyway, are you asking about the option I highlighted in the left screenshot below?
That's for evolving your monsters! 😀 You can only do it if you a) get all the fusion/catalyst monsters and b) max out the monster you want to evolve. In the right screenshot, I have all the fusion monsters needed. The numbers underneath each of the monsters just shows the quantity I have in my Monster Box.
Hey there! I'm playing it too and I'm just wondering how do you actually GIFT friends when you're Rank 20?
http://p.twimg.com/Aq5NdJxCQAE1wUf.jpg dont understand how to upgrade the skills. Ive seen "friends" with skill level maxed out and they do really massive damage compared to me.
Haha no worried dude! It's nice to see English speaking players for a fully Japanese game. I can't copy that text to google translate if not I'd have done it. It's one of those tips that randomly appear after you finishes a dungeon.
I play quite often (actually very often) so maybe that's why! Just earn money and keep making the monsters stronger.
Some days youll get free Magic stones from the developers but I'm not sure why. By the way I've sent u a request!
It says that if you fuse a monster with a monster that has the same skill, the skill level will go up.
By the way something weird just happened! I was trying out this gifting feature when I went to the "friends" tab and tappe the fifth option. I was prompted to choose a friend and after that I was brought to a golden gacha dragon and got a little dragon from there that went into my inventory!
Not that I'm complaining as I don't have that dragon, but I don't know what happened!
Hi, just to reply to you, you can send one and only one friend a gift when you hit rank 20. To upgrade skills, you merge the pets with the same skills in order to level that particular skill up, Hope this helps you!
Hi! Thank you! I found that out myself kinda randomly. Do you wanna leave your ID for me to add? I wanna add more English speaking friends!!
By the way koukoupuffs, merging monsters with same type will receive bonus exp!
Does anyone know what's monster No. 176 used for? The cute sitting dragon-like thing.
Hi Yuling, i've added you! That dragon is purely for merging with your main monsters to increase their level. Certain times during the day, there will be a random 1hr 'urgent' quest where there are no. 177 and 178. 178 is worth the most exp.
Koukoupuff, try to get some dragons from the friendship gacha! This week there'll be more rare monsters that'll help!
For those who understand a bit of chinese, there's a chinese wiki page here http://zh.pad.wikia.com/index.php?title=Puzzle_%26_Dragons_%E7%BB%B4%E5%9F%BA&variant=zh-tw.
– Is there a player level limit in the game (max level)?
– for the special dungeon, particularly the dragon boss dungeons, do those boss drop their egg as well?
Hi, there is no limit to your level. I have "friends" on my list over 160 and I'm about 120.
Also, about the Metal dragons special dungeon, do you have a recommended minimum level for a successful run? I seen the data from the wiki source and most metal dragons have over thousands defences….
Yup but their attack aren't that high too. It's worth it going for that metal dragon dungeons cos the king one gives really tons of exp for your monsters. Im not sure what level is recommended though since i only discovered it a bit later on.
Managed to level today and have 1 extra slot available for the list.
Hey guys, my friend told me that there will be localized version of this game. Is it true?
They're probably talking about Angel Salvation (https://koukoupuffs.net/2012/09/09/angel-salvation-puzzle-dragons-skinned-for-the-western-audience/). It's a knock-off by a Chinese company. GungHo North America IS planning on releasing P&D in NA soon so stay tuned!
Hi, I just stumbled upon this article today. I live in Japan and am an avid player of the Japanese P&D. I've always wanted to build an English P&D wiki database from the wealth of information I've received while playing and discussing with other players. If this sounds like something some of you may be interested in, let me know! I'm also a translator, so feel free to throw anything Japanese my way.
Hi Anthony, may I know where do u usually discuss the games with other players? Some online forums?
I'm a bit interested but how are you gonna go about doing it?
After thinking it over, the best format would probably be as a smartphone app, but that would mean I'd have to learn how to develop for both iOS and Android.
Add or send me message through here and we can chat. Without disturbing the author here with notification emails!
As for the app, ah I wish I can help..
Looks like your friend list is packed, lol.
Also, I don't have access to your profile, so I can't get your contact info. What to do?
There's an English version released for both iOS and Android.
If you wanna create combos this may helpful. The app name is "Big Combo".
iOS/Android. I used it for Zeus dungeon.


text:
Body Solutions 101
Rolf Method of Structural Integration
About S.I.
Your Practitioner
Dr. Ida Rolf
Contact Rates
Ida Rolf – Founder of Rolfing Structural Integration
Ida P. Rolf received a Ph.D. in Biochemistry from the College of Physicians and Surgeons at Colombia University. For 12 years she worked at the Rockefeller Institute in the Chemotherapy and Organic Chemistry department. She took a leave of absence to study mathmatics and atomic physics in Switzerland, while also studing Homeopathy in Geneva.
Challenged by personal and family health issues, she sought alternative answers to the standard treatments offered. Ida explored Osteopathy and Chiropractic medicine, along with many other modalities. Her quest for health and wholeness led her to many discoveries about the body, particularly fascia and it's affect on bringing the body into a healthy "Line".
This understanding enabled her to develop the method known as Structural Integration. Many have come to know it as "Rolfing" being named after her. Other schools have taught her method such as the Guild for Structural Integration, and the Rolf institute. Joseph Heller – the first President of the Rolf Institute started his own school and his work became known as "Hellerwork."
In the 1960's Dr. Rolf worked with many pioneers of the "Human Potential Movement" at the Esalen Institute in California. Pioneers such as Fritz Perls – the founder of Gestalt Therapy, and Moshe Feldenkrais the founder of the feldenkrais method. Ida also took interest in the Alexander Technique where she picked up the concept of "the line".
Ida Rolf's Structural Integration methods are taught and practiced around the world by many passionate practitioners who have been inspired by her work.
Continue to experience your human potential by doing all that you can do to improve your health, well being, and awareness.
Rolfing, body solutions 101, rolfing san diego, "the line", Alexander Technique, Chiropractor, Dr.Rolf, Esalen, Fritz Perls, Gestalt Therapy, Guild for Structural Integration, Hellerwork, Ida Rolf, Osteopathy
535 North Hwy. 101. Suite D Solana Beach 92075 (760) 715-2122
© 2019 Body Solutions 101 | Designed by: Theme Freesia | Powered by: WordPress


Saturday August 17 at 6 pm thru 11 am Sunday August 18.
$25 per person for camping, $10 for evening only. 1/2 price for Airlie wine club members and 1 guest. Reservations are required and space is limited. Kids and dogs are welcome and free.


Part of my artistic practice includes volunteering time and skill for the local community.
To the left - Samples of work that I've produced for a New Jersey organization that educates the public about the dangers of underage alcohol consumption. These short animations are for their Instagram feed. Their target audience is between 14 - 21.
Below are samples of work that I've produced for a New Jersey elementary school's annual fall fundraiser - a family friendly Haunted House.
This year was a collaboration between a local elementary school and the Girl Scouts of America. The theme was a haunted pirate ship. The girls recited sections of a poem that told the story of the lost pirate crew. There is a section where the video cuts out and the girls were expected to jump-scare the audience with the last line of the poem.
The video was projected on a semi-transparent fabric hung from the ceiling. A fan was rippling the fabric to create a ghostly effect.
The performance had a new group every five minutes for four hours a night over two nights in October 2018.
To the left is the full video.
Below is footage of the video in performance.
This year's theme was Haunted Hotel. The skit was to illustrate how the sentient items in the coat check were jealous of their masters dancing the night away at the annual Monster Mash ball. I created the video above, include the puppet coat check monster that scares the guests at the end of the video.
This was the first year collaborating with the elementary school. I was assigned the school's library. The guests were given a tour of haunted items around the library while the video was being played. This video only includes the animated segments. No footage of the performance space is included.


This fleece watch cap will keep your head nice and warm. It has been said that the majority of heat that body losses is through the head; so why not protect your head with the awesome fleece cap.
This fleece watch cap will stays secure around your head. This soft fleece cap is made from a strong fleece material which is stretch and form fitting. Do not worry if you have a unique shaped skull… we all do. It is what makes us who we are and thanks to this fleece watch cap we can protect our uniqueness.
It comes in green and black so it matches any outfit. This watch cap is trendy and warm that can't beat that. Not only does the fleece watch cap keep your head warm, have a stretchy material and water resistant.
Regardless of the temperature outside this fleece cap is just what you need to make your winter or cold weather ensemble complete. Keeping your head warm will help to keep the rest of you warm as well. Use this hat to keep your body at a nice comfortable temperature.
This fleece hat is soft, comfy and can be worn for all types of weather. That makes it an all-around great gift idea or treat for yourself. The green and black colors allow you the ability to wear this cap with any outfit.


text:
Not Dead (White Men) Yet
Lauren Horst | Feb 2015 | Global Liberal Education, Literature and Creative Writing, Opinion |
It was some months through my semester in New York before I realized that I didn't have as strong a grasp on the "classics" as I thought I did. By "classics," I mean non-contemporary works by mostly white, mostly male authors. "Dead White Men," so to speak. Sure, I took Classic American Literature once, so I could tell you a little something about Charles Brockden Brown if you needed me to. And I read an adaptation of Beowulf in high school. But I wouldn't have been able to tell you anything else about Old English, or epics, or what was happening across the pond while Brown was getting his Gothic on.
In other words, I had no sense of literary tradition; there was no narrative arc in the literature electives I had taken. In retrospect, there were some warning signs along the way, moments that would have troubled any other self-respecting literature student. For instance, I only learned in my junior year that Othello isn't a Greek tragedy, as I had thought; it's actually a work by Shakespeare. I also learned that The Odyssey not only isn't the same thing as Othello, but it's also not written by Virgil. Virgil did The Aeneid.
So I knew there were gaps, but I didn't really know how much I was missing. No one ever forced me to take the NYUAD course Foundations of Literature, and I wasn't about to subject myself to authors I wrote off as "Dead White Men." In New York, however, there was no escape. Classics, by authors mostly male, nearly all white, and all definitely dead, clogged my course syllabi, and I realized I liked reading some of it. I liked the feeling of connecting the dots. And I couldn't help wondering if, in the name of expanding my worldview and rethinking old conceptual frameworks, I'd missed out on something important. Had I, much like the baby and the bathwater, thrown out the hegemon with the counter-hegemon, the core out with the periphery, the masterminds and masterpieces out with the "Dead White Men."
I'm a dying breed of lit major at this university. When I started at NYUAD, there weren't many requirements to the literature major beyond a theory course. There are now two required courses in the literature major called Foundations of Literature, which I obviously never took, was not forced to take, and only now, with less than a semester left of my undergraduate career, wish I had. The younger students in my literature classes aren't confusing Greek tragedy and Shakespeare. (Or they're doing a commendable job hiding their confusion.)
Think of me — and my bizarre, decentered, historically backwards literary education — as an interesting case study: How important are "the classics" really? What happens when students skip them altogether? Do they make more interesting connections? Or are they left historically adrift, without any means of drawing connections? Does reading things chronologically matter, or do we just need a sampling of all the pieces?
My editor suggested I have an opinion about these questions, or at least something close to an opinion. So here's what I think, as someone who attempted to school herself in the "classics": Foundations are good, and necessary. Devaluing the classics isn't a path towards valuing the more contemporary revisions, adaptations, rethinkings, and rebuttals. While I understand that it might be more interesting to be purely critical, I have to say that I think Foundations of Literature has got it just about right.
In the end, my case was solvable. I dealt with this situation in the same way that I deal with practically any situation; only in this case, it was probably the right way to deal with the situation. I headed to the library. This was a job for Norton Anthologies, and maybe the occasional Longman edition. And, as tends to happen when you sit in front of a book and move your eyes consistently over the words on the page, I learned things. Did you know, for instance, that Brecht and Beckett are different people? You probably do, but now I do too. And that Yeats — that's Yeats-with-a-Y, who is not the same person as Keats — wrote things other than the poem from which Chinua Achebe took the title to Things Fall Apart? I know that now too. Gradually, my ability to distinguish between even the Abbreviated Anglo Authors — T. S. Eliot, E. M. Forster, D. H. Lawrence — improved. Nowadays I feel a little like someone at the eye doctor, finally able to keep straight the "D" from the "O" on the bottom line of an eye chart. Each new author, period, style, that I've learned has brought the literary world into focus a little bit more and in new, fun ways, like twists on a kaleidoscope.
At another university, even as a literature major at the College of Arts and Sciences in New York, I suspect my major would have had a different valence to it than it does here at NYUAD. But I didn't choose to go to the NYU in the Square; I chose to come here. In that respect, I feel fortunate and privileged to have spent four years at NYU Abu Dhabi, among students and professors sympathetic to my literary interests in mostly non-white, non-male, non-dead authors. But you should still force me to read the other guys.
All this discussion of canons leads me to update an old saying: Give a student the literary canon, she thinks for a day; give her the conceptual tools to question the literary canon, she thinks for a lifetime.
Senior Lit major Lauren Horst is writing a capstone project about the Nigerian novelist Buchi Emecheta and thinking about which doctoral program in literature to attend in the fall.
Next in our Roundtable: NYUAD alumnus Krisztian Kovacs reflects on his experience of the NYUAD Core Curriculum.
50 Dirhams at Night: Accra
Lauren Horst | Apr 2013 | 50 Dirhams a Day, Articles, Side Streets |
50 AED = 28 cedis [GH₵] (April 2013)
Perhaps you spent the day at school, immersed in the Pan-African theories of Ghana's founder, Kwame Nkrumah, or at your internship for the nearby hospital. Or maybe you sweated your way through the sprawling open-air Makola Market, purchasing off-brand toothpaste and colorful African print to add to your ever-growing fabric collection. Maybe you tasted the plantain chips, roasted yams, groundnut paste (essentially, peanut butter), and impossibly sweet pineapples sold at the stands on the side of the road.
You might think you've seen all Accra has to offer.
As the sun goes down, however, Accra's vibrant arts, music and literature scene comes alive. Twenty-eight cedis in your pocket is all you need to immerse yourself in that world.
First, before leaving your neighborhood, catch a bite to eat at the famed Auntie Muni's. Widely touted as the best waakye (a beans and rice dish) joint in all of Accra, this budget-friendly meal will run you no more than seven cedis. If you've already grabbed dinner, or are in the mood for something sweet, the recently opened Italian-style gelateria, Arlecchino, on bustling Oxford Street, offers some exotic flavors, including cashew, for around the same price.
While you're in the trendy Osu neighborhood, consider stopping by +233 Jazz Bar and Grill (so named for Accra's mobile area code). For five cedis, you'll hear Ghanaian and other African musicians live. Or bring your five cedis to The Republic, where one night you might hear a Nigerian band cover "Wonderwall" and "Use Somebody", and the next cheer for an expat college student as she opens for a local jazz band. Either way, five cedis well spent.
Afterwards, swing by Reggae Night at Labadi Beach, where another five cedis will get you a slightly grungier and certainly sandier experience, or head to an event at the Ohene Djan Sports Stadium like the Independence Day concert, which featured dozens of West African artists. Ask anyone to teach you the azonto, the newest Ghanaian dance craze that's sweeping the West African and international music scene.
By now, you've heard everything from American pop covers to traditional Ghanaian high-life to reggae. How about some spoken word?
It can be tricky finding out about art events and exhibits in Accra, where art galleries and theaters are fairly recent and their websites outdated and unhelpful. Here's a trick: head to Facebook and other social media platforms for the most up-to-date information.
The Goethe-Institut, Alliance-Francaise, Nubuke Foundation, and the Dei Centre all put on exceptional exhibits and events, most of which you can discover through their Facebook pages if not their websites. For example, the arts collective Ehalakasa hosts monthly "Talk Parties" at the Nubuke Foundation – essentially open mic nights. For ten cedis, you'll get to hear and rub shoulders with some of Ghana's most well-recognized performers, including Mutombo da Poet and WanLov the Kubolor.
If you didn't buy a gelato earlier, you'll have a few cedis left over, which you can use to pick up a CD from one of the artists you heard tonight. The CD purchase will support the Ghanaian arts scene and be a lasting memento of the evening—a unique souvenir of your time in Accra. Just make sure to keep back a few cedis so that you can split the cost of a taxi home with some friends.
With its colorful markets and rich heritage sites, Accra during the day is something to see. But Accra at night, that's something to experience.
[Photo credit: Lauren Horst. Independence Day concert at Ohene Djan Sports Stadium]
Arabic Typography
Lauren Horst | Nov 2012 | Art and Art History, Articles, Crossings |
Many people know the name of Johannes Gutenberg, the inventor of the movable type press that touched off a printing revolution in fifteenth-century Europe.
What comes after Gutenberg, especially in the Arabic-speaking world, is perhaps a little less familiar.
Enter the research of typographer, student and teacher Titus Nemeth, who was at NYU Abu Dhabi on September 23 to give a lecture entitled "Arabic Typography: Complexities and Simplifications."
Nemeth, who holds an MA with Distinction in Typeface Design from the University of Reading, UK, currently teaches at ESAV Marrakesh and ESAD Amiens while working independently as a designer and consultant. Since 2010, Nemeth has researched Arabic typography as a PhD candidate at the University of Reading.
In his lecture, Nemeth provided an abridged history of Arabic printing beginning with the first book printed in Arabic more than a century after the printing of Gutenberg's Bible.
Nemeth compared the error-ridden, slipshod technique of this early printed Arabic with a handwritten sample from around the same time, concluding that Arabic printing lagged behind its western European counterparts mainly for technological reasons.
"The typographic image doesn't come close to the intricacy of the handwritten script," said Nemeth, gesturing to the ornate and delicate curls of the Arabic script projected behind him.
It was not until the nineteenth century that Arabic found the first "at least partially successful" typeface. However, the complexities of the Arabic language, in which a single letter can look dramatically different depending on its position within the word, made Arabic printing a laborious task, to say the least.
For the quantitative at heart, Nemeth included some comparative figures between Roman-based and Arabic-based fonts. In the late nineteenth century, Arabic printing still required more than 1500 separate letter blocks, compared with roughly 100 blocks for a Roman font.
By the middle of the twentieth century, Arab newspapers like Al-Hayat had embraced the principle of character reduction in order to fit the Arabic alphabet to the space constraints of the typewriter.
Throughout these early slides, I sensed a common strain: the story of Arabic type design as Nemeth presented it is essentially one of man versus machine. Over time aspiring Arab publishers needed to adapt to western machinery devised for Roman type. Conforming to the mechanical limitations of the printing press, and later the linotype and typewriter, meant sacrificing the sophistication of the language.
By this point in the lecture, feeling sufficiently caught up with Arabic typography, I began to consider what implications a digitized Arabic type design holds for the world today, and what role the NYU Abu Dhabi community mightplay plays in that digitization.
Nemeth didn't leave me wondering for long.
Like so many disciplines, typography – Arabic or otherwise – has felt the dawn of the new digital world keenly. If the space constraint of print and printing presses was the only hindrance to a better Arabic typeface, what possibilities exist for Arabic typeface in a world without physical constraints?
Nemeth demonstrated one Arabic font type that uses computer programming to simulate the practice of Arabic handwriting. The digital font is comprised of only a few hundred modules based on strokes, rather than individual letters, whichcan be adapted and reused depending on the position within the word. To my eyes, the end result evoked the elegant, meticulous script I've seen in much older Arabic handwritten texts.
Clearly, the advent of computers provides unparalleled opportunities to find new Arabic typeface. New, however, isn't the same as "good." The challenge typographers face now is defining what makes a typeface "good."
For Nemeth, a good Arabic typeface would be one that is less cumbersome for the reader even if the design is more difficult for the typographer. Such an analysis hinges on a socio-historical understanding of Arab language use.
"We need an understanding of what a good type is," he said. "The starting point is to know history, what has been done and what can be done."
I smugly nodded my head in agreement, satisfied that NYU Abu Dhabi – with all its talk of cosmopolitanism and cross-cultural understanding – would somehow contribute to this process. That made the next slide in Nemeth's presentation all the more surprising.
I saw on the screen a close-up shot of one of the familiar purple and white signs that dot Sama residence halls and the Downtown campus. Until that moment, I'm ashamed to admit that I hadn't noticed that the signs are in both Arabic and English.
It took a typographer to point out that the spaces between the characters, called kerning, made the Arabic hard to read, and that the Arabic type was centered on a base-line higher up than the English one.
Passing these signs in the hallway now, I see the excessive kerning and the off-center baseline where I never did before. I'm aware of the room for improvement.
With the advent of technology and the rise of the Arab world, there is no question that the story of printing and type design now extends far beyond Gutenberg. In fact, one small chapter of that story is written on the walls in Sama and DTC. The question that remains now is how that story will be written in later chapters, and of course in what typeface.
photo courtesy of author


text:
After Over A Decade, Lindsay Lohan Is Finally Dropping New Music
Get ready to stream "Xanax."
J. Merritt/Getty
In a recent interview on "The Kris Fade Show," Lindsay Lohan, the teen-queen-turned-Mykonos-businesswoman herself, previewed a snippet of "Xanax," a new track she's set to release soon.
Everything you'd expect from Lohan is here. It's as if Ashley O—Netflix's fake pop star that took over the summer—gave Lohan a reject from her latest album. And that's a good thing. If released, it would be Lohan's first track since 2008's "Bossy" and a return to her rightful place among the pop music gods.
Lohan's been teasing new music for awhile, both in a May Instagram post and with a photo of her in the studio in June, but this is the first time fans have heard actual music. It's a classic club track, and Lilo's lyrical prowess is on full display: "I try to stay away/But you get me high/Only person in this town that I like/Guess I can take one more trip for the night." (Sarcasm!)
After an unexpected cancellation of her MTV show, "Lindsay Lohan's Beach Club," maybe this is just the project Lohan needs to find some footing again. We're waiting, ready to stream when you are Lindsay. Until then we'll just be listening to "Rumors" on repeat.
Trump Adviser: Getting Kicked Off Twitter Has Actually Helped Trump
The January 6 Committee Just Revealed Alarming Text Messages From Sean Hannity
Dan Friedman
Hero: Chris James, the Canadian Comedian Triggering Right-Wing Talk Radio Hosts


text:
UK DVD & Blu-ray Releases: Monday 6th September 2010
Including Kick-Ass and Exit Through The Gift Shop
DVD & BLU-RAY PICKS
Kick-Ass (Universal): A post-modern superhero film based on the comic book by Mark Millar and John Romita, Jr. It is the story of teenager (Aaron Johnson) who decides to become a super-hero named Kick-Ass after purchasing a costume (even though he has no powers or training) and soon finds himself involved with a local gangster (Mark Strong); his son (Christopher Mintz-Plasse); and a highly trained father and daughter vigilante duo (Nicolas Cage and Chloe Moretz).
Directed by Matthew Vaughn, produced by Brad Pitt and written by Vaughn and Jane Goldman, the film was independently financed – at a budget of $28 million dollars – and gleefully subverts the superhero movie whilst also paying homage to it. It isn't the awe-inspiring masterpiece that some would have you believe, but it is still a witty and interesting take on the comic-book genre.
The extras on the Blu-ray and DVD versions include:
Ass-Kicking Bonus View Mode (Blu-ray Disc Exclusive) – Synchronous with the feature film, this innovative multi-media presentation incorporates video and audio commentary, behind-the-scenes clips and illustrative graphics with Co-Writer/Producer/Director Matthew Vaughn, plus cast and crew providing an all-access perspective on Kick-Ass
"A New Kind of Superhero: The Making of Kick-Ass " documentary (Blu-ray Disc Exclusive)
"It's On! The Comic Book Origin of Kick-Ass" featurette
Audio Commentary with Writer-Director Matthew Vaughn
"The Art of Kick-Ass" gallery
Marketing Archive
BD Touch and Metamenu Remote
Lionsgate Live™ enabled, featuring extra content for Internet-connected players
Enhanced for D-Box™ Motion Control Systems
Standard Definition DVD Copy of the feature film
Standard Definition Digital Copy of the feature film
> Buy Kick-Ass on Blu-ray / DVD / Special Edition Combi Pack
Exit Through the Gift Shop (Revolver Entertainment): The debut film from enigmatic graffiti artist Banksy is a documentary (or is it?) which tells the story of Thierry Guetta, a French immigrant in Los Angeles who is obsessed with street art. It shows Guetta's constant filming of his own life and his attempts to capture Banksy on camera. It also features other artists including Invader and Shepard Fairey (the man famous for the Barack Obama 'Hope' poster).
Narrated by Rhys Ifans, the music is by Geoff Barrow and although there has been a continuous debate about the nature of the film since it debuted at Sundance in January, it has got very strong reviews and is likely to increase the mystique of Banksy even further.
Extra features include: stickers, art prints, the movie, and 'limited edition 2D glasses'.
> Buy Exit Through The Gift Shop on Blu-ray or DVD
ALSO OUT
After.Life (Anchor Bay Entertainment UK) [Blu-ray / DVD]
Bent (Park Circus) [Blu-ray / with DVD]
Black Lightning (Universal Pictures) [Blu-ray / DVD]
Doctor Who – The New Series: 5 – Volume 4 (2 Entertain) [Blu-ray / DVD]
Entourage: Season 6 (Warner Home Video) [Blu-ray / DVD]
The African Queen: Restoration Edition (ITV DVD) [Buy it on Blu-ray]
The Brit Indie Collection (4DVD) [Blu-ray / DVD]
The Last Song (Walt Disney) [Blu-ray / DVD]
The Official 2010 World Cup South Africa Review (2 Entertain) [Blu-ray / DVD]
True Inspiration Collection (4DVD) [Blu-ray / DVD]
> The DVD and Blu-ray releases for September 2010
> The Best DVD and Blu-ray releases for 2009
Tags exit through the gift shop, kick-ass
← Inception vs The IT Crowd → Blade Runner Revisited >3.6 Gigapixels