Partage

Erreur syntaxe mysql

Sujet résolu
Le 20 juin 2011 à 13:34:12

Bonjour a tous, j'ai acheter 1 script de site internet et j'ai 1 erreur avec la base de donée :
Base de donnée
-- phpMyAdmin SQL Dump

-- version 2.6.3-pl1

-- http://www.phpmyadmin.net

-- 

-- Host: localhost

-- Generation Time: Sep 21, 2005 at 07:22 PM

-- Server version: 4.0.25

-- PHP Version: 4.3.11

-- 

-- Database: `articlesite_art`

-- 



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



-- 

-- Table structure for table `article_master`

-- 



CREATE TABLE `article_master` (

  `article_id` bigint(20) NOT NULL auto_increment,

  `article_user_id` int(11) NOT NULL default '0',

  `article_author` varchar(100) NOT NULL default '',

  `article_snippet` varchar(255) NOT NULL default '',

  `article_summary` text NOT NULL,

  `article_title` varchar(100) NOT NULL default '',

  `article_category_id` int(11) NOT NULL default '0',

  `article_views` bigint(20) NOT NULL default '0',

  `article_status` int(11) NOT NULL default '1',

  `article_date` date NOT NULL default '0000-00-00',

  `article_home_page` int(11) NOT NULL default '0',

  `article_email` int(11) NOT NULL default '0',

  PRIMARY KEY  (`article_id`)

) TYPE=MyISAM AUTO_INCREMENT=6 ;



-- 

-- Dumping data for table `article_master`

-- 



INSERT INTO `article_master` VALUES (1, 0, 'Michael Nicholas', 'Have you ever gotten caught on a slippery road and felt the wheels under you spinning and going nowhere?\r\n\r\nWell, you don''t really need to be in a car to know what I''m talking about because this scene has been played out metaphorically many times as well.', '(c) By Michael Nicholas\r\n\r\nHave you ever gotten caught on a slippery road and felt the wheels under you spinning and going nowhere?\r\n\r\nWell, you don''t really need to be in a car to know what I''m talking about because this scene has been played out metaphorically many times as well.\r\n\r\nIt''s the feeling of not getting to your destination and it''s an unpleasant result... Spinning your wheels is being out of control and getting nowhere while trying to get somewhere.\r\n\r\nAnd when you apply this to reaching success it''s not only frustrating, but it can also crush your spirit to move on and upward.\r\n\r\nBut let me tell you a secret of success that is in every revolution of a spinning wheel. This is something that is difficult to see while you are trying to navigate toward success.\r\n\r\nIt''s like a thick fog or night blindness and it wants to throw you off course so you lose your way. It''s a false/positive state of mind that wants to lead you down the wrong road to failure where you may easily think it''s time to give up. After all it''s quite easy to stop the engine and park it...\r\n\r\nBUT... wait a minute... What if all the while your wheels were turning you were moving toward success little by little and didn''t realize it? What if you were moving in revolutions that didn''t feel like you were moving at all but you really were?...\r\n\r\nAnd what if you didn''t stop your wheels from spinning BUT kept them going in that same very direction you set out on?... Well this is the road to success, my friend, and YOU are on it...\r\n\r\nAt first being on the road to success may feel like you are going nowhere... This is where the weak give up and move to something else many times repeating the scenario over and over never getting anywhere.\r\n\r\nThey just think they are spinning their wheels and give up way too early. But if you have a goal you want to accomplish... something you really feel strong and dedicated about - don''t yield to the false/positive feelings of failure.\r\n\r\nWhy? Because the feelings of failure WILL come greet you... That you can be sure of. But pay no mind to failure because it''s not a reality unless you accept it. Many times it''s only the fear of failure - so just ignore it.\r\n\r\nThese feelings are just part of the journey leading to your success. However, if you keep on driving toward your goal without taking your eyes off of the road, but stay put even when things look, feel and taste like a losing battle... Your reward for riding through the storm is SUCCESS.\r\n\r\nAnd yes it''s been there the whole time... but this destination does not come easy to those that give up.\r\n\r\nRemember this... \r\n\r\nWhen it looks like nothing is happening... look again, give it time and even more time... Then when you have stayed the course your journey requires... that''s when success is right around the corner.\r\n\r\nTherefore, one of the real secrets of success is when it doesn''t seem like success... it can still very much be you are on a successful journey leading right to it.\r\n\r\nSo don''t cut yourself off and just spin your wheels... Spin Your Wheels To SUCCESS! \r\n\r\nMichael Nicholas publishes his weekly newsletter, Success Triggers, featuring tips for online marketers worldwide. If you want to trigger your online success, come join Michael and receive FREE gifts that can help boost your online marketing starting today. ===> http://www.SuccessTriggers.com', 'Spin Your Wheels To SUCCESS!', 205, 5, 1, '0000-00-00', 1, 0);

