-- Table structure for table `es_counteroffer`
--

CREATE TABLE `es_counteroffer` (
  `nCId` int(11) NOT NULL AUTO_INCREMENT,
  `nSTId` bigint(20) NOT NULL DEFAULT '0',
  `nPostedBy` bigint(20) NOT NULL DEFAULT '0',
  `nPostedTo` bigint(20) NOT NULL DEFAULT '0',
  `nPrice` float NOT NULL DEFAULT '0',
  `vDes` text NOT NULL,
  `vType` varchar(4) NOT NULL DEFAULT '',
  `vStatus` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`nCId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_counteroffer`
--


--
-- Table structure for table `es_creditpayments`
--

CREATE TABLE `es_creditpayments` (
  `nId` int(11) NOT NULL AUTO_INCREMENT,
  `nUserId` int(11) NOT NULL DEFAULT '0',
  `nAmount` double NOT NULL DEFAULT '0',
  `nPoints` double NOT NULL DEFAULT '0',
  `vTxnId` varchar(200) NOT NULL DEFAULT '',
  `vMethod` char(2) NOT NULL DEFAULT '00',
  `dDate` date NOT NULL DEFAULT '0000-00-00',
  `vCurrentTransaction` varchar(200) NOT NULL DEFAULT '',
  `vStatus` char(1) NOT NULL DEFAULT 'P',
  `vName` varchar(200) NOT NULL DEFAULT '',
  `vBank` varchar(200) NOT NULL DEFAULT '',
  `vReferenceNo` varchar(200) NOT NULL DEFAULT '',
  `dReferenceDate` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`nId`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_creditpayments`
--

INSERT INTO `es_creditpayments` VALUES (1,21,10,5,'','yp','2011-08-01','$10&nbsp;=&nbsp;5&nbsp;Points','A','','','','0000-00-00'),(2,28,10,5,'0S738409TJ8121123','pp','2011-08-02','$10&nbsp;=&nbsp;5&nbsp;Points','A','','','','0000-00-00'),(3,0,10,0,'3B868955BF7051315','pp','2011-08-04','$10&nbsp;=&nbsp;5&nbsp;Points','A','','','','0000-00-00'),(4,37,10,5,'42J29076JV378893J','pp','2011-08-04','$10&nbsp;=&nbsp;5&nbsp;Points','A','','','','0000-00-00'),(5,21,10,5,'','bu','2011-08-06','$10&nbsp;=&nbsp;5&nbsp;Points','A','Beniston B','International','989896','2011-08-06'),(6,31,10,5,'4CT10974BX1119523','pp','2011-08-08','$10&nbsp;=&nbsp;5&nbsp;Points','A','','','','0000-00-00'),(7,37,200,100,'','pc','2011-08-10','$10&nbsp;=&nbsp;5&nbsp;Points','P','1133','46656','5665665656','2011-08-10'),(8,37,190,95,'','ca','2011-08-11','$10&nbsp;=&nbsp;5&nbsp;Points','A','1133','46656','5665665656','2011-08-11'),(9,37,200,100,'','gc','2011-08-11','$10&nbsp;=&nbsp;5&nbsp;Points','A','','','','0000-00-00'),(10,21,1,2,'100070686508','bp','2011-08-19','$1&nbsp;=&nbsp;2&nbsp;Points','A','','','','0000-00-00'),(11,21,4,8,'TEST-2011-08-19-14-38','cc','2011-08-19','$1&nbsp;=&nbsp;2&nbsp;puntos','A','','','','0000-00-00'),(12,21,9,18,'','pp','2011-08-23','$1&nbsp;=&nbsp;2&nbsp;Points','A','','','','0000-00-00'),(13,37,20,40,'TEST-2011-12-01-11-21','cc','2011-12-01','$1&nbsp;=&nbsp;2&nbsp;Points','A','','','','0000-00-00'),(14,37,50,100,'TEST-2011-12-01-11-42','cc','2011-12-01','$1&nbsp;=&nbsp;2&nbsp;Points','A','','','','0000-00-00'),(15,57,50,100,'TEST-2011-12-06-11-31','cc','2011-12-06','$1&nbsp;=&nbsp;2&nbsp;Points','A','','','','0000-00-00'),(16,57,50,100,'TEST-2011-12-09-08-50','cc','2011-12-09','$1&nbsp;=&nbsp;2&nbsp;Points','A','','','','0000-00-00'),(17,37,50,100,'TEST-2011-12-14-12-15','cc','2011-12-14','$1&nbsp;=&nbsp;2&nbsp;Points','A','','','','0000-00-00'),(18,37,50,100,'TEST-2011-12-20-09-28','cc','2011-12-20','$1&nbsp;=&nbsp;2&nbsp;Points','A','','','','0000-00-00'),(19,115,1,1,'TEST-11/18/2014 04:18:52','cc','2014-11-18','$1&nbsp;=&nbsp;1&nbsp;Points','A','','','','0000-00-00'),(20,115,9,9,'8TM71704CS349152M','pp','2014-11-18','$1&nbsp;=&nbsp;1&nbsp;Points','A','','','','0000-00-00'),(21,120,100,100,'5R525321FY446793X','pp','2015-04-28','$1&nbsp;=&nbsp;1&nbsp;Points','A','','','','0000-00-00'),(22,114,14,14,'TEST-04/20/2016 03:49:02','cc','2016-04-21','$1&nbsp;=&nbsp;1&nbsp;Points','A','','','','0000-00-00'),(23,168,1,1,'2Y557157UA0802050','pp','2016-05-03','$1&nbsp;=&nbsp;1&nbsp;Points','A','','','','0000-00-00'),(24,201,19,19,'56839209G85638804','pp','2016-05-03','$1&nbsp;=&nbsp;1&nbsp;Points','A','','','','0000-00-00'),(25,201,1,1,'','ca','2016-05-05','$1&nbsp;=&nbsp;1&nbsp;Points','A','asd','','123','2016-05-04'),(26,201,1,1,'2E934914XX393113V','pp','2016-05-05','$1&nbsp;=&nbsp;1&nbsp;Points','A','','','','0000-00-00'),(27,164,1,1,'4MJ313622Y3850804','pp','2016-05-06','$1&nbsp;=&nbsp;1&nbsp;Points','A','','','','0000-00-00'),(28,201,1,1,'21Y27874DD486154H','pp','2016-05-07','$1&nbsp;=&nbsp;1&nbsp;Points','A','','','','0000-00-00'),(29,201,1,1,'1RN63039A37525522','pp','2016-05-10','$1&nbsp;=&nbsp;1&nbsp;Points','A','','','','0000-00-00'),(30,201,1,1,'01736609LT4390014','pp','2016-05-10','$1&nbsp;=&nbsp;1&nbsp;Points','A','','','','0000-00-00'),(31,201,1,1,'5B3693672S168332E','pp','2016-05-10','$1&nbsp;=&nbsp;1&nbsp;Points','A','','','','0000-00-00'),(32,201,1,1,'6VD29506WV752883L','pp','2016-05-10','$1&nbsp;=&nbsp;1&nbsp;Points','A','','','','0000-00-00');

--
-- Table structure for table `es_escrowrangefee`
--

CREATE TABLE `es_escrowrangefee` (
  `nLId` int(11) NOT NULL AUTO_INCREMENT,
  `nFrom` double NOT NULL DEFAULT '0',
  `nTo` double NOT NULL DEFAULT '0',
  `above` bigint(20) NOT NULL,
  `nPrice` double NOT NULL DEFAULT '0',
  `vActive` enum('0','1') NOT NULL DEFAULT '0',
  `nLPosition` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`nLId`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_escrowrangefee`
--

INSERT INTO `es_escrowrangefee` VALUES (25,0,0,13,12,'1',2),(23,0,12,0,22,'1',1),(24,12.01,13,0,11,'1',3);

--
-- Table structure for table `es_faq`
--

CREATE TABLE `es_faq` (
  `nFId` int(11) NOT NULL AUTO_INCREMENT,
  `nPosition` int(11) DEFAULT '0',
  `vActive` enum('0','1') DEFAULT '0',
  PRIMARY KEY (`nFId`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_faq`
--

INSERT INTO `es_faq` VALUES (1,2,'1'),(2,4,'1'),(3,3,'1'),(4,0,'1'),(5,1,'1'),(6,5,'1');

--
-- Table structure for table `es_faq_lang`
--

CREATE TABLE `es_faq_lang` (
  `faq_lang_id` int(11) NOT NULL AUTO_INCREMENT,
  `faq_id` int(11) NOT NULL COMMENT 'faq id',
  `lang_id` int(11) NOT NULL COMMENT 'language id',
  `vTitle` varchar(255) NOT NULL COMMENT 'question',
  `vDes` text COMMENT 'answer',
  PRIMARY KEY (`faq_lang_id`)
) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `es_faq_lang`
--

INSERT INTO `es_faq_lang` VALUES (1,1,1,'What is this site about?','This site is an online exchange service where you can access details about unwanted or surplus items and view requests for wanted goods. Its main aim is to help you to get rid of your unwanted items or enable you to find goods that others no longer need at no cost.\r\n\r\nThis site is a complete swap site that allows you to swap items with, or sell items to, other internet users. It allows you to search or browse for specific items offered for swap or sale. You can swap any unwanted items from your home or business to others who may have use for them. You can also post for items you wish.\r\n\r\nSearch/browse through the extensive list of categories, find items that may be useful for you, make offers, wait for the other party to respond by accepting or rejecting your offer, add comments, swap and enjoy!\r\n\r\nThus with the minimum effort, you can swap, sell or buy stuff from other people via the internet.\r\n'),(2,2,1,'Why use this site?','You may have items which you may no longer need, wasting your household space and things you might be thinking of how to get rid of. Why throw to the recycle bin, there may be somebody who is in need of it very badly. This site is useful for swapping stuff you don\'t want, or simply sell it to someone who does want it!\r\n\r\nYou are not committed to anything until both you and a second party (ie the other swapper/buyer) agree to proceed with the deal - you can withdraw an item at any time right up to this point without obligation or commitment.\r\n\r\nWhy Register with this site?\r\n\r\nIn order to sell and leave postings we need you to complete the short registration form. The information collected by this site will solely be used for activities that accommodate the swapping, bartering or sale of items between users of the site.\r\n\r\nWhilst you can search and browse without registering, if you want to swap, buy or sell, you will need to register.'),(3,3,1,'How do I create a listing?','In order to create a listing, you must first be a registered user. After you register and log in, you will notice Add Sale/ Add Swap/ Add Wish links in the \'My Booth\' section. Click on the appropriate link and enter all the information to create your listing.\r\n\r\n\r\n\r\nWhat types of files can I upload as an image for my listing?\r\n\r\nWe recommend uploading a gif or a jpeg when posting a picture. These file types are usually small and will work with our system quite well.\r\n\r\n\r\nDo I have any obligations?\r\n\r\nYour obligations are set out in the site\'s Terms and Conditions which you have read as part of your registration.\r\n\r\nIn brief, the items offered must be legal and non-offensive to even a small number of people, and must be your property to offer.\r\n\r\nYou have no obligation to complete a swap or sale unless both you and another party have confirmed you want to go ahead with the deal, at which point you both MUST proceed. Otherwise, you can withdraw from a deal at any time up to this point.\r\n'),(4,4,1,'HGow can I contact a user about an item I\'m interested in?','In order to contact a user about an item, you must first be a registered user. After you register and log in, select the item you are interested in and click on it. You will then notice a link in the listing that says \"Make Offer\" Click on this link, enter the details of your offer and the comments/message to the user. Please note that making an offer is the first step to go ahead with the deal.'),(5,5,1,'What happens when a swap/sale is confirmed?','When both the parties confirm for the swap/sale this site gives you away the contact details of the other party, and the deal should be handled (ship goods, verify etc) external to the system.'),(6,6,1,'What is your policy on spam?','We are proud to have a strict policy against unsolicited bulk e-mail and against sharing e-mail addresses with third parties. \r\n'),(27,6,5,'¿Cuál es su política sobre spam? ','Estamos orgullosos de tener una política estricta contra masivo no solicitado de correo electrónico y en contra de compartir direcciones de correo electrónico con terceros.\r\n'),(26,6,2,'Quelle est votre politique en matière de spam? ','Nous sommes fiers d\'avoir une politique stricte contre courrier électronique non sollicité en vrac et contre le partage adresses e-mail à des tiers.\r\n'),(34,4,6,'Wie kann ich mich wenden, einen Benutzer zu einem Artikel die ich mich interessiere? ','Um einen Benutzer zu einem Artikel wenden, müssen Sie zunächst ein registrierter Benutzer sein. Nach der Registrierung und Log-in, wählen Sie das Element, das Sie sich interessieren, und klicken Sie darauf. Sie werden dann feststellen einen Link in der Liste, die \"Make-Angebot\" Klicken Sie auf diesen Link, geben Sie die Details Ihres Angebotes und die Kommentare / Nachricht an den Benutzer sagt. Bitte beachten Sie, dass Sie ein Angebot ist der erste Schritt zur Weiterarbeit an den Deal.\r\n'),(35,3,2,'Comment puis-je créer une annonce? ','\"Afin de créer une liste, vous devez d\'abord être un utilisateur enregistré. Après vous être enregistré et connecté, vous verrez Ajouter vente / Ajouter Swap / Ajouter souhaits des liens dans la section« Mon Booth ». Cliquez sur le lien approprié et entrez toutes les informations pour créer votre annonce.\r\n\r\n\r\n\r\nQuels types de fichiers puis-je télécharger une image pour que mon annonce?\r\n\r\nNous vous recommandons de télécharger une GIF ou JPEG lors de la publication d\'une image. Ces types de fichiers sont généralement de petite taille et il travaillera avec notre système assez bien.\r\n\r\n\r\nAi-je des obligations?\r\n\r\nVos obligations sont énoncées dans les modalités du site et les conditions que vous avez lu dans le cadre de votre inscription.\r\n\r\nEn bref, les articles proposés doivent être légaux et non offensive, même pour un petit nombre de personnes, et doit être votre propriété à vous offrir.\r\n\r\nVous n\'avez aucune obligation de remplir un swap ou vente, sauf si vous et une autre partie ont confirmé que vous voulez aller de l\'avant avec la transaction, à quel point vous les deux doivent procéder. Sinon, vous pouvez retirer d\'un accord à tout moment jusqu\'à ce point.\"\r\n'),(33,4,5,'¿Cómo puedo contactar a un usuario sobre un tema que me interesa? ','Con el fin de contactar a un usuario sobre un elemento, primero debe ser un usuario registrado. Después de registrarse y conectarse, seleccione el elemento que está interesado y haga clic en él. A continuación, se dará cuenta de un enlace en la lista que dice: \"Hacer oferta\" Haga clic en este enlace, entrar en los detalles de su oferta y los comentarios de los / mensaje al usuario. Tenga en cuenta que hacer una oferta es el primer paso para seguir adelante con el acuerdo.\r\n'),(28,6,6,'Was ist Ihre Politik auf Spam? ','Wir sind stolz darauf, eine strikte Politik gegen unerwünschte Massen-E-Mail und gegen Freigabe-E-Mail-Adressen mit Dritten haben.\r\n'),(29,5,2,'Qu\'est-ce qui se passe quand un échange / vente est confirmée? ','Lorsque les deux parties confirment pour le swap / vente sur ce site vous donne de suite les coordonnées de l\'autre partie, et l\'affaire devrait être traitée (expédier des marchandises, vérifier etc) extérieurs au système.\r\n'),(30,5,5,'¿Qué sucede cuando un canje / venta está confirmada? ','Cuando ambas partes confirman para el canje / venta este sitio usted regala los datos de contacto de la otra parte, y el acuerdo debe ser manejado (envío de mercancías, verificar, etc) fuera del sistema.\r\n'),(31,5,6,'Was passiert, wenn eine Swap / Verkauf bestätigt wurde? ','Wenn beide Parteien für die swap / Verkauf bestätigen diese Seite erhalten Sie weg die Kontaktdaten der anderen Partei, und der Deal verarbeitet werden (Schiff Güter, überprüfen usw.) außerhalb des Systems werden.\r\n'),(32,4,2,'Comment puis-je contacter un utilisateur sur un élément que je suis intéressé? ','Pour contacter un utilisateur sur un élément, vous devez d\'abord être un utilisateur enregistré. Après votre inscription et vous connecter, sélectionnez l\'élément que vous intéresse et cliquez dessus. Vous remarquerez alors un lien dans la liste qui dit: \"Faire une offre« Cliquez sur ce lien, entrez les détails de votre offre et les commentaires / message à l\'utilisateur. S\'il vous plaît noter que de faire une offre est la première étape pour aller de l\'avant avec la transaction.\r\n'),(36,3,5,'¿Cómo puedo crear una lista? ','\"Con el fin de crear una lista, primero debe ser un usuario registrado. Después de registrarse y entrar, te darás cuenta de Añadir Venta / Intercambio Añadir / Agregar deseo enlaces en la sección\"\" Mi Booth. Haga clic en el enlace correspondiente e introduzca toda la información para crear su anuncio.\r\n\r\n\r\n\r\n¿Qué tipos de archivos puedo subir como una imagen de mi empresa?\r\n\r\nLe recomendamos cargar un gif o jpeg uno al publicar una foto. Estos tipos de archivos suelen ser pequeños y trabajar con nuestro sistema bastante bien.\r\n\r\n\r\n¿Tengo alguna obligación?\r\n\r\nSus obligaciones se establecen en los Términos y Condiciones del sitio que usted ha leído como parte de su registro.\r\n\r\nEn resumen, los artículos que se ofrecen deben ser legales y no ofensivo incluso a un pequeño número de personas, y debe ser de su propiedad para ofrecer.\r\n\r\nUsted no tiene obligación de completar un canje o venta, a menos que tanto usted y otra parte han confirmado que desea seguir adelante con la oferta, momento en el que ambos deben continuar. De lo contrario, usted puede retirar de un acuerdo en cualquier momento, hasta el momento.\"\r\n'),(37,3,6,'Wie erstelle ich eine Liste? ','\"Um eine Liste zu erstellen, müssen Sie zunächst ein registrierter Benutzer sein. Nach der Registrierung und Log-in, werden Sie feststellen, Add Verkauf / Add Swap / hinzufügen möchten Links in\"\" Mein Booth \'Abschnitt. Klicken Sie auf den entsprechenden Link und geben Sie alle Informationen, um Ihren Eintrag zu erstellen.\r\n\r\n\r\n\r\nWelche Arten von Dateien kann ich als ein Bild für meinen Eintrag hochladen?\r\n\r\nWir empfehlen das Hochladen eines GIF-oder JPEG, wenn Ihr einen Bild. Diese Dateitypen sind meist klein und werden mit unserem System ganz gut zu funktionieren.\r\n\r\n\r\nHabe ich irgendwelche Verpflichtungen?\r\n\r\nIhre Verpflichtungen sind in den Allgemeinen Geschäftsbedingungen, die Sie im Rahmen Ihrer Registrierung lesen gesetzt haben.\r\n\r\nKurz gesagt, müssen die angebotenen Artikel werden rechtliche und nicht-Offensive, um eine kleine Zahl von Menschen auch, und müssen Ihre Immobilie anbieten zu können.\r\n\r\nSie haben keine Verpflichtung, eine Swap-oder Verkauf vollständig, wenn Sie und eine andere Partei bestätigt haben möchten gehen Sie vor mit dem beschäftigen, an welcher Stelle Sie beide zu verfahren. Andernfalls können Sie aus einem Deal jederzeit bis zu diesem Zeitpunkt zurücktreten.\"\r\n'),(38,2,2,'Pourquoi utiliser ce site? ','\"Vous pouvez avoir des éléments qui vous n\'avez plus besoin, de gaspiller votre espace domestique et les choses que vous pourriez penser de la façon de s\'en débarrasser. Pourquoi jeter à la corbeille, il peut y avoir quelqu\'un qui a besoin d\'elle très mal. Cette site est utile pour échanger trucs que vous ne voulez pas, ou simplement le vendre à quelqu\'un qui ne le souhaitez!\r\n\r\nVous n\'êtes pas engagé à rien jusqu\'à ce que vous et une deuxième partie (ie la swapper d\'autres / acheteur) d\'accord pour procéder à la transaction - vous pouvez retirer un élément, à tout moment jusqu\'à ce point sans obligation ni engagement.\r\n\r\nPourquoi s\'inscrire sur ce site?\r\n\r\nDans le but de vendre et de laisser affichages nous avons besoin que vous pour compléter le court formulaire d\'inscription. Les informations collectées par ce site sera uniquement utilisé pour des activités qui peuvent accueillir l\'échange, le troc ou la vente d\'articles entre les utilisateurs du site.\r\n\r\nTandis que vous pouvez rechercher et de naviguer sans enregistrement, si vous voulez échanger, acheter ou vendre, vous devez vous inscrire.\"\r\n'),(39,2,5,'¿Por qué usar este sitio? ','\"Es posible que haya artículos que usted ya no necesita, perdiendo el espacio del hogar y las cosas que estar pensando en cómo deshacerse de él. ¿Por qué tirar a la papelera de reciclaje, puede haber alguien que está en la necesidad de que muy mal. Este el sitio es útil para el intercambio de cosas que no quieren, o simplemente lo venden a alguien que no quiere que lo!\r\n\r\nUsted no se ha comprometido a nada hasta que usted y una segunda parte (es decir, el intercambiador otros / comprador) están de acuerdo para proceder con la operación - que puede retirar un elemento en cualquier momento, hasta este momento sin ninguna obligación o compromiso.\r\n\r\n¿Por qué registrarse en este sitio?\r\n\r\nCon el fin de vender y salir de anuncios es necesario que usted complete el formulario de registro. La información recogida por este sitio se utiliza exclusivamente para las actividades que se adaptan a la memoria de intercambio, trueque o venta de artículos entre los usuarios del sitio.\r\n\r\nMientras que usted puede buscar y navegar sin necesidad de registrarse, si usted quiere intercambiar, comprar o vender, usted tendrá que registrarse. \"\r\n'),(40,2,6,'Warum nutzen Sie diese Seite? ','\"Möglicherweise haben Sie Artikel, die Sie nicht mehr benötigen, verschwenden Sie Ihr Haushalt Raum und Dinge, die Sie, wie man loswerden sein könnten denken. Warum in den Papierkorb zu werfen, es kann jemand sein, braucht es sehr schlecht sein. Diese Ort ist nützlich für das Swap-stuff Sie nicht wollen, oder einfach nur verkaufen sie an jemanden, der will es nicht!\r\n\r\nSie sind zu nichts, bis Sie und eine zweite Partei (dh den anderen swapper / Käufer) stimmen zu, das Geschäft weiter engagiert - Sie können ein Objekt jederzeit bis zu diesem Zeitpunkt zurücktreten freibleibend und unverbindlich.\r\n\r\nWarum mit dieser Website registrieren?\r\n\r\nUm zu verkaufen, und verlassen Postings wir brauchen Sie, um die kurze Formular ausfüllen. Die Informationen auf dieser Website erhobenen Daten werden ausschließlich für Tätigkeiten, die tauschen, Tauschhandel oder Verkauf von Artikeln zwischen den Benutzern der Seite unterzubringen verwendet werden.\r\n\r\nWährend Sie suchen können, auch ohne Registrierung durchsuchen, wenn Sie zu tauschen, kaufen oder verkaufen wollen, müssen Sie sich registrieren.\"\r\n'),(41,1,2,'Quel est ce site? ','\"Ce site est un service d\'échange en ligne où vous pouvez accéder à des détails sur les éléments indésirables ou excédentaires et de visualiser les demandes de biens voulait. Son objectif principal est de vous aider à vous débarrasser de vos articles non désirés ou vous permettre de trouver des produits que les autres n\'ont plus besoin sans frais.\r\n\r\nCe site est un site de swap complet qui vous permet d\'échanger des objets avec, ou vendre des articles d\', d\'autres internautes. Il vous permet de rechercher ou parcourir des articles spécifiques offerts pour échanger ou vendre. Vous pouvez échanger tous les éléments indésirables de votre maison ou votre entreprise à d\'autres qui peuvent avoir besoin d\'eux. Vous pouvez aussi poster des articles que vous souhaitez.\r\n\r\nRecherche / parcourir la longue liste de catégories, trouver des articles qui peuvent être utiles pour vous, faire des offres, attendre que l\'autre partie à répondre en acceptant ou en rejetant votre offre, ajouter des commentaires, échanger et apprécier!\r\n\r\nAinsi, avec le minimum d\'effort, vous pouvez échanger, vendre ou acheter des trucs d\'autres personnes via Internet.\"\r\n'),(42,1,5,'¿Qué es este sitio? ','\"Este sitio es un servicio de intercambio en línea donde se puede acceder a detalles de los elementos no deseados o excedentes y ver las solicitudes de bienes quería. Su principal objetivo es ayudar a deshacerse de sus artículos no deseados o le permiten encontrar los productos que otros ya no necesitan sin costo alguno.\r\n\r\nEste sitio es un sitio de intercambio completa que le permite cambiar los productos con o vender artículos a los usuarios de internet. Te permite realizar búsquedas o navegar por artículos específicos que se ofrecen para el canje o venta. Usted puede cambiar cualquier elemento no deseado de su casa o negocio a otros que pueden hacer uso de ellos. También puedes publicar los artículos que desean.\r\n\r\nBuscar / navegar a través de la extensa lista de categorías, encontrar los artículos que pueden ser de utilidad para usted, hacer ofertas, esperar a que la otra parte para responder aceptando o rechazando su oferta, agregar comentarios, intercambiar y disfrutar!\r\n\r\nAsí, con el mínimo esfuerzo, puede intercambiar, vender o comprar cosas de otras personas a través de Internet.\"\r\n'),(43,1,6,'Was ist auf dieser Site? ','\"Diese Website ist ein Online-Austausch-Service, wo Sie Informationen über unerwünschte oder überschüssige Produkte zugreifen können und Anträge auf Bereitstellung wollte Waren. Sein Hauptziel ist, Ihnen zu helfen loszuwerden Ihrer unerwünschte Elemente oder aktivieren Sie die Waren finden, die andere nicht mehr benötigen ohne Kosten.\r\n\r\nDiese Website ist eine komplette Swap Website, die Sie auf Elemente mit swap, oder Gegenstände verkaufen, um andere Internet-Nutzer ermöglicht. Es ermöglicht Ihnen die Suche oder für bestimmte Gegenstände für Swap-oder Verkauf angeboten zu durchsuchen. Sie können alle unerwünschten Elemente aus Ihrem Haus oder Geschäft an andere, die für sie haben können Verwendung zu tauschen. Sie können auch für Artikel, die Sie wünschen Post.\r\n\r\nSearch / browse durch die umfangreiche Liste der Kategorien, finden Gegenstände, die Ihnen nützlich sein können Angebote machen, warten, bis die andere Partei durch die Annahme oder Ablehnung Ihres Angebots reagieren, Kommentare hinzufügen, tauschen und genießen!\r\n\r\nSo mit einem minimalen Aufwand, können Sie tauschen, kaufen oder verkaufen Zeug von anderen Menschen über das Internet.\"\r\n'),(44,5,8,'Was passiert, wenn eine Swap / Verkauf bestätigt wurde? ','Wenn beide Parteien für die swap / Verkauf bestätigen diese Seite erhalten Sie weg die Kontaktdaten der anderen Partei, und der Deal verarbeitet werden (Schiff Güter, überprüfen usw.) außerhalb des Systems werden.\r\n');

--
-- Table structure for table `es_gallery`
--

CREATE TABLE `es_gallery` (
  `nId` int(11) NOT NULL AUTO_INCREMENT,
  `nUserId` int(11) DEFAULT '0',
  `nSwapId` int(11) DEFAULT '0',
  `nSaleId` int(11) DEFAULT '0',
  `vImg` varchar(200) DEFAULT NULL,
  `vDes` text,
  `nTempId` int(11) DEFAULT '0',
  `vSmlImg` varchar(200) DEFAULT NULL,
  `vMedImg` varchar(200) DEFAULT NULL,
  `vDelStatus` enum('0','1') DEFAULT '0',
  PRIMARY KEY (`nId`)
) ENGINE=MyISAM AUTO_INCREMENT=162 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_gallery`
--

INSERT INTO `es_gallery` VALUES (1,1,0,102,'pics/1_1343805572_mens-1.jpg','Mango',0,'pics/1_1343805572_mens-1_thumb.jpg',NULL,'0'),(2,2,0,3,'pics/2_1275894615_apple4.jpg','Apple2',2,'pics/2_1275894615_apple4_thumb.jpg',NULL,'0'),(3,2,3,0,'pics/2_1275894670_daisy3.jpg','Daisy 2',2,'pics/2_1275894670_daisy3_thumb.jpg',NULL,'0'),(4,2,3,0,'pics/2_1275894670_daisy.jpg','Daisy 1',2,'pics/2_1275894670_daisy_thumb.jpg',NULL,'0'),(5,2,5,0,'pics/2_1275895507_5_11_1186032925_1.jpg','FROM Arun',2,'pics/2_1275895507_5_11_1186032925_1_thumb.jpg',NULL,'0'),(6,1,7,102,'pics/5_1279185622.jpg','Lotus 2',0,'pics/5_1279185622_thumb.jpg',NULL,'0'),(7,2,9,0,'pics/2_1275996766_scene.jpg','From Arun 2',2,'pics/2_1275996766_scene_thumb.jpg',NULL,'0'),(8,28,0,17,'pics/28_1309754857_front-bag-left.jpg','',28,'',NULL,'0'),(9,28,38,17,'pics/28_1309755271_roses-633.jpg','',28,'',NULL,'0'),(10,21,0,20,'pics/21_1311949908_computer-0c6.jpg','Lorem ipsum dolor sit amet, consectetur adipiscing elit. For second image.',0,'pics/21_1311949908_computer-0c6_thumb.jpg',NULL,'0'),(11,21,0,20,'pics/21_1311949908_computer-8mj4.jpg','Lorem ipsum dolor sit amet, consectetur adipiscing elit. For third image.',0,'pics/21_1311949908_computer-8mj4_thumb.jpg',NULL,'0'),(12,21,0,21,'pics/21_1313991312_mp3play.jpg','1',0,'pics/21_1313991312_mp3play_thumb.jpg',NULL,'0'),(13,21,0,21,'pics/21_1313991313_Palm-USA-Mobile-Products-for-Consumers-Professionals-and-Businesses.jpg','2',0,'pics/21_1313991313_Palm-USA-Mobile-Products-for-Consumers-Professionals-and-Businesses_thumb.jpg',NULL,'0'),(14,21,0,0,'pics/21_1313992818_computer-0c6.jpg','1212',0,'pics/21_1313992818_computer-0c6_thumb.jpg',NULL,'0'),(15,21,0,0,'pics/21_1313992818_mp3play.jpg','121',0,'pics/21_1313992818_mp3play_thumb.jpg',NULL,'0'),(16,21,0,0,'pics/21_1313993469_computer-0c6.jpg','2',0,'pics/21_1313993469_computer-0c6_thumb.jpg',NULL,'0'),(17,21,0,0,'pics/21_1313993469_computer-8mj4.jpg','3',0,'pics/21_1313993469_computer-8mj4_thumb.jpg',NULL,'0'),(18,21,0,0,'pics/21_1313993587_car1.jpg','2',0,'pics/21_1313993587_car1_thumb.jpg',NULL,'0'),(19,21,0,0,'pics/21_1313993587_productsmall.jpg','3',0,'pics/21_1313993587_productsmall_thumb.jpg',NULL,'0'),(20,21,0,54,'pics/21_1313994262_car2.jpg','2',0,'pics/21_1313994262_car2_thumb.jpg',NULL,'0'),(21,21,0,54,'pics/21_1313994262_productsmall.jpg','3',0,'pics/21_1313994262_productsmall_thumb.jpg',NULL,'0'),(22,37,0,63,'pics/37_1317285626_logo_thumb.jpg','22222222222',0,'pics/37_1317285626_logo_thumb_thumb.jpg',NULL,'0'),(23,37,0,61,'pics/37_1323845319_example1.jpg','',0,'pics/37_1323845319_example1_thumb.jpg',NULL,'0'),(24,37,0,72,'pics/37_1323843936_lightning4.jpg','ffs',0,'pics/37_1323843936_lightning4_thumb.jpg',NULL,'0'),(25,37,0,72,'pics/37_1323843936_lightning4.jpg','fdsfsdf',0,'pics/37_1323843936_lightning4_thumb.jpg',NULL,'0'),(26,37,0,61,'pics/37_1323845367_light.jpg','',0,'pics/37_1323845367_light_thumb.jpg',NULL,'0'),(27,1,0,83,'pics/1_1343804338_kids-2.jpg','',0,'pics/1_1343804338_kids-2_thumb.jpg',NULL,'0'),(28,1,0,83,'pics/1_1343804338_kids.jpg','',0,'pics/1_1343804338_kids_thumb.jpg',NULL,'0'),(29,1,0,1,'pics/1_1343805494_pepsi.jpg','',0,'pics/1_1343805494_pepsi_thumb.jpg',NULL,'0'),(30,1,0,1,'pics/1_1343805494_wine.jpg','',0,'pics/1_1343805494_wine_thumb.jpg',NULL,'0'),(31,1,0,5,'pics/1_1343805651_Chrysanthemum.jpg','',0,'',NULL,'0'),(32,1,0,5,'pics/1_1343805652_Hydrangeas.jpg','',0,'',NULL,'0'),(33,1,0,7,'pics/1_1343805702_Chrysanthemum.jpg','',0,'',NULL,'0'),(34,1,0,7,'pics/1_1343805703_Hydrangeas.jpg','',0,'',NULL,'0'),(35,1,0,7,'pics/1_1343805929_Chrysanthemum.jpg','',0,'',NULL,'0'),(36,1,0,7,'pics/1_1343805930_Hydrangeas.jpg','',0,'',NULL,'0'),(39,1,0,4,'pics/1_1343809794_Hydrangeas.jpg','',0,'pics/1_1343809794_Hydrangeas_thumb.jpg',NULL,'0'),(40,1,0,4,'pics/1_1343809794_Tulips.jpg','',0,'pics/1_1343809794_Tulips_thumb.jpg',NULL,'0'),(41,1,0,84,'pics/1_1343810235_ebook.jpg','',0,'pics/1_1343810235_ebook_thumb.jpg',NULL,'0'),(42,1,0,84,'pics/1_1343810235_google.gif','',0,'pics/1_1343810235_google_thumb.jpg',NULL,'0'),(43,91,0,98,'pics/91_1364286545_Desert.jpg.jpg','Desert',0,'pics/91_1364286545_Desert.jpg_thumb.jpg',NULL,'0'),(44,91,0,98,'pics/91_1364286546_Hydrangeas.jpg.jpg','Hydrangeas',0,'pics/91_1364286546_Hydrangeas.jpg_thumb.jpg',NULL,'0'),(45,91,16,0,'pics/91_1364286764_playing-for-pizza.jpg.jpg','Playing for pizzas',0,'pics/91_1364286764_playing-for-pizza.jpg_thumb.jpg',NULL,'0'),(46,104,0,116,'pics/104_1384514578_Blue-Two-Tone-Mug.jpg.jpg','this is a blue mug',0,'',NULL,'0'),(47,12,0,106,'pics/large_12_14287507082.jpg','Side view',0,'pics/small_12_14287507082.jpg',NULL,'0'),(48,12,0,106,'','Rear view',0,'',NULL,'0'),(97,120,0,122,'pics/large_120_1430310031D80_16327.jpg','',0,'pics/small_120_1430310031D80_16327.jpg',NULL,'0'),(49,12,0,106,'','',0,'',NULL,'0'),(59,111,0,108,'pics/large_111_1428669939DSC07813-Edit-2.jpg','',0,'pics/small_111_1428669939DSC07813-Edit-2.jpg',NULL,'0'),(50,111,0,107,'pics/107_1428581036.jpg','123',0,'pics/107_1428581036_thumb.jpg',NULL,'1'),(51,111,0,107,'','456',0,'',NULL,'1'),(52,111,0,109,'','',0,'',NULL,'0'),(53,111,0,100,'pics/large_111_1428662222bg_moon_1440x900.jpg','',0,'pics/small_111_1428662222bg_moon_1440x900.jpg',NULL,'0'),(54,111,0,108,'pics/large_111_1428664337bg_mon_1440x900123.jpg','123',0,'pics/small_111_1428664337bg_mon_1440x900123.jpg',NULL,'0'),(55,111,0,108,'pics/large_111_1428669974DSC00803_Long_Exposure_Supermoon_Over_San_Francisco_Bay.jpg','456',0,'pics/small_111_1428669974DSC00803_Long_Exposure_Supermoon_Over_San_Francisco_Bay.jpg',NULL,'0'),(56,111,0,108,'pics/108_1428671033_84.jpg','789',0,'pics/108_1428671033_84_thumb.jpg',NULL,'0'),(58,111,0,110,'pics/large_111_14286663285.jpg','fgdfgdg',0,'pics/small_111_14286663285.jpg',NULL,'0'),(57,111,0,110,'pics/large_111_14286663034.jpg','dfgdfg',0,'pics/small_111_14286663034.jpg',NULL,'0'),(60,111,0,108,'','gdfgdfgdf',0,'',NULL,'0'),(63,111,0,111,'pics/large_111_142874367213_-_1.jpg','Madrass Mail',0,'pics/small_111_142874367213_-_1.jpg',NULL,'0'),(61,111,0,108,'','78522',0,'',NULL,'0'),(62,111,0,111,'pics/111_1428744480_55.jpg','ghghfghfghgfh',0,'pics/111_1428744480_55_thumb.jpg',NULL,'0'),(64,111,0,111,'pics/large_111_1428743694133.jpg','Alone',0,'pics/small_111_1428743694133.jpg',NULL,'0'),(65,111,0,111,'pics/large_111_1428743717bg_afternoon_1440x900.jpg','Red Balloon',0,'pics/small_111_1428743717bg_afternoon_1440x900.jpg',NULL,'0'),(66,111,0,111,'pics/large_111_1428743738bg_fri_1440x900.jpg','Kadal',0,'pics/small_111_1428743738bg_fri_1440x900.jpg',NULL,'0'),(67,111,0,111,'pics/large_111_1428743768bg_fri_1440x9001.jpg','Mountains',0,'pics/small_111_1428743768bg_fri_1440x9001.jpg',NULL,'0'),(68,111,0,111,'pics/large_111_1428743787bg_jupiter_1440x900.jpg','Thira',0,'pics/small_111_1428743787bg_jupiter_1440x900.jpg',NULL,'0'),(69,111,0,111,'pics/large_111_1428743810bg_mars_1440x900.jpg','Shukran',0,'pics/small_111_1428743810bg_mars_1440x900.jpg',NULL,'0'),(70,111,0,111,'pics/large_111_1428743831bg_mercury_1440x900.jpg','Saturday',0,'pics/small_111_1428743831bg_mercury_1440x900.jpg',NULL,'0'),(91,111,0,113,'pics/113_1428752472_82.jpg','sdfgsdf',0,'pics/113_1428752472_82_thumb.jpg',NULL,'0'),(90,111,0,113,'pics/113_1428752443_55.jpg','gsdfgsdfg',0,'pics/113_1428752443_55_thumb.jpg',NULL,'0'),(89,111,0,113,'pics/large_111_142875226813_-_1.jpg','123',0,'pics/small_111_142875226813_-_1.jpg',NULL,'0'),(88,111,0,112,'','',0,'',NULL,'0'),(87,111,0,112,'','',0,'',NULL,'0'),(86,111,0,112,'pics/112_1428751422_16.jpg','',0,'pics/112_1428751422_16_thumb.jpg',NULL,'0'),(92,111,0,113,'pics/113_1428752485_99.jpg','sdfgsdf',0,'pics/113_1428752485_99_thumb.jpg',NULL,'0'),(93,111,0,113,'pics/113_1428752500_29.jpg','gsdfgsdfg',0,'pics/113_1428752500_29_thumb.jpg',NULL,'0'),(94,111,0,113,'pics/113_1428752516_30.jpg','sdfgsdfg',0,'pics/113_1428752516_30_thumb.jpg',NULL,'0'),(95,111,0,113,'pics/113_1428753450_24.jpg','sdfgsdfgsdfgsdfgsdfg',0,'pics/113_1428753450_24_thumb.jpg',NULL,'0'),(98,120,0,122,'pics/large_120_1430310022bg_moon_1440x900.jpg','',0,'pics/small_120_1430310022bg_moon_1440x900.jpg',NULL,'0'),(99,120,0,123,'pics/large_120_1430311853bg_sat_1440x900.jpg','',0,'pics/small_120_1430311853bg_sat_1440x900.jpg',NULL,'0'),(100,120,0,123,'pics/large_120_1430311838bg_wed_1440x9001.jpg','',0,'pics/small_120_1430311838bg_wed_1440x9001.jpg',NULL,'0'),(101,120,0,123,'pics/large_120_1430311824bg_mon_1440x900123.jpg','',0,'pics/small_120_1430311824bg_mon_1440x900123.jpg',NULL,'0'),(102,37,0,70,'','',0,'',NULL,'0'),(103,111,0,131,'pics/large_111_1431506098bg_sat_1440x900.jpg','',0,'pics/small_111_1431506098bg_sat_1440x900.jpg',NULL,'0'),(104,111,0,128,'','asdfasdf',0,'',NULL,'0'),(105,111,0,120,'','',0,'',NULL,'1'),(107,111,0,120,'','',0,'',NULL,'1'),(106,111,0,120,'pics/large_111_1431520454bg_wed_1440x9001.jpg','',0,'pics/small_111_1431520454bg_wed_1440x9001.jpg',NULL,'1'),(108,111,0,130,'pics/large_111_1431690399Chrysanthemum.jpg','zdsgdhb cgfjtyk bvjtyi gfjytiji78',0,'pics/small_111_1431690399Chrysanthemum.jpg',NULL,'0'),(109,139,0,132,'pics/large_139_1435390724alarmclock.jpg','',0,'pics/small_139_1435390724alarmclock.jpg',NULL,'1'),(110,111,0,118,'pics/large_111_1436253034wall1.jpg','fgh',0,'pics/small_111_1436253034wall1.jpg',NULL,'0'),(111,111,0,118,'pics/large_111_1436253054house1.jpg','jkl',0,'pics/small_111_1436253054house1.jpg',NULL,'0'),(112,111,0,118,'pics/large_111_1436253090free-wallpaper-9.jpg','poi',0,'pics/small_111_1436253090free-wallpaper-9.jpg',NULL,'0'),(113,111,0,118,'pics/large_111_1436253117wall.jpg','uyt',0,'pics/small_111_1436253117wall.jpg',NULL,'0'),(114,111,0,118,'pics/large_111_1436253137blossom.jpg','rew',0,'pics/small_111_1436253137blossom.jpg',NULL,'0'),(115,111,0,118,'pics/large_111_1436253161design.jpg','qmn',0,'pics/small_111_1436253161design.jpg',NULL,'0'),(116,111,0,118,'pics/large_111_1436253197des.jpg','bvc',0,'pics/small_111_1436253197des.jpg',NULL,'0'),(117,111,0,146,'pics/large_111_1436257631coffeemugg.jpg','bbbbbb',0,'pics/small_111_1436257631coffeemugg.jpg',NULL,'0'),(118,111,0,146,'pics/large_111_1436261510cup515.jpg','dddddddd',0,'pics/small_111_1436261510cup515.jpg',NULL,'0'),(119,111,0,149,'pics/large_111_1447746233Tulips.jpg','description 1',0,'pics/small_111_1447746233Tulips.jpg',NULL,'0'),(120,111,0,81,'pics/large_111_1447752331Jellyfish.jpg','',0,'pics/small_111_1447752331Jellyfish.jpg',NULL,'0'),(121,111,82,0,'pics/large_111_1447752457Lighthouse.jpg','description 1 ',0,'pics/small_111_1447752457Lighthouse.jpg',NULL,'0'),(122,1,88,0,'pics/large_1_14613248501600x349.jpg','test',0,'pics/small_1_14613248501600x349.jpg','pics/medium_1_14613248501600x349.jpg','0'),(123,1,0,88,'pics/large_1_1461314642inspire-brown-magenta-georgette-kurti.jpg','',0,'pics/small_1_1461314642inspire-brown-magenta-georgette-kurti.jpg','pics/medium_1_1461314642inspire-brown-magenta-georgette-kurti.jpg','0'),(124,1,0,88,'pics/large_1_1461314662680800.jpg','',0,'pics/small_1_1461314662680800.jpg','pics/medium_1_1461314662680800.jpg','0'),(125,1,0,88,'pics/large_1_1461314679readymade-yellow-kurti.jpg','',0,'pics/small_1_1461314679readymade-yellow-kurti.jpg','pics/medium_1_1461314679readymade-yellow-kurti.jpg','0'),(126,1,0,88,'pics/large_1_1461314708linux-logo-300x300.jpg','',0,'pics/small_1_1461314708linux-logo-300x300.jpg','pics/medium_1_1461314708linux-logo-300x300.jpg','0'),(127,1,0,88,'pics/large_1_1461314731nnnxtgzxbv7.jpg','',0,'pics/small_1_1461314731nnnxtgzxbv7.jpg','pics/medium_1_1461314731nnnxtgzxbv7.jpg','0'),(128,1,0,88,'pics/large_1_1461314756mobile.jpg','',0,'pics/small_1_1461314756mobile.jpg','pics/medium_1_1461314756mobile.jpg','0'),(144,1,91,0,'pics/large_1_14615661631200.jpg','',0,'pics/small_1_14615661631200.jpg','pics/medium_1_14615661631200.jpg','0'),(129,1,0,88,'pics/large_1_14613215771200.jpg','',0,'pics/small_1_14613215771200.jpg','pics/medium_1_14613215771200.jpg','0'),(130,1,0,88,'pics/large_1_1461321593fiona-designer-pink-kurti.jpg','',0,'pics/small_1_1461321593fiona-designer-pink-kurti.jpg','pics/medium_1_1461321593fiona-designer-pink-kurti.jpg','0'),(131,1,0,88,'pics/large_1_1461321608inspire-brown-magenta-georgette-kurti.jpg','',0,'pics/small_1_1461321608inspire-brown-magenta-georgette-kurti.jpg','pics/medium_1_1461321608inspire-brown-magenta-georgette-kurti.jpg','0'),(132,1,0,88,'pics/large_1_1461321622linux-logo-300x300.jpg','',0,'pics/small_1_1461321622linux-logo-300x300.jpg','pics/medium_1_1461321622linux-logo-300x300.jpg','0'),(133,1,0,88,'pics/large_1_1461321635readymade-yellow-kurti.jpg','',0,'pics/small_1_1461321635readymade-yellow-kurti.jpg','pics/medium_1_1461321635readymade-yellow-kurti.jpg','0'),(134,1,0,88,'pics/large_1_1461321657nnnxtgzxbv7.jpg','',0,'pics/small_1_1461321657nnnxtgzxbv7.jpg','pics/medium_1_1461321657nnnxtgzxbv7.jpg','0'),(135,1,0,88,'pics/large_1_14613227101024642.jpg','',0,'pics/small_1_14613227101024642.jpg','pics/medium_1_14613227101024642.jpg','0'),(136,1,0,88,'pics/large_1_14613231021200.jpg','',0,'pics/small_1_14613231021200.jpg','pics/medium_1_14613231021200.jpg','0'),(137,1,88,0,'','',0,'','pics/medium_1_14613231021200.jpg','0'),(143,1,89,0,'pics/large_1_1461563057readymade-yellow-kurti.jpg','werwer',0,'pics/small_1_1461563057readymade-yellow-kurti.jpg',NULL,'0'),(138,1,88,0,'pics/large_1_1461323735inspire-brown-magenta-georgette-kurti.jpg','',0,'pics/small_1_1461323735inspire-brown-magenta-georgette-kurti.jpg','pics/medium_1_1461323735inspire-brown-magenta-georgette-kurti.jpg','0'),(139,1,88,0,'','',0,'','pics/medium_1_1461323747400177.jpg','0'),(140,1,88,0,'pics/large_1_1461323760cbm.jpg','',0,'pics/small_1_1461323760cbm.jpg','pics/medium_1_1461323760cbm.jpg','0'),(141,1,88,0,'pics/88_1461327457_22.jpg','',0,'pics/88_1461327457_22_thumb.jpg','pics/medium_1_1461323779linux-logo-300x300.jpg','0'),(142,1,88,0,'','',0,'','pics/medium_1_1461323791CDW-Chopped-Red.gif','0'),(145,1,93,0,'pics/large_1_1461571104linux-logo-300x300.jpg','',0,'pics/small_1_1461571104linux-logo-300x300.jpg','pics/medium_1_1461571104linux-logo-300x300.jpg','0'),(153,111,0,151,'pics/large_111_146182708151-09HuEEaL._SX258_BO1204203200_.jpg','',0,'pics/small_111_146182708151-09HuEEaL._SX258_BO1204203200_.jpg','pics/medium_111_146182687751-09HuEEaL._SX258_BO1204203200_.jpg','0'),(160,164,138,0,'pics/large_164_1486625054bug_shot_1481275112_3.png','rabbit',0,'pics/small_164_1486625054bug_shot_1481275112_3.png','pics/medium_164_1486625054bug_shot_1481275112_3.png','0'),(161,116,143,0,'pics/large_116_14962351143023994_fpx.jpg','VanHussen Branded Shirt',0,'pics/small_116_14962351143023994_fpx.jpg','pics/medium_116_14962351143023994_fpx.jpg','0'),(158,1,0,154,'pics/large_1_1485759365Screenshot_from_2016-11-11_153715.png','',0,'pics/small_1_1485759365Screenshot_from_2016-11-11_153715.png','pics/medium_1_1485758639Screenshot_from_2017-01-25_11-01-00_-_1.png','0'),(154,111,0,151,'pics/large_111_146182709951-09HuEEaL._SX258_BO1204203200_.jpg','',0,'pics/small_111_146182709951-09HuEEaL._SX258_BO1204203200_.jpg','pics/medium_111_146182709951-09HuEEaL._SX258_BO1204203200_.jpg','0'),(155,8,110,0,'pics/110_1461827325_31.jpg','',0,'pics/110_1461827325_31_thumb.jpg',NULL,'0'),(156,8,110,0,'pics/110_1461827325_20.jpg','',0,'pics/110_1461827325_20_thumb.jpg',NULL,'0'),(159,1,0,154,'','',0,'','pics/medium_1_1485758680Screenshot_from_2017-01-25_11-01-02_-_2.png','0'),(157,1,0,158,'pics/large_1_1485757047productbig__0_1469095530breakfast_2.jpg','',0,'pics/small_1_1485757047productbig__0_1469095530breakfast_2.jpg','pics/medium_1_1485756505Screenshot_from_2017-01-25_11-01-00_-_1.png','0');

--
-- Table structure for table `es_help`
--

CREATE TABLE `es_help` (
  `nHId` int(11) NOT NULL AUTO_INCREMENT,
  `nHcId` int(11) DEFAULT NULL,
  `nHposition` int(11) DEFAULT NULL,
  `vActive` enum('0','1') DEFAULT NULL,
  `vHimage` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`nHId`)
) ENGINE=MyISAM AUTO_INCREMENT=91 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_help`
--

INSERT INTO `es_help` VALUES (1,3,3,'1','1229329644_home.gif'),(4,8,21,'1','1229329370_Logging-in.jpg'),(5,10,25,'1','1229329330_Edit-Profile.jpg'),(6,1,7,'1','1229329846_Manage-Feedbacks.jpg'),(7,1,6,'1','1229329835_RegisterEswaps.jpg'),(8,1,8,'1','1229329826_RegisterEswaps.jpg'),(9,1,9,'1','1229329816_RegisterEswaps.jpg'),(10,1,10,'1','1229329805_Manage-Feedbacks.jpg'),(11,1,11,'1','1229329798_Manage-Feedbacks.jpg'),(12,31,33,'1','1229329778_Manage-Feedbacks.jpg'),(13,31,34,'1','1229329768_Manage-Feedbacks.jpg'),(14,31,35,'1','1229329761_Manage-Feedbacks.jpg'),(15,1,12,'1','1229329734_Manage-Feedbacks.jpg'),(16,1,13,'1','1229329723_home.gif'),(17,1,14,'1','1229329709_home.gif'),(18,1,15,'1','1229329703_Manage-Payments.jpg'),(19,1,16,'1','1229329694_Manage-Payments.jpg'),(20,7,18,'1','1229329453_user.gif'),(21,7,19,'1','1229329442_user.gif'),(22,7,20,'1','1229329381_RegisterEswaps.jpg'),(23,6,17,'1','1223893583_1205229057_giftshop.gif'),(24,9,22,'1','1229329351_Manage-Sale.jpg'),(25,9,23,'1','1229329346_Manage-Sale.jpg'),(26,12,26,'1','1229329321_Manage-Swap.jpg'),(27,12,27,'1','1229329315_Manage-Swap.jpg'),(28,13,28,'1','1229329264_Manage-Wish.jpg'),(29,13,29,'1','1229329307_Manage-Wish.jpg'),(30,14,30,'1','1229329215_Manage-Payments.jpg'),(31,14,31,'1','1229329208_Manage-Payments.jpg'),(32,15,32,'1','1229329227_Manage-Feedbacks.jpg'),(33,9,24,'1','1229329340_Manage-Sale.jpg'),(34,20,12,'1','1229328894_How-to-swap.jpg'),(35,20,13,'1','1229328770_features.jpg'),(36,52,14,'1','1229328854_Howtosell.jpg'),(37,21,15,'1','1229328845_Howtoswap.jpg'),(38,21,16,'1','1229328830_How-to-wish.jpg'),(39,19,1,'1','1229329060_RegisterEswaps.jpg'),(40,19,0,'1','1229328919_Logging-in.jpg'),(41,19,3,'1','1229328752_Edit-Profile.jpg'),(42,19,2,'1','1229328997_Manage-Sale.jpg'),(43,52,4,'1','1229329015_Manage-Swap.jpg'),(44,19,5,'1','1229329099_whatis-eswap.jpg'),(45,19,6,'1','1229329029_Manage-Wish.jpg'),(46,19,7,'1','1223896360_1205229057_giftshop.gif'),(47,21,17,'1','1229328965_Manage-Offers.jpg'),(48,19,8,'1','1229329124_Change-delivered-status.jpg'),(49,19,9,'1','1229328976_Manage-Payments.jpg'),(50,52,18,'1','1229328948_Manage-Feedbacks.jpg'),(51,19,10,'1','1223896576_1205229116_blogs.gif'),(52,19,11,'1','1313648095_How-to-wish.jpg'),(53,4,5,'1','1229152858_1223893813_1205229047_eventtickets.gif'),(54,3,4,'1','1229329678_Manage-Feedbacks.jpg'),(55,3,1,'1','1229329605_other.gif'),(56,3,0,'1','1229329598_Manage-Feedbacks.jpg'),(57,3,2,'1','1229158873_1223893813_1205229047_eventtickets.gif'),(59,31,36,'1','1312539214_sales-report.jpg'),(60,31,38,'1','1314092514_sales-report.jpg'),(61,31,37,'1','1277361404_1229329215_point-purchases.jpg'),(62,31,39,'1','1314092497_sales-report.jpg'),(65,35,59,'1',''),(66,35,60,'1',''),(88,20,61,'0','');

--
-- Table structure for table `es_help_lang`
--

CREATE TABLE `es_help_lang` (
  `help_lang_id` int(11) NOT NULL AUTO_INCREMENT,
  `help_id` int(11) NOT NULL COMMENT 'help id',
  `lang_id` int(11) NOT NULL COMMENT 'language id',
  `vHtitle` varchar(100) NOT NULL COMMENT 'help title',
  `vHdescription` text COMMENT 'help text',
  PRIMARY KEY (`help_lang_id`)
) ENGINE=MyISAM AUTO_INCREMENT=177 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `es_help_lang`
--

INSERT INTO `es_help_lang` VALUES (1,1,1,'Home Content','The textual content of the home page could be edited by clicking the Home link under Content Management on the left menu'),(2,4,1,'Logging in','To access the site\'s Swapping Platform Administration area, log in to the screen you view when you access: http://yoursite.com/admin\r\n\r\nJust enter the user name and password. When the credentials match correctly, you can then log in to the website using the Swapping Platform Administration Panel. '),(4,5,1,'Admin Password Settings','To change the Administrator Password, click on. \' Password \' link in the left menu section.\r\n\r\nEnter the old password in the \' Old password \' field. Enter the new password in the \' New Password \' field and confirm it by retyping it in the \' Confirm New Password \' field. Both the passwords should match. Then select the \'change password\' option and the administrator password will be  updated to the newly entered password.\r\n'),(5,6,1,'Change Site Settings','The eSwap Swapping Platform has various system leaf level settings which can control the basic functions of the site. You can control the following settings in this section:\r\n\r\nTo change the site settings- select \'Site Settings\' in the left menu. In the following screen select the parameters you want to change from the list. Then enter your values and select \'Save Changes\'.'),(6,7,1,'Registration Amount','A nominal amount is charged from the user at the time registration with Eswaps .This amount can be set in this section.This parameter will be displayed only when free registration is disabled.To disable free registration select  \"no\" option against the \"Enable free registration?\" at the bottom section of the screen and click on \' Update \'.\r\n'),(7,8,1,'Referral fee for survey','Any user registered with Eswaps can refer their friends to Eswaps. Eswaps will pay a nominal amount for every completed survey by the referred user.This amount can be set in this section.This option is available only when free registration is disabled.'),(8,9,1,'Referral fee for registration','Any user registered with Eswaps can refer their friends to eSwap.Eswaps will pay a nominal amount for every successful registration by referred user .This amount can be set in this section.This option is available only when free registration is disabled.'),(9,10,1,'Administrator Email','You can create an administrator email address in this section,  which you require for communications. \r\n'),(10,11,1,'Fees for listing item as featured','The user can add an item to the sale as a \'Featured\' sale. Then, the item will appear at the top of the listing, bold, and an icon will represent \'Featured\'. A nominal amount is charged from the user for adding his/her item under the featured site. The amount can be set here. '),(11,12,1,' Commission','If the price of the item added by the user for each sale exceeds the commission free limit , a negligible amount is charged from the user. This percentage of commission on the sale price can be set in this section.'),(12,13,1,'Commission free limit','For every additional sale, this site will charge a very negligible commission from the user, based on the quoted price. If the sale is less than the present amount, then no commission will be charged. This amount can be set here. '),(13,14,1,'Escrow Service commission','An escrow service means any payment through  this site, If the buyer chooses escrow service to purchase an item,  this site will charge a very negligible commission from the seller based on the sale price. This  rate of commission can be set set in this section.\r\n'),(14,15,1,'Name of the site','The name of the website can be set in this section. '),(15,16,1,'Site Logo','The Logo image of the website can be set in this section.'),(16,17,1,'Site Style','The appearance of the website can be set in this section.\r\n'),(17,18,1,'Paypal gateway details','You can use PayPal payment gateways for this particular website. Just provide the PayPal email address and identity token. The PayPal identity token can be obtained when you settle the payment data transfer option in the PayPal administration module. Once you are ready to go live, check the box near \'Payment Module Live\'. \r\n\r\nTo disable the PayPal support- just uncheck the box near \'Enable PayPal\'. '),(18,19,1,'Authorize.net gateway details','You can use Authorize.net payment gateways for the payments. Just provide an Authorize.net Log in ID, transaction key, and password. Once you are ready to go live with the Authorize.net, select the check box near the \'Payment Module Live\' link. '),(19,20,1,'Manage Users','To manage users registered with  this site , click on \'  Registered Users  \'  link in the left menu section.The upcoming screen will display all the users registered with  this site .\r\n\r\nTo bar a user,click on the cross icon against the user.To unbar a user click on tick icon against the user.\r\n\r\nTo edit the profile of a user, click on the login name against the user. In the ensuing screen, edit the details and click \' Save Changes \'. To change the password enter new password and click \' Change Password \'.\r\n'),(20,21,1,'User Activation','To activate a user registered with the site, select the \'User Awaiting Activation\' link in the left menu. \r\n\r\nYou can activate the user in two ways:\r\n\r\n1.If you know the user, you can directly activate them when you select the \'Activate\' button\r\n\r\n2. If you want to double check the user\'s credentials, select the \'User Name\'- then \'Activate User\'.\r\n\r\n<b>To Delete the User-</b>\r\n\r\nSelect the user name, and select the \'Delete\' button at the end of the page. Please note that the user activation is required for paid users who registered using payment methods other than a credit card or PayPal. '),(21,22,1,'User Registration','To Add new user to  this site , click on \' Add User  \'  link on the Registered Users screen. In the next screen provide the information about the user and click on \' Register \' '),(22,23,1,'Manage Categories','To manage a category  with  this site , click on \' Categories \' link in the left menu section.The upcoming screen will display all the existing categories\r\n\r\n\r\n<b>To add a New category :</b>\r\nEnter a unique Category Name in the new category name  column at the bottom section and click on \' Add New Category \'. If the category name you entered was unique, the new category is added to the category list.\r\n\r\n\r\n<b>To add a Subcategory:</b>\r\nClick on the particular category under which you intended  to add  subcategory. Enter a unique Sub Category Name in the \' Category name \' column and click on \' Add New Category \'. If the category name you entered was unique, the new subcategory is added to the category list.\r\n\r\n<b>To Edit / Delete a category:</b>\r\nClick the \'Edit \' link against the category . A new screen opens where you can edit the details of the selected category. Click on \' Update category \' to update your changes.\r\nClick on \' Delete Category \'. Before deleting category, please make sure that you have deleted all the sub categories under the category you wish to delete '),(23,24,1,'Manage Sale','To manage the sale added by the user, select the \'Sales\' link in the left menu. In the following screen you will see the sale added from the user. \r\n\r\nTo edit the sale, select the title. In the following screen, edit the details and select \'Update\'.\r\n\r\nTo delete the sale , select \'Delete\' in the current page.\r\n\r\nTo approve the sale, select \'Approve Sale\'. '),(24,25,1,'Approve Sale','All of the purchases must be approved by the site administrator. To approve a sale, select \'Approve Sale\' in the left menu. Then, select the sale near the title row. In the following screen, select \'Approve Sale\' to approve it, and \'Delete\' to delete it. '),(25,26,1,'Manage Swap','To manage swap items added by the user, select the \'Swap\' link in the left menu section. The following screen will show the swapped item. \r\n\r\nTo edit the swap, select the title against the swap item. In the next screen, edit the details and select \'Update\'.\r\n\r\nTo feature the swapped item, select \'Featured\'. \r\n\r\nTo approve a swapped item, select \'Approve Swap\'.'),(26,27,1,'Approve Swap','All of the swapped items within the site must be approved by the administrator. To approve a swap- select \'Approve swap/wish\' in the left menu section. Then, select it against the swap row. In the following screen, select \'Approve Swap\'. If you want to delete a swap, then select \'delete\' instead. '),(27,28,1,'Manage Wish','If the user wishes to own an item, he/she can publish it here.\r\n\r\nTo manage a wish item added by the user, select \'wish\' in the left section. The following screen will show all of the wish items. \r\n\r\nTo edit the wish, select the title near the wish item. In the following screen, edit the details and select \'Update\'. \r\n\r\nTo approve a swapped item, select \'Approve wish\'. '),(28,29,1,'Approve Wish','The site administrator approves the wish process for this site. To approve a wish, just select \'Approve swap/wish\' in the left menu. To approve it, select the title near the wish row. In the following screen, select \'Approve Wish\'. Select \'Delete\' if you want to delete it. '),(29,30,1,'Manage Payments','The user payments with  this site can be viewed and managed from this section.\r\n\r\n\r\n<b>Settle payments</b>\r\n    To  settle payments click on \' Pending settlements \' on the left menu section. All the unsettled payments  can be viewed and manage from this section.To settle payment click on user name against the user you want to settle. In the upcoming screen check the row(s) that you want to settle and provide mode of transaction,reference number and click on \' Settle amount \'.To view transaction details for a selected row click on Item name. A new window will open for you with transaction details such as quantity,mode of transaction etc.Note that payments can be settled only for delivered item. To settle referral payments click on manage referral payments.\r\n\r\n\r\n<b>View Payments</b>\r\n                           To view all the settled payments click on \' Account summary \' on the left menu section. In the ensuing screen click on the user name against the user that you want view payments. All the settled payments for the selected user can be viewed from this section.Payment details such as transaction mode,date etc will be listed in this section. To view more details such as commission,reference number click on \' trans no \' against the transaction details in the current page.\r\n\r\n'),(30,31,1,'Manage Referral Payments','The referral payments with this site can be viewed and managed from this section. \r\n\r\n<b>Referral Details- </b>\r\n\r\nSelect the \'Referrals\' tab in the left menu. The upcoming screen will showcase all of the referral payments. To view the details about the referred user, just select the user name against the referrer. The following screen will display the referral details such as: name, email, registration status etc. \r\n\r\nName- The name of the referred user when he/she registers with the site\r\n\r\nSurvey Status- The user can view their survey status here. To view a complete survey, just select the \'survey status\' tab. \r\n\r\nRegistration Status- The user can view their registration status from here.\r\n\r\n<b>Settle Referral Payments-</b>\r\n\r\nSelect \'Referrals\' in the left menu. The next screen will show all of the referral payments. To settle payments, select the user name near the referrer. The bottom section of the following screen will show the settlement details. Then, check the box near the amount you want to settle and provide a reference number, mode of transaction, and select \'Settle\'. To view settled payments, select \'Settle\' near the user. '),(31,32,1,'Manage Feedback','To manage feedback posted by user, click on \'  Feedbacks  \'  link in the left menu section.The upcoming screen will display all the user feedback with details such as posted user,user(against the feedback posted),feedback title,date.To view feedback in detail click on feedback title against the feedback row.'),(32,33,1,'Approve Item Addition','All of the sale additions to the site must be approved by the site administrator. To approve an item in addition to the site, select \'Approve Additional Item\' in the left menu section. Then, select the item addition near the title row. In the following screen select \'Approve Sale\' to approve the addition and select \'Delete\' to delete it. '),(33,34,1,'How Does the Website Work?','This website is an online swapping service, where members can access details about other members unwanted items. They can also list the items on the actual site, and make requests for items they want instead. The goal of this website is to help our members get rid of their unwanted items and enable them to find goods they need amongst each other at no extra cost.\r\n\r\nOur site is intended for individuals who struggle on what to do with items they no longer have any use for. We have discovered that these items are then thrown out or disregarded for years to come. The old saying \'One Mans Trash, is Another Mans Treasure is what this site lives by. \r\n\r\nOur staff is fully committed to insuring that every user in our community is catered to. In addition our staff is in constant communication with one another sharing new ideas to accommodate you. We hope that you enjoy our site and all of the benefits herein. '),(34,35,1,'Features','The Eswaps Swapping Platform  is rich with a large list of features to make its usability to the maximum and to make your work easy.\r\nThe main features are:\r\n    - No plug-ins / programming\r\n    - Web based administration\r\n    - Complete storefront system\r\n    - Free manual\r\n    - HTML knowledge not required\r\n    - Graphic design skills not required\r\n    - Related products and cross selling\r\n    - Accept real-time credit cards\r\n    - Authorize.net, PayPal or both\r\n    - Browser based email\r\n    - Customers can view order history\r\n    - Fully customizable design\r\n    - Customizable template provided\r\n    - Virtually unlimited main / sub categories\r\n    - Integrated store search\r\n    - Thumbnails and large image views\r\n    - All customer\'s data is stored in database\r\n    - Password-protected admin access'),(35,36,1,'How to sell an item with Eswaps ...','The first member of eSwap adds an item for sale in the sale list after they provide the title, description, rate, price, photo, and shipping charges. \r\n\r\nThe second member who wants to buy and item can select the first member\'s sales listing to receive all of the related info about the product.\r\n\r\nNext, he/she pays for the item they want to buy. The item is removed from the sales list. The buyer now has the option to pay directly to the seller or through eSwap with an escrow fee. If the buyer chooses the escrow fee, the buyer can pay using their credit card, PayPal, and/or Check/Money Order. The money comes from the eSwap account. The first member can see the amount in their section.\r\nWhen you receive the amount in the settlement section, the first user can ship his/her item to the second user. When the confirmation from the second user is complete, the admin selects  the \'Settle Account\' button to clear the pending settlement of the first user. The checks can be delivered bi-monthly after deducting the commission. '),(36,37,1,'How to swap an item with eSwap','The first member adds an item to the swapping list by providing the title, description, rate, photo, and shipping charges.\r\n\r\nThe second member who wants to swap the item can select the first members list and make an offer by providing their item and an amount to swap with. \r\n\r\nThe second member receives a new entry in his/her list.\r\n\r\nThe first member receives a new entry in their list. Now, he/she can view the offer and accept or reject it with a counter offer.\r\n\r\nThe process continues to the point where both members agree for a mutual transfer of goods. The user information of both of the members is shown and they can now proceed with the transfer physically. The posted item is moved to the \'Swapped Items\' list, and it will not be available for swapping any longer. Both of the members have the ability to provide feedback of the other member\'s dealings. All rated members can be banned from further trades by the administrator if necessary. \r\n\r\nThere are no fees required for swap listings. It is open to all registered users. '),(37,38,1,'How to Add an Item to the Wish List','The first member adds the item to the wish list to swap with or purchase it by providing the title, description, rate, and photo.\r\n\r\nThe second member who wishes to swap their item can select the first member\'s listing and make an offer by providing their item for swap and an amount. This will update a new entry in his/her \'My Offers\' section.\r\n\r\nThe first member receives a new entry in his/her list. They can view the offer and accept or reject it. If the first member accepts the offer he/she will be able to pay directly to the seller or through the barter site with an escrow fee. If the buyer chooses an escrow fee, the buyer can now pay using a credit card, PayPal, or check/money order. \r\n\r\nWhen the second member receives the amount, they can ship their item to the first member. When the second member receives the first member\'s confirmation, the admin selects the \'Settle Account\' button to clear the pending settlement of the second member. \r\n'),(38,39,1,'Register with Eswaps','Registering with this site swapping platform is easy and fast. Go to the registration page ( typically at http://yoursite.com/register.php ) assuming that the this site is installed at http://yoursite.com) and provide the required basic information.'),(39,40,1,'Logging in','To access the this site user area, click \' Login \' link in top menu section.\r\nEnter the user name and password. On verifying your credentials correctly, You will be redirected to the main panel. Main panel divides in to seven section .\r\n\r\n\r\n<strong>1.Latest Sale additions</strong>Your  latest sale addition can be viewed and managed from this section.Maximum of  five sale addition will be listed in this section. If you want to manage all your sale addition click on \' more \' icon on bottom right corner.\r\nManage Sale\r\n<strong>2.Latest swap additions</strong>Your  latest swap addition can be viewed and managed from this section.Maximum of  five swap addition will be listed in this section. If you want to manage all your swap additions click on \' more \' icon on bottom right corner.\r\nManage swap\r\n<strong>3.Latest wish additions</strong>Your  latest wish addition can be viewed and managed from this section.Maximum of  five wish addition will be listed in this section. If you want to manage all your wish additions click on \' more \' icon on bottom right corner.\r\nManage wish\r\n<strong>4.My Offers</strong>All <strong>swap/wish</strong> offers you have made so far can be viewed and manage from this section.Maximum of  five offers will be listed in this section. If you want to manage all your swap/wish offers click on \' more \' icon on bottom right corner.\r\nManage offers\r\n<strong>5.Offers For me</strong>All <strong>swap/wish</strong> offers for you can be viewed and managed from this section.Maximum of five offers will be listed in this section. If you want to manage all swap/wish offers for you click on \' more \' icon on bottom right corner.\r\nManage offers\r\n<strong>6.My Sale offers</strong>All <strong>sale</strong> offers you have made so far can be viewed and managed from this section.Maximum of  five sale offers will be listed in this section. If you want to manage all your sale offers click on \' more \' icon on bottom right corner.\r\nManage offers\r\n<strong>7.Sale Offers for me</strong>All <strong>sale</strong> offers for you  can be viewed and managed from this section.Maximum of five offers will be listed in this section. If you want to manage all sale offers for you click on \' more \' icon on bottom right corner.\r\nManage offers'),(40,41,1,'Edit Profile','To edit profile, click on  \' Edit profile  \' link in the left menu section.In the ensuing edit the details and click \' Save Changes \'\r\n\r\n\r\n<b>Change password</b>\r\n    To change the Password, click \' Edit profile \' link in the left menu section.In the ensuing screen enter the old password in the \' Old password \' field.Enter the new password in the \' New Password \' field and confirm it by retyping it in the \' Confirm Password \' field. Both the passwords should match and the  password will get updated to the newly entered password.\r\n'),(41,42,1,'Manage Sale','All of the registered users can add an item for sale.\r\n\r\nAdd an Item for Sale- to add an item for sale with this site, just select the \'Add Sale\' link in the left menu section. The following screen will provide the title, name, price, etc. You can add an item as featured by paying a nominal amount to the site itself. A featured item will show first in the sale listing with a different appearance. You have to pay a very negligible commission on the sale items based on the asking price. If the amount of the sale is less than a preset amount ($100), then no fees are charged. To know more about the sale process, just click here. \'How to Sell with this Site.\'\r\n\r\nEdit Sale Item- to view/edit select the \'My Booth\' on the top menu. Select the \'More\' icon under the latest sale addition section. The upcoming screen will display all of your sale additions. To edit a sale, select the title near the sale row. In the next screen, edit the sale details and select \'Update\' to finalize it. \r\n\r\nTo delete a sale- select \'Delete\'. As a word of caution, please make sure you are deleting the right item since this action is irreversible'),(42,43,1,'Manage Swap','<b>Add an item for Swap-</b>\r\n\r\nTo add an item for swapping, just select the \'Add Swap\' icon on the left menu section. Provide a title, name, price, etc. If you want to know more about the swapping process then just click here. \'How to Swap an Item\'.\r\n\r\n<b>Edit Swap Item-</b>\r\n\r\nTo view/edit an item to swap, just select the \'My Booth\' icon on the top menu section. Then, select the \'More\' icon under the latest swap addition. The next screen will display all of your items to swap. \r\n\r\nTo edit a swap- select the title near the swap item. In the following screen, edit the swap item details and select \'Update\'. \r\n\r\nTo delete a swap- select \'Delete\'. As a word of caution, please make sure you delete the correct items because this action is irreversible. '),(43,44,1,'How to swap an item with eSwap','The first member with this site adds an item for swapping to his swap list by providing the title, description, rate, photo if any and shipping charges.\r\n\r\nThe second member who wish to swap his item can click on the first members listing and make an offer by providing his item for swap and an amount that he feels is a difference of value with the first members posted item.\r\n\r\nThe second member gets a new entry in his my offers list.\r\n\r\nThe first member gets a new entry in his received offers list. He can view the offer and accept it or put a counter offer.\r\n\r\nThe process is continued to a point where both members agree for mutual transfer of goods.At this point the user information of both the members are displayed and they can proceed with the transfer physically.The posted item is moved to swapped items list and will not be available for swapping any more.Both the members will get a facility to provide a feedback of  the other member.All bad rated members can be barred from further trades by the administrator.\r\n\r\nThere are no fees required for swap listings. It is open for all registered users\r\n\r\n'),(44,45,1,'Manage Wish','<b>Add  your wish item</b>\r\n    To add  an item you wish, to swap with or buy,  click on \' Add to wish list \' on left menu  section. Provide title,brand,price etc.To know more about this site wish process click here How to  wish an item with this site .\r\n\r\n<b>Edit your wish item</b>\r\n    To view/edit wish item click on  \' MY BOOTH \' on top menu section . Click on \' More \' icon under the latest wish addition section .The upcoming screen will displays all your wish item additions.To edit wish item click on title against wish item . In the ensuing screen edit wish details and click on \' Update  \'. To delete a wish item click on \'  Delete \'. As a word of caution,please make sure that you are deleting the one you have intended since the action is irreversible.'),(45,46,1,'How to wish an item with this site','The first member with this site  adds an item of  wish to the wish list , to  swap with or purchase by providing the title, description, rate, photo if any .\r\n\r\nThe second member who wish to swap his item can click on the first members listing and make an offer by providing his item for swap and an amount that he wants.This will update a new entry in his my offers list.\r\n\r\nThe first member gets a new entry in his offers for me  list. He can view the offer and accept it or reject. If the first member accept the offer he/she will have the option of paying directly to the seller or through this site with an escrow .If the buyer chooses escrow, buyer can pay using credit card, paypal or check/money order.\r\n\r\nOn receiving the amount in pending settlement section second member can ship his item to the first member .On getting confirmation from the first member about proper receipt of the shipped item, the admin clicks the settle account button to clear the pending settlement of second member .'),(46,47,1,'Manage Offers','The highlighted portion makes no sense. It should look like this: Once you accept the order you now have the option to pay directly to the seller or through the site with an escrow fee, if you choose escrow...'),(47,48,1,'Change delivered status','<b>How to change sale delivered status</b>\r\n    \r\n    Click on \' Account Summary   \' in the left menu section. In the ensuing screen click on \' Sale payment by me \'. The upcoming screen will displays all sale payments done by you. Click on \' Delivered \' against the payment row.\r\n\r\n<b>How to change swap/wish delivered status</b>\r\n\r\n    Click on \' MY BOOTH \'  in the  top menu section. Click on \' more \' icon under the my offers \'.The upcoming screen will displays all your swap/wish offers. Click on title against the offer . In the ensuing screen you can change the status to be delivered by just clicking on the \' Change status \'. '),(48,49,1,'Manage Payments','To view the payment you have made to purchase an item, just select the \'Account Summary\' link. In the following screen, select \'Sale Payments\' (please change in the product). All of your payments can be viewed from this section. Note, that the payments accept credit cards. PayPal will not be listed here until the administrator approves the sale. Once the requested item is successfully delivered to you, remember to change the delivered status to \'yes\'. This can be done when you select the \'delivered\' link near the payment row. '),(49,50,1,'Manage Feedback','All the users registered with this site have the option to post feedback  about other users .\r\n\r\n<b>Post feedback</b>\r\n\r\n     To post feedback about a user,first you have to select the item of the intended user you wish to buy/swap ( <a href=\'{SALE_HELP_LINK}\'>click here</a> to know how to select an item for sale ) .The upcoming screen will displays the item in detail with four additional links such as  \' view large image \', \' users postings \' etc  . Click on \' users posting \' . In the ensuing screen you can view the intended user\'s listing such as sale,wish,offers etc. Click on \' post feedback about the user  \' on the top section of the screen . In the ensuing screen enter your feedback and click on \' post feedback \'\r\n\r\n\r\n\r\n<b>View feedback</b>\r\n\r\nTo view the feedback posted against you click on \' View feedbacks \' in the left.The upcoming screen will displays all the user feedback against you.To view feedback in detail click on feedback title against feedback row. '),(50,51,1,'Buy an item','Select the \'sale\' link in the top menu section. The following screen will show an item for sale. To purchase the item, select the title near the sale item. The next screen will describe the sale item in detail such as price, description, etc. Then, select \'buy\'. Now, just enter the quantity required and select \'Confirm Purchase\'. You have the option to pay directly to the seller or through this site with an escrow fee. If you choose the escrow, you can pay using a credit card, PayPal, or check/money order. Once your item is successfully delivered, you can change the order status to \'Delivered\'. '),(51,52,1,'Manage Referral','<b>What is  referral program</b>\r\n    As a registered member of this site , you could receive a fixed amount for every friend that you refer to this site . After you refer a friend to this site , we will e- mail them a link where they can participate in a short survey regarding our services and how it can possibly benefit them, or somebody they know. This survey is voluntary but, if your friend completes the survey and submits it back to us, you will earn fixed amount per completed survey. But thats not all. Your friend will also have the chance to register with this site them self, if this happens; you will earn yourself an additional amount. There are no limits to how many friends.\r\n\r\n<b>Add  referrer</b>\r\n\r\n    To add referrer  click on \' Add referrals \' in the left menu section .The top section of the upcoming screen will displays all the referred user along with their survey and registration status. In the middle section of the screen provide referrer name,email etc and click on \' Submit \'.\r\n\r\n<b>Note that referral program with this site  will not be available when free registration is enabled.</b>'),(52,53,1,'Adding Contents For FAQ','Use  this screen to  add the frequently asked questions on this site. You can add, edit or delete questions and answers.'),(53,54,1,'Contact Us Content','The textual content of the contact us page could be edited by clicking the contact us link under Content Management on the left menu.'),(54,55,1,'About Us Content','The textual content of the about us page could be edited by clicking the about us link under Content Management on the left menu.'),(55,56,1,'Privacy Content','The textual content of the privacy page could be edited by clicking the privacy link under Content Management on the left menu.'),(56,57,1,'Terms Content','The textual content of the terms page could be edited by clicking the terms link under Content Management on the left menu.'),(57,59,1,'Point System','This site allows the admin to run it in three different modes. One could use the point mode or the money mode or both. In the money mode, the system behaves like a normal shopping cart software system should. All transactions take place in terms of real currency.\r\n\r\nIn the point mode, the currency is instead replaced with points. Every user has allotted some points which he/she can use to buy or swap items. In case there is a point shortage, he/she could buy more points from the admin by paying. They can also receive points when they trade an item for points.\r\n\r\nIf the site operation is in point mode, then the admin must set the following parameters:\r\n\r\n1. Points Will Be Called- the admin can decide how a point should be called in their system. You can term it as swapbugs or tradepoints. The choice is yours.\r\n\r\n2. Point Conversion Rate- the admin can decide what is the value of the point in relation to currency\r\n\r\n3. Allow Point Transfer- admin can decide if they want to enable point transfers between the users.\r\n\r\n4. Success Fee for a Completed Transaction- the admin can decide how much the user needs to pay for each transaction.'),(58,60,1,'Success Fee Report','This report is available when the system runs in the point mode. The admin can figure out how much he/she made during a specified period of time.'),(59,61,1,'Point Purchase','This report is available when the system runs in the point mode. The admin can figure out how much he/she made during a specified period of time. '),(60,62,1,'Sales Report','This report is available when the system isn\'t running in point mode. Here, the admin will figure out how much he/she earned during a specified period of time. The admin can also filter the reports to receive the data for a specified period of time. '),(69,68,2,'fsdfsdfsdz frrrrrrFR','fsdfsdfsdz frrrrrrfsdfsdfsdz frrrrrrfsdfsdfsdz frrrrrrfsdfsdfsdz frrrrrrfsdfsdfsdz frrrrrrfsdfsdfsdz frrrrrrfsdfsdfsdz frrrrrrFR'),(133,62,6,'',''),(134,60,5,'',''),(67,62,2,'',''),(135,60,6,'',''),(68,68,1,'sZzsdf','ascsdfdsascsdfdsascsdfdsascsdfdsascsdfdsascsdfdsascsdfdsascsdfdsascsdfds'),(132,62,5,'',''),(70,60,2,'',''),(71,52,2,'Gérer aiguillage ','<b>Quel est le programme d\'aiguillage</b>\r\n    En tant que membre inscrit de ce site, vous pourriez recevoir un montant fixe pour chaque ami que vous référer à ce site. Une fois que vous parrainez un ami sur ce site, nous allons les envoyer par courriel un lien où ils peuvent participer à un court sondage concernant nos services et comment il peut éventuellement leur être utile, ou quelqu\'un qu\'ils connaissent. Cette enquête est volontaire, mais si votre ami achève l\'enquête et le soumet de nouveau à nous, vous gagnerez montant fixe par questionnaire rempli. Mais ce n\'est pas tout. Votre ami aura également la chance de s\'inscrire à ce site entre eux soi-même, si cela arrive, vous gagnerez-vous un montant supplémentaire. Il n\'y a pas de limite au nombre d\'amis.\r\n\r\n<b>Ajouter référent</b>\r\n\r\n    Pour ajouter référent cliquez sur \"\"Ajouter aiguillage» dans la section menu de gauche. La section supérieure de l\'écran affiche tous à venir sera l\'utilisateur visé de même que leur enquête et le statut d\'inscription. Dans la section du milieu de l\'écran fournissent nom de l\'affluent, etc email et cliquez sur «Soumettre».\r\n\r\n<b>Notez que le programme de référence avec ce site ne seront pas disponibles lors de l\'inscription gratuite est activée.</b>\r\n'),(139,14,2,'',''),(136,12,2,'',''),(137,12,5,'',''),(138,12,6,'',''),(76,52,5,'gestionar Referencia ','<b>¿Qué es el programa de referencia</b>\r\n    Como usuario registrado de este sitio, usted podría recibir una cantidad fija por cada amigo que se refieren a este sitio. Después de recomendar a un amigo a este sitio, vamos a enviarlas por correo electrónico un enlace donde se puede participar en una breve encuesta acerca de nuestros servicios y cómo es posible que ellos se benefician, o alguien que conocen. Esta encuesta es voluntaria pero, si tu amigo se completa el estudio y lo envía de vuelta a nosotros, usted ganará cantidad fija por cada encuesta completada. Pero eso no es todo. Su amigo también tendrá la oportunidad de registrarse en esta página a uno mismo, si esto sucede, usted se gana una cantidad adicional. No hay límites a la cantidad de amigos.\r\n\r\n<b>Añadir remitente</b>\r\n\r\n    Para agregar referrer haga clic en \"\"Agregar referencias\"\" en la sección de menú de la izquierda. En la parte superior de la pantalla se muestra próximo a todos los usuarios se refiere, junto con su encuesta y el estado del registro. En la sección central de la pantalla indique el nombre del remitente, etc correo electrónico y haga clic en \"\"Enviar\"\".\r\n\r\n<b>Tenga en cuenta que el programa de referencia con este sitio no estará disponible cuando se activa el registro libre.</b>\r\n'),(77,52,6,'verwalten Referral ','<b>Was ist Referral-Programm</b>\r\n    Als registriertes Mitglied dieser Seite können Sie erhalten einen festen Betrag für jeden Freund, den Sie beziehen sich auf dieser Website. Nachdem Sie einen Freund auf diese Seite verweisen, werden wir e-mail ihnen einen Link, wo sie in einem kurzen Überblick über unsere Dienstleistungen teilnehmen können und wie sie möglicherweise profitieren sie, oder jemand, den sie kennen. Diese Umfrage ist freiwillig, aber, wenn Ihr Freund ergänzt die Studie und legt es an uns zurück, werden Sie Festbetrag pro abgeschlossene Umfrage verdienen. Aber das ist nicht alles. Ihr Freund wird auch die Chance haben, mit dieser Website sie sich selbst registrieren, wenn dies geschieht, werden Sie verdienen Sie sich einen zusätzlichen Betrag. Es gibt keine Grenzen gesetzt, wie viele Freunde.\r\n\r\n<b>Add Referrer</b>\r\n\r\n    Um Referrer auf \'Add Verweise \"\"im linken Menü Abschnitt klicken. Der obere Abschnitt des bevorstehenden Bildschirm zeigt alle genannten Benutzer zusammen mit ihrer Umfrage und Anmeldung Status. Im mittleren Abschnitt des Bildschirms sorgen Referrer Name, Email etc. und klicken Sie auf \'Senden\'.\r\n\r\n<b>Beachten Sie, dass Referral-Programm mit dieser Website nicht verfügbar sein, wenn kostenlose Registrierung aktiviert ist.</b>\r\n'),(78,38,2,'Comment ajouter un élément à la liste de souhaits ','\"Le premier membre ajoute l\'élément à la liste de souhaits pour échanger avec ou l\'acheter en précisant le titre, description, taux, et la photo.\r\n\r\nLe second membre qui souhaite échanger leurs point peut sélectionner la liste des membres du premier et faire une offre en fournissant leur élément pour le swap et un montant. Ceci mettra à jour une nouvelle entrée dans son / sa section «Mes offres».\r\n\r\nLe premier membre reçoit une nouvelle entrée dans son / sa liste. Ils peuvent consulter l\'offre et de l\'accepter ou la rejeter. Si le premier membre accepte l\'offre, il / elle sera en mesure de payer directement au vendeur ou par l\'intermédiaire du site de troc avec des frais d\'entiercement. Si l\'acheteur choisit un droit d\'entiercement, l\'acheteur peut maintenant payer par carte de crédit, PayPal ou chèque / mandat.\r\n\r\nLorsque le deuxième membre reçoit le montant, ils peuvent expédier leur élément au premier membre. Lorsque le deuxième membre reçoit la confirmation du premier membre, l\'administrateur sélectionne le bouton «Settle compte» pour effacer le règlement en cours du second membre.\"\r\n'),(79,38,5,'Cómo agregar un elemento a la lista de deseos ','\"El primer miembro agrega el elemento a la lista de deseos para intercambiar con o comprarlo por proporcionar el título, descripción, precio, y la fotografía.\r\n\r\nEl segundo miembro que desee cambiar su punto puede seleccionar una lista de los miembros de primera y hacer una oferta al ofrecer su punto de intercambio y una cantidad. Esto actualizará una nueva entrada en su / su sección \"\"Mis Ofertas\"\".\r\n\r\nEl primer miembro recibe una nueva entrada en su / su lista. Se puede ver la oferta y aceptarla o rechazarla. Si el primer miembro acepta la oferta que él / ella será capaz de pagar directamente al vendedor o por el trueque sitio con una tasa de depósito en garantía. Si el comprador elige una cuota de depósito en garantía, el comprador puede ahora pagar con tarjeta de crédito, PayPal o cheque / giro postal.\r\n\r\nCuando el segundo miembro recibe la cantidad, pueden enviar su artículo al primer miembro. Cuando el segundo miembro recibe la confirmación del primer miembro, el administrador selecciona el botón \"\"Resolver cuenta\"\" para borrar la pendiente de resolución del segundo miembro.\"\r\n'),(80,38,6,'Wie man ein Item auf den Wunschzettel ','\"Das erste Mitglied fügt das Element auf der Wunschliste, mit Swap-oder erwerben Sie durch die Bereitstellung der Titel, Beschreibung, Preis und Foto.\r\n\r\nDas zweite Mitglied, die ihre Position tauschen will, kann wählen das erste Mitglied der Auflistung und ein Angebot machen, indem sie ihre Position für Swap und eine Menge. Dies wird update einen neuen Eintrag in seinem / ihrem \"\"Meine Angebote\"\" Abschnitt.\r\n\r\nDas erste Mitglied erhält einen neuen Eintrag in seiner / ihrer Liste. Sie können die anbieten und annehmen oder ablehnen. Wenn das erste Mitglied das Angebot annimmt wird er / sie in der Lage sein, direkt zu bezahlen an den Verkäufer oder durch den Tausch vor Ort mit einem Escrow-Gebühr. Wenn der Käufer wählt ein Escrow-Gebühr, kann der Käufer jetzt zahlen mit Kreditkarte, PayPal oder Scheck / eine Zahlungsanweisung.\r\n\r\nWenn das zweite Mitglied der Höhe erhält, kann sie ihre Position, um das erste Mitglied Schiff. Wenn das zweite Mitglied das erste Mitglied der Bestätigung erhält, wählt der Administrator die \"\"Settle Konto\"\"-Taste, um die ausstehende Abrechnung des zweiten Teils klar.\"\r\n'),(81,37,2,'Comment échanger un item avec eSwap ','\"Le premier membre ajoute un élément à la liste swapping en précisant le titre, la description, les frais de taux, la photo, et l\'expédition.\r\n\r\nLe second membre qui veut échanger l\'élément permet de sélectionner la première liste des membres et faire une offre en fournissant leur élément et un montant d\'échanger avec.\r\n\r\nLe second membre reçoit une nouvelle entrée dans son / sa liste.\r\n\r\nLe premier membre reçoit une nouvelle entrée dans leur liste. Maintenant, il / elle peut voir toute l\'offre et de l\'accepter ou le rejeter avec une contre-offre.\r\n\r\nLe processus se poursuit au point où les deux membres d\'accord pour un transfert réciproque de biens. Les informations sur les utilisateurs des deux membres est montré et ils peuvent maintenant procéder au transfert physique. L\'article posté est déplacé vers la liste «Articles échangé», et il ne sera pas disponible pour échanger plus longtemps. Les deux membres ont la capacité de fournir des commentaires sur les relations de l\'autre député. Tous les membres nominale peuvent être interdits de métiers encore par l\'administrateur si nécessaire.\r\n\r\nIl n\'y a aucun frais exigés pour les annonces de swap. Il est ouvert à tous les utilisateurs enregistrés.\"\r\n'),(82,37,5,'Cómo cambiar un elemento con eSwap ','\"El primer miembro agrega un elemento a la lista de intercambio, proporcionando el título, descripción, tipo de cargos, fotos y envío.\r\n\r\nEl segundo miembro que quiera cambiar el tema puede seleccionar la lista de los primeros miembros y hacer una oferta al ofrecer su punto y una cantidad de swap con.\r\n\r\nEl segundo miembro recibe una nueva entrada en su / su lista.\r\n\r\nEl primer miembro recibe una nueva entrada en su lista. Ahora, él / ella puede ver la oferta y la acepta o la rechaza con una contraoferta.\r\n\r\nEl proceso continúa hasta el punto que ambos miembros están de acuerdo para una transferencia mutua de los bienes. La información de los usuarios de ambos de los miembros que se muestra y que ahora se puede proceder con la transferencia física. El artículo publicado se mueve a la lista de \'Elementos intercambiado, y no estará disponible para el bombeo de más tiempo. Tanto de los miembros tienen la capacidad de proporcionar información de las relaciones de la de otros miembros. Todos los miembros de calificación puede ser prohibido de las operaciones de más por el administrador, si es necesario.\r\n\r\nNo hay cargos necesarios para las listas de intercambio. Está abierto a todos los usuarios registrados.\"\r\n'),(83,37,6,'Wie ein Element mit eSwap Swap ','\"Das erste Mitglied fügt ein Element, um die Auslagerung Liste, indem sie die Titel, Beschreibung, Preis, Foto-und Versandkosten.\r\n\r\nDas zweite Mitglied, das die Position tauschen möchte, kann wählen Sie die erste Mitglieder-Liste und ein Angebot machen, indem sie ihre Position und Höhe mit Swap.\r\n\r\nDas zweite Mitglied erhält einen neuen Eintrag in seiner / ihrer Liste.\r\n\r\nDas erste Mitglied erhält einen neuen Eintrag in die Liste. Nun kann er / sie im Internet auf offer und annehmen oder ablehnen kann mit einem Gegenangebot.\r\n\r\nDer Prozess wird fortgesetzt, bis zu dem Punkt, wo beide Mitglieder stimmen für einen gegenseitigen Austausch von Waren. Der Anwender Informationen sowohl der Mitglieder wird gezeigt, und sie können jetzt mit der Übertragung physisch vorgehen. Der entsandte Punkt auf der \"\"Swapped Items\"\" Liste verschoben, und es wird nicht verfügbar sein für den Austausch von nicht mehr. Beide haben die Mitglieder die Möglichkeit, Feedback der anderen Mitglieds Umgang bieten. Alle bewerteten Mitglieder können von der weiteren Gewerke durch den Administrator bei Bedarf gesperrt werden.\r\n\r\nEs gibt keine Gebühren für die Swap-Liste erforderlich. Es ist offen für alle registrierten Benutzer.\"\r\n'),(84,36,2,'Comment vendre un objet avec Eswaps ... ','\"Le premier membre de eSwap ajoute un élément à la vente dans la liste après-vente qu\'ils fournissent le titre, description, taux, prix, photo, et les frais d\'expédition.\r\n\r\nLe second membre qui veut acheter et le point peut sélectionner la liste des membres du premier des ventes de recevoir toutes les infos liées au sujet du produit.\r\n\r\nEnsuite, il / elle paie pour le poste qu\'ils veulent acheter. L\'élément est supprimé de la liste des ventes. L\'acheteur a désormais la possibilité de payer directement au vendeur ou par l\'intermédiaire eSwap avec un droit d\'entiercement. Si l\'acheteur choisit les frais de séquestre, l\'acheteur peut payer avec leur carte de crédit, PayPal, et / ou chèque / mandat. L\'argent provient du compte eSwap. Le premier membre peut voir le montant de leur section.\r\nLorsque vous recevez un montant dans la section de règlement, le premier utilisateur peut expédier son / sa élément pour le deuxième utilisateur. Lorsque la confirmation de l\'utilisateur seconde est terminée, l\'administrateur sélectionne les «Settle compte» bouton pour effacer le règlement en cours du premier utilisateur. Les chèques peuvent être livrés deux fois par mois après déduction de la commission.\"\r\n'),(85,36,5,'Cómo vender un artículo con Eswaps ... ','\"El primer miembro de eSwap agrega un elemento a la venta en la lista de ventas después de proporcionar el título, descripción, precio, precios, fotos, y los gastos de envío.\r\n\r\nEl segundo miembro que quiere comprar y el tema se puede seleccionar una lista de los miembros del primer ventas para recibir toda la información de relación sobre el producto.\r\n\r\nA continuación, él / ella paga por el artículo que desea comprar. El elemento se elimina de la lista de ventas. El comprador tiene ahora la opción de pagar directamente al vendedor oa través de eSwap con una tasa de depósito en garantía. Si el comprador elige la tarifa de depósito en garantía, el comprador puede pagar con su tarjeta de crédito, PayPal, y / o Cheque / Giro. El dinero proviene de la cuenta eSwap. El primer miembro puede ver la cantidad en su sección.\r\nCuando usted reciba la cantidad en la sección de solución, el usuario puede enviar su / su punto al segundo usuario. Cuando la confirmación del segundo usuario se ha completado, el administrador selecciona el \'Resolver cuenta \"\"para borrar la solución a la espera de que el primer usuario. Los controles pueden ser entregados cada dos meses después de deducir la comisión.\"\r\n'),(86,36,6,'Wie ein Element mit Eswaps verkaufen ... ','\"Das erste Mitglied der eSwap fügt einen Artikel zum Verkauf in der Verkaufsliste, nachdem sie den Titel, Beschreibung, Preis, Preis, Foto-und Versandkosten stellen.\r\n\r\nDas zweite Mitglied, das zu kaufen und zu Artikel möchte, kann wählen das erste Mitglied der Verkaufsliste auf alle zugehörigen Informationen über das Produkt erhalten.\r\n\r\nAnschließend zahlt er / sie für das Element sie kaufen möchten. Das Element wird aus der Verkaufsliste entfernt. Der Käufer hat nun die Möglichkeit, direkt an die Verkäufer oder durch eSwap mit einer Escrow-Gebühr. Wenn der Käufer wählt das Escrow-Gebühr, kann der Käufer zu zahlen mit der Kreditkarte, PayPal, und / oder Check / Money Order. Das Geld stammt aus dem eSwap Konto. Das erste Mitglied kann die Menge in ihren Bereich zu sehen.\r\nWenn Sie den Betrag in der Siedlung Abschnitt, kann der erste Benutzer seine / ihre Position an den zweiten Benutzer versenden. Wenn die Bestätigung durch den zweiten Benutzer abgeschlossen ist, wählt der Administrator die \"\"Settle Konto\"\", um die anstehenden Ansiedlung der ersten Anwender klar. Die Kontrollen können zweimonatliche nach Abzug der Provision geliefert werden.\"\r\n'),(87,35,2,'caractéristiques ','\"Le Eswaps Permutation Platform est riche avec une grande liste de fonctionnalités pour rendre sa facilité d\'utilisation au maximum et de rendre votre travail facile.\r\nLes principales caractéristiques sont les suivantes:\r\n    - Pas de plug-ins / programmation\r\n    Administration web -\r\n    - Système de vitrine complète\r\n    - Manuel gratuit\r\n    - Connaissance en HTML n\'est pas nécessaire\r\n    - Compétences en conception graphique n\'est pas nécessaire\r\n    - Les produits connexes et de la vente croisée\r\n    - Acceptez les cartes de crédit en temps réel\r\n    - Authorize.net, PayPal ou les deux\r\n    Courriel par navigateur -\r\n    - Les clients peuvent consulter l\'historique des commandes\r\n    - Conception entièrement personnalisable\r\n    - Modèle personnalisable fourni\r\n    - Pratiquement illimitée principales catégories / sous\r\n    - Rechercher dans la boutique intégré\r\n    - Miniatures et des vues grande image\r\n    - Toutes les données client sont stockées dans la base\r\n    - L\'accès admin Mot de passe-protégée\"\r\n'),(88,35,5,'características ','\"La Plataforma de Intercambio de Eswaps es rica en una larga lista de características para hacer su facilidad de uso al máximo y hacer su trabajo fácil.\r\nLas principales características son:\r\n    - No hay plug-ins / programación\r\n    - Administración basada en Web\r\n    - Sistema de fachada completa\r\n    - Manual gratis\r\n    - No requiere conocimientos de HTML\r\n    - Habilidades de diseño gráfico no es necesario\r\n    - Productos relacionados y venta cruzada\r\n    - Aceptar en tiempo real de las tarjetas de crédito\r\n    - Authorize.net, PayPal o ambos\r\n    - Navegador basado en correo electrónico\r\n    - Los clientes pueden ver el historial de pedidos\r\n    - Diseño totalmente personalizable\r\n    - Plantilla adaptable siempre\r\n    - Principales categorías / sub prácticamente ilimitada\r\n    - Búsqueda de la tienda integrada\r\n    - Miniaturas y puntos de vista de imagen grandes\r\n    - Todos los datos del cliente se almacena en la base de datos\r\n    - Acceso protegido por contraseña admin\"\r\n'),(89,35,6,'Features ','\"Die Eswaps Swapping Platform ist reich an einer großen Liste von Funktionen, um die Verwendbarkeit der maximalen zu machen und Ihnen die Arbeit leicht.\r\nDie wichtigsten Merkmale sind:\r\n    - Keine Plug-Ins / Programmierung\r\n    - Web-basierte Administration\r\n    - Komplette Storefront System\r\n    - Free manuellen\r\n    - HTML-Kenntnisse nicht erforderlich\r\n    - Graphic Design-Kenntnisse nicht erforderlich\r\n    - Verwandte Produkte und Cross-Selling\r\n    - Nehmen Sie Echtzeit-Kreditkarten\r\n    - Authorize.net, PayPal oder beide\r\n    - Browser-basierte E-Mail\r\n    - Kunden können Bestellungen\r\n    - Vollständig anpassbare Design\r\n    - Anpassbare Vorlage zur Verfügung gestellt\r\n    - Praktisch unbegrenzte main / Unterkategorien\r\n    - Integrierte speichern Suche\r\n    - Thumbnails und große Bildansichten\r\n    - Alle Kunden-Daten in der Datenbank gespeichert\r\n    - Passwort-geschützte Admin-Zugang\"\r\n'),(90,34,2,'Comment fonctionne le site? ','\"Ce site est un service en ligne permutation, où les membres peuvent accéder aux détails sur les autres membres les éléments indésirables. Ils peuvent également dresser la liste des articles sur le site même, et faire des demandes pour les articles qu\'ils veulent au lieu. Le but de ce site est d\'aider nos membres à se débarrasser de leurs éléments indésirables et de leur permettre de trouver des biens dont ils ont besoin parmi les uns des autres, sans frais supplémentaires.\r\n\r\nNotre site est destiné aux personnes qui luttent sur &#8203;&#8203;le quoi faire avec les éléments qu\'ils n\'ont plus aucune utilité pour. Nous avons découvert que ces éléments sont ensuite jetés ou ignorées pendant des années à venir. Le vieil adage «Un Corbeille Mans, Le Mans est un autre trésor est ce que ce site vit par.\r\n\r\nNotre personnel s\'est pleinement engagé à assurer que chaque utilisateur dans notre communauté est comblés. En plus de notre personnel est en communication constante avec l\'autre partager de nouvelles idées pour vous accueillir. Nous espérons que vous apprécierez notre site et de tous les avantages présentes.\"\r\n'),(91,34,5,'¿Cómo funciona la Web? ','\"Este sitio web es un servicio online de intercambio, donde los miembros pueden acceder a los detalles sobre los miembros de otros elementos no deseados. También puede mostrar los elementos en el mismo lugar, y hacer pedidos de artículos que desea en su lugar. El objetivo de este sitio web es ayudar a nuestros miembros de deshacerse de sus elementos no deseados y que puedan encontrar los productos que necesitan entre sí sin ningún coste adicional.\r\n\r\nNuestro sitio está dirigido a personas que luchan en qué hacer con los elementos que ya no tienen ningún uso para. Hemos descubierto que estos elementos se expulsados &#8203;&#8203;o pasados &#8203;&#8203;por alto en los próximos años. El viejo dicho \"\"Una basura Mans, es otro de los tesoros Mans es lo que este sitio vidas.\r\n\r\nNuestro personal está totalmente comprometida a asegurar que todos los usuarios en nuestra comunidad es atendido. Además nuestro personal está en constante comunicación unos con otros compartiendo ideas nuevas para usted. Esperamos que usted disfrute de nuestro sitio y todos los beneficios de este documento.\"\r\n'),(92,34,6,'Wie funktioniert die Webseite? ','\"Diese Website ist ein Online-Tausch-Service, in denen die Mitglieder Informationen über andere Mitglieder unerwünschte Elemente zugreifen können. Sie können auch eine Liste der Elemente auf der aktuellen Website und machen Anfragen für Gegenstände, die sie möchten, statt. Das Ziel dieser Webseite ist es, unseren Mitgliedern helfen loszuwerden ihre unerwünschte Elemente und es ihnen ermöglichen, Waren, die sie brauchen untereinander ohne zusätzliche Kosten zu finden.\r\n\r\nUnsere Website ist für Personen, auf was sie mit Gegenständen, die nicht mehr die Nutzung für Sie kämpfen sollen. Wir haben entdeckt, dass diese Elemente werden dann aus oder geworfen außer Acht gelassen für die kommenden Jahre. Das alte Sprichwort \"\"Ein Mans Trash, ist ein weiterer Mans Treasure ist, was dieser Ort von Leben.\r\n\r\nUnsere Mitarbeiter sind voll versichert, dass jeder Benutzer in unserer Gemeinde ist es, Catering verpflichtet. Neben unserer Mitarbeiter ist in ständiger Kommunikation miteinander und neue Ideen mit Ihnen aufnehmen. Wir hoffen, dass Sie unsere Website und alle Vorteile hier zu genießen.\"\r\n'),(93,51,2,'Acheter un élément ','Sélectionnez la \"vente\" lien dans la section menu du haut. L\'écran suivant montre un objet en vente. Pour acheter l\'élément, sélectionnez le titre à proximité de l\'élément de vente. L\'écran suivant vous décrire l\'article à vendre en détail comme le prix, description, etc Ensuite, sélectionnez «acheter». Maintenant, il suffit d\'entrer la quantité requise et sélectionnez \"Confirmer l\'achat\". Vous avez la possibilité de payer directement au vendeur ou à travers ce site avec un droit d\'entiercement. Si vous choisissez l\'entiercement, vous pouvez payer avec une carte de crédit, PayPal ou chèque / mandat. Une fois que votre article est livré avec succès, vous pouvez changer le statut pour «livré».\r\n'),(94,51,5,'Comprar un artículo ','Seleccione la opción \'venta\' en la sección superior del menú. La siguiente pantalla aparecerá un artículo en venta. Para comprar el artículo, seleccione el título cerca del punto de venta. La siguiente pantalla se debe describir con la venta en los detalles como el precio, descripción, etc A continuación, seleccione \"comprar\". Ahora, basta con introducir la cantidad deseada y seleccione \"Confirmar compra\". Usted tiene la opción de pagar directamente al vendedor oa través de este sitio con una tasa de depósito en garantía. Si opta por la custodia, usted puede pagar con tarjeta de crédito, PayPal o cheque / giro postal. Una vez que el tema se ha entregado correctamente, puede cambiar el estado del pedido a \"Enviado\".\r\n'),(95,51,6,'Kaufen Sie ein Element ','Wählen Sie den \"Verkauf\"-Link in der oberen Menüleiste Abschnitt. Der folgende Bildschirm wird einen Artikel zum Verkauf zu zeigen. So erwerben Sie das Element, wählen Sie den Titel in der Nähe der Kaufsache. Im nächsten Bildschirm werden die Kaufsache im Detail beschreiben, wie Preis, Beschreibung, etc. Wählen Sie dann \"kaufen\". Nun, geben Sie einfach die gewünschte Menge ein und wählen Sie \"Kauf bestätigen\". Sie haben die Möglichkeit, direkt an die Verkäufer oder durch diese Website mit einer Escrow-Gebühr. Wenn Sie das Treuhandkonto wählen, können Sie bezahlen mit Kreditkarte, PayPal oder Scheck / eine Zahlungsanweisung. Sobald Ihre Artikel erfolgreich zugestellt wird, können Sie die Reihenfolge ändern, den Status zu \"Delivered\".\r\n'),(96,50,2,'Gérer Commentaires','\"Tous les utilisateurs enregistrés sur ce site ont la possibilité d\'afficher des commentaires sur d\'autres utilisateurs.\r\n\r\n<b>message commentaires</b>\r\n\r\n     Pour poster des commentaires sur un utilisateur, vous devez d\'abord sélectionner l\'élément de l\'utilisateur prévu que vous souhaitez acheter / swap (cliquez ici pour savoir comment sélectionner un élément pour la vente). L\'écran affiche à venir sera la question en détail avec les quatre autres liens tels que \'afficher une grande image, etc\' utilisateurs affichages. Cliquez sur \'utilisateurs détachement ». Dans l\'écran suivant vous pouvez consulter la liste des utilisateurs visés, tels que la vente, le souhaitez, vous propose etc Cliquez sur \"\"commentaires post sur l\'utilisateur\"\" sur la partie supérieure de l\'écran. Dans l\'écran suivant entrez votre feedback et cliquez sur \"\"commentaires post \'\r\n\r\n\r\n\r\n<b>Voir commentaires</b>\r\n\r\nPour voir les réactions affichées contre vous cliquez sur \"\"Afficher les rétroactions» dans l\'écran à venir seront left.The affiche tous les commentaires des utilisateurs contre les réactions de vue you.To cliquez détails sur le titre contre la rétroaction consécutive commentaires.\"\r\n'),(97,50,5,'gestionar Comentarios','\"Todos los usuarios registrados en este sitio tienen la opción de publicar comentarios de otros usuarios.\r\n\r\n<b>publicar comentarios</b>\r\n\r\n     Para publicar información sobre un usuario, primero hay que seleccionar la opción del futuro usuario que desea comprar / swap (clic aquí para saber cómo seleccionar un elemento para la venta). La pantalla se muestra el próximo tema en detalle con los otros cuatro enlaces tales como \"\"ver la imagen grande\"\", \"\"los usuarios anuncios \', etc. Haga clic en \"\"usuarios de desplazamiento». En la pantalla resultante se puede ver una lista de los usuarios previstos, tales como la venta, deseo, etc ofrece Haga clic en \"\"información posterior sobre el usuario\"\" en la sección superior de la pantalla. En la pantalla resultante ingresar sus comentarios y haga clic en \"\"retroalimentación post \'\r\n\r\n\r\n\r\n<b>Ver información</b>\r\n\r\nPara ver la información publicada en contra de usted, haga clic en \"\"Ver Opiniones\"\" en la pantalla de próxima left.The se muestra toda la información de los usuarios en contra de comentarios Ver you.To en detalle, haga clic en el título de información contra la fila de información.\"\r\n'),(98,50,6,'verwalten Sie Ihre Meinung','\"Alle Benutzer mit dieser Website registriert haben, die Möglichkeit, Feedback über andere Benutzer zu posten.\r\n\r\n<b>Beitrag Feedback</b>\r\n\r\n     Um Bewertungen abzugeben über einen Benutzer, müssen Sie zuerst das Element der vorgesehenen Benutzer, den Sie kaufen möchten, / swap (Klicken Sie hier, zu wissen, wie man einen Artikel zum Verkauf auswählen) wählen. Die kommende Bildschirm zeigt die Position im Detail mit vier zusätzlichen Links wie \"\"Bild vergrößern\"\", \"\"Benutzer Kommentare \'etc. Klicken Sie auf \"\"Benutzer Entsendung\"\". In den folgenden Bildschirm können Sie die beabsichtigte Benutzer-Liste wie Verkauf sehen wollen, Angebote etc. auf \'post Feedback über den Benutzer \"\"auf dem oberen Teil des Bildschirms klicken. In den folgenden Bildschirm geben Sie Ihr Feedback und klicken Sie auf \'post Feedback \"\"\r\n\r\n\r\n\r\n<b>Bewertungen ansehen</b>\r\n\r\nUm die Rückmeldung gegen dich posted on \'View Rückmeldungen \"\"in den kommenden links.der Bildschirm Klick zeigt alle Benutzer-Feedback gegen you.To Blick Feedback im Detail klicken Sie auf Feedback-Titel gegen den Feedback-Reihe.\"\r\n'),(99,49,2,'Gérer les paiements ','Pour visualiser le paiement que vous avez fait pour acheter un article, il suffit de sélectionner le lien «Sommaire du compte». Dans l\'écran suivant, sélectionnez «Paiements Vente\" (s\'il vous plaît le changement dans le produit). Tous vos paiements peuvent être consultés depuis cette section. Notez que les paiements d\'accepter les cartes de crédit. PayPal ne seront pas répertoriés ici jusqu\'à ce que l\'administrateur approuve la vente. Une fois l\'élément demandé est livré avec succès pour vous, n\'oubliez pas de changer le statut remis à \'oui\'. Cela peut être fait lorsque vous sélectionnez le «livré» un lien proche de la ligne de paiement.\r\n'),(100,49,5,'gestionar los pagos ','Para ver el pago que haya hecho para comprar un artículo, sólo tienes que seleccionar el enlace \"Resumen de cuenta\". En la siguiente pantalla, seleccione \"Pagos en venta\" (por favor, el cambio en el producto). Todos los pagos se pueden ver desde esta sección. Tenga en cuenta que los pagos de tarjetas de crédito. PayPal no serán listados aquí hasta que el administrador apruebe la venta. Una vez que el artículo solicitado se envía con éxito para usted, recuerde que debe cambiar el estado entregó a \'yes\'. Esto se puede hacer cuando se selecciona la \"entrega\" situado cerca de la fila de pago.\r\n'),(101,49,6,'Zahlungen verwalten ','Um die Zahlung, die Sie gemacht, um einen Artikel zu erwerben sind, wählen Sie einfach die \"Account Summary\"-Link. In dem folgenden Bildschirm wählen Sie \"Sale Payments\" (please change in das Produkt). Alle Ihre Zahlungen können aus diesem Abschnitt betrachtet werden. Beachten Sie, dass die Zahlungen akzeptieren Kreditkarten. PayPal wird hier nicht aufgeführt werden, bis der Administrator genehmigt den Verkauf. Sobald der gewünschte Artikel wurde erfolgreich an Sie ausgeliefert, erinnern an den gelieferten Status auf \'Ja\' zu ändern. Dies kann geschehen, wenn Sie die \'ausgeliefert\' Link in der Nähe der Zahlung Reihe auszuwählen.\r\n'),(102,48,2,'Changer le statut livré ','<b>Comment changer le statut de vente livré</b>\r\n   \r\n    Cliquez sur \"\"Résumé du compte\"\" dans la section menu de gauche. Dans l\'écran, cliquez sur le suivi \"\"paiement Vente par moi». L\'écran affiche à venir sera la vente de tous les paiements fait par vous. Cliquez sur \"\"Livré\"\" contre la ligne de paiement.\r\n\r\n<b>Comment changer swap / souhaitent état &#8203;&#8203;livré</b>\r\n\r\n    Cliquez sur \"\"mon stand\"\" dans la section menu du haut. Cliquez sur \'plus\' icône sous l\'offre mon \"\". L\'écran affiche à venir sera tout votre swap / souhaitent offre. Cliquez sur le titre à l\'offre. Dans l\'écran suivant, vous pouvez changer le statut d\'être livré en cliquant simplement sur &#8203;&#8203;le «statut des changements».\r\n'),(103,48,5,'Cambiar el estado de entrega ','<b>Cómo cambiar el estado de venta entregado</b>\r\n   \r\n    Haga clic en \"\"Resumen de cuenta\"\" en la sección de menú de la izquierda. En la pantalla, haga clic a continuación sobre \"\"Venta de pago por mí\"\". La pantalla muestra todas las próximas pagos venta hecha por usted. Haga clic en \"\"entregados\"\" en contra de la fila de pago.\r\n\r\n<b>¿Cómo cambiar swap / deseo estado entregado</b>\r\n\r\n    Haga clic en \"\"mi stand \'en la sección superior del menú. Haga clic en \"\"más\"\" icono en mi las ofertas. La pantalla muestra todas las próximas a su swap / deseo de ofertas. Haga clic en el título contra de la oferta. En la pantalla resultante se puede cambiar el estado para ser entregados con sólo hacer clic en \"\"Cambiar estado\"\".\r\n'),(104,48,6,'Ändern Auslieferungszustand ','<b>So ändern Sie verkaufen Auslieferungszustand</b>\r\n   \r\n    Klicken Sie auf \"\"Account Summary\"\" im linken Menü Abschnitt. In den folgenden Bildschirm klicken Sie auf \'Kaufen Zahlung durch mich. \"\"Die kommende Bildschirm zeigt alle Verkauf Zahlungen von Ihnen gemacht. Klicken Sie auf \"\"Delivered\"\" gegen die Zahlung Reihe.\r\n\r\n<b>So ändern swap / wünschen Auslieferungszustand</b>\r\n\r\n    Klicken Sie auf \"\"meinem Stand\"\" in der oberen Menüleiste Abschnitt. Klicken Sie auf \"\"mehr\"\"-Symbol unter dem meine Angebote \"\". Die kommende Bildschirm zeigt alle Ihre Swap / Wunsch bietet. Klicken Sie auf den Titel gegen das Angebot ab. In den folgenden Bildschirm können Sie den Status ändern, um durch einen Klick auf den \'Status ändern\' geliefert werden.\r\n'),(105,47,2,'Gestion des offres ','La partie mise en surbrillance ne fait aucun sens. Il devrait ressembler à ceci: une fois que vous acceptez l\'ordre que vous avez maintenant la possibilité de payer directement au vendeur ou par l\'intermédiaire du site avec un droit d\'entiercement, si vous choisissez d\'entiercement ...\r\n'),(106,47,5,'gestionar las ofertas ','La parte resaltada no tiene sentido. Se debe tener este aspecto: Una vez aceptado el pedido, ahora tienen la opción de pagar directamente al vendedor o por el sitio con una cuota de depósito en garantía, si usted elige fideicomiso …\r\n'),(107,47,6,'verwalten Angebote ','Der hervorgehobene Teil macht keinen Sinn. Es sollte wie folgt aussehen: Sobald Sie akzeptieren den Auftrag haben Sie nun die Möglichkeit, direkt an die Verkäufer oder über die Website mit einem Escrow-Gebühr, wenn Sie Treuhandkonto wählen …\r\n'),(108,46,2,'Comment voulez un article avec ce site ','\"Le premier membre de ce site ajoute un élément de la volonté de la liste de vœux, d\'échanger avec ou acheter en précisant le titre, la description, le taux, photo le cas échéant.\r\n\r\nLe second membre qui souhaitent échanger son poste pouvez cliquer sur la première liste des membres et faire une offre en fournissant son élément pour le swap et d\'un montant qu\'il wants.This mettra à jour une nouvelle entrée dans son offre ma liste.\r\n\r\nLe premier membre reçoit une nouvelle entrée dans son offre pour moi la liste. Il peut voir toute l\'offre et de l\'accepter ou de rejeter. Si le premier membre d\'accepter l\'offre, il / elle aura la possibilité de payer directement au vendeur ou à travers ce site avec un séquestre. Si l\'acheteur choisit d\'entiercement, l\'acheteur peut payer par carte de crédit, Paypal ou chèque / mandat.\r\n\r\nSur réception de la somme en règlement des membres section attente seconde peut expédier son élément au premier membre. Sur obtenir la confirmation du premier élément de la réception correcte de l\'article expédié, l\'administrateur clique sur le bouton de régler les comptes pour effacer le règlement en cours du second membre.\"\r\n'),(109,46,5,'¿Cómo desea un artículo con este sitio ','\"El primer miembro de este sitio agrega un elemento de deseo de la lista de deseos, para intercambiar con o compra, proporcionando el título, descripción, precio, foto, si los hubiere.\r\n\r\nEl segundo miembro que deseen cambiar su punto puede hacer clic en la lista de los primeros miembros y hacer una oferta al ofrecer su punto de intercambio y una cantidad que se actualizará wants.This una nueva entrada en su lista ofrece.\r\n\r\nEl primer miembro obtiene una nueva entrada en su lista de ofertas para mí. Se puede ver la oferta y aceptarla o rechazarla. Si el primer miembro de aceptar la oferta que él / ella tendrá la opción de pagar directamente al vendedor oa través de este sitio con un depósito de garantía. Si el comprador elige depósito en garantía, el comprador puede pagar con tarjeta de crédito, PayPal o cheque / giro postal.\r\n\r\nAl recibir la cantidad de miembros hasta la sección de solución de segundo puede enviar su artículo al primer miembro. Al llegar la confirmación del primer miembro de la recepción correcta del artículo enviado, el administrador hace clic en el botón de la cuenta resolver para despejar el acuerdo pendiente de otro de sus miembros.\"\r\n'),(110,46,6,'Wie, um ein Element mit dieser Website möchten ','\"Das erste Mitglied mit dieser Website wird ein Element der Wunscherfüllung auf die Wunschliste, mit Swap oder durch die Bereitstellung der Titel, Beschreibung, Preis, Foto, wenn alle kaufen.\r\n\r\nDas zweite Mitglied, das seine Position tauschen möchte, kann auf den ersten Mitgliedern Liste klicken und ein Angebot machen, indem er Artikel für Swap-und eine Menge, die er wants.This wird ein neuer Eintrag in seinem meine Angebote Liste zu aktualisieren.\r\n\r\nDas erste Mitglied bekommt einen neuen Eintrag in sein Angebot für mich aus. Er kann sehen das Angebot und es akzeptieren oder ablehnen. Wenn das erste Mitglied das Angebot annehmen wird er / sie die Möglichkeit haben, die Zahlung direkt an den Verkäufer oder durch diese Website mit einem Treuhandkonto. Wenn der Käufer wählt Treuhandkonto, Käufer zahlen per Kreditkarte, PayPal oder Scheck / eine Zahlungsanweisung.\r\n\r\nNach Erhalt der Betrag in der anhängigen Siedlung Abschnitt zweite Mitglied kann seine Position Schiff auf das erste Element. Auf immer Bestätigung das erste Mitglied von ordnungsgemäßen Erhalt der gelieferten Artikel, klickt der Administrator die niederlassen Konto-Taste, um die ausstehende Regelung der zweite Mitglied klar.\"\r\n'),(111,45,2,'Gérer souhaits ','<b>Ajouter votre article souhaitent</b>\r\n    Pour ajouter un élément que vous souhaitez, d\'échanger avec ou acheter, cliquez sur «Ajouter à la liste de souhaits\"\" sur l\'article de menu à gauche. Indiquez le titre, marque, prix etc.To savoir plus sur ce site souhaitent processus, cliquez ici Comment voulez un élément de ce site.\r\n\r\n<b>Modifier votre article souhaitent</b>\r\n    Pour visualiser / modifier souhaitent élément de cliquer sur \"\"mon stand\"\" sur l\'article de menu supérieure. Cliquez sur \'Plus\' icône dans la section plus tard le souhaitent. L\'écran affiche tous à venir sera votre souhait de modification d\'éléments additions.To souhaitent élément cliquez sur le titre contre la volonté élément. Dans l\'écran Modifier suivi souhaitez plus de détails et cliquez sur \"\"Update\"\". Pour supprimer un souhait article, cliquez sur \"\"Supprimer\"\". Comme un mot de prudence, s\'il vous plaît assurez-vous que vous supprimez celui que vous avez l\'intention puisque l\'action est irréversible.\r\n'),(112,45,5,'gestionar deseo ','<b>Añade tu punto deseo</b>\r\n    Para agregar un elemento que desees, para intercambiar con o comprar, haga clic en \"\"Añadir a la lista de deseos\"\" en la sección de menú de la izquierda. Proporcionar el título, marca, precio etc.To saber más sobre este sitio deseo proceso haga clic aquí ¿Cómo desea un artículo con este sitio.\r\n\r\n<b>Editar su artículo desea</b>\r\n    Para ver / editar desean tema haga clic en \'mi stand\' en la sección superior del menú. Haga clic en \"\"Más\"\" icono en la sección desea más reciente adición. La pantalla muestra próximo a todos sus deseos de elementos de edición additions.To desean tema, haga clic en el título contra la voluntad de tema. En la pantalla de edición posterior deseo de detalles y haga clic en \"\"Actualizar\"\". Para borrar un deseo clic en el elemento en \"\"Borrar\"\". Como una palabra de advertencia, por favor asegúrese de que está eliminando la que tiene previsto ya que la acción es irreversible.\r\n'),(113,45,6,'verwalten möchten ','<b>Fügen Sie Ihren Wunsch Artikel</b>\r\n    Um einen gewünschten Artikel hinzufügen, um mit Swap oder kaufen, auf \'Zur Merkliste hinzufügen\' auf der linken Menübereich klicken. Geben Sie Titel-, Marken, Know Preis etc.To Informationen über diese Site wünschen Prozess Klicken Sie hier, wie Sie ein Element mit dieser Website möchten.\r\n\r\n<b>Bearbeiten Sie Ihre Wunsch Element</b>\r\n    Um view / edit wünschen Element klicken Sie auf \'meinem Stand \"\"auf Menüfeld. Klicken Sie auf \"\"Mehr\"\"-Symbol unter dem aktuellen Wunsch zusätzlich Abschnitt. Das kommende Bildschirm zeigt alle Ihre Wünsche Element additions.To bearbeiten möchten Element auf Titel klicken Posten wollen. In den folgenden Bildschirm bearbeiten möchten Details und klicken Sie auf \'Update\'. So löschen Sie einen Wunsch Element klicken Sie auf \'Löschen\'. Als ein Wort der Vorsicht, stellen Sie bitte sicher, dass Sie löschen, die Sie haben gedacht, da die Aktion ist unumkehrbar.\r\n'),(114,44,2,'Comment échanger un item avec eSwap ','\r\n\"Le premier membre de ce site ajoute un élément d\'échange à sa liste de swap en précisant le titre, description, tarif, photos éventuelles et les frais d\'expédition.\r\n\r\nLe second membre qui souhaitent échanger son poste pouvez cliquer sur la première liste des membres et faire une offre en fournissant son élément pour le swap et d\'un montant qu\'il estime être une différence de valeur avec les premiers membres posté élément.\r\n\r\nLe second membre reçoit une nouvelle entrée dans son offre ma liste.\r\n\r\nLe premier membre reçoit une nouvelle entrée dans sa liste des offres reçues. Il peut voir toute l\'offre et de l\'accepter ou de mettre une contre-offre.\r\n\r\nLe processus se poursuit à un point où les deux membres d\'accord pour le transfert mutuel de goods.At ce point les informations utilisateur à la fois des membres sont affichés et ils peuvent procéder à l\'élément de transfert de physically.The posté est déplacé vers la liste des articles échangés et ne seront pas être disponible pour échanger toute more.Both les membres recevront une installation pour fournir une rétroaction de l\'autre member.All mauvaise membres nominale peut être empêché de métiers encore par l\'administrateur.\r\n\r\nIl n\'y a aucun frais exigés pour les annonces de swap. Il est ouvert à tous les utilisateurs enregistrés\"\r\n'),(115,44,5,'Cómo cambiar un elemento con eSwap ','\r\n\"El primer miembro de este sitio agrega un elemento de intercambio a su lista de intercambio, proporcionando el título, descripción, precio, fotos y si los gastos de envío.\r\n\r\nEl segundo miembro que deseen cambiar su punto puede hacer clic en la lista de los primeros miembros y hacer una oferta al ofrecer su punto de intercambio y una cantidad que se siente una diferencia de valor con los miembros por primera vez el punto.\r\n\r\nEl segundo miembro obtiene una nueva entrada en su lista ofrece.\r\n\r\nEl primer miembro obtiene una nueva entrada en su lista de ofertas recibidas. Se puede ver la oferta y aceptar o poner una contraoferta.\r\n\r\nEl proceso continúa a un punto en el que ambos miembros están de acuerdo para la transferencia mutua de goods.At este punto, la información de los usuarios tanto de los miembros se muestran y que puede continuar con el tema publicado physically.The transferencia se mueve a la lista de los elementos cambiados y no se estar disponible para el bombeo de cualquier more.Both los miembros recibirán una instalación para proporcionar una retroalimentación de los otros miembros member.All mala calificación puede ser excluido de las operaciones de más por el administrador.\r\n\r\nNo hay cargos necesarios para las listas de intercambio. Está abierto para todos los usuarios registrados\"\r\n'),(116,44,6,'Wie ein Element mit eSwap Swap ','\"Das erste Mitglied mit dieser Website wird ein Eintrag für das Swap seine Swap-Liste, indem sie die Titel, Beschreibung, Preis, Foto, wenn jede und Versandkosten.\r\n\r\nDas zweite Mitglied, das seine Position tauschen möchte, kann auf den ersten Mitgliedern Liste klicken und ein Angebot machen, indem er Artikel für Swap-und eine Menge, die er fühlt, ist ein Unterschied von Wert mit der ersten Mitglieder posted Element.\r\n\r\nDas zweite Mitglied erhält einen neuen Eintrag in seinem meine Angebote Liste.\r\n\r\nDas erste Mitglied bekommt einen neuen Eintrag in seinem eingegangenen Angebote Liste. Er kann im Internet auf offer und akzeptieren lassen oder ein Gegenangebot unterbreitet.\r\n\r\nDer Prozess ist bis zu einem Punkt, wo beide Mitglieder stimmen für die gegenseitige Übertragung von goods.At diesem Punkt dem Anwender Informationen sowohl der Mitglieder angezeigt werden und sie können mit der Übertragung physically.The posted Artikel gehen zu tauschenden Artikel Liste verschoben wird fortgesetzt und wird nicht verfügbar sein für den Austausch von jedem more.Both den Mitgliedern eine Möglichkeit erhalten, ein Feedback der anderen member.All schlecht bewertet Mitgliedern bieten können von der weiteren Gewerke durch den Administrator gesperrt werden.\r\n\r\nEs gibt keine Gebühren für die Swap-Liste erforderlich. Es ist für alle registrierten Nutzer offen\"\r\n'),(123,41,2,'edit Profile ','\"Pour modifier le profil, cliquez sur le lien \'Modifier le profil »dans le menu de gauche qui a suivi l\'section.In modifier les détails et cliquez sur\"\" Enregistrer les modifications \"\"\r\n\r\n\r\n<b>Changer le mot de passe</b>\r\n    Pour changer le mot de passe, cliquez sur \"\"Modifier profil\"\" lien dans le menu de gauche section.In l\'écran suivant entrez l\'ancien mot de field.Enter le \'Ancien mot de passe \"\"nouveau mot de passe dans le champ\' Nouveau mot de passe\"\" et confirmez en le retapant dans le champ «Confirmer mot de passe \'. Les deux mots de passe doivent correspondre et le mot de passe sera mis à jour le mot de passe nouvellement entrés.\"\r\n'),(117,43,2,'Gérer Swap ','<b>Ajouter un élément pour le swap</b>\r\n\r\nPour ajouter un élément pour le swap, il suffit de sélectionner l\'icône «Ajouter Swap\"\" sur la section menu de gauche. Donner un titre, nom, prix, etc Si vous voulez en savoir plus sur le processus de permutation, puis il suffit de cliquer ici. «Comment échanger un article.\r\n\r\n<b>Modifier un élément de swap</b>\r\n\r\nPour afficher / modifier un élément d\'échange, il suffit de sélectionner l\'icône «Mon stand sur la section menu du haut. Ensuite, sélectionnez le \'Plus\' icône sous le dernier ajout de swap. L\'écran suivant permet d\'afficher tous vos objets à échanger.\r\n\r\nPour éditer un swap-sélectionner le titre à proximité de l\'élément de swap. Dans l\'écran suivant, modifier les détails du point de swap et sélectionnez \"\"Mettre à jour \'.\r\n\r\nPour supprimer un swap de sélectionner «Supprimer». Comme un mot de prudence, s\'il vous plaît assurez-vous supprimer les éléments corrects car cette action est irréversible.\r\n'),(118,43,5,'administrar intercambio ','<b>Añadir un elemento de intercambio</b>\r\n\r\nPara agregar un elemento de intercambio, sólo tienes que seleccionar el icono \"\"Agregar swap \'en la sección de menú de la izquierda. Un título, nombre, precio, etc Si quieres saber más sobre el proceso de intercambio, entonces haga clic aquí. \"\"Cómo Cambiar de un elemento.\r\n\r\n<b>Editar elemento de intercambio</b>\r\n\r\nPara ver / editar un elemento de intercambio, sólo tienes que seleccionar el icono \"\"Mi stand \'en la sección superior del menú. A continuación, seleccione \"\"Más\"\" icono en la última adición de intercambio. La siguiente pantalla mostrará todos los artículos de intercambio.\r\n\r\nPara editar un swap-seleccionar el título cerca del punto de intercambio. En la siguiente pantalla, editar los detalles del elemento de intercambio y seleccione \"\"Actualizar\"\".\r\n\r\nPara borrar un swap-seleccione \'Eliminar\'. Como una palabra de advertencia, por favor asegúrese de que elimina los elementos correctos, porque esta acción es irreversible.\r\n'),(119,43,6,'verwalten von Swap- ','<b>Setzen Sie einen Artikel für Swap</b>\r\n\r\nUm einen Artikel zu tauschen, wählen Sie einfach die \'Add Swap \"\"-Symbol auf der linken Menüfeld. Geben Sie einen Titel, Name, Preis, etc. Wenn Sie mehr über die Swap-Prozess wissen willst, dann klicken Sie einfach hier. \"\"Wie man ein Item Swap\"\".\r\n\r\n<b>Bearbeiten Swap Item</b>\r\n\r\nUm view / edit ein Element zu tauschen, wählen Sie einfach unter \"\"Mein Booth\"\"-Symbol in der oberen Menüleiste Abschnitt. Wählen Sie dann das \"\"Mehr\"\"-Symbol unter dem aktuellen Swap-Zusatz. Der nächste Bildschirm zeigt alle Artikel zu tauschen.\r\n\r\nSo bearbeiten Sie eine Swap-wählen Sie den Titel in der Nähe des Swap-Position. In den folgenden Bildschirm, bearbeiten Sie die Swap-Artikel-Seite und wählen Sie \"\"Aktualisieren\"\".\r\n\r\nSo löschen Sie eine Swap-Option \"\"Löschen\"\". Als ein Wort der Vorsicht, stellen Sie bitte sicher, dass Sie löschen die richtigen Elemente, weil diese Aktion nicht rückgängig gemacht werden.\r\n'),(120,42,2,'Gérer Vente ','\"Tous les utilisateurs enregistrés peuvent ajouter un élément à la vente.\r\n\r\nAjouter un article à vendre, pour ajouter un élément à la vente avec ce site, il suffit de sélectionner le lien «Vente Ajouter \'dans la section menu de gauche. L\'écran suivant de fournir le titre, nom, prix, etc Vous pouvez ajouter un élément tel que présenté par le paiement d\'un montant nominal sur le site lui-même. Un article présenté montrera d\'abord dans la liste de vente avec une apparence différente. Vous devez payer une commission très négligeable sur les articles en vente basée sur le prix demandé. Si le montant de la vente est inférieur à une valeur prédéfinie (100 $), alors pas de frais sont facturés. Pour en savoir plus sur le processus de vente, il suffit de cliquer ici. «Comment vendre avec ce site.\"\"\r\n\r\nModifier l\'article Vente à voir / modifier sélectionnez \"\"Mon Booth\"\" sur le menu du haut. Sélectionnez le \'Plus\' icône dans la section plus tard la vente. L\'écran à venir permettra d\'afficher tous vos ajouts vente. Pour modifier une vente, sélectionnez le titre de la rangée à vendre. Dans l\'écran suivant, modifier les détails de vente et de sélectionner «Update» pour le finaliser.\r\n\r\nPour supprimer une vente-sélectionner \"\"Supprimer\"\". Comme un mot de prudence, s\'il vous plaît assurez-vous que vous supprimez le bon article car cette action est irréversible.\"\r\n'),(121,42,5,'gestionar Venta ','\"Todos los usuarios registrados pueden agregar un elemento a la venta.\r\n\r\nAñadir un artículo para la venta, para agregar un elemento a la venta con este sitio, sólo tienes que seleccionar el enlace \"\"Añadir Venta\"\" en la sección de menú de la izquierda. La siguiente pantalla se deberá indicar el título, nombre, precio, etc Usted puede agregar un elemento que aparece mediante el pago de un importe nominal de la misma obra. Un elemento destacado mostrará por primera vez en la lista de venta con una apariencia diferente. Usted tiene que pagar una comisión muy insignificante en la venta de artículos basados &#8203;&#8203;en el precio de venta. Si el importe de la venta es menor que una cantidad preestablecida ($ 100), entonces no se cobren honorarios. Para saber más sobre el proceso de venta, haga click aquí. \'Cómo vender con este sitio.\r\n\r\nEdición de Venta de Artículo para ver / editar seleccione la opción \'Mi stand\' en el menú superior. Seleccione la opción \'Más\' icono en la sección de venta más reciente adición. La pantalla mostrará todos los futuros de las adiciones a su venta. Para editar una venta, seleccione el título cerca de la fila de venta. En la siguiente pantalla, editar los detalles de la venta y seleccione \'Actualizar\' para finalizarlo.\r\n\r\nPara eliminar una venta-seleccione \'Eliminar\'. Como una palabra de advertencia, por favor asegúrese de que está eliminando el elemento de derecho ya que esta acción es irreversible.\"\r\n'),(122,42,6,'verwalten Sale ','\"Alle registrierten Benutzer können ein Objekt zu verkaufen.\r\n\r\nFügen Sie einen Artikel zum Verkauf-auf einen Artikel zum Verkauf mit dieser Website hinzuzufügen, wählen Sie einfach die \'Add Sale \"\"-Link in der linken Menüfeld. Der folgende Bildschirm wird den Titel, Name, Preis, etc. Sie ein Element hinzufügen kann als durch Zahlung einer nominalen Betrag der Website selbst featured. Ein featured Artikel wird erst zeigen, in den Verkauf Auflistung mit einem anderen Aussehen. Sie haben eine sehr vernachlässigt Provision auf den Verkauf Gegenstände auf den geforderten Preis berechnet wird. Wenn der Betrag aus dem Verkauf ist weniger als eine vorgegebene Menge ($ 100), dann werden keine Gebühren erhoben. Um mehr zu erfahren über den Verkauf Prozess, klicken Sie einfach hier. \"\"Wie man mit dieser Website Sell\"\".\r\n\r\nBearbeiten Sale Item-to view / edit wählen Sie die \'My Booth\' in der oberen Menüleiste. Wählen Sie das \"\"Mehr\"\"-Symbol unter dem aktuellen Verkauf hinaus Abschnitt. Die kommende Bildschirm zeigt alle Ihre Veräußerung Ergänzungen. So bearbeiten Sie einen Verkauf, wählen Sie den Titel in der Nähe der Verkauf Reihe. In den nächsten Bildschirm, bearbeiten den Verkauf Details und wählen Sie \'Update\', um es fertig zu stellen.\r\n\r\nZum Löschen eines Sale-Option \"\"Löschen\"\". Als ein Wort der Vorsicht, bitte stellen Sie sicher, Sie löschen die richtige Position, da diese Aktion nicht rückgängig gemacht werden.\"\r\n'),(124,41,5,'editar perfil ','\"Para editar el perfil, haga clic en el enlace \"\"Editar perfil\"\" en el menú de la izquierda section.In la consiguiente editar los detalles y haga clic en \"\"Guardar cambios\"\"\r\n\r\n\r\n<b>cambiar la contraseña</b>\r\n    Para cambiar la contraseña, haga clic en \'Editar perfil\' en el menú de la izquierda section.In la pantalla subsiguiente introduzca la contraseña antigua en field.Enter la \'Contraseña anterior\' la nueva contraseña en el campo \"\"Contraseña Nueva\"\" y confirmar que repitiéndola en el campo \"\"Confirm Password\"\". Tanto las contraseñas deben coincidir con la contraseña y se actualizarán a la nueva contraseña introducidos.\"\r\n'),(125,41,6,'Profil bearbeiten ','\"So bearbeiten Sie Profil, auf \"\"Profil bearbeiten\"\" Link in der linken Navigation section.In der anschließenden klicken Sie die Details bearbeiten und klicken Sie auf \"\"Änderungen speichern\"\"\r\n\r\n\r\n<b>Passwort ändern</b>\r\n    So ändern Sie das Passwort ein, klicken Sie auf \"\"Profil bearbeiten\"\"-Link im Menü links section.In den folgenden Bildschirm geben Sie das alte Passwort in der \"\"Old password \'field.Enter das neue Passwort in der\"\" New Password \"\"ein und bestätigen Sie es, indem Sie es in der \"\"Kennwort bestätigen\"\" ein. Sowohl die Passwörter sollten übereinstimmen und das Passwort wird an die neu eingegebene Passwort aktualisiert.\"\r\n'),(126,40,2,'Connexion ','\"Pour accéder à la zone de ce site utilisateur, cliquez sur «Login» lien dans la section menu du haut.\r\nEntrez le nom d\'utilisateur et mot de passe. Sur vérifier vos références correctement, vous serez redirigé vers le panneau principal. Panneau principal se divise en sept section.\r\n\r\n\r\nAjouts 1.Latest Vente Vos plus tard la vente peuvent être affichés et gérés à partir de ce section.Maximum de cinq Outre la vente seront inscrits dans cette section. Si vous souhaitez gérer tous vos Outre la vente de cliquer sur \"\"plus\"\" icône sur le coin inférieur droit.\r\nGérer Vente\r\nAjouts 2.Latest échanger votre dernier ajout de swap peut être affichées et gérées à partir de ce section.Maximum plus de cinq swap seront répertoriés dans cette section. Si vous souhaitez gérer tous vos ajouts swap de cliquer sur \"\"plus\"\" icône sur le coin inférieur droit.\r\nGérer swap de\r\n3.Latest souhaitent ajouts Votre plus tard le souhaitent peuvent être affichées et gérées à partir de ce section.Maximum de cinq désirez plus seront répertoriés dans cette section. Si vous souhaitez gérer tous vos ajouts souhaite cliquez sur \'plus\' icône sur le coin inférieur droit.\r\nGérer souhaitent\r\n4.My Offres Toutes les offres d\'échange / souhaitons que vous avez fait jusqu\'à présent peuvent être consultés et de gérer à partir de ce section.Maximum de cinq offres seront répertoriés dans cette section. Si vous souhaitez gérer tous vos swap / souhaitez vous propose de cliquer sur \"\"plus\"\" icône sur le coin inférieur droit.\r\nGestion des offres\r\n5.Offers pour moi tout swap / souhaitez vous propose pour vous peut être consulté et géré à partir de ce section.Maximum de cinq offres seront répertoriés dans cette section. Si vous souhaitez gérer tous les swap / souhaitez vous propose de vous cliquez sur \"\"plus\"\" icône sur le coin inférieur droit.\r\nGestion des offres\r\nVente 6.My Toutes les offres vente offre que vous avez fait jusqu\'ici peuvent être affichées et gérées à partir de ce section.Maximum de cinq offres de vente seront inscrits dans cette section. Si vous souhaitez gérer toutes vos offres de vente de cliquer sur \"\"plus\"\" icône sur le coin inférieur droit.\r\nGestion des offres\r\n7.Sale Offres pour moi Tous les offres de vente pour vous peut être consulté et géré à partir de ce section.Maximum de cinq offres seront répertoriés dans cette section. Si vous souhaitez gérer toutes les offres de vente que vous cliquez sur \"\"plus\"\" icône sur le coin inférieur droit.\r\nGestion des offres\"\r\n'),(127,40,5,'Inicio de sesión ','\"Para acceder al área del sitio del usuario, haga clic en \"\"Iniciar sesión\"\" enlace en la sección superior del menú.\r\nEscriba el nombre de usuario y contraseña. En la verificación de sus credenciales correctamente, se le redirigirá al panel principal. Panel principal se divide en siete sección.\r\n\r\n\r\n1.Latest adiciones venta su más reciente adición de venta pueden ser vistos y gestionados desde este section.Maximum Además de la venta cinco serán incluidos en esta sección. Si quieres administrar todas tus además de la venta haga click en \"\"más\"\" situado en la esquina inferior derecha.\r\nGestionar Venta\r\n2.Latest adiciones canje de su más reciente adición de intercambio puede ser visto y manejado de esta section.Maximum Además de swap cinco serán incluidos en esta sección. Si quieres administrar todas sus adiciones swap haga clic en \"\"más\"\" situado en la esquina inferior derecha.\r\nAdministrar intercambio\r\n3.Latest desea adiciones Su última incorporación desea se puede ver y administrar desde esta section.Maximum de cinco deseen Además se incluirán en esta sección. Si quieres administrar todas sus adiciones desea hacer clic en \"\"más\"\" situado en la esquina inferior derecha.\r\nGestionar desea\r\n4.My Ofertas Todas las ofertas de canje / deseo que usted ha hecho hasta el momento se pueden ver y gestionar desde este section.Maximum de cinco ofertas se incluirán en esta sección. Si desea gestionar todos los swap / deseo ofrece haga clic en \"\"más\"\" situado en la esquina inferior derecha.\r\nGestionar las ofertas\r\n5.Offers Para mí todos los swap / deseo ofrece para que usted puede ver y administrar desde esta section.Maximum de cinco ofertas se incluirán en esta sección. Si desea administrar todos los swap / deseo ofrece para que usted haga clic en \"\"más\"\" situado en la esquina inferior derecha.\r\nGestionar las ofertas\r\nVenta 6.My ofrece todas las ofertas de venta que ha realizado hasta el momento se puede ver y administrar desde esta section.Maximum de cinco ofertas de venta serán incluidos en esta sección. Si quieres administrar todas sus ofertas de venta, haga clic en \"\"más\"\" situado en la esquina inferior derecha.\r\nGestionar las ofertas\r\n7.Sale Ofertas para mí todas las ofertas de venta para usted puede ser visto y manejado de esta section.Maximum de cinco ofertas se incluirán en esta sección. Si desea administrar todas las ofertas de venta para que usted haga clic en \"\"más\"\" situado en la esquina inferior derecha.\r\nGestionar las ofertas\"\r\n'),(128,40,6,'Logging in ','\"Zum Zugriff auf die dieser Website User-Bereich, klicken Sie auf \"\"Anmelden\"\" Link im oberen Menü-Abschnitt.\r\nGeben Sie den Benutzernamen und das Passwort. Auf der Überprüfung Ihrer Anmeldedaten korrekt, werden Sie zu den wichtigsten Panel umgeleitet werden. Main-Panel teilt sich in sieben Kapitel.\r\n\r\n\r\n1.Latest Sale Ergänzungen Ihre letzte Verkauf zusätzlich angezeigt und können von diesem section.Maximum von fünf Verkauf Zusätzlich verwaltet werden in diesem Abschnitt aufgeführt werden. Wenn Sie verwalten möchten all Ihren Verkauf hinaus auf \"\"mehr\"\"-Symbol auf der rechten unteren Ecke klicken.\r\nVerwalten Sale\r\n2.Latest Swap Ergänzungen Ihre letzte Swap zusätzlich angezeigt und können von diesem section.Maximum von fünf Swap Zusätzlich verwaltet werden in diesem Abschnitt aufgeführt werden. Wenn Sie verwalten möchten all Ihre Swap-Ergänzungen auf \"\"mehr\"\"-Symbol auf der rechten unteren Ecke klicken.\r\nVerwalten von Swap-\r\n3.Latest wünschen Ergänzungen Ihre letzte Wunsch zusätzlich angezeigt und können von diesem section.Maximum von fünf verwaltet werden wollen zusätzlich in diesem Abschnitt aufgelistet. Wenn Sie verwalten möchten all Ihre Wünsche Ergänzungen auf \"\"mehr\"\"-Symbol auf der rechten unteren Ecke klicken.\r\nVerwalten Sie wünschen\r\n4.My Angebote Alle swap / Wunsch bietet Ihnen bisher gemachten eingesehen werden darf und Verwaltung von dieser section.Maximum von fünf Angebote werden in diesem Abschnitt aufgeführt werden. Wenn Sie alle Ihre Swap-manage / wünschen möchten, bietet Klick auf \"\"mehr\"\"-Symbol auf der rechten unteren Ecke.\r\nVerwalten Sie bietet\r\n5.Bestellungen Für mich All swap / möchten, bietet Ihnen eingesehen und verwaltet werden aus diesem section.Maximum von fünf Angebote werden in diesem Abschnitt aufgeführt werden. Wenn Sie alle Swap verwalten wollen / möchten, bietet Ihnen auf \"\"mehr\"\"-Symbol auf der rechten unteren Ecke klicken.\r\nVerwalten Sie bietet\r\n6.My Sale bietet All Verkauf bietet Ihnen so weit kann eingesehen werden gemacht haben und verwaltet diese section.Maximum von fünf Verkaufsangebote werden in diesem Abschnitt aufgeführt werden. Wenn Sie verwalten möchten alle Ihre Verkaufsangebote klicken Sie auf \"\"mehr\"\"-Symbol auf der rechten unteren Ecke.\r\nVerwalten Sie bietet\r\n7.Sale Angebote für mich Alles verkaufen Angebote für Sie angezeigt und verwaltet werden aus diesem section.Maximum von fünf Angebote werden in diesem Abschnitt aufgeführt werden. Wenn Sie verwalten möchten alle Verkaufsangebote für Sie auf \"\"mehr\"\"-Symbol auf der rechten unteren Ecke.\r\nVerwalten Sie bietet\"\r\n'),(129,39,2,'Inscrivez-vous à Eswaps ','L\'inscription à cette plate-forme du site swapping est facile et rapide. Aller à la page d\'inscription (généralement à http://yoursite.com/register.php) en supposant que le site est installé à cet http://yoursite.com) et fournir les renseignements requis de base.\r\n'),(130,39,5,'Se registra en Eswaps ','Registrarse en la plataforma del sitio de intercambio es fácil y rápido. Ir a la página de registro (por lo general en http://yoursite.com/register.php), suponiendo que el sitio esté instalado en http://yoursite.com) y proporcionar la información básica requerida.\r\n'),(131,39,6,'Registrieren Sie sich bei Eswaps ','Die Anmeldung bei dieser Website Swapping-Plattform ist einfach und schnell. Gehen Sie auf die Registrierungsseite (typischerweise bei http://yoursite.com/register.php) unter der Annahme, dass die dieser Site http://yoursite.com installiert ist) und die erforderlichen Basisinformationen.\r\n'),(140,14,5,'',''),(141,14,6,'',''),(142,13,2,'',''),(143,13,5,'',''),(144,13,6,'',''),(145,61,2,'',''),(146,61,5,'',''),(147,61,6,'',''),(150,72,1,'dfgdf','gdfgdfg'),(151,72,5,'',''),(174,88,1,'erter','tretert'),(154,74,1,'jmkhy','mkjkk'),(155,74,5,'',''),(159,43,8,'',''),(160,50,8,'',''),(161,36,8,'','');

--
-- Table structure for table `es_helpcategory`
--

CREATE TABLE `es_helpcategory` (
  `nHcId` int(11) NOT NULL AUTO_INCREMENT,
  `vHtype` varchar(6) DEFAULT NULL,
  `nHcposition` int(11) DEFAULT NULL,
  `vActive` enum('0','1') DEFAULT NULL,
  PRIMARY KEY (`nHcId`)
) ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_helpcategory`
--

INSERT INTO `es_helpcategory` VALUES (1,'admin',2,'1'),(3,'admin',0,'1'),(4,'admin',1,'1'),(6,'admin',3,'1'),(7,'admin',4,'1'),(8,'admin',5,'1'),(9,'admin',6,'1'),(10,'admin',7,'1'),(12,'admin',8,'1'),(13,'admin',9,'1'),(14,'admin',10,'1'),(15,'admin',11,'1'),(16,'admin',12,'1'),(18,'admin',13,'1'),(19,'client',15,'1'),(20,'client',16,'1'),(21,'client',14,'1'),(31,'client',17,'1'),(32,'client',18,'1'),(33,'client',19,'1'),(35,'admin',20,'1'),(36,'client',21,'1'),(38,'client',23,'1'),(39,'client',24,'1'),(51,'admin',29,'1'),(52,'client',30,'1');

--
-- Table structure for table `es_helpcategory_lang`
--

CREATE TABLE `es_helpcategory_lang` (
  `help_cat_lang_id` int(11) NOT NULL AUTO_INCREMENT,
  `help_cat_id` int(11) NOT NULL COMMENT 'help category id',
  `lang_id` int(11) NOT NULL COMMENT 'language id',
  `vHctitle` varchar(100) NOT NULL COMMENT 'help category name',
  PRIMARY KEY (`help_cat_lang_id`)
) ENGINE=MyISAM AUTO_INCREMENT=123 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `es_helpcategory_lang`
--



--
-- Table structure for table `es_lang`
--

CREATE TABLE `es_lang` (
  `lang_id` int(11) NOT NULL AUTO_INCREMENT,
  `lang_name` varchar(100) NOT NULL COMMENT 'language name',
  `folder_name` varchar(100) NOT NULL COMMENT 'language folder name',
  `flag_file` varchar(100) NOT NULL COMMENT 'flag file name',
  `lang_status` enum('y','n') NOT NULL DEFAULT 'y' COMMENT 'status',
  `country_abbrev` text NOT NULL COMMENT 'country abbreviations for ip search',
  PRIMARY KEY (`lang_id`),
  UNIQUE KEY `lang_name` (`lang_name`),
  UNIQUE KEY `folder_name` (`folder_name`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `es_lang`
--

INSERT INTO `es_lang` VALUES (1,'English','en','1309175744_flag.png','y','US,UK'),(2,'French','fr','1309178676_flag.gif','y','FR'),(5,'Spanish','es','1313581288_flag.png','y','ES'),(10,'Italian','it','1496394241_flag.jpg','y','it'),(6,'German','de','1313581399_flag.gif','y','DE');

--
-- Table structure for table `es_listingfee`
--

CREATE TABLE `es_listingfee` (
  `nLId` int(11) NOT NULL AUTO_INCREMENT,
  `nFrom` double NOT NULL DEFAULT '0',
  `nTo` double NOT NULL DEFAULT '0',
  `above` bigint(20) NOT NULL,
  `nPrice` double NOT NULL DEFAULT '0',
  `vActive` enum('0','1') NOT NULL DEFAULT '0',
  `nLPosition` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`nLId`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_listingfee`
--

INSERT INTO `es_listingfee` VALUES (15,0,0,23,1,'1',2),(14,0,23,0,1,'1',1);

--
-- Table structure for table `es_lookup`
--

CREATE TABLE `es_lookup` (
  `nLookUpCode` varchar(100) DEFAULT NULL,
  `vLookUpDesc` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_lookup`
--

INSERT INTO `es_lookup` VALUES ('1','Cheque'),('1','Demand Draft'),('1','Cash'),('2','21232f297a57a5a743894a0e4a801fc3'),('3','5'),('4','babitha.a@armiasystems.com'),('5','4'),('6','Friend/Relative'),('6','Another Site'),('6','Search Engine'),('6','Newspaper Ad'),('7','0.99'),('8','100'),('9','0'),('10','0'),('14',''),('15','0'),('16','0000-00-00'),('adminname','admin'),('sitelogo','old_logo_sample.png'),('sitestyle','Antique/style.css'),('paypalemail','armiaseller@jeeva.org'),('paypalauthtoken','mFRXqntEalflklLqPAelx80iuuQT-cFP4hXpQBU1MEVCsTyC2bg4TF_Pddm'),('paypalmode','TEST'),('paypalsupport','YES'),('authloginid',' 53Ms4dJJ'),('authloginpass','authpass'),('authlogintranskey','48fZfz7546Gxw6K3'),('authemail','mahesh.s@armia.com'),('authmode','TEST'),('userapproval','E'),('authsupport','YES'),('googleaddemo','yes'),('googleadvalue','\r\n\r\n'),('bookmark_enable','Yes'),('bookmark_value','<script type=\"text/javascript\" src=\"http://s7.addthis.com/js/250/addthis_widget.js#pubid=ajiabs\"></script>\r\n<div class=\"addthis_button\"></div>\r\n'),('plan_system','yes'),('feedname','Yes'),('surl','http://localhost/eswap'),('MaxOfImages','8'),('BannerDisplay','Yes'),('ThumbToolTip','Yes'),('SessionTimeout','86400'),('Enable Escrow','No'),('yourpaysupport','NO'),('yourpaymode','TEST'),('yourpaystoreid','1909707954'),('yourpaypemfile','1909707954.pem'),('googlesupport','NO'),('googlemode','TEST'),('googleid','643760143118924'),('googlekey','jk0ACPM8RdntndpuFbqjew'),('currency','$'),('currencycode','USD'),('otherpayment','YES'),('vLicenceKey','324234'),('PointValue','1'),('EnablePoint','2'),('PointValue2','1'),('PointTransfer','1'),('freeTransactionsPerMonth','1'),('welcomeImage','1-@brive47-600x600_thumb.jpg'),('SuccessFee','10'),('language_by_ip','yes'),('EscrowCommissionType','No'),('EscrowFixed','10'),('Listing Type','1'),('enableworldpay','N'),('worldpaydemo','NO'),('worldpayid','sdf'),('worldpayemail','sdf'),('worldpaytransmode','A'),('PaymentMethod','CC'),('enablebluepay','N'),('bluepaydemo','YES'),('bluepayid','100042832485'),('bluepaykey','SLGGGBIIQQE7M3TPJX7PHILS5HXDODIG');

--
-- Table structure for table `es_mandatory`
--

CREATE TABLE `es_mandatory` (
  `nManFieldId` bigint(20) NOT NULL AUTO_INCREMENT,
  `vManFieldName` varchar(200) DEFAULT 'vFieldName',
  `vManLabelName` varchar(200) DEFAULT 'Field Name',
  `vManFieldType` char(2) DEFAULT 'TB',
  `vManStatus` char(1) DEFAULT 'N',
  `vActiveStatus` char(1) DEFAULT 'A',
  `nOrder` int(2) DEFAULT '0',
  PRIMARY KEY (`nManFieldId`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_mandatory`
--



--
-- Table structure for table `es_messages`
--

CREATE TABLE `es_messages` (
  `nMsgId` int(11) NOT NULL AUTO_INCREMENT,
  `nToUserId` int(11) DEFAULT '0',
  `nFromUserId` int(11) DEFAULT '0',
  `vTitle` tinytext,
  `vMsg` text,
  `vStatus` enum('Y','N') DEFAULT 'N',
  `nDate` date DEFAULT '0000-00-00',
  `vToDel` enum('Y','N') DEFAULT 'N',
  `vFromDel` enum('Y','N') DEFAULT 'N',
  PRIMARY KEY (`nMsgId`)
) ENGINE=MyISAM AUTO_INCREMENT=197 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_messages`
--

INSERT INTO `es_messages` VALUES (1,2,1,'Tesitng','Tesitng','Y','2010-06-10','N','Y'),(2,5,1,'tesing','testing','N','2010-09-01','N','N'),(3,1,2,'dd','dd','Y','2010-12-29','N','N'),(4,21,22,'hi','hihi','Y','2011-08-02','Y','Y'),(5,21,22,'hi','hihihihi','Y','2011-08-02','N','N'),(6,21,22,'hi2','hi2','Y','2011-08-02','N','N'),(7,21,22,'3','33','Y','2011-08-02','N','N'),(8,21,22,'4','4','Y','2011-08-02','N','N'),(9,57,37,'asdasd','adasd','N','2012-03-10','N','N'),(10,37,1,'The test message from william','The test message from william','Y','2012-04-10','Y','N'),(11,57,1,'Hi this is a test message','Hi this is a test message','N','2012-04-10','N','N'),(12,57,1,'hi this is a test message','hi this is a test message','N','2012-04-10','N','N'),(13,57,1,'Test the message by william','Test the message by william','N','2012-04-10','N','N'),(14,2,1,'Re: dd','This is a test message \r\n                                                                                           ----- Original Message -----\r\n                                                                                    dd','N','2012-04-10','N','N'),(15,37,78,'Hi','This is a new message for you!','Y','2012-05-03','N','N'),(16,104,106,'hai','halo','Y','2013-11-15','N','N'),(17,91,115,'feedback1','Lorem ipsum dollat sit amet Lorem ipsum dollat sit amet Lorem ipsum dollat sit amet Lorem ipsum dollat sit amet Lorem ipsum dollat sit amet Lorem ipsum dollat sit amet Lorem ipsum dollat sit amet Lorem ipsum dollat sit amet Lorem ipsum dollat sit amet Lorem ipsum dollat sit amet Lorem ipsum dollat sit amet Lorem ipsum dollat sit amet Lorem ipsum dollat sit amet Lorem ipsum dollat sit amet ','N','2014-10-16','N','N'),(18,32,115,'testing','test msg 2test msg 2test msg 2test msg 2test msg 2test msg 2test msg 2test msg 2test msg 2','N','2014-10-16','N','N'),(19,115,21,'nice product','nice product i want to buy','Y','2014-10-16','N','N'),(20,21,115,'Re: nice product','								----- Original Message -----\r\n								nice product i want to buy','N','2014-10-23','N','Y'),(21,12,111,'dsdsfsdf','sdfsfsfsdf','N','2015-03-23','N','N'),(22,111,12,'dfsdf','sdfsdf','Y','2015-04-13','N','N'),(23,12,111,'Furniture purchase','I would like to buy it.','N','2015-04-16','N','N'),(24,12,111,'Hi','hi','N','2015-04-16','N','N'),(25,12,111,'Hi','hi','N','2015-04-16','N','N'),(26,12,111,'test','test','N','2015-04-20','N','N'),(27,12,111,'dfgdf','gfdgdfg','N','2015-04-20','N','N'),(28,110,111,'fsdf','dfsfsd','N','2015-04-20','N','N'),(29,12,111,'gfhgf','ghfhgf','N','2015-04-20','N','N'),(30,120,111,'gfh','gfh','Y','2015-04-20','N','N'),(31,120,111,'asdf','asdfa','Y','2015-04-20','N','N'),(32,120,111,'sadfa','sdfasd','Y','2015-04-20','N','N'),(33,120,111,'df','gdfg','Y','2015-04-20','N','N'),(34,120,111,'fgfd','gdg','N','2015-04-20','N','N'),(35,91,111,'gd','fgdf','N','2015-04-20','N','N'),(36,91,111,'df','gdfg','N','2015-04-20','N','N'),(37,12,111,'sdf','dsf','N','2015-04-20','N','N'),(38,12,111,'df','gsdfg','N','2015-04-20','N','N'),(39,110,111,'asdf','asdfa','N','2015-04-20','N','N'),(40,120,111,'sdf','sdf','N','2015-04-20','N','N'),(41,120,111,'sd','fsdf','Y','2015-04-20','N','N'),(42,120,111,'dsf','dsf','N','2015-04-20','N','N'),(43,120,111,'gf','dgfdg','N','2015-04-20','N','N'),(44,120,111,'gf','dgfdg','N','2015-04-20','N','N'),(45,120,111,'dsf','af','N','2015-04-20','N','N'),(46,120,111,'df','gdfg','N','2015-04-20','N','N'),(47,120,111,'gfh','gfh','N','2015-04-20','N','N'),(48,120,111,'asdf','sdfas','N','2015-04-20','N','N'),(49,120,111,'asdf','sdfas','N','2015-04-20','N','N'),(50,120,111,'asdf','asdf','N','2015-04-20','N','N'),(51,120,111,'sdfsd','fsdf','N','2015-04-20','N','N'),(52,120,111,'dsf','sdf','N','2015-04-20','N','N'),(53,120,111,'yhj','ghj','N','2015-04-20','N','N'),(54,120,111,'yhj','ghj','N','2015-04-20','N','N'),(55,12,111,'asdf','asdf','N','2015-04-20','N','N'),(56,12,111,'sdf','sdf','N','2015-04-20','N','N'),(57,111,120,'Re: gfh','						----- Original Message -----\r\n						gfh','Y','2015-04-23','N','N'),(58,111,120,'Re: sadfa','						----- Original Message -----\r\n						sdfasd','N','2015-04-23','N','N'),(59,111,120,'Re: gfh','----- Original Message -----gfh','Y','2015-05-11','Y','N'),(60,12,111,'gdf','gdfg','N','2015-05-12','N','N'),(61,137,111,'df','dsf','N','2015-05-12','N','N'),(62,137,111,'sdfsd','dsf','N','2015-05-12','N','N'),(63,137,111,'dfg','dfg','N','2015-05-12','N','N'),(64,137,111,'fdg','dfgdfg','N','2015-05-12','N','N'),(65,137,111,'sdfsd','dfdsf','N','2015-05-12','N','N'),(66,115,0,'test','test','N','2015-05-20','N','N'),(67,111,0,'test','test','Y','2015-05-20','Y','N'),(68,115,0,'Test','Test','N','2015-05-20','N','N'),(69,104,0,'test','test','N','2015-05-20','N','N'),(70,111,0,'Test','Test','Y','2015-05-20','N','N'),(71,111,0,'Great','Great','Y','2015-05-20','Y','N'),(72,111,0,'Great','Great','N','2015-05-20','N','N'),(73,111,0,'Testing','Testing','N','2015-05-20','N','N'),(74,111,0,'Testing','Testing','N','2015-05-20','N','N'),(75,111,0,'Testing','Testing','Y','2015-05-20','Y','N'),(76,111,0,'Hii','How are you?','N','2015-05-20','N','N'),(77,115,0,'asdasd','asdasd','N','2015-05-20','N','N'),(78,115,0,'asdasd','asdasd','N','2015-05-20','N','N'),(79,112,0,'adsd','sdfdfgfd','N','2015-05-20','N','N'),(80,111,0,'This is the latest one','This is the latest one','Y','2015-05-20','Y','N'),(81,111,0,'New','Test','N','2015-05-20','N','N'),(82,111,0,'asdds','sdfsfdf','Y','2015-05-20','Y','N'),(83,115,0,'Testin','Testing','N','2015-05-20','N','N'),(84,110,0,'Testing','Testing','N','2015-05-20','N','N'),(85,137,0,'hii','hello','N','2015-07-02','N','N'),(86,137,0,'iiui','ijku','N','2015-07-03','N','N'),(87,12,111,'dddddddddde','dede','N','2015-07-03','N','Y'),(88,137,111,'hhi','fvfcvdr','N','2015-07-03','N','Y'),(89,139,111,'hi','i want the clock','N','2015-07-03','N','Y'),(90,137,111,'xaS','aswsw','N','2015-07-03','N','N'),(91,137,111,'rtgg','rrrt','N','2015-07-03','N','N'),(92,139,111,'df','dsf','N','2015-07-03','N','N'),(93,12,111,'df','sddf','N','2015-07-03','N','N'),(94,12,0,'fgh','dfg','N','2015-07-03','N','N'),(95,114,111,'dfg','dfgv','N','2015-07-03','N','N'),(96,120,111,'f','frcvfr','N','2015-07-03','N','N'),(97,114,111,'gfh','gbtg','N','2015-07-03','N','N'),(98,12,3,'xfg','dgdfg','N','2015-07-03','N','N'),(99,137,111,'f','fv','N','2015-07-03','N','N'),(100,137,3,'dfgdfg','sfsdgdg','N','2015-07-03','N','N'),(101,12,111,'rg','rf','N','2015-07-03','N','N'),(102,137,111,'aer','awer','N','2015-07-03','N','N'),(103,120,111,'o','o','N','2015-07-03','N','N'),(104,137,139,'ee','ede','N','2015-07-03','N','N'),(105,137,111,'rt','tt','N','2015-07-03','N','N'),(106,12,139,'e','we','N','2015-07-03','N','N'),(107,12,139,'f','f','N','2015-07-03','N','N'),(108,12,139,'fvb','fv','N','2015-07-03','N','N'),(109,137,139,'ed','e','N','2015-07-03','N','N'),(110,137,0,'hi','nice product','N','2015-07-16','N','N'),(111,137,0,'d','df','N','2015-07-16','N','N'),(112,137,0,'sdf','','N','2015-07-16','N','N'),(113,137,0,'dfg','dfv','N','2015-07-16','N','N'),(114,137,0,'hu','ijij','N','2015-07-16','N','N'),(115,137,111,'sxs','saad','N','2015-07-26','N','N'),(116,137,111,'ed','aS','N','2015-07-26','N','N'),(117,137,0,'D','SD','N','2015-07-26','N','N'),(118,137,111,'dcd','dcsd','N','2015-07-26','N','N'),(119,114,111,'test','test','N','2015-11-17','N','N'),(120,114,111,'sas','sas','N','2015-11-17','N','N'),(121,137,111,'test','testingg','N','2015-11-17','N','N'),(122,137,111,'dsd','sd','N','2015-11-17','N','N'),(123,137,111,'sa','sas','N','2015-11-17','N','N'),(124,137,111,'dsa','dasd','N','2015-11-17','N','N'),(125,115,111,'fds','fdsf','N','2015-11-17','N','N'),(126,114,0,'ds','dsad','N','2015-11-17','N','N'),(127,139,0,'dsa','dsad','N','2015-11-17','N','N'),(128,1,0,'TEst','test messagesdasd','N','2016-04-26','N','N'),(129,1,0,'aasdsd','asdasd','N','2016-04-26','N','N'),(130,1,0,'dsfdf','sdfsdf','N','2016-04-26','N','N'),(131,1,0,'dsfsd','fsdfsdf','N','2016-04-26','N','N'),(132,1,0,'werwer','werwer','N','2016-04-26','N','N'),(133,1,0,'sdfsdf','sdfsdf','N','2016-04-26','N','N'),(134,1,0,'xdf','dfsdfs','N','2016-04-26','N','N'),(135,1,0,'sdfsf','sdfsdf','N','2016-04-26','N','N'),(136,1,0,'asdas','dasdasd','N','2016-04-26','N','N'),(137,1,0,'asdas','dasdasd','N','2016-04-26','N','N'),(138,1,0,'sdfsd','fsdfsd','N','2016-04-26','N','N'),(139,1,0,'ddd','ddd','N','2016-04-26','N','N'),(140,1,0,'dsfs','dfsdf','N','2016-04-26','N','N'),(141,1,0,'dsfs','dfsdf','N','2016-04-26','N','N'),(142,1,0,'sdasd','sdas','N','2016-04-26','N','N'),(143,1,0,'d','d','N','2016-04-26','N','N'),(144,1,0,'dfgsdf','sdfsdf','N','2016-04-27','N','N'),(145,1,0,'test','tset','N','2016-04-27','N','N'),(146,1,0,'eddfsdf','sdfsd','N','2016-04-27','N','N'),(147,1,0,'sdf','sdfsdf','N','2016-04-27','N','N'),(148,1,0,'sdas','dasdasd','N','2016-04-27','N','N'),(149,1,0,'sdas','dasd','N','2016-04-27','N','N'),(150,1,0,'sdfs','dfsdf','N','2016-04-27','N','N'),(151,1,0,'sdf','sdfsdf','Y','2016-04-27','N','N'),(152,1,0,'dsf','sdf','N','2016-04-27','N','N'),(153,1,0,'testsdf','tsetsdfsdf','N','2016-04-27','N','N'),(154,1,0,'s','s','N','2016-04-27','N','N'),(155,1,0,'s','sss','N','2016-04-27','N','N'),(156,1,0,'dff','dfdfg','N','2016-04-27','N','N'),(157,1,0,'n','b','N','2016-04-27','N','N'),(158,1,0,'d','d','N','2016-04-27','N','N'),(159,1,0,'sd','asdad','N','2016-04-27','N','N'),(160,1,0,'s','s','N','2016-04-27','N','N'),(161,1,0,'q','q','N','2016-04-27','N','N'),(162,1,0,'s','s','N','2016-04-27','N','N'),(163,1,0,'d','d','N','2016-04-27','N','N'),(164,1,0,'a','s','N','2016-04-27','N','N'),(165,1,0,'s','a','N','2016-04-27','N','N'),(166,1,0,'a','s','N','2016-04-27','N','N'),(167,1,0,'q','q','N','2016-04-27','N','N'),(168,1,0,'m','m','N','2016-04-27','N','N'),(169,1,0,'d','d','N','2016-04-27','N','N'),(170,1,0,'sa','AD','N','2016-04-27','N','N'),(171,1,0,'V','V','N','2016-04-27','N','N'),(172,1,0,'v','v','N','2016-04-27','N','N'),(173,1,0,'g','g','N','2016-04-27','N','N'),(174,1,0,'mj','mj','N','2016-04-27','N','N'),(175,1,0,'b','b','N','2016-04-27','N','N'),(176,1,0,'mj','mj','N','2016-04-27','N','N'),(177,1,0,'mj','mj','N','2016-04-27','N','N'),(178,1,0,'v','v','N','2016-04-27','N','N'),(179,1,0,'mj','mj','N','2016-04-27','N','N'),(180,137,0,'gt','gt','N','2016-04-27','N','N'),(181,1,0,'dd','ddd','N','2016-04-27','N','N'),(182,1,0,'d','d','N','2016-04-27','N','N'),(183,111,0,'s','s','N','2016-04-27','N','N'),(184,8,0,'nh','nh','N','2016-04-27','N','N'),(185,1,0,'nh','nh','N','2016-04-27','N','N'),(186,1,0,'bg','bg','N','2016-04-27','N','N'),(187,1,0,'n','nh','N','2016-04-27','N','N'),(188,1,0,'nh','nh','N','2016-04-27','N','N'),(189,103,0,'fg','dfgd','N','2016-04-27','N','N'),(190,1,0,'ghfg','hfghfgh','N','2016-04-27','N','N'),(191,103,0,'asda','sdasd','N','2016-04-27','N','N'),(192,103,0,'sd','dasd','N','2016-04-27','N','N'),(193,137,111,'ytuty','uutyut','N','2016-04-27','N','N'),(194,1,0,'asdasd','dasd','N','2016-04-27','N','N'),(195,1,0,'sdfs','dfsdf','N','2016-04-27','N','N'),(196,110,0,'g','g','N','2016-04-27','N','N');

--
-- Table structure for table `es_metatags`
--

CREATE TABLE `es_metatags` (
  `nId` int(11) NOT NULL AUTO_INCREMENT,
  `vPageName` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`nId`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_metatags`
--

INSERT INTO `es_metatags` VALUES (1,'aboutus.php'),(2,'index.php'),(3,'featuredpaypp.php'),(4,'featuredpay.php'),(9,'credit_inte_success.php'),(8,'categorydetail.php'),(10,'failure.php'),(11,'faq.php'),(12,'contactus.php');

--
-- Table structure for table `es_metatags_lang`
--

CREATE TABLE `es_metatags_lang` (
  `meta_lang_id` int(11) NOT NULL AUTO_INCREMENT,
  `meta_id` int(11) NOT NULL COMMENT 'meta id',
  `lang_id` int(11) NOT NULL COMMENT 'language id',
  `vTitle` varchar(200) NOT NULL COMMENT 'meta title',
  `vKeywords` text COMMENT 'meta keywords',
  `vDescription` text COMMENT 'meta description',
  PRIMARY KEY (`meta_lang_id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `es_metatags_lang`
--

INSERT INTO `es_metatags_lang` VALUES (1,2,1,'Swap everything','swap, trade, exchange, swap everything, swapping platform, barter software, virtual swapmeet, swap products, virtual flea market,','eSwap is a online complete swapping platform allowing you to barter unwanted items for things you need. You can swap any unwanted items from home or business to others who may have use for them. You can sell and buy items from site too.'),(2,2,2,'Swap tout','swap, commerce, échange,  tout swap, échangeant plateforme, le troc de logiciels, virtuels swapmeet, les produits d\'échange, marché aux puces virtuel','eSwap est une plate-forme complète en ligne vous permettant d\'échanger les éléments indésirables de troc pour des choses dont vous avez besoin. Vous pouvez échanger tous les éléments indésirables de maison ou votre entreprise à d\'autres quipeuvent avoir besoin d\'eux. Vous pouvez vendre et acheter des objets à partir du siteaussi.\r\n'),(3,2,5,'intercambio de todo','de intercambio, comercio, cambio,  todo intercambio, intercambio deplataforma, el trueque de software, virtual swapmeet, los productos de intercambio,mercado de pulgas virtuales','eSwap es una línea completa plataforma de intercambio que le permite intercambiarelementos no deseados de las cosas que usted necesita. Usted puede cambiarcualquier elemento no deseado de su casa o negocio a otros que pueden hacer uso de ellos. Usted puede vender y comprar artículos en el sitio también.\r\n'),(4,2,6,'Swap alles','Swap-, Handels-, Austausch, tauschen alles, Swapping-Plattform, Tausch-Software, virtuelle swapmeet, Swap-Produkten, virtuellen Flohmarkt\r\n','eSwap ist eine Online-Plattform komplett tauschen so dass Sie unerwünschte Elemente für Dinge, die Sie Tauschhandel. Sie können alle unerwünschten Elemente aus geschäftlichen oder privaten, andere, die für sie haben können Verwendung zu tauschen. Sie können kaufen und verkaufen Gegenstände von der Baustelle zu.\r\n'),(5,11,1,'Swap everything','swap, trade, exchange,  swap everything, swapping platform,  barter software, virtual swapmeet,  swap products,  virtual flea market','eSwap is a  online complete swapping platform allowing you to  barter unwanted items for things you need.  You  can swap any unwanted items from home or business to others who may have use for them. You can sell and buy items from site too.'),(6,11,2,'Swap tout','swap, commerce, échange,  tout swap, échangeant plateforme, le troc de logiciels, virtuels swapmeet, les produits d\'échange, marché aux puces virtuel','eSwap est une plate-forme complète en ligne vous permettant d\'échanger les éléments indésirables de troc pour des choses dont vous avez besoin. Vous pouvez échanger tous les éléments indésirables de maison ou votre entreprise à d\'autres quipeuvent avoir besoin d\'eux. Vous pouvez vendre et acheter des objets à partir du siteaussi.\r\n'),(7,11,5,'intercambio de todo','de intercambio, comercio, cambio,  todo intercambio, intercambio deplataforma, el trueque de software, virtual swapmeet, los productos de intercambio,mercado de pulgas virtuales','eSwap es una línea completa plataforma de intercambio que le permite intercambiarelementos no deseados de las cosas que usted necesita. Usted puede cambiarcualquier elemento no deseado de su casa o negocio a otros que pueden hacer uso de ellos. Usted puede vender y comprar artículos en el sitio también.\r\n'),(8,11,6,'Swap alles','Swap-, Handels-, Austausch, tauschen alles, Swapping-Plattform, Tausch-Software, virtuelle swapmeet, Swap-Produkten, virtuellen Flohmarkt\r\n','eSwap ist eine Online-Plattform komplett tauschen so dass Sie unerwünschte Elemente für Dinge, die Sie Tauschhandel. Sie können alle unerwünschten Elemente aus geschäftlichen oder privaten, andere, die für sie haben können Verwendung zu tauschen. Sie können kaufen und verkaufen Gegenstände von der Baustelle zu.\r\n'),(9,12,1,'Swap everything','swap, trade, exchange,  swap everything, swapping platform,  barter software, virtual swapmeet,  swap products,  virtual flea market','eSwap is a  online complete swapping platform allowing you to  barter unwanted items for things you need.  You  can swap any unwanted items from home or business to others who may have use for them. You can sell and buy items from site too.'),(10,12,2,'Swap tout','swap, commerce, échange,  tout swap, échangeant plateforme, le troc de logiciels, virtuels swapmeet, les produits d\'échange, marché aux puces virtuel','eSwap est une plate-forme complète en ligne vous permettant d\'échanger les éléments indésirables de troc pour des choses dont vous avez besoin. Vous pouvez échanger tous les éléments indésirables de maison ou votre entreprise à d\'autres quipeuvent avoir besoin d\'eux. Vous pouvez vendre et acheter des objets à partir du siteaussi.\r\n'),(11,12,5,'intercambio de todo','de intercambio, comercio, cambio,  todo intercambio, intercambio deplataforma, el trueque de software, virtual swapmeet, los productos de intercambio,mercado de pulgas virtuales','eSwap es una línea completa plataforma de intercambio que le permite intercambiarelementos no deseados de las cosas que usted necesita. Usted puede cambiarcualquier elemento no deseado de su casa o negocio a otros que pueden hacer uso de ellos. Usted puede vender y comprar artículos en el sitio también.\r\n'),(12,12,6,'Swap alles','Swap-, Handels-, Austausch, tauschen alles, Swapping-Plattform, Tausch-Software, virtuelle swapmeet, Swap-Produkten, virtuellen Flohmarkt\r\n','eSwap ist eine Online-Plattform komplett tauschen so dass Sie unerwünschte Elemente für Dinge, die Sie Tauschhandel. Sie können alle unerwünschten Elemente aus geschäftlichen oder privaten, andere, die für sie haben können Verwendung zu tauschen. Sie können kaufen und verkaufen Gegenstände von der Baustelle zu.\r\n');

--
-- Table structure for table `es_online`
--

CREATE TABLE `es_online` (
  `nUserId` bigint(20) NOT NULL DEFAULT '0',
  `nLoggedOn` int(15) NOT NULL DEFAULT '0',
  `nActiveTill` int(15) NOT NULL DEFAULT '0',
  `nIdle` smallint(6) NOT NULL DEFAULT '0',
  `vVisible` enum('Y','N') NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`nUserId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_online`
--

INSERT INTO `es_online` VALUES (116,1496399351,1496402231,0,'Y'),(239,1496829735,1496831175,0,'Y'),(115,1496407621,1496396909,0,'Y'),(112,1496406213,1496407653,0,'Y');

--
-- Table structure for table `es_payment`
--

CREATE TABLE `es_payment` (
  `nTxn_no` int(11) NOT NULL AUTO_INCREMENT,
  `vTxn_type` varchar(10) DEFAULT NULL,
  `vTxn_id` varchar(100) DEFAULT NULL,
  `nTxn_amount` double DEFAULT '0',
  `vTxn_mode` varchar(10) DEFAULT NULL,
  `dTxn_date` datetime DEFAULT NULL,
  `nUserId` int(11) DEFAULT '0',
  `nSaleId` int(11) DEFAULT '0',
  `vInvno` varchar(100) DEFAULT '0',
  `vPlanStatus` enum('A','I','P','C') NOT NULL DEFAULT 'P',
  `vComments` text NOT NULL,
  `nPlanId` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`nTxn_no`)
) ENGINE=MyISAM AUTO_INCREMENT=260 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_payment`
--

INSERT INTO `es_payment` VALUES (1,'C','6V300949FD448273P',0.3,'pp','2011-07-27 12:32:54',168,17,'','P','',0),(2,'C','0',0.22,'cc','2011-07-28 12:49:53',168,19,'000001','P','',0),(3,'C','',0.02,'rp','2011-07-29 09:15:09',174,20,'','P','',0),(4,'FC','100069221550',1.01,'bp','2011-08-01 13:38:18',168,21,'000002','P','',0),(5,'C','',0.02,'rp','2011-08-01 12:08:40',174,22,'','P','',0),(6,'R','2',1,'ca','2011-08-03 18:42:19',168,0,'0','P','',0),(7,'R','9N658167JH281571M',1,'pp','2011-08-04 11:26:17',168,0,'000003','P','',0),(8,'R','4S499474CD543720E',1,'pp','2011-08-04 11:55:19',168,0,'000004','P','',0),(9,'R','361293165X333011N',1,'pp','2011-08-04 12:10:08',168,0,'000005','P','',0),(10,'C','3',0.1,'ca','2011-08-03 12:30:40',168,25,'0','P','',0),(11,'C','4',0.02,'ca','2011-08-03 12:20:27',168,26,'0','P','',0),(12,'C','5',0.01,'ca','2011-08-01 12:45:01',168,27,'0','P','',0),(13,'C','6',3.3,'ca','2010-06-09 10:54:30',168,28,'0','P','',0),(14,'F','',1,'rp','2011-08-05 05:31:12',174,29,'','P','',0),(15,'FC','7',1.3,'pc','2011-08-05 05:35:35',168,30,'0','P','',0),(16,'FC','8',1.3,'pc','2011-08-05 05:41:27',168,31,'0','P','',0),(17,'FC','9',1.24,'pc','2011-08-05 05:43:11',168,32,'0','P','',0),(18,'FC','10',1.24,'pc','2011-08-05 05:45:51',168,33,'0','P','',0),(19,'C','',0.02,'rp','2011-08-09 05:17:27',174,34,'','P','',0),(20,'C','',0.03,'rp','2011-08-09 05:53:26',174,35,'','P','',0),(21,'R','11',1,'ca','2011-08-09 12:56:11',168,0,'0','P','',0),(22,'R','54C96941EJ380420A',2,'pp','2011-08-09 13:10:07',168,0,'','I','Inactive on 2011-08-09 ',1),(23,'R','0YM35100T50775023',1,'pp','2011-08-09 13:11:27',168,0,'','A','',3),(24,'R','',1,'gc','2011-08-10 09:24:45',174,0,'000006','P','',0),(25,'R','',1,'gc','2011-08-10 09:27:02',174,0,'000007','P','',0),(26,'FC','',1.01,'gc','2011-08-10 16:13:37',174,36,'000008','P','',0),(27,'FC','',1.06,'rp','2011-08-11 09:10:31',174,37,'','P','',0),(28,'FC','',1.02,'rp','2011-08-11 09:12:38',174,38,'','P','',0),(29,'FC','',1.07,'rp','2011-08-11 09:14:24',174,39,'','P','',0),(30,'','',0,'rp','0000-00-00 00:00:00',174,0,'','P','',0),(31,'','',0,'rp','0000-00-00 00:00:00',174,0,'','P','',0),(32,'','',0,'rp','0000-00-00 00:00:00',174,0,'','P','',0),(33,'','',0,'rp','0000-00-00 00:00:00',174,0,'','P','',0),(34,'','',0,'rp','0000-00-00 00:00:00',174,0,'','P','',0),(35,'','',0,'rp','0000-00-00 00:00:00',174,0,'','P','',0),(36,'C','',0.01,'rp','2011-08-11 09:43:33',174,40,'','P','',0),(37,'','',0,'rp','0000-00-00 00:00:00',174,0,'','P','',0),(38,'C','',0.01,'rp','2011-08-11 09:44:15',174,41,'','P','',0),(39,'FC','',1.03,'rp','2011-08-11 09:49:15',174,42,'','P','',0),(40,'FC','',1.01,'rp','2011-08-11 09:50:25',174,43,'','P','',0),(41,'FC','',1.01,'rp','2011-08-11 09:52:53',174,44,'','P','',0),(42,'FC','',1.01,'rp','2011-08-11 10:04:07',174,45,'','P','',0),(43,'','',0,'rp','0000-00-00 00:00:00',174,0,'','P','',0),(44,'C','',0.02,'rp','2011-08-22 05:39:38',174,47,'','P','',0),(45,'C','',0.01,'rp','2011-08-22 05:45:14',174,48,'','P','',0),(46,'C','',0.01,'rp','2011-08-22 06:00:18',174,49,'','P','',0),(47,'C','',0.02,'rp','2011-08-22 06:13:07',174,52,'','P','',0),(48,'','',0,'rp','0000-00-00 00:00:00',174,0,'','P','',0),(49,'C','',0.01,'rp','2011-08-22 06:15:04',174,53,'','P','',0),(50,'C','',0.01,'rp','2011-08-22 06:15:53',174,54,'','P','',0),(51,'FC','',1.01,'rp','2011-08-23 12:39:14',174,55,'','P','',0),(52,'FC','',2.25,'gc','2011-08-23 12:48:02',174,56,'000009','P','',0),(53,'FC','',2.25,'gc','2011-08-23 12:56:34',174,57,'000010','P','',0),(54,'FC','0',2.13,'cc','2011-08-23 14:08:28',168,58,'000010','P','',0),(55,'FC','0',1.05,'cc','2011-08-23 14:09:44',168,59,'000010','P','',0),(56,'R','0',1,'cc','2011-08-23 19:36:02',168,0,'000010','A','',3),(57,'C','0',1.25,'cc','2011-09-26 10:25:16',168,60,'000010','P','',0),(58,'FC','0',1.03,'cc','2011-09-26 10:28:50',168,61,'000010','P','',0),(59,'C','0',0.38,'cc','2011-09-28 06:15:26',168,62,'000010','P','',0),(60,'R','free',0,'free','2011-12-01 13:57:32',199,0,'0','A','',0),(61,'R','free',0,'free','2011-12-01 16:51:35',199,0,'0','A','',0),(62,'R','0',8,'cc','2011-12-12 12:58:02',168,0,'000010','I','Inactive on 2011-12-12 ',1),(63,'R','0',5,'cc','2011-12-12 14:30:54',168,0,'000010','I','Inactive on 2012-03-10 ',3),(64,'R','0',5,'cc','2011-12-12 14:50:23',168,0,'000010','A','',3),(65,'R','0',5,'cc','2011-12-13 15:42:30',168,0,'000010','A','',3),(66,'R','0',5,'cc','2011-12-14 10:23:09',168,0,'000010','A','',3),(67,'R','0',5,'cc','2011-12-14 10:30:56',168,0,'000010','A','',3),(68,'R','0',5,'cc','2011-12-14 11:05:44',168,0,'000010','A','',3),(69,'C','',0.05,'rp','2011-12-14 05:56:32',174,68,'','P','',0),(70,'C','',0.05,'rp','2011-12-14 06:01:21',174,69,'','P','',0),(71,'C','',0.33,'rp','2011-12-14 06:05:26',174,70,'','P','',0),(72,'C','',0.05,'rp','2011-12-14 06:09:50',174,71,'','P','',0),(73,'C','',0.03,'rp','2011-12-14 06:25:35',174,72,'','P','',0),(74,'R','0',8,'cc','2011-12-14 16:25:46',168,0,'000010','I','Inactive on 2011-12-14 ',1),(75,'R','0',5,'cc','2011-12-14 16:31:55',168,0,'000010','A','',3),(76,'R','0',5,'cc','2011-12-19 18:03:37',168,0,'000010','I','Inactive on 2012-02-21 ',3),(77,'FC','0',1.25,'cc','2011-12-20 09:21:29',168,73,'000010','P','',0),(78,'R','0',8,'cc','2012-01-16 19:00:40',168,0,'000010','A','',1),(79,'R','0',8,'cc','2012-01-16 19:04:25',168,0,'000010','A','',1),(80,'R','0',8,'cc','2012-02-21 11:17:17',168,0,'000010','I','Inactive on 2012-03-28 ',1),(81,'R','0',8,'cc','2012-03-10 16:41:22',168,0,'000010','A','',1),(82,'R','0',5,'cc','2012-03-28 12:16:29',168,0,'000010','I','Inactive on 2012-05-02 ',3),(83,'R','0',5,'cc','2012-04-04 14:12:23',168,0,'000010','A','',3),(84,'R','0',8,'cc','2012-05-02 10:45:18',168,0,'000010','I','Inactive on 2012-06-15 ',1),(85,'R','free',0,'free','2012-05-03 13:53:53',199,0,'0','P','',0),(86,'R','0',5,'cc','2012-06-15 16:24:56',168,0,'000010','I','Inactive on 2012-10-12 ',3),(87,'R','0',5,'cc','2012-08-07 15:01:23',168,0,'000010','I','Inactive on 2012-10-12 ',3),(88,'R','0',8,'cc','2012-08-07 15:32:22',168,0,'000010','A','',1),(89,'R','0',8,'cc','2012-08-11 10:10:12',168,0,'000010','A','',1),(90,'R','0',8,'cc','2012-10-12 10:16:31',168,0,'000010','I','Inactive on 2013-02-18 ',1),(91,'R','0',1,'cc','2012-10-12 10:18:05',168,0,'000010','A','',27),(92,'FC','19',1.01,'ca','2011-08-23 12:31:12',168,87,'0','P','',0),(93,'FC','20',1.01,'ca','2011-08-23 12:22:05',168,88,'0','P','',0),(94,'R','free',0,'free','2012-12-19 10:34:09',199,0,'0','P','',0),(95,'R','free',0,'free','2013-01-12 12:03:53',199,0,'0','P','',0),(96,'C','4EN74976PT6529444',2.4,'pp','2013-02-19 10:10:50',168,97,'000010','P','',0),(97,'R','free',0,'free','2013-03-25 11:35:25',199,0,'0','P','',0),(98,'R','free',0,'free','2013-04-01 09:53:18',199,0,'0','P','',0),(99,'R','free',0,'free','2013-04-01 16:18:27',199,0,'0','A','',0),(100,'R','free',0,'free','2013-04-01 16:19:02',199,0,'0','A','',0),(101,'R','0',5,'cc','2013-08-27 11:12:46',168,0,'000010','I','Inactive on 2013-10-10 ',3),(102,'R','0',5,'cc','2013-09-27 17:39:33',168,0,'000010','I','Inactive on 2014-06-23 ',3),(103,'R','0',100,'cc','2013-10-10 10:39:44',168,0,'000010','A','',28),(104,'R','free',0,'free','2013-11-14 10:04:27',199,0,'0','P','',0),(105,'R','free',0,'free','2013-11-15 16:34:59',199,0,'0','P','',0),(106,'R','21',1,'pc','2013-11-15 17:41:48',168,0,'0','P','',0),(107,'R','free',0,'free','2013-11-15 17:47:47',199,0,'0','P','',0),(108,'R','free',0,'free','2013-11-15 18:03:53',199,0,'0','P','',0),(109,'R','free',0,'free','2013-11-19 18:08:34',199,0,'0','P','',0),(110,'R','free',0,'free','2013-12-02 10:38:22',199,0,'0','A','',0),(112,'R','free',0,'free','2014-04-12 18:10:46',199,0,'0','P','',0),(113,'R','free',0,'free','2014-04-12 18:17:37',199,0,'0','P','',0),(114,'C','0',2,'cc','2014-04-12 06:03:28',168,99,'000010','P','',0),(115,'C','3CH05931KK387831P',0.1,'pp','2014-07-14 05:02:13',168,100,'000010','P','',0),(116,'R','22',0,'','2014-07-25 12:46:01',168,0,'0','P','',0),(117,'R','free',0,'free','2014-08-05 18:50:03',199,0,'0','P','',0),(118,'C','5V879945WS9472303',0.6,'pp','2014-08-05 06:26:29',168,101,'000010','P','',0),(119,'R','free',0,'free','2014-09-22 12:11:59',199,0,'0','P','',0),(120,'R','free',0,'free','2014-10-10 12:00:23',199,0,'0','P','',0),(121,'C','23',0.1,'mo','2013-11-15 12:23:34',168,102,'0','P','',0),(122,'FC','4K923348EF543611G',6,'pp','2014-10-14 00:30:50',168,103,'000010','P','',0),(123,'R','free',0,'free','2014-12-08 11:24:07',199,0,'0','A','',0),(124,'C','4K923348EF543611F',0.04,'rp','2014-12-08 00:44:11',168,104,'','P','',0),(125,'R','8JR17524DT539684B',5,'pp','2014-12-16 18:07:32',168,0,'000010','A','',3),(126,'C','69K2561596492210W',2.4,'pp','2015-03-17 23:14:56',168,105,'000010','P','',0),(127,'R','',0,'free','2015-03-30 14:47:03',174,0,'','A','',25),(128,'C','0',6,'cc','2015-04-08 03:41:16',168,106,'000010','P','',0),(129,'FC','0TA196097R790960G',1.2,'pp','2015-04-10 00:18:58',168,108,'000010','P','',0),(130,'F','0',1,'cc','2015-04-10 00:22:39',168,109,'000010','P','',0),(131,'C','0',66.66,'cc','2015-04-10 04:45:43',168,110,'000010','P','',0),(132,'C','8SX82692N4474542K',0.02,'pp','2015-04-11 02:17:48',168,111,'000010','P','',0),(144,'FC','3Y3305925W5068156',1.5,'pp','2015-04-24 04:13:13',168,117,'000010','P','',0),(134,'R','free',0,'free','2015-04-16 17:25:01',199,0,'0','A','',0),(135,'R','free',0,'free','2015-04-16 17:31:36',199,0,'0','A','',0),(136,'R','free',0,'free','2015-04-17 11:56:10',199,0,'0','A','',0),(137,'R','free',0,'free','2015-04-17 12:31:56',199,0,'0','A','',0),(138,'R','free',0,'free','2015-04-17 15:58:47',199,0,'0','A','',0),(139,'R','5A167940DM187545G',8,'pp','2015-04-17 16:00:42',168,0,'000010','A','',1),(140,'R','2YC301004N437692R',5,'pp','2015-04-17 16:04:00',168,0,'000010','P','',0),(143,'C','24',2,'ca','2013-11-15 16:52:58',168,116,'0','P','',0),(142,'C','05478298R9797482U',0.08,'pp','2015-04-24 03:14:59',168,115,'000010','P','',0),(145,'FC','8XX65495L5198805R',1.9,'pp','2015-04-24 04:19:09',168,118,'000010','P','',0),(146,'C','24G07381FH9838530',0.1,'pp','2015-04-24 05:02:59',168,119,'000010','P','',0),(147,'FC','12C89649JM880094B',1.68,'pp','2015-04-27 01:28:35',168,120,'000010','P','',0),(148,'R','free',0,'free','2015-04-28 14:18:46',199,0,'0','A','',0),(149,'FC','43U57890AK819031X',2.04,'pp','2015-04-28 02:17:21',168,121,'000010','P','',0),(150,'C','0MS74209UG889402B',0.68,'pp','2015-04-29 05:20:57',168,122,'000010','P','',0),(151,'C','0R23750482650651C',0.68,'pp','2015-04-29 05:51:17',168,123,'000010','P','',0),(152,'C','0',6.68,'cc','2015-05-12 04:38:27',168,127,'000010','P','',0),(153,'F','',1,'rp','2015-05-13 05:20:06',174,129,'','P','',0),(154,'R','',0,'free','2015-05-21 11:36:22',174,0,'','A','',25),(155,'C','32X96992035836214',0.04,'pp','2015-06-21 23:17:48',168,131,'000010','P','',0),(156,'R','free',0,'free','2015-06-27 23:51:51',199,0,'0','A','',0),(157,'R','free',0,'free','2015-07-02 00:49:51',199,0,'0','A','',0),(158,'R','free',0,'free','2015-07-02 01:00:39',199,0,'0','A','',0),(159,'R','free',0,'free','2015-07-02 01:07:40',199,0,'0','A','',0),(160,'R','free',0,'free','2015-07-02 01:18:28',199,0,'0','A','',0),(161,'R','free',0,'free','2015-07-02 01:31:12',199,0,'0','A','',0),(162,'C','6HN273768G477871J',0.5,'pp','2015-07-02 23:07:02',168,140,'000010','P','',0),(163,'C','15M550548P251540N',0.4,'pp','2015-07-03 04:29:53',168,143,'000010','P','',0),(164,'C','4A48798210579444P',2,'pp','2015-07-03 04:32:14',168,144,'000010','P','',0),(165,'C','6RR12953NK531452U',0.68,'pp','2015-05-08 04:11:05',168,145,'000010','P','',0),(166,'C','',0.1,'rp','2015-07-07 01:27:58',174,146,'','P','',0),(167,'R','free',0,'free','2015-07-16 23:06:49',199,0,'0','P','',0),(168,'R','8GJ94596C62539418',5,'pp','2015-07-16 23:14:35',168,0,'000010','A','',3),(169,'R','4UR87326D59296134',5,'pp','2015-07-16 23:28:54',168,0,'000010','A','',3),(170,'R','free',0,'free','2015-07-17 02:16:37',199,0,'0','A','',0),(171,'R','free',0,'free','2015-07-17 02:25:53',199,0,'0','A','',0),(172,'R','70D75855K0566801X',5,'pp','2015-07-17 02:29:27',168,0,'000010','A','',3),(173,'R','free',0,'free','2015-07-17 02:36:27',199,0,'0','P','',0),(174,'R','0',5,'cc','2015-07-17 02:47:01',168,0,'000010','A','',3),(175,'R','08R66038JJ349020K',5,'pp','2015-07-17 02:56:15',168,0,'000010','A','',3),(176,'R','free',0,'free','2015-07-22 01:56:29',199,0,'0','A','',0),(177,'R','free',0,'free','2015-07-22 04:42:10',199,0,'0','A','',0),(178,'R','free',0,'free','2015-07-22 04:43:26',199,0,'0','A','',0),(179,'R','440281737M142580X',5,'pp','2015-07-22 04:46:01',168,0,'000010','A','',3),(180,'R','0',5,'cc','2015-07-22 04:48:20',168,0,'000010','A','',3),(181,'R','2T473027V01510701',200,'pp','2015-08-21 21:52:29',168,0,'','A','',29),(182,'C','',0.06,'rp','2016-04-21 05:16:46',174,149,'','P','',0),(183,'C','0',0.08,'cc','2016-04-21 05:19:03',168,150,'000010','P','',0),(184,'FC','',1.08,'rp','2016-04-21 22:12:33',174,151,'','P','',0),(185,'C','',0.2,'rp','2016-04-25 02:02:20',174,152,'','P','',0),(186,'C','0',22.2,'cc','2016-04-25 02:06:19',168,153,'000010','P','',0),(187,'FC','0',5.65,'cc','2016-04-25 02:13:06',168,154,'000010','P','',0),(188,'C','0',0.15,'cc','2016-04-25 02:42:30',168,155,'000010','P','',3),(189,'R','25',10,'wt','2016-05-03 01:27:13',168,0,'0','P','',0),(190,'R','26',10,'pc','2016-05-03 01:37:06',168,0,'0','P','',27),(191,'R','',0,'free','2016-05-03 02:02:22',174,0,'','I','Inactive on 2016-05-02 ',25),(192,'R','3NG1977174457880F',8,'pp','2016-05-03 02:16:33',155,0,'','A','',1),(193,'R','1CA98464W34062549',10,'pp','2016-05-03 02:19:05',0,0,'000010','A','',27),(194,'R','5WB582833S613681H',10,'pp','2016-05-03 02:49:55',168,0,'000010','A','',27),(197,'R','28',200,'bu','2016-05-03 04:30:10',0,0,'0','P','',0),(196,'R','27',8,'ca','2016-05-03 04:21:05',0,0,'0','P','',0),(198,'R','29',20,'ca','2016-05-03 04:32:51',0,0,'0','P','',0),(199,'R','30',8,'ca','2016-05-03 04:36:13',0,0,'0','P','',0),(200,'R','31',5,'ca','2016-05-03 04:39:26',0,0,'0','P','',0),(201,'R','32',5,'ca','2016-05-03 04:40:04',175,0,'0','P','',0),(202,'R','33',10,'ca','2016-05-03 04:45:40',0,0,'0','P','',0),(203,'R','34',10,'ca','2016-05-03 04:46:00',0,0,'0','P','',0),(204,'R','35',10,'ca','2016-05-03 04:46:25',0,0,'0','P','',0),(205,'R','36',10,'ca','2016-05-03 04:47:06',0,0,'0','P','',0),(206,'R','37',10,'ca','2016-05-03 04:47:24',0,0,'0','P','',0),(207,'R','38',10,'ca','2016-05-03 04:47:30',0,0,'0','P','',0),(208,'R','39',10,'bu','2016-05-03 04:48:51',0,0,'0','P','',0),(209,'R','40',10,'bu','2016-05-03 04:50:08',0,0,'0','P','',0),(210,'R','41',10,'bu','2016-05-03 04:50:29',0,0,'0','P','',0),(211,'R','42',10,'bu','2016-05-03 04:53:14',177,0,'0','P','',27),(212,'R','free',0,'free','2016-05-03 04:54:17',199,0,'0','A','',0),(213,'R','free',0,'free','2016-05-03 05:00:43',199,0,'0','A','',25),(214,'R','43',0,'','2016-05-03 05:01:00',0,0,'0','P','',0),(215,'R','free',0,'free','2016-05-03 05:02:25',199,0,'0','A','',25),(218,'R','134222305U2720049',10,'pp','2016-05-03 05:21:22',0,0,'000010','A','',27),(217,'R','0',10,'cc','2016-05-03 05:19:04',8,0,'000010','A','',27),(219,'R','free',0,'free','2016-05-03 05:28:34',164,0,'0','A','',25),(220,'R','0',200,'cc','2016-05-03 05:30:57',8,0,'000010','A','',29),(221,'R','81X972145J207614H',5,'pp','2016-05-03 05:32:49',0,0,'000010','A','',3),(222,'R','8CJ87015168629000',5,'pp','2016-05-03 05:51:26',0,0,'000010','A','',3),(223,'R','5JB43693LV0455433',5,'pp','2016-05-03 05:54:54',190,0,'000010','A','',3),(224,'R','44',5,'ca','2016-05-03 05:57:37',191,0,'0','P','',0),(225,'R','49',5,'ca','2016-05-03 06:02:32',192,0,'0','P','',3),(226,'R','8NS43839BS831862V',5,'pp','2016-05-03 20:17:20',193,0,'000010','A','',3),(227,'R','50',5,'ca','2016-05-03 20:19:41',194,0,'0','P','',3),(228,'R','51',5,'bu','2016-05-03 20:22:35',195,0,'0','P','',3),(229,'R','52',5,'pc','2016-05-03 20:24:25',196,0,'0','P','',3),(230,'R','53',5,'mo','2016-05-03 20:26:01',197,0,'0','P','',3),(231,'R','free',0,'free','2016-05-03 20:27:19',199,0,'0','A','',25),(232,'R','free',0,'free','2016-05-03 20:31:45',200,0,'0','A','',25),(233,'R','65M91330HR357084V',8,'pp','2016-05-03 20:35:36',201,0,'000010','I','Inactive on 2016-05-08 ',1),(239,'C','8P412085PP218411V',23.4,'pp','2016-05-04 22:14:05',0,156,'000010','P','',0),(238,NULL,NULL,0,NULL,NULL,0,0,'0','P','',0),(240,'C','8NC41945AM084092K',34.5,'pp','2016-05-05 00:19:36',0,157,'000010','P','',0),(241,'R','',5,'pp','2016-05-06 04:49:56',0,0,'000010','A','',3),(242,'R','free',0,'free','2016-05-07 05:21:04',205,0,'0','A','',25),(243,'R','5Y888344A7004821J',5,'pp','2016-05-09 21:13:13',201,0,'','I','Inactive on 2017-02-08 ',3),(244,'R','free',0,'free','2016-12-22 18:54:37',206,0,'0','A','',25),(245,'FC','0',4.1,'cc','2017-01-26 23:04:51',0,158,'000010','P','',0),(246,'R','0',5,'cc','2017-02-08 22:28:43',207,0,'000010','A','',3),(247,'R','0',100,'cc','2017-02-08 22:32:13',164,0,'000010','A','',28),(248,'R','0',100,'cc','2017-02-08 22:34:00',201,0,'000010','A','',28),(249,'R','8N926899HE2728940',5,'pp','2017-02-10 23:37:27',0,0,'000010','A','',3),(250,'R','19G18731V6243614B',5,'pp','2017-02-10 23:51:27',0,0,'000010','A','',3),(251,'R','free',0,'free','2017-02-14 01:14:43',220,0,'0','A','',25),(252,'R','6VL21911B1803180H',5,'pp','2017-02-16 20:02:47',0,0,'000010','A','',3),(253,'R','3JT396864D357205N',5,'pp','2017-02-16 20:16:27',0,0,'000010','A','',3),(254,'R','36416355NV391841N',5,'pp','2017-06-01 16:28:50',0,0,'000010','A','',3),(255,'R','1ED771742D840592D',5,'pp','2017-06-01 16:30:54',0,0,'000010','A','',3),(256,'R','7NV66199DX212620K',5,'pp','2017-06-02 11:56:44',0,0,'000010','A','',3),(257,'R','free',0,'free','2017-06-06 11:49:47',236,0,'0','A','',25),(258,'R','free',0,'free','2017-06-06 14:42:28',241,0,'0','A','',25),(259,'R','0LY30013PN524345E',5,'pp','2017-06-06 14:51:17',0,0,'000010','A','',3);

--
-- Table structure for table `es_paymentdetails`
--

CREATE TABLE `es_paymentdetails` (
  `nPaymentId` int(11) NOT NULL AUTO_INCREMENT,
  `vName` varchar(100) DEFAULT NULL,
  `vReferenceNo` varchar(100) DEFAULT NULL,
  `vBank` varchar(100) DEFAULT NULL,
  `dReferenceDate` datetime DEFAULT NULL,
  `dEntryDate` datetime DEFAULT NULL,
  PRIMARY KEY (`nPaymentId`)
) ENGINE=MyISAM AUTO_INCREMENT=56 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_paymentdetails`
--

INSERT INTO `es_paymentdetails` VALUES (1,'dfdf','dfdfdf','df','2009-01-01 00:00:00','2011-08-02 18:55:46'),(2,'Ben','2323232323','American Bank','2011-12-19 00:00:00','2011-08-03 18:42:19'),(3,'Ben','323434343','US Bank','2011-11-17 00:00:00','2011-08-05 10:47:09'),(4,'Ben','12345678','American Bank','0000-00-00 00:00:00','2011-08-05 10:47:39'),(5,'Ben','2323232','American Bank','0000-00-00 00:00:00','2011-08-05 10:47:58'),(6,'Test','Test','Test','2010-12-12 00:00:00','2011-08-05 10:49:47'),(7,'1133','5665665656','46656','2011-12-12 00:00:00','2011-08-05 11:00:52'),(8,'1133','5665665656','46656','2011-12-12 00:00:00','2011-08-05 11:03:19'),(9,'1133','5665665656','46656','2011-12-12 00:00:00','2011-08-05 11:05:03'),(10,'1133','5665665656','46656','2011-12-12 00:00:00','2011-08-05 11:07:32'),(11,'Ben','12345678','American Bank','2011-12-27 00:00:00','2011-08-09 12:56:11'),(12,'babitha','5665665656','46656','2009-01-01 00:00:00','2011-12-14 18:43:25'),(13,'Points','12345678','American Bank','2009-01-01 00:00:00','2011-12-14 18:43:39'),(14,'random test','123','','2012-01-01 00:00:00','2011-12-14 18:50:12'),(15,'random test','123','','2012-01-01 00:00:00','2011-12-14 18:51:47'),(16,'random test','123','','2012-01-01 00:00:00','2011-12-14 18:53:46'),(17,'random test','123','','2012-01-01 00:00:00','2011-12-14 19:03:44'),(18,'Babitha Antony','123-639-421','National Bank','2012-05-03 00:00:00','2012-12-04 15:17:17'),(19,'1133','5665665656','46656','2030-12-12 00:00:00','2012-12-04 15:17:51'),(20,'babitha','5665665656','46656','2030-12-12 00:00:00','2012-12-04 15:20:17'),(21,'babitha','5665665656','46656','2011-12-12 00:00:00','2013-11-15 17:41:48'),(22,'','','','0000-00-00 00:00:00','2014-07-25 12:46:01'),(23,'Flower','123456','SBI','1989-12-10 00:00:00','2014-10-10 14:57:45'),(24,'fdhg','ghgfh','hgh','0000-00-00 00:00:00','2015-04-24 16:17:34'),(25,'Dev Test','#32423','','2016-10-10 00:00:00','2016-05-03 01:27:13'),(26,'Dev Test','#2323123','','2016-10-10 00:00:00','2016-05-03 01:37:06'),(27,'Dev Test','#223242442','','2016-10-10 00:00:00','2016-05-03 04:21:05'),(28,'DF','#asasdas','','2016-01-01 00:00:00','2016-05-03 04:30:10'),(29,'Some','#342344234','','2016-01-01 00:00:00','2016-05-03 04:32:51'),(30,'some','#34324','','2016-01-01 00:00:00','2016-05-03 04:36:13'),(31,'sd','23','','2016-01-01 00:00:00','2016-05-03 04:39:26'),(32,'sd','23','','2016-01-01 00:00:00','2016-05-03 04:40:04'),(33,'df','234234','','2016-01-01 00:00:00','2016-05-03 04:45:40'),(34,'df','234234','','2016-01-01 00:00:00','2016-05-03 04:46:00'),(35,'df','234234','','2016-01-01 00:00:00','2016-05-03 04:46:25'),(36,'df','234234','','2016-01-01 00:00:00','2016-05-03 04:47:06'),(37,'df','234234','','2016-01-01 00:00:00','2016-05-03 04:47:24'),(38,'df','234234','','2016-01-01 00:00:00','2016-05-03 04:47:30'),(39,'d','34','','2016-01-01 00:00:00','2016-05-03 04:48:51'),(40,'d','34','','2016-01-01 00:00:00','2016-05-03 04:50:08'),(41,'d','34','','2016-01-01 00:00:00','2016-05-03 04:50:29'),(42,'d','34','','2016-01-01 00:00:00','2016-05-03 04:53:14'),(43,'','','','0000-00-00 00:00:00','2016-05-03 05:01:00'),(44,'sdf','3424','','2016-01-01 00:00:00','2016-05-03 05:57:37'),(45,'sdfd','5644','','2016-01-01 00:00:00','2016-05-03 06:01:19'),(46,'sdfd','5644','','2016-01-01 00:00:00','2016-05-03 06:01:24'),(47,'sdfd','5644','','2016-01-01 00:00:00','2016-05-03 06:01:25'),(48,'sdfd','5644','','2016-01-01 00:00:00','2016-05-03 06:01:46'),(49,'sdfd','5644','','2016-01-01 00:00:00','2016-05-03 06:02:32'),(50,'dd','dd','','2016-01-01 00:00:00','2016-05-03 20:19:41'),(51,'dd','dd','','2016-01-01 00:00:00','2016-05-03 20:22:35'),(52,'sd','sd','','2016-01-01 00:00:00','2016-05-03 20:24:25'),(53,'sd','sd','','2016-01-01 00:00:00','2016-05-03 20:26:01'),(54,'','','','0000-00-00 00:00:00','2017-01-30 21:31:59'),(55,'','','','0000-00-00 00:00:00','2017-01-30 21:32:02');

--
-- Table structure for table `es_pins`
--

CREATE TABLE `es_pins` (
  `nPINId` bigint(20) NOT NULL AUTO_INCREMENT,
  `nPIN` varchar(100) DEFAULT NULL,
  `nBatchId` bigint(20) DEFAULT NULL,
  `nUserId` int(11) DEFAULT '0',
  `dAltmntDate` datetime DEFAULT NULL,
  PRIMARY KEY (`nPINId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_pins`
--


--
-- Table structure for table `es_plan`
--

CREATE TABLE `es_plan` (
  `nPlanId` int(11) NOT NULL AUTO_INCREMENT,
  `nPrice` float DEFAULT NULL,
  `vActive` enum('0','1') DEFAULT '1',
  `vPeriods` char(1) DEFAULT '',
  `nPosition` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`nPlanId`)
) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_plan`
--

INSERT INTO `es_plan` VALUES (1,8,'1','M',4),(28,100,'1','Y',3),(3,5,'1','M',1),(27,10,'0','M',0),(25,0,'1','F',2),(29,200,'1','M',5),(31,20,'1','M',6),(32,534,'1','M',7),(33,646,'1','M',8),(34,654,'1','M',9),(36,50,'1','M',10),(37,100,'1','Y',11);

--
-- Table structure for table `es_plan_lang`
--

CREATE TABLE `es_plan_lang` (
  `plan_lang_id` int(11) NOT NULL AUTO_INCREMENT,
  `plan_id` int(11) NOT NULL COMMENT 'plan id',
  `lang_id` int(11) NOT NULL COMMENT 'language id',
  `vPlanName` varchar(100) NOT NULL COMMENT 'plan name',
  PRIMARY KEY (`plan_lang_id`)
) ENGINE=MyISAM AUTO_INCREMENT=74 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `es_plan_lang`
--

INSERT INTO `es_plan_lang` VALUES (1,1,1,'Platinum'),(3,3,1,'Gold'),(16,1,2,'PlatinumFR'),(7,3,2,'GoldFR'),(40,1,6,''),(39,1,5,'make\'sure'),(38,3,6,''),(37,3,5,'Reports1'),(43,25,5,'dsfsdf'),(42,25,2,'dsfsdf'),(41,25,1,'Free'),(51,27,5,'Plan1'),(50,27,2,'Plan1'),(44,25,6,'sdfsdf'),(49,27,1,'Test Planee'),(52,27,6,'Plan1'),(53,28,1,'Diamond'),(54,28,2,'Diamond'),(55,28,5,'Diamond'),(56,28,6,'Diamond'),(57,25,7,''),(58,25,8,'sdfsdf'),(59,29,1,'Silver'),(60,29,2,'Silver'),(61,29,5,'Silver'),(62,29,6,'Silver'),(63,29,8,'Silver'),(65,31,1,'fdsfd'),(66,32,1,'gfgdf'),(67,33,1,'gdfg'),(68,34,1,'gfgrer'),(70,36,1,'Gold Plan'),(71,36,9,'Gold Plan'),(72,37,1,'Platinum Plan'),(73,37,9,'Platinum Plan');

--
-- Table structure for table `es_pointhistory`
--

CREATE TABLE `es_pointhistory` (
  `nHId` bigint(20) NOT NULL AUTO_INCREMENT,
  `nSendBy` int(11) NOT NULL DEFAULT '0',
  `nSendTo` int(11) NOT NULL DEFAULT '0',
  `nPoints` double NOT NULL DEFAULT '0',
  `dDate` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`nHId`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_pointhistory`
--

INSERT INTO `es_pointhistory` VALUES (1,21,1,10,'2011-08-02'),(2,110,103,5,'2013-12-02'),(3,139,111,10,'2015-07-04'),(4,114,155,2,'2016-04-21');

--
-- Table structure for table `es_referrals`
--

CREATE TABLE `es_referrals` (
  `nRefId` int(11) NOT NULL AUTO_INCREMENT,
  `nUserId` int(11) DEFAULT '0',
  `vName` varchar(100) DEFAULT NULL,
  `vAddress` varchar(100) DEFAULT NULL,
  `vPhone` varchar(20) DEFAULT NULL,
  `vFax` varchar(20) DEFAULT NULL,
  `vEmail` varchar(100) DEFAULT NULL,
  `vSurveyStatus` char(2) DEFAULT '0',
  `dSurveyDate` datetime DEFAULT NULL,
  `nSurveyAmount` double DEFAULT '0',
  `vSurveyAnswer` text,
  `vRegStatus` char(2) DEFAULT '0',
  `dRegDate` datetime DEFAULT NULL,
  `nRegAmount` double DEFAULT '0',
  `vPayStatus` char(2) DEFAULT '0',
  `nSurveyCashTxn` int(11) DEFAULT '0',
  `nRegCashTxn` int(11) DEFAULT '0',
  `nUserRegId` int(11) DEFAULT '0',
  `vSurveyIP` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`nRefId`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_referrals`
--

INSERT INTO `es_referrals` VALUES (1,37,'maartha','armia','24566989','52565685','babitha.armia@yahoo.com','0',NULL,0,NULL,'1','2012-01-16 19:07:37',65,'0',0,9,0,NULL),(3,115,'Mila','armia','989596323','','mila@armia.com','0',NULL,35,NULL,'0',NULL,65,'0',0,0,0,NULL),(4,115,'anu','12 th street','','','armiaqa100@`gmail.com','0',NULL,35,NULL,'0',NULL,65,'0',0,0,0,NULL),(5,115,'sam','12 th street','','','armiaqa100@gmail.com','0',NULL,35,NULL,'0',NULL,65,'0',0,0,0,NULL),(6,115,'sami','12 th street','','','armiaqa103@gmail.com','1','2016-04-21 22:48:49',35,'1±1±1±1±1±2±2±2±fdgdgd','0',NULL,65,'0',0,0,0,'127.0.0.1'),(7,111,'Neha','Test','232323','','neha.t@armiasystems.com','0',NULL,35,NULL,'0',NULL,65,'0',0,0,0,NULL),(8,111,'Neha','Test','232323','','neha1.t@armiasystems.com','0',NULL,35,NULL,'0',NULL,65,'0',0,0,0,NULL),(9,116,'Sarath Kumar','Ground Floor,Vismaya Building,Infopark,Cochin','04842157896','856947859','sarath.k@armiasystems.com','0',NULL,0,NULL,'0',NULL,0,'0',0,0,0,NULL),(10,116,'Vipin PK','Ground Floor,Vismaya Building,Infopark,Cochin','04842157897','856947859','vipin.pk@armiasystems.com','0',NULL,0,NULL,'0',NULL,0,'0',0,0,0,NULL),(11,116,'Sreebu KB','Ground Floor,Vismaya Building,Infopark,Cochin','04842157897','856947859','sreebu.kb@armiasystems.com','0',NULL,0,NULL,'0',NULL,0,'0',0,0,0,NULL);

--
-- Table structure for table `es_sale`
--

CREATE TABLE `es_sale` (
  `nSaleId` int(11) NOT NULL AUTO_INCREMENT,
  `nCategoryId` int(11) DEFAULT '0',
  `nUserId` int(11) DEFAULT '0',
  `vTitle` varchar(100) DEFAULT NULL,
  `vBrand` varchar(100) DEFAULT NULL,
  `vType` varchar(100) DEFAULT NULL,
  `vCondition` varchar(100) DEFAULT NULL,
  `vYear` int(4) DEFAULT NULL,
  `nValue` double DEFAULT '0',
  `nShipping` double DEFAULT '0',
  `vUrl` varchar(100) DEFAULT NULL,
  `vDescription` text,
  `dPostDate` datetime DEFAULT NULL,
  `nQuantity` double DEFAULT '0',
  `vFeatured` char(2) NOT NULL DEFAULT 'N',
  `vDelStatus` tinyint(1) NOT NULL DEFAULT '0',
  `vSmlImg` varchar(200) DEFAULT NULL,
  `vImgDes` text,
  `nPoint` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`nSaleId`)
) ENGINE=MyISAM AUTO_INCREMENT=159 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_sale`
--

INSERT INTO `es_sale` VALUES (1,36,1,'Apple','Apple','New','New',2010,33,33,'pics/1_1343805494.jpg','Apple Apple Apple','2010-06-07 12:33:10',20,'N',0,'pics/1_1343805494_thumb.jpg','Apple Apple',0),(2,1,1,'Mango','Mango','New','New',3123,33,33,'pics/1_1275894329.jpg','Mango Mango Mango Mango Mango Mango Mango Mango ','2010-06-07 12:35:29',17,'N',1,'pics/1_1275894329_thumb.jpg','Mango',0),(3,1,2,'Apple2','Apple2','New','New',2010,22,22,'pics/2_1275894615.jpg','Apple2 Apple2 Apple2 Apple2 Apple2 Apple2 Apple2 Apple2 Apple2 ','2010-06-07 12:40:15',31,'N',0,'pics/2_1275894615_thumb.jpg','Apple2',0),(4,33,1,'Testing Listing Fee','Testing Listing Fee','New','New',2000,111,22,'pics/1_1343806340.jpg','Testing Listing Fee','2010-06-12 16:29:47',24,'N',0,'pics/1_1343806340_thumb.jpg','Testing Listing Fee',0),(5,91,1,'Testing Bluepay','Testing Bluepay','New','New',2010,22,1,'pics/1_1343805651.jpg','Testing Bluepay','2010-06-30 12:14:03',11,'N',0,'pics/1_1343805651_thumb.jpg','Testing Bluepay 123',0),(6,10,7,'Test','','New','New',2010,34,5,'pics/7_1280746743.jpg','hfh','2010-08-02 16:29:03',5,'N',0,'pics/7_1280746743_thumb.jpg','',0),(7,33,1,'Rose Testing','Rose Testing','New','New',2010,222,22,'pics/1_1343805929.jpg','Rose Testing','2010-08-27 17:17:49',220,'N',0,'pics/1_1343805929_thumb.jpg','',123),(8,2,1,'Rose Testing2','Rose Testing2','New','New',2010,2222,222,'pics/1_1282909812.jpg','Rose Testing2','2010-08-27 17:20:12',22,'N',1,'pics/1_1282909812_thumb.jpg','Rose Testing2',0),(9,2,20,'TestFlower1-sale','','New','New',2011,10,1,'','dsss','2011-04-29 14:48:01',1,'N',1,'','',0),(10,2,1,'Rose Testing22','Rose Testing22','New','New',2010,200,40,'pics/1_1282909886.jpg','Rose Testing22','2010-08-27 17:21:26',16,'N',0,'pics/1_1282909886_thumb.jpg','Rose Testing22',0),(11,10,21,'BG1','BG1','New','New',2011,12,1,'pics/21_1307950442.jpg','zoo','2011-06-13 07:34:02',2,'N',1,'pics/21_1307950442_thumb.jpg','zoo',0),(13,10,22,'Hand bag','Nike','New','New',2011,11,1,'','Nike hand bag','2011-06-28 12:15:35',3,'N',1,'','',0),(14,33,28,'Christina handbags','Mochi','New','Very good',2011,500,20,'pics/28_1309754857.jpg','  a) All featured items will be listed in bold fonts.\r\n  b) All featured items will be listed first in a search.\r\n  c) All featured items will have small featured icon near the listing title.\r\n  d) All featured items will be uniquely displayed throughout our site on eSwap2.1 Version\'s featured items in slide show on home page. ','2011-07-04 10:17:37',20,'N',0,'','',0),(15,39,21,'price and point sale','dfdf','New','New',2011,2,3,'pics/21_1312191535.jpg','dfdf','2011-07-18 10:25:37',2,'N',0,'pics/21_1312191535_thumb.jpg','',1),(17,46,28,'chip1','','New','New',2011,15,0,'','xcfvcvcvc','2011-07-27 12:32:54',2,'N',0,'','',0),(19,46,22,'Bottle','Pearl','New','New',2011,2,1,'','12','2011-07-28 12:49:53',1,'N',0,'','',0),(20,25,21,'Norton - Internet Sec','Norton','New','New',2011,2,12,'pics/21_1311948065.jpg','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce aliquam diam quis elit gravida quis eleifend nisl dapibus. Maecenas faucibus egestas scelerisque. Donec semper ultricies ullamcorper. Proin auctor tincidunt tortor, eu rutrum odio fermentum sit amet. Donec sit amet massa lacus. Vivamus fermentum facilisis arcu ac laoreet. Donec mollis venenatis mi eu commodo. Vivamus gravida pretium placerat. Vivamus mauris ligula, porttitor quis gravida vitae, feugiat vitae nunc. Integer porta posuere orci sed semper. In quis lectus a est tempor varius. Cras laoreet, augue nec imperdiet sagittis, dolor velit lobortis sapien, non accumsan mi enim ac arcu. Aenean orci dui, vehicula ac tincidunt eget, iaculis eget nunc. Curabitur egestas rutrum mauris sit amet cursus. Donec a enim purus, ut suscipit mi. Nullam mauris quam, dictum sit amet dignissim at, feugiat et urna. Nullam molestie turpis non arcu tincidunt vel interdum dui pellentesque. Pellentesque id cursus nisi.','2011-07-29 09:15:09',2,'N',0,'pics/21_1311948065_thumb.jpg','Lorem ipsum dolor sit amet, consectetur adipiscing elit. For first image.',0),(21,39,21,'Statue of Rino','None','New','New',2011,0.5,0.5,'pics/21_1313991165.jpg','1212','2011-08-01 13:38:18',0,'N',0,'pics/21_1313991165_thumb.jpg','',0.5),(22,45,22,'Panda Internet Security','Panda','New','New',2011,2,1,'','dfdf','2011-08-01 12:08:40',2,'N',0,'','',0),(149,36,111,'Renault duster','','New','New',2016,3,3,'','eeeeeeeeeeeee','2016-04-21 05:16:46',4,'N',0,'','',2),(24,35,31,'title','','New','New',2011,52,0,'','zsdfzfcdasf','2011-08-03 14:03:05',5,'N',0,'','',12),(25,12,21,'Cut Shoes','Reebook','New','New',2011,10,1,'','sddf','2011-08-03 12:30:40',10,'N',0,'','',0),(26,39,21,'Rino Statue','non','New','New',2011,2,1,'','123','2011-08-03 12:20:27',6,'N',0,'','',0),(27,43,22,'Mic','Logitec','New','New',2011,1,1,'','11','2011-08-01 12:45:01',3,'N',0,'','',0),(28,36,1,'Testing Other','Testing Other','New','New',0,333,333,'pics/1_1343805572.jpg','Testing Other','2010-06-09 10:54:30',333,'N',0,'pics/1_1343805572_thumb.jpg','Testing Other',0),(157,90,164,'345','','New','New',2016,345,0,'','234','2016-05-05 00:19:36',43,'N',0,'','',0),(34,36,21,'Oil','Activex','New','New',2011,2,3,'','12','2011-08-09 05:17:27',12,'N',0,'','',222),(35,36,21,'Spanner','None','New','New',2011,3,1,'','12','2011-08-09 05:53:26',12,'N',0,'','',3),(65,36,21,'car','nizan','New','New',2011,10000,150,'pics/65_1428574494.jpg','dcdzscdas','2011-11-30 11:11:03',5,'N',0,'pics/65_1428574494_thumb.jpg','',0),(67,36,57,'sale sale','sale sale','New','New',2011,150,1,'','sale salesale sale','2011-12-09 08:33:04',2,'N',1,'','',50),(72,39,37,'new sample','sas','New','New',2011,1,0,'pics/37_1350022038.jpg','fdsf','2011-12-14 06:25:35',10,'Y',0,'pics/37_1350022038_thumb.jpg','fdfs fdsf sdf sdfsd fsdfsdf sdf sdfsd fsf sdfsdfdsfsd',0),(74,35,78,'Pearl Necklace','Gucci','New','New',2012,1,0,'pics/78_1336043407.jpg','Pearl Necklace','2012-05-03 11:10:07',1,'N',0,'pics/78_1336043407_thumb.jpg','Pearl Necklace',0),(75,68,78,'3 member seating','','New','New',2012,0,0,'','3 member seating','2012-05-07 04:46:02',3,'N',0,'','',0),(83,36,1,'Dress','kids','New','New',2012,56,1,'pics/1_1343804338.jpg','kids-Dress','2012-08-01 06:58:58',21,'N',0,'pics/1_1343804338_thumb.jpg','',0),(84,36,1,'Washing Machine','Whirlpool','New','New',2012,120,12,'pics/1_1343809982.jpg','Whirlpool-Washing Machine','2012-08-01 08:33:02',8,'N',0,'pics/1_1343809982_thumb.jpg','',0),(85,121,78,'Creative Art','','New','New',2012,10,6,'pics/78_1344659979.jpg','Creative Art','2012-08-11 04:39:39',10,'N',1,'pics/78_1344659979_thumb.jpg','Creative Art',0),(86,33,78,'cartoon','','New','New',2012,10,0,'','The broker','2012-11-06 06:59:31',3,'N',0,'','Testing',0),(98,34,91,'The coin','','New','New',2013,12,5,'pics/91_1364286545.jpg','The coin description','2013-03-26 08:29:05',18,'N',0,'pics/91_1364286545_thumb.jpg','Chrysanthemum',0),(99,31,112,'MyShirt','','New','New',2014,100,0,'','Fantastic Shirt','2014-04-12 06:03:28',2,'N',0,'','',50),(103,36,115,' Ford Fiesta ','Ford','Used','Like New',2013,250,10,'pics/medium_115_1426597059Desert.jpg','Officially Britain\'s best-selling car of all time, the Ford Fiesta combines contemporary style with state-of-the-art technology','2014-10-14 00:30:50',1,'Y',0,'pics/small_115_1426597059Desert.jpg','The 2014 Ford Fiesta has head-turning good looks, sporty performance and an EPA-estimated 45/hwy mpg. Build & Price, choose colors and more.',10),(104,25,119,'Mouse','Dell','Used','Like New',2014,2,2,'','ewrwr','2014-12-08 00:44:11',2,'N',0,'','',3),(106,89,12,'Benz C-classs','Mercedes Benz','Used','New',2003,20000,234,'','Very good car','2015-04-08 03:41:16',2,'Y',0,'pics/small_12_14287505904.jpg','Front view',1),(108,33,111,'Tough people survive Tough people survive Tough people survive Tough people survive','DC Books','New','New',2015,100,0,'pics/108_1428742559_58.jpg','test','2015-04-10 00:18:58',3,'Y',0,'pics/108_1428742559_58_thumb.jpg','testsssssssssss',10),(109,25,111,'Compaq','PC','New','New',2015,34,1,'pics/medium_111_1428662014DSC00803_Long_Exposure_Supermoon_Over_San_Francisco_Bay.jpg','test','2015-04-10 00:22:39',0,'Y',0,'pics/small_111_1428662014DSC00803_Long_Exposure_Supermoon_Over_San_Francisco_Bay.jpg','',0),(111,38,111,'Banglore Days','T Series','New','New',2015,1,1,'','this is test product but not for sale','2015-04-11 02:17:48',2,'N',0,'pics/small_111_1428743639_DSC5071.jpg','Madrass Mail',1),(116,37,104,'mug','laopala','Used','Like New',2013,100,1,'pics/104_1384514578.jpg','this is a mug ...............','2013-11-15 16:52:58',12,'N',0,'','this is an orange mug',0),(118,72,111,'Sony Xperia','ABC','New','New',2015,45,2,'pics/medium_111_1436252857Wallpaper-Anime-3D-61.jpg','test','2015-04-24 04:19:09',3,'Y',0,'pics/small_111_1436252857Wallpaper-Anime-3D-61.jpg','asd',0),(119,89,111,'Hotwheels','','New','New',2015,5,5,'','Hotwheels','2015-04-24 05:02:59',5,'N',0,'','',0),(120,68,111,'Rubco SofaRubco Sofa','','New','New',2015,34,0,'','Rubco Sofa','2015-04-27 01:28:35',5,'Y',1,'pics/small_111_1431525528csk.jpg','',0),(121,72,137,'LG Flux2','LG','New','New',2015,52,1,'pics/medium_137_1430212614index.jpg','This is a new brand introduced','2015-04-28 02:17:21',10,'Y',0,'pics/small_137_1430212614index.jpg','The side view ',10),(152,70,111,'dsfgdfg','','New','New',2016,4,4,'','rgert','2016-04-25 02:02:20',5,'N',1,'','dfgdgdg',0),(153,25,111,'Name of Product ','','New','New',2016,444,4,'','eterte','2016-04-25 02:06:19',7,'N',0,'','gdg',6),(154,31,1,'Black kurtha','','New','New',2016,33,0,'pics/medium_1_1485759356productbig__0_1469095530breakfast_2.jpg','erwer','2016-04-25 02:13:06',2,'Y',0,'pics/small_1_1485759356productbig__0_1469095530breakfast_2.jpg','',0),(155,90,111,'wrwer','','New','New',2016,3,0,'','werwer','2016-04-25 02:42:30',33,'N',0,'','erwerw',4),(151,34,111,'test','','New','New',2016,4,0,'pics/medium_111_146182706951-09HuEEaL._SX258_BO1204203200_.jpg','desc','2016-04-21 22:12:33',0,'Y',0,'pics/small_111_146182706951-09HuEEaL._SX258_BO1204203200_.jpg','eeee',0),(131,31,111,'Shirt','Peter England','New','New',2015,1,0,'','This is a new Shirt.','2015-06-21 23:17:48',10,'N',0,'','',2),(129,12,120,'Nikon','Nikon','New','New',2015,500,0,'','Nikon','2015-05-13 05:20:06',0,'Y',0,'','',0),(130,31,111,'Test','zfsdfgd','New','New',2015,20,1,'pics/medium_111_1431690378Chrysanthemum.jpg','gdrgtrh cghk','2015-05-15 04:46:55',10,'N',0,'pics/small_111_1431690378Chrysanthemum.jpg','zdsgdhb cgfjtyk bvjtyi gfjytiji78',0),(133,33,139,'Catching the fire','','New','New',2015,10,5,'pics/medium_139_1435396072catchingthe_fire.jpg','Catching the fire','2015-06-27 02:08:29',20,'N',0,'pics/small_139_1435396072catchingthe_fire.jpg','',0),(134,37,139,'Red Cup','timex','New','New',2015,20,22,'pics/medium_139_1435396977clocks.jpg','red cup','2015-06-27 02:23:12',8,'N',0,'pics/small_139_1435396977clocks.jpg','',0),(135,68,111,'landscape','','New','New',2015,65,1,'pics/medium_111_1435562263image1.jpg','big image','2015-06-29 00:18:31',20,'N',0,'pics/small_111_1435562263image1.jpg','',0),(136,171,111,'balloon','','New','New',1996,20,0,'pics/medium_111_1435570089balloonzz.jpg','balloon','2015-06-29 02:28:25',20,'N',0,'pics/small_111_1435570089balloonzz.jpg','',0),(156,92,201,'asd','','New','New',2016,234,0,'','asd','2016-05-04 22:14:05',234,'N',0,'','',0),(158,31,1,'Check cloth','Denim','New','New',1956,1,0,'pics/medium_1_1485757040productbig__0_1469095530breakfast_2.jpg','Check cloth','2017-01-26 23:04:51',10000,'Y',0,'pics/small_1_1485757040productbig__0_1469095530breakfast_2.jpg','',0),(141,68,111,'chair','','New','New',2015,10,0,'','chair','2015-07-03 04:23:59',20,'N',0,'','',0),(150,39,111,'rrrrrrrrrrrrrrrrrrrrrr','','New','New',2016,4,4,'','fhfghgf','2016-04-21 05:19:03',4,'N',1,'','',0),(146,68,111,'umbrella','poppy','New','New',2015,5,0,'pics/medium_111_1436257590songbird.png','umbrella main desc','2015-07-07 01:27:58',10,'N',0,'pics/small_111_1436257590songbird.png','aaaaaa',0),(148,39,111,'palace','','New','New',2015,30,0,'pics/medium_111_1437026231palace.jpg','large palace','2015-07-15 22:57:43',12,'Y',0,'pics/small_111_1437026231palace.jpg','',0);

--
-- Table structure for table `es_saledetails`
--

CREATE TABLE `es_saledetails` (
  `nSaleId` int(11) DEFAULT '0',
  `nUserId` int(11) DEFAULT '0',
  `vMethod` varchar(50) DEFAULT NULL,
  `vTxnId` varchar(100) DEFAULT NULL,
  `nAmount` double DEFAULT '0',
  `dDate` datetime DEFAULT NULL,
  `nQuantity` double DEFAULT '0',
  `vSaleStatus` varchar(10) DEFAULT '2',
  `nCashTxnId` int(11) DEFAULT '0',
  `vRejected` varchar(10) DEFAULT '0',
  `dTxnDate` datetime DEFAULT NULL,
  `vDelivered` char(2) DEFAULT 'N',
  `nPoint` double NOT NULL DEFAULT '0',
  `vAddress1` varchar(100) DEFAULT NULL,
  `vAddress2` varchar(100) DEFAULT NULL,
  `vCity` varchar(100) DEFAULT NULL,
  `vState` varchar(100) DEFAULT NULL,
  `vCountry` varchar(100) DEFAULT NULL,
  `nZip` varchar(11) DEFAULT NULL,
  `vPhone` varchar(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_saledetails`
--

INSERT INTO `es_saledetails` VALUES (81,89,'pp',NULL,10,'2013-02-19 10:06:41',1,'4',0,'0','2013-02-19 15:23:15','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(96,78,'pp',NULL,250,'2013-02-19 10:14:47',1,'4',0,'0','2013-02-19 15:32:08','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(95,78,'pp',NULL,250,'2013-02-19 10:19:31',1,'1',0,'0','2013-02-19 15:36:05','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(96,78,'cc','0',250,'2013-03-08 10:02:00',1,'3',8,'0','2013-03-08 15:17:16','Y',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(83,89,'pp',NULL,57,'2013-02-21 05:19:42',1,'1',0,'0','2013-02-21 10:36:06','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(86,89,'cc',NULL,0,'2013-03-08 09:59:00',1,'1',0,'0','2013-03-08 15:14:03','N',100,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(84,89,'cc','0',132,'2013-03-08 10:00:02',1,'2',0,'0','2013-03-08 15:15:42','Y',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,1,'cc',NULL,3,'2013-04-01 11:04:43',1,'1',0,'0','2013-04-01 16:17:19','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(76,89,'cc','0',12,'2013-03-08 11:11:00',1,'2',0,'0','2013-03-08 16:26:22','Y',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52,87,'bp',NULL,3,'2013-07-27 09:18:34',1,'1',0,'0','2013-07-27 14:17:59','N',3,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(96,92,'rp',NULL,250,'2013-10-17 09:46:39',1,'1',0,'0','2013-10-17 09:46:47','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1,110,'pp',NULL,66,'2013-12-09 11:41:16',1,'1',0,'0','2013-12-09 11:41:20','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,110,'pp',NULL,1,'2013-12-09 11:44:49',1,'1',0,'0','2013-12-09 11:45:03','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,110,'pp',NULL,1,'2013-12-10 13:45:11',1,'1',0,'0','2013-12-10 13:45:17','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,110,'pp',NULL,14,'2013-12-10 13:48:00',1,'1',0,'0','2013-12-10 13:50:05','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,110,'pp',NULL,244,'2013-12-13 10:25:20',1,'1',0,'0','2013-12-13 15:55:24','N',123,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,110,'pp',NULL,244,'2013-12-13 10:29:08',1,'1',0,'0','2013-12-13 15:59:12','N',123,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,110,'pp',NULL,1,'2013-12-13 10:41:25',1,'1',0,'0','2013-12-13 16:11:30','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(83,110,'pp',NULL,57,'2013-12-13 10:37:37',1,'1',0,'0','2013-12-13 16:07:40','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(83,110,'pp',NULL,57,'2013-12-13 11:26:58',1,'1',0,'0','2013-12-13 16:57:02','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(96,104,'wt',NULL,250,'2013-12-17 09:53:43',1,'1',0,'0','2013-12-17 09:54:15','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,110,'rp','',1,'2013-12-28 12:35:05',1,'2',0,'0','2013-12-28 18:10:34','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,110,'pp',NULL,1,'2013-12-28 12:40:48',1,'1',0,'0','2013-12-28 18:15:36','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1,110,'pp',NULL,66,'2013-12-31 08:27:31',1,'1',0,'0','2013-12-31 14:05:20','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,110,'pp',NULL,1,'2013-12-28 13:17:27',1,'1',0,'0','2013-12-28 18:47:33','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,110,'pp',NULL,1,'2013-12-28 13:22:07',1,'1',0,'0','2013-12-28 18:52:14','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,110,'pp',NULL,14,'2013-12-28 13:47:26',1,'1',0,'0','2013-12-28 19:17:32','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,110,'pp',NULL,14,'2013-12-28 13:57:13',1,'1',0,'0','2013-12-28 19:27:20','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,110,'pp',NULL,1,'2013-12-31 08:40:09',1,'1',0,'0','2013-12-31 14:10:12','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(95,112,'cc','0',250,'2014-06-23 22:00:40',1,'2',0,'0','2014-06-24 10:20:22','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(93,111,'cc','0',6,'2014-06-23 21:53:14',1,'2',0,'0','2014-06-24 10:13:22','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(96,111,'cc',NULL,250,'2014-07-09 01:52:30',1,'1',0,'0','2014-07-09 14:21:49','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(100,112,'pp',NULL,5,'2014-07-14 05:05:38',1,'1',0,'0','2014-07-14 17:34:26','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(96,111,'pp',NULL,250,'2014-07-15 03:41:53',1,'1',0,'0','2014-07-15 16:10:43','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(96,116,'pp',NULL,250,'2014-10-10 02:13:35',1,'4',0,'0','2014-10-10 14:40:27','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(101,113,'pp',NULL,30,'2014-08-05 06:31:26',1,'1',0,'0','2014-08-05 18:58:50','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(101,113,'cc','0',30,'2014-08-05 21:57:38',1,'3',10,'0','2014-08-06 10:25:36','Y',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(96,113,'pp',NULL,250,'2014-08-05 22:43:14',1,'1',0,'0','2014-08-06 11:10:34','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(81,89,'pp',NULL,0,NULL,0,'2',0,'0',NULL,'N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(96,115,'pp',NULL,250,'2014-10-14 03:11:17',1,'4',0,'0','2014-10-14 15:32:42','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(105,111,'cc','75D37996DM545820M',120,'2015-03-31 21:59:16',1,'2',0,'0','2015-04-17 15:23:06','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,115,'cc','0',1,'2014-11-18 04:21:05',1,'2',0,'0','2014-11-18 17:38:59','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(87,111,'pp',NULL,16,'2014-10-30 05:39:33',1,'4',0,'0','2014-10-30 17:59:04','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(105,111,'pp','75D37996DM545820M',120,'2015-04-17 03:05:37',1,'2',0,'0','2015-04-17 15:23:06','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(109,1,'cc','0',35,'2015-04-17 05:19:48',1,'2',0,'0','2015-04-17 17:36:23','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(109,121,NULL,'0FJ14874MK710863W',35,'2015-04-17 06:24:56',1,'3',11,'0','2015-04-20 10:43:56','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(109,121,'pp','0FJ14874MK710863W',105,'2015-04-19 22:09:55',3,'2',0,'0','2015-04-20 10:43:56','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(109,121,'pp','0FJ14874MK710863W',35,'2015-04-19 22:25:40',1,'2',0,'0','2015-04-20 10:43:56','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(105,121,'pp','29A437061J750591T',120,'2015-04-19 22:38:14',1,'2',0,'0','2015-04-20 11:23:05','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(105,121,'pp','29A437061J750591T',120,'2015-04-19 22:42:15',1,'2',0,'0','2015-04-20 11:23:05','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(105,121,'cc','29A437061J750591T',120,'2015-04-19 22:57:18',1,'2',0,'0','2015-04-20 11:23:05','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(105,121,'pp','29A437061J750591T',120,'2015-04-19 23:04:14',1,'2',0,'0','2015-04-20 11:23:05','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(96,121,'cc','0',250,'2015-04-19 23:35:58',1,'2',0,'0','2015-04-20 11:53:02','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(105,121,'cc',NULL,120,'2015-04-19 23:45:09',1,'1',0,'0','2015-04-20 12:01:06','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(114,121,'pp','3CT26170AV971294U',34,'2015-04-21 03:04:37',1,'2',0,'0','2015-04-21 15:22:57','Y',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(105,111,'wt',NULL,120,'2015-04-21 03:37:34',1,'1',0,'0','2015-04-21 15:54:59','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(105,111,'wt',NULL,120,'2015-04-22 02:11:43',1,'1',0,'0','2015-04-22 14:27:32','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(96,111,'pp',NULL,250,'2015-04-22 02:25:29',1,'1',0,'0','2015-04-22 15:03:36','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(105,111,'pp',NULL,120,'2015-04-22 02:14:45',1,'1',0,'0','2015-04-22 14:31:35','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(109,120,'pp','25K09460XE388111L',35,'2015-04-22 04:12:49',1,'2',0,'0','2015-04-22 16:29:36','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,120,'pp','9TR48401JY0572258',14,'2015-04-23 03:42:09',1,'4',0,'0','2015-04-23 15:58:19','N',0,'Kakkanad','','Ernakulam','Kerala','United States','682020','2255669'),(20,120,'pp','9TR48401JY0572258',14,'2015-04-23 03:40:31',1,'4',0,'0','2015-04-23 15:58:19','N',0,'Kakkanad','','Ernakulam','Kerala','United States','682020','2255669'),(105,120,'pp',NULL,120,'2015-04-23 03:35:42',1,'4',0,'0','2015-04-23 15:51:28','N',0,'Kakkanad','','Ernakulam','Kerala','United States','682020','2255669'),(105,120,'ca',NULL,120,'2015-04-22 22:34:00',1,'4',0,'0','2015-04-23 12:09:34','N',0,'Kakkanad','','','Kerala','United States','682020','2255669'),(105,120,'pp',NULL,240,'2015-04-23 03:36:54',2,'4',0,'0','2015-04-23 15:52:39','N',0,'Kakkanad','','Ernakulam','Kerala','United States','682020','2255669'),(96,111,'pp',NULL,250,'2015-04-24 02:22:10',1,'4',0,'0','2015-04-24 14:37:52','N',0,'Tset','','asdfasd','sdaf','United States','fasdfa','sdfasd'),(105,111,'pp',NULL,120,'2015-04-24 02:33:08',1,'4',0,'0','2015-04-24 14:48:49','N',0,'Tset','','sdfasdf','fasdfas','United States','dfd','asdf'),(105,120,'pp',NULL,120,'2015-04-24 02:42:00',1,'4',0,'0','2015-04-24 15:00:55','N',0,'Kakkanad','','Ernakulam','Kerala','United States','682020','2255669'),(96,111,'pp',NULL,250,'2015-04-24 02:20:14',1,'4',0,'0','2015-04-24 14:35:57','N',0,'Tset','','sdfasd','fasdf','United States','asdfa','asdf'),(105,111,'wt',NULL,120,'2015-04-23 04:02:53',1,'4',0,'0','2015-04-23 16:18:38','N',0,'df','ds','sdfdsf','asdfasfsd','Afghanistan','sdfdsf','dfsd'),(105,111,'pp',NULL,120,'2015-04-24 03:00:15',1,'4',0,'0','2015-04-24 15:15:58','N',0,'Tset','','asdfasdf','dfs','United States','asdfasdf','sdfsf'),(96,111,'pp','CXD3456',250,'2015-04-24 03:42:32',1,'4',0,'0','2015-04-24 16:15:00','N',0,'Tset','asdasd','Ernakulam','Kerala','United States','682300','12345678'),(118,120,'mo',NULL,45,'2015-04-30 03:55:14',1,'4',0,'0','2015-04-30 16:11:08','N',0,'Kakkanad','','Ernakulam','Kerala','United States','682020','2255669'),(124,111,'pp','1TM75712TV842623F',3,'2015-06-21 23:07:19',1,'2',0,'0','2015-06-22 22:37:30','N',0,'Tset','','Ct','St','United States','50030','8050201040'),(134,111,'pp',NULL,42,'2015-06-30 04:08:20',1,'1',0,'0','2015-07-01 03:36:08','N',0,'Tset','divine line','mobile','Colorado','United States','78334','9876543210'),(134,111,'pp','40W40667KM1026255',42,'2015-06-30 04:32:39',1,'3',13,'0','2015-07-01 04:00:25','N',0,'Tset','','mobile','Colorado','United States','78334','9876543210'),(133,111,'pp',NULL,15,'2015-06-30 04:37:32',1,'1',0,'0','2015-07-01 04:04:56','N',0,'Tset','','mobile','Colorado','United States','78334','9876543210'),(108,114,'cc',NULL,100,'2015-06-30 23:09:27',1,'1',0,'0','2015-07-01 22:36:54','N',10,'texas','','fdsgds','zsd','United States','0010d0','9876543210'),(118,114,'pp',NULL,45,'2015-06-30 23:13:47',1,'1',0,'0','2015-07-01 22:41:12','N',0,'texas','','fth','dgdf','United States','jyti','ykyukuiloui'),(118,144,'pp','1K12201533591970P',47,'2015-07-01 02:48:02',1,'2',0,'0','2015-07-02 02:18:54','N',0,'infopark','','cochin','kerala','India','682032','9876543210'),(134,111,'cc','0',42,'2015-07-01 04:13:32',1,'0',NULL,'0','2015-07-02 03:41:44','N',0,'Tset','texas','newyork','Arizona','United States','11220','9876543210'),(133,111,'bu',NULL,15,'2015-07-01 04:21:51',1,'1',0,'0','2015-07-02 03:50:00','N',0,'Tset','texas','mobile','Colorado','United States','78334','9876543210'),(133,111,'cc',NULL,15,'2015-07-01 04:29:19',1,'1',0,'0','2015-07-02 03:56:45','N',0,'Tset','','mobile','Colorado','United States','78334','9876543210'),(117,120,'cc','0',25,'2015-07-06 22:02:10',1,'2',0,'0','2015-07-07 21:36:47','N',0,'Kakkanad','','Ernakulam','Kerala','United States','682020','2255669'),(117,139,'rp',NULL,25,'2015-07-03 02:12:23',1,'1',0,'0','2015-07-04 01:43:32','N',0,'texas','','newyork','texas','United States','11220','9876543210'),(117,120,'pp','4uu04419rd6483233',25,'2015-07-06 22:21:17',1,'2',0,'0','2015-07-07 21:48:43','N',0,'Kakkanad','','Ernakulam','Kerala','United States','682020','2255669'),(117,120,'mo',NULL,25,'2015-07-06 22:24:04',1,'1',0,'0','2015-07-07 21:51:36','N',0,'Kakkanad','','Ernakulam','Kerala','United States','682020','2255669'),(147,121,'pp',NULL,20,'2015-08-20 05:55:18',1,'1',0,'0','2015-08-21 05:20:28','N',0,'Armia Systems','','Ernakulam','Kerala','Afghanistan','682020','9996665552'),(147,89,'pp','5AE15312XK278824N',20,'2015-08-20 22:28:31',1,'4',0,'0','2015-08-21 21:55:52','N',0,'aasa','asdasd','GALT','ALABAMA','United States','35005','343-343-3434'),(118,114,'pp',NULL,47,'2016-02-18 23:16:36',1,'1',0,'0','2016-02-19 23:32:04','N',0,'texas','','asd','Kakkand','United States','123456','12345'),(117,114,'cc','0',25,'2016-02-19 01:19:35',1,'2',0,'0','2016-02-20 01:36:17','N',0,'texas','','tutyu','uytut','United States','65757','5675675'),(140,111,'cc',NULL,25,'2016-04-21 06:04:27',1,'1',0,'0','2016-04-22 05:16:33','N',0,'Tset','','sda','alabama','United States','0123465','545362145'),(147,8,'pp',NULL,40,'2016-02-25 22:10:33',2,'1',0,'0','2016-02-27 03:12:07','N',0,'dff','','Interchelan','Florida','Afghanistan','20005','767876'),(117,8,'cc','0',25,'2016-02-28 23:04:04',1,'2',0,'0','2016-02-29 23:46:25','N',0,'dff','','Interchelan','Florida','Afghanistan','20005','767876'),(147,8,'cc','0',20,'2016-02-29 01:45:34',1,'2',0,'0','2016-03-01 23:41:06','N',0,'dff','','Interchelan','Florida','Afghanistan','20005','767876'),(148,137,'cc','0',30,'2016-04-05 23:07:05',1,'2',0,'0','2016-04-06 22:20:32','N',0,'Armia Systems','','jkhk','ker','United States','56756756','67657567'),(148,8,'cc','0',30,'2016-03-02 22:19:51',1,'2',0,'0','2016-03-03 22:35:13','N',0,'dff','','Interchelan','Florida','Afghanistan','20005','767876'),(121,111,'cc','0',53,'2016-04-24 22:41:01',1,'3',14,'0','2016-04-25 21:53:31','N',10,'Tset','','kakkanad','State or Province','United States','546466','464646'),(118,8,'pp','3L085746AR386242A',47,'2016-04-27 02:49:38',1,'2',0,'0','2016-04-28 02:01:57','N',0,'dff','','Interchelan','Florida','Afghanistan','20005','767876'),(151,8,'pp','0YG52428YL749624T',4,'2016-04-29 05:37:53',1,'2',0,'0','2016-04-30 04:49:49','N',0,'dff','','Interchelan','Florida','Afghanistan','20005','767876'),(84,111,'pp','0G995311BG0531242',132,'2016-05-01 23:44:07',1,'2',0,'0','2016-05-02 22:56:10','N',0,'Tset','','kakkanad','State or Province','United States','546466','464646'),(148,8,'cc',NULL,30,'2016-05-02 01:18:10',1,'1',0,'0','2016-05-03 00:29:41','N',0,'dff','','Interchelan','Florida','Afghanistan','20005','767876'),(121,111,'pp','0SK3307805280282E',53,'2016-05-02 23:18:46',1,'2',0,'0','2016-05-03 22:30:41','N',10,'Tset','','kakkanad','State or Province','United States','546466','464646'),(154,111,'pp','1FR15261BP905545M',33,'2016-05-02 23:33:36',1,'2',0,'0','2016-05-03 22:45:46','N',0,'Tset','','kakkanad','State or Province','United States','546466','464646'),(154,111,'pp','1U288983K2364174R',33,'2016-05-02 23:58:00',1,'2',0,'0','2016-05-03 23:37:48','N',0,'Tset','','kakkanad','State or Province','United States','546466','464646'),(154,111,'cc',NULL,33,'2016-05-03 02:00:38',1,'1',0,'0','2016-05-04 01:12:08','N',0,'Tset','','kakkanad','State or Province','United States','546466','464646'),(147,164,'pp','75R11491X41894253',20,'2016-05-03 06:19:47',1,'2',0,'0','2016-05-04 05:31:39','N',0,'ddfsf','','234','sdf','Afghanistan','234','2344'),(157,201,'pp','5WN63915M23941927',345,'2016-05-05 00:21:19',1,'2',0,'0','2016-05-05 23:33:15','Y',0,'234','','234','234','Afghanistan','23424','34234'),(148,201,'cc','0',30,'2016-05-10 06:46:14',1,'2',0,'0','2016-05-11 05:57:38','N',0,'asd','','324','asd','Afghanistan','234','234'),(147,201,'pp','4RJ76743UT778253L',20,'2016-05-10 06:47:17',1,'2',0,'0','2016-05-11 05:58:40','N',0,'324','','234','234','Afghanistan','234','234'),(147,201,'pp',NULL,20,'2016-05-10 06:47:17',1,'1',0,'0','2016-05-11 05:58:20','N',0,'324','','234','234','Afghanistan','234','234'),(148,1,'pp','710640219X445170K',30,'2016-12-15 01:11:58',1,'2',0,'0','2016-12-15 22:50:34','N',0,'simi','','simi','simi','Afghanistan','2423234','23432'),(148,1,'pp','45J39822C4803980A',30,'2016-12-15 01:24:31',1,'2',0,'0','2016-12-15 22:58:34','N',0,'simi','','simi','simi','Afghanistan','2423234','23432'),(148,1,'pp','1WJ37603PH5787732',30,'2016-12-15 01:31:51',1,'2',0,'0','2016-12-15 23:06:34','N',0,'simi','','simi','simi','Afghanistan','2423234','23432'),(108,1,'cc',NULL,100,'2017-01-24 21:35:06',1,'1',0,'0','2017-01-25 19:05:16','N',10,'simi','','simi','simi','Afghanistan','2423234','23432'),(154,164,'pp',NULL,33,'2017-02-10 04:38:10',1,'1',0,'0','2017-02-11 02:08:02','N',0,'asdfsd','sdf','dfsdf','sdf','Afghanistan','2323232','234234234');

--
-- Table structure for table `es_saleextra`
--

CREATE TABLE `es_saleextra` (
  `nSaleextraId` int(11) NOT NULL AUTO_INCREMENT,
  `nCategoryId` int(11) DEFAULT '0',
  `nUserId` int(11) DEFAULT '0',
  `vTitle` varchar(100) DEFAULT NULL,
  `vBrand` varchar(100) DEFAULT NULL,
  `vType` varchar(100) DEFAULT NULL,
  `vCondition` varchar(100) DEFAULT NULL,
  `vYear` int(4) DEFAULT NULL,
  `nValue` double DEFAULT '0',
  `nShipping` double DEFAULT '0',
  `vUrl` varchar(100) DEFAULT NULL,
  `vDescription` text,
  `dPostDate` datetime DEFAULT NULL,
  `nQuantity` double DEFAULT '0',
  `nFeatured` double NOT NULL DEFAULT '0',
  `nCommission` double DEFAULT '0',
  `vReferenceNo` varchar(100) DEFAULT NULL,
  `vName` varchar(100) DEFAULT NULL,
  `vBank` varchar(100) DEFAULT NULL,
  `dReferenceDate` datetime DEFAULT NULL,
  `vMode` varchar(10) DEFAULT NULL,
  `vSmlImg` varchar(200) DEFAULT NULL,
  `vImgDes` text,
  `nPoint` float NOT NULL DEFAULT '0',
  PRIMARY KEY (`nSaleextraId`)
) ENGINE=MyISAM AUTO_INCREMENT=98 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_saleextra`
--

INSERT INTO `es_saleextra` VALUES (2,35,103,'antique chain','Tbz','New','Very Good',2013,5000,10,'','Antique piece','2013-11-14 10:49:25',2,0,100,NULL,NULL,NULL,NULL,NULL,'','Antique piece',5),(32,72,111,'Moto G','','New','New',2015,34,0,'','test','2015-04-24 04:23:57',4,1,0.68,NULL,NULL,NULL,NULL,NULL,'','',0),(35,36,111,'Jaguar','','New','New',2015,456,0,'','Jaguar','2015-04-27 01:41:10',3,1,9.12,NULL,NULL,NULL,NULL,NULL,'','',0),(14,89,12,'Benz C-class','Mercedes Benz','Used','Very Good',2000,7500000,234,'pics/medium_12_14284889782.jpg','Very good car','2015-04-08 03:31:48',2,0,150000,NULL,NULL,NULL,NULL,NULL,'pics/small_12_14284889782.jpg','Side View',300),(7,25,114,'Test Product Nirmala','xzvfzfd','New','New',2014,30,2,'','cvgdfg','2014-08-05 06:25:39',1,1,0.6,NULL,NULL,NULL,NULL,NULL,'','',0),(11,12,12,'test quiz','','New','New',2015,100,0,'','desc','2015-03-17 23:14:17',22,0,2,NULL,NULL,NULL,NULL,NULL,'','',0),(13,89,12,'Benz C-class','Mercedes Benz','Used','Very Good',2003,7500000,23,'pics/medium_12_14284887714.jpg','Very attractive car','2015-04-08 03:28:23',2,1,150000,NULL,NULL,NULL,NULL,NULL,'pics/small_12_14284887714.jpg','Front View',200),(19,25,111,'dfg','dsdfsdf','Used','Very Good',2015,54345,0,'pics/medium_111_14286713722.jpg','dfgdfg','2015-04-10 06:12:35',4,0,906.9,NULL,NULL,NULL,NULL,NULL,'pics/small_111_14286713722.jpg','',45345),(21,12,111,'sdfgsdfgsdf','','New','New',2015,34,0,'','asdf','2015-04-11 05:05:33',3,0,0.68,NULL,NULL,NULL,NULL,NULL,'','',0),(22,12,111,'sdfsdf','','New','New',2015,34,0,'','sdf','2015-04-11 05:06:03',4,1,0.68,NULL,NULL,NULL,NULL,NULL,'','',0),(23,33,111,'dfhdh','','New','New',2015,100,0,'','gf','2015-04-11 05:06:24',6,0,2,NULL,NULL,NULL,NULL,NULL,'','',0),(24,12,121,'Compaq','','New','New',2015,34,0,'','tets','2015-04-16 22:55:05',2,1,0.68,NULL,NULL,NULL,NULL,NULL,'','',0),(25,12,111,'@@@@@@@@@@@@@@@@@','','New','New',2015,45,0,'','sdfgsdfg','2015-04-21 03:23:34',45,1,0.9,NULL,NULL,NULL,NULL,NULL,'','',0),(26,31,111,'dsfddfsd','','New','New',2015,45,0,'','sdfsd','2015-04-24 00:22:09',4,0,0.9,NULL,NULL,NULL,NULL,NULL,'','',0),(27,34,111,'asdfasdf','','New','New',2015,3,0,'','asdfd','2015-04-24 02:57:53',3,0,0.06,NULL,NULL,NULL,NULL,NULL,'','',0),(28,33,111,'cvcx','','New','New',2015,4,0,'','xcvxc','2015-04-24 03:07:54',5,0,0.08,NULL,NULL,NULL,NULL,NULL,'','',0),(39,33,120,'dfsgsfg','','New','New',2015,5,0,'','dfgsdfg','2015-04-29 05:55:27',4,0,0.1,NULL,NULL,NULL,NULL,NULL,'','',0),(40,33,111,'asdfasd','','New','New',2015,3,0,'','sdfasdf','2015-04-30 00:11:30',3,0,0.06,NULL,NULL,NULL,NULL,NULL,'','',0),(65,37,111,'london clock','london','New','New',2015,20,0,'pics/medium_111_1437474895newgate_clocks.jpg','london clock','2015-07-21 03:36:07',10,0,0.4,'123456','vidhya','','2015-11-11 00:00:00','ca','pics/small_111_1437474895newgate_clocks.jpg','',0),(42,33,111,'adsfasd','','New','New',2015,34,0,'','asdfas','2015-05-08 04:15:40',3,0,0.68,NULL,NULL,NULL,NULL,NULL,'','',0),(44,33,111,'asdfasd','','New','New',2015,434,0,'','asdfasdf','2015-05-12 06:42:38',2,0,8.68,NULL,NULL,NULL,NULL,NULL,'','',0),(45,25,111,'Headphone','Creative','New','New',2015,25,2,'','Best headphone','2015-05-12 07:34:00',10,1,0.5,NULL,NULL,NULL,NULL,NULL,'','',20),(46,25,111,'Headphone','Creative','New','New',2015,25,2,'','Best headphone','2015-05-12 07:42:31',10,1,0.5,NULL,NULL,NULL,NULL,NULL,'','',20),(47,33,111,'asdfasd','','New','New',2015,43,0,'','adsfasdf','2015-05-12 22:24:01',2,0,0.86,NULL,NULL,NULL,NULL,NULL,'','',0),(48,34,111,'asdfasd','','New','New',2015,34,0,'','asdfas','2015-05-12 22:25:49',5,0,0.68,NULL,NULL,NULL,NULL,NULL,'','',0),(49,12,111,'adsfads','','New','New',2015,5.3,0,'','asdfasd','2015-05-12 22:27:39',3,0,0.11,NULL,NULL,NULL,NULL,NULL,'','',0),(50,33,111,'adfadsf','','New','New',2015,34,0,'','asdfasd','2015-05-12 22:32:00',3,0,0.68,NULL,NULL,NULL,NULL,NULL,'','',0),(51,33,111,'qwe','','New','New',2015,34,0,'','dsaf','2015-05-12 22:34:05',2,0,0.68,NULL,NULL,NULL,NULL,NULL,'','',0),(52,34,111,'asdfasdf','','New','New',2015,26,0,'','asdfasd','2015-05-12 23:16:27',3,0,0.52,NULL,NULL,NULL,NULL,NULL,'','',0),(53,31,111,'Benz C-classs','','New','New',2015,25,0,'','Benz C-classs','2015-05-13 01:34:08',2,0,0.5,NULL,NULL,NULL,NULL,NULL,'','',0),(54,36,111,'Benz C-classs','','New','New',2015,21,0,'pics/medium_111_1431506085bg_afternoon_1440x900.jpg','Benz C-classs','2015-05-13 01:35:07',2,0,0.42,NULL,NULL,NULL,NULL,NULL,'pics/small_111_1431506085bg_afternoon_1440x900.jpg','',0),(55,72,111,'Galaxy s6','Samsung','New','New',2015,100,2,'','Best new gen phone','2015-05-13 03:45:43',10,1,2,'123456','T S Sreejith','','2015-05-15 00:00:00','','','',50),(56,12,111,'Nipon','Nipon','New','New',2015,500,0,'','Test','2015-05-13 04:00:17',15,1,10,NULL,NULL,NULL,NULL,NULL,'','',0),(59,31,111,'xfgdg','','New','New',2015,500,0,'','dfgdth','2015-06-30 03:09:16',5,1,10,NULL,NULL,NULL,NULL,NULL,'','xgsdg',0),(64,37,111,'veg bag','','New','New',2015,20,0,'pics/medium_111_1436941999whole_veg.jpg','bag','2015-07-14 23:34:15',2,0,0.4,NULL,NULL,NULL,NULL,NULL,'pics/small_111_1436941999whole_veg.jpg','',0),(66,108,111,'onions','','New','New',2015,10,0,'pics/medium_111_1437475445onions.jpg','onions','2015-07-21 03:51:56',10,0,0.2,'123456','vidhya','','2014-11-12 00:00:00','wt','pics/small_111_1437475445onions.jpg','',0),(67,31,111,'cvbgcfh','fhggfh','New','New',2015,2,2,'','dfghfhhyujuy dfhgggggg','2015-08-25 02:04:14',2,1,0.04,NULL,NULL,NULL,NULL,NULL,'','',0),(68,70,111,'bird','bird','New','New',2015,20,1,'pics/medium_111_1447746205Koala.jpg','bird1','2015-11-16 23:45:11',1,0,0.02,NULL,NULL,NULL,NULL,NULL,'pics/small_111_1447746205Koala.jpg','description 1',1),(69,36,111,'Renault duster','','New','New',2016,3,3,'','eeeeeeeeeeeee','2016-04-21 05:15:46',4,0,0.06,NULL,NULL,NULL,NULL,NULL,'','',2),(72,34,111,'asd','asd','Used','New',2016,20,2,'','asdsdas sa dasd asdd','2016-04-21 05:47:45',5,1,0,NULL,NULL,NULL,NULL,NULL,'','asdasd',0),(74,31,111,'test clothing','testtest ','New','New',2016,5,0,'','test','2016-04-24 23:29:39',5,0,0.1,NULL,NULL,NULL,NULL,NULL,'','dfgdfg',4),(75,31,111,'test clothing','testtest ','New','New',2016,5,0,'','test','2016-04-24 23:31:33',5,4,0.1,NULL,NULL,NULL,NULL,NULL,'','dfgdfg',4),(76,25,111,'testing commision','','New','New',2016,1,0,'','dfgdfg','2016-04-24 23:56:12',2,4,0.05,NULL,NULL,NULL,NULL,NULL,'','eee',0),(78,90,111,'ghfghf','','New','New',2016,5,4,'','fghfhfgh','2016-04-25 02:04:11',55,0,0.25,NULL,NULL,NULL,NULL,NULL,'','tetet',55),(80,25,111,'Name of Product ','','New','New',2016,444,4,'','eterte','2016-04-25 02:10:47',7,0,22.2,NULL,NULL,NULL,NULL,NULL,'','gdg',6),(81,39,111,'sfsdfsd','','New','New',2016,3,0,'','dsfsdf','2016-04-25 02:11:01',3,0,0.15,NULL,NULL,NULL,NULL,NULL,'','efwrew',0),(83,39,111,'fsdfs','','New','New',2016,3,3,'','sdfsdf','2016-04-25 02:16:22',33,0,0.15,NULL,NULL,NULL,NULL,NULL,'','retet',0),(84,39,111,'fsdfs','','New','New',2016,3,3,'','sdfsdf','2016-04-25 02:17:22',33,0,0.15,NULL,NULL,NULL,NULL,NULL,'','retet',0),(85,39,111,'fsdfs','','New','New',2016,3,3,'','sdfsdf','2016-04-25 02:19:59',33,0,0.15,NULL,NULL,NULL,NULL,NULL,'','retet',0),(86,90,111,'tryrtyr','','New','New',2016,1,5,'','tryrty','2016-04-25 02:35:01',5,0,0.05,NULL,NULL,NULL,NULL,NULL,'','geterte',5),(87,39,111,'dfgdfg','','New','New',2016,4,0,'','dfgdfg','2016-04-25 02:35:22',44,0,0.2,NULL,NULL,NULL,NULL,NULL,'','rtert',0),(89,34,164,'Test #2','Test','New','New',2016,5,2,'pics/medium_164_1462174020avatar_04.jpg','Test','2016-05-02 00:27:22',100,0,0.25,NULL,NULL,NULL,NULL,NULL,'pics/small_164_1462174020avatar_04.jpg','',0),(90,92,201,'asd','','New','New',2016,324,0,'','dfsf','2016-05-04 21:29:25',324,4,32.4,NULL,NULL,NULL,NULL,NULL,'','',0),(91,92,201,'werwe','','New','New',2016,324,0,'','sdfs','2016-05-04 21:32:17',234,0,32.4,NULL,NULL,NULL,NULL,NULL,'','',0),(92,92,201,'34','','New','New',2016,234,0,'','sdf','2016-05-04 21:49:45',324,0,23.4,NULL,NULL,NULL,NULL,NULL,'','',0),(93,92,201,'dsf','','New','New',2016,2342,0,'','sdf','2016-05-04 22:05:01',234,0,936.8,NULL,NULL,NULL,NULL,NULL,'','',0),(97,68,164,'fr1','ssds','New','New',2017,0,0,'pics/medium_164_1486727313bug_shot_1481289183_2.png','adfasd','2017-02-10 03:48:50',3,4,0,NULL,NULL,NULL,NULL,NULL,'pics/small_164_1486727313bug_shot_1481289183_2.png','sdfsdf',34);

--
-- Table structure for table `es_saleinter`
--

CREATE TABLE `es_saleinter` (
  `nSaleInterId` int(11) NOT NULL AUTO_INCREMENT,
  `nSaleId` int(11) DEFAULT '0',
  `nUserId` int(11) DEFAULT '0',
  `dDate` datetime DEFAULT NULL,
  `vMethod` varchar(50) DEFAULT NULL,
  `vName` varchar(100) DEFAULT NULL,
  `vBank` varchar(100) DEFAULT NULL,
  `vReferenceNo` varchar(100) DEFAULT NULL,
  `dReferenceDate` datetime DEFAULT NULL,
  `dEntryDate` datetime DEFAULT NULL,
  `vDelStatus` varchar(10) DEFAULT '0',
  PRIMARY KEY (`nSaleInterId`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_saleinter`
--

INSERT INTO `es_saleinter` VALUES (1,117,120,'2015-07-06 22:24:04','wt','reee','','12345678','2009-01-01 00:00:00','2015-07-07 21:51:07','0');

--
-- Table structure for table `es_saletemp`
--

CREATE TABLE `es_saletemp` (
  `nSaleTempId` int(11) NOT NULL AUTO_INCREMENT,
  `nSaleId` int(11) DEFAULT '0',
  `nUserId` int(11) DEFAULT '0',
  `vMethod` varchar(50) DEFAULT NULL,
  `nAmount` double DEFAULT '0',
  `dDate` datetime DEFAULT '0000-00-00 00:00:00',
  `nQuantity` double DEFAULT '0',
  PRIMARY KEY (`nSaleTempId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_saletemp`
--


--
-- Table structure for table `es_sliders`
--

CREATE TABLE `es_sliders` (
  `nSId` int(11) NOT NULL AUTO_INCREMENT,
  `vName` varchar(200) DEFAULT NULL,
  `vImg` varchar(200) DEFAULT NULL,
  `nDate` date DEFAULT '0000-00-00',
  `vActive` enum('1','0') DEFAULT '0',
  `vlocUrl` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`nSId`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_sliders`
--

INSERT INTO `es_sliders` VALUES (2,'Banner','slider1430989243.jpg','2015-04-25','1','http://disney.com/'),(3,'Banner1','slider1430989253.jpg','2015-04-25','1',NULL),(4,'Banner2','slider1430989266.jpg','2015-05-07','1',NULL),(5,'Banner3','slider1430992543.jpg','2015-05-07','0',NULL),(7,'hand','slider1435925594.jpg','2015-07-04','1','http://yahoo.com'),(10,'simple3','slider1461326693.jpg','2015-07-07','1','http://disney.com/'),(11,'simple3','slider1461326826.jpg','2016-04-23','1','http://dff');

--
-- Table structure for table `es_smilies`
--

CREATE TABLE `es_smilies` (
  `nSId` int(100) NOT NULL AUTO_INCREMENT,
  `vImgCode` varchar(100) NOT NULL DEFAULT '',
  `vPath` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`nSId`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_smilies`
--

INSERT INTO `es_smilies` VALUES (1,':)',''),(2,':(',''),(3,';)',''),(4,':D',''),(5,';;)',''),(6,'>:D<',''),(7,':X',''),(8,';>',''),(9,':?',''),(10,':P',''),(11,':-X',''),(12,'=((',''),(13,':-O',''),(14,'X(',''),(15,';>',''),(16,'B-)',''),(17,':-S',''),(18,'#:-S',''),(19,'>:)',''),(20,':((',''),(21,':))',''),(23,'/:)','');

--
-- Table structure for table `es_state`
--

CREATE TABLE `es_state` (
  `ts_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `tc_id` bigint(20) DEFAULT '0',
  `ts_code` varchar(20) DEFAULT NULL,
  `ts_name` varchar(250) DEFAULT NULL,
  `ts_status` char(1) DEFAULT 'A',
  PRIMARY KEY (`ts_id`)
) ENGINE=MyISAM AUTO_INCREMENT=59 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_state`
--

INSERT INTO `es_state` VALUES (1,1,'AL','ALABAMA','A'),(2,1,'AK','ALASKA','A'),(4,1,'AZ','ARIZONA','A'),(5,1,'AR','ARKANSAS','A'),(6,1,'CA','CALIFORNIA','A'),(7,1,'CO','COLORADO','A'),(8,1,'CT','CONNECTICUT','A'),(9,1,'DE','DELAWARE','A'),(10,1,'DC','DISTRICT OF COLUMBIA','A'),(12,1,'FL','FLORIDA','A'),(13,1,'GA','GEORGIA','A'),(15,1,'HI','HAWAII','A'),(16,1,'ID','IDAHO','A'),(17,1,'IL','ILLINOIS','A'),(18,1,'IN','INDIANA','A'),(19,1,'IA','IOWA','A'),(20,1,'KS','KANSAS','A'),(21,1,'KY','KENTUCKY','A'),(22,1,'LA','LOUISIANA','A'),(23,1,'ME','MAINE','A'),(25,1,'MD','MARYLAND','A'),(26,1,'MA','MASSACHUSETTS','A'),(27,1,'MI','MICHIGAN','A'),(28,1,'MN','MINNESOTA','A'),(29,1,'MS','MISSISSIPPI','A'),(30,1,'MO','MISSOURI','A'),(31,1,'MT','MONTANA','A'),(32,1,'NE','NEBRASKA','A'),(33,1,'NV','NEVADA','A'),(34,1,'NH','NEW HAMPSHIRE','A'),(35,1,'NJ','NEW JERSEY','A'),(36,1,'NM','NEW MEXICO','A'),(37,1,'NY','NEW YORK','A'),(38,1,'NC','NORTH CAROLINA','A'),(39,1,'ND','NORTH DAKOTA','A'),(40,1,'MP','NORTHERN MARIANA ISLANDS','A'),(41,1,'OH','OHIO','A'),(42,1,'OK','OKLAHOMA','A'),(43,1,'OR','OREGON','A'),(44,1,'PW','PALAU','A'),(45,1,'PA','PENNSYLVANIA','A'),(46,1,'PR','PUERTO RICO','A'),(47,1,'RI','RHODE ISLAND','A'),(48,1,'SC','SOUTH CAROLINA','A'),(49,1,'SD','SOUTH DAKOTA','A'),(50,1,'TN','TENNESSEE','A'),(51,1,'TX','TEXAS','A'),(52,1,'UT','UTAH','A'),(53,1,'VT','VERMONT','A'),(54,1,'VI','VIRGIN ISLANDS','A'),(55,1,'VA','VIRGINIA','A'),(56,1,'WA','WASHINGTON','A'),(57,1,'WV','WEST VIRGINIA','A'),(58,1,'WI','WISCONSIN','A');

--
-- Table structure for table `es_successfee`
--

CREATE TABLE `es_successfee` (
  `nSId` bigint(20) NOT NULL AUTO_INCREMENT,
  `nUserId` int(11) NOT NULL DEFAULT '0',
  `nPurchaseBy` int(11) NOT NULL DEFAULT '0',
  `nProdId` int(11) NOT NULL DEFAULT '0',
  `nAmount` double NOT NULL DEFAULT '0',
  `nPoints` double NOT NULL DEFAULT '0',
  `vStatus` char(1) NOT NULL DEFAULT 'P',
  `dDate` date NOT NULL DEFAULT '0000-00-00',
  `vType` enum('sa','s','w') NOT NULL DEFAULT 's',
  PRIMARY KEY (`nSId`)
) ENGINE=MyISAM AUTO_INCREMENT=257 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_successfee`
--

INSERT INTO `es_successfee` VALUES (1,21,22,42,10,0,'A','2011-07-26','s'),(2,22,21,45,10,0,'A','2011-07-26','s'),(3,21,22,34,10,0,'A','2011-07-28','s'),(4,22,21,44,10,0,'A','2011-07-28','s'),(5,22,21,36,10,0,'P','2011-07-28','s'),(6,21,22,40,10,0,'A','2011-07-28','s'),(7,22,21,31,10,0,'P','2011-07-29','w'),(8,21,22,50,10,0,'P','2011-07-29','w'),(9,21,22,33,10,0,'P','2011-08-04','w'),(10,22,21,37,10,0,'P','2011-08-04','w'),(11,21,22,54,10,0,'P','2011-08-04','s'),(12,22,21,27,10,0,'P','2011-08-04','s'),(13,22,21,56,10,0,'P','2011-08-10','s'),(14,21,22,55,10,0,'P','2011-08-10','s'),(15,22,21,27,1,0,'P','2011-08-18','sa'),(16,22,21,58,1,0,'P','2011-08-18','s'),(17,21,22,57,1,0,'P','2011-08-18','s'),(18,21,37,67,55,0,'P','2011-11-16','s'),(19,37,21,66,55,0,'P','2011-11-16','s'),(20,21,37,72,55,0,'P','2011-11-22','w'),(21,37,21,71,55,0,'P','2011-11-22','w'),(22,21,37,74,55,0,'P','2011-11-22','w'),(23,37,21,73,55,0,'P','2011-11-22','w'),(24,57,37,91,15,0,'P','2011-12-12','s'),(25,37,57,85,15,0,'P','2011-12-12','s'),(26,21,37,65,15,0,'P','2011-12-14','sa'),(27,21,37,65,15,0,'P','2011-12-14','sa'),(28,21,37,52,15,0,'P','2011-12-14','sa'),(29,21,37,52,15,0,'P','2011-12-14','sa'),(30,21,37,54,15,0,'P','2011-12-14','sa'),(31,21,37,54,15,0,'P','2011-12-14','sa'),(32,21,37,54,15,0,'P','2011-12-14','sa'),(33,21,37,54,15,0,'P','2011-12-14','sa'),(34,21,37,54,15,0,'P','2011-12-14','sa'),(35,21,37,54,15,0,'P','2011-12-14','sa'),(36,21,37,54,15,0,'P','2011-12-14','sa'),(37,21,37,54,15,0,'P','2011-12-14','sa'),(38,21,37,53,15,0,'P','2011-12-14','sa'),(39,57,37,73,15,0,'P','2011-12-20','sa'),(40,57,37,73,15,0,'P','2011-12-20','sa'),(41,37,57,94,15,0,'P','2011-12-20','s'),(42,57,37,92,15,0,'P','2011-12-20','s'),(43,21,37,65,35,0,'P','2012-03-12','sa'),(44,1,37,4,35,0,'P','2012-03-12','sa'),(45,1,37,4,35,0,'P','2012-03-12','sa'),(46,57,37,73,35,0,'P','2012-03-28','sa'),(47,1,37,1,35,0,'A','2012-04-16','sa'),(48,1,37,1,35,0,'P','2012-04-16','sa'),(49,1,37,1,35,0,'P','2012-04-16','sa'),(50,21,37,34,35,0,'P','2012-04-17','sa'),(51,76,37,101,35,0,'P','2012-04-25','s'),(52,37,76,99,35,0,'P','2012-04-25','s'),(53,21,37,20,35,0,'P','2012-04-25','sa'),(54,2,37,3,35,0,'P','2012-04-25','sa'),(55,57,37,73,35,0,'P','2012-04-25','sa'),(56,21,37,65,35,0,'P','2012-04-25','sa'),(57,1,37,1,35,0,'P','2012-04-25','sa'),(58,2,37,3,35,0,'P','2012-04-25','sa'),(59,37,21,45,35,0,'P','2012-04-25','sa'),(60,37,21,72,35,0,'P','2012-04-25','sa'),(61,78,37,74,35,0,'P','2012-05-03','sa'),(62,78,92,74,35,0,'P','2012-05-04','sa'),(63,78,37,74,35,0,'P','2012-06-15','sa'),(64,37,78,69,35,0,'P','2012-07-11','sa'),(65,78,79,75,35,0,'P','2012-07-11','sa'),(66,78,79,76,35,0,'P','2012-07-11','sa'),(67,78,79,76,35,0,'P','2012-07-11','sa'),(68,78,79,74,35,0,'P','2012-07-11','sa'),(69,37,78,72,35,0,'P','2012-07-11','sa'),(70,78,37,102,35,0,'A','2012-07-11','s'),(71,37,78,86,35,0,'P','2012-07-11','s'),(72,78,81,104,35,0,'P','2012-08-07','s'),(73,81,78,103,35,0,'A','2012-08-07','s'),(74,81,78,106,35,0,'P','2012-08-07','s'),(75,78,81,105,35,0,'A','2012-08-07','s'),(76,78,81,107,35,0,'P','2012-08-07','s'),(77,81,78,108,35,0,'A','2012-08-07','s'),(78,87,88,116,35,0,'P','2012-12-03','s'),(79,88,87,117,35,0,'P','2012-12-03','s'),(80,1,89,83,35,0,'P','2013-01-04','sa'),(81,78,89,77,35,0,'P','2013-01-04','sa'),(82,1,89,83,35,0,'P','2013-01-04','sa'),(83,89,78,96,35,0,'P','2013-02-18','sa'),(84,78,89,86,35,0,'P','2013-02-19','sa'),(85,89,78,96,35,0,'A','2013-02-19','sa'),(86,78,89,86,35,0,'P','2013-02-19','sa'),(87,1,89,84,35,0,'P','2013-02-19','sa'),(88,1,89,84,35,0,'P','2013-02-19','sa'),(89,1,89,84,35,0,'P','2013-02-19','sa'),(90,89,1,119,35,0,'A','2013-02-19','s'),(91,1,89,19,35,0,'A','2013-02-19','s'),(92,78,89,86,35,0,'P','2013-02-19','sa'),(93,78,89,82,35,0,'P','2013-02-19','sa'),(94,78,89,81,35,0,'P','2013-02-19','sa'),(95,89,78,96,35,0,'A','2013-02-19','sa'),(96,89,78,95,35,0,'A','2013-02-19','sa'),(97,78,89,76,35,0,'P','2013-02-19','sa'),(98,1,89,83,35,0,'P','2013-02-21','sa'),(99,89,78,120,5,0,'A','2013-02-21','s'),(100,78,89,112,5,0,'P','2013-02-21','s'),(101,89,1,0,5,0,'P','2013-02-26','s'),(102,1,89,0,5,0,'P','2013-02-26','s'),(103,89,1,0,5,0,'P','2013-02-26','s'),(104,1,89,0,5,0,'P','2013-02-26','s'),(105,78,89,86,5,0,'P','2013-03-08','sa'),(106,1,89,84,5,0,'P','2013-03-08','sa'),(107,89,78,96,5,0,'P','2013-03-08','sa'),(108,89,1,2,5,0,'A','2013-03-08','s'),(109,1,89,1,5,0,'P','2013-03-08','s'),(110,89,1,3,5,0,'A','2013-03-08','s'),(111,1,89,4,5,0,'P','2013-03-08','s'),(112,89,1,5,5,0,'A','2013-03-08','s'),(113,1,89,6,5,0,'A','2013-03-08','s'),(114,78,89,86,5,0,'P','2013-03-08','sa'),(115,78,89,76,5,0,'P','2013-03-08','sa'),(116,89,91,91,5,0,'P','2013-03-25','sa'),(117,22,1,22,5,0,'P','2013-04-01','sa'),(118,21,87,52,5,0,'P','2013-07-27','sa'),(119,89,92,96,5,0,'P','2013-10-17','sa'),(120,107,104,25,5,0,'P','2013-11-19','s'),(121,104,107,24,5,0,'P','2013-11-19','s'),(122,107,104,26,5,0,'P','2013-11-21','s'),(123,104,107,22,5,0,'P','2013-11-21','s'),(124,1,110,1,5,0,'P','2013-12-09','sa'),(125,78,110,74,5,0,'P','2013-12-09','sa'),(126,78,110,74,5,0,'P','2013-12-10','sa'),(127,21,110,20,5,0,'P','2013-12-10','sa'),(128,1,110,7,5,0,'P','2013-12-13','sa'),(129,1,110,7,5,0,'P','2013-12-13','sa'),(130,1,110,1,5,0,'P','2013-12-13','sa'),(131,1,110,83,5,0,'P','2013-12-13','sa'),(132,1,110,83,5,0,'P','2013-12-13','sa'),(133,78,110,74,5,0,'P','2013-12-13','sa'),(134,1,110,83,5,0,'P','2013-12-13','sa'),(135,89,104,96,5,0,'P','2013-12-17','sa'),(136,78,110,74,5,0,'P','2013-12-28','sa'),(137,78,110,74,5,0,'P','2013-12-28','sa'),(138,21,110,20,5,0,'P','2013-12-28','sa'),(139,78,110,74,5,0,'P','2013-12-28','sa'),(140,78,110,74,5,0,'P','2013-12-28','sa'),(141,78,110,74,5,0,'P','2013-12-28','sa'),(142,21,110,20,5,0,'P','2013-12-28','sa'),(143,21,110,20,5,0,'P','2013-12-28','sa'),(144,1,110,1,5,0,'P','2013-12-31','sa'),(145,78,110,74,5,0,'P','2013-12-31','sa'),(146,89,112,96,5,0,'P','2014-06-23','sa'),(147,89,111,93,5,0,'P','2014-06-24','sa'),(148,89,112,95,5,0,'P','2014-06-24','sa'),(149,89,111,96,5,0,'P','2014-07-09','sa'),(150,111,112,100,5,0,'P','2014-07-14','sa'),(151,89,111,96,5,0,'P','2014-07-15','sa'),(152,89,113,96,5,0,'P','2014-08-05','sa'),(153,114,113,101,5,0,'P','2014-08-05','sa'),(154,114,113,101,5,0,'P','2014-08-06','sa'),(155,89,113,96,5,0,'P','2014-08-06','sa'),(156,89,116,96,5,0,'P','2014-10-10','sa'),(157,1,115,102,5,0,'P','2014-10-11','sa'),(158,89,115,96,5,0,'P','2014-10-14','sa'),(159,111,115,100,5,0,'P','2014-10-15','sa'),(160,89,115,96,5,0,'P','2014-10-15','sa'),(161,89,115,96,5,0,'P','2014-10-15','sa'),(162,89,115,96,5,0,'P','2014-10-15','sa'),(163,111,115,100,5,0,'P','2014-10-15','sa'),(164,89,115,96,5,0,'P','2014-10-16','sa'),(165,89,115,96,5,0,'P','2014-10-16','sa'),(166,1,115,102,5,0,'P','2014-10-16','sa'),(167,89,115,96,5,0,'P','2014-10-20','sa'),(168,37,111,87,5,0,'P','2014-10-30','sa'),(169,78,115,74,5,0,'P','2014-11-18','sa'),(170,119,115,39,5,0,'A','2014-12-08','s'),(171,115,119,36,5,0,'A','2014-12-08','s'),(172,12,111,105,5,0,'P','2015-04-01','sa'),(173,111,12,38,5,0,'A','2015-04-16','s'),(174,12,111,42,5,0,'A','2015-04-16','s'),(175,12,111,105,5,0,'P','2015-04-17','sa'),(176,111,1,109,5,0,'P','2015-04-17','sa'),(177,111,121,109,5,0,'P','2015-04-17','sa'),(178,111,121,109,5,0,'P','2015-04-20','sa'),(179,111,121,109,5,0,'P','2015-04-20','sa'),(180,12,121,105,5,0,'P','2015-04-20','sa'),(181,12,121,105,5,0,'P','2015-04-20','sa'),(182,12,121,105,5,0,'P','2015-04-20','sa'),(183,12,121,105,5,0,'P','2015-04-20','sa'),(184,89,121,96,5,0,'P','2015-04-20','sa'),(185,12,121,105,5,0,'P','2015-04-20','sa'),(186,111,121,114,5,0,'P','2015-04-21','sa'),(187,12,111,105,5,0,'P','2015-04-21','sa'),(188,12,111,105,5,0,'P','2015-04-22','sa'),(189,12,111,105,5,0,'P','2015-04-22','sa'),(190,12,111,105,5,0,'P','2015-04-22','sa'),(191,89,111,96,5,0,'P','2015-04-22','sa'),(192,91,111,98,5,0,'P','2015-04-22','sa'),(193,91,111,98,5,0,'P','2015-04-22','sa'),(194,91,111,98,5,0,'P','2015-04-22','sa'),(195,91,111,98,5,0,'P','2015-04-22','sa'),(196,111,120,109,5,0,'P','2015-04-22','sa'),(197,91,111,98,5,0,'P','2015-04-22','sa'),(198,91,111,98,5,0,'P','2015-04-22','sa'),(199,12,120,105,5,0,'P','2015-04-22','sa'),(200,111,120,43,5,0,'P','2015-04-22','s'),(201,120,111,41,5,0,'P','2015-04-22','s'),(202,12,120,105,5,0,'P','2015-04-22','sa'),(203,89,120,96,5,0,'P','2015-04-22','sa'),(204,89,120,96,5,0,'P','2015-04-22','sa'),(205,89,120,96,5,0,'P','2015-04-22','sa'),(206,89,120,96,5,0,'P','2015-04-22','sa'),(207,89,120,96,5,0,'P','2015-04-22','sa'),(208,89,120,96,5,0,'P','2015-04-22','sa'),(209,111,120,114,5,0,'P','2015-04-22','sa'),(210,111,120,100,5,0,'P','2015-04-22','sa'),(211,111,120,100,5,0,'P','2015-04-22','sa'),(212,111,120,100,5,0,'P','2015-04-22','sa'),(213,12,120,105,5,0,'P','2015-04-23','sa'),(214,89,111,96,5,0,'P','2015-04-23','sa'),(215,89,111,96,5,0,'P','2015-04-23','sa'),(216,89,111,96,5,0,'P','2015-04-23','sa'),(217,89,111,96,5,0,'P','2015-04-23','sa'),(218,89,111,96,5,0,'P','2015-04-23','sa'),(219,89,111,96,5,0,'P','2015-04-23','sa'),(220,12,120,105,5,0,'P','2015-04-23','sa'),(221,89,111,96,5,0,'P','2015-04-23','sa'),(222,89,111,96,5,0,'P','2015-04-23','sa'),(223,12,111,105,5,0,'P','2015-04-23','sa'),(224,12,111,105,5,0,'P','2015-04-23','sa'),(225,12,120,105,5,0,'P','2015-04-23','sa'),(226,12,120,105,5,0,'P','2015-04-23','sa'),(227,111,120,114,5,0,'P','2015-04-23','sa'),(228,12,120,105,5,0,'P','2015-04-23','sa'),(229,12,120,105,5,0,'P','2015-04-23','sa'),(230,111,120,114,5,0,'P','2015-04-23','sa'),(231,21,120,20,5,0,'P','2015-04-23','sa'),(232,21,120,20,5,0,'P','2015-04-23','sa'),(233,12,111,105,5,0,'P','2015-04-23','sa'),(234,89,111,96,5,0,'P','2015-04-24','sa'),(235,89,111,96,5,0,'P','2015-04-24','sa'),(236,12,111,105,5,0,'P','2015-04-24','sa'),(237,12,120,105,5,0,'P','2015-04-24','sa'),(238,12,111,105,5,0,'P','2015-04-24','sa'),(239,89,111,96,5,0,'P','2015-04-24','sa'),(240,89,111,96,5,0,'P','2015-04-27','sa'),(241,111,120,118,5,0,'P','2015-04-30','sa'),(242,111,120,118,5,0,'P','2015-04-30','sa'),(243,111,120,49,5,0,'P','2015-05-13','s'),(244,120,111,45,5,0,'P','2015-05-13','s'),(245,111,120,46,5,0,'P','2015-05-13','s'),(246,120,111,50,5,0,'P','2015-05-13','s'),(247,234,103,146,10,0,'P','2017-06-02','s'),(256,115,116,40,10,0,'A','2017-06-02','w');

--
-- Table structure for table `es_successtransactionpayments`
--

CREATE TABLE `es_successtransactionpayments` (
  `nId` int(11) NOT NULL AUTO_INCREMENT,
  `nSId` bigint(20) DEFAULT '0',
  `nUserId` int(11) NOT NULL DEFAULT '0',
  `nAmount` double NOT NULL DEFAULT '0',
  `nProdId` double NOT NULL DEFAULT '0',
  `vTxnId` varchar(200) NOT NULL DEFAULT '',
  `vMethod` char(2) NOT NULL DEFAULT '00',
  `dDate` date NOT NULL DEFAULT '0000-00-00',
  `vStatus` char(1) NOT NULL DEFAULT 'P',
  `vName` varchar(200) NOT NULL DEFAULT '',
  `vBank` varchar(200) NOT NULL DEFAULT '',
  `vReferenceNo` varchar(200) NOT NULL DEFAULT '',
  `dReferenceDate` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`nId`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `es_successtransactionpayments`
--

INSERT INTO `es_successtransactionpayments` VALUES (1,1,21,10,42,'','cc','2011-07-26','P','','','','0000-00-00'),(2,2,22,10,45,'','cc','2011-07-26','A','','','','0000-00-00'),(3,3,21,10,34,'','cc','2011-07-28','A','','','','0000-00-00'),(4,4,22,10,44,'','cc','2011-07-28','A','','','','0000-00-00'),(5,1,21,10,42,'','cc','2011-06-26','A','','','','0000-00-00'),(6,1,21,10,42,'','cc','2011-06-26','A','','','','0000-00-00'),(7,1,21,10,42,'','cc','2011-06-26','A','','','','0000-00-00'),(8,6,21,10,40,'','','2011-08-09','A','1133','46656','5665665656','2011-08-09'),(9,70,78,35,102,'','cc','2012-08-07','A','','','','0000-00-00'),(10,75,78,35,105,'','cc','2012-08-07','A','','','','0000-00-00'),(11,73,81,35,103,'','cc','2012-08-07','A','','','','0000-00-00'),(12,77,81,35,108,'','cc','2012-08-07','A','','','','0000-00-00'),(13,90,89,35,119,'5NP41106MN254220E','pp','2013-02-19','A','','','','0000-00-00'),(14,91,1,35,19,'0AF91721XP1180715','pp','2013-02-19','A','','','','0000-00-00'),(15,85,89,35,96,'0KW17924295160236','pp','2013-02-19','A','','','','0000-00-00'),(16,95,89,35,96,'4F704027A9668722U','pp','2013-02-21','A','','','','0000-00-00'),(17,99,89,5,120,'0YD14571UB646271F','pp','2013-02-21','A','','','','0000-00-00'),(18,96,89,5,95,'','','2013-02-21','A','aA','ASAs','asaA','2013-02-28'),(19,47,1,5,1,'','cc','2013-03-08','A','','','','0000-00-00'),(20,108,89,5,2,'','cc','2013-03-08','A','','','','0000-00-00'),(21,110,89,5,3,'','cc','2013-03-08','A','','','','0000-00-00'),(22,112,89,5,5,'','cc','2013-03-08','A','','','','0000-00-00'),(23,113,1,5,6,'','cc','2013-03-21','A','','','','0000-00-00'),(24,170,119,5,39,'','cc','2014-12-08','A','','','','0000-00-00'),(25,171,115,5,36,'','cc','2014-12-08','A','','','','0000-00-00'),(26,174,12,5,42,'5CS76525D31435335','pp','2015-04-16','A','','','','0000-00-00'),(27,173,111,5,38,'1BA47839GF024735G','pp','2015-04-16','A','','','','0000-00-00'),(28,171,115,10,36,'9AD80983TJ365162J','pp','2017-06-02','A','','','','0000-00-00'),(29,0,116,10,0,'1RN64290EH733793R','pp','2017-06-02','A','','','','0000-00-00'),(30,256,115,10,40,'1WF63627WF175031B','pp','2017-06-02','A','','','','0000-00-00');

--
