Jump to content

purge08

Members
  • Content Count

    40
  • Joined

  • Last visited

Everything posted by purge08

  1. -- phpMyAdmin SQL Dump -- version 4.2.10 -- http://www.phpmyadmin.net -- -- Host: localhost:3306 -- Generation Time: May 16, 2015 at 01:55 PM -- Server version: 5.5.38 -- PHP Version: 5.6.2 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `smartshop` -- -- -------------------------------------------------------- -- -- Table structure for table `ads` -- CREATE TABLE `ads` ( `id` int(11) NOT NULL, `ad250` text NOT NULL, `ad720` text NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `ads` -- INSERT INTO `ads` (`id`, `ad250`, `ad720`) VALUES (1, '<a href="http://www.kqzyfj.com/click-7058689-10888673" target="_blank">\r\n<img src="http://www.ftjcfx.com/image-7058689-10888673" width="250" height="250" alt="Web Hosting at InMotion Hosting" border="0"/></a>', '<a href="http://www.kqzyfj.com/click-7058689-10833186" target="_blank">\r\n<img src="http://www.lduhtrp.net/image-7058689-10833186" width="728" height="90" alt="$1/ mo Hosting + Free domain! Stick it to the slow websites!" border="0"/></a>'); -- -------------------------------------------------------- -- -- Table structure for table `cats` -- CREATE TABLE `cats` ( `id` int(11) NOT NULL, `cid` int(11) NOT NULL, `cat` varchar(150) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; -- -- Dumping data for table `cats` -- INSERT INTO `cats` (`id`, `cid`, `cat`) VALUES (1, 0, 'Computers & Laptops'), (2, 0, 'Tablets'), (4, 0, 'Mobiles'), (5, 0, 'Cameras'), (6, 0, 'eBook Readers'), (7, 0, 'TV & Audio'); -- -------------------------------------------------------- -- -- Table structure for table `languages` -- CREATE TABLE `languages` ( `id` int(11) NOT NULL, `lang` varchar(150) NOT NULL, `langchar` varchar(9) NOT NULL, `dircetionx` varchar(3) NOT NULL, `lang1` varchar(150) NOT NULL, `lang2` varchar(150) NOT NULL, `lang3` varchar(150) NOT NULL, `lang4` varchar(150) NOT NULL, `lang5` varchar(150) NOT NULL, `lang6` varchar(150) NOT NULL, `lang7` varchar(150) NOT NULL, `lang8` varchar(150) NOT NULL, `lang9` varchar(150) NOT NULL, `lang10` varchar(150) NOT NULL, `lang11` varchar(150) NOT NULL, `lang12` varchar(150) NOT NULL, `lang13` varchar(150) NOT NULL, `lang14` varchar(150) NOT NULL, `lang15` varchar(150) NOT NULL, `lang16` varchar(150) NOT NULL, `lang17` varchar(150) NOT NULL, `lang18` varchar(150) NOT NULL, `lang19` varchar(150) NOT NULL, `lang20` varchar(150) NOT NULL, `lang21` varchar(150) NOT NULL, `lang22` varchar(150) NOT NULL, `lang23` varchar(150) NOT NULL, `lang24` varchar(150) NOT NULL, `lang25` varchar(150) NOT NULL, `lang26` varchar(150) NOT NULL, `lang27` varchar(150) NOT NULL, `lang28` varchar(150) NOT NULL, `lang29` varchar(150) NOT NULL, `lang30` varchar(150) NOT NULL, `lang31` varchar(150) NOT NULL, `lang32` varchar(150) NOT NULL, `lang33` varchar(150) NOT NULL, `lang34` varchar(150) NOT NULL, `lang35` varchar(150) NOT NULL, `lang36` varchar(150) NOT NULL, `lang37` varchar(150) NOT NULL, `lang38` varchar(150) NOT NULL, `lang39` varchar(150) NOT NULL, `lang40` varchar(150) NOT NULL, `lang41` varchar(150) NOT NULL, `lang42` varchar(150) NOT NULL, `lang43` varchar(150) NOT NULL, `lang44` varchar(25) NOT NULL, `lang45` varchar(25) NOT NULL, `lang46` varchar(75) NOT NULL, `lang47` varchar(75) NOT NULL, `lang48` varchar(75) NOT NULL, `lang49` varchar(75) NOT NULL, `lang50` varchar(75) NOT NULL, `lang51` varchar(75) NOT NULL, `lang52` varchar(75) NOT NULL, `lang53` varchar(25) NOT NULL, `lang54` varchar(75) NOT NULL, `lang55` varchar(75) NOT NULL, `lang56` varchar(75) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8; -- -- Dumping data for table `languages` -- INSERT INTO `languages` (`id`, `lang`, `langchar`, `dircetionx`, `lang1`, `lang2`, `lang3`, `lang4`, `lang5`, `lang6`, `lang7`, `lang8`, `lang9`, `lang10`, `lang11`, `lang12`, `lang13`, `lang14`, `lang15`, `lang16`, `lang17`, `lang18`, `lang19`, `lang20`, `lang21`, `lang22`, `lang23`, `lang24`, `lang25`, `lang26`, `lang27`, `lang28`, `lang29`, `lang30`, `lang31`, `lang32`, `lang33`, `lang34`, `lang35`, `lang36`, `lang37`, `lang38`, `lang39`, `lang40`, `lang41`, `lang42`, `lang43`, `lang44`, `lang45`, `lang46`, `lang47`, `lang48`, `lang49`, `lang50`, `lang51`, `lang52`, `lang53`, `lang54`, `lang55`, `lang56`) VALUES (1, 'English', 'en', 'ltr', 'Home', 'Categories', 'Offers', 'Sale', 'Login', 'Contact Us', 'Sell Product', 'Register', 'Feedback', 'Search', 'Subscribe', 'Featured Products', 'Top Products', 'More Details', 'All Products', 'Sort By', 'Create Seller Account', 'If you already have an account with us', 'please login', 'Personal Details', 'Full Name', 'Address', 'City', 'Zip', 'Country', 'Phone', 'Login Details', 'Email', 'Password', 'Password Confirm', 'Register', 'Subject', 'Message', 'Send', 'Search here', 'Subscribe to Newsletter', 'Select Order Option', 'Newest', 'Title (A-Z)', 'Title (Z-A)', 'Price (High to Low)', 'Price (Low to High)', 'Languages', 'Next', 'Prev', 'Description', 'Specifications', 'Comments', 'Contact Seller', 'Availability', 'items in stock', 'Related Products', 'Submit', 'Write Comment', 'Title', 'Rate'), (2, 'Español', 'es', 'ltr', 'página de inicio', 'Categorías', 'Ofertas', 'Venta', 'Entrar', 'Contáctenos', 'Venta de productos', 'Registrarse', 'Realimentación', 'Búsqueda', 'Suscribir', 'Productos Destacados', 'Productos principales', 'Más Detalles', 'Todos los productos', 'Ordenar Por', 'Crear Cuenta Vendedor', 'Si ya tiene una cuenta con nosotros', 'por favor Iniciar sesión', 'Detalles Personales', 'Nombre Completo', 'Dirección', 'Ciudad', 'Zip', 'País', 'Teléfono', 'Entrar Detalles', 'Email', 'Contraseña', 'Contraseña Confirmada', 'Registrarse', 'Sujeto', 'Mensaje', 'Enviar', 'Busca aquí', 'Suscríbete al boletín de noticias', 'Seleccione la opción Orden', 'el más nuevo', 'Título (A-Z)', 'Título (Z-A)', 'Precio (de mayor a menor)', 'Precio (de menor a mayor)', 'Idiomas', 'Siguiente', 'Anterior', 'Descripción', 'Especificaciones', 'Comentarios', 'Contactar al Vendedor', 'Disponibilidad', 'artículos en stock', 'Productos Relacionados', 'Presentar', 'Agrega tu comentario', 'Título', 'Tarifa'), (3, 'العربية', 'ar', 'rtl', 'الصفحة الرئيسية', 'الأقسام', 'عروض', 'تخفضات', 'دخول', 'إتصل بنا', 'بيع منتجك', 'سجل', 'إتصل بنا', 'بحث', 'إشترك', 'المنتجات المميزة', 'أفضل المنتجات', 'المزيد من التفاصيل', 'كل المنتجات', 'الترتيب', 'إنشئ حساب بائع', 'لو كنت تمتلك حساب', 'إضغط هنا', 'المعلومات الشخصية', 'الاسم بالكامل', 'العنوان', 'المدينة', 'صندوق البريد', 'الدولة', 'التليفون', 'معلومات الدخول', 'البريد الالكتروني', 'كلمة السر', 'تأكيد كلمة السر', 'سجل', 'الموضوع', 'الرسالة', 'إرسل', 'إبحث هنا', 'اشترك في رسائل البريد الاكتروني', 'إختار نظام الترتيب', 'الأحدث', 'بالعنوان تصاعدي', 'بالعنوان تنازلي', 'بالسعر تنازلي', 'بالسعر تصاعدي', 'اللغات', 'التالي', 'السابق', 'الوصف', 'المواصفات', 'التعليقات', 'إتصل بالبائع', 'الكمية المتاحة', 'منتج في المخزن', 'منتجات مشابهه', 'موافق', 'اكتب تعليق', 'عنوان', 'تقييم'), (4, 'فارسی', 'fa', 'rtl', 'صفحه اصلی وب سایت', 'دسته', 'پیشنهادات', 'فروش', 'ورود به سیستم', 'تماس با ما', 'فروش محصولات', 'ثبت نام', 'باز خورد', 'جستجو', 'اشتراک', 'محصولات ویژه', 'محصولات بالا', 'جزئیات بیشتر', 'همه محصولات', 'مرتب سازی بر اساس', 'ایجاد حساب فروشنده', 'اگر شما در حال حاضر یک حساب کاربری با ما', 'لطفا وارد شوید', 'اطلاعات شخصی', 'نام و نام خانوادگی', 'نشانی', 'شهرستان', 'کد پستی', 'کشور', 'تلفن', 'جزئیات ورود', 'ایمیل', 'رمز عبور', 'تکرار رمز عبور', 'ثبت نام', 'موضوع', 'پیام', 'ارسال', 'جستجو در اینجا', 'مشترک شدن در خبرنامه', 'انتخاب ترتیب گزینه', 'پاسخ تازهترین پاسخ است', 'عنوان (A-Z)', 'عنوان (Z-A)', 'قیمت (بالا پایین تا)', 'قیمت (پایین به بالا)', 'زبان', 'بعد', 'قبلی', 'شرح', 'مشخصات', 'نظرات', 'تماس با فروشنده', 'دسترسی', 'قلم موجود در انبار', 'محصولات مرتبط', 'ثبت کردن', 'نوشتن نظر', 'عنوان', 'نرخ'), (5, 'Deutsch', 'de', 'ltr', 'Startseite', 'Kategorien', 'Angebote', 'Verkauf', 'Login', 'Kontaktieren Sie uns', 'Sell Produkt', 'Registrieren', 'Rückkopplung', 'Suche', 'Zeichnen', 'Ausgewählte Artikel', 'Top Produkte', 'Weitere Infos', 'Alle Produkte', 'Sortieren nach', 'Erstellen Verkäuferkonto', 'Wenn Sie bereits ein Konto bei uns', 'bitte anmelden', 'Persönliche Details', 'Vor- und Nachname', 'Adresse', 'City', 'PLZ', 'Land', 'Telefon', 'Login-Daten', 'E-Mail', 'Passwort', 'Kennwort bestätigen', 'Registrieren', 'Gegenstand', 'Nachricht', 'Senden', 'Suchen Sie hier', 'Abonnieren Sie den Newsletter', 'Wählen Sie Order Option', 'Neueste', 'Titel (A-Z)', 'Titel (Z-A)', 'Preis (absteigend)', 'Preis (aufsteigend)', 'Sprachen', 'Nächste', 'Zurück', 'Beschreibung', 'Technische Daten', 'Comments', 'Verkäufer kontaktieren', 'Verfügbarkeit', 'artikel auf Lager', 'Ähnliche Produkte', 'Einreichen', 'Kommentar schreiben', 'Titel', 'Preis'), (6, 'Français', 'fr', 'ltr', 'Page d''accueil', 'Catégories', 'Offres', 'Vente', 'Login', 'Contactez Nous', 'Vendre produit', 'Inscription', 'Réaction', 'ٍRecherche', 'S''abonner', 'Produits Présentés', 'Top Produits', 'Plus De Détails', 'tous les produits', 'Trier Par', 'Créer un compte vendeur', 'Si vous avez déjà un compte avec nous', 's''il vous plaît vous identifier', 'Details Personnels', 'Nom et prénom', 'Adresse', 'Ville', 'Code postal', 'Pays', 'Téléphone', 'Connexion Détails', 'Email', 'Mot de passe', 'Mot De Passe Confirmé', 'Inscription', 'Sujet', 'Message', 'Envoyer', 'Rechercher ici', 'S''inscrire à la Newsletter', 'Sélectionnez l''option Ordre', 'Date', 'Titre (A à Z)', 'Titre (Z-A)', 'Prix (décroissant)', 'Prix (croissant)', 'Langues', 'Prochaine', 'Précédent', 'Description', 'Caractéristiques', 'Commentaires', 'Contacter le vendeur', 'Disponibilité', 'pièces en stock', 'Produits Connexes', 'Soumettre', 'Ecrire un commentaire', 'Titre', 'Taux'), (7, 'Türk', 'tr', 'ltr', 'Ana Sayfa', 'Kategoriler', 'Teklifler', 'Satış', 'Oturum Aç', 'Bize Ulaşın', 'Satış Ürün', 'Kayıt', 'Geribesleme', 'Arama', 'Abone', 'Özel Ürünler', 'En Ürünleri', 'Daha Fazla Ayrıntı', 'Tüm Ürünler', 'Göre Sırala', 'Satıcı Hesap Oluştur', 'Zaten bir hesabınız varsa,', 'lütfen giriş yapın', 'Kişisel Detaylar', 'Ad Soyad', 'Adres', 'şehir', 'Posta Kodu', 'ülke', 'Telefon', 'Giriş Detayları', 'E-posta', 'şifre', 'Şifre Onayla', 'Kayıt', 'konu', 'Mesaj', 'Göndermek', 'burada ara', 'Gazetemize abone', 'Sipariş Seçeneği Seçin', 'en yeni', 'Başlık (A-Z)', 'Başlık (A-Z)', 'Fiyat (Yüksekten Düşüğe)', 'Fiyat (Düşükten Yükseğe)', 'Diller', 'sonraki', 'Önceki', 'Tanım', 'Özellikler', 'Yorumlar', 'Satıcıyla', 'Kullanılabilirlik', 'Stoktaki ürünler', 'İlgili Ürünler', 'Sunmak', 'Yorum Yaz', 'Başlık', 'oran'), (8, 'русский', 'ru', 'ltr', 'Главная страница', 'категории', 'предложения', 'продажа', 'Войти', 'Связаться С Нами', 'Продам товаров', 'Регистрация', 'обратная связь', 'поиск', 'подписываться', 'Популярные продукты', 'Лучшие продукты', 'Подробнее', 'Все продукты', 'Сортировать По', 'Создать аккаунт продавца', 'Если у вас уже есть аккаунт с нами', 'пожалуйста, войдите', 'Личная Информация', 'Полное Имя', 'адрес', 'город', 'Почтовый Индекс', 'страна', 'телефон', 'Войти Подробнее', 'E-mail', 'пароль', 'Подтвердить Пароль', 'Регистрация', 'предмет', 'сообщение', 'послать', 'Поиск здесь', 'Подписаться на рассылку', 'Выберите вариант заказа', 'новейший', 'Название (А-Я)', 'Название (Я-А)', 'Цена (от высокой к низкой)', 'Цена (от низкого до высокого)', 'Языки', 'следующий', 'Предыдущая', 'описание', 'спецификации', 'Комментарии', 'Связаться С Продавцом', 'наличие', 'на складе', 'Сопутствующие Товары', 'представить', 'Написать комментарий', 'название', 'ставка'), (9, '中国', 'zh-Hans', 'ltr', '主页', '分类', '报价', '卖', '注册', '联系我们', '卖产品', '注册', '信息反馈', '搜索', '订阅', '特色产品', '热门产品', '更多详细信息', '所有产品', '排序方式', '创建卖家帐户', '如果您已经有我们的帐户', '请登录', '个人资料', '姓名', '地址', '城市', '邮政编码', '国家', '电话', '登录详细信息', '电子邮件', '密码', '密码确认', '注册', '主题', '信息', '发送', '在这里搜索', '订阅电子报', '选择订购选项', '最新', '标题(A-Z)', '标题(Z-A)', '价格(从高到低)', '价格(从低到高)', '语言', '下一个', '上一页', '描述', '技术指标', '评论', '联系卖家', '可用性', '在库存产品', '相关产品', '提交', '发表评论', '称号', '率'); -- -------------------------------------------------------- -- -- Table structure for table `productimages` -- CREATE TABLE `productimages` ( `id` int(11) NOT NULL, `pid` int(11) NOT NULL, `pimage` varchar(250) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8; -- -- Dumping data for table `productimages` -- INSERT INTO `productimages` (`id`, `pid`, `pimage`) VALUES (12, 8, 'dxz9vOGxQgr8PSuyJUCH6zUme.JPG'), (13, 9, 'DZAxNSKLGXYAApd4xtEPYb6h7.JPG'), (14, 9, 'oZTc1ifPMjUp2frCQC9wH8hMe.JPG'), (15, 9, 'LiadEhtbk7RzyJACXS60t6g79.JPG'), (16, 9, 'B9Psf4IjTbC9xrLMBzsl0Ve6L.JPG'), (17, 10, 'oCReGh0ZseDJHO4PGDoqe1o68.JPG'), (18, 10, 'L5eo3kMzo8J9kb63v72cHqMJs.JPG'), (19, 11, '4juxiDinSGrct0BCKKXVR0rY3.JPG'), (20, 11, 'T7gf6VeMayqZSsCoRX2NkeHjF.JPG'), (21, 11, 'ex1o4eZd4st8bM1moaUPWHqw9.JPG'), (22, 12, 'YhQPh7tMP6Oz7yV84VirXPKSp.JPG'), (23, 12, 'YYhcekk2gesnyUdXr3CLtkCtI.JPG'), (24, 12, '9Glr7ePj1HHQBnWsEsazYT1XF.JPG'), (25, 12, '0NIuVlUKANpHiO8LBAz1owCxB.JPG'), (26, 13, 'yVPy3nFpmsE1HRcs1yUXPBINo.JPG'), (27, 13, '5TDO4btnxwyKd5AWH25sgqN1d.JPG'), (28, 13, 'Dy1opkw9YDZyjVZ5YSlmatRNi.JPG'), (29, 14, 'ZmM8UdjMLrTGYOqiFbEvIx9Zv.JPG'), (30, 0, 'qrFWoAUaOvMC34sO3JpZZlvrD.JPG'), (31, 0, '038XeO5yDQCjJxpeHtCj15XJf.JPG'), (32, 0, 'FBiDqnQ94StrJDRJYd6WbHiCh.JPG'), (33, 15, 'jUzjd9XLalbvSkuwk2Pf2UdUf.JPG'), (34, 15, 'UX7ESkcNaLRyqgVSVWzM91OHW.JPG'), (35, 15, '412VyuUVh3PumCgNwXMkn4ZzJ.JPG'), (36, 16, 'ne1tsrUI4P4DgzS1aysx6rX62.JPG'), (37, 17, 'KZidj8BftZ3DQ2rb8Wd6UM7Qj.JPG'), (38, 18, 'q2c07VnmWQOoKwsAB6RaZSlyk.JPG'), (39, 18, '7OCNyKs935ArWJvOcWyQOhP1n.JPG'), (40, 18, 'rTAHK1oF6TVvf2azLSH4NFcqr.JPG'), (41, 18, 'ov8xSSiSavbj6rN6vrWxT7GPl.JPG'), (42, 19, 'SwuH8JDrBy6BYxA7tw7YlPKil.JPG'), (43, 20, 'FBqqJZ22vrCr6fFAtkcP27YGr.JPG'), (44, 20, 'YhvTtv6sKsL6qt3jr8YaEdCag.JPG'), (45, 20, '2dEoqPxsTKcMJHlnhlDFHhcDJ.JPG'), (46, 20, 'zTTu6mPGbeknfmy3JWPH6ebi8.JPG'), (47, 21, 'wsIWFDjbbZPPmBXsTRMOsRMVM.JPG'), (48, 21, 'cAGJRVRWD5TA5y8q3biuowJtp.JPG'), (49, 21, 'DoBw6XFUYHA9nkVwc8cSlNNTR.JPG'), (50, 21, 'bkz43IDWB82XXJ8b3vrq4u90j.JPG'), (51, 21, 'ktX6i5CKOzqrTCDSrse3qHXht.JPG'), (52, 22, 'BSt7EjtDWYcSgJ117Bly3327F.JPG'), (53, 22, 'tQ2DpahNLNUItOHboQyIM4VUh.JPG'), (54, 22, 'LKkxF7S95ZraBbYbCq4e4WFxb.JPG'); -- -------------------------------------------------------- -- -- Table structure for table `products` -- CREATE TABLE `products` ( `id` int(11) NOT NULL, `ptitle` varchar(150) NOT NULL, `nprice` decimal(11,2) NOT NULL, `oldprice` decimal(11,0) NOT NULL, `catid` int(11) NOT NULL, `cattxt` varchar(150) NOT NULL, `pdescription` text NOT NULL, `pimage` varchar(150) NOT NULL, `pseo` varchar(150) NOT NULL, `shortdesc` varchar(200) NOT NULL, `sellerid` int(11) NOT NULL, `pstatus` tinyint(4) NOT NULL, `topproduct` tinyint(11) NOT NULL, `availability` int(11) NOT NULL, `saleoffer` varchar(15) NOT NULL, `newused` varchar(15) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8; -- -- Dumping data for table `products` -- INSERT INTO `products` (`id`, `ptitle`, `nprice`, `oldprice`, `catid`, `cattxt`, `pdescription`, `pimage`, `pseo`, `shortdesc`, `sellerid`, `pstatus`, `topproduct`, `availability`, `saleoffer`, `newused`) VALUES (8, 'MACBOOK AIR MD760LL/B 13.3', 935.00, 1050, 1, 'Computers & Laptops', '<h2 style="margin: 10px 0px 15px; font-family: Ubuntu, sans-serif; font-weight: normal; line-height: 40px; color: #666666; text-rendering: optimizelegibility; font-size: 20px; text-shadow: #ffffff 1px 1px 1px; padding: 0px 0px 8px;">Lorem Ipsum</h2>\r\n<p><span style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;">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&nbsp;</span><br style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;" /><br style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;" /><span style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;">Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old.</span><br style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;" /><br style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;" /></p>\r\n<ul class="listoption3" style="padding: 0px; margin: 0px; list-style: none; color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;">\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''../images/list3.png'') 0px 9px no-repeat scroll;">Lorem ipsum dolor sit amet Consectetur adipiscing elit</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''../images/list3.png'') 0px 9px no-repeat scroll;">Integer molestie lorem at massa Facilisis in pretium nisl aliquet</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''../images/list3.png'') 0px 9px no-repeat scroll;">Nulla volutpat aliquam velit</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''../images/list3.png'') 0px 9px no-repeat scroll;">Faucibus porta lacus fringilla vel Aenean sit amet erat nunc Eget porttitor lorem</li>\r\n</ul>', 'dxz9vOGxQgr8PSuyJUCH6zUme.JPG', 'macbook-air-md760llb-133', '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', 1, 1, 1, 15, 'sale', 'New'), (9, 'MacBook Pro - Intel i5 2.5GHz - 4GB RAM - 500GB HDD', 899.00, 1199, 1, 'Computers & Laptops', '<p><span style="color: #333333; font-family: ''Helvetica neue'', Helvetica, Verdana, sans-serif; font-size: 13px; line-height: 13px;">New:&nbsp;</span><span id="vi-cond-addl-info" style="margin: 0px; padding: 0px; border: 0px; font-size: 13px; font-family: ''Helvetica neue'', Helvetica, Verdana, sans-serif; color: #333333; line-height: 13px;">A brand-new, unused, unopened, undamaged item in its original packaging (where packaging is&nbsp;</span><span id="hiddenContent" class="u-dspn" style="margin: 0px; padding: 0px; border: 0px; font-size: 13px; display: inline; font-family: ''Helvetica neue'', Helvetica, Verdana, sans-serif; color: #333333; line-height: 13px;">applicable). Packaging should be the same as what is found in a retail store, unless the item is handmade or was packaged by the manufacturer in non-retail packaging, such as an unprinted box or plastic bag.</span></p>', 'DZAxNSKLGXYAApd4xtEPYb6h7.JPG', 'macbook-pro-intel-i5-25ghz-4gb-ram-500gb-hdd', 'Apple 13.3 MacBook Pro - Intel i5 2.5GHz - 4GB RAM - 500GB HDD - OS X Yosemite , A brand-new, unused, unopened, undamaged item in its original packaging ', 1, 1, 1, 15, 'offer', 'New'), (10, 'MacBook Air 11.6 Laptop - MC969LL/A 128gb Ssd 4gb Ram', 380.00, 400, 1, 'Computers & Laptops', '<p><span style="color: #333333; font-family: ''Helvetica neue'', Helvetica, Verdana, sans-serif; font-size: small; line-height: 13px;">Discover superior performance and reliability with the MacBook Air notebook, powered by <span style="color: #ff0000;"><strong>1.6GHz</strong></span> dual-core Intel Core i5 processor. The <span style="color: #008000;"><strong>11.6</strong></span>-inch high-resolution LED-backlit display of this Apple laptop delivers crisp and clear images. This Apple notebook gives you loads of space to store your files, documents, videos, pictures, applications, etc. Equipped with Intel HD Graphics 3000 processor, this Apple laptop renders blazing-fast image transitions, during games, sports programs, movies, 3D images, and more. Baosting 802.11n Wi-Fi wireless networking, this Apple notebook enables web surfing, downloading, video streaming, with faster than ever speed. Built with thin, glossy and lightweight design, the MacBook Air gives better portability.</span></p>', 'oCReGh0ZseDJHO4PGDoqe1o68.JPG', 'macbook-air-116-laptop-mc969lla-128gb-ssd-4gb-ram', 'Used Apple MacBook Air 11.6 Laptop - MC969LL/A 128gb Ssd 4gb Ram high-resolution LED-backlit display of this Apple laptop delivers crisp and clear images.', 1, 1, 1, 1, 'none', 'Used'), (11, 'Canon EOS 20D 8.2MP Digital SLR Camera Body', 60.00, 120, 5, 'Cameras', '<p><span style="font-family: Arial; font-size: small;">LISTED IS A MUCH USED CANON 20 D DIGITAL EOS 8.2 MP CAMERA BODY , IN NEED OF REPAIR , SOLD AS IS NO RETURNS, COMES WITH BATTERY , NO MEMORY CARD OR CHARGER</span></p>', '4juxiDinSGrct0BCKKXVR0rY3.JPG', 'canon-eos-20d-82mp-digital-slr-camera-body', 'LISTED IS A MUCH USED CANON 20 D DIGITAL EOS 8.2 MP CAMERA BODY , IN NEED OF REPAIR , SOLD AS IS NO RETURNS, COMES WITH BATTERY , NO MEMORY CARD OR CHARGER', 1, 1, 1, 1, 'none', 'Used'), (12, 'Canon 5D with BG-E4 Grip', 425.00, 500, 5, 'Cameras', '<p><span style="color: #333333; font-family: ''Helvetica neue'', Helvetica, Verdana, sans-serif; font-size: 13px; line-height: 13px;">Used:&nbsp;</span><span id="vi-cond-addl-info" style="margin: 0px; padding: 0px; border: 0px; font-size: 13px; font-family: ''Helvetica neue'', Helvetica, Verdana, sans-serif; color: #333333; line-height: 13px;">An item that has been used previously. The item may have some signs of cosmetic wear, but is fully&nbsp;</span><span id="hiddenContent" class="u-dspn" style="margin: 0px; padding: 0px; border: 0px; font-size: 13px; display: inline; font-family: ''Helvetica neue'', Helvetica, Verdana, sans-serif; color: #333333; line-height: 13px;">operational and functions as intended. This item may be a floor model or store return that has been used. See the seller&rsquo;s listing for full details and description of any imperfections.</span></p>', 'YhQPh7tMP6Oz7yV84VirXPKSp.JPG', 'canon-5d-with-bg-e4-grip', 'The item may have some signs of cosmetic wear, but is fully operational and functions as intended.', 1, 1, 1, 21, 'none', 'New'), (13, '10.1 Google Android 4.4 Tablet Smartphone Dual Sim 4CORE 2GB RAM 2Cam 3G SP', 121.95, 130, 2, 'Tablets', '<p><span style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;">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&nbsp;</span><br style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;" /><br style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;" /><span style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;">Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old.</span><br style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;" /><br style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;" /></p>\r\n<ul class="listoption3" style="padding: 0px; margin: 0px; list-style: none; color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;">\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Lorem ipsum dolor sit amet Consectetur adipiscing elit</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Integer molestie lorem at massa Facilisis in pretium nisl aliquet</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Nulla volutpat aliquam velit</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Faucibus porta lacus fringilla vel Aenean sit amet erat nunc Eget porttitor lorem</li>\r\n</ul>', 'yVPy3nFpmsE1HRcs1yUXPBINo.JPG', '101-google-android-44-tablet-smartphone-dual-sim-4core-2gb-ram-2cam-3g-sp', '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', 1, 1, 0, 25, 'none', 'New'), (14, 'Asus Nexus 7 16GB 7" K008 tablet w/ Wi-Fi', 109.95, 135, 2, 'Tablets', '<p><span style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;">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&nbsp;</span><br style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;" /><br style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;" /><span style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;">Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old.</span><br style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;" /><br style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;" /></p>\r\n<ul class="listoption3" style="padding: 0px; margin: 0px; list-style: none; color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;">\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Lorem ipsum dolor sit amet Consectetur adipiscing elit</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Integer molestie lorem at massa Facilisis in pretium nisl aliquet</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Nulla volutpat aliquam velit</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Faucibus porta lacus fringilla vel Aenean sit amet erat nunc Eget porttitor lorem</li>\r\n</ul>', 'ZmM8UdjMLrTGYOqiFbEvIx9Zv.JPG', 'asus-nexus-7-16gb-7-k008-tablet-w-wi-fi', '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', 1, 1, 1, 5, 'sale', 'New'), (15, 'Apple iPad 4th Generation 16GB w 9.7 Retina Display Wi-Fi + 4G Unlocked GSM', 260.00, 280, 2, 'Tablets', '<p><span style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;">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&nbsp;</span><br style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;" /><br style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;" /><span style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;">Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old.</span><br style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;" /><br style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;" /></p>\r\n<ul class="listoption3" style="padding: 0px; margin: 0px; list-style: none; color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;">\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Lorem ipsum dolor sit amet Consectetur adipiscing elit</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Integer molestie lorem at massa Facilisis in pretium nisl aliquet</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Nulla volutpat aliquam velit</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Faucibus porta lacus fringilla vel Aenean sit amet erat nunc Eget porttitor lorem</li>\r\n</ul>', 'jUzjd9XLalbvSkuwk2Pf2UdUf.JPG', 'apple-ipad-4th-generation-16gb-w-97-retina-display-wi-fi-4g-unlocked-gsm', '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', 1, 1, 1, 7, 'offer', 'New'), (16, 'Apple iPhone 4S 16GB for Sprint iOS Smartphone in Black', 79.00, 100, 4, 'Mobiles', '<p><span style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;">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&nbsp;</span><br style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;" /><br style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;" /><span style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;">Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old.</span><br style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;" /><br style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;" /></p>\r\n<ul class="listoption3" style="padding: 0px; margin: 0px; list-style: none; color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;">\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Lorem ipsum dolor sit amet Consectetur adipiscing elit</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Integer molestie lorem at massa Facilisis in pretium nisl aliquet</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Nulla volutpat aliquam velit</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Faucibus porta lacus fringilla vel Aenean sit amet erat nunc Eget porttitor lorem</li>\r\n</ul>', 'ne1tsrUI4P4DgzS1aysx6rX62.JPG', 'apple-iphone-4s-16gb-for-sprint-ios-smartphone-in-black', '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', 1, 1, 0, 1, 'none', 'Used'), (17, 'Apple iPhone 4S 16GB ', 124.95, 150, 4, 'Mobiles', '<p><span style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;">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&nbsp;</span><br style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;" /><br style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;" /><span style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;">Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old.</span><br style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;" /><br style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;" /></p>\r\n<ul class="listoption3" style="padding: 0px; margin: 0px; list-style: none; color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;">\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Lorem ipsum dolor sit amet Consectetur adipiscing elit</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Integer molestie lorem at massa Facilisis in pretium nisl aliquet</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Nulla volutpat aliquam velit</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Faucibus porta lacus fringilla vel Aenean sit amet erat nunc Eget porttitor lorem</li>\r\n</ul>', 'KZidj8BftZ3DQ2rb8Wd6UM7Qj.JPG', 'apple-iphone-4s-16gb-factory-unlocked-black-smartphone', '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', 1, 1, 0, 19, 'none', 'New'), (18, 'Samsung Galaxy SII S2 GT-I9100-16GB-White(Unlocked)', 145.95, 169, 4, 'Mobiles', '<p><span style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;">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&nbsp;</span><br style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;" /><br style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;" /><span style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;">Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old.</span><br style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;" /><br style="color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;" /></p>\r\n<ul class="listoption3" style="padding: 0px; margin: 0px; list-style: none; color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;">\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Lorem ipsum dolor sit amet Consectetur adipiscing elit</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Integer molestie lorem at massa Facilisis in pretium nisl aliquet</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Nulla volutpat aliquam velit</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Faucibus porta lacus fringilla vel Aenean sit amet erat nunc Eget porttitor lorem</li>\r\n</ul>', 'q2c07VnmWQOoKwsAB6RaZSlyk.JPG', 'samsung-galaxy-sii-s2-gt-i9100-16gb-whiteunlocked', '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', 1, 1, 1, 13, 'offer', 'New'), (20, 'MICROSOFT Surface Pro 3 12 128GB SSD Intel Core i5', 799.99, 900, 2, 'Tablets', '<p style="margin: 0px 0px 10px; color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;">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&nbsp;<br /><br />Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old.<br /><br /></p>\r\n<ul class="listoption3" style="padding: 0px; margin: 0px; list-style: none; color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;">\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Lorem ipsum dolor sit amet Consectetur adipiscing elit</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Integer molestie lorem at massa Facilisis in pretium nisl aliquet</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Nulla volutpat aliquam velit</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Faucibus porta lacus fringilla vel Aenean sit amet erat nunc Eget porttitor lorem</li>\r\n</ul>', 'FBqqJZ22vrCr6fFAtkcP27YGr.JPG', 'microsoft-surface-pro-3-12-128gb-ssd-intel-core-i5', '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', 2, 1, 1, 45, 'none', 'New'), (21, 'Asus 15.6 HD Gaming Notebook i7 4720HQ 12GB DDR3 750GB HDD', 815.00, 999, 1, 'Computers & Laptops', '<p style="margin: 0px 0px 10px; color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;">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&nbsp;<br /><br />Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old.<br /><br /></p>\r\n<ul class="listoption3" style="padding: 0px; margin: 0px; list-style: none; color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;">\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Lorem ipsum dolor sit amet Consectetur adipiscing elit</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Integer molestie lorem at massa Facilisis in pretium nisl aliquet</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Nulla volutpat aliquam velit</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Faucibus porta lacus fringilla vel Aenean sit amet erat nunc Eget porttitor lorem</li>\r\n</ul>', 'wsIWFDjbbZPPmBXsTRMOsRMVM.JPG', 'asus-156-hd-gaming-notebook-i7-4720hq-12gb-ddr3-750gb-hdd', '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', 2, 1, 1, 6, 'offer', 'New'), (22, 'Lenovo ThinkPad Helix Core i5-3337U, 4GB, 128GB SSD', 530.00, 600, 1, 'Computers & Laptops', '<p style="margin: 0px 0px 10px; color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;">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&nbsp;<br /><br />Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old.<br /><br /></p>\r\n<ul class="listoption3" style="padding: 0px; margin: 0px; list-style: none; color: #999999; font-family: ''Open Sans'', calibri, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 21px;">\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Lorem ipsum dolor sit amet Consectetur adipiscing elit</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Integer molestie lorem at massa Facilisis in pretium nisl aliquet</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Nulla volutpat aliquam velit</li>\r\n<li style="line-height: 20px; list-style: none; display: block; padding: 5px 0px 5px 15px; background: url(''file:///Projects/Web%20Apps/Themes/StyleShop%20-%20eCommerce%20Theme/images/list3.png'') 0px 9px no-repeat scroll;">Faucibus porta lacus fringilla vel Aenean sit amet erat nunc Eget porttitor lorem</li>\r\n</ul>', 'BSt7EjtDWYcSgJ117Bly3327F.JPG', 'lenovo-thinkpad-helix-core-i5-3337u-4gb-128gb-ssd', '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', 2, 1, 0, 1, 'none', 'Used'); -- -------------------------------------------------------- -- -- Table structure for table `reviews` -- CREATE TABLE `reviews` ( `id` int(11) NOT NULL, `pid` int(11) NOT NULL, `rtitle` varchar(150) NOT NULL, `rrate` tinyint(4) NOT NULL, `rdesc` varchar(500) NOT NULL, `rdate` date NOT NULL, `rstatus` int(11) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; -- -- Dumping data for table `reviews` -- INSERT INTO `reviews` (`id`, `pid`, `rtitle`, `rrate`, `rdesc`, `rdate`, `rstatus`) VALUES (1, 8, 'goog product', 3, 'this is test review', '2015-03-12', 0), (2, 8, 'nice product', 5, 'orem Ipsum is simply dummy text of the printing and typesetting industry.', '2015-03-12', 0), (3, 9, 'good product', 5, 'nice product', '2015-04-09', 0); -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `id` int(11) NOT NULL, `address` varchar(150) NOT NULL, `city` varchar(75) NOT NULL, `state` varchar(25) NOT NULL, `zip` varchar(25) NOT NULL, `country` varchar(75) NOT NULL, `email` varchar(75) NOT NULL, `phone` varchar(25) NOT NULL, `sitetitle` varchar(150) NOT NULL, `facebook` varchar(150) NOT NULL, `twitter` varchar(150) NOT NULL, `linkedin` varchar(150) NOT NULL, `rss` varchar(150) NOT NULL, `google` varchar(150) NOT NULL, `skype` varchar(150) NOT NULL, `flickr` varchar(150) NOT NULL, `aboutus` text NOT NULL, `wdescription` varchar(250) NOT NULL, `wkeywords` varchar(250) NOT NULL, `ccurrency` varchar(25) NOT NULL, `csymbol` varchar(5) NOT NULL, `langid` int(11) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `settings` -- INSERT INTO `settings` (`id`, `address`, `city`, `state`, `zip`, `country`, `email`, `phone`, `sitetitle`, `facebook`, `twitter`, `linkedin`, `rss`, `google`, `skype`, `flickr`, `aboutus`, `wdescription`, `wkeywords`, `ccurrency`, `csymbol`, `langid`) VALUES (1, '3558 WESTLINE DR ', 'MEMPHIS', 'TN', '38128', 'USA', 'support@website.com', '+123456789', 'MC Smart Shop | Buy and sell everything', 'https://www.facebook.com/', 'http://twitter.com/', 'https://www.linkedin.com/', 'https://www.website.com/rss', 'https://plus.google.com/', 'http://www.skype.com/en/', 'https://www.flickr.com/', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Mauris congue vehicula enim id condimentum.\r\n Integer at leo lobortis libero fermentum cursus. Mauris nulla nibh, condimentum ac cursus ac, ullamcorper eu orci.\r\n\r\n Quisque at vehicula ante. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Sed turpis felis, egestas vitae tincidunt nec, ullamcorper non nisi. Vivamus venenatis consectetur libero quis consequat. Vivamus ut lorem diam. Cras interdum sem sed risus dictum fringilla. Sed sagittis turpis ut nisi faucibus pellentesque. Nunc sit amet semper eratx\r\n', 'Sell and buy products ', 'sell, buy, prducts', 'USD', '$', 1); -- -------------------------------------------------------- -- -- Table structure for table `sliderimages` -- CREATE TABLE `sliderimages` ( `id` int(11) NOT NULL, `simage` varchar(250) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8; -- -- Dumping data for table `sliderimages` -- INSERT INTO `sliderimages` (`id`, `simage`) VALUES (7, 'erdkNcKPCdhmCrgyl9sslgu0A.jpg'), (8, 'GhCAX3EhvRrgSw83tLk5AcPTo.jpg'), (9, '5Sqk6IAOQ56RBbOPELJntp6oQ.jpg'); -- -------------------------------------------------------- -- -- Table structure for table `specifications` -- CREATE TABLE `specifications` ( `id` int(11) NOT NULL, `pid` int(11) NOT NULL, `speci` varchar(150) NOT NULL, `pvalue` varchar(250) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8; -- -- Dumping data for table `specifications` -- INSERT INTO `specifications` (`id`, `pid`, `speci`, `pvalue`) VALUES (1, 9, 'Processor Type', 'Intel Core i5'), (2, 9, 'Processor Speed', '2.50 GHz'), (3, 9, 'Operating System', 'Mac OS X 10.7'), (4, 9, 'Release Year', '2012'), (5, 9, 'Product Family', 'MacBook Pro'), (6, 9, 'Screen Size', '13.3'), (7, 9, 'Memory', '4 GB'), (8, 9, 'Hard Drive Capacity', '500 GB'), (9, 9, 'UPC', '411378263568'), (10, 10, 'Brand', 'Apple'), (11, 10, 'Product Family', 'MacBook Air'), (12, 10, 'Screen Size', '11.6'), (13, 10, 'Memory', '4 GB'), (14, 10, 'Hard Drive Capacity', '128 GB'), (15, 10, 'Processor Type', 'Intel Core i5'), (16, 10, 'Processor Speed', '1.60 GHz'), (17, 10, 'Operating System', 'Mac OS X 10.7'), (18, 10, 'Release Year', '2011'), (19, 10, 'UPC', '885909464043'), (20, 11, 'Condition', 'Used'), (21, 11, 'Brand', 'Canon'), (22, 11, 'Model', '20D'), (23, 11, 'Type', 'Digital SLR'), (24, 11, 'Megapixels', '8.2 MP'), (25, 11, 'Series', 'Canon EOS'), (26, 11, 'Battery Type', 'Lithium-ion'), (27, 11, 'Country of Manufacture', 'Japan'), (28, 11, 'MPN', '541167300'), (29, 11, 'UPC', '013803044430'), (30, 12, 'Condition', 'Used'), (31, 12, 'Brand', 'Canon'), (32, 13, 'Condition', 'New'), (33, 14, 'Condition', 'New'), (34, 14, 'Product Line', 'Nexus'), (35, 14, 'Operating System', 'Android'), (36, 14, 'Storage Capacity', '16GB'), (37, 14, 'Resolution', '1920 x 1200'), (38, 14, 'Processor', 'Quad core, 1.5 GHz'), (39, 14, 'RAM', '2 GB Memory'), (40, 0, 'Condition', 'New'), (41, 15, 'Condition', 'New'), (42, 15, 'Brand', 'Apple'), (43, 15, 'Storage Capacity', '16 GB'), (44, 15, 'Operating System', 'iOS'), (45, 15, 'Internet Connectivity', 'Wi-Fi + 4G'), (46, 15, 'Carrier', 'Unlocked'), (47, 15, 'Screen Size', '9.7'), (48, 16, 'Condition', 'Used'), (49, 17, 'Condition', 'New'), (50, 18, 'Condition', 'New'), (51, 18, 'Storage Capacity', '16 GB'), (52, 18, 'Brand', 'Samsung'), (53, 18, 'Colour', 'Ceramic White'), (54, 18, 'Camera Resolution', '8.0MP'), (55, 18, 'Carrier', 'Unlocked'), (56, 18, 'Screen Size', '4.27 in'), (57, 19, 'Condition', 'New'), (58, 20, 'Condition', 'New'), (59, 20, 'Resolution', '2160 x 1440'), (60, 20, 'Brand', 'Microsoft'), (61, 20, 'Operating System', 'Windows 8.1 Pro'), (62, 20, 'Storage Capacity', '128GB'), (63, 20, 'Processor Speed', '1.9 GHz'), (64, 21, 'Condition', 'New'), (65, 21, 'Brand', 'ASUS'), (66, 21, 'Model', 'GL551JX-ES71'), (67, 21, 'Graphics Processing Type', 'Dedicated Graphics'), (68, 21, 'Hard Drive Capacity', '750GB'), (69, 21, 'Memory', '12GB'), (70, 21, 'Processor Speed', '2.60GHz'), (71, 21, 'Screen Size', '15.6'), (72, 21, 'Operating System', 'Windows 8'), (73, 22, 'Condition', 'Used'), (74, 22, 'Brand', 'Lenovo'), (75, 22, 'Processor Type', 'Intel Core i5-3337U'), (76, 22, 'Memory', '4GB'), (77, 22, 'Screen Size', '11.6'), (78, 22, 'Hard Drive Capacity', '128GB SSD'); -- -------------------------------------------------------- -- -- Table structure for table `subscribers` -- CREATE TABLE `subscribers` ( `id` int(11) NOT NULL, `subscriber` varchar(150) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `subscribers` -- INSERT INTO `subscribers` (`id`, `subscriber`) VALUES (1, 'email@domain.com'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `fname` varchar(75) NOT NULL, `address` varchar(250) NOT NULL, `city` varchar(50) NOT NULL, `zip` varchar(15) NOT NULL, `country` varchar(50) NOT NULL, `phone` varchar(25) NOT NULL, `email` varchar(75) NOT NULL, `password` varchar(25) NOT NULL, `urole` tinyint(4) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `fname`, `address`, `city`, `zip`, `country`, `phone`, `email`, `password`, `urole`) VALUES (1, 'Administrator', 'My Address ', 'New York', '12345', 'USA', '+123456789', 'admin@gmail.com', 'admin', 0), (2, 'Jon Deo', 'My Address ', 'New York', '12345', 'USA', '123456789', 'email@gmail.com', 'password', 1); -- -- Indexes for dumped tables -- -- -- Indexes for table `ads` -- ALTER TABLE `ads` ADD PRIMARY KEY (`id`); -- -- Indexes for table `cats` -- ALTER TABLE `cats` ADD PRIMARY KEY (`id`); -- -- Indexes for table `languages` -- ALTER TABLE `languages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `productimages` -- ALTER TABLE `productimages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `products` -- ALTER TABLE `products` ADD PRIMARY KEY (`id`); -- -- Indexes for table `reviews` -- ALTER TABLE `reviews` ADD PRIMARY KEY (`id`); -- -- Indexes for table `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sliderimages` -- ALTER TABLE `sliderimages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `specifications` -- ALTER TABLE `specifications` ADD PRIMARY KEY (`id`); -- -- Indexes for table `subscribers` -- ALTER TABLE `subscribers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `ads` -- ALTER TABLE `ads` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `cats` -- ALTER TABLE `cats` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `languages` -- ALTER TABLE `languages` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `productimages` -- ALTER TABLE `productimages` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=55; -- -- AUTO_INCREMENT for table `products` -- ALTER TABLE `products` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=23; -- -- AUTO_INCREMENT for table `reviews` -- ALTER TABLE `reviews` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `settings` -- ALTER TABLE `settings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `sliderimages` -- ALTER TABLE `sliderimages` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `specifications` -- ALTER TABLE `specifications` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=79; -- -- AUTO_INCREMENT for table `subscribers` -- ALTER TABLE `subscribers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3; /*!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 */;
  2. If I knew how the persons script was fully made I would know where to pinpoint a certain php page. But I don’t know how it was made, and functions as it is made differently than the last.
  3. No I am not using my phone to code, i just logged into my file manager using my phone and clicked on edit so i can see the code. Link to zipped file of the scripts that I purchased and trying to figure out why categories or products from admin do not post into database
  4. As to Line 7 there is no more code outside of the line. the others I will post later
  5. This is the second script I’ve installed on the same site and admin has been able to delete from the database, but somehow still can’t insert into database? My config is set right, but can’t understand why two different scripts are having the same issue?
  6. Something in my mind is telling me to split this code with vendor being separate from the admin part of inserting product. <$insert_product = "insert into products (vendor_id,p_cat_id,cat_id,manufacturer_id,date,product_title,product_seo_desc,product_url,product_img1,product_img2,product_img3,product_price,product_psp_price,product_desc,product_features,product_video,product_keywords,product_label,product_type,product_weight,product_vendor_status,status) values ('admin_$admin_id','$product_cat','$cat','$manufacturer_id',NOW(),'$product_title','$product_seo_desc','$product_url','$product_img1','$product_img2','$product_img3','$product_price','$psp_price','$product_desc','$product_features','$product_video','$product_keywords','$product_label','$product_type','$product_weight','active','$status')";>
  7. P cat id is product category meaning the main category. Whereas cat id is the subcategories. Product vendor status: checks to see if the vendor has responded to the activation email in which allows them use of the vendor dashboard to be able to insert products.
  8. I put it inside the dB before the con$ string. No errors. And nothing more in my error log but will post the lines from my error log to see what might be wrong
  9. So, basically using laravel might be better at accomplishing it?
  10. I am looking in regard to Php code. Not css.
  11. I am somewhat new to Php but gradually understanding it. Html and basic programming was my first languages before getting into Laravel and Php. So, maybe explain where the code should be a little easier for me to understand. Like in a script or sql in phpmyadmin? Etc
  12. No errors today. But have these from day before. [07-Jan-2020 23:28:24 UTC] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /home/hk2khpfrmyh4/public_html/functions/functions.php on line 79 [07-Jan-2020 23:28:24 UTC] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /home/hk2khpfrmyh4/public_html/functions/functions.php on line 50 [07-Jan-2020 23:28:24 UTC] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /home/hk2khpfrmyh4/public_html/functions/functions.php on line 50 [07-Jan-2020 23:28:24 UTC] PHP Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/hk2khpfrmyh4/public_html/functions/functions.php on line 125 [07-Jan-2020 23:28:24 UTC] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /home/hk2khpfrmyh4/public_html/functions/functions.php on line 127
  13. After my navbar on desktop and large devices I want to make 20% floating on the left to show top 8 products sold and float on the right #myCarousel on large devices. But on small devices such as iPhones or tablets to have the #myCarousel on top with top 8 sold product list going down below the carousel. How can I do this? I have script for the carousel, but need help on how to make script for the top products as text highlighted as if a href with hover of product image. Plus how to make a table to pull that data into it for showing those products.
  14. i put that code in my script above insert products part and didn’t get any response. But it did take longer for the page to react. Still no products inserting. But here is the insert part and my products database MySQL for products. $insert_product = "insert into products (vendor_id,p_cat_id,cat_id,manufacturer_id,date,product_title,product_seo_desc,product_url,product_img1,product_img2,product_img3,product_price,product_psp_price,product_desc,product_features,product_video,product_keywords,product_label,product_type,product_weight,product_vendor_status,status) values ('admin_$admin_id','$product_cat','$cat','$manufacturer_id',NOW(),'$product_title','$product_seo_desc','$product_url','$product_img1','$product_img2','$product_img3','$product_price','$psp_price','$product_desc','$product_features','$product_video','$product_keywords','$product_label','$product_type','$product_weight','active','$status')"; $run_product = mysqli_query($con,$insert_product); $product_id = mysqli_insert_id($con); if($run_product){ if($product_type != "variable_product"){ if($enable_stock == "yes" and $stock_quantity > 0){ $stock_status = "instock"; }elseif($enable_stock == "yes" and $allow_backorders == "no" and $stock_quantity < 1){ $stock_status = "outofstock"; }elseif($enable_stock == "yes" and ($allow_backorders == "yes" or $allow_backorders == "notify") and $stock_quantity < 1){ $stock_status = "onbackorder"; } $insert_product_stock = "insert into products_stock (product_id,enable_stock,stock_status,stock_quantity,allow_backorders) values ('$product_id','$enable_stock','$stock_status','$stock_quantity','$allow_backorders')"; $run_insert_product_stock = mysqli_query($con,$insert_product_stock); MySQL database setup CREATE TABLE `products` ( `product_id` int(10) NOT NULL, `vendor_id` text NOT NULL, `p_cat_id` int(10) NOT NULL, `cat_id` int(10) NOT NULL, `manufacturer_id` int(10) NOT NULL, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `product_title` text NOT NULL, `product_seo_desc` text NOT NULL, `product_url` text NOT NULL, `product_img1` text NOT NULL, `product_img2` text NOT NULL, `product_img3` text NOT NULL, `product_price` int(10) NOT NULL, `product_psp_price` int(100) NOT NULL, `product_desc` text NOT NULL, `product_features` text NOT NULL, `product_video` text NOT NULL, `product_keywords` text NOT NULL, `product_label` text NOT NULL, `product_type` text NOT NULL, `product_weight` decimal(10,1) NOT NULL, `product_views` int(10) NOT NULL, `product_vendor_status` text NOT NULL, `status` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  15. I posted the Php script for insert_products.php. my DB and functions settings are correct. My delete functions, and inserting of categories, manufacturers, logins, registers all work perfectly fine. It’s just insert_product.php that is somehow not inputting products into the database. I need help because I’m wondering if something might be missing as I am not the original programmer in which is preventing it from posting into the database. Like whether a $post(action) is required or if the script is ok but something else?
  16. I am having an issue trying to get products that I am entering through my admin panel to go into my database. I am thinking that the programmer of the script might have forgot some code possibly, but everything else does get inserted into the database regarding categories, manufactures etc. Here is the insert product php script. My db and functions are set to go to my database with website name/password etc. <?php if(!isset($_SESSION['customer_email'])){ echo "<script> window.open('../checkout.php','_self'); </script>"; } $customer_email = $_SESSION['customer_email']; $get_customer = "select * from customers where customer_email='$customer_email'"; $run_customer = mysqli_query($con,$get_customer); $row_customer = mysqli_fetch_array($run_customer); $customer_id = $row_customer['customer_id']; $select_general_settings = "select * from general_settings"; $run_general_settings = mysqli_query($con,$select_general_settings); $row_general_settings = mysqli_fetch_array($run_general_settings); $product_vendor_status = $row_general_settings["new_product_status"]; ?> <script src="//cdn.tinymce.com/4/tinymce.min.js"></script> <script>tinymce.init({ selector:'#product_desc,#product_features' });</script> <div class="row"><!-- 2 row Starts --> <div class="col-lg-12"><!-- col-lg-12 Starts --> <div class="panel panel-default"><!-- panel panel-default Starts --> <div class="panel-heading"><!-- panel-heading Starts --> <h3 class="panel-title"> <i class="fa fa-money fa-fw"></i> Insert Product </h3> </div><!-- panel-heading Ends --> <div class="panel-body"><!-- panel-body Starts --> <form id="insert_product_form" method="post" enctype="multipart/form-data"><!-- form-horizontal Starts --> <div class="row"><!-- 2 row Starts --> <div class="col-md-9"><!-- col-md-9 Starts --> <div class="form-group" ><!-- form-group Starts --> <label> Product Title </label> <input type="text" name="product_title" class="form-control" required > </div><!-- form-group Ends --> <div class="form-group" ><!-- form-group Starts --> <label> Product Seo Description </label> <textarea name="product_seo_desc" class="form-control" maxlength="230" placeholder="Most search engines use a maximum of 230 chars for the description."></textarea> </div><!-- form-group Ends --> <div class="form-group" ><!-- form-group Starts --> <label> Product Url </label> <input type="text" name="product_url" class="form-control" required > <br> <p style="font-size:15px; font-weight:bold;"> Product Url Example : navy-blue-t-shirt </p> </div><!-- form-group Ends --> <div class="form-group"><!-- form-group Starts --> <label> Product Tabs </label> <ul class="nav nav-tabs"><!-- nav nav-tabs Starts --> <li class="active"> <a data-toggle="tab" href="#description"> Product Description </a> </li> <li> <a data-toggle="tab" href="#features"> Product Features </a> </li> <li> <a data-toggle="tab" href="#video"> Sounds And Videos </a> </li> </ul><!-- nav nav-tabs Ends --> <div class="tab-content"><!-- tab-content Starts --> <div id="description" class="tab-pane fade in active"><!-- description tab-pane fade in active Starts --> <br> <textarea name="product_desc" class="form-control" rows="15" id="product_desc"></textarea> </div><!-- description tab-pane fade in active Ends --> <div id="features" class="tab-pane fade in"><!-- features tab-pane fade in Starts --> <br> <textarea name="product_features" class="form-control" rows="15" id="product_features"></textarea> </div><!-- features tab-pane fade in Ends --> <div id="video" class="tab-pane fade in"><!-- video tab-pane fade in Starts --> <br> <textarea name="product_video" class="form-control" rows="15"></textarea> </div><!-- video tab-pane fade in Ends --> </div><!-- tab-content Ends --> </div><!-- form-group Ends --> <div class="form-group" id="product_weight"><!-- form-group Starts --> <label> Product Weight <small> (kg)</small> </label> <input type="text" name="product_weight" class="form-control"> </div><!-- form-group Ends --> <div class="form-group" id="product_price"><!-- form-group Starts --> <label> Product Price </label> <input type="text" name="product_price" class="form-control" required> </div><!-- form-group Ends --> <div class="form-group" id="product_psp_price"><!-- form-group Starts --> <label> Product Sale Price </label> <input type="text" name="psp_price" class="form-control"> </div><!-- form-group Ends --> </div><!-- col-md-9 Ends --> <div class="col-md-3"><!-- col-md-3 Starts --> <div class="form-group"><!-- form-group Starts --> <label> Select A Product Type </label> <select class="form-control" name="product_type"><!-- select manufacturer Starts --> <option value="physical_product"> (Physical Product) Simple Product </option> <option value="digital_product"> (Digital Product) Downloadable Product </option> <option value="variable_product"> (Variable Product) Advanced Product </option> </select><!-- select manufacturer Ends --> </div><!-- form-group Ends --> <div class="form-group"><!-- form-group Starts --> <label> Select A Manufacturer </label> <select class="form-control" name="manufacturer"><!-- select manufacturer Starts --> <option> Select A Manufacturer </option> <?php $get_manufacturer = "select * from manufacturers"; $run_manufacturer = mysqli_query($con,$get_manufacturer); while($row_manufacturer= mysqli_fetch_array($run_manufacturer)){ $manufacturer_id = $row_manufacturer['manufacturer_id']; $manufacturer_title = $row_manufacturer['manufacturer_title']; echo "<option value='$manufacturer_id'> $manufacturer_title </option>"; } ?> </select><!-- select manufacturer Ends --> </div><!-- form-group Ends --> <div class="form-group"><!-- form-group Starts --> <label> Product Category </label> <select name="product_cat" class="form-control" > <option> Select a Product Category </option> <?php $get_p_cats = "select * from product_categories"; $run_p_cats = mysqli_query($con,$get_p_cats); while ($row_p_cats=mysqli_fetch_array($run_p_cats)) { $p_cat_id = $row_p_cats['p_cat_id']; $p_cat_title = $row_p_cats['p_cat_title']; echo "<option value='$p_cat_id' >$p_cat_title</option>"; } ?> </select> </div><!-- form-group Ends --> <div class="form-group" ><!-- form-group Starts --> <label> Category </label> <select name="cat" class="form-control" > <option> Select a Category </option> <?php $get_cat = "select * from categories"; $run_cat = mysqli_query($con,$get_cat); while ($row_cat=mysqli_fetch_array($run_cat)) { $cat_id = $row_cat['cat_id']; $cat_title = $row_cat['cat_title']; echo "<option value='$cat_id'>$cat_title</option>"; } ?> </select> </div><!-- form-group Ends --> <div class="form-group" ><!-- form-group Starts --> <label> Product Image 1 </label> <input type="file" name="product_img1" class="form-control" required > </div><!-- form-group Ends --> <div class="form-group" ><!-- form-group Starts --> <label> Product Image 2 </label> <input type="file" name="product_img2" class="form-control"> </div><!-- form-group Ends --> <div class="form-group" ><!-- form-group Starts --> <label> Product Image 3 </label> <input type="file" name="product_img3" class="form-control"> </div><!-- form-group Ends --> <div class="form-group" ><!-- form-group Starts --> <label> Product Keywords </label> <input type="text" name="product_keywords" class="form-control"> </div><!-- form-group Ends --> <div class="form-group" ><!-- form-group Starts --> <label> Product Label </label> <input type="text" name="product_label" class="form-control"> </div><!-- form-group Ends --> </div><!-- col-md-3 Ends --> </div><!-- 2 row Ends --> <div class="form-group" id="product-stock-management"><!-- form-group Starts --> <label> Product Inventory Stock Management </label> <div class="panel panel-default"><!-- panel panel-default Starts --> <div class="panel-heading"><!-- panel-heading Starts --> <strong> Inventory - Stock Options </strong> </div><!-- panel-heading Ends --> <div class="panel-body"><!--panel-body Starts --> <div class="row"><!-- row Starts --> <div class="col-sm-6" id="stock-status"><!-- col-sm-6 Starts --> <div class="form-group"><!-- form-group Starts --> <label> Stock Status </label> <select class="form-control" name="stock_status" required><!-- select manufacturer Starts --> <option value="instock">In stock</option> <option value="outofstock">Out of stock</option> <option value="onbackorder">On backorder</option> </select><!-- select manufacturer Ends --> </div><!-- form-group Ends --> </div><!-- col-sm-6 Ends --> <div class="col-sm-6"><!-- col-sm-6 Starts --> <div class="form-group"><!-- form-group Starts --> <label> Enable stock management at product level? </label> <div class="radio"> <label> <input type="radio" name="enable_stock" value="yes" required> Yes </label> <label> <input type="radio" name="enable_stock" value="no" checked required> No </label> </div> </div><!-- form-group Ends --> </div><!-- col-sm-6 Ends --> </div><!-- row Ends --> <div class="row" id="stock-management-row"><!-- row Starts --> <div class="col-sm-6"><!-- col-sm-6 Starts --> <div class="form-group"><!-- form-group Starts --> <label> Stock Quantity </label> <input type="number" name="stock_quantity" value="0" class="form-control" required> </div><!-- form-group Ends --> </div><!-- col-sm-6 Ends --> <div class="col-sm-6"><!-- col-sm-6 Starts --> <div class="form-group"><!-- form-group Starts --> <label> Allow backorders? </label> <select class="form-control" name="allow_backorders" required><!-- select manufacturer Starts --> <option value="no">Do not allow</option> <option value="notify">Allow, but notify customer</option> <option value="yes">Allow</option> </select><!-- select manufacturer Ends --> </div><!-- form-group Ends --> </div><!-- col-sm-6 Ends --> </div><!-- row Ends --> </div><!--panel-body Ends --> </div><!-- panel panel-default Ends --> </div><!-- form-group Ends --> </form><!-- form-horizontal Ends --> <div class="form-group" id="variable_product_options"><!-- form-group Starts --> <label> Variable Product Options </label> <div class="panel panel-default"><!-- panel panel-default Starts --> <div class="panel-heading"><!-- panel-heading Starts --> <ul class="nav nav-tabs"><!-- nav nav-tabs Starts --> <li class="active"> <a data-toggle="tab" href="#product_attributes"> Product Attributes </a> </li> <li> <a data-toggle="tab" href="#product_variations"> Product Variations </a> </li> </ul><!-- nav nav-tabs Ends --> </div><!-- panel-heading Ends --> <div class="panel-body"><!--panel-body Starts --> <div class="tab-content"><!-- tab-content Starts --> <div id="product_attributes" class="tab-pane fade in active"><!-- product_attributes tab-pane fade in active Starts --> <form id="insert_attribute_form" method="post"><!-- form Starts --> <div class="row"><!-- row Starts --> <div class="col-sm-4"><!-- col-sm-4 Starts --> <div class="form-group"><!-- form-group Starts --> <label> Name: </label> <input type="text" name="attribute_name" class="form-control" required> </div><!-- form-group Ends --> </div><!-- col-sm-4 Ends --> <div class="col-sm-8"><!-- col-sm-8 Starts --> <div class="form-group"><!-- form-group Starts --> <label> Value(s): </label> <textarea name="attribute_values" class="form-control" placeholder="Enter some attributes by '|' separating values." required></textarea> </div><!-- form-group Ends --> </div><!-- col-sm-8 Ends --> </div><!-- row Ends --> <div class="form-group"><!-- form-group Starts --> <input type="submit" value="Insert Product Attribute" class="btn btn btn-primary"> </div><!-- form-group Ends --> </form><!-- form Ends --> <table class="table table-hover table-bordered table-striped"><!-- table table-hover table-bordered table-striped Starts --> <thead><!-- thead Starts --> <tr> <th>Attribute Name:</th> <th>Attribute Value(s):</th> <th>Actions:</th> </tr> </thead><!-- thead Ends --> <tbody><!-- tbody Starts --> <?php $random_id = 152; $select_product_attributes = "select * from product_attributes where product_id='$random_id'"; $run_product_attributes = mysqli_query($con,$select_product_attributes); while($row_product_attributes = mysqli_fetch_array($run_product_attributes)){ $attribute_id = $row_product_attributes["attribute_id"]; $attribute_name = $row_product_attributes["attribute_name"]; $attribute_values = $row_product_attributes["attribute_values"]; ?> <tr id="tr-attribute-<?php echo $attribute_id; ?>"> <td> <div class="edit" data-attribute="<?php echo $attribute_id; ?>"><?php echo $attribute_name; ?></div> <input type="text" id="attribute-name" class="input-edit form-control" data-attribute="<?php echo $attribute_id; ?>" value="<?php echo $attribute_name; ?>"> </td> <td> <div class="edit" data-attribute="<?php echo $attribute_id; ?>"><?php echo $attribute_values; ?></div> <input type="text" id="attribute-values" class="input-edit form-control" data-attribute="<?php echo $attribute_id; ?>" value="<?php echo $attribute_values; ?>"> </td> <td> <div class="btn-group"> <a href="#" class="edit-product-attribute btn btn-primary btn-sm" data-attribute="<?php echo $attribute_id; ?>"> <i class="fa fa-pencil"></i> Edit </a> <a href="#" class="save-product-attribute btn btn-success btn-sm" data-attribute="<?php echo $attribute_id; ?>"> <i class="fa fa-floppy-o"></i> Save </a> <a href="#" class="delete-product-attribute btn btn-danger btn-sm" data-attribute="<?php echo $attribute_id; ?>"> <i class="fa fa-trash-o"></i> Delete </a> </div> </td> </tr> <?php } ?> </tbody><!-- tbody Ends --> </table><!-- table table-hover table-bordered table-striped Ends --> </div><!-- product_attributes tab-pane fade in active Ends --> <div id="product_variations" class="tab-pane fade in"><!-- product_variations tab-pane fade in Starts --> <form id="product-variations-form" method="post" enctype="multipart/form-data"><!-- form Starts --> <div class="form-group row"><!-- form-group Starts --> <label class="col-sm-3 control-label"> Default Form Values: </label> <div class="col-sm-9"><!-- col-sm-10 Starts --> <div class="row" id="default_form_values"><!-- row default_form_values Starts --> </div><!-- row default_form_values Ends --> <span class="help-block"> These are the product attributes that will be pre-selected on the frontend. </span> </div><!-- col-sm-9 Ends --> </div><!-- form-group Ends --> <hr class="variation-hr"> <div class="form-group row"><!-- form-group Starts --> <label class="col-sm-1 control-label"> Actions: </label> <div class="col-sm-10"><!-- col-sm-10 Starts --> <select class="form-control" id="action_select"><!-- select manufacturer Starts --> <option value="add_variation"> Add A New Variation </option> <option value="create_variations_from_attributes"> Create New Variations From All Attributes </option> <option value="delete_all_variations"> Delete All Variations </option> </select><!-- select manufacturer Ends --> </div><!-- col-sm-10 Ends --> <div class="col-sm-1"><!-- col-sm-1 Starts --> <button type="button" id="go_button" class="btn btn-success form-control"> Go </button> </div><!-- col-sm-1 Ends --> </div><!-- form-group Ends --> <div class="product-variations-div"><!-- product-variations-div Starts --> </div><!-- product-variations-div Ends --> <hr class="variation-hr"> <div class="form-group"><!-- form-group Starts --> <input type="submit" value="Save Product Variations" class="btn btn btn-success"> </div><!-- form-group Ends --> </form><!-- form Ends --> <div class="ajax-response-div"></div> </div><!-- product_variations tab-pane fade in Ends --> </div><!-- tab-content Ends --> </div><!--panel-body Ends --> </div><!-- panel panel-default Ends --> </div><!-- form-group Ends --> <div class="form-group"><!-- form-group Starts --> <input type="submit" name="submit" value="Insert Product" form="insert_product_form" class="btn btn-primary form-control"> </div><!-- form-group Ends --> </div><!-- panel-body Ends --> </div><!-- panel panel-default Ends --> </div><!-- col-lg-12 Ends --> </div><!-- 2 row Ends --> <script> $(document).ready(function(){ //Product Stock Management Code Starts $("#stock-management-row").hide(); $("input[name='enable_stock']").click(function(){ var radio_value = $(this).val(); if(radio_value == "yes"){ $("#stock-status").hide(); $("#stock-management-row").show(); }else if(radio_value == "no"){ $("#stock-status").show(); $("#stock-management-row").hide(); } }); //Product Stock Management Code Ends //Change Product Type Function Code Starts function change_product_type(){ var product_type = $("select[name='product_type']").val(); if(product_type == "physical_product"){ $("#product_weight").show(); $("#product_price").show(); $("#product_psp_price").show(); $('#product_weight input,#product_price input,#product_psp_price input').prop("disabled", false); $("#product-stock-management").show(); $('#product-stock-management input,#product-stock-management select').prop("disabled", false); $("#variable_product_options").hide(); }else if(product_type == "digital_product"){ $("#product_weight").hide(); $("#product_price").show(); $("#product_psp_price").show(); $('#product_weight input,#product_price input,#product_psp_price input').prop("disabled", false); $("#product-stock-management").show(); $('#product-stock-management input,#product-stock-management select').prop("disabled", false); $("#variable_product_options").hide(); }else if(product_type == "variable_product"){ $("#product_weight").hide(); $("#product_price").hide(); $("#product_psp_price").hide(); $('#product_weight input,#product_price input,#product_psp_price input').prop("disabled", true); $("#product-stock-management").hide(); $('#product-stock-management input,#product-stock-management select').prop("disabled", true); $("#variable_product_options").show(); } } //Change Product Type Function Code Ends change_product_type(); $("select[name='product_type']").change(function(){ change_product_type(); }); //Load Product Attributes Function Code Starts function load_product_attributes(){ $.ajax({ method: "POST", url: "variable_product/load_product_attributes.php", data: { random_id: <?php echo $random_id; ?> }, success:function(data){ $("table tbody").html(data); $("table").removeClass("wait-loader"); } }); } //Load Product Attributes Function Code Ends //Insert New Product Attribute Code Starts $("#insert_attribute_form").submit(function(event){ event.preventDefault(); $("table").addClass("wait-loader"); $.ajax({ method: "POST", url: "variable_product/insert_product_attribute.php", data: $('#insert_attribute_form').serialize() + "&random_id=<?php echo $random_id; ?>", success: function(){ $("#insert_attribute_form").find("input[type=text],textarea").val(""); load_product_attributes(); } }); }); //Insert New Product Attribute Code Ends //Edit Product Attribute Code Starts $(".input-edit").hide(); $(".save-product-attribute").hide(); $(".edit-product-attribute").on('click', function(event){ event.preventDefault(); var attribute_id = $(this).data("attribute"); $(".edit").show(); $(".input-edit").hide(); $(".edit[data-attribute='" + attribute_id +"']").hide(); $(".input-edit[data-attribute='" + attribute_id +"']").show().focus(); $(".edit-product-attribute[data-attribute='" + attribute_id +"']").hide(); $(".save-product-attribute[data-attribute='" + attribute_id +"']").show(); }); //Edit Product Attribute Code Ends //Update Save Product Attribute Code Starts $(".save-product-attribute").on('click', function(event){ event.preventDefault(); var attribute_id = $(this).data("attribute"); $(".edit[data-attribute='" + attribute_id +"']").show(); $(".input-edit[data-attribute='" + attribute_id +"']").hide(); $(".edit-product-attribute[data-attribute='" + attribute_id +"']").show(); $(".save-product-attribute[data-attribute='" + attribute_id +"']").hide(); var attribute_name = $("#attribute-name[data-attribute='" + attribute_id +"']").val(); var attribute_values = $("#attribute-values[data-attribute='" + attribute_id +"']").val(); $("#attribute-name[data-attribute='" + attribute_id +"']").prev(".edit").text(attribute_name); $("#attribute-values[data-attribute='" + attribute_id +"']").prev(".edit").text(attribute_values); var random_id = <?php echo $random_id; ?>; $.ajax({ method: "POST", url: "variable_product/update_product_attribute.php", data: { random_id: random_id, attribute_id: attribute_id, attribute_name: attribute_name, attribute_values: attribute_values } }); }); //Update Save Product Attribute Code Ends //Delete Product Attribute Code Starts $(".delete-product-attribute").on('click', function(event){ event.preventDefault(); var attribute_id = $(this).data("attribute"); $("#tr-attribute-" + attribute_id).remove(); var random_id = <?php echo $random_id; ?>; $.ajax({ method: "POST", url: "variable_product/delete_product_attribute.php", data: { random_id: random_id, attribute_id: attribute_id } }); }); //Delete Product Attribute Code Ends //Load Product Variations Default Form Values Function Code Starts function load_variations_default_form_values(){ $.ajax({ method: "POST", url: "variable_product/load_default_form_values.php", data: { random_id: <?php echo $random_id; ?> }, success:function(data){ $("#default_form_values").html(data); } }); } //Load Product Variations Default Form Values Function Code Ends //Load Product Variations Function Code Starts function load_product_variations(){ $.ajax({ method: "POST", url: "variable_product/load_product_variations.php", data: { random_id: <?php echo $random_id; ?> }, success:function(data){ $(".product-variations-div").html(data); $(".product-variations-div").removeClass("wait-loader"); } }); } //Load Product Variations Function Code Ends //Click Product Variations Tab Code Starts $("a[href='#product_variations']").click(function(){ $(".product-variations-div").addClass("wait-loader"); load_variations_default_form_values(); load_product_variations(); }); //Click Product Variations Tab Code Ends //Save Update Product Variations Function Code Starts function save_update_product_variations(){ var form = document.getElementById("product-variations-form"); var form_data = new FormData(form); form_data.append("random_id", <?php echo $random_id; ?>); $.ajax({ method: "POST", url: "variable_product/update_all_variations.php", data:form_data, contentType: false, cache: false, processData:false, success: function(data){ $(".ajax-response-div").html(data); $(".product-variations-div").removeClass("wait-loader"); } }); } //Save Update Product Variations Function Code Ends //Product Variations Actions Go Button Code Starts $("#go_button").click(function(){ var action_select = $("#action_select").val(); if(action_select == "add_variation"){ $(".product-variations-div").addClass("wait-loader"); save_update_product_variations(); $(".product-variations-div").addClass("wait-loader"); $.ajax({ method: "POST", url: "variable_product/insert_product_variation.php", data: { random_id: <?php echo $random_id; ?> }, success: function(){ load_product_variations(); } }); }else if(action_select == "create_variations_from_attributes"){ var confirm_action = confirm("Are you sure you want to link all variations? This will create a new variation for each and every possible combination of variation attributes (max 50 per run)."); if(confirm_action == true){ $(".product-variations-div").addClass("wait-loader"); save_update_product_variations(); $(".product-variations-div").addClass("wait-loader"); $.ajax({ method: "POST", url: "variable_product/create_variations_from_attributes.php", data: { random_id: <?php echo $random_id; ?> }, success: function(data){ $(".ajax-response-div").html(data); load_product_variations(); load_variations_default_form_values(); } }); } }else if(action_select == "delete_all_variations"){ var confirm_action = confirm("Are you sure you want to delete all variations? This cannot be undone."); if(confirm_action == true){ $(".product-variations-div").addClass("wait-loader"); $.ajax({ method: "POST", url: "variable_product/delete_all_variations.php", data: { random_id: <?php echo $random_id; ?> }, success: function(){ load_product_variations(); load_variations_default_form_values(); } }); } } }); //Product Variations Actions Go Button Code Ends //Save Update Submit From Of Product Variations Code Starts $("#product-variations-form").submit(function(event){ event.preventDefault(); $(".product-variations-div").addClass("wait-loader"); save_update_product_variations(); load_variations_default_form_values(); }); //Save Update Submit From Of Product Variations Code Ends }); </script> <?php if(isset($_POST['submit'])){ $product_title = mysqli_real_escape_string($con, $_POST['product_title']); $product_seo_desc = mysqli_real_escape_string($con, $_POST['product_seo_desc']); $product_url = mysqli_real_escape_string($con, $_POST['product_url']); $product_cat = mysqli_real_escape_string($con, $_POST['product_cat']); $cat = mysqli_real_escape_string($con, $_POST['cat']); $manufacturer_id = mysqli_real_escape_string($con, $_POST['manufacturer']); $product_price = mysqli_real_escape_string($con, $_POST['product_price']); $product_desc = mysqli_real_escape_string($con, $_POST['product_desc']); $product_keywords = mysqli_real_escape_string($con, $_POST['product_keywords']); $psp_price = mysqli_real_escape_string($con, $_POST['psp_price']); $product_label = mysqli_real_escape_string($con, $_POST['product_label']); $product_type = mysqli_real_escape_string($con, $_POST['product_type']); $product_features = mysqli_real_escape_string($con, $_POST['product_features']); $product_video = mysqli_real_escape_string($con, $_POST['product_video']); $product_weight = mysqli_real_escape_string($con, $_POST['product_weight']); $stock_status = mysqli_real_escape_string($con, $_POST['stock_status']); $enable_stock = mysqli_real_escape_string($con, $_POST['enable_stock']); $stock_quantity = mysqli_real_escape_string($con, $_POST['stock_quantity']); $allow_backorders = mysqli_real_escape_string($con, $_POST['allow_backorders']); $status = "product"; $product_img1 = $_FILES['product_img1']['name']; $product_img2 = $_FILES['product_img2']['name']; $product_img3 = $_FILES['product_img3']['name']; $temp_name1 = $_FILES['product_img1']['tmp_name']; $temp_name2 = $_FILES['product_img2']['tmp_name']; $temp_name3 = $_FILES['product_img3']['tmp_name']; $allowed = array('jpeg','jpg','gif','png'); $product_img1_extension = pathinfo($product_img1, PATHINFO_EXTENSION); $product_img2_extension = pathinfo($product_img2, PATHINFO_EXTENSION); $product_img3_extension = pathinfo($product_img3, PATHINFO_EXTENSION); if(!in_array($product_img1_extension,$allowed)){ echo "<script> alert('Your Product Image 1 File Extension Is Not Supported.'); </script>"; $product_img1 = ""; }else{ move_uploaded_file($temp_name1,"../admin_area/product_images/$product_img1"); } if(!empty($product_img2)){ if(!in_array($product_img2_extension,$allowed)){ echo "<script> alert('Your Product Image 2 File Extension Is Not Supported.'); </script>"; $product_img2 = ""; }else{ move_uploaded_file($temp_name2,"../admin_area/product_images/$product_img2"); } } if(!empty($product_img3)){ if(!in_array($product_img3_extension,$allowed)){ echo "<script> alert('Your Product Image 3 File Extension Is Not Supported.'); </script>"; $product_img3 = ""; }else{ move_uploaded_file($temp_name3,"../admin_area/product_images/$product_img3"); } } $insert_product = "insert into products (vendor_id,p_cat_id,cat_id,manufacturer_id,date,product_title,product_seo_desc,product_url,product_img1,product_img2,product_img3,product_price,product_psp_price,product_desc,product_features,product_video,product_keywords,product_label,product_type,product_weight,product_vendor_status,status) values ('$customer_id','$product_cat','$cat','$manufacturer_id',NOW(),'$product_title','$product_seo_desc','$product_url','$product_img1','$product_img2','$product_img3','$product_price','$psp_price','$product_desc','$product_features','$product_video','$product_keywords','$product_label','$product_type','$product_weight','$product_vendor_status','$status')"; $run_product = mysqli_query($con,$insert_product); $product_id = mysqli_insert_id($con); if($run_product){ if($product_type != "variable_product"){ if($enable_stock == "yes" and $stock_quantity > 0){ $stock_status = "instock"; }elseif($enable_stock == "yes" and $allow_backorders == "no" and $stock_quantity < 1){ $stock_status = "outofstock"; }elseif($enable_stock == "yes" and ($allow_backorders == "yes" or $allow_backorders == "notify") and $stock_quantity < 1){ $stock_status = "onbackorder"; } $insert_product_stock = "insert into products_stock (product_id,enable_stock,stock_status,stock_quantity,allow_backorders) values ('$product_id','$enable_stock','$stock_status','$stock_quantity','$allow_backorders')"; $run_insert_product_stock = mysqli_query($con,$insert_product_stock); } $update_product_stock = "update products_stock set product_id='$product_id' where product_id='$random_id'"; $run_update_product_stock = mysqli_query($con,$update_product_stock); $update_product_attributes = "update product_attributes set product_id='$product_id' where product_id='$random_id'"; $run_product_attributes = mysqli_query($con, $update_product_attributes); $update_product_variations = "update product_variations set product_id='$product_id' where product_id='$random_id'"; $run_product_variations = mysqli_query($con, $update_product_variations); echo " <script> alert(' Your Product Has Been Inserted Successfully. '); window.open('index.php?products','_self'); </script> "; } } ?>
  17. Is there a way to make placeholder that works in conjunction with the api as to allow the user to type letters and to possibly auto fill? Or show multiple selections similar to a drop down box such as a person typing Forest and part way of typing (for), that it shows forest and every other card name that begins with for unless user selects forest or continues typing the word?
  18. @mac_gyver, what do you mean by using the computer to write the code though as in regards to an editor or such program?
  19. As to Ginerjm, I am not wisecracking. You say people are helping me, but even you said when I put up $_post, you even responded me this when others said to use that. Which has confused me greatly of what to even use, since I tried echo, $post, $_post,and $_get. And a couple people are saying don't use that use this. It would have been simpler to just put an example of just one line to help me to start off with and figure the rest from there. I am trying to learn the basics of the script and I am more of a visual learner and try to learn by seeing it. That is why I posted little script parts even if not correct, to try to get it to show up from the html form to the .php page in the same format as the form. I have progressed a little and had some things show up on the php page but not of what I was intending to have done, and instead it posted a line or two of php script on the page of echo'ing it even when post tag was used. Plus by using the parts of php, I am trying to see what each one does as to learn. When I had my game website with html, I learned it myself by breaking down other websites into code and figured out a majority of the code about 10 years ago. I am trying to do the same with php so I can get a better understanding of what the code is doing even at the smallest parts. Such as echo'ing a person's first and last name onto a page and such.
  20. I use my iPhone and it doesn't use autocorrect correctly on spoken sentences using the microphone.
  21. I was using a php form generator, and had noticed it uses .$_REQUEST, would that be what I would use for my form?
  22. actually english and 6 other languages.
  23. I was just posting from one of the websites trying to teach php where I got a post example from
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.