<?php if (isset($argc) && $argc > 0) { $docroot = "/var/www/vhosts/twextra.com/httpdocs"; } else { $docroot = $_SERVER['DOCUMENT_ROOT']; } $docroot = $_SERVER['DOCUMENT_ROOT']; require_once $docroot . "/config.php"; require_once $docroot . "/tw.lib.php"; require_once $docroot . "/models/twextra_model.php"; validate_access_twetest(); $database = "twextradb"; $database_info = "create database IF NOT EXISTS {$database};\n use {$database};"; $create_tw_token_table_stmt = "\nCREATE TABLE IF NOT EXISTS `tw_token` (\n `tid` int(10) unsigned NOT NULL default '0',\n `user_id_hash` varchar(100) NOT NULL,\n `oauth_token` varchar(100) NOT NULL default '''''',\n `oauth_token_secret` varchar(100) NOT NULL default '''''',\n `oauth_verifier` varchar(50) NOT NULL default '''''',\n `user_id` int(10) unsigned NOT NULL,\n `screen_name` varchar(50) NOT NULL default '''''',\n `name` varchar(25) NOT NULL default '''''',\n `location` varchar(40) NOT NULL default '''''',\n `description` varchar(200) NOT NULL default '''''',\n `user_image_url` varchar(255) NOT NULL default '''''',\n `created` timestamp NOT NULL default CURRENT_TIMESTAMP,\n PRIMARY KEY (`user_id`),\n UNIQUE KEY `user_id_hash` (`user_id_hash`),\n UNIQUE KEY `oauth_token` (`oauth_token`),\n UNIQUE KEY `screen_name` (`screen_name`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\n"; $create_msg_table_stmt = "\nCREATE TABLE IF NOT EXISTS `message` (\n `id` int(11) unsigned NOT NULL default '0',\n `tweet` text collate utf8_bin NOT NULL,\n `url` varchar(255) collate utf8_bin NOT NULL,\n `created` timestamp NOT NULL default CURRENT_TIMESTAMP,\n `view_count` int(11) unsigned NOT NULL default '0',\n `last_viewed` int(10) unsigned NOT NULL default '0',\n `remote_ip` char(16) collate utf8_bin default '000.000.000.000',\n `blocked` smallint(6) default '0',\n `tid` int(10) unsigned NOT NULL default '0',\n `user_id` int(10) unsigned NOT NULL default '0',\n `created_date` date NOT NULL default '0000-00-00',\n `message_id_reply` varchar(6) collate utf8_bin NOT NULL default '''''',\n `prefix` varchar(140) character set utf8 NOT NULL default '''''',\n `deleted` tinyint(4) NOT NULL default '0',\n PRIMARY KEY (`url`),\n KEY `created_date` (`created_date`),\n KEY `user_id` (`user_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;\n"; $model = new TwextraModel(); //$model->backupDbTwToken($database_info, $create_tw_token_table_stmt); sleep(5); $model->backupDbMessage($database_info, $create_msg_table_stmt); ?>