-- phpMyAdmin SQL Dump
-- version 4.0.4.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Feb 03, 2019 at 06:25 AM
-- Server version: 5.5.32
-- PHP Version: 5.6.38

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `osclicks_blog`
--
CREATE DATABASE IF NOT EXISTS `osclicks_blog` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `osclicks_blog`;

-- --------------------------------------------------------

--
-- Table structure for table `news`
--

CREATE TABLE IF NOT EXISTS `news` (
  `news_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category` enum('News','Events','Press Releases') COLLATE latin1_general_ci NOT NULL DEFAULT 'News',
  `conv_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(150) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `seo_name` text COLLATE latin1_general_ci NOT NULL,
  `summary` text COLLATE latin1_general_ci NOT NULL,
  `source` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `materials` int(11) NOT NULL DEFAULT '0',
  `image_link` text COLLATE latin1_general_ci NOT NULL,
  `details` text COLLATE latin1_general_ci NOT NULL,
  `source_logo` int(11) NOT NULL DEFAULT '0',
  `author` varchar(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `views` int(10) NOT NULL DEFAULT '0',
  `related_stories` text COLLATE latin1_general_ci NOT NULL,
  `event_date` date NOT NULL DEFAULT '0000-00-00',
  `event_time` varchar(20) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `event_end_date` date NOT NULL DEFAULT '0000-00-00',
  `create_dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_dt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish_dt` date NOT NULL DEFAULT '2007-01-01',
  `status` enum('published','unpublished') COLLATE latin1_general_ci NOT NULL DEFAULT 'unpublished',
  `item_type` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`news_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=37 ;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`news_id`, `category`, `conv_id`, `title`, `seo_name`, `summary`, `source`, `materials`, `image_link`, `details`, `source_logo`, `author`, `views`, `related_stories`, `event_date`, `event_time`, `event_end_date`, `create_dt`, `update_dt`, `publish_dt`, `status`, `item_type`) VALUES
(32, 'News', 1, 'test news in basbd.org', 'back_to_school_spirit_sale', 'test news in basbd.org', '', 5, 'babyalex_admin/uploaded_images/20080501_28_031907_redcarpet_mon_425x600_02.jpg', '<p>test news in basbd</p>\r\n<p><strong>test news in basbd<br />\r\n</strong></p>\r\n<p><strong>test news in basbd</strong></p>\r\n<p>test news in basbd</p>\r\n<p>&nbsp;</p>', 0, '', 0, '', '2008-08-11', '1.30 PM', '2008-09-13', '2008-07-19 05:00:00', '2009-02-15 00:00:00', '2008-12-08', 'published', 0),
(33, 'Events', 1, 'hahahah', 'hahaha', 'hahaha lol lol', '', 0, '', '<p>abandon and all the ways to know me.. <strong>LOL</strong></p>\r\n<p>&nbsp;</p>\r\n<p><strong>hahaha</strong></p>\r\n<p>&nbsp;</p>\r\n<p><strong>--</strong></p>\r\n<p>Rupom</p>', 0, '', 0, '', '2008-10-30', '1.00 PM', '2008-10-31', '2008-10-10 05:00:00', '2008-10-29 00:00:00', '2008-10-10', 'published', 0),
(35, 'News', 0, 'Testing in safari', 'testing_in_safari', 'Testing in safari', '', 0, '', '<p>&nbsp;Hello there,</p>\r\n<p><span class=\\"Apple-style-span\\" style=\\"font-weight: bold;\\">How are you all?</span></p>', 0, '', 0, '', '0000-00-00', '', '0000-00-00', '2008-12-05 04:19:31', '2008-12-04 00:00:00', '2008-12-04', 'published', 0),
(36, 'News', 0, 'ddddddddddd', 'ddddddddddd', 'ddd', '', 0, '', '<p>dddd</p>\r\n<p>ddd</p>\r\n<p>ddd</p>\r\n<p>dddddddddddd</p>', 0, '', 0, '', '0000-00-00', '', '0000-00-00', '2009-02-05 21:53:18', '2009-02-05 00:00:00', '2009-02-10', 'published', 0);

-- --------------------------------------------------------

--
-- Table structure for table `portfolios`
--