INSERT INTO `article_master` VALUES (2, 0, 'Jeff Schuman', 'An email automatic responder or autoresponder is the second most important marketing tool I have to make money online. The first would be my hosting company. Without these 2 tools my internet marketing business is dead in the water.', 'An email automatic responder or autoresponder is the second most important marketing tool I have to make money online. The first would be my hosting company. Without these 2 tools my internet marketing business is dead in the water. \r\n\r\nIn the world of internet marketing, millions of sites are fiercely competing with each other to gain new clients. For any ecommerce site to succeed, it must capture the interest and the trust of its visitors. It is not enough that your site is perfectly designed or has the latest in animation of content. \r\n\r\nYou should focus your efforts not only in attracting visitors but also in leading them to make a purchase. There are dozens of marketing strategies you can use to attract more buyers and pump up your sales. One of them is by establishing an excellent and professional reputation for prompt and efficient response.\r\n\r\nAs more potential customers visit your site, you should expect a flood of inquiries and requests for information. This is an excellent opportunity for you to capture more clients and lead them to buying from your site. Thus, it is important that you carry out an efficient and prompt response to every email you receive. The fastest and most effective way to do this is by utilizing an email automatic responder. \r\n\r\nAutoresponder services use a computer program that automatically return a prewritten message to anyone who sends an email to your site. It is widely used for responding to consumer inquiries and visitor comments and suggestions. \r\n\r\nFollow up automatic responders are also used by e-zines in responding to people who subscribe or unsubscribe to their online magazines. Companies, who send out their e-newsletter regularly, also use utoresponders. \r\n\r\nHow can effective autoresponder services help boost your business? The answer lies in its ability to return a prompt response to any e-mail the site receives. By responding rapidly and efficiently, you create a very good impression on your potential customer. Good email autorespondrs help you get important information back to these customers immediately. An effective autoresponder service helps you communicate your message promptly, creating a sense of professionalism and efficiency that your clients will definitely appreciate. \r\n\r\nAnother very important advantage of email automatic responders is that it saves time with multiple marketing tasks. Certainly, you do not have enough time to personally make and send all correspondence. Autoresponder services allows you to send thank you letters, newsletters, product information, brochures, orders etc. to hundreds of clients almost immediately and simultaneously. Autoresponder services are also indispensable in any email marketing campaign. \r\n\r\nChoosing the right autoresponder is very important. What makes the best automatic responder? First, you should pick an autoresponder that is reliable and can give you 24/7 service. You cannot afford to lose a customer because your autoresponder failed to answer his query or request for information. The ability to respond promptly is the first thing you must look for in any automatic responder. \r\n\r\nAnother key factor you should consider when choosing Autoresponder servcies is flexibility. Good autoresponders allow you to customize unique responses that will have maximum effect on the customer. You should avoid creating an impression that the customer is communicating with a machine instead of a real human being. \r\n\r\nAn excellent email automatic responder lets you provide the information that is specifically targeted for what the potential customers are looking for. Because any email from potential customers essentially represent the customer''s intent on getting more information about your product, which can ultimately lead to direct sales, all emails are important. Thus, a top Autoresponder servcie must fulfill all these duties to help you boost your business.\r\n\r\nFor all of our autoresponder needs we prefer Aweber. They are very reasonably priced and have proved to be reliable and easy to use.\r\n\r\n\r\n\r\nTeam-Schuman.Com contains the best make money online and make money websites available today. If you want to make money check us out here: http://www.team-schuman.com/email-automatic-responder.html', 'How I Use Email Automatic Responders', 128, 5, 1, '0000-00-00', 1, 0);

INSERT INTO `article_master` VALUES (3, 0, 'Evelyn Lim', 'Selecting the correct keywords can make or break your website. Potential customers search the web for desired sites, and if your website doesn''t have the keywords they''re looking for, they''ll miss you.', 'Selecting the correct keywords can make or break your website. Potential customers search the web for desired sites, and if your website doesn''t have the keywords they''re looking for, they''ll miss you.\r\n\r\nDetermining keywords is an art; it''s best to work backwards. What would a customer search for if they were looking for your site? You literally have to put yourself in the consumer''s place and let go of your preconceived notions about what you think your keywords are. You should remember when writing your site that you need to use words that are not only related to your content, but are popular search words as well. This is called keyword optimization, or choosing the most searched keywords related to your content.\r\n\r\nSpend some time listing all of the words and phrases that are related to your website content. Get ideas from everyone you can think of and list them all. Visit competitors'' sites and see what meta tags they use. After this research, you are ready to develop your own keyword phrases.\r\n\r\nThere are several sites designed to assist you in keyword optimization. Here are a few of the free ones:-\r\n\r\nThe Overture Keyword Tool (http://www.inventory.overture.com ) lists searches related to the keyword you provide. This took is great for expanding your list.\r\n\r\nWordtracker (http://www.wordtracker.com) helps identify keywords that will help your ranking on search engines. Wordtracker also gives you other keyword combinations that you may have overlooked.\r\n\r\nThe Keyword Tumbler (http://www.keywordtumbler.com) takes your existing keyword phrases and mixes it up to form new phrases and variations that you can include in your meta tags.\r\n\r\nA great website is not so great if no one finds it. Remember to research your keywords carefully from the consumer''s viewpoint and then sit back and watch the traffic roll in!\r\n\r\n\r\n\r\nEvelyn Lim is a publisher of the popular newsletter "Mapping You to Success" aimed at the aspiring home based internet business owner. She also hopes to educate her readers on acquiring multiple sources of online income. Please visit her site at http://www.e-BizMap.com for more information.', 'How To Select Keywords For Search Engine Optimization', 137, 1, 1, '0000-00-00', 1, 0);

