--
-- Host: localhost    Database: CWZ_dev
-- ------------------------------------------------------


--
-- Table structure for table `Account`
--

CREATE TABLE `Account` (
  `id` int NOT NULL AUTO_INCREMENT,
  `login` varchar(32) NOT NULL,
  `passwd` char(40) NOT NULL,
  `email` varchar(128) DEFAULT NULL,
  `joined` datetime DEFAULT NULL,
  `lastlog` datetime DEFAULT NULL,
  `tier` int DEFAULT NULL,
  `slots` int DEFAULT NULL,
  `codes` int DEFAULT NULL,
  `flags` varchar(400) DEFAULT NULL,
  `sess` varchar(400) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Account`
--

INSERT INTO `Account` VALUES (1,'cwzwhodi','54a270f9f25c325cbfdd52cdec9aeb89fcc0a945','aabad777@gmail.com','2022-02-19 00:49:19','2022-02-19 00:49:19',100,25,10,NULL,NULL),(2,'vader','34bcdf98deb05825ee8f40bad4b5912df89b0b95','darkvader0@live.com','2022-02-19 00:54:34','2022-02-19 00:54:34',100,25,10,NULL,'charnm:Chill22,squadnm:,slots:25,chat_chan:1,aid:0,created:2022-06-30 21,slot:22,pid:222,chat_lastmsg:1,con_lastmsg:740,login_id:2,pg:market.cgi,sid:0'),(6,'blu','fed8e0354adeaf7975ced5ca0c229e8222eaa95b','blu','2022-03-10 04:59:34','2022-03-10 04:59:34',1,1,0,NULL,NULL),(7,'fat','f684bcac2f0d38e3fcce2ae3309f7ff1eabcbfbe','aabad777@gmail.com','2022-03-10 14:45:41','2022-03-10 14:45:41',1,1,0,NULL,NULL),(8,'mcoons','2ef0ce7930e5588c5cdd5bce45882ba5c446763c','mc','2022-03-30 22:17:14','2022-03-30 22:17:14',1,1,0,NULL,NULL);

--
-- Table structure for table `Chat`
--

CREATE TABLE `Chat` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ts` datetime DEFAULT NULL,
  `chan` int DEFAULT NULL,
  `aid` int DEFAULT NULL,
  `sid` int DEFAULT NULL,
  `pid` int DEFAULT NULL,
  `msg` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Chat`
--

INSERT INTO `Chat` VALUES (1,'2022-05-24 22:15:29',1,NULL,NULL,NULL,'Test Message');

--
-- Table structure for table `Console`
--

CREATE TABLE `Console` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ts` datetime DEFAULT NULL,
  `chan` int DEFAULT NULL,
  `aid` int DEFAULT NULL,
  `sid` int DEFAULT NULL,
  `pid` int DEFAULT NULL,
  `msg` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=741 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Console`
--

INSERT INTO `Console` VALUES (1,'2022-06-30 17:20:38',0,0,0,0,'Test Message'),(479,'2022-06-30 21:50:50',4,0,0,207,'You\'ve increased your Funding by 34! Your Investors collect $235,000.00 in cash!   '),(480,'2022-06-30 22:13:17',4,0,0,207,'You\'ve increased your Funding by 28! Your Investors collect $235,000.00 in cash!   '),(481,'2022-06-30 21:50:51',4,0,0,207,'You\'ve increased your Funding by 28! Your Investors collect $235,000.00 in cash!   '),(482,'2022-06-30 21:50:52',4,0,0,207,'You\'ve increased your Funding by 12! Your Investors collect $235,000.00 in cash!   '),(483,'2022-06-30 21:50:52',4,0,0,207,'You\'ve increased your Funding by 20! Your Investors collect $235,000.00 in cash!   '),(484,'2022-06-30 21:50:52',4,0,0,207,'You\'ve increased your Funding by 28! Your Investors collect $235,000.00 in cash!   '),(485,'2022-06-30 21:50:52',4,0,0,207,'You\'ve increased your Funding by 27! Your Investors collect $235,000.00 in cash!   '),(486,'2022-06-30 21:50:52',4,0,0,207,'You\'ve increased your Funding by 18! Your Investors collect $235,000.00 in cash!   '),(487,'2022-06-30 21:50:55',4,0,0,206,'You\'ve increased your Funding by 18! Your Investors collect $235,000.00 in cash!   '),(488,'2022-06-30 21:50:56',4,0,0,206,'You\'ve increased your Funding by 15! Your Investors collect $235,000.00 in cash!   '),(489,'2022-06-30 21:50:56',4,0,0,206,'You\'ve increased your Funding by 23! Your Investors collect $235,000.00 in cash!   '),(490,'2022-06-30 21:50:56',4,0,0,206,'You\'ve increased your Funding by 20! Your Investors collect $235,000.00 in cash!   '),(491,'2022-06-30 21:51:01',4,0,0,205,'You\'ve increased your Funding by 10! Your Investors collect $235,000.00 in cash!   '),(492,'2022-06-30 21:51:02',4,0,0,205,'You\'ve increased your Funding by 15! Your Investors collect $235,000.00 in cash!   '),(493,'2022-06-30 21:51:02',4,0,0,205,'You\'ve increased your Funding by 23! Your Investors collect $235,000.00 in cash!   '),(494,'2022-06-30 21:51:02',4,0,0,205,'You\'ve increased your Funding by 24! Your Investors collect $235,000.00 in cash!   '),(495,'2022-06-30 21:51:05',4,0,0,208,'You\'ve increased your Funding by 24! Your Investors collect $235,000.00 in cash!   '),(496,'2022-06-30 21:51:05',4,0,0,208,'You\'ve increased your Funding by 21! Your Investors collect $235,000.00 in cash!   '),(497,'2022-06-30 21:51:08',4,0,0,209,'You\'ve increased your Funding by 34! Your Investors collect $235,000.00 in cash!   '),(498,'2022-06-30 21:51:08',4,0,0,209,'You\'ve increased your Funding by 20! Your Investors collect $235,000.00 in cash!   '),(499,'2022-07-01 07:59:59',4,0,0,202,'You\'ve increased your Funding by 22! Your Investors collect $235,000.00 in cash!   '),(500,'2022-07-01 07:59:59',4,0,0,202,'You\'ve increased your Funding by 35! Your Investors collect $235,000.00 in cash!   '),(501,'2022-07-01 08:00:02',4,0,0,203,'You\'ve increased your Funding by 11! Your Investors collect $235,000.00 in cash!   '),(502,'2022-07-01 08:00:02',4,0,0,203,'You\'ve increased your Funding by 27! Your Investors collect $235,000.00 in cash!   '),(503,'2022-07-01 08:00:02',4,0,0,203,'You\'ve increased your Funding by 34! Your Investors collect $235,000.00 in cash!   '),(504,'2022-07-01 08:00:05',4,0,0,204,'You\'ve increased your Funding by 19! Your Investors collect $235,000.00 in cash!   '),(505,'2022-07-01 08:00:05',4,0,0,204,'You\'ve increased your Funding by 21! Your Investors collect $235,000.00 in cash!   '),(506,'2022-07-01 08:00:05',4,0,0,204,'You\'ve increased your Funding by 28! Your Investors collect $235,000.00 in cash!   '),(507,'2022-07-01 08:00:06',4,0,0,204,'You\'ve increased your Funding by 31! Your Investors collect $235,000.00 in cash!   '),(508,'2022-07-01 08:00:08',4,0,0,205,'You\'ve increased your Funding by 20! Your Investors collect $235,000.00 in cash!   '),(509,'2022-07-01 08:00:08',4,0,0,205,'You\'ve increased your Funding by 19! Your Investors collect $235,000.00 in cash!   '),(510,'2022-07-01 08:00:09',4,0,0,205,'You\'ve increased your Funding by 23! Your Investors collect $235,000.00 in cash!   '),(511,'2022-07-01 08:00:09',4,0,0,205,'You\'ve increased your Funding by 13! Your Investors collect $235,000.00 in cash!   '),(512,'2022-07-01 08:00:09',4,0,0,205,'You\'ve increased your Funding by 14! Your Investors collect $235,000.00 in cash!   '),(513,'2022-07-01 08:00:17',4,0,0,201,'You\'ve increased your Funding by 29! Your Investors collect $235,000.00 in cash!   '),(514,'2022-07-01 14:10:40',4,0,0,210,'You\'ve increased your Strength by 33! Your Investors collect $235,000.00 in cash!   '),(515,'2022-07-01 14:10:40',4,0,0,210,'You\'ve increased your Strength by 35! Your Investors collect $235,000.00 in cash!   '),(516,'2022-07-01 14:10:41',4,0,0,210,'You\'ve increased your Strength by 30! Your Investors collect $235,000.00 in cash!   '),(517,'2022-07-01 14:10:41',4,0,0,210,'You\'ve increased your Strength by 20! Your Investors collect $235,000.00 in cash!   '),(518,'2022-07-01 14:10:41',4,0,0,210,'You\'ve increased your Strength by 29! Your Investors collect $235,000.00 in cash!   '),(519,'2022-07-01 14:10:41',4,0,0,210,'You\'ve increased your Strength by 15! Your Investors collect $235,000.00 in cash!   '),(520,'2022-07-01 14:10:44',4,0,0,209,'You\'ve increased your Strength by 21! Your Investors collect $235,000.00 in cash!   '),(521,'2022-07-01 14:33:14',4,0,0,211,'You\'ve increased your Strength by 33! Your Investors collect $235,000.00 in cash!   '),(522,'2022-07-01 14:10:47',4,0,0,211,'You\'ve increased your Strength by 24! Your Investors collect $235,000.00 in cash!   '),(523,'2022-07-01 14:10:47',4,0,0,211,'You\'ve increased your Strength by 18! Your Investors collect $235,000.00 in cash!   '),(524,'2022-07-01 14:10:50',4,0,0,212,'You\'ve increased your Strength by 16! Your Investors collect $235,000.00 in cash!   '),(525,'2022-07-01 14:10:51',4,0,0,212,'You\'ve increased your Strength by 16! Your Investors collect $235,000.00 in cash!   '),(526,'2022-07-01 14:10:52',4,0,0,212,'You\'ve increased your Strength by 31! Your Investors collect $235,000.00 in cash!   '),(527,'2022-07-01 14:10:57',4,0,0,213,'You\'ve increased your Strength by 33! Your Investors collect $235,000.00 in cash!   '),(528,'2022-07-01 14:33:24',4,0,0,213,'You\'ve increased your Strength by 29! Your Investors collect $235,000.00 in cash!   '),(529,'2022-07-01 14:10:57',4,0,0,213,'You\'ve increased your Strength by 25! Your Investors collect $235,000.00 in cash!   '),(530,'2022-07-01 14:11:00',4,0,0,214,'You\'ve increased your Strength by 27! Your Investors collect $235,000.00 in cash!   '),(531,'2022-07-01 14:11:01',4,0,0,214,'You\'ve increased your Strength by 16! Your Investors collect $235,000.00 in cash!   '),(532,'2022-07-01 14:11:01',4,0,0,214,'You\'ve increased your Strength by 27! Your Investors collect $235,000.00 in cash!   '),(533,'2022-07-01 14:11:01',4,0,0,214,'You\'ve increased your Strength by 24! Your Investors collect $235,000.00 in cash!   '),(534,'2022-07-01 14:11:08',4,0,0,215,'You\'ve increased your Strength by 22! Your Investors collect $235,000.00 in cash!   '),(535,'2022-07-01 14:11:08',4,0,0,215,'You\'ve increased your Strength by 31! Your Investors collect $235,000.00 in cash!   '),(536,'2022-07-01 14:11:08',4,0,0,215,'You\'ve increased your Strength by 35! Your Investors collect $235,000.00 in cash!   '),(537,'2022-07-01 14:11:15',4,0,0,216,'You\'ve increased your Strength by 20! Your Investors collect $235,000.00 in cash!   '),(538,'2022-07-01 14:11:21',4,0,0,217,'You\'ve increased your Strength by 28! Your Investors collect $235,000.00 in cash!   '),(539,'2022-07-01 14:11:21',4,0,0,217,'You\'ve increased your Strength by 11! Your Investors collect $235,000.00 in cash!   '),(540,'2022-07-01 14:11:21',4,0,0,217,'You\'ve increased your Strength by 17! Your Investors collect $235,000.00 in cash!   '),(541,'2022-07-01 14:11:25',4,0,0,218,'You\'ve increased your Strength by 25! Your Investors collect $235,000.00 in cash!   '),(542,'2022-07-01 14:11:25',4,0,0,218,'You\'ve increased your Strength by 30! Your Investors collect $235,000.00 in cash!   '),(543,'2022-07-01 14:12:27',4,0,0,220,'You\'ve increased your Strength by 27! Your Investors collect $235,000.00 in cash!   '),(544,'2022-07-01 14:34:54',4,0,0,220,'You\'ve increased your Strength by 34! Your Investors collect $235,000.00 in cash!   '),(545,'2022-07-01 14:12:27',4,0,0,220,'You\'ve increased your Strength by 11! Your Investors collect $235,000.00 in cash!   '),(546,'2022-07-01 14:12:30',4,0,0,221,'You\'ve increased your Strength by 27! Your Investors collect $235,000.00 in cash!   '),(547,'2022-07-01 14:12:31',4,0,0,221,'You\'ve increased your Strength by 24! Your Investors collect $235,000.00 in cash!   '),(548,'2022-07-01 14:12:31',4,0,0,221,'You\'ve increased your Strength by 24! Your Investors collect $235,000.00 in cash!   '),(549,'2022-07-01 14:12:37',4,0,0,221,'You\'ve increased your Strength by 11! Your Investors collect $235,000.00 in cash!   '),(550,'2022-07-01 14:12:37',4,0,0,221,'You\'ve increased your Strength by 14! Your Investors collect $235,000.00 in cash!   '),(551,'2022-07-01 14:12:37',4,0,0,221,'You\'ve increased your Strength by 25! Your Investors collect $235,000.00 in cash!   '),(552,'2022-07-01 14:35:04',4,0,0,221,'You\'ve increased your Strength by 13! Your Investors collect $235,000.00 in cash!   '),(553,'2022-07-01 14:12:37',4,0,0,221,'You\'ve increased your Strength by 24! Your Investors collect $235,000.00 in cash!   '),(554,'2022-07-01 14:12:37',4,0,0,221,'You\'ve increased your Strength by 20! Your Investors collect $235,000.00 in cash!   '),(555,'2022-07-01 14:12:37',4,0,0,221,'You\'ve increased your Strength by 11! Your Investors collect $235,000.00 in cash!   '),(556,'2022-07-01 14:12:38',4,0,0,221,'You\'ve increased your Strength by 19! Your Investors collect $235,000.00 in cash!   '),(557,'2022-07-01 14:12:38',4,0,0,221,'You\'ve increased your Strength by 25! Your Investors collect $235,000.00 in cash!   '),(558,'2022-07-01 14:12:38',4,0,0,221,'You\'ve increased your Strength by 30! Your Investors collect $235,000.00 in cash!   '),(559,'2022-07-01 14:12:38',4,0,0,221,'You\'ve increased your Strength by 12! Your Investors collect $235,000.00 in cash!   '),(560,'2022-07-01 14:12:38',4,0,0,221,'You\'ve increased your Strength by 12! Your Investors collect $235,000.00 in cash!   '),(561,'2022-07-01 14:12:38',4,0,0,221,'You\'ve increased your Strength by 22! Your Investors collect $235,000.00 in cash!   '),(562,'2022-07-01 14:12:41',4,0,0,222,'You\'ve increased your Strength by 33! Your Investors collect $235,000.00 in cash!   '),(563,'2022-07-01 14:12:42',4,0,0,222,'You\'ve increased your Strength by 18! Your Investors collect $235,000.00 in cash!   '),(564,'2022-07-01 14:12:42',4,0,0,222,'You\'ve increased your Strength by 19! Your Investors collect $235,000.00 in cash!   '),(565,'2022-07-01 14:12:42',4,0,0,222,'You\'ve increased your Strength by 33! Your Investors collect $235,000.00 in cash!   '),(566,'2022-07-01 14:12:42',4,0,0,222,'You\'ve increased your Strength by 28! Your Investors collect $235,000.00 in cash!   '),(567,'2022-07-01 14:12:42',4,0,0,222,'You\'ve increased your Strength by 32! Your Investors collect $235,000.00 in cash!   '),(568,'2022-07-01 14:12:42',4,0,0,222,'You\'ve increased your Strength by 29! Your Investors collect $235,000.00 in cash!   '),(569,'2022-07-01 14:12:42',4,0,0,222,'You\'ve increased your Strength by 27! Your Investors collect $235,000.00 in cash!   '),(570,'2022-07-01 14:12:43',4,0,0,222,'You\'ve increased your Strength by 27! Your Investors collect $235,000.00 in cash!   '),(571,'2022-07-01 14:12:45',4,0,0,223,'You\'ve increased your Strength by 15! Your Investors collect $235,000.00 in cash!   '),(572,'2022-07-01 14:12:45',4,0,0,223,'You\'ve increased your Strength by 11! Your Investors collect $235,000.00 in cash!   '),(573,'2022-07-01 14:12:45',4,0,0,223,'You\'ve increased your Strength by 11! Your Investors collect $235,000.00 in cash!   '),(574,'2022-07-01 14:12:46',4,0,0,223,'You\'ve increased your Strength by 14! Your Investors collect $235,000.00 in cash!   '),(575,'2022-07-01 14:12:46',4,0,0,223,'You\'ve increased your Strength by 17! Your Investors collect $235,000.00 in cash!   '),(576,'2022-07-01 14:12:46',4,0,0,223,'You\'ve increased your Strength by 14! Your Investors collect $235,000.00 in cash!   '),(577,'2022-07-01 14:12:46',4,0,0,223,'You\'ve increased your Strength by 33! Your Investors collect $235,000.00 in cash!   '),(578,'2022-07-01 14:12:46',4,0,0,223,'You\'ve increased your Strength by 16! Your Investors collect $235,000.00 in cash!   '),(579,'2022-07-01 14:12:46',4,0,0,223,'You\'ve increased your Strength by 11! Your Investors collect $235,000.00 in cash!   '),(580,'2022-07-01 15:10:18',4,0,0,219,'You\'ve increased your Strength by 31! Your Investors collect $235,000.00 in cash!   '),(581,'2022-07-01 15:32:45',4,0,0,219,'You\'ve increased your Strength by 32! Your Investors collect $235,000.00 in cash!   '),(582,'2022-07-06 22:14:47',4,0,1,201,'You sell all your coins for $111,468,087.00!'),(583,'2022-07-06 22:19:04',4,0,1,201,'You sell all your coins for $111,666,555.00!'),(584,'2022-07-06 22:19:04',4,0,1,201,'Transaction complete.  You purchase 670 units of Bitcoin for $0.00!'),(585,'2022-07-06 22:20:42',4,0,1,201,'You sell all your coins for $223,333,110.00!'),(586,'2022-07-06 22:43:24',4,0,1,201,'Transaction complete.  You purchase 1340 units of Bitcoin for $446,666,220.00!'),(587,'2022-07-06 22:21:05',4,0,1,201,'You sell all your coins for $446,666,220.00!'),(588,'2022-07-06 22:21:05',4,0,1,201,'Transaction complete.  You purchase 1340 units of Bitcoin for $446,666,220.00!'),(589,'2022-07-06 22:21:25',4,0,1,201,'You sell all your coins for $446,666,220.00!'),(590,'2022-07-06 22:21:25',4,0,1,201,'Transaction complete.  You purchase 1340 units of Bitcoin Warz for $446,666,220.00!'),(591,'2022-07-06 22:21:32',4,0,1,201,'You sell all your coins for $446,666,220.00!'),(592,'2022-07-06 22:21:32',4,0,1,201,'Transaction complete.  You purchase 211807 units of Fethereum for $446,700,963.00!'),(593,'2022-07-06 22:23:52',4,0,1,201,'You sell all your coins for $446,700,963.00!'),(594,'2022-07-06 22:23:52',4,0,1,201,'Transaction complete.  You purchase 211807 units of Fethereum for $446,700,963.00!'),(595,'2022-07-06 22:48:20',4,0,1,201,'You sell all your cryptocurrency for $446,700,963.00!'),(596,'2022-07-06 22:48:31',4,0,1,201,'Transaction complete.  You purchase 6115027 units of Trinance for $446,702,722.35!'),(597,'2022-07-06 22:50:50',4,0,1,201,'Transaction complete.  You purchase 1523 units of Bitcoin for $507,666,159.00!'),(598,'2022-07-06 22:51:00',4,0,1,201,'Transaction complete.  You purchase 6115027 units of Trinance for $507,852,992.35!'),(599,'2022-07-06 22:51:08',4,0,1,201,'Transaction complete.  You purchase 41055216 units of Gamelink for $507,853,021.92!'),(600,'2022-07-06 22:51:15',4,0,1,201,'Transaction complete.  You purchase 1523 units of Bitcoin Warz for $507,666,159.00!'),(601,'2022-07-06 22:52:10',4,0,1,201,'Transaction complete.  You purchase 1523 units of Bitcoin for $507,666,159.00!'),(602,'2022-07-08 10:16:29',4,0,1,202,'You\'ve increased your Strength by 264! Your Investors collect $2,350,000.00 in cash!   '),(603,'2022-07-08 10:16:30',4,0,1,202,'You\'ve increased your Strength by 346! Your Investors collect $2,350,000.00 in cash!   '),(604,'2022-07-08 10:16:31',4,0,1,202,'You\'ve increased your Strength by 236! Your Investors collect $2,350,000.00 in cash!   '),(605,'2022-07-08 10:16:31',4,0,1,202,'You\'ve increased your Strength by 323! Your Investors collect $2,350,000.00 in cash!   '),(606,'2022-07-08 10:16:50',4,0,1,202,'Transaction complete.  You purchase 10 units of Fethereum for $21,090.00!'),(607,'2022-07-08 10:17:02',4,0,1,202,'Transaction complete.  You purchase 10 units of Bitcoin Warz for $3,333,330.00!'),(608,'2022-07-08 10:17:13',4,0,1,202,'Transaction complete.  You purchase 10 units of Bitcoin for $3,333,330.00!'),(609,'2022-07-08 10:17:24',4,0,1,202,'Transaction complete.  You purchase 10 units of Logecoin for $0.72!'),(610,'2022-07-08 13:59:05',4,0,1,203,'Transaction complete.  You purchase 334 units of Fethereum for $704,406.00!'),(611,'2022-07-08 14:39:04',4,0,1,204,'Transaction complete.  You purchase 13146853 units of Logecoin for $939,999.99!'),(612,'2022-07-08 14:39:51',4,0,1,204,'Transaction complete.  You purchase 13146853 units of Logecoin for $939,999.99!'),(613,'2022-07-08 15:02:32',4,0,1,204,'Transaction complete.  You purchase 13146853 units of Logecoin for $939,999.99!'),(614,'2022-07-08 14:40:32',4,0,1,204,'Transaction complete.  You purchase 13146853 units of Logecoin for $939,999.99!'),(615,'2022-07-08 14:41:58',4,0,1,205,'Transaction complete.  You purchase 6 units of Bitcoin for $1,999,998.00!'),(616,'2022-07-08 14:43:10',4,0,1,206,'Transaction complete.  You purchase 75990 units of Gamelink for $939,996.30!'),(617,'2022-07-20 21:57:31',4,0,1,201,'You\'ve increased your Strength by 328! Your Investors collect $2,350,000.00 in cash!   '),(618,'2022-07-20 21:57:31',4,0,1,201,'You\'ve increased your Strength by 191! Your Investors collect $2,350,000.00 in cash!   '),(619,'2022-07-20 21:57:32',4,0,1,201,'You\'ve increased your Strength by 362! Your Investors collect $2,350,000.00 in cash!   '),(620,'2022-07-20 21:57:38',4,0,1,203,'You\'ve increased your Strength by 395! Your Investors collect $2,350,000.00 in cash!   '),(621,'2022-07-20 21:57:38',4,0,1,203,'You\'ve increased your Strength by 392! Your Investors collect $2,350,000.00 in cash!   '),(622,'2022-07-20 21:57:39',4,0,1,203,'You\'ve increased your Strength by 343! Your Investors collect $2,350,000.00 in cash!   '),(623,'2022-07-20 21:57:42',4,0,1,204,'You\'ve increased your Strength by 253! Your Investors collect $2,350,000.00 in cash!   '),(624,'2022-07-20 21:57:42',4,0,1,204,'You\'ve increased your Strength by 338! Your Investors collect $2,350,000.00 in cash!   '),(625,'2022-07-20 21:57:42',4,0,1,204,'You\'ve increased your Strength by 284! Your Investors collect $2,350,000.00 in cash!   '),(626,'2022-07-20 21:57:45',4,0,1,205,'You\'ve increased your Strength by 264! Your Investors collect $2,350,000.00 in cash!   '),(627,'2022-07-20 21:57:46',4,0,1,205,'You\'ve increased your Strength by 166! Your Investors collect $2,350,000.00 in cash!   '),(628,'2022-07-20 21:57:46',4,0,1,205,'You\'ve increased your Strength by 164! Your Investors collect $2,350,000.00 in cash!   '),(629,'2022-07-20 21:57:49',4,0,1,206,'You\'ve increased your Strength by 162! Your Investors collect $2,350,000.00 in cash!   '),(630,'2022-07-20 21:57:49',4,0,1,206,'You\'ve increased your Strength by 296! Your Investors collect $2,350,000.00 in cash!   '),(631,'2022-07-20 21:57:49',4,0,1,206,'You\'ve increased your Strength by 231! Your Investors collect $2,350,000.00 in cash!   '),(632,'2022-07-20 21:57:52',4,0,1,207,'You\'ve increased your Strength by 414! Your Investors collect $2,350,000.00 in cash!   '),(633,'2022-07-20 21:57:53',4,0,1,207,'You\'ve increased your Strength by 322! Your Investors collect $2,350,000.00 in cash!   '),(634,'2022-07-20 21:57:53',4,0,1,207,'You\'ve increased your Strength by 185! Your Investors collect $2,350,000.00 in cash!   '),(635,'2022-07-20 21:57:57',4,0,1,208,'You\'ve increased your Strength by 387! Your Investors collect $2,350,000.00 in cash!   '),(636,'2022-07-20 21:57:57',4,0,1,208,'You\'ve increased your Strength by 422! Your Investors collect $2,350,000.00 in cash!   '),(637,'2022-07-20 21:57:58',4,0,1,208,'You\'ve increased your Strength by 174! Your Investors collect $2,350,000.00 in cash!   '),(638,'2022-07-20 21:58:00',4,0,1,209,'You\'ve increased your Strength by 218! Your Investors collect $2,350,000.00 in cash!   '),(639,'2022-07-20 21:58:01',4,0,1,209,'You\'ve increased your Strength by 421! Your Investors collect $2,350,000.00 in cash!   '),(640,'2022-07-20 21:58:01',4,0,1,209,'You\'ve increased your Strength by 110! Your Investors collect $2,350,000.00 in cash!   '),(641,'2022-07-20 21:58:04',4,0,1,210,'You\'ve increased your Strength by 289! Your Investors collect $2,350,000.00 in cash!   '),(642,'2022-07-20 21:58:05',4,0,1,210,'You\'ve increased your Strength by 146! Your Investors collect $2,350,000.00 in cash!   '),(643,'2022-07-20 21:58:05',4,0,1,210,'You\'ve increased your Strength by 252! Your Investors collect $2,350,000.00 in cash!   '),(644,'2022-07-20 21:58:08',4,0,0,211,'You\'ve increased your Strength by 258! Your Investors collect $2,350,000.00 in cash!   '),(645,'2022-07-20 21:58:08',4,0,0,211,'You\'ve increased your Strength by 204! Your Investors collect $2,350,000.00 in cash!   '),(646,'2022-07-20 21:58:08',4,0,0,211,'You\'ve increased your Strength by 316! Your Investors collect $2,350,000.00 in cash!   '),(647,'2022-07-20 21:58:12',4,0,0,212,'You\'ve increased your Strength by 408! Your Investors collect $2,350,000.00 in cash!   '),(648,'2022-07-20 21:58:12',4,0,0,212,'You\'ve increased your Strength by 192! Your Investors collect $2,350,000.00 in cash!   '),(649,'2022-07-20 21:58:12',4,0,0,212,'You\'ve increased your Strength by 219! Your Investors collect $2,350,000.00 in cash!   '),(650,'2022-07-20 21:58:15',4,0,0,213,'You\'ve increased your Strength by 355! Your Investors collect $2,350,000.00 in cash!   '),(651,'2022-07-20 21:58:15',4,0,0,213,'You\'ve increased your Strength by 230! Your Investors collect $2,350,000.00 in cash!   '),(652,'2022-07-20 21:58:16',4,0,0,213,'You\'ve increased your Strength by 267! Your Investors collect $2,350,000.00 in cash!   '),(653,'2022-07-20 21:58:19',4,0,0,214,'You\'ve increased your Strength by 387! Your Investors collect $2,350,000.00 in cash!   '),(654,'2022-07-20 21:58:19',4,0,0,214,'You\'ve increased your Strength by 311! Your Investors collect $2,350,000.00 in cash!   '),(655,'2022-07-20 21:58:19',4,0,0,214,'You\'ve increased your Strength by 238! Your Investors collect $2,350,000.00 in cash!   '),(656,'2022-07-20 21:58:22',4,0,0,215,'You\'ve increased your Strength by 358! Your Investors collect $2,350,000.00 in cash!   '),(657,'2022-07-20 21:58:22',4,0,0,215,'You\'ve increased your Strength by 319! Your Investors collect $2,350,000.00 in cash!   '),(658,'2022-07-20 21:58:23',4,0,0,215,'You\'ve increased your Strength by 401! Your Investors collect $2,350,000.00 in cash!   '),(659,'2022-07-20 21:58:25',4,0,0,216,'You\'ve increased your Strength by 150! Your Investors collect $2,350,000.00 in cash!   '),(660,'2022-07-20 21:58:25',4,0,0,216,'You\'ve increased your Strength by 280! Your Investors collect $2,350,000.00 in cash!   '),(661,'2022-07-20 21:58:26',4,0,0,216,'You\'ve increased your Strength by 317! Your Investors collect $2,350,000.00 in cash!   '),(662,'2022-07-20 21:58:28',4,0,0,216,'You\'ve increased your Strength by 376! Your Investors collect $2,350,000.00 in cash!   '),(663,'2022-07-20 21:58:31',4,0,0,217,'You\'ve increased your Strength by 253! Your Investors collect $2,350,000.00 in cash!   '),(664,'2022-07-20 21:58:31',4,0,0,217,'You\'ve increased your Strength by 252! Your Investors collect $2,350,000.00 in cash!   '),(665,'2022-07-20 21:58:31',4,0,0,217,'You\'ve increased your Strength by 237! Your Investors collect $2,350,000.00 in cash!   '),(666,'2022-07-20 21:58:34',4,0,0,218,'You\'ve increased your Strength by 277! Your Investors collect $2,350,000.00 in cash!   '),(667,'2022-07-20 21:58:35',4,0,0,218,'You\'ve increased your Strength by 221! Your Investors collect $2,350,000.00 in cash!   '),(668,'2022-07-20 21:58:35',4,0,0,218,'You\'ve increased your Strength by 420! Your Investors collect $2,350,000.00 in cash!   '),(669,'2022-07-20 21:58:38',4,0,0,219,'You\'ve increased your Strength by 344! Your Investors collect $2,350,000.00 in cash!   '),(670,'2022-07-20 21:58:38',4,0,0,219,'You\'ve increased your Strength by 339! Your Investors collect $2,350,000.00 in cash!   '),(671,'2022-07-20 21:58:38',4,0,0,219,'You\'ve increased your Strength by 310! Your Investors collect $2,350,000.00 in cash!   '),(672,'2022-07-20 21:58:41',4,0,0,220,'You\'ve increased your Strength by 144! Your Investors collect $2,350,000.00 in cash!   '),(673,'2022-07-20 21:58:41',4,0,0,220,'You\'ve increased your Strength by 299! Your Investors collect $2,350,000.00 in cash!   '),(674,'2022-07-20 21:58:41',4,0,0,220,'You\'ve increased your Strength by 158! Your Investors collect $2,350,000.00 in cash!   '),(675,'2022-07-20 21:58:44',4,0,0,221,'You\'ve increased your Strength by 132! Your Investors collect $2,350,000.00 in cash!   '),(676,'2022-07-20 21:58:44',4,0,0,221,'You\'ve increased your Strength by 207! Your Investors collect $2,350,000.00 in cash!   '),(677,'2022-07-20 21:58:47',4,0,0,222,'You\'ve increased your Strength by 176! Your Investors collect $2,350,000.00 in cash!   '),(678,'2022-07-20 21:58:47',4,0,0,222,'You\'ve increased your Strength by 267! Your Investors collect $2,350,000.00 in cash!   '),(679,'2022-07-20 21:58:48',4,0,0,222,'You\'ve increased your Strength by 183! Your Investors collect $2,350,000.00 in cash!   '),(680,'2022-07-20 21:58:50',4,0,0,223,'You\'ve increased your Strength by 326! Your Investors collect $2,350,000.00 in cash!   '),(681,'2022-07-20 21:58:50',4,0,0,223,'You\'ve increased your Strength by 265! Your Investors collect $2,350,000.00 in cash!   '),(682,'2022-07-20 21:58:51',4,0,0,223,'You\'ve increased your Strength by 183! Your Investors collect $2,350,000.00 in cash!   '),(683,'2022-07-20 21:58:54',4,0,0,224,'You\'ve increased your Strength by 151! Your Investors collect $2,350,000.00 in cash!   '),(684,'2022-07-20 21:58:54',4,0,0,224,'You\'ve increased your Strength by 226! Your Investors collect $2,350,000.00 in cash!   '),(685,'2022-07-20 21:58:54',4,0,0,224,'You\'ve increased your Strength by 270! Your Investors collect $2,350,000.00 in cash!   '),(686,'2022-07-20 21:58:55',4,0,0,224,'You\'ve increased your Strength by 234! Your Investors collect $2,350,000.00 in cash!   '),(687,'2022-07-20 21:58:58',4,0,0,225,'You\'ve increased your Strength by 226! Your Investors collect $2,350,000.00 in cash!   '),(688,'2022-07-20 21:58:58',4,0,0,225,'You\'ve increased your Strength by 362! Your Investors collect $2,350,000.00 in cash!   '),(689,'2022-07-20 21:58:58',4,0,0,225,'You\'ve increased your Strength by 246! Your Investors collect $2,350,000.00 in cash!   '),(690,'2022-07-20 21:58:59',4,0,0,225,'You\'ve increased your Strength by 152! Your Investors collect $2,350,000.00 in cash!   '),(691,'2022-07-27 20:05:49',4,0,1,202,'Transaction complete.  You sell 10 units of Bitcoin Warz for $510,063.85!'),(692,'2022-07-27 20:22:51',4,0,1,202,'Transaction complete.  You purchase 10 units of Bitcoin Warz for $567,042.08!'),(693,'2022-07-27 20:25:08',4,0,1,202,'Transaction complete.  You purchase 1000 units of Astral for $155.08!'),(694,'2022-07-27 20:34:10',4,0,1,202,'Transaction complete.  You purchase 1000 units of Wave for $323.26!'),(695,'2022-07-27 20:35:46',4,0,1,201,'You\'ve increased your Strength by 1724! Your Investors collect $9,400,000.00 in cash!   '),(696,'2022-07-27 20:35:50',4,0,1,202,'You\'ve increased your Strength by 1968! Your Investors collect $9,400,000.00 in cash!   '),(697,'2022-07-27 20:35:53',4,0,1,203,'You\'ve increased your Strength by 2139! Your Investors collect $9,400,000.00 in cash!   '),(698,'2022-07-27 20:35:56',4,0,1,204,'You\'ve increased your Strength by 1124! Your Investors collect $9,400,000.00 in cash!   '),(699,'2022-07-27 20:35:59',4,0,1,205,'You\'ve increased your Strength by 1405! Your Investors collect $9,400,000.00 in cash!   '),(700,'2022-07-27 20:36:01',4,0,1,206,'You\'ve increased your Strength by 1747! Your Investors collect $9,400,000.00 in cash!   '),(701,'2022-07-27 20:36:03',4,0,1,207,'You\'ve increased your Strength by 2083! Your Investors collect $9,400,000.00 in cash!   '),(702,'2022-07-27 20:36:05',4,0,1,208,'You\'ve increased your Strength by 1964! Your Investors collect $9,400,000.00 in cash!   '),(703,'2022-07-27 20:36:07',4,0,1,209,'You\'ve increased your Strength by 2400! Your Investors collect $9,400,000.00 in cash!   '),(704,'2022-07-27 20:36:09',4,0,1,210,'You\'ve increased your Strength by 1181! Your Investors collect $9,400,000.00 in cash!   '),(705,'2022-07-27 20:36:12',4,0,0,211,'You\'ve increased your Strength by 1408! Your Investors collect $9,400,000.00 in cash!   '),(706,'2022-07-27 20:36:15',4,0,0,212,'You\'ve increased your Strength by 1659! Your Investors collect $9,400,000.00 in cash!   '),(707,'2022-07-27 20:36:18',4,0,0,213,'You\'ve increased your Strength by 1895! Your Investors collect $9,400,000.00 in cash!   '),(708,'2022-07-27 20:36:20',4,0,0,214,'You\'ve increased your Strength by 1880! Your Investors collect $9,400,000.00 in cash!   '),(709,'2022-07-27 20:36:23',4,0,0,215,'You\'ve increased your Strength by 1515! Your Investors collect $9,400,000.00 in cash!   '),(710,'2022-07-27 20:36:25',4,0,0,216,'You\'ve increased your Strength by 2198! Your Investors collect $9,400,000.00 in cash!   '),(711,'2022-07-27 20:36:28',4,0,0,217,'You\'ve increased your Strength by 2619! Your Investors collect $9,400,000.00 in cash!   '),(712,'2022-07-27 20:36:30',4,0,0,218,'You\'ve increased your Strength by 2378! Your Investors collect $9,400,000.00 in cash!   '),(713,'2022-07-27 20:36:32',4,0,0,219,'You\'ve increased your Strength by 1766! Your Investors collect $9,400,000.00 in cash!   '),(714,'2022-07-27 20:36:35',4,0,0,220,'You\'ve increased your Strength by 922! Your Investors collect $9,400,000.00 in cash!   '),(715,'2022-07-27 20:36:37',4,0,0,221,'You\'ve increased your Strength by 2435! Your Investors collect $9,400,000.00 in cash!   '),(716,'2022-07-27 20:36:40',4,0,0,222,'You\'ve increased your Strength by 1384! Your Investors collect $9,400,000.00 in cash!   '),(717,'2022-07-27 20:36:42',4,0,0,223,'You\'ve increased your Strength by 2435! Your Investors collect $9,400,000.00 in cash!   '),(718,'2022-07-27 20:36:44',4,0,0,224,'You\'ve increased your Strength by 1098! Your Investors collect $9,400,000.00 in cash!   '),(719,'2022-07-27 20:36:47',4,0,0,225,'You\'ve increased your Strength by 1452! Your Investors collect $9,400,000.00 in cash!   '),(720,'2022-07-27 20:38:09',4,0,0,225,'Transaction complete.  You purchase 501786 units of Unibrow for $18,799,973.06!'),(721,'2022-07-27 20:38:13',4,0,0,224,'Transaction complete.  You purchase 58009962 units of Wave for $18,799,999.83!'),(722,'2022-07-27 20:38:15',4,0,0,223,'Transaction complete.  You purchase 207338030 units of Logecoin for $18,564,999.97!'),(723,'2022-07-27 20:38:18',4,0,0,222,'Transaction complete.  You purchase 577133 units of Gamelink for $18,564,968.19!'),(724,'2022-07-27 20:38:21',4,0,0,221,'Transaction complete.  You purchase 555217 units of Gamelink for $17,859,983.65!'),(725,'2022-07-27 20:38:25',4,0,0,220,'Transaction complete.  You purchase 110483 units of Likecoin for $17,154,966.00!'),(726,'2022-07-27 21:01:13',4,0,0,219,'Transaction complete.  You purchase 108969 units of Likecoin for $16,919,883.51!'),(727,'2022-07-27 20:38:39',4,0,0,218,'Transaction complete.  You purchase 17415811 units of Bether for $16,919,999.75!'),(728,'2022-07-27 20:38:42',4,0,0,217,'Transaction complete.  You purchase 49773 units of Trinance for $17,154,904.38!'),(729,'2022-07-27 20:38:44',4,0,0,216,'Transaction complete.  You purchase 4706 units of Fethereum for $19,033,546.06!'),(730,'2022-07-27 20:38:49',4,0,0,215,'Transaction complete.  You purchase 4241 units of Fethereum for $17,152,840.81!'),(731,'2022-07-27 20:43:35',4,0,0,214,'Transaction complete.  You purchase 304 units of Bitcoin Warz for $17,353,012.13!'),(732,'2022-07-27 20:43:50',4,0,0,214,'Transaction complete.  You purchase 304 units of Bitcoin Warz for $17,353,012.13!'),(733,'2022-07-27 20:46:34',4,0,0,213,'Transaction complete.  You purchase 4229 units of Fethereum for $17,154,867.88!'),(734,'2022-07-27 20:46:40',4,0,0,212,'Transaction complete.  You purchase 49803 units of Trinance for $17,154,838.58!'),(735,'2022-07-27 20:46:50',4,0,0,211,'Transaction complete.  You purchase 17743363 units of Bether for $17,154,999.81!'),(736,'2022-07-27 20:58:10',4,0,1,202,'You\'ve increased your Funding by 1! Your Investors collect $23,500.00 in cash!   '),(737,'2022-07-29 01:29:24',4,0,0,225,'Transaction complete.  You purchase 180723 units of Gamelink for $6,367,043.47!'),(738,'2022-07-29 01:29:27',4,0,0,224,'Transaction complete.  You purchase 1632713 units of Gamelink for $57,522,034.50!'),(739,'2022-07-29 01:29:30',4,0,0,223,'Transaction complete.  You purchase 518640 units of Gamelink for $18,272,181.32!'),(740,'2022-07-29 01:29:33',4,0,0,222,'Transaction complete.  You purchase 577133 units of Gamelink for $20,332,945.43!');

--
-- Table structure for table `Crypto_Game`
--

CREATE TABLE `Crypto_Game` (
  `cd` int NOT NULL,
  `shortnm` varchar(8) DEFAULT NULL,
  `longnm` varchar(20) DEFAULT NULL,
  `price_now` double DEFAULT NULL,
  `price_ref` double DEFAULT NULL,
  `price_min` double DEFAULT NULL,
  `price_max` double DEFAULT NULL,
  `delta_base` double DEFAULT NULL,
  `delta_fluc` double DEFAULT NULL,
  `unit_vol` bigint DEFAULT NULL,
  `unit_ref` bigint DEFAULT NULL,
  PRIMARY KEY (`cd`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Crypto_Game`
--

INSERT INTO `Crypto_Game` VALUES (1,'BTCW','Bitcoin Warz',34536.12233073246,34677.89092329059,20000,69420,-0.00017031690042037728,-0,314,314),(2,'FETH','Fethereum',5629.842732780247,5522.651302163107,1337,8008,0.000741703939048926,0,13520,13520),(3,'TNT','Trinance',200.28360555605377,203.42695534719007,68.2,420.65,-0.000646735828219095,-0,99576,99576),(4,'USDB','Bether',1,1,0.91,1.01,0,0,35159174,35159174),(5,'LKC','Likecoin',157.2743423537865,171.5726657231055,68.2,420.65,-0.08974935955050946,-0,219452,219452),(6,'AST','Astral',0.11981662218262012,0.1191010545027251,0.1007,0.6942,0.00025112811776732165,0,1000,1000),(7,'GINK','Gamelink',32.32960516715264,32.474436761520906,8.45,42.05,-0.00018636173379532102,-0,3540416,3540416),(8,'LOGE','Logecoin',0.04226043190948422,0.04350920198151969,0.042,0.2325,-0.0012140273676867711,-0,13146863,13146863),(9,'XWP','Wave',0.8203190872936041,0.8265080514922153,0.1785,1.25,-0.00031350859043760305,-0,1000,1000),(10,'BROW','Unibrow',9.329017580390097,9.287178422706058,6.12,40.87,0.00018669158529127387,0,0,0);

--
-- Table structure for table `Crypto_Hist`
--

CREATE TABLE `Crypto_Hist` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ts` datetime DEFAULT NULL,
  `cd` int DEFAULT NULL,
  `price_then` double DEFAULT NULL,
  `units` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Crypto_Hist`
--


--
-- Table structure for table `Crypto_Live`
--

CREATE TABLE `Crypto_Live` (
  `cd` int NOT NULL,
  `shortnm` varchar(8) DEFAULT NULL,
  `longnm` varchar(20) DEFAULT NULL,
  `price_now` double DEFAULT NULL,
  `price_ref` double DEFAULT NULL,
  `price_min` double DEFAULT NULL,
  `price_max` double DEFAULT NULL,
  `delta_base` double DEFAULT NULL,
  `delta_fluc` double DEFAULT NULL,
  `unit_vol` bigint DEFAULT NULL,
  `unit_ref` bigint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Crypto_Live`
--

INSERT INTO `Crypto_Live` VALUES (11,'BTC','Bitcoin',333333,333333,30000,60000,0.01,NULL,0,NULL);

--
-- Table structure for table `Crypto_News`
--

CREATE TABLE `Crypto_News` (
  `id` int NOT NULL AUTO_INCREMENT,
  `news` varchar(2048) DEFAULT NULL,
  `wgt` int DEFAULT NULL,
  `efx` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Crypto_News`
--

INSERT INTO `Crypto_News` VALUES (3,'China announces that Bitcoin has been banned for the 420th time. Investors hands shatter as the entire crypto market plummets.',300,'BTCW:=-1.1*0.5,FETH:=-1.8,TNT:=-3.43,LKC:=-2.15,AST:=-1.83,GINK:-1*0.3,LOGE:=-7.35,XWP:=-5.7,BROW:=-3.1'),(4,'Melon Tusk tweeted \"If Logecoin hits $1 Million per token, I will eat my own genitals\" the coin has surged since his announcement.',100,'FETH:+0.25,LKC:=+0.34,AST:=+1.8,GINK:=+1.6,LOGE:+4.3,XWP:=-0.9'),(5,'South Parks future episode showed crypto prices in the year 2045. Already confused investors rave good reviews which as increase demand in the entire crypto space.',300,'BTCW:=+2.2,FETH:=+2.4*0.8,TNT:+1.7,LKC:=+1.3,AST:=+2.2,GINK:+2.2,LOGE:=+1.6,XWP:=+1.7,BROW:+1.1*1'),(6,'Ghost Hunters claim to have found the spirit of John McAfee next to a jar containing...a one-eyed trouser snake. Instead of leaving the spirit be, the hunters attempt to communicate. The spirit is restless and unwilling to participate. In a final attempt, the hunters grab the jar and the McAfee ghost unleashes his fury by taking everyones phone and tweeting \"Fethereum to 50k or I eat my phantom menace on GhostTube\".',200,'BTCW:=+0.14,FETH:=+4.2,TNT:=+1.6,LKC:=+0.78,AST:=+0.24,GINK:=+1.3,BROW:=+1.2'),(7,'Satoshi emerges for the first time. His git commit message states FUNDS ARE SAFU. The entire crypto market has paused.',399,'BTCW:=0,FETH:=0,TNT:=0,LKC:=0,AST:=0,GINK:0,LOGE:=0,XWP:=0,BROW:=0'),(8,'As El Salvador becomes the next crypto utopia, President Bukele sets focus on his next target. He announces that they will use Meteor Power to mine Astral coin. The coin gains momentum. ',100,'AST:=+2.2*2,BROW:+0.6'),(9,'Gamelink has announced partnership with Google, Amazon, Apple, NASA, Walmart, Tesla, and the American Government, the price slightly goes up. ',100,'GINK:=+1'),(10,'Genius, billionaire, playboy, philanthropist Italik Bolderin, creator of Fethereum, has reported that he...is...Miner Man. Fethereum fans go wild and the price flies. ',100,'BTCW:+0.5,FETH:=+5.4*2,LKC:+0.2,AST:=+.6,GINK:+0.5'),(11,'Logecoin creator briefs reporter that people who invest in LOGE are idiots. As the report airs, people catch wind and buy more.',100,'FETH:-0.6,LOGE:=+0.8');

--
-- Table structure for table `Crypto_Reel`
--

CREATE TABLE `Crypto_Reel` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ts` datetime DEFAULT NULL,
  `news_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Crypto_Reel`
--

INSERT INTO `Crypto_Reel` VALUES (1,'2022-07-27 22:41:42',3),(2,'2022-07-27 22:41:51',9),(3,'2022-07-27 22:42:04',8),(4,'2022-07-29 01:06:44',9),(5,'2022-07-29 01:21:01',9),(6,'2022-07-29 01:39:09',11),(7,'2022-07-29 02:14:01',3),(8,'2022-07-29 02:32:01',6),(9,'2022-07-29 03:16:01',4),(10,'2022-07-29 03:42:01',11),(11,'2022-07-29 04:09:01',6),(12,'2022-07-29 04:28:02',9),(13,'2022-07-29 04:29:01',4),(14,'2022-07-29 05:06:01',3),(15,'2022-07-29 05:19:01',8),(16,'2022-07-29 05:34:01',10),(17,'2022-07-29 06:01:01',10),(18,'2022-07-29 06:28:01',8),(19,'2022-07-29 06:54:01',5),(20,'2022-07-29 07:10:01',10),(21,'2022-07-29 07:18:02',9),(22,'2022-07-29 07:49:01',6),(23,'2022-07-29 07:58:01',10),(24,'2022-07-29 08:15:01',11),(25,'2022-07-29 08:20:01',3),(26,'2022-07-29 08:58:01',9),(27,'2022-07-29 09:15:02',10),(28,'2022-07-29 09:37:01',8),(29,'2022-07-29 09:43:01',8),(30,'2022-07-29 09:51:01',8),(31,'2022-07-29 10:07:01',3),(32,'2022-07-29 10:24:02',10),(33,'2022-07-29 10:33:01',8),(34,'2022-07-29 11:05:01',10);

--
-- Table structure for table `Holding`
--

CREATE TABLE `Holding` (
  `cd` int NOT NULL,
  `shortnm` varchar(8) DEFAULT NULL,
  `longnm` varchar(20) DEFAULT NULL,
  `init` int DEFAULT NULL,
  `max` int DEFAULT NULL,
  `cost` double DEFAULT NULL,
  PRIMARY KEY (`cd`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Holding`
--

INSERT INTO `Holding` VALUES (1,'node','Staking Nodes',50,500,5000000),(2,'mfac','Mining Facilities',25,250,10000000),(3,'jets','Private Jets',0,40,100000000);

--
-- Table structure for table `Location`
--

CREATE TABLE `Location` (
  `id` int NOT NULL,
  `shortnm` char(4) DEFAULT NULL,
  `longnm` varchar(20) DEFAULT NULL,
  `bonus_mult` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Location`
--

INSERT INTO `Location` VALUES (1,'SF','San Francisco',0),(2,'NY','New York',0),(3,'MIA','Miami',0),(4,'VBC','Vancouver',0),(5,'LDN','London',0),(6,'HK','Hong Kong',0),(7,'AMS','Amsterdam',0),(8,'ELSL','El Salvador',0),(9,'MSK','Moscow',0);

--
-- Table structure for table `Player`
--

CREATE TABLE `Player` (
  `login_id` int NOT NULL,
  `pid` int NOT NULL,
  `sid` int DEFAULT NULL,
  `slot` int DEFAULT NULL,
  `charnm` varchar(16) NOT NULL,
  `chartag` varchar(40) DEFAULT NULL,
  `loc` int DEFAULT NULL,
  `glob_rank` int DEFAULT NULL,
  `loc_rank` int DEFAULT NULL,
  `turns` int DEFAULT NULL,
  `turns_queue` int DEFAULT NULL,
  `turns_faucet` int DEFAULT NULL,
  `outs` int DEFAULT NULL,
  `ins` int DEFAULT NULL,
  `market` double DEFAULT NULL,
  `cash` double DEFAULT NULL,
  `bank` double DEFAULT NULL,
  `sk_funding` int DEFAULT NULL,
  `sk_strength` int DEFAULT NULL,
  `sk_marketing` int DEFAULT NULL,
  `sk_techanal` int DEFAULT NULL,
  `sk_intuition` int DEFAULT NULL,
  `sk_cunning` int DEFAULT NULL,
  `sk_debate` int DEFAULT NULL,
  `sk_re` int DEFAULT NULL,
  `upg_insurance` int DEFAULT NULL,
  `upg_accountant` int DEFAULT NULL,
  `upg_degree` int DEFAULT NULL,
  `upg_advert` int DEFAULT NULL,
  `upg_lawyer` int DEFAULT NULL,
  `upg_rally` int DEFAULT NULL,
  `f_newb` int DEFAULT NULL,
  `f_hodler` int DEFAULT NULL,
  `f_whale` int DEFAULT NULL,
  `f_shill` int DEFAULT NULL,
  `f_youtuber` int DEFAULT NULL,
  `f_redditor` int DEFAULT NULL,
  `f_anon` int DEFAULT NULL,
  `f_karen` int DEFAULT NULL,
  `f_reporter` int DEFAULT NULL,
  `f_politician` int DEFAULT NULL,
  `it_fails` int DEFAULT NULL,
  `it_by` varchar(16) DEFAULT NULL,
  `it_exp` int DEFAULT NULL,
  `51_fails` int DEFAULT NULL,
  `51_by` varchar(16) DEFAULT NULL,
  `51_exp` int DEFAULT NULL,
  `fud_fails` int DEFAULT NULL,
  `fud_by` varchar(16) DEFAULT NULL,
  `fud_exp` int DEFAULT NULL,
  `att_won` int DEFAULT NULL,
  `att_lost` int DEFAULT NULL,
  `investors_killed` int DEFAULT NULL,
  `shills_killed` int DEFAULT NULL,
  `def_kills` int DEFAULT NULL,
  `loot_stole` double DEFAULT NULL,
  `influencers_stole` int DEFAULT NULL,
  `doubters_stole` int DEFAULT NULL,
  `flight_exp` int DEFAULT NULL,
  `casopt` int DEFAULT NULL,
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Player`
--

INSERT INTO `Player` VALUES (2,201,1,1,'Chill01',NULL,1,0,0,3385,0,0,0,0,804592870.0959258,16636863.0000002,0,48,2628,2,5,18,14,17,2,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-255600,0,'',-255600,0,'',-255600,0,0,0,0,0,0,0,0,0,0),(2,202,1,2,'Chill02',NULL,1,0,0,3375,0,0,0,0,804592870.0959258,12038228.8652854,0,106,3162,12,12,4,2,20,12,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-295560,0,'',-295560,0,'',-295560,0,0,0,0,0,0,0,0,0,0),(2,203,1,3,'Chill03',NULL,1,0,0,3385,0,0,0,0,804592870.0959258,16450594,0,75,3292,2,4,15,0,17,3,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-262800,0,'',-262800,0,'',-262800,0,0,0,0,0,0,0,0,0,0),(2,204,1,4,'Chill04',NULL,1,0,0,3385,0,0,0,0,804592870.0959258,16450000.0105,0,111,2038,4,11,4,5,16,4,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-266400,0,'',-266400,0,'',-266400,0,0,0,0,0,0,0,0,0,0),(2,205,1,5,'Chill05',NULL,1,0,0,3385,0,0,0,0,804592870.0959258,16565002,0,191,2020,6,3,16,14,3,10,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-284400,0,'',-284400,0,'',-284400,0,0,0,0,0,0,0,0,0,0),(2,206,1,6,'Chill06',NULL,1,0,0,3385,0,0,0,0,804592870.0959258,16450003.7,0,82,2441,3,11,4,6,19,16,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-266400,0,'',-266400,0,'',-266400,0,0,0,0,0,0,0,0,0,0),(2,207,1,7,'Chill07',NULL,1,0,0,3385,0,0,0,0,804592870.0959258,18330000,0,209,3050,15,19,11,16,10,1,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-280800,0,'',-280800,0,'',-280800,0,0,0,0,0,0,0,0,0,0),(2,208,1,8,'Chill08',NULL,1,0,0,3385,0,0,0,0,804592870.0959258,16920000,0,85,2990,17,11,8,5,2,13,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-259200,0,'',-259200,0,'',-259200,0,0,0,0,0,0,0,0,0,0),(2,209,1,9,'Chill09',NULL,1,0,0,3385,0,0,0,0,804592870.0959258,17155000,0,102,3216,13,10,13,14,13,20,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-262800,0,'',-262800,0,'',-262800,0,0,0,0,0,0,0,0,0,0),(2,210,1,10,'Chill10',NULL,1,0,0,3385,0,0,0,0,804592870.0959258,17860000,0,3,2046,8,3,9,15,10,5,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-273600,0,'',-273600,0,'',-273600,0,0,0,0,0,0,0,0,0,0),(2,211,NULL,11,'Chill11',NULL,1,0,0,3385,0,0,0,0,804592870.0959258,0.194473218172789,0,38,2264,20,16,0,14,7,16,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-262800,0,'',-262800,0,'',-262800,0,0,0,0,0,0,0,0,0,0),(2,212,NULL,12,'Chill12',NULL,1,0,0,3385,0,0,0,0,804592870.0959258,161.415534220636,0,40,2575,20,17,8,7,10,9,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-262800,0,'',-262800,0,'',-262800,0,0,0,0,0,0,0,0,0,0),(2,213,NULL,13,'Chill13',NULL,1,0,0,3385,0,0,0,0,804592870.0959258,132.118598971516,0,45,2836,10,10,17,14,2,8,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-262800,0,'',-262800,0,'',-262800,0,0,0,0,0,0,0,0,0,0),(2,214,NULL,14,'Chill14',NULL,1,0,0,3385,0,0,0,0,804592870.0959258,36987.8709161021,0,30,2951,6,3,14,4,17,12,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-266400,0,'',-266400,0,'',-266400,0,0,0,0,0,0,0,0,0,0),(2,215,NULL,15,'Chill15',NULL,1,0,0,3385,0,0,0,0,804592870.0959258,2159.1893824935,0,22,2703,17,18,19,3,18,1,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-262800,0,'',-262800,0,'',-262800,0,0,0,0,0,0,0,0,0,0),(2,216,NULL,16,'Chill16',NULL,1,0,0,3385,0,0,0,0,804592870.0959258,1453.9366267398,0,24,3357,2,13,17,5,14,16,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-291600,0,'',-291600,0,'',-291600,0,0,0,0,0,0,0,0,0,0),(2,217,NULL,17,'Chill17',NULL,1,0,0,3385,0,0,0,0,804592870.0959258,95.6163874194026,0,46,3424,20,11,13,13,8,19,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-262800,0,'',-262800,0,'',-262800,0,0,0,0,0,0,0,0,0,0),(2,218,NULL,18,'Chill18',NULL,1,0,0,3385,0,0,0,0,804592870.0959258,0.2508245408535,0,26,3389,5,18,17,9,15,10,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-259200,0,'',-259200,0,'',-259200,0,0,0,0,0,0,0,0,0,0),(2,219,NULL,19,'Chill19',NULL,1,0,0,3385,0,0,0,0,804592870.0959258,116.486173529178,0,9,2840,7,11,14,17,2,0,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-259200,0,'',-259200,0,'',-259200,0,0,0,0,0,0,0,0,0,0),(2,220,NULL,20,'Chill20',NULL,1,0,0,3385,0,0,0,0,804592870.0959258,33.9981270842254,0,37,1628,2,10,6,19,15,19,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-262800,0,'',-262800,0,'',-262800,0,0,0,0,0,0,0,0,0,0),(2,221,NULL,21,'Chill21',NULL,1,0,0,3385,0,0,0,0,804592870.0959258,16.3540876358747,0,24,3115,8,5,1,11,11,1,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-273600,0,'',-273600,0,'',-273600,0,0,0,0,0,0,0,0,0,0),(2,222,NULL,22,'Chill22',NULL,1,0,0,3385,0,0,0,0,804592870.0959258,31.8136577866971,0,29,2294,2,2,7,8,18,5,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-284400,0,'',-284400,0,'',-284400,0,0,0,0,0,0,0,0,0,0),(2,223,NULL,23,'Chill23',NULL,1,0,0,3385,0,0,0,0,804592870.0959258,30.9217273667455,0,30,3365,12,3,0,11,14,17,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-284400,0,'',-284400,0,'',-284400,0,0,0,0,0,0,0,0,0,0),(2,224,NULL,24,'Chill24',NULL,1,0,0,3385,0,0,0,0,804592870.0959258,30.5201055556536,0,3,2019,17,17,13,16,19,9,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-288000,0,'',-288000,0,'',-288000,0,0,0,0,0,0,0,0,0,0),(2,225,NULL,25,'Chill25',NULL,1,0,0,3385,0,0,0,0,804592870.0959258,15.5256605679169,0,17,2458,18,9,9,18,1,14,0,0,0,0,0,0,6000,5000,4000,0,0,0,0,0,0,0,0,'',-288000,0,'',-288000,0,'',-288000,0,0,0,0,0,0,0,0,0,0);

--
-- Table structure for table `Player_Crypto`
--

CREATE TABLE `Player_Crypto` (
  `pid` int DEFAULT NULL,
  `cd` int DEFAULT NULL,
  `units` bigint DEFAULT NULL,
  `basis` double DEFAULT NULL,
  UNIQUE KEY `pid` (`pid`,`cd`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Player_Crypto`
--

INSERT INTO `Player_Crypto` VALUES (201,11,1523,507666159),(202,2,10,21090),(202,11,10,3333330),(202,8,10,0.715),(203,2,334,704406),(204,8,13146853,939999.9895),(205,11,6,1999998),(206,7,75990,939996.3),(202,1,10,567042.080135937),(202,6,1000,155.079555642599),(202,9,1000,323.260023045427),(221,7,555217,17859983.6459124),(220,5,110483,17154966.0018729),(219,5,108969,16919883.5138265),(218,4,17415811,16919999.7491755),(217,3,49773,17154904.3836126),(216,2,4706,19033546.0633733),(215,2,4241,17152840.8106175),(214,1,304,17353012.1290838),(213,2,4229,17154867.881401),(212,3,49803,17154838.5844658),(211,4,17743363,17154999.8055268),(225,7,180723,6367043.46723455),(224,7,1632713,57522034.4976507),(223,7,518640,18272181.3153086),(222,7,577133,20332945.432377);

--
-- Table structure for table `Session`
--

CREATE TABLE `Session` (
  `sess_hash` char(32) NOT NULL,
  `login_id` int DEFAULT NULL,
  PRIMARY KEY (`sess_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Session`
--

INSERT INTO `Session` VALUES ('375CF278FDBB280A53BA21421B077FD4',2),('4A5AE51080F02F11412292D847C9BDFA',2),('556D4E6CA2D6788B625386F96463F396',6),('6F2A261A9AB92233C5BABACCE8DD1E91',2),('DCC76752AF84E32FA39457C98500E446',2),('FD187FC3D680A43B6AB307C7E48256CB',2);

--
-- Table structure for table `Squad`
--

CREATE TABLE `Squad` (
  `sid` int NOT NULL AUTO_INCREMENT,
  `squadnm` varchar(16) DEFAULT NULL,
  `youtube` varchar(20) DEFAULT NULL,
  `godfather` varchar(16) DEFAULT NULL,
  `underboss` varchar(16) DEFAULT NULL,
  `myfriends` varchar(400) DEFAULT NULL,
  `myenemies` varchar(400) DEFAULT NULL,
  `myignore` varchar(400) DEFAULT NULL,
  `bank` double DEFAULT NULL,
  `att_won` int DEFAULT NULL,
  `att_lost` int DEFAULT NULL,
  `investors_killed` int DEFAULT NULL,
  `shills_killed` int DEFAULT NULL,
  `def_kills` int DEFAULT NULL,
  `loot_stole` double DEFAULT NULL,
  `influencers_stole` int DEFAULT NULL,
  `doubters_stole` int DEFAULT NULL,
  PRIMARY KEY (`sid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Squad`
--

INSERT INTO `Squad` VALUES (1,'Saturnine',NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,0,0,0),(2,'Tthugs',NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,0,0,0);

--
-- Table structure for table `Squad_Holding`
--

CREATE TABLE `Squad_Holding` (
  `sid` int DEFAULT NULL,
  `cd` int DEFAULT NULL,
  `loc` int DEFAULT NULL,
  `amt` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Squad_Holding`
--


--
-- Table structure for table `Squad_Rank`
--

CREATE TABLE `Squad_Rank` (
  `sid` int DEFAULT NULL,
  `loc` int DEFAULT NULL,
  `val` double DEFAULT NULL,
  `hourly_pct` double DEFAULT NULL,
  `daily_pct` double DEFAULT NULL,
  `hourly_ref` double DEFAULT NULL,
  `daily_ref` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Squad_Rank`
--



