--
-- Host: localhost    Database: indigo
-- ------------------------------------------------------


--
-- Table structure for table `admin_messages`
--

CREATE TABLE `admin_messages` (
  `admin_id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_type` int(11) NOT NULL,
  `admin_text` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `admin_to` int(11) NOT NULL,
  `admin_by` int(11) NOT NULL,
  `admin_post` int(11) NOT NULL,
  `is_reply` int(11) NOT NULL,
  `admin_date` datetime NOT NULL DEFAULT current_timestamp(),
  `admin_read` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`admin_id`),
  KEY `admin_by` (`admin_by`),
  KEY `admin_by_2` (`admin_by`),
  KEY `admin_to` (`admin_to`),
  KEY `admin_post` (`admin_post`),
  CONSTRAINT `admin_messages_ibfk_1` FOREIGN KEY (`admin_to`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `admin_messages_ibfk_2` FOREIGN KEY (`admin_by`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `admin_messages`
--

INSERT INTO `admin_messages` VALUES (1,1,NULL,2759,2748,11299454,0,'2025-09-26 04:28:48',0);

--
-- Table structure for table `favorite_titles`
--

CREATE TABLE `favorite_titles` (
  `fav_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `title_id` int(11) NOT NULL,
  PRIMARY KEY (`fav_id`),
  UNIQUE KEY `user_id` (`user_id`,`title_id`),
  KEY `title_id` (`title_id`),
  CONSTRAINT `favorite_titles_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `favorite_titles_ibfk_2` FOREIGN KEY (`title_id`) REFERENCES `titles` (`title_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `favorite_titles`
--

INSERT INTO `favorite_titles` VALUES (38,2747,31447370),(19,2747,57728771),(40,2747,64382903),(41,2747,76678613),(6,2747,76740503),(42,2747,84262953),(11,2747,98475796),(28,2750,35251579),(32,2754,25131469),(43,2754,26827823),(12,2754,47020925),(47,2754,58339009),(31,2754,59218003),(18,2754,59590432),(50,2754,65087970),(15,2754,70446009),(14,2754,71877175),(17,2754,83961895),(7,2754,98475796),(16,2754,98620794),(21,2758,24759419),(26,2758,25131469),(48,2758,28630271),(49,2758,30639016),(20,2758,35713751),(23,2758,50175340),(25,2758,59590432),(10,2758,86518379),(22,2758,98475796),(27,2758,98620794),(35,2761,15328732),(34,2761,33184286),(37,2761,36862897),(30,2761,48039089),(36,2761,70092491),(33,2761,97000035),(51,2763,10760279),(53,2763,26827823),(52,2763,64003498),(44,2763,76740503),(46,2764,26827823),(45,2764,83961895),(54,2766,10982684),(55,2766,59590432),(56,2766,64003498),(58,2766,76740503),(57,2766,97295282);

--
-- Table structure for table `follows`
--

CREATE TABLE `follows` (
  `follow_id` int(11) NOT NULL AUTO_INCREMENT,
  `follow_by` int(11) NOT NULL,
  `follow_to` int(11) NOT NULL,
  PRIMARY KEY (`follow_id`),
  UNIQUE KEY `follow_by` (`follow_by`,`follow_to`),
  KEY `follow_to` (`follow_to`),
  CONSTRAINT `follows_ibfk_1` FOREIGN KEY (`follow_by`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `follows_ibfk_2` FOREIGN KEY (`follow_to`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `follows`
--

INSERT INTO `follows` VALUES (5,2747,2748),(26,2747,2754),(17,2747,2756),(19,2747,2758),(16,2747,2764),(22,2747,2766),(4,2748,2747),(6,2750,2748),(10,2754,2747),(7,2758,2747),(9,2759,2747),(13,2760,2747),(14,2761,2750),(24,2763,2747),(20,2763,2749),(15,2764,2747),(23,2766,2747);

--
-- Table structure for table `nahs`
--

CREATE TABLE `nahs` (
  `nah_id` int(11) NOT NULL AUTO_INCREMENT,
  `nah_post` int(11) NOT NULL,
  `type` tinyint(1) NOT NULL,
  `date_time` datetime NOT NULL DEFAULT current_timestamp(),
  `nah_by` int(11) NOT NULL,
  PRIMARY KEY (`nah_id`),
  KEY `nah_by` (`nah_by`),
  CONSTRAINT `nahs_ibfk_1` FOREIGN KEY (`nah_by`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `nahs`
--

INSERT INTO `nahs` VALUES (12,5123850,0,'2025-09-25 14:39:32',2750),(14,54018894,0,'2025-09-25 16:29:24',2755),(15,8324926,1,'2025-09-25 16:29:48',2753),(16,83057042,1,'2025-09-25 16:30:10',2755),(17,88571533,1,'2025-09-25 16:30:57',2753),(18,43702992,1,'2025-09-25 16:31:31',2755),(19,35510843,1,'2025-09-25 16:31:31',2755),(20,33628415,1,'2025-09-25 16:32:00',2753),(21,75082982,0,'2025-09-25 16:33:58',2755),(22,52844099,1,'2025-09-25 16:34:35',2755),(23,69411565,1,'2025-09-25 16:34:36',2753),(24,42500465,0,'2025-09-25 16:37:01',2755),(25,26685448,1,'2025-09-25 16:37:25',2753),(27,14596034,1,'2025-09-25 16:42:10',2757),(28,6804041,0,'2025-09-25 16:43:06',2755),(31,92479252,1,'2025-09-25 18:17:10',2759),(32,98989319,0,'2025-09-25 18:17:21',2757),(33,47858694,0,'2025-09-25 18:20:08',2755),(34,55997250,0,'2025-09-25 18:20:26',2753),(35,47858694,0,'2025-09-25 18:20:29',2753),(36,55997250,0,'2025-09-25 18:20:39',2755),(37,75378422,1,'2025-09-25 18:33:59',2758),(38,11299454,0,'2025-09-25 21:02:59',2747),(45,11299454,0,'2025-09-26 00:25:30',2748),(46,21160213,0,'2025-09-26 00:27:05',2748),(47,18028357,0,'2025-09-26 00:27:06',2748),(48,19360925,0,'2025-09-26 00:27:07',2748),(49,47704600,0,'2025-09-26 00:27:08',2748),(50,38533827,0,'2025-09-26 00:27:09',2748),(51,54426871,0,'2025-09-26 00:27:10',2748),(52,10000804,0,'2025-09-26 00:27:11',2748),(53,35776002,0,'2025-09-26 00:27:12',2748),(54,77334422,0,'2025-09-26 00:27:13',2748),(55,31921926,0,'2025-09-26 00:27:14',2748),(56,42874478,0,'2025-09-26 00:27:17',2748),(57,86862058,0,'2025-09-26 00:27:17',2748),(58,31388313,0,'2025-09-26 00:27:19',2748),(59,56948396,0,'2025-09-26 00:27:20',2748),(60,2392805,0,'2025-09-26 00:27:22',2748),(61,12753929,0,'2025-09-26 00:27:22',2748),(62,58394911,0,'2025-09-26 00:27:23',2748),(63,4023919,0,'2025-09-26 00:27:24',2748),(64,60706106,0,'2025-09-26 00:27:26',2748),(65,768900,0,'2025-09-26 00:27:27',2748),(66,45513043,0,'2025-09-26 00:27:28',2748),(67,75967915,0,'2025-09-26 00:27:30',2748),(68,45236473,0,'2025-09-26 00:27:31',2748),(69,87474827,0,'2025-09-26 00:27:33',2748),(70,76452607,0,'2025-09-26 00:32:20',2748),(72,51993907,0,'2025-09-26 07:17:45',2750),(73,89375709,0,'2025-09-26 07:28:50',2748),(74,72195251,0,'2025-09-26 07:28:51',2748),(75,95140186,0,'2025-09-26 07:28:52',2748),(76,35859506,0,'2025-09-26 07:28:52',2748),(77,49292259,0,'2025-09-26 07:28:53',2748),(78,77185570,0,'2025-09-26 07:28:55',2748),(79,61197792,0,'2025-09-26 07:28:55',2748),(80,84234480,0,'2025-09-26 07:28:56',2748),(81,71949965,0,'2025-09-26 07:28:57',2748),(82,79044107,1,'2025-09-26 14:09:16',2753),(83,23084601,1,'2025-09-26 14:12:18',2755),(84,58914586,0,'2025-09-27 02:06:21',2748),(85,29130064,1,'2025-09-27 02:42:48',2747),(86,50081826,0,'2025-09-27 02:54:06',2747),(87,50081826,0,'2025-09-27 08:16:10',2748),(88,38608058,1,'2025-09-27 08:16:35',2748);

--
-- Table structure for table `notifs`
--

CREATE TABLE `notifs` (
  `notif_id` int(11) NOT NULL AUTO_INCREMENT,
  `notif_type` int(11) NOT NULL,
  `notif_by` int(11) DEFAULT NULL,
  `notif_to` int(11) NOT NULL,
  `notif_post` int(11) DEFAULT NULL,
  `merged` int(11) DEFAULT NULL,
  `notif_date` datetime NOT NULL DEFAULT current_timestamp(),
  `notif_read` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`notif_id`),
  KEY `notif_by` (`notif_by`),
  KEY `notif_to` (`notif_to`),
  KEY `notif_post` (`notif_post`),
  CONSTRAINT `notifs_ibfk_1` FOREIGN KEY (`notif_by`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `notifs_ibfk_2` FOREIGN KEY (`notif_to`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=166 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `notifs`
--

INSERT INTO `notifs` VALUES (47,0,2748,2747,5123850,NULL,'2025-09-25 13:52:58',1),(48,0,2748,2747,5123850,47,'2025-09-25 13:52:54',1),(49,4,2748,2747,NULL,NULL,'2025-09-25 14:01:59',1),(50,4,2747,2748,NULL,NULL,'2025-09-25 14:38:52',1),(51,4,2750,2748,NULL,50,'2025-09-25 14:38:52',1),(52,2,2747,2749,877281,NULL,'2025-09-25 14:41:57',1),(53,2,2755,2753,54018894,NULL,'2025-09-25 16:31:56',1),(54,3,2753,2755,54018894,NULL,'2025-09-25 16:32:18',1),(55,2,2755,2753,54018894,53,'2025-09-25 16:30:51',1),(56,3,2753,2755,54018894,54,'2025-09-25 16:31:12',1),(57,2,2755,2753,75082982,NULL,'2025-09-25 16:35:07',1),(58,3,2753,2755,75082982,NULL,'2025-09-25 16:34:27',1),(59,2,2755,2753,75082982,57,'2025-09-25 16:35:07',1),(60,0,2757,2753,42500465,NULL,'2025-09-25 16:37:08',1),(61,2,2755,2753,42500465,NULL,'2025-09-25 16:37:09',1),(62,3,2753,2755,42500465,NULL,'2025-09-25 16:37:23',1),(63,2,2753,2757,14043076,NULL,'2025-09-25 16:41:06',1),(64,2,2755,2757,14043076,63,'2025-09-25 16:40:22',1),(65,2,2753,2757,14043076,63,'2025-09-25 16:40:36',1),(66,2,2753,2757,51238911,NULL,'2025-09-25 16:43:27',1),(67,3,2757,2753,51238911,NULL,'2025-09-25 16:42:26',1),(68,2,2753,2757,51238911,66,'2025-09-25 16:43:27',1),(69,0,2747,2749,877281,NULL,'2025-09-25 17:00:51',0),(70,4,2758,2747,NULL,NULL,'2025-09-25 17:41:32',1),(71,4,2747,2758,NULL,NULL,'2025-09-25 17:07:17',1),(72,0,2747,2759,47858694,NULL,'2025-09-25 17:39:59',1),(73,4,2759,2747,NULL,70,'2025-09-25 17:41:32',1),(74,0,2758,2747,78656999,NULL,'2025-09-25 17:42:01',1),(75,0,2754,2756,75875925,NULL,'2025-09-25 17:51:39',1),(76,0,2754,2747,3795803,NULL,'2025-09-25 17:56:43',1),(77,0,2754,2752,35892347,NULL,'2025-09-25 17:56:46',0),(78,2,2757,2747,7656167,NULL,'2025-09-25 18:34:12',1),(79,2,2757,2758,67334688,NULL,'2025-09-25 18:10:33',1),(80,0,2757,2755,13943542,NULL,'2025-09-25 18:11:53',1),(81,0,2757,2755,65796923,NULL,'2025-09-25 18:15:55',1),(82,2,2747,2755,65796923,NULL,'2025-09-25 18:16:03',1),(83,2,2757,2755,65796923,82,'2025-09-25 18:16:03',1),(84,1,2759,2747,92479252,NULL,'2025-09-25 18:27:54',1),(85,2,2757,2758,33359281,NULL,'2025-09-25 18:17:09',1),(86,1,2759,2747,92479252,84,'2025-09-25 18:17:09',1),(87,1,2757,2747,92479252,84,'2025-09-25 18:27:54',1),(88,2,2758,2747,7656167,78,'2025-09-25 18:34:12',1),(89,4,2754,2747,NULL,NULL,'2025-09-25 19:25:05',1),(90,4,2750,2748,NULL,NULL,'2025-09-25 20:24:53',1),(91,4,2758,2750,NULL,NULL,'2025-09-25 20:32:34',1),(92,4,2760,2747,NULL,NULL,'2025-09-25 20:57:46',1),(93,0,2760,2753,63165263,NULL,'2025-09-25 20:59:46',1),(94,0,2750,2757,91983123,NULL,'2025-09-25 21:02:16',0),(95,0,2750,2761,92585587,NULL,'2025-09-25 21:04:26',1),(96,0,2750,2761,92585587,95,'2025-09-25 21:04:20',1),(97,0,2761,2750,65305894,NULL,'2025-09-25 21:05:36',1),(98,2,2761,2750,65305894,NULL,'2025-09-25 21:05:46',1),(99,0,2761,2747,74488942,NULL,'2025-09-25 21:34:03',1),(100,0,2761,2747,51993907,NULL,'2025-09-25 21:34:04',1),(101,2,2761,2747,74488942,NULL,'2025-09-25 21:34:11',1),(102,2,2748,2759,11299454,NULL,'2025-09-26 00:25:37',0),(103,0,2747,2748,12189493,NULL,'2025-09-26 01:51:14',1),(104,0,2747,2758,90390887,NULL,'2025-09-26 04:10:38',1),(105,5,NULL,2759,NULL,NULL,'2025-09-26 04:28:48',0),(106,0,2748,2747,87764935,NULL,'2025-09-26 06:25:52',1),(107,4,2761,2750,NULL,NULL,'2025-09-26 07:26:41',0),(108,0,2763,2747,87764935,NULL,'2025-09-26 09:25:54',1),(109,4,2764,2747,NULL,NULL,'2025-09-26 09:33:16',1),(110,4,2747,2764,NULL,NULL,'2025-09-26 09:51:41',1),(111,0,2748,2747,2405443,NULL,'2025-09-26 12:33:52',1),(112,0,2754,2747,78879657,NULL,'2025-09-26 13:00:00',1),(113,0,2754,2747,5123850,NULL,'2025-09-26 12:47:44',1),(114,0,2756,2747,78879657,112,'2025-09-26 13:00:00',1),(115,4,2747,2756,NULL,NULL,'2025-09-26 13:15:40',1),(116,4,2747,2754,NULL,NULL,'2025-09-26 14:05:42',1),(117,4,2747,2758,NULL,NULL,'2025-09-26 14:06:34',1),(118,2,2747,2754,85483073,NULL,'2025-09-26 14:09:56',1),(119,2,2753,2755,41210483,NULL,'2025-09-26 14:09:31',1),(120,2,2753,2754,85483073,118,'2025-09-26 14:09:56',1),(121,0,2747,2758,60536450,NULL,'2025-09-26 16:03:33',1),(122,2,2747,2758,60536450,NULL,'2025-09-26 16:03:45',1),(123,2,2747,2753,29786713,NULL,'2025-09-26 16:04:43',0),(124,0,2747,2754,85483073,NULL,'2025-09-26 16:06:12',1),(125,0,2754,2747,4263649,NULL,'2025-09-26 18:28:07',1),(126,2,2748,2750,58914586,NULL,'2025-09-27 02:06:36',0),(127,2,2748,2747,92912809,NULL,'2025-09-27 02:07:27',1),(128,3,2747,2748,92912809,NULL,'2025-09-27 02:46:09',1),(129,3,2747,2748,92912809,128,'2025-09-27 02:46:09',1),(130,2,2747,2760,31788647,NULL,'2025-09-27 02:52:51',0),(131,2,2747,2765,50081826,NULL,'2025-09-27 02:54:10',0),(132,4,2763,2749,NULL,NULL,'2025-09-27 05:27:01',0),(133,0,2763,2747,92912809,NULL,'2025-09-27 05:29:25',1),(134,0,2766,2747,182115,NULL,'2025-09-27 05:48:54',1),(135,0,2766,2747,4263649,NULL,'2025-09-27 05:49:06',1),(136,4,2747,2766,NULL,NULL,'2025-09-27 05:52:48',1),(137,2,2747,2766,3820887,NULL,'2025-09-27 05:56:39',1),(138,4,2747,2766,NULL,136,'2025-09-27 05:52:48',1),(139,1,2766,2747,61798573,NULL,'2025-09-27 05:53:01',1),(140,2,2747,2766,27009916,NULL,'2025-09-27 06:02:13',1),(141,3,2766,2747,3820887,NULL,'2025-09-27 05:53:22',1),(142,1,2766,2747,6723476,NULL,'2025-09-27 05:53:52',1),(143,3,2766,2747,27009916,NULL,'2025-09-27 06:03:29',1),(144,1,2766,2747,6723476,142,'2025-09-27 05:53:52',1),(145,2,2747,2766,27009916,140,'2025-09-27 05:55:24',1),(146,2,2747,2766,3820887,137,'2025-09-27 05:56:39',1),(147,1,2766,2747,7332760,NULL,'2025-09-27 05:57:59',1),(148,3,2766,2747,27009916,143,'2025-09-27 05:58:15',1),(149,2,2747,2766,27009916,NULL,'2025-09-27 11:59:45',1),(150,1,2766,2747,48952635,NULL,'2025-09-27 05:00:28',1),(151,4,2766,2747,NULL,NULL,'2025-09-27 06:16:03',1),(152,0,2766,2747,87764935,NULL,'2025-09-27 06:04:14',1),(153,2,2766,2747,87764935,NULL,'2025-09-27 06:04:25',1),(154,3,2747,2766,87764935,NULL,'2025-09-27 06:04:51',1),(155,1,2766,2747,42674944,NULL,'2025-09-27 06:06:29',1),(156,0,2747,2766,84942271,NULL,'2025-09-27 06:12:41',0),(157,2,2747,2766,84942271,NULL,'2025-09-27 06:12:49',0),(158,4,2763,2747,NULL,151,'2025-09-27 06:16:03',1),(159,0,2754,2747,62593877,NULL,'2025-09-27 07:35:52',1),(160,0,2754,2747,182115,NULL,'2025-09-27 07:36:01',1),(161,4,2747,2754,NULL,NULL,'2025-09-27 07:40:25',0),(162,4,2747,2754,NULL,161,'2025-09-27 07:40:25',0),(163,2,2748,2747,92912809,NULL,'2025-09-27 08:05:48',0),(164,0,2748,2758,60536450,NULL,'2025-09-27 08:07:43',0),(165,1,2748,2747,657837,NULL,'2025-09-27 08:16:15',0);

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `post_by_id` int(11) NOT NULL,
  `post_title` int(11) NOT NULL,
  `deleted` int(11) NOT NULL DEFAULT 0,
  `feeling_id` int(11) NOT NULL DEFAULT 0,
  `text` varchar(800) NOT NULL,
  `post_image` varchar(255) DEFAULT NULL,
  `date_time` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `post_by_id` (`post_by_id`),
  KEY `posts_ibfk_2` (`post_title`),
  CONSTRAINT `posts_ibfk_1` FOREIGN KEY (`post_by_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `posts_ibfk_2` FOREIGN KEY (`post_title`) REFERENCES `titles` (`title_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=99606132 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `posts`
--

INSERT INTO `posts` VALUES (182115,2747,58339009,0,0,'Guys the new community icon and banner of this community are better?',NULL,'2025-09-27 02:53:29'),(877281,2749,76740503,0,0,'RIP Peter Griffin community (2025-2025)\r\n\r\nI\'m finished with trolling. This website is probably much better and more secure than the old version',NULL,'2025-09-25 14:41:14'),(910024,2762,58339009,0,0,'Hi',NULL,'2025-09-26 07:26:24'),(2405443,2747,76740503,0,0,'SuperDumbMario2 i maked a general community so this outcome will not happend again',NULL,'2025-09-26 01:50:53'),(3795803,2747,31447370,0,0,'Welcome',NULL,'2025-09-25 14:49:11'),(3820887,2766,10982684,0,1,'This is one of my favorite games :D','https://citraverse.altervista.org/Immagini/42451170031.jpg','2025-09-27 05:39:43'),(4263649,2747,58339009,0,2,'I changing the banner of this community',NULL,'2025-09-26 16:14:00'),(5123850,2747,58339009,0,1,'HIII','https://citraverse.altervista.org/CITRA2/citrao.jpg','2025-09-25 13:50:54'),(6804041,2753,59986307,0,0,'@BarackObama IS POSTING WOKE STUFF ON HERE NOW...BECAUSE OF COURSE HE IS. I AM GONNA MAKE SURE THAT HE IS REMOVED FROM THIS WEBSITE INSTANTLY!',NULL,'2025-09-25 16:42:48'),(7036556,2753,59986307,0,0,'THE OWNER OF THIS APP AUGUSTO VILLA.... YOU NEED TO MAKE IT SO YOU CAN BAN PEOPLE FROM COMMUNITIES... I AM TIRED OF @JoeBiden HARASSING ME ON MY OWN COMMUNITY... HE IS NOT A TRUE AMERICAN PATRIOT... AND HE NEVER WILL BE.',NULL,'2025-09-25 16:38:02'),(7656167,2747,45890494,0,0,'LMAO',NULL,'2025-09-25 17:45:52'),(9109521,2753,59986307,0,0,'@everyone BAN JOE BIDEN. HE DOESN\'T LIKE MY COMMUNITY',NULL,'2025-09-25 18:17:59'),(11849601,2761,36862897,0,0,'cherry bomb',NULL,'2025-09-25 22:48:19'),(12189493,2748,76740503,0,5,'Really hope this will not have the same outcome as tomodachi from old citra (becoming an off-topic community).',NULL,'2025-09-26 00:22:06'),(13943542,2755,59986307,0,0,'test',NULL,'2025-09-25 18:11:26'),(14043076,2757,59986307,0,0,'donald and biden call me asap',NULL,'2025-09-25 16:38:57'),(14126924,2757,39021849,0,2,'I love Headlines by Drake!',NULL,'2025-09-25 18:26:03'),(26544564,2765,59986307,0,2,'All Of The \"New Gen\" Presidents Below Are Gay, Homosexual, Etc.',NULL,'2025-09-26 21:08:43'),(27009916,2766,59590432,0,1,'Am I the only one who still plays this game today? ','https://citraverse.altervista.org/Immagini/52213146605.jpg','2025-09-27 05:41:48'),(28038680,2747,25131469,2,0,'njjjj',NULL,'2025-09-26 11:01:18'),(29786713,2753,58339009,0,0,'Pay my tariffs. ',NULL,'2025-09-26 14:09:05'),(31166471,2753,59986307,0,0,'REAL AMERCIAN PATRIOTS LIVE ON!!!!!',NULL,'2025-09-25 18:15:38'),(31788647,2760,31447370,0,0,'Hi',NULL,'2025-09-25 20:59:26'),(33359281,2758,65899968,0,0,'please stop i want to make communtiies',NULL,'2025-09-25 18:15:33'),(35859506,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:52'),(35892347,2752,31447370,0,0,'This website is cool.',NULL,'2025-09-25 16:09:10'),(36506300,2754,58339009,0,1,'Hello ',NULL,'2025-09-25 17:52:13'),(36781792,2755,59986307,0,0,'Everyone, watch out for Trump, he scammed me.',NULL,'2025-09-25 16:38:46'),(38178545,2753,58339009,0,0,'We will protect America with my tariffs.','https://citraverse.altervista.org/Immagini/48300415009.jpg','2025-09-26 14:11:17'),(38533827,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:02:01'),(39046210,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:59'),(39432015,2754,98475796,0,1,'I wish squids were real',NULL,'2025-09-25 16:25:44'),(39787164,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:44'),(40970057,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:27'),(41210483,2755,58339009,0,0,'when carti dropping',NULL,'2025-09-26 14:08:11'),(41229821,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:49'),(42032031,2753,59986307,0,0,'AH YES, @JoeBiden IS SO MAD THAT I\'M JUST BETTER THAN HIM HE FEELS THE NEED TO SPREAD MISINFORMATION',NULL,'2025-09-25 16:39:39'),(42500465,2753,59986307,0,0,'AS ONE WHO IS A TRUE AMERICAN PATRIOT, I ANNOUNCE PLANS TO MAKE RAGEBAITING ILLEGAL. THE USER ON THIS APP @JoeBiden HAS PUT ME THROUGH SO MUCH... I THINK THAT HE SHOULD ROT IN PRISON, BUT I DIGRESS. WE WILL GET THIS BILL SIGNED. THIS IS FOR YOU, THE TRUE AMERICAN PATRIOTS THAT LOVE THIS COUNTRY!',NULL,'2025-09-25 16:36:10'),(42758490,2758,86518379,0,1,'im good',NULL,'2025-09-25 17:43:02'),(42874478,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:59'),(43843705,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:57:29'),(44574721,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:23'),(45167729,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:46'),(45236473,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:54'),(45298415,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:49'),(45302357,2748,70092491,0,3,'OH MY GOD IS THAT AN MII CREATOR REFERENCE',NULL,'2025-09-26 00:47:34'),(45513043,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:55'),(45864675,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:57:22'),(46611481,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:52:00'),(46618734,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:57:31'),(46691527,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:57:29'),(46797809,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:58:02'),(46948652,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:43'),(46975745,2763,10760279,0,1,'Hi all I love play pokemon Y',NULL,'2025-09-27 05:30:22'),(46996824,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:57'),(47511491,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:58:30'),(47704600,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:02:02'),(47899846,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:57:36'),(48936909,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:22'),(49292259,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:52'),(50081826,2765,58339009,0,0,'augusto we will touch you','https://citraverse.altervista.org/Immagini/77960378756.jpeg','2025-09-26 21:09:19'),(51070414,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:16'),(51161700,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:58:08'),(51238911,2757,59986307,0,2,'@DonaldTrump lets make out',NULL,'2025-09-25 16:40:59'),(51679781,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:58:05'),(51738174,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:58:29'),(51993907,2747,48039089,0,0,'Hii',NULL,'2025-09-25 21:06:07'),(52036677,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:45'),(52041489,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:25'),(52188145,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:58:28'),(52611894,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:57:24'),(52902948,2758,35713751,0,1,'HOME',NULL,'2025-09-25 19:06:57'),(52919071,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:10'),(53141734,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:58:31'),(53217319,2753,58339009,0,0,'IMAGINE SLEEPY JOE GETTING HIMSELF BANNED OFF OF CITRAVERSE. COULDN\'T BE ME',NULL,'2025-09-25 18:15:27'),(53680079,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:58:07'),(54018894,2753,31447370,0,0,'Where is Joe Biden? I bet he\'s still trying to figure out how to get to the new website. L.O.L.',NULL,'2025-09-25 16:25:20'),(54112058,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:45'),(54426871,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:02:01'),(54638827,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:57:25'),(54746392,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:57:36'),(54826772,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:58:28'),(55270039,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:46'),(56078806,2758,45890494,0,0,'ball',NULL,'2025-09-26 17:25:00'),(56948396,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:58'),(57060437,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:46'),(57330849,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:48'),(57617355,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:57:26'),(57637496,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:58:31'),(58269566,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:57:28'),(58311551,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:05'),(58394911,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:57'),(58914586,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:45:45'),(59888998,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:58:09'),(59943590,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:30'),(60536450,2758,58339009,0,0,'moscow','https://citraverse.altervista.org/Immagini/63139139652.png','2025-09-26 14:15:29'),(60706106,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:56'),(61173030,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:57:34'),(61197792,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:51'),(61955520,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:57:18'),(62593877,2747,26827823,0,0,'I changed the citraverse default color if you continue to old default color just press CTRL + F5 or reset your browser data',NULL,'2025-09-27 07:00:14'),(62602956,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:58:27'),(62689464,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:47'),(62837453,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:08'),(62958094,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:03'),(63140234,2755,59986307,0,0,'This community is trash',NULL,'2025-09-25 18:17:24'),(63165263,2753,31447370,0,0,'Hey guys, I\'m back!',NULL,'2025-09-25 16:19:40'),(63285092,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:32'),(64218251,2747,58339009,0,0,'HI',NULL,'2025-09-26 05:14:23'),(64546656,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:56'),(64620845,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:57:35'),(65108207,2747,59986307,0,0,'Lol',NULL,'2025-09-27 02:41:26'),(65305894,2750,48039089,0,0,'gilberr',NULL,'2025-09-25 21:03:27'),(65793088,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:57:19'),(65796923,2755,58339009,0,0,'Dear users of citraverse, I am sorry. I went over the top with my community usage. It wont happen again.',NULL,'2025-09-25 18:13:10'),(66023204,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:58:30'),(67334688,2758,58339009,0,0,'heya',NULL,'2025-09-25 16:42:55'),(67518488,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:28'),(68254433,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:57:28'),(68604763,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:57:28'),(68846690,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:57:31'),(69019745,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:58:28'),(71232052,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:41'),(71949965,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:50'),(72134860,2754,98475796,0,2,'You\'re a kid now, You\'re squid now. ;)\r\n',NULL,'2025-09-26 18:35:21'),(72195251,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:53'),(72799705,2757,58339009,0,0,'Hello American People!\r\nI am Barack Obama!',NULL,'2025-09-25 18:12:26'),(73117428,2754,65087970,0,1,'I really want to draw in this community.',NULL,'2025-09-26 18:33:31'),(73134993,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:48'),(73235558,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:58:06'),(74370272,2764,83961895,0,1,'hii all',NULL,'2025-09-26 09:34:21'),(74488942,2747,48039089,0,0,'How are you?',NULL,'2025-09-25 21:06:16'),(75082982,2753,59986307,0,0,'THIS IS MY NEW COMMUNITY THAT IS ONLY FOR THOSE WHO ARE TRUE AMERICANS. WE WILL PUT AN END TO @JoeBiden NO LONGER HOW LONG IT TAKES!',NULL,'2025-09-25 16:33:27'),(75250787,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:36'),(75431766,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:53'),(75875925,2756,47020925,0,0,'TVii is based',NULL,'2025-09-25 16:36:01'),(75967915,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:55'),(76317452,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:07'),(76452607,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:52:01'),(76541763,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:57:30'),(76720691,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:57:33'),(76940219,2754,47020925,0,2,'I like too much the movies, series and sports',NULL,'2025-09-25 17:51:34'),(77185570,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:52'),(77334422,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:02:00'),(77719490,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:57:59'),(78620024,2747,76740503,0,1,'Hi from my 3ds',NULL,'2025-09-25 16:54:30'),(78656999,2747,86518379,0,0,'Hi',NULL,'2025-09-25 17:41:23'),(78879657,2747,58339009,0,0,'Post with image test','https://citraverse.altervista.org/Immagini/11687563226.png','2025-09-26 12:19:45'),(78959270,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:57:21'),(81207557,2766,97295282,0,0,'Hi!',NULL,'2025-09-27 06:05:01'),(81561692,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:57:24'),(82091335,2752,91689487,0,0,' ',NULL,'2025-09-25 16:15:58'),(82435814,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:45'),(83128376,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:49'),(83553667,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:47'),(84234480,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:51'),(84942271,2766,97295282,0,0,'I created a website that contains other miii-related sites! Try it out! https://miinetwork.framer.website','https://citraverse.altervista.org/Immagini/74205556044.png','2025-09-27 06:06:06'),(85110932,2761,33184286,0,0,'wemby',NULL,'2025-09-25 21:46:27'),(85483073,2754,58339009,0,1,'A new day in citraverse ;)',NULL,'2025-09-26 12:47:29'),(85494955,2757,65899968,0,1,'Who are y\'alls favorite wrestlers? Mine is Brock Lesnar.',NULL,'2025-09-25 18:15:24'),(85602930,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:57:26'),(85650711,2753,59986307,0,0,'I am a true American.',NULL,'2025-09-26 14:12:02'),(86154035,2761,97000035,0,0,'game comes out 2026, pre-orders start september 27th',NULL,'2025-09-25 21:36:46'),(86862058,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:59'),(87414093,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:44'),(87443451,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:57:27'),(87474827,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:54'),(87764935,2747,76740503,0,0,'Guys who like Tomodachi life?',NULL,'2025-09-26 05:57:09'),(88561587,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:12'),(89071222,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:10'),(89269842,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:58:26'),(89371765,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:57:23'),(89375709,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:54'),(89505781,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:44'),(89990599,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:45'),(90044886,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:44'),(90254836,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:57:17'),(90390887,2758,98475796,0,0,'weeee are getting a new banner yahooo',NULL,'2025-09-25 17:05:12'),(90651778,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:37'),(91983123,2757,35251579,0,1,'Mustard!',NULL,'2025-09-25 18:25:49'),(92369229,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:51'),(92585587,2761,48039089,0,1,'i love gilberr',NULL,'2025-09-25 21:02:31'),(92912809,2747,26827823,0,0,'Now a user can create only 1 community',NULL,'2025-09-27 01:48:20'),(93317470,2755,59986307,0,0,'I AM MAKING A MUSTARD COMMUNITY. I SAW THE TREND ON \"TIK TOK\" AND FOUND IT FUNNY. IDK WHO THE SMILING GUY IS THO.',NULL,'2025-09-25 18:24:15'),(95140186,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:53'),(96761827,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 20:57:33'),(96919773,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:39'),(98972118,2759,58339009,0,0,'can i goon on citrafag',NULL,'2025-09-25 21:01:48'),(99606131,2750,58339009,0,0,'CITRAVERSE IS GAY\r\nCITRAVERSE IS GAYCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY\r\nCITRAVERSE IS GAY',NULL,'2025-09-25 20:51:15');

--
-- Table structure for table `profiles`
--

CREATE TABLE `profiles` (
  `user_id` int(11) NOT NULL,
  `bio` varchar(400) DEFAULT NULL,
  `name_color` varchar(7) DEFAULT NULL,
  `country` enum('1','2','3','4','5','6','7') DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `fav_post` int(11) DEFAULT NULL,
  `organization` varchar(256) DEFAULT NULL,
  `yeah_notifs` int(11) NOT NULL DEFAULT 1,
  `last_online` datetime DEFAULT NULL,
  UNIQUE KEY `user_id` (`user_id`),
  CONSTRAINT `profiles_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `profiles`
--

INSERT INTO `profiles` VALUES (2747,'I&#039;m a italian person and also the founder of this clone','#ffa200','1','2017-07-01',NULL,NULL,1,'2025-09-27 08:39:48'),(2748,NULL,NULL,NULL,NULL,NULL,NULL,1,'2025-09-27 08:40:17'),(2749,NULL,NULL,NULL,NULL,NULL,NULL,1,'2025-09-25 14:43:02'),(2750,NULL,NULL,'1',NULL,NULL,NULL,1,'2025-09-26 07:17:56'),(2752,NULL,NULL,NULL,NULL,NULL,NULL,1,'2025-09-25 16:18:36'),(2753,'The greatest US President of all time. Stopping fake news one minute at a time. ',NULL,'1',NULL,NULL,NULL,1,'2025-09-26 14:12:38'),(2754,'My name JoseDoom but you can just call me José, i&#039;m colombian but i just prefer too much speak english;)',NULL,'1',NULL,NULL,NULL,1,'2025-09-27 07:36:27'),(2755,NULL,NULL,'1',NULL,NULL,NULL,1,'2025-09-26 14:12:37'),(2756,NULL,'#1164e8','1',NULL,NULL,NULL,1,'2025-09-27 00:21:27'),(2757,NULL,NULL,NULL,NULL,NULL,NULL,1,'2025-09-25 21:00:36'),(2758,'i hate myself',NULL,'6','2017-12-14',NULL,NULL,1,'2025-09-26 22:25:05'),(2759,NULL,NULL,NULL,NULL,NULL,NULL,1,'2025-09-25 21:24:29'),(2760,NULL,NULL,NULL,NULL,NULL,NULL,1,'2025-09-25 21:00:23'),(2761,'i like cheese','#61187c','1','2017-01-18',NULL,NULL,1,'2025-09-26 14:08:46'),(2762,NULL,NULL,NULL,NULL,NULL,NULL,1,'2025-09-27 01:29:23'),(2763,NULL,NULL,'1','2017-10-05',NULL,NULL,1,'2025-09-27 06:19:29'),(2764,NULL,NULL,'1',NULL,NULL,NULL,1,'2025-09-26 14:10:21'),(2765,'Official account for John Fitzgerald Kennedy.',NULL,'1','2017-05-29',NULL,NULL,1,'2025-09-26 21:09:24'),(2766,'hi, i&#039; m Italian, I like developing software (websites and video games), I love Wii, Wii U and 3ds and I&#039;m a big fan of the frutiger aero/Windows aero style.I&#039; m learning CSS,HTML,Javascript\r\n\r\nYt Channel: https://youtube.com/@jacane_u?si=Xa6M6P0vMEJkrNX3',NULL,'5','2017-06-13',NULL,NULL,1,'2025-09-27 06:18:22');

--
-- Table structure for table `replies`
--

CREATE TABLE `replies` (
  `reply_id` int(11) NOT NULL AUTO_INCREMENT,
  `reply_post` int(11) NOT NULL,
  `reply_by_id` int(11) NOT NULL,
  `deleted` int(11) NOT NULL DEFAULT 0,
  `feeling_id` int(11) NOT NULL DEFAULT 0,
  `text` varchar(800) NOT NULL,
  `reply_image` varchar(255) DEFAULT NULL,
  `date_time` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`reply_id`),
  KEY `reply_post` (`reply_post`),
  KEY `reply_by_id` (`reply_by_id`),
  CONSTRAINT `replies_ibfk_1` FOREIGN KEY (`reply_post`) REFERENCES `posts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `replies_ibfk_2` FOREIGN KEY (`reply_by_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=99894592 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `replies`
--

INSERT INTO `replies` VALUES (657837,50081826,2747,0,0,'Nahh',NULL,'2025-09-27 02:54:10'),(6723476,27009916,2747,0,0,'what game this is',NULL,'2025-09-27 05:53:21'),(7332760,27009916,2747,0,1,'i never played nintendo land LOL',NULL,'2025-09-27 05:55:24'),(8324926,54018894,2755,0,0,'I&#039;m here, Trump. What now?',NULL,'2025-09-25 16:29:32'),(11030664,29786713,2747,0,0,'I&#039;m italian lol i don&#039;t need to pay your stupid taxes',NULL,'2025-09-26 16:04:43'),(11137225,75082982,2755,0,0,'i&#039;m literally ragebaiting dawg. lol.',NULL,'2025-09-25 16:35:07'),(11633131,33359281,2757,0,3,'This isn&#039;t a spam community, I just like the WWE.',NULL,'2025-09-25 18:17:09'),(14596034,51238911,2753,0,0,'I AM BANNING YOU FROM THIS COMMUNITY FOR POSTING WOKE STUFF! NO MORE WOKE STUFF!',NULL,'2025-09-25 16:41:42'),(14730344,51238911,2757,0,4,'Do... do you not love me anymore Trumpie-poo....',NULL,'2025-09-25 16:42:26'),(14962829,92912809,2747,0,0,'Is from protecting spamming creation of community.',NULL,'2025-09-27 02:46:09'),(15781127,78879657,2747,2,0,'Ita working the image?',NULL,'2025-09-26 13:13:02'),(18982213,877281,2747,0,2,'Thank you for saying that is better',NULL,'2025-09-25 14:41:57'),(21600976,84942271,2747,0,1,'I love your website',NULL,'2025-09-27 06:12:49'),(23084601,41210483,2753,0,0,'Joe, you aren&#039;t funny and nobody likes you.',NULL,'2025-09-26 14:09:31'),(26685448,42500465,2755,0,0,'Sounds like a dumb law, i can&#039;t lie.',NULL,'2025-09-25 16:37:09'),(28220425,67334688,2757,0,0,'Hello Eric!',NULL,'2025-09-25 18:10:33'),(29130064,92912809,2748,0,4,'this change sucks',NULL,'2025-09-27 02:07:27'),(29744201,54018894,2753,0,0,'Real American Patriots use this app. In fact, I&#039;m gonna make my own community for Real American Patriots!',NULL,'2025-09-25 16:32:18'),(33628415,54018894,2755,0,0,'I&#039;m not trustworthy? Buddy, you&#039;re trying to make people like you on some Miiverse app. ',NULL,'2025-09-25 16:31:56'),(33914218,87764935,2766,0,1,'Me ;)',NULL,'2025-09-27 06:04:25'),(35219078,60536450,2747,0,1,'Cute boy',NULL,'2025-09-26 16:03:45'),(35510843,54018894,2753,0,0,'That&#039;s a lie. I don&#039;t give tax cuts, and even if I did, you would never find out!',NULL,'2025-09-25 16:31:12'),(35630577,78879657,2747,0,1,'It working the image?',NULL,'2025-09-26 13:13:50'),(36435135,65796923,2757,0,0,'I forgive you Joe Biden!',NULL,'2025-09-25 18:16:03'),(37661914,7656167,2758,0,0,'. . .',NULL,'2025-09-25 18:34:12'),(38608058,85483073,2753,0,0,'Pay my tariffs.',NULL,'2025-09-26 14:09:56'),(40568544,31788647,2747,0,0,'Hi',NULL,'2025-09-27 02:52:51'),(42674944,87764935,2747,0,0,'i have tomodachi life on my 3ds and also a tomodachi life custom fan theme',NULL,'2025-09-27 06:04:51'),(43454835,14043076,2753,0,0,'WHAT?! WHO ALLOWED YOU ON THIS APP! YOU AREN&#039;T AN AMERICAN PATRIOT, I&#039;M GONNA MAKE SURE YOU ARE BANNED FROM THIS WEBSITE.',NULL,'2025-09-25 16:40:06'),(43702992,54018894,2753,0,0,'Besides, you have dementia. You aren&#039;t trustworthy.',NULL,'2025-09-25 16:31:24'),(44747095,3820887,2747,0,0,'My favorite game is tomodachi life',NULL,'2025-09-27 05:56:39'),(45008792,92912809,2747,2,0,'is for protecting from spamming creation of community',NULL,'2025-09-27 02:42:33'),(45349702,4263649,2747,0,0,'New Icon also',NULL,'2025-09-26 16:30:57'),(48952635,27009916,2747,0,0,'i don&#039;t have a wii u',NULL,'2025-09-27 11:59:45'),(49112095,58914586,2748,0,0,'more like YOU are gay',NULL,'2025-09-27 02:06:36'),(49459480,85483073,2747,0,0,'Yea',NULL,'2025-09-26 14:07:15'),(50771946,42500465,2753,0,0,'Yeah, well YOU ARE THE DUMB ONE.',NULL,'2025-09-25 16:37:23'),(52415601,65305894,2761,0,1,'truth nuke',NULL,'2025-09-25 21:05:46'),(52844099,75082982,2753,0,0,'YEAH WELL NOBODY LIKES YOU. THERE&#039;S A REASON WHY I HAVE A COMMUNITY, AND YOU DON&#039;T. ',NULL,'2025-09-25 16:34:27'),(55308316,78879657,2747,0,0,'It is lagging?',NULL,'2025-09-26 13:15:05'),(61798573,3820887,2747,0,0,'is great but i think the wii version is more iconic',NULL,'2025-09-27 05:52:41'),(64844718,3820887,2766,0,0,'Yeah you are right.',NULL,'2025-09-27 05:53:22'),(64989925,14043076,2755,0,0,'YOOOOOO my man was good',NULL,'2025-09-25 16:40:22'),(66073018,27009916,2747,2,0,'wait is that a tv in the photo?',NULL,'2025-09-27 06:02:13'),(69411565,75082982,2755,0,0,'No one&#039;s using this community lol',NULL,'2025-09-25 16:34:05'),(71818954,14043076,2753,0,0,'SHUT UP JOE! I&#039;LL NUKE YOU!',NULL,'2025-09-25 16:40:36'),(74213996,27009916,2766,0,0,'The Zelda game from nintendoland',NULL,'2025-09-27 05:53:50'),(74450211,74488942,2761,0,0,'good',NULL,'2025-09-25 21:34:11'),(74482257,27009916,2766,0,0,'It&#039;s just the TV that&#039;s in my house',NULL,'2025-09-27 06:03:29'),(75378422,7656167,2757,0,1,'Augusto are you a real American patriot?',NULL,'2025-09-25 18:05:30'),(79044107,41210483,2755,0,0,'Hopefully NEVER.',NULL,'2025-09-26 14:08:31'),(83057042,54018894,2753,0,0,'Sucks to suck, Joe. I got here first. That&#039;s why I&#039;m the greatest president of all time. ',NULL,'2025-09-25 16:30:03'),(83397873,27009916,2766,0,0,'I recommend it! It&#039;s so much fun!',NULL,'2025-09-27 05:58:15'),(84609236,51238911,2753,0,0,'WOKE!!!!!!!!!! WOKE!!!!!!!!!!!!!!!!!!',NULL,'2025-09-25 16:43:27'),(88571533,54018894,2755,0,0,'Oh, I&#039;m SO SURE. All you want to do is pay off your billionaire &quot;friends&quot;. By the way, they&#039;re not your friends. They just like you because you give them tax cuts.',NULL,'2025-09-25 16:30:51'),(89818426,27009916,2766,0,0,'Oh... Too bad',NULL,'2025-09-27 06:00:51'),(90645108,14043076,2753,0,0,'GRRRRRRRRRRRRRRRRRRRR! JOE BIDEN! I WILL MAKE SURE YOU ARE BANNED FROM MY CITRAVERSE COMMUNITY NO MATTER WHAT!!!!!!!!!!!!!!',NULL,'2025-09-25 16:41:06'),(92479252,65796923,2747,0,0,'It&#039;s ok I deleted your communities (I left you 1 because it&#039;s true that you have 1) ',NULL,'2025-09-25 18:15:57'),(93585606,14043076,2755,0,0,'i&#039;d like to see you try ',NULL,'2025-09-25 16:40:46'),(99894591,92912809,2748,0,0,'Did anyone ever spam the communities',NULL,'2025-09-27 08:05:48');

--
-- Table structure for table `titles`
--

CREATE TABLE `titles` (
  `title_id` int(11) NOT NULL,
  `title_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `title_desc` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `title_icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `title_banner` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `perm` int(11) DEFAULT NULL,
  `type` int(11) NOT NULL,
  `user_made` tinyint(1) NOT NULL DEFAULT 0,
  `title_by` int(11) DEFAULT NULL,
  `time_created` datetime NOT NULL DEFAULT current_timestamp(),
  `owner_only` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`title_id`),
  KEY `title_by` (`title_by`),
  CONSTRAINT `titles_ibfk_1` FOREIGN KEY (`title_by`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `titles`
--

INSERT INTO `titles` VALUES (10760279,'Pokémon X and Y Community','This community is to talk about Pokemon X and Y','https://citraverse.altervista.org/Immagini/pokmonxandycommunity_logo.png','https://citraverse.altervista.org/Immagini/pokmonxandycommunity_banner.png',0,2,0,2747,'2025-09-25 18:20:20',0),(10982684,'Wii Party U Community','This community is to talk about Wii Party U!','https://citraverse.altervista.org/Immagini/wiipartyucommunity_logo.png','https://citraverse.altervista.org/Immagini/wiipartyucommunity_banner.png',0,1,0,2747,'2025-09-25 19:30:03',0),(11555827,'Team Kirby Clash Deluxe Community','This community is to talk about Team Kirby Clash Deluxe!','https://citraverse.altervista.org/Immagini/teamkirbyclashdeluxecommunity_logo.png','https://citraverse.altervista.org/Immagini/teamkirbyclashdeluxecommunity_banner.png',0,2,0,2747,'2025-09-25 20:58:22',0),(11613025,'NWO','Jey Uso','https://citraverse.altervista.org/Immagini/nwo_logo.jpg','https://citraverse.altervista.org/Immagini/nwo_banner.png',0,6,1,2752,'2025-09-25 16:13:03',0),(11764695,'Bayonetta 2 Community','Talk about Bayonetta 2!','https://citraverse.altervista.org/Immagini/bayonetta2community_logo.png','https://citraverse.altervista.org/Immagini/bayonetta2community_banner.png',0,1,0,2747,'2025-09-26 14:59:45',0),(12852109,'The Legend of Zelda: A Link Between Worlds Community','This community is to talk about The Legend of Zelda: A Link Between Worlds!','https://citraverse.altervista.org/Immagini/thelegendofzeldaalinkbetweenworldscommunity_logo.png','https://citraverse.altervista.org/Immagini/thelegendofzeldaalinkbetweenworldscommunity_banner.png',0,2,0,2747,'2025-09-25 20:10:46',0),(13261871,'Terraria Community','Talk about Terraria!','https://citraverse.altervista.org/Immagini/terrariacommunity_logo.png','https://citraverse.altervista.org/Immagini/terrariacommunity_banner.png',0,3,0,2747,'2025-09-26 14:58:34',0),(15276682,'The Legend of Zelda: Majora\'s Mask 3D Community','This community is to talk about The Legend of Zelda: Majora\'s Mask 3D!','https://citraverse.altervista.org/Immagini/thelegendofzeldamajorasmask3dcommunity_logo.png','https://citraverse.altervista.org/Immagini/thelegendofzeldamajorasmask3dcommunity_banner.png',0,2,0,2747,'2025-09-25 21:27:05',0),(15328732,'gilberr the game 2 community','you\'re gonna love our pizza...','https://citraverse.altervista.org/Immagini/gilberrthegame2community_logo.gif','https://citraverse.altervista.org/Immagini/gilberrthegame2community_banner.jpeg',0,6,1,2761,'2025-09-25 22:07:24',0),(15535798,'smg4','smg4 community, the icon and banner are placeholders','https://citraverse.altervista.org/Immagini/smg4_logo.png','https://citraverse.altervista.org/Immagini/smg4_banner.png',0,6,1,2748,'2025-09-26 00:03:07',0),(15853898,'Paper Mario: Color Splash Community','This community is to talk about Paper Mario: Color Splash!','https://citraverse.altervista.org/Immagini/papermariocolorsplashcommunity_logo.png','https://citraverse.altervista.org/Immagini/papermariocolorsplashcommunity_banner.png',0,1,0,2747,'2025-09-25 21:07:23',0),(16331073,'Paper Mario: Sticker Star Community','This community is to talk about Paper Mario: Sticker Star!','https://citraverse.altervista.org/Immagini/papermariostickerstarcommunity_logo.png','https://citraverse.altervista.org/Immagini/papermariostickerstarcommunity_banner.png',0,2,0,2747,'2025-09-25 22:07:15',0),(17035808,'Donkey Kong CountryTropical Freeze Community','This community is to talk about Donkey Kong CountryTropical Freeze!','https://citraverse.altervista.org/Immagini/donkeykongcountrytropicalfreezecommunity_logo.png','https://citraverse.altervista.org/Immagini/donkeykongcountrytropicalfreezecommunity_banner.png',0,1,0,2747,'2025-09-25 21:05:14',0),(19753685,'Jey Uso ','Jey Uso','https://citraverse.altervista.org/Immagini/jeyuso_logo.png','https://citraverse.altervista.org/Immagini/jeyuso_banner.png',0,6,1,2752,'2025-09-25 16:10:16',0),(23593225,'The Legend of Zelda: The Wind Waker HD Community','This community is to talk about Legend of Zelda: The Wind Waker HD','https://citraverse.altervista.org/Immagini/thelegendofzeldathewindwakerhdcommunity_logo.png','https://citraverse.altervista.org/Immagini/thelegendofzeldathewindwakerhdcommunity_banner.png',0,1,0,2747,'2025-09-25 17:59:58',0),(23997392,'Sonic & All-Stars Racing Transformed™ Community','This community is to talk about Sonic & All-Stars Racing Transformed™!','https://citraverse.altervista.org/Immagini/sonicall-starsracingtransformedcommunity_logo.png','https://citraverse.altervista.org/Immagini/sonicall-starsracingtransformedcommunity_banner.png',0,1,0,2747,'2025-09-25 22:09:57',0),(24759419,'Sonic Lost World Community','This community is to talk about Sonic Lost World!','https://citraverse.altervista.org/Immagini/soniclostworldcommunity_logo.png','https://citraverse.altervista.org/Immagini/soniclostworldcommunity_banner.png',0,1,0,2747,'2025-09-25 18:50:39',0),(25131469,'YouTube Community','This community is to talk about Youtube','https://citraverse.altervista.org/Immagini/youtubecommunity_logo.png','https://citraverse.altervista.org/Immagini/youtubecommunity_banner.png',0,3,0,2747,'2025-09-25 17:50:04',0),(26827823,'Announcements','This is the official community for reciving Citraverse announcements','https://citraverse.altervista.org/Immagini/announcements_logo.jpg','https://citraverse.altervista.org/Immagini/announcements_banner.jpg',1,5,0,2747,'2025-09-26 02:00:27',0),(27775319,'Xenoblade Chronicles X Community','This community is to talk about Xenoblade Chronicles X!','https://citraverse.altervista.org/Immagini/xenobladechroniclesxcommunity_logo.png','https://citraverse.altervista.org/Immagini/xenobladechroniclesxcommunity_banner.png',0,2,0,2747,'2025-09-25 19:13:49',0),(27891573,'Sonic Lost World™ 3DS Community','This community is to talk about Sonic Lost World™ 3DS!','https://citraverse.altervista.org/Immagini/soniclostworld3dscommunity_logo.png','https://citraverse.altervista.org/Immagini/soniclostworld3dscommunity_banner.png',0,2,0,2747,'2025-09-25 22:08:04',0),(28400332,'Game & Wario','This community is to talk about Game & Wario!','https://citraverse.altervista.org/Immagini/gamewario_logo.png','https://citraverse.altervista.org/Immagini/gamewario_banner.png',0,1,0,2747,'2025-09-25 18:45:44',0),(28421288,'Pokémon Rumble World Community','This community is to talk about Pokémon Rumble World!','https://citraverse.altervista.org/Immagini/pokmonrumbleworldcommunity_logo.png','https://citraverse.altervista.org/Immagini/pokmonrumbleworldcommunity_banner.png',0,2,0,2747,'2025-09-25 19:22:21',0),(28630271,'HATSUNE MIKU Project mirai Community (MAINTENANCE)','Talk about HATSUNE MIKU Project mirai!','https://citraverse.altervista.org/Immagini/hatsunemikuprojectmiraicommunity_logo.png','https://citraverse.altervista.org/Immagini/hatsunemikuprojectmiraicommunity_banner.png',0,6,1,2747,'2025-09-26 13:47:23',1),(30238126,'Luigi’s Mansion 2 Community','This community is to talk about Luigi’s Mansion 2!','https://citraverse.altervista.org/Immagini/luigismansion2community_logo.png','https://citraverse.altervista.org/Immagini/luigismansion2community_banner.png',0,2,0,2747,'2025-09-25 21:12:11',0),(30639016,'Yoshi\'s Woolly World Community','This community is to talk about Yoshi\'s Woolly World!','https://citraverse.altervista.org/Immagini/yoshiswoollyworldcommunity_logo.png','https://citraverse.altervista.org/Immagini/yoshiswoollyworldcommunity_banner.png',0,1,0,2747,'2025-09-25 19:31:43',0),(31024294,'Monster Hunter 3 Ultimate Community','This community is to talk about Monster Hunter 3 Ultimate!','https://citraverse.altervista.org/Immagini/monsterhunter3ultimatecommunity_logo.png','https://citraverse.altervista.org/Immagini/monsterhunter3ultimatecommunity_banner.png',0,3,0,2747,'2025-09-25 19:38:57',0),(31447370,'Mario Kart 7 Community','This community is to talk about Mario Kart 7\r\n\r\n','https://citraverse.altervista.org/Immagini/mariokart7community_logo.png','https://citraverse.altervista.org/Immagini/mariokart7community_banner.jpeg',0,2,0,2747,'2025-09-25 14:46:43',0),(33184286,'SPURS COMMUNITY','we love glazing the san antonio spurs and utsa roadrunners !!!','https://citraverse.altervista.org/Immagini/spurscommunity_logo.jpg','https://citraverse.altervista.org/Immagini/spurscommunity_banner.jpg',0,6,1,2761,'2025-09-25 21:45:38',0),(33342332,'Pokémon Omega Ruby & Alpha Sapphire Community','This community is to talk about Pokémon Omega Ruby & Alpha Sapphire!','https://citraverse.altervista.org/Immagini/pokmonomegarubyalphasapphirecommunity_logo.png','https://citraverse.altervista.org/Immagini/pokmonomegarubyalphasapphirecommunity_banner.png',0,2,0,2747,'2025-09-25 19:43:16',0),(33891986,'ZombiU™ Community','This community is to talk about about ZombiU™!','https://citraverse.altervista.org/Immagini/zombiucommunity_logo.png','https://citraverse.altervista.org/Immagini/zombiucommunity_banner.png',0,1,0,2747,'2025-09-25 21:04:34',0),(34657907,'NES REMIX Series Community','This community is to talk about NES REMIX Series!','https://citraverse.altervista.org/Immagini/nesremixseriescommunity_logo.png','https://citraverse.altervista.org/Immagini/nesremixseriescommunity_banner.png',0,3,0,2747,'2025-09-25 19:18:40',0),(35251579,'MUSTAAAAAAAAAAAAAAAARD','MUSTAAAAAAAAAAAAAAAARD','https://citraverse.altervista.org/Immagini/mustaaaaaaaaaaaaaaaard_logo.png','https://citraverse.altervista.org/Immagini/mustaaaaaaaaaaaaaaaard_banner.png',0,6,1,2755,'2025-09-25 18:24:52',0),(35713751,'Homebrew Community','This community is to talk about Homebrew!','https://citraverse.altervista.org/Immagini/homebrewcommunity_logo.png','https://citraverse.altervista.org/Immagini/homebrewcommunity_banner.png',0,3,0,2747,'2025-09-25 18:29:05',0),(36862897,'tyler, the community','tamale','https://citraverse.altervista.org/Immagini/tylerthecommunity_logo.gif','https://citraverse.altervista.org/Immagini/tylerthecommunity_banner.gif',0,6,1,2761,'2025-09-25 22:37:28',0),(37019342,'New Super Mario Bros. 2 Community','This community is to talk about New Super Mario Bros. 2!','https://citraverse.altervista.org/Immagini/newsupermariobros2community_logo.png','https://citraverse.altervista.org/Immagini/newsupermariobros2community_banner.png',0,2,0,2747,'2025-09-25 19:34:51',0),(37659181,'Pikmin 3 Community','This community is to talk about Pikmin 3','https://citraverse.altervista.org/Immagini/pikmin3community_logo.png','https://citraverse.altervista.org/Immagini/pikmin3community_banner.png',0,1,0,2747,'2025-09-25 18:47:10',0),(39021849,'OVO Community','For fans of popular music artist Drake.','https://citraverse.altervista.org/Immagini/ovocommunity_logo.webp','https://citraverse.altervista.org/Immagini/ovocommunity_banner.webp',0,6,1,2757,'2025-09-25 18:25:07',0),(39610354,'Yeet','Yeet','https://citraverse.altervista.org/Immagini/yeet_logo.jpg','https://citraverse.altervista.org/Immagini/yeet_banner.png',0,6,1,2752,'2025-09-25 16:15:08',0),(39733740,'Call of Duty®: Black Ops II Community','This community is to talk about Call of Duty®: Black Ops II!','https://citraverse.altervista.org/Immagini/callofdutyblackopsiicommunity_logo.png','https://citraverse.altervista.org/Immagini/callofdutyblackopsiicommunity_banner.png',0,1,0,2747,'2025-09-25 19:41:21',0),(41063052,'Cody rhodes','Jey Uso','https://citraverse.altervista.org/Immagini/codyrhodes_logo.jpg','https://citraverse.altervista.org/Immagini/codyrhodes_banner.png',0,6,1,2752,'2025-09-25 16:13:25',0),(41225300,'amiibo tap: Nintendo’s Greatest Bits Community','This community is to talk about amiibo tap: Nintendo’s Greatest Bits!','https://citraverse.altervista.org/Immagini/amiibotapnintendosgreatestbitscommunity_logo.png','https://citraverse.altervista.org/Immagini/amiibotapnintendosgreatestbitscommunity_banner.png',0,1,0,2747,'2025-09-25 21:23:35',0),(41809747,'The Legend of Zelda: Twilight Princess HD Community','This community is to talk about The Legend of Zelda: Twilight Princess HD!','https://citraverse.altervista.org/Immagini/thelegendofzeldatwilightprincesshdcommunity_logo.png','https://citraverse.altervista.org/Immagini/thelegendofzeldatwilightprincesshdcommunity_banner.png',0,1,0,2747,'2025-09-25 19:36:39',0),(43959263,'Scribblenauts™ Unlimited Community','This community is to talk about Scribblenauts™ Unlimited!','https://citraverse.altervista.org/Immagini/scribblenautsunlimitedcommunity_logo.png','https://citraverse.altervista.org/Immagini/scribblenautsunlimitedcommunity_banner.png',0,3,0,2747,'2025-09-25 22:00:17',0),(44178846,'Animal Crossing Series Community','This community is to talk about Animal Crossing','https://citraverse.altervista.org/Immagini/animalcrossingseriescommunity_logo.png','https://citraverse.altervista.org/Immagini/animalcrossingseriescommunity_banner.png',0,3,0,2747,'2025-09-25 18:17:56',0),(44799717,'Pokkén Tournament Community','This community is to talk about Pokkén Tournament!','https://citraverse.altervista.org/Immagini/pokkntournamentcommunity_logo.png','https://citraverse.altervista.org/Immagini/pokkntournamentcommunity_banner.png',0,1,0,2747,'2025-09-25 21:03:11',0),(45890494,'Phineas and Ferb: Quest for Cool Stuff Community','A Phineas and Ferb Cartoon Game ','https://citraverse.altervista.org/Immagini/phineasandferbquestforcoolstuffcommunity_logo.png','https://citraverse.altervista.org/Immagini/phineasandferbquestforcoolstuffcommunity_banner.png',0,3,0,2747,'2025-09-25 17:44:58',0),(46133470,'Pokémon Sun & Moon Community','This community is to talk about Pokémon Sun & Moon!','https://citraverse.altervista.org/Immagini/pokmonsunmooncommunity_logo.png','https://citraverse.altervista.org/Immagini/pokmonsunmooncommunity_banner.png',0,2,0,2747,'2025-09-25 21:25:10',0),(47020925,'Nintendo Tvii Community','This community is to talk about Tvii\r\n\r\n','https://citraverse.altervista.org/Immagini/nintendotviicommunity_logo.png','https://citraverse.altervista.org/Immagini/nintendotviicommunity_banner.jpeg',0,1,0,2747,'2025-09-25 15:52:31',0),(48039089,'gilberr cool community','gilberr san very cool','https://citraverse.altervista.org/Immagini/gilberrcoolcommunity_logo.png','https://citraverse.altervista.org/Immagini/gilberrcoolcommunity_banner.png',0,6,1,2761,'2025-09-25 21:01:45',0),(48883692,'Hatsune Miku: Project Mirai DX Community','This community is to talk about Hatsune Miku: Project Mirai DX!','https://citraverse.altervista.org/Immagini/hatsunemikuprojectmiraidxcommunity_logo.png','https://citraverse.altervista.org/Immagini/hatsunemikuprojectmiraidxcommunity_banner.png',0,2,0,2747,'2025-09-25 21:08:01',0),(50175340,'Mario vs. Donkey Kong: Tipping Stars Community','This community is to talk about Mario vs. Donkey Kong: Tipping Stars!','https://citraverse.altervista.org/Immagini/mariovsdonkeykongtippingstarscommunity_logo.png','https://citraverse.altervista.org/Immagini/mariovsdonkeykongtippingstarscommunity_banner.png',0,3,0,2747,'2025-09-25 19:15:07',0),(53302854,'The Legend of Zelda: Breath of the Wild Community','This community is to talk about The Legend of Zelda: Breath of the Wild!','https://citraverse.altervista.org/Immagini/thelegendofzeldabreathofthewildcommunity_logo.png','https://citraverse.altervista.org/Immagini/thelegendofzeldabreathofthewildcommunity_banner.png',0,1,0,2747,'2025-09-25 19:20:53',0),(53573763,'LEGO® Dimensions™ Community','This community is to talk about LEGO® Dimensions™!','https://citraverse.altervista.org/Immagini/legodimensionscommunity_logo.png','https://citraverse.altervista.org/Immagini/legodimensionscommunity_banner.png',0,1,0,2747,'2025-09-25 22:12:10',0),(54667199,'Captain Toad: Treasure Tracker Community','This community is to talk about Captain Toad: Treasure Tracker!','https://citraverse.altervista.org/Immagini/captaintoadtreasuretrackercommunity_logo.png','https://citraverse.altervista.org/Immagini/captaintoadtreasuretrackercommunity_banner.png',0,3,0,2747,'2025-09-25 21:06:01',0),(55040681,'Hulk hogan ','Jey Uso','https://citraverse.altervista.org/Immagini/hulkhogan_logo.jpg','https://citraverse.altervista.org/Immagini/hulkhogan_banner.png',0,6,1,2752,'2025-09-25 16:13:15',0),(55804602,'Pokémon Rumble U Community','This community is to talk about Pokémon Rumble U!','https://citraverse.altervista.org/Immagini/pokmonrumbleucommunity_logo.png','https://citraverse.altervista.org/Immagini/pokmonrumbleucommunity_banner.png',0,1,0,2747,'2025-09-25 21:06:47',0),(56093419,'Puyopuyo Tetris Community','This community is to talk about Puyopuyo Tetris!','https://citraverse.altervista.org/Immagini/puyopuyotetriscommunity_logo.png','https://citraverse.altervista.org/Immagini/puyopuyotetriscommunity_banner.png',0,3,0,2747,'2025-09-25 22:01:21',0),(56557911,'Pokémon Picross Community','Talk about Pokémon Picross!','https://citraverse.altervista.org/Immagini/pokmonpicrosscommunity_logo.png','https://citraverse.altervista.org/Immagini/pokmonpicrosscommunity_banner.png',0,2,0,2747,'2025-09-26 15:05:11',0),(56745184,'niconico Community','This community is to talk about Niconico','https://citraverse.altervista.org/Immagini/niconicocommunity_logo.png','https://citraverse.altervista.org/Immagini/niconicocommunity_banner.png',0,1,0,2747,'2025-09-25 17:57:41',0),(57631309,'Yoshi\'s New Island Community','This community is to talk about Yoshi\'s New Island!','https://citraverse.altervista.org/Immagini/yoshisnewislandcommunity_logo.png','https://citraverse.altervista.org/Immagini/yoshisnewislandcommunity_banner.png',0,2,0,2747,'2025-09-25 22:11:14',0),(57728771,'Minecraft: Wii U Edition Community','This community is to talk about Minecraft Wii U','https://citraverse.altervista.org/Immagini/minecraftwiiueditioncommunity_logo.png','https://citraverse.altervista.org/Immagini/minecraftwiiueditioncommunity_banner.png',0,1,0,2747,'2025-09-25 17:53:07',0),(58339009,'General chat','This is a general chat where you can talk of anything you want','https://citraverse.altervista.org/Immagini/generalchat_logo.jpg','https://citraverse.altervista.org/Immagini/generalchat_banner.jpg',0,0,0,2747,'2025-09-25 13:48:11',0),(58655069,'Miitopia Community','This community is to talk about Miitopia','https://citraverse.altervista.org/Immagini/miitopiacommunity_logo.png','https://citraverse.altervista.org/Immagini/miitopiacommunity_banner.jpeg',0,1,0,2747,'2025-09-25 17:33:36',0),(59151983,'Netflix Community','This community is to talk about Netflix!\r\n','https://citraverse.altervista.org/Immagini/netflixcommunity_logo.png','https://citraverse.altervista.org/Immagini/netflixcommunity_banner.png',0,3,0,2747,'2025-09-25 19:32:47',0),(59218003,'New Super Mario Bros U Community','This community is to talk about NSMBU','https://citraverse.altervista.org/Immagini/newsupermariobrosucommunity_logo.png','https://citraverse.altervista.org/Immagini/newsupermariobrosucommunity_banner.png',0,1,0,2747,'2025-09-25 18:13:57',0),(59590432,'Nintendo Land Community','This community is to talk about Nintendo Land','https://citraverse.altervista.org/Immagini/nintendolandcommunity_logo.png','https://citraverse.altervista.org/Immagini/nintendolandcommunity_banner.png',0,1,0,2747,'2025-09-25 17:55:08',0),(59986307,'REAL AMERICAN PATRIOTS ONLY!','REAL AMERICAN PATRIOTS ONLY!','https://citraverse.altervista.org/Immagini/realamericanpatriotsonly_logo.jpg','https://citraverse.altervista.org/Immagini/realamericanpatriotsonly_banner.jpg',0,6,1,2753,'2025-09-25 16:32:47',0),(60173845,'Kid Icarus: Uprising Community','This community is to talk about Kid Icarus: Uprising','https://citraverse.altervista.org/Immagini/kidicarusuprisingcommunity_logo.png','https://citraverse.altervista.org/Immagini/kidicarusuprisingcommunity_banner.png',0,2,0,2747,'2025-09-25 19:39:39',0),(62088719,'Pokémon Art Academy Community','This community is to talk about Pokémon Art Academy','https://citraverse.altervista.org/Immagini/pokmonartacademycommunity_logo.png','https://citraverse.altervista.org/Immagini/pokmonartacademycommunity_banner.png',0,2,0,2747,'2025-09-25 18:49:13',0),(62104540,'Wii Karaoke U Community','This community is to talk about Wii Karaoke U!','https://citraverse.altervista.org/Immagini/wiikaraokeucommunity_logo.png','https://citraverse.altervista.org/Immagini/wiikaraokeucommunity_banner.png',0,1,0,2747,'2025-09-25 21:56:00',0),(63380730,'Kirby: Triple Deluxe Community','Talk about Kirby: Triple Deluxe!','https://citraverse.altervista.org/Immagini/kirbytripledeluxecommunity_logo.png','https://citraverse.altervista.org/Immagini/kirbytripledeluxecommunity_banner.png',0,2,0,2747,'2025-09-26 14:54:49',0),(64003498,'StreetPass Mii Plaza Community','This community is to talk about StreetPass Mii Plaza!','https://citraverse.altervista.org/Immagini/streetpassmiiplazacommunity_logo.png','https://citraverse.altervista.org/Immagini/streetpassmiiplazacommunity_banner.png',0,2,0,2747,'2025-09-25 21:09:53',0),(64165240,'Mario Party 10 Community','This community is to talk about Mario Party 10!','https://citraverse.altervista.org/Immagini/marioparty10community_logo.png','https://citraverse.altervista.org/Immagini/marioparty10community_banner.png',0,1,0,2747,'2025-09-25 19:17:12',0),(64382903,'Happy Home Designer Community','This community is to talk about Happy Home Designer!','https://citraverse.altervista.org/Immagini/happyhomedesignercommunity_logo.png','https://citraverse.altervista.org/Immagini/happyhomedesignercommunity_banner.png',0,2,0,2747,'2025-09-25 21:58:21',0),(65087970,'Art Academy Community','This community is to talk about Art!','https://citraverse.altervista.org/Immagini/artacademycommunity_logo.png','https://citraverse.altervista.org/Immagini/artacademycommunity_banner.png',0,3,0,2747,'2025-09-25 18:23:30',0),(65899968,'WWE Fans','Community for fans of World Wrestling Entertainment!','https://citraverse.altervista.org/Immagini/wwefans_logo.webp','https://citraverse.altervista.org/Immagini/wwefans_banner.png',0,6,1,2757,'2025-09-25 18:14:39',0),(68700447,'Super Mario 3D Land Community','This community is to talk about Super Mario 3D Land','https://citraverse.altervista.org/Immagini/supermario3dlandcommunity_logo.png','https://citraverse.altervista.org/Immagini/supermario3dlandcommunity_banner.png',0,2,0,2747,'2025-09-25 19:23:38',0),(68998844,'Wii Fit U Community','This community is to talk about Wii Fit U','https://citraverse.altervista.org/Immagini/wiifitucommunity_logo.png','https://citraverse.altervista.org/Immagini/wiifitucommunity_banner.png',0,1,0,2747,'2025-09-25 18:02:35',0),(69573224,'FIFA 15 Community','This community is to talk about FIFA 15!','https://citraverse.altervista.org/Immagini/fifa15community_logo.png','https://citraverse.altervista.org/Immagini/fifa15community_banner.png',0,2,0,2747,'2025-09-25 22:09:06',0),(70092491,'gilberr the game 3: lost in the sauce: the community','sauce the boss','https://citraverse.altervista.org/Immagini/gilberrthegame3lostinthesaucethecommunity_logo.png','https://citraverse.altervista.org/Immagini/gilberrthegame3lostinthesaucethecommunity_banner.gif',0,6,1,2761,'2025-09-25 22:11:46',0),(70446009,'Mario Kart 8 Community','This community is to talk about Mario Kart 8','https://citraverse.altervista.org/Immagini/mariokart8community_logo.png','https://citraverse.altervista.org/Immagini/mariokart8community_banner.png',0,1,0,2747,'2025-09-25 17:46:58',0),(70560985,'Crunchyroll Community','Watch Animes!','https://citraverse.altervista.org/Immagini/crunchyrollcommunity_logo.png','https://citraverse.altervista.org/Immagini/crunchyrollcommunity_banner.png',0,6,1,2758,'2025-09-25 22:06:39',0),(71877175,'Super Smash Bros. 3DS/Wii U Community','This community is to talk about Smas bros','https://citraverse.altervista.org/Immagini/supersmashbros3dswiiucommunity_logo.png','https://citraverse.altervista.org/Immagini/supersmashbros3dswiiucommunity_banner.jpeg',0,3,0,2747,'2025-09-25 14:54:25',0),(75290133,'Wii Sports Club Community','This community is to talk about Wii Sports Club!','https://citraverse.altervista.org/Immagini/wiisportsclubcommunity_logo.png','https://citraverse.altervista.org/Immagini/wiisportsclubcommunity_banner.png',0,1,0,2747,'2025-09-25 19:35:51',0),(76197397,'HATSUNE MIKU Project mirai Community  ','Talk about HATSUNE MIKU Project mirai!','https://citraverse.altervista.org/Immagini/hatsunemikuprojectmiraicommunity_logo.png','https://citraverse.altervista.org/Immagini/hatsunemikuprojectmiraicommunity_banner.png',0,2,0,2747,'2025-09-26 14:43:47',0),(76576368,'MARIO & SONIC AT THE RIO 2016 OLYMPIC GAMES Community','This community is to talk about Mario and Sonic at the rio 2016 olympic games!','https://citraverse.altervista.org/Immagini/mariosonicattherio2016olympicgamescommunity_logo.png','https://citraverse.altervista.org/Immagini/mariosonicattherio2016olympicgamescommunity_banner.png',0,2,0,2747,'2025-09-25 18:52:31',0),(76678613,'nintendogs + cats Community','This community is to talk about nintendogs + cats','https://citraverse.altervista.org/Immagini/nintendogscatscommunity_logo.png','https://citraverse.altervista.org/Immagini/nintendogscatscommunity_banner.jpeg',0,2,0,2747,'2025-09-25 17:29:41',0),(76740503,'Tomodachi Life Community','This community is to talk about Tomodachi Life','https://citraverse.altervista.org/Immagini/tomodachilifecommunity_logo.png','https://citraverse.altervista.org/Immagini/tomodachilifecommunity_banner.jpeg',0,2,0,2747,'2025-09-25 14:23:37',0),(77588920,'Rayman® Legends Community','This community is to talk about Rayman Legends!','https://citraverse.altervista.org/Immagini/raymanlegendscommunity_logo.png','https://citraverse.altervista.org/Immagini/raymanlegendscommunity_banner.png',0,1,0,2747,'2025-09-25 19:19:39',0),(78964754,'The Legend of Zelda: Tri Force Heroes Community','This community is to talk about The Legend of Zelda: Tri Force Heroes!','https://citraverse.altervista.org/Immagini/thelegendofzeldatriforceheroescommunity_logo.png','https://citraverse.altervista.org/Immagini/thelegendofzeldatriforceheroescommunity_banner.png',0,2,0,2747,'2025-09-25 21:03:47',0),(79055760,'Mario Party: Island Tour Community','This community is to talk about Mario Party: Island Tour!','https://citraverse.altervista.org/Immagini/mariopartyislandtourcommunity_logo.png','https://citraverse.altervista.org/Immagini/mariopartyislandtourcommunity_banner.png',0,2,0,2747,'2025-09-25 22:05:58',0),(80068537,'Hulu Plus Community','Talk about Hulu Plus !','https://citraverse.altervista.org/Immagini/hulupluscommunity_logo.png','https://citraverse.altervista.org/Immagini/hulupluscommunity_banner.png',0,3,0,2747,'2025-09-26 14:57:43',0),(80737080,'The Legend of Zelda: Ocarina of Time 3D Community','This community is to talk about The Legend of Zelda: Ocarina of Time 3D!','https://citraverse.altervista.org/Immagini/thelegendofzeldaocarinaoftime3dcommunity_logo.png','https://citraverse.altervista.org/Immagini/thelegendofzeldaocarinaoftime3dcommunity_banner.png',0,2,0,2747,'2025-09-25 21:59:26',0),(82602191,'Joe Hendry ','Jey Uso','https://citraverse.altervista.org/Immagini/joehendry_logo.jpg','https://citraverse.altervista.org/Immagini/joehendry_banner.png',0,6,1,2752,'2025-09-25 16:12:20',0),(82916530,'Sonic Boom: Rise of Lyric Community','This community is to talk about Sonic Boom: Rise of Lyric!','https://citraverse.altervista.org/Immagini/sonicboomriseoflyriccommunity_logo.png','https://citraverse.altervista.org/Immagini/sonicboomriseoflyriccommunity_banner.png',0,1,0,2747,'2025-09-25 22:03:21',0),(83961895,'Super mario 3D world Community','This community is to talk about Super mario 3D world','https://citraverse.altervista.org/Immagini/supermario3dworldcommunity_logo.png','https://citraverse.altervista.org/Immagini/supermario3dworldcommunity_banner.jpeg',0,1,0,2747,'2025-09-25 14:55:24',0),(84125177,'Austin Theory Haters Group Because Hes Way Too Smug And Rude!','Jey Uso','https://citraverse.altervista.org/Immagini/austintheoryhatersgroupbecauseheswaytoosmugandrude_logo.jpg','https://citraverse.altervista.org/Immagini/austintheoryhatersgroupbecauseheswaytoosmugandrude_banner.png',0,6,1,2752,'2025-09-25 16:14:12',0),(84262953,'Animal Crossing New Leaf Community','This community is to talk about Animal crossing new leaf','https://citraverse.altervista.org/Immagini/animalcrossingnewleafcommunity_logo.png','https://citraverse.altervista.org/Immagini/animalcrossingnewleafcommunity_banner.jpeg',0,2,0,2747,'2025-09-25 14:58:28',0),(85980725,'Sonic Mania (Homebrew)','Talk about Sonic Mania!','https://citraverse.altervista.org/Immagini/sonicmaniahomebrew_logo.png','https://citraverse.altervista.org/Immagini/sonicmaniahomebrew_banner.png',0,6,1,2758,'2025-09-25 22:05:01',0),(86393287,'New Super Luigi U Community','This community is to talk about NSLU','https://citraverse.altervista.org/Immagini/newsuperluigiucommunity_logo.png','https://citraverse.altervista.org/Immagini/newsuperluigiucommunity_banner.png',0,1,0,2747,'2025-09-25 18:15:08',0),(86518379,'Dandy\'s World Community (Roblox)','As a Roblox game, Dandy\'s World requires both an active internet connection and a Roblox account in order to play the game. The player can choose to either join a public server or host a private one for free, although private servers are highly recommended if it is your first time playing the game.','https://citraverse.altervista.org/Immagini/dandysworldcommunityroblox_logo.png','https://citraverse.altervista.org/Immagini/dandysworldcommunityroblox_banner.png',0,6,1,2758,'2025-09-25 17:40:17',0),(87749713,'Hyrule Warriors Community','This community is to talk about Hyrule Warriors!','https://citraverse.altervista.org/Immagini/hyrulewarriorscommunity_logo.png','https://citraverse.altervista.org/Immagini/hyrulewarriorscommunity_banner.png',0,3,0,2747,'2025-09-25 18:25:50',0),(89626656,'Mario & Luigi: Dream Team Community','Talk about Mario & Luigi: Dream Team!','https://citraverse.altervista.org/Immagini/marioluigidreamteamcommunity_logo.png','https://citraverse.altervista.org/Immagini/marioluigidreamteamcommunity_banner.png',0,2,0,2747,'2025-09-26 14:25:53',0),(91689487,'Ric Flair','Jey Uso','https://citraverse.altervista.org/Immagini/ricflair_logo.jpg','https://citraverse.altervista.org/Immagini/ricflair_banner.png',0,6,1,2752,'2025-09-25 16:12:34',0),(92602544,'ONE PIECE Unlimited World Red Community','Talk about ONE PIECE Unlimited World Red!','https://citraverse.altervista.org/Immagini/onepieceunlimitedworldredcommunity_logo.png','https://citraverse.altervista.org/Immagini/onepieceunlimitedworldredcommunity_banner.png',0,1,0,2747,'2025-09-26 15:01:13',0),(93697327,'Nintendo Badge Arcade Community','This community is to talk about Nintendo Badge Arcade','https://citraverse.altervista.org/Immagini/nintendobadgearcadecommunity_logo.png','https://citraverse.altervista.org/Immagini/nintendobadgearcadecommunity_banner.png',0,2,0,2747,'2025-09-25 18:04:41',0),(94042234,'MONSTER HUNTER 4G Community','Talk about MONSTER HUNTER 4G!','https://citraverse.altervista.org/Immagini/monsterhunter4gcommunity_logo.png','https://citraverse.altervista.org/Immagini/monsterhunter4gcommunity_banner.png',0,2,0,2747,'2025-09-26 13:49:42',0),(94180708,'The Year of Luigi Community','Special Community!','https://citraverse.altervista.org/Immagini/theyearofluigicommunity_logo.png','https://citraverse.altervista.org/Immagini/theyearofluigicommunity_banner.png',0,1,0,2747,'2025-09-26 14:41:29',0),(95058927,'Pokémon Shuffle Community','This community is to talk about Pokémon Shuffle!','https://citraverse.altervista.org/Immagini/pokmonshufflecommunity_logo.png','https://citraverse.altervista.org/Immagini/pokmonshufflecommunity_banner.png',0,2,0,2747,'2025-09-25 18:42:14',0),(96227589,'Mario & Sonic at the Sochi 2014 Olympic Winter Games Community','This community is to talk about Mario & Sonic at the Sochi 2014 Olympic Winter Games!','https://citraverse.altervista.org/Immagini/mariosonicatthesochi2014olympicwintergamescommunity_logo.png','https://citraverse.altervista.org/Immagini/mariosonicatthesochi2014olympicwintergamescommunity_banner.png',0,1,0,2747,'2025-09-25 19:33:32',0),(97000035,'gilberr the game community','play my game','https://citraverse.altervista.org/Immagini/gilberrthegamecommunity_logo.jpeg','https://citraverse.altervista.org/Immagini/gilberrthegamecommunity_banner.png',0,6,1,2761,'2025-09-25 21:35:57',0),(97295282,'Mii community','A community for all things related to Miis!','https://citraverse.altervista.org/Immagini/miicommunity_logo.png','https://citraverse.altervista.org/Immagini/miicommunity_banner.png',0,6,1,2766,'2025-09-27 05:52:44',1),(97727852,'Star Fox Zero Community','This community is to talk about Star Fox Zero!','https://citraverse.altervista.org/Immagini/starfoxzerocommunity_logo.png','https://citraverse.altervista.org/Immagini/starfoxzerocommunity_banner.png',0,1,0,2747,'2025-09-25 22:10:34',0),(98475796,'Splatoon Community','This community is to talk about Splatoon 1','https://citraverse.altervista.org/Immagini/splatooncommunity_logo.png','https://citraverse.altervista.org/Immagini/splatooncommunity_banner.png',0,1,0,2747,'2025-09-25 14:54:52',0),(98537988,'Super Mario Maker For Nintendo 3DS Community','This community is to talk about Super Mario Maker For Nintendo 3DS!','https://citraverse.altervista.org/Immagini/supermariomakerfornintendo3dscommunity_logo.png','https://citraverse.altervista.org/Immagini/supermariomakerfornintendo3dscommunity_banner.png',0,2,0,2747,'2025-09-25 21:10:47',0),(98620794,'Super Mario Maker Community','This community is to talk about Super Mario Maker','https://citraverse.altervista.org/Immagini/supermariomakercommunity_logo.png','https://citraverse.altervista.org/Immagini/supermariomakercommunity_banner.jpeg',0,1,0,2747,'2025-09-25 17:37:03',0);

--
-- Table structure for table `yeahs`
--

CREATE TABLE `yeahs` (
  `yeah_id` int(11) NOT NULL AUTO_INCREMENT,
  `yeah_post` int(11) NOT NULL,
  `type` enum('post','reply') CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'post',
  `date_time` datetime NOT NULL DEFAULT current_timestamp(),
  `yeah_by` int(11) NOT NULL,
  PRIMARY KEY (`yeah_id`),
  UNIQUE KEY `yeah_post` (`yeah_post`,`type`,`yeah_by`),
  KEY `yeah_by` (`yeah_by`),
  CONSTRAINT `yeahs_ibfk_1` FOREIGN KEY (`yeah_by`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=223 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `yeahs`
--

INSERT INTO `yeahs` VALUES (174,5123850,'post','2025-09-25 13:52:58',2748),(175,42500465,'post','2025-09-25 16:37:08',2757),(176,877281,'post','2025-09-25 17:00:51',2747),(177,47858694,'post','2025-09-25 17:39:59',2747),(178,78656999,'post','2025-09-25 17:42:01',2758),(179,75875925,'post','2025-09-25 17:51:39',2754),(180,3795803,'post','2025-09-25 17:56:43',2754),(181,35892347,'post','2025-09-25 17:56:46',2754),(182,13943542,'post','2025-09-25 18:11:53',2757),(183,65796923,'post','2025-09-25 18:15:55',2757),(186,92479252,'reply','2025-09-25 18:27:54',2757),(188,91983123,'post','2025-09-25 21:02:16',2750),(193,92585587,'post','2025-09-25 21:04:26',2750),(194,65305894,'post','2025-09-25 21:05:36',2761),(195,74488942,'post','2025-09-25 21:34:03',2761),(196,51993907,'post','2025-09-25 21:34:04',2761),(197,12189493,'post','2025-09-26 01:51:14',2747),(198,90390887,'post','2025-09-26 04:10:38',2747),(199,87764935,'post','2025-09-26 06:25:52',2748),(200,87764935,'post','2025-09-26 09:25:54',2763),(201,2405443,'post','2025-09-26 12:33:52',2748),(202,78879657,'post','2025-09-26 12:44:25',2754),(203,5123850,'post','2025-09-26 12:47:44',2754),(204,78879657,'post','2025-09-26 13:00:00',2756),(205,60536450,'post','2025-09-26 16:03:33',2747),(206,85483073,'post','2025-09-26 16:06:12',2747),(207,4263649,'post','2025-09-26 18:28:07',2754),(208,92912809,'post','2025-09-27 05:29:25',2763),(209,182115,'post','2025-09-27 05:48:54',2766),(210,4263649,'post','2025-09-27 05:49:06',2766),(211,61798573,'reply','2025-09-27 05:53:01',2766),(213,6723476,'reply','2025-09-27 05:53:52',2766),(214,7332760,'reply','2025-09-27 05:57:59',2766),(215,48952635,'reply','2025-09-27 05:00:28',2766),(216,87764935,'post','2025-09-27 06:04:14',2766),(217,42674944,'reply','2025-09-27 06:06:29',2766),(218,84942271,'post','2025-09-27 06:12:41',2747),(219,62593877,'post','2025-09-27 07:35:52',2754),(220,182115,'post','2025-09-27 07:36:01',2754),(221,60536450,'post','2025-09-27 08:07:43',2748),(222,657837,'reply','2025-09-27 08:16:15',2748);