INSERT INTO `article_master` VALUES (4, 0, 'Andrew Daum', 'The Google AdSense program is like finding money in the street. \r\n\r\nKids in High School are making thousands of dollars a month with Adsense... Housewives, Retiree''s, Mom and Pop''s who''ve never made a dime on the Internet have created full time incomes by', 'The Google AdSense program is like finding money in the street. \r\n\r\nKids in High School are making thousands of dollars a month with Adsense... Housewives, Retiree''s, Mom and Pop''s who''ve never made a dime on the Internet have created full time incomes by simply placing AdSense Ads on their web site or blog.\r\n\r\nThen you have the "Super AdSense" earners. We have all heard of them... the Elite few who are on track to make half a million dollars a year or more promoting AdSense sites. \r\n\r\nDo not be mistaken though... these people are not building like your Mom and Pop''s do. They have systems in place that create sites for them... people who build sites for them... they have outsourced and automated many of the tedious tasks such as posting to blogs and searching for keywords. \r\n\r\nWhile most people cannot emulate everything these Super AdSense earners do... many of them you can.\r\n\r\nHere are 7 Required Steps you can implement today to copy their success. \r\n\r\n1) Starting today... treat your AdSense business like it is a REAL business and track what you do.\r\n\r\nBegin tracking what you are doing that works... as well as what you are doing that does not work. This will keep you from making the same mistakes over and over, and you can repeat the steps that have worked in the past. As simple as this step seems... most people do not know the reason(s) to their success or failure. \r\n\r\n2) Utilize the latest tools and software available.\r\n\r\nThe Super AdSense earners are not any smarter than your average person. I know many people think they are... but for the most part, they are regular non techie people. \r\n\r\nThey are smarter in one respect though... they use the latest tools available to them to automate most of the tasks involved with researching and creating sites. They use the latest keyword, site creation and search engine optimization tools available. The tools they use are their secret weapons.\r\n\r\n3) Quit chasing the Mega Dollar keywords.\r\n\r\nYou cannot compete with the search engine experts who create sites for the $80 payout keywords. You may get lucky every now and then... but in the long run, you are better off building sites for the low to mid range payout keywords. The competition is less, and your chance of success is much higher over the long term.\r\n\r\n4) Choose broad niches and break it down.\r\n\r\nChoose a broad subject as your main theme (lets use computers for an example). From there... break it down into as many sub niches as possible. \r\n\r\nUsing Computers as the example... you could build sub niches/sites like laptop computers, computer hard drives, computer keyboards, etc, etc. You could literally build hundreds of sites around one major theme and stay totally focused. Once you have exhausted every possible sub niche of that major theme... choose another main theme and repeat the process.\r\n\r\n5) KISS\r\n\r\nKeep your sites easy to navigate and forget the fancy graphics that distract your visitors attention. Unless you are just building AdSense sites for the fun of it and to impress your friends... the purpose of having the site is to have people click on one of the ads, right? Then keep the site layout simple... dump the scrolling banners, dancing chickens and colored scroll bars... they are distractions.\r\n\r\n6) What is the purpose of your web site?\r\n\r\nYour web site cannot be everything to everybody. If you have a full fledged ecommerce site, with products for sale... links to other products, it is not a good site for AdSense. If the primary focus of the site is to sell products... let it do that. \r\n\r\nDo not distract or confuse your visitor with to many options or choices. The best AdSense sites are AdSense only content sites that sell nothing. They are sites that "Tell"... not "Sell."\r\n\r\n7) Be consistent.\r\n\r\nThis is not one of those deals where you build one site and you are done. Refer back to Step #4. You must continuously build in order to be successful. \r\n\r\nThink of it as planting a crop that you will harvest in a month or two, and the sites you build are seeds. Once the seeds have grown and matured... you will reap the harvest. The more seeds you plant... the larger the harvest.\r\n\r\nTo sum it up... utilize the tools available to automate as much of the process of building sites - doing research and building keyword lists as you can. This alone will help keep you organized and on track. Be consistent in building... treat it like the business it is and you will reap the rewards of your harvest.\r\n\r\n\r\n\r\nAndrew Daum is the Publisher of the New Traffic Tools Newsletter. You can subscribe by visiting his web site at; http://www.newtraffictools.com and receive updates when the latest to be released traffic building software is available.', '7 Steps Of Mega Adsense Earners', 206, 54, 1, '0000-00-00', 1, 0);

INSERT INTO `article_master` VALUES (5, 0, 'Cat Tobin', 'The Common Misconception: Auto auctions are only open to car dealers. \r\n\r\nThe Surprising Truth: Anyone with the right resources can participate in the same auctions as the dealers!', 'The Common Misconception: Auto auctions are only open to car dealers. \r\n\r\nThe Surprising Truth: Anyone with the right resources can participate in the same auctions as the dealers! \r\n\r\nThink about it. How much could you save if you bypassed the dealers and purchased directly from their sources? 30%, 50%, maybe even 75%. \r\n\r\nAs unbelievable as this sounds, it is possible with a little patience and research. \r\n\r\nAs you probably already know from past experience, car dealers will do ANYTHING to get you into the car of your dreams. Whether you can afford it or not! \r\n\r\nI can recall a former coworker who got into a new luxury vehicle with a little "creative financing." The manager divided his mortgage payment in two. His justification: As a married man his wife was responsible for the other half of the mortgage....even though she was a stay at home mom! Luckily for them, they found a way to pay their huge car payment and avoid repossession. \r\n\r\nUnfortunately, others aren''t quite as lucky. Thousands of people default on their loans everyday simply because they couldn''t really afford it in the first place. \r\n\r\nThis can work to your advantage. The banks and financial institutions that serviced the loans want to recoup their loss as quicly as possible. Add to that the exhorbitant cost of storing these vehicles, and you can easily see why the banks want to dispose of them in a timely manner. \r\n\r\nAfter all, the longer financial institutions have to store these vehicles, the less money they''re going to get back. \r\n\r\nAuto auctions are the quickest way for banks to rid themselves of repossessed vehicles. \r\n\r\nCar dealers know this, and they go to great lenghts to protect this knowledge from the general public. After all, auto auctions are a huge source of revenue. Dealers can purchase vehicles at a fraction of their value, and then resell them at a huge mark-up. \r\n\r\nBut what if you could avoid the dealer''s mark-up and instead pay what they pay? What impact would that have on your wallet? \r\n\r\nAmazingly enough, auto auctions are not solely restricted to car dealers. Up until a few years ago, I too shared this common misconception. \r\n\r\nIt was only by sheer luck that I stumbled upon a website that allowed me to search local auctions by zip code and vehicle make that I learned the surprising truth. I was paying dealers thosands of dollars in unnecessary mark-ups. \r\n\r\nI tried the website''s search feature out, and to my surprise the cars listed were exactly what I wanted. Only a few years old with very low miles. Many of them were still under the manufacturer''s original warranty! This made sense of course, since most of them were repossessions. \r\n\r\nThe auction house was even willing to throw in a vehicle history report at no extra cost and a 3 month warranty. \r\n\r\nSure I wouldn''t get the complimentary car washes and oil changes the dealer throws in, but that surely wasn''t worth thousands of dollars in premiums. \r\n\r\nAfter a little hesitation I joined the auto auction membership site. They helped me locate auto auctions in my area, and gain admission to them through their exclusive access rights. I learned what questions to ask, and how to handle the bidding process. \r\n\r\nIt was a lot simpler then I ever imagined it could be. \r\n\r\nThe day of the auction, I showed up a few hours early to inspect the vehicle I was interested in and get a feel for the place. \r\n\r\nIt must have been a slow day, because when my car came up for auction only a few dealers were bidding against me. Since I wasn''t buying the vehicle for resale, I succeeded in outbidding the dealers! \r\n\r\nIt was a truely empowering experience. I got the vehicle of my dreams, and I only paid a little over half its book value! \r\n\r\nWhat did this experience teach me? Auto Auctions can save you thousands in unnecessary dealer mark-ups. \r\n\r\nAuthor Cat Tobin \r\n\r\nHow Much Could You Save With Auto Auctions? \r\n\r\nBegin Your Local Auto Auction Search at: http://www.autoauctionfinder.com/search \r\n\r\n(c)autoauctionfinder.com \r\n\r\n** Attn Ezine Editors & Site Owners ** \r\n\r\nYou may reprint this article in its entirety so long as you do not modify the content or resource box.', 'Save Thousands at Auto Auctions - Without Marrying a Car Dealer!', 196, 5, 1, '0000-00-00', 1, 0);



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



