-- MySQL dump 10.9 -- -- Host: localhost Database: vtf2004 -- ------------------------------------------------------ -- Server version 4.1.16-standard /*!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 */; /*!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 `_stat_ss` -- DROP TABLE IF EXISTS `_stat_ss`; CREATE TABLE `_stat_ss` ( `id` bigint(20) NOT NULL auto_increment, `userid` bigint(20) NOT NULL default '0', `ssid` bigint(20) NOT NULL default '0', `sspid` bigint(20) NOT NULL default '0', `date` date NOT NULL default '0000-00-00', `clicks` bigint(20) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `_stat_ss` -- /*!40000 ALTER TABLE `_stat_ss` DISABLE KEYS */; LOCK TABLES `_stat_ss` WRITE; INSERT INTO `_stat_ss` VALUES (1,2,2,7,'2004-05-24',2),(2,3,1,1,'2004-05-24',1),(3,2,1,12,'2004-05-24',1),(4,2,2,7,'2004-05-25',1),(5,2,1,12,'2004-05-25',1),(6,2,1,22,'2004-05-25',3),(7,3,1,1,'2004-05-25',1),(8,3,1,6,'2004-05-25',1),(9,3,1,23,'2004-05-25',2),(10,3,1,25,'2004-05-25',5),(11,3,1,27,'2004-05-25',2),(12,3,1,26,'2004-05-25',2),(13,3,1,24,'2004-05-25',6),(14,3,1,28,'2004-05-25',4),(15,3,1,24,'2004-05-26',8),(16,2,1,22,'2004-05-26',3),(17,3,1,28,'2004-05-26',2),(18,3,1,29,'2004-05-26',2),(19,3,1,25,'2004-05-26',2),(20,3,1,30,'2004-05-26',2),(21,3,1,32,'2004-05-26',1),(22,3,1,31,'2004-05-26',1),(23,3,1,24,'2004-05-27',2),(24,2,2,35,'2004-07-22',1),(25,3,1,24,'2004-09-25',1),(26,2,2,35,'2004-09-25',1),(27,3,1,24,'2004-09-26',1),(28,3,1,24,'2004-09-29',1),(29,2,2,35,'2004-09-29',1),(30,3,1,30,'2004-09-29',1),(31,3,1,31,'2004-09-29',1),(32,3,1,25,'2004-09-29',1),(33,3,1,32,'2004-09-29',1),(34,2,2,35,'2004-10-06',1),(35,3,1,24,'2004-10-06',1),(36,3,1,24,'2004-10-15',1),(37,2,2,35,'2004-10-19',1),(38,3,1,24,'2004-10-20',1),(39,2,2,35,'2004-10-20',1),(40,2,2,35,'2004-11-01',1),(41,3,1,24,'2004-11-01',1),(42,3,1,25,'2004-11-01',1),(43,3,1,30,'2004-11-01',1),(44,3,1,31,'2004-11-01',1),(45,3,1,32,'2004-11-01',1),(46,3,1,24,'2004-11-02',1),(47,2,2,35,'2004-11-02',1),(48,3,1,24,'2004-11-03',1),(49,2,2,35,'2004-11-03',1),(50,3,1,24,'2004-11-12',2),(51,2,2,35,'2004-11-14',1),(52,3,1,24,'2004-11-15',1),(53,2,2,35,'2004-11-24',1),(54,3,1,24,'2004-11-24',1),(55,2,2,35,'2004-11-26',1),(56,3,1,24,'2004-11-26',1),(57,3,1,24,'2004-11-27',2),(58,2,2,35,'2004-11-27',1),(59,3,1,25,'2004-11-27',1),(60,3,1,30,'2004-11-27',1),(61,3,1,31,'2004-11-27',1),(62,3,1,32,'2004-11-27',1),(63,3,1,24,'2004-12-08',1),(64,3,1,31,'2004-12-08',1),(65,3,1,30,'2004-12-19',1),(66,3,1,25,'2004-12-19',1),(67,3,1,32,'2004-12-19',1),(68,3,1,31,'2004-12-19',1),(69,3,1,24,'2004-12-19',1),(70,2,2,35,'2004-12-29',1),(71,3,1,24,'2005-01-04',1),(72,3,1,24,'2005-01-14',1),(73,3,1,24,'2005-01-17',1),(74,3,1,24,'2005-01-18',1),(75,2,2,35,'2005-01-24',1),(76,3,1,24,'2005-01-24',2),(77,3,1,32,'2005-01-24',1),(78,3,1,30,'2005-01-24',1),(79,3,1,25,'2005-01-24',1),(80,3,1,31,'2005-01-24',1),(81,3,1,24,'2005-01-28',1),(82,3,1,24,'2005-02-04',1),(83,3,1,24,'2005-02-28',1),(84,2,2,35,'2005-03-01',4),(85,3,1,24,'2005-03-01',4),(86,3,1,30,'2005-03-01',3),(87,3,1,25,'2005-03-01',2),(88,3,1,32,'2005-03-01',1),(89,2,2,35,'2005-04-04',2),(90,2,2,35,'2005-05-11',1),(91,3,1,25,'2005-06-11',1),(92,2,2,35,'2005-06-12',1),(93,3,1,24,'2005-06-23',2),(94,3,1,31,'2005-06-28',1),(95,3,1,30,'2005-06-28',1),(96,3,1,32,'2005-06-30',1),(97,2,2,35,'2005-08-04',1),(98,2,2,35,'2005-08-07',1),(99,2,2,35,'2005-08-08',1),(100,2,2,35,'2005-08-09',1),(101,2,2,35,'2005-08-13',1),(102,2,2,35,'2005-08-14',1),(103,2,2,35,'2005-08-15',2),(104,2,2,35,'2005-08-16',4),(105,2,2,35,'2005-08-21',2),(106,2,2,35,'2005-08-22',1),(107,2,2,35,'2005-08-23',4),(108,3,1,24,'2005-08-23',1),(109,3,1,25,'2005-08-23',1),(110,3,1,30,'2005-08-23',1),(111,3,1,31,'2005-08-23',1),(112,3,1,32,'2005-08-23',1),(113,2,2,35,'2005-08-24',3),(114,2,2,35,'2005-08-25',2),(115,2,2,35,'2005-08-27',2),(116,2,2,35,'2005-08-30',1),(117,2,2,35,'2005-09-01',1),(118,2,2,35,'2005-09-02',1),(119,2,2,35,'2005-09-03',2),(120,2,2,35,'2005-09-05',1),(121,2,2,35,'2005-09-06',2),(122,2,2,35,'2005-09-07',2),(123,2,2,35,'2005-09-08',1),(124,2,2,35,'2005-09-09',1),(125,2,2,35,'2005-09-10',2),(126,2,2,35,'2005-09-11',2),(127,2,2,35,'2005-09-14',1),(128,2,2,35,'2005-09-15',1),(129,2,2,35,'2005-09-17',2),(130,2,2,35,'2005-09-18',4),(131,2,2,35,'2005-09-19',1),(132,2,2,35,'2005-09-25',1),(133,2,2,35,'2005-09-29',3),(134,2,2,35,'2005-10-01',2),(135,2,2,35,'2005-10-03',1),(136,3,1,24,'2005-10-06',3),(137,3,1,32,'2005-10-09',1),(138,3,1,30,'2005-10-09',1),(139,3,1,31,'2005-10-12',1),(140,3,1,25,'2005-10-12',1),(141,2,2,35,'2005-10-12',1),(142,2,2,35,'2005-10-15',1),(143,2,2,35,'2005-10-16',1),(144,2,2,35,'2005-10-17',1),(145,3,1,24,'2005-10-19',2),(146,3,1,32,'2005-10-21',1),(147,3,1,30,'2005-10-21',1),(148,2,2,35,'2005-10-22',1),(149,2,2,35,'2005-10-23',1),(150,2,2,35,'2005-10-29',1),(151,2,2,35,'2005-10-30',1),(152,2,2,35,'2005-10-31',1),(153,2,2,35,'2005-11-01',2),(154,2,2,35,'2005-11-02',2),(155,3,1,24,'2005-11-03',2),(156,2,2,35,'2005-11-05',1),(157,3,1,24,'2005-11-07',1),(158,2,2,35,'2005-11-13',2),(159,2,2,35,'2005-11-16',1),(160,3,1,24,'2005-11-16',2),(161,2,2,35,'2005-11-18',1),(162,3,1,24,'2005-11-21',2),(163,2,2,35,'2005-11-21',1),(164,2,2,35,'2005-11-25',1),(165,2,2,35,'2005-12-01',2),(166,2,2,35,'2005-12-03',3),(167,2,2,35,'2005-12-11',1),(168,2,2,35,'2005-12-13',3),(169,3,1,24,'2005-12-13',1),(170,2,2,35,'2005-12-18',2),(171,2,2,35,'2005-12-24',1),(172,2,2,35,'2005-12-28',1),(173,2,2,35,'2005-12-30',1),(174,3,1,24,'2005-12-30',2),(175,2,2,35,'2005-12-31',1),(176,2,2,35,'2006-01-02',1),(177,2,2,35,'2006-01-04',1),(178,3,1,24,'2006-01-06',2),(179,3,1,30,'2006-01-06',1),(180,2,2,35,'2006-01-07',3),(181,2,2,35,'2006-01-08',2),(182,2,2,35,'2006-01-09',1),(183,2,2,35,'2006-01-14',1),(184,2,2,35,'2006-01-15',2),(185,2,2,35,'2006-01-17',1),(186,3,1,24,'2006-01-18',1),(187,2,2,35,'2006-01-18',1),(188,2,2,35,'2006-01-21',1),(189,3,1,24,'2006-01-22',2),(190,2,2,35,'2006-01-22',2),(191,2,2,35,'2006-01-25',3),(192,3,1,24,'2006-01-27',1),(193,3,1,30,'2006-01-27',1),(194,3,1,31,'2006-01-27',1),(195,3,1,25,'2006-01-27',1),(196,3,1,32,'2006-01-27',1),(197,2,2,35,'2006-02-04',2),(198,2,2,35,'2006-02-06',1),(199,3,1,24,'2006-02-09',2),(200,3,1,30,'2006-02-09',1),(201,3,1,25,'2006-02-09',1),(202,3,1,32,'2006-02-09',1),(203,3,1,31,'2006-02-09',1),(204,2,2,35,'2006-02-10',1),(205,3,1,24,'2006-02-10',1),(206,2,2,35,'2006-02-11',1),(207,2,2,35,'2006-02-15',1),(208,2,2,35,'2006-02-21',1),(209,3,1,30,'2006-02-22',2),(210,2,2,35,'2006-02-23',1),(211,2,2,35,'2006-02-24',1),(212,2,2,35,'2006-02-25',4),(213,3,1,24,'2006-02-25',2),(214,3,1,32,'2006-02-25',1),(215,3,1,25,'2006-02-25',1),(216,3,1,31,'2006-02-25',1),(217,3,1,24,'2006-02-26',2),(218,2,2,35,'2006-03-01',3),(219,2,2,35,'2006-03-07',1),(220,2,2,35,'2006-03-09',1),(221,3,1,30,'2006-03-09',1),(222,2,2,35,'2006-03-10',2),(223,3,1,24,'2006-03-10',1),(224,3,1,32,'2006-03-12',1),(225,3,1,25,'2006-03-12',1),(226,2,2,35,'2006-03-12',1),(227,3,1,31,'2006-03-12',1),(228,3,1,24,'2006-03-12',1),(229,3,1,24,'2006-03-13',1),(230,2,2,35,'2006-03-16',2),(231,2,2,35,'2006-03-17',1),(232,2,2,35,'2006-03-19',1),(233,2,2,35,'2006-03-21',1),(234,3,1,24,'2006-03-22',1),(235,3,1,30,'2006-03-22',1),(236,2,2,35,'2006-03-23',2),(237,2,2,35,'2006-03-25',4),(238,3,1,25,'2006-03-26',1),(239,3,1,32,'2006-03-26',1),(240,3,1,31,'2006-03-26',1),(241,3,1,24,'2006-03-26',1),(242,3,1,24,'2006-03-27',1),(243,2,2,35,'2006-04-04',2),(244,3,1,30,'2006-04-07',1),(245,2,2,35,'2006-04-07',1),(246,3,1,24,'2006-04-09',1),(247,3,1,25,'2006-04-10',1),(248,3,1,32,'2006-04-10',1),(249,3,1,30,'2006-04-10',1),(250,3,1,31,'2006-04-11',1),(251,3,1,24,'2006-04-11',1),(252,3,1,24,'2006-04-16',1),(253,2,2,35,'2006-04-16',2),(254,2,2,35,'2006-04-21',1),(255,2,2,35,'2006-04-22',2),(256,3,1,24,'2006-04-22',1),(257,3,1,32,'2006-04-23',1),(258,3,1,25,'2006-04-23',1),(259,3,1,31,'2006-04-24',1),(260,3,1,24,'2006-04-24',1),(261,3,1,30,'2006-04-25',2),(262,3,1,24,'2006-04-28',1),(263,3,1,25,'2006-04-28',1),(264,3,1,32,'2006-04-28',1),(265,3,1,31,'2006-04-29',1),(266,3,1,30,'2006-04-29',1),(267,3,1,24,'2006-05-05',1),(268,2,2,35,'2006-05-06',2),(269,3,1,32,'2006-05-09',1),(270,3,1,25,'2006-05-09',1),(271,2,2,35,'2006-05-09',1),(272,3,1,24,'2006-05-09',1),(273,3,1,31,'2006-05-13',1),(274,3,1,24,'2006-05-13',1),(275,3,1,30,'2006-05-14',1),(276,3,1,24,'2006-05-15',3),(277,3,1,32,'2006-05-15',1),(278,2,2,35,'2006-05-18',1),(279,2,2,35,'2006-05-20',1),(280,2,2,35,'2006-05-22',2),(281,2,2,35,'2006-05-23',1),(282,3,1,24,'2006-05-29',1),(283,2,2,35,'2006-05-29',1),(284,2,2,35,'2006-05-30',1),(285,2,2,35,'2006-06-02',1),(286,3,1,24,'2006-06-07',1),(287,3,1,31,'2006-06-07',1),(288,3,1,30,'2006-06-08',1),(289,2,2,35,'2006-06-09',1),(290,2,2,35,'2006-06-11',1),(291,2,2,35,'2006-06-12',2),(292,2,2,35,'2006-06-13',2),(293,2,2,35,'2006-06-15',1),(294,2,2,35,'2006-06-22',3),(295,2,2,35,'2006-06-23',1),(296,3,1,32,'2006-06-25',1),(297,3,1,25,'2006-06-25',1),(298,2,2,35,'2006-06-27',1),(299,2,2,35,'2006-06-29',1),(300,2,2,35,'2006-07-01',2),(301,3,1,31,'2006-07-01',1),(302,3,1,24,'2006-07-01',2),(303,3,1,24,'2006-07-02',1),(304,2,2,35,'2006-07-06',1),(305,2,2,35,'2006-07-13',2),(306,2,2,35,'2006-07-14',1),(307,3,1,32,'2006-07-18',1),(308,3,1,25,'2006-07-18',1),(309,3,1,30,'2006-07-18',1),(310,2,2,35,'2006-07-19',2),(311,2,2,35,'2006-07-22',1),(312,3,1,31,'2006-07-23',1),(313,2,2,35,'2006-08-01',1),(314,2,2,35,'2006-08-02',1),(315,2,2,35,'2006-08-03',1),(316,3,1,32,'2006-08-09',1),(317,3,1,25,'2006-08-09',1),(318,3,1,24,'2006-08-09',1),(319,2,2,35,'2006-08-10',2),(320,3,1,30,'2006-08-10',1),(321,2,2,35,'2006-08-12',1),(322,2,2,35,'2006-08-14',3),(323,3,1,31,'2006-08-15',3),(324,2,2,35,'2006-08-16',3),(325,2,2,35,'2006-08-17',3),(326,2,2,35,'2006-08-18',2),(327,2,2,35,'2006-08-23',1),(328,2,2,35,'2006-08-24',1),(329,2,2,35,'2006-08-25',1),(330,2,2,35,'2006-08-27',2),(331,3,1,24,'2006-08-30',1),(332,2,2,35,'2006-08-30',1),(333,3,1,25,'2006-08-30',1),(334,3,1,30,'2006-08-30',1),(335,3,1,31,'2006-08-30',1),(336,3,1,32,'2006-08-30',1),(337,2,2,35,'2006-09-01',1),(338,3,1,32,'2006-09-03',1),(339,3,1,25,'2006-09-03',1),(340,3,1,24,'2006-09-03',2),(341,2,2,35,'2006-09-04',1),(342,3,1,30,'2006-09-05',1),(343,2,2,35,'2006-09-05',1),(344,2,2,35,'2006-09-08',1),(345,3,1,31,'2006-09-09',1),(346,2,2,35,'2006-09-09',1),(347,2,2,35,'2006-09-11',2),(348,2,2,35,'2006-09-13',3),(349,2,2,35,'2006-09-18',2),(350,2,2,35,'2006-09-21',2),(351,2,2,35,'2006-09-23',2),(352,2,2,35,'2006-09-27',2),(353,2,2,35,'2006-09-29',1),(354,3,1,25,'2006-10-03',1),(355,3,1,32,'2006-10-03',1),(356,3,1,24,'2006-10-03',1),(357,2,2,35,'2006-10-03',1),(358,2,2,35,'2006-10-04',1),(359,2,2,35,'2006-10-05',2),(360,3,1,30,'2006-10-05',2),(361,3,1,25,'2006-10-05',1),(362,3,1,32,'2006-10-05',1),(363,3,1,31,'2006-10-05',1),(364,3,1,24,'2006-10-05',1),(365,3,1,24,'2006-10-06',1),(366,2,2,35,'2006-10-06',1),(367,2,2,35,'2006-10-09',1),(368,3,1,31,'2006-10-10',1),(369,2,2,35,'2006-10-11',2),(370,2,2,35,'2006-10-12',1),(371,2,2,35,'2006-10-13',3),(372,2,2,35,'2006-10-16',1),(373,2,2,35,'2006-10-18',1),(374,3,1,24,'2006-10-21',1),(375,2,2,35,'2006-10-23',1),(376,2,2,35,'2006-10-24',2),(377,3,1,24,'2006-10-27',1),(378,2,2,35,'2006-10-27',1),(379,3,1,30,'2006-10-28',1),(380,3,1,32,'2006-10-28',1),(381,3,1,25,'2006-10-28',1),(382,3,1,30,'2006-11-01',1),(383,3,1,31,'2006-11-02',1),(384,2,2,35,'2006-11-04',1),(385,2,2,35,'2006-11-05',4),(386,3,1,32,'2006-11-08',1),(387,2,2,35,'2006-11-16',1),(388,3,1,24,'2006-11-20',1),(389,3,1,25,'2006-11-25',1),(390,3,1,32,'2006-11-25',1),(391,3,1,30,'2006-11-25',1),(392,3,1,24,'2006-11-26',1),(393,3,1,31,'2006-11-30',1),(394,3,1,31,'2006-12-05',1),(395,3,1,25,'2006-12-23',1),(396,3,1,32,'2006-12-23',1),(397,3,1,25,'2006-12-24',1),(398,3,1,32,'2006-12-24',1),(399,3,1,30,'2006-12-24',1),(400,3,1,24,'2006-12-24',1),(401,3,1,31,'2006-12-29',1),(402,2,2,35,'2006-12-30',1),(403,3,1,24,'2007-01-01',1),(404,3,1,25,'2007-01-01',1),(405,3,1,31,'2007-01-02',1),(406,3,1,25,'2007-01-02',1),(407,3,1,30,'2007-01-02',1),(408,2,2,35,'2007-01-08',1),(409,3,1,25,'2007-01-25',1),(410,3,1,32,'2007-01-25',1),(411,3,1,24,'2007-01-26',2),(412,3,1,30,'2007-01-26',1),(413,3,1,31,'2007-02-02',1),(414,3,1,24,'2007-02-16',1),(415,2,2,35,'2007-02-18',1),(416,3,1,25,'2007-02-19',1),(417,3,1,32,'2007-02-19',1),(418,3,1,24,'2007-02-20',2),(419,3,1,32,'2007-02-22',1),(420,3,1,31,'2007-03-05',1),(421,3,1,24,'2007-03-06',1),(422,3,1,30,'2007-03-28',1),(423,2,2,35,'2007-03-29',1),(424,3,1,24,'2007-03-29',1),(425,3,1,25,'2007-03-29',1),(426,3,1,24,'2007-03-30',1),(427,2,2,35,'2007-03-30',1),(428,3,1,31,'2007-03-30',1),(429,3,1,31,'2007-03-31',1),(430,3,1,31,'2007-04-03',1),(431,3,1,24,'2007-04-05',1),(432,2,2,35,'2007-05-21',1),(433,3,1,24,'2007-05-29',1),(434,3,1,31,'2007-05-31',1),(435,3,1,32,'2007-05-31',1),(436,3,1,30,'2007-06-01',1),(437,3,1,25,'2007-06-03',1),(438,2,2,35,'2007-06-30',1),(439,3,1,24,'2007-07-08',2),(440,3,1,24,'2007-07-21',1),(441,2,2,35,'2007-07-24',1),(442,3,1,25,'2007-07-24',1),(443,3,1,32,'2007-07-24',1),(444,3,1,31,'2007-07-24',1),(445,3,1,30,'2007-07-24',1),(446,2,2,35,'2007-08-05',1),(447,3,1,24,'2007-08-08',1),(448,3,1,24,'2007-08-28',1),(449,2,2,35,'2007-09-13',2),(450,3,1,24,'2007-09-13',2),(451,3,1,24,'2007-11-06',1),(452,3,1,24,'2007-11-08',1),(453,2,2,35,'2007-11-08',1),(454,3,1,25,'2007-11-08',1),(455,3,1,30,'2007-11-08',1),(456,3,1,31,'2007-11-08',1),(457,3,1,32,'2007-11-08',1),(458,3,1,24,'2007-11-09',1),(459,2,2,35,'2007-11-09',1),(460,3,1,30,'2007-11-09',1),(461,3,1,25,'2007-11-09',1),(462,3,1,32,'2007-11-09',1),(463,3,1,31,'2007-11-09',1),(464,3,1,24,'2007-11-13',1),(465,3,1,24,'2007-12-08',1),(466,3,1,31,'2007-12-08',1),(467,3,1,32,'2007-12-08',1),(468,3,1,30,'2007-12-08',1),(469,3,1,25,'2007-12-08',1); UNLOCK TABLES; /*!40000 ALTER TABLE `_stat_ss` ENABLE KEYS */; -- -- Table structure for table `_stat_vf` -- DROP TABLE IF EXISTS `_stat_vf`; CREATE TABLE `_stat_vf` ( `id` bigint(20) NOT NULL auto_increment, `userid` bigint(20) NOT NULL default '0', `catid` bigint(20) NOT NULL default '0', `productid` bigint(20) NOT NULL default '0', `date` date NOT NULL default '0000-00-00', `clicks` bigint(20) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `_stat_vf` -- /*!40000 ALTER TABLE `_stat_vf` DISABLE KEYS */; LOCK TABLES `_stat_vf` WRITE; INSERT INTO `_stat_vf` VALUES (1,4,1,7,'2004-05-21',1),(2,2,1,58,'2004-05-24',1),(3,2,1,54,'2004-05-24',2),(4,2,3,59,'2004-05-24',1),(5,4,1,48,'2004-05-24',1),(6,4,1,68,'2004-05-24',1),(7,4,1,53,'2004-05-24',1),(8,4,1,64,'2004-05-24',1),(9,4,1,66,'2004-05-24',1),(10,4,1,67,'2004-05-24',1),(11,4,1,65,'2004-05-24',1),(12,4,1,48,'2004-05-25',5),(13,4,1,49,'2004-05-25',1),(14,4,1,53,'2004-05-25',3),(15,4,1,51,'2004-05-25',2),(16,4,1,50,'2004-05-25',1),(17,2,1,56,'2004-05-25',1),(18,2,1,69,'2004-05-25',7),(19,2,1,71,'2004-05-25',6),(20,2,1,70,'2004-05-25',3),(21,4,2,72,'2004-05-25',5),(22,4,2,76,'2004-05-25',5),(23,4,2,73,'2004-05-25',6),(24,4,2,74,'2004-05-25',2),(25,4,2,77,'2004-05-25',1),(26,4,2,74,'2004-05-26',2),(27,4,2,75,'2004-05-26',2),(28,4,2,77,'2004-05-26',2),(29,2,1,69,'2004-05-26',6),(30,2,1,70,'2004-05-26',4),(31,2,1,71,'2004-05-26',1),(32,4,2,72,'2004-05-26',3),(33,4,2,72,'2004-05-26',1),(34,4,2,76,'2004-05-26',1),(35,2,1,69,'2004-05-27',4),(36,4,2,72,'2004-05-27',2),(37,4,2,76,'2004-05-27',1),(38,4,2,74,'2004-05-27',1),(39,10,1,78,'2004-05-27',1),(40,4,2,74,'2004-07-21',1),(41,4,2,77,'2004-07-21',1),(42,4,2,74,'2004-07-26',1),(43,4,2,75,'2004-07-26',2),(44,4,2,77,'2004-07-26',1),(45,2,1,79,'2004-07-26',2),(46,2,1,69,'2004-07-26',2),(47,2,1,71,'2004-07-26',1),(48,4,2,72,'2004-08-31',2),(49,4,2,77,'2004-08-31',1),(50,4,2,75,'2004-08-31',1),(51,4,2,74,'2004-08-31',1),(52,2,1,69,'2004-09-15',2),(53,2,1,71,'2004-09-15',1),(54,2,1,79,'2004-09-15',1),(55,11,1,80,'2004-09-15',1),(56,10,1,78,'2004-09-29',1),(57,2,1,69,'2004-09-29',1),(58,2,1,71,'2004-09-30',1),(59,2,1,69,'2004-10-15',1),(60,2,1,70,'2004-10-15',1),(61,2,1,71,'2004-10-15',1),(62,4,2,72,'2004-10-15',1),(63,4,2,74,'2004-10-15',1),(64,4,2,75,'2004-10-15',1),(65,4,2,76,'2004-10-15',1),(66,4,2,77,'2004-10-15',1),(67,10,1,78,'2004-10-15',1),(68,2,1,79,'2004-10-15',1),(69,10,1,78,'2004-11-01',1),(70,2,1,69,'2004-11-01',1),(71,4,2,72,'2004-11-03',1),(72,2,1,69,'2004-11-08',1),(73,2,1,70,'2004-11-08',1),(74,4,2,74,'2004-11-11',1),(75,2,1,71,'2004-11-12',1),(76,4,2,72,'2004-11-27',2),(77,4,2,74,'2004-11-27',2),(78,4,2,75,'2004-11-27',2),(79,4,2,76,'2004-11-27',2),(80,4,2,77,'2004-11-27',2),(81,2,1,69,'2004-11-27',2),(82,2,1,70,'2004-11-27',2),(83,2,1,71,'2004-11-27',2),(84,10,1,78,'2004-11-27',1),(85,2,1,79,'2004-11-27',2),(86,4,2,72,'2004-12-05',1),(87,2,1,69,'2004-12-19',3),(88,10,1,78,'2004-12-19',2),(89,2,1,71,'2004-12-19',2),(90,2,1,79,'2004-12-19',2),(91,2,1,70,'2004-12-19',2),(92,4,2,72,'2004-12-19',1),(93,4,2,76,'2004-12-19',1),(94,4,2,74,'2004-12-19',1),(95,4,2,75,'2004-12-19',1),(96,4,2,77,'2004-12-19',1),(97,11,1,80,'2004-12-19',1),(98,4,2,77,'2004-12-20',1),(99,4,2,75,'2004-12-20',1),(100,4,2,74,'2004-12-20',1),(101,4,2,76,'2004-12-20',1),(102,4,2,72,'2004-12-20',1),(103,10,1,81,'2004-12-29',1),(104,2,1,71,'2005-01-03',1),(105,2,1,69,'2005-01-13',1),(106,4,2,72,'2005-01-14',1),(107,4,2,75,'2005-01-14',1),(108,4,2,77,'2005-01-14',1),(109,2,1,69,'2005-01-17',1),(110,2,1,70,'2005-01-17',1),(111,2,1,71,'2005-01-18',1),(112,4,2,72,'2005-01-18',1),(113,4,2,74,'2005-01-19',1),(114,4,2,75,'2005-01-19',1),(115,4,2,76,'2005-01-20',1),(116,4,2,77,'2005-01-20',1),(117,2,1,79,'2005-01-23',1),(118,2,1,69,'2005-01-24',3),(119,11,1,80,'2005-01-24',1),(120,4,2,72,'2005-01-24',2),(121,4,2,77,'2005-01-24',2),(122,4,2,75,'2005-01-24',2),(123,2,1,70,'2005-01-24',2),(124,4,2,76,'2005-01-24',2),(125,2,1,71,'2005-01-24',2),(126,4,2,74,'2005-01-24',2),(127,10,1,81,'2005-01-24',3),(128,2,1,79,'2005-01-24',1),(129,10,1,82,'2005-01-24',2),(130,2,1,79,'2005-01-26',1),(131,2,1,71,'2005-01-27',1),(132,2,1,71,'2005-02-11',1),(133,2,1,69,'2005-03-01',1),(134,2,1,69,'2005-04-04',2),(135,4,2,72,'2005-04-25',1),(136,4,2,74,'2005-04-25',1),(137,4,2,77,'2005-04-25',1),(138,2,1,71,'2005-06-03',1),(139,2,1,71,'2005-06-11',2),(140,4,2,72,'2005-06-14',1),(141,4,2,74,'2005-06-14',1),(142,4,2,75,'2005-06-14',1),(143,4,2,76,'2005-06-14',1),(144,4,2,77,'2005-06-14',1),(145,2,1,69,'2005-06-14',4),(146,2,1,70,'2005-06-14',1),(147,2,1,71,'2005-06-14',1),(148,2,1,79,'2005-06-14',1),(149,11,1,80,'2005-06-14',1),(150,4,2,75,'2005-06-18',2),(151,4,2,72,'2005-06-19',2),(152,4,2,77,'2005-06-22',2),(153,4,2,76,'2005-06-25',2),(154,11,1,80,'2005-06-26',1),(155,11,1,80,'2005-06-27',1),(156,10,1,81,'2005-06-27',3),(157,4,2,74,'2005-06-28',2),(158,2,1,79,'2005-06-28',2),(159,2,1,70,'2005-06-30',2),(160,4,2,72,'2005-07-15',1),(161,4,2,74,'2005-07-15',1),(162,2,1,69,'2005-07-15',1),(163,2,1,79,'2005-07-15',1),(164,11,1,80,'2005-07-15',1),(165,2,1,69,'2005-09-02',1),(166,4,2,76,'2005-10-09',2),(167,2,1,69,'2005-10-16',3),(168,2,1,79,'2005-10-16',2),(169,4,2,72,'2005-10-16',2),(170,2,1,71,'2005-10-19',2),(171,2,1,70,'2005-10-19',2),(172,4,2,76,'2005-10-21',1),(173,4,2,77,'2005-10-25',1),(174,4,2,75,'2005-10-25',1),(175,10,1,81,'2005-10-29',3),(176,11,1,80,'2005-10-29',1),(177,4,2,74,'2005-11-03',2),(178,2,1,69,'2005-11-13',3),(179,2,1,79,'2005-11-13',1),(180,2,1,70,'2005-11-16',2),(181,2,1,71,'2005-11-16',2),(182,4,2,77,'2005-12-01',1),(183,10,1,81,'2005-12-01',3),(184,2,1,69,'2005-12-03',3),(185,10,1,81,'2005-12-03',2),(186,4,2,74,'2005-12-03',1),(187,4,2,74,'2005-12-07',1),(188,4,2,76,'2005-12-07',1),(189,4,2,75,'2005-12-07',1),(190,11,1,80,'2005-12-20',1),(191,4,2,74,'2005-12-22',2),(192,2,1,69,'2005-12-22',2),(193,10,1,81,'2005-12-22',2),(194,4,2,77,'2005-12-24',2),(195,10,1,81,'2006-01-08',2),(196,2,1,69,'2006-01-08',2),(197,4,2,74,'2006-01-13',1),(198,10,1,82,'2006-01-18',1),(199,10,1,81,'2006-01-21',1),(200,2,1,69,'2006-01-21',1),(201,2,1,70,'2006-01-21',1),(202,11,1,80,'2006-01-29',1),(203,4,2,77,'2006-02-01',2),(204,10,1,81,'2006-02-01',2),(205,2,1,69,'2006-02-01',3),(206,10,1,82,'2006-02-01',1),(207,10,1,81,'2006-02-06',1),(208,2,1,69,'2006-02-06',1),(209,2,1,79,'2006-02-06',1),(210,2,1,71,'2006-02-07',1),(211,4,2,74,'2006-02-12',1),(212,11,1,80,'2006-02-17',1),(213,10,1,81,'2006-02-19',1),(214,2,1,69,'2006-02-19',2),(215,2,1,79,'2006-02-22',1),(216,2,1,70,'2006-02-22',1),(217,2,1,69,'2006-02-22',1),(218,11,1,80,'2006-02-23',1),(219,2,1,71,'2006-02-23',1),(220,2,1,69,'2006-02-24',1),(221,4,2,74,'2006-02-28',1),(222,4,2,75,'2006-02-28',1),(223,4,2,77,'2006-03-01',2),(224,11,1,80,'2006-03-03',1),(225,2,1,69,'2006-03-04',2),(226,10,1,81,'2006-03-04',2),(227,2,1,70,'2006-03-08',1),(228,2,1,71,'2006-03-08',1),(229,2,1,69,'2006-03-09',1),(230,2,1,79,'2006-03-09',1),(231,2,1,69,'2006-03-10',1),(232,10,1,81,'2006-03-10',1),(233,2,1,69,'2006-03-16',2),(234,10,1,81,'2006-03-16',1),(235,4,2,77,'2006-03-19',2),(236,2,1,70,'2006-03-21',1),(237,2,1,69,'2006-03-21',1),(238,2,1,71,'2006-03-22',1),(239,2,1,69,'2006-03-23',3),(240,10,1,81,'2006-03-23',1),(241,4,2,75,'2006-03-23',1),(242,4,2,77,'2006-03-23',1),(243,2,1,79,'2006-03-23',1),(244,2,1,79,'2006-03-25',2),(245,10,1,81,'2006-03-29',1),(246,2,1,69,'2006-03-29',1),(247,4,2,77,'2006-04-03',1),(248,2,1,70,'2006-04-05',1),(249,2,1,69,'2006-04-05',1),(250,2,1,71,'2006-04-05',1),(251,2,1,79,'2006-04-08',1),(252,10,1,81,'2006-04-08',1),(253,2,1,69,'2006-04-08',1),(254,10,1,81,'2006-04-10',1),(255,2,1,69,'2006-04-17',1),(256,2,1,71,'2006-04-20',1),(257,11,1,80,'2006-04-20',1),(258,2,1,70,'2006-04-21',2),(259,2,1,79,'2006-04-21',2),(260,11,1,80,'2006-04-21',1),(261,2,1,71,'2006-04-21',1),(262,2,1,69,'2006-04-21',2),(263,10,1,81,'2006-04-21',1),(264,10,1,82,'2006-04-22',1),(265,2,1,69,'2006-04-22',1),(266,4,2,74,'2006-04-30',1),(267,4,2,72,'2006-05-01',1),(268,4,2,76,'2006-05-01',1),(269,2,1,69,'2006-05-02',1),(270,4,2,77,'2006-05-02',1),(271,4,2,75,'2006-05-02',1),(272,4,2,72,'2006-05-02',1),(273,4,2,76,'2006-05-02',1),(274,2,1,69,'2006-05-03',2),(275,2,1,79,'2006-05-04',2),(276,2,1,70,'2006-05-04',2),(277,11,1,80,'2006-05-04',1),(278,2,1,71,'2006-05-05',1),(279,2,1,71,'2006-05-08',1),(280,2,1,69,'2006-05-08',2),(281,10,1,81,'2006-05-08',1),(282,2,1,79,'2006-05-08',1),(283,2,1,69,'2006-05-27',1),(284,2,1,70,'2006-05-28',1),(285,2,1,79,'2006-05-28',1),(286,2,1,71,'2006-05-30',1),(287,2,1,69,'2006-06-02',1),(288,2,1,69,'2006-06-15',1),(289,2,1,69,'2006-06-19',1),(290,2,1,79,'2006-06-22',1),(291,2,1,70,'2006-06-22',1),(292,2,1,71,'2006-06-23',1),(293,2,1,71,'2006-07-16',1),(294,2,1,79,'2006-07-16',1),(295,2,1,69,'2006-07-16',1),(296,2,1,70,'2006-07-16',1),(297,4,2,74,'2006-07-19',1),(298,4,2,72,'2006-07-19',1),(299,10,1,81,'2006-08-07',1),(300,10,1,81,'2006-08-30',1),(301,10,1,81,'2006-09-30',1),(302,10,1,82,'2006-09-30',1),(303,2,1,69,'2006-10-04',1),(304,2,1,79,'2006-10-04',1),(305,10,1,81,'2006-10-06',1),(306,2,1,69,'2006-10-06',1),(307,10,1,82,'2006-10-07',2),(308,2,1,70,'2006-10-07',1),(309,2,1,71,'2006-10-07',1),(310,2,1,79,'2006-10-07',1),(311,10,1,81,'2006-10-07',1),(312,2,1,69,'2006-10-07',1),(313,10,1,81,'2006-10-08',1),(314,4,2,75,'2006-10-15',1),(315,4,2,77,'2006-10-15',1),(316,4,2,72,'2006-10-15',1),(317,4,2,74,'2006-10-15',1),(318,4,2,76,'2006-10-15',1),(319,4,2,72,'2006-10-16',1),(320,4,2,75,'2006-10-16',1),(321,4,2,77,'2006-10-21',1),(322,10,1,81,'2006-10-24',1),(323,10,1,81,'2006-10-31',1),(324,4,2,74,'2006-11-01',1),(325,4,2,72,'2006-11-02',1),(326,2,1,69,'2006-11-10',1),(327,2,1,79,'2006-11-10',1),(328,2,1,69,'2006-11-20',1),(329,4,2,76,'2006-11-20',1),(330,10,1,81,'2006-11-22',1),(331,2,1,69,'2006-11-24',1),(332,4,2,77,'2006-11-24',1),(333,4,2,76,'2006-11-30',1),(334,11,1,80,'2006-12-03',1),(335,10,1,81,'2006-12-03',1),(336,4,2,75,'2006-12-03',1),(337,2,1,69,'2007-01-03',1),(338,4,2,76,'2007-01-11',1),(339,10,1,81,'2007-01-12',1),(340,10,1,82,'2007-01-15',1),(341,4,2,76,'2007-01-15',1),(342,10,1,81,'2007-01-25',1),(343,11,1,80,'2007-02-16',1),(344,4,2,76,'2007-02-18',1),(345,4,2,74,'2007-02-18',1),(346,2,1,69,'2007-02-20',1),(347,2,1,70,'2007-02-20',1),(348,2,1,71,'2007-02-20',1),(349,2,1,79,'2007-02-20',1),(350,10,1,81,'2007-02-21',1),(351,10,1,82,'2007-02-21',1),(352,4,2,76,'2007-02-26',1),(353,2,1,69,'2007-03-04',1),(354,10,1,81,'2007-03-25',1),(355,10,1,81,'2007-04-16',1),(356,2,1,69,'2007-04-16',1),(357,10,1,82,'2007-04-19',1),(358,10,1,81,'2007-04-20',1),(359,10,1,81,'2007-05-31',1),(360,2,1,69,'2007-05-31',1),(361,2,1,69,'2007-07-12',1),(362,10,1,81,'2007-07-12',1),(363,2,1,69,'2007-07-24',1),(364,10,1,81,'2007-07-24',1),(365,2,1,69,'2007-08-16',1),(366,10,1,81,'2007-08-16',1),(367,10,1,81,'2007-10-11',1),(368,2,1,69,'2007-10-11',1),(369,2,1,79,'2007-10-12',1),(370,2,1,71,'2007-10-12',1),(371,2,1,70,'2007-10-12',1),(372,2,1,69,'2007-10-12',1),(373,2,1,69,'2007-11-09',1),(374,10,1,81,'2007-11-09',1),(375,2,1,79,'2007-11-13',1),(376,2,1,71,'2007-11-13',1),(377,10,1,82,'2007-11-13',1),(378,2,1,70,'2007-11-13',1),(379,2,1,69,'2007-11-13',1),(380,10,1,81,'2007-11-13',1),(381,2,1,69,'2007-11-17',1),(382,10,1,81,'2007-11-17',2),(383,10,1,82,'2007-11-17',1); UNLOCK TABLES; /*!40000 ALTER TABLE `_stat_vf` ENABLE KEYS */; -- -- Table structure for table `members` -- DROP TABLE IF EXISTS `members`; CREATE TABLE `members` ( `UserID` bigint(20) NOT NULL default '0', `CompanyName` varchar(255) NOT NULL default '', `TelNum` varchar(100) NOT NULL default '', `FaxNum` varchar(100) NOT NULL default '', `Address` varchar(255) NOT NULL default '', `Website` varchar(100) NOT NULL default '', `CompanyProfile` text NOT NULL, `Logo` varchar(100) NOT NULL default '', `PointsSlots` double NOT NULL default '0', `PointsUsed` double NOT NULL default '0', PRIMARY KEY (`UserID`), FULLTEXT KEY `FullText` (`CompanyName`,`CompanyProfile`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `members` -- /*!40000 ALTER TABLE `members` DISABLE KEYS */; LOCK TABLES `members` WRITE; INSERT INTO `members` VALUES (2,'33 Point 3 Exports, Inc.','(+6332) 344.8831 to 32','(+6332) 344.0518','Manuel Luis Quezon Street, Casuntingan, Mandaue City, Cebu 6014, Philippines','http://www.33point3.com','This is just a test. Exhibitor with Membership Type of Premium.\r\n\r\nCompany History\r\n\r\n33 Point 3 Exports, Inc., was established 1990 in Cebu City the center and focal point of fashion accessories industry in the Philippines. The company began as a manufacturer and exporters of fashion accessories to several buyers from Japan, Europe and USA. Because of its growing demand in the export market the company started its venture for housewares and gift items, which made of rattan, bamboo, coco midrib, hibiscus and other local materials. The company regularly develops original, updated, and finely crafted products to compete with other exporters in the industry.\r\n \r\nPrinciple\r\n\r\nFrom the start, the company\'s principle has been to produce high quality products that are made of indigenous materials ranging from shells to coconut, wood, plant, fibers, carabao horn and bone, as well as articles using plated base metals combined with synthetic gemstone, plastics, textiles and a variety of natural materials. Quality, professionalism service orientation and good relationship are fundamental to our operations.','20040525112526-2.gif',970,33),(3,'Alcon Industries, Inc.','(+6332) 261.9951 to 55','(+6332) 261.9956','Rizal Ave. Extension, Basak San Nicholas, Cebu City, Cebu 6000, Philippines','','','',984,16),(4,'Amarcas International Corporation','(+6332) 346.1109, (+6332) 344.5740 DL','(+6332) 346.0064','153 J. Rizal Street, Mandaue City Cebu 6014, Philippines','http://www.amarcas.com','This is just a test. Exhibitor with Membership Type of Standard.\r\n\r\nAmarcas... Offers costume jewelry, gift items, home novelties, and buttons. Product lines include earrings, bangles, necklaces, brooches, tie pins, buttons, buckles, rosaries, and cuff links. The materials used are sea shells, wood, leaves, stones, clay, animal skin, fish scales and other indigenous materials. \r\nThe company\'s principle come on to buyers are the intricate designs of the in-house designers, who are always abreast of fashion trends. An average of 10 new designs are releaased every month. \r\n\r\nQuality is our principal concern. \r\n\r\nBuyers can present their own designs and material use for execution, exclusive to them. \r\n\r\nWe maintains two showrooms in its principal office. It has arrangements with various hotels and resorts in Cebu and Manila who carry our products.','20040525153047-4.jpg',936,64),(10,'test','regwe','gwerg','test address','','','',996,4),(11,'Philippine International Golf Show','8451324','','secret','http://www.philippineinternationalgolfshow.com','Test only.','20040915134343-11.jpg',998,1); UNLOCK TABLES; /*!40000 ALTER TABLE `members` ENABLE KEYS */; -- -- Table structure for table `news` -- DROP TABLE IF EXISTS `news`; CREATE TABLE `news` ( `newsid` bigint(20) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `content` text NOT NULL, `datecreated` datetime NOT NULL default '0000-00-00 00:00:00', `datelastactivity` datetime NOT NULL default '0000-00-00 00:00:00', `modifiedby` bigint(20) NOT NULL default '0', `status` int(11) NOT NULL default '0', PRIMARY KEY (`newsid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `news` -- /*!40000 ALTER TABLE `news` DISABLE KEYS */; LOCK TABLES `news` WRITE; INSERT INTO `news` VALUES (10,'Password Memorability and Securability','NonNullSet writes \"Who would have thought that that something new could be said about how best to select passwords? Ross Andreson of Cambridge University and some of his colleages have performed new empirical studies and found some pretty non-intuitive results. \r\nFor example: \r\n1. The first folk belief is that users have difficulty remembering random passwords. This belief is confirmed. \r\n\r\n2. The second folk belief is that passwords based on mnemonic prases are harder for an attacker to guess than naively selected passwords. This belief is confirmed. \r\n\r\n3. The third folk belief is that random passwords are better than those based on mnemonic phrases. However, each appeared to be just as strong as the other. So this belief is debunked. \r\n\r\n4. The fourth folk belief is that passwords based on mnemonic phrases are harder to remember than naively selected passwords. However, each ap- peared to be just as easy to remember as the other. So this belief is debunked. \r\n\r\n5. The fifth folk belief is that by educating users to use random passwords or mnemonic passwords, we can gain a significant improvement in security. However, both random passwords and mnemonic passwords suffered from a non-compliance rate of about 10% (including both too-short passwords and passwords not chosen according to the instructions). While this is better than the 35% or so of users who choose bad passwords with only cursory instruction, it is not really a huge improvement. The attacker may have to work three times harder, but in the absence of password policy enforcement mechanisms there seems no way to make the attacker work a thousand times harder. In fact, our experimental group may be about the most compliant a systems administrator can expect to get. So this belief appears to be debunked.\"\r\n\r\n\r\nread more: http://www.ftp.cl.cam.ac.uk/ftp/users/rja14/tr500.pdf','2004-05-24 00:00:00','2004-09-15 00:00:00',5,0),(2,'READY FOR TESTING...','read the title...','2004-05-24 00:00:00','2004-09-15 00:00:00',5,0),(3,'EU Council approves software patents','On May 17, the EU Council voted in favor of a directive that effectively allows for the patentability of computer software. This proposal will go back to the European Parliament for a Second Reading and a subsequent vote.\r\n\r\n\r\n\r\nRead more : http://swpat.ffii.org/\r\n\r\nsign the petition : http://petition.eurolinux.org/index_html?LANG=en','2004-05-24 00:00:00','2004-09-15 12:58:09',5,1),(4,'The Truth about Sessions','Nearly every PHP application uses sessions. This article takes a detailed look at implementing a secure session management mechanism with PHP. Following a fundamental introduction to the Web\'s underlying architecture, the challenge of maintaining state, and the basic operation and intent of cookies, I will step you through some simple and effective methods that can be used to increase the security and reliability of your stateful PHP applications.\r\n\r\n\r\nread more: http://www.php-mag.net/itr/online_artikel/psecom,id,513,nodeid,114.html','2004-05-24 00:00:00','2004-09-15 00:00:00',5,0),(5,'PHP, XML, XSL, XPATH and Web Services','Mashooq Badar investigates the design and implementation of a scalable dynamic website using PHP as the deployment platform. The article also details the use of Web Services and XML with PHP to realize such system. \r\n\r\nread more: http://www.phpbuilder.com/columns/badar20040430.php3','2004-05-24 00:00:00','2004-09-15 00:00:00',5,0),(6,'OSDL releases statement on representation for Torvalds','OSDL is releasing the following statement today regarding legal representation for Linus Torvalds and others involved in various litigation involving SCO. Additional details as to the subpoenas are also included. \r\n\r\nOSDL \r\nTO FUND LINUS TORVALDS LEGAL REPRESENTATION IN SCO LITIGATION \r\n\r\nLeading Linux advocacy consortium will pay legal costs of OSDL Fellow Torvalds and other Lab employees involved in SCO litigation \r\n\r\nBEAVERTON, Ore. - November 14, 2003 - The Open Source Development Labs (OSDL), a global consortium of leading technology companies dedicated to accelerating the adoption of Linux, today announced that both OSDL and Linux creator Linus Torvalds had received subpoenas on Wednesday from attorneys for The SCO Group. \r\n\r\n\r\nread more: http://www.newsforge.com/business/03/11/14/1553204.shtml?tid=2&tid=82&tid=94','2004-05-24 00:00:00','2004-09-15 00:00:00',5,0),(7,'Linus Not The Father Of Linux, According to Report','MrIrwin writes \"According to this article on Yahoo, Linus is not the real father of Linux and Open source software is really just code nicked from other sources. \" Groklaw has done a dissection of the press release. It\'s a press release by the Alexis de Toqueville Institution, who gets funding from MSFT, as well as believes that US IT troubles are because of free software. Oh, and terrorism works better because of open source, and the \"Star Wars\" program was a good idea. \r\n\r\nread more: http://slashdot.org/article.pl?sid=04/05/17/112218&tid=163','2004-05-24 00:00:00','2004-09-15 00:00:00',5,1),(8,'Fathers of Linux Revealed: Tooth Fairy & Santa Claus','An anonymous reader writes \"The Alexis de Tocqueville Institute, which published the results of their very thorough investigation today, turned out to be right. Linus really isn\'t the father of the Linux operating system. After having been found out, Linus had no choice but to admit -- this is what he has to say: \'Ok, I admit it. I was just a front-man for the real fathers of Linux, the Tooth Fairy and Santa Claus.\'\" \r\n\r\nread more: http://developers.slashdot.org/article.pl?sid=04/05/17/2244228&tid=133','2004-05-24 00:00:00','2004-09-15 13:01:04',5,1),(9,'Ken Brown\'s Motivation, Release 1.2','On 20 May 2004, I posted a statement refuting the claim of Ken Brown, President of the Alexis de Tocqueville Institution, that Linus Torvalds didn\'t write Linux. My statement was mentioned on Slashdot, Groklaw, and many other Internet news sites. This attention resulted in over 150,000 requests to our server in less than a day, which is still standing despite yesterday being a national holiday with no one there to stand next to it saying \"You can do it. You can do it.\" Kudos to Sun Microsystems and the folks who built Apache. My statement was mirrored all over the Internet, so the number of true hits to it is probably a substantial multiple of that. There were also quite a few comments at Slashdot, Groklaw, and other sites, many of them about me. I had never engaged in remote multishrink psychoanalysis on this scale before, so it was a fascinating experience. \r\n\r\n\r\nread more: http://trends.newsforge.com/trends/04/05/21/2131224.shtml','2004-05-24 00:00:00','2004-09-15 12:59:12',5,1),(11,'Welcome To Virtual-Fairs.Com!','We don\'t make empty promises - we fulfill them. We don\'t renege on the commitments we have entered into - we nurture them. We don\'t take your problems sitting down - we handle them. This kind of exceptional service keeps our roster of clients happy. So happy, in fact, that their satisfaction is readily apparent to their colleagues. Which is why the virtual-fairs.com family just keeps on growing and growing.\r\n\r\nJust recently, our Southeast Asian neighbors Thailand, Malaysia and Taiwan have teamed up with virtual-fairs.com to further boost their businesses via the World Wide Web (WWW). Through our comprehensive website and search engine, prospective clients get to visit their personalized virtual booths 24 hours a day, seven days a week. Now, instead of limiting their creative talents and profits to their respective countries alone, they have acquired the world as their customer base - a sure indication of bigger and better things to come.\r\n\r\nWith virtual-fairs.com, Thailand, Malaysia and Taiwan can now reap the rewards of their hard work - as key players in the global playing field.\r\n\r\nClick here to know more about what virtual-fairs.com can do for you and your business. For further inquiries, click here for our contact information.','2004-05-25 00:00:00','2004-09-15 00:00:00',5,0),(12,'Age of Experimentations: Latest Trend Directions for 2003-2004','by PJ Arañador\r\nInternational Lifestyle Designer\r\n\r\nTHE NEXT THINGS TO COME. The latest of trends in product design is experimentations. What one does in design clinics will be the future of design. Materials, techniques and forms are restudied in order to give them new life. Refreshed design approaches recreate exciting new design movement called \"renewal\". \r\n\r\nRESCUE. Designers rescue old design elements. Old things are new again but reinvented. The vintage look is given a new contemporary applications. Many of these period style are updated. Inspirations as old as the Gothic look is coming back to the design scene but renewed with the modern twist. Baroque designs are suddenly simplified in details and given new functions.\r\n\r\nMATERIAL MANIPULATIONS. New techniques on material use become the prime design component in new products. Re-done materials which assume new characters are surfacing in the market today. Some of the fine examples are:\r\n\r\nRough-up- materials are crafted with a rough look to give them the artisanal look. The inspirations come from various arts and crafts around the world like slicing leather into thread-like fringes, knitting fiber into massive weaves, reversing materials inside out and naively embroidered in stitch-up manner. \r\n\r\nScissors happy- designers are going a bit crazy by giving sensual and visual values to their creations by cutting materials to give them three-dimensional effects. Usually wild cuts, the charm is in the imperfections. Examples are the \"beggar- look slashes\" or \" rag-like textures\". \r\n\r\nUnfinished look- the \"perfect imperfect\" look by deconstructing the materials. For instance, textiles are distressed again with edges left un-sewn. Knotting and stringing hemps or yarns are the hottest touches. \r\n\r\nArtisanal techniques- traditional techniques are crossing over a range of materials which were unthinkable in the past. Metal strips are woven, ceramics components are converted like macramé, fabrics are perforated and wood appears paper -like. \r\n\r\nORGANIC. The years to come will have dominant use of natural materials and organic shapes. The earth\'s ecosystem will be the major source of inspirations. Nature\'s \"leavings\" like waste recycle and refuse will be transformed into functional objects. The humblest of wasted natural materials will create a balance in the life systems.\r\n\r\nSOFT PROTECTION. Hard edge objects are given soft edges. Exciting things coming out from Europe are clever imagery of materials that functionally or visually protects the user or the wearer. Costume jewelry pieces are made of goatskin to keep one\'s neckline warm during the cold weather. Flimsy and \"cotton-like\" materials are layered at random on top of each other. Lampshades made of stiff materials like bleached leather are given soft tactile appearance for the latest demand for softer domestic edges.\r\n\r\nREAL AND COMFORTING. Honesty to materials is back again. Looking quite primitive in its rawness, its nakedness is grainy and coarse. They are not masked with thick paint finishes. If it is wood, it is wood, and not look something else. Fabrics keep their material purity, however, given new character by physical manipulations. Lowly materials like un-expensive furniture cord are made into high-fashion accessories. Faux finishes are faint just to add surface values. Otherwise, the comfort of real materials is musts. Anything synthetic would draw resistance, both for environmental and design considerations. \r\n\r\nAERATED LOOK. Home objects seem to float in space. With the trends in \"spiritual objects\", these pieces are ethereal looking. Furniture is given a \"breathable\" appearance. Pieces are constructed like scaffoldings and helixes. some imitating the appearance of x-rayed fossilized veins. Objects are punctured. Home textiles and garments are ventilated. \r\n\r\nTHE PALEST OF COLORS. With the lighter forms, light colors compliment the look. They are elegant reflections of pastel hues. Tone on tone colors are justified with texture on texture. Tinted whites go hand in hand with liquor colors of champagne, cognac, wine or brandy. The accent colors are high-luxe rather than shocking in the shades of vintage plums or cheese colors. Optically clean colors are almost spiritual and fading.\r\n\r\nSKINNY AND CURVACEOUS. Furniture takes on the thinnest slither of wood or iron. Vine furniture pieces have whisky-shapes. They echo the shapes of the organic. Garments are profusely ruffled in moving fashion as if creating ripples of water. Home objects appear swaying gracefully in a living space as if hugging someone. The market\'s desire for new inventive shapes are experimental in forms which co-exists with those hungry for new ways of doing things.\r\n\r\nClick Me!','2004-05-26 00:00:00','2004-09-15 00:00:00',5,0),(13,'The Hottest Trend: Surface Textures','By PJ Arañador\r\n\r\nDesigners believe that no single trend dominates the market. However, there are prevailing trends that create buying interests to consumer products.\r\n\r\nDOMINANT TRENDS\r\n\r\nThe most prevailing trends in focus for the next seasons to come are: material, texture, form, color and presentation. These are the major elements that have changed the product forecasts from the heavily thematic approach to more unconventional fashion.\r\n\r\nMATERIAL\r\n\r\nMaterial has become the design in itself. The next thing to come will be high-grade quality materials, sans the throw away and low-perceived kinds. Glass, wood, steel, stone (cement/ granite), leather and fiber are some good examples of very strong materials. Two combinations of these materials are more preferred. As such, products are not overworked, as it would have been for the multi-materials approach in the past.\r\n\r\nGiven a plethora of long lasting and high perceive value materials, designers came out with new design terms like “material manipulations”, “material deconstructions” or “material modernism”. I coined the word “material modernism” to do away with the trite for “material innovation.”\r\n\r\nTEXTURE\r\n\r\nUndoubtedly, the newest darling of all trends today. Surface textures (the sense of touch) have stolen the limelight from aromatic products (the sense of smell). Texturing scores high in the “must list” of consumer products. Scented soaps and candles are now textured more than scented. Ceramic pieces are knobbed and studded than smooth. Furniture upholstery is pampered with extensions and flagellating threads than polished!\r\n\r\nHome objects today are very tactile. The materials are given new soul and character by “surface values”, another term I invented to express this design twist. In Europe alone, buyers are looking for rough yet charming products coming from the East. The Philippines is the number one source of this look. There are too much industrial items coming from Asia, most of which are machine made and too polished to state a valuable personality. The market is hungry for “artisanal objects”, made by hand with charming textures the Filipino craftsmen are experts on.\r\n\r\nSurface texturing comes in wide variations: frills, fringes, frotee (towel texture), combing, chair nail patterns, repousse, bas relief, and etchings, to name a few. The beholders just don’t want to look - the products should entice them to stimulate their skin with seductive sensuality. The over-all goal is to give volume and chiaroscuro (interplay of shadows) on the product, apart from feeling good by running your fingers on it.\r\n\r\nTexturing comes in as well, in repetitive patterns that give an illusion of three-dimensional effects. The optical and graphic techniques are employed to make the product less flat looking. Thus, perceived value is much higher.\r\n\r\nThe pictures shown here highlight the most exciting textures the buyers will die for to include in their merchandise program in the forthcoming market seasons.\r\n\r\nFORM\r\n\r\nThe strong influence of texture as a primary design element has obliged the designers to make the shapes of the objects very simple. Thus, the “geoforms” are introduced.\r\n\r\nUnderstated geometric shapes like rounds, squares and rectangles are the key directions. On top of it all, the cubes are the most widely in demand. These are best seen in the latest furniture collections.\r\n\r\nInterlocking forms are still popular but this time, vertical forms are more preferred. The engineering is simple; the economics is better because of high loadability.\r\n\r\nCOLOR\r\n\r\nThe past seasons saw too many loud and crazy colors. Looking back, the influences of the retro look may have been just a quick affair.\r\n\r\nThe new color palette is turning into high-luxe neutrals with the semblance of earth colors: white pebbles, dessert sand, gray slate, stone, rust, brown leather and bitter chocolate (almost black). Yes, brown is back! The take off is basically the classical colors of organic materials such as wood, stone, granite and fiber - high grade and more sophisticated to be classic.\r\n\r\nSilver and chrome, on the other hand, are mellowing. The metallic color is predominantly gold. It is used in new and exciting ways: Matte gold with shiny gold. Dark with light. Textured with smooth!\r\n\r\nPRESENTATION\r\n\r\nThe visual presentation is basically “dry” rather than “wet or fresh”. The “fresh” imagery was heavily used in the Zen look in the past seasons. The main inspiration for the “dry” look is the picture of dry African savannah of gray driftwood, sun-dried mud, rusted objects or barren soil. The minimal look is still a common consideration, which is one way to achieve higher perceive market valuation.\r\n\r\nTHE NEXT BIG THING\r\n\r\nTextured objects could be like abstract paintings that only the seasoned eye may appreciate intensely. These are more soulful and sophisticated products to express the core idea about down-to-earth values and its sense of durability. Thus, the power in this look is the high value of the products en synch with the consumers’ preference for higher perceived value home objects. Someone who works hard has to flaunt his earnings with something special. This is a concept I refer to as “magnification of one’s purchase”.\r\n\r\nIn my next article, I will write on the theme presentations coming out in the market. It is primarily centered on the modern African look and its design sensibilities that have broken the culture-bound stigma.','2004-05-26 00:00:00','2004-09-15 00:00:00',5,0),(14,'See You At Bauma 2004!','Leaders in the construction and machinery industry converged once again at bauma 2001, the world’s most comprehensive information and communication platform for building and construction professionals. From April 2 to 8, bauma 2001 was transformed into a bustling activity that focused on the different segments of the construction business and served alternately as a popular trading venue for the show’s participants. Over 390,000 trade visitors from 152 countries came to gather information at the New Munich Trade Fair Centre, where 2,341 exhibitors from 42 countries were putting on a global display of goods and services.\r\n\r\nThis year, product innovations concentrated on better economic and operational efficiency, improved performance, user comfort and security as well as environment-friendly design and operation. Discussions on the mechatronics system, a pioneering integration of mechanics, hydraulics, electrical machineries and electronics with control systems, were also conducted to fully utilize the potentials of this new idea.\r\n\r\nDr. Reinhold Festge, Chairman of the Advisory Board to bauma, expressed his satisfaction with the way bauma 2001was organized. “bauma always manages to be a fascinating event. This (most) comprehensive display of equipment and machinery, compressed into just one week, was clearly laid out and was easy to reach on the giant exhibition space – a really tremendous feat,” said Festge. Festge also lauded the wide-ranging series of symposia, congresses, events and press conferences, which he claimed is hard to match by anyone else.\r\n\r\nSo effective was bauma 2001 that exit survey results conducted by independent market researchers yield a 98% excellent rating for the trade show. bauma 2001 also succeeded in providing their exhibitors and visitors with general market orientation, introducing new products as well as refreshing their minds with the latest news in the industry. The following sections generated the highest visitor count throughout the fair: construction vehicles, excavators, crawlers and wheeled loaders, scrapers, bulldozers and graders, construction equipment and contractor tools and site installations.\r\n\r\nWith the phenomenal achievement of bauma 2001, 90% of its exhibitors vowed to take part again in the next trade event which will be held in Munich on March 29 – April 4, 2004.','2004-05-26 00:00:00','2004-09-15 00:00:00',5,0); UNLOCK TABLES; /*!40000 ALTER TABLE `news` ENABLE KEYS */; -- -- Table structure for table `news_cat` -- DROP TABLE IF EXISTS `news_cat`; CREATE TABLE `news_cat` ( `id` bigint(20) NOT NULL auto_increment, `newsid` bigint(20) NOT NULL default '0', `catid` bigint(20) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `news_cat` -- /*!40000 ALTER TABLE `news_cat` DISABLE KEYS */; LOCK TABLES `news_cat` WRITE; INSERT INTO `news_cat` VALUES (60,10,2),(59,10,1),(5,2,1),(6,2,2),(7,2,3),(8,2,4),(93,3,1),(22,4,4),(21,4,3),(20,4,2),(19,4,1),(30,5,4),(29,5,3),(28,5,2),(27,5,1),(98,8,2),(90,6,7),(87,7,4),(97,8,1),(95,9,1),(61,10,3),(62,10,4),(88,12,6),(94,3,9),(92,13,5),(96,9,9),(91,14,8); UNLOCK TABLES; /*!40000 ALTER TABLE `news_cat` ENABLE KEYS */; -- -- Table structure for table `ssexhibitor` -- DROP TABLE IF EXISTS `ssexhibitor`; CREATE TABLE `ssexhibitor` ( `SSID` bigint(20) NOT NULL default '0', `UserID` bigint(20) NOT NULL default '0', `ExhibitorID` bigint(20) NOT NULL auto_increment, `Status` int(11) NOT NULL default '0', PRIMARY KEY (`ExhibitorID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `ssexhibitor` -- /*!40000 ALTER TABLE `ssexhibitor` DISABLE KEYS */; LOCK TABLES `ssexhibitor` WRITE; INSERT INTO `ssexhibitor` VALUES (1,2,1,1),(1,3,2,1),(2,2,3,1),(1,10,4,1),(2,10,5,1),(3,10,6,1),(4,10,7,0),(5,10,8,0),(6,10,9,0); UNLOCK TABLES; /*!40000 ALTER TABLE `ssexhibitor` ENABLE KEYS */; -- -- Table structure for table `ssmain` -- DROP TABLE IF EXISTS `ssmain`; CREATE TABLE `ssmain` ( `SSID` bigint(20) NOT NULL auto_increment, `Name` varchar(100) NOT NULL default '', `ImageFile` varchar(100) NOT NULL default '', `DateFrom` datetime NOT NULL default '0000-00-00 00:00:00', `DateTO` datetime NOT NULL default '0000-00-00 00:00:00', `DateExpiry` datetime NOT NULL default '0000-00-00 00:00:00', `Description` text NOT NULL, `Venue` varchar(100) NOT NULL default '', `DateCreated` datetime NOT NULL default '0000-00-00 00:00:00', `DateLastActivity` datetime NOT NULL default '0000-00-00 00:00:00', `ModifiedBy` bigint(20) NOT NULL default '0', `Status` int(11) NOT NULL default '0', PRIMARY KEY (`SSID`), FULLTEXT KEY `FullText` (`Name`,`Description`,`Venue`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `ssmain` -- /*!40000 ALTER TABLE `ssmain` DISABLE KEYS */; LOCK TABLES `ssmain` WRITE; INSERT INTO `ssmain` VALUES (1,'Macef Spring 2004','20040525162149-1.gif','2005-02-14 00:00:00','2005-02-17 00:00:00','0000-00-00 00:00:00','From January 2004 onwards Macef will be bigger and better and will emphasize:\r\n\r\nThe home in terms of lifestyles rather than individual products because a home is intimately linked with the person who lives in it, interprets it and devotes their time to it.\r\n\r\nItalian style in decoration, taste and design as reflected in its ability to interpret styles and suggestions from all round the world.\r\n\r\nComprehensive coverage to satisfy the needs of professional buyers and the increase in cross-buying in both Italy and internationally.\r\n\r\nThe project hinges around the relaunch of what has always been one of Fiera Milano International\'s biggest and most important events: Macef, an international trade show for the table and kitchen, furnishing accessories and fabrics, gifts and decorative items.\r\n\r\nThe strategy is to broaden horizons and to grow through an expanded range, increased opportunities, levels of interest, contacts and business.\r\n\r\nAn important step in the creation of this new Macef is the repositioning of Chibi&Cart, the International Exhibition of gifts, items for perfumery and smokers, fashion jewellery, stationery, paper and board products, items for school and the arts, to form an integral part of the themed trails and to offer even wider business horizons.\r\n\r\nAnother addition is Festivity, featuring Christmas decorations, and finally there is G! come Giocare, the toy show located within the gifts trail. Both of these are now being held in conjunction with Macef, to create a comprehensive system covering a complementary array of product categories.\r\n\r\nOnce again fairs & more will organize the Philippine Collectives composing of forty (40) companies to join Macef Spring 2004. The Biggest delegation so far since its first participation in 2001.\r\n\r\nCome and visit as at Hall 4/4: Philippine - Thailand Pavilions','Milan, Italy','2004-05-21 00:00:00','2004-05-27 00:00:00',5,1),(2,'Chibidue','20050221110925-2.gif','0000-00-00 00:00:00','2005-05-30 00:00:00','0000-00-00 00:00:00','The costume jewellery, fashion and hair accessories trade show is increasingly establishing itself as a vital opportunity to preview the trends for the coming season.\r\n\r\nFashion jewellery, belts, handbags, scarves, sandals, gloves, wallets and cases, unusual headwear…a whole universe of fashion accessories and jewellery.\r\n\r\nChibidue is all of this and more!','Milan, Italy','2004-05-21 00:00:00','2005-03-16 00:00:00',6,1),(3,'Bijorhca: Eclat de Mode 2004','20040527104902-3.jpg','2004-05-25 00:00:00','2004-05-31 00:00:00','0000-00-00 00:00:00','A true showcase of today\'s latest and most representative trends, and of the great vitality of the costume jewellery market, this show conveys the wealth of French creativity and know-how, unparalleled anywhere in the world.\r\n\r\nThe use of a geographical sector system at Eclat de Mode for the last four sessions has received the widespread approval of the entire jewellery market. This structure is taking firm root thanks to a product offer which grows from season to season, with bold, original and fun collections which dare to combine materials or to use new materials.\r\n\r\nTalent and quality combine with know-how. Eclat de Mode is know recognized as a professional trade show which combines great commercial strength with abounding creativity; it\'s an event much appreciated by everyone in the Costume Jewellery sector.','Paris, France','2004-05-25 00:00:00','2004-05-27 00:00:00',5,1),(4,'ChristmasWorld 2004','20040525170731-4.jpeg','2004-06-01 00:00:00','2004-07-01 00:00:00','0000-00-00 00:00:00','Color Christmas. Adorn the Holidays. \r\n\r\nEnchanting designs and dazzling details mark the Philippine participation to Christmasworld 2004. Spruce up the holiday season with a wonderfully diverse collection that offers everything from the whimsical, to the ethereal, and the spectacular.\r\n\r\nFilipino designers and artisans have channeled their considerable talents toward the creation of superb products that truly capture the festive spirit of the holidays. Drawing inspiration from the classic yuletide symbols, they have transformed the traditional trimmings of the season by infusing them with a fresh new vitality. An exciting array of innovative décor and gift items fashioned from indigenous materials adds to the magical mix of choices.\r\n\r\nAdd color to Christmas and adorn the holidays with style. Let your imagination soar. Explore our country\'s merry array of products – discover sparkling testaments to remarkable creativity and craftsmanship.\r\n\r\nExperience Filipino élan at Christmasworld.','Frankfurt, Germany','2004-05-25 00:00:00','2004-05-27 00:00:00',5,1),(5,'Index Dubai','20040526182405-5.jpeg','2004-10-07 00:00:00','2004-10-11 00:00:00','0000-00-00 00:00:00','What happens when Middle Eastern traditions are laced with Southeast Asian flavor? The result is a fine combination that brings the best of both worlds. Such is the case of Index Dubai 2002 – the biggest interiors event to be held in the exotic Arabian Gulf. The natural charms of Dubai is complemented by the contrasting richness of Philippine-made furniture and furnishings, producing an extraordinary visual and sensual appeal. \r\n\r\nFor five straight days, Index Dubai 2002 proves that it is the largest annual trade show for the furniture and interiors industry, attracting a dynamic line of exhibitors and visitors from all over the world. The exhibition becomes the venue for Filipino artisans to showcase their talent and the flexibility to cater to a diverse range of preferences. They boast of their ability to light up any room, with its line of carefully crafted lighting fixtures. Wrought iron is transformed into spectacular chairs and tables, courtesy of their able hands and dainty imaginations. Even metal is converted into fine furniture and components, creating a modern yet sturdy atmosphere to cater to today’s fast-paced lifestyle. Each piece succeeds in imparting a message of its own, exuding the versatility of the component and the distinct flair of the Filipino. \r\n\r\nFairs & More, Inc. organizes the Philippine contingent of Index Dubai 2002, in collaboration with Joel Enriquez of Luna Design Partners as the official Curator for the Philippine presentation. The Philippine stand is at Hall 6a, Stand 6G300-311 / 6H307-310. ','Dubai, UAE','2004-05-26 00:00:00','2004-05-27 00:00:00',5,0),(6,'International Furniture','20050113190201-6.jpg','2005-01-19 00:00:00','2005-01-25 00:00:00','0000-00-00 00:00:00','Bold Strokes in White Space\r\n\r\nEach piece of furniture is a triumph of will. \r\n\r\nIndigenous materials – fibers of abaca, strips of rattan, slats of bamboo – are all still cut, bound and carried by hand. Craftsmen, versed in decades old tradition, shape the rawness of nature with each stitch, each weave, each firing of the mold, according to the Filipino artist’s vision. Inspired as much by world trends as by a rich local heritage, this vision is both unique and boundless in its scope.\r\n\r\nIMM showcases the creativity and capacity for innovation of six Filipino designers. The workmanship of their products, from custom-made furniture to lighting fixtures and accessories, exemplifies a dedication to quality that their country is also most proud of.\r\n\r\nEmbolden your workplace or home. On January 19 - 25, 2004 experience the Filipino imagination.','Cologne, Germany','2004-05-26 00:00:00','2005-01-13 00:00:00',5,1),(7,'Chibi & Cart','20040526185047-7.jpeg','2004-06-25 00:00:00','2004-07-30 00:00:00','0000-00-00 00:00:00','Team up for Relaunch \r\n\r\nA vast spectrum of product groups comprising paper and stationery, articles for promotion, bijoux, fashion accessories, gifts, toys, decoration for Christmas and festivals is rising up to the challenge from January 17 through 20 at Chibi & Cart and from January 17 through 21 at the International Toy Show (only for the trail Christmas Decorations & Festivals).\r\n\r\nRising up to the challenge posed by an event that stands high on the calendar of trade fairs means tooling up and buckling down to face up to a market climate which, in many respects, is a cause for concern. True to its spirit, Chibi&Cart / International Toy Exhibition does just that, by developing its capabilities and increasing the range of events created especially for the respective groups of trade people and professionals. \r\n\r\nThe configuration of the show is based on six themed trails which are distinct but closely connected between one another. The parts add up to a unique homogeneous whole, introducing a new concept to trade fairs as we know them. The return of the original Cart section to the traditional Chibi&Cart formula, which translated into the trail C@rt&Co., has enabled not only the striking out into new trails, which proved a popular choice at the previous show, but also the generating of value added to the businesswise comprehensive format of the show.\r\n\r\nCarrying on with the tradition of it\'s themes, the Philippines will mark the exhibit halls of Chibi & Cart with it\'s unparalleled line-up of products looming with creativity and style.','Milan, Italy','2004-05-26 00:00:00','2004-05-27 00:00:00',5,1),(9,'Tendence','20040527093427-9.jpeg','2005-08-08 00:00:00','2005-08-30 00:00:00','2005-09-01 00:00:00','The Filipino design sensibility is synonymous to exceptional creativity and ingenuity. A singular sense of style that is rooted in nature, nourished by tradition, and honed by experience -- it is a dynamic fusion that epitomizes the ultimate in contemporary elegance.\r\n\r\nIt finds expression in myriad forms that magically give fresh life to even the most commonplace materials, revealing an inherent understanding and mastery of aesthetics. From remarkable furniture pieces to distinctive gift items, the sheer variety and outstanding quality of Philippine-made products make them indispensable additions to virtually every lifestyle setting. \r\n\r\nBy continually creating functional art pieces that both capture and liberate the imagination, Filipino designers and artisans have found their way back to their natural stage -- Tendance Lifestyle, the world\'s largest consumer goods fair.\r\n\r\nExplore and experience Filipino élan on August 22 to 26 at Tendence Lifestyle 2003.','Frankfurt, Germany','2004-05-27 00:00:00','2004-05-27 00:00:00',5,1),(10,'iSaloni','20040726110336-10.gif','2004-11-18 00:00:00','2004-11-25 00:00:00','2004-11-26 00:00:00','Salone International del Mobile:the international design showcase\r\n\r\nOn 14th to 19th of April 2004, Fiera Milano will again host the exhibit that unveils the latest trends in home interiors-Salone Internazionale del Mobile.\r\n\r\nThe event will showcase the foremost international furniture and furnishing products and the finest home designs from all over the world. This exhibition attracts the most number of visitors worldwide, 260,000 coming from both retail and wholesale side of the market including 150,000 from 150 countries around the world. The show occupies more than 255,000 square meters within Fiera Milano ground precinct and gathers an impressive 3,100 of the industry\'s most dynamic and creative exhibitors.\r\n\r\nAmong the said exhibitors are four of the premier furniture companies in Cebu who will be bringing their unique and latest designs for the year - Design Ventures, Enpekei, Janice Minor, Pacific Traders and Raphael Legacy. ','Milan, Italy','2004-05-27 00:00:00','2004-07-26 00:00:00',6,1),(11,'Chibidue','20040527103459-11.gif','2004-12-01 00:00:00','2004-12-31 00:00:00','0000-00-00 00:00:00','Jewellery and fashion, creativity and business: two pairings that will feature strongly at the next Chibidue at the Fiera Milano from 28th to 31st May 2004. The costume jewellery, fashion and hair accessories trade show is increasingly establishing itself as a vital opportunity to preview the trends for the coming autumn season.\r\n\r\nFashion jewellery, belts, handbags, scarves, sandals, gloves, wallets and cases, unusual headwear…a whole universe of fashion accessories and jewellery. Chibidue is all of this and more!','Milan, Italy','2004-05-27 00:00:00','2004-05-27 00:00:00',5,0); UNLOCK TABLES; /*!40000 ALTER TABLE `ssmain` ENABLE KEYS */; -- -- Table structure for table `ssproducts` -- DROP TABLE IF EXISTS `ssproducts`; CREATE TABLE `ssproducts` ( `SSID` bigint(20) NOT NULL default '0', `UserID` bigint(20) NOT NULL default '0', `ExhibitorID` bigint(20) NOT NULL default '0', `SSProdID` bigint(20) NOT NULL auto_increment, `Name` varchar(100) NOT NULL default '', `Description` text NOT NULL, `ImageName` varchar(100) NOT NULL default '', `ImageFile` varchar(100) NOT NULL default '', `Views` int(11) NOT NULL default '0', `Status` int(11) NOT NULL default '0', PRIMARY KEY (`SSProdID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `ssproducts` -- /*!40000 ALTER TABLE `ssproducts` DISABLE KEYS */; LOCK TABLES `ssproducts` WRITE; INSERT INTO `ssproducts` VALUES (1,3,2,24,'DCP:01483','','alcon02.jpg','20040525135420-1-3-24.jpg',0,1),(1,3,2,25,'DCP:01486','','alcon04.jpg','20040525135420-1-3-25.jpg',0,1),(1,3,2,30,'DCP:01483','','alcon01.jpg','20040526180054-1-3-30.jpg',0,1),(1,3,2,31,'alcon03.jpg','','alcon03.jpg','20040526180229-1-3-31.jpg',0,1),(1,3,2,32,'DCP:01487','','alcon05.jpg','20040526180229-1-3-32.jpg',0,1),(2,2,3,35,'shinshan.jpg','','shinshan.jpg','20040722233228-2-2-35.jpg',0,1),(1,10,4,36,'1496_2_abs-04.jpg','','1496_2_abs-04.jpg','20041229161246-1-10-36.jpg',0,0),(1,2,1,22,'33point3-a.jpeg','','33point3-a.jpeg','20040525120635-1-2-22.jpeg',0,0); UNLOCK TABLES; /*!40000 ALTER TABLE `ssproducts` ENABLE KEYS */; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `UserID` bigint(20) NOT NULL auto_increment, `UserName` char(20) NOT NULL default '', `Password` char(20) NOT NULL default '', `FullName` char(100) NOT NULL default '', `Position` char(100) NOT NULL default '', `MobileNum` char(100) NOT NULL default '', `DateCreated` date NOT NULL default '0000-00-00', `LastLog` datetime NOT NULL default '0000-00-00 00:00:00', `ModifiedBy` bigint(20) NOT NULL default '0', `Status` int(11) NOT NULL default '0', `Email` char(255) NOT NULL default '', `UserType` int(11) NOT NULL default '0', `lastActivity` datetime NOT NULL default '0000-00-00 00:00:00', `DateExpiry` date NOT NULL default '0000-00-00', PRIMARY KEY (`UserID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `users` -- /*!40000 ALTER TABLE `users` DISABLE KEYS */; LOCK TABLES `users` WRITE; INSERT INTO `users` VALUES (1,'kaiser','darkmatter','Qen','Empaces','','2004-05-20','2004-12-17 15:07:19',1,1,'q_empaces@yahoo.com',0,'2004-05-21 00:00:00','0000-00-00'),(2,'33point3','33point3','Cruz, Jennifer','General Manager','info@33point3.com','2004-05-21','2004-12-29 15:07:21',1,1,'will@eccp.com',2,'2004-10-08 00:00:00','0000-00-00'),(3,'alcon','alconind','Tan, David Johnson','President','','2004-05-21','2004-05-26 18:18:44',5,1,'aiigroup@mozcom.com',3,'2004-05-26 00:00:00','0000-00-00'),(4,'amarcas','amarcas','Sanchez, Clarence A.','VP - Operations','','2004-05-21','2004-05-26 17:36:44',4,1,'amarcas@cebu.pworld.net.ph',2,'2004-05-26 00:00:00','0000-00-00'),(5,'will','brelwit','Ng, Wilbert','','','2004-05-25','2005-03-01 19:01:54',6,1,'will@eccp.com',0,'2004-09-15 00:00:00','0000-00-00'),(6,'alain','alainjer','Coballes, Alain','Interface Designer - Web','','2004-12-29','2005-03-16 17:03:31',6,1,'alain@eccp.com',0,'2004-12-29 00:00:00','0000-00-00'),(7,'mike','mikemike','Alim, Mike','','','2004-05-25','0000-00-00 00:00:00',5,1,'mike@eccp.com',0,'2004-05-25 00:00:00','0000-00-00'),(8,'jecky','j3ckyk012n','Gaerlan, Jexter','','','2004-05-25','0000-00-00 00:00:00',5,1,'jex@eccp.com',0,'2004-05-25 00:00:00','0000-00-00'),(9,'admin','password','VTF Website Admin','VTF Website Admin','','2004-05-25','2005-03-01 19:03:29',5,1,'webmaster@virtual-fairs.com',0,'2005-03-01 00:00:00','0000-00-00'),(10,'test','test123','Lastname, Firstname','','werg','2004-05-27','2004-12-29 15:56:53',5,1,'will@eccp.com',1,'2004-12-29 00:00:00','2004-12-28'),(11,'pigs','pigs2004','Nana, Nunu','','','2004-09-15','0000-00-00 00:00:00',5,1,'webmaster@philippineinternationalgolfshow.com',2,'2004-09-15 00:00:00','2004-09-16'); UNLOCK TABLES; /*!40000 ALTER TABLE `users` ENABLE KEYS */; -- -- Table structure for table `vtfcat` -- DROP TABLE IF EXISTS `vtfcat`; CREATE TABLE `vtfcat` ( `CatID` bigint(20) NOT NULL auto_increment, `Name` char(100) NOT NULL default '', `Description` char(255) NOT NULL default '', PRIMARY KEY (`CatID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `vtfcat` -- /*!40000 ALTER TABLE `vtfcat` DISABLE KEYS */; LOCK TABLES `vtfcat` WRITE; INSERT INTO `vtfcat` VALUES (1,'Furniture & Furnishings','[Place category description here]'),(2,'Fashion & Beauty','[Place category description here]'),(3,'Travel & Tourism','[Place category description here]'),(4,'Construction','[Place category description here]'),(5,'Food & Beverages','[Place category description here]'),(6,'Gifts & Houseware','[Place category description here]'),(7,'Industrial','[Place category description here]'),(8,'IT & Communication','[Place category description here]'),(9,'Support Services','[Place category description here]'); UNLOCK TABLES; /*!40000 ALTER TABLE `vtfcat` ENABLE KEYS */; -- -- Table structure for table `vtfproducts` -- DROP TABLE IF EXISTS `vtfproducts`; CREATE TABLE `vtfproducts` ( `ProductID` bigint(20) NOT NULL auto_increment, `UserID` bigint(20) NOT NULL default '0', `CatID` bigint(20) NOT NULL default '0', `Name` char(100) NOT NULL default '', `Description` char(255) NOT NULL default '', `ImageName` char(100) NOT NULL default '', `ImageFile` char(100) NOT NULL default '', `Views` bigint(20) NOT NULL default '0', `Status` int(11) NOT NULL default '0', PRIMARY KEY (`ProductID`), FULLTEXT KEY `Fulltext` (`Name`,`Description`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `vtfproducts` -- /*!40000 ALTER TABLE `vtfproducts` DISABLE KEYS */; LOCK TABLES `vtfproducts` WRITE; INSERT INTO `vtfproducts` VALUES (82,10,1,'1496_2_abs-04.jpg','','1496_2_abs-04.jpg','20041229153224-1-10-82.jpg',0,1),(80,11,1,'catvisit.gif','','catvisit.gif','20040915143426-1-11-80.gif',0,1),(79,2,1,'200135874-001.jpg','','200135874-001.jpg','20040726111038-1-2-79.jpg',0,1),(81,10,1,'1496_2_abs-01.jpg','','1496_2_abs-01.jpg','20041229153224-1-10-81.jpg',0,1),(71,2,1,'33point3-c.jpeg','','33point3-c.jpeg','20040525111033-1-2-71.jpeg',0,1),(70,2,1,'33point3-b.jpeg','','33point3-b.jpeg','20040525111032-1-2-70.jpeg',0,1),(69,2,1,'33point3-a.jpeg','','33point3-a.jpeg','20040525111031-1-2-69.jpeg',0,1),(76,4,2,'amarcas03.jpg','','amarcas03.jpg','20040525153121-1-4-76.jpg',0,1),(75,4,2,'amarcas05.jpg','','amarcas05.jpg','20040525153120-1-4-75.jpg',0,1),(74,4,2,'amarcas02.jpg','','amarcas02.jpg','20040525153120-1-4-74.jpg',0,1),(77,4,2,'amarcas04.jpg','','amarcas04.jpg','20040525153654-1-4-77.jpg',0,1),(72,4,2,'amarcas01.jpg','','amarcas01.jpg','20040525153119-1-4-72.jpg',0,1); UNLOCK TABLES; /*!40000 ALTER TABLE `vtfproducts` ENABLE KEYS */; /*!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 */;