| Server IP : 95.111.224.176 / Your IP : 216.73.217.99 Web Server : Apache/2.4.58 (Ubuntu) System : Linux vmi550611.contaboserver.net 6.8.0-147-generic #147-Ubuntu SMP PREEMPT_DYNAMIC Thu Sep 24 11:33:16 UTC 2026 x86_64 User : aoneairsolution ( 1064) PHP Version : 8.3.6 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /var/ |
Upload File : |
-- MySQL dump 10.19 Distrib 10.3.39-MariaDB, for debian-linux-gnu (x86_64) -- -- Host: localhost Database: the_gangster -- ------------------------------------------------------ -- Server version 10.3.39-MariaDB-0ubuntu0.20.04.2 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `blog` -- DROP TABLE IF EXISTS `blog`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `blog` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(500) NOT NULL, `text` text NOT NULL, `image` text NOT NULL, `datetime` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `blog` -- LOCK TABLES `blog` WRITE; /*!40000 ALTER TABLE `blog` DISABLE KEYS */; INSERT INTO `blog` VALUES (1,'Crafting Quality in Every Stitch – Gangster’s Journey','<p><em>Get an insider’s look into the meticulous craftsmanship that goes into creating our products. Join us as we share the story behind the quality and attention to detail that defines [Company Name].</em></p>\r\n','Unsplash_Matt_Wojtas.png','2024-07-16 12:51:15'),(2,'Wardrobe Essentials','<h1>Wardrobe Essentials: Unveiling [Company Name]’s Must-Have Bags, Hoodies, Masks, Jackets, and Keyboards for Every Occasion</h1>\r\n\r\n<p><em>Explore our fashion-forward lineup designed to cater to your everyday needs. This article breaks down the essentials that will elevate your wardrobe effortlessly.</em></p>\r\n','package-281425_1280-500x300-1.png','2024-07-16 13:16:34'); /*!40000 ALTER TABLE `blog` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cart` -- DROP TABLE IF EXISTS `cart`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cart` ( `id` int(30) NOT NULL AUTO_INCREMENT, `client_ip` varchar(20) NOT NULL, `user_id` int(30) NOT NULL, `product_id` int(30) NOT NULL, `qty` int(30) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cart` -- LOCK TABLES `cart` WRITE; /*!40000 ALTER TABLE `cart` DISABLE KEYS */; INSERT INTO `cart` VALUES (13,'::1',2,6,14); /*!40000 ALTER TABLE `cart` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `category_list` -- DROP TABLE IF EXISTS `category_list`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `category_list` ( `id` int(30) NOT NULL AUTO_INCREMENT, `name` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `category_list` -- LOCK TABLES `category_list` WRITE; /*!40000 ALTER TABLE `category_list` DISABLE KEYS */; INSERT INTO `category_list` VALUES (1,'backpacks'); /*!40000 ALTER TABLE `category_list` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `comments` -- DROP TABLE IF EXISTS `comments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `comments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `blog_id` int(11) DEFAULT NULL, `commenter_name` varchar(100) DEFAULT NULL, `commenter_email` varchar(100) DEFAULT NULL, `comment_text` text DEFAULT NULL, `comment_date` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `comments` -- LOCK TABLES `comments` WRITE; /*!40000 ALTER TABLE `comments` DISABLE KEYS */; INSERT INTO `comments` VALUES (1,2,'Satya','Satya@gmail','heheh','2024-07-16 08:02:41'); /*!40000 ALTER TABLE `comments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `order_items` -- DROP TABLE IF EXISTS `order_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `order_items` ( `id` int(11) NOT NULL AUTO_INCREMENT, `order_id` varchar(500) NOT NULL, `product_name` varchar(500) NOT NULL, `product_price` varchar(500) NOT NULL, `datetime` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `order_items` -- LOCK TABLES `order_items` WRITE; /*!40000 ALTER TABLE `order_items` DISABLE KEYS */; INSERT INTO `order_items` VALUES (1,'1','Femx gold','1570','2024-07-10 15:44:48'),(2,'2','Femx gold','1570','2024-07-10 15:49:40'),(3,'3','Femx gold','1570','2024-07-10 16:20:46'),(4,'3','Ashcrush & Retrim','1870','2024-07-10 16:20:46'),(5,'4','Ashcrush & Retrim','1870','2024-07-10 16:32:50'),(6,'5','Femx gold','1570','2024-07-10 17:01:47'),(7,'6','Femx gold','1570','2024-07-10 17:06:57'),(8,'6','Pyolex & Amolex','1570','2024-07-10 17:06:57'),(9,'7','Femx gold','1570','2024-07-10 17:25:37'),(10,'8','Femx gold','1570','2024-07-10 17:28:04'),(11,'9','Femx gold','1570','2024-07-10 17:58:22'),(12,'10','Femx gold','1570','2024-07-11 12:00:20'),(13,'11','Femx gold','1570','2024-07-11 12:08:26'),(14,'12','Femx gold','1570','2024-07-11 12:11:47'),(15,'13','Femx gold','1570','2024-07-11 12:15:01'),(16,'14','Femx gold','1570','2024-07-11 12:32:16'),(17,'15','Femx gold','1570','2024-07-11 12:33:33'),(18,'16','Femx gold','1570','2024-07-11 12:35:47'),(19,'17','Femx gold','1570','2024-07-11 12:41:46'),(20,'18','Femx gold','1570','2024-07-11 12:46:28'),(21,'19','Amolex','570','2024-07-11 12:47:31'),(22,'20','Femx gold','1570','2024-07-11 12:52:10'),(23,'21','Ashcrush & Retrim','1870','2024-07-11 15:14:52'),(24,'22','Ashcrush & Retrim','1870','2024-07-11 15:21:49'),(25,'23','Ashcrush','1270','2024-07-11 15:27:47'),(26,'24','Ashcrush & Retrim','1870','2024-07-11 15:37:12'),(27,'25','Ashcrush & Retrim','1870','2024-07-11 15:41:55'),(28,'26','Ashcrush','1270','2024-07-11 15:44:32'),(29,'27','Ashcrush & Retrim','1870','2024-07-11 15:47:46'),(30,'28','Femx gold','1570','2024-07-11 15:59:13'),(31,'29','Ashcrush & Retrim','1870','2024-07-11 16:00:28'),(32,'30','Femx gold','1570','2024-07-12 12:00:12'),(33,'31','Femx gold','1570','2024-07-12 12:17:38'),(34,'32','Ashcrush','1270','2024-07-12 12:21:57'),(35,'33','Ashcrush & Retrim','1870','2024-07-12 12:23:40'),(36,'34','Ashcrush & Retrim','1870','2024-07-12 12:31:17'),(37,'35','Ashcrush & Retrim','1870','2024-07-12 12:41:59'),(38,'36','Ashcrush','1270','2024-07-12 12:44:24'),(39,'37','Ashcrush & Retrim','1870','2024-07-12 13:07:00'),(40,'38','Ashcrush','1270','2024-07-12 15:30:48'),(41,'39','Ashcrush & Retrim','1870','2024-07-12 18:05:53'),(42,'40','Ashcrush & Retrim','1870','2024-07-12 18:08:22'),(43,'41','Ashcrush & Retrim','1870','2024-07-12 18:09:33'),(44,'42','Ashcrush & Retrim','1870','2024-07-13 07:08:56'),(45,'43','Ashcrush & Retrim','1870','2024-07-13 07:10:19'),(46,'44','Ashcrush & Retrim','1870','2024-07-13 09:12:52'),(47,'45','Ashcrush','1270','2024-07-13 09:31:43'),(48,'46','Ashcrush & Retrim','1870','2024-07-13 09:39:57'),(49,'47','Ashcrush & Retrim','1870','2024-07-13 09:42:09'),(50,'48','Ashcrush','1270','2024-07-13 09:43:22'),(51,'49','Ashcrush','1270','2024-07-13 09:45:07'),(52,'50','Ashcrush','1270','2024-07-13 12:40:53'),(53,'51','Ashcrush & Retrim','1870','2024-07-13 12:44:16'),(54,'52','Ashcrush & Retrim','1870','2024-07-13 12:46:22'),(55,'53','Ashcrush','1270','2024-07-13 14:27:34'); /*!40000 ALTER TABLE `order_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `order_list` -- DROP TABLE IF EXISTS `order_list`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `order_list` ( `id` int(30) NOT NULL AUTO_INCREMENT, `order_id` int(30) NOT NULL, `product_id` int(30) NOT NULL, `qty` int(30) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `order_list` -- LOCK TABLES `order_list` WRITE; /*!40000 ALTER TABLE `order_list` DISABLE KEYS */; INSERT INTO `order_list` VALUES (1,1,10,1); /*!40000 ALTER TABLE `order_list` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orders` -- DROP TABLE IF EXISTS `orders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orders` ( `id` int(30) NOT NULL AUTO_INCREMENT, `name` text NOT NULL, `address` text NOT NULL, `state` text NOT NULL, `city` varchar(500) NOT NULL, `pincode` varchar(500) NOT NULL, `mobile` text NOT NULL, `email` text NOT NULL, `product_name` text NOT NULL, `product_price` varchar(100) NOT NULL, `payment_method` varchar(500) NOT NULL, `order_date` datetime NOT NULL DEFAULT current_timestamp(), `status` tinyint(1) NOT NULL DEFAULT 0, `payment_status` varchar(20) DEFAULT 'pending', `cancelled` tinyint(1) DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orders` -- LOCK TABLES `orders` WRITE; /*!40000 ALTER TABLE `orders` DISABLE KEYS */; INSERT INTO `orders` VALUES (1,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1570','pay_on_delivery','2024-07-10 15:44:48',1,'done',0),(2,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1570','pay_on_delivery','2024-07-10 15:49:40',1,'done',0),(3,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','3440','pay_on_delivery','2024-07-10 16:20:46',1,'pending',0),(4,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1870','pay_on_delivery','2024-07-10 16:32:50',1,'pending',0),(5,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1570','pay_on_delivery','2024-07-10 17:01:47',0,'done',0),(6,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','3140','pay_on_delivery','2024-07-10 17:06:57',1,'pending',0),(7,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1570','pay_on_delivery','2024-07-10 17:25:37',1,'pending',0),(8,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1570','pay_on_delivery','2024-07-10 17:28:04',0,'done',0),(9,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1570','pay_on_delivery','2024-07-10 17:58:22',1,'pending',0),(10,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650102','satyendrasharmasatya4@gmail.com','','1570','pay_on_delivery','2024-07-11 12:00:20',1,'pending',0),(11,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1570','pay_on_delivery','2024-07-11 12:08:26',1,'pending',0),(12,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1570','pay_on_delivery','2024-07-11 12:11:47',1,'pending',0),(13,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1570','pay_on_delivery','2024-07-11 12:15:01',1,'pending',0),(14,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1570','pay_on_delivery','2024-07-11 12:32:16',1,'pending',0),(15,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1570','pay_on_delivery','2024-07-11 12:33:33',1,'pending',0),(16,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1570','pay_on_delivery','2024-07-11 12:35:47',1,'pending',0),(17,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650102','satyendrasharmasatya4@gmail.com','','1570','pay_on_delivery','2024-07-11 12:41:46',1,'pending',0),(18,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1570','pay_on_delivery','2024-07-11 12:46:28',1,'pending',0),(19,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','570','pay_on_delivery','2024-07-11 12:47:31',1,'pending',0),(20,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1570','pay_on_delivery','2024-07-11 12:52:10',1,'pending',0),(21,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1870','pay_on_delivery','2024-07-11 15:14:52',1,'pending',0),(22,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1870','pay_on_delivery','2024-07-11 15:21:49',1,'pending',0),(23,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1270','pay_on_delivery','2024-07-11 15:27:47',1,'pending',0),(24,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1870','pay_on_delivery','2024-07-11 15:37:12',1,'pending',0),(25,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1870','pay_on_delivery','2024-07-11 15:41:55',1,'pending',0),(26,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1270','pay_on_delivery','2024-07-11 15:44:32',1,'pending',0),(27,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','pelexo7061@furnato.com','','1870','pay_on_delivery','2024-07-11 15:47:46',1,'pending',0),(28,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','wetos97537@cartep.com','','1570','pay_on_delivery','2024-07-11 15:59:13',1,'pending',0),(29,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1870','pay_on_delivery','2024-07-11 16:00:28',1,'pending',0),(30,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1570','pay_online','2024-07-12 12:00:12',1,'pending',0),(31,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1570','pay_online','2024-07-12 12:17:38',1,'pending',0),(32,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650108','satyendrasharmasatya4@gmail.com','','1270','pay_online','2024-07-12 12:21:57',1,'pending',0),(33,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1870','pay_online','2024-07-12 12:23:40',1,'pending',0),(34,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1870','pay_on_delivery','2024-07-12 12:31:17',1,'pending',0),(35,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1870','pay_online','2024-07-12 12:41:59',1,'pending',0),(36,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1270','pay_online','2024-07-12 12:44:24',1,'pending',0),(37,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1870','pay_online','2024-07-12 13:07:00',1,'pending',0),(38,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1270','pay_online','2024-07-12 15:30:48',1,'pending',0),(39,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1870','pay_on_delivery','2024-07-12 18:05:53',1,'pending',0),(40,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1870','pay_on_delivery','2024-07-12 18:08:22',1,'pending',0),(41,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','pelexo7061@furnato.com','','1870','pay_on_delivery','2024-07-12 18:09:33',1,'pending',0),(42,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1870','pay_online','2024-07-13 07:08:56',1,'pending',0),(43,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1870','pay_online','2024-07-13 07:10:19',1,'pending',0),(44,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1870','pay_online','2024-07-13 09:12:52',1,'pending',0),(45,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1270','pay_online','2024-07-13 09:31:43',1,'pending',0),(46,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1870','pay_online','2024-07-13 09:39:57',1,'pending',0),(47,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1870','pay_online','2024-07-13 09:42:09',1,'pending',0),(48,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1270','pay_online','2024-07-13 09:43:22',1,'pending',0),(49,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1270','pay_online','2024-07-13 09:45:07',1,'pending',0),(50,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1270','pay_online','2024-07-13 12:40:53',1,'pending',0),(51,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1870','pay_online','2024-07-13 12:44:16',1,'pending',0),(52,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1870','pay_online','2024-07-13 12:46:22',1,'pending',0),(53,'Satyendra Sharma','Sukrauli hata, Near shai hospital','UP','Hata , kushinagar','274207','9565650124','satyendrasharmasatya4@gmail.com','','1270','pay_online','2024-07-13 14:27:34',1,'pending',0); /*!40000 ALTER TABLE `orders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `product_list` -- DROP TABLE IF EXISTS `product_list`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `product_list` ( `id` int(30) NOT NULL AUTO_INCREMENT, `category_id` int(30) NOT NULL, `name` varchar(100) NOT NULL, `specification` text NOT NULL, `benefits` text NOT NULL, `description` text NOT NULL, `price` float NOT NULL DEFAULT 0, `img_path` text NOT NULL, `productimage2` text DEFAULT NULL, `productimage3` text DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0= unavailable, 2 Available', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `product_list` -- LOCK TABLES `product_list` WRITE; /*!40000 ALTER TABLE `product_list` DISABLE KEYS */; INSERT INTO `product_list` VALUES (1,2,'Arctic Fox Snap Dark Denim Travel Duffle Bag','','','<p>Packing for an expedition or a family trip to the country house? Regardless of the destination, you’ll probably need our new Snap duffle bag with you. A durable, easy-to-carry bag that is roomy enough to make the number of things it can carry seem infinite.</p>\r\n',1399,'DFblue2_2ed8677c-5599-4ed9-9851.png','DFblue2_2ed8677c-5599-4ed9-9851.png','DFblue2_2ed8677c-5599-4ed9-9851.png',1),(2,3,'Camera Stand','','','<p>Introducing a new range of Arctic Fox Camera bags, designed exclusively for professional photographers. Its ergonomic design provides plenty of space for camera equipment. These camera backpack are both light-weight and durable, allowing for high portability. A padded and customizable divider will ensure that your camera and accessories remain organized.</p>\r\n',3499,'1200x1200Polaroid_Red_Front_1b0c.png','1200x1200Polaroid_Red_Front_1b0c.png','1200x1200Polaroid_Red_Front_1b0c.png',1),(3,4,'Arctic Fox Tote Laptop bag Bag For Women (Deep Dive)','','','<p>Smart and Trendy! Make your way for our sleek and unique Tote bags for women, It’s perfectly blended with style and functionality. With your best interest at heart, we present the tote with laptop compatibility and an anti-slip handle for your shoulders. It is light-weight, spacious, strong and available in attractive colors perfect as a office or a college bag.</p>\r\n',1099,'Untitled-design-35.png','Untitled-design-35.png','Untitled-design-35.png',1),(4,5,'Moon Scooter Helmet','','','<p>Introducing the MOON helmets with a sophisticated classic matt black ABS outer shell. Its thick EPS liner and head circumference adjuster ensure perfect fit and protection while you cruise down the city streets.</p>\r\n',899,'Untitled-design-36.png','Untitled-design-36.png','Untitled-design-36.png',1),(5,6,'Arctic Fox AIW V2 Washable Grey Mask','','','<p>Arctic Fox AIW v2.0 washable mask provides the safest protection against non-toxic dust, bacteria, and various other common airborne irritants. Composed of a soft and non-irritating inside lining, odorless and fire-proof outer material. These masks feature a series of uses that fall under general purpose applications. The addition of an inner sponge ensures a secure and comfortable fit for prolonged use & are great for meeting everyday needs.</p>\r\n',88,'Untitled-design-37.png','Untitled-design-37.png','Untitled-design-37.png',1),(6,7,'New Arctic Fox Unisex Sea Spray Zipper Hoodies (sweatshirts)','','','<p>With the perfect blend of cotton and polyester, Arctic Fox presents to you the all-new zipper & non-zipper winter hoodies collection. A prefect unisex hoodie. Stretchable fabric for the ideal fit & comfort, along with a kangaroo pocket to carry all you need on the go! Can be used as sweatshirts for men, sweatshirts for women, winter jackets for men and winter jackets for women. Fine detailed graphics with ribbed hems, layered hood, and coated drawstring to make you look cool while keeping warm.</p>\r\n',999,'Untitled-design-38.png','Untitled-design-38.png','Untitled-design-38.png',1),(7,8,'Arctic Fox Jet Waterproof Bluetooth Travel Speaker','','','<p>Introducing the Arctic Fox JET Speaker, your ideal portable bluetooth audio companion designed to enhance your outdoor experiences. Meticulously crafted in our Arctic Fox innovation lab, this speaker boasts a user-friendly clip-on feature, compact design, robust performance and is proudly made in India!</p>\r\n',999,'Untitled-design-39.png','Untitled-design-39.png','Untitled-design-39.png',1); /*!40000 ALTER TABLE `product_list` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `product_reviews` -- DROP TABLE IF EXISTS `product_reviews`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `product_reviews` ( `id` int(11) NOT NULL AUTO_INCREMENT, `product_id` int(11) NOT NULL, `author` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `rating` int(11) NOT NULL, `review` text NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `product_id` (`product_id`), CONSTRAINT `product_reviews_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `product_list` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `product_reviews` -- LOCK TABLES `product_reviews` WRITE; /*!40000 ALTER TABLE `product_reviews` DISABLE KEYS */; INSERT INTO `product_reviews` VALUES (1,6,'Satyendra Sharma','satyendrasharmasatya4@gmail.com',5,'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.','2024-07-17 10:58:40'); /*!40000 ALTER TABLE `product_reviews` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `system_settings` -- DROP TABLE IF EXISTS `system_settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `system_settings` ( `id` int(30) NOT NULL AUTO_INCREMENT, `name` text NOT NULL, `email` varchar(200) NOT NULL, `contact` varchar(20) NOT NULL, `cover_img` text NOT NULL, `about_content` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `system_settings` -- LOCK TABLES `system_settings` WRITE; /*!40000 ALTER TABLE `system_settings` DISABLE KEYS */; INSERT INTO `system_settings` VALUES (1,'Natural Ayurveda Tips','support@naturalayurvedatips.com','9718832501','banner-1.png','<h1 style="margin-bottom: 0px; padding: 0px; line-height: 90px; color: rgb(0, 0, 0); text-align: center; font-size: 70px; font-family: DauphinPlain;">About Us</h1><h4 style="margin: 10px 10px 5px; padding: 0px; font-size: 14px; line-height: 18px; text-align: center; font-style: italic; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif;">"Discover the Healing Power of Ayurveda for Mind, Body, and Spirit"</h4><h5 style="margin: 5px 10px 20px; padding: 0px; font-size: 12px; line-height: 14px; text-align: center; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif;">"There is no one who loves pain itself, who seeks after it and wants to have it, simply because it is pain..."</h5><hr style="margin: 0px; padding: 0px; clear: both; border-top: 0px; height: 1px; background-image: linear-gradient(to right, rgba(0, 0, 0, 0), rgba(0, 0, 0, 0.75), rgba(0, 0, 0, 0)); color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; text-align: center;"><p id="Content" style="margin-bottom: 0px; padding: 0px; position: relative; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; text-align: center;"></p><p class="boxed" style="margin: 10px 28.7969px; padding: 0px; clear: both;"></p><p id="lipsum" style="margin-bottom: 0px; padding: 0px; text-align: justify;"></p><p style="margin-bottom: 15px; padding: 0px;">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent suscipit porttitor dui, a accumsan metus molestie vel. Quisque luctus eros interdum, facilisis lectus at, aliquam lacus. Etiam blandit lectus imperdiet nisi finibus posuere. Quisque in dolor id quam rhoncus sollicitudin sed id nisi. Interdum et malesuada fames ac ante ipsum primis in faucibus. Proin sed odio luctus, tempus dui quis, aliquet arcu. Nunc a sagittis dui, ut lacinia risus. Pellentesque nec leo ut quam varius semper quis ut ligula. Proin feugiat, nisl sed facilisis dignissim, augue mauris cursus elit, at mattis lectus urna in est. Quisque venenatis quam vitae mauris tincidunt, et facilisis purus tincidunt. Sed arcu lacus, maximus quis lorem eget, auctor maximus felis. Cras tristique, ligula eu iaculis feugiat, purus sapien tristique velit, non consequat quam ante sed velit.</p><p></p><p></p><p></p><p></p>'); /*!40000 ALTER TABLE `system_settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_info` -- DROP TABLE IF EXISTS `user_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `user_info` ( `user_id` int(10) NOT NULL AUTO_INCREMENT, `first_name` varchar(100) NOT NULL, `last_name` varchar(100) NOT NULL, `email` varchar(300) NOT NULL, `password` varchar(300) NOT NULL, `mobile` varchar(10) NOT NULL, `address` varchar(300) NOT NULL, PRIMARY KEY (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_info` -- LOCK TABLES `user_info` WRITE; /*!40000 ALTER TABLE `user_info` DISABLE KEYS */; INSERT INTO `user_info` VALUES (1,'Satyendra','Sharma','satya@gmail.com','$2y$10$3hwFhVQt834TRxCRJ8LaXuznj0YVmFqC8803hY2spk9lDIj3NUYhq','0956565012','Sukrauli hata, Near shai hospital\r\nNear shai hospital'),(2,'Satya','Sharma','satya4@gmail.com','$2y$10$1mwrRiDRZ8MwArZZKzkGneaJMl6nIUi59etDfOQ/uQOGtymsWzP7G','9565650124','sddiufsd fl bsd fgoasejo'); /*!40000 ALTER TABLE `user_info` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `id` int(30) NOT NULL AUTO_INCREMENT, `name` varchar(200) NOT NULL, `username` text NOT NULL, `password` varchar(200) NOT NULL, `type` tinyint(1) NOT NULL DEFAULT 2 COMMENT '1=admin , 2 = staff', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,'Admin','admin','$2y$10$hkAvvDimrCXLnCOYJ.aege5xyiFcjoXf4jMIWFewKue84T0bBPH6O',1); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping events for database 'the_gangster' -- -- -- Dumping routines for database 'the_gangster' -- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2026-09-01 11:50:00