CREATE TABLE IF NOT EXISTS `portfolios` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `url` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `services` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `summary` text COLLATE latin1_general_ci NOT NULL,
  `img_name` varchar(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `sort_order` int(3) NOT NULL DEFAULT '0',
  `anchor` varchar(20) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `time_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=19 ;

--
-- Dumping data for table `portfolios`
--

INSERT INTO `portfolios` (`id`, `name`, `url`, `services`, `summary`, `img_name`, `sort_order`, `anchor`, `time_added`) VALUES
(1, 'Deshi Tender', 'http://www.deshitender.com', 'The design, development, hosting, search engine optimization, testing &amp; quality assurance.', '<p>\r\n	<em>\r\nDeshi Tender is a Bangladesh based web service for tender and procurement information. Deshi Tender is up-to-date with latest tender and procurement information published in national dailies, known websites and sometimes directly from companies. They collect, store and notify our customers the tender information in the best way. Their everyday goal is to reach you with the latest tender information while you are relaxing with your stuffs.\r\n</em>\r\n</p>\r\n\r\n<p>\r\n	<em>\r\nDeshi Tender classifies its information by category, organization and region (division, city, etc.) so that customers can find their desired information very easily. With their tender classification, customers know which tenders are most recents, which tenders are most viewed/popular, which tenders are with deadline today or which tenders have deadline tomorrow.	\r\n	</em>\r\n</p>\r\n', 'sshot_deshitender.jpg', 1, 'deshitender', '2010-01-02 07:43:00'),
(2, 'Rabatt.Se', 'http://www.rabatt.se', 'The development, testing &amp; quality assurance.', '<p><em>Rabatt.se - a Sweden based web service - collects discount codes, promotional codes, deals and special sales from nearly 400 different companies. OS Clicks developed the entire coupon module, multiple level member module, language module and SEO structure for the entire site. Rabatt.se natural search traffic has grown 400% since implementation of a clean URL structure and on page SEO. The site is designed for scalability, usability and continues to grow as a constant rate.\r\n</em></p>', 'sshot_rabatt.jpg', 2, 'rabattse', '2010-01-02 07:48:09'),
(3, 'We Sell Arts', 'http://www.wesellarts.com', 'The design, development, search engine optimization, testing &amp; quality assurance.', '<p><em>We Sell Arts is an artwork web service for artists and art buyers. Artists can sell their artwork online using either a free or pay membership with a low commission rate on sales compared to other online South African and International galleries.\r\n</em></p>\r\n\r\n<p><em>Art Buyers can purchase quality artwork and save artworks to their wish list. They can send links to friends, post comments and rate the artist''s artwork. Art buyers can give feed back on purchases made which is displayed on the artist''s profile.</em></p>\r\n\r\n<p><em>We Sell Arts aims to be a simple and an efficient selling and buying tool for art sellers and art buyers.</em></p>', 'wesellarts_sshot.jpg', 3, 'wsa', '2010-01-02 08:01:40'),
(4, 'Capital Tickets', 'http://www.capital-tickets.co.uk', 'The design, development, testing &amp; quality assurance.', '<p><em>This is an online ticket selling service for all your Sports and Concerts Tickets, Theatre and Hospitality Tickets including Football, Rugby and Horse Racing Tickets for sale.</em></p>', 'capital_tickets_ssh.jpg', 4, 'capital', '2010-01-02 08:01:40'),
(5, 'Room Busters', 'http://www.osclicks.net/roombusterz/', 'The design, development, search engine optimization, testing &amp; quality assurance.', '<p><em>It is a room mate finding service in the United Kingdom. People join this website, tell about their spare rooms and find their room mates. Also, registered people get email updates on the room services.</em></p>', 'roombusters_sshot.jpg', 9, 'roombusters', '2010-01-02 08:19:16'),
(6, 'MY RUET', 'http://www.myruet.com', 'The design, development, hosting, search engine optimization, testing &amp; quality assurance.', '<p><em>MY RUET is the community website for the ex and current students of Rajshahi University of Engineering and Technology (RUET) - one of the leading engineering universities in Bangladesh.</em></p>', 'myruet_sshot.jpg', 6, 'myruet', '2010-01-02 08:19:16'),
(7, 'Gravure System', 'http://www.gravure-system.com', 'The development, e-commerce, search engine optimization, testing &amp; quality assurance.', '<p><em>It is a French based online store for selling gifts, greeting cards, etc.</em></p>', 'gravure_sshot.jpg', 7, 'gravure', '2010-01-02 08:34:42'),
(8, 'Cosmo Engineering', 'http://www.cosmoengg.com', 'The design, development, hosting, search engine optimization, testing &amp; quality assurance.', '<p><em>Cosmo Engineering is specialized in different kind of Power Engineering Solution and Equipment Supplier. They are devoted to consolidating and expanding the industrial market, real estate market and providing more professional services for customers. They are fully prepared for the intensive competition with our motto of "Cooperation, Communication and Development". They will strive to become the first-class trademark in the filed of Power engineering services.</em></p>', 'cosmo_engg_sshot.jpg', 8, 'cosmo', '2010-01-02 08:34:42'),
(9, 'RUPOM.NET - Shrinks Your URL', 'http://rupom.net', 'The design, development, hosting, search engine optimization, testing &amp; quality assurance.', '<p><em>RUPOM.NET is a free URL shrinker service for you, creates short URL for your internet usage. We create the shortest possible URL for you from the existing long one and makes your life easier on the internet. You may use that in your email, social networking page (like twitter), website, blog or any place you want/need on. Your short link never expires.</em></p>', 'rupom_net_sshot.jpg', 4, 'rupomnet', '2010-01-02 09:03:23'),
(10, 'Naturalfooted - surfer''s first aid kits', 'http://www.osclicks.com/demos/naturalfooted/', 'The design, development, e-commerce, iDev Affiliate setup with PayPal synchronization,  search engine optimization, testing &amp; quality assurance.', 'Naturalfooted is the global leader in first aid products for surfers dedicated to equipping traveling surfers all over the world with the most specialised and quality first aid products available.', 'naturalfooted_sshot.jpg', 7, 'naturalfooted', '2010-01-10 22:43:39'),
(11, 'Facebook Application to Aggregate Twitter Accounts', 'http://www.facebook.com/pages/My-Development/411799535639?v=app_24246086360', 'The design and development', '<p><em>This project is used to aggregate multiple twitter accounts'' tweets into a facebook fan page. The tweeter accounts are placed into some predefined categories to display tweets in separate tabs of the application. Each tweet has the user information attached along with some social links of the respective user. \r\n</em></p>\r\n\r\n<p><em>\r\nIt has a strong backend that facilitates the management of tweeter accounts, categories and their associations.</em></p>', 'tw_aggregator_sshot.jpg', 8, 'tw_aggregator', '2010-01-22 11:06:23'),
(12, 'Freelance Jobs Online - Latest Job List and Information', 'http://joblance.info', 'The design, development, search engline optimization (SEO), testing and quality assurance', '<p><em>JobLance.inFo is a free web service for people looking for freelance jobs & projects online. JobLance.inFo aggregates latest online job information from all popular and possible sources. Job seekers can find latest online jobs of every categories here. JobLance.inFO updates itself in every hour with latest jobs and projects posted in the popular job sources.</em></p>\r\n\r\n<p><em>OS CLiCKS designed the site and developed all the features and now working to optimize the site in the web search engines. Also working to release some new features to make the site unique in its kind. The site started getting 500+ hits everyday from the first day of its release.</em></p>', 'joblance_sshot.jpg', 0, 'joblance', '2010-03-24 17:28:48'),
(13, 'STONECARE.COM - Stone Care International', 'http://www.stonecare.com', 'The development, search engline optimization (SEO), testing and quality assurance', '<p><em>Stone Care International (SCI) is a shopping cart for selling products related to stones & their cleaning/caring, etc. OS CLiCKS developed the whole shopping cart, dynamic product listing in categories, user account & address management, shipping calculation, order checkout & processing as well as a product & order management administration panel.</em></p>', 'stonecare.png', 10, 'stonecare', '2012-11-11 13:45:26'),
(14, 'BABYALEXANDRA.COM - Baby Alexandra, Baby Boutique and Showroom', 'http://www.babyalexandra.com', 'The development, search engline optimization (SEO), testing and quality assurance', '<p><em>Baby Alexandra is a boutique in Palm Beach Gardens, FL which provides a unique selection of high-quality and exclusive furniture, custom bedding, decor, gear, clothing, gifts, toys and books for infants and children. BabyAlexanda.com is a full-featured baby product selling framework for their business. OS CLiCKS developed the whole shopping cart, dynamic product listing in categories, user account & address management, shipping calculation, order checkout & processing as well as a very strong administration panel for their product & order management.</em></p>', 'babyalex.png', 0, 'babyalex', '2012-11-11 13:45:26'),
(15, 'Dubai Media Incorporated (DMI)', 'http://www.dmi.ae ', 'The development, testing and quality assurance', 'The Dubai Media Incorporated (DMI) portal collects and publishes various data in its multiple media channels (press, radio and TV). Here we scraped media contents from other sources, saved in their database and displayed on the frontend pages. It also has an authentication panel to manage all media sources & contents.', 'dmi_screenshot.jpg', 0, 'dmi', '2013-01-23 10:47:50'),
(16, 'Kama Sutra Jobs', 'http://kamasutrajobs.com', 'The development (frontend, backend, crawling & aggregation), testing and quality assurance', 'Jobs aggregator using jobs from popular sources like Microsoft, Google, Yahoo, Apple, eBay, etc. Kama Sutra Jobs finds the latest vacancies at the top companies in Sydney and lists them all in one convenient location.', 'kamasutrajobs_sshot.jpg', 0, 'kamasutrajobs', '2013-01-23 10:47:50'),
(17, 'Cars Search Engine on Facebook', 'http://apps.facebook.com/searchcars', 'The development, testing and quality assurance', 'This project is a cars search engine application developed for Facebook whose backend has a strong scraping engine that scrapes & aggregates cars information from a several car websites. You can search & filter results, view details and inquire for more details without leaving Facebook. Besides, it has a custom authentication panel to manage all scraped data.', 'searchcars_sshot.jpg', 0, 'searchcars', '2013-01-23 10:53:32'),
(18, 'Coupon World Wide (CWW)', 'http://www.couponworldwide.com', 'The design, development, hosting, search engine optimization, testing &amp; quality assurance.', '<p>Coupon World Wide (CWW) is an aggregator project that finds you the best and validated coupon & voucher codes from all over the internet world.\r\n</p>\r\n\r\n<p>\r\nHaving a growing number of merchant stores integrated, CWW target to be the best in displaying verified coupon & voucher codes. Before the launching the website, their founders experienced many real life problems about coupons & voucher codes. So this website is definitely bearing a lot more than just the coupon codes.</p>', 'cww.png', 0, 'cww', '2014-09-11 09:14:34');

-- --------------------------------------------------------

--
-- Table structure for table `site_news`
--

CREATE TABLE IF NOT EXISTS `site_news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `summary` text COLLATE latin1_general_ci NOT NULL,
  `details` text COLLATE latin1_general_ci NOT NULL,
  `publish_date` date NOT NULL DEFAULT '0000-00-00',
  `status` enum('active','inactive') COLLATE latin1_general_ci NOT NULL DEFAULT 'active',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=6 ;

--
-- Dumping data for table `site_news`
--

INSERT INTO `site_news` (`id`, `title`, `summary`, `details`, `publish_date`, `status`) VALUES
(1, 'OS CLiCKS started its journey as a web development & services company', 'We are launching the website of OS CLiCKS today. It was a dream of many days since we started thinking of the company. But time killed us always. Finally we are all glad that it happended today. So it''s a memorable day for us when we start doing works as an organization.', '      We are launching the website of <b>OS CLiCKS</b> today. It was a dream of many days since we started thinking of the company. But time killed us always. \r\n      Finally we are all glad that it happended today. So it''s a memorable day for us when we start doing works as an organization.\r\n      \r\n      <span>\r\n      	<p>&nbsp;</p>\r\n      When we talk about an organization, there are lots of management rules comes up. Breaking any of those by anyone of the organization might break the flow of success that drives our company. We believe we all are professionals in work especially when we throw a commitment. \r\n    This is a positive side of our organization.</span> \r\n      \r\n      	\r\n      		<span>\r\n      		<p>&nbsp;</p>\r\n      		We clearly know that we are going to offer bigger commitments for our customers - their satisfactions, business stuffs, etc.  So when our goal is to satisfy our customers providing the best innovative services, we must plan properly, work harder to accomplish that all. We know that our quality will be preserved by our services. And we are all set and ready to do that for you. Stay with us.</span>\r\n      	  \r\n      	  <img src="images/bubble.png" onmouseover="this.src=''images/bubble_rollover.png'';" onmouseout="this.src=''images/bubble.png'';" alt="" />\r\n      	        	      \r\n      \r\n      <br />                 \r\n      <p>&nbsp;</p>\r\n', '2008-08-24', 'active'),
(2, 'OS CLiCKS is going to launch Deshi Tender - a tender and procurement service in Bangladesh', 'OS CLiCKS is going to launch its first online product <a href="http://www.deshitender.com/" target="_blank">Deshi Tender</a>. Deshi Tender is targeted to be the best source of tender and procurement information in Bangladesh. We are at the end of its development and hoping to release it next month.\r\n', 'OS CLiCKS is going to launch its first online product <a href="http://www.deshitender.com/" target="_blank">Deshi Tender</a>. Deshi Tender is targeted to be the best source of tender and procurement information in Bangladesh. We are at the end of its development and hoping to release it next month.\r\n<br /><br />\r\nDeshi Tender will be different than other tender service providers in Bangladesh. We classify tender information by category, organization and city/region/division. It''s easy to find and filter your expected tender information. We tried to use the latest web technology so visitors experience never go negative. It is going to be sophisticated website with easy navigation, easy to understand & use features, etc.\r\n<br /><br />\r\nPlease keep your eyes on this URL: <a href="http://www.deshitender.com/" target="_blank">http://www.deshitender.com/</a>', '2009-04-19', 'active'),
(3, 'Grand launch of Deshi Tender - the best source of tender and procurement information in Bangladesh', 'It''s a pleasure to announce that today we have released the first online product, Deshi Tender, of our company. Please find it here:\r\n<p>&nbsp;</p>\r\n<a href="http://www.deshitender.com/" target="_blank">http://www.deshitender.com/</a>\r\n<p>&nbsp;</p>\r\n\r\nDeshi Tender is the best source of all tender and procurement information in Bangladesh. We collect tender information from various sources - newspapers, websites and sometimes directly from companies.\r\n', 'It''s a pleasure to announce that today we have released the first online product, Deshi Tender, of our company. Please find it here:\r\n<p>&nbsp;</p>\r\n<a href="http://www.deshitender.com/" target="_blank">http://www.deshitender.com/</a>\r\n<p>&nbsp;</p>\r\n\r\nDeshi Tender is the best source of all tender and procurement information in Bangladesh. We collect tender information from various sources - newspapers, websites and sometimes directly from companies.\r\n<p>&nbsp;</p>\r\nThe purpose of this website is to ease the life of the (1) contractors who collect tender notices from many sources everyday, (2) company executives who publish their tender and/or procurement information to many newspapers, and (3) individuals who keep track of their desired tender information from various places. Deshi Tender works for all of them above.\r\n\r\n<p>&nbsp;</p>\r\n\r\nWe collect all tender and procurement information from national dailies, websites, and all possible tender sources and then publish those to our website. And then we notify our customers (by email) about the latest tender information - once/twice a day.\r\n\r\n<p>&nbsp;</p>\r\n\r\nIf you are contractor or a company, please join <b>Deshi Tender</b> today and enjoy maximum facilities in the occasion of inauguration.\r\n\r\n<br /><br />\r\n\r\nPlease visit the site. Your comments and feedback are most welcome.', '2009-06-11', 'active'),
(4, 'We are hiring!', 'OS CLiCKS is looking for some young, energetic and hard-working web programmers to work with its core development team. Candidates with following strengths are encouraged to apply on/before 30th of this month:', 'OS CLiCKS is looking for some young, energetic and hard-working web programmers to work with its core development team. Candidates with following strengths are encouraged to apply on/before 30th of this month:<br />\r\n\r\n<br /><br />\r\n1. S/he must have a bachelor degree in  Computer Science or Engineering\r\n\r\n<br /><br />\r\n2. His/her age must be within 30 years\r\n\r\n<br /><br />\r\n4. S/he must understand the current web development technology\r\n\r\n<br /><br />\r\n5. S/he must be capable to work under pressure\r\n\r\n<br /><br />\r\n6. S/he must be capable to work under a team\r\n\r\n<br /><br />7. S/he must have working experience (minimum 6 months in the field of web programming) in PHP/MySQL, HTML, JS and CSS. Ajax and MVC experiences will be his/her plus.\r\n\r\n<br /><br />\r\n8. S/he must have a clear concept on Object Oriented Programming. C/C++ strength will be considered as a plus.\r\n<br /><br />\r\n\r\n<br />If you think you are the right person, please send your CV to <a href="mailto: rupom@osclicks.com">rupom@osclicks.com</a>\r\n', '2009-06-24', 'active'),
(5, 'OS CLiCKS is going to introduce an E-Commerce solution for Bangladeshi Stores', 'A recent news reads: "Bangladesh has introduced Internet money transfers, allowing online payment of utility bills and other financial transactions with local currency credit cards.\r\n<br /><br />\r\nThe central bank on November 02, 2009 also asked scheduled banks to facilitate clients with broader online banking facilities."\r\n<br /><br />\r\nThis is really an exciting new for us living in Bangladesh. It is a long desired news indeed.', 'A recent news reads: "Bangladesh has introduced Internet money transfers, allowing online payment of utility bills and other financial transactions with local currency credit cards.\r\n<br /><br />\r\nThe central bank on November 02, 2009 also asked scheduled banks to facilitate clients with broader online banking facilities."\r\n<br /><br />\r\nThis is really an exciting new for us living in Bangladesh. It is a long desired news indeed. Business here will get a new dimension from now on. Lots shops will host their online store - people those don''t have enough time to go to an onsite location to purchase stuffs will get things easily while working/relaxing at home and much more facilities.\r\n\r\n<h2>Are we prepared?</h2>\r\nNow big question is are we prepared to provide good solutions to our country? At OS CLiCKS, we have experiences of developing some 70+ e-commerce stores. We have developed stores from scratch, modified/customized existing stores and fixed thousands problems around the globe. We have worked on osCommerce, X-Cart, Zen Cart, etc. And now when we need an efficient solution for our country, can we avoid our responsibility? Ofcourse NO.\r\n<br /><br />\r\nWe are preparing an E-Commerce suite for Bangladesh based stores. Our solution will be easy to use, easy to expand and cheaper enough to purchase from us. One of the most important feature we are going to concentrate on is - SECURITY. We are planning to keep a central code security system that takes care of all of our stores.\r\n<br /><br />\r\nWe will share more on this in future. Just waiting to see the online transfer system in action here.\r\n<br /><br />\r\nThanks.', '2009-11-05', 'active');

-- --------------------------------------------------------

--
-- Table structure for table `testimonials`
--

CREATE TABLE IF NOT EXISTS `testimonials` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `desig` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `company` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `website` varchar(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `location` varchar(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `feedback` text COLLATE latin1_general_ci NOT NULL,
  `time_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=31 ;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` (`id`, `name`, `desig`, `company`, `website`, `location`, `feedback`, `time_added`) VALUES
(1, 'Christopher Kung', 'CEO', 'Beendo Corporation', 'http://www.beendo.com', 'CA, United States', 'Rupom and his team helped solve complex problems with simple elegant technical solutions throughout our engagement. I look forward to work on a project with Rupom again.', '2009-12-27 20:15:27'),
(2, 'Shawn Owen', 'CEO', 'TWC Hosting', 'http://www.twchosting.co.za', 'South Africa', 'Rupom Razzaque has been an absolute pleasure to work with. The project was handled professionally, support has been fantastic, deadlines were successfully met, and most importantly the project was on budget. We will definately be using the services of Rupom in the near future and would strongly recommend him to anyone! Regards, Shawn Owen TWC Hosting', '2009-12-27 00:08:39'),
(3, 'Joshua Loader', 'Webmaster', 'DL Software', 'http://forums.dlsoftware.net', 'United Kingdom', 'Rupom is one of the very best web programmers I have met and also now a good friend due to his great personality. He has done so many projects for me with speed and quality all rolled into one. From server download''s and upload scripts and modifications. Rupom is a freelancer who can meet demands and produces high quality work. I can not put into words really how skilled and reliable he is. Every step of the way he provides excellent support and I recommend him to anyone. All The Best Rupom, Your Friend, Josh Loader -Webmaster (http://forums.dlsoftware.net)', '2009-12-21 01:09:18'),
(4, 'Rahman Rob', 'Managing Director', 'Annex World', 'http://www.annexworld.com', 'Bangladesh', 'It was an opportunity to have him in my company as a part-time developer few years back. Rupom''s development capability used to impress me everyday. I wish every success in his new business.', '2009-12-21 01:09:18'),
(5, 'Chris Neils', 'Owner', 'Kareems Kicks', 'http://www.kareemskicks.com', 'Canada', 'Did a great job communicating which is VERY hard to find with a programmer. He completed my project after 4 others failed. Great programmer, will use again.', '2009-12-21 01:09:18'),
(6, 'Timber (Nickname)', '', '', '', 'United Kingdom', 'SUPERB PROGRAMMER - he certainly knows his stuff!!! He was patient, explained where I went wrong and then sorted out the problem. I have already used him for more work and would definitely use him again!!Thank you for everything - see you soon.A***', '2009-12-22 18:49:51'),
(7, 'Gary Zaydman', '', '', '', 'United States', 'Excellent in every way. Very knowledgeable, did the wordpress jobs quickly and even offered some suggestions on how to improve our current installs. A+ for Happycoder.', '2009-12-21 19:04:09'),
(8, 'OY Weng Fai', '', '', '', 'Singapore', 'It is my privilege to work with happycoder. He has been really nice to give additonal useful features on his own. I am really impressed by his work, given the short amount of time to work with. I wil definiety find him again if i have any work in future. Thanks Happycoder!', '2009-12-21 01:12:18'),
(9, 'Bulatov', '', 'Tomaz Kranjc', '', 'Slovenia', 'Great programmer with amazing amount of dedication, skills and hard work! The project was done in few hours and he wouldn''t stop working until everything worked as it should. Highly recommended!', '2009-12-21 01:15:14'),
(10, 'Valerie Cox', '', 'Plena Libre', 'http://www.plenalibre.com', 'United States', 'Happycoder was very cooperative, did everything that we requested, was easy to work with and did little "extras" for me in order to finish the job on time. Recommended!', '2009-12-21 19:04:09'),
(11, 'Joshua Anderson', '', '', '', 'United States', 'Rupom is an excellent programmer his work is unique and fresh, he provided me with the very best work i have seen throughout my time using scriptlance. One of the main reasons i enjoyed working with rupom is due to his quick understanding and delivering of complex tasks. Rupom thank you again for all your hard work on my website and on my current projects i am very greatful and can''t wait for the next project to start! Thanks again your friend Josh.', '2009-12-21 19:04:09'),
(12, 'Matt Herbst', '', 'HJ', '', 'United States', 'He did a great job for me. He worked with me directly on instant messenger until everything was working perfectly. This is the second time he has done a job for me and I will use him again in the future.', '2009-12-21 19:04:09'),
(13, 'Jen Wiss', '', 'MY CLIQUE', 'http://www.myclique.co.uk/', 'United Kingdom', 'Completed project very fast, exactly what we wanted - took the time to make sure he knew exactly what was required and then carried out the project in about a day. Excellent programmer - will be using again.', '2009-12-21 17:41:26'),
(14, 'Eric', '', 'DesignersPlayground', '', 'United States', 'Very fast, very effective code, and quick responses to questions.', '2009-12-21 19:04:09'),
(15, 'Dug', '', '', '', 'United States', 'Great Programmer! Seriously fast, very easy to work with, very good comunication skills, got what I wanted exactly right in an amazingly short time, understood every problem 100%! Highly recommend for your project! ....Thanks!', '2009-12-21 19:04:09'),
(16, 'Peder Sviggum', '', 'Peder', '', 'Honduras', 'Project was very well done, and there was no sense of a rush to complete the payment. The programmer was always polite and asked if there was anything I would like to change or alter in the solution he provided for me. The solution itself was of the highest quality and completed 100%.\r\n', '2009-12-21 18:35:49'),
(17, 'Scott Lambert', 'Managing Director', 'Naturalfooted', '', 'Australia', 'Happycoder was a pleasure to work with. After accepting to undertake the project he went about it promptly and professionally, keeping in contact and providing updates. He also went that step further to implement our new code into the database and webpages. I recommend happycoder to any person that is wanting their project to be undertaken professionally and to the highest quality.', '2009-12-21 18:35:49'),
(18, 'Melissa', '', 'Andrew', '', 'United States', 'GREAT PROGRAMMER, VERY HELPFULL AND KNOWLEDGEABLE, EXCELLENT TO WORK WITH. VERY UNDERSTANDING AND PATIENT, WILL USE FROM NOW ON FOR ALL MY PROJECTS, WAS VERY HONEST AND TRUSTWORTHY AND STAYED UP THROUGHOUT THE NIGHT HELPING ME. SCRIPTLANCE NEEDS A HIGHER RATING SYSTEM BECAUSE THIS GUY DESERVES 100 A++++++++++++ VERY PROFESSIONAL PROGRAMMER CHOOSE HIM IF YOU WANT A REAL HONEST PROFESSIONAL WHO WILL GET THE JOB DONE NO MATTER WHAT. THANKS FOR ALL YOUR HARD WORK I REALLY APPRECIATE IT.', '2009-12-21 19:04:09'),
(19, 'Andreas Piller', '', '', 'http://www.apiller.de', 'Germany', 'Happycoder did a very good job. Especially the communication was great, questions were answerd very fast. He is a very creative and experienced programmer that came up with solutions for all tasks that were given. I will continue to work with him and can recommend him to anyone who is looking for good programmer.\r\n', '2009-12-21 18:43:08'),
(20, 'Depotbod22 (Nickname)', '', '', 'http://www.mqinternettservices.com', 'United Kingdom', 'This coder has done an absolutely fantastic and incredible job for my company! I only needed IPN managed for my main website but he created authentication areas and all sorts for me and he went over each job step by step with me so he knew exactly what i wanted. I am now going to use him for a large job i have coming up in a week which will be woth $3000.000 to him! I reccommend him to anyone who is lucky enough to accept him as a coder! He really knows what he is doing and is very fast!', '2009-12-22 16:38:45'),
(21, 'Dave Blaker', '', 'Dave Blaker Graphics', 'http://www.daveblaker.com/', 'United States', 'happycoder stuck with me even after the main part of the project was over. I altered some of his code by mistake, and he helped me fix it with no problem. Project was completed exactly as I needed. I will happily work with him again...', '2009-12-21 19:04:09'),
(22, 'IT Web', '', '', '', 'Arizona, United States', 'He did an osCommerce project for us.. He is a pro all around, great to work with.', '2009-12-22 16:00:04'),
(23, 'JR Steve', '', '', '', 'United States', 'Great programmer. I left out some important info that affected his script, but he still adjusted the script for me and had it working within minutes. I''ll be inviting him to more projects.', '2009-12-22 16:00:04'),
(24, 'Matt', '', '', '', 'United States', 'Great job, fixed all issues as outlined in the project. Will work together again.', '2009-12-22 16:09:08'),
(25, 'Joshua Loader', '', 'DL Software', 'http://forums.dlsoftware.net/', 'United Kingdom', 'I''ve used this programmer on many projects and what really suprises me is I don''t seem to have a challenge big enough to really test Rupom''s skills, no matter what I throw at him he always seems to deliver the product on time, with documentation and a outstanding attitude towards his work. Rupom goes way beyond the requirements of a professional programmer. Words cannot describe how talented he really is. Thanks again Rupom for a wonderful product!', '2009-12-22 16:09:08'),
(26, 'Tom Starkie', '', '', '', 'United Kingdom', 'Worked well and made sure my work was completed and fully functioning before payment. Will definatly use again and recommend to anyone!', '2009-12-22 16:17:21'),
(27, 'Barry Looker', '', '', '', 'United Kingdom', 'Very knowledgeable & helpful coder, he understood the complex mod_rewrite problem quickly and found a solution enabling us to open the site, well done Rupom!', '2009-12-22 16:17:21'),
(28, 'WickedFire (Nickname)', '', '', '', 'Los Angeles, CA, United States', 'Awesome job done on the twitter script, Rupom always does exactly what is needed even without asking. Great programmer and nice person. A+ all around. Highly recommended...', '2009-12-22 16:37:30'),
(29, 'Mohammad Habibur', '', '', '', 'Prince George, Canada', 'I found Rupom exceptionally professional and customer oriented programmer. He listened to my problems and provided me efficient and cost effective solutions. Rupom built a programming based interface as part of one of my projects. He supplied me the product on time and according to my requirements. I am fully satisfied with his service and looking forward to involve him in my future projects.', '2009-12-22 18:45:08'),
(30, 'S. Robertson', 'CEO', 'Netservice', 'http://www.netservice.se', 'Sweden', 'Our company have been outsourcing web development to OS Clicks on multiple projects for the last 9 months.\r\n\r\nOur initial project was completed within a demanding time frame and beyond expectations.\r\n\r\nThe professional services of Rupom and his team outshine any previous developer we have worked with, communication is easy, comprehension outstanding and implementation an ease.\r\n\r\nAs our demands have become more complex OS Clicks rise to meet the challenge, we look forward to a long and prosperous partnership in the future and warmly recommend their services to other companies.', '2010-01-04 19:25:45');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