-- 

-- Table structure for table `category_master`

-- 



CREATE TABLE `category_master` (

  `category_id` int(11) NOT NULL auto_increment,

  `category_name` varchar(100) NOT NULL default '',

  `category_parent_id` int(11) NOT NULL default '0',

  `category_status` int(11) NOT NULL default '1',

  `category_description` varchar(255) NOT NULL default '',

  `category_articles_count` int(11) NOT NULL default '0',

  `category_level` int(11) NOT NULL default '0',

  PRIMARY KEY  (`category_id`)

) TYPE=MyISAM AUTO_INCREMENT=207 ;



-- 

-- Dumping data for table `category_master`

-- 



INSERT INTO `category_master` VALUES (1, 'Articles', 0, 1, '', 0, 0);

INSERT INTO `category_master` VALUES (2, 'Arts & Entertainment', 1, 1, 'Here you can find articles related to Arts & entertainment.We also have several Sub categories in this field which are shown below....', 0, 1);

INSERT INTO `category_master` VALUES (3, 'Celebrities', 2, 1, 'aa', 0, 2);

INSERT INTO `category_master` VALUES (4, 'Business', 1, 1, 'Here you can find articles related to business,finance & economy.We also have several Sub categories in this field which are shown below....', 0, 1);

INSERT INTO `category_master` VALUES (20, 'Entrepreneurs', 4, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (7, 'Humanities', 2, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (8, 'Humor', 2, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (9, 'Movies', 2, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (10, 'Music', 2, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (16, 'Advertising', 4, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (12, 'Poetry', 2, 1, '', 0, 3);

INSERT INTO `category_master` VALUES (19, 'Customer Service', 4, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (17, 'Article Marketing', 4, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (18, 'Careers', 4, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (21, 'Ethics', 4, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (22, 'Home Based Business', 4, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (23, 'Management', 4, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (24, 'Marketing', 4, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (25, 'Networking', 4, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (26, 'Public Relations', 4, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (27, 'Sales', 4, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (28, 'Small Business', 4, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (29, 'Communications', 1, 1, '', 0, 1);

INSERT INTO `category_master` VALUES (30, 'Computers', 1, 1, '', 0, 1);

INSERT INTO `category_master` VALUES (31, 'Disease & Illness', 1, 1, '', 0, 1);

INSERT INTO `category_master` VALUES (32, 'Fashion', 1, 1, '', 0, 1);

INSERT INTO `category_master` VALUES (33, 'Finance', 1, 1, '', 0, 1);

INSERT INTO `category_master` VALUES (34, 'Food & Beverage', 1, 1, '', 0, 1);

INSERT INTO `category_master` VALUES (35, 'Health & Fitness', 1, 1, '', 0, 1);

INSERT INTO `category_master` VALUES (36, 'Home & Family', 1, 1, '', 0, 1);

INSERT INTO `category_master` VALUES (37, 'Internet Business', 1, 1, '', 0, 1);

INSERT INTO `category_master` VALUES (38, 'Politics', 1, 1, '', 0, 1);

INSERT INTO `category_master` VALUES (39, 'Product Reviews', 1, 1, '', 0, 1);

INSERT INTO `category_master` VALUES (40, 'Recreation & Sports', 1, 1, '', 0, 1);

INSERT INTO `category_master` VALUES (41, 'Reference & Education', 1, 1, '', 0, 1);

INSERT INTO `category_master` VALUES (42, 'Self Improvement', 1, 1, '', 0, 1);

INSERT INTO `category_master` VALUES (43, 'Society', 1, 1, '', 0, 1);

INSERT INTO `category_master` VALUES (44, 'Travel & Leisure', 1, 1, '', 0, 1);

INSERT INTO `category_master` VALUES (45, 'Vehicles', 1, 1, '', 0, 1);

INSERT INTO `category_master` VALUES (46, 'Writing & Speaking', 1, 1, '', 0, 1);

INSERT INTO `category_master` VALUES (47, 'Broadband Internet', 29, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (48, 'GPS', 29, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (49, 'Mobile Phones', 29, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (50, 'Satellite Radio', 29, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (51, 'Satellite TV', 29, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (52, 'Video Conferencing', 29, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (53, 'VOIP', 29, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (54, 'Computer Certification', 30, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (55, 'Data Recovery', 30, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (56, 'Games', 30, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (57, 'Hardware', 30, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (58, 'Networks', 30, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (59, 'Software', 30, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (60, 'Breast Cancer', 31, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (61, 'Colon Cancer', 31, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (62, 'Leukemia', 31, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (63, 'Mesothelioma', 31, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (64, 'Multiple Sclerosis', 31, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (65, 'Ovarian Cancer', 31, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (66, 'Prostate Cancer', 31, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (67, 'Skin Cancer', 31, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (68, 'Clothing', 32, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (69, 'Jewelry', 32, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (70, 'Shoes', 32, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (71, 'Credit', 33, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (72, 'Currency Trading', 33, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (73, 'Debt Consolidation', 33, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (74, 'Fundraising', 33, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (75, 'Insurance', 33, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (76, 'Investing', 33, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (77, 'Leasing', 33, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (78, 'Loans', 33, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (79, 'Mortgage', 33, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (80, 'Mutual Funds', 33, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (81, 'Personal Finance', 33, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (82, 'Real Estate', 33, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (83, 'Stock Market', 33, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (84, 'Taxes', 33, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (85, 'Coffee', 34, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (86, 'Cooking', 34, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (87, 'Gourmet', 34, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (88, 'Recipes', 34, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (89, 'Wine', 34, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (90, 'Acne', 35, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (91, 'Alternative Medicine', 35, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (92, 'Beauty', 35, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (93, 'Cardio', 35, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (94, 'Depression', 35, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (95, 'Diabetes', 35, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (96, 'Exercise', 35, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (97, 'Fitness Equipment', 35, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (98, 'Hair Loss', 35, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (99, 'Medicine', 35, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (100, 'Meditation', 35, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (101, 'Men Issues', 35, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (102, 'Muscle Building', 35, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (103, 'Nutrition', 35, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (104, 'Supplements', 35, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (105, 'Weight Loss', 35, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (106, 'Women Issues', 35, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (107, 'Yoga', 35, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (108, 'Babies', 36, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (109, 'Crafts', 36, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (110, 'Elderly Care', 36, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (111, 'Gardening', 36, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (112, 'Hobbies', 36, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (113, 'Holidays', 36, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (114, 'Home Improvement', 36, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (115, 'Home Security', 36, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (116, 'Interior Design', 36, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (117, 'Landscaping', 36, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (118, 'Parenting', 36, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (119, 'Pets', 36, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (120, 'Pregnancy', 36, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (121, 'Affiliate Programs', 37, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (122, 'Auctions', 37, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (123, 'Audio-Video Streaming', 37, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (124, 'Blogging', 37, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (125, 'Domains', 37, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (126, 'Ebooks', 37, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (127, 'Ecommerce', 37, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (128, 'Email Marketing', 37, 1, '', 1, 2);

INSERT INTO `category_master` VALUES (129, 'Ezine Marketing', 37, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (130, 'Ezine Publishing', 37, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (131, 'Forums', 37, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (132, 'Internet Marketing', 37, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (133, 'Podcasts', 37, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (134, 'PPC Advertising', 37, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (135, 'RSS', 37, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (136, 'Security', 37, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (137, 'SEO', 37, 1, '', 1, 2);

INSERT INTO `category_master` VALUES (138, 'Site Promotion', 37, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (139, 'Spam', 37, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (140, 'Traffic Generation', 37, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (141, 'Web Design', 37, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (142, 'Commentary', 38, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (143, 'Current Events', 38, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (144, 'History', 38, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (145, 'Book Reviews', 39, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (146, 'Consumer Electronics', 39, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (147, 'Digital Products', 39, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (148, 'Movie Reviews', 39, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (149, 'Music Reviews', 39, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (150, 'Biking', 40, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (151, 'Extreme', 40, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (152, 'Fishing', 40, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (153, 'Gambling & Casinos', 40, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (154, 'Golf', 40, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (155, 'Hunting', 40, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (156, 'Martial Arts', 40, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (157, 'Running', 40, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (158, 'College', 41, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (159, 'Homeschooling', 41, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (160, 'K-12 Education', 41, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (161, 'Language', 41, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (162, 'Philosophy', 41, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (163, 'Psychology', 41, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (164, 'Science', 41, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (165, 'Sociology', 41, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (166, 'Attraction', 42, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (167, 'Coaching', 42, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (168, 'Creativity', 42, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (169, 'Goal Setting', 42, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (170, 'Grief', 42, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (171, 'Happiness', 42, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (172, 'Innovation', 42, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (173, 'Inspirational', 42, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (174, 'Leadership', 42, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (175, 'Motivation', 42, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (176, 'Organizing', 42, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (177, 'Spirituality', 42, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (178, 'Stress Management', 42, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (179, 'Success', 42, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (180, 'Time Management', 42, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (181, 'Dating', 43, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (182, 'Divorce', 43, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (183, 'Marriage', 43, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (184, 'Relationships', 43, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (185, 'Religion', 43, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (186, 'Sexuality', 43, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (187, 'Weddings', 43, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (188, 'Aviation', 44, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (189, 'Boating', 44, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (190, 'Cruises', 44, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (191, 'Destinations', 44, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (192, 'Outdoors', 44, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (193, 'Travel Tips', 44, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (194, 'Vacations', 44, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (195, 'Boats', 45, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (196, 'Cars', 45, 1, '', 1, 2);

INSERT INTO `category_master` VALUES (197, 'Motorcycles', 45, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (198, 'RVs', 45, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (199, 'Trucks-SUVS', 45, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (200, 'Article Writing', 46, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (201, 'Book Marketing', 46, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (202, 'Copywriting', 46, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (203, 'Public Speaking', 46, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (204, 'Writing', 46, 1, '', 0, 2);

INSERT INTO `category_master` VALUES (205, 'ISP''s', 37, 1, 'Everything about your Internet Service Provider', 1, 2);

INSERT INTO `category_master` VALUES (206, 'Adsense', 37, 1, 'Making money with the Google Adsense Program', 1, 2);



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



-- 

-- Table structure for table `document_master`

-- 



CREATE TABLE `document_master` (

  `id` int(11) NOT NULL auto_increment,

  `doc_title` varchar(255) NOT NULL default '',

  `doc_content` text NOT NULL,

  PRIMARY KEY  (`id`)

) TYPE=MyISAM AUTO_INCREMENT=23 ;



-- 

-- Dumping data for table `document_master`

-- 



INSERT INTO `document_master` VALUES (17, 'Submission Guildlines', '\r\n<P><FONT style="BACKGROUND-COLOR: #ff0000" color=#000000></FONT><FONT face=Arial size=2></FONT>&nbsp;<STRONG>This can be edited in admin panel.</STRONG></P>\r\n<P><FONT face=Arial size=2>The rules for submitting your articles to website are simple, but they must be followed! </FONT>\r\n<LI><FONT face=Arial><FONT size=2><B>The articles that you submit must be your own work -</B> You may not submit articles written by other authors and the content must be unique. No rebranded articles allowed, you must be the sole copyright holder for each article you submit. Articles written by a ghost writer are perfectly acceptable as long as they are being used only by yourself. </FONT></FONT>\r\n<LI><FONT face=Arial><FONT size=2><STRONG>By submitting your articles to Article </STRONG>website<STRONG>, you grant us the right to publish your articles -</STRONG> We may publish your article anywhere on our website, blog, or syndicate through RSS. We may also change where it appears, including the category, at any time. </FONT></FONT>\r\n<LI><FONT face=Arial><FONT size=2><STRONG>By submitting your articles to Article </STRONG>website <STRONG>, you grant others the right to publish your articles -</STRONG> Other Article website users have the right to publish your articles on their websites, in their newsletters or ezines, and more as long as the article is left in the original state. This includes the resource box which provides you credit as the author of the content. </FONT></FONT>\r\n<LI><FONT face=Arial><FONT size=2><B>No affiliate links! -</B> The articles that you submit to Article Dashboard should not contain affiliate links. It is acceptable, however, to mention the URL''s of helpful sites or your own website which redirects to the recommended affiliate product. </FONT></FONT>\r\n<LI><FONT face=Arial><FONT size=2><STRONG>Submitting your articles to Article </STRONG>website <STRONG>does not entitle you to financial compensation of any kind -</STRONG> You will not receive compensation from website .com or the users of our directory for articles you submit. </FONT></FONT>\r\n<LI><FONT face=Arial><FONT size=2><B>Submitting an article in no ways guarantees inclusion in our directory -</B> We reserve the right to reject an article submission for any reason. </FONT></FONT>\r\n<LI><FONT face=Arial><FONT size=2><B>Articles must be spellchecked and proof read for grammatical errors prior to submitting -</B> Do not submit articles filled with spelling errors and bad grammar. We do monitor article submissions and we will reject content that doesn''t meet this requirement.</FONT></FONT></LI>');

INSERT INTO `document_master` VALUES (18, 'rss', '<SPAN class=mainContentBold><STRONG>&nbsp; This can be edited in admin panel. \r\n<P><SPAN class=mainContentBold><STRONG>How To use RSS on this Website?</STRONG></SPAN></P>\r\n<P>\r\n<TABLE class=mainContent cellSpacing=3 cellPadding=0 border=0>\r\n<TBODY>\r\n<TR>\r\n<TD width=15><IMG height=1 src="http://www.redherring.com/spacer.gif" width=15></TD>\r\n<TD vAlign=top>1.</TD>\r\n<TD vAlign=top>Put the mouse cursor over the RSS Icon and click.</TD></TR>\r\n<TR>\r\n<TD width=15><IMG height=1 src="http://www.redherring.com/spacer.gif" width=15></TD>\r\n<TD vAlign=top>2.</TD>\r\n<TD vAlign=top>Copy the RSS News Feed URL to the clipboard or write down the URL.</TD></TR>\r\n<TR>\r\n<TD width=15><IMG height=1 src="http://www.redherring.com/spacer.gif" width=15></TD>\r\n<TD vAlign=top>3.</TD>\r\n<TD vAlign=top>In the RSS News Reader Application, follow their instructions for creating a RSS News Feed by specifying the URL recorded from Step 2. Some News Reader applications will allow you to paste the URL feed from the Clipboard.</TD></TR></TBODY></TABLE></STRONG></SPAN><SPAN class=mainContentBold><STRONG>What is RSS?</STRONG></SPAN><BR>Really Simple Syndication (RSS) is an XML-based format for content distribution that includes headlines, summaries and links. RSS-aware programs called news aggregators, also known as news readers or RSS readers, enable you to get the latest headlines, in RSS format, delivered straight to your desktop. </P>\r\n<P><SPAN class=mainContentBold><STRONG>Why use RSS feeds and readers?</STRONG></SPAN><BR>As a player in the industry, you need information fast and effective. RSS and news readers bring you the whats new headlines, descriptions and links for all your favorite RSS-friendly websites directly to your desktop. News readers are set to check for new content periodically (usually every hour) so you can peruse the latest information, decide what you want to read, and then go directly to the articles. </P>\r\n<P><SPAN class=mainContentBold><STRONG>Where can I get an RSS Reader?</STRONG></SPAN><BR>There are a wide range of RSS Readers available for most operating systems, and many of them can be downloaded for free. Search news aggregator or RSS reader on Google or Yahoo to locate one to download. Generally, the process for setting up an RSS feed with your RSS Reader involves the following steps. Please refer to your specific RSS Readers instructions for configuring an RSS Feed. </P>');

INSERT INTO `document_master` VALUES (19, 'aboutus', 'About us will go here and can be edited in admin panel....');

INSERT INTO `document_master` VALUES (20, 'privacy', '\r\n<P><STRONG>This can be edited in admin panel.</STRONG></P>\r\n<P>Articlebeach.com strives to offer its visitors the many advantages of Internet technology and to provide an interactive and personalized experience. We may use Personally Identifiable Information (your name, e-mail address, street address, telephone number) subject to the terms of this privacy policy. We will never sell, barter, or rent your email address to any unauthorized third party. Period.</P>\r\n<P>How we gather information from users</P>\r\n<P>How we collect and store information depends on the page you are visiting, the activities in which you elect to participate and the services provided. For example, you may be asked to provide information when you register for access to certain portions of our site or request certain features, such as newsletters or when you make a purchase. You may provide information when you participate in sweepstakes and contests, message boards and chat rooms, and other interactive areas of our site. Like most Web sites, Articlebeach.com also collects information automatically and through the use of electronic tools that may be transparent to our visitors. For example, we may log the name of your Internet Service Provider or use cookie technology to recognize you and hold information from your visit. Among other things, the cookie may store your user name and password, sparing you from having to re-enter that information each time you visit, or may control the number of times you encounter a particular advertisement while visiting our site. As we adopt additional technology, we may also gather information through other means. In certain cases, you can choose not to provide us with information, for example by setting your browser to refuse to accept cookies, but if you do you may be unable to access certain portions of the site or may be asked to re-enter your user name and password, and we may not be able to customize the site''s features according to your preferences.</P>\r\n<P>What we do with the information we collect</P>\r\n<P>Like other Web publishers, we collect information to enhance your visit and deliver more individualized content and advertising. We respect your privacy and do not share your information with anyone.</P>\r\n<P>Aggregated Information (information that does not personally identify you) may be used in many ways. For example, we may combine information about your usage patterns with similar information obtained from other users to help enhance our site and services (e.g., to learn which pages are visited most or what features are most attractive). Aggregated Information may occasionally be shared with our advertisers and business partners. Again, this information does not include any Personally Identifiable Information about you or allow anyone to identify you individually.</P>\r\n<P>We may use Personally Identifiable Information collected on <A href="http://www.Articlebeach.com">www.Articlebeach.com</A> to communicate with you about your registration and customization preferences; our Terms of Service and privacy policy; services and products offered by <A href="http://www.Articlebeach.com">www.Articlebeach.com</A> and other topics we think you might find of interest.</P>\r\n<P>Personally Identifiable Information collected by Articlebeach.com may also be used for other purposes, including but not limited to site administration, troubleshooting, processing of e-commerce transactions, administration of sweepstakes and contests, and other communications with you. Certain third parties who provide technical support for the operation of our site (our Web hosting service for example) may access such information. We will use your information only as permitted by law. In addition, from time to time as we continue to develop our business, we may sell, buy, merge or partner with other companies or businesses. In such transactions, user information may be among the transferred assets. We may also disclose your information in response to a court order, at other times when we believe we are reasonably required to do so by law, in connection with the collection of amounts you may owe to us, and/or to law enforcement authorities whenever we deem it appropriate or necessary. Please note we may not provide you with notice prior to disclosure in such cases.</P>\r\n<P>Affiliated sites, linked sites and advertisements</P>\r\n<P>Articlebeach.com expects its partners, advertisers and affiliates to respect the privacy of our users. Be aware, however, that third parties, including our partners, advertisers, affiliates and other content providers accessible through our site, may have their own privacy and data collection policies and practices. For example, during your visit to our site you may link to, or view as part of a frame on a <A href="http://www.Articlebeach.com">www.Articlebeach.com</A> page, certain content that is actually created or hosted by a third party. Also, through Articlebeach.com you may be introduced to, or be able to access, information, Web sites, features, contests or sweepstakes offered by other parties. Articlebeach.com is not responsible for the actions or policies of such third parties. You should check the applicable privacy policies of those third parties when providing information on a feature or page operated by a third party.</P>\r\n<P>While on our site, our advertisers, promotional partners or other third parties may use cookies or other technology to attempt to identify some of your preferences or retrieve information about you. For example, some of our advertising is served by third parties and may include cookies that enable the advertiser to determine whether you have seen a particular advertisement before. Other features available on our site may offer services operated by third parties and may use cookies or other technology to gather information. Articlebeach.com does not control the use of this technology by third parties or the resulting information, and is not responsible for any actions or policies of such third parties.</P>\r\n<P>You should also be aware that if you voluntarily disclose Personally Identifiable Information on message boards or in chat areas, that information can be viewed publicly and can be collected and used by third parties without our knowledge and may result in unsolicited messages from other individuals or third parties. Such activities are beyond the control of Articlebeach.com and this policy. </P>\r\n<P>Children</P>\r\n<P>Articlebeach.com does not knowingly collect or solicit Personally Identifiable Information from or about children under 13 except as permitted by law. If we discover we have received any information from a child under 13 in violation of this policy, we will delete that information immediately. If you believe Articlebeach.com has any information from or about anyone under 13, please contact us at the address listed below.</P>\r\n<P>Contacting Us</P>\r\n<P>We can be reached by emailing us.</P>\r\n<P>Changes to this Policy</P>\r\n<P>Articlebeach.com reserves the right to change this policy at any time. Please check this page periodically for changes. Your continued use of our site following the posting of changes to these terms will mean you accept those changes. Information collected prior to the time any change is posted will be used according to the rules and laws that applied at the time the information was collected.</P>\r\n<P>Governing law</P>\r\n<P>This policy and the use of this Site are governed by Texas law. If a dispute arises under this Policy we agree to first try to resolve it with the help of a mutually agreed-upon mediator in the following location: Austin. Any costs and fees other than attorney fees associated with the mediation will be shared equally by each of us.</P>\r\n<P>If it proves impossible to arrive at a mutually satisfactory solution through mediation, we agree to submit the dispute to binding arbitration at the following location: Austin, under the rules of the American Arbitration Association. Judgment upon the award rendered by the arbitration may be entered in any court with jurisdiction to do so.</P>\r\n<P>This statement and the policies outlined herein are not intended to and do not create any contractual or other legal rights in or on behalf of any party.<BR></P>');

INSERT INTO `document_master` VALUES (21, 'contactus', '<STRONG>This can be edited in admin panel.</STRONG> \r\n<P>&nbsp;</P>\r\n<P>We wants to hear from you! We value your feedback, please <A href="mailto:feedback@articledbeach.com">contact us</A> with your comments and suggestions today!</P>');

INSERT INTO `document_master` VALUES (22, 'tos', '&nbsp; \r\n<P><STRONG>This can be edited in admin panel.</STRONG></P>\r\n<P>&nbsp;</P>\r\n<P>1. You agree that you are the original author of each article you submit. If you have hired a ghost writer, you agree that you have exclusive rights to each article you submit. 2. There are no guarantees that your articles will be accepted for publication in our directory. It is at our sole discretion whether or not to include your articles. If published, we reserve the right to remove any articles at any time. 3. We reserve the right to choose a more suitable category for your articles if we find them to be classified wrong. 4. By submitting your articles to <A href="http://www.Articlebeach.com">www.Articlebeach.com</A>, you agree to allow us to: <BR>Publish your article on <A href="http://www.Articlebeach.com">www.Articlebeach.com</A> and any of its article directory partners. <BR>Publish your article in RSS format for other websites to syndicate. <BR>Publish your article in our real time, daily, or weekly newsletters. 5. You agree that <A href="http://www.Articlebeach.com">www.Articlebeach.com</A> is a free service for authors and publishers. You will not be paid for submitting your articles to our sites. 6. You agree to not include any affiliate links in the body of your article. If you are trying to promote an affiliate program, please set up your own domain and link to it in your resource box. 7. <A href="http://www.Articlebeach.com">www.Articlebeach.com</A> may at any time translate your article into various languages for our sister sites. Your article will remain complete with your resource box. 8. We reserve the right to change these terms of service at any time. We will generally notify the community of changes via our site blog. 9. We reserve the right to include advertising on pages with your articles. <BR>Publisher Terms of Service</P>\r\n<P>1. You must not remove "Article Source: <A href="http://www.Articlebeach.com">http://www.Articlebeach.com</A>" from each article you choose to publish. 2. You must respect the copyright of each author whose articles you wish to publish. This includes but is not limited to 1. resource box, 2. any links provided by the author. 3. You must not change, edit, or reword any part of any article not written by you. 4. You must agree to keep hyperlinks "live" so that users can click on said link and be taken to it''s destination. 5. You agree to never use any articles obtained from <A href="http://www.Articlebeach.com">www.Articlebeach.com</A> in any form of spam or onsolicited mail. 6. You agree to not publish any articles on sites that contain hate, racist, warez, porn, or any other illegal material. 7. You agree to never sell any article obtained from our directory without written consent from the author. This includes selling articles individually or in a compilation. Disclaimer You agree to not hold <A href="http://www.Articlebeach.com">www.Articlebeach.com</A> or Ideafeeder, LLC liable for the accuracy of any article on any site controlled by Ideafeeder, LLC. <A href="http://www.Articlebeach.com">www.Articlebeach.com</A> is simply a hub for authors and publishers to meet. If you have an issue with someone stealing your original work, however, please contact us and we will remove the article in question immediately. <A href="http://www.Articlebeach.com">www.Articlebeach.com</A> does not endorse any author, website, or product mentioned in any articles not written by the Article beach team. All articles published by <A href="http://www.Articlebeach.com">www.Articlebeach.com</A> are not meant to be used for legal, medical, or any other type of advice. All articles are for informational purposes only. </P>');



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



-- 

-- Table structure for table `settings`

-- 



CREATE TABLE `settings` (

  `variable_id` int(11) NOT NULL default '0',

  `variable_value` text NOT NULL,

  `variable_name` varchar(255) NOT NULL default ''

) TYPE=MyISAM;



-- 

-- Dumping data for table `settings`

-- 



INSERT INTO `settings` VALUES (1, 'you@yourdomain.com', 'Webmaster Email');

INSERT INTO `settings` VALUES (2, 'ArticleBeach.com', 'Website Name');

INSERT INTO `settings` VALUES (3, 'http://www.articlebeach.com', 'Website Domain URL');

INSERT INTO `settings` VALUES (4, 'Dear XXXNAMEXXX,\r\nXXXNUMBERXXX Articles were submitted in last 24 hours on our website. You can get them here\r\nXXXLINKXXX\r\n\r\nWebmaster,\r\nXXXWEBSITEXXX', 'New Article Notify email to Users');

INSERT INTO `settings` VALUES (5, '0', 'Article Posting Require Admin Approval(enter 1 for yes and 0 for No)');

INSERT INTO `settings` VALUES (8, '<script type="text/javascript"><!--\r\ngoogle_ad_client = "pub-0569985490694469";\r\ngoogle_ad_width = 468;\r\ngoogle_ad_height = 60;\r\ngoogle_ad_format = "468x60_as";\r\ngoogle_ad_type = "text";\r\ngoogle_ad_channel ="";\r\ngoogle_color_border = "FFFFFF";\r\ngoogle_color_bg = "FFFFFF";\r\ngoogle_color_link = "0000FF";\r\ngoogle_color_url = "0066FF";\r\ngoogle_color_text = "000000";\r\n//--></script>\r\n<script type="text/javascript"\r\n  src="http://pagead2.googlesyndication.com/pagead/show_ads.js">\r\n</script>', 'Top Google Adsense Code');

INSERT INTO `settings` VALUES (6, 'Google,Yahoo,,AOL,MSN,SourceCodeBlowout.com,Other,From Friend', 'How you Hear about us');

INSERT INTO `settings` VALUES (7, 'Article Author,Publisher,Collecting Articles,others', 'You Primary Role on This website:');

INSERT INTO `settings` VALUES (9, '<center><a href="http://www.marketingtips.com/t.cgi/767631/">\r\n<img src="http://www.marketingtips.com/images/imc-48.gif" border="0"></a></center>\r\n', 'Bottom Ads');



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



-- 

-- Table structure for table `user_master`

-- 



CREATE TABLE `user_master` (

  `user_id` int(11) NOT NULL auto_increment,

  `first_name` varchar(255) NOT NULL default '',

  `last_name` varchar(255) NOT NULL default '',

  `email` varchar(255) NOT NULL default '',

  `user_name` varchar(255) NOT NULL default '',

  `password` varchar(255) NOT NULL default '',

  `user_type` int(11) NOT NULL default '2',

  `active` int(11) NOT NULL default '1',

  `user_hear` varchar(50) NOT NULL default '',

  `user_role` varchar(50) NOT NULL default '',

  `user_daily_email` int(11) NOT NULL default '0',

  PRIMARY KEY  (`user_id`)

) TYPE=MyISAM AUTO_INCREMENT=18 ;



-- 

-- Dumping data for table `user_master`

-- 



INSERT INTO `user_master` VALUES (1, 'admin', 'admin', 'as', 'admin', 'admin', 1, 1, '', '', 0);


J'ai l'erreur :

Citation : Phpmyadmin

requête SQL:

-- phpMyAdmin SQL Dump -- version 2.6.3-pl1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Sep 21, 2005 at 07:22 PM -- Server version: 4.0.25 -- PHP Version: 4.3.11 -- -- Database: `articlesite_art` -- -- -------------------------------------------------------- -- -- Table structure for table `article_master` -- CREATE TABLE `article_master` ( `article_id` bigint(20) NOT NULL auto_increment, `article_user_id` int(11) NOT NULL default '0', `article_author` varchar(100) NOT NULL default '', `article_snippet` varchar(255) NOT NULL default '', `article_summary` text NOT NULL, `article_title` varchar(100) NOT NULL default '', `article_category_id` int(11) NOT NULL default '0', `article_views` bigint(20) NOT NULL default '0', `article_status` int(11) NOT NULL default '1', `article_date` date NOT NULL default '0000-00-00', `article_home_page` int(11) NOT NULL default '0', `article_email` int(11) NOT NULL def[...]

MySQL a répondu: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM AUTO_INCREMENT=6' at line 33

Publicité
Le 20 juin 2011 à 13:34:12
Le 20 juin 2011 à 13:36:34

Remplace Type par Engine.
Ton script est probablement généré sur une vieille version de MySQL...
Le 20 juin 2011 à 13:42:31

Je vais esseyer merci :)

Erreur syntaxe mysql

× Après avoir cliqué sur "Répondre" vous serez invité à vous connecter pour que votre message soit publié.
  • Editeur
  • Markdown